范型1234567

CREATE DATABASE IF NOT EXISTS ku DEFAULT CHARSET utf8;
USE ku;
CREATE TABLE IF NOT EXISTS userinfo 
(
    UserName VARCHAR(50) PRIMARY KEY COMMENT '用户名',
    PASSWORD VARCHAR(20) COMMENT '密码',
    DATE DATE COMMENT '注册日期',
    Birday DATE COMMENT '生日'
);
SELECT * FROM userinfo;

CREATE TABLE IF NOT EXISTS browseinfo
(
    UserName VARCHAR(50) PRIMARY KEY COMMENT '用户名',
    commodityId INT COMMENT '浏览商品编号',
    commodityName VARCHAR(50) COMMENT '浏览商品名字',
    commodityDate DATE COMMENT '浏览商品日期'
    
);
SELECT * FROM browseinfo;

CREATE TABLE IF NOT EXISTS Collectioninfo
(
    username VARCHAR(50) PRIMARY KEY COMMENT '用户名',
    CollectionId INT COMMENT '收藏商品编号',
    CollectionName VARCHAR(50) COMMENT '收藏商品名字',
    CollectionDate DATE COMMENT '收藏商品日期'
);
SELECT * FROM Collectioninfo;

CREATE TABLE IF NOT EXISTS commodityinfo
(
    commodityId INT PRIMARY KEY COMMENT '商品编号',
    commodityName VARCHAR(50) COMMENT '商品名字',
    commoditType VARCHAR(50)COMMENT '商品类型'    
);
SELECT * FROM commodityinfo;

CREATE TABLE IF NOT EXISTS shopinfo
(
    shopId INT PRIMARY KEY COMMENT '店铺编号',
    shopName VARCHAR(50) COMMENT '店铺名字',
    homeName VARCHAR(50) COMMENT '店家名字'
);
SELECT * FROM shopinfo;

CREATE TABLE IF NOT EXISTS ShoppingCartRecordinfo
(
    UserName VARCHAR(50) PRIMARY KEY COMMENT '用户名',
    ShoppingCartRecord VARCHAR(500) COMMENT '购物车记录',
)
SELECT * FROM ShoppingCartRecordinfo;

CREATE TABLE IF NOT EXISTS PurchaseRecordinfo
(
    UserName VARCHAR(50) PRIMARY KEY COMMENT '用户名',
    PurchaseRecord VARCHAR(500) COMMENT '购买记录'
);
SELECT * FROM PurchaseRecordinfo;