mysql对应java的enum

CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    role ENUM('ADMIN', 'USER', 'GUEST')
);

public enum Role {
    ADMIN,
    USER,
    GUEST;
}

ALTER TABLE users ADD COLUMN role_new ENUM('ADMIN', 'USER', 'GUEST', 'MODERATOR') DEFAULT 'USER';
UPDATE users SET role_new = role;
ALTER TABLE users DROP COLUMN role;
ALTER TABLE users RENAME COLUMN role_new TO role;

public interface RoleInterface {
    String getName();
}

public enum Role implements RoleInterface {
    ADMIN("ADMIN"),
    USER("USER"),
    GUEST("GUEST");

    private String name;

    Role(String name) {
        this.name = name;
    }

    @Override
    public String getName() {
        return name;
    }
}