Spring Cloud：视频讲解编程题

# 创建数据库
CREATE DATABASE IF NOT EXISTS renda01 DEFAULT CHARACTER SET utf8;
# 选择使用数据库
USE renda01;

# 创建商品表
DROP TABLE IF EXISTS products;
CREATE TABLE products
(
    `id`          INT PRIMARY KEY AUTO_INCREMENT,
    `name`        VARCHAR(50),  # 商品名称
    `price`       DOUBLE,
    `flag`        VARCHAR(2),   # 上架状态
    `goods_desc`  VARCHAR(100), # 商品描述
    `images`      VARCHAR(400), # 商品图片
    `goods_stock` INT,          # 商品库存
    `goods_type`  VARCHAR(20)   # 商品类型
) ENGINE = INNODB AUTO_INCREMENT = 1 DEFAULT CHARSET = utf8;
INSERT INTO products
VALUES (1, 'HUAWEI P40', 5999, '1', '华为P40 5G手机 分期 麒麟990 晨曦金 8+256GB', 'https://img14.360buyimg.com/n0/jfs/t1/133822/33/8832/135985/5f4da578E7c6efde1/2cd53a53083ab2ed.jpg', 99, '1');
INSERT INTO products
VALUES (2, 'XIAOMI', 6999, '1', '小米 P40 5G手机 分期 麒麟990 晨曦金 8+256GB', 'https://img14.360buyimg.com/n0/jfs/t1/133822/33/8832/135985/5f4da578E7c6efde1/2cd53a53083ab2ed.jpg', 99, '1');
INSERT INTO products
VALUES (3, 'APPLE', 7999, '1', '苹果 P40 5G手机 分期 麒麟990 晨曦金 8+256GB', 'https://img14.360buyimg.com/n0/jfs/t1/133822/33/8832/135985/5f4da578E7c6efde1/2cd53a53083ab2ed.jpg', 99, '2');

# 创建订单表
DROP TABLE IF EXISTS orders;
CREATE TABLE orders
(
    `id`          INT PRIMARY KEY AUTO_INCREMENT,
    `flag`        VARCHAR(2),   # 订单状态（未支付、已支付、已失效、已删除）
    `create_time` DATETIME      # 创建时间
) ENGINE = INNODB AUTO_INCREMENT = 1 DEFAULT CHARSET = utf8;
INSERT INTO orders VALUES (1, '1', '2020-10-11 15:41:46');
INSERT INTO orders VALUES (2, '1', '2020-10-12 15:41:46');
INSERT INTO orders VALUES (3, '3', '2020-10-13 15:41:46');
INSERT INTO orders VALUES (4, '4', '2020-10-14 15:41:46');

# 创建订单商品中间表
DROP TABLE IF EXISTS orders_products_relation;
CREATE TABLE orders_products_relation
(
    `id`          INT PRIMARY KEY AUTO_INCREMENT,
    `order_id`    INT,   # 订单 id
    `product_id`  INT    # 商品 id
) ENGINE = INNODB AUTO_INCREMENT = 1 DEFAULT CHARSET = utf8;
INSERT INTO orders_products_relation VALUES (1, 1, 1);
INSERT INTO orders_products_relation VALUES (2, 1, 2);
INSERT INTO orders_products_relation VALUES (3, 2, 1);
INSERT INTO orders_products_relation VALUES (4, 2, 2);
INSERT INTO orders_products_relation VALUES (5, 2, 3);
INSERT INTO orders_products_relation VALUES (6, 3, 1);
INSERT INTO orders_products_relation VALUES (7, 4, 1);
INSERT INTO orders_products_relation VALUES (8, 4, 2);