Difference between revisions of "Database Schema"
From MythTV Official Wiki
(move Database info to new Database article and cleanup) |
|||
Line 1: | Line 1: | ||
[[Category:Developer Documentation]] | [[Category:Developer Documentation]] | ||
− | == | + | =mythconverg database schema= |
− | |||
− | + | ==Structure== | |
− | + | Use the following SQL to list all of the tables in the mythconverg [[database]]: | |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | Use the following SQL to list all of the | ||
SHOW tables | SHOW tables | ||
Line 38: | Line 18: | ||
--> | --> | ||
− | + | ==Tables== | |
− | Information about tables within the mythconverg database at schema 1123, MythTV 0.19 | + | Information about tables within the mythconverg [[database]] at schema 1123, MythTV 0.19 |
+ | |||
+ | Please place new table articles in [[:Category:DB Table]]. | ||
* [[callsignnetworkmap table]] | * [[callsignnetworkmap table]] |
Revision as of 14:16, 7 March 2006
mythconverg database schema
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
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
- 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