From 9366af90058d14b1ca046ad89987ee8bade3c003 Mon Sep 17 00:00:00 2001
From: Martin Czygan <martin.czygan@gmail.com>
Date: Sat, 7 Nov 2020 00:33:56 +0100
Subject: wip: aux lists and dbs

---
 sql/sslookup.sql | 13 +++++++++++++
 1 file changed, 13 insertions(+)
 create mode 100644 sql/sslookup.sql

(limited to 'sql/sslookup.sql')

diff --git a/sql/sslookup.sql b/sql/sslookup.sql
new file mode 100644
index 0000000..768e40a
--- /dev/null
+++ b/sql/sslookup.sql
@@ -0,0 +1,13 @@
+
+-- Example: Low-energy nanotube chip says 'hello world'
+CREATE TABLE IF NOT EXISTS sslookup (
+    id INTEGER PRIMARY KEY,
+	title_prefix TEXT,
+    title_suffix TEXT,
+    contribs TEXT
+);
+
+CREATE INDEX idx_sslookup_title ON sslookup (title_prefix, title_suffix);
+CREATE INDEX idx_sslookup_title_prefix ON sslookup (title_prefix);
+CREATE INDEX idx_sslookup_title_suffix ON sslookup (title_suffix);
+
-- 
cgit v1.2.3