
diff -r 2e8eeb919028 -r b538b70cbe51 settingsengines/sdb/src/schema_data_dbms.sql
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/settingsengines/sdb/src/schema_data_dbms.sql	Thu Mar 11 18:20:56 2010 +0200
@@ -0,0 +1,16 @@
+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);
+CREATE UNIQUE INDEX cnt_id_index ON CONTACTS(CM_Id) COLLATE NORMAL;
+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));
+CREATE UNIQUE INDEX IdentityIdIndex ON IDENTITYTABLE(Parent_CMID) COLLATE NORMAL;
+CREATE TABLE EMAILTABLE(EMail_FieldID INTEGER NOT NULL AUTOINCREMENT, EmailParent_CMID INTEGER, EMailAddress CHAR(255));
+CREATE UNIQUE INDEX EmailIdentityIdIndex ON EMAILTABLE( EMail_FieldID, EmailParent_CMID) COLLATE NORMAL;
+CREATE TABLE PHONE(CM_Id INTEGER NOT NULL, CM_PhoneMatching INTEGER NOT NULL, CM_ExtendedPhoneMatching INTEGER NOT NULL);
+CREATE UNIQUE INDEX cnt_phone_index ON PHONE( CM_PhoneMatching, CM_Id ) COLLATE NORMAL;
+CREATE TABLE GROUPS(CM_Id INTEGER NOT NULL, CM_Members INTEGER NOT NULL);
+CREATE INDEX cnt_group_index ON GROUPS( CM_Members, CM_Id ) COLLATE NORMAL;      
+CREATE TABLE GROUPS2(CM_Id INTEGER NOT NULL, CM_GroupMembers LONG VARBINARY);
+CREATE UNIQUE INDEX cnt_group_index2 ON GROUPS2(CM_Id) COLLATE NORMAL;
+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);
+CREATE TABLE SYNC(CM_Id UNSIGNED INTEGER NOT NULL AUTOINCREMENT, CM_LastSyncDate TIMESTAMP);
+CREATE UNIQUE INDEX sync_id_index ON SYNC(CM_Id) COLLATE NORMAL;
+




