Databases/TV - Revision history

Karellen: v21 Updates

2024-05-22T01:04:51Z

v21 Updates

← Older revision		Revision as of 01:04, 22 May 2024
Line 40:		Line 40:
	\|-		\|-
	\|iLastOpened \|\| bigint unsigned \|\| Epoch time		\|iLastOpened \|\| bigint unsigned \|\| Epoch time
			\|-
			\|iClientId \|\| integer \|\| <ref>https://github.com/xbmc/xbmc/pull/23016</ref>
			\|-
			\|bIsUserSetName \|\| bool \|\| <ref>https://github.com/xbmc/xbmc/pull/23016</ref>
			\|-
			\|sClientName \|\| varchar(64) \|\| <ref>https://github.com/xbmc/xbmc/pull/23016</ref>
			\|-
			\|iClientPosition \|\| integer \|\| <ref>https://github.com/xbmc/xbmc/pull/23016</ref>
	\|}		\|}

Line 87:		Line 95:
	\|-		\|-
	\|bIsUserSetHidden \|\| bool \|\|		\|bIsUserSetHidden \|\| bool \|\|
			\|-
			\|iLastWatchedGroupId \|\| integer \|\| Id of the group used to last watched <ref>https://github.com/xbmc/xbmc/pull/23985</ref>
	\|}		\|}

Line 164:		Line 174:
	! style="width:400px; text-align:left;" \| Description		! style="width:400px; text-align:left;" \| Description
	\|-		\|-
	\|iClientIndex \|\| integer \|\| [https://github.com/xbmc/xbmc/pull/15467/~~files See Github]~~		\|iClientIndex \|\| integer \|\| <ref>https://github.com/xbmc/xbmc/pull/15467</ref>
	\|-		\|-
	\|iParentClientIndex \|\| integer \|\|		\|iParentClientIndex \|\| integer \|\|
Line 228:		Line 238:
	\|}		\|}



			= References =
			<references />


Line 233:		Line 247:

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

	[[Category:PVR]]		[[Category:PVR]]
	[[Category:Karellen]]		[[Category:Karellen]]
	[[Category:Development]]		[[Category:Development]]

Karellen: Updated for v20

2023-01-23T03:15:30Z

Updated for v20

← Older revision		Revision as of 03:15, 23 January 2023
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 ~~v19~~ - ~~TV38~~.db		;Kodi v20 - TV40.db


Line 56:		Line 56:
	\|iUniqueId \|\| integer \|\|		\|iUniqueId \|\| integer \|\|
	\|-		\|-
	\|~~blsRadio~~ \|\| bool \|\| Is Radio Channel- Y/N		\|bIsRadio \|\| bool \|\| Is Radio Channel- Y/N
	\|-		\|-
	\|~~blsHidden~~ \|\| bool \|\| Hidden Channel? Y/N		\|bIsHidden \|\| bool \|\| Hidden Channel? Y/N
	\|-		\|-
	\|~~blsUserSetIcon~~ \|\| bool \|\| Has user set channel icon		\|bIsUserSetIcon \|\| bool \|\| Has user set channel icon
	\|-		\|-
	\|~~blsUerSetName~~ \|\| bool \|\| Has user set channel name		\|bIsUerSetName \|\| bool \|\| Has user set channel name
	\|-		\|-
	\|~~blsLocked~~ \|\| bool \|\| Locked channel? Y/N		\|bIsLocked \|\| bool \|\| Locked channel? Y/N
	\|-		\|-
	\|sIconPath \|\| varchar(255) \|\| Path to channel logo icon		\|sIconPath \|\| varchar(255) \|\| Path to channel logo icon
Line 70:		Line 70:
	\|sChannelName \|\| varchar(64) \|\| Friendly name of channel		\|sChannelName \|\| varchar(64) \|\| Friendly name of channel
	\|-		\|-
	\|~~blsVirtual~~ \|\| bool \|\| Virtual channel? Y/N		\|bIsVirtual \|\| bool \|\| Virtual channel? Y/N
	\|-		\|-
	\|bEPGEnabled \|\| bool \|\| Receive EPG? Y/N		\|bEPGEnabled \|\| bool \|\| Receive EPG? Y/N
