1CREATE TABLE data
2(
3    eid INTEGER PRIMARY KEY,
4    pid INTEGER,
5    key,
6    value
7);
8CREATE INDEX idx_key ON data (key);
9CREATE TABLE pages
10(
11    pid INTEGER PRIMARY KEY,
12    page,
13    title
14);
15CREATE UNIQUE INDEX idx_page ON pages (page);
16
17