Ahh you're right I did not pay attention to one-nofk setup. I just looked at the relationship.
Thanks Scott and sorry Pedro, but now you got the answer. Taher Alkhateeb On Wednesday, 30 December 2015, Scott Gray <[email protected]> wrote: > That's incorrect, there is no foreign-key dependency between > SecurityGroupPermission and SecurityPermission and this is done on purpose. > > Here's an old discussion on the topic: > http://ofbiz.135035.n4.nabble.com/security-permission-td154203.html#a154208 > > Regards > Scott > > On 29 December 2015 at 05:06, Taher Alkhateeb <[email protected] > <javascript:;>> > wrote: > > > Hi Pedro, > > > > I would assume the problem is in your migration process. Do you face the > > same thing on a fresh new database? If no, then you need to check what > went > > wrong with your migration. > > > > Taher Alkhateeb > > > > On Mon, Dec 28, 2015 at 6:59 PM, Pedro Lopes <[email protected] > <javascript:;>> > > wrote: > > > > > Hello all, > > > > > > Taher, thank you very much for your reply. > > > > > > OK, is that relationship supposed to be on the database also? I > migrated > > to > > > mysql and did not find it there. > > > > > > Thank you for your attention, > > > > > > Pedro > > > > > > On Mon, Dec 28, 2015 at 1:24 PM, Taher Alkhateeb < > > > [email protected] <javascript:;> > > > > wrote: > > > > > > > Hi Pedro, > > > > > > > > The SecurityGroupPermission entity has a foreign key to both > > > > SecurityPermission and SecurityGroup. You can check the entity > > definition > > > > in framework/security/entitydef/entitymodel.xml. This is because the > > > > SecurityGroupPermissions is a relationship entity (many to many) > > > > > > > > Taher Alkhateeb > > > > > > > > On Mon, Dec 28, 2015 at 3:15 PM, Pedro Lopes < > [email protected] <javascript:;>> > > > > wrote: > > > > > > > > > Hello all, > > > > > > > > > > Data model question: There isn't a foreign key between the tables > > > > > SECURITY_PERMISSION and SECURITY_GROUP_PERMISSION, is this table > not > > to > > > > > relate the table SECURITY_PERMISSION with SECURITY_GROUP? > > > > > > > > > > Thank you all very much, > > > > > > > > > > Pedro > > > > > > > > > > > > > > >
