drop table if exists ebook;
create table ebook (
id bigint not null comment ‘id’,
name varchar (50) comment ‘名称’,
category1_id bigint not null comment ‘分类1’,
category2_id bigint not null comment ‘分类2’,
description varchar (200) comment ‘描述’,
cover varchar (200) comment ‘封面’,
doc_count int comment ‘文档数’,
view_count int comment ‘阅读数’,
vote_count int comment ‘点赞数’,
primary key (id)
) engine=innodb default charset=utf8mb4 comment=‘电子书’;