| Index: trunk/extensions/ArticleFeedbackv5/sql/ArticleFeedbackv5.sql |
| — | — | @@ -62,14 +62,14 @@ |
| 63 | 63 | ) /*$wgDBTableOptions*/; |
| 64 | 64 | |
| 65 | 65 | CREATE TABLE IF NOT EXISTS /*_*/aft_article_answer ( |
| 66 | | - -- FKEY to article_feedback.aa_id) |
| | 66 | + -- FKEY to article_feedback.af_id) |
| 67 | 67 | aa_feedback_id integer unsigned NOT NULL, |
| 68 | | - -- FKEY to article_fields.article_field_id) |
| | 68 | + -- FKEY to article_field.afi_id) |
| 69 | 69 | aa_field_id integer unsigned NOT NULL, |
| 70 | 70 | aa_response_rating integer NULL, |
| 71 | 71 | aa_response_text text NULL, |
| 72 | 72 | aa_response_boolean boolean NULL, |
| 73 | | - -- FKey to article_field_options.option_id) |
| | 73 | + -- FKey to article_field_options.afo_option_id) |
| 74 | 74 | aa_response_option_id integer unsigned NULL, |
| 75 | 75 | PRIMARY KEY (aa_feedback_id, aa_field_id) |
| 76 | 76 | ) /*$wgDBTableOptions*/; |
| — | — | @@ -100,16 +100,16 @@ |
| 101 | 101 | ) /*$wgDBTableOptions*/; |
| 102 | 102 | |
| 103 | 103 | CREATE TABLE IF NOT EXISTS /*_*/aft_article_revision_feedback_select_rollup ( |
| 104 | | - arfsr_page_id integer unsigned NOT NULL, |
| 105 | | - arfsr_revision_id integer unsigned NOT NULL, |
| 106 | | - arfsr_option_id integer unsigned NOT NULL, |
| 107 | | - arfsr_total integer unsigned NOT NULL, |
| 108 | | - arfsr_count integer unsigned NOT NULL, |
| 109 | | - PRIMARY KEY (arfsr_revision_id, arfsr_option_id) |
| | 104 | + arfsr_page_id integer unsigned NOT NULL, |
| | 105 | + arfsr_revision_id integer unsigned NOT NULL, |
| | 106 | + arfsr_option_id integer unsigned NOT NULL, |
| | 107 | + arfsr_total integer unsigned NOT NULL, |
| | 108 | + arfsr_count integer unsigned NOT NULL, |
| | 109 | + PRIMARY KEY (arfsr_revision_id, arfsr_option_id) |
| 110 | 110 | ) /*$wgDBTableOptions*/; |
| 111 | 111 | |
| 112 | | -CREATE TABLE IF NOT EXISTS /*_*/aft_article_feedback_properties ( |
| | 112 | +-- Mostly taken from AFTv4 |
| | 113 | +CREATE TABLE IF NOT EXISTS /*_*/aft_article_feedback_properties ( |
| 113 | 114 | -- Keys to article_feedback.aa_id |
| 114 | 115 | afp_feedback_id integer unsigned NOT NULL, |
| 115 | 116 | -- Key/value pair - allow text or numerical metadata |