Etienne Pallier / labinvent

db-update-2019-05-27.sql 397 Bytes
1 2 3 4 5 6 7 8 
use database;

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;