diff -r 000000000000 -r ff3acec5bc43 mpxplugins/serviceplugins/collectionplugins/mpxsqlitedbhgplugin/inc/mpxcollectiondbdef.h
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/mpxplugins/serviceplugins/collectionplugins/mpxsqlitedbhgplugin/inc/mpxcollectiondbdef.h	Thu Dec 17 08:45:05 2009 +0200
@@ -0,0 +1,148 @@
+/*
+* 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 MPXCOLLECTIONDBDEF_H
+#define MPXCOLLECTIONDBDEF_H
+
+// INCLUDES
+#include <mmfmeta.h>
+
+// CONSTANTS
+
+// ================================== DATABASE ================================
+
+// Db filename
+_LIT(KMCDbFile, "mpxv2_5.db");
+
+// Collection Db resource file
+_LIT(KMPXCollectionDbResourceFile,  "mpxcollectiondbhgres.rsc");
+
+// == TABLE NAMES =============================================================
+// The Auxiliary table stores general database metadata
+_LIT(KMCAuxiliaryTable,             "Auxiliary");
+// The Music table stores songs information
+_LIT(KMCMusicTable,                 "Music");
+// The Playlist table stores playlists information
+_LIT(KMCPlaylistTable,              "Playlist");
+// The PlaylistSongs table stores the song instances for each playlist
+_LIT(KMCPlaylistSongsTable,         "PlaylistSongs");
+// The PlaylistSongInfo table stores the songs that are included in playlists
+_LIT(KMCPlaylistSongInfoTable,      "PlaylistSongInfo");
+// The Artist table stores artist information
+_LIT(KMCArtistTable,                "Artist");
+// The Album table stores albums information
+_LIT(KMCAlbumTable,                 "Album");
+// The Genre table stores genres information
+_LIT(KMCGenreTable,                 "Genre");
+// The Composer table stores composers information
+_LIT(KMCComposerTable,              "Composer");
+
+// == Music TABLE FIELDS ======================================================
+_LIT(KMCMusicUniqueId,          "UniqueId");
+
+// From MMF (MmfMeta.h)
+#define KMCMusicName                KMMFMetaEntrySongTitle           // "title"
+#define KMCMusicArtist              KMMFMetaEntryArtist              // "artist"
+#define KMCMusicAlbum               KMMFMetaEntryAlbum               // "album"
+#define KMCMusicTrackNumber         KMMFMetaEntryAlbumTrack          // "albumtrack"
+#define KMCMusicGenre               KMMFMetaEntryGenre               // "genre"
+#define KMCMusicComposer            KMMFMetaEntryComposer            // "composer"
+#define KMCMusicComment             KMMFMetaEntryComment             // "comment"
+#define KMCMusicCopyright           KMMFMetaEntryCopyright           // "copyright"
+#define KMCMusicOrigArtist          KMMFMetaEntryOriginalArtist      // "originalartist"
+//end of MMF support data
+
+// NOTE: Location will store the path without drive letter
+_LIT(KMCMusicLocation,              "Location");
+_LIT(KMCMusicDuration,              "Duration");
+_LIT(KMCMusicReleaseDate,           "ReleaseDate");
+_LIT(KMCMusicTimeAdded,             "TimeAdded");
+_LIT(KMCMusicPlayCount,             "PlayCount");
+_LIT(KMCMusicTimePlayed,            "TimePlayed");
+_LIT(KMCMusicRating,                "Rating");
+_LIT(KMCMusicArt,                   "Art");
+_LIT(KMCMusicDbFlag,                "DbFlag");
+_LIT(KMCMusicSync,                  "Sync");
+_LIT(KMCMusicMod,                   "Modified");
+_LIT(KMCMusicDel,                   "Deleted");
+_LIT(KMCMusicUrl,                   "Url");
+_LIT(KMCMusicDRM,                   "DRM");
+_LIT(KMCMusicLastPlayPosition,      "LastPlayPosition");
+_LIT(KMCMusicSampleRate,            "SampleRate");
+_LIT(KMCMusicBitRate,               "BitRate");
+_LIT(KMCMusicVolumeId,              "VolumeId");
+
+// Number of channels: required by MTP to support Play4sure
+_LIT(KMCMusicNumChannels,           "NumChannels");
+
+// Audio Codec: required by MTP to support Play4sure
+_LIT(KMCMusicCodec,                 "Codec");
+_LIT(KMCMusicMimeType,              "MimeType");
+_LIT(KMCMusicMTPDrmStatus,          "MTPDrmStatus");
+
+// == Category TABLE FIELDS ===================================================
+_LIT(KMCCategoryUniqueId,           "UniqueId");
+_LIT(KMCCategoryName,               "Name");
+_LIT(KMCCategorySongCount,          "SongCount");
+
+// == Playlist TABLE FIELDS ===================================================
+_LIT(KMCPlaylistUniqueId,           "UniqueId");
+_LIT(KMCPlaylistName,               "Name");
+_LIT(KMCPlaylistUri,                "Uri");
+_LIT(KMCPlaylistVolumeId,           "VolumeId");
+_LIT(KMCPlaylistSync,               "Sync");
+_LIT(KMCPlaylistDbFlag,             "DbFlag");
+_LIT(KMCPlaylistTime,               "Time");
+
+// == PlaylistSongs TABLE FIELDS ==============================================
+_LIT(KMCPlaylistSongsUniqueId,      "UniqueId");
+_LIT(KMCPlaylistSongsSongId,        "SongId");
+_LIT(KMCPlaylistSongsPlaylistId,        "PlaylistId");
+_LIT(KMCPlaylistSongsOrdinal,   "Ordinal");
+
+// == PlaylistSongInfo TABLE FIELDS ===========================================
+_LIT(KMCPlaylistSongInfoSongId,     "SongId");
+_LIT(KMCPlaylistSongInfoUri,        "Uri");
+_LIT(KMCPlaylistSongInfoTitle,      "Title");
+_LIT(KMCPlaylistSongInfoVolumeId,   "VolumeId");
+_LIT(KMCPlaylistSongInfoDbFlag,     "DbFlag");
+
+// == 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(KMCMusicCorruptDB,             "Corrupt");
+
+// Number of records that have been marked as deleted
+_LIT(KMCSavedDeletedRecordCount,    "SaveDeletedRecordCount");
+
+#endif // MPXCOLLECTIONDBDEF_H
+
+// End of File