OpencachingDeutschland /
oc-server3
| @@ 11-34 (lines=24) @@ | ||
| 8 | /** |
|
| 9 | * Auto-generated Migration: Please modify to your needs! |
|
| 10 | */ |
|
| 11 | class Version20170510222222 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('INSERT IGNORE INTO sysconfig VALUES (\'syslog_maillog_lastdate\', \'2017-05-01 00:00:01\')'); |
|
| 22 | } |
|
| 23 | ||
| 24 | /** |
|
| 25 | * @param Schema $schema |
|
| 26 | */ |
|
| 27 | public function down(Schema $schema) |
|
| 28 | { |
|
| 29 | // this down() migration is auto-generated, please modify it to your needs |
|
| 30 | $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.'); |
|
| 31 | ||
| 32 | $this->addSql('DROP TABLE field_note'); |
|
| 33 | } |
|
| 34 | } |
|
| 35 | ||
| @@ 11-55 (lines=45) @@ | ||
| 8 | /** |
|
| 9 | * Auto-generated Migration: Please modify to your needs! |
|
| 10 | */ |
|
| 11 | class Version20170516084212 extends AbstractMigration |
|
| 12 | { |
|
| 13 | /** |
|
| 14 | * @param Schema $schema |
|
| 15 | */ |
|
| 16 | public function up(Schema $schema) |
|
| 17 | { |
|
| 18 | $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.'); |
|
| 19 | ||
| 20 | $this->addSql(' |
|
| 21 | CREATE TABLE page_blocks( |
|
| 22 | id INT AUTO_INCREMENT NOT null, |
|
| 23 | page_group_id INT NOT null, |
|
| 24 | title VARCHAR(255) NOT null, |
|
| 25 | html LONGTEXT NOT null, |
|
| 26 | position INT DEFAULT null, |
|
| 27 | last_changed DATETIME NOT null, |
|
| 28 | active TINYINT(1) NOT null, |
|
| 29 | PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB; |
|
| 30 | '); |
|
| 31 | ||
| 32 | $this->addSql(' |
|
| 33 | CREATE TABLE page_groups( |
|
| 34 | id INT AUTO_INCREMENT NOT null, |
|
| 35 | slug VARCHAR(80) NOT null, |
|
| 36 | meta_keywords VARCHAR(255) NOT null, |
|
| 37 | meta_description VARCHAR(255) DEFAULT null, |
|
| 38 | meta_social LONGTEXT DEFAULT null, |
|
| 39 | last_changed DATETIME NOT null, |
|
| 40 | active TINYINT(1) NOT null, |
|
| 41 | PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB; |
|
| 42 | '); |
|
| 43 | ||
| 44 | $this->addSql('ALTER TABLE page_blocks ADD FOREIGN KEY (page_group_id) REFERENCES page_groups(id);'); |
|
| 45 | } |
|
| 46 | ||
| 47 | /** |
|
| 48 | * @param Schema $schema |
|
| 49 | */ |
|
| 50 | public function down(Schema $schema) |
|
| 51 | { |
|
| 52 | // this down() migration is auto-generated, please modify it to your needs |
|
| 53 | ||
| 54 | } |
|
| 55 | } |
|
| 56 | ||
