yW05nuB9

1DROP TABLE IF EXISTS "credential";
2CREATE TABLE "public"."credential" (
3    "id" character varying(36) NOT NULL,
4    "salt" bytea,
5    "type" character varying(255),
6    "user_id" character varying(36),
7    "created_date" bigint,
8    "user_label" character varying(255),
9    "secret_data" text,
10    "credential_data" text,
11    "priority" integer,
12    CONSTRAINT "constraint_f" PRIMARY KEY ("id"),
13    CONSTRAINT "fk_pfyr0glasqyl0dei3kl69r6v0" FOREIGN KEY (user_id) REFERENCES user_entity(id) NOT DEFERRABLE
14) WITH (oids = false);
15
16CREATE INDEX "idx_user_credential" ON "public"."credential" USING btree ("user_id");
17
18INSERT INTO "credential" ("id", "salt", "type", "user_id", "created_date", "user_label", "secret_data", "credential_data", "priority") VALUES
19('c6cd72f4-dc48-4070-b31f-922037651ba5',	NULL,	'password',	'be3007ec-02d9-4878-80b0-201f1243bd3b',	1590190192201,	NULL,	'{"value":"yWpL+DjYhjXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX3U3nsGsow==","salt":"FK9DpXXXXXXXXXXXXXXOXQ=="}',	'{"hashIterations":27500,"algorithm":"pbkdf2-sha256"}',	10),
20('21a13db0-690c-4633-b21b-d79ffb1f48eb',	NULL,	'otp',	'be3007ec-02d9-4878-80b0-201f1243bd3b',	1590190336840,	'Mi9Lite',	'{"value":"fm983rXXXXXXXXXXdqOs"}',	'{"subType":"totp","digits":6,"counter":0,"period":30,"algorithm":"HmacSHA1"}',	20);