Query

database.sqlite — user

SQL

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")
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id varchar ✓ ✓ Rename | Drop
email varchar(255) ✓ Rename | Drop
firstName varchar(32) ✓ Rename | Drop
lastName varchar(32) ✓ Rename | Drop
password varchar ✓ Rename | Drop
personalizationAnswers TEXT ✓ Rename | Drop
createdAt datetime(3) Rename | Drop
updatedAt datetime(3) Rename | Drop
settings TEXT ✓ Rename | Drop
disabled boolean Rename | Drop
mfaEnabled boolean Rename | Drop
mfaSecret TEXT ✓ Rename | Drop
mfaRecoveryCodes TEXT ✓ Rename | Drop
lastActiveAt date ✓ Rename | Drop
roleSlug varchar(128) Rename | Drop

Foreign Keys

Column Destination
roleSlug role.slug

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_user_1 id ✓ SQL
-- no sql found --
 Drop
sqlite_autoindex_user_2 email ✓ SQL
-- no sql found --
 Drop
user_role_idx roleSlug SQL 
CREATE INDEX "user_role_idx"
ON "user" ("roleSlug")
Drop