ALTER TABLE `ma_Naics` CHANGE `id` `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT;


ALTER TABLE `ma_LibraryNaics` DROP FOREIGN KEY `ma_LibraryNaics_ibfk_2`; ALTER TABLE `ma_LibraryNaics` ADD CONSTRAINT `ma_LibraryNaics_ibfk_2` FOREIGN KEY (`naicsCode`) REFERENCES `prj_maicc_org_naics`.`ma_Naics`(`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `ma_LicenseNaics` DROP FOREIGN KEY `ma_LicenseNaics_ibfk_2`; ALTER TABLE `ma_LicenseNaics` ADD CONSTRAINT `ma_LicenseNaics_ibfk_2` FOREIGN KEY (`naicsCode`) REFERENCES `prj_maicc_org_naics`.`ma_Naics`(`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `ma_Naics`
  DROP `code`,
  DROP `t`,
  DROP `isCategory`;