Category:DB Table

From MythTV Official Wiki
Revision as of 03:17, 19 December 2012 by Llib (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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.4. 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.