DROP TABLE IF EXISTS book_classification;
CREATE TABLE book_classification(
book_classification_id int(11) NOT NULL AUTO_INCREMENT COMMENT '图书分类ID',
book_category varchar(64) comment '图书类别',
examine_state varchar(16) DEFAULT '已通过' NOT NULL comment '审核状态',
recommend int(11) DEFAULT '0' NOT NULL comment '智能推荐',
create_time datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
update_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
DROP TABLE IF EXISTS books;
CREATE TABLE books(
books_id int(11) NOT NULL AUTO_INCREMENT COMMENT '图书ID',
cover varchar(255) comment '封面',
book_number varchar(64) comment '图书编号',
book_category varchar(64) comment '图书类别',
book_name varchar(64) comment '图书名称',
publication_date date comment '出版日期',
author varchar(64) comment '作者',
book_introduction longtext comment '图书介绍',
price varchar(64) comment '价格',
stock varchar(64) comment '库存',
hits int(11) DEFAULT 0 NOT NULL comment '点击数',
praise_len int(11) DEFAULT 0 NOT NULL comment '点赞数',
examine_state varchar(16) DEFAULT '已通过' NOT NULL comment '审核状态',
recommend int(11) DEFAULT '0' NOT NULL comment '智能推荐',
goods_id int(11) DEFAULT '0' NOT NULL comment '关联商品ID',
create_time datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
update_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
DROP TABLE IF EXISTS book_order;
CREATE TABLE book_order(
book_order_id int(11) NOT NULL AUTO_INCREMENT COMMENT '图书订单ID',
order_number varchar(64) comment '订单号',
book_number varchar(64) comment '图书编号',
book_name varchar(64) comment '图书名称',
price varchar(64) comment '价格',
purchase_quantity varchar(64) comment '购买数量',
total_price varchar(64) comment '总价格',
receiving_address varchar(64) comment '收货地址',
contact_number varchar(64) comment '联系电话',
consignee_name_ varchar(64) comment '收货人姓名',
purchase_user int(11) DEFAULT 0 comment '购买用户',
examine_state varchar(16) DEFAULT '未审核' NOT NULL comment '审核状态',
recommend int(11) DEFAULT '0' NOT NULL comment '智能推荐',
create_time datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
update_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
DROP TABLE IF EXISTS mall_users;
CREATE TABLE mall_users(
mall_users_id int(11) NOT NULL AUTO_INCREMENT COMMENT '商城用户ID',
remarks varchar(64) comment '备注',
examine_state varchar(16) DEFAULT '已通过' NOT NULL comment '审核状态',
recommend int(11) DEFAULT '0' NOT NULL comment '智能推荐',
user_id int(11) DEFAULT '0' NOT NULL comment '用户ID',
create_time datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
update_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
CREATE TABLE praise (
praise_id int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '点赞ID：',
user_id int(11) unsigned NOT NULL DEFAULT '0' COMMENT '点赞人：',
create_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间：',
update_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间：',
source_table varchar(255) DEFAULT NULL COMMENT '来源表：',
source_field varchar(255) DEFAULT NULL COMMENT '来源字段：',
source_id int(10) unsigned NOT NULL DEFAULT '0' COMMENT '来源ID：',
status tinyint(1) NOT NULL DEFAULT '1' COMMENT '点赞状态:1为点赞，0已取消',
PRIMARY KEY (praise_id) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='点赞：';
insert into praise values ('2','1',"2021-02-22 07:10:59.000 ","2021-03-02 10:24:03.000 ",'article','article_id','7','1');
insert into praise values ('25','5',"2021-03-04 10:26:08.000 ","2021-03-04 10:26:08.000 ",'article','article_id','9','1');
insert into praise values ('26','5',"2021-03-04 10:26:16.000 ","2021-03-04 10:26:16.000 ",'article','article_id','7','1');
insert into praise values ('27','5',"2021-03-04 10:26:20.000 ","2021-03-04 10:26:20.000 ",'article','article_id','7','1');
insert into praise values ('44','2',"2021-03-06 02:54:26.000 ","2021-03-06 02:54:26.000 ",'forum','forum_id','2','1');
insert into praise values ('50','2',"2021-03-06 03:06:58.000 ","2021-03-06 03:06:58.000 ",'forum','forum_id','2','1');
insert into praise values ('54','2',"2021-03-10 03:42:50.000 ","2021-03-10 03:42:50.000 ",'article','article_id','9','1');
insert into praise values ('57','0',"2021-03-12 13:00:17.000 ","2021-03-12 13:00:17.000 ",'article','article_id','10','1');
insert into praise values ('86','0',"2021-03-15 09:46:34.000 ","2021-03-15 09:46:34.000 ",'article','article_id','6','1');
insert into praise values ('101','7',"2021-03-16 04:19:29.000 ","2021-03-16 04:19:29.000 ",'article','article_id','7','1');
insert into praise values ('108','2',"2021-03-17 01:45:38.000 ","2021-03-17 01:45:38.000 ",'article','article_id','8','1');
insert into praise values ('221','0',"2021-04-02 09:41:16.000 ","2021-04-02 09:41:16.000 ",'article','article_id','2','1');
DROP TABLE IF EXISTS score;
CREATE TABLE score (
score_id int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '评分ID：',
user_id int(11) unsigned NOT NULL DEFAULT '0' COMMENT '评分人：',
nickname varchar(64) DEFAULT NULL COMMENT '昵称：',
score_num double(5,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '评分：',
create_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间：',
update_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间：',
source_table varchar(255) DEFAULT NULL COMMENT '来源表：',
source_field varchar(255) DEFAULT NULL COMMENT '来源字段：',
source_id int(10) unsigned NOT NULL DEFAULT '0' COMMENT '来源ID：',
PRIMARY KEY (score_id) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='评分：';
insert into score values ('1','0',null,'5',"2021-02-22 06:55:05.000 ","2021-02-24 02:06:47.000 ",'article','article_id','6');
insert into score values ('2','0',null,'3',"2021-02-22 06:55:14.000 ","2021-02-24 02:05:58.000 ",'article','article_id','6');
insert into score values ('3','0',null,'3.5',"2021-02-22 06:55:27.000 ","2021-02-22 06:55:29.000 ",'news','news_id','1');
insert into score values ('4','0',null,'100',"2021-02-22 06:55:45.000 ","2021-02-22 06:55:45.000 ",'news','news_id','2');
DROP TABLE IF EXISTS slides;
