ArticlesArticles Most Popular ArticlesMost Popular Articles
RSS Feeds
DrillDown Icon Table of Contents
DrillDown Icon 2019 Official Holidays & Support Schedule
DrillDown Icon IMPORTANT: End of Life of SHA1 on Windows Server 2003
DrillDown Icon IMPORTANT: Supported Operating Systems
DrillDown Icon PLEASE READ: Our Update Server IPs Have Changed
DrillDown Icon Support
DrillDown Icon modusGate for Microsoft Azure
DrillDown Icon modusCloud
DrillDown Icon Alleviating Spam – Best Practices
DrillDown Icon directQuarantine Technical Information
DrillDown Icon modusMail & modusGate Technical Information
DrillDown Icon Documentation & Release Information
DrillDown Icon Known Issues (non-release related)
DrillDown Icon Configuration Information
DrillDown Icon modusGate & modusMail
DrillDown Icon modusGate Only
DrillDown Icon modusMail Only
DrillDown Icon SQL Server Information
DrillDown Icon How-To: Enable Full Text Indexing for SQL Server Express
DrillDown Icon Known Issue: SQL Server Express Setup Problems on Windows 2000 Server
DrillDown Icon Info: Extended Database Format for ModusMail
DrillDown Icon How-To: Configure the SieveStore Database in SQL Server
DrillDown Icon How-To: Use SQL Server Instead of the Built-in MDB Database for Quarantine storage
DrillDown Icon How-to: Prevent Quarantine-Related Problems
DrillDown Icon How-To: Configure SQL TCP stack
DrillDown Icon How-To: Move SQL database from one server to another
DrillDown Icon MySQL Information
DrillDown Icon Security
DrillDown Icon Sieve
DrillDown Icon Spam and False-Positives
DrillDown Icon Statistics and Monitoring Section
DrillDown Icon Web Components
DrillDown Icon Troubleshooting
DrillDown Icon Hardware & OS System Requirements
DrillDown Icon Tools
DrillDown Icon Other Product Technical Information
DrillDown Icon Professional Services
DrillDown Icon Newsletters
  Email This ArticlePrint PreviewPrint Current Article/Category and All Sub-Articles/Categories
 
Info: Extended Database Format for ModusMail


Product:
ModusMail

Version & Build: 4.1.361 + up

 
Modusmail Extended Database Schema
 

The ModusMail Extended Database format supports most of the mailbox information and settings at the User level.  If you are using this format for mailbox authentication, please verify prior to installation that your database fields match the attached schema; otherwise mismatch errors can occur. 
 
NOTE: Mailbox aliases are not yet configurable in the database - they must be created in the Modus administration console: User's mailbox properties > Aliases tab.
 
Important Notes:
 
1. The table name must be called VOPMAIL (upper case).
 
2. Index the Username and Domain fields to help reduce processing time.
 

3. The attached database schema has been updated to increase the size of the auto responder / vacation and forwarding address fields.  If you wish to increase the size of these or any other fields without dropping and recreating the table, use the following procedure (instructions are for SQL):

  • Increase the size through the Enterprise Manager
  • Run the following script using the Query Analyzer:

alter table VOPMAIL

alter column auto_message varchar(255)
go
alter table VOPMail

alter column forward_to varchar(255)
go
 
Attachments
Modified 1/11/2007
Keywords:
Article ID: 1323