modules/ua_logger/ua_logger.install

<?php

/**
 * Implementation of hook_install().
 */
function ua_logger_install() {
  switch ($GLOBALS['db_type']) {
    case 'pgsql':
      db_query("CREATE TABLE {ua_logger} (
               id SERIAL,
               xid integer default NULL,
               type text not null default null check (type in ('node', 'comment')) ,
               ua text default NULL,
               PRIMARY KEY  (id)
              )");
      break;
    case 'mysql':
    case 'mysqli':
      db_query("CREATE TABLE {ua_logger} (
  		id int(10) unsigned zerofill NOT NULL auto_increment,
  		xid int(10) unsigned zerofill default NULL,
  		type enum('node','comment') default NULL,
  		ua char(150) default NULL,
  		PRIMARY KEY  (id)
		) ENGINE=MyISAM DEFAULT CHARSET=latin1");
      break;
  }
}

?>
1	<?php
2
3	/**
4	* Implementation of hook_install().
5	*/
6	function ua_logger_install() {
7	switch ($GLOBALS['db_type']) {
8	case 'pgsql':
9	db_query("CREATE TABLE {ua_logger} (
10	id SERIAL,
11	xid integer default NULL,
12	type text not null default null check (type in ('node', 'comment')) ,
13	ua text default NULL,
14	PRIMARY KEY (id)
15	)");
16	break;
17	case 'mysql':
18	case 'mysqli':
19	db_query("CREATE TABLE {ua_logger} (
20	id int(10) unsigned zerofill NOT NULL auto_increment,
21	xid int(10) unsigned zerofill default NULL,
22	type enum('node','comment') default NULL,
23	ua char(150) default NULL,
24	PRIMARY KEY (id)
25	) ENGINE=MyISAM DEFAULT CHARSET=latin1");
26	break;
27	}
28	}
29
30	?>