Here is how i manually modified the DerbyDB, it was just a test so i grabbed the first DerbyDB IDE i could find, it is kind of a pain but it does the job,
grab NetBeans IDE 7.2 (the version that says that have the derby embeed, i think it was the java eee -the bigger in size or 2nd-)
grab java if u dont already have it (
http://www.oracle.com/technetwork/java/ ... index.html)
once NB is installed, create a new project, then window > services to open the services window, then right click to databases and add new connection.
add the driver file (in my case program files\java\jdk 1.7.0.07\db\lib\derby.jar)
write in the db location the serviio library\db folder
test connection > should succed, create
from there u have the (APP) media_item table in which it stores all the files, with the title name ,season number, episode number, and type of file (movie or series) and if its a series, u have to look for the id or create it in the table series
remember to first make a backup of the DB and stop the serviio service manually so u can access the DB