Split down patch-comment-table.sql

[lhc/web/wiklou.git] / maintenance / archives / patch-log_search.sql

diff --git a/maintenance/archives/patch-log_search.sql b/maintenance/archives/patch-log_search.sql
index c992d3a..8d92030 100644 (file)
--- a/maintenance/archives/patch-log_search.sql
+++ b/maintenance/archives/patch-log_search.sql
@@ -1,9 +1,10 @@
 CREATE TABLE /*_*/log_search (
-       -- The type of ID (rev ID, log ID, timestamp, other)
-       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
-);
-CREATE INDEX /*i*/log_field_value ON /*_*/log_search (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
+) /*$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);