1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
|
insert into recette (id, nom) values (1, 'A');
insert into recette (id, nom) values (2, 'B');
insert into recette (id, nom) values (3, 'C');
insert into ingredient (id, nom) values (1, 'Beurre');
insert into ingredient (id, nom) values (2, 'Farine');
insert into ingredient (id, nom) values (3, 'Levure');
insert into ingredient (id, nom) values (4, 'Chocolat');
insert into ingredient (id, nom) values (5, 'Huile');
insert into ingredient (id, nom) values (6, 'Parmesan');
insert into recette_ingredient (recette_id, ingredient_id) values (1, 1);
insert into recette_ingredient (recette_id, ingredient_id) values (1, 2);
insert into recette_ingredient (recette_id, ingredient_id) values (1, 3);
insert into recette_ingredient (recette_id, ingredient_id) values (2, 1);
insert into recette_ingredient (recette_id, ingredient_id) values (2, 4);
insert into recette_ingredient (recette_id, ingredient_id) values (3, 5);
insert into recette_ingredient (recette_id, ingredient_id) values (3, 6); |
Partager