betoesquivel

sql mysql example sqlfiddle

Nov 3rd, 2014
454
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.69 KB | None | 0 0
  1. CREATE TABLE product (
  2.     category INT NOT NULL, id INT NOT NULL,
  3.     price DECIMAL,
  4.     PRIMARY KEY(category, id)
  5. )   ENGINE=INNODB;
  6.  
  7. CREATE TABLE customer (
  8.     id INT NOT NULL,
  9.     PRIMARY KEY (id)
  10. )   ENGINE=INNODB;
  11.  
  12. CREATE TABLE product_order (
  13.     no INT NOT NULL AUTO_INCREMENT,
  14.     product_category INT NOT NULL,
  15.     product_id INT NOT NULL,
  16.     customer_id INT NOT NULL,
  17.  
  18.     PRIMARY KEY(no),
  19.     INDEX (product_category, product_id),
  20.     INDEX (customer_id),
  21.  
  22.     FOREIGN KEY (product_category, product_id)
  23.       REFERENCES product(category, id)
  24.       ON UPDATE CASCADE ON DELETE RESTRICT,
  25.  
  26.     FOREIGN KEY (customer_id)
  27.       REFERENCES customer(id)
  28. )   ENGINE=INNODB;
Advertisement
Add Comment
Please, Sign In to add comment