Need help in creating table in mysql database

[Prakash Dwivedi]

I am getting error while creating table in mysql...Please help me out.

SQL query:

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( 1 ) 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;


While creating this table I am getting error like this ...........

MySQL said:

#1005 - Can't create table 'ibsinfoh_erp.manufacturer' (errno: 150) (Details...)


I assume Expected error in following line, however I can't figure it out ::
 `manufacturer_status` int( 1 ) NOT NULL ,