--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/landmarks/locationlandmarks/internalservices/inc/EPos_LandmarkDatabaseStructure.h	Tue Feb 02 01:06:48 2010 +0200
@@ -0,0 +1,190 @@
+/*
+* 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
+