Line 83:		Line 83:
	\|-		\|-
	\|bHasArchive \|\| bool \|\| Set true if this channel supports archive		\|bHasArchive \|\| bool \|\| Set true if this channel supports archive
			\|-
			\|iClientProviderUid \|\| integer \|\|
			\|-
			\|bIsUserSetHidden \|\| bool \|\|
	\|}		\|}

Line 122:		Line 126:
	\|iClientSubChannelNumber \|\| integer \|\|		\|iClientSubChannelNumber \|\| integer \|\|
	\|}		\|}



			== providers ==
			Information of channel providers <ref>https://github.com/xbmc/xbmc/pull/19395</ref>

			{\| class="wikitable"
			! style="width:130px; text-align:left;" \| Column Name
			! style="width:100px; text-align:left;" \| Data Type
			! style="width:400px; text-align:left;" \| Description
			\|-
			\|idProvider \|\| integer \|\|
			\|-
			\|iUniqueId \|\| integer \|\|
			\|-
			\|iClientId \|\| integer \|\|
			\|-
			\|sName \|\| varchar(64) \|\|
			\|-
			\|iType \|\| integer \|\|
			\|-
			\|sIconPath \|\| varchar(255) \|\|
			\|-
			\|sCountries \|\| varchar(64) \|\|
			\|-
			\|sLanguages \|\| varchar(64) \|\|
			\|}



Line 201:		Line 233:

	{{Top}}		{{Top}}
	{{updated\|19}}		{{updated\|20}}

	[[Category:PVR]]		[[Category:PVR]]
	[[Category:Karellen]]		[[Category:Karellen]]
	[[Category:Development]]		[[Category:Development]]

Karellen: Updated for v19

2021-06-24T23:50:05Z

Updated for v19

@@ Line 10: / Line 10: @@
 The current stable release of {{kodi}} is using the following version of the database:
-;Kodi v18 - TV32.db
+;Kodi v19 - TV38.db
@@ Line 38: / Line 38: @@
 |-
 |iPosition || integer ||
 |}
@@ Line 79: / Line 81: @@
 |-
 |idEPG || integer ||
 |}
@@ Line 111: / Line 115: @@
 |-
 |iSubChannelNumber || integer || Sub-channel number
 |}
@@ Line 127: / Line 195: @@
 |iCompressCount || integer ||
 |}
 {{Top}}
 [[Category:PVR]]
 [[Category:Karellen]]
 [[Category:Development]]

Karellen: Text replacement - "Category:Live_TV" to ""

2020-11-24T22:28:44Z

Text replacement - "Category:Live_TV" to ""

← Older revision		Revision as of 22:28, 24 November 2020
Line 138:		Line 138:
	[[Category:Manual]]		[[Category:Manual]]
	[[Category:Add-ons]]		[[Category:Add-ons]]
	~~[[Category:Live_TV]]~~
	[[Category:Karellen]]		[[Category:Karellen]]
	[[Category:Development]]		[[Category:Development]]

Karellen: Updated for v18

2019-04-23T05:31:56Z

Updated for v18

← Older revision		Revision as of 05:31, 23 April 2019
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~~ - ~~TV29~~.db		;Kodi v18 - TV32.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.}}'''		'''{{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 30:		Line 31:
	\|iGroupType \|\| integer \|\|		\|iGroupType \|\| integer \|\|
	\|-		\|-
	\|~~iGroupType~~ \|\| varchar(64) \|\| Name of Channel Group		\|sName \|\| varchar(64) \|\| Name of Channel Group
	\|-		\|-
	\|iLastWatched \|\| integer \|\| Last time Channel Group watched		\|iLastWatched \|\| integer \|\| Last time Channel Group watched
Line 73:		Line 74:
	\|sEPGScraper \|\| varchar(32) \|\| Source of EPG data		\|sEPGScraper \|\| varchar(32) \|\| Source of EPG data
	\|-		\|-
	\|iLastWatched \|\| integer \|\| Last time channel watched ~~in seconds from 1 Jan 1970~~		\|iLastWatched \|\| integer \|\| Last time channel watched using [[wikipedia:Unix_time\|Epoch Time]]
	\|-		\|-
	\|iClientId \|\| integer \|\|		\|iClientId \|\| integer \|\|
	\|-		\|-
	\|idEPG \|\| integer \|\|		\|idEPG \|\| integer \|\|
			\|}



			== clients ==
			{\| class="wikitable"
			! style="width:130px; text-align:left;" \| Column Name
			! style="width:100px; text-align:left;" \| Data Type
			! style="width:400px; text-align:left;" \| Description
			\|-
			\|idClient \|\| integer \|\|
			\|-
			\|iPriority \|\| integer \|\|
	\|}		\|}

