migrations/Delete/Version20250901151243_QualityNCR.php line 1

  1. <?php
  3. declare(strict_types=1);
  5. namespace DoctrineMigrations\Delete;
  7. use App\Doctrine\Type\Expediting\CasingMaterial;
  8. use App\Doctrine\Type\Expediting\CasingType;
  9. use App\Doctrine\Type\Expediting\NonConformityStatus;
  10. use App\Doctrine\Type\Expediting\NonConformitySubject;
  11. use App\Doctrine\Type\Expediting\NonConformityType;
  12. use Doctrine\DBAL\Schema\Schema;
  13. use Doctrine\Migrations\AbstractMigration;
  15. /**
  16.  * Auto-generated Migration: Please modify to your needs!
  17.  */
  18. final class Version20250901151243_QualityNCR extends AbstractMigration
  19. {
  20.     public function getDescription(): string
  21.     {
  22.         return 'Add ops ncr';
  23.     }
  25.     public function up(Schema $schema): void
  26.     {
  27.         $this->addSql(NonConformitySubject::getRegistrationSQL());
  28.         $this->addSql(NonConformityType::getRegistrationSQL());
  29.         $this->addSql(NonConformityStatus::getRegistrationSQL());
  31.         $casingTypeType = CasingType::getName();
  32.         $casingMaterialType = CasingMaterial::getName();
  33.         $nonConformitySubject = NonConformitySubject::getName();
  34.         $nonConformityType = NonConformityType::getName();
  35.         $nonConformityStatus = NonConformityStatus::getName();
  37.         $this->addSql("CREATE TABLE non_conformity (
  38.             id                              SERIAL PRIMARY KEY,
  39.             ncr_id                          INTEGER                              REFERENCES public.non_conformity (id),
  40.             
  41.             slug                            CHARACTER VARYING           NOT NULL,
  42.             reference                       CHARACTER VARYING           NOT NULL,
  43.             subject_reference               CHARACTER VARYING,
  44.             invoices_numbers                CHARACTER VARYING,
  45.             orders_numbers                  CHARACTER VARYING,
  46.             line_items                      CHARACTER VARYING,
  47.             description                     CHARACTER VARYING,
  48.             supplier                        CHARACTER VARYING,
  49.             
  50.             casing_type                     {$casingTypeType},
  51.             casing_material                 {$casingMaterialType},
  52.             length                          DECIMAL(18, 3),
  53.             width                           DECIMAL(18, 3),
  54.             height                          DECIMAL(18, 3),
  55.             weight                          DECIMAL(18, 3),
  57.             subject_type                    {$nonConformitySubject}     NOT NULL,
  58.             type                            {$nonConformityType}        NOT NULL,
  59.             status                          {$nonConformityStatus}      NOT NULL,
  60.             
  61.             created_by                      INTEGER                              REFERENCES public.user (id),
  62.             updated_by                      INTEGER                              REFERENCES public.user (id),
  63.             created_at                      TIMESTAMP(0) WITH TIME ZONE NOT NULL DEFAULT CURRENT_TIMESTAMP,
  64.             updated_at                      TIMESTAMP(0) WITH TIME ZONE,
  65.             deleted_at                      TIMESTAMP(0) WITH TIME ZONE
  66.         )");
  68.         $this->addSql("CREATE INDEX non_conformity_ncr_id_idx ON non_conformity (ncr_id)");
  69.         $this->addSql("CREATE INDEX non_conformity_created_by_idx ON non_conformity (created_by)");
  70.         $this->addSql("CREATE INDEX non_conformity_updated_by_idx ON non_conformity (updated_by)");
  71.     }
  73.     public function down(Schema $schema): void
  74.     {
  75.         $this->addSql("DROP TABLE IF EXISTS non_conformity");
  76.         $this->addSql(NonConformityStatus::getDeletionSQL());
  77.         $this->addSql(NonConformityType::getDeletionSQL());
  78.         $this->addSql(NonConformitySubject::getDeletionSQL());
  79.     }
  80. }