// Copyright (c) 2003-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:

// Definitions of commdb tables and associated columns.

// 

//

/**

 @file

 @internalComponent

*/

#ifndef DBDEF_H

#define DBDEF_H

#include <e32base.h>

#include <e32std.h>

//#include <commdb.h>//todo remove

#include <commsdattypesv1_1.h>	

#include <commsdattypeinfov1_1.h>

#include "commsdattypeinfov1_1_internal.h"

using namespace CommsDat;

#include <cdbtemp.h>

#include <d32comm.h>

#include <nifvar.h>

#include <etelmm.h>

#include <cdbcols.h>

#include "CDBSTD.H"

#include <cdbpreftable.h>

// Hex Uid presentation support.

//

_LIT(KHexMarker, "0x");

_LIT(KUidMarker, "Uid");

/**

access to local error strings

@internalComponent

*/

extern TPtrC errorCode[];

/**

local CED defines, for values not already defined by CommDB

*/

//#define CONNECTION_PREFS_OUT	_S("ConnectionPrefsOut")		// pref table outbound

//#define CONNECTION_PREFS_IN		_S("ConnectionPrefsIn")			// pref table inbound

/**

end of array

*/

#define NO_MORE_RECORDS			_S("NO_MORE_RECORDS")

const TMDBElementId NO_MORE_ID	= 0xFFFFFFFF;

/**

all records in table

*/

#define ALL_RECORDS				_S("ALL_RECORDS")

/**

TRUE enum

*/

#define TRUE_VAL				_S("TRUE")

/**

FALSE enum

*/

#define FALSE_VAL				_S("FALSE")

#define OFF_VAL 				_S("Off")

#define ON_VAL 					_S("On")

/**

empty enum

*/

#define NOTHING					_S("")

/**

max amount of column updates per table we can handle

*/

#define MAX_DB_COLUMNS			100

/**

max number of characters for UINT

*/

#define MAX_CHAR_INT_LEN		9

/**

max length for column name

*/

#define MAX_COL_NAME_LEN		64

/**

max length of column contents

*/

#define MAX_COL_VAL_LEN			96

/**

max length of Med text column contents

*/

#define MAX_COL_MED_VAL_LEN		256

/**

max length of long text column contents

*/

#define MAX_COL_LONG_VAL_LEN	1024

/**

max length of queries

*/

#define MAX_QUERY_LEN			256

/**

initial value for bad text that must be replaced

*/

#define BADTEXTVAL				_S("NOTHING")

/**

initial value for bad number that must be replaced

*/

#define BADNUMVAL				(unsigned long)999999

/**

local CED defines, for values not already defined by CommDB

*/

/**

list of local error codes

@internalComponent

*/

#define E_NOTENOUGHDATA		0

#define E_INVALIDCOMMAND	1

#define E_INCORRECTTYPE		2

#define E_INCORRECTCOLNAME	3

#define E_ALREADYEXISTS		4

#define E_INCORRECTENUM		5

#define E_INCORRECTAGENT	6

#define E_BADFIELDCOUNT		7

#define E_NOFIELDS			8

#define E_NOTSUPPORTED		9

#define E_INCORRECTGLOBAL	10

#define E_BADESCAPEDCHAR	11

#define E_BADHEXADECIMAL	12

/**

types of commdb table access we can have.  This is because CommDB does not have a uniform structure to it's

tables and some tables must be accessed using specialist functions(!) so we must determine this during

the processing

@internalComponent

*/

typedef enum accessType

	{

	DBUnknown = 0,

	DBPrefIn = 1,

	DBPrefOut = 2,

	DBTable = 4,

	DBInsert = 8,

	DBUpdate = 16,

	DBAgent = 32,

	DBGlobal = 64,

	DBTemplate = 128

#ifdef __COMMDB_ROHID_SUPPORT__

	,DBExtendedProcessing = 256

#endif // __COMMDB_ROHID_SUPPORT__

	} ACCESSTYPE;

/**

holds information on a particular column of a table

@internalComponent

*/

typedef struct ColAttributes

	{

	TPtrC						Name;

	TBuf<MAX_COL_LONG_VAL_LEN>	Value;

	TDbColType					Type;

	} COLATTRIBUTES;

//

// ENUMERATION ARRAYS

//

/**

list of values in ISP type column

@internalComponent

*/

