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