Database Structure - Revision history

Drakinite at 19:43, 11 April 2024

2024-04-11T19:43:13Z

← Older revision		Revision as of 19:43, 11 April 2024
Line 52:		Line 52:
	== Default MediaMonkey 5+ Database location ==		== Default MediaMonkey 5+ Database location ==
	'''Standard installation:''' C:\Users\<USERNAME>AppData\Roaming\MediaMonkey5\MM5.DB		'''Standard installation:''' C:\Users\<USERNAME>AppData\Roaming\MediaMonkey5\MM5.DB

	'''Portable installation:''' <INSTALL LOCATION>\Portable\MM5.DB		'''Portable installation:''' <INSTALL LOCATION>\Portable\MM5.DB

Drakinite: Added MM5+ database location and some cleanup

2024-04-11T19:42:32Z

Added MM5+ database location and some cleanup

← Older revision		Revision as of 19:42, 11 April 2024
Line 50:		Line 50:
	</source>		</source>

	== Default ~~Mediamonkey~~ 3 and MediaMonkey 4 Database location ==		== Default MediaMonkey 5+ Database location ==
			'''Standard installation:''' C:\Users\<USERNAME>AppData\Roaming\MediaMonkey5\MM5.DB
			'''Portable installation:''' <INSTALL LOCATION>\Portable\MM5.DB

			== Default MediaMonkey 3 and MediaMonkey 4 Database location ==
	'''Windows XP:''' C:\Documents and Settings\<USERNAME>\Local Settings\Application Data\MediaMonkey\MM.DB		'''Windows XP:''' C:\Documents and Settings\<USERNAME>\Local Settings\Application Data\MediaMonkey\MM.DB

Line 59:		Line 63:
	'''NOTE''': ''When you are looking for the default mediamonkey.ini or mm.db, you may have to enable "View hidden/system files" in your windows explorer options or search''.		'''NOTE''': ''When you are looking for the default mediamonkey.ini or mm.db, you may have to enable "View hidden/system files" in your windows explorer options or search''.

	== Default ~~Mediamonkey~~ 2 Database location ==		== Default MediaMonkey 2 Database location ==
	My Documents\My Music\Mediamonkey\Mediamonkey.mdb		My Documents\My Music\Mediamonkey\Mediamonkey.mdb

Line 113:		Line 117:
	*[[URLRequestCache table\|URLRequestCache]]: Caches the results of some web requests.		*[[URLRequestCache table\|URLRequestCache]]: Caches the results of some web requests.

	== Database structure ==		== MediaMonkey 3 Database structure ==
	''(only most important tables)''		''(only most important tables)''

Line 126:		Line 130:
	----		----

	==MediaMonkey v2.5 and lower==		==MediaMonkey 2.5 and lower==

	===Database structure===		===Database structure===

Drakinite: Drakinite moved page Database Structure (MM4) to Database Structure

2024-04-11T19:02:16Z

Drakinite moved page Database Structure (MM4) to Database Structure

← Older revision	Revision as of 19:02, 11 April 2024
(No difference)

Drakinite at 16:46, 11 April 2024

2024-04-11T16:46:35Z

