Guest User

Libre-NMS-Migrate-Error

a guest
Jul 21st, 2020
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 2.65 KB | None | 0 0
  1. 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)
  2. AlertScheduleUtc: alter table `alert_schedule` drop `start_recurring_dt`, drop `start_recurring_hr`, drop `end_recurring_dt`, drop `end_recurring_hr`
  3. AlterMetricColumn: ALTER TABLE application_metrics CHANGE metric metric VARCHAR(64) CHARACTER SET utf8 NOT NULL COLLATE `utf8_unicode_ci`
  4. 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
  5. 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'
  6. CreateDeviceOutagesTable: alter table `device_outages` add unique `device_outages_device_id_going_down_unique`(`device_id`, `going_down`)
  7. CreateDeviceOutagesTable: alter table `device_outages` add index `device_outages_device_id_index`(`device_id`)
  8. 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'
  9. CreateDeviceOutagesTable: alter table `availability` add unique `availability_device_id_duration_unique`(`device_id`, `duration`)
  10. CreateDeviceOutagesTable: alter table `availability` add index `availability_device_id_index`(`device_id`)
  11. 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