DROP TABLE IF EXISTS mall_member;
|
CREATE TABLE mall_member(
|
REVISION INT COMMENT '乐观锁' ,
|
CREATED_BY VARCHAR(32) COMMENT '创建人' ,
|
CREATED_TIME DATETIME COMMENT '创建时间' ,
|
UPDATED_BY VARCHAR(32) COMMENT '更新人' ,
|
UPDATED_TIME DATETIME COMMENT '更新时间' ,
|
ID BIGINT NOT NULL AUTO_INCREMENT COMMENT '主键' ,
|
name VARCHAR(32) COMMENT '名称' ,
|
phone VARCHAR(32) COMMENT '手机号' ,
|
email VARCHAR(90) COMMENT '邮箱' ,
|
password VARCHAR(500) COMMENT '密码' ,
|
sex VARCHAR(2) COMMENT '性别' ,
|
invite_id VARCHAR(8) COMMENT '邀请码' ,
|
referrer_id VARCHAR(8) COMMENT '推荐人邀请码' ,
|
referrer_ids TEXT COMMENT '推荐人线路' ,
|
level VARCHAR(255) COMMENT '代理层级' ,
|
account_status INT COMMENT '账户状态;1-正常 2-禁用' ,
|
account_type INT COMMENT '账户类型;1-正常用户' ,
|
PRIMARY KEY (ID)
|
) COMMENT = '商城用户表';
|
|
|
DROP TABLE IF EXISTS mall_goods_category;
|
CREATE TABLE mall_goods_category(
|
REVISION INT COMMENT '乐观锁' ,
|
CREATED_BY VARCHAR(32) COMMENT '创建人' ,
|
CREATED_TIME DATETIME COMMENT '创建时间' ,
|
UPDATED_BY VARCHAR(32) COMMENT '更新人' ,
|
UPDATED_TIME DATETIME COMMENT '更新时间' ,
|
ID BIGINT NOT NULL AUTO_INCREMENT COMMENT '主键' ,
|
name VARCHAR(32) COMMENT '名称' ,
|
parent_id BIGINT COMMENT '父级ID' ,
|
parent_ids VARCHAR(900) COMMENT '父级ids' ,
|
PRIMARY KEY (ID)
|
) COMMENT = '商品分类';
|
|
|
DROP TABLE IF EXISTS mall_goods;
|
CREATE TABLE mall_goods(
|
REVISION INT COMMENT '乐观锁' ,
|
CREATED_BY VARCHAR(32) COMMENT '创建人' ,
|
CREATED_TIME DATETIME COMMENT '创建时间' ,
|
UPDATED_BY VARCHAR(32) COMMENT '更新人' ,
|
UPDATED_TIME DATETIME COMMENT '更新时间' ,
|
ID BIGINT NOT NULL AUTO_INCREMENT COMMENT '主键' ,
|
goods_no VARCHAR(32) COMMENT '商品编号' ,
|
goods_name VARCHAR(255) COMMENT '商品名称' ,
|
goods_introdution TEXT(255) COMMENT '商品介绍' ,
|
unit VARCHAR(10) COMMENT '单位' ,
|
thumb VARCHAR(500) COMMENT '缩略图' ,
|
goods_details TEXT COMMENT '商品详情' ,
|
is_sale INT COMMENT '是否上架;1-上架 2-下架' ,
|
original_price VARCHAR(90) COMMENT '原价' ,
|
present_price VARCHAR(90) COMMENT '现价' ,
|
category_id BIGINT COMMENT '分类ID' ,
|
PRIMARY KEY (ID)
|
) COMMENT = '商品信息表';
|
|
|
DROP TABLE IF EXISTS mall_goods_images;
|
CREATE TABLE mall_goods_images(
|
REVISION INT COMMENT '乐观锁' ,
|
CREATED_BY VARCHAR(32) COMMENT '创建人' ,
|
CREATED_TIME DATETIME COMMENT '创建时间' ,
|
UPDATED_BY VARCHAR(32) COMMENT '更新人' ,
|
UPDATED_TIME DATETIME COMMENT '更新时间' ,
|
ID BIGINT NOT NULL AUTO_INCREMENT COMMENT '主键' ,
|
image_url VARCHAR(900) COMMENT '主图链接' ,
|
seq INT COMMENT '排序' ,
|
goods_id BIGINT COMMENT '' ,
|
PRIMARY KEY (ID)
|
) COMMENT = '商品主图';
|
|
|
DROP TABLE IF EXISTS mall_goods_style;
|
CREATE TABLE mall_goods_style(
|
REVISION INT COMMENT '乐观锁' ,
|
CREATED_BY VARCHAR(32) COMMENT '创建人' ,
|
CREATED_TIME DATETIME COMMENT '创建时间' ,
|
UPDATED_BY VARCHAR(32) COMMENT '更新人' ,
|
UPDATED_TIME DATETIME COMMENT '更新时间' ,
|
ID BIGINT NOT NULL AUTO_INCREMENT COMMENT '主键' ,
|
goods_id BIGINT COMMENT '商品ID' ,
|
name VARCHAR(90) COMMENT '样式名称' ,
|
PRIMARY KEY (ID)
|
) COMMENT = '商品样式';
|
|
|
DROP TABLE IF EXISTS mall_goods_sku;
|
CREATE TABLE mall_goods_sku(
|
REVISION INT COMMENT '乐观锁' ,
|
CREATED_BY VARCHAR(32) COMMENT '创建人' ,
|
CREATED_TIME DATETIME COMMENT '创建时间' ,
|
UPDATED_BY VARCHAR(32) COMMENT '更新人' ,
|
UPDATED_TIME DATETIME COMMENT '更新时间' ,
|
ID BIGINT NOT NULL AUTO_INCREMENT COMMENT '主键' ,
|
sku_name VARCHAR(90) COMMENT 'sku名称' ,
|
sku_image VARCHAR(900) COMMENT 'sku图片' ,
|
stock INT COMMENT '库存' ,
|
sku_volume INT COMMENT '销售数量' ,
|
original_price DECIMAL(20,2) COMMENT '原价' ,
|
present_price DECIMAL(20,2) COMMENT '现价' ,
|
style_id BIGINT COMMENT '样式ID' ,
|
goods_id BIGINT COMMENT '商品ID' ,
|
PRIMARY KEY (ID)
|
) COMMENT = '商品sku';
|
|
alter table mall_member add avatar varchar(500) null comment '头像';
|
ALTER TABLE `mall_goods_category` ADD COLUMN `is_recommend` int(11) NULL COMMENT '是否推荐 1：是 2：否' AFTER `parent_ids`;
|
alter table mall_goods add is_hot int default 2 null comment '是否热卖 1-是 2-否';
|
|
DROP TABLE IF EXISTS mall_shopping_cart;
|
CREATE TABLE mall_shopping_cart(
|
REVISION INT COMMENT '乐观锁' ,
|
CREATED_BY VARCHAR(32) COMMENT '创建人' ,
|
CREATED_TIME DATETIME COMMENT '创建时间' ,
|
UPDATED_BY VARCHAR(32) COMMENT '更新人' ,
|
UPDATED_TIME DATETIME COMMENT '更新时间' ,
|
ID BIGINT NOT NULL AUTO_INCREMENT COMMENT '主键' ,
|
member_id BIGINT COMMENT '用户ID' ,
|
goods_id BIGINT COMMENT '商品ID' ,
|
style_id BIGINT COMMENT '样式ID' ,
|
sku_id BIGINT COMMENT 'skuId' ,
|
cnt VARCHAR(255) COMMENT '数量' ,
|
PRIMARY KEY (ID)
|
) COMMENT = '购物车';
|
