<?php
// jeopardy.install

function jeopardy_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 {jeopardy_questions} (
		  nid int(10) unsigned NOT NULL default '0',
          category varchar(80) NOT NULL default '',
		  question longtext NOT NULL default '',
		  qid int(10) unsigned NOT NULL default '0',
		  rows int(10) unsigned NOT NULL default '5',
		  cols int(10) unsigned NOT NULL default '5',
          PRIMARY KEY  (nid,qid)
        ) /*!40100 DEFAULT CHARACTER SET utf8 */;");
      break;
 
    case 'pgsql':
      db_query("CREATE TABLE {jeopardy_questions} (
          vid serial CHECK (vid >= 0),
          field_name varchar(32) NOT NULL default '',
          delta integer NOT NULL default '0' CHECK (delta >= 0),
          field_nid integer NOT NULL default '0' CHECK (field_nid >= 0),
          PRIMARY KEY  (vid, field_name, delta)
        )");

      // Pgsql requires keys and indexes to be defined separately.
      // It's important to name the index as {tablename}_fieldname_idx
      // (the trailing _idx!) so update scripts can be written easily
      db_query("CREATE INDEX {jeopardy_data}_field_name_idx
                ON {my_table} (field_name)");
      break;
  }
}
?>