From 6964e122dd6a5baf08712549c0b76618534a0b7b Mon Sep 17 00:00:00 2001 From: Chad Horohoe Date: Wed, 1 Jul 2009 00:55:45 +0000 Subject: [PATCH] (bug 19428) PG and MySQL followups to r52503. Patch by OverlordQ --- maintenance/archives/patch-l10n_cache.sql | 2 +- maintenance/postgres/archives/patch-l10n_cache.sql | 8 ++++++++ maintenance/postgres/tables.sql | 6 ++++++ maintenance/tables.sql | 2 +- maintenance/updaters.inc | 1 + 5 files changed, 17 insertions(+), 2 deletions(-) create mode 100644 maintenance/postgres/archives/patch-l10n_cache.sql diff --git a/maintenance/archives/patch-l10n_cache.sql b/maintenance/archives/patch-l10n_cache.sql index 32a04f994b..4c865d71f0 100644 --- a/maintenance/archives/patch-l10n_cache.sql +++ b/maintenance/archives/patch-l10n_cache.sql @@ -3,6 +3,6 @@ CREATE TABLE /*_*/l10n_cache ( lc_lang varbinary(32) NOT NULL, lc_key varchar(255) NOT NULL, lc_value mediumblob NOT NULL -); +) /*$wgDBTableOptions*/; CREATE INDEX /*i*/lc_lang_key ON /*_*/l10n_cache (lc_lang, lc_key); diff --git a/maintenance/postgres/archives/patch-l10n_cache.sql b/maintenance/postgres/archives/patch-l10n_cache.sql new file mode 100644 index 0000000000..9b39b1b7a5 --- /dev/null +++ b/maintenance/postgres/archives/patch-l10n_cache.sql @@ -0,0 +1,8 @@ +CREATE TABLE l10n_cache ( + lc_lang TEXT NOT NULL, + lc_key TEXT NOT NULL, + lc_value TEXT NOT NULL +); +CREATE INDEX l10n_cache_lc_lang_key ON l10n_cache (lc_lang, lc_key); + + diff --git a/maintenance/postgres/tables.sql b/maintenance/postgres/tables.sql index fe0c26de3a..ae48cc02ca 100644 --- a/maintenance/postgres/tables.sql +++ b/maintenance/postgres/tables.sql @@ -616,3 +616,9 @@ CREATE TABLE mediawiki_version ( INSERT INTO mediawiki_version (type,mw_version,sql_version,sql_date) VALUES ('Creation','??','$LastChangedRevision$','$LastChangedDate$'); +CREATE TABLE l10n_cache ( + lc_lang TEXT NOT NULL, + lc_key TEXT NOT NULL, + lc_value TEXT NOT NULL +); +CREATE INDEX l10n_cache_lc_lang_key ON l10n_cache (lc_lang, lc_key); diff --git a/maintenance/tables.sql b/maintenance/tables.sql index dc4c449e14..4297b716da 100644 --- a/maintenance/tables.sql +++ b/maintenance/tables.sql @@ -1318,7 +1318,7 @@ CREATE TABLE /*_*/l10n_cache ( lc_key varchar(255) NOT NULL, -- Value lc_value mediumblob NOT NULL -); +) /*$wgDBTableOptions*/; CREATE INDEX /*i*/lc_lang_key ON /*_*/l10n_cache (lc_lang, lc_key); -- vim: sw=2 sts=2 et diff --git a/maintenance/updaters.inc b/maintenance/updaters.inc index 5352d06578..7b425a74f2 100644 --- a/maintenance/updaters.inc +++ b/maintenance/updaters.inc @@ -1489,6 +1489,7 @@ function do_postgres_updates() { array('valid_tag', 'patch-change_tag.sql'), array('user_properties', 'patch-user_properties.sql'), array('log_search', 'patch-log_search.sql'), + array('l10n_cache', 'patch-l10n_cache.sql'), ); $newcols = array( -- 2.20.1