| Index: trunk/extensions/ArticleFeedbackv5/sql/ArticleFeedbackv5.sql |
| — | — | @@ -10,6 +10,7 @@ |
| 11 | 11 | DROP TABLE IF EXISTS /*_*/aft_article_revision_feedback_select_rollup; |
| 12 | 12 | DROP TABLE IF EXISTS /*_*/aft_article_hits; |
| 13 | 13 | DROP TABLE IF EXISTS /*_*/aft_article_feedback_properties; |
| | 14 | +DROP TABLE IF EXISTS /*_*/aft_article_filter_count; |
| 14 | 15 | |
| 15 | 16 | -- Stores feedback records: "user X submitted feedback on page Y, at time Z" |
| 16 | 17 | CREATE TABLE IF NOT EXISTS /*_*/aft_article_feedback ( |
| — | — | @@ -99,17 +100,17 @@ |
| 100 | 101 | PRIMARY KEY (aa_feedback_id, aa_field_id) |
| 101 | 102 | ) /*$wgDBTableOptions*/; |
| 102 | 103 | |
| | 104 | +-- These next four are rollup tables used by the articlefeedback special page. |
| | 105 | +-- The revision tables store per-revision numers, as we (in meetings with WMF) |
| | 106 | +-- agreed that per-revision numbers could be useful in reporting, though |
| | 107 | +-- they aren't currently used on the feedback page. The page-level ones only |
| | 108 | +-- count back to wgArticleFeedbackv5RatingLifetime, so they're a rolling window. |
| 103 | 109 | -- |
| | 110 | +-- There are tables for ratings and select (ratings includes booleans as well), |
| | 111 | +-- because while the value of the rating/boolean is important (Rated 3/5), for |
| | 112 | +-- selects we only want the count for each input, not the value of that input or |
| | 113 | +-- the sum of the values (which will be numerical option_ids, not meaningful |
| | 114 | +-- rating values). The queries were sufficiently different that we deemed multiple |
| 104 | 115 | --tables worthwhile. |
| 105 | 116 | CREATE TABLE IF NOT EXISTS /*_*/aft_article_feedback_ratings_rollup ( |
| 106 | 117 | arr_page_id integer unsigned NOT NULL, |