7�-�Wd^�彔MVEgj[���Wd^�彔MN�:c~+b SQLite format 3@ .zp � � ����,�/tablethreadsthreadsCREATE TABLE threads ( id TEXT PRIMARY KEY, name TEXT NOT NULL UNIQUE, created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), current_plan_id TEXT REFERENCES plans(id), git_branches TEXT, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'paused', 'completed', 'archived')) )-Aindexsqlite_autoindex_threads_2threads-Aindexsqlite_autoindex_threads_1threadsWd^�彔M�¯�D�B$ Wd^�彔M0(��/��� Wd^�彔M4e�S�R� Wd^�彔MZhp���_�SQLite format 3@ .zp � � ��� �c3�indexidx_threads_updatedthreadsCREATE INDEX idx_threads_updated ON threads(updated_at DESC)�,�/tablethreadsthreadsCREATE TABLE threads ( id TEXT PRIMARY KEY, name TEXT NOT NULL UNIQUE, created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), current_plan_id TEXT REFERENCES plans(id), git_branches TEXT, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'paused', 'completed', 'archived')) )-Aindexsqlite_autoindex_threads_2threads-Aindexsqlite_autoindex_threads_1threadsWd^�彔M-@�k�'� Wd^�彔MQ�f�.��SQLite format 3@ .zp � - ��� � -W1qindexidx_threads_statusthreadsCREATE INDEX idx_threads_status ON threads(status)c3�indexidx_threads_updatedthreadsCREATE INDEX idx_threads_updated ON threads(updated_at DESC)�,�/tablethreadsthreadsCREATE TABLE threads ( id TEXT PRIMARY KEY, name TEXT NOT NULL UNIQUE, created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), current_plan_id TEXT REFERENCES plans(id), git_branches TEXT, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'paused', 'completed', 'archived')) )-Aindexsqlite_autoindex_threads_2threads-Aindexsqlite_autoindex_threads_1threadsWd^�彔M�Z��n_ Wd^�彔M/R��3�SQLite format 3@ .zp � � ��� � - �Q-iindexidx_threads_namethreadsCREATE INDEX idx_threads_name ON threads(name)W1qindexidx_threads_statusthreadsCREATE INDEX idx_threads_status ON threads(status)c3�indexidx_threads_updatedthreadsCREATE INDEX idx_threads_updated ON threads(updated_at DESC)�,�/tablethreadsthreadsCREATE TABLE threads ( id TEXT PRIMARY KEY, name TEXT NOT NULL UNIQUE, created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), current_plan_id TEXT REFERENCES plans(id), git_branches TEXT, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'paused', 'completed', 'archived')) )-Aindexsqlite_autoindex_threads_2threads-Aindexsqlite_autoindex_threads_1threadsWd^�彔MV��Ņ.A� Wd^�彔M����R3Y�SQLite format 3@  .zp � � ��� � - � � ��++�Ctablethread_sessionsthread_sessionsCREATE TABLE thread_sessions ( thread_id TEXT NOT NULL REFERENCES threads(id) ON DELETE CASCADE, session_id TEXT NOT NULL, created_at TEXT DEFAULT (datetime('now')), PRIMARY KEY (thread_id, session_id) )=Q+indexsqlite_autoindex_thread_sessions_1thread_sessions Q-iindexidx_threads_namethreadsCREATE INDEX idx_threads_name ON threads(name)W1qindexidx_threads_statusthreadsCREATE INDEX idx_threads_status ON threads(status)c3�indexidx_threads_updatedthreadsCREATE INDEX idx_threads_updated ON threads(updated_at DESC)�,�/tablethreadsthreadsCREATE TABLE threads ( id TEXT PRIMARY KEY, name TEXT NOT NULL UNIQUE, created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), current_plan_id TEXT REFERENCES plans(id), git_branches TEXT, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'paused', 'completed', 'archived')) )-Aindexsqlite_autoindex_threads_2threads-Aindexsqlite_autoindex_threads_1threadsWd^�彔M9�������  Wd^�彔M )�Ǎ� Wd^�彔M S[N��muSQLite format 3@  .zp �  ��� � - � � �  g�V � tableplansplans CREATE TABLE plans ( id TEXT PRIMARY KEY, created_at TEXT DEFAULT (datetime('now')), status TEXT DEFAULT 'accepted' CHECK(status IN ('accepted', 'in_progress', 'completed', 'abandoned')), description TEXT, plan_markdown TEXT NOT NULL, session_id TEXT, thread_id TEXT REFERENCES threads(id) )) =indexsqlite_autoindex_plans_1plans �++�Ctablethread_sessionsthread_sessionsCREATE TABLE thread_sessions ( thread_id TEXT NOT NULL REFERENCES threads(id) ON DELETE CASCADE, session_id TEXT NOT NULL, created_at TEXT DEFAULT (datetime('now')), PRIMARY KEY (thread_id, session_id) )=Q+indexsqlite_autoindex_thread_sessions_1thread_sessions Q-iindexidx_threads_namethreadsCREATE INDEX idx_threads_name ON threads(name)W1qindexidx_threads_statusthreadsCREATE INDEX idx_threads_status ON threads(status)c3�indexidx_threads_updatedthreadsCREATE INDEX idx_threads_updated ON threads(updated_at DESC)�,�/tablethreadsthreadsCREATE TABLE threads ( id TEXT PRIMARY KEY, name TEXT NOT NULL UNIQUE, created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), current_plan_id TEXT REFERENCES plans(id), git_branches TEXT, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'paused', 'completed', 'archived')) )-Aindexsqlite_autoindex_threads_2threads-Aindexsqlite_autoindex_threads_1threads Wd^�彔M��/�H  Wd^�彔M��J���q� Wd^�彔M[%����1SQLite format 3@  .zp � ` ��� � - � � �  g` ��v !!�7tableplan_stepsplan_steps CREATE TABLE plan_steps ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_order INTEGER NOT NULL, description TEXT NOT NULL, status TEXT DEFAULT 'pending' CHECK(status IN ('pending', 'in_progress', 'completed', 'failed', 'skipped')), created_at TEXT DEFAULT (datetime('now')) )3 G!indexsqlite_autoindex_plan_steps_1plan_steps �V � tableplansplans CREATE TABLE plans ( id TEXT PRIMARY KEY, created_at TEXT DEFAULT (datetime('now')), status TEXT DEFAULT 'accepted' CHECK(status IN ('accepted', 'in_progress', 'completed', 'abandoned')), description TEXT, plan_markdown TEXT NOT NULL, session_id TEXT, thread_id TEXT REFERENCES threads(id) )) =indexsqlite_autoindex_plans_1plans �++�Ctablethread_sessionsthread_sessionsCREATE TABLE thread_sessions ( thread_id TEXT NOT NULL REFERENCES threads(id) ON DELETE CASCADE, session_id TEXT NOT NULL, created_at TEXT DEFAULT (datetime('now')), PRIMARY KEY (thread_id, session_id) )=Q+indexsqlite_autoindex_thread_sessions_1thread_sessions Q-iindexidx_threads_namethreadsCREATE INDEX idx_threads_name ON threads(name)W1qindexidx_threads_statusthreadsCREATE INDEX idx_threads_status ON threads(status)c3�indexidx_threads_updatedthreadsCREATE INDEX idx_threads_updated ON threads(updated_at DESC)�,�/tablethreadsthreadsCREATE TABLE threads ( id TEXT PRIMARY KEY, name TEXT NOT NULL UNIQUE, created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), current_plan_id TEXT REFERENCES plans(id), git_branches TEXT, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'paused', 'completed', 'archived')) )-Aindexsqlite_autoindex_threads_2threads-Aindexsqlite_autoindex_threads_1threads Wd^�彔M촔9(~�  Wd^�彔M��i�� Wd^�彔M2��H�X,SQLite format 3@ .zp �� ��� � - � � �  g` ��)�w ##�5tablebreadcrumbsbreadcrumbsCREATE TABLE breadcrumbs ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_id TEXT REFERENCES plan_steps(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), agent_type TEXT, summary TEXT NOT NULL, files_touched TEXT, issues TEXT, next_context TEXT )5I#indexsqlite_autoindex_breadcrumbs_1breadcrumbs�v !!�7tableplan_stepsplan_steps CREATE TABLE plan_steps ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_order INTEGER NOT NULL, description TEXT NOT NULL, status TEXT DEFAULT 'pending' CHECK(status IN ('pending', 'in_progress', 'completed', 'failed', 'skipped')), created_at TEXT DEFAULT (datetime('now')) )3 G!indexsqlite_autoindex_plan_steps_1plan_steps �V � tableplansplans CREATE TABLE plans ( id TEXT PRIMARY KEY, created_at TEXT DEFAULT (datetime('now')), status TEXT DEFAULT 'accepted' CHECK(status IN ('accepted', 'in_progress', 'completed', 'abandoned')), description TEXT, plan_markdown TEXT NOT NULL, session_id TEXT, thread_id TEXT REFERENCES threads(id) )) =indexsqlite_autoindex_plans_1plans �++�Ctablethread_sessionsthread_sessionsCREATE TABLE thread_sessions ( thread_id TEXT NOT NULL REFERENCES threads(id) ON DELETE CASCADE, session_id TEXT NOT NULL, created_at TEXT DEFAULT (datetime('now')), PRIMARY KEY (thread_id, session_id) )=Q+indexsqlite_autoindex_thread_sessions_1thread_sessions Q-iindexidx_threads_namethreadsCREATE INDEX idx_threads_name ON threads(name)W1qindexidx_threads_statusthreadsCREATE INDEX idx_threads_status ON threads(status)c3�indexidx_threads_updatedthreadsCREATE INDEX idx_threads_updated ON threads(updated_at DESC)�,�/tablethreadsthreadsCREATE TABLE threads ( id TEXT PRIMARY KEY, name TEXT NOT NULL UNIQUE, created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), current_plan_id TEXT REFERENCES plans(id), git_branches TEXT, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'paused', 'completed', 'archived')) )-Aindexsqlite_autoindex_threads_2threads-Aindexsqlite_autoindex_threads_1threadsWd^�彔M�<�A�j�� Wd^�彔M��9��% Wd^�彔Mq[�� ��YSQLite format 3@  .zp �J ��� � - � � �  g` ��)Jx�+##�tablereflectionsreflectionsCREATE TABLE reflections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), trigger TEXT CHECK(trigger IN ('manual', 'compact', 'completion', 'stop')), content TEXT NOT NULL )5I#indexsqlite_autoindex_reflections_1reflections�w ##�5tablebreadcrumbsbreadcrumbsCREATE TABLE breadcrumbs ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_id TEXT REFERENCES plan_steps(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), agent_type TEXT, summary TEXT NOT NULL, files_touched TEXT, issues TEXT, next_context TEXT )5I#indexsqlite_autoindex_breadcrumbs_1breadcrumbs�v !!�7tableplan_stepsplan_steps CREATE TABLE plan_steps ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_order INTEGER NOT NULL, description TEXT NOT NULL, status TEXT DEFAULT 'pending' CHECK(status IN ('pending', 'in_progress', 'completed', 'failed', 'skipped')), created_at TEXT DEFAULT (datetime('now')) )3 G!indexsqlite_autoindex_plan_steps_1plan_steps �V � tableplansplans CREATE TABLE plans ( id TEXT PRIMARY KEY, created_at TEXT DEFAULT (datetime('now')), status TEXT DEFAULT 'accepted' CHECK(status IN ('accepted', 'in_progress', 'completed', 'abandoned')), description TEXT, plan_markdown TEXT NOT NULL, session_id TEXT, thread_id TEXT REFERENCES threads(id) )) =indexsqlite_autoindex_plans_1plans �++�Ctablethread_sessionsthread_sessionsCREATE TABLE thread_sessions ( thread_id TEXT NOT NULL REFERENCES threads(id) ON DELETE CASCADE, session_id TEXT NOT NULL, created_at TEXT DEFAULT (datetime('now')), PRIMARY KEY (thread_id, session_id) )=Q+indexsqlite_autoindex_thread_sessions_1thread_sessions Q-iindexidx_threads_namethreadsCREATE INDEX idx_threads_name ON threads(name)W1qindexidx_threads_statusthreadsCREATE INDEX idx_threads_status ON threads(status)c3�indexidx_threads_updatedthreadsCREATE INDEX idx_threads_updated ON threads(updated_at DESC)�,�/tablethreadsthreadsCREATE TABLE threads ( id TEXT PRIMARY KEY, name TEXT NOT NULL UNIQUE, created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), current_plan_id TEXT REFERENCES plans(id), git_branches TEXT, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'paused', 'completed', 'archived')) )-Aindexsqlite_autoindex_threads_2threads-Aindexsqlite_autoindex_threads_1threadsWd^�彔M쟦�@;� Wd^�彔Mi �]5�j Wd^�彔M��{���SQLite format 3@  .zp �� ��� � - � � �  g` ��)Jx��##�ktablecorrectionscorrectionsCREATE TABLE corrections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), mistake TEXT NOT NULL, symptoms TEXT, resolution TEXT, tags TEXT )5I#indexsqlite_autoindex_corrections_1corrections�+##�tablereflectionsreflectionsCREATE TABLE reflections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), trigger TEXT CHECK(trigger IN ('manual', 'compact', 'completion', 'stop')), content TEXT NOT NULL )5I#indexsqlite_autoindex_reflections_1reflections�w ##�5tablebreadcrumbsbreadcrumbsCREATE TABLE breadcrumbs ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_id TEXT REFERENCES plan_steps(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), agent_type TEXT, summary TEXT NOT NULL, files_touched TEXT, issues TEXT, next_context TEXT )5I#indexsqlite_autoindex_breadcrumbs_1breadcrumbs�v !!�7tableplan_stepsplan_steps CREATE TABLE plan_steps ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_order INTEGER NOT NULL, description TEXT NOT NULL, status TEXT DEFAULT 'pending' CHECK(status IN ('pending', 'in_progress', 'completed', 'failed', 'skipped')), created_at TEXT DEFAULT (datetime('now')) )3 G!indexsqlite_autoindex_plan_steps_1plan_steps �V � tableplansplans CREATE TABLE plans ( id TEXT PRIMARY KEY, created_at TEXT DEFAULT (datetime('now')), status TEXT DEFAULT 'accepted' CHECK(status IN ('accepted', 'in_progress', 'completed', 'abandoned')), description TEXT, plan_markdown TEXT NOT NULL, session_id TEXT, thread_id TEXT REFERENCES threads(id) )) =indexsqlite_autoindex_plans_1plans �++�Ctablethread_sessionsthread_sessionsCREATE TABLE thread_sessions ( thread_id TEXT NOT NULL REFERENCES threads(id) ON DELETE CASCADE, session_id TEXT NOT NULL, created_at TEXT DEFAULT (datetime('now')), PRIMARY KEY (thread_id, session_id) )=Q+indexsqlite_autoindex_thread_sessions_1thread_sessions Q-iindexidx_threads_namethreadsCREATE INDEX idx_threads_name ON threads(name)W1qindexidx_threads_statusthreadsCREATE INDEX idx_threads_status ON threads(status)c3�indexidx_threads_updatedthreadsCREATE INDEX idx_threads_updated ON threads(updated_at DESC)�,�/tablethreadsthreadsCREATE TABLE threads ( id TEXT PRIMARY KEY, name TEXT NOT NULL UNIQUE, created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), current_plan_id TEXT REFERENCES plans(id), git_branches TEXT, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'paused', 'completed', 'archived')) )-Aindexsqlite_autoindex_threads_2threads-Aindexsqlite_autoindex_threads_1threadsWd^�彔M���'�W Wd^�彔M��|!���) Wd^�彔M�?XV�[aBSQLite format 3@  .zp �h ��� � - � � �  g` ��)Jx�h��\##�tablebug_reportsbug_reportsCREATE TABLE bug_reports ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), title TEXT NOT NULL, repro_steps TEXT NOT NULL, evidence TEXT, status TEXT DEFAULT 'open' CHECK(status IN ('open', 'resolved', 'wontfix')) )5I#indexsqlite_autoindex_bug_reports_1bug_reports�##�ktablecorrectionscorrectionsCREATE TABLE corrections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), mistake TEXT NOT NULL, symptoms TEXT, resolution TEXT, tags TEXT )5I#indexsqlite_autoindex_corrections_1corrections�+##�tablereflectionsreflectionsCREATE TABLE reflections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), trigger TEXT CHECK(trigger IN ('manual', 'compact', 'completion', 'stop')), content TEXT NOT NULL )5I#indexsqlite_autoindex_reflections_1reflections�w ##�5tablebreadcrumbsbreadcrumbsCREATE TABLE breadcrumbs ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_id TEXT REFERENCES plan_steps(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), agent_type TEXT, summary TEXT NOT NULL, files_touched TEXT, issues TEXT, next_context TEXT )5I#indexsqlite_autoindex_breadcrumbs_1breadcrumbs�v !!�7tableplan_stepsplan_steps CREATE TABLE plan_steps ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_order INTEGER NOT NULL, description TEXT NOT NULL, status TEXT DEFAULT 'pending' CHECK(status IN ('pending', 'in_progress', 'completed', 'failed', 'skipped')), created_at TEXT DEFAULT (datetime('now')) )3 G!indexsqlite_autoindex_plan_steps_1plan_steps �V � tableplansplans CREATE TABLE plans ( id TEXT PRIMARY KEY, created_at TEXT DEFAULT (datetime('now')), status TEXT DEFAULT 'accepted' CHECK(status IN ('accepted', 'in_progress', 'completed', 'abandoned')), description TEXT, plan_markdown TEXT NOT NULL, session_id TEXT, thread_id TEXT REFERENCES threads(id) )) =indexsqlite_autoindex_plans_1plans �++�Ctablethread_sessionsthread_sessionsCREATE TABLE thread_sessions ( thread_id TEXT NOT NULL REFERENCES threads(id) ON DELETE CASCADE, session_id TEXT NOT NULL, created_at TEXT DEFAULT (datetime('now')), PRIMARY KEY (thread_id, session_id) )=Q+indexsqlite_autoindex_thread_sessions_1thread_sessions Q-iindexidx_threads_namethreadsCREATE INDEX idx_threads_name ON threads(name)W1qindexidx_threads_statusthreadsCREATE INDEX idx_threads_status ON threads(status)c3�indexidx_threads_updatedthreadsCREATE INDEX idx_threads_updated ON threads(updated_at DESC)�,�/tablethreadsthreadsCREATE TABLE threads ( id TEXT PRIMARY KEY, name TEXT NOT NULL UNIQUE, created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), current_plan_id TEXT REFERENCES plans(id), git_branches TEXT, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'paused', 'completed', 'archived')) )-Aindexsqlite_autoindex_threads_2threads-Aindexsqlite_autoindex_threads_1threadsWd^�彔M�5���Ϲ Wd^�彔M���7�� Wd^�彔MC�M�6�p�SQLite format 3@  .zp� � - � � �  g` ��)Jx�h�77/Cindexsqlite_autoindex_next_ups_1next_ups�\##�tablebug_reportsbug_reportsCREATE TABLE bug_reports ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), title TEXT NOT NULL, repro_steps TEXT NOT NULL, evidence TEXT, status TEXT DEFAULT 'open' CHECK(status IN ('open', 'resolved', 'wontfix')) )5I#indexsqlite_autoindex_bug_reports_1bug_reports�##�ktablecorrectionscorrectionsCREATE TABLE corrections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), mistake TEXT NOT NULL, symptoms TEXT, resolution TEXT, tags TEXT )5I#indexsqlite_autoindex_corrections_1corrections�+##�tablereflectionsreflectionsCREATE TABLE reflections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), trigger TEXT CHECK(trigger IN ('manual', 'compact', 'completion', 'stop')), content TEXT NOT NULL )5I#indexsqlite_autoindex_reflections_1reflections�w ##�5tablebreadcrumbsbreadcrumbsCREATE TABLE breadcrumbs ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_id TEXT REFERENCES plan_steps(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), agent_type TEXT, summary TEXT NOT NULL, files_touched TEXT, issues TEXT, next_context TEXT )5I#indexsqlite_autoindex_breadcrumbs_1breadcrumbs�v !!�7tableplan_stepsplan_steps CREATE TABLE plan_steps ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_order INTEGER NOT NULL, description TEXT NOT NULL, status TEXT DEFAULT 'pending' CHECK(status IN ('pending', 'in_progress', 'completed', 'failed', 'skipped')), created_at TEXT DEFAULT (datetime('now')) )3 G!indexsqlite_autoindex_plan_steps_1plan_steps �V � tableplansplans CREATE TABLE plans ( id TEXT PRIMARY KEY, created_at TEXT DEFAULT (datetime('now')), status TEXT DEFAULT 'accepted' CHECK(status IN ('accepted', 'in_progress', 'completed', 'abandoned')), description TEXT, plan_markdown TEXT NOT NULL, session_id TEXT, thread_id TEXT REFERENCES threads(id) )) =indexsqlite_autoindex_plans_1plans �++�Ctablethread_sessionsthread_sessionsCREATE TABLE thread_sessions ( thread_id TEXT NOT NULL REFERENCES threads(id) ON DELETE CASCADE, session_id TEXT NOT NULL, created_at TEXT DEFAULT (datetime('now')), PRIMARY KEY (thread_id, session_id) )=Q+indexsqlite_autoindex_thread_sessions_1thread_sessions Q-iindexidx_threads_namethreadsCREATE INDEX idx_threads_name ON threads(name)W1qindexidx_threads_statusthreadsCREATE INDEX idx_threads_status ON threads(status)c3�indexidx_threads_updatedthreadsCREATE INDEX idx_threads_updated ON threads(updated_at DESC)�,�/tablethreadsthreadsCREATE TABLE threads ( id TEXT PRIMARY KEY, name TEXT NOT NULL UNIQUE, created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), current_plan_id TEXT REFERENCES plans(id), git_branches TEXT, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'paused', 'completed', 'archived')) )-Aindexsqlite_autoindex_threads_2threads-Aindexsqlite_autoindex_threads_1threadsWd^�彔Mo����.N[ Wd^�彔M�I��CmE Wd^�彔MĨ�ho�N �x ��� � - � � �  g` ��)Jx�h�x7�<�Ktablenext_upsnext_upsCREATE TABLE next_ups ( id TEXT PRIMARY KEY, title TEXT NOT NULL, content TEXT NOT NULL, is_template INTEGER NOT NULL DEFAULT 0, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'archived', 'launched')), created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), last_launched_at TEXT, launch_count INTEGER DEFAULT 0 )/Cindexsqlite_autoindex_next_ups_1next_ups�\##�tablebug_reportsbug_reportsCREATE TABLE bug_reports ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), title TEXT NOT NULL, repro_steps TEXT NOT NULL, evidence TEXT, status TEXT DEFAULT 'open' CHECK(status IN ('open', 'resolved', 'wontfix')) )5I#indexsqlite_autoindex_bug_reports_1bug_reports�##�ktablecorrectionscorrectionsCREATE TABLE corrections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), mistake TEXT NOT NULL, symptoms TEXT, resolution TEXT, tags TEXT )5I#indexsqlite_autoindex_corrections_1corrections�+##�tablereflectionsreflectionsCREATE TABLE reflections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), trigger TEXT CHECK(trigger IN ('manual', 'compact', 'completion', 'stop')), content TEXT NOT NULL )5I#indexsqlite_autoindex_reflections_1reflections�w ##�5tablebreadcrumbsbreadcrumbsCREATE TABLE breadcrumbs ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_id TEXT REFERENCES plan_steps(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), agent_type TEXT, summary TEXT NOT NULL, files_touched TEXT, issues TEXT, next_context TEXT )5I#indexsqlite_autoindex_breadcrumbs_1breadcrumbs�v !!�7tableplan_stepsplan_steps CREATE TABLE plan_steps ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_order INTEGER NOT NULL, description TEXT NOT NULL, status TEXT DEFAULT 'pending' CHECK(status IN ('pending', 'in_progress', 'completed', 'failed', 'skipped')), created_at TEXT DEFAULT (datetime('now')) )3 G!indexsqlite_autoindex_plan_steps_1plan_steps �V � tableplansplans CREATE TABLE plans ( id TEXT PRIMARY KEY, created_at TEXT DEFAULT (datetime('now')), status TEXT DEFAULT 'accepted' CHECK(status IN ('accepted', 'in_progress', 'completed', 'abandoned')), description TEXT, plan_markdown TEXT NOT NULL, session_id TEXT, thread_id TEXT REFERENCES threads(id) )) =indexsqlite_autoindex_plans_1plans �++�Ctablethread_sessionsthread_sessionsCREATE TABLE thread_sessions ( thread_id TEXT NOT NULL REFERENCES threads(id) ON DELETE CASCADE, session_id TEXT NOT NULL, created_at TEXT DEFAULT (datetime('now')), PRIMARY KEY (thread_id, session_id) )=Q+indexsqlite_autoindex_thread_sessions_1thread_sessions Q-iindexidx_threads_namethreadsCREATE INDEX idx_threads_name ON threads(name)W1qindexidx_threads_statusthreadsCREATE INDEX idx_threads_status ON threads(status)c3�indexidx_threads_updatedthreadsCREATE INDEX idx_threads_updated ON threads(updated_at DESC)�,�/tablethreadsthreadsCREATE TABLE threads ( id TEXT PRIMARY KEY, name TEXT NOT NULL UNIQUE, created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), current_plan_id TEXT REFERENCES plans(id), git_branches TEXT, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'paused', 'completed', 'archived')) )-Aindexsqlite_autoindex_threads_2threads-Aindexsqlite_autoindex_threads_1threadsWd^�彔M[�r��MOdSQLite format 3@  .zp�� � - � � �  g` ��)Jx�h�77/Cindexsqlite_autoindex_next_ups_1next_ups�\##�tablebug_reportsbug_reportsCREATE TABLE bug_reports ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), title TEXT NOT NULL, repro_steps TEXT NOT NULL, evidence TEXT, status TEXT DEFAULT 'open' CHECK(status IN ('open', 'resolved', 'wontfix')) )5I#indexsqlite_autoindex_bug_reports_1bug_reports�##�ktablecorrectionscorrectionsCREATE TABLE corrections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), mistake TEXT NOT NULL, symptoms TEXT, resolution TEXT, tags TEXT )5I#indexsqlite_autoindex_corrections_1corrections�+##�tablereflectionsreflectionsCREATE TABLE reflections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), trigger TEXT CHECK(trigger IN ('manual', 'compact', 'completion', 'stop')), content TEXT NOT NULL )5I#indexsqlite_autoindex_reflections_1reflections�w ##�5tablebreadcrumbsbreadcrumbsCREATE TABLE breadcrumbs ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_id TEXT REFERENCES plan_steps(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), agent_type TEXT, summary TEXT NOT NULL, files_touched TEXT, issues TEXT, next_context TEXT )5I#indexsqlite_autoindex_breadcrumbs_1breadcrumbs�v !!�7tableplan_stepsplan_steps CREATE TABLE plan_steps ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_order INTEGER NOT NULL, description TEXT NOT NULL, status TEXT DEFAULT 'pending' CHECK(status IN ('pending', 'in_progress', 'completed', 'failed', 'skipped')), created_at TEXT DEFAULT (datetime('now')) )3 G!indexsqlite_autoindex_plan_steps_1plan_steps �V � tableplansplans CREATE TABLE plans ( id TEXT PRIMARY KEY, created_at TEXT DEFAULT (datetime('now')), status TEXT DEFAULT 'accepted' CHECK(status IN ('accepted', 'in_progress', 'completed', 'abandoned')), description TEXT, plan_markdown TEXT NOT NULL, session_id TEXT, thread_id TEXT REFERENCES threads(id) )) =indexsqlite_autoindex_plans_1plans �++�Ctablethread_sessionsthread_sessionsCREATE TABLE thread_sessions ( thread_id TEXT NOT NULL REFERENCES threads(id) ON DELETE CASCADE, session_id TEXT NOT NULL, created_at TEXT DEFAULT (datetime('now')), PRIMARY KEY (thread_id, session_id) )=Q+indexsqlite_autoindex_thread_sessions_1thread_sessions Q-iindexidx_threads_namethreadsCREATE INDEX idx_threads_name ON threads(name)W1qindexidx_threads_statusthreadsCREATE INDEX idx_threads_status ON threads(status)c3�indexidx_threads_updatedthreadsCREATE INDEX idx_threads_updated ON threads(updated_at DESC)�,�/tablethreadsthreadsCREATE TABLE threads ( id TEXT PRIMARY KEY, name TEXT NOT NULL UNIQUE, created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), current_plan_id TEXT REFERENCES plans(id), git_branches TEXT, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'paused', 'completed', 'archived')) )-Aindexsqlite_autoindex_threads_2threads-Aindexsqlite_autoindex_threads_1threads Wd^�彔M��o9�R�1 ) � ��� � - � � �  g` ��)Jx�h�x7II-Aindexsqlite_autoindex_workers_1workers�<�Ktablenext_upsnext_upsCREATE TABLE next_ups ( id TEXT PRIMARY KEY, title TEXT NOT NULL, content TEXT NOT NULL, is_template INTEGER NOT NULL DEFAULT 0, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'archived', 'launched')), created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), last_launched_at TEXT, launch_count INTEGER DEFAULT 0 ))xCindexsqlite_autoindex_next_ups_1next_ups�\##�tablebug_reportsbug_reportsCREATE TABLE bug_reports ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), title TEXT NOT NULL, repro_steps TEXT NOT NULL, evidence TEXT, status TEXT DEFAULT 'open' CHECK(status IN ('open', 'resolved', 'wontfix')) ))�I#indexsqlite_autoindex_bug_reports_1bug_reports�##�ktablecorrectionscorrectionsCREATE TABLE corrections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), mistake TEXT NOT NULL, symptoms TEXT, resolution TEXT, tags TEXT ))�I#indexsqlite_autoindex_corrections_1corrections�+##�tablereflectionsreflectionsCREATE TABLE reflections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), trigger TEXT CHECK(trigger IN ('manual', 'compact', 'completion', 'stop')), content TEXT NOT NULL )5I#indexsqlite_autoindex_reflections_1reflections�w ##�5tablebreadcrumbsbreadcrumbsCREATE TABLE breadcrumbs ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_id TEXT REFERENCES plan_steps(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), agent_type TEXT, summary TEXT NOT NULL, files_touched TEXT, issues TEXT, next_context TEXT )�7I#indexsqlite_autoindex_breadcrumbs_1breadcrumbs�v !!�7tableplan_stepsplan_steps CREATE TABLE plan_steps ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_order INTEGER NOT NULL, description TEXT NOT NULL, status TEXT DEFAULT 'pending' CHECK(status IN ('pending', 'in_progress', 'completed', 'failed', 'skipped')), created_at TEXT DEFAULT (datetime('now')) )3 G!indexsqlite_autoindex_plan_steps_1plan_steps �V � tableplansplans CREATE TABLE plans ( id TEXT PRIMARY KEY, created_at TEXT DEFAULT (datetime('now')), status TEXT DEFAULT 'accepted' CHECK(status IN ('accepted', 'in_progress', 'completed', 'abandoned')), description TEXT, plan_markdown TEXT NOT NULL, session_id TEXT, thread_id TEXT REFERENCES threads(id) )) =indexsqlite_autoindex_plans_1plans �++�Ctablethread_sessionsthread_sessionsCREATE TABLE thread_sessions ( thread_id TEXT NOT NULL REFERENCES threads(id) ON DELETE CASCADE, session_id TEXT NOT NULL, created_at TEXT DEFAULT (datetime('now')), PRIMARY KEY (thread_id, session_id) )=Q+indexsqlite_autoindex_thread_sessions_1thread_sessions Q-iindexidx_threads_namethreadsCREATE INDEX idx_threads_name ON threads(name)W1qindexidx_threads_statusthreadsCREATE INDEX idx_threads_status ON threads(status)c3�indexidx_threads_updatedthreadsCREATE INDEX idx_threads_updated ON threads(updated_at DESC)�,�/tablethreadsthreadsCREATE TABLE threads ( id TEXT PRIMARY KEY, name TEXT NOT NULL UNIQUE, created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), current_plan_id TEXT REFERENCES plans(id), git_branches TEXT, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'paused', 'completed', 'archived')) )-Aindexsqlite_autoindex_threads_2threads-Aindexsqlite_autoindex_threads_1threadsWd^�彔Mo�w�=1�� Wd^�彔M��/�5��� Wd^�彔M�zڅ��e s��d O  � � � ��s-Aindexsqlite_autoindex_workers_1workers�m�1tableworkersworkersCREATE TABLE workers ( id TEXT PRIMARY KEY, container_id TEXT NOT NULL, thread_id TEXT NOT NULL REFERENCES threads(id), status TEXT DEFAULT 'running' CHECK(status IN ('running', 'completed', 'failed', 'killed')), last_heartbeat TEXT DEFAULT (datetime('now')), created_at TEXT DEFAULT (datetime('now')), auth_mode TEXT CHECK(auth_mode IN ('env', 'config', 'oauth')), iteration INTEGER DEFAULT 0, max_iterations INTEGER DEFAULT 50 )/Cindexsqlite_autoindex_next_ups_1next_ups�<�Ktablenext_upsnext_upsCREATE TABLE next_ups ( id TEXT PRIMARY KEY, title TEXT NOT NULL, content TEXT NOT NULL, is_template INTEGER NOT NULL DEFAULT 0, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'archived', 'launched')), created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), last_launched_at TEXT, launch_count INTEGER DEFAULT 0 )5I#indexsqlite_autoindex_bug_reports_1bug_reports�\##�tablebug_reportsbug_reportsCREATE TABLE bug_reports ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), title TEXT NOT NULL, repro_steps TEXT NOT NULL, evidence TEXT, status TEXT DEFAULT 'open' CHECK(status IN ('open', 'resolved', 'wontfix')) )5I#indexsqlite_autoindex_corrections_1corrections�##�ktablecorrectionscorrectionsCREATE TABLE corrections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), mistake TEXT NOT NULL, symptoms TEXT, resolution TEXT, tags TEXT )5I#indexsqlite_autoindex_reflections_1reflections�+##�tablereflectionsreflectionsCREATE TABLE reflections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), trigger TEXT CHECK(trigger IN ('manual', 'compact', 'completion', 'stop')), content TEXT NOT NULL )5I#indexsqlite_autoindex_breadcrumbs_1breadcrumbsWd^�彔ML[%���SQLite format 3@ .zp�� � - � � �  g` ��)Jx�h�77/Cindexsqlite_autoindex_next_ups_1next_ups�\##�tablebug_reportsbug_reportsCREATE TABLE bug_reports ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), title TEXT NOT NULL, repro_steps TEXT NOT NULL, evidence TEXT, status TEXT DEFAULT 'open' CHECK(status IN ('open', 'resolved', 'wontfix')) )5I#indexsqlite_autoindex_bug_reports_1bug_reports�##�ktablecorrectionscorrectionsCREATE TABLE corrections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), mistake TEXT NOT NULL, symptoms TEXT, resolution TEXT, tags TEXT )5I#indexsqlite_autoindex_corrections_1corrections�+##�tablereflectionsreflectionsCREATE TABLE reflections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), trigger TEXT CHECK(trigger IN ('manual', 'compact', 'completion', 'stop')), content TEXT NOT NULL )5I#indexsqlite_autoindex_reflections_1reflections�w ##�5tablebreadcrumbsbreadcrumbsCREATE TABLE breadcrumbs ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_id TEXT REFERENCES plan_steps(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), agent_type TEXT, summary TEXT NOT NULL, files_touched TEXT, issues TEXT, next_context TEXT )5I#indexsqlite_autoindex_breadcrumbs_1breadcrumbs�v !!�7tableplan_stepsplan_steps CREATE TABLE plan_steps ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_order INTEGER NOT NULL, description TEXT NOT NULL, status TEXT DEFAULT 'pending' CHECK(status IN ('pending', 'in_progress', 'completed', 'failed', 'skipped')), created_at TEXT DEFAULT (datetime('now')) )3 G!indexsqlite_autoindex_plan_steps_1plan_steps �V � tableplansplans CREATE TABLE plans ( id TEXT PRIMARY KEY, created_at TEXT DEFAULT (datetime('now')), status TEXT DEFAULT 'accepted' CHECK(status IN ('accepted', 'in_progress', 'completed', 'abandoned')), description TEXT, plan_markdown TEXT NOT NULL, session_id TEXT, thread_id TEXT REFERENCES threads(id) )) =indexsqlite_autoindex_plans_1plans �++�Ctablethread_sessionsthread_sessionsCREATE TABLE thread_sessions ( thread_id TEXT NOT NULL REFERENCES threads(id) ON DELETE CASCADE, session_id TEXT NOT NULL, created_at TEXT DEFAULT (datetime('now')), PRIMARY KEY (thread_id, session_id) )=Q+indexsqlite_autoindex_thread_sessions_1thread_sessions Q-iindexidx_threads_namethreadsCREATE INDEX idx_threads_name ON threads(name)W1qindexidx_threads_statusthreadsCREATE INDEX idx_threads_status ON threads(status)c3�indexidx_threads_updatedthreadsCREATE INDEX idx_threads_updated ON threads(updated_at DESC)�,�/tablethreadsthreadsCREATE TABLE threads ( id TEXT PRIMARY KEY, name TEXT NOT NULL UNIQUE, created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), current_plan_id TEXT REFERENCES plans(id), git_branches TEXT, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'paused', 'completed', 'archived')) )-Aindexsqlite_autoindex_threads_2threads-Aindexsqlite_autoindex_threads_1threads Wd^�彔MϽ�>�� ���d O  � � � ��s�P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)�^##�tableworker_logsworker_logsCREATE TABLE worker_logs ( id INTEGER PRIMARY KEY AUTOINCREMENT, worker_id TEXT NOT NULL REFERENCES workers(id) ON DELETE CASCADE, timestamp TEXT NOT NULL DEFAULT (datetime('now')), stream TEXT NOT NULL CHECK(stream IN ('stdout', 'stderr', 'system')), line TEXT NOT NULL, iteration INTEGER )-Aindexsqlite_autoindex_workers_1workers�m�1tableworkersworkersCREATE TABLE workers ( id TEXT PRIMARY KEY, container_id TEXT NOT NULL, thread_id TEXT NOT NULL REFERENCES threads(id), status TEXT DEFAULT 'running' CHECK(status IN ('running', 'completed', 'failed', 'killed')), last_heartbeat TEXT DEFAULT (datetime('now')), created_at TEXT DEFAULT (datetime('now')), auth_mode TEXT CHECK(auth_mode IN ('env', 'config', 'oauth')), iteration INTEGER DEFAULT 0, max_iterations INTEGER DEFAULT 50 )/Cindexsqlite_autoindex_next_ups_1next_ups�<�Ktablenext_upsnext_upsCREATE TABLE next_ups ( id TEXT PRIMARY KEY, title TEXT NOT NULL, content TEXT NOT NULL, is_template INTEGER NOT NULL DEFAULT 0, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'archived', 'launched')), created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), last_launched_at TEXT, launch_count INTEGER DEFAULT 0 )5I#indexsqlite_autoindex_bug_reports_1bug_reports�\##�tablebug_reportsbug_reportsCREATE TABLE bug_reports ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), title TEXT NOT NULL, repro_steps TEXT NOT NULL, evidence TEXT, status TEXT DEFAULT 'open' CHECK(status IN ('open', 'resolved', 'wontfix')) )5I#indexsqlite_autoindex_corrections_1corrections�##�ktablecorrectionscorrectionsCREATE TABLE corrections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), mistake TEXT NOT NULL, symptoms TEXT, resolution TEXT, tags TEXT )5I#indexsqlite_autoindex_reflections_1reflections�+##�tablereflectionsreflectionsCREATE TABLE reflections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), trigger TEXT CHECK(trigger IN ('manual', 'compact', 'completion', 'stop')), content TEXT NOT NULL )5I#indexsqlite_autoindex_breadcrumbs_1breadcrumbsWd^�彔MΔ�_��k Wd^�彔M���i� Wd^�彔M���� ʬ�SQLite format 3@ .zp�� � - � � �  g` ��)Jx�h�77/Cindexsqlite_autoindex_next_ups_1next_ups�\##�tablebug_reportsbug_reportsCREATE TABLE bug_reports ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), title TEXT NOT NULL, repro_steps TEXT NOT NULL, evidence TEXT, status TEXT DEFAULT 'open' CHECK(status IN ('open', 'resolved', 'wontfix')) )5I#indexsqlite_autoindex_bug_reports_1bug_reports�##�ktablecorrectionscorrectionsCREATE TABLE corrections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), mistake TEXT NOT NULL, symptoms TEXT, resolution TEXT, tags TEXT )5I#indexsqlite_autoindex_corrections_1corrections�+##�tablereflectionsreflectionsCREATE TABLE reflections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), trigger TEXT CHECK(trigger IN ('manual', 'compact', 'completion', 'stop')), content TEXT NOT NULL )5I#indexsqlite_autoindex_reflections_1reflections�w ##�5tablebreadcrumbsbreadcrumbsCREATE TABLE breadcrumbs ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_id TEXT REFERENCES plan_steps(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), agent_type TEXT, summary TEXT NOT NULL, files_touched TEXT, issues TEXT, next_context TEXT )5I#indexsqlite_autoindex_breadcrumbs_1breadcrumbs�v !!�7tableplan_stepsplan_steps CREATE TABLE plan_steps ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_order INTEGER NOT NULL, description TEXT NOT NULL, status TEXT DEFAULT 'pending' CHECK(status IN ('pending', 'in_progress', 'completed', 'failed', 'skipped')), created_at TEXT DEFAULT (datetime('now')) )3 G!indexsqlite_autoindex_plan_steps_1plan_steps �V � tableplansplans CREATE TABLE plans ( id TEXT PRIMARY KEY, created_at TEXT DEFAULT (datetime('now')), status TEXT DEFAULT 'accepted' CHECK(status IN ('accepted', 'in_progress', 'completed', 'abandoned')), description TEXT, plan_markdown TEXT NOT NULL, session_id TEXT, thread_id TEXT REFERENCES threads(id) )) =indexsqlite_autoindex_plans_1plans �++�Ctablethread_sessionsthread_sessionsCREATE TABLE thread_sessions ( thread_id TEXT NOT NULL REFERENCES threads(id) ON DELETE CASCADE, session_id TEXT NOT NULL, created_at TEXT DEFAULT (datetime('now')), PRIMARY KEY (thread_id, session_id) )=Q+indexsqlite_autoindex_thread_sessions_1thread_sessions Q-iindexidx_threads_namethreadsCREATE INDEX idx_threads_name ON threads(name)W1qindexidx_threads_statusthreadsCREATE INDEX idx_threads_status ON threads(status)c3�indexidx_threads_updatedthreadsCREATE INDEX idx_threads_updated ON threads(updated_at DESC)�,�/tablethreadsthreadsCREATE TABLE threads ( id TEXT PRIMARY KEY, name TEXT NOT NULL UNIQUE, created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), current_plan_id TEXT REFERENCES plans(id), git_branches TEXT, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'paused', 'completed', 'archived')) )-Aindexsqlite_autoindex_threads_2threads-Aindexsqlite_autoindex_threads_1threads Wd^�彔MZ3�A�K,� ����d O  � � � ��s��}�&''� tablesession_statesession_stateCREATE TABLE session_state ( key TEXT PRIMARY KEY, value TEXT NOT NULL, updated_at TEXT DEFAULT (datetime('now')) )9M'indexsqlite_autoindex_session_state_1session_stateP++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)�^##�tableworker_logsworker_logsCREATE TABLE worker_logs ( id INTEGER PRIMARY KEY AUTOINCREMENT, worker_id TEXT NOT NULL REFERENCES workers(id) ON DELETE CASCADE, timestamp TEXT NOT NULL DEFAULT (datetime('now')), stream TEXT NOT NULL CHECK(stream IN ('stdout', 'stderr', 'system')), line TEXT NOT NULL, iteration INTEGER )-Aindexsqlite_autoindex_workers_1workers�m�1tableworkersworkersCREATE TABLE workers ( id TEXT PRIMARY KEY, container_id TEXT NOT NULL, thread_id TEXT NOT NULL REFERENCES threads(id), status TEXT DEFAULT 'running' CHECK(status IN ('running', 'completed', 'failed', 'killed')), last_heartbeat TEXT DEFAULT (datetime('now')), created_at TEXT DEFAULT (datetime('now')), auth_mode TEXT CHECK(auth_mode IN ('env', 'config', 'oauth')), iteration INTEGER DEFAULT 0, max_iterations INTEGER DEFAULT 50 )/Cindexsqlite_autoindex_next_ups_1next_ups�<�Ktablenext_upsnext_upsCREATE TABLE next_ups ( id TEXT PRIMARY KEY, title TEXT NOT NULL, content TEXT NOT NULL, is_template INTEGER NOT NULL DEFAULT 0, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'archived', 'launched')), created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), last_launched_at TEXT, launch_count INTEGER DEFAULT 0 )5I#indexsqlite_autoindex_bug_reports_1bug_reports�\##�tablebug_reportsbug_reportsCREATE TABLE bug_reports ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), title TEXT NOT NULL, repro_steps TEXT NOT NULL, evidence TEXT, status TEXT DEFAULT 'open' CHECK(status IN ('open', 'resolved', 'wontfix')) )5I#indexsqlite_autoindex_corrections_1corrections�##�ktablecorrectionscorrectionsCREATE TABLE corrections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), mistake TEXT NOT NULL, symptoms TEXT, resolution TEXT, tags TEXT )5I#indexsqlite_autoindex_reflections_1reflections�+##�tablereflectionsreflectionsCREATE TABLE reflections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), trigger TEXT CHECK(trigger IN ('manual', 'compact', 'completion', 'stop')), content TEXT NOT NULL )5I#indexsqlite_autoindex_breadcrumbs_1breadcrumbsWd^�彔M�s�)��� Wd^�彔M�ٻ'W(l Wd^�彔M@�ɪ�ji�SQLite format 3@  .zp�� � - � � �  g` ��)Jx�h�77/Cindexsqlite_autoindex_next_ups_1next_ups�\##�tablebug_reportsbug_reportsCREATE TABLE bug_reports ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), title TEXT NOT NULL, repro_steps TEXT NOT NULL, evidence TEXT, status TEXT DEFAULT 'open' CHECK(status IN ('open', 'resolved', 'wontfix')) )5I#indexsqlite_autoindex_bug_reports_1bug_reports�##�ktablecorrectionscorrectionsCREATE TABLE corrections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), mistake TEXT NOT NULL, symptoms TEXT, resolution TEXT, tags TEXT )5I#indexsqlite_autoindex_corrections_1corrections�+##�tablereflectionsreflectionsCREATE TABLE reflections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), trigger TEXT CHECK(trigger IN ('manual', 'compact', 'completion', 'stop')), content TEXT NOT NULL )5I#indexsqlite_autoindex_reflections_1reflections�w ##�5tablebreadcrumbsbreadcrumbsCREATE TABLE breadcrumbs ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_id TEXT REFERENCES plan_steps(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), agent_type TEXT, summary TEXT NOT NULL, files_touched TEXT, issues TEXT, next_context TEXT )5I#indexsqlite_autoindex_breadcrumbs_1breadcrumbs�v !!�7tableplan_stepsplan_steps CREATE TABLE plan_steps ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_order INTEGER NOT NULL, description TEXT NOT NULL, status TEXT DEFAULT 'pending' CHECK(status IN ('pending', 'in_progress', 'completed', 'failed', 'skipped')), created_at TEXT DEFAULT (datetime('now')) )3 G!indexsqlite_autoindex_plan_steps_1plan_steps �V � tableplansplans CREATE TABLE plans ( id TEXT PRIMARY KEY, created_at TEXT DEFAULT (datetime('now')), status TEXT DEFAULT 'accepted' CHECK(status IN ('accepted', 'in_progress', 'completed', 'abandoned')), description TEXT, plan_markdown TEXT NOT NULL, session_id TEXT, thread_id TEXT REFERENCES threads(id) )) =indexsqlite_autoindex_plans_1plans �++�Ctablethread_sessionsthread_sessionsCREATE TABLE thread_sessions ( thread_id TEXT NOT NULL REFERENCES threads(id) ON DELETE CASCADE, session_id TEXT NOT NULL, created_at TEXT DEFAULT (datetime('now')), PRIMARY KEY (thread_id, session_id) )=Q+indexsqlite_autoindex_thread_sessions_1thread_sessions Q-iindexidx_threads_namethreadsCREATE INDEX idx_threads_name ON threads(name)W1qindexidx_threads_statusthreadsCREATE INDEX idx_threads_status ON threads(status)c3�indexidx_threads_updatedthreadsCREATE INDEX idx_threads_updated ON threads(updated_at DESC)�,�/tablethreadsthreadsCREATE TABLE threads ( id TEXT PRIMARY KEY, name TEXT NOT NULL UNIQUE, created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), current_plan_id TEXT REFERENCES plans(id), git_branches TEXT, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'paused', 'completed', 'archived')) )-Aindexsqlite_autoindex_threads_2threads-Aindexsqlite_autoindex_threads_1threads Wd^�彔MWnǦ�b6� �\��d O  � � � ��s��}\v5#�!indexidx_breadcrumbs_planbreadcrumbs CREATE INDEX idx_breadcrumbs_plan ON breadcrumbs(plan_id, created_at DESC)�&''� tablesession_statesession_stateCREATE TABLE session_state ( key TEXT PRIMARY KEY, value TEXT NOT NULL, updated_at TEXT DEFAULT (datetime('now')) )9M'indexsqlite_autoindex_session_state_1session_stateP++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)�^##�tableworker_logsworker_logsCREATE TABLE worker_logs ( id INTEGER PRIMARY KEY AUTOINCREMENT, worker_id TEXT NOT NULL REFERENCES workers(id) ON DELETE CASCADE, timestamp TEXT NOT NULL DEFAULT (datetime('now')), stream TEXT NOT NULL CHECK(stream IN ('stdout', 'stderr', 'system')), line TEXT NOT NULL, iteration INTEGER )-Aindexsqlite_autoindex_workers_1workers�m�1tableworkersworkersCREATE TABLE workers ( id TEXT PRIMARY KEY, container_id TEXT NOT NULL, thread_id TEXT NOT NULL REFERENCES threads(id), status TEXT DEFAULT 'running' CHECK(status IN ('running', 'completed', 'failed', 'killed')), last_heartbeat TEXT DEFAULT (datetime('now')), created_at TEXT DEFAULT (datetime('now')), auth_mode TEXT CHECK(auth_mode IN ('env', 'config', 'oauth')), iteration INTEGER DEFAULT 0, max_iterations INTEGER DEFAULT 50 )/Cindexsqlite_autoindex_next_ups_1next_ups�<�Ktablenext_upsnext_upsCREATE TABLE next_ups ( id TEXT PRIMARY KEY, title TEXT NOT NULL, content TEXT NOT NULL, is_template INTEGER NOT NULL DEFAULT 0, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'archived', 'launched')), created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), last_launched_at TEXT, launch_count INTEGER DEFAULT 0 )5I#indexsqlite_autoindex_bug_reports_1bug_reports�\##�tablebug_reportsbug_reportsCREATE TABLE bug_reports ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), title TEXT NOT NULL, repro_steps TEXT NOT NULL, evidence TEXT, status TEXT DEFAULT 'open' CHECK(status IN ('open', 'resolved', 'wontfix')) )5I#indexsqlite_autoindex_corrections_1corrections�##�ktablecorrectionscorrectionsCREATE TABLE corrections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), mistake TEXT NOT NULL, symptoms TEXT, resolution TEXT, tags TEXT )5I#indexsqlite_autoindex_reflections_1reflections�+##�tablereflectionsreflectionsCREATE TABLE reflections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), trigger TEXT CHECK(trigger IN ('manual', 'compact', 'completion', 'stop')), content TEXT NOT NULL )5I#indexsqlite_autoindex_breadcrumbs_1breadcrumbs Wd^�彔M����=H_ Wd^�彔M��9AX�ISQLite format 3@ !.zp�� � - � � �  g` ��)Jx�h�77/Cindexsqlite_autoindex_next_ups_1next_ups�\##�tablebug_reportsbug_reportsCREATE TABLE bug_reports ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), title TEXT NOT NULL, repro_steps TEXT NOT NULL, evidence TEXT, status TEXT DEFAULT 'open' CHECK(status IN ('open', 'resolved', 'wontfix')) )5I#indexsqlite_autoindex_bug_reports_1bug_reports�##�ktablecorrectionscorrectionsCREATE TABLE corrections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), mistake TEXT NOT NULL, symptoms TEXT, resolution TEXT, tags TEXT )5I#indexsqlite_autoindex_corrections_1corrections�+##�tablereflectionsreflectionsCREATE TABLE reflections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), trigger TEXT CHECK(trigger IN ('manual', 'compact', 'completion', 'stop')), content TEXT NOT NULL )5I#indexsqlite_autoindex_reflections_1reflections�w ##�5tablebreadcrumbsbreadcrumbsCREATE TABLE breadcrumbs ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_id TEXT REFERENCES plan_steps(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), agent_type TEXT, summary TEXT NOT NULL, files_touched TEXT, issues TEXT, next_context TEXT )5I#indexsqlite_autoindex_breadcrumbs_1breadcrumbs�v !!�7tableplan_stepsplan_steps CREATE TABLE plan_steps ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_order INTEGER NOT NULL, description TEXT NOT NULL, status TEXT DEFAULT 'pending' CHECK(status IN ('pending', 'in_progress', 'completed', 'failed', 'skipped')), created_at TEXT DEFAULT (datetime('now')) )3 G!indexsqlite_autoindex_plan_steps_1plan_steps �V � tableplansplans CREATE TABLE plans ( id TEXT PRIMARY KEY, created_at TEXT DEFAULT (datetime('now')), status TEXT DEFAULT 'accepted' CHECK(status IN ('accepted', 'in_progress', 'completed', 'abandoned')), description TEXT, plan_markdown TEXT NOT NULL, session_id TEXT, thread_id TEXT REFERENCES threads(id) )) =indexsqlite_autoindex_plans_1plans �++�Ctablethread_sessionsthread_sessionsCREATE TABLE thread_sessions ( thread_id TEXT NOT NULL REFERENCES threads(id) ON DELETE CASCADE, session_id TEXT NOT NULL, created_at TEXT DEFAULT (datetime('now')), PRIMARY KEY (thread_id, session_id) )=Q+indexsqlite_autoindex_thread_sessions_1thread_sessions Q-iindexidx_threads_namethreadsCREATE INDEX idx_threads_name ON threads(name)W1qindexidx_threads_statusthreadsCREATE INDEX idx_threads_status ON threads(status)c3�indexidx_threads_updatedthreadsCREATE INDEX idx_threads_updated ON threads(updated_at DESC)�,�/tablethreadsthreadsCREATE TABLE threads ( id TEXT PRIMARY KEY, name TEXT NOT NULL UNIQUE, created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), current_plan_id TEXT REFERENCES plans(id), git_branches TEXT, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'paused', 'completed', 'archived')) )-Aindexsqlite_autoindex_threads_2threads-Aindexsqlite_autoindex_threads_1threads Wd^�彔Mip$)��N� ����d O  � � � ��s��}\�c)!� indexidx_steps_planplan_steps!CREATE INDEX idx_steps_plan ON plan_steps(plan_id, step_order)v5#�!indexidx_breadcrumbs_planbreadcrumbs CREATE INDEX idx_breadcrumbs_plan ON breadcrumbs(plan_id, created_at DESC)�&''� tablesession_statesession_stateCREATE TABLE session_state ( key TEXT PRIMARY KEY, value TEXT NOT NULL, updated_at TEXT DEFAULT (datetime('now')) )9M'indexsqlite_autoindex_session_state_1session_stateP++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)�^##�tableworker_logsworker_logsCREATE TABLE worker_logs ( id INTEGER PRIMARY KEY AUTOINCREMENT, worker_id TEXT NOT NULL REFERENCES workers(id) ON DELETE CASCADE, timestamp TEXT NOT NULL DEFAULT (datetime('now')), stream TEXT NOT NULL CHECK(stream IN ('stdout', 'stderr', 'system')), line TEXT NOT NULL, iteration INTEGER )-Aindexsqlite_autoindex_workers_1workers�m�1tableworkersworkersCREATE TABLE workers ( id TEXT PRIMARY KEY, container_id TEXT NOT NULL, thread_id TEXT NOT NULL REFERENCES threads(id), status TEXT DEFAULT 'running' CHECK(status IN ('running', 'completed', 'failed', 'killed')), last_heartbeat TEXT DEFAULT (datetime('now')), created_at TEXT DEFAULT (datetime('now')), auth_mode TEXT CHECK(auth_mode IN ('env', 'config', 'oauth')), iteration INTEGER DEFAULT 0, max_iterations INTEGER DEFAULT 50 )/Cindexsqlite_autoindex_next_ups_1next_ups�<�Ktablenext_upsnext_upsCREATE TABLE next_ups ( id TEXT PRIMARY KEY, title TEXT NOT NULL, content TEXT NOT NULL, is_template INTEGER NOT NULL DEFAULT 0, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'archived', 'launched')), created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), last_launched_at TEXT, launch_count INTEGER DEFAULT 0 )5I#indexsqlite_autoindex_bug_reports_1bug_reports�\##�tablebug_reportsbug_reportsCREATE TABLE bug_reports ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), title TEXT NOT NULL, repro_steps TEXT NOT NULL, evidence TEXT, status TEXT DEFAULT 'open' CHECK(status IN ('open', 'resolved', 'wontfix')) )5I#indexsqlite_autoindex_corrections_1corrections�##�ktablecorrectionscorrectionsCREATE TABLE corrections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), mistake TEXT NOT NULL, symptoms TEXT, resolution TEXT, tags TEXT )5I#indexsqlite_autoindex_reflections_1reflections�+##�tablereflectionsreflectionsCREATE TABLE reflections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), trigger TEXT CHECK(trigger IN ('manual', 'compact', 'completion', 'stop')), content TEXT NOT NULL )5I#indexsqlite_autoindex_breadcrumbs_1breadcrumbs!!Wd^�彔My��� Wd^�彔Mw��d�I�\SQLite format 3@ ".zp�� � - � � �  g` ��)Jx�h�77/Cindexsqlite_autoindex_next_ups_1next_ups�\##�tablebug_reportsbug_reportsCREATE TABLE bug_reports ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), title TEXT NOT NULL, repro_steps TEXT NOT NULL, evidence TEXT, status TEXT DEFAULT 'open' CHECK(status IN ('open', 'resolved', 'wontfix')) )5I#indexsqlite_autoindex_bug_reports_1bug_reports�##�ktablecorrectionscorrectionsCREATE TABLE corrections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), mistake TEXT NOT NULL, symptoms TEXT, resolution TEXT, tags TEXT )5I#indexsqlite_autoindex_corrections_1corrections�+##�tablereflectionsreflectionsCREATE TABLE reflections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), trigger TEXT CHECK(trigger IN ('manual', 'compact', 'completion', 'stop')), content TEXT NOT NULL )5I#indexsqlite_autoindex_reflections_1reflections�w ##�5tablebreadcrumbsbreadcrumbsCREATE TABLE breadcrumbs ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_id TEXT REFERENCES plan_steps(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), agent_type TEXT, summary TEXT NOT NULL, files_touched TEXT, issues TEXT, next_context TEXT )5I#indexsqlite_autoindex_breadcrumbs_1breadcrumbs�v !!�7tableplan_stepsplan_steps CREATE TABLE plan_steps ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_order INTEGER NOT NULL, description TEXT NOT NULL, status TEXT DEFAULT 'pending' CHECK(status IN ('pending', 'in_progress', 'completed', 'failed', 'skipped')), created_at TEXT DEFAULT (datetime('now')) )3 G!indexsqlite_autoindex_plan_steps_1plan_steps �V � tableplansplans CREATE TABLE plans ( id TEXT PRIMARY KEY, created_at TEXT DEFAULT (datetime('now')), status TEXT DEFAULT 'accepted' CHECK(status IN ('accepted', 'in_progress', 'completed', 'abandoned')), description TEXT, plan_markdown TEXT NOT NULL, session_id TEXT, thread_id TEXT REFERENCES threads(id) )) =indexsqlite_autoindex_plans_1plans �++�Ctablethread_sessionsthread_sessionsCREATE TABLE thread_sessions ( thread_id TEXT NOT NULL REFERENCES threads(id) ON DELETE CASCADE, session_id TEXT NOT NULL, created_at TEXT DEFAULT (datetime('now')), PRIMARY KEY (thread_id, session_id) )=Q+indexsqlite_autoindex_thread_sessions_1thread_sessions Q-iindexidx_threads_namethreadsCREATE INDEX idx_threads_name ON threads(name)W1qindexidx_threads_statusthreadsCREATE INDEX idx_threads_status ON threads(status)c3�indexidx_threads_updatedthreadsCREATE INDEX idx_threads_updated ON threads(updated_at DESC)�,�/tablethreadsthreadsCREATE TABLE threads ( id TEXT PRIMARY KEY, name TEXT NOT NULL UNIQUE, created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), current_plan_id TEXT REFERENCES plans(id), git_branches TEXT, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'paused', 'completed', 'archived')) )-Aindexsqlite_autoindex_threads_2threads-Aindexsqlite_autoindex_threads_1threads Wd^�彔Mc�Z��)@� ����d O  � � � ��s��}\��Y-!sindexidx_steps_statusplan_steps"CREATE INDEX idx_steps_status ON plan_steps(status)c)!� indexidx_steps_planplan_steps!CREATE INDEX idx_steps_plan ON plan_steps(plan_id, step_order)v5#�!indexidx_breadcrumbs_planbreadcrumbs CREATE INDEX idx_breadcrumbs_plan ON breadcrumbs(plan_id, created_at DESC)�&''� tablesession_statesession_stateCREATE TABLE session_state ( key TEXT PRIMARY KEY, value TEXT NOT NULL, updated_at TEXT DEFAULT (datetime('now')) )9M'indexsqlite_autoindex_session_state_1session_stateP++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)�^##�tableworker_logsworker_logsCREATE TABLE worker_logs ( id INTEGER PRIMARY KEY AUTOINCREMENT, worker_id TEXT NOT NULL REFERENCES workers(id) ON DELETE CASCADE, timestamp TEXT NOT NULL DEFAULT (datetime('now')), stream TEXT NOT NULL CHECK(stream IN ('stdout', 'stderr', 'system')), line TEXT NOT NULL, iteration INTEGER )-Aindexsqlite_autoindex_workers_1workers�m�1tableworkersworkersCREATE TABLE workers ( id TEXT PRIMARY KEY, container_id TEXT NOT NULL, thread_id TEXT NOT NULL REFERENCES threads(id), status TEXT DEFAULT 'running' CHECK(status IN ('running', 'completed', 'failed', 'killed')), last_heartbeat TEXT DEFAULT (datetime('now')), created_at TEXT DEFAULT (datetime('now')), auth_mode TEXT CHECK(auth_mode IN ('env', 'config', 'oauth')), iteration INTEGER DEFAULT 0, max_iterations INTEGER DEFAULT 50 )/Cindexsqlite_autoindex_next_ups_1next_ups�<�Ktablenext_upsnext_upsCREATE TABLE next_ups ( id TEXT PRIMARY KEY, title TEXT NOT NULL, content TEXT NOT NULL, is_template INTEGER NOT NULL DEFAULT 0, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'archived', 'launched')), created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), last_launched_at TEXT, launch_count INTEGER DEFAULT 0 )5I#indexsqlite_autoindex_bug_reports_1bug_reports�\##�tablebug_reportsbug_reportsCREATE TABLE bug_reports ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), title TEXT NOT NULL, repro_steps TEXT NOT NULL, evidence TEXT, status TEXT DEFAULT 'open' CHECK(status IN ('open', 'resolved', 'wontfix')) )5I#indexsqlite_autoindex_corrections_1corrections�##�ktablecorrectionscorrectionsCREATE TABLE corrections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), mistake TEXT NOT NULL, symptoms TEXT, resolution TEXT, tags TEXT )5I#indexsqlite_autoindex_reflections_1reflections�+##�tablereflectionsreflectionsCREATE TABLE reflections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), trigger TEXT CHECK(trigger IN ('manual', 'compact', 'completion', 'stop')), content TEXT NOT NULL )5I#indexsqlite_autoindex_breadcrumbs_1breadcrumbs""Wd^�彔M[�t���y� Wd^�彔M��_a��SQLite format 3@ #.zp�� � - � � �  g` ��)Jx�h�77/Cindexsqlite_autoindex_next_ups_1next_ups�\##�tablebug_reportsbug_reportsCREATE TABLE bug_reports ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), title TEXT NOT NULL, repro_steps TEXT NOT NULL, evidence TEXT, status TEXT DEFAULT 'open' CHECK(status IN ('open', 'resolved', 'wontfix')) )5I#indexsqlite_autoindex_bug_reports_1bug_reports�##�ktablecorrectionscorrectionsCREATE TABLE corrections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), mistake TEXT NOT NULL, symptoms TEXT, resolution TEXT, tags TEXT )5I#indexsqlite_autoindex_corrections_1corrections�+##�tablereflectionsreflectionsCREATE TABLE reflections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), trigger TEXT CHECK(trigger IN ('manual', 'compact', 'completion', 'stop')), content TEXT NOT NULL )5I#indexsqlite_autoindex_reflections_1reflections�w ##�5tablebreadcrumbsbreadcrumbsCREATE TABLE breadcrumbs ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_id TEXT REFERENCES plan_steps(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), agent_type TEXT, summary TEXT NOT NULL, files_touched TEXT, issues TEXT, next_context TEXT )5I#indexsqlite_autoindex_breadcrumbs_1breadcrumbs�v !!�7tableplan_stepsplan_steps CREATE TABLE plan_steps ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_order INTEGER NOT NULL, description TEXT NOT NULL, status TEXT DEFAULT 'pending' CHECK(status IN ('pending', 'in_progress', 'completed', 'failed', 'skipped')), created_at TEXT DEFAULT (datetime('now')) )3 G!indexsqlite_autoindex_plan_steps_1plan_steps �V � tableplansplans CREATE TABLE plans ( id TEXT PRIMARY KEY, created_at TEXT DEFAULT (datetime('now')), status TEXT DEFAULT 'accepted' CHECK(status IN ('accepted', 'in_progress', 'completed', 'abandoned')), description TEXT, plan_markdown TEXT NOT NULL, session_id TEXT, thread_id TEXT REFERENCES threads(id) )) =indexsqlite_autoindex_plans_1plans �++�Ctablethread_sessionsthread_sessionsCREATE TABLE thread_sessions ( thread_id TEXT NOT NULL REFERENCES threads(id) ON DELETE CASCADE, session_id TEXT NOT NULL, created_at TEXT DEFAULT (datetime('now')), PRIMARY KEY (thread_id, session_id) )=Q+indexsqlite_autoindex_thread_sessions_1thread_sessions Q-iindexidx_threads_namethreadsCREATE INDEX idx_threads_name ON threads(name)W1qindexidx_threads_statusthreadsCREATE INDEX idx_threads_status ON threads(status)c3�indexidx_threads_updatedthreadsCREATE INDEX idx_threads_updated ON threads(updated_at DESC)�,�/tablethreadsthreadsCREATE TABLE threads ( id TEXT PRIMARY KEY, name TEXT NOT NULL UNIQUE, created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), current_plan_id TEXT REFERENCES plans(id), git_branches TEXT, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'paused', 'completed', 'archived')) )-Aindexsqlite_autoindex_threads_2threads-Aindexsqlite_autoindex_threads_1threads Wd^�彔M�Qj�R�<� �6��d O  � � � ��s��}\��6d -�indexidx_plans_threadplans#CREATE INDEX idx_plans_thread ON plans(thread_id, created_at DESC)Y-!sindexidx_steps_statusplan_steps"CREATE INDEX idx_steps_status ON plan_steps(status)c)!� indexidx_steps_planplan_steps!CREATE INDEX idx_steps_plan ON plan_steps(plan_id, step_order)v5#�!indexidx_breadcrumbs_planbreadcrumbs CREATE INDEX idx_breadcrumbs_plan ON breadcrumbs(plan_id, created_at DESC)�&''� tablesession_statesession_stateCREATE TABLE session_state ( key TEXT PRIMARY KEY, value TEXT NOT NULL, updated_at TEXT DEFAULT (datetime('now')) )9M'indexsqlite_autoindex_session_state_1session_stateP++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)�^##�tableworker_logsworker_logsCREATE TABLE worker_logs ( id INTEGER PRIMARY KEY AUTOINCREMENT, worker_id TEXT NOT NULL REFERENCES workers(id) ON DELETE CASCADE, timestamp TEXT NOT NULL DEFAULT (datetime('now')), stream TEXT NOT NULL CHECK(stream IN ('stdout', 'stderr', 'system')), line TEXT NOT NULL, iteration INTEGER )-Aindexsqlite_autoindex_workers_1workers�m�1tableworkersworkersCREATE TABLE workers ( id TEXT PRIMARY KEY, container_id TEXT NOT NULL, thread_id TEXT NOT NULL REFERENCES threads(id), status TEXT DEFAULT 'running' CHECK(status IN ('running', 'completed', 'failed', 'killed')), last_heartbeat TEXT DEFAULT (datetime('now')), created_at TEXT DEFAULT (datetime('now')), auth_mode TEXT CHECK(auth_mode IN ('env', 'config', 'oauth')), iteration INTEGER DEFAULT 0, max_iterations INTEGER DEFAULT 50 )/Cindexsqlite_autoindex_next_ups_1next_ups�<�Ktablenext_upsnext_upsCREATE TABLE next_ups ( id TEXT PRIMARY KEY, title TEXT NOT NULL, content TEXT NOT NULL, is_template INTEGER NOT NULL DEFAULT 0, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'archived', 'launched')), created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), last_launched_at TEXT, launch_count INTEGER DEFAULT 0 )5I#indexsqlite_autoindex_bug_reports_1bug_reports�\##�tablebug_reportsbug_reportsCREATE TABLE bug_reports ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), title TEXT NOT NULL, repro_steps TEXT NOT NULL, evidence TEXT, status TEXT DEFAULT 'open' CHECK(status IN ('open', 'resolved', 'wontfix')) )5I#indexsqlite_autoindex_corrections_1corrections�##�ktablecorrectionscorrectionsCREATE TABLE corrections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), mistake TEXT NOT NULL, symptoms TEXT, resolution TEXT, tags TEXT )5I#indexsqlite_autoindex_reflections_1reflections�+##�tablereflectionsreflectionsCREATE TABLE reflections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), trigger TEXT CHECK(trigger IN ('manual', 'compact', 'completion', 'stop')), content TEXT NOT NULL )5I#indexsqlite_autoindex_breadcrumbs_1breadcrumbs##Wd^�彔Mbh�mY)-l Wd^�彔MrR�J���SQLite format 3@ $.zp�� � - � � �  g` ��)Jx�h�77/Cindexsqlite_autoindex_next_ups_1next_ups�\##�tablebug_reportsbug_reportsCREATE TABLE bug_reports ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), title TEXT NOT NULL, repro_steps TEXT NOT NULL, evidence TEXT, status TEXT DEFAULT 'open' CHECK(status IN ('open', 'resolved', 'wontfix')) )5I#indexsqlite_autoindex_bug_reports_1bug_reports�##�ktablecorrectionscorrectionsCREATE TABLE corrections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), mistake TEXT NOT NULL, symptoms TEXT, resolution TEXT, tags TEXT )5I#indexsqlite_autoindex_corrections_1corrections�+##�tablereflectionsreflectionsCREATE TABLE reflections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), trigger TEXT CHECK(trigger IN ('manual', 'compact', 'completion', 'stop')), content TEXT NOT NULL )5I#indexsqlite_autoindex_reflections_1reflections�w ##�5tablebreadcrumbsbreadcrumbsCREATE TABLE breadcrumbs ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_id TEXT REFERENCES plan_steps(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), agent_type TEXT, summary TEXT NOT NULL, files_touched TEXT, issues TEXT, next_context TEXT )5I#indexsqlite_autoindex_breadcrumbs_1breadcrumbs�v !!�7tableplan_stepsplan_steps CREATE TABLE plan_steps ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_order INTEGER NOT NULL, description TEXT NOT NULL, status TEXT DEFAULT 'pending' CHECK(status IN ('pending', 'in_progress', 'completed', 'failed', 'skipped')), created_at TEXT DEFAULT (datetime('now')) )3 G!indexsqlite_autoindex_plan_steps_1plan_steps �V � tableplansplans CREATE TABLE plans ( id TEXT PRIMARY KEY, created_at TEXT DEFAULT (datetime('now')), status TEXT DEFAULT 'accepted' CHECK(status IN ('accepted', 'in_progress', 'completed', 'abandoned')), description TEXT, plan_markdown TEXT NOT NULL, session_id TEXT, thread_id TEXT REFERENCES threads(id) )) =indexsqlite_autoindex_plans_1plans �++�Ctablethread_sessionsthread_sessionsCREATE TABLE thread_sessions ( thread_id TEXT NOT NULL REFERENCES threads(id) ON DELETE CASCADE, session_id TEXT NOT NULL, created_at TEXT DEFAULT (datetime('now')), PRIMARY KEY (thread_id, session_id) )=Q+indexsqlite_autoindex_thread_sessions_1thread_sessions Q-iindexidx_threads_namethreadsCREATE INDEX idx_threads_name ON threads(name)W1qindexidx_threads_statusthreadsCREATE INDEX idx_threads_status ON threads(status)c3�indexidx_threads_updatedthreadsCREATE INDEX idx_threads_updated ON threads(updated_at DESC)�,�/tablethreadsthreadsCREATE TABLE threads ( id TEXT PRIMARY KEY, name TEXT NOT NULL UNIQUE, created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), current_plan_id TEXT REFERENCES plans(id), git_branches TEXT, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'paused', 'completed', 'archived')) )-Aindexsqlite_autoindex_threads_2threads-Aindexsqlite_autoindex_threads_1threads Wd^�彔M��6ӋU�} ����d O  � � � ��s��}\��6�[!3uindexidx_next_ups_statusnext_ups$CREATE INDEX idx_next_ups_status ON next_ups(status)d -�indexidx_plans_threadplans#CREATE INDEX idx_plans_thread ON plans(thread_id, created_at DESC)Y-!sindexidx_steps_statusplan_steps"CREATE INDEX idx_steps_status ON plan_steps(status)c)!� indexidx_steps_planplan_steps!CREATE INDEX idx_steps_plan ON plan_steps(plan_id, step_order)v5#�!indexidx_breadcrumbs_planbreadcrumbs CREATE INDEX idx_breadcrumbs_plan ON breadcrumbs(plan_id, created_at DESC)�&''� tablesession_statesession_stateCREATE TABLE session_state ( key TEXT PRIMARY KEY, value TEXT NOT NULL, updated_at TEXT DEFAULT (datetime('now')) )9M'indexsqlite_autoindex_session_state_1session_stateP++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)�^##�tableworker_logsworker_logsCREATE TABLE worker_logs ( id INTEGER PRIMARY KEY AUTOINCREMENT, worker_id TEXT NOT NULL REFERENCES workers(id) ON DELETE CASCADE, timestamp TEXT NOT NULL DEFAULT (datetime('now')), stream TEXT NOT NULL CHECK(stream IN ('stdout', 'stderr', 'system')), line TEXT NOT NULL, iteration INTEGER )-Aindexsqlite_autoindex_workers_1workers�m�1tableworkersworkersCREATE TABLE workers ( id TEXT PRIMARY KEY, container_id TEXT NOT NULL, thread_id TEXT NOT NULL REFERENCES threads(id), status TEXT DEFAULT 'running' CHECK(status IN ('running', 'completed', 'failed', 'killed')), last_heartbeat TEXT DEFAULT (datetime('now')), created_at TEXT DEFAULT (datetime('now')), auth_mode TEXT CHECK(auth_mode IN ('env', 'config', 'oauth')), iteration INTEGER DEFAULT 0, max_iterations INTEGER DEFAULT 50 )/Cindexsqlite_autoindex_next_ups_1next_ups�<�Ktablenext_upsnext_upsCREATE TABLE next_ups ( id TEXT PRIMARY KEY, title TEXT NOT NULL, content TEXT NOT NULL, is_template INTEGER NOT NULL DEFAULT 0, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'archived', 'launched')), created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), last_launched_at TEXT, launch_count INTEGER DEFAULT 0 )5I#indexsqlite_autoindex_bug_reports_1bug_reports�\##�tablebug_reportsbug_reportsCREATE TABLE bug_reports ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), title TEXT NOT NULL, repro_steps TEXT NOT NULL, evidence TEXT, status TEXT DEFAULT 'open' CHECK(status IN ('open', 'resolved', 'wontfix')) )5I#indexsqlite_autoindex_corrections_1corrections�##�ktablecorrectionscorrectionsCREATE TABLE corrections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), mistake TEXT NOT NULL, symptoms TEXT, resolution TEXT, tags TEXT )5I#indexsqlite_autoindex_reflections_1reflections�+##�tablereflectionsreflectionsCREATE TABLE reflections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), trigger TEXT CHECK(trigger IN ('manual', 'compact', 'completion', 'stop')), content TEXT NOT NULL )5I#indexsqlite_autoindex_breadcrumbs_1breadcrumbs$$Wd^�彔M������ Wd^�彔M$��N��'YSQLite format 3@ %.zp�� � - � � �  g` ��)Jx�h�77/Cindexsqlite_autoindex_next_ups_1next_ups�\##�tablebug_reportsbug_reportsCREATE TABLE bug_reports ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), title TEXT NOT NULL, repro_steps TEXT NOT NULL, evidence TEXT, status TEXT DEFAULT 'open' CHECK(status IN ('open', 'resolved', 'wontfix')) )5I#indexsqlite_autoindex_bug_reports_1bug_reports�##�ktablecorrectionscorrectionsCREATE TABLE corrections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), mistake TEXT NOT NULL, symptoms TEXT, resolution TEXT, tags TEXT )5I#indexsqlite_autoindex_corrections_1corrections�+##�tablereflectionsreflectionsCREATE TABLE reflections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), trigger TEXT CHECK(trigger IN ('manual', 'compact', 'completion', 'stop')), content TEXT NOT NULL )5I#indexsqlite_autoindex_reflections_1reflections�w ##�5tablebreadcrumbsbreadcrumbsCREATE TABLE breadcrumbs ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_id TEXT REFERENCES plan_steps(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), agent_type TEXT, summary TEXT NOT NULL, files_touched TEXT, issues TEXT, next_context TEXT )5I#indexsqlite_autoindex_breadcrumbs_1breadcrumbs�v !!�7tableplan_stepsplan_steps CREATE TABLE plan_steps ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_order INTEGER NOT NULL, description TEXT NOT NULL, status TEXT DEFAULT 'pending' CHECK(status IN ('pending', 'in_progress', 'completed', 'failed', 'skipped')), created_at TEXT DEFAULT (datetime('now')) )3 G!indexsqlite_autoindex_plan_steps_1plan_steps �V � tableplansplans CREATE TABLE plans ( id TEXT PRIMARY KEY, created_at TEXT DEFAULT (datetime('now')), status TEXT DEFAULT 'accepted' CHECK(status IN ('accepted', 'in_progress', 'completed', 'abandoned')), description TEXT, plan_markdown TEXT NOT NULL, session_id TEXT, thread_id TEXT REFERENCES threads(id) )) =indexsqlite_autoindex_plans_1plans �++�Ctablethread_sessionsthread_sessionsCREATE TABLE thread_sessions ( thread_id TEXT NOT NULL REFERENCES threads(id) ON DELETE CASCADE, session_id TEXT NOT NULL, created_at TEXT DEFAULT (datetime('now')), PRIMARY KEY (thread_id, session_id) )=Q+indexsqlite_autoindex_thread_sessions_1thread_sessions Q-iindexidx_threads_namethreadsCREATE INDEX idx_threads_name ON threads(name)W1qindexidx_threads_statusthreadsCREATE INDEX idx_threads_status ON threads(status)c3�indexidx_threads_updatedthreadsCREATE INDEX idx_threads_updated ON threads(updated_at DESC)�,�/tablethreadsthreadsCREATE TABLE threads ( id TEXT PRIMARY KEY, name TEXT NOT NULL UNIQUE, created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), current_plan_id TEXT REFERENCES plans(id), git_branches TEXT, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'paused', 'completed', 'archived')) )-Aindexsqlite_autoindex_threads_2threads-Aindexsqlite_autoindex_threads_1threads Wd^�彔M�\)f�'�� �p��d O  � � � ��s��}\��6�pg"5� indexidx_next_ups_updatednext_ups%CREATE INDEX idx_next_ups_updated ON next_ups(updated_at DESC)[!3uindexidx_next_ups_statusnext_ups$CREATE INDEX idx_next_ups_status ON next_ups(status)d -�indexidx_plans_threadplans#CREATE INDEX idx_plans_thread ON plans(thread_id, created_at DESC)Y-!sindexidx_steps_statusplan_steps"CREATE INDEX idx_steps_status ON plan_steps(status)c)!� indexidx_steps_planplan_steps!CREATE INDEX idx_steps_plan ON plan_steps(plan_id, step_order)v5#�!indexidx_breadcrumbs_planbreadcrumbs CREATE INDEX idx_breadcrumbs_plan ON breadcrumbs(plan_id, created_at DESC)�&''� tablesession_statesession_stateCREATE TABLE session_state ( key TEXT PRIMARY KEY, value TEXT NOT NULL, updated_at TEXT DEFAULT (datetime('now')) )9M'indexsqlite_autoindex_session_state_1session_stateP++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)�^##�tableworker_logsworker_logsCREATE TABLE worker_logs ( id INTEGER PRIMARY KEY AUTOINCREMENT, worker_id TEXT NOT NULL REFERENCES workers(id) ON DELETE CASCADE, timestamp TEXT NOT NULL DEFAULT (datetime('now')), stream TEXT NOT NULL CHECK(stream IN ('stdout', 'stderr', 'system')), line TEXT NOT NULL, iteration INTEGER )-Aindexsqlite_autoindex_workers_1workers�m�1tableworkersworkersCREATE TABLE workers ( id TEXT PRIMARY KEY, container_id TEXT NOT NULL, thread_id TEXT NOT NULL REFERENCES threads(id), status TEXT DEFAULT 'running' CHECK(status IN ('running', 'completed', 'failed', 'killed')), last_heartbeat TEXT DEFAULT (datetime('now')), created_at TEXT DEFAULT (datetime('now')), auth_mode TEXT CHECK(auth_mode IN ('env', 'config', 'oauth')), iteration INTEGER DEFAULT 0, max_iterations INTEGER DEFAULT 50 )/Cindexsqlite_autoindex_next_ups_1next_ups�<�Ktablenext_upsnext_upsCREATE TABLE next_ups ( id TEXT PRIMARY KEY, title TEXT NOT NULL, content TEXT NOT NULL, is_template INTEGER NOT NULL DEFAULT 0, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'archived', 'launched')), created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), last_launched_at TEXT, launch_count INTEGER DEFAULT 0 )5I#indexsqlite_autoindex_bug_reports_1bug_reports�\##�tablebug_reportsbug_reportsCREATE TABLE bug_reports ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), title TEXT NOT NULL, repro_steps TEXT NOT NULL, evidence TEXT, status TEXT DEFAULT 'open' CHECK(status IN ('open', 'resolved', 'wontfix')) )5I#indexsqlite_autoindex_corrections_1corrections�##�ktablecorrectionscorrectionsCREATE TABLE corrections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), mistake TEXT NOT NULL, symptoms TEXT, resolution TEXT, tags TEXT )5I#indexsqlite_autoindex_reflections_1reflections�+##�tablereflectionsreflectionsCREATE TABLE reflections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), trigger TEXT CHECK(trigger IN ('manual', 'compact', 'completion', 'stop')), content TEXT NOT NULL )5I#indexsqlite_autoindex_breadcrumbs_1breadcrumbs%%Wd^�彔M�x�"��x� Wd^�彔M}n HV��SQLite format 3@ &.zp�� � - � � �  g` ��)Jx�h�77/Cindexsqlite_autoindex_next_ups_1next_ups�\##�tablebug_reportsbug_reportsCREATE TABLE bug_reports ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), title TEXT NOT NULL, repro_steps TEXT NOT NULL, evidence TEXT, status TEXT DEFAULT 'open' CHECK(status IN ('open', 'resolved', 'wontfix')) )5I#indexsqlite_autoindex_bug_reports_1bug_reports�##�ktablecorrectionscorrectionsCREATE TABLE corrections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), mistake TEXT NOT NULL, symptoms TEXT, resolution TEXT, tags TEXT )5I#indexsqlite_autoindex_corrections_1corrections�+##�tablereflectionsreflectionsCREATE TABLE reflections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), trigger TEXT CHECK(trigger IN ('manual', 'compact', 'completion', 'stop')), content TEXT NOT NULL )5I#indexsqlite_autoindex_reflections_1reflections�w ##�5tablebreadcrumbsbreadcrumbsCREATE TABLE breadcrumbs ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_id TEXT REFERENCES plan_steps(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), agent_type TEXT, summary TEXT NOT NULL, files_touched TEXT, issues TEXT, next_context TEXT )5I#indexsqlite_autoindex_breadcrumbs_1breadcrumbs�v !!�7tableplan_stepsplan_steps CREATE TABLE plan_steps ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_order INTEGER NOT NULL, description TEXT NOT NULL, status TEXT DEFAULT 'pending' CHECK(status IN ('pending', 'in_progress', 'completed', 'failed', 'skipped')), created_at TEXT DEFAULT (datetime('now')) )3 G!indexsqlite_autoindex_plan_steps_1plan_steps �V � tableplansplans CREATE TABLE plans ( id TEXT PRIMARY KEY, created_at TEXT DEFAULT (datetime('now')), status TEXT DEFAULT 'accepted' CHECK(status IN ('accepted', 'in_progress', 'completed', 'abandoned')), description TEXT, plan_markdown TEXT NOT NULL, session_id TEXT, thread_id TEXT REFERENCES threads(id) )) =indexsqlite_autoindex_plans_1plans �++�Ctablethread_sessionsthread_sessionsCREATE TABLE thread_sessions ( thread_id TEXT NOT NULL REFERENCES threads(id) ON DELETE CASCADE, session_id TEXT NOT NULL, created_at TEXT DEFAULT (datetime('now')), PRIMARY KEY (thread_id, session_id) )=Q+indexsqlite_autoindex_thread_sessions_1thread_sessions Q-iindexidx_threads_namethreadsCREATE INDEX idx_threads_name ON threads(name)W1qindexidx_threads_statusthreadsCREATE INDEX idx_threads_status ON threads(status)c3�indexidx_threads_updatedthreadsCREATE INDEX idx_threads_updated ON threads(updated_at DESC)�,�/tablethreadsthreadsCREATE TABLE threads ( id TEXT PRIMARY KEY, name TEXT NOT NULL UNIQUE, created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), current_plan_id TEXT REFERENCES plans(id), git_branches TEXT, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'paused', 'completed', 'archived')) )-Aindexsqlite_autoindex_threads_2threads-Aindexsqlite_autoindex_threads_1threads Wd^�彔M�����J� ���d O  � � � ��s��}\��6�pW#1qindexidx_workers_statusworkers&CREATE INDEX idx_workers_status ON workers(status)g"5� indexidx_next_ups_updatednext_ups%CREATE INDEX idx_next_ups_updated ON next_ups(updated_at DESC)[!3uindexidx_next_ups_statusnext_ups$CREATE INDEX idx_next_ups_status ON next_ups(status)d -�indexidx_plans_threadplans#CREATE INDEX idx_plans_thread ON plans(thread_id, created_at DESC)Y-!sindexidx_steps_statusplan_steps"CREATE INDEX idx_steps_status ON plan_steps(status)c)!� indexidx_steps_planplan_steps!CREATE INDEX idx_steps_plan ON plan_steps(plan_id, step_order)v5#�!indexidx_breadcrumbs_planbreadcrumbs CREATE INDEX idx_breadcrumbs_plan ON breadcrumbs(plan_id, created_at DESC)�&''� tablesession_statesession_stateCREATE TABLE session_state ( key TEXT PRIMARY KEY, value TEXT NOT NULL, updated_at TEXT DEFAULT (datetime('now')) )9M'indexsqlite_autoindex_session_state_1session_stateP++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)�^##�tableworker_logsworker_logsCREATE TABLE worker_logs ( id INTEGER PRIMARY KEY AUTOINCREMENT, worker_id TEXT NOT NULL REFERENCES workers(id) ON DELETE CASCADE, timestamp TEXT NOT NULL DEFAULT (datetime('now')), stream TEXT NOT NULL CHECK(stream IN ('stdout', 'stderr', 'system')), line TEXT NOT NULL, iteration INTEGER )-Aindexsqlite_autoindex_workers_1workers�m�1tableworkersworkersCREATE TABLE workers ( id TEXT PRIMARY KEY, container_id TEXT NOT NULL, thread_id TEXT NOT NULL REFERENCES threads(id), status TEXT DEFAULT 'running' CHECK(status IN ('running', 'completed', 'failed', 'killed')), last_heartbeat TEXT DEFAULT (datetime('now')), created_at TEXT DEFAULT (datetime('now')), auth_mode TEXT CHECK(auth_mode IN ('env', 'config', 'oauth')), iteration INTEGER DEFAULT 0, max_iterations INTEGER DEFAULT 50 )/Cindexsqlite_autoindex_next_ups_1next_ups�<�Ktablenext_upsnext_upsCREATE TABLE next_ups ( id TEXT PRIMARY KEY, title TEXT NOT NULL, content TEXT NOT NULL, is_template INTEGER NOT NULL DEFAULT 0, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'archived', 'launched')), created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), last_launched_at TEXT, launch_count INTEGER DEFAULT 0 )5I#indexsqlite_autoindex_bug_reports_1bug_reports�\##�tablebug_reportsbug_reportsCREATE TABLE bug_reports ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), title TEXT NOT NULL, repro_steps TEXT NOT NULL, evidence TEXT, status TEXT DEFAULT 'open' CHECK(status IN ('open', 'resolved', 'wontfix')) )5I#indexsqlite_autoindex_corrections_1corrections�##�ktablecorrectionscorrectionsCREATE TABLE corrections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), mistake TEXT NOT NULL, symptoms TEXT, resolution TEXT, tags TEXT )5I#indexsqlite_autoindex_reflections_1reflections�+##�tablereflectionsreflectionsCREATE TABLE reflections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), trigger TEXT CHECK(trigger IN ('manual', 'compact', 'completion', 'stop')), content TEXT NOT NULL )5I#indexsqlite_autoindex_breadcrumbs_1breadcrumbs&&Wd^�彔M���d O  � � � ��s��}\��6�p�>{%9#�'indexidx_worker_logs_workerworker_logs(CREATE INDEX idx_worker_logs_worker ON worker_logs(worker_id, timestamp DESC)Z$1windexidx_workers_threadworkers'CREATE INDEX idx_workers_thread ON workers(thread_id)W#1qindexidx_workers_statusworkers&CREATE INDEX idx_workers_status ON workers(status)g"5� indexidx_next_ups_updatednext_ups%CREATE INDEX idx_next_ups_updated ON next_ups(updated_at DESC)[!3uindexidx_next_ups_statusnext_ups$CREATE INDEX idx_next_ups_status ON next_ups(status)d -�indexidx_plans_threadplans#CREATE INDEX idx_plans_thread ON plans(thread_id, created_at DESC)Y-!sindexidx_steps_statusplan_steps"CREATE INDEX idx_steps_status ON plan_steps(status)c)!� indexidx_steps_planplan_steps!CREATE INDEX idx_steps_plan ON plan_steps(plan_id, step_order)v5#�!indexidx_breadcrumbs_planbreadcrumbs CREATE INDEX idx_breadcrumbs_plan ON breadcrumbs(plan_id, created_at DESC)�&''� tablesession_statesession_stateCREATE TABLE session_state ( key TEXT PRIMARY KEY, value TEXT NOT NULL, updated_at TEXT DEFAULT (datetime('now')) )9M'indexsqlite_autoindex_session_state_1session_stateP++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)�^##�tableworker_logsworker_logsCREATE TABLE worker_logs ( id INTEGER PRIMARY KEY AUTOINCREMENT, worker_id TEXT NOT NULL REFERENCES workers(id) ON DELETE CASCADE, timestamp TEXT NOT NULL DEFAULT (datetime('now')), stream TEXT NOT NULL CHECK(stream IN ('stdout', 'stderr', 'system')), line TEXT NOT NULL, iteration INTEGER )-Aindexsqlite_autoindex_workers_1workers�m�1tableworkersworkersCREATE TABLE workers ( id TEXT PRIMARY KEY, container_id TEXT NOT NULL, thread_id TEXT NOT NULL REFERENCES threads(id), status TEXT DEFAULT 'running' CHECK(status IN ('running', 'completed', 'failed', 'killed')), last_heartbeat TEXT DEFAULT (datetime('now')), created_at TEXT DEFAULT (datetime('now')), auth_mode TEXT CHECK(auth_mode IN ('env', 'config', 'oauth')), iteration INTEGER DEFAULT 0, max_iterations INTEGER DEFAULT 50 )/Cindexsqlite_autoindex_next_ups_1next_ups�<�Ktablenext_upsnext_upsCREATE TABLE next_ups ( id TEXT PRIMARY KEY, title TEXT NOT NULL, content TEXT NOT NULL, is_template INTEGER NOT NULL DEFAULT 0, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'archived', 'launched')), created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), last_launched_at TEXT, launch_count INTEGER DEFAULT 0 )5I#indexsqlite_autoindex_bug_reports_1bug_reports�\##�tablebug_reportsbug_reportsCREATE TABLE bug_reports ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), title TEXT NOT NULL, repro_steps TEXT NOT NULL, evidence TEXT, status TEXT DEFAULT 'open' CHECK(status IN ('open', 'resolved', 'wontfix')) )5I#indexsqlite_autoindex_corrections_1corrections�##�ktablecorrectionscorrectionsCREATE TABLE corrections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), mistake TEXT NOT NULL, symptoms TEXT, resolution TEXT, tags TEXT )5I#indexsqlite_autoindex_reflections_1reflections�+##�tablereflectionsreflectionsCREATE TABLE reflections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), trigger TEXT CHECK(trigger IN ('manual', 'compact', 'completion', 'stop')), content TEXT NOT NULL )5I#indexsqlite_autoindex_breadcrumbs_1breadcrumbs((Wd^�彔M��(�Z*� Wd^�彔M����s�1PSQLite format 3@ ).zp�� � - � � �  g` ��)Jx�h�77/Cindexsqlite_autoindex_next_ups_1next_ups�\##�tablebug_reportsbug_reportsCREATE TABLE bug_reports ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), title TEXT NOT NULL, repro_steps TEXT NOT NULL, evidence TEXT, status TEXT DEFAULT 'open' CHECK(status IN ('open', 'resolved', 'wontfix')) )5I#indexsqlite_autoindex_bug_reports_1bug_reports�##�ktablecorrectionscorrectionsCREATE TABLE corrections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), mistake TEXT NOT NULL, symptoms TEXT, resolution TEXT, tags TEXT )5I#indexsqlite_autoindex_corrections_1corrections�+##�tablereflectionsreflectionsCREATE TABLE reflections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), trigger TEXT CHECK(trigger IN ('manual', 'compact', 'completion', 'stop')), content TEXT NOT NULL )5I#indexsqlite_autoindex_reflections_1reflections�w ##�5tablebreadcrumbsbreadcrumbsCREATE TABLE breadcrumbs ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_id TEXT REFERENCES plan_steps(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), agent_type TEXT, summary TEXT NOT NULL, files_touched TEXT, issues TEXT, next_context TEXT )5I#indexsqlite_autoindex_breadcrumbs_1breadcrumbs�v !!�7tableplan_stepsplan_steps CREATE TABLE plan_steps ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_order INTEGER NOT NULL, description TEXT NOT NULL, status TEXT DEFAULT 'pending' CHECK(status IN ('pending', 'in_progress', 'completed', 'failed', 'skipped')), created_at TEXT DEFAULT (datetime('now')) )3 G!indexsqlite_autoindex_plan_steps_1plan_steps �V � tableplansplans CREATE TABLE plans ( id TEXT PRIMARY KEY, created_at TEXT DEFAULT (datetime('now')), status TEXT DEFAULT 'accepted' CHECK(status IN ('accepted', 'in_progress', 'completed', 'abandoned')), description TEXT, plan_markdown TEXT NOT NULL, session_id TEXT, thread_id TEXT REFERENCES threads(id) )) =indexsqlite_autoindex_plans_1plans �++�Ctablethread_sessionsthread_sessionsCREATE TABLE thread_sessions ( thread_id TEXT NOT NULL REFERENCES threads(id) ON DELETE CASCADE, session_id TEXT NOT NULL, created_at TEXT DEFAULT (datetime('now')), PRIMARY KEY (thread_id, session_id) )=Q+indexsqlite_autoindex_thread_sessions_1thread_sessions Q-iindexidx_threads_namethreadsCREATE INDEX idx_threads_name ON threads(name)W1qindexidx_threads_statusthreadsCREATE INDEX idx_threads_status ON threads(status)c3�indexidx_threads_updatedthreadsCREATE INDEX idx_threads_updated ON threads(updated_at DESC)�,�/tablethreadsthreadsCREATE TABLE threads ( id TEXT PRIMARY KEY, name TEXT NOT NULL UNIQUE, created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), current_plan_id TEXT REFERENCES plans(id), git_branches TEXT, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'paused', 'completed', 'archived')) )-Aindexsqlite_autoindex_threads_2threads-Aindexsqlite_autoindex_threads_1threads Wd^�彔M �&m��� ����d O  � � � ��s��}\��6�p�>�v&?#�indexidx_worker_logs_timestampworker_logs)CREATE INDEX idx_worker_logs_timestamp ON worker_logs(timestamp DESC){%9#�'indexidx_worker_logs_workerworker_logs(CREATE INDEX idx_worker_logs_worker ON worker_logs(worker_id, timestamp DESC)Z$1windexidx_workers_threadworkers'CREATE INDEX idx_workers_thread ON workers(thread_id)W#1qindexidx_workers_statusworkers&CREATE INDEX idx_workers_status ON workers(status)g"5� indexidx_next_ups_updatednext_ups%CREATE INDEX idx_next_ups_updated ON next_ups(updated_at DESC)[!3uindexidx_next_ups_statusnext_ups$CREATE INDEX idx_next_ups_status ON next_ups(status)d -�indexidx_plans_threadplans#CREATE INDEX idx_plans_thread ON plans(thread_id, created_at DESC)Y-!sindexidx_steps_statusplan_steps"CREATE INDEX idx_steps_status ON plan_steps(status)c)!� indexidx_steps_planplan_steps!CREATE INDEX idx_steps_plan ON plan_steps(plan_id, step_order)v5#�!indexidx_breadcrumbs_planbreadcrumbs CREATE INDEX idx_breadcrumbs_plan ON breadcrumbs(plan_id, created_at DESC)�&''� tablesession_statesession_stateCREATE TABLE session_state ( key TEXT PRIMARY KEY, value TEXT NOT NULL, updated_at TEXT DEFAULT (datetime('now')) )9M'indexsqlite_autoindex_session_state_1session_stateP++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)�^##�tableworker_logsworker_logsCREATE TABLE worker_logs ( id INTEGER PRIMARY KEY AUTOINCREMENT, worker_id TEXT NOT NULL REFERENCES workers(id) ON DELETE CASCADE, timestamp TEXT NOT NULL DEFAULT (datetime('now')), stream TEXT NOT NULL CHECK(stream IN ('stdout', 'stderr', 'system')), line TEXT NOT NULL, iteration INTEGER )-Aindexsqlite_autoindex_workers_1workers�m�1tableworkersworkersCREATE TABLE workers ( id TEXT PRIMARY KEY, container_id TEXT NOT NULL, thread_id TEXT NOT NULL REFERENCES threads(id), status TEXT DEFAULT 'running' CHECK(status IN ('running', 'completed', 'failed', 'killed')), last_heartbeat TEXT DEFAULT (datetime('now')), created_at TEXT DEFAULT (datetime('now')), auth_mode TEXT CHECK(auth_mode IN ('env', 'config', 'oauth')), iteration INTEGER DEFAULT 0, max_iterations INTEGER DEFAULT 50 )/Cindexsqlite_autoindex_next_ups_1next_ups�<�Ktablenext_upsnext_upsCREATE TABLE next_ups ( id TEXT PRIMARY KEY, title TEXT NOT NULL, content TEXT NOT NULL, is_template INTEGER NOT NULL DEFAULT 0, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'archived', 'launched')), created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), last_launched_at TEXT, launch_count INTEGER DEFAULT 0 )5I#indexsqlite_autoindex_bug_reports_1bug_reports�\##�tablebug_reportsbug_reportsCREATE TABLE bug_reports ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), title TEXT NOT NULL, repro_steps TEXT NOT NULL, evidence TEXT, status TEXT DEFAULT 'open' CHECK(status IN ('open', 'resolved', 'wontfix')) )5I#indexsqlite_autoindex_corrections_1corrections�##�ktablecorrectionscorrectionsCREATE TABLE corrections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), mistake TEXT NOT NULL, symptoms TEXT, resolution TEXT, tags TEXT )5I#indexsqlite_autoindex_reflections_1reflections�+##�tablereflectionsreflectionsCREATE TABLE reflections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), trigger TEXT CHECK(trigger IN ('manual', 'compact', 'completion', 'stop')), content TEXT NOT NULL )5I#indexsqlite_autoindex_breadcrumbs_1breadcrumbs))Wd^�彔M�mJ�g�� Wd^�彔M.��-ډKSQLite format 3@ ).zp�� � - � � �  g` ��)Jx�h�77/Cindexsqlite_autoindex_next_ups_1next_ups�\##�tablebug_reportsbug_reportsCREATE TABLE bug_reports ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), title TEXT NOT NULL, repro_steps TEXT NOT NULL, evidence TEXT, status TEXT DEFAULT 'open' CHECK(status IN ('open', 'resolved', 'wontfix')) )5I#indexsqlite_autoindex_bug_reports_1bug_reports�##�ktablecorrectionscorrectionsCREATE TABLE corrections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), mistake TEXT NOT NULL, symptoms TEXT, resolution TEXT, tags TEXT )5I#indexsqlite_autoindex_corrections_1corrections�+##�tablereflectionsreflectionsCREATE TABLE reflections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), trigger TEXT CHECK(trigger IN ('manual', 'compact', 'completion', 'stop')), content TEXT NOT NULL )5I#indexsqlite_autoindex_reflections_1reflections�w ##�5tablebreadcrumbsbreadcrumbsCREATE TABLE breadcrumbs ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_id TEXT REFERENCES plan_steps(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), agent_type TEXT, summary TEXT NOT NULL, files_touched TEXT, issues TEXT, next_context TEXT )5I#indexsqlite_autoindex_breadcrumbs_1breadcrumbs�v !!�7tableplan_stepsplan_steps CREATE TABLE plan_steps ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_order INTEGER NOT NULL, description TEXT NOT NULL, status TEXT DEFAULT 'pending' CHECK(status IN ('pending', 'in_progress', 'completed', 'failed', 'skipped')), created_at TEXT DEFAULT (datetime('now')) )3 G!indexsqlite_autoindex_plan_steps_1plan_steps �V � tableplansplans CREATE TABLE plans ( id TEXT PRIMARY KEY, created_at TEXT DEFAULT (datetime('now')), status TEXT DEFAULT 'accepted' CHECK(status IN ('accepted', 'in_progress', 'completed', 'abandoned')), description TEXT, plan_markdown TEXT NOT NULL, session_id TEXT, thread_id TEXT REFERENCES threads(id) )) =indexsqlite_autoindex_plans_1plans �++�Ctablethread_sessionsthread_sessionsCREATE TABLE thread_sessions ( thread_id TEXT NOT NULL REFERENCES threads(id) ON DELETE CASCADE, session_id TEXT NOT NULL, created_at TEXT DEFAULT (datetime('now')), PRIMARY KEY (thread_id, session_id) )=Q+indexsqlite_autoindex_thread_sessions_1thread_sessions Q-iindexidx_threads_namethreadsCREATE INDEX idx_threads_name ON threads(name)W1qindexidx_threads_statusthreadsCREATE INDEX idx_threads_status ON threads(status)c3�indexidx_threads_updatedthreadsCREATE INDEX idx_threads_updated ON threads(updated_at DESC)�,�/tablethreadsthreadsCREATE TABLE threads ( id TEXT PRIMARY KEY, name TEXT NOT NULL UNIQUE, created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), current_plan_id TEXT REFERENCES plans(id), git_branches TEXT, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'paused', 'completed', 'archived')) )-Aindexsqlite_autoindex_threads_2threads-Aindexsqlite_autoindex_threads_1threadsWd^�彔Mk�~���� �� ��� � - � � �  g` ��)�J5���x7II-Aindexsqlite_autoindex_workers_1workers�<�Ktablenext_upsnext_upsCREATE TABLE next_ups ( id TEXT PRIMARY KEY, title TEXT NOT NULL, content TEXT NOT NULL, is_template INTEGER NOT NULL DEFAULT 0, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'archived', 'launched')), created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), last_launched_at TEXT, launch_count INTEGER DEFAULT 0 ))xCindexsqlite_autoindex_next_ups_1next_ups�\##�tablebug_reportsbug_reportsCREATE TABLE bug_�\##�tablebug_reportsbug_reportsCREATE TABLE bug_reports ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), title TEXT NOT NULL, repro_steps TEXT NOT NULL, evidence TEXT, status TEXT DEFAULT 'open' CHECK(status IN ('open', 'resolved', 'wontfix')) )5I#indexsqlite_autoindex_corrections_1corrections�##�ktablecorrectionscorrectionsCREATE TABLE corrections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), mistake TEXT NOT NULL, symptoms TEXT, resolution TEXT, tags TEXT )5I#indexsqlite_autoindex_reflections_1reflections�+##�tablereflectionsreflectionsCREATE TABLE reflections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), trigger TEXT CHECK(trigger IN ('manual', 'compact', 'completion', 'stop')), content TEXT NOT NULL )�w ##�5tablebreadcrumbsbreadcrumbsCREATE TABLE breadcrumbs ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_id TEXT REFERENCES plan_steps(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), agent_type TEXT, summary TEXT NOT NULL, files_touched TEXT, issues TEXT, next_context TEXT )5I#indexsqlite_autoindex_breadcrumbs_1breadcrumbs�v !!�7tableplan_stepsplan_steps CREATE TABLE plan_steps ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_order INTEGER NOT NULL, description TEXT NOT NULL, status TEXT DEFAULT 'pending' CHECK(status IN ('pending', 'in_progress', 'completed', 'failed', 'skipped')), created_at TEXT DEFAULT (datetime('now')) )3 G!indexsqlite_autoindex_plan_steps_1plan_steps �V � tableplansplans CREATE TABLE plans ( id TEXT PRIMARY KEY, created_at TEXT DEFAULT (datetime('now')), status TEXT DEFAULT 'accepted' CHECK(status IN ('accepted', 'in_progress', 'completed', 'abandoned')), description TEXT, plan_markdown TEXT NOT NULL, session_id TEXT, thread_id TEXT REFERENCES threads(id) )) =indexsqlite_autoindex_plans_1plans �++�Ctablethread_sessionsthread_sessionsCREATE TABLE thread_sessions ( thread_id TEXT NOT NULL REFERENCES threads(id) ON DELETE CASCADE, session_id TEXT NOT NULL, created_at TEXT DEFAULT (datetime('now')), PRIMARY KEY (thread_id, session_id) )=Q+indexsqlite_autoindex_thread_sessions_1thread_sessions Q-iindexidx_threads_namethreadsCREATE INDEX idx_threads_name ON threads(name)W1qindexidx_threads_statusthreadsCREATE INDEX idx_threads_status ON threads(status)c3�indexidx_threads_updatedthreadsCREATE INDEX idx_threads_updated ON threads(updated_at DESC)�,�/tablethreadsthreadsCREATE TABLE threads ( id TEXT PRIMARY KEY, name TEXT NOT NULL UNIQUE, created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), current_plan_id TEXT REFERENCES plans(id), git_branches TEXT, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'paused', 'completed', 'archived')) )-Aindexsqlite_autoindex_threads_2threads-Aindexsqlite_autoindex_threads_1threads)Wd^�彔Mfyc^��] �� � � ��s��}\��6�p�>�^�v&?#�indexidx_worker_logs_timestampworker_logs)CREATE INDEX idx_worker_logs_timestamp ON worker_logs(timestamp DESC){%9#�'indexidx_worker_logs_workerworker_logs(CREATE INDEX idx_worker_logs_worker ON worker_logs(worker_id, timestamp DESC)Z$1windexidx_workers_threadworkers'CREATE INDEX idx_workers_thread ON workers(thread_id)W#1qindexidx_workers_statusworkers&CREATE INDEX idx_workers_status ON workers(status)g"5� indexidx_next_ups_updatednext_ups%CREATE INDEX idx_next_ups_updated ON next_ups(updated_at DESC)[!3uindexidx_next_ups_statusnext_ups$CREATE INDEX idx_next_ups_status ON next_ups(status)d -�indexidx_plans_threadplans#CREATE INDEX idx_plans_thread ON plans(thread_id, created_at DESC)Y-!sindexidx_steps_statusplan_steps"CREATE INDEX idx_steps_status ON plan_steps(status)c)!� indexidx_steps_planplan_steps!CREATE INDEX idx_steps_plan ON plan_steps(plan_id, step_order)v5#�!indexidx_breadcrumbs_planbreadcrumbs CREATE INDEX idx_breadcrumbs_plan ON breadcrumbs(plan_id, created_at DESC)�&''� tablesession_statesession_stateCREATE TABLE session_state ( key TEXT PRIMARY KEY, value TEXT NOT NULL, updated_at TEXT DEFAULT (datetime('now')) )9M'indexsqlite_autoindex_session_state_1session_state �P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)�^##�tableworker_logsworker_logsCREATE TABLE worker_logs ( id INTEGER PRIMARY KEY AUTOINCREMENT, worker_id TEXT NOT NULL REFERENCES workers(id) ON DELETE CASCADE, timestamp TEXT NOT NULL DEFAULT (datetime('now')), stream TEXT NOT NULL CHECK(stream IN ('stdout', 'stderr', 'system')), line TEXT NOT NULL, iteration INTEGER )-Aindexsqlite_autoindex_workers_1workers�m�1tableworkersworkersCREATE TABLE workers ( id TEXT PRIMARY KEY, container_id TEXT NOT NULL, thread_id TEXT NOT NULL REFERENCES threads(id), status TEXT DEFAULT 'running' CHECK(status IN ('running', 'completed', 'failed', 'killed')), last_heartbeat TEXT DEFAULT (datetime('now')), created_at TEXT DEFAULT (datetime('now')), auth_mode TEXT CHECK(auth_mode IN ('env', 'config', 'oauth')), iteration INTEGER DEFAULT 0, max_iterations INTEGER DEFAULT 50 )/Cindexsqlite_autoindex_next_ups_1next_ups�<�Ktablenext_upsnext_upsCREATE TABLE next_ups ( id TEXT PRIMARY KEY, title TEXT NOT NULL, content TEXT NOT NULL, is_template INTEGER NOT NULL DEFAULT 0, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'archived', 'launched')), created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), last_launched_at TEXT, launch_count INTEGER DEFAULT 0 )5I#indexsqlite_autoindex_bug_reports_1bug_reports�##�tablebug_reportsbug_reportsCREATE TABLE bug_reports ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), title TEXT NOT NULL, repro_steps TEXT NOT NULL, evidence TEXT, status TEXT DEFAULT 'open' CHECK(status IN ('open', 'resolved', 'wontfix')) )5I#indexsqlite_autoindex_corrections_1corrections�##�ktablecorrectionscorrectionsCREATE TABLE corrections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), mistake TEXT NOT NULL, symptoms TEXT, resolution TEXT, tags TEXT )5I#indexsqlite_autoindex_reflections_1reflections�+##�tablereflectionsreflectionsCREATE TABLE reflections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), �'##� viewactive_planactive_planCREATE VIEW active_plan AS SELECT * FROM plans WHERE status IN ('accepted', 'in_progress') ORDER BY created_at DESC LIMIT 1Wd^�彔M�y4uaNz(SQLite format 3@ ).zp�� � - � � �  g` ��)Jx�h�77/Cindexsqlite_autoindex_next_ups_1next_ups�\##�tablebug_reportsbug_reportsCREATE TABLE bug_reports ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), title TEXT NOT NULL, repro_steps TEXT NOT NULL, evidence TEXT, status TEXT DEFAULT 'open' CHECK(status IN ('open', 'resolved', 'wontfix')) )5I#indexsqlite_autoindex_bug_reports_1bug_reports�##�ktablecorrectionscorrectionsCREATE TABLE corrections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), mistake TEXT NOT NULL, symptoms TEXT, resolution TEXT, tags TEXT )5I#indexsqlite_autoindex_corrections_1corrections�+##�tablereflectionsreflectionsCREATE TABLE reflections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), trigger TEXT CHECK(trigger IN ('manual', 'compact', 'completion', 'stop')), content TEXT NOT NULL )5I#indexsqlite_autoindex_reflections_1reflections�w ##�5tablebreadcrumbsbreadcrumbsCREATE TABLE breadcrumbs ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_id TEXT REFERENCES plan_steps(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), agent_type TEXT, summary TEXT NOT NULL, files_touched TEXT, issues TEXT, next_context TEXT )5I#indexsqlite_autoindex_breadcrumbs_1breadcrumbs�v !!�7tableplan_stepsplan_steps CREATE TABLE plan_steps ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_order INTEGER NOT NULL, description TEXT NOT NULL, status TEXT DEFAULT 'pending' CHECK(status IN ('pending', 'in_progress', 'completed', 'failed', 'skipped')), created_at TEXT DEFAULT (datetime('now')) )3 G!indexsqlite_autoindex_plan_steps_1plan_steps �V � tableplansplans CREATE TABLE plans ( id TEXT PRIMARY KEY, created_at TEXT DEFAULT (datetime('now')), status TEXT DEFAULT 'accepted' CHECK(status IN ('accepted', 'in_progress', 'completed', 'abandoned')), description TEXT, plan_markdown TEXT NOT NULL, session_id TEXT, thread_id TEXT REFERENCES threads(id) )) =indexsqlite_autoindex_plans_1plans �++�Ctablethread_sessionsthread_sessionsCREATE TABLE thread_sessions ( thread_id TEXT NOT NULL REFERENCES threads(id) ON DELETE CASCADE, session_id TEXT NOT NULL, created_at TEXT DEFAULT (datetime('now')), PRIMARY KEY (thread_id, session_id) )=Q+indexsqlite_autoindex_thread_sessions_1thread_sessions Q-iindexidx_threads_namethreadsCREATE INDEX idx_threads_name ON threads(name)W1qindexidx_threads_statusthreadsCREATE INDEX idx_threads_status ON threads(status)c3�indexidx_threads_updatedthreadsCREATE INDEX idx_threads_updated ON threads(updated_at DESC)�,�/tablethreadsthreadsCREATE TABLE threads ( id TEXT PRIMARY KEY, name TEXT NOT NULL UNIQUE, created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), current_plan_id TEXT REFERENCES plans(id), git_branches TEXT, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'paused', 'completed', 'archived')) )-Aindexsqlite_autoindex_threads_2threads-Aindexsqlite_autoindex_threads_1threads)Wd^�彔M� ��LR�� �� � � ��s��}\��6�p�>�^��v&?#�indexidx_worker_logs_timestampworker_logs)CREATE INDEX idx_worker_logs_timestamp ON worker_logs(timestamp DESC){%9#�'indexidx_worker_logs_workerworker_logs(CREATE INDEX idx_worker_logs_worker ON worker_logs(worker_id, timestamp DESC)Z$1windexidx_workers_threadworkers'CREATE INDEX idx_workers_thread ON workers(thread_id)W#1qindexidx_workers_statusworkers&CREATE INDEX idx_workers_status ON workers(status)g"5� indexidx_next_ups_updatednext_ups%CREATE INDEX idx_next_ups_updated ON next_ups(updated_at DESC)[!3uindexidx_next_ups_statusnext_ups$CREATE INDEX idx_next_ups_status ON next_ups(status)d -�indexidx_plans_threadplans#CREATE INDEX idx_plans_thread ON plans(thread_id, created_at DESC)Y-!sindexidx_steps_statusplan_steps"CREATE INDEX idx_steps_status ON plan_steps(status)c)!� indexidx_steps_planplan_steps!CREATE INDEX idx_steps_plan ON plan_steps(plan_id, step_order)v5#�!indexidx_breadcrumbs_planbreadcrumbs CREATE INDEX idx_breadcrumbs_plan ON breadcrumbs(plan_id, created_at DESC)�&''� tablesession_statesession_stateCREATE TABLE session_state ( key TEXT PRIMARY KEY, value TEXT NOT NULL, updated_at TEXT DEFAULT (datetime('now')) )9M'indexsqlite_autoindex_session_state_1session_state �P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)�^##�tableworker_logsworker_logsCREATE TABLE worker_logs ( id INTEGER PRIMARY KEY AUTOINCREMENT, worker_id TEXT NOT NULL REFERENCES workers(id) ON DELETE CASCADE, timestamp TEXT NOT NULL DEFAULT (datetime('now')), stream TEXT NOT NULL CHECK(stream IN ('stdout', 'stderr', 'system')), line TEXT NOT NULL, iteration INTEGER )-Aindexsqlite_autoindex_workers_1workers�m�1tableworkersworkersCREATE TABLE workers ( id TEXT PRIMARY KEY, container_id TEXT NOT NULL, thread_id TEXT NOT NULL REFERENCES threads(id), status TEXT DEFAULT 'running' CHECK(status IN ('running', 'completed', 'failed', 'killed')), last_heartbeat TEXT DEFAULT (datetime('now')), created_at TEXT DEFAULT (datetime('now')), auth_mode TEXT CHECK(auth_mode IN ('env', 'config', 'oauth')), iteration INTEGER DEFAULT 0, max_iterations INTEGER DEFAULT 50 )/Cindexsqlite_autoindex_next_ups_1next_ups�<�Ktablenext_upsnext_upsCREATE TABLE next_ups ( id TEXT PRIMARY KEY, title TEXT NOT NULL, content TEXT NOT NULL, is_template INTEGER NOT NULL DEFAULT 0, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'archived', 'launched')), created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), last_launched_at TEXT, launch_count INTEGER DEFAULT 0 )5I#indexsqlite_autoindex_bug_reports_1bug_reports�##�tablebug_reportsbug_reportsCREATE TABLE bug_reports ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), title TEXT NOT NULL, repro_steps TEXT NOT NULL, evidence TEXT, status TEXT DEFAULT 'open' CHECK(status IN ('open', 'resolved', 'wontfix')) )5I#indexsqlite_autoindex_corrections_1corrections�##�ktablecorrectionscorrectionsCREATE TABLE corrections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), mistake TEXT NOT NULL, symptoms TEXT, resolution TEXT, tags TEXT )5I#indexsqlite_autoindex_reflec�S(''�iviewpending_stepspending_stepsCREATE VIEW pending_steps AS SELECT s.*, p.description as plan_description FROM plan_steps s JOIN plans p ON s.plan_id = p.id WHERE s.status = 'pending' ORDER BY s.step_order�'##� viewactive_planactive_planCREATE VIEW active_plan AS SELECT * FROM plans WHERE status IN ('accepted', 'in_progress') ORDER BY created_at DESC LIMIT 1Wd^�彔Mh���"pr�SQLite format 3@ ).zp�� � - � � �  g` ��)Jx�h�77/Cindexsqlite_autoindex_next_ups_1next_ups�\##�tablebug_reportsbug_reportsCREATE TABLE bug_reports ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), title TEXT NOT NULL, repro_steps TEXT NOT NULL, evidence TEXT, status TEXT DEFAULT 'open' CHECK(status IN ('open', 'resolved', 'wontfix')) )5I#indexsqlite_autoindex_bug_reports_1bug_reports�##�ktablecorrectionscorrectionsCREATE TABLE corrections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), mistake TEXT NOT NULL, symptoms TEXT, resolution TEXT, tags TEXT )5I#indexsqlite_autoindex_corrections_1corrections�+##�tablereflectionsreflectionsCREATE TABLE reflections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), trigger TEXT CHECK(trigger IN ('manual', 'compact', 'completion', 'stop')), content TEXT NOT NULL )5I#indexsqlite_autoindex_reflections_1reflections�w ##�5tablebreadcrumbsbreadcrumbsCREATE TABLE breadcrumbs ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_id TEXT REFERENCES plan_steps(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), agent_type TEXT, summary TEXT NOT NULL, files_touched TEXT, issues TEXT, next_context TEXT )5I#indexsqlite_autoindex_breadcrumbs_1breadcrumbs�v !!�7tableplan_stepsplan_steps CREATE TABLE plan_steps ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_order INTEGER NOT NULL, description TEXT NOT NULL, status TEXT DEFAULT 'pending' CHECK(status IN ('pending', 'in_progress', 'completed', 'failed', 'skipped')), created_at TEXT DEFAULT (datetime('now')) )3 G!indexsqlite_autoindex_plan_steps_1plan_steps �V � tableplansplans CREATE TABLE plans ( id TEXT PRIMARY KEY, created_at TEXT DEFAULT (datetime('now')), status TEXT DEFAULT 'accepted' CHECK(status IN ('accepted', 'in_progress', 'completed', 'abandoned')), description TEXT, plan_markdown TEXT NOT NULL, session_id TEXT, thread_id TEXT REFERENCES threads(id) )) =indexsqlite_autoindex_plans_1plans �++�Ctablethread_sessionsthread_sessionsCREATE TABLE thread_sessions ( thread_id TEXT NOT NULL REFERENCES threads(id) ON DELETE CASCADE, session_id TEXT NOT NULL, created_at TEXT DEFAULT (datetime('now')), PRIMARY KEY (thread_id, session_id) )=Q+indexsqlite_autoindex_thread_sessions_1thread_sessions Q-iindexidx_threads_namethreadsCREATE INDEX idx_threads_name ON threads(name)W1qindexidx_threads_statusthreadsCREATE INDEX idx_threads_status ON threads(status)c3�indexidx_threads_updatedthreadsCREATE INDEX idx_threads_updated ON threads(updated_at DESC)�,�/tablethreadsthreadsCREATE TABLE threads ( id TEXT PRIMARY KEY, name TEXT NOT NULL UNIQUE, created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), current_plan_id TEXT REFERENCES plans(id), git_branches TEXT, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'paused', 'completed', 'archived')) )-Aindexsqlite_autoindex_threads_2threads-Aindexsqlite_autoindex_threads_1threads)Wd^�彔M�ے�i��� �� � � ��s��}\��6�p�>�^� _�v&?#�indexidx_worker_logs_timestampworker_logs)CREATE INDEX idx_worker_logs_timestamp ON worker_logs(timestamp DESC){%9#�'indexidx_worker_logs_workerworker_logs(CREATE INDEX idx_worker_logs_worker ON worker_logs(worker_id, timestamp DESC)Z$1windexidx_workers_threadworkers'CREATE INDEX idx_workers_thread ON workers(thread_id)W#1qindexidx_workers_statusworkers&CREATE INDEX idx_workers_status ON workers(status)g"5� indexidx_next_ups_updatednext_ups%CREATE INDEX idx_next_ups_updated ON next_ups(updated_at DESC)[!3uindexidx_next_ups_statusnext_ups$CREATE INDEX idx_next_ups_status ON next_ups(status)d -�indexidx_plans_threadplans#CREATE INDEX idx_plans_thread ON plans(thread_id, created_at DESC)Y-!sindexidx_steps_statusplan_steps"CREATE INDEX idx_steps_status ON plan_steps(status)c)!� indexidx_steps_planplan_steps!CREATE INDEX idx_steps_plan ON plan_steps(plan_id, step_order)v5#�!indexidx_breadcrumbs_planbreadcrumbs CREATE INDEX idx_breadcrumbs_plan ON breadcrumbs(plan_id, created_at DESC)�&''� tablesession_statesession_stateCREATE TABLE session_state ( key TEXT PRIMARY KEY, value TEXT NOT NULL, updated_at TEXT DEFAULT (datetime('now')) )9M'indexsqlite_autoindex_session_state_1session_state �P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)�^##�tableworker_logsworker_logsCREATE TABLE worker_logs ( id INTEGER PRIMARY KEY AUTOINCREMENT, worker_id TEXT NOT NULL REFERENCES workers(id) ON DELETE CASCADE, timestamp TEXT NOT NULL DEFAULT (datetime('now')), stream TEXT NOT NULL CHECK(stream IN ('stdout', 'stderr', 'system')), line TEXT NOT NULL, iteration INTEGER )-Aindexsqlite_autoindex_workers_1workers�m�1tableworkersworkersCREATE TABLE workers ( id TEXT PRIMARY KEY, container_id TEXT NOT NULL, thread_id TEXT NOT NULL REFERENCES threads(id), status TEXT DEFAULT 'running' CHECK(status IN ('running', 'completed', 'failed', 'killed')), last_heartbeat TEXT DEFAULT (datetime('now')), created_at TEXT DEFAULT (datetime('now')), auth_mode TEXT CHECK(auth_mode IN ('env', 'config', 'oauth')), iteration INTEGER DEFAULT 0, max_iterations INTEGER DEFAULT 50 )/Cindexsqlite_autoindex_next_ups_1next_ups�<�Ktablenext_upsnext_upsCREATE TABLE next_ups ( id TEXT PRIMARY KEY, title TEXT NOT NULL, content TEXT NOT NULL, is_template INTEGER NOT NULL DEFAULT 0, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'archived', 'launched')), created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), last_launched_at TEXT, launch_count INTEGER DEFAULT 0 )5I#indexsqlite_autoindex_bug_reports_1bug_reports�##�tablebug_reportsbug_reportsCREATE TABLE bug_reports ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), title TEXT NOT NULL, repro_steps TEXT NOT NULL, evidence TEXT, status TEXT DEFAULT 'open' CHECK(status IN ('open', 'resolved', 'wontfix')) )5I#indexsqlite_autoindex_corrections_1corrections�##�ktablec�&)''�viewrecent_crumbsrecent_crumbsCREATE VIEW recent_crumbs AS SELECT b.*, p.description as plan_description, s.description as step_description FROM breadcrumbs b LEFT JOIN plans p ON b.plan_id = p.id LEFT JOIN plan_steps s ON b.step_id = s.id ORDER BY b.created_at DESC LIMIT 10�S(''�iviewpending_stepspending_stepsCREATE VIEW pending_steps AS SELECT s.*, p.description as plan_description FROM plan_steps s JOIN plans p ON s.plan_id = p.id WHERE s.status = 'pending' ORDER BY s.step_order�'##� viewactive_planactive_planCREATE VIEW active_plan AS SELECT * FROM plans WHERE status IN ('accepted', 'in_progress') ORDER BY created_at DESC LIMIT 1Wd^�彔M�Z۪#�ȊSQLite format 3@ ).zp�� � - � � �  g` ��)Jx�h�77/Cindexsqlite_autoindex_next_ups_1next_ups�\##�tablebug_reportsbug_reportsCREATE TABLE bug_reports ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), title TEXT NOT NULL, repro_steps TEXT NOT NULL, evidence TEXT, status TEXT DEFAULT 'open' CHECK(status IN ('open', 'resolved', 'wontfix')) )5I#indexsqlite_autoindex_bug_reports_1bug_reports�##�ktablecorrectionscorrectionsCREATE TABLE corrections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), mistake TEXT NOT NULL, symptoms TEXT, resolution TEXT, tags TEXT )5I#indexsqlite_autoindex_corrections_1corrections�+##�tablereflectionsreflectionsCREATE TABLE reflections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), trigger TEXT CHECK(trigger IN ('manual', 'compact', 'completion', 'stop')), content TEXT NOT NULL )5I#indexsqlite_autoindex_reflections_1reflections�w ##�5tablebreadcrumbsbreadcrumbsCREATE TABLE breadcrumbs ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_id TEXT REFERENCES plan_steps(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), agent_type TEXT, summary TEXT NOT NULL, files_touched TEXT, issues TEXT, next_context TEXT )5I#indexsqlite_autoindex_breadcrumbs_1breadcrumbs�v !!�7tableplan_stepsplan_steps CREATE TABLE plan_steps ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_order INTEGER NOT NULL, description TEXT NOT NULL, status TEXT DEFAULT 'pending' CHECK(status IN ('pending', 'in_progress', 'completed', 'failed', 'skipped')), created_at TEXT DEFAULT (datetime('now')) )3 G!indexsqlite_autoindex_plan_steps_1plan_steps �V � tableplansplans CREATE TABLE plans ( id TEXT PRIMARY KEY, created_at TEXT DEFAULT (datetime('now')), status TEXT DEFAULT 'accepted' CHECK(status IN ('accepted', 'in_progress', 'completed', 'abandoned')), description TEXT, plan_markdown TEXT NOT NULL, session_id TEXT, thread_id TEXT REFERENCES threads(id) )) =indexsqlite_autoindex_plans_1plans �++�Ctablethread_sessionsthread_sessionsCREATE TABLE thread_sessions ( thread_id TEXT NOT NULL REFERENCES threads(id) ON DELETE CASCADE, session_id TEXT NOT NULL, created_at TEXT DEFAULT (datetime('now')), PRIMARY KEY (thread_id, session_id) )=Q+indexsqlite_autoindex_thread_sessions_1thread_sessions Q-iindexidx_threads_namethreadsCREATE INDEX idx_threads_name ON threads(name)W1qindexidx_threads_statusthreadsCREATE INDEX idx_threads_status ON threads(status)c3�indexidx_threads_updatedthreadsCREATE INDEX idx_threads_updated ON threads(updated_at DESC)�,�/tablethreadsthreadsCREATE TABLE threads ( id TEXT PRIMARY KEY, name TEXT NOT NULL UNIQUE, created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), current_plan_id TEXT REFERENCES plans(id), git_branches TEXT, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'paused', 'completed', 'archived')) )-Aindexsqlite_autoindex_threads_2threads-Aindexsqlite_autoindex_threads_1threads)Wd^�彔MSq��#�� �� � � ��s��}\��6�p�>�^� _ ��v&?#�indexidx_worker_logs_timestampworker_logs)CREATE INDEX idx_worker_logs_timestamp ON worker_logs(timestamp DESC){%9#�'indexidx_worker_logs_workerworker_logs(CREATE INDEX idx_worker_logs_worker ON worker_logs(worker_id, timestamp DESC)Z$1windexidx_workers_threadworkers'CREATE INDEX idx_workers_thread ON workers(thread_id)W#1qindexidx_workers_statusworkers&CREATE INDEX idx_workers_status ON workers(status)g"5� indexidx_next_ups_updatednext_ups%CREATE INDEX idx_next_ups_updated ON next_ups(updated_at DESC)[!3uindexidx_next_ups_statusnext_ups$CREATE INDEX idx_next_ups_status ON next_ups(status)d -�indexidx_plans_threadplans#CREATE INDEX idx_plans_thread ON plans(thread_id, created_at DESC)Y-!sindexidx_steps_statusplan_steps"CREATE INDEX idx_steps_status ON plan_steps(status)c)!� indexidx_steps_planplan_steps!CREATE INDEX idx_steps_plan ON plan_steps(plan_id, step_order)v5#�!indexidx_breadcrumbs_planbreadcrumbs CREATE INDEX idx_breadcrumbs_plan ON breadcrumbs(plan_id, created_at DESC)�&''� tablesession_statesession_stateCREATE TABLE session_state ( key TEXT PRIMARY KEY, value TEXT NOT NULL, updated_at TEXT DEFAULT (datetime('now')) )9M'indexsqlite_autoindex_session_state_1session_state �P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)�^##�tableworker_logsworker_logsCREATE TABLE worker_logs ( id INTEGER PRIMARY KEY AUTOINCREMENT, worker_id TEXT NOT NULL REFERENCES workers(id) ON DELETE CASCADE, timestamp TEXT NOT NULL DEFAULT (datetime('now')), stream TEXT NOT NULL CHECK(stream IN ('stdout', 'stderr', 'system')), line TEXT NOT NULL, iteration INTEGER )-Aindexsqlite_autoindex_workers_1workers�m�1tableworkersworkersCREATE TABLE workers ( id TEXT PRIMARY KEY, container_id TEXT NOT NULL, thread_id TEXT NOT NULL REFERENCES threads(id), status TEXT DEFAULT 'running' CHECK(status IN ('running', 'completed', 'failed', 'killed')), last_heartbeat TEXT DEFAULT (datetime('now')), created_at TEXT DEFAULT (datetime('now')), auth_mode TEXT CHECK(auth_mode IN ('env', 'config', 'oauth')), iteration INTEGER DEFAULT 0, max_iterations INTEGER DEFAULT 50 )/Cindexsqlite_autoindex_next_ups_1next_ups�<�Ktablenext_upsnext_upsCREATE TABLE next_ups ( id TEXT PRIMARY KEY, title TEXT NOT NULL, content TEXT NOT NULL, is_template INTEGER NOT NULL DEFAULT 0, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'archived', 'launched')), created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), last_launched_at TEXT, launch_count INTEGER DEFAULT 0 )5I#indexsqlite_autoindex_bug_reports_1bug_reports##�tablebug_reportsbug_reportsCREATE TABLE bug_reports ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), title TEXT NOT NULL, repro_steps TEXT NOT NULL, evidence TEXT, �*))�eviewcurrent_threadcurrent_threadCREATE VIEW current_thread AS SELECT * FROM threads WHERE status = 'active' ORDER BY updated_at DESC LIMIT 1�&)''�viewrecent_crumbsrecent_crumbsCREATE VIEW recent_crumbs AS SELECT b.*, p.description as plan_description, s.description as step_description FROM breadcrumbs b LEFT JOIN plans p ON b.plan_id = p.id LEFT JOIN plan_steps s ON b.step_id = s.id ORDER BY b.created_at DESC LIMIT 10�S(''�iviewpending_stepspending_stepsCREATE VIEW pending_steps AS SELECT s.*, p.description as plan_description FROM plan_steps s JOIN plans p ON s.plan_id = p.id WHERE s.status = 'pending' ORDER BY s.step_order�'##� viewactive_planactive_planCREATE VIEW active_plan AS SELECT * FROM plans WHERE status IN ('accepted', 'in_progress') ORDER BY created_at DESC LIMIT 1Wd^�彔M&Q6 ��]SQLite format 3@ +.zp�� � - � � �  g` ��)Jx�h�77/Cindexsqlite_autoindex_next_ups_1next_ups�\##�tablebug_reportsbug_reportsCREATE TABLE bug_reports ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), title TEXT NOT NULL, repro_steps TEXT NOT NULL, evidence TEXT, status TEXT DEFAULT 'open' CHECK(status IN ('open', 'resolved', 'wontfix')) )5I#indexsqlite_autoindex_bug_reports_1bug_reports�##�ktablecorrectionscorrectionsCREATE TABLE corrections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), mistake TEXT NOT NULL, symptoms TEXT, resolution TEXT, tags TEXT )5I#indexsqlite_autoindex_corrections_1corrections�+##�tablereflectionsreflectionsCREATE TABLE reflections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), trigger TEXT CHECK(trigger IN ('manual', 'compact', 'completion', 'stop')), content TEXT NOT NULL )5I#indexsqlite_autoindex_reflections_1reflections�w ##�5tablebreadcrumbsbreadcrumbsCREATE TABLE breadcrumbs ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_id TEXT REFERENCES plan_steps(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), agent_type TEXT, summary TEXT NOT NULL, files_touched TEXT, issues TEXT, next_context TEXT )5I#indexsqlite_autoindex_breadcrumbs_1breadcrumbs�v !!�7tableplan_stepsplan_steps CREATE TABLE plan_steps ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_order INTEGER NOT NULL, description TEXT NOT NULL, status TEXT DEFAULT 'pending' CHECK(status IN ('pending', 'in_progress', 'completed', 'failed', 'skipped')), created_at TEXT DEFAULT (datetime('now')) )3 G!indexsqlite_autoindex_plan_steps_1plan_steps �V � tableplansplans CREATE TABLE plans ( id TEXT PRIMARY KEY, created_at TEXT DEFAULT (datetime('now')), status TEXT DEFAULT 'accepted' CHECK(status IN ('accepted', 'in_progress', 'completed', 'abandoned')), description TEXT, plan_markdown TEXT NOT NULL, session_id TEXT, thread_id TEXT REFERENCES threads(id) )) =indexsqlite_autoindex_plans_1plans �++�Ctablethread_sessionsthread_sessionsCREATE TABLE thread_sessions ( thread_id TEXT NOT NULL REFERENCES threads(id) ON DELETE CASCADE, session_id TEXT NOT NULL, created_at TEXT DEFAULT (datetime('now')), PRIMARY KEY (thread_id, session_id) )=Q+indexsqlite_autoindex_thread_sessions_1thread_sessions Q-iindexidx_threads_namethreadsCREATE INDEX idx_threads_name ON threads(name)W1qindexidx_threads_statusthreadsCREATE INDEX idx_threads_status ON threads(status)c3�indexidx_threads_updatedthreadsCREATE INDEX idx_threads_updated ON threads(updated_at DESC)�,�/tablethreadsthreadsCREATE TABLE threads ( id TEXT PRIMARY KEY, name TEXT NOT NULL UNIQUE, created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), current_plan_id TEXT REFERENCES plans(id), git_branches TEXT, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'paused', 'completed', 'archived')) )-Aindexsqlite_autoindex_threads_2threads-Aindexsqlite_autoindex_threads_1threadsWd^�彔Md�y2�z �� ��� � - � � �  g` ��)�J5��h�7II-Aindexsqlite_autoindex_workers_1workers�<�Ktablenext_upsnext_upsCREATE TABLE next�<�Ktablenext_upsnext_upsCREATE TABLE next_ups ( id TEXT PRIMARY KEY, title TEXT NOT NULL, content TEXT NOT NULL, is_template INTEGER NOT NULL DEFAULT 0, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'archived', 'launched')), created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), last_launched_at TEXT, launch_count INTEGER DEFAULT 0 )5I#indexsqlite_autoindex_bug_reports_1bug_reports�\##�tablebug_reportsbug_reportsCREATE TABLE bug_reports ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), title TEXT NOT NULL, repro_steps TEXT NOT NULL, evidence TEXT, status TEXT DEFAULT 'open' CHECK(status IN ('open', 'resolved', 'wontfix')) )5I#indexsqlite_autoindex_corrections_1corrections�##�ktablecorrectionscorrectionsCREATE TABLE corrections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), mistake TEXT NOT NULL, symptoms TEXT, resolution TEXT, tags TEXT )5I#indexsqlite_autoindex_reflections_1reflections�+##�tablereflectionsreflectionsCREATE TABLE reflections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), trigger TEXT CHECK(trigger IN ('manual', 'compact', 'completion', 'stop')), content TEXT NOT NULL )�w ##�5tablebreadcrumbsbreadcrumbsCREATE TABLE breadcrumbs ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_id TEXT REFERENCES plan_steps(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), agent_type TEXT, summary TEXT NOT NULL, files_touched TEXT, issues TEXT, next_context TEXT )5I#indexsqlite_autoindex_breadcrumbs_1breadcrumbs�v !!�7tableplan_stepsplan_steps CREATE TABLE plan_steps ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_order INTEGER NOT NULL, description TEXT NOT NULL, status TEXT DEFAULT 'pending' CHECK(status IN ('pending', 'in_progress', 'completed', 'failed', 'skipped')), created_at TEXT DEFAULT (datetime('now')) )3 G!indexsqlite_autoindex_plan_steps_1plan_steps �V � tableplansplans CREATE TABLE plans ( id TEXT PRIMARY KEY, created_at TEXT DEFAULT (datetime('now')), status TEXT DEFAULT 'accepted' CHECK(status IN ('accepted', 'in_progress', 'completed', 'abandoned')), description TEXT, plan_markdown TEXT NOT NULL, session_id TEXT, thread_id TEXT REFERENCES threads(id) )) =indexsqlite_autoindex_plans_1plans �++�Ctablethread_sessionsthread_sessionsCREATE TABLE thread_sessions ( thread_id TEXT NOT NULL REFERENCES threads(id) ON DELETE CASCADE, session_id TEXT NOT NULL, created_at TEXT DEFAULT (datetime('now')), PRIMARY KEY (thread_id, session_id) )=Q+indexsqlite_autoindex_thread_sessions_1thread_sessions Q-iindexidx_threads_namethreadsCREATE INDEX idx_threads_name ON threads(name)W1qindexidx_threads_statusthreadsCREATE INDEX idx_threads_status ON threads(status)c3�indexidx_threads_updatedthreadsCREATE INDEX idx_threads_updated ON threads(updated_at DESC)�,�/tablethreadsthreadsCREATE TABLE threads ( id TEXT PRIMARY KEY, name TEXT NOT NULL UNIQUE, created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), current_plan_id TEXT REFERENCES plans(id), git_branches TEXT, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'paused', 'completed', 'archived')) )-Aindexsqlite_autoindex_threads_2threads-Aindexsqlite_autoindex_threads_1threadsWd^�彔M�豞t�"� �� ��s��}\��6�p�>�^� _ � � �� ��v&?#�indexidx_worker_logs_timestampworker_logs)CREATE INDEX idx_worker_logs_timestamp ON worker_logs(timestamp DESC){%9#�'indexidx_worker_logs_workerworker_logs(CREATE INDEX idx_worker_logs_worker ON worker_logs(worker_id, timestamp DESC)Z$1windexidx_workers_threadworkers'CREATE INDEX idx_workers_thread ON workers(thread_id)W#1qindexidx_workers_statusworkers&CREATE INDEX idx_workers_status ON workers(status)g"5� indexidx_next_ups_updatednext_ups%CREATE INDEX idx_next_ups_updated ON next_ups(updated_at DESC)[!3uindexidx_next_ups_statusnext_ups$CREATE INDEX idx_next_ups_status ON next_ups(status)d -�indexidx_plans_threadplans#CREATE INDEX idx_plans_thread ON plans(thread_id, created_at DESC)Y-!sindexidx_steps_statusplan_steps"CREATE INDEX idx_steps_status ON plan_steps(status)c)!� indexidx_steps_planplan_steps!CREATE INDEX idx_steps_plan ON plan_steps(plan_id, step_order)v5#�!indexidx_breadcrumbs_planbreadcrumbs CREATE INDEX idx_breadcrumbs_plan ON breadcrumbs(plan_id, created_at DESC)�&''� tablesession_statesession_stateCREATE TABLE session_state ( key TEXT PRIMARY KEY, value TEXT NOT NULL, updated_at TEXT DEFAULT (datetime('now')) )9M'indexsqlite_autoindex_session_state_1session_state �P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)�^##�tableworker_logsworker_logsCREATE TABLE worker_logs ( id INTEGER PRIMARY KEY AUTOINCREMENT, worker_id TEXT NOT NULL REFERENCES workers(id) ON DELETE CASCADE, timestamp TEXT NOT NULL DEFAULT (datetime('now')), stream TEXT NOT NULL CHECK(stream IN ('stdout', 'stderr', 'system')), line TEXT NOT NULL, iteration INTEGER )-Aindexsqlite_autoindex_workers_1workers�m�1tableworkersworkersCREATE TABLE workers ( id TEXT PRIMARY KEY, container_id TEXT NOT NULL, thread_id TEXT NOT NULL REFERENCES threads(id), status TEXT DEFAULT 'running' CHECK(status IN ('running', 'completed', 'failed', 'killed')), last_heartbeat TEXT DEFAULT (datetime('now')), created_at TEXT DEFAULT (datetime('now')), auth_mode TEXT CHECK(auth_mode IN ('env', 'config', 'oauth')), iteration INTEGER DEFAULT 0, max_iterations INTEGER DEFAULT 50 )/Cindexsqlite_autoindex_next_ups_1next_ups��Ktablenext_upsnext_upsCREATE TABLE next_ups ( id TEXT PRIMARY KEY, title TEXT NOT NULL, content TEXT NOT NULL, is_template INTEGER NOT NULL DEFAULT 0, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN �m+�9tabletaskstasks*CREATE TABLE tasks ( id TEXT NOT NULL, session_id TEXT NOT NULL, thread_id TEXT REFERENCES threads(id) ON DELETE SET NULL, subject TEXT NOT NULL, description TEXT, active_form TEXT, status TEXT NOT NULL DEFAULT 'pending', blocks TEXT, blocked_by TEXT, created_at TEXT DEFAULT (datetime('now')), updated_at TEXT DEFAULT (datetime('now')), PRIMARY KEY (session_id, id) )),=indexsqlite_autoindex_tasks_1tasks+�*))�eviewcurrent_threadcurrent_threadCREATE VIEW current_thread AS SELECT * FROM threads WHERE status = 'active' ORDER BY updated_at DESC LIMIT 1�&)''�viewrecent_crumbsrecent_crumbsCREATE VIEW recent_crumbs AS SELECT b.*, p.description as plan_description, s.description as step_description FROM breadcrumbs b LEFT JOIN plans p ON b.plan_id = p.id LEFT JOIN plan_steps s ON b.step_id = s.id ORDER BY b.created_at DESC LIMIT 10�S(''�iviewpending_stepspending_stepsCREATE VIEW pending_steps AS SELECT s.*, p.description as plan_description FROM plan_steps s JOIN plans p ON s.plan_id = p.id WHERE s.status = 'pending' ORDER BY s.step_order�'##� viewactive_planactive_planCREATE VIEW active_plan AS SELECT * FROM plans WHERE status IN ('accepted', 'in_progress') ORDER BY created_at DESC LIMIT 1*Wd^�彔M$S��+� ++Wd^�彔M]1� Ԟ(� Wd^�彔Me�+3��XSQLite format 3@ ,.zp�� � - � � �  g` ��)Jx�h�77/Cindexsqlite_autoindex_next_ups_1next_ups�\##�tablebug_reportsbug_reportsCREATE TABLE bug_reports ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), title TEXT NOT NULL, repro_steps TEXT NOT NULL, evidence TEXT, status TEXT DEFAULT 'open' CHECK(status IN ('open', 'resolved', 'wontfix')) )5I#indexsqlite_autoindex_bug_reports_1bug_reports�##�ktablecorrectionscorrectionsCREATE TABLE corrections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), mistake TEXT NOT NULL, symptoms TEXT, resolution TEXT, tags TEXT )5I#indexsqlite_autoindex_corrections_1corrections�+##�tablereflectionsreflectionsCREATE TABLE reflections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), trigger TEXT CHECK(trigger IN ('manual', 'compact', 'completion', 'stop')), content TEXT NOT NULL )5I#indexsqlite_autoindex_reflections_1reflections�w ##�5tablebreadcrumbsbreadcrumbsCREATE TABLE breadcrumbs ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_id TEXT REFERENCES plan_steps(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), agent_type TEXT, summary TEXT NOT NULL, files_touched TEXT, issues TEXT, next_context TEXT )5I#indexsqlite_autoindex_breadcrumbs_1breadcrumbs�v !!�7tableplan_stepsplan_steps CREATE TABLE plan_steps ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_order INTEGER NOT NULL, description TEXT NOT NULL, status TEXT DEFAULT 'pending' CHECK(status IN ('pending', 'in_progress', 'completed', 'failed', 'skipped')), created_at TEXT DEFAULT (datetime('now')) )3 G!indexsqlite_autoindex_plan_steps_1plan_steps �V � tableplansplans CREATE TABLE plans ( id TEXT PRIMARY KEY, created_at TEXT DEFAULT (datetime('now')), status TEXT DEFAULT 'accepted' CHECK(status IN ('accepted', 'in_progress', 'completed', 'abandoned')), description TEXT, plan_markdown TEXT NOT NULL, session_id TEXT, thread_id TEXT REFERENCES threads(id) )) =indexsqlite_autoindex_plans_1plans �++�Ctablethread_sessionsthread_sessionsCREATE TABLE thread_sessions ( thread_id TEXT NOT NULL REFERENCES threads(id) ON DELETE CASCADE, session_id TEXT NOT NULL, created_at TEXT DEFAULT (datetime('now')), PRIMARY KEY (thread_id, session_id) )=Q+indexsqlite_autoindex_thread_sessions_1thread_sessions Q-iindexidx_threads_namethreadsCREATE INDEX idx_threads_name ON threads(name)W1qindexidx_threads_statusthreadsCREATE INDEX idx_threads_status ON threads(status)c3�indexidx_threads_updatedthreadsCREATE INDEX idx_threads_updated ON threads(updated_at DESC)�,�/tablethreadsthreadsCREATE TABLE threads ( id TEXT PRIMARY KEY, name TEXT NOT NULL UNIQUE, created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), current_plan_id TEXT REFERENCES plans(id), git_branches TEXT, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'paused', 'completed', 'archived')) )-Aindexsqlite_autoindex_threads_2threads-Aindexsqlite_autoindex_threads_1threadsWd^�彔ML�q�s� �� ��s��}\��6�p�>�^� _ � � � Z ��v&?#�indexidx_worker_logs_timestampworker_logs)CREATE INDEX idx_worker_logs_timestamp ON worker_logs(timestamp DESC){%9#�'indexidx_worker_logs_workerworker_logs(CREATE INDEX idx_worker_logs_worker ON worker_logs(worker_id, timestamp DESC)Z$1windexidx_workers_threadworkers'CREATE INDEX idx_workers_thread ON workers(thread_id)W#1qindexidx_workers_statusworkers&CREATE INDEX idx_workers_status ON workers(status)g"5� indexidx_next_ups_updatednext_ups%CREATE INDEX idx_next_ups_updated ON next_ups(updated_at DESC)[!3uindexidx_next_ups_statusnext_ups$CREATE INDEX idx_next_ups_status ON next_ups(status)d -�indexidx_plans_threadplans#CREATE INDEX idx_plans_thread ON plans(thread_id, created_at DESC)Y-!sindexidx_steps_statusplan_steps"CREATE INDEX idx_steps_status ON plan_steps(status)c)!� indexidx_steps_planplan_steps!CREATE INDEX idx_steps_plan ON plan_steps(plan_id, step_order)v5#�!indexidx_breadcrumbs_planbreadcrumbs CREATE INDEX idx_breadcrumbs_plan ON breadcrumbs(plan_id, created_at DESC)�&''� tablesession_statesession_stateCREATE TABLE session_state ( key TEXT PRIMARY KEY, value TEXT NOT NULL, updated_at TEXT DEFAULT (datetime('now')) )9M'indexsqlite_autoindex_session_state_1session_state �P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)�^##�tableworker_logsworker_logsCREATE TABLE worker_logs ( id INTEGER PRIMARY KEY AUTOINCREMENT, worker_id TEXT NOT NULL REFERENCES workers(id) ON DELETE CASCADE, timestamp TEXT NOT NULL DEFAULT (datetime('now')), stream TEXT NOT NULL CHECK(stream IN ('stdout', 'stderr', 'system')), line TEXT NOT NULL, iteration INTEGER )-Aindexsqlite_autoindex_workers_1workers�m�1tableworkersworkersCREATE TABLE workers ( id TEXT PRIMARY KEY, container_id TEXT NOT NULL, thread_id TEXT NOT NULL REFERENCES threads(id), status TEXT DEFAULT 'running' CHECK(status IN ('running', 'completed', 'failed', 'killed')), last_heartbeat TEXT DEFAULT (datetime('now')), created_at TEXT DEFAULT (datetime('now')), auth_mode TEXT CHECK(auth_mode IN ('env', 'config', 'oauth')), iteration INTEGER DEFAULT 0, max_iterations INTEGER DEFAULT 50 )/Cindexsqlite_autoindex_next_ups_1next_ups��Ktablenext_upsnext_upsCREATE TABLE next_ups ( id TEXT PRIMARY KEY, title TEXT NOT NULL, content TEXT NOT NULL, is_template INR--oindexidx_tasks_threadtasks,CREATE INDEX idx_tasks_thread ON tasks(thread_id)�m+�9tabletaskstasks*CREATE TABLE tasks ( id TEXT NOT NULL, session_id TEXT NOT NULL, thread_id TEXT REFERENCES threads(id) ON DELETE SET NULL, subject TEXT NOT NULL, description TEXT, active_form TEXT, status TEXT NOT NULL DEFAULT 'pending', blocks TEXT, blocked_by TEXT, created_at TEXT DEFAULT (datetime('now')), updated_at TEXT DEFAULT (datetime('now')), PRIMARY KEY (session_id, id) )),=indexsqlite_autoindex_tasks_1tasks+�*))�eviewcurrent_threadcurrent_threadCREATE VIEW current_thread AS SELECT * FROM threads WHERE status = 'active' ORDER BY updated_at DESC LIMIT 1�&)''�viewrecent_crumbsrecent_crumbsCREATE VIEW recent_crumbs AS SELECT b.*, p.description as plan_description, s.description as step_description FROM breadcrumbs b LEFT JOIN plans p ON b.plan_id = p.id LEFT JOIN plan_steps s ON b.step_id = s.id ORDER BY b.created_at DESC LIMIT 10�S(''�iviewpending_stepspending_stepsCREATE VIEW pending_steps AS SELECT s.*, p.description as plan_description FROM plan_steps s JOIN plans p ON s.plan_id = p.id WHERE s.status = 'pending' ORDER BY s.step_order�'##� viewactive_planactive_planCREATE VIEW active_plan AS SELECT * FROM plans WHERE status IN ('accepted', 'in_progress') ORDER BY created_at DESC LIMIT 1,,Wd^�彔MJ+ �!� Wd^�彔M&�C���7SQLite format 3@ - .zp�� � - � � �  g` ��)Jx�h�77/Cindexsqlite_autoindex_next_ups_1next_ups�\##�tablebug_reportsbug_reportsCREATE TABLE bug_reports ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), title TEXT NOT NULL, repro_steps TEXT NOT NULL, evidence TEXT, status TEXT DEFAULT 'open' CHECK(status IN ('open', 'resolved', 'wontfix')) )5I#indexsqlite_autoindex_bug_reports_1bug_reports�##�ktablecorrectionscorrectionsCREATE TABLE corrections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), mistake TEXT NOT NULL, symptoms TEXT, resolution TEXT, tags TEXT )5I#indexsqlite_autoindex_corrections_1corrections�+##�tablereflectionsreflectionsCREATE TABLE reflections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), trigger TEXT CHECK(trigger IN ('manual', 'compact', 'completion', 'stop')), content TEXT NOT NULL )5I#indexsqlite_autoindex_reflections_1reflections�w ##�5tablebreadcrumbsbreadcrumbsCREATE TABLE breadcrumbs ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_id TEXT REFERENCES plan_steps(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), agent_type TEXT, summary TEXT NOT NULL, files_touched TEXT, issues TEXT, next_context TEXT )5I#indexsqlite_autoindex_breadcrumbs_1breadcrumbs�v !!�7tableplan_stepsplan_steps CREATE TABLE plan_steps ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_order INTEGER NOT NULL, description TEXT NOT NULL, status TEXT DEFAULT 'pending' CHECK(status IN ('pending', 'in_progress', 'completed', 'failed', 'skipped')), created_at TEXT DEFAULT (datetime('now')) )3 G!indexsqlite_autoindex_plan_steps_1plan_steps �V � tableplansplans CREATE TABLE plans ( id TEXT PRIMARY KEY, created_at TEXT DEFAULT (datetime('now')), status TEXT DEFAULT 'accepted' CHECK(status IN ('accepted', 'in_progress', 'completed', 'abandoned')), description TEXT, plan_markdown TEXT NOT NULL, session_id TEXT, thread_id TEXT REFERENCES threads(id) )) =indexsqlite_autoindex_plans_1plans �++�Ctablethread_sessionsthread_sessionsCREATE TABLE thread_sessions ( thread_id TEXT NOT NULL REFERENCES threads(id) ON DELETE CASCADE, session_id TEXT NOT NULL, created_at TEXT DEFAULT (datetime('now')), PRIMARY KEY (thread_id, session_id) )=Q+indexsqlite_autoindex_thread_sessions_1thread_sessions Q-iindexidx_threads_namethreadsCREATE INDEX idx_threads_name ON threads(name)W1qindexidx_threads_statusthreadsCREATE INDEX idx_threads_status ON threads(status)c3�indexidx_threads_updatedthreadsCREATE INDEX idx_threads_updated ON threads(updated_at DESC)�,�/tablethreadsthreadsCREATE TABLE threads ( id TEXT PRIMARY KEY, name TEXT NOT NULL UNIQUE, created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), current_plan_id TEXT REFERENCES plans(id), git_branches TEXT, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'paused', 'completed', 'archived')) )-Aindexsqlite_autoindex_threads_2threads-Aindexsqlite_autoindex_threads_1threadsWd^�彔M݇� ܆d �� ��s��}\��6�p�>�^� _ � � � Z �v&?#�indexidx_worker_logs_timestampworker_logs)CREATE INDEX idx_worker_logs_timestamp ON worker_logs(timestamp DESC){%9#�'indexidx_worker_logs_workerworker_logs(CREATE INDEX idx_worker_logs_worker ON worker_logs(worker_id, timestamp DESC)Z$1windexidx_workers_threadworkers'CREATE INDEX idx_workers_thread ON workers(thread_id)W#1qindexidx_workers_statusworkers&CREATE INDEX idx_workers_status ON workers(status)g"5� indexidx_next_ups_updatednext_ups%CREATE INDEX idx_next_ups_updated ON next_ups(updated_at DESC)[!3uindexidx_next_ups_statusnext_ups$CREATE INDEX idx_next_ups_status ON next_ups(status)d -�indexidx_plans_threadplans#CREATE INDEX idx_plans_thread ON plans(thread_id, created_at DESC)Y-!sindexidx_steps_statusplan_steps"CREATE INDEX idx_steps_status ON plan_steps(status)c)!� indexidx_steps_planplan_steps!CREATE INDEX idx_steps_plan ON plan_steps(plan_id, step_order)v5#�!indexidx_breadcrumbs_planbreadcrumbs CREATE INDEX idx_breadcrumbs_plan ON breadcrumbs(plan_id, created_at DESC)�&''� tablesession_statesession_stateCREATE TABLE session_state ( key TEXT PRIMARY KEY, value TEXT NOT NULL, updated_at TEXT DEFAULT (datetime('now')) )9M'indexsqlite_autoindex_session_state_1session_state �P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)�^##�tableworker_logsworker_logsCREATE TABLE worker_logs ( id INTEGER PRIMARY KEY AUTOINCREMENT, worker_id TEXT NOT NULL REFERENCES workers(id) ON DELETE CASCADE, timestamp TEXT NOT NULL DEFAULT (datetime('now')), stream TEXT NOT NULL CHECK(stream IN ('stdout', 'stderr', 'system')), line TEXT NOT NULL, iteration INTEGER )-Aindexsqlite_autoindex_workers_1workers�m�1tableworkersworkersCREATE TABLE workers ( id TEXT PRIMARY KEY, container_id TEXT NOT NULL, thread_id TEXT NOT NULL REFERENCES threads(id), status TEXT DEFAULT 'running' CHECK(status IN ('running', 'completed', 'failed', 'killed')), last_heartbeat TEXT DEFAULT (datetime('now')), created_at TEXT DEFAULT (datetime('now')), auth_mode TEXT CHECK(auth_mode IN ('env', 'config', 'oauth')), iteration INTEGER DEFAULT 0, max_iterations INTEGER DEFAULT 50 )/Cindexsqlite_autoindex_next_ups_1next_ups@�Ktablenext_upsnext_upsCREATE TABLE next_ups ( id TU./sindexidx_tasks_sessiontasks-CREATE INDEX idx_tasks_session ON tasks(session_id)R--oindexidx_tasks_threadtasks,CREATE INDEX idx_tasks_thread ON tasks(thread_id)�m+�9tabletaskstasks*CREATE TABLE tasks ( id TEXT NOT NULL, session_id TEXT NOT NULL, thread_id TEXT REFERENCES threads(id) ON DELETE SET NULL, subject TEXT NOT NULL, description TEXT, active_form TEXT, status TEXT NOT NULL DEFAULT 'pending', blocks TEXT, blocked_by TEXT, created_at TEXT DEFAULT (datetime('now')), updated_at TEXT DEFAULT (datetime('now')), PRIMARY KEY (session_id, id) )),=indexsqlite_autoindex_tasks_1tasks+�*))�eviewcurrent_threadcurrent_threadCREATE VIEW current_thread AS SELECT * FROM threads WHERE status = 'active' ORDER BY updated_at DESC LIMIT 1�&)''�viewrecent_crumbsrecent_crumbsCREATE VIEW recent_crumbs AS SELECT b.*, p.description as plan_description, s.description as step_description FROM breadcrumbs b LEFT JOIN plans p ON b.plan_id = p.id LEFT JOIN plan_steps s ON b.step_id = s.id ORDER BY b.created_at DESC LIMIT 10�S(''�iviewpending_stepspending_stepsCREATE VIEW pending_steps AS SELECT s.*, p.description as plan_description FROM plan_steps s JOIN plans p ON s.plan_id = p.id WHERE s.status = 'pending' ORDER BY s.step_order�'##� viewactive_planactive_planCREATE VIEW active_plan AS SELECT * FROM plans WHERE status IN ('accepted', 'in_progress') ORDER BY created_at DESC LIMIT 1--Wd^�彔M3,B9GĐ Wd^�彔MU;b}D�#SQLite format 3@ /!.zp�/�� - � � �  g` ��)Jx�h�77/Cindexsqlite_autoindex_next_ups_1next_ups�\##�tablebug_reportsbug_reportsCREATE TABLE bug_reports ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), title TEXT NOT NULL, repro_steps TEXT NOT NULL, evidence TEXT, status TEXT DEFAULT 'open' CHECK(status IN ('open', 'resolved', 'wontfix')) )5I#indexsqlite_autoindex_bug_reports_1bug_reports�##�ktablecorrectionscorrectionsCREATE TABLE corrections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), mistake TEXT NOT NULL, symptoms TEXT, resolution TEXT, tags TEXT )5I#indexsqlite_autoindex_corrections_1corrections�+##�tablereflectionsreflectionsCREATE TABLE reflections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), trigger TEXT CHECK(trigger IN ('manual', 'compact', 'completion', 'stop')), content TEXT NOT NULL )5I#indexsqlite_autoindex_reflections_1reflections�w ##�5tablebreadcrumbsbreadcrumbsCREATE TABLE breadcrumbs ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_id TEXT REFERENCES plan_steps(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), agent_type TEXT, summary TEXT NOT NULL, files_touched TEXT, issues TEXT, next_context TEXT )5I#indexsqlite_autoindex_breadcrumbs_1breadcrumbs�v !!�7tableplan_stepsplan_steps CREATE TABLE plan_steps ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_order INTEGER NOT NULL, description TEXT NOT NULL, status TEXT DEFAULT 'pending' CHECK(status IN ('pending', 'in_progress', 'completed', 'failed', 'skipped')), created_at TEXT DEFAULT (datetime('now')) )3 G!indexsqlite_autoindex_plan_steps_1plan_steps �V � tableplansplans CREATE TABLE plans ( id TEXT PRIMARY KEY, created_at TEXT DEFAULT (datetime('now')), status TEXT DEFAULT 'accepted' CHECK(status IN ('accepted', 'in_progress', 'completed', 'abandoned')), description TEXT, plan_markdown TEXT NOT NULL, session_id TEXT, thread_id TEXT REFERENCES threads(id) )) =indexsqlite_autoindex_plans_1plans �++�Ctablethread_sessionsthread_sessionsCREATE TABLE thread_sessions ( thread_id TEXT NOT NULL REFERENCES threads(id) ON DELETE CASCADE, session_id TEXT NOT NULL, created_at TEXT DEFAULT (datetime('now')), PRIMARY KEY (thread_id, session_id) )=Q+indexsqlite_autoindex_thread_sessions_1thread_sessions Q-iindexidx_threads_namethreadsCREATE INDEX idx_threads_name ON threads(name)W1qindexidx_threads_statusthreadsCREATE INDEX idx_threads_status ON threads(status)c3�indexidx_threads_updatedthreadsCREATE INDEX idx_threads_updated ON threads(updated_at DESC)�,�/tablethreadsthreadsCREATE TABLE threads ( id TEXT PRIMARY KEY, name TEXT NOT NULL UNIQUE, created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), current_plan_id TEXT REFERENCES plans(id), git_branches TEXT, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'paused', 'completed', 'archived')) )-Aindexsqlite_autoindex_threads_2threads-Aindexsqlite_autoindex_threads_1thread&Wd^�彔Mz��I!z �� ��� � - � � �  g` ��)�J5��h�7II-Aindexsqlite_autoindex_workers_1workers�<�Ktablenext_upsnext_upsCREATE TABLE next�<�Ktablenext_upsnext_upsCREATE TABLE next_ups ( id TEXT PRIMARY KEY, title TEXT NOT NULL, content TEXT NOT NULL, is_template INTEGER NOT NULL DEFAULT 0, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'archived', 'launched')), created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), last_launched_at TEXT, launch_count INTEGER DEFAULT 0 )5I#indexsqlite_autoindex_bug_reports_1bug_reports�\##�tablebug_reportsbug_reportsCREATE TABLE bug_reports ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), title TEXT NOT NULL, repro_steps TEXT NOT NULL, evidence TEXT, status TEXT DEFAULT 'open' CHECK(status IN ('open', 'resolved', 'wontfix')) )5I#indexsqlite_autoindex_corrections_1corrections�##�ktablecorrectionscorrectionsCREATE TABLE corrections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), mistake TEXT NOT NULL, symptoms TEXT, resolution TEXT, tags TEXT )5I#indexsqlite_autoindex_reflections_1reflections�+##�tablereflectionsreflectionsCREATE TABLE reflections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), trigger TEXT CHECK(trigger IN ('manual', 'compact', 'completion', 'stop')), content TEXT NOT NULL )�w ##�5tablebreadcrumbsbreadcrumbsCREATE TABLE breadcrumbs ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_id TEXT REFERENCES plan_steps(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), agent_type TEXT, summary TEXT NOT NULL, files_touched TEXT, issues TEXT, next_context TEXT )5I#indexsqlite_autoindex_breadcrumbs_1breadcrumbs�v !!�7tableplan_stepsplan_steps CREATE TABLE plan_steps ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_order INTEGER NOT NULL, description TEXT NOT NULL, status TEXT DEFAULT 'pending' CHECK(status IN ('pending', 'in_progress', 'completed', 'failed', 'skipped')), created_at TEXT DEFAULT (datetime('now')) )3 G!indexsqlite_autoindex_plan_steps_1plan_steps �V � tableplansplans CREATE TABLE plans ( id TEXT PRIMARY KEY, created_at TEXT DEFAULT (datetime('now')), status TEXT DEFAULT 'accepted' CHECK(status IN ('accepted', 'in_progress', 'completed', 'abandoned')), description TEXT, plan_markdown TEXT NOT NULL, session_id TEXT, thread_id TEXT REFERENCES threads(id) )) =indexsqlite_autoindex_plans_1plans �++�Ctablethread_sessionsthread_sessionsCREATE TABLE thread_sessions ( thread_id TEXT NOT NULL REFERENCES threads(id) ON DELETE CASCADE, session_id TEXT NOT NULL, created_at TEXT DEFAULT (datetime('now')), PRIMARY KEY (thread_id, session_id) )=Q+indexsqlite_autoindex_thread_sessions_1thread_sessions Q-iindexidx_threads_namethreadsCREATE INDEX idx_threads_name ON threads(name)W1qindexidx_threads_statusthreadsCREATE INDEX idx_threads_status ON threads(status)c3�indexidx_threads_updatedthreadsCREATE INDEX idx_threads_updated ON threads(updated_at DESC)�,�/tablethreadsthreadsCREATE TABLE threads ( id TEXT PRIMARY KEY, name TEXT NOT NULL UNIQUE, created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), current_plan_id TEXT REFERENCES plans(id), git_branches TEXT, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'paused', 'completed', 'archived')) )-Aindexsqlite_autoindex_threads_2threads-Aindexsqlite_autoindex_threads_1threadsWd^�彔Mݴ��E ��� ��s��}\��6�p�>� _ � � � Z �v&?#�indexidx_worker_logs_timestampworker_logs)CREATE INDEX idx_worker_logs_timestamp ON worker_logs(timestamp DESC){%9#�'indexidx_worker_logs_workerworker_logs(CREATE INDEX idx_worker_logs_worker ON worker_logs(worker_id, timestamp DESC)Z$1windexidx_workers_threadworkers'CREATE INDEX idx_workers_thread ON workers(thread_id)W#1qindexidx_workers_statusworkers&CREATE INDEX idx_workers_status ON workers(status)g"5� indexidx_next_ups_updatednext_ups%CREATE INDEX idx_next_ups_updated ON next_ups(updated_at DESC)[!3uindexidx_next_ups_statusnext_ups$CREATE INDEX idx_next_ups_status ON next_ups(status)d -�indexidx_plans_threadplans#CREATE INDEX idx_plans_thread ON plans(thread_id, created_at DESC)Y-!sindexidx_steps_statusplan_steps"CREATE INDEX idx_steps_status ON plan_steps(status)c)!� indexidx_steps_planplan_steps!CREATE INDEX idx_steps_plan ON plan_steps(plan_id, step_order)v5#�!indexidx_breadcrumbs_planbreadcrumbs CREATE INDEX idx_breadcrumbs_plan ON breadcrumbs(plan_id, created_at DESC)�&''� tablesession_statesession_stateCREATE TABLE session_state ( key TEXT PRIMARY KEY, value TEXT NOT NULL, updated_at TEXT DEFAULT (datetime('now')) )9M'indexsqlite_autoindex_session_state_1session_state �P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)�^##�tableworker_logsworker_logsCREATE TABLE worker_logs ( id INTEGER PRIMARY KEY AUTOINCREMENT, worker_id TEXT NOT NULL REFERENCES workers(id) ON DELETE CASCADE, timestamp TEXT NOT NULL DEFAULT (datetime('now')), stream TEXT NOT NULL CHECK(stream IN ('stdout', 'stderr', 'system')), line TEXT NOT NULL, iteration INTEGER )-Aindexsqlite_autoindex_workers_1workers�m�1tableworkersworkersCREATE TABLE workers ( id TEXT PRIMARY KEY, container_id TEXT NOT NULL, thread_id TEXT NOT NULL REFERENCES threads(id), status TEXT DEFAULT 'running' CHECK(status IN ('running', 'completed', 'failed', 'killed')), last_heartbeat TEXT DEFAULT (datetime('now')), created_at TEXT DEFAULT (datetime('now')), auth_mode TEXT CHECK(auth_mode IN ('env', 'config', 'oauth')), iteration INTEGER DEFAULT 0, max_iterations INTEGER DEFAULT 50 )/Cindexsqlite_autoindex_next_ups_1next_upsG�Ktablenext_upsnext_upsCREATE TABLE next_ups ( id TU./sindexidx_tasks_sessiontasks-CREATE INDEX idx_tasks_session ON tasks(session_id)R--oindexidx_tasks_threadtasks,CREATE INDEX idx_tasks_thread ON tasks(thread_id)�m+�9tabletaskstasks*CREATE TABLE tasks ( id TEXT NOT NULL, session_id TEXT NOT NULL, thread_id TEXT REFERENCES threads(id) ON DELETE SET NULL, subject TEXT NOT NULL, description TEXT, active_form TEXT, status TEXT NOT NULL DEFAULT 'pending', blocks TEXT, blocked_by TEXT, created_at TEXT DEFAULT (datetime('now')), updated_at TEXT DEFAULT (datetime('now')), PRIMARY KEY (session_id, id) )b=indexsqlite_autoindex_tasks_1tasks+�*))�eviewcurrent_threadcurrent_threadCREATE VIEW current_thread AS SELECT * FROM threads WHERE status = 'active' ORDER BY updated_at DESC LIMIT 1�&)''�viewrecent_crumbsrecent_crumbsCREATE VIEW recent_crumbs AS SELECT b.*, p.description as plan_description, s.description as step_description FROM brea�<�Ktablenext_upsnext_upsCREATE TABLE next_ups ( id TEXT PRIMARY KEY, title TEXT NOT NULL, content TEXT NOT NULL, is_template INTEGER NOT NULL DEFAULT 0, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'archived', 'launched')), created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), last_launched_at TEXT, launch_count INTEGER DEFAULT 0 )5I#indexsqlite_autoindex_bug_reports_1bug_reports.Wd^�彔M�z5�VH //Wd^�彔M eIF}a ^� _ � � � Z �o/''�tableworker_eventsworker_events.CREATE TABLE worker_events ( id INTEGER PRIMARY KEY AUTOINCREMENT, worker_id TEXT NOT NULL, iteration INTEGER NOT NULL, timestamp TEXT NOT NULL DEFAULT (datetime('now')), event_type TEXT NOT NULL CHECK(event_type IN ('tool_call', 'tool_result', 'text', 'error', 'system')), tool_name TEXT, tool_input TEXT, tool_output_preview TEXT, file_path TEXT, duration_ms INTEGER )U./sindexidx_tasks_sessiontasks-CREATE INDEX idx_tasks_session ON tasks(session_id)R--oindexidx_tasks_threadtasks,CREATE INDEX idx_tasks_thread ON tasks(thread_id)),=indexsqlite_autoindex_tasks_1tasks+�m+�9tabletaskstasks*CREATE TABLE tasks ( id TEXT NOT NULL, session_id TEXT NOT NULL, thread_id TEXT REFERENCES threads(id) ON DELETE SET NULL, subject TEXT NOT NULL, description TEXT, active_form TEXT, status TEXT NOT NULL DEFAULT 'pending', blocks TEXT, blocked_by TEXT, created_at TEXT DEFAULT (datetime('now')), updated_at TEXT DEFAULT (datetime('now')), PRIMARY KEY (session_id, id) )�*))�eviewcurrent_threadcurrent_threadCREATE VIEW current_thread AS SELECT * FROM threads WHERE status = 'active' ORDER BY updated_at DESC LIMIT 1�&)''�viewrecent_crumbsrecent_crumbsCREATE VIEW recent_crumbs AS SELECT b.*, p.description as plan_description, s.description as step_description FROM breadcrumbs b LEFT JOIN plans p ON b.plan_id = p.id LEFT JOIN plan_steps s ON b.step_id = s.id ORDER BY b.created_at DESC LIMIT 10�S(''�iviewpending_stepspending_stepsCREATE VIEW pending_steps AS SELECT s.*, p.description as plan_description FROM plan_steps s JOIN plans p ON s.plan_id = p.id WHERE s.status = 'pending' ORDER BY s.step_order�'##� viewactive_planactive_planCREATE VIEW active_plan AS SELECT * FROM plans WHERE status IN ('accepted', 'in_progress') ORDER BY created_at DESC LIMIT 1Wd^�彔M����ˤSQLite format 3@ 0".zp�/�� - � � �  g` ��)Jx�h�77/Cindexsqlite_autoindex_next_ups_1next_ups�\##�tablebug_reportsbug_reportsCREATE TABLE bug_reports ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), title TEXT NOT NULL, repro_steps TEXT NOT NULL, evidence TEXT, status TEXT DEFAULT 'open' CHECK(status IN ('open', 'resolved', 'wontfix')) )5I#indexsqlite_autoindex_bug_reports_1bug_reports�##�ktablecorrectionscorrectionsCREATE TABLE corrections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), mistake TEXT NOT NULL, symptoms TEXT, resolution TEXT, tags TEXT )5I#indexsqlite_autoindex_corrections_1corrections�+##�tablereflectionsreflectionsCREATE TABLE reflections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), trigger TEXT CHECK(trigger IN ('manual', 'compact', 'completion', 'stop')), content TEXT NOT NULL )5I#indexsqlite_autoindex_reflections_1reflections�w ##�5tablebreadcrumbsbreadcrumbsCREATE TABLE breadcrumbs ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_id TEXT REFERENCES plan_steps(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), agent_type TEXT, summary TEXT NOT NULL, files_touched TEXT, issues TEXT, next_context TEXT )5I#indexsqlite_autoindex_breadcrumbs_1breadcrumbs�v !!�7tableplan_stepsplan_steps CREATE TABLE plan_steps ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_order INTEGER NOT NULL, description TEXT NOT NULL, status TEXT DEFAULT 'pending' CHECK(status IN ('pending', 'in_progress', 'completed', 'failed', 'skipped')), created_at TEXT DEFAULT (datetime('now')) )3 G!indexsqlite_autoindex_plan_steps_1plan_steps �V � tableplansplans CREATE TABLE plans ( id TEXT PRIMARY KEY, created_at TEXT DEFAULT (datetime('now')), status TEXT DEFAULT 'accepted' CHECK(status IN ('accepted', 'in_progress', 'completed', 'abandoned')), description TEXT, plan_markdown TEXT NOT NULL, session_id TEXT, thread_id TEXT REFERENCES threads(id) )) =indexsqlite_autoindex_plans_1plans �++�Ctablethread_sessionsthread_sessionsCREATE TABLE thread_sessions ( thread_id TEXT NOT NULL REFERENCES threads(id) ON DELETE CASCADE, session_id TEXT NOT NULL, created_at TEXT DEFAULT (datetime('now')), PRIMARY KEY (thread_id, session_id) )=Q+indexsqlite_autoindex_thread_sessions_1thread_sessions Q-iindexidx_threads_namethreadsCREATE INDEX idx_threads_name ON threads(name)W1qindexidx_threads_statusthreadsCREATE INDEX idx_threads_status ON threads(status)c3�indexidx_threads_updatedthreadsCREATE INDEX idx_threads_updated ON threads(updated_at DESC)�,�/tablethreadsthreadsCREATE TABLE threads ( id TEXT PRIMARY KEY, name TEXT NOT NULL UNIQUE, created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), current_plan_id TEXT REFERENCES plans(id), git_branches TEXT, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'paused', 'completed', 'archived')) )-Aindexsqlite_autoindex_threads_2threads-Aindexsqlite_autoindex_threads_1thread&/Wd^�彔M:�n��H�3 �^� _ � � � Z �~0='�%indexidx_worker_events_workerworker_events0CREATE INDEX idx_worker_events_worker ON worker_events(worker_id, iteration)�o/''�tableworker_eventsworker_events.CREATE TABLE worker_events ( id INTEGER PRIMARY KEY AUTOINCREMENT, worker_id TEXT NOT NULL, iteration INTEGER NOT NULL, timestamp TEXT NOT NULL DEFAULT (datetime('now')), event_type TEXT NOT NULL CHECK(event_type IN ('tool_call', 'tool_result', 'text', 'error', 'system')), tool_name TEXT, tool_input TEXT, tool_output_preview TEXT, file_path TEXT, duration_ms INTEGER )U./sindexidx_tasks_sessiontasks-CREATE INDEX idx_tasks_session ON tasks(session_id)R--oindexidx_tasks_threadtasks,CREATE INDEX idx_tasks_thread ON tasks(thread_id)),=indexsqlite_autoindex_tasks_1tasks+�m+�9tabletaskstasks*CREATE TABLE tasks ( id TEXT NOT NULL, session_id TEXT NOT NULL, thread_id TEXT REFERENCES threads(id) ON DELETE SET NULL, subject TEXT NOT NULL, description TEXT, active_form TEXT, status TEXT NOT NULL DEFAULT 'pending', blocks TEXT, blocked_by TEXT, created_at TEXT DEFAULT (datetime('now')), updated_at TEXT DEFAULT (datetime('now')), PRIMARY KEY (session_id, id) )�*))�eviewcurrent_threadcurrent_threadCREATE VIEW current_thread AS SELECT * FROM threads WHERE status = 'active' ORDER BY updated_at DESC LIMIT 1�&)''�viewrecent_crumbsrecent_crumbsCREATE VIEW recent_crumbs AS SELECT b.*, p.description as plan_description, s.description as step_description FROM breadcrumbs b LEFT JOIN plans p ON b.plan_id = p.id LEFT JOIN plan_steps s ON b.step_id = s.id ORDER BY b.created_at DESC LIMIT 10�S(''�iviewpending_stepspending_stepsCREATE VIEW pending_steps AS SELECT s.*, p.description as plan_description FROM plan_steps s JOIN plans p ON s.plan_id = p.id WHERE s.status = 'pending' ORDER BY s.step_order�'##� viewactive_planactive_planCREATE VIEW active_plan AS SELECT * FROM plans WHERE status IN ('accepted', 'in_progress') ORDER BY created_at DESC LIMIT 100Wd^�彔M5�m�+U Wd^�彔M�F\���>�SQLite format 3@ 1#.zp�/�� - � � �  g` ��)Jx�h�77/Cindexsqlite_autoindex_next_ups_1next_ups�\##�tablebug_reportsbug_reportsCREATE TABLE bug_reports ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), title TEXT NOT NULL, repro_steps TEXT NOT NULL, evidence TEXT, status TEXT DEFAULT 'open' CHECK(status IN ('open', 'resolved', 'wontfix')) )5I#indexsqlite_autoindex_bug_reports_1bug_reports�##�ktablecorrectionscorrectionsCREATE TABLE corrections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), mistake TEXT NOT NULL, symptoms TEXT, resolution TEXT, tags TEXT )5I#indexsqlite_autoindex_corrections_1corrections�+##�tablereflectionsreflectionsCREATE TABLE reflections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), trigger TEXT CHECK(trigger IN ('manual', 'compact', 'completion', 'stop')), content TEXT NOT NULL )5I#indexsqlite_autoindex_reflections_1reflections�w ##�5tablebreadcrumbsbreadcrumbsCREATE TABLE breadcrumbs ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_id TEXT REFERENCES plan_steps(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), agent_type TEXT, summary TEXT NOT NULL, files_touched TEXT, issues TEXT, next_context TEXT )5I#indexsqlite_autoindex_breadcrumbs_1breadcrumbs�v !!�7tableplan_stepsplan_steps CREATE TABLE plan_steps ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_order INTEGER NOT NULL, description TEXT NOT NULL, status TEXT DEFAULT 'pending' CHECK(status IN ('pending', 'in_progress', 'completed', 'failed', 'skipped')), created_at TEXT DEFAULT (datetime('now')) )3 G!indexsqlite_autoindex_plan_steps_1plan_steps �V � tableplansplans CREATE TABLE plans ( id TEXT PRIMARY KEY, created_at TEXT DEFAULT (datetime('now')), status TEXT DEFAULT 'accepted' CHECK(status IN ('accepted', 'in_progress', 'completed', 'abandoned')), description TEXT, plan_markdown TEXT NOT NULL, session_id TEXT, thread_id TEXT REFERENCES threads(id) )) =indexsqlite_autoindex_plans_1plans �++�Ctablethread_sessionsthread_sessionsCREATE TABLE thread_sessions ( thread_id TEXT NOT NULL REFERENCES threads(id) ON DELETE CASCADE, session_id TEXT NOT NULL, created_at TEXT DEFAULT (datetime('now')), PRIMARY KEY (thread_id, session_id) )=Q+indexsqlite_autoindex_thread_sessions_1thread_sessions Q-iindexidx_threads_namethreadsCREATE INDEX idx_threads_name ON threads(name)W1qindexidx_threads_statusthreadsCREATE INDEX idx_threads_status ON threads(status)c3�indexidx_threads_updatedthreadsCREATE INDEX idx_threads_updated ON threads(updated_at DESC)�,�/tablethreadsthreadsCREATE TABLE threads ( id TEXT PRIMARY KEY, name TEXT NOT NULL UNIQUE, created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), current_plan_id TEXT REFERENCES plans(id), git_branches TEXT, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'paused', 'completed', 'archived')) )-Aindexsqlite_autoindex_threads_2threads-Aindexsqlite_autoindex_threads_1thread&/Wd^�彔M�u.�G�� ^� _ � � � Z �� 19'�Cindexidx_worker_events_fileworker_events1CREATE INDEX idx_worker_events_file ON worker_events(file_path) WHERE file_path IS NOT NULL~0='�%indexidx_worker_events_workerworker_events0CREATE INDEX idx_worker_events_worker ON worker_events(worker_id, iteration)�o/''�tableworker_eventsworker_events.CREATE TABLE worker_events ( id INTEGER PRIMARY KEY AUTOINCREMENT, worker_id TEXT NOT NULL, iteration INTEGER NOT NULL, timestamp TEXT NOT NULL DEFAULT (datetime('now')), event_type TEXT NOT NULL CHECK(event_type IN ('tool_call', 'tool_result', 'text', 'error', 'system')), tool_name TEXT, tool_input TEXT, tool_output_preview TEXT, file_path TEXT, duration_ms INTEGER )U./sindexidx_tasks_sessiontasks-CREATE INDEX idx_tasks_session ON tasks(session_id)R--oindexidx_tasks_threadtasks,CREATE INDEX idx_tasks_thread ON tasks(thread_id)),=indexsqlite_autoindex_tasks_1tasks+�m+�9tabletaskstasks*CREATE TABLE tasks ( id TEXT NOT NULL, session_id TEXT NOT NULL, thread_id TEXT REFERENCES threads(id) ON DELETE SET NULL, subject TEXT NOT NULL, description TEXT, active_form TEXT, status TEXT NOT NULL DEFAULT 'pending', blocks TEXT, blocked_by TEXT, created_at TEXT DEFAULT (datetime('now')), updated_at TEXT DEFAULT (datetime('now')), PRIMARY KEY (session_id, id) )�*))�eviewcurrent_threadcurrent_threadCREATE VIEW current_thread AS SELECT * FROM threads WHERE status = 'active' ORDER BY updated_at DESC LIMIT 1�&)''�viewrecent_crumbsrecent_crumbsCREATE VIEW recent_crumbs AS SELECT b.*, p.description as plan_description, s.description as step_description FROM breadcrumbs b LEFT JOIN plans p ON b.plan_id = p.id LEFT JOIN plan_steps s ON b.step_id = s.id ORDER BY b.created_at DESC LIMIT 10�S(''�iviewpending_stepspending_stepsCREATE VIEW pending_steps AS SELECT s.*, p.description as plan_description FROM plan_steps s JOIN plans p ON s.plan_id = p.id WHERE s.status = 'pending' ORDER BY s.step_order�'##� viewactive_planactive_planCREATE VIEW active_plan AS SELECT * FROM plans WHERE status IN ('accepted', 'in_progress') ORDER BY created_at DESC LIMIT 111Wd^�彔M4#���x�9 Wd^�彔M�`v��cSQLite format 3@ 2$.zp�/�� - � � �  g` ��)Jx�h�77/Cindexsqlite_autoindex_next_ups_1next_ups�\##�tablebug_reportsbug_reportsCREATE TABLE bug_reports ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), title TEXT NOT NULL, repro_steps TEXT NOT NULL, evidence TEXT, status TEXT DEFAULT 'open' CHECK(status IN ('open', 'resolved', 'wontfix')) )5I#indexsqlite_autoindex_bug_reports_1bug_reports�##�ktablecorrectionscorrectionsCREATE TABLE corrections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), mistake TEXT NOT NULL, symptoms TEXT, resolution TEXT, tags TEXT )5I#indexsqlite_autoindex_corrections_1corrections�+##�tablereflectionsreflectionsCREATE TABLE reflections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), trigger TEXT CHECK(trigger IN ('manual', 'compact', 'completion', 'stop')), content TEXT NOT NULL )5I#indexsqlite_autoindex_reflections_1reflections�w ##�5tablebreadcrumbsbreadcrumbsCREATE TABLE breadcrumbs ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_id TEXT REFERENCES plan_steps(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), agent_type TEXT, summary TEXT NOT NULL, files_touched TEXT, issues TEXT, next_context TEXT )5I#indexsqlite_autoindex_breadcrumbs_1breadcrumbs�v !!�7tableplan_stepsplan_steps CREATE TABLE plan_steps ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_order INTEGER NOT NULL, description TEXT NOT NULL, status TEXT DEFAULT 'pending' CHECK(status IN ('pending', 'in_progress', 'completed', 'failed', 'skipped')), created_at TEXT DEFAULT (datetime('now')) )3 G!indexsqlite_autoindex_plan_steps_1plan_steps �V � tableplansplans CREATE TABLE plans ( id TEXT PRIMARY KEY, created_at TEXT DEFAULT (datetime('now')), status TEXT DEFAULT 'accepted' CHECK(status IN ('accepted', 'in_progress', 'completed', 'abandoned')), description TEXT, plan_markdown TEXT NOT NULL, session_id TEXT, thread_id TEXT REFERENCES threads(id) )) =indexsqlite_autoindex_plans_1plans �++�Ctablethread_sessionsthread_sessionsCREATE TABLE thread_sessions ( thread_id TEXT NOT NULL REFERENCES threads(id) ON DELETE CASCADE, session_id TEXT NOT NULL, created_at TEXT DEFAULT (datetime('now')), PRIMARY KEY (thread_id, session_id) )=Q+indexsqlite_autoindex_thread_sessions_1thread_sessions Q-iindexidx_threads_namethreadsCREATE INDEX idx_threads_name ON threads(name)W1qindexidx_threads_statusthreadsCREATE INDEX idx_threads_status ON threads(status)c3�indexidx_threads_updatedthreadsCREATE INDEX idx_threads_updated ON threads(updated_at DESC)�,�/tablethreadsthreadsCREATE TABLE threads ( id TEXT PRIMARY KEY, name TEXT NOT NULL UNIQUE, created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), current_plan_id TEXT REFERENCES plans(id), git_branches TEXT, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'paused', 'completed', 'archived')) )-Aindexsqlite_autoindex_threads_2threads-Aindexsqlite_autoindex_threads_1thread&/Wd^�彔M""�۰�̤ u^� _ � � � Z �u� 29'�Cindexidx_worker_events_toolworker_events2CREATE INDEX idx_worker_events_tool ON worker_events(tool_name) WHERE tool_name IS NOT NULL� 19'�Cindexidx_worker_events_fileworker_events1CREATE INDEX idx_worker_events_file ON worker_events(file_path) WHERE file_path IS NOT NULL~0='�%indexidx_worker_events_workerworker_events0CREATE INDEX idx_worker_events_worker ON worker_events(worker_id, iteration)�o/''�tableworker_eventsworker_events.CREATE TABLE worker_events ( id INTEGER PRIMARY KEY AUTOINCREMENT, worker_id TEXT NOT NULL, iteration INTEGER NOT NULL, timestamp TEXT NOT NULL DEFAULT (datetime('now')), event_type TEXT NOT NULL CHECK(event_type IN ('tool_call', 'tool_result', 'text', 'error', 'system')), tool_name TEXT, tool_input TEXT, tool_output_preview TEXT, file_path TEXT, duration_ms INTEGER )U./sindexidx_tasks_sessiontasks-CREATE INDEX idx_tasks_session ON tasks(session_id)R--oindexidx_tasks_threadtasks,CREATE INDEX idx_tasks_thread ON tasks(thread_id)),=indexsqlite_autoindex_tasks_1tasks+�m+�9tabletaskstasks*CREATE TABLE tasks ( id TEXT NOT NULL, session_id TEXT NOT NULL, thread_id TEXT REFERENCES threads(id) ON DELETE SET NULL, subject TEXT NOT NULL, description TEXT, active_form TEXT, status TEXT NOT NULL DEFAULT 'pending', blocks TEXT, blocked_by TEXT, created_at TEXT DEFAULT (datetime('now')), updated_at TEXT DEFAULT (datetime('now')), PRIMARY KEY (session_id, id) )�*))�eviewcurrent_threadcurrent_threadCREATE VIEW current_thread AS SELECT * FROM threads WHERE status = 'active' ORDER BY updated_at DESC LIMIT 1�&)''�viewrecent_crumbsrecent_crumbsCREATE VIEW recent_crumbs AS SELECT b.*, p.description as plan_description, s.description as step_description FROM breadcrumbs b LEFT JOIN plans p ON b.plan_id = p.id LEFT JOIN plan_steps s ON b.step_id = s.id ORDER BY b.created_at DESC LIMIT 10�S(''�iviewpending_stepspending_stepsCREATE VIEW pending_steps AS SELECT s.*, p.description as plan_description FROM plan_steps s JOIN plans p ON s.plan_id = p.id WHERE s.status = 'pending' ORDER BY s.step_order�'##� viewactive_planactive_planCREATE VIEW active_plan AS SELECT * FROM plans WHERE status IN ('accepted', 'in_progress') ORDER BY created_at DESC LIMIT 122Wd^�彔M��O��q� Wd^�彔M�0m�$`�SQLite format 3@ 5%.zp�/�� - � � �  g` ��)Jx�h�77/Cindexsqlite_autoindex_next_ups_1next_ups�\##�tablebug_reportsbug_reportsCREATE TABLE bug_reports ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), title TEXT NOT NULL, repro_steps TEXT NOT NULL, evidence TEXT, status TEXT DEFAULT 'open' CHECK(status IN ('open', 'resolved', 'wontfix')) )5I#indexsqlite_autoindex_bug_reports_1bug_reports�##�ktablecorrectionscorrectionsCREATE TABLE corrections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), mistake TEXT NOT NULL, symptoms TEXT, resolution TEXT, tags TEXT )5I#indexsqlite_autoindex_corrections_1corrections�+##�tablereflectionsreflectionsCREATE TABLE reflections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), trigger TEXT CHECK(trigger IN ('manual', 'compact', 'completion', 'stop')), content TEXT NOT NULL )5I#indexsqlite_autoindex_reflections_1reflections�w ##�5tablebreadcrumbsbreadcrumbsCREATE TABLE breadcrumbs ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_id TEXT REFERENCES plan_steps(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), agent_type TEXT, summary TEXT NOT NULL, files_touched TEXT, issues TEXT, next_context TEXT )5I#indexsqlite_autoindex_breadcrumbs_1breadcrumbs�v !!�7tableplan_stepsplan_steps CREATE TABLE plan_steps ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_order INTEGER NOT NULL, description TEXT NOT NULL, status TEXT DEFAULT 'pending' CHECK(status IN ('pending', 'in_progress', 'completed', 'failed', 'skipped')), created_at TEXT DEFAULT (datetime('now')) )3 G!indexsqlite_autoindex_plan_steps_1plan_steps �V � tableplansplans CREATE TABLE plans ( id TEXT PRIMARY KEY, created_at TEXT DEFAULT (datetime('now')), status TEXT DEFAULT 'accepted' CHECK(status IN ('accepted', 'in_progress', 'completed', 'abandoned')), description TEXT, plan_markdown TEXT NOT NULL, session_id TEXT, thread_id TEXT REFERENCES threads(id) )) =indexsqlite_autoindex_plans_1plans �++�Ctablethread_sessionsthread_sessionsCREATE TABLE thread_sessions ( thread_id TEXT NOT NULL REFERENCES threads(id) ON DELETE CASCADE, session_id TEXT NOT NULL, created_at TEXT DEFAULT (datetime('now')), PRIMARY KEY (thread_id, session_id) )=Q+indexsqlite_autoindex_thread_sessions_1thread_sessions Q-iindexidx_threads_namethreadsCREATE INDEX idx_threads_name ON threads(name)W1qindexidx_threads_statusthreadsCREATE INDEX idx_threads_status ON threads(status)c3�indexidx_threads_updatedthreadsCREATE INDEX idx_threads_updated ON threads(updated_at DESC)�,�/tablethreadsthreadsCREATE TABLE threads ( id TEXT PRIMARY KEY, name TEXT NOT NULL UNIQUE, created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), current_plan_id TEXT REFERENCES plans(id), git_branches TEXT, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'paused', 'completed', 'archived')) )-Aindexsqlite_autoindex_threads_2threads-Aindexsqlite_autoindex_threads_1thread&/Wd^�彔M��5�ؔ] m:^� _ � � � Z �u:@�V3�tabledronesdrones3CREATE TABLE drones ( id TEXT PRIMARY KEY, name TEXT NOT NULL UNIQUE, prompt TEXT NOT NULL, max_iterations INTEGER DEFAULT 100, timeout_minutes INTEGER DEFAULT 60, cooldown_seconds INTEGER DEFAULT 60, status TEXT DEFAULT 'active' CHECK(status IN ('active', 'paused', 'archived')), created_at TEXT DEFAULT (datetime('now')), updated_at TEXT DEFAULT (datetime('now')) )+5?indexsqlite_autoindex_drones_2drones5+4?indexsqlite_autoindex_drones_1drones4� 29'�Cindexidx_worker_events_toolworker_events2CREATE INDEX idx_worker_events_tool ON worker_events(tool_name) WHERE tool_name IS NOT NULL� 19'�Cindexidx_worker_events_fileworker_events1CREATE INDEX idx_worker_events_file ON worker_events(file_path) WHERE file_path IS NOT NULL~0='�%indexidx_worker_events_workerworker_events0CREATE INDEX idx_worker_events_worker ON worker_events(worker_id, iteration)�o/''�tableworker_eventsworker_events.CREATE TABLE worker_events ( id INTEGER PRIMARY KEY AUTOINCREMENT, worker_id TEXT NOT NULL, iteration INTEGER NOT NULL, timestamp TEXT NOT NULL DEFAULT (datetime('now')), event_type TEXT NOT NULL CHECK(event_type IN ('tool_call', 'tool_result', 'text', 'error', 'system')), tool_name TEXT, tool_input TEXT, tool_output_preview TEXT, file_path TEXT, duration_ms INTEGER )U./sindexidx_tasks_sessiontasks-CREATE INDEX idx_tasks_session ON tasks(session_id)R--oindexidx_tasks_threadtasks,CREATE INDEX idx_tasks_thread ON tasks(thread_id)),=indexsqlite_autoindex_tasks_1tasks+�m+�9tabletaskstasks*CREATE TABLE tasks ( id TEXT NOT NULL, session_id TEXT NOT NULL, thread_id TEXT REFERENCES threads(id) ON DELETE SET NULL, subject TEXT NOT NULL, description TEXT, active_form TEXT, status TEXT NOT NULL DEFAULT 'pending', blocks TEXT, blocked_by TEXT, created_at TEXT DEFAULT (datetime('now')), updated_at TEXT DEFAULT (datetime('now')), PRIMARY KEY (session_id, id) )�*))�eviewcurrent_threadcurrent_threadCREATE VIEW current_thread AS SELECT * FROM threads WHERE status = 'active' ORDER BY updated_at DESC LIMIT 1�&)''�viewrecent_crumbsrecent_crumbsCREATE VIEW recent_crumbs AS SELECT b.*, p.description as plan_description, s.description as step_description FROM breadcrumbs b LEFT JOIN plans p ON b.plan_id = p.id LEFT JOIN plan_steps s ON b.step_id = s.id ORDER BY b.created_at DESC LIMIT 10�S(''�iviewpending_stepspending_stepsCREATE VIEW pending_steps AS SELECT s.*, p.description as plan_description FROM plan_steps s JOIN plans p ON s.plan_id = p.id WHERE s.status = 'pending' ORDER BY s.step_order�'##� viewactive_planactive_planCREATE VIEW active_plan AS SELECT * FROM plans WHERE status IN ('accepted', 'in_progress') ORDER BY created_at DESC LIMIT 13Wd^�彔M21� qr 4Wd^�彔M�yV_���P 55Wd^�彔M��i3>� Wd^�彔M����}���SQLite format 3@ 6&.zp�/�� - � � �  g` ��)Jx�h�77/Cindexsqlite_autoindex_next_ups_1next_ups�\##�tablebug_reportsbug_reportsCREATE TABLE bug_reports ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), title TEXT NOT NULL, repro_steps TEXT NOT NULL, evidence TEXT, status TEXT DEFAULT 'open' CHECK(status IN ('open', 'resolved', 'wontfix')) )5I#indexsqlite_autoindex_bug_reports_1bug_reports�##�ktablecorrectionscorrectionsCREATE TABLE corrections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), mistake TEXT NOT NULL, symptoms TEXT, resolution TEXT, tags TEXT )5I#indexsqlite_autoindex_corrections_1corrections�+##�tablereflectionsreflectionsCREATE TABLE reflections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), trigger TEXT CHECK(trigger IN ('manual', 'compact', 'completion', 'stop')), content TEXT NOT NULL )5I#indexsqlite_autoindex_reflections_1reflections�w ##�5tablebreadcrumbsbreadcrumbsCREATE TABLE breadcrumbs ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_id TEXT REFERENCES plan_steps(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), agent_type TEXT, summary TEXT NOT NULL, files_touched TEXT, issues TEXT, next_context TEXT )5I#indexsqlite_autoindex_breadcrumbs_1breadcrumbs�v !!�7tableplan_stepsplan_steps CREATE TABLE plan_steps ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_order INTEGER NOT NULL, description TEXT NOT NULL, status TEXT DEFAULT 'pending' CHECK(status IN ('pending', 'in_progress', 'completed', 'failed', 'skipped')), created_at TEXT DEFAULT (datetime('now')) )3 G!indexsqlite_autoindex_plan_steps_1plan_steps �V � tableplansplans CREATE TABLE plans ( id TEXT PRIMARY KEY, created_at TEXT DEFAULT (datetime('now')), status TEXT DEFAULT 'accepted' CHECK(status IN ('accepted', 'in_progress', 'completed', 'abandoned')), description TEXT, plan_markdown TEXT NOT NULL, session_id TEXT, thread_id TEXT REFERENCES threads(id) )) =indexsqlite_autoindex_plans_1plans �++�Ctablethread_sessionsthread_sessionsCREATE TABLE thread_sessions ( thread_id TEXT NOT NULL REFERENCES threads(id) ON DELETE CASCADE, session_id TEXT NOT NULL, created_at TEXT DEFAULT (datetime('now')), PRIMARY KEY (thread_id, session_id) )=Q+indexsqlite_autoindex_thread_sessions_1thread_sessions Q-iindexidx_threads_namethreadsCREATE INDEX idx_threads_name ON threads(name)W1qindexidx_threads_statusthreadsCREATE INDEX idx_threads_status ON threads(status)c3�indexidx_threads_updatedthreadsCREATE INDEX idx_threads_updated ON threads(updated_at DESC)�,�/tablethreadsthreadsCREATE TABLE threads ( id TEXT PRIMARY KEY, name TEXT NOT NULL UNIQUE, created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), current_plan_id TEXT REFERENCES plans(id), git_branches TEXT, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'paused', 'completed', 'archived')) )-Aindexsqlite_autoindex_threads_2threads-Aindexsqlite_autoindex_threads_1thread&/Wd^�彔M���j �  m�^� _ � � � Z �u:@�S6/mindexidx_drones_statusdrones6CREATE INDEX idx_drones_status ON drones(status)�V3�tabledronesdrones3CREATE TABLE drones ( id TEXT PRIMARY KEY, name TEXT NOT NULL UNIQUE, prompt TEXT NOT NULL, max_iterations INTEGER DEFAULT 100, timeout_minutes INTEGER DEFAULT 60, cooldown_seconds INTEGER DEFAULT 60, status TEXT DEFAULT 'active' CHECK(status IN ('active', 'paused', 'archived')), created_at TEXT DEFAULT (datetime('now')), updated_at TEXT DEFAULT (datetime('now')) )+5?indexsqlite_autoindex_drones_2drones5+4?indexsqlite_autoindex_drones_1drones4� 29'�Cindexidx_worker_events_toolworker_events2CREATE INDEX idx_worker_events_tool ON worker_events(tool_name) WHERE tool_name IS NOT NULL� 19'�Cindexidx_worker_events_fileworker_events1CREATE INDEX idx_worker_events_file ON worker_events(file_path) WHERE file_path IS NOT NULL~0='�%indexidx_worker_events_workerworker_events0CREATE INDEX idx_worker_events_worker ON worker_events(worker_id, iteration)�o/''�tableworker_eventsworker_events.CREATE TABLE worker_events ( id INTEGER PRIMARY KEY AUTOINCREMENT, worker_id TEXT NOT NULL, iteration INTEGER NOT NULL, timestamp TEXT NOT NULL DEFAULT (datetime('now')), event_type TEXT NOT NULL CHECK(event_type IN ('tool_call', 'tool_result', 'text', 'error', 'system')), tool_name TEXT, tool_input TEXT, tool_output_preview TEXT, file_path TEXT, duration_ms INTEGER )U./sindexidx_tasks_sessiontasks-CREATE INDEX idx_tasks_session ON tasks(session_id)R--oindexidx_tasks_threadtasks,CREATE INDEX idx_tasks_thread ON tasks(thread_id)),=indexsqlite_autoindex_tasks_1tasks+�m+�9tabletaskstasks*CREATE TABLE tasks ( id TEXT NOT NULL, session_id TEXT NOT NULL, thread_id TEXT REFERENCES threads(id) ON DELETE SET NULL, subject TEXT NOT NULL, description TEXT, active_form TEXT, status TEXT NOT NULL DEFAULT 'pending', blocks TEXT, blocked_by TEXT, created_at TEXT DEFAULT (datetime('now')), updated_at TEXT DEFAULT (datetime('now')), PRIMARY KEY (session_id, id) )�*))�eviewcurrent_threadcurrent_threadCREATE VIEW current_thread AS SELECT * FROM threads WHERE status = 'active' ORDER BY updated_at DESC LIMIT 1�&)''�viewrecent_crumbsrecent_crumbsCREATE VIEW recent_crumbs AS SELECT b.*, p.description as plan_description, s.description as step_description FROM breadcrumbs b LEFT JOIN plans p ON b.plan_id = p.id LEFT JOIN plan_steps s ON b.step_id = s.id ORDER BY b.created_at DESC LIMIT 10�S(''�iviewpending_stepspending_stepsCREATE VIEW pending_steps AS SELECT s.*, p.description as plan_description FROM plan_steps s JOIN plans p ON s.plan_id = p.id WHERE s.status = 'pending' ORDER BY s.step_order�'##� viewactive_planactive_planCREATE VIEW active_plan AS SELECT * FROM plans WHERE status IN ('accepted', 'in_progress') ORDER BY created_at DESC LIMIT 166Wd^�彔M���~,b� Wd^�彔M�Nv�M��SQLite format 3@ 7'.zp�/�� - � � �  g` ��)Jx�h�77/Cindexsqlite_autoindex_next_ups_1next_ups�\##�tablebug_reportsbug_reportsCREATE TABLE bug_reports ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), title TEXT NOT NULL, repro_steps TEXT NOT NULL, evidence TEXT, status TEXT DEFAULT 'open' CHECK(status IN ('open', 'resolved', 'wontfix')) )5I#indexsqlite_autoindex_bug_reports_1bug_reports�##�ktablecorrectionscorrectionsCREATE TABLE corrections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), mistake TEXT NOT NULL, symptoms TEXT, resolution TEXT, tags TEXT )5I#indexsqlite_autoindex_corrections_1corrections�+##�tablereflectionsreflectionsCREATE TABLE reflections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), trigger TEXT CHECK(trigger IN ('manual', 'compact', 'completion', 'stop')), content TEXT NOT NULL )5I#indexsqlite_autoindex_reflections_1reflections�w ##�5tablebreadcrumbsbreadcrumbsCREATE TABLE breadcrumbs ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_id TEXT REFERENCES plan_steps(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), agent_type TEXT, summary TEXT NOT NULL, files_touched TEXT, issues TEXT, next_context TEXT )5I#indexsqlite_autoindex_breadcrumbs_1breadcrumbs�v !!�7tableplan_stepsplan_steps CREATE TABLE plan_steps ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_order INTEGER NOT NULL, description TEXT NOT NULL, status TEXT DEFAULT 'pending' CHECK(status IN ('pending', 'in_progress', 'completed', 'failed', 'skipped')), created_at TEXT DEFAULT (datetime('now')) )3 G!indexsqlite_autoindex_plan_steps_1plan_steps �V � tableplansplans CREATE TABLE plans ( id TEXT PRIMARY KEY, created_at TEXT DEFAULT (datetime('now')), status TEXT DEFAULT 'accepted' CHECK(status IN ('accepted', 'in_progress', 'completed', 'abandoned')), description TEXT, plan_markdown TEXT NOT NULL, session_id TEXT, thread_id TEXT REFERENCES threads(id) )) =indexsqlite_autoindex_plans_1plans �++�Ctablethread_sessionsthread_sessionsCREATE TABLE thread_sessions ( thread_id TEXT NOT NULL REFERENCES threads(id) ON DELETE CASCADE, session_id TEXT NOT NULL, created_at TEXT DEFAULT (datetime('now')), PRIMARY KEY (thread_id, session_id) )=Q+indexsqlite_autoindex_thread_sessions_1thread_sessions Q-iindexidx_threads_namethreadsCREATE INDEX idx_threads_name ON threads(name)W1qindexidx_threads_statusthreadsCREATE INDEX idx_threads_status ON threads(status)c3�indexidx_threads_updatedthreadsCREATE INDEX idx_threads_updated ON threads(updated_at DESC)�,�/tablethreadsthreadsCREATE TABLE threads ( id TEXT PRIMARY KEY, name TEXT NOT NULL UNIQUE, created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), current_plan_id TEXT REFERENCES plans(id), git_branches TEXT, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'paused', 'completed', 'archived')) )-Aindexsqlite_autoindex_threads_2threads-Aindexsqlite_autoindex_threads_1thread&/Wd^�彔M>%X�$y�� m�^� _ � � � Z �u:@��M7+eindexidx_drones_namedrones7CREATE INDEX idx_drones_name ON drones(name)S6/mindexidx_drones_statusdrones6CREATE INDEX idx_drones_status ON drones(status)�V3�tabledronesdrones3CREATE TABLE drones ( id TEXT PRIMARY KEY, name TEXT NOT NULL UNIQUE, prompt TEXT NOT NULL, max_iterations INTEGER DEFAULT 100, timeout_minutes INTEGER DEFAULT 60, cooldown_seconds INTEGER DEFAULT 60, status TEXT DEFAULT 'active' CHECK(status IN ('active', 'paused', 'archived')), created_at TEXT DEFAULT (datetime('now')), updated_at TEXT DEFAULT (datetime('now')) )+5?indexsqlite_autoindex_drones_2drones5+4?indexsqlite_autoindex_drones_1drones4� 29'�Cindexidx_worker_events_toolworker_events2CREATE INDEX idx_worker_events_tool ON worker_events(tool_name) WHERE tool_name IS NOT NULL� 19'�Cindexidx_worker_events_fileworker_events1CREATE INDEX idx_worker_events_file ON worker_events(file_path) WHERE file_path IS NOT NULL~0='�%indexidx_worker_events_workerworker_events0CREATE INDEX idx_worker_events_worker ON worker_events(worker_id, iteration)�o/''�tableworker_eventsworker_events.CREATE TABLE worker_events ( id INTEGER PRIMARY KEY AUTOINCREMENT, worker_id TEXT NOT NULL, iteration INTEGER NOT NULL, timestamp TEXT NOT NULL DEFAULT (datetime('now')), event_type TEXT NOT NULL CHECK(event_type IN ('tool_call', 'tool_result', 'text', 'error', 'system')), tool_name TEXT, tool_input TEXT, tool_output_preview TEXT, file_path TEXT, duration_ms INTEGER )U./sindexidx_tasks_sessiontasks-CREATE INDEX idx_tasks_session ON tasks(session_id)R--oindexidx_tasks_threadtasks,CREATE INDEX idx_tasks_thread ON tasks(thread_id)),=indexsqlite_autoindex_tasks_1tasks+�m+�9tabletaskstasks*CREATE TABLE tasks ( id TEXT NOT NULL, session_id TEXT NOT NULL, thread_id TEXT REFERENCES threads(id) ON DELETE SET NULL, subject TEXT NOT NULL, description TEXT, active_form TEXT, status TEXT NOT NULL DEFAULT 'pending', blocks TEXT, blocked_by TEXT, created_at TEXT DEFAULT (datetime('now')), updated_at TEXT DEFAULT (datetime('now')), PRIMARY KEY (session_id, id) )�*))�eviewcurrent_threadcurrent_threadCREATE VIEW current_thread AS SELECT * FROM threads WHERE status = 'active' ORDER BY updated_at DESC LIMIT 1�&)''�viewrecent_crumbsrecent_crumbsCREATE VIEW recent_crumbs AS SELECT b.*, p.description as plan_description, s.description as step_description FROM breadcrumbs b LEFT JOIN plans p ON b.plan_id = p.id LEFT JOIN plan_steps s ON b.step_id = s.id ORDER BY b.created_at DESC LIMIT 10�S(''�iviewpending_stepspending_stepsCREATE VIEW pending_steps AS SELECT s.*, p.description as plan_description FROM plan_steps s JOIN plans p ON s.plan_id = p.id WHERE s.status = 'pending' ORDER BY s.step_order�'##� viewactive_planactive_planCREATE VIEW active_plan AS SELECT * FROM plans WHERE status IN ('accepted', 'in_progress') ORDER BY created_at DESC LIMIT 177Wd^�彔MR�ՁƈB� Wd^�彔M�ٵ,SQLite format 3@ 9(.zp�/�� - � � �  g` ��)Jx�h�77/Cindexsqlite_autoindex_next_ups_1next_ups�\##�tablebug_reportsbug_reportsCREATE TABLE bug_reports ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), title TEXT NOT NULL, repro_steps TEXT NOT NULL, evidence TEXT, status TEXT DEFAULT 'open' CHECK(status IN ('open', 'resolved', 'wontfix')) )5I#indexsqlite_autoindex_bug_reports_1bug_reports�##�ktablecorrectionscorrectionsCREATE TABLE corrections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), mistake TEXT NOT NULL, symptoms TEXT, resolution TEXT, tags TEXT )5I#indexsqlite_autoindex_corrections_1corrections�+##�tablereflectionsreflectionsCREATE TABLE reflections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), trigger TEXT CHECK(trigger IN ('manual', 'compact', 'completion', 'stop')), content TEXT NOT NULL )5I#indexsqlite_autoindex_reflections_1reflections�w ##�5tablebreadcrumbsbreadcrumbsCREATE TABLE breadcrumbs ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_id TEXT REFERENCES plan_steps(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), agent_type TEXT, summary TEXT NOT NULL, files_touched TEXT, issues TEXT, next_context TEXT )5I#indexsqlite_autoindex_breadcrumbs_1breadcrumbs�v !!�7tableplan_stepsplan_steps CREATE TABLE plan_steps ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_order INTEGER NOT NULL, description TEXT NOT NULL, status TEXT DEFAULT 'pending' CHECK(status IN ('pending', 'in_progress', 'completed', 'failed', 'skipped')), created_at TEXT DEFAULT (datetime('now')) )3 G!indexsqlite_autoindex_plan_steps_1plan_steps �V � tableplansplans CREATE TABLE plans ( id TEXT PRIMARY KEY, created_at TEXT DEFAULT (datetime('now')), status TEXT DEFAULT 'accepted' CHECK(status IN ('accepted', 'in_progress', 'completed', 'abandoned')), description TEXT, plan_markdown TEXT NOT NULL, session_id TEXT, thread_id TEXT REFERENCES threads(id) )) =indexsqlite_autoindex_plans_1plans �++�Ctablethread_sessionsthread_sessionsCREATE TABLE thread_sessions ( thread_id TEXT NOT NULL REFERENCES threads(id) ON DELETE CASCADE, session_id TEXT NOT NULL, created_at TEXT DEFAULT (datetime('now')), PRIMARY KEY (thread_id, session_id) )=Q+indexsqlite_autoindex_thread_sessions_1thread_sessions Q-iindexidx_threads_namethreadsCREATE INDEX idx_threads_name ON threads(name)W1qindexidx_threads_statusthreadsCREATE INDEX idx_threads_status ON threads(status)c3�indexidx_threads_updatedthreadsCREATE INDEX idx_threads_updated ON threads(updated_at DESC)�,�/tablethreadsthreadsCREATE TABLE threads ( id TEXT PRIMARY KEY, name TEXT NOT NULL UNIQUE, created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), current_plan_id TEXT REFERENCES plans(id), git_branches TEXT, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'paused', 'completed', 'archived')) )-Aindexsqlite_autoindex_threads_2threads-Aindexsqlite_autoindex_threads_1thread&/Wd^�彔M�LdY�Y4$ mm^� _ � � � Z �u:@��mY�i8))� tabledrone_sessionsdrone_sessions8CREATE TABLE drone_sessions ( id TEXT PRIMARY KEY, drone_id TEXT NOT NULL REFERENCES drones(id) ON DELETE CASCADE, worker_id TEXT REFERENCES workers(id), git_branch TEXT, status TEXT DEFAULT 'running' CHECK(status IN ('running', 'completed', 'stopped', 'failed')), iteration INTEGER DEFAULT 0, started_at TEXT DEFAULT (datetime('now')), ended_at TEXT, stop_reason TEXT );9O)indexsqlite_autoindex_drone_sessions_1drone_sessions9M7+eindexidx_drones_namedrones7CREATE INDEX idx_drones_name ON drones(name)S6/mindexidx_drones_statusdrones6CREATE INDEX idx_drones_status ON drones(status)�V3�tabledronesdrones3CREATE TABLE drones ( id TEXT PRIMARY KEY, name TEXT NOT NULL UNIQUE, prompt TEXT NOT NULL, max_iterations INTEGER DEFAULT 100, timeout_minutes INTEGER DEFAULT 60, cooldown_seconds INTEGER DEFAULT 60, status TEXT DEFAULT 'active' CHECK(status IN ('active', 'paused', 'archived')), created_at TEXT DEFAULT (datetime('now')), updated_at TEXT DEFAULT (datetime('now')) )+5?indexsqlite_autoindex_drones_2drones5+4?indexsqlite_autoindex_drones_1drones4� 29'�Cindexidx_worker_events_toolworker_events2CREATE INDEX idx_worker_events_tool ON worker_events(tool_name) WHERE tool_name IS NOT NULL� 19'�Cindexidx_worker_events_fileworker_events1CREATE INDEX idx_worker_events_file ON worker_events(file_path) WHERE file_path IS NOT NULL~0='�%indexidx_worker_events_workerworker_events0CREATE INDEX idx_worker_events_worker ON worker_events(worker_id, iteration)�o/''�tableworker_eventsworker_events.CREATE TABLE worker_events ( id INTEGER PRIMARY KEY AUTOINCREMENT, worker_id TEXT NOT NULL, iteration INTEGER NOT NULL, timestamp TEXT NOT NULL DEFAULT (datetime('now')), event_type TEXT NOT NULL CHECK(event_type IN ('tool_call', 'tool_result', 'text', 'error', 'system')), tool_name TEXT, tool_input TEXT, tool_output_preview TEXT, file_path TEXT, duration_ms INTEGER )U./sindexidx_tasks_sessiontasks-CREATE INDEX idx_tasks_session ON tasks(session_id)R--oindexidx_tasks_threadtasks,CREATE INDEX idx_tasks_thread ON tasks(thread_id)),=indexsqlite_autoindex_tasks_1tasks+�m+�9tabletaskstasks*CREATE TABLE tasks ( id TEXT NOT NULL, session_id TEXT NOT NULL, thread_id TEXT REFERENCES threads(id) ON DELETE SET NULL, subject TEXT NOT NULL, description TEXT, active_form TEXT, status TEXT NOT NULL DEFAULT 'pending', blocks TEXT, blocked_by TEXT, created_at TEXT DEFAULT (datetime('now')), updated_at TEXT DEFAULT (datetime('now')), PRIMARY KEY (session_id, id) )�*))�eviewcurrent_threadcurrent_threadCREATE VIEW current_thread AS SELECT * FROM threads WHERE status = 'active' ORDER BY updated_at DESC LIMIT 1�&)''�viewrecent_crumbsrecent_crumbsCREATE VIEW recent_crumbs AS SELECT b.*, p.description as plan_description, s.description as step_description FROM breadcrumbs b LEFT JOIN plans p ON b.plan_id = p.id LEFT JOIN plan_steps s ON b.step_id = s.id ORDER BY b.created_at DESC LIMIT 10�S(''�iviewpending_stepspending_stepsCREATE VIEW pending_steps AS SELECT s.*, p.description as plan_description FROM plan_steps s JOIN plans p ON s.plan_id = p.id WHERE s.status = 'pending' ORDER BY s.step_order�'##� viewactive_planactive_planCREATE VIEW active_plan AS SELECT * FROM plans WHERE status IN ('accepted', 'in_progress') ORDER BY created_at DESC LIMIT 18Wd^�彔M�rx�{[ 99Wd^�彔M k��A}} Wd^�彔M�6�㇘��SQLite format 3@ :).zp�/�� - � � �  g` ��)Jx�h�77/Cindexsqlite_autoindex_next_ups_1next_ups�\##�tablebug_reportsbug_reportsCREATE TABLE bug_reports ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), title TEXT NOT NULL, repro_steps TEXT NOT NULL, evidence TEXT, status TEXT DEFAULT 'open' CHECK(status IN ('open', 'resolved', 'wontfix')) )5I#indexsqlite_autoindex_bug_reports_1bug_reports�##�ktablecorrectionscorrectionsCREATE TABLE corrections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), mistake TEXT NOT NULL, symptoms TEXT, resolution TEXT, tags TEXT )5I#indexsqlite_autoindex_corrections_1corrections�+##�tablereflectionsreflectionsCREATE TABLE reflections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), trigger TEXT CHECK(trigger IN ('manual', 'compact', 'completion', 'stop')), content TEXT NOT NULL )5I#indexsqlite_autoindex_reflections_1reflections�w ##�5tablebreadcrumbsbreadcrumbsCREATE TABLE breadcrumbs ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_id TEXT REFERENCES plan_steps(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), agent_type TEXT, summary TEXT NOT NULL, files_touched TEXT, issues TEXT, next_context TEXT )5I#indexsqlite_autoindex_breadcrumbs_1breadcrumbs�v !!�7tableplan_stepsplan_steps CREATE TABLE plan_steps ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_order INTEGER NOT NULL, description TEXT NOT NULL, status TEXT DEFAULT 'pending' CHECK(status IN ('pending', 'in_progress', 'completed', 'failed', 'skipped')), created_at TEXT DEFAULT (datetime('now')) )3 G!indexsqlite_autoindex_plan_steps_1plan_steps �V � tableplansplans CREATE TABLE plans ( id TEXT PRIMARY KEY, created_at TEXT DEFAULT (datetime('now')), status TEXT DEFAULT 'accepted' CHECK(status IN ('accepted', 'in_progress', 'completed', 'abandoned')), description TEXT, plan_markdown TEXT NOT NULL, session_id TEXT, thread_id TEXT REFERENCES threads(id) )) =indexsqlite_autoindex_plans_1plans �++�Ctablethread_sessionsthread_sessionsCREATE TABLE thread_sessions ( thread_id TEXT NOT NULL REFERENCES threads(id) ON DELETE CASCADE, session_id TEXT NOT NULL, created_at TEXT DEFAULT (datetime('now')), PRIMARY KEY (thread_id, session_id) )=Q+indexsqlite_autoindex_thread_sessions_1thread_sessions Q-iindexidx_threads_namethreadsCREATE INDEX idx_threads_name ON threads(name)W1qindexidx_threads_statusthreadsCREATE INDEX idx_threads_status ON threads(status)c3�indexidx_threads_updatedthreadsCREATE INDEX idx_threads_updated ON threads(updated_at DESC)�,�/tablethreadsthreadsCREATE TABLE threads ( id TEXT PRIMARY KEY, name TEXT NOT NULL UNIQUE, created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), current_plan_id TEXT REFERENCES plans(id), git_branches TEXT, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'paused', 'completed', 'archived')) )-Aindexsqlite_autoindex_threads_2threads-Aindexsqlite_autoindex_threads_1thread&/Wd^�彔M.�`/���% m�^� _ � � � Z �u:@��mY��:=)�1indexidx_drone_sessions_dronedrone_sessions:CREATE INDEX idx_drone_sessions_drone ON drone_sessions(drone_id, started_at DESC)�i8))� tabledrone_sessionsdrone_sessions8CREATE TABLE drone_sessions ( id TEXT PRIMARY KEY, drone_id TEXT NOT NULL REFERENCES drones(id) ON DELETE CASCADE, worker_id TEXT REFERENCES workers(id), git_branch TEXT, status TEXT DEFAULT 'running' CHECK(status IN ('running', 'completed', 'stopped', 'failed')), iteration INTEGER DEFAULT 0, started_at TEXT DEFAULT (datetime('now')), ended_at TEXT, stop_reason TEXT );9O)indexsqlite_autoindex_drone_sessions_1drone_sessions9M7+eindexidx_drones_namedrones7CREATE INDEX idx_drones_name ON drones(name)S6/mindexidx_drones_statusdrones6CREATE INDEX idx_drones_status ON drones(status)�V3�tabledronesdrones3CREATE TABLE drones ( id TEXT PRIMARY KEY, name TEXT NOT NULL UNIQUE, prompt TEXT NOT NULL, max_iterations INTEGER DEFAULT 100, timeout_minutes INTEGER DEFAULT 60, cooldown_seconds INTEGER DEFAULT 60, status TEXT DEFAULT 'active' CHECK(status IN ('active', 'paused', 'archived')), created_at TEXT DEFAULT (datetime('now')), updated_at TEXT DEFAULT (datetime('now')) )+5?indexsqlite_autoindex_drones_2drones5+4?indexsqlite_autoindex_drones_1drones4� 29'�Cindexidx_worker_events_toolworker_events2CREATE INDEX idx_worker_events_tool ON worker_events(tool_name) WHERE tool_name IS NOT NULL� 19'�Cindexidx_worker_events_fileworker_events1CREATE INDEX idx_worker_events_file ON worker_events(file_path) WHERE file_path IS NOT NULL~0='�%indexidx_worker_events_workerworker_events0CREATE INDEX idx_worker_events_worker ON worker_events(worker_id, iteration)�o/''�tableworker_eventsworker_events.CREATE TABLE worker_events ( id INTEGER PRIMARY KEY AUTOINCREMENT, worker_id TEXT NOT NULL, iteration INTEGER NOT NULL, timestamp TEXT NOT NULL DEFAULT (datetime('now')), event_type TEXT NOT NULL CHECK(event_type IN ('tool_call', 'tool_result', 'text', 'error', 'system')), tool_name TEXT, tool_input TEXT, tool_output_preview TEXT, file_path TEXT, duration_ms INTEGER )U./sindexidx_tasks_sessiontasks-CREATE INDEX idx_tasks_session ON tasks(session_id)R--oindexidx_tasks_threadtasks,CREATE INDEX idx_tasks_thread ON tasks(thread_id)),=indexsqlite_autoindex_tasks_1tasks+�m+�9tabletaskstasks*CREATE TABLE tasks ( id TEXT NOT NULL, session_id TEXT NOT NULL, thread_id TEXT REFERENCES threads(id) ON DELETE SET NULL, subject TEXT NOT NULL, description TEXT, active_form TEXT, status TEXT NOT NULL DEFAULT 'pending', blocks TEXT, blocked_by TEXT, created_at TEXT DEFAULT (datetime('now')), updated_at TEXT DEFAULT (datetime('now')), PRIMARY KEY (session_id, id) )�*))�eviewcurrent_threadcurrent_threadCREATE VIEW current_thread AS SELECT * FROM threads WHERE status = 'active' ORDER BY updated_at DESC LIMIT 1�&)''�viewrecent_crumbsrecent_crumbsCREATE VIEW recent_crumbs AS SELECT b.*, p.description as plan_description, s.description as step_description FROM breadcrumbs b LEFT JOIN plans p ON b.plan_id = p.id LEFT JOIN plan_steps s ON b.step_id = s.id ORDER BY b.created_at DESC LIMIT 10�S(''�iviewpending_stepspending_stepsCREATE VIEW pending_steps AS SELECT s.*, p.description as plan_description FROM plan_steps s JOIN plans p ON s.plan_id = p.id WHERE s.status = 'pending' ORDER BY s.step_order�'##� viewactive_planactive_planCREATE VIEW active_plan AS SELECT * FROM plans WHERE status IN ('accepted', 'in_progress') ORDER BY created_at DESC LIMIT 1::Wd^�彔MṌߍI�_ Wd^�彔Mj[ ϋӪSQLite format 3@ ;*.zp�/�� - � � �  g` ��)Jx�h�77/Cindexsqlite_autoindex_next_ups_1next_ups�\##�tablebug_reportsbug_reportsCREATE TABLE bug_reports ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), title TEXT NOT NULL, repro_steps TEXT NOT NULL, evidence TEXT, status TEXT DEFAULT 'open' CHECK(status IN ('open', 'resolved', 'wontfix')) )5I#indexsqlite_autoindex_bug_reports_1bug_reports�##�ktablecorrectionscorrectionsCREATE TABLE corrections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), mistake TEXT NOT NULL, symptoms TEXT, resolution TEXT, tags TEXT )5I#indexsqlite_autoindex_corrections_1corrections�+##�tablereflectionsreflectionsCREATE TABLE reflections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), trigger TEXT CHECK(trigger IN ('manual', 'compact', 'completion', 'stop')), content TEXT NOT NULL )5I#indexsqlite_autoindex_reflections_1reflections�w ##�5tablebreadcrumbsbreadcrumbsCREATE TABLE breadcrumbs ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_id TEXT REFERENCES plan_steps(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), agent_type TEXT, summary TEXT NOT NULL, files_touched TEXT, issues TEXT, next_context TEXT )5I#indexsqlite_autoindex_breadcrumbs_1breadcrumbs�v !!�7tableplan_stepsplan_steps CREATE TABLE plan_steps ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_order INTEGER NOT NULL, description TEXT NOT NULL, status TEXT DEFAULT 'pending' CHECK(status IN ('pending', 'in_progress', 'completed', 'failed', 'skipped')), created_at TEXT DEFAULT (datetime('now')) )3 G!indexsqlite_autoindex_plan_steps_1plan_steps �V � tableplansplans CREATE TABLE plans ( id TEXT PRIMARY KEY, created_at TEXT DEFAULT (datetime('now')), status TEXT DEFAULT 'accepted' CHECK(status IN ('accepted', 'in_progress', 'completed', 'abandoned')), description TEXT, plan_markdown TEXT NOT NULL, session_id TEXT, thread_id TEXT REFERENCES threads(id) )) =indexsqlite_autoindex_plans_1plans �++�Ctablethread_sessionsthread_sessionsCREATE TABLE thread_sessions ( thread_id TEXT NOT NULL REFERENCES threads(id) ON DELETE CASCADE, session_id TEXT NOT NULL, created_at TEXT DEFAULT (datetime('now')), PRIMARY KEY (thread_id, session_id) )=Q+indexsqlite_autoindex_thread_sessions_1thread_sessions Q-iindexidx_threads_namethreadsCREATE INDEX idx_threads_name ON threads(name)W1qindexidx_threads_statusthreadsCREATE INDEX idx_threads_status ON threads(status)c3�indexidx_threads_updatedthreadsCREATE INDEX idx_threads_updated ON threads(updated_at DESC)�,�/tablethreadsthreadsCREATE TABLE threads ( id TEXT PRIMARY KEY, name TEXT NOT NULL UNIQUE, created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), current_plan_id TEXT REFERENCES plans(id), git_branches TEXT, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'paused', 'completed', 'archived')) )-Aindexsqlite_autoindex_threads_2threads-Aindexsqlite_autoindex_threads_1thread&/Wd^�彔M�&��?L;� mo^� _ � � � Z �u:@��mY�ot;?)� indexidx_drone_sessions_statusdrone_sessions;CREATE INDEX idx_drone_sessions_status ON drone_sessions(status)�:=)�1indexidx_drone_sessions_dronedrone_sessions:CREATE INDEX idx_drone_sessions_drone ON drone_sessions(drone_id, started_at DESC)�i8))� tabledrone_sessionsdrone_sessions8CREATE TABLE drone_sessions ( id TEXT PRIMARY KEY, drone_id TEXT NOT NULL REFERENCES drones(id) ON DELETE CASCADE, worker_id TEXT REFERENCES workers(id), git_branch TEXT, status TEXT DEFAULT 'running' CHECK(status IN ('running', 'completed', 'stopped', 'failed')), iteration INTEGER DEFAULT 0, started_at TEXT DEFAULT (datetime('now')), ended_at TEXT, stop_reason TEXT );9O)indexsqlite_autoindex_drone_sessions_1drone_sessions9M7+eindexidx_drones_namedrones7CREATE INDEX idx_drones_name ON drones(name)S6/mindexidx_drones_statusdrones6CREATE INDEX idx_drones_status ON drones(status)�V3�tabledronesdrones3CREATE TABLE drones ( id TEXT PRIMARY KEY, name TEXT NOT NULL UNIQUE, prompt TEXT NOT NULL, max_iterations INTEGER DEFAULT 100, timeout_minutes INTEGER DEFAULT 60, cooldown_seconds INTEGER DEFAULT 60, status TEXT DEFAULT 'active' CHECK(status IN ('active', 'paused', 'archived')), created_at TEXT DEFAULT (datetime('now')), updated_at TEXT DEFAULT (datetime('now')) )+5?indexsqlite_autoindex_drones_2drones5+4?indexsqlite_autoindex_drones_1drones4� 29'�Cindexidx_worker_events_toolworker_events2CREATE INDEX idx_worker_events_tool ON worker_events(tool_name) WHERE tool_name IS NOT NULL� 19'�Cindexidx_worker_events_fileworker_events1CREATE INDEX idx_worker_events_file ON worker_events(file_path) WHERE file_path IS NOT NULL~0='�%indexidx_worker_events_workerworker_events0CREATE INDEX idx_worker_events_worker ON worker_events(worker_id, iteration)�o/''�tableworker_eventsworker_events.CREATE TABLE worker_events ( id INTEGER PRIMARY KEY AUTOINCREMENT, worker_id TEXT NOT NULL, iteration INTEGER NOT NULL, timestamp TEXT NOT NULL DEFAULT (datetime('now')), event_type TEXT NOT NULL CHECK(event_type IN ('tool_call', 'tool_result', 'text', 'error', 'system')), tool_name TEXT, tool_input TEXT, tool_output_preview TEXT, file_path TEXT, duration_ms INTEGER )U./sindexidx_tasks_sessiontasks-CREATE INDEX idx_tasks_session ON tasks(session_id)R--oindexidx_tasks_threadtasks,CREATE INDEX idx_tasks_thread ON tasks(thread_id)),=indexsqlite_autoindex_tasks_1tasks+�m+�9tabletaskstasks*CREATE TABLE tasks ( id TEXT NOT NULL, session_id TEXT NOT NULL, thread_id TEXT REFERENCES threads(id) ON DELETE SET NULL, subject TEXT NOT NULL, description TEXT, active_form TEXT, status TEXT NOT NULL DEFAULT 'pending', blocks TEXT, blocked_by TEXT, created_at TEXT DEFAULT (datetime('now')), updated_at TEXT DEFAULT (datetime('now')), PRIMARY KEY (session_id, id) )�*))�eviewcurrent_threadcurrent_threadCREATE VIEW current_thread AS SELECT * FROM threads WHERE status = 'active' ORDER BY updated_at DESC LIMIT 1�&)''�viewrecent_crumbsrecent_crumbsCREATE VIEW recent_crumbs AS SELECT b.*, p.description as plan_description, s.description as step_description FROM breadcrumbs b LEFT JOIN plans p ON b.plan_id = p.id LEFT JOIN plan_steps s ON b.step_id = s.id ORDER BY b.created_at DESC LIMIT 10�S(''�iviewpending_stepspending_stepsCREATE VIEW pending_steps AS SELECT s.*, p.description as plan_description FROM plan_steps s JOIN plans p ON s.plan_id = p.id WHERE s.status = 'pending' ORDER BY s.step_order�'##� viewactive_planactive_planCREATE VIEW active_plan AS SELECT * FROM plans WHERE status IN ('accepted', 'in_progress') ORDER BY created_at DESC LIMIT 1;;Wd^�彔M�O~�q^� Wd^�彔M���FR&p�SQLite format 3@ =+.zp�/�� - � � �  g` ��)Jx�h�77/Cindexsqlite_autoindex_next_ups_1next_ups�\##�tablebug_reportsbug_reportsCREATE TABLE bug_reports ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), title TEXT NOT NULL, repro_steps TEXT NOT NULL, evidence TEXT, status TEXT DEFAULT 'open' CHECK(status IN ('open', 'resolved', 'wontfix')) )5I#indexsqlite_autoindex_bug_reports_1bug_reports�##�ktablecorrectionscorrectionsCREATE TABLE corrections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), mistake TEXT NOT NULL, symptoms TEXT, resolution TEXT, tags TEXT )5I#indexsqlite_autoindex_corrections_1corrections�+##�tablereflectionsreflectionsCREATE TABLE reflections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), trigger TEXT CHECK(trigger IN ('manual', 'compact', 'completion', 'stop')), content TEXT NOT NULL )5I#indexsqlite_autoindex_reflections_1reflections�w ##�5tablebreadcrumbsbreadcrumbsCREATE TABLE breadcrumbs ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_id TEXT REFERENCES plan_steps(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), agent_type TEXT, summary TEXT NOT NULL, files_touched TEXT, issues TEXT, next_context TEXT )5I#indexsqlite_autoindex_breadcrumbs_1breadcrumbs�v !!�7tableplan_stepsplan_steps CREATE TABLE plan_steps ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_order INTEGER NOT NULL, description TEXT NOT NULL, status TEXT DEFAULT 'pending' CHECK(status IN ('pending', 'in_progress', 'completed', 'failed', 'skipped')), created_at TEXT DEFAULT (datetime('now')) )3 G!indexsqlite_autoindex_plan_steps_1plan_steps �V � tableplansplans CREATE TABLE plans ( id TEXT PRIMARY KEY, created_at TEXT DEFAULT (datetime('now')), status TEXT DEFAULT 'accepted' CHECK(status IN ('accepted', 'in_progress', 'completed', 'abandoned')), description TEXT, plan_markdown TEXT NOT NULL, session_id TEXT, thread_id TEXT REFERENCES threads(id) )) =indexsqlite_autoindex_plans_1plans �++�Ctablethread_sessionsthread_sessionsCREATE TABLE thread_sessions ( thread_id TEXT NOT NULL REFERENCES threads(id) ON DELETE CASCADE, session_id TEXT NOT NULL, created_at TEXT DEFAULT (datetime('now')), PRIMARY KEY (thread_id, session_id) )=Q+indexsqlite_autoindex_thread_sessions_1thread_sessions Q-iindexidx_threads_namethreadsCREATE INDEX idx_threads_name ON threads(name)W1qindexidx_threads_statusthreadsCREATE INDEX idx_threads_status ON threads(status)c3�indexidx_threads_updatedthreadsCREATE INDEX idx_threads_updated ON threads(updated_at DESC)�,�/tablethreadsthreadsCREATE TABLE threads ( id TEXT PRIMARY KEY, name TEXT NOT NULL UNIQUE, created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), current_plan_id TEXT REFERENCES plans(id), git_branches TEXT, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'paused', 'completed', 'archived')) )-Aindexsqlite_autoindex_threads_2threads-Aindexsqlite_autoindex_threads_1thread+Wd^�彔ME  .?�� �� ��� � - � � �  g` ��)�J5��h�7II-Aindexsqlite_autoindex_workers_1workers�<�Ktablenext_upsnext_upsCREATE TABLE next�<�Ktablenext_upsnext_upsCREATE TABLE next_ups ( id TEXT PRIMARY KEY, title TEXT NOT NULL, content TEXT NOT NULL, is_template INTEGER NOT NULL DEFAULT 0, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'archived', 'launched')), created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), last_launched_at TEXT, launch_count INTEGER DEFAULT 0 )5I#indexsqlite_autoindex_bug_reports_1bug_reports�\##�tablebug_reportsbug_reportsCREATE TABLE bug_reports ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), title TEXT NOT NULL, repro_steps TEXT NOT NULL, evidence TEXT, status TEXT DEFAULT 'open' CHECK(status IN ('open', 'resolved', 'wontfix')) )5I#indexsqlite_autoindex_corrections_1corrections�##�ktablecorrectionscorrectionsCREATE TABLE corrections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), mistake TEXT NOT NULL, symptoms TEXT, resolution TEXT, tags TEXT )5I#indexsqlite_autoindex_reflections_1reflections�+##�tablereflectionsreflectionsCREATE TABLE reflections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), trigger TEXT CHECK(trigger IN ('manual', 'compact', 'completion', 'stop')), content TEXT NOT NULL )�w ##�5tablebreadcrumbsbreadcrumbsCREATE TABLE breadcrumbs ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_id TEXT REFERENCES plan_steps(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), agent_type TEXT, summary TEXT NOT NULL, files_touched TEXT, issues TEXT, next_context TEXT )5I#indexsqlite_autoindex_breadcrumbs_1breadcrumbs�v !!�7tableplan_stepsplan_steps CREATE TABLE plan_steps ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_order INTEGER NOT NULL, description TEXT NOT NULL, status TEXT DEFAULT 'pending' CHECK(status IN ('pending', 'in_progress', 'completed', 'failed', 'skipped')), created_at TEXT DEFAULT (datetime('now')) )3 G!indexsqlite_autoindex_plan_steps_1plan_steps �V � tableplansplans CREATE TABLE plans ( id TEXT PRIMARY KEY, created_at TEXT DEFAULT (datetime('now')), status TEXT DEFAULT 'accepted' CHECK(status IN ('accepted', 'in_progress', 'completed', 'abandoned')), description TEXT, plan_markdown TEXT NOT NULL, session_id TEXT, thread_id TEXT REFERENCES threads(id) )) =indexsqlite_autoindex_plans_1plans �++�Ctablethread_sessionsthread_sessionsCREATE TABLE thread_sessions ( thread_id TEXT NOT NULL REFERENCES threads(id) ON DELETE CASCADE, session_id TEXT NOT NULL, created_at TEXT DEFAULT (datetime('now')), PRIMARY KEY (thread_id, session_id) )=Q+indexsqlite_autoindex_thread_sessions_1thread_sessions Q-iindexidx_threads_namethreadsCREATE INDEX idx_threads_name ON threads(name)W1qindexidx_threads_statusthreadsCREATE INDEX idx_threads_status ON threads(status)c3�indexidx_threads_updatedthreadsCREATE INDEX idx_threads_updated ON threads(updated_at DESC)�,�/tablethreadsthreadsCREATE TABLE threads ( id TEXT PRIMARY KEY, name TEXT NOT NULL UNIQUE, created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), current_plan_id TEXT REFERENCES plans(id), git_branches TEXT, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'paused', 'completed', 'archived')) )-Aindexsqlite_autoindex_threads_2threads-Aindexsqlite_autoindex_threads_1threadsWd^�彔M�"dYᔡ �� ��s��}\��6�p�>�^� _ � � � Z �v&?#�indexidx_worker_logs_timestampworker_logs)CREATE INDEX idx_worker_logs_timestamp ON worker_logs(timestamp DESC){%9#�'indexidx_worker_logs_workerworker_logs(CREATE INDEX idx_worker_logs_worker ON worker_logs(worker_id, timestamp DESC)Z$1windexidx_workers_threadworkers'CREATE INDEX idx_workers_thread ON workers(thread_id)W#1qindexidx_workers_statusworkers&CREATE INDEX idx_workers_status ON workers(status)g"5� indexidx_next_ups_updatednext_ups%CREATE INDEX idx_next_ups_updated ON next_ups(updated_at DESC)[!3uindexidx_next_ups_statusnext_ups$CREATE INDEX idx_next_ups_status ON next_ups(status)d -�indexidx_plans_threadplans#CREATE INDEX idx_plans_thread ON plans(thread_id, created_at DESC)Y-!sindexidx_steps_statusplan_steps"CREATE INDEX idx_steps_status ON plan_steps(status)c)!� indexidx_steps_planplan_steps!CREATE INDEX idx_steps_plan ON plan_steps(plan_id, step_order)v5#�!indexidx_breadcrumbs_planbreadcrumbs CREATE INDEX idx_breadcrumbs_plan ON breadcrumbs(plan_id, created_at DESC)�&''� tablesession_statesession_stateCREATE TABLE session_state ( key TEXT PRIMARY KEY, value TEXT NOT NULL, updated_at TEXT DEFAULT (datetime('now')) )9M'indexsqlite_autoindex_session_state_1session_state �P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)�^##�tableworker_logsworker_logsCREATE TABLE worker_logs ( id INTEGER PRIMARY KEY AUTOINCREMENT, worker_id TEXT NOT NULL REFERENCES workers(id) ON DELETE CASCADE, timestamp TEXT NOT NULL DEFAULT (datetime('now')), stream TEXT NOT NULL CHECK(stream IN ('stdout', 'stderr', 'system')), line TEXT NOT NULL, iteration INTEGER )-Aindexsqlite_autoindex_workers_1workers�m�1tableworkersworkersCREATE TABLE workers ( id TEXT PRIMARY KEY, container_id TEXT NOT NULL, thread_id TEXT NOT NULL REFERENCES threads(id), status TEXT DEFAULT 'running' CHECK(status IN ('running', 'completed', 'failed', 'killed')), last_heartbeat TEXT DEFAULT (datetime('now')), created_at TEXT DEFAULT (datetime('now')), auth_mode TEXT CHECK(auth_mode IN ('env', 'config', 'oauth')), iteration INTEGER DEFAULT 0, max_iterations INTEGER DEFAULT 50 )/Cindexsqlite_autoindex_next_ups_1next_ups�Ktablenext_upsnext_upsCREATE TABLE next_ups ( id TU./sindexidx_tasks_sessiontasks-CREATE INDEX idx_tasks_session ON tasks(session_id)R--oindexidx_tasks_threadtasks,CREATE INDEX idx_tasks_thread ON tasks(thread_id)�m+�9tabletaskstasks*CREATE TABLE task�m+�9tabletaskstasks*CREATE TABLE tasks ( id TEXT NOT NULL, session_id TEXT NOT NULL, thread_id TEXT REFERENCES threads(id) ON DELETE SET NULL, subject TEXT NOT NULL, description TEXT, active_form TEXT, status TEXT NOT NULL DEFAULT 'pending', blocks TEXT, blocked_by TEXT, created_at TEXT DEFAULT (datetime('now')), updated_at TEXT DEFAULT (datetime('now')), PRIMARY KEY (session_id, id) )�*))�eviewcurrent_threadcurrent_threadCREATE VIEW current_thread AS SELECT * FROM threads WHERE status = 'active' ORDER BY updated_at DESC LIMIT 1�&)''�viewrecent_crumbsrecent_crumbsCREATE VIEW recent_crumbs AS SELECT b.*, p.description as plan_description, s.description as step_description FROM breadcrumbs b LEFT JOIN plans p ON b.plan_id = p.id LEFT JOIN plan_steps s ON b.step_id = s.id ORDER BY b.created_at DESC LIMIT 10�S(''�iviewpending_stepspending_stepsCREATE VIEW pending_steps AS SELECT s.*, p.description as plan_description FROM plan_steps s JOIN plans p ON s.plan_id = p.id WHERE s.status = 'pending' ORDER BY s.step_order�'##� viewactive_planactive_planCREATE VIEW active_plan AS SELECT * FROM plans WHERE status IN ('accepted', 'in_progress') ORDER BY created_at DESC LIMIT 1/Wd^�彔MLc� �=� m8 � Z �u:@��mY�o �85=I#85=I#indexsqlite_autoindex_workers_new_1workers_new=t;?)� indexidx_drone_sessions_statusdrone_sessions;CREATE INDEX idx_drone_sessions_status ON drone_sessions(status)�:=)�1indexidx_drone_sessions_dronedrone_sessions:CREATE INDEX idx_drone_sessions_drone ON drone_sessions(drone_id, started_at DESC)�i8))� tabledrone_sessionsdrone_sessions8CREATE TABLE drone_sessions ( id TEXT PRIMARY KEY, drone_id TEXT NOT NULL REFERENCES drones(id) ON DELETE CASCADE, worker_id TEXT REFERENCES workers(id), git_branch TEXT, status TEXT DEFAULT 'running' CHECK(status IN ('running', 'completed', 'stopped', 'failed')), iteration INTEGER DEFAULT 0, started_at TEXT DEFAULT (datetime('now')), ended_at TEXT, stop_reason TEXT );9O)indexsqlite_autoindex_drone_sessions_1drone_sessions9M7+eindexidx_drones_namedrones7CREATE INDEX idx_drones_name ON drones(name)S6/mindexidx_drones_statusdrones6CREATE INDEX idx_drones_status ON drones(status)�V3�tabledronesdrones3CREATE TABLE drones ( id TEXT PRIMARY KEY, name TEXT NOT NULL UNIQUE, prompt TEXT NOT NULL, max_iterations INTEGER DEFAULT 100, timeout_minutes INTEGER DEFAULT 60, cooldown_seconds INTEGER DEFAULT 60, status TEXT DEFAULT 'active' CHECK(status IN ('active', 'paused', 'archived')), created_at TEXT DEFAULT (datetime('now')), updated_at TEXT DEFAULT (datetime('now')) )+5?indexsqlite_autoindex_drones_2drones5+4?indexsqlite_autoindex_drones_1drones4 �� 29'�Cindexidx_worker_events_toolworker_events2CREATE INDEX idx_worker_events_tool ON worker_events(tool_name) WHERE tool_name IS NOT NULL� 19'�Cindexidx_worker_events_fileworker_events1CREATE INDEX idx_worker_events_file ON worker_events(file_path) WHERE file_path IS NOT NULL~0='�%indexidx_worker_events_workerworker_events0CREATE INDEX idx_worker_events_worker ON worker_events(worker_id, iteration)�o/''�tableworker_eventsworker_events.CREATE TABLE worker_events ( id INTEGER PRIMARY KEY AUTOINCREMENT, worker_id TEXT NOT NULL, iteration INTEGER NOT NULL, timestamp TEXT NOT NULL DEFAULT (datetime('now')), event_type TEXT NOT NULL CHECK(event_type IN ('tool_call', 'tool_result', 'text', 'error', 'system')), tool_name TEXT, tool_input TEXT, tool_output_preview TEXT, file_path TEXT, duration_ms INTEGER )U./sindexidx_tasks_sessiontasks-CREATE INDEX idx_tasks_session ON tasks(session_id)R--oindexidx_tasks_threadtasks,CREATE INDEX idx_tasks_thread ON tasks(thread_id)),=indexsqlite_autoindex_tasks_1tasks+�9tabletaskstasks*CREATE TABLE tasks ( id TEXT NOT NULL, session_id TEXT NOT NULL, thread_id TEXT REFERENCES threads(id) ON DELETE SET NULL, subject TEXT NOT NULL, description TEXT, active_form TEXT, status TEXT NOT NULL DEFAULT 'pending', blocks TEXT, blocked_by TEXT, created_at TEXT DEFAULT (datetime('now')), updated_at TEXT DEFAULT (datetime('now')), PRIMARY KEY (session_id, id) )�*))�eviewcurrent_threadcurrent_threadCREATE VIEW current_thread AS SELECT * FROM threads WHERE status = 'active' ORDER BY updated_at DESC LIMIT 1�&)''�viewrecent_crumbsrecent_crumbsCREATE VIEW recent_crumbs AS SELECT b.*, p.description as plan_description, s.description as step_de�<##�Stableworkers_newworkers_new�^� _ � � � � � � � Z �v&?#�indexidx_worker_logs_timestampworker_logs)CREATE INDEX idx_worker_logs_timestamp ON worker_logs(timestamp DESC){%9#�'indexidx_worker_logs_workerworker_logs(CREATE INDEX idx_worker_logs_worker ON worker_logs(worker_id, timestamp DESC)��1windexidx_workers_threadworkers'CREATE INDEX idx_workers_thread ON workers(thread_id)�Y1qindexidx_workers_statusworkers&CREATE INDEX idx_workers_status ON workers(status)g"5� indexidx_next_ups_updatednext_ups%CREATE INDEX idx_next_ups_updated ON next_ups(updated_at DESC)[!3uindexidx_next_ups_statusnext_ups$CREATE INDEX idx_next_ups_status ON next_ups(status)d -�indexidx_plans_threadplans#CREATE INDEX idx_plans_thread ON plans(thread_id, created_at DESC)Y-!sindexidx_steps_statusplan_steps"CREATE INDEX idx_steps_status ON plan_steps(status)c)!� indexidx_steps_planplan_steps!CREATE INDEX idx_steps_plan ON plan_steps(plan_id, step_order)v5#�!indexidx_breadcrumbs_planbreadcrumbs CREATE INDEX idx_breadcrumbs_plan ON breadcrumbs(plan_id, created_at DESC)�&''� tablesession_statesession_stateCREATE TABLE session_state ( key TEXT PRIMARY KEY, value TEXT NOT NULL, updated_at TEXT DEFAULT (datetime('now')) )9M'indexsqlite_autoindex_session_state_1session_statesP++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)�^##�tableworker_logsworker_logsCREATE TABLE worker_logs ( id INTEGER PRIMARY KEY AUTOINCREMENT, worker_id TEXT NOT NULL REFERENCES workers(id) ON DELETE CASCADE, timestamp TEXT NOT NULL DEFAULT (datetime('now')), stream TEXT NOT NULL CHECK(stream IN ('stdout', 'stderr', 'system')), line TEXT NOT NULL, iteration INTEGER ) �Aindexsqlite_autoindex_workers_1workers ���1tableworkersworkersCREATE TABLE workers ( id TEXT PRIMARY KEY, container_id TEXT NOT NULL, thread_id TEXT NOT NULL REFERENCES threads(id), status TEXT DEFAULT 'running' CHECK(status IN ('running', 'completed', 'failed', 'killed')), last_heartbeat TEXT DEFAULT (datetime('now')), created_at TEXT DEFAULT (datetime('now')), auth_mode TEXT CHECK(auth_mode IN ('env', 'config', 'oauth')), iteration INTEGER DEFAULT 0, max_iterations INTEGER DEFAULT 50 )/Cindexsqlite_autoindex_next_ups_1next_ups�Ktablenext_upsnext_upsCREATE TABLE next_ups ( id TU./sindexidx_tasks_sessiontasks-CREATE INDEX idx_tasks_session ON tasks(session_id)R--oindexidx_tasks_threadtasks,CREATE INDEX idx_tasks_thread ON tasks(thread_id)�m+�9tabletaskstasks*CREATE TABLE task�m+�9tabletaskstasks*CREATE TABLE tasks ( id TEXT NOT NULL, session_id TEXT NOT NULL, thread_id TEXT REFERENCES threads(id) ON DELETE SET NULL, subject TEXT NOT NULL, description TEXT, active_form TEXT, status TEXT NOT NULL DEFAULT 'pending', blocks TEXT, blocked_by TEXT, created_at TEXT DEFAULT (datetime('now')), updated_at TEXT DEFAULT (datetime('now')), PRIMARY KEY (session_id, id) )�*))�eviewcurrent_threadcurrent_threadCREATE VIEW current_thread AS SELECT * FROM threads WHERE status = 'active' ORDER BY updated_at DESC LIMIT 1�&)''�viewrecent_crumbsrecent_crumbsCREATE VIEW recent_crumbs AS SELECT b.*, p.description as plan_description, s.description as step_description FROM breadcrumbs b LEFT JOIN plans p ON b.plan_id = p.id LEFT JOIN plan_steps s ON b.step_id = s.id ORDER BY b.created_at DESC LIMIT 10�S(''�iviewpending_stepspending_stepsCREATE VIEW pending_steps AS SELECT s.*, p.description as plan_description FROM plan_steps s JOIN plans p ON s.plan_id = p.id WHERE s.status = 'pending' ORDER BY s.step_order�'##� viewactive_planactive_planCREATE VIEW active_plan AS SELECT * FROM plans WHERE status IN ('accepted', 'in_progress') ORDER BY created_at DESC LIMIT 1&Wd^�彔M�vxF�A� '=Wd^�彔M޹�fv�&Wd^�彔M���)�SQLite format 3@ ='-.zp�/�� - � � �  g` ��)Jx�h�77/Cindexsqlite_autoindex_next_ups_1next_ups�\##�tablebug_reportsbug_reportsCREATE TABLE bug_reports ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), title TEXT NOT NULL, repro_steps TEXT NOT NULL, evidence TEXT, status TEXT DEFAULT 'open' CHECK(status IN ('open', 'resolved', 'wontfix')) )5I#indexsqlite_autoindex_bug_reports_1bug_reports�##�ktablecorrectionscorrectionsCREATE TABLE corrections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), mistake TEXT NOT NULL, symptoms TEXT, resolution TEXT, tags TEXT )5I#indexsqlite_autoindex_corrections_1corrections�+##�tablereflectionsreflectionsCREATE TABLE reflections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), trigger TEXT CHECK(trigger IN ('manual', 'compact', 'completion', 'stop')), content TEXT NOT NULL )5I#indexsqlite_autoindex_reflections_1reflections�w ##�5tablebreadcrumbsbreadcrumbsCREATE TABLE breadcrumbs ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_id TEXT REFERENCES plan_steps(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), agent_type TEXT, summary TEXT NOT NULL, files_touched TEXT, issues TEXT, next_context TEXT )5I#indexsqlite_autoindex_breadcrumbs_1breadcrumbs�v !!�7tableplan_stepsplan_steps CREATE TABLE plan_steps ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_order INTEGER NOT NULL, description TEXT NOT NULL, status TEXT DEFAULT 'pending' CHECK(status IN ('pending', 'in_progress', 'completed', 'failed', 'skipped')), created_at TEXT DEFAULT (datetime('now')) )3 G!indexsqlite_autoindex_plan_steps_1plan_steps �V � tableplansplans CREATE TABLE plans ( id TEXT PRIMARY KEY, created_at TEXT DEFAULT (datetime('now')), status TEXT DEFAULT 'accepted' CHECK(status IN ('accepted', 'in_progress', 'completed', 'abandoned')), description TEXT, plan_markdown TEXT NOT NULL, session_id TEXT, thread_id TEXT REFERENCES threads(id) )) =indexsqlite_autoindex_plans_1plans �++�Ctablethread_sessionsthread_sessionsCREATE TABLE thread_sessions ( thread_id TEXT NOT NULL REFERENCES threads(id) ON DELETE CASCADE, session_id TEXT NOT NULL, created_at TEXT DEFAULT (datetime('now')), PRIMARY KEY (thread_id, session_id) )=Q+indexsqlite_autoindex_thread_sessions_1thread_sessions Q-iindexidx_threads_namethreadsCREATE INDEX idx_threads_name ON threads(name)W1qindexidx_threads_statusthreadsCREATE INDEX idx_threads_status ON threads(status)c3�indexidx_threads_updatedthreadsCREATE INDEX idx_threads_updated ON threads(updated_at DESC)�,�/tablethreadsthreadsCREATE TABLE threads ( id TEXT PRIMARY KEY, name TEXT NOT NULL UNIQUE, created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), current_plan_id TEXT REFERENCES plans(id), git_branches TEXT, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'paused', 'completed', 'archived')) )-Aindexsqlite_autoindex_threads_2threads-Aindexsqlite_autoindex_threads_1thread+/=Wd^�彔Mv!��C�� mo � Z �u:@��mY�o �5=I#85=I#indexsqlite_autoindex_workers_new_1workers_new=t;?)� indexidx_drone_sessions_statusdrone_sessions;CREATE INDEX idx_drone_sessions_status ON drone_sessions(status)�:=)�1indexidx_drone_sessions_dronedrone_sessions:CREATE INDEX idx_drone_sessions_drone ON drone_sessions(drone_id, started_at DESC)�i8))� tabledrone_sessionsdrone_sessions8CREATE TABLE drone_sessions ( id TEXT PRIMARY KEY, drone_id TEXT NOT NULL REFERENCES drones(id) ON DELETE CASCADE, worker_id TEXT REFERENCES workers(id), git_branch TEXT, status TEXT DEFAULT 'running' CHECK(status IN ('running', 'completed', 'stopped', 'failed')), iteration INTEGER DEFAULT 0, started_at TEXT DEFAULT (datetime('now')), ended_at TEXT, stop_reason TEXT );9O)indexsqlite_autoindex_drone_sessions_1drone_sessions9M7+eindexidx_drones_namedrones7CREATE INDEX idx_drones_name ON drones(name)S6/mindexidx_drones_statusdrones6CREATE INDEX idx_drones_status ON drones(status)�V3�tabledronesdrones3CREATE TABLE drones ( id TEXT PRIMARY KEY, name TEXT NOT NULL UNIQUE, prompt TEXT NOT NULL, max_iterations INTEGER DEFAULT 100, timeout_minutes INTEGER DEFAULT 60, cooldown_seconds INTEGER DEFAULT 60, status TEXT DEFAULT 'active' CHECK(status IN ('active', 'paused', 'archived')), created_at TEXT DEFAULT (datetime('now')), updated_at TEXT DEFAULT (datetime('now')) )+5?indexsqlite_autoindex_drones_2drones5+4?indexsqlite_autoindex_drones_1drones4 �� 29'�Cindexidx_worker_events_toolworker_events2CREATE INDEX idx_worker_events_tool ON worker_events(tool_name) WHERE tool_name IS NOT NULL� 19'�Cindexidx_worker_events_fileworker_events1CREATE INDEX idx_worker_events_file ON worker_events(file_path) WHERE file_path IS NOT NULL~0='�%indexidx_worker_events_workerworker_events0CREATE INDEX idx_worker_events_worker ON worker_events(worker_id, iteration)�o/''�tableworker_eventsworker_events.CREATE TABLE worker_events ( id INTEGER PRIMARY KEY AUTOINCREMENT, worker_id TEXT NOT NULL, iteration INTEGER NOT NULL, timestamp TEXT NOT NULL DEFAULT (datetime('now')), event_type TEXT NOT NULL CHECK(event_type IN ('tool_call', 'tool_result', 'text', 'error', 'system')), tool_name TEXT, tool_input TEXT, tool_output_preview TEXT, file_path TEXT, duration_ms INTEGER )U./sindexidx_tasks_sessiontasks-CREATE INDEX idx_tasks_session ON tasks(session_id)R--oindexidx_tasks_threadtasks,CREATE INDEX idx_tasks_thread ON tasks(thread_id)),=indexsqlite_autoindex_tasks_1tasks+��9tabletaskstasks*CREATE TABLE tasks ( id TEXT NOT NULL, session_id TEXT NOT NULL, thread_id TEXT REFERENCES threads(id) ON DELETE SET NULL, subject TEXT NOT NULL, description TEXT, active_form TEXT, status TEXT NOT NULL DEFAULT 'pending', blocks TEXT, blocked_by TEXT, created_at TEXT DEFAULT (datetime('now')), updated_at TEXT DEFAULT (datetime('now')), PRIMARY KEY (session_id, id) )�*))�eviewcurrent_threadcurrent_threadCREATE VIEW current_thread AS SELECT * FROM threads WHERE status = 'active' ORDER BY updated_at DESC LIMIT 1�&)''�viewrecent_crumbsrecent_crumbsCREATE VIEW recent_crumbs AS SELECT b.*, p.description as plan_desc-=Aindexsqlite_autoindex_workers_1workers=�|<�Otableworkersworkers 'Wd^�彔MZ�F���v&/=Wd^�彔M�u=�h�*� mo � Z �u:@��mY�o � y5=I#85=I#indexsqlite_autoindex_workers_new_1workers_new=t;?)� indexidx_drone_sessions_statusdrone_sessions;CREATE INDEX idx_drone_sessions_status ON drone_sessions(status)�:=)�1indexidx_drone_sessions_dronedrone_sessions:CREATE INDEX idx_drone_sessions_drone ON drone_sessions(drone_id, started_at DESC)�i8))� tabledrone_sessionsdrone_sessions8CREATE TABLE drone_sessions ( id TEXT PRIMARY KEY, drone_id TEXT NOT NULL REFERENCES drones(id) ON DELETE CASCADE, worker_id TEXT REFERENCES workers(id), git_branch TEXT, status TEXT DEFAULT 'running' CHECK(status IN ('running', 'completed', 'stopped', 'failed')), iteration INTEGER DEFAULT 0, started_at TEXT DEFAULT (datetime('now')), ended_at TEXT, stop_reason TEXT );9O)indexsqlite_autoindex_drone_sessions_1drone_sessions9M7+eindexidx_drones_namedrones7CREATE INDEX idx_drones_name ON drones(name)S6/mindexidx_drones_statusdrones6CREATE INDEX idx_drones_status ON drones(status)�V3�tabledronesdrones3CREATE TABLE drones ( id TEXT PRIMARY KEY, name TEXT NOT NULL UNIQUE, prompt TEXT NOT NULL, max_iterations INTEGER DEFAULT 100, timeout_minutes INTEGER DEFAULT 60, cooldown_seconds INTEGER DEFAULT 60, status TEXT DEFAULT 'active' CHECK(status IN ('active', 'paused', 'archived')), created_at TEXT DEFAULT (datetime('now')), updated_at TEXT DEFAULT (datetime('now')) )+5?indexsqlite_autoindex_drones_2drones5+4?indexsqlite_autoindex_drones_1drones4 �� 29'�Cindexidx_worker_events_toolworker_events2CREATE INDEX idx_worker_events_tool ON worker_events(tool_name) WHERE tool_name IS NOT NULL� 19'�Cindexidx_worker_events_fileworker_events1CREATE INDEX idx_worker_events_file ON worker_events(file_path) WHERE file_path IS NOT NULL~0='�%indexidx_worker_events_workerworker_events0CREATE INDEX idx_worker_events_worker ON worker_events(worker_id, iteration)�o/''�tableworker_eventsworker_events.CREATE TABLE worker_events ( id INTEGER PRIMARY KEY AUTOINCREMENT, worker_id TEXT NOT NULL, iteration INTEGER NOT NULL, timestamp TEXT NOT NULL DEFAULT (datetime('now')), event_type TEXT NOT NULL CHECK(event_type IN ('tool_call', 'tool_result', 'text', 'error', 'system')), tool_name TEXT, tool_input TEXT, tool_output_preview TEXT, file_path TEXT, duration_ms INTEGER )U./sindexidx_tasks_sessiontasks-CREATE INDEX idx_tasks_session ON tasks(session_id)R--oindexidx_tasks_threadtasks,CREATE INDEX idx_tasks_thread ON tasks(thread_id)),=indexsqlite_autoindex_tasks_1tasks+��9tabletaskstasks*CREATE TABLE tasks ( id TEXT NOT NULL, session_id TEXT NOT NULL, thread_id TEXT REFERENCES threads(id) ON DELETE SET NULL, subject TEXT NOT NULL, description TEXT, active_form TEXT, status TEXT NOT NULL DEFAULT 'pending', blocks TEXT, blocked_by TEXT, created_at TEXT DEFAULT (datetime('now')), updated_at TEXT DEFAULT (datetime('now')), PRIMARY KEY (session_id, id) )�*))�eviewcurrent_threadcurrent_threadCREATE VIEW current_thread AS SELECT * FROM threads WHERE status = 'active' ORDER BY updated_at DESC LIMIT 1�&)''�viewrecent_crumbW>1qindexidx_workers_statusworkersCREATE INDEX idx_workers_status ON workers(status)-=Aindexsqlite_autoindex_workers_1workers=�|<�Otableworkersworkers1qindexidx_workers_statusworkersCREATE INDEX idx_workers_status ON workers(status)-=Aindexsqlite_autoindex_workers_1workers=�|<�Otableworkersworkers'�ԏf ��(W ct-1251-space-wide-suggestion-historyWd^�彔Md��� ��3 2026-03-17 01:46:23Wd^�彔M�ݔ3� ��  active=Wd^�彔M��Rtn�D ��(W ct-1251-space-wide-suggestion-historyWd^�彔M�&&"��� ��113selected_thread_ida2cf6aeb2026-03-17 01:46:23=Wd^�彔MV�j���� ��1 selected_thread_idWd^�彔Mw�׷���� ��CU3a2cf6aeba3a12b56-f158-4a74-903e-b93aca4499bd2026-03-17 01:46:23 =Wd^�彔Mט[⌈� ��0U a2cf6aeba3a12b56-f158-4a74-903e-b93aca4499bdWd^�彔M�|^[�a�SQLite format 3@ ='/.zp�/�� - � � �  g` ��)Jx�h�77/Cindexsqlite_autoindex_next_ups_1next_ups�\##�tablebug_reportsbug_reportsCREATE TABLE bug_reports ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), title TEXT NOT NULL, repro_steps TEXT NOT NULL, evidence TEXT, status TEXT DEFAULT 'open' CHECK(status IN ('open', 'resolved', 'wontfix')) )5I#indexsqlite_autoindex_bug_reports_1bug_reports�##�ktablecorrectionscorrectionsCREATE TABLE corrections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), mistake TEXT NOT NULL, symptoms TEXT, resolution TEXT, tags TEXT )5I#indexsqlite_autoindex_corrections_1corrections�+##�tablereflectionsreflectionsCREATE TABLE reflections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), trigger TEXT CHECK(trigger IN ('manual', 'compact', 'completion', 'stop')), content TEXT NOT NULL )5I#indexsqlite_autoindex_reflections_1reflections�w ##�5tablebreadcrumbsbreadcrumbsCREATE TABLE breadcrumbs ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_id TEXT REFERENCES plan_steps(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), agent_type TEXT, summary TEXT NOT NULL, files_touched TEXT, issues TEXT, next_context TEXT )5I#indexsqlite_autoindex_breadcrumbs_1breadcrumbs�v !!�7tableplan_stepsplan_steps CREATE TABLE plan_steps ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_order INTEGER NOT NULL, description TEXT NOT NULL, status TEXT DEFAULT 'pending' CHECK(status IN ('pending', 'in_progress', 'completed', 'failed', 'skipped')), created_at TEXT DEFAULT (datetime('now')) )3 G!indexsqlite_autoindex_plan_steps_1plan_steps �V � tableplansplans CREATE TABLE plans ( id TEXT PRIMARY KEY, created_at TEXT DEFAULT (datetime('now')), status TEXT DEFAULT 'accepted' CHECK(status IN ('accepted', 'in_progress', 'completed', 'abandoned')), description TEXT, plan_markdown TEXT NOT NULL, session_id TEXT, thread_id TEXT REFERENCES threads(id) )) =indexsqlite_autoindex_plans_1plans �++�Ctablethread_sessionsthread_sessionsCREATE TABLE thread_sessions ( thread_id TEXT NOT NULL REFERENCES threads(id) ON DELETE CASCADE, session_id TEXT NOT NULL, created_at TEXT DEFAULT (datetime('now')), PRIMARY KEY (thread_id, session_id) )=Q+indexsqlite_autoindex_thread_sessions_1thread_sessions Q-iindexidx_threads_namethreadsCREATE INDEX idx_threads_name ON threads(name)W1qindexidx_threads_statusthreadsCREATE INDEX idx_threads_status ON threads(status)c3�indexidx_threads_updatedthreadsCREATE INDEX idx_threads_updated ON threads(updated_at DESC)�,�/tablethreadsthreadsCREATE TABLE threads ( id TEXT PRIMARY KEY, name TEXT NOT NULL UNIQUE, created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), current_plan_id TEXT REFERENCES plans(id), git_branches TEXT, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'paused', 'completed', 'archived')) )-Aindexsqlite_autoindex_threads_2threads-Aindexsqlite_autoindex_threads_1thread+ Wd^�彔M�E.�D�=� --�H 3Y�!U0a3de5a82026-03-17 01:46:23acceptedCT-1251: Space-wide Suggestion History# CT-1251: Space-wide Suggestion History ## Context When `llmDialog`'s internal `presentResult` tool fires, the generated result is shown to the user but not persisted beyond that suggestion instance. We want to: 1. Capture every presented result (plus the conversation context that produced it) into a space-wide `suggestionHistory` list owned by `default-app.tsx` 2. Provide a viewer pattern (`suggestion-history.tsx`) that displays the history with result links + metadata 3. Expose a search sub-pattern so that `suggestion.tsx` agents can discover previously generated items when responding to new requests The original issue plan is still valid. Key code verification: - `pathForKey` exists at `wish.ts:404-413` ✓ - `presentResult` cellification happens at `llm-dialog.ts:2440-2445` ✓ - `safelyPerformUpdate` write block at `llm-dialog.ts:2492-2507` ✓ - `allPieces`/`recentPieces` pattern in `default-app.tsx:148-149` ✓ - `spaceCellSchema` exported from `runtime.ts:131` ✓ - `summary-index.tsx` exports `searchPattern` and `SummaryIndexEntry` as the model to follow ✓ - `suggestion.tsx` imports `searchPattern as summarySearchPattern` from `summary-index.tsx` at line 27 ✓ --- ## History Entry Shape ```typescript type SuggestionHistoryEntry = { result: any; // cellified { cell: Writable } — the presented result messages: any[]; // full conversation that produced it (for context/display) timestamp: string; // ISO date string }; ``` No separate `situation` field — the `situation` is the first user message in `messages` (set by `triggerGeneration` handler in `suggestion.tsx:41-44`). The viewer extracts it for display. --- ## Implementation Steps ### 1. `packages/runner/src/runtime.ts` Extend `spaceCellSchema` to include `suggestionHistory` under `defaultPattern.properties`: ```typescript suggestionHistory: { type: "array", items: { type: "object", properties: { result: { type: "object", asCell: true }, messages: { type: "array" }, timestamp: { type: "string" }, }, }, } ``` This is necessary so that `getCell(..., spaceCellSchema).key("defaultPattern").key("suggestionHistory")` resolves to a properly typed cell. ### 2. `packages/runner/src/builtins/wish.ts` Add one line to `pathForKey` (line ~405): ```typescript "#suggestions": ["defaultPattern", "suggestionHistory"], ``` ### 3. `packages/runner/src/builtins/llm-dialog.ts` **Import**: Add `spaceCellSchema` to the import from `../runtime.ts`. **Write history inside `safelyPerformUpdate` callback** (inside the same atomic tx that writes the result cell, ~line 2500). Condition: only when `cellifiedResult !== undefined` AND `queueName === "suggestions"`: ```typescript if (queueName === "suggestions") { try { const spaceCell = runtime.getCell(space, space, spaceCellSchema, tx); const historyCell = spaceCell.key("defaultPattern").key("suggestionHistory"); const current = (historyCell.get() as any[] | undefined) ?? []; historyCell.withTx(tx).set([...current, { result: cellifiedResult, messages: messagesCell.get() ?? [], timestamp: new Date().toISOString(), }]); } catch (e) { logger.warn("llm", "Failed to record suggestion history entry", e); } } ``` The try/catch ensures failures don't break the dialog. Note: `queueName` is already read at line 2239 in `startRequest`, and passed down through the call chain — confirm it's in scope (it is, since we're inside `startRequest`). ### 4. `packages/patterns/system/default-app.tsx` Add `suggestionHistory` cell (alongside `allPieces`/`recentPieces`, ~line 148): ```typescript const suggestionHistory = Writable.of([]); ``` Add a `ct-cell-link` to the toolbar (alongside the existing "Mentions" and "Search" links): ```tsx History ``` Where `suggestionHistoryViewer = SuggestionHistory({})`. Export `suggestionHistory` from the pattern return (line ~360): ```typescript suggestionHistory, ``` Also add the import: `import SuggestionHistory from "./suggestion-history.tsx"`. > Note: `default-app.tsx` owns the `Writable` cell, but llm-dialog.ts writes to it directly via the space cell path. The `Writable` cell in default-app.tsx exists so the pattern "registers" it in the space — on first load it initializes the cell which llm-dialog can then find and append to. This mirrors exactly how `allPieces` and `recentPieces` work. ### 5. `packages/patterns/system/suggestion-history.tsx` (NEW) Modeled after `summary-index.tsx`. Key exports: ```typescript export type SuggestionHistoryEntry = { result: Writable<{ cell: Writable }>; messages: any[]; timestamp: string; }; /** Search sub-pattern: filters history entries by situation text or timestamp */ export const searchPattern = pattern< { query: string; entries: Writable[] }, Writable[] >(({ query, entries }) => { return computed(() => { if (!query || query.trim() === "") return entries; const lowerQuery = query.toLowerCase().trim(); return entries.filter((entry) => { const e = entry.get(); // Search the first user message (the situation text) const firstMsg = e.messages?.find((m: any) => m.role === "user"); const situation = extractTextFromMessage(firstMsg) ?? ""; return situation.toLowerCase().includes(lowerQuery) || e.timestamp.includes(lowerQuery); }); }); }); ``` Main pattern: - `wish({ query: "#suggestions" })` to read the history list - Computes `entries` (wraps each raw entry, extracts situation from first user message) - Renders a `ct-table` with: situation text, timestamp, `ct-cell-link` to the result cell - Returns `entries`, `search: patternTool(searchPattern, { entries })`, `[UI]` ### 6. `packages/patterns/system/suggestion.tsx` Add import and wire up search tool: ```typescript import { searchPattern as searchHistoryPattern, type SuggestionHistoryEntry, } from "./suggestion-history.tsx"; ``` Add wish call (alongside the existing `#summaryIndex` wish): ```typescript const { entries: historyEntries } = wish<{ entries: SuggestionHistoryEntry[]; }>({ query: "#suggestions" }).result; ``` Add tool to `llmDialog` tools: ```typescript searchHistory: patternTool(searchHistoryPattern, { entries: historyEntries }), ``` Update the system prompt to mention the new `searchHistory` tool so the LLM knows to use it to avoid duplicating previously generated content. --- ## Files Modified | File | Change | |------|--------| | `packages/runner/src/runtime.ts` | Extend `spaceCellSchema` with `suggestionHistory` | | `packages/runner/src/builtins/wish.ts` | Add `#suggestions` to `pathForKey` | | `packages/runner/src/builtins/llm-dialog.ts` | Push to `suggestionHistory` on presentResult when queue=suggestions | | `packages/patterns/system/default-app.tsx` | Add `suggestionHistory` Writable + viewer cell-link + export | | `packages/patterns/system/suggestion-history.tsx` | **NEW** — viewer + search sub-pattern | | `packages/patterns/system/suggestion.tsx` | Import + wire `searchHistory` tool | --- ## Verification 1. `deno task check` passes (type checking across all packages) 2. Deploy locally (`dev-local`) 3. Trigger a suggestion via wish 4. After `presentResult` fires, open default-app — the "History" toolbar link should appear 5. Click "History" — verify entry shows situation text, timestamp, and a `ct-cell-link` to the result 6. Trigger a second suggestion with a related query — LLM should use `searchHistory` tool and reference the prior result 7. Verify multiple suggestions append (not overwrite) the history list a3a12b56-f158-4a74-903e-b93aca4499bda2cf6aeb'=Wd^�彔M ���5�&Wd^�彔M ���Y�W kk�W33_a2cf6aebct-1251-space-wide-suggestion-history2026-03-17 01:46:232026-03-17 01:46:230a3de5a8ben/ct-1251-space-wide-suggestion-historyactive=Wd^�彔MR�.� IC� ��3 2026-03-17 01:46:23Wd^�彔MMZ����$ TT�) 3#�I�-6407a6900a3de5a82026-03-17 02:08:09implementerAdded suggestionHistory property to spaceCellSchema in runtime.tspackages/runner/src/runtime.tsspaceCellSchema now includes suggestionHistory array under defaultPattern.properties with result (asCell:true), messages, and timestamp fields. Next steps: update default-app.tsx to write to suggestionHistory on presentResult, create suggestion-history.tsx viewer pattern.Wd^�彔M��fi�q�� ��  6407a690 =Wd^�彔M�<=�# ��3 0a3de5a82026-03-17 02:08:09Wd^�彔MP�Q5  �T ��O 3#cU�1�u61b4fe480a3de5a82026-03-17 02:08:56implementerAdded #suggestions to pathForKey in wish.tspackages/runner/src/builtins/wish.tsNo plan_steps rows exist in DB; --step flag omitted to avoid FK constraint failureThe #suggestions key now maps to ['defaultPattern', 'suggestionHistory'], consistent with #allPieces and #recent. Other steps in the plan (runtime.ts spaceCellSchema, llm-dialog.ts write, default-app.tsx, suggestion-history.tsx pattern) remain.�) 3#�I�-6407a6900a3de5a82026-03-17 02:08:09implementerAdded suggestionHistory property to spaceCellSchema in runtime.tspackages/runner/src/runtime.tsspaceCellSchema now includes suggestionHistory array under defaultPattern.properties with result (asCell:true), messages, and timestamp fields. Next steps: update default-app.tsx to write to suggestionHistory on presentResult, create suggestion-history.tsx viewer pattern.Wd^�彔M��ѳ�� ��� 61b4fe48  6407a690 =Wd^�彔M�����F*� ��� 30a3de5a82026-03-17 02:08:563 0a3de5a82026-03-17 02:08:09Wd^�彔M&i��K�  AT � A�> 3#�+k�27df7ec10a3de5a82026-03-17 02:47:44implementerFixed type errors in suggestion-history.tsx triggered by spaceCellSchema changepackages/patterns/system/suggestion-history.tsxTwo type fixes: (1) SuggestionHistoryEntry.result changed from Writable<{cell:Writable}> to Writable since the schema stores result as a direct cellified object, not a wrapper; (2) cast on line 70 goes through 'unknown' to handle OpaqueCell vs Writable mismatch; (3) line 116 now uses e.result directly instead of e.result?.cell. deno fmt also applied. Both files pass deno check.�O 3#cU�1�u61b4fe480a3de5a82026-03-17 02:08:56implementerAdded #suggestions to pathForKey in wish.tspackages/runner/src/builtins/wish.tsNo plan_steps rows exist in DB; --step flag omitted to avoid FK constraint failureThe #suggestions key now maps to ['defaultPattern', 'suggestionHistory'], consistent with #allPieces and #recent. Other steps in the plan (runtime.ts spaceCellSchema, llm-dialog.ts write, default-app.tsx, suggestion-history.tsx pattern) remain.�) 3#�I�-6407a6900a3de5a82026-03-17 02:08:09implementerAdded suggestionHistory property to spaceCellSchema in runtime.tspackages/runner/src/runtime.tsspaceCellSchema now includes suggestionHistory array under defaultPattern.properties with result (asCell:true), messages, and timestamp fields. Next steps: update default-app.tsx to write to suggestionHistory on presentResult, create suggestion-history.tsx viewer pattern.Wd^�彔M��X�+B ���� 27df7ec1 61b4fe48  6407a690 =Wd^�彔M�O���ߎ� ���� 30a3de5a82026-03-17 02:47:44 30a3de5a82026-03-17 02:08:563 0a3de5a82026-03-17 02:08:09Wd^�彔M��_��; �T � A��~ 3#�Ek��{2080c0c70a3de5a82026-03-17 02:49:05implementerCreated suggestion-history.tsx pattern with SuggestionHistoryEntry type, extractSituation helper, searchPattern export, and SuggestionHistory default exportpackages/patterns/system/suggestion-history.tsxLinter simplified result type from Writable<{ cell: Writable }> to Writable. Type check passes cleanly with deno check.Next steps: (1) Add suggestionHistory to default-app.tsx with Writable.of and ct-cell-link toolbar entry; (2) Wire up in suggestion.tsx with searchHistory tool; (3) Update runtime.ts spaceCellSchema and wish.ts pathForKey with #suggestions mapping�> 3#�+k�27df7ec10a3de5a82026-03-17 02:47:44implementerFixed type errors in suggestion-history.tsx triggered by spaceCellSchema changepackages/patterns/system/suggestion-history.tsxTwo type fixes: (1) SuggestionHistoryEntry.result changed from Writable<{cell:Writable}> to Writable since the schema stores result as a direct cellified object, not a wrapper; (2) cast on line 70 goes through 'unknown' to handle OpaqueCell vs Writable mismatch; (3) line 116 now uses e.result directly instead of e.result?.cell. deno fmt also applied. Both files pass deno check.�O 3#cU�1�u61b4fe480a3de5a82026-03-17 02:08:56implementerAdded #suggestions to pathForKey in wish.tspackages/runner/src/builtins/wish.tsNo plan_steps rows exist in DB; --step flag omitted to avoid FK constraint failureThe #suggestions key now maps to ['defaultPattern', 'suggestionHistory'], consistent with #allPieces and #recent. Other steps in the plan (runtime.ts spaceCellSchema, llm-dialog.ts write, default-app.tsx, suggestion-history.tsx pattern) remain.�) 3#�I�-6407a6900a3de5a82026-03-17 02:08:09implementerAdded suggestionHistory property to spaceCellSchema in runtime.tspackages/runner/src/runtime.tsspaceCellSchema now includes suggestionHistory array under defaultPattern.properties with result (asCell:true), messages, and timestamp fields. Next steps: update default-app.tsx to write to suggestionHistory on presentResult, create suggestion-history.tsx viewer pattern.Wd^�彔M���;bZ ����� 2080c0c7 27df7ec1 61b4fe48  6407a690 =Wd^�彔M5֟����e }}��� 30a3de5a82026-03-17 02:49:05 30a3de5a82026-03-17 02:47:44 30a3de5a82026-03-17 02:08:563 0a3de5a82026-03-17 02:08:09Wd^�彔ME ~�� �� �T � A���+ 3#}U� �;678f04a00a3de5a82026-03-17 02:49:05implementerConfirmed type check passes cleanly after wish.ts changepackages/runner/src/builtins/wish.tsStop hook showed TS errors in suggestion-history.tsx but those were pre-existing; current deno task check passes with 0 errorsBoth runtime.ts (spaceCellSchema with suggestionHistory) and wish.ts (#suggestions pathForKey) are in place. Next steps in the plan: llm-dialog.ts write block to persist entries, default-app.tsx to wire up SuggestionHistory pattern, suggestion.tsx to import and use searchPattern�~ 3#�Ek��{2080c0c70a3de5a82026-03-17 02:49:05implementerCreated suggestion-history.tsx pattern with SuggestionHistoryEntry type, extractSituation helper, searchPattern export, and SuggestionHistory default exportpackages/patterns/system/suggestion-history.tsxLinter simplified result type from Writable<{ cell: Writable }> to Writable. Type check passes cleanly with deno check.Next steps: (1) Add suggestionHistory to default-app.tsx with Writable.of and ct-cell-link toolbar entry; (2) Wire up in suggestion.tsx with searchHistory tool; (3) Update runtime.ts spaceCellSchema and wish.ts pathForKey with #suggestions mapping�> 3#�+k�27df7ec10a3de5a82026-03-17 02:47:44implementerFixed type errors in suggestion-history.tsx triggered by spaceCellSchema changepackages/patterns/system/suggestion-history.tsxTwo type fixes: (1) SuggestionHistoryEntry.result changed from Writable<{cell:Writable}> to Writable since the schema stores result as a direct cellified object, not a wrapper; (2) cast on line 70 goes through 'unknown' to handle OpaqueCell vs Writable mismatch; (3) line 116 now uses e.result directly instead of e.result?.cell. deno fmt also applied. Both files pass deno check.�O 3#cU�1�u61b4fe480a3de5a82026-03-17 02:08:56implementerAdded #suggestions to pathForKey in wish.tspackages/runner/src/builtins/wish.tsNo plan_steps rows exist in DB; --step flag omitted to avoid FK constraint failureThe #suggestions key now maps to ['defaultPattern', 'suggestionHistory'], consistent with #allPieces and #recent. Other steps in the plan (runtime.ts spaceCellSchema, llm-dialog.ts write, default-app.tsx, suggestion-history.tsx pattern) remain.�) 3#�I�-6407a6900a3de5a82026-03-17 02:08:09implementerAdded suggestionHistory property to spaceCellSchema in runtime.tspackages/runner/src/runtime.tsspaceCellSchema now includes suggestionHistory array under defaultPattern.properties with result (asCell:true), messages, and timestamp fields. Next steps: update default-app.tsx to write to suggestionHistory on presentResult, create suggestion-history.tsx viewer pattern.Wd^�彔Mr�g�_ ������ 678f04a0 2080c0c7 27df7ec1 61b4fe48  6407a690 =Wd^�彔M1jÔSv�* \}\��� 30a3de5a82026-03-17 02:49:05 30a3de5a82026-03-17 02:49:05 30a3de5a82026-03-17 02:47:44 30a3de5a82026-03-17 02:08:563 0a3de5a82026-03-17 02:08:09Wd^�彔M�Ϡ(��:6 �T � A����8 3#�-aM�U1786b8730a3de5a82026-03-17 22:43:29implementerAdded spaceCellSchema import and suggestion history write block to llm-dialog.tspackages/runner/src/builtins/llm-dialog.tsNone - type check passes cleanlyNext steps: (1) Add suggestionHistory to default-app.tsx with Writable.of and ct-cell-link toolbar entry; (2) Wire up searchHistory tool in suggestion.tsx using searchPattern from suggestion-history.tsx�+ 3#}U� �;678f04a00a3de5a82026-03-17 02:49:05implementerConfirmed type check passes cleanly after wish.ts changepackages/runner/src/builtins/wish.tsStop hook showed TS errors in suggestion-history.tsx but those were pre-existing; current deno task check passes with 0 errorsBoth runtime.ts (spaceCellSchema with suggestionHistory) and wish.ts (#suggestions pathForKey) are in place. Next steps in the plan: llm-dialog.ts write block to persist entries, default-app.tsx to wire up SuggestionHistory pattern, suggestion.tsx to import and use searchPattern�~ 3#�Ek��{2080c0c70a3de5a82026-03-17 02:49:05implementerCreated suggestion-history.tsx pattern with SuggestionHistoryEntry type, extractSituation helper, searchPattern export, and SuggestionHistory default exportpackages/patterns/system/suggestion-history.tsxLinter simplified result type from Writable<{ cell: Writable }> to Writable. Type check passes cleanly with deno check.Next steps: (1) Add suggestionHistory to default-app.tsx with Writable.of and ct-cell-link toolbar entry; (2) Wire up in suggestion.tsx with searchHistory tool; (3) Update runtime.ts spaceCellSchema and wish.ts pathForKey with #suggestions mapping�> 3#�+k�27df7ec10a3de5a82026-03-17 02:47:44implementerFixed type errors in suggestion-history.tsx triggered by spaceCellSchema changepackages/patterns/system/suggestion-history.tsxTwo type fixes: (1) SuggestionHistoryEntry.result changed from Writable<{cell:Writable}> to Writable since the schema stores result as a direct cellified object, not a wrapper; (2) cast on line 70 goes through 'unknown' to handle OpaqueCell vs Writable mismatch; (3) line 116 now uses e.result directly instead of e.result?.cell. deno fmt also applied. Both files pass deno check.�O 3#cU�1�u61b4fe480a3de5a82026-03-17 02:08:56implementerAdded #suggestions to pathForKey in wish.tspackages/runner/src/builtins/wish.tsNo plan_steps rows exist in DB; --step flag omitted to avoid FK constraint failureThe #suggestions key now maps to ['defaultPattern', 'suggestionHistory'], consistent with #allPieces and #recent. Other steps in the plan (runtime.ts spaceCellSchema, llm-dialog.ts write, default-app.tsx, suggestion-history.tsx pattern) remain.�) 3#�I�-6407a6900a3de5a82026-03-17 02:08:09implementerAdded suggestionHistory property to spaceCellSchema in runtime.tspackages/runner/src/runtime.tsspaceCellSchema now includes suggestionHistory array under defaultPattern.properties with result (asCell:true), messages, and timestamp fields. Next steps: update default-app.tsx to write to suggestionHistory on presentResult, create suggestion-history.tsx viewer pattern.Wd^�彔M�sf*�Za1 ������� 1786b873 678f04a0 2080c0c7 27df7ec1 61b4fe48  6407a690 =Wd^�彔Mu���� ;;}\��� 30a3de5a82026-03-17 22:43:29 30a3de5a82026-03-17 02:49:05 30a3de5a82026-03-17 02:49:05 30a3de5a82026-03-17 02:47:44 30a3de5a82026-03-17 02:08:563 0a3de5a82026-03-17 02:08:09Wd^�彔M�� V�&6� T � A����P 3#�U[�#8cf540040a3de5a82026-03-17 22:43:30implementerWired searchHistory tool in suggestion.tsx: import from suggestion-history.tsx, wish for historyEntries, patternTool in llmDialog tools, and step 0 in system promptpackages/patterns/system/suggestion.tsxAll implementation steps complete: runtime.ts spaceCellSchema, wish.ts #suggestions, suggestion-history.tsx viewer pattern, and suggestion.tsx searchHistory wiring. The full feature is ready for testing.�8 3#�-aM�U1786b8730a3de5a82026-03-17 22:43:29implementerAdded spaceCellSchema import and suggestion history write block to llm-dialog.tspackages/runner/src/builtins/llm-dialog.tsNone - type check passes cleanlyNext steps: (1) Add suggestionHistory to default-app.tsx with Writable.of and ct-cell-link toolbar entry; (2) Wire up searchHistory tool in suggestion.tsx using searchPattern from suggestion-history.tsx�+ 3#}U� �;678f04a00a3de5a82026-03-17 02:49:05implementerConfirmed type check passes cleanly after wish.ts changepackages/runner/src/builtins/wish.tsStop hook showed TS errors in suggestion-history.tsx but those were pre-existing; current deno task check passes with 0 errorsBoth runtime.ts (spaceCellSchema with suggestionHistory) and wish.ts (#suggestions pathForKey) are in place. Next steps in the plan: llm-dialog.ts write block to persist entries, default-app.tsx to wire up SuggestionHistory pattern, suggestion.tsx to import and use searchPattern�~ 3#�Ek��{2080c0c70a3de5a82026-03-17 02:49:05implementerCreated suggestion-history.tsx pattern with SuggestionHistoryEntry type, extractSituation helper, searchPattern export, and SuggestionHistory default exportpackages/patterns/system/suggestion-history.tsxLinter simplified result type from Writable<{ cell: Writable }> to Writable. Type check passes cleanly with deno check.Next steps: (1) Add suggestionHistory to default-app.tsx with Writable.of and ct-cell-link toolbar entry; (2) Wire up in suggestion.tsx with searchHistory tool; (3) Update runtime.ts spaceCellSchema and wish.ts pathForKey with #suggestions mapping�> 3#�+k�27df7ec10a3de5a82026-03-17 02:47:44implementerFixed type errors in suggestion-history.tsx triggered by spaceCellSchema changepackages/patterns/system/suggestion-history.tsxTwo type fixes: (1) SuggestionHistoryEntry.result changed from Writable<{cell:Writable}> to Writable since the schema stores result as a direct cellified object, not a wrapper; (2) cast on line 70 goes through 'unknown' to handle OpaqueCell vs Writable mismatch; (3) line 116 now uses e.result directly instead of e.result?.cell. deno fmt also applied. Both files pass deno check.�O 3#cU�1�u61b4fe480a3de5a82026-03-17 02:08:56implementerAdded #suggestions to pathForKey in wish.tspackages/runner/src/builtins/wish.tsNo plan_steps rows exist in DB; --step flag omitted to avoid FK constraint failureThe #suggestions key now maps to ['defaultPattern', 'suggestionHistory'], consistent with #allPieces and #recent. Other steps in the plan (runtime.ts spaceCellSchema, llm-dialog.ts write, default-app.tsx, suggestion-history.tsx pattern) remain.�) 3#�I�-6407a6900a3de5a82026-03-17 02:08:09implementerAdded suggestionHistory property to spaceCellSchema in runtime.tspackages/runner/src/runtime.tsspaceCellSchema now includes suggestionHistory array under defaultPattern.properties with result (asCell:true), messages, and timestamp fields. Next steps: update default-app.tsx to write to suggestionHistory on presentResult, create suggestion-history.tsx viewer pattern.Wd^�彔M &�*M�z� �������� 8cf54004 1786b873 678f04a0 2080c0c7 27df7ec1 61b4fe48  6407a690 =Wd^�彔M,��ٔ�� ;}\��� 30a3de5a82026-03-17 22:43:30 30a3de5a82026-03-17 22:43:29 30a3de5a82026-03-17 02:49:05 30a3de5a82026-03-17 02:49:05 30a3de5a82026-03-17 02:47:44 30a3de5a82026-03-17 02:08:563 0a3de5a82026-03-17 02:08:09Wd^�彔M���5m���SQLite format 3@ >/.zp�/�� - � � �  g` ��)Jx�h�77/Cindexsqlite_autoindex_next_ups_1next_ups�\##�tablebug_reportsbug_reportsCREATE TABLE bug_reports ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), title TEXT NOT NULL, repro_steps TEXT NOT NULL, evidence TEXT, status TEXT DEFAULT 'open' CHECK(status IN ('open', 'resolved', 'wontfix')) )5I#indexsqlite_autoindex_bug_reports_1bug_reports�##�ktablecorrectionscorrectionsCREATE TABLE corrections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), mistake TEXT NOT NULL, symptoms TEXT, resolution TEXT, tags TEXT )5I#indexsqlite_autoindex_corrections_1corrections�+##�tablereflectionsreflectionsCREATE TABLE reflections ( id TEXT PRIMARY KEY, plan_id TEXT REFERENCES plans(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), trigger TEXT CHECK(trigger IN ('manual', 'compact', 'completion', 'stop')), content TEXT NOT NULL )5I#indexsqlite_autoindex_reflections_1reflections�w ##�5tablebreadcrumbsbreadcrumbsCREATE TABLE breadcrumbs ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_id TEXT REFERENCES plan_steps(id) ON DELETE SET NULL, created_at TEXT DEFAULT (datetime('now')), agent_type TEXT, summary TEXT NOT NULL, files_touched TEXT, issues TEXT, next_context TEXT )5I#indexsqlite_autoindex_breadcrumbs_1breadcrumbs�v !!�7tableplan_stepsplan_steps CREATE TABLE plan_steps ( id TEXT PRIMARY KEY, plan_id TEXT NOT NULL REFERENCES plans(id) ON DELETE CASCADE, step_order INTEGER NOT NULL, description TEXT NOT NULL, status TEXT DEFAULT 'pending' CHECK(status IN ('pending', 'in_progress', 'completed', 'failed', 'skipped')), created_at TEXT DEFAULT (datetime('now')) )3 G!indexsqlite_autoindex_plan_steps_1plan_steps �V � tableplansplans CREATE TABLE plans ( id TEXT PRIMARY KEY, created_at TEXT DEFAULT (datetime('now')), status TEXT DEFAULT 'accepted' CHECK(status IN ('accepted', 'in_progress', 'completed', 'abandoned')), description TEXT, plan_markdown TEXT NOT NULL, session_id TEXT, thread_id TEXT REFERENCES threads(id) )) =indexsqlite_autoindex_plans_1plans �++�Ctablethread_sessionsthread_sessionsCREATE TABLE thread_sessions ( thread_id TEXT NOT NULL REFERENCES threads(id) ON DELETE CASCADE, session_id TEXT NOT NULL, created_at TEXT DEFAULT (datetime('now')), PRIMARY KEY (thread_id, session_id) )=Q+indexsqlite_autoindex_thread_sessions_1thread_sessions Q-iindexidx_threads_namethreadsCREATE INDEX idx_threads_name ON threads(name)W1qindexidx_threads_statusthreadsCREATE INDEX idx_threads_status ON threads(status)c3�indexidx_threads_updatedthreadsCREATE INDEX idx_threads_updated ON threads(updated_at DESC)�,�/tablethreadsthreadsCREATE TABLE threads ( id TEXT PRIMARY KEY, name TEXT NOT NULL UNIQUE, created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')), current_plan_id TEXT REFERENCES plans(id), git_branches TEXT, status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active', 'paused', 'completed', 'archived')) )-Aindexsqlite_autoindex_threads_2threads-Aindexsqlite_autoindex_threads_1thread+Wd^�彔MW-��v!��>�����P 3#�U[�#8cf540040a3de5a82026-03-17 22:43:30implementerWired searchHistory tool in suggestion.tsx: import from suggestion-history.tsx, wish for historyEntries, patternTool in llmDialog tools, and step 0 in system promptpackages/patterns/system/suggestion.tsxAll implementation steps complete: runtime.ts spaceCellSchema, wish.ts #suggestions, suggestion-history.tsx viewer pattern, and suggestion.tsx searchHistory wiring. The full feature is ready for testing.�8 3#�-aM�U1786b8730a3de5a82026-03-17 22:43:29implementerAdded spaceCellSchema import and suggestion history write block to llm-dialog.tspackages/runner/src/builtins/llm-dialog.tsNone - type check passes cleanlyNext steps: (1) Add suggestionHistory to default-app.tsx with Writable.of and ct-cell-link toolbar entry; (2) Wire up searchHistory tool in suggestion.tsx using searchPattern from suggestion-history.tsx�+ 3#}U� �;678f04a00a3de5a82026-03-17 02:49:05implementerConfirmed type check passes cleanly after wish.ts changepackages/runner/src/builtins/wish.tsStop hook showed TS errors in suggestion-history.tsx but those were pre-existing; current deno task check passes with 0 errorsBoth runtime.ts (spaceCellSchema with suggestionHistory) and wish.ts (#suggestions pathForKey) are in place. Next steps in the plan: llm-dialog.ts write block to persist entries, default-app.tsx to wire up SuggestionHistory pattern, suggestion.tsx to import and use searchPattern�~ 3#�Ek��{2080c0c70a3de5a82026-03-17 02:49:05implementerCreated suggestion-history.tsx pattern with SuggestionHistoryEntry type, extractSituation helper, searchPattern export, and SuggestionHistory default exportpackages/patterns/system/suggestion-history.tsxLinter simplified result type from Writable<{ cell: Writable }> to Writable. Type check passes cleanly with deno check.Next steps: (1) Add suggestionHistory to default-app.tsx with Writable.of and ct-cell-link toolbar entry; (2) Wire up in suggestion.tsx with searchHistory tool; (3) Update runtime.ts spaceCellSchema and wish.ts pathForKey with #suggestions mapping�> 3#�+k�27df7ec10a3de5a82026-03-17 02:47:44implementerFixed type errors in suggestion-history.tsx triggered by spaceCellSchema changepackages/patterns/system/suggestion-history.tsxTwo type fixes: (1) SuggestionHistoryEntry.result changed from Writable<{cell:Writable}> to Writable since the schema stores result as a direct cellified object, not a wrapper; (2) cast on line 70 goes through 'unknown' to handle OpaqueCell vs Writable mismatch; (3) line 116 now uses e.result directly instead of e.result?.cell. deno fmt also applied. Both files pass deno check.�O 3#cU�1�u61b4fe480a3de5a82026-03-17 02:08:56implementerAdded #suggestions to pathForKey in wish.tspackages/runner/src/builtins/wish.tsNo plan_steps rows exist in DB; --step flag omitted to avoid FK constraint failureThe #suggestions key now maps to ['defaultPattern', 'suggestionHistory'], consistent with #allPieces and #recent. Other steps in the plan (runtime.ts spaceCellSchema, llm-dialog.ts write, default-app.tsx, suggestion-history.tsx pattern) remain.�) 3#�I�-6407a6900a3de5a82026-03-17 02:08:09implementerAdded suggestionHistory property to spaceCellSchema in runtime.tspackages/runner/src/runtime.tsspaceCellSchema now includes suggestionHistory array under defaultPattern.properties with result (asCell:true), messages, and timestamp fields. Next steps: update default-app.tsx to write to suggestionHistory on presentResult, create suggestion-history.tsx viewer pat'Wd^�彔M�"�� t� ��������� baa59bf3 8cf54004 1786b873 678f04a0 2080c0c7 27df7ec1 61b4fe48  6407a690 Wd^�彔Mxx�ۈ�� ��;}\��� 30a3de5a82026-03-17 22:45:57 30a3de5a82026-03-17 22:43:30 30a3de5a82026-03-17 22:43:29 30a3de5a82026-03-17 02:49:05 30a3de5a82026-03-17 02:49:05 30a3de5a82026-03-17 02:47:44 30a3de5a82026-03-17 02:08:563 0a3de5a82026-03-17 02:08:09'Wd^�彔M��Ǘ���� T � A����P 3#�U[�#8cf540040a3de5a82026-03-17 22:43:30implementerWired searchHistory tool in suggestion.tsx: import from suggestion-history.tsx, wish for historyEntries, patternTool in llmDialog tools, and step 0 in system promptpackages/patterns/system/suggestion.tsxAll implementation steps complete: runtime.ts spaceCellSchema, wish.ts #suggestions, suggestion-history.tsx viewer pattern, and suggestion.tsx searchHistory wiring. The full feature is ready for testing.�8 3#�-aM�U1786b8730a3de5a82026-03-17 22:43:29implementerAdded spaceCellSchema import and suggestion history write block to llm-dialog.tspackages/runner/src/builtins/llm-dialog.tsNone - type check passes cleanlyNext steps: (1) Add suggestionHistory to default-app.tsx with Writable.of and ct-cell-link toolbar entry; (2) Wire up searchHistory tool in suggestion.tsx using searchPattern from suggestion-history.tsx�+ 3#}U� �;678f04a00a3de5a82026-03-17 02:49:05implementerConfirmed type check passes cleanly after wish.ts changepackages/runner/src/builtins/wish.tsStop hook showed TS errors in suggestion-history.tsx but those were pre-existing; current deno task check passes with 0 errorsBoth runtime.ts (spaceCellSchema with suggestionHistory) and wish.ts (#suggestions pathForKey) are in place. Next steps in the plan: llm-dialog.ts write block to persist entries, default-app.tsx to wire up SuggestionHistory pattern, suggestion.tsx to import and use searchPattern�~ 3#�Ek��{2080c0c70a3de5a82026-03-17 02:49:05implementerCreated suggestion-history.tsx pattern with SuggestionHistoryEntry type, extractSituation helper, searchPattern export, and SuggestionHistory default exportpackages/patterns/system/suggestion-history.tsxLinter simplified result type from Writable<{ cell: Writable }> to Writable. Type check passes cleanly with deno check.Next steps: (1) Add suggestionHistory to default-app.tsx with Writable.of and ct-cell-link toolbar entry; (2) Wire up in suggestion.tsx with searchHistory tool; (3) Update runtime.ts spaceCellSchema and wish.ts pathForKey with #suggestions mapping�> 3#�+k�27df7ec10a3de5a82026-03-17 02:47:44implementerFixed type errors in suggestion-history.tsx triggered by spaceCellSchema changepackages/patterns/system/suggestion-history.tsxTwo type fixes: (1) SuggestionHistoryEntry.result changed from Writable<{cell:Writable}> to Writable since the schema stores result as a direct cellified object, not a wrapper; (2) cast on line 70 goes through 'unknown' to handle OpaqueCell vs Writable mismatch; (3) line 116 now uses e.result directly instead of e.result?.cell. deno fmt also applied. Both files pass deno check.�O 3#cU�1�u61b4fe480a3de5a82026-03-17 02:08:56implementerAdded #suggestions to pathForKey in wish.tspackages/runner/src/builtins/wish.tsNo plan_steps rows exist in DB; --step flag omitted to avoid FK constraint failureThe #suggestions key now maps to ['defaultPattern', 'suggestionHistory'], consistent with #allPieces and #recent. Other steps in the plan (runtime.ts spaceCellSchema, llm-dialog.ts write, default-app.tsx, suggestion-history.tsx pattern) remain.�) 3#�I�-6407a6900a3de5a82026-03-17 02:08:09implementerAdded suggestionHistory property to spaceCellSchema in runtime.tspackages/runner/src/runtime.tsspaceCellSchema now includes suggestionHistory array under defaultPattern.properties with result (asCell:true), messages, and timestamp fields. Next steps: update default-app.tsx to write to suggestionHistory on presentResult, create suggestion-history.tsx viewer pattern.>>Wd^�彔M:��In%-�  � �� 3#�]�gbaa59bf30a3de5a82026-03-17 22:45:57implementerUpdated default-app.tsx with SuggestionHistory integration: added import, created suggestionHistory Writable cell and suggestionHistoryViewer pattern instance, added History toolbar link, and exported suggestionHistory in return object. deno task check passes.packages/patterns/system/default-app.tsxnonesuggestionHistory cell is now exported from default-app. Next steps: wire suggestion.tsx to push entries into the space-wide suggestionHistory cell when presentResult fires.Wd^�彔M]+����� �113selected_thread_ida2cf6aeb2026-03-17 01:46:23>Wd^�彔M ��{L| �1 selected_thread_id