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

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

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

Modified Files:
	mysql.sql 
Log Message:
improved logs

Index: mysql.sql
===================================================================
RCS file: /cvsroot/aimmath/moodle/mod/math_assignment/db/mysql.sql,v
retrieving revision 1.13
retrieving revision 1.14
diff -C2 -d -r1.13 -r1.14
*** mysql.sql	6 Oct 2003 00:11:07 -0000	1.13
--- mysql.sql	11 Jan 2004 14:59:53 -0000	1.14
***************
*** 6,19 ****
  
  
! CREATE TABLE mdl_math_assignment (
    id int(10) unsigned NOT NULL auto_increment,
    course int(10) unsigned NOT NULL default '0',
    name varchar(255) NOT NULL default '',
!   problems varchar(255) NOT NULL default '',
!   problemsisurl tinyint(1) NOT NULL default '1',
!   solutions varchar(255) NOT NULL default '',
!   solutionsisurl tinyint(1) NOT NULL default '1',
!   papersheetsreturned tinyint(1) NOT NULL default '0',
!   aimquiz varchar(255) NOT NULL default '',
    aimfocus tinyint(1) unsigned NOT NULL default '1',
    papergrade int(10) unsigned NOT NULL default '0',
--- 6,23 ----
  
  
! #
! # Table structure for table `prefix_math_assignment`
! #
! 
! CREATE TABLE prefix_math_assignment (
    id int(10) unsigned NOT NULL auto_increment,
    course int(10) unsigned NOT NULL default '0',
    name varchar(255) NOT NULL default '',
!   problems varchar(255) default NULL,
!   problemsisurl tinyint(1) unsigned NOT NULL default '1',
!   solutions varchar(255) default NULL,
!   solutionsisurl tinyint(1) unsigned NOT NULL default '1',
!   papersheetsreturned tinyint(1) unsigned NOT NULL default '0',
!   aimquiz varchar(255) default NULL,
    aimfocus tinyint(1) unsigned NOT NULL default '1',
    papergrade int(10) unsigned NOT NULL default '0',
***************
*** 26,66 ****
  
  
! CREATE TABLE `prefix_math_assignment_subject` (
!   `course` int(10) unsigned NOT NULL default '0',
!   `name` varchar(255) NOT NULL default '',
!   `server` int(10) unsigned NOT NULL default '0',
!   `password` varchar(255) NOT NULL default '',
! PRIMARY KEY (`course`)
! ) TYPE=MyISAM COMMENT='AiM subject used by each course';
  
! CREATE TABLE `prefix_math_assignment_server` (
!   `id` int(10) unsigned NOT NULL auto_increment,
!   `name` varchar(255) NOT NULL default '',
!   `address` varchar(255) NOT NULL default '',
!   `password` varchar(255) NOT NULL default '',
! PRIMARY KEY (`id`),
! UNIQUE `NAME` (`name`)
! ) TYPE=MyISAM COMMENT='AiM servers used by math assignments';
  
- CREATE TABLE `prefix_math_assignment_grades` (
-   `assignment` int(10) unsigned NOT NULL default '0',
-   `userid` int(10) unsigned NOT NULL default '0',
-   `papergrade` int(10) NOT NULL default '-1',
-   `papertimemodified` int(10) unsigned NOT NULL default '0',
-   `aimgrade` int(10) NOT NULL default '-1',
-   `aimtimemodified` int(10) unsigned NOT NULL default '0',
-   `aimoverride` tinyint(1) NOT NULL default '0',
-   `aimcomment` text NOT NULL default '',
- PRIMARY KEY (`assignment`,`userid`)
- ) 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";
--- 30,92 ----
  
  
! #
! # Table structure for table `prefix_math_assignment_grades`
! #
  
! CREATE TABLE prefix_math_assignment_grades (
!   id int(10) unsigned NOT NULL auto_increment,
!   assignment int(10) unsigned NOT NULL default '0',
!   userid int(10) unsigned NOT NULL default '0',
!   papergrade int(10) NOT NULL default '-1',
!   papertimemodified int(10) unsigned NOT NULL default '0',
!   aimgrade int(10) NOT NULL default '-1',
!   aimtimemodified int(10) unsigned NOT NULL default '0',
!   aimoverride tinyint(1) NOT NULL default '0',
!   aimcomment text NOT NULL,
!   PRIMARY KEY  (id)
! ) TYPE=MyISAM COMMENT='Final math assignment grade (may be best of several attempts';
  
  
! #
! # Table structure for table `prefix_math_assignment_seeds`
! #
! 
! CREATE TABLE prefix_math_assignment_seeds (
!   id int(10) unsigned NOT NULL auto_increment,
!   assignment int(10) NOT NULL default '0',
!   student int(10) default NULL,
!   seed int(8) NOT NULL default '0',
!   PRIMARY KEY  (id)
  ) TYPE=MyISAM COMMENT='seeds for problem sheets';
  
  
+ #
+ # Table structure for table `prefix_math_assignment_servers`
+ #
+ 
+ CREATE TABLE prefix_math_assignment_servers (
+   id int(10) unsigned NOT NULL auto_increment,
+   name varchar(255) NOT NULL default '',
+   address varchar(255) NOT NULL default '',
+   password varchar(255) NOT NULL default '',
+   PRIMARY KEY  (id),
+   UNIQUE KEY NAME (name)
+ ) TYPE=MyISAM COMMENT='AiM servers used by math assignments';
+ 
+ 
+ #
+ # Table structure for table `prefix_math_assignment_subjects`
+ #
+ 
+ CREATE TABLE prefix_math_assignment_subjects (
+   id int(10) unsigned NOT NULL auto_increment,
+   course int(10) unsigned NOT NULL default '0',
+   name varchar(255) NOT NULL default '',
+   server int(10) unsigned NOT NULL default '0',
+   password varchar(255) NOT NULL default '',
+   PRIMARY KEY  (id)
+ ) TYPE=MyISAM COMMENT='AiM subject used by each course';
+ 
+ 
  INSERT `prefix_config` SET `name`="math_assignment_debug",`value`="0";
  INSERT `prefix_config` SET `name`="math_assignment_auto_register",`value`="1";
***************
*** 70,71 ****
--- 96,106 ----
  INSERT `prefix_config` SET `name`="math_assignment_default_email_host", `value`="";
  INSERT `prefix_config` SET `name`="math_assignment_secretary_email", `value`="";
+ 
+ INSERT INTO `prefix_log_display` VALUES ('math_assignment', 'solutions', 'math_assignment', 'name');
+ INSERT INTO `prefix_log_display` VALUES ('math_assignment', 'problems', 'math_assignment', 'name');
+ INSERT INTO `prefix_log_display` VALUES ('math_assignment', 'AiM page', 'math_assignment', 'name');
+ INSERT INTO `prefix_log_display` VALUES ('math_assignment', 'finalise grades', 'math_assignment', 'name');
+ INSERT INTO `prefix_log_display` VALUES ('math_assignment', 'AiM subject', 'math_assignment_subjects', 'name');
+ INSERT INTO `prefix_log_display` VALUES ('math_assignment', 'update papergrades', 'math_assignment', 'name');
+ INSERT INTO `prefix_log_display` VALUES ('math_assignment', 'view', 'math_assignment', 'name');
+ INSERT INTO `prefix_log_display` VALUES ('math_assignment', 'delete server', 'math_assignment_servers', 'name');