[civicrm-core.git] / xml / schema / Core / ActionSchedule.xml

<?xml version="1.0" encoding="iso-8859-1" ?>

<table>
  <base>CRM/Core</base>
  <class>ActionSchedule</class>
  <name>civicrm_action_schedule</name>
  <comment>Table to store the reminders.</comment>
  <add>3.4</add>
  <field>
    <name>id</name>
    <title>Action Schedule ID</title>
    <type>int unsigned</type>
    <required>true</required>
    <html>
      <type>Number</type>
    </html>
    <add>3.4</add>
  </field>
  <primaryKey>
    <name>id</name>
    <autoincrement>true</autoincrement>
  </primaryKey>
  <field>
    <name>name</name>
    <title>Name</title>
    <type>varchar</type>
    <length>64</length>
    <comment>Name of the action(reminder)</comment>
    <add>3.4</add>
  </field>
  <field>
    <name>title</name>
    <title>Title</title>
    <type>varchar</type>
    <length>64</length>
    <comment>Title of the action(reminder)</comment>
    <add>3.4</add>
  </field>
  <field>
    <name>recipient</name>
    <type>varchar</type>
    <length>64</length>
    <comment>Recipient</comment>
    <html>
      <label>Recipient</label>
    </html>
    <add>3.4</add>
  </field>
  <field>
    <name>limit_to</name>
    <type>boolean</type>
    <comment>Is this the recipient criteria limited to OR in addition to?</comment>
    <html>
      <label>Limit To</label>
    </html>
    <default>1</default>
    <required>true</required>
    <add>4.4</add>
  </field>
  <field>
    <name>entity_value</name>
    <type>varchar</type>
    <length>255</length>
    <comment>Entity value</comment>
    <serialize>SEPARATOR_TRIMMED</serialize>
    <html>
      <label>Entity value</label>
    </html>
    <add>3.4</add>
  </field>
  <field>
    <name>entity_status</name>
    <type>varchar</type>
    <length>64</length>
    <comment>Entity status</comment>
    <serialize>SEPARATOR_TRIMMED</serialize>
    <html>
      <label>Entity Status</label>
    </html>
    <add>3.4</add>
  </field>
  <field>
    <name>start_action_offset</name>
    <type>int unsigned</type>
    <comment>Reminder Interval.</comment>
    <default>0</default>
    <html>
      <label>Start Action Offset</label>
    </html>
    <add>3.4</add>
  </field>
  <field>
    <name>start_action_unit</name>
    <type>varchar</type>
    <length>8</length>
    <comment>Time units for reminder.</comment>
    <pseudoconstant>
      <callback>CRM_Core_SelectValues::getRecurringFrequencyUnits</callback>
    </pseudoconstant>
    <add>3.4</add>
    <html>
      <type>Select</type>
      <label>Start Action Unit</label>
    </html>
  </field>
  <field>
    <name>start_action_condition</name>
    <type>varchar</type>
    <length>64</length>
    <comment>Reminder Action</comment>
    <html>
      <label>Start Action condition</label>
    </html>
    <add>3.4</add>
  </field>
  <field>
    <name>start_action_date</name>
    <type>varchar</type>
    <length>64</length>
    <comment>Entity date</comment>
    <html>
      <label>Start Action Date</label>
    </html>
    <add>3.4</add>
  </field>
  <field>
    <name>is_repeat</name>
    <title>Repeat?</title>
    <type>boolean</type>
    <default>0</default>
    <required>true</required>
    <add>3.4</add>
  </field>
  <field>
    <name>repetition_frequency_unit</name>
    <type>varchar</type>
    <length>8</length>
    <comment>Time units for repetition of reminder.</comment>
    <pseudoconstant>
      <callback>CRM_Core_SelectValues::getRecurringFrequencyUnits</callback>
    </pseudoconstant>
    <add>3.4</add>
    <html>
      <type>Select</type>
      <label>Repetition Frequency Unit</label>
    </html>
  </field>
  <field>
    <name>repetition_frequency_interval</name>
    <type>int unsigned</type>
    <default>0</default>
    <comment>Time interval for repeating the reminder.</comment>
    <html>
      <label>Repetition Frequency Interval</label>
    </html>
    <add>3.4</add>
  </field>
  <field>
    <name>end_frequency_unit</name>
    <type>varchar</type>
    <length>8</length>
    <comment>Time units till repetition of reminder.</comment>
    <pseudoconstant>
      <callback>CRM_Core_SelectValues::getRecurringFrequencyUnits</callback>
    </pseudoconstant>
    <add>3.4</add>
    <html>
      <type>Select</type>
      <label>End Frequency Unit</label>
    </html>
  </field>
  <field>
    <name>end_frequency_interval</name>
    <type>int unsigned</type>
    <comment>Time interval till repeating the reminder.</comment>
    <html>
      <label>End Frequency Interval</label>
    </html>
    <add>3.4</add>
    <default>0</default>
  </field>
  <field>
    <name>end_action</name>
    <type>varchar</type>
    <length>32</length>
    <comment>Reminder Action till repeating the reminder.</comment>
    <html>
      <label>End Action</label>
    </html>
    <add>3.4</add>
  </field>
  <field>
    <name>end_date</name>
    <type>varchar</type>
    <length>64</length>
    <comment>Entity end date</comment>
    <html>
      <label>End Date</label>
    </html>
    <add>3.4</add>
  </field>
  <field>
    <name>is_active</name>
    <title>Schedule is Active?</title>
    <type>boolean</type>
    <default>1</default>
    <required>true</required>
    <comment>Is this option active?</comment>
    <add>3.4</add>
  </field>
  <field>
    <name>recipient_manual</name>
    <title>Recipient Manual</title>
    <type>varchar</type>
    <length>128</length>
    <comment>Contact IDs to which reminder should be sent.</comment>
    <serialize>COMMA</serialize>
    <add>3.4</add>
  </field>
  <field>
    <name>recipient_listing</name>
    <title>Recipient Listing</title>
    <type>varchar</type>
    <length>128</length>
    <comment>listing based on recipient field.</comment>
    <add>4.1</add>
  </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>
    <add>3.4</add>
  </field>
  <field>
    <name>record_activity</name>
    <title>Record Activity for Reminder?</title>
    <type>boolean</type>
    <default>0</default>
    <required>true</required>
    <comment>Record Activity for this reminder?</comment>
    <add>3.4</add>
  </field>
  <field>
    <name>mapping_id</name>
    <title>Reminder Mapping</title>
    <type>varchar</type>
    <length>64</length>
    <comment>Name/ID of the mapping to use on this table</comment>
    <add>3.4</add>
  </field>
  <field>
    <name>group_id</name>
    <title>Group ID</title>
    <type>int unsigned</type>
    <comment>FK to Group</comment>
    <pseudoconstant>
      <table>civicrm_group</table>
      <keyColumn>id</keyColumn>
      <labelColumn>title</labelColumn>
    </pseudoconstant>
    <html>
      <type>Select</type>
      <label>Group</label>
    </html>
    <add>3.4</add>
  </field>
  <foreignKey>
    <name>group_id</name>
    <table>civicrm_group</table>
    <key>id</key>
    <onDelete>SET NULL</onDelete>
  </foreignKey>
  <field>
    <name>msg_template_id</name>
    <title>Message Template ID</title>
    <type>int unsigned</type>
    <comment>FK to the message template.</comment>
    <html>
      <label>Message Template</label>
    </html>
  </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 Template ID</title>
    <type>int unsigned</type>
    <comment>FK to the message template.</comment>
    <html>
      <label>SMS Template</label>
    </html>
  </field>
  <foreignKey>
    <name>sms_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>
    <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>
    <add>4.5</add>
  </field>
  <field>
    <name>from_email</name>
    <title>Reminder From Email</title>
    <type>varchar</type>
    <length>255</length>
    <comment>Email address in "from" field</comment>
    <add>4.5</add>
  </field>
  <field>
    <name>mode</name>
    <title>Message Mode</title>
    <default>"Email"</default>
    <type>varchar</type>
    <length>128</length>
    <comment>Send the message as email or sms or both.</comment>
    <pseudoconstant>
      <optionGroupName>msg_mode</optionGroupName>
    </pseudoconstant>
    <html>
      <type>Select</type>
    </html>
    <add>4.5</add>
  </field>
  <field>
    <name>sms_provider_id</name>
    <title>SMS Provider ID</title>
    <type>int unsigned</type>
    <add>4.5</add>
    <html>
      <type>Select</type>
      <label>SMS Provider</label>
    </html>
  </field>
  <foreignKey>
    <name>sms_provider_id</name>
    <table>civicrm_sms_provider</table>
    <key>id</key>
    <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>
    <html>
      <label>Used For</label>
    </html>
    <add>4.6</add>
  </field>
  <field>
    <name>filter_contact_language</name>
    <type>varchar</type>
    <length>128</length>
    <comment>Used for multilingual installation</comment>
    <html>
      <label>Filter Contact Language</label>
    </html>
    <add>4.7</add>
  </field>
  <field>
    <name>communication_language</name>
    <type>varchar</type>
    <length>8</length>
    <comment>Used for multilingual installation</comment>
    <html>
      <label>Communication Language</label>
    </html>
    <add>4.7</add>
  </field>
  <field>
    <name>created_date</name>
    <title>Created Date</title>
    <uniqueName>action_schedule_created_date</uniqueName>
    <type>timestamp</type>
    <comment>When was the scheduled reminder created.</comment>
    <required>false</required>
    <export>true</export>
    <default>CURRENT_TIMESTAMP</default>
    <add>5.34</add>
  </field>
  <field>
    <name>modified_date</name>
    <type>timestamp</type>
    <comment>When the reminder was created or modified.</comment>
    <required>false</required>
    <default>CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP</default>
    <html>
      <label>Modified Date</label>
    </html>
    <add>5.34</add>
    <readonly>true</readonly>
  </field>
  <field>
    <name>effective_start_date</name>
    <title>Effective start date</title>
    <uniqueName>action_schedule_effective_start_date</uniqueName>
    <type>timestamp</type>
    <comment>Earliest date to consider start events from.</comment>
    <required>false</required>
    <export>true</export>
    <add>5.34</add>
  </field>
  <field>
    <name>effective_end_date</name>
    <title>Effective end date</title>
    <uniqueName>action_schedule_effective_end_date</uniqueName>
    <type>timestamp</type>
    <comment>Latest date to consider end events from.</comment>
    <required>false</required>
    <export>true</export>
    <add>5.34</add>
  </field>
