<?php
/* $Id: node_time_tracker.install,v 1.2.2.2 2007/03/04 18:00:20 robertgarrigos Exp $ */

/**
 * Implementation of hook_install()
 */
function timetracker_install() {
  
  switch ($GLOBALS['db_type']) {
    case 'mysqli':
    case 'mysql':
      db_query("CREATE TABLE {timetracker} (
              ttid INT(10) unsigned  NOT NULL AUTO_INCREMENT ,
              uid INT unsigned  NOT NULL,
              start INT(11) unsigned,
              time INT(11) unsigned,
              comment varchar(255) default '',
              KEY (ttid),
              KEY (uid),
              KEY (start),
              PRIMARY KEY (ttid)
              ) /*!40100 DEFAULT CHARACTER SET utf8 */;");

      db_query("CREATE TABLE {timetracker_term} (
        ttid int unsigned NOT NULL default '0',
        tid int unsigned NOT NULL default '0',
        KEY ttid (ttid),
        KEY tid (tid),
        PRIMARY KEY (tid,ttid)
      ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");

      break;
    case 'pgsql':
      /* XXX: untested! beware! Use this to port: http://drupal.org/node/1395 */
      db_query("CREATE TABLE {timetracker} (
              ttid serial CHECK (ttid >= 0),
              uid int_unsigned  NOT NULL default '0',
              start int_unsigned NOT NULL default '0',
              time int_unsigned NOT NULL default '0',
              comment varchar(255) NOT NULL default '',
              PRIMARY KEY (ttid)
              )");
      db_query("CREATE INDEX {timetracker}_ttid_idx ON {node} (ttid)");
      db_query("CREATE INDEX {timetracker}_uid_idx ON {node} (uid)");
      db_query("CREATE INDEX {timetracker}_start_idx ON {timetracker} (start)");

      db_query("CREATE TABLE {timetracker_term} (
        ttid int_unsigned NOT NULL default '0',
        tid int_unsigned NOT NULL default '0',
        PRIMARY KEY (tid,ttid)
      )");
      db_query("CREATE INDEX {timetracker_term}_ttid_idx ON {timetracker_term} (ttid)");
      db_query("CREATE INDEX {timetracker_term}_tid_idx ON {timetracker_term} (tid)");

      break;
  }
}

/**
 * Implementation of hook_uninstall()
 */
function timetracker_uninstall() {
  db_query('DROP TABLE {timetracker}');
}