Database schema (1 Viewer)


Portal Member
January 2, 2016
Canada Canada
Country flag
Hi, I have two versions of the same movie (Cloud Atlas), one in English, the other in French. I am trying to translate the story plot of the French version directly in MP2 database (Datastore) using SQLiteStudio.
I was trying to use the table M_PROVIDERRESOURCE to identify file's MEDIA_ITEM_ID but I found out three PATH values for the movie. One for the English version (RESOURCE=2), and two ??? for the French one (RESOURCE=0 and 1), both french version having the same PATH (filename). Furthermore all the files have the same MEDIA_ITEM_ID, which surprises me.
Is there any documentation that explains the database tables and columns? Or tools I could use to make these changes? I would really appreciate understanding how to edit the database in order to adapt movies description and being able to choose between the English and French version.

Users who are viewing this thread

Similar threads
OP Title Forum Replies Date
toricred Using TMM, How to Stop Importer From Going to The Movie Database for Data General 1
H MP2 database won't keep in synch with recordings General 8
F How to reset tv recordings database General 5
A Synchronizing client databases MediaPortal 1 Talk 10
R Problems accessing MySQL database remotely MediaPortal 1 Talk 0
globaldonkey Music Database Error Listen Music 1
R [solved] Files moved to new location - Easy way to update database? My TVSeries 7
R Files moved to different location - Easy way to update database? Moving Pictures 2
H [solved] Video database genres, sort titles and collection thumbnails Newcomers Forum 12
G MP1 TV Server "failed to upgrade the database" using MS Sql Server Installation, configuration support 3
D PC rebuild & MP2 upgrade - how to preserve database and settings? General 1
H MP1.21F video database scan, can it be scheduled to automatically run in background General Support 5
D Large xml database in My Movies Management. I remain unclear on use My Films as bridge to MP2.2 General 9
ajs Sync databases by Media Sync Service MediaPortal 1 Talk 26
W [solved] MP 1.20 Video IMDB no showing plot General Support 129
hounddog How to get My Films working in MP 1.20 My Films 5
C How well can MediaPortal handle 10,000+ recordings? MediaPortal 1 Talk 3
H Database migration Archive 85
D Single Seat Install - can another single seat use the same databases? Installation, configuration support 1
P [Resolved] Missing column in database My TVSeries 7

Similar threads

Top Bottom