[rt-users] Query on Referential Integrity(RI) constraints in RT

[Ruslan U. Zakirov]

As I understand you have FK mysql schema I sent to the list.
Also RTx-Shredder distribution has rtx-validator script(which is out of
the date) and API to check RI.

MySQL(4.0.x) has bug so you can't create some FKs in other case code RT
would fail on delete operations.

--
Regards, Ruslan.

Ahalya_Nathan at mudnebr.com wrote:
> 
> Hi all,
> Right now there are 20 tables of RT in the database. I wanted to
> introduce RI between the tables. After analysing the RT codes to an
> extent, i feel that it shouldn't impact any perl codes. If any person
> has more information on this then it will be helpful.
> 
> 
> Regards,
> Ahalya Nathan
> Senior Programmer / Analyst
> Information Technology, Metropolitan Utilities District
> (402) 449-8218 phone
> (402) 449-8131 fax
> ahalya_nathan at mudnebr.com
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Be sure to check out the RT Wiki at http://wiki.bestpractical.com