function node_breadcrumb_install in Node breadcrumb 6

File

./node_breadcrumb.install, line 3

Code

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.");
}