/*
Navicat MySQL Data Transfer

Source Server         : 团队
Source Server Version : 50562
Source Host           : 103.140.126.214:3306
Source Database       : tuandui

Target Server Type    : MYSQL
Target Server Version : 50562
File Encoding         : 65001

Date: 2021-07-29 19:06:43
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for swx_auth_admin
-- ----------------------------
DROP TABLE IF EXISTS `swx_auth_admin`;
CREATE TABLE `swx_auth_admin` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(32) DEFAULT NULL COMMENT '用户名',
  `pwd` varchar(32) DEFAULT NULL COMMENT 'DM5后的密码',
  `nick` varchar(32) DEFAULT NULL COMMENT '昵称',
  `logo` varchar(120) DEFAULT '/admin/images/default.jpg' COMMENT '头像地址',
  `role` int(11) DEFAULT NULL COMMENT '角色ID',
  `phone` varchar(32) DEFAULT NULL COMMENT '手机号',
  `status` tinyint(1) DEFAULT '1' COMMENT '状态 0|1 关闭|开启',
  `identity` varchar(32) DEFAULT NULL COMMENT '身份',
  `color` varchar(32) DEFAULT NULL COMMENT '标签颜色',
  `create_time` int(10) DEFAULT NULL COMMENT '新增时间',
  `update_time` int(10) DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`),
  KEY `role` (`role`) USING BTREE,
  KEY `name` (`name`) USING BTREE,
  KEY `phone` (`phone`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COMMENT='AUTH - 管理员';

-- ----------------------------
-- Records of swx_auth_admin
-- ----------------------------
INSERT INTO `swx_auth_admin` VALUES ('1', 'admin', '31337d9843721197b9861ef126af8e90', 'admin', '/uploads/20210727/1627356531_678561709.jpg', '0', '', '1', 'PHP后端开发', '#33a3dc', '1627455576', '1627551835');
INSERT INTO `swx_auth_admin` VALUES ('2', '古**', '978269ed5ab74d015d9498deacfef2cd', '古**', '/admin/images/default.jpg', '4', '', '1', 'PHP后端开发', '#f36c21', '1627455576', '1627460205');
INSERT INTO `swx_auth_admin` VALUES ('4', '谢**', 'f158ed7682bf4813a15789612587598a', '谢**', '/admin/images/default.jpg', '4', '', '1', 'PHP后端开发', '#411445', '1627455211', '1627460211');
INSERT INTO `swx_auth_admin` VALUES ('5', '梁**', '3d445887cdcc22a65e5d655881295a0c', '梁**', '/admin/images/default.jpg', '0', '', '1', '技术总监', '#585eaa', '1627455243', '1627460215');
INSERT INTO `swx_auth_admin` VALUES ('6', '吴**', 'ecb91196ae78e9dd3dde38d953f81904', '吴**', '/admin/images/default.jpg', '4', '', '1', '前端开发', '#d93a49', '1627455388', '1627460220');
INSERT INTO `swx_auth_admin` VALUES ('7', '雷**', 'de1e3d91bd966722688e36ff7dd8649d', '雷**', '/admin/images/default.jpg', '4', '', '1', '前端开发', '#1a2933', '1627455431', '1627460225');
INSERT INTO `swx_auth_admin` VALUES ('8', '李**', '7f8c76d0033cc1ec8ceebb944abb3686', '李**', '/admin/images/default.jpg', '4', '', '1', '测试专员', '#008792', '1627455502', '1627460230');
INSERT INTO `swx_auth_admin` VALUES ('9', '屈**', '0a10522ad96f3b1bf17c22826632a471', '屈**', '/admin/images/default.jpg', '4', '', '1', '测试专员', '#84331f', '1627455536', '1627460235');
INSERT INTO `swx_auth_admin` VALUES ('10', '陈**', '978269ed5ab74d015d9498deacfef2cd', '陈**', '/admin/images/default.jpg', '4', '', '1', '运维专员', '#00ae9d', '1627455576', '1627460240');
INSERT INTO `swx_auth_admin` VALUES ('11', '欧**', '66e305556ac91df6cb5df785bf940bff', '欧**', '/admin/images/default.jpg', '4', '', '1', '安卓开发', '#ef4136', '1627455615', '1627460244');
INSERT INTO `swx_auth_admin` VALUES ('12', '龙**', '111c2ee005e6834ac71bf9b3ddd30b8a', '龙**', '/admin/images/default.jpg', '0', '', '1', 'CTO', '#1b315e', '1627455672', '1627460248');

-- ----------------------------
-- Table structure for swx_auth_admin_action
-- ----------------------------
DROP TABLE IF EXISTS `swx_auth_admin_action`;
CREATE TABLE `swx_auth_admin_action` (
  `id` bigint(13) NOT NULL AUTO_INCREMENT,
  `admin` int(11) DEFAULT NULL COMMENT '管理员ID',
  `url` varchar(64) DEFAULT NULL COMMENT '控制器-方法',
  `msg` varchar(255) DEFAULT NULL COMMENT '日志说明',
  `param` text COMMENT '请求内容',
  `ip` varchar(32) DEFAULT NULL COMMENT '请求IP',
  `create_time` int(10) DEFAULT NULL COMMENT '新增时间',
  `update_time` int(10) DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`),
  KEY `admin` (`admin`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=276 DEFAULT CHARSET=utf8mb4 COMMENT='AUTH - 管理员 - 操作日志表';

-- ----------------------------
-- Records of swx_auth_admin_action
-- ----------------------------

-- ----------------------------
-- Table structure for swx_auth_admin_login
-- ----------------------------
DROP TABLE IF EXISTS `swx_auth_admin_login`;
CREATE TABLE `swx_auth_admin_login` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `admin` int(11) DEFAULT NULL COMMENT '管理员ID',
  `ip` varchar(32) DEFAULT NULL COMMENT 'IP',
  `province` varchar(32) DEFAULT NULL COMMENT '省',
  `city` varchar(32) DEFAULT NULL COMMENT '市',
  `area` varchar(32) DEFAULT NULL COMMENT '区',
  `create_time` int(19) DEFAULT NULL COMMENT '登录时间',
  PRIMARY KEY (`id`),
  KEY `admin` (`admin`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=174 DEFAULT CHARSET=utf8mb4 COMMENT='AUTH - 管理员 - 登录日志表';

-- ----------------------------
-- Records of swx_auth_admin_login
-- ----------------------------

-- ----------------------------
-- Table structure for swx_auth_admin_menu
-- ----------------------------
DROP TABLE IF EXISTS `swx_auth_admin_menu`;
CREATE TABLE `swx_auth_admin_menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `admin` int(11) DEFAULT NULL COMMENT '管理ID',
  `menu_list` text COMMENT '权限id',
  `create_time` int(10) DEFAULT NULL COMMENT '新增时间',
  `update_time` int(10) DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`),
  KEY `admin` (`admin`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='AUTH - 管理员 - 独立权限';

-- ----------------------------
-- Records of swx_auth_admin_menu
-- ----------------------------

-- ----------------------------
-- Table structure for swx_auth_menu
-- ----------------------------
DROP TABLE IF EXISTS `swx_auth_menu`;
CREATE TABLE `swx_auth_menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `pid` int(11) DEFAULT '0' COMMENT '父id',
  `name` varchar(64) DEFAULT NULL COMMENT '菜单名称',
  `controller` varchar(64) DEFAULT NULL COMMENT '控制器名称',
  `action` varchar(128) DEFAULT NULL COMMENT '方法名称',
  `status` tinyint(1) DEFAULT '1' COMMENT '状态 0|1 关闭|开启',
  `icon` varchar(32) DEFAULT NULL COMMENT 'ICON 图标',
  `sort` int(11) DEFAULT '0' COMMENT '排序',
  `create_time` int(10) DEFAULT NULL COMMENT '新增时间',
  `update_time` int(10) DEFAULT NULL COMMENT '修改时间',
  `display` int(1) DEFAULT '1' COMMENT '是否在菜单显示 0|1 否|是',
  `public` int(1) DEFAULT '0' COMMENT '是否公共权限 0|1 否|是',
  `path` varchar(32) DEFAULT NULL COMMENT '完整路径',
  `level` tinyint(1) DEFAULT '1' COMMENT '等级',
  `is_franchise` tinyint(1) DEFAULT '0' COMMENT '是否加盟商有效 0.否 1.是',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=181 DEFAULT CHARSET=utf8mb4 COMMENT='AUTH - 权限菜单';

-- ----------------------------
-- Records of swx_auth_menu
-- ----------------------------
INSERT INTO `swx_auth_menu` VALUES ('10', '0', '主页', 'index', 'index', '1', 'home', '0', '1557716671', '1557716671', '1', '1', '10', '1', '1');
INSERT INTO `swx_auth_menu` VALUES ('11', '10', '控制台', 'index', 'main', '1', '', '0', '1557716698', '1557716698', '1', '1', '10/11', '2', '1');
INSERT INTO `swx_auth_menu` VALUES ('12', '0', '系统设置', '', '', '1', 'set', '0', '1557716737', '1557716737', '1', '0', '12', '1', '0');
INSERT INTO `swx_auth_menu` VALUES ('13', '12', '权限', '', '', '1', '', '2', '1557716778', '1582686205', '1', '0', '12/13', '2', '0');
INSERT INTO `swx_auth_menu` VALUES ('14', '13', '菜单', 'auth', 'menu_list', '1', '', '0', '1557716800', '1557718556', '1', '0', '12/13/14', '3', '0');
INSERT INTO `swx_auth_menu` VALUES ('15', '14', '新增', 'auth', 'menu_insert', '1', '', '0', '1557716835', '1557716835', '0', '0', '12/13/14/15', '4', '0');
INSERT INTO `swx_auth_menu` VALUES ('16', '14', '修改', 'auth', 'menu_update', '1', '', '0', '1557717011', '1557717011', '0', '0', '12/13/14/16', '4', '1');
INSERT INTO `swx_auth_menu` VALUES ('17', '14', '删除', 'auth', 'menu_delete', '1', '', '0', '1557717024', '1557717024', '0', '0', '12/13/14/17', '4', '1');
INSERT INTO `swx_auth_menu` VALUES ('18', '13', '角色', 'auth', 'role_list', '1', '', '0', '1557718545', '1557718637', '1', '0', '12/13/18', '3', '0');
INSERT INTO `swx_auth_menu` VALUES ('19', '18', '新增', 'auth', 'role_insert', '1', '', '0', '1557718577', '1557718577', '0', '0', '12/13/18/19', '4', '0');
INSERT INTO `swx_auth_menu` VALUES ('20', '18', '修改', 'auth', 'role_update', '1', '', '0', '1557718629', '1557718642', '0', '0', '12/13/18/20', '4', '0');
INSERT INTO `swx_auth_menu` VALUES ('21', '18', '删除', 'auth', 'role_delete', '1', '', '0', '1557718657', '1557718658', '0', '0', '12/13/18/21', '4', '0');
INSERT INTO `swx_auth_menu` VALUES ('22', '13', '管理员', 'auth', 'admin_list', '1', '', '0', '1557730762', '1557730762', '1', '0', '12/13/22', '3', '0');
INSERT INTO `swx_auth_menu` VALUES ('23', '22', '新增', 'auth', 'admin_insert', '1', '', '0', '1557730784', '1557730784', '0', '0', '12/13/22/23', '4', '0');
INSERT INTO `swx_auth_menu` VALUES ('24', '22', '修改', 'auth', 'admin_update', '1', '', '0', '1557730795', '1557730795', '0', '0', '12/13/22/24', '4', '0');
INSERT INTO `swx_auth_menu` VALUES ('25', '22', '删除', 'auth', 'admin_delete', '1', '', '0', '1557730811', '1557730811', '0', '0', '12/13/22/25', '4', '0');
INSERT INTO `swx_auth_menu` VALUES ('26', '22', '独立权限', 'auth', 'admin_menu', '1', '', '0', '1557730830', '1557730830', '0', '0', '12/13/22/26', '4', '0');
INSERT INTO `swx_auth_menu` VALUES ('27', '18', '权限设置', 'auth', 'role_menu', '1', '', '0', '1557798353', '1557798353', '0', '0', '12/13/18/27', '4', '0');
INSERT INTO `swx_auth_menu` VALUES ('28', '22', '登录日志', 'auth', 'admin_login_log', '1', '', '0', '1557800490', '1557800496', '0', '0', '12/13/22/28', '4', '0');
INSERT INTO `swx_auth_menu` VALUES ('29', '22', '操作日志', 'auth', 'admin_action_log', '1', '', '0', '1557800518', '1557800832', '0', '0', '12/13/22/29', '4', '0');
INSERT INTO `swx_auth_menu` VALUES ('30', '29', '删除', 'auth', 'admin_login_delete', '1', '', '0', '1557801483', '1557801483', '0', '0', '12/13/22/29/30', '5', '0');
INSERT INTO `swx_auth_menu` VALUES ('31', '28', '删除', 'auth', 'admin_action_delete', '1', '', '0', '1557801497', '1557801498', '0', '0', '12/13/22/28/31', '5', '0');
INSERT INTO `swx_auth_menu` VALUES ('32', '10', '修改密码', 'auth', 'admin_pwd', '1', '', '0', '1557803756', '1557803756', '0', '1', '10/32', '2', '1');
INSERT INTO `swx_auth_menu` VALUES ('161', '10', '修改头像', 'auth', 'admin_logo', '1', '', '0', '1627355401', null, '0', '1', '10/161', '2', '0');
INSERT INTO `swx_auth_menu` VALUES ('162', '10', '图片上传', 'auth', 'images', '1', '', '0', '1627355997', null, '0', '1', '10/162', '2', '0');
INSERT INTO `swx_auth_menu` VALUES ('163', '0', '项目', 'item', '', '1', 'senior', '0', '1627356592', null, '1', '0', '163', '1', '0');
INSERT INTO `swx_auth_menu` VALUES ('164', '163', '列表', 'item', 'index', '1', '', '0', '1627356653', null, '1', '0', '163/164', '2', '0');
INSERT INTO `swx_auth_menu` VALUES ('165', '164', '新增', 'item', 'insert', '1', '', '0', '1627356684', null, '0', '0', '163/164/165', '3', '0');
INSERT INTO `swx_auth_menu` VALUES ('166', '164', '删除', 'item', 'delete', '1', '', '0', '1627356692', null, '0', '0', '163/164/166', '3', '0');
INSERT INTO `swx_auth_menu` VALUES ('167', '164', '修改', 'item', 'update', '1', '', '0', '1627356703', null, '0', '0', '163/164/167', '3', '0');
INSERT INTO `swx_auth_menu` VALUES ('168', '0', '版本', 'edition', '', '1', 'component', '0', '1627365360', null, '1', '0', '168', '1', '0');
INSERT INTO `swx_auth_menu` VALUES ('169', '168', '列表', 'edition', 'index', '1', '', '0', '1627365371', null, '1', '0', '168/169', '2', '0');
INSERT INTO `swx_auth_menu` VALUES ('170', '169', '新增', 'edition', 'insert', '1', '', '0', '1627365380', null, '0', '0', '168/169/170', '3', '0');
INSERT INTO `swx_auth_menu` VALUES ('171', '169', '删除', 'edition', 'delete', '1', '', '0', '1627365389', null, '0', '0', '168/169/171', '3', '0');
INSERT INTO `swx_auth_menu` VALUES ('172', '169', '修改', 'edition', 'update', '1', '', '0', '1627365398', null, '0', '0', '168/169/172', '3', '0');
INSERT INTO `swx_auth_menu` VALUES ('173', '0', '任务', 'task', '', '1', 'template', '0', '1627372167', null, '1', '0', '173', '1', '0');
INSERT INTO `swx_auth_menu` VALUES ('174', '173', '列表', 'task', 'index', '1', '', '0', '1627372179', null, '1', '0', '173/174', '2', '0');
INSERT INTO `swx_auth_menu` VALUES ('175', '174', '新增', 'task', 'insert', '1', '', '0', '1627372189', null, '0', '0', '173/174/175', '3', '0');
INSERT INTO `swx_auth_menu` VALUES ('176', '174', '删除', 'task', 'delete', '1', '', '0', '1627372202', null, '0', '0', '173/174/176', '3', '0');
INSERT INTO `swx_auth_menu` VALUES ('177', '174', '修改', 'task', 'update', '1', '', '0', '1627372212', null, '0', '0', '173/174/177', '3', '0');
INSERT INTO `swx_auth_menu` VALUES ('178', '174', '查询对应版本号', 'task', 'get_edition', '1', '', '0', '1627440331', null, '0', '1', '173/174/178', '3', '0');
INSERT INTO `swx_auth_menu` VALUES ('179', '10', '修改任务状态', 'index', 'check', '1', '', '0', '1627470666', null, '0', '1', '10/179', '2', '0');
INSERT INTO `swx_auth_menu` VALUES ('180', '10', '未完成统计', 'index', 'tongji', '1', '', '0', '1627472238', null, '1', '0', '10/180', '2', '0');
INSERT INTO `swx_auth_menu` VALUES ('181', '10', '已完成统计', 'index', 'tongji2', '1', '', '0', '1627472238', null, '1', '0', '10/181', '2', '0');
INSERT INTO `swx_auth_menu` VALUES ('182', '0', '用例', 'test', '', '1', 'component', '0', '1627955147', null, '1', '0', '182', '1', '0');
INSERT INTO `swx_auth_menu` VALUES ('183', '182', 'UI', 'test', 'ui_index', '1', '', '0', '1627956070', null, '1', '0', '182/183', '2', '0');
INSERT INTO `swx_auth_menu` VALUES ('184', '183', '新增', 'test', 'ui_insert', '1', '', '0', '1627956083', null, '0', '0', '182/183/184', '3', '0');
INSERT INTO `swx_auth_menu` VALUES ('185', '183', '删除', 'test', 'ui_delete', '1', '', '0', '1627956097', null, '0', '0', '182/183/185', '3', '0');
INSERT INTO `swx_auth_menu` VALUES ('186', '183', '修改', 'test', 'ui_update', '1', '', '0', '1627956112', null, '0', '0', '182/183/186', '3', '0');
INSERT INTO `swx_auth_menu` VALUES ('187', '182', '场景', 'test', 'scene_index', '1', '', '0', '1627956158', null, '1', '0', '182/187', '2', '0');
INSERT INTO `swx_auth_menu` VALUES ('188', '187', '新增', 'test', 'scene_insert', '1', '', '0', '1627956170', null, '0', '0', '182/187/188', '3', '0');
INSERT INTO `swx_auth_menu` VALUES ('189', '187', '删除', 'test', 'scene_delete', '1', '', '0', '1627956180', null, '0', '0', '182/187/189', '3', '0');
INSERT INTO `swx_auth_menu` VALUES ('190', '187', '修改', 'test', 'scene_update', '1', '', '0', '1627956192', null, '0', '0', '182/187/190', '3', '0');
INSERT INTO `swx_auth_menu` VALUES ('191', '10', '提交评论', 'index', 'comment_submit', '1', '', '0', '1628157236', null, '0', '1', '10/191', '2', '0');
INSERT INTO `swx_auth_menu` VALUES ('192', '10', '评论查询', 'index', 'comment_list', '1', '', '0', '1628157267', null, '0', '1', '10/192', '2', '0');

-- ----------------------------
-- Table structure for swx_auth_role
-- ----------------------------
DROP TABLE IF EXISTS `swx_auth_role`;
CREATE TABLE `swx_auth_role` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(64) DEFAULT NULL COMMENT '角色名称',
  `status` tinyint(1) DEFAULT '1' COMMENT '状态 0|1 关闭|开启',
  `menu_list` text COMMENT '权限列表，用逗号分隔',
  `create_time` int(10) DEFAULT NULL COMMENT '新增时间',
  `update_time` int(10) DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COMMENT='AUTH - 角色';

-- ----------------------------
-- Records of swx_auth_role
-- ----------------------------
INSERT INTO `swx_auth_role` VALUES ('4', '前端', '1', '180,181', '1557726285', '1628161984');
INSERT INTO `swx_auth_role` VALUES ('7', '任务分配人员', '1', '180,181,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,182,183,184,185,186,187,188,189,190', '1628152046', '1628152059');
INSERT INTO `swx_auth_role` VALUES ('8', '后端', '1', '180,181', '1628161993', '1628162017');
INSERT INTO `swx_auth_role` VALUES ('9', '运维', '1', '180,181', '1628162058', '1628162064');

-- Table structure for swx_comment
-- ----------------------------
DROP TABLE IF EXISTS `swx_comment`;
CREATE TABLE `swx_comment` (
  `id` bigint(13) NOT NULL AUTO_INCREMENT,
  `admin_id` int(11) DEFAULT NULL,
  `task_id` bigint(13) DEFAULT NULL,
  `content` varchar(2048) DEFAULT NULL,
  `create_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COMMENT='任务项评论表';

-- ----------------------------
-- Table structure for swx_edition
-- ----------------------------
DROP TABLE IF EXISTS `swx_edition`;
CREATE TABLE `swx_edition` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) DEFAULT NULL COMMENT '项目ID',
  `code` varchar(64) DEFAULT NULL COMMENT '版本号',
  `explain` mediumtext COMMENT '说明',
  `status` tinyint(1) DEFAULT '1' COMMENT '看系统函数',
  `start_time` int(11) DEFAULT NULL COMMENT '开始开发时间',
  `final_start_time` int(11) DEFAULT NULL COMMENT '真实时间',
  `start_des` text COMMENT '推迟原因',
  `test_time` int(11) DEFAULT NULL COMMENT '测试开始时间',
  `final_test_time` int(11) DEFAULT NULL,
  `test_des` text COMMENT '推迟原因',
  `publish_time` int(11) DEFAULT NULL COMMENT '预计发布时间',
  `final_publish_time` int(11) DEFAULT NULL,
  `publish_des` text COMMENT '推迟原因',
  `create_time` int(11) DEFAULT NULL,
  `update_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8 COMMENT='版本';

-- ----------------------------
-- Records of swx_edition
-- ----------------------------
INSERT INTO `swx_edition` VALUES ('27', '4', 'v1.0.1', '测试', '1', '1625068800', '1625155200', '1625328000', '1625241600', '1626192000', '1626278400', '1627460301', null);
INSERT INTO `swx_edition` VALUES ('28', '4', 'v1.0.2', '', '1', '1627401600', '1627488000', '1627574400', '1627660800', '1627660800', '1627574400', '1627460350', null);

-- ----------------------------
-- Table structure for swx_item
-- ----------------------------
DROP TABLE IF EXISTS `swx_item`;
CREATE TABLE `swx_item` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(32) DEFAULT NULL COMMENT '名称',
  `admin_id` int(11) DEFAULT NULL COMMENT '负责人',
  `content` text COMMENT '描述',
  `logo` varchar(255) DEFAULT NULL COMMENT 'LOGO',
  `status` tinyint(1) DEFAULT '1' COMMENT '状态 0|1 关闭|开启',
  `create_time` int(11) DEFAULT NULL,
  `update_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='项目';

-- ----------------------------
-- Records of swx_item
-- ----------------------------
INSERT INTO `swx_item` VALUES ('4', '滴滴出行', '1', '全国领先的快车出行品牌', '/uploads/20210729/1627552221_1003317178.png', '1', '1627456478', '1627552222');
INSERT INTO `swx_item` VALUES ('5', '测试项目', '2', '测试项目', '/uploads/20210729/1627552162_19233780.jpg', '1', '1627456573', '1627552163');
INSERT INTO `swx_item` VALUES ('6', '超级商城', '1', '为XX会员，提供积分兑换服务', '/uploads/20210728/1627456669_1670296052.jpg', '1', '1627456669', '1627551928');

-- ----------------------------
-- Table structure for swx_task
-- ----------------------------
DROP TABLE IF EXISTS `swx_task`;
CREATE TABLE `swx_task` (
  `id` bigint(13) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) DEFAULT NULL COMMENT '项目ID',
  `edition_id` int(11) DEFAULT NULL COMMENT '版本ID',
  `task_title` varchar(255) DEFAULT NULL COMMENT '任务标题',
  `des` text COMMENT '描述',
  `create_time` int(11) DEFAULT NULL,
  `update_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COMMENT='任务树';

-- ----------------------------
-- Records of swx_task
-- ----------------------------
INSERT INTO `swx_task` VALUES ('10', '4', '28', 'sort 方法，以便对数字、非数字及混合类等所有内容的排序进行支持', '', '1627460383', null);
INSERT INTO `swx_task` VALUES ('11', '4', '28', 'table 组件的 escape 参数，用于是否开启 xss 字符过滤（默认 false）', '', '1627460402', null);
INSERT INTO `swx_task` VALUES ('12', '4', '27', '开发开发开发开发开发开发开发开发开发开发', '', '1627460423', null);
INSERT INTO `swx_task` VALUES ('13', '4', '27', '测试测试测试测试测试测试测试测试测试测试', '', '1627460576', null);

-- ----------------------------
-- Table structure for swx_task_user
-- ----------------------------
DROP TABLE IF EXISTS `swx_task_user`;
CREATE TABLE `swx_task_user` (
  `id` bigint(13) NOT NULL AUTO_INCREMENT,
  `task_id` bigint(13) DEFAULT NULL COMMENT '任务ID',
  `admin_id` int(11) DEFAULT NULL COMMENT '负责人',
  `start_time` int(11) DEFAULT NULL COMMENT '预计开始时间',
  `final_start_time` int(11) DEFAULT NULL,
  `end_time` int(11) DEFAULT NULL COMMENT '预计结束时间',
  `final_end_time` int(11) DEFAULT NULL COMMENT '实际结束时间',
  `duty` text COMMENT '负责内容',
  `status` tinyint(1) DEFAULT '1' COMMENT '状态参数系统函数',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8 COMMENT='任务树-负责人';

-- ----------------------------
-- Records of swx_task_user
-- ----------------------------
INSERT INTO `swx_task_user` VALUES ('9', '10', '1', '1627401600', '1627471161', '1627557275', '1627471167', '', '1');
INSERT INTO `swx_task_user` VALUES ('10', '10', '2', '1627401600', null, null, null, '', '1');
INSERT INTO `swx_task_user` VALUES ('11', '11', '6', null, null, null, null, '', '1');
INSERT INTO `swx_task_user` VALUES ('12', '11', '7', null, null, null, null, '', '1');
INSERT INTO `swx_task_user` VALUES ('13', '12', '5', null, null, null, null, '', '1');
INSERT INTO `swx_task_user` VALUES ('14', '12', '9', null, null, null, null, '', '1');
INSERT INTO `swx_task_user` VALUES ('15', '13', '1', null, '1627471163', '1627471167', '1627471168', '', '1');
INSERT INTO `swx_task_user` VALUES ('16', '13', '8', null, null, null, null, '', '1');
INSERT INTO `swx_task_user` VALUES ('17', '10', '1', '1627401600', '1627471161', '1627557275', '1627471167', '', '1');


-- ----------------------------
-- Table structure for swx_test_scene
-- ----------------------------
DROP TABLE IF EXISTS `swx_test_scene`;
CREATE TABLE `swx_test_scene` (
  `id` bigint(13) NOT NULL AUTO_INCREMENT,
  `admin_id` int(11) DEFAULT NULL,
  `item_id` bigint(13) DEFAULT NULL COMMENT '项目ID',
  `edition_id` bigint(13) DEFAULT NULL COMMENT '版本ID',
  `test_title` varchar(255) DEFAULT NULL COMMENT '功能模块',
  `create_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COMMENT='用例 - 场景';

-- ----------------------------
-- Records of swx_test_scene
-- ----------------------------

-- ----------------------------
-- Table structure for swx_test_scene_data
-- ----------------------------
DROP TABLE IF EXISTS `swx_test_scene_data`;
CREATE TABLE `swx_test_scene_data` (
  `id` bigint(13) NOT NULL AUTO_INCREMENT,
  `pid` bigint(13) DEFAULT NULL COMMENT '主表ID',
  `level_id` tinyint(3) DEFAULT NULL COMMENT '重要等级，参考系统函数',
  `scene_title` varchar(255) DEFAULT NULL COMMENT '场景标题',
  `action` text COMMENT '操作步骤',
  `expect` text COMMENT '预期结果',
  `actual` text COMMENT '实际结果',
  `test_result` tinyint(1) DEFAULT '0' COMMENT '测试环境结果 0.未开始 1.进行中 2.不通过  3.通过',
  `env_result` tinyint(1) DEFAULT NULL COMMENT '生产环境结果 0.未开始 1.进行中 2.不通过  3.通过',
  `remark` varchar(1024) DEFAULT NULL COMMENT '备注',
  `bug` varchar(1024) DEFAULT NULL COMMENT '缺陷说明',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='用例 - 场景 - 附表';

-- ----------------------------
-- Records of swx_test_scene_data
-- ----------------------------

-- ----------------------------
-- Table structure for swx_test_ui
-- ----------------------------
DROP TABLE IF EXISTS `swx_test_ui`;
CREATE TABLE `swx_test_ui` (
  `id` bigint(13) NOT NULL AUTO_INCREMENT,
  `admin_id` int(11) DEFAULT NULL,
  `item_id` bigint(13) DEFAULT NULL COMMENT '项目ID',
  `edition_id` bigint(13) DEFAULT NULL COMMENT '版本ID',
  `test_title` varchar(255) DEFAULT NULL COMMENT '功能模块',
  `create_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COMMENT='用例 - UI';

-- ----------------------------
-- Records of swx_test_ui
-- ----------------------------

-- ----------------------------
-- Table structure for swx_test_ui_data
-- ----------------------------
DROP TABLE IF EXISTS `swx_test_ui_data`;
CREATE TABLE `swx_test_ui_data` (
  `id` bigint(13) NOT NULL AUTO_INCREMENT,
  `pid` bigint(13) DEFAULT NULL COMMENT '主表ID',
  `level_id` tinyint(3) DEFAULT NULL COMMENT '重要等级，参考系统函数',
  `ui_title` varchar(255) DEFAULT NULL COMMENT '测试点',
  `front_ask` varchar(1024) DEFAULT NULL COMMENT '前置要求',
  `action` text COMMENT '操作步骤',
  `expect` text COMMENT '预期结果',
  `test_result` tinyint(1) DEFAULT '0' COMMENT '测试环境结果 0.未开始 1.进行中 2.不通过  3.通过',
  `env_result` tinyint(1) DEFAULT NULL COMMENT '生产环境结果 0.未开始 1.进行中 2.不通过  3.通过',
  `remark` varchar(1024) DEFAULT NULL COMMENT '备注',
  `bug` varchar(1024) DEFAULT NULL COMMENT '缺陷说明',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COMMENT='用例 - UI - 附表';

-- ----------------------------
-- Records of swx_test_ui_data
-- ----------------------------
