diff options
Diffstat (limited to 'app/DoctrineMigrations/Version20160410190541.php')
-rw-r--r-- | app/DoctrineMigrations/Version20160410190541.php | 11 |
1 files changed, 6 insertions, 5 deletions
diff --git a/app/DoctrineMigrations/Version20160410190541.php b/app/DoctrineMigrations/Version20160410190541.php index c41b0465..f034b0e4 100644 --- a/app/DoctrineMigrations/Version20160410190541.php +++ b/app/DoctrineMigrations/Version20160410190541.php | |||
@@ -30,11 +30,12 @@ class Version20160410190541 extends AbstractMigration implements ContainerAwareI | |||
30 | public function up(Schema $schema) | 30 | public function up(Schema $schema) |
31 | { | 31 | { |
32 | if ($this->connection->getDatabasePlatform()->getName() == 'postgresql') { | 32 | if ($this->connection->getDatabasePlatform()->getName() == 'postgresql') { |
33 | $this->addSql('ALTER TABLE '.$this->getTable('entry').' ADD uuid UUID DEFAULT NULL'); | 33 | $this->addSql('ALTER TABLE "'.$this->getTable('entry').'" ADD uuid UUID DEFAULT NULL'); |
34 | } else { | 34 | } else { |
35 | $this->addSql('ALTER TABLE '.$this->getTable('entry').' ADD uuid LONGTEXT DEFAULT NULL'); | 35 | $this->addSql('ALTER TABLE "'.$this->getTable('entry').'" ADD uuid LONGTEXT DEFAULT NULL'); |
36 | } | 36 | } |
37 | $this->addSql("INSERT INTO ".$this->getTable('craue_config_setting')." (name, value, section) VALUES ('share_public', '1', 'entry')"); | 37 | |
38 | $this->addSql("INSERT INTO \"".$this->getTable('craue_config_setting')."\" (name, value, section) VALUES ('share_public', '1', 'entry')"); | ||
38 | } | 39 | } |
39 | 40 | ||
40 | /** | 41 | /** |
@@ -44,7 +45,7 @@ class Version20160410190541 extends AbstractMigration implements ContainerAwareI | |||
44 | { | 45 | { |
45 | $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'sqlite', 'This down migration can\'t be executed on SQLite databases, because SQLite don\'t support DROP COLUMN.'); | 46 | $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'sqlite', 'This down migration can\'t be executed on SQLite databases, because SQLite don\'t support DROP COLUMN.'); |
46 | 47 | ||
47 | $this->addSql('ALTER TABLE '.$this->getTable('entry').' DROP uuid'); | 48 | $this->addSql('ALTER TABLE "'.$this->getTable('entry').'" DROP uuid'); |
48 | $this->addSql("DELETE FROM ".$this->getTable('craue_config_setting')." WHERE name = 'share_public'"); | 49 | $this->addSql("DELETE FROM \"".$this->getTable('craue_config_setting')."\" WHERE name = 'share_public'"); |
49 | } | 50 | } |
50 | } | 51 | } |