Query

db.sqlite3 — core_users

SQL

CREATE TABLE "core_users"  (
  "id" integer NOT NULL PRIMARY KEY AUTOINCREMENT,
  "password" varchar(128) NOT NULL,
  "last_login" datetime NULL,
  "is_superuser" bool NOT NULL,
  "username" varchar(150) NOT NULL UNIQUE,
  "first_name" varchar(150) NOT NULL,
  "last_name" varchar(150) NOT NULL,
  "is_staff" bool NOT NULL,
  "is_active" bool NOT NULL,
  "date_joined" datetime NOT NULL,
  "uuid" varchar(8) NULL UNIQUE,
  "email" varchar(254) NULL,
  "is_moderator" bool NOT NULL,
  "is_admin" bool NOT NULL,
  "web_login_enabled" bool NOT NULL,
  "preferred_contact_method" varchar(50) NULL,
  "timezone" varchar(50) NOT NULL,
  "mfa_enabled" bool NOT NULL,
  "mfa_secret" varchar(32) NOT NULL,
  "password_reset_token" varchar(64) NULL,
  "password_reset_expiry" datetime NULL,
  "created_at" datetime NOT NULL,
  "updated_at" datetime NOT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
password varchar(128) Rename | Drop
last_login datetime ✓ Rename | Drop
is_superuser bool Rename | Drop
username varchar(150) Rename | Drop
first_name varchar(150) Rename | Drop
last_name varchar(150) Rename | Drop
is_staff bool Rename | Drop
is_active bool Rename | Drop
date_joined datetime Rename | Drop
uuid varchar(8) ✓ Rename | Drop
email varchar(254) ✓ Rename | Drop
is_moderator bool Rename | Drop
is_admin bool Rename | Drop
web_login_enabled bool Rename | Drop
preferred_contact_method varchar(50) ✓ Rename | Drop
timezone varchar(50) Rename | Drop
mfa_enabled bool Rename | Drop
mfa_secret varchar(32) Rename | Drop
password_reset_token varchar(64) ✓ Rename | Drop
password_reset_expiry datetime ✓ Rename | Drop
created_at datetime Rename | Drop
updated_at datetime Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_core_users_1 username ✓ SQL
-- no sql found --
 Drop
sqlite_autoindex_core_users_2 uuid ✓ SQL
-- no sql found --
 Drop