--- a/contentstorage/castorage/inc/casqlcommands.h	Fri Apr 30 15:22:08 2010 +0300
+++ b/contentstorage/castorage/inc/casqlcommands.h	Fri May 14 17:24:44 2010 +0300
@@ -60,6 +60,9 @@
 (AT_ENTRY_ID, AT_NAME,AT_VALUE) \
 VALUES ( :AT_ENTRY_ID, :AT_NAME, :AT_VALUE )" );
 
+_LIT( KSQLAddLocalization, "INSERT INTO CA_LOCALIZATION_TEXT \
+(LT_TABLE_NAME, LT_ATTRIBUTE_NAME, LT_STRING_ID, LT_QMFILENAME, LT_ROW_ID) \
+VALUES ( :LT_TABLE, :LT_ATTRIBUTE, :LT_STRING, :LT_QMFILENAME, :LT_ROW_ID )" );
 
 //update Data
 _LIT( KSQLUpdateEntry, "UPDATE CA_ENTRY SET " );
@@ -107,6 +110,12 @@
 _LIT( KSQLUpdateProperty, "UPDATE CA_DB_PROPERTIES \
 SET DB_VALUE = :DB_VALUE WHERE DB_PROPERTY = :DB_PROPERTY ");
 
+// Update localization table entry
+
+_LIT( KSQLUpdateLocalization, "UPDATE CA_LOCALIZATION_TEXT SET \
+ LT_STRING_ID = :LT_STRING , LT_QMFILENAME = :LT_QMFILENAME \
+ WHERE LT_TABLE_NAME = :LT_TABLE AND LT_ATTRIBUTE_NAME = :LT_ATTRIBUTE \
+ AND LT_ROW_ID = :LT_ROW_ID" );
 
 //Delete Data
 _LIT( KSQLDeleteLaunch, "DELETE FROM CA_LAUNCH \
@@ -128,13 +137,17 @@
 
 //Get Data
 
+_LIT( KSQLGetLocalizations, "SELECT LOC_TEXT_ID, LT_TABLE_NAME, \
+LT_ATTRIBUTE_NAME, LT_STRING_ID, LT_QMFILENAME, LT_ROW_ID \
+FROM CA_LOCALIZATION_TEXT ORDER BY LT_QMFILENAME" );
+
+_LIT( KSQLGetLocalization, "SELECT LOC_TEXT_ID, LT_TABLE_NAME, \
+LT_ATTRIBUTE_NAME, LT_STRING_ID, LT_QMFILENAME, LT_ROW_ID \
+FROM CA_LOCALIZATION_TEXT WHERE LT_TABLE_NAME = :LT_TABLE \
+AND LT_ATTRIBUTE_NAME = :LT_ATTRIBUTE AND LT_ROW_ID = :LT_ROW_ID" );
+
 //Get all entries from group by Parent_Id
 // %S string of where for flags;
-
-_LIT( KSQLGetLocalizations, "SELECT LOC_TEXT_ID, LT_TABLE_NAME, \
-LT_ATTRIBUTE_NAME, LT_STRING_ID, LT_ROW_ID \
-FROM CA_LOCALIZATION_TEXT" );
-
 _LIT( KSQLGetListByEntryIds, "SELECT ENTRY_ID, EN_TEXT, EN_DESCRIPTION, \
 EN_ROLE, EN_TYPE_NAME, EN_ICON_ID, EN_CREATION_TIME, EN_UID, EN_FLAGS, \
 IC_FILENAME,IC_SKIN_ID,IC_APP_ID \
@@ -312,6 +325,7 @@
 _LIT( KSQLLocTable, ":LT_TABLE" );
 _LIT( KSQLLocAttribute, ":LT_ATTRIBUTE" );
 _LIT( KSQLLocString, ":LT_STRING" );
+_LIT( KSQLLocQmFilename, ":LT_QMFILENAME" );
 _LIT( KSQLLocRowId, ":LT_ROW_ID" );
 
 // columns
@@ -348,6 +362,8 @@
 _LIT( KColumnLocTableName, "LT_TABLE_NAME" );
 _LIT( KColumnLocAttrName,    "LT_ATTRIBUTE_NAME" );
 _LIT( KColumnLocStringId,   "LT_STRING_ID" );
+_LIT( KColumnQmFile,     "LT_QMFILENAME" );
+
 _LIT( KColumnLocRowId,   "LT_ROW_ID" );
 
 _LIT( KColumnDbProperty, "DB_PROPERTY" );