On Thu, Jul 24, 2014 at 5:32 PM, Marc Delisle <marc@infomarc.info> wrote:
Le 2014-07-23 22:39, Hugues Peccatte a écrit :
> 2014-07-23 20:22 GMT+02:00 Ashutosh Dhundhara
> <ashutoshdhundhara@yahoo.com <mailto:ashutoshdhundhara@yahoo.com>>:
>
>     Hi,
>
>     This is in regards with RFE #919
>     <http://sourceforge.net/p/phpmyadmin/feature-requests/919/> (Multiple-column
>     foreign key relation). I was trying to figure out the UI for this by
>     modifying the existing one. I have attached a screenshot for the same.
>     Please comment.
>
>     --
>     Ashutosh Dhundhara
>
>
> Hi,
>
> This is nice.
> IMO the constraint name should be displayed as a title, and not
> displayed in the bottom-right corner, so you will see it easily.
> Maybe, you can reduce table rows height, by displaying the ON UPDATE and
> DELETE on the same line.
>
> Hugues.

Hi Ashutosh,
somehow I missed your initial email but saw the screenshot in the archives.

The UI you are proposing does not work, in my opinion. On the left side,
you are proposing multiple columns, but the feature request is about
having, on the left side, one column, and on the foreign key constraint
side (right), multiple columns.

Hi Marc,

can you please quote an example of this case?

Are you talking about a case like this: 

Lets say I have two tables `table_1` and `table_2` with two columns `id` and `value`. 
The query:
ALTER TABLE `table_2` ADD FOREIGN KEY (`id`) REFERENCES `table_1` (`id`, `value`);


--
Ashutosh Dhundhara