MediaMonkey Wiki - User contributions [en]

Getting Started (Addons)

2024-12-06T04:49:02Z

Drakinite: /* Metadata (info.json) */

''For a tutorial on developing addons for MediaMonkey 4, see [[Scripting (MM4)]]

=Additional Links=
* The [https://www.mediamonkey.com/forum/viewtopic.php?f=27&t=81285 '''Developer Forum pinned post'''] provides a summary of the information provided here, plus a few additional notes.
* The [https://www.mediamonkey.com/docs/api/ '''API Reference'''] is a complete reference to all the functionality provided both by MM native code and JS libraries.
* [[Important Methods and Utilities (Addons)|'''Important Methods and Utilities''']] provides a list of some of the most notable functionality provided.
* '''[[Methods_Added_Post_5.0|Methods added Post 5.0]]''' provides a list of methods that have been added ''after'' version 5.0.0, which you must be mindful of when publishing an addon.
* '''[[Working_with_Native_Objects_&_Data|Working with Native Objects & Data]]''' covers the concepts of data sources and native objects.
* The [https://www.mediamonkey.com/forum/viewforum.php?f=27 '''MM5 Developer Forum'''] is where you can find and ask questions related to developing MM5 addons.
* The [https://www.mediamonkey.com/wiki/Skinning_Guide '''Skinning Guide'''] provides information on how to create skins.
* [[Controlling MM5 from External Applications|'''Controlling MM5 from External Applications''']] discusses the different methods of controlling MediaMonkey 5 from other applications.

=Introduction to Making Addons in MediaMonkey 5=

MediaMonkey 5 is a fully HTML-based desktop application which uses Chromium for rendering. This means that the entire UI is driven by a '''platform-independent''' HTML/CSS/JS stack, which is fully accessible to developers and skinners. JS in cooperation with native code drives the non-visual aspects, also fully controllable by developers. This gives unprecedented customization options to create beautiful skins, new or enhanced functionality and great addons in general.

Scripting in MediaMonkey 5 differs greatly from MediaMonkey 4 and below, because it has been designed from the ground-up. It is not difficult to learn, especially if you are familiar with web programming. If you are coming from writing MediaMonkey 4 addons, you will get adjusted in no time at all.

=Hello World example=

Here is a basic Hello World example for a MediaMonkey 5 addon.

Inside a new folder, create a file named info.json with the essential information about your addon.

<syntaxhighlight lang="javascript">
{
    "title": "My First Addon",
    "id": "myFirstAddon",
    "description": "Hello world!",
    "version": "1.0.0",
    "type": "general",
    "author": "Jane Doe"
}
</syntaxhighlight>

Next, create a file named mainwindow_add.js. This code will get added to the end of mainwindow.js, and it will run when MediaMonkey starts.

<syntaxhighlight lang="javascript">
// Execute when the window is ready
window.whenReady(() => {
    uitools.toastMessage.show('Hello world!', {
        disableUndo: true
    });
});
</syntaxhighlight>

Then, select your two files and package them into a zip. Make sure that they are in the root of your zip archive and not inside a subfolder. Rename it to myFirstAddon.mmip.

Inside MediaMonkey5, go to Tools > Addons, click Add, and select your addon. After it installs and you reload the window, you will get a popup "toast" message on the bottom of the screen.

=MMIP (MediaMonkey Installer Packages)=
The center of all MediaMonkey add-ons is the MMIP. There is nothing special about the file format itself; it is just a ZIP archive with a different filename. You can use any standard method to zip the files, and then just rename it to a .mmip file.

If you wish to automate the process of zipping the MMIP packages, you are in luck.
* There is a tool named pack-mmip which allows you to automatically package MMIPs from the command line. It is available here: https://github.com/JL102/pack-mmip
* If your code is on Github, you can use a pipeline to automatically package your addon whenever you commit changes: https://www.mediamonkey.com/forum/viewtopic.php?p=476534

==Folder Structure==

===Metadata (info.json)===
At the root of an MMIP, there must be a file named info.json. It includes all essential information about the addon. It cannot be in a subfolder.

Here is an example info.json:
<syntaxhighlight lang="javascript">
{
    "title": "My Addon Name",
    "id": "myFirstAddon",
    "description": "This is my first addon!",
    "version": "1.0.0",
    "minAppVersion": "5.0.0",
    "type": "general",
    "author": "Jane Doe",
    "icon": "icon.png"
}
</syntaxhighlight>

Here are the possible attributes info.json can contain:
{| class="wikitable" style="max-width: 800px;"
|-
! Attribute
! Required?
! Information
|-
| title
| '''yes'''
| This is the name of your addon that is visible to the user.
|-
| id
| '''yes'''
| This is the unique ID of your addon. It does not have to be identical to your title, but it is recommended that your addon's id be similar to its title for organizational purposes. The id can include the following characters: [a-zA-Z0-9 -_'()]. As of 5.0.3, this format will be enforced. We recommend sticking to an alphanumeric string without spaces.
|-
| description
| '''yes'''
| The description of your addon. Make sure your description is brief, yet conveys the meaning and usage of your addon to the user. You can create line breaks in the description with \n.
|-
| version
| '''yes'''
| The version number of your addon. It must be in the format %d.%d.%d, which is three period-separated numbers.
|-
| minAppVersion
| no*
| The minimum compatible version of MediaMonkey for your addon. Please consult [[Methods_Added_Post_5.0]] to view whether your addon is incompatible with older versions of MediaMonkey.
|-
| maxAppVersion
| no
| The maximum compatible version of MediaMonkey for your addon. If this field is specified, then MediaMonkey versions newer than the one specified will not allow an installation of the addon. Useful if, for example, a newer version of MediaMonkey makes the addon not necessary to install or breaks compatibility.
|-
| type
| no
| The category of your addon. The existing categories are: general, skin, layout, sync, metadata, and visualization; but you can create your own categories. If unspecified, the type defaults to general.
|-
| author
| no
| The name of the addon's author.
|-
| icon
| no
| The filename of your addon's icon image. The image file must be in the root of the MMIP.
|-
| config
| no
| The filename of your addon's configuration script. See Adding Configurable Settings for more info.
|-
| updateURL
| no
| Link to a custom URL to check for app updates, for addons that are self-hosted. See: [[#Self-hosted addons|Self-hosted addons]]
|-
| installScript
| no
| The filename of your addon's install script. The script will run once when the addon is being installed. </br>The variable <code>window.__currentAddonPath</code> will be set, pointing to the filesystem folder into which the addon has been installed.

|-
| uninstallScript
| no
| The filename of your addon's uninstall script. The script will run once when the addon is being uninstalled. </br>The variable <code>window.__currentAddonPath</code> will be set, pointing to the filesystem folder into which the addon has been installed.
|-
| files
| no
| This only applies to plugins (type: "plugin"). Contains an array of objects, listing plugin files to be added. "src" is the source file path relative to the root inside mmip and "tgt" is the target file path relative to the Plugins folder. It can only write under the Plugins folder.</br>Example:
<syntaxhighlight lang="js">
"files": [{
    "src": "pluginDLL.dll",
    "tgt": "pluginDLL.dll"
})
</syntaxhighlight>
|-
| showRestartPrompt
| no
| Default is "true". Tells MediaMonkey whether to prompt a user for a restart. </br> Possible values: "true", "false", "install", and "uninstall". </br> If "true", MM will prompt the user for a restart on both install and uninstall. </br> If "install", MM will only prompt on install. </br> If "uninstall", MM will only prompt on uninstall. </br> If "false", neither installing nor uninstalling will prompt a restart. </br> <u>Must be a string if provided. Boolean true/false is not supported.</u>
|}

<nowiki>*</nowiki> May be required in the future.

===License===
You can choose to include a license file in the root of your addon, named license.txt. If present, when the addon is being installed. the license agreement will be shown to the user, and they will be required to accept the terms before installing.

===Code===
All the HTML/CSS/JS code that handles MM functionality is stored in a tree structure. As a developer, you can add new files, replace existing, or even extend functionality of the existing files. This is achieved by replication of the folder structure in Addons. For example, if a file controls\checkbox.js is present in the Addon, it completely replaces the default MM functionality of a checkbox. Similarly, an _add suffix in a filename extends functionality of an existing file. E.g. dialogs\dlgAbout_add.js can contain code that adds new controls to the layout of the About dialog.

For information on how to load other files & scripts into your code, please see the sections on <code>requirejs</code> and <code>localRequirejs</code> here: [[Important_Methods_and_Utilities_(Addons)#requirejs]]

===init.js===
You can choose to include a script named init.js in the root of your addon. If present, the script will run at startup.

===MediaMonkey folder structure===

* '''Root''' - Contains mainly mminit.js, which has the basic MM JS routines, several other utility .js files, maincontent.html which contains the basic definition of the main window. Also important is viewHandlers.js, which defines the tree structure of MM and behaviour of the views.
** '''controls''' - Contains all the controls used in MM UI. This starts with very basic controls, like button.js or dropdown.js, and continues with more complex things like listview.js and goes all the way to the complex UI elements, like equalizer.js, player.js or autoPlaylistEditor.js.
** '''dialogs''' - All the dialogs reside here, e.g. dlgConvertFormat.html + dlgConvertFormat.js
*** '''dlgOptions''' - Panels for the Tools > Options menu reside here.
** '''helpers''' - Contains miscellaneous helper scripts that do not fit into the other categories. For example: butt services, tray icon menus, docking, etc.
** '''layouts''' - Subfolders contain individual layouts, i.e. something that can replace/modify the files in the default folder structure in order to achieve completely different layout of MM (e.g. "Touch mode" layout). Unlike skins, layouts are supposed to mainly modify dimensions, positions and types of UI elements, not their color, etc. See [[Layouts]] for more information.
** '''scripts''' - This contains all non-skin addons that are installed to MediaMonkey, including addons that are preinstalled. They are organized by id.
** '''skin''' - Contains basic skin definitions, mostly a set of LESS files (an extension to CSS). See http://lesscss.org for more information.
*** '''icon''' - Contains all the icons used by MM. They are in SVG format in order to scale nicely to any display resolution. As anything else, they can be easily replaced by any Addon (skin or script).
** '''skins''' - Subfolders contain individual skins, i.e. something that can replace/modify the files in the default folder structure in order to achieve completely different looks of MM. Unlike layouts, this is supposed to mainly modify colors, fonts, icons, etc. See [[Skinning_Guide]] for more information.

Filetypes that can be overridden:
* JS (e.g. controls/artistGrid.js
* HTML (e.g. (root)/player.html)
* LESS (e.g. skin/skin_complete.less)
* SVG (e.g. skin/icon/about.svg)
Filetypes that can be added to:
* JS (e.g. (root)/actions_add.js)
* LESS (e.g. skin/skin_base_add.less)
Filetypes that can be added new:
* JS (e.g. dialogs/dlgOptions/pnl_myAddon.js)
* HTML (e.g. dialogs/dlgOptions/pnl_myAddon.html)
* LESS (e.g. skin/skin_somethingnew.less)
* SVG (e.g. skin/icon/newIcon.svg)
* CSS (e.g. dialogs/dlgOptions/myExtraStylesheet.css) (Not recommended)

==Versioning==
The versioning of addons must be in the format of three period-separated numbers (for example 0.0.1, 1.2.34, etc.) We recommend using semantic versioning (see https://semver.org).

MediaMonkey has a built-in updater for addons. When the user clicks "Find Updates" in the addons screen, it will check online if there are any updates for addons that are installed. If any are found, the user clicks the download button that appears, then it will download and install the updated addon.

==Submitting an addon==
To submit an addon, you must first have an account on the MediaMonkey forum and be signed in.
# Go to https://www.mediamonkey.com/addons/ and click Submit Addon.
# Select the most appropriate sub-category under MediaMonkey 5 that describes your addon.
# Click Submit New Addon.
## Name: Make sure it is the same as your addon's title, so that it does not confuse users after installing.
## Description: This does not have to be the same as the description in info.json. You can be as descriptive as you like.
## Support Link, Author Link, and License Type are optional.
## Image is not required, but highly recommended. We recommend that it be a square image, and the same image as your addon's icon.
# Click next. On this page, you will add the first version of your addon.
## Either upload your MMIP file or specify an external download link.
## Compatibility: Specify the MediaMonkey versions on which you have confirmed your addon works.
## What's New is optional, but you can specify updates here in future versions.
# Click Save. Review your changes, make sure everything is accurate, then click Finish.
# Your addon will appear in red until it is approved by a moderator. When approved, it will appear on the main addons page.
To add a new version of your addon, simply click Add New Version and follow steps 4-5. Each additional version needs to be approved by a moderator.

==Adding to scripts==
To add code to the end of a certain script, create a JS file in its appropriate location, with _add at the end of its name.

For example, if you wish to make an addition to controls/navigationBar.js, make controls/navigationBar_add.js inside your MMIP. You can also entirely replace the file if you name it controls/navigationBar.js inside your MMIP.

==Self-hosted addons==
For addons hosted on external sites, please provide a field '''updateURL''' in info.json to allow MediaMonkey to check for updates to your addon. The server must reply with info on the most recent version of the addon, in either XML or JSON format. More fields can be returned, but will be ignored by current versions of MediaMonkey.

For a working example, see: https://www.happymonkeying.com/update.php?upd=300021
Please note that since the release of that addon, the MinVersionMajor - MaxVersionBuild fields have been replaced with MinAppVersion, as described below.

===XML===
# The sequence of '''VersionMajor''', '''VersionMinor''', and '''VersionRelease''' form the standard version string; in the below example, it would be 3.0.6. '''VersionBuild''' also must be included but can be blank.
# '''UpdateURL''' is the link to download the addon as an MMIP.
# '''MinAppVersion''' refers to the minimum supported version of MediaMonkey. It is optional but highly recommended to include.

Example:
<syntaxhighlight lang="xml">
<VersionMajor>3</VersionMajor>
<VersionMinor>0</VersionMinor>
<VersionRelease>6</VersionRelease>
<VersionBuild></VersionBuild>
<MinAppVersion>5.0.2</MinAppVersion>
<UpdateURL>http://myserver/myAddon.mmip</UpdateURL>
</syntaxhighlight>

===JSON===
In JSON, '''version''' is provided as a single string instead of the four separate VersionX fields.

Example (equivalent to the XML above):
<syntaxhighlight lang="js">
{
"version": "3.0.6",
"minAppVersion": "5.0.2",
"updateUrl":"http://myserver/myAddon.mmip"
}
</syntaxhighlight>

=Important tips=
* '''Minimize the amount of computation your addon does on startup.''' Most scripts in MM run as soon as the window loads, so make sure your addon does not take a long time doing synchronous calculations that can cause the window to take longer to load. Ways to help avoid this:
** Use '''window.whenReady()''' when possible. Using window.whenReady() will cause your callback to only fire when all scripts are loaded, the whole DOM is processed by our parser, and all controls are initialized.
** Use asynchronous code when possible (with either callbacks, Promises, or async/await). If you perform heavy calculations that are synchronous, then it will halt the UI. See https://developer.mozilla.org/en-US/docs/Learn/JavaScript/Asynchronous/Async_await for more information.
* '''Put your _add scripts into an anonymous function.''' To prevent potential issues of variables with the same name being used across different scripts, we recommend putting most/all of your logic into an anonymous function. You can do it with arrow notation or function notation.
** <code>(() => { /* Do stuff */ })();</code>
** <code>(function() { /* Do stuff */ })();</code>
* '''Enable Developer Mode.''' Under Help > About, you can enable Developer Mode. This will prevent crash logs from being automatically sent to MediaMonkey staff.
** Additionally, developer mode can be enabled in the code via <code>app.enabledDeveloperMode(true)</code> during testing. But '''do not''' keep it in your published extension.
* '''Use requestFrame and requestTimeout instead of requestAnimationFrame and setTimeout.''' The custom functions automatically check whether the window/control still exists, and do not call the callback when the window/control have already been destroyed, to prevent crashes.

* '''Do not spam console.log''' in your final addon that's distributed to users. While developing it, it is completely okay to use it as much as you want! However, the JavaScript console.log function is relatively computationally expensive, so if it spams logs, then it will degrade performance. If it just logs occasionally, for debugging purposes, it's okay. Just don't overdo it.

* To avoid breaking for...in loops, do not add functions to Array.prototype with the syntax <code>Array.prototype.func = function () {}</code>. Details here: https://www.ventismedia.com/mantis/view.php?id=18145

=Actions, Hotkeys & Menus=
The MediaMonkey interface is controlled largely by actions, which are defined inside actions.js. Most UI elements are tied to actions, and all hotkeys are defined by actions.

'''Note:''' Defining custom actions must be done in actions_add.js. Otherwise, MediaMonkey will not properly register the actions.

==Defining actions==
Actions are defined in the global actions object. Each action contains the following attributes:
{| class="wikitable" style="max-width: 800px;"
|-
! Attribute
! Type
! Required?
! Information
|-
| title
| function (string)
| '''yes'''
| Function that returns the (string) title of the action.
|-
| execute
| function
| '''yes'''
| Function that runs when the action is executed.
|-
| category
| function (string)
| no
| Function that returns the (string) name of the action's category. Categories are defined in the global actionCategories object. Default is general.
|-
| hotkeyAble
| boolean
| no
| Determines whether the action can be tied to a hotkey. Default is false.
|-
| icon
| string
| no
| Icon that shows in menus that contain the action. The icon ids are located in skin/(iconname).svg.
|-
| visible
| function (boolean)
| no
| Determines whether the action will show up in menus. This can be useful for integrating party mode, for example, by disabling your action when party mode is enabled with
<code>visible: window.uitools.getCanEdit</code>.
|}
Additionally, actions can contain any other custom attributes and methods.

Defining your own custom action in actions_add.js:
<syntaxhighlight lang="js">
actions.myCustomAction = {
    title: 'My Custom Action',
    hotkeyAble: true,
    execute: function () {
        messageDlg('This action was created by hotkeyAction script.', 'information', ['btnOK'], {
            defaultButton: 'btnOK'
        }, undefined);
    }
}
</syntaxhighlight>

==Assigning hotkeys to actions==
Assigning hotkeys is very simple. Hotkeys are handled by the global hotkeys object, and you can register a hotkey with the hotkeys.addHotkey method.

Usage:
<syntaxhighlight>hotkeys.addHotkey(hotkey, action, global);</syntaxhighlight>

{| class="wikitable" style="max-width: 800px;"
|-
! Attribute
! Type
! Required?
! Information
|-
| hotkey
| string
| '''yes'''
| The hotkey to assign. See Tools > Options > Hotkeys for the right syntax.
|-
| action
| string
| '''yes'''
| The action (in window.actions) to execute. Caps sensitive.
|-
| global
| boolean
| no
| Determines whether the hotkey is global (accessible outside the MM window). Default is false.
|}

Adding a hotkey to your custom action:
<syntaxhighlight lang="js">hotkeys.addHotkey('Ctrl+Shift+Q', 'myCustomAction');</syntaxhighlight>

The addHotkey method automatically handles duplicates and deletions. So if a user deletes the hotkey, you don't have to worry about it showing up again every time the window reloads; and they can manually re-add it.

To see the syntax that MediaMonkey uses for hotkeys, go to the Tools>Options>Hotkeys window and type in your desired hotkey.

==Adding actions to menus==
MediaMonkey uses a structure for menus that allows infinitely nested sub-menus. The data structure of a menu item is as follows:
<syntaxhighlight lang="js">
menuItem = {
action: {
title: String, // Required
execute: Function, // Usually required
icon: String,
visible: Boolean,
disabled: Boolean,
submenu: Array
},
order: Number, // Required
grouporder: Number // Required
}
</syntaxhighlight>
The <code>submenu</code> field, which is optional, contains an array of as many other menu items as desired. The <code>grouporder</code> field determines which group a menu item will belong to, and groups will be automatically sorted by the <code>order</code> field. Menu items defined in actions.js are intentionally given order and grouporder like 10, 20, 30, etc. to allow addons to insert menu items in between them as desired.

Note: These fields can ''either'' be the datatype as described above ''or'' a function which returns the requested data type. At runtime, the global method <code>resolveToValue</code> is called, which either returns the primitive type or calls the provided function. If you analyze the actions in actions.js, you'll see bits like <code>visible: window.uitools.getCanEdit</code>. This is an example of a function which resolves to a boolean.

There are two menu groups that you will most likely want to add items to: The main menu bar, and tracklist menus.

===Main menu bar===
The File, Edit, View, etc. menus are defined in <code>window._menuItems</code>, from actions.js. See actions.js or look in the devtools console to see all the possible submenus to which to add your action. '''You can only add to these menus inside actions_add.js.'''

For example, if you wish to add an action to the "Tools > Edit tags" submenu, that is under <code>window._menuItems.editTags</code>:
<syntaxhighlight lang="js">
window._menuItems.editTags.submenu.push({
action: actions.myNewAction,
order: 10,
grouporder: 10
});
</syntaxhighlight>

===Tracklist menus===
Tracklist menus, which may also be called media menus, are the ones that contain ''Play now'', ''Play next'', ''Properties'', etc. These are defined in <code>window.menus.tracklistMenuItems</code>, from controls/trackListView.js. '''You should only add to these menus inside controls/trackListView_add.js.'''

For example, if you wish to add an action below Cut, Copy, and Paste, but above Rename:

* First, look in the definition of menus.tracklistMenuItems that Cut/Copy/Paste/Rename are in group 40, Paste's order is 30, and Rename's order is 35.
* This item must go in the same group and have an order between 30 and 35.
<syntaxhighlight lang="js">
window.menus.tracklistMenuItems.push({
action: actions.myNewAction,
order: 31,
grouporder: 40
});
</syntaxhighlight>

==Categories==
''Coming soon''

=Storing Data=

==JSON==
When you wish to save data such as user preferences, the most effective method is to save values in persistent.json. The way you do this is through the app.setValue and app.getValue methods.
Both methods require two parameters.

If retrieving a value that is primitive, set the second parameter as undefined.
<syntaxhighlight lang="javascript">
app.setValue('myExtension_foo', 'bar');

var foo = app.getValue('myExtension_foo', undefined);
</syntaxhighlight>

When retrieving a value that is an object, you must provide the second parameter as an object. The function will take that object and populate each value if it exists, so you can easily manage default settings this way.
<syntaxhighlight lang="javascript">
// Saving settings
app.setValue('myExtension_settings', {
    option1: 0,
    option2: 'electric boogaloo'
});
// Getting settings with hardcoded defaults
var settings = app.getValue('myExtension_settings', {
    option1: 0,
    option2: 'default'
})
// Passing an empty object works too
var settings = app.getValue('myExtension_settings', {});
</syntaxhighlight>
This data is automatically saved in persistent.json, which is saved in the user's AppData folder or the Portable subfolder; for non-portable and portable installations, respectively. Persistent.json is only deleted if the user manually deletes it or removes a portable installation.
'''Important:''' Make sure the keys that you use are unique. Include the addon ID in the key, as demonstrated above, to ensure this.

==Database==
If you need to manage more data, you can use the database. In MM5, you can access the database through the app.db object. For more information, see: https://www.mediamonkey.com/webhelp/MM5Preview/classes/DB.html.

To execute queries that do not need return values, use app.db.executeQueryAsync:

<syntaxhighlight lang="javascript">
app.db.executeQueryAsync('CREATE TABLE IF NOT EXISTS myPlugin (_id INTEGER PRIMARY KEY, value TEXT UNIQUE NOT NULL)')
.then(() => {
app.db.executeQueryAsync('INSERT INTO myPlugin [. . .]');
})
.catch(err => {
    console.error(err)
});

To execute queries that need return values, use app.db.getQueryResultAsync:
app.db.getQueryResultAsync('SELECT * FROM Albums')
.then(result => {
    // do stuff
})
.catch(err => console.error(err));
</syntaxhighlight>

This method returns a QueryResults object, which is a linked list. See https://www.mediamonkey.com/webhelp/MM5Preview/classes/QueryResults.html.

==Adding Configurable Settings to your Addon==
There are two ways to add configurable options to an addon: via the "config" option in info.json, or modifying the options dialog.

===Addon Config===
The recommended way of adding configurable settings to an addon, if the settings are not directly related to an existing options panel, is to use the built-in addon configuration options. To do this, you must specify "config" in info.json:
<syntaxhighlight>"config": "config.js"</syntaxhighlight>

Inside your configuration js file, you must define a window.configInfo object, with two functions: load and save.

Load is executed during page load, and save is executed after "OK" is pressed. Both functions are passed two parameters: pnl and item.
* "pnl" (pnlDiv) is the HTML node of the panel
* "item" (addon) is an object that contains information about the addon, such as title, ext_id, description, version, installType, author, path, etc.

You can opt to add a config HTML as well, by giving it the same base name as your config JS. For example, if it is named config.js, create config.html; if it is named MediaMonkeyRocks.js, create MediaMonkeyRocks.html.

When a configuration script is provided for an addon, the panel will open once the addon is installed. Additionally, a button will appear in its listing to open the configuration panel.

Example usage:

config.html
<syntaxhighlight lang="html">
<div class="uiRows">
    <div>
        <div data-id="chbOption1" data-control-class="Checkbox" data-tip="Option 1 tooltip">Option 1</div>
    </div>
    <div>
        <div data-id="chbOption2" data-control-class="Checkbox" data-tip="Option 2 tooltip">Option 1</div>
    </div>
</div>
</syntaxhighlight>

config.js
<syntaxhighlight lang="js">
window.configInfo = {
    load: function (pnlDiv, addon) {
        // Load config with defaults
        this.config = app.getValue('myAddon_config', {
            option1: true,
            option2: false,
        });
        // Set checkboxes to the configuration settings
        var UI = getAllUIElements(pnlDiv);
        UI.chbOption1.controlClass.checked = this.config.option1;
        UI.chbOption2.controlClass.checked = this.config.option2;
    },
    save: function (pnlDiv, addon) {
        // Save settings according to the checkbox changes
        var UI = getAllUIElements(pnlDiv);
        this.config.option1 = UI.chbOption1.controlClass.checked;
        this.config.option2 = UI.chbOption2.controlClass.checked;
        app.setValue('myAddon_config', this.config);
    }
}
</syntaxhighlight>

===Options Dialog===
When modifying the options dialog, you can either add to / modify an existing panel or create your own panel.

====Adding to an existing panel====
Adding to an existing panel can be done with _add JS files. For more context, take a look at dialogs/dlgOptions.js.

For example, if you wish to add to the General Options panel:
# Create dialogs/dlgOptions/pnl_General_add.js
# Override the optionPanels.pnl_General.load and optionPanels.pnl_General.save functions to add your own code
# Use the divFromSimpleMenu function to automatically create styled checkboxes/radio buttons
# Use app.getValue and app.setValue to retrieve and save the user settings

<syntaxhighlight lang="javascript">
(() => {
    var options = [
        {
            title: 'Option 1', // The label that appears on the checkbox/radio button
            radiogroup: 'myAddon_RadioOptions', // Self-explanatory
            execute: function() {state.RadioOptions = 'option1'} // This function runs whenever the element is clicked
        },
        {
            title: 'Option 2',
            radiogroup: 'myAddon_RadioOptions',
            execute: function() {state.RadioOptions = 'option2'}
        },
        {
            title: 'My Checkbox',
            checkable: true, // Turns it into a checkbox
            execute: function() {state.Checkbox = this.checked;}
        },
    ]
    var state;

    optionPanels.pnl_General.override({
        load: function($super, sett, pnlDiv) {
            $super(sett, pnlDiv);
            console.log('yoyoyoyoyo')

            state = app.getValue('myAddon_settings', {
                RadioOptions: 'option1',
                Checkbox: false
            });
            // Update checkbox/radiobutton state from settings
            if (state.RadioOptions == 'option1') {options[0].checked = true; options[1].checked = false;}
            else {options[0].checked = false; options[1].checked = true}
            if (state.Checkbox == true) options[2].checked = true;
            // Create an HTML menu from the options
            divFromSimpleMenu(pnlDiv, options);
        },
        save: function($super, sett, pnlDiv) {
            $super(sett, pnlDiv);
            // Save settings
            app.setValue('myAddon_settings', state);
        }
    });
})();
</syntaxhighlight>

====Creating a new panel====
You can define your new panel inside dialogs/dlgOptions, and add it inside dialogs/dlgOptions_add.js.

''Coming soon''

=Plugins=
While most functionality can be reached in MediaMonkey 5 via addons using JS/HTML, it still supports the majority of the Winamp 2.0 API. Winamp plugin support for MediaMonkey 5 is the same as in MediaMonkey 4. See [[Winamp Plug-ins (MM4)]] for more details.

==Packaging a Plugin==
To create an MMIP installer for a plugin, you need to include the information about your plugin's file[s] into info.json:
<syntaxhighlight lang="json">
"type": "plugin",
"files": [{
"src": "pluginDLL.dll",
"tgt": "pluginDLL.dll"
}]
</syntaxhighlight>

It can contain more files. "src" is the source file path relative to the root inside mmip, and "tgt" is target file relative to the Plugins folder inside the MediaMonkey installation. It can write only under the Plugins folder.

If needed, you can also include an installScript and uninstallScript:
<syntaxhighlight lang="json">
"installScript": "install.js",
"uninstallScript": "uninstall.js"
</syntaxhighlight>
The install script will run during installation and uninstall script will run after uninstallation.

Both will run inside the main window, allowing full access to the UI. Additionally, the variable <code>window.__currentAddonPath</code> will be set, pointing to the filesystem folder into which the addon has been installed.

=Accessing the main window object from other windows=
Sometimes, you may need to run functions or access properties from the main window in the context of other windows. For example, performing live updates in an options panel. To do this, use the app.dialogs.getMainWindow() method.

If you have a property "x" in the main window, this is how to access it from another window:
<syntaxhighlight lang="js">app.dialogs.getMainWindow().getValue('x')</syntaxhighlight>
If you assign a property or method to "app", you will need to do this to get the version of it that is attached to the main window.
<syntaxhighlight lang="js">app.dialogs.getMainWindow().getValue('app').myObject.myMethod();</syntaxhighlight>

=UI Elements & Controls=

==Icons==
Instead of bitmaps, MediaMonkey uses [https://en.wikipedia.org/wiki/Scalable_Vector_Graphics SVGs] for its icons. They are stored in the <code>skin/icon</code> folder. This is because SVGs can be scaled to any size without appearing pixelated. See [[Skinning_Guide#Creating_Icons|Skinning Guide/Creating Icons]] for an introduction on how to create custom icons.

There are three ways to load icons: The <code>data-icon</code> HTML attribute; <code>loadIconFast()</code>; and <code>loadIcon()</code>.

===data-icon===
Whenever HTML is loaded and/or classes are initialized, any and all elements with the attribute "data-icon" will automatically load the SVG files associated with the icon name provided. For details on how it works, check window.initializeControls in mminit.js. See this example:
<syntaxhighlight lang="html">
<div data-control-class="toolbutton" data-icon="music"></div>
</syntaxhighlight>
This will create a ToolButton control with the icon from music.svg. Using the ToolButton control class is not required, but if you do not add any CSS to limit the size of the icon, it will appear very large.

===loadIconFast===
If you wish to load an icon programmatically, use <code>loadIconFast()</code>. For more details, see [https://www.mediamonkey.com/docs/api/classes/Window.html#method_loadIconFast loadIconFast].

===loadIcon===
Only use <code>loadIcon()</code> if you need to access the raw SVG code before adding it to the DOM. For more details, see [https://www.mediamonkey.com/docs/api/classes/Window.html#method_loadIcon loadIcon].

''More coming soon''

Database Structure

2024-04-11T19:43:13Z

Drakinite:

{{DatabaseTablesList}}
== Database type ==
[http://www.sqlite.org SQLite] version 3
* Encoding: UTF-16le
* Text collate IUNICODE (except where indicated with a (*))

== Additions to SQLite ==
Check out [http://www.sqlite.org/docs.html SQLite documentation]. MediaMonkey adds some more functions that you can use in SQL queries:

=== Collations ===
* IUNICODE - Unicode language neutral case insensitive (Post [http://www.mediamonkey.com/forum/viewtopic.php?p=127635#127635 1] [http://www.mediamonkey.com/forum/viewtopic.php?p=79915#79915 2] by Jiri with more detail)
* USERLOCALE - Sorts according to users locale in regional settings. (Implemented in 3.1.2.1279)
* NUMERICSTRING - Natural song order respecting numbers stored as strings. Useful for Track# and Disc# fields.

Due the customized collations MediaMonkey for Windows extension Library can be downloaded from
http://www.happymonkeying.com/beta/SQLite3MMExt.dll and then used in any app that can load and use external extension like
free Database Browser for SQLite

=== Functions ===
* HASSUBFOLDERS(string) - Used internally by MediaMonkey.
* INSTR(string1, string2) - Returns 1-based index of the first occurrence of string2 in string1, if not found 0 is returned. Case sensitive.
* LIKE(string1, string2) - Used to replace internal SQLite LIKE operator with one that supports Unicode strings. SEE NOTE!
* NEXTPATHPART(string) - Used internally by MediaMonkey.
* SIN(number) - Mathematical sinus function.
* STRICOMPW(string1, string2) - Compares two Unicode strings, case insensitive.
* UPPERW(string) - Unicode string upper case.
* GETEXTENSION(string) - Returns the extension from a filename. (Introduced in MM 3.1)
* SOUNDEX(string) - Returns a four-character string, based on how the word is pronounced in English. Similar spelled names are supposed to returns the same string. (Introduced in MM 3.1)

==== Note regarding LIKE ====
This MM-specific implementation of LIKE, automatically uses the @-sign as the escape character and it is always applied.
It means that you need to modify the SearchString to correctly use this function.

Here is one example of an VBScript function which prepares the search string correctly.
<source lang="vb">
Function FixLikeSearchString(Str)
Str = Replace(Str,"@","@@")
Str = Replace(Str,"_","@_")
Str = Replace(Str,"%","@%")
Str = Replace(Str,"'","''") '<--- Single quotes are escaped with another single quote
FixLikeSearchString=Str
End Function
</source>

If you for some reason, within an SQL-statement, need to link two fields using LIKE (instead of =) then use this syntax:
<source lang="sql">
SomeField LIKE REPLACE(REPLACE(REPLACE(SomeOtherField,'@','@@')'_','@_')'%','@%')
</source>

== 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 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''.

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

== Used data types ==
'''INTEGER''' The value is a signed integer, stored in 1, 2, 3, 4, 6, or 8 bytes depending on the magnitude of the value.
<br>'''REAL''' The value is a floating point value, stored as an 8-byte IEEE floating point number.
<br>'''TEXT''' The value is a text string, stored using the database encoding (UTF-16-LE).

== Structure explanation ==
The most important table is the ''Songs'' table, which is the starting point for all song-specific info. To allow rapid requests, most of the information is present in the table itself, e.g. the Artist name is spelled out.
The link between table Songs and other tables like Artists, Albums, ... happens with intermediary tables, e.g. ArtistsSongs. This allows us to assign multiple songs to one artist, AND multiple artists to one song.

The database contains custom events, called "triggers", that are executed when e.g. an artist is assigned to a track. For that example, the trigger will automatically increment the Artists table's Tracks counter field.

== Database tables ==
*[[Albums table|Albums]]: Contains all Albums and some Album specific info
*[[Artists table|Artists]]: Contains all Artists, AlbumArtists, Composers, Conductors and Lyricists with their track count
*[[ArtistsAlbums table|ArtistsAlbums]]: Specifies the relation between an Album and its AlbumArtist(s)
*[[ArtistsSongs table|ArtistsSongs]]: Specifies the relation between a Song and its Artist(s), Composer(s), Conductor(s) and Lyricist(s)
*[[Covers table|Covers]]
*[[DBInfo table|DBInfo]]
*[[DeviceFilters table|DeviceFilters]]
*[[DeviceTracks table|DeviceTracks]]
*[[Devices table|Devices]]
*[[Downloads table|Downloads]]
*[[Filters table|Filters]]: Contains all Filters/Views configured in MM
*[[Folders table|Folders]]
*[[FoldersHier table|FoldersHier]]
*[[Genres table|Genres]]: Contains all Genres with track Count
*[[GenresSongs table|GenresSongs]]: Specifies the relation between a Song and its Genre(s)
*[[LastTreePath table|LastTreePath]]
*[[Lists table|Lists]]: Contains all Classifications and their sort order in the tree
*[[ListsSongs table|ListsSongs]]: Specifies the relation between a Song and its various Classifications
*[[Medias table|Medias]]: Contains all the media sources that have been used
*[[OrganizeRules table|OrganizeRules]]
*[[PathProcessing table|PathProcessing]]
*[[Pinned table|Pinned]]: Stores links to Pinned items (Added in version 5.0)
*[[Played table|Played]]
*[[PlaylistSongs table|PlaylistSongs]] Specifies the relation between a Song and what '''Static Playlist(s)''' it appears in
*[[Playlists table|Playlists]] : Contains all Static Playlists and Auto-Playlists
*[[PodcastDirs table|PodcastDirs]]
*[[PodcastEpisodes table|PodcastEpisodes]] Specifies the relation between a Song and a Podcast
*[[Podcasts table|Podcasts]] Specifies podcast subscriptions
*[[Radio table|Radio]]: Stores links to the Radio node (Added in version 5.0)
*[[RemoteClients table|RemoteClients]]
*[[Songs table|Songs]] : Contains all songs with all their properties
*[[SynchAlbum table|SynchAlbum]]
*[[SynchArtist table|SynchArtist]]
*[[SynchLocation table|SynchLocation]]
*[[SynchPlaylist table|SynchPlaylist]]
*[[SynchPodcast table|SynchPodcast]]
*[[URLRequestCache table|URLRequestCache]]: Caches the results of some web requests.

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

[[Image:MM3DBStructure.PNG|center|650px]]

----

----

==MediaMonkey 2.5 and lower==

===Database structure===
[[Image:DatabaseRelationsMM2.gif|center|650px]]

===AddSongInfo===
''Value field is "TextData"''

'''DataType'''
{| border="2"
|-
! Value || AIF Code || Description
|-
| 100 || AIF_COPYRIGHT || Copyright
|-
| 101 || AIF_PUBLISHER || Publisher
|-
| 102 || AIF_ENCODER || Encoder
|-
| 103 || AIF_ENCODEDBY || Encoded By
|-
| 200 || AIF_LYRICIST || Lyricist
|-
| 201 || AIF_BAND || Band
|-
| 202 || AIF_CONDUCTOR || Conductor
|-
| 203 || AIF_REMIXER || Remixer
|-
| 204 || AIF_INVOLVEDPEOPLE || Involved People
|-
| 205 || AIF_MUSICCOMPOSER || (See note)
|-
| 300 || AIF_ORIGTITLE || Original Title
|-
| 301 || AIF_ORIGARTIST || Original Artist
|-
| 302 || AIF_ORIGLYRICIST || Original Lyricist
|-
| 400 || AIF_GROUPDESC ||
|-
| 401 || AIF_SUBTITLE ||
|-
| 402 || AIF_ISRC ||
|-
| 500 || AIF_INITIALKEY ||
|-
| 501 || AIF_LANGUAGE ||
|-
| 502 || AIF_MEDIATYPE ||
|-
| 503 || AIF_RATINGSTRING ||
|-
| 1000 || AIF_WEB_COMMERCIAL ||
|-
| 1001 || AIF_WEB_COPYRIGHT ||
|-
| 1002 || AIF_WEB_FILEPAGE ||
|-
| 1003 || AIF_WEB_ARTIST ||
|-
| 1004 || AIF_WEB_SOURCE ||
|-
| 1005 || AIF_WEB_RADIO ||
|-
| 1006 || AIF_WEB_PAYMENT ||
|-
| 1007 || AIF_WEB_PUBLISHER ||
|-
| 1100 || AIF_WEB_USER ||
|}

Note: Apparently, the value for the composer is stored in the Author field of the Songs table rather than in the AddSongInfo table under MediaMonkey 2.5. The situation in other versions is unknown.

===AddSongInfoInt===
''Value field is "IntData"'' (linked to Lists.ID)

'''DataType''' (partially linked to Lists.IDListType)
{| border="2"
|-
! Value || AIF Code || Description
|-
| 10000 || AIF_ORIGYEAR || Original Year
|-
| 10101 || AIF_TEMPO || Tempo
|-
| 10102 || AIF_MOOD || Mood
|-
| 10103 || AIF_OCCASION || Occasion
|-
| 10104 || AIF_QUALITY || Quality
|}
<references/>

===Memos===
''Value field is "MemoText"''

'''MemoType'''
{| border="2"
|-
! Value || AIF Code || Description
|-
| 20000 || AIF_LYRICS || Lyrics
|-
| 20001 || AIF_COMMENT || Comment
|}

Database Structure

2024-04-11T19:42:32Z

Drakinite: Added MM5+ database location and some cleanup

{{DatabaseTablesList}}
== Database type ==
[http://www.sqlite.org SQLite] version 3
* Encoding: UTF-16le
* Text collate IUNICODE (except where indicated with a (*))

== Additions to SQLite ==
Check out [http://www.sqlite.org/docs.html SQLite documentation]. MediaMonkey adds some more functions that you can use in SQL queries:

=== Collations ===
* IUNICODE - Unicode language neutral case insensitive (Post [http://www.mediamonkey.com/forum/viewtopic.php?p=127635#127635 1] [http://www.mediamonkey.com/forum/viewtopic.php?p=79915#79915 2] by Jiri with more detail)
* USERLOCALE - Sorts according to users locale in regional settings. (Implemented in 3.1.2.1279)
* NUMERICSTRING - Natural song order respecting numbers stored as strings. Useful for Track# and Disc# fields.

Due the customized collations MediaMonkey for Windows extension Library can be downloaded from
http://www.happymonkeying.com/beta/SQLite3MMExt.dll and then used in any app that can load and use external extension like
free Database Browser for SQLite

=== Functions ===
* HASSUBFOLDERS(string) - Used internally by MediaMonkey.
* INSTR(string1, string2) - Returns 1-based index of the first occurrence of string2 in string1, if not found 0 is returned. Case sensitive.
* LIKE(string1, string2) - Used to replace internal SQLite LIKE operator with one that supports Unicode strings. SEE NOTE!
* NEXTPATHPART(string) - Used internally by MediaMonkey.
* SIN(number) - Mathematical sinus function.
* STRICOMPW(string1, string2) - Compares two Unicode strings, case insensitive.
* UPPERW(string) - Unicode string upper case.
* GETEXTENSION(string) - Returns the extension from a filename. (Introduced in MM 3.1)
* SOUNDEX(string) - Returns a four-character string, based on how the word is pronounced in English. Similar spelled names are supposed to returns the same string. (Introduced in MM 3.1)

==== Note regarding LIKE ====
This MM-specific implementation of LIKE, automatically uses the @-sign as the escape character and it is always applied.
It means that you need to modify the SearchString to correctly use this function.

Here is one example of an VBScript function which prepares the search string correctly.
<source lang="vb">
Function FixLikeSearchString(Str)
Str = Replace(Str,"@","@@")
Str = Replace(Str,"_","@_")
Str = Replace(Str,"%","@%")
Str = Replace(Str,"'","''") '<--- Single quotes are escaped with another single quote
FixLikeSearchString=Str
End Function
</source>

If you for some reason, within an SQL-statement, need to link two fields using LIKE (instead of =) then use this syntax:
<source lang="sql">
SomeField LIKE REPLACE(REPLACE(REPLACE(SomeOtherField,'@','@@')'_','@_')'%','@%')
</source>

== 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 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''.

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

== Used data types ==
'''INTEGER''' The value is a signed integer, stored in 1, 2, 3, 4, 6, or 8 bytes depending on the magnitude of the value.
<br>'''REAL''' The value is a floating point value, stored as an 8-byte IEEE floating point number.
<br>'''TEXT''' The value is a text string, stored using the database encoding (UTF-16-LE).

== Structure explanation ==
The most important table is the ''Songs'' table, which is the starting point for all song-specific info. To allow rapid requests, most of the information is present in the table itself, e.g. the Artist name is spelled out.
The link between table Songs and other tables like Artists, Albums, ... happens with intermediary tables, e.g. ArtistsSongs. This allows us to assign multiple songs to one artist, AND multiple artists to one song.

The database contains custom events, called "triggers", that are executed when e.g. an artist is assigned to a track. For that example, the trigger will automatically increment the Artists table's Tracks counter field.

== Database tables ==
*[[Albums table|Albums]]: Contains all Albums and some Album specific info
*[[Artists table|Artists]]: Contains all Artists, AlbumArtists, Composers, Conductors and Lyricists with their track count
*[[ArtistsAlbums table|ArtistsAlbums]]: Specifies the relation between an Album and its AlbumArtist(s)
*[[ArtistsSongs table|ArtistsSongs]]: Specifies the relation between a Song and its Artist(s), Composer(s), Conductor(s) and Lyricist(s)
*[[Covers table|Covers]]
*[[DBInfo table|DBInfo]]
*[[DeviceFilters table|DeviceFilters]]
*[[DeviceTracks table|DeviceTracks]]
*[[Devices table|Devices]]
*[[Downloads table|Downloads]]
*[[Filters table|Filters]]: Contains all Filters/Views configured in MM
*[[Folders table|Folders]]
*[[FoldersHier table|FoldersHier]]
*[[Genres table|Genres]]: Contains all Genres with track Count
*[[GenresSongs table|GenresSongs]]: Specifies the relation between a Song and its Genre(s)
*[[LastTreePath table|LastTreePath]]
*[[Lists table|Lists]]: Contains all Classifications and their sort order in the tree
*[[ListsSongs table|ListsSongs]]: Specifies the relation between a Song and its various Classifications
*[[Medias table|Medias]]: Contains all the media sources that have been used
*[[OrganizeRules table|OrganizeRules]]
*[[PathProcessing table|PathProcessing]]
*[[Pinned table|Pinned]]: Stores links to Pinned items (Added in version 5.0)
*[[Played table|Played]]
*[[PlaylistSongs table|PlaylistSongs]] Specifies the relation between a Song and what '''Static Playlist(s)''' it appears in
*[[Playlists table|Playlists]] : Contains all Static Playlists and Auto-Playlists
*[[PodcastDirs table|PodcastDirs]]
*[[PodcastEpisodes table|PodcastEpisodes]] Specifies the relation between a Song and a Podcast
*[[Podcasts table|Podcasts]] Specifies podcast subscriptions
*[[Radio table|Radio]]: Stores links to the Radio node (Added in version 5.0)
*[[RemoteClients table|RemoteClients]]
*[[Songs table|Songs]] : Contains all songs with all their properties
*[[SynchAlbum table|SynchAlbum]]
*[[SynchArtist table|SynchArtist]]
*[[SynchLocation table|SynchLocation]]
*[[SynchPlaylist table|SynchPlaylist]]
*[[SynchPodcast table|SynchPodcast]]
*[[URLRequestCache table|URLRequestCache]]: Caches the results of some web requests.

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

[[Image:MM3DBStructure.PNG|center|650px]]

----

----

==MediaMonkey 2.5 and lower==

===Database structure===
[[Image:DatabaseRelationsMM2.gif|center|650px]]

===AddSongInfo===
''Value field is "TextData"''

'''DataType'''
{| border="2"
|-
! Value || AIF Code || Description
|-
| 100 || AIF_COPYRIGHT || Copyright
|-
| 101 || AIF_PUBLISHER || Publisher
|-
| 102 || AIF_ENCODER || Encoder
|-
| 103 || AIF_ENCODEDBY || Encoded By
|-
| 200 || AIF_LYRICIST || Lyricist
|-
| 201 || AIF_BAND || Band
|-
| 202 || AIF_CONDUCTOR || Conductor
|-
| 203 || AIF_REMIXER || Remixer
|-
| 204 || AIF_INVOLVEDPEOPLE || Involved People
|-
| 205 || AIF_MUSICCOMPOSER || (See note)
|-
| 300 || AIF_ORIGTITLE || Original Title
|-
| 301 || AIF_ORIGARTIST || Original Artist
|-
| 302 || AIF_ORIGLYRICIST || Original Lyricist
|-
| 400 || AIF_GROUPDESC ||
|-
| 401 || AIF_SUBTITLE ||
|-
| 402 || AIF_ISRC ||
|-
| 500 || AIF_INITIALKEY ||
|-
| 501 || AIF_LANGUAGE ||
|-
| 502 || AIF_MEDIATYPE ||
|-
| 503 || AIF_RATINGSTRING ||
|-
| 1000 || AIF_WEB_COMMERCIAL ||
|-
| 1001 || AIF_WEB_COPYRIGHT ||
|-
| 1002 || AIF_WEB_FILEPAGE ||
|-
| 1003 || AIF_WEB_ARTIST ||
|-
| 1004 || AIF_WEB_SOURCE ||
|-
| 1005 || AIF_WEB_RADIO ||
|-
| 1006 || AIF_WEB_PAYMENT ||
|-
| 1007 || AIF_WEB_PUBLISHER ||
|-
| 1100 || AIF_WEB_USER ||
|}

Note: Apparently, the value for the composer is stored in the Author field of the Songs table rather than in the AddSongInfo table under MediaMonkey 2.5. The situation in other versions is unknown.

===AddSongInfoInt===
''Value field is "IntData"'' (linked to Lists.ID)

'''DataType''' (partially linked to Lists.IDListType)
{| border="2"
|-
! Value || AIF Code || Description
|-
| 10000 || AIF_ORIGYEAR || Original Year
|-
| 10101 || AIF_TEMPO || Tempo
|-
| 10102 || AIF_MOOD || Mood
|-
| 10103 || AIF_OCCASION || Occasion
|-
| 10104 || AIF_QUALITY || Quality
|}
<references/>

===Memos===
''Value field is "MemoText"''

'''MemoType'''
{| border="2"
|-
! Value || AIF Code || Description
|-
| 20000 || AIF_LYRICS || Lyrics
|-
| 20001 || AIF_COMMENT || Comment
|}

URLRequestCache table

2024-04-11T19:30:08Z

Drakinite: Created page with "{{DatabaseTablesList}} This table was added in version 5.0. == Fields == {| border="1" |- ! Name ! Value Type ! Possible Values ! Description |- | '''ID''' | INTEGER | | |- | '''URL''' | TEXT | http://mb.mediamonkey.com:5000/ws/2/artist/?query=... | The URL of the web request |- | '''Response''' | TEXT | {"created":"2023-12-05T13:01:15.203Z","artists":[{"release-... | The response of the web request |- | '''CachedTime''' | REAL | 2024-04-10 17:42:33 | The time the requ..."

{{DatabaseTablesList}}
This table was added in version 5.0.
== Fields ==
{| border="1"
|-
! Name
! Value Type
! Possible Values
! Description
|-
| '''ID'''
| INTEGER
|
|
|-
| '''URL'''
| TEXT
| http://mb.mediamonkey.com:5000/ws/2/artist/?query=...
| The URL of the web request
|-
| '''Response'''
| TEXT
| {"created":"2023-12-05T13:01:15.203Z","artists":[{"release-...
| The response of the web request
|-
| '''CachedTime'''
| REAL
| 2024-04-10 17:42:33
| The time the request was cached. Formatted as an ISO string.
|}

Pinned table

2024-04-11T19:25:04Z

Drakinite: added examples

{{DatabaseTablesList}}
This table was added in version 5.0.
== Fields ==
{| border="1"
|-
! Name
! Value Type
! Possible Values
! Description
|-
| '''type'''
| TEXT*
| folder
| The type of object being pinned
|-
| '''type_id'''
| INTEGER
|
| The numerical database id of the pinned item, if it has one
|-
| '''coll_id'''
| INTEGER
|
|
|-
| '''string_type_id'''
| TEXT*
| C:\Users\<USERNAME>\Music
| String representation of the pinned item, if it doesn't have a numerical ID
|}

Radio table

2024-04-11T19:15:56Z

Drakinite: Created page

{{DatabaseTablesList}}
This table was added in version 5.0.
== Fields ==
{| border="1"
|-
! Name
! Value Type
! Possible Values
! Description
|-
| '''ID'''
| INTEGER
|
|
|-
| '''ParentID'''
| INTEGER
|
|
|-
| '''Name'''
| TEXT
|
| Internet Radio
|-
| '''URL'''
| TEXT
|
| https://www.internet-radio.com/
|}

Database Structure (MM4)

2024-04-11T19:02:16Z

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

#REDIRECT [[Database Structure]]

Database Structure

2024-04-11T19:02:16Z

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

{{DatabaseTablesList}}
== Database type ==
[http://www.sqlite.org SQLite] version 3
* Encoding: UTF-16le
* Text collate IUNICODE (except where indicated with a (*))

== Additions to SQLite ==
Check out [http://www.sqlite.org/docs.html SQLite documentation]. MediaMonkey adds some more functions that you can use in SQL queries:

=== Collations ===
* IUNICODE - Unicode language neutral case insensitive (Post [http://www.mediamonkey.com/forum/viewtopic.php?p=127635#127635 1] [http://www.mediamonkey.com/forum/viewtopic.php?p=79915#79915 2] by Jiri with more detail)
* USERLOCALE - Sorts according to users locale in regional settings. (Implemented in 3.1.2.1279)
* NUMERICSTRING - Natural song order respecting numbers stored as strings. Useful for Track# and Disc# fields.

Due the customized collations MediaMonkey for Windows extension Library can be downloaded from
http://www.happymonkeying.com/beta/SQLite3MMExt.dll and then used in any app that can load and use external extension like
free Database Browser for SQLite

=== Functions ===
* HASSUBFOLDERS(string) - Used internally by MediaMonkey.
* INSTR(string1, string2) - Returns 1-based index of the first occurrence of string2 in string1, if not found 0 is returned. Case sensitive.
* LIKE(string1, string2) - Used to replace internal SQLite LIKE operator with one that supports Unicode strings. SEE NOTE!
* NEXTPATHPART(string) - Used internally by MediaMonkey.
* SIN(number) - Mathematical sinus function.
* STRICOMPW(string1, string2) - Compares two Unicode strings, case insensitive.
* UPPERW(string) - Unicode string upper case.
* GETEXTENSION(string) - Returns the extension from a filename. (Introduced in MM 3.1)
* SOUNDEX(string) - Returns a four-character string, based on how the word is pronounced in English. Similar spelled names are supposed to returns the same string. (Introduced in MM 3.1)

==== Note regarding LIKE ====
This MM-specific implementation of LIKE, automatically uses the @-sign as the escape character and it is always applied.
It means that you need to modify the SearchString to correctly use this function.

Here is one example of an VBScript function which prepares the search string correctly.
<source lang="vb">
Function FixLikeSearchString(Str)
Str = Replace(Str,"@","@@")
Str = Replace(Str,"_","@_")
Str = Replace(Str,"%","@%")
Str = Replace(Str,"'","''") '<--- Single quotes are escaped with another single quote
FixLikeSearchString=Str
End Function
</source>

If you for some reason, within an SQL-statement, need to link two fields using LIKE (instead of =) then use this syntax:
<source lang="sql">
SomeField LIKE REPLACE(REPLACE(REPLACE(SomeOtherField,'@','@@')'_','@_')'%','@%')
</source>

== Default Mediamonkey 3 and MediaMonkey 4 Database location ==
'''Windows XP:''' C:\Documents and Settings\<USERNAME>\Local Settings\Application Data\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''.

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

== Used data types ==
'''INTEGER''' The value is a signed integer, stored in 1, 2, 3, 4, 6, or 8 bytes depending on the magnitude of the value.
<br>'''REAL''' The value is a floating point value, stored as an 8-byte IEEE floating point number.
<br>'''TEXT''' The value is a text string, stored using the database encoding (UTF-16-LE).

== Structure explanation ==
The most important table is the ''Songs'' table, which is the starting point for all song-specific info. To allow rapid requests, most of the information is present in the table itself, e.g. the Artist name is spelled out.
The link between table Songs and other tables like Artists, Albums, ... happens with intermediary tables, e.g. ArtistsSongs. This allows us to assign multiple songs to one artist, AND multiple artists to one song.

The database contains custom events, called "triggers", that are executed when e.g. an artist is assigned to a track. For that example, the trigger will automatically increment the Artists table's Tracks counter field.

== Database tables ==
*[[Albums table|Albums]]: Contains all Albums and some Album specific info
*[[Artists table|Artists]]: Contains all Artists, AlbumArtists, Composers, Conductors and Lyricists with their track count
*[[ArtistsAlbums table|ArtistsAlbums]]: Specifies the relation between an Album and its AlbumArtist(s)
*[[ArtistsSongs table|ArtistsSongs]]: Specifies the relation between a Song and its Artist(s), Composer(s), Conductor(s) and Lyricist(s)
*[[Covers table|Covers]]
*[[DBInfo table|DBInfo]]
*[[DeviceFilters table|DeviceFilters]]
*[[DeviceTracks table|DeviceTracks]]
*[[Devices table|Devices]]
*[[Downloads table|Downloads]]
*[[Filters table|Filters]]: Contains all Filters/Views configured in MM
*[[Folders table|Folders]]
*[[FoldersHier table|FoldersHier]]
*[[Genres table|Genres]]: Contains all Genres with track Count
*[[GenresSongs table|GenresSongs]]: Specifies the relation between a Song and its Genre(s)
*[[LastTreePath table|LastTreePath]]
*[[Lists table|Lists]]: Contains all Classifications and their sort order in the tree
*[[ListsSongs table|ListsSongs]]: Specifies the relation between a Song and its various Classifications
*[[Medias table|Medias]]: Contains all the media sources that have been used
*[[OrganizeRules table|OrganizeRules]]
*[[PathProcessing table|PathProcessing]]
*[[Pinned table|Pinned]]: Stores links to Pinned items (Added in version 5.0)
*[[Played table|Played]]
*[[PlaylistSongs table|PlaylistSongs]] Specifies the relation between a Song and what '''Static Playlist(s)''' it appears in
*[[Playlists table|Playlists]] : Contains all Static Playlists and Auto-Playlists
*[[PodcastDirs table|PodcastDirs]]
*[[PodcastEpisodes table|PodcastEpisodes]] Specifies the relation between a Song and a Podcast
*[[Podcasts table|Podcasts]] Specifies podcast subscriptions
*[[Radio table|Radio]]: Stores links to the Radio node (Added in version 5.0)
*[[RemoteClients table|RemoteClients]]
*[[Songs table|Songs]] : Contains all songs with all their properties
*[[SynchAlbum table|SynchAlbum]]
*[[SynchArtist table|SynchArtist]]
*[[SynchLocation table|SynchLocation]]
*[[SynchPlaylist table|SynchPlaylist]]
*[[SynchPodcast table|SynchPodcast]]
*[[URLRequestCache table|URLRequestCache]]: Caches the results of some web requests.

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

[[Image:MM3DBStructure.PNG|center|650px]]

----

----

==MediaMonkey v2.5 and lower==

===Database structure===
[[Image:DatabaseRelationsMM2.gif|center|650px]]

===AddSongInfo===
''Value field is "TextData"''

'''DataType'''
{| border="2"
|-
! Value || AIF Code || Description
|-
| 100 || AIF_COPYRIGHT || Copyright
|-
| 101 || AIF_PUBLISHER || Publisher
|-
| 102 || AIF_ENCODER || Encoder
|-
| 103 || AIF_ENCODEDBY || Encoded By
|-
| 200 || AIF_LYRICIST || Lyricist
|-
| 201 || AIF_BAND || Band
|-
| 202 || AIF_CONDUCTOR || Conductor
|-
| 203 || AIF_REMIXER || Remixer
|-
| 204 || AIF_INVOLVEDPEOPLE || Involved People
|-
| 205 || AIF_MUSICCOMPOSER || (See note)
|-
| 300 || AIF_ORIGTITLE || Original Title
|-
| 301 || AIF_ORIGARTIST || Original Artist
|-
| 302 || AIF_ORIGLYRICIST || Original Lyricist
|-
| 400 || AIF_GROUPDESC ||
|-
| 401 || AIF_SUBTITLE ||
|-
| 402 || AIF_ISRC ||
|-
| 500 || AIF_INITIALKEY ||
|-
| 501 || AIF_LANGUAGE ||
|-
| 502 || AIF_MEDIATYPE ||
|-
| 503 || AIF_RATINGSTRING ||
|-
| 1000 || AIF_WEB_COMMERCIAL ||
|-
| 1001 || AIF_WEB_COPYRIGHT ||
|-
| 1002 || AIF_WEB_FILEPAGE ||
|-
| 1003 || AIF_WEB_ARTIST ||
|-
| 1004 || AIF_WEB_SOURCE ||
|-
| 1005 || AIF_WEB_RADIO ||
|-
| 1006 || AIF_WEB_PAYMENT ||
|-
| 1007 || AIF_WEB_PUBLISHER ||
|-
| 1100 || AIF_WEB_USER ||
|}

Note: Apparently, the value for the composer is stored in the Author field of the Songs table rather than in the AddSongInfo table under MediaMonkey 2.5. The situation in other versions is unknown.

===AddSongInfoInt===
''Value field is "IntData"'' (linked to Lists.ID)

'''DataType''' (partially linked to Lists.IDListType)
{| border="2"
|-
! Value || AIF Code || Description
|-
| 10000 || AIF_ORIGYEAR || Original Year
|-
| 10101 || AIF_TEMPO || Tempo
|-
| 10102 || AIF_MOOD || Mood
|-
| 10103 || AIF_OCCASION || Occasion
|-
| 10104 || AIF_QUALITY || Quality
|}
<references/>

===Memos===
''Value field is "MemoText"''

'''MemoType'''
{| border="2"
|-
! Value || AIF Code || Description
|-
| 20000 || AIF_LYRICS || Lyrics
|-
| 20001 || AIF_COMMENT || Comment
|}

Pinned table

2024-04-11T18:58:52Z

Drakinite: Created page

{{DatabaseTablesList}}
This table was added in version 5.0.
== Fields ==
{| border="1"
|-
! Name
! Value Type
! Possible Values
! Description
|-
| '''type'''
| TEXT*
|
|
|-
| '''type_id'''
| INTEGER
|
|
|-
| '''coll_id'''
| INTEGER
|
|
|-
| '''string_type_id'''
| TEXT*
|
|
|}

Database Structure

2024-04-11T16:46:35Z

Drakinite:

{{DatabaseTablesList}}
== Database type ==
[http://www.sqlite.org SQLite] version 3
* Encoding: UTF-16le
* Text collate IUNICODE (except where indicated with a (*))

== Additions to SQLite ==
Check out [http://www.sqlite.org/docs.html SQLite documentation]. MediaMonkey adds some more functions that you can use in SQL queries:

=== Collations ===
* IUNICODE - Unicode language neutral case insensitive (Post [http://www.mediamonkey.com/forum/viewtopic.php?p=127635#127635 1] [http://www.mediamonkey.com/forum/viewtopic.php?p=79915#79915 2] by Jiri with more detail)
* USERLOCALE - Sorts according to users locale in regional settings. (Implemented in 3.1.2.1279)
* NUMERICSTRING - Natural song order respecting numbers stored as strings. Useful for Track# and Disc# fields.

Due the customized collations MediaMonkey for Windows extension Library can be downloaded from
http://www.happymonkeying.com/beta/SQLite3MMExt.dll and then used in any app that can load and use external extension like
free Database Browser for SQLite

=== Functions ===
* HASSUBFOLDERS(string) - Used internally by MediaMonkey.
* INSTR(string1, string2) - Returns 1-based index of the first occurrence of string2 in string1, if not found 0 is returned. Case sensitive.
* LIKE(string1, string2) - Used to replace internal SQLite LIKE operator with one that supports Unicode strings. SEE NOTE!
* NEXTPATHPART(string) - Used internally by MediaMonkey.
* SIN(number) - Mathematical sinus function.
* STRICOMPW(string1, string2) - Compares two Unicode strings, case insensitive.
* UPPERW(string) - Unicode string upper case.
* GETEXTENSION(string) - Returns the extension from a filename. (Introduced in MM 3.1)
* SOUNDEX(string) - Returns a four-character string, based on how the word is pronounced in English. Similar spelled names are supposed to returns the same string. (Introduced in MM 3.1)

==== Note regarding LIKE ====
This MM-specific implementation of LIKE, automatically uses the @-sign as the escape character and it is always applied.
It means that you need to modify the SearchString to correctly use this function.

Here is one example of an VBScript function which prepares the search string correctly.
<source lang="vb">
Function FixLikeSearchString(Str)
Str = Replace(Str,"@","@@")
Str = Replace(Str,"_","@_")
Str = Replace(Str,"%","@%")
Str = Replace(Str,"'","''") '<--- Single quotes are escaped with another single quote
FixLikeSearchString=Str
End Function
</source>

If you for some reason, within an SQL-statement, need to link two fields using LIKE (instead of =) then use this syntax:
<source lang="sql">
SomeField LIKE REPLACE(REPLACE(REPLACE(SomeOtherField,'@','@@')'_','@_')'%','@%')
</source>

== Default Mediamonkey 3 and MediaMonkey 4 Database location ==
'''Windows XP:''' C:\Documents and Settings\<USERNAME>\Local Settings\Application Data\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''.

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

== Used data types ==
'''INTEGER''' The value is a signed integer, stored in 1, 2, 3, 4, 6, or 8 bytes depending on the magnitude of the value.
<br>'''REAL''' The value is a floating point value, stored as an 8-byte IEEE floating point number.
<br>'''TEXT''' The value is a text string, stored using the database encoding (UTF-16-LE).

== Structure explanation ==
The most important table is the ''Songs'' table, which is the starting point for all song-specific info. To allow rapid requests, most of the information is present in the table itself, e.g. the Artist name is spelled out.
The link between table Songs and other tables like Artists, Albums, ... happens with intermediary tables, e.g. ArtistsSongs. This allows us to assign multiple songs to one artist, AND multiple artists to one song.

The database contains custom events, called "triggers", that are executed when e.g. an artist is assigned to a track. For that example, the trigger will automatically increment the Artists table's Tracks counter field.

== Database tables ==
*[[Albums table|Albums]]: Contains all Albums and some Album specific info
*[[Artists table|Artists]]: Contains all Artists, AlbumArtists, Composers, Conductors and Lyricists with their track count
*[[ArtistsAlbums table|ArtistsAlbums]]: Specifies the relation between an Album and its AlbumArtist(s)
*[[ArtistsSongs table|ArtistsSongs]]: Specifies the relation between a Song and its Artist(s), Composer(s), Conductor(s) and Lyricist(s)
*[[Covers table|Covers]]
*[[DBInfo table|DBInfo]]
*[[DeviceFilters table|DeviceFilters]]
*[[DeviceTracks table|DeviceTracks]]
*[[Devices table|Devices]]
*[[Downloads table|Downloads]]
*[[Filters table|Filters]]: Contains all Filters/Views configured in MM
*[[Folders table|Folders]]
*[[FoldersHier table|FoldersHier]]
*[[Genres table|Genres]]: Contains all Genres with track Count
*[[GenresSongs table|GenresSongs]]: Specifies the relation between a Song and its Genre(s)
*[[LastTreePath table|LastTreePath]]
*[[Lists table|Lists]]: Contains all Classifications and their sort order in the tree
*[[ListsSongs table|ListsSongs]]: Specifies the relation between a Song and its various Classifications
*[[Medias table|Medias]]: Contains all the media sources that have been used
*[[OrganizeRules table|OrganizeRules]]
*[[PathProcessing table|PathProcessing]]
*[[Pinned table|Pinned]]: Stores links to Pinned items (Added in version 5.0)
*[[Played table|Played]]
*[[PlaylistSongs table|PlaylistSongs]] Specifies the relation between a Song and what '''Static Playlist(s)''' it appears in
*[[Playlists table|Playlists]] : Contains all Static Playlists and Auto-Playlists
*[[PodcastDirs table|PodcastDirs]]
*[[PodcastEpisodes table|PodcastEpisodes]] Specifies the relation between a Song and a Podcast
*[[Podcasts table|Podcasts]] Specifies podcast subscriptions
*[[Radio table|Radio]]: Stores links to the Radio node (Added in version 5.0)
*[[RemoteClients table|RemoteClients]]
*[[Songs table|Songs]] : Contains all songs with all their properties
*[[SynchAlbum table|SynchAlbum]]
*[[SynchArtist table|SynchArtist]]
*[[SynchLocation table|SynchLocation]]
*[[SynchPlaylist table|SynchPlaylist]]
*[[SynchPodcast table|SynchPodcast]]
*[[URLRequestCache table|URLRequestCache]]: Caches the results of some web requests.

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

[[Image:MM3DBStructure.PNG|center|650px]]

----

----

==MediaMonkey v2.5 and lower==

===Database structure===
[[Image:DatabaseRelationsMM2.gif|center|650px]]

===AddSongInfo===
''Value field is "TextData"''

'''DataType'''
{| border="2"
|-
! Value || AIF Code || Description
|-
| 100 || AIF_COPYRIGHT || Copyright
|-
| 101 || AIF_PUBLISHER || Publisher
|-
| 102 || AIF_ENCODER || Encoder
|-
| 103 || AIF_ENCODEDBY || Encoded By
|-
| 200 || AIF_LYRICIST || Lyricist
|-
| 201 || AIF_BAND || Band
|-
| 202 || AIF_CONDUCTOR || Conductor
|-
| 203 || AIF_REMIXER || Remixer
|-
| 204 || AIF_INVOLVEDPEOPLE || Involved People
|-
| 205 || AIF_MUSICCOMPOSER || (See note)
|-
| 300 || AIF_ORIGTITLE || Original Title
|-
| 301 || AIF_ORIGARTIST || Original Artist
|-
| 302 || AIF_ORIGLYRICIST || Original Lyricist
|-
| 400 || AIF_GROUPDESC ||
|-
| 401 || AIF_SUBTITLE ||
|-
| 402 || AIF_ISRC ||
|-
| 500 || AIF_INITIALKEY ||
|-
| 501 || AIF_LANGUAGE ||
|-
| 502 || AIF_MEDIATYPE ||
|-
| 503 || AIF_RATINGSTRING ||
|-
| 1000 || AIF_WEB_COMMERCIAL ||
|-
| 1001 || AIF_WEB_COPYRIGHT ||
|-
| 1002 || AIF_WEB_FILEPAGE ||
|-
| 1003 || AIF_WEB_ARTIST ||
|-
| 1004 || AIF_WEB_SOURCE ||
|-
| 1005 || AIF_WEB_RADIO ||
|-
| 1006 || AIF_WEB_PAYMENT ||
|-
| 1007 || AIF_WEB_PUBLISHER ||
|-
| 1100 || AIF_WEB_USER ||
|}

Note: Apparently, the value for the composer is stored in the Author field of the Songs table rather than in the AddSongInfo table under MediaMonkey 2.5. The situation in other versions is unknown.

===AddSongInfoInt===
''Value field is "IntData"'' (linked to Lists.ID)

'''DataType''' (partially linked to Lists.IDListType)
{| border="2"
|-
! Value || AIF Code || Description
|-
| 10000 || AIF_ORIGYEAR || Original Year
|-
| 10101 || AIF_TEMPO || Tempo
|-
| 10102 || AIF_MOOD || Mood
|-
| 10103 || AIF_OCCASION || Occasion
|-
| 10104 || AIF_QUALITY || Quality
|}
<references/>

===Memos===
''Value field is "MemoText"''

'''MemoType'''
{| border="2"
|-
! Value || AIF Code || Description
|-
| 20000 || AIF_LYRICS || Lyrics
|-
| 20001 || AIF_COMMENT || Comment
|}

Songs table

2024-04-11T16:45:17Z

Drakinite: {{DatabaseTablesList}}, formattting, added missing Extension field

{{DatabaseTablesList}}
== Fields ==
{| border="1"
|-
! Name
! Value Type
! Possible Values
! Description
!
! SongData Name
! SongData Type
! SongData Description
|-
| '''ID'''
| INTEGER
| AUTOINCREMENT (1 to inf.)
|
|
| [[ISDBSongData::ID |ID ]]
| Property Get/Let
|
|-
| '''Artist'''
| TEXT
|
|
|
| [[ISDBSongData::ArtistName |ArtistName ]]
| Property Get/Let
|
|-
| '''IDAlbum'''
| INTEGER
|
|
|
|
|
|
|-
| '''Album'''
| TEXT
|
|
|
| [[ISDBSongData::AlbumName |AlbumName ]]
| Property Get/Let
|
|-
| '''AlbumArtist'''
| TEXT
|
|
|
| [[ISDBSongData::AlbumArtistName |AlbumArtistName ]]
| Property Get/Let
|
|-
| '''DiscNumber'''
| TEXT
|
|
|
| [[ISDBSongData::DiscNumberStr |DiscNumberStr ]]
| Property Get/Let
|
|-
| '''TrackNumber'''
| TEXT
|
|
|
| [[ISDBSongData::TrackOrderStr |TrackOrderStr ]]
| Property Get/Let
|
|-
| '''SongTitle'''
| TEXT
|
|
|
| [[ISDBSongData::Title |Title ]]
| Property Get/Let
|
|-
| '''SongPath'''
| TEXT
|
|
|
| [[ISDBSongData::Path |Path ]]
| Property Get/Let
|
|-
| '''Extension'''
| TEXT*
| 5 characters max
|
|
|
|
|
|-
| '''Year'''
| INTEGER
| 2010
|
|
| [[ISDBSongData::Year |Year ]]
| Property Get/Let
|
|-
| '''Date'''
| INTEGER
| 20100930
|
|
|
|
|
|-
| '''Genre'''
| TEXT
|
|
|
| [[ISDBSongData::Genre |Genre ]]
| Property Get/Let
|
|-
| '''FileLength'''
| INTEGER
|
|
|
| [[ISDBSongData::FileLength |FileLength ]]
| Property Get/Let
|
|-
| '''SongLength'''
| INTEGER
|
|
|
| [[ISDBSongData::SongLength |SongLength ]]
| Property Get/Let
|
|-
| '''IDMedia'''
| INTEGER
|
|
|
| [[ISDBSongData::Media |Media ]]
| Property Get
|
|-
| '''CacheStatus'''
| INTEGER
|
|
|
| [[ISDBSongData::Cached |Cached ]]
| Property Get/Let
|
|-
| '''CacheName'''
| TEXT
|
|
|
| [[ISDBSongData::CachedPath |CachedPath ]]
| Property Get
|
|-
| '''Rating'''
| INTEGER
|
|
|
| [[ISDBSongData::Rating |Rating ]]
| Property Get/Let
|
|-
| '''Bitrate'''
| INTEGER
|
|
|
| [[ISDBSongData::Bitrate |Bitrate ]]
| Property Get/Let
|
|-
| '''TrackType'''
| INTEGER
| Music = 0, Podcast = 1, Audiobook = 2
| Added in version 3.1
|
|
|
|
|-
| '''IDEpisode'''
| INTEGER
| Corresponds to PodcastsEpisodes.ID
| Added in version 3.1
|
|
|
|
|-
| '''Broadcast'''
| INTEGER
|
|
|
|
|
|
|-
| '''PreviewState'''
| INTEGER
|
|
|
|
|
|
|-
| '''PreviewName'''
| TEXT
|
|
|
| [[ISDBSongData::PreviewPath |PreviewPath ]]
| Property Get
|
|-
| '''PreviewStartTime'''
| INTEGER
|
|
|
|
|
|
|-
| '''PreviewLength'''
| INTEGER
|
|
|
|
|
|
|-
| '''Author'''
| TEXT
|
| The Composer of the Song
|
| [[ISDBSongData::Author |Author ]]
| Property Get/Let
|
|-
| '''SamplingFrequency'''
| INTEGER
|
|
|
| [[ISDBSongData::SampleRate |SampleRate ]]
| Property Get/Let
|
|-
| '''Stereo'''
| INTEGER
|
|
|
| [[ISDBSongData::Channels |Channels ]]
| Property Get/Let
|
|-
| '''Copyrighted'''
| INTEGER
|
|
|
|
|
|
|-
| '''Original'''
| INTEGER
|
|
|
|
|
|
|-
| '''VBR'''
| INTEGER
|
|
|
| [[ISDBSongData::VBR |VBR ]]
| Property Get/Let
|
|-
| '''BPM'''
| INTEGER
|
| Beats Per Minute
|
| [[ISDBSongData::BPM |BPM ]]
| Property Get/Let
|
|-
| '''SignType'''
| INTEGER
|
|
|
|
|
|
|-
| '''SignPart1'''
| INTEGER
|
|
|
|
|
|
|-
| '''SignPart2'''
| INTEGER
|
|
|
|
|
|
|-
| '''SignPart3'''
| INTEGER
|
|
|
|
|
|
|-
| '''SignPart4'''
| INTEGER
|
|
|
|
|
|
|-
| '''PlayCounter'''
| INTEGER
|
|
|
| [[ISDBSongData::PlayCounter |PlayCounter ]]
| Property Get/Let
|
|-
| '''LastTimePlayed'''
| REAL
| UTC as Delphi TDateTime
|
|
| [[ISDBSongData::LastPlayed |LastPlayed ]]
| Property Get/Let
|
|-
| '''LastTimeSkipped'''
| REAL
| UTC as Delphi TDateTime
| Added in version 5.1
|
|
|
|
|-
| '''AudioCDTrack'''
| INTEGER
|
|
|
|
|
|
|-
| '''FileModified'''
| REAL
| UTC as Delphi TDateTime
|
|
| [[ISDBSongData::FileModified |FileModified ]]
| Property Get/Let
|
|-
| '''TrackModified'''
| REAL
| UTC as Delphi TDateTime
|
|
|
|
|
|-
| '''ArtworkModified'''
| REAL
| UTC as Delphi TDateTime
| Added in version 5.0
|
|
|
|
|-
| '''MaxSample'''
| REAL
|
|
|
|
|
|
|-
| '''NormalizeTrack'''
| REAL
|
| Track gain value (dB)
|
| [[ISDBSongData::Leveling |Leveling ]]
| Property Get/Let
|
|-
| '''NormalizeAlbum'''
| REAL
|
| Album gain value (dB)
|
| [[ISDBSongData::LevelingAlbum |LevelingAlbum ]]
| Property Get/Let
|
|-
| '''Custom1'''
| TEXT
|
|
|
| [[ISDBSongData::Custom1 |Custom1 ]]
| Property Get/Let
|
|-
| '''Custom2'''
| TEXT
|
|
|
| [[ISDBSongData::Custom2 |Custom2 ]]
| Property Get/Let
|
|-
| '''Custom3'''
| TEXT
|
|
|
| [[ISDBSongData::Custom3 |Custom3 ]]
| Property Get/Let
|
|-
| '''Custom4'''
| TEXT
|
|
|
| [[ISDBSongData::Custom4 |Custom4 ]]
| Property Get/Let
|
|-
| '''Custom5'''
| TEXT
|
|
|
| [[ISDBSongData::Custom5 |Custom5 ]]
| Property Get/Let
|
|-
| '''Custom6'''
| TEXT
|
| Added in version 5.0
|
|
|
|
|-
| '''Custom7'''
| TEXT
|
| Added in version 5.0
|
|
|
|
|-
| '''Custom8'''
| TEXT
|
| Added in version 5.0
|
|
|
|
|-
| '''Custom9'''
| TEXT
|
| Added in version 5.0
|
|
|
|
|-
| '''Custom10'''
| TEXT
|
| Added in version 5.0
|
|
|
|
|-
| '''DateAdded'''
| REAL
| UTC as Delphi TDateTime
|
|
| [[ISDBSongData::DateAdded |DateAdded ]]
| Property Get/Let
|
|-
| '''OrigFileLength'''
| INTEGER
|
|
|
|
|
|
|-
| '''PreGap'''
| INTEGER
|
|
|
| [[ISDBSongData::PreGap |PreGap ]]
| Property Get/Let
|
|-
| '''PostGap'''
| INTEGER
|
|
|
| [[ISDBSongData::PostGap |PostGap ]]
| Property Get/Let
|
|-
| '''TotalSamples'''
| INTEGER
|
|
|
| [[ISDBSongData::TotalSamples |TotalSamples ]]
| Property Get/Let
|
|-
| '''PlaybackPos'''
| INTEGER
|
|
|
| [[ISDBSongData::Bookmark |Bookmark ]]
| Property Get/Let
| To be confirmed
|-
| '''GaplessBytes'''
| INTEGER
|
|
|
| [[ISDBSongData::GaplessBytes |GaplessBytes ]]
| Property Get/Let
|
|-
| '''IDFolder'''
| INTEGER
|
|
|
|
|
|
|-
| '''Copyright'''
| TEXT
|
|
|
| [[ISDBSongData::Copyright |Copyright ]]
| Property Get/Let
|
|-
| '''Publisher'''
| TEXT
|
|
|
| [[ISDBSongData::Publisher |Publisher ]]
| Property Get/Let
|
|-
| '''Encoder'''
| TEXT
|
|
|
| [[ISDBSongData::Encoder |Encoder ]]
| Property Get/Let
|
|-
| '''EncodedBy'''
| TEXT
|
|
|
|
|
|
|-
| '''Lyricist'''
| TEXT
|
|
|
| [[ISDBSongData::Lyricist |Lyricist ]]
| Property Get/Let
|
|-
| '''Band'''
| TEXT
|
|
|
| [[ISDBSongData::Band |Band ]]
| Property Get/Let
|
|-
| '''Conductor'''
| TEXT
|
|
|
| [[ISDBSongData::Conductor |Conductor ]]
| Property Get/Let
|
|-
| '''Remixer'''
| TEXT
|
|
|
|
|
|
|-
| '''InvolvedPeople'''
| TEXT
|
|
|
| [[ISDBSongData::InvolvedPeople |InvolvedPeople ]]
| Property Get/Let
|
|-
| '''OrigTitle'''
| TEXT
|
|
|
| [[ISDBSongData::OriginalTitle |OriginalTitle ]]
| Property Get/Let
|
|-
| '''OrigArtist'''
| TEXT
|
|
|
| [[ISDBSongData::OriginalArtist |OriginalArtist ]]
| Property Get/Let
|
|-
| '''OrigLyricist'''
| TEXT
|
|
|
| [[ISDBSongData::OriginalLyricist |OriginalLyricist ]]
| Property Get/Let
|
|-
| '''GroupDesc'''
| TEXT
|
|
|
| [[ISDBSongData::Grouping |Grouping ]]
| Property Get/Let
|
|-
| '''SubTitle'''
| TEXT
|
|
|
|
|
|
|-
| '''ISRC'''
| TEXT
|
|
|
| [[ISDBSongData::ISRC |ISRC ]]
| Property Get/Let
|
|-
| '''cuePath'''
| TEXT
|
| Added in version 5.1
|
|
|
|
|-
| '''InitialKey'''
| TEXT
|
|
|
|
|
|
|-
| '''Language'''
| TEXT
|
|
|
|
|
|
|-
| '''MediaType'''
| TEXT
|
|
|
|
|
|
|-
| '''RatingString'''
| TEXT
|
|
|
|
|
|
|-
| '''WebCommercial'''
| TEXT
|
|
|
|
|
|
|-
| '''WebCopyright'''
| TEXT
|
|
|
|
|
|
|-
| '''WebFilepage'''
| TEXT
|
|
|
|
|
|
|-
| '''WebArtist'''
| TEXT
|
|
|
|
|
|
|-
| '''WebSource'''
| TEXT
|
|
|
|
|
|
|-
| '''WebRadio'''
| TEXT
|
|
|
|
|
|
|-
| '''WebPayment'''
| TEXT
|
|
|
|
|
|
|-
| '''WebPublisher'''
| TEXT
|
|
|
|
|
|
|-
| '''WebUser'''
| TEXT
|
|
|
|
|
|
|-
| '''OrigYear'''
| INTEGER
|
|
|
| [[ISDBSongData::OriginalYear |OriginalYear ]]
| Property Get/Let
|
|-
| '''Tempo'''
| TEXT
|
|
|
| [[ISDBSongData::Tempo |Tempo ]]
| Property Get/Let
|
|-
| '''Mood'''
| TEXT
|
|
|
| [[ISDBSongData::Mood |Mood ]]
| Property Get/Let
|
|-
| '''Occasion'''
| TEXT
|
|
|
| [[ISDBSongData::Occasion |Occasion ]]
| Property Get/Let
|
|-
| '''Quality'''
| TEXT
|
|
|
| [[ISDBSongData::Quality |Quality ]]
| Property Get/Let
|
|-
| '''Lyrics'''
| TEXT
|
|
|
| [[ISDBSongData::Lyrics |Lyrics ]]
| Property Get/Let
|
|-
| '''Comment'''
| TEXT
|
|
|
| [[ISDBSongData::Comment |Comment ]]
| Property Get/Let
|
|-
| '''ExtendedTags'''
| TEXT
|
| Added in version 5.0
|
|
|
|
|}

RemoteClients table

2024-04-11T16:41:17Z

Drakinite: {{DatabaseTablesList}} and added asterisks for non IUNICODE fields

{{DatabaseTablesList}}
== Fields ==
{| border="1"
|-
! Name
! Value Type
! Possible Values
! Description
|-
| '''ID'''
| INTEGER
|
|
|-
| '''Name'''
| TEXT
|
|
|-
| '''AutoConversions'''
| TEXT*
|
|
|-
| '''MAC'''
| TEXT*
|
|
|-
| '''IP'''
| TEXT
|
|
|-
| '''Enabled'''
| INTEGER
|
|
|-
| '''CustomizeAC'''
| INTEGER
|
|
|-
| '''CustomizeContent'''
| INTEGER
|
|
|-
| '''NotSharedCustomNodes'''
| TEXT*
|
|
|-
| '''ShareAllPlaylists'''
| INTEGER
|
|
|-
| '''ShareAllCollections'''
| INTEGER
|
|
|-
| '''LastAccessTime'''
| REAL
|
| Formatted as the number of days since December 30, 1899.
Added in version 5.0
|}

Podcasts table

2024-04-11T16:40:25Z

Drakinite: {{DatabaseTablesList}}, formatting, and added asterisks to non IUNICODE fields

{{DatabaseTablesList}}
== Fields ==
{| border="1"
|-
! Name
! Value Type
! Possible Values
! Description
|-
| '''ID'''
| INTEGER
| AUTOINCREMENT (1 to inf.)
|
|-
| '''PodcastName'''
| TEXT
| Health Update
| The Name of the Podcast feed
|-
| '''PodcastUrl'''
| TEXT
| http://www.nytimes.com/services/xml/rss/nyt/podcasts/healthupdate.xml
| Podcast feed URL
|-
| '''Generator'''
| TEXT
| The New York Times
| Generator of the feed (<itunes:author> XML tag)
|-
| '''ImageLink'''
| TEXT*
| http://graphics.nytimes.com/images/apps/podcasts/healthupdate.jpg
| Added in version 5.0
|-
| '''CachedImageLink'''
| TEXT*
| C:\Users\username\AppData\Roaming\MediaMonkey5\Thumbs\80\6JY1YHN11VECYHF3-200px.jpg
| Added in version 5.0
|-
| '''WebLink'''
| TEXT*
| http://www.nytimes.com
| Added in version 5.0
|-
| '''CustomizeRules'''
| INTEGER
| 1 = customize rules for the feed, 0 = take global podcast rules (avail. in Options)
| Whether feed settings should be customized or taken from global settings
|-
| '''DelEpisodes'''
| INTEGER
| 1 = Delete episodes older than..., 0 = don't delete episodes older than
| Whether episodes should be automatically deleted
|-
| '''DelOnlyListened'''
| INTEGER
| 0 = unticked , 1 = ticked
| [x] Delete only if they have been listened to
|-
| '''RetainEpisodes'''
| INTEGER
| 0 = unticked , 1 = ticked
| Activate the [x] Always retain the ... checkbox
|-
| '''RetainNumber'''
| INTEGER
| 0 (x=1), 1 (x=2), 2 (x=3), 3 (x=5), 4 (x=10)
| Always retain the X most recent episodes
|-
| '''EpisodeAge'''
| INTEGER
|
0 = EPISODEAGE_1_DAY
1 = EPISODEAGE_3_DAYS
2 = EPISODEAGE_1_WEEK
3 = EPISODEAGE_2_WEEKS
4 = EPISODEAGE_1_MONTH
| Delete episodes older than X
|-
| '''DownloadType'''
| INTEGER
|
0 = DOWNLOAD_ALL
1 = DOWNLOAD_RECENT_1
2 = DOWNLOAD_RECENT_2
3 = DOWNLOAD_RECENT_5
4 = DOWNLOAD_RECENT_10
5 = DOWNLOAD_RECENT_20
6 = DOWNLOAD_NOTHING

New for 3.1
DOWNLOAD_RECENT_1_DAY = 7
DOWNLOAD_RECENT_2_DAYS = 8
DOWNLOAD_RECENT_3_DAYS = 9
DOWNLOAD_RECENT_WEEK = 10
DOWNLOAD_RECENT_2_WEEK = 11
DOWNLOAD_RECENT_MONTH = 12
DOWNLOAD_OLDEST_1 = 13
DOWNLOAD_OLDEST_2 = 14
DOWNLOAD_OLDEST_5 = 15
DOWNLOAD_OLDEST_10 = 16
DOWNLOAD_OLDEST_20 = 17
| How many of the most recent episodes should be download when available
|-
| '''Description'''
| TEXT
| The New York Times's Jane Brody, "Personal Health" columnist, discusses the latest health news.
| Description of the feed
|-
| '''OverwriteTags'''
| INTEGER
| 0 = unticked , 1 = ticked
| Overwrite Episode MP3 tags from feed
|-
| '''ShowRemovedEpisodes'''
| INTEGER
| 0 = unticked , 1 = ticked
| Show Removed Episodes in feed list
|}

PodcastEpisodes table

2024-04-11T16:38:59Z

Drakinite: {{DatabaseTablesList}}, formatting, added missing duration field, and asterisks for non IUNICODE fields

{{DatabaseTablesList}}
== Fields ==
{| border="1"
|-
! Name
! Value Type
! Possible Values
! Description
|-
| '''ID'''
| INTEGER
| AUTOINCREMENT (1 to inf.)
| Primary key
|-
| '''IDPodcast'''
| INTEGER
| ID
| Link to Podcasts table
|-
| '''IDTrack'''
| INTEGER
| -1(Not Downloaded),ID
| Link to Songs table
|-
| '''Downloaded'''
| INTEGER
| 0(Not Downloaded), 1(Downloaded)
| Episode download status
|-
| '''title'''
| TEXT
| NYT: Health Update for 04/01/2008
| From <item><title>. Also stored in ID3 Title tag.
|-
| '''autor'''
| TEXT
| Jane Brody of The New York Times
| From <item><author>. Also stored in ID3 Artist tag.
Note that the field '''is''' named "autor" and not "author". This is a typo in the code but it is being left as-is for backwards compatibility.
|-
| '''link'''
| TEXT
|
| From <item><link>. Infrequently used.
|-
| '''description'''
| TEXT
| The effectiveness of weight loss drugs.
| From <item><description>. Also stored in ID3 Comment tag.
|-
| '''subtitle'''
| TEXT
|
| From <channel><subtitle>
|-
| '''summary'''
| TEXT
|
| From <channel><summary>
|-
| '''PubDate'''
| REAL
| 39535.447916667
| Publication date. From <item><pubdate>. Formatted as the number of days since December 30, 1899.
|-
| '''NetSource'''
| TEXT
| http://podcasts.nytimes.com/podcasts/2008/03/28/01healthupdate.mp3
| URL for media file. From <item><enclosure url>
|-
| '''keywords'''
| TEXT
|
| From <item><keywords>
|-
| '''duration'''
| TEXT*
| 1:03
| From <item><itunes:duration>
This is the self-reported duration of the podcast from the XML, which may or may not be accurate to the real duration of the audio file.
|-
| '''category'''
| TEXT
| News
| From <item><category>
|-
| '''mime'''
| TEXT*
| audio/mpeg
| MIME type of the NetSource file. From <item><enclosure type>
Added in version 5.0
|-
| '''GUID'''
| TEXT
| http://podcasts.nytimes.com/podcasts/2008/03/28/01healthupdate.mp3
| Globally Unique Identifier
Added in version 3.1
|-
| '''ViewStatus'''
| INTEGER
|
0 = VS_VISIBLE
1 = VS_HIDDEN
| Show Removed Episode
Added in version 3.1
|}

Note: iTunes feed tags take precedence over standard tags. e.g. <iTunes:author> is used in preference to <author>.

PodcastDirs table

2024-04-11T16:23:44Z

Drakinite: Formatting, {{DatabaseTablesList}}, and updated cache path example

{{DatabaseTablesList}}
== Fields ==
{| border="1"
|-
! Name
! Value Type
! Possible Values
! Description
|-
| '''ID'''
| INTEGER
| AUTOINCREMENT (1 to inf.)
| Primary Key
|-
| '''DirName'''
| TEXT
| Digital Podcast
| Directory name from <opml><head><title>
|-
| '''Type'''
| INTEGER
| 0(OPML)
| Directory Type. Currently only OPML is supported.
|-
| '''DirUrl'''
| TEXT
| http://www.digitalpodcast.com/opml/digitalpodcast.opml
|
|-
| '''CachePath'''
| TEXT
| C:\Users\<USERNAME>\AppData\Local\Temp\7E8A.opml
| Path to local cached copy of OPML directory.
|}

Albums table

2024-04-11T16:21:59Z

Drakinite: Added asterisks for non IUNICODE fields

{{DatabaseTablesList}}
== Fields ==
{| border="1"
|-
! Name
! Value Type
! Possible Values
! Description
|-
| '''ID'''
| INTEGER
| AUTOINCREMENT (1 to inf.)
|
|-
| '''Artist'''
| TEXT
|
| The name(s) of the AlbumArtist(s)
|-
| '''Album'''
| TEXT
|
| The Name of the Album
|-
| '''Year'''
| INTEGER
| 20100521
| Was not in use until version 5.0.
The first 4 digits are the year, and the last 4 digits are the month and then day. The example is May 21, 2010.
|-
| '''Comment'''
| TEXT
|
| Album level comment
|-
| '''Tracks'''
| INTEGER
| Counter by trigger (0 to inf.)
| Count of Songs linked to the Album
|-
| '''MBGID'''
| TEXT*
| bfd86854-99cb-496e-b7c4-1c58c928ba1d
| ID of the matching release on MusicBrainz.
Added in version 5.0
|-
| '''MBRGGID'''
| TEXT*
| 7a83ecca-b88e-3eab-b769-8d72dde013f7
| ID of the matching release group on MusicBrainz.
Added in version 5.0
|-
| '''LastTimeShown'''
| REAL
|
| Formatted as the number of days since December 30, 1899.
Added in version 5.0
|-
| '''TVDBID'''
| INTEGER
|
| Added in version 5.0
|-
| '''RATING'''
| INTEGER
|
| Added in version 5.1
|}

== Connections ==
* Songs table
* Artists table (via the ArtistsAlbums table)
* ...

Artists table

2024-04-11T16:20:55Z

Drakinite: Added asterisks for non IUNICODE fields

{{DatabaseTablesList}}
== Fields ==
{| border="1"
|-
! Name
! Value Type
! Possible Values
! Description
|-
| '''ID'''
| INTEGER
| AUTOINCREMENT (1 to inf.)
|
|-
| '''Artist'''
| TEXT
| Imagine Dragons
| Name of the "Person". (This field should be named Person.)
|-
| '''Comment'''
| TEXT
|
| Description of the artist.
MediaMonkey 5.0 and later may automatically populate this field from a web search.
|-
| '''Tracks'''
| INTEGER
|
| Count of tracks where the "Person" appears as Artist.
|-
| '''Albums'''
| INTEGER
|
| Count of tracks where the "Person" appears as AlbumArtist.
|-
| '''Authors'''
| INTEGER
|
| Count of tracks where the "Person" appears as Composer.
|-
| '''Conducts'''
| INTEGER
|
| Count of tracks where the "Person" appears as Conductor.
|-
| '''Lyrics'''
| INTEGER
|
| Count of tracks where the "Person" appears as Lyricist.
|-
| '''PictureDataHash'''
| TEXT*
| FVGQBM43GJ83JVRZ
| First 16 digits of a MD5 hash of the cover image saved for this "Person".
Added in version 5.0
|-
| '''MBGID'''
| TEXT*
| 012151a8-0f9a-44c9-997f-ebd68b5389f9
| ID of the matching artist on MusicBrainz.
Added in version 5.0
|-
| '''LastTimeShown'''
| REAL
| 45173.1271521528
| Last time the artist was displayed in the UI. Formatted as the number of days since December 30, 1899.
Added in version 5.0
|}

ArtistsAlbums table

2024-04-11T16:20:21Z

Drakinite: Formatting

{{DatabaseTablesList}}
== Fields ==
{| border="1"
|-
! Name
! Value Type
! Possible Values
! Description
|-
| '''ID'''
| INTEGER
| AUTOINCREMENT (1 to inf.)
|
|-
| '''IDArtist'''
| INTEGER
|
| ID of the AlbumArtist. (ID of the "Artist" in the Artists table.)
|-
| '''IDAlbum'''
| INTEGER
|
| ID of the Album. (ID of the Album in the Albums table.)
|}

ArtistsSongs table

2024-04-11T16:20:01Z

Drakinite: Formatting

{{DatabaseTablesList}}
== Fields ==
{| border="1"
|-
! Name
! Value Type
! Possible Values
! Description
|-
| '''ID'''
| INTEGER
| AUTOINCREMENT (1 to inf.)
|
|-
| '''PersonType'''
| INTEGER
| 1=Artist or AlbumArtist, 3=Composer, 4=Conductor, 5=Lyricist, 6=Producer, 7=Actor, 8 = Publisher
| Specifies the PersonType relation between the Song and the "Artist"
|-
| '''IDArtist'''
| INTEGER
|
| ID of the "Artist". (ID of the "Artist" in the Artists table.)
|-
| '''IDSong'''
| INTEGER
|
| ID of the Song. (ID of the Song in the Songs table.)
|}

Covers table

2024-04-11T16:19:44Z

Drakinite: added asterisk for non IUNICODE field

{{DatabaseTablesList}}
== Fields ==
{| border="1"
|-
! Name
! Value Type
! Possible Values
! Description
|-
| '''ID'''
| INTEGER
| AUTOINCREMENT (1 to inf.)
|
|-
| '''IDSong'''
| INTEGER
|
|
|-
| '''CoverOrder'''
| INTEGER
|
|
|-
| '''CoverPath'''
| TEXT
| filename
| Name of cover file in folder (if applicable)
|-
| '''CoverStorage'''
| INTEGER
|
|
|-
| '''Cover Description'''
| TEXT
| Any
| Info/Comment about the cover
|-
| '''CoverType'''
| INTEGER
|
| This is an enum.
|-
| '''PictureType'''
| TEXT
| image/bmp, image/jpg, image/jpeg, image/png, etc.
| Cover picture format
|-
| '''PictureDataHash'''
| TEXT*
|
| First 16 digits of a MD5 hash of the cover image.
Added in version 5.0
|}

DeviceTracks table

2024-04-11T16:18:49Z

Drakinite: Added asterisks for non IUNICODE fields

{{DatabaseTablesList}}
== Fields ==
{| border="1"
|-
! Name
! Value Type
! Possible Values
! Description
|-
| '''ID'''
| INTEGER
|
|
|-
| '''IDDevice'''
| INTEGER
|
| ID of the associated device in the Devices table.
|-
| '''IDTrack'''
| INTEGER
|
| ID of the associated track in the Songs table.
|-
| '''DevicePath'''
| TEXT
|
|
|-
| '''Rating'''
| INTEGER
|
|
|-
| '''Bitrate'''
| INTEGER
|
|
|-
| '''SampleRate'''
| INTEGER
|
|
|-
| '''Channels'''
| INTEGER
|
|
|-
| '''isVBR'''
| INTEGER
|
|
|-
| '''PlayCount'''
| INTEGER
|
|
|-
| '''UploadTime'''
| REAL
|
| Formatted as the number of days since December 30, 1899.
|-
| '''ACSettHash'''
| TEXT*
|
|
|-
| '''Status'''
| INTEGER
|
|
|-
| '''Converted'''
| INTEGER
|
|
|-
| '''PreModified'''
| INTEGER
|
|
|-
| '''SyncID'''
| TEXT*
|
| Added in version 5.0
|-
| '''SourceInfo'''
| TEXT*
|
| Added in version 5.0
|-
| '''LastMetaHash'''
| TEXT*
|
| Added in version 5.0
|}

Devices table

2024-04-11T16:17:28Z

Drakinite: added asterisks for non IUNICODE fields

{{DatabaseTablesList}}
== Fields ==
{| border="1"
|-
! Name
! Value Type
! Other attributes
! Possible Values
! Description
|-
| '''ID'''
| INTEGER
| PRIMARY KEY AUTOINCREMENT
|
|
|-
| '''PluginName'''
| TEXT
| COLLATE IUNICODE
|
|
|-
| '''SynchAll'''
| INTEGER
|
|
|
|-
| '''AdvancedSynch'''
| INTEGER
|
|
|
|-
| '''MusicMask'''
| TEXT*
|
|
|
|-
| '''ClassMusicMask'''
| TEXT*
|
|
|
|-
| '''AudiobookMask'''
| TEXT*
|
|
|
|-
| '''PodcastMask'''
| TEXT*
|
|
|
|-
| '''VideoPodcastMask'''
| TEXT*
|
|
|
|-
| '''VideoMask'''
| TEXT*
|
|
|
|-
| '''MusicVideoMask'''
| TEXT*
|
|
|
|-
| '''TVMask'''
| TEXT*
|
|
|
|-
| '''SaveAAToFolder'''
| INTEGER
|
|
|
|-
| '''SaveAAToTag'''
| INTEGER
|
|
|
|-
| '''RemoveAAFromTag'''
| INTEGER
|
|
|
|-
| '''RemoveAAByteRate'''
| INTEGER
|
|
|
|-
| '''SyncAAMask'''
| TEXT
| COLLATE IUNICODE
|
|
|-
| '''DetailedUSBID'''
| TEXT
| COLLATE IUNICODE
|
|
|-
| '''CopyM3U'''
| INTEGER
|
|
|
|-
| '''PlaylistFormat'''
| TEXT
| COLLATE IUNICODE
|
|
|-
| '''M3UFolder'''
| TEXT
| COLLATE IUNICODE
|
|
|-
| '''M3UFlags'''
| INTEGER
|
|
|
|-
| '''M3UCopyLocations'''
| INTEGER
|
|
|
|-
| '''M3UCopyArtists'''
| INTEGER
|
|
|
|-
| '''M3UCopyAlbums'''
| INTEGER
|
|
|
|-
| '''M3UCopyPlaylists'''
| INTEGER
|
|
|
|-
| '''M3UOrganize'''
| INTEGER
|
|
|
|-
| '''DeleteUnsynch'''
| INTEGER
|
|
|
|-
| '''DeleteConfirm'''
| INTEGER
|
|
|
|-
| '''DeleteUnknown'''
| INTEGER
|
|
|
|-
| '''DeleteConfirmUnknown'''
| INTEGER
|
|
|
|-
| '''ResyncOnMaskChange'''
| INTEGER
|
|
|
|-
| '''BiDirSync'''
| INTEGER
|
|
|
|-
| '''BiDirConfirm'''
| INTEGER
|
|
|
|-
| '''BiDirSyncMetadata'''
| INTEGER
|
|
|
|-
| '''SynchOnConnect'''
| INTEGER
|
|
|
|-
| '''ScanOnConnect'''
| INTEGER
|
|
|
|-
| '''AllowWifiSync'''
| INTEGER
|
|
|
|-
| '''DeviceID'''
| TEXT
| COLLATE IUNICODE
|
|
|-
| '''DeviceCaption'''
| TEXT
| COLLATE IUNICODE
|
|
|-
| '''AutoUnmount'''
| INTEGER
|
|
|
|-
| '''DontDelete'''
| TEXT
| COLLATE IUNICODE
|
|
|-
| '''SyncBackFolders'''
| TEXT
| COLLATE IUNICODE
|
|
|-
| '''ScanFolders'''
| TEXT
| COLLATE IUNICODE
|
|
|-
| '''AutoConversions'''
| TEXT
| COLLATE IUNICODE
|
|
|-
| '''ImagePath'''
| TEXT*
|
|
|
|-
| '''WirelessIDString'''
| TEXT*
|
|
|
|-
| '''CopyToPCFolder'''
| TEXT*
|
|
|
|-
| '''Invisible'''
| INTEGER
|
|
|
|-
| '''LastAutoSynch'''
| FLOAT
|
|
|
|-
| '''LastChangedACRulesTm'''
| FLOAT
|
|
|
|-
| '''FirstGenre'''
| INTEGER
|
|
|
|-
| '''FirstArtist'''
| INTEGER
|
|
|
|-
| '''Capacity'''
| INTEGER
|
|
| Added in version 5.0
|-
| '''OtherContentSize'''
| INTEGER DEFAULT 0
|
|
| Added in version 5.0
|-
| '''handlerID'''
| TEXT DEFAULT "usb"
|
|
| Added in version 5.0
|-
| '''customJSON'''
| TEXT*
|
|
| Added in version 5.0
|-
| '''convertArtwork'''
| INTEGER DEFAULT 0
|
|
| Added in version 5.1
|-
| '''convertArtworkType'''
| STRING DEFAULT "JPG"
|
|
| Added in version 5.1
|-
| '''resizeArtwork'''
| INTEGER DEFAULT 0
|
|
| Added in version 5.1
|-
| '''resizeArtworkMaxRes'''
| INTEGER DEFAULT 500
|
|
| Maximum resolution of artwork when converted for the device.
Added in version 5.1
|}

Downloads table

2024-04-11T16:16:12Z

Drakinite: Added asterisk for non IUNICODE field

{{DatabaseTablesList}}
== Fields ==
{| border="1"
|-
! Name
! Value Type
! Possible Values
! Description
|-
| '''ID'''
| INTEGER
|
|
|-
| '''Source'''
| TEXT
|
|
|-
| '''Destination'''
| TEXT
|
|
|-
| '''Cookie'''
| TEXT
|
|
|-
| '''RequestBody'''
| TEXT
|
|
|-
| '''Title'''
| TEXT
|
|
|-
| '''Album'''
| TEXT
|
|
|-
| '''Artist'''
| TEXT
|
|
|-
| '''Genre'''
| TEXT
|
|
|-
| '''BytesDownloaded'''
| INTEGER
|
|
|-
| '''BytesTotal'''
| INTEGER
|
|
|-
| '''StartDate'''
| REAL
|
| Formatted as the number of days since December 30, 1899.
|-
| '''AddToLib'''
| INTEGER
|
|
|-
| '''TrackID'''
| INTEGER
|
| Added in version 5.0
|-
| '''TargetMask'''
| TEXT*
|
| Added in version 5.0
|}

Filters table

2024-04-11T16:15:46Z

Drakinite: added asterisk for non IUNICODE field

{{DatabaseTablesList}}
== Fields ==
{| border="1"
|-
! Name
! Value Type
! Possible Values
! Description
|-
| '''ID'''
| INTEGER
| AUTOINCREMENT (1 to inf.)
|
|-
| '''Pos'''
| INTEGER
|
| Sort order in the 'Manage Filters and Views' window
|-
| '''Name'''
| TEXT
|
| The Name of the Filter/View
|-
| '''Cond'''
| TEXT
|
| Used internally
|-
| '''View'''
| TEXT
|
| Used internally
|-
| '''Player'''
| INTEGER
|
|
|-
| '''ContentType'''
| INTEGER
|
|
|-
| '''criteriaJSON'''
| TEXT*
|
| Added in version 5.0
|}

Medias table

2024-04-11T16:13:08Z

Drakinite: Fixed asterisks in the wrong place

{{DatabaseTablesList}}
== Fields ==
{| border="1"
|-
! Name
! Value Type
! Possible Values
! Description
|-
| '''IDMedia'''
| INTEGER
|
| Internal MM ID number
|-
| '''SerialNumber'''
| TEXT
|
|
|-
| '''DriveType'''
| TEXT
|
|
|-
| '''Label'''
| TEXT
|
|
|-
| '''ShowLabel'''
| TEXT
|
|
|-
| '''Comment'''
| TEXT
|
|
|-
| '''IsAudioCD'''
| INTEGER
|
|
|-
| '''Location'''
| TEXT
|
|
|-
| '''CDDBId'''
| TEXT
|
|
|-
| '''TOCData'''
| TEXT
|
|
|-
| '''CDDBQueryState'''
| TEXT
|
|
|-
| '''CDDBQueryResult'''
| TEXT*
|
|
|-
| '''TurnedSN'''
| TEXT
|
|
|-
| '''DriveLetter'''
| INTEGER
|
| Ascii code of drive letter "A"=65
|-
| '''MusicBrainzDiscId'''
| TEXT*
|
|
|-
|}

(need more info in each)

Playlists table

2024-04-11T16:12:43Z

Drakinite: {{DatabaseTablesList}}, Added missing MM4 fields, and added asterisks for non IUNICODE fields

{{DatabaseTablesList}}
== Fields ==
{| border="1"
|-
! '''Name'''
! '''Value Type'''
! '''Possible Values'''
! '''Description'''
|-
| '''IDPlaylist'''
| INTEGER
| AUTOINCREMENT (1 to inf.)
| Assigned Playlist Number
|-
| '''PlaylistName'''
| TEXT
| Title
| Playlist Name
|-
| '''ParentPlaylist'''
| INTEGER
| [IDPlaylist]
| Playlist Parent (One level up in the Tree Node)
|-
| '''Comment'''
| TEXT
|
|
|-
| '''IsAutoPlaylist'''
| INTEGER
|
| 0=normal playlist 1=autoplaylist
|-
| '''QueryData'''
| TEXT
|
|
|-
| '''srcMedia'''
| INTEGER
|
|
|-
| '''srcPath'''
| TEXT
|
|
|-
| '''Persistent'''
| INTEGER
|
|
|-
| '''LastModified'''
| REAL
|
| Last time the playlist was modified. Formatted as the number of days since December 30, 1899.
|-
| '''LastContentHash'''
| TEXT*
|
| First 16 digits of an MD5 hash of the list of track IDs in the playlist.
|-
| '''GUID'''*
| TEXT*
|
|
|-
| '''IDFilter'''
| INTEGER DEFAULT -1
|
|
|-
| '''Synchronize'''
| INTEGER
|
|
|-
| '''PictureDataHash'''
| TEXT*
| 212WNGZVRZSKG56U
| First 16 digits of a MD5 hash of the cover image saved for this playlist.
Added in 5.0
|-
| '''ImageCollageInfo'''
| TEXT*
| 298,561,565,1061,1968,2133,2973,3363,4552
| List of '''idsong''' attributes in the Covers table for the covers that form the collage of art for this playlist.
Added in 5.0
|-
| '''QueryDataJSON'''
| TEXT*
|
| Added in 5.0
|}

MediaMonkey Database tables

2024-04-11T16:08:38Z

Drakinite:

MediaMonkey Database tables

2024-04-11T16:08:17Z

Drakinite:

PlaylistSongs table

2024-04-11T16:02:40Z

Drakinite: {{DatabaseTablesList}} and removed "need more info" since there's a description for each field

{{DatabaseTablesList}}
The PlaylistSongs table can be used for retrieving song IDs from a given playlist. Every song in every playlist resides in this table.

== Fields ==
{| border="1"
|-
! Name
! Value Type
! Possible Values
! Description
|-
| '''IDSong'''
| INTEGER
| Primary Key
| Each playlist entry has a unique identifier
|-
| '''IDPlaylist'''
| INTEGER
| Primary key from the [[Playlists table|Playlists]] table.
| The playlist that this entry's song resides in.
|-
| '''IDPlaylistSong'''
| INTEGER
| Primary key from the [[Songs table|Songs]] table.
| The song to be used for this entry in the given playlist.
|-
| '''SongOrder'''
| INTEGER
| Zero-based index, ordering the entry in the playlist.
| Entries in a database are unordered, so the playlist order must be made explicit. All numbers must be filled in, starting with zero.
|}

PlaylistSongs table

2024-04-11T16:01:42Z

Drakinite: {{DatabaseTablesList}}

Medias table

2024-04-11T16:01:20Z

Drakinite: {{DatabaseTablesList}} and capitalization

{{DatabaseTablesList}}
== Fields ==
{| border="1"
|-
! Name
! Value Type
! Possible Values
! Description
|-
| '''IDMedia'''
| INTEGER
|
| Internal MM ID number
|-
| '''SerialNumber'''
| TEXT
|
|
|-
| '''DriveType'''
| TEXT
|
|
|-
| '''Label'''
| TEXT
|
|
|-
| '''ShowLabel'''
| TEXT
|
|
|-
| '''Comment'''
| TEXT
|
|
|-
| '''IsAudioCD'''
| INTEGER
|
|
|-
| '''Location'''
| TEXT
|
|
|-
| '''CDDBId'''
| TEXT
|
|
|-
| '''TOCData'''
| TEXT
|
|
|-
| '''CDDBQueryState'''
| TEXT
|
|
|-
| '''CDDBQueryResult'''*
| TEXT
|
|
|-
| '''TurnedSN'''
| TEXT
|
|
|-
| '''DriveLetter'''
| INTEGER
|
| Ascii code of drive letter "A"=65
|-
| '''MusicBrainzDiscId'''*
| TEXT
|
|
|-
|}

(need more info in each)

ListsSongs table

2024-04-11T15:59:07Z

Drakinite: {{DatabaseTablesList}} and formatting

{{DatabaseTablesList}}
== Fields ==
{| border="1"
|-
! Name
! Value Type
! Possible Values
! Description
|-
| '''ID'''
| INTEGER
| AUTOINCREMENT (1 to inf.)
|
|-
| '''IDSong'''
| INTEGER
|
| ID of the Song. (ID of the Song in the Songs table.)
|-
| '''IDListType'''
| INTEGER
| 1=Tempo, 2=Mood, 3=Occasion, 4=Quality
| ID of the ListType. (IDListType in the Lists table.)
|-
| '''IDList'''
| INTEGER
|
| ID of the List. (ID of the List in the Lists table.)
|}

Lists table

2024-04-11T15:58:43Z

Drakinite: {{DatabaseTablesList}} and formatting

{{DatabaseTablesList}}
== Fields ==
{| border="1"
|-
! Name
! Value Type
! Possible Values
! Description
|-
| '''ID'''
| INTEGER
| AUTOINCREMENT (1 to inf.)
|
|-
| '''IDListType'''
| INTEGER
| 1=Tempo, 2=Mood, 3=Occasion, 4=Quality
| Type of Classification
|-
| '''TextData'''
| TEXT
|
| Contains the actual Tempo, Mood, Occasion or Quality. Listed as subnodes of the selected Classification
|-
| '''SortOrder'''
| INTEGER
|
| The sortorder of the TextData in the tree
|}

GenresSongs table

2024-04-11T15:58:19Z

Drakinite: {{DatabaseTablesList}} and formatting

{{DatabaseTablesList}}
== Fields ==
{| border="1"
|-
! Name
! Value Type
! Possible Values
! Description
|-
| '''ID'''
| INTEGER
| AUTOINCREMENT (1 to inf.)
|
|-
| '''IDGenre'''
| INTEGER
|
| ID of the Genre. (ID of the Genre in the Genres table.)
|-
| '''IDSong'''
| INTEGER
|
| ID of the Song. (ID of the Song in the Songs table.)
|}

Genres table

2024-04-11T15:56:05Z

Drakinite: {{DatabaseTablesList}}

{{DatabaseTablesList}}
== Fields ==
{| border="1"
|-
! Name
! Value Type
! Possible Values
! Description
|-
| '''IDGenre'''
| INTEGER
| AUTOINCREMENT (1 to inf.)
|
|-
| '''GenreName'''
| TEXT
|
| The name of the Genre
|-
| '''Description'''
| TEXT
|
| Not really in use
|-
| '''UsageCount'''
| INTEGER
|
| Count of Songs linked to the Genre
|}

Genres table

2024-04-11T15:55:17Z

Drakinite: {{DatabaseTablesList}} and formatting

== Fields ==
{| border="1"
|-
! Name
! Value Type
! Possible Values
! Description
|-
| '''IDGenre'''
| INTEGER
| AUTOINCREMENT (1 to inf.)
|
|-
| '''GenreName'''
| TEXT
|
| The name of the Genre
|-
| '''Description'''
| TEXT
|
| Not really in use
|-
| '''UsageCount'''
| INTEGER
|
| Count of Songs linked to the Genre
|}

Filters table

2024-04-11T15:54:53Z

Drakinite: {{DatabaseTablesList}}

Downloads table

2024-04-11T15:54:44Z

Drakinite: {{DatabaseTablesList}}

Devices table

2024-04-11T15:54:32Z

Drakinite: {{DatabaseTablesList}} and formatting

{{DatabaseTablesList}}
== Fields ==
{| border="1"
|-
! Name
! Value Type
! Other attributes
! Possible Values
! Description
|-
| '''ID'''
| INTEGER
| PRIMARY KEY AUTOINCREMENT
|
|
|-
| '''PluginName'''
| TEXT
| COLLATE IUNICODE
|
|
|-
| '''SynchAll'''
| INTEGER
|
|
|
|-
| '''AdvancedSynch'''
| INTEGER
|
|
|
|-
| '''MusicMask'''
| TEXT
|
|
|
|-
| '''ClassMusicMask'''
| TEXT
|
|
|
|-
| '''AudiobookMask'''
| TEXT
|
|
|
|-
| '''PodcastMask'''
| TEXT
|
|
|
|-
| '''VideoPodcastMask'''
| TEXT
|
|
|
|-
| '''VideoMask'''
| TEXT
|
|
|
|-
| '''MusicVideoMask'''
| TEXT
|
|
|
|-
| '''TVMask'''
| TEXT
|
|
|
|-
| '''SaveAAToFolder'''
| INTEGER
|
|
|
|-
| '''SaveAAToTag'''
| INTEGER
|
|
|
|-
| '''RemoveAAFromTag'''
| INTEGER
|
|
|
|-
| '''RemoveAAByteRate'''
| INTEGER
|
|
|
|-
| '''SyncAAMask'''
| TEXT
| COLLATE IUNICODE
|
|
|-
| '''DetailedUSBID'''
| TEXT
| COLLATE IUNICODE
|
|
|-
| '''CopyM3U'''
| INTEGER
|
|
|
|-
| '''PlaylistFormat'''
| TEXT
| COLLATE IUNICODE
|
|
|-
| '''M3UFolder'''
| TEXT
| COLLATE IUNICODE
|
|
|-
| '''M3UFlags'''
| INTEGER
|
|
|
|-
| '''M3UCopyLocations'''
| INTEGER
|
|
|
|-
| '''M3UCopyArtists'''
| INTEGER
|
|
|
|-
| '''M3UCopyAlbums'''
| INTEGER
|
|
|
|-
| '''M3UCopyPlaylists'''
| INTEGER
|
|
|
|-
| '''M3UOrganize'''
| INTEGER
|
|
|
|-
| '''DeleteUnsynch'''
| INTEGER
|
|
|
|-
| '''DeleteConfirm'''
| INTEGER
|
|
|
|-
| '''DeleteUnknown'''
| INTEGER
|
|
|
|-
| '''DeleteConfirmUnknown'''
| INTEGER
|
|
|
|-
| '''ResyncOnMaskChange'''
| INTEGER
|
|
|
|-
| '''BiDirSync'''
| INTEGER
|
|
|
|-
| '''BiDirConfirm'''
| INTEGER
|
|
|
|-
| '''BiDirSyncMetadata'''
| INTEGER
|
|
|
|-
| '''SynchOnConnect'''
| INTEGER
|
|
|
|-
| '''ScanOnConnect'''
| INTEGER
|
|
|
|-
| '''AllowWifiSync'''
| INTEGER
|
|
|
|-
| '''DeviceID'''
| TEXT
| COLLATE IUNICODE
|
|
|-
| '''DeviceCaption'''
| TEXT
| COLLATE IUNICODE
|
|
|-
| '''AutoUnmount'''
| INTEGER
|
|
|
|-
| '''DontDelete'''
| TEXT
| COLLATE IUNICODE
|
|
|-
| '''SyncBackFolders'''
| TEXT
| COLLATE IUNICODE
|
|
|-
| '''ScanFolders'''
| TEXT
| COLLATE IUNICODE
|
|
|-
| '''AutoConversions'''
| TEXT
| COLLATE IUNICODE
|
|
|-
| '''ImagePath'''
| TEXT
|
|
|
|-
| '''WirelessIDString'''
| TEXT
|
|
|
|-
| '''CopyToPCFolder'''
| TEXT
|
|
|
|-
| '''Invisible'''
| INTEGER
|
|
|
|-
| '''LastAutoSynch'''
| FLOAT
|
|
|
|-
| '''LastChangedACRulesTm'''
| FLOAT
|
|
|
|-
| '''FirstGenre'''
| INTEGER
|
|
|
|-
| '''FirstArtist'''
| INTEGER
|
|
|
|-
| '''Capacity'''
| INTEGER
|
|
| Added in version 5.0
|-
| '''OtherContentSize'''
| INTEGER DEFAULT 0
|
|
| Added in version 5.0
|-
| '''handlerID'''
| TEXT DEFAULT "usb"
|
|
| Added in version 5.0
|-
| '''customJSON'''
| TEXT
|
|
| Added in version 5.0
|-
| '''convertArtwork'''
| INTEGER DEFAULT 0
|
|
| Added in version 5.1
|-
| '''convertArtworkType'''
| STRING DEFAULT "JPG"
|
|
| Added in version 5.1
|-
| '''resizeArtwork'''
| INTEGER DEFAULT 0
|
|
| Added in version 5.1
|-
| '''resizeArtworkMaxRes'''
| INTEGER DEFAULT 500
|
|
| Maximum resolution of artwork when converted for the device.
Added in version 5.1
|}

DeviceTracks table

2024-04-11T15:51:18Z

Drakinite: {{DatabaseTablesList}}

{{DatabaseTablesList}}
== Fields ==
{| border="1"
|-
! Name
! Value Type
! Possible Values
! Description
|-
| '''ID'''
| INTEGER
|
|
|-
| '''IDDevice'''
| INTEGER
|
| ID of the associated device in the Devices table.
|-
| '''IDTrack'''
| INTEGER
|
| ID of the associated track in the Songs table.
|-
| '''DevicePath'''
| TEXT
|
|
|-
| '''Rating'''
| INTEGER
|
|
|-
| '''Bitrate'''
| INTEGER
|
|
|-
| '''SampleRate'''
| INTEGER
|
|
|-
| '''Channels'''
| INTEGER
|
|
|-
| '''isVBR'''
| INTEGER
|
|
|-
| '''PlayCount'''
| INTEGER
|
|
|-
| '''UploadTime'''
| REAL
|
| Formatted as the number of days since December 30, 1899.
|-
| '''ACSettHash'''
| TEXT
|
|
|-
| '''Status'''
| INTEGER
|
|
|-
| '''Converted'''
| INTEGER
|
|
|-
| '''PreModified'''
| INTEGER
|
|
|-
| '''SyncID'''
| TEXT
|
| Added in version 5.0
|-
| '''SourceInfo'''
| TEXT
|
| Added in version 5.0
|-
| '''LastMetaHash'''
| TEXT
|
| Added in version 5.0
|}

Covers table

2024-04-11T15:51:09Z

Drakinite: {{DatabaseTablesList}}

{{DatabaseTablesList}}
== Fields ==
{| border="1"
|-
! Name
! Value Type
! Possible Values
! Description
|-
| '''ID'''
| INTEGER
| AUTOINCREMENT (1 to inf.)
|
|-
| '''IDSong'''
| INTEGER
|
|
|-
| '''CoverOrder'''
| INTEGER
|
|
|-
| '''CoverPath'''
| TEXT
| filename
| Name of cover file in folder (if applicable)
|-
| '''CoverStorage'''
| INTEGER
|
|
|-
| '''Cover Description'''
| TEXT
| Any
| Info/Comment about the cover
|-
| '''CoverType'''
| INTEGER
|
| This is an enum.
|-
| '''PictureType'''
| TEXT
| image/bmp, image/jpg, image/jpeg, image/png, etc.
| Cover picture format
|-
| '''PictureDataHash'''
| TEXT
|
| First 16 digits of a MD5 hash of the cover image.
Added in version 5.0
|}

ArtistsSongs table

2024-04-11T15:50:15Z

Drakinite: {{DatabaseTablesList}}

{{DatabaseTablesList}}
== Fields ==
{| border="1"
|-
! Name
! Value Type
! Possible Values
! Description
|-
| '''ID'''
| INTEGER
| AUTOINCREMENT (1 to inf.)
|
|-
| PersonType
| INTEGER
| 1=Artist or AlbumArtist, 3=Composer, 4=Conductor, 5=Lyricist, 6=Producer, 7=Actor, 8 = Publisher
| Specifies the PersonType relation between the Song and the "Artist"
|-
| IDArtist
| INTEGER
|
| ID of the "Artist". (ID of the "Artist" in the Artists table.)
|-
| IDSong
| INTEGER
|
| ID of the Song. (ID of the Song in the Songs table.)
|}

ArtistsAlbums table

2024-04-11T15:50:02Z

Drakinite:

{{DatabaseTablesList}}
== Fields ==
{| border="1"
|-
! Name
! Value Type
! Possible Values
! Description
|-
| '''ID'''
| INTEGER
| AUTOINCREMENT (1 to inf.)
|
|-
| IDArtist
| INTEGER
|
| ID of the AlbumArtist. (ID of the "Artist" in the Artists table.)
|-
| IDAlbum
| INTEGER
|
| ID of the Album. (ID of the Album in the Albums table.)
|}

ArtistsAlbums table

2024-04-11T15:49:54Z

Drakinite: {{DatabaseTablesList}}

{{DatabaseTablesList}}

== Fields ==
{| border="1"
|-
! Name
! Value Type
! Possible Values
! Description
|-
| '''ID'''
| INTEGER
| AUTOINCREMENT (1 to inf.)
|
|-
| IDArtist
| INTEGER
|
| ID of the AlbumArtist. (ID of the "Artist" in the Artists table.)
|-
| IDAlbum
| INTEGER
|
| ID of the Album. (ID of the Album in the Albums table.)
|}

Artists table

2024-04-11T15:47:58Z

Drakinite:

{{DatabaseTablesList}}

== Fields ==
{| border="1"
|-
! Name
! Value Type
! Possible Values
! Description
|-
| '''ID'''
| INTEGER
| AUTOINCREMENT (1 to inf.)
|
|-
| '''Artist'''
| TEXT
| Imagine Dragons
| Name of the "Person". (This field should be named Person.)
|-
| '''Comment'''
| TEXT
|
| Description of the artist.
MediaMonkey 5.0 and later may automatically populate this field from a web search.
|-
| '''Tracks'''
| INTEGER
|
| Count of tracks where the "Person" appears as Artist.
|-
| '''Albums'''
| INTEGER
|
| Count of tracks where the "Person" appears as AlbumArtist.
|-
| '''Authors'''
| INTEGER
|
| Count of tracks where the "Person" appears as Composer.
|-
| '''Conducts'''
| INTEGER
|
| Count of tracks where the "Person" appears as Conductor.
|-
| '''Lyrics'''
| INTEGER
|
| Count of tracks where the "Person" appears as Lyricist.
|-
| '''PictureDataHash'''
| TEXT
| FVGQBM43GJ83JVRZ
| First 16 digits of a MD5 hash of the cover image saved for this "Person".
Added in version 5.0
|-
| '''MBGID'''
| TEXT
| 012151a8-0f9a-44c9-997f-ebd68b5389f9
| ID of the matching artist on MusicBrainz.
Added in version 5.0
|-
| '''LastTimeShown'''
| REAL
| 45173.1271521528
| Last time the artist was displayed in the UI. Formatted as the number of days since December 30, 1899.
Added in version 5.0
|}

Database Structure

2024-04-11T15:47:15Z

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

{{DatabaseTablesList}}

==MediaMonkey 3.0==

== Database type ==
[http://www.sqlite.org SQLite] version 3
* Encoding: UTF-16le
* Text collate IUNICODE (except where indicated with a (*))

== Additions to SQLite ==
Check out [http://www.sqlite.org/docs.html SQLite documentation]. MediaMonkey adds some more functions that you can use in SQL queries:

=== Collations ===
* IUNICODE - Unicode language neutral case insensitive (Post [http://www.mediamonkey.com/forum/viewtopic.php?p=127635#127635 1] [http://www.mediamonkey.com/forum/viewtopic.php?p=79915#79915 2] by Jiri with more detail)
* USERLOCALE - Sorts according to users locale in regional settings. (Implemented in 3.1.2.1279)
* NUMERICSTRING - Natural song order respecting numbers stored as strings. Useful for Track# and Disc# fields.

Due the customized collations MediaMonkey for Windows extension Library can be downloaded from
http://www.happymonkeying.com/beta/SQLite3MMExt.dll and then used in any app that can load and use external extension like
free Database Browser for SQLite

=== Functions ===
* HASSUBFOLDERS(string) - Used internally by MediaMonkey.
* INSTR(string1, string2) - Returns 1-based index of the first occurrence of string2 in string1, if not found 0 is returned. Case sensitive.
* LIKE(string1, string2) - Used to replace internal SQLite LIKE operator with one that supports Unicode strings. SEE NOTE!
* NEXTPATHPART(string) - Used internally by MediaMonkey.
* SIN(number) - Mathematical sinus function.
* STRICOMPW(string1, string2) - Compares two Unicode strings, case insensitive.
* UPPERW(string) - Unicode string upper case.
* GETEXTENSION(string) - Returns the extension from a filename. (Introduced in MM 3.1)
* SOUNDEX(string) - Returns a four-character string, based on how the word is pronounced in English. Similar spelled names are supposed to returns the same string. (Introduced in MM 3.1)

==== Note regarding LIKE ====
This MM-specific implementation of LIKE, automatically uses the @-sign as the escape character and it is always applied.
It means that you need to modify the SearchString to correctly use this function.

Here is one example of an VBScript function which prepares the search string correctly.
<source lang="vb">
Function FixLikeSearchString(Str)
Str = Replace(Str,"@","@@")
Str = Replace(Str,"_","@_")
Str = Replace(Str,"%","@%")
Str = Replace(Str,"'","''") '<--- Single quotes are escaped with another single quote
FixLikeSearchString=Str
End Function
</source>

If you for some reason, within an SQL-statement, need to link two fields using LIKE (instead of =) then use this syntax:
<source lang="sql">
SomeField LIKE REPLACE(REPLACE(REPLACE(SomeOtherField,'@','@@')'_','@_')'%','@%')
</source>

== Default Mediamonkey 3 and MediaMonkey 4 Database location ==
'''Windows XP:''' C:\Documents and Settings\<USERNAME>\Local Settings\Application Data\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''.

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

== Used data types ==
'''INTEGER''' The value is a signed integer, stored in 1, 2, 3, 4, 6, or 8 bytes depending on the magnitude of the value.
<br>'''REAL''' The value is a floating point value, stored as an 8-byte IEEE floating point number.
<br>'''TEXT''' The value is a text string, stored using the database encoding (UTF-16-LE).

== Structure explanation ==
The most important table is the ''Songs'' table, which is the starting point for all song-specific info. To allow rapid requests, most of the information is present in the table itself, e.g. the Artist name is spelled out.
The link between table Songs and other tables like Artists, Albums, ... happens with intermediary tables, e.g. ArtistsSongs. This allows us to assign multiple songs to one artist, AND multiple artists to one song.

The database contains custom events, called "triggers", that are executed when e.g. an artist is assigned to a track. For that example, the trigger will automatically increment the Artists table's Tracks counter field.

== Database tables ==
*[[Albums table|Albums]]: Contains all Albums and some Album specific info
*[[Artists table|Artists]]: Contains all Artists, AlbumArtists, Composers, Conductors and Lyricists with their track count
*[[ArtistsAlbums table|ArtistsAlbums]]: Specifies the relation between an Album and its AlbumArtist(s)
*[[ArtistsSongs table|ArtistsSongs]]: Specifies the relation between a Song and its Artist(s), Composer(s), Conductor(s) and Lyricist(s)
*[[Covers table|Covers]]
*[[DBInfo table|DBInfo]]
*[[DeviceFilters table|DeviceFilters]]
*[[DeviceTracks table|DeviceTracks]]
*[[Devices table|Devices]]
*[[Downloads table|Downloads]]
*[[Filters table|Filters]]: Contains all Filters/Views configured in MM
*[[Folders table|Folders]]
*[[FoldersHier table|FoldersHier]]
*[[Genres table|Genres]]: Contains all Genres with track Count
*[[GenresSongs table|GenresSongs]]: Specifies the relation between a Song and its Genre(s)
*[[LastTreePath table|LastTreePath]]
*[[Lists table|Lists]]: Contains all Classifications and their sort order in the tree
*[[ListsSongs table|ListsSongs]]: Specifies the relation between a Song and its various Classifications
*[[Medias table|Medias]]: Contains all the media sources that have been used
*[[OrganizeRules table|OrganizeRules]]
*[[PathProcessing table|PathProcessing]]
*[[Pinned table|Pinned]]: Stores links to Pinned items (Added in version 5.0)
*[[Played table|Played]]
*[[PlaylistSongs table|PlaylistSongs]] Specifies the relation between a Song and what '''Static Playlist(s)''' it appears in
*[[Playlists table|Playlists]] : Contains all Static Playlists and Auto-Playlists
*[[PodcastDirs table|PodcastDirs]]
*[[PodcastEpisodes table|PodcastEpisodes]] Specifies the relation between a Song and a Podcast
*[[Podcasts table|Podcasts]] Specifies podcast subscriptions
*[[Radio table|Radio]]: Stores links to the Radio node (Added in version 5.0)
*[[RemoteClients table|RemoteClients]]
*[[Songs table|Songs]] : Contains all songs with all their properties
*[[SynchAlbum table|SynchAlbum]]
*[[SynchArtist table|SynchArtist]]
*[[SynchLocation table|SynchLocation]]
*[[SynchPlaylist table|SynchPlaylist]]
*[[SynchPodcast table|SynchPodcast]]
*[[URLRequestCache table|URLRequestCache]]: Caches the results of some web requests.

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

[[Image:MM3DBStructure.PNG|center|650px]]

----

----

==MediaMonkey v2.5 and lower==

===Database structure===
[[Image:DatabaseRelationsMM2.gif|center|650px]]

===AddSongInfo===
''Value field is "TextData"''

'''DataType'''
{| border="2"
|-
! Value || AIF Code || Description
|-
| 100 || AIF_COPYRIGHT || Copyright
|-
| 101 || AIF_PUBLISHER || Publisher
|-
| 102 || AIF_ENCODER || Encoder
|-
| 103 || AIF_ENCODEDBY || Encoded By
|-
| 200 || AIF_LYRICIST || Lyricist
|-
| 201 || AIF_BAND || Band
|-
| 202 || AIF_CONDUCTOR || Conductor
|-
| 203 || AIF_REMIXER || Remixer
|-
| 204 || AIF_INVOLVEDPEOPLE || Involved People
|-
| 205 || AIF_MUSICCOMPOSER || (See note)
|-
| 300 || AIF_ORIGTITLE || Original Title
|-
| 301 || AIF_ORIGARTIST || Original Artist
|-
| 302 || AIF_ORIGLYRICIST || Original Lyricist
|-
| 400 || AIF_GROUPDESC ||
|-
| 401 || AIF_SUBTITLE ||
|-
| 402 || AIF_ISRC ||
|-
| 500 || AIF_INITIALKEY ||
|-
| 501 || AIF_LANGUAGE ||
|-
| 502 || AIF_MEDIATYPE ||
|-
| 503 || AIF_RATINGSTRING ||
|-
| 1000 || AIF_WEB_COMMERCIAL ||
|-
| 1001 || AIF_WEB_COPYRIGHT ||
|-
| 1002 || AIF_WEB_FILEPAGE ||
|-
| 1003 || AIF_WEB_ARTIST ||
|-
| 1004 || AIF_WEB_SOURCE ||
|-
| 1005 || AIF_WEB_RADIO ||
|-
| 1006 || AIF_WEB_PAYMENT ||
|-
| 1007 || AIF_WEB_PUBLISHER ||
|-
| 1100 || AIF_WEB_USER ||
|}

Note: Apparently, the value for the composer is stored in the Author field of the Songs table rather than in the AddSongInfo table under MediaMonkey 2.5. The situation in other versions is unknown.

===AddSongInfoInt===
''Value field is "IntData"'' (linked to Lists.ID)

'''DataType''' (partially linked to Lists.IDListType)
{| border="2"
|-
! Value || AIF Code || Description
|-
| 10000 || AIF_ORIGYEAR || Original Year
|-
| 10101 || AIF_TEMPO || Tempo
|-
| 10102 || AIF_MOOD || Mood
|-
| 10103 || AIF_OCCASION || Occasion
|-
| 10104 || AIF_QUALITY || Quality
|}
<references/>

===Memos===
''Value field is "MemoText"''

'''MemoType'''
{| border="2"
|-
! Value || AIF Code || Description
|-
| 20000 || AIF_LYRICS || Lyrics
|-
| 20001 || AIF_COMMENT || Comment
|}

Database Structure

2024-04-11T15:38:27Z

Drakinite: /* Default Mediamonkey 3 Database location */

{{DatabaseTablesList}}

==MediaMonkey 3.0==

== Database type ==
[http://www.sqlite.org SQLite] version 3
* Encoding: UTF-16le
* Text collate IUNICODE (except where indicated with a (*))

== Additions to SQLite ==
Check out [http://www.sqlite.org/docs.html SQLite documentation]. MediaMonkey adds some more functions that you can use in SQL queries:

=== Collations ===
* IUNICODE - Unicode language neutral case insensitive (Post [http://www.mediamonkey.com/forum/viewtopic.php?p=127635#127635 1] [http://www.mediamonkey.com/forum/viewtopic.php?p=79915#79915 2] by Jiri with more detail)
* USERLOCALE - Sorts according to users locale in regional settings. (Implemented in 3.1.2.1279)
* NUMERICSTRING - Natural song order respecting numbers stored as strings. Useful for Track# and Disc# fields.

Due the customized collations MediaMonkey for Windows extension Library can be downloaded from
http://www.happymonkeying.com/beta/SQLite3MMExt.dll and then used in any app that can load and use external extension like
free Database Browser for SQLite

=== Functions ===
* HASSUBFOLDERS(string) - Used internally by MediaMonkey.
* INSTR(string1, string2) - Returns 1-based index of the first occurrence of string2 in string1, if not found 0 is returned. Case sensitive.
* LIKE(string1, string2) - Used to replace internal SQLite LIKE operator with one that supports Unicode strings. SEE NOTE!
* NEXTPATHPART(string) - Used internally by MediaMonkey.
* SIN(number) - Mathematical sinus function.
* STRICOMPW(string1, string2) - Compares two Unicode strings, case insensitive.
* UPPERW(string) - Unicode string upper case.
* GETEXTENSION(string) - Returns the extension from a filename. (Introduced in MM 3.1)
* SOUNDEX(string) - Returns a four-character string, based on how the word is pronounced in English. Similar spelled names are supposed to returns the same string. (Introduced in MM 3.1)

==== Note regarding LIKE ====
This MM-specific implementation of LIKE, automatically uses the @-sign as the escape character and it is always applied.
It means that you need to modify the SearchString to correctly use this function.

Here is one example of an VBScript function which prepares the search string correctly.
<source lang="vb">
Function FixLikeSearchString(Str)
Str = Replace(Str,"@","@@")
Str = Replace(Str,"_","@_")
Str = Replace(Str,"%","@%")
Str = Replace(Str,"'","''") '<--- Single quotes are escaped with another single quote
FixLikeSearchString=Str
End Function
</source>

If you for some reason, within an SQL-statement, need to link two fields using LIKE (instead of =) then use this syntax:
<source lang="sql">
SomeField LIKE REPLACE(REPLACE(REPLACE(SomeOtherField,'@','@@')'_','@_')'%','@%')
</source>

== Default Mediamonkey 3 and MediaMonkey 4 Database location ==
'''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

'''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 ==
My Documents\My Music\Mediamonkey\Mediamonkey.mdb

== Used data types ==
'''INTEGER''' The value is a signed integer, stored in 1, 2, 3, 4, 6, or 8 bytes depending on the magnitude of the value.
<br>'''REAL''' The value is a floating point value, stored as an 8-byte IEEE floating point number.
<br>'''TEXT''' The value is a text string, stored using the database encoding (UTF-16-LE).

== Structure explanation ==
The most important table is the ''Songs'' table, which is the starting point for all song-specific info. To allow rapid requests, most of the information is present in the table itself, e.g. the Artist name is spelled out.
The link between table Songs and other tables like Artists, Albums, ... happens with intermediary tables, e.g. ArtistsSongs. This allows us to assign multiple songs to one artist, AND multiple artists to one song.

The database contains custom events, called "triggers", that are executed when e.g. an artist is assigned to a track. For that example, the trigger will automatically increment the Artists table's Tracks counter field.

== Database tables ==
*[[Albums table|Albums]]: Contains all Albums and some Album specific info
*[[Artists table|Artists]]: Contains all Artists, AlbumArtists, Composers, Conductors and Lyricists with their track count
*[[ArtistsAlbums table|ArtistsAlbums]]: Specifies the relation between an Album and its AlbumArtist(s)
*[[ArtistsSongs table|ArtistsSongs]]: Specifies the relation between a Song and its Artist(s), Composer(s), Conductor(s) and Lyricist(s)
*[[Covers table|Covers]]
*[[DBInfo table|DBInfo]]
*[[DeviceFilters table|DeviceFilters]]
*[[DeviceTracks table|DeviceTracks]]
*[[Devices table|Devices]]
*[[Downloads table|Downloads]]
*[[Filters table|Filters]]: Contains all Filters/Views configured in MM
*[[Folders table|Folders]]
*[[FoldersHier table|FoldersHier]]
*[[Genres table|Genres]]: Contains all Genres with track Count
*[[GenresSongs table|GenresSongs]]: Specifies the relation between a Song and its Genre(s)
*[[LastTreePath table|LastTreePath]]
*[[Lists table|Lists]]: Contains all Classifications and their sort order in the tree
*[[ListsSongs table|ListsSongs]]: Specifies the relation between a Song and its various Classifications
*[[Medias table|Medias]]: Contains all the media sources that have been used
*[[OrganizeRules table|OrganizeRules]]
*[[PathProcessing table|PathProcessing]]
*[[Pinned table|Pinned]]: Stores links to Pinned items (Added in version 5.0)
*[[Played table|Played]]
*[[PlaylistSongs table|PlaylistSongs]] Specifies the relation between a Song and what '''Static Playlist(s)''' it appears in
*[[Playlists table|Playlists]] : Contains all Static Playlists and Auto-Playlists
*[[PodcastDirs table|PodcastDirs]]
*[[PodcastEpisodes table|PodcastEpisodes]] Specifies the relation between a Song and a Podcast
*[[Podcasts table|Podcasts]] Specifies podcast subscriptions
*[[Radio table|Radio]]: Stores links to the Radio node (Added in version 5.0)
*[[RemoteClients table|RemoteClients]]
*[[Songs table|Songs]] : Contains all songs with all their properties
*[[SynchAlbum table|SynchAlbum]]
*[[SynchArtist table|SynchArtist]]
*[[SynchLocation table|SynchLocation]]
*[[SynchPlaylist table|SynchPlaylist]]
*[[SynchPodcast table|SynchPodcast]]
*[[URLRequestCache table|URLRequestCache]]: Caches the results of some web requests.

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

[[Image:MM3DBStructure.PNG|center|650px]]

----

----

==MediaMonkey v2.5 and lower==

===Database structure===
[[Image:DatabaseRelationsMM2.gif|center|650px]]

===AddSongInfo===
''Value field is "TextData"''

'''DataType'''
{| border="2"
|-
! Value || AIF Code || Description
|-
| 100 || AIF_COPYRIGHT || Copyright
|-
| 101 || AIF_PUBLISHER || Publisher
|-
| 102 || AIF_ENCODER || Encoder
|-
| 103 || AIF_ENCODEDBY || Encoded By
|-
| 200 || AIF_LYRICIST || Lyricist
|-
| 201 || AIF_BAND || Band
|-
| 202 || AIF_CONDUCTOR || Conductor
|-
| 203 || AIF_REMIXER || Remixer
|-
| 204 || AIF_INVOLVEDPEOPLE || Involved People
|-
| 205 || AIF_MUSICCOMPOSER || (See note)
|-
| 300 || AIF_ORIGTITLE || Original Title
|-
| 301 || AIF_ORIGARTIST || Original Artist
|-
| 302 || AIF_ORIGLYRICIST || Original Lyricist
|-
| 400 || AIF_GROUPDESC ||
|-
| 401 || AIF_SUBTITLE ||
|-
| 402 || AIF_ISRC ||
|-
| 500 || AIF_INITIALKEY ||
|-
| 501 || AIF_LANGUAGE ||
|-
| 502 || AIF_MEDIATYPE ||
|-
| 503 || AIF_RATINGSTRING ||
|-
| 1000 || AIF_WEB_COMMERCIAL ||
|-
| 1001 || AIF_WEB_COPYRIGHT ||
|-
| 1002 || AIF_WEB_FILEPAGE ||
|-
| 1003 || AIF_WEB_ARTIST ||
|-
| 1004 || AIF_WEB_SOURCE ||
|-
| 1005 || AIF_WEB_RADIO ||
|-
| 1006 || AIF_WEB_PAYMENT ||
|-
| 1007 || AIF_WEB_PUBLISHER ||
|-
| 1100 || AIF_WEB_USER ||
|}

Note: Apparently, the value for the composer is stored in the Author field of the Songs table rather than in the AddSongInfo table under MediaMonkey 2.5. The situation in other versions is unknown.

===AddSongInfoInt===
''Value field is "IntData"'' (linked to Lists.ID)

'''DataType''' (partially linked to Lists.IDListType)
{| border="2"
|-
! Value || AIF Code || Description
|-
| 10000 || AIF_ORIGYEAR || Original Year
|-
| 10101 || AIF_TEMPO || Tempo
|-
| 10102 || AIF_MOOD || Mood
|-
| 10103 || AIF_OCCASION || Occasion
|-
| 10104 || AIF_QUALITY || Quality
|}
<references/>

===Memos===
''Value field is "MemoText"''

'''MemoType'''
{| border="2"
|-
! Value || AIF Code || Description
|-
| 20000 || AIF_LYRICS || Lyrics
|-
| 20001 || AIF_COMMENT || Comment
|}

Database Structure

2024-04-10T19:18:20Z

Drakinite: Added Pinned, Radio, and URLRequestCache tables

{{DatabaseTablesList}}

==MediaMonkey 3.0==

== Database type ==
[http://www.sqlite.org SQLite] version 3
* Encoding: UTF-16le
* Text collate IUNICODE (except where indicated with a (*))

== Additions to SQLite ==
Check out [http://www.sqlite.org/docs.html SQLite documentation]. MediaMonkey adds some more functions that you can use in SQL queries:

=== Collations ===
* IUNICODE - Unicode language neutral case insensitive (Post [http://www.mediamonkey.com/forum/viewtopic.php?p=127635#127635 1] [http://www.mediamonkey.com/forum/viewtopic.php?p=79915#79915 2] by Jiri with more detail)
* USERLOCALE - Sorts according to users locale in regional settings. (Implemented in 3.1.2.1279)
* NUMERICSTRING - Natural song order respecting numbers stored as strings. Useful for Track# and Disc# fields.

Due the customized collations MediaMonkey for Windows extension Library can be downloaded from
http://www.happymonkeying.com/beta/SQLite3MMExt.dll and then used in any app that can load and use external extension like
free Database Browser for SQLite

=== Functions ===
* HASSUBFOLDERS(string) - Used internally by MediaMonkey.
* INSTR(string1, string2) - Returns 1-based index of the first occurrence of string2 in string1, if not found 0 is returned. Case sensitive.
* LIKE(string1, string2) - Used to replace internal SQLite LIKE operator with one that supports Unicode strings. SEE NOTE!
* NEXTPATHPART(string) - Used internally by MediaMonkey.
* SIN(number) - Mathematical sinus function.
* STRICOMPW(string1, string2) - Compares two Unicode strings, case insensitive.
* UPPERW(string) - Unicode string upper case.
* GETEXTENSION(string) - Returns the extension from a filename. (Introduced in MM 3.1)
* SOUNDEX(string) - Returns a four-character string, based on how the word is pronounced in English. Similar spelled names are supposed to returns the same string. (Introduced in MM 3.1)

==== Note regarding LIKE ====
This MM-specific implementation of LIKE, automatically uses the @-sign as the escape character and it is always applied.
It means that you need to modify the SearchString to correctly use this function.

Here is one example of an VBScript function which prepares the search string correctly.
<source lang="vb">
Function FixLikeSearchString(Str)
Str = Replace(Str,"@","@@")
Str = Replace(Str,"_","@_")
Str = Replace(Str,"%","@%")
Str = Replace(Str,"'","''") '<--- Single quotes are escaped with another single quote
FixLikeSearchString=Str
End Function
</source>

If you for some reason, within an SQL-statement, need to link two fields using LIKE (instead of =) then use this syntax:
<source lang="sql">
SomeField LIKE REPLACE(REPLACE(REPLACE(SomeOtherField,'@','@@')'_','@_')'%','@%')
</source>

== Default Mediamonkey 3 Database location ==
'''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

'''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 ==
My Documents\My Music\Mediamonkey\Mediamonkey.mdb

== Used data types ==
'''INTEGER''' The value is a signed integer, stored in 1, 2, 3, 4, 6, or 8 bytes depending on the magnitude of the value.
<br>'''REAL''' The value is a floating point value, stored as an 8-byte IEEE floating point number.
<br>'''TEXT''' The value is a text string, stored using the database encoding (UTF-16-LE).

== Structure explanation ==
The most important table is the ''Songs'' table, which is the starting point for all song-specific info. To allow rapid requests, most of the information is present in the table itself, e.g. the Artist name is spelled out.
The link between table Songs and other tables like Artists, Albums, ... happens with intermediary tables, e.g. ArtistsSongs. This allows us to assign multiple songs to one artist, AND multiple artists to one song.

The database contains custom events, called "triggers", that are executed when e.g. an artist is assigned to a track. For that example, the trigger will automatically increment the Artists table's Tracks counter field.

== Database tables ==
*[[Albums table|Albums]]: Contains all Albums and some Album specific info
*[[Artists table|Artists]]: Contains all Artists, AlbumArtists, Composers, Conductors and Lyricists with their track count
*[[ArtistsAlbums table|ArtistsAlbums]]: Specifies the relation between an Album and its AlbumArtist(s)
*[[ArtistsSongs table|ArtistsSongs]]: Specifies the relation between a Song and its Artist(s), Composer(s), Conductor(s) and Lyricist(s)
*[[Covers table|Covers]]
*[[DBInfo table|DBInfo]]
*[[DeviceFilters table|DeviceFilters]]
*[[DeviceTracks table|DeviceTracks]]
*[[Devices table|Devices]]
*[[Downloads table|Downloads]]
*[[Filters table|Filters]]: Contains all Filters/Views configured in MM
*[[Folders table|Folders]]
*[[FoldersHier table|FoldersHier]]
*[[Genres table|Genres]]: Contains all Genres with track Count
*[[GenresSongs table|GenresSongs]]: Specifies the relation between a Song and its Genre(s)
*[[LastTreePath table|LastTreePath]]
*[[Lists table|Lists]]: Contains all Classifications and their sort order in the tree
*[[ListsSongs table|ListsSongs]]: Specifies the relation between a Song and its various Classifications
*[[Medias table|Medias]]: Contains all the media sources that have been used
*[[OrganizeRules table|OrganizeRules]]
*[[PathProcessing table|PathProcessing]]
*[[Pinned table|Pinned]]: Stores links to Pinned items (Added in version 5.0)
*[[Played table|Played]]
*[[PlaylistSongs table|PlaylistSongs]] Specifies the relation between a Song and what '''Static Playlist(s)''' it appears in
*[[Playlists table|Playlists]] : Contains all Static Playlists and Auto-Playlists
*[[PodcastDirs table|PodcastDirs]]
*[[PodcastEpisodes table|PodcastEpisodes]] Specifies the relation between a Song and a Podcast
*[[Podcasts table|Podcasts]] Specifies podcast subscriptions
*[[Radio table|Radio]]: Stores links to the Radio node (Added in version 5.0)
*[[RemoteClients table|RemoteClients]]
*[[Songs table|Songs]] : Contains all songs with all their properties
*[[SynchAlbum table|SynchAlbum]]
*[[SynchArtist table|SynchArtist]]
*[[SynchLocation table|SynchLocation]]
*[[SynchPlaylist table|SynchPlaylist]]
*[[SynchPodcast table|SynchPodcast]]
*[[URLRequestCache table|URLRequestCache]]: Caches the results of some web requests.

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

[[Image:MM3DBStructure.PNG|center|650px]]

----

----

==MediaMonkey v2.5 and lower==

===Database structure===
[[Image:DatabaseRelationsMM2.gif|center|650px]]

===AddSongInfo===
''Value field is "TextData"''

'''DataType'''
{| border="2"
|-
! Value || AIF Code || Description
|-
| 100 || AIF_COPYRIGHT || Copyright
|-
| 101 || AIF_PUBLISHER || Publisher
|-
| 102 || AIF_ENCODER || Encoder
|-
| 103 || AIF_ENCODEDBY || Encoded By
|-
| 200 || AIF_LYRICIST || Lyricist
|-
| 201 || AIF_BAND || Band
|-
| 202 || AIF_CONDUCTOR || Conductor
|-
| 203 || AIF_REMIXER || Remixer
|-
| 204 || AIF_INVOLVEDPEOPLE || Involved People
|-
| 205 || AIF_MUSICCOMPOSER || (See note)
|-
| 300 || AIF_ORIGTITLE || Original Title
|-
| 301 || AIF_ORIGARTIST || Original Artist
|-
| 302 || AIF_ORIGLYRICIST || Original Lyricist
|-
| 400 || AIF_GROUPDESC ||
|-
| 401 || AIF_SUBTITLE ||
|-
| 402 || AIF_ISRC ||
|-
| 500 || AIF_INITIALKEY ||
|-
| 501 || AIF_LANGUAGE ||
|-
| 502 || AIF_MEDIATYPE ||
|-
| 503 || AIF_RATINGSTRING ||
|-
| 1000 || AIF_WEB_COMMERCIAL ||
|-
| 1001 || AIF_WEB_COPYRIGHT ||
|-
| 1002 || AIF_WEB_FILEPAGE ||
|-
| 1003 || AIF_WEB_ARTIST ||
|-
| 1004 || AIF_WEB_SOURCE ||
|-
| 1005 || AIF_WEB_RADIO ||
|-
| 1006 || AIF_WEB_PAYMENT ||
|-
| 1007 || AIF_WEB_PUBLISHER ||
|-
| 1100 || AIF_WEB_USER ||
|}

Note: Apparently, the value for the composer is stored in the Author field of the Songs table rather than in the AddSongInfo table under MediaMonkey 2.5. The situation in other versions is unknown.

===AddSongInfoInt===
''Value field is "IntData"'' (linked to Lists.ID)

'''DataType''' (partially linked to Lists.IDListType)
{| border="2"
|-
! Value || AIF Code || Description
|-
| 10000 || AIF_ORIGYEAR || Original Year
|-
| 10101 || AIF_TEMPO || Tempo
|-
| 10102 || AIF_MOOD || Mood
|-
| 10103 || AIF_OCCASION || Occasion
|-
| 10104 || AIF_QUALITY || Quality
|}
<references/>

===Memos===
''Value field is "MemoText"''

'''MemoType'''
{| border="2"
|-
! Value || AIF Code || Description
|-
| 20000 || AIF_LYRICS || Lyrics
|-
| 20001 || AIF_COMMENT || Comment
|}

MediaMonkey Database tables

2024-04-10T19:18:11Z

Drakinite: Added Downloads, RemoteClients, Pinned, Radio, and URLRequestCache tables

Downloads table

2024-04-10T19:12:19Z

Drakinite: Added Downloads table

== Fields ==
{| border="1"
|-
! Name
! Value Type
! Possible Values
! Description
|-
| '''ID'''
| INTEGER
|
|
|-
| '''Source'''
| TEXT
|
|
|-
| '''Destination'''
| TEXT
|
|
|-
| '''Cookie'''
| TEXT
|
|
|-
| '''RequestBody'''
| TEXT
|
|
|-
| '''Title'''
| TEXT
|
|
|-
| '''Album'''
| TEXT
|
|
|-
| '''Artist'''
| TEXT
|
|
|-
| '''Genre'''
| TEXT
|
|
|-
| '''BytesDownloaded'''
| INTEGER
|
|
|-
| '''BytesTotal'''
| INTEGER
|
|
|-
| '''StartDate'''
| REAL
|
| Formatted as the number of days since December 30, 1899.
|-
| '''AddToLib'''
| INTEGER
|
|
|-
| '''TrackID'''
| INTEGER
|
| Added in version 5.0
|-
| '''TargetMask'''
| TEXT
|
| Added in version 5.0
|}