svn commit: r1073943 - in /ofbiz/trunk/applications: accounting/entitydef/entitymodel.xml party/entitydef/entitymodel.xml product/entitydef/entitymodel.xml product/entitydef/entitymodel_shipment.xml workeffort/entitydef/entitymodel.xml

[jaz-3]

Author: jaz
Date: Wed Feb 23 20:55:16 2011
New Revision: 1073943

URL: http://svn.apache.org/viewvc?rev=1073943&view=rev
Log:
fixed a few entities missing index names for foreign keys

Modified:
    ofbiz/trunk/applications/accounting/entitydef/entitymodel.xml
    ofbiz/trunk/applications/party/entitydef/entitymodel.xml
    ofbiz/trunk/applications/product/entitydef/entitymodel.xml
    ofbiz/trunk/applications/product/entitydef/entitymodel_shipment.xml
    ofbiz/trunk/applications/workeffort/entitydef/entitymodel.xml

Modified: ofbiz/trunk/applications/accounting/entitydef/entitymodel.xml
URL: http://svn.apache.org/viewvc/ofbiz/trunk/applications/accounting/entitydef/entitymodel.xml?rev=1073943&r1=1073942&r2=1073943&view=diff
==============================================================================
--- ofbiz/trunk/applications/accounting/entitydef/entitymodel.xml (original)
+++ ofbiz/trunk/applications/accounting/entitydef/entitymodel.xml Wed Feb 23 20:55:16 2011
@@ -2350,7 +2350,7 @@ under the License.
         <relation type="one" fk-name="ACTGPREF_ODRCM" title="Order" rel-entity-name="CustomMethod">
             <key-map field-name="orderSeqCustMethId" rel-field-name="customMethodId"/>
         </relation>
-        <relation type="one" rel-entity-name="PaymentMethod">
+        <relation type="one" fk-name="ACTGPREF_PAYMTH" rel-entity-name="PaymentMethod">
             <key-map field-name="refundPaymentMethodId" rel-field-name="paymentMethodId"/>
         </relation>
         <relation type="one" fk-name="ACTGPREF_GLJRNL" rel-entity-name="GlJournal">

Modified: ofbiz/trunk/applications/party/entitydef/entitymodel.xml
URL: http://svn.apache.org/viewvc/ofbiz/trunk/applications/party/entitydef/entitymodel.xml?rev=1073943&r1=1073942&r2=1073943&view=diff
==============================================================================
--- ofbiz/trunk/applications/party/entitydef/entitymodel.xml (original)
+++ ofbiz/trunk/applications/party/entitydef/entitymodel.xml Wed Feb 23 20:55:16 2011
@@ -139,7 +139,7 @@ under the License.
       <relation type="one" fk-name="AGRMNT_GEOAP_AGR" rel-entity-name="Agreement">
         <key-map field-name="agreementId"/>
       </relation>
-      <relation type="one" rel-entity-name="AgreementItem">
+      <relation type="one" fk-name="AGRMNT_GEOAP_AGRI" rel-entity-name="AgreementItem">
         <key-map field-name="agreementId"/>
         <key-map field-name="agreementItemSeqId"/>
       </relation>
@@ -2041,7 +2041,7 @@ under the License.
         <relation type="one" fk-name="PTYINV_PTY" rel-entity-name="Party">
             <key-map field-name="partyIdFrom" rel-field-name="partyId"/>
         </relation>
-        <relation type="one" rel-entity-name="StatusItem">
+        <relation type="one" fk-name="PTYINV_STTS" rel-entity-name="StatusItem">
             <key-map field-name="statusId"/>
         </relation>
     </entity>
@@ -2052,13 +2052,13 @@ under the License.
         <field name="partyIdTo" type="id-ne"></field>
         <prim-key field="partyInvitationId"/>
         <prim-key field="partyIdTo"/>
-        <relation type="one" title="To" rel-entity-name="PartyGroup">
+        <relation type="one" fk-name="PTYINVGA_PTYGRP" title="To" rel-entity-name="PartyGroup">
             <key-map field-name="partyIdTo" rel-field-name="partyId"/>
         </relation>
-        <relation type="one" title="To" rel-entity-name="Party">
+        <relation type="one" fk-name="PTYINVGA_PTYTO" title="To" rel-entity-name="Party">
             <key-map field-name="partyIdTo" rel-field-name="partyId"/>
         </relation>
