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 _LIT(KMCDbFile, "mpxv2_5.db");

    31 

    32 // Collection Db resource file

    33 _LIT(KMPXCollectionDbResourceFile,  "mpxcollectiondbres.rsc");

    34 

    35 // == TABLE NAMES =============================================================

    36 // The Auxiliary table stores general database metadata

    37 _LIT(KMCAuxiliaryTable,             "Auxiliary");

    38 // The Music table stores songs information

    39 _LIT(KMCMusicTable,                 "Music");

    40 // The Playlist table stores playlists information

    41 _LIT(KMCPlaylistTable,              "Playlist");

    42 // The PlaylistSongs table stores the song instances for each playlist

    43 _LIT(KMCPlaylistSongsTable,         "PlaylistSongs");

    44 // The PlaylistSongInfo table stores the songs that are included in playlists

    45 _LIT(KMCPlaylistSongInfoTable,      "PlaylistSongInfo");

    46 // The Artist table stores artist information

    47 _LIT(KMCArtistTable,                "Artist");

    48 // The Album table stores albums information

    49 _LIT(KMCAlbumTable,                 "Album");

    50 // The Genre table stores genres information

    51 _LIT(KMCGenreTable,                 "Genre");

    52 // The Composer table stores composers information

    53 _LIT(KMCComposerTable,              "Composer");

    54 

    55 // == Music TABLE FIELDS ======================================================

    56 _LIT(KMCMusicUniqueId,          "UniqueId");

    57 

    58 // From MMF (MmfMeta.h)

    59 #define KMCMusicName                KMMFMetaEntrySongTitle           // "title"

    60 #define KMCMusicArtist              KMMFMetaEntryArtist              // "artist"

    61 #define KMCMusicAlbum               KMMFMetaEntryAlbum               // "album"

    62 #define KMCMusicTrackNumber         KMMFMetaEntryAlbumTrack          // "albumtrack"

    63 #define KMCMusicGenre               KMMFMetaEntryGenre               // "genre"

    64 #define KMCMusicComposer            KMMFMetaEntryComposer            // "composer"

    65 #define KMCMusicComment             KMMFMetaEntryComment             // "comment"

    66 #define KMCMusicCopyright           KMMFMetaEntryCopyright           // "copyright"

    67 #define KMCMusicOrigArtist          KMMFMetaEntryOriginalArtist      // "originalartist"

    68 //end of MMF support data

    69 

    70 // NOTE: Location will store the path without drive letter

    71 _LIT(KMCMusicLocation,              "Location");

    72 _LIT(KMCMusicDuration,              "Duration");

    73 _LIT(KMCMusicReleaseDate,           "ReleaseDate");

    74 _LIT(KMCMusicTimeAdded,             "TimeAdded");

    75 _LIT(KMCMusicPlayCount,             "PlayCount");

    76 _LIT(KMCMusicTimePlayed,            "TimePlayed");

    77 _LIT(KMCMusicRating,                "Rating");

    78 _LIT(KMCMusicArt,                   "Art");

    79 _LIT(KMCMusicDbFlag,                "DbFlag");

    80 _LIT(KMCMusicSync,                  "Sync");

    81 _LIT(KMCMusicMod,                   "Modified");

    82 _LIT(KMCMusicDel,                   "Deleted");

    83 _LIT(KMCMusicUrl,                   "Url");

    84 _LIT(KMCMusicDRM,                   "DRM");

    85 _LIT(KMCMusicLastPlayPosition,      "LastPlayPosition");

    86 _LIT(KMCMusicSampleRate,            "SampleRate");

    87 _LIT(KMCMusicBitRate,               "BitRate");

    88 _LIT(KMCMusicVolumeId,              "VolumeId");

    89 

    90 // Number of channels: required by MTP to support Play4sure

    91 _LIT(KMCMusicNumChannels,           "NumChannels");

    92 

    93 // Audio Codec: required by MTP to support Play4sure

    94 _LIT(KMCMusicCodec,                 "Codec");

    95 _LIT(KMCMusicMimeType,              "MimeType");

    96 _LIT(KMCMusicMTPDrmStatus,          "MTPDrmStatus");

    97 

    98 // == Category TABLE FIELDS ===================================================

    99 _LIT(KMCCategoryUniqueId,           "UniqueId");

   100 _LIT(KMCCategoryName,               "Name");

   101 _LIT(KMCCategorySongCount,          "SongCount");

   102 

   103 // == Playlist TABLE FIELDS ===================================================

   104 _LIT(KMCPlaylistUniqueId,           "UniqueId");

   105 _LIT(KMCPlaylistName,               "Name");

   106 _LIT(KMCPlaylistUri,                "Uri");

   107 _LIT(KMCPlaylistVolumeId,           "VolumeId");

   108 _LIT(KMCPlaylistSync,               "Sync");

   109 _LIT(KMCPlaylistDbFlag,             "DbFlag");

   110 _LIT(KMCPlaylistTime,               "Time");

   111 

   112 // == PlaylistSongs TABLE FIELDS ==============================================

   113 _LIT(KMCPlaylistSongsUniqueId,      "UniqueId");

   114 _LIT(KMCPlaylistSongsSongId,        "SongId");

   115 _LIT(KMCPlaylistSongsPlaylistId,        "PlaylistId");

   116 _LIT(KMCPlaylistSongsOrdinal,   "Ordinal");

   117 

   118 // == PlaylistSongInfo TABLE FIELDS ===========================================

   119 _LIT(KMCPlaylistSongInfoSongId,     "SongId");

   120 _LIT(KMCPlaylistSongInfoUri,        "Uri");

   121 _LIT(KMCPlaylistSongInfoTitle,      "Title");

   122 _LIT(KMCPlaylistSongInfoVolumeId,   "VolumeId");

   123 _LIT(KMCPlaylistSongInfoDbFlag,     "DbFlag");

   124 

   125 // == Auxiliary TABLE FIELDS ==================================================

   126 // Version of database

   127 // The version integer looks like:

   128 // 31     23      15           0 bit

   129 // -----------------------------

   130 // |Major |Minor  |Build       |

   131 // -----------------------------

   132 _LIT(KMCAuxVersion,                 "Version");

   133 

   134 // Last time db was refreshed

   135 _LIT(KMCAuxTimeRefresh,             "TimeRefreshed");

   136 

   137 // Last time db was synced

   138 _LIT(KMCAuxTimeSync,                "TimeSynced");

   139 

   140 // Database Corrupted bit

   141 _LIT(KMCMusicCorruptDB,             "Corrupt");

   142 

   143 // Number of records that have been marked as deleted

   144 _LIT(KMCSavedDeletedRecordCount,    "SaveDeletedRecordCount");

   145 

   146 #endif // MPXCOLLECTIONDBDEF_H

   147 

   148 // End of File