<?php declare (strict_types = 1);
namespace DoctrineMigrations;
use Doctrine\DBAL\Schema\Schema;
use Doctrine\Migrations\AbstractMigration;
/**
* Auto-generated Migration: Please modify to your needs!
*/
class Version20180316150002 extends AbstractMigration
{
public function up(Schema $schema): void
{
// this up() migration is auto-generated, please modify it to your needs
$this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.');
$this->addSql('ALTER TABLE user_survey DROP FOREIGN KEY FK_C80D80C132FD39D4');
$this->addSql('DROP INDEX IDX_C80D80C132FD39D4 ON user_survey');
$this->addSql('ALTER TABLE user_survey CHANGE surveydetail_id `survey_id` INT NOT NULL');
$this->addSql('ALTER TABLE user_survey ADD CONSTRAINT FK_C80D80C1C964D0DE FOREIGN KEY (`survey_id`) REFERENCES survey (`id`)');
$this->addSql('CREATE INDEX IDX_C80D80C1C964D0DE ON user_survey (`survey_id`)');
$this->addSql('ALTER TABLE user_survey DROP value');
$this->addSql('ALTER TABLE user_survey ADD `creationUser` VARCHAR(255) DEFAULT NULL, ADD `creationDate` DATETIME DEFAULT NULL, ADD `modifiedUser` VARCHAR(255) DEFAULT NULL, ADD `modifiedDate` DATETIME DEFAULT NULL');
}
public function down(Schema $schema): void
{
// this down() migration is auto-generated, please modify it to your needs
$this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.');
$this->addSql('ALTER TABLE user_survey DROP FOREIGN KEY FK_C80D80C1C964D0DE');
$this->addSql('DROP INDEX IDX_C80D80C1C964D0DE ON user_survey');
$this->addSql('ALTER TABLE user_survey CHANGE survey_id surveyDetail_id INT NOT NULL');
$this->addSql('ALTER TABLE user_survey ADD CONSTRAINT FK_C80D80C132FD39D4 FOREIGN KEY (surveyDetail_id) REFERENCES survey_detail (id)');
$this->addSql('CREATE INDEX IDX_C80D80C132FD39D4 ON user_survey (surveyDetail_id)');
$this->addSql('ALTER TABLE user_survey ADD value VARCHAR(255) NOT NULL COLLATE utf8_unicode_ci');
$this->addSql('ALTER TABLE user_survey DROP `creationUser`, DROP `creationDate`, DROP `modifiedUser`, DROP `modifiedDate`');
}
}