|
1
|
|
|
<?php |
|
2
|
|
|
|
|
3
|
|
|
namespace Application\Migrations; |
|
4
|
|
|
|
|
5
|
|
|
use Doctrine\DBAL\Migrations\AbstractMigration; |
|
6
|
|
|
use Doctrine\DBAL\Schema\Schema; |
|
7
|
|
|
|
|
8
|
|
|
/** |
|
9
|
|
|
* Auto-generated Migration: Please modify to your needs! |
|
10
|
|
|
*/ |
|
11
|
|
|
class Version20170326151604 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('CREATE TABLE customer_order (id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid_binary)\', status enum(\'free\', \'booked\', \'ordered\', \'opened\', \'closed\'), createdAt DATETIME NOT NULL, updatedAt DATETIME DEFAULT NULL, deletedAt DATETIME DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB'); |
|
22
|
|
|
$this->addSql('CREATE TABLE ticket (id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid_binary)\', seat_id INT NOT NULL, performance_event_id INT NOT NULL, setDate DATETIME NOT NULL, setNumber VARCHAR(10) NOT NULL, price INT NOT NULL, status enum(\'free\', \'booked\', \'paid\', \'offline\'), createdAt DATETIME NOT NULL, updatedAt DATETIME DEFAULT NULL, deletedAt DATETIME DEFAULT NULL, customerOrder_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:uuid_binary)\', INDEX IDX_97A0ADA3C1DAFE35 (seat_id), INDEX IDX_97A0ADA3FAEA8C89 (performance_event_id), INDEX IDX_97A0ADA31C7C4AAD (customerOrder_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB'); |
|
23
|
|
|
$this->addSql('ALTER TABLE ticket ADD CONSTRAINT FK_97A0ADA3C1DAFE35 FOREIGN KEY (seat_id) REFERENCES seat (id)'); |
|
24
|
|
|
$this->addSql('ALTER TABLE ticket ADD CONSTRAINT FK_97A0ADA3FAEA8C89 FOREIGN KEY (performance_event_id) REFERENCES performance_schedule (id)'); |
|
25
|
|
|
$this->addSql('ALTER TABLE ticket ADD CONSTRAINT FK_97A0ADA31C7C4AAD FOREIGN KEY (customerOrder_id) REFERENCES customer_order (id)'); |
|
26
|
|
|
} |
|
27
|
|
|
|
|
28
|
|
|
/** |
|
29
|
|
|
* @param Schema $schema |
|
30
|
|
|
*/ |
|
31
|
|
|
public function down(Schema $schema) |
|
32
|
|
|
{ |
|
33
|
|
|
// this down() migration is auto-generated, please modify it to your needs |
|
34
|
|
|
$this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.'); |
|
35
|
|
|
|
|
36
|
|
|
$this->addSql('ALTER TABLE ticket DROP FOREIGN KEY FK_97A0ADA31C7C4AAD'); |
|
37
|
|
|
$this->addSql('DROP TABLE customer_order'); |
|
38
|
|
|
$this->addSql('DROP TABLE ticket'); |
|
39
|
|
|
} |
|
40
|
|
|
} |
|
41
|
|
|
|
geekhub-php /
CheTheatre
