Databases/Addons - Revision history

Karellen: v21 Updates

2024-05-22T00:07:04Z

v21 Updates

← Older revision		Revision as of 00:07, 22 May 2024
Line 172:		Line 172:

	{{Top}}		{{Top}}
	{{updated\|20}}		{{updated\|21}}

	[[Category:PVR]]		[[Category:PVR]]

Karellen: Updated for v20

2023-01-22T23:16:32Z

Updated for v20

← Older revision		Revision as of 23:16, 22 January 2023
Line 9:		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 ~~v19~~ - Addons33.db		;Kodi v20 - Addons33.db


Line 172:		Line 172:

	{{Top}}		{{Top}}
	{{updated\|19}}		{{updated\|20}}

	[[Category:PVR]]		[[Category:PVR]]

Karellen: Updated for v19

2021-06-24T23:43:54Z

Updated for v19

@@ Line 1: / Line 1: @@
 {{Template:DatabasesNavBox}}
 {{mininav| [[Development]] {{l2| [[Userdata]]}} | [[Databases]]  }}
@@ Line 10: / Line 9: @@
 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
 |}
@@ Line 103: / Line 70: @@
 |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
@@ Line 111: / Line 78: @@
 |lastUsed || text || Date add-o was last used
 |-
-|origin || text || Originating Repository
+|origin || text || Originating Repository<br>
 |}
@@ Line 117: / Line 91: @@
 == 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"
@@ Line 153: / Line 127: @@
 |-
 |version || text || Installed version of the repository
 |}
@@ Line 167: / Line 166: @@
 |idVersion || integer || Database version
 |-
-|iCompressCount || integer ||
+|iCompressCount || integer || Number of times database has been compressed
 |}
@@ Line 173: / Line 172: @@
 {{Top}}
 [[Category:PVR]]
 [[Category:Add-ons]]
 [[Category:Karellen]]
 [[Category:Development]]
 [[Category:Video library]]
 [[Category:Music library]]
-[[Category:Advanced topics]]
+[[Category:Skin_development]]

Karellen: Text replacement - "Category:Live_TV" to ""

2020-11-24T22:28:58Z

Text replacement - "Category:Live_TV" to ""

← Older revision		Revision as of 22:28, 24 November 2020
Line 180:		Line 180:
	[[Category:Manual]]		[[Category:Manual]]
	[[Category:Add-ons]]		[[Category:Add-ons]]
	~~[[Category:Live_TV]]~~
	[[Category:Karellen]]		[[Category:Karellen]]
	[[Category:Development]]		[[Category:Development]]

Karellen: Updated for v18

2019-04-19T03:44:46Z

Updated for v18

← Older revision		Revision as of 03:44, 19 April 2019
Line 6:		Line 6:

	= Addons#.db =		= Addons#.db =
	The Addons#.db database ~~file~~ contains the information on all Kodi addons such as skins, scraper, video-addons etc		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:		The current stable release of {{kodi}} is using the following version of the database:

	;Kodi ~~v17~~ - Addons27.db		;Kodi v18 - Addons27.db


Line 128:		Line 128:
	\|addonID \|\| text \|\| Foreign key to [[Databases/Addons#addons\|addons table]]		\|addonID \|\| text \|\| Foreign key to [[Databases/Addons#addons\|addons table]]
	\|-		\|-
	\|filename \|\| text \|\| ~~Name~~ of add-on zip file		\|filename \|\| text \|\| Path and name of add-on zip file
	\|-		\|-
	\|hash \|\| text \|\| Hash security check of zip file		\|hash \|\| text \|\| Hash security check of zip file
Line 148:		Line 148:
	\|addonID \|\| text \|\| Foreign key to [[Databases/Addons#addons\|addons table]]		\|addonID \|\| text \|\| Foreign key to [[Databases/Addons#addons\|addons table]]
	\|-		\|-
	\|checksum \|\| text \|\| Hash of the repository ~~friendly~~		\|checksum \|\| text \|\| Hash of the repository
	\|-		\|-
	\|lastcheck \|\| text \|\| Last time Repository was checked for updates		\|lastcheck \|\| text \|\| Last time Repository was checked for updates
Line 175:		Line 175:


	{{updated\|17}}		{{updated\|18}}
	[[Category:PVR]]		[[Category:PVR]]
	[[Category:Index]]		[[Category:Index]]

Karellen: Create Page

2018-02-27T02:18:29Z

Create Page

New page

{{Template:DatabasesNavBox}}
{{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

'''{{red|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

{| 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 n
|-
|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="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
|-
|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="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
|}

== installed ==
Add-ons that have been installed, showing status and usage details

{| 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]]
|-
|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="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]]
|-
|filename || text || Name of add-on zip file
|-
|hash || text || Hash security check of zip file
|}

== repo ==
Details related to 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]]
|-
|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="wikitable"
! style="width:130px; text-align:left;" | Column Name
! style="width:100px; text-align:left;" | Data Type
! style="width:400px; text-align:left;" | 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]]