KEY `par_ind` (`parent_id`)
) TYPE=InnoDB |
+--+
+
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:
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 VAR