ALTER TABLE `pseudowires` CHANGE `cpwOid` `pwOid` INT(11) UNSIGNED NOT NULL, CHANGE `cpwVcID` `pwID` INT(11) NOT NULL, CHANGE `peer_ldp_id` `pwMplsPeerLdpID` VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL, CHANGE `pw_type` `pwType` VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, CHANGE `pw_psntype` `pwPsnType` VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, CHANGE `pw_local_mtu` `pwLocalIfMtu` INT(11) NOT NULL, CHANGE `pw_peer_mtu` `pwRemoteIfMtu` INT(11) NOT NULL, CHANGE `pw_descr` `pwDescr` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, CHANGE `peer_descr` `pwRemoteIfString` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL, CHANGE `reverse_dns` `peer_rdns` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '';
ALTER TABLE `pseudowires` ADD `mib` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'CISCO-IETF-PW-MIB' AFTER `device_id`;