diff options
| author |  Alexandre Alapetite <alexandre@alapetite.fr>
| 2022-05-09 15:59:21 +0200 |
|---|---|---|
| committer |  GitHub <noreply@github.com>
| 2022-05-09 15:59:21 +0200 |
| commit | 9d1930d9adb4f56ae12209d3d01f4a1ed1af8503 (patch) | |
| tree | e0f61d1a5f8162d78304577477674d5471efa0a6 /app/SQL/install.sql.pgsql.php | |
| parent | 893d4d14c06fcb72835f8e152cd6f22f3209263e (diff) | |
Allow many (20k+) feeds (#4347)
* Allow many (20k+) feeds
Fix errors such as `SQL error listWhereRaw: ERROR: value "42926" is out of range for type smallint`
Start of UI performance improvements accordingly.
Diffstat (limited to 'app/SQL/install.sql.pgsql.php')
| -rw-r--r-- | app/SQL/install.sql.pgsql.php | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/app/SQL/install.sql.pgsql.php b/app/SQL/install.sql.pgsql.php index aa9fbbc3f..58381bb11 100644 --- a/app/SQL/install.sql.pgsql.php +++ b/app/SQL/install.sql.pgsql.php @@ -14,7 +14,7 @@ CREATE TABLE IF NOT EXISTS `_feed` ( "id" SERIAL PRIMARY KEY, "url" VARCHAR(511) UNIQUE NOT NULL, "kind" SMALLINT DEFAULT 0, -- 1.20.0 - "category" SMALLINT DEFAULT 0, + "category" INT DEFAULT 0, -- 1.20.0 "name" VARCHAR(255) NOT NULL, "website" VARCHAR(255), "description" TEXT, @@ -44,7 +44,7 @@ CREATE TABLE IF NOT EXISTS `_entry` ( "hash" BYTEA, "is_read" SMALLINT NOT NULL DEFAULT 0, "is_favorite" SMALLINT NOT NULL DEFAULT 0, - "id_feed" SMALLINT, + "id_feed" INT, -- 1.20.0 "tags" VARCHAR(1023), FOREIGN KEY ("id_feed") REFERENCES `_feed` ("id") ON DELETE CASCADE ON UPDATE CASCADE, UNIQUE ("id_feed","guid") @@ -77,7 +77,7 @@ CREATE TABLE IF NOT EXISTS `_entrytmp` ( -- v1.7 "hash" BYTEA, "is_read" SMALLINT NOT NULL DEFAULT 0, "is_favorite" SMALLINT NOT NULL DEFAULT 0, - "id_feed" SMALLINT, + "id_feed" INT, -- 1.20.0 "tags" VARCHAR(1023), FOREIGN KEY ("id_feed") REFERENCES `_feed` ("id") ON DELETE CASCADE ON UPDATE CASCADE, UNIQUE ("id_feed","guid") @@ -92,7 +92,7 @@ CREATE TABLE IF NOT EXISTS `_tag` ( -- v1.12 "attributes" TEXT ); CREATE TABLE IF NOT EXISTS `_entrytag` ( - "id_tag" SMALLINT, + "id_tag" INT, -- 1.20.0 "id_entry" BIGINT, PRIMARY KEY ("id_tag","id_entry"), FOREIGN KEY ("id_tag") REFERENCES `_tag` ("id") ON DELETE CASCADE ON UPDATE CASCADE, |