SQLite format 3@  ,)
D

.���*��
�
|
�^:
�
�
3����w��V��
�tablethreadsthreadsCREATE TABLE threads (
    id TEXT PRIMARY KEY,
    rollout_path TEXT NOT NULL,
    created_at INTEGER NOT NULL,
    updated_at INTEGER NOT NULL,
    source TEXT NOT NULL,
    model_provider TEXT NOT NULL,
    cwd TEXT NOT NULL,
    title TEXT NOT NULL,
    sandbox_policy TEXT NOT NULL,
    approval_mode TEXT NOT NULL,
    tokens_used INTEGER NOT NULL DEFAULT 0,
    has_user_event INTEGER NOT NULL DEFAULT 0,
    archived INTEGER NOT NULL DEFAULT 0,
    archived_at INTEGER,
    git_sha TEXT,
    git_branch TEXT,
    git_origin_url TEXT
, cli_version TEXT NOT NULL DEFAULT '', first_user_message TEXT NOT NULL DEFAULT '')�M
�Kindexidx_jobs_kind_status_retry_leasejobsCREATE INDEX idx_jobs_kind_status_retry_lease
    ON jobs(kind, status, retry_at, lease_until)';
indexsqlite_autoindex_jobs_1jobs�0
�CtablejobsjobsCREATE TABLE jobs (
    kind TEXT NOT NULL,
    job_key TEXT NOT NULL,
    status TEXT NOT NULL,
    worker_id TEXT,
    ownership_token TEXT,
    started_at INTEGER,
    finished_at INTEGER,
    lease_until INTEGER,
    retry_at INTEGER,
    retry_remaining INTEGER NOT NULL,
    last_error TEXT,
    input_watermark INTEGER,
    last_success_watermark INTEGER,
    PRIMARY KEY (kind, job_key)
)�/U)
�mindexidx_stage1_outputs_source_updated_atstage1_outputsCREATE INDEX idx_stage1_outputs_source_updated_at
    ON stage1_outputs(source_updated_at DESC, thread_id DESC);O)
indexsqlite_autoindex_stage1_outputs_1stage1_outputs�?))
�9tablestage1_outputsstage1_outputsCREATE TABLE stage1_outputs (
    thread_id TEXT PRIMARY KEY,
    source_updated_at INTEGER NOT NULL,
    raw_memory TEXT NOT NULL,
    rollout_summary TEXT NOT NULL,
    generated_at INTEGER NOT NULL,
    FOREIGN KEY(thread_id) REFERENCES threads(id) ON DELETE CASCADE
)�K5
�+indexidx_thread_dynamic_tools_threadthread_dynamic_toolsCREATE INDEX idx_thread_dynamic_tools_thread ON thread_dynamic_tools(thread_id)G[5
indexsqlite_autoindex_thread_dynamic_tools_1thread_dynamic_tools�_55
�atablethread_dynamic_toolsthread_dynamic_toolsCREATE TABLE thread_dynamic_tools (
    thread_id TEXT NOT NULL,
    position INTEGER NOT NULL,
    name TEXT NOT NULL,
    description TEXT NOT NULL,
    input_schema TEXT NOT NULL,
    PRIMARY KEY(thread_id, position),
    FOREIGN KEY(thread_id) REFERENCES threads(id) ON DELETE CASCADE
)T
1
qindexidx_logs_thread_idlogsCREATE INDEX idx_logs_thread_id ON logs(thread_id)]#
�indexidx_logs_tslogsCREATE INDEX idx_logs_ts ON logs(ts DESC, ts_nanos DESC, id DESC)P++
Ytablesqlite_sequencesqlite_sequence
CREATE TABLE sqlite_sequence(name,seq)�!

�%tablelogslogsCREATE TABLE logs (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    ts INTEGER NOT NULL,
    ts_nanos INTEGER NOT NULL,
    level TEXT NOT NULL,
    target TEXT NOT NULL,
    message TEXT,
    module_path TEXT,
    file TEXT,
    line INTEGER
, thread_id TEXT)d	5
�indexidx_threads_providerthreadsCREATE INDEX idx_threads_provider ON threads(model_provider)W1
qindexidx_threads_sourcethreads
CREATE INDEX idx_threads_source ON threads(source)]5
yindexidx_threads_archivedthreads	CREATE INDEX idx_threads_archived ON threads(archived)r9
�indexidx_threads_updated_atthreadsCREATE INDEX idx_threads_updated_at ON threads(updated_at DESC, id DESC)r9
�indexidx_threads_created_atthreadsCREATE INDEX idx_threads_created_at ON threads(created_at DESC, id DESC)-A
indexsqlite_autoindex_threads_1threads?S-
indexsqlite_autoindex__sqlx_migrations_1_sqlx_migrations�)
--
�table_sqlx_migrations_sqlx_migrationsCREATE TABLE _sqlx_migrations (
    version BIGINT PRIMARY KEY,
    description TEXT NOT NULL,
    installed_on TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    success BOOLEAN NOT NULL,
    checksum BLOB NOT NULL,
    execution_time BIGINT ,#+
































#`�V��1
�
o
�G�w
�
I	�	�	�?�{"�P�z�V��#�``#
13	l#drop memory tables2026-06-03 02:04:23Q� �D��>�����~���<�F��E�i��d;m:������F�^�<_"
/3	l"drop thread goals2026-06-03 02:04:23C֏�P2�,y�1rljԼz;�-�Iz�k���^O�=j�iWD�7Y��,	j!
E3	l!thread goal stopped statuses2026-06-03 02:04:23��U����a��{R��U�}�v�$e�"��d_���������a�=�] 
+3	l threads preview2026-06-03 02:04:23�Ӡy�8��Lķ�c�[^K#�)ױ�o>rZ�wf~#v��u��p�j����f
=3	ldrop device key bindings2026-06-03 02:04:23p�|qqB uso�,e�C�����
��#5���=���aK��������0��(c
73	lthreads thread source2026-06-03 02:04:23�I6����2���#�{֟C�j�;A�MQ{dV[t�Cz(#^7�Y�k#�$n�Z
%3	lthread goals2026-06-03 02:04:23H�tV1�톅��چ��qh[������t��80���gQ�YU���!	(����a
33	ldevice key bindings2026-06-03 02:04:23܉�`r�p���S��s��cM����난�h��o��a����V��!�f
=3	lthreads cwd sort indexes2026-06-03 02:04:23�t&�!�ȍ�UJo�V��g`ChG���ʨG�.�U}�F>�\<�΅�l
I3	lthread dynamic tools namespace2026-06-03 02:04:23��"6�QF�Fk��s���_�]�ؗ^�.,@=�-��a�\WD��f
=3	lthread timestamps millis2026-06-03 02:04:23ɹ����ၴ���k1I�6|�l������:a|H��/�V� �0h
A3	lremote control enrollments2026-06-03 02:04:23&�T�����7
|���v�1�������h�|%�̖Pd�m�bRe��W
3	ldrop logs2026-06-03 02:04:23�N]ߢ��(�R��6�y��U'������p,�A�õ�8-S��l�����`
13	lthreads agent path2026-06-03 02:04:23I�r]�(d�wĂ��h?O�KX]��ͧ�y6E�X��*� ��j�@`
13	lthread spawn edges2026-06-03 02:04:23�<��`�<�Ӝ������?��P%�K̨�����y�Ͳ�Ώ�<<�J�
D l
I3	lthreads model reasoning effort2026-06-03 02:04:23�w�g���a�]S�?Ӄ��M�eh��t��K?k�0�
���G���L�:�p
Q3	lthread dynamic tools defer loading2026-06-03 02:04:23W�k�6�J�m��6���i��i���Ux들&]��n�Έ�_�7KaW
�$g
?3	lphase2 selection snapshot2026-06-03 02:04:23Rɂ�M��\e�zP:�����1}(M�$�����sF�'8|{YWj*q�,[�c
73	lphase2 selection flag2026-06-03 02:04:23o�*U Z���͢ȉvm�aG7�1�tDƂO=ER���S.[t���.��&��Z
%3	lmemory usage2026-06-03 02:04:23��l��YH��UC�X��kx���%-W#�Y���ۼie�eY9ZH`�JG`pl
I3	lagent jobs max runtime seconds2026-06-03 02:04:23��{�c�f\w�ˁ���0�G/����bVo�:���"6Po!��Н
^
��X
!3	lagent jobs2026-06-03 02:04:23'[�k�hU%۵L7�&��f
{��U�%����m�ˎ��ud�u.9g���d

93	l
threads agent nickname2026-06-03 02:04:23����hռ���;���]<
���],<+�hY�㴅��Wgh�Y&�b
53	llogs estimated bytes2026-06-03 02:04:239̙��5�s���tɐ��6�?!�x�Щ\6zYw�,/�a� a�J��-

�j
E3	llogs partition prune indexes2026-06-03 02:04:23N27���d:�{kY]E
7P����E|۹�I7��]D��Vg�b>�^_	M
�]

