Database Schema
From MythTV Official Wiki
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
- inputgroup
- inuseprograms table
- jobqueue table
- jumppoints table
- keybindings table
- keyword table
- mamemetadata table
- mamesettings table
- music_albums table
- music_artists table
- music_genres table
- music_playlists table
- music_songs table
- music_stats table
- music_smartplaylists table
- music_smartplaylist_categories table
- music_smartplaylist_items table
- musicmetadata table
- musicplaylist table
- mythlog table
- mythweb_sessions table
- neskeyword table
- nestitle table
- networkiconmap table
- newssites table
- oldfind table
- oldprogram table
- oldrecorded table
- people table
- phonecallhistory table
- phonedirectory 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
- snessettings table
- storagegroup 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