migrations/Purchasing/Version20200306152908_PurchasingLineItem.php line 1

  1. <?php
  3. declare(strict_types=1);
  5. namespace DoctrineMigrations\Purchasing;
  7. use App\Doctrine\Type\Purchasing\LineItemStatus;
  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 Version20200306152908_PurchasingLineItem extends AbstractMigration
  15. {
  16.     public function getDescription(): string
  17.     {
  18.         return 'Add line item table';
  19.     }
  21.     public function up(Schema $schema): void
  22.     {
  23.         $lineItemStatusType = LineItemStatus::getName();
  24.         $defaultStatus = LineItemStatus::ORDERED->value;
  26.         $this->addSql("CREATE TABLE purchasing_line_item (
  27.             id                              SERIAL PRIMARY KEY,
  28.             identifier                      UUID                        NOT NULL,
  29.             slug                            CHARACTER VARYING           NOT NULL,
  30.             order_id                        INTEGER                     NOT NULL REFERENCES purchasing_order (id),
  31.             customer_id                     INTEGER                              REFERENCES public.company (id),
  32.             supplier_id                     INTEGER                              REFERENCES public.company (id),
  33.             asset_id                        INTEGER                              REFERENCES company_asset (id),
  34.             flow_id                         INTEGER                              REFERENCES purchasing_flow (id),
  35.             number                          CHARACTER VARYING           NOT NULL,
  36.             material_number                 CHARACTER VARYING,
  37.             material_group                  CHARACTER VARYING,
  38.             supplier_part_number            CHARACTER VARYING,
  39.             supplier_description            CHARACTER VARYING,
  40.             customer_description            CHARACTER VARYING,
  41.             quantity                        INTEGER,
  42.             hs_code                         CHARACTER VARYING,
  43.             country_of_origin               CHARACTER VARYING,
  44.             currency                        CHARACTER VARYING(3),
  45.             unit_price                      DECIMAL(18, 5),
  46.             value                           DECIMAL(18, 5),
  47.             available_on                    DATE,
  48.             status                          {$lineItemStatusType}       NOT NULL DEFAULT '{$defaultStatus}',
  50.             created_by                      INTEGER                     NOT NULL REFERENCES public.user (id),
  51.             updated_by                      INTEGER                              REFERENCES public.user (id),
  52.             created_at                      TIMESTAMP(0) WITH TIME ZONE NOT NULL DEFAULT CURRENT_TIMESTAMP,
  53.             updated_at                      TIMESTAMP(0) WITH TIME ZONE,
  54.             deleted_at                      TIMESTAMP(0) WITH TIME ZONE,
  56.             CONSTRAINT purchasing_line_item_identifier_key UNIQUE (identifier),
  57.             CONSTRAINT purchasing_line_item_order_id_number_key UNIQUE (order_id, number),
  58.             CONSTRAINT purchasing_line_item_slug_key UNIQUE (slug)
  59.         )");
  61.         $this->addSql("COMMENT ON COLUMN purchasing_line_item.identifier IS '(DC2Type:ulid)'");
  62.         $this->addSql("CREATE INDEX purchasing_line_item_order_id_idx ON purchasing_line_item (order_id)");
  63.         $this->addSql("CREATE INDEX purchasing_line_item_customer_id_idx ON purchasing_line_item (customer_id)");
  64.         $this->addSql("CREATE INDEX purchasing_line_item_supplier_id_idx ON purchasing_line_item (supplier_id)");
  65.         $this->addSql("CREATE INDEX purchasing_line_item_asset_id_idx ON purchasing_line_item (asset_id)");
  66.         $this->addSql("CREATE INDEX purchasing_line_item_flow_id_idx ON purchasing_line_item (flow_id)");
  67.         $this->addSql("CREATE INDEX purchasing_line_item_created_by_idx ON purchasing_line_item (created_by)");
  68.         $this->addSql("CREATE INDEX purchasing_line_item_updated_by_idx ON purchasing_line_item (updated_by)");
  69.     }
  71.     public function down(Schema $schema): void
  72.     {
  73.         $this->addSql("DROP TABLE IF EXISTS purchasing_line_item");
  74.     }
  75. }