Difference between revisions of "Database Schema"

Revision as of 20:52, 14 November 2007

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
• 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