+3	l
logs process id2026-06-03 02:04:23�2 �Iۑ�Dx��Pq�_w2�l�D˱dT�Q4�����tL�(0�d-u7�\i	
C3	l	stage1 outputs rollout slug2026-06-03 02:04:23J�Uk!�T��2�	���Q�=�����{�|
6tP�F�a���.��f-�
��\
)3	lbackfill state2026-06-03 02:04:23�l��H
�
��a���8R�W,D<��NX���$�t�R
�I�IQy�.���h
A3	lthreads first user message2026-06-03 02:04:23ؿ�P���E+.6�);�V��ԀP+B�8�V2��Pqo$Յ��@��	3V
3	lmemories2026-06-03 02:04:23�Py���UJ1��e	
�i��k̲uy�(m0dq�p�
x��S�*�
>�a
33	lthreads cli version2026-06-03 02:04:23[�tr`g�3�
��$u�U�Q��b��sn�
'��񰜕a�,��|�d4�3;b
53	lthread dynamic tools2026-06-03 02:04:23�T�]h��m5N�Å[{�:�N�Q�M4	�G�RS:�Rʹ�����NFh�X\
)3	llogs thread id2026-06-03 02:04:23[��Wx���/�	�n5/'8���|�UA��x/�f������
�R�wkRE<R
3	llogs2026-06-03 02:04:23O�m~�qӿ*��v�V�i�D��.��rx�@����6�9���8g�
��T
	3	lthreads2026-06-03 02:04:23T���y���tEu�=��{SNf�z��*�jKV�m���'���P#�G�(:�
#0���������������������~xrlf`ZTNHB<60

##

""

!!

  

















































		













		


S
S�.
$�*
$U�k�#��G!+��019e8b45-cbde-7e42-8d1d-913b2e4bf144C:\Users\fred\.codex\sessions\2026\06\03\rollout-2026-06-03T10-17-47-019e8b45-cbde-7e42-8d1d-913b2e4bf144.jsonlj��j�vscodeopenai\\?\C:\Users\fred\Documents\Codex\2026-06-03\my-windows-defenser-win-10-canMy windows defenser (win 10) can not update, what can you do?{"type":"managed","file_system":{"type":"restricted","entries":[{"path":{"type":"special","value":{"kind":"root"}},"access":"read"}]},"network":"restricted"}on-request�`0.136.0-alpha.2My windows defenser (win 10) can not update, what can you do?enabledgpt-5.5medium
��E��
��V;EuserMy windows defenser (win 10) can not update, what can you do?

��'U	019e8b45-cbde-7e42-8d1d-913b2e4bf144

��,U	j��019e8b45-cbde-7e42-8d1d-913b2e4bf144

��,U	j�019e8b45-cbde-7e42-8d1d-913b2e4bf144

��	

��		vscode

��		openai










��.U	
��E��019e8b45-cbde-7e42-8d1d-913b2e4bf144

��.U	
��V;E019e8b45-cbde-7e42-8d1d-913b2e4bf144

���Zd
�
|
�^1	X�<
�
B�
	��0
�CtablejobsjobsCREATE TABLE jobs (
    kind TEXT NOT NULL,
    job_key TEXT NOT NULL,
    status TEXT NOT NULL,
    worker_id TEXT,
    ownership_token TEXT,
    started_at INTEGER,
    finished_at INTEGER,
    lease_until INTEGER,
    retry_at INTEGER,
    retry_remaining INTEGER NOT NULL,
    last_error TEXT,
    input_watermark INTEGER,
    last_success_watermark INTEGER,
    PRIMARY KEY (kind, job_key)
)�S
�}tablethreadsthreadsCREATE TABLE threads (
    id TEXT PRIMARY KEY,
    rollout_path TEXT NOT NULL,
    created_at INTEGER NOT NULL,
    updated_at INTEGER NOT NULL,
    source TEXT NOT NULL,
    model_provider TEXT NOT NULL,
    cwd TEXT NOT NULL,
    title TEXT NOT NULL,
    sandbox_policy TEXT NOT NULL,
    approval_mode TEXT NOT NULL,
    tokens_used INTEGER NOT NULL DEFAULT 0,
    has_user_event INTEGER NOT NULL DEFAULT 0,
    archived INTEGER NOT NULL DEFAULT 0,
    archived_at INTEGER,
    git_sha TEXT,
    git_branch TEXT,
    git_origin_url TEXT
, cli_version TEXT NOT NULL DEFAULT '', first_user_message TEXT NOT NULL DEFAULT '', agent_nickname TEXT, agent_role TEXT, memory_mode TEXT NOT NULL DEFAULT 'enabled', model TEXT, reasoning_effort TEXT, agent_path TEXT, created_at_ms INTEGER, updated_at_ms INTEGER)	
�55
�5tablethread_dynamic_toolsthread_dynamic_toolsCREATE TABLE thread_dynamic_tools (
    thread_id TEXT NOT NULL,
    position INTEGER NOT NULL,
    name TEXT NOT NULL,
    description TEXT NOT NULL,
    input_schema TEXT NOT NULL, defer_loading INTEGER NOT NULL DEFAULT 0,
    PRIMARY KEY(thread_id, position),
    FOREIGN KEY(thread_id) REFERENCES threads(id) ON DELETE CASCADE
)�Z))
�otablestage1_outputsstage1_outputsCREATE TABLE stage1_outputs (
    thread_id TEXT PRIMARY KEY,
    source_updated_at INTEGER NOT NULL,
    raw_memory TEXT NOT NULL,
    rollout_summary TEXT NOT NULL,
    generated_at INTEGER NOT NULL, rollout_slug TEXT, usage_count INTEGER, last_usage INTEGER, selected_for_phase2 INTEGER NOT NULL DEFAULT 0, selected_for_phase2_source_updated_at INTEGER,
    FOREIGN KEY(thread_id) REFERENCES threads(id) ON DELETE CASCADE
)?
�#tablelogslogsCREATE TABLE logs (
    id INTEGER PRI�55
