// 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:

// Table definitions

// 

//

/**

 @file

 @internalComponent

*/

#ifndef __TABDEF_H__

#define __TABDEF_H__

#include <e32math.h>

#include <f32file.h>

#include "CDBSTD.H"

/**

@internalComponent

*/

namespace commdb_dll

	{

const TUint KSingleQuoteChar='\'';

/**

Literals to speed up commdb by not having to create TPtr's at runtime 

@internalComponent

*/

CDB_LIT(KGlobalSettings,_GLOBAL_SETTINGS);

CDB_LIT(KConnectionPreferences,_CONNECTION_PREFERENCES);

CDB_LIT(KConnectPrefRanking,_CONNECT_PREF_RANKING);

CDB_LIT(KConnectPrefDirection,_CONNECT_PREF_DIRECTION);

CDB_LIT(KCommDbIntValue, _COMMDB_INT_VALUE);

CDB_LIT(KCommDbTextValue, _COMMDB_TEXT_VALUE);

CDB_LIT(KStartSQLQuery,_SQL_START_SQL_QUERY);

CDB_LIT(KWhereKeyword,_SQL_WHERE_KEYWORD);

CDB_LIT(KAndKeyword,_SQL_AND_KEYWORD);

CDB_LIT(KOrderKeyword,_SQL_ORDER_KEYWORD);

CDB_LIT(KOrderByKeyword, _SQL_ORDER_BY_KEYWORD);

CDB_LIT(KWhereHidden,_SQL_WHERE_HIDDEN);

CDB_LIT(KAndHidden,_SQL_AND_HIDDEN);

CDB_LIT(KWhereIntMatch,_SQL_WHERE_INT_MATCH);

CDB_LIT(KWhereTextMatch,_SQL_WHERE_TEXT_MATCH);

CDB_LIT(KAndIntMatch,_SQL_AND_INT_MATCH) ;

CDB_LIT(KAndTextMatch,_SQL_AND_TEXT_MATCH);

CDB_LIT(KOrTextMatch,_SQL_OR_TEXT_MATCH);

CDB_LIT(KWhereIntGreaterThan,_SQL_WHERE_INT_GREATERTHAN);

/**

Default widths for DB columns

@internalComponent

*/

const TInt KDefaultColumnWidth = KDbUndefinedLength  ;

const TInt KDefaultTextColumnWidth = 50 ;

/**

Non-default DB column widths

*/

const TInt KAUTH_NAME_FIELD_WIDTH = 255 ;

const TInt KAUTH_PASS_FIELD_WIDTH = 255 ;

/**

Specifies the name, type and special attributes of a column in a table.

Used during the creation of a new database.

@internalComponent

*/

struct TColumn

	{

	const TText* iName;

	TDbColType iType;

	TUint iAttributes;

	TInt iColumnWidth ;

	};

/**

Specifies the name and columns of a table.

An array of `TTable` objects is used during the creation of a new database.

@internalComponent

*/

struct TTable

	{

	const TText* iName;

	const TColumn* iTable;

	};

/**

Maps a bearer type and direction to a service table (Dialout,GPRS)

Used by `OpenIAPTableViewMatchingBearerSetLC()`.

@internalComponent

*/

struct TMapBearerToServiceType

	{

	TCommDbBearer				bearerMask;

	TCommDbConnectionDirection	direction;

	const TText*				serviceType;

	};

/**

Table defintions

@internalComponent

*/ 

TColumn const KNetworkTable[]=

	{

	{COMMDB_ID,EDbColUint32,TDbCol::EAutoIncrement|TDbCol::ENotNull, KDefaultColumnWidth},

	{COMMDB_NAME,EDbColText,TDbCol::ENotNull, KDefaultTextColumnWidth},

	{COMMDB_HIDDEN,EDbColBit,TDbCol::ENotNull, KDefaultColumnWidth},

	{COMMDB_READ_ONLY,EDbColBit,TDbCol::ENotNull, KDefaultColumnWidth},

	//

	{HOST_NAME,EDbColText,0, KDefaultTextColumnWidth},

	{0}

	};

/**

@internalComponent

*/

TColumn const KIAPTable[]=

	{

	{COMMDB_ID, EDbColUint32, TDbCol::EAutoIncrement|TDbCol::ENotNull, KDefaultColumnWidth},

	{COMMDB_NAME, EDbColText, TDbCol::ENotNull, KDefaultTextColumnWidth},

	{COMMDB_HIDDEN,EDbColBit, TDbCol::ENotNull, KDefaultColumnWidth},

	{COMMDB_READ_ONLY, EDbColBit, TDbCol::ENotNull, KDefaultColumnWidth},

	//

	{IAP_SERVICE,EDbColUint32,TDbCol::ENotNull, KDefaultColumnWidth},

	{IAP_SERVICE_TYPE, EDbColText, TDbCol::ENotNull, KDefaultTextColumnWidth},

	{IAP_BEARER,EDbColUint32,TDbCol::ENotNull, KDefaultColumnWidth},

	{IAP_BEARER_TYPE,EDbColText,TDbCol::ENotNull, KDefaultTextColumnWidth},

	{IAP_NETWORK,EDbColUint32,TDbCol::ENotNull, KDefaultColumnWidth},

	{IAP_NETWORK_WEIGHTING,EDbColUint32,TDbCol::ENotNull, KDefaultColumnWidth},

	{IAP_LOCATION,EDbColUint32,TDbCol::ENotNull, KDefaultColumnWidth},

#ifdef SYMBIAN_NETWORKING_UMTSR5

	{IAP_APPSID,EDbColUint32,TDbCol::ENotNull, KDefaultColumnWidth},

#endif //SYMBIAN_NETWORKING_UMTSR5

	//

	{0}

	};

/**

@internalComponent

*/

TColumn const KDialOutISPTable[]=

	{

	{COMMDB_ID,EDbColUint32,TDbCol::EAutoIncrement|TDbCol::ENotNull, KDefaultColumnWidth},

	{COMMDB_NAME,EDbColText,TDbCol::ENotNull, KDefaultTextColumnWidth},

	{COMMDB_HIDDEN,EDbColBit,TDbCol::ENotNull, KDefaultColumnWidth},

	{COMMDB_READ_ONLY,EDbColBit,TDbCol::ENotNull, KDefaultColumnWidth},

	//

	{ISP_DESCRIPTION,EDbColText,0, KDefaultTextColumnWidth},

	{ISP_TYPE,EDbColUint32,0, KDefaultColumnWidth},

	//

	{ISP_DEFAULT_TEL_NUM,EDbColText,0, KDefaultTextColumnWidth},

	{ISP_DIAL_RESOLUTION,EDbColBit,TDbCol::ENotNull, KDefaultColumnWidth},

	{ISP_USE_LOGIN_SCRIPT,EDbColBit,TDbCol::ENotNull, KDefaultColumnWidth},

	{ISP_LOGIN_SCRIPT,EDbColLongText,0, KDefaultColumnWidth},

	{ISP_PROMPT_FOR_LOGIN,EDbColBit,TDbCol::ENotNull, KDefaultColumnWidth},

	{ISP_LOGIN_NAME,EDbColText,0, KAUTH_NAME_FIELD_WIDTH},

	{ISP_LOGIN_PASS,EDbColText,0, KAUTH_PASS_FIELD_WIDTH},

	{ISP_CHARGECARD,EDbColUint32,0, KDefaultColumnWidth},

	{ISP_DISPLAY_PCT,EDbColBit,0, KDefaultColumnWidth},

	//

	{ISP_IF_PARAMS,EDbColText,0, KDefaultTextColumnWidth},

	{ISP_IF_NETWORKS,EDbColText,0, KDefaultTextColumnWidth},

	//

	{ISP_IF_PROMPT_FOR_AUTH,EDbColBit,TDbCol::ENotNull, KDefaultColumnWidth},

	{ISP_IF_AUTH_NAME,EDbColText,0, KAUTH_NAME_FIELD_WIDTH},

	{ISP_IF_AUTH_PASS,EDbColText,0, KAUTH_PASS_FIELD_WIDTH},

	{ISP_IF_AUTH_RETRIES,EDbColUint32,0, KDefaultColumnWidth},

	{ISP_IF_CALLBACK_ENABLED,EDbColBit,0, KDefaultColumnWidth},

	{ISP_IF_CALLBACK_TYPE,EDbColUint32,0, KDefaultColumnWidth},

	{ISP_IF_CALLBACK_INFO,EDbColText8,0, KDefaultTextColumnWidth},

	{ISP_CALLBACK_TIMEOUT,EDbColUint32,0, KDefaultColumnWidth},

	//

	{ISP_IP_ADDR_FROM_SERVER,EDbColBit,TDbCol::ENotNull, KDefaultColumnWidth},

	{ISP_IP_ADDR,EDbColText,0, KDefaultTextColumnWidth},

	{ISP_IP_NETMASK,EDbColText,0, KDefaultTextColumnWidth},

	{ISP_IP_GATEWAY,EDbColText,0, KDefaultTextColumnWidth},

	{ISP_IP_DNS_ADDR_FROM_SERVER,EDbColBit,TDbCol::ENotNull, KDefaultColumnWidth},

	{ISP_IP_NAME_SERVER1,EDbColText,0, KDefaultTextColumnWidth},

	{ISP_IP_NAME_SERVER2,EDbColText,0, KDefaultTextColumnWidth},

	{ISP_IP6_DNS_ADDR_FROM_SERVER, EDbColBit,0, KDefaultColumnWidth},

	{ISP_IP6_NAME_SERVER1,EDbColText,0, KDefaultTextColumnWidth},

	{ISP_IP6_NAME_SERVER2,EDbColText,0, KDefaultTextColumnWidth},

	{ISP_IP_ADDR_LEASE_VALID_FROM,EDbColText,0, KDefaultTextColumnWidth},

	{ISP_IP_ADDR_LEASE_VALID_TO,EDbColText,0, KDefaultTextColumnWidth}, 

	//

	{ISP_CONFIG_DAEMON_MANAGER_NAME,EDbColText,0, KDefaultTextColumnWidth},

	{ISP_CONFIG_DAEMON_NAME,EDbColText,0, KDefaultTextColumnWidth},

	//

	{ISP_ENABLE_IP_HEADER_COMP,EDbColBit,0, KDefaultColumnWidth},

	{ISP_ENABLE_LCP_EXTENSIONS,EDbColBit,0, KDefaultColumnWidth},

	{ISP_DISABLE_PLAIN_TEXT_AUTH,EDbColBit,0, KDefaultColumnWidth},

	{ISP_ENABLE_SW_COMP,EDbColBit,0, KDefaultColumnWidth},

	//

	{ISP_BEARER_NAME,EDbColUint32,0, KDefaultColumnWidth},

	{ISP_BEARER_SPEED,EDbColUint32,0, KDefaultColumnWidth},

	{ISP_BEARER_CE,EDbColUint32,0, KDefaultColumnWidth},

	{ISP_INIT_STRING,EDbColText8,0, KDefaultTextColumnWidth},

	//

	{ISP_BEARER_TYPE,EDbColUint32,0, KDefaultColumnWidth},

	{ISP_CHANNEL_CODING,EDbColUint32,0, KDefaultColumnWidth},

	{ISP_AIUR,EDbColUint32,0, KDefaultColumnWidth},

	{ISP_REQUESTED_TIME_SLOTS,EDbColUint32,0, KDefaultColumnWidth},

	{ISP_MAXIMUM_TIME_SLOTS,EDbColUint32,0, KDefaultColumnWidth},

	//

	/**	new multimode columns */

	{ISP_BEARER_SERVICE,EDbColUint32,0, KDefaultColumnWidth},

	{ISP_BEARER_PROTOCOL,EDbColUint32,0, KDefaultColumnWidth},

	{ISP_RLP_VERSION,EDbColUint32,0, KDefaultColumnWidth},

	{ISP_IWF_TO_MS,EDbColUint32,0, KDefaultColumnWidth},

	{ISP_MS_TO_IWF,EDbColUint32,0, KDefaultColumnWidth},

	{ISP_ACK_TIMER,EDbColUint32,0, KDefaultColumnWidth},

	{ISP_RETRANSMISSION_ATTEMPTS,EDbColUint32,0, KDefaultColumnWidth},

	{ISP_RESEQUENCE_PERIOD,EDbColUint32,0, KDefaultColumnWidth},

	{ISP_V42_COMPRESSION,EDbColUint32,0, KDefaultColumnWidth},

	{ISP_V42_CODEWORDS,EDbColUint32,0, KDefaultColumnWidth},

	{ISP_V42_MAX_LENGTH,EDbColUint32,0, KDefaultColumnWidth},

	{ISP_ASYMMETRY,EDbColUint32,0, KDefaultColumnWidth},

	{ISP_USER_INIT_UPGRADE,EDbColBit,0, KDefaultColumnWidth},

	{ISP_USE_EDGE,EDbColBit,0, KDefaultColumnWidth},

	{ISP_IF_SERVER_MODE,EDbColBit,0, KDefaultColumnWidth},

	{ISP_SERVICE_ENABLE_LLMNR,EDbColBit,0, KDefaultColumnWidth},

	{0}

	};

/**

@internalComponent

*/

TColumn const KDialInISPTable[]=

	{

	{COMMDB_ID,EDbColUint32,TDbCol::EAutoIncrement|TDbCol::ENotNull, KDefaultColumnWidth},

	{COMMDB_NAME,EDbColText,TDbCol::ENotNull, KDefaultTextColumnWidth},

	{COMMDB_HIDDEN,EDbColBit,TDbCol::ENotNull, KDefaultColumnWidth},

	{COMMDB_READ_ONLY,EDbColBit,TDbCol::ENotNull, KDefaultColumnWidth},

	//

	{ISP_DESCRIPTION,EDbColText,0, KDefaultTextColumnWidth},

	{ISP_TYPE,EDbColUint32,0, KDefaultColumnWidth},

	//

	{ISP_USE_LOGIN_SCRIPT,EDbColBit,0, KDefaultColumnWidth},

	{ISP_LOGIN_SCRIPT,EDbColLongText,0, KDefaultColumnWidth},

	//

	{ISP_AUTHENTICATION,EDbColUint32,0, KDefaultColumnWidth},

	{ISP_IF_AUTH_RETRIES,EDbColUint32,0, KDefaultColumnWidth},

	//

	{ISP_IF_PARAMS,EDbColText,0, KDefaultTextColumnWidth},

	{ISP_IF_NETWORKS,EDbColText,0, KDefaultTextColumnWidth},

	//

	{ISP_IP_ADDR_FROM_SERVER,EDbColBit,TDbCol::ENotNull, KDefaultColumnWidth},

	{ISP_IP_ADDR,EDbColText,0, KDefaultTextColumnWidth},

	{ISP_IP_NETMASK,EDbColText,0, KDefaultTextColumnWidth},

	{ISP_IP_GATEWAY,EDbColText,0, KDefaultTextColumnWidth},

	{ISP_IP_DNS_ADDR_FROM_SERVER,EDbColBit,TDbCol::ENotNull, KDefaultColumnWidth},

	{ISP_IP_NAME_SERVER1,EDbColText,0, KDefaultTextColumnWidth},

	{ISP_IP_NAME_SERVER2,EDbColText,0, KDefaultTextColumnWidth},

	{ISP_IP6_DNS_ADDR_FROM_SERVER,EDbColBit,0, KDefaultColumnWidth},

	{ISP_IP6_NAME_SERVER1,EDbColText,0, KDefaultTextColumnWidth},

	{ISP_IP6_NAME_SERVER2,EDbColText,0, KDefaultTextColumnWidth},

	//

	{ISP_ENABLE_IP_HEADER_COMP,EDbColBit,0, KDefaultColumnWidth},

	{ISP_ENABLE_LCP_EXTENSIONS,EDbColBit,0, KDefaultColumnWidth},

	{ISP_DISABLE_PLAIN_TEXT_AUTH,EDbColBit,0, KDefaultColumnWidth},

	{ISP_ENABLE_SW_COMP,EDbColBit,0, KDefaultColumnWidth},

	//

	{ISP_BEARER_NAME,EDbColUint32,0, KDefaultColumnWidth},

	{ISP_BEARER_SPEED,EDbColUint32,0, KDefaultColumnWidth},

	{ISP_BEARER_CE,EDbColUint32,0, KDefaultColumnWidth},

	{ISP_INIT_STRING,EDbColText8,0, KDefaultTextColumnWidth},

	{ISP_USE_EDGE,EDbColBit,0, KDefaultColumnWidth},

	//

	{0}

	};

/**

@internalComponent

*/

TColumn const KGPRSTable[]=

	{

	{COMMDB_ID,EDbColUint32,TDbCol::EAutoIncrement|TDbCol::ENotNull, KDefaultColumnWidth},

	{COMMDB_NAME,EDbColText,TDbCol::ENotNull, KDefaultTextColumnWidth},

	{COMMDB_HIDDEN,EDbColBit,TDbCol::ENotNull, KDefaultColumnWidth},

	{COMMDB_READ_ONLY,EDbColBit,TDbCol::ENotNull, KDefaultColumnWidth},

	{GPRS_APN,EDbColLongText,0, KDefaultColumnWidth},

	//

	{GPRS_PDP_TYPE,EDbColUint32,TDbCol::ENotNull, KDefaultColumnWidth},

	{GPRS_PDP_ADDRESS,EDbColText,0, KDefaultTextColumnWidth},

	//

	{GPRS_REQ_PRECEDENCE,EDbColUint32,0, KDefaultColumnWidth},

	{GPRS_REQ_DELAY,EDbColUint32,0, KDefaultColumnWidth},

	{GPRS_REQ_RELIABILITY,EDbColUint32,0, KDefaultColumnWidth},

	{GPRS_REQ_PEAK_THROUGHPUT,EDbColUint32,0, KDefaultColumnWidth},

	{GPRS_REQ_MEAN_THROUGHPUT,EDbColUint32,0, KDefaultColumnWidth},

	//

	{GPRS_MIN_PRECEDENCE,EDbColUint32,0, KDefaultColumnWidth},

	{GPRS_MIN_DELAY,EDbColUint32,0, KDefaultColumnWidth},

	{GPRS_MIN_RELIABILITY,EDbColUint32,0, KDefaultColumnWidth},

	{GPRS_MIN_PEAK_THROUGHPUT,EDbColUint32,0, KDefaultColumnWidth},

	{GPRS_MIN_MEAN_THROUGHPUT,EDbColUint32,0, KDefaultColumnWidth},

	//

	{GPRS_DATA_COMPRESSION,EDbColBit,0, KDefaultColumnWidth},

	{GPRS_HEADER_COMPRESSION,EDbColBit,0, KDefaultColumnWidth},

	{GPRS_USE_EDGE, EDbColBit, 0, KDefaultColumnWidth},

	//

	{GPRS_ANONYMOUS_ACCESS,EDbColBit,0, KDefaultColumnWidth},

	//

	{GPRS_IF_PARAMS,EDbColText,0, KDefaultTextColumnWidth},

	{GPRS_IF_NETWORKS,EDbColText,0, KDefaultTextColumnWidth},

	//

	{GPRS_IF_PROMPT_FOR_AUTH,EDbColBit,TDbCol::ENotNull, KDefaultColumnWidth},

	{GPRS_IF_AUTH_NAME,EDbColText,0, KAUTH_NAME_FIELD_WIDTH},

	{GPRS_IF_AUTH_PASS,EDbColText,0, KAUTH_PASS_FIELD_WIDTH},

	//

	{GPRS_IF_AUTH_RETRIES,EDbColUint32,0, KDefaultColumnWidth},

	//

	{GPRS_IP_NETMASK,EDbColText,0, KDefaultTextColumnWidth},

	{GPRS_IP_GATEWAY,EDbColText,0, KDefaultTextColumnWidth},

	{GPRS_IP_ADDR_FROM_SERVER,EDbColBit,TDbCol::ENotNull, KDefaultColumnWidth},

	{GPRS_IP_ADDR,EDbColText,0, KDefaultTextColumnWidth},

	{GPRS_IP_DNS_ADDR_FROM_SERVER,EDbColBit,TDbCol::ENotNull,KDefaultColumnWidth},

	{GPRS_IP_NAME_SERVER1,EDbColText,0, KDefaultTextColumnWidth},

	{GPRS_IP_NAME_SERVER2,EDbColText,0, KDefaultTextColumnWidth},

	//

	{GPRS_IP6_DNS_ADDR_FROM_SERVER,EDbColBit,0, KDefaultColumnWidth},

	{GPRS_IP6_NAME_SERVER1,EDbColText,0, KDefaultTextColumnWidth},

	{GPRS_IP6_NAME_SERVER2,EDbColText,0, KDefaultTextColumnWidth},

	{GPRS_IP_ADDR_LEASE_VALID_FROM,EDbColText,0, KDefaultTextColumnWidth},

	{GPRS_IP_ADDR_LEASE_VALID_TO,EDbColText,0, KDefaultTextColumnWidth},

	//

	{GPRS_CONFIG_DAEMON_MANAGER_NAME,EDbColText,0, KDefaultTextColumnWidth},	

	{GPRS_CONFIG_DAEMON_NAME,EDbColText,0, KDefaultTextColumnWidth},

	//

	{GPRS_ENABLE_LCP_EXTENSIONS,EDbColBit,0, KDefaultColumnWidth},

	{GPRS_DISABLE_PLAIN_TEXT_AUTH,EDbColBit,0, KDefaultColumnWidth},

	//

	{GPRS_AP_TYPE,EDbColUint32,0, KDefaultColumnWidth},

	//

	{GPRS_QOS_WARNING_TIMEOUT,EDbColUint32,0, KDefaultColumnWidth},

	{GPRS_SERVICE_ENABLE_LLMNR,EDbColBit,0, KDefaultColumnWidth},

	{QOS_UMTS_R99_AND_ON_TABLE, EDbColUint32, 0, KDefaultColumnWidth},

	{GPRS_R5_DATA_COMPRESSION,EDbColUint32, 0, KDefaultColumnWidth},

	{GPRS_R5_HEADER_COMPRESSION,EDbColUint32, 0, KDefaultColumnWidth},

	{GPRS_R4_PACKET_FLOW_IDENTIFIER,EDbColUint32, 0, KDefaultColumnWidth},

	{GPRS_UMTS_GPRS_RELEASE,EDbColUint32, 0, KDefaultColumnWidth},

	{0}

	};

TColumn const KGPRSQoSR99Table[]=	

	{

	{GPRS_QOS_REQ_TRAFFIC_CLASS, EDbColUint32, 0, KDefaultColumnWidth},	

	{GPRS_QOS_MIN_TRAFFIC_CLASS, EDbColUint32, 0, KDefaultColumnWidth},           	

	{GPRS_QOS_REQ_DELIVERY_ORDER, EDbColUint32, 0, KDefaultColumnWidth},			

	{GPRS_QOS_MIN_DELIVERY_ORDER, EDbColUint32, 0, KDefaultColumnWidth},			

	{GPRS_QOS_REQ_DELIVER_ERRONEOUS_SDU, EDbColUint32, 0, KDefaultColumnWidth},	

	{GPRS_QOS_MIN_DELIVER_ERRONEOUS_SDU, EDbColUint32, 0, KDefaultColumnWidth},	

	{GPRS_QOS_REQ_MAX_SDUSIZE, EDbColInt32, 0, KDefaultColumnWidth}, 			

	{GPRS_QOS_MIN_ACCEPTABLE_MAX_SDU_SIZE, EDbColInt32, 0, KDefaultColumnWidth},

	{GPRS_QOS_REQ_MAX_UPLINK_RATE, EDbColInt32, 0, KDefaultColumnWidth},     		

	{GPRS_QOS_REQ_MIN_UPLINK_RATE, EDbColInt32, 0, KDefaultColumnWidth},			

	{GPRS_QOS_REQ_MAX_DOWNLINK_RATE, EDbColInt32, 0, KDefaultColumnWidth},		

	{GPRS_QOS_REQ_MIN_DOWNLINK_RATE, EDbColInt32, 0, KDefaultColumnWidth},		

	{GPRS_QOS_REQ_BER, EDbColUint32, 0, KDefaultColumnWidth},						

	{GPRS_QOS_MAX_BER, EDbColUint32, 0, KDefaultColumnWidth},						

	{GPRS_QOS_REQ_SDU_ERROR_RATIO, EDbColUint32, 0, KDefaultColumnWidth},		

	{GPRS_QOS_MAX_SDU_ERROR_RATIO, EDbColUint32, 0, KDefaultColumnWidth},		

	{GPRS_QOS_REQ_TRAFFIC_HANDLING_PRIORITY, EDbColUint32, 0, KDefaultColumnWidth},

	{GPRS_QOS_MIN_TRAFFIC_HANDLING_PRIORITY, EDbColUint32, 0, KDefaultColumnWidth},

	{GPRS_QOS_REQ_TRANSFER_DELAY, EDbColInt32, 0, KDefaultColumnWidth}, 			

	{GPRS_QOS_MAX_TRANSFER_DELAY, EDbColInt32, 0, KDefaultColumnWidth},			

	{GPRS_QOS_REQ_GUARANTEED_UPLINK_RATE, EDbColInt32, 0, KDefaultColumnWidth},	

	{GPRS_QOS_MIN_GUARANTEED_UPLINK_RATE, EDbColInt32, 0, KDefaultColumnWidth},	

	{GPRS_QOS_REQ_GUARANTEED_DOWNLINK_RATE, EDbColInt32, 0, KDefaultColumnWidth},

	{GPRS_QOS_MIN_GUARANTEED_DOWNLINK_RATE, EDbColInt32, 0, KDefaultColumnWidth},

	{GPRS_QOS_SIGNALLING_INDICATION, EDbColBit, 0, KDefaultColumnWidth},		

	{GPRS_QOS_IM_CN_SIGNALLING_INDICATOR, EDbColBit, 0, KDefaultColumnWidth},

	{GPRS_QOS_SOURCE_STATISTICS_DESCRIPTOR, EDbColUint32, 0, KDefaultColumnWidth},

	{0}

	};

/**

@internalComponent

*/

TColumn const KLANServiceTable[]=

	{

	{COMMDB_ID,EDbColUint32,TDbCol::EAutoIncrement|TDbCol::ENotNull, KDefaultColumnWidth},

	{COMMDB_NAME,EDbColText,TDbCol::ENotNull, KDefaultTextColumnWidth},

	{COMMDB_HIDDEN,EDbColBit,TDbCol::ENotNull, KDefaultColumnWidth},

	{COMMDB_READ_ONLY,EDbColBit,TDbCol::ENotNull, KDefaultColumnWidth},

	{LAN_IF_NETWORKS,EDbColText,0, KDefaultTextColumnWidth},

	//

	{LAN_IP_NETMASK,EDbColText,0, KDefaultTextColumnWidth},

	{LAN_IP_GATEWAY,EDbColText,0, KDefaultTextColumnWidth},

	{LAN_IP_ADDR_FROM_SERVER,EDbColBit,TDbCol::ENotNull, KDefaultColumnWidth},

	{LAN_IP_ADDR,EDbColText,0, KDefaultTextColumnWidth},

	{LAN_IP_DNS_ADDR_FROM_SERVER,EDbColBit,TDbCol::ENotNull, KDefaultColumnWidth},

	{LAN_IP_NAME_SERVER1,EDbColText,0, KDefaultTextColumnWidth},

	{LAN_IP_NAME_SERVER2,EDbColText,0, KDefaultTextColumnWidth},

	//

	{LAN_IP6_DNS_ADDR_FROM_SERVER,EDbColBit,0, KDefaultColumnWidth},

	{LAN_IP6_NAME_SERVER1,EDbColText,0, KDefaultTextColumnWidth},

	{LAN_IP6_NAME_SERVER2,EDbColText,0, KDefaultTextColumnWidth},

	{LAN_IP_ADDR_LEASE_VALID_FROM,EDbColText,0, KDefaultTextColumnWidth},

	{LAN_IP_ADDR_LEASE_VALID_TO,EDbColText,0, KDefaultTextColumnWidth},

	{LAN_CONFIG_DAEMON_MANAGER_NAME,EDbColText,0, KDefaultTextColumnWidth}, 

	{LAN_CONFIG_DAEMON_NAME,EDbColText,0, KDefaultTextColumnWidth}, 

	{LAN_SERVICE_EXTENSION_TABLE_NAME,EDbColText,0, KDefaultTextColumnWidth},	// LanServiceExtensionTableName

	{LAN_SERVICE_EXTENSION_TABLE_RECORD_ID,EDbColUint32,0, KDefaultColumnWidth},	// LanServiceExtensionTableRecordId

	{LAN_SERVICE_ENABLE_LLMNR,EDbColBit,0, KDefaultColumnWidth},

	//

	{0}

	};

/**

@internalComponent

*/

TColumn const KPANServiceExtensionsTable[]=

	{

	{COMMDB_ID,EDbColUint32,TDbCol::EAutoIncrement|TDbCol::ENotNull, KDefaultColumnWidth},

	{COMMDB_NAME,EDbColText,TDbCol::ENotNull, KDefaultTextColumnWidth},

	{COMMDB_HIDDEN,EDbColBit,TDbCol::ENotNull, KDefaultColumnWidth},

	{COMMDB_READ_ONLY,EDbColBit,TDbCol::ENotNull, KDefaultColumnWidth},

	//

	{PAN_LOCAL_ROLE,EDbColUint32,TDbCol::ENotNull,KDefaultColumnWidth},

	{PAN_PEER_ROLE,EDbColUint32,TDbCol::ENotNull,KDefaultColumnWidth},

	{PAN_PEER_MAC_ADDRESSES,EDbColText,0,KDefaultTextColumnWidth},

	{PAN_PROMPT_FOR_REMOTE_DEVICES,EDbColBit,TDbCol::ENotNull,KDefaultColumnWidth},

	{PAN_DISABLE_SDP_QUERY,EDbColBit,TDbCol::ENotNull,KDefaultColumnWidth},

	{PAN_ALLOW_INCOMING,EDbColBit,TDbCol::ENotNull,KDefaultColumnWidth},

#ifdef SYMBIAN_NETWORKING_DHCPSERVER

	{PAN_NAP_SERVICE_ENABLED,EDbColUint32,TDbCol::ENotNull,KDefaultColumnWidth},

#endif // SYMBIAN_NETWORKING_DHCPSERVER	

	//

	{0}

	};

/**

@internalComponent

*/

TColumn const KModemTable[]=

	{

	{COMMDB_ID,EDbColUint32,TDbCol::EAutoIncrement|TDbCol::ENotNull, KDefaultColumnWidth},

	{COMMDB_NAME,EDbColText,TDbCol::ENotNull, KDefaultTextColumnWidth},

	{COMMDB_HIDDEN,EDbColBit,TDbCol::ENotNull, KDefaultColumnWidth},

	{COMMDB_READ_ONLY,EDbColBit,TDbCol::ENotNull, KDefaultColumnWidth},

	//

	{MODEM_AGENT,EDbColText,0, KDefaultTextColumnWidth},

	{MODEM_NIF_NAME,EDbColText,0, KDefaultTextColumnWidth},

  	{MODEM_BCA_STACK, EDbColText, 0, KDefaultTextColumnWidth},

	{MODEM_PORT_NAME,EDbColText,0, KDefaultTextColumnWidth},

	{MODEM_CONTROL_CHANNEL_PORT_NAME,EDbColText,0, KDefaultTextColumnWidth},

	{MODEM_TSY_NAME,EDbColText,0, KDefaultTextColumnWidth},

	{MODEM_CSY_NAME,EDbColText,0, KDefaultTextColumnWidth},

	{MODEM_DATA_BITS,EDbColUint8,0, KDefaultColumnWidth},

	{MODEM_STOP_BITS,EDbColUint8,0, KDefaultColumnWidth},

	{MODEM_PARITY,EDbColUint8,0, KDefaultColumnWidth},

	{MODEM_RATE,EDbColUint32,0, KDefaultColumnWidth},

	{MODEM_HANDSHAKING,EDbColUint32,0, KDefaultColumnWidth},

	{MODEM_SPECIAL_RATE,EDbColUint32,0, KDefaultColumnWidth},

	{MODEM_XON_CHAR,EDbColUint8,0, KDefaultColumnWidth},

	{MODEM_XOFF_CHAR,EDbColUint8,0, KDefaultColumnWidth},

	//

	{MODEM_FAX_CLASS_PREF,EDbColUint8,0, KDefaultColumnWidth},

	{MODEM_SPEAKER_PREF,EDbColUint8,0, KDefaultColumnWidth},

	{MODEM_SPEAKER_VOL_PREF,EDbColUint8,0, KDefaultColumnWidth},

	//

	{MODEM_MODEM_INIT_STRING,EDbColText8,0, KDefaultTextColumnWidth},

	{MODEM_DATA_INIT_STRING,EDbColText8,0, KDefaultTextColumnWidth},

	{MODEM_FAX_INIT_STRING,EDbColText8,0, KDefaultTextColumnWidth},

	{MODEM_ISP_INIT_STRING,EDbColText8,0, KDefaultTextColumnWidth},

	//

	{MODEM_DIAL_PAUSE_LENGTH,EDbColText8,0, KDefaultTextColumnWidth},

	{MODEM_CARRIER_TIMEOUT,EDbColText8,0, KDefaultTextColumnWidth},

	{MODEM_AUTO_ANSWER_RING_COUNT,EDbColText8,0, KDefaultTextColumnWidth},

	{MODEM_SPEAKER_VOL_CONTROL_LOW,EDbColText8,0, KDefaultTextColumnWidth},

	{MODEM_SPEAKER_VOL_CONTROL_MEDIUM,EDbColText8,0, KDefaultTextColumnWidth},

	{MODEM_SPEAKER_VOL_CONTROL_HIGH,EDbColText8,0, KDefaultTextColumnWidth},

	{MODEM_SPEAKER_ALWAYS_OFF,EDbColText8,0, KDefaultTextColumnWidth},

	{MODEM_SPEAKER_ON_UNTIL_CARRIER,EDbColText8,0, KDefaultTextColumnWidth},

	{MODEM_SPEAKER_ALWAYS_ON,EDbColText8,0, KDefaultTextColumnWidth},

	{MODEM_SPEAKER_ON_AFTER_DIAL_UNTIL_CARRIER,EDbColText8,0, KDefaultTextColumnWidth},

	{MODEM_DIAL_TONE_WAIT_MODIFIER,EDbColText8,0, KDefaultTextColumnWidth},

	{MODEM_CALL_PROGRESS_1,EDbColText8,0, KDefaultTextColumnWidth},

	{MODEM_CALL_PROGRESS_2,EDbColText8,0, KDefaultTextColumnWidth},

	{MODEM_CALL_PROGRESS_3,EDbColText8,0, KDefaultTextColumnWidth},

	{MODEM_CALL_PROGRESS_4,EDbColText8,0, KDefaultTextColumnWidth},

	{MODEM_ECHO_OFF,EDbColText8,0, KDefaultTextColumnWidth},

	{MODEM_VERBOSE_TEXT,EDbColText8,0, KDefaultTextColumnWidth},

	{MODEM_QUIET_OFF,EDbColText8,0, KDefaultTextColumnWidth},

	{MODEM_QUIET_ON,EDbColText8,0, KDefaultTextColumnWidth},

	{MODEM_DIAL_COMMAND_STATE_MODIFIER,EDbColText8,0, KDefaultTextColumnWidth},

	{MODEM_ON_LINE,EDbColText8,0, KDefaultTextColumnWidth},

	{MODEM_RESET_CONFIGURATION,EDbColText8,0, KDefaultTextColumnWidth},

	{MODEM_RETURN_TO_FACTORY_DEFS,EDbColText8,0, KDefaultTextColumnWidth},

	{MODEM_DCD_ON_DURING_LINK,EDbColText8,0, KDefaultTextColumnWidth},

	{MODEM_DTR_HANG_UP,EDbColText8,0, KDefaultTextColumnWidth},

	{MODEM_DSR_ALWAYS_ON,EDbColText8,0, KDefaultTextColumnWidth},

	{MODEM_RTS_CTS_HANDSHAKE,EDbColText8,0, KDefaultTextColumnWidth},

	{MODEM_XON_XOFF_HANDSHAKE,EDbColText8,0, KDefaultTextColumnWidth},

	{MODEM_ESCAPE_CHARACTER,EDbColText8,0, KDefaultTextColumnWidth},

	{MODEM_ESCAPE_GUARD_PERIOD,EDbColText8,0, KDefaultTextColumnWidth},