migrations/Version20260807160000.php line 1

Open in your IDE?
  1. <?php
  3. declare(strict_types=1);
  5. namespace DoctrineMigrations;
  7. use Doctrine\DBAL\Schema\Schema;
  8. use Doctrine\Migrations\AbstractMigration;
  10. final class Version20260807160000 extends AbstractMigration
  11. {
  12.     public function getDescription(): string
  13.     {
  14.         return 'Add road_occupation_stage_purpose_fee for dynamic occupation purpose fees per stage (#29749).';
  15.     }
  17.     public function up(Schema $schema): void
  18.     {
  19.         $this->addSql('CREATE TABLE road_occupation_stage_purpose_fee (
  20.             id UUID NOT NULL,
  21.             stage_id UUID NOT NULL,
  22.             purpose_fee_id UUID NOT NULL,
  23.             width DOUBLE PRECISION DEFAULT NULL,
  24.             length DOUBLE PRECISION DEFAULT NULL,
  25.             area DOUBLE PRECISION DEFAULT NULL,
  26.             ordinal_number INT DEFAULT NULL,
  27.             created_by UUID DEFAULT NULL,
  28.             updated_by UUID DEFAULT NULL,
  29.             created_at TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL,
  30.             updated_at TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL,
  31.             deleted_at TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL,
  32.             PRIMARY KEY(id)
  33.         )');
  34.         $this->addSql('CREATE INDEX IDX_ROSPF_STAGE ON road_occupation_stage_purpose_fee (stage_id)');
  35.         $this->addSql('CREATE INDEX IDX_ROSPF_PURPOSE_FEE ON road_occupation_stage_purpose_fee (purpose_fee_id)');
  36.         $this->addSql('CREATE INDEX IDX_ROSPF_CREATED_BY ON road_occupation_stage_purpose_fee (created_by)');
  37.         $this->addSql('CREATE INDEX IDX_ROSPF_UPDATED_BY ON road_occupation_stage_purpose_fee (updated_by)');
  38.         $this->addSql('COMMENT ON COLUMN road_occupation_stage_purpose_fee.id IS \'(DC2Type:uuid)\'');
  39.         $this->addSql('COMMENT ON COLUMN road_occupation_stage_purpose_fee.stage_id IS \'(DC2Type:uuid)\'');
  40.         $this->addSql('COMMENT ON COLUMN road_occupation_stage_purpose_fee.purpose_fee_id IS \'(DC2Type:uuid)\'');
  41.         $this->addSql('COMMENT ON COLUMN road_occupation_stage_purpose_fee.created_by IS \'(DC2Type:uuid)\'');
  42.         $this->addSql('COMMENT ON COLUMN road_occupation_stage_purpose_fee.updated_by IS \'(DC2Type:uuid)\'');
  43.         $this->addSql('ALTER TABLE road_occupation_stage_purpose_fee ADD CONSTRAINT FK_ROSPF_STAGE FOREIGN KEY (stage_id) REFERENCES road_occupation_stage (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE');
  44.         $this->addSql('ALTER TABLE road_occupation_stage_purpose_fee ADD CONSTRAINT FK_ROSPF_PURPOSE_FEE FOREIGN KEY (purpose_fee_id) REFERENCES dict_road_occupation_purpose_fee (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
  45.         $this->addSql('ALTER TABLE road_occupation_stage_purpose_fee ADD CONSTRAINT FK_ROSPF_CREATED_BY FOREIGN KEY (created_by) REFERENCES "user" (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
  46.         $this->addSql('ALTER TABLE road_occupation_stage_purpose_fee ADD CONSTRAINT FK_ROSPF_UPDATED_BY FOREIGN KEY (updated_by) REFERENCES "user" (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
  47.     }
  49.     public function down(Schema $schema): void
  50.     {
  51.         $this->addSql('ALTER TABLE road_occupation_stage_purpose_fee DROP CONSTRAINT FK_ROSPF_STAGE');
  52.         $this->addSql('ALTER TABLE road_occupation_stage_purpose_fee DROP CONSTRAINT FK_ROSPF_PURPOSE_FEE');
  53.         $this->addSql('ALTER TABLE road_occupation_stage_purpose_fee DROP CONSTRAINT FK_ROSPF_CREATED_BY');
  54.         $this->addSql('ALTER TABLE road_occupation_stage_purpose_fee DROP CONSTRAINT FK_ROSPF_UPDATED_BY');
  55.         $this->addSql('DROP TABLE road_occupation_stage_purpose_fee');
  56.     }
  57. }