�Utablethread_dynamic_toolsthread_dynamic_toolsCREATE TABLE thread_dynamic_tools (
    thread_id TEXT NOT NULL,
    position INTEGER NOT NULL,
    name TEXT NOT NULL,
    description TEXT NOT NULL,
    input_schema TEXT NOT NULL, defer_loading INTEGER NOT NULL DEFAULT 0, namespace TEXT,
    PRIMARY KEY(thread_id, position),
    FOREIGN KEY(thread_id) REFERENCES threads(id) ON DELETE CASCADE
);O)
indexsqlite_autoindex_stage1_outputs_1stage1_outputsP++
Ytablesqlite_sequencesqlite_sequence
CREATE TABLE sqlite_sequence(name,seq)�K5
�+indexidx_thread_dynamic_tools_threadthread_dynamic_toolsCREATE INDEX idx_thread_dynamic_tools_thread ON thread_dynamic_tools(thread_id)G[5
indexsqlite_autoindex_thread_dynamic_tools_1thread_dynamic_toolsd	5
�indexidx_threads_providerthreadsCREATE INDEX idx_threads_provider ON threads(model_provider)W1
qindexidx_threads_sourcethreads
CREATE INDEX idx_threads_source ON threads(source)]5
yindexidx_threads_archivedthreads	CREATE INDEX idx_threads_archived ON threads(archived)r9
�indexidx_threads_updated_atthreadsCREATE INDEX idx_threads_updated_at ON threads(updated_at DESC, id DESC)r9
�indexidx_threads_created_atthreadsCREATE INDEX idx_threads_created_at ON threads(created_at DESC, id DESC)-A
indexsqlite_autoindex_threads_1threads?S-
indexsqlite_autoindex__sqlx_migrations_1_sqlx_migrations�)
--
�table_sqlx_migrations_sqlx_migrationsCREATE TABLE _sqlx_migrations (
    version BIGINT PRIMARY KEY,
    description TEXT NOT NULL,
    installed_on TIMESTAMP NOT N|�#U	\\?\C:\Users\fred\Documents\Codex\2026-06-03\my-windows-defenser-win-10-can
��E��019e8b45-cbde-7e42-8d1d-913b2e4bf144

��$#"! |�#U	\\?\C:\Users\fred\Documents\Codex\2026-06-03\my-windows-defenser-win-10-can
��V;E019e8b45-cbde-7e42-8d1d-913b2e4bf144

��
completej��j��
���d
�
|
�^	1
�
|��<�
�tablethreadsthreadsCREATE TABLE threads (
    id TEXT PRIMARY KEY,
    rollout_path TEXT NOT NULL,
    created_at INTEGER NOT NULL,
    updated_at INTEGER NOT NULL,
    source TEXT NOT NULL,
    model_provider TEXT NOT NULL,
    cwd TEXT NOT NULL,
    title TEXT NOT NULL,
    sandbox_policy TEXT NOT NULL,
    approval_mode TEXT NOT NULL,
    tokens_used INTEGER NOT NULL DEFAULT 0,
    has_user_event INTEGER NOT NULL DEFAULT 0,
    archived INTEGER NOT NULL DEFAULT 0,
    archived_at INTEGER,
    git_sha TEXT,
    git_branch TEXT,
    git_origin_url TEXT
, cli_version TEXT NOT NULL DEFAULT '', first_user_message TEXT NOT NULL DEFAULT '', agent_nickname TEXT, agent_role TEXT, memory_mode TEXT NOT NULL DEFAULT 'enabled', model TEXT, reasoning_effort TEXT)�	55
�5tablethread_dynamic_toolsthread_dynamic_toolsCREATE TABLE thread_dynamic_tools (
    thread_id TEXT NOT NULL,
    position INTEGER NOT NULL,
    name TEXT NOT NULL,
    description TEXT NOT NULL,
    input_schema TEXT NOT NULL, defer_loading INTEGER NOT NULL DEFAULT 0,
    PRIMARY KEY(thread_id, position),
    FOREIGN KEY(thread_id) REFERENCES threads(id) ON DELETE CASCADE
)�Z))
�otablestage1_outputsstage1_outputsCREATE TABLE stage1_outputs (
    thread_id TEXT PRIMARY KEY,
    source_updated_at INTEGER NOT NULL,
    raw_memory TEXT NOT NULL,
    rollout_summary TEXT NOT NULL,
    generated_at INTEGER NOT NULL, rollout_slug TEXT, usage_count INTEGER, last_usage INTEGER, selected_for_phase2 INTEGER NOT NULL DEFAULT 0, selected_for_phase2_source_updated_at INTEGER,
    FOREIGN KEY(thread_id) REFERENCES threads(id) ON DELETE CASCADE
)�`

�#tablelogslogsCREATE TABLE logs (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    ts INTEGER NOT NULL,
    ts_nanos INTEGER NOT NULL,
    level TEXT NOT NULL,
    target TEXT NOT NULL,
    message TEXT,
    module_path TEXT,
    file TEXT,
    line INTEGER
, thread_id TEXT, process_uuid TEXT, estimated_bytes INTEGER NOT NULL DEFAULT 0)T
1
qindexidx_logs_thread_idlogsCREATE INDEX idx_logs_thread_id ON logs(thread_id)]#
�indexidx_logs_tslogsCREATE INDEX idx_logs_ts ON logs(ts DESC, ts_nanos DESC, id DESC)P++
Ytablesqlite_sequencesqlite_sequence
CREATE TABLE sqlite_sequence(name,seq)�K5
�+indexidx_thread_dynamic_tools_threadthread_dynamic_toolsCREATE INDEX idx_thread_dynamic_tools_thread ON thread_dynamic_tools(thread_id)G[5
indexsqlite_autoindex_thread_dynamic_tools_1thread_dynamic_toolsd	5
�indexidx_threads_providerthreadsCREATE INDEX idx_threads_provider ON threads(model_provider)W1
qindexidx_threads_sourcethreads
CREATE INDEX idx_threads_source ON threads(source)]5
yindexidx_threads_archivedthreads	CREATE INDEX idx_threads_archived ON threads(archived)r9
�indexidx_threads_updated_atthreadsCREATE INDEX idx_threads_updated_at ON threads(updated_at DESC, id DESC)r9
�indexidx_threads_created_atthreadsCREATE INDEX idx_threads_created_at ON threads(created_at DESC, id DESC)-A
indexsqlite_autoindex_threads_1threads?S-
indexsqlite_autoindex__sqlx_migrations_1_sqlx_migrations�)
--
�table_sqlx_migrations_sqlx_migrationsCREATE TABLE _sqlx_migrations (
    version BIGINT PRIMARY KEY,
    description TEXT NOT NULL,
    installed_on TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    success BOOLEAN NOT NULL,
    checksum BLOB NOT NULL,
    execution_time BIGINT NOT NULL
)

��!
�
e	y	���`!��+))
�tablestage1_outputsstage1_outputsCREATE TABLE stage1_outputs (
    thread_id TEXT PRIMARY KEY,
    source_updated_at INTEGER NOT NULL,
    raw_memory TEXT NOT NULL,
    rollout_summary TEXT NOT NULL,
    generated_at INTEGER NOT NULL, rollout_slug TEXT, usage_count INTEGER, last_usage INTEGER, selected_for_phase2 INTEGER NOT NULL DEFAULT 0,
    FOREIGN KEY(thread_id) REFERENCES threads(id) ON DELETE CASCADE
)�!!
�gtableagent_jobsagent_jobsCREATE TABLE agent_jobs (
    id TEXT PRIMARY KEY,
    name TEXT NOT NULL,
    status TEXT NOT NULL,
    instruction TEXT NOT NULL,
    output_schema_json TEXT,
    input_headers_json TEXT NOT NULL,
    input_csv_path TEXT NOT NULL,
    output_csv_path TEXT NOT NULL,
    auto_export INTEGER NOT NULL DEFAULT 1,
    created_at INTEGER NOT NULL,
    updated_at INTEGER NOT NULL,
    started_at INTEGER,
    completed_at INTEGER,
    last_error TEXT
, max_runtime_seconds INTEGER)� A+
�?indexidx_agent_job_items_statusagent_job_items"CREATE INDEX idx_agent_job_items_status ON agent_job_items(job_id, status, row_index ASC)u7!
�indexidx_agent_jobs_statusagent_jobs!CREATE INDEX idx_agent_jobs_status ON agent_jobs(status, updated_at DESC)=Q+
indexsqlite_autoindex_agent_job_items_1agent_job_items �M++
�Qtableagent_job_itemsagent_job_itemsCREATE TABLE agent_job_items (
    job_id TEXT NOT NULL,
    item_id TEXT NOT NULL,
    row_index INTEGER NOT NULL,
    source_id TEXT,
    row_json TEXT NOT NULL,
    status TEXT NOT NULL,
    assigned_thread_id TEXT,
    attempt_count INTEGER NOT NULL DEFAULT 0,
    result_json TEXT,
    last_error TEXT,
    created_at INTEGER NOT NULL,
    updated_at INTEGER NOT NULL,
    completed_at INTEGER,
    reported_at INTEGER,
    PRIMARY KEY (job_id, item_id),
    FOREIGN KEY(job_id) REFERENCES agent_jobs(id) ON DELETE CASCADE
)3G!
indexsqlite_autoindex_agent_jobs_1agent_jobs�4S
�
indexidx_logs_process_uuid_threadless_tslogsCREATE INDEX idx_logs_process_uuid_threadless_ts ON logs(process_uuid, ts DESC, ts_nanos DESC, id DESC)
WHERE thread_id IS NULL|7
�9indexidx_logs_thread_id_tslogsCREATE INDEX idx_logs_thread_id_ts ON logs(thread_id, ts DESC, ts_nanos DESC, id DESC)]7
}indexidx_logs_process_uuidlogsCREATE INDEX idx_logs_process_uuid ON logs(process_uuid)�i))
�
tablebackfill_statebackfill_stateCREATE TABLE backfill_state (
    id INTEGER PRIMARY KEY CHECK (id = 1),
    status TEXT NOT NULL,
    last_watermark TEXT,
    last_success_at INTEGER,
    updated_at INTEGER NOT NULL
)�M
�Kindexidx_jobs_kind_status_retry_leasejobsCREATE INDEX idx_jobs_kind_status_retry_lease
    ON jobs(kind, status, retry_at, lease_until)';
indexsqlite_autoindex_jobs_1jobs�0
�CtablejobsjobsCREATE TABLE jobs (
    kind TEXT NOT NULL,
    job_key TEXT NOT NULL,
    status TEXT NOT NULL,
    worker_id TEXT,
    ownership_token TEXT,
    started_at INTEGER,
    finished_at INTEGER,
    lease_until INTEGER,
    retry_at INTEGER,
    retry_remaining INTEGER NOT NULL,
    last_error TEXT,
    input_watermark INTEGER,
    last_success_watermark INTEGER,
    PRIMARY KEY (kind, job_key)
)�/U)
�mindexidx_stage1_outputs_source_updated_atstage1_outputsCREATE INDEX idx_stage1_outputs_source_updated_at
    ON stage1_outputs(source_updated_at DESC, thread_id DESC);O)
