addSql('ALTER TABLE devis_options DROP CONSTRAINT fk_42db61dba7c41d6f'); $this->addSql('DROP INDEX idx_42db61dba7c41d6f'); $this->addSql('ALTER TABLE devis_options ADD option TEXT NOT NULL'); $this->addSql('ALTER TABLE devis_options DROP option_id'); } 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 devis_options ADD option_id INT DEFAULT NULL'); $this->addSql('ALTER TABLE devis_options DROP option'); $this->addSql('ALTER TABLE devis_options ADD CONSTRAINT fk_42db61dba7c41d6f FOREIGN KEY (option_id) REFERENCES options (id) NOT DEFERRABLE INITIALLY IMMEDIATE'); $this->addSql('CREATE INDEX idx_42db61dba7c41d6f ON devis_options (option_id)'); } }