</table>
Commit	Line	Data
6a488035 TO	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>
8f069c03	10	<name>id</name>
7cd3d797	11	<title>Action Schedule ID</title>
8f069c03 EM	12	<type>int unsigned</type>
8f069c03 EM	13	<required>true</required>
0481e12c A	14	<html>
	15	<type>Number</type>
	16	</html>
8f069c03	17	<add>3.4</add>
6a488035 TO	18	</field>
6a488035 TO	19	<primaryKey>
8f069c03 EM	20	<name>id</name>
8f069c03 EM	21	<autoincrement>true</autoincrement>
6a488035 TO	22	</primaryKey>
6a488035 TO	23	<field>
8f069c03 EM	24	<name>name</name>
	25	<title>Name</title>
	26	<type>varchar</type>
	27	<length>64</length>
	28	<comment>Name of the action(reminder)</comment>
	29	<add>3.4</add>
6a488035 TO	30	</field>
6a488035 TO	31	<field>
8f069c03 EM	32	<name>title</name>
	33	<title>Title</title>
	34	<type>varchar</type>
	35	<length>64</length>
	36	<comment>Title of the action(reminder)</comment>
	37	<add>3.4</add>
	38	</field>
6a488035	39	<field>
8f069c03 EM	40	<name>recipient</name>
	41	<type>varchar</type>
	42	<length>64</length>
	43	<comment>Recipient</comment>
