[rt-devel] primary keys on table

[Jesse Vincent]

On Fri, Oct 18, 2002 at 03:13:38PM -0400, Vivek Khera wrote:
> Someone here (or on rt-users) swore up and down that MySQL supports
> referential integrity via foreign keys now.  I have no clue.

It supports defining the relationships, but doesn't actually do anything
with them.

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

Right. but they were added to the schema file. A new install should
insert them from that.

-- 
»|« http://www.bestpractical.com/rt  -- Trouble Ticketing. Free.