<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<databaseChangeLog xmlns="http://www.liquibase.org/xml/ns/dbchangelog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-2.0.xsd">

    <changeSet author="maxence" id="1505981350000-1">
        <delete tableName="permission">
            <where>role_id=2 OR role_id=3 OR role_id=6</where>
        </delete>
        <delete tableName="users_roles">
            <where>roles_id=2 OR roles_id=3 OR roles_id=6</where>
        </delete>
        <delete tableName="roles">
            <where>id=2 OR id=3 OR id=6</where>
        </delete>
    </changeSet>
</databaseChangeLog>

Remove Public, Register and Guest roles
[DB] Remove Public, Register and Guest roles

* remove their permissions, and users_roles