indexsqlite_autoindex_stage1_outputs_1stage1_outputs=K5
�+indexidx_thread_dynamic_tools_threadthread_dynamic_toolsCREATE INDEX idx_thread_dynamic_tools_thread ON thread_dynamic_tools(thread_id)G[5
indexsqlite_autoindex_thread_dynamic_tools_1thread_dynamic_tools�_55
�atablethread_dynamic_toolsthread_dynamic_toolsCREATE TABLE thread_dynamic_tools (
    thread_id TEXT NOT NULL,
    position INTEGER NOT NULL,
    name TEXT NOT NULL,
    description TEXT NOT NULL,
    input_schema TEXT NOT NULL,
    PRIMARY KEY(thread_id, position),
    FOREIGN KEY(thread_id) REFERENCES threads(id) ON DELETE CASCADE
)

�U
��D�	�	�	#7
d�+�4S
�
indexidx_logs_process_uuid_threadless_tslogsCREATE INDEX idx_logs_process_uuid_threadless_ts ON logs(process_uuid, ts DESC, ts_nanos DESC, id DESC)
WHERE thread_id IS NULL�R))
�_tablestage1_outputsstage1_outputsCREATE TABLE stage1_outputs (
    thread_id TEXT PRIMARY KEY,
    source_updated_at INTEGER NOT NULL,
    raw_memory TEXT NOT NULL,
    rollout_summary TEXT NOT NULL,
    generated_at INTEGER NOT NULL, rollout_slug TEXT,
    FOREIGN KEY(thread_id) REFERENCES threads(id) ON DELETE CASCADE
)�i))
�
tablebackfill_statebackfill_stateCREATE TABLE backfill_state (
    id INTEGER PRIMARY KEY CHECK (id = 1),
    status TEXT NOT NULL,
    last_watermark TEXT,
    last_success_at INTEGER,
    updated_at INTEGER NOT NULL
)�M
�Kindexidx_jobs_kind_status_retry_leasejobsCREATE INDEX idx_jobs_kind_status_retry_lease
    ON jobs(kind, status, retry_at, lease_until)';
indexsqlite_autoindex_jobs_1jobs�0
�CtablejobsjobsCREATE TABLE jobs (
    kind TEXT NOT NULL,
    job_key TEXT NOT NULL,
    status TEXT NOT NULL,
    worker_id TEXT,
    ownership_token TEXT,
    started_at INTEGER,
    finished_at INTEGER,
    lease_until INTEGER,
    retry_at INTEGER,
    retry_remaining INTEGER NOT NULL,
    last_error TEXT,
    input_watermark INTEGER,
    last_success_watermark INTEGER,
    PRIMARY KEY (kind, job_key)
)�/U)
�mindexidx_stage1_outputs_source_updated_atstage1_outputsCREATE INDEX idx_stage1_outputs_source_updated_at
    ON stage1_outputs(source_updated_at DESC, thread_id DESC);O)
