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 nonnull 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.
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.
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...
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