Databases/TV

From Official Kodi Wiki
Jump to: navigation, search
Kodi Databases

See also:

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



1 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


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.


1.1 channelgroups

Holds the information related to the Channel Groups

Column Name Data Type 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


1.2 channels

Holds the information related to each TV Channel

Column Name Data Type 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


1.3 map_channelgroups_channels

Links Channels to Channel Groups

Column Name Data Type Description
idChannel integer Channel number from channels table
idGroup integer Group number from channelgroups table
iChannelNumber integer Channel number
iSubChannelNumber integer Sub-channel number


1.4 version

Database details

Column Name Data Type Description
idVersion integer Database version
iCompressCount integer


Return to top