+/- table definition

Query 

CREATE TABLE message  (
  id INTEGER NOT NULL,
  ts DATETIME DEFAULT CURRENT_TIMESTAMP,
  sub_id INTEGER NOT NULL,
  who VARCHAR(80) NOT NULL,
  txt VARCHAR(256),
  PRIMARY KEY (id),
  FOREIGN KEY(sub_id) REFERENCES submission (id)
)
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 view : create view : drop