Login | Register For Free | Help
Search for: (Advanced)

Mailing List Archive: Wikipedia: Mediawiki-CVS
SVN: [114890] trunk/extensions/PageTriage/sql/PageTriageTimestamps.patch. sql
 

Index | Next | Previous | View Flat


kaldari at svn

Apr 13, 2012, 2:22 PM


Views: 70
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

Subject User Time
SVN: [114890] trunk/extensions/PageTriage/sql/PageTriageTimestamps.patch. sql kaldari at svn Apr 13, 2012, 2:22 PM

  Index | Next | Previous | View Flat
 
 


Interested in having your list archived? Contact Gossamer Threads
 
  Web Applications & Managed Hosting Powered by Gossamer Threads Inc.