-
Notifications
You must be signed in to change notification settings - Fork 0
/
backup.sql
290 lines (204 loc) · 17.2 KB
/
backup.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
--
-- PostgreSQL database dump
--
-- Dumped from database version 9.6.10
-- Dumped by pg_dump version 9.6.10
-- Started on 2018-10-30 02:15:21
SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET client_min_messages = warning;
SET row_security = off;
--
-- TOC entry 1 (class 3079 OID 12387)
-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner:
--
CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
--
-- TOC entry 2157 (class 0 OID 0)
-- Dependencies: 1
-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner:
--
COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
SET default_tablespace = '';
SET default_with_oids = false;
--
-- TOC entry 187 (class 1259 OID 16423)
-- Name: referenz_anmeldung; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public.referenz_anmeldung (
id integer NOT NULL,
referenz character(255),
plz character(255),
europaletten numeric(50,0),
sendung_gewicht numeric(50,0),
abholung_bereit date,
abholung_bereit_in character(255),
anlieferung_spat_bis date,
anlieferung_spat_in character(255),
"verfügbar" boolean
);
ALTER TABLE public.referenz_anmeldung OWNER TO postgres;
--
-- TOC entry 188 (class 1259 OID 16426)
-- Name: referenz_anmeldung_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--
CREATE SEQUENCE public.referenz_anmeldung_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.referenz_anmeldung_id_seq OWNER TO postgres;
--
-- TOC entry 2158 (class 0 OID 0)
-- Dependencies: 188
-- Name: referenz_anmeldung_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--
ALTER SEQUENCE public.referenz_anmeldung_id_seq OWNED BY public.referenz_anmeldung.id;
--
-- TOC entry 185 (class 1259 OID 16410)
-- Name: user_info; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public.user_info (
id integer NOT NULL,
email character(255),
password character(10000),
user_name character(255)
);
ALTER TABLE public.user_info OWNER TO postgres;
--
-- TOC entry 186 (class 1259 OID 16413)
-- Name: user_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--
CREATE SEQUENCE public.user_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.user_id_seq OWNER TO postgres;
--
-- TOC entry 2159 (class 0 OID 0)
-- Dependencies: 186
-- Name: user_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--
ALTER SEQUENCE public.user_id_seq OWNED BY public.user_info.id;
--
-- TOC entry 189 (class 1259 OID 16448)
-- Name: zeit_buchung_referenz; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public.zeit_buchung_referenz (
id integer NOT NULL,
telephone character(50),
ref_id numeric(1000,0),
fahrer character(100),
fahrzeug character(100),
email_bestatigung text,
datum_ausgewahlt character(100)
);
ALTER TABLE public.zeit_buchung_referenz OWNER TO postgres;
--
-- TOC entry 190 (class 1259 OID 16451)
-- Name: zeit_buchung_referenz_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--
CREATE SEQUENCE public.zeit_buchung_referenz_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.zeit_buchung_referenz_id_seq OWNER TO postgres;
--
-- TOC entry 2160 (class 0 OID 0)
-- Dependencies: 190
-- Name: zeit_buchung_referenz_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--
ALTER SEQUENCE public.zeit_buchung_referenz_id_seq OWNED BY public.zeit_buchung_referenz.id;
--
-- TOC entry 2017 (class 2604 OID 16428)
-- Name: referenz_anmeldung id; Type: DEFAULT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.referenz_anmeldung ALTER COLUMN id SET DEFAULT nextval('public.referenz_anmeldung_id_seq'::regclass);
--
-- TOC entry 2016 (class 2604 OID 16415)
-- Name: user_info id; Type: DEFAULT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.user_info ALTER COLUMN id SET DEFAULT nextval('public.user_id_seq'::regclass);
--
-- TOC entry 2018 (class 2604 OID 16453)
-- Name: zeit_buchung_referenz id; Type: DEFAULT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.zeit_buchung_referenz ALTER COLUMN id SET DEFAULT nextval('public.zeit_buchung_referenz_id_seq'::regclass);
--
-- TOC entry 2146 (class 0 OID 16423)
-- Dependencies: 187
-- Data for Name: referenz_anmeldung; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY public.referenz_anmeldung (id, referenz, plz, europaletten, sendung_gewicht, abholung_bereit, abholung_bereit_in, anlieferung_spat_bis, anlieferung_spat_in, "verfügbar") FROM stdin;
\.
--
-- TOC entry 2161 (class 0 OID 0)
-- Dependencies: 188
-- Name: referenz_anmeldung_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--
SELECT pg_catalog.setval('public.referenz_anmeldung_id_seq', 43, true);
--
-- TOC entry 2162 (class 0 OID 0)
-- Dependencies: 186
-- Name: user_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--
SELECT pg_catalog.setval('public.user_id_seq', 40, true);
--
-- TOC entry 2144 (class 0 OID 16410)
-- Dependencies: 185
-- Data for Name: user_info; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY public.user_info (id, email, password, user_name) FROM stdin;
40 admin 24f83f5b22|561af1b9f01a1aac4a36b0db381abf89|6bd8dcfc7a980732ec6056590fb6853dc444f160516cd1e59b1368cab1c0c212 admin
\.
--
-- TOC entry 2148 (class 0 OID 16448)
-- Dependencies: 189
-- Data for Name: zeit_buchung_referenz; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY public.zeit_buchung_referenz (id, telephone, ref_id, fahrer, fahrzeug, email_bestatigung, datum_ausgewahlt) FROM stdin;
\.
--
-- TOC entry 2163 (class 0 OID 0)
-- Dependencies: 190
-- Name: zeit_buchung_referenz_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--
SELECT pg_catalog.setval('public.zeit_buchung_referenz_id_seq', 28, true);
--
-- TOC entry 2020 (class 2606 OID 16422)
-- Name: user_info email; Type: CONSTRAINT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.user_info
ADD CONSTRAINT email UNIQUE (email);
--
-- TOC entry 2024 (class 2606 OID 16447)
-- Name: referenz_anmeldung referenz_anmeldung_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.referenz_anmeldung
ADD CONSTRAINT referenz_anmeldung_pkey PRIMARY KEY (id);
--
-- TOC entry 2022 (class 2606 OID 16420)
-- Name: user_info user_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.user_info
ADD CONSTRAINT user_pkey PRIMARY KEY (id);
--
-- TOC entry 2026 (class 2606 OID 16474)
-- Name: zeit_buchung_referenz zeit_buchung_referenz_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.zeit_buchung_referenz
ADD CONSTRAINT zeit_buchung_referenz_pkey PRIMARY KEY (id);
-- Completed on 2018-10-30 02:15:21
--
-- PostgreSQL database dump complete
--