CMS_User table - Update Column types

Brian Abel asked on August 12, 2021 21:12

We have made a change to our site and we have a customer number that is changing from int to bigint. the dbo.CMS_User table currently has the customer number as int.
How can I change that to bigint?

cmsuser

Correct Answer

Dmitry Bastron answered on August 13, 2021 06:32

Hi Brian,

Since there is no "customer number" field in the default CMS_User table I'd guess this was a custom field added to User entity. To amend this field's type you'd need:

go to Modules application
select module Membership
switch to Classes tab on the left menu
edit User class
switch to Fields tab and select your "customer number" field
change it's Data type from Integer number to Long integer number
amend your code working with this field to write bigint values

3 votesVote for this answer Unmark Correct answer

Recent Answers

Sean Wright answered on August 14, 2021 19:12

I definitely recommend Dmitry's approach.

Changing the built-in column to a different type will break the application.

Instead, add a new custom field (easy to do, doesn't affect the platforms functionality, and is upgrade proof) and add business logic to use it where appropriate.

2 votesVote for this answer Mark as a Correct answer