From 12bdfebb9b3acb3d9e8ea52b8db5946ea23714e7 Mon Sep 17 00:00:00 2001 From: Helius <wangdoubleone@gmail.com> Date: Fri, 17 Sep 2021 16:35:35 +0800 Subject: [PATCH] add sql file --- sql/xc_mall.sql | 113 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 113 insertions(+), 0 deletions(-) diff --git a/sql/xc_mall.sql b/sql/xc_mall.sql new file mode 100644 index 0000000..ac34e58 --- /dev/null +++ b/sql/xc_mall.sql @@ -0,0 +1,113 @@ +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-否'; + + -- Gitblit v1.9.1