modules/node_breadcrumb/node_breadcrumb.install

<?php
// $Id: node_breadcrumb.install,v 1.7 2008/05/01 04:18:40 edhel Exp $

function node_breadcrumb_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      db_query("CREATE TABLE {node_breadcrumb_rule} (
        rid int NOT NULL auto_increment,
        node_type varchar(255) default NULL,
        tid1 int default NULL,
        tid2 int default NULL,
        mid int default NULL,
        weight tinyint NOT NULL default '0',
        `condition` text,
        PRIMARY KEY  (rid)
      ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");
      break;
    case 'pgsql':
      db_query("CREATE TABLE {node_breadcrumb_rule} (
        rid serial,
        node_type varchar(255) default NULL,
        tid1 integer default NULL,
        tid2 integer default NULL,
        mid integer default NULL,
        weight smallint NOT NULL default '0',
        condition text,
        PRIMARY KEY  (rid)
      )");
      break;
  }
  drupal_set_message("node_breadcrumb_rule table created.");
}

function node_breadcrumb_uninstall() {
  if (db_table_exists('node_breadcrumb_rule')) {
    db_query("DROP TABLE {node_breadcrumb_rule}");
  }
  variable_del('node_breadcrumb_add_active_class');
  drupal_set_message("node_breadcrumb_rule table dropped.");
}

function node_breadcrumb_update_1() {
  $ret[] = update_sql("ALTER TABLE {node_breadcrumb_rule} ADD condition text");
  return $ret;
}
1	<?php
2	// $Id: node_breadcrumb.install,v 1.7 2008/05/01 04:18:40 edhel Exp $
3
4	function node_breadcrumb_install() {
5	switch ($GLOBALS['db_type']) {
6	case 'mysql':
7	case 'mysqli':
8	db_query("CREATE TABLE {node_breadcrumb_rule} (
9	rid int NOT NULL auto_increment,
10	node_type varchar(255) default NULL,
11	tid1 int default NULL,
12	tid2 int default NULL,
13	mid int default NULL,
14	weight tinyint NOT NULL default '0',
15	`condition` text,
16	PRIMARY KEY (rid)
17	) /!40100 DEFAULT CHARACTER SET UTF8 / ");
18	break;
19	case 'pgsql':
20	db_query("CREATE TABLE {node_breadcrumb_rule} (
21	rid serial,
22	node_type varchar(255) default NULL,
23	tid1 integer default NULL,
24	tid2 integer default NULL,
25	mid integer default NULL,
26	weight smallint NOT NULL default '0',
27	condition text,
28	PRIMARY KEY (rid)
29	)");
30	break;
31	}
32	drupal_set_message("node_breadcrumb_rule table created.");
33	}
34
35	function node_breadcrumb_uninstall() {
36	if (db_table_exists('node_breadcrumb_rule')) {
37	db_query("DROP TABLE {node_breadcrumb_rule}");
38	}
39	variable_del('node_breadcrumb_add_active_class');
40	drupal_set_message("node_breadcrumb_rule table dropped.");
41	}
42
43	function node_breadcrumb_update_1() {
44	$ret[] = update_sql("ALTER TABLE {node_breadcrumb_rule} ADD condition text");
45	return $ret;
46	}