4 lines
1.3 KiB
SQL
4 lines
1.3 KiB
SQL
--Prepare for ports multiupdate
|
|
ALTER TABLE `ports` CHANGE `ifInUcastPkts_rate` `ifInUcastPkts_rate` INT(11) UNSIGNED NOT NULL DEFAULT '0', CHANGE `ifOutUcastPkts_rate` `ifOutUcastPkts_rate` INT(11) UNSIGNED NOT NULL DEFAULT '0', CHANGE `ifInErrors_rate` `ifInErrors_rate` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0', CHANGE `ifOutErrors_rate` `ifOutErrors_rate` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0', CHANGE `ifOctets_rate` `ifOctets_rate` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', CHANGE `ifUcastPkts_rate` `ifUcastPkts_rate` INT(11) UNSIGNED NOT NULL DEFAULT '0', CHANGE `ifErrors_rate` `ifErrors_rate` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0', CHANGE `ifInOctets_rate` `ifInOctets_rate` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', CHANGE `ifOutOctets_rate` `ifOutOctets_rate` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', CHANGE `ifInOctets_perc` `ifInOctets_perc` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0', CHANGE `ifOutOctets_perc` `ifOutOctets_perc` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0', CHANGE `ifInErrors_delta` `ifInErrors_delta` INT(10) UNSIGNED NOT NULL DEFAULT '0', CHANGE `ifOutErrors_delta` `ifOutErrors_delta` INT(10) UNSIGNED NOT NULL DEFAULT '0';
|
|
ALTER TABLE `ports` CHANGE `poll_time` `poll_time` INT(11) UNSIGNED NOT NULL DEFAULT '0', CHANGE `poll_period` `poll_period` INT(11) UNSIGNED NOT NULL DEFAULT '300';
|