INSERT INTO `operation` (`id`, `native_code`, `code`, `name`, `module_id`, `active`, `create_time`, `update_time`, `update_by`) VALUES ('227', '3502', 'view', '获取指纹卡号', '72', '
', '2017-06-30 17:53:18', '2017-06-30 17:53:20', 'system');
INSERT INTO `operation` (`id`, `native_code`, `code`, `name`, `module_id`, `active`, `create_time`, `update_time`, `update_by`) VALUES ('228', '3502', 'view', '缴费确认', '72', '
', '2017-06-30 17:53:18', '2017-06-30 17:53:20', 'system');
INSERT INTO `operation` (`id`, `native_code`, `code`, `name`, `module_id`, `active`, `create_time`, `update_time`, `update_by`) VALUES ('229', '3502', 'view', '导出数据', '72', '
', '2017-06-30 17:53:18', '2017-06-30 17:53:20', 'system');
INSERT INTO `operation` (`id`, `native_code`, `code`, `name`, `module_id`, `active`, `create_time`, `update_time`, `update_by`) VALUES ('230', '3502', 'view', '导入数据', '72', '
', '2017-06-30 17:53:18', '2017-06-30 17:53:20', 'system');

-- 删除 adminq权限
DELETE from permission where role_id =1;
-- 插入admin角色的权限信息
INSERT INTO permission (native_code,role_id,module_id,operation_id,roletype) SELECT '3502',1,module_id,id,'1' FROM operation t where module_id in( select id from module where moduletype=1);