/*
 Navicat Premium Data Transfer

 Source Server         : book
 Source Server Type    : MySQL
 Source Server Version : 80019
 Source Host           : localhost:3306
 Source Schema         : testbook

 Target Server Type    : MySQL
 Target Server Version : 80019
 File Encoding         : 65001

 Date: 18/12/2022 22:58:25
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin`  (
  `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `realname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`username`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of admin
-- ----------------------------
INSERT INTO `admin` VALUES ('20130213', '200299', '名字');
INSERT INTO `admin` VALUES ('用户名2', '密码', '名字');

-- ----------------------------
-- Table structure for book
-- ----------------------------
DROP TABLE IF EXISTS `book`;
CREATE TABLE `book`  (
  `book_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `publisher` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `author` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `page` int NOT NULL,
  `date` date NOT NULL,
  `price` double(10, 2) NOT NULL,
  `quantity` int NOT NULL,
  `image` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `detail` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`book_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of book
-- ----------------------------
INSERT INTO `book` VALUES ('1', '计算机', 'On Java123', '人民邮电出版社', '布鲁斯·埃克尔', 150, '2002-05-14', 64.90, 98, '1.png', 'Thinkingin作者BruceEckel新作，重讲Java的编程思想，基于Java8、11、17，配套视频讲解与导读指南！');
INSERT INTO `book` VALUES ('10', '人文社科', '玩乐高 学物理 乐高积木与粒子物理学', '哈尔滨工业大学出版社', '本·斯蒂尔', 154, '2004-07-23', 80.00, 138, '10.png', '用乐高积木趣解物质世界，从独特的视角认识各种基本粒子，一本书带你更好的理解宇宙！中科院高能物理研究所张双南教授作序、刘红薇博士专业审读');
INSERT INTO `book` VALUES ('11', '人文社科', '相对论 狭义与广义理论（发表100周年纪念版）', '哈尔滨工业大学出版社', '阿尔伯特·爱因斯坦', 74, '1922-06-30', 55.00, 34, '11.png', '提供了爱因斯坦部分手稿，私人信函以及相对论各语种版本出版背景，是表述狭义和广义相对论中zui清晰的读本之一');
INSERT INTO `book` VALUES ('12', '人文社科', '生命是什么1', '哈尔滨工业大学出版社', '王立铭', 104, '2005-10-01', 60.00, 45, '12.png', '一本书带你了解生命科学');
INSERT INTO `book` VALUES ('2', '计算机', '代码整洁之道', '人民邮电出版社', '罗伯特·C', 200, '2001-07-05', 84.50, 150, '2.png', '鲍勃大叔作品，程序员，汇聚编程数十年编程生涯的心得体会，阐释如何解决软件开发人员、项目经理及软件项目领导们所面临的棘手的问题;');
INSERT INTO `book` VALUES ('3', '计算机', 'c++prime', '人民邮电出版社', '小明', 100, '2002-10-14', 10.10, 130, '1.jpg', 'c++图书');
INSERT INTO `book` VALUES ('4', '金融', '期货交易从入门到精通', '清华大学出版社', '拉塞尔·沃森道夫', 150, '1995-07-21', 69.00, 740, '4.png', '知乎金融专栏作家翻译注疏，详解交易细节与常识，谷物，金属，能源等市场基本面分析，技术面分析，期货期权交易，跨式组合交易，价差交易，对冲交易升级策略');
INSERT INTO `book` VALUES ('5', '金融', '东方财富炒股软件从入门到精通', '清华大学出版社', '龙马金融研究中心 ', 210, '2010-11-18', 81.00, 450, '5.png', '从零开始学炒股，炒股从入门到精通，含新沪港通操作指南190招赢利技巧，详解从零开始K线炒股，透彻解析股票基础知识和股市利好行情，一本书读懂股票交易规则');
INSERT INTO `book` VALUES ('6', '金融', '从零开始学炒股：股票入门与实战（全彩图解版）第2版', '清华大学出版社', '马涛', 155, '2014-05-30', 49.60, 255, '6.png', '股票炒股书籍，全彩图解入门级投资理财读本，3大股票投资实战8大炒股技巧分析10余年炒股实战经验总结280多张图片全称图解，让投资不再盲从！');
INSERT INTO `book` VALUES ('7', '儿童读物', '勇闯山海经 全4册', '人民邮电出版社', '常青藤爸爸', 215, '2000-01-01', 173.90, 10, '7.png', '给5~12岁孩子看的山海经漫画故事启蒙读物，配套图鉴拉页，赠送20节国学启蒙视频课课外阅读书，儿童文学科普彩色图书');
INSERT INTO `book` VALUES ('8', '儿童读物', '小小神仙系列 第一辑', '人民邮电出版社', '林晶婕', 512, '2005-07-07', 121.90, 15, '8.png', '东方神话故事精彩来袭，让儿童爱不释手的神话绘本，阅读神话绘本，学习传统文化，培养良好习惯');
INSERT INTO `book` VALUES ('9', '儿童读物', '简笔画5000例，一本就够（缤纷涂色卷）', '哈尔滨工业大学出版社', '涂涂猫 ', 135, '2010-06-03', 52.00, 14, '9.png', '简笔画');

-- ----------------------------
-- Table structure for delivery
-- ----------------------------
DROP TABLE IF EXISTS `delivery`;
CREATE TABLE `delivery`  (
  `order_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `location` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `user_verify` tinyint(1) NULL DEFAULT 0,
  PRIMARY KEY (`order_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of delivery
-- ----------------------------
INSERT INTO `delivery` VALUES ('1', '所在位置', '地址', 0);
INSERT INTO `delivery` VALUES ('10138b6d5fba421190351bfbf234c15b', '仓库', '22', 0);
INSERT INTO `delivery` VALUES ('132ec97302184ec59dd0c19500b8f73a', '仓库', '22', 0);
INSERT INTO `delivery` VALUES ('343d5138f4ee4438b74f7dda43ee6d58', '仓库', '22', 0);
INSERT INTO `delivery` VALUES ('435af585d40744388fa716a55bd4facc', '仓库', '22', 0);
INSERT INTO `delivery` VALUES ('4dc53883a2d845b2814ea960a6d824a1', '仓库', '地址', 0);
INSERT INTO `delivery` VALUES ('663044571f124564ac0f681eb200c720', '仓库', '地址', 0);
INSERT INTO `delivery` VALUES ('a1616cc360bb43b98e7e2099bc82d715', '仓库', '22', 0);
INSERT INTO `delivery` VALUES ('a79e06dd7a754b8c872d48b40c74790b', '仓库', '22', 0);
INSERT INTO `delivery` VALUES ('aa23f6ca3795482cb10a8be7f5fbe25c', '仓库', '22', 0);
INSERT INTO `delivery` VALUES ('de49564a4eb6473195df979386e17a52', '仓库', '333', 0);
INSERT INTO `delivery` VALUES ('f393182b8fb44a538f9e9dcde01036cb', '仓库', '22', 0);
INSERT INTO `delivery` VALUES ('f8666de2ae2641a8a7e9f7dbb7517cca', '仓库', '地址', 0);

-- ----------------------------
-- Table structure for order_book
-- ----------------------------
DROP TABLE IF EXISTS `order_book`;
CREATE TABLE `order_book`  (
  `order_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `book_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `quantity` int NOT NULL,
  `price` double(10, 2) NOT NULL,
  PRIMARY KEY (`order_id`, `book_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of order_book
-- ----------------------------
INSERT INTO `order_book` VALUES ('1', '1', 10, 10.20);
INSERT INTO `order_book` VALUES ('10138b6d5fba421190351bfbf234c15b', '1', 1, 64.90);
INSERT INTO `order_book` VALUES ('132ec97302184ec59dd0c19500b8f73a', '10', 1, 80.00);
INSERT INTO `order_book` VALUES ('16570eec6ffd4f30a487369c9769acf8', '3', 4, 40.40);
INSERT INTO `order_book` VALUES ('16570eec6ffd4f30a487369c9769acf8', '4', 2, 30.20);
INSERT INTO `order_book` VALUES ('16570eec6ffd4f30a487369c9769acf8', '45', 1, 53.00);
INSERT INTO `order_book` VALUES ('343d5138f4ee4438b74f7dda43ee6d58', '1', 2, 129.80);
INSERT INTO `order_book` VALUES ('435af585d40744388fa716a55bd4facc', '1', 1, 64.90);
INSERT INTO `order_book` VALUES ('4dc53883a2d845b2814ea960a6d824a1', '10', 1, 80.00);
INSERT INTO `order_book` VALUES ('663044571f124564ac0f681eb200c720', '1', 2, 129.80);
INSERT INTO `order_book` VALUES ('663044571f124564ac0f681eb200c720', '10', 1, 80.00);
INSERT INTO `order_book` VALUES ('a1616cc360bb43b98e7e2099bc82d715', '10', 1, 80.00);
INSERT INTO `order_book` VALUES ('a79e06dd7a754b8c872d48b40c74790b', '10', 1, 80.00);
INSERT INTO `order_book` VALUES ('aa23f6ca3795482cb10a8be7f5fbe25c', '10', 1, 80.00);
INSERT INTO `order_book` VALUES ('de49564a4eb6473195df979386e17a52', '3', 1, 10.10);
INSERT INTO `order_book` VALUES ('de49564a4eb6473195df979386e17a52', '45', 1, 53.00);
INSERT INTO `order_book` VALUES ('f393182b8fb44a538f9e9dcde01036cb', '1', 1, 64.90);
INSERT INTO `order_book` VALUES ('f8666de2ae2641a8a7e9f7dbb7517cca', '10', 1, 80.00);
INSERT INTO `order_book` VALUES ('f8666de2ae2641a8a7e9f7dbb7517cca', '11', 1, 55.00);

-- ----------------------------
-- Table structure for orders
-- ----------------------------
DROP TABLE IF EXISTS `orders`;
CREATE TABLE `orders`  (
  `order_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `price` double(10, 2) NOT NULL,
  `DateTime` datetime(0) NOT NULL,
  `admin_verify` tinyint(1) NULL DEFAULT 0,
  `user_verify` tinyint(1) NULL DEFAULT 0,
  PRIMARY KEY (`order_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of orders
-- ----------------------------
INSERT INTO `orders` VALUES ('1', '用户名', 10.00, '2002-10-14 19:20:15', 0, 0);
INSERT INTO `orders` VALUES ('10138b6d5fba421190351bfbf234c15b', '333', 64.90, '2022-12-06 20:35:14', 0, 0);
INSERT INTO `orders` VALUES ('132ec97302184ec59dd0c19500b8f73a', '333', 80.00, '2022-12-06 20:11:21', 0, 0);
INSERT INTO `orders` VALUES ('16570eec6ffd4f30a487369c9769acf8', '333', 123.60, '2022-12-06 13:38:25', 0, 0);
INSERT INTO `orders` VALUES ('343d5138f4ee4438b74f7dda43ee6d58', '333', 129.80, '2022-12-06 20:35:23', 0, 0);
INSERT INTO `orders` VALUES ('435af585d40744388fa716a55bd4facc', '333', 64.90, '2022-12-06 19:52:10', 0, 0);
INSERT INTO `orders` VALUES ('4dc53883a2d845b2814ea960a6d824a1', '123', 80.00, '2022-12-09 09:27:04', 0, 0);
INSERT INTO `orders` VALUES ('663044571f124564ac0f681eb200c720', '456', 209.80, '2022-12-09 09:53:42', 0, 0);
INSERT INTO `orders` VALUES ('a1616cc360bb43b98e7e2099bc82d715', '333', 80.00, '2022-12-06 19:27:48', 0, 0);
INSERT INTO `orders` VALUES ('a79e06dd7a754b8c872d48b40c74790b', '333', 80.00, '2022-12-06 19:44:33', 0, 0);
INSERT INTO `orders` VALUES ('aa23f6ca3795482cb10a8be7f5fbe25c', '333', 80.00, '2022-12-06 19:59:29', 0, 0);
INSERT INTO `orders` VALUES ('de49564a4eb6473195df979386e17a52', '333', 63.10, '2022-12-06 15:19:42', 0, 0);
INSERT INTO `orders` VALUES ('f393182b8fb44a538f9e9dcde01036cb', '333', 64.90, '2022-12-06 19:59:05', 0, 0);
INSERT INTO `orders` VALUES ('f8666de2ae2641a8a7e9f7dbb7517cca', '123', 135.00, '2022-12-09 09:27:16', 0, 0);

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `realname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `mail` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`username`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('1', '名字', '123', '地址', '电话号码', '邮箱');
INSERT INTO `user` VALUES ('123', '小王', '321', '地址', '15549505587', '2714326198@qq.com');
INSERT INTO `user` VALUES ('333', 'ssss', '333', '22', '2', '2');
INSERT INTO `user` VALUES ('456', '小王', '456', '地址', '15549505587', '2714326198@qq.com');
INSERT INTO `user` VALUES ('用户名2', '名字', '密码', '地址', '电话号码', '邮箱');

SET FOREIGN_KEY_CHECKS = 1;