Menu

#1579 (ok 4.4) Default to primary key when adding relation

Next_release
fixed
None
Low
2015-04-20
2014-12-12
No

Could you default to the primary key of the foreign table when a foreign table is selected?

Discussion

  • Hugues Peccatte

    Hugues Peccatte - 2014-12-15

    I sent a PR for this ticket: https://github.com/phpmyadmin/phpmyadmin/pull/1428
    This manage the first case: PK with one column. An other improvement could be to manage a PK with many columns.

     
    • Madhura Jayaratne

      I feel that this doesn't make much sense for PKs with multiple columns. For instance, the user may have chosen a single column from "Column" field and if the chosen foreign table has a PK with multiple columns the system would be adding additional columns in "Column" field to match it, which is not what the user wanted in the first place.

      So I suggest this feature be marked as implemented.

       
  • Marc Delisle

    Marc Delisle - 2014-12-16

    Pull request merged, thanks.

     
  • Marc Delisle

    Marc Delisle - 2015-02-15
    • Priority: 5 --> Normal
     
  • Marc Delisle

    Marc Delisle - 2015-03-12
    • summary: Default to primary key when adding relation --> (ok 4.4) Default to primary key when adding relation
    • status: open --> resolved
    • assigned_to: Hugues Peccatte
    • Group: Needs_decision --> Next_release
    • Priority: Normal --> Low
     
  • Marc Delisle

    Marc Delisle - 2015-04-20
    • Status: resolved --> fixed