wSjbWL0i

1-- up
2
3BEGIN;
4  CREATE TABLE IF NOT EXISTS "public"."user_mfa" (
5      "id" uuid DEFAULT uuid_generate_v4(),
6      "user_id" uuid NOT NULL,
7      "client_key" varchar(255),
8      "encrypted_secret" bytea,
9      "aws_kms_key_id" varchar(255),
10      "aws_kms_region" varchar(255),
11      "backup_codes" text[],
12      "verified" boolean DEFAULT false,
13      "created_at" timestamp with time zone DEFAULT now(),
14      PRIMARY KEY ("id")
15  );
16
17  CREATE INDEX IF NOT EXISTS "user_mfa_id_idx" ON "public"."user_mfa"("id");
18  CREATE INDEX IF NOT EXISTS "user_mfa_user_id_idx" ON "public"."user_mfa"("user_id");
19  CREATE INDEX IF NOT EXISTS "user_mfa_client_key_idx" ON "public"."user_mfa"("client_key");
20  CREATE INDEX IF NOT EXISTS "user_mfa_encrypted_secret_idx" ON "public"."user_mfa"("encrypted_secret");
21  CREATE INDEX IF NOT EXISTS "user_mfa_aws_kms_key_id_idx" ON "public"."user_mfa"("aws_kms_key_id");
22  CREATE INDEX IF NOT EXISTS "user_mfa_aws_kms_region_idx" ON "public"."user_mfa"("aws_kms_region");
23  CREATE INDEX IF NOT EXISTS "user_mfa_aws_backup_codes_idx" ON "public"."user_mfa"("backup_codes");
24  CREATE INDEX IF NOT EXISTS "user_mfa_aws_created_at_idx" ON "public"."user_mfa"("created_at");
25COMMIT;
26
27-- down
28
29BEGIN;
30  DROP TABLE IF EXISTS "public"."user_mfa";
31  DROP INDEX IF EXISTS "user_mfa_id_idx";
32  DROP INDEX IF EXISTS "user_mfa_user_id_idx";
33  DROP INDEX IF EXISTS "user_mfa_client_key_idx";
34  DROP INDEX IF EXISTS "user_mfa_encrypted_secret_idx";
35  DROP INDEX IF EXISTS "user_mfa_aws_kms_key_id_idx";
36  DROP INDEX IF EXISTS "user_mfa_aws_kms_region_idx";
37  DROP INDEX IF EXISTS "user_mfa_aws_backup_codes_idx";
38  DROP INDEX IF EXISTS "user_mfa_aws_created_at_idx";
39  DROP INDEX IF EXISTS "user_mfa_aws_verified_idx";
40COMMIT;