MAILEXPRESS

Basic Index   Expanded Index

Table Name: medatabase.DatabasePurgeConfigLog
Description: Auditing table for changes to corresponding with table DatabasePurgeConfig.
Primary Keys: identifier
logNumber
Field Type Defaults Nulls? Comments
identifier numeric (19) None No Unique ID for an entry.
logNumber numeric (19) None No Audit log identifier.
auditLogHistThreshTimeNumber int None Yes The numerical component of the threshold at which the audit log data will be purged.
auditLogHistThreshTimeUnit nvarchar (255) None Yes The time unit component of the threshold at which the audit log data will be purged. Values values: MINUTES, HOURS, DAYS, WEEKS, MONTHS, YEARS.
enableAuditLogPurge tinyint None Yes Enables purging of audit and transaction logs.
enableFullStorageNotification tinyint None Yes Enables system notification when the database has reached its size quota.
sizeNotifPeriodTimeNumber int None Yes The numerical component of the period at which notifications will be sent.
sizeNotifPeriodTimeUnit nvarchar (255) None Yes The time unit component of the period at which notifications will be sent. Values values: MINUTES, HOURS, DAYS, WEEKS, MONTHS, YEARS.
fullStorageThreshold int None Yes The percentage of the database size quota at which to send a notification.
storageQuota numeric (38, 2) None Yes The maximum size, in bytes, allotted for the database.

Index Clustered? Unique? Fields
PK__Database__B55535B711E05B9E Yes Yes identifier
logNumber

No check constraints
Internal Foreign Key Constraint Affected Field Source Table
FK91751EB2D247948F identifier AbstractSingletonLog
FK91751EB2D247948F logNumber AbstractSingletonLog

No primary keys as foreign key constraints
No triggers

For more information, review the topics in the Contents to the left. If the Contents pane is hidden, click <--Show.

You can also search the Knowledgebase for help, or pose your question in the Globalscape User Forum. Visit the Mail Express Support Center for the most up-to-date information, to view version history, updates, and activation instructions, or to download a PDF of this user guide. For information about Globalscape, visit www.globalscape.com or follow us on Twitter.

Last modified: 07 October 2013 at 9:14:21