--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/contentpublishingsrv/contentpublishingutils/contentpublishingmap/inc/cpssqlcommands.h	Thu Dec 17 08:54:17 2009 +0200
@@ -0,0 +1,126 @@
+/*
+* Copyright (c) 2008 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:  
+ *  Version     : %version: 8 % << Don't touch! Updated by Synergy at check-out.
+ *
+*/
+
+
+#ifndef C_CPSSQL_H
+#define C_CPSSQL_H
+
+//Insert Data
+//Update Data
+
+
+_LIT( KSQLUpdate, "UPDATE CP_MAIN_TABLE SET " );
+_LIT( KSQLUpdateData, "Data = :Data " );
+_LIT( KSQLUpdateAction, "Action = :Action " );
+_LIT( KSQLUpdateExpirationDate, "Expiration_date = :Expiration_date " );
+_LIT( KSQLUpdateFlag, "Flag = :Flag " );
+_LIT( KSQLUpdateWhere, "WHERE Id = :Id  " );
+_LIT( KComma, ",  " );
+
+_LIT( KSQLUpdateRegistry, "UPDATE CP_PUBLISHER_TABLE SET " );
+
+_LIT( KSQLInsert,
+    "INSERT INTO CP_MAIN_TABLE (Publisher,Content_type,Content_id,Expiration_date,Access_List,Data,Action) VALUES ( \
+					            :Publisher,\
+                                :Content_type,\
+                                :Content_id,\
+                                :Expiration_date,\
+                                :Access_List,\
+                                :Data,\
+                                :Action )" );
+
+_LIT( KSQLInsertToRegistry,
+    "INSERT INTO CP_PUBLISHER_TABLE (Publisher,Content_type,Content_id,Flag,Access_List,Data,Action) VALUES ( \
+					            :Publisher,\
+                                :Content_type,\
+                                :Content_id,\
+                                :Flag,\
+                                :Access_List,\
+                                :Data,\
+                                :Action )" );
+
+//Delete Data
+_LIT( KSQLDelete, "DELETE FROM CP_MAIN_TABLE" );
+_LIT( KSQLDeleteFromRegistry, "DELETE FROM CP_PUBLISHER_TABLE" );
+
+//Get Data
+_LIT( KSQLGetLastInsertId, "SELECT last_insert_rowid() ");
+
+_LIT( KSQLGetList, 
+    "SELECT Id,Publisher,Content_type,Content_id,Expiration_date,Access_List,Data,Action FROM CP_MAIN_TABLE");
+_LIT( KSQLGetIds,
+    "SELECT Id,Publisher,Content_type,Content_id,Access_List FROM CP_MAIN_TABLE");
+_LIT( KSQLGetIdsRegistry, 
+    "SELECT Id,Publisher,Content_type,Content_id,Access_List,Flag FROM CP_PUBLISHER_TABLE" );
+_LIT( KSQLGetAction, 
+    "SELECT Action FROM CP_MAIN_TABLE WHERE ");
+
+_LIT( KSQLGetListFromRegistry, 
+    "SELECT Id,Publisher,Content_type,Content_id,Access_List,Flag,Data,Action FROM CP_PUBLISHER_TABLE");
+_LIT( KSQLGetIdsFromRegistry, 
+    "SELECT Id,Publisher,Content_type,Content_id FROM CP_PUBLISHER_TABLE");
+_LIT( KSQLGetActionFromRegistry, 
+    "SELECT Id,Action FROM CP_PUBLISHER_TABLE WHERE ");
+
+_LIT( KSQLGetFlag ,"Flag <> 0");
+_LIT( KSQLGetPublisher ,"Publisher = :Publisher");
+_LIT( KSQLGetContentType ,"Content_type = :Content_type");
+_LIT( KSQLGetContentId ,"Content_id = :Content_id");
+_LIT( KSQLGetId ,"Id = :Id");
+_LIT( KAnd," AND ");
+
+_LIT( KSQLFetchId, 
+    "SELECT Id FROM CP_MAIN_TABLE WHERE Publisher =:Publisher AND Content_type=:Content_type AND Content_id =:Content_id");
+_LIT( KSQLFetchIds, 
+    "SELECT Publisher,Content_type,Content_id,Access_List FROM CP_MAIN_TABLE WHERE Id =:Id");
+
+_LIT( KSQLFetchIdFromRegistry,
+    "SELECT Id FROM CP_PUBLISHER_TABLE WHERE Publisher =:Publisher AND Content_type=:Content_type AND Content_id =:Content_id" );
+_LIT( KSQLFetchIdsFromRegistry,
+    "SELECT Publisher,Content_type,Content_id,Access_List FROM CP_PUBLISHER_TABLE WHERE Id =:Id" );
+
+_LIT( KSQLPublisher, ":Publisher" );
+_LIT( KSQLContent_type, ":Content_type" );
+_LIT( KSQLContent_id, ":Content_id" );
+_LIT( KSQLExpiration_date, ":Expiration_date" );
+_LIT( KSQLFlag, ":Flag" );
+_LIT( KSQLData, ":Data" );
+_LIT( KSQLAction, ":Action" );
+_LIT( KSQLAccessList, ":Access_List" );
+_LIT( KSQLId, ":Id" );
+
+_LIT( KSQLOrderRecent, " ORDER BY Id DESC" );
+_LIT( KSQLOrderPublisher, " ORDER BY Publisher" );
+_LIT( KSQLOrderContent, " ORDER BY Content_type" );
+_LIT( KSQLOrderContentId, " ORDER BY Content_id" );
+
+_LIT( KColumnId, "Id" );
+_LIT( KColumnPublisher, "Publisher" );
+_LIT( KColumnContent_type, "Content_type" );
+_LIT( KColumnContent_id, "Content_id" );
+_LIT( KColumnAccessList, "Access_List" );
+_LIT( KColumnExpiration_date, "Expiration_date" );
+_LIT( KColumnFlag, "Flag" );
+_LIT( KColumnData, "Data" );
+_LIT( KColumnAction, "Action" );
+
+_LIT( KWhere, " WHERE ");
+
+_LIT8( KList, "List" );
+
+#endif //C_CPSSQL_H