Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- AlertScheduleUtc: update `alert_schedule` set `start` = CONVERT_TZ(IF(`recurring` = 1, STR_TO_DATE(CONCAT(start_recurring_dt, ' ', start_recurring_hr), '%Y-%m-%d %H:%i:%s'), start), @@global.time_zone, '+00:00'), `end` = CONVERT_TZ(IF(`recurring` = 1, STR_TO_DATE(CONCAT(IFNULL(end_recurring_dt, '9000-09-09'), ' ', end_recurring_hr), '%Y-%m-%d %H:%i:%s'), end), @@global.time_zone, '+00:00'), `recurring_day` = REPLACE(recurring_day, 0, 7)
- AlertScheduleUtc: alter table `alert_schedule` drop `start_recurring_dt`, drop `start_recurring_hr`, drop `end_recurring_dt`, drop `end_recurring_hr`
- AlterMetricColumn: ALTER TABLE application_metrics CHANGE metric metric VARCHAR(64) CHARACTER SET utf8 NOT NULL COLLATE `utf8_unicode_ci`
- PollerClusterSettings: alter table `poller_cluster` add `poller_enabled` tinyint(1) null, add `poller_frequency` int null, add `poller_workers` int null, add `poller_down_retry` int null, add `discovery_enabled` tinyint(1) null, add `discovery_frequency` int null, add `discovery_workers` int null, add `services_enabled` tinyint(1) null, add `services_frequency` int null, add `services_workers` int null, add `billing_enabled` tinyint(1) null, add `billing_frequency` int null, add `billing_calculate_frequency` int null, add `alerting_enabled` tinyint(1) null, add `alerting_frequency` int null, add `ping_enabled` tinyint(1) null, add `ping_frequency` int null, add `update_enabled` tinyint(1) null, add `update_frequency` int null, add `loglevel` varchar(8) null, add `watchdog_enabled` tinyint(1) null, add `watchdog_log` varchar(255) null
- CreateDeviceOutagesTable: create table `device_outages` (`device_id` int unsigned not null, `going_down` bigint not null, `up_again` bigint null, `uptime` bigint null) default character set utf8 collate 'utf8_unicode_ci'
- CreateDeviceOutagesTable: alter table `device_outages` add unique `device_outages_device_id_going_down_unique`(`device_id`, `going_down`)
- CreateDeviceOutagesTable: alter table `device_outages` add index `device_outages_device_id_index`(`device_id`)
- CreateDeviceOutagesTable: create table `availability` (`availability_id` int unsigned not null auto_increment primary key, `device_id` int unsigned not null, `duration` bigint not null, `availability_perc` double(6, 6) not null default '0') default character set utf8 collate 'utf8_unicode_ci'
- CreateDeviceOutagesTable: alter table `availability` add unique `availability_device_id_duration_unique`(`device_id`, `duration`)
- CreateDeviceOutagesTable: alter table `availability` add index `availability_device_id_index`(`device_id`)
- AlterAvailabilityPercColumn: ALTER TABLE availability CHANGE availability_perc availability_perc NUMERIC(9, 6) DEFAULT '0' NOT NULL
Advertisement
Add Comment
Please, Sign In to add comment