use database; -- On execute TOUT ou RIEN START TRANSACTION; ALTER TABLE `configurations` CHANGE `ldap_anonymous` `ldap_authentified` BOOLEAN NOT NULL DEFAULT FALSE AFTER `ldap_filter`; update configurations set ldap_authentified = FALSE; COMMIT;