1662d426 A	44	<html>
	45	<label>Recipient</label>
	46	</html>
8f069c03	47	<add>3.4</add>
6a488035	48	</field>
3e315abc	49	<field>
8f069c03 EM	50	<name>limit_to</name>
8f069c03 EM	51	<type>boolean</type>
8f069c03	52	<comment>Is this the recipient criteria limited to OR in addition to?</comment>
1662d426 A	53	<html>
	54	<label>Limit To</label>
	55	</html>
c1e814c7 MD	56	<default>1</default>
c1e814c7 MD	57	<required>true</required>
8f069c03	58	<add>4.4</add>
3e315abc	59	</field>
6a488035	60	<field>
8f069c03 EM	61	<name>entity_value</name>
8f069c03 EM	62	<type>varchar</type>
f5da40c8	63	<length>255</length>
8f069c03	64	<comment>Entity value</comment>
d5851cf2	65	<serialize>SEPARATOR_TRIMMED</serialize>
1662d426 A	66	<html>
	67	<label>Entity value</label>
	68	</html>
8f069c03	69	<add>3.4</add>
6a488035 TO	70	</field>
6a488035 TO	71	<field>
8f069c03 EM	72	<name>entity_status</name>
	73	<type>varchar</type>
	74	<length>64</length>
	75	<comment>Entity status</comment>
