Increase the limit for the table usrgrp field 'name' from 64 chars to 128 chars

XMLWordPrintable

    • Sprint candidates

      Currently in the schema we have the limit for the group name field with max of 64 characters.

      In some cases - when e.g. the groups are synced with SAML, this might be not enough, and there's a request to increase the limit of the 'name' field to e.g. 128 chars.

      zabbix=> \d usrgrp
                                       Table "public.usrgrp"
           Column      |         Type          | Collation | Nullable |        Default        
      -----------------+-----------------------+-----------+----------+-----------------------
       usrgrpid        | bigint                |           | not null | 
       name            | character varying(64) |           | not null | ''::character varying
       gui_access      | integer               |           | not null | 0
       users_status    | integer               |           | not null | 0
       debug_mode      | integer               |           | not null | 0
       userdirectoryid | bigint                |           |          | 
       mfa_status      | integer               |           | not null | 0
       mfaid           | bigint                |           |          | 

            Assignee:
            Zabbix Development Team
            Reporter:
            Piotr Zakrzewski
            Team C
            Votes:
            1 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated: