Query

data — User

SQL

CREATE TABLE "User"  (
  "id" integer PRIMARY KEY,
  "username" text NOT NULL,
  "name" text NOT NULL,
  "email" text NOT NULL UNIQUE,
  "lang" text,
  "timezone" text,
  "nationality" text,
  "country" text,
  "is_active" integer,
  "date_joined" text
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
username TEXT Rename | Drop
name TEXT Rename | Drop
email TEXT Rename | Drop
lang TEXT ✓ Rename | Drop
timezone TEXT ✓ Rename | Drop
nationality TEXT ✓ Rename | Drop
country TEXT ✓ Rename | Drop
is_active INTEGER ✓ Rename | Drop
date_joined TEXT ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_User_1 email ✓ SQL
-- no sql found --
 Drop