Database Schema

Conventions

This section is for the layouts and internal detail of the tables Myth stores in your database engine; either MySQL or (hopefully sometime soon) PostgreSQL.

There will be one page for each table; it will list each field, what it does, it's domain, and what other tables link to it, as well as a paragraph at the top explaining the semantics. Hopefully, the development team will help out on this one; inferring database semantics is a mug's game, at best.

History

Thanks to Kevin Kuphal for doing the original keying of this stuff, so that all I had to do was copy, paste, and annotate.

Interfaces

command line

Use the mysql command on the host running the database:

% mysql -u mythtv -pmythtv mythconverg

SQL commands can be issued at the mysql> prompt.

Web

Try phpMyAdmin.

mythconverg database

Structure

Use the following SQL to list all of the table names 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

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