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 '審核狀態(tài)',

`recommend` int(11) DEFAULT '0' NOT NULL comment '智能推薦',

`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時間',

?`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新時間',

? ?PRIMARY KEY (book_classification_id)

)ENGINE=InnoDB DEFAULT CHARSET=utf8 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 '點擊數(shù)',

`praise_len` int(11) DEFAULT 0 NOT NULL comment '點贊數(shù)',

`examine_state` varchar(16) DEFAULT '已通過' NOT NULL comment '審核狀態(tài)',

`recommend` int(11) DEFAULT '0' NOT NULL comment '智能推薦',

`goods_id` int(11) DEFAULT '0' NOT NULL comment '關聯(lián)商品ID',

`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時間',

?`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新時間',

? ?PRIMARY KEY (books_id)

)ENGINE=InnoDB DEFAULT CHARSET=utf8 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 '購買數(shù)量',

`total_price` varchar(64) comment '總價格',

`receiving_address` varchar(64) comment '收貨地址',

`contact_number` varchar(64) comment '聯(lián)系電話',

`consignee_name_` varchar(64) comment '收貨人姓名',

`purchase_user` int(11) DEFAULT 0 comment '購買用戶',

`examine_state` varchar(16) DEFAULT '未審核' NOT NULL comment '審核狀態(tài)',

`recommend` int(11) DEFAULT '0' NOT NULL comment '智能推薦',

`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時間',

?`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新時間',

? ?PRIMARY KEY (book_order_id)

)ENGINE=InnoDB DEFAULT CHARSET=utf8 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 '審核狀態(tài)',

`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 '創(chuàng)建時間',

?`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 '創(chuàng)建時間：',

? `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 '點贊狀態(tài):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 '創(chuàng)建時間：',

? `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`;