1 

     2 // Copyright (c) 1997-2009 Nokia Corporation and/or its subsidiary(-ies).

     3 // All rights reserved.

     4 // This component and the accompanying materials are made available

     5 // under the terms of "Eclipse Public License v1.0"

     6 // which accompanies this distribution, and is available

     7 // at the URL "http://www.eclipse.org/legal/epl-v10.html".

     8 //

     9 // Initial Contributors:

    10 // Nokia Corporation - initial contribution.

    11 //

    12 // Contributors:

    13 //

    14 // Description:

    15 // Table definitions

    16 // 

    17 //

    18 

    19 /**

    20  @file

    21  @internalComponent

    22 */

    23 

    24 #ifndef __TABDEF_H__

    25 #define __TABDEF_H__

    26 

    27 #include <e32math.h>

    28 #include <f32file.h>

    29 #include "CDBSTD.H"

    30 

    31 /**

    32 @internalComponent

    33 */

    34 namespace commdb_dll

    35 	{

    36 const TUint KSingleQuoteChar='\'';

    37 

    38 /**

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

    40 @internalComponent

    41 */

    42 CDB_LIT(KGlobalSettings,_GLOBAL_SETTINGS);

    43 CDB_LIT(KConnectionPreferences,_CONNECTION_PREFERENCES);

    44 CDB_LIT(KConnectPrefRanking,_CONNECT_PREF_RANKING);

    45 CDB_LIT(KConnectPrefDirection,_CONNECT_PREF_DIRECTION);

    46 CDB_LIT(KCommDbIntValue, _COMMDB_INT_VALUE);

    47 CDB_LIT(KCommDbTextValue, _COMMDB_TEXT_VALUE);

    48 CDB_LIT(KStartSQLQuery,_SQL_START_SQL_QUERY);

    49 CDB_LIT(KWhereKeyword,_SQL_WHERE_KEYWORD);

    50 CDB_LIT(KAndKeyword,_SQL_AND_KEYWORD);

    51 CDB_LIT(KOrderKeyword,_SQL_ORDER_KEYWORD);

    52 CDB_LIT(KOrderByKeyword, _SQL_ORDER_BY_KEYWORD);

    53 CDB_LIT(KWhereHidden,_SQL_WHERE_HIDDEN);

    54 CDB_LIT(KAndHidden,_SQL_AND_HIDDEN);

    55 CDB_LIT(KWhereIntMatch,_SQL_WHERE_INT_MATCH);

    56 CDB_LIT(KWhereTextMatch,_SQL_WHERE_TEXT_MATCH);

    57 CDB_LIT(KAndIntMatch,_SQL_AND_INT_MATCH) ;

    58 CDB_LIT(KAndTextMatch,_SQL_AND_TEXT_MATCH);

    59 CDB_LIT(KOrTextMatch,_SQL_OR_TEXT_MATCH);

    60 CDB_LIT(KWhereIntGreaterThan,_SQL_WHERE_INT_GREATERTHAN);

    61 

    62 

    63 /**

    64 Default widths for DB columns

    65 @internalComponent

    66 */

    67 const TInt KDefaultColumnWidth = KDbUndefinedLength  ;

    68 const TInt KDefaultTextColumnWidth = 50 ;

    69 

    70 /**

    71 Non-default DB column widths

    72 */

    73 const TInt KAUTH_NAME_FIELD_WIDTH = 255 ;

    74 const TInt KAUTH_PASS_FIELD_WIDTH = 255 ;

    75 

    76 

    77 /**

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

    79 Used during the creation of a new database.

    80 @internalComponent

    81 */

    82 struct TColumn

    83 	{

    84 	const TText* iName;

    85 	TDbColType iType;

    86 	TUint iAttributes;

    87 	TInt iColumnWidth ;

    88 	};

    89 

    90 /**

    91 Specifies the name and columns of a table.

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

    93 @internalComponent

    94 */

    95 struct TTable

    96 	{

    97 	const TText* iName;

    98 	const TColumn* iTable;

    99 	};

   100 

   101 /**

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

   103 Used by `OpenIAPTableViewMatchingBearerSetLC()`.

   104 @internalComponent

   105 */

   106 struct TMapBearerToServiceType

   107 	{

   108 	TCommDbBearer				bearerMask;

   109 	TCommDbConnectionDirection	direction;

   110 	const TText*				serviceType;

   111 	};

   112 

   113 

   114 /**

   115 Table defintions

   116 @internalComponent

   117 */ 

   118 TColumn const KNetworkTable[]=

   119 	{

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

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

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

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

   124 	//

   125 	{HOST_NAME,EDbColText,0, KDefaultTextColumnWidth},

   126 	{0}

   127 	};

   128 

   129 /**

   130 @internalComponent

   131 */

   132 TColumn const KIAPTable[]=

   133 	{

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

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

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

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

   138 	//

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

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

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

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

   143 	

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

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

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

   147 #ifdef SYMBIAN_NETWORKING_UMTSR5

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

   149 #endif //SYMBIAN_NETWORKING_UMTSR5

   150 	//

   151 	{0}

   152 	};

   153 

   154 /**

   155 @internalComponent

   156 */

   157 TColumn const KDialOutISPTable[]=

   158 	{

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

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

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

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

   163 	//

   164 	{ISP_DESCRIPTION,EDbColText,0, KDefaultTextColumnWidth},

   165 	{ISP_TYPE,EDbColUint32,0, KDefaultColumnWidth},

   166 	//

   167 	{ISP_DEFAULT_TEL_NUM,EDbColText,0, KDefaultTextColumnWidth},

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

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

   170 	{ISP_LOGIN_SCRIPT,EDbColLongText,0, KDefaultColumnWidth},

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

   172 	{ISP_LOGIN_NAME,EDbColText,0, KAUTH_NAME_FIELD_WIDTH},

   173 	{ISP_LOGIN_PASS,EDbColText,0, KAUTH_PASS_FIELD_WIDTH},

   174 	{ISP_CHARGECARD,EDbColUint32,0, KDefaultColumnWidth},

   175 	{ISP_DISPLAY_PCT,EDbColBit,0, KDefaultColumnWidth},

   176 	//

   177 	{ISP_IF_PARAMS,EDbColText,0, KDefaultTextColumnWidth},

   178 	{ISP_IF_NETWORKS,EDbColText,0, KDefaultTextColumnWidth},

   179 	//

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

   181 	{ISP_IF_AUTH_NAME,EDbColText,0, KAUTH_NAME_FIELD_WIDTH},

   182 	{ISP_IF_AUTH_PASS,EDbColText,0, KAUTH_PASS_FIELD_WIDTH},

   183 	{ISP_IF_AUTH_RETRIES,EDbColUint32,0, KDefaultColumnWidth},

   184 	{ISP_IF_CALLBACK_ENABLED,EDbColBit,0, KDefaultColumnWidth},

   185 	{ISP_IF_CALLBACK_TYPE,EDbColUint32,0, KDefaultColumnWidth},

   186 	{ISP_IF_CALLBACK_INFO,EDbColText8,0, KDefaultTextColumnWidth},

   187 	{ISP_CALLBACK_TIMEOUT,EDbColUint32,0, KDefaultColumnWidth},

   188 	//

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

   190 	{ISP_IP_ADDR,EDbColText,0, KDefaultTextColumnWidth},

   191 	{ISP_IP_NETMASK,EDbColText,0, KDefaultTextColumnWidth},

   192 	{ISP_IP_GATEWAY,EDbColText,0, KDefaultTextColumnWidth},

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

   194 	{ISP_IP_NAME_SERVER1,EDbColText,0, KDefaultTextColumnWidth},

   195 	{ISP_IP_NAME_SERVER2,EDbColText,0, KDefaultTextColumnWidth},

   196 	

   197 	{ISP_IP6_DNS_ADDR_FROM_SERVER, EDbColBit,0, KDefaultColumnWidth},

   198 	{ISP_IP6_NAME_SERVER1,EDbColText,0, KDefaultTextColumnWidth},

   199 	{ISP_IP6_NAME_SERVER2,EDbColText,0, KDefaultTextColumnWidth},

   200 	

   201 	{ISP_IP_ADDR_LEASE_VALID_FROM,EDbColText,0, KDefaultTextColumnWidth},

   202 	{ISP_IP_ADDR_LEASE_VALID_TO,EDbColText,0, KDefaultTextColumnWidth}, 

   203 	//

   204 	{ISP_CONFIG_DAEMON_MANAGER_NAME,EDbColText,0, KDefaultTextColumnWidth},

   205 	{ISP_CONFIG_DAEMON_NAME,EDbColText,0, KDefaultTextColumnWidth},

   206 	//

   207 	{ISP_ENABLE_IP_HEADER_COMP,EDbColBit,0, KDefaultColumnWidth},

   208 	{ISP_ENABLE_LCP_EXTENSIONS,EDbColBit,0, KDefaultColumnWidth},

   209 	{ISP_DISABLE_PLAIN_TEXT_AUTH,EDbColBit,0, KDefaultColumnWidth},

   210 	{ISP_ENABLE_SW_COMP,EDbColBit,0, KDefaultColumnWidth},

   211 	//

   212 	{ISP_BEARER_NAME,EDbColUint32,0, KDefaultColumnWidth},

   213 	{ISP_BEARER_SPEED,EDbColUint32,0, KDefaultColumnWidth},

   214 	{ISP_BEARER_CE,EDbColUint32,0, KDefaultColumnWidth},

   215 	{ISP_INIT_STRING,EDbColText8,0, KDefaultTextColumnWidth},

   216 	//

   217 	{ISP_BEARER_TYPE,EDbColUint32,0, KDefaultColumnWidth},

   218 	{ISP_CHANNEL_CODING,EDbColUint32,0, KDefaultColumnWidth},

   219 	{ISP_AIUR,EDbColUint32,0, KDefaultColumnWidth},

   220 	{ISP_REQUESTED_TIME_SLOTS,EDbColUint32,0, KDefaultColumnWidth},

   221 	{ISP_MAXIMUM_TIME_SLOTS,EDbColUint32,0, KDefaultColumnWidth},

   222 	//

   223 	/**	new multimode columns */

   224 	{ISP_BEARER_SERVICE,EDbColUint32,0, KDefaultColumnWidth},

   225 	{ISP_BEARER_PROTOCOL,EDbColUint32,0, KDefaultColumnWidth},

   226 	{ISP_RLP_VERSION,EDbColUint32,0, KDefaultColumnWidth},

   227 	{ISP_IWF_TO_MS,EDbColUint32,0, KDefaultColumnWidth},

   228 	{ISP_MS_TO_IWF,EDbColUint32,0, KDefaultColumnWidth},

   229 	{ISP_ACK_TIMER,EDbColUint32,0, KDefaultColumnWidth},

   230 	{ISP_RETRANSMISSION_ATTEMPTS,EDbColUint32,0, KDefaultColumnWidth},

   231 	{ISP_RESEQUENCE_PERIOD,EDbColUint32,0, KDefaultColumnWidth},

   232 	{ISP_V42_COMPRESSION,EDbColUint32,0, KDefaultColumnWidth},

   233 	{ISP_V42_CODEWORDS,EDbColUint32,0, KDefaultColumnWidth},

   234 	{ISP_V42_MAX_LENGTH,EDbColUint32,0, KDefaultColumnWidth},

   235 	{ISP_ASYMMETRY,EDbColUint32,0, KDefaultColumnWidth},

   236 	{ISP_USER_INIT_UPGRADE,EDbColBit,0, KDefaultColumnWidth},

   237 	{ISP_USE_EDGE,EDbColBit,0, KDefaultColumnWidth},

   238 	

   239 	{ISP_IF_SERVER_MODE,EDbColBit,0, KDefaultColumnWidth},

   240 	{ISP_SERVICE_ENABLE_LLMNR,EDbColBit,0, KDefaultColumnWidth},

   241 	{0}

   242 	};

   243 

   244 /**

   245 @internalComponent

   246 */

   247 TColumn const KDialInISPTable[]=

   248 	{

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

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

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

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

   253 	//

   254 	{ISP_DESCRIPTION,EDbColText,0, KDefaultTextColumnWidth},

   255 	{ISP_TYPE,EDbColUint32,0, KDefaultColumnWidth},

   256 	//

   257 	{ISP_USE_LOGIN_SCRIPT,EDbColBit,0, KDefaultColumnWidth},

   258 	{ISP_LOGIN_SCRIPT,EDbColLongText,0, KDefaultColumnWidth},

   259 	//

   260 	{ISP_AUTHENTICATION,EDbColUint32,0, KDefaultColumnWidth},

   261 	{ISP_IF_AUTH_RETRIES,EDbColUint32,0, KDefaultColumnWidth},

   262 	//

   263 	{ISP_IF_PARAMS,EDbColText,0, KDefaultTextColumnWidth},

   264 	{ISP_IF_NETWORKS,EDbColText,0, KDefaultTextColumnWidth},

   265 	//

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

   267 	{ISP_IP_ADDR,EDbColText,0, KDefaultTextColumnWidth},

   268 	{ISP_IP_NETMASK,EDbColText,0, KDefaultTextColumnWidth},

   269 	{ISP_IP_GATEWAY,EDbColText,0, KDefaultTextColumnWidth},

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

   271 	{ISP_IP_NAME_SERVER1,EDbColText,0, KDefaultTextColumnWidth},

   272 	{ISP_IP_NAME_SERVER2,EDbColText,0, KDefaultTextColumnWidth},

   273 	

   274 	{ISP_IP6_DNS_ADDR_FROM_SERVER,EDbColBit,0, KDefaultColumnWidth},

   275 	{ISP_IP6_NAME_SERVER1,EDbColText,0, KDefaultTextColumnWidth},

   276 	{ISP_IP6_NAME_SERVER2,EDbColText,0, KDefaultTextColumnWidth},

   277 	

   278 	//

   279 	{ISP_ENABLE_IP_HEADER_COMP,EDbColBit,0, KDefaultColumnWidth},

   280 	{ISP_ENABLE_LCP_EXTENSIONS,EDbColBit,0, KDefaultColumnWidth},

   281 	{ISP_DISABLE_PLAIN_TEXT_AUTH,EDbColBit,0, KDefaultColumnWidth},

   282 	{ISP_ENABLE_SW_COMP,EDbColBit,0, KDefaultColumnWidth},

   283 	//

   284 	{ISP_BEARER_NAME,EDbColUint32,0, KDefaultColumnWidth},

   285 	{ISP_BEARER_SPEED,EDbColUint32,0, KDefaultColumnWidth},

   286 	{ISP_BEARER_CE,EDbColUint32,0, KDefaultColumnWidth},

   287 	{ISP_INIT_STRING,EDbColText8,0, KDefaultTextColumnWidth},

   288 	{ISP_USE_EDGE,EDbColBit,0, KDefaultColumnWidth},

   289 	//

   290 	{0}

   291 	};

   292 

   293 /**

   294 @internalComponent

   295 */

   296 TColumn const KGPRSTable[]=

   297 	{

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

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

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

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

   302 	

   303 	{GPRS_APN,EDbColLongText,0, KDefaultColumnWidth},

   304 	//

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

   306 	{GPRS_PDP_ADDRESS,EDbColText,0, KDefaultTextColumnWidth},

   307 	//

   308 	{GPRS_REQ_PRECEDENCE,EDbColUint32,0, KDefaultColumnWidth},

   309 	{GPRS_REQ_DELAY,EDbColUint32,0, KDefaultColumnWidth},

   310 	{GPRS_REQ_RELIABILITY,EDbColUint32,0, KDefaultColumnWidth},

   311 	{GPRS_REQ_PEAK_THROUGHPUT,EDbColUint32,0, KDefaultColumnWidth},

   312 	{GPRS_REQ_MEAN_THROUGHPUT,EDbColUint32,0, KDefaultColumnWidth},

   313 	//

   314 	{GPRS_MIN_PRECEDENCE,EDbColUint32,0, KDefaultColumnWidth},

   315 	{GPRS_MIN_DELAY,EDbColUint32,0, KDefaultColumnWidth},

   316 	{GPRS_MIN_RELIABILITY,EDbColUint32,0, KDefaultColumnWidth},

   317 	{GPRS_MIN_PEAK_THROUGHPUT,EDbColUint32,0, KDefaultColumnWidth},

   318 	{GPRS_MIN_MEAN_THROUGHPUT,EDbColUint32,0, KDefaultColumnWidth},

   319 	//

   320 	{GPRS_DATA_COMPRESSION,EDbColBit,0, KDefaultColumnWidth},

   321 	{GPRS_HEADER_COMPRESSION,EDbColBit,0, KDefaultColumnWidth},

   322 	{GPRS_USE_EDGE, EDbColBit, 0, KDefaultColumnWidth},

   323 	//

   324 	{GPRS_ANONYMOUS_ACCESS,EDbColBit,0, KDefaultColumnWidth},

   325 	//

   326 	{GPRS_IF_PARAMS,EDbColText,0, KDefaultTextColumnWidth},

   327 	{GPRS_IF_NETWORKS,EDbColText,0, KDefaultTextColumnWidth},

   328 	//

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

   330 	{GPRS_IF_AUTH_NAME,EDbColText,0, KAUTH_NAME_FIELD_WIDTH},

   331 	{GPRS_IF_AUTH_PASS,EDbColText,0, KAUTH_PASS_FIELD_WIDTH},

   332 	//

   333 	{GPRS_IF_AUTH_RETRIES,EDbColUint32,0, KDefaultColumnWidth},

   334 	//

   335 	{GPRS_IP_NETMASK,EDbColText,0, KDefaultTextColumnWidth},

   336 	{GPRS_IP_GATEWAY,EDbColText,0, KDefaultTextColumnWidth},

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

   338 	{GPRS_IP_ADDR,EDbColText,0, KDefaultTextColumnWidth},

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

   340 	{GPRS_IP_NAME_SERVER1,EDbColText,0, KDefaultTextColumnWidth},

   341 	{GPRS_IP_NAME_SERVER2,EDbColText,0, KDefaultTextColumnWidth},

   342 	//

   343 	{GPRS_IP6_DNS_ADDR_FROM_SERVER,EDbColBit,0, KDefaultColumnWidth},

   344 	{GPRS_IP6_NAME_SERVER1,EDbColText,0, KDefaultTextColumnWidth},

   345 	{GPRS_IP6_NAME_SERVER2,EDbColText,0, KDefaultTextColumnWidth},

   346 	

   347 	{GPRS_IP_ADDR_LEASE_VALID_FROM,EDbColText,0, KDefaultTextColumnWidth},

   348 	{GPRS_IP_ADDR_LEASE_VALID_TO,EDbColText,0, KDefaultTextColumnWidth},

   349 	//

   350 	{GPRS_CONFIG_DAEMON_MANAGER_NAME,EDbColText,0, KDefaultTextColumnWidth},	

   351 	{GPRS_CONFIG_DAEMON_NAME,EDbColText,0, KDefaultTextColumnWidth},

   352 	//

   353 	{GPRS_ENABLE_LCP_EXTENSIONS,EDbColBit,0, KDefaultColumnWidth},

   354 	{GPRS_DISABLE_PLAIN_TEXT_AUTH,EDbColBit,0, KDefaultColumnWidth},

   355 	//

   356 	{GPRS_AP_TYPE,EDbColUint32,0, KDefaultColumnWidth},

   357 	//

   358 	{GPRS_QOS_WARNING_TIMEOUT,EDbColUint32,0, KDefaultColumnWidth},

   359 	{GPRS_SERVICE_ENABLE_LLMNR,EDbColBit,0, KDefaultColumnWidth},

   360 

   361 	{QOS_UMTS_R99_AND_ON_TABLE, EDbColUint32, 0, KDefaultColumnWidth},

   362 	

   363 	{GPRS_R5_DATA_COMPRESSION,EDbColUint32, 0, KDefaultColumnWidth},

   364 	{GPRS_R5_HEADER_COMPRESSION,EDbColUint32, 0, KDefaultColumnWidth},

   365 	{GPRS_R4_PACKET_FLOW_IDENTIFIER,EDbColUint32, 0, KDefaultColumnWidth},

   366 	{GPRS_UMTS_GPRS_RELEASE,EDbColUint32, 0, KDefaultColumnWidth},

   367 

   368 	{0}

   369 	};

   370 

   371 

   372 TColumn const KGPRSQoSR99Table[]=	

   373 	{

   374 	{GPRS_QOS_REQ_TRAFFIC_CLASS, EDbColUint32, 0, KDefaultColumnWidth},	

   375 	{GPRS_QOS_MIN_TRAFFIC_CLASS, EDbColUint32, 0, KDefaultColumnWidth},           	

   376 	{GPRS_QOS_REQ_DELIVERY_ORDER, EDbColUint32, 0, KDefaultColumnWidth},			

   377 	{GPRS_QOS_MIN_DELIVERY_ORDER, EDbColUint32, 0, KDefaultColumnWidth},			

   378 	{GPRS_QOS_REQ_DELIVER_ERRONEOUS_SDU, EDbColUint32, 0, KDefaultColumnWidth},	

   379 	{GPRS_QOS_MIN_DELIVER_ERRONEOUS_SDU, EDbColUint32, 0, KDefaultColumnWidth},	

   380 	{GPRS_QOS_REQ_MAX_SDUSIZE, EDbColInt32, 0, KDefaultColumnWidth}, 			

   381 	{GPRS_QOS_MIN_ACCEPTABLE_MAX_SDU_SIZE, EDbColInt32, 0, KDefaultColumnWidth},

   382 	{GPRS_QOS_REQ_MAX_UPLINK_RATE, EDbColInt32, 0, KDefaultColumnWidth},     		

   383 	{GPRS_QOS_REQ_MIN_UPLINK_RATE, EDbColInt32, 0, KDefaultColumnWidth},			

   384 	{GPRS_QOS_REQ_MAX_DOWNLINK_RATE, EDbColInt32, 0, KDefaultColumnWidth},		

   385 	{GPRS_QOS_REQ_MIN_DOWNLINK_RATE, EDbColInt32, 0, KDefaultColumnWidth},		

   386 	{GPRS_QOS_REQ_BER, EDbColUint32, 0, KDefaultColumnWidth},						

   387 	{GPRS_QOS_MAX_BER, EDbColUint32, 0, KDefaultColumnWidth},						

   388 	{GPRS_QOS_REQ_SDU_ERROR_RATIO, EDbColUint32, 0, KDefaultColumnWidth},		

   389 	{GPRS_QOS_MAX_SDU_ERROR_RATIO, EDbColUint32, 0, KDefaultColumnWidth},		

   390 	{GPRS_QOS_REQ_TRAFFIC_HANDLING_PRIORITY, EDbColUint32, 0, KDefaultColumnWidth},

   391 	{GPRS_QOS_MIN_TRAFFIC_HANDLING_PRIORITY, EDbColUint32, 0, KDefaultColumnWidth},

   392 	{GPRS_QOS_REQ_TRANSFER_DELAY, EDbColInt32, 0, KDefaultColumnWidth}, 			

   393 	{GPRS_QOS_MAX_TRANSFER_DELAY, EDbColInt32, 0, KDefaultColumnWidth},			

   394 	{GPRS_QOS_REQ_GUARANTEED_UPLINK_RATE, EDbColInt32, 0, KDefaultColumnWidth},	

   395 	{GPRS_QOS_MIN_GUARANTEED_UPLINK_RATE, EDbColInt32, 0, KDefaultColumnWidth},	

   396 	{GPRS_QOS_REQ_GUARANTEED_DOWNLINK_RATE, EDbColInt32, 0, KDefaultColumnWidth},

   397 	{GPRS_QOS_MIN_GUARANTEED_DOWNLINK_RATE, EDbColInt32, 0, KDefaultColumnWidth},

   398 	{GPRS_QOS_SIGNALLING_INDICATION, EDbColBit, 0, KDefaultColumnWidth},		

   399 	{GPRS_QOS_IM_CN_SIGNALLING_INDICATOR, EDbColBit, 0, KDefaultColumnWidth},

   400 	{GPRS_QOS_SOURCE_STATISTICS_DESCRIPTOR, EDbColUint32, 0, KDefaultColumnWidth},

   401 	{0}

   402 	};

   403 

   404 /**

   405 @internalComponent

   406 */

   407 TColumn const KLANServiceTable[]=

   408 	{

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

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

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

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

   413 	{LAN_IF_NETWORKS,EDbColText,0, KDefaultTextColumnWidth},

   414 	

   415 	//

   416 	{LAN_IP_NETMASK,EDbColText,0, KDefaultTextColumnWidth},

   417 	{LAN_IP_GATEWAY,EDbColText,0, KDefaultTextColumnWidth},

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

   419 	{LAN_IP_ADDR,EDbColText,0, KDefaultTextColumnWidth},

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

   421 	{LAN_IP_NAME_SERVER1,EDbColText,0, KDefaultTextColumnWidth},

   422 	{LAN_IP_NAME_SERVER2,EDbColText,0, KDefaultTextColumnWidth},

   423 	//

   424 	{LAN_IP6_DNS_ADDR_FROM_SERVER,EDbColBit,0, KDefaultColumnWidth},

   425 	{LAN_IP6_NAME_SERVER1,EDbColText,0, KDefaultTextColumnWidth},

   426 	{LAN_IP6_NAME_SERVER2,EDbColText,0, KDefaultTextColumnWidth},

   427 	

   428 	{LAN_IP_ADDR_LEASE_VALID_FROM,EDbColText,0, KDefaultTextColumnWidth},

   429 	{LAN_IP_ADDR_LEASE_VALID_TO,EDbColText,0, KDefaultTextColumnWidth},

   430 	

   431 	{LAN_CONFIG_DAEMON_MANAGER_NAME,EDbColText,0, KDefaultTextColumnWidth}, 

   432 	{LAN_CONFIG_DAEMON_NAME,EDbColText,0, KDefaultTextColumnWidth}, 

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

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

   435 	{LAN_SERVICE_ENABLE_LLMNR,EDbColBit,0, KDefaultColumnWidth},

   436 	//

   437 	{0}

   438 	};

   439 

   440 /**

   441 @internalComponent

   442 */

   443 TColumn const KPANServiceExtensionsTable[]=

   444 	{

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

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

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

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

   449 

   450 	//

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

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

   453 	{PAN_PEER_MAC_ADDRESSES,EDbColText,0,KDefaultTextColumnWidth},

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

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

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

   457 #ifdef SYMBIAN_NETWORKING_DHCPSERVER

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

   459 #endif // SYMBIAN_NETWORKING_DHCPSERVER	

   460 	//

   461 	{0}

   462 	};

   463 

   464 /**

   465 @internalComponent

   466 */

   467 TColumn const KModemTable[]=

   468 	{

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

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

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

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

   473 	//

   474 	{MODEM_AGENT,EDbColText,0, KDefaultTextColumnWidth},

   475 	{MODEM_NIF_NAME,EDbColText,0, KDefaultTextColumnWidth},

   476   	{MODEM_BCA_STACK, EDbColText, 0, KDefaultTextColumnWidth},

   477 	{MODEM_PORT_NAME,EDbColText,0, KDefaultTextColumnWidth},

   478 	{MODEM_CONTROL_CHANNEL_PORT_NAME,EDbColText,0, KDefaultTextColumnWidth},

   479 	{MODEM_TSY_NAME,EDbColText,0, KDefaultTextColumnWidth},

   480 	{MODEM_CSY_NAME,EDbColText,0, KDefaultTextColumnWidth},

   481 	{MODEM_DATA_BITS,EDbColUint8,0, KDefaultColumnWidth},

   482 	{MODEM_STOP_BITS,EDbColUint8,0, KDefaultColumnWidth},

   483 	{MODEM_PARITY,EDbColUint8,0, KDefaultColumnWidth},

   484 	{MODEM_RATE,EDbColUint32,0, KDefaultColumnWidth},

   485 	{MODEM_HANDSHAKING,EDbColUint32,0, KDefaultColumnWidth},

   486 	{MODEM_SPECIAL_RATE,EDbColUint32,0, KDefaultColumnWidth},

   487 	{MODEM_XON_CHAR,EDbColUint8,0, KDefaultColumnWidth},

   488 	{MODEM_XOFF_CHAR,EDbColUint8,0, KDefaultColumnWidth},

   489 	//

   490 	{MODEM_FAX_CLASS_PREF,EDbColUint8,0, KDefaultColumnWidth},

   491 	{MODEM_SPEAKER_PREF,EDbColUint8,0, KDefaultColumnWidth},

   492 	{MODEM_SPEAKER_VOL_PREF,EDbColUint8,0, KDefaultColumnWidth},

   493 	//

   494 	{MODEM_MODEM_INIT_STRING,EDbColText8,0, KDefaultTextColumnWidth},

   495 	{MODEM_DATA_INIT_STRING,EDbColText8,0, KDefaultTextColumnWidth},

   496 	{MODEM_FAX_INIT_STRING,EDbColText8,0, KDefaultTextColumnWidth},

   497 	{MODEM_ISP_INIT_STRING,EDbColText8,0, KDefaultTextColumnWidth},

   498 	//

   499 	{MODEM_DIAL_PAUSE_LENGTH,EDbColText8,0, KDefaultTextColumnWidth},

   500 	{MODEM_CARRIER_TIMEOUT,EDbColText8,0, KDefaultTextColumnWidth},

   501 	{MODEM_AUTO_ANSWER_RING_COUNT,EDbColText8,0, KDefaultTextColumnWidth},

   502 	{MODEM_SPEAKER_VOL_CONTROL_LOW,EDbColText8,0, KDefaultTextColumnWidth},

   503 	{MODEM_SPEAKER_VOL_CONTROL_MEDIUM,EDbColText8,0, KDefaultTextColumnWidth},

   504 	{MODEM_SPEAKER_VOL_CONTROL_HIGH,EDbColText8,0, KDefaultTextColumnWidth},

   505 	{MODEM_SPEAKER_ALWAYS_OFF,EDbColText8,0, KDefaultTextColumnWidth},

   506 	{MODEM_SPEAKER_ON_UNTIL_CARRIER,EDbColText8,0, KDefaultTextColumnWidth},

   507 	{MODEM_SPEAKER_ALWAYS_ON,EDbColText8,0, KDefaultTextColumnWidth},

   508 	{MODEM_SPEAKER_ON_AFTER_DIAL_UNTIL_CARRIER,EDbColText8,0, KDefaultTextColumnWidth},

   509 	{MODEM_DIAL_TONE_WAIT_MODIFIER,EDbColText8,0, KDefaultTextColumnWidth},

   510 	{MODEM_CALL_PROGRESS_1,EDbColText8,0, KDefaultTextColumnWidth},

   511 	{MODEM_CALL_PROGRESS_2,EDbColText8,0, KDefaultTextColumnWidth},

   512 	{MODEM_CALL_PROGRESS_3,EDbColText8,0, KDefaultTextColumnWidth},

   513 	{MODEM_CALL_PROGRESS_4,EDbColText8,0, KDefaultTextColumnWidth},

   514 	{MODEM_ECHO_OFF,EDbColText8,0, KDefaultTextColumnWidth},

   515 	{MODEM_VERBOSE_TEXT,EDbColText8,0, KDefaultTextColumnWidth},

   516 	{MODEM_QUIET_OFF,EDbColText8,0, KDefaultTextColumnWidth},

   517 	{MODEM_QUIET_ON,EDbColText8,0, KDefaultTextColumnWidth},

   518 	{MODEM_DIAL_COMMAND_STATE_MODIFIER,EDbColText8,0, KDefaultTextColumnWidth},

   519 	{MODEM_ON_LINE,EDbColText8,0, KDefaultTextColumnWidth},

   520 	{MODEM_RESET_CONFIGURATION,EDbColText8,0, KDefaultTextColumnWidth},

   521 	{MODEM_RETURN_TO_FACTORY_DEFS,EDbColText8,0, KDefaultTextColumnWidth},

   522 	{MODEM_DCD_ON_DURING_LINK,EDbColText8,0, KDefaultTextColumnWidth},

   523 	{MODEM_DTR_HANG_UP,EDbColText8,0, KDefaultTextColumnWidth},

   524 	{MODEM_DSR_ALWAYS_ON,EDbColText8,0, KDefaultTextColumnWidth},

   525 	{MODEM_RTS_CTS_HANDSHAKE,EDbColText8,0, KDefaultTextColumnWidth},

   526 	{MODEM_XON_XOFF_HANDSHAKE,EDbColText8,0, KDefaultTextColumnWidth},

   527 	{MODEM_ESCAPE_CHARACTER,EDbColText8,0, KDefaultTextColumnWidth},

   528 	{MODEM_ESCAPE_GUARD_PERIOD,EDbColText8,0, KDefaultTextColumnWidth},

   529 	{MODEM_FAX_CLASS_INTERROGATE,EDbColText8,0, KDefaultTextColumnWidth},

   530 	{MODEM_FAX_CLASS,EDbColText8,0, KDefaultTextColumnWidth},

   531 	//

   532 	{MODEM_NO_DIAL_TONE,EDbColText8,0, KDefaultTextColumnWidth},

   533 	{MODEM_BUSY,EDbColText8,0, KDefaultTextColumnWidth},

   534 	{MODEM_NO_ANSWER,EDbColText8,0, KDefaultTextColumnWidth},

   535 	{MODEM_CARRIER,EDbColText8,0, KDefaultTextColumnWidth},

   536 	{MODEM_CONNECT,EDbColText8,0, KDefaultTextColumnWidth},

   537 	{MODEM_COMPRESSION_CLASS_5,EDbColText8,0, KDefaultTextColumnWidth},

   538 	{MODEM_COMPRESSION_V42BIS,EDbColText8,0, KDefaultTextColumnWidth},

   539 	{MODEM_COMPRESSION_NONE,EDbColText8,0, KDefaultTextColumnWidth},

   540 	{MODEM_PROTOCOL_LAPD,EDbColText8,0, KDefaultTextColumnWidth},

   541 	{MODEM_PROTOCOL_ALT,EDbColText8,0, KDefaultTextColumnWidth},

   542 	{MODEM_PROTOCOL_ALTCELLULAR,EDbColText8,0, KDefaultTextColumnWidth},

   543 	{MODEM_PROTOCOL_NONE,EDbColText8,0, KDefaultTextColumnWidth},

   544 	//

   545 	{MODEM_MESSAGE_CENTRE_NUMBER,EDbColText,0, KDefaultTextColumnWidth},

   546 	{MODEM_MESSAGE_VALIDITY_PERIOD,EDbColUint32,0, KDefaultColumnWidth},

   547 	{MODEM_MESSAGE_DELIVERY_REPORT,EDbColBit,0, KDefaultColumnWidth},

   548 	//

   549 	{MODEM_MIN_SIGNAL_LEVEL,EDbColUint32,0, KDefaultColumnWidth},

   550 	//

   551 	{LAST_SOCKET_ACTIVITY_TIMEOUT,EDbColUint32,0, KDefaultColumnWidth},

   552 	{LAST_SESSION_CLOSED_TIMEOUT,EDbColUint32,0, KDefaultColumnWidth},

   553 	{LAST_SOCKET_CLOSED_TIMEOUT,EDbColUint32,0, KDefaultColumnWidth},

   554 	//

   555 	{MODEM_SIR_SETTINGS,EDbColUint32,0, KDefaultColumnWidth},

   556 	{MODEM_COMM_ROLE,EDbColUint32,0, KDefaultColumnWidth},

   557 	{BEARER_TECHNOLOGY,EDbColUint32,0, KDefaultColumnWidth},

   558 	//

   559 	{0}

   560 	};

   561 

   562 /**

   563 @internalComponent

   564 */

   565 TColumn const KLANBearerTable[]=

   566 	{

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

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

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

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

   571 	//

   572 	{LAN_BEARER_AGENT,EDbColText,TDbCol::ENotNull, KDefaultTextColumnWidth},

   573 	{LAN_BEARER_NIF_NAME,EDbColText,TDbCol::ENotNull, KDefaultTextColumnWidth},

   574 	{LAN_BEARER_LDD_FILENAME,EDbColText,0, KDefaultTextColumnWidth},

   575 	{LAN_BEARER_LDD_NAME,EDbColText,TDbCol::ENotNull, KDefaultTextColumnWidth},

   576 	{LAN_BEARER_PDD_FILENAME,EDbColText,0, KDefaultTextColumnWidth},

   577 	{LAN_BEARER_PDD_NAME,EDbColText,TDbCol::ENotNull, KDefaultTextColumnWidth},

   578 	{LAN_BEARER_PACKET_DRIVER_NAME,EDbColText,0, KDefaultTextColumnWidth},

   579 	{LAST_SOCKET_ACTIVITY_TIMEOUT,EDbColUint32,0, KDefaultColumnWidth},

   580 	{LAST_SESSION_CLOSED_TIMEOUT,EDbColUint32,0, KDefaultColumnWidth},

   581 	{LAST_SOCKET_CLOSED_TIMEOUT,EDbColUint32,0, KDefaultColumnWidth},

   582 	{BEARER_TECHNOLOGY,EDbColUint32,0, KDefaultColumnWidth},

   583 	{0}

   584 	};

   585 

   586 /**

   587 @internalComponent

   588 */   

   589 TColumn const KLocationTable[]=

   590 	{

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

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

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

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

   595 	//

   596 	{LOCATION_INTL_PREFIX_CODE,EDbColText,0, KDefaultTextColumnWidth},

   597 	{LOCATION_NAT_PREFIX_CODE,EDbColText,0, KDefaultTextColumnWidth},

   598 	{LOCATION_NAT_CODE,EDbColText,0, KDefaultTextColumnWidth},

   599 	{LOCATION_AREA_CODE,EDbColText,0, KDefaultTextColumnWidth},

   600 	{LOCATION_DIAL_OUT_CODE,EDbColText,0, KDefaultTextColumnWidth},

   601 	{LOCATION_DISABLE_CALL_WAITING_CODE,EDbColText,0, KDefaultTextColumnWidth},

   602 	{LOCATION_MOBILE,EDbColBit,TDbCol::ENotNull, KDefaultColumnWidth},

   603 	{LOCATION_USE_PULSE_DIAL,EDbColBit,TDbCol::ENotNull, KDefaultColumnWidth},

   604 	{LOCATION_WAIT_FOR_DIAL_TONE,EDbColBit,TDbCol::ENotNull, KDefaultColumnWidth},

   605 	{LOCATION_PAUSE_AFTER_DIAL_OUT,EDbColUint32,TDbCol::ENotNull, KDefaultColumnWidth},

   606 	{0}

   607 	};

   608 

   609 /**

   610 @internalComponent

   611 */

   612 TColumn const KChargecardTable[]=

   613 	{

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

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

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

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

   618 	//

   619 	{CHARGECARD_ACCOUNT_NUMBER,EDbColText,0, KDefaultTextColumnWidth},

   620 	{CHARGECARD_PIN,EDbColText,0, KDefaultTextColumnWidth},

   621 	{CHARGECARD_LOCAL_RULE,EDbColText,0, KDefaultTextColumnWidth},

   622 	{CHARGECARD_NAT_RULE,EDbColText,0, KDefaultTextColumnWidth},

   623 	{CHARGECARD_INTL_RULE,EDbColText,0, KDefaultTextColumnWidth},

   624 	{0}

   625 	};

   626 

   627 /**

   628 @internalComponent

   629 */

   630 TColumn const KProxiesTable[]=

   631 	{

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

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

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

   635 	//

   636 	{PROXY_ISP,EDbColUint32,TDbCol::ENotNull, KDefaultColumnWidth},

   637 	{PROXY_SERVICE_TYPE,EDbColText,0, KDefaultTextColumnWidth},

   638 	{PROXY_USE_PROXY_SERVER,EDbColBit,TDbCol::ENotNull, KDefaultColumnWidth},

   639 	{PROXY_SERVER_NAME,EDbColLongText,0, KDefaultColumnWidth},

   640 	{PROXY_PROTOCOL_NAME,EDbColText,TDbCol::ENotNull, KDefaultTextColumnWidth},

   641 	{PROXY_PORT_NUMBER,EDbColUint32,0, KDefaultColumnWidth},

   642 	{PROXY_EXCEPTIONS,EDbColLongText,0, KDefaultColumnWidth},

   643 	{0}

   644 	};

   645 

   646 /**

   647 @internalComponent

   648 */

   649 TColumn const KWAPAccessPointTable[]=

   650 	{

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

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

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

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

   655 	//

   656 	{WAP_CURRENT_BEARER,EDbColText,TDbCol::ENotNull, KDefaultTextColumnWidth},

   657 	{WAP_START_PAGE,EDbColLongText,0, KDefaultColumnWidth},

   658 	{0}

   659 	};

   660 

   661 /**

   662 @internalComponent

   663 */

   664 TColumn const KWAPIPBearerTable[]=

   665 	{

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

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

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

   669 	//

   670 	{WAP_ACCESS_POINT_ID,EDbColUint32,TDbCol::ENotNull, KDefaultColumnWidth},

   671 	{WAP_GATEWAY_ADDRESS,EDbColText,0, KDefaultTextColumnWidth},

   672 	{WAP_IAP,EDbColUint32,0, KDefaultColumnWidth},

   673 	/**	The following two fields are obsoleted for WAP2.0 but maintained for

   674 	WAP1.0. They should be removed in Symbian OS 8.0 */

   675 	{WAP_WSP_OPTION,EDbColUint8,0, KDefaultColumnWidth},

   676 	{WAP_SECURITY,EDbColBit,0, KDefaultColumnWidth},

   677 	//

   678 	{WAP_PROXY_PORT,EDbColUint32,TDbCol::ENotNull, KDefaultColumnWidth},

   679 	{WAP_PROXY_LOGIN_NAME,EDbColText,0, KAUTH_NAME_FIELD_WIDTH},

   680 	{WAP_PROXY_LOGIN_PASS,EDbColText,0, KAUTH_PASS_FIELD_WIDTH},

   681 	//

   682 	{0}

   683 	};

   684 

   685 /**

   686 @internalComponent

   687 */

   688 TColumn const KWAPSMSBearerTable[]=

   689 	{

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

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

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

   693 	//

   694 	{WAP_ACCESS_POINT_ID,EDbColUint32,TDbCol::ENotNull, KDefaultColumnWidth},

   695 	{WAP_GATEWAY_ADDRESS,EDbColText,0, KDefaultTextColumnWidth},

   696 	{WAP_SERVICE_CENTRE_ADDRESS,EDbColText,0, KDefaultTextColumnWidth},

   697 	{WAP_WSP_OPTION,EDbColUint8,0, KDefaultColumnWidth},

   698 	{WAP_SECURITY,EDbColBit,0, KDefaultColumnWidth},

   699 	{0}

   700 	};

   701 

   702 /**

   703 @internalComponent

   704 */

   705 TColumn const KConnectionPreferencesTable[]=

   706 	{

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

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

   709 	//

   710 	{CONNECT_PREF_RANKING,EDbColUint32,0, KDefaultColumnWidth},

   711 	{CONNECT_PREF_DIRECTION,EDbColUint32,0, KDefaultColumnWidth},

   712 	{CONNECT_PREF_BEARER_SET,EDbColUint32,0, KDefaultColumnWidth},

   713 	{CONNECT_PREF_DIALOG_PREF,EDbColUint32,0, KDefaultColumnWidth},

   714 	{CONNECT_PREF_IAP,EDbColUint32,0, KDefaultColumnWidth},

   715 	//

   716 	{0}

   717 	};

   718 

   719 /**

   720 @internalComponent

   721 */

   722 TColumn const KAgentLookup[]=

   723 	{

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

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

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

   727 	{AGENT_FRIENDLY_NAME,EDbColText,TDbCol::ENotNull, KDefaultTextColumnWidth},

   728 	{AGENT_FILENAME,EDbColText,TDbCol::ENotNull, KDefaultTextColumnWidth},

   729 	{0}

   730 	};

   731 

   732 /**

   733 @internalComponent

   734 */

   735 TColumn const KGlobalSettingsTable[]=

   736 	{

   737 	{COMMDB_ID,EDbColUint32,TDbCol::ENotNull, KDefaultColumnWidth},

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

   739 	//

   740 	{COMMDB_INT_VALUE,EDbColUint32,0, KDefaultColumnWidth},

   741 	{COMMDB_TEXT_VALUE,EDbColText,0, KDefaultTextColumnWidth},

   742 	{0}

   743 	};

   744 

   745 /**

   746 @internalComponent

   747 */

   748 TColumn const KDefaultGPRSTable[]=

   749 	{

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

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

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

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

   754 	//

   755 	{DEFAULT_GPRS_USAGE,EDbColUint32,0, KDefaultColumnWidth},

   756 	{DEFAULT_GPRS_APN,EDbColText, 0, KDefaultTextColumnWidth},

   757 	//

   758 	{DEFAULT_GPRS_PDP_TYPE,EDbColUint32,TDbCol::ENotNull, KDefaultColumnWidth},

   759 	{DEFAULT_GPRS_PDP_ADDRESS,EDbColText, 0, KDefaultTextColumnWidth},

   760 	//

   761 	{DEFAULT_GPRS_PRECEDENCE,EDbColUint32,0, KDefaultColumnWidth},

   762 	{DEFAULT_GPRS_DELAY,EDbColUint32,0, KDefaultColumnWidth},

   763 	{DEFAULT_GPRS_RELIABILITY,EDbColUint32,0, KDefaultColumnWidth},

   764 	{DEFAULT_GPRS_PEAK_THROUGHPUT,EDbColUint32,0, KDefaultColumnWidth},

   765 	{DEFAULT_GPRS_MEAN_THROUGHPUT,EDbColUint32,0, KDefaultColumnWidth},

   766 	//

   767 	{DEFAULT_GPRS_MIN_PRECEDENCE,EDbColUint32,0, KDefaultColumnWidth},

   768 	{DEFAULT_GPRS_MIN_DELAY,EDbColUint32,0, KDefaultColumnWidth},

   769 	{DEFAULT_GPRS_MIN_RELIABILITY,EDbColUint32,0, KDefaultColumnWidth},

   770 	{DEFAULT_GPRS_MIN_PEAK_THROUGHPUT,EDbColUint32,0, KDefaultColumnWidth},

   771 	{DEFAULT_GPRS_MIN_MEAN_THROUGHPUT,EDbColUint32,0, KDefaultColumnWidth},

   772 	//

   773 	{DEFAULT_GPRS_DATA_COMPRESSION,EDbColBit,0, KDefaultColumnWidth},

   774 	{DEFAULT_GPRS_HEADER_COMPRESSION,EDbColBit,0, KDefaultColumnWidth},

   775 	{DEFAULT_GPRS_USE_EDGE, EDbColBit, 0, KDefaultColumnWidth},

   776 	//

   777 	{DEFAULT_GPRS_ANONYMOUS_ACCESS,EDbColBit,0, KDefaultColumnWidth},

   778 	//

   779 	{0}

   780 	};

   781 

   782 /**

   783 @internalComponent

   784 */

   785 TColumn const KCBTDeviceTable[]=

   786 	{

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

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

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

   790 	//

   791 	{BT_DEV_ADD,EDbColText8,TDbCol::ENotNull, KDefaultTextColumnWidth},

   792 	{BT_DEV_DFLT_NAME,EDbColLongText16,0, KDefaultColumnWidth},

   793 	{BT_DEV_FRIENDLY_NAME,EDbColLongText16,0, KDefaultColumnWidth},

   794 	{BT_DEVICE_CLASS,EDbColUint32,0, KDefaultColumnWidth},

   795 	{BT_LINKKEY,EDbColText8,0, KDefaultTextColumnWidth},

   796 	{BT_DEVICE_GLOBAL_SECURITY, EDbColUint32,0, KDefaultColumnWidth},

   797 	{BT_DEV_STATE, EDbColUint32, TDbCol::ENotNull, KDefaultColumnWidth},

   798 	/** specific details concerning the juice of each device */

   799 	{BT_PAGE_SCAN_REP_MODE, EDbColUint32, 0, KDefaultColumnWidth}, 

   800 	{BT_PAGE_SCAN_PERIOD_MODE, EDbColUint32, 0, KDefaultColumnWidth}, 

   801 	{BT_PAGE_SCAN_MODE, EDbColUint32, 0, KDefaultColumnWidth}, 

   802 	{BT_SPARE, EDbColUint32, 0, KDefaultColumnWidth}, 

   803 	{BT_CLK_OFFSET, EDbColUint32, 0, KDefaultColumnWidth}, 

   804 	{BT_COD, EDbColUint32, 0, KDefaultColumnWidth}, 

   805 	{0}

   806 	};

   807 

   808 /**

   809 @internalComponent

   810 */

   811 TColumn const KCBTDefaultServiceTable[]=

   812 	{

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

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

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

   816 	//

   817 	{BT_DFLT_SER_NAME,EDbColText16,0, KDefaultTextColumnWidth},

   818 	{BT_DFLT_SER_UUID,EDbColText8,TDbCol::ENotNull, KDefaultTextColumnWidth},

   819 	{BT_DFLT_VIRTUAL_PORT,EDbColUint32,TDbCol::ENotNull, KDefaultColumnWidth},

   820 	{BT_DFLT_DEV_ADD,EDbColText8,TDbCol::ENotNull, KDefaultTextColumnWidth},

   821 	{BT_DFLT_SECURITY_LEVEL,EDbColUint8,0, KDefaultColumnWidth},

   822 	{0}

   823 	};

   824 

   825 /**

   826 @internalComponent

   827 */

   828 TColumn const KCBTSecurityTable[]=

   829 	{

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

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

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

   833 	//

   834 	{BT_DEV_ADD,EDbColText8,TDbCol::ENotNull, KDefaultTextColumnWidth},

   835 	{BT_SEC_DEVICE_SECURITY,EDbColUint32,0, KDefaultColumnWidth},

   836 	{BT_SEC_UID,EDbColUint32,0, KDefaultColumnWidth},

   837 	{0}

   838 	};

   839 

   840 /**

   841 @internalComponent

   842 */

   843 LOCAL_D TColumn const KAccessTypeTable[]=

   844 	{	

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

   846 		//

   847 	{TABLE_ACC_NAME,EDbColText16,TDbCol::ENotNull, KDefaultTextColumnWidth},

   848 	{TABLE_ACC_TYPE,EDbColUint8,0, KDefaultColumnWidth},

   849 	{0}

   850 	};

   851 

   852 

   853 /**

   854 @internalComponent

   855 */

   856 TColumn const KCBTPersistTable[]=

   857 	{

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

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

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

   861 	//

   862 	{BT_PERSIST_COD,EDbColUint32,0 , KDefaultColumnWidth},

   863 	{BT_PERSIST_PAGE_TIMEOUT,EDbColUint32,0, KDefaultColumnWidth},

   864 	{BT_PERSIST_PAGE_SCAN_INTERVAL,EDbColUint32,0, KDefaultColumnWidth},

   865 	{BT_PERSIST_PAGE_SCAN_WINDOW,EDbColUint32,0, KDefaultColumnWidth},

   866 	{BT_PERSIST_INQUIRY_SCAN_INTERVAL,EDbColUint32,0, KDefaultColumnWidth},

   867 	{BT_PERSIST_INQUIRY_SCAN_WINDOW,EDbColUint32,0, KDefaultColumnWidth},

   868 	{BT_PERSIST_HOLD_MODE_ACTIVITY,EDbColUint32,0, KDefaultColumnWidth},

   869 	{BT_PERSIST_SCO_FLOW_CONTROL,EDbColUint32,0, KDefaultColumnWidth},

   870 	{BT_PERSIST_PAGE_SCAN_PERIOD,EDbColUint32,0, KDefaultColumnWidth},

   871 	{BT_PERSIST_PAGE_SCAN_MODE,EDbColUint32,0, KDefaultColumnWidth},

   872 	{BT_PERSIST_POWER_SETTINGS,EDbColUint32,0, KDefaultColumnWidth},

   873 	{BT_PERSIST_SCAN,EDbColUint32,0, KDefaultColumnWidth},

   874 	{BT_PERSIST_LOCAL_NAME,EDbColLongText16,0 , KDefaultColumnWidth},

   875 	{BT_PERSIST_IAC_LAP, EDbColLongText16, 0, KDefaultColumnWidth},

   876 	{BT_PERSIST_STATE, EDbColUint32, TDbCol::ENotNull, KDefaultColumnWidth},

   877 	{0}

   878 	};

   879 

   880 

   881 

   882 /**

   883 @internalComponent

   884 */

   885 TColumn const KSecureSocketTable[]=

   886 	{

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

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

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

   890 	//

   891 	{SS_PROTO_NAME,EDbColText,TDbCol::ENotNull, KDefaultTextColumnWidth},

   892 	{SS_PROTO_LIBRARY,EDbColText,TDbCol::ENotNull, KDefaultTextColumnWidth},

   893 	{0}

   894 	};

   895 

   896 /**

   897 @internalComponent

   898 */

   899 TColumn const KVirtualBearerTable[]=

   900 	{

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

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

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

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

   905 	//

   906 	{VIRTUAL_BEARER_AGENT,EDbColText,TDbCol::ENotNull, KDefaultTextColumnWidth},

   907 	{VIRTUAL_BEARER_NIF,EDbColText,TDbCol::ENotNull, KDefaultColumnWidth},

   908 	{LAST_SOCKET_ACTIVITY_TIMEOUT,EDbColUint32,0, KDefaultColumnWidth},

   909 	{LAST_SESSION_CLOSED_TIMEOUT,EDbColUint32,0, KDefaultColumnWidth},

   910 	{LAST_SOCKET_CLOSED_TIMEOUT,EDbColUint32,0, KDefaultColumnWidth},	

   911 	{BEARER_TECHNOLOGY,EDbColUint32,0, KDefaultColumnWidth},	

   912 	{0}

   913 	};

   914 

   915 /**

   916 @internalComponent

   917 */

   918 TColumn const KVpnServiceTable[]=

   919 	{

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

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

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

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

   924 	//

   925 	{VPN_SERVICE_POLICY,EDbColText,TDbCol::ENotNull, KDefaultColumnWidth},

   926 	{VPN_SERVICE_IAP,EDbColUint32,0, KDefaultColumnWidth},

   927 	{VPN_SERVICE_NETWORKID,EDbColUint32,0, KDefaultColumnWidth},

   928 	{VPN_SERVICE_ENABLE_LLMNR,EDbColBit,0, KDefaultColumnWidth},

   929 	{0}

   930 	};

   931 

   932 /**

   933 @internalComponent

   934 */

   935 TColumn const KWlanServiceExtensionTable[]=

   936 	{

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

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

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

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

   941 	//

   942 	{WLAN_PROFILE,  EDbColText ,  0,  KDefaultColumnWidth},  

   943 	{WLAN_SSID, EDbColText , 0, KDefaultColumnWidth}, 

   944 	{WLAN_ENCRYPTION_STATUS, EDbColBit, 0, KDefaultColumnWidth}, 

   945 	{WLAN_ENCRYPTION_TYPE, EDbColUint32, 0, KDefaultColumnWidth}, 

   946 	{WLAN_DEFAULT_WEP_KEY, EDbColUint32, 0, KDefaultColumnWidth}, 

   947 	{WLAN_ENCRYPT_KEY1_VALID, EDbColBit, 0, KDefaultColumnWidth}, 

   948 	{WLAN_WEP_Key1, EDbColText, 0, KDefaultColumnWidth}, 

   949 	{WLAN_ENCRYPT_KEY2_VALID, EDbColBit, 0, KDefaultColumnWidth}, 

   950 	{WLAN_WEP_KEY2, EDbColText, 0, KDefaultColumnWidth}, 

   951 	{WLAN_ENCRYPT_KEY3_VALID, EDbColBit, 0, KDefaultColumnWidth}, 

   952 	{WLAN_WEP_KEY3, EDbColText, 0, KDefaultColumnWidth}, 

   953 	{WLAN_ENCRYPT_KEY4_VALID, EDbColBit, 0, KDefaultColumnWidth}, 

   954 	{WLAN_WEP_KEY4, EDbColText, 0, KDefaultColumnWidth}, 

   955 	{WLANRANKING, EDbColUint32, 0, KDefaultColumnWidth}, 

   956 	{WLAN_DIALOG_PREF, EDbColUint32, 0, KDefaultColumnWidth}, 

   957 	{WLAN_NETWORK_TYPE, EDbColUint32, 0, KDefaultColumnWidth}, 

   958 	{WLAN_FRAG_THRES, EDbColUint32, 0, KDefaultColumnWidth}, 

   959 	{WLAN_RTS_THRES, EDbColUint32, 0, KDefaultColumnWidth}, 

   960 	{WLAN_DES_TRANS_RATE, EDbColUint32, 0, KDefaultColumnWidth}, 

   961 	{WLAN_BEACON_INT, EDbColUint32, 0, KDefaultColumnWidth}, 

   962 	{WLAN_CHANNEL_ID, EDbColUint32, 0, KDefaultColumnWidth}, 

   963 	{WLAN_AUTHENTICATION_MODE, EDbColUint32, 0, KDefaultColumnWidth}, 

   964 	{WLAN_POWERSAVE_MODE, EDbColUint32, 0, KDefaultColumnWidth}, 

   965 	{WLAN_ALLOW_UNENCRYPT_MODE, EDbColBit, 0, KDefaultColumnWidth}, 

   966 	{WLAN_ALLOW_SHORT_PRE, EDbColBit, 0, KDefaultColumnWidth}, 

   967 	{WLAN_PREAMBLE_TYPE, EDbColUint32, 0, KDefaultColumnWidth}, 

   968 	{WLAN_TX_POWER_LEVEL, EDbColUint32, 0, KDefaultColumnWidth}, 

   969 	{WLAN_EAP_PRESHARED_KEY, EDbColText, 0, KAUTH_PASS_FIELD_WIDTH}, 

   970 	{WLAN_REG_DOMAIN, EDbColUint32, 0, KDefaultColumnWidth}, 

   971 	{WLAN_SEC_DATA, EDbColText,  0,  KDefaultColumnWidth}, 

   972 	{0}

   973 	};

   974 

   975 /**

   976 @internalComponent

   977 */

   978 TColumn const KEAPSecRecord[]=

   979 	{

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

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

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

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

   984 	//

   985 	{EAP_SEC_OUTER_EAP_TYPE, EDbColUint32, 0, KDefaultColumnWidth},

   986 	{EAP_SEC_ID, EDbColText, 0, KDefaultColumnWidth},

   987 	{EAP_SEC_PASSWORD, EDbColText, 0, KDefaultColumnWidth},

   988 	{EAP_SEC_CONFIGID,  EDbColUint32, 0, KDefaultColumnWidth},	

   989 	{EAP_SEC_DATA, EDbColText, 0, KDefaultColumnWidth},

   990     {EAP_SEC_VENDORID,  EDbColText, 0, KDefaultColumnWidth},

   991     {EAP_SEC_VENDORTYPE,  EDbColUint32, 0, KDefaultColumnWidth},

   992 	{0}

   993 	};

   994 	

   995 /**

   996 @internalComponent

   997 */

   998 TColumn const KTunEAPRecord[]=

   999 	{

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

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

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

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

  1004 	//

  1005 	{TUN_EAP_INNERTYPE, EDbColUint32, 0, KDefaultColumnWidth},

  1006 	{TUN_EAP_DATA, EDbColText, 0, KDefaultColumnWidth},

  1007 	{0}

  1008 	};

  1009 

  1010 /**

  1011 @internalComponent

  1012 */

  1013 TColumn const KEAPTLSRecord[]=

  1014 	{

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

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

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

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

  1019 	//

  1020 	{EAP_TLS_CLIENT_CERT_NAME, EDbColText, TDbCol::ENotNull, KDefaultColumnWidth},

  1021 	{0}

  1022 	};

  1023 	

  1024 /**

  1025 @internalComponent

  1026 */

  1027 TColumn const KLEAPRecord[]=

  1028 	{

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

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

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

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

  1033 	//

  1034 	{EAP_LEAP_TIMEOUT,  EDbColUint32, 0, KDefaultColumnWidth},	

  1035 	{0}

  1036 	};

  1037 

  1038 

  1039 /**

  1040 @internalComponent

  1041 */

  1042 TColumn const KEapSimRecord[]=

  1043 	{

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

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

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

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

  1048 	//

  1049 	{EAPSIM_PROTOCOL_ID, EDbColUint32, TDbCol::ENotNull, KDefaultColumnWidth},

  1050 	{EAPSIM_PROTOCOL_PSEUDONYM, EDbColText8, TDbCol::ENotNull, KDefaultTextColumnWidth},

  1051 	{EAPSIM_PROTOCOL_USE_NAI_REALM, EDbColBit,TDbCol::ENotNull, KDefaultColumnWidth},

  1052 	{EAPSIM_PROTOCOL_NAI_REALM, EDbColText8, TDbCol::ENotNull, KDefaultTextColumnWidth},

  1053 	{EAPSIM_PROTOCOL_MIN_RANDS, EDbColUint8,0, KDefaultColumnWidth},

  1054 	{0}

  1055 	};

  1056 

  1057 

  1058 /**

  1059 @internalComponent

  1060 */

  1061 TColumn const KEapAkaRecord[]=

  1062 	{

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

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

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

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

  1067 	//

  1068 	{EAPAKA_PROTOCOL_ID, EDbColUint32, TDbCol::ENotNull, KDefaultColumnWidth},

  1069 	{EAPAKA_PROTOCOL_PSEUDONYM, EDbColText8, TDbCol::ENotNull, KDefaultTextColumnWidth},

  1070 	{EAPAKA_PROTOCOL_USE_NAI_REALM, EDbColBit,TDbCol::ENotNull, KDefaultColumnWidth},

  1071 	{EAPAKA_PROTOCOL_NAI_REALM, EDbColText8, TDbCol::ENotNull, KDefaultTextColumnWidth},

  1072 	{0}

  1073 	};

  1074 

  1075 

  1076 #ifdef SYMBIAN_NON_SEAMLESS_NETWORK_BEARER_MOBILITY

  1077 /**

  1078 @internalComponent

  1079 */

  1080 TColumn const KPolicySelectorRecord[]=

  1081 	{

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

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

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

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

  1086 	//

  1087 	/** Columns of the `PolicySelector Table` */

  1088 	{POLICYID, EDbColUint32, TDbCol::ENotNull, KDefaultColumnWidth},

  1089 	{APPUID, EDbColText8, TDbCol::ENotNull, KDefaultTextColumnWidth},

  1090 	{SRCADDRESS, EDbColText8, TDbCol::ENotNull, KDefaultTextColumnWidth},

  1091 	{SRCMASK, EDbColText8, TDbCol::ENotNull, KDefaultTextColumnWidth},

  1092 	{DSTADDRESS, EDbColText8, TDbCol::ENotNull, KDefaultTextColumnWidth},

  1093 	{DSTMASK, EDbColText8, TDbCol::ENotNull, KDefaultTextColumnWidth},

  1094 	{SRCPORT, EDbColUint32, TDbCol::ENotNull, KDefaultColumnWidth},

  1095 	{DSTPORT, EDbColUint32, TDbCol::ENotNull, KDefaultColumnWidth},

  1096 	{SRCPORTMAX, EDbColUint32, TDbCol::ENotNull, KDefaultColumnWidth},

  1097 	{DSTPORTMAX, EDbColUint32, TDbCol::ENotNull, KDefaultColumnWidth},

  1098 	{PROTOCOLID, EDbColUint32, TDbCol::ENotNull, KDefaultColumnWidth},

  1099 	{IAPID, EDbColUint32, TDbCol::ENotNull, KDefaultColumnWidth},

  1100 	{PRIORITY, EDbColUint32, TDbCol::ENotNull, KDefaultColumnWidth},

  1101 	{0}

  1102 	};

  1103 

  1104 TColumn const KPolicySelector2QoSParametersRecord[]=

  1105 	{

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

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

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

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

  1110 	//

  1111 	/** Columns of the `PolicySelector2Params Table` */

  1112 	{POLICYSELECTORID, EDbColUint32, TDbCol::ENotNull, KDefaultColumnWidth},

  1113 	{PARAMSID, EDbColUint32, TDbCol::ENotNull, KDefaultColumnWidth},

  1114 	{0}

  1115 	};

  1116 

  1117 TColumn const KGenericQoSRecord[]=

  1118 	{

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

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

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

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

  1123 	//

  1124 	/** Columns of the `GenericQos Table` */

  1125 	{DOWNLINKBANDWIDTH, EDbColUint32, TDbCol::ENotNull, KDefaultColumnWidth},

  1126 	{UPLINKBANDWIDTH, EDbColUint32, TDbCol::ENotNull, KDefaultColumnWidth},

  1127 	{DOWNLINKMAXIMUMBURSTSIZE, EDbColUint32, TDbCol::ENotNull, KDefaultColumnWidth},

  1128 	{UPLINKMAXIMUMBURSTSIZE, EDbColUint32, TDbCol::ENotNull, KDefaultColumnWidth},

  1129 	{DOWNLINKAVERAGEPACKETSIZE, EDbColUint32, TDbCol::ENotNull, KDefaultColumnWidth},

  1130 	{UPLINKAVERAGEPACKETSIZE, EDbColUint32, TDbCol::ENotNull, KDefaultColumnWidth},

  1131 	{DOWNLINKMAXIMUMPACKETSIZE, EDbColUint32, TDbCol::ENotNull, KDefaultColumnWidth},

  1132 	{UPLINKMAXIMUMPACKETSIZE, EDbColUint32, TDbCol::ENotNull, KDefaultColumnWidth},

  1133 	{DOWNLINKDELAY, EDbColUint32, TDbCol::ENotNull, KDefaultColumnWidth},

  1134 	{UPLINKDELAY, EDbColUint32, TDbCol::ENotNull, KDefaultColumnWidth},

  1135 	{DOWNLINKDELAYVARIATION, EDbColUint32, TDbCol::ENotNull, KDefaultColumnWidth},