-        <relation type="one" rel-entity-name="PartyInvitation">
+        <relation type="one" fk-name="PTYINVGA_PTYINV" rel-entity-name="PartyInvitation">
             <key-map field-name="partyInvitationId"/>
         </relation>
     </entity>
@@ -2069,10 +2069,10 @@ under the License.
         <field name="roleTypeId" type="id-ne"></field>
         <prim-key field="partyInvitationId"/>
         <prim-key field="roleTypeId"/>
-        <relation type="one" rel-entity-name="RoleType">
+        <relation type="one" fk-name="PTYINVROLE_ROLET" rel-entity-name="RoleType">
             <key-map field-name="roleTypeId"/>
         </relation>
-        <relation type="one" rel-entity-name="PartyInvitation" fk-name="PTYINVROLE_PTYINV">
+        <relation type="one" fk-name="PTYINVROLE_PTYINV" rel-entity-name="PartyInvitation">
             <key-map field-name="partyInvitationId"/>
         </relation>
     </entity>

Modified: ofbiz/trunk/applications/product/entitydef/entitymodel.xml
URL: http://svn.apache.org/viewvc/ofbiz/trunk/applications/product/entitydef/entitymodel.xml?rev=1073943&r1=1073942&r2=1073943&view=diff
==============================================================================
--- ofbiz/trunk/applications/product/entitydef/entitymodel.xml (original)
+++ ofbiz/trunk/applications/product/entitydef/entitymodel.xml Wed Feb 23 20:55:16 2011
@@ -1503,7 +1503,7 @@ under the License.
       <relation type="one" fk-name="PROD_FEAT_TYPE" rel-entity-name="ProductFeatureType">
         <key-map field-name="productFeatureTypeId"/>
       </relation>
-      <relation rel-entity-name="Uom" type="one">
+      <relation type="one" fk-name="PROD_FEAT_UOM" rel-entity-name="Uom">
           <key-map field-name="uomId"/>
       </relation>
     </entity>

Modified: ofbiz/trunk/applications/product/entitydef/entitymodel_shipment.xml
URL: http://svn.apache.org/viewvc/ofbiz/trunk/applications/product/entitydef/entitymodel_shipment.xml?rev=1073943&r1=1073942&r2=1073943&view=diff
==============================================================================
--- ofbiz/trunk/applications/product/entitydef/entitymodel_shipment.xml (original)
+++ ofbiz/trunk/applications/product/entitydef/entitymodel_shipment.xml Wed Feb 23 20:55:16 2011
@@ -603,7 +603,7 @@ under the License.
       <relation type="one" fk-name="SHPMNT_PRTNHDR" title="Primary" rel-entity-name="ReturnHeader">
         <key-map field-name="primaryReturnId" rel-field-name="returnId"/>
       </relation>
-      <relation type="one" rel-entity-name="PicklistBin">
+      <relation type="one" fk-name="SHPMNT_PKLSTBIN" rel-entity-name="PicklistBin">
           <key-map field-name="picklistBinId"/>
       </relation>
       <relation type="one-nofk" title="Primary" rel-entity-name="OrderItemShipGroup">

Modified: ofbiz/trunk/applications/workeffort/entitydef/entitymodel.xml
URL: http://svn.apache.org/viewvc/ofbiz/trunk/applications/workeffort/entitydef/entitymodel.xml?rev=1073943&r1=1073942&r2=1073943&view=diff
==============================================================================
--- ofbiz/trunk/applications/workeffort/entitydef/entitymodel.xml (original)
+++ ofbiz/trunk/applications/workeffort/entitydef/entitymodel.xml Wed Feb 23 20:55:16 2011
@@ -882,13 +882,13 @@ under the License.
       <prim-key field="workEffortId"/>
       <prim-key field="surveyId"/>
       <prim-key field="fromDate"/>
-      <relation type="one" rel-entity-name="Survey">
+      <relation type="one" fk-name="WKEF_SURVAPL_SVY" rel-entity-name="Survey">
         <key-map field-name="surveyId"/>
       </relation>
-      <relation type="one" rel-entity-name="WorkEffort">
+      <relation type="one" fk-name="WKEF_SURVAPL_WKE" rel-entity-name="WorkEffort">
         <key-map field-name="workEffortId"/>
       </relation>
-      <relation type="one" rel-entity-name="ProductStoreSurveyAppl">
+      <relation type="one" fk-name="WKEF_SURVAPL_PSSA" rel-entity-name="ProductStoreSurveyAppl">
         <key-map field-name="surveyId" rel-field-name="productStoreSurveyId"/>
       </relation>
     </entity>