From af503fefa7f8bbd41dbb955036dd74cae66a21db Mon Sep 17 00:00:00 2001 From: Greg Sabino Mullane Date: Thu, 21 Feb 2008 20:04:00 +0000 Subject: [PATCH] Add table page_props to Postgres schema. --- maintenance/postgres/archives/patch-page_props.sql | 9 +++++++++ maintenance/postgres/compare_schemas.pl | 2 ++ maintenance/postgres/tables.sql | 7 +++++++ maintenance/updaters.inc | 1 + 4 files changed, 19 insertions(+) create mode 100644 maintenance/postgres/archives/patch-page_props.sql diff --git a/maintenance/postgres/archives/patch-page_props.sql b/maintenance/postgres/archives/patch-page_props.sql new file mode 100644 index 0000000000..ab70702251 --- /dev/null +++ b/maintenance/postgres/archives/patch-page_props.sql @@ -0,0 +1,9 @@ + +CREATE TABLE page_props ( + pp_page INTEGER NOT NULL REFERENCES page (page_id) ON DELETE CASCADE, + pp_propname TEXT NOT NULL, + pp_value TEXT NOT NULL +); +ALTER TABLE page_props ADD CONSTRAINT page_props_pk PRIMARY KEY (pp_page,pp_propname); +CREATE INDEX page_props_propname ON page_props (pp_propname); + diff --git a/maintenance/postgres/compare_schemas.pl b/maintenance/postgres/compare_schemas.pl index 3842fce417..821bdb769c 100644 --- a/maintenance/postgres/compare_schemas.pl +++ b/maintenance/postgres/compare_schemas.pl @@ -314,6 +314,8 @@ oi_minor_mime varbinary(32) TEXT oi_sha1 varbinary(32) TEXT old_flags tinyblob TEXT old_text mediumblob TEXT +pp_propname varbinary(60) TEXT +pp_value blob TEXT page_restrictions tinyblob TEXT # CSV string pf_server varchar(30) TEXT pr_level varbinary(60) TEXT diff --git a/maintenance/postgres/tables.sql b/maintenance/postgres/tables.sql index 500d663166..420b9be6ca 100644 --- a/maintenance/postgres/tables.sql +++ b/maintenance/postgres/tables.sql @@ -123,6 +123,13 @@ CREATE TABLE page_restrictions ( ); ALTER TABLE page_restrictions ADD CONSTRAINT page_restrictions_pk PRIMARY KEY (pr_page,pr_type); +CREATE TABLE page_props ( + pp_page INTEGER NOT NULL REFERENCES page (page_id) ON DELETE CASCADE, + pp_propname TEXT NOT NULL, + pp_value TEXT NOT NULL +); +ALTER TABLE page_props ADD CONSTRAINT page_props_pk PRIMARY KEY (pp_page,pp_propname); +CREATE INDEX page_props_propname ON page_props (pp_propname); CREATE TABLE archive ( ar_namespace SMALLINT NOT NULL, diff --git a/maintenance/updaters.inc b/maintenance/updaters.inc index ef55e63142..86e87014d5 100644 --- a/maintenance/updaters.inc +++ b/maintenance/updaters.inc @@ -1329,6 +1329,7 @@ function do_postgres_updates() { array("mwuser", "patch-mwuser.sql"), array("pagecontent", "patch-pagecontent.sql"), array("querycachetwo", "patch-querycachetwo.sql"), + array("page_props", "patch-page_props.sql"), array("page_restrictions", "patch-page_restrictions.sql"), array("profiling", "patch-profiling.sql"), array("protected_titles", "patch-protected_titles.sql"), -- 2.20.1