create database cart;
use cart;
# 商品详细
create table shop
(
    id     int          not null,
    shop   varchar(100) not null,
    detail varchar(200) not null,
    price  float        not null,
    num    int          not null

) character set = utf8;

insert into shop
values (1, 'Note 9 Pro', '一亿像素夜景相机，120Hz六档变速高刷', 3220.00, 4);
insert into shop
values (2, '品家风冷对开门冰箱', '风冷无霜不结冰 / 环绕立体出风，长久锁水保鲜', 7499.00, 12);
insert into shop
values (3, '品家手持挂烫机', '熨衣不伤衣丨除菌除螨丨轻巧便携', 152.00, 10);
insert into shop
values (4, '小米平板4 Plus', '10英寸 LTE版 4GB+128GB 黑', 2200, 43);

# 用户登录
create table user
(
    name     varchar(50) not null,
    password varchar(50) not null,
    email    varchar(20) not null,
    primary key (name)
) character set = utf8;

insert into user
values ('33', '111', '111111@qq.com');


# 订单
create table personalorder
(
    name        varchar(50)  not null,
    shop        varchar(50)  not null,
    shouhuoname varchar(50)  not null,
    address     varchar(100) not null,
    phone       varchar(18)  not null,
    primary key (name)
) character set = utf8;

insert into personalorder
values ('33', 'Note 9 Pro', '33不是山山', '广东省广州市从化区温泉大道广州南方学院', '19832327832');


# 个人购物车
create table personalcart
(
    name  varchar(50) not null,
    shop  varchar(50) not null,
    price float       not null,
    primary key (name)
) character set = utf8;

insert into personalcart
values ('33', '品家风冷对开门冰箱', 7499.00);