Query

database.db — players

+/- table definition

Query 

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'
)
Use Shift + Up/Down to navigate recently-executed queries
delete expression index : create index : drop insert select : advanced select table : alter table : create table : drop trigger : create trigger : drop update upsert view : create view : drop