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]
