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.
This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.Read more
Do you own more than one Server or Data Center product? Do you have challenges provisioning users across your Atlassian products? Are you spending a lot of time integrating each Atlassian product wit...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs