modules/click2bookmark/click2bookmark.install

<?php
// $Id:$ 

/**
 * Implementation of hook_install().
 */

function click2bookmark_install() {
  
  switch ($GLOBALS['db_type']) {
    
    case 'mysql':
    case 'mysqli':
      db_query("CREATE TABLE {click2bookmark} (
          c2bid INT UNSIGNED NOT NULL AUTO_INCREMENT,
          uid INT UNSIGNED NOT NULL DEFAULT 0,
          path VARCHAR(255) NOT NULL,
          title VARCHAR(255) NOT NULL,
          PRIMARY KEY (c2bid)
      )  /*!40100 DEFAULT CHARACTER SET utf8 */;");
      break;
   
    case 'pgsql':
      db_query("CREATE TABLE {click2bookmark} (
        c2bid serial CHECK (c2bid >= 0),
        uid int NOT NULL default '0',
        path varchar(255) NOT NULL default '',
        title varchar(255) NOT NULL default '',
        PRIMARY KEY (c2bid)
      )");
      break;
    
  } // End case

}


/**
 * Implementation of hook_uninstall().
 */
function click2bookmark_uninstall() {
  db_query('DROP TABLE {click2bookmark}');
  foreach(node_get_types() as $type => $name) {
    variable_del(CLICK2BOOKMARK_NODE_TYPE . $type);
  }  
}
1	<?php
2	// $Id:$
3
4	/**
5	* Implementation of hook_install().
6	*/
7
8	function click2bookmark_install() {
9
10	switch ($GLOBALS['db_type']) {
11
12	case 'mysql':
13	case 'mysqli':
14	db_query("CREATE TABLE {click2bookmark} (
15	c2bid INT UNSIGNED NOT NULL AUTO_INCREMENT,
16	uid INT UNSIGNED NOT NULL DEFAULT 0,
17	path VARCHAR(255) NOT NULL,
18	title VARCHAR(255) NOT NULL,
19	PRIMARY KEY (c2bid)
20	) /!40100 DEFAULT CHARACTER SET utf8 /;");
21	break;
22
23	case 'pgsql':
24	db_query("CREATE TABLE {click2bookmark} (
25	c2bid serial CHECK (c2bid >= 0),
26	uid int NOT NULL default '0',
27	path varchar(255) NOT NULL default '',
28	title varchar(255) NOT NULL default '',
29	PRIMARY KEY (c2bid)
30	)");
31	break;
32
33	} // End case
34
35	}
36
37
38
39
40	/**
41	* Implementation of hook_uninstall().
42	*/
43	function click2bookmark_uninstall() {
44	db_query('DROP TABLE {click2bookmark}');
45	foreach(node_get_types() as $type => $name) {
46	variable_del(CLICK2BOOKMARK_NODE_TYPE . $type);
47	}
48	}