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;

