ALTER TABLE `moncompte` ADD `guideinstallation` VARCHAR(500) NULL AFTER `logo`;
ALTER TABLE `transporteur` ADD `wsnumcompte` VARCHAR(20) NULL AFTER `wspassword`;
ALTER TABLE `lignecommande` CHANGE `idcommande` `idcommande` VARCHAR(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL;
ALTER TABLE `services_attributs` CHANGE `value` `value` VARCHAR(2000) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL;
ALTER TABLE `services` ADD `sendcodetracking` TINYINT(2) NOT NULL DEFAULT '0' AFTER `servicestype`;

