function quiz_drag_drop_update_101 in Quiz Drag Drop 7

Droping primary key if any from quiz_drag_drop_user_answers table, Adding indexes on question nid, result id and question vid.

File

./quiz_drag_drop.install, line 112

drag drop Install (a quiz question type)

Code

function quiz_drag_drop_update_101() {

  //Removing primary fields.
  db_drop_primary_key('quiz_drag_drop_user_answers');

  //Adding indexes.
  db_add_index('quiz_drag_drop_user_answers', 'nid_vid_rid', array(
    'question_nid',
    'question_vid',
    'result_id',
  ));
}