h2.sql

-- 将该建表 SQL 语句，添加到 yudao-module-ecw-impl 模块的 test/resources/sql/create_tables.sql 文件里
CREATE TABLE IF NOT EXISTS "ecw_product_brand_unauth_empower" (
    "id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
    "product_brand_id" bigint NOT NULL,
    "customer_id" bigint NOT NULL,
    "customer_contacts_id" bigint NOT NULL,
    "fee_scale" tinyint NOT NULL,
    "create_user_id" bigint NOT NULL,
    "create_username" varchar(255) NOT NULL,
    "creator" varchar(32) DEFAULT '',
    "create_time" datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updater" varchar(32) DEFAULT '',
    "update_time" datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    "deleted" bit NOT NULL DEFAULT FALSE,
    PRIMARY KEY ("id")
) COMMENT '商品品牌-未授权客户-指定收费标准表';

-- 将该删表 SQL 语句，添加到 yudao-module-ecw-impl 模块的 test/resources/sql/clean.sql 文件里
DELETE FROM "ecw_product_brand_unauth_empower";