| Index: trunk/extensions/ArticleFeedbackv5/sql/wmfupdate-jan31.sql |
| — | — | @@ -0,0 +1,16 @@ |
| | 2 | +CREATE TABLE IF NOT EXISTS /*_*/aft_article_filter_count ( |
| | 3 | + afc_page_id integer unsigned NOT NULL, |
| | 4 | + afc_filter_name varchar(64) NOT NULL, |
| | 5 | + afc_filter_count integer unsigned NOT NULL, |
| | 6 | + PRIMARY KEY (afc_page_id, afc_filter_name) |
| | 7 | +); |
| | 8 | + |
| | 9 | +ALTER TABLE /*_*/aft_article_feedback |
| | 10 | + ADD COLUMN af_abuse_count integer unsigned NOT NULL DEFAULT 0, |
| | 11 | + ADD COLUMN af_helpful_count integer unsigned NOT NULL DEFAULT 0, |
| | 12 | + ADD COLUMN af_unhelpful_count integer unsigned NOT NULL DEFAULT 0, |
| | 13 | + ADD COLUMN af_needs_oversight boolean NOT NULL DEFAULT FALSE, |
| | 14 | + ADD COLUMN af_is_deleted boolean NOT NULL DEFAULT FALSE, |
| | 15 | + ADD COLUMN af_is_hidden boolean NOT NULL DEFAULT FALSE; |
| | 16 | + |
| | 17 | +CREATE INDEX /*i*/afo_field_id ON /*_*/aft_article_field_option (afo_field_id); |
| \ No newline at end of file |
| Property changes on: trunk/extensions/ArticleFeedbackv5/sql/wmfupdate-jan31.sql |
| ___________________________________________________________________ |
| Added: svn:eol-style |
| 1 | 18 | + native |