const TText* const ENUM_ISP_TYPEArray[] =

	{

	_S("INTERNETONLY"), _S("WAPONLY"), _S("INTERNETANDWAP"),

		NO_MORE_RECORDS

	};

/**

@internalComponent

*/

#define BEARER_NAME_ASYNCHRONOUS			_S("ASYNCHRONOUS")

#define BEARER_NAME_ASYNCHRONOUSRDI			_S("ASYNCHRONOUSRDI")

#define BEARER_NAME_SYNCHRONOUS				_S("SYNCHRONOUS")

#define BEARER_NAME_SYNCHRONOUSRDI			_S("SYNCHRONOUSRDI")

#define BEARER_NAME_PADASYNCUDI				_S("PADASYNCUDI")

#define BEARER_NAME_PADASYNCRDI				_S("PADASYNCRDI")

#define BEARER_NAME_ACCESSSYNCUDI			_S("DADS")

#define BEARER_NAME_ACCESSSYNCRDI			_S("ACCESSSYNCRDI")

#define BEARER_NAME_SERVICEEXTENDED			_S("SERVICEEXTENDED")

/**

list of values in ISP Bearer name column

@internalComponent

*/

const TText* const ENUM_ISP_BEARERNAMEArray[] =

	{

	BEARER_NAME_ASYNCHRONOUS, BEARER_NAME_ASYNCHRONOUSRDI,

	BEARER_NAME_SYNCHRONOUS, BEARER_NAME_SYNCHRONOUSRDI,

	BEARER_NAME_PADASYNCUDI, BEARER_NAME_PADASYNCRDI,

	BEARER_NAME_ACCESSSYNCUDI, BEARER_NAME_ACCESSSYNCRDI,

	BEARER_NAME_SERVICEEXTENDED,

	NO_MORE_RECORDS

	};

/**

list of values in ISP Bearer speed column

@internalComponent

*/

const TText* const ENUM_ISP_BEARERSPEEDArray[] =

	{

	_S("UNSPECIFIED"), _S("AUTOBAUDING"), _S("2400"), _S("4800"), _S("9600"),

	_S("14400"), _S("19200"), _S("28800"), _S("32000"), _S("33600"), _S("38400"),

	_S("43200"), _S("48000"), _S("56000"), _S("57600"), _S("64000"),

	NO_MORE_RECORDS

	};

/**

list of values in ISP BearerPROTOCOL column

@internalComponent

*/

#define BEARER_PROTOCOL_UNSPECIFIED		_S("UNSPECIFIED")

#define BEARER_PROTOCOL_0				_S("0")

#define BEARER_PROTOCOL_V22BIS			_S("V22BIS")

#define BEARER_PROTOCOL_V32				_S("V32")

#define BEARER_PROTOCOL_V34				_S("V34")

#define BEARER_PROTOCOL_V110			_S("V110")

#define BEARER_PROTOCOL_V120			_S("V120")

#define BEARER_PROTOCOL_X31FLAGSTUFFING _S("X31FLAGSTUFFING")

#define BEARER_PROTOCOL_PIAFS			_S("PIAFS")

#define BEARER_PROTOCOL_BITTRANSPARENT  _S("BITTRANSPARENT")

#define BEARER_PROTOCOL_PSTNMULTIMEDIAVOICEFALLBACK  _S("PSTNMULTIMEDIAVOICEFALLBACK")

#define BEARER_PROTOCOL_PSTNMULTIMEDIA  _S("PSTNMULTIMEDIA")

#define BEARER_PROTOCOL_ISDNMULTIMEDIA  _S("ISDNMULTIMEDIA")

/**

@internalComponent

*/

const TText* const ENUM_ISP_BEARERPROTOCOLArray[] =

	{

	BEARER_PROTOCOL_UNSPECIFIED,	BEARER_PROTOCOL_0,

	BEARER_PROTOCOL_V22BIS,			BEARER_PROTOCOL_V32,

	BEARER_PROTOCOL_V34,			BEARER_PROTOCOL_V110,

	BEARER_PROTOCOL_V120,			BEARER_PROTOCOL_X31FLAGSTUFFING,

	BEARER_PROTOCOL_PIAFS,			BEARER_PROTOCOL_BITTRANSPARENT,

	BEARER_PROTOCOL_PSTNMULTIMEDIAVOICEFALLBACK,

	BEARER_PROTOCOL_PSTNMULTIMEDIA,	BEARER_PROTOCOL_ISDNMULTIMEDIA,

	NO_MORE_RECORDS

	};

