Advertisement
Guest User

Untitled

a guest
Mar 27th, 2017
50
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.83 KB | None | 0 0
  1. SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
  2. SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
  3. SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
  4.  
  5.  
  6. ALTER TABLE `zbox_municipios_informacoes`
  7. DROP FOREIGN KEY `fk_zbox_municipios_informacoes_gal_galerias_imagens1`;
  8.  
  9. ALTER TABLE `zbox_municipios_informacoes`
  10. CHANGE COLUMN `codGaleriaImagens` `codGaleriaImagens` INT(10) UNSIGNED NULL DEFAULT NULL ;
  11.  
  12. ALTER TABLE `zbox_municipios_informacoes`
  13. ADD CONSTRAINT `fk_zbox_municipios_informacoes_gal_galerias_imagens1`
  14.   FOREIGN KEY (`codGaleriaImagens`)
  15.   REFERENCES `gal_galerias_imagens` (`codGaleriaImagens`)
  16.   ON DELETE NO ACTION
  17.   ON UPDATE NO ACTION;
  18.  
  19.  
  20. SET SQL_MODE=@OLD_SQL_MODE;
  21. SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
  22. SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement