--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/mmappcomponents/harvester/filehandler/inc/mpxdbcommon.h Thu Dec 17 08:55:47 2009 +0200
@@ -0,0 +1,87 @@
+/*
+* Copyright (c) 2006 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: Common Literals for the harvester db
+*
+*/
+
+
+#ifndef MPXDBCOMMON_H
+#define MPXDBCOMMON_H
+
+_LIT( KHarvesterDBPath, "\\private\\101ffca9\\");
+// Harvester db increment 9 v1
+// Please update the increment number for each increment
+// Please update the version number for each schema change
+_LIT( KHarvesterDBName, "harvesterdbv9_5.dat" );
+_LIT( KHarvesterDBPattern, "harvesterdbv*.dat" );
+
+const TInt KDbMaxTableCreationSQLLength = 1024;
+
+// Files table name
+_LIT(KHarvesterMainTable, "Files");
+
+// Column names
+_LIT(KHarPathName, "FilePath" ); // Drive and Folder for an item
+_LIT(KHarFileName, "FileName" ); // File name for an item
+_LIT(KHarLastModTime, "ModTime" ); // Last modified time stamp
+_LIT(KHarCollectionDB, "DBID" ); // Collection database ID
+_LIT(KHarItemDRM, "DRM" ); // DRM file flag
+
+// Column numbers
+const TInt KHarPathNameColumn = 1;
+const TInt KHarFileNameColumn = 2;
+const TInt KHarModTimeColumn = 3;
+const TInt KHarColDBIDColumn = 4;
+const TInt KHarDRMColumn = 5;
+
+// Column types
+_LIT(KHarPathNameType, " LONG VARCHAR");
+_LIT(KHarFileNameType, " LONG VARCHAR");
+_LIT(KHarLastModTimeType, " TIME");
+_LIT(KHarColDBIDType, " INTEGER");
+_LIT(KHarItemDRMType, " BIT");
+
+// AUX table name
+_LIT(KHarvesterAuxTable, "Aux");
+
+// AUX Column names
+_LIT(KAuxVolumeId, "VolumeId");
+_LIT(KAuxVolumeIdType, " UNSIGNED INTEGER");
+
+// AUX Column number
+const TInt KHarAuxVolumeIdColumn = 1;
+
+
+// SQL query strings
+_LIT(KStartCreateTable, "CREATE TABLE ");
+_LIT(KSelectAll, "SELECT * FROM ");
+_LIT(KSelect, "SELECT ");
+_LIT(KUpdate, "UPDATE ");
+_LIT(KDelete, "DELETE ");
+_LIT(KAll, "* ");
+_LIT(KFrom, "FROM ");
+_LIT(KWhere, " WHERE ");
+_LIT(KAnd, " AND ");
+_LIT(KSet, " SET ");
+_LIT(KItemBracket, "'");
+_LIT(KItemHash, "#");
+_LIT(KEquals, " = ");
+_LIT(KOpenBracket, "(");
+_LIT(KCloseBracket, ")");
+_LIT(KCommaSign, ",");
+_LIT(KAuxVolumeIdQuery, "INSERT INTO Aux(VolumeId) VALUES (%u)");
+_LIT(KLike, " LIKE ");
+_LIT(KWildcard, "*");
+_LIT(KOn, "1");
+#endif // MPXDBCOMMON_H
\ No newline at end of file