/*

* Copyright (c) 2002-2007 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: 

*   numbers.

*

*/

#ifndef LANDMARKDATABASESTRUCTURE_H

#define LANDMARKDATABASESTRUCTURE_H

#include <e32std.h>

const TInt KPosLmSqlStatementMaxLen = 256;

// Common SQL queries

_LIT(KPosLmSqlAll, "*");

_LIT(KPosLmSqlSelect, "SELECT %S FROM %S");

_LIT(KPosLmSqlFindString, "SELECT %S FROM %S WHERE %S='%S'");

_LIT(KPosLmSqlFindInt, "SELECT %S FROM %S WHERE %S=%d");

_LIT(KPosLmSqlFindUint, "SELECT %S FROM %S WHERE %S=%u");

_LIT(KPosLmSqlFind2Uint, "SELECT %S FROM %S WHERE %S=%u AND %S=%u");

_LIT(KPosLmSqlDeleteUint,"DELETE FROM %S WHERE %S=%u");

_LIT(KPosLmSqlDeleteBy2Uint,"DELETE FROM %S WHERE %S=%u AND %S=%u");

_LIT(KPosLmSqlSelectOrderByString, "SELECT %S FROM %S ORDER BY %S");

_LIT(KPosLmSqlDescOrder, " DESC");

// Table names

_LIT(KPosLmLandmarkTable, "lmt_landmark");

_LIT(KPosLmLandmarkFieldTable, "lmt_lmfield");

_LIT(KPosLmCategoryTable, "lmt_cat");

_LIT(KPosLmLandmarkCategoryTable, "lmt_lmcat");

_LIT(KPosLmIconTable, "lmt_icon");

_LIT(KPosLmSettingsTable, "lmt_settings");

_LIT(KPosLmIndexTable, "lmt_index");

// COLUMN NAMES: Landmark table

_LIT(KPosLmLandmarkIdCol, "lmc_lmid");

_LIT(KPosLmLatitudeCol, "lmc_lat");

_LIT(KPosLmLongitudeCol, "lmc_long");

_LIT(KPosLmAltitudeCol, "lmc_alt");

_LIT(KPosLmHorizAccCol, "lmc_hacc");

_LIT(KPosLmVertAccCol, "lmc_vacc");

_LIT(KPosLmCoverageRadiusCol, "lmc_covrad");

_LIT(KPosLmIconIdCol, "lmc_iconid");

_LIT(KPosLmIconPicNrCol, "lmc_iconnr");

_LIT(KPosLmMaskPicNrCol, "lmc_masknr");

_LIT(KPosLmNameCol, "lmc_name");

_LIT(KPosLmNDescCol, "lmc_desc");

// COLUMN NAMES: Landmark Field

// KPosLmLandmarkIdCol declared above

_LIT(KPosLmFieldTypeCol, "lmc_fieldtype");

_LIT(KPosLmFieldStringCol, "lmc_fieldstr");

// COLUMN NAMES: Category table

_LIT(KPosLmCategoryIdCol, "lmc_catid");

_LIT(KPosLmGlobalCategoryIdCol, "lmc_glcatid");

// KPosLmIconIdCol declared above

// KPosLmIconPicNrCol declared above

// KPosLmMaskPicNrCol declared above

_LIT(KPosLmCategoryNameCol, "lmc_catname");

_LIT(KPosLmCategoryNameModifiedCol, "lmc_namemod");

// COLUMN NAMES: Landmark-Category table

// KPosLmLandmarkIdCol declared above

// KPosLmCategoryIdCol declared above

// COLUMN NAMES: Icon table

// KPosLmIconIdCol declared above

_LIT(KPosLmIconPathCol, "lmc_iconpath");

// COLUMN NAMES: Landmark settings table

_LIT(KPosLmLanguageCol, "lmc_language");

_LIT(KPosLmInitFlagCol, "lmc_init");

// COLUMN NAMES: Indexes table

// KPosLmLanguageCol declared above

_LIT(KPosLmTimestampCol, "lmc_time");

_LIT(KPosLmIndexDataCol, "lmc_lmnameindex");

// INDEXES: Landmark table

_LIT(KPosLmLandmarkIdIndex, "lmi_lmid");

// INDEXES: Category table

_LIT(KPosLmCategoryIdIndex, "lmi_catid");

_LIT(KPosLmGlobalCategoryIdIndex, "lmi_glcatid");

_LIT(KPosLmCategoryNameIndex, "lmi_catname");

_LIT(KPosLmCategoryLmIdIndex, "lmi_lmcat_lmid");

// INDEXES: Icon table

_LIT(KPosLmIconIdIndex, "lmi_iconid");

// INDEXES: Landmark Fields table

_LIT(KPosLmFieldsLmIdIndex, "lmi_fields_lmid");

// DATA TYPES

// Tables

enum TPosLmDatabaseTables

    {

    EPosLmLandmarkTable = 1,

    EPosLmLandmarkFieldTable,

    EPosLmCategoryTable,

    EPosLmLandmarkCategoryTable,

    EPosLmIconTable,

    EPosLmEventTable,

    EPosLmSettingsTable,

    EPosLmIndexTable

    };

// Landmark columns

enum TPosLmLandmarkCols

    {

    EPosLmLcLandmarkIdCol = 1,

    EPosLmLcLatitudeCol,

    EPosLmLcLongitudeCol,

    EPosLmLcAltitudeCol,

    EPosLmLcHorizAccCol,

    EPosLmLcVertAccCol,

    EPosLmLcCoverageRadiusCol,

    EPosLmLcIconIdCol,

    EPosLmLcIconPicNrCol,

    EPosLmLcMaskPicNrCol,

    EPosLmLcNameCol,

    EPosLmLcDescriptionCol

    };

// Landmark Field columns

enum TPosLmLandmarkFieldCols

    {

    EPosLmLfcLandmarkIdCol = 1,

    EPosLmLfcFieldTypeCol,

    EPosLmLfcFieldStringCol

    };

// Category columns

enum TPosLmCategoryCols

    {

    EPosLmCcCategoryIdCol = 1,

    EPosLmCcGlobalCategoryIdCol,

    EPosLmCcIconIdCol,

    EPosLmCcIconPicNrCol,

    EPosLmCcMaskPicNrCol,

    EPosLmCcCategoryNameCol,

    EPosLmCcCategoryNameModifiedCol

    };

// Landmark-Category columns

enum TPosLmLandmarkCategoryCols

    {

    EPosLmLccLandmarkIdCol = 1,

    EPosLmLccCategoryIdCol

    };

// Icon columns

enum TPosLmIconCols

    {

    EPosLmIcIconIdCol = 1,

    EPosLmIcIconPathCol

    };

// Settings columns

enum TPosLmSettingsCols

    {

    EPosLmScLanguageCol  = 1,

    EPosLmScInitFlagCol

    };

// Indexes columns

enum TPosLmIndexCols

    {

    EPosLmIncLanguageCol  = 1,

    EPosLmIncTimestampCol,

    EPosLmIncIndexDataCol

    };

#endif // LANDMARKDATABASESTRUCTURE_H