Searched refs:testdata (Results 1 – 1 of 1) sorted by path
/plugin/sqlite/_test/db/ |
H A D | update0001.sql | 1 CREATE TABLE testdata (tid INTEGER PRIMARY KEY, keyword, value); table 2 CREATE INDEX idx_keyword ON testdata(keyword); 3 INSERT INTO testdata VALUES(1,'book','Nice reading'); 4 INSERT INTO testdata VALUES(2,'book','Long reading'); 5 INSERT INTO testdata VALUES(3,'music','happy'); 6 INSERT INTO testdata VALUES(4,'music','Classic'); 7 INSERT INTO testdata VALUES(5,'music','Pop'); 8 INSERT INTO testdata VALUES(6,'glass','Black'); 9 INSERT INTO testdata VALUES(7,'glass','Red'); 10 INSERT INTO testdata VALUE [all...] |