12 lines
742 B
SQL
12 lines
742 B
SQL
-- 在部署新版 wallet 服务之前，对钱包库执行。只新增空表，不清理或修正历史流水、余额。
|
|
CREATE TABLE IF NOT EXISTS wallet_transaction_idempotency (
|
|
tenant_id BIGINT NOT NULL,
|
|
wallet_id BIGINT NOT NULL,
|
|
biz_type VARCHAR(8) CHARACTER SET ascii COLLATE ascii_bin NOT NULL COMMENT '仅批量更新2、退还食堂8',
|
|
biz_id VARCHAR(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
|
|
price INT NOT NULL COMMENT '有符号变动金额，分',
|
|
transaction_id BIGINT NOT NULL,
|
|
create_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
PRIMARY KEY (tenant_id, wallet_id, biz_type, biz_id)
|
|
) ENGINE=InnoDB COMMENT='批量钱包入账幂等键，与余额和流水同事务提交';
|