CREATE TABLE Table1 (
fid Integer NOT NULL PRIMARY KEY AUTOINCREMENT,
fx Real NOT NULL, 
fy Real NOT NULL, 
fdraw Integer NOT NULL, 
fkind Integer NOT NULL, 
fsize Integer NOT NULL, 
fcolor Integer NOT NULL, 
ftext Text);

CREATE UNIQUE INDEX Table1_key_fid ON Table1 (fid);
CREATE INDEX Table1_ind_xy ON Table1 (fx, fy);

select count(*) from table1