1DELETE FROM accounts; 2DELETE FROM settings; 3DELETE FROM contacts; 4DELETE FROM raw_contacts; 5DELETE FROM data; 6DELETE FROM data_usage_stat; 7 8--CREATE TABLE accounts (_id INTEGER PRIMARY KEY AUTOINCREMENT,account_name TEXT, account_type TEXT, data_set TEXT); 9 10INSERT INTO "accounts" VALUES(1,NULL,NULL,NULL); 11INSERT INTO "accounts" VALUES(2,"visible","type1",NULL); 12INSERT INTO "accounts" VALUES(3,"visible","type1","ds_not_visible"); 13INSERT INTO "accounts" VALUES(4,"not_syncable","type1",NULL); 14INSERT INTO "accounts" VALUES(5,"no_settings","type2",NULL); 15 16--CREATE TABLE settings (account_name STRING NOT NULL,account_type STRING NOT NULL,data_set STRING,ungrouped_visible INTEGER NOT NULL DEFAULT 0,should_sync INTEGER NOT NULL DEFAULT 1); 17 18INSERT INTO "settings" VALUES ("visible","type1",NULL,1,1) 19INSERT INTO "settings" VALUES ("visible","type1","ds_not_visible",0,1) 20INSERT INTO "settings" VALUES ("not_syncable","type1",NULL,0,0) 21