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
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
SQLite format 3 @ . �
� R j�(
��
G � � + �
� �
� �:�R T- kindexidx_temp_pins_idtemp_pinsCREATE INDEX idx_temp_pins_id
ON temp_pins (id)g9 �indexidx_temp_pins_block_idtemp_pinsCREATE INDEX idx_temp_pins_block_id
ON temp_pins (block_id)�s �5tabletemp_pinstemp_pinsCREATE TABLE temp_pins (
id INTEGER NOT NULL,
block_id INTEGER NOT NULL,
UNIQUE(id,block_id)
CONSTRAINT fk_block_id
FOREIGN KEY (block_id)
REFERENCES cids(id)
ON DELETE CASCADE
)1E indexsqlite_autoindex_temp_pins_1temp_pinsc�%tablestatsstatsCREATE TABLE stats (
count INTEGER NOT NULL,
size INTEGER NOT NULL
)j9%�indexidx_temp_aliases_aliastemp_aliasesCREATE INDEX idx_temp_aliases_alias
ON temp_aliases (alias)s?%�indexidx_temp_aliases_block_idtemp_aliasesCREATE INDEX idx_temp_aliases_block_id
ON temp_aliases (block_id)�
%%�Gtabletemp_aliasestemp_aliasesCREATE TABLE temp_aliases (
alias INTEGER NOT NULL,
block_id INTEGER NOT NULL,
UNIQUE(alias,block_id)
CONSTRAINT fk_block_id
FOREIGN KEY (block_id)
REFERENCES cids(id)
ON DELETE CASCADE
)7K% indexsqlite_autoindex_temp_aliases_1temp_aliases^ 5{indexidx_aliases_block_idaliases
CREATE INDEX idx_aliases_block_id
ON aliases (block_id)�[
�
tablealiasesaliases CREATE TABLE aliases (
name blob UNIQUE NOT NULL,
block_id INTEGER NOT NULL,
CONSTRAINT fk_block_id
FOREIGN KEY (block_id)
REFERENCES cids(id)
ON DELETE CASCADE
)- A indexsqlite_autoindex_aliases_1aliases Z 3windexidx_blocks_block_idblocks
CREATE INDEX idx_blocks_block_id
ON blocks (block_id)j�/tableblocksblocks CREATE TABLE blocks (
block_id INTEGER PRIMARY_KEY,
block BLOB NOT NULL
)R/oindexidx_refs_child_idrefsCREATE INDEX idx_refs_child_id
ON refs (child_id)U1sindexidx_refs_parent_idrefsCREATE INDEX idx_refs_parent_id
ON refs (parent_id)�^� tablerefsrefsCREATE TABLE refs (
parent_id INTEGER NOT NULL,
child_id INTEGER NOT NULL,
UNIQUE(parent_id,child_id)
CONSTRAINT fk_parent_id
FOREIGN KEY (parent_id)
REFERENCES cids(id)
ON DELETE CASCADE
CONSTRAINT fk_child_id
FOREIGN KEY (child_id)
REFERENCES cids(id)
ON DELETE CASCADE
)'; indexsqlite_autoindex_refs_1refs@#Windexidx_cids_idcidsCREATE INDEX idx_cids_id
ON cids (id)c�)tablecidscidsCREATE TABLE cids (
id INTEGER PRIMARY KEY,
cid BLOB UNIQUE NOT NULL
)'; indexsqlite_autoindex_cids_1cids
�� R
�� Q
��
��
��
��
��
��
��
� �