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

// - General definitions for client use

// - Table and column names,

// - Enums and constants use in tables,

// - UIDs for notifications

//

//

/**

 @file

 @publishedAll

 @deprecated since v9.1. Functionality is replaced with commsdat.

*/

#ifndef CDBCOLS_H

#define CDBCOLS_H

#include <e32std.h>

// Database table names. The name (a string) of each table is defined by a macro.

#define NETWORK											_S("Network")

/** Internet access point table identifier.*/

#define IAP												_S("IAP")

/** Identifier of default dial-out ISP table.

Field type: TUint32 */

#define DIAL_OUT_ISP									_S("DialOutISP")

/** Dial-in Internet Service Provider.

*/

#define DIAL_IN_ISP										_S("DialInISP")

/** Outgoing WCDMA table.

*/

#define OUTGOING_WCDMA									_S("OutgoingGPRS")

/**

Not used in v7.0 */

#define INCOMING_WCDMA									_S("IncomingGPRS")

#define LAN_SERVICE										_S("LANService")	// test use only

#define PAN_SERVICE_EXTENSIONS							_S("PANServiceExtensions")

#define WLAN_SERVICE_EXTENSIONS							_S("WLANServiceExtensions")

/**

Identifier of modem settings table.

In v7.0s, this table changed its name from MODEM to MODEM_BEARER.

In v6.1, it is possible to define only a single record for this table. */

#define MODEM_BEARER									_S("ModemBearer")

#define LAN_BEARER										_S("LANBearer")

/** Identifier of the default location table.

In 6.1, it is possible to define only a single record for this table.

Field type: TUint32 */

#define LOCATION										_S("Location")

/** Identifier of the default chargecard table.

Field type: TUint32 */

#define CHARGECARD										_S("Chargecard")

/** Identifier of proxy server settings table.*/

#define PROXIES											_S("Proxies")

/** Identifier of default WAP Access Point table.

Field type: TUint32 */

#define WAP_ACCESS_POINT								_S("WAPAccessPoint")

/** WAP IP bearer. */

#define WAP_IP_BEARER									_S("WAPIPBearer")

/** WAP SMS bearer. */

#define WAP_SMS_BEARER									_S("WAPSMSBearer")

/** GPRS default settings.

It is possible to define only one record for  this table.

*/

#define DEFAULT_GPRS									_S("DefaultGPRS")

/** Bluetooth device table. */

#define BT_DEVICE_TABLE									_S("BTDeviceTable")

/** Bluetooth default table. */

#define BT_DEFAULT_TABLE								_S("BTDefaultTable")

/** Bluetooth security table. */

#define BT_SECURITY_TABLE								_S("BTSecurityTable")

/** Bluetooth persist table. */

#define BT_PERSIST_TABLE								_S("BTPersistTable")

/** Identifier of the sockets table.*/

#define SS_PROTO_TABLE									_S("SecureSocketTable")

/** Agent lookup table identifier*/

#define AGENT_LOOKUP									_S("AgentLookup")

#define VIRTUAL_BEARER									_S("VirtualBearer")

#define VPN_SERVICE										_S("VpnService")

#define WLAN_SERVICE_EXTENSION_TABLE					_S("WLANServiceExtensionTable")

#define ACCESS_POINT_TABLE								_S("AccessPointTable")

#define IAP_PRIORITY_SELECTION_POLICY_TABLE				_S("IAPPrioritySelectionPolicyTable")

#define XML_ACCESS_POINT_TABLE							_S("AccessPoint")

#define AP_PRIORITY_SELECTION_POLICY_TABLE				_S("APPrioritySelectionPolicyTable")

#define TIER_TABLE										_S("TierTable")

#define MCPR_TABLE										_S("MCprTable")

#define CPR_TABLE										_S("CprTable")

#define SCPR_TABLE										_S("SCprTable")

#define PROTOCOL_TABLE									_S("ProtocolTable")

#define BEARER_TYPE_TABLE								_S("BearerTypeTable")

#define CONFIG_ACCESS_POINT_TABLE                                                       _S("ConfigAccessPointTable")

#define XML_AP_PRIORITY_SELECTION_POLICY_TABLE			_S("APPrioritySelectionPolicy")

