[rt-devel] primary keys on table

[Vivek Khera]

>>>>> "JV" == Jesse Vincent <jesse at bestpractical.com> writes:

>> ALTER TABLE ObjectKeywords ADD CONSTRAINT objectfk1 FOREIGN KEY (ObjectId) REFERENCES Tickets(id) MATCH FULL ON DELETE CASCADE;

JV> Slick. I can't wait until mysql actually supports this ;)

Someone here (or on rt-users) swore up and down that MySQL supports
referential integrity via foreign keys now.  I have no clue.

I'm sure there are other relationships that could have foriegn keys
added, but I don't need them...

I checked the rt 2.0.14 insertdata script and it doesn't appear to
have any alter tables for primary keys.