Etienne Pallier / labinvent

Blame view

database/update/script_sql/db-update-2019-01-09-CRAL.sql 1.39 KB
Edit Raw Normal View History
a5276c81   Etienne Pallier   ajout du mode lda... 
1
2
 
use database;
97276a4a   Etienne Pallier   Mise à jour page ... 
3
4
 
-- On execute TOUT ou RIEN
START TRANSACTION;
a5276c81   Etienne Pallier   ajout du mode lda... 
5
6422375e   Etienne Pallier   renommé ldap_anon... 
6
7
 
ALTER TABLE `configurations` CHANGE `use_ldap` `ldap_used` BOOLEAN NOT NULL DEFAULT FALSE; 
ALTER TABLE `configurations` CHANGE `host_ldap` `ldap_host` VARCHAR(250) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL AFTER `ldap_used`;
a5276c81   Etienne Pallier   ajout du mode lda... 
8
9
 
ALTER TABLE `configurations` CHANGE `port_ldap` `ldap_port` VARCHAR(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL AFTER `ldap_host`;
ALTER TABLE `configurations` CHANGE `authentificationType_ldap` `ldap_authenticationType` VARCHAR(30) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL AFTER `ldap_port`;
6422375e   Etienne Pallier   renommé ldap_anon... 
10
 
ALTER TABLE `configurations` CHANGE `baseDn_ldap` `ldap_baseDn` VARCHAR(300) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL AFTER `ldap_authenticationType`;
a5276c81   Etienne Pallier   ajout du mode lda... 
11
 
ALTER TABLE `configurations` CHANGE `filter_ldap` `ldap_filter` VARCHAR(300) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL AFTER `ldap_baseDn`;
6422375e   Etienne Pallier   renommé ldap_anon... 
12
13
14
15
16
17
18
 

ALTER TABLE `configurations` CHANGE `anonymous_ldap` `ldap_authentified` BOOLEAN NOT NULL DEFAULT FALSE AFTER `ldap_filter`;
update configurations set ldap_authentified = TRUE;

ALTER TABLE `configurations` CHANGE `bindDn_ldap` `ldap_bindDn` VARCHAR(250) NULL DEFAULT NULL AFTER `ldap_authentified`;
ALTER TABLE `configurations` CHANGE `bindPass_ldap` `ldap_bindPass` VARCHAR(50) NULL DEFAULT NULL AFTER `ldap_bindDn`;
97276a4a   Etienne Pallier   Mise à jour page ... 
19
 
COMMIT;