 (340, 'patient1', 0, '13566666666', 20, 'patient1-13566666666', 666666, '1491979941', NULL, NULL, NULL, 1, 0, NULL, NULL, NULL, NULL, '温州', '苟...'),
 (341, 'patient1', 0, '13566666666', 20, 'patient1-13566666666', 666666, '1491979941', NULL, NULL, NULL, 1, 0, NULL, NULL, NULL, NULL, '温州', '苟...'),
 (342, 'patient1', 0, '13566666666', 20, 'patient1-13566666666', 666666, '1491979941', NULL, NULL, NULL, 1, 0, NULL, NULL, NULL, NULL, '温州', '苟...'),
-(343, 'patient1', 0, '13566666666', 20, 'patient1-13566666666', 666666, '1491979941', NULL, NULL, NULL, 1, 0, NULL, NULL, NULL, NULL, '温州', '苟...');
-INSERT INTO `patient` (`id`, `name`, `sex`, `tel`, `age`, `wechat`, `qq`, `add_time`, `order_time`, `reach_time`, `disease_id`, `author_id`, `state`, `mediaFrom_id`, `doctor_id`, `advisory_way`, `advisory_content`, `area`, `remarks`) VALUES
+(343, 'patient1', 0, '13566666666', 20, 'patient1-13566666666', 666666, '1491979941', NULL, NULL, NULL, 1, 0, NULL, NULL, NULL, NULL, '温州', '苟...'),
 (344, 'patient1', 0, '13566666666', 20, 'patient1-13566666666', 666666, '1491979941', NULL, NULL, NULL, 1, 0, NULL, NULL, NULL, NULL, '温州', '苟...'),
 (345, 'patient1', 0, '13566666666', 20, 'patient1-13566666666', 666666, '1491979941', NULL, NULL, NULL, 1, 0, NULL, NULL, NULL, NULL, '温州', '苟...'),
 (346, 'patient1', 0, '13566666666', 20, 'patient1-13566666666', 666666, '1491979941', NULL, NULL, NULL, 1, 0, NULL, NULL, NULL, NULL, '温州', '苟...'),

-- 表的结构 `permission`
--

