Redmine SQL Commands

Some useful commands

Get Administrator

update users set admin=1 where id=xxx;

Update People Phone

update users set users.skype=(select value from custom_values a where a.customized_id=@userid and a.custom_field_id=122) where users.id=@userid;

Update set projects to not public

update projects set is_public=0;