/* Navicat Premium Data Transfer Source Server : 吉亨测试阿里云数据库 Source Server Type : MySQL Source Server Version : 50718 Source Host : 39.100.230.190:8092 Source Schema : crocodile Target Server Type : MySQL Target Server Version : 50718 File Encoding : 65001 Date: 19/08/2021 11:05:11 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for approval_rule -- ---------------------------- DROP TABLE IF EXISTS `approval_rule`; CREATE TABLE `approval_rule` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一id主键', `approval_level` int(10) NOT NULL COMMENT '1 代表1级别审批 2代表2级别审批以此类推先后台配置', `role_id` bigint(20) NOT NULL COMMENT '对应的角色', `type` int(10) NOT NULL COMMENT '1 新建计划审批 2 首件审批 3 防错审批 以此类推', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `approval_level`(`approval_level`, `type`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '纠错审批规则设置' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of approval_rule -- ---------------------------- INSERT INTO `approval_rule` VALUES (5, 1, 3, 1); INSERT INTO `approval_rule` VALUES (6, 2, 4, 1); INSERT INTO `approval_rule` VALUES (7, 1, 2, 3); INSERT INTO `approval_rule` VALUES (8, 2, 3, 3); INSERT INTO `approval_rule` VALUES (9, 1, 2, 2); INSERT INTO `approval_rule` VALUES (10, 2, 3, 2); -- ---------------------------- -- Table structure for benteler_plan -- ---------------------------- DROP TABLE IF EXISTS `benteler_plan`; CREATE TABLE `benteler_plan` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键id', `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '计划名称', `plan_type` int(1) NULL DEFAULT NULL COMMENT '计划类型 1首件 2防错', `pause_flag` tinyint(1) NULL DEFAULT NULL COMMENT '是否禁用暂停', `deleted` int(1) NULL DEFAULT NULL COMMENT '逻辑删除', `created_user_id` bigint(20) NULL DEFAULT NULL COMMENT '创建人', `created_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `updated_user_id` bigint(20) NULL DEFAULT NULL COMMENT '最近更新人', `updated_time` datetime(0) NULL DEFAULT NULL COMMENT '最近更新时间', `effective_date` date NULL DEFAULT NULL COMMENT '生效日期', `prev_id` bigint(20) NULL DEFAULT NULL COMMENT '上一个计划版本ID', `original_id` bigint(20) NULL DEFAULT NULL COMMENT '原始计划ID', `status` int(11) NULL DEFAULT NULL COMMENT '当前状态：1待审核2审核不通过3审核通过待生效4最新版本5已经过期', `file_id` int(11) NULL DEFAULT NULL COMMENT '对应指导文件id', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '本特勒检测计划' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for benteler_plan_bak -- ---------------------------- DROP TABLE IF EXISTS `benteler_plan_bak`; CREATE TABLE `benteler_plan_bak` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键id', `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '计划名称', `plan_type` int(1) NULL DEFAULT NULL COMMENT '计划类型 1首件 2防错', `pause_flag` tinyint(1) NULL DEFAULT NULL COMMENT '是否禁用暂停', `deleted` int(1) NULL DEFAULT NULL COMMENT '逻辑删除', `created_user_id` bigint(20) NULL DEFAULT NULL COMMENT '创建人', `created_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `updated_user_id` bigint(20) NULL DEFAULT NULL COMMENT '最近更新人', `updated_time` datetime(0) NULL DEFAULT NULL COMMENT '最近更新时间', `effective_date` date NULL DEFAULT NULL COMMENT '生效日期', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '本特勒检测计划' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for cn_dict -- ---------------------------- DROP TABLE IF EXISTS `cn_dict`; CREATE TABLE `cn_dict` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `create_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP, `dict_key` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'key', `dict_val` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'value', `note` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '内容', `desc` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '描述', `sort` int(11) NOT NULL DEFAULT 0, `service_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'bs' COMMENT '服务', PRIMARY KEY (`id`) USING BTREE, INDEX `dict_key`(`dict_key`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 42 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '字典表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of cn_dict -- ---------------------------- INSERT INTO `cn_dict` VALUES (10, '2020-02-12 14:30:50', 'shift', 'A', 'A班', '班次', 10, 'bs'); INSERT INTO `cn_dict` VALUES (11, '2020-02-12 14:31:38', 'shift', 'B', 'B班', '班次', 20, 'bs'); -- ---------------------------- -- Table structure for first_article_approval_task -- ---------------------------- DROP TABLE IF EXISTS `first_article_approval_task`; CREATE TABLE `first_article_approval_task` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一id主键', `first_article_task_id` bigint(20) NOT NULL COMMENT '任务关联id', `approval_level` int(10) NOT NULL COMMENT '1 代表1级别审批 2代表2级别审批以此类推先后台配置', `approval_user_id` bigint(20) NULL DEFAULT NULL COMMENT '对应的用户的userid 插入任务指定这个人，这个人就可以审批了', `status` int(10) NOT NULL DEFAULT 0 COMMENT '审批状态 0 初始化 1放行 2不放行', `created_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `updated_time` datetime(0) NULL DEFAULT NULL COMMENT '审批时间', `reason` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '审批意见', `approval_role` bigint(20) NOT NULL COMMENT '审批角色', PRIMARY KEY (`id`) USING BTREE, INDEX `status`(`status`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '审批任务表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for first_article_calendar -- ---------------------------- DROP TABLE IF EXISTS `first_article_calendar`; CREATE TABLE `first_article_calendar` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一id主键', `benteler_plan_id` bigint(20) NOT NULL COMMENT '关联benteler_plan表的id', `first_start` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '首件开始时间', `first_remind` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '首件提醒时间', `first_end` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '首件（检测结束时间）', `two_remind` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '200件提交时间（pad提醒时间）', `uplever_time_num` int(32) NULL DEFAULT NULL COMMENT '升级时长(分钟)', `type_flag` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '0:首件 1:200件 2:中断 判断该计划有几种类型', `principal_one_shift` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '责任人1班次', `principal_one_id` int(16) NULL DEFAULT NULL COMMENT '责任人1 id', `principal_two_shift` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '责任人2班次', `principal_two_id` int(16) NULL DEFAULT NULL COMMENT '责任人2id', PRIMARY KEY (`id`) USING BTREE, INDEX `benteler_plan_id`(`benteler_plan_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '记录计划的提醒时间 和人员配置' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for first_article_item -- ---------------------------- DROP TABLE IF EXISTS `first_article_item`; CREATE TABLE `first_article_item` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一id主键', `workshop_id` bigint(20) NOT NULL COMMENT '关联在工作站id', `item_content` varchar(1024) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '检查描述', `item_standard` varchar(1024) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '检查标准', `prefix` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '前缀', `sno_start` smallint(3) NOT NULL DEFAULT 0 COMMENT '序号开始', `sno_end` smallint(3) NOT NULL DEFAULT 0 COMMENT '序号结束', `val_flag` smallint(3) NOT NULL DEFAULT 0 COMMENT '0 数值 1 属性', `val_up` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '对应 0数值类型 上限', `val_down` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '0对应 0数值类型 下限', `val_ok` smallint(3) NOT NULL DEFAULT 0 COMMENT '对应 1 属性 0 表示ok 1表示 nook', `val_desc` varchar(1024) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '对应 1 属性 描述', `level_info` varchar(1024) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '特性等级', `product_info` varchar(1024) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '产品特性', `tool_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '工具id', `tool_desc` varchar(1024) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '工具描述', `first_flag` smallint(3) NOT NULL DEFAULT 0 COMMENT '0 没选择 1 选择', `two_hundred_flag` smallint(3) NOT NULL DEFAULT 0 COMMENT '0 没选择 1 选择', `catch_flag` smallint(3) NOT NULL DEFAULT 0 COMMENT '0 没选择 1 选择', `val_unit` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '单位 对应0数值', PRIMARY KEY (`id`) USING BTREE, INDEX `workshop_id`(`workshop_id`) USING BTREE, CONSTRAINT `first_article_wk_ibfk_1` FOREIGN KEY (`workshop_id`) REFERENCES `first_article_workshop` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '项目设置' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for first_article_item_result -- ---------------------------- DROP TABLE IF EXISTS `first_article_item_result`; CREATE TABLE `first_article_item_result` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一id主键', `first_article_task_id` bigint(20) NOT NULL, `first_article_item_id` bigint(20) NOT NULL, `val` varchar(1024) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '对应数据类型0数值', `val_desc` varchar(1024) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '对应数据类型1属性', `created_user_id` bigint(20) NULL DEFAULT NULL COMMENT '创建人', `created_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `prefix` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '前缀', `sno` int(10) NOT NULL DEFAULT 0 COMMENT '序号', `tool_desc` varchar(1024) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '工具描述', `abnormal` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '异常信息', `order_number` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '订单号', `result` int(10) NOT NULL COMMENT '-1 不通过重检 0 通过 1 巡检不通过 2 没有巡检（这个是预留字段现在不对应）', `result_bak` int(10) NOT NULL DEFAULT 0 COMMENT 'task整体提交时，备份result字段的值 0 通过 1 巡检不通过 2 没有巡检', PRIMARY KEY (`id`) USING BTREE, INDEX `first_article_item_id`(`first_article_item_id`) USING BTREE, CONSTRAINT `first_article_item_result_ibfk_1` FOREIGN KEY (`first_article_item_id`) REFERENCES `first_article_item` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for first_article_task -- ---------------------------- DROP TABLE IF EXISTS `first_article_task`; CREATE TABLE `first_article_task` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一id主键', `first_article_calendar_id` bigint(20) NOT NULL COMMENT '首件巡检时间表id', `status` smallint(3) NOT NULL DEFAULT 0 COMMENT '0 初始化 1 待审核状态 2放行 3 不通过 4 员工提交直接通过', `task_time` date NULL DEFAULT NULL COMMENT '任务创建时间 ，这个应该是精确到日的', `remind_task_flag` smallint(3) NOT NULL DEFAULT 0 COMMENT '是否发送了任务提醒给操作者 0 没提醒 1 已提醒', `remind_nowork_flag` smallint(3) NOT NULL DEFAULT 0 COMMENT '没工作提醒是不是已经完成 0 没提醒 1 已提醒', `type_flag` int(1) NULL DEFAULT NULL COMMENT '首件类型 0首件 1：200件 2中断', `submit_time` datetime(0) NULL DEFAULT NULL COMMENT '提交任务时候 记录提交时间', `submit_user_id` bigint(11) NULL DEFAULT NULL COMMENT '提交任务时候 记录人id', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '任务表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for first_article_task_his_blob -- ---------------------------- DROP TABLE IF EXISTS `first_article_task_his_blob`; CREATE TABLE `first_article_task_his_blob` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一id主键', `first_article_task_id` bigint(20) NOT NULL COMMENT '任务id', `his_content` blob NOT NULL COMMENT '备份任务检查结果', `created_user_id` bigint(20) NULL DEFAULT NULL COMMENT '创建人', `created_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '任务和巡检结果历史备份' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for first_article_task_key -- ---------------------------- DROP TABLE IF EXISTS `first_article_task_key`; CREATE TABLE `first_article_task_key` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一id主键', `first_article_calendar_id` bigint(20) NOT NULL COMMENT '首件巡检时间表id', `task_time` date NULL DEFAULT NULL COMMENT '任务创建时间 ，这个应该是精确到日的', `type_flag` int(11) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `first_article_calendar_id`(`first_article_calendar_id`, `task_time`, `type_flag`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '任务表唯一表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for first_article_title_blob -- ---------------------------- DROP TABLE IF EXISTS `first_article_title_blob`; CREATE TABLE `first_article_title_blob` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一id主键', `benteler_plan_id` bigint(20) NOT NULL COMMENT '计划关联', `title_content` blob NOT NULL, PRIMARY KEY (`id`) USING BTREE, INDEX `benteler_plan_id`(`benteler_plan_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '没给计划对应的所有表头信息存储' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for first_article_workshop -- ---------------------------- DROP TABLE IF EXISTS `first_article_workshop`; CREATE TABLE `first_article_workshop` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一id主键', `benteler_plan_id` bigint(20) NOT NULL COMMENT '关联benteler_plan表的id', `ws_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '工作站名称', `pl_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '生产线名称', PRIMARY KEY (`id`) USING BTREE, INDEX `benteler_plan_id`(`benteler_plan_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '这是一个抽象为了以后可以公用选项设计，而且可以有效pad端查询' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for nowork_remind_rule -- ---------------------------- DROP TABLE IF EXISTS `nowork_remind_rule`; CREATE TABLE `nowork_remind_rule` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一id主键', `role_id` bigint(10) NOT NULL COMMENT '对应的角色', `type` int(10) NOT NULL COMMENT ' 1首件没完成工作提醒 2 防错没完成工作提醒 以此类推', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '提醒规则设置' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of nowork_remind_rule -- ---------------------------- INSERT INTO `nowork_remind_rule` VALUES (1, 3, 2); INSERT INTO `nowork_remind_rule` VALUES (2, 3, 1); -- ---------------------------- -- Table structure for onsite_approval_plan -- ---------------------------- DROP TABLE IF EXISTS `onsite_approval_plan`; CREATE TABLE `onsite_approval_plan` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一id主键', `benteler_plan_id` bigint(20) NOT NULL COMMENT '关联benteler_plan表的id', `approval_level` int(10) NOT NULL COMMENT '1代表1级别审批 2代表2级别审批 以此类推先后台配置', `approval_user_id` bigint(20) NULL DEFAULT NULL COMMENT '审批人的userId', `status` int(10) NOT NULL DEFAULT 0 COMMENT '审批状态 0未审批 1审批通过 2驳回', `created_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `updated_time` datetime(0) NULL DEFAULT NULL COMMENT '审批时间', `reason` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '审批意见', `approval_role` bigint(20) NOT NULL COMMENT '角色ID', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '计划审批表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for onsite_approval_task -- ---------------------------- DROP TABLE IF EXISTS `onsite_approval_task`; CREATE TABLE `onsite_approval_task` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一id主键', `onsite_task_id` bigint(20) NOT NULL COMMENT '任务关联id', `approval_level` int(10) NOT NULL COMMENT '1 代表1级别审批 2代表2级别审批以此类推先后台配置', `approval_user_id` bigint(20) NULL DEFAULT NULL COMMENT '对应的用户的userid 插入任务指定这个人，这个人就可以审批了', `status` int(10) NOT NULL DEFAULT 0 COMMENT '审批状态 0 初始化 1放行 2不放行', `created_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `updated_time` datetime(0) NULL DEFAULT NULL COMMENT '审批时间', `reason` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '审批意见', `approval_role` bigint(220) NOT NULL COMMENT '审批角色', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '审批任务表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for onsite_calendar -- ---------------------------- DROP TABLE IF EXISTS `onsite_calendar`; CREATE TABLE `onsite_calendar` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一id主键', `benteler_plan_id` bigint(20) NOT NULL COMMENT '关联benteler_plan表的id', `start_day` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '日巡检开始时间 格式：10:00', `end_day` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '日巡检结束时间 格式11:00', `day_validate` int(10) NOT NULL DEFAULT 60 COMMENT '日检查时长设置单位分钟 例如60', `day_outtime` int(10) NOT NULL DEFAULT 60 COMMENT '升级时长设置单位是分钟 例如60 这个时间其实是汇报超时给监督', `week_day` smallint(3) NOT NULL DEFAULT -1 COMMENT '周巡检时间设置 1-7 ', `month_day` smallint(3) NOT NULL DEFAULT -1 COMMENT '设置月巡检时间 1-28 这个要考虑最小的月份，要么就需要扩展个字段几月用于月设置', `month` smallint(3) NOT NULL DEFAULT -1 COMMENT '这个用于月巡检备用预留字段，因为可能不用月巡检的日子是不一样的', `user_id` bigint(20) NOT NULL, `type_flag` smallint(3) NOT NULL DEFAULT 0 COMMENT '0 日巡检 1 周巡检 2 月巡检 这个如果有常数代码对应调整', `shift` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'A' COMMENT '班次', `effect_flag` tinyint(1) NULL DEFAULT 0 COMMENT '是否有对应类型点检内容', PRIMARY KEY (`id`) USING BTREE, INDEX `benteler_plan_id`(`benteler_plan_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '这个表日月周目前都只设置一个，目前对应useid也是一个本项目，但之后应该是\r\n每个人可以有一套信息的这个时间表是为了扩展和满足现有设计' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for onsite_item -- ---------------------------- DROP TABLE IF EXISTS `onsite_item`; CREATE TABLE `onsite_item` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一id主键', `workshop_id` bigint(20) NOT NULL COMMENT '关联在工作站id', `item_content` varchar(1024) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '巡检项目内容设置', `type_flag` smallint(3) NOT NULL DEFAULT 0 COMMENT '0 日巡检 1 周巡检 2 月巡检 这个如果有常数代码对应调整', `inspection_flag` smallint(3) NOT NULL DEFAULT 0 COMMENT '0非手动 1 手动', PRIMARY KEY (`id`) USING BTREE, INDEX `workshop_id`(`workshop_id`) USING BTREE, CONSTRAINT `onsite_item_ibfk_1` FOREIGN KEY (`workshop_id`) REFERENCES `onsite_workshop` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '巡检项目设置' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for onsite_item_result -- ---------------------------- DROP TABLE IF EXISTS `onsite_item_result`; CREATE TABLE `onsite_item_result` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一id主键', `onsite_task_id` bigint(20) NOT NULL COMMENT '计划关联', `onsite_item_id` bigint(20) NOT NULL COMMENT '输入内容id', `result` int(10) NOT NULL COMMENT '0 通过 1 巡检不通过 2 没有巡检（这个是预留字段现在不对应）', `created_user_id` bigint(20) NULL DEFAULT NULL COMMENT '创建人', `created_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `abnormal` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '异常信息', `result_bak` int(10) NOT NULL DEFAULT 0 COMMENT 'task整体提交时，备份result字段的值 0 通过 1 巡检不通过 2 没有巡检', PRIMARY KEY (`id`) USING BTREE, INDEX `onsite_item_id`(`onsite_item_id`) USING BTREE, CONSTRAINT `onsite_item_result_ibfk_1` FOREIGN KEY (`onsite_item_id`) REFERENCES `onsite_item` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '巡检结果表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for onsite_plan_his_blob -- ---------------------------- DROP TABLE IF EXISTS `onsite_plan_his_blob`; CREATE TABLE `onsite_plan_his_blob` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一id主键', `benteler_plan_id` bigint(20) NOT NULL COMMENT '计划关联', `his_content` blob NOT NULL COMMENT '备份完整的历史内容json', `created_user_id` bigint(20) NULL DEFAULT NULL COMMENT '创建人', `created_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`id`) USING BTREE, INDEX `benteler_plan_id`(`benteler_plan_id`) USING BTREE, CONSTRAINT `onsite_plan_his_blob_ibfk_1` FOREIGN KEY (`benteler_plan_id`) REFERENCES `benteler_plan_bak` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '存储历史备份' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for onsite_task -- ---------------------------- DROP TABLE IF EXISTS `onsite_task`; CREATE TABLE `onsite_task` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一id主键', `onsite_calendar_id` bigint(20) NOT NULL COMMENT '巡检时间表id', `status` smallint(3) NOT NULL DEFAULT 0 COMMENT '0 初始化 1 待审核状态 2放行 3 不通过 4 员工提交直接通过', `task_time` date NULL DEFAULT NULL COMMENT '任务创建时间 ，这个应该是精确到日的', `remind_task_flag` smallint(3) NOT NULL DEFAULT 0 COMMENT '是否发送了任务提醒给操作者 0 没提醒 1 已提醒', `remind_nowork_flag` smallint(3) NOT NULL DEFAULT 0 COMMENT '没工作提醒是不是已经完成 0 没提醒 1 已提醒', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `onsite_calendar_id`(`onsite_calendar_id`, `task_time`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '任务表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for onsite_task_his_blob -- ---------------------------- DROP TABLE IF EXISTS `onsite_task_his_blob`; CREATE TABLE `onsite_task_his_blob` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一id主键', `onsite_task_id` bigint(20) NOT NULL COMMENT '任务id', `his_content` blob NOT NULL COMMENT '备份任务检查结果', `created_user_id` bigint(20) NULL DEFAULT NULL COMMENT '创建人', `created_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '任务和巡检结果历史备份' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for onsite_title_blob -- ---------------------------- DROP TABLE IF EXISTS `onsite_title_blob`; CREATE TABLE `onsite_title_blob` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一id主键', `benteler_plan_id` bigint(20) NOT NULL COMMENT '计划关联', `title_content` blob NOT NULL, PRIMARY KEY (`id`) USING BTREE, INDEX `benteler_plan_id`(`benteler_plan_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '没给计划对应的所有表头信息存储' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for onsite_workshop -- ---------------------------- DROP TABLE IF EXISTS `onsite_workshop`; CREATE TABLE `onsite_workshop` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一id主键', `benteler_plan_id` bigint(20) NOT NULL COMMENT '关联benteler_plan表的id', `ws_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '工作站名称', PRIMARY KEY (`id`) USING BTREE, INDEX `benteler_plan_id`(`benteler_plan_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '这是一个抽象为了以后可以公用选项设计，而且可以有效pad端查询' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for plan_bind -- ---------------------------- DROP TABLE IF EXISTS `plan_bind`; CREATE TABLE `plan_bind` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一id主键', `old_benteler_plan_id` bigint(20) NOT NULL COMMENT '旧的计划id', `new_benteler_plan_id` bigint(20) NOT NULL COMMENT '新的计划id', `created_user_id` bigint(20) NULL DEFAULT NULL COMMENT '创建人', `created_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '计划绑定表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for remind_approval_task -- ---------------------------- DROP TABLE IF EXISTS `remind_approval_task`; CREATE TABLE `remind_approval_task` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一id主键', `task_id` bigint(20) NOT NULL COMMENT '不同类型对应不同的任务id', `approval_user_id` bigint(20) NULL DEFAULT NULL COMMENT '这个人审批的', `task_type` smallint(3) NOT NULL COMMENT ' 首件 1 防错 2', `status` int(10) NOT NULL DEFAULT 0 COMMENT '审批状态 0 初始化 1已经处理', `approval_role_id` bigint(20) NULL DEFAULT NULL COMMENT '审批角色', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '提醒确认任务表，用于小程序查询' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for upload_file_blob -- ---------------------------- DROP TABLE IF EXISTS `upload_file_blob`; CREATE TABLE `upload_file_blob` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一id主键', `file` longblob NOT NULL, `file_nm` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '没给计划对应的所有表头信息存储' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of upload_file_blob -- ---------------------------- INSERT INTO `upload_file_blob` VALUES (1, 0x89504E470D0A1A0A0000000D494844520000021A000000910806000000855111140000200049444154789CED9D0FB41755B5C7BFB7AB1750140215DE45141F3C14FB036190869AA651F04479F174699A062F4D45F25F99A6E9D3B44CF35F1A66F9347D922E7911544B9615A166659116C9D2A7E192050B0351FEE8B51B3789B7CE738F0D73E79C3967E6CCDFDFF7B3D62CB8BF993967CF993333FBECB3CFDE6D983277338001A8071702B80D404F81D29E0CE0BE0AB54E9F0CD73F06C0339EE549CB8D00AE03B0DEF1FCCFCB794D628EF46B1706013807C095156A8770DFEC00B0D563D9BF0470A8C7F2B2F27100DFAF903CC300BC14F3FBF61264C9429A67210DCFC8FB9014C03B6AA464286E9097D7EB008E073024873A547B8C05F06B7948ABA46428DA1D8F1F211FE6ED1552321417005827729D0A604FCB6B1B5A806C4563734DEDD23755BFFF0B80572BA66428FA85FEDFE1B9EC3D23E5178D52EC8E00F0B2F4D92A291948F15EA82AB74AFB3E07601280FE39C97952FD9BAA36CC7A474D05579DEF41000F0118EEB96CF501FC0380833D975B061300BC2856802A738FBCC0F768409BE785EAF39BA5DF97F9C12D8BD125D7FF65004B45E121F9A3EEF7E300AECEA92665FD798CF73177BA013C5C574523603C80D53222CECA08F9285F5EFA5599B11DB9A807F4B76509999275326AF43D1AAE3AA67BDA21FD7C7383AEA94EA8F7C24A006737E47AEAC6B962C11BE4B94F6D00F0AFADD184A5324E297575573402EE910F54161E96974A13508AD7A535BD8EA5327545DE4259EC9E645B94869A22195903399BA2D8C5D14FA60A7DD3056071A5AEB459AC01F03CC447A329A80FD47129AE45F9793C5A01D3AC2FCE11C5ABCE284BCCBB1BFEF20CB32DE63775ED9D329AAE2371D75427F61425637C4D64AE7B7BDBF0740E65CEC8A14CF2168707FF6992A2A15898E29C53C30D5273868833551378BAC5150DC5DA82E520FF60B2AC2C21D5618C3843FB443D7BE7F11E7B673E804D41A14D5334205320B62B6986D770A9A4EEE33B443CB59BC48F1A763D3AE2EEE937AA215A4B32A882ABCDC85B3C28D64E5FA8E5D8B7B06DBD7302802D41A14D5434263BAC5EC8CBA3B90C26D46CA9B20D93AB2F626ED0F9B03CAABE4AABD5B93887EB3FADD51BD523BDE2A03451D150FCCCE298119E56AB148DCECC5E77BF0C1D974756A1347D3AA54382C49172189ED3872C6F5A69A5561ECFC7033994D9AAF49A8ADAA9A10D61B37AA4297E190183AA2186775450AA6B1B764D49D06C5F1E5CF1540FD4F4C90ACF921E985350C3D9867DC1C0B1AC01D4373D9717EB5CDB5445031255EE9786FD751CB5C4A13AE831D513CB2B6AF5C52A29B0E9DEF50C5A562E759D3629322D431550EFEF591EAF5B95F32C8005393801DF05E0AF9ECBF4415FCF8AC62A69BF5E3475EA0416239326C5B94FB3DAA64EB4524E02469E2C9749AD7CF13522AFE9C52B7228735A0E656665670017792EF333BA1D4D5634DED522F396ADB004341C30A98973A9E151401D82433599565952DD04F208C5BF4212BBF944AD94790DC0C700EC5272BB778ADF5B8FE75C49F702F8896EA7AFA993373D9513E0432EE5B57FBE1F715A8679A1F9C4E0851B9D43B4FD7B578F71208685FEBF1CC0C00CF2F5CD213EC5308369D446BEEED0F19D9E652B8AEE6A88414866BE9D433CA2DD240AE94D00BE58D254CA180942978785D8681DF1A568A80435FB7A2AEB02C9D25A17DA4A96D3E708AC2BBCF639233EE78CC37E0B3D19CBCE6314B4C9E387D667B6CADDE49E92E2511979D737A8DDDF27C926B3F2318F61BFF3B258F74876D7FB7328FB7CD9D414CD9D9AD4FE3E51EF80FD45797A5F4E75DC92D4D79B3C7542082184A441A5B4D89863CB5D29C12547E57C775452BA65392A198A9B930EA0A241082184ECC87AC93C9A276A89EE9F24D7D6184FFE1B3B4BA8036535D90EE0CB395FC3B4D08A402D543408218490DEACB1F9887AE07089DF71A287B2F6954CB73716743FB50EA061A86810420821F114B9DCF9BFC43F64BA633A899DC53AB2542C2445F1215B7F392A1A841042483CAFC96A3C17DAE4E3AF62E27C01C0568773D5793F00F07571E4B4619664BB3EC2A19E5724D7D730A9D37551C3B3B259D17445836BE20921A49914F1FD52ABB64E713CA78F847C7845B283AB95645F722CE3D3A2E45C0F60EF98FD4324119CF2C3F89663D95F01F02F22D34B22ABEB0A5465CDD8607B302D1A84104288199754F2D125F46F4A46D389001E776CE7CFC939E1D4F8432440D6771DCA51531C4F01380AC0D7006C769423CC632E4A065A40D1687A5E0C42086955FE5EE075BB84EBFE46CC6F9B6599E961A270FCC6A1BC7D656A64B92C895D0760B2C3F98A7F037010809F8BA524CAA71DCAFA8863DDB46810420821164CB76CA44F4AC0361D4AE1383E455E95F73A2A185DE2EBA114959F251C6BCA301BE61A87FADF868A062184903A5264C65A55D72200CF5B1E7F87C4B3D0A196CE5E25FE1B57E724F348C946BCDAD056BB4826DC032CCBBC2C4DBB3759D16862F22D420821E571B665CDC78A05228937005C0BE06889A59105E50BF2479926196019D97477005FB57406BD30AD6C4D56345E2858E3258410521C6524F25B02E06ECB63EFB7FC80BF21E5BE4B148EB4A8D4F963012C143F0C9B64A73739D4E5E210BB034D56349EAA800C841042FC53A6C5FA12CBE3868A65C385476539ABAD02F0174998A696ABFED8B12E55CF3196C71EE258F60E3459D158500119082184F8E7B6122DD6EB1D427C7F478262D9A2AC106B258BF9EEE2CBA1E36551303E0360A5281DB6EC217E2436D9A295B5E5892CAB38E90C4A0821A46E2C2B59DEB996C72987D07352D6F17A82A2D19521CDBCCAAF32D5F25897A5BDB1F85234AAA6B09C5701190821A4295429CAF2FC0AF8DFBDE0F0A1BE585680A4F94E9AAED3C607238E5D1CFC2D2EF3E186D0548BC6FC0AC8400821C43FAEF127F2C22A73A9B0B242FDE0DF3561CDE3F09205D635BEB989BD2391DA0225E6EF8E7FBB64AD8BE33D19CC4969181BD13A8379AC764F7FAFB75CA64448949121CF7C5FFD11D2DFB789B7BC5328E216628CBCCB82F6EB08B55DF86FDDBC7752FB6F12D3795123FB1162CA77ED2F3DA1BFD5B6574639A6BB24F3CA1975AD873A8415578E973F7414E96F867D6922A38E96E5AC369CE76B658F2F4563EF84B9A4A250CE2D2B0AAEF30F3997AF1EAA0373AE833493BCFBE615127488F46669016DD2A7C076FF9F02EBD2A106908B2B204798E72534F8588B632F4FA1689848A3689C0EA0D3F2586F33034D9A3A518D726605E4F0CD1E31497A08A9027BF22E944AABBD17F6A9606C2465D1FBB0E5B12AD7C8198E0AA2AF7C2ECAA8300EC0672D8F1FE77366A0298AC672D1D49A085FE6849056675485AF5F4D6D3F6279EC1D9E5D165CF87D68CACE44977C53BDD10445E312D1BEB6544016425A092E8F2779A38250B5C92A8F2A67E3B64DB8064974668B2F8BC6290EC71EE4A9CEB7A9F38B6285A4DB4D1D16951092892A2D7924CDE304C70F6499F438F82BA929FE8105CB3AC7F2B8C5B200C12B7555347692D525CB4A8A775F347CA1932A52E51126A92FEF112BC6FC1A59AABB1D97DDCEF5A06CD8583BFA8A5F864D8237C5B43CDABCAE8A8629FD6E13E10B9D54115F665D42C29C0860484D5B64B6E57127C9F2F3244CCF98CDF3D75FACFE367E21F3F2FAD6D455D15031DEB74BCADE56533A0821A4C95C0A609DE4EE98E421B65291DCE150D7F70A700CFD9AC3B1B3F212A2EECE5CDF04F020950D4208691CFD2418D61935BBB07196C7A9E0594765A827C9A2A1E2657CDCB2ACD332C8914813BCC6D58D7A55CC6D75D27C09218424739D58B1C7D4A0ADB6C9D2D02596C7DF0B60DF84F2D23048A64C6CFC4036881CB9C52869D2F2B4FB017CB20272104208F18B8A27F44C8D1CE32FB13C4E85643FD9B0DF74BD268BC638C96962436E5326014D5B077F2B80998CA4496A4C9D1C7FAB16A5B1D5684527F1372D9D28CB6699643EB5E11A00C334079A729DE8E810B7021B1648AC925CF1A568BC99C39696BB6AD2116DA95A6C7F4202D6B2254AE3B116BD6E383A5C96894BE6D3F33DCA792C80032C8FB58DAF91095F1EAF2F25CC33B9D25F3205A6E56989275FC488ABAD803A48EBE0D334BC9B841326C533348FC04725325146E9BED89EA11CE597779C0CC2AA6C55EB960CA8375B1C7B21808701FCD4A1FCB8A91315AAFD26CBF3EF2E2AD3799343081F570119082184F867614DDA544D4DD8F29F31C7B9C6AA394DB2A9DB707DA62B73A0C98AC67D350EFA420821C4CCC135689F350ECB5D3F2881BC6C671AC22E063BC972D9CF599EAB1C409FB53C36334D56343AB8DC9510421ACBA76A7261CB1DC27A7F2FC3F4E9731272DC867929EB4845D3B32F7EBE0232104208F1CFCC1AB5E9210EC77E35F47FDB10E4C73A943FAD68DF96A62B1A47564006420821ADCD7A8765A473528468B01D54ABA99CDF147D279AAE683469992B2184901DE9A8497B6C0430DDF2D89DC4AA31D4E2D8DD017C02C0FB2DCB3E582281164AD3150D420821CD65788DAE6C9B2C29B5E15C007F4E88EEF941F1FD9867E940BAA2A8E5AC51A868104208A92B36A3FE2A716689B27CB8AC8AA96810420821C5714A096D7D5B99C1FBA868104208A92B7549B216D023531D1B0BAE778E442A2D052A1A84104248B1E49E3135846D72B7DCA0A2410821A4AED43583ED22C7F0E459B8B6A07AB450D1208410428AE7BC026AAC442C292A1A84104248F1ACC939E5FD13001EA982D5878A06218410520E7966503DBF2AF7D497A2E19ACA9610420869755E90D4EEBEB9512C1A9580160D420821A43C1EC8A1E6ABAA743F7D291AB6F9F30921AD411EF3C2755D614088891EC9A8EA8BCB1CD2D217022D1A84104248B9A88CAAAB3C49609B4FA5307C5922F600F04B8FBE1A75B2906C2FB8BE5D2211DEEA16198F98F11926F8F502DB7A8964A70CE4CFA35F6EF558569BC7B2E2589773F951F62A232B27F186BA779300ACCD58E0C4B212A799F0F541EF2B99E448FE445FE03427378BF535BD9AA32A20432BD3B7D51BA0012805613980B1192E6559159B815327F5838A45B35953E3AB0B2BC13D25CA41485DF94806B9DF53D56B6EBAA2F1BC615F5DCD8C9C2A6936AB1B747517554006572A3922242D4397645A75E5B12A0F529AAE68989C626E29500E426C79A5212DA52C1AB757400E57BE5D2F71DFA6A32272906C744BA655578EADDA4A93304D5734161BF6FDB840390871E18A86B4964FC7D6A2585A439949F370C9B8BAA8CA4A065A40D15891721F2165A12C01D734A8F54BCF1CE988AF25868464C12534F949556FE9262B1A87581C7350017210E2CAB60659DCEEAC800CAEEC532F71FF1F3A89378F0F595CD17975B8F74D553416489C77D30D50FB9ECA397B1E216999D190967BC152E9AF0ADBC4A9AE52219C2DA0A2D12C7AC4C133295FC92D7558E1D55445C3C5DBFD9AAACF6F9196E5C0865CF81335B4D0DC91B06A8D9022306560CD23195B2E3451D1D8474651B6AC91A87A75812397D6408D529EF59C03A14CD4753C52237955F0A4FD2B2007696D9E904CAC515424DE7BEBD2324D533466A45C4BAC5EEA87E6200F2159511FE7331BD28AD36B18BF665C056420AD4DDC345E9A25B0A5D1144563BD582516642843E56AE993B052A50AE419B0AB15AC25750B78D62566FC26382E6F91E7346E845655964B5E943C52791362C396C8EAAD9F88B5B3363441D150EB8DC77B1A2929CBC6D100667B28AB8EB442D451DFCA5451D1F89402BC1F80F905D59727EA99FD28808D3592F9B3759A13278D233C4D52BB383B75553496C808AF4D9C397D66AB53D691B952F67E15BCA9510F639F1EC79B3C96D50A724114DC6E8BE3B2D223311E4E90BE79740175BA62DB0EDD322A1B0C60208059D5B9042D1BE465DF26D3ACF32A265FDED6C8AAAE6C68959C3ACF4A66D6D9750C93DF8629732FAE801C36BC2651FBD44BEA8D02E77AFB03D85542FC768446FDC1BFDB3CFF1D25BA3F6A3253BF1F06E0E08CD7A9DAF517B2E4D707ED92F6386B565F25D7AF3C3E5CED724F3BE5EFACF76F7D492373D517FB49DFEC170A41EDBB3F26FD0D79D96F92699E342F7E25FB00C9401A3C63D1FA0374D98B5DE57571188F6340E8BDD05E81F6D75DCF888CF225959F9691917AD25E7FADA6103CA07B2E2A8D5234EA242F218410426A04D3C4134208212437A868104208212437A868104208212437A868104208212437A868104208212437A868104208212437A868104208212437A868104208212437A868104208212437A868104208212437A868104208212437A86810526F8284598342DB0049B446D2335C92386E0F6D37879293559D0E491E3840B6A07FD4457ED220A86810527FB6027835B46D06F075DED74CDC0DE0884801E70238B126F2ABECA8AF4B5FD81CEA1BE7544036D26250D120A4DE0CD1487F7628153EB14759888E922D8E7BC4DAE14A6051280A9DFC3788858390C2A0A24108213B3235A13D3E9AA2BDCE02F028DB99B4223BF1AE1342C8DB6C03B03CA139565834D79E003E00E05600234A68DEBF97502721B150D12084901D79D8D01E5B00BC60D15E6A8A650ADB95104E9D10424894F5008ED6B4CABE003658B418950C42042A1A8410D29BDF013812C062004FC82A948962D1208438C0A9134208E98D52281E918D1092015A3408218410921BB46890BAD02E5B38E2650F80EE18F9DB256641DF50244475EC1B0036265C6F3FD9768FFCFE9AD415579F0D41B97DE5DF7639675B6853F27589AC79136ECFF618796CA708544C865D43F7659BC8FFD78CED152E5FDDC39DE5DFE07E764B1D411FF0DD66FD22513483F689EB3F41144EC8F59B086258B4878E7169EFBC88BB8FDDA1FB98B67D3B22FD3E68D3ACFDBE7FA4DFC6F5B5B8F740B7D4677B4D81CCA67A3AA4FD760EF583E07DA3EEABCFBEA97BDEC2ED684347E4BA60789F9AEAB56A4B5A34489DD81A8A74B8D910E550456F7C19C06A002B6553FFBFCB62A9E16489A0F862647B55F6A561BCC4515065AC15799E936DA5D4B35AF61F5FE0FDD81A8A1AF9B26CAF4A54519BA04E13E4D8B5A1767E51FE7ED543144D25C3A522D75A293B68B7D5F2FBE60CF7C5C4E4485F0BDA6564CC39E744A2B26E36941B8DD419945BC612D880A09DA3F7719DC83A2165B923A40F6C96B25E34F4FB131D039A9D1569C74B638E897B0FAC95F36CFBE6E4483D7111772787FA68707D2FCA6F4A4E5F01D24668EED35A69DFB31CCA8A468E353D47A67AADFA471BA6CC75908D90D2182E2F8C283B8956AEA2605E0E60A685804A031F28FF6F17EDFC02005FB5BC38E514B82CE198C3658963DA0FC88500FEDB628543A73CF071EC03608D66DFCD12523B8E67011CA8D9A73E069F94F36DB905C04596233B35221C03E0F11479394E02F080E3393A96C6842057CC00B020F4F78004C5C296FD00ACF2243B2432EC3735FB8649BF571F9B871CF2E2D8F6FB9B44B94EC335D25F92FAFDF698DFA603784A02AA7DC7B2EEA4FA1E956B0AA31C83BF20EDF76BCB7A16C93D79C9F2F800D5BF8E01709FC339F300CC4EB092E9FA479BFCABDE2B2703B8CEA15E6DFFE0D409A93B6FA690BF9F8CE6D3B2505ED62646661CA5DE201FDDAB72B83F030C4A86E234C33E356ABADAB1BE734549BCD1E2D8F11922681619E2DB373E958C24748A69124AF9EB9370CCC80C4A0664E4DC93B2DF2FCCA1BEB8C067332D0734618E938FF744C7F394E5E55B8EE79C2CEFA7231DCF43C8FAB23085254BFB5EE4D40921EE748A05C434E2F6913DF5CA8CCA4A9CBF80FA183F6838679A665432404640AE4A46C00D165690113508D3DD6E714C53E9B0C860EBABDFCF2C30D3EC9532C2CFBBBE09F2ECD94CA574C834AAAB9211A0AC713F4B71DEE60CD3659D6201E9D58E54340849C70D05B5DB3D9ECB1B69988B55D32C3FD1EC7BBFBC8C752C12E5EB7E8343E4B92167B938E2E6D949B53059C27C7257C157AD9B66F2CDF11A3F9F28EF4C1810FC4E3EEA0BC421338EA332F8D7A4E5F371E751D120243D7B18CED4F9234C13FF9036D906274C551C6EC8D0EA8A1A8DFFD670CE2883DCBAD1D19D721DD3656EFE133225FB73CDF13FD58CE8940FCEA70DB25D24F205EDA64CD0B322C7D87ADC6721AA446D09C914DE74C41D6B3ABE8A8C35C8A45332A73AF67B24D49384F2BB181DD3CE2605C6D6AF23CCFFCA5451B49E9B0CE7D858ED5ED4FCFE23297F82F889CC10E5FD32CDF13F95BC3B45D2EB7D454583348565F2B11B262FB43EB2ED05E05A8B6B3C5D1CF276936DA06CB30DE78C32EC5B290FFF44394EC9B18B580CC24E5A1BC581D1349F6AAAC70593A7FD0CC33EDDF4CD2AB162C4F11F9ADF0FD6FC6E1A79ED0FE0F6488E1175BFE74BBBAA6DA885A322D9917BA56D074BDFDC25D4F74F30B495E95EAD948FFC54297BA894B944D3EF754EC749F5E8E811E5FC0A007F8A39E632F958C771AA635D4AA93E0CC0EF63F67DC5A0B8F44F983E196098823A45F3FB5DE2C41D57968D05254A97BC134749FF08DEA741FF38CF706EAFECC65434481338523EE88BC4AB3B58BBDE23DEE49718AE719A8C10EE940F67976C5B6433AD6278B761DF23E2D1BE4C3E901B0CEBCDD56FBF31949565641730C1E0B97EA79860E364EB6F4832F645592217876ACB2F69F6C59957871A647F4163ADE89276DD20F949E25EB4A437B3A4CF2B8BC2F3F2D10FE243047DFFC786763359D896C84768B194BDDE1023A32721415D9AA5DE6A45D42F0C2B2EFE0CE058C3F963227F9BBE913F00F08A669FFAFD0CC3B9C768FC7DFA6996D0421C565FD3ECFBB3C1A1F562831C719C200AC59D727F3686DEA741FFF8B6E17CFA68904662934D5387CE27A1695C6EB89E240FFFD19ADF934CC08B34BFEBAC1AA4184CD969034C4EAF45DDBFA4E06779E0DBA741379D675AAEAA9B429C9F50976EBAD235CE8CF77722150DD204B2BC9092623B14F5B2CBA39E76319D8E9711541CA30CB1361033C20B9314EBE069CDEF475949FF0F863B1E4FCCE89C07C3989E8BA256DEA4A9C7F639D2ADE63823326DF1B714328431F97DC42DC736F97DE9FC36025ED6FCEEBA12C8269AAFA99D7BE915543408692EAB65A9DA939A2BBCCDC21A5494D7FA4AC3BE85358F91D1348A5234D228DFB6B2C5F96F2826A5A8D3840AEEE5421A7F8ACAC3805D84E44B90234059158E9665A21D6229302DF52C820B2DEA30CD9327C51DE8908F85CDCBDF942575AC847F5E25322BBF974D05AD3221BDB151003A6489E628E94341BF1FED31247716FE98207B30AACFAA5499AC033BC7FC66728E6DD79C1346F97A7D20E6F73165FA3051D120245FCE72086D5E3459A76B7C7FE84F4F3035ABD52FDF97FF5F240E6965272323F14C36ACEEA8023A8B4695C9D2D74796A96870EA8490F4989E9F49928FA1AA4A062A361DD1235EEE4B2C8FBF4EA6851E2F392119D9911192E0CB879291347ACF8B5D3D966BCA8313CDA1821C932AFA88D86A4BAFB0ED543408F14F7FF900569D2ACE07CF4C98468932499C4EE9C3510D1EF31860AEE9B44C9FA5A241EA42194BDD92884BB83448A2F199F8544C24C122471C01BFB6F0B328FA1DB146E2A21CEA704E7FF1E1E0EA94F2E827E1F24DF7E00AF1DB88F67D5DF8EF342B3E6C32042711AE376BFFEF6BD8F758CC6F79BDE74A7D7F52D120C42FEF34C41950018CF69634CE45B08F04DE1967A82B698D7D9C325504CB24CAEB74075F903925C94ADE4217595365583E2034DD5527B2F67F931FE4C698DFF2F2398AABAB30A86890BA5097AC99A6646BEF9214DD6952DBA7619B7CA4971B1CC17E943085621A09F531E4EE48DA92E89128AF8B44591A6CB14A2636A1132984730C9528E5FB39007F2D4010DB0CAC8719F6D9C491B0C564D1887BB64C3E4A599E3797E9C8AC308E062139A38B3BF18D921B3E9A802C8C296BAA29BE45916C947C2707268CCECA5E32DCAAF4CA6F216CAEE8EAC6C105D5F3BE82EAA934543408494FDCF3D3A929EDF9044B46DE560E53C2B19906AB465CC2A880A23FEADD6299317D245CC32D133FE8566AFCD062BAA40CFF0153E6589F168D29867D9B627E5B6A38FE9D1EE42902AE3A21A485D9CF70E9BA291F535E8C321DCC9E28B16ED21B9D5FD23A8BB62A635A54676930656B4E834AF216872E699DC95A57DB552A543408498F8BA3D8AE0926E43E39DF876D125953F7823B0EC0C7637E7FC950A62E5F4499F8FA68E9DE8D555CFD540574BE05A726F829C0C1AFC286A4FBA3FAC73F1BF6CF8D9491E57E9B2C7E576956C8C45939024C89D82A0D150D428AE16B15696753A6D6EF6B7EBF57F3FB8925FA44949501B62E4EC955C194FE3FE0BD1E65B5B93FBAFC3E3E96C6865960D8679ACAD4AD9E1A5F60EE21AF50D120C42FBA8FB2E23392E721D8064BEE87EF262CE1F4F99C2E93089C2619C3234CF5F2FDACE1F8D72505FD48F14FD953B64EF94D05D4BA5812BCA948A9F76B46B09DB2FF1900B74AD4C41112FC6988ECEF949C0DA6606849A9B46DC96B59EF05725DE1EB3946A6AEEA1CC0C9E45B708F2C5556994907CAA65660BD5BEE795C6E8EB41C204BC807496C8F0ED906C8EF3F30947B66CC6F26C5658C5C537FB1DAF4956BDB5B2C231FD19C77BDA1CC1E4976A8E3B762D918AD79DE46CBF3F6A4B4EDD62AF4AB364C995BB60C84D8305C3E56710C4B30F1431EBA3892965A0E3038B3CD96174A98C9097E0D69986378F974CA92D93874ED626A4BC8344E7474F7A48CA87C1057BEE93A6CE992A5B03E501FCE2362CA999130520DD0F53713833DC63B38DB10086BA045BC860EF948C5B1441204861999C30AA5B87A02D2B4AF896E4900177D5E74FD200BFB48603A13F78BC5D00771FDCAD43FE29ECF28A6FED1EBBD488B06217EC963BD7ADAD1B56E34B6C6E0ABA1B82BE6B74352CA608B8F2989137296110EE67593654B47922F4395595563D915FF643158F1C121164A86E2148F7596EE5744458310FF4CAF419B9A7C354ED6985B4D29AC6D7940735C5645438D7E7FE7413E5F98CCDF4DC5B4AAC984692AAF08E6149405F88104DF8C287B1572F505404583D405D348324F8DDD5476DCBE1E89667989431D5DA1B9EB38D25EBBE9BC245F8DFB228E9E3D12C322EBCB6F4B0A6FFB242E1313FB868CB285D1B5ABAD42B4CC22926994379CA5D453F4F312AC6A72C951A33808C0E939C86343974C9714A1144E04709243DB6F93FE3CD872AACE449CFF579EFDA357D95434485D30BDE0F35E091097FC0809F3E92A8AE5540B53FBF56229D8621855E595A7E01AC3BE299A00415BE4E57791636023652EBE16C0E70CC79CE9181FA34BDAF87687736CD1F91BB82844B739289CBEF3DFE8FA92AE2FC7A1B37A997C319689F290D437E68905E429F93B6EEA258DCFC75316C740EECB8186152836D8E4E0B95BAED3C5921166A344F59D6539E512D02DCFDBFE9AFDBAFE617A2744D1F58F5EEF2B3A83129223DB1F3AAB57E16D536F57AB0C7E5576A2A338D9F0967C5ECA4953964DB96D536F1F5476DBB9606A1F646CA32A958ED1A7000000AA49444154E3AB7F69D039834E178BA2AFFA4DCEA081D3E488ED0F9DD54B51F27D5F93FA519E7567A58A31E809693A8B19F82913B55132484B507747D8DCA1A24148F1344AC9C86BF4D494917E532D16499474DD6F4FA316597FABDE635B3875420821A46EE8A64E6CE39CD86233754212A033282184104272838A062184104272838A062184104272838A062184104272838A062184104272838A06218410128FEE1BE973654BB301F07FB520405E37B25AB20000000049454E44AE426082, '本特勒LOGO.png'); -- ---------------------------- -- Table structure for us_dept -- ---------------------------- DROP TABLE IF EXISTS `us_dept`; CREATE TABLE `us_dept` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `create_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP, `del_flag` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否删除', `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '部门名', `p_id` bigint(20) NOT NULL DEFAULT 0 COMMENT '父Id', `dept_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, INDEX `p_id`(`p_id`) USING BTREE, INDEX `del_flag`(`del_flag`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 20 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '部门表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of us_dept -- ---------------------------- INSERT INTO `us_dept` VALUES (11, '2020-02-03 15:54:43', 0, '市场部', 0, '1001'); INSERT INTO `us_dept` VALUES (12, '2020-02-03 15:54:43', 0, '工程部', 0, '1002'); INSERT INTO `us_dept` VALUES (13, '2020-02-03 15:54:43', 0, '质量部', 0, '1004'); INSERT INTO `us_dept` VALUES (14, '2020-02-03 15:55:25', 0, '生产部', 0, '1006'); INSERT INTO `us_dept` VALUES (17, '2020-02-03 16:42:19', 0, '物流部', 0, '1005'); INSERT INTO `us_dept` VALUES (18, '2021-03-29 11:02:19', 0, '设备部', 0, '1003'); INSERT INTO `us_dept` VALUES (19, '2020-02-28 08:19:03', 0, '财务部', 0, '1007'); -- ---------------------------- -- Table structure for us_module -- ---------------------------- DROP TABLE IF EXISTS `us_module`; CREATE TABLE `us_module` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `create_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP, `del_flag` tinyint(4) NOT NULL DEFAULT 0, `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '名称', `description` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '描述', `sort` int(11) NOT NULL DEFAULT 0 COMMENT '排序', `type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'WEB' COMMENT '类型 WEB APP WX', `hidden` tinyint(1) NOT NULL DEFAULT 0, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '功能模块' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of us_module -- ---------------------------- INSERT INTO `us_module` VALUES (1, '2021-07-11 15:26:01', 0, '微信小程序用户相关', NULL, 0, 'WX', 0); INSERT INTO `us_module` VALUES (2, '2021-07-11 15:26:17', 0, '微信小程序计划审批', 'PLAN_APPROVAL', 0, 'WX', 0); INSERT INTO `us_module` VALUES (3, '2021-07-11 15:27:35', 0, '微信小程序计划放行', 'PASS_PLAN', 0, 'WX', 0); INSERT INTO `us_module` VALUES (4, '2021-07-11 15:28:03', 0, '微信小程序计划提醒', 'PLAN_REMINDER', 0, 'WX', 0); INSERT INTO `us_module` VALUES (5, '2021-07-11 15:28:38', 0, '微信小程序异常统计', 'ABNORMAL_STATISTICS', 0, 'WX', 0); INSERT INTO `us_module` VALUES (6, '2021-07-11 15:30:48', 0, '微信小程序模块', NULL, 0, 'WX', 0); INSERT INTO `us_module` VALUES (7, '2021-07-22 16:55:17', 0, 'WEB', 'WEB', 0, 'WEB', 0); -- ---------------------------- -- Table structure for us_permission -- ---------------------------- DROP TABLE IF EXISTS `us_permission`; CREATE TABLE `us_permission` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `create_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP, `del_flag` tinyint(4) NOT NULL DEFAULT 0, `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '权限名称', `url` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '请求路径', `module_id` bigint(20) NULL DEFAULT NULL COMMENT '模块Id', `hidden` tinyint(1) NULL DEFAULT 0 COMMENT '是否隐藏', PRIMARY KEY (`id`) USING BTREE, INDEX `FK_us_permission_us_module`(`module_id`) USING BTREE, CONSTRAINT `us_permission_ibfk_1` FOREIGN KEY (`module_id`) REFERENCES `us_module` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 76 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '权限' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of us_permission -- ---------------------------- INSERT INTO `us_permission` VALUES (1, '2021-07-11 15:11:18', 0, '微信小程序登录', '/login', 1, 0); INSERT INTO `us_permission` VALUES (2, '2021-07-11 15:13:45', 0, '微信小程序登出', '', 1, 0); INSERT INTO `us_permission` VALUES (3, '2021-07-11 15:14:45', 0, '微信小程序绑定用户', '/wx/functions/bind', 1, 0); INSERT INTO `us_permission` VALUES (4, '2021-07-11 15:33:53', 0, '微信小程序解绑', '', 1, 0); INSERT INTO `us_permission` VALUES (5, '2021-07-11 15:34:17', 0, '微信小程序订阅消息', '/wx/functions/bind/check', 1, 0); INSERT INTO `us_permission` VALUES (6, '2021-07-11 15:34:35', 0, '微信小程序功能列表', '/wx/functions/list', 1, 0); INSERT INTO `us_permission` VALUES (7, '2021-07-11 15:34:52', 0, '微信小程序计划-表头', '/wx/plans/pass/detail', 1, 0); INSERT INTO `us_permission` VALUES (8, '2021-07-11 16:26:21', 0, '微信小程序计划-附件', '/wx/benteler/fileupload/downloadFileForPlan', 1, 0); INSERT INTO `us_permission` VALUES (9, '2021-07-11 16:26:38', 0, '微信审批计划-列表', '/wx/plans/approval/list', 2, 0); INSERT INTO `us_permission` VALUES (10, '2021-07-11 17:34:19', 0, '微信审批计划-详情-首件', '/wx/plans/approval/detail/initial', 2, 0); INSERT INTO `us_permission` VALUES (11, '2021-07-12 22:55:05', 0, '微信审批计划-详情-防错', '/wx/plans/approval/detail/pm', 2, 0); INSERT INTO `us_permission` VALUES (12, '2021-07-12 22:56:24', 0, '微信审批计划-审批', '/wx/plans/approval/operate', 2, 0); INSERT INTO `us_permission` VALUES (13, '2021-07-12 22:57:10', 0, '微信计划放行-列表', '/wx/plans/pass/list', 3, 0); INSERT INTO `us_permission` VALUES (14, '2021-07-12 22:57:43', 0, '微信计划放行-详情', '/wx/plans/pass/detail/pm', 3, 0); INSERT INTO `us_permission` VALUES (15, '2021-07-12 22:58:10', 0, '微信计划放行-放行', '/wx/plans/pass/operate', 3, 0); INSERT INTO `us_permission` VALUES (16, '2021-07-12 22:58:28', 0, '微信计划提醒-列表', '/wx/plans/reminder/list', 4, 0); INSERT INTO `us_permission` VALUES (17, '2021-07-12 22:58:52', 0, '微信计划提醒-防错详情', '/wx/plans/reminder/detail/pm', 4, 0); INSERT INTO `us_permission` VALUES (18, '2021-07-12 23:00:11', 0, '微信计划提醒-标记', '/wx/plans/reminder/operate', 4, 0); INSERT INTO `us_permission` VALUES (19, '2021-07-12 23:00:51', 0, '微信异常统计-总览', '/wx/statistics/abnormal', 5, 0); INSERT INTO `us_permission` VALUES (20, '2021-07-12 23:01:22', 0, '微信异常统计-当月总数', '/wx/statistics/abnormal', 5, 0); INSERT INTO `us_permission` VALUES (21, '2021-07-12 23:01:38', 0, '微信异常统计-当月记录', '/wx/statistics/month', 5, 0); INSERT INTO `us_permission` VALUES (22, '2021-07-12 23:01:38', 0, '微信异常统计-异常列表', '/wx/statistics/list', 5, 0); INSERT INTO `us_permission` VALUES (23, '2021-07-14 00:01:57', 0, '微信异常统计-异常详情', '/wx/statistics/detail', 5, 0); INSERT INTO `us_permission` VALUES (24, '2021-07-22 17:04:18', 0, 'WEB-防错-新建防错计划', '/benteler/pm/addPmPlan', 7, 0); INSERT INTO `us_permission` VALUES (25, '2021-07-22 17:04:18', 0, 'WEB-防错-取得Web端防错计划点检列表', '/benteler/pm/getPmPlanCheckList', 7, 0); INSERT INTO `us_permission` VALUES (26, '2021-07-22 17:04:18', 0, 'WEB-防错-取得Web端防错计划列表', '/benteler/pm/getPmPlanlist', 7, 0); INSERT INTO `us_permission` VALUES (27, '2021-07-22 17:04:18', 0, 'WEB-防错-取得防错计划信息', '/benteler/pm/getPmPlan', 7, 0); INSERT INTO `us_permission` VALUES (28, '2021-07-22 17:04:18', 0, 'WEB-防错-禁用解禁防错计划', '/benteler/pm/disablePmPlan', 7, 0); INSERT INTO `us_permission` VALUES (29, '2021-07-22 17:04:18', 0, 'WEB-防错-取得工作站及站下巡检项目信息', '/benteler/pm/getWorkshop', 7, 0); INSERT INTO `us_permission` VALUES (30, '2021-07-22 17:04:18', 0, 'WEB-防错-修改防错计划', '/benteler/pm/editPmPlan', 7, 0); INSERT INTO `us_permission` VALUES (31, '2021-07-22 17:04:19', 0, 'WEB-防错-取得计划审批信息', '/benteler/pm/getPmPlanApprovalList', 7, 0); INSERT INTO `us_permission` VALUES (32, '2021-07-22 17:04:19', 0, 'WEB-防错-取得每频次检查信息', '/benteler/pm/getPmCheckList', 7, 0); INSERT INTO `us_permission` VALUES (33, '2021-07-22 17:04:19', 0, 'WEB-防错-取得巡检规则信息', '/benteler/pm/getCalendarList', 7, 0); INSERT INTO `us_permission` VALUES (34, '2021-07-22 17:04:19', 0, 'WEB-防错-检查记录列表', '/benteler/pm/getPmCheckRecordList', 7, 0); INSERT INTO `us_permission` VALUES (35, '2021-07-22 17:04:19', 0, 'WEB-防错-取得Pad端防错计划列表', '/benteler/pm/getPmPlanListForPad', 7, 0); INSERT INTO `us_permission` VALUES (36, '2021-07-22 17:04:19', 0, 'WEB-防错-通过计划ID取得表头', '/benteler/pm/getTitle', 7, 0); INSERT INTO `us_permission` VALUES (37, '2021-07-22 17:04:19', 0, 'WEB-防错-通过计划ID取得工作站列表', '/benteler/pm/getWorkshopList', 7, 0); INSERT INTO `us_permission` VALUES (38, '2021-07-22 17:04:19', 0, 'WEB-防错-通过工作站ID取得巡检项目列表', '/benteler/pm/getItemList', 7, 0); INSERT INTO `us_permission` VALUES (39, '2021-07-22 17:04:19', 0, 'WEB-防错-添加巡检项目检查结果', '/benteler/pm/addItemResult', 7, 0); INSERT INTO `us_permission` VALUES (40, '2021-07-22 17:04:19', 0, 'WEB-防错-任务检查完后提交', '/benteler/pm/submitTask', 7, 0); INSERT INTO `us_permission` VALUES (41, '2021-07-22 17:04:19', 0, 'WEB-防错-取得不放行任务对应的工作站', '/benteler/pm/getPmWorkshopNoGoList', 7, 0); INSERT INTO `us_permission` VALUES (42, '2021-07-22 17:04:19', 0, 'WEB-防错-取得不放行任务对应的点检项目', '/benteler/pm/getPmItemNoGoList', 7, 0); INSERT INTO `us_permission` VALUES (43, '2021-07-22 17:04:19', 0, 'WEB-防错-取得不放行任务对应的质量经理审批信息', '/benteler/pm/getPmNoGoTaskAapproval', 7, 0); INSERT INTO `us_permission` VALUES (44, '2021-07-22 17:04:19', 0, 'WEB-防错-修改巡检项目检查结果', '/benteler/pm/editItemResult', 7, 0); INSERT INTO `us_permission` VALUES (45, '2021-07-22 17:04:19', 0, 'WEB-防错-取得所有工作站', '/benteler/pm/getAllWorkshopList', 7, 0); INSERT INTO `us_permission` VALUES (46, '2020-03-09 17:15:32', 0, 'wx - 登录', '/wx/login', 7, 0); INSERT INTO `us_permission` VALUES (47, '2020-03-09 17:15:32', 0, 'web - 登录', 'login', 7, 0); INSERT INTO `us_permission` VALUES (48, '2021-06-03 18:46:22', 0, 'pad - 登录', '/mobile/login', 7, 0); INSERT INTO `us_permission` VALUES (49, '2021-07-23 19:21:14', 0, 'WEB-首件-新建首件计划', '/benteler/fa/addFaPlan', 7, 0); INSERT INTO `us_permission` VALUES (50, '2021-07-23 19:21:14', 0, 'WEB-首件-取得首件计划信息', '/benteler/fa/getFaPlan', 7, 0); INSERT INTO `us_permission` VALUES (51, '2021-07-23 19:21:14', 0, 'WEB-首件-修改首件计划', '/benteler/fa/editFaPlan', 7, 0); INSERT INTO `us_permission` VALUES (52, '2021-07-23 19:21:14', 0, 'WEB-首件-禁用解禁首件计划', '/benteler/fa/disableFaPlan', 7, 0); INSERT INTO `us_permission` VALUES (53, '2021-07-23 19:21:14', 0, 'WEB-首件-取得Web端首件计划点检列表', '/benteler/fa/getFaPlanCheckList', 7, 0); INSERT INTO `us_permission` VALUES (54, '2021-07-23 19:21:14', 0, 'WEB-首件-取得Pad端首件计划列表', '/benteler/fa/getFaPlanListForPad', 7, 0); INSERT INTO `us_permission` VALUES (55, '2021-07-23 19:21:14', 0, 'WEB-首件-取得Pad端工作站列表', '/benteler/fa/getFaWorkshopListForPad', 7, 0); INSERT INTO `us_permission` VALUES (56, '2021-07-23 19:21:14', 0, 'WEB-首件-取得Pad端巡检项目列表', '/benteler/fa/getFaItemListForPad', 7, 0); INSERT INTO `us_permission` VALUES (57, '2021-07-23 19:21:14', 0, 'WEB-首件-添加巡检项目检查结果', '/benteler/fa/addFaItemResult', 7, 0); INSERT INTO `us_permission` VALUES (58, '2021-07-23 19:21:14', 0, 'WEB-首件-任务检查完后提交', '/benteler/fa/submitFaTask', 7, 0); INSERT INTO `us_permission` VALUES (59, '2021-07-23 19:21:14', 0, 'WEB-首件-取得不放行任务对应的工作站', '/benteler/fa/getFaWorkshopNoGoList', 7, 0); INSERT INTO `us_permission` VALUES (60, '2021-07-23 19:21:14', 0, 'WEB-首件-取得不放行任务对应的点检项目', '/benteler/fa/getFaItemNoGoList', 7, 0); INSERT INTO `us_permission` VALUES (61, '2021-07-23 19:21:14', 0, 'WEB-首件-修改巡检项目检查结果', '/benteler/fa/editFaItemResult', 7, 0); INSERT INTO `us_permission` VALUES (62, '2021-07-23 19:21:15', 0, 'WEB-首件-通过计划ID取得表头', '/benteler/fa/getFaTitle', 7, 0); INSERT INTO `us_permission` VALUES (63, '2021-07-23 19:21:15', 0, 'WEB-首件-取得不放行任务对应的质量经理审批信息', '/benteler/fa/getFaNoGoTaskAapproval', 7, 0); INSERT INTO `us_permission` VALUES (64, '2021-07-23 19:21:15', 0, 'WEB-首件-取得计划审批信息', '/benteler/fa/getFaPlanApprovalList', 7, 0); INSERT INTO `us_permission` VALUES (65, '2021-07-23 19:21:15', 0, 'WEB-首件-取得所有计划(首件、防错)', '/benteler/fa/getALLPlanList', 7, 0); INSERT INTO `us_permission` VALUES (66, '2021-07-23 19:21:15', 0, 'WEB-首件-检查记录列表', '/benteler/fa/getFaCheckRecordList', 7, 0); INSERT INTO `us_permission` VALUES (67, '2021-07-23 19:21:15', 0, 'WEB-首件-判断检验结果是否填写完成', '/benteler/fa/getFaAllCheckFlag', 7, 0); INSERT INTO `us_permission` VALUES (68, '2021-07-23 19:46:52', 0, '我也不知道这个是干什么的', '/mobile/zdPlan/iniPlanList', 7, 0); INSERT INTO `us_permission` VALUES (69, '2021-07-24 06:11:09', 0, 'WEB-防错-取得异常列表', '/benteler/pm/getAbnormalList', 7, 0); INSERT INTO `us_permission` VALUES (70, '2021-07-24 06:11:09', 0, 'WEB-首件-取得用户列表', '/benteler/fa/getUserList', 7, 0); INSERT INTO `us_permission` VALUES (71, '2021-07-12 22:58:52', 0, '微信计划提醒-首件详情', '/wx/plans/reminder/detail/initial', 4, 0); INSERT INTO `us_permission` VALUES (72, '2021-07-24 12:48:42', 0, '微信计划放行-首件详情', '/wx/plans/pass/detail/initial', 3, 0); INSERT INTO `us_permission` VALUES (73, '2021-08-10 20:27:39', 0, 'WEB-首件-PAD取得中断任务列表', '/benteler/fa/getFaBreakTaskForPad', 7, 0); INSERT INTO `us_permission` VALUES (74, '2021-08-10 20:27:39', 0, 'PAD-common-提醒待执行数量', '/benteler/fa/getUnFinishedNum', 7, 0); INSERT INTO `us_permission` VALUES (75, '2021-08-10 20:27:39', 0, 'WX-common - 提醒待执行数量', '/wx/plans/approval/unfinishedNum', 6, 0); -- ---------------------------- -- Table structure for us_role -- ---------------------------- DROP TABLE IF EXISTS `us_role`; CREATE TABLE `us_role` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `create_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP, `del_flag` tinyint(4) NULL DEFAULT 0 COMMENT '是否删除 0 ：不删除 1：删除', `name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '名称', `remark` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注', `user_id` bigint(20) NULL DEFAULT NULL COMMENT '创建人', `type` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '项目区分(JH:计划)', PRIMARY KEY (`id`) USING BTREE, INDEX `FK_role_user`(`user_id`) USING BTREE, INDEX `del_flag`(`del_flag`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of us_role -- ---------------------------- INSERT INTO `us_role` VALUES (1, '2020-07-11 14:04:59', 0, '管理员', NULL, NULL, NULL); INSERT INTO `us_role` VALUES (2, '2020-07-11 14:04:59', 0, '质量工程师', NULL, NULL, NULL); INSERT INTO `us_role` VALUES (3, '2020-07-11 14:04:59', 0, '质量经理', NULL, NULL, NULL); INSERT INTO `us_role` VALUES (4, '2020-07-11 14:04:59', 0, '生产经理', NULL, NULL, NULL); INSERT INTO `us_role` VALUES (6, '2020-07-11 14:04:59', 0, '检查人员', NULL, NULL, NULL); INSERT INTO `us_role` VALUES (7, '2021-07-22 18:03:36', 0, '高级管理者', '高级管理者', NULL, NULL); -- ---------------------------- -- Table structure for us_role_permission -- ---------------------------- DROP TABLE IF EXISTS `us_role_permission`; CREATE TABLE `us_role_permission` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `create_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP, `role_id` bigint(20) NULL DEFAULT NULL COMMENT '角色Id', `permission_id` bigint(20) NULL DEFAULT NULL COMMENT '权限Id', PRIMARY KEY (`id`) USING BTREE, INDEX `FK_role_permission_role`(`role_id`) USING BTREE, INDEX `FK_role_permission_permission`(`permission_id`) USING BTREE, CONSTRAINT `us_role_permission_ibfk_1` FOREIGN KEY (`permission_id`) REFERENCES `us_permission` (`id`) ON DELETE RESTRICT ON UPDATE SET NULL, CONSTRAINT `us_role_permission_ibfk_2` FOREIGN KEY (`role_id`) REFERENCES `us_role` (`id`) ON DELETE RESTRICT ON UPDATE SET NULL ) ENGINE = InnoDB AUTO_INCREMENT = 818 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色-权限关联表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of us_role_permission -- ---------------------------- INSERT INTO `us_role_permission` VALUES (45, '2021-07-22 17:09:21', 1, 24); INSERT INTO `us_role_permission` VALUES (46, '2021-07-22 17:09:21', 1, 25); INSERT INTO `us_role_permission` VALUES (47, '2021-07-22 17:09:21', 1, 26); INSERT INTO `us_role_permission` VALUES (48, '2021-07-22 17:09:21', 1, 27); INSERT INTO `us_role_permission` VALUES (49, '2021-07-22 17:09:21', 1, 28); INSERT INTO `us_role_permission` VALUES (50, '2021-07-22 17:09:21', 1, 29); INSERT INTO `us_role_permission` VALUES (51, '2021-07-22 17:09:21', 1, 30); INSERT INTO `us_role_permission` VALUES (52, '2021-07-22 17:09:21', 1, 31); INSERT INTO `us_role_permission` VALUES (53, '2021-07-22 17:09:21', 1, 32); INSERT INTO `us_role_permission` VALUES (54, '2021-07-22 17:09:21', 1, 33); INSERT INTO `us_role_permission` VALUES (55, '2021-07-22 17:09:21', 1, 34); INSERT INTO `us_role_permission` VALUES (56, '2021-07-22 17:09:21', 1, 35); INSERT INTO `us_role_permission` VALUES (57, '2021-07-22 17:09:21', 1, 36); INSERT INTO `us_role_permission` VALUES (58, '2021-07-22 17:09:21', 1, 37); INSERT INTO `us_role_permission` VALUES (59, '2021-07-22 17:09:21', 1, 38); INSERT INTO `us_role_permission` VALUES (60, '2021-07-22 17:09:21', 1, 39); INSERT INTO `us_role_permission` VALUES (61, '2021-07-22 17:09:21', 1, 40); INSERT INTO `us_role_permission` VALUES (62, '2021-07-22 17:09:21', 1, 41); INSERT INTO `us_role_permission` VALUES (63, '2021-07-22 17:09:21', 1, 42); INSERT INTO `us_role_permission` VALUES (64, '2021-07-22 17:09:22', 1, 43); INSERT INTO `us_role_permission` VALUES (65, '2021-07-22 17:09:22', 1, 44); INSERT INTO `us_role_permission` VALUES (66, '2021-07-22 17:09:22', 1, 45); INSERT INTO `us_role_permission` VALUES (111, '2021-07-22 17:12:30', 4, 24); INSERT INTO `us_role_permission` VALUES (112, '2021-07-22 17:12:30', 4, 25); INSERT INTO `us_role_permission` VALUES (113, '2021-07-22 17:12:30', 4, 26); INSERT INTO `us_role_permission` VALUES (114, '2021-07-22 17:12:30', 4, 27); INSERT INTO `us_role_permission` VALUES (115, '2021-07-22 17:12:30', 4, 28); INSERT INTO `us_role_permission` VALUES (116, '2021-07-22 17:12:30', 4, 29); INSERT INTO `us_role_permission` VALUES (117, '2021-07-22 17:12:30', 4, 30); INSERT INTO `us_role_permission` VALUES (118, '2021-07-22 17:12:30', 4, 31); INSERT INTO `us_role_permission` VALUES (119, '2021-07-22 17:12:31', 4, 32); INSERT INTO `us_role_permission` VALUES (120, '2021-07-22 17:12:31', 4, 33); INSERT INTO `us_role_permission` VALUES (121, '2021-07-22 17:12:31', 4, 34); INSERT INTO `us_role_permission` VALUES (122, '2021-07-22 17:12:31', 4, 35); INSERT INTO `us_role_permission` VALUES (123, '2021-07-22 17:12:31', 4, 36); INSERT INTO `us_role_permission` VALUES (124, '2021-07-22 17:12:31', 4, 37); INSERT INTO `us_role_permission` VALUES (125, '2021-07-22 17:12:31', 4, 38); INSERT INTO `us_role_permission` VALUES (126, '2021-07-22 17:12:31', 4, 39); INSERT INTO `us_role_permission` VALUES (127, '2021-07-22 17:12:31', 4, 40); INSERT INTO `us_role_permission` VALUES (128, '2021-07-22 17:12:31', 4, 41); INSERT INTO `us_role_permission` VALUES (129, '2021-07-22 17:12:31', 4, 42); INSERT INTO `us_role_permission` VALUES (130, '2021-07-22 17:12:31', 4, 43); INSERT INTO `us_role_permission` VALUES (131, '2021-07-22 17:12:31', 4, 44); INSERT INTO `us_role_permission` VALUES (132, '2021-07-22 17:12:31', 4, 45); INSERT INTO `us_role_permission` VALUES (178, '2021-07-23 15:58:53', 7, 24); INSERT INTO `us_role_permission` VALUES (179, '2021-07-23 15:58:53', 7, 25); INSERT INTO `us_role_permission` VALUES (180, '2021-07-23 15:58:53', 7, 26); INSERT INTO `us_role_permission` VALUES (181, '2021-07-23 15:58:53', 7, 27); INSERT INTO `us_role_permission` VALUES (182, '2021-07-23 15:58:53', 7, 28); INSERT INTO `us_role_permission` VALUES (183, '2021-07-23 15:58:53', 7, 29); INSERT INTO `us_role_permission` VALUES (184, '2021-07-23 15:58:53', 7, 30); INSERT INTO `us_role_permission` VALUES (185, '2021-07-23 15:58:53', 7, 31); INSERT INTO `us_role_permission` VALUES (186, '2021-07-23 15:58:53', 7, 32); INSERT INTO `us_role_permission` VALUES (187, '2021-07-23 15:58:53', 7, 33); INSERT INTO `us_role_permission` VALUES (188, '2021-07-23 15:58:53', 7, 34); INSERT INTO `us_role_permission` VALUES (189, '2021-07-23 15:58:53', 7, 35); INSERT INTO `us_role_permission` VALUES (190, '2021-07-23 15:58:53', 7, 36); INSERT INTO `us_role_permission` VALUES (191, '2021-07-23 15:58:53', 7, 37); INSERT INTO `us_role_permission` VALUES (192, '2021-07-23 15:58:53', 7, 38); INSERT INTO `us_role_permission` VALUES (193, '2021-07-23 15:58:53', 7, 39); INSERT INTO `us_role_permission` VALUES (194, '2021-07-23 15:58:53', 7, 40); INSERT INTO `us_role_permission` VALUES (195, '2021-07-23 15:58:53', 7, 41); INSERT INTO `us_role_permission` VALUES (196, '2021-07-23 15:58:53', 7, 42); INSERT INTO `us_role_permission` VALUES (197, '2021-07-23 15:58:53', 7, 43); INSERT INTO `us_role_permission` VALUES (198, '2021-07-23 15:58:53', 7, 44); INSERT INTO `us_role_permission` VALUES (199, '2021-07-23 15:58:53', 7, 45); INSERT INTO `us_role_permission` VALUES (219, '2021-07-23 15:58:53', 7, 46); INSERT INTO `us_role_permission` VALUES (221, '2021-07-23 15:58:53', 7, 47); INSERT INTO `us_role_permission` VALUES (223, '2021-07-23 15:58:53', 7, 48); INSERT INTO `us_role_permission` VALUES (224, '2021-07-23 19:22:47', 4, 24); INSERT INTO `us_role_permission` VALUES (225, '2021-07-23 19:22:47', 4, 25); INSERT INTO `us_role_permission` VALUES (226, '2021-07-23 19:22:47', 4, 26); INSERT INTO `us_role_permission` VALUES (227, '2021-07-23 19:22:47', 4, 27); INSERT INTO `us_role_permission` VALUES (228, '2021-07-23 19:22:47', 4, 28); INSERT INTO `us_role_permission` VALUES (229, '2021-07-23 19:22:47', 4, 29); INSERT INTO `us_role_permission` VALUES (230, '2021-07-23 19:22:47', 4, 30); INSERT INTO `us_role_permission` VALUES (231, '2021-07-23 19:22:47', 4, 31); INSERT INTO `us_role_permission` VALUES (232, '2021-07-23 19:22:47', 4, 32); INSERT INTO `us_role_permission` VALUES (233, '2021-07-23 19:22:47', 4, 33); INSERT INTO `us_role_permission` VALUES (234, '2021-07-23 19:22:47', 4, 34); INSERT INTO `us_role_permission` VALUES (235, '2021-07-23 19:22:47', 4, 35); INSERT INTO `us_role_permission` VALUES (236, '2021-07-23 19:22:47', 4, 36); INSERT INTO `us_role_permission` VALUES (237, '2021-07-23 19:22:47', 4, 37); INSERT INTO `us_role_permission` VALUES (238, '2021-07-23 19:22:47', 4, 38); INSERT INTO `us_role_permission` VALUES (239, '2021-07-23 19:22:47', 4, 39); INSERT INTO `us_role_permission` VALUES (240, '2021-07-23 19:22:47', 4, 40); INSERT INTO `us_role_permission` VALUES (241, '2021-07-23 19:22:47', 4, 41); INSERT INTO `us_role_permission` VALUES (242, '2021-07-23 19:22:47', 4, 42); INSERT INTO `us_role_permission` VALUES (243, '2021-07-23 19:22:47', 4, 43); INSERT INTO `us_role_permission` VALUES (244, '2021-07-23 19:22:47', 4, 44); INSERT INTO `us_role_permission` VALUES (245, '2021-07-23 19:22:47', 4, 45); INSERT INTO `us_role_permission` VALUES (246, '2021-07-23 19:22:47', 4, 49); INSERT INTO `us_role_permission` VALUES (247, '2021-07-23 19:22:47', 4, 50); INSERT INTO `us_role_permission` VALUES (248, '2021-07-23 19:22:47', 4, 51); INSERT INTO `us_role_permission` VALUES (249, '2021-07-23 19:22:47', 4, 52); INSERT INTO `us_role_permission` VALUES (250, '2021-07-23 19:22:47', 4, 53); INSERT INTO `us_role_permission` VALUES (251, '2021-07-23 19:22:47', 4, 54); INSERT INTO `us_role_permission` VALUES (252, '2021-07-23 19:22:47', 4, 55); INSERT INTO `us_role_permission` VALUES (253, '2021-07-23 19:22:47', 4, 56); INSERT INTO `us_role_permission` VALUES (254, '2021-07-23 19:22:47', 4, 57); INSERT INTO `us_role_permission` VALUES (255, '2021-07-23 19:22:47', 4, 58); INSERT INTO `us_role_permission` VALUES (256, '2021-07-23 19:22:47', 4, 59); INSERT INTO `us_role_permission` VALUES (257, '2021-07-23 19:22:47', 4, 60); INSERT INTO `us_role_permission` VALUES (258, '2021-07-23 19:22:47', 4, 61); INSERT INTO `us_role_permission` VALUES (259, '2021-07-23 19:22:47', 4, 62); INSERT INTO `us_role_permission` VALUES (260, '2021-07-23 19:22:47', 4, 63); INSERT INTO `us_role_permission` VALUES (261, '2021-07-23 19:22:47', 4, 64); INSERT INTO `us_role_permission` VALUES (262, '2021-07-23 19:22:47', 4, 65); INSERT INTO `us_role_permission` VALUES (263, '2021-07-23 19:22:47', 4, 66); INSERT INTO `us_role_permission` VALUES (264, '2021-07-23 19:22:47', 4, 67); INSERT INTO `us_role_permission` VALUES (287, '2021-07-23 19:22:56', 7, 24); INSERT INTO `us_role_permission` VALUES (288, '2021-07-23 19:22:56', 7, 25); INSERT INTO `us_role_permission` VALUES (289, '2021-07-23 19:22:56', 7, 26); INSERT INTO `us_role_permission` VALUES (290, '2021-07-23 19:22:56', 7, 27); INSERT INTO `us_role_permission` VALUES (291, '2021-07-23 19:22:56', 7, 28); INSERT INTO `us_role_permission` VALUES (292, '2021-07-23 19:22:56', 7, 29); INSERT INTO `us_role_permission` VALUES (293, '2021-07-23 19:22:56', 7, 30); INSERT INTO `us_role_permission` VALUES (294, '2021-07-23 19:22:56', 7, 31); INSERT INTO `us_role_permission` VALUES (295, '2021-07-23 19:22:56', 7, 32); INSERT INTO `us_role_permission` VALUES (296, '2021-07-23 19:22:56', 7, 33); INSERT INTO `us_role_permission` VALUES (297, '2021-07-23 19:22:56', 7, 34); INSERT INTO `us_role_permission` VALUES (298, '2021-07-23 19:22:56', 7, 35); INSERT INTO `us_role_permission` VALUES (299, '2021-07-23 19:22:56', 7, 36); INSERT INTO `us_role_permission` VALUES (300, '2021-07-23 19:22:56', 7, 37); INSERT INTO `us_role_permission` VALUES (301, '2021-07-23 19:22:56', 7, 38); INSERT INTO `us_role_permission` VALUES (302, '2021-07-23 19:22:56', 7, 39); INSERT INTO `us_role_permission` VALUES (303, '2021-07-23 19:22:56', 7, 40); INSERT INTO `us_role_permission` VALUES (304, '2021-07-23 19:22:56', 7, 41); INSERT INTO `us_role_permission` VALUES (305, '2021-07-23 19:22:56', 7, 42); INSERT INTO `us_role_permission` VALUES (306, '2021-07-23 19:22:56', 7, 43); INSERT INTO `us_role_permission` VALUES (307, '2021-07-23 19:22:56', 7, 44); INSERT INTO `us_role_permission` VALUES (308, '2021-07-23 19:22:56', 7, 45); INSERT INTO `us_role_permission` VALUES (309, '2021-07-23 19:22:56', 7, 49); INSERT INTO `us_role_permission` VALUES (310, '2021-07-23 19:22:56', 7, 50); INSERT INTO `us_role_permission` VALUES (311, '2021-07-23 19:22:56', 7, 51); INSERT INTO `us_role_permission` VALUES (312, '2021-07-23 19:22:56', 7, 52); INSERT INTO `us_role_permission` VALUES (313, '2021-07-23 19:22:56', 7, 53); INSERT INTO `us_role_permission` VALUES (314, '2021-07-23 19:22:56', 7, 54); INSERT INTO `us_role_permission` VALUES (315, '2021-07-23 19:22:56', 7, 55); INSERT INTO `us_role_permission` VALUES (316, '2021-07-23 19:22:56', 7, 56); INSERT INTO `us_role_permission` VALUES (317, '2021-07-23 19:22:56', 7, 57); INSERT INTO `us_role_permission` VALUES (318, '2021-07-23 19:22:56', 7, 58); INSERT INTO `us_role_permission` VALUES (319, '2021-07-23 19:22:56', 7, 59); INSERT INTO `us_role_permission` VALUES (320, '2021-07-23 19:22:56', 7, 60); INSERT INTO `us_role_permission` VALUES (321, '2021-07-23 19:22:56', 7, 61); INSERT INTO `us_role_permission` VALUES (322, '2021-07-23 19:22:56', 7, 62); INSERT INTO `us_role_permission` VALUES (323, '2021-07-23 19:22:56', 7, 63); INSERT INTO `us_role_permission` VALUES (324, '2021-07-23 19:22:56', 7, 64); INSERT INTO `us_role_permission` VALUES (325, '2021-07-23 19:22:56', 7, 65); INSERT INTO `us_role_permission` VALUES (326, '2021-07-23 19:22:56', 7, 66); INSERT INTO `us_role_permission` VALUES (327, '2021-07-23 19:22:56', 7, 67); INSERT INTO `us_role_permission` VALUES (350, '2021-07-23 19:47:49', 7, 68); INSERT INTO `us_role_permission` VALUES (351, '2021-07-23 19:48:04', 4, 68); INSERT INTO `us_role_permission` VALUES (352, '2021-07-24 06:12:10', 4, 69); INSERT INTO `us_role_permission` VALUES (353, '2021-07-24 06:12:18', 4, 70); INSERT INTO `us_role_permission` VALUES (354, '2021-07-24 06:12:28', 7, 69); INSERT INTO `us_role_permission` VALUES (355, '2021-07-24 06:12:36', 7, 70); INSERT INTO `us_role_permission` VALUES (395, '2021-07-26 16:28:22', 4, 1); INSERT INTO `us_role_permission` VALUES (396, '2021-07-26 16:28:22', 4, 2); INSERT INTO `us_role_permission` VALUES (397, '2021-07-26 16:28:22', 4, 3); INSERT INTO `us_role_permission` VALUES (398, '2021-07-26 16:28:22', 4, 4); INSERT INTO `us_role_permission` VALUES (399, '2021-07-26 16:28:22', 4, 5); INSERT INTO `us_role_permission` VALUES (400, '2021-07-26 16:28:22', 4, 6); INSERT INTO `us_role_permission` VALUES (401, '2021-07-26 16:28:22', 4, 7); INSERT INTO `us_role_permission` VALUES (402, '2021-07-26 16:28:22', 4, 8); INSERT INTO `us_role_permission` VALUES (403, '2021-07-26 16:28:22', 4, 9); INSERT INTO `us_role_permission` VALUES (404, '2021-07-26 16:28:22', 4, 10); INSERT INTO `us_role_permission` VALUES (405, '2021-07-26 16:28:22', 4, 11); INSERT INTO `us_role_permission` VALUES (406, '2021-07-26 16:28:23', 4, 12); INSERT INTO `us_role_permission` VALUES (407, '2021-07-26 16:28:23', 7, 1); INSERT INTO `us_role_permission` VALUES (408, '2021-07-26 16:28:23', 7, 2); INSERT INTO `us_role_permission` VALUES (409, '2021-07-26 16:28:23', 7, 3); INSERT INTO `us_role_permission` VALUES (410, '2021-07-26 16:28:23', 7, 4); INSERT INTO `us_role_permission` VALUES (411, '2021-07-26 16:28:23', 7, 5); INSERT INTO `us_role_permission` VALUES (412, '2021-07-26 16:28:23', 7, 6); INSERT INTO `us_role_permission` VALUES (413, '2021-07-26 16:28:23', 7, 7); INSERT INTO `us_role_permission` VALUES (414, '2021-07-26 16:28:23', 7, 8); INSERT INTO `us_role_permission` VALUES (415, '2021-07-26 16:28:23', 7, 20); INSERT INTO `us_role_permission` VALUES (416, '2021-07-26 16:28:23', 7, 21); INSERT INTO `us_role_permission` VALUES (417, '2021-07-26 16:28:23', 7, 22); INSERT INTO `us_role_permission` VALUES (418, '2021-07-26 16:28:23', 7, 23); INSERT INTO `us_role_permission` VALUES (425, '2021-07-26 21:25:21', 1, 49); INSERT INTO `us_role_permission` VALUES (426, '2021-07-27 09:50:03', 2, 1); INSERT INTO `us_role_permission` VALUES (427, '2021-07-27 09:50:03', 2, 2); INSERT INTO `us_role_permission` VALUES (428, '2021-07-27 09:50:03', 2, 3); INSERT INTO `us_role_permission` VALUES (429, '2021-07-27 09:50:03', 2, 4); INSERT INTO `us_role_permission` VALUES (430, '2021-07-27 09:50:03', 2, 5); INSERT INTO `us_role_permission` VALUES (431, '2021-07-27 09:50:03', 2, 6); INSERT INTO `us_role_permission` VALUES (432, '2021-07-27 09:50:03', 2, 7); INSERT INTO `us_role_permission` VALUES (433, '2021-07-27 09:50:03', 2, 8); INSERT INTO `us_role_permission` VALUES (438, '2021-07-27 09:50:03', 2, 13); INSERT INTO `us_role_permission` VALUES (439, '2021-07-27 09:50:03', 2, 14); INSERT INTO `us_role_permission` VALUES (440, '2021-07-27 09:50:03', 2, 15); INSERT INTO `us_role_permission` VALUES (441, '2021-07-27 09:50:03', 2, 72); INSERT INTO `us_role_permission` VALUES (451, '2021-07-27 09:50:03', 2, 24); INSERT INTO `us_role_permission` VALUES (452, '2021-07-27 09:50:03', 2, 25); INSERT INTO `us_role_permission` VALUES (453, '2021-07-27 09:50:03', 2, 26); INSERT INTO `us_role_permission` VALUES (454, '2021-07-27 09:50:03', 2, 27); INSERT INTO `us_role_permission` VALUES (455, '2021-07-27 09:50:03', 2, 28); INSERT INTO `us_role_permission` VALUES (456, '2021-07-27 09:50:03', 2, 29); INSERT INTO `us_role_permission` VALUES (457, '2021-07-27 09:50:03', 2, 30); INSERT INTO `us_role_permission` VALUES (458, '2021-07-27 09:50:03', 2, 31); INSERT INTO `us_role_permission` VALUES (459, '2021-07-27 09:50:03', 2, 32); INSERT INTO `us_role_permission` VALUES (460, '2021-07-27 09:50:03', 2, 33); INSERT INTO `us_role_permission` VALUES (461, '2021-07-27 09:50:03', 2, 34); INSERT INTO `us_role_permission` VALUES (462, '2021-07-27 09:50:03', 2, 35); INSERT INTO `us_role_permission` VALUES (463, '2021-07-27 09:50:03', 2, 36); INSERT INTO `us_role_permission` VALUES (464, '2021-07-27 09:50:03', 2, 37); INSERT INTO `us_role_permission` VALUES (465, '2021-07-27 09:50:03', 2, 38); INSERT INTO `us_role_permission` VALUES (466, '2021-07-27 09:50:03', 2, 39); INSERT INTO `us_role_permission` VALUES (467, '2021-07-27 09:50:03', 2, 40); INSERT INTO `us_role_permission` VALUES (468, '2021-07-27 09:50:03', 2, 41); INSERT INTO `us_role_permission` VALUES (469, '2021-07-27 09:50:03', 2, 42); INSERT INTO `us_role_permission` VALUES (470, '2021-07-27 09:50:03', 2, 43); INSERT INTO `us_role_permission` VALUES (471, '2021-07-27 09:50:03', 2, 44); INSERT INTO `us_role_permission` VALUES (472, '2021-07-27 09:50:03', 2, 45); INSERT INTO `us_role_permission` VALUES (473, '2021-07-27 09:50:03', 2, 46); INSERT INTO `us_role_permission` VALUES (474, '2021-07-27 09:50:03', 2, 47); INSERT INTO `us_role_permission` VALUES (475, '2021-07-27 09:50:03', 2, 48); INSERT INTO `us_role_permission` VALUES (476, '2021-07-27 09:50:03', 2, 49); INSERT INTO `us_role_permission` VALUES (477, '2021-07-27 09:50:03', 2, 50); INSERT INTO `us_role_permission` VALUES (478, '2021-07-27 09:50:03', 2, 51); INSERT INTO `us_role_permission` VALUES (479, '2021-07-27 09:50:03', 2, 52); INSERT INTO `us_role_permission` VALUES (480, '2021-07-27 09:50:03', 2, 53); INSERT INTO `us_role_permission` VALUES (481, '2021-07-27 09:50:03', 2, 54); INSERT INTO `us_role_permission` VALUES (482, '2021-07-27 09:50:03', 2, 55); INSERT INTO `us_role_permission` VALUES (483, '2021-07-27 09:50:03', 2, 56); INSERT INTO `us_role_permission` VALUES (484, '2021-07-27 09:50:03', 2, 57); INSERT INTO `us_role_permission` VALUES (485, '2021-07-27 09:50:03', 2, 58); INSERT INTO `us_role_permission` VALUES (486, '2021-07-27 09:50:03', 2, 59); INSERT INTO `us_role_permission` VALUES (487, '2021-07-27 09:50:03', 2, 60); INSERT INTO `us_role_permission` VALUES (488, '2021-07-27 09:50:03', 2, 61); INSERT INTO `us_role_permission` VALUES (489, '2021-07-27 09:50:03', 2, 62); INSERT INTO `us_role_permission` VALUES (490, '2021-07-27 09:50:03', 2, 63); INSERT INTO `us_role_permission` VALUES (491, '2021-07-27 09:50:03', 2, 64); INSERT INTO `us_role_permission` VALUES (492, '2021-07-27 09:50:03', 2, 65); INSERT INTO `us_role_permission` VALUES (493, '2021-07-27 09:50:03', 2, 66); INSERT INTO `us_role_permission` VALUES (494, '2021-07-27 09:50:03', 2, 67); INSERT INTO `us_role_permission` VALUES (495, '2021-07-27 09:50:03', 2, 68); INSERT INTO `us_role_permission` VALUES (496, '2021-07-27 09:50:03', 2, 69); INSERT INTO `us_role_permission` VALUES (497, '2021-07-27 09:50:03', 2, 70); INSERT INTO `us_role_permission` VALUES (553, '2021-07-27 12:16:33', 3, 1); INSERT INTO `us_role_permission` VALUES (554, '2021-07-27 12:16:33', 3, 2); INSERT INTO `us_role_permission` VALUES (555, '2021-07-27 12:16:33', 3, 3); INSERT INTO `us_role_permission` VALUES (556, '2021-07-27 12:16:33', 3, 4); INSERT INTO `us_role_permission` VALUES (557, '2021-07-27 12:16:33', 3, 5); INSERT INTO `us_role_permission` VALUES (558, '2021-07-27 12:16:33', 3, 6); INSERT INTO `us_role_permission` VALUES (559, '2021-07-27 12:16:33', 3, 7); INSERT INTO `us_role_permission` VALUES (560, '2021-07-27 12:16:33', 3, 8); INSERT INTO `us_role_permission` VALUES (561, '2021-07-27 12:16:33', 3, 9); INSERT INTO `us_role_permission` VALUES (562, '2021-07-27 12:16:33', 3, 10); INSERT INTO `us_role_permission` VALUES (563, '2021-07-27 12:16:33', 3, 11); INSERT INTO `us_role_permission` VALUES (564, '2021-07-27 12:16:33', 3, 12); INSERT INTO `us_role_permission` VALUES (565, '2021-07-27 12:16:33', 3, 13); INSERT INTO `us_role_permission` VALUES (566, '2021-07-27 12:16:33', 3, 14); INSERT INTO `us_role_permission` VALUES (567, '2021-07-27 12:16:33', 3, 15); INSERT INTO `us_role_permission` VALUES (568, '2021-07-27 12:16:33', 3, 72); INSERT INTO `us_role_permission` VALUES (569, '2021-07-27 12:16:33', 3, 16); INSERT INTO `us_role_permission` VALUES (570, '2021-07-27 12:16:33', 3, 17); INSERT INTO `us_role_permission` VALUES (571, '2021-07-27 12:16:33', 3, 18); INSERT INTO `us_role_permission` VALUES (572, '2021-07-27 12:16:33', 3, 71); INSERT INTO `us_role_permission` VALUES (578, '2021-07-27 12:16:33', 3, 24); INSERT INTO `us_role_permission` VALUES (579, '2021-07-27 12:16:33', 3, 25); INSERT INTO `us_role_permission` VALUES (580, '2021-07-27 12:16:33', 3, 26); INSERT INTO `us_role_permission` VALUES (581, '2021-07-27 12:16:33', 3, 27); INSERT INTO `us_role_permission` VALUES (582, '2021-07-27 12:16:33', 3, 28); INSERT INTO `us_role_permission` VALUES (583, '2021-07-27 12:16:33', 3, 29); INSERT INTO `us_role_permission` VALUES (584, '2021-07-27 12:16:33', 3, 30); INSERT INTO `us_role_permission` VALUES (585, '2021-07-27 12:16:33', 3, 31); INSERT INTO `us_role_permission` VALUES (586, '2021-07-27 12:16:33', 3, 32); INSERT INTO `us_role_permission` VALUES (587, '2021-07-27 12:16:33', 3, 33); INSERT INTO `us_role_permission` VALUES (588, '2021-07-27 12:16:33', 3, 34); INSERT INTO `us_role_permission` VALUES (589, '2021-07-27 12:16:33', 3, 35); INSERT INTO `us_role_permission` VALUES (590, '2021-07-27 12:16:33', 3, 36); INSERT INTO `us_role_permission` VALUES (591, '2021-07-27 12:16:33', 3, 37); INSERT INTO `us_role_permission` VALUES (592, '2021-07-27 12:16:33', 3, 38); INSERT INTO `us_role_permission` VALUES (593, '2021-07-27 12:16:33', 3, 39); INSERT INTO `us_role_permission` VALUES (594, '2021-07-27 12:16:33', 3, 40); INSERT INTO `us_role_permission` VALUES (595, '2021-07-27 12:16:33', 3, 41); INSERT INTO `us_role_permission` VALUES (596, '2021-07-27 12:16:33', 3, 42); INSERT INTO `us_role_permission` VALUES (597, '2021-07-27 12:16:33', 3, 43); INSERT INTO `us_role_permission` VALUES (598, '2021-07-27 12:16:33', 3, 44); INSERT INTO `us_role_permission` VALUES (599, '2021-07-27 12:16:33', 3, 45); INSERT INTO `us_role_permission` VALUES (600, '2021-07-27 12:16:33', 3, 46); INSERT INTO `us_role_permission` VALUES (601, '2021-07-27 12:16:33', 3, 47); INSERT INTO `us_role_permission` VALUES (602, '2021-07-27 12:16:33', 3, 48); INSERT INTO `us_role_permission` VALUES (603, '2021-07-27 12:16:33', 3, 49); INSERT INTO `us_role_permission` VALUES (604, '2021-07-27 12:16:33', 3, 50); INSERT INTO `us_role_permission` VALUES (605, '2021-07-27 12:16:33', 3, 51); INSERT INTO `us_role_permission` VALUES (606, '2021-07-27 12:16:33', 3, 52); INSERT INTO `us_role_permission` VALUES (607, '2021-07-27 12:16:33', 3, 53); INSERT INTO `us_role_permission` VALUES (608, '2021-07-27 12:16:33', 3, 54); INSERT INTO `us_role_permission` VALUES (609, '2021-07-27 12:16:33', 3, 55); INSERT INTO `us_role_permission` VALUES (610, '2021-07-27 12:16:33', 3, 56); INSERT INTO `us_role_permission` VALUES (611, '2021-07-27 12:16:33', 3, 57); INSERT INTO `us_role_permission` VALUES (612, '2021-07-27 12:16:33', 3, 58); INSERT INTO `us_role_permission` VALUES (613, '2021-07-27 12:16:33', 3, 59); INSERT INTO `us_role_permission` VALUES (614, '2021-07-27 12:16:33', 3, 60); INSERT INTO `us_role_permission` VALUES (615, '2021-07-27 12:16:33', 3, 61); INSERT INTO `us_role_permission` VALUES (616, '2021-07-27 12:16:33', 3, 62); INSERT INTO `us_role_permission` VALUES (617, '2021-07-27 12:16:33', 3, 63); INSERT INTO `us_role_permission` VALUES (618, '2021-07-27 12:16:33', 3, 64); INSERT INTO `us_role_permission` VALUES (619, '2021-07-27 12:16:33', 3, 65); INSERT INTO `us_role_permission` VALUES (620, '2021-07-27 12:16:33', 3, 66); INSERT INTO `us_role_permission` VALUES (621, '2021-07-27 12:16:33', 3, 67); INSERT INTO `us_role_permission` VALUES (622, '2021-07-27 12:16:33', 3, 68); INSERT INTO `us_role_permission` VALUES (623, '2021-07-27 12:16:33', 3, 69); INSERT INTO `us_role_permission` VALUES (624, '2021-07-27 12:16:33', 3, 70); INSERT INTO `us_role_permission` VALUES (705, '2021-07-27 13:39:27', 6, 24); INSERT INTO `us_role_permission` VALUES (706, '2021-07-27 13:39:27', 6, 25); INSERT INTO `us_role_permission` VALUES (707, '2021-07-27 13:39:27', 6, 26); INSERT INTO `us_role_permission` VALUES (708, '2021-07-27 13:39:27', 6, 27); INSERT INTO `us_role_permission` VALUES (709, '2021-07-27 13:39:27', 6, 28); INSERT INTO `us_role_permission` VALUES (710, '2021-07-27 13:39:27', 6, 29); INSERT INTO `us_role_permission` VALUES (711, '2021-07-27 13:39:27', 6, 30); INSERT INTO `us_role_permission` VALUES (712, '2021-07-27 13:39:27', 6, 31); INSERT INTO `us_role_permission` VALUES (713, '2021-07-27 13:39:27', 6, 32); INSERT INTO `us_role_permission` VALUES (714, '2021-07-27 13:39:27', 6, 33); INSERT INTO `us_role_permission` VALUES (715, '2021-07-27 13:39:27', 6, 34); INSERT INTO `us_role_permission` VALUES (716, '2021-07-27 13:39:27', 6, 35); INSERT INTO `us_role_permission` VALUES (717, '2021-07-27 13:39:27', 6, 36); INSERT INTO `us_role_permission` VALUES (718, '2021-07-27 13:39:27', 6, 37); INSERT INTO `us_role_permission` VALUES (719, '2021-07-27 13:39:27', 6, 38); INSERT INTO `us_role_permission` VALUES (720, '2021-07-27 13:39:27', 6, 39); INSERT INTO `us_role_permission` VALUES (721, '2021-07-27 13:39:27', 6, 40); INSERT INTO `us_role_permission` VALUES (722, '2021-07-27 13:39:27', 6, 41); INSERT INTO `us_role_permission` VALUES (723, '2021-07-27 13:39:27', 6, 42); INSERT INTO `us_role_permission` VALUES (724, '2021-07-27 13:39:27', 6, 43); INSERT INTO `us_role_permission` VALUES (725, '2021-07-27 13:39:27', 6, 44); INSERT INTO `us_role_permission` VALUES (726, '2021-07-27 13:39:27', 6, 45); INSERT INTO `us_role_permission` VALUES (727, '2021-07-27 13:39:27', 6, 46); INSERT INTO `us_role_permission` VALUES (728, '2021-07-27 13:39:27', 6, 47); INSERT INTO `us_role_permission` VALUES (729, '2021-07-27 13:39:27', 6, 48); INSERT INTO `us_role_permission` VALUES (730, '2021-07-27 13:39:27', 6, 49); INSERT INTO `us_role_permission` VALUES (731, '2021-07-27 13:39:27', 6, 50); INSERT INTO `us_role_permission` VALUES (732, '2021-07-27 13:39:27', 6, 51); INSERT INTO `us_role_permission` VALUES (733, '2021-07-27 13:39:27', 6, 52); INSERT INTO `us_role_permission` VALUES (734, '2021-07-27 13:39:27', 6, 53); INSERT INTO `us_role_permission` VALUES (735, '2021-07-27 13:39:27', 6, 54); INSERT INTO `us_role_permission` VALUES (736, '2021-07-27 13:39:27', 6, 55); INSERT INTO `us_role_permission` VALUES (737, '2021-07-27 13:39:27', 6, 56); INSERT INTO `us_role_permission` VALUES (738, '2021-07-27 13:39:27', 6, 57); INSERT INTO `us_role_permission` VALUES (739, '2021-07-27 13:39:27', 6, 58); INSERT INTO `us_role_permission` VALUES (740, '2021-07-27 13:39:27', 6, 59); INSERT INTO `us_role_permission` VALUES (741, '2021-07-27 13:39:27', 6, 60); INSERT INTO `us_role_permission` VALUES (742, '2021-07-27 13:39:27', 6, 61); INSERT INTO `us_role_permission` VALUES (743, '2021-07-27 13:39:27', 6, 62); INSERT INTO `us_role_permission` VALUES (744, '2021-07-27 13:39:27', 6, 63); INSERT INTO `us_role_permission` VALUES (745, '2021-07-27 13:39:27', 6, 64); INSERT INTO `us_role_permission` VALUES (746, '2021-07-27 13:39:27', 6, 65); INSERT INTO `us_role_permission` VALUES (747, '2021-07-27 13:39:27', 6, 66); INSERT INTO `us_role_permission` VALUES (748, '2021-07-27 13:39:27', 6, 67); INSERT INTO `us_role_permission` VALUES (749, '2021-07-27 13:39:27', 6, 68); INSERT INTO `us_role_permission` VALUES (750, '2021-07-27 13:39:27', 6, 69); INSERT INTO `us_role_permission` VALUES (751, '2021-07-27 13:39:27', 6, 70); INSERT INTO `us_role_permission` VALUES (807, '2021-08-10 20:28:00', 6, 73); INSERT INTO `us_role_permission` VALUES (808, '2021-08-10 20:28:00', 2, 75); INSERT INTO `us_role_permission` VALUES (809, '2021-08-10 20:28:00', 3, 75); INSERT INTO `us_role_permission` VALUES (810, '2021-08-10 20:28:00', 4, 75); INSERT INTO `us_role_permission` VALUES (811, '2021-08-10 20:28:00', 3, 74); INSERT INTO `us_role_permission` VALUES (812, '2021-08-10 20:28:00', 6, 74); INSERT INTO `us_role_permission` VALUES (813, '2021-08-10 20:28:00', 3, 19); INSERT INTO `us_role_permission` VALUES (814, '2021-08-10 20:28:00', 3, 20); INSERT INTO `us_role_permission` VALUES (815, '2021-08-10 20:28:00', 3, 21); INSERT INTO `us_role_permission` VALUES (816, '2021-08-10 20:28:00', 3, 22); INSERT INTO `us_role_permission` VALUES (817, '2021-08-10 20:28:00', 3, 23); -- ---------------------------- -- Table structure for us_user -- ---------------------------- DROP TABLE IF EXISTS `us_user`; CREATE TABLE `us_user` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `create_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP, `del_flag` tinyint(4) NULL DEFAULT 0 COMMENT '是否删除', `username` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户名', `password` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '密码', `lock` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否锁定 0 否 1 是', `effective_time` datetime(0) NULL DEFAULT NULL COMMENT '生效日期', `remark` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注', `no` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '工号', `name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '姓名', `dept_id` bigint(20) NULL DEFAULT NULL COMMENT '部门Id', `shift_id` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `phone` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '手机号', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `no`(`no`) USING BTREE, INDEX `FK_user_dept`(`dept_id`) USING BTREE, INDEX `username`(`username`) USING BTREE, INDEX `del_flag`(`del_flag`) USING BTREE, CONSTRAINT `FK_user_dept` FOREIGN KEY (`dept_id`) REFERENCES `us_dept` (`id`) ON DELETE RESTRICT ON UPDATE SET NULL ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of us_user -- ---------------------------- INSERT INTO `us_user` VALUES (1, '2020-02-26 16:51:45', 0, 'admin', 'MTIzNDU2', 0, '2020-02-03 00:00:00', 'admin', 'admin', '管理员', 11, NULL, NULL); -- ---------------------------- -- Table structure for us_user_role -- ---------------------------- DROP TABLE IF EXISTS `us_user_role`; CREATE TABLE `us_user_role` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `create_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP, `user_id` bigint(20) NULL DEFAULT NULL COMMENT '用户Id', `role_id` bigint(20) NULL DEFAULT NULL COMMENT '角色Id', PRIMARY KEY (`id`) USING BTREE, INDEX `FK_user_role_role`(`role_id`) USING BTREE, INDEX `FK_user_role_user`(`user_id`) USING BTREE, CONSTRAINT `us_user_role_ibfk_1` FOREIGN KEY (`role_id`) REFERENCES `us_role` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `us_user_role_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `us_user` (`id`) ON DELETE RESTRICT ON UPDATE SET NULL ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户角色关联表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of us_user_role -- ---------------------------- INSERT INTO `us_user_role` VALUES (1, '2021-07-30 20:03:42', 1, 1); -- ---------------------------- -- Table structure for us_user_wechat -- ---------------------------- DROP TABLE IF EXISTS `us_user_wechat`; CREATE TABLE `us_user_wechat` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `openid` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '小程序openid', `user_id` bigint(20) NULL DEFAULT NULL COMMENT '绑定系统账号', `create_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `bind_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '绑定账号时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; SET FOREIGN_KEY_CHECKS = 1;