modules/site_tour/site_tour.install

<?php
// $Id: site_tour.install,v 1.2 2006/11/24 23:37:50 stefano73 Exp $

/**
 * Implementation of hook_install().
 */
function site_tour_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      db_query("CREATE TABLE {site_tour} (
        id int(10) unsigned NOT NULL AUTO_INCREMENT,
        url varchar(128) NOT NULL,
        title varchar(128) NOT NULL,
        description text,
        page tinyint(2) unsigned NOT NULL default '0',
        status tinyint(1) unsigned NOT NULL default '0',
        KEY id_status(id, status),
        KEY url(url(15)),
        KEY title( title(15))
      ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");
      break;
  }
}
1	<?php
2	// $Id: site_tour.install,v 1.2 2006/11/24 23:37:50 stefano73 Exp $
3
4	/**
5	* Implementation of hook_install().
6	*/
7	function site_tour_install() {
8	switch ($GLOBALS['db_type']) {
9	case 'mysql':
10	case 'mysqli':
11	db_query("CREATE TABLE {site_tour} (
12	id int(10) unsigned NOT NULL AUTO_INCREMENT,
13	url varchar(128) NOT NULL,
14	title varchar(128) NOT NULL,
15	description text,
16	page tinyint(2) unsigned NOT NULL default '0',
17	status tinyint(1) unsigned NOT NULL default '0',
18	KEY id_status(id, status),
19	KEY url(url(15)),
20	KEY title( title(15))
21	) /!40100 DEFAULT CHARACTER SET UTF8 / ");
22	break;
23	}
24	}