User:Karellen/scratchpad: Difference between revisions
Jump to navigation
Jump to search
(Page cleared) |
No edit summary |
||
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
Development Userdata |
Databases | scratchpad |
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
Column Name | Data Type | Description |
---|---|---|
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 |
blacklist
Column Name | Data Type | Description |
---|---|---|
id | integer | Primary Key |
addonID | text | Foreign key to addons table |
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 |
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 |
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 |
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 |
version
Database details
Column Name | Data Type | Description |
---|---|---|
idVersion | integer | Database version |
iCompressCount | integer |
Return to top |
---|