[civicrm-core.git] / xml / schema / Core / MailSettings.xml

<table>
  <base>CRM/Core</base>
  <class>MailSettings</class>
  <name>civicrm_mail_settings</name>
  <comment>Various email accounts for use by CiviMail (and its processor)</comment>
  <add>2.2</add>
  <field>
    <name>id</name>
    <title>Mail Settings ID</title>
    <type>int unsigned</type>
    <required>true</required>
    <comment>primary key</comment>
    <html>
      <type>Number</type>
    </html>
    <add>2.2</add>
  </field>
  <primaryKey>
    <name>id</name>
    <autoincrement>true</autoincrement>
  </primaryKey>
  <field>
    <name>domain_id</name>
    <title>Domain ID</title>
    <type>int unsigned</type>
    <required>true</required>
    <pseudoconstant>
      <table>civicrm_domain</table>
      <keyColumn>id</keyColumn>
      <labelColumn>name</labelColumn>
    </pseudoconstant>
    <comment>Which Domain is this match entry for</comment>
    <html>
      <label>Domain</label>
    </html>
    <add>3.1</add>
  </field>
  <foreignKey>
    <name>domain_id</name>
    <table>civicrm_domain</table>
    <key>id</key>
    <add>4.5</add>
    <onDelete>CASCADE</onDelete>
  </foreignKey>
  <field>
    <name>name</name>
    <title>Mail Settings Name</title>
    <type>varchar</type>
    <length>255</length>
    <comment>name of this group of settings</comment>
    <add>2.2</add>
  </field>
  <field>
    <name>is_default</name>
    <title>Is Default Mail Settings?</title>
    <type>boolean</type>
    <comment>whether this is the default set of settings for this domain</comment>
    <add>2.2</add>
  </field>
  <field>
    <name>domain</name>
    <title>email Domain</title>
    <type>varchar</type>
    <length>255</length>
    <comment>email address domain (the part after @)</comment>
    <add>2.2</add>
  </field>
  <field>
    <name>localpart</name>
    <title>email Local Part</title>
    <type>varchar</type>
    <length>255</length>
    <comment>optional local part (like civimail+ for addresses like civimail+s.1.2@example.com)</comment>
    <add>2.2</add>
  </field>
  <field>
    <name>return_path</name>
    <title>Return Path</title>
    <type>varchar</type>
    <length>255</length>
    <comment>contents of the Return-Path header</comment>
    <add>2.2</add>
  </field>
  <field>
    <name>protocol</name>
    <title>Protocol</title>
    <type>varchar</type>
    <length>255</length>
    <comment>name of the protocol to use for polling (like IMAP, POP3 or Maildir)</comment>
    <add>2.2</add>
    <pseudoconstant>
      <optionGroupName>mail_protocol</optionGroupName>
    </pseudoconstant>
    <html>
      <type>Select</type>
    </html>
  </field>
  <field>
    <name>server</name>
    <title>Mail Server</title>
    <type>varchar</type>
    <length>255</length>
    <comment>server to use when polling</comment>
    <add>2.2</add>
  </field>
  <field>
    <name>port</name>
    <title>Mail Port</title>
    <type>int unsigned</type>
    <comment>port to use when polling</comment>
    <add>2.2</add>
  </field>
  <field>
    <name>username</name>
    <title>Mail Account Username</title>
    <type>varchar</type>
    <length>255</length>
    <comment>username to use when polling</comment>
    <add>2.2</add>
  </field>
  <field>
    <name>password</name>
    <title>Mail Account Password</title>
    <type>varchar</type>
    <length>255</length>
    <comment>password to use when polling</comment>
    <add>2.2</add>
  </field>
  <field>
    <name>is_ssl</name>
    <title>Mail Account Uses SSL</title>
    <type>boolean</type>
    <comment>whether to use SSL or not</comment>
    <add>2.2</add>
  </field>
  <field>
    <name>source</name>
    <title>Mail Folder</title>
    <type>varchar</type>
    <length>255</length>
    <comment>folder to poll from when using IMAP, path to poll from when using Maildir, etc.</comment>
    <add>2.2</add>
  </field>
  <field>
    <name>activity_status</name>
    <title>Activity Status</title>
    <type>varchar</type>
    <length>255</length>
    <comment>Name of status to use when creating email to activity.</comment>
    <add>4.7</add>
    <pseudoconstant>
      <optionGroupName>activity_status</optionGroupName>
      <keyColumn>name</keyColumn>
    </pseudoconstant>
    <html>
      <type>Select</type>
    </html>
  </field>
  <field>
    <name>is_non_case_email_skipped</name>
    <title>Skip emails which do not have a Case ID or Case hash</title>
    <type>boolean</type>
    <default>0</default>
    <html>
      <type>CheckBox</type>
    </html>
    <comment>Enabling this option will have CiviCRM skip any emails that do not have the Case ID or Case Hash so that the system will only process emails that can be placed on case records. Any emails that are not processed will be moved to the ignored folder.</comment>
    <add>5.31</add>
  </field>
  <field>
    <name>is_contact_creation_disabled_if_no_match</name>
    <type>boolean</type>
    <title>Do not create new contacts when filing emails</title>
    <default>0</default>
    <html>
      <type>CheckBox</type>
    </html>
    <description>If this option is enabled, CiviCRM will not create new contacts when filing emails.</description>
    <add>5.31</add>
  </field>
