diff options
-rw-r--r-- | app/DoctrineMigrations/Version20190806130304.php | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/app/DoctrineMigrations/Version20190806130304.php b/app/DoctrineMigrations/Version20190806130304.php index b1e8f8d0..1449bdd3 100644 --- a/app/DoctrineMigrations/Version20190806130304.php +++ b/app/DoctrineMigrations/Version20190806130304.php | |||
@@ -40,7 +40,7 @@ final class Version20190806130304 extends WallabagMigration | |||
40 | $this->addSql('CREATE INDEX user_starred ON ' . $this->getTable('entry') . ' (user_id, is_starred, starred_at)'); | 40 | $this->addSql('CREATE INDEX user_starred ON ' . $this->getTable('entry') . ' (user_id, is_starred, starred_at)'); |
41 | break; | 41 | break; |
42 | case 'postgresql': | 42 | case 'postgresql': |
43 | $this->addSql('ALTER TABLE ' . $this->getTable('entry') . ' ALTER COLUMN language VARCHAR(20) DEFAULT NULL'); | 43 | $this->addSql('ALTER TABLE ' . $this->getTable('entry') . ' ALTER language TYPE VARCHAR(20)'); |
44 | $this->addSql('CREATE INDEX user_language ON ' . $this->getTable('entry') . ' (language, user_id)'); | 44 | $this->addSql('CREATE INDEX user_language ON ' . $this->getTable('entry') . ' (language, user_id)'); |
45 | $this->addSql('CREATE INDEX user_starred ON ' . $this->getTable('entry') . ' (user_id, is_starred, starred_at)'); | 45 | $this->addSql('CREATE INDEX user_starred ON ' . $this->getTable('entry') . ' (user_id, is_starred, starred_at)'); |
46 | break; | 46 | break; |
@@ -77,7 +77,7 @@ final class Version20190806130304 extends WallabagMigration | |||
77 | $this->addSql('DROP INDEX user_starred ON ' . $this->getTable('entry')); | 77 | $this->addSql('DROP INDEX user_starred ON ' . $this->getTable('entry')); |
78 | break; | 78 | break; |
79 | case 'postgresql': | 79 | case 'postgresql': |
80 | $this->addSql('ALTER TABLE ' . $this->getTable('entry') . ' ALTER COLUMN language LONGTEXT DEFAULT NULL'); | 80 | $this->addSql('ALTER TABLE ' . $this->getTable('entry') . ' ALTER language TYPE TEXT'); |
81 | $this->addSql('DROP INDEX user_language ON ' . $this->getTable('entry')); | 81 | $this->addSql('DROP INDEX user_language ON ' . $this->getTable('entry')); |
82 | $this->addSql('DROP INDEX user_starred ON ' . $this->getTable('entry')); | 82 | $this->addSql('DROP INDEX user_starred ON ' . $this->getTable('entry')); |
83 | break; | 83 | break; |