+/- table definition

Query

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 ''
)
Use Shift + Up/Down to navigate recently-executed queries