forked from mtusi2026/mtusi2026lab3
8 lines
262 B
SQL
8 lines
262 B
SQL
CREATE TABLE idempotency_keys (
|
|
scope TEXT PRIMARY KEY,
|
|
request_hash CHAR(64) NOT NULL,
|
|
response_json JSONB NOT NULL,
|
|
created_at TIMESTAMPTZ NOT NULL DEFAULT now()
|
|
);
|
|
CREATE INDEX idempotency_keys_created_at_idx ON idempotency_keys (created_at);
|