migrations/Delete/Version20241210130245_InventoryMaterial.php line 1

  1. <?php
  3. declare(strict_types=1);
  5. namespace DoctrineMigrations\Delete;
  7. use Doctrine\DBAL\Schema\Schema;
  8. use Doctrine\Migrations\AbstractMigration;
  10. /**
  11.  * Auto-generated Migration: Please modify to your needs!
  12.  */
  13. final class Version20241210130245_InventoryMaterial extends AbstractMigration
  14. {
  15.     public function getDescription(): string
  16.     {
  17.         return 'Add inventory material table';
  18.     }
  20.     public function up(Schema $schema) : void
  21.     {
  22.         $this->addSql('CREATE TABLE inventory_x_material (
  23.             id                          SERIAL PRIMARY KEY,
  24.             slug                        CHARACTER VARYING NOT NULL,
  25.             order_number                CHARACTER VARYING NOT NULL,
  26.             item_number                 CHARACTER VARYING NOT NULL,
  27.             material_number             CHARACTER VARYING NOT NULL,
  28.             supplier_part_number        CHARACTER VARYING,
  29.             description                 CHARACTER VARYING NOT NULL,
  30.             supplier                    CHARACTER VARYING NOT NULL,
  31.             owner                       CHARACTER VARYING,
  32.             preservation                CHARACTER VARYING,
  33.             Searchable                  CHARACTER VARYING,
  34.             quantity                    INTEGER           NOT NULL,
  35.             unit_price                  DECIMAL(18, 2)    NOT NULL,
  36.             value                       DECIMAL(18, 2)    NOT NULL,
  37.             currency                    CHARACTER VARYING(3),
  38.             spfr                        CHARACTER VARYING,
  39.             
  40.             degrouped                   BOOLEAN,
  41.             certified                   BOOLEAN,
  42.             fat_required                BOOLEAN           NOT NULL DEFAULT false,
  43.             retired                     BOOLEAN           NOT NULL DEFAULT false,
  44.             
  45.             expeditable                 BOOLEAN,
  46.             dangerous                   BOOLEAN,
  47.             prohibited                  BOOLEAN,
  49.             created_by                  INTEGER                              REFERENCES public.user (id),
  50.             updated_by                  INTEGER                              REFERENCES public.user (id),
  51.             created_at                  TIMESTAMP(0) WITH TIME ZONE NOT NULL DEFAULT CURRENT_TIMESTAMP,
  52.             updated_at                  TIMESTAMP(0) WITH TIME ZONE,
  53.             deleted_at                  TIMESTAMP(0) WITH TIME ZONE,
  54.             
  55.             CONSTRAINT inventory_x_material_slug_key UNIQUE (slug)
  56.         )');
  58.         $this->addSql("CREATE INDEX inventory_x_material_created_by_idx ON inventory_x_material (created_by)");
  59.         $this->addSql("CREATE INDEX inventory_x_material_updated_by_idx ON inventory_x_material (updated_by)");
  60.     }
  62.     public function down(Schema $schema) : void
  63.     {
  64.         $this->addSql('DROP TABLE IF EXISTS inventory_x_material');
  65.     }
  66. }