mpxplugins/serviceplugins/collectionplugins/mpxsqlitepodcastdbplugin/inc/mpxpodcastcollectiondbdef.h
changeset 0 ff3acec5bc43
child 40 cb96c29156b2
equal deleted inserted replaced
-1:000000000000 0:ff3acec5bc43
       
     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 database subsystem.
       
    15 *
       
    16 */
       
    17 
       
    18 #ifndef MPXPODCASTCOLLECTIONDBDEF_H
       
    19 #define MPXPODCASTCOLLECTIONDBDEF_H
       
    20 
       
    21 // INCLUDES
       
    22 #include <mmfmeta.h>
       
    23 
       
    24 // CONSTANTS
       
    25 
       
    26 // ================================== DATABASE ================================
       
    27 
       
    28 // Db filename
       
    29 _LIT(KMCDbFile, "pcv6_1.db");
       
    30 
       
    31 // Collection Db resource file
       
    32 _LIT(KMPXCollectionDbResourceFile,  "PCRes.rsc");
       
    33 
       
    34 // == TABLE NAMES ===============================================
       
    35 // The Auxiliary table stores general database metadata like last refresh time etc...
       
    36 _LIT(KMCAuxiliaryTable,         "Auxiliary");
       
    37 // The Podcast table stores information about the episodes stored within the collection
       
    38 _LIT(KMCPodcastTable,           "Podcast");
       
    39 // The author table stores information about the authors of the music stored in the collection
       
    40 _LIT(KMCAuthorTable,            "Artist"); // podcast author = media artist
       
    41 // The Title table stores information about the podcast titles of the episodes stored in the collection
       
    42 _LIT(KMCTitleTable,             "Album");  // podcast title = media album
       
    43 // The Category table stores information about the category of the episodes stored in the collection
       
    44 _LIT(KMCCategoryTable,          "Genre");  // podcast category = media genre
       
    45 // The Composer table stores information about the composer of the episodes stored in the collection
       
    46 _LIT(KMCComposerTable,          "Composer");
       
    47 
       
    48 // == Podcast TABLE FIELDS ======================================================
       
    49 // Uniqe Id (32 bits). Combination of 4bits of table Id and 28bits of MD5 hashed code
       
    50 // (from Path or Name string)
       
    51 _LIT(KMCPodcastUniqueId,            "UniqueId");
       
    52 _LIT(KMCPodcastVolumeId,            "VolumeId");
       
    53 _LIT(KMCPodcastSync,                "Sync");        // Ever SYNCed with PC
       
    54 _LIT(KMCPodcastMod,                 "Modified");    // Modified in db
       
    55 _LIT(KMCPodcastIsPlaying,           "IsPlaying");   // Episode is currently playing
       
    56 _LIT(KMCPodcastDel,                 "Deleted");     // File deleted already
       
    57 _LIT(KMCPodcastDuration,            "Duration");
       
    58 _LIT(KMCPodcastTimeAdded,           "TimeAdded");
       
    59 _LIT(KMCPodcastPlayCount,           "PlayCount");
       
    60 _LIT(KMCPodcastTimePlayed,          "TimePlayed");
       
    61 _LIT(KMCPodcastRating,              "Rating");
       
    62 // NOTE: Location will store the path and file name, without drive-letter
       
    63 _LIT(KMCPodcastLocation,            "Location");
       
    64 _LIT(KMCPodcastArt,                 "Art");
       
    65 _LIT(KMCPodcastDbFlag,              "DbFlag");
       
    66 _LIT(KMCPodcastUrl,                 "Url");
       
    67 _LIT(KMCPodcastDRM,                 "DRM");
       
    68 _LIT(KMCPodcastReleaseDate,         "ReleaseDate");
       
    69 _LIT(KMCPodcastPublishDate,         "PublishDate");
       
    70 _LIT(KMCPodcastLastPlayPosition,    "LastPlayPosition");
       
    71 _LIT(KMCPodcastSampleRate,          "SampleRate");
       
    72 _LIT(KMCPodcastBitRate,             "BitRate");
       
    73 // Number of channels: required by MTP to support Play4sure
       
    74 _LIT(KMCPodcastNumChannels,         "NumChannels");
       
    75 // Audio Codec: required by MTP to support Play4sure
       
    76 _LIT(KMCPodcastCodec,               "Codec");
       
    77 _LIT(KMCPodcastMimeType,            "MimeType");
       
    78 
       
    79 // From MMF (MmfMeta.h)
       
    80 #define KMCPodcastName             KMMFMetaEntrySongTitle           // "title"
       
    81 // podcast author = media artist
       
    82 #define KMCPodcastAuthor           KMMFMetaEntryArtist              // "artist"
       
    83 // podcast title = media album
       
    84 #define KMCPodcastTitle            KMMFMetaEntryAlbum               // "album"
       
    85 #define KMCPodcastTrackNumber      KMMFMetaEntryAlbumTrack          // "albumtrack"
       
    86 // podcast category = media genre
       
    87 #define KMCPodcastGenre            KMMFMetaEntryGenre               // "genre"
       
    88 #define KMCPodcastComposer         KMMFMetaEntryComposer            // "composer"
       
    89 #define KMCPodcastComment          KMMFMetaEntryComment             // "comment"
       
    90 #define KMCPodcastCopyright        KMMFMetaEntryCopyright           // "copyright"
       
    91 #define KMCPodcastOrigArtist       KMMFMetaEntryOriginalArtist      // "originalartist"
       
    92 _LIT(KMCPodcastCategory,           "PodcastCategory");
       
    93 // end of MMF support data
       
    94 
       
    95 // == Category TABLE FIELDS ===================================================
       
    96 _LIT(KMCCategoryUniqueId,           "UniqueId");
       
    97 _LIT(KMCCategoryName,               "Name");
       
    98 _LIT(KMCCategoryCountEpisodes,      "EpisodeCount");
       
    99 
       
   100 // == Auxiliary TABLE FIELDS ==================================================
       
   101 // Version of database
       
   102 // The version integer looks like:
       
   103 // 31     23      15           0 bit
       
   104 // -----------------------------
       
   105 // |Major |Minor  |Build       |
       
   106 // -----------------------------
       
   107 _LIT(KMCAuxVersion,                 "Version");
       
   108 
       
   109 // Last time db was refreshed
       
   110 _LIT(KMCAuxTimeRefresh,             "TimeRefreshed");
       
   111 
       
   112 // Last time db was synced
       
   113 _LIT(KMCAuxTimeSync,                "TimeSynced");
       
   114 
       
   115 // Database Corrupted bit
       
   116 _LIT(KMCPodcastCorruptDB,           "Corrupt");
       
   117 
       
   118 // Number of records that have been marked as deleted
       
   119 _LIT(KMCSavedDeletedRecordCount,    "SaveDeletedRecordCount");
       
   120 
       
   121 
       
   122 #endif // MPXPODCASTCOLLECTIONDBDEF_H
       
   123 
       
   124 //End of File