/*
* Copyright (c) 2006 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: This header file contains macro definitions used by the database subsystem.
*
*/
#ifndef MPXPODCASTCOLLECTIONDBDEF_H
#define MPXPODCASTCOLLECTIONDBDEF_H
// INCLUDES
#include <mmfmeta.h>
// CONSTANTS
// ================================== DATABASE ================================
// Db filename
_LIT(KMCDbFile, "pcv6_1.db");
// Collection Db resource file
_LIT(KMPXCollectionDbResourceFile, "PCRes.rsc");
// == TABLE NAMES ===============================================
// The Auxiliary table stores general database metadata like last refresh time etc...
_LIT(KMCAuxiliaryTable, "Auxiliary");
// The Podcast table stores information about the episodes stored within the collection
_LIT(KMCPodcastTable, "Podcast");
// The author table stores information about the authors of the music stored in the collection
_LIT(KMCAuthorTable, "Artist"); // podcast author = media artist
// The Title table stores information about the podcast titles of the episodes stored in the collection
_LIT(KMCTitleTable, "Album"); // podcast title = media album
// The Category table stores information about the category of the episodes stored in the collection
_LIT(KMCCategoryTable, "Genre"); // podcast category = media genre
// The Composer table stores information about the composer of the episodes stored in the collection
_LIT(KMCComposerTable, "Composer");
// == Podcast TABLE FIELDS ======================================================
// Uniqe Id (32 bits). Combination of 4bits of table Id and 28bits of MD5 hashed code
// (from Path or Name string)
_LIT(KMCPodcastUniqueId, "UniqueId");
_LIT(KMCPodcastVolumeId, "VolumeId");
_LIT(KMCPodcastSync, "Sync"); // Ever SYNCed with PC
_LIT(KMCPodcastMod, "Modified"); // Modified in db
_LIT(KMCPodcastIsPlaying, "IsPlaying"); // Episode is currently playing
_LIT(KMCPodcastDel, "Deleted"); // File deleted already
_LIT(KMCPodcastDuration, "Duration");
_LIT(KMCPodcastTimeAdded, "TimeAdded");
_LIT(KMCPodcastPlayCount, "PlayCount");
_LIT(KMCPodcastTimePlayed, "TimePlayed");
_LIT(KMCPodcastRating, "Rating");
// NOTE: Location will store the path and file name, without drive-letter
_LIT(KMCPodcastLocation, "Location");
_LIT(KMCPodcastArt, "Art");
_LIT(KMCPodcastDbFlag, "DbFlag");
_LIT(KMCPodcastUrl, "Url");
_LIT(KMCPodcastDRM, "DRM");
_LIT(KMCPodcastReleaseDate, "ReleaseDate");
_LIT(KMCPodcastPublishDate, "PublishDate");
_LIT(KMCPodcastLastPlayPosition, "LastPlayPosition");
_LIT(KMCPodcastSampleRate, "SampleRate");
_LIT(KMCPodcastBitRate, "BitRate");
// Number of channels: required by MTP to support Play4sure
_LIT(KMCPodcastNumChannels, "NumChannels");
// Audio Codec: required by MTP to support Play4sure
_LIT(KMCPodcastCodec, "Codec");
_LIT(KMCPodcastMimeType, "MimeType");
// From MMF (MmfMeta.h)
#define KMCPodcastName KMMFMetaEntrySongTitle // "title"
// podcast author = media artist
#define KMCPodcastAuthor KMMFMetaEntryArtist // "artist"
// podcast title = media album
#define KMCPodcastTitle KMMFMetaEntryAlbum // "album"
#define KMCPodcastTrackNumber KMMFMetaEntryAlbumTrack // "albumtrack"
// podcast category = media genre
#define KMCPodcastGenre KMMFMetaEntryGenre // "genre"
#define KMCPodcastComposer KMMFMetaEntryComposer // "composer"
#define KMCPodcastComment KMMFMetaEntryComment // "comment"
#define KMCPodcastCopyright KMMFMetaEntryCopyright // "copyright"
#define KMCPodcastOrigArtist KMMFMetaEntryOriginalArtist // "originalartist"
_LIT(KMCPodcastCategory, "PodcastCategory");
// end of MMF support data
// == Category TABLE FIELDS ===================================================
_LIT(KMCCategoryUniqueId, "UniqueId");
_LIT(KMCCategoryName, "Name");
_LIT(KMCCategoryCountEpisodes, "EpisodeCount");
// == Auxiliary TABLE FIELDS ==================================================
// Version of database
// The version integer looks like:
// 31 23 15 0 bit
// -----------------------------
// |Major |Minor |Build |
// -----------------------------
_LIT(KMCAuxVersion, "Version");
// Last time db was refreshed
_LIT(KMCAuxTimeRefresh, "TimeRefreshed");
// Last time db was synced
_LIT(KMCAuxTimeSync, "TimeSynced");
// Database Corrupted bit
_LIT(KMCPodcastCorruptDB, "Corrupt");
// Number of records that have been marked as deleted
_LIT(KMCSavedDeletedRecordCount, "SaveDeletedRecordCount");
#endif // MPXPODCASTCOLLECTIONDBDEF_H
//End of File