/*

* 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 COMMON_H

#define COMMON_H

#include <e32base.h>

_LIT( KBlacklistServerName, "BlacklistServer" );

_LIT( KBlacklistServerExe,  "BlacklistServer.exe" ); // 0x0 2001B2EB = server uid

_LIT( KBlacklistChunkName,  "BlacklistServerChunk" );

const TUid KUidKBlacklistServer = { 0x2001B2EB };  

const TUint KBlacklistServerMajorVersion = 0;

const TUint KBlacklistServerMinorVersion = 1;

const TUint KBlacklistServerBuildVersion = 1;

enum TService

{

    EBlacklistAdd,

    EBlacklistRemove,

    EBlacklistRemoveFromDB,

    EGetBlacklistData,

    EBlacklistCloseDB,

    EMaxService     // Not an actual service

};

// SQL clauses for server

_LIT( KDefaultBlacklistDatabaseFile, "C:[200009fe]blacklistdb.sq" );

_LIT( KMdsBlacklistInsert, "INSERT INTO Blacklist(Modified, Uri, MediaId) VALUES(?, ?, ?);" );

_LIT( KMdsBlacklistUpdate, "UPDATE Blacklist SET Modified = ? WHERE Uri = ? AND MediaId = ?;" );

_LIT( KMdsBlacklistDelete, "DELETE FROM Blacklist WHERE Uri = ? AND MediaId = ?;" );

_LIT( KMdsBlacklistCheck, "SELECT Modified FROM Blacklist WHERE Uri = ? AND MediaId = ?;" );

_LIT( KMdsBlacklistCheckTableExistence, "SELECT COUNT(*) FROM Blacklist;" );

_LIT( KDropBlacklistTable, "DROP TABLE IF EXISTS Blacklist;" );

_LIT( KCreateBlacklistTable, "CREATE TABLE Blacklist(Uri TEXT NOT NULL, MediaId INTEGER NOT NULL, Modified INTEGER NOT NULL, PRIMARY KEY(Uri,MediaId));" );

_LIT( KMdsBlacklistCache, "SELECT Uri, MediaId, Modified FROM Blacklist;" );

#endif

// End of file