-
Notifications
You must be signed in to change notification settings - Fork 1
/
schema.sql
59 lines (47 loc) · 2.18 KB
/
schema.sql
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
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
DROP TABLE IF EXISTS `geo_cities`;
CREATE TABLE `geo_cities` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`gov_province_id` int(10) unsigned DEFAULT NULL,
`gov_county_id` int(10) unsigned DEFAULT NULL,
`gov_community_id` int(10) unsigned DEFAULT NULL,
`name` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `geo_cities_gov_province_id_index` (`gov_province_id`),
KEY `geo_cities_gov_county_id_index` (`gov_county_id`),
KEY `geo_cities_gov_community_id_index` (`gov_community_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
DROP TABLE IF EXISTS `geo_communities`;
CREATE TABLE `geo_communities` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`gov_id` int(10) unsigned NOT NULL,
`gov_county_id` int(10) unsigned DEFAULT NULL,
`gov_province_id` int(10) unsigned DEFAULT NULL,
`name` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `geo_communities_gov_county_id_index` (`gov_county_id`),
KEY `geo_communities_gov_province_id_index` (`gov_province_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
DROP TABLE IF EXISTS `geo_counties`;
CREATE TABLE `geo_counties` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`gov_id` int(10) unsigned NOT NULL,
`gov_province_id` int(10) unsigned DEFAULT NULL,
`name` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `geo_counties_gov_province_id_index` (`gov_province_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
DROP TABLE IF EXISTS `geo_provinces`;
CREATE TABLE `geo_provinces` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`gov_id` int(10) unsigned NOT NULL,
`name` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;