Databases/MyVideos - Revision history

Crystalp: Add originalLanguage field to movies tvshows movie_view tvshow_view

2026-01-11T03:08:07Z

Add originalLanguage field to movies tvshows movie_view tvshow_view

← Older revision		Revision as of 03:08, 11 January 2026
Line 186:		Line 186:
	\|-		\|-
	\|premiered \|\| text \|\| Date movie premiered		\|premiered \|\| text \|\| Date movie premiered
			\|-
			\|originalLanguage \|\| text \|\| Main spoken language of the show (added in v22)
	\|-		\|-
	\|strSet \|\| text \|\| Movie Set		\|strSet \|\| text \|\| Movie Set
Line 413:		Line 415:
	\|-		\|-
	\|duration \|\| integer \|\| Total duration		\|duration \|\| integer \|\| Total duration
			\|-
			\|originalLanguage \|\| text \|\| Main spoken language of the show (added in v22)
	\|-		\|-
	\|tagline \|\| text \|\| Show tagline (added in v22)		\|tagline \|\| text \|\| Show tagline (added in v22)
Line 849:		Line 853:
	\|-		\|-
	\|premiered \|\| text \|\| Date movie premiered \|\| <premiered></premiered>		\|premiered \|\| text \|\| Date movie premiered \|\| <premiered></premiered>
			\|-
			\|originalLanguage \|\| text \|\| Main spoken language of the movie (added in v22) \|\| <originallanguage></originallanguage>
	\|}		\|}

Line 1,331:		Line 1,337:
	\|-		\|-
	\|duration \|\| integer \|\| Length of Episodes \|\| <runtime></runtime>		\|duration \|\| integer \|\| Length of Episodes \|\| <runtime></runtime>
			\|-
			\|originalLanguage \|\| text \|\| Main spoken language of the show (added in v22) \|\| <originallanguage></originallanguage>
	\|-		\|-
	\|tagline \|\| text \|\| Show tagline (added in v22) \|\| <tagline></tagline>		\|tagline \|\| text \|\| Show tagline (added in v22) \|\| <tagline></tagline>

Crystalp: Clarify tvshow tagline is available from v22

2026-01-11T01:23:56Z

Clarify tvshow tagline is available from v22

← Older revision		Revision as of 01:23, 11 January 2026
Line 414:		Line 414:
	\|duration \|\| integer \|\| Total duration		\|duration \|\| integer \|\| Total duration
	\|-		\|-
	\|tagline \|\| text \|\| Show tagline		\|tagline \|\| text \|\| Show tagline (added in v22)
	\|-		\|-
	\|idParentPath \|\| integer \|\|		\|idParentPath \|\| integer \|\|
Line 1,332:		Line 1,332:
	\|duration \|\| integer \|\| Length of Episodes \|\| <runtime></runtime>		\|duration \|\| integer \|\| Length of Episodes \|\| <runtime></runtime>
	\|-		\|-
	\|tagline \|\| text \|\| Show tagline \|\| <tagline></tagline>		\|tagline \|\| text \|\| Show tagline (added in v22) \|\| <tagline></tagline>
	\|}		\|}

Crystalp: Add tagline field to tvshow and tvshow_view

2026-01-11T01:20:15Z

Add tagline field to tvshow and tvshow_view

← Older revision		Revision as of 01:20, 11 January 2026
Line 413:		Line 413:
	\|-		\|-
	\|duration \|\| integer \|\| Total duration		\|duration \|\| integer \|\| Total duration
			\|-
			\|tagline \|\| text \|\| Show tagline
	\|-		\|-
	\|idParentPath \|\| integer \|\|		\|idParentPath \|\| integer \|\|
Line 1,329:		Line 1,331:
	\|-		\|-
	\|duration \|\| integer \|\| Length of Episodes \|\| <runtime></runtime>		\|duration \|\| integer \|\| Length of Episodes \|\| <runtime></runtime>
			\|-
			\|tagline \|\| text \|\| Show tagline \|\| <tagline></tagline>
	\|}		\|}

Crystalp: /* videoversion */

2024-05-27T21:26:31Z

videoversion

