Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE `products` (
- `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
- `name` TEXT NOT NULL,
- PRIMARY KEY (`id`),
- );
- CREATE TABLE `ingredients` (
- `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
- `name` TEXT NOT NULL,
- PRIMARY KEY (`id`),
- );
- CREATE TABLE `ingredient_to_product` (
- `ingredient_id` INT UNSIGNED NOT NULL,
- `product_id` INT UNSIGNED NOT NULL,
- PRIMARY KEY (`ingredient_id`, `product_id`),
- INDEX (`product_id`)
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement