Difference between revisions of "Database Schema"
From MythTV Official Wiki
(Reformat) |
(table namespace change to avoid clashes with regular Wiki words) |
||
| Line 19: | Line 19: | ||
Try [http://www.phpmyadmin.net phpMyAdmin]. | Try [http://www.phpmyadmin.net phpMyAdmin]. | ||
| − | ==mythconverg | + | ==mythconverg database== |
<!-- | <!-- | ||
| Line 27: | Line 27: | ||
Tables within the mythconverg database at schema 1123, MythTV 0.19 | Tables within the mythconverg database at schema 1123, MythTV 0.19 | ||
| − | * [[callsignnetworkmap]] | + | * [[callsignnetworkmap table]] |
| − | * [[capturecard]] | + | * [[capturecard table]] |
| − | * [[cardinput]] | + | * [[cardinput table]] |
| − | * [[channel]] | + | * [[channel table]] |
| − | * [[codecparams]] | + | * [[codecparams table]] |
| − | <!-- * [[conflictresolutionany]] | + | <!-- * [[conflictresolutionany table]] |
| − | * [[conflictresolutionoverride]] | + | * [[conflictresolutionoverride table]] |
| − | * [[conflictresolutionsingle]] --> | + | * [[conflictresolutionsingle table]] --> |
| − | * [[credits]] | + | * [[credits table]] |
| − | * [[dtv_multiplex]] | + | * [[dtv_multiplex table]] |
| − | * [[dtv_privatetypes]] | + | * [[dtv_privatetypes table]] |
| − | * [[dvdinput]] | + | * [[dvdinput table]] |
| − | * [[dvdtranscode]] | + | * [[dvdtranscode table]] |
| − | <!-- * [[dvb_channel]] | + | <!-- * [[dvb_channel table]] |
| − | * [[dvb_pids]] | + | * [[dvb_pids table]] |
| − | * [[dvb_sat]] | + | * [[dvb_sat table]] |
| − | * [[dvb_signal_quality]] --> | + | * [[dvb_signal_quality table]] --> |
| − | * [[favorites]] | + | * [[favorites table]] |
| − | * [[filemarkup]] | + | * [[filemarkup table]] |
| − | * [[gallerymetadata]] | + | * [[gallerymetadata table]] |
| − | * [[gameplayers]] | + | * [[gameplayers table]] |
| − | * [[housekeeping]] | + | * [[housekeeping table]] |
| − | * [[inuseprograms]] | + | * [[inuseprograms table]] |
| − | * [[jobqueue]] | + | * [[jobqueue table]] |
| − | * [[jumppoints]] | + | * [[jumppoints table]] |
| − | * [[keybindings]] | + | * [[keybindings table]] |
| − | * [[keyword]] | + | * [[keyword table]] |
| − | * [[mamemetadata]] | + | * [[mamemetadata table]] |
| − | * [[mamesettings]] | + | * [[mamesettings table]] |
| − | * [[musicmetadata]] | + | * [[musicmetadata table]] |
| − | * [[musicplaylist]] | + | * [[musicplaylist table]] |
| − | * [[mythlog]] | + | * [[mythlog table]] |
| − | * [[mythweb_sessions]] | + | * [[mythweb_sessions table]] |
| − | * [[neskeyword]] | + | * [[neskeyword table]] |
| − | * [[nestitle]] | + | * [[nestitle table]] |
| − | * [[networkiconmap]] | + | * [[networkiconmap table]] |
| − | * [[newsites]] | + | * [[newsites table]] |
| − | * [[oldfind]] | + | * [[oldfind table]] |
| − | * [[oldprogram]] | + | * [[oldprogram table]] |
| − | * [[oldrecorded]] | + | * [[oldrecorded table]] |
| − | * [[people]] | + | * [[people table]] |
| − | * [[phonecallhistory]] | + | * [[phonecallhistory table]] |
| − | * [[phonecalldirectory]] | + | * [[phonecalldirectory table]] |
| − | * [[pidcache]] | + | * [[pidcache table]] |
| − | * [[playgroup]] | + | * [[playgroup table]] |
| − | * [[profilegroups]] | + | * [[profilegroups table]] |
| − | * [[program]] | + | * [[program table]] |
| − | * [[programgenres]] | + | * [[programgenres table]] |
| − | * [[programrating]] | + | * [[programrating table]] |
| − | * [[recgrouppassword]] | + | * [[recgrouppassword table]] |
| − | * [[record]] | + | * [[record table]] |
| − | * [[recorded]] | + | * [[recorded table]] |
| − | * [[recordedcredits]] | + | * [[recordedcredits table]] |
| − | * [[recordedmarkup]] | + | * [[recordedmarkup table]] |
| − | * [[recordedprogram]] | + | * [[recordedprogram table]] |
| − | * [[recordedrating]] | + | * [[recordedrating table]] |
| − | * [[recordingprofiles]] | + | * [[recordingprofiles table]] |
| − | <!-- * [[recordoverride]] --> | + | <!-- * [[recordoverride table]] --> |
| − | * [[recordmatch]] | + | * [[recordmatch table]] |
| − | * [[romdb]] | + | * [[romdb table]] |
| − | * [[schemalock]] | + | * [[schemalock table]] |
| − | * [[settings]] | + | * [[settings table]] |
| − | * [[smartplaylist]] | + | * [[smartplaylist table]] |
| − | * [[smartplaylistcategory]] | + | * [[smartplaylistcategory table]] |
| − | * [[smartplaylistitem]] | + | * [[smartplaylistitem table]] |
| − | * [[snessettings]] | + | * [[snessettings table]] |
| − | <!-- * [[transcoding]] --> | + | <!-- * [[transcoding table]] --> |
| − | * [[tvchain]] | + | * [[tvchain table]] |
| − | * [[videobookmarks]] | + | * [[videobookmarks table]] |
| − | * [[videocategory]] | + | * [[videocategory table]] |
| − | <!-- * [[videocountry]] --> | + | <!-- * [[videocountry table]] --> |
| − | * [[videogenre]] | + | * [[videogenre table]] |
| − | * [[videometadata]] | + | * [[videometadata table]] |
| − | * [[videometadatacountry]] | + | * [[videometadatacountry table]] |
| − | * [[videometadatagenre]] | + | * [[videometadatagenre table]] |
| − | * [[videosource]] | + | * [[videosource table]] |
| − | * [[videotypes]] | + | * [[videotypes table]] |
| − | * [[websites]] | + | * [[websites table]] |
| − | * [[xvmc_buffer_settings]] | + | * [[xvmc_buffer_settings table]] |
Revision as of 16:59, 28 February 2006
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
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
