Difference between revisions of "Database Schema"

From MythTV Official Wiki
Jump to: navigation, search
Line 103: Line 103:
  
 
[[Category:Developer Documentation]]
 
[[Category:Developer Documentation]]
 +
[[Category:MySQL]]

Revision as of 19:23, 23 December 2006

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.