Databases/MyVideos: Difference between revisions
(→tvshow) |
(add <hdrtype></hdrtype> tag) |
||
(9 intermediate revisions by the same user 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: | ||
== episodeview == | |||
== episodeview == | |||
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 30: | Line 28: | ||
|idEpisode || integer || Primary Key | |idEpisode || integer || Primary Key | ||
|- | |- | ||
|idFile || integer || Foreign key to the [[Databases#files|files table]] | |idFile || integer || Foreign key to the [[Databases/MyVideos#files|files table]] | ||
|- | |- | ||
|c00 || text || Episode Title | |c00 || text || Episode Title | ||
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 || | |c12 || varchar(24) || Season Number | ||
|- | |- | ||
|c13 || | |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 66: | Line 64: | ||
|c16 || text || Episode formatted for sorting | |c16 || text || Episode formatted for sorting | ||
|- | |- | ||
|c17 || | |c17 || varchar(24) || Bookmark | ||
|- | |- | ||
|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 80: | Line 78: | ||
|c23 || text || Not used | |c23 || text || Not used | ||
|- | |- | ||
|idShow || | |idShow || integer || Foreign key to the [[Databases/MyVideos#tvshow|tvshow table]] | ||
|- | |- | ||
|userrating || | |userrating || integer || User Rating | ||
|- | |- | ||
|idSeason || | |idSeason || integer || Foreign key to the [[Databases/MyVideos#seasons|seasons table]] | ||
|- | |- | ||
|strFilename || text || Full name of file including extension | |strFilename || text || Full name of file including extension | ||
Line 109: | Line 107: | ||
|- | |- | ||
|totalTimeInSeconds || double || Length of video | |totalTimeInSeconds || double || Length of video | ||
|- | |||
|playerState || text || | |||
|- | |- | ||
|rating || float || Rating | |rating || float || Rating | ||
Line 123: | Line 123: | ||
== movieview == | == movieview == | ||
A view that joins movie to file and path. | A view that joins movie to file and path. | ||
Line 131: | Line 131: | ||
|idMovie || integer || Primary Key | |idMovie || integer || Primary Key | ||
|- | |- | ||
|idFile || integer || Foreign Key to [[Databases#files|files table]] | |idFile || integer || Foreign Key to [[Databases/MyVideos#files|files table]] | ||
|- | |- | ||
|c00 || text || Local Movie Title | |c00 || text || Local Movie Title | ||
Line 141: | Line 141: | ||
|c03 || text || Movie Tagline | |c03 || text || Movie Tagline | ||
|- | |- | ||
|c04 || text || | |c04 || text || Not Used | ||
|- | |- | ||
|c05 || text || Link to [[Databases#rating|Rating Table]] | |c05 || text || Link to [[Databases/MyVideos#rating|Rating Table]] | ||
|- | |- | ||
|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 167: | 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 175: | 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#sets|sets table]] | |idSet || integer || Foreign Key to [[Databases/MyVideos#sets|sets table]] | ||
|- | |- | ||
|userrating || integer || Rating applied by user | |userrating || integer || Rating applied by user | ||
Line 204: | Line 204: | ||
|- | |- | ||
|totalTimeInSeconds || double || Length of video | |totalTimeInSeconds || double || Length of video | ||
|- | |||
|playerState || text || | |||
|- | |- | ||
|rating || float || Rating | |rating || float || Rating | ||
Line 218: | Line 220: | ||
== musicvideoview == | == musicvideoview == | ||
A view that joins musicvideo to file and path. | A view that joins musicvideo to file and path. | ||
{|class="prettytable" | {|class="prettytable" | ||
Line 225: | Line 227: | ||
|idMVideo || integer || Primary Key | |idMVideo || integer || Primary Key | ||
|- | |- | ||
|idFile || integer || Foreign Key to [[Databases#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 292: | Line 294: | ||
|- | |- | ||
|totalTimeInSeconds || double || Time in seconds of the video | |totalTimeInSeconds || double || Time in seconds of the video | ||
|- | |||
|playerState || text || | |||
|} | |} | ||
== tvshowview == | == season_view == | ||
A view that joins seasons to the tvshow. | |||
{|class="prettytable" | |||
! Column Name || Data Type || Description | |||
|- | |||
|idSeason || integer || Primary Key | |||
|- | |||
|idShow || integer || Foreign key to the [[Databases/MyVideos#files|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 || || | |||
|- | |||
|aired || || | |||
|} | |||
== tvshowview == | |||
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 335: | Line 378: | ||
|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 382: | Line 425: | ||
== | == 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 399: | Line 442: | ||
|dateAdded || text || Date Added | |dateAdded || text || Date Added | ||
|} | |} | ||
== tvshowlinkpath_minview == | |||
Joins TV Show to Path | |||
{|class="prettytable" | |||
! Column Name || Data Type || Description | |||
|- | |||
|idShow || integer || Primary Key | |||
|- | |||
|idPath || || Foreign key to [[Databases/MyVideos#path|path table]] | |||
|} | |||
{{top}} | {{top}} | ||
= Tables = | = Tables = | ||
The information in the Video Library is organized into the following tables. Several large tables (such as [[Databases#episode|episode]], [[Databases#movie|movie]], [[Databases#settings|settings]], and [[Databases#tvshow|tvshow]]) contain the bulk of the information, while most of the others are used to link a long string to a common ID key. | The information in the Video Library is organized into the following tables. Several large tables (such as [[Databases/MyVideos#episode|episode]], [[Databases/MyVideos#movie|movie]], [[Databases/MyVideos#settings|settings]], and [[Databases/MyVideos#tvshow|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 == | |||
== actor == | |||
This table stores actor, artist, director, and writer information. | This table stores actor, artist, director, and writer information. | ||
Line 432: | Line 488: | ||
== 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 440: | Line 496: | ||
! rowspan="1" style="text-align: centre;" | Music Videos | ! rowspan="1" style="text-align: centre;" | Music Videos | ||
|- | |- | ||
|actor_id || integer || Foreign key to [[Databases# | |actor_id || integer || Foreign key to [[Databases/MyVideos#actor|actors table]] || || | ||
|- | |- | ||
|media_id || integer || Foreign key to [[Databases#episode|episode table]], [[Databases#tvshow|tv show table]], [[Databases#movie|movie table]],[[Databases#musicvideo|music video table]] || || | |media_id || integer || Foreign key to [[Databases/MyVideos#episode|episode table]], [[Databases/MyVideos#tvshow|tv show table]], [[Databases/MyVideos#movie|movie table]],[[Databases/MyVideos#musicvideo|music video table]] || || | ||
|- | |- | ||
|media_type || text || Movie, TV Show, Episode, Music Video || <movie></movie><br /><tvshow></tvshow><br /><episodedetails></episodedetails> || <musicvideo></musicvideo> | |media_type || text || Movie, TV Show, Episode, Music Video || <movie></movie><br /><tvshow></tvshow><br /><episodedetails></episodedetails> || <musicvideo></musicvideo> | ||
Line 460: | Line 516: | ||
== art == | == art == | ||
This table stores URLs for video art metadata. | This table stores URLs for video art metadata. | ||
Line 514: | Line 570: | ||
== 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 523: | Line 579: | ||
|idBookmark || integer || Primary Key || | |idBookmark || integer || Primary Key || | ||
|- | |- | ||
|idFile || integer || Foreign key to [[Databases#files|files table]] || | |idFile || integer || Foreign key to [[Databases/MyVideos#files|files table]] || | ||
|- | |- | ||
|timeInSeconds || double || Time in seconds of bookmark location | |timeInSeconds || double || Time in seconds of bookmark location | ||
Line 532: | Line 588: | ||
</resume> | </resume> | ||
|- | |- | ||
|totalTimeInSeconds || | |totalTimeInSeconds || double || Time in seconds of the video | ||
|- | |- | ||
|thumbNailImage || text || Thumbnail for bookmark || | |thumbNailImage || text || Thumbnail for bookmark || | ||
Line 545: | Line 601: | ||
== country == | == country == | ||
This table lists countries. | This table lists countries. | ||
Line 558: | Line 614: | ||
== country link == | == country link == | ||
This table links countries to movies. | This table links countries to movies. | ||
Line 564: | Line 620: | ||
! Column Name || Data Type || Description | ! Column Name || Data Type || Description | ||
|- | |- | ||
|country_id || integer || Foreign key to [[Databases#country|country table]] | |country_id || integer || Foreign key to [[Databases/MyVideos#country|country table]] | ||
|- | |- | ||
|media_id || integer ||Foreign key to [[Databases#movie|movie table]] | |media_id || integer ||Foreign key to [[Databases/MyVideos#movie|movie table]] | ||
|- | |- | ||
|media_type || | |media_type || text || Media Class | ||
|} | |} | ||
== 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 579: | Line 635: | ||
! Column Name || Data Type || Description | ! Column Name || Data Type || Description | ||
|- | |- | ||
|actor_id || integer || Foreign key to [[Databases#actors|actors table]] | |actor_id || integer || Foreign key to [[Databases/MyVideos#actors|actors table]] | ||
|- | |- | ||
|media_id || integer || Foreign key to [[Databases#episode|episode table]], [[Databases#movie|movie table]],[[Databases#musicvideo|music video table]] | |media_id || integer || Foreign key to [[Databases/MyVideos#episode|episode table]], [[Databases/MyVideos#movie|movie table]],[[Databases/MyVideos#musicvideo|music video table]] | ||
|- | |- | ||
|media_type || text || Movie, Music Video, Episode | |media_type || text || Movie, Music Video, Episode | ||
Line 588: | Line 644: | ||
== episode == | == episode == | ||
This table stores television episode information. Information concerning the series is stored in [[Databases#tvshow|tvshow]]. To link an episode to its parent series, use [[Databases#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]]. | ||
{|class="prettytable" | {|class="prettytable" | ||
Line 597: | Line 653: | ||
|idEpisode || integer || Primary Key || | |idEpisode || integer || Primary Key || | ||
|- | |- | ||
|idFile || integer || Foreign key to the [[Databases#files|files table]] || | |idFile || integer || Foreign key to the [[Databases/MyVideos#files|files table]] || | ||
|- | |- | ||
|c00 || text || Episode Title || <title></title> | |c00 || text || Episode Title || <title></title> | ||
Line 603: | Line 659: | ||
|c01 || text || Plot Summary || <plot></plot> | |c01 || text || Plot Summary || <plot></plot> | ||
|- | |- | ||
|c02 || text || | |c02 || text || Not Used || | ||
|- | |- | ||
|c03 || text || Link to [[Databases#rating|Rating Table]] || | |c03 || text || Link to [[Databases/MyVideos#rating|Rating Table]] || | ||
|- | |- | ||
|c04 || text || Writer || <credits></credits> | |c04 || text || Writer || <credits></credits> | ||
Line 613: | Line 669: | ||
|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 || | |c12 || varchar(24) || Season Number || <season></season> | ||
|- | |- | ||
|c13 || | |c13 || varchar(24) || Episode Number || <episode></episode> | ||
|- | |- | ||
|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 || | |c17 || varchar(24) || Bookmark || | ||
|- | |- | ||
|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 647: | Line 703: | ||
|c23 || text || Not used || | |c23 || text || Not used || | ||
|- | |- | ||
|idShow || | |idShow || integer || Foreign key to the [[Databases/MyVideos#tvshow|tvshow table]] || | ||
|- | |- | ||
|userrating || | |userrating || integer || User Rating || <userrating></userrating> | ||
|- | |- | ||
|idSeason || | |idSeason || integer || Foreign key to the [[Databases/MyVideos#seasons|seasons table]] || | ||
|} | |} | ||
== files == | == files == | ||
This table stores filenames and links the path. | This table stores filenames and links the path. | ||
Line 664: | Line 720: | ||
|idFile || integer || Primary Key || | |idFile || integer || Primary Key || | ||
|- | |- | ||
|idPath || integer || Foreign key to [[Databases#path|path table]] || | |idPath || integer || Foreign key to [[Databases/MyVideos#path|path table]] || | ||
|- | |- | ||
|strFilename || text || Full name of file including extension || | |strFilename || text || Full name of file including extension || | ||
Line 677: | Line 733: | ||
== genre == | == genre == | ||
This table stores genre information. For convenience the contents are duplicated in [[Databases#movie|movie]] and [[Databases#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. | ||
{|class="prettytable" | {|class="prettytable" | ||
Line 690: | Line 746: | ||
== 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 696: | Line 752: | ||
! Column Name || Data Type || Description | ! Column Name || Data Type || Description | ||
|- | |- | ||
|genre_id || integer || Foreign key to [[Databases#genre|genre table]] | |genre_id || integer || Foreign key to [[Databases/MyVideos#genre|genre table]] | ||
|- | |- | ||
|media_id || integer || Foreign key to [[Databases#movie|movie table]], [[Databases#tvshow|tv show table]], [[Databases#musicvideo|music video table]] | |media_id || integer || Foreign key to [[Databases/MyVideos#movie|movie table]], [[Databases/MyVideos#tvshow|tv show table]], [[Databases/MyVideos#musicvideo|music video table]] | ||
|- | |- | ||
|media_type || text || Movie, Music Video, TV Show | |media_type || text || Movie, Music Video, TV Show | ||
Line 705: | Line 761: | ||
== movie == | == movie == | ||
This table stores movie information. | This table stores movie information. | ||
Line 714: | Line 770: | ||
|idMovie || integer || Primary Key || | |idMovie || integer || Primary Key || | ||
|- | |- | ||
|idFile || integer || Foreign Key to [[Databases#files|files table]] || | |idFile || integer || Foreign Key to [[Databases/MyVideos#files|files table]] || | ||
|- | |- | ||
|c00 || text || Local Movie Title || <title></title> | |c00 || text || Local Movie Title || <title></title> | ||
Line 724: | Line 780: | ||
|c03 || text || Movie Tagline || <tagline></tagline> | |c03 || text || Movie Tagline || <tagline></tagline> | ||
|- | |- | ||
|c04 || text || | |c04 || text || Not Used || | ||
|- | |- | ||
|c05 || text || Link to [[Databases#rating|Rating Table]] || | |c05 || text || Link to [[Databases/MyVideos#rating|Rating Table]] || | ||
|- | |- | ||
|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 750: | Line 806: | ||
|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 762: | Line 818: | ||
</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#sets|sets table]] || | |idSet || integer || Foreign Key to [[Databases/MyVideos#sets|sets table]] || | ||
|- | |- | ||
|userrating || integer || Rating applied by user || <userrating></userrating> | |userrating || integer || Rating applied by user || <userrating></userrating> | ||
Line 782: | Line 838: | ||
== movielinktvshow == | == movielinktvshow == | ||
This table links movies to TV shows. | This table links movies to TV shows. | ||
Line 788: | Line 844: | ||
! Column Name || Data Type || Description | ! Column Name || Data Type || Description | ||
|- | |- | ||
|idMovie || integer || Foreign key to [[Databases#movie|movie table]] | |idMovie || integer || Foreign key to [[Databases/MyVideos#movie|movie table]] | ||
|- | |- | ||
|idShow || integer || Foreign key to [[Databases#tvshow|tvshow table]] | |idShow || integer || Foreign key to [[Databases/MyVideos#tvshow|tvshow table]] | ||
|} | |} | ||
== musicvideo == | == musicvideo == | ||
{|class="prettytable" | {|class="prettytable" | ||
Line 802: | Line 858: | ||
|idMVideo || integer || Primary Key || | |idMVideo || integer || Primary Key || | ||
|- | |- | ||
|idFile || integer || Foreign Key to [[Databases#files|files table]] || | |idFile || integer || Foreign Key to [[Databases/MyVideos#files|files table]] || | ||
|- | |- | ||
|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 818: | Line 874: | ||
|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 828: | Line 884: | ||
|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 871: | Line 927: | ||
|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 884: | Line 940: | ||
|- | |- | ||
|exclude || bool || | |exclude || bool || | ||
|- | |||
|allAudio || bool || Skip filename matching for external audio tracks<br>0 = Disabled<br>1 = Enabled | |||
|- | |- | ||
|dateAdded || text || | |dateAdded || text || | ||
Line 892: | Line 950: | ||
== 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 901: | Line 959: | ||
|rating_id || integer || Primary Key || | |rating_id || integer || Primary Key || | ||
|- | |- | ||
|media_id || integer || Foreign key to [[Databases#episode|episode table]], [[Databases#tvshow|tv show table]], [[Databases#movie|movie table]], || | |media_id || integer || Foreign key to [[Databases/MyVideos#episode|episode table]], [[Databases/MyVideos#tvshow|tv show table]], [[Databases/MyVideos#movie|movie table]], || | ||
|- | |- | ||
|media_type || text || Movies, TV Show, TV Episode || <movie></movie><br /><tvshow></tvshow><br /><episodedetails></episodedetails> | |media_type || text || Movies, TV Show, TV Episode || <movie></movie><br /><tvshow></tvshow><br /><episodedetails></episodedetails> | ||
Line 921: | Line 979: | ||
== seasons == | == seasons == | ||
This table stores the links between tv show and seasons. | This table stores the links between tv show and seasons. | ||
Line 929: | Line 987: | ||
|idSeason || integer || Primary Key || | |idSeason || integer || Primary Key || | ||
|- | |- | ||
|idShow|| integer || Foreign key to [[Databases#tvshow|tvshow table]] || | |idShow|| integer || Foreign key to [[Databases/MyVideos#tvshow|tvshow table]] || | ||
|- | |- | ||
|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 940: | Line 998: | ||
== 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 961: | Line 1,019: | ||
== settings == | == settings == | ||
This table stores settings for individual files. | This table stores settings for individual files. | ||
Line 967: | Line 1,025: | ||
! Column Name || Data Type || Description | ! Column Name || Data Type || Description | ||
|- | |- | ||
|idFile || integer || Foreign Key to [[Databases#files|files table]] | |idFile || integer || Foreign Key to [[Databases/MyVideos#files|files table]] | ||
|- | |- | ||
|Deinterlace || bool || Deinterlace | |Deinterlace || bool || Deinterlace | ||
Line 987: | Line 1,045: | ||
|SubtitleOn || bool || Enable subtitles | |SubtitleOn || bool || Enable subtitles | ||
|- | |- | ||
|Brightness || | |Brightness || float || Brightness | ||
|- | |- | ||
|Contrast || | |Contrast || float || Contrast | ||
|- | |- | ||
|Gamma || | |Gamma || float || Gamma | ||
|- | |- | ||
|VolumeAmplification || float || VolumeAmplification | |VolumeAmplification || float || VolumeAmplification | ||
|- | |- | ||
|AudioDelay || float || AudioDelay | |AudioDelay || float || AudioDelay | ||
|- | |- | ||
|ResumeTime || integer || ResumeTime | |ResumeTime || integer || ResumeTime | ||
|- | |- | ||
|Sharpness || float || Sharpness | |Sharpness || float || Sharpness | ||
Line 1,028: | Line 1,074: | ||
|- | |- | ||
|VideoStream || integer || VideoStream | |VideoStream || integer || VideoStream | ||
|- | |||
|TonemapMethod || integer || | |||
|- | |||
|TonemapParam || float || | |||
|- | |||
|Orientation || integer || | |||
|- | |||
|CenterMixLevel || integer || | |||
|} | |} | ||
== 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,038: | Line 1,092: | ||
! Column Name || Data Type || Description | ! Column Name || Data Type || Description | ||
|- | |- | ||
|idFile || integer || Foreign key to [[Databases#files|files table]] | |idFile || integer || Foreign key to [[Databases/MyVideos#files|files table]] | ||
|- | |- | ||
|times|| text || Times | |times|| text || Times | ||
Line 1,045: | Line 1,099: | ||
== streamdetails == | == streamdetails == | ||
This table contains information regarding codecs used, aspect ratios etc | This table contains information regarding codecs used, aspect ratios etc | ||
Line 1,052: | Line 1,106: | ||
! 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#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,073: | Line 1,128: | ||
| rowspan="6" style="text-align: left;" | | | rowspan="6" style="text-align: left;" | | ||
|- | |- | ||
|fVideoAspect|| | |fVideoAspect|| float || Aspect ratio | ||
|- | |- | ||
|iVideoWidth|| integer || Width of the video | |iVideoWidth|| integer || Width of the video | ||
Line 1,079: | Line 1,134: | ||
|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> | ||
<streamdetails> | <streamdetails> | ||
<audio> | <audio> | ||
<codec></codec> | <codec></codec> | ||
Line 1,093: | Line 1,147: | ||
<language></language> | <language></language> | ||
</audio> | </audio> | ||
</streamdetails> | </streamdetails> | ||
</fileinfo> | </fileinfo> | ||
| rowspan="3" style="text-align: left;" | | | rowspan="3" style="text-align: left;" | | ||
<fileinfo> | <fileinfo> | ||
<streamdetails> | <streamdetails> | ||
<audio> | <audio> | ||
<codec></codec> | <codec></codec> | ||
Line 1,105: | Line 1,157: | ||
<language></language> | <language></language> | ||
</audio> | </audio> | ||
</streamdetails> | </streamdetails> | ||
</fileinfo> | </fileinfo> | ||
Line 1,126: | Line 1,177: | ||
| 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,137: | Line 1,190: | ||
== studio == | == studio == | ||
This table stores studio information. | This table stores studio information. | ||
Line 1,150: | Line 1,203: | ||
== 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,156: | Line 1,209: | ||
! Column Name || Data Type || Description | ! Column Name || Data Type || Description | ||
|- | |- | ||
|studio_id || integer || Foreign key to [[Databases#studio|studio table]] | |studio_id || integer || Foreign key to [[Databases/MyVideos#studio|studio table]] | ||
|- | |- | ||
|media_id || integer || Foreign key to [[Databases#movie|movie table]], [[Databases#tvshow|tv show table]], [[Databases#musicvideo|music video table]] | |media_id || integer || Foreign key to [[Databases/MyVideos#movie|movie table]], [[Databases/MyVideos#tvshow|tv show table]], [[Databases/MyVideos#musicvideo|music video table]] | ||
|- | |- | ||
|media_type || text || Movie, Music Video, TV Show | |media_type || text || Movie, Music Video, TV Show | ||
Line 1,165: | Line 1,218: | ||
== tag == | == tag == | ||
This stores tags. | This stores tags. | ||
Line 1,178: | Line 1,231: | ||
== | == tag_link == | ||
This table links tags to various media. | This table links tags to various media. | ||
Line 1,184: | Line 1,237: | ||
! Column Name || Data Type || Description | ! Column Name || Data Type || Description | ||
|- | |- | ||
|tag_id || integer || Foreign key to [[Databases#tag|tag table]] | |tag_id || integer || Foreign key to [[Databases/MyVideos#tag|tag table]] | ||
|- | |- | ||
|media_id || integer || Foreign key to a media table | |media_id || integer || Foreign key to a media table | ||
Line 1,193: | Line 1,246: | ||
== tvshow == | == tvshow == | ||
This table stores information about a television series. Information concerning the shows episodes is stored in [[Databases#episode|episode]]. To link a TV show to its episodes, use [[Databases#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]]. | ||
{|class="prettytable" | {|class="prettytable" | ||
Line 1,209: | Line 1,262: | ||
|c03 || text || Unknown || | |c03 || text || Unknown || | ||
|- | |- | ||
|c04 || text || Link to [[Databases#rating|Rating Table]] || | |c04 || text || Link to [[Databases/MyVideos#rating|Rating Table]] || | ||
|- | |- | ||
|c05 || text || First Aired || <premiered></premiered> | |c05 || text || First Aired || <premiered></premiered> | ||
Line 1,239: | Line 1,292: | ||
|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,257: | Line 1,310: | ||
|userrating || integer || Rating applied by user || <userrating></userrating> | |userrating || integer || Rating applied by user || <userrating></userrating> | ||
|- | |- | ||
|duration || | |duration || integer || Length of Episodes || <runtime></runtime> | ||
|} | |} | ||
== tvshowlinkpath == | == tvshowlinkpath == | ||
This table links a TV show to its path. | This table links a TV show to its path. | ||
Line 1,266: | Line 1,319: | ||
! Column Name || Data Type || Description | ! Column Name || Data Type || Description | ||
|- | |- | ||
|idShow || integer || Foreign key to [[Databases#tvshow|tvshow table]] | |idShow || integer || Foreign key to [[Databases/MyVideos#tvshow|tvshow table]] | ||
|- | |- | ||
|idPath || integer || Foreign key to [[Databases#path|path table]] | |idPath || integer || Foreign key to [[Databases/MyVideos#path|path table]] | ||
|} | |} | ||
== 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,292: | Line 1,345: | ||
== version == | == version == | ||
This table stores database information. | This table stores database information. | ||
{|class="prettytable" | {|class="prettytable" | ||
Line 1,304: | Line 1,357: | ||
== writer_link == | == 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,310: | Line 1,363: | ||
! Column Name || Data Type || Description | ! Column Name || Data Type || Description | ||
|- | |- | ||
|actor_id || integer || Foreign key to [[Databases#actors|actors table]] | |actor_id || integer || Foreign key to [[Databases/MyVideos#actors|actors table]] | ||
|- | |- | ||
|media_id || integer || Foreign key to a media table | |media_id || integer || Foreign key to a media table | ||
Line 1,316: | Line 1,369: | ||
|media_type || text || Media type for link | |media_type || text || Media type for link | ||
|} | |} | ||
{{Top}} | {{Top}} | ||
{{updated|20}} | |||
[[Category:Karellen]] | [[Category:Karellen]] | ||
[[Category:Development]] | [[Category:Development]] | ||
[[Category:Video library]] | [[Category:Video library]] | ||
[[Category: | [[Category:Skin_development]] |
Latest revision as of 09:46, 28 December 2023
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.
episodeview
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 | |
uniqueid_type | text |
movieview
A view that joins movie to file and path.
Column Name | Data Type | Description |
---|---|---|
idMovie | integer | Primary Key |
idFile | integer | Foreign Key to files table |
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 | |
uniqueid_type | text |
musicvideoview
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 | ||
aired |
tvshowview
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 | |
uniqueid_type | text |
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 |
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 or actor | ||||
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 [1] |
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 |
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 |
Return to top |
---|