[rt-devel] primary keys on table
khera at kcilink.com
Fri Oct 18 15:13:38 EDT 2002
>>>>> "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.
More information about the Rt-devel