sql/core_geoip_city_network_mapping.sql

sql/core_geoip_city.sql
sql/core_geoip_continent.sql
sql/core_geoip_country_network_mapping.sql
sql/core_geoip_country.sql
sql/core_geoip_division.sql
sql/core_geoip_location.sql

diff --git a/sql/core_geoip_city.sql b/sql/core_geoip_city.sql
deleted file mode 100644 (file)
index 4e73ce3..0000000
--- a/sql/core_geoip_city.sql
+++ /dev/null
@@ -1,22 +0,0 @@
-DROP TABLE IF EXISTS core_geoip_city;
-
--- CREATE  TABLE core_geoip_city (
---     id INT(11) NOT NULL AUTO_INCREMENT ,
---     name VARCHAR(255) NOT NULL DEFAULT '',
---     country_id INT(11) NOT NULL DEFAULT 0,
---     division_id INT(11) NOT NULL DEFAULT 0,
---     postal_code VARCHAR(128) NOT NULL DEFAULT '',
---     metro_code VARCHAR(128) NOT NULL DEFAULT 0,
---     time_zone VARCHAR(128) NOT NULL DEFAULT '',
---     PRIMARY KEY (id)
--- );
--- 
--- CREATE INDEX name_idx ON core_geoip_city (name) USING BTREE;
--- CREATE INDEX country_id_idx ON core_geoip_city (country_id) USING BTREE;
--- CREATE INDEX division_id_idx ON core_geoip_city (division_id) USING BTREE;
--- CREATE INDEX postal_code_idx ON core_geoip_city (postal_code) USING BTREE;
--- CREATE INDEX metro_code_idx ON core_geoip_city (metro_code) USING BTREE;
--- CREATE INDEX time_zone_idx ON core_geoip_city (time_zone) USING BTREE;
--- 
--- CREATE INDEX name_country_id_division_id_idx ON core_geoip_city (name,country_id,division_id) USING BTREE;
--- 

diff --git a/sql/core_geoip_city_network_mapping.sql b/sql/core_geoip_city_network_mapping.sql
deleted file mode 100644 (file)
index d12e4d4..0000000
--- a/sql/core_geoip_city_network_mapping.sql
+++ /dev/null
@@ -1,19 +0,0 @@
-DROP TABLE IF EXISTS core_geoip_network_mapping;
-DROP TABLE IF EXISTS core_geoip_city_network_mapping;
-
--- CREATE  TABLE core_geoip_city_network_mapping (
---     id INT(11) NOT NULL AUTO_INCREMENT ,
---     start_ip VARCHAR(128) NOT NULL DEFAULT '',
---     mask_length INT(11) NOT NULL DEFAULT 0,
---     city_id INT(11) NOT NULL DEFAULT 0,
---     is_anonymous_proxy INT(2) NOT NULL DEFAULT 0,
---     is_satellite_provider INT(2) NOT NULL DEFAULT 0,
---     PRIMARY KEY (id)
--- );
--- 
--- CREATE INDEX start_ip_idx ON core_geoip_city_network_mapping (start_ip) USING BTREE;
--- CREATE INDEX mask_length_idx ON core_geoip_city_network_mapping (mask_length) USING BTREE;
--- CREATE INDEX city_id_idx ON core_geoip_city_network_mapping (city_id) USING BTREE;
--- CREATE INDEX is_anonymous_proxy_idx ON core_geoip_city_network_mapping (is_anonymous_proxy) USING BTREE;
--- CREATE INDEX is_satellite_provider_idx ON core_geoip_city_network_mapping (is_satellite_provider) USING BTREE;
--- 

diff --git a/sql/core_geoip_continent.sql b/sql/core_geoip_continent.sql
deleted file mode 100644 (file)
index 05a4ee7..0000000
--- a/sql/core_geoip_continent.sql
+++ /dev/null
@@ -1,11 +0,0 @@
-DROP TABLE IF EXISTS core_geoip_continent;
-
--- CREATE  TABLE core_geoip_continent (
---     id INT(11) NOT NULL AUTO_INCREMENT ,
---     code VARCHAR(32) NOT NULL DEFAULT '',
---     name VARCHAR(255) NOT NULL DEFAULT '',
---     PRIMARY KEY (id)
--- );
--- 
--- CREATE INDEX code_idx ON core_geoip_continent (code) USING BTREE;
--- CREATE INDEX name_idx ON core_geoip_continent (name) USING BTREE;

