/*
MySQL Data Transfer
Source Host: localhost
Source Database: test
Target Host: localhost
Target Database: test
Date: 2011-08-20 11:25:39
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for area
-- ----------------------------
CREATE TABLE `area` (
`code` varchar(100) NOT NULL,
`name` varchar(300) default NULL,
`path` varchar(300) default NULL,
`level` int(2) default NULL,
PRIMARY KEY (`code`),
KEY `idx01` (`level`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records
-- ----------------------------
INSERT INTO `area` VALUES ('11', '北京', '11.html', '1');
INSERT INTO `area` VALUES ('12', '天津', '12.html', '1');
INSERT INTO `area` VALUES ('13', '河北', '13.html', '1');
INSERT INTO `area` VALUES ('14', '山西', '14.html', '1');
INSERT INTO `area` VALUES ('15', '内蒙古', '15.html', '1');
INSERT INTO `area` VALUES ('21', '辽宁', '21.html', '1');
INSERT INTO `area` VALUES ('22', '吉林', '22.html', '1');
INSERT INTO `area` VALUES ('23', '黑龙江', '23.html', '1');
INSERT INTO `area` VALUES ('31', '上海', '31.html', '1');
INSERT INTO `area` VALUES ('32', '江苏', '32.html', '1');
INSERT INTO `area` VALUES ('33', '浙江', '33.html', '1');
INSERT INTO `area` VALUES ('34', '安徽', '34.html', '1');
INSERT INTO `area` VALUES ('35', '福建', '35.html', '1');
INSERT INTO `area` VALUES ('36', '江西', '36.html', '1');
INSERT INTO `area` VALUES ('37', '山东', '37.html', '1');
INSERT INTO `area` VALUES ('41', '河南', '41.html', '1');
INSERT INTO `area` VALUES ('42', '湖北', '42.html', '1');
INSERT INTO `area` VALUES ('43', '湖南', '43.html', '1');
INSERT INTO `area` VALUES ('44', '广东', '44.html', '1');
INSERT INTO `area` VALUES ('45', '广西', '45.html', '1');
INSERT INTO `area` VALUES ('46', '海南', '46.html', '1');
INSERT INTO `area` VALUES ('50', '重庆', '50.html', '1');
INSERT INTO `area` VALUES ('51', '四川', '51.html', '1');
INSERT INTO `area` VALUES ('52', '贵州', '52.html', '1');
INSERT INTO `area` VALUES ('53', '云南', '53.html', '1');
INSERT INTO `area` VALUES ('54', '西藏', '54.html', '1');
INSERT INTO `area` VALUES ('61', '陕西', '61.html', '1');
INSERT INTO `area` VALUES ('62', '甘肃', '62.html', '1');
INSERT INTO `area` VALUES ('63', '青海', '63.html', '1');
INSERT INTO `area` VALUES ('64', '宁夏', '64.html', '1');
INSERT INTO `area` VALUES ('65', '新疆', '65.html', '1');
INSERT INTO `area` VALUES ('110100000000', '市辖区', '11/1101.html', '2');
INSERT INTO `area` VALUES ('110101000000', '东城区', '01/110101.html', '3');
INSERT INTO `area` VALUES ('110101001000', '东华门街道办事处', '01/110101001.html', '4');
INSERT INTO `area` VALUES ('110101001001', '多福巷社区居委会', '', '5');
INSERT INTO `area` VALUES ('110101001002', '银闸社区居委会', '', '5');
INSERT INTO `area` VALUES ('110101001005', '东厂社区居委会', '', '5');
INSERT INTO `area` VALUES ('110101001006', '智德社区居委会', '', '5');
INSERT INTO `area` VALUES ('110101001007', '南池子社区居委会', '', '5');
INSERT INTO `area` VALUES ('110101001008', '黄图岗社区居委会', '', '5');
INSERT INTO `area` VALUES ('110101001009', '灯市口社区居委会', '', '5');
INSERT INTO `area` VALUES ('110101001010', '正义路社区居委会', '', '5');
INSERT INTO `area` VALUES ('110101001011', '甘雨社区居委会', '', '5');
INSERT INTO `area` VALUES ('110101001013', '台基厂社区居委会', '', '5');
INSERT INTO `area` VALUES ('110101001014', '韶九社区居委会', '', '5');
INSERT INTO `area` VALUES ('110101001015', '王府井社区居委会', '', '5');
INSERT INTO `area` VALUES ('110101002000', '景山街道办事处', '01/110101002.html', '4');
INSERT INTO `area` VALUES ('110101002001', '隆福寺社区居委会', '', '5');
INSERT INTO `area` VALUES ('110101002002', '吉祥社区居委会', '', '5');
INSERT INTO `area` VALUES ('110101002003', '黄化门社区居委会', '', '5');
INSERT INTO `area` VALUES ('110101002004', '钟鼓社区居委会', '', '5');
INSERT INTO `area` VALUES ('110101002005', '魏家社区居委会', '', '5');
INSERT INTO `area` VALUES ('110101002006', '汪芝麻社区居委会', '', '5');
INSERT INTO `area` VALUES ('110101002008', '景山东街社区居委会', '', '5');
INSERT INTO `area` VALUES ('110101002009', '皇城根北街社区居委会', '', '5');
INSERT INTO `area` VALUES ('110101003000', '交道口街道办事处', '01/110101003.html', '4');
INSERT INTO `area` VALUES ('110101003001', '交东社区居委会', '', '5');
INSERT INTO `area` VALUES ('110101003002', '福祥社区居委会', '', '5');
INSERT INTO `area` VALUES ('110101003003', '大兴社区居委会', '', '5');
INSERT INTO `area` VALUES ('110101003005', '府学社区居委会', '', '5');
INSERT INTO `area` VALUES ('110101003007', '鼓楼苑社区居委会', '', '5');
INSERT INTO `area` VALUES ('110101003008', '菊儿社区居委会', '', '5');
INSERT INTO `area` VALUES ('110101003009', '南锣鼓巷社区居委会', '', '5');
INSERT INTO `area` VALUES ('110101004000', '安定门街道办事处', '01/110101004.html', '4');
INSERT INTO `area` VALUES ('110101004001', '交北头条社区居委会', '', '5');
INSERT INTO `area` VALUES ('110101004002', '北锣鼓巷社区居委会', '', '5');
INSERT INTO `area` VALUES ('110101004003', '国子监社区居委会', '', '5');
INSERT INTO `area` VALUES ('110101004004', '钟楼湾社区居委会', '', '5');
INSERT INTO `area` VALUES ('110101004005', '宝钞南社区居委会', '', '5');
INSERT INTO `area` VALUES ('110101004006', '五道营社区居委会', '', '5');
INSERT INTO `area` VALUES ('110101004009', '分司厅社区居委会', '', '5');
INSERT INTO `area` VALUES ('110101004011', '国旺社区居委会', '', '5');
INSERT INTO `area` VALUES ('110101004012', '花园社区居委会', '', '5');
INSERT INTO `area` VALUES ('110101005000', '北新桥街道办事处', '01/110101005.html', '4');
INSERT INTO `area` VALUES ('110101005001', '海运仓社区居委会', '', '5');
INSERT INTO `area` VALUES ('110101005002', '北新仓社区居委会', '', '5');
INSERT INTO `area` VALUES ('110101005003', '十二条社区居委会', '', '5');
INSERT INTO `area` VALUES ('110101005004', '门楼社区居委会', '', '5');
INSERT INTO `area` VALUES ('110101005005', '十三条社区居委会', '', '5');
INSERT INTO `area` VALUES ('110101005006', '民安社区居委会', '', '5');
INSERT INTO `area` VALUES ('110101005007', '板桥社区居委会', '', '5');
INSERT INTO `area` VALUES ('110101005008', '九道湾社区居委会', '', '5');
INSERT INTO `area` VALUES ('110101005009', '北官厅社区居委会', '', '5');
INSERT INTO `area` VALUES ('110101005010', '青龙社区居委会', '', '5');
INSERT INTO `area` VALUES ('110101005011', '小菊社区居委会', '', '5');
INSERT INTO `area` VALUES ('110101005012', '藏经馆社区居委会', '', '5');
INSERT INTO `area` VALUES ('110101005013', '炮局社区居委会', '', '5');
INSERT INTO `area` VALUES ('110101005014', '草园社区居委会', '', '5');
INSERT INTO `area` VALUES ('110101005015', '二条社区居委会', '', '5');
INSERT INTO `area` VALUES ('110101005016', '前永康社区居委会', '', '5');
INSERT INTO `area` VALUES ('110101006000', '东四街道办事处', '01/110101006.html', '4');
INSERT INTO `area` VALUES ('110101006001', '南门仓社区居委会', '', '5');
INSERT INTO `area` VALUES ('110101006002', '七条社区居委会', '', '5');
INSERT INTO `area` VALUES ('110101006003', '二条社区居委会', '', '5');
INSERT INTO `area` VALUES ('110101006005', '五条社区居委会', '', '5');
INSERT INTO `area` VALUES ('110101006006', '六条社区居委会', '', '5');
INSERT INTO `area` VALUES ('110101006007', '豆瓣社区居委会', '', '5');
INSERT INTO `area` VALUES ('110101006008', '八条社区居委会'