function truefalse_update_7500 in Quiz 7.5
Normalize data storage.
File
- question_types/
truefalse/ truefalse.install, line 87 - Truefalse question install file.
Code
function truefalse_update_7500() {
db_drop_primary_key('quiz_truefalse_user_answers');
db_add_field('quiz_truefalse_user_answers', 'answer_id', array(
'type' => 'serial',
'not null' => TRUE,
), array(
'primary key' => array(
'answer_id',
),
));
db_add_field('quiz_truefalse_user_answers', 'result_answer_id', array(
'type' => 'int',
'unsigned' => TRUE,
'not null' => FALSE,
));
db_query("UPDATE {quiz_truefalse_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_truefalse_user_answers', 'result_id');
db_drop_field('quiz_truefalse_user_answers', 'question_nid');
db_drop_field('quiz_truefalse_user_answers', 'question_vid');
db_add_unique_key('quiz_truefalse_user_answers', 'result_answer_id', array(
'result_answer_id',
));
}