From e313c40d246ac7545a1907621841090664bf61ae Mon Sep 17 00:00:00 2001
From: cel 🌸 <cel@bunny.garden>
Date: Thu, 5 Jun 2025 03:50:36 +0100
Subject: feat: database functions

---
 migrations/1.sql                 | 36 ++++++++++++++++++++++++++++++++++++
 migrations/20240726140649_fj.sql | 35 -----------------------------------
 2 files changed, 36 insertions(+), 35 deletions(-)
 create mode 100644 migrations/1.sql
 delete mode 100644 migrations/20240726140649_fj.sql

(limited to 'migrations')

diff --git a/migrations/1.sql b/migrations/1.sql
new file mode 100644
index 0000000..e540cac
--- /dev/null
+++ b/migrations/1.sql
@@ -0,0 +1,36 @@
+PRAGMA foreign_keys = on;
+
+create table tasks (
+    id blob primary key,
+    name text unique not null,
+    -- TODO: multiple crons?
+    cron text,
+    archived integer not null default 0,
+    description text
+);
+
+create table categories (
+    id blob primary key,
+    name text unique not null
+);
+
+create table tasks_categories (
+    task_id blob not null,
+    category_id blob not null,
+    foreign key(task_id) references tasks(id) on delete cascade,
+    foreign key(category_id) references categories(id) on delete cascade
+);
+
+create table log (
+    id blob primary key,
+    task_id blob not null,
+    timestamp text not null,
+    foreign key(task_id) references tasks(id) on delete cascade
+);
+
+create table reminders (
+    id blob primary key,
+    task_id blob not null,
+    time_delta text not null,
+    foreign key(task_id) references tasks(id) on delete cascade
+);
diff --git a/migrations/20240726140649_fj.sql b/migrations/20240726140649_fj.sql
deleted file mode 100644
index 0afed32..0000000
--- a/migrations/20240726140649_fj.sql
+++ /dev/null
@@ -1,35 +0,0 @@
-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