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;