--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/onlinesearchproviders/isproviderdbmanager/inc/isproviderdbconstants.h	Tue Jul 06 14:17:22 2010 +0300
@@ -0,0 +1,38 @@
+/*
+* Copyright (c) 2009 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: 
+*
+*/
+
+#ifndef ISPROVIDERDBCONSTANTS_H_
+#define ISPROVIDERDBCONSTANTS_H_
+
+// Database info
+#ifdef __WINSCW__
+const QString databaseName = "c:\\private\\20022f35\\providerdatabase.sq";
+#else
+const QString databaseName = "z:\\private\\20022f35\\providerdatabase.sq";
+#endif
+const QString connectionName = "providerdatabase.sq";
+const QString databaseType = "QSQLITE";
+
+// SQL Queries
+const QString providerQuery = "SELECT p.ProviderId, Name, Description, Iconpath FROM Providers p INNER JOIN CountryProviderMap map ON p.ProviderId = map.ProviderId JOIN Countries ON map.CountryId = Countries.CountryId WHERE Countries.CountryCode = \'";
+const QString selectedProviderQuery = "SELECT ProviderId, Name, Description, Iconpath, ProviderUrl FROM Providers WHERE Selected = 1";
+const QString resetProviderSelection = "UPDATE Providers SET Selected = 0";
+const QString setSelectedProvider = "UPDATE Providers SET Selected = 1 WHERE ProviderId = ";
+const QString countryQuery = "SELECT Country FROM Countries";
+
+
+#endif /* ISPROVIDERDBCONSTANTS_H_ */