modules/gradebook/gradebookapi.install

<?php
// $Id: gradebookapi.install,v 1.1 2006/11/05 23:36:09 rwohleb Exp $

function gradebookapi_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      // the {tablename} syntax is so multisite installs can add a
      // prefix to the table name as set in the settings.php file
      db_query("CREATE TABLE {gradebookapi_assignment} (
        nid int(10) unsigned NOT NULL,
        possible int(10) NOT NULL default '0',
        PRIMARY KEY  (nid)
        )");
      db_query("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 NULL,
        PRIMARY KEY  (uid, nid)
        )");
      db_query("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)
        )");
      break;
    case 'pgsql':
      db_query("CREATE TABLE \"gradebookapi_assignment\" (
        \"nid\" int(10) unsigned NOT NULL default '0',
        \"possible\" int(10) NOT NULL default '0',
        PRIMARY KEY  (\"nid\")
        )");
      db_query("CREATE TABLE \"gradebookapi_grade\" (
        \"uid\" int(10) unsigned NOT NULL default '0',
        \"nid\" int(10) unsigned NOT NULL default '0',
        \"earned\" int(10) NOT NULL default '0',
        \"exempt\" int(2) NOT NULL default '0',
        \"timestamp\" int(11) NOT NULL default '0',
        \"note\" longtext NULL,
        PRIMARY KEY  (\"uid\",\"nid\")
        )");
      db_query("CREATE TABLE \"gradebookapi_cache\" (
        \"uid\" int(10) unsigned NOT NULL default '0',
        \"tid\" int(10) unsigned NOT NULL default '0',
        \"earned\" int(10) NOT NULL default '0',
        \"possible\" int(10) NOT NULL default '0',
        PRIMARY KEY  (\"uid\",\"tid\")
        )");
      break;
  }
}
1	<?php
2	// $Id: gradebookapi.install,v 1.1 2006/11/05 23:36:09 rwohleb Exp $
3
4	function gradebookapi_install() {
5	switch ($GLOBALS['db_type']) {
6	case 'mysql':
7	case 'mysqli':
8	// the {tablename} syntax is so multisite installs can add a
9	// prefix to the table name as set in the settings.php file
10	db_query("CREATE TABLE {gradebookapi_assignment} (
11	nid int(10) unsigned NOT NULL,
12	possible int(10) NOT NULL default '0',
13	PRIMARY KEY (nid)
14	)");
15	db_query("CREATE TABLE {gradebookapi_grade} (
16	uid int(10) unsigned NOT NULL,
17	nid int(10) unsigned NOT NULL,
18	earned int(10) NOT NULL default '0',
19	exempt int(2) NOT NULL default '0',
20	timestamp int(11) NOT NULL default '0',
21	note longtext NULL,
22	PRIMARY KEY (uid, nid)
23	)");
24	db_query("CREATE TABLE {gradebookapi_cache} (
25	uid int(10) unsigned NOT NULL,
26	tid int(10) unsigned NOT NULL,
27	earned int(10) NOT NULL default '0',
28	possible int(10) NOT NULL default '0',
29	PRIMARY KEY (uid, tid)
30	)");
31	break;
32	case 'pgsql':
33	db_query("CREATE TABLE \"gradebookapi_assignment\" (
34	\"nid\" int(10) unsigned NOT NULL default '0',
35	\"possible\" int(10) NOT NULL default '0',
36	PRIMARY KEY (\"nid\")
37	)");
38	db_query("CREATE TABLE \"gradebookapi_grade\" (
39	\"uid\" int(10) unsigned NOT NULL default '0',
40	\"nid\" int(10) unsigned NOT NULL default '0',
41	\"earned\" int(10) NOT NULL default '0',
42	\"exempt\" int(2) NOT NULL default '0',
43	\"timestamp\" int(11) NOT NULL default '0',
44	\"note\" longtext NULL,
45	PRIMARY KEY (\"uid\",\"nid\")
46	)");
47	db_query("CREATE TABLE \"gradebookapi_cache\" (
48	\"uid\" int(10) unsigned NOT NULL default '0',
49	\"tid\" int(10) unsigned NOT NULL default '0',
50	\"earned\" int(10) NOT NULL default '0',
51	\"possible\" int(10) NOT NULL default '0',
52	PRIMARY KEY (\"uid\",\"tid\")
53	)");
54	break;
55	}
56	}