<?php
// $Id: sko_taskmanagement.install, v 2 2007/10/28 19:27:27 $

/**
* Implementation of hook_install().
*/
function sko_taskmanagement_install() {
  switch($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      db_query("CREATE TABLE {sko_taskmanagement_tasks} (
        `nid` INT( 6 ) NOT NULL DEFAULT '0',
        `manager` INT( 6 ) NOT NULL DEFAULT '0',
        `status` ENUM( 'open', 'in-progress', 'pending-other-task', 'finished' ) NOT NULL DEFAULT 'open',
        `progress` INT( 3 ) NOT NULL,
        `parent` INT( 6 ) NOT NULL DEFAULT '0',
        `deadline_ts` INT( 10 ) NOT NULL DEFAULT '0',
        `completion_ts` INT( 10 ) NOT NULL DEFAULT '0',
        PRIMARY KEY ( `nid` )
      ) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;");
     
      // db_query("CREATE TABLE {sko_taskmanagement_dependence} (
        // `nid` INT( 6 ) NOT NULL DEFAULT '0',
        // `dependend_on` INT( 6 ) NOT NULL DEFAULT '0',
        // PRIMARY KEY ( `nid` , `dependend_on` )
      // ) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;");
      
      db_query("CREATE TABLE {sko_taskmanagement_users} (
        `nid` INT( 6 ) NOT NULL DEFAULT '0',
        `uid` INT( 6 ) NOT NULL DEFAULT '0',
        PRIMARY KEY ( `nid` , `uid` )
      ) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;");

      //Edit the authenticated user
      $result = db_query("SELECT `perm` FROM {permission} WHERE `rid` = 2");
      $permissions = db_fetch_object($result);
      $perm = $permissions->perm.", edit own sko tasks, view sko tasks";
      db_query("UPDATE {permission} SET `perm` = '".$perm."' WHERE `rid` = 2");

      //Edit the anomynous user
      //$result = db_query("SELECT `perm` FROM {permission} WHERE `rid` = 1");
      //$permissions = db_fetch_object($result);
      //$perm = $permissions->perm.", view sko tasks";
      //db_query("UPDATE {permission} SET `perm` = '".$perm."' WHERE `rid` = 1");

      //Insert role for taskposter
      db_query("INSERT INTO {role} (`name`) VALUES ('sko taskmanagement taskposter')");
      $result = db_query("SELECT `rid` FROM {role} WHERE `name` = 'sko taskmanagement taskposter'");
      $roles = db_fetch_object($result);
      db_query("INSERT INTO {permission} (`rid`, `perm`) VALUES ('".$roles->rid."', 'create sko tasks, edit own sko tasks, view sko tasks')");
      break;
    
    default:
      die("Database ".$GLOBALS['db_type']." isn't supported in this module.");
      break;
  }
}

/**
* Implementation of hook_uninstall().
*/
function sko_taskmanagement_uninstall() {
  db_query('DROP TABLE {sko_taskmanagement_tasks}, {sko_taskmanagement_users};'); //{sko_taskmanagement_dependence}, 
  db_query("DELETE FROM {node} WHERE `type` = 'sko_task'");
  db_query("DELETE FROM {role} WHERE `name` = 'sko taskmanagement taskposter'");
}

?>