aboutsummaryrefslogtreecommitdiffstats
path: root/migrations/20240726140649_fj.sql
diff options
context:
space:
mode:
Diffstat (limited to 'migrations/20240726140649_fj.sql')
-rw-r--r--migrations/20240726140649_fj.sql35
1 files changed, 0 insertions, 35 deletions
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)
-);