← Older revision		Revision as of 16:46, 11 April 2024
Line 1:		Line 1:
	{{DatabaseTablesList}}		{{DatabaseTablesList}}

	~~==MediaMonkey 3.0==~~

	== Database type ==		== Database type ==
	[http://www.sqlite.org SQLite] version 3		[http://www.sqlite.org SQLite] version 3

Drakinite: /* Default Mediamonkey 3 and MediaMonkey 4 Database location */ Made database location a bit more clear for MM3-4

2024-04-11T15:47:15Z

Default Mediamonkey 3 and MediaMonkey 4 Database location: Made database location a bit more clear for MM3-4

← Older revision		Revision as of 15:47, 11 April 2024
Line 55:		Line 55:
	== Default Mediamonkey 3 and MediaMonkey 4 Database location ==		== Default Mediamonkey 3 and MediaMonkey 4 Database location ==
	'''Windows XP:''' C:\Documents and Settings\<USERNAME>\Local Settings\Application Data\MediaMonkey\MM.DB		'''Windows XP:''' C:\Documents and Settings\<USERNAME>\Local Settings\Application Data\MediaMonkey\MM.DB
	~~<br>~~'''Windows Vista and Windows 7:''' C:\Users\<USERNAME>\AppData\Local\MediaMonkey\MM.DB or (~~on a Win7~~-~~64 platform as of~~ 2016-01-06) C:\Users\<USERNAME>\AppData\Roaming\MediaMonkey\MM.DB
			'''Windows Vista and Windows 7, before 2016-01-06:''' C:\Users\<USERNAME>\AppData\Local\MediaMonkey\MM.DB

			'''Windows 7 through 11 (64-bit), after 2016-01-06:''' C:\Users\<USERNAME>\AppData\Roaming\MediaMonkey\MM.DB

	'''NOTE''': ''When you are looking for the default mediamonkey.ini or mm.db, you may have to enable "View hidden/system files" in your windows explorer options or search''.		'''NOTE''': ''When you are looking for the default mediamonkey.ini or mm.db, you may have to enable "View hidden/system files" in your windows explorer options or search''.

Drakinite: /* Default Mediamonkey 3 Database location */

2024-04-11T15:38:27Z

Default Mediamonkey 3 Database location

← Older revision		Revision as of 15:38, 11 April 2024
Line 53:		Line 53:
	</source>		</source>

	== Default Mediamonkey 3 Database location ==		== Default Mediamonkey 3 and MediaMonkey 4 Database location ==
	'''Windows XP:''' C:\Documents and Settings\<USERNAME>\Local Settings\Application Data\MediaMonkey\MM.DB		'''Windows XP:''' C:\Documents and Settings\<USERNAME>\Local Settings\Application Data\MediaMonkey\MM.DB
	<br>'''Windows Vista and Windows 7:''' C:\Users\<USERNAME>\AppData\Local\MediaMonkey\MM.DB or (on a Win7-64 platform as of 2016-01-06) C:\Users\<USERNAME>\AppData\Roaming\MediaMonkey\MM.DB		<br>'''Windows Vista and Windows 7:''' C:\Users\<USERNAME>\AppData\Local\MediaMonkey\MM.DB or (on a Win7-64 platform as of 2016-01-06) C:\Users\<USERNAME>\AppData\Roaming\MediaMonkey\MM.DB

Drakinite: Added Pinned, Radio, and URLRequestCache tables

2024-04-10T19:18:20Z

Added Pinned, Radio, and URLRequestCache tables

← Older revision		Revision as of 19:18, 10 April 2024
Line 96:		Line 96:
	*[[OrganizeRules table\|OrganizeRules]]		*[[OrganizeRules table\|OrganizeRules]]
	*[[PathProcessing table\|PathProcessing]]		*[[PathProcessing table\|PathProcessing]]
			*[[Pinned table\|Pinned]]: Stores links to Pinned items (Added in version 5.0)
	*[[Played table\|Played]]		*[[Played table\|Played]]
	*[[PlaylistSongs table\|PlaylistSongs]] Specifies the relation between a Song and what '''Static Playlist(s)''' it appears in		*[[PlaylistSongs table\|PlaylistSongs]] Specifies the relation between a Song and what '''Static Playlist(s)''' it appears in
Line 102:		Line 103:
	*[[PodcastEpisodes table\|PodcastEpisodes]] Specifies the relation between a Song and a Podcast		*[[PodcastEpisodes table\|PodcastEpisodes]] Specifies the relation between a Song and a Podcast
	*[[Podcasts table\|Podcasts]] Specifies podcast subscriptions		*[[Podcasts table\|Podcasts]] Specifies podcast subscriptions
			*[[Radio table\|Radio]]: Stores links to the Radio node (Added in version 5.0)
	*[[RemoteClients table\|RemoteClients]]		*[[RemoteClients table\|RemoteClients]]
	*[[Songs table\|Songs]] : Contains all songs with all their properties		*[[Songs table\|Songs]] : Contains all songs with all their properties
Line 109:		Line 111:
	*[[SynchPlaylist table\|SynchPlaylist]]		*[[SynchPlaylist table\|SynchPlaylist]]
	*[[SynchPodcast table\|SynchPodcast]]		*[[SynchPodcast table\|SynchPodcast]]
			*[[URLRequestCache table\|URLRequestCache]]: Caches the results of some web requests.

	== Database structure ==		== Database structure ==

Drakinite: added Downloads table

2024-04-10T19:02:15Z

added Downloads table

← Older revision		Revision as of 19:02, 10 April 2024
Line 84:		Line 84:
	*[[DeviceTracks table\|DeviceTracks]]		*[[DeviceTracks table\|DeviceTracks]]
	*[[Devices table\|Devices]]		*[[Devices table\|Devices]]
			*[[Downloads table\|Downloads]]
	*[[Filters table\|Filters]]: Contains all Filters/Views configured in MM		*[[Filters table\|Filters]]: Contains all Filters/Views configured in MM
	*[[Folders table\|Folders]]		*[[Folders table\|Folders]]

Drakinite: Added RemoteClients table

2024-04-10T18:43:36Z

Added RemoteClients table

← Older revision		Revision as of 18:43, 10 April 2024
Line 101:		Line 101:
	*[[PodcastEpisodes table\|PodcastEpisodes]] Specifies the relation between a Song and a Podcast		*[[PodcastEpisodes table\|PodcastEpisodes]] Specifies the relation between a Song and a Podcast
	*[[Podcasts table\|Podcasts]] Specifies podcast subscriptions		*[[Podcasts table\|Podcasts]] Specifies podcast subscriptions
			*[[RemoteClients table\|RemoteClients]]
	*[[Songs table\|Songs]] : Contains all songs with all their properties		*[[Songs table\|Songs]] : Contains all songs with all their properties
	*[[SynchAlbum table\|SynchAlbum]]		*[[SynchAlbum table\|SynchAlbum]]

Drakinite: Drakinite moved page MediaMonkey Database structure to Database Structure (MM4)

2020-12-03T18:07:31Z

Drakinite moved page MediaMonkey Database structure to Database Structure (MM4)

← Older revision	Revision as of 18:07, 3 December 2020
(No difference)

← Older revision		Revision as of 19:18, 10 April 2024
Line 96:		Line 96:
	*[[OrganizeRules table\|OrganizeRules]]		*[[OrganizeRules table\|OrganizeRules]]
	*[[PathProcessing table\|PathProcessing]]		*[[PathProcessing table\|PathProcessing]]
			*[[Pinned table\|Pinned]]: Stores links to Pinned items (Added in version 5.0)
	*[[Played table\|Played]]		*[[Played table\|Played]]
	*[[PlaylistSongs table\|PlaylistSongs]] Specifies the relation between a Song and what '''Static Playlist(s)''' it appears in		*[[PlaylistSongs table\|PlaylistSongs]] Specifies the relation between a Song and what '''Static Playlist(s)''' it appears in
Line 102:		Line 103:
	*[[PodcastEpisodes table\|PodcastEpisodes]] Specifies the relation between a Song and a Podcast		*[[PodcastEpisodes table\|PodcastEpisodes]] Specifies the relation between a Song and a Podcast
	*[[Podcasts table\|Podcasts]] Specifies podcast subscriptions		*[[Podcasts table\|Podcasts]] Specifies podcast subscriptions
			*[[Radio table\|Radio]]: Stores links to the Radio node (Added in version 5.0)
	*[[RemoteClients table\|RemoteClients]]		*[[RemoteClients table\|RemoteClients]]
	*[[Songs table\|Songs]] : Contains all songs with all their properties		*[[Songs table\|Songs]] : Contains all songs with all their properties
Line 109:		Line 111:
	*[[SynchPlaylist table\|SynchPlaylist]]		*[[SynchPlaylist table\|SynchPlaylist]]
	*[[SynchPodcast table\|SynchPodcast]]		*[[SynchPodcast table\|SynchPodcast]]
			*[[URLRequestCache table\|URLRequestCache]]: Caches the results of some web requests.

	== Database structure ==		== Database structure ==

← Older revision		Revision as of 19:02, 10 April 2024
Line 84:		Line 84:
	*[[DeviceTracks table\|DeviceTracks]]		*[[DeviceTracks table\|DeviceTracks]]
	*[[Devices table\|Devices]]		*[[Devices table\|Devices]]
			*[[Downloads table\|Downloads]]
	*[[Filters table\|Filters]]: Contains all Filters/Views configured in MM		*[[Filters table\|Filters]]: Contains all Filters/Views configured in MM
	*[[Folders table\|Folders]]		*[[Folders table\|Folders]]

← Older revision		Revision as of 18:43, 10 April 2024
Line 101:		Line 101:
	*[[PodcastEpisodes table\|PodcastEpisodes]] Specifies the relation between a Song and a Podcast		*[[PodcastEpisodes table\|PodcastEpisodes]] Specifies the relation between a Song and a Podcast
	*[[Podcasts table\|Podcasts]] Specifies podcast subscriptions		*[[Podcasts table\|Podcasts]] Specifies podcast subscriptions
			*[[RemoteClients table\|RemoteClients]]
	*[[Songs table\|Songs]] : Contains all songs with all their properties		*[[Songs table\|Songs]] : Contains all songs with all their properties
	*[[SynchAlbum table\|SynchAlbum]]		*[[SynchAlbum table\|SynchAlbum]]