
diff -r 2e8eeb919028 -r b538b70cbe51 settingsengines/sdb/testdata/contacts/schema_data.sql
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/settingsengines/sdb/testdata/contacts/schema_data.sql	Thu Mar 11 18:20:56 2010 +0200
@@ -0,0 +1,18 @@
+CREATE TABLE symbian_settings(Id INTEGER,Reserved INTEGER,CollationDllName TEXT);
+INSERT INTO "symbian_settings" VALUES(3,0,'ELOCL.LOC');
+CREATE TABLE contact (contact_id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, template_id INTEGER, type_flags INTEGER, access_count INTEGER, creation_date , last_modified , guid_string VARCHAR(255) NULL, first_name VARCHAR(255) NULL, last_name VARCHAR(255) NULL, company_name VARCHAR(255) NULL, firstname_prn VARCHAR(255) NULL, lastname_prn VARCHAR(255) NULL, companyname_prn VARCHAR(255) NULL, text_fields_header BLOB, binary_fields_header BLOB, tex_fields TEXT, binary_fields BLOB);
+INSERT INTO "contact" VALUES(0,-1,67371008,0,63388107914680000,63388107914680000,'00e13325f73d16c0',NULL,NULL,NULL,NULL,NULL,NULL,'040000005E1C0100000000000FFFFFFFF000200802E40001005000000145469746C651401000001000000FFFFFFFF200000802E4000100A000000284669727374206E616D651C01000002000000FFFFFFFF80000802E4000100B0000002C4D6964646C65206E616D651401000003000000FFFFFFFF100000802E40001009000000244C617374206E616D651C01000004000000FFFFFFFF000100802E4001006000000185375666669781401000005000000FFFFFFFF020000832A400010DB390010DD390010713E001006000000184D6F62696C651401000006000000FFFFFFFF020000822A40001DB390010DD3900100800000020486F6D652074656C1C01000007000000FFFFFFFF000000832A40001091170010DB390010DE3900100800000020486F6D65206661781C01000008000000FFFFFFF020000832A400010DB390010DD390010723E00100A00000028486F6D652050616765721C01000009000000FFFFFFFF020000822A400010DB390010D53900100E0000003842756C66574696E20426F6172641C0100000A000000FFFFFFFF020000822A400010DB390010D63900100A00000028486F6D65204D6F64656D1C0100000B000000FFFFFFFF020000832A400010DB30010DD390010D739001009000000244361722050686F6E651C0100000C000000FFFFFFFF020000822A400010DB390010D83900100900000024486F6D65204953444E1C0100000D000000FFFFFFF020000822A400010DB390010D93900100A00000028486F6D6520566964656F140100000E000000FFFFFFFF0040008120400010DB3900100A00000028486F6D6520656D61696C1C000000F000000FFFFFFFF00000082EA4D0010F44D0010DB3900100B0000002C486F6D6520504F20626F781C01000010000000FFFFFFFF00000082EB4D0010F54D0010DB390010100000004486F6D652065787420616464726573731401000011000000FFFFFFFF400000811D400010DB3900100C00000030486F6D6520616464726573731401000012000000FFFFFFFF00000082EC40010F64D0010DB3900100900000024486F6D6520636974791401000013000000FFFFFFFF00000082ED4D0010F74D0010DB3900100B0000002C486F6D6520726567696F6E140100001400000FFFFFFFF00000082EE4D0010F84D0010DB3900100B0000002C486F6D65207027636F64651401000015000000FFFFFFFF00000082EF4D0010F94D0010DB3900100C00000030486F6D652636F756E7472791401000016000000FFFFFFFF000000822D40001035400010DB3900100D00000034486F6D652057656220706167652401000017000000FFFFFFFF080000802640001007000001C436F6D70616E792401000018000000FFFFFFFF000000812C4000109893001009000000244A6F62207469746C652C01000019000000FFFFFFFF020000832A400010DA390010DD39010713E00100B0000002C576F726B206D6F62696C65240100001A000000FFFFFFFF020000822A400010DA390010DD3900100800000020576F726B2074656C240100001B000000FFFFFFFF00000832A40001091170010DA390010DE3900100800000020576F726B206661782C0100001C000000FFFFFFFF020000822A400010723E0010DA3900100A00000028576F726B207061676572C0100001D000000FFFFFFFF020000822A400010DA390010D5390010130000004C576F726B2042756C6C6574696E20426F6172642C0100001E000000FFFFFFFF020000822A400010DA39010D63900100A00000028576F726B204D6F64656D1C0100001F000000FFFFFFFF020000832A400010DA390010DD390010D73900100E00000038576F726B204361722050686F6E652C0100020000000FFFFFFFF020000822A400010DA390010D83900100900000024576F726B204953444E2C01000021000000FFFFFFFF020000822A400010DA390010D93900100A00000028576F72620566964656F2401000022000000FFFFFFFF0040008120400010DA3900100A00000028576F726B20656D61696C2401000023000000FFFFFFFF000000822D40001035400010DA3900100D0000034576F726B2057656220706167652C01000024000000FFFFFFFF00000082EA4D0010F44D0010DA3900100B0000002C576F726B20504F20626F782C01000025000000FFFFFFFF0000082EB4D0010F54D0010DA3900101000000040576F726B2065787420616464726573732401000026000000FFFFFFFF400000811D400010DA3900100C00000030576F726B2061646472657372401000027000000FFFFFFFF00000082EC4D0010F64D0010DA3900100900000024576F726B20636974792401000028000000FFFFFFFF00000082ED4D0010F74D0010DA3900100B0000002576F726B20726567696F6E2401000029000000FFFFFFFF00000082EE4D0010F84D0010DA3900100B0000002C576F726B207027636F6465240100002A000000FFFFFFFF00000082EF4D001F94D0010DA3900100C00000030576F726B20636F756E747279340100002B000000FFFFFFFF00000081254000101C40001005000000144E6F746573050100002C000000FFFFFFFF00000082F4000100C00000030446973706C6179206E616D650C0100002D000000FFFFFFFF000000802240001005000000144C4142454C050100002E000000FFFFFFFF000000812E4000108057001160000005847726F7570202F2054656D706C617465204C6162656C','0400000006250110000400000000000000FFFFFFFF0000008123400010D15D001004000000104C4F474F3C013000800000001000000FFFFFFFF000000811F4000103440001008000000204269727468646179040110001000000002000000FFFFFFFF0000008127400010D15D0010050000001450484F544','','0000000000000000000000000000008000000000');
+DELETE FROM sqlite_sequence;
+INSERT INTO "sqlite_sequence" VALUES('preferences',1);
+INSERT INTO "sqlite_sequence" VALUES('contact',0);
+INSERT INTO "sqlite_sequence" VALUES('comm_addr',1);
+CREATE TABLE groups (group_id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, contact_group_id INTEGER NOT NULL, contact_group_member_id INTEGER NOT NULL, FOREIGN KEY (contact_group_id) REFERENCES contact(contact_id), FOREIGN KEY (contact_group_member_id) REFERENCES contact(contact_id) );
+CREATE TABLE comm_addr (comm_addr_id  INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, type INTEGER NOT NULL, value CHAR(255) NOT NULL, extra_value CHAR(25), contact_id INTEGER NOT NULL, FOREIGN KEY (contact_id) REFERENCES contact(contact_id));
+INSERT INTO "comm_addr" VALUES(1,0,'7000000','0',1);
+CREATE TABLE preferences (preference_id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, data_schema_version INTEGER NOT NULL, preferred_cardtemplate_id ITEGER, machine_id , creation_date , preferred_sortorder BLOB);
+INSERT INTO "preferences" VALUES(1,1,-1,3778953099,63388107914660000,'00000000');
+CREATE INDEX contact_guid_string_idx  ON contact (guid_string);
+CREATE INDEX contact_group_id_idx ON groups (contact_group_id);
+CREATE INDEX contact_group_member_id_idx ON groups (contact_group_member_id);
+CREATE INDEX comm_addr_val_idx  ON comm_addr (value);
+CREATE INDEX comm_addr_contact_id_idx  ON comm_addr (contact_id);




