aboutsummaryrefslogtreecommitdiffstats
path: root/migrations
diff options
context:
space:
mode:
authorLibravatar cel 🌸 <cel@blos.sm>2024-08-04 18:26:38 +0100
committerLibravatar cel 🌸 <cel@blos.sm>2024-08-04 18:26:38 +0100
commitc3fde18b74fa967a02b3a922a9a3554b80207b06 (patch)
treee2d822189e97c8600b5113490e6dc921f3398561 /migrations
downloadfj-c3fde18b74fa967a02b3a922a9a3554b80207b06.tar.gz
fj-c3fde18b74fa967a02b3a922a9a3554b80207b06.tar.bz2
fj-c3fde18b74fa967a02b3a922a9a3554b80207b06.zip
WIP: db
Diffstat (limited to 'migrations')
-rw-r--r--migrations/20240726140649_fj.sql35
1 files changed, 35 insertions, 0 deletions
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)
+);