update lams_configuration set config_value='${lams.version}' where config_key='Version';
update lams_configuration set config_value='${lams.version}' where config_key='Version';
update lams_configuration set config_value='${SERVER_URL}' where config_key='ServerURL';
update lams_configuration set config_value='${TEMP_DIR}' where config_key='TempDir';
update lams_configuration set config_value='${DUMP_DIR}' where config_key='DumpDir';
update lams_configuration set config_value='${EAR_DIR}' where config_key='EARDir';
update lams_configuration set config_value='${server.version}' where config_key='AuthoringClientVersion' or config_key='MonitorClientVersion' or config_key="LearnerClientVersion" or config_key='ServerVersionNumber';
update lams_configuration set config_value='' where config_key='SMTPServer';
update lams_configuration set config_value='${REPOSITORY_DIR}' where config_key='ContentRepositoryPath';
update lams_configuration set config_value='${LOCALE}' where config_key='ServerLanguage';
update lams_configuration set config_value='${LOCALE_DIRECTION}' where config_key='ServerPageDirection';
update lams_configuration set config_value='${WILDFIRE_DOMAIN}' where config_key='XmppDomain';
update lams_configuration set config_value='${WILDFIRE_CONFERENCE}' where config_key='XmppConference';
update lams_configuration set config_value='${WILDFIRE_USER}' where config_key='XmppAdmin';
update lams_configuration set config_value='${WILDFIRE_PASS}' where config_key='XmppPassword';
update lams_user set login='${LAMS_USER}', password=sha1('${LAMS_PASS}') where user_id=1;
update lams_user set locale_id=(select locale_id from lams_supported_locale where language_iso_code=(SELECT SUBSTRING_INDEX('${LOCALE}', '_', 1)) and country_iso_code=(SELECT SUBSTRING_INDEX('${LOCALE}', '_', -1))) where user_id=1;