[rt-devel] MySQL - Foreign Keys & Ticket Deletion

[Jesse Vincent]

On Sun, Jan 11, 2004 at 03:19:04PM -0600, Ben Allen wrote:
> Are there any plans to do as suggested in make an update to the MySQL 
> schema to make use of the support for foreign keys and cascading?

see etc/constraints.mysql. I'd appreciate commentary on whether it
catches everything.

	-j
> 
> from http://www.mysql.com/doc/en/ANSI_diff_Foreign_Keys.html
> 
> In MySQL Server 3.23.44 and up, InnoDB tables support checking of 
> foreign key constraints, including CASCADE, ON DELETE, and ON UPDATE. 
> See section 7.5.5.2 FOREIGN KEY Constraints.
> 
> 
> In our previous installation (2.0.?? / PgSql / FreeBSD), we culled 
> deleted tickets from the database nightly via cron.  I'm trying to see 
> if there's a clean way to do the same on our new install (3.0.8 / MySQL 
> / FreeBSD).
> 
> Just Curious.
> 
> Thanks.
> 
> Ben
> -- 
> ======================================================================
> Benjamin Allen                                 benjamin at oitsec.umn.edu
> U of MN - OIT                                             612-625-7885
> 
>      I try to take one day at a time, but sometimes several
>         days attack me at once.  -- Ashleigh Brilliant
> 
> 
> _______________________________________________
> rt-devel mailing list
> rt-devel at lists.bestpractical.com
> http://lists.bestpractical.com/mailman/listinfo/rt-devel
> 

-- 
http://www.bestpractical.com/rt  -- Trouble Ticketing. Free.