From 3bdfc7cba14ee6a7262b4cfbec444692f49499a8 Mon Sep 17 00:00:00 2001 From: Chad Horohoe Date: Thu, 8 Jul 2010 13:58:42 +0000 Subject: [PATCH] Add optional ul_value blob to updatelog so it can store more useful things --- maintenance/archives/patch-ul_value.sql | 4 ++++ maintenance/tables.sql | 3 ++- maintenance/updaters.inc | 6 ++++-- 3 files changed, 10 insertions(+), 3 deletions(-) create mode 100644 maintenance/archives/patch-ul_value.sql diff --git a/maintenance/archives/patch-ul_value.sql b/maintenance/archives/patch-ul_value.sql new file mode 100644 index 0000000000..50f4e9a8d7 --- /dev/null +++ b/maintenance/archives/patch-ul_value.sql @@ -0,0 +1,4 @@ +-- Add the ul_value column to updatelog + +ALTER TABLE /*_*/updatelog + add ul_value blob; diff --git a/maintenance/tables.sql b/maintenance/tables.sql index fe6f265810..99ddb77d9f 100644 --- a/maintenance/tables.sql +++ b/maintenance/tables.sql @@ -1311,7 +1311,8 @@ CREATE UNIQUE INDEX /*i*/pp_page_propname ON /*_*/page_props (pp_page,pp_propnam -- A table to log updates, one text key row per update. CREATE TABLE /*_*/updatelog ( - ul_key varchar(255) NOT NULL PRIMARY KEY + ul_key varchar(255) NOT NULL PRIMARY KEY, + ul_value blob ) /*$wgDBTableOptions*/; diff --git a/maintenance/updaters.inc b/maintenance/updaters.inc index a642a454fc..9ea5057783 100644 --- a/maintenance/updaters.inc +++ b/maintenance/updaters.inc @@ -176,6 +176,7 @@ $wgUpdates = array( // 1.17 array( 'add_table', 'iwlinks', 'patch-iwlinks.sql' ), array( 'add_index', 'iwlinks', 'iwl_prefix_from_title', 'patch-rename-iwl_prefix.sql' ), + array( 'add_field', 'updatelog', 'ul_value', 'patch-ul_value.sql' ), ), 'sqlite' => array( @@ -205,8 +206,9 @@ $wgUpdates = array( array( 'sqlite_setup_searchindex' ), // 1.17 - array( 'add_table', 'iwlinks', 'patch-iwlinks.sql' ), - array( 'add_index', 'iwlinks', 'iwl_prefix_from_title', 'patch-rename-iwl_prefix.sql' ), + array( 'add_table', 'iwlinks', 'patch-iwlinks.sql' ), + array( 'add_index', 'iwlinks', 'iwl_prefix_from_title', 'patch-rename-iwl_prefix.sql' ), + array( 'add_field', 'updatelog', 'ul_value', 'patch-ul_value.sql' ), ), ); -- 2.20.1