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 @ .0:
~ ��(y�
G � � + �
� �
� �:~�R �x �?tabletemp_pinstemp_pinsCREATE TABLE temp_pins (
id INTEGER NOT NULL,
block_id INTEGER NOT NULL,
PRIMARY KEY(id,block_id)
CONSTRAINT fk_block_id
FOREIGN KEY (block_id)
REFERENCES cids(id)
ON DELETE CASCADE
)�c�)tablerefsrefsCREATE TABLE refs (
parent_id INTEGER NOT NULL,
child_id INTEGER NOT NULL,
PRIMARY KEY(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
)q�EtablecidscidsCREATE TABLE cids (
id INTEGER PRIMARY KEY AUTOINCREMENT,
cid BLOB UNIQUE NOT NULL
)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) � 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)
� � - 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)j ~ �`
�tablealiasesaliases CREATE TABLE aliases (
name blob NOT NULL PRIMARY KEY,
block_id INTEGER NOT NULL,
CONSTRAINT fk_block_id
FOREIGN KEY (block_id)
REFERENCES cids(id)
ON DELETE CASCADE
)'; indexsqlite_autoindex_refs_1refs@#Windexidx_cids_idcidsCREATE INDEX idx_cids_id
ON cids (id)� e '; indexsqlite_autoindex_cids_1cids
�� R
�� Q
��
��
��
��
��
��
��
� �