modules/casetracker_work/casetracker_work.install

<?php
/* $Id$ */

function casetracker_work_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      db_query("CREATE TABLE casetracker_work (
        ctwid int(10) unsigned NOT NULL auto_increment,
        nid int(10) unsigned NOT NULL default '0',
        uid int(10) unsigned NOT NULL default '0',
        tid int(10) unsigned NOT NULL default '0',
        start int(12) unsigned default '0',
        finish int(12) unsigned default '0',
        duration int(12) unsigned default NULL,
        rate varchar(15) NOT NULL default '',
        locked int(2) unsigned default '0',
        activity text,
        PRIMARY KEY  (ctwid)
      ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");
      break;
  }
  $ret = array();
  $ret = db_query("ALTER TABLE {users} ADD casetracker_rate varchar(15) NOT NULL default ''");
  return $ret;
}

/**
 * Implementation of hook_uninstall().
 */
function casetracker_work_uninstall() {

  $ret = array();
  $ret[] = db_query('DROP TABLE {casetracker_work}');
  $ret[] = db_query('ALTER TABLE {users} DROP casetracker_rate');

  $variables = array(
  );
  foreach ($variables as $variable) {
    variable_del($variable);
  }
  return $ret;
}
1	<?php
2	/* $Id$ */
3
4	function casetracker_work_install() {
5	switch ($GLOBALS['db_type']) {
6	case 'mysql':
7	case 'mysqli':
8	db_query("CREATE TABLE casetracker_work (
9	ctwid int(10) unsigned NOT NULL auto_increment,
10	nid int(10) unsigned NOT NULL default '0',
11	uid int(10) unsigned NOT NULL default '0',
12	tid int(10) unsigned NOT NULL default '0',
13	start int(12) unsigned default '0',
14	finish int(12) unsigned default '0',
15	duration int(12) unsigned default NULL,
16	rate varchar(15) NOT NULL default '',
17	locked int(2) unsigned default '0',
18	activity text,
19	PRIMARY KEY (ctwid)
20	) /!40100 DEFAULT CHARACTER SET UTF8 / ");
21	break;
22	}
23	$ret = array();
24	$ret = db_query("ALTER TABLE {users} ADD casetracker_rate varchar(15) NOT NULL default ''");
25	return $ret;
26	}
27
28	/**
29	* Implementation of hook_uninstall().
30	*/
31	function casetracker_work_uninstall() {
32
33	$ret = array();
34	$ret[] = db_query('DROP TABLE {casetracker_work}');
35	$ret[] = db_query('ALTER TABLE {users} DROP casetracker_rate');
36
37	$variables = array(
38	);
39	foreach ($variables as $variable) {
40	variable_del($variable);
41	}
42	return $ret;
43	}