From 4052368bb5372a9f4c6164ef71d3bcd7ede9e81b Mon Sep 17 00:00:00 2001
From: Ricardo Wurmus <rekado@elephly.net>
Date: Thu, 12 Mar 2020 10:56:47 +0100
Subject: 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.
---
 etc/schema.sql | 14 ++++++++++++++
 1 file changed, 14 insertions(+)
 create mode 100644 etc/schema.sql

(limited to 'etc')

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;
-- 
cgit v1.2.3