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
SQLite format 3 @
.O|
� � W�
B(��F
�
�
K �
��ktablemetadatametadataCREATE TABLE metadata (
key TEXT PRIMARY KEY,
value TEXT NOT NULL
)/C indexsqlite_autoindex_metadata_1metadata
O
-iindexidx_links_targetlinksCREATE INDEX idx_links_target ON links(target)I )aindexidx_links_baselinks
CREATE INDEX idx_links_base ON links(base)]3{indexidx_entries_createdentries CREATE INDEX idx_entries_created ON entries(created_at)`7}indexidx_actions_timestampactionsCREATE INDEX idx_actions_timestamp ON actions(timestamp)N+eindexidx_actions_seqactionsCREATE INDEX idx_actions_seq ON actions(seq)�G�mtablelinkslinksCREATE TABLE links (
id INTEGER PRIMARY KEY,
base BLOB NOT NULL,
target BLOB NOT NULL,
link_type INTEGER NOT NULL,
tag BLOB,
timestamp INTEGER NOT NULL,
deleted INTEGER DEFAULT 0
)�c�tableentriesentriesCREATE TABLE entries (
hash BLOB PRIMARY KEY,
entry_type TEXT NOT NULL,
content BLOB NOT NULL,
created_at INTEGER NOT NULL
)-A indexsqlite_autoindex_entries_1entries�o�5tableactionsactionsCREATE TABLE actions (
hash BLOB PRIMARY KEY,
seq INTEGER NOT NULL,
timestamp INTEGER NOT NULL,
action_type TEXT NOT NULL,
author BLOB NOT NULL,
prev_action BLOB,
entry_hash BLOB,
data BLOB NOT NULL
)-A indexsqlite_autoindex_actions_1actions