Query

database.db — guests

SQL

CREATE TABLE guests  (
  tag         TEXT PRIMARY KEY NOT NULL,
  name        TEXT NOT NULL,
  level       INTEGER NOT NULL,
  is_active   TEXT NOT NULL DEFAULT 'no',
  times_paid  INTEGER NOT NULL DEFAULT 0,
  ticks       INTEGER NOT NULL DEFAULT 0,
  blacklisted TEXT NOT NULL DEFAULT 'no',
  date        TEXT NOT NULL DEFAULT '',
  buy_days    TEXT NOT NULL DEFAULT '[]',
  email       TEXT NOT NULL DEFAULT ''
)

+ Add column

Columns

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

+ Add index

Indexes

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