Databases/Addons: Difference between revisions

From Official Kodi Wiki
Jump to navigation Jump to search
← Older edit
Update for v22
Tag: Reverted
m Undo revision 264499 by Karellen (talk)
Tag: Undo
 
Line 4: Line 4:




= EPG#.db =
= Addons#.db =
The EPG#.db database file contains the listings for the Electronic Program Guide for Live-TV and saved searches.
The Addons#.db database contains the information on all Kodi addons such as skins, scraper, video-addons etc


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




Line 16: Line 16:




== epg ==
== addonlinkrepo ==
Lists the channel names and source of the EPG information
Links the Add-on to the Repository


{| class="wikitable"
{| class="wikitable"
! style="width:130px; text-align:left;" | Column Name  
! style="width:130px; text-align:left;" | Column Name  
! style="width:100px; text-align:left;" |  Data Type
! style="width:100px; text-align:left;" |  Data Type
! style="width:400px; text-align:left;" | Description
! style="width:400px; text-align:left;" | Description n
|-
|-
|idEpg || integer || Primary Key
|idRepo || integer || Foreign key to [[Databases/Addons#repo|repo table]]
|-
|-
|sName || varchar(64) || Channel Name
|idAddon || integer || Foreign key to [[Databases/Addons#addons|addons table]]
|-
|sScraperName || varchar(32) || Source of Information
|}
|}




== epgtags ==
 
This table stores the downloaded EPG data
== addons ==
Details relating to the add-on


{| class="wikitable"
{| class="wikitable"
! style="width:130px; text-align:left;" | Column Name  
! style="width:130px; text-align:left;" | Column Name  
! style="width:100px; text-align:left;" |  Data Type
! style="width:100px; text-align:left;" |  Data Type
! style="width:400px; text-align:left;" | Description
! style="width:400px; text-align:left;" | Description  
|-
|-
|idBroadcast || integer || Primary Key  
|id || integer || Primary Key  
|-
|-
|idBroadcastUid || integer ||  
|metadata || blob ||  
|-
|-
|idEpg || integer ||  
|addonID || text || ID of the Add-on
|-
|-
|sTitle || varchar(128) || Program Name
|version || text || Add-on version
|-
|-
|sPlotOutline || text || Short program description
|name || text || Add-on friendly name
|-
|-
|sPlot || text || Long program description
|summary || text || Short friendly description
|-
|-
|sOriginalTitle || varchar(128) || Original program title
|news || text || Notes
|-
|-
|sCast || varchar(255) || Cast in program
|description || text || Extended description of add-on
|-
|}
|sDirector || varchar(255) || Director of program
 
 
 
== installed ==
Add-ons that have been installed, showing status and usage 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
|-
|-
|sWriter || varchar(255) || Writer of program
|id || integer || Primary Key
|-
|-
|iYear || integer || Release year of program
|addonID || text || Foreign key to [[Databases/Addons#addons|addons table]]
|-
|-
|sIMDBNumber || varchar(50) || IMDB title ID
|enabled || boolean || 0/1 - No / Yes
|-
|-
|sIconPath || varchar(255) || Path to channel icon
|installDate || text || Date add-on was installed
|-
|-
|iStartTime || integer || Program start time in seconds from 1 January 1970
|lastUpdated || text || Date add-on was last updated
|-
|-
|iEndTime || integer || Program end time in seconds from 1 January 1970
|lastUsed || text || Date add-o was last used
|-
|-
|iGenreType || Integer ||  
|origin || text || Originating Repository<br>
*A hash (if it's b6a50484-93a0-4afb-a01c-8d17e059feda) means ORIGIN_SYSTEM<br>
*blank means MANUAL (or from ZIP) install<br>
*anything else is installed from a REPOSITORY.<br>
See: [https://github.com/xbmc/xbmc/blob/592fdeef613d44e0f8a8d6375a900435d34ded3b/xbmc/addons/addoninfo/AddonInfo.h#L30-L57 Github]
|-
|-
|iGenreSubType || integer ||
|disabledReason || Integer ||   NONE = 0<br>USER = 1<br>INCOMPATIBLE = 2<br>PERMANENT_FAILURE = 3<br>
|-
See: [https://github.com/xbmc/xbmc/blob/592fdeef613d44e0f8a8d6375a900435d34ded3b/xbmc/addons/addoninfo/AddonInfo.h#L30-L57 Github]
|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 <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>
|}
|}




== lastepgscan ==
 
This table holds information detailing EPG updates
== package ==
Details of downloaded zip files for installation. Can be used to roll-back to previous versions. Does not include add-ons installed using ''Install via zip file'' method.


{| class="wikitable"
{| class="wikitable"
! style="width:130px; text-align:left;" | Column Name  
! style="width:130px; text-align:left;" | Column Name  
! style="width:100px; text-align:left;" |  Data Type
! style="width:100px; text-align:left;" |  Data Type
! style="width:400px; text-align:left;" | Description
! style="width:400px; text-align:left;" | Description  
|-
|-
|idEpg || integer || Primary Key
|id || integer || Primary Key
|-
|-
|sLastScan || varchar(20) || yyy-mm-dd hh:mm:ss of last EPG scan for new content
|addonID || text || Foreign key to [[Databases/Addons#addons|addons table]]
|-
|filename || text || Path and name of add-on zip file
|-
|hash || text || Hash security check of zip file
|}
|}




== 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>
 
== repo ==
Details related to the Repository


{| class="wikitable"
{| class="wikitable"
! style="width:130px; text-align:left;" | Column Name  
! style="width:130px; text-align:left;" | Column Name  
! style="width:100px; text-align:left;" |  Data Type
! style="width:100px; text-align:left;" |  Data Type
! style="width:400px; text-align:left;" | Description
! style="width:400px; text-align:left;" | Description  
|-
|-
|idSearch || integer || Primary Key  
|id || integer || Primary Key
|-
|-
|sTitle || varchar(255) ||  
|addonID || text || Foreign key to [[Databases/Addons#addons|addons table]]
|-
|-
|idLastExecutedDateTime || varchar(20) ||  
|checksum || text || Hash of the repository
|-
|-
|sSearchTerm || varchar(255) ||  
|lastcheck || text || Last time Repository was checked for updates
|-
|-
|bSearchInDescription || bool ||  
|version || text || Installed version of the repository
|-
|-
|iGenreType || Integer ||  
|nextcheck || text || Next scheduled check for updates
|-
|}
|sStartDateTime || varchar(20) ||  
 
|-
 
|sEndDateTime || varchar(20) ||  
 
== update_rules ==
How non-official repositories are updated
 
{| 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
|-
|-
|bIsCasaeSensitive || bool ||  
|id || integer || Primary Key
|-
|-
|iMinimumDuration || integer ||  
|addonID || text || Foreign key to [[Databases/Addons#addons|addons table]]
|-
|-
|iMaximumDuration || integer ||  
|updateRule || Integer || Any = 0<br>
|-
::used internally, not to be explicitly set<br>
|bIsRadio || bool ||
User Disabled Auto Update = 1<br>
|-
::automatic updates disabled via AddonInfo dialog<br>
|iClientId || integer ||
Pin Old Version = 2<br>
|-
::user downgraded to an older version<br>
|iChallenUid || integer ||
See: [https://github.com/xbmc/xbmc/blob/592fdeef613d44e0f8a8d6375a900435d34ded3b/xbmc/addons/addoninfo/AddonInfo.h#L30-L57 Github]
|-
|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 184: Line 162:
! style="width:130px; text-align:left;" | Column Name  
! style="width:130px; text-align:left;" | Column Name  
! style="width:100px; text-align:left;" |  Data Type
! style="width:100px; text-align:left;" |  Data Type
! style="width:400px; text-align:left;" | Description
! style="width:400px; text-align:left;" | Description  
|-
|-
|idVersion || integer || Database version
|idVersion || integer || Database version
Line 190: Line 168:
|iCompressCount || integer || Number of times database has been compressed
|iCompressCount || integer || Number of times database has been compressed
|}
|}
= References =
<references />




Line 202: Line 175:


[[Category:PVR]]
[[Category:PVR]]
[[Category:Add-ons]]
[[Category:Karellen]]
[[Category:Karellen]]
[[Category:Development]]
[[Category:Development]]
[[Category:Video library]]
[[Category:Music library]]
[[Category:Skin_development]]

Latest revision as of 23:11, 13 October 2026

Kodi Databases

See also:

  ▶ Development
▶ Userdata		 ▶ Databases ▶ Addons


Addons#.db

The Addons#.db database contains the information on all Kodi addons such as skins, scraper, video-addons etc

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

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


addonlinkrepo

Links the Add-on to the Repository

Column Name Data Type Description n
idRepo integer Foreign key to repo table
idAddon integer Foreign key to addons table


addons

Details relating to the add-on

Column Name Data Type Description
id integer Primary Key
metadata blob
addonID text ID of the Add-on
version text Add-on version
name text Add-on friendly name
summary text Short friendly description
news text Notes
description text Extended description of add-on


installed

Add-ons that have been installed, showing status and usage details

Column Name Data Type Description
id integer Primary Key
addonID text Foreign key to addons table
enabled boolean 0/1 - No / Yes
installDate text Date add-on was installed
lastUpdated text Date add-on was last updated
lastUsed text Date add-o was last used
origin text Originating Repository
  • A hash (if it's b6a50484-93a0-4afb-a01c-8d17e059feda) means ORIGIN_SYSTEM
  • blank means MANUAL (or from ZIP) install
  • anything else is installed from a REPOSITORY.

See: Github

disabledReason Integer NONE = 0
USER = 1
INCOMPATIBLE = 2
PERMANENT_FAILURE = 3

See: Github


package

Details of downloaded zip files for installation. Can be used to roll-back to previous versions. Does not include add-ons installed using Install via zip file method.

Column Name Data Type Description
id integer Primary Key
addonID text Foreign key to addons table
filename text Path and name of add-on zip file
hash text Hash security check of zip file



repo

Details related to the Repository

Column Name Data Type Description
id integer Primary Key
addonID text Foreign key to addons table
checksum text Hash of the repository
lastcheck text Last time Repository was checked for updates
version text Installed version of the repository
nextcheck text Next scheduled check for updates


update_rules

How non-official repositories are updated

Column Name Data Type Description
id integer Primary Key
addonID text Foreign key to addons table
updateRule Integer Any = 0
used internally, not to be explicitly set

User Disabled Auto Update = 1

automatic updates disabled via AddonInfo dialog

Pin Old Version = 2

user downgraded to an older version

See: Github


version

Database details

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


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