</table>
Commit	Line	Data
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>
45afd2ea	9	<title>Mail Settings ID</title>
6a488035 TO	10	<type>int unsigned</type>
	11	<required>true</required>
	12	<comment>primary key</comment>
0481e12c A	13	<html>
	14	<type>Number</type>
	15	</html>
6a488035 TO	16	<add>2.2</add>
	17	</field>
	18	<primaryKey>
	19	<name>id</name>
	20	<autoincrement>true</autoincrement>
	21	</primaryKey>
	22	<field>
4cc2ccac	23	<name>domain_id</name>
047c5009	24	<title>Domain ID</title>
4cc2ccac EM	25	<type>int unsigned</type>
	26	<required>true</required>
	27	<pseudoconstant>
	28	<table>civicrm_domain</table>
	29	<keyColumn>id</keyColumn>
	30	<labelColumn>name</labelColumn>
	31	</pseudoconstant>
	32	<comment>Which Domain is this match entry for</comment>
57e94608	33	<html>
047c5009	34	<label>Domain</label>
57e94608	35	</html>
4cc2ccac	36	<add>3.1</add>
6a488035	37	</field>
41876fd8	38	<foreignKey>
4cc2ccac EM	39	<name>domain_id</name>
	40	<table>civicrm_domain</table>
	41	<key>id</key>
	42	<add>4.5</add>
ce62f51a	43	<onDelete>CASCADE</onDelete>
41876fd8	44	</foreignKey>
6a488035 TO	45	<field>
6a488035 TO	46	<name>name</name>
45afd2ea	47	<title>Mail Settings Name</title>
6a488035 TO	48	<type>varchar</type>
	49	<length>255</length>
	50	<comment>name of this group of settings</comment>
	51	<add>2.2</add>
	52	</field>
	53	<field>
	54	<name>is_default</name>
45afd2ea	55	<title>Is Default Mail Settings?</title>
6a488035 TO	56	<type>boolean</type>
	57	<comment>whether this is the default set of settings for this domain</comment>
	58	<add>2.2</add>
	59	</field>
	60	<field>
	61	<name>domain</name>
45afd2ea	62	<title>email Domain</title>
6a488035 TO	63	<type>varchar</type>
	64	<length>255</length>
	65	<comment>email address domain (the part after @)</comment>
	66	<add>2.2</add>
	67	</field>
	68	<field>
	69	<name>localpart</name>
45afd2ea	70	<title>email Local Part</title>
6a488035 TO	71	<type>varchar</type>
	72	<length>255</length>
	73	<comment>optional local part (like civimail+ for addresses like civimail+s.1.2@example.com)</comment>
	74	<add>2.2</add>
	75	</field>
	76	<field>
	77	<name>return_path</name>
