+/- table definition

Query 

CREATE TABLE submission  (
  id INTEGER NOT NULL,
  ts DATETIME DEFAULT CURRENT_TIMESTAMP,
  user_id INTEGER NOT NULL,
  taskid VARCHAR(34),
  category VARCHAR(50),
  task VARCHAR(200),
  active BOOLEAN,
  points INTEGER,
  filename VARCHAR(200),
  is_graded BOOLEAN,
  PRIMARY KEY (id),
  FOREIGN KEY(user_id) REFERENCES user (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