[rt-users] RT2 database cleanup before rt2->rt3 migration

Jesse Vincent jesse at bestpractical.com
Fri Sep 24 10:34:15 EDT 2004


> Once again, I call for Jesse to put in the proper FK's in the official 
> schema :-)

And how do you deal with "global" things which reference the
non-existent queue "0" or ACLs which reference a different table by a
compound key that needs a transformation or Watcher groups which may or
may not reference a specific row of another table depending on the
values of multiple keys?  Every time I've tried someone's suggestions
for enforced FK relationships (including ones I put together myself),
I've gotten bitten quite badly. Hell, I couldn't even drop the mysql
database after setting up relationships, at one point.

Jesse



> Vivek Khera, Ph.D.
> +1-301-869-4449 x806



More information about the rt-users mailing list