Plugin Database Scripts

Plugins that require persistence of data outside of that allowed by the IdentityIQ object model require at minimum the creation, updating, and deletion of unique tablespace. The plugin framework creates a database named identityiqPlugin. The creation of this database is handled by the installation scripts packaged with every download of IdentityIQ, in the WEB-INF/database folder. Additionally, a default user identityiqPlugin is created to perform operations, installation and deletion of plugins, on this new database. Similar to the base IdentityIQ username and password, these can be modified and updated in the IdentityIQ iiq.properties file located in WEB-INF/classes/iiq.properties.

When creating a plugin, you must create a folder named db in your project directory. This folder should be further subdivided into three operation specific folders: install, uninstall, and upgrade.

The scripts placed in these folders are automatically run when a plugin is installed or deleted. It is recommended that you include scripts for the four major database types supported by IdentityIQ, MySQL, SQLServer, DB2, and Oracle, or note in your documentation which databases are supported. Database specific scripts must include the database type as the file extension, for example .mysql. The upgrade folder should contain any deltas in table definitions from prior versions of the plugin.