库存流水修改

liyong

10 天以前 450bcae3cfffe9923dc09dea2a4e89312bb373d7

 yudao-module-mall/yudao-module-promotion/src/test/resources/sql/create_tables.sql

@@ -23,13 +23,14 @@
(
    "id"                   bigint   NOT NULL GENERATED BY DEFAULT AS IDENTITY,
    "name"                 varchar  NOT NULL,
    "description"          varchar,
    "status"               int      NOT NULL,
    "total_count"          int      NOT NULL,
    "take_limit_count"     int      NOT NULL,
    "take_type"            int      NOT NULL,
    "use_price"            int      NOT NULL,
    "product_scope"        int      NOT NULL,
    "product_spu_ids"      varchar,
    "product_scope_values" varchar,
    "validity_type"        int      NOT NULL,
    "valid_start_time"     datetime,
    "valid_end_time"       datetime,
@@ -57,11 +58,11 @@
    "status"               int      NOT NULL,
    "user_id"              bigint   NOT NULL,
    "take_type"            int      NOT NULL,
    "useprice"             int      NOT NULL,
    "use_price"            int      NOT NULL,
    "valid_start_time"     datetime NOT NULL,
    "valid_end_time"       datetime NOT NULL,
    "product_scope"        int      NOT NULL,
    "product_spu_ids"      varchar,
    "product_scope_values" varchar,
    "discount_type"        int      NOT NULL,
    "discount_percent"     int,
    "discount_price"       int,
@@ -111,6 +112,27 @@
    "deleted"     bit      NOT NULL DEFAULT FALSE,
    PRIMARY KEY ("id")
) COMMENT '限时折扣活动';

CREATE TABLE IF NOT EXISTS "promotion_discount_product"
(
    "id"                  bigint   NOT NULL GENERATED BY DEFAULT AS IDENTITY,
    "activity_id"         bigint   NOT NULL,
    "spu_id"              bigint   NOT NULL,
    "sku_id"              bigint   NOT NULL,
    "discount_type"       int      NOT NULL,
    "discount_percent"    int,
    "discount_price"      int,
    "activity_name"       varchar  NOT NULL,
    "activity_status"     int      NOT NULL,
    "activity_start_time" datetime NOT NULL,
    "activity_end_time"   datetime NOT NULL,
    "creator"             varchar           DEFAULT '',
    "create_time"         datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updater"             varchar           DEFAULT '',
    "update_time"         datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    "deleted"             bit      NOT NULL DEFAULT FALSE,
    PRIMARY KEY ("id")
) COMMENT '限时折扣商品';

CREATE TABLE IF NOT EXISTS "promotion_seckill_activity"
(
@@ -180,6 +202,36 @@
    "tenant_id"          bigint   NOT NULL,
    PRIMARY KEY ("id")
) COMMENT '拼团活动';

CREATE TABLE IF NOT EXISTS "promotion_combination_record"
(
    "id"                bigint   NOT NULL GENERATED BY DEFAULT AS IDENTITY,
    "activity_id"       bigint   NOT NULL,
    "combination_price" int      NOT NULL,
    "spu_id"            bigint   NOT NULL,
    "spu_name"          varchar  NOT NULL,
    "pic_url"           varchar,
    "sku_id"            bigint   NOT NULL,
    "count"             int      NOT NULL,
    "user_id"           bigint   NOT NULL,
    "nickname"          varchar,
    "avatar"            varchar,
    "head_id"           bigint   NOT NULL,
    "status"            int      NOT NULL,
    "order_id"          bigint   NOT NULL,
    "user_size"         int      NOT NULL,
    "user_count"        int      NOT NULL,
    "virtual_group"     bit      NOT NULL,
    "expire_time"       datetime,
    "start_time"        datetime,
    "end_time"          datetime,
    "creator"           varchar           DEFAULT '',
    "create_time"       datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updater"           varchar           DEFAULT '',
    "update_time"       datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    "deleted"           bit      NOT NULL DEFAULT FALSE,
    PRIMARY KEY ("id")
) COMMENT '拼团记录';

CREATE TABLE IF NOT EXISTS "promotion_article_category"
(
@@ -253,4 +305,4 @@
    "deleted"            bit      NOT NULL DEFAULT FALSE,
    "tenant_id"          bigint   NOT NULL,
    PRIMARY KEY ("id")
) COMMENT '装修页面';
) COMMENT '装修页面';