alter table zabbix.actions modify column esc_period varchar(255) character set utf8 collate utf8_bin default '1h'  not null ;
alter table zabbix.actions modify column def_shortdata varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.actions modify column def_longdata text character set utf8 collate utf8_bin not null ;
alter table zabbix.actions modify column r_shortdata varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.actions modify column r_longdata text character set utf8 collate utf8_bin not null ;
alter table zabbix.actions modify column formula varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.actions modify column ack_shortdata varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.actions modify column ack_longdata text character set utf8 collate utf8_bin not null ;
alter table zabbix.applications modify column name varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.auditlog modify column details varchar(128) character set utf8 collate utf8_bin default '0'  not null ;
alter table zabbix.auditlog modify column ip varchar(39) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.auditlog modify column resourcename varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.auditlog_details modify column table_name varchar(64) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.auditlog_details modify column field_name varchar(64) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.auditlog_details modify column oldvalue text character set utf8 collate utf8_bin not null ;
alter table zabbix.auditlog_details modify column newvalue text character set utf8 collate utf8_bin not null ;
alter table zabbix.conditions modify column value varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.conditions modify column value2 varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.config modify column refresh_unsupported varchar(32) character set utf8 collate utf8_bin default '10m'  not null ;
alter table zabbix.config modify column work_period varchar(255) character set utf8 collate utf8_bin default '1-5,09:00-18:00'  not null ;
alter table zabbix.config modify column default_theme varchar(128) character set utf8 collate utf8_bin default 'blue-theme'  not null ;
alter table zabbix.config modify column ldap_host varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.config modify column ldap_base_dn varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.config modify column ldap_bind_dn varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.config modify column ldap_bind_password varchar(128) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.config modify column ldap_search_attribute varchar(128) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.config modify column severity_color_0 varchar(6) character set utf8 collate utf8_bin default '97AAB3'  not null ;
alter table zabbix.config modify column severity_color_1 varchar(6) character set utf8 collate utf8_bin default '7499FF'  not null ;
alter table zabbix.config modify column severity_color_2 varchar(6) character set utf8 collate utf8_bin default 'FFC859'  not null ;
alter table zabbix.config modify column severity_color_3 varchar(6) character set utf8 collate utf8_bin default 'FFA059'  not null ;
alter table zabbix.config modify column severity_color_4 varchar(6) character set utf8 collate utf8_bin default 'E97659'  not null ;
alter table zabbix.config modify column severity_color_5 varchar(6) character set utf8 collate utf8_bin default 'E45959'  not null ;
alter table zabbix.config modify column severity_name_0 varchar(32) character set utf8 collate utf8_bin default 'Not classified'  not null ;
alter table zabbix.config modify column severity_name_1 varchar(32) character set utf8 collate utf8_bin default 'Information'  not null ;
alter table zabbix.config modify column severity_name_2 varchar(32) character set utf8 collate utf8_bin default 'Warning'  not null ;
alter table zabbix.config modify column severity_name_3 varchar(32) character set utf8 collate utf8_bin default 'Average'  not null ;
alter table zabbix.config modify column severity_name_4 varchar(32) character set utf8 collate utf8_bin default 'High'  not null ;
alter table zabbix.config modify column severity_name_5 varchar(32) character set utf8 collate utf8_bin default 'Disaster'  not null ;
alter table zabbix.config modify column ok_period varchar(32) character set utf8 collate utf8_bin default '5m'  not null ;
alter table zabbix.config modify column blink_period varchar(32) character set utf8 collate utf8_bin default '2m'  not null ;
alter table zabbix.config modify column problem_unack_color varchar(6) character set utf8 collate utf8_bin default 'CC0000'  not null ;
alter table zabbix.config modify column problem_ack_color varchar(6) character set utf8 collate utf8_bin default 'CC0000'  not null ;
alter table zabbix.config modify column ok_unack_color varchar(6) character set utf8 collate utf8_bin default '009900'  not null ;
alter table zabbix.config modify column ok_ack_color varchar(6) character set utf8 collate utf8_bin default '009900'  not null ;
alter table zabbix.config modify column hk_events_trigger varchar(32) character set utf8 collate utf8_bin default '365d'  not null ;
alter table zabbix.config modify column hk_events_internal varchar(32) character set utf8 collate utf8_bin default '1d'  not null ;
alter table zabbix.config modify column hk_events_discovery varchar(32) character set utf8 collate utf8_bin default '1d'  not null ;
alter table zabbix.config modify column hk_events_autoreg varchar(32) character set utf8 collate utf8_bin default '1d'  not null ;
alter table zabbix.config modify column hk_services varchar(32) character set utf8 collate utf8_bin default '365d'  not null ;
alter table zabbix.config modify column hk_audit varchar(32) character set utf8 collate utf8_bin default '365d'  not null ;
alter table zabbix.config modify column hk_sessions varchar(32) character set utf8 collate utf8_bin default '365d'  not null ;
alter table zabbix.config modify column hk_history varchar(32) character set utf8 collate utf8_bin default '90d'  not null ;
alter table zabbix.config modify column hk_trends varchar(32) character set utf8 collate utf8_bin default '365d'  not null ;
alter table zabbix.config modify column http_strip_domains varchar(2048) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.config modify column db_extension varchar(32) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.dchecks modify column key_ varchar(512) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.dchecks modify column snmp_community varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.dchecks modify column ports varchar(255) character set utf8 collate utf8_bin default '0'  not null ;
alter table zabbix.dchecks modify column snmpv3_securityname varchar(64) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.dchecks modify column snmpv3_authpassphrase varchar(64) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.dchecks modify column snmpv3_privpassphrase varchar(64) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.dchecks modify column snmpv3_contextname varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.drules modify column name varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.drules modify column iprange varchar(2048) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.drules modify column delay varchar(255) character set utf8 collate utf8_bin default '1h'  not null ;
alter table zabbix.dservices modify column value varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.dservices modify column ip varchar(39) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.dservices modify column dns varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.events modify column name varchar(2048) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.functions modify column name varchar(12) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.functions modify column parameter varchar(255) character set utf8 collate utf8_bin default '0'  not null ;
alter table zabbix.globalmacro modify column macro varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.globalmacro modify column value varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.globalmacro modify column description text character set utf8 collate utf8_bin not null ;
alter table zabbix.sessions modify column sessionid varchar(32) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.graphs modify column name varchar(128) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.graphs_items modify column color varchar(6) character set utf8 collate utf8_bin default '009600'  not null ;
alter table zabbix.group_discovery modify column name varchar(64) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.alerts modify column sendto varchar(1024) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.alerts modify column subject varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.alerts modify column message text character set utf8 collate utf8_bin not null ;
alter table zabbix.alerts modify column error varchar(2048) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.alerts modify column parameters text character set utf8 collate utf8_bin not null ;
alter table zabbix.screens modify column name varchar(255) character set utf8 collate utf8_bin not null ;
alter table zabbix.history_log modify column source varchar(64) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.history_log modify column value text character set utf8 collate utf8_bin not null ;
alter table zabbix.history_str modify column value varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.history_text modify column value text character set utf8 collate utf8_bin not null ;
alter table zabbix.host_discovery modify column host varchar(128) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.hostmacro modify column macro varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.hostmacro modify column value varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.hostmacro modify column description text character set utf8 collate utf8_bin not null ;
alter table zabbix.hosts modify column host varchar(128) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.hosts modify column error varchar(2048) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.hosts modify column ipmi_username varchar(16) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.hosts modify column ipmi_password varchar(20) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.hosts modify column ipmi_error varchar(2048) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.hosts modify column snmp_error varchar(2048) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.hosts modify column jmx_error varchar(2048) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.hosts modify column name varchar(128) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.hosts modify column description text character set utf8 collate utf8_bin not null ;
alter table zabbix.hosts modify column tls_issuer varchar(1024) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.hosts modify column tls_subject varchar(1024) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.hosts modify column tls_psk_identity varchar(128) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.hosts modify column tls_psk varchar(512) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.hosts modify column proxy_address varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.mappings modify column value varchar(64) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.mappings modify column newvalue varchar(64) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.housekeeper modify column tablename varchar(64) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.housekeeper modify column field varchar(64) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.hstgrp modify column name varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.httpstep modify column name varchar(64) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.httpstep modify column url varchar(2048) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.httpstep modify column timeout varchar(255) character set utf8 collate utf8_bin default '15s'  not null ;
alter table zabbix.httpstep modify column posts text character set utf8 collate utf8_bin not null ;
alter table zabbix.httpstep modify column required varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.httpstep modify column status_codes varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.httptest modify column name varchar(64) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.httptest modify column delay varchar(255) character set utf8 collate utf8_bin default '1m'  not null ;
alter table zabbix.httptest modify column agent varchar(255) character set utf8 collate utf8_bin default 'Zabbix'  not null ;
alter table zabbix.httptest modify column http_user varchar(64) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.httptest modify column http_password varchar(64) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.httptest modify column http_proxy varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.httptest modify column ssl_cert_file varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.httptest modify column ssl_key_file varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.httptest modify column ssl_key_password varchar(64) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.icon_map modify column name varchar(64) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.sysmaps_elements modify column label varchar(2048) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.sysmaps_elements modify column application varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.icon_mapping modify column expression varchar(64) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.ids modify column table_name varchar(64) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.ids modify column field_name varchar(64) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.images modify column name varchar(64) character set utf8 collate utf8_bin default '0'  not null ;
alter table zabbix.interface modify column ip varchar(64) character set utf8 collate utf8_bin default '127.0.0.1'  not null ;
alter table zabbix.interface modify column dns varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.interface modify column port varchar(64) character set utf8 collate utf8_bin default '10050'  not null ;
alter table zabbix.profiles modify column idx varchar(96) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.profiles modify column value_str varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.profiles modify column source varchar(96) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.item_condition modify column macro varchar(64) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.item_condition modify column value varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.item_discovery modify column key_ varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.scripts modify column name varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.scripts modify column command varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.scripts modify column description text character set utf8 collate utf8_bin not null ;
alter table zabbix.scripts modify column confirmation varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.maintenances modify column name varchar(128) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.maintenances modify column description text character set utf8 collate utf8_bin not null ;
alter table zabbix.expressions modify column expression varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.expressions modify column exp_delimiter varchar(1) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.media modify column sendto varchar(1024) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.media modify column period varchar(1024) character set utf8 collate utf8_bin default '1-7,00:00-24:00'  not null ;
alter table zabbix.media_type modify column name varchar(100) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.media_type modify column smtp_server varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.media_type modify column smtp_helo varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.media_type modify column smtp_email varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.media_type modify column exec_path varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.media_type modify column gsm_modem varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.media_type modify column username varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.media_type modify column passwd varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.media_type modify column exec_params varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.media_type modify column attempt_interval varchar(32) character set utf8 collate utf8_bin default '10s'  not null ;
alter table zabbix.media_type modify column script text character set utf8 collate utf8_bin not null ;
alter table zabbix.media_type modify column timeout varchar(32) character set utf8 collate utf8_bin default '30s'  not null ;
alter table zabbix.media_type modify column event_menu_url varchar(2048) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.media_type modify column event_menu_name varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.media_type modify column description text character set utf8 collate utf8_bin not null ;
alter table zabbix.opconditions modify column value varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.operations modify column esc_period varchar(255) character set utf8 collate utf8_bin default '0'  not null ;
alter table zabbix.opcommand modify column port varchar(64) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.opcommand modify column username varchar(64) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.opcommand modify column password varchar(64) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.opcommand modify column publickey varchar(64) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.opcommand modify column privatekey varchar(64) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.opcommand modify column command text character set utf8 collate utf8_bin not null ;
alter table zabbix.triggers modify column expression varchar(2048) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.triggers modify column description varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.triggers modify column url varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.triggers modify column comments text character set utf8 collate utf8_bin not null ;
alter table zabbix.triggers modify column error varchar(2048) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.triggers modify column recovery_expression varchar(2048) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.triggers modify column correlation_tag varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.triggers modify column opdata varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.proxy_dhistory modify column ip varchar(39) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.proxy_dhistory modify column value varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.proxy_dhistory modify column dns varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.proxy_history modify column source varchar(64) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.proxy_history modify column value longtext character set utf8 collate utf8_bin not null ;
alter table zabbix.regexps modify column name varchar(128) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.regexps modify column test_string text character set utf8 collate utf8_bin not null ;
alter table zabbix.services modify column name varchar(128) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.slideshows modify column name varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.slideshows modify column delay varchar(32) character set utf8 collate utf8_bin default '30s'  not null ;
alter table zabbix.slides modify column delay varchar(32) character set utf8 collate utf8_bin default '0'  not null ;
alter table zabbix.opmessage modify column subject varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.opmessage modify column message text character set utf8 collate utf8_bin not null ;
alter table zabbix.services_times modify column note varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.items modify column snmp_community varchar(64) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.items modify column snmp_oid varchar(512) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.items modify column name varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.items modify column key_ varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.items modify column delay varchar(1024) character set utf8 collate utf8_bin default '0'  not null ;
alter table zabbix.items modify column history varchar(255) character set utf8 collate utf8_bin default '90d'  not null ;
alter table zabbix.items modify column trends varchar(255) character set utf8 collate utf8_bin default '365d'  not null ;
alter table zabbix.items modify column trapper_hosts varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.items modify column units varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.items modify column snmpv3_securityname varchar(64) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.items modify column snmpv3_authpassphrase varchar(64) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.items modify column snmpv3_privpassphrase varchar(64) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.items modify column formula varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.items modify column logtimefmt varchar(64) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.items modify column params text character set utf8 collate utf8_bin not null ;
alter table zabbix.items modify column ipmi_sensor varchar(128) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.items modify column username varchar(64) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.items modify column password varchar(64) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.items modify column publickey varchar(64) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.items modify column privatekey varchar(64) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.items modify column port varchar(64) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.items modify column description text character set utf8 collate utf8_bin not null ;
alter table zabbix.items modify column lifetime varchar(255) character set utf8 collate utf8_bin default '30d'  not null ;
alter table zabbix.items modify column snmpv3_contextname varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.items modify column jmx_endpoint varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.items modify column timeout varchar(255) character set utf8 collate utf8_bin default '3s'  not null ;
alter table zabbix.items modify column url varchar(2048) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.items modify column query_fields varchar(2048) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.items modify column posts text character set utf8 collate utf8_bin not null ;
alter table zabbix.items modify column status_codes varchar(255) character set utf8 collate utf8_bin default '200'  not null ;
alter table zabbix.items modify column http_proxy varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.items modify column headers text character set utf8 collate utf8_bin not null ;
alter table zabbix.items modify column ssl_cert_file varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.items modify column ssl_key_file varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.items modify column ssl_key_password varchar(64) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.sysmap_url modify column name varchar(255) character set utf8 collate utf8_bin not null ;
alter table zabbix.sysmap_url modify column url varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.sysmaps modify column name varchar(128) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.sysmaps modify column label_string_host varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.sysmaps modify column label_string_hostgroup varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.sysmaps modify column label_string_trigger varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.sysmaps modify column label_string_map varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.sysmaps modify column label_string_image varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.sysmap_element_url modify column name varchar(255) character set utf8 collate utf8_bin not null ;
alter table zabbix.sysmap_element_url modify column url varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.sysmaps_link_triggers modify column color varchar(6) character set utf8 collate utf8_bin default '000000'  not null ;
alter table zabbix.sysmaps_links modify column color varchar(6) character set utf8 collate utf8_bin default '000000'  not null ;
alter table zabbix.sysmaps_links modify column label varchar(2048) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.users modify column alias varchar(100) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.users modify column name varchar(100) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.users modify column surname varchar(100) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.users modify column passwd varchar(32) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.users modify column url varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.users modify column autologout varchar(32) character set utf8 collate utf8_bin default '15m'  not null ;
alter table zabbix.users modify column lang varchar(5) character set utf8 collate utf8_bin default 'en_GB'  not null ;
alter table zabbix.users modify column refresh varchar(32) character set utf8 collate utf8_bin default '30s'  not null ;
alter table zabbix.users modify column theme varchar(128) character set utf8 collate utf8_bin default 'default'  not null ;
alter table zabbix.users modify column attempt_ip varchar(39) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.usrgrp modify column name varchar(64) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.valuemaps modify column name varchar(64) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.autoreg_host modify column host varchar(128) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.autoreg_host modify column listen_ip varchar(39) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.autoreg_host modify column listen_dns varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.autoreg_host modify column host_metadata varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.proxy_autoreg_host modify column host varchar(128) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.proxy_autoreg_host modify column listen_ip varchar(39) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.proxy_autoreg_host modify column listen_dns varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.proxy_autoreg_host modify column host_metadata varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.group_prototype modify column name varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.screens_items modify column url varchar(255) character set utf8 collate utf8_bin default ''  not null ;
alter table zabbix.screens_items modify column application varchar(255) character set utf8 collate utf8_bin default ''  not null ;
