From fa1640fee3488d8666e4db2895ab9fed57a21d88 Mon Sep 17 00:00:00 2001 From: Max Semenik Date: Thu, 22 Oct 2009 18:04:08 +0000 Subject: [PATCH] Finished bringing SQLite updater in par with MySQL --- maintenance/sqlite/archives/patch-log_user_text.sql | 5 +++++ maintenance/updaters.inc | 6 +++++- 2 files changed, 10 insertions(+), 1 deletion(-) create mode 100644 maintenance/sqlite/archives/patch-log_user_text.sql diff --git a/maintenance/sqlite/archives/patch-log_user_text.sql b/maintenance/sqlite/archives/patch-log_user_text.sql new file mode 100644 index 0000000000..c7fcc75f9d --- /dev/null +++ b/maintenance/sqlite/archives/patch-log_user_text.sql @@ -0,0 +1,5 @@ +ALTER TABLE /*$wgDBprefix*/logging ADD COLUMN log_user_text TEXT NOT NULL default ''; +ALTER TABLE /*$wgDBprefix*/logging ADD COLUMN log_page INTEGER NULL; + +CREATE INDEX /*i*/log_user_type_time ON /*_*/logging (log_user, log_type, log_timestamp); +CREATE INDEX /*i*/log_page_id_time ON /*_*/logging (log_page,log_timestamp); diff --git a/maintenance/updaters.inc b/maintenance/updaters.inc index 47d5672678..3f0a9f24e4 100644 --- a/maintenance/updaters.inc +++ b/maintenance/updaters.inc @@ -183,8 +183,12 @@ $wgUpdates = array( array( 'add_table', 'user_properties', 'patch-user_properties.sql' ), array( 'add_table', 'log_search', 'patch-log_search.sql' ), array( 'do_log_search_population' ), - array( 'add_field', 'redirect', 'rd_interwiki', 'patch-rd_interwiki.sql' ), + array( 'add_field', 'logging', 'log_user_text', 'patch-log_user_text.sql' ), array( 'add_table', 'l10n_cache', 'patch-l10n_cache.sql' ), + array( 'add_table', 'external_user', 'patch-external_user.sql' ), + array( 'add_index', 'log_search', 'ls_field_val', 'patch-log_search-rename-index.sql' ), + array( 'add_index', 'change_tag', 'change_tag_rc_tag', 'patch-change_tag-indexes.sql' ), + array( 'add_field', 'redirect', 'rd_interwiki', 'patch-rd_interwiki.sql' ), ), ); -- 2.20.1