Difference between revisions of "Database Schema"

From MythTV Official Wiki
Jump to: navigation, search
(move Database info to new Database article and cleanup)
Line 1: Line 1:
 
[[Category:Developer Documentation]]
 
[[Category:Developer Documentation]]
  
==Conventions==
+
=mythconverg database schema=
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.
+
==Structure==
===History===
+
Use the following SQL to list all of the tables in the mythconverg [[database]]:
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==
 
 
 
===Structure===
 
Use the following SQL to list all of the table names in the mythconverg database:
 
 
  SHOW tables
 
  SHOW tables
  
Line 38: Line 18:
 
-->
 
-->
  
===Tables===
+
==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.