CREATE TABLE IF NOT EXISTS `permission` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '权限名称',
  `des` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '权限说明',
  `level` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '权限的层级关系',
  PRIMARY KEY (`id`),
  UNIQUE KEY `permission_name_uindex` (`name`),
  UNIQUE KEY `permission_level_uindex` (`level`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='权限表' AUTO_INCREMENT=60 ;

--
-- 转存表中的数据 `permission`
--

INSERT INTO `permission` (`id`, `name`, title, `level`) VALUES
(1, 'index', '系统后台', '1'),
(2, 'index/home', '控制台', '1-1'),
(3, 'index/rank', '排行', '1-2'),
(4, 'patient', '客户信息查看编辑操作', '2'),
(5, 'patient_edit_info', '允许编辑客户信息', '2-1'),
(6, 'patient_edit_name', '允许修改客户姓名', '2-1-1'),
(7, 'patient_edit_sex', '允许修改客户性别', '2-1-2'),
(8, 'patient_edit_tel', '允许修改客户电话', '2-1-3'),
(9, 'patient_edit_age', '允许修改客户年龄', '2-1-4'),
(10, 'patient_edit_wechat', '允许修改客户微信', '2-1-5'),
(11, 'patient_edit_qq', '允许修改客户QQ', '2-1-6'),
(12, 'patient_edit_order_time', '允许修改客户预约时间', '2-1-7'),
(13, 'patient_edit_reach_time', '允许修改客户到诊时间', '2-1-8'),
(14, 'patient_edit_disease', '允许修改客户预约病种', '2-1-9'),
(15, 'patient_edit_media', '允许修改客户渠道来源', '2-1-10'),
(16, 'patient_edit_doctor', '允许修改客户预约医生', '2-1-11'),
(17, 'patient_edit_advisory_way', '允许修改客户咨询方式', '2-1-12'),
(18, 'patient_edit_advisory_content', '允许修改客户咨询内容', '2-1-13'),
(19, 'patient_edit_area', '允许修改客户所在地址', '2-1-14'),
(20, 'patient_edit_remark', '允许修改客户预约备注', '2-1-15'),
(21, 'patient_edit_oth', '允许编辑TA人登记信息', '2-2'),
(22, 'patient_add_info', '允许新增客户信息', '2-3'),
(23, 'patient_show_info', '允许查看客户信息', '2-4'),
(24, 'patient_show_oth', '允许查看TA人登记信息', '2-4-1'),
(25, 'patient_show_tell', '允许查看客户完整电话', '2-4-2'),
(26, 'patient_huif_info', '允许回访客户', '2-5'),
(27, 'patient_huif_oth', '允许回访TA人客户', '2-6'),
(28, 'patient_check_info', '允许确认状态', '2-7'),
(29, 'patient_check_doc', '允许设置客户接诊医生', '2-8'),
(30, 'info', '信息管理', '3'),
(31, 'info_doctor', '医生管理', '3-1'),
(32, 'add_info_doctor', '新增医生', '3-1-1'),
(33, 'rm_info_doctor', '删除医生', '3-1-2'),
(34, 'edit_info_doctor', '编辑医生详情', '3-1-3'),
(35, 'info_disease', '病种科室管理', '3-2'),
(36, 'add_info_disease', '新增病种科室', '3-2-1'),
(37, 'rm_info_disease', '删除病种科室', '3-2-2'),
(38, 'edit_info_disease', '编辑病种科室', '3-2-3'),
(39, 'info_media', '来源渠道管理', '3-3'),
(40, 'add_info_media', '新增来源渠道', '3-3-1'),
(41, 'rm_info_media', '删除来源渠道', '3-3-2'),
(42, 'edit_info_media', '编辑来源渠道', '3-3-3'),
(43, 'info_advisory', '咨询方式管理', '3-4'),
(44, 'add_info_advisory', '新增咨询方式', '3-4-1'),
(45, 'rm_info_advisory', '删除咨询方式', '3-4-2'),
(46, 'edit_info_advisory', '编辑咨询方式', '3-4-3'),
(47, 'data', '数据中心', '4'),
(48, 'group_data', '分组数据', '4-1'),
(49, 'group_data_mid', '客服数据', '4-1-1'),
(50, 'group_data_disease', '病种数据', '4-1-2'),
(51, 'group_data_media', '渠道数据', '4-1-3'),
(52, 't_report_data', '绩效数据(文本)', '4-2'),
(53, 't_report_data_mid', '客服数据', '4-2-1'),
(54, 't_report_data_disease', '病种数据', '4-2-2'),
(55, 't_report_data_media', '渠道数据', '4-2-3'),
(56, 'c_report_data', '绩效数据(图形)', '4-3'),
(57, 'c_report_data_mid', '客服数据', '4-3-1'),
(58, 'c_report_data_disease', '病种数据', '4-3-2'),
(59, 'c_report_data_media', '渠道数据', '4-3-3');

-- --------------------------------------------------------


(665, 'patient1', 0, '13566666666', 20, 'patient1-13566666666', 666666, '1491979941', NULL, NULL, NULL, 1, 0, NULL, NULL, NULL, NULL, '温州', '苟...'),
(666, 'patient1', 0, '13566666666', 20, 'patient1-13566666666', 666666, '1491979941', NULL, NULL, NULL, 1, 0, NULL, NULL, NULL, NULL, '温州', '苟...'),
(667, 'patient1', 0, '13566666666', 20, 'patient1-13566666666', 666666, '1491979941', NULL, NULL, NULL, 1, 0, NULL, NULL, NULL, NULL, '温州', '苟...'),
(668, 'patient1', 0, '13566666666', 20, 'patient1-13566666666', 666666, '1491979941', NULL, NULL, NULL, 1, 0, NULL, NULL, NULL, NULL, '温州', '苟...'),
(669, 'patient1', 0, '13566666666', 20, 'patient1-13566666666', 666666, '1491979941', NULL, NULL, NULL, 1, 0, NULL, NULL, NULL, NULL, '温州', '苟...'),
(670, 'patient1', 0, '13566666666', 20, 'patient1-13566666666', 666666, '1491979941', NULL, NULL, NULL, 1, 0, NULL, NULL, NULL, NULL, '温州', '苟...'),
(671, 'patient1', 0, '13566666666', 20, 'patient1-13566666666', 666666, '1491979941', NULL, NULL, NULL, 1, 0, NULL, NULL, NULL, NULL, '温州', '苟...'),
