CRM-14181 fixes - migrate enums to varchar in schema for all tables
[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>
614d72ec 68 <html>
e0991796 69 <type>Select</type>
614d72ec 70 </html>
6a488035
TO
71 </field>
72 <field>
73 <name>server</name>
74 <type>varchar</type>
75 <length>255</length>
76 <comment>server to use when polling</comment>
77 <add>2.2</add>
78 </field>
79 <field>
80 <name>port</name>
81 <type>int unsigned</type>
82 <comment>port to use when polling</comment>
83 <add>2.2</add>
84 </field>
85 <field>
86 <name>username</name>
87 <type>varchar</type>
88 <length>255</length>
89 <comment>username to use when polling</comment>
90 <add>2.2</add>
91 </field>
92 <field>
93 <name>password</name>
94 <type>varchar</type>
95 <length>255</length>
96 <comment>password to use when polling</comment>
97 <add>2.2</add>
98 </field>
99 <field>
100 <name>is_ssl</name>
101 <type>boolean</type>
102 <comment>whether to use SSL or not</comment>
103 <add>2.2</add>
104 </field>
105 <field>
106 <name>source</name>
107 <type>varchar</type>
108 <length>255</length>
109 <comment>folder to poll from when using IMAP, path to poll from when using Maildir, etc.</comment>
110 <add>2.2</add>
111 </field>
112</table>