raouf pd

-- MySQL Workbench Synchronization
-- Generated: 2019-11-13 22:10
-- Model: New Model
-- Version: 1.0
-- Project: Name of the project
-- Author: mousl

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='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';

ALTER TABLE `projetweb`.`PhoneNumber`
DROP FOREIGN KEY `fk_PhoneNumber_contact1`;

ALTER TABLE `projetweb`.`PhoneNumber`
CHANGE COLUMN `contact_id` `contact_id` INT(11) NULL DEFAULT NULL ;

ALTER TABLE `projetweb`.`contactGroup`
ADD UNIQUE INDEX `groupeName_UNIQUE` (`groupeName` ASC) VISIBLE;
;

ALTER TABLE `projetweb`.`PhoneNumber`
ADD CONSTRAINT `fk_PhoneNumber_contact1`
  FOREIGN KEY (`contact_id`)
  REFERENCES `projetweb`.`contact` (`id`)
  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;