/*
* Copyright (c) 1997-2009 Nokia Corporation and/or its subsidiary(-ies).
* All rights reserved.
* This component and the accompanying materials are made available
* under the terms of "Eclipse Public License v1.0"
* which accompanies this distribution, and is available
* at the URL "http://www.eclipse.org/legal/epl-v10.html".
*
* Initial Contributors:
* Nokia Corporation - initial contribution.
*
* Contributors:
*
* Description: 
*
*/



#if !defined(__CNTSTD_H__)
#define __CNTSTD_H__

#if !defined(__E32DEF_H__)
#include <e32def.h>
#endif

const TInt KNumberOfNewTables = 8;//Used for discovering if we're opening an old version of cntmodel

_LIT(KContactTableName,"CONTACTS");
_LIT(KContactGroupTableName,"GROUPS");
_LIT(KContactGroupTableNameByGroup,"GROUPS2");
_LIT(KContactPrefTableName,"PREFERENCES");
_LIT(KContactPhoneMatchingTableName,"PHONE");
_LIT(KSyncTableName,"SYNC");

_LIT(KIdentifierColName,"CM_Id");
_LIT(KLastLastSyncColName,"CM_LastSyncDate");
_LIT(KUidStringColName,"CM_UIDString");
_LIT(KTypeColName,"CM_Type");
_LIT(KTemplateRefId,"CM_PrefTemplateRefId");
_LIT(KLastModifiedColName,"CM_Last_modified");
_LIT(KCreationDateColName,"CM_ContactCreationDate");
_LIT(KAttributesColName,"CM_Attributes");
_LIT(KTextFieldsColName,"CM_TextBlob");
_LIT(KFieldHeaderColName, "CM_Header");
_LIT(KSearchableTextColName,"CM_SearchableText");
_LIT(KPhoneMatchingColName,"CM_PhoneMatching");
_LIT(KPhoneMatchingColNameTwo,"CM_ExtendedPhoneMatching");
_LIT(KItemsContainedColName,"CM_Members");
_LIT(KGroupMembersName,"CM_GroupMembers");
_LIT(KReplicationCountColName,"CM_ReplicationCount");
_LIT(KPrefId,"CM_PrefId");
_LIT(KPrefTemplateId,"CM_PrefTemplateId");
_LIT(KPrefTemplateFileVersion,"CM_PrefFileVer");
_LIT(KPrefFileId,"CM_PrefFileId");
_LIT(KContactTableIdIndex,"cnt_id_index");
_LIT(KSyncTableIdIndex,"sync_id_index");
_LIT(KContactGroupIndex,"cnt_group_index");
_LIT(KContactGroupIndexByGroupId,"cnt_group_index2");
_LIT(KContactPhoneMatchingIndex,"cnt_phone_index");
_LIT(KPrefCreationDate,"CM_creationdate");
_LIT(KPrefOwnCardId,"CM_PrefOwnCardId");
_LIT(KPrefCardTemplateId,"CM_PrefCardTemplateId");
_LIT(KPrefGroupIdList,"CM_PrefGroupIdList");
_LIT(KPrefCardTemplatePrefId,"CM_PrefCardTemplatePrefId");
_LIT(KPrefMachineUniqueId,"CM_MachineUID");
_LIT(KPrefSortOrder,"CM_PrefSortOrder");
_LIT(KContactHintField,"CM_HintField");

_LIT(KContactExtHintField, "CM_ExtHintField");

//LPD//Identity TABLE
_LIT(KIdentityTableName, "IDENTITYTABLE");
_LIT(KParentCMID, "Parent_CMID");
_LIT(KFirstNameColName,"CM_FirstName");
_LIT(KLastNameColName,"CM_LastName");
_LIT(KCompanyNameColName,"CM_CompanyName");
_LIT(KFirstNamePronunciationColName,"CM_FirstNmPrn");
_LIT(KLastNamePronunciationColName,"CM_LastNmPrn");
_LIT(KCompanyNamePronunciationColName,"CM_CompanyNmPrn");
_LIT(KIdentityIdIndex, "IdentityIdIndex");

//Email Table
_LIT(KEMailTableName, "EMAILTABLE");
_LIT(KEMailParentCMID, "EmailParent_CMID");///
_LIT(KEMailFieldID, "EMail_FieldID");////Together these match a unique id.
_LIT(KEMailAddress,"EMailAddress");
_LIT(KEMailIdentityIdIndex, "EmailIdentityIdIndex");

//SQL Literals
_LIT(KASC,"ASC");
_LIT(KDESC,"DESC");

//Asych Sort Consts
//Values for sort window
const TInt KSortWindowForeSlots=5;
const TInt KSortWindowRearSlots=0;

