mumi: Add bugs.

* mumi/bugs.scm: New file.
* etc/schema.sql: New file.
* Makefile.am (SOURCES): Add mumi/bugs.scm.
(dist_pkgdata_DATA): Add etc/schema.sql.

1 files changed, 14 insertions, 0 deletions

diff --git a/etc/schema.sql b/etc/schema.sql
new file mode 100644
index 0000000..4bcecda
--- /dev/null
+++ b/etc/schema.sql
@@ -0,0 +1,14 @@
+BEGIN TRANSACTION;
+
+CREATE TABLE bugs (
+  id          INTEGER NOT NULL PRIMARY KEY UNIQUE,
+  submitter   TEXT NOT NULL,
+  owner       TEXT,
+  severity    TEXT NOT NULL,
+  status      TEXT NOT NULL,
+  tags        TEXT NOT NULL
+);
+
+CREATE INDEX bugs_index ON bugs(id, submitter, owner, severity, status, tags);
+
+COMMIT;