From c3fde18b74fa967a02b3a922a9a3554b80207b06 Mon Sep 17 00:00:00 2001
From: cel 🌸 <cel@blos.sm>
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