mysql hy000 1005,mysql – ERROR 1005(HY000)：无法创建表(errno：150)

当我尝试在

mysql中创建一个表时,我收到一个错误.

任何提示解决吗？

create table stock_in(

ind int not null auto_increment,

itemcode varchar(10) not null,

quantity int not null,

description text not null,

sales_ref int not null default -1,

return_outwards_ref int not null default -1,

stock_in_receipt_ref int not null default -1,

date text not null,

time text not null,

username text not null,

foreign key (sales_ref) references sales (receiptno),

foreign key (return_outwards_ref) references returnoutwards(ind),

primary key (ind)

);

错误：

ERROR 1005 (HY000): Can't create table 'posinventory.stock_in' (errno: 150)