diff options
| author | Thomas Citharel <tcit@tcit.fr> | 2016-10-15 14:42:46 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2016-10-15 14:42:46 +0200 |
| commit | 76f2123defe40d7315597938f182fed386707765 (patch) | |
| tree | 56760496bdb917314dfef54306411fddbf1c21e2 /app/DoctrineMigrations/Version20160916201049.php | |
| parent | 7131f94274a7a4fb15e822d3f8ef5fa4d9594144 (diff) | |
| parent | 4c79c51f998fbec0caba3cf20291a9a54916af09 (diff) | |
| download | wallabag-76f2123defe40d7315597938f182fed386707765.tar.gz wallabag-76f2123defe40d7315597938f182fed386707765.tar.zst wallabag-76f2123defe40d7315597938f182fed386707765.zip | |
Merge pull request #2412 from wallabag/fix-postgres-migration
Fix PostgreSQL migrations
Diffstat (limited to 'app/DoctrineMigrations/Version20160916201049.php')
| -rw-r--r-- | app/DoctrineMigrations/Version20160916201049.php | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/app/DoctrineMigrations/Version20160916201049.php b/app/DoctrineMigrations/Version20160916201049.php index 202901e6..0d2edf9e 100644 --- a/app/DoctrineMigrations/Version20160916201049.php +++ b/app/DoctrineMigrations/Version20160916201049.php | |||
| @@ -29,8 +29,8 @@ class Version20160916201049 extends AbstractMigration implements ContainerAwareI | |||
| 29 | */ | 29 | */ |
| 30 | public function up(Schema $schema) | 30 | public function up(Schema $schema) |
| 31 | { | 31 | { |
| 32 | $this->addSql('ALTER TABLE '.$this->getTable('config').' ADD pocket_consumer_key VARCHAR(255) DEFAULT NULL'); | 32 | $this->addSql('ALTER TABLE "'.$this->getTable('config').'" ADD pocket_consumer_key VARCHAR(255) DEFAULT NULL'); |
| 33 | $this->addSql("DELETE FROM `".$this->getTable('craue_config_setting')."` WHERE `name` = 'pocket_consumer_key';"); | 33 | $this->addSql("DELETE FROM \"".$this->getTable('craue_config_setting')."\" WHERE name = 'pocket_consumer_key';"); |
| 34 | } | 34 | } |
| 35 | 35 | ||
| 36 | /** | 36 | /** |
| @@ -40,7 +40,7 @@ class Version20160916201049 extends AbstractMigration implements ContainerAwareI | |||
| 40 | { | 40 | { |
| 41 | $this->abortIf($this->connection->getDatabasePlatform()->getName() == 'sqlite', 'Migration can only be executed safely on \'mysql\' or \'postgresql\'.'); | 41 | $this->abortIf($this->connection->getDatabasePlatform()->getName() == 'sqlite', 'Migration can only be executed safely on \'mysql\' or \'postgresql\'.'); |
| 42 | 42 | ||
| 43 | $this->addSql('ALTER TABLE `'.$this->getTable('config').'` DROP pocket_consumer_key'); | 43 | $this->addSql('ALTER TABLE "'.$this->getTable('config').'" DROP pocket_consumer_key'); |
| 44 | $this->addSql("INSERT INTO `".$this->getTable('craue_config_setting')."` (`name`, `value`, `section`) VALUES ('pocket_consumer_key', NULL, 'import')"); | 44 | $this->addSql("INSERT INTO \"".$this->getTable('craue_config_setting')."\" (name, value, section) VALUES ('pocket_consumer_key', NULL, 'import')"); |
| 45 | } | 45 | } |
| 46 | } | 46 | } |