modules/search_keywords/search_keywords.install

<?php
function search_keywords_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      db_query("CREATE TABLE {search_keywords_log} (
                aid int(10) NOT NULL auto_increment,
                title varchar(255) default NULL,
                path varchar(255) default NULL,
                url varchar(255) default NULL,
                hostname varchar(128) default NULL,
                search_engine varchar(255) default NULL,
                keywords varchar(255) default NULL,
                timestamp int(11) unsigned NOT NULL default '0',
                KEY search_keywords_log_timestamp (timestamp),
                PRIMARY KEY (aid)
              ) TYPE=MyISAM
              /*!40100 DEFAULT CHARACTER SET utf8 */ ;");
      break;
    case 'pgsql':
      db_query("CREATE SEQUENCE {search_keywords_log_aid_seq};");
      db_query("CREATE TABLE {search_keywords_log} (
                aid integer NOT NULL DEFAULT nextval( 'search_keywords_log_aid_seq' ),
                title varchar(255) default NULL,
                path varchar(255) default NULL,
                url varchar(255) default NULL,
                hostname varchar(128) default NULL,
                search_engine varchar(255) default NULL,
                keywords varchar(255) default NULL,
                timestamp integer NOT NULL default '0',
                PRIMARY KEY (aid)
              )");
      db_query("CREATE INDEX {search_keywords_log_timestamp_idx} ON search_keywords_log (timestamp);");
      break;
  }
}

function search_keywords_uninstall() {
  db_query("DROP TABLE {search_keywords_log}");
}
?>
1	<?php
2	function search_keywords_install() {
3	switch ($GLOBALS['db_type']) {
4	case 'mysql':
5	case 'mysqli':
6	db_query("CREATE TABLE {search_keywords_log} (
7	aid int(10) NOT NULL auto_increment,
8	title varchar(255) default NULL,
9	path varchar(255) default NULL,
10	url varchar(255) default NULL,
11	hostname varchar(128) default NULL,
12	search_engine varchar(255) default NULL,
13	keywords varchar(255) default NULL,
14	timestamp int(11) unsigned NOT NULL default '0',
15	KEY search_keywords_log_timestamp (timestamp),
16	PRIMARY KEY (aid)
17	) TYPE=MyISAM
18	/!40100 DEFAULT CHARACTER SET utf8 / ;");
19	break;
20	case 'pgsql':
21	db_query("CREATE SEQUENCE {search_keywords_log_aid_seq};");
22	db_query("CREATE TABLE {search_keywords_log} (
23	aid integer NOT NULL DEFAULT nextval( 'search_keywords_log_aid_seq' ),
24	title varchar(255) default NULL,
25	path varchar(255) default NULL,
26	url varchar(255) default NULL,
27	hostname varchar(128) default NULL,
28	search_engine varchar(255) default NULL,
29	keywords varchar(255) default NULL,
30	timestamp integer NOT NULL default '0',
31	PRIMARY KEY (aid)
32	)");
33	db_query("CREATE INDEX {search_keywords_log_timestamp_idx} ON search_keywords_log (timestamp);");
34	break;
35	}
36	}
37
38	function search_keywords_uninstall() {
39	db_query("DROP TABLE {search_keywords_log}");
40	}
41	?>