From c3fde18b74fa967a02b3a922a9a3554b80207b06 Mon Sep 17 00:00:00 2001 From: cel 🌸 Date: Sun, 4 Aug 2024 18:26:38 +0100 Subject: WIP: db --- migrations/20240726140649_fj.sql | 35 +++++++++++++++++++++++++++++++++++ 1 file changed, 35 insertions(+) create mode 100644 migrations/20240726140649_fj.sql (limited to 'migrations') diff --git a/migrations/20240726140649_fj.sql b/migrations/20240726140649_fj.sql new file mode 100644 index 0000000..0afed32 --- /dev/null +++ b/migrations/20240726140649_fj.sql @@ -0,0 +1,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) +); -- cgit