//const TInt KMaxPhoneNumberLenghForSearch=50;
_LIT(KSelectStringFromEmailTable,"SELECT EmailParent_CMID FROM EMAILTABLE WHERE EMailAddress LIKE '%S'");
_LIT(KSelectAddressFromEmailTableByCntID,"SELECT EMailAddress FROM EMAILTABLE WHERE EmailParent_CMID = %d");

//Find String Sql lits
//_LIT(KSelectStringFromIdentityTable,"SELECT Parent_CMID FROM IDENTITYTABLE WHERE (CM_FirstName LIKE '%S') OR (CM_LastName LIKE '%S') OR (CM_CompanyName LIKE '%S')");
_LIT(KSelectStringFromIdentityTable,"SELECT * FROM IDENTITYTABLE WHERE (CM_FirstName LIKE '%S') OR (CM_LastName LIKE '%S') OR (CM_CompanyName LIKE '%S') OR (CM_FirstNmPrn LIKE '%S') OR (CM_LastNmPrn LIKE '%S') OR (CM_CompanyNmPrn LIKE '%S')");

//_LIT(KSelectStringFromIdentityTableWhere,"SELECT Parent_CMID FROM IDENTITYTABLE WHERE ");
_LIT(KSelectStringFromIdentityTableWhere,"SELECT * FROM IDENTITYTABLE WHERE ");

_LIT(KSelectAllIdsFromIdentity,"SELECT Parent_CMID, CM_Type FROM IDENTITYTABLE");//Gives an unsorted list of contact ids for every contact
_LIT(KSelectStringForTextDefSearch,"SELECT Parent_CMID,CM_FirstName,CM_LastName,CM_CompanyName,CM_FirstNmPrn,CM_LastNmPrn,CM_CompanyNmPrn,CM_Type FROM IDENTITYTABLE WHERE ");

_LIT(KLeftBracket,"(");
_LIT(KLikeString," LIKE '");
_LIT(KLikeStringRight,"')");
_LIT(KOR," OR ");

_LIT(KNullBlobTextField," ");



_LIT(KSqlDeleteFromTableFormat,"DELETE FROM %S WHERE %S=%d");


enum TCntModelPanic
	{
	ECntPanicInvalidColumnName,
	ECntPanicInvalidColumnIndex,
	ECntPanicInvalidItemType,
	ECntPanicInvalidItemIndex,
	ECntPanicDbmsResourceNotFreed,
	ECntPanicNullFieldDefinition,
	ECntPanicInvalidFieldContentType,
	ECntPanicViewIsEmpty,
	ECntPanicDuplicateViewFields,
	ECntPanicFieldDoesNotExist,
	ECntPanicNullPointer,
	ECntPanicDuplicateIds,
	ECntPanicInternalSortError,
	ECntPanicUnhandledUid,
	ECntPanicFieldTypeIndex,
	ECntPanicInvalidStorageType,
	ECntPanicStorageAlreadyAllocated,
	ECntPanicServerNotFound,
	ECntPanicSystemTemplate,
	ECntPanicAgentNotNull,
	ECntPanicTemplateNotEmpty,
	ECntPanicItemAlreadyExists,
	ECntPanicInvalidSortArray,
	ECntPanicPhoneMatchLength,
	ECntPanicDuffGroup,
	ECntPanicInvalidSpeedDialContactId,
	ECntPanicInvalidSpeedDialIndex,
	ECntPanicInvalidViewIndex,
	ECntPanicInvalidIndexForSubView,
	ECntPanicInvalidIndexForConcatenatedView,
	ECntPanicViewNotReady,
	ECntPanicNoViewIndexMatchCriteria,
	ECntPanicUnderlyingViewUnsorted,
	ECntPanicAsyncViewNotificationPending,
	ECntPanicObserverNotFound,
	ECntPanicComponentViewNotFound,
	ECntPanicInvalidFieldText,
	ECntPanicFieldTextNotInitialised,
	ECntPanicUnableToRestartServer,
	ECntPanicFilterableFieldMaxNumberInUse,
	ECntPanicFieldTextNotBlank,
	ECntPanicInvalidConnectionId,
	ECntPanicAPIRemoved,
	ECntPanicDuplicateBackupEvent,
	ECntPanicDuplicateRestoreEvent,
	ECntPanicUnexpectedEndofRestoreEvent,
	ECntPanicFieldBufferNotAllocated,
	ECntPanicFieldBufferAllocError,
	ECntPanicFieldBufferWrongSize,
	ECntPanicViewSorterStateMachine,
	ECntPhonebookSyncObserverList,
	ECntPanicContactsLeftLocked,
	ECntPanicLast
	};

GLREF_C void Panic(TCntModelPanic aPanic);



#endif
