2010-10-23, 13:27
Montellese Wrote:I have no clue why there are multiple databases (well someday you'll have to decide for either one of them) but I don't think that rewriting it will be worth the effort because there already is a proposal (work in progress) for a new database schema at http://forum.xbmc.org/showthread.php?tid=73831 (but of course you know that as you have also posted there )
My thought was that incremental changes would be better than one big and potentially destabilizing change. E.g., fix up column names (get rid of the cxxs) in one; ensure table names are unique across databases in another; then merge databases; add appropriate foreign keys; etc. Firnsy encouraged incremental changes in the thread you refer to, even with the potential new schema, and the new "4.0a" schema can be reached incrementally yet offers several advantages over the current schema (and over an EAV/CR model too, for that matter).