You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
Next: Root
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
The Atlassian Community can help you and your team get more value out of Atlassian products and practices.
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.
Marina
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.
Marina.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.