From a6ccbd113de22ddf606440c05a4134fb28a0d380 Mon Sep 17 00:00:00 2001
From: Helmut Grohne <helmut@subdivi.de>
Date: Mon, 13 Jan 2020 20:07:00 +0100
Subject: fetch and display bugs

Retrieve bugs from udd-mirror by tags/usertags and display relevant bug
numbers in the webapp.
---
 schema.sql | 9 +++++++++
 1 file changed, 9 insertions(+)

(limited to 'schema.sql')

diff --git a/schema.sql b/schema.sql
index c785080..ccd78ec 100644
--- a/schema.sql
+++ b/schema.sql
@@ -38,3 +38,12 @@ CREATE TABLE buildrequests (
 	architecture TEXT,
 	requesttime TIMESTAMP NOT NULL,
         priority INTEGER NOT NULL DEFAULT 0);
+
+CREATE TABLE bugs (
+	kind TEXT NOT NULL CHECK (kind in ('bdsat', 'ftbfs', 'ftcbfs')),
+	bugnum INTEGER NOT NULL,
+	package TEXT,
+	affects TEXT NOT NULL,
+	title TEXT,
+	patched BOOLEAN NOT NULL CHECK (patched in (0, 1)));
+CREATE INDEX bugs_affects_index ON bugs(affects);
-- 
cgit v1.2.3

