modules/top_searches/top_searches.install

<?php

function top_searches_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      $query1 = db_query("
       CREATE TABLE {top_searches} (
      `qid` INT( 11 ) NOT NULL AUTO_INCREMENT ,
      `q` VARCHAR( 255 ) NOT NULL ,
      `counter` INT( 11 ) NULL DEFAULT '0',
      PRIMARY KEY ( `qid` ),
      UNIQUE KEY `q` (`q`)
      )");

      if ($query1) {
        $created = TRUE;
      }
      break;
  }
  if ($created) {
    drupal_set_message(t('Top searches module installed successfully.'));
  }
  else {
    drupal_set_message(t('Table installation for the Top Searches module was unsuccessful. The tables may need to be installed by hand.'), 'error');
  }
}

function top_searches_uninstall() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      db_query("DROP TABLE {top_searches}");
      db_query("DELETE FROM {variable} WHERE name LIKE 'top_searches%'");
      cache_clear_all('variables', 'cache');
      break;
  }
}

1	<?php
2
3	function top_searches_install() {
4	switch ($GLOBALS['db_type']) {
5	case 'mysql':
6	case 'mysqli':
7	$query1 = db_query("
8	CREATE TABLE {top_searches} (
9	`qid` INT( 11 ) NOT NULL AUTO_INCREMENT ,
10	`q` VARCHAR( 255 ) NOT NULL ,
11	`counter` INT( 11 ) NULL DEFAULT '0',
12	PRIMARY KEY ( `qid` ),
13	UNIQUE KEY `q` (`q`)
14	)");
15
16	if ($query1) {
17	$created = TRUE;
18	}
19	break;
20	}
21	if ($created) {
22	drupal_set_message(t('Top searches module installed successfully.'));
23	}
24	else {
25	drupal_set_message(t('Table installation for the Top Searches module was unsuccessful. The tables may need to be installed by hand.'), 'error');
26	}
27	}
28
29	function top_searches_uninstall() {
30	switch ($GLOBALS['db_type']) {
31	case 'mysql':
32	case 'mysqli':
33	db_query("DROP TABLE {top_searches}");
34	db_query("DELETE FROM {variable} WHERE name LIKE 'top_searches%'");
35	cache_clear_all('variables', 'cache');
36	break;
37	}
38	}
39