← Older revision		Revision as of 21:26, 27 May 2024
Line 1,384:		Line 1,384:
	\|idMedia \|\| integer \|\| id of the media		\|idMedia \|\| integer \|\| id of the media
	\|-		\|-
	\|media_type \|\| text \|\| The type of media this asset is linked with (v21: ~~movies~~ only)		\|media_type \|\| text \|\| The type of media this asset is linked with (v21: the only supported value is "movie")
	\|-		\|-
	\|itemType \|\| integer \|\| Type of video asset. 0 = VideoVersion; 1 = Extras		\|itemType \|\| integer \|\| Type of video asset. 0 = VideoVersion; 1 = Extras

Crystalp: /* art */

2024-05-27T21:24:34Z

art

← Older revision		Revision as of 21:24, 27 May 2024
Line 550:		Line 550:
	\|media_id \|\| integer \|\| The id of the media this piece of art is for \|\| \|\| \|\| \|\|		\|media_id \|\| integer \|\| The id of the media this piece of art is for \|\| \|\| \|\| \|\|
	\|-		\|-
	\|media_type \|\| text \|\| The type of media this art applies to - movie, set, tvshow, season, episode, musicvideo or ~~actor~~ \|\| \|\| \|\| \|\|		\|media_type \|\| text \|\| The type of media this art applies to - movie, set, tvshow, season, episode, musicvideo, actor or videoversion\|\| \|\| \|\| \|\|
	\|-		\|-
	\|type \|\| text \|\| The image type - poster, fanart, thumb, banner, landscape, clearlogo, clearart, characterart or discart \|\|\|\| \|\| \|\|		\|type \|\| text \|\| The image type - poster, fanart, thumb, banner, landscape, clearlogo, clearart, characterart or discart \|\|\|\| \|\| \|\|
Line 587:		Line 587:
	</art>		</art>
	\|}		\|}



	== bookmark ==		== bookmark ==

Crystalp: /* videoversion */

2024-05-27T21:22:44Z

videoversion

