From a2eccde5e1e83f77bd015990279f75f8b3c7db4a Mon Sep 17 00:00:00 2001
From: Helmut Grohne <helmut@subdivi.de>
Date: Sun, 24 Mar 2019 07:25:38 +0100
Subject: table buildreqeusts should have an explicit id

We rely on the id being constant. However, sqlite does not guarantee
that the implicit rowid stays constant across vacuum. Making the rowid
explicit fixes that.
---
 schema.sql | 1 +
 1 file changed, 1 insertion(+)

(limited to 'schema.sql')

diff --git a/schema.sql b/schema.sql
index 62ce9c4..d7854a2 100644
--- a/schema.sql
+++ b/schema.sql
@@ -32,6 +32,7 @@ CREATE TABLE builds (
 	filename TEXT NOT NULL);
 
 CREATE TABLE buildrequests (
+	id INTEGER PRIMARY KEY,
 	source TEXT NOT NULL,
 	architecture TEXT,
 	requesttime TIMESTAMP NOT NULL,
-- 
cgit v1.2.3

