P9rzHeYc

1alter table tur_caracteristicas_tipo_equipamentos add column destaque int(1);
2alter table tur_equipamentos_hospedagens add column cadastur varchar(30) null;
3alter table tur_caracteristicas_equipamentos add column observacao varchar(20) null;
4CREATE TABLE IF NOT EXISTS `tur_redes_sociais_municipio` (
5  `codRedeSocialMunicipio` INT NOT NULL AUTO_INCREMENT,
6  `codRedeSocial` INT UNSIGNED NOT NULL,
7  `codMunicipio` INT(10) UNSIGNED NOT NULL,
8  `link` varchar(500) NOT NULL,
9  PRIMARY KEY (`codRedeSocialMunicipio`),
10  INDEX `fk_tur_redes_sociais_municipio_util_redes_sociais1_idx` (`codRedeSocial` ASC),
11  INDEX `fk_tur_redes_sociais_municipio_zbox_municipios1_idx` (`codMunicipio` ASC),
12  CONSTRAINT `fk_tur_redes_sociais_municipio_util_redes_sociais1`
13    FOREIGN KEY (`codRedeSocial`)
14    REFERENCES `util_redes_sociais` (`codRedeSocial`)
15    ON DELETE CASCADE
16    ON UPDATE NO ACTION,
17  CONSTRAINT `fk_tur_redes_sociais_municipio_zbox_municipios1`
18    FOREIGN KEY (`codMunicipio`)
19    REFERENCES `zbox_municipios` (`codMunicipio`)
20    ON DELETE CASCADE
21    ON UPDATE NO ACTION)
22ENGINE = InnoDB;
23
24
25CREATE TABLE IF NOT EXISTS `tur_instagram_home` (
26  `codInstagramHome` INT NOT NULL AUTO_INCREMENT,
27  `codSite` INT(10) UNSIGNED NOT NULL,
28  `exibeInstagram` int(1) NOT NULL,
29  `urlFeed` varchar(500) NOT NULL,
30  PRIMARY KEY (`codInstagramHome`),
31  INDEX `fk_tur_instagram_home_zbox_sites1_idx` (`codSite` ASC),
32  CONSTRAINT `fk_tur_instagram_home_zbox_sites1`
33    FOREIGN KEY (`codSite`)
34    REFERENCES `zbox_sites` (`codSite`)
35    ON DELETE CASCADE
36    ON UPDATE NO ACTION)
37ENGINE = InnoDB;