#define XML_TIER_TABLE									_S("Tier")

#define XML_MCPR_TABLE									_S("MCpr")

#define XML_CPR_TABLE									_S("Cpr")

#define XML_SCPR_TABLE									_S("SCpr")

#define XML_PROTOCOL_TABLE								_S("Protocol")

#define XML_BEARER_TYPE_TABLE							_S("BearerType")

#define XML_CONFIG_ACCESS_POINT_TABLE                                                       _S("ConfigAccessPoint")

#define	EAP_SEC_TABLE									_S("EAPSecuritySettingsTable")

#define	TUN_EAP_TABLE									_S("TunnelledEAPSettingsTable")

#define	EAP_TLS_TABLE									_S("EAPTLSSettingsTable")

#define	LEAP_TABLE										_S("LEAPSettingsTable")

#define EAPSIM_PROTOCOL_TABLE							_S("EapSimProtocolTable")

#define EAPAKA_PROTOCOL_TABLE							_S("EapAkaProtocolTable")

#define POLICY_SELECTOR_TABLE                     		_S("PolicySelectorTable")

#define XML_POLICY_SELECTOR_TABLE                 		_S("PolicySelector")

#define POLICYSELECTOR2QOSPARAMETERS_TABLE 				_S("PolicySelector2QosParametersTable")

#define XML_POLICYSELECTOR2QOSPARAMETERS_TABLE 			_S("PolicySelector2QosParameters")

#define GENERIC_QOS_TABLE 								_S("GenericQosTable")

#define XML_GENERIC_QOS_TABLE 							_S("GenericQos")

/**

@internalTechnology

*/

#define WIFI_SCANENGINE_TABLE                     		_S("WifiScanEngineTable")

//DEPRECATED : MODEM has been reassigned so as to maintain backwards compatibility

/** Identifier of default modem.

Field type: TUint32

@deprecated Unsupported since v7.0 */

#define MODEM											MODEM_BEARER

// Just in case any applications use the literal pre-7.0s string for the ModemBearer table.

/** @deprecated Unsupported since v7.0 */

#define OLD_MODEM_TABLE									_S("Modem")

//

// Global settings.

// The following macros define values for the Global table fields.

// Note that Global table fields are accessed through CCommsDatabase.

//

/** Number of times to attempt redial when the ISP number is busy.

Field type: TUint32 */

#define REDIAL_ATTEMPTS									_S("RedialAttempts")

/** The bearer for sending SMS.

Values for this are defined by the enum RMobileSmsMessaging::TMobileSmsBearer

Field type: TUint32 */

#define SMS_BEARER										_S("SmsBearer")				// Takes the values of RGprs::TSmsBearer from ETEL

/** The SMS receive mode, taken from RMobileSmsMessaging::TMobileSmsReceiveMode.

Field type: TUint32 */

#define SMS_RECEIVE_MODE								_S("SmsReceiveMode")		// Takes the values of RMobileSmsMessaging::TMobileSmsReceiveMode from ETel MM

/** The GPRS attach mode, i.e. whether to attach at the boot-up of the device or

at a later time.

Values for this are defined by the enum RPacketService::TAttachMode

Field type: TUint32 */

#define GPRS_ATTACH_MODE								_S("GPRSAttachMode")				// Takes the values of RGprs::TGprsAttachMode from ETEL

/** Whether or not to allow incoming requests for PDP context activation to be automatically

accepted (when there is a waiting application).

Use a TBool to specify the value.

Field type: TUint32 */

#define ACCEPT_INCOMING_GPRS							_S("AcceptIncomingGprs")			// Takes a TBool value - ETrue = accept incoming requests, EFalse = reject incoming requests

/** The preferred bearer when device is forced into GPRS Class C operation.

The values for this field are defined by TCommDbGprsClassCBearer.

Field type: TUint32

@see TCommDbGprsClassCBearer */

#define GPRS_CLASS_C_BEARER								_S("GPRSClassCBearer")				// Takes the values of TCommDbGprsClassCBearer

/** The number of connection attempts (preferences) to make.

This is limited to a maximum of 2.

Field type: TUint32 */

