aurasec.db — app_users

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
)