summaryrefslogtreecommitdiff
path: root/schema.sql
diff options
context:
space:
mode:
authorHelmut Grohne <helmut@subdivi.de>2013-07-25 13:28:19 +0200
committerHelmut Grohne <helmut@subdivi.de>2013-07-25 13:28:19 +0200
commit9b653583711c59d96c45af43ff8ee9534500adb6 (patch)
treeaca58a607a571f1f46294e2cfa4f20ce06746771 /schema.sql
parent796eeb217e449234b777512451c5b668837c9118 (diff)
downloaddebian-dedup-9b653583711c59d96c45af43ff8ee9534500adb6.tar.gz
display "issues" with files in package view
Currently this is invalid .gz files and png files not named .png.
Diffstat (limited to 'schema.sql')
-rw-r--r--schema.sql1
1 files changed, 1 insertions, 0 deletions
diff --git a/schema.sql b/schema.sql
index e9e0bcc..8a94882 100644
--- a/schema.sql
+++ b/schema.sql
@@ -9,3 +9,4 @@ CREATE INDEX hash_hash_index ON hash (hash);
CREATE TABLE sharing (pid1 INTEGER, pid2 INTEGER, func1 TEXT, func2 TEXT, files INTEGER, size INTEGER, FOREIGN KEY (pid1) REFERENCES package(id) ON DELETE CASCADE, FOREIGN KEY (pid2) REFERENCES package(id) ON DELETE CASCADE);
CREATE INDEX sharing_insert_index ON sharing (pid1, pid2, func1, func2);
CREATE TABLE duplicate (cid INTEGER PRIMARY KEY, FOREIGN KEY (cid) REFERENCES content(id) ON DELETE CASCADE);
+CREATE TABLE issue (cid INTEGER REFERENCES content(id) ON DELETE CASCADE, issue TEXT);