1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
|
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)
);
|
