BEGIN TRANSACTION;

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, text_fields TEXT, binary_fields BLOB);

INSERT INTO "contact" VALUES(0,-1,67371008,0,63391801901215000,63391801901220000,'00e1368209fe6d18',NULL,NULL,NULL,NULL,NULL,NULL,X'040000005E1C01000000000000FFFFFFFF000200802E40001005000000145469746C651401000001000000FFFFFFFF200000802E4000100A000000284669727374206E616D651C01000002000000FFFFFFFF800000802E4000100B0000002C4D6964646C65206E616D651401000003000000FFFFFFFF100000802E40001009000000244C617374206E616D651C01000004000000FFFFFFFF000100802E40001006000000185375666669781401000005000000FFFFFFFF020000832A400010DB390010DD390010713E001006000000184D6F62696C651401000006000000FFFFFFFF020000822A400010DB390010DD3900100800000020486F6D652074656C1C01000007000000FFFFFFFF000000832A40001091170010DB390010DE3900100800000020486F6D65206661781C01000008000000FFFFFFFF020000832A400010DB390010DD390010723E00100A00000028486F6D652050616765721C01000009000000FFFFFFFF020000822A400010DB390010D53900100E0000003842756C6C6574696E20426F6172641C0100000A000000FFFFFFFF020000822A400010DB390010D63900100A00000028486F6D65204D6F64656D1C0100000B000000FFFFFFFF020000832A400010DB390010DD390010D739001009000000244361722050686F6E651C0100000C000000FFFFFFFF020000822A400010DB390010D83900100900000024486F6D65204953444E1C0100000D000000FFFFFFFF020000822A400010DB390010D93900100A00000028486F6D6520566964656F140100000E000000FFFFFFFF0040008120400010DB3900100A00000028486F6D6520656D61696C1C0100000F000000FFFFFFFF00000082EA4D0010F44D0010DB3900100B0000002C486F6D6520504F20626F781C01000010000000FFFFFFFF00000082EB4D0010F54D0010DB3900101000000040486F6D652065787420616464726573731401000011000000FFFFFFFF400000811D400010DB3900100C00000030486F6D6520616464726573731401000012000000FFFFFFFF00000082EC4D0010F64D0010DB3900100900000024486F6D6520636974791401000013000000FFFFFFFF00000082ED4D0010F74D0010DB3900100B0000002C486F6D6520726567696F6E1401000014000000FFFFFFFF00000082EE4D0010F84D0010DB3900100B0000002C486F6D65207027636F64651401000015000000FFFFFFFF00000082EF4D0010F94D0010DB3900100C00000030486F6D6520636F756E7472791401000016000000FFFFFFFF000000822D40001035400010DB3900100D00000034486F6D652057656220706167652401000017000000FFFFFFFF0800008026400010070000001C436F6D70616E792401000018000000FFFFFFFF000000812C4000109893001009000000244A6F62207469746C652C01000019000000FFFFFFFF020000832A400010DA390010DD390010713E00100B0000002C576F726B206D6F62696C65240100001A000000FFFFFFFF020000822A400010DA390010DD3900100800000020576F726B2074656C240100001B000000FFFFFFFF000000832A40001091170010DA390010DE3900100800000020576F726B206661782C0100001C000000FFFFFFFF020000822A400010723E0010DA3900100A00000028576F726B2070616765722C0100001D000000FFFFFFFF020000822A400010DA390010D5390010130000004C576F726B2042756C6C6574696E20426F6172642C0100001E000000FFFFFFFF020000822A400010DA390010D63900100A00000028576F726B204D6F64656D1C0100001F000000FFFFFFFF020000832A400010DA390010DD390010D73900100E00000038576F726B204361722050686F6E652C01000020000000FFFFFFFF020000822A400010DA390010D83900100900000024576F726B204953444E2C01000021000000FFFFFFFF020000822A400010DA390010D93900100A00000028576F726B20566964656F2401000022000000FFFFFFFF0040008120400010DA3900100A00000028576F726B20656D61696C2401000023000000FFFFFFFF000000822D40001035400010DA3900100D00000034576F726B2057656220706167652C01000024000000FFFFFFFF00000082EA4D0010F44D0010DA3900100B0000002C576F726B20504F20626F782C01000025000000FFFFFFFF00000082EB4D0010F54D0010DA3900101000000040576F726B2065787420616464726573732401000026000000FFFFFFFF400000811D400010DA3900100C00000030576F726B20616464726573732401000027000000FFFFFFFF00000082EC4D0010F64D0010DA3900100900000024576F726B20636974792401000028000000FFFFFFFF00000082ED4D0010F74D0010DA3900100B0000002C576F726B20726567696F6E2401000029000000FFFFFFFF00000082EE4D0010F84D0010DA3900100B0000002C576F726B207027636F6465240100002A000000FFFFFFFF00000082EF4D0010F94D0010DA3900100C00000030576F726B20636F756E747279340100002B000000FFFFFFFF00000081254000101C40001005000000144E6F746573050100002C000000FFFFFFFF000000802F4000100C00000030446973706C6179206E616D650C0100002D000000FFFFFFFF000000802240001005000000144C4142454C050100002E000000FFFFFFFF000000812E40001080570010160000005847726F7570202F2054656D706C617465204C6162656C',X'0400000006250110000400000000000000FFFFFFFF0000008123400010D15D001004000000104C4F474F3C0130000800000001000000FFFFFFFF000000811F4000103440001008000000204269727468646179040110001000000002000000FFFFFFFF0000008127400010D15D0010050000001450484F544F','',X'0000000000000000000000000000008000000000');

DELETE FROM sqlite_sequence;

INSERT INTO "sqlite_sequence" VALUES('preferences',1);

INSERT INTO "sqlite_sequence" VALUES('contact',0);

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(255), contact_id INTEGER NOT NULL, FOREIGN KEY (contact_id) REFERENCES contact(contact_id));

CREATE TABLE preferences (preference_id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, data_schema_version INTEGER NOT NULL, preferred_cardtemplate_id INTEGER, machine_id , creation_date , preferred_sortorder BLOB);

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);

COMMIT;