<?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 Version20180315164214 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('CREATE TABLE event_store (id INT AUTO_INCREMENT NOT NULL, type VARCHAR(255) NOT NULL, ts DATETIME NOT NULL, description VARCHAR(255) NOT NULL, username VARCHAR(255) NOT NULL, data VARCHAR(255) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
$this->addSql('CREATE TABLE survey (`id` INT AUTO_INCREMENT NOT NULL, `enabled` TINYINT(1) DEFAULT NULL, `description` VARCHAR(255) DEFAULT NULL, PRIMARY KEY(`id`)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
$this->addSql('CREATE TABLE survey_detail (`id` INT AUTO_INCREMENT NOT NULL, `order` INT NOT NULL, `key` VARCHAR(255) NOT NULL, `type_field` VARCHAR(255) NOT NULL COMMENT \'(DC2Type:enumsurveyfield)\', `enabled` TINYINT(1) NOT NULL, `value_field` VARCHAR(255) DEFAULT NULL, `description` VARCHAR(255) NOT NULL, `survey_id` INT DEFAULT NULL, INDEX IDX_608B7FFC964D0DE (`survey_id`), PRIMARY KEY(`id`)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
$this->addSql('CREATE TABLE user (`id` INT AUTO_INCREMENT NOT NULL, `mapped_id` INT NOT NULL, `description` VARCHAR(255) NOT NULL, PRIMARY KEY(`id`)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
$this->addSql('CREATE TABLE user_survey (`id` INT AUTO_INCREMENT NOT NULL, `value` VARCHAR(255) NOT NULL, `start_date` DATE NOT NULL, `end_date` DATE DEFAULT NULL, `user_id` INT NOT NULL, `surveyDetail_id` INT NOT NULL, INDEX IDX_C80D80C1C03ACDAE (`user_id`), INDEX IDX_C80D80C132FD39D4 (`surveyDetail_id`), PRIMARY KEY(`id`)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
$this->addSql('CREATE TABLE user_survey_answer (`id` INT AUTO_INCREMENT NOT NULL, `value` VARCHAR(255) NOT NULL, `userSurvey_id` INT NOT NULL, `surveyDetail_id` INT NOT NULL, INDEX IDX_1C5D2F1957CA8F96 (`userSurvey_id`), INDEX IDX_1C5D2F1932FD39D4 (`surveyDetail_id`), PRIMARY KEY(`id`)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
$this->addSql('ALTER TABLE survey_detail ADD CONSTRAINT FK_608B7FFC964D0DE FOREIGN KEY (`survey_id`) REFERENCES survey (`id`)');
$this->addSql('ALTER TABLE user_survey ADD CONSTRAINT FK_C80D80C1C03ACDAE FOREIGN KEY (`user_id`) REFERENCES user (`id`)');
$this->addSql('ALTER TABLE user_survey ADD CONSTRAINT FK_C80D80C132FD39D4 FOREIGN KEY (`surveyDetail_id`) REFERENCES survey_detail (`id`)');
$this->addSql('ALTER TABLE user_survey_answer ADD CONSTRAINT FK_1C5D2F1957CA8F96 FOREIGN KEY (`userSurvey_id`) REFERENCES user_survey (`id`)');
$this->addSql('ALTER TABLE user_survey_answer ADD CONSTRAINT FK_1C5D2F1932FD39D4 FOREIGN KEY (`surveyDetail_id`) REFERENCES survey_detail (`id`)');
}
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 survey_detail DROP FOREIGN KEY FK_608B7FFC964D0DE');
$this->addSql('ALTER TABLE user_survey DROP FOREIGN KEY FK_C80D80C132FD39D4');
$this->addSql('ALTER TABLE user_survey_answer DROP FOREIGN KEY FK_1C5D2F1932FD39D4');
$this->addSql('ALTER TABLE user_survey DROP FOREIGN KEY FK_C80D80C1C03ACDAE');
$this->addSql('ALTER TABLE user_survey_answer DROP FOREIGN KEY FK_1C5D2F1957CA8F96');
$this->addSql('DROP TABLE event_store');
$this->addSql('DROP TABLE survey');
$this->addSql('DROP TABLE survey_detail');
$this->addSql('DROP TABLE user');
$this->addSql('DROP TABLE user_survey');
$this->addSql('DROP TABLE user_survey_answer');
}
}