migrations/Delete/Version20241011190123_ExpeditingBox.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 Doctrine\DBAL\Schema\Schema;
  10. use Doctrine\Migrations\AbstractMigration;
  12. /**
  13.  * Auto-generated Migration: Please modify to your needs!
  14.  */
  15. final class Version20241011190123_ExpeditingBox extends AbstractMigration
  16. {
  17.     public function getDescription(): string
  18.     {
  19.         return 'Add expediting box';
  20.     }
  22.     public function up(Schema $schema): void
  23.     {
  24.         $casingTypeType = CasingType::getName();
  25.         $casingMaterialType = CasingMaterial::getName();
  27.         $this->addSql("CREATE TABLE expediting_z_box (
  28.             id                              SERIAL PRIMARY KEY,
  30.             container_id                    INTEGER                              REFERENCES expediting_z_container (id),
  31.             repacking_id                    INTEGER                              REFERENCES public.company (id),
  32.             slug                            CHARACTER VARYING           NOT NULL,
  33.             reference                       CHARACTER VARYING           NOT NULL,
  34.             order_numbers                   CHARACTER VARYING,
  35.             pickup_country_code             CHARACTER VARYING,
  36.             vendor                          CHARACTER VARYING,
  37.             batch                           CHARACTER VARYING,
  38.             hub                             CHARACTER VARYING,
  39.             
  40.             jv                              BOOLEAN,
  41.             dg                              BOOLEAN,
  42.             casing_type                     {$casingTypeType},
  43.             casing_material                 {$casingMaterialType},
  44.             length                          DECIMAL(18, 3),
  45.             width                           DECIMAL(18, 3),
  46.             height                          DECIMAL(18, 3),
  47.             weight                          DECIMAL(18, 3),
  48.             shipping_weight                 DECIMAL(18, 3),
  49.             value                           DECIMAL(18, 2),
  50.             items                           JSONB                       NOT NULL,
  52.             created_by                      INTEGER                              REFERENCES public.user (id),
  53.             updated_by                      INTEGER                              REFERENCES public.user (id),
  54.             created_at                      TIMESTAMP(0) WITH TIME ZONE NOT NULL DEFAULT CURRENT_TIMESTAMP,
  55.             updated_at                      TIMESTAMP(0) WITH TIME ZONE,
  56.             deleted_at                      TIMESTAMP(0) WITH TIME ZONE,
  57.             
  58.             CONSTRAINT expediting_z_box_slug_key UNIQUE (slug),
  59.             CONSTRAINT expediting_z_box_reference_key UNIQUE (reference)
  60.         )");
  62.         $this->addSql("COMMENT ON COLUMN expediting_z_box.items IS '(DC2Type:json_document)'");
  63.         $this->addSql("CREATE INDEX expediting_z_box_batch_idx ON expediting_z_box (batch)");
  64.         $this->addSql("CREATE INDEX expediting_z_box_order_numbers_idx ON expediting_z_box (order_numbers)");
  65.         $this->addSql("CREATE INDEX expediting_z_container_container_id_idx ON expediting_z_box (container_id)");
  66.         $this->addSql("CREATE INDEX expediting_z_container_repacking_id_idx ON expediting_z_box (repacking_id)");
  67.         $this->addSql("CREATE INDEX expediting_z_box_created_by_idx ON expediting_z_box (created_by)");
  68.         $this->addSql("CREATE INDEX expediting_z_box_updated_by_idx ON expediting_z_box (updated_by)");
  69.     }
  71.     public function down(Schema $schema): void
  72.     {
  73.         $this->addSql("DROP TABLE IF EXISTS expediting_z_box");
  74.     }
  75. }