From cababf71f9411266191d4b1295c030ea533c942c Mon Sep 17 00:00:00 2001
From: Tom Willemse
Date: Tue, 8 Sep 2026 00:54:36 -0700
Subject: Add reading session and progress tables

Each book can have multiple reading sessions, when something is re-read later.
Each session has multiple progress updates. Each progress update has a separate
total number of pages because the total can change for ebooks depending on the
device and the settings that are used.
---
 src/db.phel | 2 ++
 1 file changed, 2 insertions(+)

(limited to 'src/db.phel')

diff --git a/src/db.phel b/src/db.phel
index a83a290..33aee97 100644
--- a/src/db.phel
+++ b/src/db.phel
@@ -5,5 +5,7 @@
 
 (defn initialize-database []
   (pdo/exec conn "create table if not exists books (id integer primary key autoincrement, title varchar(255), subtitle varchar(255), created_at integer, updated_at integer)")
+  (pdo/exec conn "create table if not exists books_sessions (id integer primary key autoincrement, book_id integer, status string, started_at integer, stopped_at integer, created_at integer, updated_at integer)")
+  (pdo/exec conn "create table if not exists sessions_progress (id integer primary key autoincrement, session_id integer, progress integer, total integer, created_at integer, updated_at integer)")
   (pdo/exec conn "create table if not exists authors (id integer primary key autoincrement, name varchar(255), created_at integer, updated_at integer)")
   (pdo/exec conn "create table if not exists authors_books (author_id integer, book_id integer)"))
-- 
cgit v1.3-2-g0d8e