#define CONNECTION_ATTEMPTS								_S("ConnectionAttempts")			// Number of connection preferences, with incremental rank, to try

/** Specifies the ID of the modem record to be used for data transactions.

Field type: TUint32 */

#define MODEM_DATA_FAX									_S("ModemForDataAndFax")

/** Specifies the ID of the modem record to be used for phone services such as SMS.

Field type: TUint32 */

#define MODEM_PHONE_SERVICES_SMS						_S("ModemForPhoneServicesAndSMS")

/** Specifies the location to be used with the default modem for data transactions.

Field type: TUint32 */

#define LOCATION_DATA_FAX								_S("LocationForDataAndFax")

/** Specifies the location to be used with default modem for phone services such

as SMS.

Field type: TUint32 */

#define LOCATION_PHONE_SERVICES_SMS						_S("LocationForPhoneServicesAndSMS")

/** Maximum RMBuf heap size.

Field type: TUint32 */

#define MAXMBUF_HEAP									_S("MaxMBufHeap")

#define DEFAULT_AGENT									_S("DefaultAgent")

#define DEFAULT_NETWORK									_S("DefaultNetwork")

#define BEARER_AVAILABILITY_CHECK_TSY					_S("BearerAvailabilityCheckTSY")

// The following fields define the specific CDMA parameters provisioned through OTA

// and  defined in TIA-683B section 3.5.8

/** Operation capability bitmap to indicate which operations are supported by the MS.

Bit allocation:

bit 0 - SimpleIP supported

bit 1 - MobileIP supported

bit 2 - MobileIP with simple IP fallback supported

bits 3-7 - reserved

Field type: TUint32 */

#define CDMA_OP_CAPABILITY								_S("CDMAOperationCapability")

/** Maximum number of SimpleIP NAI entries.

Field type: TUint32 */

#define CDMA_SIMIP_MAX_NUM_NAI							_S("CDMASimpleIpMaxNumNai")

/** Maximum SimpleIP NAI length (min 72 octets).

Field type: TUint32 */

#define CDMA_SIMIP_MAX_NAI_LENGTH						_S("CDMASimpleIpMaxNaiLength")

/** Maximum length of SimpleIP shared secret data.

Field type: TUint32 */

#define CDMA_SIMIP_MAX_SS_LENGTH						_S("CDMASimpleIpMaxSsLength")

/** SimpleIP authentication algorithm bitmap supported by the MS.

Bit allocation:

bit 0 - CHAP supported

bit 1 - PAP supported

bits 2-7 - reserved

Field type: TUint32 */

#define CDMA_SIMIP_AUTH_SUPPORTED						_S("CDMASimpleIpAuthSupported")

/** Maximum number of mobile IP NAI entries.

Field type: TUint32 */

#define CDMA_MIP_MAX_NUM_NAI							_S("CDMAMobileIpMaxNumNai")

/** Maximum MobileIP NAI length (min 72 octets).

Field type: TUint32 */

#define CDMA_MIP_MAX_NAI_LENGTH							_S("CDMAMobileIpMaxNAILength")

/** Maximum length of the shared secret data (MN-AAA)

Field type: TUint32 */

#define CDMA_MIP_MAX_MN_AAA_SS_LENGTH					_S("CDMAMobileIpMaxMnAaaSsLength")

/** Authentication algorithm bitmap (MN-AAA) supported by the mobile station.

Bit allocation:

bit 0 - MD5 authentication supported (RFC 3012)

bits 1-7 - reserved

Field type: TUint32 */

#define CDMA_MIP_MN_AAA_AUTH_ALGORITHM					_S("CDMAMobileIpMnAaaAuthAlgorithm")

/** Maximum length of the shared secret data (MN-HA)

Field type: TUint32 */

#define CDMA_MIP_MAX_MN_HA_SS_LENGTH					_S("CDMAMobileIpMaxMnHaSsLength")

/** Authentication algorithm bitmap (MN-HA) supported by the mobile station.

Bit allocation:

bit 0 - MD5 authentication supported (RFC 3012)

bits 1-7 - reserved

Field type: TUint32 */

#define CDMA_MIP_MN_HA_AUTH_ALGORITHM					_S("CDMAMobileIpMnHaAuthAlgorithm")

