#  Add a new Role
# Shameema Esufali June 2020

# 1. Add roles 

INSERT INTO RoleReference (Description) VALUES("Test Role1"),("Test Role 2");

# If you want to control the RoleReference ID manually then 
SELECT @maxid:=max(RoleID) from RoleReference;

INSERT INTO RoleReference (RoleID,Description) VALUES(@maxid+1,"Test Role2"),(@maxid+2,"Test Role 3");





