From 7f3d8c5098d23bb43b86e060700170cc41cd22aa Mon Sep 17 00:00:00 2001 From: Helmut Grohne Date: Sat, 7 Sep 2013 21:04:40 +0200 Subject: permit multiple architectures per package While the importer can easily cope with this change, the web presentation still needs fixing. It works somewhat now. --- schema.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'schema.sql') diff --git a/schema.sql b/schema.sql index 2ab7ca7..7098a71 100644 --- a/schema.sql +++ b/schema.sql @@ -1,4 +1,4 @@ -CREATE TABLE package (id INTEGER PRIMARY KEY, name TEXT UNIQUE, version TEXT, architecture TEXT, source TEXT); +CREATE TABLE package (id INTEGER PRIMARY KEY, name TEXT, version TEXT, architecture TEXT, source 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); -- cgit v1.2.3