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
SQLite format 3 @ .O|
I
� v�Q�a�y �< � � u
?)�indexix_tags_plaintext_item_idtags_plaintextCREATE INDEX ix_tags_plaintext_item_id ON tags_plaintext(item_id)o;)�indexix_tags_plaintext_valuetags_plaintext
CREATE INDEX ix_tags_plaintext_value ON tags_plaintext(value)l9)�indexix_tags_plaintext_nametags_plaintextCREATE INDEX ix_tags_plaintext_name ON tags_plaintext(name)�: ))�/tabletags_plaintexttags_plaintext
CREATE TABLE tags_plaintext(
name NOT NULL,
value NOT NULL,
item_id INTEGER NOT NULL,
PRIMARY KEY(name, item_id),
FOREIGN KEY(item_id)
REFERENCES items(id)
ON DELETE CASCADE
ON UPDATE CASCADE
);
O) indexsqlite_autoindex_tags_plaintext_1tags_plaintextu?)�indexix_tags_encrypted_item_idtags_encrypted CREATE INDEX ix_tags_encrypted_item_id ON tags_encrypted(item_id)o;)�indexix_tags_encrypted_valuetags_encryptedCREATE INDEX ix_tags_encrypted_value ON tags_encrypted(value)l9)�indexix_tags_encrypted_nametags_encryptedCREATE INDEX ix_tags_encrypted_name ON tags_encrypted(name)�:))�/tabletags_encryptedtags_encryptedCREATE TABLE tags_encrypted(
name NOT NULL,
value NOT NULL,
item_id INTEGER NOT NULL,
PRIMARY KEY(name, item_id),
FOREIGN KEY(item_id)
REFERENCES items(id)
ON DELETE CASCADE
ON UPDATE CASCADE
);O) indexsqlite_autoindex_tags_encrypted_1tags_encrypted _1�indexux_items_type_nameitemsCREATE UNIQUE INDEX ux_items_type_name ON items(type, name)�A�atableitemsitemsCREATE TABLE items(
id INTEGER NOT NULL,
type NOT NULL,
name NOT NULL,
value NOT NULL,
key NOT NULL,
PRIMARY KEY(id)
)��atablemetadatametadataCREATE TABLE metadata (
id INTEGER NOT NULL,
value NOT NULL,
PRIMARY KEY(id)
)
2 2 �K �{"keys":[218,166,131,109,86,196,204,109,222,175,26,218,52,132,28,81,2,187,238,60,59,67,96,43,106,18,117,59,26,111,157,79,54,138,170,232,216,158,223,179,106,96,20,35,197,221,15,132,61,104,60,129,135,208,26,130,50,49,214,106,110,252,228,77,224,243,155,60,233,63,100,57,89,118,66,163,162,67,58,133,49,79,11,156,102,73,49,147,242,40,158,180,93,232,47,135,197,61,45,35,203,107,209,46,51,214,232,200,126,70,243,77,53,118,43,3,83,242,193,203,1,48,11,107,162,136,123,146,91,10,23,5,241,43,254,238,209,62,183,27,176,22,131,80,251,211,159,237,103,197,247,191,119,206,11,15,11,23,229,85,106,6,133,181,80,225,242,143,47,143,232,159,125,196,98,87,93,89,231,239,231,139,97,138,237,174,150,158,249,120,193,72,180,222,233,52,66,56,201,28,12,127,207,62,107,234,184,233,29,34,111,169,104,174,152,241,54,54,177,83,179,180,222,67,40,249,49,99,97,180,161,29,207,39,112,156,153,114,204,153,230,105,203,42,159,49,80,135,157,17,84,38,251,170,81,21,237,241,92,129,80,153,204,135,178,123,239]}