blob: 0afed328a9d2ab50aedf6a31bbb9695bee241e5f (
plain) (
tree)
|
|
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)
);
|