From: Johan De Meersman Date: April 8 2011 11:07pm Subject: Re: Any table visualization tools with wires connecting the actual columns? List-Archive: http://lists.mysql.com/mysql/224796 Message-Id: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="=_07a0c243-8970-481a-876a-24a8b9169aa2" --=_07a0c243-8970-481a-876a-24a8b9169aa2 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit ----- Original Message ----- > From: "Daevid Vincent" > > It only seems to do the lines for InnoDB tables, not MyISAM... I > mean, it not only won't auto-connect them, it won't even allow ME to connect > them. :( Probably because it wants to adhere to the engine capabilities, and MyISAM doesn't have referential integrity. MySQL Workbench seems to do it right, though. It may or may not complain at apply time, but it does seem to save the relations you set, even for MyISAM tables. See attached file as example :-) The tool is freely downloadable from the MySQL site. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel --=_07a0c243-8970-481a-876a-24a8b9169aa2 Content-Type: application/zip; name=test.mwb Content-Disposition: attachment; filename=test.mwb Content-Transfer-Encoding: base64 UEsDBBQAAAAIAK4IiT4DmWVShxIAALnkAAAQAAAAZG9jdW1lbnQubXdiLnhtbO1dW3PbOJZ+71+h 0rzM1m4U3i9biad8S8Y7vmRtp6f7yQWCoMw2L2qQjK3+9QOQlERZFAmCsC1HzEPKpM2Dg4Pv3IAD 4NM/nsJg9APhxI+jz2N5Io3/cfDLJxekYDTF6Z0X4xCkn8cK+cXIjWEWoii9S+cz9Hl8Mb/5//PR v2P84KAI3o8uYhcF4yoxbSKPD34ZjT79AEGGRsVnsfMHgul4lKQ4g+mHCITk5eOCyuSkbGQ88t3P Y0+RTNN0wQdDUdUPsoykDwAqxgdJkoHmWLKkKc6SFLxH8CHJws9j6cmUVdnxbDtvvxsHQTz1IQgm ZX9KNhxNk1FnNjxNUSTVJMJ7QPPP45J0QbngbMnb3SzFd/Qb4NqOrZBPCm4DPyG8wjhKiVQ+rPdg 8balJyc+mGIQlky4xVMy/riVA0d3PXfJgevTtvJvYZakcXhC4NH4NZIUi5v/kEpncgHwA8Jls2H+ kLS0qVs1HMezlKBx89PiD0nDfjQt/5Q2Pz749DH/g+WfB3700AScrzi9Kt8XDT5GhO8DFuR++kiJ lwitNrsJCcOVNBGQuCLq+cNHj99ARMFdcFx9t5TUBg9IQoosgofZ/TypaljOxOJl/i4Z145Wi+I+ p7vQXMf0uhsQBCXDVky45ISFF9eZhPPkz2ByTDSEaN+CB1lRDFXqzIOlAFfVDGOhfCXRFUe1imBr kF/5lj04j6df/AB9xXE2W1mv5auKQm1jQ9cEsHFD5BGCkoEkfyC2p9p0p3FZkCuHRXMlz+g8LARS RMaK8oyNOpWRVckVIIXrOEv9aG0wcOXVs8GotyDAVJE4Vta5YGRAU0UgAv2ZEXVfcJCUj6ws2JIA FvK3GUYu9YT0ywUzy1/ckpesLCERLM2jOJovXHxSPDEyoKsCGLgFTrAQQ0p/TjbUo5OmlvSookqm reimCqmial0UlfxaUm3NqOGkKQ4AP6bX8eM5iqbp/UY8sJWEHy2DpJKF8YHU/vFyJEiAaUFTgIIc x0EWRgte8oekVgLdPFpJlQ6IrCsQObZRGRDbkWSGqNxSHV221C3sbJUoyNL4LIIY5ZnBgdwg1uah hfcAA5gifIPSy7pwr3WUDAd5/RzbMRXIMYlJUwyeg2ZTYRn6FAcBoEFulw7V0HFLW3b6NAt86Kff QJ4l9CCIPJAF6a/0993IrMRSpXGWXGZB0KxV9WNmW0az71vj2wvAlHUkVpz6yWWcFgzKfH0NSovz gR/fRQqTJfjOd/mYmGEEfZrAd+VjRSIhMThi+bwttSLKcuOHswA9d7P5S+pixwcwDksLhV0nTMqf F1ieEK6qWVY3vQoLc8M9GnHgsukkZ47J4hibet/IFqdvUHTFMA0dvpVvkN7SNwDHk6TBN7wn32Aq lmO/H9+g6T19A/1/8AzEM/wAmGr84B04vANrTvRMYlFEmCQAuileH3CRKbX+uIu1bqfGbCe32qIA zP+F5v/Gfoq6JX7A02UkYsruS4yRP40IFwtjtXwhIAGsUqeOHhiGYskQdHf0ErA8qEnjPtq/OemA kYcwnQlyi7cHKtRdCF3Ai//6FF3x+iV/7Mn5FlEcsGTfLf3idbcIA8cP/HTeJ84iqoJSdJ3RMbq8 Gh0e355dXfKxFIKI2PMYz7n9KqHQ42O6znAVBSziYMB0Fc2CbHhdkGq4jiEOwyu1O+ZCs2EqwNB1 7bXRvOL7ghNEa6DOZoRGH1ALDi6KYM97uMsShO+Ai1GSoKR/rNKJYq8IouIfVRl5AvzjWeSip0VE Hrk+RALcYkk0nxY1VM9RXK2zR1Ql27E0E4zZHZFDfK8kSCRdfVJH4azNHFMRQY7ZAYMuoDoqbOBr +3x8zsBiPr/NUovRzEY/mkAUuYycMPiNRnssIl7gKJsQmciw6FVbB9osH69h9CnC/+XT4eTzQ+S/ oyCGDzf+X6hPVPXop/ffAE6owF7X74iPEHOhFkn8t+uzi8Pr3/n48ZNv2A9BP89ewLsXH1nk/5n1 Gt2l/2Xk4yeZMgjB03X8mHDm9iHCU3QWEZVI+1D4HuVzXnwE/KhHByL0lB4W09ucFGYAPhTpf/cp jRnAqU/nRI7jrG1mvS5m8ywBMdu3BRMnyPOj/Kfn7K1+s2Vitkk8JY3TpxmNZ/kHekmpMFucNJLk McbNroR9cqQa7s4KO0gnb3q60+3sY+C7x/dZVLoyLhEsaSQ9CPQYAhw/fslLnnkUJskcDp2p4aJK qDcyq8R6SCav6aGz7Sc+7kPiNJrS8rGDi/nZzeEFP50c3Yy8rJslRYBZusX+dLosT06LJxbzUw1O btLM6QCRtU/nSYpCzo9vUTiLcR4W8eEzXRC4gfGMa7q8DDSRe5VxawnECKQUkoQDRZKJAdM+SPZI kv9X6uSqHA3JwGIsdmdjLQAJXaCIpvXsKd0FxjjV2F4ZgjD3kN8R5HOqPkti0W+ljL9Ov70KeJs3 3MoOX50jy4LFT1DnKCNZ1UVMXr18oaOmO5ahmdI+FjpasmvpQzHLuypm0R3NaK4m/7kKHYE7FDru Q6Fj36X8lyh0ZFm4/FkLHYEGSRcH3/CefAOQNVOR9qfQcSiC359Sx530D46qSZK5l/7BRMB0h9zh XfkHS3OR+oqF8NIb+weaO5DXCKWDjxh8xNv4CNPUiNp5yn5ullKHHOK95RA2cKU98xGzOElh7A6b pgYv8VZewrFMIO9nJqERszWsQrwzL2Hp5r55CTKA88FDDB7ijTwEcqEiO9JerkVAzQODh3hfc00O MG1pzzwErQjFg5MYnMRw9sLOnL3gkJHxkP7Shy98ZC2Mk5H7Dja65mVx0JZeYaOrCXVVf4cbXamI TKk4MXzY6Po6G11ZqjV3eqMri14NG12Hja7DRtefLT4bNrq+042uNICUXGXY6bqLO137+dNhp+uw 0/Xd7nTN7ZIn5GD/YavrLm91VbqCAnrSa+511d5sryvDEWXDflcR+123va67asQQYJF+9dFj2Sl6 bdX2W066zGDSKchIbu4K8xxmQewueUSun9zfQZ+FbleTwWYuOgxOfk9dJ8vAbRWkbgJhsAht1iCc u07nT1utAL8F4Nf+Hprfeg1ZnebXsFH3avMGMAeI2OV9g/APhM8JW8sbnxYv2i8hc4BjCbrbKCEp 5voFR/RFGwuGCqHes8p1ZapqFs2fT2DXnbFavxpHqSQonTj+VK8d986UXAQtMZTgzNIlMaTuZ4J4 eoh9C4shtXA2wmgpYmgRh2WKoQQS6PtiSGV/+Img7gmjdI8cjB7F0Er9xFAEgR1l8AGLg3smhtTU UVRZEESnGKEHUUZGVkRZmanzIFCddVFKGFI1FGT/stQTRQkmijA/YRiC8I7mjjC+QgAhEkYKxyGI xDlWRSBSTYGqKAukZQikJaiPjh8BWv8lxNygOEldYcGWrSrC/M8fs7DGybJlDHblelaGFFRMoZKA AiWmmrnqTcYl5fId56RMrQD7HZR/Ha/uU4kDxJJg9btLoqGScPGSP8NZ1hsSQzXfckAOB7UkBEEg jlyIXD8LxdETR4lkhuKIeUEMRNFy44wk4KKIIeiTERVEbVtdKwephipZrsHs736qrAmlRxU0RU+i 8CGQVKGdAgkGcTQV2VUiOSeIHVEoEUeqkJxAglRyAsnRC3tSP0QCyQkbU2FczZEwA0K5SlIQzgTR IzFsiFJhJmQWi/NVMMM/RI0A+QIVUaVAggJJASyQtyTDHoBI2JAG82kcCcYb3Z5V7IUQZehIJO+L hF9OUCQGc4LCgZhTFTvipShFDrvjixoWFGWhKD1BKW+O7DhSr4zre4Lws3wrq7zayLZYNkGs06T7 H+r7TxtaDUwcB7VbICxbcTykbl4Qyr01DcA0AwHT1rSGVLFpqqDYoth9sZe0Xan3PLg9u/z97PL2 7/J/cS5zH11dne/uuvFLwwmBaEDUCyDq9PByP0Hl+U/I3T1INUxZvAKkTk6Pzy4Oz/8uS/8j8aLq y9lvpyd7iik6EabtHqi2TtC9AqS+nF8d3vJCiX6r7TGWrB00UFsnaF/DPl19Pzo/7YMmaz/RRKIU eYif6uMnjdfTkY/lvYWTsntwalq9ewU83ZDI6ZwCyugBKGVvAaXuHqAa129fAVEXpydn3y8opOwe kFL3FlI7GIq/HZjyqQK5B460vcXRDobh2ws4XgFKR2dfKZoUqQea9jcQR/me28EwCTNMp19Pr/cT TbRuYlmws6vx07bCjlcLoI7Or4440XV+dfl19Ovh9dHZ5fYja/YDZLRgbVchtq3q6tUgdnv6221P iB3/83CPrdiArJdB1n4iKvRdN0D5LvNhTkH4nMLF2cnJ+SkhsZ/girIQYR8Oa8fi144vv1+cXp8d 7yeuyPANmBKPKUJjP/G0PEti91C1/Yj4F4cUDbP5S6bo14fHt7s838Baa6r2rjWt1JgmrNs3mw7P aRN+ubWy05dNR+7wD5bkOKYHugzWRvMsJ/pfxikoUAtx/Jh4cZxuo7M6CU5C0ND6nc4zDdPJ8ZKL DbbWBruufbPHWWCPMX5wUATvJ7P7eeJDEExOfDDFIFxssC2e1quZ261oE11qUD1DMxzDbNyoW2tI FVWBiqZqTdXVlQPAgjhBWw9O3zy7y1ENi1+Y+elazUPZaAFZJVltgQoTGIZiQQd0PiPfdgByoK3U nJHfoDBgVmiJ93BHjdFd6/mAa7QwAsE6pd+uPI9IRpqg/5YkXiK/dyfS8aDBbQygyD0W0ZEVnb59 QU8pBseLYerOSOXznl2qUGLsFEM41HBDyPgg1wUZAp6jird1o5jfuEFTihDaDZRyiyRJAU6FCLdK iQMxlUP4MXi8mQV+46mqrQNTGL8v/jTDaIXo8jk/J941oMFzTjxP07lwFo1Lpq0YCgIv2Pi601xE LgxOjgmLq7H64Se+Q6+fkjnsQuO9G/UesjWHenbORwKx32R3amJjCal9Xe7a0Hv5gyBXm59YuCBP fS0Lluqv7HFkDUHojJnHurxY5/RpBiKXRjFyV82uXJ20otLZPpQ3H/Xgg4ggBNj/C534ySwA88bb 01hcQD4s1TMkCyXXTRVyKXk924szujvL7vkthjExBn+zraMvJ4ddRYe6Sr3iIe7J4N8Tqy5PJJ04 BqWvcT8H82UaGuQ/FybOcq3eJq7CdoA8wrQyUVuY3nLXYAwfuGAegigDwY3/V36tW3d/nMYzKuou XFe+fvRdeteUPFGEDNU78kc0h+A6ELunJWcJSX52Sy7toiXvc6fQT2/JDevdWXJjImnv0ZKTMK+X JTf2zZK3TARxZhi1aqBakq1Lq3+arpmaqeqSZRHRaLJs2bqpy7auyrlDVdmyEcMl3/TNRjaUa+Ni hTZBnp5ej8pxZ+Pbk73K3d2VEx/jWe0tV4zYu6D/95+N5/bZpSSXE8Yt5qnWW8uurEHyJ8vTGOO0 INvlCoLc7nPcadGWDtfeH+EaxqskxPUHrgieLOkx89NFYk5fiX3FcTYrBTalP7fdhvKCZqnNoTZO 823aBsNRoCXQpiWZc15r1lo8Kgvb272pbSpNAnsTZ8rrSrmm6Fjn0wy19xLW2jJsgspTvhq9WOXu 0hk9we+oOXrrNdzbPn5qxNi2r+ZcX/0VxyHlc8uHmwvH7CvShb1erUYvHePHbUvyNSggf8qv819x epOSjNMlTCy8SER+XF+KZrlWkq5tX9OalIX7zX+uL1jZWMSvuQPGkfudkpz74wWw84fG5fW8SaOX INd0KQXTY6Ic0xj7zxxyneukp1lDV9JEVD6sd6nHZT4hSgHJ2lc3K067oaLOEMMMY9LQ4iWXRa6t jFjdJ9t6Cnrt973DiguAH5aOM8wfmgHn6IptMUbynd1IjxIc0zTdDkH/WtPrDzU5F6HPNE7tSQSY zSYnMczoSu1Z5MVl8kD4J1x2Tx4cB5iWRLWlnD8jFJdd3Cp9kKX3NGH4v/geRKMTNLpAZNjzqyfW BoShxuISPY7yLIz5U+p8iwvj3I3b4vRuVPLb79zWO+f4EqCGS41xXNg/Wko2ir1Reo9G5UtmIj+I xPNm5Qk7v+XN7TieIZz6GxMZr6U+dfrSgvlvYIpuUJqSviQrzJsQdq+wMl1omrZpLq+YrlCuFWG1 UgLgqR8dxWlaREeaZkjVf5auGLqsWIotK7IiKYpKUiRVo0+SrZo0JZKbRmujqfNyhpHQqP4zNI3Y fkNVZNm2ya8kUyKvVNMyjFVLUqeWrosc7zWauqXZ0gs0tF6qSUKQaBFizmKcYuCnXQFfQI9oy+2q MHm2fK6EeY/OJH+f1yMD7Zmz2FbhAgHNovRJp47V+r63V902Hnk5RK7mIRkwcrhs8tNHWh5+8Mt/ AFBLAwQUAAAACABiCIk+LXUr8vkBAAAAFAAACwAAAEBkYi9kYXRhLmRi7ZbPb5swFMftkDYSEueo yuUdk6lUQID8OC2LUmlapqRJurUnYoyjRgqhA5p2u6XS/qD9IbvuP9lthxlKpqTZJqTdFn9k4Nnv PeOvxQPGF/15zGAWhD6JoY6KCGP0EgAhbu5yzI/CVh+jnCjSDz7ZF1SIpK/4Ezf+hfV5sVS+vMTr ICbugtWp5VHqEdU26qaq60xTCTVsVdN0YrpNXTMNN0/MUXfU60x6MOm86vdgmidlCtWpM4UVCekN CU9halpu0zYb2lZSy9X0Z0lZfG29klIhj4NUiNZoGVajTv92xzwxxV0heVL2hOiWQZnbsnMJ4fGG ZdgN26L5hD++x6VypYI/H6XCr4bOcDToZpfCzvKzQVBkVYXJzTyCNAVoyEjMPHA/wiBiy3fzKCbj u+RBNjStmUZ3sxCPn9ugmWe6cZY4QTfbVqutNxS5qsiQspqze2dJfJZ0Jr2ryenGc0tC4jsLPv9z z8P4og8bdjwemzlp3p4nuI3/4KGB77Nl/JvZhqPXbzuja3jTu4ZfC95a8maopsg1tXBc7lQwmi89 9hB9WPANcchdHKR9J9tMR88MKalxJSlk6RviTSAQ/BdUcekEdbnhkyhmYcQWjMbwAmZh4EP2Ynhy yWn9f0e8CQSCQ0CWTvBT+ePk+7/3py8QCA4CUf8CweHyE1BLAQIAABQAAAAIAK4IiT4DmWVShxIA ALnkAAAQAAAAAAAAAAAAAAAAAAAAAABkb2N1bWVudC5td2IueG1sUEsBAgAAFAAAAAgAYgiJPi11 K/L5AQAAABQAAAsAAAAAAAAAAAAAAAAAtRIAAEBkYi9kYXRhLmRiUEsFBgAAAAACAAIAdwAAANcU AAAiAE15U1FMIFdvcmtiZW5jaCBNb2RlbCBhcmNoaXZlIDEuMAA= --=_07a0c243-8970-481a-876a-24a8b9169aa2--