rRGd0EcJ

1[QUERY    ] SET statement_timeout = 0
2[QUERY    ] SET lock_timeout = 0
3[QUERY    ] SET client_encoding = 'UTF8'
4[QUERY    ] SET standard_conforming_strings = on
5[QUERY    ] SELECT pg_catalog.set_config('search_path', '', false)
6[QUERY    ] SET check_function_bodies = false
7[QUERY    ] SET client_min_messages = warning
8[QUERY    ] SET row_security = off
9[QUERY    ] CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog
10[QUERY    ] COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language'
11[QUERY    ] SET default_tablespace = ''
12[QUERY    ] SET default_with_oids = false
13[WARNING  ] CREATE TABLE public.r_vvp_pass_attach (
14                id bigint NOT NULL,
15                id_pass bigint NOT NULL,
16                id_attach bigint NOT NULL
17            )
18            ERRORE:  la relazione "r_vvp_pass_attach" esiste già
19[QUERY    ] ALTER TABLE public.r_vvp_pass_attach OWNER TO vivipass
20[WARNING  ] CREATE TABLE public.r_vvp_pass_user (
21                id bigint NOT NULL,
22                id_pass bigint NOT NULL,
23                id_user bigint NOT NULL
24            )
25            ERRORE:  la relazione "r_vvp_pass_user" esiste già
26[QUERY    ] ALTER TABLE public.r_vvp_pass_user OWNER TO vivipass
27[WARNING  ] CREATE TABLE public.r_vvp_pass_ztlpass (
28                id bigint NOT NULL,
29                id_pass bigint NOT NULL,
30                id_ztlpass bigint NOT NULL
31            )
32            ERRORE:  la relazione "r_vvp_pass_ztlpass" esiste già
33[QUERY    ] ALTER TABLE public.r_vvp_pass_ztlpass OWNER TO vivipass
34[WARNING  ] CREATE TABLE public.r_vvp_user_attach (
35                id bigint NOT NULL,
36                id_user bigint NOT NULL,
37                id_attach bigint NOT NULL
38            )
39            ERRORE:  la relazione "r_vvp_user_attach" esiste già
40[QUERY    ] ALTER TABLE public.r_vvp_user_attach OWNER TO vivipass
41[WARNING  ] CREATE TABLE public.t_vvp_attachment (
42                id bigint NOT NULL,
43                uuid character varying(40),
44                doc_type character varying(50),
45                size integer,
46                mimetype character varying(50),
47                filename character varying(100),
48                number character varying(50),
49                path character varying(200),
50                vl_from_date date,
51                vl_to_date date,
52                public_auth_type character varying(50),
53                creation_date timestamp without time zone,
54                last_modify_date timestamp without time zone,
55                create_user character varying(100),
56                last_modify_user character varying(100),
57                title character varying(50),
58                description character varying(200)
59            )
60            ERRORE:  la relazione "t_vvp_attachment" esiste già
61[QUERY    ] ALTER TABLE public.t_vvp_attachment OWNER TO vivipass
62[WARNING  ] CREATE TABLE public.t_vvp_cap_comuni (
63                id_cap integer NOT NULL,
64                cap character varying(5) NOT NULL,
65                id_comune integer NOT NULL,
66                vl_inizio date NOT NULL,
67                vl_fine date NOT NULL,
68                dt_agg date NOT NULL
69            )
70            ERRORE:  la relazione "t_vvp_cap_comuni" esiste già
71[QUERY    ] ALTER TABLE public.t_vvp_cap_comuni OWNER TO vivipass
72[WARNING  ] CREATE TABLE public.t_vvp_comuni (
73                id_comune integer NOT NULL,
74                sigla_provincia character varying(2) NOT NULL,
75                codice_istat character varying(6),
76                codice_mf character varying(4),
77                denominazione character varying(50) NOT NULL,
78                vl_inizio date NOT NULL,
79                vl_fine date NOT NULL,
80                dt_agg date,
81                id_provincia integer NOT NULL
82            )
83            ERRORE:  la relazione "t_vvp_comuni" esiste già
84[QUERY    ] ALTER TABLE public.t_vvp_comuni OWNER TO vivipass
85[WARNING  ] CREATE TABLE public.t_vvp_item_configuration (
86                id bigint NOT NULL,
87                domain character varying(200),
88                category character varying(500),
89                name character varying(100),
90                label character varying(200),
91                value character varying(200),
92                type character varying(50),
93                fk bigint,
94                version integer DEFAULT 0 NOT NULL,
95                cloneable boolean DEFAULT false,
96                "order" integer DEFAULT 0 NOT NULL,
97                mandatory boolean DEFAULT false NOT NULL
98            )
99            ERRORE:  la relazione "t_vvp_item_configuration" esiste già
100[QUERY    ] ALTER TABLE public.t_vvp_item_configuration OWNER TO vivipass
101[WARNING  ] CREATE TABLE public.t_vvp_pass (
102                id bigint NOT NULL,
103                process_instance_id character varying(100),
104                rfid character varying(100),
105                permission_number character varying(100),
106                fiscal_code character varying(16),
107                name character varying(100),
108                surname character varying(100),
109                vl_from_date date,
110                vl_to_date date,
111                release_date date,
112                forced_end_date date,
113                status_pass character varying(100),
114                cause character varying(100),
115                note character varying(2000),
116                temporary boolean,
117                duplicated boolean,
118                id_pass_or bigint,
119                permission_type character varying(100),
120                tenant_code character varying(20),
121                tenant_name character varying(100),
122                acquisition_channel character varying(50),
123                live boolean,
124                version_number integer,
125                creation_date timestamp without time zone,
126                last_modify_date timestamp without time zone,
127                create_user character varying(100),
128                last_modify_user character varying(100),
129                printed boolean,
130                verified boolean,
131                practice_outcome character varying(100),
132                cod_op character varying(10)
133            )
134            ERRORE:  la relazione "t_vvp_pass" esiste già
135[QUERY    ] ALTER TABLE public.t_vvp_pass OWNER TO vivipass
136[WARNING  ] CREATE TABLE public.t_vvp_payment (
137                id bigint NOT NULL,
138                id_pass bigint NOT NULL,
139                pay_id character varying(50),
140                pay_receipt_num character varying(50),
141                pay_type character varying(50),
142                pay_terms character varying(50),
143                pay_amount character varying(10),
144                pay_date date,
145                pay_holder_name character varying(100),
146                pay_holder_surname character varying(100),
147                creation_date timestamp without time zone,
148                last_modify_date timestamp without time zone,
149                create_user character varying(100),
150                last_modify_user character varying(100),
151                permission_type character varying(100)
152            )
153            ERRORE:  la relazione "t_vvp_payment" esiste già
154[QUERY    ] ALTER TABLE public.t_vvp_payment OWNER TO vivipass
155[WARNING  ] CREATE TABLE public.t_vvp_province (
156                id_provincia integer NOT NULL,
157                codice_istat character varying(3) NOT NULL,
158                sigla character varying(2) NOT NULL,
159                denominazione character varying(50) NOT NULL,
160                vl_inizio date NOT NULL,
161                vl_fine date NOT NULL,
162                dt_agg date NOT NULL,
163                id_regione integer NOT NULL
164            )
165            ERRORE:  la relazione "t_vvp_province" esiste già
166[QUERY    ] ALTER TABLE public.t_vvp_province OWNER TO vivipass
167[WARNING  ] CREATE TABLE public.t_vvp_regioni (
168                codice_istat character varying(3),
169                codice_ssn character varying(3),
170                codice_mf character varying(3),
171                denominazione character varying(50) NOT NULL,
172                codice_area character varying(1),
173                vl_inizio date NOT NULL,
174                vl_fine date NOT NULL,
175                dt_agg date NOT NULL,
176                id_area integer,
177                id_regione integer NOT NULL
178            )
179            ERRORE:  la relazione "t_vvp_regioni" esiste già
180[QUERY    ] ALTER TABLE public.t_vvp_regioni OWNER TO vivipass
181[WARNING  ] CREATE TABLE public.t_vvp_user (
182                id bigint NOT NULL,
183                fiscal_code character varying(16),
184                name character varying(100),
185                surname character varying(100),
186                birth_province character varying(20),
187                birth_place character varying(20),
188                birth_date date,
189                residence_province character varying(20),
190                residence_city character varying(20),
191                residence_address character varying(200),
192                residence_house_num character varying(10),
193                residence_postal_code character varying(10),
194                domicile_province character varying(20),
195                domicile_city character varying(20),
196                domicile_address character varying(200),
197                domicile_house_num character varying(10),
198                domicile_postal_code character varying(10),
199                telephone character varying(20),
200                cell character varying(20),
201                email character varying(100),
202                ref_name character varying(100),
203                ref_sur character varying(100),
204                ref_fiscal_code character varying(16),
205                creation_date timestamp without time zone,
206                last_modify_date timestamp without time zone,
207                create_user character varying(100),
208                last_modify_user character varying(100),
209                tenant_code character varying(20),
210                tenant_name character varying(100),
211                ref_type character varying(50)
212            )
213            ERRORE:  la relazione "t_vvp_user" esiste già
214[QUERY    ] ALTER TABLE public.t_vvp_user OWNER TO vivipass
215[WARNING  ] CREATE TABLE public.t_vvp_ztl_pass (
216                id bigint NOT NULL,
217                number character varying(20),
218                vehicle_type character varying(50),
219                foreign_state boolean,
220                use_type character varying(50),
221                pass_type character varying(50),
222                pass_subtype character varying(50),
223                pass_category character varying(50),
224                vl_from_date date,
225                vl_to_date date,
226                note character varying(2000),
227                flag_ztl_network boolean,
228                state_send_registry character varying(50),
229                certification_tenant_code character varying(50),
230                creation_date timestamp without time zone,
231                last_modify_date timestamp without time zone,
232                create_user character varying(100),
233                last_modify_user character varying(100)
234            )
235            ERRORE:  la relazione "t_vvp_ztl_pass" esiste già
236[QUERY    ] ALTER TABLE public.t_vvp_ztl_pass OWNER TO vivipass
237[WARNING  ] CREATE TABLE public.t_vvp_ztl_pass_registry_log (
238                id bigint NOT NULL,
239                id_ztl_pass bigint NOT NULL,
240                op_type character varying(50),
241                flag_stato_pass character varying(50),
242                flag_invio_pass character varying(50),
243                timestamp_ack_dreg character varying(50),
244                response_ack_dreg character varying(50)
245            )
246            ERRORE:  la relazione "t_vvp_ztl_pass_registry_log" esiste già
247[QUERY    ] ALTER TABLE public.t_vvp_ztl_pass_registry_log OWNER TO vivipass
248[WARNING  ] CREATE SEQUENCE public.vvp_attachment_id_seq
249                START WITH 1
250                INCREMENT BY 1
251                NO MINVALUE
252                MAXVALUE 999999999999999999
253                CACHE 1
254            ERRORE:  la relazione "vvp_attachment_id_seq" esiste già
255[QUERY    ] ALTER TABLE public.vvp_attachment_id_seq OWNER TO vivipass
256[WARNING  ] CREATE SEQUENCE public.vvp_item_conf_id_seq
257                START WITH 1
258                INCREMENT BY 1
259                NO MINVALUE
260                MAXVALUE 999999999999999999
261                CACHE 1
262            ERRORE:  la relazione "vvp_item_conf_id_seq" esiste già
263[QUERY    ] ALTER TABLE public.vvp_item_conf_id_seq OWNER TO vivipass
264[WARNING  ] CREATE SEQUENCE public.vvp_item_configuration_id_seq
265                START WITH 1
266                INCREMENT BY 1
267                NO MINVALUE
268                MAXVALUE 999999999999999999
269                CACHE 1
270            ERRORE:  la relazione "vvp_item_configuration_id_seq" esiste già
271[QUERY    ] ALTER TABLE public.vvp_item_configuration_id_seq OWNER TO vivipass
272[WARNING  ] CREATE SEQUENCE public.vvp_pass_attach_id_seq
273                START WITH 1
274                INCREMENT BY 1
275                NO MINVALUE
276                MAXVALUE 999999999999999999
277                CACHE 1
278            ERRORE:  la relazione "vvp_pass_attach_id_seq" esiste già
279[QUERY    ] ALTER TABLE public.vvp_pass_attach_id_seq OWNER TO vivipass
280[WARNING  ] CREATE SEQUENCE public.vvp_pass_id_seq
281                START WITH 1
282                INCREMENT BY 1
283                NO MINVALUE
284                MAXVALUE 999999999999999999
285                CACHE 1
286            ERRORE:  la relazione "vvp_pass_id_seq" esiste già
287[QUERY    ] ALTER TABLE public.vvp_pass_id_seq OWNER TO vivipass
288[WARNING  ] CREATE SEQUENCE public.vvp_pass_user_id_seq
289                START WITH 1
290                INCREMENT BY 1
291                NO MINVALUE
292                MAXVALUE 999999999999999999
293                CACHE 1
294            ERRORE:  la relazione "vvp_pass_user_id_seq" esiste già
295[QUERY    ] ALTER TABLE public.vvp_pass_user_id_seq OWNER TO vivipass
296[WARNING  ] CREATE SEQUENCE public.vvp_pass_ztlpass_id_seq
297                START WITH 1
298                INCREMENT BY 1
299                NO MINVALUE
300                MAXVALUE 999999999999999999
301                CACHE 1
302            ERRORE:  la relazione "vvp_pass_ztlpass_id_seq" esiste già
303[QUERY    ] ALTER TABLE public.vvp_pass_ztlpass_id_seq OWNER TO vivipass
304[WARNING  ] CREATE SEQUENCE public.vvp_payment_id_seq
305                START WITH 1
306                INCREMENT BY 1
307                NO MINVALUE
308                MAXVALUE 999999999999999999
309                CACHE 1
310            ERRORE:  la relazione "vvp_payment_id_seq" esiste già
311[QUERY    ] ALTER TABLE public.vvp_payment_id_seq OWNER TO vivipass
312[WARNING  ] CREATE SEQUENCE public.vvp_user_attach_id_seq
313                START WITH 1
314                INCREMENT BY 1
315                NO MINVALUE
316                MAXVALUE 999999999999999999
317                CACHE 1
318            ERRORE:  la relazione "vvp_user_attach_id_seq" esiste già
319[QUERY    ] ALTER TABLE public.vvp_user_attach_id_seq OWNER TO vivipass
320[WARNING  ] CREATE SEQUENCE public.vvp_user_id_seq
321                START WITH 1
322                INCREMENT BY 1
323                NO MINVALUE
324                MAXVALUE 999999999999999999
325                CACHE 1
326            ERRORE:  la relazione "vvp_user_id_seq" esiste già
327[QUERY    ] ALTER TABLE public.vvp_user_id_seq OWNER TO vivipass
328[WARNING  ] CREATE SEQUENCE public.vvp_ztl_pass_id_seq
329                START WITH 1
330                INCREMENT BY 1
331                NO MINVALUE
332                MAXVALUE 999999999999999999
333                CACHE 1
334            ERRORE:  la relazione "vvp_ztl_pass_id_seq" esiste già
335[QUERY    ] ALTER TABLE public.vvp_ztl_pass_id_seq OWNER TO vivipass
336[WARNING  ] CREATE SEQUENCE public.vvp_ztl_pass_reg_log_id_seq
337                START WITH 1
338                INCREMENT BY 1
339                NO MINVALUE
340                MAXVALUE 999999999999999999
341                CACHE 1
342            ERRORE:  la relazione "vvp_ztl_pass_reg_log_id_seq" esiste già
343[QUERY    ] ALTER TABLE public.vvp_ztl_pass_reg_log_id_seq OWNER TO vivipass
344[WARNING  ] CREATE SEQUENCE public.vvp_ztl_pass_registry_log_id_seq
345                START WITH 1
346                INCREMENT BY 1
347                NO MINVALUE
348                MAXVALUE 999999999999999999
349                CACHE 1
350            ERRORE:  la relazione "vvp_ztl_pass_registry_log_id_seq" esiste già
351[QUERY    ] ALTER TABLE public.vvp_ztl_pass_registry_log_id_seq OWNER TO vivipass
352[WARNING  ] ALTER TABLE ONLY public.t_vvp_cap_comuni
353                ADD CONSTRAINT cap_comuni_pk PRIMARY KEY (id_cap)
354            ERRORE:  non è possibile avere più di una chiave primaria per la tabella "t_vvp_cap_comuni"
355[WARNING  ] ALTER TABLE ONLY public.t_vvp_comuni
356                ADD CONSTRAINT comuni_pk PRIMARY KEY (id_comune)
357            ERRORE:  non è possibile avere più di una chiave primaria per la tabella "t_vvp_comuni"
358[WARNING  ] ALTER TABLE ONLY public.t_vvp_province
359                ADD CONSTRAINT province_pk PRIMARY KEY (id_provincia)
360            ERRORE:  non è possibile avere più di una chiave primaria per la tabella "t_vvp_province"
361[WARNING  ] ALTER TABLE ONLY public.r_vvp_pass_attach
362                ADD CONSTRAINT r_vvp_pass_attach_pk PRIMARY KEY (id)
363            ERRORE:  non è possibile avere più di una chiave primaria per la tabella "r_vvp_pass_attach"
364[WARNING  ] ALTER TABLE ONLY public.r_vvp_pass_user
365                ADD CONSTRAINT r_vvp_pass_user_pk PRIMARY KEY (id)
366            ERRORE:  non è possibile avere più di una chiave primaria per la tabella "r_vvp_pass_user"
367[WARNING  ] ALTER TABLE ONLY public.r_vvp_pass_ztlpass
368                ADD CONSTRAINT r_vvp_pass_ztlpass_pk PRIMARY KEY (id)
369            ERRORE:  non è possibile avere più di una chiave primaria per la tabella "r_vvp_pass_ztlpass"
370[WARNING  ] ALTER TABLE ONLY public.r_vvp_user_attach
371                ADD CONSTRAINT r_vvp_user_attach_pk PRIMARY KEY (id)
372            ERRORE:  non è possibile avere più di una chiave primaria per la tabella "r_vvp_user_attach"
373[WARNING  ] ALTER TABLE ONLY public.t_vvp_regioni
374                ADD CONSTRAINT regioni_pk PRIMARY KEY (id_regione)
375            ERRORE:  non è possibile avere più di una chiave primaria per la tabella "t_vvp_regioni"
376[WARNING  ] ALTER TABLE ONLY public.t_vvp_province
377                ADD CONSTRAINT unique_codice_istat UNIQUE (codice_istat, vl_inizio, vl_fine)
378            ERRORE:  la relazione "unique_codice_istat" esiste già
379[WARNING  ] ALTER TABLE ONLY public.t_vvp_comuni
380                ADD CONSTRAINT unique_codice_istat_comune UNIQUE (codice_istat, vl_inizio, vl_fine)
381            ERRORE:  la relazione "unique_codice_istat_comune" esiste già
382[WARNING  ] ALTER TABLE ONLY public.t_vvp_item_configuration
383                ADD CONSTRAINT unique_item_configuration UNIQUE (domain, category, name, version)
384            ERRORE:  la relazione "unique_item_configuration" esiste già
385[WARNING  ] ALTER TABLE ONLY public.r_vvp_pass_attach
386                ADD CONSTRAINT unique_pass_attach_1 UNIQUE (id_pass, id_attach)
387            ERRORE:  la relazione "unique_pass_attach_1" esiste già
388[WARNING  ] ALTER TABLE ONLY public.r_vvp_pass_user
389                ADD CONSTRAINT unique_pass_user_1 UNIQUE (id_pass, id_user)
390            ERRORE:  la relazione "unique_pass_user_1" esiste già
391[WARNING  ] ALTER TABLE ONLY public.r_vvp_pass_ztlpass
392                ADD CONSTRAINT unique_pass_ztlpass_1 UNIQUE (id_pass, id_ztlpass)
393            ERRORE:  la relazione "unique_pass_ztlpass_1" esiste già
394[WARNING  ] ALTER TABLE ONLY public.t_vvp_payment
395                ADD CONSTRAINT unique_payment_1 UNIQUE (pay_id)
396            ERRORE:  la relazione "unique_payment_1" esiste già
397[WARNING  ] ALTER TABLE ONLY public.t_vvp_pass
398                ADD CONSTRAINT unique_permission_number UNIQUE (permission_number, version_number)
399            ERRORE:  la relazione "unique_permission_number" esiste già
400[WARNING  ] ALTER TABLE ONLY public.t_vvp_user
401                ADD CONSTRAINT unique_user_1 UNIQUE (fiscal_code)
402            ERRORE:  la relazione "unique_user_1" esiste già
403[WARNING  ] ALTER TABLE ONLY public.r_vvp_user_attach
404                ADD CONSTRAINT unique_user_attach_1 UNIQUE (id_user, id_attach)
405            ERRORE:  la relazione "unique_user_attach_1" esiste già
406[WARNING  ] ALTER TABLE ONLY public.t_vvp_ztl_pass
407                ADD CONSTRAINT unique_ztl_pass_1 UNIQUE (number)
408            ERRORE:  la relazione "unique_ztl_pass_1" esiste già
409[WARNING  ] ALTER TABLE ONLY public.t_vvp_user
410                ADD CONSTRAINT user_pk PRIMARY KEY (id)
411            ERRORE:  non è possibile avere più di una chiave primaria per la tabella "t_vvp_user"
412[WARNING  ] ALTER TABLE ONLY public.t_vvp_attachment
413                ADD CONSTRAINT vvp_attach_pk PRIMARY KEY (id)
414            ERRORE:  non è possibile avere più di una chiave primaria per la tabella "t_vvp_attachment"
415[WARNING  ] ALTER TABLE ONLY public.t_vvp_attachment
416                ADD CONSTRAINT vvp_attach_unique_1 UNIQUE (uuid)
417            ERRORE:  la relazione "vvp_attach_unique_1" esiste già
418[WARNING  ] ALTER TABLE ONLY public.t_vvp_item_configuration
419                ADD CONSTRAINT vvp_item_configuration_pk PRIMARY KEY (id)
420            ERRORE:  non è possibile avere più di una chiave primaria per la tabella "t_vvp_item_configuration"
421[WARNING  ] ALTER TABLE ONLY public.t_vvp_pass
422                ADD CONSTRAINT vvp_pass_pk PRIMARY KEY (id)
423            ERRORE:  non è possibile avere più di una chiave primaria per la tabella "t_vvp_pass"
424[WARNING  ] ALTER TABLE ONLY public.t_vvp_payment
425                ADD CONSTRAINT vvp_payment_pk PRIMARY KEY (id)
426            ERRORE:  non è possibile avere più di una chiave primaria per la tabella "t_vvp_payment"
427[WARNING  ] ALTER TABLE ONLY public.t_vvp_ztl_pass
428                ADD CONSTRAINT ztl_pass_pk PRIMARY KEY (id)
429            ERRORE:  non è possibile avere più di una chiave primaria per la tabella "t_vvp_ztl_pass"
430[WARNING  ] ALTER TABLE ONLY public.t_vvp_ztl_pass_registry_log
431                ADD CONSTRAINT ztl_pass_registry_log_pk PRIMARY KEY (id)
432            ERRORE:  non è possibile avere più di una chiave primaria per la tabella "t_vvp_ztl_pass_registry_log"
433[WARNING  ] CREATE INDEX fki_province_regioni_fk ON public.t_vvp_province USING btree (id_regione)
434            ERRORE:  la relazione "fki_province_regioni_fk" esiste già
435[WARNING  ] ALTER TABLE ONLY public.t_vvp_cap_comuni
436                ADD CONSTRAINT cap_comuni_comuni_fk FOREIGN KEY (id_comune) REFERENCES public.t_vvp_comuni(id_comune)
437            ERRORE:  il vincolo "cap_comuni_comuni_fk" per la relazione "t_vvp_cap_comuni" esiste già
438[WARNING  ] ALTER TABLE ONLY public.t_vvp_comuni
439                ADD CONSTRAINT comuni_province_fk FOREIGN KEY (id_provincia) REFERENCES public.t_vvp_province(id_provincia)
440            ERRORE:  il vincolo "comuni_province_fk" per la relazione "t_vvp_comuni" esiste già
441[WARNING  ] ALTER TABLE ONLY public.t_vvp_item_configuration
442                ADD CONSTRAINT item_conf_fk FOREIGN KEY (fk) REFERENCES public.t_vvp_item_configuration(id)
443            ERRORE:  il vincolo "item_conf_fk" per la relazione "t_vvp_item_configuration" esiste già
444[WARNING  ] ALTER TABLE ONLY public.r_vvp_pass_attach
445                ADD CONSTRAINT pass_attach_attach_fk FOREIGN KEY (id_attach) REFERENCES public.t_vvp_attachment(id)
446            ERRORE:  il vincolo "pass_attach_attach_fk" per la relazione "r_vvp_pass_attach" esiste già
447[WARNING  ] ALTER TABLE ONLY public.r_vvp_pass_attach
448                ADD CONSTRAINT pass_attach_pass_fk FOREIGN KEY (id_pass) REFERENCES public.t_vvp_pass(id)
449            ERRORE:  il vincolo "pass_attach_pass_fk" per la relazione "r_vvp_pass_attach" esiste già
450[WARNING  ] ALTER TABLE ONLY public.r_vvp_pass_user
451                ADD CONSTRAINT pass_user_pass_fk_2 FOREIGN KEY (id_pass) REFERENCES public.t_vvp_pass(id)
452            ERRORE:  il vincolo "pass_user_pass_fk_2" per la relazione "r_vvp_pass_user" esiste già
453[WARNING  ] ALTER TABLE ONLY public.r_vvp_pass_user
454                ADD CONSTRAINT pass_user_user_fk FOREIGN KEY (id_user) REFERENCES public.t_vvp_user(id)
455            ERRORE:  il vincolo "pass_user_user_fk" per la relazione "r_vvp_pass_user" esiste già
456[WARNING  ] ALTER TABLE ONLY public.r_vvp_pass_ztlpass
457                ADD CONSTRAINT pass_ztlpass_pass FOREIGN KEY (id_pass) REFERENCES public.t_vvp_pass(id)
458            ERRORE:  il vincolo "pass_ztlpass_pass" per la relazione "r_vvp_pass_ztlpass" esiste già
459[WARNING  ] ALTER TABLE ONLY public.r_vvp_pass_ztlpass
460                ADD CONSTRAINT pass_ztlpass_ztlpass_fk FOREIGN KEY (id_ztlpass) REFERENCES public.t_vvp_ztl_pass(id)
461            ERRORE:  il vincolo "pass_ztlpass_ztlpass_fk" per la relazione "r_vvp_pass_ztlpass" esiste già
462[WARNING  ] ALTER TABLE ONLY public.t_vvp_province
463                ADD CONSTRAINT province_regioni_fk FOREIGN KEY (id_regione) REFERENCES public.t_vvp_regioni(id_regione)
464            ERRORE:  il vincolo "province_regioni_fk" per la relazione "t_vvp_province" esiste già
465[WARNING  ] ALTER TABLE ONLY public.r_vvp_user_attach
466                ADD CONSTRAINT user_attach_attach FOREIGN KEY (id_attach) REFERENCES public.t_vvp_attachment(id)
467            ERRORE:  il vincolo "user_attach_attach" per la relazione "r_vvp_user_attach" esiste già
468[WARNING  ] ALTER TABLE ONLY public.r_vvp_user_attach
469                ADD CONSTRAINT user_attach_user FOREIGN KEY (id_user) REFERENCES public.t_vvp_user(id)
470            ERRORE:  il vincolo "user_attach_user" per la relazione "r_vvp_user_attach" esiste già
471[WARNING  ] ALTER TABLE ONLY public.t_vvp_ztl_pass_registry_log
472                ADD CONSTRAINT ztl_pass_reg_log_ztlpass_fk FOREIGN KEY (id_ztl_pass) REFERENCES public.t_vvp_ztl_pass(id)
473            ERRORE:  il vincolo "ztl_pass_reg_log_ztlpass_fk" per la relazione "t_vvp_ztl_pass_registry_log" esiste già
474[QUERY    ] REVOKE ALL ON SCHEMA public FROM PUBLIC
475[QUERY    ] REVOKE ALL ON SCHEMA public FROM postgres
476[QUERY    ] GRANT ALL ON SCHEMA public TO postgres
477[QUERY    ] GRANT ALL ON SCHEMA public TO PUBLIC