[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>
    <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>255</length>
    <comment>Entity value</comment>
    <serialize>SEPARATOR_TRIMMED</serialize>
    <add>3.4</add>
  </field>
  <field>
    <name>entity_status</name>
    <type>varchar</type>
    <length>64</length>
    <comment>Entity status</comment>
    <serialize>SEPARATOR_TRIMMED</serialize>
    <add>3.4</add>
  </field>
  <field>
    <name>start_action_offset</name>
    <type>int unsigned</type>
    <comment>Reminder Interval.</comment>
    <default>0</default>
    <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>
    </html>
  </field>
  <field>
    <name>start_action_condition</name>
    <type>varchar</type>
    <length>64</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::getRecurringFrequencyUnits</callback>
    </pseudoconstant>
    <add>3.4</add>
    <html>
      <type>Select</type>
    </html>
  </field>
  <field>
    <name>repetition_frequency_interval</name>
    <type>int unsigned</type>
    <default>0</default>
    <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::getRecurringFrequencyUnits</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>
    <default>0</default>
  </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>
    <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>NULL</default>
    <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>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>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</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>Used for repeating entity</comment>
    <add>4.6</add>
  </field>
  <field>
    <name>filter_contact_language</name>
    <type>varchar</type>
    <length>128</length>
    <comment>Used for multilingual installation</comment>
    <add>4.7</add>
  </field>
  <field>
    <name>communication_language</name>
    <type>varchar</type>
    <length>8</length>
    <comment>Used for multilingual installation</comment>
    <add>4.7</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>
8f069c03 EM	45	<type>boolean</type>
8f069c03 EM	46	<comment>Is this the recipient criteria limited to OR in addition to?</comment>
8f069c03 EM	47	<add>4.4</add>
3e315abc	48	</field>
6a488035	49	<field>
8f069c03 EM	50	<name>entity_value</name>
8f069c03 EM	51	<type>varchar</type>
f5da40c8	52	<length>255</length>
8f069c03	53	<comment>Entity value</comment>
d5851cf2	54	<serialize>SEPARATOR_TRIMMED</serialize>
8f069c03	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>
d5851cf2	62	<serialize>SEPARATOR_TRIMMED</serialize>
8f069c03	63	<add>3.4</add>
6a488035 TO	64	</field>
6a488035 TO	65	<field>
8f069c03 EM	66	<name>start_action_offset</name>
	67	<type>int unsigned</type>
	68	<comment>Reminder Interval.</comment>
055c5fe6	69	<default>0</default>
8f069c03 EM	70	<add>3.4</add>
8f069c03 EM	71	</field>
6a488035	72	<field>
8f069c03 EM	73	<name>start_action_unit</name>
	74	<type>varchar</type>
	75	<length>8</length>
	76	<comment>Time units for reminder.</comment>
	77	<pseudoconstant>
0b642d60	78	<callback>CRM_Core_SelectValues::getRecurringFrequencyUnits</callback>
8f069c03 EM	79	</pseudoconstant>
	80	<add>3.4</add>
	81	<html>
	82	<type>Select</type>
	83	</html>
6a488035	84	</field>
8f069c03 EM	85	<field>
	86	<name>start_action_condition</name>
	87	<type>varchar</type>
c105ac4b	88	<length>64</length>
8f069c03 EM	89	<comment>Reminder Action</comment>
	90	<add>3.4</add>
	91	</field>
	92	<field>
	93	<name>start_action_date</name>
	94	<type>varchar</type>
	95	<length>64</length>
	96	<comment>Entity date</comment>
	97	<add>3.4</add>
6a488035 TO	98	</field>
6a488035 TO	99	<field>
8f069c03 EM	100	<name>is_repeat</name>
	101	<title>Repeat?</title>
	102	<type>boolean</type>
	103	<default>0</default>
	104	<add>3.4</add>
6a488035 TO	105	</field>
6a488035 TO	106	<field>
8f069c03 EM	107	<name>repetition_frequency_unit</name>
	108	<type>varchar</type>
	109	<length>8</length>
	110	<comment>Time units for repetition of reminder.</comment>
	111	<pseudoconstant>
4226026e	112	<callback>CRM_Core_SelectValues::getRecurringFrequencyUnits</callback>
8f069c03 EM	113	</pseudoconstant>
	114	<add>3.4</add>
	115	<html>
	116	<type>Select</type>
	117	</html>
	118	</field>
6a488035	119	<field>
8f069c03 EM	120	<name>repetition_frequency_interval</name>
8f069c03 EM	121	<type>int unsigned</type>
055c5fe6	122	<default>0</default>
8f069c03 EM	123	<comment>Time interval for repeating the reminder.</comment>
8f069c03 EM	124	<add>3.4</add>
6a488035 TO	125	</field>
6a488035 TO	126	<field>
8f069c03 EM	127	<name>end_frequency_unit</name>
	128	<type>varchar</type>
	129	<length>8</length>
	130	<comment>Time units till repetition of reminder.</comment>
	131	<pseudoconstant>
0b642d60	132	<callback>CRM_Core_SelectValues::getRecurringFrequencyUnits</callback>
8f069c03 EM	133	</pseudoconstant>
	134	<add>3.4</add>
	135	<html>
	136	<type>Select</type>
	137	</html>
6a488035 TO	138	</field>
6a488035 TO	139	<field>
8f069c03 EM	140	<name>end_frequency_interval</name>
	141	<type>int unsigned</type>
	142	<comment>Time interval till repeating the reminder.</comment>
	143	<add>3.4</add>
055c5fe6	144	<default>0</default>
6a488035 TO	145	</field>
6a488035 TO	146	<field>
8f069c03 EM	147	<name>end_action</name>
	148	<type>varchar</type>
	149	<length>32</length>
	150	<comment>Reminder Action till repeating the reminder.</comment>
	151	<add>3.4</add>
6a488035 TO	152	</field>
6a488035 TO	153	<field>
8f069c03 EM	154	<name>end_date</name>
	155	<type>varchar</type>
	156	<length>64</length>
	157	<comment>Entity end date</comment>
	158	<add>3.4</add>
6a488035 TO	159	</field>
6a488035 TO	160	<field>
8f069c03	161	<name>is_active</name>
0d94665e	162	<title>Schedule is Active?</title>
8f069c03 EM	163	<type>boolean</type>
	164	<default>1</default>
	165	<comment>Is this option active?</comment>
	166	<add>3.4</add>
6a488035 TO	167	</field>
6a488035 TO	168	<field>
8f069c03 EM	169	<name>recipient_manual</name>
	170	<title>Recipient Manual</title>
	171	<type>varchar</type>
	172	<length>128</length>
	173	<comment>Contact IDs to which reminder should be sent.</comment>
d5851cf2	174	<serialize>COMMA</serialize>
8f069c03	175	<add>3.4</add>
6a488035	176	</field>
8f069c03 EM	177	<field>
	178	<name>recipient_listing</name>
	179	<title>Recipient Listing</title>
	180	<type>varchar</type>
	181	<length>128</length>
	182	<comment>listing based on recipient field.</comment>
	183	<add>4.1</add>
6a488035 TO	184	</field>
6a488035 TO	185	<field>
8f069c03	186	<name>body_text</name>
0d94665e	187	<title>Reminder Text</title>
8f069c03 EM	188	<type>longtext</type>
	189	<comment>Body of the mailing in text format.</comment>
	190	<add>3.4</add>
6a488035 TO	191	</field>
6a488035 TO	192	<field>
8f069c03	193	<name>body_html</name>
0d94665e	194	<title>Reminder HTML</title>
8f069c03 EM	195	<type>longtext</type>
	196	<comment>Body of the mailing in html format.</comment>
	197	<add>3.4</add>
6a488035	198	</field>
1e035d58	199	<field>
	200	<name>sms_body_text</name>
	201	<title>SMS Reminder Text</title>
	202	<type>longtext</type>
	203	<comment>Content of the SMS text.</comment>
	204	<add>4.5</add>
	205	</field>
8f069c03 EM	206	<field>
8f069c03 EM	207	<name>subject</name>
0d94665e	208	<title>Reminder Subject</title>
8f069c03 EM	209	<type>varchar</type>
	210	<length>128</length>
	211	<comment>Subject of mailing</comment>
	212	<add>3.4</add>
6a488035	213	</field>
8f069c03 EM	214	<field>
8f069c03 EM	215	<name>record_activity</name>
0d94665e	216	<title>Record Activity for Reminder?</title>
8f069c03 EM	217	<type>boolean</type>
	218	<default>NULL</default>
	219	<comment>Record Activity for this reminder?</comment>
	220	<add>3.4</add>
6a488035	221	</field>
8f069c03 EM	222	<field>
8f069c03 EM	223	<name>mapping_id</name>
0d94665e	224	<title>Reminder Mapping</title>
4d5ef3de TO	225	<type>varchar</type>
	226	<length>64</length>
	227	<comment>Name/ID of the mapping to use on this table</comment>
8f069c03	228	<add>3.4</add>
6a488035	229	</field>
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>
ce62f51a	270	<name>sms_template_id</name>
1e035d58	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>
881c2dfb	333	<comment>Used for repeating entity</comment>
9d54f3a4	334	<add>4.6</add>
62933949	335	</field>
776a4216 SV	336	<field>
	337	<name>filter_contact_language</name>
	338	<type>varchar</type>
	339	<length>128</length>
	340	<comment>Used for multilingual installation</comment>
	341	<add>4.7</add>
	342	</field>
	343	<field>
	344	<name>communication_language</name>
	345	<type>varchar</type>
	346	<length>8</length>
	347	<comment>Used for multilingual installation</comment>
	348	<add>4.7</add>
	349	</field>
6a488035	350	</table>