Addshore has uploaded a new change for review. https://gerrit.wikimedia.org/r/284690
Change subject: WIP watchlist_props table ...................................................................... WIP watchlist_props table Bug: 129486 Change-Id: I0e660adeffb873b65973875db9ba79d70b2b16f4 --- A maintenance/archives/patch-watchlist_props.sql M maintenance/mssql/tables.sql M maintenance/oracle/tables.sql A maintenance/postgres/archives/patch-watchlist_props.sql M maintenance/postgres/tables.sql M maintenance/tables.sql 6 files changed, 42 insertions(+), 0 deletions(-) git pull ssh://gerrit.wikimedia.org:29418/mediawiki/core refs/changes/90/284690/1 diff --git a/maintenance/archives/patch-watchlist_props.sql b/maintenance/archives/patch-watchlist_props.sql new file mode 100644 index 0000000..09b48f3 --- /dev/null +++ b/maintenance/archives/patch-watchlist_props.sql @@ -0,0 +1,11 @@ +-- Name/value pairs indexed by wl_id +CREATE TABLE /*_*/watchlist_props ( + wlp_item int NOT NULL, + wlp_propname varbinary(60) NOT NULL, + wlp_value blob NOT NULL, + wlp_sortkey float DEFAULT NULL, + PRIMARY KEY (wlp_item,wlp_propname) +) /*$wgDBTableOptions*/; + +CREATE UNIQUE INDEX /*i*/wlp_propname_item ON /*_*/watchlist_props (wlp_propname,wlp_item); +CREATE UNIQUE INDEX /*i*/wlp_propname_sortkey_item ON /*_*/watchlist_props (wlp_propname,wlp_sortkey,wlp_item); \ No newline at end of file diff --git a/maintenance/mssql/tables.sql b/maintenance/mssql/tables.sql index 86bd735..cccef87 100644 --- a/maintenance/mssql/tables.sql +++ b/maintenance/mssql/tables.sql @@ -868,6 +868,17 @@ CREATE INDEX /*i*/namespace_title ON /*_*/watchlist (wl_namespace, wl_title); +-- Name/value pairs indexed by page_id +CREATE TABLE /*_*/watchlist_props ( + wlp_page int NOT NULL REFERENCES /*_*/watchlist(wl_id) ON DELETE CASCADE, + wlp_propname nvarchar(60) NOT NULL, + wlp_value nvarchar(max) NOT NULL +); + +CREATE UNIQUE INDEX /*i*/wlp_page_propname ON /*_*/watchlist_props (wlp_page,wlp_propname); +CREATE UNIQUE INDEX /*i*/wlp_propname_page ON /*_*/watchlist_props (wlp_propname,wlp_page); + + -- -- Our search index for the builtin MediaWiki search -- diff --git a/maintenance/oracle/tables.sql b/maintenance/oracle/tables.sql index 27c3030..f3b2b5a 100644 --- a/maintenance/oracle/tables.sql +++ b/maintenance/oracle/tables.sql @@ -448,6 +448,9 @@ CREATE INDEX &mw_prefix.watchlist_i01 ON &mw_prefix.watchlist (wl_namespace, wl_title); +-- TODO watchlist_props table + + CREATE TABLE &mw_prefix.searchindex ( si_page NUMBER NOT NULL, si_title VARCHAR2(255), diff --git a/maintenance/postgres/archives/patch-watchlist_props.sql b/maintenance/postgres/archives/patch-watchlist_props.sql new file mode 100644 index 0000000..71ef480 --- /dev/null +++ b/maintenance/postgres/archives/patch-watchlist_props.sql @@ -0,0 +1 @@ +-- TODO watchlist_props table \ No newline at end of file diff --git a/maintenance/postgres/tables.sql b/maintenance/postgres/tables.sql index 61cb198..41dcdad 100644 --- a/maintenance/postgres/tables.sql +++ b/maintenance/postgres/tables.sql @@ -461,6 +461,9 @@ CREATE INDEX wl_user_notificationtimestamp ON watchlist (wl_user, wl_notificationtimestamp); +-- TODO watchlist_props table + + CREATE TABLE interwiki ( iw_prefix TEXT NOT NULL UNIQUE, iw_url TEXT NOT NULL, diff --git a/maintenance/tables.sql b/maintenance/tables.sql index 89aeb9c..2a12753 100644 --- a/maintenance/tables.sql +++ b/maintenance/tables.sql @@ -1161,6 +1161,19 @@ CREATE INDEX /*i*/wl_user_notificationtimestamp ON /*_*/watchlist (wl_user, wl_notificationtimestamp); +-- Name/value pairs indexed by wl_id +CREATE TABLE /*_*/watchlist_props ( + wlp_item int NOT NULL, + wlp_propname varbinary(60) NOT NULL, + wlp_value blob NOT NULL, + wlp_sortkey float DEFAULT NULL, + PRIMARY KEY (wlp_item,wlp_propname) +) /*$wgDBTableOptions*/; + +CREATE UNIQUE INDEX /*i*/wlp_propname_item ON /*_*/watchlist_props (wlp_propname,wlp_item); +CREATE UNIQUE INDEX /*i*/wlp_propname_sortkey_item ON /*_*/watchlist_props (wlp_propname,wlp_sortkey,wlp_item); + + -- -- When using the default MySQL search backend, page titles -- and text are munged to strip markup, do Unicode case folding, -- To view, visit https://gerrit.wikimedia.org/r/284690 To unsubscribe, visit https://gerrit.wikimedia.org/r/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I0e660adeffb873b65973875db9ba79d70b2b16f4 Gerrit-PatchSet: 1 Gerrit-Project: mediawiki/core Gerrit-Branch: master Gerrit-Owner: Addshore <[email protected]> _______________________________________________ MediaWiki-commits mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
