Category:DB Table

From MythTV Official Wiki
(Redirected from Database Schema)
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 31.0. 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:


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.


This category has the following 9 subcategories, out of 9 total.