use database;

-- On execute TOUT ou RIEN
START TRANSACTION;

ALTER TABLE `configurations` ADD `labName2` varchar(200) DEFAULT 'NOM COMPLET';
update configurations set labName2 = labName where id = 1;
ALTER TABLE `configurations` DROP `labName`;
ALTER TABLE `configurations` ADD `labName` varchar(200) DEFAULT 'NOM COMPLET';
update configurations set labName = labName2 where id = 1;
ALTER TABLE `configurations` DROP `labName2`;



ALTER TABLE `configurations` ADD `baseDn_ldap2` varchar(300) DEFAULT null;
update configurations set baseDn_ldap2 = baseDn_ldap where id = 1;
ALTER TABLE `configurations` DROP `baseDn_ldap`;
ALTER TABLE `configurations` ADD `baseDn_ldap` varchar(300) DEFAULT null;
update configurations set baseDn_ldap = baseDn_ldap2 where id = 1;
ALTER TABLE `configurations` DROP `baseDn_ldap2`;

COMMIT;