卷王 SurveyKing 在idea中部署

/* Source Server : mysql5-local Source Server Type : MySQL Source Server Version : 50735 Source Host : localhost:3306 Source Schema : surveyking Target Server Type : MySQL Target Server Version : 50735 File Encoding : 65001 Date: 10/11/2022 08:06:16 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for t_account -- ---------------------------- CREATE TABLE `t_account` ( `id` varchar(64) NOT NULL COMMENT 'ID', `user_type` varchar(100) NOT NULL DEFAULT 'SysUser' COMMENT '用户类型', `user_id` varchar(64) NOT NULL COMMENT '用户ID', `auth_type` varchar(20) NOT NULL DEFAULT 'PWD' COMMENT '认证方式', `auth_account` varchar(100) NOT NULL COMMENT '用户名', `auth_secret` varchar(64) DEFAULT NULL COMMENT '密码', `secret_salt` varchar(32) DEFAULT NULL COMMENT '加密盐', `status` int(11) NOT NULL DEFAULT '1' COMMENT '用户状态', `is_deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除', `create_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `create_by` varchar(256) DEFAULT NULL, `update_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `update_by` varchar(256) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='登录账号'; -- ---------------------------- -- Records of t_account -- ---------------------------- BEGIN; INSERT INTO `t_account` VALUES ('1457995482310680578', 'SysUser', '1457995481966747649', 'PWD', 'admin', '$2a$10$vZk9P3XtbD2KrdLbQYPvBuPAkkUda0OlkDg7io1Q6VEtfFPig/tqO', NULL, 1, 0, '2021-11-09 16:56:26', NULL, '2022-02-01 23:57:27', '1457995481966747649'); COMMIT; -- ---------------------------- -- Table structure for t_answer -- ---------------------------- CREATE TABLE `t_answer` ( `id` varchar(64) COLLATE utf8mb4_bin NOT NULL, `project_id` varchar(64) COLLATE utf8mb4_bin NOT NULL, `temp_answer` text COLLATE utf8mb4_bin COMMENT '暂存答案', `survey` text COLLATE utf8mb4_bin COMMENT '问卷', `answer` text COLLATE utf8mb4_bin COMMENT '问卷答案', `attachment` varchar(1024) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '问卷元数据', `meta_info` text COLLATE utf8mb4_bin COMMENT '问卷元数据', `temp_save` int(11) DEFAULT NULL COMMENT '0暂存 1已完成', `exam_info` text COLLATE utf8mb4_bin COMMENT '考试信息', `exam_score` float DEFAULT NULL COMMENT '考试分数', `is_deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除', `create_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `create_by` varchar(256) COLLATE utf8mb4_bin DEFAULT NULL, `update_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `update_by` varchar(256) COLLATE utf8mb4_bin DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, KEY `key_answer_pid` (`project_id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='答案'; -- ---------------------------- -- Records of t_answer -- ---------------------------- BEGIN; COMMIT; -- ---------------------------- -- Table structure for t_comm_dict -- ---------------------------- CREATE TABLE `t_comm_dict` ( `id` varchar(64) COLLATE utf8mb4_bin NOT NULL, `code` varchar(256) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '字典编码', `name` varchar(256) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '字典中文名称', `remark` varchar(256) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '备注信息', `dict_type` int(2) DEFAULT NULL COMMENT '字典类型 1:问卷字典', `create_at` datetime DEFAULT NULL COMMENT '创建时间', `create_by` varchar(256) COLLATE utf8mb4_bin DEFAULT NULL, `update_at` datetime DEFAULT NULL COMMENT '更新时间', `update_by` varchar(256) COLLATE utf8mb4_bin DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC; -- ---------------------------- -- Records of t_comm_dict -- ---------------------------- BEGIN; COMMIT; -- ---------------------------- -- Table structure for t_comm_dict_item -- ---------------------------- CREATE TABLE `t_comm_dict_item` ( `id` varchar(64) COLLATE utf8mb4_bin NOT NULL, `dict_code` varchar(256) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '字典编码', `item_name` varchar(256) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '字典项中文名称', `item_value` varchar(256) COLLATE utf8mb4_bin NOT NULL COMMENT '字典项值', `item_order` int(8) DEFAULT NULL COMMENT '字典顺序', `item_level` int(4) DEFAULT NULL COMMENT '层级', `parent_item_value` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '父字典项值', `create_at` datetime DEFAULT NULL COMMENT '创建时间', `create_by` varchar(256) COLLATE utf8mb4_bin DEFAULT NULL, `update_at` datetime DEFAULT NULL COMMENT '更新时间', `update_by` varchar(256) COLLATE utf8mb4_bin DEFAULT NULL, PRIMARY KEY (`id`,`item_value`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC; -- ---------------------------- -- Records of t_comm_dict_item -- ---------------------------- BEGIN; COMMIT; -- ---------------------------- -- Table structure for t_dashboard -- ---------------------------- CREATE TABLE `t_dashboard` ( `id` varchar(64) NOT NULL COMMENT 'ID', `key` varchar(256) NOT NULL COMMENT '仪表盘组件key', `type` int(2) DEFAULT NULL COMMENT '仪表盘分类', `project_id` varchar(64) DEFAULT NULL COMMENT '项目ID', `setting` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '仪表盘设置', `create_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `create_by` varchar(256) DEFAULT NULL, `update_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `update_by` varchar(256) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='仪表盘'; -- ---------------------------- -- Records of t_dashboard -- ---------------------------- BEGIN; COMMIT; -- ---------------------------- -- Table structure for t_dept -- ---------------------------- CREATE TABLE `t_dept` ( `id` varchar(64) NOT NULL COMMENT 'ID', `parent_id` varchar(64) NOT NULL, `name` varchar(64) DEFAULT NULL COMMENT '名称', `short_name` varchar(64) NOT NULL COMMENT '简称', `code` varchar(64) DEFAULT NULL COMMENT '数据权限类型', `manager_id` varchar(64) DEFAULT NULL COMMENT '扩展字段', `sort_code` int(11) DEFAULT NULL, `property_json` varchar(256) DEFAULT NULL COMMENT '扩展字段', `status` varchar(20) DEFAULT NULL COMMENT '扩展字段', `remark` varchar(256) DEFAULT NULL COMMENT '扩展字段', `is_deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除', `create_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `create_by` varchar(256) DEFAULT NULL, `update_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `update_by` varchar(256) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='组织机构'; -- ---------------------------- -- Records of t_dept -- ---------------------------- BEGIN; INSERT INTO `t_dept` VALUES ('1', '0', '卷王', 'juanwang', 'juanwang', '1457995481966747649', NULL, NULL, NULL, NULL, 0, '2021-11-21 14:12:08', NULL, '2021-11-21 14:22:58', '1457995481966747649'); COMMIT; -- ---------------------------- -- Table structure for t_file -- ---------------------------- CREATE TABLE `t_file` ( `id` varchar(64) COLLATE utf8mb4_bin NOT NULL, `original_name` varchar(256) COLLATE utf8mb4_bin DEFAULT NULL, `file_name` varchar(256) COLLATE utf8mb4_bin DEFAULT NULL, `file_path` varchar(512) COLLATE utf8mb4_bin DEFAULT NULL, `thumb_file_path` varchar(512) COLLATE utf8mb4_bin DEFAULT NULL, `storage_type` int(11) DEFAULT NULL, `shared` int(11) DEFAULT '0', `is_deleted` tinyin