I think this is your problem
FOREIGN KEY(foo_user1) REFERENCES user(user_id) ON DELETE RESTRICT
| FOREIGN KEY(foo_user2) REFERENCES user(user_id) ON DELETE RESTRICT
Try creating another column for FK foo_user2
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4088363#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...