area.sql

phpcms2007很好的cms内容管理系统,操作方便

INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (1, '北京市', '东城区', '', '100000', '010');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (2, '北京市', '西城区', '', '100000', '010');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (3, '北京市', '崇文区', '', '100000', '010');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (4, '北京市', '宣武区', '', '100000', '010');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (5, '北京市', '朝阳区', '', '100000', '010');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (6, '北京市', '丰台区', '', '100000', '010');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (7, '北京市', '石景山区', '', '100000', '010');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (8, '北京市', '海淀区', '', '100000', '010');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (9, '北京市', '门头沟区', '', '102300', '010');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (10, '北京市', '房山区', '', '102400', '010');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (11, '北京市', '通州区', '', '101100', '010');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (12, '北京市', '顺义区', '', '101300', '010');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (13, '北京市', '昌平区', '', '102200', '010');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (14, '北京市', '大兴区', '', '102600', '010');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (15, '北京市', '怀柔区', '', '101400', '010');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (16, '北京市', '平谷区', '', '101200', '010');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (17, '北京市', '密云县', '', '101500', '010');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (18, '北京市', '延庆县', '', '102100', '010');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (19, '上海市', '黄浦区', '', '200000', '021');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (20, '上海市', '卢湾区', '', '200000', '021');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (21, '上海市', '徐汇区', '', '200000', '021');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (22, '上海市', '长宁区', '', '200000', '021');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (23, '上海市', '静安区', '', '200000', '021');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (24, '上海市', '普陀区', '', '200000', '021');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (25, '上海市', '闸北区', '', '200000', '021');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (26, '上海市', '虹口区', '', '200000', '021');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (27, '上海市', '杨浦区', '', '200000', '021');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (28, '上海市', '闵行区', '', '201100', '021');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (29, '上海市', '宝山区', '', '201900', '021');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (30, '上海市', '嘉定区', '', '201800', '021');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (31, '上海市', '浦东新区', '', '201200', '021');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (32, '上海市', '金山区', '', '201500', '021');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (33, '上海市', '松江区', '', '201600', '021');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (34, '上海市', '青浦区', '', '201700', '021');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (35, '上海市', '南汇区', '', '201300', '021');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (36, '上海市', '奉贤区', '', '201400', '021');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (37, '上海市', '崇明县', '', '202150', '021');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (38, '天津市', '和平区', '', '300000', '022');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (39, '天津市', '河东区', '', '300000', '022');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (40, '天津市', '河西区', '', '300000', '022');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (41, '天津市', '南开区', '', '300000', '022');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (42, '天津市', '河北区', '', '300000', '022');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (43, '天津市', '红桥区', '', '300000', '022');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (44, '天津市', '塘沽区', '', '300450', '022');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (45, '天津市', '汉沽区', '', '300480', '022');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (46, '天津市', '大港区', '', '300200', '022');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (47, '天津市', '东丽区', '', '300000', '022');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (48, '天津市', '西青区', '', '300000', '022');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (49, '天津市', '津南区', '', '300000', '022');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (50, '天津市', '北辰区', '', '300000', '022');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (51, '天津市', '武清区', '', '301700', '022');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (52, '天津市', '宝坻区', '', '301800', '022');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (53, '天津市', '宁河县', '', '301500', '022');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (54, '天津市', '静海县', '', '301600', '022');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (55, '天津市', '蓟县', '', '301900', '022');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (56, '重庆市', '万州区', '', '404000', '023');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (57, '重庆市', '涪陵区', '', '408000', '023');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (58, '重庆市', '渝中区', '', '400010', '023');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (59, '重庆市', '大渡口区', '', '400080', '023');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (60, '重庆市', '江北区', '', '400020', '023');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (61, '重庆市', '沙坪坝区', '', '400030', '023');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (62, '重庆市', '九龙坡区', '', '400050', '023');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (63, '重庆市', '南岸区', '', '400060', '023');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (64, '重庆市', '北碚区', '', '400700', '023');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (65, '重庆市', '万盛区', '', '400800', '023');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (66, '重庆市', '双桥区', '', '400900', '023');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (67, '重庆市', '渝北区', '', '401100', '023');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (68, '重庆市', '巴南区', '', '401300', '023');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (69, '重庆市', '黔江区', '', '409000', '023');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (70, '重庆市', '长寿区', '', '401200', '023');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (71, '重庆市', '綦江县', '', '401400', '023');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (72, '重庆市', '潼南县', '', '402600', '023');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (73, '重庆市', '铜梁县', '', '402500', '023');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (74, '重庆市', '大足县', '', '402300', '023');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (75, '重庆市', '荣昌县', '', '402400', '023');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (76, '重庆市', '璧山县', '', '402700', '023');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (77, '重庆市', '梁平县', '', '405200', '023');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (78, '重庆市', '城口县', '', '405900', '023');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (79, '重庆市', '丰都县', '', '408200', '023');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (80, '重庆市', '垫江县', '', '408300', '023');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (81, '重庆市', '武隆县', '', '408500', '023');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (82, '重庆市', '忠县', '', '404300', '023');
INSERT INTO `phpcms_city` (`cityid`, `province`, `city`, `area`, `postcode`, `areacode`) VALUES (83, '重庆市', '开县', '', '405400', '023');