-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathgeo_provinces.sql
31 lines (31 loc) · 5.13 KB
/
geo_provinces.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
INSERT INTO power.geo_provinces (code, name, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('11', '北京市', 0, '11', '0', '0', null, 1, '0');
INSERT INTO power.geo_provinces (code, name, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('12', '天津市', 0, null, null, null, null, 2, '0');
INSERT INTO power.geo_provinces (code, name, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('13', '河北省', 0, null, null, null, null, 3, '0');
INSERT INTO power.geo_provinces (code, name, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('14', '山西省', 0, null, null, null, null, 4, '0');
INSERT INTO power.geo_provinces (code, name, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('15', '内蒙古自治区', 0, null, null, null, null, 5, '0');
INSERT INTO power.geo_provinces (code, name, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('21', '辽宁省', 0, null, null, null, null, 6, '0');
INSERT INTO power.geo_provinces (code, name, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('22', '吉林省', 0, null, null, null, null, 7, '0');
INSERT INTO power.geo_provinces (code, name, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('23', '黑龙江省', 0, null, null, null, null, 8, '0');
INSERT INTO power.geo_provinces (code, name, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('31', '上海市', 0, null, null, null, null, 9, '0');
INSERT INTO power.geo_provinces (code, name, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('32', '江苏省', 0, null, null, null, null, 10, '0');
INSERT INTO power.geo_provinces (code, name, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('33', '浙江省', 0, null, null, null, null, 11, '0');
INSERT INTO power.geo_provinces (code, name, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('34', '安徽省', 0, null, null, null, null, 12, '0');
INSERT INTO power.geo_provinces (code, name, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('35', '福建省', 0, null, null, null, null, 13, '0');
INSERT INTO power.geo_provinces (code, name, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('36', '江西省', 0, null, null, null, null, 14, '0');
INSERT INTO power.geo_provinces (code, name, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('37', '山东省', 0, null, null, null, null, 15, '0');
INSERT INTO power.geo_provinces (code, name, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('41', '河南省', 0, null, null, null, null, 16, '0');
INSERT INTO power.geo_provinces (code, name, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('42', '湖北省', 0, null, null, null, null, 17, '0');
INSERT INTO power.geo_provinces (code, name, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('43', '湖南省', 0, null, null, null, null, 18, '0');
INSERT INTO power.geo_provinces (code, name, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('44', '广东省', 0, null, null, null, null, 19, '0');
INSERT INTO power.geo_provinces (code, name, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('45', '广西壮族自治区', 0, null, null, null, null, 20, '0');
INSERT INTO power.geo_provinces (code, name, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('46', '海南省', 0, null, null, null, null, 21, '0');
INSERT INTO power.geo_provinces (code, name, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('50', '重庆市', 0, null, null, null, null, 22, '0');
INSERT INTO power.geo_provinces (code, name, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('51', '四川省', 0, null, null, null, null, 23, '0');
INSERT INTO power.geo_provinces (code, name, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('52', '贵州省', 0, null, null, null, null, 24, '0');
INSERT INTO power.geo_provinces (code, name, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('53', '云南省', 0, null, null, null, null, 25, '0');
INSERT INTO power.geo_provinces (code, name, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('54', '西藏自治区', 0, null, null, null, null, 26, '0');
INSERT INTO power.geo_provinces (code, name, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('61', '陕西省', 0, null, null, null, null, 27, '0');
INSERT INTO power.geo_provinces (code, name, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('62', '甘肃省', 0, null, null, null, null, 28, '0');
INSERT INTO power.geo_provinces (code, name, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('63', '青海省', 0, null, null, null, null, 29, '0');
INSERT INTO power.geo_provinces (code, name, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('64', '宁夏回族自治区', 0, null, null, null, null, 30, '0');
INSERT INTO power.geo_provinces (code, name, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('65', '新疆维吾尔自治区', 0, null, null, null, null, 31, '0');