-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathinit_db.sql
More file actions
28 lines (28 loc) · 705 Bytes
/
init_db.sql
File metadata and controls
28 lines (28 loc) · 705 Bytes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
/*
This file, when executed by MySQL will go to the geordap database
and create two tables, one to store the results of the
geo ip lookup and the other to store the results of the rdap lookups.
*/
USE geordap;
create table geo_ip(
ip_address VARCHAR(19),
country_code VARCHAR(255),
country_name VARCHAR(255),
region_code VARCHAR(255),
region_name VARCHAR(255),
city VARCHAR(255),
zip_code VARCHAR(255),
time_zone VARCHAR(255),
latitude VARCHAR(255),
longitude VARCHAR(225),
metro_code VARCHAR(255),
PRIMARY KEY(ip_address)
);
create table rdap(
ip_address VARCHAR(19),
start_address VARCHAR(19),
end_address VARCHAR(19),
company_name VARCHAR(255),
company_address VARCHAR(255),
PRIMARY KEY(ip_address)
);