/*
* 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 HSACTIVITY_H
#define HSACTIVITY_H


const char ActivityOrganization [] = "nokia";

const char ActivityApplication [] = "hsactivitydbserver";

const char ActivityStorageDriver [] = "QSQLITE";

const char ActivityStorageName [] = "ActivitySQLClient";

const char ActivityStorageProperty [] = "activitydatabase";

const char ActivityDefaultStorage [] = "activitydatabase.db";

const char ActivityTableKeyword [] = ":Table";
const char ActivityDataKeyword [] = ":Data";



const char ActivityCreateQuery [] = "CREATE TABLE Activities(" \
                                    "ApplicationId INTEGER NOT NULL," \
                                    "ActivityName TEXT NOT NULL," \
                                    "Data BLOB NOT NULL," \
                                    "PRIMARY KEY ( ApplicationId, ActivityName ) )";

const char ActivityDropQuery [] = "DROP TABLE :Table";

const char ActivitySelectActivityQuery [] = "SELECT ApplicationId FROM Activities WHERE " \
                                            "ApplicationId = :ApplicationId AND " \
                                            "ActivityName = :ActivityName";

const char ActivityUpdateActivityQuery [] = "UPDATE Activities SET Data = :Data WHERE " \
                                            "ApplicationId = :ApplicationId AND " \
                                            "ActivityName = :ActivityName";

const char ActivityInsertActivityQuery [] = "INSERT INTO Activities( ApplicationId, ActivityName, Data ) VALUES " \
                                            "( :ApplicationId, :ActivityName, :Data )";

const char ActivitySelectActiveQuery [] = "SELECT ActivityName FROM Activities WHERE " \
                                          "ApplicationId = :ApplicationId";

const char ActivityActivitiesQuery [] = "SELECT Data FROM Activities";

const char ActivityApplicationActivitiesQuery [] = "SELECT Data FROM Activities " \
                                                   "WHERE ApplicationId = :ApplicationId";

const char ActivityDeleteActivityQuery [] = "DELETE FROM Activities WHERE " \
                                            "ApplicationId = :ApplicationId AND " \
                                            "ActivityName = :ActivityName";

const char ActivityDeleteApplicationActivitiesQuery [] = "DELETE FROM Activities WHERE " \
                                                         "ApplicationId = :ApplicationId";

#endif //HSACTIVITY_H