--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/mpserviceplugins/mpxsqlitepodcastdbplugin/inc/mpxpodcastcollectiondbdef.h Fri Mar 19 09:28:13 2010 +0200
@@ -0,0 +1,125 @@
+/*
+* 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