Getting error in creating table in mysql database

[Prakash Dwivedi]

CREATE TABLE `manufacturer` (
`manufacturer_id` bigint( 10 ) NOT NULL AUTO_INCREMENT ,
`vehicle_type_fk` bigint( 10 ) NOT NULL ,
`manufacturer_name` varchar( 255 ) NOT NULL ,
`manufacturer_logo` varchar( 255 ) NOT NULL ,
`sort_order` bigint( 10 ) NOT NULL ,
`manufacturer_status` int( 2 ) NOT NULL ,
`create_date` datetime NOT NULL ,
`modified_date` datetime NOT NULL ,
`created_by` int( 11 ) NOT NULL ,
PRIMARY KEY ( `manufacturer_id` ) ,
KEY `vehicle_type_fk` ( `vehicle_type_fk` ) ,
CONSTRAINT `manufacturer_ibfk_1` FOREIGN KEY ( `vehicle_type_fk` ) REFERENCES `vehicle_type` ( `vehicle_type_id` ) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT =67 DEFAULT CHARSET = latin1;        


I am getting error ::: #1005 - Can't create table 'focusis.manufacturer' (errno: 150)

Please help me out.

[Rahul Shrivastava]

hello

      prakash create  first table vehicle_type and then create manufacturer table.

--
Create filter of mails from this group http://www.wikihow.com/Create-a-Filter-in-Gmail
Manage your settings from http://groups.google.com/groups/mysubs?pli=1
---
You received this message because you are subscribed to the Google Groups "PHP Developers' Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to xamppdev+u...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.