From aaae5693485ae850bfe2c9506f2586a9542641bf Mon Sep 17 00:00:00 2001
From: Helmut Grohne <helmut@subdivi.de>
Date: Thu, 8 Oct 2020 17:16:06 +0200
Subject: add build architecture to schema of depstate table

---
 schema.sql | 5 +++--
 1 file changed, 3 insertions(+), 2 deletions(-)

(limited to 'schema.sql')

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,
-- 
cgit v1.2.3

