r109995 MediaWiki - Code Review archive

Repository:MediaWiki
Revision:< r109994‎ | r109995 | r109996 >
Date:05:29, 25 January 2012
Author:santhosh
Status:ok
Tags:
Comment:
FIX: database prefix missing in table names.
Modified paths:
  • /trunk/extensions/ArticleFeedbackv5/sql/ArticleFeedbackv5.sql (modified) (history)

Diff [purge]

Index: trunk/extensions/ArticleFeedbackv5/sql/ArticleFeedbackv5.sql
——@@ -175,28 +175,28 @@
176176 CREATE INDEX /*i*/afi_data_type ON /*_*/aft_article_field (afi_data_type);
177177 CREATE INDEX /*i*/aa_feedback_field_option ON /*_*/aft_article_answer (aa_feedback_id, aa_field_id, aa_response_option_id);
178178
179 -INSERT INTO aft_article_field(afi_name, afi_data_type, afi_bucket_id) VALUES ('found', 'boolean', 1);
180 -INSERT INTO aft_article_field(afi_name, afi_data_type, afi_bucket_id) VALUES ('comment', 'text', 1);
181 -INSERT INTO aft_article_field(afi_name, afi_data_type, afi_bucket_id) VALUES ('tag', 'option_id', 2);
182 -INSERT INTO aft_article_field(afi_name, afi_data_type, afi_bucket_id) VALUES ('comment', 'text', 2);
183 -INSERT INTO aft_article_field(afi_name, afi_data_type, afi_bucket_id) VALUES ('rating', 'rating', 3);
184 -INSERT INTO aft_article_field(afi_name, afi_data_type, afi_bucket_id) VALUES ('comment', 'text', 3);
185 -INSERT INTO aft_article_field(afi_name, afi_data_type, afi_bucket_id) VALUES ('trustworthy', 'rating', 5);
186 -INSERT INTO aft_article_field(afi_name, afi_data_type, afi_bucket_id) VALUES ('objective', 'rating', 5);
187 -INSERT INTO aft_article_field(afi_name, afi_data_type, afi_bucket_id) VALUES ('complete', 'rating', 5);
188 -INSERT INTO aft_article_field(afi_name, afi_data_type, afi_bucket_id) VALUES ('wellwritten', 'rating', 5);
189 -INSERT INTO aft_article_field(afi_name, afi_data_type, afi_bucket_id) VALUES ('expertise-general', 'boolean', 5);
190 -INSERT INTO aft_article_field(afi_name, afi_data_type, afi_bucket_id) VALUES ('expertise-studies', 'boolean', 5);
191 -INSERT INTO aft_article_field(afi_name, afi_data_type, afi_bucket_id) VALUES ('expertise-profession', 'boolean', 5);
192 -INSERT INTO aft_article_field(afi_name, afi_data_type, afi_bucket_id) VALUES ('expertise-hobby', 'boolean', 5);
193 -INSERT INTO aft_article_field(afi_name, afi_data_type, afi_bucket_id) VALUES ('expertise-other', 'boolean', 5);
 179+INSERT INTO /*_*/aft_article_field(afi_name, afi_data_type, afi_bucket_id) VALUES ('found', 'boolean', 1);
 180+INSERT INTO /*_*/aft_article_field(afi_name, afi_data_type, afi_bucket_id) VALUES ('comment', 'text', 1);
 181+INSERT INTO /*_*/aft_article_field(afi_name, afi_data_type, afi_bucket_id) VALUES ('tag', 'option_id', 2);
 182+INSERT INTO /*_*/aft_article_field(afi_name, afi_data_type, afi_bucket_id) VALUES ('comment', 'text', 2);
 183+INSERT INTO /*_*/aft_article_field(afi_name, afi_data_type, afi_bucket_id) VALUES ('rating', 'rating', 3);
 184+INSERT INTO /*_*/aft_article_field(afi_name, afi_data_type, afi_bucket_id) VALUES ('comment', 'text', 3);
 185+INSERT INTO /*_*/aft_article_field(afi_name, afi_data_type, afi_bucket_id) VALUES ('trustworthy', 'rating', 5);
 186+INSERT INTO /*_*/aft_article_field(afi_name, afi_data_type, afi_bucket_id) VALUES ('objective', 'rating', 5);
 187+INSERT INTO /*_*/aft_article_field(afi_name, afi_data_type, afi_bucket_id) VALUES ('complete', 'rating', 5);
 188+INSERT INTO /*_*/aft_article_field(afi_name, afi_data_type, afi_bucket_id) VALUES ('wellwritten', 'rating', 5);
 189+INSERT INTO /*_*/aft_article_field(afi_name, afi_data_type, afi_bucket_id) VALUES ('expertise-general', 'boolean', 5);
 190+INSERT INTO /*_*/aft_article_field(afi_name, afi_data_type, afi_bucket_id) VALUES ('expertise-studies', 'boolean', 5);
 191+INSERT INTO /*_*/aft_article_field(afi_name, afi_data_type, afi_bucket_id) VALUES ('expertise-profession', 'boolean', 5);
 192+INSERT INTO /*_*/aft_article_field(afi_name, afi_data_type, afi_bucket_id) VALUES ('expertise-hobby', 'boolean', 5);
 193+INSERT INTO /*_*/aft_article_field(afi_name, afi_data_type, afi_bucket_id) VALUES ('expertise-other', 'boolean', 5);
194194
195 -INSERT INTO aft_article_field_option (afo_field_id, afo_name)
196 - SELECT afi_id, 'suggestion' FROM aft_article_field WHERE afi_name = 'tag' AND afi_bucket_id = 2;
197 -INSERT INTO aft_article_field_option (afo_field_id, afo_name)
198 - SELECT afi_id, 'question' FROM aft_article_field WHERE afi_name = 'tag' AND afi_bucket_id = 2;
199 -INSERT INTO aft_article_field_option (afo_field_id, afo_name)
200 - SELECT afi_id, 'problem' FROM aft_article_field WHERE afi_name = 'tag' AND afi_bucket_id = 2;
201 -INSERT INTO aft_article_field_option (afo_field_id, afo_name)
202 - SELECT afi_id, 'praise' FROM aft_article_field WHERE afi_name = 'tag' AND afi_bucket_id = 2;
 195+INSERT INTO /*_*/aft_article_field_option (afo_field_id, afo_name)
 196+ SELECT afi_id, 'suggestion' FROM /*_*/aft_article_field WHERE afi_name = 'tag' AND afi_bucket_id = 2;
 197+INSERT INTO /*_*/aft_article_field_option (afo_field_id, afo_name)
 198+ SELECT afi_id, 'question' FROM /*_*/aft_article_field WHERE afi_name = 'tag' AND afi_bucket_id = 2;
 199+INSERT INTO /*_*/aft_article_field_option (afo_field_id, afo_name)
 200+ SELECT afi_id, 'problem' FROM /*_*/aft_article_field WHERE afi_name = 'tag' AND afi_bucket_id = 2;
 201+INSERT INTO /*_*/aft_article_field_option (afo_field_id, afo_name)
 202+ SELECT afi_id, 'praise' FROM /*_*/aft_article_field WHERE afi_name = 'tag' AND afi_bucket_id = 2;
203203

Status & tagging log