From f32375488f5127c910021f627d83e017c5c7a10f Mon Sep 17 00:00:00 2001
From: Grail Finder <wohilas@gmail.com>
Date: Tue, 19 Nov 2024 17:15:02 +0300
Subject: Feat: add storage interface; add sqlite impl

---
 storage/migrations/001_init.up.sql | 7 +++++++
 1 file changed, 7 insertions(+)
 create mode 100644 storage/migrations/001_init.up.sql

(limited to 'storage/migrations/001_init.up.sql')

diff --git a/storage/migrations/001_init.up.sql b/storage/migrations/001_init.up.sql
new file mode 100644
index 0000000..287f3d1
--- /dev/null
+++ b/storage/migrations/001_init.up.sql
@@ -0,0 +1,7 @@
+CREATE TABLE chat (
+    id INTEGER PRIMARY KEY AUTOINCREMENT,
+    name TEXT NOT NULL,
+    msgs TEXT NOT NULL,  -- Store messages as a comma-separated string
+    created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
+    updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
+);
-- 
cgit v1.2.3

