1 ALTER TABLE GROUPS rename column scm_box TO scm_box_old;
2 ALTER TABLE GROUPS add column scm_box text;
3 update groups set scm_box=scm_box_old;
5 -- NOTE - scm_box needs to be a fully qualified domain
6 -- name - probably requires a manual SQL update.
8 ALTER TABLE GROUPS drop column scm_box_old;