DROP database if exists `datav_platform`; CREATE database `datav_platform` default charset=utf8; use `datav_platform`; SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for mortals_xhx_area -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_area`; CREATE TABLE `mortals_xhx_area` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键,自增长', `parentId` bigint(20) NULL DEFAULT NULL COMMENT '上级区域ID', `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '区域名称', `level` tinyint(4) NULL DEFAULT NULL COMMENT '区域级别，按所处树的节点层次', `code` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '区域编码，按全国省市编码', `contactsPeople` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '区域负责人', `contactsMobile` varchar(21) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '区域负责人电话', `childSize` int(11) NULL DEFAULT NULL COMMENT '子区域数量，默认0', `maxChildId` int(11) NULL DEFAULT NULL COMMENT '子区域的最大ID，默认0', `status` tinyint(4) NULL DEFAULT NULL COMMENT '状态，0停用，1启用', `remark` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述', `createTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `updateTime` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', `createUserId` bigint(20) NULL DEFAULT NULL COMMENT '创建用户ID', `createUserName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci 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; -- ---------------------------- -- Records of mortals_xhx_area -- ---------------------------- -- ---------------------------- -- Table structure for mortals_xhx_customer -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_customer`; CREATE TABLE `mortals_xhx_customer` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID，主键，自增长', `loginName` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户登录账号', `password` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '密码', `memberLevel` tinyint(2) NOT NULL COMMENT '会员等级，，0：未开启，1：试用客户，2：VIP，3：设计师，默认0', `custName` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '客户真实名称', `organization` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '单位名称', `contactTelphone` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '联系电话', `enterpriseConsultant` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '企业顾问', `siteId` bigint(20) NULL DEFAULT NULL COMMENT '站点ID', `sex` tinyint(2) NULL DEFAULT NULL COMMENT '性别', `mailbox` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱', `job` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '职位', `avatar` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '头像图片地址', `customerSrc` bigint(20) NULL DEFAULT NULL COMMENT '客户来源', `status` tinyint(2) NOT NULL COMMENT '使用状态，1:正常，0:禁用，默认：0', `createUserId` bigint(20) NULL DEFAULT NULL COMMENT '创建用户', `createTime` datetime(0) NOT NULL COMMENT '注册时间', `updateTime` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', `lastLoginTime` datetime(0) NULL DEFAULT NULL COMMENT '最后一次登录时间', `lastLoginAddress` varchar(21) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '最后一次登录地址', `openId` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '微信openid', `saltKey` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '密码盐值', `lastUpdatePwdTime` datetime(0) NULL DEFAULT NULL COMMENT '最后一次修改密码时间', `errorCount` tinyint(2) NULL DEFAULT 0 COMMENT '当日登录失败数', `loginLock` tinyint(2) NULL DEFAULT 0 COMMENT '登录锁定状态0未锁定1已锁定', `lockTime` datetime(0) NULL DEFAULT NULL COMMENT '锁定时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 42 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '客户管理' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of mortals_xhx_customer -- ---------------------------- INSERT INTO `mortals_xhx_customer` VALUES (23, 'xiaoyi', '4280d89a5a03f812751f504cc10ee8a5', 3, 'xiaoyi', '恒升信达', '16608319500', '小易', NULL, 1, '', '', 'file/uploadfile/3c781deb8bd44a0ea1cd069315f15266.jpg', 2, 1, 1, '2022-07-11 09:23:47', '2022-08-04 14:08:27', '2023-11-24 18:05:39', '192.168.0.192', NULL, NULL, '2023-11-13 10:08:21', 0, 0, NULL); INSERT INTO `mortals_xhx_customer` VALUES (30, 'wanghongxia', '4280d89a5a03f812751f504cc10ee8a5', 3, '王大侠', '四川恒生信达科技有限公司', '14785698547', '王红霞', NULL, 2, '3698547@qq.com', 'Ui设计', NULL, 2, 1, 1, '2022-07-19 15:48:33', '2022-07-28 10:16:50', '2022-08-12 15:46:58', '192.168.0.48', NULL, NULL, '2023-11-13 10:08:21', 0, 0, NULL); INSERT INTO `mortals_xhx_customer` VALUES (34, 'zdyue', '4280d89a5a03f812751f504cc10ee8a5', 3, '昝月月', '研发中心', '13214785698', 'UI设计', NULL, 2, '', '', 'file/uploadfile/23efe46506be40d4b7daf519b681246f.jpg', 2, 1, 1, '2022-07-28 10:16:21', '2022-07-28 10:16:36', '2023-07-17 10:08:38', '192.168.0.252', NULL, NULL, '2023-11-13 10:08:21', 0, 0, NULL); INSERT INTO `mortals_xhx_customer` VALUES (35, 'gaowei', 'd53b2e6434ebf5b919ac857ef8fe8cf1', 1, '高维', '四川恒升信达科技有限公司', '13088088834', '高维', NULL, 1, '', '', NULL, 2, 1, 1, '2022-08-11 14:13:22', '2022-08-11 15:37:17', '2023-09-25 14:27:14', '192.168.0.252', NULL, NULL, '2023-11-13 10:08:21', 0, 0, NULL); INSERT INTO `mortals_xhx_customer` VALUES (36, 'ecac', '3d15f7afd31b9928717a835182115ec5', 2, 'lilac', 'ecac', '13088088834', '范佳', NULL, 1, '', '', NULL, 2, 1, 1, '2022-08-11 14:23:32', '2022-08-11 14:24:34', NULL, NULL, NULL, NULL, '2023-11-13 10:08:21', 0, 0, NULL); INSERT INTO `mortals_xhx_customer` VALUES (37, 'guoxianjiao', '4280d89a5a03f812751f504cc10ee8a5', 3, '郭香蕉', '四川恒升信达科技有限公司', '14780651258', '郭香蕉', NULL, 1, '2243698@qq.com', '测试', 'file/uploadfile/454203ae82084391b6c30fb422497202.jpg', 2, 1, 1, '2022-08-17 15:23:40', '2022-09-20 16:04:09', '2022-09-22 16:02:09', '192.168.0.8', NULL, NULL, '2023-11-13 10:08:21', 0, 0, NULL); INSERT INTO `mortals_xhx_customer` VALUES (38, 'ceshiya', '4280d89a5a03f812751f504cc10ee8a5', 2, 'ceshi', '31321321', '16608318900', '121', NULL, 1, '', '', NULL, 2, 1, 1, '2022-08-22 14:43:04', '2023-02-16 15:18:25', '2022-08-25 14:56:50', '192.168.0.192', NULL, NULL, '2023-11-13 10:08:21', 0, 0, NULL); INSERT INTO `mortals_xhx_customer` VALUES (40, 'xiaozhen', '4280d89a5a03f812751f504cc10ee8a5', 2, '小真', '测试', '18890889088', '小易', NULL, 2, '', '', NULL, 2, 1, 1, '2022-09-19 09:45:18', '2022-09-20 15:46:45', '2022-09-19 09:49:26', '192.168.0.192', NULL, NULL, '2023-11-13 10:08:21', 0, 0, NULL); INSERT INTO `mortals_xhx_customer` VALUES (41, 'liaoxuwei', '4280d89a5a03f812751f504cc10ee8a5', 3, '廖旭伟', '信宏翔', '18981841597', '张三', NULL, 1, 'test@qq.com', '开发人员', 'file/uploadfile/d6bc1b71797848ca8332bb0f168ad107.jpg', 1, 1, 1, '2023-02-14 14:06:00', '2023-02-14 14:22:35', '2023-04-16 11:24:01', '0:0:0:0:0:0:0:1', NULL, NULL, '2023-11-13 10:08:21', 0, 0, NULL); -- ---------------------------- -- Table structure for mortals_xhx_customer_pwd_record -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_customer_pwd_record`; CREATE TABLE `mortals_xhx_customer_pwd_record` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键，自增长', `userId` bigint(20) NULL DEFAULT NULL COMMENT '客户ID，主键，自增长', `loginName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '登录名', `loginPwd` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '登录密码，使用md5双次加密', `createTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `createUserId` 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; -- ---------------------------- -- Records of mortals_xhx_customer_pwd_record -- ---------------------------- -- ---------------------------- -- Table structure for mortals_xhx_customer_trial -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_customer_trial`; CREATE TABLE `mortals_xhx_customer_trial` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID，主键，自增长', `customerId` bigint(20) NULL DEFAULT NULL COMMENT '客户ID', `memberLevel` tinyint(2) NOT NULL DEFAULT 1 COMMENT '申请会员等级，1：试用客户，2：VIP，3：设计师', `isAccept` tinyint(2) NOT NULL DEFAULT 0 COMMENT '受理状态，0:未受理，1:同意，2:不同意。默认：0', `createUserId` bigint(20) NULL DEFAULT NULL COMMENT '受理用户', `createTime` datetime(0) NOT NULL COMMENT '提交时间', `updateTime` datetime(0) NULL DEFAULT NULL COMMENT '受理时间', `custName` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '客户真实名称', `organization` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '单位名称', `contactTelphone` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '联系电话', `sex` tinyint(2) NULL DEFAULT NULL COMMENT '性别', `mailbox` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱', `job` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '职位', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '客户试用申请' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of mortals_xhx_customer_trial -- ---------------------------- INSERT INTO `mortals_xhx_customer_trial` VALUES (11, 41, 3, 1, 41, '2023-02-14 14:22:25', '2023-02-14 14:22:25', '廖旭伟', '信宏翔', '18981841597', 1, 'test@qq.com', '开发人员'); -- ---------------------------- -- Table structure for mortals_xhx_customer_work_collect -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_customer_work_collect`; CREATE TABLE `mortals_xhx_customer_work_collect` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID，主键，自增长', `customerId` bigint(20) NOT NULL COMMENT '客户ID', `masterplateId` bigint(20) NOT NULL COMMENT '模版ID', `createTime` datetime(0) NOT NULL COMMENT '收藏时间', `designType` tinyint(2) NOT NULL DEFAULT 1 COMMENT '作品类型：1:图片，2:视频', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '客户收藏信息' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of mortals_xhx_customer_work_collect -- ---------------------------- -- ---------------------------- -- Table structure for mortals_xhx_customer_work_design -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_customer_work_design`; CREATE TABLE `mortals_xhx_customer_work_design` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID，主键，自增长', `customerId` bigint(20) NOT NULL COMMENT '客户ID', `createTime` datetime(0) NOT NULL COMMENT '创建时间', `workDesignName` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '作品名称', `workDesignStatus` tinyint(2) NOT NULL COMMENT '作品状态：0:草稿，1:发布', `workDesignDesc` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '作品描述', `updateTime` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', `pictureIds` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模版引用的图片', `pictureSrcIds` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模版引用的素材', `pictureBackgroundIds` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模版引用的背景', `fontIds` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '作品引用的字体', `previewUrl` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图片预览地址（相对地址）', `draft` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '草稿内容', `designType` tinyint(2) NOT NULL DEFAULT 1 COMMENT '作品类型：1:图片，2:视频', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '客户作品信息' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of mortals_xhx_customer_work_design -- ---------------------------- -- ---------------------------- -- Table structure for mortals_xhx_customer_work_design_stat -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_customer_work_design_stat`; CREATE TABLE `mortals_xhx_customer_work_design_stat` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID，主键，自增长', `customerId` bigint(20) NOT NULL COMMENT '客户ID', `customerDesignPictures` int(4) NOT NULL COMMENT '客户设计图片数量', `customerDesignVideos` int(4) NOT NULL COMMENT '客户设计视频数量', `createTime` datetime(0) NOT NULL COMMENT '注册时间', `updateTime` 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; -- ---------------------------- -- Records of mortals_xhx_customer_work_design_stat -- ---------------------------- -- ---------------------------- -- Table structure for mortals_xhx_design_masterplate -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_design_masterplate`; CREATE TABLE `mortals_xhx_design_masterplate` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID，主键，自增长', `masterplateName` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '模版名称', `masterplateCode` int(4) NOT NULL COMMENT '模版编码', `customerId` bigint(20) NOT NULL COMMENT '发布人', `customerName` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '发布人名称', `createTime` datetime(0) NOT NULL COMMENT '发布时间', `masterplateDesc` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '模版描述', `masterplatePath` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '模版下载地址（相对地址）', `masterplateUseNum` int(4) NOT NULL COMMENT '模版被引用的次数。默认：0', `pictureIds` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模版引用的图片', `pictureSrcIds` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模版引用的素材', `pictureBackgroundIds` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模版引用的背景', `fontIds` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模版引用的字体', `previewUrl` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图片预览地址（相对地址）', `draft` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '草稿', `plateType` int(4) NOT NULL DEFAULT 1 COMMENT '版式。1：横版2竖版默认：1', `designType` tinyint(2) NOT NULL DEFAULT 1 COMMENT '作品类型：1:图片，2:视频', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '模版管理' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of mortals_xhx_design_masterplate -- ---------------------------- -- ---------------------------- -- Table structure for mortals_xhx_font_material -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_font_material`; CREATE TABLE `mortals_xhx_font_material` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID，主键，自增长', `fontName` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '字体名称', `createUserId` bigint(20) NOT NULL COMMENT '上传人', `createTime` datetime(0) NOT NULL COMMENT '上传时间', `fontDesc` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '字体描述', `fontPath` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '字体下载地址（相对地址）', `fileName` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '文件原始名称', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '字体素材' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of mortals_xhx_font_material -- ---------------------------- -- ---------------------------- -- Table structure for mortals_xhx_goview_masterplate -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_goview_masterplate`; CREATE TABLE `mortals_xhx_goview_masterplate` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '序号，主键，自增长', `masterplateName` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模板名称', `customerId` bigint(20) NULL DEFAULT NULL COMMENT '发布用户ID', `state` tinyint(2) NULL DEFAULT NULL COMMENT '项目状态[0未发布,1发布]', `indexImage` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '首页图片', `remarks` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模板介绍', `createUserId` bigint(20) NULL DEFAULT NULL COMMENT '创建用户', `createTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `updateUserId` bigint(20) NULL DEFAULT NULL COMMENT '更新用户', `updateTime` 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; -- ---------------------------- -- Records of mortals_xhx_goview_masterplate -- ---------------------------- -- ---------------------------- -- Table structure for mortals_xhx_goview_masterplate_data -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_goview_masterplate_data`; CREATE TABLE `mortals_xhx_goview_masterplate_data` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '序号，主键，自增长', `masterplateId` bigint(20) NULL DEFAULT NULL COMMENT '模板Id', `content` blob NULL COMMENT '存储数据', `createUserId` bigint(20) NULL DEFAULT NULL COMMENT '创建用户', `createTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `updateUserId` bigint(20) NULL DEFAULT NULL COMMENT '更新用户', `updateTime` 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; -- ---------------------------- -- Records of mortals_xhx_goview_masterplate_data -- ---------------------------- -- ---------------------------- -- Table structure for mortals_xhx_goview_project -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_goview_project`; CREATE TABLE `mortals_xhx_goview_project` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '序号，主键，自增长', `projectName` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '项目名称', `customerId` bigint(20) NULL DEFAULT NULL COMMENT '用户ID', `state` tinyint(2) NULL DEFAULT NULL COMMENT '项目状态[-1未发布,1发布]', `indexImage` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '首页图片', `remarks` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '项目介绍', `createUserId` bigint(20) NULL DEFAULT NULL COMMENT '创建用户', `createTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `updateUserId` bigint(20) NULL DEFAULT NULL COMMENT '更新用户', `updateTime` 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; -- ---------------------------- -- Records of mortals_xhx_goview_project -- ---------------------------- -- ---------------------------- -- Table structure for mortals_xhx_goview_project_data -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_goview_project_data`; CREATE TABLE `mortals_xhx_goview_project_data` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '序号，主键，自增长', `projectId` bigint(20) NULL DEFAULT NULL COMMENT '项目Id', `content` longblob NULL COMMENT '存储数据', `createUserId` bigint(20) NULL DEFAULT NULL COMMENT '创建用户', `createTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `updateUserId` bigint(20) NULL DEFAULT NULL COMMENT '更新用户', `updateTime` 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; -- ---------------------------- -- Records of mortals_xhx_goview_project_data -- ---------------------------- -- ---------------------------- -- Table structure for mortals_xhx_help -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_help`; CREATE TABLE `mortals_xhx_help` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '帮助ID，主键，自增长', `sortNum` int(8) NULL DEFAULT NULL COMMENT '排序号', `title` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '问题标题', `content` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '问题内容', `answerContent` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '问题回复', `questionType` tinyint(2) NULL DEFAULT NULL COMMENT '问题类型备用字段', `status` tinyint(2) NULL DEFAULT NULL COMMENT '状态备用字段', `useful` int(8) NULL DEFAULT NULL COMMENT '有用统计', `useless` int(8) NULL DEFAULT NULL COMMENT '无用统计', `createTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `createUserId` bigint(20) NULL DEFAULT NULL COMMENT '创建用户', `createUserName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建用户名称', `updateTime` datetime(0) NULL DEFAULT NULL COMMENT '修改时间', `updateUserId` bigint(20) NULL DEFAULT NULL COMMENT '修改用户', `updateUserName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci 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; -- ---------------------------- -- Records of mortals_xhx_help -- ---------------------------- -- ---------------------------- -- Table structure for mortals_xhx_help_evaluate -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_help_evaluate`; CREATE TABLE `mortals_xhx_help_evaluate` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '评价ID，主键，自增长', `helpId` bigint(20) NULL DEFAULT NULL COMMENT '帮助ID', `customerId` bigint(20) NULL DEFAULT NULL COMMENT '客户id', `custName` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '客户真实名称', `organization` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '单位名称', `contactTelphone` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系电话', `evaluateType` tinyint(2) NULL DEFAULT NULL COMMENT '评价结果1有用2没用', `evaluateTime` 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; -- ---------------------------- -- Records of mortals_xhx_help_evaluate -- ---------------------------- -- ---------------------------- -- Table structure for mortals_xhx_idgenerator -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_idgenerator`; CREATE TABLE `mortals_xhx_idgenerator` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '序号，主键，自增长', `idType` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'id类型', `idMaxValue` bigint(20) UNSIGNED NOT NULL COMMENT 'id值', `remark` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '备注', `versionNum` bigint(20) UNSIGNED NOT NULL COMMENT '版本号，默认0', `gmtModify` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最后修改时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '主键Id生成器业务' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of mortals_xhx_idgenerator -- ---------------------------- -- ---------------------------- -- Table structure for mortals_xhx_masterplate_use_info -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_masterplate_use_info`; CREATE TABLE `mortals_xhx_masterplate_use_info` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID，主键，自增长', `masterplateId` bigint(20) NOT NULL COMMENT '模版ID', `customerId` bigint(20) NOT NULL COMMENT '使用人ID', `customerName` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '使用人', `customerTelphone` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '使用人电话', `createTime` datetime(0) NOT NULL COMMENT '使用时间', `customerOrganization` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '使用人单位', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '模版使用信息' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of mortals_xhx_masterplate_use_info -- ---------------------------- -- ---------------------------- -- Table structure for mortals_xhx_menu -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_menu`; CREATE TABLE `mortals_xhx_menu` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '菜单ID，主键，自增长', `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '菜单名称', `url` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '连接地址', `parentId` bigint(20) NULL DEFAULT NULL COMMENT '父菜单ID，一级菜单的该字段值为-1', `orderId` int(11) NULL DEFAULT NULL COMMENT '排序编号', `status` tinyint(2) NULL DEFAULT NULL COMMENT '菜单状态，0：禁用，1：启用，默认1', `linkType` tinyint(2) NULL DEFAULT NULL COMMENT '链接方式，0：普通，1：弹出，2：脚本（JavaScript），默认0', `groupId` int(11) NULL DEFAULT NULL COMMENT '分组编号，使用菜单分隔符按该值分隔，默认1', `groupName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `imgPath` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '主菜单图标，主菜单图标的css样式名', `buttonImgPath` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '按钮图标，按钮图标的css样式名', `imgCommPath` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '常用菜单图标，常用菜单图标的css样式名', `commMenu` tinyint(2) NULL DEFAULT NULL COMMENT '是否常用菜单，0：非常用，1：常用，默认0', `menuType` tinyint(2) NULL DEFAULT NULL COMMENT '菜单类型，0：主菜单，1：非主菜单(功能操作组)，默认0', `authType` tinyint(2) NULL DEFAULT NULL COMMENT '权限类型，0：无限制，1：无需登录查看，2：需要登录查看，3：需要角色权限查看，默认3', `createTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `createUserId` bigint(20) NULL DEFAULT NULL COMMENT '创建用户', `createUserName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci 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; -- ---------------------------- -- Records of mortals_xhx_menu -- ---------------------------- -- ---------------------------- -- Table structure for mortals_xhx_message -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_message`; CREATE TABLE `mortals_xhx_message` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '消息ID，主键，自增长', `title` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '消息标题', `content` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '消息内容', `sendMode` tinyint(2) NOT NULL COMMENT '发送方式1站内发送2短信发送3同时发送', `scope` tinyint(2) NOT NULL COMMENT '可见范围1所有人可见2VIP可见3普通用户可见', `sendStatus` tinyint(2) NULL DEFAULT NULL COMMENT '发送状态0未发送1已发送', `sendTime` datetime(0) NULL DEFAULT NULL COMMENT '发送时间', `createTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `createUserId` bigint(20) NULL DEFAULT NULL COMMENT '创建用户', `createUserName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建用户名称', `messageType` tinyint(2) NOT NULL COMMENT '消息类型1标题消息2动态消息', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '客户建议信息' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of mortals_xhx_message -- ---------------------------- -- ---------------------------- -- Table structure for mortals_xhx_news -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_news`; CREATE TABLE `mortals_xhx_news` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '消息ID，主键，自增长', `messageId` bigint(20) NULL DEFAULT NULL COMMENT '消息id', `customerId` bigint(20) NULL DEFAULT NULL COMMENT '客户id', `title` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '消息标题', `content` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '消息内容', `messageType` tinyint(2) NOT NULL COMMENT '消息类型1标题消息2动态消息', `readStatus` tinyint(2) NOT NULL DEFAULT 0 COMMENT '查阅状态0未读1已读', `receiveTime` 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; -- ---------------------------- -- Records of mortals_xhx_news -- ---------------------------- -- ---------------------------- -- Table structure for mortals_xhx_oper_log -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_oper_log`; CREATE TABLE `mortals_xhx_oper_log` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '序号，主键，自增长', `platformMark` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '平台标识', `userId` bigint(20) NULL DEFAULT NULL COMMENT '用户id', `userName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户名称', `loginName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户登录名', `requestUrl` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '请求地址', `content` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作内容，记录操作具体信息，如修改前修改或的数据', `ip` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作IP地址', `logDate` datetime(0) NULL DEFAULT NULL COMMENT '操作时间', `operType` tinyint(2) NULL DEFAULT NULL COMMENT '操作类型，0：新增，1：修改，2：删除', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '操作日志业务' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of mortals_xhx_oper_log -- ---------------------------- INSERT INTO `mortals_xhx_oper_log` VALUES (1, 'datav-manager', 1, '系统管理员', 'admin', '/dm/help/list', '查询帮助信息 【成功】', '192.168.0.54', '2024-11-18 15:30:42', NULL); INSERT INTO `mortals_xhx_oper_log` VALUES (2, 'datav-manager', 1, '系统管理员', 'admin', '/dm/help/list', '查询帮助信息 【成功】', '192.168.0.54', '2024-11-18 15:30:43', NULL); INSERT INTO `mortals_xhx_oper_log` VALUES (3, 'datav-manager', 1, '系统管理员', 'admin', '/dm/proposal/list', '查询客户建议信息 【成功】', '192.168.0.54', '2024-11-18 15:30:44', NULL); INSERT INTO `mortals_xhx_oper_log` VALUES (4, 'datav-manager', 1, '系统管理员', 'admin', '/dm/proposal/list', '查询客户建议信息 【成功】', '192.168.0.54', '2024-11-18 15:30:46', NULL); INSERT INTO `mortals_xhx_oper_log` VALUES (5, 'datav-manager', 1, '系统管理员', 'admin', '/dm/role/list', '查询角色信息 【成功】', '192.168.0.54', '2024-11-18 15:30:47', NULL); INSERT INTO `mortals_xhx_oper_log` VALUES (6, 'datav-manager', 1, '系统管理员', 'admin', '/dm/user/list', '查询用户信息 【成功】', '192.168.0.54', '2024-11-18 15:30:47', NULL); INSERT INTO `mortals_xhx_oper_log` VALUES (7, 'datav-manager', 1, '系统管理员', 'admin', '/dm/role/list', '查询角色信息 【成功】', '192.168.0.54', '2024-11-18 15:30:48', NULL); INSERT INTO `mortals_xhx_oper_log` VALUES (8, 'datav-manager', 1, '系统管理员', 'admin', '/dm/oper/log/list', '查询操作日志 【成功】', '192.168.0.54', '2024-11-18 15:30:49', NULL); -- ---------------------------- -- Table structure for mortals_xhx_param -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_param`; CREATE TABLE `mortals_xhx_param` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '序号，主键，自增长', `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '参数名称', `firstOrganize` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '一级组织，如：平台配置', `secondOrganize` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '二级组织，如：基础配置', `paramKey` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '参数键，全局唯一', `paramValue` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '参数值', `validStatus` tinyint(2) NULL DEFAULT NULL COMMENT '参数有效状态，0：禁用，1：启用，默认1', `modStatus` tinyint(2) NULL DEFAULT NULL COMMENT '参数修改状态，0：隐藏，1：页面仅查看，2：页面可修改，3：页面可删除，4：页面可修改删除，默认4', `displayType` tinyint(2) NULL DEFAULT NULL COMMENT '展现类型，0：普通文本框，1：多行文本框，2：开关，3：块输入框，默认：0', `remark` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注', `createTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `createUserId` bigint(20) NULL DEFAULT NULL COMMENT '创建用户', `createUserName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建用户名称', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 32 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '参数信息业务' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of mortals_xhx_param -- ---------------------------- INSERT INTO `mortals_xhx_param` VALUES (2, '素材分组', 'PictureMaterial', 'pictureGroupId', '4', '风景元素', NULL, NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (6, '素材分组', 'PictureMaterial', 'pictureGroupId', '2', '美食元素', NULL, NULL, NULL, NULL, '2022-06-15 17:20:29', 1, '系统管理员'); INSERT INTO `mortals_xhx_param` VALUES (11, '素材分组', 'PictureMaterial', 'pictureGroupId', '3', '党政元素', NULL, NULL, NULL, NULL, '2022-06-15 18:19:36', 1, '系统管理员'); INSERT INTO `mortals_xhx_param` VALUES (13, '素材分类', 'PictureMaterial', 'pictureClassifyId', '1', '党建元素', NULL, NULL, NULL, NULL, '2022-06-15 18:19:36', 1, '系统管理员'); INSERT INTO `mortals_xhx_param` VALUES (14, '素材分类', 'PictureMaterial', 'pictureClassifyId', '2', '餐饮元素', NULL, NULL, NULL, NULL, '2022-06-15 18:32:17', 1, '系统管理员'); INSERT INTO `mortals_xhx_param` VALUES (21, '素材分组', 'PictureMaterial', 'pictureGroupId', '5', '新闻报道', NULL, NULL, NULL, NULL, '2022-07-12 16:21:57', 1, '系统管理员'); INSERT INTO `mortals_xhx_param` VALUES (23, '素材分组', 'PictureMaterial', 'pictureGroupId', '7', '政务服务', NULL, NULL, NULL, NULL, '2022-08-12 16:10:54', 1, '系统管理员'); INSERT INTO `mortals_xhx_param` VALUES (24, '素材分组', 'PictureMaterial', 'pictureGroupId', '8', '线、箭头', NULL, NULL, NULL, NULL, '2022-08-12 16:48:42', 1, '系统管理员'); INSERT INTO `mortals_xhx_param` VALUES (25, '素材分组', 'PictureMaterial', 'pictureGroupId', '9', '几何形状', NULL, NULL, NULL, NULL, '2022-08-12 16:51:19', 1, '系统管理员'); INSERT INTO `mortals_xhx_param` VALUES (26, '素材分组', 'PictureMaterial', 'pictureGroupId', '10', '人物插画', NULL, NULL, NULL, NULL, '2022-08-12 16:58:54', 1, '系统管理员'); INSERT INTO `mortals_xhx_param` VALUES (27, '素材分组', 'PictureMaterial', 'pictureGroupId', '11', '科技元素', NULL, NULL, NULL, NULL, '2022-08-15 11:14:24', 1, '系统管理员'); INSERT INTO `mortals_xhx_param` VALUES (28, '素材分组', 'PictureMaterial', 'pictureGroupId', '12', '节日元素', NULL, NULL, NULL, NULL, '2022-08-17 15:09:44', 1, '系统管理员'); INSERT INTO `mortals_xhx_param` VALUES (29, '素材分组', 'PictureMaterial', 'pictureGroupId', '13', '其他', NULL, NULL, NULL, NULL, '2022-08-17 15:18:22', 1, '系统管理员'); INSERT INTO `mortals_xhx_param` VALUES (30, '素材分组', 'PictureMaterial', 'pictureGroupId', '14', '数字', NULL, NULL, NULL, NULL, '2022-08-17 16:15:38', 1, '系统管理员'); INSERT INTO `mortals_xhx_param` VALUES (31, '素材分组', 'PictureMaterial', 'pictureGroupId', '15', '艺术字', NULL, NULL, NULL, NULL, '2022-08-19 15:19:07', 1, '系统管理员'); -- ---------------------------- -- Table structure for mortals_xhx_picture_material -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_picture_material`; CREATE TABLE `mortals_xhx_picture_material` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID，主键，自增长', `pictureName` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '图片名称', `pictureGroupId` bigint(20) NOT NULL COMMENT '图片分组（系统参数中获取，字典数据）', `pictureClassifyId` bigint(20) NOT NULL COMMENT '图片分类（系统参数中获取，字典数据）', `createUserId` bigint(20) NOT NULL COMMENT '上传人', `createTime` datetime(0) NOT NULL COMMENT '上传时间', `pictureDesc` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '图片描述', `picturePath` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '图片下载地址（相对地址）', `pictureType` tinyint(2) NOT NULL COMMENT '图片类型，0:普通图片，1：素材，2:背景图片。默认：0', `fileName` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '文件原始名称', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '图片素材' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of mortals_xhx_picture_material -- ---------------------------- -- ---------------------------- -- Table structure for mortals_xhx_proposal -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_proposal`; CREATE TABLE `mortals_xhx_proposal` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '建议ID，主键，自增长', `content` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '建议内容', `screenshot` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '截图地址', `customerId` bigint(20) NULL DEFAULT NULL COMMENT '客户id', `custName` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '客户名称', `createTime` datetime(0) NOT NULL COMMENT '提交时间', `replyStatus` tinyint(2) NULL DEFAULT 0 COMMENT '回复状态备0未回复1已回复', `replyContent` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '回复内容', `replyTime` datetime(0) NULL DEFAULT NULL COMMENT '回复时间', `sendMode` tinyint(2) NULL DEFAULT NULL COMMENT '回复发送方式1站内发送2短信发送3同时发送', `sendStatus` tinyint(2) NULL DEFAULT 0 COMMENT '回复发送状态0未发送1已发送', `contactTelphone` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '联系电话', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '客户建议信息' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of mortals_xhx_proposal -- ---------------------------- -- ---------------------------- -- Table structure for mortals_xhx_question -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_question`; CREATE TABLE `mortals_xhx_question` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '问答ID，主键，自增长', `questionType` tinyint(2) NULL DEFAULT 1 COMMENT '问题类型备用字段', `status` tinyint(2) NOT NULL DEFAULT 0 COMMENT '状态0未完成1已完成', `customerId` bigint(20) NOT NULL COMMENT '客户id', `custName` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '客户真实名称', `organization` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '单位名称', `contactTelphone` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '联系电话', `createUserName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建用户名称', `beginTime` datetime(0) NULL DEFAULT NULL COMMENT '开始时间', `finishTime` datetime(0) NULL DEFAULT NULL COMMENT '结束时间', `evaluate` tinyint(2) NOT NULL DEFAULT 0 COMMENT '评价', `sumQA` int(8) NOT NULL DEFAULT 0 COMMENT '问答次数', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '问答信息' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of mortals_xhx_question -- ---------------------------- -- ---------------------------- -- Table structure for mortals_xhx_question_record -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_question_record`; CREATE TABLE `mortals_xhx_question_record` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '记录ID，主键，自增长', `questionId` bigint(20) NULL DEFAULT NULL COMMENT '用户ID，主键，自增长', `recordType` tinyint(2) NULL DEFAULT NULL COMMENT '记录类型1提问2答复', `content` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '内容', `createTime` datetime(0) NULL DEFAULT NULL COMMENT '提交时间', `createUserName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci 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; -- ---------------------------- -- Records of mortals_xhx_question_record -- ---------------------------- -- ---------------------------- -- Table structure for mortals_xhx_question_reply -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_question_reply`; CREATE TABLE `mortals_xhx_question_reply` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '回复ID，主键，自增长', `keywords` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '问题关键字', `replyContent` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '回复内容', `createTime` datetime(0) NULL DEFAULT NULL COMMENT '提交时间', `createUserName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci 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; -- ---------------------------- -- Records of mortals_xhx_question_reply -- ---------------------------- -- ---------------------------- -- Table structure for mortals_xhx_resource -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_resource`; CREATE TABLE `mortals_xhx_resource` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '菜单ID，主键，自增长', `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称', `url` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '连接地址，多个地址以逗号分隔', `authType` tinyint(2) NULL DEFAULT NULL COMMENT '权限类型，0：无限制，1：无需登录查看，2：需要登录查看，3：需要角色权限查看，默认3', `sourceType` tinyint(2) NULL DEFAULT NULL COMMENT '资源类型，0：系统资源，1：开放资源，默认0', `createTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `createUserId` bigint(20) NULL DEFAULT NULL COMMENT '创建用户', `createUserName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建用户名称', `userType` tinyint(2) NULL DEFAULT NULL COMMENT '用户类型，0：系统用户 1:代理商用户 2:品牌商用户', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '资源信息业务' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of mortals_xhx_resource -- ---------------------------- -- ---------------------------- -- Table structure for mortals_xhx_role -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_role`; CREATE TABLE `mortals_xhx_role` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '序号，主键，自增长', `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色名称', `remark` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注', `roleType` tinyint(2) NULL DEFAULT NULL COMMENT '角色类型，0：系统内置角色（不可删除），1：默认系统角色，2：普通角色，默认2', `customerId` bigint(20) NULL DEFAULT NULL COMMENT '归属客户ID', `createTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `createUserId` bigint(20) NULL DEFAULT NULL COMMENT '创建用户', `createUserName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建用户名称', `userType` tinyint(2) NULL DEFAULT NULL COMMENT '用户类型，0：系统用户 1:代理商用户 2:品牌商用户', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 25 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色信息业务' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of mortals_xhx_role -- ---------------------------- INSERT INTO `mortals_xhx_role` VALUES (5, '超级管理员', '超级', NULL, NULL, '2022-06-15 14:05:38', 1, '系统管理员', NULL); INSERT INTO `mortals_xhx_role` VALUES (21, 'UI设计', '设计师', NULL, NULL, '2022-07-12 14:37:35', 1, '系统管理员', NULL); INSERT INTO `mortals_xhx_role` VALUES (22, 'VIP会员', 'VIP会员', NULL, NULL, '2022-07-12 14:37:57', 1, '系统管理员', NULL); INSERT INTO `mortals_xhx_role` VALUES (23, '普通用户', '普通用户', NULL, NULL, '2022-07-12 14:38:07', 1, '系统管理员', NULL); INSERT INTO `mortals_xhx_role` VALUES (24, '访客', '访客', NULL, NULL, '2022-07-12 14:38:14', 1, '系统管理员', NULL); -- ---------------------------- -- Table structure for mortals_xhx_role_auth -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_role_auth`; CREATE TABLE `mortals_xhx_role_auth` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '序号，主键，自增长', `roleId` bigint(20) NULL DEFAULT NULL COMMENT '角色ID', `resourceId` bigint(20) 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; -- ---------------------------- -- Records of mortals_xhx_role_auth -- ---------------------------- -- ---------------------------- -- Table structure for mortals_xhx_role_user -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_role_user`; CREATE TABLE `mortals_xhx_role_user` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '序号，主键，自增长', `roleId` bigint(20) NULL DEFAULT NULL COMMENT '角色ID', `userId` bigint(20) NULL DEFAULT NULL COMMENT '用户ID', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 26 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色用户业务' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of mortals_xhx_role_user -- ---------------------------- INSERT INTO `mortals_xhx_role_user` VALUES (4, 5, 2); INSERT INTO `mortals_xhx_role_user` VALUES (5, 8, 2); INSERT INTO `mortals_xhx_role_user` VALUES (6, 5, 3); INSERT INTO `mortals_xhx_role_user` VALUES (7, 6, 3); INSERT INTO `mortals_xhx_role_user` VALUES (8, 5, 4); INSERT INTO `mortals_xhx_role_user` VALUES (10, 6, 6); INSERT INTO `mortals_xhx_role_user` VALUES (12, 5, 1); INSERT INTO `mortals_xhx_role_user` VALUES (14, 5, 7); INSERT INTO `mortals_xhx_role_user` VALUES (15, 5, 8); INSERT INTO `mortals_xhx_role_user` VALUES (16, 5, 9); INSERT INTO `mortals_xhx_role_user` VALUES (17, 5, 5); INSERT INTO `mortals_xhx_role_user` VALUES (19, 23, 10); INSERT INTO `mortals_xhx_role_user` VALUES (22, 5, 11); INSERT INTO `mortals_xhx_role_user` VALUES (23, 5, 12); INSERT INTO `mortals_xhx_role_user` VALUES (24, 5, 13); INSERT INTO `mortals_xhx_role_user` VALUES (25, 5, 14); -- ---------------------------- -- Table structure for mortals_xhx_site -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_site`; CREATE TABLE `mortals_xhx_site` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID，主键，自增长', `siteName` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '站点名', `parentId` bigint(11) NOT NULL COMMENT '父级id', `ancestors` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '祖级列表，逗号分隔', `address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '地址', `mobile` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '电话', `introduce` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '单位介绍', `workday1` tinyint(1) NULL DEFAULT NULL COMMENT '周一 1上班 0不上', `workday2` tinyint(1) NULL DEFAULT NULL COMMENT '周二 1上班 0不上', `workday3` tinyint(1) NULL DEFAULT NULL COMMENT '周三 1上班 0不上', `workday4` tinyint(1) NULL DEFAULT NULL COMMENT '周四 1上班 0不上', `workday5` tinyint(1) NULL DEFAULT NULL COMMENT '周五 1上班 0不上', `workday6` tinyint(1) NULL DEFAULT NULL COMMENT '周六 1上班 0不上', `workday7` tinyint(1) NULL DEFAULT NULL COMMENT '周日 1上班 0不上', `number` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '站点编号', `summary` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '中心介绍', `orderNum` int(9) NULL DEFAULT 0 COMMENT '排序字段', `status` tinyint(2) NULL DEFAULT 1 COMMENT '站点状态 ，0，停用，1，正常 默认1', `updateTime` datetime(0) NULL DEFAULT NULL COMMENT '变更时间', `updateUser` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '变更用户loginName', `createTime` datetime(0) NOT NULL COMMENT '创建时间', `createUser` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建用户loginName', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '站点信息表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of mortals_xhx_site -- ---------------------------- -- ---------------------------- -- Table structure for mortals_xhx_table_index -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_table_index`; CREATE TABLE `mortals_xhx_table_index` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '菜单ID，主键，自增长', `tableName` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '表名称', `tableMark` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '表标识', `createTime` 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; -- ---------------------------- -- Records of mortals_xhx_table_index -- ---------------------------- -- ---------------------------- -- Table structure for mortals_xhx_task -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_task`; CREATE TABLE `mortals_xhx_task` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '序号，主键，自增长', `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '任务名称', `taskKey` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '任务关键字，区分任务执行流程', `status` tinyint(2) NULL DEFAULT NULL COMMENT '任务状态，0：未启动，1：执行中，默认0', `excuteService` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '任务执行服务', `excuteParam` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '任务执行参数', `excuteHost` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '任务执行主机，为空表示不限制任务的执行主机，多个用逗号分隔', `excuteStrategy` tinyint(2) NULL DEFAULT NULL COMMENT '执行策略，1：按日，2：按周，3：按月，4：按间隔时间，默认1', `excuteDate` int(11) NULL DEFAULT NULL COMMENT '执行日期，按日：则为0；按周：则为1-7；按月：则为：1-31；按间隔时间：则为间隔时间，单位：秒；默认0', `excuteTime` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '执行时间，格式：HH:mm，默认：00:00', `remark` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注', `lastExcuteHost` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '最后执行主机', `lastExcuteTime` datetime(0) NULL DEFAULT NULL COMMENT '最后执行时间', `interimExcuteStatus` tinyint(2) NULL DEFAULT NULL COMMENT '临时执行状态，0：未启用，1：立即执行并保留，2：立即执行并删除，默认0', `createTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `createUserId` bigint(20) NULL DEFAULT NULL COMMENT '创建用户', `createUserName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci 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; -- ---------------------------- -- Records of mortals_xhx_task -- ---------------------------- -- ---------------------------- -- Table structure for mortals_xhx_uploadfile -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_uploadfile`; CREATE TABLE `mortals_xhx_uploadfile` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID，主键，自增长', `fileName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文件名称', `filePath` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文件路径', `fileType` tinyint(2) NULL DEFAULT NULL COMMENT '文件类型，1 excel ,2 img,3 zip, 4 pdf', `createTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `createUser` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci 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; -- ---------------------------- -- Records of mortals_xhx_uploadfile -- ---------------------------- -- ---------------------------- -- Table structure for mortals_xhx_user -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_user`; CREATE TABLE `mortals_xhx_user` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '用户ID，主键，自增长', `loginName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '登录名', `loginPwd` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '登录密码，使用md5双次加密', `loginPwd1` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '最近一次使用密码，使用md5双次加密', `loginPwd2` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '最近二次使用密码，使用md5双次加密', `loginPwd3` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '最近三次使用密码，使用md5双次加密', `loginLimitAddress` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '登录限制地址，多个IP地址用逗号分隔，可以使用IP段匹配，如：172.17.*非空：则只能该值内的IP可以登录', `realName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户名', `mobile` varchar(21) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户手机号', `phone` varchar(21) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户联系电话', `email` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户邮箱', `qq` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'QQ号码', `userType` tinyint(2) NULL DEFAULT NULL COMMENT '用户类型，0：系统用户 1:普通用户 2:工作人员，默认2', `siteId` bigint(20) NULL DEFAULT NULL COMMENT '站点id', `status` tinyint(2) NULL DEFAULT NULL COMMENT '用户状态，0：停用，1：正常，2：冻结，3：销户，4：离职，默认1', `customerId` bigint(20) NULL DEFAULT NULL COMMENT '客户ID', `createTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `createUserId` bigint(20) NULL DEFAULT NULL COMMENT '创建用户', `createUserName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建用户名称', `lastLoginTime` datetime(0) NULL DEFAULT NULL COMMENT '最后一次登录时间', `lastLoginAddress` varchar(21) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '最后一次登录地址', `lastModPwdTime` datetime(0) NULL DEFAULT NULL COMMENT '最后修改密码时间', `lastModPwdAddr` varchar(21) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '最后修改密码地址', `saltKey` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '密码盐值', `lastUpdatePwdTime` datetime(0) NULL DEFAULT NULL COMMENT '最后一次修改密码时间', `errorCount` tinyint(2) NULL DEFAULT 0 COMMENT '当日登录失败数', `loginLock` tinyint(2) NULL DEFAULT 0 COMMENT '登录锁定状态0未锁定1已锁定', `lockTime` datetime(0) NULL DEFAULT NULL COMMENT '锁定时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户信息业务' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of mortals_xhx_user -- ---------------------------- INSERT INTO `mortals_xhx_user` VALUES (1, 'admin', '43442676c74ae59f219c2d87fd6bad52', NULL, NULL, NULL, NULL, '系统管理员', '13808095770', NULL, NULL, NULL, 1, NULL, 1, NULL, '2022-06-02 09:12:26', 1, 'admin', '2024-11-18 15:27:14', '192.168.0.54', NULL, NULL, NULL, NULL, 0, 0, NULL); -- ---------------------------- -- Table structure for mortals_xhx_user_pwd_record -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_user_pwd_record`; CREATE TABLE `mortals_xhx_user_pwd_record` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键，自增长', `userId` bigint(20) NULL DEFAULT NULL COMMENT '用户ID，主键，自增长', `loginName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '登录名', `loginPwd` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '登录密码，使用md5双次加密', `createTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `createUserId` 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; -- ---------------------------- -- Records of mortals_xhx_user_pwd_record -- ---------------------------- -- ---------------------------- -- Table structure for mortals_xhx_valid_code -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_valid_code`; CREATE TABLE `mortals_xhx_valid_code` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '菜单ID，主键，自增长', `code` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '验证码', `url` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '校验地址，email校验使用', `mobile` varchar(21) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '校验手机号', `email` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '校验邮箱', `type` tinyint(2) NULL DEFAULT NULL COMMENT '校验方式，0：图片校验，1：手机校验，2：邮箱校验，默认0', `sessionId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '会话ID', `ip` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'IP地址', `createTime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `lapseTime` datetime(0) NULL DEFAULT NULL COMMENT '失效时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 17 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '验证码信息业务' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of mortals_xhx_valid_code -- ---------------------------- INSERT INTO `mortals_xhx_valid_code` VALUES (1, '8351', NULL, NULL, NULL, 0, '2D3E28A7CC5C559BC53F49F87BD1C8BF', '192.168.0.192', '2023-11-13 09:41:37', '2023-11-13 09:51:37'); INSERT INTO `mortals_xhx_valid_code` VALUES (2, '8624', NULL, NULL, NULL, 0, '0A5298515780FCA1BAA19F9BA1FF6FB3', '192.168.0.192', '2023-11-13 09:41:49', '2023-11-13 09:51:49'); INSERT INTO `mortals_xhx_valid_code` VALUES (3, '5428', NULL, NULL, NULL, 0, '1A7D26AF21672F51995502BD9CF4DC1D', '192.168.0.192', '2023-11-13 09:41:51', '2023-11-13 09:51:51'); INSERT INTO `mortals_xhx_valid_code` VALUES (4, '7153', NULL, NULL, NULL, 0, '9192EFE17031156972273637731D03CA', '192.168.0.192', '2023-11-13 09:42:33', '2023-11-13 09:52:33'); INSERT INTO `mortals_xhx_valid_code` VALUES (5, '1297', NULL, NULL, NULL, 0, '4F010BA8A269B3C8FC6D95E280F96173', '192.168.0.192', '2023-11-13 09:42:48', '2023-11-13 09:52:48'); INSERT INTO `mortals_xhx_valid_code` VALUES (6, '7829', NULL, NULL, NULL, 0, '3D1D4C55B9B8B317E70C713AF09360E0', '192.168.0.192', '2023-11-13 09:43:47', '2023-11-13 09:53:47'); INSERT INTO `mortals_xhx_valid_code` VALUES (7, '8613', NULL, NULL, NULL, 0, 'E2294F9D8FBBB6A0AED79AA30F8926E5', '192.168.0.192', '2023-11-13 09:44:24', '2023-11-13 09:54:24'); INSERT INTO `mortals_xhx_valid_code` VALUES (8, '3569', NULL, NULL, NULL, 0, 'FABDBBB9C77E28A206608CCA753DA8F3', '192.168.0.192', '2023-11-13 09:44:32', '2023-11-13 09:54:32'); INSERT INTO `mortals_xhx_valid_code` VALUES (9, '6894', NULL, NULL, NULL, 0, 'FBE6846A98EC5803318B3E33D2C84F3F', '192.168.0.192', '2023-11-13 09:44:38', '2023-11-13 09:54:38'); INSERT INTO `mortals_xhx_valid_code` VALUES (10, '7826', NULL, NULL, NULL, 0, '14971108A19E67D720AA46A8C6ECAE06', '192.168.0.192', '2023-11-13 09:44:48', '2023-11-13 09:54:48'); INSERT INTO `mortals_xhx_valid_code` VALUES (11, '4735', NULL, NULL, NULL, 0, '2ED8F8D23FFACDCFF51302AADBBD8837', '192.168.0.192', '2023-11-13 09:45:21', '2023-11-13 09:55:21'); INSERT INTO `mortals_xhx_valid_code` VALUES (12, '4628', NULL, NULL, NULL, 0, '6C223AB29EE28710ABB04ACC897CE4D8', '192.168.0.192', '2023-11-13 09:45:21', '2023-11-13 09:55:21'); INSERT INTO `mortals_xhx_valid_code` VALUES (13, '9416', NULL, NULL, NULL, 0, '202FC3D0A930C768B5BB9935C580698A', '192.168.0.192', '2023-11-13 09:48:56', '2023-11-13 09:58:56'); INSERT INTO `mortals_xhx_valid_code` VALUES (14, '4376', NULL, NULL, NULL, 0, 'E799A3F5C45FF0AF757C8886109C5F0E', '192.168.0.192', '2023-11-13 09:50:17', '2023-11-13 10:00:17'); INSERT INTO `mortals_xhx_valid_code` VALUES (15, '8623', NULL, NULL, NULL, 0, 'E98E7C330F0310B8C2868E2B1084EF41', '192.168.0.192', '2023-11-13 09:50:49', '2023-11-13 10:00:49'); INSERT INTO `mortals_xhx_valid_code` VALUES (16, '3927', NULL, NULL, NULL, 0, '3AB67ADDF36575C72154112C2953F86A', '192.168.0.69', '2023-12-06 11:27:20', '2023-12-06 11:37:20'); SET FOREIGN_KEY_CHECKS = 1;