From 7aadbb783bb197bb0fe3e59aa346a6c53d8db304 Mon Sep 17 00:00:00 2001 From: Aaron Schulz Date: Thu, 4 Jun 2009 12:57:22 +0000 Subject: [PATCH] Tweaked r49468 - sqllite fix --- maintenance/archives/patch-log_search.sql | 4 ++-- maintenance/tables.sql | 4 ++-- 2 files changed, 4 insertions(+), 4 deletions(-) diff --git a/maintenance/archives/patch-log_search.sql b/maintenance/archives/patch-log_search.sql index e396330b8f..8d92030b26 100644 --- a/maintenance/archives/patch-log_search.sql +++ b/maintenance/archives/patch-log_search.sql @@ -4,7 +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, - PRIMARY KEY (ls_field,ls_value,ls_log_id) + ls_log_id int unsigned NOT NULL default 0 ) /*$wgDBTableOptions*/; +CREATE UNIQUE INDEX /*i*/ls_field_val ON /*_*/log_search (ls_field,ls_value,ls_log_id); CREATE INDEX /*i*/ls_log_id ON /*_*/log_search (ls_log_id); diff --git a/maintenance/tables.sql b/maintenance/tables.sql index 73dbe8da07..4e7924587a 100644 --- a/maintenance/tables.sql +++ b/maintenance/tables.sql @@ -1130,9 +1130,9 @@ 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, - PRIMARY KEY (ls_field,ls_value,ls_log_id) + ls_log_id int unsigned NOT NULL default 0 ) /*$wgDBTableOptions*/; +CREATE UNIQUE INDEX /*i*/ls_field_val 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