Extending JIRA DB with custom schema

Now that we know that JIRA scheme definitions are maintained in WEB-INF/classes/entitydefs/entitygroup.xml and entitymodel.xml, let us have a look at extending the existing scheme definitions. How would you extend the JIRA scheme if you want to add one or two custom tables into JIRA? Is it just about creating the new tables in our database? We will see that in this recipe.

How to do it...

JIRA uses the schema definitions entered in the WEB-INF/classes/entitydefs/entitygroup.xml and entitymodel.xml files. It makes use of these files not only to validate and create the schema but also during import and export of the JIRA Data backup. JIRA also uses these entity definitions to read and write to a database, using OfBizDelegator (http://docs.atlassian.com/jira/latest/com/atlassian/jira/ofbiz/OfBizDelegator.html), details of which we will see in the upcoming recipes.

The following are quick steps to add a new table into the JIRA schema. Let us assume we are adding...