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