← Older revision		Revision as of 21:22, 27 May 2024
Line 1,378:		Line 1,378:

	== videoversion ==		== videoversion ==
	This table stores the ~~versioning data~~ for the Video Versions feature. <ref>https://github.com/xbmc/xbmc/pulls?page=4&q=is%3Apr+label%3A%22Feature%3A+Video+Versions%2FExtras%22+is%3Aclosed</ref>		This table stores the relations between media "parents" (movies, episodes, ...) and their video assets (versions, extras) for the Video Versions feature. <ref>https://github.com/xbmc/xbmc/pulls?page=4&q=is%3Apr+label%3A%22Feature%3A+Video+Versions%2FExtras%22+is%3Aclosed</ref>
	{\|class="prettytable"		{\|class="prettytable"
	! Column Name \|\| Data Type \|\| Description		! Column Name \|\| Data Type \|\| Description
	\|-		\|-
	\|idFile \|\| integer \|\| Foreign Key to [[Databases/MyVideos#files\|files table]]		\|idFile \|\| integer \|\| The video asset. Foreign Key to [[Databases/MyVideos#files\|files table]]
	\|-		\|-
	\|idMedia \|\| integer \|\| ~~Foreign key to a~~ media ~~table~~		\|idMedia \|\| integer \|\| id of the media
	\|-		\|-
	\|media_type \|\| text \|\| ~~Media~~ type ~~for link~~		\|media_type \|\| text \|\| The type of media this asset is linked with (v21: movies only)
	\|-		\|-
	\|itemType \|\| integer \|\| 0 = VideoVersion; 1 = Extras		\|itemType \|\| integer \|\| Type of video asset. 0 = VideoVersion; 1 = Extras
	\|-		\|-
	\|idType \|\| integer \|\| Foreign key to a videoversiontype table		\|idType \|\| integer \|\| Name of the video asset. Foreign key to the [[Databases/MyVideos#videoversiontype\|videoversiontype table]]
	\|}		\|}



	== videoversiontype ==		== videoversiontype ==

Crystalp: /* videoversiontype */

2024-05-27T21:09:59Z

videoversiontype

← Older revision		Revision as of 21:09, 27 May 2024
Line 1,396:		Line 1,396:

	== videoversiontype ==		== videoversiontype ==
	This table stores the ~~versioning data~~ for the Video Versions feature.<ref>https://github.com/xbmc/xbmc/pulls?page=4&q=is%3Apr+label%3A%22Feature%3A+Video+Versions%2FExtras%22+is%3Aclosed</ref>		This table stores the version types/names and extras names for the Video Versions feature.<ref>https://github.com/xbmc/xbmc/pulls?page=4&q=is%3Apr+label%3A%22Feature%3A+Video+Versions%2FExtras%22+is%3Aclosed</ref>
	{\|class="prettytable"		{\|class="prettytable"
	! Column Name \|\| Data Type \|\| Description		! Column Name \|\| Data Type \|\| Description
Line 1,402:		Line 1,402:
	\|id \|\| integer \|\| Primary Key		\|id \|\| integer \|\| Primary Key
	\|-		\|-
	\|name \|\| text \|\| ~~Description~~ of version ~~type~~		\|name \|\| text \|\| Name / type of the version or extra
	\|-		\|-
	\|owner \|\| integer \|\| 0 = ~~{{Kodi}} default~~; 1 = ~~User~~ added		\|owner \|\| integer \|\| 0 = prepopulated by the system; 1 = added by library scan; 2 = added by user
	\|-		\|-
	\|~~idType~~ \|\| integer \|\| 0 = ~~default VideoVersion type~~; 1 = Extras~~; 2 = User added VideoVersion type~~		\|itemType \|\| integer \|\| type of asset the record applies to. 0 = Version; 1 = Extras
	\|}		\|}



	== writer_link ==		== writer_link ==

Crystalp at 20:02, 27 May 2024

2024-05-27T20:02:51Z

← Older revision		Revision as of 20:02, 27 May 2024
Line 20:		Line 20:


	== ~~episodeview~~ ==		== episode_view ==
	A view that joins episode to file and tvshow (through tvshowlinkepisode) and path.		A view that joins episode to file and tvshow (through tvshowlinkepisode) and path.

Line 123:		Line 123:


	== ~~movieview~~ ==		== movie_view ==
	A view that joins movie to file and ~~path~~.		A view that joins movie to file, path, videoversion and videoversiontype. One record per movie version. Most values are the same for all versions of a movie.

	{\|class="prettytable"		{\|class="prettytable"
Line 131:		Line 131:
	\|idMovie \|\| integer \|\| Primary Key		\|idMovie \|\| integer \|\| Primary Key
	\|-		\|-
	\|idFile \|\| integer \|\| Foreign Key to [[Databases/MyVideos#files\|files table]]		\|idFile \|\| integer \|\| Foreign Key to [[Databases/MyVideos#files\|files table]] for the default version of the movie.
	\|-		\|-
	\|c00 \|\| text \|\| Local Movie Title		\|c00 \|\| text \|\| Local Movie Title
Line 217:		Line 217:
	\|uniqueid_type \|\| text \|\| Provider of the default UniqueID. eg... <uniqueid type="tmdb" default="true">		\|uniqueid_type \|\| text \|\| Provider of the default UniqueID. eg... <uniqueid type="tmdb" default="true">
	\|-		\|-
	\|hasVideoVersions \|\| integer \|\| 0 = ~~Not part of~~ a ~~VideoVersion~~; 1 = ~~Part of a VideoVersion set~~		\|hasVideoVersions \|\| integer \|\| 0 = the movie has a single version; 1 = the movie has additional versions
	\|-		\|-
	\|hasVideoExtras \|\| integer \|\| 0 = No Extras; 1 = ~~Contains~~ Extras		\|hasVideoExtras \|\| integer \|\| 0 = No Extras; 1 = has Extras
	\|-		\|-
	\|~~isDefautlVersion~~ \|\| integer \|\| 0 = Not the default / parent version; 1 = Default / parent version		\|isDefaultVersion \|\| integer \|\| 0 = Not the default / parent version; 1 = Default / parent version
	\|-		\|-
	\|videoVersionIdFile \|\| integer \|\| Foreign Key to [[Databases/MyVideos#files\|files table]]		\|videoVersionIdFile \|\| integer \|\| [version specific] Foreign Key to [[Databases/MyVideos#files\|files table]]
	\|-		\|-
	\|videoVersionTypeId \|\| integer \|\| Foreign Key to videoversiontype table		\|videoVersionTypeId \|\| integer \|\| [version specific] Foreign Key to [[Databases/MyVideos#videoversiontype\|videoversiontype table]]
	\|-		\|-
	\|videoVersionTypeName \|\| text \|\| Descriptive name of version ~~type from~~ videoversiontype table		\|videoVersionTypeName \|\| text \|\| [version specific] Descriptive name of the version, see [[Databases/MyVideos#videoversiontype\|videoversiontype table]]
	\|-		\|-
	\|VideoVersionTypeItemType \|\| integer \|\|		\|VideoVersionTypeItemType \|\| integer \|\| [version specific] Type of the version, see [[Databases/MyVideos#videoversiontype\|videoversiontype table]]
	\|}		\|}



	== ~~musicvideoview~~ ==		== musicvideo_view ==
	A view that joins musicvideo to file and path.		A view that joins musicvideo to file and path.
	{\|class="prettytable"		{\|class="prettytable"
Line 355:		Line 355:


	== ~~tvshowview~~ ==		== tvshow_view ==
	View that joins tvshow to path. Also produces information about total number of episodes as well as number of watched and unwatched episodes.		View that joins tvshow to path. Also produces information about total number of episodes as well as number of watched and unwatched episodes.
	{\|class="prettytable"		{\|class="prettytable"

Karellen: v21 Updates

2024-05-22T03:39:30Z

v21 Updates

← Older revision		Revision as of 03:39, 22 May 2024
Line 116:		Line 116:
	\|rating_type \|\| text \|\| Type of rating		\|rating_type \|\| text \|\| Type of rating
	\|-		\|-
	\|uniqueid_value \|\| text \|\|		\|uniqueid_value \|\| text \|\| Default UniqueID ( default="true" )
	\|-		\|-
	\|uniqueid_type \|\| text \|\|		\|uniqueid_type \|\| text \|\| Provider of the default UniqueID. eg... <uniqueid type="tmdb" default="true">
	\|}		\|}

Line 213:		Line 213:
	\|rating_type \|\| text \|\| Type of rating		\|rating_type \|\| text \|\| Type of rating
	\|-		\|-
	\|uniqueid_value \|\| text \|\|		\|uniqueid_value \|\| text \|\| Default UniqueID ( default="true" )
	\|-		\|-
	\|uniqueid_type \|\| text \|\|		\|uniqueid_type \|\| text \|\| Provider of the default UniqueID. eg... <uniqueid type="tmdb" default="true">
			\|-
			\|hasVideoVersions \|\| integer \|\| 0 = Not part of a VideoVersion; 1 = Part of a VideoVersion set
			\|-
			\|hasVideoExtras \|\| integer \|\| 0 = No Extras; 1 = Contains Extras
			\|-
			\|isDefautlVersion \|\| integer \|\| 0 = Not the default / parent version; 1 = Default / parent version
			\|-
			\|videoVersionIdFile \|\| integer \|\| Foreign Key to [[Databases/MyVideos#files\|files table]]
			\|-
			\|videoVersionTypeId \|\| integer \|\| Foreign Key to videoversiontype table
			\|-
			\|videoVersionTypeName \|\| text \|\| Descriptive name of version type from videoversiontype table
			\|-
			\|VideoVersionTypeItemType \|\| integer \|\|
	\|}		\|}

Line 332:		Line 346:
	\|episodes \|\| text \|\| Season episode count		\|episodes \|\| text \|\| Season episode count
	\|-		\|-
	\|playCount \|\| \|\|		\|playCount \|\| integer \|\| Number of play times. Each played episode increases the count
			\|-
			\|aired \|\| text \|\| Aired date of the first episode in the season
	\|-		\|-
	\|~~aired~~ \|\| \|\|		\|inProgressCount \|\| integer \|\| Show watched/in progress/total counts in home screen listings and video window listings<ref>https://github.com/xbmc/xbmc/pull/23658</ref>
	\|}		\|}

Line 398:		Line 414:
	\|duration \|\| integer \|\| Total duration		\|duration \|\| integer \|\| Total duration
	\|-		\|-
	\|idParentPath \|\| integer \|\|		\|idParentPath \|\| integer \|\|
	\|-		\|-
	\|strPath \|\| text \|\| Path URL		\|strPath \|\| text \|\| Path URL
Line 418:		Line 434:
	\|rating_type \|\| text \|\| Type of rating		\|rating_type \|\| text \|\| Type of rating
	\|-		\|-
	\|uniqueid_value \|\| text \|\|		\|uniqueid_value \|\| text \|\| Default UniqueID ( default="true" )
			\|-
			\|uniqueid_type \|\| text \|\| Provider of the default UniqueID. eg... <uniqueid type="tmdb" default="true">
	\|-		\|-
	\|~~uniqueid_type~~ \|\| ~~text~~ \|\|		\|inProgressCount \|\| integer \|\| Show in progress episodes count along with watched episodes and total episodes count in home screen listings and video window listings.<ref>https://github.com/xbmc/xbmc/pull/23658</ref>
	\|}		\|}

Line 441:		Line 459:
	\|-		\|-
	\|dateAdded \|\| text \|\| Date Added		\|dateAdded \|\| text \|\| Date Added
			\|-
			\|inProgressCount \|\| integer \|\| Show in progress episodes count along with watched episodes and total episodes count in home screen listings and video window listings.<ref>https://github.com/xbmc/xbmc/pull/23658</ref>
	\|}		\|}

Line 1,353:		Line 1,373:
	\|-		\|-
	\|idCompressCount \|\| integer \|\| Number of times database has been compressed		\|idCompressCount \|\| integer \|\| Number of times database has been compressed
			\|}



			== videoversion ==
			This table stores the versioning data for the Video Versions feature. <ref>https://github.com/xbmc/xbmc/pulls?page=4&q=is%3Apr+label%3A%22Feature%3A+Video+Versions%2FExtras%22+is%3Aclosed</ref>
			{\|class="prettytable"
			! Column Name \|\| Data Type \|\| Description
			\|-
			\|idFile \|\| integer \|\| Foreign Key to [[Databases/MyVideos#files\|files table]]
			\|-
			\|idMedia \|\| integer \|\| Foreign key to a media table
			\|-
			\|media_type \|\| text \|\| Media type for link
			\|-
			\|itemType \|\| integer \|\| 0 = VideoVersion; 1 = Extras
			\|-
			\|idType \|\| integer \|\| Foreign key to a videoversiontype table
			\|}



			== videoversiontype ==
			This table stores the versioning data for the Video Versions feature.<ref>https://github.com/xbmc/xbmc/pulls?page=4&q=is%3Apr+label%3A%22Feature%3A+Video+Versions%2FExtras%22+is%3Aclosed</ref>
			{\|class="prettytable"
			! Column Name \|\| Data Type \|\| Description
			\|-
			\|id \|\| integer \|\| Primary Key
			\|-
			\|name \|\| text \|\| Description of version type
			\|-
			\|owner \|\| integer \|\| 0 = {{Kodi}} default; 1 = User added
			\|-
			\|idType \|\| integer \|\| 0 = default VideoVersion type; 1 = Extras; 2 = User added VideoVersion type
	\|}		\|}

Line 1,370:		Line 1,424:
	\|}		\|}



			= References =
			<references />


Line 1,375:		Line 1,433:

	{{Top}}		{{Top}}
	{{updated\|20}}		{{updated\|21}}

	[[Category:Karellen]]		[[Category:Karellen]]

Karellen: add tag

2023-12-28T09:46:53Z

add <hdrtype></hdrtype> tag

← Older revision		Revision as of 09:46, 28 December 2023
Line 1,179:		Line 1,179:
	\|strVideoLanguage\|\| text \|\| Language of the Video \|\| \|\| \|\|		\|strVideoLanguage\|\| text \|\| Language of the Video \|\| \|\| \|\|
	\|-		\|-
	\|strHdrType\|\| text \|\| hdr type of the video \|\| \|\| \|\| v20 <ref>https://github.com/xbmc/xbmc/pull/19983</ref>		\|strHdrType\|\| text \|\| hdr type of the video \|\| <hdrtype></hdrtype> \|\| \|\| v20 <ref>https://github.com/xbmc/xbmc/pull/19983</ref>
	\|}		\|}