[rt-users] Re: rt-users digest, Vol 1 #1169 - 8 msgs

[Nicolae P. Costescu]

>Assume you mean marked "dead" and for RT2.
>
>Someone here posted a script to do that a while back.  What I did was
>add referential constraints to the database with cascading deletes,
>and then I do this:  delete from tickets where status='dead'
>
>I posted the constraints here last week.  They don't work for mysql
>with the default setup for RT2.

I thought mysql didn't support cascading delete/updates since it doesn't 
support foreign keys?
****************************************************
Nicolae P. Costescu, Ph.D.  / Senior Developer
Stronghold Technologies
46040 Center Oak Plaza, Suite 160 / Sterling, Va 20166
Tel: 571-434-1472 / Fax: 571-434-1478