From d0a3dc38a1c346e1ff25400caf17da5912b000c3 Mon Sep 17 00:00:00 2001 From: Brion Vibber Date: Thu, 14 May 2009 22:43:57 +0000 Subject: [PATCH] Cleanup for r50567: * Include DB table options on log_search table creation * Adjust tabs->spaces in table def... sounds silly, but the tabs sometimes confuse things when cut-and-pasting into mysql command line. :) --- maintenance/archives/patch-log_search.sql | 16 ++++++++-------- maintenance/tables.sql | 16 ++++++++-------- 2 files changed, 16 insertions(+), 16 deletions(-) diff --git a/maintenance/archives/patch-log_search.sql b/maintenance/archives/patch-log_search.sql index 2c2cd0e153..e396330b8f 100644 --- a/maintenance/archives/patch-log_search.sql +++ b/maintenance/archives/patch-log_search.sql @@ -1,10 +1,10 @@ CREATE TABLE /*_*/log_search ( - -- The type of ID (rev ID, log ID, rev timestamp, username) - ls_field varbinary(32) NOT NULL, - -- The value of the ID - ls_value varchar(255) NOT NULL, - -- Key to log_id - ls_log_id int unsigned NOT NULL default 0, - PRIMARY KEY (ls_field,ls_value,ls_log_id) -); + -- The type of ID (rev ID, log ID, rev timestamp, username) + ls_field varbinary(32) NOT NULL, + -- The value of the ID + ls_value varchar(255) NOT NULL, + -- Key to log_id + ls_log_id int unsigned NOT NULL default 0, + PRIMARY KEY (ls_field,ls_value,ls_log_id) +) /*$wgDBTableOptions*/; CREATE INDEX /*i*/ls_log_id ON /*_*/log_search (ls_log_id); diff --git a/maintenance/tables.sql b/maintenance/tables.sql index 101a17784f..9ce238031d 100644 --- a/maintenance/tables.sql +++ b/maintenance/tables.sql @@ -1125,14 +1125,14 @@ CREATE INDEX /*i*/times ON /*_*/logging (log_timestamp); CREATE TABLE /*_*/log_search ( - -- The type of ID (rev ID, log ID, rev timestamp, username) - ls_field varbinary(32) NOT NULL, - -- The value of the ID - ls_value varchar(255) NOT NULL, - -- Key to log_id - ls_log_id int unsigned NOT NULL default 0, - PRIMARY KEY (ls_field,ls_value,ls_log_id) -); + -- The type of ID (rev ID, log ID, rev timestamp, username) + ls_field varbinary(32) NOT NULL, + -- The value of the ID + ls_value varchar(255) NOT NULL, + -- Key to log_id + ls_log_id int unsigned NOT NULL default 0, + PRIMARY KEY (ls_field,ls_value,ls_log_id) +) /*$wgDBTableOptions*/; CREATE INDEX /*i*/ls_log_id ON /*_*/log_search (ls_log_id); -- 2.20.1