<?phpdeclare(strict_types=1);namespaceDoctrineMigrations;useDoctrine\DBAL\Schema\Schema;useDoctrine\Migrations\AbstractMigration;/** * Auto-generated Migration: Please modify to your needs! */finalclassVersion20240311155641extendsAbstractMigration{publicfunctiongetDescription():string{return'';}publicfunctionup(Schema$schema):void{// this up() migration is auto-generated, please modify it to your needs$this->addSql('ALTER TABLE geoloc ADD subterritory_id CHAR(36) DEFAULT NULL COMMENT \'(DC2Type:uuid)\'');$this->addSql('ALTER TABLE geoloc ADD CONSTRAINT FK_E1B7F4E7C8B38DB4 FOREIGN KEY (subterritory_id) REFERENCES subterritory (id)');$this->addSql('CREATE INDEX IDX_E1B7F4E7C8B38DB4 ON geoloc (subterritory_id)');$this->addSql('ALTER TABLE prestataire CHANGE iban iban LONGTEXT DEFAULT NULL COMMENT \'(DC2Type:personal_data)\'');}publicfunctiondown(Schema$schema):void{// this down() migration is auto-generated, please modify it to your needs$this->addSql('ALTER TABLE geoloc DROP FOREIGN KEY FK_E1B7F4E7C8B38DB4');$this->addSql('DROP INDEX IDX_E1B7F4E7C8B38DB4 ON geoloc');$this->addSql('ALTER TABLE geoloc DROP subterritory_id');$this->addSql('ALTER TABLE prestataire CHANGE iban iban LONGTEXT CHARACTER SET utf8 DEFAULT NULL COLLATE `utf8_general_ci` COMMENT \'(DC2Type:personal_data)\'');}}