From fd23af9a2f5b2021aa781c5e39ba3e5c9df5419c Mon Sep 17 00:00:00 2001 From: Greg Sabino Mullane Date: Wed, 19 Mar 2008 13:02:49 +0000 Subject: [PATCH] Add 'category' table to Postgres schema. --- maintenance/postgres/archives/patch-category.sql | 14 ++++++++++++++ maintenance/postgres/tables.sql | 11 +++++++++++ maintenance/updaters.inc | 9 +++++---- 3 files changed, 30 insertions(+), 4 deletions(-) create mode 100644 maintenance/postgres/archives/patch-category.sql diff --git a/maintenance/postgres/archives/patch-category.sql b/maintenance/postgres/archives/patch-category.sql new file mode 100644 index 0000000000..9986cdaf6e --- /dev/null +++ b/maintenance/postgres/archives/patch-category.sql @@ -0,0 +1,14 @@ + +CREATE SEQUENCE category_id_seq; + +CREATE TABLE category ( + cat_id INTEGER NOT NULL PRIMARY KEY DEFAULT nextval('category_id_seq'), + cat_title TEXT NOT NULL, + cat_pages INTEGER NOT NULL DEFAULT 0, + cat_subcats INTEGER NOT NULL DEFAULT 0, + cat_files INTEGER NOT NULL DEFAULT 0, + cat_hidden SMALLINT NOT NULL DEFAULT 0 +); + +CREATE INDEX category_title ON category(cat_title, cat_pages); + diff --git a/maintenance/postgres/tables.sql b/maintenance/postgres/tables.sql index a27e4b1b7a..521458a6cf 100644 --- a/maintenance/postgres/tables.sql +++ b/maintenance/postgres/tables.sql @@ -535,6 +535,17 @@ CREATE TABLE updatelog ( ); +CREATE SEQUENCE category_id_seq; +CREATE TABLE category ( + cat_id INTEGER NOT NULL PRIMARY KEY DEFAULT nextval('category_id_seq'), + cat_title TEXT NOT NULL, + cat_pages INTEGER NOT NULL DEFAULT 0, + cat_subcats INTEGER NOT NULL DEFAULT 0, + cat_files INTEGER NOT NULL DEFAULT 0, + cat_hidden SMALLINT NOT NULL DEFAULT 0 +); +CREATE INDEX category_title ON category(cat_title, cat_pages); + CREATE TABLE mediawiki_version ( type TEXT NOT NULL, mw_version TEXT NOT NULL, diff --git a/maintenance/updaters.inc b/maintenance/updaters.inc index b30c515116..8a112ddb67 100644 --- a/maintenance/updaters.inc +++ b/maintenance/updaters.inc @@ -1344,6 +1344,7 @@ function do_postgres_updates() { ); $newtables = array( + array("category", "patch-category.sql"), array("mediawiki_version", "patch-mediawiki_version.sql"), array("mwuser", "patch-mwuser.sql"), array("pagecontent", "patch-pagecontent.sql"), @@ -1410,10 +1411,10 @@ function do_postgres_updates() { array("interwiki", "iw_local", "smallint", "iw_local::smallint DEFAULT 0"), array("interwiki", "iw_trans", "smallint", "iw_trans::smallint DEFAULT 0"), array("ipblocks", "ipb_auto", "smallint", "ipb_auto::smallint DEFAULT 0"), - array("ipblocks", "ipb_anon_only", "smallint", "ipb_anon_only::smallint DEFAULT 0"), - array("ipblocks", "ipb_create_account", "smallint", "ipb_create_account::smallint DEFAULT 1"), - array("ipblocks", "ipb_enable_autoblock", "smallint", "ipb_enable_autoblock::smallint DEFAULT 1"), - array("ipblocks", "ipb_block_email", "smallint", "ipb_block_email::smallint DEFAULT 0"), + array("ipblocks", "ipb_anon_only", "smallint", "ipb_anon_only::smallint DEFAULT 0"), + array("ipblocks", "ipb_create_account", "smallint", "ipb_create_account::smallint DEFAULT 1"), + array("ipblocks", "ipb_enable_autoblock", "smallint", "ipb_enable_autoblock::smallint DEFAULT 1"), + array("ipblocks", "ipb_block_email", "smallint", "ipb_block_email::smallint DEFAULT 0"), array("ipblocks", "ipb_address", "text", "ipb_address::text"), array("ipblocks", "ipb_deleted", "smallint", "ipb_deleted::smallint"), array("math", "math_inputhash", "bytea", "decode(math_inputhash,'escape')"), -- 2.20.1