Update of /cvsroot/stack/stack-1-0/scripts/rqp/moodle_16_rqp/quiz/db
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv4725/scripts/rqp/moodle_16_rqp/quiz/db
Modified Files:
mysql.php postgres7.php
Log Message:
Latest version of RQPServer and client
Implemented options
Error reporting
Index: mysql.php
===================================================================
RCS file: /cvsroot/stack/stack-1-0/scripts/rqp/moodle_16_rqp/quiz/db/mysql.php,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** mysql.php 12 Sep 2005 09:46:59 -0000 1.1
--- mysql.php 5 Oct 2005 11:43:44 -0000 1.2
***************
*** 912,918 ****
options longblob NOT NULL default '')");
! //Quiz options
execute_sql('ALTER TABLE '.$CFG->prefix."quiz_rqp ADD `options` longblob NOT NULL default ''");
}
return true;
--- 912,926 ----
options longblob NOT NULL default '')");
! //Question Options
execute_sql('ALTER TABLE '.$CFG->prefix."quiz_rqp ADD `options` longblob NOT NULL default ''");
}
+
+ if ($oldversion < 2005093000) {
+ //Quiz options
+ execute_sql('CREATE TABLE '.$CFG->prefix."quiz_rqp_quiz_options (id INT( 10 ) UNSIGNED PRIMARY KEY AUTO_INCREMENT,
+ quizid INT( 10 ) UNSIGNED NOT NULL,
+ typeid INT( 10 ) UNSIGNED NOT NULL,
+ options longblob NOT NULL default '')");
+ }
return true;
Index: postgres7.php
===================================================================
RCS file: /cvsroot/stack/stack-1-0/scripts/rqp/moodle_16_rqp/quiz/db/postgres7.php,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** postgres7.php 12 Sep 2005 09:46:59 -0000 1.1
--- postgres7.php 5 Oct 2005 11:43:44 -0000 1.2
***************
*** 1007,1010 ****
--- 1007,1017 ----
modify_database('',"ALTER TABLE prefix_quiz_rqp ADD options TEXT NOT NULL default ''");
}
+
+ if ($oldversion < 2005093000) {
+ modify_database('',"CREATE TABLE prefix_quiz_rqp_quiz_options (id SERIAL PRIMARY KEY,
+ quizid integer NOT NULL default '0',
+ typeid integer NOT NULL default '0',
+ options TEXT NOT NULL default '');");
+ }
|
