-- -- PostgreSQL database dump -- SET client_encoding = 'UNICODE'; SET check_function_bodies = false; SET SESSION AUTHORIZATION 'postgres'; -- -- TOC entry 4 (OID 2200) -- Name: public; Type: ACL; Schema: -; Owner: postgres -- REVOKE ALL ON SCHEMA public FROM PUBLIC; GRANT ALL ON SCHEMA public TO PUBLIC; SET SESSION AUTHORIZATION 'cristian'; SET search_path = public, pg_catalog; -- -- TOC entry 5 (OID 25531) -- Name: festivita; Type: TABLE; Schema: public; Owner: cristian -- CREATE TABLE festivita ( data date, tipo character varying(10) ); -- -- TOC entry 6 (OID 25533) -- Name: db; Type: TABLE; Schema: public; Owner: cristian -- CREATE TABLE db ( codice character varying(10), prodotto character varying(2), fase integer, unita_misura character varying(4), quantita integer ); -- -- TOC entry 7 (OID 25535) -- Name: articoli; Type: TABLE; Schema: public; Owner: cristian -- CREATE TABLE articoli ( codice character varying(10), descrizione character varying(50), testo_articolo text, tipo character varying(3), prodotto character varying(2), unita_misura character varying(4), lotto_min real, lotto_acq real, punto_riordino real, punto_massimo real, cod_fornitore real, disegno text, categoria_merceologica character varying(10), classe_merceologica character varying(4), link_disegno text, lead_time double precision DEFAULT 0, cicle_time bigint DEFAULT 0 ); -- -- TOC entry 8 (OID 25542) -- Name: unita_misura; Type: TABLE; Schema: public; Owner: cristian -- CREATE TABLE unita_misura ( codice character varying(4) NOT NULL, descrizione character varying(50) NOT NULL, testo_um text ); -- -- TOC entry 9 (OID 25547) -- Name: lista_pezzi; Type: TABLE; Schema: public; Owner: cristian -- CREATE TABLE lista_pezzi ( articolo_padre character varying(10), articolo_figlio character varying(10), qta_figlio real, magazzino character varying(15), sospeso boolean ); -- -- TOC entry 10 (OID 25551) -- Name: richieste_produzione; Type: TABLE; Schema: public; Owner: cristian -- CREATE TABLE richieste_produzione ( id_rdp bigserial NOT NULL, cod_ric_prod character varying(10), qta_ric_prod double precision NOT NULL, cons_ric_prod date, wbs text, stato_rdp character varying(10) ); -- -- TOC entry 11 (OID 25559) -- Name: impegni; Type: TABLE; Schema: public; Owner: cristian -- CREATE TABLE impegni ( id_impegni bigserial NOT NULL, art_impegni character varying(15) NOT NULL, qta_mov_impegni integer NOT NULL, data_mov_impegni date NOT NULL, tipo_mov_impegni character(10), progetto_impegni character varying(15), magazino_impegni character varying, tipo_art_impegni character varying(3) ); -- -- TOC entry 12 (OID 25564) -- Name: prova; Type: TABLE; Schema: public; Owner: cristian -- CREATE TABLE prova ( id_prova bigserial NOT NULL, nome character(12) ); -- -- TOC entry 13 (OID 25569) -- Name: ordini_produzione; Type: TABLE; Schema: public; Owner: cristian -- CREATE TABLE ordini_produzione ( id_odp bigserial NOT NULL, articolo_odp character varying(15), consegna_odp date, qta_odp numeric, stato_odp character varying(15), progetto_odp character varying(15), magazzino_odp character varying(15) ); -- -- TOC entry 14 (OID 33815) -- Name: richieste_acquisto; Type: TABLE; Schema: public; Owner: cristian -- CREATE TABLE richieste_acquisto ( id_rda bigserial NOT NULL, articolo_rda character varying(15), consegna_rda date, qta_rda numeric, stato_rda character varying(15), progetto_rda character varying(15), magazzino_rda character varying(15), mov_rda character varying(12), tipo_art_rda character varying(3) ); -- -- TOC entry 15 (OID 33823) -- Name: ordine_acquisto; Type: TABLE; Schema: public; Owner: cristian -- CREATE TABLE ordine_acquisto ( id_oda bigserial NOT NULL, item_oda numeric, articolo_oda character varying(15), consegna_oda date, qta_oda numeric, stato_oda character varying(15), progetto_oda character varying(15), magazzino_oda character varying(15), mov_oda character varying(12), tipo_art_oda character varying(3), codice_fornitore character varying(50) ); -- -- TOC entry 16 (OID 33847) -- Name: cont_imp_odp; Type: VIEW; Schema: public; Owner: cristian -- CREATE VIEW cont_imp_odp AS SELECT id_impegni, art_impegni, qta_mov_impegni, data_mov_impegni, tipo_mov_impegni, progetto_impegni, magazino_impegni, tipo_art_impegni, id_odp, articolo_odp, consegna_odp, qta_odp, stato_odp, progetto_odp, magazzino_odp FROM (impegni LEFT JOIN ordini_produzione ON ((((impegni.progetto_impegni)::text = (ordini_produzione.progetto_odp)::text) AND ((impegni.art_impegni)::text = (ordini_produzione.articolo_odp)::text)))); -- -- TOC entry 17 (OID 33852) -- Name: contr_imp_rda_oda; Type: VIEW; Schema: public; Owner: cristian -- CREATE VIEW contr_imp_rda_oda AS (SELECT impegni.art_impegni, impegni.qta_mov_impegni, impegni.data_mov_impegni, impegni.tipo_mov_impegni FROM impegni UNION SELECT richieste_acquisto.articolo_rda AS art_impegni, richieste_acquisto.qta_rda AS qta_mov_impegni, richieste_acquisto.consegna_rda AS data_mov_impegni, richieste_acquisto.mov_rda AS tipo_mov_impegni FROM richieste_acquisto) UNION SELECT ordine_acquisto.articolo_oda AS art_impegni, ordine_acquisto.qta_oda AS qta_mov_impegni, ordine_acquisto.consegna_oda AS data_mov_impegni, ordine_acquisto.mov_oda AS tipo_mov_impegni FROM ordine_acquisto; -- -- TOC entry 18 (OID 33879) -- Name: con_imp_rda_oda; Type: VIEW; Schema: public; Owner: cristian -- CREATE VIEW con_imp_rda_oda AS (SELECT impegni.art_impegni, impegni.qta_mov_impegni, impegni.data_mov_impegni, impegni.tipo_mov_impegni, impegni.tipo_art_impegni FROM impegni UNION SELECT richieste_acquisto.articolo_rda AS art_impegni, richieste_acquisto.qta_rda AS qta_mov_impegni, richieste_acquisto.consegna_rda AS data_mov_impegni, richieste_acquisto.mov_rda AS tipo_mov_impegni, richieste_acquisto.tipo_art_rda AS tipo_art_impegni FROM richieste_acquisto) UNION SELECT ordine_acquisto.articolo_oda AS art_impegni, ordine_acquisto.qta_oda AS qta_mov_impegni, ordine_acquisto.consegna_oda AS data_mov_impegni, ordine_acquisto.mov_oda AS tipo_mov_impegni, ordine_acquisto.tipo_art_oda AS tipo_art_impegni FROM ordine_acquisto; -- -- TOC entry 19 (OID 33910) -- Name: framework; Type: TABLE; Schema: public; Owner: cristian -- CREATE TABLE framework ( nome_vista character varying, tipo character varying, campi character varying, etichette character varying, proprieta character varying, comando character varying ); -- -- TOC entry 20 (OID 33965) -- Name: auth; Type: TABLE; Schema: public; Owner: cristian -- CREATE TABLE auth ( username text NOT NULL, "password" text NOT NULL, lastlogin time without time zone, errorlogin integer DEFAULT 0 ); SET SESSION AUTHORIZATION 'postgres'; -- -- TOC entry 21 (OID 33983) -- Name: posizioni_oda; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE posizioni_oda ( id_pos bigserial NOT NULL, item_pos_oda bigint, articolo character varying(15) NOT NULL, quantita bigint, prezzo bigint, sconto smallint, iva smallint, numero_oda bigint ); -- -- TOC entry 22 (OID 34000) -- Name: fornitori; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE fornitori ( id_fornitori bigserial NOT NULL, codice_fornitore character varying(15) NOT NULL, indirizzo_fornitore character varying(100), citta_fornitore character varying(100), cap_fornitore character varying(7), pi_fornitore character varying(20), tipo_pagamento character varying(60), dilazione integer, banca_fornitore character varying(100), cc_fornitore character varying(50), iban character varying(50), nazione_fornitore character varying(4), nome_fornitore character varying(90) ); -- -- TOC entry 23 (OID 34008) -- Name: clienti; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE clienti ( id_cliente bigserial NOT NULL, codice_cliente character varying(15) NOT NULL, indirizzo_cliente character varying(100), citta_cliente character varying(100), cap_cliente character varying(7), pi_cliente character varying(20), tipo_pagamento character varying(60), dilazione integer, banca_cliente character varying(100), cc_cliente character varying(50), iban character varying(50), nazione_cliente character varying(4), nome_cliente character varying(90) ); -- -- TOC entry 24 (OID 34016) -- Name: movimenti_magazino; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE movimenti_magazino ( id_movmage bigserial NOT NULL, magazino character varying(8), tipo_operazione character varying(10), q_ta_movmage double precision, prezzo_movmage double precision, iva_mov_mage double precision, numero_oda bigint, pos_oda bigint, articolo_movmage character varying(15) ); SET SESSION AUTHORIZATION 'cristian'; -- -- TOC entry 25 (OID 34023) -- Name: ordine_vendita; Type: TABLE; Schema: public; Owner: cristian -- CREATE TABLE ordine_vendita ( id_odv bigserial NOT NULL, cod_cliente_odv character varying(15), data_consegna_odv date ); SET SESSION AUTHORIZATION 'postgres'; -- -- TOC entry 26 (OID 34031) -- Name: posizioni_odv; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE posizioni_odv ( id_pos_odv bigserial NOT NULL, item_pos_odv bigint, articolo_odv character varying(15) NOT NULL, codice_cliente_odv character varying(15), quantita_odv bigint, prezzo_odv bigint, sconto_odv smallint, iva_odv smallint, numero_odv bigint ); -- -- TOC entry 27 (OID 34054) -- Name: vis_oda_pos; Type: VIEW; Schema: public; Owner: postgres -- CREATE VIEW vis_oda_pos AS SELECT id_pos, id_oda, codice_fornitore, item_pos_oda, articolo, quantita, prezzo, sconto, iva FROM (ordine_acquisto LEFT JOIN posizioni_oda ON ((ordine_acquisto.id_oda = posizioni_oda.numero_oda))); SET SESSION AUTHORIZATION 'cristian'; -- -- Data for TOC entry 44 (OID 25531) -- Name: festivita; Type: TABLE DATA; Schema: public; Owner: cristian -- COPY festivita (data, tipo) FROM stdin; 2005-12-25 natale 2005-08-15 ferragosto \. -- -- Data for TOC entry 45 (OID 25533) -- Name: db; Type: TABLE DATA; Schema: public; Owner: cristian -- COPY db (codice, prodotto, fase, unita_misura, quantita) FROM stdin; \. -- -- Data for TOC entry 46 (OID 25535) -- Name: articoli; Type: TABLE DATA; Schema: public; Owner: cristian -- COPY articoli (codice, descrizione, testo_articolo, tipo, prodotto, unita_misura, lotto_min, lotto_acq, punto_riordino, punto_massimo, cod_fornitore, disegno, categoria_merceologica, classe_merceologica, link_disegno, lead_time, cicle_time) FROM stdin; V0001 pc server 001 prova di un prodotto finito ven \N N 0 0 0 9999 \N dx 0001 \N \N \N 7 24 P0002 scheda madre completa scheda madre + ram + dual cpu pro \N N 0 0 0 9999 \N dx 0003 \N \N \N 14 36 A0002 alimentatore ATX 400 W alimentatore ATX 400 w acq \N N 0 0 0 9999 \N dx 0005 \N \N \N 14 \N A0003 cassetti hd casetti hd acq \N N 0 0 0 9999 \N \N \N \N \N 14 0 A0004 cpu amb 64 bit 3200 mhz cpu amb 64 bit 3200 mhz acq \N N 0 0 0 9999 \N \N \N \N \N 21 0 A0005 mb linux + dual cpu dual eth gb mb per server acq \N N 0 0 0 9999 \N \N \N \N \N 7 0 A0006 scheda raid sata scheda raid sata acq \N N 0 0 0 9999 \N \N \N \N \N 14 0 A0007 hd 250 gb sata hd 250 gb sata acq \N N 0 0 0 9999 \N \N \N \N \N 14 0 A0008 dvd rw+- dual layer dvd rw+- dual layer acq \N N 0 0 0 9999 \N \N \N \N \N 7 0 A0009 ventola raffredamento case ventola raffredamento case acq \N N 0 0 0 9999 \N \N \N \N \N 7 0 P0001 case MB e cassetti case + scheda madre completa + alimentatore + cassetti hd pro \N N 0 0 0 9999 \N dx 0002 \N \N \N 7 \N A0001 case server case server grigio acq \N N 0 0 0 9999 \N dx 0004 \N \N \N 14 \N P0003 scheda madre ram cpu scheda madre + cpu + ram pro \N N 0 0 0 9999 \N \N \N \N \N 1 0 A0010 RAM 512 DDR RAM 512 DDR acq \N N 0 0 0 9999 \N \N \N \N \N 21 0 \. -- -- Data for TOC entry 47 (OID 25542) -- Name: unita_misura; Type: TABLE DATA; Schema: public; Owner: cristian -- COPY unita_misura (codice, descrizione, testo_um) FROM stdin; m Metri per articoli quantificati in Metri kg Kilogrammi per articoli con il peso in kg n Numero per articoli quantificati in quantita' l Litri per articoli con quantità in litri \. -- -- Data for TOC entry 48 (OID 25547) -- Name: lista_pezzi; Type: TABLE DATA; Schema: public; Owner: cristian -- COPY lista_pezzi (articolo_padre, articolo_figlio, qta_figlio, magazzino, sospeso) FROM stdin; V0001 P0002 1 M1 f P0002 P0003 1 M1 f V0001 P0001 1 M1 f V0001 A0007 4 M1 f V0001 A0008 1 M1 f V0001 A0009 2 M1 f P0001 A0001 1 M1 f P0001 A0002 2 M1 f P0001 A0003 4 M1 f P0002 A0006 2 M1 f P0003 A0004 2 M1 f P0003 A0005 1 M1 f P0003 A00010 4 M1 f \. -- -- Data for TOC entry 49 (OID 25551) -- Name: richieste_produzione; Type: TABLE DATA; Schema: public; Owner: cristian -- COPY richieste_produzione (id_rdp, cod_ric_prod, qta_ric_prod, cons_ric_prod, wbs, stato_rdp) FROM stdin; 1 V0001 5 2005-12-31 PR0001 trattenuto \. -- -- Data for TOC entry 50 (OID 25559) -- Name: impegni; Type: TABLE DATA; Schema: public; Owner: cristian -- COPY impegni (id_impegni, art_impegni, qta_mov_impegni, data_mov_impegni, tipo_mov_impegni, progetto_impegni, magazino_impegni, tipo_art_impegni) FROM stdin; 116 P0002 -5 2005-12-24 prelievo PR0001 M1 pro 118 A0008 -5 2005-12-24 prelievo PR0001 M1 acq 119 A0009 -10 2005-12-24 prelievo PR0001 M1 acq 120 P0001 -5 2005-12-24 prelievo PR0001 M1 pro 121 A0006 -10 2005-12-10 prelievo PR0001 M1 acq 122 P0003 -5 2005-12-10 prelievo PR0001 M1 pro 123 A0002 -10 2005-12-17 prelievo PR0001 M1 acq 124 A0003 -20 2005-12-17 prelievo PR0001 M1 acq 125 A0001 -5 2005-12-17 prelievo PR0001 M1 acq 126 A0004 -10 2005-12-09 prelievo PR0001 M1 acq 127 A0005 -5 2005-12-09 prelievo PR0001 M1 acq 117 A0007 -20 2005-12-24 prelievo PR0001 M1 acq \. -- -- Data for TOC entry 51 (OID 25564) -- Name: prova; Type: TABLE DATA; Schema: public; Owner: cristian -- COPY prova (id_prova, nome) FROM stdin; 1 prova 2 pippo \. -- -- Data for TOC entry 52 (OID 25569) -- Name: ordini_produzione; Type: TABLE DATA; Schema: public; Owner: cristian -- COPY ordini_produzione (id_odp, articolo_odp, consegna_odp, qta_odp, stato_odp, progetto_odp, magazzino_odp) FROM stdin; 1 V0001 2005-12-10 5 pianificato PR001 M1 2 P0001 2005-11-12 10 pianificato PR0001 M1 \. -- -- Data for TOC entry 53 (OID 33815) -- Name: richieste_acquisto; Type: TABLE DATA; Schema: public; Owner: cristian -- COPY richieste_acquisto (id_rda, articolo_rda, consegna_rda, qta_rda, stato_rda, progetto_rda, magazzino_rda, mov_rda, tipo_art_rda) FROM stdin; 1 A0008 2005-12-24 4 stampato \N M1 richiesto acq \. -- -- Data for TOC entry 54 (OID 33823) -- Name: ordine_acquisto; Type: TABLE DATA; Schema: public; Owner: cristian -- COPY ordine_acquisto (id_oda, item_oda, articolo_oda, consegna_oda, qta_oda, stato_oda, progetto_oda, magazzino_oda, mov_oda, tipo_art_oda, codice_fornitore) FROM stdin; 6 \N \N \N \N 1 \N \N \N \N F00001 \. -- -- Data for TOC entry 55 (OID 33910) -- Name: framework; Type: TABLE DATA; Schema: public; Owner: cristian -- COPY framework (nome_vista, tipo, campi, etichette, proprieta, comando) FROM stdin; leggi_rdp scheda id_rdp, cod_ric_prod, qta_ric_prod, cons_ric_prod, wbs, stato_rdp id, codice, quantita, consegna, wbs, stato entry.0.10, entry.1.15, entry.1.15, entry1.15, entry1,15 pippo \. -- -- Data for TOC entry 56 (OID 33965) -- Name: auth; Type: TABLE DATA; Schema: public; Owner: cristian -- COPY auth (username, "password", lastlogin, errorlogin) FROM stdin; \N 0 cristian segreta \N 0 aldo 123 \N 0 \. SET SESSION AUTHORIZATION 'postgres'; -- -- Data for TOC entry 57 (OID 33983) -- Name: posizioni_oda; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY posizioni_oda (id_pos, item_pos_oda, articolo, quantita, prezzo, sconto, iva, numero_oda) FROM stdin; 7 1 V0001 5 15 3 29 6 9 2 V0002 5 20 3 20 6 \. -- -- Data for TOC entry 58 (OID 34000) -- Name: fornitori; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY fornitori (id_fornitori, codice_fornitore, indirizzo_fornitore, citta_fornitore, cap_fornitore, pi_fornitore, tipo_pagamento, dilazione, banca_fornitore, cc_fornitore, iban, nazione_fornitore, nome_fornitore) FROM stdin; 1 F00001 Via Fratelli Fontana Monselice 35043 2222222 \N \N \N \N \N IT Greg \. -- -- Data for TOC entry 59 (OID 34008) -- Name: clienti; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY clienti (id_cliente, codice_cliente, indirizzo_cliente, citta_cliente, cap_cliente, pi_cliente, tipo_pagamento, dilazione, banca_cliente, cc_cliente, iban, nazione_cliente, nome_cliente) FROM stdin; 1 C0001 Via che ne so San Fidenzio (PD) 35070 2222222 \N \N \N \N \N IT Aldo Computers \. -- -- Data for TOC entry 60 (OID 34016) -- Name: movimenti_magazino; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY movimenti_magazino (id_movmage, magazino, tipo_operazione, q_ta_movmage, prezzo_movmage, iva_mov_mage, numero_oda, pos_oda, articolo_movmage) FROM stdin; \. SET SESSION AUTHORIZATION 'cristian'; -- -- Data for TOC entry 61 (OID 34023) -- Name: ordine_vendita; Type: TABLE DATA; Schema: public; Owner: cristian -- COPY ordine_vendita (id_odv, cod_cliente_odv, data_consegna_odv) FROM stdin; \. SET SESSION AUTHORIZATION 'postgres'; -- -- Data for TOC entry 62 (OID 34031) -- Name: posizioni_odv; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY posizioni_odv (id_pos_odv, item_pos_odv, articolo_odv, codice_cliente_odv, quantita_odv, prezzo_odv, sconto_odv, iva_odv, numero_odv) FROM stdin; \. SET SESSION AUTHORIZATION 'cristian'; -- -- TOC entry 40 (OID 25616) -- Name: unita_misura_pkey; Type: CONSTRAINT; Schema: public; Owner: cristian -- ALTER TABLE ONLY unita_misura ADD CONSTRAINT unita_misura_pkey PRIMARY KEY (codice); -- -- TOC entry 41 (OID 33971) -- Name: auth_pkey; Type: CONSTRAINT; Schema: public; Owner: cristian -- ALTER TABLE ONLY auth ADD CONSTRAINT auth_pkey PRIMARY KEY (username); SET SESSION AUTHORIZATION 'postgres'; -- -- TOC entry 42 (OID 34003) -- Name: fornitori_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY fornitori ADD CONSTRAINT fornitori_pkey PRIMARY KEY (codice_fornitore); -- -- TOC entry 43 (OID 34011) -- Name: clienti_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY clienti ADD CONSTRAINT clienti_pkey PRIMARY KEY (codice_cliente); SET SESSION AUTHORIZATION 'cristian'; -- -- TOC entry 28 (OID 25549) -- Name: richieste_produzione_id_rdp_seq; Type: SEQUENCE SET; Schema: public; Owner: cristian -- SELECT pg_catalog.setval('richieste_produzione_id_rdp_seq', 2, true); -- -- TOC entry 29 (OID 25557) -- Name: disponibilita_id_disponibilità_seq; Type: SEQUENCE SET; Schema: public; Owner: cristian -- SELECT pg_catalog.setval('"disponibilita_id_disponibilità_seq"', 127, true); -- -- TOC entry 30 (OID 25562) -- Name: prova_id_prova_seq; Type: SEQUENCE SET; Schema: public; Owner: cristian -- SELECT pg_catalog.setval('prova_id_prova_seq', 2, true); -- -- TOC entry 31 (OID 25567) -- Name: ordini_produzione_id_odp_seq; Type: SEQUENCE SET; Schema: public; Owner: cristian -- SELECT pg_catalog.setval('ordini_produzione_id_odp_seq', 2, true); -- -- TOC entry 32 (OID 33813) -- Name: richieste_acquisto_id_rdp_seq; Type: SEQUENCE SET; Schema: public; Owner: cristian -- SELECT pg_catalog.setval('richieste_acquisto_id_rdp_seq', 1, true); -- -- TOC entry 33 (OID 33821) -- Name: ordine_acquisto_id_odp_seq; Type: SEQUENCE SET; Schema: public; Owner: cristian -- SELECT pg_catalog.setval('ordine_acquisto_id_odp_seq', 6, true); SET SESSION AUTHORIZATION 'postgres'; -- -- TOC entry 34 (OID 33981) -- Name: posizioni_oda_id_pos_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('posizioni_oda_id_pos_seq', 10, true); -- -- TOC entry 35 (OID 33998) -- Name: fornitori_id_fornitori_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('fornitori_id_fornitori_seq', 1, true); -- -- TOC entry 36 (OID 34006) -- Name: clienti_id_cliente_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('clienti_id_cliente_seq', 1, true); -- -- TOC entry 37 (OID 34014) -- Name: movimenti_magazino_id_movmage_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('movimenti_magazino_id_movmage_seq', 5, true); -- -- TOC entry 38 (OID 34021) -- Name: ordine_vendita_id_odv_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('ordine_vendita_id_odv_seq', 1, false); -- -- TOC entry 39 (OID 34029) -- Name: posizioni_odv_id_pos_odv_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('posizioni_odv_id_pos_odv_seq', 1, false); -- -- TOC entry 3 (OID 2200) -- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres -- COMMENT ON SCHEMA public IS 'Standard public schema';