1CREATE TABLE testdata (tid INTEGER PRIMARY KEY, keyword, value);
2CREATE INDEX idx_keyword ON testdata(keyword);
3INSERT INTO testdata VALUES(1,'book','Nice reading');
4INSERT INTO testdata VALUES(2,'book','Long reading');
5INSERT INTO testdata VALUES(3,'music','happy');
6INSERT INTO testdata VALUES(4,'music','Classic');
7INSERT INTO testdata VALUES(5,'music','Pop');
8INSERT INTO testdata VALUES(6,'glass','Black');
9INSERT INTO testdata VALUES(7,'glass','Red');
10INSERT INTO testdata VALUES(8,'music','Pink');
11INSERT INTO testdata VALUES(9,'book','Black');
12INSERT INTO testdata VALUES(10,'music','Boring');
13
14
15
16
17