Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Adding index and Not Null to existing table causing problems.


We are currently going through the Atlassian Data Center app readiness checklist and are a little confused by what is required for Questions 89, 90, and 91 - Database: Additional Tables

We found that we did require indexes on our additional tables, which works fine. However, when we add a NOT NULL constraint to the indexed fields, on updating the app in the host application the existing tables are dropped, recreated and all data is gone. Obviously, this is not suitable for our existing customers. 

This does not happen if we only add the Index and no further constraint. 

So this leads me to ask, is the NOT NULL constraint for an indexed column absolutely necessary?

Question 89 is:

Does your app have indexes defined on the fields that are used in frequent queries? *
I now can answer Yes to this. 

Now, reading question 90 of the checklist:

 Does your app have non­null constraints and unique constraints to guarantee? *

I read this to be asking, does your app have nonnull constraints and unique constraints to guarantee the index of the previous question. 

Is this how others are reading it? This is what led me to believe the NOT NULL constraint goes hand in hand with the index. 

Any advice or previous experience would be greatly appreciated. 


1 answer

0 votes

For a bit more context (I've got three ways I could be reading the question), could you tell us what "DC Checklist" you are using?  Typing some of the phrases you have used into google does not land me on any documentation, so I'm a bit lost on what you're reading.

Hi Nic

I'm referring to the Atlassian Data Center app readiness checklist.

It was originally a google form. 



Like Nic Brough _Adaptavist_ likes this

Thanks, that's cleared up what I suspected - it's not something I have run into myself (I've not written DC apps).  But it saves us suffering the other essay-like answers that don't apply!

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Data Center

Architect your Atlassian Data Center Application (Jira, Confluence, Bitbucket) in Azure

Hello folks! To the member of organizations who are still running their Atlassian applications on the server, we are on the side of the bridge, and if we need to sail the boat with confidence either...

588 views 0 11
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you