On Thu, Oct 16, 2003 at 10:15:20AM -0400, Matthew T. O'Connor wrote: > Foreign keys are a good example, when we delete the last entry in the > message table, the database should automatically delete all entries in > the phs_message table and in the msg_blocks table for us.
I think this would require triggers, which MySQL doesn't support, because there can't be a one-to-many relationship between a foreign key and field it references. Messages reference physmessages, not the other way around. xn
