Merge pull request #15504 from mattwire/transact

[civicrm-core.git] / xml / schema / Financial / EntityFinancialAccount.xml

diff --git a/xml/schema/Financial/EntityFinancialAccount.xml b/xml/schema/Financial/EntityFinancialAccount.xml
old mode 100755 (executable)
new mode 100644 (file)
index de635c6..9d20ca8
--- a/xml/schema/Financial/EntityFinancialAccount.xml
+++ b/xml/schema/Financial/EntityFinancialAccount.xml
@@ -9,6 +9,7 @@
   <log>true</log>
   <field>
     <name>id</name>
+    <title>Entity Financial Account ID</title>
     <type>int unsigned</type>
     <required>true</required>
     <comment>ID</comment>
@@ -20,6 +21,7 @@
   </primaryKey>
   <field>
     <name>entity_table</name>
+    <title>Entity Table</title>
     <type>varchar</type>
     <length>64</length>
     <required>true</required>
@@ -29,6 +31,7 @@
   </field>
   <field>
     <name>entity_id</name>
+    <title>Entity ID</title>
     <type>int unsigned</type>
     <required>true</required>
     <add>4.3</add>
@@ -41,6 +44,7 @@
   </dynamicForeignKey>
   <field>
     <name>account_relationship</name>
+    <title>Account Relationship</title>
     <type>int unsigned</type>
     <required>true</required>
     <add>4.3</add>
@@ -55,6 +59,7 @@
   <field>
     <name>financial_account_id</name>
     <type>int unsigned</type>
+    <title>Financial Account</title>
     <required>true</required>
     <add>4.3</add>
     <comment>FK to the financial_account_id</comment>
@@ -74,5 +79,12 @@
     <add>4.3</add>
     <onDelete>RESTRICT</onDelete>
   </foreignKey>
+  <index>
+    <name>index_entity_id_entity_table_account_relationship</name>
+    <fieldName>entity_id</fieldName>
+    <fieldName>entity_table</fieldName>
+    <fieldName>account_relationship</fieldName>
+    <unique>true</unique>
+    <add>4.7</add>
+  </index>
 </table>
-