da36506b89
P0 fixes: - ModelError.Is(): use exact matching instead of substring contains() - shouldClearStickySession: add context param for cancellation/tracing P1 fixes: - TODO stubs: return 501 Not Implemented errors - validateInstanceSignature: deduplicate to shared validateCodeSignature() - Error messages: standardize to English only - http.go: remove pseudo if-else with duplicate branches
11 lines
413 B
SQL
11 lines
413 B
SQL
-- 冷归档旧账务幂等键，缩小热表索引与清理范围，同时不丢失长期去重能力。
|
|
|
|
CREATE TABLE IF NOT EXISTS usage_billing_dedup_archive (
|
|
request_id VARCHAR(255) NOT NULL,
|
|
api_key_id BIGINT NOT NULL,
|
|
request_fingerprint VARCHAR(64) NOT NULL,
|
|
created_at TIMESTAMPTZ NOT NULL,
|
|
archived_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),
|
|
PRIMARY KEY (request_id, api_key_id)
|
|
);
|