| Index: trunk/extensions/ReaderFeedback/ReaderFeedback.sql |
| — | — | @@ -21,7 +21,7 @@ |
| 22 | 22 | CREATE TABLE IF NOT EXISTS /*$wgDBprefix*/reader_feedback_history ( |
| 23 | 23 | -- Foreign key to page.page_id |
| 24 | 24 | rfh_page_id integer unsigned NOT NULL, |
| 25 | | - rfh_tag char(20) NOT NULL default '', |
| | 25 | + rfh_tag varchar(20) NOT NULL default '', |
| 26 | 26 | rfh_total integer unsigned NOT NULL default 0, |
| 27 | 27 | rfh_count integer unsigned NOT NULL default 0, |
| 28 | 28 | -- MW date of the day this average corresponds to |
| — | — | @@ -33,7 +33,7 @@ |
| 34 | 34 | CREATE TABLE IF NOT EXISTS /*$wgDBprefix*/reader_feedback_pages ( |
| 35 | 35 | -- Foreign key to page.page_id |
| 36 | 36 | rfp_page_id integer unsigned NOT NULL, |
| 37 | | - rfp_tag char(20) NOT NULL default '', |
| | 37 | + rfp_tag varchar(20) NOT NULL default '', |
| 38 | 38 | -- Value in last few days (14) |
| 39 | 39 | rfp_ave_val real NOT NULL default 0, |
| 40 | 40 | -- And said total (used as threshold) |