Custom field names shows message keys instead of values - JRASERVER-69388

Still need help?

The Atlassian Community is here for you.

Ask the community

In Jira 8.2.0 we introduced a bug  JRASERVER-69388 - Getting issue details... STATUS  which caused that some i18n keys where shown instead of their translation provided by applications and apps.


The root cause

In Jira 8.2.0 we introduced a bug by not respecting the contract between plugins and Jira Core on the com.atlassian.plugin.event.events.PluginEnabledEvent.

Application and apps can use this event to finish initialisation and it is often used to trigger creating custom fields or other entities. When this event is sent the plugin expects that Jira Core services reflect the new state of the plugin system, for example that they are aware of the resources added by this new plugin. In 8.2.0 we have delayed reseting of some caches which contain data related to plugins. One of these caches is the i18n cache providing translations for all i18n resources present in the plugin system. When the cache is not correctly rebuilt after resources have been added, it will return untranslated keys, rather than the corresponding translations.
The bug was fixed in Jira 8.3.1 by bringing back the contract between plugins and Jira Core when com.atlassian.plugin.event.events.PluginEnabledEvent is sent. 

Affected versions and related issues

  • Jira Core and Jira Software 8.2.0, 8.2.1, 8.2.2, 8.2.3, 8.2.4, 8.3.0 
  • Jira Service Management 4.2.0, 4.2.1, 4.2.2, 4.2.3, 4.2.4, 4.3.0
  • any plugin installed on Jira version listed above
  • JRASERVER-69388 - Getting issue details... STATUS
  • JSWSERVER-20103 - Getting issue details... STATUS
  • JPOSERVER-2629 - Getting issue details... STATUS
  • JRASERVER-69635 - Getting issue details... STATUS

Only versions listed above can be affected by this bug. When upgrading from < 8.2.0 to >=8.3.1 this bug is not affecting the Jira installation.

Broken installations and upgrade

If plugins where using those untranslated keys for creating new entities during set up you may have corrupted data in the database. To solve this problem we have done the following:

  • In version 8.3.1 there is an upgrade task which should solve most of the common problems usually caused by this bug. See more in: Upgrade Task fixing untranslated keys
  • In version 8.3.1 there is an endpoint which can fix any untranslated key in any database table / column. See more in: REST Endpoint fixing untranslated keys.

Upgrade Task fixing untranslated keys

We found the following tables could have broken data, i.e. keys instead of their translations according to the default instance language. 

This task fixes following tables:

  • customfield
  • issuetype
  • fieldconfigscheme
  • fieldconfiguration
  • fieldlayoutitem
  • projectrole
  • searchrequest

The upgrade task will be run only once if an affected version has been previously installed.

More details about when the upgrade task is run.
The upgrade task is triggered only if any of the versions containing this bug (8.2.0, 8.2.1, 8.2.2, 8.2.3, 8.2.4, 8.3.0) is present in your upgrade version history (upgradeversionhistory table).

The upgrade task will be triggered only if the Jira property: com.atlassian.jira.upgrade.untranslatedkeyfixer.disabled is not defined (by default) or is set to false (it will be automatically set to true after the first run).

It is safe to run the upgrade task multiple times (by changing the value of Jira property com.atlassian.jira.upgrade.untranslatedkeyfixer.disabled to false) - this can be useful in case some plugins providing i18n resources failed to start during upgrade.

It is also safe to completely disable this task by setting the value of Jira property com.atlassian.jira.upgrade.untranslatedkeyfixer.disabled to true before upgrading to >= 8.3.1.


After this upgrade task is run the results describing what was fixed can be found in atlassian-jira.log :

[KEY-FIXER] Triggering customfield fixer.
[KEY-FIXER] Fixing customfield [name, description] id: 10011 from [devstatus.customfield.development.name, devstatus.customfield.development.desc] to [Development, Development Summary Field for Jira Software use only.]...
...
[KEY-FIXER] Fixing customfield done: 18/18/39 [found problems/fixed problems/total]
...
[KEY-FIXER] Triggering issuetype fixer.
[KEY-FIXER] Fixing issuetype [name, description] id: 10002 from [gh.issue.epic, gh.issue.epicdesc] to [Epic, Created by Jira Software - do not edit or delete. Issue type for a big user story that needs to be broken down.]...
...
[KEY-FIXER] Fixing issuetype done: 2/2/11 [found problems/fixed problems/total]
...
[KEY-FIXER] Triggering fieldconfigscheme fixer.
...
[KEY-FIXER] Triggering fieldconfiguration fixer.
...
[KEY-FIXER] Triggering fieldlayoutitem fixer.
...
[KEY-FIXER] Fixing fieldlayoutitem done: 26/26/81 [found problems/fixed problems/total]
...
[KEY-FIXER] Triggering projectrole fixer.
...
[KEY-FIXER] Triggering searchrequest fixer.
...
[KEY-FIXER] Resetting all related caches.
[KEY-FIXER] Untranslated key fixer finished.


The list of custom fields affected by the upgrade task is available in the audit log:


REST Endpoint fixing untranslated keys

The upgrade task is not handling untranslated keys in active objects tables (AO_* database tables). To solve this problem or any other affected table not handled by the above upgrade task, we added endpoints which allow you to fix untranslated keys in any database table.

Note that these endpoints are disabled by default. To enable them add the following system property: -Dcom.atlassian.jira.retranslatekeys.enabled=true

Dry Run
GET http://[jira]/rest/internal/2/retranslatekeys/[tableOrEntityName]/[columnOrFieldName]?key=[some.untranslated.key]


Returns the results of doing a "dry run" of replacing all occurrences of key with its default Jira i18n translation in the table and column specified by tableOrEntityName and  columnOrFieldName. "Table" and "column" apply to AO tables. If tableOrEntityName starts with "AO_", then the assumption is that a plugin table is being targeted. Otherwise, we assume that Jira table is the intended target, and the first two parameters are interpreted as entityname and fieldname. These are OfBiz constructs that differ from raw table & column names. For a full inventory of them, see Jira's entitymodel.xml file.

