MAVEN项目 SSM

drop table CommonTASK; drop table Task_ATTACHMENT; drop table TASK_SUBTASK_RELASHIONSHIP; CREATE TABLE CommonTASK ( taskID VARCHAR(36) NOT NULL, taskName VARCHAR(100) NULL, taskSource VARCHAR(2) NULL, taskAssigneeID VARCHAR(36) NULL, candidateGroup VARCHAR(36) NULL, taskPromoterID VARCHAR(36) NULL, taskStatus VARCHAR(2) NULL, taskPlanStartTime TIMESTAMP NULL, taskPlanEndTime TIMESTAMP NULL, taskActualStartTime TIMESTAMP NULL, taskActualEndTime TIMESTAMP NULL, taskMemo TEXT NULL, taskDeptID VARCHAR(36) NULL, isRootTask VARCHAR(2) NULL, isCurActiveNode VARCHAR(2) NULL, taskType VARCHAR(2) NULL, taskContent TEXT NULL, taskPriority VARCHAR(2) NULL, taskLink VARCHAR(200) NULL, isNeedApprove VARCHAR(2) NULL, taskCreateTime TIMESTAMP NULL ); CREATE TABLE Task_ATTACHMENT ( attachId VARCHAR(36) NOT NULL, uploadTime TIMESTAMP NULL, attachFileName VARCHAR(300) NULL, attachFileContent LONGBLOB Null, attachType VARCHAR(20) NULL, taskID VARCHAR(36) NULL ); CREATE TABLE TASK_SUBTASK_RELASHIONSHIP ( ID VARCHAR(36) NOT NULL, taskID VARCHAR(36) NULL, prevSubtaskID VARCHAR(36) NULL, nextSubtaskID VARCHAR(36) NULL, curIndex int not null, subtaskMemo TEXT NULL, subTaskID VARCHAR(36) NULL, subtaskRelationship VARCHAR(2) NULL, isNeedApprove VARCHAR(2) NULL );