I solved the problem in a way...
I used the "ON DELETE CASCADE" feature of InnoDB (ON DELETE CASCADE on all
foreign keys)
CREATE TABLE TURBINE_USER_GROUP_ROLE
(
USER_ID INTEGER NOT NULL,
GROUP_ID INTEGER NOT NULL,
ROLE_ID INTEGER NOT NULL,
PRIMARY KEY(USER_ID,GROUP_ID,ROLE_ID),
FOREIGN KEY (USER_ID) REFERENCES TURBINE_USER (USER_ID) ON DELETE
CASCADE,
FOREIGN KEY (GROUP_ID) REFERENCES TURBINE_GROUP (GROUP_ID) ON DELETE
CASCADE,
FOREIGN KEY (ROLE_ID) REFERENCES TURBINE_USER_ROLE (ROLE_ID) ON DELETE
CASCADE
);
It works, users and all dependancies in other tables are deleted.
This solved my problem but i don't know if a kind of ON DELETE CASCADE
feature is implemented in other table formats (ISAM etc..).
I think ORACLE supports that...
Good luck marian.
Mike
> Hi Mike!
> I'm experiencing the *same behaviour* using ORACLE database caused by the
> *same reason*. I was planning to post this issue, but you have jumped the
> queue Mike:))
> Anybody know about this bug ?
> Thx.
> $kala.
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
