Symfony Profiler

<?php
declare(strict_types=1);
namespace DoctrineMigrations;
use Doctrine\DBAL\Schema\Schema;
use Doctrine\Migrations\AbstractMigration;
/**
* Auto-generated Migration: Please modify to your needs!
*/
final class Version20240709064232 extends AbstractMigration
{
public function getDescription(): string
{
return '';
}
public function up(Schema $schema): void
{
// this up() migration is auto-generated, please modify it to your needs
$this->addSql('CREATE TABLE road_occupation (id UUID NOT NULL, application_id UUID DEFAULT NULL, created_by UUID DEFAULT NULL, updated_by UUID DEFAULT NULL, occupation_type VARCHAR(255) DEFAULT NULL, city VARCHAR(255) DEFAULT NULL, purpose VARCHAR(255) DEFAULT NULL, location_decision_number VARCHAR(255) DEFAULT NULL, created_at TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, updated_at TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, deleted_at TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE INDEX IDX_51453B6C3E030ACD ON road_occupation (application_id)');
$this->addSql('CREATE INDEX IDX_51453B6CDE12AB56 ON road_occupation (created_by)');
$this->addSql('CREATE INDEX IDX_51453B6C16FE72E1 ON road_occupation (updated_by)');
$this->addSql('COMMENT ON COLUMN road_occupation.id IS \'(DC2Type:uuid)\'');
$this->addSql('COMMENT ON COLUMN road_occupation.application_id IS \'(DC2Type:uuid)\'');
$this->addSql('COMMENT ON COLUMN road_occupation.created_by IS \'(DC2Type:uuid)\'');
$this->addSql('COMMENT ON COLUMN road_occupation.updated_by IS \'(DC2Type:uuid)\'');
$this->addSql('CREATE TABLE road_occupation_stage (id UUID NOT NULL, road_occupation_id UUID NOT NULL, created_by UUID DEFAULT NULL, updated_by UUID DEFAULT NULL, start_date DATE NOT NULL, end_date DATE NOT NULL, geometry VARCHAR(255) DEFAULT NULL, road_width DOUBLE PRECISION DEFAULT NULL, road_length DOUBLE PRECISION DEFAULT NULL, road_area DOUBLE PRECISION DEFAULT NULL, road_fee DOUBLE PRECISION DEFAULT NULL, sidewalk_width DOUBLE PRECISION DEFAULT NULL, sidewalk_length DOUBLE PRECISION DEFAULT NULL, sidewalk_area DOUBLE PRECISION DEFAULT NULL, sidewalk_fee DOUBLE PRECISION DEFAULT NULL, shoulder_width DOUBLE PRECISION DEFAULT NULL, shoulder_length DOUBLE PRECISION DEFAULT NULL, shoulder_area DOUBLE PRECISION DEFAULT NULL, shoulder_fee DOUBLE PRECISION DEFAULT NULL, greenery_width DOUBLE PRECISION DEFAULT NULL, greenery_length DOUBLE PRECISION DEFAULT NULL, greenery_area DOUBLE PRECISION DEFAULT NULL, greenery_fee DOUBLE PRECISION DEFAULT NULL, other_elements_width DOUBLE PRECISION DEFAULT NULL, other_elements_length DOUBLE PRECISION DEFAULT NULL, other_elements_area DOUBLE PRECISION DEFAULT NULL, other_elements_fee DOUBLE PRECISION DEFAULT NULL, created_at TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, updated_at TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, deleted_at TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE INDEX IDX_2037D5CB1D88AD02 ON road_occupation_stage (road_occupation_id)');
$this->addSql('CREATE INDEX IDX_2037D5CBDE12AB56 ON road_occupation_stage (created_by)');
$this->addSql('CREATE INDEX IDX_2037D5CB16FE72E1 ON road_occupation_stage (updated_by)');
$this->addSql('COMMENT ON COLUMN road_occupation_stage.id IS \'(DC2Type:uuid)\'');
$this->addSql('COMMENT ON COLUMN road_occupation_stage.road_occupation_id IS \'(DC2Type:uuid)\'');
$this->addSql('COMMENT ON COLUMN road_occupation_stage.created_by IS \'(DC2Type:uuid)\'');
$this->addSql('COMMENT ON COLUMN road_occupation_stage.updated_by IS \'(DC2Type:uuid)\'');
$this->addSql('ALTER TABLE road_occupation ADD CONSTRAINT FK_51453B6C3E030ACD FOREIGN KEY (application_id) REFERENCES application (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE road_occupation ADD CONSTRAINT FK_51453B6CDE12AB56 FOREIGN KEY (created_by) REFERENCES "user" (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE road_occupation ADD CONSTRAINT FK_51453B6C16FE72E1 FOREIGN KEY (updated_by) REFERENCES "user" (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE road_occupation_stage ADD CONSTRAINT FK_2037D5CB1D88AD02 FOREIGN KEY (road_occupation_id) REFERENCES road_occupation (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE road_occupation_stage ADD CONSTRAINT FK_2037D5CBDE12AB56 FOREIGN KEY (created_by) REFERENCES "user" (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE road_occupation_stage ADD CONSTRAINT FK_2037D5CB16FE72E1 FOREIGN KEY (updated_by) REFERENCES "user" (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE application ADD application_subject TEXT DEFAULT NULL');
}
public function down(Schema $schema): void
{
// this down() migration is auto-generated, please modify it to your needs
$this->addSql('CREATE SCHEMA public');
$this->addSql('ALTER TABLE road_occupation DROP CONSTRAINT FK_51453B6C3E030ACD');
$this->addSql('ALTER TABLE road_occupation DROP CONSTRAINT FK_51453B6CDE12AB56');
$this->addSql('ALTER TABLE road_occupation DROP CONSTRAINT FK_51453B6C16FE72E1');
$this->addSql('ALTER TABLE road_occupation_stage DROP CONSTRAINT FK_2037D5CB1D88AD02');
$this->addSql('ALTER TABLE road_occupation_stage DROP CONSTRAINT FK_2037D5CBDE12AB56');
$this->addSql('ALTER TABLE road_occupation_stage DROP CONSTRAINT FK_2037D5CB16FE72E1');
$this->addSql('DROP TABLE road_occupation');
$this->addSql('DROP TABLE road_occupation_stage');
$this->addSql('ALTER TABLE application DROP application_subject');
}
}

migrations/Version20240709064232.php line 1