/* 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');