Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | INT UNSIGNED | 10 | √ | null |
|
|
primary key |
|||
| domain_id | INT UNSIGNED | 10 | null |
|
|
Which Domain is this match entry for |
||||
| name | VARCHAR | 255 | √ | null |
|
|
name of this group of settings |
|||
| is_default | TINYINT | 3 | √ | null |
|
|
whether this is the default set of settings for this domain |
|||
| domain | VARCHAR | 255 | √ | null |
|
|
email address domain (the part after @) |
|||
| localpart | VARCHAR | 255 | √ | null |
|
|
optional local part (like civimail+ for addresses like civimail+s.1.2@example.com) |
|||
| return_path | VARCHAR | 255 | √ | null |
|
|
contents of the Return-Path header |
|||
| protocol | VARCHAR | 255 | √ | null |
|
|
name of the protocol to use for polling (like IMAP, POP3 or Maildir) |
|||
| server | VARCHAR | 255 | √ | null |
|
|
server to use when polling |
|||
| port | INT UNSIGNED | 10 | √ | null |
|
|
port to use when polling |
|||
| username | VARCHAR | 255 | √ | null |
|
|
username to use when polling |
|||
| password | VARCHAR | 255 | √ | null |
|
|
password to use when polling |
|||
| is_ssl | TINYINT | 3 | √ | null |
|
|
whether to use SSL or not |
|||
| source | VARCHAR | 255 | √ | null |
|
|
folder to poll from when using IMAP, path to poll from when using Maildir, etc. |
|||
| activity_status | VARCHAR | 255 | √ | null |
|
|
Name of status to use when creating email to activity. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| FK_civicrm_mail_settings_domain_id | Performance | Asc | domain_id |
Relationships
Close relationships within degrees of separation
