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