Revert "Schema - Fix boolean fields in various tables"
[civicrm-core.git] / xml / schema / Contact / RelationshipCache.xml
index e24998f55ef02e30589234643d371d7f3a83d8b5..e53094d61a35ce888c4534bc9a8f04797fed5e3c 100644 (file)
@@ -9,6 +9,12 @@
   <log>false</log>
   <icon>fa-handshake-o</icon>
   <title>Related Contact</title>
+  <paths>
+    <view>civicrm/contact/view/rel?action=view&amp;reset=1&amp;cid=[near_contact_id]&amp;id=[relationship_id]</view>
+    <update>civicrm/contact/view/rel?action=update&amp;reset=1&amp;cid=[near_contact_id]&amp;id=[relationship_id]&amp;rtype=[orientation]</update>
+    <delete>civicrm/contact/view/rel?action=delete&amp;reset=1&amp;cid=[near_contact_id]&amp;id=[relationship_id]</delete>
+  </paths>
+
   <field>
     <name>id</name>
     <type>int unsigned</type>
     </html>
     <readonly>true</readonly>
   </field>
+  <field>
+    <name>case_id</name>
+    <type>int unsigned</type>
+    <component>CiviCase</component>
+    <title>Case ID</title>
+    <default>NULL</default>
+    <comment>FK to civicrm_case</comment>
+    <html>
+      <label>Case</label>
+    </html>
+    <add>5.44</add>
+    <readonly>true</readonly>
+  </field>
+  <foreignKey>
+    <name>case_id</name>
+    <table>civicrm_case</table>
+    <key>id</key>
+    <add>2.2</add>
+    <onDelete>CASCADE</onDelete>
+  </foreignKey>
 </table>