From 506713247b0099142ff873f5750933d49b182c37 Mon Sep 17 00:00:00 2001
From: Guillermo Serrahima <dev@vylion.com>
Date: Mon, 22 Jun 2026 02:49:02 +0200
Subject: first commit

---
 mcp/senia/migrations/0001_initial.sql | 12 ++++++++++++
 1 file changed, 12 insertions(+)
 create mode 100644 mcp/senia/migrations/0001_initial.sql

(limited to 'mcp/senia/migrations/0001_initial.sql')

diff --git a/mcp/senia/migrations/0001_initial.sql b/mcp/senia/migrations/0001_initial.sql
new file mode 100644
index 0000000..e560e10
--- /dev/null
+++ b/mcp/senia/migrations/0001_initial.sql
@@ -0,0 +1,12 @@
+-- Initial schema for senia.db.
+-- Single shared database for all senia-related state.
+-- Currently: diary_logs only. Future tables (tasks, embeddings, etc.) added via new migrations.
+
+CREATE TABLE diary_logs (
+    id INTEGER PRIMARY KEY AUTOINCREMENT,
+    ts TEXT NOT NULL,                    -- ISO 8601 UTC with offset
+    content TEXT NOT NULL,               -- 1-2 sentence observation
+    created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP
+);
+
+CREATE INDEX idx_diary_ts ON diary_logs(ts);
-- 
cgit v1.2.3