How To: Assign a Theme to All Users (SQL Script)

1. Take database backup.

2. Run the script to see current theme assignment.

/* Query to see what user themes are already assigned

select * from pwuserpreferences
where AppID = 'passageways.portal' and Preferencekey = 'usertheme'

3. Delete current theme assignments

/* query to delete existing theme preferences

delete from pwuserpreferences
where AppID = 'passageways.portal' and Preferencekey = 'usertheme'

4. Assign new theme to all users. 
/* query to insert Swoogle theme preference for all users; Make sure to change 'Swoogle' to the correct theme name... Case senstive - watch out!

Insert into pwuserpreferences (UserID, AppID,PreferenceKey, PreferenceValue)
select userid, 'passageways.portal','usertheme','Swoogle' from pwuser