function matching_update_7400 in Quiz 7.5
Same name and namespace in other branches
- 7.6 question_types/matching/matching.install \matching_update_7400()
- 7.4 question_types/matching/matching.install \matching_update_7400()
Add a table to store properties for the matching questions.
File
- question_types/
matching/ matching.install, line 123 - Matching questions install file.
Code
function matching_update_7400() {
$schema = array(
'fields' => array(
'nid' => array(
'type' => 'int',
'unsigned' => TRUE,
'not null' => TRUE,
),
'vid' => array(
'type' => 'int',
'unsigned' => TRUE,
'not null' => TRUE,
),
'choice_penalty' => array(
'type' => 'int',
'unsigned' => TRUE,
'not null' => TRUE,
'default' => 0,
),
),
'primary key' => array(
'nid',
'vid',
),
);
db_create_table('quiz_matching_properties', $schema);
// Insert default properties for all of the existing matching questions.
$result = db_query("SELECT nid, vid FROM {node} WHERE type='matching'");
foreach ($result as $question) {
db_insert('quiz_matching_properties')
->fields(array(
'nid' => $question->nid,
'vid' => $question->vid,
'choice_penalty' => 0,
))
->execute();
}
}