d5851cf2	76	<serialize>SEPARATOR_TRIMMED</serialize>
1662d426 A	77	<html>
	78	<label>Entity Status</label>
	79	</html>
8f069c03	80	<add>3.4</add>
6a488035 TO	81	</field>
6a488035 TO	82	<field>
8f069c03 EM	83	<name>start_action_offset</name>
	84	<type>int unsigned</type>
	85	<comment>Reminder Interval.</comment>
055c5fe6	86	<default>0</default>
1662d426 A	87	<html>
	88	<label>Start Action Offset</label>
	89	</html>
8f069c03 EM	90	<add>3.4</add>
8f069c03 EM	91	</field>
6a488035	92	<field>
8f069c03 EM	93	<name>start_action_unit</name>
	94	<type>varchar</type>
	95	<length>8</length>
	96	<comment>Time units for reminder.</comment>
	97	<pseudoconstant>
0b642d60	98	<callback>CRM_Core_SelectValues::getRecurringFrequencyUnits</callback>
8f069c03 EM	99	</pseudoconstant>
	100	<add>3.4</add>
	101	<html>
	102	<type>Select</type>
fd735f54	103	<label>Start Action Unit</label>
8f069c03	104	</html>
6a488035	105	</field>
8f069c03 EM	106	<field>
	107	<name>start_action_condition</name>
	108	<type>varchar</type>
c105ac4b	109	<length>64</length>
8f069c03	110	<comment>Reminder Action</comment>
1662d426 A	111	<html>
	112	<label>Start Action condition</label>
	113	</html>
8f069c03 EM	114	<add>3.4</add>
	115	</field>
	116	<field>
	117	<name>start_action_date</name>
	118	<type>varchar</type>
	119	<length>64</length>
	120	<comment>Entity date</comment>
1662d426 A	121	<html>
	122	<label>Start Action Date</label>
	123	</html>
8f069c03	124	<add>3.4</add>
6a488035 TO	125	</field>
6a488035 TO	126	<field>
8f069c03 EM	127	<name>is_repeat</name>
	128	<title>Repeat?</title>
	129	<type>boolean</type>
	130	<default>0</default>
c1e814c7	131	<required>true</required>
8f069c03	132	<add>3.4</add>
6a488035 TO	133	</field>
6a488035 TO	134	<field>
8f069c03 EM	135	<name>repetition_frequency_unit</name>
	136	<type>varchar</type>
	137	<length>8</length>
	138	<comment>Time units for repetition of reminder.</comment>
	139	<pseudoconstant>
4226026e	140	<callback>CRM_Core_SelectValues::getRecurringFrequencyUnits</callback>
8f069c03 EM	141	</pseudoconstant>
	142	<add>3.4</add>
	143	<html>
	144	<type>Select</type>
