Merge pull request #10630 from tschuettler/CRM-CRM-20841

[civicrm-core.git] / xml / schema / Case / CaseActivity.xml

diff --git a/xml/schema/Case/CaseActivity.xml b/xml/schema/Case/CaseActivity.xml
index 68e96231a39e0e4c1aeec8b10ad066d597d06e96..0ae6710e4d74324c7fb318185775507cec00e5e4 100644 (file)
--- a/xml/schema/Case/CaseActivity.xml
+++ b/xml/schema/Case/CaseActivity.xml
@@ -8,6 +8,7 @@
   <log>true</log>
   <field>
     <name>id</name>
+    <title>Case Activity ID</title>
     <type>int unsigned</type>
     <required>true</required>
     <comment>Unique case-activity association id</comment>
@@ -19,6 +20,7 @@
   </primaryKey>
   <field>
     <name>case_id</name>
+    <title>Case</title>
     <type>int unsigned</type>
     <required>true</required>
     <comment>Case ID of case-activity association.</comment>
@@ -33,6 +35,7 @@
   </foreignKey>
   <field>
     <name>activity_id</name>
+    <title>Activity ID</title>
     <type>int unsigned</type>
     <required>true</required>
     <comment>Activity ID of case-activity association.</comment>
@@ -51,9 +54,8 @@
     <fieldName>activity_id</fieldName>
     <add>2.0</add>
   </index>
-                                
 
-  <field> 
+  <field>
    <name>activity_entity_table</name>
    <type>varchar</type>
    <length>64</length>
@@ -64,13 +66,19 @@
   </field>
 
   <field>
-   <name>activity_entity_id</name>   
+   <name>activity_entity_id</name>
    <type>int unsigned</type>
    <required>true</required>
    <comment>Entity (activity, phonecall or meeting) id for which the assigment is created</comment>
    <add>1.8</add>
-   <drop>2.0</drop>   
+   <drop>2.0</drop>
   </field>
 
+  <dynamicForeignKey>
+   <idColumn>activity_entity_id</idColumn>
+   <typeColumn>activity_entity_table</typeColumn>
+   <add>1.8</add>
+   <drop>2.0</drop>
+  </dynamicForeignKey>
 
 </table>