15 lines
517 B
PL/PgSQL
15 lines
517 B
PL/PgSQL
|
BEGIN;
|
||
|
|
CREATE TABLE customer_phone_credential (
|
||
|
|
phone_digest char(64) PRIMARY KEY,
|
||
|
|
phone_masked text NOT NULL,
|
||
|
|
issuer text NOT NULL,
|
||
|
|
subject text NOT NULL,
|
||
|
|
password_hash text,
|
||
|
|
created_at timestamptz NOT NULL DEFAULT now(),
|
||
|
|
updated_at timestamptz NOT NULL DEFAULT now(),
|
||
|
|
UNIQUE(issuer,subject)
|
||
|
|
);
|
||
|
|
ALTER TABLE onboarding_account_session ADD COLUMN phone_digest char(64) REFERENCES customer_phone_credential(phone_digest);
|
||
|
|
ALTER TABLE onboarding_account_session ADD COLUMN phone_verified_at timestamptz;
|
||
|
|
COMMIT;
|