|
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 Version20170731113707 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 lexik_trans_unit (id INT AUTO_INCREMENT NOT NULL, key_name VARCHAR(255) NOT NULL, domain VARCHAR(255) NOT NULL, created_at DATETIME DEFAULT NULL, updated_at DATETIME DEFAULT NULL, UNIQUE INDEX key_domain_idx (key_name, domain), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB'); |
|
22
|
|
|
$this->addSql('CREATE TABLE lexik_trans_unit_translations (id INT AUTO_INCREMENT NOT NULL, file_id INT DEFAULT NULL, trans_unit_id INT DEFAULT NULL, locale VARCHAR(10) NOT NULL, content LONGTEXT NOT NULL, created_at DATETIME DEFAULT NULL, updated_at DATETIME DEFAULT NULL, INDEX IDX_B0AA394493CB796C (file_id), INDEX IDX_B0AA3944C3C583C9 (trans_unit_id), UNIQUE INDEX trans_unit_locale_idx (trans_unit_id, locale), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB'); |
|
23
|
|
|
$this->addSql('CREATE TABLE lexik_translation_file (id INT AUTO_INCREMENT NOT NULL, domain VARCHAR(255) NOT NULL, locale VARCHAR(10) NOT NULL, extention VARCHAR(10) NOT NULL, path VARCHAR(255) NOT NULL, hash VARCHAR(255) NOT NULL, UNIQUE INDEX hash_idx (hash), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB'); |
|
24
|
|
|
$this->addSql('CREATE TABLE review_translations (id INT AUTO_INCREMENT NOT NULL, object_id INT DEFAULT NULL, locale VARCHAR(8) NOT NULL, field VARCHAR(32) NOT NULL, content LONGTEXT DEFAULT NULL, INDEX IDX_9F7A217C232D562B (object_id), UNIQUE INDEX review_lookup_unique_idx (locale, object_id, field), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB'); |
|
25
|
|
|
$this->addSql('CREATE TABLE event_news_translations (id INT AUTO_INCREMENT NOT NULL, object_id INT DEFAULT NULL, locale VARCHAR(8) NOT NULL, field VARCHAR(32) NOT NULL, content LONGTEXT DEFAULT NULL, INDEX IDX_B564E951232D562B (object_id), UNIQUE INDEX event_news_lookup_unique_idx (locale, object_id, field), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB'); |
|
26
|
|
|
$this->addSql('CREATE TABLE page_translations (id INT AUTO_INCREMENT NOT NULL, object_id INT DEFAULT NULL, locale VARCHAR(8) NOT NULL, field VARCHAR(32) NOT NULL, content LONGTEXT DEFAULT NULL, INDEX IDX_78AB76C9232D562B (object_id), UNIQUE INDEX page_lookup_unique_idx (locale, object_id, field), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB'); |
|
27
|
|
|
$this->addSql('CREATE TABLE news_translations (id INT AUTO_INCREMENT NOT NULL, object_id INT DEFAULT NULL, locale VARCHAR(8) NOT NULL, field VARCHAR(32) NOT NULL, content LONGTEXT DEFAULT NULL, INDEX IDX_20FDB330232D562B (object_id), UNIQUE INDEX news_lookup_unique_idx (locale, object_id, field), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB'); |
|
28
|
|
|
$this->addSql('CREATE TABLE event_page_translations (id INT AUTO_INCREMENT NOT NULL, object_id INT DEFAULT NULL, locale VARCHAR(8) NOT NULL, field VARCHAR(32) NOT NULL, content LONGTEXT DEFAULT NULL, INDEX IDX_ED322CA8232D562B (object_id), UNIQUE INDEX event_page_lookup_unique_idx (locale, object_id, field), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB'); |
|
29
|
|
|
$this->addSql('CREATE TABLE promo_code_translations (id INT AUTO_INCREMENT NOT NULL, object_id INT DEFAULT NULL, locale VARCHAR(8) NOT NULL, field VARCHAR(32) NOT NULL, content LONGTEXT DEFAULT NULL, INDEX IDX_89D0C96F232D562B (object_id), UNIQUE INDEX promo_code_lookup_unique_idx (locale, object_id, field), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB'); |
|
30
|
|
|
$this->addSql('CREATE TABLE event_translations (id INT AUTO_INCREMENT NOT NULL, object_id INT DEFAULT NULL, locale VARCHAR(8) NOT NULL, field VARCHAR(32) NOT NULL, content LONGTEXT DEFAULT NULL, INDEX IDX_2BA4D074232D562B (object_id), UNIQUE INDEX event_lookup_unique_idx (locale, object_id, field), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB'); |
|
31
|
|
|
$this->addSql('CREATE TABLE speaker_translations (id INT AUTO_INCREMENT NOT NULL, object_id INT DEFAULT NULL, locale VARCHAR(8) NOT NULL, field VARCHAR(32) NOT NULL, content LONGTEXT DEFAULT NULL, INDEX IDX_6AB8CDA5232D562B (object_id), UNIQUE INDEX speaker_lookup_unique_idx (locale, object_id, field), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB'); |
|
32
|
|
|
$this->addSql('CREATE TABLE sponsor_translations (id INT AUTO_INCREMENT NOT NULL, object_id INT DEFAULT NULL, locale VARCHAR(8) NOT NULL, field VARCHAR(32) NOT NULL, content LONGTEXT DEFAULT NULL, INDEX IDX_4C84E738232D562B (object_id), UNIQUE INDEX sponsor_lookup_unique_idx (locale, object_id, field), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB'); |
|
33
|
|
|
$this->addSql('CREATE TABLE category_translations (id INT AUTO_INCREMENT NOT NULL, object_id INT DEFAULT NULL, locale VARCHAR(8) NOT NULL, field VARCHAR(32) NOT NULL, content LONGTEXT DEFAULT NULL, INDEX IDX_1C60F915232D562B (object_id), UNIQUE INDEX category_lookup_unique_idx (locale, object_id, field), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB'); |
|
34
|
|
|
$this->addSql('ALTER TABLE lexik_trans_unit_translations ADD CONSTRAINT FK_B0AA394493CB796C FOREIGN KEY (file_id) REFERENCES lexik_translation_file (id)'); |
|
35
|
|
|
$this->addSql('ALTER TABLE lexik_trans_unit_translations ADD CONSTRAINT FK_B0AA3944C3C583C9 FOREIGN KEY (trans_unit_id) REFERENCES lexik_trans_unit (id)'); |
|
36
|
|
|
$this->addSql('ALTER TABLE review_translations ADD CONSTRAINT FK_9F7A217C232D562B FOREIGN KEY (object_id) REFERENCES event__reviews (id) ON DELETE CASCADE'); |
|
37
|
|
|
$this->addSql('ALTER TABLE event_news_translations ADD CONSTRAINT FK_B564E951232D562B FOREIGN KEY (object_id) REFERENCES event__news (id) ON DELETE CASCADE'); |
|
38
|
|
|
$this->addSql('ALTER TABLE page_translations ADD CONSTRAINT FK_78AB76C9232D562B FOREIGN KEY (object_id) REFERENCES pages (id) ON DELETE CASCADE'); |
|
39
|
|
|
$this->addSql('ALTER TABLE news_translations ADD CONSTRAINT FK_20FDB330232D562B FOREIGN KEY (object_id) REFERENCES news (id) ON DELETE CASCADE'); |
|
40
|
|
|
$this->addSql('ALTER TABLE event_page_translations ADD CONSTRAINT FK_ED322CA8232D562B FOREIGN KEY (object_id) REFERENCES event__pages (id) ON DELETE CASCADE'); |
|
41
|
|
|
$this->addSql('ALTER TABLE promo_code_translations ADD CONSTRAINT FK_89D0C96F232D562B FOREIGN KEY (object_id) REFERENCES event__promo_code (id) ON DELETE CASCADE'); |
|
42
|
|
|
$this->addSql('ALTER TABLE event_translations ADD CONSTRAINT FK_2BA4D074232D562B FOREIGN KEY (object_id) REFERENCES event__events (id) ON DELETE CASCADE'); |
|
43
|
|
|
$this->addSql('ALTER TABLE speaker_translations ADD CONSTRAINT FK_6AB8CDA5232D562B FOREIGN KEY (object_id) REFERENCES event__speakers (id) ON DELETE CASCADE'); |
|
44
|
|
|
$this->addSql('ALTER TABLE sponsor_translations ADD CONSTRAINT FK_4C84E738232D562B FOREIGN KEY (object_id) REFERENCES sponsors (id) ON DELETE CASCADE'); |
|
45
|
|
|
$this->addSql('ALTER TABLE category_translations ADD CONSTRAINT FK_1C60F915232D562B FOREIGN KEY (object_id) REFERENCES sponsors_category (id) ON DELETE CASCADE'); |
|
46
|
|
|
$this->addSql('ALTER TABLE news ADD meta_keywords VARCHAR(255) DEFAULT NULL, ADD meta_description VARCHAR(255) DEFAULT NULL'); |
|
47
|
|
|
$this->addSql('ALTER TABLE event__news ADD meta_keywords VARCHAR(255) DEFAULT NULL, ADD meta_description VARCHAR(255) DEFAULT NULL'); |
|
48
|
|
|
} |
|
49
|
|
|
|
|
50
|
|
|
/** |
|
51
|
|
|
* @param Schema $schema |
|
52
|
|
|
*/ |
|
53
|
|
|
public function down(Schema $schema) |
|
54
|
|
|
{ |
|
55
|
|
|
// this down() migration is auto-generated, please modify it to your needs |
|
56
|
|
|
$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.'); |
|
57
|
|
|
|
|
58
|
|
|
$this->addSql('ALTER TABLE lexik_trans_unit_translations DROP FOREIGN KEY FK_B0AA3944C3C583C9'); |
|
59
|
|
|
$this->addSql('ALTER TABLE lexik_trans_unit_translations DROP FOREIGN KEY FK_B0AA394493CB796C'); |
|
60
|
|
|
$this->addSql('DROP TABLE lexik_trans_unit'); |
|
61
|
|
|
$this->addSql('DROP TABLE lexik_trans_unit_translations'); |
|
62
|
|
|
$this->addSql('DROP TABLE lexik_translation_file'); |
|
63
|
|
|
$this->addSql('DROP TABLE review_translations'); |
|
64
|
|
|
$this->addSql('DROP TABLE event_news_translations'); |
|
65
|
|
|
$this->addSql('DROP TABLE page_translations'); |
|
66
|
|
|
$this->addSql('DROP TABLE news_translations'); |
|
67
|
|
|
$this->addSql('DROP TABLE event_page_translations'); |
|
68
|
|
|
$this->addSql('DROP TABLE promo_code_translations'); |
|
69
|
|
|
$this->addSql('DROP TABLE event_translations'); |
|
70
|
|
|
$this->addSql('DROP TABLE speaker_translations'); |
|
71
|
|
|
$this->addSql('DROP TABLE sponsor_translations'); |
|
72
|
|
|
$this->addSql('DROP TABLE category_translations'); |
|
73
|
|
|
$this->addSql('ALTER TABLE event__news DROP meta_keywords, DROP meta_description'); |
|
74
|
|
|
$this->addSql('ALTER TABLE news DROP meta_keywords, DROP meta_description'); |
|
75
|
|
|
} |
|
76
|
|
|
} |
|
77
|
|
|
|
stfalcon /
fwdays
