MCP Shamash

7�-�~r%���O~u���m+
~r%���OBT.�b�SQLite format 3@ 3
.�*
��\ ] � �.�^�
�3
�
?�U+
qindexidx_messages_tomessagesCREATE INDEX idx_messages_to ON messages(to_agent)[/
yindexidx_messages_frommessagesCREATE INDEX idx_messages_from ON messages(from_agent)S/
mindexidx_agents_statusagentsCREATE INDEX idx_agents_status ON agents(status)�?
�]tabletaskstasksCREATE TABLE tasks ( id TEXT PRIMARY KEY, milestone_id TEXT, project_id TEXT NOT NULL, title TEXT NOT NULL, description TEXT, status TEXT DEFAULT 'pending', assigned_to TEXT, priority INTEGER DEFAULT 5, metadata TEXT, -- JSON object created INTEGER NOT NULL, completed_at INTEGER, FOREIGN KEY (milestone_id) REFERENCES milestones(id), FOREIGN KEY (project_id) REFERENCES projects(id), FOREIGN KEY (assigned_to) REFERENCES agents(id) ))=
indexsqlite_autoindex_tasks_1tasks�!!
�{tablemilestonesmilestones CREATE TABLE milestones ( id TEXT PRIMARY KEY, project_id TEXT NOT NULL, title TEXT NOT NULL, description TEXT, status TEXT DEFAULT 'pending', due_date INTEGER, completed_at INTEGER, metadata TEXT, -- JSON object created INTEGER NOT NULL, FOREIGN KEY (project_id) REFERENCES projects(id) )3 G!
indexsqlite_autoindex_milestones_1milestones�3 
�9tableservicesservicesCREATE TABLE services ( id TEXT PRIMARY KEY, name TEXT NOT NULL, type TEXT NOT NULL, -- api, database, queue, etc. endpoint TEXT, status TEXT DEFAULT 'unknown', health_check_url TEXT, last_check INTEGER, response_time_ms INTEGER, metadata TEXT, -- JSON object created INTEGER NOT NULL, updated INTEGER NOT NULL )/C
indexsqlite_autoindex_services_1services� 
�mtableprojectsprojectsCREATE TABLE projects ( id TEXT PRIMARY KEY, name TEXT NOT NULL, path TEXT NOT NULL UNIQUE, description TEXT, type TEXT, -- git, npm, python, etc. status TEXT DEFAULT 'active', metadata TEXT, -- JSON object (git info, dependencies, etc.) created INTEGER NOT NULL, updated INTEGER NOT NULL )/ C
indexsqlite_autoindex_projects_2projects /C
indexsqlite_autoindex_projects_1projects �S
�ytablememoriesmemoriesCREATE TABLE memories ( id TEXT PRIMARY KEY, content TEXT NOT NULL, type TEXT NOT NULL CHECK (type IN ('fact', 'insight', 'experience', 'error')), embedding BLOB, -- Vector embedding agent_id TEXT, project_id TEXT, relevance_score REAL DEFAULT 1.0, access_count INTEGER DEFAULT 0, last_accessed INTEGER, metadata TEXT, -- JSON object created INTEGER NOT NULL, FOREIGN KEY (agent_id) REFERENCES agents(id), FOREIGN KEY (project_id) REFERENCES projects(id) )/C
indexsqlite_autoindex_memories_1memories�K
�itablemessagesmessagesCREATE TABLE messages ( id TEXT PRIMARY KEY, from_agent TEXT NOT NULL, to_agent TEXT, -- NULL for broadcasts content TEXT NOT NULL, channel TEXT, timestamp INTEGER NOT NULL, message_type TEXT NOT NULL DEFAULT 'message', metadata TEXT, -- JSON object FOREIGN KEY (from_agent) REFERENCES agents(id), FOREIGN KEY (to_agent) REFERENCES agents(id) )/C
indexsqlite_autoindex_messages_1messages�;

�QtableagentsagentsCREATE TABLE agents ( id TEXT PRIMARY KEY, name TEXT NOT NULL, status TEXT NOT NULL DEFAULT 'online', capabilities TEXT NOT NULL, -- JSON array last_seen INTEGER NOT NULL, metadata TEXT, -- JSON object created INTEGER NOT NULL )+?
indexsqlite_autoindex_agents_1agents ~r%���Okc���w� 8��4 ���= � � " � e �N��@��]
�tablephasesphases2CREATE TABLE phases ( id TEXT PRIMARY KEY, project_name TEXT NOT NULL, project_path TEXT, timestamp INTEGER NOT NULL, action_items TEXT NOT NULL, -- JSON array design_logic TEXT NOT NULL, agents_used TEXT NOT NULL, supporting_documents TEXT NOT NULL, -- JSON array next_steps TEXT NOT NULL, status TEXT NOT NULL DEFAULT 'PENDING' CHECK (status IN ('PENDING', 'IN_PROGRESS', 'COMPLETE')), metadata TEXT, -- JSON object created INTEGER NOT NULL, updated INTEGER NOT NULL )+?
indexsqlite_autoindex_phases_1phases3X1
windexidx_tasks_assignedtasksCREATE INDEX idx_tasks_assigned ON tasks(assigned_to)U/
sindexidx_tasks_projecttasksCREATE INDEX idx_tasks_project ON tasks(project_id)[3
uindexidx_services_statusservicesCREATE INDEX idx_services_status ON services(status)[3
uindexidx_projects_statusprojectsCREATE INDEX idx_projects_status ON projects(status)U/
mindexidx_memories_typememoriesCREATE INDEX idx_memories_type ON memories(type)a5
indexidx_memories_projectmemoriesCREATE INDEX idx_memories_project ON memories(project_id)[1
windexidx_memories_agentmemoriesCREATE INDEX idx_memories_agent ON memories(agent_id)^5
yindexidx_messages_channelmessagesCREATE INDEX idx_messages_channel ON messages(channel)e9
�
indexidx_messages_timestampmessagesCREATE INDEX idx_messages_timestamp ON messages(timestamp)U+
qindexidx_messages_tomessagesCREATE INDEX idx_messages_to ON messages(to_agent)[/
yindexidx_messages_frommessagesCREATE INDEX idx_messages_from ON messages(from_agent)S/
mindexidx_agents_statusagentsCREATE INDEX idx_agents_status ON agents(status))=
indexsqlite_autoindex_tasks_1tasks�?
�]tabletaskstasksCREATE TABLE tasks ( id TEXT PRIMARY KEY, milestone_id TEXT, project_id TEXT NOT NULL, title TEXT NOT NULL, description TEXT, status TEXT DEFAULT 'pending', assigned_to TEXT, priority INTEGER DEFAULT 5, metadata TEXT, -- JSON object created INTEGER NOT NULL, completed_at INTEGER, FOREIGN KEY (milestone_id) REFERENCES milestones(id), FOREIGN KEY (project_id) REFERENCES projects(id), FOREIGN KEY (assigned_to) REFERENCES agents(id) )3 G!
indexsqlite_autoindex_milestones_1milestones�!!
�{tablemilestonesmilestones CREATE TABLE milestones ( id TEXT PRIMARY KEY, project_id TEXT NOT NULL, title TEXT NOT NULL, description TEXT, status TEXT DEFAULT 'pending', due_date INTEGER, completed_at INTEGER, metadata TEXT, -- JSON object created INTEGER NOT NULL, FOREIGN KEY (project_id) REFERENCES projects(id) )/C
indexsqlite_autoindex_services_1services2~r%���OM~��ⴊ 33~r%���Os���~ߧ0 
~r%���OH��� �3aSQLite format 3@ 6
.�*
��\ ] � �.�^�
�3
�
?�U+
qindexidx_messages_tomessagesCREATE INDEX idx_messages_to ON messages(to_agent)[/
yindexidx_messages_frommessagesCREATE INDEX idx_messages_from ON messages(from_agent)S/
mindexidx_agents_statusagentsCREATE INDEX idx_agents_status ON agents(status)�?
�]tabletaskstasksCREATE TABLE tasks ( id TEXT PRIMARY KEY, milestone_id TEXT, project_id TEXT NOT NULL, title TEXT NOT NULL, description TEXT, status TEXT DEFAULT 'pending', assigned_to TEXT, priority INTEGER DEFAULT 5, metadata TEXT, -- JSON object created INTEGER NOT NULL, completed_at INTEGER, FOREIGN KEY (milestone_id) REFERENCES milestones(id), FOREIGN KEY (project_id) REFERENCES projects(id), FOREIGN KEY (assigned_to) REFERENCES agents(id) ))=
indexsqlite_autoindex_tasks_1tasks�!!
�{tablemilestonesmilestones CREATE TABLE milestones ( id TEXT PRIMARY KEY, project_id TEXT NOT NULL, title TEXT NOT NULL, description TEXT, status TEXT DEFAULT 'pending', due_date INTEGER, completed_at INTEGER, metadata TEXT, -- JSON object created INTEGER NOT NULL, FOREIGN KEY (project_id) REFERENCES projects(id) )3 G!
indexsqlite_autoindex_milestones_1milestones�3 
�9tableservicesservicesCREATE TABLE services ( id TEXT PRIMARY KEY, name TEXT NOT NULL, type TEXT NOT NULL, -- api, database, queue, etc. endpoint TEXT, status TEXT DEFAULT 'unknown', health_check_url TEXT, last_check INTEGER, response_time_ms INTEGER, metadata TEXT, -- JSON object created INTEGER NOT NULL, updated INTEGER NOT NULL )/C
indexsqlite_autoindex_services_1services� 
�mtableprojectsprojectsCREATE TABLE projects ( id TEXT PRIMARY KEY, name TEXT NOT NULL, path TEXT NOT NULL UNIQUE, description TEXT, type TEXT, -- git, npm, python, etc. status TEXT DEFAULT 'active', metadata TEXT, -- JSON object (git info, dependencies, etc.) created INTEGER NOT NULL, updated INTEGER NOT NULL )/ C
indexsqlite_autoindex_projects_2projects /C
indexsqlite_autoindex_projects_1projects �S
�ytablememoriesmemoriesCREATE TABLE memories ( id TEXT PRIMARY KEY, content TEXT NOT NULL, type TEXT NOT NULL CHECK (type IN ('fact', 'insight', 'experience', 'error')), embedding BLOB, -- Vector embedding agent_id TEXT, project_id TEXT, relevance_score REAL DEFAULT 1.0, access_count INTEGER DEFAULT 0, last_accessed INTEGER, metadata TEXT, -- JSON object created INTEGER NOT NULL, FOREIGN KEY (agent_id) REFERENCES agents(id), FOREIGN KEY (project_id) REFERENCES projects(id) )/C
indexsqlite_autoindex_memories_1memories�K
�itablemessagesmessagesCREATE TABLE messages ( id TEXT PRIMARY KEY, from_agent TEXT NOT NULL, to_agent TEXT, -- NULL for broadcasts content TEXT NOT NULL, channel TEXT, timestamp INTEGER NOT NULL, message_type TEXT NOT NULL DEFAULT 'message', metadata TEXT, -- JSON object FOREIGN KEY (from_agent) REFERENCES agents(id), FOREIGN KEY (to_agent) REFERENCES agents(id) )/C
indexsqlite_autoindex_messages_1messages�;

�QtableagentsagentsCREATE TABLE agents ( id TEXT PRIMARY KEY, name TEXT NOT NULL, status TEXT NOT NULL DEFAULT 'online', capabilities TEXT NOT NULL, -- JSON array last_seen INTEGER NOT NULL, metadata TEXT, -- JSON object created INTEGER NOT NULL )+?
indexsqlite_autoindex_agents_1agents ~r%���O}��h��� 82�4 ���= � � " � e �N��@�2j)�t--
�tableproject_mappingsproject_mappings4CREATE TABLE project_mappings ( id TEXT PRIMARY KEY, name TEXT NOT NULL, base_path TEXT NOT NULL UNIQUE, discord_channel_id TEXT, websocket_port INTEGER, session_id TEXT, pid INTEGER, is_active INTEGER DEFAULT 1, child_paths TEXT NOT NULL DEFAULT '[]', -- JSON array metadata TEXT, -- JSON object created INTEGER NOT NULL, last_access INTEGER NOT NULL )? S-
indexsqlite_autoindex_project_mappings_2project_mappings6?S-
indexsqlite_autoindex_project_mappings_1project_mappings5�]
�tablephasesphases2CREATE TABLE phases ( id TEXT PRIMARY KEY, project_name TEXT NOT NULL, project_path TEXT, timestamp INTEGER NOT NULL, action_items TEXT NOT NULL, -- JSON array design_logic TEXT NOT NULL, agents_used TEXT NOT NULL, supporting_documents TEXT NOT NULL, -- JSON array next_steps TEXT NOT NULL, status TEXT NOT NULL DEFAULT 'PENDING' CHECK (status IN ('PENDING', 'IN_PROGRESS', 'COMPLETE')), metadata TEXT, -- JSON object created INTEGER NOT NULL, updated INTEGER NOT NULL )+?
indexsqlite_autoindex_phases_1phases3X1
windexidx_tasks_assignedtasksCREATE INDEX idx_tasks_assigned ON tasks(assigned_to)U/
sindexidx_tasks_projecttasksCREATE INDEX idx_tasks_project ON tasks(project_id)[3
uindexidx_services_statusservicesCREATE INDEX idx_services_status ON services(status)[3
uindexidx_projects_statusprojectsCREATE INDEX idx_projects_status ON projects(status)U/
mindexidx_memories_typememoriesCREATE INDEX idx_memories_type ON memories(type)a5
indexidx_memories_projectmemoriesCREATE INDEX idx_memories_project ON memories(project_id)[1
windexidx_memories_agentmemoriesCREATE INDEX idx_memories_agent ON memories(agent_id)^5
yindexidx_messages_channelmessagesCREATE INDEX idx_messages_channel ON messages(channel)e9
�
indexidx_messages_timestampmessagesCREATE INDEX idx_messages_timestamp ON messages(timestamp)U+
qindexidx_messages_tomessagesCREATE INDEX idx_messages_to ON messages(to_agent)[/
yindexidx_messages_frommessagesCREATE INDEX idx_messages_from ON messages(from_agent)S/
mindexidx_agents_statusagentsCREATE INDEX idx_agents_status ON agents(status))=
indexsqlite_autoindex_tasks_1tasks�?
�]tabletaskstasksCREATE TABLE tasks ( id TEXT PRIMARY KEY, milestone_id TEXT, project_id TEXT NOT NULL, title TEXT NOT NULL, description TEXT, status TEXT DEFAULT 'pending', assigned_to TEXT, priority INTEGER DEFAULT 5, metadata TEXT, -- JSON object created INTEGER NOT NULL, completed_at INTEGER, FOREIGN KEY (milestone_id) REFERENCES milestones(id), FOREIGN KEY (project_id) REFERENCES projects(id), FOREIGN KEY (assigned_to) REFERENCES agents(id) )3 G!
indexsqlite_autoindex_milestones_1milestones�!!
�{tablemilestonesmilestones CREATE TABLE milestones ( id TEXT PRIMARY KEY, project_id TEXT NOT NULL, title TEXT NOT NULL, description TEXT, status TEXT DEFAULT 'pending', due_date INTEGER, completed_at INTEGER, metadata TEXT, -- JSON object created INTEGER NOT NULL, FOREIGN KEY (project_id) REFERENCES projects(id) )/C
indexsqlite_autoindex_services_1services4~r%���OT��'5 5~r%���OP���p� 66~r%���Owŷ�諜� 
~r%���O2!�c!�fSQLite format 3@ 8
.�*
��\ ] � �.�^�
�3
�
?�U+
qindexidx_messages_tomessagesCREATE INDEX idx_messages_to ON messages(to_agent)[/
yindexidx_messages_frommessagesCREATE INDEX idx_messages_from ON messages(from_agent)S/
mindexidx_agents_statusagentsCREATE INDEX idx_agents_status ON agents(status)�?
�]tabletaskstasksCREATE TABLE tasks ( id TEXT PRIMARY KEY, milestone_id TEXT, project_id TEXT NOT NULL, title TEXT NOT NULL, description TEXT, status TEXT DEFAULT 'pending', assigned_to TEXT, priority INTEGER DEFAULT 5, metadata TEXT, -- JSON object created INTEGER NOT NULL, completed_at INTEGER, FOREIGN KEY (milestone_id) REFERENCES milestones(id), FOREIGN KEY (project_id) REFERENCES projects(id), FOREIGN KEY (assigned_to) REFERENCES agents(id) ))=
indexsqlite_autoindex_tasks_1tasks�!!
�{tablemilestonesmilestones CREATE TABLE milestones ( id TEXT PRIMARY KEY, project_id TEXT NOT NULL, title TEXT NOT NULL, description TEXT, status TEXT DEFAULT 'pending', due_date INTEGER, completed_at INTEGER, metadata TEXT, -- JSON object created INTEGER NOT NULL, FOREIGN KEY (project_id) REFERENCES projects(id) )3 G!
indexsqlite_autoindex_milestones_1milestones�3 
�9tableservicesservicesCREATE TABLE services ( id TEXT PRIMARY KEY, name TEXT NOT NULL, type TEXT NOT NULL, -- api, database, queue, etc. endpoint TEXT, status TEXT DEFAULT 'unknown', health_check_url TEXT, last_check INTEGER, response_time_ms INTEGER, metadata TEXT, -- JSON object created INTEGER NOT NULL, updated INTEGER NOT NULL )/C
indexsqlite_autoindex_services_1services� 
�mtableprojectsprojectsCREATE TABLE projects ( id TEXT PRIMARY KEY, name TEXT NOT NULL, path TEXT NOT NULL UNIQUE, description TEXT, type TEXT, -- git, npm, python, etc. status TEXT DEFAULT 'active', metadata TEXT, -- JSON object (git info, dependencies, etc.) created INTEGER NOT NULL, updated INTEGER NOT NULL )/ C
indexsqlite_autoindex_projects_2projects /C
indexsqlite_autoindex_projects_1projects �S
�ytablememoriesmemoriesCREATE TABLE memories ( id TEXT PRIMARY KEY, content TEXT NOT NULL, type TEXT NOT NULL CHECK (type IN ('fact', 'insight', 'experience', 'error')), embedding BLOB, -- Vector embedding agent_id TEXT, project_id TEXT, relevance_score REAL DEFAULT 1.0, access_count INTEGER DEFAULT 0, last_accessed INTEGER, metadata TEXT, -- JSON object created INTEGER NOT NULL, FOREIGN KEY (agent_id) REFERENCES agents(id), FOREIGN KEY (project_id) REFERENCES projects(id) )/C
indexsqlite_autoindex_memories_1memories�K
�itablemessagesmessagesCREATE TABLE messages ( id TEXT PRIMARY KEY, from_agent TEXT NOT NULL, to_agent TEXT, -- NULL for broadcasts content TEXT NOT NULL, channel TEXT, timestamp INTEGER NOT NULL, message_type TEXT NOT NULL DEFAULT 'message', metadata TEXT, -- JSON object FOREIGN KEY (from_agent) REFERENCES agents(id), FOREIGN KEY (to_agent) REFERENCES agents(id) )/C
indexsqlite_autoindex_messages_1messages�;

�QtableagentsagentsCREATE TABLE agents ( id TEXT PRIMARY KEY, name TEXT NOT NULL, status TEXT NOT NULL DEFAULT 'online', capabilities TEXT NOT NULL, -- JSON array last_seen INTEGER NOT NULL, metadata TEXT, -- JSON object created INTEGER NOT NULL )+?
indexsqlite_autoindex_agents_1agents ~r%���O��B~ss� 88�4 ���= � � " � e �N��@�2j)8
�F!
�_tablesessionssessions7CREATE TABLE sessions ( id TEXT PRIMARY KEY, project_id TEXT NOT NULL, agent_ids TEXT NOT NULL DEFAULT '[]', -- JSON array websocket_port INTEGER, discord_channel_id TEXT, is_active INTEGER DEFAULT 1, metadata TEXT, -- JSON object created INTEGER NOT NULL, last_activity INTEGER NOT NULL, FOREIGN KEY (project_id) REFERENCES projects(id) )/"C
indexsqlite_autoindex_sessions_1sessions8�t--
�tableproject_mappingsproject_mappings4CREATE TABLE project_mappings ( id TEXT PRIMARY KEY, name TEXT NOT NULL, base_path TEXT NOT NULL UNIQUE, discord_channel_id TEXT, websocket_port INTEGER, session_id TEXT, pid INTEGER, is_active INTEGER DEFAULT 1, child_paths TEXT NOT NULL DEFAULT '[]', -- JSON array metadata TEXT, -- JSON object created INTEGER NOT NULL, last_access INTEGER NOT NULL )? S-
indexsqlite_autoindex_project_mappings_2project_mappings6?S-
indexsqlite_autoindex_project_mappings_1project_mappings5�]
�tablephasesphases2CREATE TABLE phases ( id TEXT PRIMARY KEY, project_name TEXT NOT NULL, project_path TEXT, timestamp INTEGER NOT NULL, action_items TEXT NOT NULL, -- JSON array design_logic TEXT NOT NULL, agents_used TEXT NOT NULL, supporting_documents TEXT NOT NULL, -- JSON array next_steps TEXT NOT NULL, status TEXT NOT NULL DEFAULT 'PENDING' CHECK (status IN ('PENDING', 'IN_PROGRESS', 'COMPLETE')), metadata TEXT, -- JSON object created INTEGER NOT NULL, updated INTEGER NOT NULL )+?
indexsqlite_autoindex_phases_1phases3X1
windexidx_tasks_assignedtasksCREATE INDEX idx_tasks_assigned ON tasks(assigned_to)U/
sindexidx_tasks_projecttasksCREATE INDEX idx_tasks_project ON tasks(project_id)[3
uindexidx_services_statusservicesCREATE INDEX idx_services_status ON services(status)[3
uindexidx_projects_statusprojectsCREATE INDEX idx_projects_status ON projects(status)U/
mindexidx_memories_typememoriesCREATE INDEX idx_memories_type ON memories(type)a5
indexidx_memories_projectmemoriesCREATE INDEX idx_memories_project ON memories(project_id)[1
windexidx_memories_agentmemoriesCREATE INDEX idx_memories_agent ON memories(agent_id)^5
yindexidx_messages_channelmessagesCREATE INDEX idx_messages_channel ON messages(channel)e9
�
indexidx_messages_timestampmessagesCREATE INDEX idx_messages_timestamp ON messages(timestamp)U+
qindexidx_messages_tomessagesCREATE INDEX idx_messages_to ON messages(to_agent)[/
yindexidx_messages_frommessagesCREATE INDEX idx_messages_from ON messages(from_agent)S/
mindexidx_agents_statusagentsCREATE INDEX idx_agents_status ON agents(status))=
indexsqlite_autoindex_tasks_1tasks�?
�]tabletaskstasksCREATE TABLE tasks ( id TEXT PRIMARY KEY, milestone_id TEXT, project_id TEXT NOT NULL, title TEXT NOT NULL, description TEXT, status TEXT DEFAULT 'pending', assigned_to TEXT, priority INTEGER DEFAULT 5, metadata TEXT, -- JSON object created INTEGER NOT NULL, completed_at INTEGER, FOREIGN KEY (milestone_id) REFERENCES milestones(id), FOREIGN KEY (project_id) REFERENCES projects(id), FOREIGN KEY (assigned_to) REFERENCES agents(id) )3 G!
indexsqlite_autoindex_milestones_1milestones�!!
�{tablemilestonesmilestones CREATE TABLE milestones ( id TEXT PRIMARY KEY, project_id TEXT NOT NULL, title TEXT NOT NULL, description TEXT, status TEXT DEFAULT 'pending', due_date INTEGER, completed_at INTEGER, metadata TEXT, -- JSON object created INTEGER NOT NULL, FOREIGN KEY (project_id) REFERENCES projects(id) )/C
indexsqlite_autoindex_services_1services7~r%���O����rf 88~r%���O>@�}�Q� 
~r%���O���5⬼=SQLite format 3@ :
.�*
��\ ] � �.�^�
�3
�
?�U+
qindexidx_messages_tomessagesCREATE INDEX idx_messages_to ON messages(to_agent)[/
yindexidx_messages_frommessagesCREATE INDEX idx_messages_from ON messages(from_agent)S/
mindexidx_agents_statusagentsCREATE INDEX idx_agents_status ON agents(status)�?
�]tabletaskstasksCREATE TABLE tasks ( id TEXT PRIMARY KEY, milestone_id TEXT, project_id TEXT NOT NULL, title TEXT NOT NULL, description TEXT, status TEXT DEFAULT 'pending', assigned_to TEXT, priority INTEGER DEFAULT 5, metadata TEXT, -- JSON object created INTEGER NOT NULL, completed_at INTEGER, FOREIGN KEY (milestone_id) REFERENCES milestones(id), FOREIGN KEY (project_id) REFERENCES projects(id), FOREIGN KEY (assigned_to) REFERENCES agents(id) ))=
indexsqlite_autoindex_tasks_1tasks�!!
�{tablemilestonesmilestones CREATE TABLE milestones ( id TEXT PRIMARY KEY, project_id TEXT NOT NULL, title TEXT NOT NULL, description TEXT, status TEXT DEFAULT 'pending', due_date INTEGER, completed_at INTEGER, metadata TEXT, -- JSON object created INTEGER NOT NULL, FOREIGN KEY (project_id) REFERENCES projects(id) )3 G!
indexsqlite_autoindex_milestones_1milestones�3 
�9tableservicesservicesCREATE TABLE services ( id TEXT PRIMARY KEY, name TEXT NOT NULL, type TEXT NOT NULL, -- api, database, queue, etc. endpoint TEXT, status TEXT DEFAULT 'unknown', health_check_url TEXT, last_check INTEGER, response_time_ms INTEGER, metadata TEXT, -- JSON object created INTEGER NOT NULL, updated INTEGER NOT NULL )/C
indexsqlite_autoindex_services_1services� 
�mtableprojectsprojectsCREATE TABLE projects ( id TEXT PRIMARY KEY, name TEXT NOT NULL, path TEXT NOT NULL UNIQUE, description TEXT, type TEXT, -- git, npm, python, etc. status TEXT DEFAULT 'active', metadata TEXT, -- JSON object (git info, dependencies, etc.) created INTEGER NOT NULL, updated INTEGER NOT NULL )/ C
indexsqlite_autoindex_projects_2projects /C
indexsqlite_autoindex_projects_1projects �S
�ytablememoriesmemoriesCREATE TABLE memories ( id TEXT PRIMARY KEY, content TEXT NOT NULL, type TEXT NOT NULL CHECK (type IN ('fact', 'insight', 'experience', 'error')), embedding BLOB, -- Vector embedding agent_id TEXT, project_id TEXT, relevance_score REAL DEFAULT 1.0, access_count INTEGER DEFAULT 0, last_accessed INTEGER, metadata TEXT, -- JSON object created INTEGER NOT NULL, FOREIGN KEY (agent_id) REFERENCES agents(id), FOREIGN KEY (project_id) REFERENCES projects(id) )/C
indexsqlite_autoindex_memories_1memories�K
�itablemessagesmessagesCREATE TABLE messages ( id TEXT PRIMARY KEY, from_agent TEXT NOT NULL, to_agent TEXT, -- NULL for broadcasts content TEXT NOT NULL, channel TEXT, timestamp INTEGER NOT NULL, message_type TEXT NOT NULL DEFAULT 'message', metadata TEXT, -- JSON object FOREIGN KEY (from_agent) REFERENCES agents(id), FOREIGN KEY (to_agent) REFERENCES agents(id) )/C
indexsqlite_autoindex_messages_1messages�;

�QtableagentsagentsCREATE TABLE agents ( id TEXT PRIMARY KEY, name TEXT NOT NULL, status TEXT NOT NULL DEFAULT 'online', capabilities TEXT NOT NULL, -- JSON array last_seen INTEGER NOT NULL, metadata TEXT, -- JSON object created INTEGER NOT NULL )+?
indexsqlite_autoindex_agents_1agents~r%���O׮<Tjm�Y ����\ ] � �.��^3
�
?��e9
�
indexidx_messages_timestampmessagesCREATE INDEX idx_messages_timestamp ON messages(timestamp)U+
qindexidx_messages_tomessagesCREATE INDEX idx_messages_to ON messages(to_agent)[/
yindexidx_messages_frommessagesCREATE INDEX idx_messages_from ON messages(from_agent)S/
mindexidx_agents_statusagentsCREATE INDEX idx_agents_status ON agents(status)�?
�]tabletaskstasksCREATE TABLE task�?
�]tabletaskstasksCREATE TABLE tasks ( id TEXT PRIMARY KEY, milestone_id TEXT, project_id TEXT NOT NULL, title TEXT NOT NULL, description TEXT, status TEXT DEFAULT 'pending', assigned_to TEXT, priority INTEGER DEFAULT 5, metadata TEXT, -- JSON object created INTEGER NOT NULL, completed_at INTEGER, FOREIGN KEY (milestone_id) REFERENCES milestones(id), FOREIGN KEY (project_id) REFERENCES projects(id), FOREIGN KEY (assigned_to) REFERENCES agents(id) )3 G!
indexsqlite_autoindex_milestones_1milestones�!!
�{tablemilestonesmilestones CREATE TABLE milestones ( id TEXT PRIMARY KEY, project_id TEXT NOT NULL, title TEXT NOT NULL, description TEXT, status TEXT DEFAULT 'pending', due_date INTEGER, completed_at INTEGER, metadata TEXT, -- JSON object created INTEGER NOT NULL, FOREIGN KEY (project_id) REFERENCES projects(id) )�3 
�9tableservicesservicesCREATE TABLE services ( id TEXT PRIMARY KEY, name TEXT NOT NULL, type TEXT NOT NULL, -- api, database, queue, etc. endpoint TEXT, status TEXT DEFAULT 'unknown', health_check_url TEXT, last_check INTEGER, response_time_ms INTEGER, metadata TEXT, -- JSON object created INTEGER NOT NULL, updated INTEGER NOT NULL )/C
indexsqlite_autoindex_services_1services� 
�mtableprojectsprojectsCREATE TABLE projects ( id TEXT PRIMARY KEY, name TEXT NOT NULL, path TEXT NOT NULL UNIQUE, description TEXT, type TEXT, -- git, npm, python, etc. status TEXT DEFAULT 'active', metadata TEXT, -- JSON object (git info, dependencies, etc.) created INTEGER NOT NULL, updated INTEGER NOT NULL )/ C
indexsqlite_autoindex_projects_2projects /C
indexsqlite_autoindex_projects_1projects �S
�ytablememoriesmemoriesCREATE TABLE memories ( id TEXT PRIMARY KEY, content TEXT NOT NULL, type TEXT NOT NULL CHECK (type IN ('fact', 'insight', 'experience', 'error')), embedding BLOB, -- Vector embedding agent_id TEXT, project_id TEXT, relevance_score REAL DEFAULT 1.0, access_count INTEGER DEFAULT 0, last_accessed INTEGER, metadata TEXT, -- JSON object created INTEGER NOT NULL, FOREIGN KEY (agent_id) REFERENCES agents(id), FOREIGN KEY (project_id) REFERENCES projects(id) )/C
indexsqlite_autoindex_memories_1memories�K
�itablemessagesmessagesCREATE TABLE messages ( id TEXT PRIMARY KEY, from_agent TEXT NOT NULL, to_agent TEXT, -- NULL for broadcasts content TEXT NOT NULL, channel TEXT, timestamp INTEGER NOT NULL, message_type TEXT NOT NULL DEFAULT 'message', metadata TEXT, -- JSON object FOREIGN KEY (from_agent) REFERENCES agents(id), FOREIGN KEY (to_agent) REFERENCES agents(id) )/C
indexsqlite_autoindex_messages_1messages�;

�QtableagentsagentsCREATE TABLE agents ( id TEXT PRIMARY KEY, name TEXT NOT NULL, status TEXT NOT NULL DEFAULT 'online', capabilities TEXT NOT NULL, -- JSON array last_seen INTEGER NOT NULL, metadata TEXT, -- JSON object created INTEGER NOT NULL )+?
indexsqlite_autoindex_agents_1agents~r%���O�ƏI�� 88�= � � " � e �N��@�2j)8
��
�F!
�_tablesessionssessions7CREATE TABLE sessions ( id TEXT PRIMARY KEY, project_id TEXT NOT NULL, agent_ids TEXT NOT NULL DEFAULT '[]', -- JSON array websocket_port INTEGER, discord_channel_id TEXT, is_active INTEGER DEFAULT 1, metadata TEXT, -- JSON object created INTEGER NOT NULL, last_activity INTEGER NOT NULL, FOREIGN KEY (project_id) REFERENCES projects(id) )/"C
indexsqlite_autoindex_sessions_1sessions8�t--
�tableproject_mappingsproject_mappings4CREATE TABLE project_mappings ( id TEXT PRIMARY KEY, name TEXT NOT NULL, base_path TEXT NOT NULL UNIQUE, discord_channel_id TEXT, websocket_port INTEGER, session_id TEXT, pid INTEGER, is_active INTEGER DEFAULT 1, child_paths TEXT NOT NULL DEFAULT '[]', -- JSON array metadata TEXT, -- JSON object created INTEGER NOT NULL, last_access INTEGER NOT NULL )? S-
indexsqlite_autoindex_project_mappings_2project_mappings6?S-
indexsqlite_autoindex_project_mappings_1project_mappings5�]
�tablephasesphases2CREATE TABLE phases ( id TEXT PRIMARY KEY, project_name TEXT NOT NULL, project_path TEXT, timestamp INTEGER NOT NULL, action_items TEXT NOT NULL, -- JSON array design_logic TEXT NOT NULL, agents_used TEXT NOT NULL, supporting_documents TEXT NOT NULL, -- JSON array next_steps TEXT NOT NULL, status TEXT NOT NULL DEFAULT 'PENDING' CHECK (status IN ('PENDING', 'IN_PROGRESS', 'COMPLETE')), metadata TEXT, -- JSON object created INTEGER NOT NULL, updated INTEGER NOT NULL )+?
indexsqlite_autoindex_phases_1phases3�X1
windexidx_tasks_assignedtasksCREATE INDEX idx_tasks_assigned ON tasks(assigned_to)U/
sindexidx_tasks_projecttasksCREATE INDEX idx_tasks_project ON tasks(project_id)[3
uindexidx_services_statusservicesCREATE INDEX idx_services_status ON services(status)[3
uindexidx_projects_statusprojectsCREATE INDEX idx_projects_status ON projects(status)U/
mindexidx_memories_typememoriesCREATE INDEX idx_memories_type ON memories(type)a5
indexidx_memories_projectmemoriesCREATE INDEX idx_memories_project ON memories(project_id)[1
windexidx_memories_agentmemoriesCREATE INDEX idx_memories_agent ON memories(agent_id)^5
yindexidx_messages_channelmessagesCREATE INDEX idx_messages_channel ON messages(channel)e9
�
indexidx_messages_timestampmessagesCREATE INDEX idx_messages_timestamp ON messages(timestamp)U+
qindexidx_messages_tomessagesCREATE INDEX idx_messages_to ON messages(to_agent)[/
yindexidx_messages_frommessagesCREATE INDEX idx_messages_from ON messages(from_agent)S/
mindexidx_agents_statusagentsCREATE INDEX idx_agents_status ON agents(status))=
indexsqlite_autoindex_tasks_1tasks
�
�]tabletaskstasksCREATE TABLE tasks ( id TEXT PRIMARY KEY, milestone_id TEXT, project_id TEXT NOT NULL, title TEXT NOT NULL, description TEXT, status TEXT DEFAULT 'pending', assigned_to TEXT, priority INTEGER DEFAULT 5, metadata TEXT, -- JSON object created INTEGER NOT NULL, completed_at INTEGER, FOREIGN KEY (milestone_id) REFERENCES milestones(id�##CC
�Mtableproject_context_resolutionsproject_context_resolutions9CREATE TABLE project_context_resolutions ( id TEXT PRIMARY KEY, working_directory TEXT NOT NULL, project_id TEXT NOT NULL, resolved_project_path TEXT NOT NULL, hierarchy_depth INTEGER DEFAULT 0, resolution_time_ms INTEGER, agent_id TEXT, created INTEGER NOT NULL, expires INTEGER NOT NULL, FOREIGN KEY (project_id) REFERENCES projects(id), FOREIGN KEY (agent_id) REFERENCES agents(id) )U$iC
indexsqlite_autoindex_project_context_resolutions_1project_context_resolutions:9~r%���O�b��[�1� ::~r%���O�*�U��%� 
~r%���O��r�x�SQLite format 3@ ;
.�*
��\ ] � �.�^�
�3
�
?�U+
qindexidx_messages_tomessagesCREATE INDEX idx_messages_to ON messages(to_agent)[/
yindexidx_messages_frommessagesCREATE INDEX idx_messages_from ON messages(from_agent)S/
mindexidx_agents_statusagentsCREATE INDEX idx_agents_status ON agents(status)�?
�]tabletaskstasksCREATE TABLE tasks ( id TEXT PRIMARY KEY, milestone_id TEXT, project_id TEXT NOT NULL, title TEXT NOT NULL, description TEXT, status TEXT DEFAULT 'pending', assigned_to TEXT, priority INTEGER DEFAULT 5, metadata TEXT, -- JSON object created INTEGER NOT NULL, completed_at INTEGER, FOREIGN KEY (milestone_id) REFERENCES milestones(id), FOREIGN KEY (project_id) REFERENCES projects(id), FOREIGN KEY (assigned_to) REFERENCES agents(id) ))=
indexsqlite_autoindex_tasks_1tasks�!!
�{tablemilestonesmilestones CREATE TABLE milestones ( id TEXT PRIMARY KEY, project_id TEXT NOT NULL, title TEXT NOT NULL, description TEXT, status TEXT DEFAULT 'pending', due_date INTEGER, completed_at INTEGER, metadata TEXT, -- JSON object created INTEGER NOT NULL, FOREIGN KEY (project_id) REFERENCES projects(id) )3 G!
indexsqlite_autoindex_milestones_1milestones�3 
�9tableservicesservicesCREATE TABLE services ( id TEXT PRIMARY KEY, name TEXT NOT NULL, type TEXT NOT NULL, -- api, database, queue, etc. endpoint TEXT, status TEXT DEFAULT 'unknown', health_check_url TEXT, last_check INTEGER, response_time_ms INTEGER, metadata TEXT, -- JSON object created INTEGER NOT NULL, updated INTEGER NOT NULL )/C
indexsqlite_autoindex_services_1services� 
�mtableprojectsprojectsCREATE TABLE projects ( id TEXT PRIMARY KEY, name TEXT NOT NULL, path TEXT NOT NULL UNIQUE, description TEXT, type TEXT, -- git, npm, python, etc. status TEXT DEFAULT 'active', metadata TEXT, -- JSON object (git info, dependencies, etc.) created INTEGER NOT NULL, updated INTEGER NOT NULL )/ C
indexsqlite_autoindex_projects_2projects /C
indexsqlite_autoindex_projects_1projects �S
�ytablememoriesmemoriesCREATE TABLE memories ( id TEXT PRIMARY KEY, content TEXT NOT NULL, type TEXT NOT NULL CHECK (type IN ('fact', 'insight', 'experience', 'error')), embedding BLOB, -- Vector embedding agent_id TEXT, project_id TEXT, relevance_score REAL DEFAULT 1.0, access_count INTEGER DEFAULT 0, last_accessed INTEGER, metadata TEXT, -- JSON object created INTEGER NOT NULL, FOREIGN KEY (agent_id) REFERENCES agents(id), FOREIGN KEY (project_id) REFERENCES projects(id) )/C
indexsqlite_autoindex_memories_1memories�K
�itablemessagesmessagesCREATE TABLE messages ( id TEXT PRIMARY KEY, from_agent TEXT NOT NULL, to_agent TEXT, -- NULL for broadcasts content TEXT NOT NULL, channel TEXT, timestamp INTEGER NOT NULL, message_type TEXT NOT NULL DEFAULT 'message', metadata TEXT, -- JSON object FOREIGN KEY (from_agent) REFERENCES agents(id), FOREIGN KEY (to_agent) REFERENCES agents(id) )/C
indexsqlite_autoindex_messages_1messages�;

�QtableagentsagentsCREATE TABLE agents ( id TEXT PRIMARY KEY, name TEXT NOT NULL, status TEXT NOT NULL DEFAULT 'online', capabilities TEXT NOT NULL, -- JSON array last_seen INTEGER NOT NULL, metadata TEXT, -- JSON object created INTEGER NOT NULL )+?
indexsqlite_autoindex_agents_1agents~r%���O2^wK 88�= � � " � e �N��@�2j)8
�� &
�F!
�_tablesessionssessions7CREATE TABLE sessions ( id TEXT PRIMARY KEY, project_id TEXT NOT NULL, agent_ids TEXT NOT NULL DEFAULT '[]', -- JSON array websocket_port INTEGER, discord_channel_id TEXT, is_active INTEGER DEFAULT 1, metadata TEXT, -- JSON object created INTEGER NOT NULL, last_activity INTEGER NOT NULL, FOREIGN KEY (project_id) REFERENCES projects(id) )/"C
indexsqlite_autoindex_sessions_1sessions8�t--
�tableproject_mappingsproject_mappings4CREATE TABLE project_mappings ( id TEXT PRIMARY KEY, name TEXT NOT NULL, base_path TEXT NOT NULL UNIQUE, discord_channel_id TEXT, websocket_port INTEGER, session_id TEXT, pid INTEGER, is_active INTEGER DEFAULT 1, child_paths TEXT NOT NULL DEFAULT '[]', -- JSON array metadata TEXT, -- JSON object created INTEGER NOT NULL, last_access INTEGER NOT NULL )? S-
indexsqlite_autoindex_project_mappings_2project_mappings6?S-
indexsqlite_autoindex_project_mappings_1project_mappings5�]
�tablephasesphases2CREATE TABLE phases ( id TEXT PRIMARY KEY, project_name TEXT NOT NULL, project_path TEXT, timestamp INTEGER NOT NULL, action_items TEXT NOT NULL, -- JSON array design_logic TEXT NOT NULL, agents_used TEXT NOT NULL, supporting_documents TEXT NOT NULL, -- JSON array next_steps TEXT NOT NULL, status TEXT NOT NULL DEFAULT 'PENDING' CHECK (status IN ('PENDING', 'IN_PROGRESS', 'COMPLETE')), metadata TEXT, -- JSON object created INTEGER NOT NULL, updated INTEGER NOT NULL )+?
indexsqlite_autoindex_phases_1phases3�X1
windexidx_tasks_assignedtasksCREATE INDEX idx_tasks_assigned ON tasks(assigned_to)U/
sindexidx_tasks_projecttasksCREATE INDEX idx_tasks_project ON tasks(project_id)[3
uindexidx_services_statusservicesCREATE INDEX idx_services_status ON services(status)[3
uindexidx_projects_statusprojectsCREATE INDEX idx_projects_status ON projects(status)U/
mindexidx_memories_typememoriesCREATE INDEX idx_memories_type ON memories(type)a5
indexidx_memories_projectmemoriesCREATE INDEX idx_memories_project ON memories(project_id)[1
windexidx_memories_agentmemoriesCREATE INDEX idx_memories_agent ON memories(agent_id)^5
yindexidx_messages_channelmessagesCREATE INDEX idx_messages_channel ON messages(channel)e9
�
indexidx_messages_timestampmessagesCREATE INDEX idx_messages_timestamp ON messages(timestamp)U+
qindexidx_messages_tomessagesCREATE INDEX idx_messages_to ON messages(to_agent)[/
yindexidx_messages_frommessagesCREATE INDEX idx_messages_from ON messages(from_agent)S/
mindexidx_agents_statusagentsCREATE INDEX idx_agents_status ON agents(status))=
indexsqlite_autoindex_tasks_1tasks
i
�]tabletaskstasksCREATE TABLE tasks ( id TEXT PRIMARY KEY, milestone_id TEXT, project_id TEXT NOT NULL, title TEXT NOT NULL, description TEXT, status TEXT DEFAULT 'pending', assigned_to TEXT, priority INTEGER DEFAULT 5, metadata TEXT, -- JSON object created INTEGER NOT NU[%1
{indexidx_phases_projectphases;CREATE INDEX idx_phases_project ON phases(project_name)�##CC
�Mtableproject_context_resolutionsproject_context_resolutions9CREATE TABLE project_context_resolutions ( id TEXT PRIMARY KEY, working_directory TEXT NOT NULL, project_id TEXT NOT NULL, resolved_project_path TEXT NOT NULL, hierarchy_depth INTEGER DEFAULT 0, resolution_time_ms INTEGER, agent_id TEXT, created INTEGER NOT NULL, expires INTEGER NOT NULL, FOREIGN KEY (project_id) REFERENCES projects(id), FOREIGN KEY (agent_id) REFERENCES agents(id) )U$iC
indexsqlite_autoindex_project_context_resolutions_1project_context_resolutions:;;~r%���O�K~�� 
~r%���O#i�����SQLite format 3@ <
.�*
��\ ] � �.�^�
�3
�
?�U+
qindexidx_messages_tomessagesCREATE INDEX idx_messages_to ON messages(to_agent)[/
yindexidx_messages_frommessagesCREATE INDEX idx_messages_from ON messages(from_agent)S/
mindexidx_agents_statusagentsCREATE INDEX idx_agents_status ON agents(status)�?
�]tabletaskstasksCREATE TABLE tasks ( id TEXT PRIMARY KEY, milestone_id TEXT, project_id TEXT NOT NULL, title TEXT NOT NULL, description TEXT, status TEXT DEFAULT 'pending', assigned_to TEXT, priority INTEGER DEFAULT 5, metadata TEXT, -- JSON object created INTEGER NOT NULL, completed_at INTEGER, FOREIGN KEY (milestone_id) REFERENCES milestones(id), FOREIGN KEY (project_id) REFERENCES projects(id), FOREIGN KEY (assigned_to) REFERENCES agents(id) ))=
indexsqlite_autoindex_tasks_1tasks�!!
�{tablemilestonesmilestones CREATE TABLE milestones ( id TEXT PRIMARY KEY, project_id TEXT NOT NULL, title TEXT NOT NULL, description TEXT, status TEXT DEFAULT 'pending', due_date INTEGER, completed_at INTEGER, metadata TEXT, -- JSON object created INTEGER NOT NULL, FOREIGN KEY (project_id) REFERENCES projects(id) )3 G!
indexsqlite_autoindex_milestones_1milestones�3 
�9tableservicesservicesCREATE TABLE services ( id TEXT PRIMARY KEY, name TEXT NOT NULL, type TEXT NOT NULL, -- api, database, queue, etc. endpoint TEXT, status TEXT DEFAULT 'unknown', health_check_url TEXT, last_check INTEGER, response_time_ms INTEGER, metadata TEXT, -- JSON object created INTEGER NOT NULL, updated INTEGER NOT NULL )/C
indexsqlite_autoindex_services_1services� 
�mtableprojectsprojectsCREATE TABLE projects ( id TEXT PRIMARY KEY, name TEXT NOT NULL, path TEXT NOT NULL UNIQUE, description TEXT, type TEXT, -- git, npm, python, etc. status TEXT DEFAULT 'active', metadata TEXT, -- JSON object (git info, dependencies, etc.) created INTEGER NOT NULL, updated INTEGER NOT NULL )/ C
indexsqlite_autoindex_projects_2projects /C
indexsqlite_autoindex_projects_1projects �S
�ytablememoriesmemoriesCREATE TABLE memories ( id TEXT PRIMARY KEY, content TEXT NOT NULL, type TEXT NOT NULL CHECK (type IN ('fact', 'insight', 'experience', 'error')), embedding BLOB, -- Vector embedding agent_id TEXT, project_id TEXT, relevance_score REAL DEFAULT 1.0, access_count INTEGER DEFAULT 0, last_accessed INTEGER, metadata TEXT, -- JSON object created INTEGER NOT NULL, FOREIGN KEY (agent_id) REFERENCES agents(id), FOREIGN KEY (project_id) REFERENCES projects(id) )/C
indexsqlite_autoindex_memories_1memories�K
�itablemessagesmessagesCREATE TABLE messages ( id TEXT PRIMARY KEY, from_agent TEXT NOT NULL, to_agent TEXT, -- NULL for broadcasts content TEXT NOT NULL, channel TEXT, timestamp INTEGER NOT NULL, message_type TEXT NOT NULL DEFAULT 'message', metadata TEXT, -- JSON object FOREIGN KEY (from_agent) REFERENCES agents(id), FOREIGN KEY (to_agent) REFERENCES agents(id) )/C
indexsqlite_autoindex_messages_1messages�;

�QtableagentsagentsCREATE TABLE agents ( id TEXT PRIMARY KEY, name TEXT NOT NULL, status TEXT NOT NULL DEFAULT 'online', capabilities TEXT NOT NULL, -- JSON array last_seen INTEGER NOT NULL, metadata TEXT, -- JSON object created INTEGER NOT NULL )+?
indexsqlite_autoindex_agents_1agents~r%���Oj���"1� 88�= � � " � e �N��@�2j)8
�� &уF!
�_tablesessionssessions7CREATE TABLE sessions ( id TEXT PRIMARY KEY, project_id TEXT NOT NULL, agent_ids TEXT NOT NULL DEFAULT '[]', -- JSON array websocket_port INTEGER, discord_channel_id TEXT, is_active INTEGER DEFAULT 1, metadata TEXT, -- JSON object created INTEGER NOT NULL, last_activity INTEGER NOT NULL, FOREIGN KEY (project_id) REFERENCES projects(id) )/"C
indexsqlite_autoindex_sessions_1sessions8�t--
�tableproject_mappingsproject_mappings4CREATE TABLE project_mappings ( id TEXT PRIMARY KEY, name TEXT NOT NULL, base_path TEXT NOT NULL UNIQUE, discord_channel_id TEXT, websocket_port INTEGER, session_id TEXT, pid INTEGER, is_active INTEGER DEFAULT 1, child_paths TEXT NOT NULL DEFAULT '[]', -- JSON array metadata TEXT, -- JSON object created INTEGER NOT NULL, last_access INTEGER NOT NULL )? S-
indexsqlite_autoindex_project_mappings_2project_mappings6?S-
indexsqlite_autoindex_project_mappings_1project_mappings5�]
�tablephasesphases2CREATE TABLE phases ( id TEXT PRIMARY KEY, project_name TEXT NOT NULL, project_path TEXT, timestamp INTEGER NOT NULL, action_items TEXT NOT NULL, -- JSON array design_logic TEXT NOT NULL, agents_used TEXT NOT NULL, supporting_documents TEXT NOT NULL, -- JSON array next_steps TEXT NOT NULL, status TEXT NOT NULL DEFAULT 'PENDING' CHECK (status IN ('PENDING', 'IN_PROGRESS', 'COMPLETE')), metadata TEXT, -- JSON object created INTEGER NOT NULL, updated INTEGER NOT NULL )+?
indexsqlite_autoindex_phases_1phases3�X1
windexidx_tasks_assignedtasksCREATE INDEX idx_tasks_assigned ON tasks(assigned_to)U/
sindexidx_tasks_projecttasksCREATE INDEX idx_tasks_project ON tasks(project_id)[3
uindexidx_services_statusservicesCREATE INDEX idx_services_status ON services(status)[3
uindexidx_projects_statusprojectsCREATE INDEX idx_projects_status ON projects(status)U/
mindexidx_memories_typememoriesCREATE INDEX idx_memories_type ON memories(type)a5
indexidx_memories_projectmemoriesCREATE INDEX idx_memories_project ON memories(project_id)[1
windexidx_memories_agentmemoriesCREATE INDEX idx_memories_agent ON memories(agent_id)^5
yindexidx_messages_channelmessagesCREATE INDEX idx_messages_channel ON messages(channel)e9
�
indexidx_messages_timestampmessagesCREATE INDEX idx_messages_timestamp ON messages(timestamp)U+
qindexidx_messages_tomessagesCREATE INDEX idx_messages_to ON messages(to_agent)[/
yindexidx_messages_frommessagesCREATE INDEX idx_messages_from ON messages(from_agent)S/
mindexidx_agents_statusagentsCREATE INDEX idx_agents_status ON agents(status))=
indexsqlite_autoindex_tasks_1tasks

�]tabletaskstasksCREATE TABLE tasks ( id TEXT PRIMARY KEY, milestone_id TEXT, project_id TEXT NOT NULL, title TEXT NOT NULL, description TEXT, status TEXT DEFAULT 'pending', assigned_to TEXT, priority INS&/
mindexidx_phases_statusphases<CREATE INDEX idx_phases_status ON phases(status)[%1
{indexidx_phases_projectphases;CREATE INDEX idx_phases_project ON phases(project_name)�##CC
�Mtableproject_context_resolutionsproject_context_resolutions9CREATE TABLE project_context_resolutions ( id TEXT PRIMARY KEY, working_directory TEXT NOT NULL, project_id TEXT NOT NULL, resolved_project_path TEXT NOT NULL, hierarchy_depth INTEGER DEFAULT 0, resolution_time_ms INTEGER, agent_id TEXT, created INTEGER NOT NULL, expires INTEGER NOT NULL, FOREIGN KEY (project_id) REFERENCES projects(id), FOREIGN KEY (agent_id) REFERENCES agents(id) )U$iC
indexsqlite_autoindex_project_context_resolutions_1project_context_resolutions:<<~r%���OyIڙA�4� 
~r%���O��`���S�SQLite format 3@ =
.�*
��\ ] � �.�^�
�3
�
?�U+
qindexidx_messages_tomessagesCREATE INDEX idx_messages_to ON messages(to_agent)[/
yindexidx_messages_frommessagesCREATE INDEX idx_messages_from ON messages(from_agent)S/
mindexidx_agents_statusagentsCREATE INDEX idx_agents_status ON agents(status)�?
�]tabletaskstasksCREATE TABLE tasks ( id TEXT PRIMARY KEY, milestone_id TEXT, project_id TEXT NOT NULL, title TEXT NOT NULL, description TEXT, status TEXT DEFAULT 'pending', assigned_to TEXT, priority INTEGER DEFAULT 5, metadata TEXT, -- JSON object created INTEGER NOT NULL, completed_at INTEGER, FOREIGN KEY (milestone_id) REFERENCES milestones(id), FOREIGN KEY (project_id) REFERENCES projects(id), FOREIGN KEY (assigned_to) REFERENCES agents(id) ))=
indexsqlite_autoindex_tasks_1tasks�!!
�{tablemilestonesmilestones CREATE TABLE milestones ( id TEXT PRIMARY KEY, project_id TEXT NOT NULL, title TEXT NOT NULL, description TEXT, status TEXT DEFAULT 'pending', due_date INTEGER, completed_at INTEGER, metadata TEXT, -- JSON object created INTEGER NOT NULL, FOREIGN KEY (project_id) REFERENCES projects(id) )3 G!
indexsqlite_autoindex_milestones_1milestones�3 
�9tableservicesservicesCREATE TABLE services ( id TEXT PRIMARY KEY, name TEXT NOT NULL, type TEXT NOT NULL, -- api, database, queue, etc. endpoint TEXT, status TEXT DEFAULT 'unknown', health_check_url TEXT, last_check INTEGER, response_time_ms INTEGER, metadata TEXT, -- JSON object created INTEGER NOT NULL, updated INTEGER NOT NULL )/C
indexsqlite_autoindex_services_1services� 
�mtableprojectsprojectsCREATE TABLE projects ( id TEXT PRIMARY KEY, name TEXT NOT NULL, path TEXT NOT NULL UNIQUE, description TEXT, type TEXT, -- git, npm, python, etc. status TEXT DEFAULT 'active', metadata TEXT, -- JSON object (git info, dependencies, etc.) created INTEGER NOT NULL, updated INTEGER NOT NULL )/ C
indexsqlite_autoindex_projects_2projects /C
indexsqlite_autoindex_projects_1projects �S
�ytablememoriesmemoriesCREATE TABLE memories ( id TEXT PRIMARY KEY, content TEXT NOT NULL, type TEXT NOT NULL CHECK (type IN ('fact', 'insight', 'experience', 'error')), embedding BLOB, -- Vector embedding agent_id TEXT, project_id TEXT, relevance_score REAL DEFAULT 1.0, access_count INTEGER DEFAULT 0, last_accessed INTEGER, metadata TEXT, -- JSON object created INTEGER NOT NULL, FOREIGN KEY (agent_id) REFERENCES agents(id), FOREIGN KEY (project_id) REFERENCES projects(id) )/C
indexsqlite_autoindex_memories_1memories�K
�itablemessagesmessagesCREATE TABLE messages ( id TEXT PRIMARY KEY, from_agent TEXT NOT NULL, to_agent TEXT, -- NULL for broadcasts content TEXT NOT NULL, channel TEXT, timestamp INTEGER NOT NULL, message_type TEXT NOT NULL DEFAULT 'message', metadata TEXT, -- JSON object FOREIGN KEY (from_agent) REFERENCES agents(id), FOREIGN KEY (to_agent) REFERENCES agents(id) )/C
indexsqlite_autoindex_messages_1messages�;

�QtableagentsagentsCREATE TABLE agents ( id TEXT PRIMARY KEY, name TEXT NOT NULL, status TEXT NOT NULL DEFAULT 'online', capabilities TEXT NOT NULL, -- JSON array last_seen INTEGER NOT NULL, metadata TEXT, -- JSON object created INTEGER NOT NULL )+?
indexsqlite_autoindex_agents_1agents~r%���O�G8��n� ��Q��6 � y  � b �T�'N�E
T �� &��\'5
yindexidx_phases_timestampphases=CREATE INDEX idx_phases_timestamp ON phases(timestamp)�F!
�_tablesessionssessions7CREATE TABLE sessions ( id TEXT PRIMARY KEY, project_id TEXT NOT NULL, agent_ids TEXT NOT NULL DEFAULT '[]', -- JSON array websocket_port INTEGER, discord_channel_id TEXT, is_active INTEGER DEFAULT 1, metadata TEXT, -- JSON object created INTEGER NOT NULL, last_activity INTEGER NOT NULL, FOREIGN KEY (project_id) REFERENCES projects(id) )/"C
indexsqlite_autoindex_sessions_1sessions8�t--
�tableproject_mappingsproject_mappings4CREATE TABLE project_mappings ( id TEXT PRIMARY KEY, name TEXT NOT NULL, base_path TEXT NOT NULL UNIQUE, discord_channel_id TEXT, websocket_port INTEGER, session_id TEXT, pid INTEGER, is_active INTEGER DEFAULT 1, child_paths TEXT NOT NULL DEFAULT '[]', -- JSON array metadata TEXT, -- JSON object created INTEGER NOT NULL, last_access INTEGER NOT NULL )? S-
indexsqlite_autoindex_project_mappings_2project_mappings6?S-
indexsqlite_autoindex_project_mappings_1project_mappings5�]
�tablephasesphases2CREATE TABLE phases ( id TEXT PRIMARY KEY, project_name TEXT NOT NULL, project_path TEXT, timestamp INTEGER NOT NULL, action_items TEXT NOT NULL, -- JSON array design_logic TEXT NOT NULL, agents_used TEXT NOT NULL, supporting_documents TEXT NOT NULL, -- JSON array next_steps TEXT NOT NULL, status TEXT NOT NULL DEFAULT 'PENDING' CHECK (status IN ('PENDING', 'IN_PROGRESS', 'COMPLETE')), metadata TEXT, -- JSON object created INTEGER NOT NULL, updated INTEGER NOT NULL )+?
indexsqlite_autoindex_phases_1phases3X1
windexidx_tasks_assignedtasksCREATE INDEX idx_tasks_assigned ON tasks(assigned_to)U/
sindexidx_tasks_projecttasksCREATE INDEX idx_tasks_project ON tasks(project_id)[3
uindexidx_services_statusservicesCREATE INDEX idx_services_status ON services(status)[3
uindexidx_projects_statusprojectsCREATE INDEX idx_projects_status ON projects(status)U/
mindexidx_memories_typememoriesCREATE INDEX idx_memories_type ON memories(type)a5
indexidx_memories_projectmemoriesCREATE INDEX idx_memories_project ON memories(project_id)[1
windexidx_memories_agentmemoriesCREATE INDEX idx_memories_agent ON memories(agent_id)^5
yindexidx_messages_channelmessagesCREATE INDEX idx_messages_channel ON messages(channel)e9
�
indexidx_messages_timestampmessagesCREATE INDEX idx_messages_timestamp ON messages(timestamp)U+
qindexidx_messages_tomessagesCREATE INDEX idx_messages_to ON messages(to_agent)[/
yindexidx_messages_frommessagesCREATE INDEX idx_messages_from ON messages(from_agent)S/
mindexidx_agents_statusagentsCREATE INDEX idx_agents_status ON agents(status))=
indexsqlite_autoindex_tasks_1tasksS&/
mindexidx_phases_statusphases<CREATE INDEX idx_phases_status ON phases(status)[%1
{indexidx_phases_projectphases;CREATE INDEX idx_phases_project ON phases(project_name)�##CC
�Mtableproject_context_resolutionsproject_context_resolutions9CREATE TABLE project_context_resolutions ( id TEXT PRIMARY KEY, working_directory TEXT NOT NULL, project_id TEXT NOT NULL, resolved_project_path TEXT NOT NULL, hierarchy_depth INTEGER DEFAULT 0, resolution_time_ms INTEGER, agent_id TEXT, created INTEGER NOT NULL, expires INTEGER NOT NULL, FOREIGN KEY (project_id) REFERENCES projects(id), FOREIGN KEY (agent_id) REFERENCES agents(id) )U$iC
indexsqlite_autoindex_project_context_resolutions_1project_context_resolutions:==~r%���O��3JZ�� 
~r%���Oޮ�{��mSQLite format 3@ >
.�*
��\ ] � �.�^�
�3
�
?�U+
qindexidx_messages_tomessagesCREATE INDEX idx_messages_to ON messages(to_agent)[/
yindexidx_messages_frommessagesCREATE INDEX idx_messages_from ON messages(from_agent)S/
mindexidx_agents_statusagentsCREATE INDEX idx_agents_status ON agents(status)�?
�]tabletaskstasksCREATE TABLE tasks ( id TEXT PRIMARY KEY, milestone_id TEXT, project_id TEXT NOT NULL, title TEXT NOT NULL, description TEXT, status TEXT DEFAULT 'pending', assigned_to TEXT, priority INTEGER DEFAULT 5, metadata TEXT, -- JSON object created INTEGER NOT NULL, completed_at INTEGER, FOREIGN KEY (milestone_id) REFERENCES milestones(id), FOREIGN KEY (project_id) REFERENCES projects(id), FOREIGN KEY (assigned_to) REFERENCES agents(id) ))=
indexsqlite_autoindex_tasks_1tasks�!!
�{tablemilestonesmilestones CREATE TABLE milestones ( id TEXT PRIMARY KEY, project_id TEXT NOT NULL, title TEXT NOT NULL, description TEXT, status TEXT DEFAULT 'pending', due_date INTEGER, completed_at INTEGER, metadata TEXT, -- JSON object created INTEGER NOT NULL, FOREIGN KEY (project_id) REFERENCES projects(id) )3 G!
indexsqlite_autoindex_milestones_1milestones�3 
�9tableservicesservicesCREATE TABLE services ( id TEXT PRIMARY KEY, name TEXT NOT NULL, type TEXT NOT NULL, -- api, database, queue, etc. endpoint TEXT, status TEXT DEFAULT 'unknown', health_check_url TEXT, last_check INTEGER, response_time_ms INTEGER, metadata TEXT, -- JSON object created INTEGER NOT NULL, updated INTEGER NOT NULL )/C
indexsqlite_autoindex_services_1services� 
�mtableprojectsprojectsCREATE TABLE projects ( id TEXT PRIMARY KEY, name TEXT NOT NULL, path TEXT NOT NULL UNIQUE, description TEXT, type TEXT, -- git, npm, python, etc. status TEXT DEFAULT 'active', metadata TEXT, -- JSON object (git info, dependencies, etc.) created INTEGER NOT NULL, updated INTEGER NOT NULL )/ C
indexsqlite_autoindex_projects_2projects /C
indexsqlite_autoindex_projects_1projects �S
�ytablememoriesmemoriesCREATE TABLE memories ( id TEXT PRIMARY KEY, content TEXT NOT NULL, type TEXT NOT NULL CHECK (type IN ('fact', 'insight', 'experience', 'error')), embedding BLOB, -- Vector embedding agent_id TEXT, project_id TEXT, relevance_score REAL DEFAULT 1.0, access_count INTEGER DEFAULT 0, last_accessed INTEGER, metadata TEXT, -- JSON object created INTEGER NOT NULL, FOREIGN KEY (agent_id) REFERENCES agents(id), FOREIGN KEY (project_id) REFERENCES projects(id) )/C
indexsqlite_autoindex_memories_1memories�K
�itablemessagesmessagesCREATE TABLE messages ( id TEXT PRIMARY KEY, from_agent TEXT NOT NULL, to_agent TEXT, -- NULL for broadcasts content TEXT NOT NULL, channel TEXT, timestamp INTEGER NOT NULL, message_type TEXT NOT NULL DEFAULT 'message', metadata TEXT, -- JSON object FOREIGN KEY (from_agent) REFERENCES agents(id), FOREIGN KEY (to_agent) REFERENCES agents(id) )/C
indexsqlite_autoindex_messages_1messages�;

�QtableagentsagentsCREATE TABLE agents ( id TEXT PRIMARY KEY, name TEXT NOT NULL, status TEXT NOT NULL DEFAULT 'online', capabilities TEXT NOT NULL, -- JSON array last_seen INTEGER NOT NULL, metadata TEXT, -- JSON object created INTEGER NOT NULL )+?
indexsqlite_autoindex_agents_1agents~r%���O QP��� n�Q��6 � y  � b �T�'N�E
T �� &��n�(I-
�!indexidx_project_mappings_base_pathproject_mappings>CREATE INDEX idx_project_mappings_base_path ON project_mappings(base_path)\'5
yindexidx_phases_timestampphases=CREATE INDEX idx_phases_timestamp ON phases(timestamp)�F!
�_tablesessionssessions7CREATE TABLE sessions ( id TEXT PRIMARY KEY, project_id TEXT NOT NULL, agent_ids TEXT NOT NULL DEFAULT '[]', -- JSON array websocket_port INTEGER, discord_channel_id TEXT, is_active INTEGER DEFAULT 1, metadata TEXT, -- JSON object created INTEGER NOT NULL, last_activity INTEGER NOT NULL, FOREIGN KEY (project_id) REFERENCES projects(id) )/"C
indexsqlite_autoindex_sessions_1sessions8�t--
�tableproject_mappingsproject_mappings4CREATE TABLE project_mappings ( id TEXT PRIMARY KEY, name TEXT NOT NULL, base_path TEXT NOT NULL UNIQUE, discord_channel_id TEXT, websocket_port INTEGER, session_id TEXT, pid INTEGER, is_active INTEGER DEFAULT 1, child_paths TEXT NOT NULL DEFAULT '[]', -- JSON array metadata TEXT, -- JSON object created INTEGER NOT NULL, last_access INTEGER NOT NULL )? S-
indexsqlite_autoindex_project_mappings_2project_mappings6?S-
indexsqlite_autoindex_project_mappings_1project_mappings5�]
�tablephasesphases2CREATE TABLE phases ( id TEXT PRIMARY KEY, project_name TEXT NOT NULL, project_path TEXT, timestamp INTEGER NOT NULL, action_items TEXT NOT NULL, -- JSON array design_logic TEXT NOT NULL, agents_used TEXT NOT NULL, supporting_documents TEXT NOT NULL, -- JSON array next_steps TEXT NOT NULL, status TEXT NOT NULL DEFAULT 'PENDING' CHECK (status IN ('PENDING', 'IN_PROGRESS', 'COMPLETE')), metadata TEXT, -- JSON object created INTEGER NOT NULL, updated INTEGER NOT NULL )+?
indexsqlite_autoindex_phases_1phases3X1
windexidx_tasks_assignedtasksCREATE INDEX idx_tasks_assigned ON tasks(assigned_to)U/
sindexidx_tasks_projecttasksCREATE INDEX idx_tasks_project ON tasks(project_id)[3
uindexidx_services_statusservicesCREATE INDEX idx_services_status ON services(status)[3
uindexidx_projects_statusprojectsCREATE INDEX idx_projects_status ON projects(status)U/
mindexidx_memories_typememoriesCREATE INDEX idx_memories_type ON memories(type)a5
indexidx_memories_projectmemoriesCREATE INDEX idx_memories_project ON memories(project_id)[1
windexidx_memories_agentmemoriesCREATE INDEX idx_memories_agent ON memories(agent_id)^5
yindexidx_messages_channelmessagesCREATE INDEX idx_messages_channel ON messages(channel)e9
�
indexidx_messages_timestampmessagesCREATE INDEX idx_messages_timestamp ON messages(timestamp)U+
qindexidx_messages_tomessagesCREATE INDEX idx_messages_to ON messages(to_agent)[/
yindexidx_messages_frommessagesCREATE INDEX idx_messages_from ON messages(from_agent)S/
mindexidx_agents_statusagentsCREATE INDEX idx_agents_status ON agents(status))=
indexsqlite_autoindex_tasks_1tasksS&/
mindexidx_phases_statusphases<CREATE INDEX idx_phases_status ON phases(status)[%1
{indexidx_phases_projectphases;CREATE INDEX idx_phases_project ON phases(project_name)�##CC
�Mtableproject_context_resolutionsproject_context_resolutions9CREATE TABLE project_context_resolutions ( id TEXT PRIMARY KEY, working_directory TEXT NOT NULL, project_id TEXT NOT NULL, resolved_project_path TEXT NOT NULL, hierarchy_depth INTEGER DEFAULT 0, resolution_time_ms INTEGER, agent_id TEXT, created INTEGER NOT NULL, expires INTEGER NOT NULL, FOREIGN KEY (project_id) REFERENCES projects(id), FOREIGN KEY (agent_id) REFERENCES agents(id) )U$iC
indexsqlite_autoindex_project_context_resolutions_1project_context_resolutions:>>~r%���O4�Y]��0 
~r%���O����-S� SQLite format 3@ ?
.�*
��\ ] � �.�^�
�3
�
?�U+
qindexidx_messages_tomessagesCREATE INDEX idx_messages_to ON messages(to_agent)[/
yindexidx_messages_frommessagesCREATE INDEX idx_messages_from ON messages(from_agent)S/
mindexidx_agents_statusagentsCREATE INDEX idx_agents_status ON agents(status)�?
�]tabletaskstasksCREATE TABLE tasks ( id TEXT PRIMARY KEY, milestone_id TEXT, project_id TEXT NOT NULL, title TEXT NOT NULL, description TEXT, status TEXT DEFAULT 'pending', assigned_to TEXT, priority INTEGER DEFAULT 5, metadata TEXT, -- JSON object created INTEGER NOT NULL, completed_at INTEGER, FOREIGN KEY (milestone_id) REFERENCES milestones(id), FOREIGN KEY (project_id) REFERENCES projects(id), FOREIGN KEY (assigned_to) REFERENCES agents(id) ))=
indexsqlite_autoindex_tasks_1tasks�!!
�{tablemilestonesmilestones CREATE TABLE milestones ( id TEXT PRIMARY KEY, project_id TEXT NOT NULL, title TEXT NOT NULL, description TEXT, status TEXT DEFAULT 'pending', due_date INTEGER, completed_at INTEGER, metadata TEXT, -- JSON object created INTEGER NOT NULL, FOREIGN KEY (project_id) REFERENCES projects(id) )3 G!
indexsqlite_autoindex_milestones_1milestones�3 
�9tableservicesservicesCREATE TABLE services ( id TEXT PRIMARY KEY, name TEXT NOT NULL, type TEXT NOT NULL, -- api, database, queue, etc. endpoint TEXT, status TEXT DEFAULT 'unknown', health_check_url TEXT, last_check INTEGER, response_time_ms INTEGER, metadata TEXT, -- JSON object created INTEGER NOT NULL, updated INTEGER NOT NULL )/C
indexsqlite_autoindex_services_1services� 
�mtableprojectsprojectsCREATE TABLE projects ( id TEXT PRIMARY KEY, name TEXT NOT NULL, path TEXT NOT NULL UNIQUE, description TEXT, type TEXT, -- git, npm, python, etc. status TEXT DEFAULT 'active', metadata TEXT, -- JSON object (git info, dependencies, etc.) created INTEGER NOT NULL, updated INTEGER NOT NULL )/ C
indexsqlite_autoindex_projects_2projects /C
indexsqlite_autoindex_projects_1projects �S
�ytablememoriesmemoriesCREATE TABLE memories ( id TEXT PRIMARY KEY, content TEXT NOT NULL, type TEXT NOT NULL CHECK (type IN ('fact', 'insight', 'experience', 'error')), embedding BLOB, -- Vector embedding agent_id TEXT, project_id TEXT, relevance_score REAL DEFAULT 1.0, access_count INTEGER DEFAULT 0, last_accessed INTEGER, metadata TEXT, -- JSON object created INTEGER NOT NULL, FOREIGN KEY (agent_id) REFERENCES agents(id), FOREIGN KEY (project_id) REFERENCES projects(id) )/C
indexsqlite_autoindex_memories_1memories�K
�itablemessagesmessagesCREATE TABLE messages ( id TEXT PRIMARY KEY, from_agent TEXT NOT NULL, to_agent TEXT, -- NULL for broadcasts content TEXT NOT NULL, channel TEXT, timestamp INTEGER NOT NULL, message_type TEXT NOT NULL DEFAULT 'message', metadata TEXT, -- JSON object FOREIGN KEY (from_agent) REFERENCES agents(id), FOREIGN KEY (to_agent) REFERENCES agents(id) )/C
indexsqlite_autoindex_messages_1messages�;

�QtableagentsagentsCREATE TABLE agents ( id TEXT PRIMARY KEY, name TEXT NOT NULL, status TEXT NOT NULL DEFAULT 'online', capabilities TEXT NOT NULL, -- JSON array last_seen INTEGER NOT NULL, metadata TEXT, -- JSON object created INTEGER NOT NULL )+?
indexsqlite_autoindex_agents_1agents~r%���O����/� � �����\ ] � �.��^
�
�
?��e9
�
indexidx_messages_timestampmessagesCREATE INDEX idx_messages_timestamp ON messages(timestamp)U+
qindexidx_messages_tomessagesCREATE INDEX idx_messages_to ON messages(to_agent)[/
yindexidx_messages_frommessagesCREATE INDEX idx_messages_from ON messages(from_agent)S/
mindexidx_agents_statusagentsCREATE INDEX idx_agents_status ON agents(status))=
indexsqlite_autoindex_tasks_1tasks�?
�]tabletaskstasksCREATE TABLE tasks ( id TEXT PRIMARY KEY, milestone_id TEXT, project_id TEXT NOT NULL, title TEXT NOT NULL, description TEXT, status TEXT DEFAULT 'pending', assigned_to TEXT, priority INTEGER DEFAULT 5, metadata TEXT, -- JSON object created INTEGER NOT NULL, completed_at INTEGER, FOREIGN KEY (milestone_id) REFERENCES milestones(id), FOREIGN KEY (project_id) REFERENCES projects(id), FOREIGN KEY (assigned_to) REFERENCES agents(id) )3 G!
indexsqlite_autoindex_milestones_1milestones�!!
�{tablemilestonesmilestones CREATE TABLE milestones ( id TEXT PRIMARY KEY, project_id TEXT NOT NULL, title TEXT NOT NULL, description TEXT, status TEXT DEFAULT 'pending', due_date INTEGER, completed_at INTEGER, metadata TEXT, -- JSON object created INTEGER NOT NULL, FOREIGN KEY (project_id) REFERENCES projects(id) )�3 
�9tableservicesservicesCREATE TABLE services ( id TEXT PRIMARY KEY, name TEXT NOT NULL, type TEXT NOT NULL, -- api, database, queue, etc. endpoint TEXT, status TEXT DEFAULT 'unknown', health_check_url TEXT, last_check INTEGER, response_time_ms INTEGER, metadata TEXT, -- JSON object created INTEGER NOT NULL, updated INTEGER NOT NULL )/C
indexsqlite_autoindex_services_1services� 
�mtableprojectsprojectsCREATE TABLE projects ( id TEXT PRIMARY KEY, name TEXT NOT NULL, path TEXT NOT NULL UNIQUE, description TEXT, type TEXT, -- git, npm, python, etc. status TEXT DEFAULT 'active', metadata TEXT, -- JSON object (git info, dependencies, etc.) created INTEGER NOT NULL, updated INTEGER NOT NULL )/ C
indexsqlite_autoindex_projects_2projects /C
indexsqlite_autoindex_projects_1projects �S
�ytablememoriesmemoriesCREATE TABLE memories ( id TEXT PRIMARY KEY, content TEXT NOT NULL, type TEXT NOT NULL CHECK (type IN ('fact', 'insight', 'experience', 'error')), embedding BLOB, -- Vector embedding agent_id TEXT, project_id TEXT, relevance_score REAL DEFAULT 1.0, access_count INTEGER DEFAULT 0, last_accessed INTEGER, metadata TEXT, -- JSON object created INTEGER NOT NULL, FOREIGN KEY (agent_id) REFERENCES agents(id), FOREIGN KEY (project_id) REFERENCES projects(id) )/C
indexsqlite_autoindex_memories_1memories�K
�itablemessagesmessagesCREATE TABLE messages ( id TEXT PRIMARY KEY, from_agent TEXT NOT NULL, to_agent TEXT, -- NULL for broadcasts content TEXT NOT NULL, channel TEXT, timestamp INTEGER NOT NULL, message_type TEXT NOT NULL DEFAULT 'message', metadata TEXT, -- JSON object FOREIGN KEY (from_agent) REFERENCES agents(id), FOREIGN KEY (to_agent) REFERENCES agents(id) )/C
indexsqlite_autoindex_messages_1messages�;

�QtableagentsagentsCREATE TABLE agents ( id TEXT PRIMARY KEY, name TEXT NOT NULL, status TEXT NOT NULL DEFAULT 'online', capabilities TEXT NOT NULL, -- JSON array last_seen INTEGER NOT NULL, metadata TEXT, -- JSON object created INTEGER NOT NULL )+?
indexsqlite_autoindex_agents_1agents~r%���O���@��w� �n6 � y  � b �T�'N�E
T �� &��nP�(I-
�!indexidx_project_mappings_base_pathproject_mappings>CREATE INDEX idx_project_mappings_base_path ON project_mappings(base_path)\'5
yindexidx_phases_timestampphases=CREATE INDEX idx_phases_timestamp ON phases(timestamp)�F!
�_tablesessionssessions7CREATE TABLE sessions ( id TEXT PRIMARY KEY, project_id TEXT NOT NULL, agent_ids TEXT NOT NULL DEFAULT '[]', -- JSON array websocket_port INTEGER, discord_channel_id TEXT, is_active INTEGER DEFAULT 1, metadata TEXT, -- JSON object created INTEGER NOT NULL, last_activity INTEGER NOT NULL, FOREIGN KEY (project_id) REFERENCES projects(id) )/"C
indexsqlite_autoindex_sessions_1sessions8�t--
�tableproject_mappingsproject_mappings4CREATE TABLE project_mappings ( id TEXT PRIMARY KEY, name TEXT NOT NULL, base_path TEXT NOT NULL UNIQUE, discord_channel_id TEXT, websocket_port INTEGER, session_id TEXT, pid INTEGER, is_active INTEGER DEFAULT 1, child_paths TEXT NOT NULL DEFAULT '[]', -- JSON array metadata TEXT, -- JSON object created INTEGER NOT NULL, last_access INTEGER NOT NULL )? S-
indexsqlite_autoindex_project_mappings_2project_mappings6?S-
indexsqlite_autoindex_project_mappings_1project_mappings5�]
�tablephasesphases2CREATE TABLE phases ( id TEXT PRIMARY KEY, project_name TEXT NOT NULL, project_path TEXT, timestamp INTEGER NOT NULL, action_items TEXT NOT NULL, -- JSON array design_logic TEXT NOT NULL, agents_used TEXT NOT NULL, supporting_documents TEXT NOT NULL, -- JSON array next_steps TEXT NOT NULL, status TEXT NOT NULL DEFAULT 'PENDING' CHECK (status IN ('PENDING', 'IN_PROGRESS', 'COMPLETE')), metadata TEXT, -- JSON object created INTEGER NOT NULL, updated INTEGER NOT NULL )+?
indexsqlite_autoindex_phases_1phases3X1
windexidx_tasks_assignedtasksCREATE INDEX idx_tasks_assigned ON tasks(assigned_to)U/
sindexidx_tasks_projecttasksCREATE INDEX idx_tasks_project ON tasks(project_id)[3
uindexidx_services_statusservicesCREATE INDEX idx_services_status ON services(status)[3
uindexidx_projects_statusprojectsCREATE INDEX idx_projects_status ON projects(status)U/
mindexidx_memories_typememoriesCREATE INDEX idx_memories_type ON memories(type)a5
indexidx_memories_projectmemoriesCREATE INDEX idx_memories_project ON memories(project_id)[1
windexidx_memories_agentmemoriesCREATE INDEX idx_memories_agent ON memories(agent_id)^5
yindexidx_messages_channelmessagesCREATE INDEX idx_messages_channel ON messages(channel)e9
�
indexidx_messages_timestampmessagesCREATE INDEX idx_messages_timestamp ON messages(timestamp)�+
qindexidx_messages_tomessagesCREATE INDEX idx_messages_to ON messages(to_agent)[/
yindexidx_messages_frommessagesCREATE INDEX idx_messages_from ON messages(from_agent)C-
�indexidx_project_mappings_activeproject_mappings?CREATE INDEX idx_project_mappings_active ON project_mappings(is_active)S&/
mindexidx_phases_statusphases<CREATE INDEX idx_phases_status ON phases(status)[%1
{indexidx_phases_projectphases;CREATE INDEX idx_phases_project ON phases(project_name)�##CC
�Mtableproject_context_resolutionsproject_context_resolutions9CREATE TABLE project_context_resolutions ( id TEXT PRIMARY KEY, working_directory TEXT NOT NULL, project_id TEXT NOT NULL, resolved_project_path TEXT NOT NULL, hierarchy_depth INTEGER DEFAULT 0, resolution_time_ms INTEGER, agent_id TEXT, created INTEGER NOT NULL, expires INTEGER NOT NULL, FOREIGN KEY (project_id) REFERENCES projects(id), FOREIGN KEY (agent_id) REFERENCES agents(id) )U$iC
indexsqlite_autoindex_project_context_resolutions_1project_context_resolutions:??~r%���O����_L�V 
~r%���OJ���G�SQLite format 3@ @
.�*
��\ ] � �.�^�
�3
�
?�U+
qindexidx_messages_tomessagesCREATE INDEX idx_messages_to ON messages(to_agent)[/
yindexidx_messages_frommessagesCREATE INDEX idx_messages_from ON messages(from_agent)S/
mindexidx_agents_statusagentsCREATE INDEX idx_agents_status ON agents(status)�?
�]tabletaskstasksCREATE TABLE tasks ( id TEXT PRIMARY KEY, milestone_id TEXT, project_id TEXT NOT NULL, title TEXT NOT NULL, description TEXT, status TEXT DEFAULT 'pending', assigned_to TEXT, priority INTEGER DEFAULT 5, metadata TEXT, -- JSON object created INTEGER NOT NULL, completed_at INTEGER, FOREIGN KEY (milestone_id) REFERENCES milestones(id), FOREIGN KEY (project_id) REFERENCES projects(id), FOREIGN KEY (assigned_to) REFERENCES agents(id) ))=
indexsqlite_autoindex_tasks_1tasks�!!
�{tablemilestonesmilestones CREATE TABLE milestones ( id TEXT PRIMARY KEY, project_id TEXT NOT NULL, title TEXT NOT NULL, description TEXT, status TEXT DEFAULT 'pending', due_date INTEGER, completed_at INTEGER, metadata TEXT, -- JSON object created INTEGER NOT NULL, FOREIGN KEY (project_id) REFERENCES projects(id) )3 G!
indexsqlite_autoindex_milestones_1milestones�3 
�9tableservicesservicesCREATE TABLE services ( id TEXT PRIMARY KEY, name TEXT NOT NULL, type TEXT NOT NULL, -- api, database, queue, etc. endpoint TEXT, status TEXT DEFAULT 'unknown', health_check_url TEXT, last_check INTEGER, response_time_ms INTEGER, metadata TEXT, -- JSON object created INTEGER NOT NULL, updated INTEGER NOT NULL )/C
indexsqlite_autoindex_services_1services� 
�mtableprojectsprojectsCREATE TABLE projects ( id TEXT PRIMARY KEY, name TEXT NOT NULL, path TEXT NOT NULL UNIQUE, description TEXT, type TEXT, -- git, npm, python, etc. status TEXT DEFAULT 'active', metadata TEXT, -- JSON object (git info, dependencies, etc.) created INTEGER NOT NULL, updated INTEGER NOT NULL )/ C
indexsqlite_autoindex_projects_2projects /C
indexsqlite_autoindex_projects_1projects �S
�ytablememoriesmemoriesCREATE TABLE memories ( id TEXT PRIMARY KEY, content TEXT NOT NULL, type TEXT NOT NULL CHECK (type IN ('fact', 'insight', 'experience', 'error')), embedding BLOB, -- Vector embedding agent_id TEXT, project_id TEXT, relevance_score REAL DEFAULT 1.0, access_count INTEGER DEFAULT 0, last_accessed INTEGER, metadata TEXT, -- JSON object created INTEGER NOT NULL, FOREIGN KEY (agent_id) REFERENCES agents(id), FOREIGN KEY (project_id) REFERENCES projects(id) )/C
indexsqlite_autoindex_memories_1memories�K
�itablemessagesmessagesCREATE TABLE messages ( id TEXT PRIMARY KEY, from_agent TEXT NOT NULL, to_agent TEXT, -- NULL for broadcasts content TEXT NOT NULL, channel TEXT, timestamp INTEGER NOT NULL, message_type TEXT NOT NULL DEFAULT 'message', metadata TEXT, -- JSON object FOREIGN KEY (from_agent) REFERENCES agents(id), FOREIGN KEY (to_agent) REFERENCES agents(id) )/C
indexsqlite_autoindex_messages_1messages�;

�QtableagentsagentsCREATE TABLE agents ( id TEXT PRIMARY KEY, name TEXT NOT NULL, status TEXT NOT NULL DEFAULT 'online', capabilities TEXT NOT NULL, -- JSON array last_seen INTEGER NOT NULL, metadata TEXT, -- JSON object created INTEGER NOT NULL )+?
indexsqlite_autoindex_agents_1agents~r%���Ow�F��?.\ �n6 � y  � b �T�'N�E
T �� &��nP��(I-
�!indexidx_project_mappings_base_pathproject_mappings>CREATE INDEX idx_project_mappings_base_path ON project_mappings(base_path)\'5
yindexidx_phases_timestampphases=CREATE INDEX idx_phases_timestamp ON phases(timestamp)�F!
�_tablesessionssessions7CREATE TABLE sessions ( id TEXT PRIMARY KEY, project_id TEXT NOT NULL, agent_ids TEXT NOT NULL DEFAULT '[]', -- JSON array websocket_port INTEGER, discord_channel_id TEXT, is_active INTEGER DEFAULT 1, metadata TEXT, -- JSON object created INTEGER NOT NULL, last_activity INTEGER NOT NULL, FOREIGN KEY (project_id) REFERENCES projects(id) )/"C
indexsqlite_autoindex_sessions_1sessions8�t--
�tableproject_mappingsproject_mappings4CREATE TABLE project_mappings ( id TEXT PRIMARY KEY, name TEXT NOT NULL, base_path TEXT NOT NULL UNIQUE, discord_channel_id TEXT, websocket_port INTEGER, session_id TEXT, pid INTEGER, is_active INTEGER DEFAULT 1, child_paths TEXT NOT NULL DEFAULT '[]', -- JSON array metadata TEXT, -- JSON object created INTEGER NOT NULL, last_access INTEGER NOT NULL )? S-
indexsqlite_autoindex_project_mappings_2project_mappings6?S-
indexsqlite_autoindex_project_mappings_1project_mappings5�]
�tablephasesphases2CREATE TABLE phases ( id TEXT PRIMARY KEY, project_name TEXT NOT NULL, project_path TEXT, timestamp INTEGER NOT NULL, action_items TEXT NOT NULL, -- JSON array design_logic TEXT NOT NULL, agents_used TEXT NOT NULL, supporting_documents TEXT NOT NULL, -- JSON array next_steps TEXT NOT NULL, status TEXT NOT NULL DEFAULT 'PENDING' CHECK (status IN ('PENDING', 'IN_PROGRESS', 'COMPLETE')), metadata TEXT, -- JSON object created INTEGER NOT NULL, updated INTEGER NOT NULL )+?
indexsqlite_autoindex_phases_1phases3X1
windexidx_tasks_assignedtasksCREATE INDEX idx_tasks_assigned ON tasks(assigned_to)U/
sindexidx_tasks_projecttasksCREATE INDEX idx_tasks_project ON tasks(project_id)[3
uindexidx_services_statusservicesCREATE INDEX idx_services_status ON services(status)[3
uindexidx_projects_statusprojectsCREATE INDEX idx_projects_status ON projects(status)U/
mindexidx_memories_typememoriesCREATE INDEX idx_memories_type ON memories(type)a5
indexidx_memories_projectmemoriesCREATE INDEX idx_memories_project ON memories(project_id)[1
windexidx_memories_agentmemoriesCREATE INDEX idx_memories_agent ON memories(agent_id)^5
yindexidx_messages_channelmessagesCREATE INDEX idx_messages_channel ON messages(channel)e9
�
indexidx_messages_timestampmessagesCREATE INDEX idx_messages_timestamp ON messages(timestamp)P+
qindexidx_messages_tomessagesCREATE INDEX idx_messages_to ON messages(toa*5
indexidx_sessions_projectsessions@CREATE INDEX idx_sessions_project ON sessions(project_id))C-
�indexidx_project_mappings_activeproject_mappings?CREATE INDEX idx_project_mappings_active ON project_mappings(is_active)S&/
mindexidx_phases_statusphases<CREATE INDEX idx_phases_status ON phases(status)[%1
{indexidx_phases_projectphases;CREATE INDEX idx_phases_project ON phases(project_name)�##CC
�Mtableproject_context_resolutionsproject_context_resolutions9CREATE TABLE project_context_resolutions ( id TEXT PRIMARY KEY, working_directory TEXT NOT NULL, project_id TEXT NOT NULL, resolved_project_path TEXT NOT NULL, hierarchy_depth INTEGER DEFAULT 0, resolution_time_ms INTEGER, agent_id TEXT, created INTEGER NOT NULL, expires INTEGER NOT NULL, FOREIGN KEY (project_id) REFERENCES projects(id), FOREIGN KEY (agent_id) REFERENCES agents(id) )U$iC
indexsqlite_autoindex_project_context_resolutions_1project_context_resolutions:@@~r%���O�{v��=� 
~r%���O�o+I�SQLite format 3@ A
.�*
��\ ] � �.�^�
�3
�
?�U+
qindexidx_messages_tomessagesCREATE INDEX idx_messages_to ON messages(to_agent)[/
yindexidx_messages_frommessagesCREATE INDEX idx_messages_from ON messages(from_agent)S/
mindexidx_agents_statusagentsCREATE INDEX idx_agents_status ON agents(status)�?
�]tabletaskstasksCREATE TABLE tasks ( id TEXT PRIMARY KEY, milestone_id TEXT, project_id TEXT NOT NULL, title TEXT NOT NULL, description TEXT, status TEXT DEFAULT 'pending', assigned_to TEXT, priority INTEGER DEFAULT 5, metadata TEXT, -- JSON object created INTEGER NOT NULL, completed_at INTEGER, FOREIGN KEY (milestone_id) REFERENCES milestones(id), FOREIGN KEY (project_id) REFERENCES projects(id), FOREIGN KEY (assigned_to) REFERENCES agents(id) ))=
indexsqlite_autoindex_tasks_1tasks�!!
�{tablemilestonesmilestones CREATE TABLE milestones ( id TEXT PRIMARY KEY, project_id TEXT NOT NULL, title TEXT NOT NULL, description TEXT, status TEXT DEFAULT 'pending', due_date INTEGER, completed_at INTEGER, metadata TEXT, -- JSON object created INTEGER NOT NULL, FOREIGN KEY (project_id) REFERENCES projects(id) )3 G!
indexsqlite_autoindex_milestones_1milestones�3 
�9tableservicesservicesCREATE TABLE services ( id TEXT PRIMARY KEY, name TEXT NOT NULL, type TEXT NOT NULL, -- api, database, queue, etc. endpoint TEXT, status TEXT DEFAULT 'unknown', health_check_url TEXT, last_check INTEGER, response_time_ms INTEGER, metadata TEXT, -- JSON object created INTEGER NOT NULL, updated INTEGER NOT NULL )/C
indexsqlite_autoindex_services_1services� 
�mtableprojectsprojectsCREATE TABLE projects ( id TEXT PRIMARY KEY, name TEXT NOT NULL, path TEXT NOT NULL UNIQUE, description TEXT, type TEXT, -- git, npm, python, etc. status TEXT DEFAULT 'active', metadata TEXT, -- JSON object (git info, dependencies, etc.) created INTEGER NOT NULL, updated INTEGER NOT NULL )/ C
indexsqlite_autoindex_projects_2projects /C
indexsqlite_autoindex_projects_1projects �S
�ytablememoriesmemoriesCREATE TABLE memories ( id TEXT PRIMARY KEY, content TEXT NOT NULL, type TEXT NOT NULL CHECK (type IN ('fact', 'insight', 'experience', 'error')), embedding BLOB, -- Vector embedding agent_id TEXT, project_id TEXT, relevance_score REAL DEFAULT 1.0, access_count INTEGER DEFAULT 0, last_accessed INTEGER, metadata TEXT, -- JSON object created INTEGER NOT NULL, FOREIGN KEY (agent_id) REFERENCES agents(id), FOREIGN KEY (project_id) REFERENCES projects(id) )/C
indexsqlite_autoindex_memories_1memories�K
�itablemessagesmessagesCREATE TABLE messages ( id TEXT PRIMARY KEY, from_agent TEXT NOT NULL, to_agent TEXT, -- NULL for broadcasts content TEXT NOT NULL, channel TEXT, timestamp INTEGER NOT NULL, message_type TEXT NOT NULL DEFAULT 'message', metadata TEXT, -- JSON object FOREIGN KEY (from_agent) REFERENCES agents(id), FOREIGN KEY (to_agent) REFERENCES agents(id) )/C
indexsqlite_autoindex_messages_1messages�;

�QtableagentsagentsCREATE TABLE agents ( id TEXT PRIMARY KEY, name TEXT NOT NULL, status TEXT NOT NULL DEFAULT 'online', capabilities TEXT NOT NULL, -- JSON array last_seen INTEGER NOT NULL, metadata TEXT, -- JSON object created INTEGER NOT NULL )+?
indexsqlite_autoindex_agents_1agents~r%���O�'��7�y ^�& � f  � U��w���
�m �� &�
F�P�^^+3
{indexidx_sessions_activesessionsACREATE INDEX idx_sessions_active ON sessions(is_active)�(I-
�!indexidx_project_mappings_base_pathproject_mappings>CREATE INDEX idx_project_mappings_base_path ON project_mappings(base_path)\'5
yindexidx_phases_timestampphases=CREATE INDEX idx_phases_timestamp ON phases(timestamp)�F!
�_tablesessionssessions7CREATE TABLE sessions ( id TEXT PRIMARY KEY, project_id TEXT NOT NULL, agent_ids TEXT NOT NULL DEFAULT '[]', -- JSON array websocket_port INTEGER, discord_channel_id TEXT, is_active INTEGER DEFAULT 1, metadata TEXT, -- JSON object created INTEGER NOT NULL, last_activity INTEGER NOT NULL, FOREIGN KEY (project_id) REFERENCES projects(id) )/"C
indexsqlite_autoindex_sessions_1sessions8�t--
�tableproject_mappingsproject_mappings4CREATE TABLE project_mappings ( id TEXT PRIMARY KEY, name TEXT NOT NULL, base_path TEXT NOT NULL UNIQUE, discord_channel_id TEXT, websocket_port INTEGER, session_id TEXT, pid INTEGER, is_active INTEGER DEFAULT 1, child_paths TEXT NOT NULL DEFAULT '[]', -- JSON array metadata TEXT, -- JSON object created INTEGER NOT NULL, last_access INTEGER NOT NULL )? S-
indexsqlite_autoindex_project_mappings_2project_mappings6?S-
indexsqlite_autoindex_project_mappings_1project_mappings5�]
�tablephasesphases2CREATE TABLE phases ( id TEXT PRIMARY KEY, project_name TEXT NOT NULL, project_path TEXT, timestamp INTEGER NOT NULL, action_items TEXT NOT NULL, -- JSON array design_logic TEXT NOT NULL, agents_used TEXT NOT NULL, supporting_documents TEXT NOT NULL, -- JSON array next_steps TEXT NOT NULL, status TEXT NOT NULL DEFAULT 'PENDING' CHECK (status IN ('PENDING', 'IN_PROGRESS', 'COMPLETE')), metadata TEXT, -- JSON object created INTEGER NOT NULL, updated INTEGER NOT NULL )+?
indexsqlite_autoindex_phases_1phases3X1
windexidx_tasks_assignedtasksCREATE INDEX idx_tasks_assigned ON tasks(assigned_to)U/
sindexidx_tasks_projecttasksCREATE INDEX idx_tasks_project ON tasks(project_id)[3
uindexidx_services_statusservicesCREATE INDEX idx_services_status ON services(status)[3
uindexidx_projects_statusprojectsCREATE INDEX idx_projects_status ON projects(status)U/
mindexidx_memories_typememoriesCREATE INDEX idx_memories_type ON memories(type)a5
indexidx_memories_projectmemoriesCREATE INDEX idx_memories_project ON memories(project_id)[1
windexidx_memories_agentmemoriesCREATE INDEX idx_memories_agent ON memories(agent_id)^5
yindexidx_messages_channelmessagesCREATE INDEX idx_messages_channel ON messages(channel)e9
�
indexidx_messages_timestampmessagesCREATE INDEX idx_messages_timestamp ON messages(timestamp)a*5
indexidx_sessions_projectsessions@CREATE INDEX idx_sessions_project ON sessions(project_id))C-
�indexidx_project_mappings_activeproject_mappings?CREATE INDEX idx_project_mappings_active ON project_mappings(is_active)S&/
mindexidx_phases_statusphases<CREATE INDEX idx_phases_status ON phases(status)[%1
{indexidx_phases_projectphases;CREATE INDEX idx_phases_project ON phases(project_name)�##CC
�Mtableproject_context_resolutionsproject_context_resolutions9CREATE TABLE project_context_resolutions ( id TEXT PRIMARY KEY, working_directory TEXT NOT NULL, project_id TEXT NOT NULL, resolved_project_path TEXT NOT NULL, hierarchy_depth INTEGER DEFAULT 0, resolution_time_ms INTEGER, agent_id TEXT, created INTEGER NOT NULL, expires INTEGER NOT NULL, FOREIGN KEY (project_id) REFERENCES projects(id), FOREIGN KEY (agent_id) REFERENCES agents(id) )U$iC
indexsqlite_autoindex_project_context_resolutions_1project_context_resolutions:AA~r%���OU(��B�� 
~r%���O"_�>c�ASQLite format 3@ C
.�*�C�� ] � �.�^�
�3
�
?�U+
qindexidx_messages_tomessagesCREATE INDEX idx_messages_to ON messages(to_agent)[/
yindexidx_messages_frommessagesCREATE INDEX idx_messages_from ON messages(from_agent)S/
mindexidx_agents_statusagentsCREATE INDEX idx_agents_status ON agents(status)�?
�]tabletaskstasksCREATE TABLE tasks ( id TEXT PRIMARY KEY, milestone_id TEXT, project_id TEXT NOT NULL, title TEXT NOT NULL, description TEXT, status TEXT DEFAULT 'pending', assigned_to TEXT, priority INTEGER DEFAULT 5, metadata TEXT, -- JSON object created INTEGER NOT NULL, completed_at INTEGER, FOREIGN KEY (milestone_id) REFERENCES milestones(id), FOREIGN KEY (project_id) REFERENCES projects(id), FOREIGN KEY (assigned_to) REFERENCES agents(id) ))=
indexsqlite_autoindex_tasks_1tasks�!!
�{tablemilestonesmilestones CREATE TABLE milestones ( id TEXT PRIMARY KEY, project_id TEXT NOT NULL, title TEXT NOT NULL, description TEXT, status TEXT DEFAULT 'pending', due_date INTEGER, completed_at INTEGER, metadata TEXT, -- JSON object created INTEGER NOT NULL, FOREIGN KEY (project_id) REFERENCES projects(id) )3 G!
indexsqlite_autoindex_milestones_1milestones�3 
�9tableservicesservicesCREATE TABLE services ( id TEXT PRIMARY KEY, name TEXT NOT NULL, type TEXT NOT NULL, -- api, database, queue, etc. endpoint TEXT, status TEXT DEFAULT 'unknown', health_check_url TEXT, last_check INTEGER, response_time_ms INTEGER, metadata TEXT, -- JSON object created INTEGER NOT NULL, updated INTEGER NOT NULL )/C
indexsqlite_autoindex_services_1services� 
�mtableprojectsprojectsCREATE TABLE projects ( id TEXT PRIMARY KEY, name TEXT NOT NULL, path TEXT NOT NULL UNIQUE, description TEXT, type TEXT, -- git, npm, python, etc. status TEXT DEFAULT 'active', metadata TEXT, -- JSON object (git info, dependencies, etc.) created INTEGER NOT NULL, updated INTEGER NOT NULL )/ C
indexsqlite_autoindex_projects_2projects /C
indexsqlite_autoindex_projects_1projects �S
�ytablememoriesmemoriesCREATE TABLE memories ( id TEXT PRIMARY KEY, content TEXT NOT NULL, type TEXT NOT NULL CHECK (type IN ('fact', 'insight', 'experience', 'error')), embedding BLOB, -- Vector embedding agent_id TEXT, project_id TEXT, relevance_score REAL DEFAULT 1.0, access_count INTEGER DEFAULT 0, last_accessed INTEGER, metadata TEXT, -- JSON object created INTEGER NOT NULL, FOREIGN KEY (agent_id) REFERENCES agents(id), FOREIGN KEY (project_id) REFERENCES projects(id) )/C
indexsqlite_autoindex_memories_1memories�K
�itablemessagesmessagesCREATE TABLE messages ( id TEXT PRIMARY KEY, from_agent TEXT NOT NULL, to_agent TEXT, -- NULL for broadcasts content TEXT NOT NULL, channel TEXT, timestamp INTEGER NOT NULL, message_type TEXT NOT NULL DEFAULT 'message', metadata TEXT, -- JSON object FOREIGN KEY (from_agent) REFERENCES agents(id), FOREIGN KEY (to_agent) REFERENCES agents(id) )/C
indexsqlite_autoindex_messages_1messages�;

�QtableagentsagentsCREATE TABLE agents ( id TEXT PRIMARY KEY, name TEXT NOT NULL, status TEXT NOT NULL DEFAULT 'online', capabilities TEXT NOT NULL, -- JSON array last_seen INTEGER NOT NULL, metadata TEXT, -- JSON object created INTEGER NOT NULL )+?
indexsqlite_autoindex_agents_1agent ~r%���O�����5/� ����\ ] � �.��^
�
�
?��e9
�
indexidx_messages_timestampmessagesCREATE INDEX idx_messages_timestamp ON messages(timestamp)U+
qindexidx_messages_tomessagesCREATE INDEX idx_messages_to ON messages(to_agent)[/
yindexidx_messages_frommessagesCREATE INDEX idx_messages_from ON messages(from_agent)S/
mindexidx_agents_statusagentsCREATE INDEX idx_agents_status ON agents(status))=
indexsqlite_autoindex_tasks_1tasks�?
�]tabletaskstasksCREATE TABLE tasks ( id TEXT PRIMARY KEY, milestone_id TEXT, project_id TEXT NOT NULL, title TEXT NOT NULL, description TEXT, status TEXT DEFAULT 'pending', assigned_to TEXT, priority INTEGER DEFAULT 5, metadata TEXT, -- JSON object created INTEGER NOT NULL, completed_at INTEGER, FOREIGN KEY (milestone_id) REFERENCES milestones(id), FOREIGN KEY (project_id) REFERENCES projects(id), FOREIGN KEY (assigned_to) REFERENCES agents(id) )3 G!
indexsqlite_autoindex_milestones_1milestones�!!
�{tablemilestonesmilestones CREATE TABLE milestones ( id TEXT PRIMARY KEY, project_id TEXT NOT NULL, title TEXT NOT NULL, description TEXT, status TEXT DEFAULT 'pending', due_date INTEGER, completed_at INTEGER, metadata TEXT, -- JSON object created INTEGER NOT NULL, FOREIGN KEY (project_id) REFERENCES projects(id) )�3 
�9tableservicesservicesCREATE TABLE services ( id TEXT PRIMARY KEY, name TEXT NOT NULL, type TEXT NOT NULL, -- api, database, queue, etc. endpoint TEXT, status TEXT DEFAULT 'unknown', health_check_url TEXT, last_check INTEGER, response_time_ms INTEGER, metadata TEXT, -- JSON object created INTEGER NOT NULL, updated INTEGER NOT NULL )/C
indexsqlite_autoindex_services_1services� 
�mtableprojectsprojectsCREATE TABLE projects ( id TEXT PRIMARY KEY, name TEXT NOT NULL, path TEXT NOT NULL UNIQUE, description TEXT, type TEXT, -- git, npm, python, etc. status TEXT DEFAULT 'active', metadata TEXT, -- JSON object (git info, dependencies, etc.) created INTEGER NOT NULL, updated INTEGER NOT NULL )/ C
indexsqlite_autoindex_projects_2projects /C
indexsqlite_autoindex_projects_1projects �S
�ytablememoriesmemoriesCREATE TABLE memories ( id TEXT PRIMARY KEY, content TEXT NOT NULL, type TEXT NOT NULL CHECK (type IN ('fact', 'insight', 'experience', 'error')), embedding BLOB, -- Vector embedding agent_id TEXT, project_id TEXT, relevance_score REAL DEFAULT 1.0, access_count INTEGER DEFAULT 0, last_accessed INTEGER, metadata TEXT, -- JSON object created INTEGER NOT NULL, FOREIGN KEY (agent_id) REFERENCES agents(id), FOREIGN KEY (project_id) REFERENCES projects(id) )/C
indexsqlite_autoindex_memories_1memories�K
�itablemessagesmessagesCREATE TABLE messages ( id TEXT PRIMARY KEY, from_agent TEXT NOT NULL, to_agent TEXT, -- NULL for broadcasts content TEXT NOT NULL, channel TEXT, timestamp INTEGER NOT NULL, message_type TEXT NOT NULL DEFAULT 'message', metadata TEXT, -- JSON object FOREIGN KEY (from_agent) REFERENCES agents(id), FOREIGN KEY (to_agent) REFERENCES agents(id) )/C
indexsqlite_autoindex_messages_1messages�;

�QtableagentsagentsCREATE TABLE agents ( id TEXT PRIMARY KEY, name TEXT NOT NULL, status TEXT NOT NULL DEFAULT 'online', capabilities TEXT NOT NULL, -- JSON array last_seen INTEGER NOT NULL, metadata TEXT, -- JSON object created INTEGER NOT NULL )+?
indexsqlite_autoindex_agents_1agents~r%���OB�C�T�w= ����#��& � f  � U��w��� &�
F�P�^^+3
{indexidx_sessions_activesessionsACREATE INDEX idx_sessions_active ON sessions(is_active)�(I-
�!indexidx_project_mappings_base_pathproject_mappings>CREATE INDEX idx_project_mappings_base_path ON project_mappings(base_path)\'5
yindexidx_phases_timestampphases=CREATE INDEX idx_phases_timestamp ON phases(timestamp)�F!
�_tablesessionssessions7CREATE TABLE sessions ( id TEXT PRIMARY KEY, project_id TEXT NOT NULL, agent_ids TEXT NOT NULL DEFAULT '[]', -- JSON array websocket_port INTEGER, discord_channel_id TEXT, is_active INTEGER DEFAULT 1, metadata TEXT, -- JSON object created INTEGER NOT NULL, last_activity INTEGER NOT NULL, FOREIGN KEY (project_id) REFERENCES projects(id) )/"C
indexsqlite_autoindex_sessions_1sessions8�t--
�tableproject_mappingsproject_mappings4CREATE TABLE project_mappings ( id TEXT PRIMARY KEY, name TEXT NOT NULL, base_path TEXT NOT NULL UNIQUE, discord_channel_id TEXT, websocket_port INTEGER, session_id TEXT, pid INTEGER, is_active INTEGER DEFAULT 1, child_paths TEXT NOT NULL DEFAULT '[]', -- JSON array metadata TEXT, -- JSON object created INTEGER NOT NULL, last_access INTEGER NOT NULL )? S-
indexsqlite_autoindex_project_mappings_2project_mappings6?S-
indexsqlite_autoindex_project_mappings_1project_mappings5�]
�tablephasesphases2CREATE TABLE phases ( id TEXT PRIMARY KEY, project_name TEXT NOT NULL, project_path TEXT, timestamp INTEGER NOT NULL, action_items TEXT NOT NULL, -- JSON array design_logic TEXT NOT NULL, agents_used TEXT NOT NULL, supporting_documents TEXT NOT NULL, -- JSON array next_steps TEXT NOT NULL, status TEXT NOT NULL DEFAULT 'PENDING' CHECK (status IN ('PENDING', 'IN_PROGRESS', 'COMPLETE')), metadata TEXT, -- JSON object created INTEGER NOT NULL, updated INTEGER NOT NULL )+?
indexsqlite_autoindex_phases_1phases3X1
windexidx_tasks_assignedtasksCREATE INDEX idx_tasks_assigned ON tasks(assigned_to)U/
sindexidx_tasks_projecttasksCREATE INDEX idx_tasks_project ON tasks(project_id)[3
uindexidx_services_statusservicesCREATE INDEX idx_services_status ON services(status)[3
uindexidx_projects_statusprojectsCREATE INDEX idx_projects_status ON projects(status)U/
mindexidx_memories_typememoriesCREATE INDEX idx_memories_type ON memories(type)a5
indexidx_memories_projectmemoriesCREATE INDEX idx_memories_project ON memories(project_id)[1
windexidx_memories_agentmemoriesCREATE INDEX idx_memories_agent ON memories(agent_id)^5
yindexidx_messages_channelmessagesCREATE INDEX idx_messages_channel ON messages(channel)e9
�
indexidx_messages_timestampmessagesCREATE INDEX idx_messages_timestamp ON messages(timestamp)�5
indexidx_sessions_projectsessions@CREATE INDEX idx_sessions_project ON sessions(project_id))C-
�indexidx_project_mappings_activeproject_mappings?CREATE INDEX idx_project_mappings_active ON project_mappings(is_active)S&/
mindexidx_phases_statusphases<CREATE INDEX idx_phases_status ON phases(status)[%1
{indexidx_phases_projectphases;CREATE INDEX idx_phases_project ON phases(project_name)�##CC
�Mtableproject_context_resolutionsproject_context_resolutions9CREATE TABLE project_context_resolutions ( id TEXT PRIMARY KEY, working_directory TEXT NOT NULL, project_id TEXT NOT NULL, resolved_project_path TEXT NOT NULL, hierarchy_depth INTEGER DEFAULT 0, resolution_time_U+
qindexidx_messages_tomessagesCREATE INDEX idx_messages_to ON messages(to_agent)[/
yindexidx_messages_frommessagesCREATE INDEX idx_messages_from ON messages(from_agent)S/
mindexidx_agents_statusagentsCREATE INDEX idx_agents_status ON agents(status))=
indexsqlite_autoindex_tasks_1tasksB~r%���O�gi�/`� CC~r%���O��gnR�� 7��, � y � p ��,;C
�9indexidx_project_context_pwdproject_context_resolutionsBCREATE INDEX idx_project_context_pwd ON project_context_resolutions(working_directory)^+3
{indexidx_sessions_activesessionsACREATE INDEX idx_sessions_active ON sessions(is_active)a*5
indexidx_sessions_projectsessions@CREATE INDEX idx_sessions_project ON sessions(project_id))C-
�indexidx_project_mappings_activeproject_mappings?CREATE INDEX idx_project_mappings_active ON project_mappings(is_active)�(I-
�!indexidx_project_mappings_base_pathproject_mappings>CREATE INDEX idx_project_mappings_base_path ON project_mappings(base_path)\'5
yindexidx_phases_timestampphases=CREATE INDEX idx_phases_timestamp ON phases(timestamp)S&/
mindexidx_phases_statusphases<CREATE INDEX idx_phases_status ON phases(status)[%1
{indexidx_phases_projectphases;CREATE INDEX idx_phases_project ON phases(project_name)U$iC
indexsqlite_autoindex_project_context_resolutions_1project_context_resolutions:�##CC
�Mtableproject_context_resolutionsproject_context_resolutions9CREATE TABLE project_context_resolutions ( id TEXT PRIMARY KEY, working_directory TEXT NOT NULL, project_id TEXT NOT NULL, resolved_project_path TEXT NOT NULL, hierarchy_depth INTEGER DEFAULT 0, resolution_time_ms INTEGER, agent_id TEXT, created INTEGER NOT NULL, expires INTEGER NOT NULL, FOREIGN KEY (project_id) REFERENCES projects(id), FOREIGN KEY (agent_id) REFERENCES agents(id) )/"C
indexsqlite_autoindex_sessions_1sessions8�F!
�_tablesessionssessions7CREATE TABLE sessions ( id TEXT PRIMARY KEY, project_id TEXT NOT NULL, agent_ids TEXT NOT NULL DEFAULT '[]', -- JSON array websocket_port INTEGER, discord_channel_id TEXT, is_active INTEGER DEFAULT 1, metadata TEXT, -- JSON object created INTEGER NOT NULL, last_activity INTEGER NOT NULL, FOREIGN KEY (project_id) REFERENCES projects(id) )
~r%���O^��4�QSQLite format 3@ D 
.�*�C�� ] � �.�^�
�3
�
?�U+
qindexidx_messages_tomessagesCREATE INDEX idx_messages_to ON messages(to_agent)[/
yindexidx_messages_frommessagesCREATE INDEX idx_messages_from ON messages(from_agent)S/
mindexidx_agents_statusagentsCREATE INDEX idx_agents_status ON agents(status)�?
�]tabletaskstasksCREATE TABLE tasks ( id TEXT PRIMARY KEY, milestone_id TEXT, project_id TEXT NOT NULL, title TEXT NOT NULL, description TEXT, status TEXT DEFAULT 'pending', assigned_to TEXT, priority INTEGER DEFAULT 5, metadata TEXT, -- JSON object created INTEGER NOT NULL, completed_at INTEGER, FOREIGN KEY (milestone_id) REFERENCES milestones(id), FOREIGN KEY (project_id) REFERENCES projects(id), FOREIGN KEY (assigned_to) REFERENCES agents(id) ))=
indexsqlite_autoindex_tasks_1tasks�!!
�{tablemilestonesmilestones CREATE TABLE milestones ( id TEXT PRIMARY KEY, project_id TEXT NOT NULL, title TEXT NOT NULL, description TEXT, status TEXT DEFAULT 'pending', due_date INTEGER, completed_at INTEGER, metadata TEXT, -- JSON object created INTEGER NOT NULL, FOREIGN KEY (project_id) REFERENCES projects(id) )3 G!
indexsqlite_autoindex_milestones_1milestones�3 
�9tableservicesservicesCREATE TABLE services ( id TEXT PRIMARY KEY, name TEXT NOT NULL, type TEXT NOT NULL, -- api, database, queue, etc. endpoint TEXT, status TEXT DEFAULT 'unknown', health_check_url TEXT, last_check INTEGER, response_time_ms INTEGER, metadata TEXT, -- JSON object created INTEGER NOT NULL, updated INTEGER NOT NULL )/C
indexsqlite_autoindex_services_1services� 
�mtableprojectsprojectsCREATE TABLE projects ( id TEXT PRIMARY KEY, name TEXT NOT NULL, path TEXT NOT NULL UNIQUE, description TEXT, type TEXT, -- git, npm, python, etc. status TEXT DEFAULT 'active', metadata TEXT, -- JSON object (git info, dependencies, etc.) created INTEGER NOT NULL, updated INTEGER NOT NULL )/ C
indexsqlite_autoindex_projects_2projects /C
indexsqlite_autoindex_projects_1projects �S
�ytablememoriesmemoriesCREATE TABLE memories ( id TEXT PRIMARY KEY, content TEXT NOT NULL, type TEXT NOT NULL CHECK (type IN ('fact', 'insight', 'experience', 'error')), embedding BLOB, -- Vector embedding agent_id TEXT, project_id TEXT, relevance_score REAL DEFAULT 1.0, access_count INTEGER DEFAULT 0, last_accessed INTEGER, metadata TEXT, -- JSON object created INTEGER NOT NULL, FOREIGN KEY (agent_id) REFERENCES agents(id), FOREIGN KEY (project_id) REFERENCES projects(id) )/C
indexsqlite_autoindex_memories_1memories�K
�itablemessagesmessagesCREATE TABLE messages ( id TEXT PRIMARY KEY, from_agent TEXT NOT NULL, to_agent TEXT, -- NULL for broadcasts content TEXT NOT NULL, channel TEXT, timestamp INTEGER NOT NULL, message_type TEXT NOT NULL DEFAULT 'message', metadata TEXT, -- JSON object FOREIGN KEY (from_agent) REFERENCES agents(id), FOREIGN KEY (to_agent) REFERENCES agents(id) )/C
indexsqlite_autoindex_messages_1messages�;

�QtableagentsagentsCREATE TABLE agents ( id TEXT PRIMARY KEY, name TEXT NOT NULL, status TEXT NOT NULL DEFAULT 'online', capabilities TEXT NOT NULL, -- JSON array last_seen INTEGER NOT NULL, metadata TEXT, -- JSON object created INTEGER NOT NULL )+?
indexsqlite_autoindex_agents_1agent C~r%���Oh�Ϛ@��� 7��, � y � p ��-CC
�-indexidx_project_context_expiresproject_context_resolutionsDCREATE INDEX idx_project_context_expires ON project_context_resolutions(expires)�,;C
�9indexidx_project_context_pwdproject_context_resolutionsBCREATE INDEX idx_project_context_pwd ON project_context_resolutions(working_directory)^+3
{indexidx_sessions_activesessionsACREATE INDEX idx_sessions_active ON sessions(is_active)a*5
indexidx_sessions_projectsessions@CREATE INDEX idx_sessions_project ON sessions(project_id))C-
�indexidx_project_mappings_activeproject_mappings?CREATE INDEX idx_project_mappings_active ON project_mappings(is_active)�(I-
�!indexidx_project_mappings_base_pathproject_mappings>CREATE INDEX idx_project_mappings_base_path ON project_mappings(base_path)\'5
yindexidx_phases_timestampphases=CREATE INDEX idx_phases_timestamp ON phases(timestamp)S&/
mindexidx_phases_statusphases<CREATE INDEX idx_phases_status ON phases(status)[%1
{indexidx_phases_projectphases;CREATE INDEX idx_phases_project ON phases(project_name)U$iC
indexsqlite_autoindex_project_context_resolutions_1project_context_resolutions:�##CC
�Mtableproject_context_resolutionsproject_context_resolutions9CREATE TABLE project_context_resolutions ( id TEXT PRIMARY KEY, working_directory TEXT NOT NULL, project_id TEXT NOT NULL, resolved_project_path TEXT NOT NULL, hierarchy_depth INTEGER DEFAULT 0, resolution_time_ms INTEGER, agent_id TEXT, created INTEGER NOT NULL, expires INTEGER NOT NULL, FOREIGN KEY (project_id) REFERENCES projects(id), FOREIGN KEY (agent_id) REFERENCES agents(id) )/"C
indexsqlite_autoindex_sessions_1sessions8�F!
�_tablesessionssessions7CREATE TABLE sessions ( id TEXT PRIMARY KEY, project_id TEXT NOT NULL, agent_ids TEXT NOT NULL DEFAULT '[]', -- JSON array websocket_port INTEGER, discord_channel_id TEXT, is_active INTEGER DEFAULT 1, metadata TEXT, -- JSON object created INTEGER NOT NULL, last_activity INTEGER NOT NULL, FOREIGN KEY (project_id) REFERENCES projects(id) )DD~r%���O�D������