Difference between revisions of "Category:DB Table"
From MythTV Official Wiki
m |
(Add link to doxygen code.mythtv.org link. Can the "current version" of DBSchemaVer be removed... not exactly useful, and requires manual updates to this page) |
||
| Line 12: | Line 12: | ||
SHOW CREATE TABLE ''name_of_table''; | SHOW CREATE TABLE ''name_of_table''; | ||
| − | Note: The schema is also documented in the doxygen [http://www.cuymedia.net/mythtv-trunk/group__db__schema.html developer documentation]. | + | Note: The schema is also documented in the doxygen [http://www.cuymedia.net/mythtv-trunk/group__db__schema.html developer documentation], and an [http://code.mythtv.org/doxygen/group__db__schema.html auto-updated version]. |
[[Category:Developer Documentation]] | [[Category:Developer Documentation]] | ||
[[Category:MySQL]] | [[Category:MySQL]] | ||
Revision as of 13:31, 27 February 2011
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.
Subcategories
This category has the following 9 subcategories, out of 9 total.
M
U
Pages in category "DB Table"
The following 67 pages are in this category, out of 67 total.
