| Index: trunk/extensions/FlaggedRevs/archives/patch-reader_feedback.sql |
| — | — | @@ -1,37 +0,0 @@ |
| 2 | | -CREATE TABLE /*$wgDBprefix*/reader_feedback ( |
| 3 | | - -- Foreign key to revision.rev_id |
| 4 | | - rfb_rev_id integer unsigned NOT NULL, |
| 5 | | - -- Foreign key to user.user_id |
| 6 | | - rfb_user integer unsigned NOT NULL, |
| 7 | | - rfb_ip varchar(255) NOT NULL default '', |
| 8 | | - -- No double voting! |
| 9 | | - PRIMARY KEY (rfb_rev_id,rfb_user,rfb_ip) |
| 10 | | -) /*$wgDBTableOptions*/; |
| 11 | | - |
| 12 | | -CREATE TABLE /*$wgDBprefix*/reader_feedback_history ( |
| 13 | | - -- Foreign key to page.page_id |
| 14 | | - rfh_page_id integer NOT NULL, |
| 15 | | - rfh_tag char(20) NOT NULL default '', |
| 16 | | - rfh_total integer unsigned NOT NULL default 0, |
| 17 | | - rfh_count integer unsigned NOT NULL default 0, |
| 18 | | - -- MW date of the day this average corresponds to |
| 19 | | - rfh_date char(14) NOT NULL default '', |
| 20 | | - PRIMARY KEY (rfh_page_id,rfh_tag,rfh_date) |
| 21 | | -) /*$wgDBTableOptions*/; |
| 22 | | - |
| 23 | | -CREATE TABLE /*$wgDBprefix*/reader_feedback_pages ( |
| 24 | | - -- Foreign key to page.page_id |
| 25 | | - rfp_page_id integer unsigned NOT NULL, |
| 26 | | - rfp_tag char(20) NOT NULL default '', |
| 27 | | - -- Value in last few days (14) |
| 28 | | - rfp_ave_val real NOT NULL default 0, |
| 29 | | - -- And said total (used as threshold) |
| 30 | | - rfp_count integer unsigned NOT NULL default 0, |
| 31 | | - rfp_touched char(14) NOT NULL default '', |
| 32 | | - PRIMARY KEY (rfp_page_id,rfp_tag), |
| 33 | | - INDEX rfp_tag_val_page (rfp_tag,rfp_ave_val,rfp_page_id) |
| 34 | | -) /*$wgDBTableOptions*/; |
| 35 | | - |
| Index: trunk/extensions/FlaggedRevs/archives/patch-rfb_timestamp.sql |
| — | — | @@ -1,2 +0,0 @@ |
| 2 | | -ALTER TABLE /*$wgDBprefix*/reader_feedback |
| 3 | | - ADD rfb_timestamp char(14) NOT NULL default ''; |
| Index: trunk/extensions/FlaggedRevs/archives/patch-rfb_ratings.sql |
| — | — | @@ -1,2 +0,0 @@ |
| 2 | | -ALTER TABLE /*$wgDBprefix*/reader_feedback |
| 3 | | - ADD rfb_ratings mediumblob NOT NULL; |