r99451 MediaWiki - Code Review archive

Repository:MediaWiki
Revision:< r99450‎ | r99451 | r99452 >
Date:00:14, 11 October 2011
Author:raindrift
Status:deferred (Comments)
Tags:
Comment:
Adding SQL for storing when a page has been reviewed, and by whom.
Modified paths:
  • /trunk/extensions/PageTriage/sql (added) (history)
  • /trunk/extensions/PageTriage/sql/PageTriage.sql (added) (history)

Diff [purge]

Index: trunk/extensions/PageTriage/sql/PageTriage.sql
——@@ -0,0 +1,12 @@
 2+
 3+-- mapping table for user to pages
 4+CREATE TABLE /*_*/pagetriage (
 5+ ptr_user_id int UNSIGNED NOT NULL,
 6+ ptr_recentchanges_id int NOT NULL,
 7+ ptr_timestamp varbinary(14) NOT NULL
 8+) /*$wgDBTableOptions*/;
 9+
 10+CREATE UNIQUE INDEX /*i*/ptr_user_rc ON /*_*/pagetriage (ptr_user_id,ptr_recentchanges_id);
 11+
 12+-- this stores when a page was checked. we'll be interested in that sometimes.
 13+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
114 + native

Comments

#Comment by Nikerabbit (talk | contribs)   14:54, 11 October 2011

In core all fields that refer to the user_id are named foo_user, so bar_user_id is a bit inconsistent.

Status & tagging log