Talk:Databases: Difference between revisions
Jump to navigation
Jump to search
>Mshorts No edit summary |
>TiloWiki No edit summary |
||
| Line 13: | Line 13: | ||
MyVideos75 | MyVideos75 | ||
* tvshowlinkepisode - This table links TV shows (series) to episodes. | * tvshowlinkepisode - This table links TV shows (series) to episodes. | ||
==Example for update on Watched== | |||
* [[User:TiloWiki|TiloWiki]] 20:25, 31 March 2013 (EDT) | |||
* Here a simple example to update the watched flag based on a folder | |||
<syntaxhighlight lang="SQL"> | |||
--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%') | |||
</syntaxhighlight> | |||
Revision as of 00:25, 1 April 2013
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%')