migrations/Delete/Version20241011145526_ExpeditingBatch.php line 1

  1. <?php
  3. declare(strict_types=1);
  5. namespace DoctrineMigrations\Delete;
  7. use App\Doctrine\Type\Expediting\TransportMode;
  8. use Doctrine\DBAL\Schema\Schema;
  9. use Doctrine\Migrations\AbstractMigration;
  11. /**
  12.  * Auto-generated Migration: Please modify to your needs!
  13.  */
  14. final class Version20241011145526_ExpeditingBatch extends AbstractMigration
  15. {
  16.     public function getDescription(): string
  17.     {
  18.         return 'Add expediting batch';
  19.     }
  21.     public function up(Schema $schema): void
  22.     {
  23.         $transportModeType = TransportMode::getName();
  25.         $this->addSql("CREATE TABLE expediting_z_batch (
  26.             id                              SERIAL PRIMARY KEY,
  28.             slug                            CHARACTER VARYING           NOT NULL,
  29.             reference                       CHARACTER VARYING           NOT NULL,
  30.             
  31.             jv                              BOOLEAN,
  32.             dg                              BOOLEAN,
  33.             transport_mode                  {$transportModeType}          NOT NULL,
  34.             carrier                         CHARACTER VARYING,
  35.             vessel                          CHARACTER VARYING,
  36.             bill_number                     CHARACTER VARYING,
  37.             booking_number                  CHARACTER VARYING,
  38.             vector_reference                CHARACTER VARYING,
  39.             place_of_loading                CHARACTER VARYING,
  40.             place_of_discharge              CHARACTER VARYING,
  41.             departure_country_code          CHARACTER VARYING             NOT NULL,
  42.             hub_country_code                CHARACTER VARYING,
  43.             
  44.             description                     CHARACTER VARYING,
  45.             buyer                           JSONB,
  46.             shipper                         JSONB,
  47.             consignee                       JSONB,
  48.             notify_party                    JSONB,
  49.             
  50.             form_m                          CHARACTER VARYING,
  51.             ba_number                       CHARACTER VARYING,
  52.             weight                          DECIMAL(18, 2),
  53.             volume                          DECIMAL(18, 2),
  54.             value                           DECIMAL(18, 2),
  55.             pickup_cost                     DECIMAL(18, 5),
  56.             freight_cost                    DECIMAL(18, 5),
  57.             green_lit_on                    DATE,
  58.             booked_on                       DATE,
  59.             etd                             DATE,
  60.             atd                             DATE,
  61.             eta                             DATE,
  62.             ata                             DATE,
  63.             customs_on                      DATE,
  64.             delivered_on                    DATE,
  65.             metadata                        JSONB,
  67.             created_by                      INTEGER                              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,
  72.             
  73.             CONSTRAINT expediting_z_batch_slug_key UNIQUE (slug),
  74.             CONSTRAINT expediting_z_batch_reference_key UNIQUE (reference)
  75.         )");
  77.         $this->addSql("COMMENT ON COLUMN expediting_z_batch.buyer IS '(DC2Type:json_document)'");
  78.         $this->addSql("COMMENT ON COLUMN expediting_z_batch.shipper IS '(DC2Type:json_document)'");
  79.         $this->addSql("COMMENT ON COLUMN expediting_z_batch.consignee IS '(DC2Type:json_document)'");
  80.         $this->addSql("COMMENT ON COLUMN expediting_z_batch.notify_party IS '(DC2Type:json_document)'");
  81.         $this->addSql("COMMENT ON COLUMN expediting_z_batch.metadata IS '(DC2Type:json_document)'");
  82.         $this->addSql("CREATE INDEX expediting_z_batch_created_by_idx ON expediting_z_batch (created_by)");
  83.         $this->addSql("CREATE INDEX expediting_z_batch_updated_by_idx ON expediting_z_batch (updated_by)");
  84.     }
  86.     public function down(Schema $schema): void
  87.     {
  88.         $this->addSql("DROP TABLE IF EXISTS expediting_z_batch");
  89.     }
  90. }