function quiz_drag_drop_schema in Quiz Drag Drop 7

Implements hook_schema().

File

./quiz_drag_drop.install, line 62

drag drop Install (a quiz question type)

Code

function quiz_drag_drop_schema() {

  // Stores the users answers to a question.
  $schema['quiz_drag_drop_user_answers'] = array(
    'fields' => array(
      'question_nid' => array(
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE,
      ),
      'question_vid' => array(
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE,
      ),
      'result_id' => array(
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE,
      ),
      'score' => array(
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE,
        'default' => 0,
      ),
    ),
    'primary key' => array(
      'result_id',
      'question_nid',
      'question_vid',
    ),
  );
  return $schema;
}