Databases: Difference between revisions
>Nmrs |
>Nmrs No edit summary |
||
Line 1: | Line 1: | ||
{{Incomplete}} | {{Incomplete}} | ||
=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== | |||
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== | |||
===episode=== | |||
This table stores television episode information. | |||
{|class="usertable" border="1" | {|class="usertable" border="1" | ||
! 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" | ||
! 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" | ||
! 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)= | |||
*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: 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.