xiaoming
/*
Name: tangchao
Date: 2017-05-03 14:06:22
*/
SET FOREIGN_KEY_CHECKS=0;
-- ---------------------------
-- Table structure for `zbp_province`
-- ----------------------------
DROP TABLE IF EXISTS `zbp_province`;CREATE TABLE `zbp_province` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`provinceID` varchar(6) DEFAULT NULL,
`province` varchar(40) DEFAULT NULL,
`name` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=35 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of zbp_province
-- ----------------------------
INSERT INTO `zbp_province` VALUES (1, 110000, 北京市, beijing);
INSERT INTO `zbp_province` VALUES (2, 120000, 天津市, tianjin);
INSERT INTO `zbp_province` VALUES (3, 130000, 河北省, hebei);
INSERT INTO `zbp_province` VALUES (4, 140000, 山西省, shanxi);
INSERT INTO `zbp_province` VALUES (5, 150000, 内蒙古自治区, neimenggu);
INSERT INTO `zbp_province` VALUES (6, 210000, 辽宁省, liaoning);
INSERT INTO `zbp_province` VALUES (7, 220000, 吉林省, jilin);
INSERT INTO `zbp_province` VALUES (8, 230000, 黑龙江省, heilongjiang);
INSERT INTO `zbp_province` VALUES (9, 310000, 上海市, shanghai);
INSERT INTO `zbp_province` VALUES (10, 320000, 江苏省, jiangsu);
INSERT INTO `zbp_province` VALUES (11, 330000, 浙江省, zhejiang);
INSERT INTO `zbp_province` VALUES (12, 340000, 安徽省, anhui);
INSERT INTO `zbp_province` VALUES (13, 350000, 福建省, fujian);
INSERT INTO `zbp_province` VALUES (14, 360000, 江西省, jiangxi);
INSERT INTO `zbp_province` VALUES (15, 370000, 山东省, shandong);
INSERT INTO `zbp_province` VALUES (16, 410000, 河南省, henan);
INSERT INTO `zbp_province` VALUES (17, 420000, 湖北省, hubei);
INSERT INTO `zbp_province` VALUES (18, 430000, 湖南省, hunan);
INSERT INTO `zbp_province` VALUES (19, 440000, 广东省, guangdong);
INSERT INTO `zbp_province` VALUES (20, 450000, 广西壮族自治区, guangxi);
INSERT INTO `zbp_province` VALUES (21, 460000, 海南省, hainan);
INSERT INTO `zbp_province` VALUES (22, 500000, 重庆市, zhongqing);
INSERT INTO `zbp_province` VALUES (23, 510000, 四川省, sichuan);
INSERT INTO `zbp_province` VALUES (24, 520000, 贵州省, guizhou);
INSERT INTO `zbp_province` VALUES (25, 530000, 云南省, yunnan);
INSERT INTO `zbp_province` VALUES (26, 540000, 西藏自治区, xicang);
INSERT INTO `zbp_province` VALUES (27, 610000, 陕西省, shanxi);
INSERT INTO `zbp_province` VALUES (28, 620000, 甘肃省, gansu);
INSERT INTO `zbp_province` VALUES (29, 630000, 青海省, qinghai);
INSERT INTO `zbp_province` VALUES (30, 640000, 宁夏回族自治区, ningxia);
INSERT INTO `zbp_province` VALUES (31, 650000, 新疆维吾尔自治区, xinjiang);
INSERT INTO `zbp_province` VALUES (32, 710000, 台湾省, taiwan);
INSERT INTO `zbp_province` VALUES (33, 810000, 香港特别行政区, xianggang);
INSERT INTO `zbp_province` VALUES (34, 820000, 澳门特别行政区, aomen);
