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>enum</type>
  72        <values>hour,day,week,month,year</values>
  73        <comment>Time units for reminder.</comment>
  74        <add>3.4</add>
  75        <html>
  76          <type>Select</type>
  77        </html>
  78   </field>
  79   <field>
  80        <name>start_action_condition</name>
  81        <type>varchar</type>
  82        <length>32</length>
  83        <comment>Reminder Action</comment>
  84        <add>3.4</add>
  85   </field>
  86   <field>
  87        <name>start_action_date</name>
  88        <type>varchar</type>
  89        <length>64</length>
  90        <comment>Entity date</comment>
  91        <add>3.4</add>
  92   </field>
  93   <field>
  94        <name>is_repeat</name>
  95        <title>Repeat?</title>
  96        <type>boolean</type>
  97        <default>0</default>
  98        <add>3.4</add>
  99   </field>
 100   <field>
 101        <name>repetition_frequency_unit</name>
 102        <type>enum</type>
 103        <values>hour,day,week,month,year</values>
 104        <comment>Time units for repetition of reminder.</comment>
 105        <add>3.4</add>
 106        <html>
 107          <type>Select</type>
 108        </html>
 109   </field>
 110   <field>
 111        <name>repetition_frequency_interval</name>
 112        <type>int unsigned</type>
 113        <comment>Time interval for repeating the reminder.</comment>
 114        <add>3.4</add>
 115   </field>
 116   <field>
 117        <name>end_frequency_unit</name>
 118        <type>enum</type>
 119        <values>hour,day,week,month,year</values>
 120        <comment>Time units till repetition of reminder.</comment>
 121        <add>3.4</add>
 122        <html>
 123          <type>Select</type>
 124        </html>
 125   </field>
 126   <field>
 127        <name>end_frequency_interval</name>
 128        <type>int unsigned</type>
 129        <comment>Time interval till repeating the reminder.</comment>
 130        <add>3.4</add>
 131   </field>
 132   <field>
 133        <name>end_action</name>
 134        <type>varchar</type>
 135        <length>32</length>
 136        <comment>Reminder Action till repeating the reminder.</comment>
 137        <add>3.4</add>
 138   </field>
 139   <field>
 140        <name>end_date</name>
 141        <type>varchar</type>
 142        <length>64</length>
 143        <comment>Entity end date</comment>
 144        <add>3.4</add>
 145   </field>
 146   <field>
 147        <name>is_active</name>
 148        <type>boolean</type>
 149        <default>1</default>
 150        <comment>Is this option active?</comment>
 151        <add>3.4</add>
 152   </field>
 153  <field>
 154       <name>recipient_manual</name>
 155       <title>Recipient Manual</title>
 156       <type>varchar</type>
 157       <length>128</length>
 158       <comment>Contact IDs to which reminder should be sent.</comment>
 159       <add>3.4</add>
 160   </field>
 161   <field>
 162       <name>recipient_listing</name>
 163       <title>Recipient Listing</title>
 164       <type>varchar</type>
 165       <length>128</length>
 166       <comment>listing based on recipient field.</comment>
 167       <add>4.1</add>
 168   </field>
 169   <field>
 170        <name>body_text</name>
 171        <type>longtext</type>
 172        <comment>Body of the mailing in text format.</comment>
 173        <add>3.4</add>
 174   </field>
 175   <field>
 176        <name>body_html</name>
 177        <type>longtext</type>
 178        <comment>Body of the mailing in html format.</comment>
 179        <add>3.4</add>
 180   </field>
 181   <field>
 182        <name>subject</name>
 183        <type>varchar</type>
 184        <length>128</length>
 185        <comment>Subject of mailing</comment>
 186        <add>3.4</add>
 187   </field>
 188  <field>
 189        <name>record_activity</name>
 190        <type>boolean</type>
 191        <default>NULL</default>
 192        <comment>Record Activity for this reminder?</comment>
 193        <add>3.4</add>
 194   </field>
 195   <field>
 196       <name>mapping_id</name>
 197       <type>int unsigned</type>
 198       <comment>FK to mapping which is being used by this reminder</comment>
 199       <add>3.4</add>
 200   </field>
 201   <foreignKey>
 202        <name>mapping_id</name>
 203        <table>civicrm_action_mapping</table>
 204        <key>id</key>
 205        <onDelete>SET NULL</onDelete>
 206   </foreignKey>
 207   <field>
 208     <name>group_id</name>
 209     <type>int unsigned</type>
 210     <comment>FK to Group</comment>
 211     <pseudoconstant>
 212       <table>civicrm_group</table>
 213       <keyColumn>id</keyColumn>
 214       <labelColumn>title</labelColumn>
 215     </pseudoconstant>
 216     <html>
 217       <type>Select</type>
 218     </html>
 219     <add>3.4</add>
 220   </field>
 221     <foreignKey>
 222         <name>group_id</name>
 223         <table>civicrm_group</table>
 224         <key>id</key>
 225         <onDelete>SET NULL</onDelete>
 226     </foreignKey>
 227     <field>
 228           <name>msg_template_id</name>
 229     <type>int unsigned</type>
 230     <comment>FK to the message template.</comment>
 231     </field>
 232     <foreignKey>
 233           <name>msg_template_id</name>
 234     <table>civicrm_msg_template</table>
 235     <key>id</key>
 236     <onDelete>SET NULL</onDelete>
 237     </foreignKey>
 238     <field>
 239        <name>absolute_date</name>
 240        <type>date</type>
 241        <comment>Date on which the reminder be sent.</comment>
 242        <add>4.1</add>
 243   </field>
 244 </table>