gxpzx2xt

1command.CommandText =
2	"CREATE TABLE if not exists file_hash_list( " +
3		"id    INTEGER PRIMARY KEY, " +
4		"hash  BLOB NOT NULL, " +
5		"filesize INTEGER NOT NULL);";
6command.ExecuteNonQuery();
7	
8BEGIN;
9CREATE TABLE file_hash_list (
10  id INTEGER PRIMARY KEY,
11  hash BLOB NOT NULL,
12  filesize INTEGER NOT NULL
13);
14CREATE INDEX file_hash_list_filesize_idx ON file_hash_list (filesize);
15COMMIT;
16	
17create index
18    myIndex
19on
20    myTable (myColumn)