X-Git-Url: https://vcs.fsf.org/?a=blobdiff_plain;f=xml%2Fschema%2FCore%2FActionLog.xml;h=f0faf45bbbce32160eed12137cb11bab65280d75;hb=5c4d65599fee6dfdf661b4932d12c5905e60ac90;hp=09f05039b227feb03c0256470eedc06f1682be53;hpb=f8c0096cdf4c70962010a7686412070b3417fe4d;p=civicrm-core.git

diff --git a/xml/schema/Core/ActionLog.xml b/xml/schema/Core/ActionLog.xml
index 09f05039b2..f0faf45bbb 100644
--- a/xml/schema/Core/ActionLog.xml
+++ b/xml/schema/Core/ActionLog.xml
@@ -7,84 +7,91 @@
   <comment>Table to store log for the reminder.</comment>
   <add>3.4</add>
   <field>
-      <name>id</name>
-      <type>int unsigned</type>
-      <required>true</required>
-      <add>3.4</add>
+    <name>id</name>
+    <type>int unsigned</type>
+    <required>true</required>
+    <add>3.4</add>
   </field>
   <primaryKey>
-       <name>id</name>
-       <autoincrement>true</autoincrement>
+    <name>id</name>
+    <autoincrement>true</autoincrement>
   </primaryKey>
   <field>
-      <name>contact_id</name>
-      <type>int unsigned</type>
-      <comment>FK to Contact ID</comment>
-      <add>3.4</add>
+    <name>contact_id</name>
+    <type>int unsigned</type>
+    <comment>FK to Contact ID</comment>
+    <add>3.4</add>
   </field>
   <foreignKey>
-       <name>contact_id</name>
-       <table>civicrm_contact</table>
-       <key>id</key>
-       <add>3.4</add>
-       <onDelete>CASCADE</onDelete>
+    <name>contact_id</name>
+    <table>civicrm_contact</table>
+    <key>id</key>
+    <add>3.4</add>
+    <onDelete>CASCADE</onDelete>
   </foreignKey>
   <field>
-      <name>entity_id</name>
-      <type>int unsigned</type>
-      <required>true</required>
-      <comment>FK to id of the entity that the action was performed on. Pseudo - FK.</comment>
-      <add>3.4</add>
+    <name>entity_id</name>
+    <type>int unsigned</type>
+    <required>true</required>
+    <comment>FK to id of the entity that the action was performed on. Pseudo - FK.</comment>
+    <add>3.4</add>
   </field>
   <field>
-       <name>entity_table</name>
-       <type>varchar</type>
-       <length>255</length>
-       <comment>name of the entity table for the above id, e.g. civicrm_activity, civicrm_participant</comment>
-       <add>3.4</add>
+    <name>entity_table</name>
+    <type>varchar</type>
+    <length>255</length>
+    <comment>name of the entity table for the above id, e.g. civicrm_activity, civicrm_participant</comment>
+    <add>3.4</add>
   </field>
   <dynamicForeignKey>
-       <idColumn>entity_id</idColumn>
-       <typeColumn>entity_table</typeColumn>
-       <add>3.4</add>
+    <idColumn>entity_id</idColumn>
+    <typeColumn>entity_table</typeColumn>
+    <add>3.4</add>
   </dynamicForeignKey>
   <field>
-      <name>action_schedule_id</name>
-      <type>int unsigned</type>
-      <required>true</required>
-      <comment>FK to the action schedule that this action originated from.</comment>
-      <add>3.4</add>
+    <name>action_schedule_id</name>
+    <type>int unsigned</type>
+    <required>true</required>
+    <comment>FK to the action schedule that this action originated from.</comment>
+    <add>3.4</add>
   </field>
   <foreignKey>
-       <name>action_schedule_id</name>
-       <table>civicrm_action_schedule</table>
-       <key>id</key>
-       <add>3.4</add>
-       <onDelete>CASCADE</onDelete>
+    <name>action_schedule_id</name>
+    <table>civicrm_action_schedule</table>
+    <key>id</key>
+    <add>3.4</add>
+    <onDelete>CASCADE</onDelete>
   </foreignKey>
   <field>
-      <name>action_date_time</name>
-      <type>datetime</type>
-      <comment>date time that the action was performed on.</comment>
-      <add>3.4</add>
+    <name>action_date_time</name>
+    <type>datetime</type>
+    <comment>date time that the action was performed on.</comment>
+    <add>3.4</add>
   </field>
   <field>
-      <name>is_error</name>
-      <type>boolean</type>
-      <default>0</default>
-      <comment>Was there any error sending the reminder?</comment>
-      <add>3.4</add>
+    <name>is_error</name>
+    <type>boolean</type>
+    <default>0</default>
+    <comment>Was there any error sending the reminder?</comment>
+    <add>3.4</add>
   </field>
   <field>
-     <name>message</name>
-     <type>text</type>
-     <comment>Description / text in case there was an error encountered.</comment>
-     <add>3.4</add>
+    <name>message</name>
+    <type>text</type>
+    <comment>Description / text in case there was an error encountered.</comment>
+    <add>3.4</add>
   </field>
   <field>
-      <name>repetition_number</name>
-      <type>int unsigned</type>
-      <comment>Keeps track of the sequence number of this repetition.</comment>
-      <add>3.4</add>
+    <name>repetition_number</name>
+    <type>int unsigned</type>
+    <comment>Keeps track of the sequence number of this repetition.</comment>
+    <add>3.4</add>
+  </field>
+  <field>
+    <name>reference_date</name>
+    <type>date</type>
+    <default>NULL</default>
+    <comment>Stores the date from the entity which triggered this reminder action (e.g. membership.end_date for most membership renewal reminders)</comment>
+    <add>4.6</add>
   </field>
 </table>