path: root/fj.db

SQLite format 3

@  		
.j�
�%�h�
��%�6
�;tableremindersreminders	CREATE TABLE reminders (
    id integer primary key,
    task_id integer,
    time_delta text not null,
    foreign key(task_id) references tasks(id)
)�"
�+tableloglogCREATE TABLE log (
    id integer primary key,
    task_id integer,
    datetime text not null,
    foreign key(task_id) references tasks(id)
)�b--
�wtabletasks_categoriestasks_categoriesCREATE TABLE tasks_categories (
    task_id integer,
    category_id integer,
    foreign key(task_id) references tasks(id),
    foreign key(category_id) references categories(id)
)v!!
�7tablecategoriescategoriesCREATE TABLE categories (
    id integer primary key,
    name text unique not null
)3G!
indexsqlite_autoindex_categories_1categories�5

�ItabletaskstasksCREATE TABLE tasks (
    id integer primary key,
    name text unique not null,
    cron text,
    archived integer not null default 0,
    description text
))=
indexsqlite_autoindex_tasks_1tasks