Would anyone be interested in a script that uses the GD library to draw a picture of foreign key constraints in their MySQL/Innodb database? I haven't been able to find anything free out there that does it.<br /><br />If so I'll share what I've done so far. If not I'll just keep it to myself <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/smile.gif" style="vertical-align:middle" emoid="
" border="0" alt="smile.gif" /> See it in action <a href="http://example.draconite.com" target="_blank">drawing the mess I've made</a>. Red dots are "parents" and blue dots are "children" in the relationships.<br /><br />l8r,<br />Nate<!--content-->
I'm not exactly sure what it does... but I like the fact that you're using the GD library... one of the more esoteric bells and whistles offered by TCH.<br /><br />Cool stuff.<br /><br />Thanks for posting your hard work.<!--content-->
Hi,<br /><br />Cool., maybe we should give it to London Underground so the map is a bit more easy!<br /><br />Nice though!<br /><br />Jim<!--content-->
<!--QuoteBegin-surefire+Jun 13 2003, 10:03 AM--><div class='quotetop'>QUOTE(surefire @ Jun 13 2003, 10:03 AM)</div><div class='quotemain'><!--QuoteEBegin-->I'm not exactly sure what it does... but I like the fact that you're using the GD library... one of the more esoteric bells and whistles offered by TCH.<br /><br />Cool stuff.<br /><br />Thanks for posting your hard work.<!--QuoteEnd--></div><!--QuoteEEnd--><br />Not sure what it does...? Well, each box represents a table in the MySQL database, and each line represents a foreign key contraint for the table. So basically all it does is give a graphical representation of foreign key definitions. <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/smile.gif" style="vertical-align:middle" emoid="" border="0" alt="smile.gif" /><br /><br />GD is pretty spiffy. <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/biggrin.gif" style="vertical-align:middle" emoid="
" border="0" alt="biggrin.gif" /><br /><br />l8r,<br /><br />Nate<!--content-->
" border="0" alt="smile.gif" /> See it in action <a href="http://example.draconite.com" target="_blank">drawing the mess I've made</a>. Red dots are "parents" and blue dots are "children" in the relationships.<br /><br />l8r,<br />Nate<!--content-->I'm not exactly sure what it does... but I like the fact that you're using the GD library... one of the more esoteric bells and whistles offered by TCH.<br /><br />Cool stuff.<br /><br />Thanks for posting your hard work.<!--content-->
Hi,<br /><br />Cool., maybe we should give it to London Underground so the map is a bit more easy!<br /><br />Nice though!<br /><br />Jim<!--content-->
<!--QuoteBegin-surefire+Jun 13 2003, 10:03 AM--><div class='quotetop'>QUOTE(surefire @ Jun 13 2003, 10:03 AM)</div><div class='quotemain'><!--QuoteEBegin-->I'm not exactly sure what it does... but I like the fact that you're using the GD library... one of the more esoteric bells and whistles offered by TCH.<br /><br />Cool stuff.<br /><br />Thanks for posting your hard work.<!--QuoteEnd--></div><!--QuoteEEnd--><br />Not sure what it does...? Well, each box represents a table in the MySQL database, and each line represents a foreign key contraint for the table. So basically all it does is give a graphical representation of foreign key definitions. <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/smile.gif" style="vertical-align:middle" emoid="
" border="0" alt="smile.gif" /><br /><br />GD is pretty spiffy. <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/biggrin.gif" style="vertical-align:middle" emoid="" border="0" alt="biggrin.gif" /><br /><br />l8r,<br /><br />Nate<!--content-->