Openfire Custom Database and Smack API problem

I am working with Openfire with external MySQL database created with the defaultopenfire_mysql.sql from the Openfire server resources folder.

What I am trying to accomplish is to make the attribute persistence work, as described in the Smack API. Attribute stored using createAccount(String username, String password, Map<String, String> attributes) and retrieved using getAttributes

However it seems that the default external database setup is not up for persisting these attributes, I already tried manually adding the row yet still attributes are not persisted.

Anyone have encountered this requirement before?

BTW, I am able to persist attributes:

“name”, “first”, “last” and “email”

But other attributes that are defined in Smack API javadoc is not persisted:

“phone” and “misc”