
May 1st, 2008, 12:05 PM
|
|
Contributing User
|
|
Join Date: Jun 2003
Location: Long Beach, CA
Posts: 98
Time spent in forums: 2 Days 2 h 15 m 10 sec
Reputation Power: 5
|
|
|
ERROR 1005 (HY000) Can't create table (errno: 150)
What is wrong with this SQL? As far as I can tell I have everything right. I'm using the latest version of MySQL also.
This is all generated with the latest version of MySQL Workbench.
The permissions table I posted below is line 45 in the entire SQL code.
ERROR 1005 (HY000) at line 45: Can't create table './furcanvas_chat/permissions.frm' (errno: 150)
SQL Code:
Original
- SQL Code |
|
|
|
-
-- ----------------------------------------------------- -- Table `furcanvas_chat`.`members` -- ----------------------------------------------------- DROP TABLE IF EXISTS `furcanvas_chat`.`members` ; CREATE TABLE IF NOT EXISTS `furcanvas_chat`.`members` ( `id` INT UNSIGNED NOT NULL AUTO_INCREMENT , `who` VARCHAR(64) CHARACTER SET 'latin1' COLLATE 'latin1_general_ci' NOT NULL , `password` VARCHAR(512) CHARACTER SET 'latin1' COLLATE 'latin1_general_ci' NOT NULL , `email` VARCHAR(64) NOT NULL , `poses` VARCHAR(64) NOT NULL , `chatkey` VARCHAR(64) NOT NULL , PRIMARY KEY (`id`) ) ENGINE = InnoDB AUTO_INCREMENT = 48 ROW_FORMAT = DYNAMIC; -- ----------------------------------------------------- -- Table `furcanvas_chat`.`permissions` -- ----------------------------------------------------- DROP TABLE IF EXISTS `furcanvas_chat`.`permissions` ; CREATE TABLE IF NOT EXISTS `furcanvas_chat`.`permissions` ( `user_id` INT UNSIGNED NOT NULL , `admin_id` INT UNSIGNED NOT NULL , `bodyshop_id` INT UNSIGNED NOT NULL , `reviewer_id` INT UNSIGNED NOT NULL , `tickets_id` INT UNSIGNED NOT NULL , PRIMARY KEY (`user_id`) , CONSTRAINT `members` FOREIGN KEY (`user_id` ) REFERENCES `furcanvas_chat`.`members` (`id` ) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = InnoDB ROW_FORMAT = DYNAMIC;
Last edited by Jason Knight : May 1st, 2008 at 02:25 PM.
|