captains-log/migrations/0001_create_tasks.sql

CREATE TABLE IF NOT EXISTS task ( 
  id integer NOT NULL PRIMARY KEY AUTOINCREMENT, 
  title text NOT NULL, 
  description text,
  CHECK(title <> '')
);