[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>
    <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>
    <add>3.4</add>
  </field>
  <field>
    <name>limit_to</name>
    <type>boolean</type>
    <default>1</default>
    <comment>Is this the recipient criteria limited to OR in addition to?</comment>
    <add>4.4</add>
  </field>
  <field>
    <name>entity_value</name>
    <type>varchar</type>
    <length>64</length>
    <comment>Entity value</comment>
    <add>3.4</add>
  </field>
  <field>
    <name>entity_status</name>
    <type>varchar</type>
    <length>64</length>
    <comment>Entity status</comment>
    <add>3.4</add>
  </field>
  <field>
    <name>start_action_offset</name>
    <type>int unsigned</type>
    <comment>Reminder Interval.</comment>
    <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::getScheduleReminderFrequencyUnits</callback>
    </pseudoconstant>
    <add>3.4</add>
    <html>
      <type>Select</type>
    </html>
  </field>
  <field>
    <name>start_action_condition</name>
    <type>varchar</type>
    <length>32</length>
    <comment>Reminder Action</comment>
    <add>3.4</add>
  </field>
  <field>
    <name>start_action_date</name>
    <type>varchar</type>
    <length>64</length>
    <comment>Entity date</comment>
    <add>3.4</add>
  </field>
  <field>
    <name>is_repeat</name>
    <title>Repeat?</title>
    <type>boolean</type>
    <default>0</default>
    <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::getScheduleReminderFrequencyUnits</callback>
    </pseudoconstant>
    <add>3.4</add>
    <html>
      <type>Select</type>
    </html>
  </field>
  <field>
    <name>repetition_frequency_interval</name>
    <type>int unsigned</type>
    <comment>Time interval for repeating the reminder.</comment>
    <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::getScheduleReminderFrequencyUnits</callback>
    </pseudoconstant>
    <add>3.4</add>
    <html>
      <type>Select</type>
    </html>
  </field>
  <field>
    <name>end_frequency_interval</name>
    <type>int unsigned</type>
    <comment>Time interval till repeating the reminder.</comment>
    <add>3.4</add>
  </field>
  <field>
    <name>end_action</name>
    <type>varchar</type>
    <length>32</length>
    <comment>Reminder Action till repeating the reminder.</comment>
    <add>3.4</add>
  </field>
  <field>
    <name>end_date</name>
    <type>varchar</type>
    <length>64</length>
    <comment>Entity end date</comment>
    <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>
    <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>
    <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>NULL</default>
    <comment>Record Activity for this reminder?</comment>
    <add>3.4</add>
  </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>
  </field>
  <foreignKey>
    <name>mapping_id</name>
    <table>civicrm_action_mapping</table>
    <key>id</key>
    <onDelete>SET NULL</onDelete>
  </foreignKey>
  <field>
    <name>group_id</name>
    <title>Reminder Group</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>
    </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>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>
    <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>
    <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</title>
    <type>int unsigned</type>
    <add>4.5</add>
    <html>
      <type>Select</type>
    </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>Maintained for recurring entity</comment>
    <add>4.4</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>
	13	<required>true</required>
	14	<add>3.4</add>
6a488035 TO	15	</field>
6a488035 TO	16	<primaryKey>
8f069c03 EM	17	<name>id</name>
8f069c03 EM	18	<autoincrement>true</autoincrement>
6a488035 TO	19	</primaryKey>
6a488035 TO	20	<field>
8f069c03 EM	21	<name>name</name>
	22	<title>Name</title>
	23	<type>varchar</type>
	24	<length>64</length>
	25	<comment>Name of the action(reminder)</comment>
	26	<add>3.4</add>
6a488035 TO	27	</field>
6a488035 TO	28	<field>
8f069c03 EM	29	<name>title</name>
	30	<title>Title</title>
	31	<type>varchar</type>
	32	<length>64</length>
	33	<comment>Title of the action(reminder)</comment>
	34	<add>3.4</add>
	35	</field>
6a488035	36	<field>
8f069c03 EM	37	<name>recipient</name>
	38	<type>varchar</type>
	39	<length>64</length>
	40	<comment>Recipient</comment>
	41	<add>3.4</add>
6a488035	42	</field>
3e315abc	43	<field>
8f069c03 EM	44	<name>limit_to</name>
	45	<type>boolean</type>
	46	<default>1</default>
	47	<comment>Is this the recipient criteria limited to OR in addition to?</comment>
	48	<add>4.4</add>
3e315abc	49	</field>
6a488035	50	<field>
8f069c03 EM	51	<name>entity_value</name>
	52	<type>varchar</type>
	53	<length>64</length>
	54	<comment>Entity value</comment>
	55	<add>3.4</add>
6a488035 TO	56	</field>
6a488035 TO	57	<field>
8f069c03 EM	58	<name>entity_status</name>
	59	<type>varchar</type>
	60	<length>64</length>
	61	<comment>Entity status</comment>
	62	<add>3.4</add>
6a488035 TO	63	</field>
6a488035 TO	64	<field>
8f069c03 EM	65	<name>start_action_offset</name>
	66	<type>int unsigned</type>
	67	<comment>Reminder Interval.</comment>
	68	<add>3.4</add>
	69	</field>
6a488035	70	<field>
8f069c03 EM	71	<name>start_action_unit</name>
	72	<type>varchar</type>
	73	<length>8</length>
	74	<comment>Time units for reminder.</comment>
	75	<pseudoconstant>
	76	<callback>CRM_Core_SelectValues::getScheduleReminderFrequencyUnits</callback>
	77	</pseudoconstant>
	78	<add>3.4</add>
	79	<html>
	80	<type>Select</type>
	81	</html>
6a488035	82	</field>
8f069c03 EM	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>
6a488035 TO	96	</field>
6a488035 TO	97	<field>
8f069c03 EM	98	<name>is_repeat</name>
	99	<title>Repeat?</title>
	100	<type>boolean</type>
	101	<default>0</default>
	102	<add>3.4</add>
6a488035 TO	103	</field>
6a488035 TO	104	<field>
8f069c03 EM	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	<callback>CRM_Core_SelectValues::getScheduleReminderFrequencyUnits</callback>
	111	</pseudoconstant>
	112	<add>3.4</add>
	113	<html>
	114	<type>Select</type>
	115	</html>
	116	</field>
6a488035	117	<field>
8f069c03 EM	118	<name>repetition_frequency_interval</name>
	119	<type>int unsigned</type>
	120	<comment>Time interval for repeating the reminder.</comment>
	121	<add>3.4</add>
6a488035 TO	122	</field>
6a488035 TO	123	<field>
8f069c03 EM	124	<name>end_frequency_unit</name>
	125	<type>varchar</type>
	126	<length>8</length>
	127	<comment>Time units till repetition of reminder.</comment>
	128	<pseudoconstant>
	129	<callback>CRM_Core_SelectValues::getScheduleReminderFrequencyUnits</callback>
	130	</pseudoconstant>
	131	<add>3.4</add>
	132	<html>
	133	<type>Select</type>
	134	</html>
6a488035 TO	135	</field>
6a488035 TO	136	<field>
8f069c03 EM	137	<name>end_frequency_interval</name>
	138	<type>int unsigned</type>
	139	<comment>Time interval till repeating the reminder.</comment>
	140	<add>3.4</add>
6a488035 TO	141	</field>
6a488035 TO	142	<field>
8f069c03 EM	143	<name>end_action</name>
	144	<type>varchar</type>
	145	<length>32</length>
	146	<comment>Reminder Action till repeating the reminder.</comment>
	147	<add>3.4</add>
6a488035 TO	148	</field>
6a488035 TO	149	<field>
8f069c03 EM	150	<name>end_date</name>
	151	<type>varchar</type>
	152	<length>64</length>
	153	<comment>Entity end date</comment>
	154	<add>3.4</add>
6a488035 TO	155	</field>
6a488035 TO	156	<field>
8f069c03	157	<name>is_active</name>
0d94665e	158	<title>Schedule is Active?</title>
8f069c03 EM	159	<type>boolean</type>
	160	<default>1</default>
	161	<comment>Is this option active?</comment>
	162	<add>3.4</add>
6a488035 TO	163	</field>
6a488035 TO	164	<field>
8f069c03 EM	165	<name>recipient_manual</name>
	166	<title>Recipient Manual</title>
	167	<type>varchar</type>
	168	<length>128</length>
	169	<comment>Contact IDs to which reminder should be sent.</comment>
	170	<add>3.4</add>
6a488035	171	</field>
8f069c03 EM	172	<field>
	173	<name>recipient_listing</name>
	174	<title>Recipient Listing</title>
	175	<type>varchar</type>
	176	<length>128</length>
	177	<comment>listing based on recipient field.</comment>
	178	<add>4.1</add>
6a488035 TO	179	</field>
6a488035 TO	180	<field>
8f069c03	181	<name>body_text</name>
0d94665e	182	<title>Reminder Text</title>
8f069c03 EM	183	<type>longtext</type>
	184	<comment>Body of the mailing in text format.</comment>
	185	<add>3.4</add>
6a488035 TO	186	</field>
6a488035 TO	187	<field>
8f069c03	188	<name>body_html</name>
0d94665e	189	<title>Reminder HTML</title>
8f069c03 EM	190	<type>longtext</type>
	191	<comment>Body of the mailing in html format.</comment>
	192	<add>3.4</add>
6a488035	193	</field>
1e035d58	194	<field>
	195	<name>sms_body_text</name>
	196	<title>SMS Reminder Text</title>
	197	<type>longtext</type>
	198	<comment>Content of the SMS text.</comment>
	199	<add>4.5</add>
	200	</field>
8f069c03 EM	201	<field>
8f069c03 EM	202	<name>subject</name>
0d94665e	203	<title>Reminder Subject</title>
8f069c03 EM	204	<type>varchar</type>
	205	<length>128</length>
	206	<comment>Subject of mailing</comment>
	207	<add>3.4</add>
6a488035	208	</field>
8f069c03 EM	209	<field>
8f069c03 EM	210	<name>record_activity</name>
0d94665e	211	<title>Record Activity for Reminder?</title>
8f069c03 EM	212	<type>boolean</type>
	213	<default>NULL</default>
	214	<comment>Record Activity for this reminder?</comment>
	215	<add>3.4</add>
6a488035	216	</field>
8f069c03 EM	217	<field>
8f069c03 EM	218	<name>mapping_id</name>
0d94665e	219	<title>Reminder Mapping</title>
8f069c03 EM	220	<type>int unsigned</type>
	221	<comment>FK to mapping which is being used by this reminder</comment>
	222	<add>3.4</add>
6a488035 TO	223	</field>
6a488035 TO	224	<foreignKey>
8f069c03 EM	225	<name>mapping_id</name>
	226	<table>civicrm_action_mapping</table>
	227	<key>id</key>
	228	<onDelete>SET NULL</onDelete>
3c7d2158	229	</foreignKey>
6a488035	230	<field>
29494eef	231	<name>group_id</name>
0d94665e	232	<title>Reminder Group</title>
29494eef AS	233	<type>int unsigned</type>
	234	<comment>FK to Group</comment>
	235	<pseudoconstant>
	236	<table>civicrm_group</table>
	237	<keyColumn>id</keyColumn>
	238	<labelColumn>title</labelColumn>
	239	</pseudoconstant>
614d72ec	240	<html>
e0991796	241	<type>Select</type>
614d72ec	242	</html>
29494eef AS	243	<add>3.4</add>
29494eef AS	244	</field>
8f069c03 EM	245	<foreignKey>
	246	<name>group_id</name>
	247	<table>civicrm_group</table>
	248	<key>id</key>
	249	<onDelete>SET NULL</onDelete>
	250	</foreignKey>
	251	<field>
	252	<name>msg_template_id</name>
0d94665e	253	<title>Reminder Template</title>
011aeb62	254	<type>int unsigned</type>
011aeb62	255	<comment>FK to the message template.</comment>
8f069c03 EM	256	</field>
	257	<foreignKey>
	258	<name>msg_template_id</name>
011aeb62	259	<table>civicrm_msg_template</table>
	260	<key>id</key>
	261	<onDelete>SET NULL</onDelete>
8f069c03	262	</foreignKey>
1e035d58	263	<field>
	264	<name>sms_template_id</name>
	265	<title>SMS Reminder Template</title>
	266	<type>int unsigned</type>
	267	<comment>FK to the message template.</comment>
	268	</field>
	269	<foreignKey>
	270	<name>msg_template_id</name>
	271	<table>civicrm_msg_template</table>
	272	<key>id</key>
	273	<onDelete>SET NULL</onDelete>
	274	</foreignKey>
8f069c03 EM	275	<field>
8f069c03 EM	276	<name>absolute_date</name>
0d94665e	277	<title>Fixed Date for Reminder</title>
8f069c03 EM	278	<type>date</type>
	279	<comment>Date on which the reminder be sent.</comment>
	280	<add>4.1</add>
6a488035	281	</field>
1991bba1 DG	282	<field>
1991bba1 DG	283	<name>from_name</name>
0d94665e	284	<title>Reminder from Name</title>
1991bba1 DG	285	<type>varchar</type>
	286	<length>255</length>
	287	<comment>Name in "from" field</comment>
	288	<add>4.5</add>
	289	</field>
	290	<field>
	291	<name>from_email</name>
0d94665e	292	<title>Reminder From Email</title>
1991bba1 DG	293	<type>varchar</type>
	294	<length>255</length>
	295	<comment>Email address in "from" field</comment>
	296	<add>4.5</add>
	297	</field>
a3e3eea1	298	<field>
	299	<name>mode</name>
	300	<title>Message Mode</title>
	301	<default>"Email"</default>
	302	<type>varchar</type>
	303	<length>128</length>
	304	<comment>Send the message as email or sms or both.</comment>
	305	<pseudoconstant>
	306	<optionGroupName>msg_mode</optionGroupName>
	307	</pseudoconstant>
	308	<html>
	309	<type>Select</type>
	310	</html>
	311	<add>4.5</add>
	312	</field>
	313	<field>
	314	<name>sms_provider_id</name>
0d94665e	315	<title>SMS Provider</title>
a3e3eea1	316	<type>int unsigned</type>
	317	<add>4.5</add>
	318	<html>
	319	<type>Select</type>
	320	</html>
	321	</field>
	322	<foreignKey>
	323	<name>sms_provider_id</name>
	324	<table>civicrm_sms_provider</table>
	325	<key>id</key>
	326	<onDelete>SET NULL</onDelete>
	327	<add>4.5</add>
	328	</foreignKey>
62933949	329	<field>
	330	<name>used_for</name>
	331	<type>varchar</type>
	332	<length>64</length>
	333	<comment>Maintained for recurring entity</comment>
	334	<add>4.4</add>
	335	</field>
6a488035	336	</table>