AO tables in the Jira native database

Owned by Pablo Beltran (Unlicensed)
Last updated: Oct 05, 2018

The Java H2 database instance used to store Subversion data internally has been replaced by Atlassian's Active Objects in Subversion ALM 7.0 and above. Therefore, data are now stored in the JIRA native database (Oracle, PostgreSQL, MySQL, MS SQL Server). All the plugin's tables start with the AO_2B6364_SVN prefix and they are listed in:

JIRA > Adminsitration > System > Advanced > Plugin Data Storage > Subversion ALM (plugin) 

This is a brief description for each table:

  • AO_2B6364_SVN_APP_CONF: General plugin configuration
  • AO_2B6364_SVN_REPOSITORY: The main information about the registered Subversion repositories
  • AO_2B6364_SVN_REPOSITORY_CONF: Polarion Web Client for Subversion configuration
  • AO_2B6364_SVN_REVISION: All the scanned revisions for all the registered repositories above
  • AO_2B6364_SVN_COMMENT: The commit message for each revision
  • AO_2B6364_SVN_ITEM: All the versioned item names (files and directories) for all the registered Subversion repositories
  • AO_2B6364_SVN_ACTION: All the actions (Added, Modified, Deleted or Replaced) on a particular item and revision
  • AO_2B6364_SVN_COPY: All the branches for all the items
  • AO_2B6364_SVN_ISSUE: All the JIRA issue keys related to some revision
  • AO_2B6364_SVN_AUX: Internal usage.