CREATE TABLE "user" (
"id" varchar PRIMARY KEY,
"email" varchar(255),
"firstName" varchar(32),
"lastName" varchar(32),
"password" varchar,
"personalizationAnswers" text,
"createdAt" datetime(3) NOT NULL DEFAULT (STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')),
"updatedAt" datetime(3) NOT NULL DEFAULT (STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')),
"settings" text,
"disabled" boolean NOT NULL DEFAULT (FALSE),
"mfaEnabled" boolean NOT NULL DEFAULT (FALSE),
"mfaSecret" text,
"mfaRecoveryCodes" text,
"lastActiveAt" date,
"roleSlug" varchar(128) NOT NULL DEFAULT ('global:member'),
CONSTRAINT "UQ_e12875dfb3b1d92d7d7c5377e22" UNIQUE ("email"),
CONSTRAINT "FK_eaea92ee7bfb9c1b6cd01505d56" FOREIGN KEY ("roleSlug") REFERENCES "role" ("slug")
)