Query

aurasec.db — app_users

SQL

CREATE TABLE "app_users"  (
  "id" INTEGER NOT NULL CONSTRAINT "PK_app_users" PRIMARY KEY AUTOINCREMENT,
  "username" TEXT NOT NULL,
  "fullname" TEXT NOT NULL,
  "role" TEXT NOT NULL DEFAULT 'admin',
  "enabled" INTEGER NOT NULL DEFAULT 1,
  "password_hash" BLOB NOT NULL,
  "password_salt" BLOB NOT NULL,
  "academy_id" INTEGER NULL,
  "created_at" TEXT NOT NULL DEFAULT (CURRENT_TIMESTAMP),
  "updated_at" TEXT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
username TEXT Rename | Drop
fullname TEXT Rename | Drop
role TEXT Rename | Drop
enabled INTEGER Rename | Drop
password_hash BLOB Rename | Drop
password_salt BLOB Rename | Drop
academy_id INTEGER ✓ Rename | Drop
created_at TEXT Rename | Drop
updated_at TEXT ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IX_app_users_username username ✓ SQL 
CREATE UNIQUE INDEX "IX_app_users_username"
ON "app_users" ("username")
Drop