Talk:Databases
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%')