|
|
| (23 intermediate revisions by 12 users not shown) |
| Line 1: |
Line 1: |
| − | ==Conventions==
| + | #REDIRECT [[:Category:DB_Table]] |
| − | This section is for the layouts and internal detail of the tables Myth stores in your database engine; either [http://www.mysql.com/ MySQL] or (hopefully sometime soon) [http://www.postgresql.org/ 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.
| + | [[Category:Developer Documentation]] |
| − | ===History===
| + | [[Category:MySQL]] |
| − | 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 [http://www.phpmyadmin.net phpMyAdmin].
| |
| − | | |
| − | ==mythconverg database==
| |
| − | | |
| − | ===SQL===
| |
| − | 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''
| |
| − | <!--
| |
| − | | |
| − | note to contributors: I've commented out a few tables that don't exist in my setup. These may be obsolete or they may be created by components I'm not using at present.
| |
| − | | |
| − | -->
| |
| − | ===Tables===
| |
| − | Tables within the mythconverg database at schema 1123, MythTV 0.19
| |
| − | | |
| − | * [[callsignnetworkmap table]]
| |
| − | * [[capturecard table]]
| |
| − | * [[cardinput table]]
| |
| − | * [[channel table]]
| |
| − | * [[codecparams table]]
| |
| − | <!-- * [[conflictresolutionany table]]
| |
| − | * [[conflictresolutionoverride table]]
| |
| − | * [[conflictresolutionsingle table]] -->
| |
| − | * [[credits table]]
| |
| − | * [[dtv_multiplex table]]
| |
| − | * [[dtv_privatetypes table]]
| |
| − | * [[dvdinput table]]
| |
| − | * [[dvdtranscode table]]
| |
| − | <!-- * [[dvb_channel table]]
| |
| − | * [[dvb_pids table]]
| |
| − | * [[dvb_sat table]]
| |
| − | * [[dvb_signal_quality 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]]
| |
| − | <!-- * [[recordoverride table]] -->
| |
| − | * [[recordmatch table]]
| |
| − | * [[romdb table]]
| |
| − | * [[schemalock table]]
| |
| − | * [[settings table]]
| |
| − | * [[smartplaylist table]]
| |
| − | * [[smartplaylistcategory table]]
| |
| − | * [[smartplaylistitem table]]
| |
| − | * [[snessettings table]]
| |
| − | <!-- * [[transcoding table]] -->
| |
| − | * [[tvchain table]]
| |
| − | * [[videobookmarks table]]
| |
| − | * [[videocategory table]]
| |
| − | <!-- * [[videocountry table]] -->
| |
| − | * [[videogenre table]]
| |
| − | * [[videometadata table]]
| |
| − | * [[videometadatacountry table]]
| |
| − | * [[videometadatagenre table]]
| |
| − | * [[videosource table]]
| |
| − | * [[videotypes table]]
| |
| − | * [[websites table]]
| |
| − | * [[xvmc_buffer_settings table]]
| |
