Database - Configuration properties
There are some global JIRA configuration settings, such as:
- Search index path
- Attachments path
- Base URL
- Settings configured in Administration -> General Configuration
- License info
These are all stored in a propertyset on a virtual 'jira.properties' entity:
The 'propertytype' column indicates which table stores the actual value for this property. 1 means 'propertynumber' and 5 means 'propertystring':
Here you can see that indexing is enabled (1), external user management off (0), subtasks enabled (1), etc.
JIRA build versions and upgrading
One important property stored is the build number:
The build number corresponds to a JIRA version. In the footer of JIRA pages you'll see this build number after the version, eg. "Version: 3.7.2-#186".
The build number is mostly relevant when upgrading. JIRA will run "upgrade tasks" when it detects that the JIRA's data is from an older version, and it does this by comparing the build number in the database with its own.
When an upgrade task is successfully run, it is recorded in the upgradehistory table: