Talk:Databases

From Official Kodi Wiki
Revision as of 00:25, 1 April 2013 by >TiloWiki
Jump to navigation Jump to search

TO-DO (what needs to be added to this database article)

  • The layout, etc. will be explained in more detail here later.
  • Need to add music database information

These don't exist in MyMusic32 or MyVideos75, but will need confirmation as to whether or not they will be in the future: MyMusic32:

  • exartistablum - Links artists to albums
  • exartistsong - Links artists to songs
  • exgenrealbum - Links genres to albums
  • exgenresong - Links genres to songs
  • thumb

MyVideos75

  • tvshowlinkepisode - This table links TV shows (series) to episodes.

Example for update on Watched

  • TiloWiki 20:25, 31 March 2013 (EDT)
  • Here a simple example to update the watched flag based on a folder
--Check with this SQL
select * from files where idFile in (select idFile From movieview where playcount is null and strPath like '%A_alreadyViewed%')

--Update with this SQL
update files set playcount = '1', lastplayed = '2013-03-30 17:55:55'  where idFile in (select idFile From movieview where playcount is null and strPath like '%A_alreadyViewed%')