25 lines
5.9 KiB
SQL
25 lines
5.9 KiB
SQL
ALTER TABLE `links` ENGINE = INNODB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `mac_accounting` ENGINE = INNODB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `ports_adsl` ENGINE = INNODB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `ports_perms` ENGINE = INNODB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `pseudowires` ENGINE = INNODB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `services` ENGINE = INNODB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `storage` ENGINE = INNODB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `syslog` ENGINE = INNODB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `toner` ENGINE = INNODB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `users` ENGINE = INNODB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `vlans` ENGINE = INNODB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `vrfs` ENGINE = INNODB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `entPhysical_state` ENGINE = MEMORY DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
|
|
RENAME TABLE `entPhysical_state` TO `entPhysical-state`;
|
|
ALTER TABLE `ports-state` CHANGE `ifInUcastPkts` `ifInUcastPkts` BIGINT UNSIGNED NULL DEFAULT NULL;
|
|
ALTER TABLE `ports-state` CHANGE `ifInUcastPkts` `ifInUcastPkts` BIGINT(20) UNSIGNED NULL DEFAULT NULL, CHANGE `ifInUcastPkts_delta` `ifInUcastPkts_delta` INT(20) UNSIGNED NULL DEFAULT NULL, CHANGE `ifOutUcastPkts` `ifOutUcastPkts` BIGINT(20) UNSIGNED NULL DEFAULT NULL, CHANGE `ifOutUcastPkts_delta` `ifOutUcastPkts_delta` INT(20) UNSIGNED NULL DEFAULT NULL, CHANGE `ifInErrors` `ifInErrors` BIGINT(20) UNSIGNED NULL DEFAULT NULL, CHANGE `ifInErrors_delta` `ifInErrors_delta` INT UNSIGNED NULL DEFAULT NULL, CHANGE `ifOutErrors` `ifOutErrors` BIGINT(20) UNSIGNED NULL DEFAULT NULL, CHANGE `ifOutErrors_delta` `ifOutErrors_delta` INT UNSIGNED NULL DEFAULT NULL, CHANGE `ifOctets_rate` `ifOctets_rate` BIGINT(20) UNSIGNED NULL DEFAULT NULL, CHANGE `ifUcastPkts_rate` `ifUcastPkts_rate` INT UNSIGNED NULL DEFAULT NULL, CHANGE `ifInOctets` `ifInOctets` BIGINT(20) UNSIGNED NULL DEFAULT NULL, CHANGE `ifInOctets_delta` `ifInOctets_delta` BIGINT(20) UNSIGNED NULL DEFAULT NULL, CHANGE `ifInOctets_rate` `ifInOctets_rate` BIGINT(11) UNSIGNED NULL DEFAULT NULL, CHANGE `ifOutOctets` `ifOutOctets` BIGINT(20) UNSIGNED NULL DEFAULT NULL, CHANGE `ifOutOctets_delta` `ifOutOctets_delta` BIGINT(20) UNSIGNED NULL DEFAULT NULL, CHANGE `ifOutOctets_rate` `ifOutOctets_rate` BIGINT(11) UNSIGNED NULL DEFAULT NULL;
|
|
ALTER TABLE `ports-state` CHANGE `port_id` `port_id` INT( 11 ) UNSIGNED NOT NULL ,CHANGE `ifInUcastPkts_rate` `ifInUcastPkts_rate` INT( 11 ) UNSIGNED NULL DEFAULT NULL ,CHANGE `ifOutUcastPkts_rate` `ifOutUcastPkts_rate` INT( 11 ) UNSIGNED NULL DEFAULT NULL ,CHANGE `ifInErrors_rate` `ifInErrors_rate` INT( 11 ) UNSIGNED NULL DEFAULT NULL ,CHANGE `ifOutErrors_rate` `ifOutErrors_rate` INT( 11 ) UNSIGNED NULL DEFAULT NULL ,CHANGE `ifUcastPkts_rate` `ifUcastPkts_rate` INT( 11 ) UNSIGNED NULL DEFAULT NULL ,CHANGE `ifErrors_rate` `ifErrors_rate` INT( 11 ) UNSIGNED NULL DEFAULT NULL ,CHANGE `ifInOctets_perc` `ifInOctets_perc` INT( 11 ) UNSIGNED NULL DEFAULT NULL ,CHANGE `ifOutOctets_perc` `ifOutOctets_perc` INT( 11 ) UNSIGNED NULL DEFAULT NULL ,CHANGE `poll_time` `poll_time` INT( 11 ) UNSIGNED NULL DEFAULT NULL ,CHANGE `poll_period` `poll_period` INT( 11 ) UNSIGNED NULL DEFAULT NULL;
|
|
ALTER TABLE `ports-state` CHANGE `port_id` `port_id` INT(11) UNSIGNED NOT NULL, CHANGE `ifInUcastPkts` `ifInUcastPkts` BIGINT(20) UNSIGNED NOT NULL, CHANGE `ifInUcastPkts_delta` `ifInUcastPkts_delta` INT(20) UNSIGNED NOT NULL, CHANGE `ifInUcastPkts_rate` `ifInUcastPkts_rate` INT(11) UNSIGNED NOT NULL, CHANGE `ifOutUcastPkts` `ifOutUcastPkts` BIGINT(20) UNSIGNED NOT NULL, CHANGE `ifOutUcastPkts_delta` `ifOutUcastPkts_delta` INT(20) UNSIGNED NOT NULL, CHANGE `ifOutUcastPkts_rate` `ifOutUcastPkts_rate` INT(11) UNSIGNED NOT NULL, CHANGE `ifInErrors` `ifInErrors` BIGINT(20) UNSIGNED NOT NULL, CHANGE `ifInErrors_delta` `ifInErrors_delta` INT(10) UNSIGNED NOT NULL, CHANGE `ifInErrors_rate` `ifInErrors_rate` INT(11) UNSIGNED NOT NULL, CHANGE `ifOutErrors` `ifOutErrors` BIGINT(20) UNSIGNED NOT NULL, CHANGE `ifOutErrors_delta` `ifOutErrors_delta` INT(10) UNSIGNED NOT NULL, CHANGE `ifOutErrors_rate` `ifOutErrors_rate` INT(11) UNSIGNED NOT NULL, CHANGE `ifOctets_rate` `ifOctets_rate` BIGINT(20) UNSIGNED NOT NULL, CHANGE `ifUcastPkts_rate` `ifUcastPkts_rate` INT(11) UNSIGNED NOT NULL, CHANGE `ifErrors_rate` `ifErrors_rate` INT(11) UNSIGNED NOT NULL, CHANGE `ifInOctets` `ifInOctets` BIGINT(20) UNSIGNED NOT NULL, CHANGE `ifInOctets_delta` `ifInOctets_delta` BIGINT(20) UNSIGNED NOT NULL, CHANGE `ifInOctets_rate` `ifInOctets_rate` BIGINT(11) UNSIGNED NOT NULL, CHANGE `ifOutOctets` `ifOutOctets` BIGINT(20) UNSIGNED NOT NULL, CHANGE `ifOutOctets_delta` `ifOutOctets_delta` BIGINT(20) UNSIGNED NOT NULL, CHANGE `ifOutOctets_rate` `ifOutOctets_rate` BIGINT(11) UNSIGNED NOT NULL, CHANGE `ifInOctets_perc` `ifInOctets_perc` INT(11) UNSIGNED NOT NULL, CHANGE `ifOutOctets_perc` `ifOutOctets_perc` INT(11) UNSIGNED NOT NULL, CHANGE `poll_time` `poll_time` INT(11) UNSIGNED NOT NULL, CHANGE `poll_period` `poll_period` INT(11) UNSIGNED NOT NULL;
|
|
ALTER TABLE `ports-state` CHANGE `ifInErrors_rate` `ifInErrors_rate` SMALLINT UNSIGNED NOT NULL ,CHANGE `ifOutErrors_rate` `ifOutErrors_rate` SMALLINT UNSIGNED NOT NULL ,CHANGE `ifErrors_rate` `ifErrors_rate` SMALLINT UNSIGNED NOT NULL;
|
|
ALTER TABLE `ports-state` CHANGE `ifOutOctets_perc` `ifOutOctets_perc` TINYINT UNSIGNED NOT NULL;
|
|
ALTER TABLE `ports-state` CHANGE `ifInOctets_perc` `ifInOctets_perc` TINYINT UNSIGNED NOT NULL;
|
|
ALTER TABLE `ports-state` CHANGE `ifInOctets_rate` `ifInOctets_rate` BIGINT UNSIGNED NOT NULL;
|
|
ALTER TABLE `ports-state` CHANGE `ifOutOctets_rate` `ifOutOctets_rate` BIGINT( 20 ) UNSIGNED NOT NULL;
|
|
|