From c97af49669619b8e34df3481787b514f68343382 Mon Sep 17 00:00:00 2001 From: Brion Vibber Date: Thu, 18 Sep 2008 19:38:56 +0000 Subject: [PATCH] Back out r41001 for the moment ("Add log_user_text. Useful for log dumps, which are needed by rev_deleted") If applied in one piece, it should probably fill in log_user_text... but that would be very slow in production environments. If it has to be able to work with an online update in production, it should probably allow for a NULL log_user_text value rather than '', which is eery --- maintenance/archives/patch-log_user_text.sql | 2 -- maintenance/tables.sql | 4 +--- maintenance/updaters.inc | 5 ++--- 3 files changed, 3 insertions(+), 8 deletions(-) delete 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 deleted file mode 100644 index b455b210c9..0000000000 --- a/maintenance/archives/patch-log_user_text.sql +++ /dev/null @@ -1,2 +0,0 @@ -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 662d03b16f..d3512c5077 100644 --- a/maintenance/tables.sql +++ b/maintenance/tables.sql @@ -1076,9 +1076,7 @@ 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, - -- Text username or IP address of the editor. - log_user_text varchar(255) binary NOT NULL default '', + log_user int unsigned NOT NULL default 0, -- 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 dc30dbca6c..cd12da26a8 100644 --- a/maintenance/updaters.inc +++ b/maintenance/updaters.inc @@ -145,9 +145,8 @@ $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', 'logging', 'log_user_text', 'patch-log_user_text.sql' ), + array( 'add_field', 'site_stats', 'ss_active_users', 'patch-ss_active_users.sql' ), + array( 'do_active_users_init' ) ); -- 2.20.1