node_breadcrumb.install in Node breadcrumb 6
File
node_breadcrumb.install
View source
<?php
function node_breadcrumb_install() {
switch ($GLOBALS['db_type']) {
case 'mysql':
case 'mysqli':
db_query("CREATE TABLE {node_breadcrumb_rule} (\n rid int NOT NULL auto_increment,\n node_type varchar(255) default NULL,\n tid1 int default NULL,\n tid2 int default NULL,\n mid int default NULL,\n weight tinyint NOT NULL default '0',\n `condition` text,\n PRIMARY KEY (rid)\n ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");
break;
case 'pgsql':
db_query("CREATE TABLE {node_breadcrumb_rule} (\n rid serial,\n node_type varchar(255) default NULL,\n tid1 integer default NULL,\n tid2 integer default NULL,\n mid integer default NULL,\n weight smallint NOT NULL default '0',\n condition text,\n PRIMARY KEY (rid)\n )");
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}");
}
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;
}