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