12 lines
1.2 KiB
SQL
12 lines
1.2 KiB
SQL
create table chat_gpt.writer_docs (
|
|
id bigint auto_increment comment '主键' ,
|
|
create_time datetime default CURRENT_TIMESTAMP not null comment '创建时间',
|
|
update_time datetime default CURRENT_TIMESTAMP not null on update CURRENT_TIMESTAMP comment '更新时间',
|
|
user_name varchar(300) not null comment '用户名',
|
|
user_id bigint default 0 not null comment '用户id',
|
|
title varchar(250) default '' null comment '文章标题',
|
|
docs longtext charset utf8mb4 null comment '文章正文',
|
|
deleted int(1) default 0 not null comment '是否删除 0->未删除;1->已删除',
|
|
primary key (id)
|
|
) engine=innodb charset = utf8 comment = '文档撰写存储表';
|
|
commit; |