migrations/Expediting/Version20200309105319_ExpeditingPackage.php line 1

  1. <?php
  3. declare(strict_types=1);
  5. namespace DoctrineMigrations\Expediting;
  7. use App\Doctrine\Type\Expediting\CasingMaterial;
  8. use App\Doctrine\Type\Expediting\CasingType;
  9. use App\Doctrine\Type\Expediting\DeliveryPriority;
  10. use App\Doctrine\Type\Expediting\ExpeditableStatus;
  11. use Doctrine\DBAL\Schema\Schema;
  12. use Doctrine\Migrations\AbstractMigration;
  14. /**
  15.  * Auto-generated Migration: Please modify to your needs!
  16.  */
  17. final class Version20200309105319_ExpeditingPackage extends AbstractMigration
  18. {
  19.     public function getDescription(): string
  20.     {
  21.         return 'Add package table';
  22.     }
  24.     public function up(Schema $schema): void
  25.     {
  26.         $casingTypeType = CasingType::getName();
  27.         $casingMaterialType = CasingMaterial::getName();
  28.         $expeditableStatusType = ExpeditableStatus::getName();
  29.         $deliveryPriorityType = DeliveryPriority::getName();
  30.         $defaultPriority = DeliveryPriority::NORMAL->value;
  32.         $this->addSql("CREATE TABLE expediting_package (
  33.             id                              SERIAL PRIMARY KEY,
  34.             identifier                      UUID                        NOT NULL,
  35.             destination_repacking_id        INTEGER                              REFERENCES public.expediting_repacking (id),
  36.             source_repacking_id             INTEGER                              REFERENCES public.expediting_repacking (id),
  37.             slug                            CHARACTER VARYING           NOT NULL,
  38.             reference                       CHARACTER VARYING           NOT NULL,
  39.             package_number                  CHARACTER VARYING           NOT NULL,
  40.             status                          {$expeditableStatusType}    NOT NULL,
  42.             -- Aspect
  43.             length                          DECIMAL(18, 3),
  44.             width                           DECIMAL(18, 3),
  45.             height                          DECIMAL(18, 3),
  46.             weight                          DECIMAL(18, 3),
  47.             shipping_weight                 DECIMAL(18, 3),
  48.             casing_type                     {$casingTypeType},
  49.             casing_material                 {$casingMaterialType},
  52.             -- shipping
  53.             priority                        {$deliveryPriorityType}              DEFAULT '{$defaultPriority}',
  54.             high_value                      BOOLEAN                              DEFAULT false,
  55.             high_volume                     BOOLEAN                              DEFAULT false,
  56.             high_risk                       BOOLEAN                              DEFAULT false,
  57.             expeditable                     BOOLEAN                              DEFAULT false,
  58.             prohibited                      BOOLEAN                              DEFAULT false,
  59.             dangerous                       BOOLEAN                              DEFAULT false,
  62.             -- QA/QC
  63.             openable                        BOOLEAN                     NOT NULL DEFAULT false,
  64.             destroyed                       BOOLEAN                     NOT NULL DEFAULT false,
  67.             created_by                      INTEGER                     NOT NULL REFERENCES public.user (id),
  68.             updated_by                      INTEGER                              REFERENCES public.user (id),
  69.             created_at                      TIMESTAMP(0) WITH TIME ZONE NOT NULL DEFAULT CURRENT_TIMESTAMP,
  70.             updated_at                      TIMESTAMP(0) WITH TIME ZONE,
  71.             deleted_at                      TIMESTAMP(0) WITH TIME ZONE,
  73.             CONSTRAINT expediting_package_slug_key UNIQUE (slug),
  74.             CONSTRAINT expediting_package_reference_key UNIQUE (reference),
  75.             CONSTRAINT expediting_package_identifier_key UNIQUE (identifier)
  76.         )");
  78.         $this->addSql("COMMENT ON COLUMN expediting_package.identifier IS '(DC2Type:ulid)'");
  79.         $this->addSql("CREATE INDEX expediting_package_destination_repacking_id_idx ON expediting_package (destination_repacking_id)");
  80.         $this->addSql("CREATE INDEX expediting_package_source_repacking_id_idx ON expediting_package (source_repacking_id)");
  81.         $this->addSql("CREATE INDEX expediting_package_created_by_idx ON expediting_package (created_by)");
  82.         $this->addSql("CREATE INDEX expediting_package_updated_by_idx ON expediting_package (updated_by)");
  83.     }
  85.     public function down(Schema $schema): void
  86.     {
  87.         $this->addSql("DROP TABLE IF EXISTS expediting_package");
  88.     }
  89. }