/*

* 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