CRM-14955 - add custom tokens to greetings
[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>
41876fd8
PJ
25 <foreignKey>
26 <name>domain_id</name>
27 <table>civicrm_domain</table>
28 <key>id</key>
29 <add>4.5</add>
30 </foreignKey>
6a488035
TO
31 <field>
32 <name>name</name>
33 <type>varchar</type>
34 <length>255</length>
35 <comment>name of this group of settings</comment>
36 <add>2.2</add>
37 </field>
38 <field>
39 <name>is_default</name>
40 <type>boolean</type>
41 <comment>whether this is the default set of settings for this domain</comment>
42 <add>2.2</add>
43 </field>
44 <field>
45 <name>domain</name>
46 <type>varchar</type>
47 <length>255</length>
48 <comment>email address domain (the part after @)</comment>
49 <add>2.2</add>
50 </field>
51 <field>
52 <name>localpart</name>
53 <type>varchar</type>
54 <length>255</length>
55 <comment>optional local part (like civimail+ for addresses like civimail+s.1.2@example.com)</comment>
56 <add>2.2</add>
57 </field>
58 <field>
59 <name>return_path</name>
60 <type>varchar</type>
61 <length>255</length>
62 <comment>contents of the Return-Path header</comment>
63 <add>2.2</add>
64 </field>
65 <field>
66 <name>protocol</name>
67 <type>varchar</type>
68 <length>255</length>
69 <comment>name of the protocol to use for polling (like IMAP, POP3 or Maildir)</comment>
70 <add>2.2</add>
cbf48754
AS
71 <pseudoconstant>
72 <optionGroupName>mail_protocol</optionGroupName>
73 </pseudoconstant>
614d72ec 74 <html>
e0991796 75 <type>Select</type>
614d72ec 76 </html>
6a488035
TO
77 </field>
78 <field>
79 <name>server</name>
80 <type>varchar</type>
81 <length>255</length>
82 <comment>server to use when polling</comment>
83 <add>2.2</add>
84 </field>
85 <field>
86 <name>port</name>
87 <type>int unsigned</type>
88 <comment>port to use when polling</comment>
89 <add>2.2</add>
90 </field>
91 <field>
92 <name>username</name>
93 <type>varchar</type>
94 <length>255</length>
95 <comment>username to use when polling</comment>
96 <add>2.2</add>
97 </field>
98 <field>
99 <name>password</name>
100 <type>varchar</type>
101 <length>255</length>
102 <comment>password to use when polling</comment>
103 <add>2.2</add>
104 </field>
105 <field>
106 <name>is_ssl</name>
107 <type>boolean</type>
108 <comment>whether to use SSL or not</comment>
109 <add>2.2</add>
110 </field>
111 <field>
112 <name>source</name>
113 <type>varchar</type>
114 <length>255</length>
115 <comment>folder to poll from when using IMAP, path to poll from when using Maildir, etc.</comment>
116 <add>2.2</add>
117 </field>
118</table>