indexsqlite_autoindex_stage1_outputs_1stage1_outputse))
�9tablestage1_outputsstage1_outputsCREATE TABLE stage1_outputs (
    thread_id TEXT PRIMARY|7
�9indexidx_logs_thread_id_tslogsCREATE INDEX idx_logs_thread_id_ts ON logs(thread_id, ts DESC, ts_nanos DESC, id DESC)]7
}indexidx_logs_process_uuidlogsCREATE INDEX idx_logs_process_uuid ON logs(process_uuid)�K5
�+indexidx_thread_dynamic_tools_threadthread_dynamic_toolsCREATE INDEX idx_thread_dynamic_tools_thread ON thread_dynamic_tools(thread_id)G[5
indexsqlite_autoindex_thread_dynamic_tools_1thread_dynamic_tools�_55
�atablethread_dynamic_toolsthread_dynamic_toolsCREATE TABLE thread_dynamic_tools (
    thread_id TEXT NOT NULL,
    position INTEGER NOT NULL,
    name TEXT NOT NULL,
    description TEXT NOT NULL,
    input_schema TEXT NOT NULL,
    PRIMARY KEY(thread_id, position),
    FOREIGN KEY(thread_id) REFERENCES threads(id) ON DELETE CASCADE
)
��	d
�
|
�^�
�
�
3����w��V��
�tablethreadsthreadsCREATE TABLE threads (
    id TEXT PRIMA�
�tablethreadsthreadsCREATE TABLE threads (
    id TEXT PRIMARY KEY,
    rollout_path TEXT NOT NULL,
    created_at INTEGER NOT NULL,
    updated_at INTEGER NOT NULL,
    source TEXT NOT NULL,
    model_provider TEXT NOT NULL,
    cwd TEXT NOT NULL,
    title TEXT NOT NULL,
    sandbox_policy TEXT NOT NULL,
    approval_mode TEXT NOT NULL,
    tokens_used INTEGER NOT NULL DEFAULT 0,
    has_user_event INTEGER NOT NULL DEFAULT 0,
    archived INTEGER NOT NULL DEFAULT 0,
    archived_at INTEGER,
    git_sha TEXT,
    git_branch TEXT,
    git_origin_url TEXT
, cli_version TEXT NOT NULL DEFAULT '', first_user_message TEXT NOT NULL DEFAULT ''):zM
�Kindexidx_jobs_kind_status_retry_leasejobsCREATE INDEX idx_jobs_kind_status_retry_lease
    ON jobs(kind, status, retry_at, lease_until)';
indexsqlite_autoindex_jobs_1jobs�0
�CtablejobsjobsCREATE TABLE jobs (
    kind TEXT NOT NULL,
    job_key TEXT NOT NULL,
    status TEXT NOT NULL,
    worker_id TEXT,
    ownership_token TEXT,
    started_at INTEGER,
    finished_at INTEGER,
    lease_until INTEGER,
    retry_at INTEGER,
    retry_remaining INTEGER NOT NULL,
    last_error TEXT,
    input_watermark INTEGER,
    last_success_watermark INTEGER,
    PRIMARY KEY (kind, job_key)
)�/U)
�mindexidx_stage1_outputs_source_updated_atstage1_outputsCR�D
�_tablethreadsthreadsCREATE TABLE threads (
    id TEXT PRIMARY KEY,
    rollout_path TEXT NOT NULL,
    created_at INTEGER NOT NULL,
    updated_at INTEGER NOT NULL,
    source TEXT NOT NULL,
    model_provider TEXT NOT NULL,
    cwd TEXT NOT NULL,
    title TEXT NOT NULL,
    sandbox_policy TEXT NOT NULL,
    approval_mode TEXT NOT NULL,
    tokens_used INTEGER NOT NULL DEFAULT 0,
    has_user_event INTEGER NOT NULL DEFAULT 0,
    archived INTEGER NOT NULL DEFAULT 0,
    archived_at INTEGER,
    git_sha TEXT,
    git_branch TEXT,
    git_origin_url TEXT
, cli_version TEXT NOT NULL DEFAULT '', first_user_message TEXT NOT NULL DEFAULT '', agent_nickname TEXT, agent_role TEXT)�`

�#tablelogslogsCREATE TABLE logs (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    ts INTEGER NOT NULL,
    ts_nanos INTEGER NOT NULL,
    level TEXT NOT NULL,
    target TEXT NOT NULL,
    message TEXT,
    module_path TEXT,
    file TEXT,
    line INTEGER
, thread_id TEXT, process_uuid TEXT, estimated_bytes INTEGER NOT NULL DEFAULT 0)T
1
qindexidx_logs_thread_idlogsCREATE INDEX idx_logs_thread_id ON logs(thread_id)]#
�indexidx_logs_tslogsCREATE INDEX idx_logs_ts ON logs(ts DESC, ts_nanos DESC, id DESC)P++
Ytablesqlite_sequencesqlite_sequence
CREATE TABLE sqlite_sequence(name,seq)
$
�%tablelogslogsCREATE TABLE logs (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    ts INTEGER NOT NULL,
    ts_nanos INTEGER NOT NULL,
    level TEXT NOT NULL,
    target TEXT NOT NULL,
    message TEXT,
    module_path TEXT,
    file TEXT,
    line INTEGER
, thread_id TEXT)d	5
�indexidx_threads_providerthreadsCREATE INDEX idx_threads_provider ON threads(model_provider)W1
qindexidx_threads_sourcethreads
CREATE INDEX idx_threads_source ON threads(source)]5
yindexidx_threads_archivedthreads	CREATE INDEX idx_threads_archived ON threads(archived)r9
�indexidx_threads_updated_atthreadsCREATE INDEX idx_threads_updated_at ON threads(updated_at DESC, id DESC)r9
�indexidx_threads_created_atthreadsCREATE INDEX idx_threads_created_at ON threads(created_at DESC, id DESC)-A
indexsqlite_autoindex_threads_1threads?S-
indexsqlite_autoindex__sqlx_migrations_1_sqlx_migrations�)
--
�table_sqlx_migrations_sqlx_migrationsCREATE TABLE _sqlx_migrations (
    version BIGINT PRIMARY KEY,
    description TEXT NOT NULL,
    installed_on TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    success BOOLEAN NOT NULL,
    checksum BLOB NOT NULL,
    execution_time BIGINT NOT NULL
)





��Zd
�
|
�^1	X�<
�
B�
	��0
�CtablejobsjobsCREATE TABLE jobs (
    kind TEXT NOT NULL,
    job_key TEXT NOT NULL,
    status TEXT NOT NULL,
    worker_id TEXT,
    ownership_token TEXT,
    started_at INTEGER,
    finished_at INTEGER,
    lease_until INTEGER,
    retry_at INTEGER,
    retry_remaining INTEGER NOT NULL,
    last_error TEXT,
    input_watermark INTEGER,
    last_success_watermark INTEGER,
    PRIMARY KEY (kind, job_key)
)�S
�}tablethreadsthreadsCREATE TABLE threads (
    id TEXT PRIMARY KEY,
    rollout_path TEXT NOT NULL,
    created_at INTEGER NOT NULL,
    updated_at INTEGER NOT NULL,
    source TEXT NOT NULL,
    model_provider TEXT NOT NULL,
    cwd TEXT NOT NULL,
    title TEXT NOT NULL,
    sandbox_policy TEXT NOT NULL,
    approval_mode TEXT NOT NULL,
    tokens_used INTEGER NOT NULL DEFAULT 0,
    has_user_event INTEGER NOT NULL DEFAULT 0,
    archived INTEGER NOT NULL DEFAULT 0,
    archived_at INTEGER,
    git_sha TEXT,
    git_branch TEXT,
    git_origin_url TEXT
, cli_version TEXT NOT NULL DEFAULT '', first_user_message TEXT NOT NULL DEFAULT '', agent_nickname TEXT, agent_role TEXT, memory_mode TEXT NOT NULL DEFAULT 'enabled', model TEXT, reasoning_effort TEXT, agent_path TEXT, created_at_ms INTEGER, updated_at_ms INTEGER)	
�55
�5tablethread_dynamic_toolsthread_dynamic_toolsCREATE TABLE thread_dynamic_tools (
    thread_id TEXT NOT NULL,
    position INTEGER NOT NULL,
    name TEXT NOT NULL,
    description TEXT NOT NULL,
    input_schema TEXT NOT NULL, defer_loading INTEGER NOT NULL DEFAULT 0,
    PRIMARY KEY(thread_id, position),
    FOREIGN KEY(thread_id) REFERENCES threads(id) ON DELETE CASCADE
)�Z))
�otablestage1_outputsstage1_outputsCREATE TABLE stage1_outputs (
    thread_id TEXT PRIMARY KEY,
    source_updated_at INTEGER NOT NULL,
    raw_memory TEXT NOT NULL,
    rollout_summary TEXT NOT NULL,
    generated_at INTEGER NOT NULL, rollout_slug TEXT, usage_count INTEGER, last_usage INTEGER, selected_for_phase2 INTEGER NOT NULL DEFAULT 0, selected_for_phase2_source_updated_at INTEGER,
    FOREIGN KEY(thread_id) REFERENCES threads(id) ON DELETE CASCADE
)?
�#tablelogslogsCREATE TABLE logs (
    id INTEGER PRI�55
�Utablethread_dynamic_toolsthread_dynamic_toolsCREATE TABLE thread_dynamic_tools (
    thread_id TEXT NOT NULL,
    position INTEGER NOT NULL,
    name TEXT NOT NULL,
    description TEXT NOT NULL,
    input_schema TEXT NOT NULL, defer_loading INTEGER NOT NULL DEFAULT 0, namespace TEXT,
    PRIMARY KEY(thread_id, position),
    FOREIGN KEY(thread_id) REFERENCES threads(id) ON DELETE CASCADE
);O)
indexsqlite_autoindex_stage1_outputs_1stage1_outputsP++
Ytablesqlite_sequencesqlite_sequence
CREATE TABLE sqlite_sequence(name,seq)�K5
�+indexidx_thread_dynamic_tools_threadthread_dynamic_toolsCREATE INDEX idx_thread_dynamic_tools_thread ON thread_dynamic_tools(thread_id)G[5
indexsqlite_autoindex_thread_dynamic_tools_1thread_dynamic_toolsd	5
�indexidx_threads_providerthreadsCREATE INDEX idx_threads_provider ON threads(model_provider)W1
qindexidx_threads_sourcethreads
CREATE INDEX idx_threads_source ON threads(source)]5
yindexidx_threads_archivedthreads	CREATE INDEX idx_threads_archived ON threads(archived)r9
�indexidx_threads_updated_atthreadsCREATE INDEX idx_threads_updated_at ON threads(updated_at DESC, id DESC)r9
�indexidx_threads_created_atthreadsCREATE INDEX idx_threads_created_at ON threads(created_at DESC, id DESC)-A
indexsqlite_autoindex_threads_1threads?S-
indexsqlite_autoindex__sqlx_migrations_1_sqlx_migrations�)
--
�table_sqlx_migrations_sqlx_migrationsCREATE TABLE _sqlx_migrations (
    version BIGINT PRIMARY KEY,
    description TEXT NOT NULL,
    installed_on TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    success BOOLEAN NOT NULL,
    checksum BLOB NOT NULL,
    execution_time BIGINT NOT NULL
)
$#"! 

(�]
�
~
?	�	6o*~"�X{*?
�)indexidx_threads_created_at_msthreads"CREATE INDEX idx_threads_created_at_ms ON threads(created_at_ms DESC, id DESC)�J)Q�3triggerthreads_updated_at_ms_after_updatethreadsCREATE TRIGGER threads_updated_at_ms_after_update
AFTER UPDATE OF updated_at ON threads
WHEN NEW.updated_at != OLD.updated_at
 AND NEW.updated_at_ms IS OLD.updated_at_ms
BEGIN
    UPDATE threads
    SET updated_at_ms = NEW.updated_at * 1000
    WHERE id = NEW.id;
END�J(Q�3triggerthreads_created_at_ms_after_updatethreadsCREATE TRIGGER threads_created_at_ms_after_update
AFTER UPDATE OF created_at ON threads
WHEN NEW.created_at != OLD.created_at
 AND NEW.created_at_ms IS OLD.created_at_ms
BEGIN
    UPDATE threads
    SET created_at_ms = NEW.created_at * 1000
    WHERE id = NEW.id;
END�'Q�/triggerthreads_updated_at_ms_after_insertthreadsCREATE TRIGGER threads_updated_at_ms_after_insert
AFTER INSERT ON threads
WHEN NEW.updated_at_ms IS NULL
BEGIN
    UPDATE threads
    SET updated_at_ms = NEW.updated_at * 1000�M
�Kindexidx_jobs_kind_status_retry_leasejobsCREATE INDEX idx_jobs_kind_status_retry_lease
    ON jobs(kind, status, retry_at, lease_until)';
indexsqlite_autoindex_jobs_1jobs�0
�CtablejobsjobsCREATE TABLE jobs (
    kind TEXT NOT NULL,
    job_key TEXT NOT NULL,
    status TEXT NOT NULL,
    worker_id TEXT,
    ownership_token TEXT,
    started_at INTEGER,
    finished_at INTEGER,
    lease_until INTEGER,
    retry_at INTEGER,
    retry_remaining INTEGER NOT NULL,
    last_error TEXT,
    input_watermark INTEGER,
    last_success_watermark INTEGER,
    PRIMARY KEY (kind, job_key)
)�/U)
�mindexidx_stage1_outputs_source_updated_atstage1_outputsCREATE INDEX idx_stage1_outputs_source_updated_at
    ON stage1_outputs(source_updated_at DESC, thread_id DESC)�)#U1
�Yindexidx_thread_spawn_edges_parent_statusthread_spawn_edgesCREATE INDEX idx_thread_spawn_edges_parent_status
    ON thread_spawn_edges(parent_thread_id, status)C"W1
indexsqlite_autoindex_thread_spawn_edges_1thread_spawn_edges�D!11
�3tablethread_spawn_edgesthread_spawn_edgesCREATE TABLE thread_spawn_edges (
    parent_thread_id TEXT NOT NULL,
    child_thread_id TEXT NOT NULL PRIMARY KEY,
    status TEXT NOT NULL
)� A+
�?indexidx_agent_job_items_statusagent_job_itemsCREATE INDEX idx_agent_job_items_status ON agent_job_items(job_id, status, row_index ASC)u7!
�indexidx_agent_jobs_statusagent_jobsCREATE INDEX idx_agent_jobs_status ON agent_jobs(status, updated_at DESC)=Q+
indexsqlite_autoindex_agent_job_items_1agent_job_items�M++
�Qtableagent_job_itemsagent_job_itemsCREATE TABLE agent_job_items (
    job_id TEXT NOT NULL,
    item_id TEXT NOT NULL,
    row_index INTEGER NOT NULL,
    source_id TEXT,
    row_json TEXT NOT NULL,
    status TEXT NOT NULL,
    assigned_thread_id TEXT,
    attempt_count INTEGER NOT NULL DEFAULT 0,
    result_json TEXT,
    last_error TEXT,
    created_at INTEGER NOT NULL,
    updated_at INTEGER NOT NULL,
    completed_at INTEGER,
    reported_at INTEGER,
    PRIMARY KEY (job_id, item_id),
    FOREIGN KEY(job_id) REFERENCES agent_jobs(id) ON DELETE CASCADE
)3G!
indexsqlite_autoindex_agent_jobs_1agent_jobs�!!
�gtableagent_jobsagent_jobsCREATE TABLE agent_jobs (
    id TEXT PRIMARY KEY,
    name TEXT NOT NULL,
    status TEXT NOT NULL,
    instruction TEXT NOT NULL,
    output_schema_json TEXT,
    input_headers_json TEXT NOT NULL,
    input_csv_path TEXT NOT NULL,
    output_csv_path TEXT NOT NULL,
    auto_export INTEGER NOT NULL DEFAULT 1,
    created_at INTEGER NOT NULL,
    updated_at INTEGER NOT NULL,
    started_at INTEGER,
    completed_at INTEGER,
    last_error TEXT
, max_runtime_seconds INTEGER)�i))
�
tablebackfill_statebackfill_stateCREATE TABLE backfill_state (
    id INTEGER PRIMARY KEY CHECK (id = 1),
    status TEXT NOT NULL,
    last_watermark TEXT,
    last_success_at INTEGER,
    updated_at INTEGER NOT NULL
)
��Zd
�
|
�^1	X�<
�
B�
	��0
�CtablejobsjobsCREATE TABLE jobs (
    kind TEXT NOT NULL,
    job_key TEXT NOT NULL,
    status TEXT NOT NULL,
    worker_id TEXT,
    ownership_token TEXT,
    started_at INTEGER,
    finished_at INTEGER,
    lease_until INTEGER,
    retry_at INTEGER,
    retry_remaining INTEGER NOT NULL,
    last_error TEXT,
    input_watermark INTEGER,
    last_success_watermark INTEGER,
    PRIMARY KEY (kind, job_key)
)�S
�}tablethreadsthreadsCREATE TABLE threads (
    id TEXT PRIMARY KEY,
    rollout_path TEXT NOT NULL,
    created_at INTEGER NOT NULL,
    updated_at INTEGER NOT NULL,
    source TEXT NOT NULL,
    model_provider TEXT NOT NULL,
    cwd TEXT NOT NULL,
    title TEXT NOT NULL,
    sandbox_policy TEXT NOT NULL,
    approval_mode TEXT NOT NULL,
    tokens_used INTEGER NOT NULL DEFAULT 0,
    has_user_event INTEGER NOT NULL DEFAULT 0,
    archived INTEGER NOT NULL DEFAULT 0,
    archived_at INTEGER,
    git_sha TEXT,
    git_branch TEXT,
    git_origin_url TEXT
, cli_version TEXT NOT NULL DEFAULT '', first_user_message TEXT NOT NULL DEFAULT '', agent_nickname TEXT, agent_role TEXT, memory_mode TEXT NOT NULL DEFAULT 'enabled', model TEXT, reasoning_effort TEXT, agent_path TEXT, created_at_ms INTEGER, updated_at_ms INTEGER)	
�55
�5tablethread_dynamic_toolsthread_dynamic_toolsCREATE TABLE thread_dynamic_tools (
    thread_id TEXT NOT NULL,
    position INTEGER NOT NULL,
    name TEXT NOT NULL,
    description TEXT NOT NULL,
    input_schema TEXT NOT NULL, defer_loading INTEGER NOT NULL DEFAULT 0,
    PRIMARY KEY(thread_id, position),
    FOREIGN KEY(thread_id) REFERENCES threads(id) ON DELETE CASCADE
)�Z))
�otablestage1_outputsstage1_outputsCREATE TABLE stage1_outputs (
    thread_id TEXT PRIMARY KEY,
    source_updated_at INTEGER NOT NULL,
    raw_memory TEXT NOT NULL,
    rollout_summary TEXT NOT NULL,
    generated_at INTEGER NOT NULL, rollout_slug TEXT, usage_count INTEGER, last_usage INTEGER, selected_for_phase2 INTEGER NOT NULL DEFAULT 0, selected_for_phase2_source_updated_at INTEGER,
    FOREIGN KEY(thread_id) REFERENCES threads(id) ON DELETE CASCADE
)?
�#tablelogslogsCREATE TABLE logs (
    id INTEGER PRI�55
�Utablethread_dynamic_toolsthread_dynamic_toolsCREATE TABLE thread_dynamic_tools (
    thread_id TEXT NOT NULL,
    position INTEGER NOT NULL,
    name TEXT NOT NULL,
    description TEXT NOT NULL,
    input_schema TEXT NOT NULL, defer_loading INTEGER NOT NULL DEFAULT 0, namespace TEXT,
    PRIMARY KEY(thread_id, position),
    FOREIGN KEY(thread_id) REFERENCES threads(id) ON DELETE CASCADE
);O)
indexsqlite_autoindex_stage1_outputs_1stage1_outputsP++
Ytablesqlite_sequencesqlite_sequence
CREATE TABLE sqlite_sequence(name,seq)�K5
�+indexidx_thread_dynamic_tools_threadthread_dynamic_toolsCREATE INDEX idx_thread_dynamic_tools_thread ON thread_dynamic_tools(thread_id)G[5
indexsqlite_autoindex_thread_dynamic_tools_1thread_dynamic_toolsd	5
�indexidx_threads_providerthreadsCREATE INDEX idx_threads_provider ON threads(model_provider)W1
qindexidx_threads_sourcethreads
CREATE INDEX idx_threads_source ON threads(source)]5
yindexidx_threads_archivedthreads	CREATE INDEX idx_threads_archived ON threads(archived)r9
�indexidx_threads_updated_atthreadsCREATE INDEX idx_threads_updated_at ON threads(updated_at DESC, id DESC)r9
�indexidx_threads_created_atthreadsCREATE INDEX idx_threads_created_at ON threads(created_at DESC, id DESC)-A
indexsqlite_autoindex_threads_1threads?S-
indexsqlite_autoindex__sqlx_migrations_1_sqlx_migrations�)
--
�table_sqlx_migrations_sqlx_migrationsCREATE TABLE _sqlx_migrations (
    version BIGINT PRIMARY KEY,
    description TEXT NOT NULL,
    installed_on TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    success BOOLEAN NOT NULL,
    checksum BLOB NOT NULL,
    execution_time BIGINT NOT NULL
)	('&%$#"! {*?
�)indexidx_threads_created_at_msthreads"CREATE INDEX idx_threads_created_at_ms ON threads(created_at_ms DESC, id DESC)�J)Q�3triggerthreads_updated_at_ms_after_updatethreadsCREATE TRIGGER threads_updated_at_ms_after_update
AFTER UPDATE OF updated_at ON threads
WHEN NEW.updated_at != OLD.updated_at
 AND NEW.updated_at_ms IS OLD.updated_at_ms
BEGIN
    UPDATE threads
    SET updated_at_ms = NEW.updated_at * 1000
    WHERE id = NEW.id;
END�J(Q�3triggerthreads_created_at_ms_after_updatethreadsCREATE TRIGGER threads_created_at_ms_after_update
AFTER UPDATE OF created_at ON threads
WHEN NEW.created_at != OLD.created_at
 AND NEW.created_at_ms IS OLD.created_at_ms
BEGIN
    UPDATE threads
    SET created_at_ms = NEW.created_at * 1000
    WHERE id = NEW.id;
END�'Q�/triggerthreads_updated_at_ms_after_insertthreadsCREATE TRIGGER threads_updated_at_ms_after_insert
AFTER INSERT ON threads
WHEN NEW.updated_at_ms IS NULL
BEGIN
    UPDATE threads
    SET updated_at_ms = NEW.updated_at * 1000�M
�Kindexidx_jobs_kind_status_retry_leasejobsCREATE INDEX idx_jobs_kind_status_retry_lease
    ON jobs(kind, status, retry_at, lease_until)';
indexsqlite_autoindex_jobs_1jobs�0
�CtablejobsjobsCREATE TABLE jobs (
    kind TEXT NOT NULL,
    job_key TEXT NOT NULL,
    status TEXT NOT NULL,
    worker_id TEXT,
    ownership_token TEXT,
    started_at INTEGER,
    finished_at INTEGER,
    lease_until INTEGER,
    retry_at INTEGER,
    retry_remaining INTEGER NOT NULL,
    last_error TEXT,
    input_watermark INTEGER,
    last_success_watermark INTEGER,
    PRIMARY KEY (kind, job_key)
)�/U)
�mindexidx_stage1_outputs_source_updated_atstage1_outputsCREATE INDEX idx_stage1_outputs_source_updated_at
    ON stage1_outputs(source_updated_at DESC, thread_id DESC)�)#U1
�Yindexidx_thread_spawn_edges_parent_statusthread_spawn_edgesCREATE INDEX idx_thread_spawn_edges_parent_status
    ON thread_spawn_edges(parent_thread_id, status)C"W1
indexsqlite_autoindex_thread_spawn_edges_1thread_spawn_edges�D!11
�3tablethread_spawn_edgesthread_spawn_edgesCREATE TABLE thread_spawn_edges (
    parent_thread_id TEXT NOT NULL,
    child_thread_id TEXT NOT NULL PRIMARY KEY,
    status TEXT NOT NULL
)� A+
�?indexidx_agent_job_items_statusagent_job_itemsCREATE INDEX idx_agent_job_items_status ON agent_job_items(job_id, status, row_index ASC)u7!
�indexidx_agent_jobs_statusagent_jobsCREATE INDEX idx_agent_jobs_status ON agent_jobs(status, updated_at DESC)=Q+
indexsqlite_autoindex_agent_job_items_1agent_job_items�M++
�Qtableagent_job_itemsagent_job_itemsCREATE TABLE agent_job_items (
    job_id TEXT NOT NULL,
    item_id TEXT NOT NULL,
    row_index INTEGER NOT NULL,
    source_id TEXT,
    row_json TEXT NOT NULL,
    status TEXT NOT NULL,
    assigned_thread_id TEXT,
    attempt_count INTEGER NOT NULL DEFAULT 0,
    result_json TEXT,
    last_error TEXT,
    created_at INTEGER NOT NULL,
    updated_at INTEGER NOT NULL,
    completed_at INTEGER,
    reported_at INTEGER,
    PRIMARY KEY (job_id, item_id),
    FOREIGN KEY(job_id) REFERENCES agent_jobs(id) ON DELETE CASCADE
)3G!
indexsqlite_autoindex_agent_jobs_1agent_jobs�!!
�gtableagent_jobsagent_jobsCREATE TABLE agent_jobs (
    id TEXT PRIMARY KEY,
    name TEXT NOT NULL,
    status TEXT NOT NULL,
    instruction TEXT NOT NULL,
    output_schema_json TEXT,
    input_headers_json TEXT NOT NULL,
    input_csv_path TEXT NOT NULL,
    output_csv_path TEXT NOT NULL,
    auto_export INTEGER NOT NULL DEFAULT 1,
    created_at INTEGER NOT NULL,
    updated_at INTEGER NOT NULL,
    started_at INTEGER,
    completed_at INTEGER,
    last_error TEXT
, max_runtime_seconds INTEGER)�i))
�
tablebackfill_statebackfill_stateCREATE TABLE backfill_state (
    id INTEGER PRIMARY KEY CHECK (id = 1),
    status TEXT NOT NULL,
    last_watermark TEXT,
    last_success_at INTEGER,
    updated_at INTEGER NOT NULL
)

\��
�	W�]������X2--
�ctablethread_goals_newthread_goals_new&CREATE TABLE thread_goals_new (
    thread_id TEXT PRIMARY KEY NOT NULL REFERENCES threads(id) ON DELETE CASCADE,
    goal_id TEXT NOT NULL,
    objective TEXT NOT NULL,
    status TEXT NOT NULL CHECK(status IN (
        'active',
        'paused',
        'blocked',
        'usage_limited',
        'budget_limited',
        'complete'
    )),
    token_budget INTEGER,
    tokens_used INTEGER NOT NULL DEFAULT 0,
    time_used_seconds INTEGER NOT NULL DEFAULT 0,
    created_at_ms INTEGER NOT NULL,
    updated_at_ms INTEGER NOT NULL
)<%%
�)tablethread_goalsthread_goals&CREATE TABLE thread_goals (
    thread_id TEXT PRIMARY KEY NOT NULL REFERENCES threads(id) ON DELETE CASCADE,
    goal_id TEXT NOT NULL,
    objective TEXT NOT NULL,
    status TEXT N�V2--
�N2%%
�_tablethread_goalsthread_goals&CREATE TABLE "thread_goals" (
    thread_id TEXT PRIMARY KEY NOT NULL REFERENCES threads(id) ON DELETE CASCADE,
    goal_id TEXT NOT NULL,
    objective TEXT NOT NULL,
    status TEXT NOT NULL CHECK(status IN (
        'active',
        'paused',
        'blocked',
        'usage_limited',
        'budget_limited',
        'complete'
    )),
    token_budget INTEGER,
    tokens_used INTEGER NOT NULL DEFAULT 0,
    time_used_seconds INTEGER NOT NULL DEFAULT 0,
    created_at_ms INTEGER NOT NULL,
    updated_at_ms INTEGER NOT NULL
)S-
indexsql73K%
indexsqlite_autoindex_thread_goals_1thread_goals'�$-Y
�aindexidx_threads_archived_cwd_updated_at_msthreadsCREATE INDEX idx_threads_archived_cwd_updated_at_ms ON threads(archived, cwd, updated_at_ms DESC, id DESC)�$,Y
�aindexidx_threads_archived_cwd_created_at_msthreadsCREATE INDEX idx_threads_archived_cwd_created_at_ms ON threads(archived, cwd, created_at_ms DESC, id DESC){+?
�)indexidx_threads_updated_at_msthreadsCREATE INDEX idx_threads_updated_at_ms ON threads(updated_at_ms DESC, id DESC){*?
�)indexidx_threads_created_at_msthreadsCREATE INDEX idx_threads_created_at_ms ON threads(created_at_ms DESC, id DESC)�J)Q�3triggerthreads_updated_at_ms_after_updatethreadsCREATE TRIGGER threads_updated_at_ms_after_update
AFTER UPDATE OF updated_at ON threads
WHEN NEW.updated_at != OLD.updated_at
 AND NEW.updated_at_ms IS OLD.updated_at_ms
BEGIN
    UPDATE threads
    SET updated_at_ms = NEW.updated_at * 1000
    WHERE id = NEW.id;
END�J(Q�3triggerthreads_created_at_ms_after_updatethreadsCREATE TRIGGER threads_created_at_ms_after_update
AFTER UPDATE OF created_at ON threads
WHEN NEW.created_at != OLD.created_at
 AND NEW.created_at_ms IS OLD.created_at_ms
BEGIN
    UPDATE threads
    SET created_at_ms = NEW.created_at * 1000
    WHERE id = NEW.id;
END�'Q�/triggerthreads_updated_at_ms_after_insertthreadsCREATE TRIGGER threads_updated_at_ms_after_insert
AFTER INSERT ON threads
WHEN NEW.updated_at_ms IS NULL
BEGIN
    UPDATE threads
    SET updated_at_ms = NEW.updated_at * 1000
    WHERE id = NEW.id;
END�&Q�/triggerthreads_created_at_ms_after_insertthreadsCREATE TRIGGER threads_created_at_ms_after_insert
AFTER INSERT ON threads
WHEN NEW.created_at_ms IS NULL
BEGIN
    UPDATE threads
    SET created_at_ms = NEW.created_at * 1000
    WHERE id = NEW.id;
ENDS%gA
indexsqlite_autoindex_remote_control_enrollments_1remote_control_enrollments�!$AA
�Mtableremote_control_enrollmentsremote_control_enrollmentsCREATE TABLE remote_control_enrollments (
    websocket_url TEXT NOT NULL,
    account_id TEXT NOT NULL,
    app_server_client_name TEXT NOT NULL,
    server_id TEXT NOT NULL,
    environment_id TEXT NOT NULL,
    server_name TEXT NOT NULL,
    updated_at INTEGER NOT NULL,
    PRIMARY KEY (websocket_url, account_id, app_server_client_name)
)
<
����d
�
|
�^1	X�
�
�
B�
	��0
�CtablejobsjobsCREATE TABLE jobs (
    kind TEXT NOT NULL,
    job_key TEXT NOT NULL,
    status TEXT NOT NULL,
    worker_id TEXT,
    ownership_token TEXT,
    started_at INTEGER,
    finished_at INTEGER,
    lease_until INTEGER,
    retry_at INTEGER,
    retry_remaining INTEGER NOT NULL,
    last_error TEXT,
    input_watermark INTEGER,
    last_success_watermark INTEGER,
    PRIMARY KEY (kind, job_key)
)�S
�}tablethreadsthreadsCREATE TABLE threads (
    id TEXT PRIMARY KEY,
    rollout_path TEXT NOT NULL,
    created_at INTEGER NOT NULL,
    updated_at INTEGER NOT NULL,
    source TEXT NOT NULL,
    model_provider TEXT NOT NULL,
    cwd TEXT NOT NULL,
    title TEXT NOT NULL,
    sandbox_policy TEXT NOT NULL,
    approval_m�	
�itablethreadsthreadsCREATE TABLE threads (
    id TEXT PRIMARY KEY,
    rollout_path TEXT NOT NULL,
    created_at INTEGER NOT NULL,
    updated_at INTEGER NOT NULL,
    source TEXT NOT NULL,
    model_provider TEXT NOT NULL,
    cwd TEXT NOT NULL,
    title TEXT NOT NULL,
    sandbox_policy TEXT NOT NULL,
    approval_mode TEXT NOT NULL,
    tokens_used INTEGER NOT NULL DEFAULT 0,
    has_user_event INTEGER NOT NULL DEFAULT 0,
    archived INTEGER NOT NULL DEFAULT 0,
    archived_at INTEGER,
    git_sha TEXT,
    git_branch TEXT,
    git_origin_url TEXT
, cli_version TEXT NOT NULL DEFAULT '', first_user_message TEXT NOT NULL DEFAULT '', agent_nickname TEXT, agent_role TEXT, memory_mode TEXT NOT NULL DEFAULT 'enabled', model TEXT, reasoning_effort TEXT, agent_path TEXT, created_at_ms INTEGER, updated_at_ms INTEGER, thread_source TEXT, preview TEXT NOT NULL DEFAULT '')
�))
�otablestage1_outputsstage1_outputsCREATE TABLE stage1_outputs (
    thread_id TEXT PRIMARY KEY,
    source_updated_at INTEGER NOT NULL,
    raw_memory TEXT NOT NULL,
    rollout_summary TEXT NOT NULL,
    generated_at INTEGER NOT NULL, rollout_slug TEXT, usage_count INTEGER, last_usage INTEGER, selected_for_phase2 INTEGER NOT NULL DEFAULT 0, selected_for_phase2_source_updated_at INTEGER,
    FOREIGN KEY(thread_id) REFERENCES threads(id) ON DELETE CASCADE
)?
�#tablelogslogsCREATE TABLE logs (
    id INTEGER PRI�55
�Utablethread_dynamic_toolsthread_dynamic_toolsCREATE TABLE thread_dynamic_tools (
    thread_id TEXT NOT NULL,
    position INTEGER NOT NULL,
    name TEXT NOT NULL,
    description TEXT NOT NULL,
    input_schema TEXT NOT NULL, defer_loading INTEGER NOT NULL DEFAULT 0, namespace TEXT,
    PRIMARY KEY(thread_id, position),
    FOREIGN KEY(thread_id) REFERENCES threads(id) ON DELETE CASCADE
)=O)
indexsqlite_autoindex_stage1_outputs_1stage1_outputsP++
Ytablesqlite_sequencesqlite_sequence
CREATE TABLE sqlite_sequence(name,seq)�K5
�+indexidx_thread_dynamic_tools_threadthread_dynamic_toolsCREATE INDEX idx_thread_dynamic_tools_thread ON thread_dynamic_tools(thread_id)G[5
indexsqlite_autoindex_thread_dynamic_tools_1thread_dynamic_toolsd	5
�indexidx_threads_providerthreadsCREATE INDEX idx_threads_provider ON threads(model_provider)W1
qindexidx_threads_sourcethreads
CREATE INDEX idx_threads_source ON threads(source)]5
yindexidx_threads_archivedthreads	CREATE INDEX idx_threads_archived ON threads(archived)r9
�indexidx_threads_updated_atthreadsCREATE INDEX idx_threads_updated_at ON threads(updated_at DESC, id DESC)r9
�indexidx_threads_created_atthreadsCREATE INDEX idx_threads_created_at ON threads(created_at DESC, id DESC)-A
indexsqlite_autoindex_threads_1threads?S-
indexsqlite_autoindex__sqlx_migrations_1_sqlx_migrations�)
--
�table_sqlx_migrations_sqlx_migrationsCREATE TABLE _sqlx_migrations (
    version BIGINT PRIMARY KEY,
    description TEXT NOT NULL,
    installed_on TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    success BOOLEAN NOT NULL,
    checksum BLOB NOT NULL,
    execution_time BIGINT NOT NULL
)

~
�
~
?	�	6o*~~~~~"�X{*?
�)indexidx_threads_created_at_msthreads"CREATE INDEX idx_threads_created_at_ms ON threads(created_at_ms DESC, id DESC)�J)Q�3triggerthreads_updated_at_ms_after_updatethreadsCREATE TRIGGER threads_updated_at_ms_after_update
AFTER UPDATE OF updated_at ON threads
WHEN NEW.updated_at != OLD.updated_at
 AND NEW.updated_at_ms IS OLD.updated_at_ms
BEGIN
    UPDATE threads
    SET updated_at_ms = NEW.updated_at * 1000
    WHERE id = NEW.id;
END�J(Q�3triggerthreads_created_at_ms_after_updatethreadsCREATE TRIGGER threads_created_at_ms_after_update
AFTER UPDATE OF created_at ON threads
WHEN NEW.created_at != OLD.created_at
 AND NEW.created_at_ms IS OLD.created_at_ms
BEGIN
    UPDATE threads
    SET created_at_ms = NEW.created_at * 1000
    WHERE id = NEW.id;
END�'Q�/triggerthreads_updated_at_ms_after_insertthreadsCREATE TRIGGER threads_updated_at_ms_after_insert
AFTER INSERT ON threads
WHEN NEW.updated_at_ms IS NULL
BEGIN
    UPDATE threads
    SET updated_at_ms = NEW.updated_at * 1000�M
�Kindexidx_jobs_kind_status_retry_leasejobsCREATE INDEX idx_jobs_kind_status_retry_lease
    ON jobs(kind, status, retry_at, lease_until)
�;
indexsqlite_autoindex_jobs_1jobs
�
�CtablejobsjobsCREATE TABLE jobs (
    kind TEXT NOT NULL,
    job_key TEXT NOT NULL,
    status TEXT NOT NULL,
    worker_id TEXT,
    ownership_token TEXT,
    started_at INTEGER,
    finished_at INTEGER,
    lease_until INTEGER,
    retry_at INTEGER,
    retry_remaining INTEGER NOT NULL,
    last_error TEXT,
    input_watermark INTEGER,
    last_success_watermark INTEGER,
    PRIMARY KEY (kind, job_key)
)�/U)
�mindexidx_stage1_outputs_source_updated_atstage1_outputsCREATE INDEX idx_stage1_outputs_source_updated_at
    ON stage1_outputs(source_updated_at DESC, thread_id DESC)�)#U1
�Yindexidx_thread_spawn_edges_parent_statusthread_spawn_edgesCREATE INDEX idx_thread_spawn_edges_parent_status
    ON thread_spawn_edges(parent_thread_id, status)C"W1
indexsqlite_autoindex_thread_spawn_edges_1thread_spawn_edges�D!11
�3tablethread_spawn_edgesthread_spawn_edgesCREATE TABLE thread_spawn_edges (
    parent_thread_id TEXT NOT NULL,
    child_thread_id TEXT NOT NULL PRIMARY KEY,
    status TEXT NOT NULL
)� A+
�?indexidx_agent_job_items_statusagent_job_itemsCREATE INDEX idx_agent_job_items_status ON agent_job_items(job_id, status, row_index ASC)u7!
�indexidx_agent_jobs_statusagent_jobsCREATE INDEX idx_agent_jobs_status ON agent_jobs(status, updated_at DESC)=Q+
indexsqlite_autoindex_agent_job_items_1agent_job_items�M++
�Qtableagent_job_itemsagent_job_itemsCREATE TABLE agent_job_items (
    job_id TEXT NOT NULL,
    item_id TEXT NOT NULL,
    row_index INTEGER NOT NULL,
    source_id TEXT,
    row_json TEXT NOT NULL,
    status TEXT NOT NULL,
    assigned_thread_id TEXT,
    attempt_count INTEGER NOT NULL DEFAULT 0,
    result_json TEXT,
    last_error TEXT,
    created_at INTEGER NOT NULL,
    updated_at INTEGER NOT NULL,
    completed_at INTEGER,
    reported_at INTEGER,
    PRIMARY KEY (job_id, item_id),
    FOREIGN KEY(job_id) REFERENCES agent_jobs(id) ON DELETE CASCADE
)3G!
indexsqlite_autoindex_agent_jobs_1agent_jobs�!!
�gtableagent_jobsagent_jobsCREATE TABLE agent_jobs (
    id TEXT PRIMARY KEY,
    name TEXT NOT NULL,
    status TEXT NOT NULL,
    instruction TEXT NOT NULL,
    output_schema_json TEXT,
    input_headers_json TEXT NOT NULL,
    input_csv_path TEXT NOT NULL,
    output_csv_path TEXT NOT NULL,
    auto_export INTEGER NOT NULL DEFAULT 1,
    created_at INTEGER NOT NULL,
    updated_at INTEGER NOT NULL,
    started_at INTEGER,
    completed_at INTEGER,
    last_error TEXT
, max_runtime_seconds INTEGER)�i))
�
tablebackfill_statebackfill_stateCREATE TABLE backfill_state (
    id INTEGER PRIMARY KEY CHECK (id = 1),
    status TEXT NOT NULL,
    last_watermark TEXT,
    last_success_at INTEGER,
    updated_at INTEGER NOT NULL
)