text: /*
  Navicat MySQL Data Transfer
  
  Source Server         : mysql8.0
  Source Server Version : 80020
  Source Host           : localhost:3306
  Source Database       : test
  
  Target Server Type    : MYSQL
  Target Server Version : 80020
  File Encoding         : 65001
  
  Date: 2020-12-17 12:55:38
  */
  
  SET FOREIGN_KEY_CHECKS=0;
  
  -- ----------------------------
  -- Table structure for admin_user
  -- ----------------------------
  DROP TABLE IF EXISTS `admin_user`;
  CREATE TABLE `admin_user` (
    `id` int NOT NULL AUTO_INCREMENT,
    `password` varchar(255) DEFAULT NULL,
    `username` varchar(255) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Table structure for classification
  -- ----------------------------
  DROP TABLE IF EXISTS `classification`;
  CREATE TABLE `classification` (
    `id` int NOT NULL AUTO_INCREMENT,
    `cname` varchar(255) DEFAULT NULL,
    `parent_id` int DEFAULT NULL,
    `type` int DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Table structure for order
  -- ----------------------------
  DROP TABLE IF EXISTS `order`;
  CREATE TABLE `order` (
    `id` int NOT NULL AUTO_INCREMENT,
    `addr` varchar(255) DEFAULT NULL,
    `name` varchar(255) DEFAULT NULL,
    `order_time` datetime DEFAULT NULL,
    `phone` varchar(255) DEFAULT NULL,
    `state` int DEFAULT NULL,
    `total` double DEFAULT NULL,
    `user_id` int DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Table structure for order_item
  -- ----------------------------
  DROP TABLE IF EXISTS `order_item`;
  CREATE TABLE `order_item` (
    `id` int NOT NULL AUTO_INCREMENT,
    `count` int DEFAULT NULL,
    `order_id` int DEFAULT NULL,
    `product_id` int DEFAULT NULL,
    `sub_total` double DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Table structure for product
  -- ----------------------------
  DROP TABLE IF EXISTS `product`;
  CREATE TABLE `product` (
    `id` int NOT NULL AUTO_INCREMENT,
    `csid` int DEFAULT NULL,
    `desc` varchar(1000) DEFAULT NULL,
    `image` varchar(255) DEFAULT NULL,
    `is_hot` int DEFAULT NULL,
    `market_price` double DEFAULT NULL,
    `pdate` datetime DEFAULT NULL,
    `shop_price` bigint DEFAULT NULL,
    `title` varchar(255) DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Table structure for user
  -- ----------------------------
  DROP TABLE IF EXISTS `user`;
  CREATE TABLE `user` (
    `id` int NOT NULL AUTO_INCREMENT,
    `addr` varchar(255) DEFAULT NULL,
    `email` varchar(255) DEFAULT NULL,
    `name` varchar(255) DEFAULT NULL,
    `password` varchar(255) DEFAULT NULL,
    `phone` varchar(255) DEFAULT NULL,
    `username` varchar(255) DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
  