Tables (that contain issues) in Jira Database

Question

All:

After installation of JIRA (6.1.2) on linux server (Suse 11) with SQL server 2008 R2 backend.

The database was called "jiradb"

I created a  project "Atlassian Jira Test Project" and 2 issues AJTP-1 and AJTP-2 in JIRA

Which tables in the database "jiradb" contain the info about this project  and the issues created.

Thanks for your help.

Bzoo

Bill Mariasoosa · Answer

Hi Nic:

The above link contains really  a lot of information I need.

Thanks & Regards,

Bzoo

Nic Brough -Adaptavist- · Answer

Although you've now been given the table you asked about, I suspect you're going to look at it and find it doesn't contain what you think it does and you're going to ask for more.

Before you do, have a look at https://developer.atlassian.com/display/JIRADEV/Database+Schema

Bill Mariasoosa · Answer

Hi Steve:

Thanks for your info. Based on your reply, I figured out.

The name of the table is dbo.jiraissue in my SQL SERVER 2008 R2

Thanks again

Bzoo