2011-07-07, 04:13
I just had a quick look at it, and at a glance it looks like it could be done by converting all the tables to view except for `xbmc_video`.`files` - `files` is the table that seems to store the watched data. But having a second database that's 99% a view of the first, but with a files table that is local, we should be able to have a working secondary unit (which is what I really want, units not profiles) that can write it's own watched data.
I'll just need to write a trigger to replicate everything over from the real `files` table on insert/update/delete except for the playCount and lastPlayed fields.
I'll post an update once I get a change to actually do it, but so far I've got a working version where `tvshowview` is working off of views except for the `files` table.
I'll just need to write a trigger to replicate everything over from the real `files` table on insert/update/delete except for the playCount and lastPlayed fields.
I'll post an update once I get a change to actually do it, but so far I've got a working version where `tvshowview` is working off of views except for the `files` table.