Difference between revisions of "Databases/MyVideos"

From Official Kodi Wiki
Jump to: navigation, search
(Create Page)
 
 
(4 intermediate revisions by the same user not shown)
Line 10: Line 10:
 
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 v17 - MyVideos107.db  
+
;Kodi v18 - MyVideos116.db  
 +
 
 +
 
 +
'''{{red|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.}}'''
  
  
Line 27: Line 30:
 
|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 33: Line 36:
 
|c01 || text ||  Plot Summary
 
|c01 || text ||  Plot Summary
 
|-
 
|-
|c02 || text ||  [unknown - listed as Votes]
+
|c02 || text ||  Not Used
 
|-
 
|-
|c03 || text ||  Rating
+
|c03 || text ||  Link to [[Databases/MyVideos#rating|Rating Table]]
 
|-
 
|-
 
|c04 || text ||  Writer
 
|c04 || text ||  Writer
Line 43: Line 46:
 
|c06 || text ||  Thumbnail URL
 
|c06 || text ||  Thumbnail URL
 
|-
 
|-
|c07 || text ||  [unknown - listed as Thumbnail URL Spoof, unused?]
+
|c07 || text ||  Thumbnail URL Spoof
 
|-
 
|-
|c08 || text ||  Has the episode been watched? (unused?)
+
|c08 || text ||  Not Used
 
|-
 
|-
|c09 || text ||  Episode length in minutes
+
|c09 || text ||  Runtime
 
|-
 
|-
 
|c10 || text ||  Director
 
|c10 || text ||  Director
 
|-
 
|-
|c11 || text ||  [unknown - listed as Indentifier]
+
|c11 || text ||  Production Code
 
|-
 
|-
|c12 || text ||  Season Number
+
|c12 || varchar(24) ||  Season Number
 
|-
 
|-
|c13 || text ||  Episode Number
+
|c13 || tvarchar(24)ext ||  Episode Number
 
|-
 
|-
|c14 || text ||  [unknown - listed as Original Title, unused?]
+
|c14 || text ||  Original Title
 
|-
 
|-
 
|c15 || text ||  Season formatted for sorting
 
|c15 || text ||  Season formatted for sorting
Line 63: Line 66:
 
|c16 || text ||  Episode formatted for sorting
 
|c16 || text ||  Episode formatted for sorting
 
|-
 
|-
|c17 || text ||  Bookmark
+
|c17 || varchar(24) ||  Bookmark
 
|-
 
|-
 
|c18 || text ||  Path to episode file
 
|c18 || text ||  Path to episode file
 
|-
 
|-
|c19 || text ||  Used- unknown
+
|c19 || text ||  Link to [[Databases/MyVideos#path|Path Table]]
 
|-
 
|-
|c20 || text ||  Used- unknown
+
|c20 || text ||  Link to [[Databases/MyVideos#uniqueid|UniqueID Table]]
 
|-
 
|-
 
|c21 || text ||  Not used
 
|c21 || text ||  Not used
Line 77: Line 80:
 
|c23 || text ||  Not used
 
|c23 || text ||  Not used
 
|-
 
|-
|idShow || text ||  Foreign key to the [[Databases#tvshow|tvshow table]]
+
|idShow || integer ||  Foreign key to the [[Databases/MyVideos#tvshow|tvshow table]]
 
|-
 
|-
|userrating || text ||  User Rating
+
|userrating || integer ||  User Rating
 
|-
 
|-
|idSeason || text ||  Foreign key to the [[Databases#seasons|seasons table]]
+
|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 106: Line 109:
 
|-
 
|-
 
|totalTimeInSeconds || double || Length of video
 
|totalTimeInSeconds || double || Length of video
 +
|-
 +
|playerState || text ||
 
|-
 
|-
 
|rating || float || Rating
 
|rating || float || Rating
Line 128: Line 133:
 
|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 138: Line 143:
 
|c03 || text ||  Movie Tagline
 
|c03 || text ||  Movie Tagline
 
|-
 
|-
|c04 || text ||  Rating Votes link to [[Databases#rating|Rating Table]]
+
|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 ||  Year Released
+
|c07 || text ||  Not Used
 
|-
 
|-
 
|c08 || text ||  Image URL
 
|c08 || text ||  Image URL
 
|-
 
|-
|c09 || text ||  IMDB ID link to [[Databases#uniqueid|uniqueid Table]]  
+
|c09 || text ||  Link to [[Databases/MyVideos#uniqueid|uniqueid Table]]
 
|-
 
|-
 
|c10 || text ||  Title formatted for sorting
 
|c10 || text ||  Title formatted for sorting
 
|-
 
|-
|c11 || text ||  Runtime (UPnP devices see this as seconds)
+
|c11 || text ||  Runtime  
 
|-
 
|-
 
|c12 || text ||  MPAA Rating
 
|c12 || text ||  MPAA Rating
Line 164: Line 169:
 
|c16 || text ||  Original Movie Title
 
|c16 || text ||  Original Movie Title
 
|-
 
|-
|c17 || text ||  [unknown - listed as Thumbnail URL Spoof]
+
|c17 || text ||  Thumb URL Spoof]
 
|-
 
|-
 
|c18 || text ||  Studio
 
|c18 || text ||  Studio
Line 172: Line 177:
 
|c20 || text ||  Fanart URLs
 
|c20 || text ||  Fanart URLs
 
|-
 
|-
|c21 || text ||  Country (Added in r29886[http://trac.kodi.tv/changeset/29886/trunk])
+
|c21 || text ||  Country
 
|-
 
|-
 
|c22 || text ||  Path to playable file
 
|c22 || text ||  Path to playable file
 
|-
 
|-
|c23 || text ||  idPath
+
|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 201: Line 206:
 
|-
 
|-
 
|totalTimeInSeconds || double || Length of video
 
|totalTimeInSeconds || double || Length of video
 +
|-
 +
|playerState || text ||
 
|-
 
|-
 
|rating || float || Rating
 
|rating || float || Rating
Line 222: Line 229:
 
|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 || Thumbnail URL
+
|c01 || text || Thumb URL  
 
|-
 
|-
|c02 || text || [unknown - listed as Thumbnail URL spoof]
+
|c02 || text || Thumb URL spoof
 
|-
 
|-
|c03 || text || Play count (unused?)
+
|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 || Year
+
|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 289: Line 296:
 
|-
 
|-
 
|totalTimeInSeconds || double || Time in seconds of the video
 
|totalTimeInSeconds || double || Time in seconds of the video
 +
|-
 +
|playerState || text ||
 +
|}
 +
 +
 +
 +
== 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 || ||
 
|}
 
|}
  
Line 332: Line 380:
 
|c15 || text ||  Title formatted for sorting
 
|c15 || text ||  Title formatted for sorting
 
|-
 
|-
|c16 || text ||  Not Used
+
|c16 || text ||  Trailer
 
|-
 
|-
 
|c17 || text ||  Not Used
 
|c17 || text ||  Not Used
Line 396: Line 444:
 
|dateAdded || text || Date Added
 
|dateAdded || text || Date Added
 
|}
 
|}
 +
 +
 +
 +
== tvshowlinkpath_miniview ==
 +
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}}
Line 401: Line 463:
  
 
= 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.
  
  
Line 437: Line 499:
 
! rowspan="1" style="text-align: centre;" | Music Videos
 
! rowspan="1" style="text-align: centre;" | Music Videos
 
|-
 
|-
|actor_id || integer || Foreign key to [[Databases#actors|actors table]] || ||
+
|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 520: Line 582:
 
|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 529: Line 591:
 
  </resume>
 
  </resume>
 
|-
 
|-
|totalTimeInSeconds || integer || Time in seconds of the video  
+
|totalTimeInSeconds || double || Time in seconds of the video  
 
|-
 
|-
 
|thumbNailImage || text || Thumbnail for bookmark ||
 
|thumbNailImage || text || Thumbnail for bookmark ||
Line 561: Line 623:
 
! 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 || integer || Movie
+
|media_type || text || Media Class
 
|}
 
|}
  
Line 576: Line 638:
 
! 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 586: Line 648:
  
 
== 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 594: Line 656:
 
|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 600: Line 662:
 
|c01 || text ||  Plot Summary || <plot></plot>
 
|c01 || text ||  Plot Summary || <plot></plot>
 
|-
 
|-
|c02 || text ||  [unknown - listed as Votes] ||  
+
|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 610: Line 672:
 
|c06 || text ||  Thumbnail URL || <thumb></thumb>
 
|c06 || text ||  Thumbnail URL || <thumb></thumb>
 
|-
 
|-
|c07 || text ||  [unknown - listed as Thumbnail URL Spoof, unused?] ||
+
|c07 || text ||  Thumbnail URL Spoof ||
 
|-
 
|-
|c08 || text ||  Has the episode been watched? (unused?) ||
+
|c08 || text ||  Not Used ||
 
|-
 
|-
|c09 || text ||  Episode length in minutes (converted to sec in DB) || <runtime></runtime>
+
|c09 || text ||  Runtime || <runtime></runtime>
 
|-
 
|-
 
|c10 || text ||  Director || <director></director>
 
|c10 || text ||  Director || <director></director>
 
|-
 
|-
|c11 || text ||  [unknown - listed as Indentifier] || <code></code>
+
|c11 || text ||  Production Code || <code></code>
 
|-
 
|-
|c12 || text ||  Season Number || <season></season>
+
|c12 || varchar(24) ||  Season Number || <season></season>
 
|-
 
|-
|c13 || text ||  Episode Number || <episode></episode>
+
|c13 || varchar(24) ||  Episode Number || <episode></episode>
 
|-
 
|-
 
|c14 || text ||  Original Title || <originaltitle></originaltitle>
 
|c14 || text ||  Original Title || <originaltitle></originaltitle>
 
|-
 
|-
|c15 || text ||  Season formatted for sorting || <displayseason></displayseason>
+
|c15 || text ||  Season Number- Specials Sorting || <displayseason></displayseason>
 
|-
 
|-
|c16 || text ||  Episode formatted for sorting || <displayepisode></displayepisode>
+
|c16 || text ||  Episode Number- Specials Sorting || <displayepisode></displayepisode>
 
|-
 
|-
|c17 || text ||  Bookmark ||
+
|c17 || varchar(24) ||  Bookmark ||
 
|-
 
|-
 
|c18 || text ||  Path to episode file ||  
 
|c18 || text ||  Path to episode file ||  
 
|-
 
|-
|c19 || text ||  Used- unknown ||
+
|c19 || text ||  Link to [[Databases/MyVideos#path|Path Table]] ||
 
|-
 
|-
|c20 || text ||  Used- unknown ||  
+
|c20 || text ||  Link to [[Databases/MyVideos#uniqueid|UniqueID Table]] ||  
 
|-
 
|-
 
|c21 || text ||  Not used ||
 
|c21 || text ||  Not used ||
Line 644: Line 706:
 
|c23 || text ||  Not used ||
 
|c23 || text ||  Not used ||
 
|-
 
|-
|idShow || text ||  Foreign key to the [[Databases#tvshow|tvshow table]] ||
+
|idShow || integer ||  Foreign key to the [[Databases/MyVideos#tvshow|tvshow table]] ||
 
|-
 
|-
|userrating || text ||  User Rating || <userrating></userrating>
+
|userrating || integer ||  User Rating || <userrating></userrating>
 
|-
 
|-
|idSeason || text ||  Foreign key to the [[Databases#seasons|seasons table]] ||
+
|idSeason || integer ||  Foreign key to the [[Databases/MyVideos#seasons|seasons table]] ||
 
|}  
 
|}  
  
Line 661: Line 723:
 
|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 675: Line 737:
  
 
== 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 693: Line 755:
 
! 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 711: Line 773:
 
|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 721: Line 783:
 
|c03 || text ||  Movie Tagline || <tagline></tagline>
 
|c03 || text ||  Movie Tagline || <tagline></tagline>
 
|-
 
|-
|c04 || text ||  Rating Votes link to [[Databases#rating|Rating Table]] ||
+
|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 ||  Year Released ||
+
|c07 || text ||  Not Used ||
 
|-
 
|-
 
|c08 || text ||  Image URL || <thumb aspect="poster" preview=""></thumb>
 
|c08 || text ||  Image URL || <thumb aspect="poster" preview=""></thumb>
 
|-
 
|-
|c09 || text ||  IMDB ID link to [[Databases#uniqueid|uniqueid Table]] ||
+
|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 minutes (UPnP devices see this as seconds) || <runtime></runtime> **
+
|c11 || text ||  Runtime || <runtime></runtime> **
 
|-
 
|-
 
|c12 || text ||  MPAA Rating || <mpaa></mpaa>
 
|c12 || text ||  MPAA Rating || <mpaa></mpaa>
Line 747: Line 809:
 
|c16 || text ||  Original Movie Title || <originaltitle></originaltitle>
 
|c16 || text ||  Original Movie Title || <originaltitle></originaltitle>
 
|-
 
|-
|c17 || text ||  [unknown - listed as Thumbnail URL Spoof] ||
+
|c17 || text ||  Thumb URL Spoof ||
 
|-
 
|-
 
|c18 || text ||  Studio || <studio></studio>
 
|c18 || text ||  Studio || <studio></studio>
Line 759: Line 821:
 
  </fanart>
 
  </fanart>
 
|-
 
|-
|c21 || text ||  Country (Added in r29886[http://trac.kodi.tv/changeset/29886/trunk]) || <country></country>
+
|c21 || text ||  Country || <country></country>
 
|-
 
|-
 
|c22 || text ||  Path to playable file ||
 
|c22 || text ||  Path to playable file ||
 
|-
 
|-
|c23 || text ||  idPath ||
+
|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 785: Line 847:
 
! 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]]
 
|}
 
|}
  
Line 799: Line 861:
 
|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 || Thumbnail URL || <thumb preview=""></thumb>  
+
|c01 || text || Thumb URL || <thumb preview=""></thumb>  
 
|-
 
|-
|c02 || text || [unknown - listed as Thumbnail URL spoof] ||
+
|c02 || text || Thumb URL spoof ||
 
|-
 
|-
|c03 || text || Play count (unused?) ||
+
|c03 || text || Not Used ||
 
|-
 
|-
 
|c04 || text || Run time || <runtime></runtime>
 
|c04 || text || Run time || <runtime></runtime>
Line 815: Line 877:
 
|c06 || text || Studios || <studio></studio>
 
|c06 || text || Studios || <studio></studio>
 
|-
 
|-
|c07 || text || Year || Not used
+
|c07 || text || Not Used ||
 
|-
 
|-
 
|c08 || text || Plot || <plot></plot>
 
|c08 || text || Plot || <plot></plot>
Line 825: Line 887:
 
|c11 || text || Genre || <genre></genre>
 
|c11 || text || Genre || <genre></genre>
 
|-
 
|-
|c12 || text || Track || Not used
+
|c12 || text || Track ||  
 
|-
 
|-
|c13 || text || Path to playable file || <filenameandpath></filenameandpath><br /><basepath></basepath>
+
|c13 || text || Path to playable file || <filenameandpath></filenameandpath>
 
|-
 
|-
|c14 || text || Unknown || Not used
+
|c14 || text || Link to [[Databases/MyVideos#path|path table]] for Source folder || <basepath></basepath>
 
|-
 
|-
|c15 || text || Unknown || Not used
+
|c15 || text || Not Used ||
 
|-
 
|-
|c16 || text || Unknown || Not used
+
|c16 || text || Not Used ||
 
|-
 
|-
|c17 || text || Unknown || Not used
+
|c17 || text || Not Used ||
 
|-
 
|-
|c18 || text || Unknown || Not used
+
|c18 || text || Not Used ||
 
|-
 
|-
|c19 || text || Unknown || Not used
+
|c19 || text || Not Used ||
 
|-
 
|-
|c20 || text || Unknown || Not used
+
|c20 || text || Not Used ||  
 
|-
 
|-
|c21 || text || Unknown || Not used
+
|c21 || text || Not Used ||
 
|-
 
|-
|c22 || text || Unknown || Not used
+
|c22 || text || Not Used ||
 
|-
 
|-
|c23 || text || Unknown || Not used
+
|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 || <year></year>
+
|premiered || text ||  Date movie premiered || <premiered></premiered>
 
|}
 
|}
  
Line 898: Line 960:
 
|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 926: Line 988:
 
|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>
Line 964: Line 1,026:
 
! 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 984: Line 1,046:
 
|SubtitleOn || bool || Enable subtitles
 
|SubtitleOn || bool || Enable subtitles
 
|-
 
|-
|Brightness || integer || Brightness  
+
|Brightness || float || Brightness  
 
|-
 
|-
|Contrast || integer || Contrast  
+
|Contrast || float || Contrast  
 
|-
 
|-
|Gamma || integer || Gamma  
+
|Gamma || float || Gamma  
 
|-
 
|-
 
|VolumeAmplification || float || VolumeAmplification  
 
|VolumeAmplification || float || VolumeAmplification  
 
|-
 
|-
 
|AudioDelay || float || AudioDelay  
 
|AudioDelay || float || AudioDelay  
|-
 
|OutputToAllSpeakers || bool || OutputToAllSpeakers
 
 
|-
 
|-
 
|ResumeTime || integer || ResumeTime  
 
|ResumeTime || integer || ResumeTime  
|-
 
|Crop || bool || Crop
 
|-
 
|CropLeft || integer || CropLeft
 
|-
 
|CropRight || integer || CropRight
 
|-
 
|CropTop || integer || CropTop
 
|-
 
|CropBottom || integer || CropBottom
 
 
|-
 
|-
 
|Sharpness || float || Sharpness
 
|Sharpness || float || Sharpness
Line 1,025: Line 1,075:
 
|-
 
|-
 
|VideoStream || integer || VideoStream
 
|VideoStream || integer || VideoStream
 +
|-
 +
|TonemapMethod || integer ||
 +
|-
 +
|TonemapParam || float ||
 +
|-
 +
|Orientation || integer ||
 +
|-
 +
|CenterMixLevel || integer ||
 
|}
 
|}
  
Line 1,035: Line 1,093:
 
! 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,050: Line 1,108:
 
! rowspan="1" style="text-align: centre;" | Music Videos **
 
! rowspan="1" style="text-align: centre;" | Music Videos **
 
|-
 
|-
|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 || ||
Line 1,070: Line 1,128:
 
| rowspan="6" style="text-align: left;" |
 
| rowspan="6" style="text-align: left;" |
 
|-
 
|-
|fVideoAspect|| real || Aspect ratio  
+
|fVideoAspect|| float || Aspect ratio  
 
|-
 
|-
 
|iVideoWidth|| integer || Width of the video  
 
|iVideoWidth|| integer || Width of the video  
Line 1,084: Line 1,142:
 
  <fileinfo>
 
  <fileinfo>
 
   <streamdetails>
 
   <streamdetails>
    <video>
 
 
       <audio>
 
       <audio>
 
         <codec></codec>
 
         <codec></codec>
Line 1,090: Line 1,147:
 
         <language></language>
 
         <language></language>
 
       </audio>
 
       </audio>
    </video>
 
 
   </streamdetails>
 
   </streamdetails>
 
  </fileinfo>
 
  </fileinfo>
 
| rowspan="3" style="text-align: left;" |
 
| rowspan="3" style="text-align: left;" |
 
  <fileinfo>
 
  <fileinfo>
   <streamdetails>
+
   <streamdetails>    
    <video>
 
 
       <audio>
 
       <audio>
 
         <codec></codec>
 
         <codec></codec>
Line 1,102: Line 1,157:
 
         <language></language>
 
         <language></language>
 
       </audio>
 
       </audio>
    </video>
 
 
   </streamdetails>
 
   </streamdetails>
 
  </fileinfo>
 
  </fileinfo>
Line 1,153: Line 1,207:
 
! 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,181: Line 1,235:
 
! 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,191: Line 1,245:
  
 
== 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,206: Line 1,260:
 
|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,228: Line 1,282:
 
  </fanart>
 
  </fanart>
 
|-
 
|-
|c12 || text ||  SeriesId (when using thetvdb.com scraper) ||
+
|c12 || text ||  Unique ID issued by Kodi based on Scraper ID's ||
 
|-
 
|-
 
|c13 || text ||  Content Rating || <mpaa></mpaa>
 
|c13 || text ||  Content Rating || <mpaa></mpaa>
Line 1,236: Line 1,290:
 
|c15 || text ||  Title formatted for sorting || <sorttitle></sorttitle>
 
|c15 || text ||  Title formatted for sorting || <sorttitle></sorttitle>
 
|-
 
|-
|c16 || text ||  Not Used ||
+
|c16 || text ||  Trailer  || <trailer></trailer>
 
|-
 
|-
 
|c17 || text ||  Not Used ||
 
|c17 || text ||  Not Used ||
Line 1,254: Line 1,308:
 
|userrating || integer ||  Rating applied by user || <userrating></userrating>
 
|userrating || integer ||  Rating applied by user || <userrating></userrating>
 
|-
 
|-
|duration || text || Length of Episodes || <runtime></runtime>
+
|duration || integer || Length of Episodes || <runtime></runtime>
 
|}
 
|}
 
 
  
 
== tvshowlinkpath ==  
 
== tvshowlinkpath ==  
Line 1,265: Line 1,317:
 
! 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]]
 
|}
 
|}
  
Line 1,309: Line 1,361:
 
! 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,321: Line 1,373:
  
  
{{updated|17}}
+
{{updated|18}}
 
[[Category:Index]]
 
[[Category:Index]]
 
[[Category:Manual]]
 
[[Category:Manual]]

Latest revision as of 21:34, 28 May 2019

Kodi Databases

See also:

Home icon grey.png   ▶ Development
▶ Userdata
▶ Databases ▶ MyVideos



1 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 v18 - MyVideos116.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.


2 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.


2.1 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


2.2 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


2.3 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


2.4 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


2.5 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


2.6 tvshow counts

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


2.7 tvshowlinkpath_miniview

Joins TV Show to Path

Column Name Data Type Description
idShow integer Primary Key
idPath Foreign key to path table


Return to top


3 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.


3.1 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


3.2 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


3.3 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>


3.4 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)


3.5 country

This table lists countries.

Column Name Data Type Description Movies
country_id integer Primary Key
name text Country Name <country></country>


3.6 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


3.7 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


3.8 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


3.9 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>


3.10 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>


3.11 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


3.12 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


3.13 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


3.14 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>


3.15 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 XML file of scraper used for this path
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
dateAdded text
idParentPath integer


3.16 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


3.17 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
userrating integer Season level User Rating


3.18 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


3.19 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


3.20 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


3.21 streamdetails

This table contains information regarding codecs used, aspect ratios etc

Column Name Data Type Description Movies **
TV Episode **
Music Videos **
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
Notes
** Settings Will be overwritten on first play


3.22 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>


3.23 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


3.24 tag

This stores tags.

Column Name Data Type Description Movies
TV Shows
Music Videos
tag_id integer Primary Key
name integer Tag <tag></tag>


3.25 taglinks

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


3.26 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>

3.27 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


3.28 uniqueid

This table links a Movie, TV show and Episode to its the scraper site

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


3.29 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


3.30 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