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 thesame.
Please comment. -- Ashutosh DhundharaHi,
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`);