| Index: trunk/extensions/ArticleFeedback/sql/AddStatsHighsLowsTable.sql |
| — | — | @@ -1,11 +0,0 @@ |
| 2 | | -CREATE TABLE IF NOT EXISTS /*_*/article_feedback_stats_highs_lows ( |
| 3 | | - afshl_id integer unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT, |
| 4 | | - afshl_page_id integer unsigned NOT NULL, |
| 5 | | - -- combined average rating |
| 6 | | - afshl_avg_overall double unsigned NOT NULL, |
| 7 | | - -- json object of rating key => avg value |
| 8 | | - afshl_avg_ratings varbinary(255) NOT NULL, |
| 9 | | - -- timestamp of insertion job |
| 10 | | - afshl_ts binary(14) NOT NULL |
| 11 | | -) /*$wgDBTableOptions*/; |
| 12 | | -CREATE INDEX /*i*/ afshl_ts_avg_overall ON /*_*/article_feedback_stats_highs_lows (afshl_ts, afshl_avg_overall); |
| Index: trunk/extensions/ArticleFeedback/sql/ArticleFeedback.sql |
| — | — | @@ -32,7 +32,6 @@ |
| 33 | 33 | aa_rating_value int unsigned NOT NULL, |
| 34 | 34 | -- Which rating widget the user was given. Default of 0 is the "old" design |
| 35 | 35 | aa_design_bucket int unsigned NOT NULL DEFAULT 0, |
| 36 | | - aa_design_bucket int unsigned NOT NULL DEFAULT 0, |
| 37 | 36 | -- 1 vote per user per revision |
| 38 | 37 | PRIMARY KEY (aa_revision, aa_user_text, aa_rating_id, aa_user_anon_token) |
| 39 | 38 | ) /*$wgDBTableOptions*/; |