modules/gradebook/gradebookapi.mysql


# $Id: gradebookapi.mysql,v 1.3 2006/08/12 05:49:31 rwohleb Exp $

CREATE TABLE gradebookapi_assignment (
  nid int(10) unsigned NOT NULL,
  possible int(10) NOT NULL default '0',
  PRIMARY KEY  (nid)
);

CREATE TABLE gradebookapi_grade (
  uid int(10) unsigned NOT NULL,
  nid int(10) unsigned NOT NULL,
  earned int(10) NOT NULL default '0',
  exempt int(2) NOT NULL default '0',
  timestamp int(11) NOT NULL default '0',
  note longtext NOT NULL default '',
  PRIMARY KEY  (uid, nid)
);

CREATE TABLE gradebookapi_cache (
  uid int(10) unsigned NOT NULL,
  tid int(10) unsigned NOT NULL,
  earned int(10) NOT NULL default '0',
  possible int(10) NOT NULL default '0',
  PRIMARY KEY  (uid, tid)
);
1
2	# $Id: gradebookapi.mysql,v 1.3 2006/08/12 05:49:31 rwohleb Exp $
3
4	CREATE TABLE gradebookapi_assignment (
5	nid int(10) unsigned NOT NULL,
6	possible int(10) NOT NULL default '0',
7	PRIMARY KEY (nid)
8	);
9
10	CREATE TABLE gradebookapi_grade (
11	uid int(10) unsigned NOT NULL,
12	nid int(10) unsigned NOT NULL,
13	earned int(10) NOT NULL default '0',
14	exempt int(2) NOT NULL default '0',
15	timestamp int(11) NOT NULL default '0',
16	note longtext NOT NULL default '',
17	PRIMARY KEY (uid, nid)
18	);
19
20	CREATE TABLE gradebookapi_cache (
21	uid int(10) unsigned NOT NULL,
22	tid int(10) unsigned NOT NULL,
23	earned int(10) NOT NULL default '0',
24	possible int(10) NOT NULL default '0',
25	PRIMARY KEY (uid, tid)
26	);