entitymodel.xml...
<!-- based on entitymodel.xml 8.3.1, contains only entity and field tags -->
<entitymodel>
    <entity entity-name="SequenceValueItem" table-name="SEQUENCE_VALUE_ITEM" package-name="">
        <field name="seqName" type="id-long-ne"/>
        <field name="seqId" type="numeric"/>
    </entity>
    <entity entity-name="User" table-name="cwd_user" package-name="">
        <field name="id" type="numeric"/>
        <field name="directoryId" col-name="directory_id" type="numeric"/>
        <field name="userName" col-name="user_name" type="long-varchar"/>
        <field name="lowerUserName" col-name="lower_user_name" type="long-varchar"/>
        <field name="active" col-name="active" type="integer"/>
        <field name="createdDate" col-name="created_date" type="date-time"/>
        <field name="updatedDate" col-name="updated_date" type="date-time"/>
        <field name="firstName" col-name="first_name" type="long-varchar"/>
        <field name="lowerFirstName" col-name="lower_first_name" type="long-varchar"/>
        <field name="lastName" col-name="last_name" type="long-varchar"/>
        <field name="lowerLastName" col-name="lower_last_name" type="long-varchar"/>
        <field name="displayName" col-name="display_name" type="long-varchar"/>
        <field name="lowerDisplayName" col-name="lower_display_name" type="long-varchar"/>
        <field name="emailAddress" col-name="email_address" type="long-varchar"/>
        <field name="lowerEmailAddress" col-name="lower_email_address" type="long-varchar"/>
        <field name="credential" type="long-varchar"/>
        <field name="deletedExternally" col-name="deleted_externally" type="integer"/>
        <field name="externalId" type="long-varchar"/>
    </entity>
    <entity entity-name="ApplicationUser" table-name="app_user" package-name="">
        <field name="id" type="numeric"/>
        <field name="userKey" col-name="user_key" type="long-varchar"/>
        <field name="lowerUserName" col-name="lower_user_name" type="long-varchar"/>
    </entity>
    <entity entity-name="Board" table-name="board" package-name="">
        <field name="id" type="numeric"/>
        <field name="jql" type="extremely-long"/>
    </entity>
    <entity entity-name="BoardProject" table-name="boardproject" package-name="">
        <field name="boardId" type="numeric"/>
        <field name="projectId" type="numeric"/>
    </entity>
    <entity entity-name="UserAttribute" table-name="cwd_user_attributes" package-name="">
        <field name="id" type="numeric"/>
        <field name="userId" col-name="user_id" type="numeric"/>
        <field name="directoryId" col-name="directory_id" type="numeric"/>
        <field name="name" col-name="attribute_name" type="long-varchar"/>
        <field name="value" col-name="attribute_value" type="long-varchar"/>
        <field name="lowerValue" col-name="lower_attribute_value" type="long-varchar"/>
    </entity>
    <entity entity-name="Group" table-name="cwd_group" package-name="">
        <field name="id" type="numeric"/>
        <field name="groupName" col-name="group_name" type="long-varchar"/>
        <field name="lowerGroupName" col-name="lower_group_name" type="long-varchar"/>
        <field name="active" col-name="active" type="integer"/>
        <field name="local" col-name="local" type="integer"/>
        <field name="createdDate" col-name="created_date" type="date-time"/>
        <field name="updatedDate" col-name="updated_date" type="date-time"/>
        <field name="description" col-name="description" type="long-varchar"/>
        <field name="lowerDescription" col-name="lower_description" type="long-varchar"/>
        <field name="type" col-name="group_type" type="short-varchar"/>
        <field name="directoryId" col-name="directory_id" type="numeric"/>
    </entity>
    <entity entity-name="GroupAttribute" table-name="cwd_group_attributes" package-name="">
        <field name="id" type="numeric"/>
        <field name="groupId" col-name="group_id" type="numeric"/>
        <field name="directoryId" col-name="directory_id" type="numeric"/>
        <field name="name" col-name="attribute_name" type="long-varchar"/>
        <field name="value" col-name="attribute_value" type="long-varchar"/>
        <field name="lowerValue" col-name="lower_attribute_value" type="long-varchar"/>
    </entity>
    <entity entity-name="OSUser" table-name="userbase" package-name="">
        <field name="id" type="numeric"/>
        <field name="name" col-name="username" type="long-varchar"/>
        <field name="passwordHash" type="long-varchar"/>
    </entity>
    <entity entity-name="OSMembership" table-name="membershipbase" package-name="">
        <field name="id" type="numeric"/>
        <field name="userName" type="long-varchar"/>
        <field name="groupName" type="long-varchar"/>
    </entity>
    <entity entity-name="OSGroup" table-name="groupbase" package-name="">
        <field name="id" type="numeric"/>
        <field name="name" col-name="groupname" type="long-varchar"/>
    </entity>
    <entity entity-name="Membership" table-name="cwd_membership" package-name="">
        <field name="id" type="numeric"/>
        <field name="parentId" col-name="parent_id" type="numeric"/>
        <field name="childId" col-name="child_id" type="numeric"/>
        <field name="membershipType" col-name="membership_type" type="short-varchar"/>
        <field name="groupType" col-name="group_type" type="short-varchar"/>
        <field name="parentName" col-name="parent_name" type="long-varchar"/>
        <field name="lowerParentName" col-name="lower_parent_name" type="long-varchar"/>
        <field name="childName" col-name="child_name" type="long-varchar"/>
        <field name="lowerChildName" col-name="lower_child_name" type="long-varchar"/>
        <field name="directoryId" col-name="directory_id" type="numeric"/>
    </entity>
    <entity entity-name="Directory" table-name="cwd_directory" package-name="">
        <field name="id" type="numeric"/>
        <field name="directoryName" col-name="directory_name" type="long-varchar"/>
        <field name="lowerDirectoryName" col-name="lower_directory_name" type="long-varchar"/>
        <field name="createdDate" col-name="created_date" type="date-time"/>
        <field name="updatedDate" col-name="updated_date" type="date-time"/>
        <field name="active" col-name="active" type="integer"/>
        <field name="description" col-name="description" type="long-varchar"/>
        <field name="implementationClass" col-name="impl_class" type="long-varchar"/>
        <field name="lowerImplementationClass" col-name="lower_impl_class" type="long-varchar"/>
        <field name="type" col-name="directory_type" type="short-varchar"/>
        <field name="position" col-name="directory_position" type="numeric"/>
    </entity>
    <entity entity-name="DirectoryAttribute" table-name="cwd_directory_attribute" package-name="">
        <field name="directoryId" col-name="directory_id" type="numeric"/>
        <field name="name" col-name="attribute_name" type="long-varchar"/>
        <field name="value" col-name="attribute_value" type="4k-varchar"/>
    </entity>
    <entity entity-name="DirectoryOperation" table-name="cwd_directory_operation" package-name="">
        <field name="directoryId" col-name="directory_id" type="numeric"/>
        <field name="operationType" col-name="operation_type" type="short-varchar"/>
    </entity>
    <entity entity-name="Application" table-name="cwd_application" package-name="">
        <field name="id" type="numeric"/>
        <field name="name" col-name="application_name" type="long-varchar"/>
        <field name="lowerName" col-name="lower_application_name" type="long-varchar"/>
        <field name="createdDate" col-name="created_date" type="date-time"/>
        <field name="updatedDate" col-name="updated_date" type="date-time"/>
        <field name="active" col-name="active" type="integer"/>
        <field name="description" col-name="description" type="long-varchar"/>
        <field name="applicationType" col-name="application_type" type="long-varchar"/>
        <field name="credential" col-name="credential" type="long-varchar"/>
    </entity>
    <entity entity-name="RemoteAddress" table-name="cwd_application_address" package-name="">
        <field name="applicationId" col-name="application_id" type="numeric"/>
        <field name="address" col-name="remote_address" type="long-varchar"/>
        <field name="encodedAddressBytes" col-name="encoded_address_binary" type="long-varchar"/>
        <field name="mask" col-name="remote_address_mask" type="integer"/>
    </entity>
    <entity entity-name="ExternalEntity" table-name="external_entities" package-name="">
        <field name="id" type="numeric"/>
        <field name="name" type="long-varchar"/>
        <field name="type" col-name="entitytype" type="long-varchar"/>
    </entity>
    <entity entity-name="EntityTranslation" table-name="entity_translation" package-name="">
        <field name="id" type="numeric"/>
        <field name="entityName" type="long-varchar"/>
        <field name="entityId" type="numeric"/>
        <field name="locale" type="short-varchar"/>
        <field name="transName" type="long-varchar"/>
        <field name="transDesc" type="long-varchar"/>
    </entity>
    <entity entity-name="EntityProperty" table-name="entity_property" package-name="">
        <field name="id" type="numeric"/>
        <field name="entityName" type="long-varchar"/>
        <field name="entityId" type="numeric"/>
        <field name="propertyKey" type="long-varchar"/>
        <field name="created" type="date-time"/>
        <field name="updated" type="date-time"/>
        <field name="value" col-name="json_value" type="extremely-long"/>
    </entity>
    <entity entity-name="EntityPropertyIndexDocument" table-name="entity_property_index_document" package-name="">
        <field name="id" type="numeric"/>
        <field name="pluginKey" type="long-varchar"/>
        <field name="moduleKey" type="long-varchar"/>
        <field name="entityKey" type="long-varchar"/>
        <field name="updated" type="date-time"/>
        <field name="document" type="extremely-long"/>
    </entity>
    <entity entity-name="OSPropertyEntry" table-name="propertyentry" package-name="">
        <field name="id" type="numeric"/>
        <field name="entityName" type="long-varchar"/>
        <field name="entityId" type="numeric"/>
        <field name="propertyKey" type="long-varchar"/>
        <field name="type" col-name="propertytype" type="integer"/>
    </entity>
    <entity entity-name="OSPropertyString" table-name="propertystring" package-name="">
        <field name="id" type="numeric"/>
        <field name="value" col-name="propertyvalue" type="very-long"/>
    </entity>
    <entity entity-name="OSPropertyText" table-name="propertytext" package-name="">
        <field name="id" type="numeric"/>
        <field name="value" col-name="propertyvalue" type="extremely-long"/>
    </entity>
    <entity entity-name="OSPropertyDate" table-name="propertydate" package-name="">
        <field name="id" type="numeric"/>
        <field name="value" col-name="propertyvalue" type="date-time"/>
    </entity>
    <entity entity-name="OSPropertyData" table-name="propertydata" package-name="">
        <field name="id" type="numeric"/>
        <field name="value" col-name="propertyvalue" type="blob"/>
    </entity>
    <entity entity-name="OSPropertyDecimal" table-name="propertydecimal" package-name="">
        <field name="id" type="numeric"/>
        <field name="value" col-name="propertyvalue" type="floating-point"/>
    </entity>
    <entity entity-name="OSPropertyNumber" table-name="propertynumber" package-name="">
        <field name="id" type="numeric"/>
        <field name="value" col-name="propertyvalue" type="numeric"/>
    </entity>
    <entity entity-name="OSWorkflowEntry" table-name="OS_WFENTRY" package-name="">
        <field name="id" col-name="ID" type="numeric"/>
        <field name="name" col-name="NAME" type="long-varchar"/>
        <field name="initialized" col-name="INITIALIZED" type="integer"/>
        <field name="state" col-name="STATE" type="integer"/>
    </entity>
    <entity entity-name="OSCurrentStep" table-name="OS_CURRENTSTEP" package-name="">
        <field name="id" col-name="ID" type="numeric"/>
        <field name="entryId" col-name="ENTRY_ID" type="numeric"/>
        <field name="stepId" col-name="STEP_ID" type="integer"/>
        <field name="actionId" col-name="ACTION_ID" type="integer"/>
        <field name="owner" col-name="OWNER" type="long-varchar"/>
        <field name="startDate" col-name="START_DATE" type="date-time"/>
        <field name="dueDate" col-name="DUE_DATE" type="date-time"/>
        <field name="finishDate" col-name="FINISH_DATE" type="date-time"/>
        <field name="status" col-name="STATUS" type="short-varchar"/>
        <field name="caller" col-name="CALLER" type="long-varchar"/>
    </entity>
    <entity entity-name="OSHistoryStep" table-name="OS_HISTORYSTEP" package-name="">
        <field name="id" col-name="ID" type="numeric"/>
        <field name="entryId" col-name="ENTRY_ID" type="numeric"/>
        <field name="stepId" col-name="STEP_ID" type="integer"/>
        <field name="actionId" col-name="ACTION_ID" type="integer"/>
        <field name="owner" col-name="OWNER" type="long-varchar"/>
        <field name="startDate" col-name="START_DATE" type="date-time"/>
        <field name="dueDate" col-name="DUE_DATE" type="date-time"/>
        <field name="finishDate" col-name="FINISH_DATE" type="date-time"/>
        <field name="status" col-name="STATUS" type="short-varchar"/>
        <field name="caller" col-name="CALLER" type="long-varchar"/>
    </entity>
    <entity entity-name="OSCurrentStepPrev" table-name="OS_CURRENTSTEP_PREV" package-name="">
        <field name="id" col-name="ID" type="numeric"/>
        <field name="previousId" col-name="PREVIOUS_ID" type="numeric"/>
    </entity>
    <entity entity-name="OSHistoryStepPrev" table-name="OS_HISTORYSTEP_PREV" package-name="">
        <field name="id" col-name="ID" type="numeric"/>
        <field name="previousId" col-name="PREVIOUS_ID" type="numeric"/>
    </entity>
    <entity entity-name="ListenerConfig" table-name="listenerconfig" package-name="">
        <field name="id" type="numeric"/>
        <field name="clazz" type="long-varchar"/>
        <field name="name" col-name="listenername" type="long-varchar"/>
    </entity>
    <entity entity-name="ServiceConfig" table-name="serviceconfig" package-name="">
        <field name="id" type="numeric"/>
        <field name="time" type="numeric" col-name="delaytime"/>
        <field name="clazz" type="long-varchar"/>
        <field name="name" col-name="servicename" type="long-varchar"/>
        <field name="cronExpression" type="long-varchar"/>
    </entity>
    <entity entity-name="Project" table-name="project" package-name="">
        <field name="id" type="numeric"/>
        <field name="name" col-name="pname" type="long-varchar"/>
        <field name="url" type="long-varchar"/>
        <field name="lead" type="long-varchar"/>
        <field name="description" type="very-long"/>
        <field name="key" col-name="pkey" type="long-varchar"/>
        <field name="counter" col-name="pcounter" type="numeric"/>
        <field name="assigneetype" type="numeric"/>
        <field name="avatar" type="numeric"/>
        <field name="originalkey" type="long-varchar"/>
        <field name="projecttype" type="long-varchar"/>
    </entity>
    <entity entity-name="Version" table-name="projectversion" package-name="">
        <field name="id" type="numeric"/>
        <field name="project" type="numeric"/>
        <field name="name" col-name="vname" type="long-varchar"/>
        <field name="description" type="very-long"/>
        <field name="sequence" type="numeric"/>
        <field name="released" type="very-short"/>
        <field name="archived" type="very-short"/>
        <field name="url" type="long-varchar"/>
        <field name="startdate" type="date-time"/>
        <field name="releasedate" type="date-time"/>
    </entity>
    <entity entity-name="Component" table-name="component" package-name="">
        <field name="id" type="numeric"/>
        <field name="project" type="numeric"/>
        <field name="name" col-name="cname" type="long-varchar"/>
        <field name="description" col-name="description" type="very-long"/>
        <field name="url" type="long-varchar"/>
        <field name="lead" type="long-varchar"/>
        <field name="assigneetype" type="numeric"/>
        <field name="archived" type="very-short"/>
    </entity>
    <entity entity-name="ProjectCategory" table-name="projectcategory" package-name="">
        <field name="id" type="numeric"/>
        <field name="name" col-name="cname" type="long-varchar"/>
        <field name="description" col-name="description" type="very-long"/>
    </entity>
    <entity entity-name="Issue" table-name="jiraissue" package-name="">
        <field name="id" type="numeric"/>
        <field name="key" col-name="pkey" type="long-varchar"/>
        <field name="number" col-name="issuenum" type="numeric"/>
        <field name="project" type="numeric"/>
        <field name="reporter" type="long-varchar"/>
        <field name="assignee" type="long-varchar"/>
        <field name="creator" type="long-varchar"/>
        <field name="type" col-name="issuetype" type="long-varchar"/>
        <field name="summary" type="long-varchar"/>
        <field name="description" type="extremely-long"/>
        <field name="environment" type="extremely-long"/>
        <field name="priority" type="long-varchar"/>
        <field name="resolution" type="long-varchar"/>
        <field name="status" col-name="issuestatus" type="long-varchar"/>
        <field name="created" type="date-time"/>
        <field name="updated" type="date-time"/>
        <field name="duedate" type="date-time"/>
        <field name="resolutiondate" type="date-time"/>
        <field name="votes" type="numeric"/>
        <field name="watches" type="numeric"/>
        <field name="timeoriginalestimate" type="numeric"/>
        <field name="timeestimate" type="numeric"/>
        <field name="timespent" type="numeric"/>
        <field name="workflowId" type="numeric"/>
        <field name="security" type="numeric"/>
        <field name="fixfor" type="numeric"/>
        <field name="component" type="numeric"/>
        <field name="archived" type="indicator"/>
        <field name="archivedby" type="long-varchar"/>
        <field name="archiveddate" type="date-time"/>
    </entity>
    <entity entity-name="ProjectKey" table-name="project_key" package-name="">
        <field name="id" type="numeric"/>
        <field name="projectId" type="numeric"/>
        <field name="projectKey" type="long-varchar"/>
    </entity>
    <entity entity-name="MovedIssueKey" table-name="moved_issue_key" package-name="">
        <field name="id" type="numeric"/>
        <field name="oldIssueKey" type="long-varchar"/>
        <field name="issueId" type="numeric"/>
    </entity>
    <entity entity-name="Label" table-name="label" package-name="">
        <field name="id" type="numeric"/>
        <field name="fieldid" type="numeric"/>
        <field name="issue" type="numeric"/>
        <field name="label" type="long-varchar"/>
    </entity>
    <entity entity-name="Action" table-name="jiraaction" package-name="">
        <field name="id" type="numeric"/>
        <field name="issue" col-name="issueid" type="numeric"/>
        <field name="author" type="long-varchar"/>
        <field name="type" col-name="actiontype" type="long-varchar"/>
        <field name="level" col-name="actionlevel" type="long-varchar"/>
        <field name="rolelevel" col-name="rolelevel" type="numeric"/>
        <field name="body" col-name="actionbody" type="extremely-long"/>
        <field name="created" type="date-time"/>
        <field name="updateauthor" type="long-varchar"/>
        <field name="updated" type="date-time"/>
        <field name="numvalue" col-name="actionnum" type="numeric"/>
    </entity>
    <entity entity-name="Worklog" table-name="worklog" package-name="">
        <field name="id" type="numeric"/>
        <field name="issue" col-name="issueid" type="numeric"/>
        <field name="author" type="long-varchar"/>
        <field name="grouplevel" col-name="grouplevel" type="long-varchar"/>
        <field name="rolelevel" col-name="rolelevel" type="numeric"/>
        <field name="body" col-name="worklogbody" type="extremely-long"/>
        <field name="created" type="date-time"/>
        <field name="updateauthor" type="long-varchar"/>
        <field name="updated" type="date-time"/>
        <field name="startdate" type="date-time"/>
        <field name="timeworked" col-name="timeworked" type="numeric"/>
    </entity>
    <entity entity-name="FileAttachment" table-name="fileattachment" package-name="">
        <field name="id" type="numeric"/>
        <field name="issue" col-name="issueid" type="numeric"/>
        <field name="mimetype" type="long-varchar"/>
        <field name="filename" type="long-varchar"/>
        <field name="created" type="date-time"/>
        <field name="filesize" type="numeric"/>
        <field name="author" type="long-varchar"/>
        <field name="zip" col-name="zip" type="integer"/>
        <field name="thumbnailable" col-name="thumbnailable" type="integer"/>
    </entity>
    <entity entity-name="SearchRequest" table-name="searchrequest" package-name="">
        <field name="id" type="numeric"/>
        <field name="name" col-name="filtername" type="long-varchar"/>
        <field name="author" col-name="authorname" type="long-varchar"/>
        <field name="description" type="very-long"/>
        <field name="user" col-name="username" type="long-varchar"/>
        <field name="group" col-name="groupname" type="long-varchar"/>
        <field name="project" col-name="projectid" type="numeric"/>
        <field name="request" col-name="reqcontent" type="extremely-long"/>
        <field name="favCount" type="numeric"/>
        <field name="nameLower" col-name="filtername_lower" type="long-varchar"/>
    </entity>
    <entity entity-name="IssueLinkType" table-name="issuelinktype" package-name="">
        <field name="id" type="numeric"/>
        <field name="linkname" type="long-varchar"/>
        <field name="inward" type="long-varchar"/>
        <field name="outward" type="long-varchar"/>
        <field name="style" col-name="pstyle" type="short-varchar"/>
    </entity>
    <entity entity-name="IssueLink" table-name="issuelink" package-name="">
        <field name="id" type="numeric"/>
        <field name="linktype" type="numeric"/>
        <field name="source" type="numeric"/>
        <field name="destination" type="numeric"/>
        <field name="sequence" type="numeric"/>
    </entity>
    <entity entity-name="RemoteIssueLink" table-name="remotelink" package-name="">
        <field name="id" type="numeric"/>
        <field name="issueid" type="numeric"/>
        <field name="globalid" type="long-varchar"/>
        <field name="title" type="long-varchar"/>
        <field name="summary" type="very-long"/>
        <field name="url" type="very-long"/>
        <field name="iconurl" type="very-long"/>
        <field name="icontitle" type="very-long"/>
        <field name="relationship" type="long-varchar"/>
        <field name="resolved" type="indicator"/>
        <field name="statusname" type="long-varchar"/>
        <field name="statusdescription" type="very-long"/>
        <field name="statusiconurl" type="very-long"/>
        <field name="statusicontitle" type="very-long"/>
        <field name="statusiconlink" type="very-long"/>
        <field name="statuscategorykey" type="long-varchar"/>
        <field name="statuscategorycolorname" type="long-varchar"/>
        <field name="applicationtype" type="long-varchar"/>
        <field name="applicationname" type="long-varchar"/>
    </entity>
    <entity entity-name="TrackbackPing" table-name="trackback_ping" package-name="">
        <field name="id" type="numeric"/>
        <field name="issue" type="numeric"/>
        <field name="url" type="long-varchar"/>
        <field name="title" type="long-varchar"/>
        <field name="blogname" type="long-varchar"/>
        <field name="excerpt" type="long-varchar"/>
        <field name="created" type="date-time"/>
    </entity>
    <entity entity-name="Priority" table-name="priority" package-name="">
        <field name="id" type="short-varchar"/>
        <field name="sequence" type="numeric"/>
        <field name="name" col-name="pname" type="short-varchar"/>
        <field name="description" type="very-long"/>
        <field name="iconurl" type="long-varchar"/>
        <field name="statusColor" type="short-varchar"/>
    </entity>
    <entity entity-name="Resolution" table-name="resolution" package-name="">
        <field name="id" type="short-varchar"/>
        <field name="sequence" type="numeric"/>
        <field name="name" col-name="pname" type="short-varchar"/>
        <field name="description" type="very-long"/>
        <field name="iconurl" type="long-varchar"/>
    </entity>
    <entity entity-name="IssueType" table-name="issuetype" package-name="">
        <field name="id" type="short-varchar"/>
        <field name="sequence" type="numeric"/>
        <field name="name" col-name="pname" type="short-varchar"/>
        <field name="style" col-name="pstyle" type="short-varchar"/>
        <field name="description" type="very-long"/>
        <field name="iconurl" type="long-varchar"/>
        <field name="avatar" type="numeric"/>
    </entity>
    <entity entity-name="Status" table-name="issuestatus" package-name="">
        <field name="id" type="short-varchar"/>
        <field name="sequence" type="numeric"/>
        <field name="name" col-name="pname" type="short-varchar"/>
        <field name="description" type="very-long"/>
        <field name="iconurl" type="long-varchar"/>
        <field name="statuscategory" type="numeric"/>
    </entity>
    <entity entity-name="ProjectChangedTime" table-name="projectchangedtime" package-name="">
        <field name="projectId" type="numeric"/>
        <field name="issueChangedTime" type="date-time"/>
    </entity>
    <entity entity-name="CustomField" table-name="customfield" package-name="">
        <field name="id" type="numeric"/>
        <field name="key" col-name="cfkey" type="long-varchar"/>
        <field name="customfieldtypekey" type="long-varchar"/>
        <field name="customfieldsearcherkey" type="long-varchar"/>
        <field name="name" col-name="cfname" type="long-varchar"/>
        <field name="description" type="very-long"/>
        <field name="default" col-name="defaultvalue" type="long-varchar"/>
        <field name="fieldtype" type="numeric"/>
        <field name="project" type="numeric"/>
        <field name="issuetype" type="long-varchar"/>
    </entity>
    <entity entity-name="CustomFieldValue" table-name="customfieldvalue" package-name="">
        <field name="id" type="numeric"/>
        <field name="issue" type="numeric"/>
        <field name="customfield" type="numeric"/>
        <field name="updated" type="numeric"/>
        <field name="parentkey" type="long-varchar"/>
        <field name="stringvalue" type="long-varchar"/>
        <field name="numbervalue" type="floating-point"/>
        <field name="textvalue" type="extremely-long"/>
        <field name="datevalue" type="date-time"/>
        <field name="valuetype" type="long-varchar"/>
    </entity>
    <entity entity-name="CustomFieldOption" table-name="customfieldoption" package-name="">
        <field name="id" type="numeric"/>
        <field name="customfield" type="numeric"/>
        <field name="customfieldconfig" type="numeric"/>
        <field name="parentoptionid" type="numeric"/>
        <field name="sequence" type="numeric"/>
        <field name="value" col-name="customvalue" type="long-varchar"/>
        <field name="type" col-name="optiontype" type="short-varchar"/>
        <field name="disabled" col-name="disabled" type="short-varchar"/>
    </entity>
    <entity entity-name="IssueFieldOption" table-name="issue_field_option" package-name="">
        <field name="id" type="numeric"/>
        <field name="optionId" type="numeric"/>
        <field name="fieldKey" type="long-varchar"/>
        <field name="value" col-name="option_value" type="long-varchar"/>
        <field name="properties" type="very-long"/>
    </entity>
    <entity entity-name="IssueFieldOptionScope" table-name="issue_field_option_scope" package-name="">
        <field name="id" type="numeric"/>
        <field name="optionId" type="numeric"/>
        <field name="entityId" type="long-varchar"/>
        <field name="scopeType" type="long-varchar"/>
    </entity>
    <entity entity-name="UserPickerFilter" table-name="userpickerfilter" package-name="">
        <field name="id" type="numeric"/>
        <field name="customfield" type="numeric"/>
        <field name="customfieldconfig" type="numeric"/>
        <field name="enabled" col-name="enabled" type="short-varchar"/>
    </entity>
    <entity entity-name="UserPickerFilterGroup" table-name="userpickerfiltergroup" package-name="">
        <field name="id" type="numeric"/>
        <field name="userpickerfilter" type="numeric"/>
        <field name="group" col-name="groupname" type="long-varchar"/>
    </entity>
    <entity entity-name="UserPickerFilterRole" table-name="userpickerfilterrole" package-name="">
        <field name="id" type="numeric"/>
        <field name="userpickerfilter" type="numeric"/>
        <field name="projectroleid" type="numeric"/>
    </entity>
    <entity entity-name="ConfigurationContext" table-name="configurationcontext" package-name="">
        <field name="id" type="numeric"/>
        <field name="projectcategory" type="numeric"/>
        <field name="project" type="numeric"/>
        <field name="key" col-name="customfield" type="long-varchar"/>
        <field name="fieldconfigscheme" type="numeric"/>
    </entity>
    <entity entity-name="FieldConfigScheme" table-name="fieldconfigscheme" package-name="">
        <field name="id" type="numeric"/>
        <field name="name" col-name="configname" type="long-varchar"/>
        <field name="description" type="very-long"/>
        <field name="fieldid" type="short-varchar"/>
        <field name="customfield" type="numeric"/>
    </entity>
    <entity entity-name="FieldConfigSchemeIssueType" table-name="fieldconfigschemeissuetype" package-name="">
        <field name="id" type="numeric"/>
        <field name="issuetype" type="long-varchar"/>
        <field name="fieldconfigscheme" type="numeric"/>
        <field name="fieldconfiguration" type="numeric"/>
    </entity>
    <entity entity-name="FieldConfiguration" table-name="fieldconfiguration" package-name="">
        <field name="id" type="numeric"/>
        <field name="name" col-name="configname" type="long-varchar"/>
        <field name="description" type="very-long"/>
        <field name="fieldid" type="short-varchar"/>
        <field name="customfield" type="numeric"/>
    </entity>
    <entity entity-name="OptionConfiguration" table-name="optionconfiguration" package-name="">
        <field name="id" type="numeric"/>
        <field name="fieldid" type="short-varchar"/>
        <field name="optionid" type="short-varchar"/>
        <field name="fieldconfig" type="numeric"/>
        <field name="sequence" type="numeric"/>
    </entity>
    <entity entity-name="GenericConfiguration" table-name="genericconfiguration" package-name="">
        <field name="id" type="numeric"/>
        <field name="datatype" type="short-varchar"/>
        <field name="datakey" type="short-varchar"/>
        <field name="xmlvalue" type="very-long"/>
    </entity>
    <entity entity-name="ChangeGroup" table-name="changegroup" package-name="">
        <field name="id" type="numeric"/>
        <field name="issue" col-name="issueid" type="numeric"/>
        <field name="author" type="long-varchar"/>
        <field name="created" type="date-time"/>
    </entity>
    <entity entity-name="ChangeItem" table-name="changeitem" package-name="">
        <field name="id" type="numeric"/>
        <field name="group" col-name="groupid" type="numeric"/>
        <field name="fieldtype" type="long-varchar"/>
        <field name="field" type="long-varchar"/>
        <field name="oldvalue" type="extremely-long"/>
        <field name="oldstring" type="extremely-long"/>
        <field name="newvalue" type="extremely-long"/>
        <field name="newstring" type="extremely-long"/>
    </entity>
    <entity entity-name="UserHistoryItem" table-name="userhistoryitem" package-name="">
        <field name="id" type="numeric"/>
        <field name="type" col-name="entitytype" type="very-short"/>
        <field name="entityId" col-name="entityid" type="short-varchar"/>
        <field name="username" type="long-varchar"/>
        <field name="lastViewed" col-name="lastviewed" type="numeric"/>
        <field name="data" col-name="data" type="extremely-long"/>
    </entity>
    <entity entity-name="NodeAssociation" table-name="nodeassociation" package-name="">
        <field name="sourceNodeId" type="numeric"/>
        <field name="sourceNodeEntity" type="short-varchar"/>
        <field name="sinkNodeId" type="numeric"/>
        <field name="sinkNodeEntity" type="short-varchar"/>
        <field name="associationType" type="short-varchar"/>
        <field name="sequence" type="integer"/>
    </entity>
    <entity entity-name="UserAssociation" table-name="userassociation" package-name="">
        <field name="sourceName" type="short-varchar"/>
        <field name="sinkNodeId" type="numeric"/>
        <field name="sinkNodeEntity" type="short-varchar"/>
        <field name="associationType" type="short-varchar"/>
        <field name="sequence" type="integer"/>
        <field name="created" type="date-time"/>
    </entity>
    <entity entity-name="MailServer" table-name="mailserver" package-name="">
        <field name="id" type="numeric"/>
        <field name="name" type="long-varchar"/>
        <field name="description" type="very-long"/>
        <field name="from" col-name="mailfrom" type="long-varchar"/>
        <field name="prefix" type="short-varchar"/>
        <field name="smtpPort" col-name="smtp_port" type="short-varchar"/>
        <field name="protocol" col-name="protocol" type="short-varchar"/>
        <field name="type" col-name="server_type" type="short-varchar"/>
        <field name="servername" type="long-varchar"/>
        <field name="jndilocation" type="long-varchar"/>
        <field name="username" col-name="mailusername" type="long-varchar"/>
        <field name="password" col-name="mailpassword" type="long-varchar"/>
        <field name="istlsrequired" type="short-varchar"/>
        <field name="timeout" type="numeric"/>
        <field name="socksPort" col-name="socks_port" type="short-varchar"/>
        <field name="socksHost" col-name="socks_host" type="short-varchar"/>
    </entity>
    <entity entity-name="NotificationScheme" table-name="notificationscheme" package-name="">
        <field name="id" type="numeric"/>
        <field name="name" type="long-varchar"/>
        <field name="description" type="very-long"/>
    </entity>
    <entity entity-name="NotificationInstance" table-name="notificationinstance" package-name="">
        <field name="id" type="numeric"/>
        <field name="type" col-name="notificationtype" type="short-varchar"/>
        <field name="source" type="numeric"/>
        <field name="email" col-name="emailaddress" type="long-varchar"/>
        <field name="messageid" type="long-varchar"/>
    </entity>
    <entity entity-name="Notification" table-name="notification" package-name="">
        <field name="id" type="numeric"/>
        <field name="scheme" type="numeric"/>
        <field name="event" type="short-varchar"/>
        <field name="eventTypeId" type="numeric"/>
        <field name="templateId" type="numeric"/>
        <field name="type" col-name="notif_type" type="short-varchar"/>
        <field name="parameter" col-name="notif_parameter" type="short-varchar"/>
    </entity>
    <entity entity-name="DeadLetter" table-name="deadletter" package-name="">
        <field name="id" type="numeric"/>
        <field name="messageId" type="long-varchar"/>
        <field name="lastSeen" type="numeric"/>
        <field name="mailServerId" type="numeric"/>
        <field name="folderName" type="long-varchar"/>
    </entity>
    <entity entity-name="EventType" table-name="jiraeventtype" package-name="">
        <field name="id" type="numeric"/>
        <field name="templateId" type="numeric"/>
        <field name="name" type="long-varchar"/>
        <field name="description" type="very-long"/>
        <field name="type" col-name="event_type" type="short-varchar"/>
    </entity>
    <entity entity-name="PermissionScheme" table-name="permissionscheme" package-name="">
        <field name="id" type="numeric"/>
        <field name="name" type="long-varchar"/>
        <field name="description" type="very-long"/>
    </entity>
    <entity entity-name="PermissionSchemeAttribute" table-name="permissionschemeattribute" package-name="">
        <field name="id" type="numeric"/>
        <field name="scheme" type="numeric"/>
        <field name="attributeKey" type="long-varchar"/>
        <field name="attributeValue" type="very-long"/>
    </entity>
    <entity entity-name="SchemePermissions" table-name="schemepermissions" package-name="">
        <field name="id" type="numeric"/>
        <field name="scheme" type="numeric"/>
        <field name="permission" type="numeric"/>
        <field name="type" col-name="perm_type" type="long-varchar"/>
        <field name="parameter" col-name="perm_parameter" type="long-varchar"/>
        <field name="permissionKey" type="long-varchar"/>
    </entity>
    <entity entity-name="GlobalPermissionEntry" table-name="globalpermissionentry" package-name="">
        <field name="id" type="numeric"/>
        <field name="permission" type="long-varchar"/>
        <field name="group_id" type="long-varchar"/>
    </entity>
    <entity entity-name="LicenseRoleGroup" table-name="licenserolesgroup" package-name="">
        <field name="id" type="numeric"/>
        <field name="licenseRoleName" type="long-varchar"/>
        <field name="groupId" type="long-varchar"/>
        <field name="primaryGroup" type="indicator"/>
    </entity>
    <entity entity-name="LicenseRoleDefault" table-name="licenserolesdefault" package-name="">
        <field name="id" type="numeric"/>
        <field name="licenseRoleName" type="long-varchar"/>
    </entity>
    <entity entity-name="ProductLicense" table-name="productlicense" package-name="">
        <field name="id" type="numeric"/>
        <field name="license" type="extremely-long"/>
    </entity>
    <entity entity-name="IssueSecurityScheme" table-name="issuesecurityscheme" package-name="">
        <field name="id" type="numeric"/>
        <field name="name" type="long-varchar"/>
        <field name="description" type="very-long"/>
        <field name="defaultlevel" type="numeric"/>
    </entity>
    <entity entity-name="SchemeIssueSecurities" table-name="schemeissuesecurities" package-name="">
        <field name="id" type="numeric"/>
        <field name="scheme" type="numeric"/>
        <field name="security" type="numeric"/>
        <field name="type" col-name="sec_type" type="long-varchar"/>
        <field name="parameter" col-name="sec_parameter" type="long-varchar"/>
    </entity>
    <entity entity-name="SchemeIssueSecurityLevels" table-name="schemeissuesecuritylevels" package-name="">
        <field name="id" type="numeric"/>
        <field name="name" type="long-varchar"/>
        <field name="description" type="very-long"/>
        <field name="scheme" type="numeric"/>
    </entity>
    <entity entity-name="FilterSubscription" table-name="filtersubscription" package-name="">
        <field name="id" type="numeric"/>
        <field name="filterID" type="numeric"/>
        <field name="username" type="short-varchar"/>
        <field name="group" col-name="groupname" type="short-varchar"/>
        <field name="lastRun" type="date-time"/>
        <field name="emailOnEmpty" type="very-short"/>
    </entity>
    <entity entity-name="QRTZJobDetails" table-name="qrtz_job_details" package-name="">
        <field name="id" type="numeric"/>
        <field name="jobName" type="long-varchar"/>
        <field name="jobGroup" type="long-varchar"/>
        <field name="className" type="long-varchar"/>
        <field name="isDurable" type="short-varchar"/>
        <field name="isStateful" type="short-varchar"/>
        <field name="requestsRecovery" type="short-varchar"/>
        <field name="jobData" type="long-varchar"/>
    </entity>
    <entity entity-name="QRTZJobListeners" table-name="qrtz_job_listeners" package-name="">
        <field name="id" type="numeric"/>
        <field name="job" type="numeric"/>
        <field name="jobListener" type="long-varchar"/>
    </entity>
    <entity entity-name="QRTZTriggers" table-name="qrtz_triggers" package-name="">
        <field name="id" type="numeric"/>
        <field name="triggerName" type="long-varchar"/>
        <field name="triggerGroup" type="long-varchar"/>
        <field name="job" type="numeric"/>
        <field name="nextFire" type="date-time"/>
        <field name="triggerState" type="long-varchar"/>
        <field name="triggerType" type="short-varchar"/>
        <field name="startTime" type="date-time"/>
        <field name="endTime" type="date-time"/>
        <field name="calendarName" type="long-varchar"/>
        <field name="misfireInstr" type="integer"/>
    </entity>
    <entity entity-name="QRTZSimpleTriggers" table-name="qrtz_simple_triggers" package-name="">
        <field name="id" type="numeric"/>
        <field name="trigger" col-name="trigger_id" type="numeric"/>
        <field name="repeatCount" type="integer"/>
        <field name="repeatInterval" type="numeric"/>
        <field name="timesTriggered" type="integer"/>
    </entity>
    <entity entity-name="QRTZCronTriggers" table-name="qrtz_cron_triggers" package-name="">
        <field name="id" type="numeric"/>
        <field name="trigger" col-name="trigger_id" type="numeric"/>
        <field name="cronExpression" col-name="cronExperssion" type="long-varchar"/>
    </entity>
    <entity entity-name="QRTZTriggerListeners" table-name="qrtz_trigger_listeners" package-name="">
        <field name="id" type="numeric"/>
        <field name="trigger" col-name="trigger_id" type="numeric"/>
        <field name="triggerListener" type="long-varchar"/>
    </entity>
    <entity entity-name="QRTZFiredTriggers" table-name="qrtz_fired_triggers" package-name="">
        <field name="id" type="numeric"/>
        <field name="entryId" type="long-varchar"/>
        <field name="trigger" col-name="trigger_id" type="numeric"/>
        <field name="triggerListener" type="long-varchar"/>
        <field name="firedTime" type="date-time"/>
        <field name="triggerState" type="long-varchar"/>
    </entity>
    <entity entity-name="QRTZCalendars" table-name="qrtz_calendars" package-name="">
        <field name="id" type="numeric"/>
        <field name="calendarName" type="long-varchar"/>
        <field name="calendar" type="very-long"/>
    </entity>
    <entity entity-name="PortalPage" table-name="portalpage" package-name="">
        <field name="id" type="numeric"/>
        <field name="username" type="long-varchar"/>
        <field name="pagename" type="long-varchar"/>
        <field name="description" type="long-varchar"/>
        <field name="sequence" type="numeric"/>
        <field name="favCount" type="numeric"/>
        <field name="layout" type="long-varchar"/>
        <field name="version" col-name="ppversion" type="numeric"/>
    </entity>
    <entity entity-name="PortletConfiguration" table-name="portletconfiguration" package-name="">
        <field name="id" type="numeric"/>
        <field name="portalpage" type="numeric"/>
        <field name="portletId" type="long-varchar"/>
        <field name="columnNumber" type="integer"/>
        <field name="position" col-name="positionseq" type="integer"/>
        <field name="gadgetXml" type="very-long"/>
        <field name="color" type="long-varchar"/>
        <field name="dashboardModuleCompleteKey" type="very-long"/>
    </entity>
    <entity entity-name="GadgetUserPreference" table-name="gadgetuserpreference" package-name="">
        <field name="id" type="numeric"/>
        <field name="portletconfiguration" type="numeric"/>
        <field name="userprefkey" type="long-varchar"/>
        <field name="userprefvalue" type="extremely-long"/>
    </entity>
    <entity entity-name="ExternalGadget" table-name="externalgadget" package-name="">
        <field name="id" type="numeric"/>
        <field name="gadgetXml" type="very-long"/>
    </entity>
    <entity entity-name="UpgradeHistory" table-name="upgradehistory" package-name="">
        <field name="id" type="numeric"/>
        <field name="upgradeclass" type="long-varchar"/>
        <field name="targetbuild" type="long-varchar"/>
        <field name="status" type="long-varchar"/>
        <field name="downgradetaskrequired" type="indicator"/>
    </entity>
    <entity entity-name="UpgradeVersionHistory" table-name="upgradeversionhistory" package-name="">
        <field name="id" type="numeric"/>
        <field name="timeperformed" type="date-time"/>
        <field name="targetbuild" type="long-varchar"/>
        <field name="targetversion" type="long-varchar"/>
    </entity>
    <entity entity-name="UpgradeTaskHistory" table-name="upgradetaskhistory" package-name="">
        <field name="id" type="numeric"/>
        <field name="upgradeTaskFactoryKey" type="long-varchar"/>
        <field name="buildNumber" type="integer"/>
        <field name="status" type="short-varchar"/>
        <field name="upgradeType" type="very-short"/>
    </entity>
    <entity entity-name="UpgradeTaskHistoryAuditLog" table-name="upgradetaskhistoryauditlog" package-name="">
        <field name="id" type="numeric"/>
        <field name="upgradeTaskFactoryKey" type="long-varchar"/>
        <field name="buildNumber" type="integer"/>
        <field name="status" type="short-varchar"/>
        <field name="upgradeType" type="very-short"/>
        <field name="timeperformed" type="date-time"/>
        <field name="action" type="very-short"/>
    </entity>
    <entity entity-name="FieldLayoutScheme" table-name="fieldlayoutscheme" package-name="">
        <field name="id" type="numeric"/>
        <field name="name" type="long-varchar"/>
        <field name="description" type="very-long"/>
    </entity>
    <entity entity-name="FieldLayoutSchemeEntity" table-name="fieldlayoutschemeentity" package-name="">
        <field name="id" type="numeric"/>
        <field name="scheme" type="numeric"/>
        <field name="issuetype" col-name="issuetype" type="long-varchar"/>
        <field name="fieldlayout" type="numeric"/>
    </entity>
    <entity entity-name="FieldLayoutSchemeAssociation" table-name="fieldlayoutschemeassociation" package-name="">
        <field name="id" type="numeric"/>
        <field name="issuetype" type="long-varchar"/>
        <field name="project" type="numeric"/>
        <field name="fieldlayoutscheme" type="numeric"/>
    </entity>
    <entity entity-name="FieldLayout" table-name="fieldlayout" package-name="">
        <field name="id" type="numeric"/>
        <field name="name" type="long-varchar"/>
        <field name="description" type="long-varchar"/>
        <field name="type" col-name="layout_type" type="long-varchar"/>
        <field name="layoutscheme" type="numeric"/>
    </entity>
    <entity entity-name="FieldLayoutItem" table-name="fieldlayoutitem" package-name="">
        <field name="id" type="numeric"/>
        <field name="fieldlayout" type="numeric"/>
        <field name="fieldidentifier" type="long-varchar"/>
        <field name="description" type="very-long"/>
        <field name="verticalposition" type="numeric"/>
        <field name="ishidden" type="short-varchar"/>
        <field name="isrequired" type="short-varchar"/>
        <field name="renderertype" type="long-varchar"/>
    </entity>
    <entity entity-name="ColumnLayout" table-name="columnlayout" package-name="">
        <field name="id" type="numeric"/>
        <field name="username" type="long-varchar"/>
        <field name="searchrequest" type="numeric"/>
    </entity>
    <entity entity-name="ColumnLayoutItem" table-name="columnlayoutitem" package-name="">
        <field name="id" type="numeric"/>
        <field name="columnlayout" type="numeric"/>
        <field name="fieldidentifier" type="long-varchar"/>
        <field name="horizontalposition" type="numeric"/>
    </entity>
    <entity entity-name="FieldScreen" table-name="fieldscreen" package-name="">
        <field name="id" type="numeric"/>
        <field name="name" type="long-varchar"/>
        <field name="description" type="long-varchar"/>
    </entity>
    <entity entity-name="FieldScreenTab" table-name="fieldscreentab" package-name="">
        <field name="id" type="numeric"/>
        <field name="name" type="long-varchar"/>
        <field name="description" type="long-varchar"/>
        <field name="sequence" type="numeric"/>
        <field name="fieldscreen" type="numeric"/>
    </entity>
    <entity entity-name="FieldScreenLayoutItem" table-name="fieldscreenlayoutitem" package-name="">
        <field name="id" type="numeric"/>
        <field name="fieldidentifier" type="long-varchar"/>
        <field name="sequence" type="numeric"/>
        <field name="fieldscreentab" type="numeric"/>
    </entity>
    <entity entity-name="IssueTypeScreenScheme" table-name="issuetypescreenscheme" package-name="">
        <field name="id" type="numeric"/>
        <field name="name" type="long-varchar"/>
        <field name="description" type="long-varchar"/>
    </entity>
    <entity entity-name="IssueTypeScreenSchemeEntity" table-name="issuetypescreenschemeentity" package-name="">
        <field name="id" type="numeric"/>
        <field name="issuetype" type="long-varchar"/>
        <field name="scheme" type="numeric"/>
        <field name="fieldscreenscheme" type="numeric"/>
    </entity>
    <entity entity-name="FieldScreenScheme" table-name="fieldscreenscheme" package-name="">
        <field name="id" type="numeric"/>
        <field name="name" type="long-varchar"/>
        <field name="description" type="long-varchar"/>
    </entity>
    <entity entity-name="FieldScreenSchemeItem" table-name="fieldscreenschemeitem" package-name="">
        <field name="id" type="numeric"/>
        <field name="operation" type="numeric"/>
        <field name="fieldscreen" type="numeric"/>
        <field name="fieldscreenscheme" type="numeric"/>
    </entity>
    <entity entity-name="Permission" table-name="jiraperms" package-name="">
        <field name="id" type="numeric"/>
        <field name="type" col-name="permtype" type="numeric"/>
        <field name="project" col-name="projectid" type="numeric"/>
        <field name="group" col-name="groupname" type="long-varchar"/>
    </entity>
    <entity entity-name="TrustedApplication" table-name="trustedapp" package-name="">
        <field name="id" type="numeric"/>
        <field name="applicationId" type="long-varchar"/>
        <field name="name" type="long-varchar"/>
        <field name="publicKey" type="very-long"/>
        <field name="ipMatch" type="very-long"/>
        <field name="urlMatch" type="very-long"/>
        <field name="timeout" type="numeric"/>
        <field name="created" type="date-time"/>
        <field name="createdBy" type="long-varchar"/>
        <field name="updated" type="date-time"/>
        <field name="updatedBy" type="long-varchar"/>
    </entity>
    <entity entity-name="VersionControl" table-name="versioncontrol" package-name="">
        <field name="id" type="numeric"/>
        <field name="name" col-name="vcsname" type="long-varchar"/>
        <field name="description" col-name="vcsdescription" type="long-varchar"/>
        <field name="type" col-name="vcstype" type="long-varchar"/>
    </entity>
    <entity entity-name="Workflow" table-name="jiraworkflows" package-name="">
        <field name="id" type="numeric"/>
        <field name="name" col-name="workflowname" type="long-varchar"/>
        <field name="creator" col-name="creatorname" type="long-varchar"/>
        <field name="descriptor" type="extremely-long"/>
        <field name="islocked" type="short-varchar"/>
    </entity>
    <entity entity-name="WorkflowStatuses" table-name="jiraworkflowstatuses" package-name="">
        <field name="id" type="numeric"/>
        <field name="status" col-name="status" type="long-varchar"/>
        <field name="parentname" col-name="parentname" type="long-varchar"/>
    </entity>
    <entity entity-name="DraftWorkflow" table-name="jiradraftworkflows" package-name="">
        <field name="id" type="numeric"/>
        <field name="parentname" type="long-varchar"/>
        <field name="descriptor" type="extremely-long"/>
    </entity>
    <entity entity-name="WorkflowScheme" table-name="workflowscheme" package-name="">
        <field name="id" type="numeric"/>
        <field name="name" type="long-varchar"/>
        <field name="description" type="very-long"/>
    </entity>
    <entity entity-name="WorkflowSchemeEntity" table-name="workflowschemeentity" package-name="">
        <field name="id" type="numeric"/>
        <field name="scheme" type="numeric"/>
        <field name="workflow" type="long-varchar"/>
        <field name="issuetype" col-name="issuetype" type="long-varchar"/>
    </entity>
    <entity entity-name="DraftWorkflowScheme" table-name="draftworkflowscheme" package-name="">
        <field name="id" type="numeric"/>
        <field name="name" type="long-varchar"/>
        <field name="description" type="very-long"/>
        <field name="workflowSchemeId" type="numeric"/>
        <field name="lastModifiedDate" type="date-time"/>
        <field name="lastModifiedUser" type="long-varchar"/>
    </entity>
    <entity entity-name="DraftWorkflowSchemeEntity" table-name="draftworkflowschemeentity" package-name="">
        <field name="id" type="numeric"/>
        <field name="scheme" type="numeric"/>
        <field name="workflow" type="long-varchar"/>
        <field name="issuetype" col-name="issuetype" type="long-varchar"/>
    </entity>
    <entity entity-name="ProjectRole" table-name="projectrole" package-name="">
        <field name="id" type="numeric"/>
        <field name="name" type="long-varchar"/>
        <field name="description" type="very-long"/>
    </entity>
    <entity entity-name="ProjectRoleActor" table-name="projectroleactor" package-name="">
        <field name="id" type="numeric"/>
        <field name="pid" type="numeric"/>
        <field name="projectroleid" type="numeric"/>
        <field name="roletype" type="long-varchar"/>
        <field name="roletypeparameter" type="long-varchar"/>
    </entity>
    <entity entity-name="PluginVersion" table-name="pluginversion" package-name="">
        <field name="id" type="numeric"/>
        <field name="name" col-name="pluginname" type="long-varchar"/>
        <field name="key" col-name="pluginkey" type="long-varchar"/>
        <field name="version" col-name="pluginversion" type="long-varchar"/>
        <field name="created" type="date-time"/>
    </entity>
    <entity entity-name="PluginState" table-name="pluginstate" package-name="">
        <field name="key" col-name="pluginkey" type="long-varchar"/>
        <field name="enabled" col-name="pluginenabled" type="short-varchar"/>
    </entity>
    <entity entity-name="FavouriteAssociations" table-name="favouriteassociations" package-name="">
        <field name="id" type="numeric"/>
        <field name="username" type="long-varchar"/>
        <field name="entityType" col-name="entitytype" type="short-varchar"/>
        <field name="entityId" col-name="entityid" type="numeric"/>
        <field name="sequence" type="numeric"/>
    </entity>
    <entity entity-name="SharePermissions" table-name="sharepermissions" package-name="">
        <field name="id" type="numeric"/>
        <field name="entityId" col-name="entityid" type="numeric"/>
        <field name="entityType" col-name="entitytype" type="short-varchar"/>
        <field name="type" col-name="sharetype" type="very-short"/>
        <field name="param1" type="long-varchar"/>
        <field name="param2" type="short-varchar"/>
        <field name="rights" type="integer"/>
    </entity>
    <entity entity-name="Avatar" table-name="avatar" package-name="">
        <field name="id" type="numeric"/>
        <field name="fileName" col-name="filename" type="long-varchar"/>
        <field name="contentType" col-name="contenttype" type="long-varchar"/>
        <field name="avatarType" col-name="avatartype" type="short-varchar"/>
        <field name="owner" col-name="owner" type="long-varchar"/>
        <field name="systemAvatar" col-name="systemavatar" type="integer"/>
    </entity>
    <entity entity-name="OAuthConsumerToken" table-name="oauthconsumertoken" package-name="">
        <field name="id" type="numeric"/>
        <field name="created" type="date-time"/>
        <field name="tokenKey" type="long-varchar"/>
        <field name="token" type="long-varchar"/>
        <field name="tokenSecret" type="long-varchar"/>
        <field name="tokenType" type="short-varchar"/>
        <field name="consumerKey" type="long-varchar"/>
    </entity>
    <entity entity-name="OAuthConsumer" table-name="oauthconsumer" package-name="">
        <field name="id" type="numeric"/>
        <field name="created" type="date-time"/>
        <field name="name" col-name="consumername" type="long-varchar"/>
        <field name="consumerKey" type="long-varchar"/>
        <field name="service" col-name="consumerservice" type="long-varchar"/>
        <field name="publicKey" type="very-long"/>
        <field name="privateKey" type="very-long"/>
        <field name="description" type="very-long"/>
        <field name="callback" type="very-long"/>
        <field name="signatureMethod" type="short-varchar"/>
        <field name="sharedSecret" type="very-long"/>
    </entity>
    <entity entity-name="OAuthServiceProviderConsumer" table-name="oauthspconsumer" package-name="">
        <field name="id" type="numeric"/>
        <field name="created" type="date-time"/>
        <field name="consumerKey" type="long-varchar"/>
        <field name="name" col-name="consumername" type="long-varchar"/>
        <field name="publicKey" type="very-long"/>
        <field name="description" type="very-long"/>
        <field name="callback" type="very-long"/>
        <field name="twoLOAllowed" type="short-varchar"/>
        <field name="executingTwoLOUser" type="long-varchar"/>
        <field name="twoLOImpersonationAllowed" type="short-varchar"/>
        <field name="threeLOAllowed" type="short-varchar"/>
    </entity>
    <entity entity-name="OAuthServiceProviderToken" table-name="oauthsptoken" package-name="">
        <field name="id" type="numeric"/>
        <field name="created" type="date-time"/>
        <field name="token" type="long-varchar"/>
        <field name="tokenSecret" type="long-varchar"/>
        <field name="tokenType" type="short-varchar"/>
        <field name="consumerKey" type="long-varchar"/>
        <field name="username" type="long-varchar"/>
        <field name="ttl" type="numeric"/>
        <field name="auth" col-name="spauth" type="short-varchar"/>
        <field name="callback" type="very-long"/>
        <field name="verifier" col-name="spverifier" type="long-varchar"/>
        <field name="version" col-name="spversion" type="short-varchar"/>
        <field name="sessionHandle" type="long-varchar"/>
        <field name="sessionCreationTime" type="date-time"/>
        <field name="sessionLastRenewalTime" type="date-time"/>
        <field name="sessionTimeToLive" type="date-time"/>
    </entity>
    <entity entity-name="RememberMeToken" table-name="remembermetoken" package-name="">
        <field name="id" type="numeric"/>
        <field name="created" type="date-time"/>
        <field name="token" type="long-varchar"/>
        <field name="username" type="long-varchar"/>
    </entity>
    <entity entity-name="VoteHistory" table-name="votehistory" package-name="">
        <field name="id" type="numeric"/>
        <field name="issue" col-name="issueid" type="numeric"/>
        <field name="votes" type="numeric"/>
        <field name="timestamp" type="date-time"/>
    </entity>
    <entity entity-name="ManagedConfigurationItem" table-name="managedconfigurationitem" package-name="">
        <field name="id" type="numeric"/>
        <field name="itemId" type="long-varchar"/>
        <field name="itemType" type="long-varchar"/>
        <field name="managed" type="very-short"/>
        <field name="accessLevel" type="long-varchar"/>
        <field name="source" type="long-varchar"/>
        <field name="descriptionKey" type="long-varchar"/>
    </entity>
    <entity entity-name="Feature" table-name="feature" package-name="">
        <field name="id" type="numeric"/>
        <field name="featureName" type="long-varchar"/>
        <field name="featureType" type="very-short"/>
        <field name="userKey" type="long-varchar"/>
    </entity>
    <entity entity-name="ReplicatedIndexOperation" table-name="replicatedindexoperation" package-name="">
        <field name="id" type="numeric"/>
        <field name="indexTime" type="date-time"/>
        <field name="nodeId" type="short-varchar"/>
        <field name="affectedIndex" type="short-varchar"/>
        <field name="entityType" type="short-varchar"/>
        <field name="affectedIds" type="extremely-long"/>
        <field name="operation" type="short-varchar"/>
        <field name="filename" type="long-varchar"/>
    </entity>
    <entity entity-name="NodeIndexCounter" table-name="nodeindexcounter" package-name="">
        <field name="id" type="numeric"/>
        <field name="nodeId" type="short-varchar"/>
        <field name="sendingNodeId" type="short-varchar"/>
        <field name="indexOperationId" type="numeric"/>
    </entity>
    <entity entity-name="ClusterMessage" table-name="clustermessage" package-name="">
        <field name="id" type="numeric"/>
        <field name="sourceNode" type="short-varchar"/>
        <field name="destinationNode" type="short-varchar"/>
        <field name="claimedByNode" type="short-varchar"/>
        <field name="message" type="long-varchar"/>
        <field name="messageTime" type="date-time"/>
    </entity>
    <entity entity-name="ClusterNode" table-name="clusternode" package-name="">
        <field name="nodeId" type="short-varchar"/>
        <field name="nodeState" type="short-varchar"/>
        <field name="timestamp" type="numeric"/>
        <field name="ip" type="short-varchar"/>
        <field name="cacheListenerPort" type="numeric"/>
        <field name="nodeBuildNumber" type="numeric"/>
        <field name="nodeVersion" type="short-varchar"/>
    </entity>
    <entity entity-name="ClusterLockStatus" table-name="clusterlockstatus" package-name="">
        <field name="id" type="numeric"/>
        <field name="lockName" type="long-varchar"/>
        <field name="lockedByNode" type="short-varchar"/>
        <field name="updateTime" type="numeric"/>
    </entity>
    <entity entity-name="ClusterNodeHeartbeat" table-name="clusternodeheartbeat" package-name="">
        <field name="nodeId" type="short-varchar"/>
        <field name="heartbeatTime" type="numeric"/>
        <field name="databaseTime" type="numeric"/>
    </entity>
    <entity entity-name="ClusterUpgradeState" table-name="clusterupgradestate" package-name="">
        <field name="id" type="numeric"/>
        <field name="databaseTime" type="numeric"/>
        <field name="clusterBuildNumber" type="numeric"/>
        <field name="clusterVersion" type="short-varchar"/>
        <field name="state" type="short-varchar"/>
        <field name="orderNumber" type="numeric"/>
    </entity>
    <entity entity-name="RunDetails" table-name="rundetails" package-name="">
        <field name="id" type="numeric"/>
        <field name="jobId" type="long-varchar"/>
        <field name="startTime" type="date-time"/>
        <field name="runDuration" type="numeric"/>
        <field name="runOutcome" type="indicator"/>
        <field name="infoMessage" type="long-varchar"/>
    </entity>
    <entity entity-name="ClusteredJob" table-name="clusteredjob" package-name="">
        <field name="id" type="numeric"/>
        <field name="jobId" type="long-varchar"/>
        <field name="jobRunnerKey" type="long-varchar"/>
        <field name="schedType" type="indicator"/>
        <field name="intervalMillis" type="numeric"/>
        <field name="firstRun" type="numeric"/>
        <field name="cronExpression" type="long-varchar"/>
        <field name="timeZone" type="short-varchar"/>
        <field name="nextRun" type="numeric"/>
        <field name="version" type="numeric"/>
        <field name="parameters" type="byte-array"/>
    </entity>
    <entity entity-name="JQRTZJobDetails" table-name="JQUARTZ_JOB_DETAILS" package-name="">
        <field name="schedName" col-name="SCHED_NAME" type="quartz-char-120"/>
        <field name="jobName" col-name="JOB_NAME" type="quartz-char-200"/>
        <field name="jobGroup" col-name="JOB_GROUP" type="quartz-char-200"/>
        <field name="Description" col-name="DESCRIPTION" type="quartz-char-250"/>
        <field name="className" col-name="JOB_CLASS_NAME" type="quartz-char-250"/>
        <field name="isDurable" col-name="IS_DURABLE" type="quartz-boolean"/>
        <field name="isVolatile" col-name="IS_VOLATILE" type="quartz-boolean"/>
        <field name="isStateful" col-name="IS_STATEFUL" type="quartz-boolean"/>
        <field name="isNonconcurrent" col-name="IS_NONCONCURRENT" type="quartz-boolean"/>
        <field name="isUpdateData" col-name="IS_UPDATE_DATA" type="quartz-boolean"/>
        <field name="requestsRecovery" col-name="REQUESTS_RECOVERY" type="quartz-boolean"/>
        <field name="jobData" col-name="JOB_DATA" type="quartz-data"/>
    </entity>
    <entity entity-name="JQRTZJobListeners" table-name="JQUARTZ_JOB_LISTENERS" package-name="">
        <field name="jobName" col-name="JOB_NAME" type="quartz-char-200"/>
        <field name="jobGroup" col-name="JOB_GROUP" type="quartz-char-200"/>
        <field name="jobListener" col-name="JOB_LISTENER" type="quartz-char-200"/>
    </entity>
    <entity entity-name="JQRTZTriggers" table-name="JQUARTZ_TRIGGERS" package-name="">
        <field name="schedName" col-name="SCHED_NAME" type="quartz-char-120"/>
        <field name="triggerName" col-name="TRIGGER_NAME" type="quartz-char-200"/>
        <field name="triggerGroup" col-name="TRIGGER_GROUP" type="quartz-char-200"/>
        <field name="jobName" col-name="JOB_NAME" type="quartz-char-200"/>
        <field name="jobGroup" col-name="JOB_GROUP" type="quartz-char-200"/>
        <field name="isVolatile" col-name="IS_VOLATILE" type="quartz-boolean"/>
        <field name="description" col-name="DESCRIPTION" type="quartz-char-250"/>
        <field name="nextFireTime" col-name="NEXT_FIRE_TIME" type="quartz-long-int"/>
        <field name="prevFireTime" col-name="PREV_FIRE_TIME" type="quartz-long-int"/>
        <field name="priority" col-name="PRIORITY" type="quartz-int"/>
        <field name="triggerState" col-name="TRIGGER_STATE" type="quartz-char-16"/>
        <field name="triggerType" col-name="TRIGGER_TYPE" type="quartz-char-8"/>
        <field name="startTime" col-name="START_TIME" type="quartz-long-int"/>
        <field name="endTime" col-name="END_TIME" type="quartz-long-int"/>
        <field name="calendarName" col-name="CALENDAR_NAME" type="quartz-char-200"/>
        <field name="misfireInstr" col-name="MISFIRE_INSTR" type="quartz-small-int"/>
        <field name="jobData" col-name="JOB_DATA" type="quartz-data"/>
    </entity>
    <entity entity-name="JQRTZSimpleTriggers" table-name="JQUARTZ_SIMPLE_TRIGGERS" package-name="">
        <field name="schedName" col-name="SCHED_NAME" type="quartz-char-120"/>
        <field name="triggerName" col-name="TRIGGER_NAME" type="quartz-char-200"/>
        <field name="triggerGroup" col-name="TRIGGER_GROUP" type="quartz-char-200"/>
        <field name="repeatCount" col-name="REPEAT_COUNT" type="quartz-long-int"/>
        <field name="repeatInterval" col-name="REPEAT_INTERVAL" type="quartz-long-int"/>
        <field name="timesTriggered" col-name="TIMES_TRIGGERED" type="quartz-long-int"/>
    </entity>
    <entity entity-name="JQRTZCronTriggers" table-name="JQUARTZ_CRON_TRIGGERS" package-name="">
        <field name="schedName" col-name="SCHED_NAME" type="quartz-char-120"/>
        <field name="triggerName" col-name="TRIGGER_NAME" type="quartz-char-200"/>
        <field name="triggerGroup" col-name="TRIGGER_GROUP" type="quartz-char-200"/>
        <field name="cronExpression" col-name="CRON_EXPRESSION" type="quartz-char-120"/>
        <field name="timeZoneId" col-name="TIME_ZONE_ID" type="quartz-char-80"/>
    </entity>
    <entity entity-name="JQRTZSimplePropTriggers" table-name="JQUARTZ_SIMPROP_TRIGGERS" package-name="">
        <field name="schedName" col-name="SCHED_NAME" type="quartz-char-120"/>
        <field name="triggerName" col-name="TRIGGER_NAME" type="quartz-char-200"/>
        <field name="triggerGroup" col-name="TRIGGER_GROUP" type="quartz-char-200"/>
        <field name="str_prop_1" col-name="STR_PROP_1" type="quartz-char-512"/>
        <field name="str_prop_2" col-name="STR_PROP_2" type="quartz-char-512"/>
        <field name="str_prop_3" col-name="STR_PROP_3" type="quartz-char-512"/>
        <field name="int_prop_1" col-name="INT_PROP_1" type="quartz-int"/>
        <field name="int_prop_2" col-name="INT_PROP_2" type="quartz-int"/>
        <field name="long_prop_1" col-name="LONG_PROP_1" type="quartz-long-int"/>
        <field name="long_prop_2" col-name="LONG_PROP_2" type="quartz-long-int"/>
        <field name="dec_prop_1" col-name="DEC_PROP_1" type="quartz-numeric"/>
        <field name="dec_prop_2" col-name="DEC_PROP_2" type="quartz-numeric"/>
        <field name="bool_prop_1" col-name="BOOL_PROP_1" type="quartz-boolean"/>
        <field name="bool_prop_2" col-name="BOOL_PROP_2" type="quartz-boolean"/>
    </entity>
    <entity entity-name="JQRTZBlobTriggers" table-name="JQUARTZ_BLOB_TRIGGERS" package-name="">
        <field name="schedName" col-name="SCHED_NAME" type="quartz-char-120"/>
        <field name="triggerName" col-name="TRIGGER_NAME" type="quartz-char-200"/>
        <field name="triggerGroup" col-name="TRIGGER_GROUP" type="quartz-char-200"/>
        <field name="blobData" col-name="BLOB_DATA" type="quartz-data"/>
    </entity>
    <entity entity-name="JQRTZTriggerListeners" table-name="JQUARTZ_TRIGGER_LISTENERS" package-name="">
        <field name="triggerName" col-name="TRIGGER_NAME" type="quartz-char-200"/>
        <field name="triggerGroup" col-name="TRIGGER_GROUP" type="quartz-char-200"/>
        <field name="triggerListener" col-name="TRIGGER_LISTENER" type="quartz-char-200"/>
    </entity>
    <entity entity-name="JQRTZCalendars" table-name="JQUARTZ_CALENDARS" package-name="">
        <field name="schedName" col-name="SCHED_NAME" type="quartz-char-120"/>
        <field name="calendarName" col-name="CALENDAR_NAME" type="quartz-char-200"/>
        <field name="calendar" col-name="CALENDAR" type="quartz-data"/>
    </entity>
    <entity entity-name="JQRTZPausedTriggerGroups" table-name="JQUARTZ_PAUSED_TRIGGER_GRPS" package-name="">
        <field name="schedName" col-name="SCHED_NAME" type="quartz-char-120"/>
        <field name="triggerGroup" col-name="TRIGGER_GROUP" type="quartz-char-200"/>
    </entity>
    <entity entity-name="JQRTZFiredTriggers" table-name="JQUARTZ_FIRED_TRIGGERS" package-name="">
        <field name="schedName" col-name="SCHED_NAME" type="quartz-char-120"/>
        <field name="entryId" col-name="ENTRY_ID" type="quartz-char-95"/>
        <field name="triggerName" col-name="TRIGGER_NAME" type="quartz-char-200"/>
        <field name="triggerGroup" col-name="TRIGGER_GROUP" type="quartz-char-200"/>
        <field name="isVolatile" col-name="IS_VOLATILE" type="quartz-boolean"/>
        <field name="instanceName" col-name="INSTANCE_NAME" type="quartz-char-200"/>
        <field name="firedTime" col-name="FIRED_TIME" type="quartz-long-int"/>
        <field name="schedTime" col-name="SCHED_TIME" type="quartz-long-int"/>
        <field name="priority" col-name="PRIORITY" type="quartz-int"/>
        <field name="triggerState" col-name="STATE" type="quartz-char-16"/>
        <field name="jobName" col-name="JOB_NAME" type="quartz-char-200"/>
        <field name="jobGroup" col-name="JOB_GROUP" type="quartz-char-200"/>
        <field name="isStateful" col-name="IS_STATEFUL" type="quartz-boolean"/>
        <field name="isNonconcurrent" col-name="IS_NONCONCURRENT" type="quartz-boolean"/>
        <field name="isUpdateData" col-name="IS_UPDATE_DATA" type="quartz-boolean"/>
        <field name="requestsRecovery" col-name="REQUESTS_RECOVERY" type="quartz-boolean"/>
    </entity>
    <entity entity-name="JQRTZSchedulerState" table-name="JQUARTZ_SCHEDULER_STATE" package-name="">
        <field name="schedName" col-name="SCHED_NAME" type="quartz-char-120"/>
        <field name="instanceName" col-name="INSTANCE_NAME" type="quartz-char-200"/>
        <field name="lastCheckinTime" col-name="LAST_CHECKIN_TIME" type="quartz-long-int"/>
        <field name="checkinInterval" col-name="CHECKIN_INTERVAL" type="quartz-long-int"/>
    </entity>
    <entity entity-name="JQRTZLocks" table-name="JQUARTZ_LOCKS" package-name="">
        <field name="schedName" col-name="SCHED_NAME" type="quartz-char-120"/>
        <field name="lockName" col-name="LOCK_NAME" type="quartz-char-40"/>
    </entity>
    <entity entity-name="AuditLog" table-name="audit_log" package-name="">
        <field name="id" type="numeric"/>
        <field name="remoteAddress" type="short-varchar"/>
        <field name="created" type="date-time"/>
        <field name="authorKey" type="long-varchar"/>
        <field name="summary" type="long-varchar"/>
        <field name="category" type="long-varchar"/>
        <field name="objectType" type="short-varchar"/>
        <field name="objectId" type="long-varchar"/>
        <field name="objectName" type="long-varchar"/>
        <field name="objectParentId" type="long-varchar"/>
        <field name="objectParentName" type="long-varchar"/>
        <field name="authorType" type="integer"/>
        <field name="eventSourceName" type="long-varchar"/>
        <field name="description" type="long-varchar"/>
        <field name="longDescription" type="extremely-long"/>
        <field name="searchField" type="extremely-long"/>
    </entity>
    <entity entity-name="AuditItem" table-name="audit_item" package-name="">
        <field name="id" type="numeric"/>
        <field name="logId" type="numeric"/>
        <field name="objectType" type="short-varchar"/>
        <field name="objectId" type="long-varchar"/>
        <field name="objectName" type="long-varchar"/>
        <field name="objectParentId" type="long-varchar"/>
        <field name="objectParentName" type="long-varchar"/>
    </entity>
    <entity entity-name="AuditChangedValue" table-name="audit_changed_value" package-name="">
        <field name="id" type="numeric"/>
        <field name="logId" type="numeric"/>
        <field name="name" type="long-varchar"/>
        <field name="deltaFrom" type="extremely-long"/>
        <field name="deltaTo" type="extremely-long"/>
    </entity>
    <entity entity-name="ReindexRequest" table-name="reindex_request" package-name="">
        <field name="id" type="numeric"/>
        <field name="type" type="short-varchar"/>
        <field name="requestTime" type="date-time"/>
        <field name="startTime" type="date-time"/>
        <field name="completionTime" type="date-time"/>
        <field name="status" type="short-varchar"/>
        <field name="executionNodeId" type="short-varchar"/>
        <field name="query" type="very-long"/>
    </entity>
    <entity entity-name="ReindexComponent" table-name="reindex_component" package-name="">
        <field name="id" type="numeric"/>
        <field name="requestId" type="numeric"/>
        <field name="affectedIndex" type="short-varchar"/>
        <field name="entityType" type="short-varchar"/>
    </entity>
    <entity entity-name="TempAttachmentsMonitor" table-name="tempattachmentsmonitor" package-name="">
        <field name="temporaryAttachmentId" type="long-varchar"/>
        <field name="formToken" type="long-varchar"/>
        <field name="fileName" type="long-varchar"/>
        <field name="contentType" type="long-varchar"/>
        <field name="fileSize" type="numeric"/>
        <field name="createdTime" type="numeric"/>
    </entity>
