/*
Navicat MySQL Data Transfer
Source Server : 本地开发虚拟机master数据库
Source Server Version : 50721
Source Host : 192.168.199.151:3306
Source Database : nbcio-boot
Target Server Type : MYSQL
Target Server Version : 50721
File Encoding : 65001
Date: 2023-06-13 09:08:58
*/
SET FOREIGN_KEY_CHECKS=0;
— —————————-
— Table structure for tw_account
— —————————-
DROP TABLE IF EXISTS `tw_account`;
CREATE TABLE `tw_account` (
`id` varchar(36) NOT NULL COMMENT ‘主键’,
`user_id` varchar(36) DEFAULT NULL COMMENT ‘所属账号’,
`organization_id` varchar(36) DEFAULT NULL COMMENT ‘组织ID’,
`is_owner` int(10) DEFAULT ‘0’ COMMENT ‘是否主账号’,
`name` varchar(100) DEFAULT NULL COMMENT ‘姓名’,
`email` varchar(100) DEFAULT NULL COMMENT ‘邮件’,
`status` int(11) DEFAULT NULL COMMENT ‘状态’,
`create_by` varchar(50) DEFAULT NULL COMMENT ‘创建人’,
`create_time` datetime DEFAULT NULL COMMENT ‘创建日期’,
`update_by` varchar(50) DEFAULT NULL COMMENT ‘更新人’,
`update_time` datetime DEFAULT NULL COMMENT ‘更新日期’,
`sys_org_code` varchar(64) DEFAULT NULL COMMENT ‘所属部门’,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
— —————————-
— Records of tw_account
— —————————-
INSERT INTO `tw_account` VALUES (‘1667794610372911105’, ‘admin’, ‘1667794608753909762’, ‘1’, ‘管理员’, ‘jeecg@163.com’, ‘1’, ‘admin’, ‘2023-06-11 15:23:16’, null, null, ‘A02’);
INSERT INTO `tw_account` VALUES (‘1667799000899035137’, ‘zhangsan’, ‘1667794608753909762’, ‘0’, ‘张三’, null, ‘1’, ‘admin’, ‘2023-06-11 15:40:43’, null, null, ‘A02’);
— —————————-
— Table structure for tw_organization
— —————————-
DROP TABLE IF EXISTS `tw_organization`;
CREATE TABLE `tw_organization` (
`id` varchar(36) NOT NULL,
`name` varchar(200) DEFAULT NULL COMMENT ‘名称’,
`avatar` varchar(255) DEFAULT NULL COMMENT ‘头像’,
`owner_id` varchar(36) DEFAULT NULL COMMENT ‘拥有者’,
`personal` int(11) DEFAULT NULL COMMENT ‘是否个人项目’,
`address` varchar(100) DEFAULT NULL COMMENT ‘地址’,
`description` varchar(200) DEFAULT NULL COMMENT ‘描述’,
`create_by` varchar(50) DEFAULT NULL COMMENT ‘创建人’,
`create_time` datetime DEFAULT NULL COMMENT ‘创建日期’,
`update_by` varchar(50) DEFAULT NULL COMMENT ‘更新人’,
`update_time` datetime DEFAULT NULL COMMENT ‘更新日期’,
`sys_org_code` varchar(64) DEFAULT NULL COMMENT ‘所属部门’,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
— —————————-
— Records of tw_organization
— —————————-
INSERT INTO `tw_organization` VALUES (‘1667794608753909762’, ‘admin个人项目’, null, null, null, null, null, ‘admin’, ‘2023-06-11 15:23:15’, null, null, ‘A02’);
— —————————-
— Table structure for tw_project
— —————————-
DROP TABLE IF EXISTS `tw_project`;
CREATE TABLE `tw_project` (
`id` varchar(36) NOT NULL COMMENT ‘主键’,
`name` varchar(100) DEFAULT NULL COMMENT ‘名称’,
`cover` varchar(200) DEFAULT NULL COMMENT ‘封面’,
`access_control_type` varchar(32) DEFAULT NULL COMMENT ‘控制类型’,
`white_list` varchar(200) DEFAULT NULL COMMENT ‘白名单’,
`sort` int(11) DEFAULT NULL COMMENT ‘排序’,
`deleted` int(10) DEFAULT ‘0’ COMMENT ‘删除标志’,
`template_id` varchar(36) DEFAULT NULL COMMENT ‘项目模板’,
`schedule` double(10,0) DEFAULT ‘0’ COMMENT ‘进度’,
`organization_id` varchar(36) DEFAULT NULL COMMENT ‘组织编码’,
`deleted_time` datetime DEFAULT NULL COMMENT ‘删除时间’,
`privated` int(10) DEFAULT ‘1’ COMMENT ‘是否私有’,
`prefix` varchar(10) DEFAULT NULL COMMENT ‘项目前缀’,
`open_prefix` int(10) DEFAULT ‘0’ COMMENT ‘是否开启项目前缀’,
`archive` int(10) DEFAULT ‘0’ COMMENT ‘是否归档’,
`archive_time` datetime DEFAULT NULL COMMENT ‘归档时间’,
`open_begin_time` int(10) DEFAULT ‘0’ COMMENT ‘是否开启任务开始时间’,
`open_task_private` int(10) DEFAULT ‘0’ COMMENT ‘是否开启新任务默认开启隐私模式’,
`task_board_theme` varchar(250) DEFAULT NULL COMMENT ‘看板风格’,
`begin_time` datetime DEFAULT NULL COMMENT ‘项目开始日期’,
`end_time` datetime DEFAULT NULL COMMENT ‘项目截止日期’,
`auto_update_schedule` int(10) DEFAULT ‘0’ COMMENT ‘自动更新项目进度’,
`create_by` varchar(50) DEFAULT NULL COMMENT ‘创建人’,
`create_time` datetime DEFAULT NULL COMMENT ‘创建日期’,
`update_by` varchar(50) DEFAULT NULL COMMENT ‘更新人’,
`update_time` datetime DEFAULT NULL COMMENT ‘更新日期’,
`sys_org_code` varchar(64) DEFAULT NULL COMMENT ‘所属部门’,
`collected` int(10) DEFAULT ‘0’ COMMENT ‘是否收藏’,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
— —————————-
— Records of tw_project
— —————————-
INSERT INTO `tw_project` VALUES (‘1667800984918073345’, ‘我的项目’, null, null, null, null, ‘0’, ‘1667794765205643266’, ‘0’, ‘1667794608753909762’, ‘2023-06-11 15:51:14’, ‘1’, null, ‘0’, ‘0’, null, ‘0’, ‘0’, null, null, null, ‘0’, ‘admin’, ‘2023-06-11 15:48:36’, null, null, ‘A02’, ‘0’);
INSERT INTO `tw_project` VALUES (‘1668066435828867074’, ‘我的项目2’, null, null, null, null, ‘0’, ‘1667794765205643266’, ‘0’, ‘1667794608753909762’, null, ‘1’, null, ‘0’, ‘0’, null, ‘0’, ‘0’, null, null, null, ‘0’, ‘admin’, ‘2023-06-12 09:23:24’, null, null, ‘A02’, ‘0’);
INSERT INTO `tw_project` VALUES (‘1668066473615351810’, ‘我的项目3’, null, null, null, null, ‘0’, ‘1667794765205643266’, ‘0’, ‘1667794608753909762’, null, ‘1’, null, ‘0’, ‘0’, null, ‘0’, ‘0’, null, null, null, ‘0’, ‘admin’, ‘2023-06-12 09:23:33’, null, null, ‘A02’, ‘0’);
INSERT INTO `tw_project` VALUES (‘1668066514937634818’, ‘我的项目4’, null, null, null, null, ‘0’, ‘1667794765205643266’, ‘0’, ‘1667794608753909762’, null, ‘1’, null, ‘0’, ‘0’, null, ‘0’, ‘0’, null, null, null, ‘0’, ‘admin’, ‘2023-06-12 09:23:43’, null, null, ‘A02’, ‘0’);
INSERT INTO `tw_project` VALUES (‘1668066557883113473’, ‘我的项目5’, null, null, null, null, ‘0’, ‘1667794765205643266’, ‘0’, ‘1667794608753909762’, null, ‘1’, null, ‘0’, ‘0’, null, ‘0’, ‘0’, null, null, null, ‘0’, ‘admin’, ‘2023-06-12 09:23:53’, null, null, ‘A02’, ‘0’);
INSERT INTO `tw_project` VALUES (‘1668066594637799426’, ‘我的项目6’, null, null, null, null, ‘0’, ‘1667794765205643266’, ‘0’, ‘1667794608753909762’, null, ‘1’, null, ‘0’, ‘0’, null, ‘0’, ‘0’, null, null, null, ‘0’, ‘admin’, ‘2023-06-12 09:24:02’, null, null, ‘A02’, ‘0’);
INSERT INTO `tw_project` VALUES (‘1668066629186281473’, ‘我的项目7’, null, null, null, null, ‘0’, ‘1667794765205643266’, ‘0’, ‘1667794608753909762’, null, ‘1’, null, ‘0’, ‘0’, null, ‘0’, ‘0’, null, null, null, ‘0’, ‘admin’, ‘2023-06-12 09:24:10’, null, null, ‘A02’, ‘0’);
INSERT INTO `tw_project` VALUES (‘1668066683938725890’, ‘我的项目8’, null, null, null, null, ‘0’, ‘1667794765205643266’, ‘0’, ‘1667794608753909762’, null, ‘1’, null, ‘0’, ‘0’, null, ‘0’, ‘0’, null, null, null, ‘0’, ‘admin’, ‘2023-06-12 09:24:23’, null, null, ‘A02’, ‘0’);
INSERT INTO `tw_project` VALUES (‘1668066721326751745’, ‘我的项目9’, null, null, null, null, ‘0’, ‘1667794765205643266’, ‘0’, ‘1667794608753909762’, null, ‘1’, null, ‘0’, ‘0’, null, ‘0’, ‘0’, null, null, null, ‘0’, ‘admin’, ‘2023-06-12 09:24:32’, null, null, ‘A02’, ‘0’);
INSERT INTO `tw_project` VALUES (‘1668066765236920322’, ‘我的项目10’, null, null, null, null, ‘0’, ‘1667794765205643266’, ‘0’, ‘1667794608753909762’, null, ‘1’, null, ‘0’, ‘0’, null, ‘0’, ‘0’, null, null, null, ‘0’, ‘admin’, ‘2023-06-12 09:24:43’, null, null, ‘A02’, ‘0’);
INSERT INTO `tw_project` VALUES (‘1668066835055304705’, ‘我的项目11’, null, null, null, null, ‘1’, ‘1667794765205643266’, ‘0’, ‘1667794608753909762’, ‘2023-06-13 09:07:24’, ‘1’, null, ‘0’, ‘0’, null, ‘0’, ‘0’, null, null, null, ‘0’, ‘admin’, ‘2023-06-12 09:24:59’, null, null, ‘A02’, ‘0’);
— —————————-
— Table structure for tw_project_collect
— —————————-
DROP TABLE IF EXISTS `tw_project_collect`;
CREATE TABLE `tw_project_collect` (
`id` varchar(36) NOT NULL COMMENT ‘主键’,
`project_id` varchar(36) DEFAULT NULL COMMENT ‘项目ID’,
`user_id` varchar(36) DEFAULT NULL COMMENT ‘用户ID’,
`create_by` varchar(50) DEFAULT NULL COMMENT ‘创建人’,
`create_time` datetime DEFAULT NULL COMMENT ‘创建日期’,
`update_by` varchar(50) DEFAULT NULL COMMENT ‘更新人’,
`update_time` datetime DEFAULT NULL COMMENT ‘更新日期’,
`sys_org_code` varchar(64) DEFAULT NULL COMMENT ‘所属部门’,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
— —————————-
— Records of tw_project_collect
— —————————-
INSERT INTO `tw_project_collect` VALUES (‘1668089373294649345’, ‘1668066835055304705’, ‘admin’, ‘admin’, ‘2023-06-12 10:54:33’, null, null, ‘A02’);
INSERT INTO `tw_project_collect` VALUES (‘1668091409184645122’, ‘1668066765236920322’, ‘admin’, ‘admin’, ‘2023-06-12 11:02:38’, null, null, ‘A02’);
INSERT INTO `tw_project_collect` VALUES (‘1668091902166360065’, ‘1668066721326751745’, ‘admin’, ‘admin’, ‘2023-06-12 11:04:36’, null, null, ‘A02’);
INSERT INTO `tw_project_collect` VALUES (‘1668092748828565506’, ‘1668066629186281473’, ‘admin’, ‘admin’, ‘2023-06-12 11:07:58’, null, null, ‘A02’);
INSERT INTO `tw_project_collect` VALUES (‘1668133074150744065’, ‘1668066683938725890’, ‘admin’, ‘admin’, ‘2023-06-12 13:48:12’, null, null, ‘A02’);
INSERT INTO `tw_project_collect` VALUES (‘1668153119304105985’, ‘1668066594637799426’, ‘admin’, ‘admin’, ‘2023-06-12 15:07:51’, null, null, ‘A02’);
INSERT INTO `tw_project_collect` VALUES (‘1668162106930020353’, ‘1668066557883113473’, ‘admin’, ‘admin’, ‘2023-06-12 15:43:34’, null, null, ‘A02’);
INSERT INTO `tw_project_collect` VALUES (‘1668162290493734914’, ‘1668066514937634818’, ‘admin’, ‘admin’, ‘2023-06-12 15:44:18’, null, null, ‘A02’);
— —————————-
— Table structure for tw_project_member
— —————————-
DROP TABLE IF EXISTS `tw_project_member`;
CREATE TABLE `tw_project_member` (
`id` varchar(36) NOT NULL COMMENT ‘主键’,
`project_id` varchar(36) DEFAULT NULL COMMENT ‘项目ID’,
`user_id` varchar(36) DEFAULT NULL COMMENT ‘用户ID’,
`is_owner` int(10) DEFAULT ‘0’ COMMENT ‘拥有者’,
`create_by` varchar(50) DEFAULT NULL COMMENT ‘创建人’,
`create_time` datetime DEFAULT NULL COMMENT ‘创建日期’,
`update_by` varchar(50) DEFAULT NULL COMMENT ‘更新人’,
`update_time` datetime DEFAULT NULL COMMENT ‘更新日期’,
`sys_org_code` varchar(64) DEFAULT NULL COMMENT ‘所属部门’,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
— —————————-
— Records of tw_project_member
— —————————-
INSERT INTO `tw_project_member` VALUES (‘1667800991335358466’, ‘1667800984918073345’, ‘admin’, ‘1’, ‘admin’, ‘2023-06-11 15:48:37’, null, null, ‘A02’);
INSERT INTO `tw_project_member` VALUES (‘1668066436176994305’, ‘1668066435828867074’, ‘admin’, ‘1’, ‘admin’, ‘2023-06-12 09:23:24’, null, null, ‘A02’);
INSERT INTO `tw_project_member` VALUES (‘1668066473703432194’, ‘1668066473615351810’, ‘admin’, ‘1’, ‘admin’, ‘2023-06-12 09:23:33’, null, null, ‘A02’);
INSERT INTO `tw_project_member` VALUES (‘1668066515034103809’, ‘1668066514937634818’, ‘admin’, ‘1’, ‘admin’, ‘2023-06-12 09:23:43’, null, null, ‘A02’);
INSERT INTO `tw_project_member` VALUES (‘1668066558097022977’, ‘1668066557883113473’, ‘admin’, ‘1’, ‘admin’, ‘2023-06-12 09:23:53’, null, null, ‘A02’);
INSERT INTO `tw_project_member` VALUES (‘1668066594709102593’, ‘1668066594637799426’, ‘admin’, ‘1’, ‘admin’, ‘2023-06-12 09:24:02’, null, null, ‘A02’);
INSERT INTO `tw_project_member` VALUES (‘1668066629257584641’, ‘1668066629186281473’, ‘admin’, ‘1’, ‘admin’, ‘2023-06-12 09:24:10’, null, null, ‘A02’);
INSERT INTO `tw_project_member` VALUES (‘1668066684014223361’, ‘1668066683938725890’, ‘admin’, ‘1’, ‘admin’, ‘2023-06-12 09:24:23’, null, null, ‘A02’);
INSERT INTO `tw_project_member` VALUES (‘1668066721402249218’, ‘1668066721326751745’, ‘admin’, ‘1’, ‘admin’, ‘2023-06-12 09:24:32’, null, null, ‘A02’);
INSERT INTO `tw_project_member` VALUES (‘1668066765316612098’, ‘1668066765236920322’, ‘admin’, ‘1’, ‘admin’, ‘2023-06-12 09:24:43’, null, null, ‘A02’);
INSERT INTO `tw_project_member` VALUES (‘1668066835122413570’, ‘1668066835055304705’, ‘admin’, ‘1’, ‘admin’, ‘2023-06-12 09:24:59’, null, null, ‘A02’);
— —————————-
— Table structure for tw_project_template
— —————————-
DROP TABLE IF EXISTS `tw_project_template`;
CREATE TABLE `tw_project_template` (
`id` varchar(36) NOT NULL COMMENT ‘主键’,
`name` varchar(200) DEFAULT NULL COMMENT ‘模板名称’,
`organization_id` varchar(36) DEFAULT NULL COMMENT ‘组织编码’,
`is_system` int(10) DEFAULT NULL COMMENT ‘系统默认’,
`cover` varchar(250) DEFAULT NULL COMMENT ‘封面’,
`sort` int(11) DEFAULT NULL COMMENT ‘排序’,
`description` varchar(250) DEFAULT NULL COMMENT ‘模板说明’,
`create_by` varchar(50) DEFAULT NULL COMMENT ‘创建人’,
`create_time` datetime DEFAULT NULL COMMENT ‘创建日期’,
`update_by` varchar(50) DEFAULT NULL COMMENT ‘更新人’,
`update_time` datetime DEFAULT NULL COMMENT ‘更新日期’,
`sys_org_code` varchar(64) DEFAULT NULL COMMENT ‘所属部门’,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
— —————————-
— Records of tw_project_template
— —————————-
INSERT INTO `tw_project_template` VALUES (‘1667794765205643266’, ‘项目管理’, ‘1667794608753909762’, null, null, null, null, ‘admin’, ‘2023-06-11 15:23:53’, null, null, ‘A02’);
— —————————-
— Table structure for tw_task_stages
— —————————-
DROP TABLE IF EXISTS `tw_task_stages`;
CREATE TABLE `tw_task_stages` (
`id` varchar(36) NOT NULL COMMENT ‘主键’,
`name` varchar(200) DEFAULT NULL COMMENT ‘名称’,
`project_id` varchar(36) DEFAULT NULL COMMENT ‘项目ID’,
`sort` int(11) DEFAULT NULL COMMENT ‘排序’,
`deleted` int(10) DEFAULT ‘0’ COMMENT ‘删除标记’,
`description` varchar(255) DEFAULT NULL COMMENT ‘备注’,
`create_by` varchar(50) DEFAULT NULL COMMENT ‘创建人’,
`create_time` datetime DEFAULT NULL COMMENT ‘创建日期’,
`update_by` varchar(50) DEFAULT NULL COMMENT ‘更新人’,
`update_time` datetime DEFAULT NULL COMMENT ‘更新日期’,
`sys_org_code` varchar(64) DEFAULT NULL COMMENT ‘所属部门’,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
— —————————-
— Records of tw_task_stages
— —————————-
INSERT INTO `tw_task_stages` VALUES (‘1667800990987231233’, ‘待处理’, ‘1667800984918073345’, ‘0’, ‘0’, null, ‘admin’, ‘2023-06-11 15:48:37’, null, null, ‘A02’);
INSERT INTO `tw_task_stages` VALUES (‘1667800991041757186’, ‘进行中’, ‘1667800984918073345’, ‘1’, ‘0’, null, ‘admin’, ‘2023-06-11 15:48:37’, null, null, ‘A02’);
INSERT INTO `tw_task_stages` VALUES (‘1667800991054340097’, ‘已完成’, ‘1667800984918073345’, ‘2’, ‘0’, null, ‘admin’, ‘2023-06-11 15:48:37’, null, null, ‘A02’);
INSERT INTO `tw_task_stages` VALUES (‘1668066436118274049’, ‘待处理’, ‘1668066435828867074’, ‘0’, ‘0’, null, ‘admin’, ‘2023-06-12 09:23:24’, null, null, ‘A02’);
INSERT INTO `tw_task_stages` VALUES (‘1668066436135051266’, ‘进行中’, ‘1668066435828867074’, ‘1’, ‘0’, null, ‘admin’, ‘2023-06-12 09:23:24’, null, null, ‘A02’);
INSERT INTO `tw_task_stages` VALUES (‘1668066436151828481’, ‘已完成’, ‘1668066435828867074’, ‘2’, ‘0’, null, ‘admin’, ‘2023-06-12 09:23:24’, null, null, ‘A02’);
INSERT INTO `tw_task_stages` VALUES (‘1668066473661489154’, ‘待处理’, ‘1668066473615351810’, ‘0’, ‘0’, null, ‘admin’, ‘2023-06-12 09:23:33’, null, null, ‘A02’);
INSERT INTO `tw_task_stages` VALUES (‘1668066473669877762’, ‘进行中’, ‘1668066473615351810’, ‘1’, ‘0’, null, ‘admin’, ‘2023-06-12 09:23:33’, null, null, ‘A02’);
INSERT INTO `tw_task_stages` VALUES (‘1668066473686654977’, ‘已完成’, ‘1668066473615351810’, ‘2’, ‘0’, null, ‘admin’, ‘2023-06-12 09:23:33’, null, null, ‘A02’);
INSERT INTO `tw_task_stages` VALUES (‘1668066514975383553’, ‘待处理’, ‘1668066514937634818’, ‘0’, ‘0’, null, ‘admin’, ‘2023-06-12 09:23:43’, null, null, ‘A02’);
INSERT INTO `tw_task_stages` VALUES (‘1668066515000549378’, ‘进行中’, ‘1668066514937634818’, ‘1’, ‘0’, null, ‘admin’, ‘2023-06-12 09:23:43’, null, null, ‘A02’);
INSERT INTO `tw_task_stages` VALUES (‘1668066515017326594’, ‘已完成’, ‘1668066514937634818’, ‘2’, ‘0’, null, ‘admin’, ‘2023-06-12 09:23:43’, null, null, ‘A02’);
INSERT INTO `tw_task_stages` VALUES (‘1668066558042497026’, ‘待处理’, ‘1668066557883113473’, ‘0’, ‘0’, null, ‘admin’, ‘2023-06-12 09:23:53’, null, null, ‘A02’);
INSERT INTO `tw_task_stages` VALUES (‘1668066558063468546’, ‘进行中’, ‘1668066557883113473’, ‘1’, ‘0’, null, ‘admin’, ‘2023-06-12 09:23:53’, null, null, ‘A02’);
INSERT INTO `tw_task_stages` VALUES (‘1668066558084440066’, ‘已完成’, ‘1668066557883113473’, ‘2’, ‘0’, null, ‘admin’, ‘2023-06-12 09:23:53’, null, null, ‘A02’);
INSERT INTO `tw_task_stages` VALUES (‘1668066594667159554’, ‘待处理’, ‘1668066594637799426’, ‘0’, ‘0’, null, ‘admin’, ‘2023-06-12 09:24:02’, null, null, ‘A02’);
INSERT INTO `tw_task_stages` VALUES (‘1668066594688131074’, ‘进行中’, ‘1668066594637799426’, ‘1’, ‘0’, null, ‘admin’, ‘2023-06-12 09:24:02’, null, null, ‘A02’);
INSERT INTO `tw_task_stages` VALUES (‘1668066594700713986’, ‘已完成’, ‘1668066594637799426’, ‘2’, ‘0’, null, ‘admin’, ‘2023-06-12 09:24:02’, null, null, ‘A02’);
INSERT INTO `tw_task_stages` VALUES (‘1668066629207252993’, ‘待处理’, ‘1668066629186281473’, ‘0’, ‘0’, null, ‘admin’, ‘2023-06-12 09:24:10’, null, null, ‘A02’);
INSERT INTO `tw_task_stages` VALUES (‘1668066629232418817’, ‘进行中’, ‘1668066629186281473’, ‘1’, ‘0’, null, ‘admin’, ‘2023-06-12 09:24:10’, null, null, ‘A02’);
INSERT INTO `tw_task_stages` VALUES (‘1668066629240807425’, ‘已完成’, ‘1668066629186281473’, ‘2’, ‘0’, null, ‘admin’, ‘2023-06-12 09:24:10’, null, null, ‘A02’);
INSERT INTO `tw_task_stages` VALUES (‘1668066683972280322’, ‘待处理’, ‘1668066683938725890’, ‘0’, ‘0’, null, ‘admin’, ‘2023-06-12 09:24:23’, null, null, ‘A02’);
INSERT INTO `tw_task_stages` VALUES (‘1668066683993251842’, ‘进行中’, ‘1668066683938725890’, ‘1’, ‘0’, null, ‘admin’, ‘2023-06-12 09:24:23’, null, null, ‘A02’);
INSERT INTO `tw_task_stages` VALUES (‘1668066684005834753’, ‘已完成’, ‘1668066683938725890’, ‘2’, ‘0’, null, ‘admin’, ‘2023-06-12 09:24:23’, null, null, ‘A02’);
INSERT INTO `tw_task_stages` VALUES (‘1668066721360306178’, ‘待处理’, ‘1668066721326751745’, ‘0’, ‘0’, null, ‘admin’, ‘2023-06-12 09:24:32’, null, null, ‘A02’);
INSERT INTO `tw_task_stages` VALUES (‘1668066721381277698’, ‘进行中’, ‘1668066721326751745’, ‘1’, ‘0’, null, ‘admin’, ‘2023-06-12 09:24:32’, null, null, ‘A02’);
INSERT INTO `tw_task_stages` VALUES (‘1668066721393860610’, ‘已完成’, ‘1668066721326751745’, ‘2’, ‘0’, null, ‘admin’, ‘2023-06-12 09:24:32’, null, null, ‘A02’);
INSERT INTO `tw_task_stages` VALUES (‘1668066765262086146’, ‘待处理’, ‘1668066765236920322’, ‘0’, ‘0’, null, ‘admin’, ‘2023-06-12 09:24:43’, null, null, ‘A02’);
INSERT INTO `tw_task_stages` VALUES (‘1668066765283057665’, ‘进行中’, ‘1668066765236920322’, ‘1’, ‘0’, null, ‘admin’, ‘2023-06-12 09:24:43’, null, null, ‘A02’);
INSERT INTO `tw_task_stages` VALUES (‘1668066765304029186’, ‘已完成’, ‘1668066765236920322’, ‘2’, ‘0’, null, ‘admin’, ‘2023-06-12 09:24:43’, null, null, ‘A02’);
INSERT INTO `tw_task_stages` VALUES (‘1668066835088859138’, ‘待处理’, ‘1668066835055304705’, ‘0’, ‘0’, null, ‘admin’, ‘2023-06-12 09:24:59’, null, null, ‘A02’);
INSERT INTO `tw_task_stages` VALUES (‘1668066835097247746’, ‘进行中’, ‘1668066835055304705’, ‘1’, ‘0’, null, ‘admin’, ‘2023-06-12 09:24:59’, null, null, ‘A02’);
INSERT INTO `tw_task_stages` VALUES (‘1668066835097247747’, ‘已完成’, ‘1668066835055304705’, ‘2’, ‘0’, null, ‘admin’, ‘2023-06-12 09:24:59’, null, null, ‘A02’);
— —————————-
— Table structure for tw_task_stages_template
— —————————-
DROP TABLE IF EXISTS `tw_task_stages_template`;
CREATE TABLE `tw_task_stages_template` (
`id` varchar(36) NOT NULL,
`name` varchar(200) DEFAULT NULL COMMENT ‘名称’,
`project_template_id` varchar(36) DEFAULT NULL COMMENT ‘项目模板ID’,
`sort` int(11) DEFAULT NULL COMMENT ‘排序’,
`create_by` varchar(50) DEFAULT NULL COMMENT ‘创建人’,
`create_time` datetime DEFAULT NULL COMMENT ‘创建日期’,
`update_by` varchar(50) DEFAULT NULL COMMENT ‘更新人’,
`update_time` datetime DEFAULT NULL COMMENT ‘更新日期’,
`sys_org_code` varchar(64) DEFAULT NULL COMMENT ‘所属部门’,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
— —————————-
— Records of tw_task_stages_template
— —————————-
INSERT INTO `tw_task_stages_template` VALUES (‘1667794767084691458’, ‘待处理’, ‘1667794765205643266’, ‘0’, ‘admin’, ‘2023-06-11 15:23:53’, null, null, ‘A02’);
INSERT INTO `tw_task_stages_template` VALUES (‘1667794767088885762’, ‘进行中’, ‘1667794765205643266’, ‘0’, ‘admin’, ‘2023-06-11 15:23:53’, null, null, ‘A02’);
INSERT INTO `tw_task_stages_template` VALUES (‘1667794767093080065’, ‘已完成’, ‘1667794765205643266’, ‘0’, ‘admin’, ‘2023-06-11 15:23:53’, null, null, ‘A02’);
INSERT INTO `tw_task_stages_template` VALUES (‘1667796867344670722’, ‘我的工作项目’, ‘1667794765205643266’, ‘4’, ‘admin’, ‘2023-06-11 15:32:14’, null, null, ‘A02’);
INSERT INTO `tw_task_stages_template` VALUES (‘1668424922404597762’, ‘项目开发’, ‘1667794765205643266’, ‘4’, ‘admin’, ‘2023-06-13 09:07:54’, null, null, ‘A02’);