Comment 6 for bug 1174623

Reviewed: https://reviews.mahara.org/2815
Committed: http://gitorious.org/mahara/mahara/commit/852254aa84038ecb787fb6920a8d8030ba4a9f41
Submitter: Aaron Wells (<email address hidden>)
Branch: 1.8_STABLE

commit 852254aa84038ecb787fb6920a8d8030ba4a9f41
Author: Robert Lyon <email address hidden>
Date: Tue Nov 26 11:15:14 2013 +1300

Adding in missing keys & indexes

Bug 1174623 For sites that have been upgraded from version 1.0 there are
some missing constraints and indexes on the artefact_access_usr,
artefact_access_role, artefact_attachment, group, grouptype_roles
and view_autocreate_grouptype tables.

Also some fields need to be adjusted to match the referenced field in
another table so that they can be used as a foreign key

Change-Id: Ifb8cd79d4fa9933be02f6086fb5dada18d47bfe2
Signed-off-by: Robert Lyon <email address hidden>
Signed-off-by: Aaron Wells <email address hidden>