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/0002_tasks.sql | 16 ++++++++++++++++
 1 file changed, 16 insertions(+)
 create mode 100644 mcp/senia/migrations/0002_tasks.sql

(limited to 'mcp/senia/migrations/0002_tasks.sql')

diff --git a/mcp/senia/migrations/0002_tasks.sql b/mcp/senia/migrations/0002_tasks.sql
new file mode 100644
index 0000000..73f7820
--- /dev/null
+++ b/mcp/senia/migrations/0002_tasks.sql
@@ -0,0 +1,16 @@
+-- Task tracking for agents.
+-- Live tasks only; completed/cancelled tasks are deleted after their
+-- lifecycle event is committed to memory (via diary_log).
+
+CREATE TABLE tasks (
+    id INTEGER PRIMARY KEY AUTOINCREMENT,
+    owner TEXT NOT NULL CHECK (owner IN ('agent', 'user')),
+    content TEXT NOT NULL,
+    due_at TEXT,
+    last_nudged_at TEXT,
+    created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP,
+    updated_at TEXT,
+    notes TEXT
+);
+
+CREATE INDEX idx_tasks_owner ON tasks(owner);
-- 
cgit v1.2.3