function short_answer_update_7500 in Quiz 7.5
Same name and namespace in other branches
- 8.6 question_types/quiz_short_answer/quiz_short_answer.install \short_answer_update_7500()
- 8.5 question_types/quiz_short_answer/quiz_short_answer.install \short_answer_update_7500()
Normalize data storage.
File
- question_types/
short_answer/ short_answer.install, line 147 - Short_answer questions install file.
Code
function short_answer_update_7500() {
db_drop_unique_key('quiz_short_answer_user_answers', 'ids');
db_add_field('quiz_short_answer_user_answers', 'result_answer_id', array(
'type' => 'int',
'unsigned' => TRUE,
'not null' => FALSE,
));
db_query("UPDATE {quiz_short_answer_user_answers} qtua\n INNER JOIN {quiz_node_results_answers} qnra ON (qtua.question_nid = qnra.question_nid\n AND qtua.question_vid = qnra.question_vid\n AND qtua.result_id = qnra.result_id)\n SET qtua.result_answer_id = qnra.result_answer_id");
db_drop_field('quiz_short_answer_user_answers', 'result_id');
db_drop_field('quiz_short_answer_user_answers', 'question_nid');
db_drop_field('quiz_short_answer_user_answers', 'question_vid');
db_add_unique_key('quiz_short_answer_user_answers', 'result_answer_id', array(
'result_answer_id',
));
}