1CREATE TABLE pictures (
2  id INTEGER PRIMARY KEY AUTOINCREMENT,
3  digest CHAR(32) NOT NULL
4);
5CREATE TABLE sentpictures (
6  id INTEGER PRIMARY KEY AUTOINCREMENT,
7  url VARCHAR(255) NOT NULL,
8  sender VARCHAR(100) NOT NULL,
9  picture_id INTEGER NOT NULL
10);
11CREATE TABLE signatures (
12  id INTEGER PRIMARY KEY AUTOINCREMENT,
13  compressed_signature CHAR(182) NOT NULL,
14  picture_id INTEGER NOT NULL
15);
16CREATE TABLE words (
17  pos_and_word CHAR(5) NOT NULL,
18  signature_id INTEGER NOT NULL
19);
20CREATE UNIQUE INDEX idx_digest ON pictures(digest);
21CREATE INDEX idx_picture_id ON sentpictures (picture_id);
22CREATE INDEX idx_pos_and_word ON words(pos_and_word);
23CREATE UNIQUE INDEX idx_url ON sentpictures (url);
24