Difference between revisions of "Database Schema"
From MythTV Official Wiki
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.
- callsignnetworkmap table
- capturecard table
- cardinput table
- channel table
- codecparams table
- credits table
- dtv_multiplex table
- dtv_privatetypes table
- dvdinput table
- dvdtranscode table
- favorites table
- filemarkup table
- gallerymetadata table
- gameplayers table
- housekeeping table
- inuseprograms table
- jobqueue table
- jumppoints table
- keybindings table
- keyword table
- mamemetadata table
- mamesettings table
- musicmetadata table
- musicplaylist table
- mythlog table
- mythweb_sessions table
- neskeyword table
- nestitle table
- networkiconmap table
- newsites table
- oldfind table
- oldprogram table
- oldrecorded table
- people table
- phonecallhistory table
- phonecalldirectory table
- pidcache table
- playgroup table
- profilegroups table
- program table
- programgenres table
- programrating table
- recgrouppassword table
- record table
- recorded table
- recordedcredits table
- recordedmarkup table
- recordedprogram table
- recordedrating table
- recordedseek table
- recordingprofiles table
- recordmatch table
- romdb table
- schemalock table
- settings table
- smartplaylist table
- smartplaylistcategory table
- smartplaylistitem table
- snessettings table
- tvchain table
- videobookmarks table
- videocategory table
- videogenre table
- videometadata table
- videometadatacountry table
- videometadatagenre table
- videosource table
- videotypes table
- websites table
- xvmc_buffer_settings table