1 CREATE TABLE CONTACTS(CM_Id INTEGER NOT NULL AUTOINCREMENT, CM_Type INTEGER, CM_PrefTemplateRefId INTEGER, CM_UIDString CHAR(244), CM_Last_modified TIMESTAMP, CM_ContactCreationDate TIMESTAMP, CM_Attributes UNSIGNED INTEGER, CM_ReplicationCount UNSIGNED INTEGER, CM_Header LONG VARBINARY, CM_TextBlob LONG VARBINARY, CM_SearchableText LONG VARCHAR);

     2 CREATE UNIQUE INDEX cnt_id_index ON CONTACTS(CM_Id) COLLATE NORMAL;

     3 CREATE TABLE IDENTITYTABLE(Parent_CMID INTEGER, CM_FirstName CHAR(255), CM_LastName CHAR(255), CM_CompanyName CHAR(255), CM_Type INTEGER, CM_Attributes UNSIGNED INTEGER, CM_HintField TINYINT, CM_ExtHintField UNSIGNED SMALLINT, CM_FirstNmPrn CHAR(255), CM_LastNmPrn CHAR(255), CM_CompanyNmPrn CHAR(255));

     4 CREATE UNIQUE INDEX IdentityIdIndex ON IDENTITYTABLE(Parent_CMID) COLLATE NORMAL;

     5 CREATE TABLE EMAILTABLE(EMail_FieldID INTEGER NOT NULL AUTOINCREMENT, EmailParent_CMID INTEGER, EMailAddress CHAR(255));

     6 CREATE UNIQUE INDEX EmailIdentityIdIndex ON EMAILTABLE( EMail_FieldID, EmailParent_CMID) COLLATE NORMAL;

     7 CREATE TABLE PHONE(CM_Id INTEGER NOT NULL, CM_PhoneMatching INTEGER NOT NULL, CM_ExtendedPhoneMatching INTEGER NOT NULL);

     8 CREATE UNIQUE INDEX cnt_phone_index ON PHONE( CM_PhoneMatching, CM_Id ) COLLATE NORMAL;

     9 CREATE TABLE GROUPS(CM_Id INTEGER NOT NULL, CM_Members INTEGER NOT NULL);

    10 CREATE INDEX cnt_group_index ON GROUPS( CM_Members, CM_Id ) COLLATE NORMAL;      

    11 CREATE TABLE GROUPS2(CM_Id INTEGER NOT NULL, CM_GroupMembers LONG VARBINARY);

    12 CREATE UNIQUE INDEX cnt_group_index2 ON GROUPS2(CM_Id) COLLATE NORMAL;

    13 CREATE TABLE PREFERENCES(CM_PrefFileId SMALLINT, CM_PrefTemplateId INTEGER, CM_PrefOwnCardId INTEGER, CM_PrefCardTemplatePrefId INTEGER, CM_PrefCardTemplateId LONG VARBINARY, CM_PrefGroupIdList LONG VARBINARY, CM_PrefFileVer INTEGER, CM_creationdate TIMESTAMP, CM_MachineUID BIGINT, CM_PrefSortOrder LONG VARBINARY);

    14 CREATE TABLE SYNC(CM_Id UNSIGNED INTEGER NOT NULL AUTOINCREMENT, CM_LastSyncDate TIMESTAMP);

    15 CREATE UNIQUE INDEX sync_id_index ON SYNC(CM_Id) COLLATE NORMAL;

    16