blob: 768e40a8574076514a3428bbbea2f0af06ae107f (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
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);
|