|
|
| (2 intermediate revisions by the same user not shown) |
| Line 1: |
Line 1: |
| − | ==Structure==
| + | #REDIRECT [[:Category:DB_Table]] |
| − | 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'';
| |
| − | <!--
| |
| − | | |
| − | 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==
| |
| − | 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 [http://www.cuymedia.net/mythtv-trunk/group__db__schema.html developer documentation].
| |
| − | | |
| − | Please place new table articles in [[:Category:DB Table]].
| |
| − | | |
| − | * [[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]]
| |
| − | * [[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]]
| |
| − | <!-- * [[recordoverride table]] -->
| |
| − | * [[recordmatch table]]
| |
| − | * [[romdb table]]
| |
| − | * [[schemalock table]]
| |
| − | * [[settings table]]
| |
| − | * [[snessettings table]]
| |
| − | * [[storagegroup 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]]
| |
| | | | |
| | [[Category:Developer Documentation]] | | [[Category:Developer Documentation]] |
| | [[Category:MySQL]] | | [[Category:MySQL]] |
