use database;

-- On execute TOUT ou RIEN
START TRANSACTION;

ALTER TABLE configurations ADD ldap_cached BOOLEAN NOT NULL DEFAULT FALSE;
ALTER TABLE configurations ADD ldap_cache_validity_duration INT NOT NULL DEFAULT 60;
ALTER TABLE configurations ADD ldap_cache_last_update DATETIME NULL DEFAULT NULL;

ALTER TABLE users ADD created DATETIME NULL DEFAULT NULL AFTER id;
ALTER TABLE users ADD modified DATETIME NULL DEFAULT NULL AFTER created;

COMMIT;