modules/slicedbook_navigation/slicedbook_navigation.install

<?php
function slicedbook_navigation_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysqli':
    case 'mysql':
      $query1 = db_query("CREATE TABLE {slicedbook_navigation} (
                            nid INT NOT NULL,
                            attribute VARCHAR( 128 ) NOT NULL,
                            PRIMARY KEY ( `nid` )
                          ) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;");
      if ($query1) {
 	      $created = TRUE;
 	  }
      break;

    case 'pgsql':
      $query1 = db_query("CREATE TABLE {slicedbook_navigation} (
                            nid INT NOT NULL,
                            attribute VARCHAR(128) NOT NULL,
                            PRIMARY KEY (nid)
                          )");
      if ($query1) {
 	      $created = TRUE;
 	  }
      break;
  }

  if ($created) {
    drupal_set_message(t('Sliced Book Navigation module installed successfully.'));
  }
  else {
    drupal_set_message(t('Table installation for the Sliced Book Navigation module was unsuccessful. The tables may need to be installed by hand.'), 'error');
  }
}
?>
1	<?php
2	function slicedbook_navigation_install() {
3	switch ($GLOBALS['db_type']) {
4	case 'mysqli':
5	case 'mysql':
6	$query1 = db_query("CREATE TABLE {slicedbook_navigation} (
7	nid INT NOT NULL,
8	attribute VARCHAR( 128 ) NOT NULL,
9	PRIMARY KEY ( `nid` )
10	) TYPE=MyISAM /!40100 DEFAULT CHARACTER SET utf8 /;");
11	if ($query1) {
12	$created = TRUE;
13	}
14	break;
15
16	case 'pgsql':
17	$query1 = db_query("CREATE TABLE {slicedbook_navigation} (
18	nid INT NOT NULL,
19	attribute VARCHAR(128) NOT NULL,
20	PRIMARY KEY (nid)
21	)");
22	if ($query1) {
23	$created = TRUE;
24	}
25	break;
26	}
27
28	if ($created) {
29	drupal_set_message(t('Sliced Book Navigation module installed successfully.'));
30	}
31	else {
32	drupal_set_message(t('Table installation for the Sliced Book Navigation module was unsuccessful. The tables may need to be installed by hand.'), 'error');
33	}
34	}
35	?>