1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
SQLite format 3 @
.zq
� � X��
bo l
) % �
� 0�� �C5�5indexweb_evidence_anchor_subjectweb_evidence_anchorsCREATE INDEX web_evidence_anchor_subject
ON web_evidence_anchors(subject, anchor_id)�'
A)�qindexevidence_facts_subject_seqevidence_factsCREATE INDEX evidence_facts_subject_seq
ON evidence_facts(subject, captured_at_seq ASC, predicate ASC, object ASC)y ;+�indexedit_projection_doc_seqedit_projection
CREATE INDEX edit_projection_doc_seq
ON edit_projection(doc, seq DESC)�
55�_tableweb_evidence_anchorsweb_evidence_anchors CREATE TABLE web_evidence_anchors (
anchor_id TEXT PRIMARY KEY NOT NULL,
subject TEXT NOT NULL,
representation_id TEXT NOT NULL REFERENCES web_representations(representation_id) ON DELETE RESTRICT,
record_json TEXT NOT NULL
)G [5 indexsqlite_autoindex_web_evidence_anchors_1web_evidence_anchors �
33�Atableweb_representationsweb_representations CREATE TABLE web_representations (
representation_id TEXT PRIMARY KEY NOT NULL,
capture_id TEXT NOT NULL REFERENCES web_captures(capture_id) ON DELETE RESTRICT,
text TEXT NOT NULL,
metadata_json TEXT NOT NULL
)E Y3 indexsqlite_autoindex_web_representations_1web_representations
�:%%�7tableweb_capturesweb_capturesCREATE TABLE web_captures (
capture_id TEXT PRIMARY KEY NOT NULL,
source_uri TEXT NOT NULL,
body BLOB NOT NULL,
exchange_json TEXT NOT NULL
)7K% indexsqlite_autoindex_web_captures_1web_captures�
))�Otableevidence_factsevidence_factsCREATE TABLE evidence_facts (
subject TEXT NOT NULL,
predicate TEXT NOT NULL,
object TEXT NOT NULL,
captured_at_seq INTEGER NOT NULL,
immutable_hint TEXT,
PRIMARY KEY(subject, predicate, object, captured_at_seq)
);O) indexsqlite_autoindex_evidence_facts_1evidence_facts�)++� tableedit_projectionedit_projectionCREATE TABLE edit_projection (
seq INTEGER PRIMARY KEY,
doc TEXT NOT NULL,
edit TEXT NOT NULL,
inverse TEXT NOT NULL
)u�MtabledocsdocsCREATE TABLE docs (
id TEXT PRIMARY KEY NOT NULL,
kind TEXT NOT NULL,
body TEXT NOT NULL
)'; indexsqlite_autoindex_docs_1docs