CREATE TABLE tasks(
id INT PRIMARY KEY auto_increment COMMENT 'primary key',
project_id INT COMMENT 'project_id',
issue_id INT COMMENT 'issue id',
task_id INT COMMENT 'task id',
status INT COMMENT 'status',
version INT COMMENT 'version',
title VARCHAR(1024) COMMENT 'Title',
description TEXT COMMENT 'description',
deadline DATETIME COMMENT 'deadline',
progress INT COMMENT 'progress',
estimate INT COMMENT 'estimate of cost time',
cost INT COMMENT 'fact cost time',
insert_time DATETIME COMMENT 'create datetime',
insert_user INT COMMENT 'create user',
update_time DATETIME COMMENT 'update datetime',
update_user INT COMMENT 'update user'
)  type=InnoDB, COMMENT = 'Tasks'
;

