JIRA 3.12 DB Schema Changes
The table below summarises the changes to the database schema. Please note, that if you have developed any custom utilities which query or modify the JIRA database directly (i.e. without using the JIRA API), please check whether the utilities need to be updated.
New Database Table Table - TRUSTEDAPP
The database table trustedapp has been added to schema support Trusted Applications:
It has the following columns:
Column Name |
Type |
|---|---|
id |
numeric |
applicationId |
long-varchar |
name |
long-varchar |
publicKey |
very-long |
ipMatch |
very-long |
urlMatch |
very-long |
timeout |
numeric |
created |
date-time |
createdBy |
long-varchar |
updated |
date-time |
updatedBy |
long-varchar |
The ID column is the primary key.
For a mapping of the above type to your particular database, please see the appropriate fieldtype-*.xml file in JIRA's WEB-INF/classes/entitydefs/ directory.