From f787b8155fb88b86842e0051aa50087f487207eb Mon Sep 17 00:00:00 2001 From: OverlordQ Date: Fri, 16 Apr 2010 02:35:37 +0000 Subject: [PATCH] Followup to r65104, PG updater/table def --- maintenance/postgres/archives/patch-iwlinks.sql | 8 ++++++++ maintenance/postgres/tables.sql | 8 ++++++++ maintenance/updaters.inc | 2 +- 3 files changed, 17 insertions(+), 1 deletion(-) create mode 100644 maintenance/postgres/archives/patch-iwlinks.sql diff --git a/maintenance/postgres/archives/patch-iwlinks.sql b/maintenance/postgres/archives/patch-iwlinks.sql new file mode 100644 index 0000000000..a24154f3a2 --- /dev/null +++ b/maintenance/postgres/archives/patch-iwlinks.sql @@ -0,0 +1,8 @@ + +CREATE TABLE iwlinks ( + iwl_from INTEGER NOT NULL DEFAULT 0, + iwl_prefix TEXT NOT NULL DEFAULT '', + iwl_title TEXT NOT NULL DEFAULT '' +); +CREATE UNIQUE INDEX iwl_from ON iwlinks (iwl_from, iwl_prefix, iwl_title); +CREATE INDEX iwl_prefix ON iwlinks (iwl_prefix, iwl_title); diff --git a/maintenance/postgres/tables.sql b/maintenance/postgres/tables.sql index a310aadc93..456a57c29f 100644 --- a/maintenance/postgres/tables.sql +++ b/maintenance/postgres/tables.sql @@ -636,3 +636,11 @@ CREATE TABLE l10n_cache ( lc_value TEXT NOT NULL ); CREATE INDEX l10n_cache_lc_lang_key ON l10n_cache (lc_lang, lc_key); + +CREATE TABLE iwlinks ( + iwl_from INTEGER NOT NULL DEFAULT 0, + iwl_prefix TEXT NOT NULL DEFAULT '', + iwl_title TEXT NOT NULL DEFAULT '' +); +CREATE UNIQUE INDEX iwl_from ON iwlinks (iwl_from, iwl_prefix, iwl_title); +CREATE INDEX iwl_prefix ON iwlinks (iwl_prefix, iwl_title); diff --git a/maintenance/updaters.inc b/maintenance/updaters.inc index 8bdfea1dbe..46110de4a3 100644 --- a/maintenance/updaters.inc +++ b/maintenance/updaters.inc @@ -1596,7 +1596,7 @@ function do_postgres_updates() { array('user_properties', 'patch-user_properties.sql'), array('log_search', 'patch-log_search.sql'), array('l10n_cache', 'patch-l10n_cache.sql'), - // @fixme add iwlinks table + array('iwlinks', 'patch-iwlinks.sql'), ); $newcols = array( -- 2.20.1