init.sql 477 B

12345678910111213
  1. drop table if exists `t_simple`;
  2. create table `t_simple`
  3. (
  4. id int auto_increment comment 'id',
  5. name varchar(50) comment '姓名',
  6. age int comment '年龄',
  7. delete_flag tinyint(1) comment '删除标识1',
  8. deleted tinyint(1) comment '删除标识2',
  9. version bigint comment '版本',
  10. create_time datetime comment '创建时间',
  11. update_time datetime comment '更新时间',
  12. primary key (id)
  13. ) COMMENT = '测试表';