modules/question/question.install

<?php
function question_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
    case 'pgsql':
      db_query("CREATE TABLE {question_node} (
          nid int(10) NOT NULL default '0',
          questioner varchar(50) NOT NULL default '',
          quid int(10) NOT NULL default '0',
          question text NOT NULL,
          q_format int(4) NOT NULL default '0',
          answer text NOT NULL,
          a_format int(4) NOT NULL default '0',
          PRIMARY KEY  (`nid`)
          );");
      db_query("CREATE TABLE {question_queue} (
          qid int(10) NOT NULL default '0',
          questioner varchar(50) NOT NULL default '',
          quid int(10) NOT NULL default '0',
          question text NOT NULL
          );");
      break;
  }
}

function question_update_1() {
  $items = array();
  $items[] = update_sql("ALTER TABLE {question_node} ADD PRIMARY KEY  (`nid`)");
  $items[] = update_sql("ALTER TABLE {question_queue} ADD PRIMARY KEY  (`qid`)");
  return $items;
}

function question_uninstall() {
  db_query('DROP TABLE {question_node}');
  db_query('DROP TABLE {question_queue}');
  variable_del('question_require_registered');
  variable_del('question_thanks');
}
?>
1	<?php
2	function question_install() {
3	switch ($GLOBALS['db_type']) {
4	case 'mysql':
5	case 'mysqli':
6	case 'pgsql':
7	db_query("CREATE TABLE {question_node} (
8	nid int(10) NOT NULL default '0',
9	questioner varchar(50) NOT NULL default '',
10	quid int(10) NOT NULL default '0',
11	question text NOT NULL,
12	q_format int(4) NOT NULL default '0',
13	answer text NOT NULL,
14	a_format int(4) NOT NULL default '0',
15	PRIMARY KEY (`nid`)
16	);");
17	db_query("CREATE TABLE {question_queue} (
18	qid int(10) NOT NULL default '0',
19	questioner varchar(50) NOT NULL default '',
20	quid int(10) NOT NULL default '0',
21	question text NOT NULL
22	);");
23	break;
24	}
25	}
26
27	function question_update_1() {
28	$items = array();
29	$items[] = update_sql("ALTER TABLE {question_node} ADD PRIMARY KEY (`nid`)");
30	$items[] = update_sql("ALTER TABLE {question_queue} ADD PRIMARY KEY (`qid`)");
31	return $items;
32	}
33
34	function question_uninstall() {
35	db_query('DROP TABLE {question_node}');
36	db_query('DROP TABLE {question_queue}');
37	variable_del('question_require_registered');
38	variable_del('question_thanks');
39	}
40	?>