← Back to team overview

mahara-contributors team mailing list archive

[Bug 1407511] Re: usr_institution uses institution name as foreign key

 

Since we've just added an ID column to the "institution" table, it
should be fairly easy to refactor usr_institution to use that instead of
institution.name for the foreign key.

** Changed in: mahara
    Milestone: None => 15.04.0

** Changed in: mahara
       Status: New => Confirmed

** Changed in: mahara
   Importance: Undecided => Wishlist

-- 
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.
Matching subscriptions: Subscription for all Mahara Contributors -- please ask on #mahara-dev or mahara.org forum before editing or unsubscribing it!
https://bugs.launchpad.net/bugs/1407511

Title:
  usr_institution uses institution name as foreign key

Status in Mahara ePortfolio:
  Confirmed

Bug description:
  In current Mahara dev at the time of writing (15.04-dev), the
  usr_institution table uses the institution name rather than its ID as
  a foreign key. This will slow things down because it forces string
  comparisons to be done instead of simple numeric value comparisons.

To manage notifications about this bug go to:
https://bugs.launchpad.net/mahara/+bug/1407511/+subscriptions


References