Database Schema

From MythTV Official Wiki
Revision as of 20:52, 14 November 2007 by Bullestock (Talk | contribs)

Jump to: navigation, search

Structure

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

Tables

Information about tables within the mythconverg database at schema 1123, MythTV 0.19 (Currently being updated to the 0.20 schema)

Note: The schema is also documented in the doxygen developer documentation.

Please place new table articles in Category:DB Table.