addSql('ALTER TABLE task_status ADD project_id INT NOT NULL'); $this->addSql('ALTER TABLE task_status ADD CONSTRAINT FK_40A9E1CF166D1F9C FOREIGN KEY (project_id) REFERENCES project (id) ON DELETE CASCADE NOT DEFERRABLE'); $this->addSql('CREATE INDEX IDX_40A9E1CF166D1F9C ON task_status (project_id)'); } public function down(Schema $schema): void { // this down() migration is auto-generated, please modify it to your needs $this->addSql('ALTER TABLE task_status DROP CONSTRAINT FK_40A9E1CF166D1F9C'); $this->addSql('DROP INDEX IDX_40A9E1CF166D1F9C'); $this->addSql('ALTER TABLE task_status DROP project_id'); } }