/** Prompt for an Access Point if used.

Field type: TBool*/

#define PROMPT_FOR_AP									_S("PromptForSnap")

/** If default Access Point is defined, use default Access Point. Otherwise use connection preferences.

Field type: TUint32 */

#define DEFAULT_AP										_S("DefaultSnap")

/** This field differentiate the Bravo selection from the 399 selection

(needed for implicit scenarios where prefs are not available).

Field type: TUint32 */

#define DEFAULT_SNAP									_S("DefaultSnap")

/** Default tier.

Field type: TUint32 */

#define DEFAULT_TIER	      							_S("DefaultTier")

/** Prompt the User.

Field type: TBool*/

#define PROMPT_USER									    _S("PromptUser")

/** This field  defines the default or current IEEE 802.11 regulatory domain or country code.

Field type: TCommsDatWlanRegDomain */

#define REGULATORY_DOMAIN						_S("RegulatoryDomain")

#define	WMM_ENABLED										_S("WmmEnabled")

/** This field determines whether to use the country code information or not.

 *

 * Field type: TBool */

#define ENABLE_COUNTRYCODE								_S("EnableCountryCode")

/** This field  defines the default regulatory domain or country code.

 *

 * Field type: TDesC */

#define DEFAULT_REGULATORY_DOMAIN						_S("DefaultRegulatoryDomain")

/**

Maintained for backwards compatibility.

Specifies whether to show the connection dialog.

Field type: TUint32 (Boolean)

@deprecated v7.0 */

#define ASK_USER_BEFORE_DIAL							_S("AskUserBeforeDial")

/** Identifier of default dial-out IAP.

Field type: TUint32

@deprecated v7.0 */

#define DIAL_OUT_IAP									_S("DialOutIAP")

#define DIAL_IN_IAP										_S("DialInIAP")

/** Identifier of (dial out) ISP in this IAP.

Field type: TUint32. This field may not be left as NULL.

@deprecated v7.0 */

#define IAP_ISP											_S("IAPISP")

/** Time to stay online when all clients have closed.

Field type: TUint32

@deprecated v7.0 */

#define CLIENT_TIMEOUT									_S("ClientTimout")

/** Time to stay online when idle.

Field type: TUint32

@deprecated v7.0 */

#define ROUTE_TIMEOUT									_S("RouteTimeout")

/** Outgoing GPRS table.

*/

#define OUTGOING_GPRS									OUTGOING_WCDMA

/** Incoming GPRS table.

*/

#define INCOMING_GPRS									INCOMING_WCDMA

#define ECommDbBearerUnknown							KCommDbBearerUnknown

#define ECommDbBearerCSD								KCommDbBearerCSD

#define ECommDbBearerWcdma								KCommDbBearerWcdma

#define ECommDbBearerLAN								KCommDbBearerLAN

#define ECommDbBearerCdma2000							KCommDbBearerCdma2000

#define ECommDbBearerPSD								KCommDbBearerPSD

#define ECommDbBearerVirtual							KCommDbBearerVirtual

#define ECommDbBearerPAN								KCommDbBearerPAN

#define ECommDbBearerWLAN								KCommDbBearerWLAN

/** Avoids the need for lots of search & replace in migrations from v6.1 */

#define ECommDbBearerGPRS                               ECommDbBearerWcdma

// Columns common to all tables

/**Unique ID assigned by the server for identification of records by the server.

Field type: TUint32 */

#define COMMDB_ID										_S("Id")			// Id of the row

/**Name of the record for easy identification by the user.

This is not present in the some tables.

Field type: Text. */

#define COMMDB_NAME										_S("Name")			// Name of the row

// COMMDB_UNUSED_NAME with COMMDB_ID appended, is inserted in the name column of entries that

// have been deleted, but are required to be inserted by ceddump, inserted and subsequently

// deleted by ced so that the COMMDB_ID indices are preserved. Such entries may be modified

// but ideally should not be deleted as this will require all the indices to be recalculated.

_LIT(COMMDB_UNUSED_NAME, "__UNUSED_ENTRY_DO_NOT_DELETE__");

// Columns for `IAP` table

// The following macros define values for the IAP table fields.

// An IAP table allows a group of related records for service information (including service

