2022-06-16, 04:34
Tonight I created a WatchedList database with Collation utf8_general-ci.
I then pointed Kodi WatchedList add-on to the database and it seems to have populated the database on my new NAS MariaDB10.
However, the structure is different.
On my SQL setup, under the WatchedList database there is subfolders:
New
episode_watched, with columns and indexes
movie_watched, with columns and indexes
tvshows, with columns and indexes
On my new MariaDB10 there are none of these subfolders. When I click on the WatchedList database, to the right is Table:
episode_watched
movie_watched
tvshows.
The row counts are not the same, but close.
Did I do it wrong or does MariaDB10 handle the WatchedList structure differently than SQL?
I then pointed Kodi WatchedList add-on to the database and it seems to have populated the database on my new NAS MariaDB10.
However, the structure is different.
On my SQL setup, under the WatchedList database there is subfolders:
New
episode_watched, with columns and indexes
movie_watched, with columns and indexes
tvshows, with columns and indexes
On my new MariaDB10 there are none of these subfolders. When I click on the WatchedList database, to the right is Table:
episode_watched
movie_watched
tvshows.
The row counts are not the same, but close.
Did I do it wrong or does MariaDB10 handle the WatchedList structure differently than SQL?