kmall-haikong/sql/init/sys_table.sql

/*
 Navicat Premium Data Transfer

 Source Server         : 海控测试库
 Source Server Type    : MySQL
 Source Server Version : 50651
 Source Host           : 14.29.226.8:3306
 Source Schema         : kmall-haikong

 Target Server Type    : MySQL
 Target Server Version : 50651
 File Encoding         : 65001

 Date: 14/12/2021 17:15:35
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for sys_biz_permission
-- ----------------------------
DROP TABLE IF EXISTS `sys_biz_permission`;
CREATE TABLE `sys_biz_permission`  (
  `permission_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `permission_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '权限名称',
  `permission_type` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '权限类别',
  `remark` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '备注',
  `create_user_id` varchar(22) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '创建者ID',
  `create_time` datetime(0) DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`permission_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '系统业务权限表' ROW_FORMAT = Compact;

-- ----------------------------
-- Records of sys_biz_permission
-- ----------------------------
INSERT INTO `sys_biz_permission` VALUES (7, '测试', '1', NULL, '1', '2020-10-10 10:36:23');

-- ----------------------------
-- Table structure for sys_config
-- ----------------------------
DROP TABLE IF EXISTS `sys_config`;
CREATE TABLE `sys_config`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `key` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT 'key',
  `value` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT 'value',
  `status` tinyint(4) DEFAULT 1 COMMENT '状态   0：隐藏   1：显示',
  `remark` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `key`(`key`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '系统配置信息表' ROW_FORMAT = Compact;

-- ----------------------------
-- Records of sys_config
-- ----------------------------
INSERT INTO `sys_config` VALUES (1, 'CLOUD_STORAGE_CONFIG_KEY', '{\"aliyunAccessKeyId\":\"\",\"aliyunAccessKeySecret\":\"\",\"aliyunBucketName\":\"\",\"aliyunDomain\":\"\",\"aliyunEndPoint\":\"\",\"aliyunPrefix\":\"\",\"qcloudBucketName\":\"\",\"qcloudDomain\":\"\",\"qcloudPrefix\":\"\",\"qcloudSecretId\":\"\",\"qcloudSecretKey\":\"\",\"qiniuAccessKey\":\"\",\"qiniuBucketName\":\"\",\"qiniuDomain\":\"http://7xqbwh.dl1.z0.glb.clouddn.com\",\"qiniuPrefix\":\"\",\"qiniuSecretKey\":\"\",\"type\":2}', 0, '云存储配置信息');
INSERT INTO `sys_config` VALUES (2, 'SMS_CONFIG_KEY', '{\"apiKey\":\"3084e52ffff6adb96a67995b43edfb93\",\"url\":\"https://sms.yunpian.com/v2/sms/single_send.json\"}', 0, '短信配置');
INSERT INTO `sys_config` VALUES (4, 'DIST_HIER_LVL', '3', 1, '分销商层级');
INSERT INTO `sys_config` VALUES (5, 'FACE_COLLECT_FREQUENCY_TIME', '0', 1, '海淘人像采集频率时间，单位（秒）');
INSERT INTO `sys_config` VALUES (6, 'IS_QUERY_CROSS_QUOTAL', '1', 1, '是否开启跨境额度查询 1：是；0：否');
INSERT INTO `sys_config` VALUES (7, 'HK_NOTICE_KEY', 'aD9MNIuAATSUazu64nBz', 1, '海控通知回调秘钥');
INSERT INTO `sys_config` VALUES (8, 'HK_NOTICE_NUM', '100', 1, '通知数据阀值');
INSERT INTO `sys_config` VALUES (9, 'HAIKONG_MEMBER_SCORE_LIMIT', '30', 1, '海控平台统一30积分1块钱');
INSERT INTO `sys_config` VALUES (10, 'HAIKONG_MEMBER_MAX_SCORE_RATIO', '0.5', 1, '最大抵扣比例（最多能抵扣订单金额的比例）');

-- ----------------------------
-- Table structure for sys_cus_nation_code
-- ----------------------------
DROP TABLE IF EXISTS `sys_cus_nation_code`;
CREATE TABLE `sys_cus_nation_code`  (
  `sn` varchar(22) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '内部编号',
  `code` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '代码',
  `name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '名称(简称)',
  `ename` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '英文名(简称)',
  `discounts_tax_type` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '优普税率类型',
  `remark` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '备注',
  `is_valid` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '是否有效,0:有效，1:无效',
  `creater_sn` varchar(22) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '创建人编号',
  `create_time` datetime(0) DEFAULT NULL COMMENT '创建时间,yyyy-MM-dd HH:mm:ss',
  `moder_sn` varchar(22) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '修改人编号',
  `mod_time` datetime(0) DEFAULT NULL COMMENT '修改时间,yyyy-MM-dd HH:mm:ss',
  `tstm` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '时间戳',
  PRIMARY KEY (`sn`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '国别地区代码' ROW_FORMAT = Compact;

-- ----------------------------
-- Records of sys_cus_nation_code
-- ----------------------------
INSERT INTO `sys_cus_nation_code` VALUES ('scnc233787704501527047', '412', '智利', 'Chile', NULL, NULL, NULL, '288', '2020-11-07 03:00:49', '288', '2020-11-07 03:00:49', '2020-11-07 03:00:48');
INSERT INTO `sys_cus_nation_code` VALUES ('scnc242553117871483795', '418', '多米尼加共和国', 'Dominican Republic', NULL, NULL, NULL, '288', '2020-11-07 02:49:47', '288', '2020-11-07 02:49:47', '2020-11-07 02:49:46');
INSERT INTO `sys_cus_nation_code` VALUES ('scnc450665502727868416', '116', '日本', 'Japan', 'L', '', '0', 'user989416973951827968', '2018-05-28 14:23:48', 'user989416973951827968', '2018-05-28 14:24:02', '2018-05-28 14:24:02');
INSERT INTO `sys_cus_nation_code` VALUES ('scnc450665638921113600', '143', '台澎金马关税区', 'Tan Wan', 'L', '', '0', 'user989416973951827968', '2018-05-28 14:24:21', 'user989416973951827968', '2018-08-27 09:04:51', '2018-08-27 09:04:51');
INSERT INTO `sys_cus_nation_code` VALUES ('scnc452078431869865984', '301', '比利时', 'Belgium', 'L', '', '0', 'user989416973951827968', '2018-06-01 11:58:17', 'user989416973951827968', '2018-06-01 11:58:17', '2018-06-01 11:58:17');
INSERT INTO `sys_cus_nation_code` VALUES ('scnc452079462473273344', '309', '荷兰', 'Nederlanden', 'L', '', '0', 'user989416973951827968', '2018-06-01 12:02:23', 'user989416973951827968', '2018-06-11 11:28:24', '2018-06-11 11:28:24');
INSERT INTO `sys_cus_nation_code` VALUES ('scnc452081428012208128', '501', '加拿大', 'Canada', 'L', '', '0', 'user989416973951827968', '2018-06-01 12:10:11', 'user989416973951827968', '2018-06-01 12:10:11', '2018-06-01 12:10:11');
INSERT INTO `sys_cus_nation_code` VALUES ('scnc455686918727933952', '306', '爱尔兰', 'Ireland', 'L', '', '0', 'user989416973951827968', '2018-06-11 10:57:07', 'user989416973951827968', '2018-06-11 10:57:07', '2018-06-11 10:57:07');
INSERT INTO `sys_cus_nation_code` VALUES ('scnc455687162773512192', '315', '奥地利', 'Austria', 'L', '', '0', 'user989416973951827968', '2018-06-11 10:58:05', 'user989416973951827968', '2018-06-11 10:58:05', '2018-06-11 10:58:05');
INSERT INTO `sys_cus_nation_code` VALUES ('scnc455687308949200896', '601', '澳大利亚', 'Australia', 'L', '', '0', 'user989416973951827968', '2018-06-11 10:58:40', 'user989416973951827968', '2018-06-11 10:58:40', '2018-06-11 10:58:40');
INSERT INTO `sys_cus_nation_code` VALUES ('scnc455687682464555008', '327', '波兰', 'Poland', 'L', '', '0', 'user989416973951827968', '2018-06-11 11:00:09', 'user989416973951827968', '2018-06-11 11:00:09', '2018-06-11 11:00:09');
INSERT INTO `sys_cus_nation_code` VALUES ('scnc455688225228464128', '129', '菲律宾', 'Philippines', 'L', '', '0', 'user989416973951827968', '2018-06-11 11:02:19', 'user989416973951827968', '2018-06-11 11:15:42', '2018-06-11 11:15:42');
INSERT INTO `sys_cus_nation_code` VALUES ('scnc455688466002485248', '133', '韩国', 'Korea', 'L', '', '0', 'user989416973951827968', '2018-06-11 11:03:16', 'user989416973951827968', '2018-06-11 11:03:16', '2018-06-11 11:03:16');
INSERT INTO `sys_cus_nation_code` VALUES ('scnc455688942076960768', '122', '马来西亚', 'Malaysia', 'L', '', '0', 'user989416973951827968', '2018-06-11 11:05:10', 'user989416973951827968', '2018-06-11 11:05:10', '2018-06-11 11:05:10');
INSERT INTO `sys_cus_nation_code` VALUES ('scnc455689275574460416', '231', '毛里求斯', 'Mauritius', 'L', '', '0', 'user989416973951827968', '2018-06-11 11:06:29', 'user989416973951827968', '2018-06-11 11:06:29', '2018-06-11 11:06:29');
INSERT INTO `sys_cus_nation_code` VALUES ('scnc455689694673510400', '232', '摩洛哥', 'Morocco', 'L', '', '0', 'user989416973951827968', '2018-06-11 11:08:09', 'user989416973951827968', '2018-06-11 11:08:09', '2018-06-11 11:08:09');
INSERT INTO `sys_cus_nation_code` VALUES ('scnc455689909660950528', '331', '瑞士', 'Switzerland', 'L', '', '0', 'user989416973951827968', '2018-06-11 11:09:00', 'user989416973951827968', '2018-06-11 11:09:00', '2018-06-11 11:09:00');
INSERT INTO `sys_cus_nation_code` VALUES ('scnc455690205359382528', '136', '泰国', 'Thailand', 'L', '', '0', 'user989416973951827968', '2018-06-11 11:10:11', 'user989416973951827968', '2018-06-11 11:10:11', '2018-06-11 11:10:11');
INSERT INTO `sys_cus_nation_code` VALUES ('scnc455690492560154624', '132', '新加坡', 'Singapore', 'L', '', '0', 'user989416973951827968', '2018-06-11 11:11:19', 'user989416973951827968', '2018-06-11 11:11:19', '2018-06-11 11:11:19');
INSERT INTO `sys_cus_nation_code` VALUES ('scnc455690655483699200', '609', '新西兰', 'Zealand', 'L', '', '0', 'user989416973951827968', '2018-06-11 11:11:58', 'user989416973951827968', '2018-06-11 11:11:58', '2018-06-11 11:11:58');
INSERT INTO `sys_cus_nation_code` VALUES ('scnc455690907406180352', '303', '英国', 'UK', 'L', '', '0', 'user989416973951827968', '2018-06-11 11:12:58', 'user989416973951827968', '2018-06-11 11:12:58', '2018-06-11 11:12:58');
INSERT INTO `sys_cus_nation_code` VALUES ('scnc455691132380258304', '141', '越南', 'Vietnam', 'L', '', '0', 'user989416973951827968', '2018-06-11 11:13:52', 'user989416973951827968', '2018-06-11 11:13:52', '2018-06-11 11:13:52');
INSERT INTO `sys_cus_nation_code` VALUES ('scnc455692253068926976', '111', '印度', 'India', 'L', '', '0', 'user989416973951827968', '2018-06-11 11:18:19', 'user989416973951827968', '2018-06-11 11:18:19', '2018-06-11 11:18:19');
INSERT INTO `sys_cus_nation_code` VALUES ('scnc455692442504667136', '112', '印度尼西亚', 'Indonesia', 'L', '', '0', 'user989416973951827968', '2018-06-11 11:19:04', 'user989416973951827968', '2018-06-11 11:19:04', '2018-06-11 11:19:04');
INSERT INTO `sys_cus_nation_code` VALUES ('scnc455693065404948480', '103', '孟加拉', 'Bangladesh', 'L', '', '0', 'user989416973951827968', '2018-06-11 11:21:33', 'user989416973951827968', '2018-06-11 11:21:33', '2018-06-11 11:21:33');
INSERT INTO `sys_cus_nation_code` VALUES ('scnc455693269839519744', '106', '缅甸', 'Myanmar', 'L', '', '0', 'user989416973951827968', '2018-06-11 11:22:21', 'user989416973951827968', '2018-06-11 11:22:21', '2018-06-11 11:22:21');
INSERT INTO `sys_cus_nation_code` VALUES ('scnc455693413003698176', '113', '伊朗', 'Iran', 'L', '', '0', 'user989416973951827968', '2018-06-11 11:22:56', 'user989416973951827968', '2018-06-11 11:22:56', '2018-06-11 11:22:56');
INSERT INTO `sys_cus_nation_code` VALUES ('scnc455693513650216960', '114', '伊拉克', 'Iraq', 'L', '', '0', 'user989416973951827968', '2018-06-11 11:23:20', 'user989416973951827968', '2018-06-11 11:23:20', '2018-06-11 11:23:20');
INSERT INTO `sys_cus_nation_code` VALUES ('scnc455693706449788928', '115', '以色列', 'Israel', 'L', '', '0', 'user989416973951827968', '2018-06-11 11:24:05', 'user989416973951827968', '2018-06-11 11:24:05', '2018-06-11 11:24:05');
INSERT INTO `sys_cus_nation_code` VALUES ('scnc455693819146543104', '121', '澳门', 'Macau', 'L', '', '0', 'user989416973951827968', '2018-06-11 11:24:32', 'user989416973951827968', '2018-06-11 11:24:32', '2018-06-11 11:24:32');
INSERT INTO `sys_cus_nation_code` VALUES ('scnc455694037493620736', '131', '沙特阿拉伯', 'Saudi Arabia', 'L', '', '0', 'user989416973951827968', '2018-06-11 11:25:24', 'user989416973951827968', '2018-06-11 11:25:24', '2018-06-11 11:25:24');
INSERT INTO `sys_cus_nation_code` VALUES ('scnc455694249264029696', '137', '土耳其', 'Turkey', 'L', '', '0', 'user989416973951827968', '2018-06-11 11:26:15', 'user989416973951827968', '2018-06-11 11:26:15', '2018-06-11 11:26:15');
INSERT INTO `sys_cus_nation_code` VALUES ('scnc455694454579404800', '302', '丹麦', 'Denmark', 'L', '', '0', 'user989416973951827968', '2018-06-11 11:27:04', 'user989416973951827968', '2018-06-11 11:27:04', '2018-06-11 11:27:04');
INSERT INTO `sys_cus_nation_code` VALUES ('scnc455694905408364544', '310', '希腊', 'Greece', 'L', '', '0', 'user989416973951827968', '2018-06-11 11:28:51', 'user989416973951827968', '2018-06-11 11:28:51', '2018-06-11 11:28:51');
INSERT INTO `sys_cus_nation_code` VALUES ('scnc455695531928330240', '311', '葡萄牙', 'Portugal', 'L', '', '0', 'user989416973951827968', '2018-06-11 11:31:21', 'user989416973951827968', '2018-06-11 11:31:21', '2018-06-11 11:31:21');
INSERT INTO `sys_cus_nation_code` VALUES ('scnc455695707380260864', '318', '芬兰', 'Finland', 'L', '', '0', 'user989416973951827968', '2018-06-11 11:32:03', 'user989416973951827968', '2018-06-11 11:32:03', '2018-06-11 11:32:03');
INSERT INTO `sys_cus_nation_code` VALUES ('scnc455695860761763840', '321', '匈牙利', 'Hungary', 'L', '', '0', 'user989416973951827968', '2018-06-11 11:32:39', 'user989416973951827968', '2018-06-11 11:32:39', '2018-06-11 11:32:39');
INSERT INTO `sys_cus_nation_code` VALUES ('scnc455696037203550208', '326', '挪威', 'Norway', 'L', '', '0', 'user989416973951827968', '2018-06-11 11:33:21', 'user989416973951827968', '2018-06-11 11:33:21', '2018-06-11 11:33:21');
INSERT INTO `sys_cus_nation_code` VALUES ('scnc455696206733123584', '330', '瑞典', 'Sweden', 'L', '', '0', 'user989416973951827968', '2018-06-11 11:34:02', 'user989416973951827968', '2018-06-11 11:34:02', '2018-06-11 11:34:02');
INSERT INTO `sys_cus_nation_code` VALUES ('scnc455696356926955520', '603', '斐济', 'Fiji', 'L', '', '0', 'user989416973951827968', '2018-06-11 11:34:37', 'user989416973951827968', '2018-06-11 11:34:37', '2018-06-11 11:34:37');
INSERT INTO `sys_cus_nation_code` VALUES ('scnc469086013614993408', '413', '哥伦比亚', 'Colombia', 'L', '', '0', 'user989416973951827968', '2018-07-18 10:20:20', 'user989416973951827968', '2018-07-18 10:20:20', '2018-07-18 10:20:20');
INSERT INTO `sys_cus_nation_code` VALUES ('scnc469088613341081600', '429', '墨西哥', '', 'L', '', '0', 'user989416973951827968', '2018-07-18 10:30:40', 'user989416973951827968', '2018-07-18 10:30:40', '2018-07-18 10:30:40');
INSERT INTO `sys_cus_nation_code` VALUES ('scnc469088771327930368', '244', '南非', '', 'L', '', '0', 'user989416973951827968', '2018-07-18 10:31:18', 'user989416973951827968', '2018-07-18 10:31:18', '2018-07-18 10:31:18');
INSERT INTO `sys_cus_nation_code` VALUES ('scnc586188575412465070', '435', '波多黎各', 'Puerto Rico', 'L', '', '0', '288', '2020-10-31 14:32:31', '288', '2020-10-31 14:33:06', '2020-10-31 14:33:06');
INSERT INTO `sys_cus_nation_code` VALUES ('scnc754832626722302289', '410', '巴西', 'Brazil', 'L', NULL, '0', '288', '2020-11-18 09:58:39', '288', '2020-11-18 09:58:39', '2020-11-18 09:58:39');
INSERT INTO `sys_cus_nation_code` VALUES ('scnc919865123396001792', '142', '中国', 'China', 'L', '1', '0', '1', '2017-10-16 17:58:30', 'user000000000000000001', '2018-05-08 15:33:44', '2018-05-08 15:33:42');
INSERT INTO `sys_cus_nation_code` VALUES ('scnc919880620414083072', '502', '美国', 'America', 'L', '1', '0', '1', '2017-10-16 19:00:05', '1', '2017-10-16 19:18:07', '2018-04-21 15:19:36');
INSERT INTO `sys_cus_nation_code` VALUES ('scnc984625783575187456', '101', '阿富汗', 'Afhanistan', 'L', '', '0', 'user000000000000000001', '2018-04-13 10:54:14', 'user000000000000000001', '2018-04-13 10:54:14', '2018-04-21 15:20:03');
INSERT INTO `sys_cus_nation_code` VALUES ('scnc984625908951322624', '102', '巴林', 'Bahrian', 'L', '', '0', 'user000000000000000001', '2018-04-13 10:54:44', 'user000000000000000001', '2018-04-13 10:54:44', '2018-04-21 15:20:03');
INSERT INTO `sys_cus_nation_code` VALUES ('scnc984626008213721088', '107', '柬埔寨', 'Cambodia', 'L', '', '0', 'user000000000000000001', '2018-04-13 10:55:08', 'user000000000000000001', '2018-04-13 10:55:08', '2018-04-21 15:20:03');
INSERT INTO `sys_cus_nation_code` VALUES ('scnc984626135577956352', '110', '中国香港', 'Hong Kong', 'L', '', '0', 'user000000000000000001', '2018-04-13 10:55:38', 'user000000000000000001', '2018-04-13 10:55:38', '2018-04-13 10:54:05');
INSERT INTO `sys_cus_nation_code` VALUES ('scnc988394073346945024', '304', '德国', 'Germany', 'L', '', '0', 'user000000000000000001', '2018-04-23 20:28:05', 'user000000000000000001', '2018-04-23 20:28:05', '2018-04-23 20:28:03');
INSERT INTO `sys_cus_nation_code` VALUES ('scnc999201726296231936', '305', '法国', 'France', 'L', '', '0', 'user989416973951827968', '2018-05-23 16:13:50', 'user989416973951827968', '2018-05-23 16:13:50', '2018-05-23 16:13:50');
INSERT INTO `sys_cus_nation_code` VALUES ('scnc999206510914965504', '307', '意大利', 'Italy', 'L', '', '0', 'user989416973951827968', '2018-05-23 16:32:51', 'user989416973951827968', '2018-05-23 16:32:51', '2018-05-23 16:32:51');
INSERT INTO `sys_cus_nation_code` VALUES ('scnc999207978254471168', '312', '西班牙', 'Spain', 'L', '', '0', 'user989416973951827968', '2018-05-23 16:38:41', 'user989416973951827968', '2018-05-23 16:39:18', '2018-05-23 16:39:18');

-- ----------------------------
-- Table structure for sys_cus_unit_code
-- ----------------------------
DROP TABLE IF EXISTS `sys_cus_unit_code`;
CREATE TABLE `sys_cus_unit_code`  (
  `sn` varchar(22) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '内部编号',
  `code` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '代码',
  `name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '名称',
  `remark` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '备注',
  `is_valid` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '是否有效,0:有效，1:无效',
  `creater_sn` varchar(22) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '创建人编号',
  `create_time` datetime(0) DEFAULT NULL COMMENT '创建时间,yyyy-MM-dd HH:mm:ss',
  `moder_sn` varchar(22) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '修改人编号',
  `mod_time` datetime(0) DEFAULT NULL COMMENT '修改时间,yyyy-MM-dd HH:mm:ss',
  `tstm` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '时间戳',
  PRIMARY KEY (`sn`) USING BTREE,
  INDEX `code_index`(`code`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '计量单位代码' ROW_FORMAT = Compact;

-- ----------------------------
-- Records of sys_cus_unit_code
-- ----------------------------
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564881741217792', '001', '台', NULL, '0', NULL, '2018-03-08 09:54:53', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564881791549440', '002', '座', NULL, '0', NULL, '2018-03-08 09:54:53', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564881825103872', '003', '辆', NULL, '0', NULL, '2018-03-08 09:54:53', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564881858658304', '004', '艘', NULL, '0', NULL, '2018-03-08 09:54:53', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564881896407040', '005', '架', NULL, '0', NULL, '2018-03-08 09:54:53', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564881921572864', '006', '套', NULL, '0', NULL, '2018-03-08 09:54:53', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564881963515904', '008', '只', NULL, '0', NULL, '2018-03-08 09:54:53', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564881988681728', '009', '头', NULL, '0', NULL, '2018-03-08 09:54:53', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564882009653248', '010', '张', NULL, '0', NULL, '2018-03-08 09:54:53', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564882030624768', '011', '件', NULL, '0', NULL, '2018-03-08 09:54:53', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564882047401984', '012', '支', NULL, '0', NULL, '2018-03-08 09:54:53', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564882072567808', '013', '枝', NULL, '0', NULL, '2018-03-08 09:54:53', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564882097733632', '014', '根', NULL, '0', NULL, '2018-03-08 09:54:53', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564882118705152', '015', '条', NULL, '0', NULL, '2018-03-08 09:54:53', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564882135482368', '016', '把', NULL, '0', NULL, '2018-03-08 09:54:53', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564882160648192', '017', '块', NULL, '0', NULL, '2018-03-08 09:54:53', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564882185814016', '018', '卷', NULL, '0', NULL, '2018-03-08 09:54:53', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564882202591232', '019', '副', NULL, '0', NULL, '2018-03-08 09:54:53', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564882219368448', '020', '片', NULL, '0', NULL, '2018-03-08 09:54:53', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564882244534272', '021', '组', NULL, '0', NULL, '2018-03-08 09:54:53', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564882265505792', '022', '份', NULL, '0', NULL, '2018-03-08 09:54:53', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564882286477312', '023', '幅', NULL, '0', NULL, '2018-03-08 09:54:53', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564882303254528', '025', '双', NULL, '0', NULL, '2018-03-08 09:54:53', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564882328420352', '026', '对', NULL, '0', NULL, '2018-03-08 09:54:53', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564882353586176', '027', '棵', NULL, '0', NULL, '2018-03-08 09:54:53', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564882374557696', '028', '株', NULL, '0', NULL, '2018-03-08 09:54:53', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564882391334912', '029', '井', NULL, '0', NULL, '2018-03-08 09:54:53', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564882420695040', '030', '米', NULL, '0', NULL, '2018-03-08 09:54:53', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564882445860864', '031', '盘', NULL, '0', NULL, '2018-03-08 09:54:53', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564882462638080', '032', '平方米', NULL, '0', NULL, '2018-03-08 09:54:53', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564882479415296', '033', '立方米', NULL, '0', NULL, '2018-03-08 09:54:53', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564882504581120', '034', '筒', NULL, '0', NULL, '2018-03-08 09:54:53', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564882525552640', '035', '千克', NULL, '0', NULL, '2018-03-08 09:54:53', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564882546524160', '036', '克', NULL, '0', NULL, '2018-03-08 09:54:53', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564882563301376', '037', '盆', NULL, '0', NULL, '2018-03-08 09:54:53', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564882588467200', '038', '万个', NULL, '0', NULL, '2018-03-08 09:54:53', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564882609438720', '039', '具', NULL, '0', NULL, '2018-03-08 09:54:53', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564882630410240', '040', '百副', NULL, '0', NULL, '2018-03-08 09:54:53', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564882647187456', '041', '百支', NULL, '0', NULL, '2018-03-08 09:54:53', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564882676547584', '042', '百把', NULL, '0', NULL, '2018-03-08 09:54:53', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564882701713408', '043', '百个', NULL, '0', NULL, '2018-03-08 09:54:53', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564882718490624', '044', '百片', NULL, '0', NULL, '2018-03-08 09:54:53', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564882739462144', '045', '刀', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564882764627968', '046', '疋', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564882789793792', '047', '公担', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564882806571008', '048', '扇', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564882827542528', '049', '百枝', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564882848514048', '050', '千只', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564882873679872', '051', '千块', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564882890457088', '052', '千盒', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564882907234304', '053', '千枝', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564882932400128', '054', '千个', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564882953371648', '055', '亿支', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564882974343168', '056', '亿个', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564882991120384', '057', '万套', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564883016286208', '058', '千张', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564883041452032', '059', '万张', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564883058229248', '060', '千伏安', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564883079200768', '061', '千瓦', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564883104366592', '062', '千瓦时', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564883133726720', '063', '千升', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564883158892544', '067', '英尺', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564883175669760', '070', '吨', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564883205029888', '071', '长吨', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564883230195712', '072', '短吨', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564883251167232', '073', '司马担', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564883272138752', '074', '司马斤', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564883301498880', '075', '斤', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564883326664704', '076', '磅', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564883343441920', '077', '担', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564883364413440', '078', '英担', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564883389579264', '079', '短担', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564883414745088', '080', '两', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564883431522304', '081', '市担', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564883452493824', '083', '盎司', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564883477659648', '084', '克拉', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564883498631168', '085', '市尺', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564883523796992', '086', '码', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564883540574208', '088', '英寸', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564883565740032', '089', '寸', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564883590905856', '095', '升', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564883607683072', '096', '毫升', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564883628654592', '097', '英加仑', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564883653820416', '098', '美加仑', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564883674791936', '099', '立方英尺', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564883695763456', '101', '立方尺', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564883716734976', '110', '平方码', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564883741900800', '111', '平方英尺', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564883762872320', '112', '平方尺', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564883783843840', '115', '英制马力', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564883800621056', '116', '公制马力', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564883825786880', '118', '令', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564883850952704', '120', '箱', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564883867729920', '121', '批', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564883884507136', '122', '罐', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564883909672960', '123', '桶', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564883934838784', '124', '扎', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564883955810304', '125', '包', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564883972587520', '126', '箩', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564883997753344', '127', '打', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564884022919168', '128', '筐', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564884043890688', '129', '罗', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564884060667904', '130', '匹', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564884085833728', '131', '册', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564884110999552', '132', '本', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564884131971072', '133', '发', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564884148748288', '134', '枚', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564884173914112', '135', '捆', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564884194885632', '136', '袋', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564884215857152', '139', '粒', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564884232634368', '140', '盒', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564884257800192', '141', '合', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564884278771712', '142', '瓶', '瓶', '0', NULL, '2018-03-08 09:54:54', '288', '2020-10-19 02:25:31', '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564884299743232', '143', '千支', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564884316520448', '144', '万双', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564884341686272', '145', '万粒', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564884366852096', '146', '千粒', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564884383629312', '147', '千米', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564884400406528', '148', '千英尺', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564884425572352', '149', '百万贝可', NULL, '0', NULL, '2018-03-08 09:54:54', NULL, NULL, '2018-03-08 09:54:53');
INSERT INTO `sys_cus_unit_code` VALUES ('scuc971564884446543872', '163', '个', NULL, '0', NULL, '2018-03-08 09:54:54', '1', '2021-11-24 14:28:30', '2021-11-24 14:28:17');

-- ----------------------------
-- Table structure for sys_dept
-- ----------------------------
DROP TABLE IF EXISTS `sys_dept`;
CREATE TABLE `sys_dept`  (
  `dept_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `parent_id` bigint(20) DEFAULT NULL COMMENT '上级部门ID，一级部门为0',
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '部门名称',
  `order_num` int(11) DEFAULT NULL COMMENT '排序',
  `del_flag` tinyint(4) DEFAULT 0 COMMENT '是否删除  -1：已删除  0：正常',
  PRIMARY KEY (`dept_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '部门管理' ROW_FORMAT = Compact;

-- ----------------------------
-- Table structure for sys_exception_record
-- ----------------------------
DROP TABLE IF EXISTS `sys_exception_record`;
CREATE TABLE `sys_exception_record`  (
  `id` int(11) NOT NULL COMMENT '编号',
  `exception_info` varchar(5000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '异常信息',
  `creater_sn` varchar(22) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '创建人编号',
  `create_time` datetime(0) DEFAULT NULL COMMENT '创建时间',
  `moder_sn` varchar(22) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '修改人编号',
  `mod_time` datetime(0) DEFAULT NULL COMMENT '修改时间',
  `tstm` datetime(0) DEFAULT NULL COMMENT '时间戳',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '系统异常记录表' ROW_FORMAT = Compact;

-- ----------------------------
-- Table structure for sys_macro
-- ----------------------------
DROP TABLE IF EXISTS `sys_macro`;
CREATE TABLE `sys_macro`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `parent_id` bigint(255) DEFAULT NULL COMMENT '父级id',
  `name` varchar(50) CHARACTER SET gbk COLLATE gbk_chinese_ci DEFAULT NULL COMMENT '名称',
  `value` varchar(2000) CHARACTER SET gbk COLLATE gbk_chinese_ci DEFAULT NULL COMMENT '值',
  `status` tinyint(4) DEFAULT 1 COMMENT '状态，0：隐藏   1：显示',
  `type` tinyint(20) DEFAULT NULL COMMENT '类型,0:目录，1:参数配置',
  `order_num` int(11) DEFAULT NULL COMMENT '排序',
  `remark` varchar(500) CHARACTER SET gbk COLLATE gbk_chinese_ci DEFAULT NULL COMMENT '备注',
  `gmt_create` date DEFAULT NULL COMMENT '创建时间',
  `gmt_modified` date DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 101 CHARACTER SET = gbk COLLATE = gbk_chinese_ci COMMENT = '通用字典表' ROW_FORMAT = Compact;

-- ----------------------------
-- Records of sys_macro
-- ----------------------------
INSERT INTO `sys_macro` VALUES (5, NULL, '单位', 'goodsUnit', 1, 0, NULL, NULL, '2017-08-30', NULL);
INSERT INTO `sys_macro` VALUES (6, 5, '个', '个', 1, 1, 1, NULL, '2017-08-30', '2018-11-01');
INSERT INTO `sys_macro` VALUES (7, 5, '只', '只', 1, 1, 2, NULL, '2017-10-06', '2017-10-06');
INSERT INTO `sys_macro` VALUES (8, NULL, '货品业务类型', 'goodsBizType', 1, 0, NULL, NULL, '2018-10-18', NULL);
INSERT INTO `sys_macro` VALUES (9, 8, '保税备货', '00', 0, 1, 1, NULL, '2018-10-18', '2020-06-10');
INSERT INTO `sys_macro` VALUES (10, 8, '保税展示补货', '02', 0, 1, 2, NULL, '2018-10-18', '2020-06-10');
INSERT INTO `sys_macro` VALUES (11, 8, '保税展示跨境', '10', 1, 1, 3, NULL, '2018-10-18', NULL);
INSERT INTO `sys_macro` VALUES (12, 8, '普通货物', '11', 0, 1, 4, NULL, '2018-10-18', '2020-06-10');
INSERT INTO `sys_macro` VALUES (13, NULL, '退款入账账户 ', 'refundRecvAccout', 1, 0, NULL, NULL, '2018-11-01', NULL);
INSERT INTO `sys_macro` VALUES (14, 13, '退回银行卡：{银行名称}{卡类型}{卡尾号}', '1', 1, 1, 1, NULL, '2018-11-01', '2018-11-01');
INSERT INTO `sys_macro` VALUES (15, 13, '退回支付用户零钱:支付用户零钱', '2', 1, 1, 2, NULL, '2018-11-01', NULL);
INSERT INTO `sys_macro` VALUES (16, 13, '退还商户:商户基本账户 商户结算银行账户', '3', 1, 1, 3, NULL, '2018-11-01', NULL);
INSERT INTO `sys_macro` VALUES (17, 13, '退回支付用户零钱通:支付用户零钱通', '4', 1, 1, 4, NULL, '2018-11-01', NULL);
INSERT INTO `sys_macro` VALUES (18, NULL, '微信退款状态', 'wechatRefundStatusDes', 1, 0, NULL, NULL, '2018-11-06', NULL);
INSERT INTO `sys_macro` VALUES (19, 18, '退款成功', 'SUCCESS', 1, 1, 1, NULL, '2018-11-07', '2018-11-07');
INSERT INTO `sys_macro` VALUES (20, 18, '退款关闭', 'REFUNDCLOSE', 1, 1, 2, NULL, '2018-11-07', '2018-11-07');
INSERT INTO `sys_macro` VALUES (21, 18, '退款处理中', 'PROCESSING', 1, 1, 3, NULL, '2018-11-07', '2018-11-07');
INSERT INTO `sys_macro` VALUES (22, 18, '退款异常', 'CHANGE', 1, 1, 4, NULL, '2018-11-07', NULL);
INSERT INTO `sys_macro` VALUES (23, NULL, '退款类型', 'refundType', 1, 0, NULL, NULL, '2018-11-07', NULL);
INSERT INTO `sys_macro` VALUES (24, 23, '用户全额退款', '1', 1, 1, 1, NULL, '2018-11-07', NULL);
INSERT INTO `sys_macro` VALUES (25, 23, '系统部分退款', '2', 1, 1, 2, NULL, '2018-11-07', NULL);
INSERT INTO `sys_macro` VALUES (26, NULL, '退款状态', 'refundStatus', 1, 0, NULL, NULL, '2018-11-07', NULL);
INSERT INTO `sys_macro` VALUES (27, 26, '申请中', '1', 1, 1, 1, NULL, '2018-11-07', NULL);
INSERT INTO `sys_macro` VALUES (28, 26, '退款成功', '2', 1, 1, 2, NULL, '2018-11-07', NULL);
INSERT INTO `sys_macro` VALUES (29, 26, '已拒绝', '3', 1, 1, 3, NULL, '2018-11-07', NULL);
INSERT INTO `sys_macro` VALUES (30, NULL, '库存变化类型', 'changeType', 1, 0, NULL, '库存变化类型', '2019-03-11', '2019-03-11');
INSERT INTO `sys_macro` VALUES (31, 30, '还原', '0', 1, 1, NULL, NULL, '2019-03-11', NULL);
INSERT INTO `sys_macro` VALUES (32, 30, '扣减', '1', 1, 1, NULL, NULL, '2019-03-11', NULL);
INSERT INTO `sys_macro` VALUES (33, 30, '新增调整', '2', 1, 1, NULL, NULL, '2019-03-11', NULL);
INSERT INTO `sys_macro` VALUES (34, 30, '更新库存增加', '3', 1, 1, NULL, NULL, '2019-03-11', '2019-03-11');
INSERT INTO `sys_macro` VALUES (35, 30, '更新库存减少', '4', 1, 1, NULL, NULL, '2019-03-11', NULL);
INSERT INTO `sys_macro` VALUES (36, NULL, '订单状态', 'orderStatus', 1, 0, NULL, NULL, '2019-03-19', '2019-03-19');
INSERT INTO `sys_macro` VALUES (37, 36, '待付款', '0', 1, 1, NULL, NULL, '2019-03-19', NULL);
INSERT INTO `sys_macro` VALUES (38, 36, '订单已取消', '101', 1, 1, NULL, NULL, '2019-03-19', NULL);
INSERT INTO `sys_macro` VALUES (39, 36, '订单已删除', '102', 1, 1, NULL, NULL, '2019-03-19', NULL);
INSERT INTO `sys_macro` VALUES (40, 36, '订单已付款', '201', 1, 1, NULL, NULL, '2019-03-19', NULL);
INSERT INTO `sys_macro` VALUES (41, 36, '订单已发货', '300', 1, 1, NULL, NULL, '2019-03-19', NULL);
INSERT INTO `sys_macro` VALUES (42, 36, '用户确认收货', '301', 1, 1, NULL, NULL, '2019-03-19', NULL);
INSERT INTO `sys_macro` VALUES (43, 36, '退款', '401', 1, 1, NULL, NULL, '2019-03-19', NULL);
INSERT INTO `sys_macro` VALUES (44, NULL, '付款状态', 'payStatus', 1, 0, NULL, NULL, '2019-03-19', NULL);
INSERT INTO `sys_macro` VALUES (45, 44, '未付款', '0', 1, 1, NULL, NULL, '2019-03-19', NULL);
INSERT INTO `sys_macro` VALUES (46, 44, '付款中', '1', 1, 1, NULL, NULL, '2019-03-19', NULL);
INSERT INTO `sys_macro` VALUES (47, 44, '已付款', '2', 1, 1, NULL, NULL, '2019-03-19', NULL);
INSERT INTO `sys_macro` VALUES (48, 44, '退款中', '3', 1, 1, NULL, NULL, '2019-03-19', NULL);
INSERT INTO `sys_macro` VALUES (49, 44, '已退款', '4', 1, 1, NULL, NULL, '2019-03-19', NULL);
INSERT INTO `sys_macro` VALUES (50, 44, '退款关闭', '5', 1, 1, NULL, NULL, '2019-03-19', NULL);
INSERT INTO `sys_macro` VALUES (51, 44, '退款异常', '6', 1, 1, NULL, NULL, '2019-03-19', NULL);
INSERT INTO `sys_macro` VALUES (52, NULL, '提醒类别', 'reminderCategory', 1, 0, NULL, NULL, '2020-06-18', NULL);
INSERT INTO `sys_macro` VALUES (53, 52, '出货提醒', '0', 1, 1, NULL, NULL, '2020-06-18', NULL);
INSERT INTO `sys_macro` VALUES (54, 52, '订货提醒', '1', 1, 1, NULL, NULL, '2020-06-18', NULL);
INSERT INTO `sys_macro` VALUES (55, NULL, '提醒类型', 'reminderType', 1, 0, NULL, NULL, '2020-06-18', NULL);
INSERT INTO `sys_macro` VALUES (56, 55, '固定值', '00', 1, 1, NULL, NULL, '2020-06-18', NULL);
INSERT INTO `sys_macro` VALUES (57, 55, '周期计算', '10', 1, 1, NULL, NULL, '2020-06-18', NULL);
INSERT INTO `sys_macro` VALUES (58, NULL, '机器码类型', 'machineCodeType', 1, 0, NULL, NULL, '2020-06-23', NULL);
INSERT INTO `sys_macro` VALUES (59, 58, '机器码001', '0', 1, 1, NULL, NULL, '2020-06-23', NULL);
INSERT INTO `sys_macro` VALUES (60, 58, '机器码002', '1', 1, 1, NULL, NULL, '2020-06-23', NULL);
INSERT INTO `sys_macro` VALUES (62, NULL, '快递类型', 'exprType', 1, 0, NULL, '快递类型配置', '2021-04-12', NULL);
INSERT INTO `sys_macro` VALUES (63, 62, '普通', '00', 1, 1, 2, '普通快递', '2021-04-12', NULL);
INSERT INTO `sys_macro` VALUES (64, 62, '圆通普通', '60', 1, 1, 2, '圆通普通快递', '2021-04-12', NULL);
INSERT INTO `sys_macro` VALUES (65, 62, '百世普通', '70', 1, 1, 2, '百世快递', '2021-04-12', '2021-04-26');
INSERT INTO `sys_macro` VALUES (66, NULL, '支付方式', 'payFlag', 1, 0, NULL, '支付方式', '2021-05-11', NULL);
INSERT INTO `sys_macro` VALUES (67, 66, '支付宝支付', 'alipay', 1, 1, NULL, '支付宝支付', '2021-05-11', NULL);
INSERT INTO `sys_macro` VALUES (69, 66, '微信支付', 'weixin', 1, 1, NULL, '微信支付', '2021-05-11', NULL);
INSERT INTO `sys_macro` VALUES (70, NULL, '积分类型', NULL, 1, 0, NULL, NULL, '2021-11-15', NULL);
INSERT INTO `sys_macro` VALUES (71, 70, '门店', '0', 1, 1, NULL, NULL, '2021-11-15', NULL);
INSERT INTO `sys_macro` VALUES (73, 70, '商品类别', '1', 1, 1, NULL, NULL, '2021-11-15', NULL);
INSERT INTO `sys_macro` VALUES (75, 70, '门店商品', '2', 1, 1, NULL, NULL, '2021-11-15', NULL);
INSERT INTO `sys_macro` VALUES (79, NULL, '数据状态', NULL, 1, 0, NULL, NULL, '2021-11-30', '2021-11-30');
INSERT INTO `sys_macro` VALUES (80, 79, '是', '0', 1, 1, NULL, NULL, '2021-11-30', '2021-11-30');
INSERT INTO `sys_macro` VALUES (81, 79, '否', '1', 1, 1, NULL, NULL, '2021-11-30', NULL);
INSERT INTO `sys_macro` VALUES (82, NULL, '地址类型', NULL, 1, 0, NULL, NULL, '2021-12-02', NULL);
INSERT INTO `sys_macro` VALUES (83, 82, '发货人', '1', 1, 1, NULL, NULL, '2021-12-02', '2021-12-02');
INSERT INTO `sys_macro` VALUES (84, 82, '收货人', '2', 1, 1, NULL, NULL, '2021-12-02', NULL);
INSERT INTO `sys_macro` VALUES (85, NULL, '接口类型', NULL, 1, 0, NULL, NULL, '2021-12-09', NULL);
INSERT INTO `sys_macro` VALUES (86, 85, '订单创建接口', '订单创建接口', 1, 1, NULL, NULL, '2021-12-09', '2021-12-09');
INSERT INTO `sys_macro` VALUES (87, 85, '订单取消接口', '订单取消接口', 1, 1, NULL, NULL, '2021-12-09', NULL);
INSERT INTO `sys_macro` VALUES (88, 85, '订单通关查询接口', '订单通关查询接口', 1, 1, NULL, NULL, '2021-12-09', NULL);
INSERT INTO `sys_macro` VALUES (89, 85, '重试订单接口', '重试订单接口', 1, 1, NULL, NULL, '2021-12-09', NULL);
INSERT INTO `sys_macro` VALUES (90, 85, '查询库存接口', '查询库存接口', 1, 1, NULL, NULL, '2021-12-09', NULL);
INSERT INTO `sys_macro` VALUES (91, 85, '获取accessToken接口', '获取accessToken接口', 1, 1, NULL, NULL, '2021-12-09', NULL);
INSERT INTO `sys_macro` VALUES (92, 85, '刷新token接口', '刷新token接口', 1, 1, NULL, NULL, '2021-12-09', NULL);
INSERT INTO `sys_macro` VALUES (93, 85, '查询会员信息（根据手机号）接口', '查询会员信息（根据手机号）接口', 1, 1, NULL, NULL, '2021-12-09', NULL);
INSERT INTO `sys_macro` VALUES (94, 85, '查询会员信息（根据会员码）接口', '查询会员信息（根据会员码）接口', 1, 1, NULL, NULL, '2021-12-09', NULL);
INSERT INTO `sys_macro` VALUES (95, 85, '更新会员积分接口', '更新会员积分接口', 1, 1, NULL, NULL, '2021-12-09', NULL);
INSERT INTO `sys_macro` VALUES (97, 85, '会员积分回退接口', '会员积分回退接口', 1, 1, NULL, NULL, '2021-12-09', NULL);
INSERT INTO `sys_macro` VALUES (98, 85, '会员积分部分回退接口', '会员积分部分回退接口', 1, 1, NULL, NULL, '2021-12-09', NULL);
INSERT INTO `sys_macro` VALUES (99, 85, '查询会员优惠券接口', '查询会员优惠券接口', 1, 1, NULL, NULL, '2021-12-09', NULL);
INSERT INTO `sys_macro` VALUES (100, 85, '会员消费订单同步接口', '会员消费订单同步接口', 1, 1, NULL, NULL, '2021-12-09', NULL);

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu`  (
  `menu_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `parent_id` bigint(20) DEFAULT NULL COMMENT '父菜单ID，一级菜单为0',
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '菜单名称',
  `url` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '菜单URL',
  `perms` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '授权(多个用逗号分隔，如：user:list,user:create)',
  `type` int(11) DEFAULT NULL COMMENT '类型   0：目录   1：菜单   2：按钮',
  `icon` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '菜单图标',
  `order_num` int(11) DEFAULT NULL COMMENT '排序',
  `status` int(11) DEFAULT NULL COMMENT '状态',
  PRIMARY KEY (`menu_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 917 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '菜单管理' ROW_FORMAT = Compact;

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
INSERT INTO `sys_menu` VALUES (1, 0, '系统管理', NULL, NULL, 0, 'fa fa-cog', 11, 0);
INSERT INTO `sys_menu` VALUES (2, 1, '管理员列表', 'sys/user.html', NULL, 1, 'fa fa-user', 1, 0);
INSERT INTO `sys_menu` VALUES (3, 1, '角色管理', 'sys/role.html', NULL, 1, 'fa fa-user-secret', 2, 0);
INSERT INTO `sys_menu` VALUES (4, 1, '菜单管理', 'sys/menu.html', NULL, 1, 'fa fa-folder-open', 4, 0);
INSERT INTO `sys_menu` VALUES (5, 1, 'SQL监控', 'druid/sql.html', NULL, 1, 'fa fa-linux', 9, 0);
INSERT INTO `sys_menu` VALUES (15, 2, '查看', NULL, 'sys:user:list,sys:user:info', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (16, 2, '新增', NULL, 'sys:user:save,sys:role:select', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (17, 2, '修改', NULL, 'sys:user:update,sys:role:select', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (18, 2, '删除', NULL, 'sys:user:delete', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (19, 3, '查看', NULL, 'sys:role:list,sys:role:info', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (20, 3, '新增', NULL, 'sys:role:save,sys:menu:perms', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (21, 3, '修改', NULL, 'sys:role:update,sys:menu:perms', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (22, 3, '删除', NULL, 'sys:role:delete', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (23, 4, '查看', NULL, 'sys:menu:list,sys:menu:info', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (24, 4, '新增', NULL, 'sys:menu:save,sys:menu:select', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (25, 4, '修改', NULL, 'sys:menu:update,sys:menu:select', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (26, 4, '删除', NULL, 'sys:menu:delete', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (27, 1, '系统参数', 'sys/config.html', 'sys:config:list,sys:config:info,sys:config:save,sys:config:update,sys:config:delete', 1, 'fa fa-sun-o', 7, 0);
INSERT INTO `sys_menu` VALUES (28, 1, '代码生成器', 'sys/generator.html', 'sys:generator:list,sys:generator:code', 1, 'fa fa-rocket', 10, 0);
INSERT INTO `sys_menu` VALUES (29, 1, '系统日志', 'sys/log.html', 'sys:log:list', 1, 'fa fa-file-text-o', 8, 0);
INSERT INTO `sys_menu` VALUES (200, 0, '会员管理', NULL, NULL, 0, 'fa fa-user-circle-o', 5, 0);
INSERT INTO `sys_menu` VALUES (201, 200, '会员管理', 'shop/shopuser.html', NULL, 1, 'fa fa-user-md', 1, 0);
INSERT INTO `sys_menu` VALUES (202, 201, '查看', NULL, 'user:list,user:info', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (203, 201, '新增', NULL, 'user:save', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (204, 201, '修改', NULL, 'user:update', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (205, 201, '删除', NULL, 'user:delete', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (222, 0, '商城配置', NULL, NULL, 0, 'fa fa-shopping-cart', 2, 0);
INSERT INTO `sys_menu` VALUES (234, 233, '查看', NULL, 'ad:list,ad:info', 2, NULL, 6, 0);
INSERT INTO `sys_menu` VALUES (235, 233, '新增', NULL, 'ad:save', 2, NULL, 6, 0);
INSERT INTO `sys_menu` VALUES (236, 233, '修改', NULL, 'ad:update', 2, NULL, 6, 0);
INSERT INTO `sys_menu` VALUES (237, 233, '删除', NULL, 'ad:delete', 2, NULL, 6, 0);
INSERT INTO `sys_menu` VALUES (239, 238, '查看', NULL, 'adposition:list,adposition:info', 2, NULL, 6, 0);
INSERT INTO `sys_menu` VALUES (240, 238, '新增', NULL, 'adposition:save', 2, NULL, 6, 0);
INSERT INTO `sys_menu` VALUES (241, 238, '修改', NULL, 'adposition:update', 2, NULL, 6, 0);
INSERT INTO `sys_menu` VALUES (242, 238, '删除', NULL, 'adposition:delete', 2, NULL, 6, 0);
INSERT INTO `sys_menu` VALUES (254, 222, '品牌制造商', 'shop/brand.html', NULL, 1, 'fa fa-registered', 4, 0);
INSERT INTO `sys_menu` VALUES (255, 254, '查看', NULL, 'brand:list,brand:info', 2, NULL, 6, 0);
INSERT INTO `sys_menu` VALUES (256, 254, '新增', NULL, 'brand:save', 2, NULL, 6, 0);
INSERT INTO `sys_menu` VALUES (257, 254, '修改', NULL, 'brand:update', 2, NULL, 6, 0);
INSERT INTO `sys_menu` VALUES (258, 254, '删除', NULL, 'brand:delete', 2, NULL, 6, 0);
INSERT INTO `sys_menu` VALUES (289, 357, '所有商品', 'shop/goods.html', NULL, 1, 'fa fa-shopping-bag', 1, 0);
INSERT INTO `sys_menu` VALUES (290, 289, '查看', NULL, 'goods:list,goods:info', 2, NULL, 6, 0);
INSERT INTO `sys_menu` VALUES (291, 289, '新增', NULL, 'goods:save', 2, NULL, 6, 0);
INSERT INTO `sys_menu` VALUES (292, 289, '修改', NULL, 'goods:update', 2, NULL, 6, 0);
INSERT INTO `sys_menu` VALUES (293, 289, '删除', NULL, 'goods:delete', 2, NULL, 6, 0);
INSERT INTO `sys_menu` VALUES (297, 222, '商品类型', 'shop/category.html', NULL, 1, 'fa fa-ship', 1, 0);
INSERT INTO `sys_menu` VALUES (298, 297, '查看', NULL, 'category:list,category:info', 2, NULL, 6, 0);
INSERT INTO `sys_menu` VALUES (299, 297, '新增', NULL, 'category:save', 2, NULL, 6, 0);
INSERT INTO `sys_menu` VALUES (300, 297, '修改', NULL, 'category:update', 2, NULL, 6, 0);
INSERT INTO `sys_menu` VALUES (301, 297, '删除', NULL, 'category:delete', 2, NULL, 6, 0);
INSERT INTO `sys_menu` VALUES (302, 1, '通用字典表', 'sys/macro.html', NULL, 1, 'fa fa-book', 6, 0);
INSERT INTO `sys_menu` VALUES (303, 302, '查看', NULL, 'sys:macro:list,sys:macro:info', 2, NULL, 6, 0);
INSERT INTO `sys_menu` VALUES (304, 302, '新增', NULL, 'sys:macro:save', 2, NULL, 6, 0);
INSERT INTO `sys_menu` VALUES (305, 302, '修改', NULL, 'sys:macro:update', 2, NULL, 6, 0);
INSERT INTO `sys_menu` VALUES (306, 302, '删除', NULL, 'sys:macro:delete', 2, NULL, 6, 0);
INSERT INTO `sys_menu` VALUES (357, 0, '商品管理', NULL, NULL, 0, 'fa fa-edit', 4, 0);
INSERT INTO `sys_menu` VALUES (366, 0, '门店管理', NULL, NULL, 0, 'fa fa-leanpub', 3, 0);
INSERT INTO `sys_menu` VALUES (374, 0, '订单管理', NULL, NULL, 0, 'fa fa-first-order', 8, 0);
INSERT INTO `sys_menu` VALUES (393, 201, '导出', NULL, 'user:export', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (394, 200, '收货地址管理', 'shop/address.html', NULL, 1, 'fa fa-map', 7, 0);
INSERT INTO `sys_menu` VALUES (395, 394, '查看', NULL, 'address:list,address:info', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (396, 394, '删除', NULL, 'address:delete', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (398, 397, '查看', NULL, 'sys:noticeuser:list,sys:noticeuser:info', 2, NULL, 6, 0);
INSERT INTO `sys_menu` VALUES (399, 397, '新增', NULL, 'sys:noticeuser:save', 2, NULL, 6, 0);
INSERT INTO `sys_menu` VALUES (400, 397, '修改', NULL, 'sys:noticeuser:update', 2, NULL, 6, 0);
INSERT INTO `sys_menu` VALUES (401, 397, '删除', NULL, 'sys:noticeuser:delete', 2, NULL, 6, 0);
INSERT INTO `sys_menu` VALUES (403, 402, '查看', NULL, 'sys:notice:list,sys:notice:info', 2, NULL, 6, 0);
INSERT INTO `sys_menu` VALUES (404, 402, '新增', NULL, 'sys:notice:save', 2, NULL, 6, 0);
INSERT INTO `sys_menu` VALUES (405, 402, '修改', NULL, 'sys:notice:update', 2, NULL, 6, 0);
INSERT INTO `sys_menu` VALUES (406, 402, '删除', NULL, 'sys:notice:delete', 2, NULL, 6, 0);
INSERT INTO `sys_menu` VALUES (422, 366, '门店打印机', 'sys/printer.html', NULL, 1, 'fa fa-print', 2, 1);
INSERT INTO `sys_menu` VALUES (423, 422, '查看', NULL, 'sys:printer:list,sys:printer:info', 2, NULL, 6, 0);
INSERT INTO `sys_menu` VALUES (424, 422, '新增', NULL, 'sys:printer:save', 2, NULL, 6, 0);
INSERT INTO `sys_menu` VALUES (425, 422, '修改', NULL, 'sys:printer:update', 2, NULL, 6, 0);
INSERT INTO `sys_menu` VALUES (426, 422, '删除', NULL, 'sys:printer:delete', 2, NULL, 6, 0);
INSERT INTO `sys_menu` VALUES (427, 366, '门店管理', 'shop/store.html', NULL, 1, 'fa fa-university', 1, 0);
INSERT INTO `sys_menu` VALUES (428, 427, '查看', NULL, 'store:list,store:info', 2, NULL, 6, 0);
INSERT INTO `sys_menu` VALUES (429, 427, '新增', NULL, 'store:save', 2, NULL, 6, 0);
INSERT INTO `sys_menu` VALUES (430, 427, '修改', NULL, 'store:update', 2, NULL, 6, 0);
INSERT INTO `sys_menu` VALUES (431, 427, '删除', NULL, 'store:delete', 2, NULL, 6, 0);
INSERT INTO `sys_menu` VALUES (443, 442, '查看', NULL, 'sys:smslog:list,sys:smslog:info', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (444, 357, '门店商品', 'shop/storeProductStock.html', NULL, 1, 'fa fa-print', 2, 0);
INSERT INTO `sys_menu` VALUES (445, 444, '导入', NULL, 'productstorerela:upload', 2, NULL, 3, 0);
INSERT INTO `sys_menu` VALUES (447, 444, '修改', NULL, 'productstorerela:update', 2, NULL, 2, 0);
INSERT INTO `sys_menu` VALUES (448, 444, '新增', NULL, 'productstorerela:save', 2, NULL, 1, 0);
INSERT INTO `sys_menu` VALUES (609, 222, '运费模版', 'shop/freight.html', NULL, 1, 'fa fa-truck', 1, 1);
INSERT INTO `sys_menu` VALUES (610, 609, '查看', NULL, 'freight:list,freight:info', 2, NULL, 6, 0);
INSERT INTO `sys_menu` VALUES (611, 609, '新增', NULL, 'freight:save', 2, NULL, 6, 0);
INSERT INTO `sys_menu` VALUES (612, 609, '修改', NULL, 'freight:update', 2, NULL, 6, 0);
INSERT INTO `sys_menu` VALUES (613, 609, '删除', NULL, 'freight:delete', 2, NULL, 6, 0);
INSERT INTO `sys_menu` VALUES (618, 222, '商品供货商', 'shop/supplier.html', NULL, 1, 'fa fa-ship', 3, 0);
INSERT INTO `sys_menu` VALUES (619, 618, '查看', NULL, 'supplier:list,supplier:info	', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (620, 618, '修改', NULL, 'supplier:update', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (621, 618, '保存', NULL, 'supplier:save	', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (622, 618, '删除', NULL, 'supplier:delete', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (627, 374, '线下订单', 'shop/offilineOrderList.html?orderType=1', NULL, 1, 'fa fa-book', 0, 0);
INSERT INTO `sys_menu` VALUES (628, 627, '查看', NULL, 'order:offilineOrderList,order:offlineInfos', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (629, 627, '现金付款', NULL, 'order:confirmPay', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (630, 627, '取消', NULL, 'order:refund	', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (631, 289, '导入', NULL, 'goods:upload,goods:generalGoodsUpload', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (633, 627, '微信付款', NULL, 'order:wxMicropayPay', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (634, 677, '商户管理', 'shop/merch.html', NULL, 1, 'fa fa-registered', 0, 0);
INSERT INTO `sys_menu` VALUES (635, 634, '查看', NULL, 'merch:list,merch:info', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (636, 634, '新增', NULL, 'merch:save', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (637, 634, '修改', NULL, 'merch:update', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (638, 634, '删除', NULL, 'merch:delete', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (639, 357, '商品导入异常数据', 'shop/exportexceptiondata.html', NULL, 1, 'fa fa-file-code-o', 13, 0);
INSERT INTO `sys_menu` VALUES (640, 639, '查看', NULL, 'exportexceptiondata:list,exportexceptiondata:info', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (641, 222, '国别代码', 'shop/syscusnationcode.html', '', 1, 'fa fa-clone', 11, 0);
INSERT INTO `sys_menu` VALUES (642, 641, '查看', NULL, 'syscusnationcode:list,syscusnationcode:info', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (643, 641, '新增', NULL, 'syscusnationcode:save', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (644, 641, '修改', NULL, 'syscusnationcode:update', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (645, 641, '删除', NULL, 'syscusnationcode:delete', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (646, 222, '计量单位代码', 'shop/syscusunitcode.html', NULL, 1, 'fa fa-clone', 12, 0);
INSERT INTO `sys_menu` VALUES (647, 646, '查看', NULL, 'syscusunitcode:list,syscusunitcode:info', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (648, 646, '新增', NULL, 'syscusunitcode:save', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (649, 646, '修改', NULL, 'syscusunitcode:update', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (650, 646, '删除', NULL, 'syscusunitcode:delete', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (651, 627, '退款', NULL, 'order:offilineRefund', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (652, 427, '生成二维码', NULL, 'store:qrcodeCanvas', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (654, 677, '第三方商户管理', 'shop/thirdmerchantbiz.html', NULL, 1, 'fa fa-registered', 0, 0);
INSERT INTO `sys_menu` VALUES (655, 654, '查询', NULL, 'thirdmerchantbiz:list,thirdmerchantbiz:info', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (656, 654, '新增', NULL, 'thirdmerchantbiz:save', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (657, 654, '修改', NULL, 'thirdmerchantbiz:update', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (658, 654, '删除', NULL, 'thirdmerchantbiz:delete', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (659, 289, '上架、下架', NULL, 'goods:unSaleBatch', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (660, 289, '下载', NULL, 'goods:down', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (662, 201, '购物车', NULL, 'shop:cart', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (663, 201, '收货地址', NULL, 'shop:address', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (664, 444, '查看', NULL, 'productstorerela:list,productstorerela:info', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (671, 357, '门店商品库存变化', 'shop/storemngchange.html', NULL, 1, 'fa fa-shopping-bag', 5, 0);
INSERT INTO `sys_menu` VALUES (673, 671, '查看', NULL, 'storemngchange:list,storemngchange:info', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (674, 444, '删除', NULL, 'productstorerela:delete', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (677, 0, '商户配置', NULL, NULL, 0, 'fa fa-th-list', 1, 0);
INSERT INTO `sys_menu` VALUES (689, 684, '查看', NULL, 'mkdist:list,mkdist:info', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (690, 684, '新增', NULL, 'mkdist:save', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (691, 684, '修改', NULL, 'mkdist:update', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (692, 684, '删除', NULL, 'mkdist:delete', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (693, 685, '查看', NULL, 'mkdistchnl:list,mkdistchnl:info', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (694, 685, '新增', NULL, 'mkdistchnl:save', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (695, 685, '修改', NULL, 'mkdistchnl:update', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (696, 685, '删除', NULL, 'mkdistchnl:delete', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (697, 686, '查询', NULL, 'mkdisthier:list,mkdisthier:info', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (698, 686, '新增', NULL, 'mkdisthier:save', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (699, 686, '修改', NULL, 'mkdisthier:update', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (700, 686, '删除', NULL, 'mkdisthier:delete', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (701, 687, '查询', NULL, 'mkdistsellallocation:list,mkdistsellallocation:info', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (702, 687, '新增', NULL, 'mkdistsellallocation:save', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (703, 687, '修改', NULL, 'mkdistsellallocation:update', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (704, 687, '删除', NULL, 'mkdistsellallocation:delete', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (705, 688, '查询', NULL, 'mkdistsellstatis:list,mkdistsellstatis:info', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (707, 706, '活动新增', NULL, 'mkdists:save', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (709, 708, '查询', NULL, 'mkcentermenu:list,mkcentermenu:info', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (710, 708, '新增', NULL, 'mkcentermenu:save', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (711, 708, '修改', NULL, 'mkcentermenu:update', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (712, 708, '删除', NULL, 'mkcentermenu:delete', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (713, 688, '导出', NULL, 'mkdistsellstatis:export', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (722, 721, '查询', NULL, 'storetopic:list,storetopic:info', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (723, 706, '查询渠道追踪', NULL, 'mkstoreprom:list,mkstoreprom:info', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (724, 706, '新增渠道追踪', NULL, 'mkstoreprom:save', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (725, 706, '修改渠道追踪', NULL, 'mkstoreprom:update', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (726, 706, '删除渠道追踪', NULL, 'mkstoreprom:delete', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (727, 706, '新增推广渠道', NULL, 'mkstorepromchnl:save', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (730, 729, '查询', NULL, 'mkstorepromstat:list,mkstorepromstat:info', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (736, 735, '查询', NULL, 'mkstoretopicstat:list,mkstoretopicstat:info', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (737, 708, '新增门店营销菜单', NULL, 'mkcentermenustorereal:save,mkcentermenustorereal:info', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (738, 708, '删除门店营销菜单', NULL, 'mkcentermenustorereal:delete', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (745, 222, '商品规格', 'shop/product.html', NULL, 1, 'fa fa-registered', 5, 0);
INSERT INTO `sys_menu` VALUES (746, 745, '查看', NULL, 'product:list,product:info', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (747, 427, '导入，下载', NULL, 'store:storeUpload,store:down', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (748, 444, '下载、导入', NULL, 'productstorerela:productStoreRelaUpload,productstorerela:down', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (749, 2, '导入、下载', NULL, 'sys:user:sysUserUpload,sys:user:down', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (750, 427, '导出', NULL, 'store:export', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (754, 297, '复制', NULL, 'category:saveCopyCategory', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (755, 254, '复制', NULL, 'brand:saveCopyBrand', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (756, 609, '复制', NULL, 'freight:saveCopyFreight', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (757, 233, '复制', NULL, 'ad:saveCopyAd', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (759, 758, '查询', NULL, 'order:list', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (760, 758, '人脸识别', NULL, 'face:checkLivenessRecognition', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (762, 763, '小票查询', 'receipt/receiptCheck.html', NULL, 1, 'fa fa-file-code-o', 0, 0);
INSERT INTO `sys_menu` VALUES (763, 0, '收银管理', '', '', 0, 'fa fa-money', 7, 0);
INSERT INTO `sys_menu` VALUES (764, 763, '收银机管理', 'cashier/cashierManager.html', NULL, 1, 'fa fa-file-code-o', 0, 0);
INSERT INTO `sys_menu` VALUES (765, 763, '收银员登录记录', 'cashier/cashierLoginRecord.html', NULL, 1, 'fa fa-file-code-o', 0, 0);
INSERT INTO `sys_menu` VALUES (771, 763, '销售记录', 'cashier/salerecord.html', NULL, 1, 'fa fa-file-code-o', 0, 0);
INSERT INTO `sys_menu` VALUES (778, 200, '会员消费记录', '/vip/mall2memberconsumptionrecords.html', NULL, 1, 'fa fa-file-code-o', 0, 0);
INSERT INTO `sys_menu` VALUES (779, 0, '活动管理', NULL, NULL, 0, 'fa fa-shopping-basket', 6, 0);
INSERT INTO `sys_menu` VALUES (803, 374, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` VALUES (804, 627, '导出', NULL, 'order:exportOffilineOrder', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (805, 289, '导出', NULL, 'goods:export', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (806, 444, '导出', NULL, 'productstorerela:export', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (823, 1, '系统业务权限管理', 'sys/sysbizpermission.html', NULL, 1, 'fa fa-file-code-o', 11, 0);
INSERT INTO `sys_menu` VALUES (824, 1, '系统用户权限管理', 'sys/sysuserbizpermission.html', NULL, 1, 'fa fa-file-code-o', 12, 0);
INSERT INTO `sys_menu` VALUES (825, 823, '查询', NULL, 'sysbizpermission:list,sysbizpermission:info', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (826, 823, '新增', NULL, 'sysbizpermission:save', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (827, 823, '修改', NULL, 'sysbizpermission:update', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (828, 823, '删除', NULL, 'sysbizpermission:delete', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (829, 824, '查询', NULL, 'sysuserbizpermission:list,sysuserbizpermission:info', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (830, 824, '新增', NULL, 'sysuserbizpermission:save', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (831, 824, '修改', NULL, 'sysuserbizpermission:update', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (832, 824, '删除', NULL, 'sysuserbizpermission:delete', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (834, 850, '查询', NULL, 'mkactivityform:list,mkactivityform:info', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (835, 850, '新增', NULL, 'mkactivityform:save', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (836, 850, '修改', NULL, 'mkactivityform:update', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (837, 850, '删除', NULL, 'mkactivityform:delete', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (850, 779, '活动形式管理', '/mk/mkactivityform.html', NULL, 1, 'fa fa-file-code-o', 4, 0);
INSERT INTO `sys_menu` VALUES (860, 859, '支付单信息', 'compared/payorderinfo.html', NULL, 1, 'fa fa-file-code-o', 0, 0);
INSERT INTO `sys_menu` VALUES (861, 859, '支付异常单信息', 'compared/ordercomparederror.html', NULL, 1, 'fa fa-file-code-o', 0, 0);
INSERT INTO `sys_menu` VALUES (862, 859, '税单导入', 'compared/taxinfo.html', NULL, 1, 'fa fa-file-code-o', 0, 0);
INSERT INTO `sys_menu` VALUES (863, 859, '税单异常', 'compared/taxcomparederror.html', NULL, 1, 'fa fa-file-code-o', 0, 0);
INSERT INTO `sys_menu` VALUES (875, 0, '转移管理', NULL, NULL, 0, 'fa fa-leanpub', 3, 1);
INSERT INTO `sys_menu` VALUES (876, 875, '门店库存转移单表', 'shop/storetransferinventoryorder.html', NULL, 1, 'fa fa-file-code-o', 6, 1);
INSERT INTO `sys_menu` VALUES (877, 876, '查看', NULL, 'storetransferinventoryorder:list,storetransferinventoryorder:info', 2, NULL, 6, 0);
INSERT INTO `sys_menu` VALUES (878, 876, '新增', NULL, 'storetransferinventoryorder:save', 2, NULL, 6, 0);
INSERT INTO `sys_menu` VALUES (879, 876, '修改', NULL, 'storetransferinventoryorder:update', 2, NULL, 6, 0);
INSERT INTO `sys_menu` VALUES (880, 876, '删除', NULL, 'storetransferinventoryorder:delete', 2, NULL, 6, 0);
INSERT INTO `sys_menu` VALUES (881, 875, '门店库存转移单详情表', 'shop/storetransferinventoryorderdetail.html', NULL, 1, 'fa fa-file-code-o', 6, 1);
INSERT INTO `sys_menu` VALUES (882, 881, '查看', NULL, 'storetransferinventoryorderdetail:list,storetransferinventoryorderdetail:info', 2, NULL, 6, 0);
INSERT INTO `sys_menu` VALUES (883, 881, '新增', NULL, 'storetransferinventoryorderdetail:save', 2, NULL, 6, 0);
INSERT INTO `sys_menu` VALUES (884, 881, '修改', NULL, 'storetransferinventoryorderdetail:update', 2, NULL, 6, 0);
INSERT INTO `sys_menu` VALUES (885, 881, '删除', NULL, 'storetransferinventoryorderdetail:delete', 2, NULL, 6, 0);
INSERT INTO `sys_menu` VALUES (888, 1, '快递公司列表', 'sys/expresscompanysys.html', '', 1, 'fa fa-file-code-o', 13, 1);
INSERT INTO `sys_menu` VALUES (889, 888, '查看', NULL, 'expresscompanysys:list,expresscompanysys:info', 2, NULL, 6, 0);
INSERT INTO `sys_menu` VALUES (890, 888, '新增', NULL, 'expresscompanysys:save', 2, NULL, 6, 0);
INSERT INTO `sys_menu` VALUES (891, 888, '修改', NULL, 'expresscompanysys:update', 2, NULL, 6, 0);
INSERT INTO `sys_menu` VALUES (896, 888, '选中分配门店', NULL, 'expresscompanysys:showshopaddrsave', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (903, 903, '新增', '/vip/mall2pointsrules.html', 'mall2pointsrules:save', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (904, 200, '积分赠送规则设置', '/vip/mall2pointsrules.html', 'fa fa-edit', 1, 'fa fa-cog', 0, 0);
INSERT INTO `sys_menu` VALUES (905, 904, '新增', NULL, 'mall2pointsrules:save', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (906, 904, '修改', NULL, 'mall2pointsrules:update', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (907, 904, '删除', NULL, 'mall2pointsrules:delete', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (908, 394, '新增', NULL, 'address:save', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (909, 394, '修改', NULL, 'address:update', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (915, 942, '接口日志', 'shop/interfacesendlog.html', 'fa fa-eye', 1, 'fa fa-file-text-o', 0, 0);
INSERT INTO `sys_menu` VALUES (916, 915, '查询', NULL, 'tinterfacesendlog:info,interfacesendlog:list', 2, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (942, 0, '日志记录', NULL, NULL, 0, 'fa fa-file-text-o', 10, 0);

INSERT INTO `sys_menu` (`parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `status`)
    VALUES ('357', '出入库单记录', 'shop/stockchangerecord.html', NULL, '1', 'fa fa-file-code-o', '6', '0');
-- 按钮父菜单ID
set @parentId = @@identity;

-- 菜单对应按钮SQL
INSERT INTO `sys_menu` (`parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `status`)
    SELECT @parentId, '查看', null, 'stockchangerecord:list,stockchangerecord:info', '2', null, '6', '0';
INSERT INTO `sys_menu` (`parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `status`)
    SELECT @parentId, '新增', null, 'stockchangerecord:save', '2', null, '6', '0';
INSERT INTO `sys_menu` (`parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `status`)
    SELECT @parentId, '修改', null, 'stockchangerecord:update', '2', null, '6', '0';
INSERT INTO `sys_menu` (`parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `status`)
    SELECT @parentId, '删除', null, 'stockchangerecord:delete', '2', null, '6', '0';



-- 菜单SQL
INSERT INTO `sys_menu` (`parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `status`)
    VALUES ('942', '会员同步消费订单记录', 'shop/haikongmemberordersyncresend.html', NULL, '1', 'fa fa-file-code-o', '6', '0');

-- 按钮父菜单ID
set @parentId = @@identity;

-- 菜单对应按钮SQL
INSERT INTO `sys_menu` (`parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `status`)
    SELECT @parentId, '查看', null, 'haikongmemberordersyncresend:list,haikongmemberordersyncresend:info', '2', null, '6', '0';
INSERT INTO `sys_menu` (`parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `status`)
    SELECT @parentId, '新增', null, 'haikongmemberordersyncresend:save', '2', null, '6', '0';
INSERT INTO `sys_menu` (`parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `status`)
    SELECT @parentId, '修改', null, 'haikongmemberordersyncresend:update', '2', null, '6', '0';
INSERT INTO `sys_menu` (`parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `status`)
    SELECT @parentId, '删除', null, 'haikongmemberordersyncresend:delete', '2', null, '6', '0';


-- 菜单SQL
INSERT INTO `sys_menu` (`parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `status`)
    VALUES ('942', '会员积分变动记录详情表', 'shop/haikongmemberscorechangedetailrecord.html', NULL, '1', 'fa fa-file-code-o', '6', '0');

-- 按钮父菜单ID
set @parentId = @@identity;

-- 菜单对应按钮SQL
INSERT INTO `sys_menu` (`parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `status`)
    SELECT @parentId, '查看', null, 'haikongmemberscorechangedetailrecord:list,haikongmemberscorechangedetailrecord:info', '2', null, '6', '0';
INSERT INTO `sys_menu` (`parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `status`)
    SELECT @parentId, '新增', null, 'haikongmemberscorechangedetailrecord:save', '2', null, '6', '0';
INSERT INTO `sys_menu` (`parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `status`)
    SELECT @parentId, '修改', null, 'haikongmemberscorechangedetailrecord:update', '2', null, '6', '0';
INSERT INTO `sys_menu` (`parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `status`)
    SELECT @parentId, '删除', null, 'haikongmemberscorechangedetailrecord:delete', '2', null, '6', '0';


-- 菜单SQL
INSERT INTO `sys_menu` (`parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `status`)
    VALUES ('942', '推送订单信息记录', 'shop/haikongsendorderinforecord.html', NULL, '1', 'fa fa-file-code-o', '6', '0');

-- 按钮父菜单ID
set @parentId = @@identity;

-- 菜单对应按钮SQL
INSERT INTO `sys_menu` (`parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `status`)
    SELECT @parentId, '查看', null, 'haikongsendorderinforecord:list,haikongsendorderinforecord:info', '2', null, '6', '0';
INSERT INTO `sys_menu` (`parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `status`)
    SELECT @parentId, '新增', null, 'haikongsendorderinforecord:save', '2', null, '6', '0';
INSERT INTO `sys_menu` (`parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `status`)
    SELECT @parentId, '修改', null, 'haikongsendorderinforecord:update', '2', null, '6', '0';
INSERT INTO `sys_menu` (`parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `status`)
    SELECT @parentId, '删除', null, 'haikongsendorderinforecord:delete', '2', null, '6', '0';


-- 菜单SQL
INSERT INTO `sys_menu` (`parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `status`)
    VALUES ('942', '会员积分变动记录表', 'shop/haikongmemberscorechangerecord.html', NULL, '1', 'fa fa-file-code-o', '6', '0');

-- 按钮父菜单ID
set @parentId = @@identity;

-- 菜单对应按钮SQL
INSERT INTO `sys_menu` (`parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `status`)
    SELECT @parentId, '查看', null, 'haikongmemberscorechangerecord:list,haikongmemberscorechangerecord:info', '2', null, '6', '0';
INSERT INTO `sys_menu` (`parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `status`)
    SELECT @parentId, '新增', null, 'haikongmemberscorechangerecord:save', '2', null, '6', '0';
INSERT INTO `sys_menu` (`parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `status`)
    SELECT @parentId, '修改', null, 'haikongmemberscorechangerecord:update', '2', null, '6', '0';
INSERT INTO `sys_menu` (`parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `status`)
    SELECT @parentId, '删除', null, 'haikongmemberscorechangerecord:delete', '2', null, '6', '0';


-- 菜单SQL
INSERT INTO `sys_menu` (`parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `status`)
    VALUES ('942', '推送订单明细记录', 'shop/haikongsendorderinfodetailrecord.html', NULL, '1', 'fa fa-file-code-o', '6', '0');

-- 按钮父菜单ID
set @parentId = @@identity;

-- 菜单对应按钮SQL
INSERT INTO `sys_menu` (`parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `status`)
    SELECT @parentId, '查看', null, 'haikongsendorderinfodetailrecord:list,haikongsendorderinfodetailrecord:info', '2', null, '6', '0';
INSERT INTO `sys_menu` (`parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `status`)
    SELECT @parentId, '新增', null, 'haikongsendorderinfodetailrecord:save', '2', null, '6', '0';
INSERT INTO `sys_menu` (`parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `status`)
    SELECT @parentId, '修改', null, 'haikongsendorderinfodetailrecord:update', '2', null, '6', '0';
INSERT INTO `sys_menu` (`parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `status`)
    SELECT @parentId, '删除', null, 'haikongsendorderinfodetailrecord:delete', '2', null, '6', '0';





-- ----------------------------
-- Table structure for sys_notice
-- ----------------------------
DROP TABLE IF EXISTS `sys_notice`;
CREATE TABLE `sys_notice`  (
  `id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '编号',
  `context` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '通知内容',
  `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '通知标题',
  `soucre` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '通知来源 1=普通通知（人工发起） 2=下单通知（系统发起）',
  `status` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '通知状态 0=已发布 1=草稿 ',
  `is_urgent` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '是否紧急 0是1否',
  `release_timee` datetime(0) DEFAULT NULL COMMENT '发布时间',
  `create_time` datetime(0) DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime(0) DEFAULT NULL COMMENT '修改时间',
  `create_id` bigint(20) DEFAULT NULL COMMENT '创建人',
  `update_id` bigint(20) DEFAULT NULL COMMENT '更新人',
  `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '备用字段',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '通知' ROW_FORMAT = Compact;

-- ----------------------------
-- Table structure for sys_notice_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_notice_user`;
CREATE TABLE `sys_notice_user`  (
  `id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '编号',
  `user_id` bigint(20) DEFAULT NULL COMMENT '用户id',
  `notice_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '通知id',
  `status` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '状态 0已读 1未读',
  `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '备用字段',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '通知和用户关系表' ROW_FORMAT = Compact;

-- ----------------------------
-- Table structure for sys_param
-- ----------------------------
DROP TABLE IF EXISTS `sys_param`;
CREATE TABLE `sys_param`  (
  `param_id` mediumint(8) NOT NULL COMMENT '编号',
  `param_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '参数名称',
  `creater_sn` varchar(22) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '创建人编号',
  `create_time` datetime(0) DEFAULT NULL COMMENT '创建时间',
  `moder_sn` varchar(22) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '修改人编号',
  `mod_time` datetime(0) DEFAULT NULL COMMENT '修改时间',
  `tstm` datetime(0) DEFAULT NULL COMMENT '时间戳',
  PRIMARY KEY (`param_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '系统参数表' ROW_FORMAT = Compact;

-- ----------------------------
-- Table structure for sys_printer
-- ----------------------------
DROP TABLE IF EXISTS `sys_printer`;
CREATE TABLE `sys_printer`  (
  `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '打印机名称',
  `sn` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '打印机编号',
  `store_id` mediumint(8) DEFAULT NULL COMMENT '所属门店',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `sn`(`sn`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = '飞鸽打印机' ROW_FORMAT = Compact;

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role`  (
  `role_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `role_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '角色名称',
  `remark` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '备注',
  `create_user_id` bigint(20) DEFAULT NULL COMMENT '创建者ID',
  `create_time` datetime(0) DEFAULT NULL COMMENT '创建时间',
  `dept_id` bigint(20) DEFAULT NULL COMMENT '部门ID',
  PRIMARY KEY (`role_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 32 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色' ROW_FORMAT = Compact;

-- ----------------------------
-- Records of sys_role
-- ----------------------------
INSERT INTO `sys_role` VALUES (1, '超级管理员', '超级管理员', 1, '2017-09-18 00:40:15', 1);
INSERT INTO `sys_role` VALUES (18, 'cw管理员', 'cw管理员', 1, '2020-09-29 11:51:11', NULL);
INSERT INTO `sys_role` VALUES (20, 'CW收银员', 'cw收银员', 288, '2020-10-14 15:37:20', NULL);
INSERT INTO `sys_role` VALUES (21, 'kf_1', '客服部', 1, '2020-11-11 17:25:44', NULL);
INSERT INTO `sys_role` VALUES (25, 'cw_financial', NULL, 1, '2020-11-13 11:21:40', NULL);
INSERT INTO `sys_role` VALUES (26, 'cw_operating', '运营', 1, '2020-12-17 15:40:17', NULL);
INSERT INTO `sys_role` VALUES (27, 'yw收银员', 'cw永旺门店收银员', 1, '2021-03-11 15:08:43', NULL);
INSERT INTO `sys_role` VALUES (28, 'yw管理员', 'cw永旺门店管理员', 1, '2021-03-11 15:26:19', NULL);
INSERT INTO `sys_role` VALUES (29, 'e码头管理员', 'e码头管理员', 1, '2021-05-11 10:02:24', NULL);
INSERT INTO `sys_role` VALUES (30, 'haikong-test', NULL, 1, '2021-11-30 03:07:03', NULL);
INSERT INTO `sys_role` VALUES (31, '0', '0', 317, '2021-12-14 09:11:49', NULL);

-- ----------------------------
-- Table structure for sys_role_dept
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_dept`;
CREATE TABLE `sys_role_dept`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `role_id` bigint(20) DEFAULT NULL COMMENT '角色ID',
  `dept_id` bigint(20) DEFAULT NULL COMMENT '部门ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色与部门对应关系' ROW_FORMAT = Compact;

-- ----------------------------
-- Table structure for sys_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_menu`;
CREATE TABLE `sys_role_menu`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `role_id` bigint(20) DEFAULT NULL COMMENT '角色ID',
  `menu_id` bigint(20) DEFAULT NULL COMMENT '菜单ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 44576 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色与菜单对应关系' ROW_FORMAT = Compact;

-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
INSERT INTO `sys_role_menu` VALUES (32262, 20, 763);
INSERT INTO `sys_role_menu` VALUES (32263, 20, 762);
INSERT INTO `sys_role_menu` VALUES (35510, 27, 763);
INSERT INTO `sys_role_menu` VALUES (35511, 27, 762);
INSERT INTO `sys_role_menu` VALUES (36646, 28, 677);
INSERT INTO `sys_role_menu` VALUES (36647, 28, 634);
INSERT INTO `sys_role_menu` VALUES (36648, 28, 635);
INSERT INTO `sys_role_menu` VALUES (36649, 28, 636);
INSERT INTO `sys_role_menu` VALUES (36650, 28, 637);
INSERT INTO `sys_role_menu` VALUES (36651, 28, 638);
INSERT INTO `sys_role_menu` VALUES (36652, 28, 654);
INSERT INTO `sys_role_menu` VALUES (36653, 28, 655);
INSERT INTO `sys_role_menu` VALUES (36654, 28, 656);
INSERT INTO `sys_role_menu` VALUES (36655, 28, 657);
INSERT INTO `sys_role_menu` VALUES (36656, 28, 658);
INSERT INTO `sys_role_menu` VALUES (36657, 28, 678);
INSERT INTO `sys_role_menu` VALUES (36658, 28, 679);
INSERT INTO `sys_role_menu` VALUES (36659, 28, 680);
INSERT INTO `sys_role_menu` VALUES (36660, 28, 681);
INSERT INTO `sys_role_menu` VALUES (36661, 28, 682);
INSERT INTO `sys_role_menu` VALUES (36662, 28, 222);
INSERT INTO `sys_role_menu` VALUES (36663, 28, 297);
INSERT INTO `sys_role_menu` VALUES (36664, 28, 754);
INSERT INTO `sys_role_menu` VALUES (36665, 28, 298);
INSERT INTO `sys_role_menu` VALUES (36666, 28, 299);
INSERT INTO `sys_role_menu` VALUES (36667, 28, 300);
INSERT INTO `sys_role_menu` VALUES (36668, 28, 301);
INSERT INTO `sys_role_menu` VALUES (36669, 28, 609);
INSERT INTO `sys_role_menu` VALUES (36670, 28, 756);
INSERT INTO `sys_role_menu` VALUES (36671, 28, 610);
INSERT INTO `sys_role_menu` VALUES (36672, 28, 611);
INSERT INTO `sys_role_menu` VALUES (36673, 28, 612);
INSERT INTO `sys_role_menu` VALUES (36674, 28, 613);
INSERT INTO `sys_role_menu` VALUES (36675, 28, 407);
INSERT INTO `sys_role_menu` VALUES (36676, 28, 408);
INSERT INTO `sys_role_menu` VALUES (36677, 28, 409);
INSERT INTO `sys_role_menu` VALUES (36678, 28, 410);
INSERT INTO `sys_role_menu` VALUES (36679, 28, 411);
INSERT INTO `sys_role_menu` VALUES (36680, 28, 618);
INSERT INTO `sys_role_menu` VALUES (36681, 28, 619);
INSERT INTO `sys_role_menu` VALUES (36682, 28, 620);
INSERT INTO `sys_role_menu` VALUES (36683, 28, 621);
INSERT INTO `sys_role_menu` VALUES (36684, 28, 622);
INSERT INTO `sys_role_menu` VALUES (36685, 28, 254);
INSERT INTO `sys_role_menu` VALUES (36686, 28, 755);
INSERT INTO `sys_role_menu` VALUES (36687, 28, 256);
INSERT INTO `sys_role_menu` VALUES (36688, 28, 257);
INSERT INTO `sys_role_menu` VALUES (36689, 28, 258);
INSERT INTO `sys_role_menu` VALUES (36690, 28, 255);
INSERT INTO `sys_role_menu` VALUES (36691, 28, 745);
INSERT INTO `sys_role_menu` VALUES (36692, 28, 746);
INSERT INTO `sys_role_menu` VALUES (36693, 28, 315);
INSERT INTO `sys_role_menu` VALUES (36694, 28, 316);
INSERT INTO `sys_role_menu` VALUES (36695, 28, 317);
INSERT INTO `sys_role_menu` VALUES (36696, 28, 318);
INSERT INTO `sys_role_menu` VALUES (36697, 28, 319);
INSERT INTO `sys_role_menu` VALUES (36698, 28, 325);
INSERT INTO `sys_role_menu` VALUES (36699, 28, 326);
INSERT INTO `sys_role_menu` VALUES (36700, 28, 327);
INSERT INTO `sys_role_menu` VALUES (36701, 28, 328);
INSERT INTO `sys_role_menu` VALUES (36702, 28, 329);
INSERT INTO `sys_role_menu` VALUES (36703, 28, 417);
INSERT INTO `sys_role_menu` VALUES (36704, 28, 418);
INSERT INTO `sys_role_menu` VALUES (36705, 28, 419);
INSERT INTO `sys_role_menu` VALUES (36706, 28, 420);
INSERT INTO `sys_role_menu` VALUES (36707, 28, 421);
INSERT INTO `sys_role_menu` VALUES (36708, 28, 412);
INSERT INTO `sys_role_menu` VALUES (36709, 28, 413);
INSERT INTO `sys_role_menu` VALUES (36710, 28, 414);
INSERT INTO `sys_role_menu` VALUES (36711, 28, 415);
INSERT INTO `sys_role_menu` VALUES (36712, 28, 416);
INSERT INTO `sys_role_menu` VALUES (36713, 28, 641);
INSERT INTO `sys_role_menu` VALUES (36714, 28, 642);
INSERT INTO `sys_role_menu` VALUES (36715, 28, 643);
INSERT INTO `sys_role_menu` VALUES (36716, 28, 644);
INSERT INTO `sys_role_menu` VALUES (36717, 28, 645);
INSERT INTO `sys_role_menu` VALUES (36718, 28, 646);
INSERT INTO `sys_role_menu` VALUES (36719, 28, 647);
INSERT INTO `sys_role_menu` VALUES (36720, 28, 648);
INSERT INTO `sys_role_menu` VALUES (36721, 28, 649);
INSERT INTO `sys_role_menu` VALUES (36722, 28, 650);
INSERT INTO `sys_role_menu` VALUES (36723, 28, 366);
INSERT INTO `sys_role_menu` VALUES (36724, 28, 427);
INSERT INTO `sys_role_menu` VALUES (36725, 28, 652);
INSERT INTO `sys_role_menu` VALUES (36726, 28, 747);
INSERT INTO `sys_role_menu` VALUES (36727, 28, 750);
INSERT INTO `sys_role_menu` VALUES (36728, 28, 428);
INSERT INTO `sys_role_menu` VALUES (36729, 28, 429);
INSERT INTO `sys_role_menu` VALUES (36730, 28, 430);
INSERT INTO `sys_role_menu` VALUES (36731, 28, 431);
INSERT INTO `sys_role_menu` VALUES (36732, 28, 357);
INSERT INTO `sys_role_menu` VALUES (36733, 28, 816);
INSERT INTO `sys_role_menu` VALUES (36734, 28, 817);
INSERT INTO `sys_role_menu` VALUES (36735, 28, 818);
INSERT INTO `sys_role_menu` VALUES (36736, 28, 819);
INSERT INTO `sys_role_menu` VALUES (36737, 28, 820);
INSERT INTO `sys_role_menu` VALUES (36738, 28, 821);
INSERT INTO `sys_role_menu` VALUES (36739, 28, 822);
INSERT INTO `sys_role_menu` VALUES (36740, 28, 864);
INSERT INTO `sys_role_menu` VALUES (36741, 28, 870);
INSERT INTO `sys_role_menu` VALUES (36742, 28, 871);
INSERT INTO `sys_role_menu` VALUES (36743, 28, 872);
INSERT INTO `sys_role_menu` VALUES (36744, 28, 873);
INSERT INTO `sys_role_menu` VALUES (36745, 28, 874);
INSERT INTO `sys_role_menu` VALUES (36746, 28, 289);
INSERT INTO `sys_role_menu` VALUES (36747, 28, 805);
INSERT INTO `sys_role_menu` VALUES (36748, 28, 631);
INSERT INTO `sys_role_menu` VALUES (36749, 28, 659);
INSERT INTO `sys_role_menu` VALUES (36750, 28, 660);
INSERT INTO `sys_role_menu` VALUES (36751, 28, 290);
INSERT INTO `sys_role_menu` VALUES (36752, 28, 291);
INSERT INTO `sys_role_menu` VALUES (36753, 28, 293);
INSERT INTO `sys_role_menu` VALUES (36754, 28, 444);
INSERT INTO `sys_role_menu` VALUES (36755, 28, 806);
INSERT INTO `sys_role_menu` VALUES (36756, 28, 664);
INSERT INTO `sys_role_menu` VALUES (36757, 28, 674);
INSERT INTO `sys_role_menu` VALUES (36758, 28, 748);
INSERT INTO `sys_role_menu` VALUES (36759, 28, 448);
INSERT INTO `sys_role_menu` VALUES (36760, 28, 447);
INSERT INTO `sys_role_menu` VALUES (36761, 28, 445);
INSERT INTO `sys_role_menu` VALUES (36762, 28, 670);
INSERT INTO `sys_role_menu` VALUES (36763, 28, 672);
INSERT INTO `sys_role_menu` VALUES (36764, 28, 671);
INSERT INTO `sys_role_menu` VALUES (36765, 28, 673);
INSERT INTO `sys_role_menu` VALUES (36766, 28, 772);
INSERT INTO `sys_role_menu` VALUES (36767, 28, 773);
INSERT INTO `sys_role_menu` VALUES (36768, 28, 774);
INSERT INTO `sys_role_menu` VALUES (36769, 28, 775);
INSERT INTO `sys_role_menu` VALUES (36770, 28, 776);
INSERT INTO `sys_role_menu` VALUES (36771, 28, 639);
INSERT INTO `sys_role_menu` VALUES (36772, 28, 640);
INSERT INTO `sys_role_menu` VALUES (36773, 28, 200);
INSERT INTO `sys_role_menu` VALUES (36774, 28, 777);
INSERT INTO `sys_role_menu` VALUES (36775, 28, 778);
INSERT INTO `sys_role_menu` VALUES (36776, 28, 783);
INSERT INTO `sys_role_menu` VALUES (36777, 28, 201);
INSERT INTO `sys_role_menu` VALUES (36778, 28, 393);
INSERT INTO `sys_role_menu` VALUES (36779, 28, 661);
INSERT INTO `sys_role_menu` VALUES (36780, 28, 662);
INSERT INTO `sys_role_menu` VALUES (36781, 28, 663);
INSERT INTO `sys_role_menu` VALUES (36782, 28, 202);
INSERT INTO `sys_role_menu` VALUES (36783, 28, 203);
INSERT INTO `sys_role_menu` VALUES (36784, 28, 204);
INSERT INTO `sys_role_menu` VALUES (36785, 28, 205);
INSERT INTO `sys_role_menu` VALUES (36786, 28, 779);
INSERT INTO `sys_role_menu` VALUES (36787, 28, 782);
INSERT INTO `sys_role_menu` VALUES (36788, 28, 850);
INSERT INTO `sys_role_menu` VALUES (36789, 28, 834);
INSERT INTO `sys_role_menu` VALUES (36790, 28, 835);
INSERT INTO `sys_role_menu` VALUES (36791, 28, 836);
INSERT INTO `sys_role_menu` VALUES (36792, 28, 837);
INSERT INTO `sys_role_menu` VALUES (36793, 28, 763);
INSERT INTO `sys_role_menu` VALUES (36794, 28, 771);
INSERT INTO `sys_role_menu` VALUES (36795, 28, 762);
INSERT INTO `sys_role_menu` VALUES (36796, 28, 764);
INSERT INTO `sys_role_menu` VALUES (36797, 28, 765);
INSERT INTO `sys_role_menu` VALUES (36798, 28, 374);
INSERT INTO `sys_role_menu` VALUES (36799, 28, 627);
INSERT INTO `sys_role_menu` VALUES (36800, 28, 804);
INSERT INTO `sys_role_menu` VALUES (36801, 28, 628);
INSERT INTO `sys_role_menu` VALUES (36802, 28, 629);
INSERT INTO `sys_role_menu` VALUES (36803, 28, 630);
INSERT INTO `sys_role_menu` VALUES (36804, 28, 633);
INSERT INTO `sys_role_menu` VALUES (36805, 28, 651);
INSERT INTO `sys_role_menu` VALUES (36806, 28, 382);
INSERT INTO `sys_role_menu` VALUES (36807, 28, 360);
INSERT INTO `sys_role_menu` VALUES (36808, 28, 653);
INSERT INTO `sys_role_menu` VALUES (36809, 28, 665);
INSERT INTO `sys_role_menu` VALUES (36810, 28, 669);
INSERT INTO `sys_role_menu` VALUES (36811, 28, 676);
INSERT INTO `sys_role_menu` VALUES (36812, 28, 449);
INSERT INTO `sys_role_menu` VALUES (36813, 28, 719);
INSERT INTO `sys_role_menu` VALUES (36814, 28, 720);
INSERT INTO `sys_role_menu` VALUES (36815, 28, 295);
INSERT INTO `sys_role_menu` VALUES (36816, 28, 614);
INSERT INTO `sys_role_menu` VALUES (36817, 28, 615);
INSERT INTO `sys_role_menu` VALUES (36818, 28, 751);
INSERT INTO `sys_role_menu` VALUES (36819, 28, 752);
INSERT INTO `sys_role_menu` VALUES (36820, 28, 753);
INSERT INTO `sys_role_menu` VALUES (36821, 28, 616);
INSERT INTO `sys_role_menu` VALUES (36822, 28, 666);
INSERT INTO `sys_role_menu` VALUES (36823, 28, 667);
INSERT INTO `sys_role_menu` VALUES (36824, 28, 617);
INSERT INTO `sys_role_menu` VALUES (36825, 28, 795);
INSERT INTO `sys_role_menu` VALUES (36826, 28, 796);
INSERT INTO `sys_role_menu` VALUES (36827, 28, 800);
INSERT INTO `sys_role_menu` VALUES (36828, 28, 807);
INSERT INTO `sys_role_menu` VALUES (38245, 25, 859);
INSERT INTO `sys_role_menu` VALUES (38246, 25, 860);
INSERT INTO `sys_role_menu` VALUES (38247, 25, 861);
INSERT INTO `sys_role_menu` VALUES (38248, 25, 862);
INSERT INTO `sys_role_menu` VALUES (38249, 25, 863);
INSERT INTO `sys_role_menu` VALUES (38250, 25, 366);
INSERT INTO `sys_role_menu` VALUES (38251, 25, 427);
INSERT INTO `sys_role_menu` VALUES (38252, 25, 750);
INSERT INTO `sys_role_menu` VALUES (38253, 25, 357);
INSERT INTO `sys_role_menu` VALUES (38254, 25, 289);
INSERT INTO `sys_role_menu` VALUES (38255, 25, 805);
INSERT INTO `sys_role_menu` VALUES (38256, 25, 660);
INSERT INTO `sys_role_menu` VALUES (38257, 25, 290);
INSERT INTO `sys_role_menu` VALUES (38258, 25, 444);
INSERT INTO `sys_role_menu` VALUES (38259, 25, 806);
INSERT INTO `sys_role_menu` VALUES (38260, 25, 664);
INSERT INTO `sys_role_menu` VALUES (38261, 25, 623);
INSERT INTO `sys_role_menu` VALUES (38262, 25, 625);
INSERT INTO `sys_role_menu` VALUES (38263, 25, 763);
INSERT INTO `sys_role_menu` VALUES (38264, 25, 762);
INSERT INTO `sys_role_menu` VALUES (38265, 25, 374);
INSERT INTO `sys_role_menu` VALUES (38266, 25, 627);
INSERT INTO `sys_role_menu` VALUES (38267, 25, 804);
INSERT INTO `sys_role_menu` VALUES (38268, 25, 628);
INSERT INTO `sys_role_menu` VALUES (38269, 25, 898);
INSERT INTO `sys_role_menu` VALUES (38270, 25, 899);
INSERT INTO `sys_role_menu` VALUES (38271, 25, 900);
INSERT INTO `sys_role_menu` VALUES (38272, 25, 901);
INSERT INTO `sys_role_menu` VALUES (38273, 25, 902);
INSERT INTO `sys_role_menu` VALUES (38274, 25, 795);
INSERT INTO `sys_role_menu` VALUES (38275, 25, 853);
INSERT INTO `sys_role_menu` VALUES (38304, 18, 677);
INSERT INTO `sys_role_menu` VALUES (38305, 18, 634);
INSERT INTO `sys_role_menu` VALUES (38306, 18, 635);
INSERT INTO `sys_role_menu` VALUES (38307, 18, 636);
INSERT INTO `sys_role_menu` VALUES (38308, 18, 637);
INSERT INTO `sys_role_menu` VALUES (38309, 18, 638);
INSERT INTO `sys_role_menu` VALUES (38310, 18, 654);
INSERT INTO `sys_role_menu` VALUES (38311, 18, 655);
INSERT INTO `sys_role_menu` VALUES (38312, 18, 656);
INSERT INTO `sys_role_menu` VALUES (38313, 18, 657);
INSERT INTO `sys_role_menu` VALUES (38314, 18, 658);
INSERT INTO `sys_role_menu` VALUES (38315, 18, 678);
INSERT INTO `sys_role_menu` VALUES (38316, 18, 679);
INSERT INTO `sys_role_menu` VALUES (38317, 18, 680);
INSERT INTO `sys_role_menu` VALUES (38318, 18, 681);
INSERT INTO `sys_role_menu` VALUES (38319, 18, 682);
INSERT INTO `sys_role_menu` VALUES (38320, 18, 222);
INSERT INTO `sys_role_menu` VALUES (38321, 18, 297);
INSERT INTO `sys_role_menu` VALUES (38322, 18, 754);
INSERT INTO `sys_role_menu` VALUES (38323, 18, 298);
INSERT INTO `sys_role_menu` VALUES (38324, 18, 299);
INSERT INTO `sys_role_menu` VALUES (38325, 18, 300);
INSERT INTO `sys_role_menu` VALUES (38326, 18, 301);
INSERT INTO `sys_role_menu` VALUES (38327, 18, 407);
INSERT INTO `sys_role_menu` VALUES (38328, 18, 408);
INSERT INTO `sys_role_menu` VALUES (38329, 18, 409);
INSERT INTO `sys_role_menu` VALUES (38330, 18, 410);
INSERT INTO `sys_role_menu` VALUES (38331, 18, 411);
INSERT INTO `sys_role_menu` VALUES (38332, 18, 618);
INSERT INTO `sys_role_menu` VALUES (38333, 18, 619);
INSERT INTO `sys_role_menu` VALUES (38334, 18, 620);
INSERT INTO `sys_role_menu` VALUES (38335, 18, 621);
INSERT INTO `sys_role_menu` VALUES (38336, 18, 622);
INSERT INTO `sys_role_menu` VALUES (38337, 18, 254);
INSERT INTO `sys_role_menu` VALUES (38338, 18, 755);
INSERT INTO `sys_role_menu` VALUES (38339, 18, 256);
INSERT INTO `sys_role_menu` VALUES (38340, 18, 257);
INSERT INTO `sys_role_menu` VALUES (38341, 18, 258);
INSERT INTO `sys_role_menu` VALUES (38342, 18, 255);
INSERT INTO `sys_role_menu` VALUES (38343, 18, 641);
INSERT INTO `sys_role_menu` VALUES (38344, 18, 642);
INSERT INTO `sys_role_menu` VALUES (38345, 18, 643);
INSERT INTO `sys_role_menu` VALUES (38346, 18, 644);
INSERT INTO `sys_role_menu` VALUES (38347, 18, 645);
INSERT INTO `sys_role_menu` VALUES (38348, 18, 646);
INSERT INTO `sys_role_menu` VALUES (38349, 18, 647);
INSERT INTO `sys_role_menu` VALUES (38350, 18, 648);
INSERT INTO `sys_role_menu` VALUES (38351, 18, 649);
INSERT INTO `sys_role_menu` VALUES (38352, 18, 650);
INSERT INTO `sys_role_menu` VALUES (38353, 18, 875);
INSERT INTO `sys_role_menu` VALUES (38354, 18, 876);
INSERT INTO `sys_role_menu` VALUES (38355, 18, 877);
INSERT INTO `sys_role_menu` VALUES (38356, 18, 878);
INSERT INTO `sys_role_menu` VALUES (38357, 18, 879);
INSERT INTO `sys_role_menu` VALUES (38358, 18, 880);
INSERT INTO `sys_role_menu` VALUES (38359, 18, 881);
INSERT INTO `sys_role_menu` VALUES (38360, 18, 882);
INSERT INTO `sys_role_menu` VALUES (38361, 18, 883);
INSERT INTO `sys_role_menu` VALUES (38362, 18, 884);
INSERT INTO `sys_role_menu` VALUES (38363, 18, 885);
INSERT INTO `sys_role_menu` VALUES (38364, 18, 366);
INSERT INTO `sys_role_menu` VALUES (38365, 18, 887);
INSERT INTO `sys_role_menu` VALUES (38366, 18, 427);
INSERT INTO `sys_role_menu` VALUES (38367, 18, 652);
INSERT INTO `sys_role_menu` VALUES (38368, 18, 747);
INSERT INTO `sys_role_menu` VALUES (38369, 18, 750);
INSERT INTO `sys_role_menu` VALUES (38370, 18, 428);
INSERT INTO `sys_role_menu` VALUES (38371, 18, 429);
INSERT INTO `sys_role_menu` VALUES (38372, 18, 430);
INSERT INTO `sys_role_menu` VALUES (38373, 18, 431);
INSERT INTO `sys_role_menu` VALUES (38374, 18, 357);
INSERT INTO `sys_role_menu` VALUES (38375, 18, 816);
INSERT INTO `sys_role_menu` VALUES (38376, 18, 817);
INSERT INTO `sys_role_menu` VALUES (38377, 18, 818);
INSERT INTO `sys_role_menu` VALUES (38378, 18, 819);
INSERT INTO `sys_role_menu` VALUES (38379, 18, 820);
INSERT INTO `sys_role_menu` VALUES (38380, 18, 821);
INSERT INTO `sys_role_menu` VALUES (38381, 18, 822);
INSERT INTO `sys_role_menu` VALUES (38382, 18, 864);
INSERT INTO `sys_role_menu` VALUES (38383, 18, 870);
INSERT INTO `sys_role_menu` VALUES (38384, 18, 871);
INSERT INTO `sys_role_menu` VALUES (38385, 18, 872);
INSERT INTO `sys_role_menu` VALUES (38386, 18, 873);
INSERT INTO `sys_role_menu` VALUES (38387, 18, 874);
INSERT INTO `sys_role_menu` VALUES (38388, 18, 289);
INSERT INTO `sys_role_menu` VALUES (38389, 18, 805);
INSERT INTO `sys_role_menu` VALUES (38390, 18, 631);
INSERT INTO `sys_role_menu` VALUES (38391, 18, 659);
INSERT INTO `sys_role_menu` VALUES (38392, 18, 660);
INSERT INTO `sys_role_menu` VALUES (38393, 18, 290);
INSERT INTO `sys_role_menu` VALUES (38394, 18, 291);
INSERT INTO `sys_role_menu` VALUES (38395, 18, 292);
INSERT INTO `sys_role_menu` VALUES (38396, 18, 293);
INSERT INTO `sys_role_menu` VALUES (38397, 18, 444);
INSERT INTO `sys_role_menu` VALUES (38398, 18, 806);
INSERT INTO `sys_role_menu` VALUES (38399, 18, 664);
INSERT INTO `sys_role_menu` VALUES (38400, 18, 674);
INSERT INTO `sys_role_menu` VALUES (38401, 18, 748);
INSERT INTO `sys_role_menu` VALUES (38402, 18, 448);
INSERT INTO `sys_role_menu` VALUES (38403, 18, 447);
INSERT INTO `sys_role_menu` VALUES (38404, 18, 445);
INSERT INTO `sys_role_menu` VALUES (38405, 18, 670);
INSERT INTO `sys_role_menu` VALUES (38406, 18, 672);
INSERT INTO `sys_role_menu` VALUES (38407, 18, 671);
INSERT INTO `sys_role_menu` VALUES (38408, 18, 673);
INSERT INTO `sys_role_menu` VALUES (38409, 18, 772);
INSERT INTO `sys_role_menu` VALUES (38410, 18, 773);
INSERT INTO `sys_role_menu` VALUES (38411, 18, 774);
INSERT INTO `sys_role_menu` VALUES (38412, 18, 775);
INSERT INTO `sys_role_menu` VALUES (38413, 18, 776);
INSERT INTO `sys_role_menu` VALUES (38414, 18, 639);
INSERT INTO `sys_role_menu` VALUES (38415, 18, 640);
INSERT INTO `sys_role_menu` VALUES (38416, 18, 200);
INSERT INTO `sys_role_menu` VALUES (38417, 18, 777);
INSERT INTO `sys_role_menu` VALUES (38418, 18, 778);
INSERT INTO `sys_role_menu` VALUES (38419, 18, 783);
INSERT INTO `sys_role_menu` VALUES (38420, 18, 201);
INSERT INTO `sys_role_menu` VALUES (38421, 18, 393);
INSERT INTO `sys_role_menu` VALUES (38422, 18, 661);
INSERT INTO `sys_role_menu` VALUES (38423, 18, 662);
INSERT INTO `sys_role_menu` VALUES (38424, 18, 663);
INSERT INTO `sys_role_menu` VALUES (38425, 18, 202);
INSERT INTO `sys_role_menu` VALUES (38426, 18, 203);
INSERT INTO `sys_role_menu` VALUES (38427, 18, 204);
INSERT INTO `sys_role_menu` VALUES (38428, 18, 205);
INSERT INTO `sys_role_menu` VALUES (38429, 18, 779);
INSERT INTO `sys_role_menu` VALUES (38430, 18, 782);
INSERT INTO `sys_role_menu` VALUES (38431, 18, 850);
INSERT INTO `sys_role_menu` VALUES (38432, 18, 834);
INSERT INTO `sys_role_menu` VALUES (38433, 18, 835);
INSERT INTO `sys_role_menu` VALUES (38434, 18, 836);
INSERT INTO `sys_role_menu` VALUES (38435, 18, 837);
INSERT INTO `sys_role_menu` VALUES (38436, 18, 763);
INSERT INTO `sys_role_menu` VALUES (38437, 18, 771);
INSERT INTO `sys_role_menu` VALUES (38438, 18, 762);
INSERT INTO `sys_role_menu` VALUES (38439, 18, 764);
INSERT INTO `sys_role_menu` VALUES (38440, 18, 765);
INSERT INTO `sys_role_menu` VALUES (38441, 18, 374);
INSERT INTO `sys_role_menu` VALUES (38442, 18, 627);
INSERT INTO `sys_role_menu` VALUES (38443, 18, 804);
INSERT INTO `sys_role_menu` VALUES (38444, 18, 628);
INSERT INTO `sys_role_menu` VALUES (38445, 18, 629);
INSERT INTO `sys_role_menu` VALUES (38446, 18, 630);
INSERT INTO `sys_role_menu` VALUES (38447, 18, 633);
INSERT INTO `sys_role_menu` VALUES (38448, 18, 651);
INSERT INTO `sys_role_menu` VALUES (38449, 18, 382);
INSERT INTO `sys_role_menu` VALUES (38450, 18, 360);
INSERT INTO `sys_role_menu` VALUES (38451, 18, 653);
INSERT INTO `sys_role_menu` VALUES (38452, 18, 665);
INSERT INTO `sys_role_menu` VALUES (38453, 18, 669);
INSERT INTO `sys_role_menu` VALUES (38454, 18, 676);
INSERT INTO `sys_role_menu` VALUES (38455, 18, 449);
INSERT INTO `sys_role_menu` VALUES (38456, 18, 719);
INSERT INTO `sys_role_menu` VALUES (38457, 18, 720);
INSERT INTO `sys_role_menu` VALUES (38458, 18, 295);
INSERT INTO `sys_role_menu` VALUES (38459, 18, 614);
INSERT INTO `sys_role_menu` VALUES (38460, 18, 615);
INSERT INTO `sys_role_menu` VALUES (38461, 18, 898);
INSERT INTO `sys_role_menu` VALUES (38462, 18, 899);
INSERT INTO `sys_role_menu` VALUES (38463, 18, 901);
INSERT INTO `sys_role_menu` VALUES (38464, 18, 751);
INSERT INTO `sys_role_menu` VALUES (38465, 18, 752);
INSERT INTO `sys_role_menu` VALUES (38466, 18, 753);
INSERT INTO `sys_role_menu` VALUES (38467, 18, 616);
INSERT INTO `sys_role_menu` VALUES (38468, 18, 666);
INSERT INTO `sys_role_menu` VALUES (38469, 18, 667);
INSERT INTO `sys_role_menu` VALUES (38470, 18, 617);
INSERT INTO `sys_role_menu` VALUES (38471, 18, 795);
INSERT INTO `sys_role_menu` VALUES (38472, 18, 796);
INSERT INTO `sys_role_menu` VALUES (38473, 18, 800);
INSERT INTO `sys_role_menu` VALUES (38474, 18, 807);
INSERT INTO `sys_role_menu` VALUES (38475, 18, 809);
INSERT INTO `sys_role_menu` VALUES (38476, 18, 810);
INSERT INTO `sys_role_menu` VALUES (38477, 18, 811);
INSERT INTO `sys_role_menu` VALUES (38478, 18, 813);
INSERT INTO `sys_role_menu` VALUES (38479, 18, 815);
INSERT INTO `sys_role_menu` VALUES (38480, 18, 853);
INSERT INTO `sys_role_menu` VALUES (38481, 18, 797);
INSERT INTO `sys_role_menu` VALUES (38482, 18, 798);
INSERT INTO `sys_role_menu` VALUES (38483, 18, 799);
INSERT INTO `sys_role_menu` VALUES (38484, 18, 801);
INSERT INTO `sys_role_menu` VALUES (38485, 18, 802);
INSERT INTO `sys_role_menu` VALUES (38486, 18, 1);
INSERT INTO `sys_role_menu` VALUES (38487, 18, 30);
INSERT INTO `sys_role_menu` VALUES (38488, 29, 859);
INSERT INTO `sys_role_menu` VALUES (38489, 29, 860);
INSERT INTO `sys_role_menu` VALUES (38490, 29, 861);
INSERT INTO `sys_role_menu` VALUES (38491, 29, 862);
INSERT INTO `sys_role_menu` VALUES (38492, 29, 863);
INSERT INTO `sys_role_menu` VALUES (38493, 29, 759);
INSERT INTO `sys_role_menu` VALUES (38494, 29, 677);
INSERT INTO `sys_role_menu` VALUES (38495, 29, 634);
INSERT INTO `sys_role_menu` VALUES (38496, 29, 635);
INSERT INTO `sys_role_menu` VALUES (38497, 29, 636);
INSERT INTO `sys_role_menu` VALUES (38498, 29, 637);
INSERT INTO `sys_role_menu` VALUES (38499, 29, 638);
INSERT INTO `sys_role_menu` VALUES (38500, 29, 654);
INSERT INTO `sys_role_menu` VALUES (38501, 29, 655);
INSERT INTO `sys_role_menu` VALUES (38502, 29, 656);
INSERT INTO `sys_role_menu` VALUES (38503, 29, 657);
INSERT INTO `sys_role_menu` VALUES (38504, 29, 658);
INSERT INTO `sys_role_menu` VALUES (38505, 29, 678);
INSERT INTO `sys_role_menu` VALUES (38506, 29, 679);
INSERT INTO `sys_role_menu` VALUES (38507, 29, 680);
INSERT INTO `sys_role_menu` VALUES (38508, 29, 681);
INSERT INTO `sys_role_menu` VALUES (38509, 29, 682);
INSERT INTO `sys_role_menu` VALUES (38510, 29, 893);
INSERT INTO `sys_role_menu` VALUES (38511, 29, 894);
INSERT INTO `sys_role_menu` VALUES (38512, 29, 895);
INSERT INTO `sys_role_menu` VALUES (38513, 29, 897);
INSERT INTO `sys_role_menu` VALUES (38514, 29, 222);
INSERT INTO `sys_role_menu` VALUES (38515, 29, 297);
INSERT INTO `sys_role_menu` VALUES (38516, 29, 754);
INSERT INTO `sys_role_menu` VALUES (38517, 29, 298);
INSERT INTO `sys_role_menu` VALUES (38518, 29, 299);
INSERT INTO `sys_role_menu` VALUES (38519, 29, 300);
INSERT INTO `sys_role_menu` VALUES (38520, 29, 301);
INSERT INTO `sys_role_menu` VALUES (38521, 29, 609);
INSERT INTO `sys_role_menu` VALUES (38522, 29, 756);
INSERT INTO `sys_role_menu` VALUES (38523, 29, 610);
INSERT INTO `sys_role_menu` VALUES (38524, 29, 611);
INSERT INTO `sys_role_menu` VALUES (38525, 29, 612);
INSERT INTO `sys_role_menu` VALUES (38526, 29, 613);
INSERT INTO `sys_role_menu` VALUES (38527, 29, 407);
INSERT INTO `sys_role_menu` VALUES (38528, 29, 408);
INSERT INTO `sys_role_menu` VALUES (38529, 29, 409);
INSERT INTO `sys_role_menu` VALUES (38530, 29, 410);
INSERT INTO `sys_role_menu` VALUES (38531, 29, 411);
INSERT INTO `sys_role_menu` VALUES (38532, 29, 618);
INSERT INTO `sys_role_menu` VALUES (38533, 29, 619);
INSERT INTO `sys_role_menu` VALUES (38534, 29, 620);
INSERT INTO `sys_role_menu` VALUES (38535, 29, 621);
INSERT INTO `sys_role_menu` VALUES (38536, 29, 622);
INSERT INTO `sys_role_menu` VALUES (38537, 29, 254);
INSERT INTO `sys_role_menu` VALUES (38538, 29, 755);
INSERT INTO `sys_role_menu` VALUES (38539, 29, 256);
INSERT INTO `sys_role_menu` VALUES (38540, 29, 257);
INSERT INTO `sys_role_menu` VALUES (38541, 29, 258);
INSERT INTO `sys_role_menu` VALUES (38542, 29, 255);
INSERT INTO `sys_role_menu` VALUES (38543, 29, 745);
INSERT INTO `sys_role_menu` VALUES (38544, 29, 746);
INSERT INTO `sys_role_menu` VALUES (38545, 29, 315);
INSERT INTO `sys_role_menu` VALUES (38546, 29, 316);
INSERT INTO `sys_role_menu` VALUES (38547, 29, 317);
INSERT INTO `sys_role_menu` VALUES (38548, 29, 318);
INSERT INTO `sys_role_menu` VALUES (38549, 29, 319);
INSERT INTO `sys_role_menu` VALUES (38550, 29, 325);
INSERT INTO `sys_role_menu` VALUES (38551, 29, 326);
INSERT INTO `sys_role_menu` VALUES (38552, 29, 327);
INSERT INTO `sys_role_menu` VALUES (38553, 29, 328);
INSERT INTO `sys_role_menu` VALUES (38554, 29, 329);
INSERT INTO `sys_role_menu` VALUES (38555, 29, 417);
INSERT INTO `sys_role_menu` VALUES (38556, 29, 418);
INSERT INTO `sys_role_menu` VALUES (38557, 29, 419);
INSERT INTO `sys_role_menu` VALUES (38558, 29, 420);
INSERT INTO `sys_role_menu` VALUES (38559, 29, 421);
INSERT INTO `sys_role_menu` VALUES (38560, 29, 412);
INSERT INTO `sys_role_menu` VALUES (38561, 29, 413);
INSERT INTO `sys_role_menu` VALUES (38562, 29, 414);
INSERT INTO `sys_role_menu` VALUES (38563, 29, 415);
INSERT INTO `sys_role_menu` VALUES (38564, 29, 416);
INSERT INTO `sys_role_menu` VALUES (38565, 29, 641);
INSERT INTO `sys_role_menu` VALUES (38566, 29, 642);
INSERT INTO `sys_role_menu` VALUES (38567, 29, 643);
INSERT INTO `sys_role_menu` VALUES (38568, 29, 644);
INSERT INTO `sys_role_menu` VALUES (38569, 29, 645);
INSERT INTO `sys_role_menu` VALUES (38570, 29, 646);
INSERT INTO `sys_role_menu` VALUES (38571, 29, 647);
INSERT INTO `sys_role_menu` VALUES (38572, 29, 648);
INSERT INTO `sys_role_menu` VALUES (38573, 29, 649);
INSERT INTO `sys_role_menu` VALUES (38574, 29, 650);
INSERT INTO `sys_role_menu` VALUES (38575, 29, 875);
INSERT INTO `sys_role_menu` VALUES (38576, 29, 876);
INSERT INTO `sys_role_menu` VALUES (38577, 29, 877);
INSERT INTO `sys_role_menu` VALUES (38578, 29, 878);
INSERT INTO `sys_role_menu` VALUES (38579, 29, 879);
INSERT INTO `sys_role_menu` VALUES (38580, 29, 880);
INSERT INTO `sys_role_menu` VALUES (38581, 29, 881);
INSERT INTO `sys_role_menu` VALUES (38582, 29, 882);
INSERT INTO `sys_role_menu` VALUES (38583, 29, 883);
INSERT INTO `sys_role_menu` VALUES (38584, 29, 884);
INSERT INTO `sys_role_menu` VALUES (38585, 29, 885);
INSERT INTO `sys_role_menu` VALUES (38586, 29, 366);
INSERT INTO `sys_role_menu` VALUES (38587, 29, 887);
INSERT INTO `sys_role_menu` VALUES (38588, 29, 427);
INSERT INTO `sys_role_menu` VALUES (38589, 29, 652);
INSERT INTO `sys_role_menu` VALUES (38590, 29, 747);
INSERT INTO `sys_role_menu` VALUES (38591, 29, 750);
INSERT INTO `sys_role_menu` VALUES (38592, 29, 428);
INSERT INTO `sys_role_menu` VALUES (38593, 29, 429);
INSERT INTO `sys_role_menu` VALUES (38594, 29, 430);
INSERT INTO `sys_role_menu` VALUES (38595, 29, 431);
INSERT INTO `sys_role_menu` VALUES (38596, 29, 422);
INSERT INTO `sys_role_menu` VALUES (38597, 29, 423);
INSERT INTO `sys_role_menu` VALUES (38598, 29, 424);
INSERT INTO `sys_role_menu` VALUES (38599, 29, 425);
INSERT INTO `sys_role_menu` VALUES (38600, 29, 426);
INSERT INTO `sys_role_menu` VALUES (38601, 29, 357);
INSERT INTO `sys_role_menu` VALUES (38602, 29, 816);
INSERT INTO `sys_role_menu` VALUES (38603, 29, 817);
INSERT INTO `sys_role_menu` VALUES (38604, 29, 818);
INSERT INTO `sys_role_menu` VALUES (38605, 29, 819);
INSERT INTO `sys_role_menu` VALUES (38606, 29, 820);
INSERT INTO `sys_role_menu` VALUES (38607, 29, 821);
INSERT INTO `sys_role_menu` VALUES (38608, 29, 822);
INSERT INTO `sys_role_menu` VALUES (38609, 29, 864);
INSERT INTO `sys_role_menu` VALUES (38610, 29, 870);
INSERT INTO `sys_role_menu` VALUES (38611, 29, 871);
INSERT INTO `sys_role_menu` VALUES (38612, 29, 872);
INSERT INTO `sys_role_menu` VALUES (38613, 29, 873);
INSERT INTO `sys_role_menu` VALUES (38614, 29, 874);
INSERT INTO `sys_role_menu` VALUES (38615, 29, 289);
INSERT INTO `sys_role_menu` VALUES (38616, 29, 805);
INSERT INTO `sys_role_menu` VALUES (38617, 29, 631);
INSERT INTO `sys_role_menu` VALUES (38618, 29, 659);
INSERT INTO `sys_role_menu` VALUES (38619, 29, 660);
INSERT INTO `sys_role_menu` VALUES (38620, 29, 290);
INSERT INTO `sys_role_menu` VALUES (38621, 29, 291);
INSERT INTO `sys_role_menu` VALUES (38622, 29, 292);
INSERT INTO `sys_role_menu` VALUES (38623, 29, 293);
INSERT INTO `sys_role_menu` VALUES (38624, 29, 444);
INSERT INTO `sys_role_menu` VALUES (38625, 29, 806);
INSERT INTO `sys_role_menu` VALUES (38626, 29, 664);
INSERT INTO `sys_role_menu` VALUES (38627, 29, 674);
INSERT INTO `sys_role_menu` VALUES (38628, 29, 748);
INSERT INTO `sys_role_menu` VALUES (38629, 29, 448);
INSERT INTO `sys_role_menu` VALUES (38630, 29, 447);
INSERT INTO `sys_role_menu` VALUES (38631, 29, 445);
INSERT INTO `sys_role_menu` VALUES (38632, 29, 623);
INSERT INTO `sys_role_menu` VALUES (38633, 29, 624);
INSERT INTO `sys_role_menu` VALUES (38634, 29, 625);
INSERT INTO `sys_role_menu` VALUES (38635, 29, 626);
INSERT INTO `sys_role_menu` VALUES (38636, 29, 670);
INSERT INTO `sys_role_menu` VALUES (38637, 29, 672);
INSERT INTO `sys_role_menu` VALUES (38638, 29, 671);
INSERT INTO `sys_role_menu` VALUES (38639, 29, 673);
INSERT INTO `sys_role_menu` VALUES (38640, 29, 772);
INSERT INTO `sys_role_menu` VALUES (38641, 29, 773);
INSERT INTO `sys_role_menu` VALUES (38642, 29, 774);
INSERT INTO `sys_role_menu` VALUES (38643, 29, 775);
INSERT INTO `sys_role_menu` VALUES (38644, 29, 776);
INSERT INTO `sys_role_menu` VALUES (38645, 29, 766);
INSERT INTO `sys_role_menu` VALUES (38646, 29, 768);
INSERT INTO `sys_role_menu` VALUES (38647, 29, 769);
INSERT INTO `sys_role_menu` VALUES (38648, 29, 770);
INSERT INTO `sys_role_menu` VALUES (38649, 29, 767);
INSERT INTO `sys_role_menu` VALUES (38650, 29, 336);
INSERT INTO `sys_role_menu` VALUES (38651, 29, 341);
INSERT INTO `sys_role_menu` VALUES (38652, 29, 337);
INSERT INTO `sys_role_menu` VALUES (38653, 29, 338);
INSERT INTO `sys_role_menu` VALUES (38654, 29, 339);
INSERT INTO `sys_role_menu` VALUES (38655, 29, 340);
INSERT INTO `sys_role_menu` VALUES (38656, 29, 358);
INSERT INTO `sys_role_menu` VALUES (38657, 29, 359);
INSERT INTO `sys_role_menu` VALUES (38658, 29, 639);
INSERT INTO `sys_role_menu` VALUES (38659, 29, 640);
INSERT INTO `sys_role_menu` VALUES (38660, 29, 200);
INSERT INTO `sys_role_menu` VALUES (38661, 29, 201);
INSERT INTO `sys_role_menu` VALUES (38662, 29, 393);
INSERT INTO `sys_role_menu` VALUES (38663, 29, 661);
INSERT INTO `sys_role_menu` VALUES (38664, 29, 662);
INSERT INTO `sys_role_menu` VALUES (38665, 29, 663);
INSERT INTO `sys_role_menu` VALUES (38666, 29, 202);
INSERT INTO `sys_role_menu` VALUES (38667, 29, 203);
INSERT INTO `sys_role_menu` VALUES (38668, 29, 204);
INSERT INTO `sys_role_menu` VALUES (38669, 29, 205);
INSERT INTO `sys_role_menu` VALUES (38670, 29, 264);
INSERT INTO `sys_role_menu` VALUES (38671, 29, 265);
INSERT INTO `sys_role_menu` VALUES (38672, 29, 266);
INSERT INTO `sys_role_menu` VALUES (38673, 29, 394);
INSERT INTO `sys_role_menu` VALUES (38674, 29, 395);
INSERT INTO `sys_role_menu` VALUES (38675, 29, 396);
INSERT INTO `sys_role_menu` VALUES (38676, 29, 779);
INSERT INTO `sys_role_menu` VALUES (38677, 29, 780);
INSERT INTO `sys_role_menu` VALUES (38678, 29, 781);
INSERT INTO `sys_role_menu` VALUES (38679, 29, 782);
INSERT INTO `sys_role_menu` VALUES (38680, 29, 839);
INSERT INTO `sys_role_menu` VALUES (38681, 29, 840);
INSERT INTO `sys_role_menu` VALUES (38682, 29, 841);
INSERT INTO `sys_role_menu` VALUES (38683, 29, 842);
INSERT INTO `sys_role_menu` VALUES (38684, 29, 843);
INSERT INTO `sys_role_menu` VALUES (38685, 29, 844);
INSERT INTO `sys_role_menu` VALUES (38686, 29, 845);
INSERT INTO `sys_role_menu` VALUES (38687, 29, 846);
INSERT INTO `sys_role_menu` VALUES (38688, 29, 850);
INSERT INTO `sys_role_menu` VALUES (38689, 29, 834);
INSERT INTO `sys_role_menu` VALUES (38690, 29, 835);
INSERT INTO `sys_role_menu` VALUES (38691, 29, 836);
INSERT INTO `sys_role_menu` VALUES (38692, 29, 837);
INSERT INTO `sys_role_menu` VALUES (38693, 29, 763);
INSERT INTO `sys_role_menu` VALUES (38694, 29, 771);
INSERT INTO `sys_role_menu` VALUES (38695, 29, 762);
INSERT INTO `sys_role_menu` VALUES (38696, 29, 764);
INSERT INTO `sys_role_menu` VALUES (38697, 29, 765);
INSERT INTO `sys_role_menu` VALUES (38698, 29, 374);
INSERT INTO `sys_role_menu` VALUES (38699, 29, 294);
INSERT INTO `sys_role_menu` VALUES (38700, 29, 627);
INSERT INTO `sys_role_menu` VALUES (38701, 29, 804);
INSERT INTO `sys_role_menu` VALUES (38702, 29, 628);
INSERT INTO `sys_role_menu` VALUES (38703, 29, 629);
INSERT INTO `sys_role_menu` VALUES (38704, 29, 630);
INSERT INTO `sys_role_menu` VALUES (38705, 29, 633);
INSERT INTO `sys_role_menu` VALUES (38706, 29, 651);
INSERT INTO `sys_role_menu` VALUES (38707, 29, 382);
INSERT INTO `sys_role_menu` VALUES (38708, 29, 360);
INSERT INTO `sys_role_menu` VALUES (38709, 29, 653);
INSERT INTO `sys_role_menu` VALUES (38710, 29, 665);
INSERT INTO `sys_role_menu` VALUES (38711, 29, 669);
INSERT INTO `sys_role_menu` VALUES (38712, 29, 676);
INSERT INTO `sys_role_menu` VALUES (38713, 29, 449);
INSERT INTO `sys_role_menu` VALUES (38714, 29, 719);
INSERT INTO `sys_role_menu` VALUES (38715, 29, 720);
INSERT INTO `sys_role_menu` VALUES (38716, 29, 295);
INSERT INTO `sys_role_menu` VALUES (38717, 29, 614);
INSERT INTO `sys_role_menu` VALUES (38718, 29, 615);
INSERT INTO `sys_role_menu` VALUES (38719, 29, 898);
INSERT INTO `sys_role_menu` VALUES (38720, 29, 899);
INSERT INTO `sys_role_menu` VALUES (38721, 29, 900);
INSERT INTO `sys_role_menu` VALUES (38722, 29, 901);
INSERT INTO `sys_role_menu` VALUES (38723, 29, 902);
INSERT INTO `sys_role_menu` VALUES (38724, 29, 751);
INSERT INTO `sys_role_menu` VALUES (38725, 29, 752);
INSERT INTO `sys_role_menu` VALUES (38726, 29, 753);
INSERT INTO `sys_role_menu` VALUES (38727, 29, 616);
INSERT INTO `sys_role_menu` VALUES (38728, 29, 666);
INSERT INTO `sys_role_menu` VALUES (38729, 29, 667);
INSERT INTO `sys_role_menu` VALUES (38730, 29, 617);
INSERT INTO `sys_role_menu` VALUES (38731, 29, 795);
INSERT INTO `sys_role_menu` VALUES (38732, 29, 796);
INSERT INTO `sys_role_menu` VALUES (38733, 29, 800);
INSERT INTO `sys_role_menu` VALUES (38734, 29, 807);
INSERT INTO `sys_role_menu` VALUES (38735, 29, 809);
INSERT INTO `sys_role_menu` VALUES (38736, 29, 810);
INSERT INTO `sys_role_menu` VALUES (38737, 29, 811);
INSERT INTO `sys_role_menu` VALUES (38738, 29, 813);
INSERT INTO `sys_role_menu` VALUES (38739, 29, 815);
INSERT INTO `sys_role_menu` VALUES (38740, 29, 853);
INSERT INTO `sys_role_menu` VALUES (38741, 29, 1);
INSERT INTO `sys_role_menu` VALUES (38742, 29, 714);
INSERT INTO `sys_role_menu` VALUES (38743, 29, 715);
INSERT INTO `sys_role_menu` VALUES (38744, 29, 716);
INSERT INTO `sys_role_menu` VALUES (38745, 29, 2);
INSERT INTO `sys_role_menu` VALUES (38746, 29, 15);
INSERT INTO `sys_role_menu` VALUES (38747, 29, 3);
INSERT INTO `sys_role_menu` VALUES (38748, 29, 19);
INSERT INTO `sys_role_menu` VALUES (38749, 29, 4);
INSERT INTO `sys_role_menu` VALUES (38750, 29, 23);
INSERT INTO `sys_role_menu` VALUES (38751, 29, 302);
INSERT INTO `sys_role_menu` VALUES (38752, 29, 303);
INSERT INTO `sys_role_menu` VALUES (38753, 29, 304);
INSERT INTO `sys_role_menu` VALUES (38754, 29, 305);
INSERT INTO `sys_role_menu` VALUES (38755, 29, 306);
INSERT INTO `sys_role_menu` VALUES (38756, 29, 865);
INSERT INTO `sys_role_menu` VALUES (38757, 29, 866);
INSERT INTO `sys_role_menu` VALUES (38758, 29, 867);
INSERT INTO `sys_role_menu` VALUES (38759, 29, 868);
INSERT INTO `sys_role_menu` VALUES (38760, 29, 869);
INSERT INTO `sys_role_menu` VALUES (38761, 29, 823);
INSERT INTO `sys_role_menu` VALUES (38762, 29, 825);
INSERT INTO `sys_role_menu` VALUES (38763, 29, 888);
INSERT INTO `sys_role_menu` VALUES (38764, 29, 896);
INSERT INTO `sys_role_menu` VALUES (38765, 29, 889);
INSERT INTO `sys_role_menu` VALUES (38766, 29, 890);
INSERT INTO `sys_role_menu` VALUES (38767, 29, 891);
INSERT INTO `sys_role_menu` VALUES (38768, 29, 312);
INSERT INTO `sys_role_menu` VALUES (38769, 29, 402);
INSERT INTO `sys_role_menu` VALUES (38770, 29, 403);
INSERT INTO `sys_role_menu` VALUES (38771, 29, 404);
INSERT INTO `sys_role_menu` VALUES (38772, 29, 405);
INSERT INTO `sys_role_menu` VALUES (38773, 29, 406);
INSERT INTO `sys_role_menu` VALUES (38774, 29, 397);
INSERT INTO `sys_role_menu` VALUES (38775, 29, 398);
INSERT INTO `sys_role_menu` VALUES (38776, 29, 399);
INSERT INTO `sys_role_menu` VALUES (38777, 29, 400);
INSERT INTO `sys_role_menu` VALUES (38778, 29, 401);
INSERT INTO `sys_role_menu` VALUES (38779, 29, 683);
INSERT INTO `sys_role_menu` VALUES (38780, 29, 684);
INSERT INTO `sys_role_menu` VALUES (38781, 29, 689);
INSERT INTO `sys_role_menu` VALUES (38782, 29, 690);
INSERT INTO `sys_role_menu` VALUES (38783, 29, 691);
INSERT INTO `sys_role_menu` VALUES (38784, 29, 692);
INSERT INTO `sys_role_menu` VALUES (38785, 29, 685);
INSERT INTO `sys_role_menu` VALUES (38786, 29, 693);
INSERT INTO `sys_role_menu` VALUES (38787, 29, 694);
INSERT INTO `sys_role_menu` VALUES (38788, 29, 695);
INSERT INTO `sys_role_menu` VALUES (38789, 29, 696);
INSERT INTO `sys_role_menu` VALUES (38790, 29, 686);
INSERT INTO `sys_role_menu` VALUES (38791, 29, 697);
INSERT INTO `sys_role_menu` VALUES (38792, 29, 698);
INSERT INTO `sys_role_menu` VALUES (38793, 29, 699);
INSERT INTO `sys_role_menu` VALUES (38794, 29, 700);
INSERT INTO `sys_role_menu` VALUES (38795, 29, 687);
INSERT INTO `sys_role_menu` VALUES (38796, 29, 701);
INSERT INTO `sys_role_menu` VALUES (38797, 29, 702);
INSERT INTO `sys_role_menu` VALUES (38798, 29, 703);
INSERT INTO `sys_role_menu` VALUES (38799, 29, 704);
INSERT INTO `sys_role_menu` VALUES (38800, 29, 688);
INSERT INTO `sys_role_menu` VALUES (38801, 29, 705);
INSERT INTO `sys_role_menu` VALUES (38802, 29, 713);
INSERT INTO `sys_role_menu` VALUES (38803, 29, 441);
INSERT INTO `sys_role_menu` VALUES (38804, 29, 442);
INSERT INTO `sys_role_menu` VALUES (38805, 29, 443);
INSERT INTO `sys_role_menu` VALUES (38806, 29, 455);
INSERT INTO `sys_role_menu` VALUES (38807, 29, 728);
INSERT INTO `sys_role_menu` VALUES (38808, 29, 729);
INSERT INTO `sys_role_menu` VALUES (38809, 29, 730);
INSERT INTO `sys_role_menu` VALUES (38810, 29, 735);
INSERT INTO `sys_role_menu` VALUES (38811, 29, 736);
INSERT INTO `sys_role_menu` VALUES (38812, 29, 243);
INSERT INTO `sys_role_menu` VALUES (38813, 29, 706);
INSERT INTO `sys_role_menu` VALUES (38814, 29, 707);
INSERT INTO `sys_role_menu` VALUES (38815, 29, 723);
INSERT INTO `sys_role_menu` VALUES (38816, 29, 724);
INSERT INTO `sys_role_menu` VALUES (38817, 29, 725);
INSERT INTO `sys_role_menu` VALUES (38818, 29, 726);
INSERT INTO `sys_role_menu` VALUES (38819, 29, 727);
INSERT INTO `sys_role_menu` VALUES (38820, 29, 731);
INSERT INTO `sys_role_menu` VALUES (38821, 29, 732);
INSERT INTO `sys_role_menu` VALUES (38822, 29, 733);
INSERT INTO `sys_role_menu` VALUES (38823, 29, 734);
INSERT INTO `sys_role_menu` VALUES (38824, 29, 740);
INSERT INTO `sys_role_menu` VALUES (38825, 29, 741);
INSERT INTO `sys_role_menu` VALUES (38826, 29, 742);
INSERT INTO `sys_role_menu` VALUES (38827, 29, 743);
INSERT INTO `sys_role_menu` VALUES (38828, 29, 744);
INSERT INTO `sys_role_menu` VALUES (38829, 29, 708);
INSERT INTO `sys_role_menu` VALUES (38830, 29, 709);
INSERT INTO `sys_role_menu` VALUES (38831, 29, 710);
INSERT INTO `sys_role_menu` VALUES (38832, 29, 711);
INSERT INTO `sys_role_menu` VALUES (38833, 29, 712);
INSERT INTO `sys_role_menu` VALUES (38834, 29, 737);
INSERT INTO `sys_role_menu` VALUES (38835, 29, 738);
INSERT INTO `sys_role_menu` VALUES (38836, 29, 238);
INSERT INTO `sys_role_menu` VALUES (38837, 29, 239);
INSERT INTO `sys_role_menu` VALUES (38838, 29, 240);
INSERT INTO `sys_role_menu` VALUES (38839, 29, 241);
INSERT INTO `sys_role_menu` VALUES (38840, 29, 242);
INSERT INTO `sys_role_menu` VALUES (38841, 29, 721);
INSERT INTO `sys_role_menu` VALUES (38842, 29, 722);
INSERT INTO `sys_role_menu` VALUES (38843, 29, 233);
INSERT INTO `sys_role_menu` VALUES (38844, 29, 757);
INSERT INTO `sys_role_menu` VALUES (38845, 29, 234);
INSERT INTO `sys_role_menu` VALUES (38846, 29, 235);
INSERT INTO `sys_role_menu` VALUES (38847, 29, 236);
INSERT INTO `sys_role_menu` VALUES (38848, 29, 237);
INSERT INTO `sys_role_menu` VALUES (38849, 26, 859);
INSERT INTO `sys_role_menu` VALUES (38850, 26, 860);
INSERT INTO `sys_role_menu` VALUES (38851, 26, 861);
INSERT INTO `sys_role_menu` VALUES (38852, 26, 862);
INSERT INTO `sys_role_menu` VALUES (38853, 26, 863);
INSERT INTO `sys_role_menu` VALUES (38854, 26, 759);
INSERT INTO `sys_role_menu` VALUES (38855, 26, 760);
INSERT INTO `sys_role_menu` VALUES (38856, 26, 677);
INSERT INTO `sys_role_menu` VALUES (38857, 26, 634);
INSERT INTO `sys_role_menu` VALUES (38858, 26, 635);
INSERT INTO `sys_role_menu` VALUES (38859, 26, 636);
INSERT INTO `sys_role_menu` VALUES (38860, 26, 637);
INSERT INTO `sys_role_menu` VALUES (38861, 26, 638);
INSERT INTO `sys_role_menu` VALUES (38862, 26, 654);
INSERT INTO `sys_role_menu` VALUES (38863, 26, 655);
INSERT INTO `sys_role_menu` VALUES (38864, 26, 656);
INSERT INTO `sys_role_menu` VALUES (38865, 26, 657);
INSERT INTO `sys_role_menu` VALUES (38866, 26, 658);
INSERT INTO `sys_role_menu` VALUES (38867, 26, 678);
INSERT INTO `sys_role_menu` VALUES (38868, 26, 679);
INSERT INTO `sys_role_menu` VALUES (38869, 26, 680);
INSERT INTO `sys_role_menu` VALUES (38870, 26, 681);
INSERT INTO `sys_role_menu` VALUES (38871, 26, 682);
INSERT INTO `sys_role_menu` VALUES (38872, 26, 893);
INSERT INTO `sys_role_menu` VALUES (38873, 26, 894);
INSERT INTO `sys_role_menu` VALUES (38874, 26, 895);
INSERT INTO `sys_role_menu` VALUES (38875, 26, 897);
INSERT INTO `sys_role_menu` VALUES (38876, 26, 222);
INSERT INTO `sys_role_menu` VALUES (38877, 26, 297);
INSERT INTO `sys_role_menu` VALUES (38878, 26, 754);
INSERT INTO `sys_role_menu` VALUES (38879, 26, 298);
INSERT INTO `sys_role_menu` VALUES (38880, 26, 299);
INSERT INTO `sys_role_menu` VALUES (38881, 26, 300);
INSERT INTO `sys_role_menu` VALUES (38882, 26, 301);
INSERT INTO `sys_role_menu` VALUES (38883, 26, 609);
INSERT INTO `sys_role_menu` VALUES (38884, 26, 756);
INSERT INTO `sys_role_menu` VALUES (38885, 26, 610);
INSERT INTO `sys_role_menu` VALUES (38886, 26, 611);
INSERT INTO `sys_role_menu` VALUES (38887, 26, 612);
INSERT INTO `sys_role_menu` VALUES (38888, 26, 613);
INSERT INTO `sys_role_menu` VALUES (38889, 26, 407);
INSERT INTO `sys_role_menu` VALUES (38890, 26, 408);
INSERT INTO `sys_role_menu` VALUES (38891, 26, 409);
INSERT INTO `sys_role_menu` VALUES (38892, 26, 410);
INSERT INTO `sys_role_menu` VALUES (38893, 26, 411);
INSERT INTO `sys_role_menu` VALUES (38894, 26, 618);
INSERT INTO `sys_role_menu` VALUES (38895, 26, 619);
INSERT INTO `sys_role_menu` VALUES (38896, 26, 620);
INSERT INTO `sys_role_menu` VALUES (38897, 26, 621);
INSERT INTO `sys_role_menu` VALUES (38898, 26, 622);
INSERT INTO `sys_role_menu` VALUES (38899, 26, 254);
INSERT INTO `sys_role_menu` VALUES (38900, 26, 755);
INSERT INTO `sys_role_menu` VALUES (38901, 26, 256);
INSERT INTO `sys_role_menu` VALUES (38902, 26, 257);
INSERT INTO `sys_role_menu` VALUES (38903, 26, 258);
INSERT INTO `sys_role_menu` VALUES (38904, 26, 255);
INSERT INTO `sys_role_menu` VALUES (38905, 26, 745);
INSERT INTO `sys_role_menu` VALUES (38906, 26, 746);
INSERT INTO `sys_role_menu` VALUES (38907, 26, 315);
INSERT INTO `sys_role_menu` VALUES (38908, 26, 316);
INSERT INTO `sys_role_menu` VALUES (38909, 26, 317);
INSERT INTO `sys_role_menu` VALUES (38910, 26, 318);
INSERT INTO `sys_role_menu` VALUES (38911, 26, 319);
INSERT INTO `sys_role_menu` VALUES (38912, 26, 325);
INSERT INTO `sys_role_menu` VALUES (38913, 26, 326);
INSERT INTO `sys_role_menu` VALUES (38914, 26, 327);
INSERT INTO `sys_role_menu` VALUES (38915, 26, 328);
INSERT INTO `sys_role_menu` VALUES (38916, 26, 329);
INSERT INTO `sys_role_menu` VALUES (38917, 26, 417);
INSERT INTO `sys_role_menu` VALUES (38918, 26, 418);
INSERT INTO `sys_role_menu` VALUES (38919, 26, 419);
INSERT INTO `sys_role_menu` VALUES (38920, 26, 420);
INSERT INTO `sys_role_menu` VALUES (38921, 26, 421);
INSERT INTO `sys_role_menu` VALUES (38922, 26, 412);
INSERT INTO `sys_role_menu` VALUES (38923, 26, 413);
INSERT INTO `sys_role_menu` VALUES (38924, 26, 414);
INSERT INTO `sys_role_menu` VALUES (38925, 26, 415);
INSERT INTO `sys_role_menu` VALUES (38926, 26, 416);
INSERT INTO `sys_role_menu` VALUES (38927, 26, 641);
INSERT INTO `sys_role_menu` VALUES (38928, 26, 642);
INSERT INTO `sys_role_menu` VALUES (38929, 26, 643);
INSERT INTO `sys_role_menu` VALUES (38930, 26, 644);
INSERT INTO `sys_role_menu` VALUES (38931, 26, 645);
INSERT INTO `sys_role_menu` VALUES (38932, 26, 646);
INSERT INTO `sys_role_menu` VALUES (38933, 26, 647);
INSERT INTO `sys_role_menu` VALUES (38934, 26, 648);
INSERT INTO `sys_role_menu` VALUES (38935, 26, 649);
INSERT INTO `sys_role_menu` VALUES (38936, 26, 650);
INSERT INTO `sys_role_menu` VALUES (38937, 26, 875);
INSERT INTO `sys_role_menu` VALUES (38938, 26, 876);
INSERT INTO `sys_role_menu` VALUES (38939, 26, 877);
INSERT INTO `sys_role_menu` VALUES (38940, 26, 878);
INSERT INTO `sys_role_menu` VALUES (38941, 26, 879);
INSERT INTO `sys_role_menu` VALUES (38942, 26, 880);
INSERT INTO `sys_role_menu` VALUES (38943, 26, 881);
INSERT INTO `sys_role_menu` VALUES (38944, 26, 882);
INSERT INTO `sys_role_menu` VALUES (38945, 26, 883);
INSERT INTO `sys_role_menu` VALUES (38946, 26, 884);
INSERT INTO `sys_role_menu` VALUES (38947, 26, 885);
INSERT INTO `sys_role_menu` VALUES (38948, 26, 366);
INSERT INTO `sys_role_menu` VALUES (38949, 26, 887);
INSERT INTO `sys_role_menu` VALUES (38950, 26, 427);
INSERT INTO `sys_role_menu` VALUES (38951, 26, 652);
INSERT INTO `sys_role_menu` VALUES (38952, 26, 747);
INSERT INTO `sys_role_menu` VALUES (38953, 26, 750);
INSERT INTO `sys_role_menu` VALUES (38954, 26, 428);
INSERT INTO `sys_role_menu` VALUES (38955, 26, 429);
INSERT INTO `sys_role_menu` VALUES (38956, 26, 430);
INSERT INTO `sys_role_menu` VALUES (38957, 26, 431);
INSERT INTO `sys_role_menu` VALUES (38958, 26, 422);
INSERT INTO `sys_role_menu` VALUES (38959, 26, 423);
INSERT INTO `sys_role_menu` VALUES (38960, 26, 424);
INSERT INTO `sys_role_menu` VALUES (38961, 26, 425);
INSERT INTO `sys_role_menu` VALUES (38962, 26, 426);
INSERT INTO `sys_role_menu` VALUES (38963, 26, 357);
INSERT INTO `sys_role_menu` VALUES (38964, 26, 816);
INSERT INTO `sys_role_menu` VALUES (38965, 26, 817);
INSERT INTO `sys_role_menu` VALUES (38966, 26, 818);
INSERT INTO `sys_role_menu` VALUES (38967, 26, 819);
INSERT INTO `sys_role_menu` VALUES (38968, 26, 820);
INSERT INTO `sys_role_menu` VALUES (38969, 26, 821);
INSERT INTO `sys_role_menu` VALUES (38970, 26, 822);
INSERT INTO `sys_role_menu` VALUES (38971, 26, 864);
INSERT INTO `sys_role_menu` VALUES (38972, 26, 870);
INSERT INTO `sys_role_menu` VALUES (38973, 26, 871);
INSERT INTO `sys_role_menu` VALUES (38974, 26, 872);
INSERT INTO `sys_role_menu` VALUES (38975, 26, 873);
INSERT INTO `sys_role_menu` VALUES (38976, 26, 874);
INSERT INTO `sys_role_menu` VALUES (38977, 26, 289);
INSERT INTO `sys_role_menu` VALUES (38978, 26, 805);
INSERT INTO `sys_role_menu` VALUES (38979, 26, 631);
INSERT INTO `sys_role_menu` VALUES (38980, 26, 659);
INSERT INTO `sys_role_menu` VALUES (38981, 26, 660);
INSERT INTO `sys_role_menu` VALUES (38982, 26, 290);
INSERT INTO `sys_role_menu` VALUES (38983, 26, 291);
INSERT INTO `sys_role_menu` VALUES (38984, 26, 292);
INSERT INTO `sys_role_menu` VALUES (38985, 26, 293);
INSERT INTO `sys_role_menu` VALUES (38986, 26, 444);
INSERT INTO `sys_role_menu` VALUES (38987, 26, 806);
INSERT INTO `sys_role_menu` VALUES (38988, 26, 664);
INSERT INTO `sys_role_menu` VALUES (38989, 26, 674);
INSERT INTO `sys_role_menu` VALUES (38990, 26, 748);
INSERT INTO `sys_role_menu` VALUES (38991, 26, 448);
INSERT INTO `sys_role_menu` VALUES (38992, 26, 447);
INSERT INTO `sys_role_menu` VALUES (38993, 26, 445);
INSERT INTO `sys_role_menu` VALUES (38994, 26, 623);
INSERT INTO `sys_role_menu` VALUES (38995, 26, 624);
INSERT INTO `sys_role_menu` VALUES (38996, 26, 625);
INSERT INTO `sys_role_menu` VALUES (38997, 26, 626);
INSERT INTO `sys_role_menu` VALUES (38998, 26, 670);
INSERT INTO `sys_role_menu` VALUES (38999, 26, 672);
INSERT INTO `sys_role_menu` VALUES (39000, 26, 671);
INSERT INTO `sys_role_menu` VALUES (39001, 26, 673);
INSERT INTO `sys_role_menu` VALUES (39002, 26, 772);
INSERT INTO `sys_role_menu` VALUES (39003, 26, 773);
INSERT INTO `sys_role_menu` VALUES (39004, 26, 774);
INSERT INTO `sys_role_menu` VALUES (39005, 26, 775);
INSERT INTO `sys_role_menu` VALUES (39006, 26, 776);
INSERT INTO `sys_role_menu` VALUES (39007, 26, 766);
INSERT INTO `sys_role_menu` VALUES (39008, 26, 768);
INSERT INTO `sys_role_menu` VALUES (39009, 26, 769);
INSERT INTO `sys_role_menu` VALUES (39010, 26, 770);
INSERT INTO `sys_role_menu` VALUES (39011, 26, 767);
INSERT INTO `sys_role_menu` VALUES (39012, 26, 336);
INSERT INTO `sys_role_menu` VALUES (39013, 26, 341);
INSERT INTO `sys_role_menu` VALUES (39014, 26, 337);
INSERT INTO `sys_role_menu` VALUES (39015, 26, 338);
INSERT INTO `sys_role_menu` VALUES (39016, 26, 339);
INSERT INTO `sys_role_menu` VALUES (39017, 26, 340);
INSERT INTO `sys_role_menu` VALUES (39018, 26, 358);
INSERT INTO `sys_role_menu` VALUES (39019, 26, 359);
INSERT INTO `sys_role_menu` VALUES (39020, 26, 639);
INSERT INTO `sys_role_menu` VALUES (39021, 26, 640);
INSERT INTO `sys_role_menu` VALUES (39022, 26, 200);
INSERT INTO `sys_role_menu` VALUES (39023, 26, 777);
INSERT INTO `sys_role_menu` VALUES (39024, 26, 778);
INSERT INTO `sys_role_menu` VALUES (39025, 26, 783);
INSERT INTO `sys_role_menu` VALUES (39026, 26, 207);
INSERT INTO `sys_role_menu` VALUES (39027, 26, 208);
INSERT INTO `sys_role_menu` VALUES (39028, 26, 209);
INSERT INTO `sys_role_menu` VALUES (39029, 26, 210);
INSERT INTO `sys_role_menu` VALUES (39030, 26, 211);
INSERT INTO `sys_role_menu` VALUES (39031, 26, 201);
INSERT INTO `sys_role_menu` VALUES (39032, 26, 393);
INSERT INTO `sys_role_menu` VALUES (39033, 26, 661);
INSERT INTO `sys_role_menu` VALUES (39034, 26, 662);
INSERT INTO `sys_role_menu` VALUES (39035, 26, 663);
INSERT INTO `sys_role_menu` VALUES (39036, 26, 202);
INSERT INTO `sys_role_menu` VALUES (39037, 26, 203);
INSERT INTO `sys_role_menu` VALUES (39038, 26, 204);
INSERT INTO `sys_role_menu` VALUES (39039, 26, 205);
INSERT INTO `sys_role_menu` VALUES (39040, 26, 264);
INSERT INTO `sys_role_menu` VALUES (39041, 26, 265);
INSERT INTO `sys_role_menu` VALUES (39042, 26, 266);
INSERT INTO `sys_role_menu` VALUES (39043, 26, 280);
INSERT INTO `sys_role_menu` VALUES (39044, 26, 281);
INSERT INTO `sys_role_menu` VALUES (39045, 26, 282);
INSERT INTO `sys_role_menu` VALUES (39046, 26, 286);
INSERT INTO `sys_role_menu` VALUES (39047, 26, 287);
INSERT INTO `sys_role_menu` VALUES (39048, 26, 288);
INSERT INTO `sys_role_menu` VALUES (39049, 26, 283);
INSERT INTO `sys_role_menu` VALUES (39050, 26, 284);
INSERT INTO `sys_role_menu` VALUES (39051, 26, 285);
INSERT INTO `sys_role_menu` VALUES (39052, 26, 394);
INSERT INTO `sys_role_menu` VALUES (39053, 26, 395);
INSERT INTO `sys_role_menu` VALUES (39054, 26, 396);
INSERT INTO `sys_role_menu` VALUES (39055, 26, 779);
INSERT INTO `sys_role_menu` VALUES (39056, 26, 780);
INSERT INTO `sys_role_menu` VALUES (39057, 26, 781);
INSERT INTO `sys_role_menu` VALUES (39058, 26, 782);
INSERT INTO `sys_role_menu` VALUES (39059, 26, 839);
INSERT INTO `sys_role_menu` VALUES (39060, 26, 840);
INSERT INTO `sys_role_menu` VALUES (39061, 26, 841);
INSERT INTO `sys_role_menu` VALUES (39062, 26, 842);
INSERT INTO `sys_role_menu` VALUES (39063, 26, 843);
INSERT INTO `sys_role_menu` VALUES (39064, 26, 844);
INSERT INTO `sys_role_menu` VALUES (39065, 26, 845);
INSERT INTO `sys_role_menu` VALUES (39066, 26, 846);
INSERT INTO `sys_role_menu` VALUES (39067, 26, 850);
INSERT INTO `sys_role_menu` VALUES (39068, 26, 834);
INSERT INTO `sys_role_menu` VALUES (39069, 26, 835);
INSERT INTO `sys_role_menu` VALUES (39070, 26, 836);
INSERT INTO `sys_role_menu` VALUES (39071, 26, 837);
INSERT INTO `sys_role_menu` VALUES (39072, 26, 763);
INSERT INTO `sys_role_menu` VALUES (39073, 26, 771);
INSERT INTO `sys_role_menu` VALUES (39074, 26, 762);
INSERT INTO `sys_role_menu` VALUES (39075, 26, 764);
INSERT INTO `sys_role_menu` VALUES (39076, 26, 765);
INSERT INTO `sys_role_menu` VALUES (39077, 26, 374);
INSERT INTO `sys_role_menu` VALUES (39078, 26, 627);
INSERT INTO `sys_role_menu` VALUES (39079, 26, 804);
INSERT INTO `sys_role_menu` VALUES (39080, 26, 628);
INSERT INTO `sys_role_menu` VALUES (39081, 26, 629);
INSERT INTO `sys_role_menu` VALUES (39082, 26, 630);
INSERT INTO `sys_role_menu` VALUES (39083, 26, 633);
INSERT INTO `sys_role_menu` VALUES (39084, 26, 651);
INSERT INTO `sys_role_menu` VALUES (39085, 26, 382);
INSERT INTO `sys_role_menu` VALUES (39086, 26, 360);
INSERT INTO `sys_role_menu` VALUES (39087, 26, 653);
INSERT INTO `sys_role_menu` VALUES (39088, 26, 665);
INSERT INTO `sys_role_menu` VALUES (39089, 26, 669);
INSERT INTO `sys_role_menu` VALUES (39090, 26, 676);
INSERT INTO `sys_role_menu` VALUES (39091, 26, 449);
INSERT INTO `sys_role_menu` VALUES (39092, 26, 719);
INSERT INTO `sys_role_menu` VALUES (39093, 26, 720);
INSERT INTO `sys_role_menu` VALUES (39094, 26, 295);
INSERT INTO `sys_role_menu` VALUES (39095, 26, 614);
INSERT INTO `sys_role_menu` VALUES (39096, 26, 615);
INSERT INTO `sys_role_menu` VALUES (39097, 26, 898);
INSERT INTO `sys_role_menu` VALUES (39098, 26, 899);
INSERT INTO `sys_role_menu` VALUES (39099, 26, 900);
INSERT INTO `sys_role_menu` VALUES (39100, 26, 901);
INSERT INTO `sys_role_menu` VALUES (39101, 26, 902);
INSERT INTO `sys_role_menu` VALUES (39102, 26, 751);
INSERT INTO `sys_role_menu` VALUES (39103, 26, 752);
INSERT INTO `sys_role_menu` VALUES (39104, 26, 753);
INSERT INTO `sys_role_menu` VALUES (39105, 26, 616);
INSERT INTO `sys_role_menu` VALUES (39106, 26, 666);
INSERT INTO `sys_role_menu` VALUES (39107, 26, 667);
INSERT INTO `sys_role_menu` VALUES (39108, 26, 617);
INSERT INTO `sys_role_menu` VALUES (39109, 26, 795);
INSERT INTO `sys_role_menu` VALUES (39110, 26, 796);
INSERT INTO `sys_role_menu` VALUES (39111, 26, 800);
INSERT INTO `sys_role_menu` VALUES (39112, 26, 807);
INSERT INTO `sys_role_menu` VALUES (39113, 26, 797);
INSERT INTO `sys_role_menu` VALUES (39114, 26, 798);
INSERT INTO `sys_role_menu` VALUES (39115, 26, 799);
INSERT INTO `sys_role_menu` VALUES (39116, 26, 801);
INSERT INTO `sys_role_menu` VALUES (39117, 26, 802);
INSERT INTO `sys_role_menu` VALUES (39118, 26, 1);
INSERT INTO `sys_role_menu` VALUES (39119, 26, 865);
INSERT INTO `sys_role_menu` VALUES (39120, 26, 866);
INSERT INTO `sys_role_menu` VALUES (39121, 26, 867);
INSERT INTO `sys_role_menu` VALUES (39122, 26, 868);
INSERT INTO `sys_role_menu` VALUES (39123, 26, 869);
INSERT INTO `sys_role_menu` VALUES (39124, 26, 888);
INSERT INTO `sys_role_menu` VALUES (39125, 26, 896);
INSERT INTO `sys_role_menu` VALUES (39126, 26, 889);
INSERT INTO `sys_role_menu` VALUES (39127, 26, 890);
INSERT INTO `sys_role_menu` VALUES (39128, 26, 891);
INSERT INTO `sys_role_menu` VALUES (39129, 26, 312);
INSERT INTO `sys_role_menu` VALUES (39130, 26, 402);
INSERT INTO `sys_role_menu` VALUES (39131, 26, 403);
INSERT INTO `sys_role_menu` VALUES (39132, 26, 404);
INSERT INTO `sys_role_menu` VALUES (39133, 26, 405);
INSERT INTO `sys_role_menu` VALUES (39134, 26, 406);
INSERT INTO `sys_role_menu` VALUES (39135, 26, 397);
INSERT INTO `sys_role_menu` VALUES (39136, 26, 398);
INSERT INTO `sys_role_menu` VALUES (39137, 26, 399);
INSERT INTO `sys_role_menu` VALUES (39138, 26, 400);
INSERT INTO `sys_role_menu` VALUES (39139, 26, 401);
INSERT INTO `sys_role_menu` VALUES (39140, 26, 683);
INSERT INTO `sys_role_menu` VALUES (39141, 26, 684);
INSERT INTO `sys_role_menu` VALUES (39142, 26, 689);
INSERT INTO `sys_role_menu` VALUES (39143, 26, 690);
INSERT INTO `sys_role_menu` VALUES (39144, 26, 691);
INSERT INTO `sys_role_menu` VALUES (39145, 26, 692);
INSERT INTO `sys_role_menu` VALUES (39146, 26, 685);
INSERT INTO `sys_role_menu` VALUES (39147, 26, 693);
INSERT INTO `sys_role_menu` VALUES (39148, 26, 694);
INSERT INTO `sys_role_menu` VALUES (39149, 26, 695);
INSERT INTO `sys_role_menu` VALUES (39150, 26, 696);
INSERT INTO `sys_role_menu` VALUES (39151, 26, 686);
INSERT INTO `sys_role_menu` VALUES (39152, 26, 697);
INSERT INTO `sys_role_menu` VALUES (39153, 26, 698);
INSERT INTO `sys_role_menu` VALUES (39154, 26, 699);
INSERT INTO `sys_role_menu` VALUES (39155, 26, 700);
INSERT INTO `sys_role_menu` VALUES (39156, 26, 687);
INSERT INTO `sys_role_menu` VALUES (39157, 26, 701);
INSERT INTO `sys_role_menu` VALUES (39158, 26, 702);
INSERT INTO `sys_role_menu` VALUES (39159, 26, 703);
INSERT INTO `sys_role_menu` VALUES (39160, 26, 704);
INSERT INTO `sys_role_menu` VALUES (39161, 26, 688);
INSERT INTO `sys_role_menu` VALUES (39162, 26, 705);
INSERT INTO `sys_role_menu` VALUES (39163, 26, 713);
INSERT INTO `sys_role_menu` VALUES (39164, 26, 441);
INSERT INTO `sys_role_menu` VALUES (39165, 26, 442);
INSERT INTO `sys_role_menu` VALUES (39166, 26, 443);
INSERT INTO `sys_role_menu` VALUES (39167, 26, 728);
INSERT INTO `sys_role_menu` VALUES (39168, 26, 729);
INSERT INTO `sys_role_menu` VALUES (39169, 26, 730);
INSERT INTO `sys_role_menu` VALUES (39170, 26, 735);
INSERT INTO `sys_role_menu` VALUES (39171, 26, 736);
INSERT INTO `sys_role_menu` VALUES (39172, 26, 243);
INSERT INTO `sys_role_menu` VALUES (39173, 26, 706);
INSERT INTO `sys_role_menu` VALUES (39174, 26, 707);
INSERT INTO `sys_role_menu` VALUES (39175, 26, 723);
INSERT INTO `sys_role_menu` VALUES (39176, 26, 724);
INSERT INTO `sys_role_menu` VALUES (39177, 26, 725);
INSERT INTO `sys_role_menu` VALUES (39178, 26, 726);
INSERT INTO `sys_role_menu` VALUES (39179, 26, 727);
INSERT INTO `sys_role_menu` VALUES (39180, 26, 731);
INSERT INTO `sys_role_menu` VALUES (39181, 26, 732);
INSERT INTO `sys_role_menu` VALUES (39182, 26, 733);
INSERT INTO `sys_role_menu` VALUES (39183, 26, 734);
INSERT INTO `sys_role_menu` VALUES (39184, 26, 740);
INSERT INTO `sys_role_menu` VALUES (39185, 26, 741);
INSERT INTO `sys_role_menu` VALUES (39186, 26, 742);
INSERT INTO `sys_role_menu` VALUES (39187, 26, 743);
INSERT INTO `sys_role_menu` VALUES (39188, 26, 744);
INSERT INTO `sys_role_menu` VALUES (39189, 26, 708);
INSERT INTO `sys_role_menu` VALUES (39190, 26, 709);
INSERT INTO `sys_role_menu` VALUES (39191, 26, 710);
INSERT INTO `sys_role_menu` VALUES (39192, 26, 711);
INSERT INTO `sys_role_menu` VALUES (39193, 26, 712);
INSERT INTO `sys_role_menu` VALUES (39194, 26, 737);
INSERT INTO `sys_role_menu` VALUES (39195, 26, 738);
INSERT INTO `sys_role_menu` VALUES (39196, 26, 238);
INSERT INTO `sys_role_menu` VALUES (39197, 26, 239);
INSERT INTO `sys_role_menu` VALUES (39198, 26, 240);
INSERT INTO `sys_role_menu` VALUES (39199, 26, 241);
INSERT INTO `sys_role_menu` VALUES (39200, 26, 242);
INSERT INTO `sys_role_menu` VALUES (39201, 26, 721);
INSERT INTO `sys_role_menu` VALUES (39202, 26, 722);
INSERT INTO `sys_role_menu` VALUES (39203, 26, 233);
INSERT INTO `sys_role_menu` VALUES (39204, 26, 757);
INSERT INTO `sys_role_menu` VALUES (39205, 26, 234);
INSERT INTO `sys_role_menu` VALUES (39206, 26, 235);
INSERT INTO `sys_role_menu` VALUES (39207, 26, 236);
INSERT INTO `sys_role_menu` VALUES (39208, 26, 237);
INSERT INTO `sys_role_menu` VALUES (39806, 21, 859);
INSERT INTO `sys_role_menu` VALUES (39807, 21, 860);
INSERT INTO `sys_role_menu` VALUES (39808, 21, 861);
INSERT INTO `sys_role_menu` VALUES (39809, 21, 862);
INSERT INTO `sys_role_menu` VALUES (39810, 21, 863);
INSERT INTO `sys_role_menu` VALUES (39811, 21, 677);
INSERT INTO `sys_role_menu` VALUES (39812, 21, 893);
INSERT INTO `sys_role_menu` VALUES (39813, 21, 894);
INSERT INTO `sys_role_menu` VALUES (39814, 21, 895);
INSERT INTO `sys_role_menu` VALUES (39815, 21, 897);
INSERT INTO `sys_role_menu` VALUES (39816, 21, 875);
INSERT INTO `sys_role_menu` VALUES (39817, 21, 876);
INSERT INTO `sys_role_menu` VALUES (39818, 21, 877);
INSERT INTO `sys_role_menu` VALUES (39819, 21, 878);
INSERT INTO `sys_role_menu` VALUES (39820, 21, 879);
INSERT INTO `sys_role_menu` VALUES (39821, 21, 880);
INSERT INTO `sys_role_menu` VALUES (39822, 21, 366);
INSERT INTO `sys_role_menu` VALUES (39823, 21, 427);
INSERT INTO `sys_role_menu` VALUES (39824, 21, 750);
INSERT INTO `sys_role_menu` VALUES (39825, 21, 428);
INSERT INTO `sys_role_menu` VALUES (39826, 21, 357);
INSERT INTO `sys_role_menu` VALUES (39827, 21, 870);
INSERT INTO `sys_role_menu` VALUES (39828, 21, 871);
INSERT INTO `sys_role_menu` VALUES (39829, 21, 289);
INSERT INTO `sys_role_menu` VALUES (39830, 21, 805);
INSERT INTO `sys_role_menu` VALUES (39831, 21, 631);
INSERT INTO `sys_role_menu` VALUES (39832, 21, 659);
INSERT INTO `sys_role_menu` VALUES (39833, 21, 660);
INSERT INTO `sys_role_menu` VALUES (39834, 21, 290);
INSERT INTO `sys_role_menu` VALUES (39835, 21, 291);
INSERT INTO `sys_role_menu` VALUES (39836, 21, 292);
INSERT INTO `sys_role_menu` VALUES (39837, 21, 293);
INSERT INTO `sys_role_menu` VALUES (39838, 21, 444);
INSERT INTO `sys_role_menu` VALUES (39839, 21, 806);
INSERT INTO `sys_role_menu` VALUES (39840, 21, 664);
INSERT INTO `sys_role_menu` VALUES (39841, 21, 623);
INSERT INTO `sys_role_menu` VALUES (39842, 21, 624);
INSERT INTO `sys_role_menu` VALUES (39843, 21, 625);
INSERT INTO `sys_role_menu` VALUES (39844, 21, 670);
INSERT INTO `sys_role_menu` VALUES (39845, 21, 672);
INSERT INTO `sys_role_menu` VALUES (39846, 21, 671);
INSERT INTO `sys_role_menu` VALUES (39847, 21, 673);
INSERT INTO `sys_role_menu` VALUES (39848, 21, 772);
INSERT INTO `sys_role_menu` VALUES (39849, 21, 773);
INSERT INTO `sys_role_menu` VALUES (39850, 21, 774);
INSERT INTO `sys_role_menu` VALUES (39851, 21, 775);
INSERT INTO `sys_role_menu` VALUES (39852, 21, 766);
INSERT INTO `sys_role_menu` VALUES (39853, 21, 768);
INSERT INTO `sys_role_menu` VALUES (39854, 21, 769);
INSERT INTO `sys_role_menu` VALUES (39855, 21, 767);
INSERT INTO `sys_role_menu` VALUES (39856, 21, 639);
INSERT INTO `sys_role_menu` VALUES (39857, 21, 640);
INSERT INTO `sys_role_menu` VALUES (39858, 21, 779);
INSERT INTO `sys_role_menu` VALUES (39859, 21, 780);
INSERT INTO `sys_role_menu` VALUES (39860, 21, 781);
INSERT INTO `sys_role_menu` VALUES (39861, 21, 782);
INSERT INTO `sys_role_menu` VALUES (39862, 21, 839);
INSERT INTO `sys_role_menu` VALUES (39863, 21, 840);
INSERT INTO `sys_role_menu` VALUES (39864, 21, 841);
INSERT INTO `sys_role_menu` VALUES (39865, 21, 842);
INSERT INTO `sys_role_menu` VALUES (39866, 21, 843);
INSERT INTO `sys_role_menu` VALUES (39867, 21, 844);
INSERT INTO `sys_role_menu` VALUES (39868, 21, 845);
INSERT INTO `sys_role_menu` VALUES (39869, 21, 846);
INSERT INTO `sys_role_menu` VALUES (39870, 21, 850);
INSERT INTO `sys_role_menu` VALUES (39871, 21, 834);
INSERT INTO `sys_role_menu` VALUES (39872, 21, 835);
INSERT INTO `sys_role_menu` VALUES (39873, 21, 836);
INSERT INTO `sys_role_menu` VALUES (39874, 21, 837);
INSERT INTO `sys_role_menu` VALUES (39875, 21, 374);
INSERT INTO `sys_role_menu` VALUES (39876, 21, 627);
INSERT INTO `sys_role_menu` VALUES (39877, 21, 804);
INSERT INTO `sys_role_menu` VALUES (39878, 21, 628);
INSERT INTO `sys_role_menu` VALUES (39879, 21, 629);
INSERT INTO `sys_role_menu` VALUES (39880, 21, 898);
INSERT INTO `sys_role_menu` VALUES (39881, 21, 899);
INSERT INTO `sys_role_menu` VALUES (39882, 21, 900);
INSERT INTO `sys_role_menu` VALUES (39883, 21, 901);
INSERT INTO `sys_role_menu` VALUES (39884, 21, 902);
INSERT INTO `sys_role_menu` VALUES (39885, 21, 751);
INSERT INTO `sys_role_menu` VALUES (39886, 21, 752);
INSERT INTO `sys_role_menu` VALUES (43059, 1, 860);
INSERT INTO `sys_role_menu` VALUES (43060, 1, 861);
INSERT INTO `sys_role_menu` VALUES (43061, 1, 862);
INSERT INTO `sys_role_menu` VALUES (43062, 1, 863);
INSERT INTO `sys_role_menu` VALUES (43063, 1, 903);
INSERT INTO `sys_role_menu` VALUES (43064, 1, 759);
INSERT INTO `sys_role_menu` VALUES (43065, 1, 760);
INSERT INTO `sys_role_menu` VALUES (43066, 1, 677);
INSERT INTO `sys_role_menu` VALUES (43067, 1, 634);
INSERT INTO `sys_role_menu` VALUES (43068, 1, 635);
INSERT INTO `sys_role_menu` VALUES (43069, 1, 636);
INSERT INTO `sys_role_menu` VALUES (43070, 1, 637);
INSERT INTO `sys_role_menu` VALUES (43071, 1, 638);
INSERT INTO `sys_role_menu` VALUES (43072, 1, 654);
INSERT INTO `sys_role_menu` VALUES (43073, 1, 655);
INSERT INTO `sys_role_menu` VALUES (43074, 1, 656);
INSERT INTO `sys_role_menu` VALUES (43075, 1, 657);
INSERT INTO `sys_role_menu` VALUES (43076, 1, 658);
INSERT INTO `sys_role_menu` VALUES (43077, 1, 678);
INSERT INTO `sys_role_menu` VALUES (43078, 1, 679);
INSERT INTO `sys_role_menu` VALUES (43079, 1, 680);
INSERT INTO `sys_role_menu` VALUES (43080, 1, 681);
INSERT INTO `sys_role_menu` VALUES (43081, 1, 682);
INSERT INTO `sys_role_menu` VALUES (43082, 1, 893);
INSERT INTO `sys_role_menu` VALUES (43083, 1, 894);
INSERT INTO `sys_role_menu` VALUES (43084, 1, 895);
INSERT INTO `sys_role_menu` VALUES (43085, 1, 897);
INSERT INTO `sys_role_menu` VALUES (43086, 1, 222);
INSERT INTO `sys_role_menu` VALUES (43087, 1, 297);
INSERT INTO `sys_role_menu` VALUES (43088, 1, 754);
INSERT INTO `sys_role_menu` VALUES (43089, 1, 298);
INSERT INTO `sys_role_menu` VALUES (43090, 1, 299);
INSERT INTO `sys_role_menu` VALUES (43091, 1, 300);
INSERT INTO `sys_role_menu` VALUES (43092, 1, 301);
INSERT INTO `sys_role_menu` VALUES (43093, 1, 609);
INSERT INTO `sys_role_menu` VALUES (43094, 1, 756);
INSERT INTO `sys_role_menu` VALUES (43095, 1, 610);
INSERT INTO `sys_role_menu` VALUES (43096, 1, 611);
INSERT INTO `sys_role_menu` VALUES (43097, 1, 612);
INSERT INTO `sys_role_menu` VALUES (43098, 1, 613);
INSERT INTO `sys_role_menu` VALUES (43099, 1, 407);
INSERT INTO `sys_role_menu` VALUES (43100, 1, 408);
INSERT INTO `sys_role_menu` VALUES (43101, 1, 409);
INSERT INTO `sys_role_menu` VALUES (43102, 1, 410);
INSERT INTO `sys_role_menu` VALUES (43103, 1, 411);
INSERT INTO `sys_role_menu` VALUES (43104, 1, 618);
INSERT INTO `sys_role_menu` VALUES (43105, 1, 619);
INSERT INTO `sys_role_menu` VALUES (43106, 1, 620);
INSERT INTO `sys_role_menu` VALUES (43107, 1, 621);
INSERT INTO `sys_role_menu` VALUES (43108, 1, 622);
INSERT INTO `sys_role_menu` VALUES (43109, 1, 254);
INSERT INTO `sys_role_menu` VALUES (43110, 1, 755);
INSERT INTO `sys_role_menu` VALUES (43111, 1, 256);
INSERT INTO `sys_role_menu` VALUES (43112, 1, 257);
INSERT INTO `sys_role_menu` VALUES (43113, 1, 258);
INSERT INTO `sys_role_menu` VALUES (43114, 1, 255);
INSERT INTO `sys_role_menu` VALUES (43115, 1, 745);
INSERT INTO `sys_role_menu` VALUES (43116, 1, 746);
INSERT INTO `sys_role_menu` VALUES (43117, 1, 641);
INSERT INTO `sys_role_menu` VALUES (43118, 1, 642);
INSERT INTO `sys_role_menu` VALUES (43119, 1, 643);
INSERT INTO `sys_role_menu` VALUES (43120, 1, 644);
INSERT INTO `sys_role_menu` VALUES (43121, 1, 645);
INSERT INTO `sys_role_menu` VALUES (43122, 1, 646);
INSERT INTO `sys_role_menu` VALUES (43123, 1, 647);
INSERT INTO `sys_role_menu` VALUES (43124, 1, 648);
INSERT INTO `sys_role_menu` VALUES (43125, 1, 649);
INSERT INTO `sys_role_menu` VALUES (43126, 1, 650);
INSERT INTO `sys_role_menu` VALUES (43127, 1, 875);
INSERT INTO `sys_role_menu` VALUES (43128, 1, 876);
INSERT INTO `sys_role_menu` VALUES (43129, 1, 877);
INSERT INTO `sys_role_menu` VALUES (43130, 1, 878);
INSERT INTO `sys_role_menu` VALUES (43131, 1, 879);
INSERT INTO `sys_role_menu` VALUES (43132, 1, 880);
INSERT INTO `sys_role_menu` VALUES (43133, 1, 881);
INSERT INTO `sys_role_menu` VALUES (43134, 1, 882);
INSERT INTO `sys_role_menu` VALUES (43135, 1, 883);
INSERT INTO `sys_role_menu` VALUES (43136, 1, 884);
INSERT INTO `sys_role_menu` VALUES (43137, 1, 885);
INSERT INTO `sys_role_menu` VALUES (43138, 1, 366);
INSERT INTO `sys_role_menu` VALUES (43139, 1, 887);
INSERT INTO `sys_role_menu` VALUES (43140, 1, 427);
INSERT INTO `sys_role_menu` VALUES (43141, 1, 652);
INSERT INTO `sys_role_menu` VALUES (43142, 1, 747);
INSERT INTO `sys_role_menu` VALUES (43143, 1, 750);
INSERT INTO `sys_role_menu` VALUES (43144, 1, 428);
INSERT INTO `sys_role_menu` VALUES (43145, 1, 429);
INSERT INTO `sys_role_menu` VALUES (43146, 1, 430);
INSERT INTO `sys_role_menu` VALUES (43147, 1, 431);
INSERT INTO `sys_role_menu` VALUES (43148, 1, 422);
INSERT INTO `sys_role_menu` VALUES (43149, 1, 423);
INSERT INTO `sys_role_menu` VALUES (43150, 1, 424);
INSERT INTO `sys_role_menu` VALUES (43151, 1, 425);
INSERT INTO `sys_role_menu` VALUES (43152, 1, 426);
INSERT INTO `sys_role_menu` VALUES (43153, 1, 357);
INSERT INTO `sys_role_menu` VALUES (43154, 1, 816);
INSERT INTO `sys_role_menu` VALUES (43155, 1, 817);
INSERT INTO `sys_role_menu` VALUES (43156, 1, 818);
INSERT INTO `sys_role_menu` VALUES (43157, 1, 819);
INSERT INTO `sys_role_menu` VALUES (43158, 1, 820);
INSERT INTO `sys_role_menu` VALUES (43159, 1, 821);
INSERT INTO `sys_role_menu` VALUES (43160, 1, 822);
INSERT INTO `sys_role_menu` VALUES (43161, 1, 864);
INSERT INTO `sys_role_menu` VALUES (43162, 1, 870);
INSERT INTO `sys_role_menu` VALUES (43163, 1, 871);
INSERT INTO `sys_role_menu` VALUES (43164, 1, 872);
INSERT INTO `sys_role_menu` VALUES (43165, 1, 873);
INSERT INTO `sys_role_menu` VALUES (43166, 1, 874);
INSERT INTO `sys_role_menu` VALUES (43167, 1, 289);
INSERT INTO `sys_role_menu` VALUES (43168, 1, 805);
INSERT INTO `sys_role_menu` VALUES (43169, 1, 631);
INSERT INTO `sys_role_menu` VALUES (43170, 1, 659);
INSERT INTO `sys_role_menu` VALUES (43171, 1, 660);
INSERT INTO `sys_role_menu` VALUES (43172, 1, 290);
INSERT INTO `sys_role_menu` VALUES (43173, 1, 291);
INSERT INTO `sys_role_menu` VALUES (43174, 1, 292);
INSERT INTO `sys_role_menu` VALUES (43175, 1, 293);
INSERT INTO `sys_role_menu` VALUES (43176, 1, 444);
INSERT INTO `sys_role_menu` VALUES (43177, 1, 806);
INSERT INTO `sys_role_menu` VALUES (43178, 1, 664);
INSERT INTO `sys_role_menu` VALUES (43179, 1, 674);
INSERT INTO `sys_role_menu` VALUES (43180, 1, 748);
INSERT INTO `sys_role_menu` VALUES (43181, 1, 448);
INSERT INTO `sys_role_menu` VALUES (43182, 1, 447);
INSERT INTO `sys_role_menu` VALUES (43183, 1, 445);
INSERT INTO `sys_role_menu` VALUES (43184, 1, 623);
INSERT INTO `sys_role_menu` VALUES (43185, 1, 624);
INSERT INTO `sys_role_menu` VALUES (43186, 1, 625);
INSERT INTO `sys_role_menu` VALUES (43187, 1, 626);
INSERT INTO `sys_role_menu` VALUES (43188, 1, 670);
INSERT INTO `sys_role_menu` VALUES (43189, 1, 672);
INSERT INTO `sys_role_menu` VALUES (43190, 1, 671);
INSERT INTO `sys_role_menu` VALUES (43191, 1, 673);
INSERT INTO `sys_role_menu` VALUES (43192, 1, 772);
INSERT INTO `sys_role_menu` VALUES (43193, 1, 773);
INSERT INTO `sys_role_menu` VALUES (43194, 1, 774);
INSERT INTO `sys_role_menu` VALUES (43195, 1, 775);
INSERT INTO `sys_role_menu` VALUES (43196, 1, 776);
INSERT INTO `sys_role_menu` VALUES (43197, 1, 336);
INSERT INTO `sys_role_menu` VALUES (43198, 1, 341);
INSERT INTO `sys_role_menu` VALUES (43199, 1, 337);
INSERT INTO `sys_role_menu` VALUES (43200, 1, 338);
INSERT INTO `sys_role_menu` VALUES (43201, 1, 339);
INSERT INTO `sys_role_menu` VALUES (43202, 1, 340);
INSERT INTO `sys_role_menu` VALUES (43203, 1, 358);
INSERT INTO `sys_role_menu` VALUES (43204, 1, 359);
INSERT INTO `sys_role_menu` VALUES (43205, 1, 639);
INSERT INTO `sys_role_menu` VALUES (43206, 1, 640);
INSERT INTO `sys_role_menu` VALUES (43207, 1, 200);
INSERT INTO `sys_role_menu` VALUES (43208, 1, 777);
INSERT INTO `sys_role_menu` VALUES (43209, 1, 778);
INSERT INTO `sys_role_menu` VALUES (43210, 1, 783);
INSERT INTO `sys_role_menu` VALUES (43211, 1, 904);
INSERT INTO `sys_role_menu` VALUES (43212, 1, 905);
INSERT INTO `sys_role_menu` VALUES (43213, 1, 906);
INSERT INTO `sys_role_menu` VALUES (43214, 1, 907);
INSERT INTO `sys_role_menu` VALUES (43215, 1, 207);
INSERT INTO `sys_role_menu` VALUES (43216, 1, 208);
INSERT INTO `sys_role_menu` VALUES (43217, 1, 209);
INSERT INTO `sys_role_menu` VALUES (43218, 1, 210);
INSERT INTO `sys_role_menu` VALUES (43219, 1, 211);
INSERT INTO `sys_role_menu` VALUES (43220, 1, 201);
INSERT INTO `sys_role_menu` VALUES (43221, 1, 393);
INSERT INTO `sys_role_menu` VALUES (43222, 1, 661);
INSERT INTO `sys_role_menu` VALUES (43223, 1, 662);
INSERT INTO `sys_role_menu` VALUES (43224, 1, 663);
INSERT INTO `sys_role_menu` VALUES (43225, 1, 202);
INSERT INTO `sys_role_menu` VALUES (43226, 1, 203);
INSERT INTO `sys_role_menu` VALUES (43227, 1, 204);
INSERT INTO `sys_role_menu` VALUES (43228, 1, 205);
INSERT INTO `sys_role_menu` VALUES (43229, 1, 264);
INSERT INTO `sys_role_menu` VALUES (43230, 1, 265);
INSERT INTO `sys_role_menu` VALUES (43231, 1, 266);
INSERT INTO `sys_role_menu` VALUES (43232, 1, 280);
INSERT INTO `sys_role_menu` VALUES (43233, 1, 281);
INSERT INTO `sys_role_menu` VALUES (43234, 1, 282);
INSERT INTO `sys_role_menu` VALUES (43235, 1, 286);
INSERT INTO `sys_role_menu` VALUES (43236, 1, 287);
INSERT INTO `sys_role_menu` VALUES (43237, 1, 288);
INSERT INTO `sys_role_menu` VALUES (43238, 1, 283);
INSERT INTO `sys_role_menu` VALUES (43239, 1, 284);
INSERT INTO `sys_role_menu` VALUES (43240, 1, 285);
INSERT INTO `sys_role_menu` VALUES (43241, 1, 394);
INSERT INTO `sys_role_menu` VALUES (43242, 1, 395);
INSERT INTO `sys_role_menu` VALUES (43243, 1, 396);
INSERT INTO `sys_role_menu` VALUES (43244, 1, 908);
INSERT INTO `sys_role_menu` VALUES (43245, 1, 909);
INSERT INTO `sys_role_menu` VALUES (43246, 1, 779);
INSERT INTO `sys_role_menu` VALUES (43247, 1, 780);
INSERT INTO `sys_role_menu` VALUES (43248, 1, 781);
INSERT INTO `sys_role_menu` VALUES (43249, 1, 782);
INSERT INTO `sys_role_menu` VALUES (43250, 1, 850);
INSERT INTO `sys_role_menu` VALUES (43251, 1, 834);
INSERT INTO `sys_role_menu` VALUES (43252, 1, 835);
INSERT INTO `sys_role_menu` VALUES (43253, 1, 836);
INSERT INTO `sys_role_menu` VALUES (43254, 1, 837);
INSERT INTO `sys_role_menu` VALUES (43255, 1, 374);
INSERT INTO `sys_role_menu` VALUES (43256, 1, 627);
INSERT INTO `sys_role_menu` VALUES (43257, 1, 804);
INSERT INTO `sys_role_menu` VALUES (43258, 1, 628);
INSERT INTO `sys_role_menu` VALUES (43259, 1, 629);
INSERT INTO `sys_role_menu` VALUES (43260, 1, 630);
INSERT INTO `sys_role_menu` VALUES (43261, 1, 633);
INSERT INTO `sys_role_menu` VALUES (43262, 1, 651);
INSERT INTO `sys_role_menu` VALUES (43263, 1, 382);
INSERT INTO `sys_role_menu` VALUES (43264, 1, 360);
INSERT INTO `sys_role_menu` VALUES (43265, 1, 653);
INSERT INTO `sys_role_menu` VALUES (43266, 1, 665);
INSERT INTO `sys_role_menu` VALUES (43267, 1, 669);
INSERT INTO `sys_role_menu` VALUES (43268, 1, 676);
INSERT INTO `sys_role_menu` VALUES (43269, 1, 449);
INSERT INTO `sys_role_menu` VALUES (43270, 1, 719);
INSERT INTO `sys_role_menu` VALUES (43271, 1, 720);
INSERT INTO `sys_role_menu` VALUES (43272, 1, 295);
INSERT INTO `sys_role_menu` VALUES (43273, 1, 614);
INSERT INTO `sys_role_menu` VALUES (43274, 1, 615);
INSERT INTO `sys_role_menu` VALUES (43275, 1, 898);
INSERT INTO `sys_role_menu` VALUES (43276, 1, 899);
INSERT INTO `sys_role_menu` VALUES (43277, 1, 900);
INSERT INTO `sys_role_menu` VALUES (43278, 1, 901);
INSERT INTO `sys_role_menu` VALUES (43279, 1, 902);
INSERT INTO `sys_role_menu` VALUES (43280, 1, 751);
INSERT INTO `sys_role_menu` VALUES (43281, 1, 752);
INSERT INTO `sys_role_menu` VALUES (43282, 1, 753);
INSERT INTO `sys_role_menu` VALUES (43283, 1, 795);
INSERT INTO `sys_role_menu` VALUES (43284, 1, 796);
INSERT INTO `sys_role_menu` VALUES (43285, 1, 800);
INSERT INTO `sys_role_menu` VALUES (43286, 1, 807);
INSERT INTO `sys_role_menu` VALUES (43287, 1, 853);
INSERT INTO `sys_role_menu` VALUES (43288, 1, 1);
INSERT INTO `sys_role_menu` VALUES (43289, 1, 915);
INSERT INTO `sys_role_menu` VALUES (43290, 1, 916);
INSERT INTO `sys_role_menu` VALUES (43291, 1, 2);
INSERT INTO `sys_role_menu` VALUES (43292, 1, 15);
INSERT INTO `sys_role_menu` VALUES (43293, 1, 16);
INSERT INTO `sys_role_menu` VALUES (43294, 1, 17);
INSERT INTO `sys_role_menu` VALUES (43295, 1, 18);
INSERT INTO `sys_role_menu` VALUES (43296, 1, 3);
INSERT INTO `sys_role_menu` VALUES (43297, 1, 19);
INSERT INTO `sys_role_menu` VALUES (43298, 1, 20);
INSERT INTO `sys_role_menu` VALUES (43299, 1, 21);
INSERT INTO `sys_role_menu` VALUES (43300, 1, 22);
INSERT INTO `sys_role_menu` VALUES (43301, 1, 23);
INSERT INTO `sys_role_menu` VALUES (43302, 1, 24);
INSERT INTO `sys_role_menu` VALUES (43303, 1, 25);
INSERT INTO `sys_role_menu` VALUES (43304, 1, 26);
INSERT INTO `sys_role_menu` VALUES (43305, 1, 302);
INSERT INTO `sys_role_menu` VALUES (43306, 1, 303);
INSERT INTO `sys_role_menu` VALUES (43307, 1, 304);
INSERT INTO `sys_role_menu` VALUES (43308, 1, 305);
INSERT INTO `sys_role_menu` VALUES (43309, 1, 306);
INSERT INTO `sys_role_menu` VALUES (43310, 1, 865);
INSERT INTO `sys_role_menu` VALUES (43311, 1, 866);
INSERT INTO `sys_role_menu` VALUES (43312, 1, 867);
INSERT INTO `sys_role_menu` VALUES (43313, 1, 868);
INSERT INTO `sys_role_menu` VALUES (43314, 1, 869);
INSERT INTO `sys_role_menu` VALUES (43315, 1, 27);
INSERT INTO `sys_role_menu` VALUES (43316, 1, 29);
INSERT INTO `sys_role_menu` VALUES (43317, 1, 28);
INSERT INTO `sys_role_menu` VALUES (43318, 1, 823);
INSERT INTO `sys_role_menu` VALUES (43319, 1, 825);
INSERT INTO `sys_role_menu` VALUES (43320, 1, 826);
INSERT INTO `sys_role_menu` VALUES (43321, 1, 827);
INSERT INTO `sys_role_menu` VALUES (43322, 1, 828);
INSERT INTO `sys_role_menu` VALUES (43323, 1, 824);
INSERT INTO `sys_role_menu` VALUES (43324, 1, 829);
INSERT INTO `sys_role_menu` VALUES (43325, 1, 830);
INSERT INTO `sys_role_menu` VALUES (43326, 1, 831);
INSERT INTO `sys_role_menu` VALUES (43327, 1, 832);
INSERT INTO `sys_role_menu` VALUES (43328, 1, 888);
INSERT INTO `sys_role_menu` VALUES (43329, 1, 896);
INSERT INTO `sys_role_menu` VALUES (43330, 1, 889);
INSERT INTO `sys_role_menu` VALUES (43331, 1, 890);
INSERT INTO `sys_role_menu` VALUES (43332, 1, 891);
INSERT INTO `sys_role_menu` VALUES (43333, 1, 243);
INSERT INTO `sys_role_menu` VALUES (43334, 1, 706);
INSERT INTO `sys_role_menu` VALUES (43335, 1, 707);
INSERT INTO `sys_role_menu` VALUES (43336, 1, 723);
INSERT INTO `sys_role_menu` VALUES (43337, 1, 724);
INSERT INTO `sys_role_menu` VALUES (43338, 1, 725);
INSERT INTO `sys_role_menu` VALUES (43339, 1, 726);
INSERT INTO `sys_role_menu` VALUES (43340, 1, 727);
INSERT INTO `sys_role_menu` VALUES (43341, 1, 731);
INSERT INTO `sys_role_menu` VALUES (43342, 1, 732);
INSERT INTO `sys_role_menu` VALUES (43343, 1, 733);
INSERT INTO `sys_role_menu` VALUES (43344, 1, 734);
INSERT INTO `sys_role_menu` VALUES (43345, 1, 740);
INSERT INTO `sys_role_menu` VALUES (43346, 1, 741);
INSERT INTO `sys_role_menu` VALUES (43347, 1, 742);
INSERT INTO `sys_role_menu` VALUES (43348, 1, 743);
INSERT INTO `sys_role_menu` VALUES (43349, 1, 744);
INSERT INTO `sys_role_menu` VALUES (43350, 1, 708);
INSERT INTO `sys_role_menu` VALUES (43351, 1, 709);
INSERT INTO `sys_role_menu` VALUES (43352, 1, 710);
INSERT INTO `sys_role_menu` VALUES (43353, 1, 711);
INSERT INTO `sys_role_menu` VALUES (43354, 1, 712);
INSERT INTO `sys_role_menu` VALUES (43355, 1, 737);
INSERT INTO `sys_role_menu` VALUES (43356, 1, 738);
INSERT INTO `sys_role_menu` VALUES (43357, 1, 238);
INSERT INTO `sys_role_menu` VALUES (43358, 1, 239);
INSERT INTO `sys_role_menu` VALUES (43359, 1, 240);
INSERT INTO `sys_role_menu` VALUES (43360, 1, 241);
INSERT INTO `sys_role_menu` VALUES (43361, 1, 242);
INSERT INTO `sys_role_menu` VALUES (43362, 1, 721);
INSERT INTO `sys_role_menu` VALUES (43363, 1, 722);
INSERT INTO `sys_role_menu` VALUES (43364, 1, 233);
INSERT INTO `sys_role_menu` VALUES (43365, 1, 757);
INSERT INTO `sys_role_menu` VALUES (43366, 1, 234);
INSERT INTO `sys_role_menu` VALUES (43367, 1, 235);
INSERT INTO `sys_role_menu` VALUES (43368, 1, 236);
INSERT INTO `sys_role_menu` VALUES (43369, 1, 237);
INSERT INTO `sys_role_menu` VALUES (44397, 30, 677);
INSERT INTO `sys_role_menu` VALUES (44398, 30, 634);
INSERT INTO `sys_role_menu` VALUES (44399, 30, 635);
INSERT INTO `sys_role_menu` VALUES (44400, 30, 636);
INSERT INTO `sys_role_menu` VALUES (44401, 30, 637);
INSERT INTO `sys_role_menu` VALUES (44402, 30, 638);
INSERT INTO `sys_role_menu` VALUES (44403, 30, 654);
INSERT INTO `sys_role_menu` VALUES (44404, 30, 655);
INSERT INTO `sys_role_menu` VALUES (44405, 30, 656);
INSERT INTO `sys_role_menu` VALUES (44406, 30, 657);
INSERT INTO `sys_role_menu` VALUES (44407, 30, 658);
INSERT INTO `sys_role_menu` VALUES (44408, 30, 893);
INSERT INTO `sys_role_menu` VALUES (44409, 30, 894);
INSERT INTO `sys_role_menu` VALUES (44410, 30, 895);
INSERT INTO `sys_role_menu` VALUES (44411, 30, 897);
INSERT INTO `sys_role_menu` VALUES (44412, 30, 222);
INSERT INTO `sys_role_menu` VALUES (44413, 30, 297);
INSERT INTO `sys_role_menu` VALUES (44414, 30, 754);
INSERT INTO `sys_role_menu` VALUES (44415, 30, 298);
INSERT INTO `sys_role_menu` VALUES (44416, 30, 299);
INSERT INTO `sys_role_menu` VALUES (44417, 30, 300);
INSERT INTO `sys_role_menu` VALUES (44418, 30, 301);
INSERT INTO `sys_role_menu` VALUES (44419, 30, 618);
INSERT INTO `sys_role_menu` VALUES (44420, 30, 619);
INSERT INTO `sys_role_menu` VALUES (44421, 30, 620);
INSERT INTO `sys_role_menu` VALUES (44422, 30, 621);
INSERT INTO `sys_role_menu` VALUES (44423, 30, 622);
INSERT INTO `sys_role_menu` VALUES (44424, 30, 254);
INSERT INTO `sys_role_menu` VALUES (44425, 30, 755);
INSERT INTO `sys_role_menu` VALUES (44426, 30, 256);
INSERT INTO `sys_role_menu` VALUES (44427, 30, 257);
INSERT INTO `sys_role_menu` VALUES (44428, 30, 258);
INSERT INTO `sys_role_menu` VALUES (44429, 30, 255);
INSERT INTO `sys_role_menu` VALUES (44430, 30, 745);
INSERT INTO `sys_role_menu` VALUES (44431, 30, 746);
INSERT INTO `sys_role_menu` VALUES (44432, 30, 641);
INSERT INTO `sys_role_menu` VALUES (44433, 30, 642);
INSERT INTO `sys_role_menu` VALUES (44434, 30, 643);
INSERT INTO `sys_role_menu` VALUES (44435, 30, 644);
INSERT INTO `sys_role_menu` VALUES (44436, 30, 645);
INSERT INTO `sys_role_menu` VALUES (44437, 30, 646);
INSERT INTO `sys_role_menu` VALUES (44438, 30, 647);
INSERT INTO `sys_role_menu` VALUES (44439, 30, 648);
INSERT INTO `sys_role_menu` VALUES (44440, 30, 649);
INSERT INTO `sys_role_menu` VALUES (44441, 30, 650);
INSERT INTO `sys_role_menu` VALUES (44442, 30, 366);
INSERT INTO `sys_role_menu` VALUES (44443, 30, 887);
INSERT INTO `sys_role_menu` VALUES (44444, 30, 427);
INSERT INTO `sys_role_menu` VALUES (44445, 30, 652);
INSERT INTO `sys_role_menu` VALUES (44446, 30, 747);
INSERT INTO `sys_role_menu` VALUES (44447, 30, 750);
INSERT INTO `sys_role_menu` VALUES (44448, 30, 428);
INSERT INTO `sys_role_menu` VALUES (44449, 30, 429);
INSERT INTO `sys_role_menu` VALUES (44450, 30, 430);
INSERT INTO `sys_role_menu` VALUES (44451, 30, 431);
INSERT INTO `sys_role_menu` VALUES (44452, 30, 357);
INSERT INTO `sys_role_menu` VALUES (44453, 30, 289);
INSERT INTO `sys_role_menu` VALUES (44454, 30, 805);
INSERT INTO `sys_role_menu` VALUES (44455, 30, 631);
INSERT INTO `sys_role_menu` VALUES (44456, 30, 659);
INSERT INTO `sys_role_menu` VALUES (44457, 30, 660);
INSERT INTO `sys_role_menu` VALUES (44458, 30, 290);
INSERT INTO `sys_role_menu` VALUES (44459, 30, 291);
INSERT INTO `sys_role_menu` VALUES (44460, 30, 292);
INSERT INTO `sys_role_menu` VALUES (44461, 30, 293);
INSERT INTO `sys_role_menu` VALUES (44462, 30, 444);
INSERT INTO `sys_role_menu` VALUES (44463, 30, 806);
INSERT INTO `sys_role_menu` VALUES (44464, 30, 664);
INSERT INTO `sys_role_menu` VALUES (44465, 30, 674);
INSERT INTO `sys_role_menu` VALUES (44466, 30, 748);
INSERT INTO `sys_role_menu` VALUES (44467, 30, 448);
INSERT INTO `sys_role_menu` VALUES (44468, 30, 447);
INSERT INTO `sys_role_menu` VALUES (44469, 30, 445);
INSERT INTO `sys_role_menu` VALUES (44470, 30, 670);
INSERT INTO `sys_role_menu` VALUES (44471, 30, 672);
INSERT INTO `sys_role_menu` VALUES (44472, 30, 671);
INSERT INTO `sys_role_menu` VALUES (44473, 30, 673);
INSERT INTO `sys_role_menu` VALUES (44474, 30, 200);
INSERT INTO `sys_role_menu` VALUES (44475, 30, 904);
INSERT INTO `sys_role_menu` VALUES (44476, 30, 905);
INSERT INTO `sys_role_menu` VALUES (44477, 30, 906);
INSERT INTO `sys_role_menu` VALUES (44478, 30, 907);
INSERT INTO `sys_role_menu` VALUES (44479, 30, 394);
INSERT INTO `sys_role_menu` VALUES (44480, 30, 395);
INSERT INTO `sys_role_menu` VALUES (44481, 30, 396);
INSERT INTO `sys_role_menu` VALUES (44482, 30, 908);
INSERT INTO `sys_role_menu` VALUES (44483, 30, 909);
INSERT INTO `sys_role_menu` VALUES (44484, 30, 779);
INSERT INTO `sys_role_menu` VALUES (44485, 30, 850);
INSERT INTO `sys_role_menu` VALUES (44486, 30, 834);
INSERT INTO `sys_role_menu` VALUES (44487, 30, 835);
INSERT INTO `sys_role_menu` VALUES (44488, 30, 836);
INSERT INTO `sys_role_menu` VALUES (44489, 30, 837);
INSERT INTO `sys_role_menu` VALUES (44490, 30, 763);
INSERT INTO `sys_role_menu` VALUES (44491, 30, 771);
INSERT INTO `sys_role_menu` VALUES (44492, 30, 762);
INSERT INTO `sys_role_menu` VALUES (44493, 30, 764);
INSERT INTO `sys_role_menu` VALUES (44494, 30, 765);
INSERT INTO `sys_role_menu` VALUES (44495, 30, 374);
INSERT INTO `sys_role_menu` VALUES (44496, 30, 627);
INSERT INTO `sys_role_menu` VALUES (44497, 30, 804);
INSERT INTO `sys_role_menu` VALUES (44498, 30, 628);
INSERT INTO `sys_role_menu` VALUES (44499, 30, 629);
INSERT INTO `sys_role_menu` VALUES (44500, 30, 630);
INSERT INTO `sys_role_menu` VALUES (44501, 30, 633);
INSERT INTO `sys_role_menu` VALUES (44502, 30, 651);
INSERT INTO `sys_role_menu` VALUES (44503, 30, 898);
INSERT INTO `sys_role_menu` VALUES (44504, 30, 899);
INSERT INTO `sys_role_menu` VALUES (44505, 30, 900);
INSERT INTO `sys_role_menu` VALUES (44506, 30, 901);
INSERT INTO `sys_role_menu` VALUES (44507, 30, 902);
INSERT INTO `sys_role_menu` VALUES (44508, 30, 795);
INSERT INTO `sys_role_menu` VALUES (44509, 30, 796);
INSERT INTO `sys_role_menu` VALUES (44510, 30, 800);
INSERT INTO `sys_role_menu` VALUES (44511, 30, 807);
INSERT INTO `sys_role_menu` VALUES (44512, 30, 809);
INSERT INTO `sys_role_menu` VALUES (44513, 30, 810);
INSERT INTO `sys_role_menu` VALUES (44514, 30, 811);
INSERT INTO `sys_role_menu` VALUES (44515, 30, 813);
INSERT INTO `sys_role_menu` VALUES (44516, 30, 815);
INSERT INTO `sys_role_menu` VALUES (44517, 30, 853);
INSERT INTO `sys_role_menu` VALUES (44518, 30, 1);
INSERT INTO `sys_role_menu` VALUES (44519, 30, 915);
INSERT INTO `sys_role_menu` VALUES (44520, 30, 916);
INSERT INTO `sys_role_menu` VALUES (44521, 30, 714);
INSERT INTO `sys_role_menu` VALUES (44522, 30, 715);
INSERT INTO `sys_role_menu` VALUES (44523, 30, 716);
INSERT INTO `sys_role_menu` VALUES (44524, 30, 2);
INSERT INTO `sys_role_menu` VALUES (44525, 30, 15);
INSERT INTO `sys_role_menu` VALUES (44526, 30, 16);
INSERT INTO `sys_role_menu` VALUES (44527, 30, 17);
INSERT INTO `sys_role_menu` VALUES (44528, 30, 18);
INSERT INTO `sys_role_menu` VALUES (44529, 30, 749);
INSERT INTO `sys_role_menu` VALUES (44530, 30, 3);
INSERT INTO `sys_role_menu` VALUES (44531, 30, 19);
INSERT INTO `sys_role_menu` VALUES (44532, 30, 20);
INSERT INTO `sys_role_menu` VALUES (44533, 30, 21);
INSERT INTO `sys_role_menu` VALUES (44534, 30, 22);
INSERT INTO `sys_role_menu` VALUES (44535, 30, 4);
INSERT INTO `sys_role_menu` VALUES (44536, 30, 23);
INSERT INTO `sys_role_menu` VALUES (44537, 30, 24);
INSERT INTO `sys_role_menu` VALUES (44538, 30, 25);
INSERT INTO `sys_role_menu` VALUES (44539, 30, 26);
INSERT INTO `sys_role_menu` VALUES (44540, 30, 30);
INSERT INTO `sys_role_menu` VALUES (44541, 30, 302);
INSERT INTO `sys_role_menu` VALUES (44542, 30, 303);
INSERT INTO `sys_role_menu` VALUES (44543, 30, 304);
INSERT INTO `sys_role_menu` VALUES (44544, 30, 305);
INSERT INTO `sys_role_menu` VALUES (44545, 30, 306);
INSERT INTO `sys_role_menu` VALUES (44546, 30, 910);
INSERT INTO `sys_role_menu` VALUES (44547, 30, 911);
INSERT INTO `sys_role_menu` VALUES (44548, 30, 912);
INSERT INTO `sys_role_menu` VALUES (44549, 30, 913);
INSERT INTO `sys_role_menu` VALUES (44550, 30, 914);
INSERT INTO `sys_role_menu` VALUES (44551, 30, 27);
INSERT INTO `sys_role_menu` VALUES (44552, 30, 29);
INSERT INTO `sys_role_menu` VALUES (44553, 30, 5);
INSERT INTO `sys_role_menu` VALUES (44554, 30, 28);
INSERT INTO `sys_role_menu` VALUES (44555, 30, 823);
INSERT INTO `sys_role_menu` VALUES (44556, 30, 825);
INSERT INTO `sys_role_menu` VALUES (44557, 30, 826);
INSERT INTO `sys_role_menu` VALUES (44558, 30, 827);
INSERT INTO `sys_role_menu` VALUES (44559, 30, 828);
INSERT INTO `sys_role_menu` VALUES (44560, 30, 824);
INSERT INTO `sys_role_menu` VALUES (44561, 30, 829);
INSERT INTO `sys_role_menu` VALUES (44562, 30, 830);
INSERT INTO `sys_role_menu` VALUES (44563, 30, 831);
INSERT INTO `sys_role_menu` VALUES (44564, 30, 832);
INSERT INTO `sys_role_menu` VALUES (44565, 30, 888);
INSERT INTO `sys_role_menu` VALUES (44566, 30, 896);
INSERT INTO `sys_role_menu` VALUES (44567, 30, 889);
INSERT INTO `sys_role_menu` VALUES (44568, 30, 890);
INSERT INTO `sys_role_menu` VALUES (44569, 30, 891);
INSERT INTO `sys_role_menu` VALUES (44570, 31, 677);
INSERT INTO `sys_role_menu` VALUES (44571, 31, 634);
INSERT INTO `sys_role_menu` VALUES (44572, 31, 635);
INSERT INTO `sys_role_menu` VALUES (44573, 31, 636);
INSERT INTO `sys_role_menu` VALUES (44574, 31, 637);
INSERT INTO `sys_role_menu` VALUES (44575, 31, 638);

-- ----------------------------
-- Table structure for sys_sms_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_sms_log`;
CREATE TABLE `sys_sms_log`  (
  `id` smallint(5) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `user_id` bigint(20) DEFAULT NULL COMMENT '操作人',
  `content` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '必填参数。发送内容（1-500 个汉字）UTF-8编码',
  `sms_code` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '验证码',
  `mobile` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '必填参数。手机号码。多个以英文逗号隔开',
  `stime` datetime(0) DEFAULT NULL COMMENT '可选参数。发送时间，填写时已填写的时间发送，不填时为当前时间发送',
  `sign` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '必填参数。用户签名',
  `type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '必填参数。固定值 pt',
  `extno` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '可选参数。扩展码，用户定义扩展码，只能为数字',
  `send_status` int(11) DEFAULT NULL COMMENT '发送状态 1成功 0失败',
  `send_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '发送编号',
  `invalid_num` int(11) DEFAULT NULL COMMENT '无效号码数',
  `success_num` int(11) DEFAULT NULL COMMENT '成功提交数',
  `black_num` int(11) DEFAULT NULL COMMENT '黑名单数',
  `return_msg` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '返回消息',
  `merch_sn` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '商户编号',
  `store_id` int(11) DEFAULT NULL COMMENT '门店编号',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '短信发送日志' ROW_FORMAT = Compact;

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user`  (
  `user_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `username` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户名',
  `password` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '密码',
  `email` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '邮箱',
  `mobile` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '手机号',
  `status` tinyint(4) DEFAULT NULL COMMENT '状态  0：禁用   1：正常',
  `create_user_id` bigint(20) DEFAULT NULL COMMENT '创建者ID',
  `create_time` datetime(0) DEFAULT NULL COMMENT '创建时间',
  `dept_id` bigint(20) DEFAULT NULL COMMENT '部门ID',
  `store_id` mediumint(9) DEFAULT NULL COMMENT '门店ID',
  `role_type` int(11) DEFAULT NULL COMMENT '1：操作员；2：店员；3：商户管理员 4：第三方商户管理员',
  `merch_sn` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '商户编号',
  `third_party_merch_code` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '第三方商户代码',
  PRIMARY KEY (`user_id`) USING BTREE,
  UNIQUE INDEX `username`(`username`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 318 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '系统用户' ROW_FORMAT = Compact;

-- ----------------------------
-- Records of sys_user
-- ----------------------------
INSERT INTO `sys_user` VALUES (1, 'admin', 'bcb15f821479b4d5772bd0ca866c00ad5f926e3580720659cc80d39c9d09802a', 'admin@162.com', '15209831990', 1, 1, '2016-11-11 11:11:11', 1, NULL, 1, NULL, NULL);
INSERT INTO `sys_user` VALUES (288, 'cw_admin', '8edf2eb9213ee4c7f237bffcb9eee0627692b0a942c9aa32de5fa25da5b2a3fa', '123456@test.com', '13212345678', 1, 1, '2020-09-29 11:53:07', NULL, NULL, 3, 'mhbs990053989883052032', '');
INSERT INTO `sys_user` VALUES (290, 'cw_cashier', 'bcb15f821479b4d5772bd0ca866c00ad5f926e3580720659cc80d39c9d09802a', '123456@test.com', '13212345678', 1, 288, '2020-10-14 15:37:58', NULL, 163, 2, 'mhbs990053989883052032', 'CW001');
INSERT INTO `sys_user` VALUES (291, 'cw_test', 'bcb15f821479b4d5772bd0ca866c00ad5f926e3580720659cc80d39c9d09802a', 'test@163.com', '15912345678', 1, 288, '2020-10-20 10:00:08', NULL, 169, 2, 'mhbs990053989883052032', 'CW001');
INSERT INTO `sys_user` VALUES (292, 'kf', 'bcb15f821479b4d5772bd0ca866c00ad5f926e3580720659cc80d39c9d09802a', '123@qq.com', '15918475125', 1, 1, '2020-11-11 17:27:23', NULL, NULL, 3, 'mhbs990053989883052032', '');
INSERT INTO `sys_user` VALUES (293, 'cw_c1', 'bcb15f821479b4d5772bd0ca866c00ad5f926e3580720659cc80d39c9d09802a', '111111111@qq.com', '17865367271', 1, 288, '2020-11-12 16:20:29', NULL, 163, 2, 'mhbs990053989883052032', 'CW001');
INSERT INTO `sys_user` VALUES (294, 'cw_c2', 'bcb15f821479b4d5772bd0ca866c00ad5f926e3580720659cc80d39c9d09802a', '126783467@qq.com', '18734829482', 1, 288, '2020-11-12 16:22:03', NULL, 163, 2, 'mhbs990053989883052032', 'CW001');
INSERT INTO `sys_user` VALUES (295, 'cw_c3', 'bcb15f821479b4d5772bd0ca866c00ad5f926e3580720659cc80d39c9d09802a', '22334324323@qq.com', '17552523652', 1, 288, '2020-11-12 16:22:59', NULL, 163, 2, 'mhbs990053989883052032', 'CW001');
INSERT INTO `sys_user` VALUES (296, 'cw_c4', 'bcb15f821479b4d5772bd0ca866c00ad5f926e3580720659cc80d39c9d09802a', '34224342342@qq.com', '18356548020', 1, 288, '2020-11-12 16:23:47', NULL, 163, 2, 'mhbs990053989883052032', 'CW001');
INSERT INTO `sys_user` VALUES (297, 'cw_c5', 'bcb15f821479b4d5772bd0ca866c00ad5f926e3580720659cc80d39c9d09802a', '5512345472@qq.com', '15789856410', 1, 288, '2020-11-12 16:24:22', NULL, 163, 2, 'mhbs990053989883052032', 'CW001');
INSERT INTO `sys_user` VALUES (298, 'cw_1', 'bcb15f821479b4d5772bd0ca866c00ad5f926e3580720659cc80d39c9d09802a', '565215245@qq.com', '15756562525', 1, 1, '2020-11-13 11:24:06', NULL, NULL, 3, 'mhbs990053989883052032', '');
INSERT INTO `sys_user` VALUES (299, 'e_admin', 'bcb15f821479b4d5772bd0ca866c00ad5f926e3580720659cc80d39c9d09802a', '2234423293@qq.com', '15623560000', 1, 1, '2020-12-07 15:38:43', NULL, NULL, 3, 'mhbs990053989883052032', '');
INSERT INTO `sys_user` VALUES (300, 'e_operating', 'bcb15f821479b4d5772bd0ca866c00ad5f926e3580720659cc80d39c9d09802a', '25686111@qq.com', '15689745555', 1, 1, '2020-12-17 15:41:36', NULL, NULL, 3, 'mhbs990053989883052032', '');
INSERT INTO `sys_user` VALUES (301, 'cw_yw_c1', 'bcb15f821479b4d5772bd0ca866c00ad5f926e3580720659cc80d39c9d09802a', '111111111@qq.com', '17800000001', 1, 1, '2021-03-11 15:12:18', NULL, 171, 2, 'mhbs990053989883052032', 'CW001');
INSERT INTO `sys_user` VALUES (302, 'yw_admin', 'bcb15f821479b4d5772bd0ca866c00ad5f926e3580720659cc80d39c9d09802a', '17800001234@qq.com', '17800001234', 0, 1, '2021-03-11 15:31:53', NULL, NULL, 3, 'mhbs990053989883052032', '');
INSERT INTO `sys_user` VALUES (303, 'cw_yw_c2', 'bcb15f821479b4d5772bd0ca866c00ad5f926e3580720659cc80d39c9d09802a', '12522522222@qq.com', '17344551000', 1, 1, '2021-03-17 17:26:45', NULL, 171, 2, 'mhbs990053989883052032', 'CW001');
INSERT INTO `sys_user` VALUES (304, 'cw_yw_c3', 'bcb15f821479b4d5772bd0ca866c00ad5f926e3580720659cc80d39c9d09802a', '123456@qq.com', '15689892222', 1, 1, '2021-03-17 17:27:20', NULL, 171, 2, 'mhbs990053989883052032', 'CW001');
INSERT INTO `sys_user` VALUES (305, 'cw_yw_c4', 'bcb15f821479b4d5772bd0ca866c00ad5f926e3580720659cc80d39c9d09802a', '12344556@qq.com', '17844422341', 1, 1, '2021-03-17 17:28:04', NULL, 171, 2, 'mhbs990053989883052032', 'CW001');
INSERT INTO `sys_user` VALUES (306, 'cw_yw_c5', 'bcb15f821479b4d5772bd0ca866c00ad5f926e3580720659cc80d39c9d09802a', '223224535@qq.com', '18577421000', 1, 1, '2021-03-17 17:28:52', NULL, 171, 2, 'mhbs990053989883052032', 'CW001');
INSERT INTO `sys_user` VALUES (307, 'cw_yw_c6', 'bcb15f821479b4d5772bd0ca866c00ad5f926e3580720659cc80d39c9d09802a', '232398123@qq.com', '15388940903', 1, 1, '2021-03-17 17:29:27', NULL, 171, 2, 'mhbs990053989883052032', 'CW001');
INSERT INTO `sys_user` VALUES (308, 'cw_yw_c7', 'bcb15f821479b4d5772bd0ca866c00ad5f926e3580720659cc80d39c9d09802a', '326378264@qq.com', '18356556632', 1, 1, '2021-03-17 17:30:06', NULL, 171, 2, 'mhbs990053989883052032', 'CW001');
INSERT INTO `sys_user` VALUES (309, 'cw_yw_c8', 'bcb15f821479b4d5772bd0ca866c00ad5f926e3580720659cc80d39c9d09802a', '4326546235@qq.com', '15633232410', 1, 1, '2021-03-17 17:30:41', NULL, 171, 2, 'mhbs990053989883052032', 'CW001');
INSERT INTO `sys_user` VALUES (310, 'penglilin', 'bcb15f821479b4d5772bd0ca866c00ad5f926e3580720659cc80d39c9d09802a', '52468253@qq.com', '15379754815', 1, 1, '2021-06-17 09:23:58', NULL, NULL, 3, 'mhbs990053989883052032', '');
INSERT INTO `sys_user` VALUES (311, 'xiaojiaojiao', 'bcb15f821479b4d5772bd0ca866c00ad5f926e3580720659cc80d39c9d09802a', '1545231235@qq.com', '17689893636', 1, 1, '2021-07-19 14:16:39', NULL, NULL, 3, 'mhbs990053989883052032', '');
INSERT INTO `sys_user` VALUES (312, 'tianjiagui', 'bcb15f821479b4d5772bd0ca866c00ad5f926e3580720659cc80d39c9d09802a', '5456212341@qq.com', '15625252323', 1, 1, '2021-07-19 14:17:19', NULL, NULL, 3, 'mhbs990053989883052032', '');
INSERT INTO `sys_user` VALUES (313, 'linchuqi', '1e12c1e01097cf3861ff603cd173c6b4376ee0a3e438ab7c92a7ae68a245dea8', '56865642@qq.com', '18986457575', 1, 1, '2021-07-19 14:17:59', NULL, NULL, 3, 'mhbs990053989883052032', '');
INSERT INTO `sys_user` VALUES (314, 'yuanweicai', 'bcb15f821479b4d5772bd0ca866c00ad5f926e3580720659cc80d39c9d09802a', '23123213@qq.com', '15612341111', 1, 1, '2021-07-19 14:20:02', NULL, NULL, 3, 'mhbs990053989883052032', '');
INSERT INTO `sys_user` VALUES (315, 'zhonganjian', 'bcb15f821479b4d5772bd0ca866c00ad5f926e3580720659cc80d39c9d09802a', '1323@qq.com', '17689562341', 1, 1, '2021-09-28 15:05:40', NULL, NULL, 3, 'mhbs990053989883052032', '');
INSERT INTO `sys_user` VALUES (316, 'e_test', 'bcb15f821479b4d5772bd0ca866c00ad5f926e3580720659cc80d39c9d09802a', '3427@qq.com', '17683565210', 1, 1, '2021-10-14 11:39:05', NULL, NULL, 3, 'mhbs990053989883052032', '');
INSERT INTO `sys_user` VALUES (317, 'haikongtest001', 'bcb15f821479b4d5772bd0ca866c00ad5f926e3580720659cc80d39c9d09802a', '123@qq.com', '18888888888', 1, 1, '2021-11-30 03:12:55', NULL, NULL, 1, 'mhbs990053989883052032', '');

-- ----------------------------
-- Table structure for sys_user_biz_permission
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_biz_permission`;
CREATE TABLE `sys_user_biz_permission`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `user_id` bigint(20) DEFAULT NULL COMMENT '用户ID',
  `permission_id` bigint(20) DEFAULT NULL COMMENT '权限ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户业务权限表' ROW_FORMAT = Compact;

-- ----------------------------
-- Records of sys_user_biz_permission
-- ----------------------------
INSERT INTO `sys_user_biz_permission` VALUES (4, 1, 7);

-- ----------------------------
-- Table structure for sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `user_id` bigint(20) DEFAULT NULL COMMENT '用户ID',
  `role_id` bigint(20) DEFAULT NULL COMMENT '角色ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 260 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户与角色对应关系' ROW_FORMAT = Compact;

-- ----------------------------
-- Records of sys_user_role
-- ----------------------------
INSERT INTO `sys_user_role` VALUES (9, 1, 1);
INSERT INTO `sys_user_role` VALUES (221, 288, 18);
INSERT INTO `sys_user_role` VALUES (223, 290, 20);
INSERT INTO `sys_user_role` VALUES (224, 291, 20);
INSERT INTO `sys_user_role` VALUES (226, 293, 20);
INSERT INTO `sys_user_role` VALUES (227, 294, 20);
INSERT INTO `sys_user_role` VALUES (228, 295, 20);
INSERT INTO `sys_user_role` VALUES (229, 296, 20);
INSERT INTO `sys_user_role` VALUES (230, 297, 20);
INSERT INTO `sys_user_role` VALUES (232, 298, 25);
INSERT INTO `sys_user_role` VALUES (233, 292, 21);
INSERT INTO `sys_user_role` VALUES (235, 300, 26);
INSERT INTO `sys_user_role` VALUES (239, 302, 28);
INSERT INTO `sys_user_role` VALUES (240, 301, 27);
INSERT INTO `sys_user_role` VALUES (241, 303, 27);
INSERT INTO `sys_user_role` VALUES (242, 304, 27);
INSERT INTO `sys_user_role` VALUES (243, 305, 27);
INSERT INTO `sys_user_role` VALUES (244, 306, 27);
INSERT INTO `sys_user_role` VALUES (245, 307, 27);
INSERT INTO `sys_user_role` VALUES (246, 308, 27);
INSERT INTO `sys_user_role` VALUES (247, 309, 27);
INSERT INTO `sys_user_role` VALUES (250, 299, 29);
INSERT INTO `sys_user_role` VALUES (251, 310, 26);
INSERT INTO `sys_user_role` VALUES (252, 311, 21);
INSERT INTO `sys_user_role` VALUES (253, 312, 21);
INSERT INTO `sys_user_role` VALUES (254, 313, 21);
INSERT INTO `sys_user_role` VALUES (255, 314, 21);
INSERT INTO `sys_user_role` VALUES (256, 315, 26);
INSERT INTO `sys_user_role` VALUES (257, 316, 18);
INSERT INTO `sys_user_role` VALUES (259, 317, 30);

-- ----------------------------
-- Table structure for sys_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_log`;
CREATE TABLE `sys_log`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `username` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '用户名',
  `operation` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '用户操作',
  `method` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '请求方法',
  `params` varchar(5000) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '请求参数',
  `ip` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT 'IP地址',
  `create_date` datetime(0) DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 27096 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '系统日志' ROW_FORMAT = Compact;

-- ----------------------------
-- Table structure for sys_oss
-- ----------------------------
DROP TABLE IF EXISTS `sys_oss`;
CREATE TABLE `sys_oss`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `url` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT 'URL地址',
  `create_date` datetime(0) DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 9184 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '文件上传' ROW_FORMAT = Compact;

SET FOREIGN_KEY_CHECKS = 1;


SET FOREIGN_KEY_CHECKS = 1;


-- 添加菜单SQL
INSERT INTO `sys_menu` (`parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`, `status`) VALUES ('942','短信发送记录','aliyunsms/sendsmsrecord.html',NULL,'1','fa fa-file-code-o','6','0');