Extend table sysmaps_elements to support icons with names longer then 32 chars

[Andreas Bollhalder]

Hello

Hope I'm not doubling an already known problem.

On Zabbix 1.1.6 with mysql, I wasn't able to use an icon with a name larger then 32 characters in the maps.

The problem is in the table "sysmaps_elements", columns "icon" and "icon_on". They are of type "varchar(32)" while the corresponding column "name" in the table "images" is of "varchar(64)".

Extending the type in mysql helps here:

alter table sysmaps_elements modify icon varchar(64) not null default 'Server';
alter table sysmaps_elements modify icon_on varchar(64) not null default 'Server';

Sincerly

Andreas Bollhalder