theo-agent-dashboard

Unnamed repository; edit this file 'description' to name the repository.
Log | Files | Refs | README

0001_init.sql (1043B)

      1 -- Theo Agent Dashboard: initial schema
      2 
      3 CREATE TABLE IF NOT EXISTS topics (
      4     id TEXT PRIMARY KEY,
      5     name TEXT NOT NULL UNIQUE,
      6     color TEXT NOT NULL DEFAULT '#6366f1',
      7     sort_order INTEGER NOT NULL DEFAULT 0,
      8     created_at INTEGER NOT NULL
      9 );
     10 
     11 CREATE TABLE IF NOT EXISTS topic_sessions (
     12     topic_id TEXT NOT NULL REFERENCES topics(id),
     13     session_id TEXT NOT NULL UNIQUE,
     14     assigned_at INTEGER NOT NULL
     15 );
     16 
     17 CREATE TABLE IF NOT EXISTS attachments (
     18     id TEXT PRIMARY KEY,
     19     session_id TEXT NOT NULL,
     20     filename TEXT NOT NULL,
     21     content_type TEXT NOT NULL,
     22     size_bytes INTEGER NOT NULL,
     23     disk_path TEXT NOT NULL,
     24     created_at INTEGER NOT NULL
     25 );
     26 
     27 CREATE TABLE IF NOT EXISTS branches (
     28     session_id TEXT PRIMARY KEY,
     29     parent_session_id TEXT NOT NULL,
     30     fork_message_index INTEGER NOT NULL,
     31     created_at INTEGER NOT NULL
     32 );
     33 
     34 CREATE TABLE IF NOT EXISTS auth_config (
     35     id INTEGER PRIMARY KEY DEFAULT 1,
     36     password_hash TEXT NOT NULL,
     37     hermes_api_key TEXT NOT NULL,
     38     created_at INTEGER NOT NULL
     39 );