document.sql 434 B

1234567891011121314
  1. create table `project`
  2. (
  3. id int unsigned primary key not null auto_increment,
  4. company_id int unsigned not null,
  5. code varchar(100) comment '编号',
  6. name varchar(100) not null comment '名称',
  7. enabled boolean comment '是否启用',
  8. creator_id int unsigned,
  9. creator_name varchar(100),
  10. create_time datetime,
  11. updater_id int unsigned,
  12. updater_name varchar(100),
  13. update_time datetime
  14. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='项目';