[Aimmath-commit] moodle/mod/math_assignment/db mysql.php,1.8,1.9 mysql.sql,1.7,1.8

[<ma...@us...>]

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

Modified Files:
	mysql.php mysql.sql 
Log Message:
Changed server admin around to provide more features and make it clearer. Also implemented the storing of the Zone Admin password.

Index: mysql.php
===================================================================
RCS file: /cvsroot/aimmath/moodle/mod/math_assignment/db/mysql.php,v
retrieving revision 1.8
retrieving revision 1.9
diff -C2 -d -r1.8 -r1.9
*** mysql.php	22 Sep 2003 21:03:55 -0000	1.8
--- mysql.php	23 Sep 2003 17:53:09 -0000	1.9
***************
*** 13,16 ****
--- 13,20 ----
          execute_sql("ALTER TABLE `{$CFG->prefix}math_assignment_server` DROP `student_passwd`");
      }
+     if ($oldversion < 2003092315) {
+         execute_sql("ALTER TABLE `{$CFG->prefix}math_assignment_server` ADD `password` VARCHAR(255) NOT NULL default ''");
+         execute_sql("ALTER TABLE `{$CFG->prefix}math_assignment_subject` DROP INDEX `UNIQUE`");
+     }
  
      return true;

Index: mysql.sql
===================================================================
RCS file: /cvsroot/aimmath/moodle/mod/math_assignment/db/mysql.sql,v
retrieving revision 1.7
retrieving revision 1.8
diff -C2 -d -r1.7 -r1.8
*** mysql.sql	22 Sep 2003 21:03:55 -0000	1.7
--- mysql.sql	23 Sep 2003 17:53:10 -0000	1.8
***************
*** 29,34 ****
    `server` int(10) unsigned NOT NULL default '0',
    `password` varchar(255) NOT NULL default '',
! PRIMARY KEY (`course`),
! UNIQUE `UNIQUE` (`name`, `server`)
  ) TYPE=MyISAM COMMENT='AiM subject used by each course';
  
--- 29,33 ----
    `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';
  
***************
*** 37,40 ****
--- 36,40 ----
    `name` varchar(255) NOT NULL default '',
    `address` varchar(255) NOT NULL default '',
+   `password` varchar(255) NOT NULL default '',
  PRIMARY KEY (`id`),
  UNIQUE `NAME` (`name`)