fetch and display bugs

Retrieve bugs from udd-mirror by tags/usertags and display relevant bug
numbers in the webapp.

1 files changed, 9 insertions, 0 deletions

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);