ALTER TABLE `actions`
ADD KEY `actions_1` (`eventsource`,`status`);

ALTER TABLE `auditlog_details`
CHANGE `table_name` `table_name` VARCHAR(64) COLLATE utf8_general_ci NOT NULL DEFAULT '',
CHANGE `field_name` `field_name` VARCHAR(64) COLLATE utf8_general_ci NOT NULL DEFAULT '',
DEFAULT CHARSET='utf8';

ALTER TABLE `autoreg_host`
CHANGE `host` `host` VARCHAR(64) COLLATE utf8_general_ci NOT NULL DEFAULT '',
DROP KEY `autoreg_host_1`,
ADD KEY `autoreg_host_1`(`proxy_hostid`,`host`),
DEFAULT CHARSET='utf8';

ALTER TABLE `dhosts`
ADD KEY `dhosts_1` (`druleid`);

ALTER TABLE `dservices`
ADD UNIQUE KEY `dservices_1` (`dcheckid`,`type`,`key_`,`ip`,`port`);

ALTER TABLE `escalations`
ADD KEY `escalations_2` (`status`,`nextcheck`);

ALTER TABLE `events`
DROP KEY `events_2`,
ADD KEY `events_2` (`clock`);

ALTER TABLE `expressions`
CHANGE `expression` `expression` VARCHAR(255) COLLATE utf8_general_ci NOT NULL DEFAULT '',
CHANGE `exp_delimiter` `exp_delimiter` VARCHAR(1) COLLATE utf8_general_ci NOT NULL DEFAULT '',
DEFAULT CHARSET='utf8';

ALTER TABLE `globalmacro`
CHANGE `macro` `macro` VARCHAR(64) COLLATE utf8_general_ci NOT NULL DEFAULT '',
CHANGE `value` `value` VARCHAR(255) COLLATE utf8_general_ci NOT NULL DEFAULT '',
DEFAULT CHARSET='utf8';

ALTER TABLE `graph_theme`
CHANGE `description` `description` VARCHAR(64)  COLLATE utf8_general_ci NOT NULL DEFAULT '',
CHANGE `theme` `theme` VARCHAR(64)  COLLATE utf8_general_ci NOT NULL DEFAULT '',
CHANGE `backgroundcolor` `backgroundcolor` VARCHAR(6)  COLLATE utf8_general_ci NOT NULL DEFAULT 'F0F0F0',
CHANGE `graphcolor` `graphcolor` VARCHAR(6)  COLLATE utf8_general_ci NOT NULL DEFAULT 'FFFFFF',
CHANGE `graphbordercolor` `graphbordercolor` VARCHAR(6)  COLLATE utf8_general_ci NOT NULL DEFAULT '222222',
CHANGE `gridcolor` `gridcolor` VARCHAR(6)  COLLATE utf8_general_ci NOT NULL DEFAULT 'CCCCCC',
CHANGE `maingridcolor` `maingridcolor` VARCHAR(6)  COLLATE utf8_general_ci NOT NULL DEFAULT 'AAAAAA',
CHANGE `gridbordercolor` `gridbordercolor` VARCHAR(6)  COLLATE utf8_general_ci NOT NULL DEFAULT '000000',
CHANGE `textcolor` `textcolor` VARCHAR(6)  COLLATE utf8_general_ci NOT NULL DEFAULT '202020',
CHANGE `highlightcolor` `highlightcolor` VARCHAR(6)  COLLATE utf8_general_ci NOT NULL DEFAULT 'AA4444',
CHANGE `leftpercentilecolor` `leftpercentilecolor` VARCHAR(6)  COLLATE utf8_general_ci NOT NULL DEFAULT '11CC11',
CHANGE `rightpercentilecolor` `rightpercentilecolor` VARCHAR(6)  COLLATE utf8_general_ci NOT NULL DEFAULT 'CC1111',
CHANGE `noneworktimecolor` `noneworktimecolor` VARCHAR(6)  COLLATE utf8_general_ci NOT NULL DEFAULT 'CCCCCC',
DEFAULT CHARSET='utf8';

ALTER TABLE `graphs_items`
ADD KEY `graphs_items_1` (`itemid`),
ADD KEY `graphs_items_2` (`graphid`);

