Database Structure

2007-09-05T20:42:20Z

Judas: /* Structure explanation */

{{DatabaseTablesList}}

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

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

== 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.
 '''REAL''' The value is a floating point value, stored as an 8-byte IEEE floating point number.
 '''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]]: All info about a certain album.
*[[Artists table|Artists]]
*[[ArtistsAlbums table|ArtistsAlbums]]
*[[ArtistsSongs table|ArtistsSongs]]
*[[Covers table|Covers]]
*[[DBInfo table|DBInfo]]
*[[DeviceFilters table|DeviceFilters]]
*[[DeviceTracks table|DeviceTracks]]

----

----

==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 || Music Composer
|-
| 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 ||
|}

===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
|}

Skins for MediaMonkey v3.0 and higher

2007-08-25T17:12:41Z

Judas: /* WMP11 */

[[Skinning|''Go back to the '''main''' skinning page'']]

'''Listed Below are some skins for MediaMonkey v3.0 which currently is in the alpha stages. You may need to right click and use the "Save link as" or "Save target as" option in your internet browser.'''

==Blake's skins==
===Monkey11===
[[Image:WMP11_blakeloth.jpg|right|thumb|300px|Blake's WMP11 look-a-like]]

'''Author:''' [[User:Blake|Blake]]

'''First released:''' 2007-02-25

'''Current version:''' [http://www.mediafire.com/?cjzxzjjmx2h Download #1] | [http://lajevardi.googlepages.com/Monkey11.msz Download #2] | [http://lajevardi.persiangig.com/app/mm.v3.0/Monkey11.msz Download #3] (v?.? - 2007-0?-??)

'''Green Version:''' [http://www.mediafire.com/?awwntvwbhti G-Monkey11]

'''Notes:''' This skin is more inspired by WMP and it feels more like the original MediaMonkey skin. There are two versions available: The blue version (original) and the green version as shown in the screenshot

 

===MiPod===
[[Image:Ipodfull.PNG#file|right|thumb|300px|Blake's iPod inspired skin]]

'''Author:''' [[User:Blake|Blake]]

'''First released:''' 2007-04-05

'''Current version:''' [http://www.mediafire.com/?82kmnqki0n4 Download ]

 

==Morten's skins==

===WMP11===
[[Image:WMP11_m.jpg|right|thumb|300px|Morten's WMP11 skin for MM3]]

'''Author:''' [[User:Morten9300|Morten]]

'''First released:''' 2007-01-26

'''Current version:''' [http://www.diskusjon.no/index.php?act=Attach&type=post&id=160464 Download] (v1.2 - 2007-01-28)

'''Notes:''' This skin tries to look like Windows Media Player v11 as much as possible. Some usability enhancements are made that are not available in WMP11 itself.

 

===iTunes 7===
[[Image:ITunes_morten.jpg|right|thumb|300px|Morten's iTunes 7 skin for MM3]]

'''Author:''' [[User:Morten9300|Morten]]

'''First released:''' 2007-01-26

'''Current version:''' [http://www.diskusjon.no/index.php?act=Attach&type=post&id=135227 Download] (v1.2 - 2007-01-28)

'''Notes:''' This skin tries to look like ITunes v7 as much as possible. Some usability enhancements are made that are not available in ITunes7 itself.

 

==Tommae88's skins==
===Red Bruise===

[[Image:Red_bruise.jpg|right|thumb|300px|Tommae88's Red Bruise skin]]

'''Author:''' [[User:Tommae88|Tommae88]]

'''First released:''' 2007-03-02

'''Current version:''' [http://www.mediafire.com/?1nvhvvimmmz Download] (v1.2 - 2007-01-28)

'''Notes:''' This skin has a nice red quality over itself and is based on the default theme.

 

== Authors with More than 2 Skin Screenshots ==

===Rovingcowboy's skins===

'''[http://www.mediamonkey.com/forum/viewtopic.php?p=27829#27829 For More Information Read This Forum Thread]
'''

'''[[Roving Cowboy's MM 3_ScreenShots]] |''' [http://www.angelfire.com/tx3/rovingcowboy/mediadownloads.html My Media DownLoads]'''

===Default Skin Recolored===
'''by Blake and by Tommae88'''

'''[http://www.mediamonkey.com/forum/viewtopic.php?p=78163#78163 the default royal blue, in modified colours Download links] |

'''[[Re - Colored Screenshots]]'''

MediaMonkey Wiki - User contributions [en]

Database Structure

Skins for MediaMonkey v3.0 and higher