Re: InnoDb referencing key bug?

2002-10-30 Thread Heikki Tuuri
| +--+ + 1 row in set (0.00 sec) mysql Regards, Heikki Innobase Oy sql query . Subject: InnoDb referencing key bug? From: Peter Brawley Date: Tue, 29 Oct 2002 14:13:45 -0800 In Jannie's problem, CREATE TABLE

InnoDb referencing key bug?

2002-10-29 Thread Peter Brawley
In Jannie's problem, CREATE TABLE pub_access_type( access_type_id INT UNSIGNED NOT NULL, access_type_name VARCHAR(25), PRIMARY KEY(access_type_id) ) TYPE=INNODB; CREATE TABLE pub_user( user_id INT UNSIGNED, parent_id INT, user_fname VARCHAR (25), user_lname VARCHAR (25), user_password