中华人民共和国国家统计局 行政区划代码 - TFdream/blog GitHub Wiki
中华人民共和国国家统计局>>行政区划代码：
CREATE TABLE `tb_provinces` (
`id` bigint(15) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
`name` varchar(64) NOT NULL DEFAULT '' COMMENT '省份名',
`adn_code` varchar(8) NOT NULL DEFAULT '' COMMENT 'ADN编码',
`type` tinyint(2) NOT NULL DEFAULT '0' COMMENT '类型：0:省, 1:直辖市, 2:自治区, 3:特别行政区',
`first_letter` varchar(3) NOT NULL DEFAULT '' COMMENT '省份名首字母',
`opened` bit(1) NOT NULL DEFAULT b'0' COMMENT '省份是否开放：0:未开放，1:开放',
`created_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`modified_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '1: deleted, 0: normal',
PRIMARY KEY (`id`),
UNIQUE KEY `INDEX_adn_code` (`adn_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='小白贷开放省份列表';
INSERT INTO `tb_provinces`(name, adn_code, TYPE, first_letter, opened) VALUES ('北京市', '110000', 1, 'B', b'1');
INSERT INTO `tb_provinces`(name, adn_code, TYPE, first_letter, opened) VALUES ('天津市', '120000', 1, 'T', b'1');
INSERT INTO `tb_provinces`(name, adn_code, TYPE, first_letter, opened) VALUES ('河北省', '130000', 0, 'H', b'1');
INSERT INTO `tb_provinces`(name, adn_code, TYPE, first_letter, opened) VALUES ('山西省', '140000', 0, 'S', b'1');
INSERT INTO `tb_provinces`(name, adn_code, TYPE, first_letter, opened) VALUES ('内蒙古自治区', '150000', 2, 'N', b'1');
INSERT INTO `tb_provinces`(name, adn_code, TYPE, first_letter, opened) VALUES ('辽宁省', '210000', 0, 'L', b'1');
INSERT INTO `tb_provinces`(name, adn_code, TYPE, first_letter, opened) VALUES ('吉林省', '220000', 0, 'J', b'1');
INSERT INTO `tb_provinces`(name, adn_code, TYPE, first_letter, opened) VALUES ('黑龙江省', '230000', 0, 'H', b'1');
INSERT INTO `tb_provinces`(name, adn_code, TYPE, first_letter, opened) VALUES ('上海市', '310000', 1, 'S', b'1');
INSERT INTO `tb_provinces`(name, adn_code, TYPE, first_letter, opened) VALUES ('江苏省', '320000', 0, 'J', b'1');
INSERT INTO `tb_provinces`(name, adn_code, TYPE, first_letter, opened) VALUES ('浙江省', '330000', 0, 'Z', b'1');
INSERT INTO `tb_provinces`(name, adn_code, TYPE, first_letter, opened) VALUES ('安徽省', '340000', 0, 'A', b'1');
INSERT INTO `tb_provinces`(name, adn_code, TYPE, first_letter, opened) VALUES ('福建省', '350000', 0, 'F', b'1');
INSERT INTO `tb_provinces`(name, adn_code, TYPE, first_letter, opened) VALUES ('江西省', '360000', 0, 'J', b'1');
INSERT INTO `tb_provinces`(name, adn_code, TYPE, first_letter, opened) VALUES ('山东省', '370000', 0, 'S', b'1');
INSERT INTO `tb_provinces`(name, adn_code, TYPE, first_letter, opened) VALUES ('河南省', '410000', 0, 'H', b'1');
INSERT INTO `tb_provinces`(name, adn_code, TYPE, first_letter, opened) VALUES ('湖北省', '420000', 0, 'H', b'1');
INSERT INTO `tb_provinces`(name, adn_code, TYPE, first_letter, opened) VALUES ('湖南省', '430000', 0, 'H', b'1');
INSERT INTO `tb_provinces`(name, adn_code, TYPE, first_letter, opened) VALUES ('广东省', '440000', 0, 'G', b'1');
INSERT INTO `tb_provinces`(name, adn_code, TYPE, first_letter, opened) VALUES ('广西壮族自治区', '450000', 2, 'G', b'1');
INSERT INTO `tb_provinces`(name, adn_code, TYPE, first_letter, opened) VALUES ('海南省', '460000', 0, 'H', b'1');
INSERT INTO `tb_provinces`(name, adn_code, TYPE, first_letter, opened) VALUES ('重庆市', '500000', 1, 'C', b'1');
INSERT INTO `tb_provinces`(name, adn_code, TYPE, first_letter, opened) VALUES ('四川省', '510000', 0, 'S', b'1');
INSERT INTO `tb_provinces`(name, adn_code, TYPE, first_letter, opened) VALUES ('贵州省', '520000', 0, 'G', b'1');
INSERT INTO `tb_provinces`(name, adn_code, TYPE, first_letter, opened) VALUES ('云南省', '530000', 0, 'Y', b'1');
INSERT INTO `tb_provinces`(name, adn_code, TYPE, first_letter, opened) VALUES ('西藏自治区', '540000', 2, 'X', b'0');
INSERT INTO `tb_provinces`(name, adn_code, TYPE, first_letter, opened) VALUES ('陕西省', '610000', 0, 'S', b'1');
INSERT INTO `tb_provinces`(name, adn_code, TYPE, first_letter, opened) VALUES ('甘肃省', '620000', 0, 'G', b'1');
INSERT INTO `tb_provinces`(name, adn_code, TYPE, first_letter, opened) VALUES ('青海省', '630000', 0, 'Q', b'1');
INSERT INTO `tb_provinces`(name, adn_code, TYPE, first_letter, opened) VALUES ('宁夏回族自治区', '640000', 2, 'N', b'1');
INSERT INTO `tb_provinces`(name, adn_code, TYPE, first_letter, opened) VALUES ('新疆维吾尔自治区', '650000', 2, 'Q', b'1');
INSERT INTO `tb_provinces`(name, adn_code, TYPE, first_letter, opened) VALUES ('台湾省', '710000', 0, 'T', b'0');
INSERT INTO `tb_provinces`(name, adn_code, TYPE, first_letter, opened) VALUES ('香港特别行政区', '810000', 3, 'X', b'0');
INSERT INTO `tb_provinces`(name, adn_code, TYPE, first_letter, opened) VALUES ('澳门特别行政区', '820000', 3, 'A', b'0');