From a9f11abff1469d881aa65dd4e022e10b7359d544 Mon Sep 17 00:00:00 2001 From: Andrea Zagli Date: Tue, 19 Oct 2010 11:53:24 +0200 Subject: [PATCH] File mancante al commit precedente. --- docs/organigramma.sql | 195 +++++++++++++++++++++--------------------- 1 file changed, 99 insertions(+), 96 deletions(-) diff --git a/docs/organigramma.sql b/docs/organigramma.sql index 08ad05c..60a45ff 100644 --- a/docs/organigramma.sql +++ b/docs/organigramma.sql @@ -4,7 +4,7 @@ -- Dumped from database version 8.4.4 -- Dumped by pg_dump version 9.0.1 --- Started on 2010-10-19 11:13:24 +-- Started on 2010-10-19 11:52:58 SET statement_timeout = 0; SET client_encoding = 'UTF8'; @@ -14,7 +14,7 @@ SET client_min_messages = warning; SET escape_string_warning = off; -- --- TOC entry 362 (class 2612 OID 16386) +-- TOC entry 363 (class 2612 OID 16386) -- Name: plpgsql; Type: PROCEDURAL LANGUAGE; Schema: -; Owner: - -- @@ -26,8 +26,8 @@ SET search_path = public, pg_catalog; SET default_with_oids = false; -- --- TOC entry 1549 (class 1259 OID 59279) --- Dependencies: 1849 1850 1851 3 +-- TOC entry 1550 (class 1259 OID 59279) +-- Dependencies: 1850 1851 1852 3 -- Name: nodi; Type: TABLE; Schema: public; Owner: - -- @@ -42,8 +42,8 @@ CREATE TABLE nodi ( -- --- TOC entry 1570 (class 1259 OID 61344) --- Dependencies: 1921 1922 1923 1924 1925 1926 1927 1928 1929 3 +-- TOC entry 1571 (class 1259 OID 61344) +-- Dependencies: 1924 1925 1926 1927 1928 1929 1930 1931 1932 3 -- Name: persona_incarichi; Type: TABLE; Schema: public; Owner: - -- @@ -64,8 +64,8 @@ CREATE TABLE persona_incarichi ( -- --- TOC entry 1565 (class 1259 OID 61295) --- Dependencies: 1904 1905 1906 1907 3 +-- TOC entry 1566 (class 1259 OID 61295) +-- Dependencies: 1907 1908 1909 1910 3 -- Name: persona_nodi; Type: TABLE; Schema: public; Owner: - -- @@ -81,8 +81,8 @@ CREATE TABLE persona_nodi ( -- --- TOC entry 1566 (class 1259 OID 61307) --- Dependencies: 1908 1909 1910 1911 1912 1913 1914 3 +-- TOC entry 1567 (class 1259 OID 61307) +-- Dependencies: 1911 1912 1913 1914 1915 1916 1917 3 -- Name: persona_nodo_recapiti; Type: TABLE; Schema: public; Owner: - -- @@ -99,8 +99,8 @@ CREATE TABLE persona_nodo_recapiti ( -- --- TOC entry 1563 (class 1259 OID 61266) --- Dependencies: 1891 1892 1893 1894 1895 1896 3 +-- TOC entry 1564 (class 1259 OID 61266) +-- Dependencies: 1894 1895 1896 1897 1898 1899 3 -- Name: persona_recapiti; Type: TABLE; Schema: public; Owner: - -- @@ -116,8 +116,8 @@ CREATE TABLE persona_recapiti ( -- --- TOC entry 1562 (class 1259 OID 61243) --- Dependencies: 1889 1890 3 +-- TOC entry 1563 (class 1259 OID 61243) +-- Dependencies: 1890 1891 1892 1893 3 -- Name: persona_uffici; Type: TABLE; Schema: public; Owner: - -- @@ -128,13 +128,15 @@ CREATE TABLE persona_uffici ( da_data date, a_data date, note text DEFAULT ''::text, - status character varying(1) DEFAULT ''::character varying + status character varying(1) DEFAULT ''::character varying, + piano character varying(10) DEFAULT ''::character varying, + stanza character varying(10) DEFAULT ''::character varying ); -- --- TOC entry 1564 (class 1259 OID 61280) --- Dependencies: 1897 1898 1899 1900 1901 1902 1903 3 +-- TOC entry 1565 (class 1259 OID 61280) +-- Dependencies: 1900 1901 1902 1903 1904 1905 1906 3 -- Name: persona_ufficio_recapiti; Type: TABLE; Schema: public; Owner: - -- @@ -151,8 +153,8 @@ CREATE TABLE persona_ufficio_recapiti ( -- --- TOC entry 1560 (class 1259 OID 61227) --- Dependencies: 1878 1879 1880 1881 1882 1883 1884 1885 1886 3 +-- TOC entry 1561 (class 1259 OID 61227) +-- Dependencies: 1879 1880 1881 1882 1883 1884 1885 1886 1887 3 -- Name: persone; Type: TABLE; Schema: public; Owner: - -- @@ -172,8 +174,8 @@ CREATE TABLE persone ( -- --- TOC entry 1567 (class 1259 OID 61322) --- Dependencies: 1915 1916 3 +-- TOC entry 1568 (class 1259 OID 61322) +-- Dependencies: 1918 1919 3 -- Name: posizioni_economiche; Type: TABLE; Schema: public; Owner: - -- @@ -185,8 +187,8 @@ CREATE TABLE posizioni_economiche ( -- --- TOC entry 1569 (class 1259 OID 61336) --- Dependencies: 1919 1920 3 +-- TOC entry 1570 (class 1259 OID 61336) +-- Dependencies: 1922 1923 3 -- Name: profili_professionali; Type: TABLE; Schema: public; Owner: - -- @@ -198,8 +200,8 @@ CREATE TABLE profili_professionali ( -- --- TOC entry 1555 (class 1259 OID 59346) --- Dependencies: 1865 1866 1867 3 +-- TOC entry 1556 (class 1259 OID 59346) +-- Dependencies: 1866 1867 1868 3 -- Name: struttura_indirizzi; Type: TABLE; Schema: public; Owner: - -- @@ -214,8 +216,8 @@ CREATE TABLE struttura_indirizzi ( -- --- TOC entry 1553 (class 1259 OID 59327) --- Dependencies: 1859 1860 1861 1862 1863 3 +-- TOC entry 1554 (class 1259 OID 59327) +-- Dependencies: 1860 1861 1862 1863 1864 3 -- Name: strutture; Type: TABLE; Schema: public; Owner: - -- @@ -230,8 +232,8 @@ CREATE TABLE strutture ( -- --- TOC entry 1550 (class 1259 OID 59290) --- Dependencies: 1852 1853 3 +-- TOC entry 1551 (class 1259 OID 59290) +-- Dependencies: 1853 1854 3 -- Name: tipi_nodo; Type: TABLE; Schema: public; Owner: - -- @@ -243,8 +245,8 @@ CREATE TABLE tipi_nodo ( -- --- TOC entry 1568 (class 1259 OID 61329) --- Dependencies: 1917 1918 3 +-- TOC entry 1569 (class 1259 OID 61329) +-- Dependencies: 1920 1921 3 -- Name: tipi_prestazione; Type: TABLE; Schema: public; Owner: - -- @@ -256,8 +258,8 @@ CREATE TABLE tipi_prestazione ( -- --- TOC entry 1561 (class 1259 OID 61236) --- Dependencies: 1887 1888 3 +-- TOC entry 1562 (class 1259 OID 61236) +-- Dependencies: 1888 1889 3 -- Name: tipi_rapporto_lavoro; Type: TABLE; Schema: public; Owner: - -- @@ -269,8 +271,8 @@ CREATE TABLE tipi_rapporto_lavoro ( -- --- TOC entry 1551 (class 1259 OID 59297) --- Dependencies: 1854 1855 3 +-- TOC entry 1552 (class 1259 OID 59297) +-- Dependencies: 1855 1856 3 -- Name: tipi_recapito; Type: TABLE; Schema: public; Owner: - -- @@ -282,8 +284,8 @@ CREATE TABLE tipi_recapito ( -- --- TOC entry 1559 (class 1259 OID 61219) --- Dependencies: 1875 1876 1877 3 +-- TOC entry 1560 (class 1259 OID 61219) +-- Dependencies: 1876 1877 1878 3 -- Name: titoli; Type: TABLE; Schema: public; Owner: - -- @@ -296,8 +298,8 @@ CREATE TABLE titoli ( -- --- TOC entry 1552 (class 1259 OID 59311) --- Dependencies: 1856 1857 1858 3 +-- TOC entry 1553 (class 1259 OID 59311) +-- Dependencies: 1857 1858 1859 3 -- Name: uffici; Type: TABLE; Schema: public; Owner: - -- @@ -311,8 +313,8 @@ CREATE TABLE uffici ( -- --- TOC entry 1556 (class 1259 OID 59357) --- Dependencies: 1868 1869 3 +-- TOC entry 1557 (class 1259 OID 59357) +-- Dependencies: 1869 1870 3 -- Name: ufficio_nodi; Type: TABLE; Schema: public; Owner: - -- @@ -326,8 +328,8 @@ CREATE TABLE ufficio_nodi ( -- --- TOC entry 1557 (class 1259 OID 59399) --- Dependencies: 1870 1871 3 +-- TOC entry 1558 (class 1259 OID 59399) +-- Dependencies: 1871 1872 3 -- Name: ufficio_orari; Type: TABLE; Schema: public; Owner: - -- @@ -354,8 +356,8 @@ CREATE TABLE ufficio_orari ( -- --- TOC entry 1558 (class 1259 OID 59409) --- Dependencies: 1872 1873 1874 3 +-- TOC entry 1559 (class 1259 OID 59409) +-- Dependencies: 1873 1874 1875 3 -- Name: ufficio_recapiti; Type: TABLE; Schema: public; Owner: - -- @@ -371,8 +373,8 @@ CREATE TABLE ufficio_recapiti ( -- --- TOC entry 1571 (class 1259 OID 61407) --- Dependencies: 1930 1931 1932 1933 1934 3 +-- TOC entry 1572 (class 1259 OID 61417) +-- Dependencies: 1933 1934 1935 1936 1937 1938 3 -- Name: ufficio_stanze; Type: TABLE; Schema: public; Owner: - -- @@ -382,13 +384,14 @@ CREATE TABLE ufficio_stanze ( piano character varying(10) DEFAULT ''::character varying, da_stanza character varying(10) DEFAULT ''::character varying, a_stanza character varying(10) DEFAULT ''::character varying, + note text DEFAULT ''::text, status character varying(1) DEFAULT ''::character varying ); -- --- TOC entry 1554 (class 1259 OID 59340) --- Dependencies: 1864 3 +-- TOC entry 1555 (class 1259 OID 59340) +-- Dependencies: 1865 3 -- Name: vie; Type: TABLE; Schema: public; Owner: - -- @@ -399,8 +402,8 @@ CREATE TABLE vie ( -- --- TOC entry 1936 (class 2606 OID 59289) --- Dependencies: 1549 1549 +-- TOC entry 1940 (class 2606 OID 59289) +-- Dependencies: 1550 1550 -- Name: nodi_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- @@ -409,8 +412,8 @@ ALTER TABLE ONLY nodi -- --- TOC entry 1978 (class 2606 OID 61360) --- Dependencies: 1570 1570 +-- TOC entry 1982 (class 2606 OID 61360) +-- Dependencies: 1571 1571 -- Name: persona_incarichi_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- @@ -419,8 +422,8 @@ ALTER TABLE ONLY persona_incarichi -- --- TOC entry 1968 (class 2606 OID 61305) --- Dependencies: 1565 1565 +-- TOC entry 1972 (class 2606 OID 61305) +-- Dependencies: 1566 1566 -- Name: persona_nodi_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- @@ -429,8 +432,8 @@ ALTER TABLE ONLY persona_nodi -- --- TOC entry 1970 (class 2606 OID 61321) --- Dependencies: 1566 1566 +-- TOC entry 1974 (class 2606 OID 61321) +-- Dependencies: 1567 1567 -- Name: persona_nodo_recapiti_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- @@ -439,8 +442,8 @@ ALTER TABLE ONLY persona_nodo_recapiti -- --- TOC entry 1964 (class 2606 OID 61279) --- Dependencies: 1563 1563 +-- TOC entry 1968 (class 2606 OID 61279) +-- Dependencies: 1564 1564 -- Name: persona_recapiti_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- @@ -449,8 +452,8 @@ ALTER TABLE ONLY persona_recapiti -- --- TOC entry 1962 (class 2606 OID 61252) --- Dependencies: 1562 1562 +-- TOC entry 1966 (class 2606 OID 61252) +-- Dependencies: 1563 1563 -- Name: persona_uffici_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- @@ -459,8 +462,8 @@ ALTER TABLE ONLY persona_uffici -- --- TOC entry 1966 (class 2606 OID 61294) --- Dependencies: 1564 1564 +-- TOC entry 1970 (class 2606 OID 61294) +-- Dependencies: 1565 1565 -- Name: persona_ufficio_recapiti_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- @@ -469,8 +472,8 @@ ALTER TABLE ONLY persona_ufficio_recapiti -- --- TOC entry 1958 (class 2606 OID 61235) --- Dependencies: 1560 1560 +-- TOC entry 1962 (class 2606 OID 61235) +-- Dependencies: 1561 1561 -- Name: persone_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- @@ -479,8 +482,8 @@ ALTER TABLE ONLY persone -- --- TOC entry 1972 (class 2606 OID 61328) --- Dependencies: 1567 1567 +-- TOC entry 1976 (class 2606 OID 61328) +-- Dependencies: 1568 1568 -- Name: posizioni_economiche_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- @@ -489,8 +492,8 @@ ALTER TABLE ONLY posizioni_economiche -- --- TOC entry 1976 (class 2606 OID 61342) --- Dependencies: 1569 1569 +-- TOC entry 1980 (class 2606 OID 61342) +-- Dependencies: 1570 1570 -- Name: profili_professionali_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- @@ -499,8 +502,8 @@ ALTER TABLE ONLY profili_professionali -- --- TOC entry 1948 (class 2606 OID 59356) --- Dependencies: 1555 1555 +-- TOC entry 1952 (class 2606 OID 59356) +-- Dependencies: 1556 1556 -- Name: struttura_indirizzi_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- @@ -509,8 +512,8 @@ ALTER TABLE ONLY struttura_indirizzi -- --- TOC entry 1944 (class 2606 OID 59339) --- Dependencies: 1553 1553 +-- TOC entry 1948 (class 2606 OID 59339) +-- Dependencies: 1554 1554 -- Name: strutture_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- @@ -519,8 +522,8 @@ ALTER TABLE ONLY strutture -- --- TOC entry 1938 (class 2606 OID 59296) --- Dependencies: 1550 1550 +-- TOC entry 1942 (class 2606 OID 59296) +-- Dependencies: 1551 1551 -- Name: tipi_nodo_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- @@ -529,8 +532,8 @@ ALTER TABLE ONLY tipi_nodo -- --- TOC entry 1974 (class 2606 OID 61335) --- Dependencies: 1568 1568 +-- TOC entry 1978 (class 2606 OID 61335) +-- Dependencies: 1569 1569 -- Name: tipi_prestazione_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- @@ -539,8 +542,8 @@ ALTER TABLE ONLY tipi_prestazione -- --- TOC entry 1960 (class 2606 OID 61242) --- Dependencies: 1561 1561 +-- TOC entry 1964 (class 2606 OID 61242) +-- Dependencies: 1562 1562 -- Name: tipi_rapporto_lavoro_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- @@ -549,8 +552,8 @@ ALTER TABLE ONLY tipi_rapporto_lavoro -- --- TOC entry 1940 (class 2606 OID 59303) --- Dependencies: 1551 1551 +-- TOC entry 1944 (class 2606 OID 59303) +-- Dependencies: 1552 1552 -- Name: tipi_recapito_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- @@ -559,8 +562,8 @@ ALTER TABLE ONLY tipi_recapito -- --- TOC entry 1956 (class 2606 OID 61226) --- Dependencies: 1559 1559 +-- TOC entry 1960 (class 2606 OID 61226) +-- Dependencies: 1560 1560 -- Name: titoli_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- @@ -569,8 +572,8 @@ ALTER TABLE ONLY titoli -- --- TOC entry 1942 (class 2606 OID 59321) --- Dependencies: 1552 1552 +-- TOC entry 1946 (class 2606 OID 59321) +-- Dependencies: 1553 1553 -- Name: uffici_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- @@ -579,8 +582,8 @@ ALTER TABLE ONLY uffici -- --- TOC entry 1950 (class 2606 OID 59366) --- Dependencies: 1556 1556 +-- TOC entry 1954 (class 2606 OID 59366) +-- Dependencies: 1557 1557 -- Name: ufficio_nodi_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- @@ -589,8 +592,8 @@ ALTER TABLE ONLY ufficio_nodi -- --- TOC entry 1952 (class 2606 OID 59408) --- Dependencies: 1557 1557 +-- TOC entry 1956 (class 2606 OID 59408) +-- Dependencies: 1558 1558 -- Name: ufficio_orari_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- @@ -599,8 +602,8 @@ ALTER TABLE ONLY ufficio_orari -- --- TOC entry 1954 (class 2606 OID 59419) --- Dependencies: 1558 1558 +-- TOC entry 1958 (class 2606 OID 59419) +-- Dependencies: 1559 1559 -- Name: ufficio_recapiti_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- @@ -609,8 +612,8 @@ ALTER TABLE ONLY ufficio_recapiti -- --- TOC entry 1980 (class 2606 OID 61416) --- Dependencies: 1571 1571 +-- TOC entry 1984 (class 2606 OID 61430) +-- Dependencies: 1572 1572 -- Name: ufficio_stanze_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- @@ -619,8 +622,8 @@ ALTER TABLE ONLY ufficio_stanze -- --- TOC entry 1946 (class 2606 OID 59345) --- Dependencies: 1554 1554 +-- TOC entry 1950 (class 2606 OID 59345) +-- Dependencies: 1555 1555 -- Name: vie_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- @@ -628,7 +631,7 @@ ALTER TABLE ONLY vie ADD CONSTRAINT vie_pkey PRIMARY KEY (id); --- Completed on 2010-10-19 11:13:25 +-- Completed on 2010-10-19 11:52:58 -- -- PostgreSQL database dump complete -- 2.49.0