5 lines
349 B
PL/PgSQL
5 lines
349 B
PL/PgSQL
|
BEGIN;
|
||
|
|
ALTER TABLE conversation ADD COLUMN onboarding_generation bigint, ADD COLUMN activation_attempt_id uuid REFERENCES device_activation_attempt(id), ADD COLUMN activation_test_deadline timestamptz;
|
||
|
|
CREATE UNIQUE INDEX conversation_activation_attempt_unique ON conversation(activation_attempt_id) WHERE activation_attempt_id IS NOT NULL;
|
||
|
|
COMMIT;
|