From 528cbf2ef570894aaf919ed3da0d3cd129a2c8e8 Mon Sep 17 00:00:00 2001
From: Tom Willemse
Date: Tue, 8 Sep 2026 00:43:46 -0700
Subject: db: Add created_at and updated_at fields in tables

---
 src/db.phel | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

(limited to 'src/db.phel')

diff --git a/src/db.phel b/src/db.phel
index 3f50ccc..a83a290 100644
--- a/src/db.phel
+++ b/src/db.phel
@@ -4,6 +4,6 @@
 (def conn (pdo/connect "sqlite:test.db"))
 
 (defn initialize-database []
-  (pdo/exec conn "create table if not exists books (id integer primary key autoincrement, title varchar(255), subtitle varchar(255))")
-  (pdo/exec conn "create table if not exists authors (id integer primary key autoincrement, name varchar(255))")
+  (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 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