From eb878c2aa2726c1a4fada07474027be8d703c5b7 Mon Sep 17 00:00:00 2001 From: Aaron Schulz Date: Tue, 14 Apr 2009 15:38:51 +0000 Subject: [PATCH] Follow up to r49454: redid indexing --- maintenance/archives/patch-log_search.sql | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) diff --git a/maintenance/archives/patch-log_search.sql b/maintenance/archives/patch-log_search.sql index c992d3a0ce..939523ac75 100644 --- a/maintenance/archives/patch-log_search.sql +++ b/maintenance/archives/patch-log_search.sql @@ -4,6 +4,7 @@ CREATE TABLE /*_*/log_search ( -- The value of the ID ls_value varchar(255) NOT NULL, -- Key to log_id - ls_log_id int unsigned NOT NULL default 0 + ls_log_id int unsigned NOT NULL default 0, + PRIMARY KEY (ls_field,ls_value,ls_log_id) ); -CREATE INDEX /*i*/log_field_value ON /*_*/log_search (ls_field,ls_value,ls_log_id); +CREATE INDEX /*i*/ls_log_id ON /*_*/log_search (ls_log_id); -- 2.20.1