1-- Defines the queries that can be used in wiki 2CREATE TABLE queries ( 3 id INTEGER PRIMARY KEY, 4 db TEXT NOT NULL, 5 name TEXT NOT NULL, 6 sql TEXT NOT NULL 7); 8 9-- Defines the syntax parsers used query columns 10CREATE TABLE parsers ( 11 id INTEGER PRIMARY KEY, 12 query_id INTEGER NOT NULL, 13 column TEXT NOT NULL, 14 parser TEXT NOT NULL, 15 FOREIGN KEY(query_id) REFERENCES queries(id) 16); 17