From ed47c1557915bb2472f6959e723cd76155312a98 Mon Sep 17 00:00:00 2001
From: Chris Xiong <chirs241097@gmail.com>
Date: Mon, 6 Apr 2020 00:50:58 +0800
Subject: Add deduper (unfinished tool for finding image duplicates).

---
 .../php/examples/similar/schema.sqlite3.sql        | 23 ++++++++++++++++++++++
 1 file changed, 23 insertions(+)
 create mode 100644 deduper/libpuzzle/php/examples/similar/schema.sqlite3.sql

(limited to 'deduper/libpuzzle/php/examples/similar/schema.sqlite3.sql')

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);
-- 
cgit v1.2.3

