diff options
| author | Guillermo Serrahima <dev@vylion.com> | 2026-06-22 02:49:02 +0200 |
|---|---|---|
| committer | Guillermo Serrahima <dev@vylion.com> | 2026-06-26 13:40:00 +0200 |
| commit | 506713247b0099142ff873f5750933d49b182c37 (patch) | |
| tree | dfe444c057a9addfeaa57951673cf2251802f049 /mcp/senia/migrations/0001_initial.sql | |
| download | senia-506713247b0099142ff873f5750933d49b182c37.tar.xz senia-506713247b0099142ff873f5750933d49b182c37.zip | |
first commit
Diffstat (limited to 'mcp/senia/migrations/0001_initial.sql')
| -rw-r--r-- | mcp/senia/migrations/0001_initial.sql | 12 |
1 files changed, 12 insertions, 0 deletions
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); |