Query

branch.sqlite — local_users

SQL

CREATE TABLE "local_users"  (
  "Id" TEXT NOT NULL CONSTRAINT "PK_local_users" PRIMARY KEY,
  "UserId" TEXT NOT NULL,
  "FullName" TEXT NOT NULL,
  "PinHash" TEXT NOT NULL,
  "UserType" TEXT NOT NULL,
  "IsActive" INTEGER NOT NULL,
  "PinIssuedAt" TEXT NOT NULL,
  "LastLoginAt" TEXT NULL,
  "CreatedAt" TEXT NOT NULL,
  "UpdatedAt" TEXT NOT NULL,
  "IsDeleted" INTEGER NOT NULL,
  "DeletedAt" TEXT NULL,
  "Email" TEXT NOT NULL DEFAULT '',
  "PasswordHash" TEXT NOT NULL DEFAULT ''
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
Id TEXT ✓ Rename | Drop
UserId TEXT Rename | Drop
FullName TEXT Rename | Drop
PinHash TEXT Rename | Drop
UserType TEXT Rename | Drop
IsActive INTEGER Rename | Drop
PinIssuedAt TEXT Rename | Drop
LastLoginAt TEXT ✓ Rename | Drop
CreatedAt TEXT Rename | Drop
UpdatedAt TEXT Rename | Drop
IsDeleted INTEGER Rename | Drop
DeletedAt TEXT ✓ Rename | Drop
Email TEXT Rename | Drop
PasswordHash TEXT Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IX_local_users_IsActive IsActive SQL 
CREATE INDEX "IX_local_users_IsActive"
ON "local_users" ("IsActive")
Drop
IX_local_users_UserId UserId ✓ SQL 
CREATE UNIQUE INDEX "IX_local_users_UserId"
ON "local_users" ("UserId")
Drop
sqlite_autoindex_local_users_1 Id ✓ SQL
-- no sql found --
 Drop