mpxplugins/serviceplugins/collectionplugins/mpxsqlitedbhgplugin/inc/mpxcollectiondbdef.h
branchRCL_3
changeset 26 3de6c4cf6b67
child 27 2cbbefa9af78
equal deleted inserted replaced
25:14979e23cb5e 26:3de6c4cf6b67
       
     1 /*
       
     2 * Copyright (c) 2006 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:  This header file contains macro definitions used by the
       
    15 *                database subsystem.
       
    16 *
       
    17 */
       
    18 
       
    19 #ifndef MPXCOLLECTIONDBDEF_H
       
    20 #define MPXCOLLECTIONDBDEF_H
       
    21 
       
    22 // INCLUDES
       
    23 #include <mmfmeta.h>
       
    24 
       
    25 // CONSTANTS
       
    26 
       
    27 // ================================== DATABASE ================================
       
    28 
       
    29 // Db filename
       
    30 #ifdef ABSTRACTAUDIOALBUM_INCLUDED
       
    31 _LIT(KMCDbFile, "mpxv3_1.db");
       
    32 _LIT(KMCDbFileEMMC, "mpxv3_1i.db");
       
    33 #else 
       
    34 _LIT(KMCDbFile, "mpxv3_1n.db");
       
    35 _LIT(KMCDbFileEMMC, "mpxv3_1in.db");
       
    36 #endif // ABSTRACTAUDIOALBUM_INCLUDED
       
    37 // Collection Db resource file
       
    38 _LIT(KMPXCollectionDbResourceFile,  "mpxcollectiondbhgres.rsc");
       
    39 
       
    40 // == TABLE NAMES =============================================================
       
    41 // The Auxiliary table stores general database metadata
       
    42 _LIT(KMCAuxiliaryTable,             "Auxiliary");
       
    43 // The Music table stores songs information
       
    44 _LIT(KMCMusicTable,                 "Music");
       
    45 // The Playlist table stores playlists information
       
    46 _LIT(KMCPlaylistTable,              "Playlist");
       
    47 // The PlaylistSongs table stores the song instances for each playlist
       
    48 _LIT(KMCPlaylistSongsTable,         "PlaylistSongs");
       
    49 // The PlaylistSongInfo table stores the songs that are included in playlists
       
    50 _LIT(KMCPlaylistSongInfoTable,      "PlaylistSongInfo");
       
    51 // The Artist table stores artist information
       
    52 _LIT(KMCArtistTable,                "Artist");
       
    53 // The Album table stores albums information
       
    54 _LIT(KMCAlbumTable,                 "Album");
       
    55 // The Genre table stores genres information
       
    56 _LIT(KMCGenreTable,                 "Genre");
       
    57 // The Composer table stores composers information
       
    58 _LIT(KMCComposerTable,              "Composer");
       
    59 #ifdef ABSTRACTAUDIOALBUM_INCLUDED
       
    60 // The AbstractAlbum table stores Abstract Album Art information
       
    61 _LIT(KMCAbstractAlbumTable,              "AbstractAlbum");
       
    62 #endif // ABSTRACTAUDIOALBUM_INCLUDED
       
    63 // == Music TABLE FIELDS ======================================================
       
    64 _LIT(KMCMusicUniqueId,          "UniqueId");
       
    65 
       
    66 // From MMF (MmfMeta.h)
       
    67 #define KMCMusicName                KMMFMetaEntrySongTitle           // "title"
       
    68 #define KMCMusicArtist              KMMFMetaEntryArtist              // "artist"
       
    69 #define KMCMusicAlbum               KMMFMetaEntryAlbum               // "album"
       
    70 #define KMCMusicTrackNumber         KMMFMetaEntryAlbumTrack          // "albumtrack"
       
    71 #define KMCMusicGenre               KMMFMetaEntryGenre               // "genre"
       
    72 #define KMCMusicComposer            KMMFMetaEntryComposer            // "composer"
       
    73 #define KMCMusicComment             KMMFMetaEntryComment             // "comment"
       
    74 #define KMCMusicCopyright           KMMFMetaEntryCopyright           // "copyright"
       
    75 #define KMCMusicOrigArtist          KMMFMetaEntryOriginalArtist      // "originalartist"
       
    76 //end of MMF support data
       
    77 
       
    78 // NOTE: Location will store the path without drive letter
       
    79 _LIT(KMCMusicLocation,              "Location");
       
    80 _LIT(KMCMusicDuration,              "Duration");
       
    81 _LIT(KMCMusicReleaseDate,           "ReleaseDate");
       
    82 _LIT(KMCMusicTimeAdded,             "TimeAdded");
       
    83 _LIT(KMCMusicPlayCount,             "PlayCount");
       
    84 _LIT(KMCMusicTimePlayed,            "TimePlayed");
       
    85 _LIT(KMCMusicRating,                "Rating");
       
    86 _LIT(KMCMusicArt,                   "Art");
       
    87 _LIT(KMCMusicDbFlag,                "DbFlag");
       
    88 _LIT(KMCMusicSync,                  "Sync");
       
    89 _LIT(KMCMusicMod,                   "Modified");
       
    90 _LIT(KMCMusicDel,                   "Deleted");
       
    91 _LIT(KMCMusicUrl,                   "Url");
       
    92 _LIT(KMCMusicDRM,                   "DRM");
       
    93 _LIT(KMCMusicLastPlayPosition,      "LastPlayPosition");
       
    94 _LIT(KMCMusicSampleRate,            "SampleRate");
       
    95 _LIT(KMCMusicBitRate,               "BitRate");
       
    96 _LIT(KMCMusicVolumeId,              "VolumeId");
       
    97 
       
    98 // Number of channels: required by MTP to support Play4sure
       
    99 _LIT(KMCMusicNumChannels,           "NumChannels");
       
   100 
       
   101 // Audio Codec: required by MTP to support Play4sure
       
   102 _LIT(KMCMusicCodec,                 "Codec");
       
   103 _LIT(KMCMusicMimeType,              "MimeType");
       
   104 _LIT(KMCMusicMTPDrmStatus,          "MTPDrmStatus");
       
   105 #ifdef ABSTRACTAUDIOALBUM_INCLUDED
       
   106 _LIT(KMCMusicAlbumArtist,           "AlbumArtist");
       
   107 _LIT(KMCMusicContainEmbeddedArt,    "ContainEmbeddedArt");
       
   108 _LIT(KMCMusicAbstractAlbum,         "AbstractAlbum");
       
   109 #endif // ABSTRACTAUDIOALBUM_INCLUDED
       
   110 
       
   111 // == Category TABLE FIELDS ===================================================
       
   112 _LIT(KMCCategoryUniqueId,           "UniqueId");
       
   113 _LIT(KMCCategoryName,               "Name");
       
   114 _LIT(KMCCategorySongCount,          "SongCount");
       
   115 
       
   116 // == Playlist TABLE FIELDS ===================================================
       
   117 _LIT(KMCPlaylistUniqueId,           "UniqueId");
       
   118 _LIT(KMCPlaylistName,               "Name");
       
   119 _LIT(KMCPlaylistUri,                "Uri");
       
   120 _LIT(KMCPlaylistVolumeId,           "VolumeId");
       
   121 _LIT(KMCPlaylistSync,               "Sync");
       
   122 _LIT(KMCPlaylistDbFlag,             "DbFlag");
       
   123 _LIT(KMCPlaylistTime,               "Time");
       
   124 
       
   125 // == PlaylistSongs TABLE FIELDS ==============================================
       
   126 _LIT(KMCPlaylistSongsUniqueId,      "UniqueId");
       
   127 _LIT(KMCPlaylistSongsSongId,        "SongId");
       
   128 _LIT(KMCPlaylistSongsPlaylistId,        "PlaylistId");
       
   129 _LIT(KMCPlaylistSongsOrdinal,   "Ordinal");
       
   130 
       
   131 // == PlaylistSongInfo TABLE FIELDS ===========================================
       
   132 _LIT(KMCPlaylistSongInfoSongId,     "SongId");
       
   133 _LIT(KMCPlaylistSongInfoUri,        "Uri");
       
   134 _LIT(KMCPlaylistSongInfoTitle,      "Title");
       
   135 _LIT(KMCPlaylistSongInfoVolumeId,   "VolumeId");
       
   136 _LIT(KMCPlaylistSongInfoDbFlag,     "DbFlag");
       
   137 
       
   138 // == Album TABLE FIELDS ==============================================
       
   139 _LIT(KMCAlbumArtistName, "ArtistName");
       
   140 // == Auxiliary TABLE FIELDS ==================================================
       
   141 // Version of database
       
   142 // The version integer looks like:
       
   143 // 31     23      15           0 bit
       
   144 // -----------------------------
       
   145 // |Major |Minor  |Build       |
       
   146 // -----------------------------
       
   147 _LIT(KMCAuxVersion,                 "Version");
       
   148 
       
   149 // Last time db was refreshed
       
   150 _LIT(KMCAuxTimeRefresh,             "TimeRefreshed");
       
   151 
       
   152 // Last time db was synced
       
   153 _LIT(KMCAuxTimeSync,                "TimeSynced");
       
   154 
       
   155 // Database Corrupted bit
       
   156 _LIT(KMCMusicCorruptDB,             "Corrupt");
       
   157 
       
   158 // Number of records that have been marked as deleted
       
   159 _LIT(KMCSavedDeletedRecordCount,    "SaveDeletedRecordCount");
       
   160 
       
   161 #endif // MPXCOLLECTIONDBDEF_H
       
   162 
       
   163 // End of File