ALTER TABLE `help_items`
CHANGE `key_` `key_` VARCHAR(255)  COLLATE utf8_general_ci NOT NULL DEFAULT '',
CHANGE `description` `description` VARCHAR(255) COLLATE utf8_general_ci NOT NULL DEFAULT '',
DEFAULT CHARSET='utf8';

ALTER TABLE `history_log`
CHANGE `value` `value` text COLLATE utf8_general_ci NOT NULL,
ADD UNIQUE KEY `history_log_2` (`itemid`,`id`);

ALTER TABLE `history_text`
CHANGE `value` `value` text COLLATE utf8_general_ci NOT NULL,
ADD UNIQUE KEY `history_text_2` (`itemid`,`id`);

ALTER TABLE `hostmacro`
CHANGE `macro` `macro` VARCHAR(64) COLLATE utf8_general_ci NOT NULL DEFAULT '',
CHANGE `value` `value` VARCHAR(255) COLLATE utf8_general_ci NOT NULL DEFAULT '',
DEFAULT CHARSET='utf8';

ALTER TABLE `hosts_templates`
ADD KEY `hosts_templates_2` (`templateid`);

ALTER TABLE `httptest`
ADD KEY `httptest_2` (`name`),
ADD KEY `httptest_3` (`status`);

ALTER TABLE `items`
CHANGE `params` `params` text COLLATE utf8_general_ci NOT NULL;

ALTER TABLE `maintenances`
CHANGE `name` `name` VARCHAR(128) COLLATE utf8_general_ci NOT NULL DEFAULT '',
DEFAULT CHARSET='utf8';

ALTER TABLE `maintenances_groups`
DEFAULT CHARSET='utf8';

ALTER TABLE `maintenances_hosts`
DEFAULT CHARSET='utf8';


ALTER TABLE `maintenances_windows`
DEFAULT CHARSET='utf8';


ALTER TABLE `node_cksum`
CHANGE `cksum` `cksum` text COLLATE utf8_general_ci NOT NULL,
DROP KEY `node_cksum_cksum_1`;

ALTER TABLE `opmediatypes`
DEFAULT CHARSET='utf8';

ALTER TABLE `proxy_autoreg_host`
CHANGE `host` `host` VARCHAR(64) COLLATE utf8_general_ci NOT NULL DEFAULT '',
DEFAULT CHARSET='utf8';

ALTER TABLE `proxy_history`
CHANGE `value` `value` text COLLATE utf8_general_ci NOT NULL;

ALTER TABLE `regexps`
CHANGE `name` `name` VARCHAR(128) COLLATE utf8_general_ci NOT NULL DEFAULT '',
DEFAULT CHARSET='utf8';

ALTER TABLE `services`
ADD KEY `services_1` (`triggerid`);

ALTER TABLE `timeperiods`
DEFAULT CHARSET='utf8';

ALTER TABLE `user_history`
CHANGE `title1` `title1` VARCHAR(255)  COLLATE utf8_general_ci NOT NULL DEFAULT '',
CHANGE `url1` `url1` VARCHAR(255)  COLLATE utf8_general_ci NOT NULL DEFAULT '',
CHANGE `title2` `title2` VARCHAR(255)  COLLATE utf8_general_ci NOT NULL DEFAULT '',
CHANGE `url2` `url2` VARCHAR(255)  COLLATE utf8_general_ci NOT NULL DEFAULT '',
CHANGE `title3` `title3` VARCHAR(255)  COLLATE utf8_general_ci NOT NULL DEFAULT '',
CHANGE `url3` `url3` VARCHAR(255)  COLLATE utf8_general_ci NOT NULL DEFAULT '',
CHANGE `title4` `title4` VARCHAR(255)  COLLATE utf8_general_ci NOT NULL DEFAULT '',
CHANGE `url4` `url4` VARCHAR(255)  COLLATE utf8_general_ci NOT NULL DEFAULT '',
CHANGE `title5` `title5` VARCHAR(255)  COLLATE utf8_general_ci NOT NULL DEFAULT '',
CHANGE `url5` `url5` VARCHAR(255)  COLLATE utf8_general_ci NOT NULL DEFAULT '',
DEFAULT CHARSET='utf8';