Databases/MyVideos: Difference between revisions
(Updated for v18) |
|||
(14 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
{{Template:DatabasesNavBox}} | {{Template:DatabasesNavBox}} | ||
{{mininav| [[Development]] {{l2| [[Userdata]]}} | [[Databases]] }} | {{mininav| [[Development]] {{l2| [[Userdata]]}} | [[Databases]] }} | ||
Line 10: | Line 9: | ||
The current stable release of {{kodi}} is using the following version of the database: | The current stable release of {{kodi}} is using the following version of the database: | ||
;Kodi | ;Kodi v20 - MyVideos121.db | ||
Line 21: | Line 20: | ||
== episode_view == | |||
== | |||
A view that joins episode to file and tvshow (through tvshowlinkepisode) and path. | A view that joins episode to file and tvshow (through tvshowlinkepisode) and path. | ||
Line 36: | Line 34: | ||
|c01 || text || Plot Summary | |c01 || text || Plot Summary | ||
|- | |- | ||
|c02 || text || | |c02 || text || Not Used | ||
|- | |- | ||
|c03 || text || Rating | |c03 || text || Link to [[Databases/MyVideos#rating|Rating Table]] | ||
|- | |- | ||
|c04 || text || Writer | |c04 || text || Writer | ||
Line 46: | Line 44: | ||
|c06 || text || Thumbnail URL | |c06 || text || Thumbnail URL | ||
|- | |- | ||
|c07 || text || | |c07 || text || Thumbnail URL Spoof | ||
|- | |- | ||
|c08 || text || | |c08 || text || Not Used | ||
|- | |- | ||
|c09 || text || | |c09 || text || Runtime | ||
|- | |- | ||
|c10 || text || Director | |c10 || text || Director | ||
|- | |- | ||
|c11 || text || | |c11 || text || Production Code | ||
|- | |- | ||
|c12 || varchar(24) || Season Number | |c12 || varchar(24) || Season Number | ||
Line 60: | Line 58: | ||
|c13 || tvarchar(24)ext || Episode Number | |c13 || tvarchar(24)ext || Episode Number | ||
|- | |- | ||
|c14 || text || | |c14 || text || Original Title | ||
|- | |- | ||
|c15 || text || Season formatted for sorting | |c15 || text || Season formatted for sorting | ||
Line 70: | Line 68: | ||
|c18 || text || Path to episode file | |c18 || text || Path to episode file | ||
|- | |- | ||
|c19 || text || | |c19 || text || Link to [[Databases/MyVideos#path|Path Table]] | ||
|- | |- | ||
|c20 || text || | |c20 || text || Link to [[Databases/MyVideos#uniqueid|UniqueID Table]] | ||
|- | |- | ||
|c21 || text || Not used | |c21 || text || Not used | ||
Line 118: | Line 116: | ||
|rating_type || text || Type of rating | |rating_type || text || Type of rating | ||
|- | |- | ||
|uniqueid_value || text || | |uniqueid_value || text || Default UniqueID ( default="true" ) | ||
|- | |- | ||
|uniqueid_type || text || | |uniqueid_type || text || Provider of the default UniqueID. eg... <uniqueid type="tmdb" default="true"> | ||
|} | |} | ||
== | == movie_view == | ||
A view that joins movie to file and | A view that joins movie to file, path, videoversion and videoversiontype. One record per movie version. Most values are the same for all versions of a movie. | ||
{|class="prettytable" | {|class="prettytable" | ||
Line 133: | Line 131: | ||
|idMovie || integer || Primary Key | |idMovie || integer || Primary Key | ||
|- | |- | ||
|idFile || integer || Foreign Key to [[Databases/MyVideos#files|files table]] | |idFile || integer || Foreign Key to [[Databases/MyVideos#files|files table]] for the default version of the movie. | ||
|- | |- | ||
|c00 || text || Local Movie Title | |c00 || text || Local Movie Title | ||
Line 143: | Line 141: | ||
|c03 || text || Movie Tagline | |c03 || text || Movie Tagline | ||
|- | |- | ||
|c04 || text || | |c04 || text || Not Used | ||
|- | |- | ||
|c05 || text || Link to [[Databases/MyVideos#rating|Rating Table]] | |c05 || text || Link to [[Databases/MyVideos#rating|Rating Table]] | ||
Line 149: | Line 147: | ||
|c06 || text || Writers | |c06 || text || Writers | ||
|- | |- | ||
|c07 || text || | |c07 || text || Not Used | ||
|- | |- | ||
|c08 || text || Image URL | |c08 || text || Image URL | ||
|- | |- | ||
|c09 || text || | |c09 || text || Link to [[Databases/MyVideos#uniqueid|uniqueid Table]] | ||
|- | |- | ||
|c10 || text || Title formatted for sorting | |c10 || text || Title formatted for sorting | ||
|- | |- | ||
|c11 || text || Runtime | |c11 || text || Runtime | ||
|- | |- | ||
|c12 || text || MPAA Rating | |c12 || text || MPAA Rating | ||
Line 169: | Line 167: | ||
|c16 || text || Original Movie Title | |c16 || text || Original Movie Title | ||
|- | |- | ||
|c17 || text || | |c17 || text || Thumb URL Spoof] | ||
|- | |- | ||
|c18 || text || Studio | |c18 || text || Studio | ||
Line 177: | Line 175: | ||
|c20 || text || Fanart URLs | |c20 || text || Fanart URLs | ||
|- | |- | ||
|c21 || text || Country | |c21 || text || Country | ||
|- | |- | ||
|c22 || text || Path to playable file | |c22 || text || Path to playable file | ||
|- | |- | ||
|c23 || text || | |c23 || text || Link to [[Databases/MyVideos#path|path table]] for Source folder | ||
|- | |- | ||
|idSet || integer || Foreign Key to [[Databases/MyVideos#sets|sets table]] | |idSet || integer || Foreign Key to [[Databases/MyVideos#sets|sets table]] | ||
Line 215: | Line 213: | ||
|rating_type || text || Type of rating | |rating_type || text || Type of rating | ||
|- | |- | ||
|uniqueid_value || text || | |uniqueid_value || text || Default UniqueID ( default="true" ) | ||
|- | |||
|uniqueid_type || text || Provider of the default UniqueID. eg... <uniqueid type="tmdb" default="true"> | |||
|- | |- | ||
| | |hasVideoVersions || integer || 0 = the movie has a single version; 1 = the movie has additional versions | ||
|- | |||
|hasVideoExtras || integer || 0 = No Extras; 1 = has Extras | |||
|- | |||
|isDefaultVersion || integer || 0 = Not the default / parent version; 1 = Default / parent version | |||
|- | |||
|videoVersionIdFile || integer || [version specific] Foreign Key to [[Databases/MyVideos#files|files table]] | |||
|- | |||
|videoVersionTypeId || integer || [version specific] Foreign Key to [[Databases/MyVideos#videoversiontype|videoversiontype table]] | |||
|- | |||
|videoVersionTypeName || text || [version specific] Descriptive name of the version, see [[Databases/MyVideos#videoversiontype|videoversiontype table]] | |||
|- | |||
|VideoVersionTypeItemType || integer || [version specific] Type of the version, see [[Databases/MyVideos#videoversiontype|videoversiontype table]] | |||
|} | |} | ||
== | == musicvideo_view == | ||
A view that joins musicvideo to file and path. | A view that joins musicvideo to file and path. | ||
{|class="prettytable" | {|class="prettytable" | ||
Line 231: | Line 243: | ||
|idFile || integer || Foreign Key to [[Databases/MyVideos#files|files table]] | |idFile || integer || Foreign Key to [[Databases/MyVideos#files|files table]] | ||
|- | |- | ||
|c00 || text || Title | |c00 || text || Title | ||
|- | |- | ||
|c01 || text || | |c01 || text || Thumb URL | ||
|- | |- | ||
|c02 || text || | |c02 || text || Thumb URL spoof | ||
|- | |- | ||
|c03 || text || | |c03 || text || Not Used | ||
|- | |- | ||
|c04 || text || Run time | |c04 || text || Run time | ||
|- | |- | ||
|c05 || text || Director | |c05 || text || Director | ||
|- | |- | ||
|c06 || text || Studios | |c06 || text || Studios | ||
|- | |- | ||
|c07 || text || | |c07 || text || Not Used | ||
|- | |- | ||
|c08 || text || Plot | |c08 || text || Plot | ||
|- | |- | ||
|c09 || text || Album | |c09 || text || Album | ||
|- | |- | ||
|c10 || text || Artist | |c10 || text || Artist | ||
|- | |- | ||
|c11 || text || Genre | |c11 || text || Genre | ||
|- | |- | ||
|c12 || text || Track | |c12 || text || Track | ||
|- | |- | ||
|c13 || text || | |c13 || text || Path to playable file | ||
|- | |- | ||
|c14 || text || | |c14 || text || Link to [[Databases/MyVideos#path|path table]] for Source folder | ||
|- | |- | ||
|c15 || text || | |c15 || text || Not Used | ||
|- | |- | ||
|c16 || text || | |c16 || text || Not Used | ||
|- | |- | ||
|c17 || text || | |c17 || text || Not Used | ||
|- | |- | ||
|c18 || text || | |c18 || text || Not Used | ||
|- | |- | ||
|c19 || text || | |c19 || text || Not Used | ||
|- | |- | ||
|c20 || text || | |c20 || text || Not Used | ||
|- | |- | ||
|c21 || text || | |c21 || text || Not Used | ||
|- | |- | ||
|c22 || text || | |c22 || text || Not Used | ||
|- | |- | ||
|c23 || text || | |c23 || text || Not Used | ||
|- | |- | ||
|userrating || integer || User Rating | |userrating || integer || User Rating | ||
Line 302: | Line 314: | ||
== season_view == | == season_view == | ||
A view that joins seasons to the tvshow. | A view that joins seasons to the tvshow. | ||
Line 334: | Line 346: | ||
|episodes || text || Season episode count | |episodes || text || Season episode count | ||
|- | |- | ||
|playCount || | |playCount || integer || Number of play times. Each played episode increases the count | ||
|- | |||
|aired || text || Aired date of the first episode in the season | |||
|- | |- | ||
| | |inProgressCount || integer || Show watched/in progress/total counts in home screen listings and video window listings<ref>https://github.com/xbmc/xbmc/pull/23658</ref> | ||
|} | |} | ||
== | == tvshow_view == | ||
View that joins tvshow to path. Also produces information about total number of episodes as well as number of watched and unwatched episodes. | View that joins tvshow to path. Also produces information about total number of episodes as well as number of watched and unwatched episodes. | ||
{|class="prettytable" | {|class="prettytable" | ||
Line 380: | Line 394: | ||
|c15 || text || Title formatted for sorting | |c15 || text || Title formatted for sorting | ||
|- | |- | ||
|c16 || text || | |c16 || text || Trailer | ||
|- | |- | ||
|c17 || text || Not Used | |c17 || text || Not Used | ||
Line 400: | Line 414: | ||
|duration || integer || Total duration | |duration || integer || Total duration | ||
|- | |- | ||
|idParentPath || integer || | |idParentPath || integer || | ||
|- | |- | ||
|strPath || text || Path URL | |strPath || text || Path URL | ||
Line 420: | Line 434: | ||
|rating_type || text || Type of rating | |rating_type || text || Type of rating | ||
|- | |- | ||
|uniqueid_value || text || | |uniqueid_value || text || Default UniqueID ( default="true" ) | ||
|- | |- | ||
|uniqueid_type || text || | |uniqueid_type || text || Provider of the default UniqueID. eg... <uniqueid type="tmdb" default="true"> | ||
|- | |||
|inProgressCount || integer || Show in progress episodes count along with watched episodes and total episodes count in home screen listings and video window listings.<ref>https://github.com/xbmc/xbmc/pull/23658</ref> | |||
|} | |} | ||
== | == tvshowcounts == | ||
This table stores the TV Show watched count, total seasons, last played and date added data | This table stores the TV Show watched count, total seasons, last played and date added data | ||
{|class="prettytable" | {|class="prettytable" | ||
Line 443: | Line 459: | ||
|- | |- | ||
|dateAdded || text || Date Added | |dateAdded || text || Date Added | ||
|- | |||
|inProgressCount || integer || Show in progress episodes count along with watched episodes and total episodes count in home screen listings and video window listings.<ref>https://github.com/xbmc/xbmc/pull/23658</ref> | |||
|} | |} | ||
== | == tvshowlinkpath_minview == | ||
Joins TV Show to Path | Joins TV Show to Path | ||
{|class="prettytable" | {|class="prettytable" | ||
Line 458: | Line 476: | ||
{{top}} | |||
Line 466: | Line 484: | ||
== actor == | |||
== actor == | |||
This table stores actor, artist, director, and writer information. | This table stores actor, artist, director, and writer information. | ||
Line 491: | Line 508: | ||
== actor_link == | == actor_link == | ||
This table links actors to Movies, TV Shows, Episodes, Music Videos and stores role information. | This table links actors to Movies, TV Shows, Episodes, Music Videos and stores role information. | ||
Line 519: | Line 536: | ||
== art == | == art == | ||
This table stores URLs for video art metadata. | This table stores URLs for video art metadata. | ||
Line 533: | Line 550: | ||
|media_id || integer || The id of the media this piece of art is for || || || || | |media_id || integer || The id of the media this piece of art is for || || || || | ||
|- | |- | ||
|media_type || text || The type of media this art applies to - movie, set, tvshow, season, episode, musicvideo or | |media_type || text || The type of media this art applies to - movie, set, tvshow, season, episode, musicvideo, actor or videoversion|| || || || | ||
|- | |- | ||
|type || text || The image type - poster, fanart, thumb, banner, landscape, clearlogo, clearart, characterart or discart |||| || || | |type || text || The image type - poster, fanart, thumb, banner, landscape, clearlogo, clearart, characterart or discart |||| || || | ||
Line 571: | Line 588: | ||
|} | |} | ||
== bookmark == | |||
== bookmark == | |||
This table stores bookmarks, which are timestamps representing the point in a video where a user stopped playback, an explicit bookmark requested by the user, or an automatically generated episode bookmark. | This table stores bookmarks, which are timestamps representing the point in a video where a user stopped playback, an explicit bookmark requested by the user, or an automatically generated episode bookmark. | ||
Line 604: | Line 619: | ||
== country == | == country == | ||
This table lists countries. | This table lists countries. | ||
Line 617: | Line 632: | ||
== country link == | == country link == | ||
This table links countries to movies. | This table links countries to movies. | ||
Line 632: | Line 647: | ||
== director_link == | == director_link == | ||
This table links directors to Movies, TV show episodes and Music Videos | This table links directors to Movies, TV show episodes and Music Videos | ||
Line 647: | Line 662: | ||
== episode == | == episode == | ||
This table stores television episode information. Information concerning the series is stored in [[Databases/MyVideos#tvshow|tvshow]]. To link an episode to its parent series, use [[Databases/MyVideos#tvshowlinkepisode|tvshowlinkepisode]]. | This table stores television episode information. Information concerning the series is stored in [[Databases/MyVideos#tvshow|tvshow]]. To link an episode to its parent series, use [[Databases/MyVideos#tvshowlinkepisode|tvshowlinkepisode]]. | ||
Line 662: | Line 677: | ||
|c01 || text || Plot Summary || <plot></plot> | |c01 || text || Plot Summary || <plot></plot> | ||
|- | |- | ||
|c02 || text || | |c02 || text || Not Used || | ||
|- | |- | ||
|c03 || text || Link to [[Databases/MyVideos#rating|Rating Table]] || | |c03 || text || Link to [[Databases/MyVideos#rating|Rating Table]] || | ||
Line 672: | Line 687: | ||
|c06 || text || Thumbnail URL || <thumb></thumb> | |c06 || text || Thumbnail URL || <thumb></thumb> | ||
|- | |- | ||
|c07 || text || | |c07 || text || Thumbnail URL Spoof || | ||
|- | |- | ||
|c08 || text || | |c08 || text || Not Used || | ||
|- | |- | ||
|c09 || text || | |c09 || text || Runtime || <runtime></runtime> | ||
|- | |- | ||
|c10 || text || Director || <director></director> | |c10 || text || Director || <director></director> | ||
|- | |- | ||
|c11 || text || | |c11 || text || Production Code || <code></code> | ||
|- | |- | ||
|c12 || varchar(24) || Season Number || <season></season> | |c12 || varchar(24) || Season Number || <season></season> | ||
Line 688: | Line 703: | ||
|c14 || text || Original Title || <originaltitle></originaltitle> | |c14 || text || Original Title || <originaltitle></originaltitle> | ||
|- | |- | ||
|c15 || text || Season | |c15 || text || Season Number- Specials Sorting || <displayseason></displayseason> | ||
|- | |- | ||
|c16 || text || Episode | |c16 || text || Episode Number- Specials Sorting || <displayepisode></displayepisode> | ||
|- | |- | ||
|c17 || varchar(24) || Bookmark || | |c17 || varchar(24) || Bookmark || | ||
Line 696: | Line 711: | ||
|c18 || text || Path to episode file || | |c18 || text || Path to episode file || | ||
|- | |- | ||
|c19 || text || | |c19 || text || Link to [[Databases/MyVideos#path|Path Table]] || | ||
|- | |- | ||
|c20 || text || | |c20 || text || Link to [[Databases/MyVideos#uniqueid|UniqueID Table]] || | ||
|- | |- | ||
|c21 || text || Not used || | |c21 || text || Not used || | ||
Line 715: | Line 730: | ||
== files == | == files == | ||
This table stores filenames and links the path. | This table stores filenames and links the path. | ||
Line 736: | Line 751: | ||
== genre == | == genre == | ||
This table stores genre information. For convenience the contents are duplicated in [[Databases/MyVideos#movie|movie]] and [[Databases/MyVideos#tvshow|tvshow]], so a join isn't necessary. | This table stores genre information. For convenience the contents are duplicated in [[Databases/MyVideos#movie|movie]] and [[Databases/MyVideos#tvshow|tvshow]], so a join isn't necessary. | ||
Line 749: | Line 764: | ||
== genre_link == | == genre_link == | ||
This table links genres to movies. (The contents are also stored in movies.c14, though.) | This table links genres to movies. (The contents are also stored in movies.c14, though.) | ||
Line 764: | Line 779: | ||
== movie == | == movie == | ||
This table stores movie information. | This table stores movie information. | ||
Line 783: | Line 798: | ||
|c03 || text || Movie Tagline || <tagline></tagline> | |c03 || text || Movie Tagline || <tagline></tagline> | ||
|- | |- | ||
|c04 || text || | |c04 || text || Not Used || | ||
|- | |- | ||
|c05 || text || Link to [[Databases/MyVideos#rating|Rating Table]] || | |c05 || text || Link to [[Databases/MyVideos#rating|Rating Table]] || | ||
Line 789: | Line 804: | ||
|c06 || text || Writers || <credits></credits> | |c06 || text || Writers || <credits></credits> | ||
|- | |- | ||
|c07 || text || | |c07 || text || Not Used || | ||
|- | |- | ||
|c08 || text || Image URL || <thumb aspect="poster" preview=""></thumb> | |c08 || text || Image URL || <thumb aspect="poster" preview=""></thumb> | ||
|- | |- | ||
|c09 || text || | |c09 || text || Link to [[Databases/MyVideos#uniqueid|uniqueid Table]] || | ||
|- | |- | ||
|c10 || text || Title formatted for sorting || <sorttitle></sorttitle> | |c10 || text || Title formatted for sorting || <sorttitle></sorttitle> | ||
|- | |- | ||
|c11 || text || Runtime | |c11 || text || Runtime || <runtime></runtime> ** | ||
|- | |- | ||
|c12 || text || MPAA Rating || <mpaa></mpaa> | |c12 || text || MPAA Rating || <mpaa></mpaa> | ||
Line 809: | Line 824: | ||
|c16 || text || Original Movie Title || <originaltitle></originaltitle> | |c16 || text || Original Movie Title || <originaltitle></originaltitle> | ||
|- | |- | ||
|c17 || text || | |c17 || text || Thumb URL Spoof || | ||
|- | |- | ||
|c18 || text || Studio || <studio></studio> | |c18 || text || Studio || <studio></studio> | ||
Line 821: | Line 836: | ||
</fanart> | </fanart> | ||
|- | |- | ||
|c21 || text || Country | |c21 || text || Country || <country></country> | ||
|- | |- | ||
|c22 || text || Path to playable file || | |c22 || text || Path to playable file || | ||
|- | |- | ||
|c23 || text || | |c23 || text || Link to [[Databases/MyVideos#path|path table]] for Source folder || | ||
|- | |- | ||
|idSet || integer || Foreign Key to [[Databases/MyVideos#sets|sets table]] || | |idSet || integer || Foreign Key to [[Databases/MyVideos#sets|sets table]] || | ||
Line 841: | Line 856: | ||
== movielinktvshow == | == movielinktvshow == | ||
This table links movies to TV shows. | This table links movies to TV shows. | ||
Line 854: | Line 869: | ||
== musicvideo == | == musicvideo == | ||
{|class="prettytable" | {|class="prettytable" | ||
Line 865: | Line 880: | ||
|c00 || text || Title || <title></title> | |c00 || text || Title || <title></title> | ||
|- | |- | ||
|c01 || text || | |c01 || text || Thumb URL || <thumb preview=""></thumb> | ||
|- | |- | ||
|c02 || text || | |c02 || text || Thumb URL spoof || | ||
|- | |- | ||
|c03 || text || | |c03 || text || Not Used || | ||
|- | |- | ||
|c04 || text || Run time || <runtime></runtime> | |c04 || text || Run time || <runtime></runtime> | ||
Line 877: | Line 892: | ||
|c06 || text || Studios || <studio></studio> | |c06 || text || Studios || <studio></studio> | ||
|- | |- | ||
|c07 || text || | |c07 || text || Not Used || | ||
|- | |- | ||
|c08 || text || Plot || <plot></plot> | |c08 || text || Plot || <plot></plot> | ||
Line 887: | Line 902: | ||
|c11 || text || Genre || <genre></genre> | |c11 || text || Genre || <genre></genre> | ||
|- | |- | ||
|c12 || text || Track || | |c12 || text || Track || | ||
|- | |- | ||
|c13 || text || Path to playable file || <filenameandpath></filenameandpath | |c13 || text || Path to playable file || <filenameandpath></filenameandpath> | ||
|- | |- | ||
|c14 || text || | |c14 || text || Link to [[Databases/MyVideos#path|path table]] for Source folder || <basepath></basepath> | ||
|- | |- | ||
|c15 || text || | |c15 || text || Not Used || | ||
|- | |- | ||
|c16 || text || | |c16 || text || Not Used || | ||
|- | |- | ||
|c17 || text || | |c17 || text || Not Used || | ||
|- | |- | ||
|c18 || text || | |c18 || text || Not Used || | ||
|- | |- | ||
|c19 || text || | |c19 || text || Not Used || | ||
|- | |- | ||
|c20 || text || | |c20 || text || Not Used || | ||
|- | |- | ||
|c21 || text || | |c21 || text || Not Used || | ||
|- | |- | ||
|c22 || text || | |c22 || text || Not Used || | ||
|- | |- | ||
|c23 || text || | |c23 || text || Not Used || | ||
|- | |- | ||
|userrating || integer || Rating applied by user || <userrating></userrating> | |userrating || integer || Rating applied by user || <userrating></userrating> | ||
|- | |- | ||
|premiered || text || Date movie premiered || < | |premiered || text || Date movie premiered || <premiered></premiered> | ||
|} | |} | ||
== path == | == path == | ||
This table stores path information. | This table stores path information. | ||
Line 930: | Line 945: | ||
|strContent || text || Type of content (tvshows, movies, etc...) | |strContent || text || Type of content (tvshows, movies, etc...) | ||
|- | |- | ||
|strScraper || text || | |strScraper || text || addon ID | ||
|- | |- | ||
|strHash || text || Hash | |strHash || text || Hash | ||
Line 943: | Line 958: | ||
|- | |- | ||
|exclude || bool || | |exclude || bool || | ||
|- | |||
|allAudio || bool || Skip filename matching for external audio tracks<br>0 = Disabled<br>1 = Enabled | |||
|- | |- | ||
|dateAdded || text || | |dateAdded || text || | ||
Line 951: | Line 968: | ||
== rating == | == rating == | ||
This table stores the ratings for TV Shows, Episodes and Movies | This table stores the ratings for TV Shows, Episodes and Movies | ||
Line 980: | Line 997: | ||
== seasons == | == seasons == | ||
This table stores the links between tv show and seasons. | This table stores the links between tv show and seasons. | ||
Line 992: | Line 1,009: | ||
|season || integer || Season number || <season></season> | |season || integer || Season number || <season></season> | ||
|- | |- | ||
|name || text || Season Name || | |name || text || Season Name || <namedseason number="n"></namedseason><br/> n = season number | ||
|- | |- | ||
|userrating || integer || Season level User Rating || | |userrating || integer || Season level User Rating || | ||
Line 999: | Line 1,016: | ||
== sets == | == sets == | ||
This table stores the id and name for movie sets. Sets are linked to movies in the movie table (idSet column). | This table stores the id and name for movie sets. Sets are linked to movies in the movie table (idSet column). | ||
Line 1,020: | Line 1,037: | ||
== settings == | == settings == | ||
This table stores settings for individual files. | This table stores settings for individual files. | ||
Line 1,087: | Line 1,104: | ||
== stacktimes == | == stacktimes == | ||
This table stores playing times for files (used for playing multi-file videos). | This table stores playing times for files (used for playing multi-file videos). | ||
Line 1,100: | Line 1,117: | ||
== streamdetails == | == streamdetails == | ||
This table contains information regarding codecs used, aspect ratios etc | This table contains information regarding codecs used, aspect ratios etc | ||
Line 1,107: | Line 1,124: | ||
! rowspan="1" style="text-align: centre;" | Movies **<br />TV Episode ** | ! rowspan="1" style="text-align: centre;" | Movies **<br />TV Episode ** | ||
! rowspan="1" style="text-align: centre;" | Music Videos ** | ! rowspan="1" style="text-align: centre;" | Music Videos ** | ||
! Version<br/>Added | |||
|- | |- | ||
|idFile || integer || Foreign Key to [[Databases/MyVideos#files|files table]] || || | |idFile || integer || Foreign Key to [[Databases/MyVideos#files|files table]] || || || | ||
|- | |- | ||
|iStreamType || integer || 0 = video, 1 = audio, 2 = subtitles || || | |iStreamType || integer || 0 = video, 1 = audio, 2 = subtitles || || || | ||
|- | |- | ||
|strVideoCodec|| text || Video codex (xvid etc) | |strVideoCodec|| text || Video codex (xvid etc) | ||
Line 1,134: | Line 1,152: | ||
|iVideoHeight|| integer || Height of the video | |iVideoHeight|| integer || Height of the video | ||
|- | |- | ||
|iVideoDuration|| integer || Actual runtime in sec | |iVideoDuration|| integer || Actual runtime in sec | ||
|- | |- | ||
|strStereoMode || text || Stereo Mode | |strStereoMode || text || Stereo Mode | ||
|- | |- | ||
|strAudioCodec|| text || Audio codec (aac, mp3 etc) | |strAudioCodec|| text || Audio codec (aac, mp3 etc) | ||
| rowspan="3" style="text-align: left;" | | | rowspan="3" style="text-align: left;" | | ||
<fileinfo> | <fileinfo> | ||
Line 1,177: | Line 1,195: | ||
| rowspan="1" style="text-align: left;" | | | rowspan="1" style="text-align: left;" | | ||
|- | |- | ||
|strVideoLanguage|| text || Language of the Video || | |strVideoLanguage|| text || Language of the Video || || || | ||
|- | |||
|strHdrType|| text || hdr type of the video || <hdrtype></hdrtype> || || v20 <ref>https://github.com/xbmc/xbmc/pull/19983</ref> | |||
|} | |} | ||
Line 1,188: | Line 1,208: | ||
== studio == | == studio == | ||
This table stores studio information. | This table stores studio information. | ||
Line 1,201: | Line 1,221: | ||
== studio link == | == studio link == | ||
This table links studios to movies, music videos and tv shows | This table links studios to movies, music videos and tv shows | ||
Line 1,216: | Line 1,236: | ||
== tag == | == tag == | ||
This stores tags. | This stores tags. | ||
Line 1,229: | Line 1,249: | ||
== | == tag_link == | ||
This table links tags to various media. | This table links tags to various media. | ||
Line 1,244: | Line 1,264: | ||
== tvshow == | == tvshow == | ||
This table stores information about a television series. Information concerning the shows episodes is stored in [[Databases/MyVideos#episode|episode]]. To link a TV show to its episodes, use [[Databases/MyVideos#tvshowlinkepisode|tvshowlinkepisode]]. | This table stores information about a television series. Information concerning the shows episodes is stored in [[Databases/MyVideos#episode|episode]]. To link a TV show to its episodes, use [[Databases/MyVideos#tvshowlinkepisode|tvshowlinkepisode]]. | ||
Line 1,290: | Line 1,310: | ||
|c15 || text || Title formatted for sorting || <sorttitle></sorttitle> | |c15 || text || Title formatted for sorting || <sorttitle></sorttitle> | ||
|- | |- | ||
|c16 || text || | |c16 || text || Trailer || <trailer></trailer> | ||
|- | |- | ||
|c17 || text || Not Used || | |c17 || text || Not Used || | ||
Line 1,311: | Line 1,331: | ||
|} | |} | ||
== tvshowlinkpath == | == tvshowlinkpath == | ||
This table links a TV show to its path. | This table links a TV show to its path. | ||
Line 1,324: | Line 1,344: | ||
== uniqueid == | == uniqueid == | ||
This table | This table holds the UniqueID's for Movies, TV shows and Episodes. Normally the UniqueID's are the ID's used at the scraper sites. For user created nfo files for say, home movies, the ID's are user nominated. Music Videos do not require a UniqueID. | ||
{|class="prettytable" | {|class="prettytable" | ||
Line 1,343: | Line 1,363: | ||
== version == | == version == | ||
This table stores database information. | This table stores database information. | ||
{|class="prettytable" | {|class="prettytable" | ||
Line 1,355: | Line 1,375: | ||
== writer_link == | == videoversion == | ||
This table stores the relations between media "parents" (movies, episodes, ...) and their video assets (versions, extras) for the Video Versions feature. <ref>https://github.com/xbmc/xbmc/pulls?page=4&q=is%3Apr+label%3A%22Feature%3A+Video+Versions%2FExtras%22+is%3Aclosed</ref> | |||
{|class="prettytable" | |||
! Column Name || Data Type || Description | |||
|- | |||
|idFile || integer || The video asset. Foreign Key to [[Databases/MyVideos#files|files table]] | |||
|- | |||
|idMedia || integer || id of the media | |||
|- | |||
|media_type || text || The type of media this asset is linked with (v21: the only supported value is "movie") | |||
|- | |||
|itemType || integer || Type of video asset. 0 = VideoVersion; 1 = Extras | |||
|- | |||
|idType || integer || Name of the video asset. Foreign key to the [[Databases/MyVideos#videoversiontype|videoversiontype table]] | |||
|} | |||
== videoversiontype == | |||
This table stores the version types/names and extras names for the Video Versions feature.<ref>https://github.com/xbmc/xbmc/pulls?page=4&q=is%3Apr+label%3A%22Feature%3A+Video+Versions%2FExtras%22+is%3Aclosed</ref> | |||
{|class="prettytable" | |||
! Column Name || Data Type || Description | |||
|- | |||
|id || integer || Primary Key | |||
|- | |||
|name || text || Name / type of the version or extra | |||
|- | |||
|owner || integer || 0 = prepopulated by the system; 1 = added by library scan; 2 = added by user | |||
|- | |||
|itemType || integer || type of asset the record applies to. 0 = Version; 1 = Extras | |||
|} | |||
== writer_link == | |||
This table links writers stored in the actors table to movies and episodes. | This table links writers stored in the actors table to movies and episodes. | ||
Line 1,367: | Line 1,417: | ||
|media_type || text || Media type for link | |media_type || text || Media type for link | ||
|} | |} | ||
= References = | |||
<references /> | |||
{{Top}} | {{Top}} | ||
{{updated|21}} | |||
[[Category:Karellen]] | [[Category:Karellen]] | ||
[[Category:Development]] | [[Category:Development]] | ||
[[Category:Video library]] | [[Category:Video library]] | ||
[[Category: | [[Category:Skin_development]] |
Latest revision as of 21:26, 27 May 2024
Kodi Databases
See also: |
---|
Development Userdata |
Databases | MyVideos |
MyVideos#
This database contains all information concerning TV shows, movies, and music videos. It is used in the Videos portion of Kodi.
The current stable release of Kodi is using the following version of the database:
- Kodi v20 - MyVideos121.db
Warning: The databases are critical components of Kodi. We strongly urge that you do not interfere with them, unless you have knowledge and experience with database designs.
Views
Views are standard queries, often long or complicated queries saved in the database for convenience. The views below allow you to easily access all the information about each of the main media types in the Video Library, across all the linking tables.
episode_view
A view that joins episode to file and tvshow (through tvshowlinkepisode) and path.
Column Name | Data Type | Description |
---|---|---|
idEpisode | integer | Primary Key |
idFile | integer | Foreign key to the files table |
c00 | text | Episode Title |
c01 | text | Plot Summary |
c02 | text | Not Used |
c03 | text | Link to Rating Table |
c04 | text | Writer |
c05 | text | First Aired |
c06 | text | Thumbnail URL |
c07 | text | Thumbnail URL Spoof |
c08 | text | Not Used |
c09 | text | Runtime |
c10 | text | Director |
c11 | text | Production Code |
c12 | varchar(24) | Season Number |
c13 | tvarchar(24)ext | Episode Number |
c14 | text | Original Title |
c15 | text | Season formatted for sorting |
c16 | text | Episode formatted for sorting |
c17 | varchar(24) | Bookmark |
c18 | text | Path to episode file |
c19 | text | Link to Path Table |
c20 | text | Link to UniqueID Table |
c21 | text | Not used |
c22 | text | Not used |
c23 | text | Not used |
idShow | integer | Foreign key to the tvshow table |
userrating | integer | User Rating |
idSeason | integer | Foreign key to the seasons table |
strFilename | text | Full name of file including extension |
strPath | text | Path to playable file |
playCount | integer | # of Times Played |
lastPlayed | text | Date & Time Last Played |
dateAdded | text | Date & Time Added to Library |
strTitle | text | Name of program |
genre | text | Genre |
studio | text | Studio |
premiered | text | Premiered Date |
mpaa | text | MPAA Rating |
resumeTimeInSeconds | double | Resume Point |
totalTimeInSeconds | double | Length of video |
playerState | text | |
rating | float | Rating |
votes | integer | Votes for rating |
rating_type | text | Type of rating |
uniqueid_value | text | Default UniqueID ( default="true" ) |
uniqueid_type | text | Provider of the default UniqueID. eg... <uniqueid type="tmdb" default="true"> |
movie_view
A view that joins movie to file, path, videoversion and videoversiontype. One record per movie version. Most values are the same for all versions of a movie.
Column Name | Data Type | Description |
---|---|---|
idMovie | integer | Primary Key |
idFile | integer | Foreign Key to files table for the default version of the movie. |
c00 | text | Local Movie Title |
c01 | text | Movie Plot |
c02 | text | Movie Plot Outline |
c03 | text | Movie Tagline |
c04 | text | Not Used |
c05 | text | Link to Rating Table |
c06 | text | Writers |
c07 | text | Not Used |
c08 | text | Image URL |
c09 | text | Link to uniqueid Table |
c10 | text | Title formatted for sorting |
c11 | text | Runtime |
c12 | text | MPAA Rating |
c13 | text | IMDB Top 250 Ranking |
c14 | text | Genre |
c15 | text | Director |
c16 | text | Original Movie Title |
c17 | text | Thumb URL Spoof] |
c18 | text | Studio |
c19 | text | Trailer URL |
c20 | text | Fanart URLs |
c21 | text | Country |
c22 | text | Path to playable file |
c23 | text | Link to path table for Source folder |
idSet | integer | Foreign Key to sets table |
userrating | integer | Rating applied by user |
premiered | text | Date movie premiered |
strSet | text | Movie Set |
strSetOverview | text | Movie Set plot |
strFilename | text | Full name of file including extension |
strPath | text | Path to playable file |
playCount | integer | # of Times Played |
lastPlayed | text | Date & Time Last Played |
dateAdded | text | Date & Time Added to Library |
resumeTimeInSeconds | double | Resume Point |
totalTimeInSeconds | double | Length of video |
playerState | text | |
rating | float | Rating |
votes | integer | Votes for rating |
rating_type | text | Type of rating |
uniqueid_value | text | Default UniqueID ( default="true" ) |
uniqueid_type | text | Provider of the default UniqueID. eg... <uniqueid type="tmdb" default="true"> |
hasVideoVersions | integer | 0 = the movie has a single version; 1 = the movie has additional versions |
hasVideoExtras | integer | 0 = No Extras; 1 = has Extras |
isDefaultVersion | integer | 0 = Not the default / parent version; 1 = Default / parent version |
videoVersionIdFile | integer | [version specific] Foreign Key to files table |
videoVersionTypeId | integer | [version specific] Foreign Key to videoversiontype table |
videoVersionTypeName | text | [version specific] Descriptive name of the version, see videoversiontype table |
VideoVersionTypeItemType | integer | [version specific] Type of the version, see videoversiontype table |
musicvideo_view
A view that joins musicvideo to file and path.
Column Name | Data Type | Description |
---|---|---|
idMVideo | integer | Primary Key |
idFile | integer | Foreign Key to files table |
c00 | text | Title |
c01 | text | Thumb URL |
c02 | text | Thumb URL spoof |
c03 | text | Not Used |
c04 | text | Run time |
c05 | text | Director |
c06 | text | Studios |
c07 | text | Not Used |
c08 | text | Plot |
c09 | text | Album |
c10 | text | Artist |
c11 | text | Genre |
c12 | text | Track |
c13 | text | Path to playable file |
c14 | text | Link to path table for Source folder |
c15 | text | Not Used |
c16 | text | Not Used |
c17 | text | Not Used |
c18 | text | Not Used |
c19 | text | Not Used |
c20 | text | Not Used |
c21 | text | Not Used |
c22 | text | Not Used |
c23 | text | Not Used |
userrating | integer | User Rating |
premiered | text | Premier of Music Video |
strFileName | text | Full name of file including extension |
strPath | text | Path URL |
playCount | integer | # of Times Played |
lastPlayed | text | Date & Time Last Played |
dateAdded | text | Date & Time Added to Library |
resumeTimeInSeconds | double | Time in seconds of bookmark location |
totalTimeInSeconds | double | Time in seconds of the video |
playerState | text |
season_view
A view that joins seasons to the tvshow.
Column Name | Data Type | Description |
---|---|---|
idSeason | integer | Primary Key |
idShow | integer | Foreign key to the tv show table |
Season | integer | Season number |
name | text | User modified Season name |
userrating | integer | User rating for season |
strPath | text | Path to tv show |
showTitle | text | TV Show name |
Plot | text | TV Show plot |
premiered | text | TV Show premiered date |
genre | text | genre |
studio | text | Studio |
mpaa | text | Certification |
episodes | text | Season episode count |
playCount | integer | Number of play times. Each played episode increases the count |
aired | text | Aired date of the first episode in the season |
inProgressCount | integer | Show watched/in progress/total counts in home screen listings and video window listings[1] |
tvshow_view
View that joins tvshow to path. Also produces information about total number of episodes as well as number of watched and unwatched episodes.
Column Name | Data Type | Description |
---|---|---|
idShow | integer | Primary Key |
c00 | text | Show Title |
c01 | text | Show Plot Summary |
c02 | text | Status |
c03 | text | Votes |
c04 | text | Rating |
c05 | text | First Aired |
c06 | text | Thumbnail URL |
c07 | text | [unknown - Spoof Thumbnail URL?] |
c08 | text | Genre |
c09 | text | Original Title |
c10 | text | Episode Guide URL |
c11 | text | Fan Art URL |
c12 | text | SeriesId (when using thetvdb.com scraper) |
c13 | text | Content Rating |
c14 | text | Network |
c15 | text | Title formatted for sorting |
c16 | text | Trailer |
c17 | text | Not Used |
c18 | text | Not Used |
c19 | text | Not Used |
c20 | text | [unknown] |
c21 | text | [unknown] |
c22 | text | [unknown] |
c23 | text | [unknown] |
userrating | integer | User Rating |
duration | integer | Total duration |
idParentPath | integer | |
strPath | text | Path URL |
dateAdded | text | Date & Time Added to Library |
lastPlayed | text | Date & Time Last Played |
totalCount | integer | # of Episodes |
watchedcount | integer | # of Times Played |
totalSeasons | integer | # of Seasons |
rating | float | Rating |
votes | integer | Votes for rating |
rating_type | text | Type of rating |
uniqueid_value | text | Default UniqueID ( default="true" ) |
uniqueid_type | text | Provider of the default UniqueID. eg... <uniqueid type="tmdb" default="true"> |
inProgressCount | integer | Show in progress episodes count along with watched episodes and total episodes count in home screen listings and video window listings.[2] |
tvshowcounts
This table stores the TV Show watched count, total seasons, last played and date added data
Column Name | Data Type | Description |
---|---|---|
idShow | integer | Primary Key |
lastPlayed | text | Date & Time Last Played |
totalCount | integer | # of Episodes |
watchedcount | integer | # of Times Played |
totalSeasons | integer | # of Seasons |
dateAdded | text | Date Added |
inProgressCount | integer | Show in progress episodes count along with watched episodes and total episodes count in home screen listings and video window listings.[3] |
tvshowlinkpath_minview
Joins TV Show to Path
Column Name | Data Type | Description |
---|---|---|
idShow | integer | Primary Key |
idPath | Foreign key to path table |
Return to top |
---|
Tables
The information in the Video Library is organized into the following tables. Several large tables (such as episode, movie, settings, and tvshow) contain the bulk of the information, while most of the others are used to link a long string to a common ID key.
actor
This table stores actor, artist, director, and writer information.
Column Name | Data Type | Description | Movies TV Show TV Episode |
Music Videos |
---|---|---|---|---|
actor_id | integer | Primary Key | ||
name | integer | Name of the actor, artist, director, or writer |
<actor> <name></name> <thumb></thumb> </actor> |
<artist></artist> |
art_urls | text | Image URL |
actor_link
This table links actors to Movies, TV Shows, Episodes, Music Videos and stores role information.
Column Name | Data Type | Description | Movies TV Show TV Episode |
Music Videos |
---|---|---|---|---|
actor_id | integer | Foreign key to actors table | ||
media_id | integer | Foreign key to episode table, tv show table, movie table,music video table | ||
media_type | text | Movie, TV Show, Episode, Music Video | <movie></movie> <tvshow></tvshow> <episodedetails></episodedetails> |
<musicvideo></musicvideo> |
role | text | Role the actor played |
<actor> <role></role> <order></order> </actor> |
n/a |
cast_order | integer | Order actors will be displayed |
art
This table stores URLs for video art metadata.
Column Name | Data Type | Description | Movies | TV Shows | TV Episode | Music Videos |
---|---|---|---|---|---|---|
art_id | integer | Primary Key | ||||
media_id | integer | The id of the media this piece of art is for | ||||
media_type | text | The type of media this art applies to - movie, set, tvshow, season, episode, musicvideo, actor or videoversion | ||||
type | text | The image type - poster, fanart, thumb, banner, landscape, clearlogo, clearart, characterart or discart | ||||
url | text | Image URL |
<thumb aspect="poster" preview=""></thumb> and <fanart> <thumb preview=""></thumb> </fanart> |
<fanart url=""> <thumb dim="" colors="" preview=""></thumb> </fanart> and <actor> <thumb></thumb> </actor> and <thumb aspect="" type="" season=""></thumb> |
<fanart> <thumb preview=""></thumb> </fanart> and <actor> <thumb></thumb> </actor> and <thumb></thumb> |
<art> <fanart></fanart> <poster></poster> </art> |
bookmark
This table stores bookmarks, which are timestamps representing the point in a video where a user stopped playback, an explicit bookmark requested by the user, or an automatically generated episode bookmark.
Column Name | Data Type | Description | Movies TV Show TV Episode |
---|---|---|---|
idBookmark | integer | Primary Key | |
idFile | integer | Foreign key to files table | |
timeInSeconds | double | Time in seconds of bookmark location |
<resume> <position></position> <total></total> </resume> |
totalTimeInSeconds | double | Time in seconds of the video | |
thumbNailImage | text | Thumbnail for bookmark | |
player | text | Player used to store bookmark | |
playerState | text | Player's internal state in XML | |
type | integer | Type of bookmark (0=standard, 1=resume, 2=episode) |
country
This table lists countries.
Column Name | Data Type | Description | Movies |
---|---|---|---|
country_id | integer | Primary Key | |
name | text | Country Name | <country></country> |
country link
This table links countries to movies.
Column Name | Data Type | Description |
---|---|---|
country_id | integer | Foreign key to country table |
media_id | integer | Foreign key to movie table |
media_type | text | Media Class |
director_link
This table links directors to Movies, TV show episodes and Music Videos
Column Name | Data Type | Description |
---|---|---|
actor_id | integer | Foreign key to actors table |
media_id | integer | Foreign key to episode table, movie table,music video table |
media_type | text | Movie, Music Video, Episode |
episode
This table stores television episode information. Information concerning the series is stored in tvshow. To link an episode to its parent series, use tvshowlinkepisode.
Column Name | Data Type | Description | TV Episode |
---|---|---|---|
idEpisode | integer | Primary Key | |
idFile | integer | Foreign key to the files table | |
c00 | text | Episode Title | <title></title> |
c01 | text | Plot Summary | <plot></plot> |
c02 | text | Not Used | |
c03 | text | Link to Rating Table | |
c04 | text | Writer | <credits></credits> |
c05 | text | First Aired | <premiered></premiered> |
c06 | text | Thumbnail URL | <thumb></thumb> |
c07 | text | Thumbnail URL Spoof | |
c08 | text | Not Used | |
c09 | text | Runtime | <runtime></runtime> |
c10 | text | Director | <director></director> |
c11 | text | Production Code |
|
c12 | varchar(24) | Season Number | <season></season> |
c13 | varchar(24) | Episode Number | <episode></episode> |
c14 | text | Original Title | <originaltitle></originaltitle> |
c15 | text | Season Number- Specials Sorting | <displayseason></displayseason> |
c16 | text | Episode Number- Specials Sorting | <displayepisode></displayepisode> |
c17 | varchar(24) | Bookmark | |
c18 | text | Path to episode file | |
c19 | text | Link to Path Table | |
c20 | text | Link to UniqueID Table | |
c21 | text | Not used | |
c22 | text | Not used | |
c23 | text | Not used | |
idShow | integer | Foreign key to the tvshow table | |
userrating | integer | User Rating | <userrating></userrating> |
idSeason | integer | Foreign key to the seasons table |
files
This table stores filenames and links the path.
Column Name | Data Type | Description | Movies TV Shows TV Episodes Music Videos |
---|---|---|---|
idFile | integer | Primary Key | |
idPath | integer | Foreign key to path table | |
strFilename | text | Full name of file including extension | |
playCount | integer | # of Times Played | <playcount></playcount> |
lastPlayed | text | Date & Time Last Played | <lastplayed></lastplayed> |
dateAdded | text | Date & Time Added to Library | <dateadded></dateadded> |
genre
This table stores genre information. For convenience the contents are duplicated in movie and tvshow, so a join isn't necessary.
Column Name | Data Type | Description | Movies TV Shows TV Episodes Music Videos |
---|---|---|---|
genre_id | integer | Primary Key | |
name | text | Genre label | <genre></genre> |
genre_link
This table links genres to movies. (The contents are also stored in movies.c14, though.)
Column Name | Data Type | Description |
---|---|---|
genre_id | integer | Foreign key to genre table |
media_id | integer | Foreign key to movie table, tv show table, music video table |
media_type | text | Movie, Music Video, TV Show |
movie
This table stores movie information.
Column Name | Data Type | Description | Movies |
---|---|---|---|
idMovie | integer | Primary Key | |
idFile | integer | Foreign Key to files table | |
c00 | text | Local Movie Title | <title></title> |
c01 | text | Movie Plot | <plot></plot> |
c02 | text | Movie Plot Outline | <outline></outline> |
c03 | text | Movie Tagline | <tagline></tagline> |
c04 | text | Not Used | |
c05 | text | Link to Rating Table | |
c06 | text | Writers | <credits></credits> |
c07 | text | Not Used | |
c08 | text | Image URL | <thumb aspect="poster" preview=""></thumb> |
c09 | text | Link to uniqueid Table | |
c10 | text | Title formatted for sorting | <sorttitle></sorttitle> |
c11 | text | Runtime | <runtime></runtime> ** |
c12 | text | MPAA Rating | <mpaa></mpaa> |
c13 | text | IMDB Top 250 Ranking | <top250></top250> |
c14 | text | Genre | <genre></genre> |
c15 | text | Director | <director></director> |
c16 | text | Original Movie Title | <originaltitle></originaltitle> |
c17 | text | Thumb URL Spoof | |
c18 | text | Studio | <studio></studio> |
c19 | text | Trailer URL | <trailer></trailer> |
c20 | text | Fanart URLs |
<fanart> <thumb preview=""></thumb> </fanart> |
c21 | text | Country | <country></country> |
c22 | text | Path to playable file | |
c23 | text | Link to path table for Source folder | |
idSet | integer | Foreign Key to sets table | |
userrating | integer | Rating applied by user | <userrating></userrating> |
premiered | text | Date movie premiered | <premiered></premiered> |
Notes | |
---|---|
** | Overwritten on Play |
movielinktvshow
This table links movies to TV shows.
Column Name | Data Type | Description |
---|---|---|
idMovie | integer | Foreign key to movie table |
idShow | integer | Foreign key to tvshow table |
musicvideo
Column Name | Data Type | Description | Music Videos |
---|---|---|---|
idMVideo | integer | Primary Key | |
idFile | integer | Foreign Key to files table | |
c00 | text | Title | <title></title> |
c01 | text | Thumb URL | <thumb preview=""></thumb> |
c02 | text | Thumb URL spoof | |
c03 | text | Not Used | |
c04 | text | Run time | <runtime></runtime> |
c05 | text | Director | <director></director> |
c06 | text | Studios | <studio></studio> |
c07 | text | Not Used | |
c08 | text | Plot | <plot></plot> |
c09 | text | Album | <album></album> |
c10 | text | Artist | <artist></artist> |
c11 | text | Genre | <genre></genre> |
c12 | text | Track | |
c13 | text | Path to playable file | <filenameandpath></filenameandpath> |
c14 | text | Link to path table for Source folder | <basepath></basepath> |
c15 | text | Not Used | |
c16 | text | Not Used | |
c17 | text | Not Used | |
c18 | text | Not Used | |
c19 | text | Not Used | |
c20 | text | Not Used | |
c21 | text | Not Used | |
c22 | text | Not Used | |
c23 | text | Not Used | |
userrating | integer | Rating applied by user | <userrating></userrating> |
premiered | text | Date movie premiered | <premiered></premiered> |
path
This table stores path information.
Column Name | Data Type | Description |
---|---|---|
idPath | integer | Primary Key |
strPath | text | Path URL |
strContent | text | Type of content (tvshows, movies, etc...) |
strScraper | text | addon ID |
strHash | text | Hash |
scanRecursive | integer | Recursive scan setting |
useFolderNames | bool | User folder names setting |
strSettings | text | Custom settings used by scraper |
noUpdate | bool | Exclude path from library update |
exclude | bool | |
allAudio | bool | Skip filename matching for external audio tracks 0 = Disabled 1 = Enabled |
dateAdded | text | |
idParentPath | integer |
rating
This table stores the ratings for TV Shows, Episodes and Movies
Column Name | Data Type | Description | Movies TV Shows TV Episode |
---|---|---|---|
rating_id | integer | Primary Key | |
media_id | integer | Foreign key to episode table, tv show table, movie table, | |
media_type | text | Movies, TV Show, TV Episode | <movie></movie> <tvshow></tvshow> <episodedetails></episodedetails> |
rating_type | text | default | |
rating | float | rating from scraper site |
<ratings> <rating name="default" max="10" default="true"> <value></value> <votes></votes> </rating> </ratings> |
votes | integer | votes from scraper site |
seasons
This table stores the links between tv show and seasons.
Column Name | Data Type | Description | TV Show |
---|---|---|---|
idSeason | integer | Primary Key | |
idShow | integer | Foreign key to tvshow table | |
season | integer | Season number | <season></season> |
name | text | Season Name | <namedseason number="n"></namedseason> n = season number |
userrating | integer | Season level User Rating |
sets
This table stores the id and name for movie sets. Sets are linked to movies in the movie table (idSet column).
Column Name | Data Type | Description | Movies |
---|---|---|---|
idSet | integer | Primary Key | |
strSet | text | The name of the set |
<set> <name></name> <overview></overview> </set> |
strOverview | text | The description of the set |
settings
This table stores settings for individual files.
Column Name | Data Type | Description |
---|---|---|
idFile | integer | Foreign Key to files table |
Deinterlace | bool | Deinterlace |
ViewMode | integer | ViewMode |
ZoomAmount | float | ZoomAmount |
PixelRatio | float | PixelRatio |
VerticalShift | float | |
AudioStream | integer | Selected audio stream |
SubtitleStream | integer | Selected subtitle stream |
SubtitleDelay | float | Amount of delay for subtitles |
SubtitleOn | bool | Enable subtitles |
Brightness | float | Brightness |
Contrast | float | Contrast |
Gamma | float | Gamma |
VolumeAmplification | float | VolumeAmplification |
AudioDelay | float | AudioDelay |
ResumeTime | integer | ResumeTime |
Sharpness | float | Sharpness |
NoiseReduction | float | Noise Reduction |
NonLinStretch | bool | Non Linear Stretch |
PostProcess | bool | Post Processing |
ScalingMethod | integer | Scaling |
DeinterlaceMode | integer | Deinterlace mode |
StereoMode | integer | Stereo Mode |
StereoInvert | bool | Stereo Inversion |
VideoStream | integer | VideoStream |
TonemapMethod | integer | |
TonemapParam | float | |
Orientation | integer | |
CenterMixLevel | integer |
stacktimes
This table stores playing times for files (used for playing multi-file videos).
Column Name | Data Type | Description |
---|---|---|
idFile | integer | Foreign key to files table |
times | text | Times |
streamdetails
This table contains information regarding codecs used, aspect ratios etc
Column Name | Data Type | Description | Movies ** TV Episode ** |
Music Videos ** | Version Added |
---|---|---|---|---|---|
idFile | integer | Foreign Key to files table | |||
iStreamType | integer | 0 = video, 1 = audio, 2 = subtitles | |||
strVideoCodec | text | Video codex (xvid etc) |
<fileinfo> <streamdetails> <video> <codec></codec> <aspect></aspect> <width></width> <height></height> <durationinseconds>5311</durationinseconds> <stereomode></stereomode> </video> </streamdetails> </fileinfo> |
||
fVideoAspect | float | Aspect ratio | |||
iVideoWidth | integer | Width of the video | |||
iVideoHeight | integer | Height of the video | |||
iVideoDuration | integer | Actual runtime in sec | |||
strStereoMode | text | Stereo Mode | |||
strAudioCodec | text | Audio codec (aac, mp3 etc) |
<fileinfo> <streamdetails> <audio> <codec></codec> <channels></channels> <language></language> </audio> </streamdetails> </fileinfo> |
<fileinfo> <streamdetails> <audio> <codec></codec> <channels></channels> <language></language> </audio> </streamdetails> </fileinfo> | |
iAudioChannels | integer | Number of audio channels (2 for stereo, 6 for 5.1 etc) | |||
strAudioLanguage | text | Language of the audio track | |||
strSubtitleLanguage | text | Language of the subtitles |
<fileinfo> <streamdetails> <video> <subtitle> <language>en</language> </subtitle> </video> </streamdetails> </fileinfo> |
||
strVideoLanguage | text | Language of the Video | |||
strHdrType | text | hdr type of the video | <hdrtype></hdrtype> | v20 [4] |
Notes | |
---|---|
** | Settings Will be overwritten on first play |
studio
This table stores studio information.
Column Name | Data Type | Description | Movies TV Shows TV Episodes Music Videos |
---|---|---|---|
studio_id | integer | Primary Key | |
name | text | Studio Label | <studio></studio> |
studio link
This table links studios to movies, music videos and tv shows
Column Name | Data Type | Description |
---|---|---|
studio_id | integer | Foreign key to studio table |
media_id | integer | Foreign key to movie table, tv show table, music video table |
media_type | text | Movie, Music Video, TV Show |
tag
This stores tags.
Column Name | Data Type | Description | Movies TV Shows Music Videos |
---|---|---|---|
tag_id | integer | Primary Key | |
name | integer | Tag | <tag></tag> |
tag_link
This table links tags to various media.
Column Name | Data Type | Description |
---|---|---|
tag_id | integer | Foreign key to tag table |
media_id | integer | Foreign key to a media table |
media_type | text | Media type for link |
tvshow
This table stores information about a television series. Information concerning the shows episodes is stored in episode. To link a TV show to its episodes, use tvshowlinkepisode.
Column Name | Data Type | Description | TV Show |
---|---|---|---|
idShow | integer | Primary Key | |
c00 | text | Show Title | <showtitle></showtitle> |
c01 | text | Show Plot Summary | <plot>plot> |
c02 | text | Status | <status></status> |
c03 | text | Unknown | |
c04 | text | Link to Rating Table | |
c05 | text | First Aired | <premiered></premiered> |
c06 | text | Thumbnail URL | <thumb aspect="" type="" season=""></thumb> |
c07 | text | [unknown - Spoof Thumbnail URL?] | |
c08 | text | Genre | <genre></genre> |
c09 | text | Original Title | <originaltitle></originaltitle> |
c10 | text | Episode Guide URL |
<episodeguide> <url cache=""></url> </episodeguide> |
c11 | text | Fan Art URL |
<fanart url=""> <thumb dim="" colors="" preview=""></thumb> </fanart> |
c12 | text | Unique ID issued by Kodi based on Scraper ID's | |
c13 | text | Content Rating | <mpaa></mpaa> |
c14 | text | Studio | <studio></studio> |
c15 | text | Title formatted for sorting | <sorttitle></sorttitle> |
c16 | text | Trailer | <trailer></trailer> |
c17 | text | Not Used | |
c18 | text | Not Used | |
c19 | text | Not Used | |
c20 | text | [unknown] | |
c21 | text | [unknown] | |
c22 | text | [unknown] | |
c23 | text | [unknown] | |
userrating | integer | Rating applied by user | <userrating></userrating> |
duration | integer | Length of Episodes | <runtime></runtime> |
tvshowlinkpath
This table links a TV show to its path.
Column Name | Data Type | Description |
---|---|---|
idShow | integer | Foreign key to tvshow table |
idPath | integer | Foreign key to path table |
uniqueid
This table holds the UniqueID's for Movies, TV shows and Episodes. Normally the UniqueID's are the ID's used at the scraper sites. For user created nfo files for say, home movies, the ID's are user nominated. Music Videos do not require a UniqueID.
Column Name | Data Type | Description | Movies TV Shows TV Episodes |
---|---|---|---|
uniqueid | integer | Primary Key | |
media_id | integer | Foreign key to a media table | |
media_type | text | Media type for link | <movie></movie> <tvshow></tvshow> <episodedetails></episodedetails> |
value | text | ID at scraper site | <id></id> |
type | text | Scraper site |
version
This table stores database information.
Column Name | Data Type | Description |
---|---|---|
idVersion | integer | Version of database |
idCompressCount | integer | Number of times database has been compressed |
videoversion
This table stores the relations between media "parents" (movies, episodes, ...) and their video assets (versions, extras) for the Video Versions feature. [5]
Column Name | Data Type | Description |
---|---|---|
idFile | integer | The video asset. Foreign Key to files table |
idMedia | integer | id of the media |
media_type | text | The type of media this asset is linked with (v21: the only supported value is "movie") |
itemType | integer | Type of video asset. 0 = VideoVersion; 1 = Extras |
idType | integer | Name of the video asset. Foreign key to the videoversiontype table |
videoversiontype
This table stores the version types/names and extras names for the Video Versions feature.[6]
Column Name | Data Type | Description |
---|---|---|
id | integer | Primary Key |
name | text | Name / type of the version or extra |
owner | integer | 0 = prepopulated by the system; 1 = added by library scan; 2 = added by user |
itemType | integer | type of asset the record applies to. 0 = Version; 1 = Extras |
writer_link
This table links writers stored in the actors table to movies and episodes.
Column Name | Data Type | Description |
---|---|---|
actor_id | integer | Foreign key to actors table |
media_id | integer | Foreign key to a media table |
media_type | text | Media type for link |
References
- ↑ https://github.com/xbmc/xbmc/pull/23658
- ↑ https://github.com/xbmc/xbmc/pull/23658
- ↑ https://github.com/xbmc/xbmc/pull/23658
- ↑ https://github.com/xbmc/xbmc/pull/19983
- ↑ https://github.com/xbmc/xbmc/pulls?page=4&q=is%3Apr+label%3A%22Feature%3A+Video+Versions%2FExtras%22+is%3Aclosed
- ↑ https://github.com/xbmc/xbmc/pulls?page=4&q=is%3Apr+label%3A%22Feature%3A+Video+Versions%2FExtras%22+is%3Aclosed
Return to top |
---|