// type), and chargecard (optional) to be identified.

/** Identifier of the dialog preference in this IAP.

Field type: TUint32. This field may be left as NULL. */

#define IAP_DIALOG_PREF									_S("DialogPref")

/** Identifier of the service in this IAP.

Field type: TUint32. This field may not be left as NULL. */

#define IAP_SERVICE										_S("IAPService")

/** Name of the service table (e.g. DIAL_OUT_ISP, OUTGOING_GPRS)

in this IAP.

Field type: Text. This field may not be left as NULL. */

#define IAP_SERVICE_TYPE								_S("IAPServiceType")

/** Identifier of the bearer in this IAP.

Field type: TUint32. This field may be left as NULL. */

#define IAP_BEARER										_S("IAPBearer")

/** Identifier of the type of the bearer in this IAP.

Field type: Text. This field may be left as NULL. */

#define IAP_BEARER_TYPE									_S("IAPBearerType")

/** Identifier of the network in this IAP.

Field type: TUint32. This field may be left as NULL. */

#define IAP_NETWORK										_S("IAPNetwork")

/** Identifier of the Application secure ID in this IAP.

Field type: TUint32. This field may be left as NULL. */

#define IAP_APPSID                                      _S("IAPAppSid")

/** Identifier of the weighting for networks in this IAP.

Field type: TUint32. This field may be left as NULL. */

#define IAP_NETWORK_WEIGHTING							_S("IAPNetworkWeighting")

/** Identifier of the location in this IAP.

Field type: TUint32. This field may be left as NULL. */

#define IAP_LOCATION									_S("Location")

//#define IAP_CHARGECARD									_S("Chargecard")

#define BCA_STACK										_S("BCAStack") 						///< Comma separated list of BCAs, eg. C32BCA 

// Columns common to all bearer tables using IP and PPP

#define IF_NAME											_S("IfName")						//< Interface name, e.g. "PPP" or "SLIP"

// Columns common to all service tables using IP and PPP

#define SERVICE_IF_PARAMS								_S("IfParams")						//< Interface parameter string

#define SERVICE_IF_NETWORKS								_S("IfNetworks")					//< Comma separated list of network protocols, e.g. "PPP"

/**  When using external IP configuration (MobileIP or DHCP), always reject PPP peer authentication requests.

If external IP configuration is used and this field is set to TRUE then peer authentication requests are always rejected.

If external IP configuration is used and this field is set to FALSE then PPP allows authentication to proceed (although it may still fail later).

If this field is not set or absent, the result is the same as when it is set to TRUE. */

#define SERVICE_IF_EXTERN_IP_CONFIG_ALWAYS_REJECT_AUTH	_S("IfExternIpConfigAlwaysRejectAuth")

#define SERVICE_IF_PROMPT_FOR_AUTH						_S("IfPromptForAuth")				//< Prompt user for authentication name and password?

#define SERVICE_IF_AUTH_NAME							_S("IfAuthName")					//< Authentication username used by PPP

#define SERVICE_IF_AUTH_PASS							_S("IfAuthPass")					//< Authentication password used by PPP

#define SERVICE_IF_AUTH_RETRIES							_S("AuthRetries")					//< No of times to retry authentication if it fails

#define SERVICE_IF_CALLBACK_ENABLED						_S("IfCallbackEnabled")				//< Callback enabled?

#define SERVICE_IF_CALLBACK_TYPE						_S("IfCallbackType")				//< Type of callback if enabled

#define SERVICE_IF_CALLBACK_INFO						_S("IfCallbackInfo")				//< Info for callback request if enabled

#define SERVICE_CALLBACK_TIMEOUT						_S("CallbackTimeout")				//< time to wait for callback

#define SERVICE_IF_SERVER_MODE							_S("IfServerMode")					//< PPP in server mode?

#define SERVICE_IP_ADDR_FROM_SERVER						_S("IpAddrFromServer")				//< Get IP address from server?

#define SERVICE_IP_ADDR									_S("IpAddr")						//< IP Address of Interface

#define SERVICE_IP_NETMASK								_S("IpNetMask")						//< IP Netmask of Interface

#define SERVICE_IP_GATEWAY								_S("IpGateway")						//< IP Address of Gateway

