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