Re: Enforcing integrity of Foreign Keys

[Zachary Agatstein]

Well, in order to enforce referential integrity, I converted the tables to 
InnoDB.  But referential integrity is still not being enforced.   I use 
mysql version 3-23-54-nt, and the tables are generated through the use of 
dbdesigner (ver. 4.0.5.6 beta).

Here is a snippet of a "create" script:
============================
CREATE TABLE Types (
 Event_type VARCHAR(20) NOT NULL,
 PRIMARY KEY(Event_type)
)
TYPE=InnoDB;
CREATE TABLE Events (
 event_id INTEGER NOT NULL,
 Types_Event_type VARCHAR(20) NOT NULL,
 PRIMARY KEY(event_id),
 INDEX Events_FKIndex1(Types_Event_type),
 FOREIGN KEY(Types_Event_type)
   REFERENCES Types(Event_type)
     ON DELETE CASCADE
     ON UPDATE CASCADE
)
TYPE=InnoDB;
==========================
Is there anything still wrong with this?
ZA
_________________________________________________________________
MSN Toolbar provides one-click access to Hotmail from any Web page – FREE 
download! http://toolbar.msn.click-url.com/go/onm00200413ave/direct/01/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]