config Table (255)
•
Environment: onsite, online
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 | ● |
Indexes
| Fields | Types | Description |
|---|---|---|
| id | PK | Clustered, Unique |
Replication Flags
- None
Security Flags
- No access control via user's Role.