http://www.mediawiki.org/wiki/Special:Code/MediaWiki/90829
Revision: 90829
Author: ashley
Date: 2011-06-26 14:05:35 +0000 (Sun, 26 Jun 2011)
Log Message:
-----------
SocialProfile: add stats_links_submitted and stats_links_approved columns to
user_stats table. These are only used by the LinkFilter extension, so you most
likely don't need to care about these. Also tweaked user_stats.sql for SQLite
compatibility by moving the PRIMARY KEY declaration to where it belongs and
changing /*$wgDBprefix*/ to /*_*/
Modified Paths:
--------------
trunk/extensions/SocialProfile/UserStats/user_stats.postgres.sql
trunk/extensions/SocialProfile/UserStats/user_stats.sql
Modified: trunk/extensions/SocialProfile/UserStats/user_stats.postgres.sql
===================================================================
--- trunk/extensions/SocialProfile/UserStats/user_stats.postgres.sql
2011-06-26 12:48:45 UTC (rev 90828)
+++ trunk/extensions/SocialProfile/UserStats/user_stats.postgres.sql
2011-06-26 14:05:35 UTC (rev 90829)
@@ -43,5 +43,7 @@
stats_quiz_questions_correct INTEGER DEFAULT 0,
stats_quiz_points INTEGER DEFAULT 0,
stats_quiz_questions_created INTEGER DEFAULT 0,
- stats_quiz_questions_correct_percent FLOAT DEFAULT 0
+ stats_quiz_questions_correct_percent FLOAT DEFAULT 0,
+ stats_links_submitted INTEGER NOT NULL DEFAULT 0,
+ stats_links_approved INTEGER NOT NULL DEFAULT 0
);
Modified: trunk/extensions/SocialProfile/UserStats/user_stats.sql
===================================================================
--- trunk/extensions/SocialProfile/UserStats/user_stats.sql 2011-06-26
12:48:45 UTC (rev 90828)
+++ trunk/extensions/SocialProfile/UserStats/user_stats.sql 2011-06-26
14:05:35 UTC (rev 90829)
@@ -2,9 +2,9 @@
-- Table structure for table `user_stats`
--
-CREATE TABLE /*$wgDBprefix*/user_stats (
+CREATE TABLE /*_*/user_stats (
`stats_year_id` int(2) NOT NULL default '0',
- `stats_user_id` int(11) NOT NULL default '0',
+ `stats_user_id` int(11) NOT NULL default '0' PRIMARY KEY,
`stats_user_name` varchar(255) NOT NULL default '',
`stats_user_image_count` int(11) NOT NULL default '0',
`stats_comment_count` int(11) NOT NULL default '0',
@@ -46,5 +46,6 @@
`stats_quiz_points` int(11) default '0',
`stats_quiz_questions_created` int(11) default '0',
`stats_quiz_questions_correct_percent` float default '0',
- PRIMARY KEY (`stats_user_id`)
+ `stats_links_submitted` int(11) NOT NULL default '0',
+ `stats_links_approved` int(11) NOT NULL default '0'
) DEFAULT CHARSET=utf8;
_______________________________________________
MediaWiki-CVS mailing list
MediaWiki-CVS@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-cvs
