diff options
| author | Martin Czygan <martin.czygan@gmail.com> | 2020-11-07 00:33:56 +0100 |
|---|---|---|
| committer | Martin Czygan <martin.czygan@gmail.com> | 2020-11-07 00:33:56 +0100 |
| commit | 9366af90058d14b1ca046ad89987ee8bade3c003 (patch) | |
| tree | 396fdbdfd5c468834aafa0ffecd48fec23e22e36 /sql/sslookup.sql | |
| parent | bafb146d7872be4719aa3c4ab5dba45e571eae1a (diff) | |
| download | fuzzycat-9366af90058d14b1ca046ad89987ee8bade3c003.tar.gz fuzzycat-9366af90058d14b1ca046ad89987ee8bade3c003.zip | |
wip: aux lists and dbs
Diffstat (limited to 'sql/sslookup.sql')
| -rw-r--r-- | sql/sslookup.sql | 13 |
1 files changed, 13 insertions, 0 deletions
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); + |