fd735f54	145	<label>Repetition Frequency Unit</label>
8f069c03 EM	146	</html>
8f069c03 EM	147	</field>
6a488035	148	<field>
8f069c03 EM	149	<name>repetition_frequency_interval</name>
8f069c03 EM	150	<type>int unsigned</type>
055c5fe6	151	<default>0</default>
8f069c03	152	<comment>Time interval for repeating the reminder.</comment>
1662d426 A	153	<html>
	154	<label>Repetition Frequency Interval</label>
	155	</html>
8f069c03	156	<add>3.4</add>
6a488035 TO	157	</field>
6a488035 TO	158	<field>
8f069c03 EM	159	<name>end_frequency_unit</name>
	160	<type>varchar</type>
	161	<length>8</length>
	162	<comment>Time units till repetition of reminder.</comment>
	163	<pseudoconstant>
0b642d60	164	<callback>CRM_Core_SelectValues::getRecurringFrequencyUnits</callback>
8f069c03 EM	165	</pseudoconstant>
	166	<add>3.4</add>
	167	<html>
	168	<type>Select</type>
fd735f54	169	<label>End Frequency Unit</label>
8f069c03	170	</html>
6a488035 TO	171	</field>
6a488035 TO	172	<field>
8f069c03 EM	173	<name>end_frequency_interval</name>
	174	<type>int unsigned</type>
	175	<comment>Time interval till repeating the reminder.</comment>
1662d426 A	176	<html>
	177	<label>End Frequency Interval</label>
	178	</html>
8f069c03	179	<add>3.4</add>
055c5fe6	180	<default>0</default>
6a488035 TO	181	</field>
6a488035 TO	182	<field>
8f069c03 EM	183	<name>end_action</name>
	184	<type>varchar</type>
	185	<length>32</length>
	186	<comment>Reminder Action till repeating the reminder.</comment>
1662d426 A	187	<html>
	188	<label>End Action</label>
	189	</html>
8f069c03	190	<add>3.4</add>
6a488035 TO	191	</field>
6a488035 TO	192	<field>
8f069c03 EM	193	<name>end_date</name>
	194	<type>varchar</type>
	195	<length>64</length>
	196	<comment>Entity end date</comment>
1662d426 A	197	<html>
	198	<label>End Date</label>
	199	</html>
8f069c03	200	<add>3.4</add>
6a488035 TO	201	</field>
6a488035 TO	202	<field>
8f069c03	203	<name>is_active</name>
0d94665e	204	<title>Schedule is Active?</title>
8f069c03 EM	205	<type>boolean</type>
8f069c03 EM	206	<default>1</default>
c1e814c7	207	<required>true</required>
8f069c03 EM	208	<comment>Is this option active?</comment>
8f069c03 EM	209	<add>3.4</add>
6a488035 TO	210	</field>
6a488035 TO	211	<field>
8f069c03 EM	212	<name>recipient_manual</name>
	213	<title>Recipient Manual</title>
	214	<type>varchar</type>
	215	<length>128</length>
	216	<comment>Contact IDs to which reminder should be sent.</comment>
d5851cf2	217	<serialize>COMMA</serialize>
8f069c03	218	<add>3.4</add>
6a488035	219	</field>
8f069c03 EM	220	<field>
	221	<name>recipient_listing</name>
	222	<title>Recipient Listing</title>
	223	<type>varchar</type>
	224	<length>128</length>
	225	<comment>listing based on recipient field.</comment>
	226	<add>4.1</add>
6a488035 TO	227	</field>
6a488035 TO	228	<field>
8f069c03	229	<name>body_text</name>
0d94665e	230	<title>Reminder Text</title>
8f069c03 EM	231	<type>longtext</type>
	232	<comment>Body of the mailing in text format.</comment>
	233	<add>3.4</add>
6a488035 TO	234	</field>
6a488035 TO	235	<field>
8f069c03	236	<name>body_html</name>
0d94665e	237	<title>Reminder HTML</title>
8f069c03 EM	238	<type>longtext</type>
	239	<comment>Body of the mailing in html format.</comment>
	240	<add>3.4</add>
