diff options
-rw-r--r-- | app/DoctrineMigrations/Version20161106113822.php | 8 | ||||
-rw-r--r-- | app/DoctrineMigrations/Version20161117071626.php (renamed from app/DoctrineMigrations/Version20161109150755.php) | 14 |
2 files changed, 14 insertions, 8 deletions
diff --git a/app/DoctrineMigrations/Version20161106113822.php b/app/DoctrineMigrations/Version20161106113822.php index 41e64a4a..edca54f5 100644 --- a/app/DoctrineMigrations/Version20161106113822.php +++ b/app/DoctrineMigrations/Version20161106113822.php | |||
@@ -4,8 +4,10 @@ namespace Application\Migrations; | |||
4 | 4 | ||
5 | use Doctrine\DBAL\Migrations\AbstractMigration; | 5 | use Doctrine\DBAL\Migrations\AbstractMigration; |
6 | use Doctrine\DBAL\Schema\Schema; | 6 | use Doctrine\DBAL\Schema\Schema; |
7 | use Symfony\Component\DependencyInjection\ContainerAwareInterface; | ||
8 | use Symfony\Component\DependencyInjection\ContainerInterface; | ||
7 | 9 | ||
8 | class Version20161106113822 extends AbstractMigration | 10 | class Version20161106113822 extends AbstractMigration implements ContainerAwareInterface |
9 | { | 11 | { |
10 | /** | 12 | /** |
11 | * @var ContainerInterface | 13 | * @var ContainerInterface |
@@ -27,7 +29,7 @@ class Version20161106113822 extends AbstractMigration | |||
27 | */ | 29 | */ |
28 | public function up(Schema $schema) | 30 | public function up(Schema $schema) |
29 | { | 31 | { |
30 | $this->addSql('ALTER TABLE "'.$this->getTable('config').'" ADD action_mark_as_read INT DEFAULT 0'); | 32 | $this->addSql('ALTER TABLE '.$this->getTable('config').' ADD action_mark_as_read INT DEFAULT 0'); |
31 | } | 33 | } |
32 | 34 | ||
33 | /** | 35 | /** |
@@ -37,6 +39,6 @@ class Version20161106113822 extends AbstractMigration | |||
37 | { | 39 | { |
38 | $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'sqlite', 'This down migration can\'t be executed on SQLite databases, because SQLite don\'t support DROP COLUMN.'); | 40 | $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'sqlite', 'This down migration can\'t be executed on SQLite databases, because SQLite don\'t support DROP COLUMN.'); |
39 | 41 | ||
40 | $this->addSql('ALTER TABLE "'.$this->getTable('config').'" DROP action_mark_as_read'); | 42 | $this->addSql('ALTER TABLE '.$this->getTable('config').' DROP action_mark_as_read'); |
41 | } | 43 | } |
42 | } | 44 | } |
diff --git a/app/DoctrineMigrations/Version20161109150755.php b/app/DoctrineMigrations/Version20161117071626.php index e4d269c4..9ae55b5f 100644 --- a/app/DoctrineMigrations/Version20161109150755.php +++ b/app/DoctrineMigrations/Version20161117071626.php | |||
@@ -7,34 +7,38 @@ use Doctrine\DBAL\Schema\Schema; | |||
7 | use Symfony\Component\DependencyInjection\ContainerAwareInterface; | 7 | use Symfony\Component\DependencyInjection\ContainerAwareInterface; |
8 | use Symfony\Component\DependencyInjection\ContainerInterface; | 8 | use Symfony\Component\DependencyInjection\ContainerInterface; |
9 | 9 | ||
10 | class Version20161031132655 extends AbstractMigration implements ContainerAwareInterface | 10 | class Version20161117071626 extends AbstractMigration implements ContainerAwareInterface |
11 | { | 11 | { |
12 | /** | 12 | /** |
13 | * @var ContainerInterface | 13 | * @var ContainerInterface |
14 | */ | 14 | */ |
15 | private $container; | 15 | private $container; |
16 | |||
16 | public function setContainer(ContainerInterface $container = null) | 17 | public function setContainer(ContainerInterface $container = null) |
17 | { | 18 | { |
18 | $this->container = $container; | 19 | $this->container = $container; |
19 | } | 20 | } |
21 | |||
20 | private function getTable($tableName) | 22 | private function getTable($tableName) |
21 | { | 23 | { |
22 | return $this->container->getParameter('database_table_prefix') . $tableName; | 24 | return $this->container->getParameter('database_table_prefix') . $tableName; |
23 | } | 25 | } |
26 | |||
24 | /** | 27 | /** |
25 | * @param Schema $schema | 28 | * @param Schema $schema |
26 | */ | 29 | */ |
27 | public function up(Schema $schema) | 30 | public function up(Schema $schema) |
28 | { | 31 | { |
29 | $this->addSql("INSERT INTO \"".$this->getTable('craue_config_setting')."\" (name, value, section) VALUES ('share_unmark', 0, 'entry')"); | 32 | $this->addSql("INSERT INTO ".$this->getTable('craue_config_setting')." (name, value, section) VALUES ('share_unmark', 0, 'entry')"); |
30 | $this->addSql("INSERT INTO \"".$this->getTable('craue_config_setting')."\" (name, value, section) VALUES ('unmark_url', 'https://unmark.it', 'entry')"); | 33 | $this->addSql("INSERT INTO ".$this->getTable('craue_config_setting')." (name, value, section) VALUES ('unmark_url', 'https://unmark.it', 'entry')"); |
31 | } | 34 | } |
35 | |||
32 | /** | 36 | /** |
33 | * @param Schema $schema | 37 | * @param Schema $schema |
34 | */ | 38 | */ |
35 | public function down(Schema $schema) | 39 | public function down(Schema $schema) |
36 | { | 40 | { |
37 | $this->addSql("DELETE FROM \"".$this->getTable('craue_config_setting')."\" WHERE name = 'share_unmark';"); | 41 | $this->addSql("DELETE FROM ".$this->getTable('craue_config_setting')." WHERE name = 'share_unmark';"); |
38 | $this->addSql("DELETE FROM \"".$this->getTable('craue_config_setting')."\" WHERE name = 'unmark_url';"); | 42 | $this->addSql("DELETE FROM ".$this->getTable('craue_config_setting')." WHERE name = 'unmark_url';"); |
39 | } | 43 | } |
40 | } | 44 | } |