modules/ad_geoip/ad_geoip.install

<?php
// $Id: $

/**
 * Ad GeoIP module database schema.
 * Copyright (c) 2008 Jeremy Andrews <jeremy@tag1consulting.com>.
 */

function ad_geoip_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
    default:
      db_query("CREATE TABLE {ad_geoip_codes} (
        code CHAR(2) NOT NULL DEFAULT '',
        country varchar(64),
        PRIMARY KEY code (code)
      ) /*!40100 DEFAULT CHARACTER SET UTF8 */");

      db_query("CREATE TABLE {ad_geoip_ads} (
        aid INT(11) NOT NULL DEFAULT '0',
        code CHAR(2) NOT NULL DEFAULT '',
        format INT(1) NOT NULL DEFAULT '0',
        PRIMARY KEY aid_code (aid, code)
      ) /*!40100 DEFAULT CHARACTER SET UTF8 */");

      break;
  }
}
1	<?php
2	// $Id: $
3
4	/**
5	* Ad GeoIP module database schema.
6	* Copyright (c) 2008 Jeremy Andrews <jeremy@tag1consulting.com>.
7	*/
8
9	function ad_geoip_install() {
10	switch ($GLOBALS['db_type']) {
11	case 'mysql':
12	case 'mysqli':
13	default:
14	db_query("CREATE TABLE {ad_geoip_codes} (
15	code CHAR(2) NOT NULL DEFAULT '',
16	country varchar(64),
17	PRIMARY KEY code (code)
18	) /!40100 DEFAULT CHARACTER SET UTF8 /");
19
20	db_query("CREATE TABLE {ad_geoip_ads} (
21	aid INT(11) NOT NULL DEFAULT '0',
22	code CHAR(2) NOT NULL DEFAULT '',
23	format INT(1) NOT NULL DEFAULT '0',
24	PRIMARY KEY aid_code (aid, code)
25	) /!40100 DEFAULT CHARACTER SET UTF8 /");
26
27	break;
28	}
29	}