[Aimmath-commit] moodle/mod/math_assignment/db mysql.php,NONE,1.1 mysql.sql,NONE,1.1

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

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

Added Files:
	mysql.php mysql.sql 
Log Message:
New module math_assignment

--- NEW FILE: mysql.php ---
<?PHP // $Id: mysql.php,v 1.1 2003/09/09 18:31:07 gustav_delius Exp $

function math_assignment_upgrade($oldversion) {
// This function does anything necessary to upgrade
// older versions to match current functionality

    global $CFG;

    return true;
}

?>

--- NEW FILE: mysql.sql ---
# This file contains a complete database schema for all the 
# tables used by this module, written in SQL

# It may also contain INSERT statements for particular data 
# that may be used, especially new entries in the table log_display

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) NOT NULL default '',
  `solutions` varchar(255) NOT NULL default '',
  `aimsubject` int(10) NOT NULL default '0',
  `aimquiz` varchar(255) NOT NULL default '',
  `papergrade` int(10) unsigned NOT NULL default '0',
  `aimgrade` int(10) unsigned NOT NULL default '0',
  `timedue` int(10) unsigned NOT NULL default '0',
  `timemodified` int(10) unsigned NOT NULL default '0',
PRIMARY KEY  (`id`)
) TYPE=MyISAM COMMENT='Main information about each math assignment';

CREATE TABLE `prefix_math_assignment_subject` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `server` int(10) unsigned NOT NULL default '0',
  `password` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE `UNIQUE` (`name`, `server`)
) TYPE=MyISAM COMMENT='AiM subjects used by math assignments';

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 '',
  `student_passwd` 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)';

INSERT `prefix_config` SET `name`="math_assignment_debug",`value`="0";
INSERT `prefix_config` SET `name`="math_assignment_auto_register",`value`="1";
INSERT `prefix_config` SET `name`="math_assignment_grade_multiplier",`value`="1";
INSERT `prefix_config` SET `name`="math_assignment_default_latex_output",`value`="0";
INSERT `prefix_config` SET `name`="math_assignment_server_display", `value`="2";
INSERT `prefix_config` SET `name`="math_assignment_aim_display", `value`="1";