Thanks Korry,
I think that's a step in the right direction but I'm not quite there yet. I'm trying to run this series of commands:
sql> UPDATE domain SET settings=CONCAT(settings, 'default_language:', defaultlanguage, ';');
sql> UPDATE domain SET settings=CONCAT(settings, 'default_user_quota:', defaultuserquota, ';');
sql> UPDATE domain SET settings=CONCAT(settings, 'default_groups:', defaultuseraliases, ';');
sql> UPDATE domain SET settings=CONCAT(settings, 'min_passwd_length:', minpasswordlength, ';');
sql> UPDATE domain SET settings=CONCAT(settings, 'max_passwd_length:', maxpasswordlength, ';');
sql> UPDATE domain SET settings=CONCAT(settings, 'disabled_domain_profiles:', disableddomainprofiles, ';');
sql> UPDATE domain SET settings=CONCAT(settings, 'disabled_user_profiles:', disableduserprofiles, ';');
When I did it this way:
UPDATE domain SET settings = ('default_language:en_US;default_user_quota:10240;default_groups:;min_passwd_length:0;max_passwd_length:0;disabled_domain_profiles:;disabled_user_profiles:;');
It created one line in the column with everything strung together.
I'm trying to get everything into individual lines. When I run separate statements using your approach, it created two lines (I think because one of the other tables, defaultuserquota, contained two values itself.
So I'm still stuck. Does anyone else have any clues? Or am I totally mis-thinking this completely? Thanks.
- Fabian S.