From d8c97392354a6b6d14efbdd4a73ee0148609bef8 Mon Sep 17 00:00:00 2001 From: xiaoyong931011 <15274802129@163.com> Date: Wed, 22 Sep 2021 10:04:06 +0800 Subject: [PATCH] Merge branch 'master' of http://120.27.238.55:7000/r/xc-mall --- sql/xc_mall.sql | 146 ++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 146 insertions(+), 0 deletions(-) diff --git a/sql/xc_mall.sql b/sql/xc_mall.sql new file mode 100644 index 0000000..1b723cd --- /dev/null +++ b/sql/xc_mall.sql @@ -0,0 +1,146 @@ +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 = '购物车'; + +DROP TABLE IF EXISTS mall_address_info; +CREATE TABLE mall_address_info( + 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' , + name VARCHAR(255) COMMENT '姓名' , + phone VARCHAR(255) COMMENT '联系方式' , + area TEXT COMMENT '地区' , + address TEXT COMMENT '地址' , + longitude VARCHAR(255) COMMENT '经度' , + latitude VARCHAR(255) COMMENT '纬度' , + is_default INT COMMENT '是否默认;1-是2-否' , + PRIMARY KEY (ID) +) COMMENT = '用户地址'; -- Gitblit v1.9.1