#define SERVICE_IP_DNS_ADDR_FROM_SERVER					_S("IpDNSAddrFromServer")			//< Get DNS addresses from server?

#define SERVICE_IP_NAME_SERVER1							_S("IpNameServer1")					//< IP Address of primary name server reachable through this interface

#define SERVICE_IP_NAME_SERVER2							_S("IpNameServer2")					//< IP Address of secondary name server reachable through this interface

#define SERVICE_IP6_DNS_ADDR_FROM_SERVER					_S("Ip6DNSAddrFromServer")			//< Get DNS addresses from server?

#define SERVICE_IP6_NAME_SERVER1							_S("Ip6NameServer1")					//< IP Address of primary name server reachable through this interface

#define SERVICE_IP6_NAME_SERVER2							_S("Ip6NameServer2")					//< IP Address of secondary name server reachable through this interface

#define SERVICE_ENABLE_IP_HEADER_COMP	 				_S("EnableIPHeaderComp")			//< Enable IP header compression

#define SERVICE_ENABLE_LCP_EXTENSIONS					_S("EnableLCPExtension")			//< Enable LCP extension

#define SERVICE_DISABLE_PLAIN_TEXT_AUTH					_S("DisablePlainTextAuth")			//< Disable plain text authentication

#define SERVICE_ENABLE_SW_COMP							_S("EnableSWComp")					//< Enable S/W compression

#define SERVICE_IP_ADDR_LEASE_VALID_FROM				_S("IpAddrLeaseValidFrom")			//< Start of address lease (.e.g. a DHCP assigned ip address)

#define SERVICE_IP_ADDR_LEASE_VALID_TO					_S("IpAddrLeaseValidTo")			//< End of address lease (e.g. a DHCP assigned IP address)

#define SERVICE_CONFIG_DAEMON_MANAGER_NAME				_S("ConfigDaemonManagerName")		//< Name of the ECOM daemon manager plug-in for NIFMAN used to load a specific configuration daemon (see the next field)

#define SERVICE_CONFIG_DAEMON_NAME						_S("ConfigDaemonName")				//< Name of the daemon used for address configuration .e.g Dhcp, MobileIp

/** Enable link-local multicast name resolution

Field type: TBool. This field may be left as NULL. */

#define SERVICE_ENABLE_LLMNR						_S("EnableLLMNR")

#define ISP_SERVICE_ENABLE_LLMNR					SERVICE_ENABLE_LLMNR

#define GPRS_SERVICE_ENABLE_LLMNR					SERVICE_ENABLE_LLMNR

#define LAN_SERVICE_ENABLE_LLMNR					SERVICE_ENABLE_LLMNR

#define CDMA_SERVICE_ENABLE_LLMNR					SERVICE_ENABLE_LLMNR

#define VPN_SERVICE_ENABLE_LLMNR					SERVICE_ENABLE_LLMNR

// Columns of the `DIAL_OUT_ISP` and `DIAL_IN_ISP` service tables.

// The following macros define values for the dial out/in ISP table fields.

/** Description of ISP (for use by applications etc.)

Field type: Text. This field may be left as NULL.*/

#define ISP_DESCRIPTION									_S("Description")					// text field for app to use to describe ISP

/** TCommsDbIspType value indicating ISP type, e.g. Internet, LAN, etc.

Field type: TUint32. This field may be left as NULL. */

#define ISP_TYPE										_S("Type")							// int field for ISP "type" e.g. Internet, LAN, etc

/** Default phone number.

Field type: Text. This field may be left as NULL. */

#define ISP_DEFAULT_TEL_NUM								_S("DefaultTelNum")					// The default telephone number to be used if the location does not match those below

/** Perform dialling resolution for default phone number?

Field type: TBool. This field may not be left as NULL. */

#define ISP_DIAL_RESOLUTION								_S("DialResolution")				// Perform Dialing Resolution for default phone number?

/** Use login script?

Field type: TBool. This field may not be left as NULL. */

#define ISP_USE_LOGIN_SCRIPT							_S("UseLoginScript")				// Use login script?

/** Login script (used if ISP_USE_LOGIN_SCRIPT is ETrue).