/**

@internalComponent

*/

typedef struct{

	const TText*   OptionDescriptor;

	TUint32 EnumVal;

	}TDescEnumMap;

/**

Map the descriptors used in the ced.cfg file to the correct enumertaion value used by the rest of the system.

NB this is not in enumeration order. The code uses RMobileCall::EProtocolUnspecified as

a termination condition, so the last entry is in fact redundant.

@internalComponent

*/

const TDescEnumMap  IspBearerProtocolMap[]= {

	{BEARER_PROTOCOL_V22BIS,RMobileCall::EProtocolV22bis},

	{BEARER_PROTOCOL_V32,RMobileCall::EProtocolV32},

	{BEARER_PROTOCOL_V34,RMobileCall::EProtocolV34},

	{BEARER_PROTOCOL_V110,RMobileCall::EProtocolV110},

	{BEARER_PROTOCOL_V120,RMobileCall::EProtocolV120},

	{BEARER_PROTOCOL_X31FLAGSTUFFING,RMobileCall::EProtocolX31FlagStuffing},

	{BEARER_PROTOCOL_PIAFS,RMobileCall::EProtocolPIAFS},

	{BEARER_PROTOCOL_BITTRANSPARENT,RMobileCall::EProtocolBitTransparent},

	{BEARER_PROTOCOL_PSTNMULTIMEDIAVOICEFALLBACK,RMobileCall::EProtocolPstnMultimediaVoiceFallback},

	{BEARER_PROTOCOL_PSTNMULTIMEDIA,RMobileCall::EProtocolPstnMultimedia},

	{BEARER_PROTOCOL_ISDNMULTIMEDIA,RMobileCall::EProtocolIsdnMultimedia},

	{BEARER_PROTOCOL_UNSPECIFIED,RMobileCall::EProtocolUnspecified},

	{BEARER_PROTOCOL_0,RMobileCall::EProtocolUnspecified}

	};

/**

list of values in ISP BearerCE column

@internalComponent

*/

const TText* const ENUM_ISP_BEARERCEArray[] =

	{

	_S("UNSPECIFIED"), _S("TRANSPARENT"), _S("NONTRANSPARENT"),

	_S("TRANSPARENTPREF"),_S("NONTRANSPARENTPREF"),

	NO_MORE_RECORDS

	};

/**

list of values in ISP bearer type column

@internalComponent

*/

const TText* const ENUM_ISP_BEARER_TYPEArray[] =

	{

	_S("CSD"), _S("HSCSD"),

	NO_MORE_RECORDS

	};

/**

list of values in ISP channel coding column

@internalComponent

*/

const TText* const ENUM_ISP_CHANNEL_CODINGArray[] =

	{

	_S("UNSPECIFIED"), _S("48"), _S("96"), _S("144"),

	_S("288"), _S("320"), _S("432"),

	NO_MORE_RECORDS

	};

/**

list of values in ISP AIUR column

@internalComponent

*/

const TText* const ENUM_ISP_AIURArray[] =

	{

	_S("UNSPECIFIED"),

	_S("9600"), _S("14400"), _S("19200"), _S("28800"),

	_S("38400"), _S("43200"), _S("57600"),

	NO_MORE_RECORDS

	};

/**

#defines because we reference them in the CPP code

@internalComponent

*/

#define MSCBCPCLIENTNUM		_S("MSCBCPCLIENTNUM")

#define MSCBCPSERVERNUM		_S("MSCBCPSERVERNUM")

#define MSCBCPOVERRIDESER	_S("MSCBCPOVERRIDESER")

/**

list of values in callback type column

@internalComponent

*/

const TText* const ENUM_ISP_IFCALLBACKTYPEArray[] =

	{

	_S("IETF0"), _S("IETF1"), _S("IETF2"), _S("IETF3"), _S("IETF4"), _S("IETF5"),

	MSCBCPCLIENTNUM, MSCBCPSERVERNUM, MSCBCPOVERRIDESER,

	NO_MORE_RECORDS

	};

/**

list of values in gprs pdp type column

@internalComponent

*/

