User:Karellen/scratchpad: Difference between revisions

From Official Kodi Wiki
Jump to navigation Jump to search
No edit summary
(Blanked the page)
Line 1: Line 1:
{{mininav| [[Development]] {{l2| [[Userdata]]}} | [[Databases]]  }}


{| class="infobox"
! style="width:160px; text-align:left;" |<div align="center"><big>'''{{kodi}} Databases:'''</big></div>
*[[Databases]]
**[[Databases/Addons|Addons]]
**[[Databases/ADSP|ADSP]]
**[[Databases/Epg|Epg]]
**[[Databases/MyMusic|MyMusic]]
**[[Databases/MyVideos|MyVideos]]
**[[Databases/Textures|Textures]]
**[[Databases/TV|TV]]
**[[Databases/ViewModes|ViewModes]]
----
'''''See also'''''
*[[Database_Schema_4.0/a|Database Schema]]
*[[NFO_files|NFO Files]]
*[[MySQL|Shared Library 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 02:06, 27 February 2018

Retrieved from "https://kodi.wiki/index.php?title=User:Karellen/scratchpad&oldid=136057"