1 update users set theme_id = (select theme_id from themes where dirname = 'gforge') where theme_id = (select theme_id from themes where dirname = 'osx');
2 update users set theme_id = (select theme_id from themes where dirname = 'gforge') where theme_id = (select theme_id from themes where dirname = 'gforge-classic');
3 update users set theme_id = (select theme_id from themes where dirname = 'gforge') where theme_id = (select theme_id from themes where dirname = 'gforge-simple-theme');
4 update users set theme_id = (select theme_id from themes where dirname = 'gforge') where theme_id = (select theme_id from themes where dirname = 'lite');
5 update users set theme_id = (select theme_id from themes where dirname = 'gforge') where theme_id = (select theme_id from themes where dirname = 'ultralite');
6 delete from themes where dirname = 'osx';
7 delete from themes where dirname = 'gforge-classic';
8 delete from themes where dirname = 'gforge-simple-theme';
9 delete from themes where dirname = 'lite';
10 delete from themes where dirname = 'ultralite';
11 insert into themes (dirname,fullname,enabled) values ('funky','Funky','t');