categories table: ugno* fields too short!

[tektsu]

I have PhotoPost integrated with VBulletin3. In VB3, I have a large number of usergroups, and in Photopost, I have some categories which should not be seen by people in a majority of user groups.

It hasn't happened yet, but the problem I see coming up is that the ugno* fields in the categories table are varchar(255), and soon that will not be large enough to hold the complete lists of usergroup ids that need to be there.

On my test system, I have changed these 5 fields to text fields, and everything seems to work ok. Is this a good fix, or is that likely to cause problems somewhere down the line?

Thanks

[Chuck S]

You can do that should you choose. If it needs to be more than 255 you must really have a ton of usergroups as the current field would allow 81 usergroups.

[tektsu]

Originally Posted by Chuck S

If it needs to be more than 255 you must really have a ton of usergroups as the current field would allow 81 usergroups.

Fewer than 81 over time, actually. I do have a ton of usergroups, and I also create temporary usergroups fairly often. Of course, usergroup ids don't get reused, so it won't be too long before I have a bunch of 4-digit ids, putting a further crimp in the available space!

The text fields have been working well so far.

Thanks!

[Chuck S]

well the current field will house as stated 81 before the space is up.