diff --git a/sql/core_geoip_country.sql b/sql/core_geoip_country.sql
deleted file mode 100644 (file)
index 2b589e9..0000000
--- a/sql/core_geoip_country.sql
+++ /dev/null
@@ -1,13 +0,0 @@
-DROP TABLE IF EXISTS core_geoip_country;
-
--- CREATE  TABLE core_geoip_country (
---     id INT(11) NOT NULL AUTO_INCREMENT ,
---     code VARCHAR(32) NOT NULL DEFAULT '',
---     name VARCHAR(255) NOT NULL DEFAULT '',
---     continent_id INT(11) NOT NULL DEFAULT 0,
---     PRIMARY KEY (id)
--- );
--- 
--- CREATE INDEX code_idx ON core_geoip_country (code) USING BTREE;
--- CREATE INDEX name_idx ON core_geoip_country (name) USING BTREE;
--- CREATE INDEX continent_id_idx ON core_geoip_country (continent_id) USING BTREE;

diff --git a/sql/core_geoip_country_network_mapping.sql b/sql/core_geoip_country_network_mapping.sql
deleted file mode 100644 (file)
index c0cc288..0000000
--- a/sql/core_geoip_country_network_mapping.sql
+++ /dev/null
@@ -1,18 +0,0 @@
-DROP TABLE IF EXISTS core_geoip_country_network_mapping;
-
--- CREATE  TABLE core_geoip_country_network_mapping (
---     id INT(11) NOT NULL AUTO_INCREMENT ,
---     start_ip VARCHAR(128) NOT NULL DEFAULT '',
---     mask_length INT(11) NOT NULL DEFAULT 0,
---     country_id INT(11) NOT NULL DEFAULT 0,
---     is_anonymous_proxy INT(2) NOT NULL DEFAULT 0,
---     is_satellite_provider INT(2) NOT NULL DEFAULT 0,
---     PRIMARY KEY (id)
--- );
--- 
--- CREATE INDEX start_ip_idx ON core_geoip_country_network_mapping (start_ip) USING BTREE;
--- CREATE INDEX mask_length_idx ON core_geoip_country_network_mapping (mask_length) USING BTREE;
--- CREATE INDEX country_id_idx ON core_geoip_country_network_mapping (country_id) USING BTREE;
--- CREATE INDEX is_anonymous_proxy_idx ON core_geoip_country_network_mapping (is_anonymous_proxy) USING BTREE;
--- CREATE INDEX is_satellite_provider_idx ON core_geoip_country_network_mapping (is_satellite_provider) USING BTREE;
-

diff --git a/sql/core_geoip_division.sql b/sql/core_geoip_division.sql
deleted file mode 100644 (file)
index efb86a8..0000000
--- a/sql/core_geoip_division.sql
+++ /dev/null
@@ -1,15 +0,0 @@
-DROP TABLE IF EXISTS core_geoip_division;
-
--- CREATE  TABLE core_geoip_division (
---     id INT(11) NOT NULL AUTO_INCREMENT ,
---     code VARCHAR(32) NOT NULL DEFAULT '',
---     name VARCHAR(255) NOT NULL DEFAULT '',
---     country_id INT(11) NOT NULL DEFAULT 0,
---     PRIMARY KEY (id)
--- );
--- 
--- CREATE INDEX code_idx ON core_geoip_division (code) USING BTREE;
--- CREATE INDEX name_idx ON core_geoip_division (name) USING BTREE;
--- CREATE INDEX country_id_idx ON core_geoip_division (country_id) USING BTREE;
--- 
--- CREATE INDEX cdoe_country_id_idx ON core_geoip_division (code,country_id) USING BTREE;

diff --git a/sql/core_geoip_location.sql b/sql/core_geoip_location.sql
deleted file mode 100644 (file)
index 784ca36..0000000
--- a/sql/core_geoip_location.sql
+++ /dev/null
@@ -1,13 +0,0 @@
-DROP TABLE IF EXISTS core_geoip_location;
-
--- CREATE  TABLE core_geoip_location (
---     id INT(11) NOT NULL AUTO_INCREMENT ,
---     latitude DECIMAL(11,8) NOT NULL DEFAULT 0,
---     longitude DECIMAL(11,8) NOT NULL DEFAULT 0,
---     city_id INT(11) NOT NULL DEFAULT 0,
---     PRIMARY KEY (id)
--- );
--- 
--- CREATE INDEX latitude_idx ON core_geoip_location (latitude) USING BTREE;
--- CREATE INDEX longitude_idx ON core_geoip_location (longitude) USING BTREE;
--- CREATE INDEX city_id_idx ON core_geoip_location (city_id) USING BTREE;
\ No newline at end of file