返回 DeepSeek-Reasonix
drafts.sqlite
根目录 / desktop / testdata / manual-session-upgrade / main-v2-pr10469 / drafts.sqlite
1 SQLite format 3@ .��
2 � >��
3 �
4 � 
5 | \
6 >��
7 ''�[tablerestore_staterestore_state CREATE TABLE restore_state (slot TEXT PRIMARY KEY, draft_id TEXT NOT NULL, updated_at INTEGER NOT NULL)9 M'indexsqlite_autoindex_restore_state_1restore_state P ++Ytablesqlite_sequencesqlite_sequence
8 CREATE TABLE sqlite_sequence(name,seq)�� tableconflictsconflicts CREATE TABLE conflicts (
9 id INTEGER PRIMARY KEY AUTOINCREMENT, draft_id TEXT NOT NULL,
10 expected_revision INTEGER NOT NULL, actual_revision INTEGER NOT NULL,
11 content_json TEXT NOT NULL, settings_json TEXT NOT NULL, created_at INTEGER NOT NULL
12 )�7!�Uindexoperations_by_requestoperationsCREATE UNIQUE INDEX operations_by_request ON operations(draft_id, request_id) WHERE request_id <> ''s3!�indexoperations_by_draftoperationsCREATE INDEX operations_by_draft ON operations(draft_id, updated_at DESC)�N!!�gtableoperationsoperationsCREATE TABLE operations (
13 id TEXT PRIMARY KEY, draft_id TEXT NOT NULL, workspace_id TEXT NOT NULL,
14 draft_revision INTEGER NOT NULL, session_id TEXT NOT NULL,
15 topic_id TEXT NOT NULL,
16 submission_id TEXT NOT NULL, fingerprint TEXT NOT NULL,
17 request_json TEXT NOT NULL, phase TEXT NOT NULL, error TEXT NOT NULL,
18 created_at INTEGER NOT NULL, updated_at INTEGER NOT NULL,
19 request_id TEXT NOT NULL DEFAULT '', source_digest TEXT NOT NULL DEFAULT '',
20 operation_revision INTEGER NOT NULL DEFAULT 1, execution_json TEXT NOT NULL DEFAULT ''
21 )3G!indexsqlite_autoindex_operations_1operations�I�Qindexone_active_draft_per_workspacedraftsCREATE UNIQUE INDEX one_active_draft_per_workspace ON drafts(workspace_id) WHERE status = 'active'�(�+tabledraftsdraftsCREATE TABLE drafts (
22 id TEXT PRIMARY KEY, workspace_id TEXT NOT NULL, scope TEXT NOT NULL,
23 workspace_root TEXT NOT NULL, revision INTEGER NOT NULL,
24 content_json TEXT NOT NULL, settings_json TEXT NOT NULL,
25 status TEXT NOT NULL, updated_at INTEGER NOT NULL
26 )+?indexsqlite_autoindex_drafts_1drafts�� f
27 )��6��RJ�N
28 +31 �draft-cancelledworkspace-cancelledproject/fixture/cancelled{}{"model":"fixture/model","modelSource":"explicit","mode":"normal","toolApprovalMode":"ask","disabledMcp":{},"mcpOrder":[]}active��k���4 %-+�k�draft-failedworkspace-failedproject/fixture/failed{"text":"unsent upgrade fixture","attachments":[{"path":"missing-historical-file"}],"future":{"preserve":true}}{"model":"fixture/model","modelSource":"explicit","mode":"normal","toolApprovalMode":"ask","disabledMcp":{},"mcpOrder":[]}active��k�q�O 7?=�k�draft-resume_requiredworkspace-resume_requiredproject/fixture/resume_required{"text":"unsent upgrade fixture","attachments":[{"path":"missing-historical-file"}],"future":{"preserve":true}}{"model":"fixture/model","modelSource":"explicit","mode":"normal","toolApprovalMode":"ask","disabledMcp":{},"mcpOrder":[]}active��k�S�R
29 9A?�k�draft-cancel_requestedworkspace-cancel_requestedproject/fixture/cancel_requested{"text":"unsent upgrade fixture","attachments":[{"path":"missing-historical-file"}],"future":{"preserve":true}}{"model":"fixture/model","modelSource":"explicit","mode":"normal","toolApprovalMode":"ask","disabledMcp":{},"mcpOrder":[]}active��k�B�: )1/�k�draft-acceptedworkspace-acceptedproject/fixture/accepted{"text":"unsent upgrade fixture","attachments":[{"path":"missing-historical-file"}],"future":{"preserve":true}}{"model":"fixture/model","modelSource":"explicit","mode":"normal","toolApprovalMode":"ask","disabledMcp":{},"mcpOrder":[]}active��k�4�R 9A?�k�draft-dispatch_unknownworkspace-dispatch_unknownproject/fixture/dispatch_unknown{"text":"unsent upgrade fixture","attachments":[{"path":"missing-historical-file"}],"future":{"preserve":true}}{"model":"fixture/model","modelSource":"explicit","mode":"normal","toolApprovalMode":"ask","disabledMcp":{},"mcpOrder":[]}active��k��U ;CA�k�draft-dispatching_shellworkspace-dispatching_shellproject/fixture/dispatching_shell{"text":"unsent upgrade fixture","attachments":[{"path":"missing-historical-file"}],"future":{"preserve":true}}{"model":"fixture/model","modelSource":"explicit","mode":"normal","toolApprovalMode":"ask","disabledMcp":{},"mcpOrder":[]}active��k��C /75�k�draft-dispatchingworkspace-dispatchingproject/fixture/dispatching{"text":"unsent upgrade fixture","attachments":[{"path":"missing-historical-file"}],"future":{"preserve":true}}{"model":"fixture/model","modelSource":"explicit","mode":"normal","toolApprovalMode":"ask","disabledMcp":{},"mcpOrder":[]}active��k���: )1/�k�draft-startingworkspace-startingproject/fixture/starting{"text":"unsent upgrade fixture","attachments":[{"path":"missing-historical-file"}],"future":{"preserve":true}}{"model":"fixture/model","modelSource":"explicit","mode":"normal","toolApprovalMode":"ask","disabledMcp":{},"mcpOrder":[]}active��k���: )1/�k�draft-reservedworkspace-reservedproject/fixture/reserved{"text":"unsent upgrade fixture","attachments":[{"path":"missing-historical-file"}],"future":{"preserve":true}}{"model":"fixture/model","modelSource":"explicit","mode":"normal","toolApprovalMode":"ask","disabledMcp":{},"mcpOrder":[]}active��k��@ +31�k�draft-convertedworkspace-convertedproject/fixture/converted{"text":"unsent upgrade fixture","attachments":[{"path":"missing-historical-file"}],"future":{"preserve":true}}{"model":"fixture/model","modelSource":"explicit","mode":"normal","toolApprovalMode":"ask","disabledMcp":{},"mcpOrder":[]}converted��k�ҁZ 3;9 �draft-settings-onlyworkspace-settings-onlyproject/fixture/settings-only{}{"model":"fixture/model","modelSource":"explicit","mode":"normal","toolApprovalMode":"ask","disabledMcp":{},"mcpOrder":[]}active��k���: )1/�k�draft-editableworkspace-editableproject/fixture/editable{"text":"unsent upgrade fixture","attachments":[{"path":"missing-historical-file"}],"future":{"preserve":true}}{"model":"fixture/model","modelSource":"explicit","mode":"normal","toolApprovalMode":"ask","disabledMcp":{},"mcpOrder":[]}active
30
31 �<!��O�j�����+draft-cancelled
32 %draft-failed 7draft-resume_required 9draft-cancel_requested
33 )draft-accepted 9draft-dispatch_unknown;draft-dispatching_shell/draft-dispatching)draft-starting)draft-reserved+draft-converted3draft-settings-only) draft-editable
34 �0�G�f������3workspace-cancelled
35 -workspace-failed ?workspace-resume_required Aworkspace-cancel_requested
36 1workspace-accepted Aworkspace-dispatch_unknownCworkspace-dispatching_shell7workspace-dispatching1workspace-starting1workspace-reserved;workspace-settings-only1 workspace-editable�� ��$���> ?7?;79�+
37 
38
39 
40 operation-resume_requireddraft-resume_requiredworkspace-resume_requiredsession-resume_requiredtopic-resume_requiredsubmit-resume_requiredsynthetic{"snapshotVersion":4,"draftId":"draft-resume_required","expectedRevision":2,"content":{"text":"frozen historical request"},"settings":{"model":"fixture/frozen","modelSource":"explicit","toolApprovalMode":"read-only"},"futureSnapshot":{"preserve":true}}resume_required��k�T��k�^�FA9A=9;�-
41 
42
43 
44 operation-cancel_requesteddraft-cancel_requestedworkspace-cancel_requestedsession-cancel_requestedtopic-cancel_requestedsubmit-cancel_requestedsynthetic{"snapshotVersion":4,"draftId":"draft-cancel_requested","expectedRevision":2,"content":{"text":"frozen historical request"},"settings":{"model":"fixture/frozen","modelSource":"explicit","toolApprovalMode":"read-only"},"futureSnapshot":{"preserve":true}}cancel_requested��k�H��k�H�1)1-)+�w
45 
46
47 
48 operation-accepteddraft-acceptedworkspace-acceptedsession-acceptedtopic-acceptedsubmit-acceptedsynthetic{"snapshotVersion":4,"draftId":"draft-accepted","expectedRevision":2,"content":{"text":"frozen historical request"},"settings":{"model":"fixture/frozen","modelSource":"explicit","toolApprovalMode":"read-only"},"futureSnapshot":{"preserve":true}}accepted��k�5��k�:�FA9A=9;�-
49 
50
51 
52 operation-dispatch_unknowndraft-dispatch_unknownworkspace-dispatch_unknownsession-dispatch_unknowntopic-dispatch_unknownsubmit-dispatch_unknownsynthetic{"snapshotVersion":4,"draftId":"draft-dispatch_unknown","expectedRevision":2,"content":{"text":"frozen historical request"},"settings":{"model":"fixture/frozen","modelSource":"explicit","toolApprovalMode":"read-only"},"futureSnapshot":{"preserve":true}}dispatch_unknown��k���k�%�NC;C?;=� /
53 
54
55 
56 operation-dispatching_shelldraft-dispatching_shellworkspace-dispatching_shellsession-dispatching_shelltopic-dispatching_shellsubmit-dispatching_shellsynthetic{"snapshotVersion":4,"draftId":"draft-dispatching_shell","expectedRevision":2,"content":{"text":"frozen historical request"},"settings":{"model":"fixture/frozen","modelSource":"explicit","toolApprovalMode":"read-only"},"futureSnapshot":{"preserve":true}}dispatching_shell��k���k��7/73/1�}#
57 
58
59 
60 operation-dispatchingdraft-dispatchingworkspace-dispatchingsession-dispatchingtopic-dispatchingsubmit-dispatchingsynthetic{"snapshotVersion":4,"draftId":"draft-dispatching","expectedRevision":2,"content":{"text":"frozen historical request"},"settings":{"model":"fixture/frozen","modelSource":"explicit","toolApprovalMode":"read-only"},"futureSnapshot":{"preserve":true}}dispatching��k���k��1)1-)+�w
61 
62
63 
64 operation-startingdraft-startingworkspace-startingsession-startingtopic-startingsubmit-startingsynthetic{"snapshotVersion":4,"draftId":"draft-starting","expectedRevision":2,"content":{"text":"frozen historical request"},"settings":{"model":"fixture/frozen","modelSource":"explicit","toolApprovalMode":"read-only"},"futureSnapshot":{"preserve":true}}starting��k����k���1)1-)+�w
65 
66
67
68 operation-reserveddraft-reservedworkspace-reservedsession-reservedtopic-reservedsubmit-reservedsynthetic{"snapshotVersion":4,"draftId":"draft-reserved","expectedRevision":2,"content":{"text":"frozen historical request"},"settings":{"model":"fixture/frozen","modelSource":"explicit","toolApprovalMode":"read-only"},"futureSnapshot":{"preserve":true}}reserved��k����k��
69 3+3/+-�y
70 
71
72 
73 operation-converteddraft-convertedworkspace-convertedsession-convertedtopic-convertedsubmit-convertedsynthetic{"snapshotVersion":4,"draftId":"draft-converted","expectedRevision":2,"content":{"text":"frozen historical request"},"settings":{"model":"fixture/frozen","modelSource":"explicit","toolApprovalMode":"read-only"},"futureSnapshot":{"preserve":true}}accepted��k���
74
75 �K,��b�����3operation-cancelled -operation-failed
76 ?operation-resume_required Aoperation-cancel_requested1operation-acceptedAoperation-dispatch_unknownCoperation-dispatching_shell7operation-dispatching1operation-starting1operation-reserved3 operation-converted
77 �6��P�r����+draft-cancelled��k�� %draft-failed��k��
78 7draft-resume_required��k�^ !9draft-cancel_requested��k�H)draft-accepted��k�:!9draft-dispatch_unknown��k�%";draft-dispatching_shell��k�/draft-dispatching��k�)draft-starting��k��)draft-reserved��k��+ draft-converted��k��
79 
80 BB�; ) S�draft-editable{"text":"losing historical writer"}{"model":"fixture/model","modelSource":"explicit","mode":"normal","toolApprovalMode":"ask","disabledMcp":{},"mcpOrder":[]}��k��
81 ��  conflicts
82 
83 
84 p � _ ��$���> ?7?;79�+
85 
86
87 
88 operation-resume_requireddraft-resume_requiredworkspace-resume_requiredsession-resume_requiredtopic-resume_requiredsubmit-resume_requiredsynthetic{"snapshotVersion":4,"draftId":"draft-resume_required","expectedRevision":2,"content":{"text":"frozen historical request"},"settings":{"model":"fixture/frozen","modelSource":"explicit","toolApprovalMode":"read-only"},"futureSnapshot":{"preserve":true}}resume_required��k�T��k�^�FA9A=9;�-
89 
90
91 
92 operation-cancel_requesteddraft-cancel_requestedworkspace-cancel_requestedsession-cancel_requestedtopic-cancel_requestedsubmit-cancel_requestedsynthetic{"snapshotVersion":4,"draftId":"draft-cancel_requested","expectedRevision":2,"content":{"text":"frozen historical request"},"settings":{"model":"fixture/frozen","modelSource":"explicit","toolApprovalMode":"read-only"},"futureSnapshot":{"preserve":true}}cancel_requested��k�H��k�H�1)1-)+�w
93 
94
95 
96 operation-accepteddraft-acceptedworkspace-acceptedsession-acceptedtopic-acceptedsubmit-acceptedsynthetic{"snapshotVersion":4,"draftId":"draft-accepted","expectedRevision":2,"content":{"text":"frozen historical request"},"settings":{"model":"fixture/frozen","modelSource":"explicit","toolApprovalMode":"read-only"},"futureSnapshot":{"preserve":true}}accepted��k�5��k�:�FA9A=9;�-
97 
98
99 
100 operation-dispatch_unknowndraft-dispatch_unknownworkspace-dispatch_unknownsession-dispatch_unknowntopic-dispatch_unknownsubmit-dispatch_unknownsynthetic{"snapshotVersion":4,"draftId":"draft-dispatch_unknown","expectedRevision":2,"content":{"text":"frozen historical request"},"settings":{"model":"fixture/frozen","modelSource":"explicit","toolApprovalMode":"read-only"},"futureSnapshot":{"preserve":true}}dispatch_unknown��k���k�%�NC;C?;=� /
101 
102
103 
104 operation-dispatching_shelldraft-dispatching_shellworkspace-dispatching_shellsession-dispatching_shelltopic-dispatching_shellsubmit-dispatching_shellsynthetic{"snapshotVersion":4,"draftId":"draft-dispatching_shell","expectedRevision":2,"content":{"text":"frozen historical request"},"settings":{"model":"fixture/frozen","modelSource":"explicit","toolApprovalMode":"read-only"},"futureSnapshot":{"preserve":true}}dispatching_shell��k���k��7/73/1�}#
105 
106
107 
108 operation-dispatchingdraft-dispatchingworkspace-dispatchingsession-dispatchingtopic-dispatchingsubmit-dispatchingsynthetic{"snapshotVersion":4,"draftId":"draft-dispatching","expectedRevision":2,"content":{"text":"frozen historical request"},"settings":{"model":"fixture/frozen","modelSource":"explicit","toolApprovalMode":"read-only"},"futureSnapshot":{"preserve":true}}dispatching��k���k��1)1-)+�w
109 
110
111 
112 operation-startingdraft-startingworkspace-startingsession-startingtopic-startingsubmit-startingsynthetic{"snapshotVersion":4,"draftId":"draft-starting","expectedRevision":2,"content":{"text":"frozen historical request"},"settings":{"model":"fixture/frozen","modelSource":"explicit","toolApprovalMode":"read-only"},"futureSnapshot":{"preserve":true}}starting��k����k���1)1-)+�w
113 
114
115
116 operation-reserveddraft-reservedworkspace-reservedsession-reservedtopic-reservedsubmit-reservedsynthetic{"snapshotVersion":4,"draftId":"draft-reserved","expectedRevision":2,"content":{"text":"frozen historical request"},"settings":{"model":"fixture/frozen","modelSource":"explicit","toolApprovalMode":"read-only"},"futureSnapshot":{"preserve":true}}reserved��k����k��
117 3+3/+-�y
118 
119
120 
121 operation-converteddraft-convertedworkspace-convertedsession-convertedtopic-convertedsubmit-convertedsynthetic{"snapshotVersion":4,"draftId":"draft-converted","expectedRevision":2,"content":{"text":"frozen historical request"},"settings":{"model":"fixture/frozen","modelSource":"explicit","toolApprovalMode":"read-only"},"futureSnapshot":{"preserve":true}}accepted��k����k��
122  �� �� 3+3/+-�y
123 
124
125 
126 operation-cancelleddraft-cancelledworkspace-cancelledsession-cancelledtopic-cancelledsubmit-cancelledsynthetic{"snapshotVersion":4,"draftId":"draft-cancelled","expectedRevision":2,"content":{"text":"frozen historical request"},"settings":{"model":"fixture/frozen","modelSource":"explicit","toolApprovalMode":"read-only"},"futureSnapshot":{"preserve":true}}cancelled��k����k���v
127 -%-)%'�s
128 
129
130 
131 operation-faileddraft-failedworkspace-failedsession-failedtopic-failedsubmit-failedsynthetic{"snapshotVersion":4,"draftId":"draft-failed","expectedRevision":2,"content":{"text":"frozen historical request"},"settings":{"model":"fixture/frozen","modelSource":"explicit","toolApprovalMode":"read-only"},"futureSnapshot":{"preserve":true}}failed��k�w��k��
132 �
133 � � f
134 )��6��R�4 %-+�k�draft-failedworkspace-failedproject/fixture/failed{"text":"unsent upgrade fixture","attachments":[{"path":"missing-historical-file"}],"future":{"preserve":true}}{"model":"fixture/model","modelSource":"explicit","mode":"normal","toolApprovalMode":"ask","disabledMcp":{},"mcpOrder":[]}active��k�q�O 7?=�k�draft-resume_requiredworkspace-resume_requiredproject/fixture/resume_required{"text":"unsent upgrade fixture","attachments":[{"path":"missing-historical-file"}],"future":{"preserve":true}}{"model":"fixture/model","modelSource":"explicit","mode":"normal","toolApprovalMode":"ask","disabledMcp":{},"mcpOrder":[]}active��k�S�R
135 9A?�k�draft-cancel_requestedworkspace-cancel_requestedproject/fixture/cancel_requested{"text":"unsent upgrade fixture","attachments":[{"path":"missing-historical-file"}],"future":{"preserve":true}}{"model":"fixture/model","modelSource":"explicit","mode":"normal","toolApprovalMode":"ask","disabledMcp":{},"mcpOrder":[]}active��k�B�: )1/�k�draft-acceptedworkspace-acceptedproject/fixture/accepted{"text":"unsent upgrade fixture","attachments":[{"path":"missing-historical-file"}],"future":{"preserve":true}}{"model":"fixture/model","modelSource":"explicit","mode":"normal","toolApprovalMode":"ask","disabledMcp":{},"mcpOrder":[]}active��k�4�R 9A?�k�draft-dispatch_unknownworkspace-dispatch_unknownproject/fixture/dispatch_unknown{"text":"unsent upgrade fixture","attachments":[{"path":"missing-historical-file"}],"future":{"preserve":true}}{"model":"fixture/model","modelSource":"explicit","mode":"normal","toolApprovalMode":"ask","disabledMcp":{},"mcpOrder":[]}active��k��U ;CA�k�draft-dispatching_shellworkspace-dispatching_shellproject/fixture/dispatching_shell{"text":"unsent upgrade fixture","attachments":[{"path":"missing-historical-file"}],"future":{"preserve":true}}{"model":"fixture/model","modelSource":"explicit","mode":"normal","toolApprovalMode":"ask","disabledMcp":{},"mcpOrder":[]}active��k��C /75�k�draft-dispatchingworkspace-dispatchingproject/fixture/dispatching{"text":"unsent upgrade fixture","attachments":[{"path":"missing-historical-file"}],"future":{"preserve":true}}{"model":"fixture/model","modelSource":"explicit","mode":"normal","toolApprovalMode":"ask","disabledMcp":{},"mcpOrder":[]}active��k���: )1/�k�draft-startingworkspace-startingproject/fixture/starting{"text":"unsent upgrade fixture","attachments":[{"path":"missing-historical-file"}],"future":{"preserve":true}}{"model":"fixture/model","modelSource":"explicit","mode":"normal","toolApprovalMode":"ask","disabledMcp":{},"mcpOrder":[]}active��k���: )1/�k�draft-reservedworkspace-reservedproject/fixture/reserved{"text":"unsent upgrade fixture","attachments":[{"path":"missing-historical-file"}],"future":{"preserve":true}}{"model":"fixture/model","modelSource":"explicit","mode":"normal","toolApprovalMode":"ask","disabledMcp":{},"mcpOrder":[]}active��k��@ +31�k�draft-convertedworkspace-convertedproject/fixture/converted{"text":"unsent upgrade fixture","attachments":[{"path":"missing-historical-file"}],"future":{"preserve":true}}{"model":"fixture/model","modelSource":"explicit","mode":"normal","toolApprovalMode":"ask","disabledMcp":{},"mcpOrder":[]}converted��k�ҁZ 3;9 �draft-settings-onlyworkspace-settings-onlyproject/fixture/settings-only{}{"model":"fixture/model","modelSource":"explicit","mode":"normal","toolApprovalMode":"ask","disabledMcp":{},"mcpOrder":[]}active��k���: )1/�k�draft-editableworkspace-editableproject/fixture/editable{"text":"unsent upgrade fixture","attachments":[{"path":"missing-historical-file"}],"future":{"preserve":true}}{"model":"fixture/model","modelSource":"explicit","mode":"normal","toolApprovalMode":"ask","disabledMcp":{},"mcpOrder":[]}active��k��
136 ���=
137 +31�k�draft-cancelledworkspace-cancelledproject/fixture/cancelled{"text":"unsent upgrade fixture","attachments":[{"path":"missing-historical-file"}],"future":{"preserve":true}}{"model":"fixture/model","modelSource":"explicit","mode":"normal","toolApprovalMode":"ask","disabledMcp":{},"mcpOrder":[]}active��k��
137 lines Plain Text