function truefalse_schema in Quiz 6.6
Same name and namespace in other branches
- 8.4 question_types/truefalse/truefalse.install \truefalse_schema()
- 6.4 question_types/truefalse/truefalse.install \truefalse_schema()
- 7.6 question_types/truefalse/truefalse.install \truefalse_schema()
- 7 question_types/truefalse/truefalse.install \truefalse_schema()
- 7.4 question_types/truefalse/truefalse.install \truefalse_schema()
- 7.5 question_types/truefalse/truefalse.install \truefalse_schema()
Implementation of hook_schema().
File
- question_types/
truefalse/ truefalse.install, line 29 - The installer file for truefalse question type. *
Code
function truefalse_schema() {
//////////////////////
// TRUE/FALSE tables.
//////////////////////
// Extensions to nodes for T/F
$schema['quiz_truefalse_node'] = array(
'fields' => array(
// Nid/vid of the question
'nid' => array(
'type' => 'int',
'unsigned' => TRUE,
'not null' => TRUE,
),
'vid' => array(
'type' => 'int',
'unsigned' => TRUE,
'not null' => TRUE,
),
// The correct answer for the user to give. 1 for true.
'correct_answer' => array(
'type' => 'int',
'unsigned' => TRUE,
'size' => 'tiny',
'default' => 0,
),
'feedback' => array(
'type' => 'text',
),
),
'primary key' => array(
'vid',
'nid',
),
);
// Place to store user answers for T/F questions
$schema['quiz_truefalse_user_answers'] = array(
'fields' => array(
// Nid/vid of the question
'question_nid' => array(
'type' => 'int',
'unsigned' => TRUE,
'not null' => TRUE,
),
'question_vid' => array(
'type' => 'int',
'unsigned' => TRUE,
'not null' => TRUE,
),
// User's result set
'result_id' => array(
'type' => 'int',
'unsigned' => TRUE,
'not null' => TRUE,
),
// The actual answer the user gave. True or false.
'answer' => array(
'type' => 'int',
'unsigned' => TRUE,
'size' => 'tiny',
'default' => 0,
),
'score' => array(
'type' => 'int',
'unsigned' => TRUE,
'not null' => TRUE,
'default' => 0,
),
),
'primary key' => array(
'result_id',
'question_nid',
'question_vid',
),
);
return $schema;
}