title: How to add more attributes to Openfire MySQL database?
body: <p>I setup a Openfire server with external MySQL database using the openfire_mysql.sql file from the openfire installation directory to populate the database, the connection and everything basic seems to be ok.</p>
  
  <p>However I need to add another attribute of a User instead of just "name", "email", I need to add "phone" and a long text field for users to save some notes.</p>
  
  <p>Actually using the Smack API there are already enough attributes that can be stored in a User's data based on the API doc:</p>
  
  <p><a href="http://docs.jivesoftware.com/smack/latest/javadoc/org/jivesoftware/smack/AccountManager.html#getAccountAttributes" rel="nofollow">http://docs.jivesoftware.com/smack/latest/javadoc/org/jivesoftware/smack/AccountManager.html#getAccountAttributes</a>()</p>
  
  <p>However when doing createAccount with the parameter of Map attributes, the attribute is not persisted because I think the default database does not have fields to store this. So I used external database, yet still I can't see in the phpMyAdmin which fields this attribute get stored? </p>
  
  <p>Any ideas?</p>