7 lines
232 B
SQL
7 lines
232 B
SQL
ALTER TABLE IF EXISTS email_sms_outbox
|
|
ADD COLUMN IF NOT EXISTS idempotency_key TEXT;
|
|
|
|
CREATE UNIQUE INDEX IF NOT EXISTS email_sms_outbox_idempotency_idx
|
|
ON email_sms_outbox(idempotency_key)
|
|
WHERE idempotency_key IS NOT NULL;
|