modules/todolist/todolist.install

<?php
// $Id: todolist.install,v 1.3 2008/07/29 22:11:22 marvil07 Exp $

/**
 * Implementation of hook_install().
 */
function todolist_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      db_query("
      CREATE TABLE {todolist_task} (
       `tid` int(10) unsigned NOT NULL auto_increment,
       `nid` int(10) unsigned NOT NULL,
       `sort` int(10) NOT NULL,
       `status` int(11) NOT NULL,
       `task` varchar(255) NOT NULL,
       PRIMARY KEY  (`tid`)
      ) ENGINE=MyISAM DEFAULT CHARSET=utf8;");
      break;
    case 'pgsql':
      db_query("
        CREATE TABLE {todolist_task} (
          tid SERIAL,
          nid smallint NOT NULL,
          sort smallint NOT NULL,
          status smallint NOT NULL,
          task varchar(255) NOT NULL,
          PRIMARY KEY (tid));
      ");
      break;
  }
}

/**
 * Implementation of hook_install().
 */
function todolist_uninstall() {
  if (db_table_exists('todolist_task')) {
    db_query("DROP TABLE {todolist_task}");
  }
}

// change a field name because it's a reserverd word in pgsql
function todolist_update_1() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      $ret[] = update_sql("ALTER TABLE {todolist_task} CHANGE `order` `sort` INT(10) NOT NULL");
    break;
  }

  return $ret;
}

1	<?php
2	// $Id: todolist.install,v 1.3 2008/07/29 22:11:22 marvil07 Exp $
3
4	/**
5	* Implementation of hook_install().
6	*/
7	function todolist_install() {
8	switch ($GLOBALS['db_type']) {
9	case 'mysql':
10	case 'mysqli':
11	db_query("
12	CREATE TABLE {todolist_task} (
13	`tid` int(10) unsigned NOT NULL auto_increment,
14	`nid` int(10) unsigned NOT NULL,
15	`sort` int(10) NOT NULL,
16	`status` int(11) NOT NULL,
17	`task` varchar(255) NOT NULL,
18	PRIMARY KEY (`tid`)
19	) ENGINE=MyISAM DEFAULT CHARSET=utf8;");
20	break;
21	case 'pgsql':
22	db_query("
23	CREATE TABLE {todolist_task} (
24	tid SERIAL,
25	nid smallint NOT NULL,
26	sort smallint NOT NULL,
27	status smallint NOT NULL,
28	task varchar(255) NOT NULL,
29	PRIMARY KEY (tid));
30	");
31	break;
32	}
33	}
34
35	/**
36	* Implementation of hook_install().
37	*/
38	function todolist_uninstall() {
39	if (db_table_exists('todolist_task')) {
40	db_query("DROP TABLE {todolist_task}");
41	}
42	}
43
44	// change a field name because it's a reserverd word in pgsql
45	function todolist_update_1() {
46	switch ($GLOBALS['db_type']) {
47	case 'mysql':
48	case 'mysqli':
49	$ret[] = update_sql("ALTER TABLE {todolist_task} CHANGE `order` `sort` INT(10) NOT NULL");
50	break;
51	}
52
53	return $ret;
54	}
55