• Robert Lyon's avatar
    Adding in missing keys & indexes · aee3b546
    Robert Lyon authored and Aaron Wells's avatar Aaron Wells committed
    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's avatarRobert Lyon <robertl@catalyst.net.nz>
    Signed-off-by: Aaron Wells's avatarAaron Wells <aaronw@catalyst.net.nz>