This is like I want to add new columns in existing table of openfire ex. ofRoster new column ABC .
how we can achieve this . didn’t found any documentation related to it .
Modifying Openfire database tables is risky. Doing so introduces risks that future updates of Openfire will fail (as they might introduce database updates that clash with the custom change that was made). I recommend against modifying Openfire database tables.
Instead, you can create new database tables, and manage your data there. One way of doing so is to use a plugin, that can have its own set of database installation and upgrade scripts. This mechanism is documented in the Openfire Plugin Developers Guide.