Databases/Epg: Difference between revisions

From Official Kodi Wiki
Jump to navigation Jump to search
Create Page
 
Update for v22
 
(6 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]]  }}






= EPG#.db =
= EPG#.db =
The EPG#.db database file contains the listings for the Electronic Program Guide for Live-TV
The EPG#.db database file contains the listings for the Electronic Program Guide for Live-TV and saved searches.


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 - Epg11.db
;Kodi v22 - Epg22.db




Line 31: Line 30:
|sScraperName || varchar(32) || Source of Information
|sScraperName || varchar(32) || Source of Information
|}
|}




Line 78: Line 76:
|sGenre || varchar(128) ||  
|sGenre || varchar(128) ||  
|-
|-
|iFirstAired || Integer || First time aired
|sFirstAired || varchar(32) || First time aired
|-
|-
|iParentalRating || Integer || Parental rating
|iParentalRating || Integer || Parental rating
|-
|-
|iStarRating || Integer || Star rating
|iStarRating || Integer || Star rating
|-
|bNotify || bool ||
|-
|-
|iSeriesId || Integer ||  
|iSeriesId || Integer ||  
|-
|-
|iEpisodeID || Integer ||  
|iEpisodeId || Integer ||  
|-
|-
|iEpisodePart || Integer ||  
|iEpisodePart || Integer ||  
Line 95: Line 91:
|-
|-
|iFlags || Integer ||  
|iFlags || Integer ||  
|-
|sSeriesLink || varchar(255) ||
|-
|sParentalRatingCode || varchar(64) ||
|-
|sParentalRatingIcon || varchar(512) || Stores icons associated with parental rating codes <ref name="pr24096">https://github.com/xbmc/xbmc/pull/24096</ref>
|-
|sParentalRatingSource || varchar(128) || Source of the parental rating <ref name="pr24096" />
|-
|sTitleExtraInfo || varchar(128) || Support for extra information text supplied by many EPG providers to give more details for programme entries. <ref>https://github.com/xbmc/xbmc/pull/25867</ref>
|}
|}




Line 112: Line 117:
|}
|}


== savedsearches ==
This table holds information for saved PVR guide (EPG) searches, which is a new feature added in v20. <ref>https://github.com/xbmc/xbmc/pull/20437</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 
|-
|idSearch || integer || Primary Key
|-
|sTitle || varchar(255) ||
|-
|idLastExecutedDateTime || varchar(20) ||
|-
|sSearchTerm || varchar(255) ||
|-
|bSearchInDescription || bool ||
|-
|iGenreType || Integer ||
|-
|sStartDateTime || varchar(20) ||
|-
|sEndDateTime || varchar(20) ||
|-
|bIsCasaeSensitive || bool ||
|-
|iMinimumDuration || integer ||
|-
|iMaximumDuration || integer ||
|-
|bIsRadio || bool ||
|-
|iClientId || integer ||
|-
|iChallenUid || integer ||
|-
|bIncludeUnknownGenres || bool ||
|-
|bRemoveDuplicates || bool ||
|-
|bIgnoreFinishedBroadcasts || bool ||
|-
|bIgnoreFutureBroadcasts || bool ||
|-
|bFreeToAirOnly || bool ||
|-
|bIgnorePresentTimers || bool ||
|-
|bIgnorePresentRecordings || bool ||
|-
|iChannelGroup || Integer ||
|-
|sIconPath || varchar(255) || store icons associated with channels <ref  name="pr25746">https://github.com/xbmc/xbmc/pull/25746</ref>
|-
|bStartAnyTime || bool || Set optional start time of programming when searching <ref name="pr25746" />
|-
|bEndAnyTime || bool || Set optional end time of programming when searching <ref name="pr25746" />
|}




Line 124: Line 188:
|idVersion || integer || Database version
|idVersion || integer || Database version
|-
|-
|iCompressCount || integer ||  
|iCompressCount || integer || Number of times database has been compressed
|}
|}
= References =
<references />






{{Top}}
{{Top}}
{{updated|22}}


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

Latest revision as of 23:12, 13 October 2026

Kodi Databases

See also:

  ▶ Development
▶ Userdata		 ▶ Databases ▶ Epg


EPG#.db

The EPG#.db database file contains the listings for the Electronic Program Guide for Live-TV and saved searches.

The current stable release of Kodi is using the following version of the database:

Kodi v22 - Epg22.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.


epg

Lists the channel names and source of the EPG information

Column Name Data Type Description
idEpg integer Primary Key
sName varchar(64) Channel Name
sScraperName varchar(32) Source of Information


epgtags

This table stores the downloaded EPG data

Column Name Data Type Description
idBroadcast integer Primary Key
idBroadcastUid integer
idEpg integer
sTitle varchar(128) Program Name
sPlotOutline text Short program description
sPlot text Long program description
sOriginalTitle varchar(128) Original program title
sCast varchar(255) Cast in program
sDirector varchar(255) Director of program
sWriter varchar(255) Writer of program
iYear integer Release year of program
sIMDBNumber varchar(50) IMDB title ID
sIconPath varchar(255) Path to channel icon
iStartTime integer Program start time in seconds from 1 January 1970
iEndTime integer Program end time in seconds from 1 January 1970
iGenreType Integer
iGenreSubType integer
sGenre varchar(128)
sFirstAired varchar(32) First time aired
iParentalRating Integer Parental rating
iStarRating Integer Star rating
iSeriesId Integer
iEpisodeId Integer
iEpisodePart Integer
sEpisodeName varchar(128)
iFlags Integer
sSeriesLink varchar(255)
sParentalRatingCode varchar(64)
sParentalRatingIcon varchar(512) Stores icons associated with parental rating codes [1]
sParentalRatingSource varchar(128) Source of the parental rating [1]
sTitleExtraInfo varchar(128) Support for extra information text supplied by many EPG providers to give more details for programme entries. [2]


lastepgscan

This table holds information detailing EPG updates

Column Name Data Type Description
idEpg integer Primary Key
sLastScan varchar(20) yyy-mm-dd hh:mm:ss of last EPG scan for new content


savedsearches

This table holds information for saved PVR guide (EPG) searches, which is a new feature added in v20. [3]

Column Name Data Type Description
idSearch integer Primary Key
sTitle varchar(255)
idLastExecutedDateTime varchar(20)
sSearchTerm varchar(255)
bSearchInDescription bool
iGenreType Integer
sStartDateTime varchar(20)
sEndDateTime varchar(20)
bIsCasaeSensitive bool
iMinimumDuration integer
iMaximumDuration integer
bIsRadio bool
iClientId integer
iChallenUid integer
bIncludeUnknownGenres bool
bRemoveDuplicates bool
bIgnoreFinishedBroadcasts bool
bIgnoreFutureBroadcasts bool
bFreeToAirOnly bool
bIgnorePresentTimers bool
bIgnorePresentRecordings bool
iChannelGroup Integer
sIconPath varchar(255) store icons associated with channels [4]
bStartAnyTime bool Set optional start time of programming when searching [4]
bEndAnyTime bool Set optional end time of programming when searching [4]


version

Database details

Column Name Data Type Description
idVersion integer Database version
iCompressCount integer Number of times database has been compressed


References

  1. ↑ 1.0 1.1 https://github.com/xbmc/xbmc/pull/24096
  2. ↑ https://github.com/xbmc/xbmc/pull/25867
  3. ↑ https://github.com/xbmc/xbmc/pull/20437
  4. ↑ 4.0 4.1 4.2 https://github.com/xbmc/xbmc/pull/25746


Return to top
Retrieved from "https://kodi.wiki/index.php?title=Databases/Epg&oldid=264505"