| Index: trunk/extensions/ArticleAssessmentPilot/ArticleAssessmentPilot.sql |
| — | — | @@ -14,16 +14,16 @@ |
| 15 | 15 | aa_user_id integer NOT NULL, |
| 16 | 16 | -- unique user identifier |
| 17 | 17 | aa_user_text varchar(255) binary NOT NULL, |
| 18 | | - aa_user_anon_token binary(32) DEFAULT NULL, |
| | 18 | + aa_user_anon_token binary(32) DEFAULT '', |
| 19 | 19 | -- Foreign key to revision.rev_id |
| 20 | 20 | aa_revision integer unsigned NOT NULL, |
| 21 | 21 | -- MW Timestamp |
| 22 | | - aa_timestamp binary(14) NOT NULL default '', |
| | 22 | + aa_timestamp binary(14) NOT NULL DEFAULT '', |
| 23 | 23 | -- Rating info |
| 24 | 24 | aa_rating_id int unsigned NOT NULL, |
| 25 | 25 | aa_rating_value int unsigned NOT NULL, |
| 26 | 26 | -- 1 vote per user per revision |
| 27 | | - PRIMARY KEY (aa_revision, aa_user_text, aa_rating_id) |
| | 27 | + PRIMARY KEY (aa_revision, aa_user_text, aa_rating_id, aa_user_anon_token) |
| 28 | 28 | ) /*$wgDBTableOptions*/; |
| 29 | 29 | CREATE INDEX /*i*/aa_user_page_revision ON /*_*/article_assessment (aa_user_id, aa_page_id, aa_revision); |
| 30 | 30 | |