user: add default role_id

This is a cleaner, DB-side implementation of the intent behind
a97cf33dd952ed677dcec184b276e3438f933878, which was reverted (for this
commit).

Noe that we make use of a new config/initializers/constants.rb file in
order to define some global constants used throughout the application.