http://www.mediawiki.org/wiki/Special:Code/MediaWiki/99451
Revision: 99451
Author: raindrift
Date: 2011-10-11 00:14:48 +0000 (Tue, 11 Oct 2011)
Log Message:
-----------
Adding SQL for storing when a page has been reviewed, and by whom.
Added Paths:
-----------
trunk/extensions/PageTriage/sql/
trunk/extensions/PageTriage/sql/PageTriage.sql
Added: trunk/extensions/PageTriage/sql/PageTriage.sql
===================================================================
--- trunk/extensions/PageTriage/sql/PageTriage.sql
(rev 0)
+++ trunk/extensions/PageTriage/sql/PageTriage.sql 2011-10-11 00:14:48 UTC
(rev 99451)
@@ -0,0 +1,12 @@
+
+-- mapping table for user to pages
+CREATE TABLE /*_*/pagetriage (
+ ptr_user_id int UNSIGNED NOT NULL,
+ ptr_recentchanges_id int NOT NULL,
+ ptr_timestamp varbinary(14) NOT NULL
+) /*$wgDBTableOptions*/;
+
+CREATE UNIQUE INDEX /*i*/ptr_user_rc ON /*_*/pagetriage
(ptr_user_id,ptr_recentchanges_id);
+
+-- this stores when a page was checked. we'll be interested in that sometimes.
+CREATE INDEX /*i*/ptr_timestamp ON /*_*/pagetriage (ptr_timestamp);
\ No newline at end of file
Property changes on: trunk/extensions/PageTriage/sql/PageTriage.sql
___________________________________________________________________
Added: svn:eol-style
+ native
_______________________________________________
MediaWiki-CVS mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-cvs
