[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>
    <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::getRecurringFrequencyUnits</callback>
    </pseudoconstant>
    <add>3.4</add>
    <html>
      <type>Select</type>
    </html>
  </field>
  <field>
    <name>start_action_condition</name>
    <type>varchar</type>
    <length>62</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>
    <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>
  </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>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 EM	53	<comment>Entity value</comment>
8f069c03 EM	54	<add>3.4</add>
6a488035 TO	55	</field>
6a488035 TO	56	<field>
8f069c03 EM	57	<name>entity_status</name>
	58	<type>varchar</type>
	59	<length>64</length>
	60	<comment>Entity status</comment>
	61	<add>3.4</add>
6a488035 TO	62	</field>
6a488035 TO	63	<field>
8f069c03 EM	64	<name>start_action_offset</name>
	65	<type>int unsigned</type>
	66	<comment>Reminder Interval.</comment>
	67	<add>3.4</add>
	68	</field>
6a488035	69	<field>
8f069c03 EM	70	<name>start_action_unit</name>
	71	<type>varchar</type>
	72	<length>8</length>
	73	<comment>Time units for reminder.</comment>
	74	<pseudoconstant>
0b642d60	75	<callback>CRM_Core_SelectValues::getRecurringFrequencyUnits</callback>
8f069c03 EM	76	</pseudoconstant>
	77	<add>3.4</add>
	78	<html>
	79	<type>Select</type>
	80	</html>
6a488035	81	</field>
8f069c03 EM	82	<field>
	83	<name>start_action_condition</name>
	84	<type>varchar</type>
59d3a29c	85	<length>62</length>
8f069c03 EM	86	<comment>Reminder Action</comment>
	87	<add>3.4</add>
	88	</field>
	89	<field>
	90	<name>start_action_date</name>
	91	<type>varchar</type>
	92	<length>64</length>
	93	<comment>Entity date</comment>
	94	<add>3.4</add>
6a488035 TO	95	</field>
6a488035 TO	96	<field>
8f069c03 EM	97	<name>is_repeat</name>
	98	<title>Repeat?</title>
	99	<type>boolean</type>
	100	<default>0</default>
	101	<add>3.4</add>
6a488035 TO	102	</field>
6a488035 TO	103	<field>
8f069c03 EM	104	<name>repetition_frequency_unit</name>
	105	<type>varchar</type>
	106	<length>8</length>
	107	<comment>Time units for repetition of reminder.</comment>
	108	<pseudoconstant>
4226026e	109	<callback>CRM_Core_SelectValues::getRecurringFrequencyUnits</callback>
8f069c03 EM	110	</pseudoconstant>
	111	<add>3.4</add>
	112	<html>
	113	<type>Select</type>
	114	</html>
	115	</field>
6a488035	116	<field>
8f069c03 EM	117	<name>repetition_frequency_interval</name>
	118	<type>int unsigned</type>
	119	<comment>Time interval for repeating the reminder.</comment>
	120	<add>3.4</add>
6a488035 TO	121	</field>
6a488035 TO	122	<field>
8f069c03 EM	123	<name>end_frequency_unit</name>
	124	<type>varchar</type>
	125	<length>8</length>
	126	<comment>Time units till repetition of reminder.</comment>
	127	<pseudoconstant>
0b642d60	128	<callback>CRM_Core_SelectValues::getRecurringFrequencyUnits</callback>
8f069c03 EM	129	</pseudoconstant>
	130	<add>3.4</add>
	131	<html>
	132	<type>Select</type>
	133	</html>
6a488035 TO	134	</field>
6a488035 TO	135	<field>
8f069c03 EM	136	<name>end_frequency_interval</name>
	137	<type>int unsigned</type>
	138	<comment>Time interval till repeating the reminder.</comment>
	139	<add>3.4</add>
6a488035 TO	140	</field>
6a488035 TO	141	<field>
8f069c03 EM	142	<name>end_action</name>
	143	<type>varchar</type>
	144	<length>32</length>
	145	<comment>Reminder Action till repeating the reminder.</comment>
	146	<add>3.4</add>
6a488035 TO	147	</field>
6a488035 TO	148	<field>
8f069c03 EM	149	<name>end_date</name>
	150	<type>varchar</type>
	151	<length>64</length>
	152	<comment>Entity end date</comment>
	153	<add>3.4</add>
6a488035 TO	154	</field>
6a488035 TO	155	<field>
8f069c03	156	<name>is_active</name>
0d94665e	157	<title>Schedule is Active?</title>
8f069c03 EM	158	<type>boolean</type>
	159	<default>1</default>
	160	<comment>Is this option active?</comment>
	161	<add>3.4</add>
6a488035 TO	162	</field>
6a488035 TO	163	<field>
8f069c03 EM	164	<name>recipient_manual</name>
	165	<title>Recipient Manual</title>
	166	<type>varchar</type>
	167	<length>128</length>
	168	<comment>Contact IDs to which reminder should be sent.</comment>
	169	<add>3.4</add>
6a488035	170	</field>
8f069c03 EM	171	<field>
	172	<name>recipient_listing</name>
	173	<title>Recipient Listing</title>
	174	<type>varchar</type>
	175	<length>128</length>
	176	<comment>listing based on recipient field.</comment>
	177	<add>4.1</add>
6a488035 TO	178	</field>
6a488035 TO	179	<field>
8f069c03	180	<name>body_text</name>
0d94665e	181	<title>Reminder Text</title>
8f069c03 EM	182	<type>longtext</type>
	183	<comment>Body of the mailing in text format.</comment>
	184	<add>3.4</add>
6a488035 TO	185	</field>
6a488035 TO	186	<field>
8f069c03	187	<name>body_html</name>
0d94665e	188	<title>Reminder HTML</title>
8f069c03 EM	189	<type>longtext</type>
	190	<comment>Body of the mailing in html format.</comment>
	191	<add>3.4</add>
6a488035	192	</field>
1e035d58	193	<field>
	194	<name>sms_body_text</name>
	195	<title>SMS Reminder Text</title>
	196	<type>longtext</type>
	197	<comment>Content of the SMS text.</comment>
	198	<add>4.5</add>
	199	</field>
8f069c03 EM	200	<field>
8f069c03 EM	201	<name>subject</name>
0d94665e	202	<title>Reminder Subject</title>
8f069c03 EM	203	<type>varchar</type>
	204	<length>128</length>
	205	<comment>Subject of mailing</comment>
	206	<add>3.4</add>
6a488035	207	</field>
8f069c03 EM	208	<field>
8f069c03 EM	209	<name>record_activity</name>
0d94665e	210	<title>Record Activity for Reminder?</title>
8f069c03 EM	211	<type>boolean</type>
	212	<default>NULL</default>
	213	<comment>Record Activity for this reminder?</comment>
	214	<add>3.4</add>
6a488035	215	</field>
8f069c03 EM	216	<field>
8f069c03 EM	217	<name>mapping_id</name>
0d94665e	218	<title>Reminder Mapping</title>
4d5ef3de TO	219	<type>varchar</type>
	220	<length>64</length>
	221	<comment>Name/ID of the mapping to use on this table</comment>
8f069c03	222	<add>3.4</add>
6a488035	223	</field>
6a488035	224	<field>
29494eef	225	<name>group_id</name>
0d94665e	226	<title>Reminder Group</title>
29494eef AS	227	<type>int unsigned</type>
	228	<comment>FK to Group</comment>
	229	<pseudoconstant>
	230	<table>civicrm_group</table>
	231	<keyColumn>id</keyColumn>
	232	<labelColumn>title</labelColumn>
	233	</pseudoconstant>
614d72ec	234	<html>
e0991796	235	<type>Select</type>
614d72ec	236	</html>
29494eef AS	237	<add>3.4</add>
29494eef AS	238	</field>
8f069c03 EM	239	<foreignKey>
	240	<name>group_id</name>
	241	<table>civicrm_group</table>
	242	<key>id</key>
	243	<onDelete>SET NULL</onDelete>
	244	</foreignKey>
	245	<field>
	246	<name>msg_template_id</name>
0d94665e	247	<title>Reminder Template</title>
011aeb62	248	<type>int unsigned</type>
011aeb62	249	<comment>FK to the message template.</comment>
8f069c03 EM	250	</field>
	251	<foreignKey>
	252	<name>msg_template_id</name>
011aeb62	253	<table>civicrm_msg_template</table>
	254	<key>id</key>
	255	<onDelete>SET NULL</onDelete>
8f069c03	256	</foreignKey>
1e035d58	257	<field>
	258	<name>sms_template_id</name>
	259	<title>SMS Reminder Template</title>
	260	<type>int unsigned</type>
	261	<comment>FK to the message template.</comment>
	262	</field>
	263	<foreignKey>
ce62f51a	264	<name>sms_template_id</name>
1e035d58	265	<table>civicrm_msg_template</table>
	266	<key>id</key>
	267	<onDelete>SET NULL</onDelete>
	268	</foreignKey>
8f069c03 EM	269	<field>
8f069c03 EM	270	<name>absolute_date</name>
0d94665e	271	<title>Fixed Date for Reminder</title>
8f069c03 EM	272	<type>date</type>
	273	<comment>Date on which the reminder be sent.</comment>
	274	<add>4.1</add>
6a488035	275	</field>
1991bba1 DG	276	<field>
1991bba1 DG	277	<name>from_name</name>
0d94665e	278	<title>Reminder from Name</title>
1991bba1 DG	279	<type>varchar</type>
	280	<length>255</length>
	281	<comment>Name in "from" field</comment>
	282	<add>4.5</add>
	283	</field>
	284	<field>
	285	<name>from_email</name>
0d94665e	286	<title>Reminder From Email</title>
1991bba1 DG	287	<type>varchar</type>
	288	<length>255</length>
	289	<comment>Email address in "from" field</comment>
	290	<add>4.5</add>
	291	</field>
a3e3eea1	292	<field>
	293	<name>mode</name>
	294	<title>Message Mode</title>
	295	<default>"Email"</default>
	296	<type>varchar</type>
	297	<length>128</length>
	298	<comment>Send the message as email or sms or both.</comment>
	299	<pseudoconstant>
	300	<optionGroupName>msg_mode</optionGroupName>
	301	</pseudoconstant>
	302	<html>
	303	<type>Select</type>
	304	</html>
	305	<add>4.5</add>
	306	</field>
	307	<field>
	308	<name>sms_provider_id</name>
0d94665e	309	<title>SMS Provider</title>
a3e3eea1	310	<type>int unsigned</type>
	311	<add>4.5</add>
	312	<html>
	313	<type>Select</type>
	314	</html>
	315	</field>
	316	<foreignKey>
	317	<name>sms_provider_id</name>
	318	<table>civicrm_sms_provider</table>
	319	<key>id</key>
	320	<onDelete>SET NULL</onDelete>
	321	<add>4.5</add>
	322	</foreignKey>
62933949	323	<field>
	324	<name>used_for</name>
	325	<type>varchar</type>
	326	<length>64</length>
881c2dfb	327	<comment>Used for repeating entity</comment>
9d54f3a4	328	<add>4.6</add>
62933949	329	</field>
776a4216 SV	330	<field>
	331	<name>filter_contact_language</name>
	332	<type>varchar</type>
	333	<length>128</length>
	334	<comment>Used for multilingual installation</comment>
	335	<add>4.7</add>
	336	</field>
	337	<field>
	338	<name>communication_language</name>
	339	<type>varchar</type>
	340	<length>8</length>
	341	<comment>Used for multilingual installation</comment>
	342	<add>4.7</add>
	343	</field>
6a488035	344	</table>