Databases: Difference between revisions

From Official Kodi Wiki
Jump to navigation Jump to search
>Nmrs
>Nmrs
No edit summary
Line 1: Line 1:
{{Incomplete}}
{{Incomplete}}
==XBMC Database Details==
=XBMC Database Details=
XBMC utilizes [http://www.sqlite.org/ SQLite], an open source light-weight SQL database-engine, to store all its library related data ([[Music Library|Music]], [[Video Library|Video]] and Program databases). By default, the database files (*.db) are stored in [[The UserData Folder]], specifically $HOME\UserData\Database\.
XBMC utilizes [http://www.sqlite.org/ SQLite], an open source light-weight SQL database-engine, to store all its library related data ([[Music Library|Music]], [[Video Library|Video]] and Program databases). By default, the database files (*.db) are stored in [[The UserData Folder]], specifically $HOME\UserData\Database\.


Line 6: Line 6:
That is independant of if the video is part of the Video Library or not.
That is independant of if the video is part of the Video Library or not.


===Accessing the Database via SQLite application===
==Accessing the Database via SQLite application==
Database files can be transferred via FTP to a Windows-based computer and edited or analyzed with a SQLite graphical client. XBMC's version of the database engine should be compatible with the standard clients such as [http://sqlitebrowser.sourceforge.net SQLiteBrowser] or [http://bobmanc.home.comcast.net/sqlitecc.html SQLiteCC], (more available management-tools can be found in [http://www.sqlite.org/cvstrac/wiki?p=ManagementTools sqlite.org WIKI]).<br>
Database files can be transferred via FTP to a Windows-based computer and edited or analyzed with a SQLite graphical client. XBMC's version of the database engine should be compatible with the standard clients such as [http://sqlitebrowser.sourceforge.net SQLiteBrowser] or [http://bobmanc.home.comcast.net/sqlitecc.html SQLiteCC], (more available management-tools can be found in [http://www.sqlite.org/cvstrac/wiki?p=ManagementTools sqlite.org WIKI]).<br>
We recommend you use [http://www.yunqa.de/delphi/doku.php/products/sqlitespy/index SQLiteSpy version 1.5.2] or higher.
We recommend you use [http://www.yunqa.de/delphi/doku.php/products/sqlitespy/index SQLiteSpy version 1.5.2] or higher.
*[[HOW-TO: Use your computer to edit XBMC's (SQL) database-files]].
*[[HOW-TO: Use your computer to edit XBMC's (SQL) database-files]].


===Database Structure===
==Database Structure==
===episode===
This table stores television episode information.
{|class="usertable" border="1"
{|class="usertable" border="1"
|+ episode - Stores Television Episode Information
! Column Name || Data Type || Description
! Column Name || Data Type || Description
|-
|-
Line 62: Line 63:
|idFle || integer ||  Foreign key to the file for this episode
|idFle || integer ||  Foreign key to the file for this episode
|}
|}
 
===tvshow===
-------------
This table stores television show information.
 
{|class="usertable" border="1"
{|class="usertable" border="1"
|+ tvshow - Stores Television Show Information
! Column Name || Data Type || Description
! Column Name || Data Type || Description
|-
|-
Line 113: Line 112:
|c20 || text ||  [unknown]
|c20 || text ||  [unknown]
|}
|}
 
=== tvshowlinkepisode ===
-------------
This table is a simple linker table to join TV Shows and Episodes.
 
{|class="usertable" border="1"
{|class="usertable" border="1"
|+ tvshowlinkepisode - Linker table to join TV Shows and Episodes
! Column Name || Data Type || Description
! Column Name || Data Type || Description
|-
|-
Line 125: Line 122:
|}
|}


===TO-DO (what needs to be added to this database article)===
=TO-DO (what needs to be added to this database article)=
*The layout, etc. will be explained in more detail here later.
*The layout, etc. will be explained in more detail here later.


Revision as of 17:30, 9 January 2009

Incomplete.png INCOMPLETE:
This page or section is incomplete. Please add information or correct uncertain data which is marked with a ?

XBMC Database Details

XBMC utilizes SQLite, an open source light-weight SQL database-engine, to store all its library related data (Music, Video and Program databases). By default, the database files (*.db) are stored in The UserData Folder, specifically $HOME\UserData\Database\.

Also XBMC puts a video in it's database if you change any OSD setting while watching, resume points are also stored here. That is independant of if the video is part of the Video Library or not.

Accessing the Database via SQLite application

Database files can be transferred via FTP to a Windows-based computer and edited or analyzed with a SQLite graphical client. XBMC's version of the database engine should be compatible with the standard clients such as SQLiteBrowser or SQLiteCC, (more available management-tools can be found in sqlite.org WIKI).
We recommend you use SQLiteSpy version 1.5.2 or higher.

Database Structure

episode

This table stores television episode information.

Column Name Data Type Description
idEpisode integer Primary Key
c00 text Episode Title
c01 text Plot Summary
c02 text [unknown]
c03 text Rating
c04 text Writer
c05 text First Aired
c06 text Thumbnail URL
c07 text [unknown]
c08 text Has the episode been watched?
c09 text [unknown]
c10 text Director
c11 text [unknown]
c12 text Season
c13 text Episode Number
c14 text [unknown]
c15 text [unknown]
c16 text [unknown]
c17 text [unknown]
c18 text [unknown]
c19 text [unknown]
c20 text [unknown]
idFle integer Foreign key to the file for this episode

tvshow

This table stores television show information.

Column Name Data Type Description
idShow integer Primary Key
c00 text Show Title
c01 text Show Summary
c02 text [unknown]
c03 text [unknown]
c04 text Rating
c05 text First Aired
c06 text Thumbnail URL
c07 text [unknown]
c08 text Genre
c09 text [unknown]
c10 text Episode Guide URL
c11 text Fan Art URL
c12 text [unknown]
c13 text [unknown]
c14 text [unknown]
c15 text [unknown]
c16 text [unknown]
c17 text [unknown]
c18 text [unknown]
c19 text [unknown]
c20 text [unknown]

tvshowlinkepisode

This table is a simple linker table to join TV Shows and Episodes.

Column Name Data Type Description
idShow integer Foreign Key to tvshow table
idEpisode integer Foreign Key to episode table

TO-DO (what needs to be added to this database article)

  • The layout, etc. will be explained in more detail here later.
Retrieved from "https://kodi.wiki/index.php?title=Databases&oldid=6401"