add build architecture to schema of depstate table

1 files changed, 3 insertions, 2 deletions

diff --git a/schema.sql b/schema.sql
index 1c2a2ec..7c591c9 100644
--- a/schema.sql
+++ b/schema.sql
@@ -3,10 +3,11 @@
 CREATE TABLE depstate (
 	source TEXT NOT NULL,
 	version TEXT NOT NULL,
-	architecture TEXT NOT NULL,
+	buildarch TEXT NOT NULL,
+	hostarch TEXT NOT NULL,
 	satisfiable BOOLEAN NOT NULL CHECK (satisfiable in (0, 1)),
 	reason TEXT,
-	UNIQUE (source, architecture, version));
+	UNIQUE (source, buildarch, hostarch, version));
 
 CREATE TABLE depcheck (
 	architecture TEXT NOT NULL UNIQUE,