Revision: 49454
Author: aaron
Date: 2009-04-14 02:14:05 +0000 (Tue, 14 Apr 2009)
Log Message:
-----------
Added proposed log_search table to deal with revisiondelete log extracts and
possibly other issues
Added Paths:
-----------
trunk/phase3/maintenance/archives/patch-log_search.sql
Added: trunk/phase3/maintenance/archives/patch-log_search.sql
===================================================================
--- trunk/phase3/maintenance/archives/patch-log_search.sql
(rev 0)
+++ trunk/phase3/maintenance/archives/patch-log_search.sql 2009-04-14
02:14:05 UTC (rev 49454)
@@ -0,0 +1,13 @@
+CREATE TABLE /*_*/log_search (
+ -- Key to log_type
+ ls_log_type varbinary(32) NOT NULL,
+ -- Key to log_action
+ ls_log_action varbinary(32) NOT NULL,
+ -- The type of ID (rev 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);
Property changes on: trunk/phase3/maintenance/archives/patch-log_search.sql
___________________________________________________________________
Added: svn:eol-style
+ native
_______________________________________________
MediaWiki-CVS mailing list
MediaWiki-CVS@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-cvs
