Adding Columns to the Settings Table

Modifying the Settings Table describes how the design of the Settings table of the FmLib database was changed to support critique functionality. As the code for CML/LitCrit was written it became clear that additional settings were needed. The following Settings table diagram shows the version of the table that was implemented.

The following columns were added to the Settings table during the implementation phase:

• The CritiqueEnabled column contains 0 (False) or 1 (True), indicating whether or not the CML/LitCrit application is enabled for critiques. When this setting is False, the LitCrit Outlook® application does not create critique records in the FmLib database and the critique enhancements to the CML are not available.
• The PublicFolderName column contains the name of the public folder where critiques are posted.
• The PublicFolderID column contains the unique identifier Exchange has assigned to the public folder named in the PublicFolderName column.