[m.savazzi]

I read this thread an didn't found any sketch/scheme besides Dans picture (nice work!) to display the new scheme. Is there a place where I can take a look at the structure? (like example MediaDatabaseSQL_v1.txt, demo.emm database which can be watched with SQLITEBrowser?) If this hasn't be done maybe we should pick the current MediaDatabaseSQL_v1.txt which displays all the Ember tables and just post here and mark/edit the changes based on our discussion?

sent link via PM

thanks for sending! ok I looked into that and looks fine to me - the tag/keyword table we talked about is missing I think, but it's just 1:1 copy of genre-table just (different name) so thats no problem at all.
Thats for the tables/relations in database - I noticed there aren't any columns/field names mentioned yet but I think we can use the current fields of ember tables and dropping the "HAS..." fields which we can obtain with SQL query..

Removing other tables, adding new Keywords table

Cocotus I've not understood what you mean here:

I noticed there aren't any columns/field names mentioned yet but I think we can use the current fields of ember tables and dropping the "HAS..." fields which we can obtain with SQL query..

What are you talking?