1 files changed, 4 insertions, 2 deletions
diff --git a/schema.sql b/schema.sql
index 99ae7e5..3a49daf 100644
--- a/schema.sql
+++ b/schema.sql
@@ -1,10 +1,12 @@
 CREATE TABLE package (		-- binary Debian packages
 	id INTEGER PRIMARY KEY,
-	name TEXT UNIQUE NOT NULL,
+	name TEXT NOT NULL,
 	-- binary package name
 	version TEXT,		-- Debian version
 	architecture TEXT,
-	source TEXT);		-- name of the source package it was built from
+	source TEXT,		-- name of the source package it was built from
+	multiarch TEXT,		-- value of the Multi-Arch field
+	UNIQUE (name, architecture));
 
 CREATE TABLE content (		-- a file contained in a binary package
 	id INTEGER PRIMARY KEY,