2016-04-09, 12:09
so, *someone* accidentally updated to the latest kodi version with their android tablet and I had to migrate all other openelec boxes to the current beta a little early.
in the process, I created two scripts. One to modify a "clean" MyVideos99 (Kodi 16) table to include the additional filestates for each user and another one to actually upgrade an existing MyVideos93 (Kodi 15, with existing filestates stuff) to the new MyVideos99 structure. maybe they are helpful to anyone.
I tested both versions with HeidiSQL, but as always - no guarantees.
CloudFlare prevents embedding the scripts as code, so I need to fall back to dropbox. sorry for that.
Upgrade-MyVideos93-to-MyVideos99.sql: You need to create a 1:1 copy of MyVideos93, name it MyVideos99 and apply the script. after that, you still need to manually edit the one entry in the "version" table.
*edit*: I noticed that kodi is doing some adjustments on the data during upgrade. Main problem here is that a new field "idSeason" is populated in the episode table. I added Upgrade-episode-table.sql to take care of this, but I'm not sure on what else might be missing. Maybe we should prefer method 2 below... If you want to risk it, just execute the new script after the actual upgrade.
If you are coming from a different version then MyVideos93 or don't have a database yet or {insert any other reason}, you can use Modify-MyVideos99.sql. Just apply to a clean db created by kodi. one could use this in combination with the very good import / export feature of texturecache.py to still import existing watched states. to do this, just import the watched states after configuring the advancedsettings.xml for the user the watched states should be applied to.
in the process, I created two scripts. One to modify a "clean" MyVideos99 (Kodi 16) table to include the additional filestates for each user and another one to actually upgrade an existing MyVideos93 (Kodi 15, with existing filestates stuff) to the new MyVideos99 structure. maybe they are helpful to anyone.
I tested both versions with HeidiSQL, but as always - no guarantees.
CloudFlare prevents embedding the scripts as code, so I need to fall back to dropbox. sorry for that.
Upgrade-MyVideos93-to-MyVideos99.sql: You need to create a 1:1 copy of MyVideos93, name it MyVideos99 and apply the script. after that, you still need to manually edit the one entry in the "version" table.
*edit*: I noticed that kodi is doing some adjustments on the data during upgrade. Main problem here is that a new field "idSeason" is populated in the episode table. I added Upgrade-episode-table.sql to take care of this, but I'm not sure on what else might be missing. Maybe we should prefer method 2 below... If you want to risk it, just execute the new script after the actual upgrade.
If you are coming from a different version then MyVideos93 or don't have a database yet or {insert any other reason}, you can use Modify-MyVideos99.sql. Just apply to a clean db created by kodi. one could use this in combination with the very good import / export feature of texturecache.py to still import existing watched states. to do this, just import the watched states after configuring the advancedsettings.xml for the user the watched states should be applied to.
