modules/knurl/knurl.install

<?php
// $Id$


/**
 * Implementation of hook_install().
 */
function knurl_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      db_query("CREATE TABLE {knurl} (
        tid       int(11) auto_increment, -- knurl id
        uid       int(11) unsigned NOT NULL default 0, -- knurl user id
        short_url varchar(255) NOT NULL,
        link      text NOT NULL,
        PRIMARY KEY (tid),
        KEY short_url (short_url)
      ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");
      break;
    default:
      die("Schema for " . $GLOBALS['db_type'] . " not implemented!");
  }
}

/**
 * Implementation of hook_uninstall().
 */
function knurl_uninstall() {
  db_query('DROP TABLE {knurl}');
}
1	<?php
2	// $Id$
3
4
5	/**
6	* Implementation of hook_install().
7	*/
8	function knurl_install() {
9	switch ($GLOBALS['db_type']) {
10	case 'mysql':
11	case 'mysqli':
12	db_query("CREATE TABLE {knurl} (
13	tid int(11) auto_increment, -- knurl id
14	uid int(11) unsigned NOT NULL default 0, -- knurl user id
15	short_url varchar(255) NOT NULL,
16	link text NOT NULL,
17	PRIMARY KEY (tid),
18	KEY short_url (short_url)
19	) /!40100 DEFAULT CHARACTER SET UTF8 / ");
20	break;
21	default:
22	die("Schema for " . $GLOBALS['db_type'] . " not implemented!");
23	}
24	}
25
26	/**
27	* Implementation of hook_uninstall().
28	*/
29	function knurl_uninstall() {
30	db_query('DROP TABLE {knurl}');
31	}