db-update-2016-06-23-build.sql
777 Bytes
use inventirap-test;
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`;