[mythtv] database schema
steve.p.daniels at googlemail.com
Sun May 13 21:13:02 UTC 2007
> Patrick Reynolds a écrit :
>> On Sun, 13 May 2007, wad wrote:
>>> I'm looking for a diagram of the mythconverg database. I need it in
>>> order to to a presentation of MythTV. Is that available or does anyone
>>> know how can I make it ?
>> mysqldump -u root -d mythconverg
>> It's 770 fields in 80 tables, at least on my system. I'm not sure what
>> kind of diagram you hope to get.
> In fact it's more a conceptual diagram I hope, like a Merise
> representation :d
> therefore, mysqldump is a good idea, but I prefer the use of phpmyadmin
> for things like that :D
Re: my last post on MySQL Workbench, you'll want to load it up, and go
to the Database menu, then go to "Reverse Engineering", fill in your
database details, and keep clicking next selecting all the bits and bobs.
At the end of it, you'll have all 80 odd table shown in the screen, you
can drag and drop these round the screen, clicking the arrow at the top
right of each table will show it's contents. Then it's up to you to
somehow order them, move em round etc. till it looks pretty. If you
manage it, I would be *very* interested in seeing the final, pretty result.
More information about the mythtv-dev