45afd2ea	78	<title>Return Path</title>
6a488035 TO	79	<type>varchar</type>
	80	<length>255</length>
	81	<comment>contents of the Return-Path header</comment>
	82	<add>2.2</add>
	83	</field>
	84	<field>
	85	<name>protocol</name>
45afd2ea	86	<title>Protocol</title>
6a488035 TO	87	<type>varchar</type>
	88	<length>255</length>
	89	<comment>name of the protocol to use for polling (like IMAP, POP3 or Maildir)</comment>
	90	<add>2.2</add>
cbf48754 AS	91	<pseudoconstant>
	92	<optionGroupName>mail_protocol</optionGroupName>
	93	</pseudoconstant>
614d72ec	94	<html>
e0991796	95	<type>Select</type>
614d72ec	96	</html>
6a488035 TO	97	</field>
	98	<field>
	99	<name>server</name>
45afd2ea	100	<title>Mail Server</title>
6a488035 TO	101	<type>varchar</type>
	102	<length>255</length>
	103	<comment>server to use when polling</comment>
	104	<add>2.2</add>
	105	</field>
	106	<field>
	107	<name>port</name>
45afd2ea	108	<title>Mail Port</title>
6a488035 TO	109	<type>int unsigned</type>
	110	<comment>port to use when polling</comment>
	111	<add>2.2</add>
	112	</field>
	113	<field>
	114	<name>username</name>
45afd2ea	115	<title>Mail Account Username</title>
6a488035 TO	116	<type>varchar</type>
	117	<length>255</length>
	118	<comment>username to use when polling</comment>
	119	<add>2.2</add>
	120	</field>
	121	<field>
	122	<name>password</name>
45afd2ea	123	<title>Mail Account Password</title>
6a488035 TO	124	<type>varchar</type>
	125	<length>255</length>
	126	<comment>password to use when polling</comment>
	127	<add>2.2</add>
	128	</field>
	129	<field>
	130	<name>is_ssl</name>
45afd2ea	131	<title>Mail Account Uses SSL</title>
6a488035 TO	132	<type>boolean</type>
	133	<comment>whether to use SSL or not</comment>
	134	<add>2.2</add>
	135	</field>
	136	<field>
	137	<name>source</name>
45afd2ea	138	<title>Mail Folder</title>
6a488035 TO	139	<type>varchar</type>
	140	<length>255</length>
	141	<comment>folder to poll from when using IMAP, path to poll from when using Maildir, etc.</comment>
	142	<add>2.2</add>
	143	</field>
040073c9 CW	144	<field>
	145	<name>activity_status</name>
	146	<title>Activity Status</title>
	147	<type>varchar</type>
	148	<length>255</length>
	149	<comment>Name of status to use when creating email to activity.</comment>
	150	<add>4.7</add>
	151	<pseudoconstant>
	152	<optionGroupName>activity_status</optionGroupName>
	153	<keyColumn>name</keyColumn>
	154	</pseudoconstant>
	155	<html>
	156	<type>Select</type>
	157	</html>
	158	</field>
f945f0c4 I	159	<field>
	160	<name>is_non_case_email_skipped</name>
	161	<title>Skip emails which do not have a Case ID or Case hash</title>
	162	<type>boolean</type>
	163	<default>0</default>
	164	<html>
	165	<type>CheckBox</type>
	166	</html>
	167	<comment>Enabling this option will have CiviCRM skip any emails that do not have the Case ID or Case Hash so that the system will only process emails that can be placed on case records. Any emails that are not processed will be moved to the ignored folder.</comment>
	168	<add>5.31</add>
	169	</field>
993a642c I	170	<field>
	171	<name>is_contact_creation_disabled_if_no_match</name>
	172	<type>boolean</type>
	173	<title>Do not create new contacts when filing emails</title>
	174	<default>0</default>
	175	<html>
	176	<type>CheckBox</type>
	177	</html>
	178	<description>If this option is enabled, CiviCRM will not create new contacts when filing emails.</description>
	179	<add>5.31</add>
	180	</field>
6a488035	181	</table>