-- Inserts NEW authority for each user which have OPEN authority
INSERT INTO authority (name) value ("NEW");
SET @authorityNewId = last_insert_id();
SELECT
    id
FROM
    authority
WHERE
    name = 'OPEN' INTO @relatedAuthorityNewId;
INSERT INTO user_authority (userId, authorityId)
SELECT userId,
       @authorityNewId
FROM user_authority
WHERE authorityId = @relatedAuthorityNewId;