diff options
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, |