CREATE TABLE project(
id INT PRIMARY KEY auto_increment COMMENT 'primary key',
name VARCHAR(384) COMMENT 'project name',
status INT COMMENT 'status',
description VARCHAR(4096) COMMENT 'description',
enabled INT COMMENT 'enabled flag',
start_date DATETIME COMMENT 'start date',
end_date DATETIME COMMENT 'end date',
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 = 'Project definition'
;

INSERT INTO project ( id, name, status, description, enabled, start_date, end_date, insert_time, insert_user, update_time, update_user ) VALUES (1,'Project Name',1,'Project Description',1,NOW(),NOW(),NOW(),null,NOW(),null)
;
