kaldari at svn
Apr 13, 2012, 2:22 PM
Views: 41
Permalink
|
|
SVN: [114890] trunk/extensions/PageTriage/sql/PageTriageTimestamps.patch. sql
|
|
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
MediaWiki-CVS [at] lists
https://lists.wikimedia.org/mailman/listinfo/mediawiki-cvs
|
SVN: [114890] trunk/extensions/PageTriage/sql/PageTriageTimestamps.patch. sql