summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorHelmut Grohne <helmut@subdivi.de>2013-07-10 15:23:15 +0200
committerHelmut Grohne <helmut@subdivi.de>2013-07-10 15:23:15 +0200
commitada4f94466bf3eddc192cf22c8ecefc9cd5f0ea3 (patch)
tree0413aba3a8e7ca1d7f4ffb01ba4b88428d7c2fd6
parente85fb930e71f27a1a399273b433ba67d0eb6d3c5 (diff)
downloaddebian-dedup-ada4f94466bf3eddc192cf22c8ecefc9cd5f0ea3.tar.gz
schema.sql: drop unused index
sharing_package_index is a sub-index of sharing_insert_index and therefore unnecessary.
-rw-r--r--schema.sql1
1 files changed, 0 insertions, 1 deletions
diff --git a/schema.sql b/schema.sql
index e942c7b..94f0317 100644
--- a/schema.sql
+++ b/schema.sql
@@ -8,5 +8,4 @@ CREATE INDEX hash_hash_index ON hash (hash);
CREATE TABLE sharing (package1 TEXT, package2 TEXT, func1 TEXT, func2 TEXT, files INTEGER, size INTEGER, FOREIGN KEY (package1) REFERENCES package(package) ON DELETE CASCADE, FOREIGN KEY (package2) REFERENCES package(package) ON DELETE CASCADE);
CREATE INDEX sharing_insert_index ON sharing (package1, package2, func1, func2);
-CREATE INDEX sharing_package_index ON sharing (package1);
CREATE TABLE duplicate (cid INTEGER PRIMARY KEY, FOREIGN KEY (cid) REFERENCES content(id) ON DELETE CASCADE);