Line 119:		Line 133:


	{{updated\|17}}		{{updated\|18}}
	[[Category:PVR]]		[[Category:PVR]]
	[[Category:Index]]		[[Category:Index]]

Karellen: Create Page

2018-02-27T02:05:05Z

Create Page

New page

{{Template:DatabasesNavBox}}
{{mininav| [[Development]] {{l2| [[Userdata]]}} | [[Databases]] }}

= TV#.db =
The TV#.db database file contains the information for Live-TV channels.

The current stable release of {{kodi}} is using the following version of the database:

;Kodi v17 - TV29.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.}}'''

== channelgroups ==
Holds the information related to the Channel Groups

{| class="wikitable"
! style="width:130px; text-align:left;" | Column Name
! style="width:100px; text-align:left;" | Data Type
! style="width:400px; text-align:left;" | Description
|-
|idGroup || integer || Primary Key
|-
|blsRadio || bool || Is Radio Group- Y/N
|-
|iGroupType || integer ||
|-
|iGroupType || varchar(64) || Name of Channel Group
|-
|iLastWatched || integer || Last time Channel Group watched
|-
|blsHidden || bool || Hidden group? Y/N
|-
|iPosition || integer ||
|}

== channels ==
Holds the information related to each TV Channel

{| class="wikitable"
! style="width:130px; text-align:left;" | Column Name
! style="width:100px; text-align:left;" | Data Type
! style="width:400px; text-align:left;" | Description
|-
|idChannel || integer || Primary Key
|-
|iUniqueId || integer ||
|-
|blsRadio || bool || Is Radio Channel- Y/N
|-
|blsHidden || bool || Hidden Channel? Y/N
|-
|blsUserSetIcon || bool || Has user set channel icon
|-
|blsUerSetName || bool || Has user set channel name
|-
|blsLocked || bool || Locked channel? Y/N
|-
|sIconPath || varchar(255) || Path to channel logo icon
|-
|sChannelName || varchar(64) || Friendly name of channel
|-
|blsVirtual || bool || Virtual channel? Y/N
|-
|bEPGEnabled || bool || Receive EPG? Y/N
|-
|sEPGScraper || varchar(32) || Source of EPG data
|-
|iLastWatched || integer || Last time channel watched in seconds from 1 Jan 1970
|-
|iClientId || integer ||
|-
|idEPG || integer ||
|}

== map_channelgroups_channels ==
Links Channels to Channel Groups

{| class="wikitable"
! style="width:130px; text-align:left;" | Column Name
! style="width:100px; text-align:left;" | Data Type
! style="width:400px; text-align:left;" | Description
|-
|idChannel || integer || Channel number from [[Databases/TV#channels|channels table]]
|-
|idGroup || integer || Group number from [[Databases/TV#channelgroups|channelgroups table]]
|-
|iChannelNumber || integer || Channel number
|-
|iSubChannelNumber || integer || Sub-channel number
|}

== version ==
Database details

{| class="wikitable"
! style="width:130px; text-align:left;" | Column Name
! style="width:100px; text-align:left;" | Data Type
! style="width:400px; text-align:left;" | Description
|-
|idVersion || integer || Database version
|-
|iCompressCount || integer ||
|}

{{Top}}

{{updated|17}}
[[Category:PVR]]
[[Category:Index]]
[[Category:Manual]]
[[Category:Add-ons]]
[[Category:Live_TV]]
[[Category:Karellen]]
[[Category:Development]]
[[Category:Video library]]
[[Category:Music library]]
[[Category:Advanced topics]]