allow scheduling builds via webapp

1 files changed, 6 insertions, 0 deletions

diff --git a/schema.sql b/schema.sql
index e76dde0..62ce9c4 100644
--- a/schema.sql
+++ b/schema.sql
@@ -30,3 +30,9 @@ CREATE TABLE builds (
 	success BOOLEAN NOT NULL CHECK (success in (0, 1)),
 	starttime TIMESTAMP NOT NULL,
 	filename TEXT NOT NULL);
+
+CREATE TABLE buildrequests (
+	source TEXT NOT NULL,
+	architecture TEXT,
+	requesttime TIMESTAMP NOT NULL,
+        priority INTEGER NOT NULL DEFAULT 0);