From 6dfc23760f12d9f66c0126119b5931c4619cb33e Mon Sep 17 00:00:00 2001 From: gustav_delius Date: Wed, 22 Mar 2006 22:04:31 +0000 Subject: [PATCH] The obsolete table quiz_attemptonlast_datasets should no longer get created --- mod/quiz/db/mysql.sql | 15 --------------- mod/quiz/db/postgres7.sql | 14 -------------- 2 files changed, 29 deletions(-) diff --git a/mod/quiz/db/mysql.sql b/mod/quiz/db/mysql.sql index 83fe73eddc..733207a4a7 100644 --- a/mod/quiz/db/mysql.sql +++ b/mod/quiz/db/mysql.sql @@ -66,21 +66,6 @@ CREATE TABLE prefix_question_answers ( -- -------------------------------------------------------- --- --- Table structure for table `prefix_quiz_attemptonlast_datasets` --- - -CREATE TABLE prefix_quiz_attemptonlast_datasets ( - id int(10) unsigned NOT NULL auto_increment, - category int(10) unsigned NOT NULL default '0', - userid int(10) unsigned NOT NULL default '0', - datasetnumber int(10) unsigned NOT NULL default '0', - PRIMARY KEY (id), - UNIQUE KEY category (category,userid) -) TYPE=MyISAM COMMENT='Dataset number for attemptonlast attempts per user'; - --- -------------------------------------------------------- - -- -- Table structure for table `prefix_quiz_attempts` -- diff --git a/mod/quiz/db/postgres7.sql b/mod/quiz/db/postgres7.sql index 6192d3d607..08fb04c0ec 100644 --- a/mod/quiz/db/postgres7.sql +++ b/mod/quiz/db/postgres7.sql @@ -62,20 +62,6 @@ CREATE TABLE prefix_question_answers ( CREATE INDEX prefix_question_answers_question_idx ON prefix_question_answers (question); -# -------------------------------------------------------- -# -# Table structure for table prefix_quiz_attemptonlast_datasets -# - -CREATE TABLE prefix_quiz_attemptonlast_datasets ( - id SERIAL8 PRIMARY KEY, - category INT8 NOT NULL default '0', - userid INT8 NOT NULL default '0', - datasetnumber INT8 NOT NULL default '0', - CONSTRAINT prefix_quiz_attemptonlast_datasets_category_userid UNIQUE (category,userid) -); - - # -------------------------------------------------------- # # Table structure for table prefix_quiz_attempts -- 2.39.5