Database schema

Discussion in 'General' started by jfd553, December 7, 2018.

  1. jfd553

    jfd553 Portal Member

    Joined:
    January 2, 2016
    Messages:
    16
    Likes Received:
    0
    Ratings:
    +0 / 0
    Home Country:
    Canada Canada
    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.


     
Loading...

Users Viewing Thread (Users: 0, Guests: 0)

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice
  • About The Project

    The vision of the MediaPortal project is to create a free open source media centre application, which supports all advanced media centre functions, and is accessible to all Windows users.

    In reaching this goal we are working every day to make sure our software is one of the best.

             

  • Support MediaPortal!

    The team works very hard to make sure the community is running the best HTPC-software. We give away MediaPortal for free but hosting and software is not for us.

    Care to support our work with a few bucks? We'd really appreciate it!