const TText* const ENUM_GPRS_PDP_TYPEArray[] =

	{

	_S("IPV4"), _S("IPV6"), _S("X25"), _S("PPP"), _S("CDPD"),

	NO_MORE_RECORDS

	};

/**

list of values in default gprs pdp type column

@internalComponent

*/

const TText* const ENUM_CDMA_PDP_TYPEArray[] =

	{

	_S("IPV4"), _S("IPV6"), _S("X25"), _S("PPP"), _S("CDPD"),

	NO_MORE_RECORDS

	};

/**

list of values in start bit column

@internalComponent

*/

const TText* const ENUM_MODEM_STARTArray[] =

	{

	_S("5"), _S("6"), _S("7"), _S("8"),

	NO_MORE_RECORDS

	};

/**

list of values in stop bit column

@internalComponent

*/

const TText* const ENUM_MODEM_STOPArray[] =

	{

	_S("1"), _S("2"),

	NO_MORE_RECORDS

	};

/**

list of values in parity column

@internalComponent

*/

const TText* const ENUM_MODEM_PARITYArray[] =

	{

	_S("NONE"), _S("EVEN"), _S("ODD"), _S("MARK"), _S("SPACE"),

	NO_MORE_RECORDS

	};

/**

	#defines because we reference them in the CPP code

@internalComponent

*/

#define MODEM_RATE_AUTO	_S("AUTO")

#define MODEM_RATE_SPECIAL	_S("SPECIAL")

/**

list of values in rate column

@internalComponent

*/

const TText* const ENUM_MODEM_RATEArray[] =

	{

	_S("50"), _S("75"), _S("110"), _S("134"), _S("150"),

	_S("300"), _S("600"), _S("1200"), _S("1800"), _S("2000"),

	_S("2400"), _S("3600"), _S("4800"), _S("7200"), _S("9600"),

	_S("19200"), _S("38400"), _S("57600"), _S("115200"),

	_S("230400"), _S("460800"), _S("576000"), _S("1152000"), _S("4000000"),

	MODEM_RATE_AUTO, MODEM_RATE_SPECIAL,

	NO_MORE_RECORDS

	};

/**

list of values in fax class preference column

@internalComponent

*/

#define MODEM_FAX_AUTO			_S("AUTO")

#define MODEM_FAX_1				_S("1")

#define MODEM_FAX_2 			_S("2")

#define MODEM_FAX_2POINT0		_S("2.0")

#define MODEM_FAX_1POINT0		_S("1.0")

#define MODEM_FAX_2POINT1		_S("2.1")

/**

@internalComponent

*/

const TText* const ENUM_MODEM_FAX_CLASSArray[] =

	{

	_S("AUTO"), _S("1"), _S("2"), _S("2.0"), _S("1.0"), _S("2.1"),

	NO_MORE_RECORDS

	};

/**

list of values in modem speaker preference column

@internalComponent

*/

const TText* const ENUM_MODEM_SPEAKER_PREFArray[] =

	{

	_S("NEVER"), _S("UNTILCALLANSWERED"), _S("ALWAYS"), _S("AFTERDIALUNTILANSWER"),

	NO_MORE_RECORDS

	};

/**

list of values in modem speaker volumn column

@internalComponent

*/

const TText* const ENUM_MODEM_SPEAKER_VOL_PREFArray[] =

	{

	_S("QUIET"), _S("MEDIUM"), _S("LOUD"),

	NO_MORE_RECORDS

	};

/**

list of values in WAP WSP option column

@internalComponent

*/

const TText* const ENUM_WAP_WSP_OPTIONArray[] =

	{

	_S("CONNECTIONLESS"), _S("CONNECTIONORIENTED"),

	NO_MORE_RECORDS

	};

/**

list of values in connection prefs ranking column

@internalComponent

*/

const TText* const ENUM_CONNECT_PREF_RANKINGArray[] =

	{

	_S("0"), _S("1"), _S("2"),

	NO_MORE_RECORDS

	};

/**

list of values in connection preference direction column

@internalComponent

*/

const TText* const ENUM_CONNECT_PREF_DIRECTIONArray[] =

	{

	_S("UNKNOWN"), _S("OUTGOING"), _S("INCOMING"),

	NO_MORE_RECORDS

	};

/**

@internalComponent

*/

#define BEARER_SET_UNKNOWN		_S("UNKNOWN")