ALTER TABLE `utilisateur` CHANGE `uti_cpt_bloque` `uti_cpt_bloque` INT(1) NOT NULL DEFAULT '0', CHANGE `uti_no_faild_login` `uti_no_faild_login` INT(1) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `patient_comment` CHANGE `pat_com_type` `pat_com_type` SMALLINT UNSIGNED NOT NULL;

ALTER TABLE `courrier_edite` CHANGE `cou_lettre` `cou_lettre` SMALLINT UNSIGNED NULL;

ALTER TABLE `donneur` CHANGE `don_type` `don_type` SMALLINT UNSIGNED NULL;

ALTER TABLE `greffe` CHANGE `gre_greffon_fonct` `gre_greffon_fonct` SMALLINT UNSIGNED NULL;

ALTER TABLE `dialyse` CHANGE `dia_rang` `dia_rang` SMALLINT UNSIGNED NULL;

ALTER TABLE `greffe` DROP FOREIGN KEY  `fk_greffe_type_greffe`;
ALTER TABLE `greffe` MODIFY tgr_code SMALLINT(2) NULL DEFAULT NULL;
alter table type_greffe modify tgr_code SMALLINT(2) NOT NULL;
ALTER TABLE `greffe` ADD CONSTRAINT `fk_greffe_type_greffe` FOREIGN KEY (`tgr_code`) REFERENCES `type_greffe`(`tgr_code`) ON DELETE RESTRICT ON UPDATE RESTRICT;
