Query

database.db — players

SQL

CREATE TABLE players  (
  tag         TEXT PRIMARY KEY NOT NULL,
  name        TEXT NOT NULL,
  level       INTEGER NOT NULL,
  blacklisted TEXT NOT NULL DEFAULT 'no',
  date        TEXT NOT NULL DEFAULT '',
  ticks       INTEGER NOT NULL DEFAULT 0,
  email       TEXT NOT NULL DEFAULT '',
  role        TEXT NOT NULL DEFAULT 'member'
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
tag TEXT ✓ Rename | Drop
name TEXT Rename | Drop
level INTEGER Rename | Drop
blacklisted TEXT Rename | Drop
date TEXT Rename | Drop
ticks INTEGER Rename | Drop
email TEXT Rename | Drop
role TEXT Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_players_1 tag ✓ SQL
-- no sql found --
 Drop