use yourDatabaseName;
      2 drop table IF EXISTS product_order;
      3 drop table IF EXISTS product;
      4 drop table IF EXISTS customer;
      5 CREATE TABLE product (pid INT NOT NULL,
      6                       price FLOAT,
      7                       pname CHAR(10),
      8                       PRIMARY KEY(pid)) TYPE=INNODB;
      9 CREATE TABLE customer (cid INT NOT NULL,
     10                       name char(10),
     11                       PRIMARY KEY (cid)) TYPE=INNODB;
     12 CREATE TABLE product_order (ono INT NOT NULL AUTO_INCREMENT,
     13                       product_id INT NOT NULL,
     14                       customer_id INT NOT NULL,
     15                       PRIMARY KEY(ono),
     16                       FOREIGN KEY (product_id)
     17                         REFERENCES product(pid)
     18                         ON UPDATE CASCADE ON DELETE RESTRICT,
     19                       FOREIGN KEY (customer_id)
     20                         REFERENCES customer(cid)) TYPE=INNODB;
     21 insert into product values(10, 2.5, 'lamp');
     22 insert into product values(20, 3.5, 'rug');
     23 insert into product values(30, 5.5, 'soap');

     27 insert into customer values(2000, 'Dave');
     28 insert into customer values(3000, 'Bo');
     29 insert into customer values(4000, 'Gus');
     30 insert into customer values(5000, 'Dean');