diff options
| author | Alexandre Alapetite <alexandre@alapetite.fr> | 2017-03-26 22:08:17 +0200 |
|---|---|---|
| committer | Alexandre Alapetite <alexandre@alapetite.fr> | 2017-03-26 22:08:17 +0200 |
| commit | bc580c5905522143cb3d73a37641f7bf21225545 (patch) | |
| tree | 242f437cd0d4d59931f151701bd000421de57a9a /app/SQL/install.sql.pgsql.php | |
| parent | fbdc22f75a896363d6c0f1a5b1d84adf8209fb88 (diff) | |
| download | freshrss-bc580c5905522143cb3d73a37641f7bf21225545.tar.gz freshrss-bc580c5905522143cb3d73a37641f7bf21225545.zip | |
SQL index auto added
At the same time as the new temp table
Diffstat (limited to 'app/SQL/install.sql.pgsql.php')
| -rw-r--r-- | app/SQL/install.sql.pgsql.php | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/app/SQL/install.sql.pgsql.php b/app/SQL/install.sql.pgsql.php index ca4dfa925..74c6d1b79 100644 --- a/app/SQL/install.sql.pgsql.php +++ b/app/SQL/install.sql.pgsql.php @@ -50,7 +50,6 @@ $SQL_CREATE_TABLES = array( 'CREATE INDEX %1$sis_favorite_index ON "%1$sentry" ("is_favorite");', 'CREATE INDEX %1$sis_read_index ON "%1$sentry" ("is_read");', 'CREATE INDEX %1$sentry_lastSeen_index ON "%1$sentry" ("lastSeen");', -'CREATE INDEX %1$sentry_feed_read_index ON "%1$sentry" ("id_feed","is_read");', //v1.7 //TODO: Auto add this index to existing version 'INSERT INTO "%1$scategory" (name) SELECT \'%2$s\' WHERE NOT EXISTS (SELECT id FROM "%1$scategory" WHERE id = 1);', ); @@ -75,6 +74,8 @@ $SQL_CREATE_TABLE_ENTRYTMP = array( UNIQUE ("id_feed","guid") );', 'CREATE INDEX %1$sentrytmp_date_index ON "%1$sentrytmp" ("date");', + +'CREATE INDEX %1$sentry_feed_read_index ON "%1$sentry" ("id_feed","is_read");', //v1.7 ); global $SQL_INSERT_FEEDS; |