/*

* 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_ */