https://www.mediawiki.org/wiki/Special:Code/MediaWiki/114890
Revision: 114890
Author: kaldari
Date: 2012-04-13 21:22:00 +0000 (Fri, 13 Apr 2012)
Log Message:
-----------
follow-up to r114884 - including the patch file
Added Paths:
-----------
trunk/extensions/PageTriage/sql/PageTriageTimestamps.patch.sql
Added: trunk/extensions/PageTriage/sql/PageTriageTimestamps.patch.sql
===================================================================
--- trunk/extensions/PageTriage/sql/PageTriageTimestamps.patch.sql
(rev 0)
+++ trunk/extensions/PageTriage/sql/PageTriageTimestamps.patch.sql
2012-04-13 21:22:00 UTC (rev 114890)
@@ -0,0 +1,4 @@
+-- Update table to have separate timestamps for created and updated
+ALTER TABLE /*_*/pagetriage_page CHANGE ptrp_timestamp ptrp_created VARBINARY(
14 ) NOT NULL;
+ALTER TABLE /*_*/pagetriage_page ADD ptrp_tags_updated VARBINARY( 14 ) NOT
NULL;
+CREATE INDEX /*i*/ptrp_tags_updated ON /*_*/pagetriage_page
(ptrp_tags_updated);
\ No newline at end of file
_______________________________________________
MediaWiki-CVS mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-cvs
