ALTER TABLE `vrfs` DROP `vrf_oid`;
ALTER TABLE `vrfs` CHANGE `mplsVpnVrfRouteDistinguisher` `vrf_rd` VARCHAR(128) CHARACTER SET latin1 COLLATE latin1_general_ci NULL DEFAULT NULL, CHANGE `mplsVpnVrfDescription` `vrf_descr` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `vrfs` ADD `vrf_mib` VARCHAR(64) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL AFTER `vrf_id`;
ALTER TABLE `vrfs` ADD `vrf_admin_status` ENUM('up','down','testing') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'up' AFTER `device_id`, ADD `vrf_oper_status` ENUM('up','down') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'up' AFTER `vrf_admin_status`, ADD `vrf_active_ports` INT UNSIGNED NOT NULL DEFAULT '0' AFTER `vrf_oper_status`, ADD `vrf_total_ports` INT UNSIGNED NOT NULL DEFAULT '0' AFTER `vrf_active_ports`, ADD `vrf_added_routes` INT UNSIGNED NOT NULL DEFAULT '0' AFTER `vrf_total_ports`, ADD `vrf_deleted_routes` INT UNSIGNED NOT NULL DEFAULT '0' AFTER `vrf_added_routes`, ADD `vrf_total_routes` INT UNSIGNED NOT NULL DEFAULT '0' AFTER `vrf_deleted_routes`, ADD `vrf_added` INT UNSIGNED NULL DEFAULT NULL AFTER `vrf_total_routes`, ADD `vrf_last_change` INT UNSIGNED NULL DEFAULT NULL AFTER `vrf_added`;