<html><body><div style="color:#000; background-color:#fff; font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:10pt"><div id="yiv6317128917"><div><div style="color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 10pt;"><div id="yiv6317128917yui_3_13_0_7_1396123829547_8">Yes Hugues, you are right. This problem is linked to : <span style="font-size: 10pt; font-family: 'Helvetica Neue', 'Segoe UI', Helvetica, Arial, 'Lucida Grande', sans-serif;"> </span><a rel="nofollow" shape="rect" target="_blank" href="https://sourceforge.net/p/phpmyadmin/feature-requests/919/" style="background-color: rgb(255, 255, 255); font-size: 10pt; color: rgb(25, 106, 212); font-family: 'Helvetica Neue', 'Segoe UI', Helvetica, Arial, 'Lucida Grande',
sans-serif;">https://sourceforge.net/p/phpmyadmin/feature-requests/919/</a></div><div id="yiv6317128917yui_3_13_0_7_1396123829547_8">This feature request is also a part of GSoC.</div><div id="yiv6317128917yui_3_13_0_7_1396123829547_8">Thanks.</div><div id="yiv6317128917yui_3_13_0_7_1396123829547_10"></div><div id="yiv6317128917yui_3_13_0_7_1396123829547_12"> </div><div id="yiv6317128917yui_3_13_0_7_1396123829547_14">Regards,
<br clear="none">Ashutosh Dhundhara</div><div class="yiv6317128917yqt4276450824" id="yiv6317128917yqt27680"><div class="yiv6317128917yahoo_quoted" id="yiv6317128917yui_3_13_0_7_1396123829547_16" style="display: block;"> <div class="yiv6317128917yui_3_13_0_1_1396123829547_5516" style="font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 10pt;"> <div class="yiv6317128917yui_3_13_0_1_1396123829547_5517" style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt;"> <div dir="ltr"> <font size="2" face="Arial"> On Saturday, 29 March 2014 9:56 PM, Hugues Peccatte <hugues.peccatte@gmail.com> wrote:<br clear="none"> </font> </div> <div class="yiv6317128917y_msg_container"><div id="yiv6317128917"><div><div dir="ltr"><div class="yiv6317128917gmail_extra"><div class="yiv6317128917gmail_quote">2014-03-28 12:48 GMT+01:00 Ashutosh Dhundhara <span dir="ltr"><<a rel="nofollow" shape="rect"
ymailto="mailto:ashutoshdhundhara@yahoo.com" target="_blank" href="mailto:ashutoshdhundhara@yahoo.com">ashutoshdhundhara@yahoo.com</a>></span>:<br clear="none">
<blockquote class="yiv6317128917gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex;"><div class="yiv6317128917yqt8476481909" id="yiv6317128917yqt26785"><div><div class="yiv6317128917yui_3_13_0_1_1396123829547_5520" style="font-size: 10pt; font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">
<div><span>Hello All,</span></div><div style="background-color:transparent;"><br clear="none"></div><div style="background-color:transparent;"><span><span style="white-space:pre-wrap;"> </span>I have a table `vb_test` having one column `id`. I applied two foreign key constraints over `vb_test`.`id` as follows: </span></div>
<div style="background-color:transparent;">1) <span style="white-space:pre-wrap;"> </span>a<span style="background-color:transparent;">lter table `vb_test`</span></div><div style="background-color:transparent;"><span style="white-space:pre-wrap;"> </span>add constraint fk1 foreign key(id) references parent_one(id);</div>
<div style="background-color:transparent;">2) <span> </span>a<span style="background-color:transparent;">lter table `vb_test`</span></div><div style="background-color:transparent;"><span style="white-space:pre-wrap;"> </span>add constraint fk2 foreign key(id) references parent_two(id);</div>
<div style="background-color:transparent;">Up to this, everything is fine.</div><div style="background-color:transparent;"><br clear="none"></div><div style="background-color:transparent;">Now when I switch to "Visual Builder" in QBE, I see only one line joining `vb_test`.`id` to `parent_one`.`id` in the diagram.</div>
<div style="background-color:transparent;">There is no link from <span style="font-size:10pt;">`vb_test`.`id` to `parent_two`.`id`.</span></div><div style="font-size:10pt;background-color:transparent;"><span style="font-size:10pt;">Is this an intended behavior or a bug ?</span></div>
<div></div><div> </div><div>Regards, <span class="yiv6317128917"><font color="#888888"><br clear="none">Ashutosh Dhundhara</font></span></div></div></div></div><br clear="none">------------------------------------------------------------------------------<br clear="none">
<br clear="none">_______________________________________________<br clear="none">
Phpmyadmin-devel mailing list<br clear="none">
<a rel="nofollow" shape="rect" ymailto="mailto:Phpmyadmin-devel@lists.sourceforge.net" target="_blank" href="mailto:Phpmyadmin-devel@lists.sourceforge.net">Phpmyadmin-devel@lists.sourceforge.net</a><br clear="none">
<a rel="nofollow" shape="rect" target="_blank" href="https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel">https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel</a><br clear="none">
<br clear="none"></blockquote></div><br clear="none"></div><div class="yiv6317128917gmail_extra">Hi,<div><br clear="none"></div><div>I think this is linked to this ticket: <a rel="nofollow" shape="rect" target="_blank" href="https://sourceforge.net/p/phpmyadmin/feature-requests/919/">https://sourceforge.net/p/phpmyadmin/feature-requests/919/</a></div>
<div>The problem is bigger than only having 2 FK on the same field, but also to have a FK on multiple fields.</div><div><br clear="none"></div><div>So I'm not sure that you need to create a new ticket.</div><div><br clear="none"></div><div>Hugues.</div>
</div></div></div></div><br clear="none"><br clear="none"></div> </div> </div> </div></div> </div></div></div></div></body></html>