Formated by GeSHi
SQL query: 
 
CREATE TABLE IF NOT EXISTS `lockstock`.`user` (
`user_id` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
`user_group_id` INT( 10 ) UNSIGNED NOT NULL ,
`client_type_id` INT( 11 ) NULL DEFAULT NULL ,
`broker_id` INT( 11 ) NULL DEFAULT NULL ,
`mcent_salsesman_id` INT( 11 ) NULL DEFAULT NULL ,
`user_login` VARCHAR( 20 ) NOT NULL ,
`user_pass` VARCHAR( 40 ) NOT NULL COMMENT 'sha1',
`user_first_name` VARCHAR( 40 ) NOT NULL ,
`user_surname` VARCHAR( 45 ) NOT NULL ,
`user_email` VARCHAR( 100 ) NOT NULL ,
`user_address` VARCHAR( 255 ) NOT NULL ,
`user_phone` VARCHAR( 255 ) NOT NULL ,
`user_active` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '1',
PRIMARY KEY ( `user_id` , `user_group_id` ) ,
INDEX `fk_user_user_group` ( `user_group_id` ASC ) ,
INDEX `fk_user_mcent_salsesman1` ( `mcent_salsesman_id` ASC ) ,
INDEX `fk_user_broker1` ( `broker_id` ASC ) ,
INDEX `fk_user_client_type1` ( `client_type_id` ASC ) ,
CONSTRAINT `fk_user_user_group` FOREIGN KEY ( `user_group_id` ) REFERENCES `lockstock`.`user_group` (
`user_group_id` 
) ON DELETE NO ACTION ON UPDATE NO ACTION ,
CONSTRAINT `fk_user_mcent_salsesman1` FOREIGN KEY ( `mcent_salsesman_id` ) REFERENCES `lockstock`.`mcent_salsesman` (
`mcent_salsesman_id` 
) ON DELETE NO ACTION ON UPDATE NO ACTION ,
CONSTRAINT `fk_user_broker1` FOREIGN KEY ( `broker_id` ) REFERENCES `lockstock`.`broker` (
`broker_id` 
) ON DELETE NO ACTION ON UPDATE NO ACTION ,
CONSTRAINT `fk_user_client_type1` FOREIGN KEY ( `client_type_id` ) REFERENCES `lockstock`.`client_type` (
`client_type_id` 
) ON DELETE NO ACTION ON UPDATE NO ACTION 
) ENGINE = InnoDB AUTO_INCREMENT =1 DEFAULT CHARACTER SET = utf8 COLLATE = utf8_general_ci 
 
 
MySQL said:  
#1005 - Can't create table './lockstock/user.frm' (errno: 150)
Parsed in 0.04666591 seconds