[Phpmyadmin-devel] RFE #919

[Ashutosh Dhundhara]

On Thu, Jul 24, 2014 at 5:32 PM, Marc Delisle <marc at infomarc.info> wrote:

> Le 2014-07-23 22:39, Hugues Peccatte a écrit :
> > 2014-07-23 20:22 GMT+02:00 Ashutosh Dhundhara
> > <ashutoshdhundhara at yahoo.com <mailto:ashutoshdhundhara at 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.phpmyadmin.net/pipermail/developers/attachments/20140724/8ec72d99/attachment.html>