/*
Navicat MySQL Data Transfer

Source Server         : 百川信阿里云
Source Server Version : 50518
Source Host           : bcxin366.mysql.rds.aliyuncs.com:3306
Source Database       : ars

Target Server Type    : MYSQL
Target Server Version : 50518
File Encoding         : 65001

Date: 2017-11-18 09:32:48
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for module
-- ----------------------------
DROP TABLE IF EXISTS `module`;
CREATE TABLE `module` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `native_code` int(11) NOT NULL,
  `code` varchar(20) NOT NULL,
  `name` varchar(20) NOT NULL,
  `url` varchar(100) DEFAULT NULL,
  `seq` int(11) NOT NULL DEFAULT '0',
  `index` bit(1) NOT NULL DEFAULT b'0',
  `shortcut` bit(1) NOT NULL DEFAULT b'0',
  `class` varchar(100) DEFAULT NULL,
  `action` varchar(100) DEFAULT NULL,
  `active` bit(1) NOT NULL DEFAULT b'1',
  `create_time` datetime NOT NULL,
  `update_time` datetime NOT NULL,
  `update_by` varchar(20) NOT NULL,
  `moduletype` varchar(1) DEFAULT NULL COMMENT '公安1公司2',
  PRIMARY KEY (`id`),
  KEY `fk_module_native` (`native_code`),
  CONSTRAINT `fk_module_native` FOREIGN KEY (`native_code`) REFERENCES `native` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=119 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of module
-- ----------------------------
INSERT INTO `module` VALUES ('1', '3502', 'search', '一键搜', null, '1', '
', '\0', '', '', '
', '2017-02-28 22:53:42', '2017-02-28 22:53:45', 'system', '1');
INSERT INTO `module` VALUES ('2', '3502', 'person_ctr', '人员中心', null, '2', '
', '\0', '', '', '
', '2017-03-01 10:28:44', '2017-03-01 10:28:46', 'system', '1');
INSERT INTO `module` VALUES ('3', '3502', 'task_ctr', '任务中心', null, '3', '
', '\0', '', '', '
', '2017-03-01 10:29:07', '2017-03-01 10:29:10', 'system', '1');
INSERT INTO `module` VALUES ('4', '3502', 'ungentask_ctr', '紧急任务', null, '4', '
', '\0', '', '', '
', '2017-03-01 21:09:22', '2017-03-01 21:09:25', 'system', '1');
INSERT INTO `module` VALUES ('5', '3502', 'approval_ctr', '待办事项', null, '5', '\0', '\0', '', '', '
', '2017-03-01 10:29:32', '2017-03-01 10:29:34', 'system', '1');
INSERT INTO `module` VALUES ('6', '3502', 'complaint_ctr', '市民意见建议', null, '6', '\0', '\0', '', '', '
', '2017-03-01 10:29:54', '2017-03-01 10:29:57', 'system', '1');
INSERT INTO `module` VALUES ('25', '3502', 'search', '一键搜', null, '25', '
', '\0', '', '', '
', '2017-02-28 22:53:42', '2017-02-28 22:53:45', 'system', '2');
INSERT INTO `module` VALUES ('26', '3502', 'person_ctr', '人员中心', null, '26', '
', '\0', '', '', '
', '2017-03-01 10:28:44', '2017-03-01 10:28:46', 'system', '2');
INSERT INTO `module` VALUES ('27', '3502', 'task_ctr', '任务中心', null, '27', '
', '\0', '', '', '
', '2017-03-01 10:29:07', '2017-03-01 10:29:10', 'system', '2');
INSERT INTO `module` VALUES ('28', '3502', 'company_ctr', '安保公司中心', null, '28', '
', '\0', '', '', '\0', '2017-03-01 21:09:22', '2017-03-01 21:09:25', 'system', '2');
INSERT INTO `module` VALUES ('29', '3502', 'safety_srv', '保障服务', null, '29', '\0', '\0', '', '', '\0', '2017-03-01 10:29:32', '2017-03-01 10:29:34', 'system', '2');
INSERT INTO `module` VALUES ('30', '3502', 'person_mgr', '人员管理', null, '30', '\0', '\0', '', '', '
', '2017-03-01 10:29:54', '2017-03-01 10:29:57', 'system', '2');
INSERT INTO `module` VALUES ('31', '3502', 'org_mgr', '组织架构', null, '31', '\0', '\0', '', '', '
', '2017-03-01 10:30:20', '2017-03-01 10:30:22', 'system', '2');
INSERT INTO `module` VALUES ('32', '3502', 'role_mgr', '角色权限', null, '32', '\0', '\0', '', '', '
', '2017-03-01 10:30:53', '2017-03-01 10:30:59', 'system', '2');
INSERT INTO `module` VALUES ('33', '3502', 'company_info', '公司信息', null, '33', '\0', '\0', '', '', '
', '2017-03-01 10:30:57', '2017-03-01 10:31:02', 'system', '2');
INSERT INTO `module` VALUES ('64', '3502', 'xhmanager_ctr', '保安协会管理', null, '64', '\0', '\0', null, null, '
', '2017-06-30 17:08:00', '2017-06-30 17:08:04', 'system', '1');
INSERT INTO `module` VALUES ('65', '3502', 'jdmanager', '监督检查情况管理', null, '65', '\0', '\0', null, null, '
', '2017-06-30 17:41:19', '2017-06-30 17:41:21', 'system', '1');
INSERT INTO `module` VALUES ('66', '3502', 'sponsorlicense', '设立保安服务公司行政许可证管理', null, '66', '\0', '\0', null, null, '
', '2017-06-30 17:52:38', '2017-06-30 17:52:41', 'system', '1');
INSERT INTO `module` VALUES ('67', '3502', 'sponsorlicense', '设立保安培训单位行政许可证管理', null, '67', '\0', '\0', null, null, '
', '2017-06-30 17:55:58', '2017-05-01 17:55:55', 'system', '1');
INSERT INTO `module` VALUES ('68', '3502', 'subsidiary', '保安服务公司设立分公司备案管理', null, '68', '\0', '\0', null, null, '
', '2017-05-01 17:59:19', '2017-06-30 17:59:22', 'system', '1');
INSERT INTO `module` VALUES ('69', '3502', 'crosscompany', '跨区域经营保安服务备案管理', null, '69', '\0', '\0', null, null, '
', '2017-06-30 18:00:19', '2017-06-30 18:00:21', 'system', '1');
INSERT INTO `module` VALUES ('70', '3502', 'confesscompany', '自招单位备案管理', '', '70', '\0', '\0', '', '', '
', '2017-06-30 18:00:19', '2017-06-30 18:00:21', 'system', '1');
INSERT INTO `module` VALUES ('71', '3502', 'legalchange', '保安服务（培训）许可证项目变更', '', '71', '\0', '\0', '', '', '
', '2017-06-30 18:00:19', '2017-06-30 18:00:21', 'system', '1');
INSERT INTO `module` VALUES ('72', '3502', 'personcertificate', '保安员资格证考试报名', '', '72', '\0', '\0', '', '', '
', '2017-06-30 18:00:19', '2017-06-30 18:00:21', 'system', '1');
INSERT INTO `module` VALUES ('73', '3502', 'statistics', '培训统计', '', '73', '\0', '\0', '', '', '
', '2017-06-30 18:00:19', '2017-06-30 18:00:21', 'system', '1');
INSERT INTO `module` VALUES ('74', '3502', 'yearreport', '保安服务公司年度报告备案', '', '74', '\0', '\0', '', '', '
', '2017-06-30 18:00:19', '2017-06-30 18:00:21', 'system', '1');
INSERT INTO `module` VALUES ('75', '3502', 'orgManager', '机构管理', '', '75', '\0', '\0', '', '', '
', '2017-06-30 18:00:19', '2017-06-30 18:00:21', 'system', '1');
INSERT INTO `module` VALUES ('76', '3502', 'userManager', '用户管理', '', '76', '\0', '\0', '', '', '
', '2017-06-30 18:00:19', '2017-06-30 18:00:21', 'system', '1');
INSERT INTO `module` VALUES ('77', '3502', 'roleManager', '角色管理', '', '77', '\0', '\0', '', '', '
', '2017-06-30 18:00:19', '2017-06-30 18:00:21', 'system', '1');
INSERT INTO `module` VALUES ('78', '3502', 'companyManager', '保安公司管理', '', '78', '\0', '\0', '', '', '
', '2017-06-30 18:00:19', '2017-06-30 18:00:21', 'system', '1');
INSERT INTO `module` VALUES ('80', '3502', 'company_ctr', '安保公司中心', '', '80', '
', '\0', '', '', '
', '2017-03-01 21:09:22', '2017-03-01 21:09:25', 'system', '1');
INSERT INTO `module` VALUES ('81', '3502', 'securityTraincompany', '自行招用保安员单位管理', '', '81', '\0', '\0', '', '', '
', '2017-06-30 18:00:19', '2017-06-30 18:00:21', 'system', '1');
INSERT INTO `module` VALUES ('82', '3502', 'securityConfesscpy', '保安培训单位信息管理', '', '82', '\0', '\0', '', '', '
', '2017-06-30 18:00:19', '2017-06-30 18:00:21', 'system', '1');
INSERT INTO `module` VALUES ('83', '3502', 'task', '任务管理', '', '83', '\0', '\0', '', '', '
', '2017-03-01 10:30:57', '2017-03-01 10:31:02', 'system', '2');
INSERT INTO `module` VALUES ('84', '3502', 'team', '应急小队', '', '84', '\0', '\0', '', '', '
', '2017-03-01 10:30:57', '2017-03-01 10:31:02', 'system', '2');
INSERT INTO `module` VALUES ('85', '3502', 'ld', '劳动合同', '', '85', '\0', '\0', '', '', '
', '2017-03-01 10:30:57', '2017-03-01 10:31:02', 'system', '2');
INSERT INTO `module` VALUES ('86', '3502', 'fwht', '服务合同', '', '86', '\0', '\0', '', '', '
', '2017-03-01 10:30:57', '2017-03-01 10:31:02', 'system', '2');
INSERT INTO `module` VALUES ('87', '3502', 'kqjx', '跨区经营', '', '87', '\0', '\0', '', '', '
', '2017-03-01 10:30:57', '2017-03-01 10:31:02', 'system', '2');
INSERT INTO `module` VALUES ('88', '3502', 'hw', '海外经营', '', '88', '\0', '\0', '', '', '
', '2017-03-01 10:30:57', '2017-03-01 10:31:02', 'system', '2');
INSERT INTO `module` VALUES ('89', '3502', 'jl', '保安员奖励', '', '89', '\0', '\0', '', '', '
', '2017-03-01 10:30:57', '2017-03-01 10:31:02', 'system', '2');
INSERT INTO `module` VALUES ('90', '3502', 'cf', '保安员惩罚', '', '90', '\0', '\0', '', '', '
', '2017-03-01 10:30:57', '2017-03-01 10:31:02', 'system', '2');
INSERT INTO `module` VALUES ('91', '3502', 'hrhs', '好人好事', '', '91', '\0', '\0', '', '', '
', '2017-03-01 10:30:57', '2017-03-01 10:31:02', 'system', '2');
INSERT INTO `module` VALUES ('92', '3502', 'bay', '保安员证报名', '', '92', '\0', '\0', '', '', '
', '2017-03-01 10:30:57', '2017-03-01 10:31:02', 'system', '2');
INSERT INTO `module` VALUES ('93', '3502', 'bzfw', '保障服务', '', '93', '\0', '\0', '', '', '
', '2017-03-01 10:30:57', '2017-03-01 10:31:02', 'system', '2');
INSERT INTO `module` VALUES ('94', '3502', 'pxgl', '培训管理', '', '94', '\0', '\0', '', '', '
', '2017-03-01 10:30:57', '2017-03-01 10:31:02', 'system', '2');
INSERT INTO `module` VALUES ('95', '3502', 'clgl', '车辆管理', '', '95', '\0', '\0', '', '', '
', '2017-03-01 10:30:57', '2017-03-01 10:31:02', 'system', '2');
INSERT INTO `module` VALUES ('96', '3502', 'qzgl', '枪支管理', '', '96', '\0', '\0', '', '', '
', '2017-03-01 10:30:57', '2017-03-01 10:31:02', 'system', '2');
INSERT INTO `module` VALUES ('97', '3502', 'jfgl', '技防管理', '', '97', '\0', '\0', '', '', '
', '2017-03-01 10:30:57', '2017-03-01 10:31:02', 'system', '2');
INSERT INTO `module` VALUES ('98', '3502', 'fgs', '保安服务公司设立分公司备案', '', '98', '\0', '\0', '', '', '
', '2017-03-01 10:30:57', '2017-03-01 10:31:02', 'system', '2');
INSERT INTO `module` VALUES ('99', '3502', 'pxdw', '保安培训单位许可证申请', '', '99', '\0', '\0', '', '', '
', '2017-03-01 10:30:57', '2017-03-01 10:31:02', 'system', '2');
INSERT INTO `module` VALUES ('100', '3502', 'kq', '跨区域经营备案', '', '100', '\0', '\0', '', '', '
', '2017-03-01 10:30:57', '2017-03-01 10:31:02', 'system', '2');
INSERT INTO `module` VALUES ('101', '3502', 'frbg', '法人变更备案', '', '101', '\0', '\0', '', '', '
', '2017-03-01 10:30:57', '2017-03-01 10:31:02', 'system', '2');
INSERT INTO `module` VALUES ('102', '3502', 'ndbg', '年度报告备案', '', '102', '\0', '\0', '', '', '
', '2017-03-01 10:30:57', '2017-03-01 10:31:02', 'system', '2');
INSERT INTO `module` VALUES ('103', '3502', 'spjd', '审批进度', '', '103', '\0', '\0', '', '', '
', '2017-03-01 10:30:57', '2017-03-01 10:31:02', 'system', '2');
INSERT INTO `module` VALUES ('104', '3502', 'ungentask_ctr', '紧急任务', '', '104', '\0', '\0', '', '', '
', '2017-03-01 21:09:22', '2017-03-01 21:09:25', 'system', '2');
INSERT INTO `module` VALUES ('105', '3502', 'fgs', '分公司', '', '105', '\0', '\0', '', '', '
', '2017-03-01 21:09:22', '2017-03-01 21:09:25', 'system', '2');
INSERT INTO `module` VALUES ('106', '3502', 'czr', '出资人', '', '106', '\0', '\0', '', '', '
', '2017-03-01 21:09:22', '2017-03-01 21:09:25', 'system', '2');
INSERT INTO `module` VALUES ('107', '3502', 'glc', '管理层', '', '107', '\0', '\0', '', '', '
', '2017-03-01 21:09:22', '2017-03-01 21:09:25', 'system', '2');
INSERT INTO `module` VALUES ('108', '3502', 'fp', '发票管理', '', '108', '\0', '\0', '', '', '
', '2017-03-01 21:09:22', '2017-03-01 21:09:25', 'system', '2');
INSERT INTO `module` VALUES ('109', '3502', 'examinationarrange', '考试安排', '', '109', '\0', '\0', '', '', '
', '2017-06-30 18:00:19', '2017-06-30 18:00:21', 'system', '1');
INSERT INTO `module` VALUES ('110', '3502', 'baygl', '保安员管理', '', '110', '\0', '\0', '', '', '
', '2017-06-30 18:00:19', '2017-06-30 18:00:21', 'system', '1');
INSERT INTO `module` VALUES ('111', '3502', 'wtry', '问题人员', '', '111', '\0', '\0', '', '', '
', '2017-06-30 18:00:19', '2017-06-30 18:00:21', 'system', '1');
INSERT INTO `module` VALUES ('112', '3502', 'hrhs', '好人好事管理', '', '112', '\0', '\0', '', '', '
', '2017-06-30 18:00:19', '2017-06-30 18:00:21', 'system', '1');
INSERT INTO `module` VALUES ('113', '3502', 'sjtj', '数据统计', '', '113', '\0', '\0', '', '', '
', '2017-06-30 18:00:19', '2017-06-30 18:00:21', 'system', '1');
INSERT INTO `module` VALUES ('114', '3502', 'jdmanager', '保安服务公司许可证审批', '', '114', '\0', '\0', '', '', '
', '2017-06-30 17:41:19', '2017-06-30 17:41:21', 'system', '1');
INSERT INTO `module` VALUES ('115', '3502', 'legalchange', ' 枪支培训机构备案', '', '115', '\0', '\0', '', '', '
', '2017-06-30 18:00:19', '2017-06-30 18:00:21', 'system', '1');
INSERT INTO `module` VALUES ('117', '3502', 'statistics', '制证管理', '', '73', '\0', '\0', '', '', '
', '2017-06-30 18:00:19', '2017-06-30 18:00:21', 'system', '1');

-- ----------------------------
-- Table structure for operation
-- ----------------------------
DROP TABLE IF EXISTS `operation`;
CREATE TABLE `operation` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `native_code` int(11) NOT NULL,
  `code` varchar(20) NOT NULL,
  `name` varchar(20) NOT NULL,
  `module_id` int(11) NOT NULL,
  `active` bit(1) NOT NULL,
  `create_time` datetime NOT NULL,
  `update_time` datetime NOT NULL,
  `update_by` varchar(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_operation_module` (`module_id`),
  KEY `fk_operation_native` (`native_code`),
  CONSTRAINT `fk_operation_module` FOREIGN KEY (`module_id`) REFERENCES `module` (`id`),
  CONSTRAINT `fk_operation_native` FOREIGN KEY (`native_code`) REFERENCES `native` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=227 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of operation
-- ----------------------------
INSERT INTO `operation` VALUES ('1', '3502', 'read', '查看', '1', '
', '2017-02-28 22:54:18', '2017-02-28 22:54:20', 'system');
INSERT INTO `operation` VALUES ('2', '3502', 'read', '查看', '2', '
', '2017-03-01 13:01:19', '2017-03-01 13:01:22', 'system');
INSERT INTO `operation` VALUES ('3', '3502', 'read', '查看', '3', '
', '2017-03-01 13:01:45', '2017-03-01 13:01:48', 'system');
INSERT INTO `operation` VALUES ('4', '3502', 'read', '查看', '4', '
', '2017-03-01 13:02:14', '2017-03-01 13:02:16', 'system');
INSERT INTO `operation` VALUES ('5', '3502', 'read', '查看', '5', '
', '2017-03-01 13:02:49', '2017-03-01 13:02:53', 'system');
INSERT INTO `operation` VALUES ('8', '3502', 'save', '查看', '6', '
', '2017-03-01 21:21:21', '2017-03-01 21:21:23', 'system');
INSERT INTO `operation` VALUES ('22', '3502', 'read', '查看', '25', '
', '2017-02-28 22:54:18', '2017-02-28 22:54:20', 'system');
INSERT INTO `operation` VALUES ('23', '3502', 'read', '查看', '26', '
', '2017-03-01 13:01:19', '2017-03-01 13:01:22', 'system');
INSERT INTO `operation` VALUES ('24', '3502', 'read', '查看', '27', '
', '2017-03-01 13:01:45', '2017-03-01 13:01:48', 'system');
INSERT INTO `operation` VALUES ('25', '3502', 'read', '查看', '28', '
', '2017-03-01 13:02:14', '2017-03-01 13:02:16', 'system');
INSERT INTO `operation` VALUES ('26', '3502', 'read', '购买', '29', '
', '2017-03-01 13:02:49', '2017-03-01 13:02:53', 'system');
INSERT INTO `operation` VALUES ('28', '3502', 'read', '查看', '30', '
', '2017-03-01 21:20:46', '2017-03-01 21:20:48', 'system');
INSERT INTO `operation` VALUES ('29', '3502', 'save', '新增', '30', '
', '2017-03-01 21:21:21', '2017-03-01 21:21:23', 'system');
INSERT INTO `operation` VALUES ('30', '3502', 'update', '修改', '30', '
', '2017-03-01 21:21:42', '2017-03-01 21:21:44', 'system');
INSERT INTO `operation` VALUES ('31', '3502', 'delete', '离职', '30', '
', '2017-03-01 21:22:03', '2017-03-01 21:22:10', 'system');
INSERT INTO `operation` VALUES ('32', '3502', 'import', '导入', '30', '
', '2017-03-01 21:22:35', '2017-03-01 21:22:38', 'system');
INSERT INTO `operation` VALUES ('33', '3502', 'read', '查看', '31', '
', '2017-03-01 21:23:05', '2017-03-01 21:23:08', 'system');
INSERT INTO `operation` VALUES ('34', '3502', 'save', '新增', '31', '
', '2017-03-01 21:23:30', '2017-03-01 21:23:35', 'system');
INSERT INTO `operation` VALUES ('35', '3502', 'update', '修改', '31', '
', '2017-03-01 21:23:51', '2017-03-01 21:23:54', 'system');
INSERT INTO `operation` VALUES ('36', '3502', 'delete', '删除', '31', '
', '2017-03-01 21:24:14', '2017-03-01 21:24:19', 'system');
INSERT INTO `operation` VALUES ('37', '3502', 'read', '查看', '32', '
', '2017-03-01 21:24:40', '2017-03-01 21:24:42', 'system');
INSERT INTO `operation` VALUES ('38', '3502', 'save', '新增', '32', '
', '2017-03-01 21:25:13', '2017-03-01 21:25:16', 'system');
INSERT INTO `operation` VALUES ('39', '3502', 'update', '修改', '32', '
', '2017-03-01 21:25:34', '2017-03-01 21:25:36', 'system');
INSERT INTO `operation` VALUES ('40', '3502', 'delete', '删除', '32', '
', '2017-03-01 21:25:53', '2017-03-01 21:25:55', 'system');
INSERT INTO `operation` VALUES ('42', '3502', 'update', '修改', '33', '
', '2017-03-01 21:26:47', '2017-03-01 21:26:49', 'system');
INSERT INTO `operation` VALUES ('43', '3502', 'end', '结束', '4', '
', '2017-06-29 23:17:47', '2017-06-29 23:17:50', 'system');
INSERT INTO `operation` VALUES ('53', '3502', 'create', '创建', '4', '
', '2017-06-29 23:23:20', '2017-06-29 23:23:22', 'system');
INSERT INTO `operation` VALUES ('54', '3502', 'approval', '审批', '5', '
', '2017-06-29 23:30:20', '2017-06-29 23:30:23', 'system');
INSERT INTO `operation` VALUES ('56', '3502', 'add', '新增', '64', '
', '2017-06-30 17:09:27', '2017-06-30 17:09:29', 'system');
INSERT INTO `operation` VALUES ('59', '3502', 'view', '查看', '64', '
', '2017-06-30 17:09:49', '2017-06-30 17:09:51', 'system');
INSERT INTO `operation` VALUES ('60', '3502', 'del', '删除', '64', '
', '2017-06-30 17:14:15', '2017-06-30 17:14:18', 'system');
INSERT INTO `operation` VALUES ('61', '3502', 'edit', '修改', '64', '
', '2017-06-30 17:14:38', '2017-06-30 17:14:40', 'system');
INSERT INTO `operation` VALUES ('62', '3502', 'view', '查看', '65', '
', '2017-06-30 17:41:51', '2017-06-30 17:41:54', 'system');
INSERT INTO `operation` VALUES ('63', '3502', 'add', '新增', '65', '
', '2017-06-30 17:42:37', '2017-06-30 17:42:39', 'system');
INSERT INTO `operation` VALUES ('64', '3502', 'edit', '修改', '65', '
', '2017-06-30 17:42:37', '2017-06-30 17:42:39', 'system');
INSERT INTO `operation` VALUES ('65', '3502', 'del', '删除', '65', '
', '2017-06-30 17:50:11', '2017-06-30 17:50:12', 'system');
INSERT INTO `operation` VALUES ('66', '3502', 'view', '查看', '114', '
', '2017-06-30 17:53:18', '2017-06-30 17:53:20', 'system');
INSERT INTO `operation` VALUES ('67', '3502', 'view', '查看', '67', '
', '2017-06-30 17:53:18', '2017-06-30 17:53:20', 'system');
INSERT INTO `operation` VALUES ('68', '3502', 'view', '查看', '68', '
', '2017-06-30 17:53:18', '2017-06-30 17:53:20', 'system');
INSERT INTO `operation` VALUES ('69', '3502', 'view', '查看', '69', '
', '2017-06-30 17:53:18', '2017-06-30 17:53:20', 'system');
INSERT INTO `operation` VALUES ('70', '3502', 'view', '查看', '70', '
', '2017-06-30 17:53:18', '2017-06-30 17:53:20', 'system');
INSERT INTO `operation` VALUES ('71', '3502', 'view', '查看', '71', '
', '2017-06-30 17:53:18', '2017-06-30 17:53:20', 'system');
INSERT INTO `operation` VALUES ('72', '3502', 'view', '查看', '72', '
', '2017-06-30 17:53:18', '2017-06-30 17:53:20', 'system');
INSERT INTO `operation` VALUES ('73', '3502', 'view', '查看', '73', '
', '2017-06-30 17:53:18', '2017-06-30 17:53:20', 'system');
INSERT INTO `operation` VALUES ('74', '3502', 'view', '查看', '74', '
', '2017-06-30 17:53:18', '2017-06-30 17:53:20', 'system');
INSERT INTO `operation` VALUES ('75', '3502', 'view', '查看', '75', '
', '2017-06-30 17:53:18', '2017-06-30 17:53:20', 'system');
INSERT INTO `operation` VALUES ('76', '3502', 'add', '新增', '75', '
', '2017-06-30 17:53:18', '2017-06-30 17:53:20', 'system');
INSERT INTO `operation` VALUES ('77', '3502', 'edit', '修改', '75', '
', '2017-06-30 17:53:18', '2017-06-30 17:53:20', 'system');
INSERT INTO `operation` VALUES ('78', '3502', 'del', '删除', '75', '
', '2017-06-30 17:53:18', '2017-06-30 17:53:20', 'system');
INSERT INTO `operation` VALUES ('79', '3502', 'copy', '复制', '75', '
', '2017-06-30 17:53:18', '2017-06-30 17:53:20', 'system');
INSERT INTO `operation` VALUES ('80', '3502', 'view', '查看', '76', '
', '2017-06-30 17:53:18', '2017-06-30 17:53:20', 'system');
INSERT INTO `operation` VALUES ('81', '3502', 'add', '新增', '76', '
', '2017-06-30 17:53:18', '2017-06-30 17:53:20', 'system');
INSERT INTO `operation` VALUES ('82', '3502', 'edit', '修改', '76', '
', '2017-06-30 17:53:18', '2017-06-30 17:53:20', 'system');
INSERT INTO `operation` VALUES ('83', '3502', 'reset', '重置密码', '76', '
', '2017-06-30 17:53:18', '2017-06-30 17:53:20', 'system');
INSERT INTO `operation` VALUES ('84', '3502', 'del', '删除', '76', '
', '2017-06-30 17:53:18', '2017-06-30 17:53:20', 'system');
INSERT INTO `operation` VALUES ('85', '3502', 'view', '查看', '77', '
', '2017-06-30 17:53:18', '2017-06-30 17:53:20', 'system');
INSERT INTO `operation` VALUES ('86', '3502', 'add', '新增', '77', '
', '2017-06-30 17:53:18', '2017-06-30 17:53:20', 'system');
INSERT INTO `operation` VALUES ('87', '3502', 'edit', '修改', '77', '
', '2017-06-30 17:53:18', '2017-06-30 17:53:20', 'system');
INSERT INTO `operation` VALUES ('88', '3502', 'copy', '复制', '77', '
', '2017-06-30 17:53:18', '2017-06-30 17:53:20', 'system');
INSERT INTO `operation` VALUES ('89', '3502', 'del', '删除', '77', '
', '2017-06-30 17:53:18', '2017-06-30 17:53:20', 'system');
INSERT INTO `operation` VALUES ('90', '3502', 'view', '查看', '78', '
', '2017-06-30 17:53:18', '2017-06-30 17:53:20', 'system');
INSERT INTO `operation` VALUES ('91', '3502', 'edit', '修改', '78', '
', '2017-06-30 17:53:18', '2017-06-30 17:53:20', 'system');
INSERT INTO `operation` VALUES ('92', '3502', 'del', '删除', '78', '
', '2017-06-30 17:53:18', '2017-06-30 17:53:20', 'system');
INSERT INTO `operation` VALUES ('93', '3502', 'reset', '重置密码', '78', '
', '2017-06-30 17:53:18', '2017-06-30 17:53:20', 'system');
INSERT INTO `operation` VALUES ('94', '3502', 'import', '导入', '78', '
', '2017-06-30 17:53:18', '2017-06-30 17:53:20', 'system');
INSERT INTO `operation` VALUES ('95', '3502', 'out', '导出', '78', '
', '2017-06-30 17:53:18', '2017-06-30 17:53:20', 'system');
INSERT INTO `operation` VALUES ('96', '3502', 'add', '新增', '78', '
', '2017-06-30 17:53:18', '2017-06-30 17:53:20', 'system');
INSERT INTO `operation` VALUES ('97', '3502', 'view', '查看', '80', '
', '2017-07-01 07:07:34', '2017-07-01 07:07:36', 'system');
INSERT INTO `operation` VALUES ('98', '3502', 'view', '查询', '81', '
', '2017-08-13 14:27:27', '2017-08-13 14:27:29', 'system');
INSERT INTO `operation` VALUES ('99', '3502', 'add', '新增', '81', '
', '2017-08-13 14:27:27', '2017-08-13 14:27:29', 'system');
INSERT INTO `operation` VALUES ('100', '3502', 'edit', '修改', '81', '
', '2017-08-13 14:27:27', '2017-08-13 14:27:29', 'system');
INSERT INTO `operation` VALUES ('101', '3502', 'view', '查询', '82', '
', '2017-08-13 14:27:27', '2017-08-13 14:27:29', 'system');
INSERT INTO `operation` VALUES ('102', '3502', 'add', '新增', '82', '
', '2017-08-13 14:27:27', '2017-08-13 14:27:29', 'system');
INSERT INTO `operation` VALUES ('103', '3502', 'edit', '修改', '82', '
', '2017-08-13 14:27:27', '2017-08-13 14:27:29', 'system');
INSERT INTO `operation` VALUES ('104', '3502', 'del', '删除', '81', '
', '2017-08-13 14:27:27', '2017-08-13 14:27:29', 'system');
INSERT INTO `operation` VALUES ('105', '3502', 'del', '删除', '82', '
', '2017-08-13 14:27:27', '2017-08-13 14:27:29', 'system');
INSERT INTO `operation` VALUES ('106', '3502', 'out', '导出', '30', '
', '2017-03-01 21:22:35', '2017-03-01 21:22:38', 'system');
INSERT INTO `operation` VALUES ('107', '3502', 'add', '新增', '83', '
', '2017-03-01 21:22:35', '2017-03-01 21:22:38', 'system');
INSERT INTO `operation` VALUES ('108', '3502', 'edit', '修改', '83', '
', '2017-03-01 21:22:35', '2017-03-01 21:22:38', 'system');
INSERT INTO `operation` VALUES ('109', '3502', 'view', '查看', '83', '
', '2017-03-01 21:22:35', '2017-03-01 21:22:38', 'system');
INSERT INTO `operation` VALUES ('110', '3502', 'del', '删除', '83', '
', '2017-03-01 21:22:35', '2017-03-01 21:22:38', 'system');
INSERT INTO `operation` VALUES ('111', '3502', 'add', '新增', '84', '
', '2017-03-01 21:22:35', '2017-03-01 21:22:38', 'system');
INSERT INTO `operation` VALUES ('112', '3502', 'view', '查看', '84', '
', '2017-03-01 21:22:35', '2017-03-01 21:22:38', 'system');
INSERT INTO `operation` VALUES ('113', '3502', 'add', '新增', '85', '
', '2017-03-01 21:22:35', '2017-03-01 21:22:38', 'system');
INSERT INTO `operation` VALUES ('114', '3502', 'xq', '续签', '85', '
', '2017-03-01 21:22:35', '2017-03-01 21:22:38', 'system');
INSERT INTO `operation` VALUES ('115', '3502', 'bg', '变更', '85', '
', '2017-03-01 21:22:35', '2017-03-01 21:22:38', 'system');
INSERT INTO `operation` VALUES ('116', '3502', 'jc', '解除', '85', '
', '2017-03-01 21:22:35', '2017-03-01 21:22:38', 'system');
INSERT INTO `operation` VALUES ('117', '3502', 'add', '新增', '86', '
', '2017-03-01 21:22:35', '2017-03-01 21:22:38', 'system');
INSERT INTO `operation` VALUES ('118', '3502', 'xq', '续签', '86', '
', '2017-03-01 21:22:35', '2017-03-01 21:22:38', 'system');
INSERT INTO `operation` VALUES ('119', '3502', 'bg', '变更', '86', '
', '2017-03-01 21:22:35', '2017-03-01 21:22:38', 'system');
INSERT INTO `operation` VALUES ('120', '3502', 'jc', '解除', '86', '
', '2017-03-01 21:22:35', '2017-03-01 21:22:38', 'system');
INSERT INTO `operation` VALUES ('121', '3502', 'view', '查看', '85', '
', '2017-03-01 21:22:35', '2017-03-01 21:22:38', 'system');
INSERT INTO `operation` VALUES ('122', '3502', 'view', '查看', '86', '
', '2017-03-01 21:22:35', '2017-03-01 21:22:38', 'system');
INSERT INTO `operation` VALUES ('123', '3502', 'read', '查看', '87', '
', '2017-03-01 21:24:40', '2017-03-01 21:24:42', 'system');
INSERT INTO `operation` VALUES ('124', '3502', 'save', '新增', '87', '
', '2017-03-01 21:25:13', '2017-03-01 21:25:16', 'system');
INSERT INTO `operation` VALUES ('125', '3502', 'update', '修改', '87', '
', '2017-03-01 21:25:34', '2017-03-01 21:25:36', 'system');
INSERT INTO `operation` VALUES ('126', '3502', 'delete', '删除', '87', '
', '2017-03-01 21:25:53', '2017-03-01 21:25:55', 'system');
INSERT INTO `operation` VALUES ('127', '3502', 'read', '查看', '88', '
', '2017-03-01 21:24:40', '2017-03-01 21:24:42', 'system');
INSERT INTO `operation` VALUES ('128', '3502', 'save', '新增', '88', '
', '2017-03-01 21:25:13', '2017-03-01 21:25:16', 'system');
INSERT INTO `operation` VALUES ('129', '3502', 'update', '修改', '88', '
', '2017-03-01 21:25:34', '2017-03-01 21:25:36', 'system');
INSERT INTO `operation` VALUES ('130', '3502', 'delete', '删除', '88', '
', '2017-03-01 21:25:53', '2017-03-01 21:25:55', 'system');
INSERT INTO `operation` VALUES ('131', '3502', 'read', '查看', '89', '
', '2017-03-01 21:24:40', '2017-03-01 21:24:42', 'system');
INSERT INTO `operation` VALUES ('132', '3502', 'save', '新增', '89', '
', '2017-03-01 21:25:13', '2017-03-01 21:25:16', 'system');
INSERT INTO `operation` VALUES ('133', '3502', 'update', '修改', '89', '
', '2017-03-01 21:25:34', '2017-03-01 21:25:36', 'system');
INSERT INTO `operation` VALUES ('134', '3502', 'delete', '删除', '89', '
', '2017-03-01 21:25:53', '2017-03-01 21:25:55', 'system');
INSERT INTO `operation` VALUES ('135', '3502', 'read', '查看', '90', '
', '2017-03-01 21:24:40', '2017-03-01 21:24:42', 'system');
INSERT INTO `operation` VALUES ('136', '3502', 'save', '新增', '90', '
', '2017-03-01 21:25:13', '2017-03-01 21:25:16', 'system');
INSERT INTO `operation` VALUES ('137', '3502', 'update', '修改', '90', '
', '2017-03-01 21:25:34', '2017-03-01 21:25:36', 'system');
INSERT INTO `operation` VALUES ('138', '3502', 'delete', '删除', '90', '
', '2017-03-01 21:25:53', '2017-03-01 21:25:55', 'system');
INSERT INTO `operation` VALUES ('139', '3502', 'read', '查看', '91', '
', '2017-03-01 21:24:40', '2017-03-01 21:24:42', 'system');
INSERT INTO `operation` VALUES ('140', '3502', 'save', '新增', '91', '
', '2017-03-01 21:25:13', '2017-03-01 21:25:16', 'system');
INSERT INTO `operation` VALUES ('141', '3502', 'update', '修改', '91', '
', '2017-03-01 21:25:34', '2017-03-01 21:25:36', 'system');
INSERT INTO `operation` VALUES ('142', '3502', 'delete', '删除', '91', '
', '2017-03-01 21:25:53', '2017-03-01 21:25:55', 'system');
INSERT INTO `operation` VALUES ('143', '3502', 'read', '查看', '92', '
', '2017-03-01 21:24:40', '2017-03-01 21:24:42', 'system');
INSERT INTO `operation` VALUES ('144', '3502', 'save', '新增', '92', '
', '2017-03-01 21:25:13', '2017-03-01 21:25:16', 'system');
INSERT INTO `operation` VALUES ('145', '3502', 'update', '修改', '92', '
', '2017-03-01 21:25:34', '2017-03-01 21:25:36', 'system');
INSERT INTO `operation` VALUES ('146', '3502', 'delete', '删除', '92', '
', '2017-03-01 21:25:53', '2017-03-01 21:25:55', 'system');
INSERT INTO `operation` VALUES ('147', '3502', 'read', '查看', '93', '
', '2017-03-01 21:24:40', '2017-03-01 21:24:42', 'system');
INSERT INTO `operation` VALUES ('149', '3502', 'save', '购买', '94', '
', '2017-03-01 21:25:13', '2017-03-01 21:25:16', 'system');
INSERT INTO `operation` VALUES ('150', '3502', 'read', '查看', '95', '
', '2017-03-01 21:24:40', '2017-03-01 21:24:42', 'system');
INSERT INTO `operation` VALUES ('151', '3502', 'save', '新增', '95', '
', '2017-03-01 21:25:13', '2017-03-01 21:25:16', 'system');
INSERT INTO `operation` VALUES ('152', '3502', 'update', '修改', '95', '
', '2017-03-01 21:25:34', '2017-03-01 21:25:36', 'system');
INSERT INTO `operation` VALUES ('153', '3502', 'delete', '删除', '95', '
', '2017-03-01 21:25:53', '2017-03-01 21:25:55', 'system');
INSERT INTO `operation` VALUES ('154', '3502', 'delete', '删除', '96', '
', '2017-03-01 21:25:53', '2017-03-01 21:25:55', 'system');
INSERT INTO `operation` VALUES ('155', '3502', 'save', '新增', '96', '
', '2017-03-01 21:25:13', '2017-03-01 21:25:16', 'system');
INSERT INTO `operation` VALUES ('156', '3502', 'update', '修改', '96', '
', '2017-03-01 21:25:34', '2017-03-01 21:25:36', 'system');
INSERT INTO `operation` VALUES ('157', '3502', 'read', '查看', '96', '
', '2017-03-01 21:24:40', '2017-03-01 21:24:42', 'system');
INSERT INTO `operation` VALUES ('158', '3502', 'read', '查看', '97', '
', '2017-03-01 21:24:40', '2017-03-01 21:24:42', 'system');
INSERT INTO `operation` VALUES ('159', '3502', 'save', '新增', '97', '
', '2017-03-01 21:25:13', '2017-03-01 21:25:16', 'system');
INSERT INTO `operation` VALUES ('160', '3502', 'update', '修改', '97', '
', '2017-03-01 21:25:34', '2017-03-01 21:25:36', 'system');
INSERT INTO `operation` VALUES ('161', '3502', 'delete', '删除', '97', '
', '2017-03-01 21:25:53', '2017-03-01 21:25:55', 'system');
INSERT INTO `operation` VALUES ('162', '3502', 'read', '申报', '98', '
', '2017-03-01 21:24:40', '2017-03-01 21:24:42', 'system');
INSERT INTO `operation` VALUES ('166', '3502', 'read', '申报', '99', '
', '2017-03-01 21:24:40', '2017-03-01 21:24:42', 'system');
INSERT INTO `operation` VALUES ('170', '3502', 'read', '申报', '100', '
', '2017-03-01 21:24:40', '2017-03-01 21:24:42', 'system');
INSERT INTO `operation` VALUES ('177', '3502', 'read', '申报', '101', '
', '2017-03-01 21:24:40', '2017-03-01 21:24:42', 'system');
INSERT INTO `operation` VALUES ('178', '3502', 'read', '申报', '102', '
', '2017-03-01 21:24:40', '2017-03-01 21:24:42', 'system');
INSERT INTO `operation` VALUES ('182', '3502', 'read', '查看', '103', '
', '2017-03-01 21:24:40', '2017-03-01 21:24:42', 'system');
INSERT INTO `operation` VALUES ('183', '3502', 'delete', '重命名', '32', '
', '2017-03-01 21:25:53', '2017-03-01 21:25:55', 'system');
INSERT INTO `operation` VALUES ('184', '3502', 'jj', '查看', '104', '
', '2017-03-01 21:22:35', '2017-03-01 21:22:38', 'system');
INSERT INTO `operation` VALUES ('185', '3502', 'save', '新增', '105', '
', '2017-03-01 21:25:13', '2017-03-01 21:25:16', 'system');
INSERT INTO `operation` VALUES ('186', '3502', 'update', '修改', '105', '
', '2017-03-01 21:25:34', '2017-03-01 21:25:36', 'system');
INSERT INTO `operation` VALUES ('187', '3502', 'delete', '删除', '105', '
', '2017-03-01 21:25:53', '2017-03-01 21:25:55', 'system');
INSERT INTO `operation` VALUES ('188', '3502', 'read', '查看', '105', '
', '2017-03-01 21:24:40', '2017-03-01 21:24:42', 'system');
INSERT INTO `operation` VALUES ('189', '3502', 'save', '新增', '106', '
', '2017-03-01 21:25:13', '2017-03-01 21:25:16', 'system');
INSERT INTO `operation` VALUES ('190', '3502', 'update', '修改', '106', '
', '2017-03-01 21:25:34', '2017-03-01 21:25:36', 'system');
INSERT INTO `operation` VALUES ('191', '3502', 'delete', '删除', '106', '
', '2017-03-01 21:25:53', '2017-03-01 21:25:55', 'system');
INSERT INTO `operation` VALUES ('192', '3502', 'read', '查看', '106', '
', '2017-03-01 21:24:40', '2017-03-01 21:24:42', 'system');
INSERT INTO `operation` VALUES ('193', '3502', 'save', '新增', '107', '
', '2017-03-01 21:25:13', '2017-03-01 21:25:16', 'system');
INSERT INTO `operation` VALUES ('194', '3502', 'update', '修改', '107', '
', '2017-03-01 21:25:34', '2017-03-01 21:25:36', 'system');
INSERT INTO `operation` VALUES ('195', '3502', 'delete', '删除', '107', '
', '2017-03-01 21:25:53', '2017-03-01 21:25:55', 'system');
INSERT INTO `operation` VALUES ('196', '3502', 'read', '查看', '107', '
', '2017-03-01 21:24:40', '2017-03-01 21:24:42', 'system');
INSERT INTO `operation` VALUES ('197', '3502', 'edit', '维护', '107', '
', '2017-03-01 21:24:40', '2017-03-01 21:24:42', 'system');
INSERT INTO `operation` VALUES ('198', '3502', 'log', '日志', '95', '
', '2017-03-01 21:25:53', '2017-03-01 21:25:55', 'system');
INSERT INTO `operation` VALUES ('199', '3502', 'gh', '归还', '95', '
', '2017-03-01 21:25:53', '2017-03-01 21:25:55', 'system');
INSERT INTO `operation` VALUES ('200', '3502', 'pc', '派出', '95', '
', '2017-03-01 21:25:53', '2017-03-01 21:25:55', 'system');
INSERT INTO `operation` VALUES ('201', '3502', 'zx', '注销', '96', '
', '2017-03-01 21:24:40', '2017-03-01 21:24:42', 'system');
INSERT INTO `operation` VALUES ('202', '3502', 'ly', '领用', '96', '
', '2017-03-01 21:24:40', '2017-03-01 21:24:42', 'system');
INSERT INTO `operation` VALUES ('203', '3502', 'gh', '归还', '96', '
', '2017-03-01 21:24:40', '2017-03-01 21:24:42', 'system');
INSERT INTO `operation` VALUES ('204', '3502', 'log', '日志', '96', '
', '2017-03-01 21:24:40', '2017-03-01 21:24:42', 'system');
INSERT INTO `operation` VALUES ('205', '3502', 'ys', '遗失', '96', '
', '2017-03-01 21:24:40', '2017-03-01 21:24:42', 'system');
INSERT INTO `operation` VALUES ('206', '3502', 'del', '删除', '86', '
', '2017-03-01 21:22:35', '2017-03-01 21:22:38', 'system');
INSERT INTO `operation` VALUES ('207', '3502', 'import', '导入', '75', '
', '2017-06-30 17:53:18', '2017-06-30 17:53:20', 'system');
INSERT INTO `operation` VALUES ('208', '3502', 'out', '导出', '75', '
', '2017-06-30 17:53:18', '2017-06-30 17:53:20', 'system');
INSERT INTO `operation` VALUES ('209', '3502', 'import', '导入', '65', '
', '2017-06-30 17:53:18', '2017-06-30 17:53:20', 'system');
INSERT INTO `operation` VALUES ('210', '3502', 'out', '导出', '65', '
', '2017-06-30 17:53:18', '2017-06-30 17:53:20', 'system');
INSERT INTO `operation` VALUES ('211', '3502', 'import', '导入', '5', '
', '2017-06-29 23:30:20', '2017-06-29 23:30:23', 'system');
INSERT INTO `operation` VALUES ('212', '3502', 'out', '导出', '5', '
', '2017-06-29 23:30:20', '2017-06-29 23:30:23', 'system');
INSERT INTO `operation` VALUES ('213', '3502', 'examinationarrange', '培训考试', '109', '
', '2017-08-13 14:27:27', '2017-08-13 14:27:29', 'system');
INSERT INTO `operation` VALUES ('214', '3502', 'view', '查看', '110', '
', '2017-08-13 14:27:27', '2017-08-13 14:27:29', 'system');
INSERT INTO `operation` VALUES ('215', '3502', 'view', '查看', '111', '
', '2017-08-13 14:27:27', '2017-08-13 14:27:29', 'system');
INSERT INTO `operation` VALUES ('216', '3502', 'view', '查看', '112', '
', '2017-08-13 14:27:27', '2017-08-13 14:27:29', 'system');
INSERT INTO `operation` VALUES ('217', '3502', 'view', '数据看板', '113', '
', '2017-08-13 14:27:27', '2017-08-13 14:27:29', 'system');
INSERT INTO `operation` VALUES ('218', '3502', 'view', '许可备案数据统计', '113', '
', '2017-08-13 14:27:27', '2017-08-13 14:27:29', 'system');
INSERT INTO `operation` VALUES ('219', '3502', 'view', '保安服务公司数据统计', '113', '
', '2017-08-13 14:27:27', '2017-08-13 14:27:29', 'system');
INSERT INTO `operation` VALUES ('220', '3502', 'view', '保安员数据统计', '113', '
', '2017-08-13 14:27:27', '2017-08-13 14:27:29', 'system');
INSERT INTO `operation` VALUES ('221', '3502', 'view', '保安员资格证考试报名数据统计', '113', '
', '2017-08-13 14:27:27', '2017-08-13 14:27:29', 'system');
INSERT INTO `operation` VALUES ('222', '3502', 'view', '监督检查（年度报告）', '113', '
', '2017-08-13 14:27:27', '2017-08-13 14:27:29', 'system');
INSERT INTO `operation` VALUES ('223', '3502', 'view', '查看', '115', '
', '2017-06-30 17:53:18', '2017-06-30 17:53:20', 'system');
INSERT INTO `operation` VALUES ('224', '3502', 'view', '保安服务许可证', '117', '
', '2017-06-30 17:53:18', '2017-06-30 17:53:20', 'system');
INSERT INTO `operation` VALUES ('225', '3502', 'view', '保安培训单位许可证', '117', '
', '2017-06-30 17:53:18', '2017-06-30 17:53:20', 'system');
INSERT INTO `operation` VALUES ('226', '3502', 'view', '保安员资格证', '117', '
', '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);



-- 编码表
DROP TABLE IF EXISTS `sys_code`;
CREATE TABLE `sys_code` (
  `uuid` varchar(255) NOT NULL,
  `code_desc` varchar(255) DEFAULT NULL,
  `code_id` varchar(255) DEFAULT NULL,
  `code_name` varchar(255) DEFAULT NULL,
  `code_text` varchar(255) DEFAULT NULL,
  `code_value` varchar(255) DEFAULT NULL,
  `is_valid` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of sys_code
-- ----------------------------
INSERT INTO `sys_code` VALUES ('1', '6', null, '自行招用保安员单位备案', 'sb_crosscompany', '006', null);
INSERT INTO `sys_code` VALUES ('2', '8', null, '保安服务公司年度报告备案', '1', '008', null);
INSERT INTO `sys_code` VALUES ('3', '7', null, '保安服务（培训）许可证项目变更', 'sb_legalchange', '007', null);
INSERT INTO `sys_code` VALUES ('4', '1', '', '保安服务公司许可证', 'sb_sponsorlicense', '001', '');
INSERT INTO `sys_code` VALUES ('5', '9', null, '枪支培训机构备案', null, '009', null);
INSERT INTO `sys_code` VALUES ('6', '5', null, '保安跨区域服务备案', 'sb_confesscompany', '005', null);
INSERT INTO `sys_code` VALUES ('7', '2', null, '保安培训单位许可证', 'sb_traincompanyapply', '002', null);
INSERT INTO `sys_code` VALUES ('8', '4', null, '保安服务公司设立分公司备案', 'sb_subsidiary', '003', null);
INSERT INTO `sys_code` VALUES ('9', '3', null, '保安员资格证考试报名', 'sb_personcertificate', '004', null);


 ALTER TABLE `config`
MODIFY COLUMN `value`  varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `key`;



 DROP TABLE IF EXISTS `userbusinesstype`;
CREATE TABLE `userbusinesstype` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `active` bit(1) NOT NULL COMMENT '是否有效',
  `create_time` datetime NOT NULL,
  `update_time` datetime NOT NULL,
  `update_by` varchar(50) NOT NULL,
  `businessType` varchar(10) DEFAULT NULL,
  `userId` int(11) DEFAULT NULL,
  `typeValue` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `UserBusinessTypeKey` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;



-- 560
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '560', '5', '212', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '560', '5', '211', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '560', '5', '54', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '560', '5', '5', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '560', '67', '67', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '560', '68', '68', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '560', '69', '69', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '560', '70', '70', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '560', '71', '71', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '560', '72', '72', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '560', '74', '74', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '560', '114', '66', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '560', '115', '223', '2');


-- 569
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '569', '5', '212', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '569', '5', '211', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '569', '5', '54', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '569', '5', '5', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '569', '67', '67', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '569', '68', '68', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '569', '69', '69', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '569', '70', '70', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '569', '71', '71', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '569', '72', '72', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '569', '74', '74', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '569', '114', '66', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '569', '115', '223', '2');


-- 574
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '574', '5', '212', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '574', '5', '211', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '574', '5', '54', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '574', '5', '5', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '574', '67', '67', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '574', '68', '68', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '574', '69', '69', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '574', '70', '70', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '574', '71', '71', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '574', '72', '72', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '574', '74', '74', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '574', '114', '66', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '574', '115', '223', '2');



-- 575
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '575', '5', '212', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '575', '5', '211', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '575', '5', '54', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '575', '5', '5', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '575', '67', '67', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '575', '68', '68', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '575', '69', '69', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '575', '70', '70', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '575', '71', '71', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '575', '72', '72', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '575', '74', '74', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '575', '114', '66', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '575', '115', '223', '2');



-- 563
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '563', '5', '212', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '563', '5', '211', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '563', '5', '54', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '563', '5', '5', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '563', '67', '67', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '563', '68', '68', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '563', '69', '69', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '563', '70', '70', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '563', '71', '71', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '563', '72', '72', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '563', '74', '74', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '563', '114', '66', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '563', '115', '223', '2');




-- 576
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '576', '5', '212', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '576', '5', '211', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '576', '5', '54', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '576', '5', '5', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '576', '67', '67', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '576', '68', '68', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '576', '69', '69', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '576', '70', '70', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '576', '71', '71', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '576', '72', '72', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '576', '74', '74', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '576', '114', '66', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '576', '115', '223', '2');




-- 564
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '564', '5', '212', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '564', '5', '211', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '564', '5', '54', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '564', '5', '5', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '564', '67', '67', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '564', '68', '68', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '564', '69', '69', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '564', '70', '70', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '564', '71', '71', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '564', '72', '72', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '564', '74', '74', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '564', '114', '66', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '564', '115', '223', '2');




-- 604
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '604', '5', '212', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '604', '5', '211', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '604', '5', '54', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '604', '5', '5', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '604', '67', '67', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '604', '68', '68', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '604', '69', '69', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '604', '70', '70', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '604', '71', '71', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '604', '72', '72', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '604', '74', '74', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '604', '114', '66', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '604', '115', '223', '2');





-- 1
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '1', '5', '212', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '1', '5', '211', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '1', '5', '54', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '1', '5', '5', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '1', '67', '67', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '1', '68', '68', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '1', '69', '69', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '1', '70', '70', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '1', '71', '71', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '1', '72', '72', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '1', '74', '74', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '1', '114', '66', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '1', '115', '223', '2');




-- 4
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '4', '5', '212', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '4', '5', '211', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '4', '5', '54', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '4', '5', '5', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '4', '67', '67', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '4', '68', '68', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '4', '69', '69', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '4', '70', '70', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '4', '71', '71', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '4', '72', '72', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '4', '74', '74', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '4', '114', '66', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '4', '115', '223', '2');



-- 156
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '156', '5', '212', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '156', '5', '211', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '156', '5', '54', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '156', '5', '5', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '156', '67', '67', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '156', '68', '68', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '156', '69', '69', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '156', '70', '70', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '156', '71', '71', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '156', '72', '72', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '156', '74', '74', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '156', '114', '66', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '156', '115', '223', '2');


-- 3
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '3', '5', '212', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '3', '5', '211', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '3', '5', '54', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '3', '5', '5', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '3', '67', '67', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '3', '68', '68', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '3', '69', '69', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '3', '70', '70', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '3', '71', '71', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '3','72', '72', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '3', '74', '74', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '3', '114', '66', '2');
INSERT INTO `permission` (`id`, `native_code`, `role_id`, `module_id`, `operation_id`, `roletype`) VALUES (null, '3502', '3', '115', '223', '2');