Merge pull request #4302 from guanhuan/additional-participant-fixes

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

diff --git a/xml/schema/Core/ActionSchedule.xml b/xml/schema/Core/ActionSchedule.xml
index c519fa89f6818f815ed7f1bc5191bacfd6a5a030..8253c06cd20d0feab35f9cc516513bbf0f6e9fa4 100644 (file)
--- a/xml/schema/Core/ActionSchedule.xml
+++ b/xml/schema/Core/ActionSchedule.xml
@@ -191,6 +191,13 @@
     <comment>Body of the mailing in html format.</comment>
     <add>3.4</add>
   </field>
+  <field>
+    <name>sms_body_text</name>
+    <title>SMS Reminder Text</title>
+    <type>longtext</type>
+    <comment>Content of the SMS text.</comment>
+    <add>4.5</add>
+  </field>
   <field>
     <name>subject</name>
     <title>Reminder Subject</title>
@@ -253,6 +260,18 @@
     <key>id</key>
     <onDelete>SET NULL</onDelete>
   </foreignKey>
+  <field>
+    <name>sms_template_id</name>
+    <title>SMS Reminder Template</title>
+    <type>int unsigned</type>
+    <comment>FK to the message template.</comment>
+  </field>
+  <foreignKey>
+    <name>msg_template_id</name>
+    <table>civicrm_msg_template</table>
+    <key>id</key>
+    <onDelete>SET NULL</onDelete>
+  </foreignKey>
   <field>
     <name>absolute_date</name>
     <title>Fixed Date for Reminder</title>
@@ -307,4 +326,11 @@
     <onDelete>SET NULL</onDelete>
     <add>4.5</add>
   </foreignKey>
+  <field>
+    <name>used_for</name>
+    <type>varchar</type>
+    <length>64</length>
+    <comment>Used for repeating entity</comment>
+    <add>4.6</add>
+  </field>
 </table>