JIRA 4.0 : JIRA 3.7 Database Schema Changes
This page last changed on Dec 17, 2006 by anton@atlassian.com.
Due to the upgrade of HSQLDB, and to improve compatibility with Firebird and Frontbase, various database tables and columns have been renamed. 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. TablesThe following database table has been renamed:
ColumnsThe following database columns have been renamed. Their old and new names, as well as the database table they belong to are shown below:
Special note for MS SQL ServerAdditionally to the schema changes described above, for MS SQL Server, all columns of type TEXT have been changed to NTEXT to ensure that international characters can be safely stored. |
![]() |
Document generated by Confluence on Oct 06, 2009 00:27 |