[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>
      <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>
       <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>
       <type>longtext</type>
       <comment>Body of the mailing in text format.</comment>
       <add>3.4</add>
  </field>
  <field>
       <name>body_html</name>
       <type>longtext</type>
       <comment>Body of the mailing in html format.</comment>
       <add>3.4</add>
  </field>
  <field>
       <name>subject</name>
       <type>varchar</type>
       <length>128</length>
       <comment>Subject of mailing</comment>
       <add>3.4</add>
  </field>
 <field>
       <name>record_activity</name>
       <type>boolean</type>
       <default>NULL</default>
       <comment>Record Activity for this reminder?</comment>
       <add>3.4</add>
  </field>
  <field>
      <name>mapping_id</name>
      <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>
    <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>
    <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>
       <type>date</type>
       <comment>Date on which the reminder be sent.</comment>
       <add>4.1</add>
  </field>
  <field>
    <name>from_name</name>
    <type>varchar</type>
    <length>255</length>
    <comment>Name in "from" field</comment>
    <add>4.5</add>
  </field>
  <field>
    <name>from_email</name>
    <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>
    <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>
</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>
	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>
3e315abc	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>
6a488035 TO	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>
d9cf711e	71	<type>varchar</type>
d9cf711e	72	<length>8</length>
6a488035	73	<comment>Time units for reminder.</comment>
f80ce889	74	<pseudoconstant>
9775f926	75	<callback>CRM_Core_SelectValues::getScheduleReminderFrequencyUnits</callback>
f80ce889	76	</pseudoconstant>
6a488035	77	<add>3.4</add>
614d72ec	78	<html>
	79	<type>Select</type>
	80	</html>
6a488035 TO	81	</field>
	82	<field>
	83	<name>start_action_condition</name>
	84	<type>varchar</type>
	85	<length>32</length>
	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>
	95	</field>
	96	<field>
	97	<name>is_repeat</name>
	98	<title>Repeat?</title>
	99	<type>boolean</type>
	100	<default>0</default>
	101	<add>3.4</add>
	102	</field>
	103	<field>
	104	<name>repetition_frequency_unit</name>
d9cf711e	105	<type>varchar</type>
d9cf711e	106	<length>8</length>
6a488035	107	<comment>Time units for repetition of reminder.</comment>
f80ce889	108	<pseudoconstant>
9775f926	109	<callback>CRM_Core_SelectValues::getScheduleReminderFrequencyUnits</callback>
f80ce889	110	</pseudoconstant>
6a488035	111	<add>3.4</add>
614d72ec	112	<html>
	113	<type>Select</type>
	114	</html>
6a488035 TO	115	</field>
	116	<field>
	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>
	121	</field>
	122	<field>
	123	<name>end_frequency_unit</name>
d9cf711e	124	<type>varchar</type>
d9cf711e	125	<length>8</length>
6a488035	126	<comment>Time units till repetition of reminder.</comment>
f80ce889	127	<pseudoconstant>
9775f926	128	<callback>CRM_Core_SelectValues::getScheduleReminderFrequencyUnits</callback>
f80ce889	129	</pseudoconstant>
6a488035	130	<add>3.4</add>
614d72ec	131	<html>
	132	<type>Select</type>
	133	</html>
6a488035 TO	134	</field>
	135	<field>
	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>
	140	</field>
	141	<field>
	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>
	147	</field>
	148	<field>
	149	<name>end_date</name>
	150	<type>varchar</type>
	151	<length>64</length>
	152	<comment>Entity end date</comment>
	153	<add>3.4</add>
	154	</field>
	155	<field>
	156	<name>is_active</name>
	157	<type>boolean</type>
	158	<default>1</default>
	159	<comment>Is this option active?</comment>
	160	<add>3.4</add>
	161	</field>
3c7d2158	162	<field>
3c7d2158	163	<name>recipient_manual</name>
6a488035	164	<title>Recipient Manual</title>
3c7d2158	165	<type>varchar</type>
	166	<length>128</length>
	167	<comment>Contact IDs to which reminder should be sent.</comment>
	168	<add>3.4</add>
6a488035	169	</field>
3c7d2158	170	<field>
3c7d2158	171	<name>recipient_listing</name>
6a488035	172	<title>Recipient Listing</title>
3c7d2158	173	<type>varchar</type>
	174	<length>128</length>
	175	<comment>listing based on recipient field.</comment>
	176	<add>4.1</add>
6a488035 TO	177	</field>
	178	<field>
	179	<name>body_text</name>
	180	<type>longtext</type>
	181	<comment>Body of the mailing in text format.</comment>
	182	<add>3.4</add>
	183	</field>
	184	<field>
	185	<name>body_html</name>
	186	<type>longtext</type>
	187	<comment>Body of the mailing in html format.</comment>
	188	<add>3.4</add>
	189	</field>
	190	<field>
	191	<name>subject</name>
	192	<type>varchar</type>
	193	<length>128</length>
	194	<comment>Subject of mailing</comment>
	195	<add>3.4</add>
	196	</field>
	197	<field>
	198	<name>record_activity</name>
	199	<type>boolean</type>
	200	<default>NULL</default>
	201	<comment>Record Activity for this reminder?</comment>
	202	<add>3.4</add>
	203	</field>
	204	<field>
	205	<name>mapping_id</name>
	206	<type>int unsigned</type>
	207	<comment>FK to mapping which is being used by this reminder</comment>
	208	<add>3.4</add>
	209	</field>
	210	<foreignKey>
	211	<name>mapping_id</name>
	212	<table>civicrm_action_mapping</table>
	213	<key>id</key>
	214	<onDelete>SET NULL</onDelete>
3c7d2158	215	</foreignKey>
6a488035	216	<field>
29494eef AS	217	<name>group_id</name>
	218	<type>int unsigned</type>
	219	<comment>FK to Group</comment>
	220	<pseudoconstant>
	221	<table>civicrm_group</table>
	222	<keyColumn>id</keyColumn>
	223	<labelColumn>title</labelColumn>
	224	</pseudoconstant>
614d72ec	225	<html>
e0991796	226	<type>Select</type>
614d72ec	227	</html>
29494eef AS	228	<add>3.4</add>
29494eef AS	229	</field>
6a488035 TO	230	<foreignKey>
	231	<name>group_id</name>
	232	<table>civicrm_group</table>
	233	<key>id</key>
	234	<onDelete>SET NULL</onDelete>
	235	</foreignKey>
	236	<field>
	237	<name>msg_template_id</name>
011aeb62	238	<type>int unsigned</type>
011aeb62	239	<comment>FK to the message template.</comment>
6a488035 TO	240	</field>
	241	<foreignKey>
	242	<name>msg_template_id</name>
011aeb62	243	<table>civicrm_msg_template</table>
	244	<key>id</key>
	245	<onDelete>SET NULL</onDelete>
6a488035 TO	246	</foreignKey>
	247	<field>
	248	<name>absolute_date</name>
	249	<type>date</type>
	250	<comment>Date on which the reminder be sent.</comment>
	251	<add>4.1</add>
	252	</field>
1991bba1 DG	253	<field>
	254	<name>from_name</name>
	255	<type>varchar</type>
	256	<length>255</length>
	257	<comment>Name in "from" field</comment>
	258	<add>4.5</add>
	259	</field>
	260	<field>
	261	<name>from_email</name>
	262	<type>varchar</type>
	263	<length>255</length>
	264	<comment>Email address in "from" field</comment>
	265	<add>4.5</add>
	266	</field>
a3e3eea1	267	<field>
	268	<name>mode</name>
	269	<title>Message Mode</title>
	270	<default>"Email"</default>
	271	<type>varchar</type>
	272	<length>128</length>
	273	<comment>Send the message as email or sms or both.</comment>
	274	<pseudoconstant>
	275	<optionGroupName>msg_mode</optionGroupName>
	276	</pseudoconstant>
	277	<html>
	278	<type>Select</type>
	279	</html>
	280	<add>4.5</add>
	281	</field>
	282	<field>
	283	<name>sms_provider_id</name>
	284	<type>int unsigned</type>
	285	<add>4.5</add>
	286	<html>
	287	<type>Select</type>
	288	</html>
	289	</field>
	290	<foreignKey>
	291	<name>sms_provider_id</name>
	292	<table>civicrm_sms_provider</table>
	293	<key>id</key>
	294	<onDelete>SET NULL</onDelete>
	295	<add>4.5</add>
	296	</foreignKey>
6a488035	297	</table>