diff options
Diffstat (limited to 'migrations/20240726140649_fj.sql')
-rw-r--r-- | migrations/20240726140649_fj.sql | 35 |
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) -); |