From 6712f9d26a8578dd7e6718adfcb3a81879bfdff9 Mon Sep 17 00:00:00 2001 From: Aaron Schulz Date: Thu, 18 Sep 2008 18:26:54 +0000 Subject: [PATCH] Add log_user_text. Useful for log dumps, which are needed by rev_deleted --- maintenance/archives/patch-log_user_text.sql | 2 ++ maintenance/tables.sql | 4 +++- maintenance/updaters.inc | 5 +++-- 3 files changed, 8 insertions(+), 3 deletions(-) create mode 100644 maintenance/archives/patch-log_user_text.sql diff --git a/maintenance/archives/patch-log_user_text.sql b/maintenance/archives/patch-log_user_text.sql new file mode 100644 index 0000000000..b455b210c9 --- /dev/null +++ b/maintenance/archives/patch-log_user_text.sql @@ -0,0 +1,2 @@ +ALTER TABLE /*$wgDBprefix*/logging + ADD log_user_text varchar(255) binary NOT NULL default ''; diff --git a/maintenance/tables.sql b/maintenance/tables.sql index d3512c5077..662d03b16f 100644 --- a/maintenance/tables.sql +++ b/maintenance/tables.sql @@ -1076,7 +1076,9 @@ CREATE TABLE /*$wgDBprefix*/logging ( log_timestamp binary(14) NOT NULL default '19700101000000', -- The user who performed this action; key to user_id - log_user int unsigned NOT NULL default 0, + log_user int unsigned NOT NULL default 0, + -- Text username or IP address of the editor. + log_user_text varchar(255) binary NOT NULL default '', -- Key to the page affected. Where a user is the target, -- this will point to the user page. diff --git a/maintenance/updaters.inc b/maintenance/updaters.inc index cd12da26a8..dc30dbca6c 100644 --- a/maintenance/updaters.inc +++ b/maintenance/updaters.inc @@ -145,8 +145,9 @@ $wgMysqlUpdates = array( array( 'update_password_format' ), // 1.14 - array( 'add_field', 'site_stats', 'ss_active_users', 'patch-ss_active_users.sql' ), - array( 'do_active_users_init' ) + array( 'add_field', 'site_stats', 'ss_active_users', 'patch-ss_active_users.sql' ), + array( 'do_active_users_init' ), + array( 'add_field', 'logging', 'log_user_text', 'patch-log_user_text.sql' ), ); -- 2.20.1