sql.migration.V20150731152013__MigrateGroupAdmins.sql Maven / Gradle / Ivy
The newest version!
update group_users gu set is_admin = true where gu.user_id = (select g.creator_user_id from groups g where g.id = gu.group_id);
update group_users gu set is_admin = true where gu.user_id = (select g.creator_user_id from groups g where g.id = gu.group_id);