Databases/Epg - Revision history

Karellen: v21 Updates

2024-05-22T00:09:36Z

v21 Updates

← Older revision		Revision as of 00:09, 22 May 2024
Line 184:		Line 184:

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

	[[Category:PVR]]		[[Category:PVR]]
	[[Category:Karellen]]		[[Category:Karellen]]
	[[Category:Development]]		[[Category:Development]]

Karellen: Updated for v20

2023-01-23T00:11:45Z

Updated for v20

@@ Line 9: / Line 9: @@
 The current stable release of {{kodi}} is using the following version of the database:
-;Kodi v19 - Epg13.db
+;Kodi v20 - Epg16.db
@@ Line 31: / Line 31: @@
 |}
 == epgtags ==
@@ Line 77: / Line 76: @@
 |sGenre || varchar(128) ||
 |-
-|iFirstAired || Integer || First time aired
+|sFirstAired || varchar(32) || First time aired
 |-
 |iParentalRating || Integer || Parental rating
@@ Line 94: / Line 93: @@
 |-
 |sSeriesLink || varchar(255) ||
 |}
@@ Line 111: / Line 111: @@
 |}
@@ Line 131: / Line 184: @@
 {{Top}}
-{{updated|19}}
+{{updated|20}}
 [[Category:PVR]]
 [[Category:Karellen]]
 [[Category:Development]]

Karellen: Updated for v19

2021-06-24T23:44:35Z

Updated for v19

← Older revision		Revision as of 23:44, 24 June 2021
Line 1:		Line 1:
	{{Template:DatabasesNavBox}}		{{Template:DatabasesNavBox}}
	{{mininav\| [[Development]] {{l2\| [[Userdata]]}} \| [[Databases]] }}		{{mininav\| [[Development]] {{l2\| [[Userdata]]}} \| [[Databases]] }}



Line 10:		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 ~~v18~~ - ~~Epg12~~.db		;Kodi v19 - Epg13.db


Line 83:		Line 82:
	\|-		\|-
	\|iStarRating \|\| Integer \|\| Star rating		\|iStarRating \|\| Integer \|\| Star rating
	\|-
	~~\|bNotify \|\| bool \|\|~~
	\|-		\|-
	\|iSeriesId \|\| Integer \|\|		\|iSeriesId \|\| Integer \|\|
	\|-		\|-
	\|~~iEpisodeID~~ \|\| Integer \|\|		\|iEpisodeId \|\| Integer \|\|
	\|-		\|-
	\|iEpisodePart \|\| Integer \|\|		\|iEpisodePart \|\| Integer \|\|
Line 96:		Line 93:
	\|iFlags \|\| Integer \|\|		\|iFlags \|\| Integer \|\|
	\|-		\|-
	\|sSeriesLink \|\| varchar(255) \|\|		\|sSeriesLink \|\| varchar(255) \|\|
	\|}		\|}

Line 126:		Line 123:
	\|idVersion \|\| integer \|\| Database version		\|idVersion \|\| integer \|\| Database version
	\|-		\|-
	\|iCompressCount \|\| integer \|\|		\|iCompressCount \|\| integer \|\| Number of times database has been compressed
	\|}		\|}





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


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

	[[Category:Karellen]]		[[Category:Karellen]]
	[[Category:Development]]		[[Category:Development]]
	~~[[Category:Video library]]~~
	~~[[Category:Music library]]~~
	~~[[Category:Advanced topics]]~~

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

2020-11-24T22:28:40Z

Text replacement - "Category:Live_TV" to ""

← Older revision		Revision as of 22:28, 24 November 2020
Line 138:		Line 138:
	[[Category:Index]]		[[Category:Index]]
	[[Category:Manual]]		[[Category:Manual]]
	~~[[Category:Live_TV]]~~
	[[Category:Karellen]]		[[Category:Karellen]]
	[[Category:Development]]		[[Category:Development]]

Karellen: Updated for v18

2019-04-19T03:52:27Z

Updated for v18

← Older revision		Revision as of 03:52, 19 April 2019
Line 10:		Line 10:
	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~~ - ~~Epg11~~.db		;Kodi v18 - Epg12.db


Line 32:		Line 32:
	\|}		\|}

			Nuvola apps kscd.png

	== epgtags ==		== epgtags ==
