1.0.0.sql
6.14 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
CREATE TABLE `collaboration`.`TSK_TASK_HISTORY` (
`ID` BIGINT(20) NOT NULL COMMENT '主键',
`TENANT_ID` BIGINT(20) DEFAULT NULL COMMENT '承租人ID',
`TASK_ID` BIGINT(20) DEFAULT NULL COMMENT '任务ID',
`BEFORE_OBJECT_NAME` VARCHAR(100) DEFAULT NULL COMMENT '编辑前任务名称',
`BEFORE_OBJECT_DESCRIPTION` VARCHAR(100) DEFAULT NULL COMMENT '编辑前任务内容',
`AFTER_OBJECT_NAME` VARCHAR(100) DEFAULT NULL COMMENT '编辑后任务名称',
`AFTER_OBJECT_DESCRIPTION` VARCHAR(100) DEFAULT NULL COMMENT '编辑后任务内容',
`SAVE_TIME` DATETIME DEFAULT NULL COMMENT '保存时间',
`SAVE_USER_ID` BIGINT(20) DEFAULT NULL COMMENT '用户ID',
`SAVE_USER_NAME` VARCHAR(100) DEFAULT NULL COMMENT '用户姓名',
`BEFORE_START_TIME` DATETIME DEFAULT NULL COMMENT '编辑前开始时间',
`BEFORE_END_TIME` DATETIME DEFAULT NULL COMMENT '编辑前结束时间',
`AFTER_START_TIME` DATETIME DEFAULT NULL COMMENT '编辑后开始时间',
`AFTER_END_TIME` DATETIME DEFAULT NULL COMMENT '编辑后结束时间',
`ATTRIBUTE1` VARCHAR(500) DEFAULT NULL COMMENT '扩展栏位1',
`ATTRIBUTE2` VARCHAR(500) DEFAULT NULL COMMENT '扩展栏位2',
`ATTRIBUTE3` VARCHAR(500) DEFAULT NULL COMMENT '扩展栏位3',
`ATTRIBUTE4` VARCHAR(500) DEFAULT NULL COMMENT '扩展栏位4',
`ATTRIBUTE5` VARCHAR(500) DEFAULT NULL COMMENT '扩展栏位5',
`ATTRIBUTE6` VARCHAR(500) DEFAULT NULL COMMENT '扩展栏位6',
`ATTRIBUTE7` VARCHAR(500) DEFAULT NULL COMMENT '扩展栏位7',
`ATTRIBUTE8` VARCHAR(500) DEFAULT NULL COMMENT '扩展栏位8',
`ATTRIBUTE9` VARCHAR(500) DEFAULT NULL COMMENT '扩展栏位9',
`ATTRIBUTE10` VARCHAR(500) DEFAULT NULL COMMENT '扩展栏位10',
`ROW_VERSION` BIGINT(20) DEFAULT NULL COMMENT '行版本',
`IS_DELETED` TINYINT(1) DEFAULT NULL COMMENT '是否已删除',
`CREATED_BY` BIGINT(20) NOT NULL COMMENT '创建用户',
`CREATION_TIME` DATETIME NOT NULL COMMENT '创建时间',
`LAST_UPDATED_BY` BIGINT(20) DEFAULT NULL COMMENT '最后更新用户',
`LAST_UPDATE_TIME` DATETIME DEFAULT NULL COMMENT '最后更新时间',
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='任务编辑历史';
ALTER TABLE `collaboration`.`tsk_task`
ADD COLUMN `BEGIN_TIME` DATETIME NULL COMMENT '开始时间' AFTER `DEADLINE_DATE`,
ADD COLUMN `END_TIME` DATETIME NULL COMMENT '结束时间' AFTER `BEGIN_TIME`;
ALTER TABLE `collaboration`.`tsk_task_list`
ADD COLUMN `IS_TOP` TINYINT(1) NULL COMMENT '置顶' AFTER `TENANT_ID`,
ADD COLUMN `TOP_INDEX` INTEGER NULL COMMENT '排序' AFTER `IS_TOP`;
ALTER TABLE `collaboration`.`tsk_task`
ADD COLUMN `IS_ABORT` TINYINT(1) NULL COMMENT '是否终止' AFTER `TENANT_ID`,
ADD COLUMN `ABORT_USER_ID` BIGINT(20) NULL COMMENT '终止用户id' AFTER `IS_ABORT`,
ADD COLUMN `ABORT_USER_NAME` VARCHAR(20) NULL COMMENT '终止用户名称' AFTER `ABORT_USER_ID`,
ADD COLUMN `ABORT_TIME` DATETIME NULL COMMENT '终止时间' AFTER `ABORT_USER_NAME`,
ADD COLUMN `ABORT_REASON` VARCHAR(500) NULL COMMENT '终止原因' AFTER `ABORT_TIME`,
ADD COLUMN `IS_DELAY` TINYINT(1) NULL COMMENT '是否延期' AFTER `ABORT_REASON`,
ADD COLUMN `DELAY_USER_ID` BIGINT(20) NULL COMMENT '延期用户id' AFTER `IS_DELAY`,
ADD COLUMN `DELAY_USER_NAME` VARCHAR(20) NULL COMMENT '延期用户名称' AFTER `DELAY_USER_ID`,
ADD COLUMN `DELAY_TIME` DATETIME NULL COMMENT '延期时间' AFTER `DELAY_USER_NAME`,
ADD COLUMN `DELAY_REASON` VARCHAR(500) NULL COMMENT '延期原因' AFTER `DELAY_TIME`,
ADD COLUMN `IS_OVER_DUE` TINYINT(1) NULL COMMENT '是否逾期' AFTER `DELAY_REASON`,
ADD COLUMN `DONE_MESSAGE` VARCHAR(500) NULL COMMENT '完成信息' AFTER `DO_TIME`
;
ALTER TABLE `collaboration`.`tsk_task_user`
ADD COLUMN `IS_TOP` TINYINT(1) NULL COMMENT '置顶' AFTER `TENANT_ID`,
ADD COLUMN `TOP_INDEX` INTEGER NULL COMMENT '排序' AFTER `IS_TOP`,
ADD COLUMN `USER_ROLE` VARCHAR(20) NULL COMMENT '用户类型' AFTER `TOP_INDEX`,
ADD COLUMN `HISTORY_COUNT` INTEGER NULL COMMENT '未读历史修改记录数' AFTER `USER_ROLE`,
ADD COLUMN `COMMENT_COUNT` INTEGER NULL COMMENT '未读进展数量数' AFTER `HISTORY_COUNT`,
ADD COLUMN `LAST_DYNAMIC_TIME` DATETIME NULL COMMENT '最后动态时间' AFTER `COMMENT_COUNT`
;
INSERT INTO `collaboration`.`tsk_task_list` (`ID`, `TENANT_ID`, `IS_TOP`, `TOP_INDEX`, `OBJECT_TYPE`, `OBJECT_ID`, `OWNER_USER_ID`, `OBJECT_NAME`, `OBJECT_DESCRIPTION`, `ATTRIBUTE1`, `ATTRIBUTE2`, `ATTRIBUTE3`, `ATTRIBUTE4`, `ATTRIBUTE5`, `ATTRIBUTE6`, `ATTRIBUTE7`, `ATTRIBUTE8`, `ATTRIBUTE9`, `ATTRIBUTE10`, `ROW_VERSION`, `IS_DELETED`, `CREATED_BY`, `CREATION_TIME`, `LAST_UPDATED_BY`, `LAST_UPDATE_TIME`)
VALUES
(0, '0', NULL, NULL, 'SYSTEM', 0, NULL, '完成任务组','完成任务组-系统任务组' , NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', '0', '532768031404068864', '2017-01-10 20:02:45', NULL, NULL);
INSERT INTO `collaboration`.`tsk_task_list` (`ID`, `TENANT_ID`, `IS_TOP`, `TOP_INDEX`, `OBJECT_TYPE`, `OBJECT_ID`, `OWNER_USER_ID`, `OBJECT_NAME`, `OBJECT_DESCRIPTION`, `ATTRIBUTE1`, `ATTRIBUTE2`, `ATTRIBUTE3`, `ATTRIBUTE4`, `ATTRIBUTE5`, `ATTRIBUTE6`, `ATTRIBUTE7`, `ATTRIBUTE8`, `ATTRIBUTE9`, `ATTRIBUTE10`, `ROW_VERSION`, `IS_DELETED`, `CREATED_BY`, `CREATION_TIME`, `LAST_UPDATED_BY`, `LAST_UPDATE_TIME`)
VALUES
(1, '0', NULL, NULL, 'SYSTEM', 1, NULL, '终止任务组', '终止任务组-系统任务组', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', '0', '532832407502852096', '2017-01-11 09:37:32', NULL, NULL);
INSERT INTO `collaboration`.`tsk_task_list` (`ID`, `TENANT_ID`, `IS_TOP`, `TOP_INDEX`, `OBJECT_TYPE`, `OBJECT_ID`, `OWNER_USER_ID`, `OBJECT_NAME`, `OBJECT_DESCRIPTION`, `ATTRIBUTE1`, `ATTRIBUTE2`, `ATTRIBUTE3`, `ATTRIBUTE4`, `ATTRIBUTE5`, `ATTRIBUTE6`, `ATTRIBUTE7`, `ATTRIBUTE8`, `ATTRIBUTE9`, `ATTRIBUTE10`, `ROW_VERSION`, `IS_DELETED`, `CREATED_BY`, `CREATION_TIME`, `LAST_UPDATED_BY`, `LAST_UPDATE_TIME`)
VALUES
(2, '0', NULL, NULL, 'SYSTEM', 2, NULL, '逾期任务组', '逾期任务组-系统任务组', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', '0', '532768031404068864', '2017-01-13 14:15:23', NULL, NULL);