6a488035	241	</field>
1e035d58	242	<field>
	243	<name>sms_body_text</name>
	244	<title>SMS Reminder Text</title>
	245	<type>longtext</type>
	246	<comment>Content of the SMS text.</comment>
	247	<add>4.5</add>
	248	</field>
8f069c03 EM	249	<field>
8f069c03 EM	250	<name>subject</name>
0d94665e	251	<title>Reminder Subject</title>
8f069c03 EM	252	<type>varchar</type>
	253	<length>128</length>
	254	<comment>Subject of mailing</comment>
	255	<add>3.4</add>
6a488035	256	</field>
8f069c03 EM	257	<field>
8f069c03 EM	258	<name>record_activity</name>
0d94665e	259	<title>Record Activity for Reminder?</title>
8f069c03	260	<type>boolean</type>
c1e814c7 MD	261	<default>0</default>
c1e814c7 MD	262	<required>true</required>
8f069c03 EM	263	<comment>Record Activity for this reminder?</comment>
8f069c03 EM	264	<add>3.4</add>
6a488035	265	</field>
8f069c03 EM	266	<field>
8f069c03 EM	267	<name>mapping_id</name>
0d94665e	268	<title>Reminder Mapping</title>
4d5ef3de TO	269	<type>varchar</type>
	270	<length>64</length>
	271	<comment>Name/ID of the mapping to use on this table</comment>
8f069c03	272	<add>3.4</add>
6a488035	273	</field>
6a488035	274	<field>
29494eef	275	<name>group_id</name>
047c5009	276	<title>Group ID</title>
29494eef AS	277	<type>int unsigned</type>
	278	<comment>FK to Group</comment>
	279	<pseudoconstant>
	280	<table>civicrm_group</table>
	281	<keyColumn>id</keyColumn>
	282	<labelColumn>title</labelColumn>
	283	</pseudoconstant>
614d72ec	284	<html>
e0991796	285	<type>Select</type>
047c5009	286	<label>Group</label>
614d72ec	287	</html>
29494eef AS	288	<add>3.4</add>
29494eef AS	289	</field>
8f069c03 EM	290	<foreignKey>
	291	<name>group_id</name>
	292	<table>civicrm_group</table>
	293	<key>id</key>
	294	<onDelete>SET NULL</onDelete>
	295	</foreignKey>
	296	<field>
	297	<name>msg_template_id</name>
047c5009	298	<title>Message Template ID</title>
011aeb62	299	<type>int unsigned</type>
011aeb62	300	<comment>FK to the message template.</comment>
57e94608	301	<html>
047c5009	302	<label>Message Template</label>
57e94608	303	</html>
8f069c03 EM	304	</field>
	305	<foreignKey>
	306	<name>msg_template_id</name>
011aeb62	307	<table>civicrm_msg_template</table>
	308	<key>id</key>
	309	<onDelete>SET NULL</onDelete>
8f069c03	310	</foreignKey>
1e035d58	311	<field>
1e035d58	312	<name>sms_template_id</name>
047c5009	313	<title>SMS Template ID</title>
1e035d58	314	<type>int unsigned</type>
1e035d58	315	<comment>FK to the message template.</comment>
57e94608	316	<html>
047c5009	317	<label>SMS Template</label>
57e94608	318	</html>
1e035d58	319	</field>
1e035d58	320	<foreignKey>
ce62f51a	321	<name>sms_template_id</name>
1e035d58	322	<table>civicrm_msg_template</table>
	323	<key>id</key>
	324	<onDelete>SET NULL</onDelete>
	325	</foreignKey>
8f069c03 EM	326	<field>
8f069c03 EM	327	<name>absolute_date</name>
0d94665e	328	<title>Fixed Date for Reminder</title>
8f069c03 EM	329	<type>date</type>
	330	<comment>Date on which the reminder be sent.</comment>
	331	<add>4.1</add>
6a488035	332	</field>
1991bba1 DG	333	<field>
1991bba1 DG	334	<name>from_name</name>
0d94665e	335	<title>Reminder from Name</title>
1991bba1 DG	336	<type>varchar</type>
	337	<length>255</length>
	338	<comment>Name in "from" field</comment>
	339	<add>4.5</add>
	340	</field>
	341	<field>
	342	<name>from_email</name>
