G4wszSut

1CREATE TABLE IF NOT EXISTS xinst ( id INTEGER NOT NULL, lay_path TEXT NOT NULL COLLATE NOCASE, sch_path TEXT NOT NULL COLLATE NOCASE, cell_id INTEGER NOT NULL );
2CREATE INDEX IF NOT EXISTS cell_id on xinst (cell_id);
3CREATE INDEX IF NOT EXISTS cell_id_and_lay_path on xinst (cell_id,lay_path);
4CREATE INDEX IF NOT EXISTS cell_id_and_sch_path on xinst (cell_id,sch_path);
5	
6sqlite3 foo.xinst
7.read schema
8.separator ','
9.import data.txt xinst