MySQL - Foreign Keys & Ticket Deletion

RT Developers
1

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?

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@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
2

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@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@lists.bestpractical.com
The rt-devel Archives

Request Tracker... So much more than a help desk — Best Practical Solutions – Trouble Ticketing. Free.