6 lines
434 B
PL/PgSQL
6 lines
434 B
PL/PgSQL
|
BEGIN;
|
||
|
|
ALTER TABLE onboarding_sms_challenge ADD COLUMN purpose varchar(32) NOT NULL DEFAULT 'LOGIN' CHECK (purpose IN ('LOGIN','CHANGE_PASSWORD'));
|
||
|
|
ALTER TABLE customer_sms_challenge ADD COLUMN purpose varchar(32) NOT NULL DEFAULT 'LOGIN' CHECK (purpose IN ('LOGIN','CHANGE_PASSWORD'));
|
||
|
|
ALTER TABLE operator_sms_challenge ADD COLUMN purpose varchar(32) NOT NULL DEFAULT 'LOGIN' CHECK (purpose IN ('LOGIN','CHANGE_PASSWORD'));
|
||
|
|
COMMIT;
|