Merge pull request #3915 from eileenmcnaughton/CRM-15168

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

diff --git a/xml/schema/Core/MailSettings.xml b/xml/schema/Core/MailSettings.xml
index 8f20d31ac500c608b115c9dbc9d8b30e1b4454c4..08585e17c59aa060b68c6fdac6e59f59c2b743cc 100644 (file)
--- a/xml/schema/Core/MailSettings.xml
+++ b/xml/schema/Core/MailSettings.xml
@@ -16,12 +16,23 @@
     <autoincrement>true</autoincrement>
   </primaryKey>
   <field>
-      <name>domain_id</name>
-      <type>int unsigned</type>
-      <required>true</required>
-      <comment>Which Domain is this match entry for</comment>
-      <add>3.1</add>
+    <name>domain_id</name>
+    <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>
+    <add>3.1</add>
   </field>
+  <foreignKey>
+    <name>domain_id</name>
+    <table>civicrm_domain</table>
+    <key>id</key>
+    <add>4.5</add>
+  </foreignKey>
   <field>
     <name>name</name>
     <type>varchar</type>