· 8 years ago · Nov 24, 2017, 08:12 AM
1--
2-- PostgreSQL database dump
3--
4
5-- Dumped from database version 10.0
6-- Dumped by pg_dump version 10.0
7
8-- Started on 2017-11-24 09:09:52
9
10SET statement_timeout = 0;
11SET lock_timeout = 0;
12SET idle_in_transaction_session_timeout = 0;
13SET client_encoding = 'UTF8';
14SET standard_conforming_strings = on;
15SET check_function_bodies = false;
16SET client_min_messages = warning;
17SET row_security = off;
18
19--
20-- TOC entry 1 (class 3079 OID 12924)
21-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner:
22--
23
24CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
25
26
27--
28-- TOC entry 2818 (class 0 OID 0)
29-- Dependencies: 1
30-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner:
31--
32
33COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
34
35
36SET search_path = public, pg_catalog;
37
38SET default_tablespace = '';
39
40SET default_with_oids = false;
41
42--
43-- TOC entry 197 (class 1259 OID 16396)
44-- Name: bouteille; Type: TABLE; Schema: public; Owner: postgres
45--
46
47CREATE TABLE bouteille (
48 idbouteille integer NOT NULL,
49 dateachat date,
50 millesime smallint,
51 idcepage integer,
52 idparcelle integer
53);
54
55
56ALTER TABLE bouteille OWNER TO postgres;
57
58--
59-- TOC entry 196 (class 1259 OID 16394)
60-- Name: bouteille_idbouteille_seq; Type: SEQUENCE; Schema: public; Owner: postgres
61--
62
63CREATE SEQUENCE bouteille_idbouteille_seq
64 AS integer
65 START WITH 1
66 INCREMENT BY 1
67 NO MINVALUE
68 NO MAXVALUE
69 CACHE 1;
70
71
72ALTER TABLE bouteille_idbouteille_seq OWNER TO postgres;
73
74--
75-- TOC entry 2819 (class 0 OID 0)
76-- Dependencies: 196
77-- Name: bouteille_idbouteille_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
78--
79
80ALTER SEQUENCE bouteille_idbouteille_seq OWNED BY bouteille.idbouteille;
81
82
83--
84-- TOC entry 199 (class 1259 OID 16402)
85-- Name: cepage; Type: TABLE; Schema: public; Owner: postgres
86--
87
88CREATE TABLE cepage (
89 idcepage integer NOT NULL,
90 nomcepage character varying(60)
91);
92
93
94ALTER TABLE cepage OWNER TO postgres;
95
96--
97-- TOC entry 198 (class 1259 OID 16400)
98-- Name: cepage_idcepage_seq; Type: SEQUENCE; Schema: public; Owner: postgres
99--
100
101CREATE SEQUENCE cepage_idcepage_seq
102 AS integer
103 START WITH 1
104 INCREMENT BY 1
105 NO MINVALUE
106 NO MAXVALUE
107 CACHE 1;
108
109
110ALTER TABLE cepage_idcepage_seq OWNER TO postgres;
111
112--
113-- TOC entry 2820 (class 0 OID 0)
114-- Dependencies: 198
115-- Name: cepage_idcepage_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
116--
117
118ALTER SEQUENCE cepage_idcepage_seq OWNED BY cepage.idcepage;
119
120
121--
122-- TOC entry 201 (class 1259 OID 16408)
123-- Name: parcelle; Type: TABLE; Schema: public; Owner: postgres
124--
125
126CREATE TABLE parcelle (
127 idparcelle integer NOT NULL,
128 nomparcelle character varying(60),
129 coordgps character varying(50)
130);
131
132
133ALTER TABLE parcelle OWNER TO postgres;
134
135--
136-- TOC entry 200 (class 1259 OID 16406)
137-- Name: parcelle_idparcelle_seq; Type: SEQUENCE; Schema: public; Owner: postgres
138--
139
140CREATE SEQUENCE parcelle_idparcelle_seq
141 AS integer
142 START WITH 1
143 INCREMENT BY 1
144 NO MINVALUE
145 NO MAXVALUE
146 CACHE 1;
147
148
149ALTER TABLE parcelle_idparcelle_seq OWNER TO postgres;
150
151--
152-- TOC entry 2821 (class 0 OID 0)
153-- Dependencies: 200
154-- Name: parcelle_idparcelle_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
155--
156
157ALTER SEQUENCE parcelle_idparcelle_seq OWNED BY parcelle.idparcelle;
158
159
160--
161-- TOC entry 2682 (class 2604 OID 16399)
162-- Name: bouteille idbouteille; Type: DEFAULT; Schema: public; Owner: postgres
163--
164
165ALTER TABLE ONLY bouteille ALTER COLUMN idbouteille SET DEFAULT nextval('bouteille_idbouteille_seq'::regclass);
166
167
168--
169-- TOC entry 2683 (class 2604 OID 16405)
170-- Name: cepage idcepage; Type: DEFAULT; Schema: public; Owner: postgres
171--
172
173ALTER TABLE ONLY cepage ALTER COLUMN idcepage SET DEFAULT nextval('cepage_idcepage_seq'::regclass);
174
175
176--
177-- TOC entry 2684 (class 2604 OID 16411)
178-- Name: parcelle idparcelle; Type: DEFAULT; Schema: public; Owner: postgres
179--
180
181ALTER TABLE ONLY parcelle ALTER COLUMN idparcelle SET DEFAULT nextval('parcelle_idparcelle_seq'::regclass);
182
183
184--
185-- TOC entry 2807 (class 0 OID 16396)
186-- Dependencies: 197
187-- Data for Name: bouteille; Type: TABLE DATA; Schema: public; Owner: postgres
188--
189
190INSERT INTO bouteille VALUES (1, '2017-11-24', 0, 1, 1);
191
192
193--
194-- TOC entry 2809 (class 0 OID 16402)
195-- Dependencies: 199
196-- Data for Name: cepage; Type: TABLE DATA; Schema: public; Owner: postgres
197--
198
199INSERT INTO cepage VALUES (1, 'St Graal');
200
201
202--
203-- TOC entry 2811 (class 0 OID 16408)
204-- Dependencies: 201
205-- Data for Name: parcelle; Type: TABLE DATA; Schema: public; Owner: postgres
206--
207
208INSERT INTO parcelle VALUES (1, 'Jesus', '0 nord,0 est');
209
210
211--
212-- TOC entry 2822 (class 0 OID 0)
213-- Dependencies: 196
214-- Name: bouteille_idbouteille_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
215--
216
217SELECT pg_catalog.setval('bouteille_idbouteille_seq', 1, true);
218
219
220--
221-- TOC entry 2823 (class 0 OID 0)
222-- Dependencies: 198
223-- Name: cepage_idcepage_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
224--
225
226SELECT pg_catalog.setval('cepage_idcepage_seq', 1, false);
227
228
229--
230-- TOC entry 2824 (class 0 OID 0)
231-- Dependencies: 200
232-- Name: parcelle_idparcelle_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
233--
234
235SELECT pg_catalog.setval('parcelle_idparcelle_seq', 1, false);
236
237
238-- Completed on 2017-11-24 09:09:53
239
240--
241-- PostgreSQL database dump complete
242--