summaryrefslogtreecommitdiff
path: root/etc/schema.sql
diff options
context:
space:
mode:
Diffstat (limited to 'etc/schema.sql')
-rw-r--r--etc/schema.sql14
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;