addSql('ALTER TABLE game ADD add_by_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:uuid)\', ADD add_datetime DATETIME DEFAULT NULL'); $this->addSql('ALTER TABLE game ADD CONSTRAINT FK_232B318C17542AC5 FOREIGN KEY (add_by_id) REFERENCES user (id)'); $this->addSql('CREATE INDEX IDX_232B318C17542AC5 ON game (add_by_id)'); } public function down(Schema $schema): void { // this down() migration is auto-generated, please modify it to your needs $this->addSql('ALTER TABLE game DROP FOREIGN KEY FK_232B318C17542AC5'); $this->addSql('DROP INDEX IDX_232B318C17542AC5 ON game'); $this->addSql('ALTER TABLE game DROP add_by_id, DROP add_datetime'); } }