summaryrefslogtreecommitdiff
path: root/schema.sql
diff options
context:
space:
mode:
authorHelmut Grohne <helmut@subdivi.de>2013-09-07 21:24:15 +0200
committerHelmut Grohne <helmut@subdivi.de>2013-09-07 21:24:15 +0200
commitba9ae116e0bbb25e2df327ba48c82472ccfa2690 (patch)
tree74eb9d6780fe8fe0349d818e9a3fa5ce40726ca7 /schema.sql
parent7f3d8c5098d23bb43b86e060700170cc41cd22aa (diff)
downloaddebian-dedup-ba9ae116e0bbb25e2df327ba48c82472ccfa2690.tar.gz
record multi-arch header in package table
Diffstat (limited to 'schema.sql')
-rw-r--r--schema.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/schema.sql b/schema.sql
index 7098a71..30f6109 100644
--- a/schema.sql
+++ b/schema.sql
@@ -1,4 +1,4 @@
-CREATE TABLE package (id INTEGER PRIMARY KEY, name TEXT, version TEXT, architecture TEXT, source TEXT, UNIQUE (name, architecture));
+CREATE TABLE package (id INTEGER PRIMARY KEY, name TEXT, version TEXT, architecture TEXT, source TEXT, multiarch TEXT, UNIQUE (name, architecture));
CREATE TABLE content (id INTEGER PRIMARY KEY, pid INTEGER, filename TEXT, size INTEGER, FOREIGN KEY (pid) REFERENCES package(id) ON DELETE CASCADE);
CREATE TABLE function (id INTEGER PRIMARY KEY, name TEXT UNIQUE NOT NULL, eqclass INTEGER);
INSERT INTO function (name, eqclass) VALUES ("sha512", 1), ("gzip_sha512", 1), ("png_sha512", 2), ("gif_sha512", 2);