INSERT INTO `cms__resource`(
    `resourceID`,
    `moduleID`,
    `name`,
    `description`
) VALUES (
    'auth.user.resendActivation',
    3,
    'auth.user.resendActivation.name',
    'auth.user.resendActivation.description'
 );


insert into smd__organization_role_has_resources (roleID, resourceID) select roleID, 'auth.user.resendActivation' as resourceID from smd__organization_role WHERE roleID LIKE '%.superAdmin.%';
insert into smd__organization_role_has_resources (roleID, resourceID) select roleID, 'auth.user.resendActivation' as resourceID from smd__organization_role WHERE roleID LIKE '%.admin.%';