Difference between revisions of "User:Karellen/scratchpad"

From Official Kodi Wiki
Jump to: navigation, search
(Page cleared)
Line 1: Line 1:
 +
{{mininav| [[Development]] {{l2| [[Userdata]]}} | [[Databases]]  }}
  
 +
 +
 +
= Addons#.db =
 +
The Addons#.db database file 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 v17 - Addons27.db
 +
 +
 +
 +
== addonlinkrepo ==
 +
Links the Add-on to the Repository
 +
 +
{|class="prettytable"
 +
! Column Name || Data Type || Description
 +
|-
 +
|idRepo || integer || Foreign key to [[Databases/Addons#repo|repo table]]
 +
|-
 +
|idAddon || integer || Foreign key to [[Databases/Addons#addons|addons table]]
 +
|}
 +
 +
 +
 +
== addons ==
 +
Details relating to the add-on
 +
 +
{|class="prettytable"
 +
! 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
 +
|}
 +
 +
 +
 +
== blacklist ==
 +
 +
 +
{|class="prettytable"
 +
! Column Name || Data Type || 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="prettytable"
 +
! Column Name || Data Type || 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
 +
|}
 +
 +
 +
 +
== installed ==
 +
Add-ons that have been installed, showing status and usage details
 +
 +
{|class="prettytable"
 +
! Column Name || Data Type || Description
 +
|-
 +
|id || integer || Primary Key
 +
|-
 +
|addonID || text || Foreign key to [[Databases/Addons#addons|addons table]]
 +
|-
 +
|enabled || boolean || Y/N
 +
|-
 +
|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
 +
|}
 +
 +
 +
 +
== package ==
 +
 +
 +
{|class="prettytable"
 +
! Column Name || Data Type || Description
 +
|-
 +
|id || integer || Primary Key
 +
|-
 +
|addonID || text || Foreign key to [[Databases/Addons#addons|addons table]]
 +
|-
 +
|filename || text || Name of add-on zip file
 +
|-
 +
|hash || text || Hash security check of zip file
 +
|}
 +
 +
 +
 +
 +
== repo ==
 +
Details related to the Repository
 +
 +
{|class="prettytable"
 +
! Column Name || Data Type || Description
 +
|-
 +
|id || integer || Primary Key
 +
|-
 +
|addonID || text || Foreign key to [[Databases/Addons#addons|addons table]]
 +
|-
 +
|checksum || text || Hash of the repository friendly
 +
|-
 +
|lastcheck || text || Last time Repository was checked for updates
 +
|-
 +
|version || text || Installed version of the repository
 +
|}
 +
 +
 +
 +
== version ==
 +
Database details
 +
 +
{|class="prettytable"
 +
! Column Name || Data Type || 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]]

Revision as of 22:38, 26 February 2018

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


1 Addons#.db

The Addons#.db database file 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 v17 - Addons27.db


1.1 addonlinkrepo

Links the Add-on to the Repository

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


1.2 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


1.3 blacklist

Column Name Data Type Description
id integer Primary Key
addonID text Foreign key to addons table


1.4 broken

Add-ons marked as broken in the repository

Column Name Data Type Description
id integer Primary Key
addonID text Foreign key to addons table
reason text Reason installed add-on is marked as broken


1.5 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 Y/N
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


1.6 package

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



1.7 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 friendly
lastcheck text Last time Repository was checked for updates
version text Installed version of the repository


1.8 version

Database details

Column Name Data Type Description
idVersion integer Database version
iCompressCount integer


Return to top