Etienne Pallier / labinvent

Blame view

database/update/script_sql/db-update-2016-06-23.sql 824 Bytes
Edit Raw Normal View History
057309e6   Alexandre   Version: 2.4.6.6 
1
2
 
use database;
97276a4a   Etienne Pallier   Mise à jour page ... 
3
4
 
-- On execute TOUT ou RIEN
START TRANSACTION;
057309e6   Alexandre   Version: 2.4.6.6 
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
 

ALTER TABLE `configurations` ADD `labName2` varchar(200) DEFAULT 'NOM COMPLET';
update configurations set labName2 = labName where id = 1;
ALTER TABLE `configurations` DROP `labName`;
ALTER TABLE `configurations` ADD `labName` varchar(200) DEFAULT 'NOM COMPLET';
update configurations set labName = labName2 where id = 1;
ALTER TABLE `configurations` DROP `labName2`;



ALTER TABLE `configurations` ADD `baseDn_ldap2` varchar(300) DEFAULT null;
update configurations set baseDn_ldap2 = baseDn_ldap where id = 1;
ALTER TABLE `configurations` DROP `baseDn_ldap`;
ALTER TABLE `configurations` ADD `baseDn_ldap` varchar(300) DEFAULT null;
update configurations set baseDn_ldap = baseDn_ldap2 where id = 1;
ALTER TABLE `configurations` DROP `baseDn_ldap2`;
97276a4a   Etienne Pallier   Mise à jour page ... 
22
 
COMMIT;