CREATE TABLE ip2locationipv6 (

    id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,

    ipv61 VARCHAR(100) NULL,

    ipv62 VARCHAR(100) NULL,

    country_short VARCHAR(3),

    country VARCHAR(100) NULL,

    state VARCHAR(100) NULL,

    city VARCHAR(100) NULL,

    Latitude DECIMAL(12, 6),

    Longitude DECIMAL(12, 6),

    ZipCode VARCHAR(15) NULL,

    region_name VARCHAR(35) NULL,

    region_id INT NULL,

    region_dir VARCHAR(30) NULL

);





CREATE INDEX Index_ip2locationipv6_country_short ON ip2locationipv6 (country_short);

CREATE INDEX Index_ip2locationipv6_country ON ip2locationipv6 (country);

CREATE INDEX Index_ip2locationipv6_state ON ip2locationipv6 (state);

CREATE INDEX Index_ip2locationipv6_city ON ip2locationipv6 (city);

CREATE INDEX Index_ip2locationipv6_Latitude ON ip2locationipv6 (Latitude);

CREATE INDEX Index_ip2locationipv6_Longitude ON ip2locationipv6 (Longitude);

CREATE INDEX Index_ip2locationipv4_ipv62 ON ip2locationipv6 (ipv62);

CREATE INDEX Index_ip2locationipv4_ipv61 ON ip2locationipv6 (ipv61);





CREATE TABLE ip2locationipv4 (

    id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,

    ipv41 VARCHAR(100) NULL,

    ipv42 VARCHAR(100) NULL,

    country_short VARCHAR(3),

    country VARCHAR(100) NULL,

    state VARCHAR(100) NULL,

    city VARCHAR(100) NULL,

    Latitude DECIMAL(12, 6),

    Longitude DECIMAL(12, 6),

    ZipCode VARCHAR(15) NULL,

    region_name VARCHAR(35) NULL,

    region_id INT NULL,

    region_dir VARCHAR(30) NULL

);





CREATE INDEX Index_ip2locationipv4_country_short ON ip2locationipv4 (country_short);

CREATE INDEX Index_ip2locationipv4_country ON ip2locationipv4 (country);

CREATE INDEX Index_ip2locationipv4_state ON ip2locationipv4 (state);

CREATE INDEX Index_ip2locationipv4_city ON ip2locationipv4 (city);

CREATE INDEX Index_ip2locationipv4_Latitude ON ip2locationipv4 (Latitude);

CREATE INDEX Index_ip2locationipv4_Longitude ON ip2locationipv4 (Longitude);

CREATE INDEX Index_ip2locationipv4_ipv42 ON ip2locationipv4 (ipv42);

CREATE INDEX Index_ip2locationipv4_ipv41 ON ip2locationipv4 (ipv41);