SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for CITY_AREA
-- ----------------------------
DROP TABLE IF EXISTS `CITY_AREA`;
CREATE TABLE `CITY_AREA` (
`id` int(10) unsigned NOT NULL COMMENT 'ID',
`name` varchar(50) NOT NULL DEFAULT '' COMMENT '地区名',
`pid` int(10) NOT NULL COMMENT '父ID',
`zipcode` varchar(10) DEFAULT NULL COMMENT '邮编',
`sort` tinyint(3) unsigned DEFAULT '50' COMMENT '排序',
PRIMARY KEY (`id`),
KEY `pid` (`pid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of CITY_AREA
-- ----------------------------
INSERT INTO `CITY_AREA` VALUES ('2', '阿富汗', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('3', '奥兰群岛', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('4', '阿拉斯加', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('5', '阿尔巴尼亚', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('6', '阿尔及利亚', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('7', '东萨摩亚(美)', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('8', '安道尔', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('9', '安哥拉', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('10', '安圭拉岛(英)', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('11', '南极', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('12', '安提瓜和巴布达', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('13', '阿根廷', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('14', '亚美尼亚', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('15', '阿鲁巴岛', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('16', '澳大利亚', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('17', '奥地利', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('18', '阿塞拜疆', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('19', '巴林', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('20', '根西岛(英)', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('21', '孟加拉国', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('22', '巴巴多斯', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('23', '白俄罗斯', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('24', '比利时', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('25', '伯利兹', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('26', '贝宁', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('27', '百慕大群岛(英)', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('28', '不丹', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('29', '玻利维亚', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('30', '波斯尼亚和黑塞哥维那', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('31', '博茨瓦纳', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('32', '巴西', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('33', '保加利亚', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('34', '布基纳法索', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('35', '布隆迪', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('36', '喀麦隆', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('37', '加拿大', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('38', '加那利群岛', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('39', '佛得角', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('40', '开曼群岛(英)', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('41', '中非', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('42', '乍得', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('43', '智利', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('44', '圣诞岛', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('45', '科科斯岛', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('46', '哥伦比亚', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('47', '科摩罗', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('48', '刚果', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('49', '科克群岛(新)', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('50', '哥斯达黎加', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('51', '克罗地亚', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('52', '古巴', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('53', '塞浦路斯', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('54', '捷克', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('55', '刚果(金)', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('56', '丹麦', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('57', '迪戈加西亚岛', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('58', '吉布提', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('59', '多米尼克国', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('60', '多米尼加共和国', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('61', '厄瓜多尔', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('62', '埃及', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('63', '萨尔瓦多', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('64', '赤道几内亚', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('65', '厄立特里亚', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('66', '爱沙尼亚', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('67', '埃塞俄比亚', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('68', '福克兰群岛', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('69', '法罗群岛(丹)', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('70', '斐济', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('71', '芬兰', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('72', '法国', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('73', '法属波里尼西亚', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('74', '加蓬', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('75', '冈比亚', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('76', '格鲁吉亚', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('77', '德国', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('78', '加纳', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('79', '直布罗陀(英)', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('80', '希腊', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('81', '格陵兰岛', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('82', '格林纳达', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('83', '瓜德罗普岛(法)', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('84', '关岛(美)', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('85', '危地马拉', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('86', '几内亚', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('87', '几内亚比绍', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('88', '法属圭亚那', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('89', '圭亚那', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('90', '海地', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('91', '洪都拉斯', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('92', '匈牙利', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('93', '冰岛', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('94', '印度', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('95', '印度尼西亚', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('96', '伊郎', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('97', '伊拉克', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('98', '爱尔兰', '990000', '', '50');
INSERT INTO `CITY_AREA` VALUES ('99', '马恩岛(�
