| Thursday 30 March 2006 2:04:36 pm 
                                                                 Convert from eng-GB to eng-US 
UPDATE ezcontentobject_nameSET
 content_translation='eng-US',
 real_translation='eng-US'
 WHERE
 content_translation='eng-GB' and
 real_translation='eng-GB';
 
UPDATE ezcontentobject_attributeSET
 language_code='eng-US'
 WHERE
 language_code='eng-GB';
 
UPDATE ezcontent_translationSET
 locale='eng-US',
 name='English (USA)'
 WHERE
 locale='eng-GB';
 Convert from eng-GB to ger-DE 
UPDATE ezcontentobject_nameSET
 content_translation='ger-DE',
 real_translation='ger-DE'
 WHERE
 content_translation='eng-GB' and
 real_translation='eng-GB';
 
UPDATE ezcontentobject_attributeSET
 language_code='ger-DE'
 WHERE
 language_code='eng-GB';
 
UPDATE ezcontent_translationSET
 locale='ger-DE',
 name='Deutsch (Deutschland)'
 WHERE
 locale='eng-GB';
 |