1 /*

     2  * Copyright (c) 2008 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  *

    16  */

    17 

    18 #ifndef C_CASQL_H

    19 #define C_CASQL_H

    20 

    21 //insert Data

    22 

    23 _LIT( KSQLInsertToEntry, "INSERT INTO CA_ENTRY \

    24 (EN_TEXT, EN_DESCRIPTION, EN_ROLE, EN_TYPE_NAME, EN_ICON_ID, \

    25 EN_CREATION_TIME, EN_UID, EN_FLAGS ) \

    26 VALUES ( :EN_TEXT, :EN_DESCRIPTION, :EN_ROLE, :EN_TYPE_NAME, :EN_ICON_ID, \

    27 :EN_CREATION_TIME, :EN_UID, :EN_FLAGS )" );

    28 

    29 _LIT( KSQLInsertToEntryWithoutIcon, "INSERT INTO CA_ENTRY \

    30 (EN_TEXT, EN_DESCRIPTION, EN_ROLE, EN_TYPE_NAME, EN_ICON_ID, \

    31 EN_CREATION_TIME, EN_UID, EN_FLAGS ) \

    32 VALUES ( :EN_TEXT, :EN_DESCRIPTION, :EN_ROLE, :EN_TYPE_NAME, \

    33 NULL, :EN_CREATION_TIME, :EN_UID, :EN_FLAGS )" );

    34 

    35 _LIT( KSQLInsertToEntryUniqueUid, "INSERT INTO CA_ENTRY \

    36 (EN_TEXT, EN_DESCRIPTION, EN_ROLE, EN_TYPE_NAME, EN_ICON_ID, \

    37 EN_CREATION_TIME, EN_FLAGS ) \

    38 VALUES ( :EN_TEXT, :EN_DESCRIPTION, :EN_ROLE, :EN_TYPE_NAME, \

    39 :EN_ICON_ID, :EN_CREATION_TIME, :EN_FLAGS )" );

    40 

    41 _LIT( KSQLInsertToEntryUniqueUidWithoutIcon, "INSERT INTO CA_ENTRY \

    42 (EN_TEXT, EN_DESCRIPTION, EN_ROLE, EN_TYPE_NAME, EN_ICON_ID, \

    43 EN_CREATION_TIME, EN_FLAGS ) \

    44 VALUES ( :EN_TEXT, :EN_DESCRIPTION, :EN_ROLE, :EN_TYPE_NAME, \

    45 NULL, :EN_CREATION_TIME, :EN_FLAGS )" );

    46 

    47 _LIT( KSQLInsertToGroup, "INSERT INTO CA_GROUP_ENTRY \

    48 (GE_GROUP_ID, GE_ENTRY_ID, GE_POSITION) \

    49 VALUES ( :GE_GROUP_ID, :GE_ENTRY_ID, :GE_POSITION )" );

    50 

    51 _LIT( KSQLInsertToIcon, "INSERT INTO CA_ICON \

    52 (IC_FILENAME,IC_BITMAP_ID,IC_MASK_ID,IC_SKINMAJOR_ID,IC_SKINMINOR_ID) \

    53 VALUES ( :IC_FILENAME, :IC_BITMAP_ID, :IC_MASK_ID, \

    54 :IC_SKINMAJOR_ID, :IC_SKINMINOR_ID )" );

    55 

    56 _LIT( KSQLInsertToLaunch, "INSERT INTO CA_LAUNCH \

    57 (LA_ENTRY_ID, LA_LAUNCH_TIME) \

    58 VALUES ( :LA_ENTRY_ID, :LA_LAUNCH_TIME )" );

    59 

    60 _LIT( KSQLInsertToAttribute, "REPLACE INTO CA_ATTRIBUTE \

    61 (AT_ENTRY_ID, AT_NAME,AT_VALUE) \

    62 VALUES ( :AT_ENTRY_ID, :AT_NAME, :AT_VALUE )" );

    63 

    64 

    65 //update Data

    66 _LIT( KSQLUpdateEntry, "UPDATE CA_ENTRY SET " );

    67 _LIT( KSQLUpdateGroup, "UPDATE CA_GROUP_ENTRY SET " );

    68 _LIT( KSQLUpdateIcon, "UPDATE CA_ICON SET " );

    69 _LIT( KSQLUpdateEntryUsedFlag, "UPDATE CA_ENTRY SET \

    70 EN_FLAGS = EN_FLAGS | :EN_FLAGS WHERE ENTRY_ID = :LA_ENTRY_ID");

    71 _LIT( KSQLLocalizeEntry, "UPDATE CA_ENTRY SET \

    72 EN_TEXT = :LT_STRING WHERE ENTRY_ID = :LT_ROW_ID"); // WHERE ENTRY_ID must be changed if an attribute

    73 

    74 _LIT( KSQLUpdatePositionInGroup, "UPDATE CA_GROUP_ENTRY SET \

    75 GE_POSITION = :GE_POSITION WHERE \

    76 GE_ENTRY_ID = :GE_ENTRY_ID AND GE_GROUP_ID = :GE_GROUP_ID" );

    77 

    78 /*

    79 _LIT( KSQLLocalizeEntry, "UPDATE CA_ENTRY SET \

    80 :LT_ATTRIBUTE = :LT_STRING WHERE ENTRY_ID = :LT_ROW_ID"); // WHERE ENTRY_ID must be changed if an attribute

    81 */

    82 //update Entry

    83 _LIT( KSQLUpdateEntryText, "EN_TEXT = :EN_TEXT " );

    84 _LIT( KSQLUpdateEntryDescription, "EN_DESCRIPTION = :EN_DESCRIPTION " );

    85 _LIT( KSQLUpdateEntryRole, "EN_ROLE = :EN_ROLE " );

    86 _LIT( KSQLUpdateEntryTypeName, "EN_TYPE_NAME = :EN_TYPE_NAME " );

    87 _LIT( KSQLUpdateEntryIdIcon, "EN_ICON_ID = :EN_ICON_ID " );

    88 _LIT( KSQLUpdateEntryIdIconNull, "EN_ICON_ID = NULL " );

    89 _LIT( KSQLUpdateEntryCreationTime, "EN_CREATION_TIME = :EN_CREATION_TIME " );

    90 _LIT( KSQLUpdateEntryUid, "EN_UID = :EN_UID " );

    91 _LIT( KSQLUpdateEntryUidNULL, "EN_UID = NULL " );

    92 _LIT( KSQLUpdateEntryFlags, "EN_FLAGS = :EN_FLAGS " );

    93 _LIT( KSQLUpdateWhere, "WHERE ENTRY_ID = :ENTRY_ID " );

    94 

    95 

    96 // Update Icon

    97 _LIT( KSQLUpdateIconId, "ICON_ID = :ICON_ID " );

    98 _LIT( KSQLUpdateIconFileName, "IC_FILENAME = :IC_FILENAME " );

    99 _LIT( KSQLUpdateIconBitmapId, "IC_BITMAP_ID = :IC_BITMAP_ID " );

   100 _LIT( KSQLUpdateIconMaskId, "IC_MASK_ID = :IC_MASK_ID " );

   101 _LIT( KSQLUpdateIconSkinMajorId, "IC_SKINMAJOR_ID = :IC_SKINMAJOR_ID " );

   102 _LIT( KSQLUpdateIconSkinMinorId, "IC_SKINMINOR_ID = :IC_SKINMINOR_ID " );

   103 _LIT( KSQLUpdateIconWhere, "WHERE ICON_ID = :ICON_ID" );

   104 

   105 // Update property

   106 _LIT( KSQLUpdateProperty, "UPDATE CA_DB_PROPERTIES \

   107 SET DB_VALUE = :DB_VALUE WHERE DB_PROPERTY = :DB_PROPERTY ");

   108 

   109 

   110 //Delete Data

   111 _LIT( KSQLDeleteLaunch, "DELETE FROM CA_LAUNCH \

   112 WHERE LA_ENTRY_ID = :ENTRY_ID" );

   113 _LIT( KSQLDeleteOldFromLaunch, "DELETE FROM CA_LAUNCH \

   114 WHERE LA_LAUNCH_TIME < :LA_LAUNCH_TIME" );

   115 _LIT( KSQLDeleteEntryFromGroup, "DELETE FROM CA_GROUP_ENTRY \

   116 WHERE GE_ENTRY_ID = :ENTRY_ID" );

   117 _LIT( KSQLDeleteGroupFromGroup, "DELETE FROM CA_GROUP_ENTRY \

   118 WHERE GE_GROUP_ID = :ENTRY_ID" );

   119 _LIT( KSQLDeleteAttribute, "DELETE FROM CA_ATTRIBUTE \

   120 WHERE AT_ENTRY_ID = :ENTRY_ID" );

   121 _LIT( KSQLDeleteEntry, "DELETE FROM CA_ENTRY \

   122 WHERE ENTRY_ID = :ENTRY_ID" );

   123 _LIT( KSQLDeleteIcon, "DELETE FROM CA_ICON WHERE ICON_ID = :ICON_ID" );

   124 _LIT( KSQLDeleteIconWhereIconId, "DELETE FROM CA_ICON WHERE ICON_ID = " );

   125 

   126 _LIT( KSQLDeleteLocalizationTextWhereEntryId, "DELETE FROM CA_LOCALIZATION_TEXT WHERE LT_ROW_ID = :LT_ROW_ID" );

   127 

   128 //Get Data

   129 

   130 //Get all entries from group by Parent_Id

   131 // %S string of where for flags;

   132 

   133 _LIT( KSQLGetLocalizations, "SELECT LOC_TEXT_ID, LT_TABLE_NAME, \

   134 LT_ATTRIBUTE_NAME, LT_STRING_ID, LT_ROW_ID \

   135 FROM CA_LOCALIZATION_TEXT" );

   136 

   137 _LIT( KSQLGetListByEntryIds, "SELECT ENTRY_ID, EN_TEXT, EN_DESCRIPTION, \

   138 EN_ROLE, EN_TYPE_NAME, EN_ICON_ID, EN_CREATION_TIME, EN_UID, EN_FLAGS, \

   139 IC_FILENAME, IC_BITMAP_ID, IC_MASK_ID, IC_SKINMAJOR_ID, IC_SKINMINOR_ID \

   140 FROM CA_ENTRY LEFT JOIN CA_ICON ON EN_ICON_ID = ICON_ID \

   141 WHERE ENTRY_ID IN ( %S )" );

   142 

   143 _LIT( KSQLGetList, "SELECT ENTRY_ID, EN_TEXT, EN_DESCRIPTION, EN_ROLE, \

   144 EN_TYPE_NAME, EN_ICON_ID, EN_CREATION_TIME, EN_UID, EN_FLAGS, IC_FILENAME, \

   145 IC_BITMAP_ID, IC_MASK_ID, IC_SKINMAJOR_ID, IC_SKINMINOR_ID FROM \

   146 CA_ENTRY LEFT JOIN CA_ICON ON EN_ICON_ID = ICON_ID " );

   147 

   148 _LIT( KSQLGetListByParentId, "SELECT ENTRY_ID, EN_TEXT, EN_DESCRIPTION, \

   149 EN_ROLE, EN_TYPE_NAME, EN_ICON_ID, EN_CREATION_TIME, EN_UID, EN_FLAGS, \

   150 IC_FILENAME, IC_BITMAP_ID, IC_MASK_ID, IC_SKINMAJOR_ID, IC_SKINMINOR_ID, \

   151 GE_GROUP_ID, GE_ENTRY_ID, GE_POSITION FROM CA_ENTRY  \

   152 LEFT JOIN CA_ICON ON EN_ICON_ID = ICON_ID LEFT JOIN CA_GROUP_ENTRY ON \

   153 GE_ENTRY_ID = ENTRY_ID WHERE GE_GROUP_ID = :GE_GROUP_ID %S " );

   154 

   155 //Get all attributes by entry id

   156 //:Entry_Id_List is a list of Integers seperated by commas.

   157 _LIT( KSQLGetAttributesByEntryId, "SELECT \

   158 ATTRIBUTE_ID, AT_ENTRY_ID, AT_NAME, AT_VALUE FROM CA_ATTRIBUTE \

   159 WHERE AT_ENTRY_ID IN ( %S )" );

   160 

   161 //Select most used

   162 // %S - the input table to work on.

   163 _LIT( KSQLGetListByLaunchDataPart1,"SELECT ENTRY_ID, EN_TEXT, \

   164 EN_DESCRIPTION, EN_ROLE, EN_TYPE_NAME, EN_ICON_ID, EN_CREATION_TIME, \

   165 EN_UID, EN_FLAGS, IC_FILENAME, IC_BITMAP_ID, IC_MASK_ID, IC_SKINMAJOR_ID, \

   166 IC_SKINMINOR_ID FROM (");

   167 

   168 // %S - the table to match e.g KSQLGetMostUsed or KSQLGetLastUsed

   169 // The column USAGE_DATA is used to order the items

   170 _LIT( KSQLGetListByLaunchDataPart2,") LEFT JOIN(");

   171 _LIT( KSQLGetListByLaunchDataPart3,") ON ENTRY_ID = LA_ENTRY_ID \

   172 ORDER BY USAGE_DATA");

   173 

   174 _LIT( KSQLGetParentIds,"SELECT GE_GROUP_ID FROM CA_GROUP_ENTRY \

   175 WHERE GE_ENTRY_ID IN ( %S )" );

   176 

   177 _LIT( KSQLNotINIds," AND GE_GROUP_ID NOT IN( %S )" );

   178 

   179 _LIT( KSQLGetIconId,"SELECT ICON_ID AS Data FROM CA_ICON \

   180 WHERE IC_FILENAME = :IC_FILENAME AND \

   181 IC_BITMAP_ID = :IC_BITMAP_ID AND \

   182 IC_MASK_ID = :IC_MASK_ID AND \

   183 IC_SKINMAJOR_ID = :IC_SKINMAJOR_ID AND \

   184 IC_SKINMINOR_ID = :IC_SKINMINOR_ID");

   185 

   186 _LIT( KSQLGetEntryIdFromEntryTable,"SELECT ENTRY_ID AS Data FROM CA_ENTRY \

   187 WHERE ENTRY_ID = :ENTRY_ID");

   188 

   189 _LIT( KSQLGETIconIdFromEntryTable, "SELECT EN_ICON_ID AS Data FROM CA_ENTRY \

   190 WHERE ENTRY_ID = :ENTRY_ID");

   191 

   192 _LIT( KSQLGetIconDataByIdIcon,"SELECT ICON_ID, IC_FILENAME, IC_BITMAP_ID, \

   193 IC_MASK_ID, IC_SKINMAJOR_ID, IC_SKINMINOR_ID \

   194 FROM CA_ICON WHERE ICON_ID = :EN_ICON_ID");

   195 

   196 _LIT( KSQLGetIconsItems,"SELECT ENTRY_ID, EN_TEXT, EN_DESCRIPTION, EN_ROLE, \

   197 EN_TYPE_NAME, EN_ICON_ID, EN_CREATION_TIME, EN_UID, EN_FLAGS, IC_FILENAME, \

   198 IC_BITMAP_ID, IC_MASK_ID, IC_SKINMAJOR_ID, IC_SKINMINOR_ID FROM \

   199 CA_ENTRY LEFT JOIN CA_ICON ON EN_ICON_ID = ICON_ID \

   200 WHERE EN_ICON_ID = :EN_ICON_ID");

   201 

   202 _LIT( KSQLGetMostUsed,"SELECT LA_ENTRY_ID, COUNT(*) AS USAGE_DATA FROM \

   203 CA_LAUNCH GROUP BY LA_ENTRY_ID" );

   204 

   205 _LIT( KSQLGetLastUsed,"SELECT LA_ENTRY_ID, MAX(LA_LAUNCH_TIME) \

   206 AS USAGE_DATA FROM CA_LAUNCH GROUP BY LA_ENTRY_ID" );

   207 

   208 _LIT( KSQLGetProperty, "SELECT DB_VALUE FROM CA_DB_PROPERTIES WHERE DB_PROPERTY = :DB_PROPERTY ");

   209 

   210 

   211 //Organize statements

   212 

   213 _LIT( KSQLOrganizeGetEntryIdCountFromGroup,"SELECT COUNT(GE_ENTRY_ID) \

   214 AS Data FROM CA_GROUP_ENTRY \

   215 WHERE GE_GROUP_ID = :GE_GROUP_ID AND GE_ENTRY_ID IN ( %S ) " );

   216 

   217 //Statement to append the entry to the first available position

   218 _LIT( KSQLOrganizeInsertToGroupBasic,"INSERT INTO CA_GROUP_ENTRY \

   219 (GE_GROUP_ID,GE_ENTRY_ID,GE_POSITION) \

   220 VALUES ( :GE_GROUP_ID, :GE_ENTRY_ID, \

   221 ( SELECT GE_POSITION FROM CA_GROUP_ENTRY \

   222 WHERE GE_ENTRY_ID = :Entry_Id_Before ) ) ");

   223 

   224 _LIT( KSQLOrganizeInsertToGroupPrepend,"INSERT INTO CA_GROUP_ENTRY \

   225 (GE_GROUP_ID,GE_ENTRY_ID,GE_POSITION) \

   226 VALUES ( :GE_GROUP_ID, :GE_ENTRY_ID, 1 ) "); 

   227 

   228 //Statement to append the entry at end of table

   229 _LIT( KSQLOrganizeAppendToGroup,"INSERT INTO CA_GROUP_ENTRY \

   230 (GE_GROUP_ID, GE_ENTRY_ID, GE_POSITION) \

   231 VALUES ( :GE_GROUP_ID, :GE_ENTRY_ID, \

   232 (SELECT MAX(DATA) FROM ( SELECT MAX(GE_POSITION)+ 1 AS DATA FROM \

   233 CA_GROUP_ENTRY WHERE \

   234 GE_GROUP_ID = :GE_GROUP_ID UNION SELECT 1 AS DATA FROM \

   235 CA_GROUP_ENTRY ) ) )");

   236 

   237 _LIT( KSQLOrganizeRemoveEntriesFromGroup,"DELETE FROM CA_GROUP_ENTRY \

   238 WHERE GE_ENTRY_ID IN (%S) AND GE_GROUP_ID = :GE_GROUP_ID");

   239 

   240 //Get Data

   241 _LIT( KSQLGetLastInsertId, "SELECT last_insert_rowid() " );

   242 

   243 _LIT( KSQLGetEntryFlags, " EN_FLAGS = :EN_FLAGS " );

   244 _LIT( KSQLGetEntryTypeName, " EN_TYPE_NAME = :EN_TYPE_NAME " );

   245 _LIT( KSQLGetAttributeName, " AT_NAME = :AT_NAME " );

   246 _LIT( KSQLGetAttributeValue, " AT_VALUE = :AT_VALUE " );

   247 _LIT( KSQLGetEntryRole, " :EN_ROLE | EN_ROLE == :EN_ROLE  " );

   248 _LIT( KSQLGetEntryUid, " EN_UID = :EN_UID " );

   249 _LIT( KSQLGetEntryFlagsOff, " :Flags_off & (~EN_FLAGS) == :Flags_off " );

   250 _LIT( KSQLGetEntryFlagsOn, " :Flags_on & EN_FLAGS == :Flags_on " );

   251 _LIT( KSQLGetEntryTypeNames, " EN_TYPE_NAME IN (%S) " );

   252 _LIT( KSQLGetEntrySortOrder, " ORDER BY :Sort_Type " );

   253 _LIT( KWhere, " WHERE " );

   254 _LIT( KDesc, " DESC " );

   255 _LIT( KAnd, " AND " );

   256 _LIT( KLimit, " LIMIT ");

   257 _LIT( KSingleQuotes, "\'" );

   258 

   259 _LIT( KSQLSortOrderNameAsc, " ORDER BY EN_TEXT ASC" );

   260 _LIT( KSQLSortOrderNameDesc, " ORDER BY EN_TEXT DESC" );

   261 _LIT( KSQLSortOrderCreatedTimestampAsc, " ORDER BY EN_CREATION_TIME ASC" );

   262 _LIT( KSQLSortOrderCreatedTimestampDesc, " ORDER BY EN_CREATION_TIME DESC" );

   263 _LIT( KSQLSortOrderIdAsc, " ORDER BY ENTRY_ID ASC" );

   264 _LIT( KSQLSortOrderIdDesc, " ORDER BY ENTRY_ID DESC" );

   265 _LIT( KSQLSortOrderDefault, " ORDER BY GE_GROUP_ID, GE_POSITION" );

   266 _LIT( KSQLSortOrderDefaultDesc, " ORDER BY GE_GROUP_ID, GE_POSITION DESC" );

   267 

   268 // additional data

   269 _LIT( KSQLEntryId, ":ENTRY_ID" );

   270 _LIT( KSQLEnText, ":EN_TEXT" );

   271 _LIT( KSQLEnDescription, ":EN_DESCRIPTION" );

   272 _LIT( KSQLEnRole, ":EN_ROLE" );

   273 _LIT( KSQLEnTypeName, ":EN_TYPE_NAME" );

   274 _LIT( KSQLEnIdIcon, ":EN_ICON_ID" );

   275 _LIT( KSQLEnCreationTime, ":EN_CREATION_TIME" );

   276 _LIT( KSQLEnUid, ":EN_UID" );

   277 _LIT( KSQLEnFlags, ":EN_FLAGS" );

   278 

   279 _LIT( KSQLGroupEntryId, ":GROUP_ENTRY_ID" );

   280 _LIT( KSQLGEIdGroup, ":GE_GROUP_ID" );

   281 _LIT( KSQLGEEntryId, ":GE_ENTRY_ID" );

   282 _LIT( KSQLGEPosition, ":GE_POSITION" );

   283 

   284 _LIT( KSQLIconId, ":ICON_ID" );

   285 _LIT( KSQLIcFileName, ":IC_FILENAME" );

   286 _LIT( KSQLIcBitmapId, ":IC_BITMAP_ID" );

   287 _LIT( KSQLIcMaskId, ":IC_MASK_ID" );

   288 _LIT( KSQLIcSkinMajorId, ":IC_SKINMAJOR_ID" );

   289 _LIT( KSQLIcSkinMinorId, ":IC_SKINMINOR_ID" );

   290 

   291 _LIT( KSQLLaunchId, ":LAUNCH_ID" );

   292 _LIT( KSQLLaLaunchTime, ":LA_LAUNCH_TIME" );

   293 _LIT( KSQLLaLaunchEntryId, ":LA_ENTRY_ID" );

   294 

   295 _LIT( KSQLAttributeId, ":ATTRIBUTE_ID" );

   296 _LIT( KSQLAttrEntryID, ":AT_ENTRY_ID" );

   297 _LIT( KSQLAttrName, ":AT_NAME" );

   298 _LIT( KSQLAttrValue, ":AT_VALUE" );

   299 

   300 _LIT( KSQLDbProperty, ":DB_PROPERTY");

   301 _LIT( KSQLDbValue, ":DB_VALUE");

   302 

   303 _LIT( KSQLFlagsOn, ":Flags_on" );

   304 _LIT( KSQLFlagsOff, ":Flags_off" );

   305 _LIT( KSQLSortType, ":Sort_Type" );

   306 _LIT( KSQLEntryIdBefore, ":Entry_Id_Before" );

   307 _LIT( KSQLShiftThreshold, ":Shift_Threshold" );

   308 

   309 _LIT( KSQLLocTable, ":LT_TABLE" );

   310 _LIT( KSQLLocAttribute, ":LT_ATTRIBUTE" );

   311 _LIT( KSQLLocString, ":LT_STRING" );

   312 _LIT( KSQLLocRowId, ":LT_ROW_ID" );

   313 

   314 // columns

   315 _LIT( KColumnSingleData, "Data" );

   316 

   317 _LIT( KColumnEntryId, "ENTRY_ID" );

   318 _LIT( KColumnEnText, "EN_TEXT" );

   319 _LIT( KColumnEnDescription, "EN_DESCRIPTION" );

   320 _LIT( KColumnEnRole, "EN_ROLE" );

   321 _LIT( KColumnEnTypeName, "EN_TYPE_NAME" );

   322 _LIT( KColumnEnIdIcon, "EN_ICON_ID" );

   323 _LIT( KColumnEnCreationTime, "EN_CREATION_TIME" );

   324 _LIT( KColumnEnUid, "EN_UID" );

   325 _LIT( KColumnEnFlags, "EN_FLAGS" );

   326 

   327 _LIT( KColumnGroupEntryId, "GROUP_ENTRY_ID" );

   328 _LIT( KColumnGEIdGroup, "GE_GROUP_ID" );

   329 _LIT( KColumnGEPosition, "GE_POSITION" );

   330 

   331 _LIT( KColumnIconId, "ICON_ID" );

   332 _LIT( KColumnIcFileName, "IC_FILENAME" );

   333 _LIT( KColumnIcBitmapId, "IC_BITMAP_ID" );

   334 _LIT( KColumnIcMaskId, "IC_MASK_ID" );

   335 _LIT( KColumnIcSkinMajorId, "IC_SKINMAJOR_ID" );

   336 _LIT( KColumnIcSkinMinorId, "IC_SKINMINOR_ID" );

   337 

   338 _LIT( KColumnLaunchId, "LAUNCH_ID" );

   339 _LIT( KColumnLaLaunchTime, "LA_LAUNCH_TIME" );

   340 

   341 _LIT( KColumnAttributeId, "ATTRIBUTE_ID" );

   342 _LIT( KColumnAttrEntryID, "AT_ENTRY_ID" );

   343 _LIT( KColumnAttrName, "AT_NAME" );

   344 _LIT( KColumnAttrValue, "AT_VALUE" );

   345 

   346 _LIT( KColumnLocTextId, "LOC_TEXT_ID" );

   347 _LIT( KColumnLocTableName, "LT_TABLE_NAME" );

   348 _LIT( KColumnLocAttrName,    "LT_ATTRIBUTE_NAME" );

   349 _LIT( KColumnLocStringId,   "LT_STRING_ID" );

   350 _LIT( KColumnLocRowId,   "LT_ROW_ID" );

   351 

   352 _LIT( KColumnDbProperty, "DB_PROPERTY" );

   353 _LIT( KColumnDbValue, "DB_VALUE" );

   354 

   355 //transaction data

   356 _LIT( KSqlStatementBegin, "BEGIN");

   357 _LIT( KSqlStatementCommit, "COMMIT");

   358 _LIT( KSqlStatementRollback, "ROLLBACK");

   359 

   360 #endif //C_CPSSQL_H