Hi Aditya, It would be good if we use upper case for fk-name, as its constraints and across the application we are using fk-name as upper case.
Thanks & Regards -- Deepak Dixit www.hotwaxsystems.com www.hotwax.co On Sat, Sep 23, 2017 at 1:54 PM, <jler...@apache.org> wrote: > Author: jleroux > Date: Sat Sep 23 08:24:08 2017 > New Revision: 1809375 > > URL: http://svn.apache.org/viewvc?rev=1809375&view=rev > Log: > Implemented: Missing foreign key constraint for fields userLoginId & > userPrefGroupTypeId in UserPreference entity > > UserPreference.userLoginId is related to UserLogin.userLoginId. > UserPreference.userPrefGroupTypeId is related to > UserPrefGroupType.userPrefGroupTypeId. > > (OFBIZ-9678) > > > Thanks: Aditya > > Modified: > ofbiz/ofbiz-framework/trunk/framework/common/entitydef/entitymodel.xml > > Modified: ofbiz/ofbiz-framework/trunk/framework/common/entitydef/ > entitymodel.xml > URL: http://svn.apache.org/viewvc/ofbiz/ofbiz-framework/trunk/ > framework/common/entitydef/entitymodel.xml?rev=1809375& > r1=1809374&r2=1809375&view=diff > ============================================================ > ================== > --- ofbiz/ofbiz-framework/trunk/framework/common/entitydef/entitymodel.xml > (original) > +++ ofbiz/ofbiz-framework/trunk/framework/common/entitydef/entitymodel.xml > Sat Sep 23 08:24:08 2017 > @@ -639,6 +639,12 @@ under the License. > <field name="userPrefDataType" type="id-long"><description>The > java data type of this preference (empty = java.lang.String)</ > description></field> > <prim-key field="userLoginId"/> > <prim-key field="userPrefTypeId"/> > + <relation type="one" fk-name="UP_User_Login" > rel-entity-name="UserLogin"> > + <key-map field-name="userLoginId"/> > + </relation> > + <relation type="one" fk-name="UP_User_Group_Type" rel-entity-name=" > UserPrefGroupType"> > + <key-map field-name="userPrefGroupTypeId"/> > + </relation> > </entity> > > <entity entity-name="UserPrefGroupType" > > >