Advertisement
Guest User

Untitled

a guest
Mar 29th, 2017
45
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.43 KB | None | 0 0
  1. CREATE TABLE `products` (
  2. `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
  3. `name` TEXT NOT NULL,
  4. PRIMARY KEY (`id`),
  5. );
  6.  
  7. CREATE TABLE `ingredients` (
  8. `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
  9. `name` TEXT NOT NULL,
  10. PRIMARY KEY (`id`),
  11. );
  12.  
  13. CREATE TABLE `ingredient_to_product` (
  14. `ingredient_id` INT UNSIGNED NOT NULL,
  15. `product_id` INT UNSIGNED NOT NULL,
  16. PRIMARY KEY (`ingredient_id`, `product_id`),
  17. INDEX (`product_id`)
  18. );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement