Category:DB Table

From MythTV Official Wiki
Revision as of 13:31, 27 February 2011 by Mrand (Talk | contribs)

Jump to: navigation, search

This category contains all database tables currently used to store information in MythTV.

Schema version is stored as DBSchemaVer and is currently at version 1263.

Use the following SQL 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 documented in the doxygen developer documentation, and an auto-updated version.