</entitymodel>


GET-ting this endpoint has no side-effects - it is a read only operation.

This method is a way of previewing the results of a key-translation operation before actually applying it via calling POST against the same URL.

Translating keys
POST http://[jira]/rest/internal/2/retranslatekeys/[tableOrEntityName]/[columnOrFieldName]?key=[some.untranslated.key]


Returns the results of replacing all occurrences of key with its default Jira i18n translation in the table and column specified by tableOrEntityName and columnOrFieldNamePOST-ing to this endpoint means that the transformations are applied to the database and overwrite the original text. Clients should first call GET against this same URL to check the expected translations without actually writing them out to the database. Read Dry Run section first.

Triggering this endpoint will also clear some internal Jira caches. Note that it is possible that a untranslated key is still cached at a plugin level cache. If the key was successfully translated in the database but the changes are not visible on the UI a restart of Jira Server may be required.

Examples

To retranslate key: my.untranslated.key present in the entity: CustomField in field: description run the following query against your Jira instance (or any node in DC):

GET http://[jira]/rest/internal/2/retranslatekeys/CustomField/description?key=my.untranslated.key

This will show the result of re-translating my.untranslated.key in the entity: CustomField in field: description. To apply this change run again the query above with POST.

To retranslate key: my.untranslated.key present in the active object table: AO_ABCDE_TEAM in field: NAME run the following query against your Jira instance (or any node in DC):

GET http://[jira]/rest/internal/2/retranslatekeys/AO_ABCDE_TEAM/NAME?key=my.untransltated.key

This will show the result of re-translating my.untranslated.key in the active object table: AO_ABCDE_TEAM in field: NAME. To apply this change run again the query above with POST.

Last modified on Nov 23, 2020

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.