can't get line_items table created

I try to execute this script on Mysql and it can't create it and get this error in MySQL query browser window. "Can't create table '.\pos_development\line_items.frm' (errno: 150)"

The problem is with the "constraint fk_items_product" part of the script.

Help!!!

create table line_items (   id int not null auto_increment,   product_id int not null,   quantity int not null default 0,   unit_price decimal(10,2) not null,   constraint fk_items_product foreign key (product_id) references products(id),   primary key (id) );

Try changing the order in which you're creating the tables.

hth, Bill