Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
- SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
- SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
- ALTER TABLE `zbox_municipios_informacoes`
- DROP FOREIGN KEY `fk_zbox_municipios_informacoes_gal_galerias_imagens1`;
- ALTER TABLE `zbox_municipios_informacoes`
- CHANGE COLUMN `codGaleriaImagens` `codGaleriaImagens` INT(10) UNSIGNED NULL DEFAULT NULL ;
- ALTER TABLE `zbox_municipios_informacoes`
- ADD CONSTRAINT `fk_zbox_municipios_informacoes_gal_galerias_imagens1`
- FOREIGN KEY (`codGaleriaImagens`)
- REFERENCES `gal_galerias_imagens` (`codGaleriaImagens`)
- ON DELETE NO ACTION
- ON UPDATE NO ACTION;
- SET SQL_MODE=@OLD_SQL_MODE;
- SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
- SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement