Difference between revisions of "User:Karellen/scratchpad"

From Official Kodi Wiki
Jump to: navigation, search
(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]]
 

Latest revision as of 02:06, 27 February 2018