 2	1
 2	4
 \.
-
-
---
--- TOC entry 1748 (class 0 OID 16403)
--- Dependencies: 1472
--- Data for Name: recette; Type: TABLE DATA; Schema: public; Owner: -
---
-
-COPY recette (id, nom) FROM stdin;
-0	gateau
-1	omelette
-2	pain_perdu
-\.
-
-
---
--- TOC entry 1750 (class 0 OID 16424)
--- Dependencies: 1474
--- Data for Name: test_insert; Type: TABLE DATA; Schema: public; Owner: -
---
-
-COPY test_insert (foo, bar) FROM stdin;
-gateau	farine
-gateau	sucre
-gateau	oeuf
-gateau	lait
-omelette	sel
-omelette	oeuf
-pain_perdu	oeuf
-pain_perdu	lait
-pain_perdu	sucre
-\.
-
-
---
--- TOC entry 1742 (class 2606 OID 16402)
--- Dependencies: 1471 1471
--- Name: ingredient_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
---
-
-ALTER TABLE ONLY ingredient
-    ADD CONSTRAINT ingredient_pkey PRIMARY KEY (id);
-
-
---
--- TOC entry 1744 (class 2606 OID 16410)
--- Dependencies: 1472 1472
--- Name: recette_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
---
-
-ALTER TABLE ONLY recette
-    ADD CONSTRAINT recette_pkey PRIMARY KEY (id);
-
-
---
--- TOC entry 1746 (class 2606 OID 16419)
--- Dependencies: 1473 1741 1471
--- Name: liste_ingredient_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
---
-
-ALTER TABLE ONLY liste
-    ADD CONSTRAINT liste_ingredient_fkey FOREIGN KEY (ingredient) REFERENCES ingredient(id);
-
-
---
--- TOC entry 1745 (class 2606 OID 16414)
--- Dependencies: 1473 1743 1472
--- Name: liste_recette_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
---
-
-ALTER TABLE ONLY liste
-    ADD CONSTRAINT liste_recette_fkey FOREIGN KEY (recette) REFERENCES recette(id);
-
-
--- Completed on 2009-07-30 21:10:34 UTC
-
---
--- PostgreSQL database dump complete
---
-

5	sel
\.


--
-- TOC entry 1749 (class 0 OID 16411)
-- Dependencies: 1473
-- Data for Name: liste; Type: TABLE DATA; Schema: public; Owner: -
--

COPY liste (recette, ingredient) FROM stdin;
0	2

CREATE TABLE ingredient (
    id integer NOT NULL,
    nom text
);

ALTER TABLE ONLY ingredient
    ADD CONSTRAINT ingredient_pkey PRIMARY KEY (id);

COPY ingredient (id, nom) FROM stdin;
0	oeuf
