-- phpMyAdmin SQL Dump
-- version 2.10.2
-- http://www.phpmyadmin.net
--
-- 主机: localhost
-- 服务器版本: 5.0.45
-- PHP 版本: 5.2.3
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- 数据库: `db_dev`
--
-- --------------------------------------------------------
--
-- 表的结构 `s_city`
--
CREATE TABLE `s_city` (
`cid` int(11) NOT NULL,
`cname` varchar(20) collate utf8_unicode_ci NOT NULL,
`cpostcode` char(6) collate utf8_unicode_ci NOT NULL,
`pid` int(11) NOT NULL,
PRIMARY KEY (`cid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- 导出表中的数据 `s_city`
--
INSERT INTO `s_city` VALUES (1, '北京市', '100000', 1);
INSERT INTO `s_city` VALUES (2, '天津市', '100000', 2);
INSERT INTO `s_city` VALUES (3, '石家庄市', '050000', 3);
INSERT INTO `s_city` VALUES (4, '唐山市', '063000', 3);
INSERT INTO `s_city` VALUES (5, '秦皇岛市', '066000', 3);
INSERT INTO `s_city` VALUES (6, '邯郸市', '056000', 3);
INSERT INTO `s_city` VALUES (7, '邢台市', '054000', 3);
INSERT INTO `s_city` VALUES (8, '保定市', '071000', 3);
INSERT INTO `s_city` VALUES (9, '张家口市', '075000', 3);
INSERT INTO `s_city` VALUES (10, '承德市', '067000', 3);
INSERT INTO `s_city` VALUES (11, '沧州市', '061000', 3);
INSERT INTO `s_city` VALUES (12, '廊坊市', '065000', 3);
INSERT INTO `s_city` VALUES (13, '衡水市', '053000', 3);
INSERT INTO `s_city` VALUES (14, '太原市', '030000', 4);
INSERT INTO `s_city` VALUES (15, '大同市', '037000', 4);
INSERT INTO `s_city` VALUES (16, '阳泉市', '045000', 4);
INSERT INTO `s_city` VALUES (17, '长治市', '046000', 4);
INSERT INTO `s_city` VALUES (18, '晋城市', '048000', 4);
INSERT INTO `s_city` VALUES (19, '朔州市', '036000', 4);
INSERT INTO `s_city` VALUES (20, '晋中市', '030600', 4);
INSERT INTO `s_city` VALUES (21, '运城市', '044000', 4);
INSERT INTO `s_city` VALUES (22, '忻州市', '034000', 4);
INSERT INTO `s_city` VALUES (23, '临汾市', '041000', 4);
INSERT INTO `s_city` VALUES (24, '吕梁市', '030500', 4);
INSERT INTO `s_city` VALUES (25, '呼和浩特市', '010000', 5);
INSERT INTO `s_city` VALUES (26, '包头市', '014000', 5);
INSERT INTO `s_city` VALUES (27, '乌海市', '016000', 5);
INSERT INTO `s_city` VALUES (28, '赤峰市', '024000', 5);
INSERT INTO `s_city` VALUES (29, '通辽市', '028000', 5);
INSERT INTO `s_city` VALUES (30, '鄂尔多斯市', '010300', 5);
INSERT INTO `s_city` VALUES (31, '呼伦贝尔市', '021000', 5);
INSERT INTO `s_city` VALUES (32, '巴彦淖尔市', '014400', 5);
INSERT INTO `s_city` VALUES (33, '乌兰察布市', '011800', 5);
INSERT INTO `s_city` VALUES (34, '兴安盟', '137500', 5);
INSERT INTO `s_city` VALUES (35, '锡林郭勒盟', '011100', 5);
INSERT INTO `s_city` VALUES (36, '阿拉善盟', '016000', 5);
INSERT INTO `s_city` VALUES (37, '沈阳市', '110000', 6);
INSERT INTO `s_city` VALUES (38, '大连市', '116000', 6);
INSERT INTO `s_city` VALUES (39, '鞍山市', '114000', 6);
INSERT INTO `s_city` VALUES (40, '抚顺市', '113000', 6);
INSERT INTO `s_city` VALUES (41, '本溪市', '117000', 6);
INSERT INTO `s_city` VALUES (42, '丹东市', '118000', 6);
INSERT INTO `s_city` VALUES (43, '锦州市', '121000', 6);
INSERT INTO `s_city` VALUES (44, '营口市', '115000', 6);
INSERT INTO `s_city` VALUES (45, '阜新市', '123000', 6);
INSERT INTO `s_city` VALUES (46, '辽阳市', '111000', 6);
INSERT INTO `s_city` VALUES (47, '盘锦市', '124000', 6);
INSERT INTO `s_city` VALUES (48, '铁岭市', '112000', 6);
INSERT INTO `s_city` VALUES (49, '朝阳市', '122000', 6);
INSERT INTO `s_city` VALUES (50, '葫芦岛市', '125000', 6);
INSERT INTO `s_city` VALUES (51, '长春市', '130000', 7);
INSERT INTO `s_city` VALUES (52, '吉林市', '132000', 7);
INSERT INTO `s_city` VALUES (53, '四平市', '136000', 7);
INSERT INTO `s_city` VALUES (54, '辽源市', '136200', 7);
INSERT INTO `s_city` VALUES (55, '通化市', '134000', 7);
INSERT INTO `s_city` VALUES (56, '白山市', '134300', 7);
INSERT INTO `s_city` VALUES (57, '松原市', '131100', 7);
INSERT INTO `s_city` VALUES (58, '白城市', '137000', 7);
INSERT INTO `s_city` VALUES (59, '延边朝鲜族自治州', '133000', 7);
INSERT INTO `s_city` VALUES (60, '哈尔滨市', '150000', 8);
INSERT INTO `s_city` VALUES (61, '齐齐哈尔市', '161000', 8);
INSERT INTO `s_city` VALUES (62, '鸡西市', '158100', 8);
INSERT INTO `s_city` VALUES (63, '鹤岗市', '154100', 8);
INSERT INTO `s_city` VALUES (64, '双鸭山市', '155100', 8);
INSERT INTO `s_city` VALUES (65, '大庆市', '163000', 8);
INSERT INTO `s_city` VALUES (66, '伊春市', '152300', 8);
INSERT INTO `s_city` VALUES (67, '佳木斯市', '154000', 8);
INSERT INTO `s_city` VALUES (68, '七台河市', '154600', 8);
INSERT INTO `s_city` VALUES (69, '牡丹江市', '157000', 8);
INSERT INTO `s_city` VALUES (70, '黑河市', '164300', 8);
INSERT INTO `s_city` VALUES (71, '绥化市', '152000', 8);
INSERT INTO `s_city` VALUES (72, '大兴安岭地区', '165000', 8);
INSERT INTO `s_city` VALUES (73, '上海市', '200000', 9);
INSERT INTO `s_city` VALUES (74, '南京市', '210000', 10);
INSERT INTO `s_city` VALUES (75, '无锡市', '214000', 10);
INSERT INTO `s_city` VALUES (76, '徐州市', '221000', 10);
INSERT INTO `s_city` VALUES (77, '常州市', '213000', 10);
INSERT INTO `s_city` VALUES (78, '苏州市', '215000', 10);
INSERT INTO `s_city` VALUES (79, '南通市', '226000', 10);
INSERT INTO `s_city` VALUES (80, '连云港市', '222000', 10);
INSERT INTO `s_city` VALUES (81, '淮安市', '223200', 10);
INSERT INTO `s_city` VALUES (82, '盐城市', '224000', 10);
INSERT INTO `s_city` VALUES (83, '扬州市', '225000', 10);
INSERT INTO `s_city` VALUES (84, '镇江市', '212000', 10);
INSERT INTO `s_city` VALUES (85, '泰州市', '225300', 10);
INSERT INTO `s_city` VALUES (86, '宿迁市', '223800', 10);
INSERT INTO `s_city` VALUES (87, '杭州市', '310000', 11);
INSERT INTO `s_city` VALUES (88, '宁波市', '315000', 11);
INSERT INTO `s_city` VALUES (89, '温州市', '325000', 11);
INSERT INTO `s_city` VALUES (90, '嘉兴市', '314000', 11);
INSERT INTO `s_city` VALUES (91, '湖州市', '313000', 11);
INSERT INTO `s_city` VALUES (92, '绍兴市', '312000', 11);
INSERT INTO `s_city` VALUES (93, '金华市', '321000', 11);
INSERT INTO `s_city` VALUES (94, '衢州市', '324000', 11);
INSERT INTO `s_city` VALUES (95, '舟山市', '316000', 11);
INSERT INTO `s_city` VALUES (96, '台州市', '318000', 11);
INSERT INTO `s_city` VALUES (97, '丽水市', '323000', 11);
INSERT INTO `s_city` VALUES (98, '合肥市', '230000', 12);
INSERT INTO `s_city` VALUES (99, '芜湖市', '241000', 12);
INSERT INTO `s_city` VALUES (100, '蚌埠市', '233000', 12);
INSERT INTO `s_city` VALUES (101, '淮南市', '232000', 12);
INSERT INTO `s_city` VALUES (102, '马鞍山市', '243000', 12);
INSERT INTO `s_city` VALUES (103, '淮北市', '235000', 12);
INSERT INTO `s_city` VALUES (104, '铜陵市', '244000', 12);
INSERT INTO `s_city` VALUES (105, '安庆市', '246000', 12);
INSERT INTO `s_city` VALUES (106, '黄山市', '242700', 12);
INSERT INTO `s_city` VALUES (107, '滁州市', '239000', 12);
INSERT INTO `s_city` VALUES (108, '阜阳市', '236100', 12);
INSERT INTO `s_city` VALUES (109, '宿州市', '234100', 12);
INSERT INTO `s_city` VALUES (110, '巢湖市', '238000', 12);
INSERT INTO `s_city` VALUES (111, '六安市', '237000', 12);
INSERT INTO `s_city` VALUES (112, '亳州市', '236800', 12);
INSERT INTO `s_city` VALUES (113, '池州市', '247100', 12);
INSERT INTO `s_city` VALUES (114, '宣城市', '366000', 12);
INSERT INTO `s_city` VALUES (115, '福州市', '350000', 13);
INSERT INTO `s_city` VALUES (116, '厦门市', '361000', 13);
INSERT INTO `s_city` VALUES (117, '莆田市', '351100', 13);
INSERT INTO `s_city` VALUES (118, '三明市', '365000', 13);
INSERT INTO `s_city` VALUES (119, '泉州市', '362000', 13);
INSERT INTO `s_city` VALUES (120, '漳州市', '363000', 13);
INSERT INTO `s_city` VALUES (121, '南平市', '353000', 13);
INSERT INTO `s_city` VALUES (122, '龙岩市', '364000', 13);
INSERT INTO `s_city` VALUES (123, '宁德市', '352100', 13);
INSERT INTO `s_city` VALUES (124, '南昌市', '330000', 14);
INSERT INTO `s_city` VALUES (125, '景