geekhub-php /
CheTheatre
| @@ 11-38 (lines=28) @@ | ||
| 8 | /** |
|
| 9 | * Auto-generated Migration: Please modify to your needs! |
|
| 10 | */ |
|
| 11 | class Version20170411152812 extends AbstractMigration |
|
| 12 | { |
|
| 13 | /** |
|
| 14 | * @param Schema $schema |
|
| 15 | */ |
|
| 16 | public function up(Schema $schema) |
|
| 17 | { |
|
| 18 | // this up() migration is auto-generated, please modify it to your needs |
|
| 19 | $this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.'); |
|
| 20 | ||
| 21 | $this->addSql('ALTER TABLE ticket DROP FOREIGN KEY FK_97A0ADA31C7C4AAD'); |
|
| 22 | $this->addSql('DROP INDEX IDX_97A0ADA31C7C4AAD ON ticket'); |
|
| 23 | $this->addSql('ALTER TABLE ticket CHANGE user_order_id user_order_id INT DEFAULT NULL'); |
|
| 24 | } |
|
| 25 | ||
| 26 | /** |
|
| 27 | * @param Schema $schema |
|
| 28 | */ |
|
| 29 | public function down(Schema $schema) |
|
| 30 | { |
|
| 31 | // this down() migration is auto-generated, please modify it to your needs |
|
| 32 | $this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.'); |
|
| 33 | ||
| 34 | $this->addSql('ALTER TABLE ticket CHANGE user_order_id user_order_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:uuid_binary)\''); |
|
| 35 | $this->addSql('ALTER TABLE ticket ADD CONSTRAINT FK_97A0ADA31C7C4AAD FOREIGN KEY (user_order_id) REFERENCES user_order (id)'); |
|
| 36 | $this->addSql('CREATE INDEX IDX_97A0ADA31C7C4AAD ON ticket (user_order_id)'); |
|
| 37 | } |
|
| 38 | } |
|
| @@ 11-38 (lines=28) @@ | ||
| 8 | /** |
|
| 9 | * Auto-generated Migration: Please modify to your needs! |
|
| 10 | */ |
|
| 11 | class Version20170415090211 extends AbstractMigration |
|
| 12 | { |
|
| 13 | /** |
|
| 14 | * @param Schema $schema |
|
| 15 | */ |
|
| 16 | public function up(Schema $schema) |
|
| 17 | { |
|
| 18 | // this up() migration is auto-generated, please modify it to your needs |
|
| 19 | $this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.'); |
|
| 20 | ||
| 21 | $this->addSql('ALTER TABLE user_order ADD user_id INT DEFAULT NULL'); |
|
| 22 | $this->addSql('ALTER TABLE user_order ADD CONSTRAINT FK_17EB68C0A76ED395 FOREIGN KEY (user_id) REFERENCES users (id)'); |
|
| 23 | $this->addSql('CREATE INDEX IDX_17EB68C0A76ED395 ON user_order (user_id)'); |
|
| 24 | } |
|
| 25 | ||
| 26 | /** |
|
| 27 | * @param Schema $schema |
|
| 28 | */ |
|
| 29 | public function down(Schema $schema) |
|
| 30 | { |
|
| 31 | // this down() migration is auto-generated, please modify it to your needs |
|
| 32 | $this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.'); |
|
| 33 | ||
| 34 | $this->addSql('ALTER TABLE user_order DROP FOREIGN KEY FK_17EB68C0A76ED395'); |
|
| 35 | $this->addSql('DROP INDEX IDX_17EB68C0A76ED395 ON user_order'); |
|
| 36 | $this->addSql('ALTER TABLE user_order DROP user_id'); |
|
| 37 | } |
|
| 38 | } |
|
| 39 | ||
