Moodle Local Development Environment Settings

I use the following SQL to adjust my local moodle development environment after refreshing it from a production instance. Thought it might be a handy reference.