返回 DeepSeek-Reasonix
drafts.sqlite
根目录 / desktop / testdata / manual-session-upgrade / main-v2-pr10572 / 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��l
29 ��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��l
30 ~�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��l
31 u�R
32 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��l
33 X�: )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��l
34 W�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��l
35 V�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��l
36 V�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��l
37 U�: )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��l
38 U�: )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��l
39 T�@ +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��l
40 S�Z 3;9 �draft-settings-onlyworkspace-settings-onlyproject/fixture/settings-only{}{"model":"fixture/model","modelSource":"explicit","mode":"normal","toolApprovalMode":"ask","disabledMcp":{},"mcpOrder":[]}active��l
41 �: )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
42
43 �<!��O�j�����+draft-cancelled
44 %draft-failed 7draft-resume_required 9draft-cancel_requested
45 )draft-accepted 9draft-dispatch_unknown;draft-dispatching_shell/draft-dispatching)draft-starting)draft-reserved+draft-converted3draft-settings-only) draft-editable
46 �0�G�f������3workspace-cancelled
47 -workspace-failed ?workspace-resume_required Aworkspace-cancel_requested
48 1workspace-accepted Aworkspace-dispatch_unknownCworkspace-dispatching_shell7workspace-dispatching1workspace-starting1workspace-reserved;workspace-settings-only1 workspace-editable�� ��$���> ?7?;79�+
49 
50
51 
52 operation-resume_requireddraft-resume_requiredworkspace-resume_requiredsession-resume_requiredtopic-resume_requiredsubmit-resume_requiredsynthetic{"snapshotVersion":5,"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��l
53 v��l
54 {�FA9A=9;�-
55 
56
57 
58 operation-cancel_requesteddraft-cancel_requestedworkspace-cancel_requestedsession-cancel_requestedtopic-cancel_requestedsubmit-cancel_requestedsynthetic{"snapshotVersion":5,"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��l
59 p��l
60 q�1)1-)+�w
61 
62
63 
64 operation-accepteddraft-acceptedworkspace-acceptedsession-acceptedtopic-acceptedsubmit-acceptedsynthetic{"snapshotVersion":5,"draftId":"draft-accepted","expectedRevision":2,"content":{"text":"frozen historical request"},"settings":{"model":"fixture/frozen","modelSource":"explicit","toolApprovalMode":"read-only"},"futureSnapshot":{"preserve":true}}accepted��l
65 W��l
66 W�FA9A=9;�-
67 
68
69 
70 operation-dispatch_unknowndraft-dispatch_unknownworkspace-dispatch_unknownsession-dispatch_unknowntopic-dispatch_unknownsubmit-dispatch_unknownsynthetic{"snapshotVersion":5,"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��l
71 W��l
72 W�NC;C?;=� /
73 
74
75 
76 operation-dispatching_shelldraft-dispatching_shellworkspace-dispatching_shellsession-dispatching_shelltopic-dispatching_shellsubmit-dispatching_shellsynthetic{"snapshotVersion":5,"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��l
77 V��l
78 V�7/73/1�}#
79 
80
81 
82 operation-dispatchingdraft-dispatchingworkspace-dispatchingsession-dispatchingtopic-dispatchingsubmit-dispatchingsynthetic{"snapshotVersion":5,"draftId":"draft-dispatching","expectedRevision":2,"content":{"text":"frozen historical request"},"settings":{"model":"fixture/frozen","modelSource":"explicit","toolApprovalMode":"read-only"},"futureSnapshot":{"preserve":true}}dispatching��l
83 U��l
84 V�1)1-)+�w
85 
86
87 
88 operation-startingdraft-startingworkspace-startingsession-startingtopic-startingsubmit-startingsynthetic{"snapshotVersion":5,"draftId":"draft-starting","expectedRevision":2,"content":{"text":"frozen historical request"},"settings":{"model":"fixture/frozen","modelSource":"explicit","toolApprovalMode":"read-only"},"futureSnapshot":{"preserve":true}}starting��l
89 U��l
90 U�1)1-)+�w
91 
92
93
94 operation-reserveddraft-reservedworkspace-reservedsession-reservedtopic-reservedsubmit-reservedsynthetic{"snapshotVersion":5,"draftId":"draft-reserved","expectedRevision":2,"content":{"text":"frozen historical request"},"settings":{"model":"fixture/frozen","modelSource":"explicit","toolApprovalMode":"read-only"},"futureSnapshot":{"preserve":true}}reserved��l
95 T��l
96 T�
97 3+3/+-�y
98 
99
100 
101 operation-converteddraft-convertedworkspace-convertedsession-convertedtopic-convertedsubmit-convertedsynthetic{"snapshotVersion":5,"draftId":"draft-converted","expectedRevision":2,"content":{"text":"frozen historical request"},"settings":{"model":"fixture/frozen","modelSource":"explicit","toolApprovalMode":"read-only"},"futureSnapshot":{"preserve":true}}accepted��l
102 1�
103
104 �K,��b�����3operation-cancelled -operation-failed
105 ?operation-resume_required Aoperation-cancel_requested1operation-acceptedAoperation-dispatch_unknownCoperation-dispatching_shell7operation-dispatching1operation-starting1operation-reserved3 operation-converted
106 �6��P�r����+draft-cancelled��l
107 � %draft-failed��l
108 �
109 7draft-resume_required��l
110 { !9draft-cancel_requested��l
111 q)draft-accepted��l
112 W!9draft-dispatch_unknown��l
113 W";draft-dispatching_shell��l
114 V/draft-dispatching��l
115 V)draft-starting��l
116 U)draft-reserved��l
117 T+ draft-converted��l
118 B
119 
120 BB�; ) S�draft-editable{"text":"losing historical writer"}{"model":"fixture/model","modelSource":"explicit","mode":"normal","toolApprovalMode":"ask","disabledMcp":{},"mcpOrder":[]}��l
121 
122 ��  conflicts
123 
124 
125 p � _ ��$���> ?7?;79�+
126 
127
128 
129 operation-resume_requireddraft-resume_requiredworkspace-resume_requiredsession-resume_requiredtopic-resume_requiredsubmit-resume_requiredsynthetic{"snapshotVersion":5,"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��l
130 v��l
131 {�FA9A=9;�-
132 
133
134 
135 operation-cancel_requesteddraft-cancel_requestedworkspace-cancel_requestedsession-cancel_requestedtopic-cancel_requestedsubmit-cancel_requestedsynthetic{"snapshotVersion":5,"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��l
136 p��l
137 q�1)1-)+�w
138 
139
140 
141 operation-accepteddraft-acceptedworkspace-acceptedsession-acceptedtopic-acceptedsubmit-acceptedsynthetic{"snapshotVersion":5,"draftId":"draft-accepted","expectedRevision":2,"content":{"text":"frozen historical request"},"settings":{"model":"fixture/frozen","modelSource":"explicit","toolApprovalMode":"read-only"},"futureSnapshot":{"preserve":true}}accepted��l
142 W��l
143 W�FA9A=9;�-
144 
145
146 
147 operation-dispatch_unknowndraft-dispatch_unknownworkspace-dispatch_unknownsession-dispatch_unknowntopic-dispatch_unknownsubmit-dispatch_unknownsynthetic{"snapshotVersion":5,"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��l
148 W��l
149 W�NC;C?;=� /
150 
151
152 
153 operation-dispatching_shelldraft-dispatching_shellworkspace-dispatching_shellsession-dispatching_shelltopic-dispatching_shellsubmit-dispatching_shellsynthetic{"snapshotVersion":5,"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��l
154 V��l
155 V�7/73/1�}#
156 
157
158 
159 operation-dispatchingdraft-dispatchingworkspace-dispatchingsession-dispatchingtopic-dispatchingsubmit-dispatchingsynthetic{"snapshotVersion":5,"draftId":"draft-dispatching","expectedRevision":2,"content":{"text":"frozen historical request"},"settings":{"model":"fixture/frozen","modelSource":"explicit","toolApprovalMode":"read-only"},"futureSnapshot":{"preserve":true}}dispatching��l
160 U��l
161 V�1)1-)+�w
162 
163
164 
165 operation-startingdraft-startingworkspace-startingsession-startingtopic-startingsubmit-startingsynthetic{"snapshotVersion":5,"draftId":"draft-starting","expectedRevision":2,"content":{"text":"frozen historical request"},"settings":{"model":"fixture/frozen","modelSource":"explicit","toolApprovalMode":"read-only"},"futureSnapshot":{"preserve":true}}starting��l
166 U��l
167 U�1)1-)+�w
168 
169
170
171 operation-reserveddraft-reservedworkspace-reservedsession-reservedtopic-reservedsubmit-reservedsynthetic{"snapshotVersion":5,"draftId":"draft-reserved","expectedRevision":2,"content":{"text":"frozen historical request"},"settings":{"model":"fixture/frozen","modelSource":"explicit","toolApprovalMode":"read-only"},"futureSnapshot":{"preserve":true}}reserved��l
172 T��l
173 T�
174 3+3/+-�y
175 
176
177 
178 operation-converteddraft-convertedworkspace-convertedsession-convertedtopic-convertedsubmit-convertedsynthetic{"snapshotVersion":5,"draftId":"draft-converted","expectedRevision":2,"content":{"text":"frozen historical request"},"settings":{"model":"fixture/frozen","modelSource":"explicit","toolApprovalMode":"read-only"},"futureSnapshot":{"preserve":true}}accepted��l
179 1��l
180 B
181  �� �� 3+3/+-�y
182 
183
184 
185 operation-cancelleddraft-cancelledworkspace-cancelledsession-cancelledtopic-cancelledsubmit-cancelledsynthetic{"snapshotVersion":5,"draftId":"draft-cancelled","expectedRevision":2,"content":{"text":"frozen historical request"},"settings":{"model":"fixture/frozen","modelSource":"explicit","toolApprovalMode":"read-only"},"futureSnapshot":{"preserve":true}}cancelled��l
186 ���l
187 ��v
188 -%-)%'�s
189 
190
191 
192 operation-faileddraft-failedworkspace-failedsession-failedtopic-failedsubmit-failedsynthetic{"snapshotVersion":5,"draftId":"draft-failed","expectedRevision":2,"content":{"text":"frozen historical request"},"settings":{"model":"fixture/frozen","modelSource":"explicit","toolApprovalMode":"read-only"},"futureSnapshot":{"preserve":true}}failed��l
193 ���l
194 �
195 �
196 � � f
197 )��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��l
198 ~�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��l
199 u�R
200 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��l
201 X�: )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��l
202 W�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��l
203 V�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��l
204 V�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��l
205 U�: )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��l
206 U�: )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��l
207 T�@ +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��l
208 S�Z 3;9 �draft-settings-onlyworkspace-settings-onlyproject/fixture/settings-only{}{"model":"fixture/model","modelSource":"explicit","mode":"normal","toolApprovalMode":"ask","disabledMcp":{},"mcpOrder":[]}active��l
209 �: )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��l
210 
211 ���=
212 +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��l
213 �
213 lines Plain Text