xml/schema/Core/ActionSchedule.xml

   1 <?xml version="1.0" encoding="iso-8859-1" ?>
   2
   3 <table>
   4   <base>CRM/Core</base>
   5   <class>ActionSchedule</class>
   6   <name>civicrm_action_schedule</name>
   7   <comment>Table to store the reminders.</comment>
   8   <add>3.4</add>
   9   <field>
  10       <name>id</name>
  11       <type>int unsigned</type>
  12       <required>true</required>
  13       <add>3.4</add>
  14   </field>
  15   <primaryKey>
  16        <name>id</name>
  17        <autoincrement>true</autoincrement>
  18   </primaryKey>
  19   <field>
  20        <name>name</name>
  21        <title>Name</title>
  22        <type>varchar</type>
  23        <length>64</length>
  24        <comment>Name of the action(reminder)</comment>
  25        <add>3.4</add>
  26   </field>
  27   <field>
  28        <name>title</name>
  29        <title>Title</title>
  30        <type>varchar</type>
  31        <length>64</length>
  32        <comment>Title of the action(reminder)</comment>
  33        <add>3.4</add>
  34   </field>
  35   <field>
  36        <name>recipient</name>
  37        <type>varchar</type>
  38        <length>64</length>
  39        <comment>Recipient</comment>
  40        <add>3.4</add>
  41   </field>
  42   <field>
  43        <name>limit_to</name>
  44        <type>boolean</type>
  45        <default>1</default>
  46        <comment>Is this the recipient criteria limited to OR in addition to?</comment>
  47        <add>4.4</add>
  48   </field>
  49   <field>
  50        <name>entity_value</name>
  51        <type>varchar</type>
  52        <length>64</length>
  53        <comment>Entity value</comment>
  54        <add>3.4</add>
  55   </field>
  56   <field>
  57        <name>entity_status</name>
  58        <type>varchar</type>
  59        <length>64</length>
  60        <comment>Entity status</comment>
  61        <add>3.4</add>
  62   </field>
  63   <field>
  64        <name>start_action_offset</name>
  65        <type>int unsigned</type>
  66        <comment>Reminder Interval.</comment>
  67        <add>3.4</add>
  68   </field>
  69   <field>
  70        <name>start_action_unit</name>
  71        <type>varchar</type>
  72        <length>8</length>
  73        <comment>Time units for reminder.</comment>
  74        <pseudoconstant>
  75          <optionGroupName>recur_frequency_units</optionGroupName>
  76          <keyColumn>name</keyColumn>
  77        </pseudoconstant>
  78        <add>3.4</add>
  79        <html>
  80          <type>Select</type>
  81        </html>
  82   </field>
  83   <field>
  84        <name>start_action_condition</name>
  85        <type>varchar</type>
  86        <length>32</length>
  87        <comment>Reminder Action</comment>
  88        <add>3.4</add>
  89   </field>
  90   <field>
  91        <name>start_action_date</name>
  92        <type>varchar</type>
  93        <length>64</length>
  94        <comment>Entity date</comment>
  95        <add>3.4</add>
  96   </field>
  97   <field>
  98        <name>is_repeat</name>
  99        <title>Repeat?</title>
 100        <type>boolean</type>
 101        <default>0</default>
 102        <add>3.4</add>
 103   </field>
 104   <field>
 105        <name>repetition_frequency_unit</name>
 106        <type>varchar</type>
 107        <length>8</length>
 108        <comment>Time units for repetition of reminder.</comment>
 109        <pseudoconstant>
 110          <optionGroupName>recur_frequency_units</optionGroupName>
 111          <keyColumn>name</keyColumn>
 112        </pseudoconstant>
 113        <add>3.4</add>
 114        <html>
 115          <type>Select</type>
 116        </html>
 117   </field>
 118   <field>
 119        <name>repetition_frequency_interval</name>
 120        <type>int unsigned</type>
 121        <comment>Time interval for repeating the reminder.</comment>
 122        <add>3.4</add>
 123   </field>
 124   <field>
 125        <name>end_frequency_unit</name>
 126        <type>varchar</type>
 127        <length>8</length>
 128        <comment>Time units till repetition of reminder.</comment>
 129        <pseudoconstant>
 130          <optionGroupName>recur_frequency_units</optionGroupName>
 131          <keyColumn>name</keyColumn>
 132        </pseudoconstant>
 133        <add>3.4</add>
 134        <html>
 135          <type>Select</type>
 136        </html>
 137   </field>
 138   <field>
 139        <name>end_frequency_interval</name>
 140        <type>int unsigned</type>
 141        <comment>Time interval till repeating the reminder.</comment>
 142        <add>3.4</add>
 143   </field>
 144   <field>
 145        <name>end_action</name>
 146        <type>varchar</type>
 147        <length>32</length>
 148        <comment>Reminder Action till repeating the reminder.</comment>
 149        <add>3.4</add>
 150   </field>
 151   <field>
 152        <name>end_date</name>
 153        <type>varchar</type>
 154        <length>64</length>
 155        <comment>Entity end date</comment>
 156        <add>3.4</add>
 157   </field>
 158   <field>
 159        <name>is_active</name>
 160        <type>boolean</type>
 161        <default>1</default>
 162        <comment>Is this option active?</comment>
 163        <add>3.4</add>
 164   </field>
 165  <field>
 166       <name>recipient_manual</name>
 167       <title>Recipient Manual</title>
 168       <type>varchar</type>
 169       <length>128</length>
 170       <comment>Contact IDs to which reminder should be sent.</comment>
 171       <add>3.4</add>
 172   </field>
 173   <field>
 174       <name>recipient_listing</name>
 175       <title>Recipient Listing</title>
 176       <type>varchar</type>
 177       <length>128</length>
 178       <comment>listing based on recipient field.</comment>
 179       <add>4.1</add>
 180   </field>
 181   <field>
 182        <name>body_text</name>
 183        <type>longtext</type>
 184        <comment>Body of the mailing in text format.</comment>
 185        <add>3.4</add>
 186   </field>
 187   <field>
 188        <name>body_html</name>
 189        <type>longtext</type>
 190        <comment>Body of the mailing in html format.</comment>
 191        <add>3.4</add>
 192   </field>
 193   <field>
 194        <name>subject</name>
 195        <type>varchar</type>
 196        <length>128</length>
 197        <comment>Subject of mailing</comment>
 198        <add>3.4</add>
 199   </field>
 200  <field>
 201        <name>record_activity</name>
 202        <type>boolean</type>
 203        <default>NULL</default>
 204        <comment>Record Activity for this reminder?</comment>
 205        <add>3.4</add>
 206   </field>
 207   <field>
 208       <name>mapping_id</name>
 209       <type>int unsigned</type>
 210       <comment>FK to mapping which is being used by this reminder</comment>
 211       <add>3.4</add>
 212   </field>
 213   <foreignKey>
 214        <name>mapping_id</name>
 215        <table>civicrm_action_mapping</table>
 216        <key>id</key>
 217        <onDelete>SET NULL</onDelete>
 218   </foreignKey>
 219   <field>
 220     <name>group_id</name>
 221     <type>int unsigned</type>
 222     <comment>FK to Group</comment>
 223     <pseudoconstant>
 224       <table>civicrm_group</table>
 225       <keyColumn>id</keyColumn>
 226       <labelColumn>title</labelColumn>
 227     </pseudoconstant>
 228     <html>
 229       <type>Select</type>
 230     </html>
 231     <add>3.4</add>
 232   </field>
 233     <foreignKey>
 234         <name>group_id</name>
 235         <table>civicrm_group</table>
 236         <key>id</key>
 237         <onDelete>SET NULL</onDelete>
 238     </foreignKey>
 239     <field>
 240           <name>msg_template_id</name>
 241     <type>int unsigned</type>
 242     <comment>FK to the message template.</comment>
 243     </field>
 244     <foreignKey>
 245           <name>msg_template_id</name>
 246     <table>civicrm_msg_template</table>
 247     <key>id</key>
 248     <onDelete>SET NULL</onDelete>
 249     </foreignKey>
 250     <field>
 251        <name>absolute_date</name>
 252        <type>date</type>
 253        <comment>Date on which the reminder be sent.</comment>
 254        <add>4.1</add>
 255   </field>
 256   <field>
 257     <name>mode</name>
 258     <title>Message Mode</title>
 259     <default>"Email"</default>
 260     <type>varchar</type>
 261     <length>128</length>
 262     <comment>Send the message as email or sms or both.</comment>
 263     <pseudoconstant>
 264       <optionGroupName>msg_mode</optionGroupName>
 265     </pseudoconstant>
 266     <html>
 267       <type>Select</type>
 268     </html>
 269     <add>4.5</add>
 270   </field>
 271   <field>
 272     <name>sms_provider_id</name>
 273     <type>int unsigned</type>
 274     <add>4.5</add>
 275     <html>
 276       <type>Select</type>
 277     </html>
 278   </field>
 279   <foreignKey>
 280     <name>sms_provider_id</name>
 281     <table>civicrm_sms_provider</table>
 282     <key>id</key>
 283     <onDelete>SET NULL</onDelete>
 284     <add>4.5</add>
 285   </foreignKey>
 286 </table>