modules/geonames_cck/geoapi.install

<?php
function geoapi_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysqli':
    case 'mysql':
      db_query("CREATE TABLE if not exists {geonamesalias} (
        geonameid int(10) unsigned NOT NULL,
        alias varchar(128) NOT NULL,
        name varchar(255) NOT NULL,
        PRIMARY KEY (geonameid),
        KEY (alias)
      ) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;");
      break;
    case 'pgsql':
      break;
    default:
      break;
  }
}

function geoapi_update_1() {
  $result[] = update_sql("CREATE TABLE if not exists {geonamesalias} (
        geonameid int(10) unsigned NOT NULL,
        alias varchar(128) NOT NULL,
        name varchar(255) NOT NULL,
        PRIMARY KEY (geonameid),
        KEY (alias)
      ) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;");
  return $result;
}
?>
1	<?php
2	function geoapi_install() {
3	switch ($GLOBALS['db_type']) {
4	case 'mysqli':
5	case 'mysql':
6	db_query("CREATE TABLE if not exists {geonamesalias} (
7	geonameid int(10) unsigned NOT NULL,
8	alias varchar(128) NOT NULL,
9	name varchar(255) NOT NULL,
10	PRIMARY KEY (geonameid),
11	KEY (alias)
12	) TYPE=MyISAM /!40100 DEFAULT CHARACTER SET utf8 /;");
13	break;
14	case 'pgsql':
15	break;
16	default:
17	break;
18	}
19	}
20
21	function geoapi_update_1() {
22	$result[] = update_sql("CREATE TABLE if not exists {geonamesalias} (
23	geonameid int(10) unsigned NOT NULL,
24	alias varchar(128) NOT NULL,
25	name varchar(255) NOT NULL,
26	PRIMARY KEY (geonameid),
27	KEY (alias)
28	) TYPE=MyISAM /!40100 DEFAULT CHARACTER SET utf8 /;");
29	return $result;
30	}
31	?>