XEMGXdCJ

1-- --------------------------------------------------------------------------------
2-- --------------------------------------------------------------------------------
3--
4-- Table structure for ip to latitude and longitude map `v3_ip_mapping`
5--
6CREATE TABLE IF NOT EXISTS `v3_ip_mapping` (
7    `ipstart` INT UNSIGNED NOT NULL,
8    `ipend` INT UNSIGNED NOT NULL,
9    `latitude` FLOAT NOT NULL,
10    `longitude` FLOAT NOT NULL,
11    PRIMARY KEY (`ipstart`),
12    UNIQUE KEY `ipstart` (`ipstart`),
13    UNIQUE KEY `ipend` (`ipend`)
14)
15    ENGINE = InnoDB
16    DEFAULT CHARSET = utf8mb4
17    COLLATE = utf8mb4_unicode_ci;
18
19-- --------------------------------------------------------------------------------