ext_tables.sql

CREATE TABLE static_ip2country_v4
(
    ip_from      int(10) unsigned DEFAULT NULL,
    ip_to        int(10) unsigned DEFAULT NULL,
    country_code char(2) NOT NULL DEFAULT '',
    KEY          idx_ip_from (ip_from),
    KEY          idx_ip_to (ip_to),
    KEY          idx_ip_from_to (ip_from,ip_to)
);

CREATE TABLE static_ip2country_v6
(
    ip_from      decimal(39, 0) unsigned DEFAULT NULL,
    ip_to        decimal(39, 0) unsigned NOT NULL,
    country_code char(2) NOT NULL DEFAULT '',
    KEY          idx_ip_from (ip_from),
    KEY          idx_ip_to (ip_to),
    KEY          idx_ip_from_to (ip_from,ip_to)
);

CREATE TABLE tx_locate_page_region_mm
(
    uid_local   int(11) DEFAULT '0' NOT NULL,
    uid_foreign int(11) DEFAULT '0' NOT NULL,
    sorting     int(11) DEFAULT '0' NOT NULL,

    KEY         uid_local (uid_local),
    KEY         uid_foreign (uid_foreign)
);

CREATE TABLE tx_locate_domain_model_region
(
    title     varchar(255) DEFAULT '' NOT NULL,
    countries text DEFAULT '' NOT NULL,
);

CREATE TABLE pages
(
    tx_locate_regions int DEFAULT 0 NOT NULL,
    tx_locate_invert  smallint(2) DEFAULT 0 NOT NULL
);