From 9d1930d9adb4f56ae12209d3d01f4a1ed1af8503 Mon Sep 17 00:00:00 2001 From: Alexandre Alapetite Date: Mon, 9 May 2022 15:59:21 +0200 Subject: 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. --- app/SQL/install.sql.pgsql.php | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) (limited to 'app/SQL/install.sql.pgsql.php') 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, -- cgit v1.2.3