Databases/Addons: Difference between revisions

From Official Kodi Wiki
Jump to navigation Jump to search
(Updated for v18)
(Updated for v19)
(One intermediate revision by the same user not shown)
Line 1: Line 1:
{{Template:DatabasesNavBox}}
{{Template:DatabasesNavBox}}
{{mininav| [[Development]] {{l2| [[Userdata]]}} | [[Databases]]  }}
{{mininav| [[Development]] {{l2| [[Userdata]]}} | [[Databases]]  }}




Line 10: Line 9:
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 v18 - Addons27.db
;Kodi v19 - Addons33.db




Line 55: Line 54:
|-
|-
|description || text || Extended description of add-on
|description || text || Extended description of add-on
|}
== blacklist ==
{| 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
|-
|id || integer || Primary Key
|-
|addonID || text || Foreign key to [[Databases/Addons#addons|addons table]]
|}
== broken ==
Add-ons marked as broken in the repository
{| 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
|-
|id || integer || Primary Key
|-
|addonID || text || Foreign key to [[Databases/Addons#addons|addons table]]
|-
|reason || text || Reason installed add-on is marked as broken
|}
|}


Line 103: Line 70:
|addonID || text || Foreign key to [[Databases/Addons#addons|addons table]]
|addonID || text || Foreign key to [[Databases/Addons#addons|addons table]]
|-
|-
|enabled || boolean || Y/N
|enabled || boolean || 0/1 - No / Yes
|-
|-
|installDate || text || Date add-on was installed
|installDate || text || Date add-on was installed
Line 111: Line 78:
|lastUsed || text || Date add-o was last used
|lastUsed || text || Date add-o was last used
|-
|-
|origin || text || Originating Repository
|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]
|-
|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]
|}
|}


Line 117: Line 91:


== package ==
== 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"
Line 153: Line 127:
|-
|-
|version || text || Installed version of the repository
|version || text || Installed version of the repository
|-
|nextcheck || text || Next scheduled check for updates
|}
== 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
|-
|id || integer || Primary Key
|-
|addonID || text || Foreign key to [[Databases/Addons#addons|addons table]]
|-
|updateRule || Integer || Any = 0<br>
::used internally, not to be explicitly set<br>
User Disabled Auto Update = 1<br>
::automatic updates disabled via AddonInfo dialog<br>
Pin Old Version = 2<br>
::user downgraded to an older version<br>
See: [https://github.com/xbmc/xbmc/blob/592fdeef613d44e0f8a8d6375a900435d34ded3b/xbmc/addons/addoninfo/AddonInfo.h#L30-L57 Github]
|}
|}


Line 167: Line 166:
|idVersion || integer || Database version
|idVersion || integer || Database version
|-
|-
|iCompressCount || integer ||  
|iCompressCount || integer || Number of times database has been compressed
|}
|}


Line 173: Line 172:


{{Top}}
{{Top}}
{{updated|19}}


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

Revision as of 23:43, 24 June 2021

Kodi Databases

See also:

Home icon grey.png   ▶ 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 v19 - 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=228870"