Files
2026-10-20 20:46:51 +03:00

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;