cc/server/db/sqlite/ch_provinces.sql

INSERT INTO ch_provinces (id,province) VALUES (
1,'北京市');
INSERT INTO ch_provinces (id,province) VALUES (
2,'天津市');
INSERT INTO ch_provinces (id,province) VALUES (
3,'河北省');
INSERT INTO ch_provinces (id,province) VALUES (
4,'山西省');
INSERT INTO ch_provinces (id,province) VALUES (
5,'内蒙古自治区');
INSERT INTO ch_provinces (id,province) VALUES (
6,'辽宁省');
INSERT INTO ch_provinces (id,province) VALUES (
7,'吉林省');
INSERT INTO ch_provinces (id,province) VALUES (
8,'黑龙江省');
INSERT INTO ch_provinces (id,province) VALUES (
9,'上海市');
INSERT INTO ch_provinces (id,province) VALUES (
10,'江苏省');
INSERT INTO ch_provinces (id,province) VALUES (
11,'浙江省');
INSERT INTO ch_provinces (id,province) VALUES (
12,'安徽省');
INSERT INTO ch_provinces (id,province) VALUES (
13,'福建省');
INSERT INTO ch_provinces (id,province) VALUES (
14,'江西省');
INSERT INTO ch_provinces (id,province) VALUES (
15,'山东省');
INSERT INTO ch_provinces (id,province) VALUES (
16,'河南省');
INSERT INTO ch_provinces (id,province) VALUES (
17,'湖北省');
INSERT INTO ch_provinces (id,province) VALUES (
18,'湖南省');
INSERT INTO ch_provinces (id,province) VALUES (
19,'广东省');
INSERT INTO ch_provinces (id,province) VALUES (
20,'广西壮族自治区');
INSERT INTO ch_provinces (id,province) VALUES (
21,'海南省');
INSERT INTO ch_provinces (id,province) VALUES (
22,'重庆市');
INSERT INTO ch_provinces (id,province) VALUES (
23,'四川省');
INSERT INTO ch_provinces (id,province) VALUES (
24,'贵州省');
INSERT INTO ch_provinces (id,province) VALUES (
25,'云南省');
INSERT INTO ch_provinces (id,province) VALUES (
26,'西藏自治区');
INSERT INTO ch_provinces (id,province) VALUES (
27,'陕西省');
INSERT INTO ch_provinces (id,province) VALUES (
28,'甘肃省');
INSERT INTO ch_provinces (id,province) VALUES (
29,'青海省');
INSERT INTO ch_provinces (id,province) VALUES (
30,'宁夏回族自治区');
INSERT INTO ch_provinces (id,province) VALUES (
31,'新疆维吾尔自治区');