0d94665e	343	<title>Reminder From Email</title>
1991bba1 DG	344	<type>varchar</type>
	345	<length>255</length>
	346	<comment>Email address in "from" field</comment>
	347	<add>4.5</add>
	348	</field>
a3e3eea1	349	<field>
	350	<name>mode</name>
	351	<title>Message Mode</title>
	352	<default>"Email"</default>
	353	<type>varchar</type>
	354	<length>128</length>
	355	<comment>Send the message as email or sms or both.</comment>
	356	<pseudoconstant>
	357	<optionGroupName>msg_mode</optionGroupName>
	358	</pseudoconstant>
	359	<html>
	360	<type>Select</type>
	361	</html>
	362	<add>4.5</add>
	363	</field>
	364	<field>
	365	<name>sms_provider_id</name>
57e94608	366	<title>SMS Provider ID</title>
a3e3eea1	367	<type>int unsigned</type>
	368	<add>4.5</add>
	369	<html>
	370	<type>Select</type>
57e94608	371	<label>SMS Provider</label>
a3e3eea1	372	</html>
	373	</field>
	374	<foreignKey>
	375	<name>sms_provider_id</name>
	376	<table>civicrm_sms_provider</table>
	377	<key>id</key>
	378	<onDelete>SET NULL</onDelete>
	379	<add>4.5</add>
	380	</foreignKey>
62933949	381	<field>
	382	<name>used_for</name>
	383	<type>varchar</type>
	384	<length>64</length>
881c2dfb	385	<comment>Used for repeating entity</comment>
1662d426 A	386	<html>
	387	<label>Used For</label>
	388	</html>
9d54f3a4	389	<add>4.6</add>
62933949	390	</field>
776a4216 SV	391	<field>
	392	<name>filter_contact_language</name>
	393	<type>varchar</type>
	394	<length>128</length>
	395	<comment>Used for multilingual installation</comment>
1662d426 A	396	<html>
	397	<label>Filter Contact Language</label>
	398	</html>
776a4216 SV	399	<add>4.7</add>
	400	</field>
	401	<field>
	402	<name>communication_language</name>
	403	<type>varchar</type>
	404	<length>8</length>
	405	<comment>Used for multilingual installation</comment>
1662d426 A	406	<html>
	407	<label>Communication Language</label>
	408	</html>
776a4216 SV	409	<add>4.7</add>
776a4216 SV	410	</field>
6a62a64e	411	<field>
	412	<name>created_date</name>
	413	<title>Created Date</title>
	414	<uniqueName>action_schedule_created_date</uniqueName>
	415	<type>timestamp</type>
	416	<comment>When was the scheduled reminder created.</comment>
	417	<required>false</required>
	418	<export>true</export>
	419	<default>CURRENT_TIMESTAMP</default>
	420	<add>5.34</add>
	421	</field>
	422	<field>
	423	<name>modified_date</name>
	424	<type>timestamp</type>
	425	<comment>When the reminder was created or modified.</comment>
	426	<required>false</required>
	427	<default>CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP</default>
1662d426 A	428	<html>
	429	<label>Modified Date</label>
	430	</html>
6a62a64e	431	<add>5.34</add>
a0e733f3	432	<readonly>true</readonly>
6a62a64e	433	</field>
	434	<field>
	435	<name>effective_start_date</name>
	436	<title>Effective start date</title>
	437	<uniqueName>action_schedule_effective_start_date</uniqueName>
	438	<type>timestamp</type>
	439	<comment>Earliest date to consider start events from.</comment>
	440	<required>false</required>
	441	<export>true</export>
	442	<add>5.34</add>
	443	</field>
	444	<field>
	445	<name>effective_end_date</name>
	446	<title>Effective end date</title>
	447	<uniqueName>action_schedule_effective_end_date</uniqueName>
	448	<type>timestamp</type>
	449	<comment>Latest date to consider end events from.</comment>
	450	<required>false</required>
	451	<export>true</export>
	452	<add>5.34</add>
	453	</field>
6a488035	454	</table>