idoubi / sql2struct Goto Github PK

Contributors

Stargazers

Forkers

zanjs zhengchaolong hdfs010 haodreams totoleo azh18 dazhenghu yuanddqiao xluohome anoty markcheney1 zh-ang dyliu iwordz lixunguan 1486327116 pennkao arieslee leonardleonard drownedman jiyis byteh sniperzj lzqmyb dzhcool xuchunhua-com xserve98 erichen86 halibut735 1178947261 yzqfjxm meetbetter reacher-gua lwqmyself vvvvvw sjatsh yianz xshnjau sjw1357 gonwalk leaf-rain alexgee2046 nihility981 alswl ywqwancbx coderchiang netfly-vpn csuqiyuan 2niuhe chu108 qiujiafei bluesfu lqszsd qauzy huajunhuang hexin12 miaogaolin tangximing banna2019 lbd2013 daihy8759 melodyjerry hexergogo mike5522718 cheyunhua billbliu jackzing sinchie liqingju123 924963465 aglowhy lilinxi edgarseu theonelee qianshuinixing guanyanliang leeonsoft weichangdong kcersing 609412635 xiaohei7529 python95plus q-meet zz-demo math-chao fenglingdu16 sh7ning-mirror alex86w waltcow maxmilia coollinuxman ruanun varluffy kokizzu showsmall xujiabin02 djun coderi421 see792 ccc469

create table dpi_bookinfo_test.book_info
(
	id bigint auto_increment
		primary key,
	name varchar(255) default '' not null comment '书名',
	author varchar(32) default '' not null comment '作者',
	tag varchar(64) default '' not null comment '标签',
	cover varchar(1024) default '' not null comment '封面',
	multi_cover tinyint(1) default 0 not null,
	status int default 1 not null comment '0完结,1连载中',
	introduction text null comment '简介',
	source varchar(32) default '' not null comment '来源',
	link varchar(512) default '' not null comment '连接地址',
	score double default 0 not null,
	read_user_num int default 0 not null,
	last_chapter varchar(1024) default '' not null,
	last_update varchar(64) default '' not null,
	words int default 0 not null,
	md5 varchar(64) default '' not null,
	create_time datetime default CURRENT_TIMESTAMP not null comment '创建时间',
	update_time datetime default CURRENT_TIMESTAMP not null on update CURRENT_TIMESTAMP,
	constraint book_info_name_author_uindex
		unique (name, author)
)
comment '书籍信息';

create index book_info_md5_index
	on dpi_bookinfo_test.book_info (md5);