CRM-12167: Start Implementation of Visibility per Price Option
[civicrm-core.git] / xml / schema / SMS / Provider.xml
index 72d9369cbc4097242c9d3d498d43d229e443d93f..354c14cf17b15a51bfa823ef03ac918af968c7f7 100644 (file)
       <type>CheckBox</type>
     </html>
   </field>
+  <field>
+    <name>domain_id</name>
+    <title>SMS Domain</title>
+    <type>int unsigned</type>
+    <pseudoconstant>
+      <table>civicrm_domain</table>
+      <keyColumn>id</keyColumn>
+      <labelColumn>name</labelColumn>
+    </pseudoconstant>
+    <comment>Which Domain is this sms provider for</comment>
+    <add>4.7</add>
+  </field>
+  <foreignKey>
+    <name>domain_id</name>
+    <table>civicrm_domain</table>
+    <key>id</key>
+    <add>4.7</add>
+    <onDelete>SET NULL</onDelete>
+  </foreignKey>
 </table>