<div dir="ltr">Hello, Mike<div><br><div>1. Do you see foreign keys in other tools?</div><div>I've installed Wordpress and foreign keys are not defined at all.</div></div><div><br></div><div>2. Double-click a dotted link line to open an editor, on the right pane you can select `comment_id` field to define it as a foreign key field.</div>
<div><br></div><div>--</div><div>Best regards,</div><div>Sergey Pashkov.</div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Sun, Mar 16, 2014 at 11:08 AM, Pretzlaw <span dir="ltr"><<a href="mailto:pretzlaw@googlemail.com" target="_blank">pretzlaw@googlemail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
<div>
<p style="margin:1.2em 0px!important">Hello everyone,</p>
<p style="margin:1.2em 0px!important">I like VStudio because
it is much faster than the MySql Workbench with almost the same
capabilities.</p>
<p style="margin:1.2em 0px!important">Today I wanted to create
a database diagram. Unfortunately VStudio doesn’t seem to look
up the existing foreign key, so I add relations by hand. Now I
came up with something like this:</p>
<p style="margin:1.2em 0px!important"><img src="cid:part1.00070903.08040908@gmail.com" alt=""></p>
<p style="margin:1.2em 0px!important">The type of connection
is shown 1:n and it’s bound to the primary key but as I edit the
script of this link:</p>
<pre style="font-size:0.85em;font-family:Consolas,Inconsolata,Courier,monospace;font-size:1em;line-height:1.2em;margin:1.2em 0px"><code style="font-size:0.85em;font-family:Consolas,Inconsolata,Courier,monospace;margin:0px 0.15em;padding:0px 0.3em;white-space:pre-wrap;border:1px solid rgb(234,234,234);background-color:rgb(248,248,248);border-radius:3px 3px 3px 3px;display:inline;white-space:pre-wrap;overflow:auto;border-radius:3px 3px 3px 3px;border:1px solid rgb(204,204,204);padding:0.5em 0.7em;display:block!important;display:block;padding:0.5em;color:rgb(51,51,51);background:none repeat scroll 0% 0% rgb(248,248,255)">-- CREATE LINK "lnk_wp_comments_wp_commentmeta" ----------------
ALTER TABLE `wp_commentmeta`
ADD CONSTRAINT `lnk_wp_comments_wp_commentmeta`
FOREIGN KEY ( )
REFERENCES `wp_comments`( `comment_ID` )
ON DELETE Cascade
ON UPDATE Cascade;
-- -------------------------------------------------------------
</code></pre>
<p style="margin:1.2em 0px!important">the foreign key is
missing.</p>
<p style="margin:1.2em 0px!important"><strong>How do I add the
foreign key in the diagram view?</strong><br>
I want it to be <code style="font-size:0.85em;font-family:Consolas,Inconsolata,Courier,monospace;margin:0px 0.15em;padding:0px 0.3em;white-space:pre-wrap;border:1px solid rgb(234,234,234);background-color:rgb(248,248,248);border-radius:3px 3px 3px 3px;display:inline">comment_id</code>
in the wp_commentmeta table.</p>
<p style="margin:1.2em 0px!important">Thanks in advance!</p>
<p style="margin:1.2em 0px!important">Cheers,</p>
<p style="margin:1.2em 0px!important">Mike</p>
</div>
</div>
<br>_______________________________________________<br>
Valentina-studio mailing list<br>
<a href="mailto:Valentina-studio@lists.macserve.net">Valentina-studio@lists.macserve.net</a><br>
<a href="http://lists.macserve.net/mailman/listinfo/valentina-studio" target="_blank">http://lists.macserve.net/mailman/listinfo/valentina-studio</a><br>
<br></blockquote></div><br></div>