Merge pull request #2120 from pratik-joshi/CRM-13857
[civicrm-core.git] / xml / schema / Core / MailSettings.xml
CommitLineData
6a488035
TO
1<table>
2 <base>CRM/Core</base>
3 <class>MailSettings</class>
4 <name>civicrm_mail_settings</name>
5 <comment>Various email accounts for use by CiviMail (and its processor)</comment>
6 <add>2.2</add>
7 <field>
8 <name>id</name>
9 <type>int unsigned</type>
10 <required>true</required>
11 <comment>primary key</comment>
12 <add>2.2</add>
13 </field>
14 <primaryKey>
15 <name>id</name>
16 <autoincrement>true</autoincrement>
17 </primaryKey>
18 <field>
19 <name>domain_id</name>
20 <type>int unsigned</type>
21 <required>true</required>
22 <comment>Which Domain is this match entry for</comment>
23 <add>3.1</add>
24 </field>
25 <field>
26 <name>name</name>
27 <type>varchar</type>
28 <length>255</length>
29 <comment>name of this group of settings</comment>
30 <add>2.2</add>
31 </field>
32 <field>
33 <name>is_default</name>
34 <type>boolean</type>
35 <comment>whether this is the default set of settings for this domain</comment>
36 <add>2.2</add>
37 </field>
38 <field>
39 <name>domain</name>
40 <type>varchar</type>
41 <length>255</length>
42 <comment>email address domain (the part after @)</comment>
43 <add>2.2</add>
44 </field>
45 <field>
46 <name>localpart</name>
47 <type>varchar</type>
48 <length>255</length>
49 <comment>optional local part (like civimail+ for addresses like civimail+s.1.2@example.com)</comment>
50 <add>2.2</add>
51 </field>
52 <field>
53 <name>return_path</name>
54 <type>varchar</type>
55 <length>255</length>
56 <comment>contents of the Return-Path header</comment>
57 <add>2.2</add>
58 </field>
59 <field>
60 <name>protocol</name>
61 <type>varchar</type>
62 <length>255</length>
63 <comment>name of the protocol to use for polling (like IMAP, POP3 or Maildir)</comment>
64 <add>2.2</add>
cbf48754
AS
65 <pseudoconstant>
66 <optionGroupName>mail_protocol</optionGroupName>
67 </pseudoconstant>
6a488035
TO
68 </field>
69 <field>
70 <name>server</name>
71 <type>varchar</type>
72 <length>255</length>
73 <comment>server to use when polling</comment>
74 <add>2.2</add>
75 </field>
76 <field>
77 <name>port</name>
78 <type>int unsigned</type>
79 <comment>port to use when polling</comment>
80 <add>2.2</add>
81 </field>
82 <field>
83 <name>username</name>
84 <type>varchar</type>
85 <length>255</length>
86 <comment>username to use when polling</comment>
87 <add>2.2</add>
88 </field>
89 <field>
90 <name>password</name>
91 <type>varchar</type>
92 <length>255</length>
93 <comment>password to use when polling</comment>
94 <add>2.2</add>
95 </field>
96 <field>
97 <name>is_ssl</name>
98 <type>boolean</type>
99 <comment>whether to use SSL or not</comment>
100 <add>2.2</add>
101 </field>
102 <field>
103 <name>source</name>
104 <type>varchar</type>
105 <length>255</length>
106 <comment>folder to poll from when using IMAP, path to poll from when using Maildir, etc.</comment>
107 <add>2.2</add>
108 </field>
109</table>