Ordered List of changes to perform in the 1.7 => 1.8 upgrade of groups: 1) Set groups->description to NULLable. 2) Rename the groups->password field to enrolmentkey 3) Change the groups->lang from 10cc to 30cc 4) Change the groups->hidepicture from int(2) to int(1) 5) Add one UNIQUE index on groups_members (groupid, userid) 6) Add the whole groups_groupings table (as is in 1.8.2+) 7) Add the whole groups_courses_groups table (as is in 1.8.2+) 8) Add the whole groups_courses_groupings table (as is in 1.8.2+) 9) Add the whole groups_groupings_groups table (as is in 1.8.2+) 10) Insert one record in log_display (module, action, mtable, field) VALUES ('group', 'view', 'groups', 'name') IF it doesn't exist. 11) PERFORM ALL THE NEEDED MOVEMENTS OF DATA 12) Drop the groups->courseid index 13) Drop the groups->courseid field