<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>