/[drupal]/contributions/modules/jeopardy/jeopardy.install
ViewVC logotype

Diff of /contributions/modules/jeopardy/jeopardy.install

Parent Directory Parent Directory | Revision Log Revision Log | View Revision Graph Revision Graph | View Patch Patch

revision 1.1, Tue Jan 30 21:46:56 2007 UTC revision 1.2, Sun Aug 31 12:20:53 2008 UTC
# Line 5  function jeopardy_install() { Line 5  function jeopardy_install() {
5    switch ($GLOBALS['db_type']) {    switch ($GLOBALS['db_type']) {
6      case 'mysql':      case 'mysql':
7      case 'mysqli':      case 'mysqli':
       // the {tablename} syntax is so multisite installs can add a  
       // prefix to the table name as set in the settings.php file  
8        db_query("CREATE TABLE {jeopardy_questions} (        db_query("CREATE TABLE {jeopardy_questions} (
9                    nid int(10) unsigned NOT NULL default '0',            nid int(10) unsigned NOT NULL default '0',
10            category varchar(80) NOT NULL default '',            category varchar(80) NOT NULL default '',
11                    question longtext NOT NULL default '',            question longtext NOT NULL default '',
12                    qid int(10) unsigned NOT NULL default '0',            answer longtext NOT NULL default '',
13                    rows int(10) unsigned NOT NULL default '5',            qid int(10) unsigned NOT NULL default '0',
14                    cols int(10) unsigned NOT NULL default '5',            row int(10) unsigned NOT NULL default '0',
15            PRIMARY KEY  (nid,qid)            col int(10) unsigned NOT NULL default '0'
16          ) /*!40100 DEFAULT CHARACTER SET utf8 */;");          ) /*!40100 DEFAULT CHARACTER SET utf8 */;"
17          );
18    
19          db_query("CREATE TABLE {jeopardy_rows_cols} (
20              nid int(10) unsigned NOT NULL default '0',
21              rows int(10) unsigned NOT NULL default '0',
22              cols int(10) unsigned NOT NULL default '0'
23            ) /*!40100 DEFAULT CHARACTER SET utf8 */;"
24          );
25        break;        break;
26    
27      case 'pgsql':      case 'pgsql':
28        db_query("CREATE TABLE {jeopardy_questions} (        db_query("CREATE TABLE {jeopardy_questions} (
29            vid serial CHECK (vid >= 0),            nid integer NOT NULL default '0',
30            field_name varchar(32) NOT NULL default '',            category varchar(80),
31            delta integer NOT NULL default '0' CHECK (delta >= 0),            question longtext,
32            field_nid integer NOT NULL default '0' CHECK (field_nid >= 0),            answer longtext,
33            PRIMARY KEY  (vid, field_name, delta)            qid integer NOT NULL default '0',
34          )");            row integer NOT NULL default '0',
35              col integer NOT NULL default '0'
36            )"
37          );
38    
39        // Pgsql requires keys and indexes to be defined separately.        db_query("CREATE TABLE {jeopardy_rows_cols} (
40        // It's important to name the index as {tablename}_fieldname_idx            nid integer NOT NULL default '0',
41        // (the trailing _idx!) so update scripts can be written easily            rows integer NOT NULL default '0',
42        db_query("CREATE INDEX {jeopardy_data}_field_name_idx            cols integer NOT NULL default '0'
43                  ON {my_table} (field_name)");          )"
44          );
45        break;        break;
46    }    }
47  }  }
48  ?>  
49    
Legend:
Removed from v.1.1  
changed lines
  Added in v.1.2
  ViewVC Help
Powered by ViewVC 1.1.2