create table `project`
(
id int unsigned primary key not null auto_increment,
company_id int unsigned not null,
code varchar(100) comment '编号',
name varchar(100) not null comment '名称',
enabled boolean comment '是否启用',
creator_id int unsigned,
creator_name varchar(100),
create_time datetime,
updater_id int unsigned,
updater_name varchar(100),
update_time datetime
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='项目';