crm.fsf.org/20131203/files/sites/all/modules-old/civicrm/xml/schema/Core/MailSettings.xml

   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     <title>Mail Settings ID</title>
  10     <type>int unsigned</type>
  11     <required>true</required>
  12     <comment>primary key</comment>
  13     <add>2.2</add>
  14   </field>
  15   <primaryKey>
  16     <name>id</name>
  17     <autoincrement>true</autoincrement>
  18   </primaryKey>
  19   <field>
  20     <name>domain_id</name>
  21     <title>Mail Settings Domain</title>
  22     <type>int unsigned</type>
  23     <required>true</required>
  24     <pseudoconstant>
  25       <table>civicrm_domain</table>
  26       <keyColumn>id</keyColumn>
  27       <labelColumn>name</labelColumn>
  28     </pseudoconstant>
  29     <comment>Which Domain is this match entry for</comment>
  30     <add>3.1</add>
  31   </field>
  32   <foreignKey>
  33     <name>domain_id</name>
  34     <table>civicrm_domain</table>
  35     <key>id</key>
  36     <add>4.5</add>
  37   </foreignKey>
  38   <field>
  39     <name>name</name>
  40     <title>Mail Settings Name</title>
  41     <type>varchar</type>
  42     <length>255</length>
  43     <comment>name of this group of settings</comment>
  44     <add>2.2</add>
  45   </field>
  46   <field>
  47     <name>is_default</name>
  48     <title>Is Default Mail Settings?</title>
  49     <type>boolean</type>
  50     <comment>whether this is the default set of settings for this domain</comment>
  51     <add>2.2</add>
  52   </field>
  53   <field>
  54     <name>domain</name>
  55     <title>email Domain</title>
  56     <type>varchar</type>
  57     <length>255</length>
  58     <comment>email address domain (the part after @)</comment>
  59     <add>2.2</add>
  60   </field>
  61   <field>
  62     <name>localpart</name>
  63     <title>email Local Part</title>
  64     <type>varchar</type>
  65     <length>255</length>
  66     <comment>optional local part (like civimail+ for addresses like civimail+s.1.2@example.com)</comment>
  67     <add>2.2</add>
  68   </field>
  69   <field>
  70     <name>return_path</name>
  71     <title>Return Path</title>
  72     <type>varchar</type>
  73     <length>255</length>
  74     <comment>contents of the Return-Path header</comment>
  75     <add>2.2</add>
  76   </field>
  77   <field>
  78     <name>protocol</name>
  79     <title>Protocol</title>
  80     <type>varchar</type>
  81     <length>255</length>
  82     <comment>name of the protocol to use for polling (like IMAP, POP3 or Maildir)</comment>
  83     <add>2.2</add>
  84     <pseudoconstant>
  85       <optionGroupName>mail_protocol</optionGroupName>
  86     </pseudoconstant>
  87     <html>
  88       <type>Select</type>
  89     </html>
  90   </field>
  91   <field>
  92     <name>server</name>
  93     <title>Mail Server</title>
  94     <type>varchar</type>
  95     <length>255</length>
  96     <comment>server to use when polling</comment>
  97     <add>2.2</add>
  98   </field>
  99   <field>
 100     <name>port</name>
 101     <title>Mail Port</title>
 102     <type>int unsigned</type>
 103     <comment>port to use when polling</comment>
 104     <add>2.2</add>
 105   </field>
 106   <field>
 107     <name>username</name>
 108     <title>Mail Account Username</title>
 109     <type>varchar</type>
 110     <length>255</length>
 111     <comment>username to use when polling</comment>
 112     <add>2.2</add>
 113   </field>
 114   <field>
 115     <name>password</name>
 116     <title>Mail Account Password</title>
 117     <type>varchar</type>
 118     <length>255</length>
 119     <comment>password to use when polling</comment>
 120     <add>2.2</add>
 121   </field>
 122   <field>
 123     <name>is_ssl</name>
 124     <title>Mail Account Uses SSL</title>
 125     <type>boolean</type>
 126     <comment>whether to use SSL or not</comment>
 127     <add>2.2</add>
 128   </field>
 129   <field>
 130     <name>source</name>
 131     <title>Mail Folder</title>
 132     <type>varchar</type>
 133     <length>255</length>
 134     <comment>folder to poll from when using IMAP, path to poll from when using Maildir, etc.</comment>
 135     <add>2.2</add>
 136   </field>
 137 </table>