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 planning to store additional user's attributes in Crowd. The max size for the attribute in Crowd right now is only 255 characters. We need to store up to 2000 characters. I updated the DB table and Crowd seems accept the attribute with larger size fine.
alter table cwd_user_attribute modify (attribute_value varchar2(2000));
alter table cwd_user_attribute modify (attribute_lower_value varchar2(2000));
Only a small number of users will have this attribute so I'm not concerning about performance hit. Will this change cause an upgrade issue later on? Are those attributes going to get truncated back to 255 chars.
I believe we will not have problems regarding the column types, however we cannot guarantee that changes in the database model will occur on the newest versions, which can truncate your data. Even though you can perform the customizations, and bear in mind that that some manual procedures will be necessary during the upgrade process to avoid loss of data on those columns.
Cheers!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.