1 /*

     2 * Copyright (c) 2002-2007 Nokia Corporation and/or its subsidiary(-ies). 

     3 * All rights reserved.

     4 * This component and the accompanying materials are made available

     5 * under the terms of "Eclipse Public License v1.0"

     6 * which accompanies this distribution, and is available

     7 * at the URL "http://www.eclipse.org/legal/epl-v10.html".

     8 *

     9 * Initial Contributors:

    10 * Nokia Corporation - initial contribution.

    11 *

    12 * Contributors:

    13 *

    14 * Description: 

    15 *   numbers.

    16 *

    17 */

    18 

    19 

    20 #ifndef LANDMARKDATABASESTRUCTURE_H

    21 #define LANDMARKDATABASESTRUCTURE_H

    22 

    23 #include <e32std.h>

    24 

    25 const TInt KPosLmSqlStatementMaxLen = 256;

    26 

    27 // Common SQL queries

    28 _LIT(KPosLmSqlAll, "*");

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

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

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

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

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

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

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

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

    37 _LIT(KPosLmSqlDescOrder, " DESC");

    38 

    39 // Table names

    40 _LIT(KPosLmLandmarkTable, "lmt_landmark");

    41 _LIT(KPosLmLandmarkFieldTable, "lmt_lmfield");

    42 _LIT(KPosLmCategoryTable, "lmt_cat");

    43 _LIT(KPosLmLandmarkCategoryTable, "lmt_lmcat");

    44 _LIT(KPosLmIconTable, "lmt_icon");

    45 _LIT(KPosLmSettingsTable, "lmt_settings");

    46 _LIT(KPosLmIndexTable, "lmt_index");

    47 

    48 // COLUMN NAMES: Landmark table

    49 _LIT(KPosLmLandmarkIdCol, "lmc_lmid");

    50 _LIT(KPosLmLatitudeCol, "lmc_lat");

    51 _LIT(KPosLmLongitudeCol, "lmc_long");

    52 _LIT(KPosLmAltitudeCol, "lmc_alt");

    53 _LIT(KPosLmHorizAccCol, "lmc_hacc");

    54 _LIT(KPosLmVertAccCol, "lmc_vacc");

    55 _LIT(KPosLmCoverageRadiusCol, "lmc_covrad");

    56 _LIT(KPosLmIconIdCol, "lmc_iconid");

    57 _LIT(KPosLmIconPicNrCol, "lmc_iconnr");

    58 _LIT(KPosLmMaskPicNrCol, "lmc_masknr");

    59 _LIT(KPosLmNameCol, "lmc_name");

    60 _LIT(KPosLmNDescCol, "lmc_desc");

    61 

    62 // COLUMN NAMES: Landmark Field

    63 // KPosLmLandmarkIdCol declared above

    64 _LIT(KPosLmFieldTypeCol, "lmc_fieldtype");

    65 _LIT(KPosLmFieldStringCol, "lmc_fieldstr");

    66 

    67 // COLUMN NAMES: Category table

    68 _LIT(KPosLmCategoryIdCol, "lmc_catid");

    69 _LIT(KPosLmGlobalCategoryIdCol, "lmc_glcatid");

    70 // KPosLmIconIdCol declared above

    71 // KPosLmIconPicNrCol declared above

    72 // KPosLmMaskPicNrCol declared above

    73 _LIT(KPosLmCategoryNameCol, "lmc_catname");

    74 _LIT(KPosLmCategoryNameModifiedCol, "lmc_namemod");

    75 

    76 // COLUMN NAMES: Landmark-Category table

    77 // KPosLmLandmarkIdCol declared above

    78 // KPosLmCategoryIdCol declared above

    79 

    80 // COLUMN NAMES: Icon table

    81 // KPosLmIconIdCol declared above

    82 _LIT(KPosLmIconPathCol, "lmc_iconpath");

    83 

    84 // COLUMN NAMES: Landmark settings table

    85 _LIT(KPosLmLanguageCol, "lmc_language");

    86 _LIT(KPosLmInitFlagCol, "lmc_init");

    87 

    88 // COLUMN NAMES: Indexes table

    89 // KPosLmLanguageCol declared above

    90 _LIT(KPosLmTimestampCol, "lmc_time");

    91 _LIT(KPosLmIndexDataCol, "lmc_lmnameindex");

    92 

    93 // INDEXES: Landmark table

    94 _LIT(KPosLmLandmarkIdIndex, "lmi_lmid");

    95 

    96 // INDEXES: Category table

    97 _LIT(KPosLmCategoryIdIndex, "lmi_catid");

    98 _LIT(KPosLmGlobalCategoryIdIndex, "lmi_glcatid");

    99 _LIT(KPosLmCategoryNameIndex, "lmi_catname");

   100 _LIT(KPosLmCategoryLmIdIndex, "lmi_lmcat_lmid");

   101 

   102 // INDEXES: Icon table

   103 _LIT(KPosLmIconIdIndex, "lmi_iconid");

   104 

   105 // INDEXES: Landmark Fields table

   106 _LIT(KPosLmFieldsLmIdIndex, "lmi_fields_lmid");

   107 

   108 // DATA TYPES

   109 

   110 // Tables

   111 enum TPosLmDatabaseTables

   112     {

   113     EPosLmLandmarkTable = 1,

   114     EPosLmLandmarkFieldTable,

   115     EPosLmCategoryTable,

   116     EPosLmLandmarkCategoryTable,

   117     EPosLmIconTable,

   118     EPosLmEventTable,

   119     EPosLmSettingsTable,

   120     EPosLmIndexTable

   121     };

   122 

   123 // Landmark columns

   124 enum TPosLmLandmarkCols

   125     {

   126     EPosLmLcLandmarkIdCol = 1,

   127     EPosLmLcLatitudeCol,

   128     EPosLmLcLongitudeCol,

   129     EPosLmLcAltitudeCol,

   130     EPosLmLcHorizAccCol,

   131     EPosLmLcVertAccCol,

   132     EPosLmLcCoverageRadiusCol,

   133     EPosLmLcIconIdCol,

   134     EPosLmLcIconPicNrCol,

   135     EPosLmLcMaskPicNrCol,

   136     EPosLmLcNameCol,

   137     EPosLmLcDescriptionCol

   138     };

   139 

   140 // Landmark Field columns

   141 enum TPosLmLandmarkFieldCols

   142     {

   143     EPosLmLfcLandmarkIdCol = 1,

   144     EPosLmLfcFieldTypeCol,

   145     EPosLmLfcFieldStringCol

   146     };

   147 

   148 // Category columns

   149 enum TPosLmCategoryCols

   150     {

   151     EPosLmCcCategoryIdCol = 1,

   152     EPosLmCcGlobalCategoryIdCol,

   153     EPosLmCcIconIdCol,

   154     EPosLmCcIconPicNrCol,

   155     EPosLmCcMaskPicNrCol,

   156     EPosLmCcCategoryNameCol,

   157     EPosLmCcCategoryNameModifiedCol

   158     };

   159 

   160 // Landmark-Category columns

   161 enum TPosLmLandmarkCategoryCols

   162     {

   163     EPosLmLccLandmarkIdCol = 1,

   164     EPosLmLccCategoryIdCol

   165     };

   166 

   167 // Icon columns

   168 enum TPosLmIconCols

   169     {

   170     EPosLmIcIconIdCol = 1,

   171     EPosLmIcIconPathCol

   172     };

   173 

   174 // Settings columns

   175 enum TPosLmSettingsCols

   176     {

   177     EPosLmScLanguageCol  = 1,

   178     EPosLmScInitFlagCol

   179     };

   180 

   181 // Indexes columns

   182 enum TPosLmIndexCols

   183     {

   184     EPosLmIncLanguageCol  = 1,

   185     EPosLmIncTimestampCol,

   186     EPosLmIncIndexDataCol

   187     };

   188 

   189 #endif // LANDMARKDATABASESTRUCTURE_H

   190