use yourDatabaseName;
drop table IF EXISTS FK_order;
drop table IF EXISTS FK_product;
drop table IF EXISTS FK_customer;
CREATE TABLE FK_product (pid INT NOT NULL,
                      price FLOAT,
                      pname CHAR(10),
                      PRIMARY KEY(pid)) TYPE=INNODB;
CREATE TABLE FK_customer (cid INT NOT NULL,
                      name char(10),
                      PRIMARY KEY (cid)) TYPE=INNODB;
CREATE TABLE FK_order (ono INT NOT NULL AUTO_INCREMENT,
                      product_id INT NOT NULL,
                      customer_id INT NOT NULL,
                      PRIMARY KEY(ono),
                      FOREIGN KEY (product_id)
                        REFERENCES FK_product(pid)
                        ON UPDATE CASCADE ON DELETE RESTRICT,
                      FOREIGN KEY (customer_id)
                        REFERENCES FK_customer(cid)) TYPE=INNODB;
insert into FK_product values(10, 2.5, 'lamp');
insert into FK_product values(20, 3.5, 'rug');
insert into FK_product values(30, 5.5, 'soap');

insert into FK_customer values(2000, 'Dave');
insert into FK_customer values(3000, 'Bo');
insert into FK_customer values(4000, 'Gus');
insert into FK_customer values(5000, 'Dean');