Merge branch 'master' of https://github.com/rollox/civicrm-core into CRM-18317
[civicrm-core.git] / xml / schema / Core / ActionSchedule.xml
index 587f68f940432dc1dd60def44611757d08168c0f..dc1512120140dcded118b132e4df59d56ad12a49 100644 (file)
   <field>
     <name>mapping_id</name>
     <title>Reminder Mapping</title>
-    <type>int unsigned</type>
-    <comment>FK to mapping which is being used by this reminder</comment>
+    <type>varchar</type>
+    <length>64</length>
+    <comment>Name/ID of the mapping to use on this table</comment>
     <add>3.4</add>
   </field>
-  <foreignKey>
-    <name>mapping_id</name>
-    <table>civicrm_action_mapping</table>
-    <key>id</key>
-    <onDelete>SET NULL</onDelete>
-  </foreignKey>
   <field>
     <name>group_id</name>
     <title>Reminder Group</title>
     <comment>FK to the message template.</comment>
   </field>
   <foreignKey>
-    <name>msg_template_id</name>
+    <name>sms_template_id</name>
     <table>civicrm_msg_template</table>
     <key>id</key>
     <onDelete>SET NULL</onDelete>
     <comment>Used for repeating entity</comment>
     <add>4.6</add>
   </field>
+  <field>
+    <name>filter_contact_language</name>
+    <type>varchar</type>
+    <length>128</length>
+    <comment>Used for multilingual installation</comment>
+    <add>4.7</add>
+  </field>
+  <field>
+    <name>communication_language</name>
+    <type>varchar</type>
+    <length>8</length>
+    <comment>Used for multilingual installation</comment>
+    <add>4.7</add>
+  </field>
 </table>