Etienne Pallier / labinvent

Blame view

database/update/script_sql/db-update-2019-05-27.sql 453 Bytes
Edit Raw Normal View History
82c02279   Etienne Pallier   ldap optimisé v2 
1
2
 
use database;
97276a4a   Etienne Pallier   Mise à jour page ... 
3
4
5
 
-- On execute TOUT ou RIEN
START TRANSACTION;
82c02279   Etienne Pallier   ldap optimisé v2 
6
7
8
9
10
 
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;
97276a4a   Etienne Pallier   Mise à jour page ... 
11
12
13
 
ALTER TABLE users ADD modified DATETIME NULL DEFAULT NULL AFTER created;

COMMIT;