OpencachingDeutschland /
oc-server3
| @@ 11-29 (lines=19) @@ | ||
| 8 | /** |
|
| 9 | * Migration to add syslog_maillog_lastdate to table sysconfig. |
|
| 10 | */ |
|
| 11 | class Version20170510222222 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('INSERT IGNORE INTO sysconfig VALUES (\'syslog_maillog_lastdate\', \'2017-05-01 00:00:01\')'); |
|
| 21 | } |
|
| 22 | ||
| 23 | /** |
|
| 24 | * @param Schema $schema |
|
| 25 | */ |
|
| 26 | public function down(Schema $schema) |
|
| 27 | { |
|
| 28 | } |
|
| 29 | } |
|
| 30 | ||
| @@ 11-42 (lines=32) @@ | ||
| 8 | /** |
|
| 9 | * Migration to add impressum and tos to the page table. |
|
| 10 | */ |
|
| 11 | class Version20170526212910 extends AbstractMigration |
|
| 12 | { |
|
| 13 | /** |
|
| 14 | * @param Schema $schema |
|
| 15 | * |
|
| 16 | * @return void |
|
| 17 | */ |
|
| 18 | public function up(Schema $schema) |
|
| 19 | { |
|
| 20 | $this->abortIf( |
|
| 21 | $this->connection->getDatabasePlatform()->getName() != 'mysql', |
|
| 22 | 'Migration can only be executed safely on \'mysql\'.' |
|
| 23 | ); |
|
| 24 | ||
| 25 | $this->addSql(" |
|
| 26 | INSERT INTO page (slug, meta_keywords, meta_description, meta_social, updated_at, active) |
|
| 27 | VALUE ('impressum','','','', NOW(),1); |
|
| 28 | ||
| 29 | INSERT INTO page (slug, meta_keywords, meta_description, meta_social, updated_at, active) |
|
| 30 | VALUE ('tos','','','',NOW(),1); |
|
| 31 | "); |
|
| 32 | } |
|
| 33 | ||
| 34 | /** |
|
| 35 | * @param Schema $schema |
|
| 36 | * |
|
| 37 | * @return void |
|
| 38 | */ |
|
| 39 | public function down(Schema $schema) |
|
| 40 | { |
|
| 41 | } |
|
| 42 | } |
|
| 43 | ||
