Add deduper (unfinished tool for finding image duplicates).

1 files changed, 23 insertions, 0 deletions

diff --git a/deduper/libpuzzle/php/examples/similar/schema.sqlite3.sql b/deduper/libpuzzle/php/examples/similar/schema.sqlite3.sql
new file mode 100644
index 0000000..dc5a6c3
--- /dev/null
+++ b/deduper/libpuzzle/php/examples/similar/schema.sqlite3.sql
@@ -0,0 +1,23 @@
+CREATE TABLE pictures (
+  id INTEGER PRIMARY KEY AUTOINCREMENT,
+  digest CHAR(32) NOT NULL
+);
+CREATE TABLE sentpictures (
+  id INTEGER PRIMARY KEY AUTOINCREMENT,
+  url VARCHAR(255) NOT NULL,
+  sender VARCHAR(100) NOT NULL,  
+  picture_id INTEGER NOT NULL
+);
+CREATE TABLE signatures (
+  id INTEGER PRIMARY KEY AUTOINCREMENT,
+  compressed_signature CHAR(182) NOT NULL,
+  picture_id INTEGER NOT NULL
+);
+CREATE TABLE words (
+  pos_and_word CHAR(5) NOT NULL,
+  signature_id INTEGER NOT NULL
+);
+CREATE UNIQUE INDEX idx_digest ON pictures(digest);
+CREATE INDEX idx_picture_id ON sentpictures (picture_id);
+CREATE INDEX idx_pos_and_word ON words(pos_and_word);
+CREATE UNIQUE INDEX idx_url ON sentpictures (url);