| Index: trunk/extensions/SocialProfile/UserStats/user_stats.postgres.sql |
| — | — | @@ -43,5 +43,7 @@ |
| 44 | 44 | stats_quiz_questions_correct INTEGER DEFAULT 0, |
| 45 | 45 | stats_quiz_points INTEGER DEFAULT 0, |
| 46 | 46 | stats_quiz_questions_created INTEGER DEFAULT 0, |
| 47 | | - stats_quiz_questions_correct_percent FLOAT DEFAULT 0 |
| | 47 | + stats_quiz_questions_correct_percent FLOAT DEFAULT 0, |
| | 48 | + stats_links_submitted INTEGER NOT NULL DEFAULT 0, |
| | 49 | + stats_links_approved INTEGER NOT NULL DEFAULT 0 |
| 48 | 50 | ); |
| Index: trunk/extensions/SocialProfile/UserStats/user_stats.sql |
| — | — | @@ -2,9 +2,9 @@ |
| 3 | 3 | -- Table structure for table `user_stats` |
| 4 | 4 | -- |
| 5 | 5 | |
| 6 | | -CREATE TABLE /*$wgDBprefix*/user_stats ( |
| | 6 | +CREATE TABLE /*_*/user_stats ( |
| 7 | 7 | `stats_year_id` int(2) NOT NULL default '0', |
| 8 | | - `stats_user_id` int(11) NOT NULL default '0', |
| | 8 | + `stats_user_id` int(11) NOT NULL default '0' PRIMARY KEY, |
| 9 | 9 | `stats_user_name` varchar(255) NOT NULL default '', |
| 10 | 10 | `stats_user_image_count` int(11) NOT NULL default '0', |
| 11 | 11 | `stats_comment_count` int(11) NOT NULL default '0', |
| — | — | @@ -46,5 +46,6 @@ |
| 47 | 47 | `stats_quiz_points` int(11) default '0', |
| 48 | 48 | `stats_quiz_questions_created` int(11) default '0', |
| 49 | 49 | `stats_quiz_questions_correct_percent` float default '0', |
| 50 | | - PRIMARY KEY (`stats_user_id`) |
| | 50 | + `stats_links_submitted` int(11) NOT NULL default '0', |
| | 51 | + `stats_links_approved` int(11) NOT NULL default '0' |
| 51 | 52 | ) DEFAULT CHARSET=utf8; |