modules/node_badges/node_badges.install

<?php
// $Id$

/**
 * Implementation of hook_install().
 */
function node_badges_install() {
  switch ($GLOBALS['db_type']) {
    case 'pgsql':
      db_query('CREATE TABLE {node_badges_badges} (
      	bid serial CHECK (bid >= 0),
      	source varchar(255) NOT NULL default \'\',
      	caption varchar(255) NOT NULL default \'\',
      	description text NOT NULL,
      	PRIMARY KEY (bid)
      )');
      db_query('CREATE TABLE {node_badges_badges_roles} (
      	bid int_unsigned NOT NULL default 0,
      	rid int_unsigned NOT NULL default 0,
      	PRIMARY KEY (bid, rid)
      )');
      db_query('CREATE TABLE {node_badges_badges_types} (
      	bid int_unsigned NOT NULL default 0,
      	type varchar(32) NOT NULL,
      	PRIMARY KEY (bid, type)
      )');
      db_query('CREATE TABLE {node_badges_nodes} (
      	nid int_unsigned NOT NULL default 0,
      	bid int_unsigned NOT NULL default 0,
      	PRIMARY KEY (nid, bid)
      )');
      break;

    case 'mysql':
    case 'mysqli':
      db_query('CREATE TABLE {node_badges_badges} (
        bid INT unsigned NOT NULL auto_increment, 
        source VARCHAR(255) NOT NULL DEFAULT \'\', 
        caption VARCHAR(255) NOT NULL DEFAULT \'\', 
        description MEDIUMTEXT NOT NULL, 
        PRIMARY KEY (bid)
        ) /*!40100 DEFAULT CHARACTER SET UTF8 */');
      db_query('CREATE TABLE {node_badges_badges_roles} (
        bid INT unsigned NOT NULL DEFAULT 0, 
        rid INT unsigned NOT NULL DEFAULT 0, 
        PRIMARY KEY (bid, rid)
        ) /*!40100 DEFAULT CHARACTER SET UTF8 */');
      db_query('CREATE TABLE {node_badges_badges_types} (
        bid INT unsigned NOT NULL DEFAULT 0, 
        type VARCHAR(32) NOT NULL, 
        PRIMARY KEY (bid, type)
        ) /*!40100 DEFAULT CHARACTER SET UTF8 */');
      db_query('CREATE TABLE {node_badges_nodes} (
        nid INT unsigned NOT NULL DEFAULT 0, 
        bid INT unsigned NOT NULL DEFAULT 0, 
        PRIMARY KEY (nid, bid)
        ) /*!40100 DEFAULT CHARACTER SET UTF8 */');
      break;
  }
}

/**
 * Implementation of hook_uninstall().
 */
function node_badges_uninstall() {
  db_query('DROP TABLE {node_badges_badges}');
  db_query('DROP TABLE {node_badges_badges_roles}');
  db_query('DROP TABLE {node_badges_badges_types}');
  db_query('DROP TABLE {node_badges_nodes}');
}
1	<?php
2	// $Id$
3
4	/**
5	* Implementation of hook_install().
6	*/
7	function node_badges_install() {
8	switch ($GLOBALS['db_type']) {
9	case 'pgsql':
10	db_query('CREATE TABLE {node_badges_badges} (
11	bid serial CHECK (bid >= 0),
12	source varchar(255) NOT NULL default \'\',
13	caption varchar(255) NOT NULL default \'\',
14	description text NOT NULL,
15	PRIMARY KEY (bid)
16	)');
17	db_query('CREATE TABLE {node_badges_badges_roles} (
18	bid int_unsigned NOT NULL default 0,
19	rid int_unsigned NOT NULL default 0,
20	PRIMARY KEY (bid, rid)
21	)');
22	db_query('CREATE TABLE {node_badges_badges_types} (
23	bid int_unsigned NOT NULL default 0,
24	type varchar(32) NOT NULL,
25	PRIMARY KEY (bid, type)
26	)');
27	db_query('CREATE TABLE {node_badges_nodes} (
28	nid int_unsigned NOT NULL default 0,
29	bid int_unsigned NOT NULL default 0,
30	PRIMARY KEY (nid, bid)
31	)');
32	break;
33
34	case 'mysql':
35	case 'mysqli':
36	db_query('CREATE TABLE {node_badges_badges} (
37	bid INT unsigned NOT NULL auto_increment,
38	source VARCHAR(255) NOT NULL DEFAULT \'\',
39	caption VARCHAR(255) NOT NULL DEFAULT \'\',
40	description MEDIUMTEXT NOT NULL,
41	PRIMARY KEY (bid)
42	) /!40100 DEFAULT CHARACTER SET UTF8 /');
43	db_query('CREATE TABLE {node_badges_badges_roles} (
44	bid INT unsigned NOT NULL DEFAULT 0,
45	rid INT unsigned NOT NULL DEFAULT 0,
46	PRIMARY KEY (bid, rid)
47	) /!40100 DEFAULT CHARACTER SET UTF8 /');
48	db_query('CREATE TABLE {node_badges_badges_types} (
49	bid INT unsigned NOT NULL DEFAULT 0,
50	type VARCHAR(32) NOT NULL,
51	PRIMARY KEY (bid, type)
52	) /!40100 DEFAULT CHARACTER SET UTF8 /');
53	db_query('CREATE TABLE {node_badges_nodes} (
54	nid INT unsigned NOT NULL DEFAULT 0,
55	bid INT unsigned NOT NULL DEFAULT 0,
56	PRIMARY KEY (nid, bid)
57	) /!40100 DEFAULT CHARACTER SET UTF8 /');
58	break;
59	}
60	}
61
62	/**
63	* Implementation of hook_uninstall().
64	*/
65	function node_badges_uninstall() {
66	db_query('DROP TABLE {node_badges_badges}');
67	db_query('DROP TABLE {node_badges_badges_roles}');
68	db_query('DROP TABLE {node_badges_badges_types}');
69	db_query('DROP TABLE {node_badges_nodes}');
70	}