SQL

CREATE TABLE user  (
  id TEXT PRIMARY KEY,
  name TEXT NOT NULL DEFAULT '',
  email TEXT NOT NULL UNIQUE,
  emailVerified INTEGER NOT NULL DEFAULT 0,
  image TEXT,
  role TEXT NOT NULL DEFAULT 'user',
  banned INTEGER NOT NULL DEFAULT 0,
  banReason TEXT,
  banExpires INTEGER,
  createdAt INTEGER NOT NULL,
  updatedAt INTEGER NOT NULL,
  phoneNumber TEXT,
  phoneNumberVerified INTEGER NOT NULL DEFAULT 0
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id TEXT ✓ ✓ Rename | Drop
name TEXT Rename | Drop
email TEXT Rename | Drop
emailVerified INTEGER Rename | Drop
image TEXT ✓ Rename | Drop
role TEXT Rename | Drop
banned INTEGER Rename | Drop
banReason TEXT ✓ Rename | Drop
banExpires INTEGER ✓ Rename | Drop
createdAt INTEGER Rename | Drop
updatedAt INTEGER Rename | Drop
phoneNumber TEXT ✓ Rename | Drop
phoneNumberVerified INTEGER Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_user_1 id ✓ SQL
-- no sql found --
 Drop
sqlite_autoindex_user_2 email ✓ SQL
-- no sql found --
 Drop