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