9T5kShfz

1create table if not exists tasks (
2    id integer primary key autoincrement,
3    name char(100) not null,
4    closed bool not null,
5    priority integer default (0)
6);
7
8insert or ignore into tasks (id, name, closed, priority) values (0, 'Start learning Pyramid', 0, 0);
9insert or ignore into tasks (id, name, closed, priority) values (1, 'Do quick tutorial', 0, 0);
10insert or ignore into tasks (id, name, closed, priority) values (2, 'Have some beer!', 0, 0);