Foreign key constraint missing for profile icons
Bug #805742 reported by
Richard Mansfield
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Mahara |
Fix Released
|
Low
|
Richard Mansfield |
Bug Description
The installation misses a foreign key (the profileicon field of the usr table should refer to the artefact table). This is because of the order in which XMLDB creates tables and keys, but it seems reasonable to fix it up in the postinst function once all the tables exist.
Changed in mahara: | |
status: | New → Confirmed |
importance: | Undecided → Low |
assignee: | nobody → Richard Mansfield (richard-mansfield) |
milestone: | none → 1.5.0 |
Changed in mahara: | |
status: | Confirmed → Fix Committed |
Changed in mahara: | |
status: | In Progress → Fix Committed |
Changed in mahara: | |
status: | Fix Committed → Fix Released |
To post a comment you must log in.
Reviewed: https:/ /reviews. mahara. org/436 gitorious. org/mahara/ mahara/ commit/ 0c9774b93387361 89f57bf5cef0464 25e97bf092
Committed: http://
Submitter: Richard Mansfield (<email address hidden>)
Branch: master
commit 0c9774b93387361 89f57bf5cef0464 25e97bf092
Author: Richard Mansfield <email address hidden>
Date: Tue Jul 5 12:10:01 2011 +1200
Add foreign key constraint on profileicon field of usr table
Bug #805742
Also ensures the profileicon field is cleared when the artefact
it points to gets deleted.
Change-Id: Idfda6111b3d653 e26225bff905007 06ec5dd66a7
Signed-off-by: Richard Mansfield <email address hidden>