Overview

Each setting can have a number of environment-specific values. The "current value" of a given setting is determined by a priority ranking of those environments:

• If a value exists for the current environment then that value is used.

• Otherwise, if a "client default" setting exists, then that value is used.

• Otherwise, the "product default" setting is used.

This design supports our process of restoring a nightly snapshot of the production database to the "support" instance. Certain environmental settings, such as the payment gateway and email override feature, are configured differently in SUPPORT than PROD for various reasons. By tracking the environment-specific settings in a single database it becomes much simpler to move and promote the database snapshots.

Individual settings