• Share
    • Twitter
    • LinkedIn
    • Facebook
    • Email
  • Feedback
  • Edit
Show / Hide Table of Contents

config Table (255)

Some tooltip text!
• 4 minutes to read
 • 4 minutes to read

This table contains certain system-wide configuration values.

Fields

Name Description Type Null
id The primary key (auto-incremented) PK
text_path The path to the text-folder containing the emailBackup, trashbin, etc. subfolders. String(255) ●
attachment_path The path to the folder containing the attachments. String(255) ●
template_path The path to the templates used for the customer front-end. String(255) ●
admin_mail The email address to the administrator of the system. E.g. ejournal-admin@company.com. String(255) ●
default_mail The default from address in emails being sent from the system. E.g. support@company.com. String(255) ●
panic_mail The email address to where error messages are sent. Normally error@superoffice.com. String(255) ●
smtp_host The hostname or IP-address of the SMTP server used for sending email. String(255) ●
smtp_port The port of the SMTP server used for sending email. Int
cgi_bin The cgi-bin alias used to access the executables through HTTP. E.g. '/bin' String(255) ●
cgi_url The base URL to the system. E.g. 'http://ejournal.company.com'. String(255) ●
gfx_url The base URL to the graphics files. String(255) ●
warning The path + leading filename for the warning logfiles. String(255) ●
tag The tag used as ticket id identificator in the subject of emails. String(32) ●
mailheader The default header used (i.e. line 1) in outbound email. String(255) ●
autologout The number of minutes if idle time before a user is logged ut. A zero value means no autologout. Int ●
simautologout The number of minutes if idle time before a simultaneus user is logged ut. A zero value means no autologout. Int ●
flags A bitmask of flags controlling various options. Int ●
debug_flags A default bitmask of flags controlling debug logging. Int ●
language The systemlanguage. 'no' or 'en'. String(5) ●
mb_max_value This is the upper (initial) value for the spam-control algorithm, which makes sure that a single email address does not recieve too many emails. Int ●
mb_threshold This is the treshold value for the spam-contol algorithm. When the value for a given email address is below this value, emails will be blocked. Int ●
mb_modifier This is the 'cost' of sending an email, which is subtracted from the mb-value for the given email address. The mb-value is increased with 1 every second. Int ●
version The version of the installed software. String(32) ●
installed_at The timestamp of when the system was installed, or last upgraded. DateTime ●
installed_by Whoever installed the software. String(255) ●
unique_id An ID that should be unique for all eJournal installations. String(32) ●
cgi_url_internal The internal base URL to the system. E.g. 'http://ejournal.company.com'. String(255) ●
temp_license Temporary license key created for this session. String(255) ●
feature_toggle Temporary values used for feature toggles Clob ●

config table relationship diagram

Indexes

Fields Types Description
id PK Clustered, Unique

Replication Flags

  • None

Security Flags

  • No access control via user's Role.
© SuperOffice. All rights reserved.
SuperOffice |  Community |  Release Notes |  Privacy |  Site feedback |  Search Docs |  About Docs |  Contribute |  Back to top