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 | } |
|
| 39 | ||
| @@ 11-38 (lines=28) @@ | ||
| 8 | /** |
|
| 9 | * Auto-generated Migration: Please modify to your needs! |
|
| 10 | */ |
|
| 11 | class Version20170411225256 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 ADD price_category_id INT NOT NULL'); |
|
| 22 | $this->addSql('ALTER TABLE ticket ADD CONSTRAINT FK_97A0ADA3159FD1F4 FOREIGN KEY (price_category_id) REFERENCES price_category (id)'); |
|
| 23 | $this->addSql('CREATE INDEX IDX_97A0ADA3159FD1F4 ON ticket (price_category_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 ticket DROP FOREIGN KEY FK_97A0ADA3159FD1F4'); |
|
| 35 | $this->addSql('DROP INDEX IDX_97A0ADA3159FD1F4 ON ticket'); |
|
| 36 | $this->addSql('ALTER TABLE ticket DROP price_category_id'); |
|
| 37 | } |
|
| 38 | } |
|
| 39 | ||
