Merge pull request #4027 from magnolia61/(CRM-15223)-Include-gender-and-age-in-(const...
[civicrm-core.git] / xml / schema / Core / ActionSchedule.xml
index 6d941768a2874bee04991e47a1977290698f272a..726da804dc0225e0851f6864aa9bdbf38038eef1 100644 (file)
@@ -8,6 +8,7 @@
   <add>3.4</add>
   <field>
     <name>id</name>
+    <title>Action Schedule ID</title>
     <type>int unsigned</type>
     <required>true</required>
     <add>3.4</add>
   </field>
   <field>
     <name>is_active</name>
+    <title>Schedule is Active?</title>
     <type>boolean</type>
     <default>1</default>
     <comment>Is this option active?</comment>
   </field>
   <field>
     <name>body_text</name>
+    <title>Reminder Text</title>
     <type>longtext</type>
     <comment>Body of the mailing in text format.</comment>
     <add>3.4</add>
   </field>
   <field>
     <name>body_html</name>
+    <title>Reminder HTML</title>
     <type>longtext</type>
     <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>
     <type>varchar</type>
     <length>128</length>
     <comment>Subject of mailing</comment>
   </field>
   <field>
     <name>record_activity</name>
+    <title>Record Activity for Reminder?</title>
     <type>boolean</type>
     <default>NULL</default>
     <comment>Record Activity for this reminder?</comment>
   </field>
   <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>
     <add>3.4</add>
   </foreignKey>
   <field>
     <name>group_id</name>
+    <title>Reminder Group</title>
     <type>int unsigned</type>
     <comment>FK to Group</comment>
     <pseudoconstant>
   </foreignKey>
   <field>
     <name>msg_template_id</name>
+    <title>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>sms_template_id</name>
+    <title>SMS Reminder Template</title>
     <type>int unsigned</type>
     <comment>FK to the message template.</comment>
   </field>
   </foreignKey>
   <field>
     <name>absolute_date</name>
+    <title>Fixed Date for Reminder</title>
     <type>date</type>
     <comment>Date on which the reminder be sent.</comment>
     <add>4.1</add>
   </field>
   <field>
     <name>from_name</name>
+    <title>Reminder from Name</title>
     <type>varchar</type>
     <length>255</length>
     <comment>Name in "from" field</comment>
   </field>
   <field>
     <name>from_email</name>
+    <title>Reminder From Email</title>
     <type>varchar</type>
     <length>255</length>
     <comment>Email address in "from" field</comment>
   </field>
   <field>
     <name>sms_provider_id</name>
+    <title>SMS Provider</title>
     <type>int unsigned</type>
     <add>4.5</add>
     <html>