diff options
| author | Jeremy Benoist <jeremy.benoist@gmail.com> | 2016-10-09 21:35:04 +0200 |
|---|---|---|
| committer | Jeremy Benoist <jeremy.benoist@gmail.com> | 2016-10-09 21:35:04 +0200 |
| commit | 4c79c51f998fbec0caba3cf20291a9a54916af09 (patch) | |
| tree | 4b5af222e20784993f7cb1e606949965f8709260 /app/DoctrineMigrations/Version20160916201049.php | |
| parent | 47508f004fe9a17a8012187f37032f4155d507f4 (diff) | |
| download | wallabag-4c79c51f998fbec0caba3cf20291a9a54916af09.tar.gz wallabag-4c79c51f998fbec0caba3cf20291a9a54916af09.tar.zst wallabag-4c79c51f998fbec0caba3cf20291a9a54916af09.zip | |
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 | } |