Difference between revisions of "Category:DB Table"

From MythTV Official Wiki
Jump to: navigation, search
(Add link to doxygen code.mythtv.org link. Can the "current version" of DBSchemaVer be removed... not exactly useful, and requires manual updates to this page)
(Add out of date text)
 
Line 1: Line 1:
This category contains all database tables currently used to store information in MythTV.
+
This category contains database tables used to store information in MythTV.
 +
Users will find some of the information listed here is out of date.
 +
{{Note box|Popular wisdom on the mythtv-users' list and channel strongly advises users '''not''' to
 +
manually change their database.}}
  
Schema version is stored as '''DBSchemaVer''' and is currently at version '''1263'''.  
+
The current version of MythTV is {{CurrentRelease}}.
 +
At the time of this page's last update, the schema version (stored as '''DBSchemaVer''') is '''1307'''
 +
for MythTV version '''0.26'''.  
  
Use the following SQL to list all of the tables in the mythconverg [[database]]:
+
If required, the commands that follow will give the user an accurate description
  SHOW tables;
+
of the schema in use on their system.
 +
 
 +
To list all of the tables in the mythconverg [[database]]:
 +
  SHOW TABLES;
  
 
To list the structure of an individual table:
 
To list the structure of an individual table:
Line 12: Line 20:
 
  SHOW CREATE TABLE ''name_of_table'';
 
  SHOW CREATE TABLE ''name_of_table'';
  
Note: The schema is also documented in the doxygen [http://www.cuymedia.net/mythtv-trunk/group__db__schema.html developer documentation], and an [http://code.mythtv.org/doxygen/group__db__schema.html auto-updated version].
+
Note: The schema is also partially documented in the doxygen [http://www.cuymedia.net/mythtv-trunk/group__db__schema.html developer documentation], and an [http://code.mythtv.org/doxygen/group__db__schema.html auto-updated version].
  
 
[[Category:Developer Documentation]]
 
[[Category:Developer Documentation]]
 
[[Category:MySQL]]
 
[[Category:MySQL]]

Latest revision as of 03:17, 19 December 2012

This category contains database tables used to store information in MythTV. Users will find some of the information listed here is out of date.

Important.png Note: Popular wisdom on the mythtv-users' list and channel strongly advises users not to manually change their database.

The current version of MythTV is 0.27. At the time of this page's last update, the schema version (stored as DBSchemaVer) is 1307 for MythTV version 0.26.

If required, the commands that follow will give the user an accurate description of the schema in use on their system.

To list all of the tables in the mythconverg database:

SHOW TABLES;

To list the structure of an individual table:

DESCRIBE name_of_table;

To generate the SQL necessary to recreate a table:

SHOW CREATE TABLE name_of_table;

Note: The schema is also partially documented in the doxygen developer documentation, and an auto-updated version.