ALTER TABLE LabelsDocLang MODIFY traduction varchar(255);

ALTER TABLE ZooTechniqueAV MODIFY methodeIdentAnim varchar(20);
ALTER TABLE ZooTechniqueAV MODIFY resIdentAnim varchar(50);
ALTER TABLE ZooTechniqueAV MODIFY typeRepro varchar(3);
ALTER TABLE ZooTechniqueAV MODIFY animRepro varchar(20);
ALTER TABLE ZooTechniqueAV MODIFY noboviRepro varchar(50);
ALTER TABLE ZooTechniqueAV MODIFY methodeIdentRepro varchar(20);
ALTER TABLE ZooTechniqueAV MODIFY resIdentRepro varchar(50);
ALTER TABLE ZooTechniqueAV MODIFY paysDest varchar(20) NOT NULL;
ALTER TABLE ZooTechniqueAV MODIFY nomDest varchar(100);
ALTER TABLE ZooTechniqueAV MODIFY numCertif varchar(30) NOT NULL;
ALTER TABLE ZooTechniqueAV ADD UNIQUE (numCertif);

ALTER TABLE ZooTechniqueS MODIFY methodeIdentAnim varchar(20);
ALTER TABLE ZooTechniqueS MODIFY resIdentAnim varchar(50);
ALTER TABLE ZooTechniqueS MODIFY paysDest varchar(20) NOT NULL;
ALTER TABLE ZooTechniqueS MODIFY nomDest varchar(100);
ALTER TABLE ZooTechniqueS MODIFY addDest varchar(150);
ALTER TABLE ZooTechniqueS MODIFY nomCentre varchar(50);
ALTER TABLE ZooTechniqueS MODIFY adressCentre varchar(150);
ALTER TABLE ZooTechniqueS MODIFY agreCentre varchar(20);
ALTER TABLE ZooTechniqueS MODIFY tabSperme mediumtext;
ALTER TABLE ZooTechniqueS MODIFY numCertif varchar(30) NOT NULL;
ALTER TABLE ZooTechniqueS ADD UNIQUE (numCertif);


ALTER TABLE ZooTechniqueE MODIFY methodeIdentAnimS varchar(20);
ALTER TABLE ZooTechniqueE MODIFY resIdentAnimS varchar(50);
ALTER TABLE ZooTechniqueE MODIFY methodeIdentAnimO varchar(20);
ALTER TABLE ZooTechniqueE MODIFY resIdentAnimO varchar(50);
ALTER TABLE ZooTechniqueE MODIFY paysDest varchar(20) NOT NULL;
ALTER TABLE ZooTechniqueE MODIFY nomDest varchar(100);
ALTER TABLE ZooTechniqueE MODIFY addDest varchar(150);
ALTER TABLE ZooTechniqueE MODIFY nomCentre varchar(50);
ALTER TABLE ZooTechniqueE MODIFY adressCentre varchar(150);
ALTER TABLE ZooTechniqueE MODIFY agreCentre varchar(20);
ALTER TABLE ZooTechniqueE MODIFY tabSperme mediumtext;
ALTER TABLE ZooTechniqueE MODIFY numCertif varchar(30) NOT NULL;
ALTER TABLE ZooTechniqueE ADD UNIQUE (numCertif);
