modules/urlborg/urlborg.install

<?php
// $Id: urlborb.install,v 0.1 2008/7/2 16:50:42 nsyll Exp $

/**
 * Implementation of hook_install().
 */
function urlborg_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      db_query("CREATE TABLE {urlborg} (
        nid int(10) unsigned NOT NULL default '0',
        created int(11) NOT NULL default '0',
        s_key varchar(9) NOT NULL default '0',
        o_url varchar(255) NOT NULL default '0',
        s_domain varchar(9) NOT NULL default '0',
        s_url varchar(255) NOT NULL default '0'
      ) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;"
    );
    break;

    case 'pgsql':
      db_query("CREATE TABLE {urlborg} (
        nid integer NOT NULL,
        created integer NOT NULL,
        s_key varchar(9) NOT NULL,
        o_url varchar(60) NOT NULL,
        s_domain varchar(9) NOT NULL,
        s_url varchar(255) NOT NULL,
        PRIMARY KEY (nid)
      )");
      db_query("CREATE SEQUENCE {trackback_received}_nid_seq");
      db_query("CREATE INDEX {trackback_received}_nid_idx ON {trackback_received}(nid)");

      break;
  }
}

function urlborg_uninstall(){
  db_query('DROP TABLE {urlborg}');
}
1	<?php
2	// $Id: urlborb.install,v 0.1 2008/7/2 16:50:42 nsyll Exp $
3
4	/**
5	* Implementation of hook_install().
6	*/
7	function urlborg_install() {
8	switch ($GLOBALS['db_type']) {
9	case 'mysql':
10	case 'mysqli':
11	db_query("CREATE TABLE {urlborg} (
12	nid int(10) unsigned NOT NULL default '0',
13	created int(11) NOT NULL default '0',
14	s_key varchar(9) NOT NULL default '0',
15	o_url varchar(255) NOT NULL default '0',
16	s_domain varchar(9) NOT NULL default '0',
17	s_url varchar(255) NOT NULL default '0'
18	) TYPE=MyISAM /!40100 DEFAULT CHARACTER SET utf8 /;"
19	);
20	break;
21
22	case 'pgsql':
23	db_query("CREATE TABLE {urlborg} (
24	nid integer NOT NULL,
25	created integer NOT NULL,
26	s_key varchar(9) NOT NULL,
27	o_url varchar(60) NOT NULL,
28	s_domain varchar(9) NOT NULL,
29	s_url varchar(255) NOT NULL,
30	PRIMARY KEY (nid)
31	)");
32	db_query("CREATE SEQUENCE {trackback_received}_nid_seq");
33	db_query("CREATE INDEX {trackback_received}_nid_idx ON {trackback_received}(nid)");
34
35	break;
36	}
37	}
38
39	function urlborg_uninstall(){
40	db_query('DROP TABLE {urlborg}');
41	}