PRAGMA foreign_keys = on;

create table tasks (
    id integer primary key,
    name text unique not null,
    cron text,
    archived integer not null default 0,
    description text
);

create table categories (
    id integer primary key,
    name text unique not null
);

create table tasks_categories (
    task_id integer,
    category_id integer,
    foreign key(task_id) references tasks(id),
    foreign key(category_id) references categories(id)
);

create table log (
    id integer primary key,
    task_id integer,
    datetime text not null,
    foreign key(task_id) references tasks(id)
);

create table reminders (
    id integer primary key,
    task_id integer,
    time_delta text not null,
    foreign key(task_id) references tasks(id)
);