Line 68:		Line 68:
	\|sIconPath \|\| varchar(255) \|\| Path to channel icon		\|sIconPath \|\| varchar(255) \|\| Path to channel icon
	\|-		\|-
	\|iStartTime \|\| integer \|\| Program start time in seconds from ??		\|iStartTime \|\| integer \|\| Program start time in seconds from 1 January 1970
	\|-		\|-
	\|iEndTime \|\| integer \|\| Program end time in seconds from ??		\|iEndTime \|\| integer \|\| Program end time in seconds from 1 January 1970
	\|-		\|-
	\|iGenreType \|\| Integer \|\|		\|iGenreType \|\| Integer \|\|
Line 95:		Line 95:
	\|-		\|-
	\|iFlags \|\| Integer \|\|		\|iFlags \|\| Integer \|\|
			\|-
			\|sSeriesLink \|\| varchar(255) \|\|
	\|}		\|}

Line 132:		Line 134:


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

Karellen at 02:31, 30 April 2018

2018-04-30T02:31:09Z

← Older revision		Revision as of 02:31, 30 April 2018
Line 68:		Line 68:
	\|sIconPath \|\| varchar(255) \|\| Path to channel icon		\|sIconPath \|\| varchar(255) \|\| Path to channel icon
	\|-		\|-
	\|iStartTime \|\| integer \|\| Program start time in seconds from ~~1 January 1970~~		\|iStartTime \|\| integer \|\| Program start time in seconds from ??
	\|-		\|-
	\|iEndTime \|\| integer \|\| Program end time in seconds from ~~1 January 1970~~		\|iEndTime \|\| integer \|\| Program end time in seconds from ??
	\|-		\|-
	\|iGenreType \|\| Integer \|\|		\|iGenreType \|\| Integer \|\|

Karellen: Create Page

2018-02-27T02:13:37Z

Create Page

New page

{{Template:DatabasesNavBox}}
{{mininav| [[Development]] {{l2| [[Userdata]]}} | [[Databases]] }}

= EPG#.db =
The EPG#.db database file contains the listings for the Electronic Program Guide for Live-TV

The current stable release of {{kodi}} is using the following version of the database:

;Kodi v17 - Epg11.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.}}'''

== epg ==
Lists the channel names and source of the EPG information

{| 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
|-
|idEpg || integer || Primary Key
|-
|sName || varchar(64) || Channel Name
|-
|sScraperName || varchar(32) || Source of Information
|}

== epgtags ==
This table stores the downloaded EPG data

{| 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
|-
|idBroadcast || integer || Primary Key
|-
|idBroadcastUid || integer ||
|-
|idEpg || integer ||
|-
|sTitle || varchar(128) || Program Name
|-
|sPlotOutline || text || Short program description
|-
|sPlot || text || Long program description
|-
|sOriginalTitle || varchar(128) || Original program title
|-
|sCast || varchar(255) || Cast in program
|-
|sDirector || varchar(255) || Director of program
|-
|sWriter || varchar(255) || Writer of program
|-
|iYear || integer || Release year of program
|-
|sIMDBNumber || varchar(50) || IMDB title ID
|-
|sIconPath || varchar(255) || Path to channel icon
|-
|iStartTime || integer || Program start time in seconds from 1 January 1970
|-
|iEndTime || integer || Program end time in seconds from 1 January 1970
|-
|iGenreType || Integer ||
|-
|iGenreSubType || integer ||
|-
|sGenre || varchar(128) ||
|-
|iFirstAired || Integer || First time aired
|-
|iParentalRating || Integer || Parental rating
|-
|iStarRating || Integer || Star rating
|-
|bNotify || bool ||
|-
|iSeriesId || Integer ||
|-
|iEpisodeID || Integer ||
|-
|iEpisodePart || Integer ||
|-
|sEpisodeName || varchar(128) ||
|-
|iFlags || Integer ||
|}

== lastepgscan ==
This table holds information detailing EPG updates

{| 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
|-
|idEpg || integer || Primary Key
|-
|sLastScan || varchar(20) || yyy-mm-dd hh:mm:ss of last EPG scan for new content
|}

== 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:Live_TV]]
[[Category:Karellen]]
[[Category:Development]]
[[Category:Video library]]
[[Category:Music library]]
[[Category:Advanced topics]]