[Aimmath-commit] moodle/mod/math_assignment/db mysql.php,1.13,1.14 mysql.sql,1.12,1.13

[<gus...@us...>]

Update of /cvsroot/aimmath/moodle/mod/math_assignment/db
In directory sc8-pr-cvs1:/tmp/cvs-serv23091/mod/math_assignment/db

Modified Files:
	mysql.php mysql.sql 
Log Message:
added math_assignment_seed table

Index: mysql.php
===================================================================
RCS file: /cvsroot/aimmath/moodle/mod/math_assignment/db/mysql.php,v
retrieving revision 1.13
retrieving revision 1.14
diff -C2 -d -r1.13 -r1.14
*** mysql.php	5 Oct 2003 22:54:15 -0000	1.13
--- mysql.php	6 Oct 2003 00:11:07 -0000	1.14
***************
*** 7,10 ****
--- 7,18 ----
      global $CFG;
  
+     if ($oldversion < 2003100502) {
+         execute_sql("CREATE TABLE `mdl_math_assignment_seed` (
+               `assignment` INT( 10 ) NOT NULL ,
+               `student` INT( 10 ) ,
+               `seed` INT( 8 ) NOT NULL ,
+               PRIMARY KEY ( `assignment` , `seed` ) 
+             ) COMMENT = 'seeds for problem sheets'");
+     }
      if ($oldversion < 2003100501) {
          table_column("math_assignment", "", "solutiontime", "int", "10", "unsigned", "0");

Index: mysql.sql
===================================================================
RCS file: /cvsroot/aimmath/moodle/mod/math_assignment/db/mysql.sql,v
retrieving revision 1.12
retrieving revision 1.13
diff -C2 -d -r1.12 -r1.13
*** mysql.sql	5 Oct 2003 22:54:15 -0000	1.12
--- mysql.sql	6 Oct 2003 00:11:07 -0000	1.13
***************
*** 55,58 ****
--- 55,66 ----
  ) TYPE=MyISAM COMMENT='Final math assignment grade (may be best of several attempts)';
  
+ CREATE TABLE `mdl_math_assignment_seed` (
+   `assignment` int(10) NOT NULL default '0',
+   `student` int(10) default NULL,
+   `seed` int(8) NOT NULL default '0',
+   PRIMARY KEY  (`assignment`,`seed`)
+ ) TYPE=MyISAM COMMENT='seeds for problem sheets';
+ 
+ 
  INSERT `prefix_config` SET `name`="math_assignment_debug",`value`="0";
  INSERT `prefix_config` SET `name`="math_assignment_auto_register",`value`="1";