@Override
    public void prepareDatabaseTable(final Statement s) throws Exception {
        s.execute("create table table_users (uid VARCHAR(255),attr_name VARCHAR(255),attr_value VARCHAR(255));");
        s.execute("insert into table_users (uid, attr_name, attr_value) values('casuser', 'role_code', 'AL');");
        s.execute("insert into table_users (uid, attr_name, attr_value) values('casuser', 'role_code', 'SF');");
        s.execute("insert into table_users (uid, attr_name, attr_value) values('casuser', 'role_code', 'AZ');");
        s.execute("insert into table_users (uid, attr_name, attr_value) values('casuser', 'nickname', 'CASTest1');");
        s.execute("insert into table_users (uid, attr_name, attr_value) values('casuser', 'nickname', 'CasTest2');");

        s.execute("create table table_ext_users (uid VARCHAR(255),attr_name VARCHAR(255),attr_value VARCHAR(255));");
        s.execute("insert into table_ext_users (uid, attr_name, attr_value) values('casuser', 'nickname', 'ApereoCAS');");

    }
This is {@link JdbcMultiRowAttributeRepositoryTests}.

@author Misagh Moayyed
@since 5.3.0
support/cas-server-support-jdbc/src/test/java/org/apereo/cas/jdbc/JdbcMultiRowAttributeRepositoryTests.java