Merge remote-tracking branch 'upstream/4.5' into 4.5-master-2014-11-17-13-40-23
[civicrm-core.git] / xml / schema / Core / ActionSchedule.xml
index c519fa89f6818f815ed7f1bc5191bacfd6a5a030..40f4bec4fbb8537a5fcf85ead5896e2863453b7d 100644 (file)
@@ -43,7 +43,6 @@
   <field>
     <name>limit_to</name>
     <type>boolean</type>
-    <default>1</default>
     <comment>Is this the recipient criteria limited to OR in addition to?</comment>
     <add>4.4</add>
   </field>
     <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>
     <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>
     <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>