From ebc9ee51527ac722eb196beca123eb916896cdc4 Mon Sep 17 00:00:00 2001 From: Greg Sabino Mullane Date: Wed, 9 Jul 2008 19:25:47 +0000 Subject: [PATCH] Add recentlinkchanges table for Postgres --- .../postgres/archives/patch-recentlinkchanges.sql | 12 ++++++++++++ maintenance/postgres/tables.sql | 13 +++++++++++++ maintenance/updaters.inc | 1 + 3 files changed, 26 insertions(+) create mode 100644 maintenance/postgres/archives/patch-recentlinkchanges.sql diff --git a/maintenance/postgres/archives/patch-recentlinkchanges.sql b/maintenance/postgres/archives/patch-recentlinkchanges.sql new file mode 100644 index 0000000000..96cc13adbc --- /dev/null +++ b/maintenance/postgres/archives/patch-recentlinkchanges.sql @@ -0,0 +1,12 @@ +CREATE SEQUENCE recentlinkchanges_rcl_id_seq; +CREATE TABLE recentlinkchanges ( + rlc_id INTEGER NOT NULL PRIMARY KEY DEFAULT nextval('recentlinkchanges_rcl_id_seq'), + rlc_type TEXT NOT NULL, + rlc_timestamp TIMESTAMPTZ NOT NULL, + rlc_action SMALLINT NOT NULL DEFAULT 0, + rlc_from INTEGER NOT NULL, + rlc_to_namespace SMALLINT, + rlc_to_title TEXT, + rlc_to_blob TEXT +); +CREATE INDEX recentlinkchanges_type ON recentlinkchanges(rlc_type); diff --git a/maintenance/postgres/tables.sql b/maintenance/postgres/tables.sql index 40a948e2b3..afabddec1a 100644 --- a/maintenance/postgres/tables.sql +++ b/maintenance/postgres/tables.sql @@ -538,6 +538,19 @@ CREATE TABLE updatelog ( ); +CREATE SEQUENCE recentlinkchanges_rcl_id_seq; +CREATE TABLE recentlinkchanges ( + rlc_id INTEGER NOT NULL PRIMARY KEY DEFAULT nextval('recentlinkchanges_rcl_id_seq'), + rlc_type TEXT NOT NULL, + rlc_timestamp TIMESTAMPTZ NOT NULL, + rlc_action SMALLINT NOT NULL DEFAULT 0, + rlc_from INTEGER NOT NULL, + rlc_to_namespace SMALLINT, + rlc_to_title TEXT, + rlc_to_blob TEXT +); +CREATE INDEX recentlinkchanges_type ON recentlinkchanges(rlc_type); + CREATE SEQUENCE category_id_seq; CREATE TABLE category ( cat_id INTEGER NOT NULL PRIMARY KEY DEFAULT nextval('category_id_seq'), diff --git a/maintenance/updaters.inc b/maintenance/updaters.inc index a882dae46f..1e1ec54a7c 100644 --- a/maintenance/updaters.inc +++ b/maintenance/updaters.inc @@ -1423,6 +1423,7 @@ function do_postgres_updates() { array("page_restrictions", "patch-page_restrictions.sql"), array("profiling", "patch-profiling.sql"), array("protected_titles", "patch-protected_titles.sql"), + array("recentlinkchanges", "patch-recentlinkchanges.sql"), array("redirect", "patch-redirect.sql"), array("updatelog", "patch-updatelog.sql"), ); -- 2.20.1