forked from mtusi2026/mtusi2026lab4
11 lines
429 B
SQL
11 lines
429 B
SQL
-- +goose Up
|
|
-- Additive: old lab2 writers can still insert NULL keys during migration.
|
|
ALTER TABLE messages ADD COLUMN IF NOT EXISTS idempotency_key text
|
|
CHECK (idempotency_key ~ '^[A-Za-z0-9._:-]{1,128}$');
|
|
CREATE UNIQUE INDEX IF NOT EXISTS messages_idempotency_idx
|
|
ON messages(sender_id, chat_id, idempotency_key);
|
|
|
|
-- +goose Down
|
|
DROP INDEX messages_idempotency_idx;
|
|
ALTER TABLE messages DROP COLUMN idempotency_key;
|