SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `t_news`
-- ----------------------------
DROP TABLE IF EXISTS `t_news`;
CREATE TABLE `t_news` (
  `id` varchar(32) COLLATE utf8_bin NOT NULL,
  `address` varchar(200) COLLATE utf8_bin DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `description` varchar(200) COLLATE utf8_bin DEFAULT NULL,
  `news_time` datetime DEFAULT NULL,
  `title` varchar(200) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
--  Records of `t_news`
-- ----------------------------
BEGIN;
INSERT INTO `t_news` VALUES ('31c673070cfa480e9a89bb7d389767c5', 'AA', '2017-07-10 12:52:54', 'AA', '2017-07-10 12:56:43', 'AA'), ('6c0517e1ec0c4831ab93a6c967aacbec', 'CC', '2017-07-10 13:07:28', 'CC', '2017-07-10 13:09:13', 'CC'), ('8714509c7bfb4e2b9a944d3c82b0d001', 'DD', '2017-07-10 12:58:57', 'DD', '2017-07-10 13:09:16', 'DD'), ('f40d6da72fa448ada5d7b9d17e19c582', 'BB', '2017-07-10 12:52:13', 'BB', '2017-07-10 12:56:46', 'BB');
COMMIT;

-- ----------------------------
--  Table structure for `t_sys_permission`
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_permission`;
CREATE TABLE `t_sys_permission` (
  `id` varchar(32) NOT NULL COMMENT '主键',
  `name` varchar(255) DEFAULT NULL COMMENT '菜单名',
  `css_class` varchar(255) DEFAULT NULL COMMENT '菜单样式图标名',
  `url` varchar(255) DEFAULT NULL COMMENT '菜单相对URL',
  `skey` varchar(255) DEFAULT NULL COMMENT '菜单KEY',
  `parent_key` varchar(255) DEFAULT NULL COMMENT '父菜单KEY',
  `hide` int(11) DEFAULT NULL COMMENT '是否显示：1=有效，0=无效',
  `lev` int(11) DEFAULT NULL COMMENT '菜单级别，最多只能有3级',
  `sort` int(11) DEFAULT NULL COMMENT '菜单排序',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
--  Records of `t_sys_permission`
-- ----------------------------
BEGIN;
INSERT INTO `t_sys_permission` VALUES ('2017100200000000001', '管理首页', 'fa-home', 'index', 'glsy', null, '1', '1', '1'), ('2017100200000000002', '站内新闻', 'fa-sitemap', null, 'znxy', null, '1', '1', '10'), ('2017100200000000003', '新闻发布', '', 'news/add', 'znxy_xwfb', 'znxy', '1', '2', '11'), ('2017100200000000004', '新闻列表', '', 'news/list', 'znxy_xwlb', 'znxy', '1', '2', '12'), ('2017100200000000008', '系统配置', 'fa-gear', 'view/sysconfig/setconfig', 'xtpz', null, '1', '1', '20'), ('2017100200000000009', '电商管理', 'fa-desktop', 'view/tenant/tenant-list', 'dxgl', null, '1', '1', '30'), ('2017100200000000010', '电商配置', 'fa-gears', 'view/tenantConfig/list', 'dspz', null, '1', '1', '40'), ('2017100200000000011', '地区城市管理', 'fa-map-marker', null, 'dccsgl', null, '1', '1', '50'), ('2017100200000000012', '添加城市', null, 'view/city/add2', 'dccsgl_tjcs', 'dccsgl', '1', '2', '51'), ('2017100200000000013', '城市列表', null, 'view/city/list', 'dccsgl_cslb', 'dccsgl', '1', '2', '51'), ('2017100200000000014', '账号管理', 'fa-user', 'view/user/user_list', 'chgl', null, '1', '1', '60'), ('2017100200000000015', '楼盘管理', 'fa-building', 'view/project/list', 'lpgl', null, '1', '1', '70'), ('2017100200000000016', '开通楼盘', 'fa-plus', 'view/project/openProject', 'lpgl_ktlp', 'lpgl', '1', '2', '71'), ('2017100200000000017', '楼盘审核', 'fa-pencil', 'view/project/list', 'lpgl_lpsh', 'lpgl', '1', '2', '72'), ('2017100200000000018', '楼盘管理', 'fa-building', 'view/project/manager_list', 'lpgl_lpgl', 'lpgl', '1', '2', '73'), ('2017100200000000019', '合作楼盘', 'fa-slideshare', 'view/project/edit_list', 'lpgl_hzlp', 'lpgl', '1', '2', '74'), ('2017100200000000020', '添加楼盘', 'fa-plus', 'view/project/add', 'lpgl_tjlp', 'lpgl', '1', '2', '75'), ('2017100200000000021', '基本信息', 'fa-file-text-o', 'view/project/add', 'lpgl_tjlp_jbxx', 'lpgl_tjlp', '1', '3', '76'), ('2017100200000000022', '户型管理', 'fa-puzzle-piece', 'view/project/add2', 'lpgl_tjlp_hxgl', 'lpgl_tjlp', '1', '3', '77'), ('2017100200000000023', '楼盘相册', 'fa-picture-o', 'view/project/add3', 'lpgl_tjlp_lpxc', 'lpgl_tjlp', '1', '3', '78'), ('2017100200000000024', '销控管理', 'fa-sort-numeric-asc', 'view/project/add4', 'lpgl_tjlp_xkgl', 'lpgl_tjlp', '1', '3', '79'), ('2017100200000000025', '合作信息', 'fa-slideshare', 'view/project/add5', 'lpgl_tjlp_hzxx', 'lpgl_tjlp', '1', '3', '80'), ('2017100200000000026', '产品维护', 'fa-share-alt', 'view/project/add6', 'lpgl_tjlp_cpwh', 'lpgl_tjlp', '1', '3', '81'), ('2017100200000000027', '拥金维护', 'fa-dollar', 'view/project/add7', 'lpgl_tjlp_rjwh', 'lpgl_tjlp', '1', '3', '82'), ('2017100200000000028', '楼盘动态', 'fa-list-alt', 'view/project/add8', 'lpgl_tjlp_lpdt', 'lpgl_tjlp', '1', '3', '83'), ('2017100200000000029', '优惠活动', 'fa-heart', 'view/project/add9', 'lpgl_tjlp_yhhd', 'lpgl_tjlp', '1', '3', '84'), ('2017100200000000030', '经济公司/经纪人', 'fa-group', null, 'jjgsjjr', null, '1', '1', '90'), ('2017100200000000031', '经纪公司维护', 'fa-vine', 'view/firm/list', 'jjgsjjr_jjgswh', 'jjgsjjr', '1', '2', '91'), ('2017100200000000032', '经纪人管理', 'fa-group', 'view/agent/list', 'jjgsjjr_jjrgl', 'jjgsjjr', '1', '2', '92'), ('2017100200000000033', '经纪人实名认证', 'fa-newspaper-o', 'view/agent/list', 'jjgsjjr_jjrsmrz', 'jjgsjjr', '1', '2', '93'), ('2017100200000000034', '经纪人银行卡认证', 'fa-credit-card', 'view/agent/list', 'jjgsjjr_jjryhkrz', 'jjgsjjr', '1', '2', '94'), ('2017100200000000035', '置业顾问管理', 'fa-user-md', null, 'zygwgl', null, '1', '1', '100'), ('2017100200000000036', '置业顾问挂靠审核', 'fa-stumbleupon', 'view/adviserProject/adviserAuditList', 'zygwgl_zygwgksh', 'zygwgl', '1', '2', '101'), ('2017100200000000037', '置业顾问管理', 'fa-user-md', 'view/adviser/list', 'zygwgl_zygwgl', 'zygwgl', '1', '2', '102'), ('2017100200000000038', '置业顾问实名认证', 'fa-newspaper-o', 'view/agent/list', 'zygwgl_zygwsmrz', 'zygwgl', '1', '2', '103'), ('2017100200000000039', '置业顾问银行卡认证', 'fa-credit-card', 'view/agent/list', 'zygwgl_zygwyhkrz', 'zygwgl', '1', '2', '104'), ('2017100200000000040', '置业顾问元宝提现', 'fa-database', 'view/agent/list', 'zygwgl_zygwybtx', 'zygwgl', '1', '2', '105'), ('2017100200000000041', 'POS交易管理', 'fa-credit-card', null, 'posjygl', null, '1', '1', '110'), ('2017100200000000042', 'POS机绑定', 'fa-unlock-alt', 'view/pos/bind', 'posjygl_posjbd', 'posjygl', '1', '2', '111'), ('2017100200000000043', 'POS绑定信息', 'fa-link', 'view/pos/list', 'posjygl_posbdxx', 'posjygl', '1', '2', '112'), ('2017100200000000044', 'POS交易信息', 'fa-legal', 'view/pos/poslog', 'posjygl_posjyxx', 'posjygl', '1', '2', '113'), ('2017100200000000045', '数据统计', 'fa-pie-chart', null, 'sjtj', null, '1', '1', '120'), ('2017100200000000046', '用户统计', 'fa-user', 'view/data/statIncome_data', 'sjtj_yhtj', 'sjtj', '1', '2', '121'), ('2017100200000000047', '客户统计', 'fa-group', 'view/data/statIncome_data', 'sjtj_khtj', 'sjtj', '1', '2', '122'), ('2017100200000000048', '收入统计', 'fa-line-chart', 'view/data/statIncome_data', 'sjtj_sytj', 'sjtj', '1', '2', '123'), ('2017100200000000049', '佣金统计', 'fa-pie-chart', 'view/data/statIncome_data', 'sjtj_yjtj', 'sjtj', '1', '2', '124'), ('2017100200000000050', '合同管理', 'fa-edit', null, 'htgl', null, '1', '1', '130'), ('2017100200000000051', '添加/管理列表', 'fa-plus', 'view/agreement/list', 'htgl_tjgllb', 'htgl', '1', '2', '131'), ('2017100200000000052', '转认购', 'fa-mail-forward', 'view/agreement/rengou', 'htgl_zrg', 'htgl', '1', '2', '132'), ('2017100200000000053', '签约', 'fa-check-square-o', 'view/agreement/qianyue', 'htgl_qy', 'htgl', '1', '2', '133'), ('2017100200000000054', '合同明细/编辑', 'fa-edit', 'view/agreement/edit', 'htgl_htmxbj', 'htgl', '1', '2', '134'), ('2017100200000000055', '合同详情', 'fa-building-o', 'view/agreement/view', 'htgl_htxq', 'htgl', '1', '2', '135'), ('2017100200000000056', '总经理', 'fa-sitemap', null, 'zjl', null, '1', '1', '140'), ('2017100200000000057', '客户统计', 'fa-group', 'view/data/statIncome_data', 'zjl_khtj', 'zjl', '1', '2', '141'), ('2017100200000000058', '收入统计', 'fa-line-chart', 'view/data/statIncome_data', 'zjl_sytj', 'zjl', '1', '2', '143'), ('2017100200000000059', '佣金统计', 'fa-pie-chart', 'view/data/statIncome_data', 'zjl_yjtj', 'zjl', '1', '2', '144'), ('2017100200000000060', '经济公司管理员', 'fa-sitemap', null, 'jjgsgly', null, '1', '1', '150'), ('2017100200000000061', '合作', 'fa-slideshare', 'view/firm/verify', 'jjgsgly_hz', 'jjgsgly', '1', '2', '151'), ('2017100200000000062', '门店列表', 'fa-slideshare', 'view/firm/list2', 'jjgsgly_mdlb', 'jjgsgly', '1', '2', '152'), ('2017100200000000063', '账号管理', 'fa-slideshare', 'view/user/user_list', 'jjgsgly_zhgl', 'jjgsgly', '1', '2', '153'), ('2017100200000000064', '挂靠审核', 'fa-slideshare', 'view/firm/verify', 'jjgsgly_ghsh', 'jjgsgly', '1', '2', '154'), ('2017100200000000065', '对公账号', 'fa-slideshare', 'view/firm/view', 'jjgsgly_dgzh', 'jjgsgly', '1', '2', '155'), ('2017100200000000066', '经纪人列表', 'fa-slideshare', 'view/agent/list', 'jjgsgly_jjrlb', 'jjgsgly', '1', '2', '156'), ('2017100200000000067', '客户列表', 'fa-slideshare', 'view/agent/custAgent', 'jjgsgly_khlb', 'jjgsgly', '1', '2', '157'), ('2017100200000000068', '佣金信息', 'fa-slideshare', 'view/commission/agentCommission', 'jjgsgly_yjxx', 'jjgsgly', '1', '2', '158'), ('2017100200000000069', '额外佣金', 'fa-slideshare', 'view/commission/commissionExt', 'jjgsgly_ewyj', 'jjgsgly', '1', '2', '159'), ('2017100200000000070', '客户统计', 'fa-group', 'view/data/statIncome_data', 'jjgsgly_khtj', 'jjgsgly', '1', '2', '160'), ('2017100200000000071', '收入统计', 'fa-line-chart', 'view/data/statIncome_data', 'jjgsgly_sytj', 'jjgsgly', '1', '2', '161'), ('2017100200000000072', '佣金统计', 'fa-pie-chart', 'view/data/statIncome_data', 'jjgsgly_yjtj', 'jjgsgly', '1', '2', '162'), ('2017100200000000073', '门店管理员', 'fa-sitemap', null, 'mdgly', null, '1', '1', '170'), ('2017100200000000074', '挂靠审核', 'fa-slideshare', 'view/firm/verify', 'mdgly_ghsh', 'mdgly', '1', '2', '171'), ('2017100200000000075', '经纪人列表', 'fa-slideshare', 'view/agent/list', 'mdgly_jjrlb', 'mdgly', '1', '2', '172'), ('2017100200000000076', '客户列表', 'fa-slideshare', 'view/agent/custAgent', 'mdgly_khlb', 'mdgly', '1', '2', '173'), ('2017100200000000077', '用户统计', 'fa-user', 'view/data/statIncome_data', 'mdgly_yhtj2', 'mdgly', '1', '2', '174'), ('2017100200000000078', '用户统计', 'fa-user', 'view/data/statIncome_data', 'mdgly_yhtj3', 'mdgly', '1', '2', '175'), ('2017100200000000079', '用户统计', 'fa-user', 'view/data/statIncome_data', 'mdgly_yhtj4', 'mdgly', '1', '2', '176'), ('2017100200000000080', '客户统计', 'fa-group', 'view/data/statIncome_data', 'mdgly_khtj', 'mdgly', '1', '2', '177'), ('2017100200000000081', '案场经理', 'fa-sitemap', null, 'acjl', null, '1', '1', '180'), ('2017100200000000082', '楼盘管理', null, null, 'acjl_lpgl', 'acjl', '1', '2', '181'), ('2017100200000000083', '楼盘列表', null, 'view/project/list', 'acjl_lpgl_lpgl', 'acjl_lpgl', '1', '3', '182'), ('2017100200000000084', '编辑添加', null, 'view/project/add', 'acjl_lpgl_bjtj', 'acjl_lpgl', '1', '3', '183'), ('2017100200000000085', '置业顾问挂靠审核', 'fa-stumbleupon', 'view/adviserProject/adviserAuditList', 'acjl_zygwgksh', 'acjl', '1', '2', '184'), ('2017100200000000086', '置业顾问管理', 'fa-user-md', 'view/adviser/list', 'acjl_zygwgl', 'acjl', '1', '2', '185'), ('2017100200000000087', '客户审核', null, 'view/custintent/custAuditList', 'acjl_khsh', 'acjl', '1', '2', '186'), ('2017100200000000088', '项目总监', null, null, 'xmzj', null, '1', '1', '190'), ('2017100200000000089', '客户统计', 'fa-group', 'view/data/statIncome_data', 'xmzj_khtj', 'xmzj', '1', '2', '191'), ('2017100200000000090', '收入统计', 'fa-line-chart', 'view/data/statIncome_data', 'xmzj_sytj', 'xmzj', '1', '2', '192'), ('2017100200000000091', '佣金统计', 'fa-pie-chart', 'view/data/statIncome_data', 'xmzj_yjtj', 'xmzj', '1', '2', '193'), ('2017100200000000092', '项目经理', 'fa-sitemap', null, 'xmjl', null, '1', '1', '200'), ('2017100200000000093', '开通楼盘', 'fa-plus', 'view/project/openProject', 'xmjl_ktlp', 'xmjl', '1', '2', '201'), ('2017100200000000094', '账号管理', 'fa-slideshare', 'view/user/user_list', 'xmjl_zhgl', 'xmjl', '1', '2', '202'), ('2017100200000000095', '佣金审核', null, 'view/commission/list', 'xmjl_yjsh', 'xmjl', '1', '2', '203'), ('2017100200000000096', '开发商补贴', null, 'view/devpSubsidy/list', 'xmjl_kfsbt', 'xmjl', '1', '2', '204'), ('2017100200000000097', '推送管理', null, 'view/push/list', 'xmjl_tsgl', 'xmjl', '1', '2', '205'), ('2017100200000000098', '客户统计', 'fa-group', 'view/data/statIncome_data', 'xmjl_khtj', 'xmjl', '1', '2', '206'), ('2017100200000000099', '收入统计', 'fa-line-chart', 'view/data/statIncome_data', 'xmjl_sytj', 'xmjl', '1', '2', '207'), ('2017100200000000100', '佣金统计', 'fa-pie-chart', 'view/data/statIncome_data', 'xmjl_yjtj', 'xmjl', '1', '2', '208'), ('2017100200000000101', '项目助理', 'fa-sitemap', null, 'xmzl', null, '1', '1', '210'), ('2017100200000000102', '确认到访', null, 'view/code/code', 'xmzl_qrdf', 'xmzl', '1', '2', '211'), ('2017100200000000103', '发送语音验证码', null, 'view/code/telcode', 'xmzl_fsyyyzm', 'xmzl', '1', '2', '212'), ('2017100200000000104', 'POS机绑定', 'fa-unlock-alt', 'view/pos/bind', 'xmzl_posjbd', 'xmzl', '1', '2', '213'), ('2017100200000000105', 'POS交易记录', 'fa-link', 'view/pos/list', 'xmzl_posbdxx', 'xmzl', '1', '2', '214'), ('2017100200000000106', '客户意向查询', null, 'view/custintent/custAuditList', 'xmzl_khyxqx', 'xmzl', '1', '2', '215'), ('2017100200000000107', '合同管理', null, 'view/agreement/list', 'xmzl_htgl', 'xmzl', '1', '2', '216'), ('2017100200000000108', '运营专员', 'fa-sitemap', null, 'yyzy', null, '1', '1', '220'), ('2017100200000000109', '签到规则配置', null, 'view/sysconfig/signin', 'yyzy_qdgzpz', 'yyzy', '1', '2', '221'), ('2017100200000000110', '楼盘管理', 'fa-building', 'view/project/manager_list', 'yyzy_lpgl', 'yyzy', '1', '2', '222'), ('2017100200000000111', '城市管理', null, 'view/city/add2', 'yyzy_tjcs', 'yyzy', '1', '2', '223'), ('2017100200000000112', '账号管理', 'fa-slideshare', 'view/user/user_list', 'yyzy_zhgl', 'yyzy', '1', '2', '224'), ('2017100200000000113', '推送管理', null, 'view/push/list', 'yyzy_tsgl', 'yyzy', '1', '2', '225'), ('2017100200000000114', '广告位管理', null, 'view/adv/list', 'yyzy_ggwgl', 'yyzy', '1', '2', '226'), ('2017100200000000115', '客户意向查询', null, 'view/custintent/custAuditList', 'yyzy_khyxqx', 'yyzy', '1', '2', '227'), ('2017100200000000116', 'POS机绑定', 'fa-unlock-alt', 'view/pos/bind', 'yyzy_posjbd', 'yyzy', '1', '2', '228'), ('2017100200000000117', 'POS交易记录', 'fa-link', 'view/pos/list', 'yyzy_posjyjl', 'yyzy', '1', '2', '229'), ('2017100200000000118', '签约经纪公司', null, 'view/pos/list', 'yyzy_qyjjgs', 'yyzy', '1', '2', '230'), ('2017100200000000119', '经纪人管理', 'fa-group', 'view/agent/list', 'yyzy_jjrgl', 'yyzy', '1', '2', '231'), ('2017100200000000120', '用户统计', 'fa-user', 'view/data/statIncome_data', 'yyzy_yhtj', 'yyzy', '1', '2', '232'), ('2017100200000000121', '客户统计', 'fa-group', 'view/data/statIncome_data', 'yyzy_khtj', 'yyzy', '1', '2', '233'), ('2017100200000000122', '收入统计', 'fa-line-chart', 'view/data/statIncome_data', 'yyzy_sytj', 'yyzy', '1', '2', '234'), ('2017100200000000123', '佣金统计', 'fa-pie-chart', 'view/data/statIncome_data', 'yyzy_yjtj', 'yyzy', '1', '2', '235'), ('2017100200000000124', '佣金专员', 'fa-sitemap', null, 'yjzy', null, '1', '1', '240'), ('2017100200000000125', '佣金规则审核', null, 'view/commission/auditList', 'yjzy_yjgzsh', 'yjzy', '1', '2', '241'), ('2017100200000000126', '经纪人实名认证', 'fa-newspaper-o', 'view/agent/list', 'yjzy_jjrsmrz', 'yjzy', '1', '2', '242'), ('2017100200000000127', '经纪人银行卡认证', 'fa-credit-card', 'view/agent/list', 'yjzy_jjryhkrz', 'yjzy', '1', '2', '243'), ('2017100200000000128', '经纪人元宝提现', 'fa-credit-card', 'view/agent/grain', 'yjzy_jjrybtx', 'yjzy', '1', '2', '244'), ('2017100200000000129', '置业顾问实名认证', 'fa-newspaper-o', 'view/agent/list', 'yjzy_zygwsmrz', 'yjzy', '1', '2', '245'), ('2017100200000000130', '置业顾问银行卡认证', 'fa-credit-card', 'view/agent/list', 'yjzy_zygwyhkrz', 'yjzy', '1', '2', '246'), ('2017100200000000131', '置业顾问元宝提现', 'fa-database', 'view/agent/list', 'yjzy_zygwybtx', 'yjzy', '1', '2', '247'), ('2017100200000000132', '对公账号审核', 'fa-database', 'view/firm/account', 'yjzy_dgzhsh', 'yjzy', '1', '2', '248'), ('2017100200000000133', '退款审核', null, 'view/refund/list', 'yjzy_tksh', 'yjzy', '1', '2', '249'), ('2017100200000000134', '佣金审核', null, 'view/commission/list', 'yjzy_yjsh', 'yjzy', '1', '2', '250'), ('2017100200000000135', '合同管理', null, 'view/agreement/list', 'yjzy_htgl', 'yjzy', '1', '2', '251'), ('2017100200000000136', '额外佣金审核', null, 'view/commission/Ext', 'yjzy_ewyjsh', 'yjzy', '1', '2', '252'), ('2017100200000000137', '出纳专员', 'fa-sitemap', null, 'cnzy', null, '1', '1', '260'), ('2017100200000000138', '经纪人元宝提现', 'fa-credit-card', 'view/agent/grain', 'cnzy_jjrybtx', 'cnzy', '1', '2', '261'), ('2017100200000000139', '置业顾问元宝提现', 'fa-database', 'view/agent/list', 'cnzy_zygwybtx', 'cnzy', '1', '2', '262'), ('2017100200000000140', '退款审核', null, 'view/refund/list', 'cnzy_tksh', 'cnzy', '1', '2', '263'), ('2017100200000000141', '佣金审核', null, 'view/commission/list', 'cnzy_yjsh', 'cnzy', '1', '2', '264'), ('2017100200000000142', '额外佣金审核', null, 'view/commission/Ext', 'cnzy_ewyjsh', 'cnzy', '1', '2', '265'), ('2017100200000000143', '财务专员', null, null, 'cwzy', null, '1', '1', '270'), ('2017100200000000144', '经纪人元宝提现', 'fa-credit-card', 'view/agent/grain', 'cwzy_jjrybtx', 'cwzy', '1', '2', '271'), ('2017100200000000145', '置业顾问元宝提现', 'fa-database', 'view/agent/list', 'cwzy_zygwybtx', 'cwzy', '1', '2', '272'), ('2017100200000000146', '开发商补贴确认', null, 'view/devpSubsidy/list2', 'cwzy_kfsbt', 'cwzy', '1', '2', '273'), ('2017100200000000147', '退款审核', null, 'view/refund/list', 'cwzy_tksh', 'cwzy', '1', '2', '274'), ('2017100200000000148', '佣金审核', null, 'view/commission/list', 'cwzy_yjsh', 'cwzy', '1', '2', '275'), ('2017100200000000149', 'POS交易记录', 'fa-link', 'view/pos/list', 'cwzy_posbdxx', 'cwzy', '1', '2', '276'), ('2017100200000000150', '额外佣金审核', null, 'view/commission/Ext', 'cwzy_ewyjsh', 'cwzy', '1', '2', '277'), ('2017100200000000151', '经纪服务专员测试', 'fa-sitemap', null, 'jjfwzycs', null, '1', '1', '280'), ('2017100200000000152', '经纪公司维护', null, 'view/firm/list2', 'jjfwzycs_jjgswh', 'jjfwzycs', '1', '2', '281'), ('2017100200000000153', '客服专员', 'fa-sitemap', null, 'kfzy', null, '1', '1', '290'), ('2017100200000000154', '客户意向审核', 'fa-sitemap', 'view/custintent/custSupport', 'kfzy_khyxsh', 'kfzy', '1', '2', '291');
COMMIT;

-- ----------------------------
--  Table structure for `t_sys_role`
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_role`;
CREATE TABLE `t_sys_role` (
  `id` varchar(32) NOT NULL COMMENT '主键',
  `name` varchar(255) DEFAULT NULL COMMENT '角色名',
  `code` varchar(255) DEFAULT NULL COMMENT '角色编码',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
--  Records of `t_sys_role`
-- ----------------------------
BEGIN;
INSERT INTO `t_sys_role` VALUES ('2017100300000000001', '超级管理员', 'admin_role', '超级管理员'), ('2017100300000000002', '普通用户', 'common_role', '普通用户');
COMMIT;

-- ----------------------------
--  Table structure for `t_sys_role_permission`
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_role_permission`;
CREATE TABLE `t_sys_role_permission` (
  `id` varchar(32) NOT NULL COMMENT '主键',
  `permission_id` varchar(255) DEFAULT NULL COMMENT '菜单表主键',
  `role_id` varchar(255) DEFAULT NULL COMMENT '角色表主键',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
--  Records of `t_sys_role_permission`
-- ----------------------------
BEGIN;
INSERT INTO `t_sys_role_permission` VALUES ('2017100400000000001', '2017100200000000001', '2017100300000000001'), ('2017100400000000002', '2017100200000000001', '2017100300000000002'), ('2017100400000000003', '2017100200000000002', '2017100300000000001'), ('2017100400000000004', '2017100200000000002', '2017100300000000002'), ('2017100400000000005', '2017100200000000003', '2017100300000000001'), ('2017100400000000006', '2017100200000000003', '2017100300000000002'), ('2017100400000000007', '2017100200000000004', '2017100300000000001'), ('2017100400000000008', '2017100200000000004', '2017100300000000002'), ('2017100400000000015', '2017100200000000008', '2017100300000000001'), ('2017100400000000016', '2017100200000000008', '2017100300000000002'), ('2017100400000000017', '2017100200000000009', '2017100300000000001'), ('2017100400000000018', '2017100200000000009', '2017100300000000002'), ('2017100400000000019', '2017100200000000010', '2017100300000000001'), ('2017100400000000020', '2017100200000000010', '2017100300000000002'), ('2017100400000000021', '2017100200000000011', '2017100300000000001'), ('2017100400000000022', '2017100200000000011', '2017100300000000002'), ('2017100400000000023', '2017100200000000012', '2017100300000000001'), ('2017100400000000024', '2017100200000000012', '2017100300000000002'), ('2017100400000000025', '2017100200000000013', '2017100300000000001'), ('2017100400000000026', '2017100200000000013', '2017100300000000002'), ('2017100400000000027', '2017100200000000014', '2017100300000000001'), ('2017100400000000028', '2017100200000000014', '2017100300000000002'), ('2017100400000000029', '2017100200000000015', '2017100300000000001'), ('2017100400000000030', '2017100200000000015', '2017100300000000002'), ('2017100400000000031', '2017100200000000016', '2017100300000000001'), ('2017100400000000032', '2017100200000000016', '2017100300000000002'), ('2017100400000000033', '2017100200000000017', '2017100300000000001'), ('2017100400000000034', '2017100200000000017', '2017100300000000002'), ('2017100400000000035', '2017100200000000018', '2017100300000000001'), ('2017100400000000036', '2017100200000000018', '2017100300000000002'), ('2017100400000000037', '2017100200000000019', '2017100300000000001'), ('2017100400000000038', '2017100200000000019', '2017100300000000002'), ('2017100400000000039', '2017100200000000020', '2017100300000000001'), ('2017100400000000040', '2017100200000000020', '2017100300000000002'), ('2017100400000000041', '2017100200000000021', '2017100300000000001'), ('2017100400000000042', '2017100200000000021', '2017100300000000002'), ('2017100400000000043', '2017100200000000022', '2017100300000000001'), ('2017100400000000044', '2017100200000000022', '2017100300000000002'), ('2017100400000000045', '2017100200000000023', '2017100300000000001'), ('2017100400000000046', '2017100200000000023', '2017100300000000002'), ('2017100400000000047', '2017100200000000024', '2017100300000000001'), ('2017100400000000048', '2017100200000000024', '2017100300000000002'), ('2017100400000000049', '2017100200000000025', '2017100300000000001'), ('2017100400000000050', '2017100200000000025', '2017100300000000002'), ('2017100400000000051', '2017100200000000026', '2017100300000000001'), ('2017100400000000052', '2017100200000000026', '2017100300000000002'), ('2017100400000000053', '2017100200000000027', '2017100300000000001'), ('2017100400000000054', '2017100200000000027', '2017100300000000002'), ('2017100400000000055', '2017100200000000028', '2017100300000000001'), ('2017100400000000056', '2017100200000000028', '2017100300000000002'), ('2017100400000000057', '2017100200000000029', '2017100300000000001'), ('2017100400000000058', '2017100200000000029', '2017100300000000002'), ('2017100400000000059', '2017100200000000030', '2017100300000000001'), ('2017100400000000060', '2017100200000000030', '2017100300000000002'), ('2017100400000000061', '2017100200000000031', '2017100300000000001'), ('2017100400000000062', '2017100200000000031', '2017100300000000002'), ('2017100400000000063', '2017100200000000032', '2017100300000000001'), ('2017100400000000064', '2017100200000000032', '2017100300000000002'), ('2017100400000000065', '2017100200000000033', '2017100300000000001'), ('2017100400000000066', '2017100200000000033', '2017100300000000002'), ('2017100400000000067', '2017100200000000034', '2017100300000000001'), ('2017100400000000068', '2017100200000000034', '2017100300000000002'), ('2017100400000000069', '2017100200000000035', '2017100300000000001'), ('2017100400000000070', '2017100200000000035', '2017100300000000002'), ('2017100400000000071', '2017100200000000036', '2017100300000000001'), ('2017100400000000072', '2017100200000000036', '2017100300000000002'), ('2017100400000000073', '2017100200000000037', '2017100300000000001'), ('2017100400000000074', '2017100200000000037', '2017100300000000002'), ('2017100400000000075', '2017100200000000038', '2017100300000000001'), ('2017100400000000076', '2017100200000000038', '2017100300000000002'), ('2017100400000000077', '2017100200000000039', '2017100300000000001'), ('2017100400000000078', '2017100200000000039', '2017100300000000002'), ('2017100400000000079', '2017100200000000040', '2017100300000000001'), ('2017100400000000080', '2017100200000000040', '2017100300000000002'), ('2017100400000000081', '2017100200000000041', '2017100300000000001'), ('2017100400000000082', '2017100200000000041', '2017100300000000002'), ('2017100400000000083', '2017100200000000042', '2017100300000000001'), ('2017100400000000084', '2017100200000000042', '2017100300000000002'), ('2017100400000000085', '2017100200000000043', '2017100300000000001'), ('2017100400000000086', '2017100200000000043', '2017100300000000002'), ('2017100400000000087', '2017100200000000044', '2017100300000000001'), ('2017100400000000088', '2017100200000000044', '2017100300000000002'), ('2017100400000000089', '2017100200000000045', '2017100300000000001'), ('2017100400000000090', '2017100200000000045', '2017100300000000002'), ('2017100400000000091', '2017100200000000046', '2017100300000000001'), ('2017100400000000092', '2017100200000000046', '2017100300000000002'), ('2017100400000000093', '2017100200000000047', '2017100300000000001'), ('2017100400000000094', '2017100200000000047', '2017100300000000002'), ('2017100400000000095', '2017100200000000048', '2017100300000000001'), ('2017100400000000096', '2017100200000000048', '2017100300000000002'), ('2017100400000000097', '2017100200000000049', '2017100300000000001'), ('2017100400000000098', '2017100200000000049', '2017100300000000002'), ('2017100400000000099', '2017100200000000050', '2017100300000000001'), ('2017100400000000100', '2017100200000000050', '2017100300000000002'), ('2017100400000000101', '2017100200000000051', '2017100300000000001'), ('2017100400000000102', '2017100200000000051', '2017100300000000002'), ('2017100400000000103', '2017100200000000052', '2017100300000000001'), ('2017100400000000104', '2017100200000000052', '2017100300000000002'), ('2017100400000000105', '2017100200000000053', '2017100300000000001'), ('2017100400000000106', '2017100200000000053', '2017100300000000002'), ('2017100400000000107', '2017100200000000054', '2017100300000000001'), ('2017100400000000108', '2017100200000000054', '2017100300000000002'), ('2017100400000000109', '2017100200000000055', '2017100300000000001'), ('2017100400000000110', '2017100200000000055', '2017100300000000002'), ('2017100400000000111', '2017100200000000056', '2017100300000000001'), ('2017100400000000112', '2017100200000000056', '2017100300000000002'), ('2017100400000000113', '2017100200000000057', '2017100300000000001'), ('2017100400000000114', '2017100200000000057', '2017100300000000002'), ('2017100400000000115', '2017100200000000058', '2017100300000000001'), ('2017100400000000116', '2017100200000000058', '2017100300000000002'), ('2017100400000000117', '2017100200000000059', '2017100300000000001'), ('2017100400000000118', '2017100200000000059', '2017100300000000002'), ('2017100400000000119', '2017100200000000060', '2017100300000000001'), ('2017100400000000120', '2017100200000000060', '2017100300000000002'), ('2017100400000000121', '2017100200000000061', '2017100300000000001'), ('2017100400000000122', '2017100200000000061', '2017100300000000002'), ('2017100400000000123', '2017100200000000062', '2017100300000000001'), ('2017100400000000124', '2017100200000000062', '2017100300000000002'), ('2017100400000000125', '2017100200000000063', '2017100300000000001'), ('2017100400000000126', '2017100200000000063', '2017100300000000002'), ('2017100400000000127', '2017100200000000064', '2017100300000000001'), ('2017100400000000128', '2017100200000000064', '2017100300000000002'), ('2017100400000000129', '2017100200000000065', '2017100300000000001'), ('2017100400000000130', '2017100200000000065', '2017100300000000002'), ('2017100400000000131', '2017100200000000066', '2017100300000000001'), ('2017100400000000132', '2017100200000000066', '2017100300000000002'), ('2017100400000000133', '2017100200000000067', '2017100300000000001'), ('2017100400000000134', '2017100200000000067', '2017100300000000002'), ('2017100400000000135', '2017100200000000068', '2017100300000000001'), ('2017100400000000136', '2017100200000000068', '2017100300000000002'), ('2017100400000000137', '2017100200000000069', '2017100300000000001'), ('2017100400000000138', '2017100200000000069', '2017100300000000002'), ('2017100400000000139', '2017100200000000070', '2017100300000000001'), ('2017100400000000140', '2017100200000000070', '2017100300000000002'), ('2017100400000000141', '2017100200000000071', '2017100300000000001'), ('2017100400000000142', '2017100200000000071', '2017100300000000002'), ('2017100400000000143', '2017100200000000072', '2017100300000000001'), ('2017100400000000144', '2017100200000000072', '2017100300000000002'), ('2017100400000000145', '2017100200000000073', '2017100300000000001'), ('2017100400000000146', '2017100200000000073', '2017100300000000002'), ('2017100400000000147', '2017100200000000074', '2017100300000000001'), ('2017100400000000148', '2017100200000000074', '2017100300000000002'), ('2017100400000000149', '2017100200000000075', '2017100300000000001'), ('2017100400000000150', '2017100200000000075', '2017100300000000002'), ('2017100400000000151', '2017100200000000076', '2017100300000000001'), ('2017100400000000152', '2017100200000000076', '2017100300000000002'), ('2017100400000000153', '2017100200000000077', '2017100300000000001'), ('2017100400000000154', '2017100200000000077', '2017100300000000002'), ('2017100400000000155', '2017100200000000078', '2017100300000000001'), ('2017100400000000156', '2017100200000000078', '2017100300000000002'), ('2017100400000000157', '2017100200000000079', '2017100300000000001'), ('2017100400000000158', '2017100200000000079', '2017100300000000002'), ('2017100400000000159', '2017100200000000080', '2017100300000000001'), ('2017100400000000160', '2017100200000000080', '2017100300000000002'), ('2017100400000000161', '2017100200000000081', '2017100300000000001'), ('2017100400000000162', '2017100200000000081', '2017100300000000002'), ('2017100400000000163', '2017100200000000082', '2017100300000000001'), ('2017100400000000164', '2017100200000000082', '2017100300000000002'), ('2017100400000000165', '2017100200000000083', '2017100300000000001'), ('2017100400000000166', '2017100200000000083', '2017100300000000002'), ('2017100400000000167', '2017100200000000084', '2017100300000000001'), ('2017100400000000168', '2017100200000000084', '2017100300000000002'), ('2017100400000000169', '2017100200000000085', '2017100300000000001'), ('2017100400000000170', '2017100200000000085', '2017100300000000002'), ('2017100400000000171', '2017100200000000086', '2017100300000000001'), ('2017100400000000172', '2017100200000000086', '2017100300000000002'), ('2017100400000000173', '2017100200000000087', '2017100300000000001'), ('2017100400000000174', '2017100200000000087', '2017100300000000002'), ('2017100400000000175', '2017100200000000088', '2017100300000000001'), ('2017100400000000176', '2017100200000000088', '2017100300000000002'), ('2017100400000000177', '2017100200000000089', '2017100300000000001'), ('2017100400000000178', '2017100200000000089', '2017100300000000002'), ('2017100400000000179', '2017100200000000090', '2017100300000000001'), ('2017100400000000180', '2017100200000000090', '2017100300000000002'), ('2017100400000000181', '2017100200000000091', '2017100300000000001'), ('2017100400000000182', '2017100200000000091', '2017100300000000002'), ('2017100400000000183', '2017100200000000092', '2017100300000000001'), ('2017100400000000184', '2017100200000000092', '2017100300000000002'), ('2017100400000000185', '2017100200000000093', '2017100300000000001'), ('2017100400000000186', '2017100200000000093', '2017100300000000002'), ('2017100400000000187', '2017100200000000094', '2017100300000000001'), ('2017100400000000188', '2017100200000000094', '2017100300000000002'), ('2017100400000000189', '2017100200000000095', '2017100300000000001'), ('2017100400000000190', '2017100200000000095', '2017100300000000002'), ('2017100400000000191', '2017100200000000096', '2017100300000000001'), ('2017100400000000192', '2017100200000000096', '2017100300000000002'), ('2017100400000000193', '2017100200000000097', '2017100300000000001'), ('2017100400000000194', '2017100200000000097', '2017100300000000002'), ('2017100400000000195', '2017100200000000098', '2017100300000000001'), ('2017100400000000196', '2017100200000000098', '2017100300000000002'), ('2017100400000000197', '2017100200000000099', '2017100300000000001'), ('2017100400000000198', '2017100200000000099', '2017100300000000002'), ('2017100400000000199', '2017100200000000100', '2017100300000000001'), ('2017100400000000200', '2017100200000000100', '2017100300000000002'), ('2017100400000000201', '2017100200000000101', '2017100300000000001'), ('2017100400000000202', '2017100200000000101', '2017100300000000002'), ('2017100400000000203', '2017100200000000102', '2017100300000000001'), ('2017100400000000204', '2017100200000000102', '2017100300000000002'), ('2017100400000000205', '2017100200000000103', '2017100300000000001'), ('2017100400000000206', '2017100200000000103', '2017100300000000002'), ('2017100400000000207', '2017100200000000104', '2017100300000000001'), ('2017100400000000208', '2017100200000000104', '2017100300000000002'), ('2017100400000000209', '2017100200000000105', '2017100300000000001'), ('2017100400000000210', '2017100200000000105', '2017100300000000002'), ('2017100400000000211', '2017100200000000106', '2017100300000000001'), ('2017100400000000212', '2017100200000000106', '2017100300000000002'), ('2017100400000000213', '2017100200000000107', '2017100300000000001'), ('2017100400000000214', '2017100200000000107', '2017100300000000002'), ('2017100400000000215', '2017100200000000108', '2017100300000000001'), ('2017100400000000216', '2017100200000000108', '2017100300000000002'), ('2017100400000000217', '2017100200000000109', '2017100300000000001'), ('2017100400000000218', '2017100200000000109', '2017100300000000002'), ('2017100400000000219', '2017100200000000110', '2017100300000000001'), ('2017100400000000220', '2017100200000000110', '2017100300000000002'), ('2017100400000000221', '2017100200000000111', '2017100300000000001'), ('2017100400000000222', '2017100200000000111', '2017100300000000002'), ('2017100400000000223', '2017100200000000112', '2017100300000000001'), ('2017100400000000224', '2017100200000000112', '2017100300000000002'), ('2017100400000000225', '2017100200000000113', '2017100300000000001'), ('2017100400000000226', '2017100200000000113', '2017100300000000002'), ('2017100400000000227', '2017100200000000114', '2017100300000000001'), ('2017100400000000228', '2017100200000000114', '2017100300000000002'), ('2017100400000000229', '2017100200000000115', '2017100300000000001'), ('2017100400000000230', '2017100200000000115', '2017100300000000002'), ('2017100400000000231', '2017100200000000116', '2017100300000000001'), ('2017100400000000232', '2017100200000000116', '2017100300000000002'), ('2017100400000000233', '2017100200000000117', '2017100300000000001'), ('2017100400000000234', '2017100200000000117', '2017100300000000002'), ('2017100400000000235', '2017100200000000118', '2017100300000000001'), ('2017100400000000236', '2017100200000000118', '2017100300000000002'), ('2017100400000000237', '2017100200000000119', '2017100300000000001'), ('2017100400000000238', '2017100200000000119', '2017100300000000002'), ('2017100400000000239', '2017100200000000120', '2017100300000000001'), ('2017100400000000240', '2017100200000000120', '2017100300000000002'), ('2017100400000000241', '2017100200000000121', '2017100300000000001'), ('2017100400000000242', '2017100200000000121', '2017100300000000002'), ('2017100400000000243', '2017100200000000122', '2017100300000000001'), ('2017100400000000244', '2017100200000000122', '2017100300000000002'), ('2017100400000000245', '2017100200000000123', '2017100300000000001'), ('2017100400000000246', '2017100200000000123', '2017100300000000002'), ('2017100400000000247', '2017100200000000124', '2017100300000000001'), ('2017100400000000248', '2017100200000000124', '2017100300000000002'), ('2017100400000000249', '2017100200000000125', '2017100300000000001'), ('2017100400000000250', '2017100200000000125', '2017100300000000002'), ('2017100400000000251', '2017100200000000126', '2017100300000000001'), ('2017100400000000252', '2017100200000000126', '2017100300000000002'), ('2017100400000000253', '2017100200000000127', '2017100300000000001'), ('2017100400000000254', '2017100200000000127', '2017100300000000002'), ('2017100400000000255', '2017100200000000128', '2017100300000000001'), ('2017100400000000256', '2017100200000000128', '2017100300000000002'), ('2017100400000000257', '2017100200000000129', '2017100300000000001'), ('2017100400000000258', '2017100200000000129', '2017100300000000002'), ('2017100400000000259', '2017100200000000130', '2017100300000000001'), ('2017100400000000260', '2017100200000000130', '2017100300000000002'), ('2017100400000000261', '2017100200000000131', '2017100300000000001'), ('2017100400000000262', '2017100200000000131', '2017100300000000002'), ('2017100400000000263', '2017100200000000132', '2017100300000000001'), ('2017100400000000264', '2017100200000000132', '2017100300000000002'), ('2017100400000000265', '2017100200000000133', '2017100300000000001'), ('2017100400000000266', '2017100200000000133', '2017100300000000002'), ('2017100400000000267', '2017100200000000134', '2017100300000000001'), ('2017100400000000268', '2017100200000000134', '2017100300000000002'), ('2017100400000000269', '2017100200000000135', '2017100300000000001'), ('2017100400000000270', '2017100200000000135', '2017100300000000002'), ('2017100400000000271', '2017100200000000136', '2017100300000000001'), ('2017100400000000272', '2017100200000000136', '2017100300000000002'), ('2017100400000000273', '2017100200000000137', '2017100300000000001'), ('2017100400000000274', '2017100200000000137', '2017100300000000002'), ('2017100400000000275', '2017100200000000138', '2017100300000000001'), ('2017100400000000276', '2017100200000000138', '2017100300000000002'), ('2017100400000000277', '2017100200000000139', '2017100300000000001'), ('2017100400000000278', '2017100200000000139', '2017100300000000002'), ('2017100400000000279', '2017100200000000140', '2017100300000000001'), ('2017100400000000280', '2017100200000000140', '2017100300000000002'), ('2017100400000000281', '2017100200000000141', '2017100300000000001'), ('2017100400000000282', '2017100200000000141', '2017100300000000002'), ('2017100400000000283', '2017100200000000142', '2017100300000000001'), ('2017100400000000284', '2017100200000000142', '2017100300000000002'), ('2017100400000000285', '2017100200000000143', '2017100300000000001'), ('2017100400000000286', '2017100200000000143', '2017100300000000002'), ('2017100400000000287', '2017100200000000144', '2017100300000000001'), ('2017100400000000288', '2017100200000000144', '2017100300000000002'), ('2017100400000000289', '2017100200000000145', '2017100300000000001'), ('2017100400000000290', '2017100200000000145', '2017100300000000002'), ('2017100400000000291', '2017100200000000146', '2017100300000000001'), ('2017100400000000292', '2017100200000000146', '2017100300000000002'), ('2017100400000000293', '2017100200000000147', '2017100300000000001'), ('2017100400000000294', '2017100200000000147', '2017100300000000002'), ('2017100400000000295', '2017100200000000148', '2017100300000000001'), ('2017100400000000296', '2017100200000000148', '2017100300000000002'), ('2017100400000000297', '2017100200000000149', '2017100300000000001'), ('2017100400000000298', '2017100200000000149', '2017100300000000002'), ('2017100400000000299', '2017100200000000150', '2017100300000000001'), ('2017100400000000300', '2017100200000000150', '2017100300000000002'), ('2017100400000000301', '2017100200000000151', '2017100300000000001'), ('2017100400000000302', '2017100200000000151', '2017100300000000002'), ('2017100400000000303', '2017100200000000152', '2017100300000000001'), ('2017100400000000304', '2017100200000000152', '2017100300000000002'), ('2017100400000000305', '2017100200000000153', '2017100300000000001'), ('2017100400000000306', '2017100200000000153', '2017100300000000002'), ('2017100400000000307', '2017100200000000154', '2017100300000000001'), ('2017100400000000308', '2017100200000000154', '2017100300000000002');
COMMIT;

-- ----------------------------
--  Table structure for `t_sys_user`
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_user`;
CREATE TABLE `t_sys_user` (
  `id` varchar(32) NOT NULL COMMENT '主键',
  `username` varchar(255) DEFAULT NULL COMMENT '登录账号',
  `password` varchar(255) DEFAULT NULL COMMENT '登录密码',
  `salt` varchar(255) DEFAULT NULL COMMENT 'salt',
  `true_name` varchar(255) DEFAULT NULL COMMENT '真实姓名',
  `email` varchar(255) DEFAULT NULL COMMENT '邮箱',
  `organize_id` varchar(255) DEFAULT NULL COMMENT '部门ID',
  `status` int(11) DEFAULT NULL COMMENT '状态：0=有效，1=无效',
  `last_login_time` datetime DEFAULT NULL COMMENT '上将登录时间',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `modify_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
--  Records of `t_sys_user`
-- ----------------------------
BEGIN;
INSERT INTO `t_sys_user` VALUES ('2017100500000000001', 'admin', '1b674d35616ce659a8329c717bd86f92aeea25d0', 'bf7d54e57f1dcf64', '管理员', 'admin@163.com', '2017100300000000001', '1', null, '2017-07-10 10:17:57', null), ('2017100500000000002', 'wangxin', '88224c07ca4cb62fae285bff8cf176efc46b1230', 'b70a35c29470e7cc', '王鑫', 'wangxin@139.com', '2017100300000000002', '1', null, '2017-07-10 10:17:57', null);
COMMIT;

-- ----------------------------
--  Table structure for `t_sys_user_role`
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_user_role`;
CREATE TABLE `t_sys_user_role` (
  `id` varchar(32) NOT NULL COMMENT '主键',
  `role_id` varchar(255) DEFAULT NULL COMMENT '角色表主键',
  `user_id` varchar(255) DEFAULT NULL COMMENT '用户表主键',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
--  Records of `t_sys_user_role`
-- ----------------------------
BEGIN;
INSERT INTO `t_sys_user_role` VALUES ('2017100600000000001', '2017100300000000001', '2017100500000000001'), ('2017100600000000002', '2017100300000000002', '2017100500000000002');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;