Index: win_installer/templates/update_lams_configuration.sql =================================================================== RCS file: /usr/local/cvsroot/win_installer/templates/Attic/update_lams_configuration.sql,v diff -u -r1.7 -r1.8 --- win_installer/templates/update_lams_configuration.sql 8 Mar 2007 07:25:10 -0000 1.7 +++ win_installer/templates/update_lams_configuration.sql 20 Jul 2007 00:34:33 -0000 1.8 @@ -10,7 +10,7 @@ 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 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; 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 login='test1'; 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 login='test2';