CREATE TABLE webauthn_credentials ( credential_id varchar(512) PRIMARY KEY NOT NULL, user_id integer NOT NULL, origin text(-5) NOT NULL, public_key text(-5) NOT NULL, sign_count int8 DEFAULT 0 NOT NULL, created_at timestamptz DEFAULT now() NOT NULL, last_used_at timestamptz, label text(-5) NOT NULL, user_agent text(-5) NOT NULL, rp_id text(-5) NOT NULL, ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT webauthn_credentials_pkey REFERENCES users (), CONSTRAINT webauthn_credentials_user_id_fkey REFERENCES users () ); CREATE UNIQUE INDEX webauthn_credentials_credential_id_un_idx ON webauthn_credentials (credential_id); CREATE TRIGGER RI_ConstraintTrigger_c_1683742 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_1683743 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 8,192 bytes -- Table rows: 8
Begin main content
