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

CREATE TABLE IF NOT EXISTS "market_activity" (
    "id" bigint(20) NOT NULL GENERATED BY DEFAULT AS IDENTITY,
    "title" varchar(50) NOT NULL,
    "activity_type" tinyint(4) NOT NULL,
    "status" tinyint(4) NOT NULL,
    "start_time" datetime NOT NULL,
    "end_time" datetime NOT NULL,
    "invalid_time" datetime,
    "delete_time" datetime,
    "time_limited_discount" varchar(2000),
    "full_privilege" varchar(2000),
    "creator" varchar(64) DEFAULT '',
    "create_time" datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updater" varchar(64) DEFAULT '',
    "update_time" datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    "deleted" bit NOT NULL DEFAULT FALSE,
    "tenant_id" bigint(20) NOT NULL,
    PRIMARY KEY ("id")
    ) COMMENT '促销活动';

CREATE TABLE IF NOT EXISTS "promotion_coupon_template" (
   "id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
   "name" varchar NOT NULL,
   "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,
   "validity_type" int NOT NULL,
   "valid_start_time" datetime,
   "valid_end_time" datetime,
   "fixed_start_term" int,
   "fixed_end_term" int,
   "discount_type" int NOT NULL,
   "discount_percent" int,
   "discount_price" int,
   "discount_limit_price" int,
   "take_count" int NOT NULL DEFAULT 0,
   "use_count" int NOT NULL DEFAULT 0,
   "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_coupon" (
    "id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
    "template_id" bigint NOT NULL,
    "name" varchar NOT NULL,
    "status" int NOT NULL,
    "user_id" bigint NOT NULL,
    "take_type" int NOT NULL,
    "useprice" int NOT NULL,
    "valid_start_time" datetime NOT NULL,
    "valid_end_time" datetime NOT NULL,
    "product_scope" int NOT NULL,
    "product_spu_ids" varchar,
    "discount_type" int NOT NULL,
    "discount_percent" int,
    "discount_price" int,
    "discount_limit_price" int,
    "use_order_id" bigint,
    "use_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_reward_activity" (
   "id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
   "name" varchar NOT NULL,
   "status" int NOT NULL,
   "start_time" datetime NOT NULL,
   "end_time" datetime NOT NULL,
   "remark" varchar,
   "condition_type" int NOT NULL,
   "product_scope" int NOT NULL,
   "product_spu_ids" varchar,
   "rules" varchar,
   "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_discount_activity" (
     "id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
     "name" varchar NOT NULL,
     "status" int NOT NULL,
     "start_time" datetime NOT NULL,
     "end_time" datetime NOT NULL,
     "remark" varchar,
     "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_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_price" int 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 '限时折扣活动';