SET client_encoding = 'UTF8';
SET check_function_bodies = false;
SET client_min_messages = warning;

--
-- TOC entry 1535 (class 0 OID 0)
-- Dependencies: 4
-- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres
--

COMMENT ON SCHEMA public IS 'Standard public schema';


--
-- TOC entry 261 (class 2612 OID 16386)
-- Name: plpgsql; Type: PROCEDURAL LANGUAGE; Schema: -; Owner: 
--

CREATE PROCEDURAL LANGUAGE plpgsql;


SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- TOC entry 1205 (class 1259 OID 241811)
-- Dependencies: 4
-- Name: Barcode; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE "Barcode" (
    "BARCODE" character varying(256),
    "OPERATORE" character varying(50),
    "DATA" timestamp with time zone,
    "RULLINO" integer,
    "CONTATORE" integer
);


ALTER TABLE public."Barcode" OWNER TO postgres;

SET default_with_oids = true;

--
-- TOC entry 1200 (class 1259 OID 213059)
-- Dependencies: 1527 4
-- Name: Eventi; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE "Eventi" (
    "ID" integer DEFAULT nextval(('public."Eventi_ID_seq"'::text)::regclass) NOT NULL,
    "EVENTO" character varying(64)
);


ALTER TABLE public."Eventi" OWNER TO postgres;

--
-- TOC entry 1195 (class 1259 OID 210612)
-- Dependencies: 4
-- Name: Eventi_ID_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE "Eventi_ID_seq"
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public."Eventi_ID_seq" OWNER TO postgres;

--
-- TOC entry 1201 (class 1259 OID 213062)
-- Dependencies: 1528 4
-- Name: Fotografie; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE "Fotografie" (
    "ID" integer DEFAULT nextval(('public."Fotografie_ID_seq"'::text)::regclass) NOT NULL,
    "OPERATORE" character varying(50),
    "DATA" timestamp with time zone,
    "RULLINO" integer,
    "CONTATORE" integer,
    "NOME_FILE" character varying(255),
    "POSIZIONE" integer,
    "FG_IMAGE_NAME" character varying(255),
    "BG_IMAGE_NAME" character varying(255),
    "ICON_IMAGE_NAME" character varying(255),
    "ASPECT_RATIO" real,
    "IMAGEX" integer,
    "IMAGEY" integer,
    "CROPLEFT" integer,
    "CROPTOP" integer,
    "CROPRIGHT" integer,
    "CROPBOTTOM" integer,
    "ZOOM" smallint,
    "ROTATION" smallint,
    "RED" smallint,
    "GREEN" smallint,
    "BLUE" smallint,
    "CONTRAST" smallint,
    "BRIGHTNESS" smallint,
    "SATURATION" smallint,
    "ICONX" integer,
    "ICONY" integer,
    "ICONZOOM" smallint,
    "ICONROTATION" smallint,
    "TEXT" character varying(255),
    "TEXTX" integer,
    "TEXTY" integer,
    "TEXTZOOM" smallint,
    "TEXTROTATION" integer,
    "TEXTALIGN" smallint,
    "TEXTCOLOR" integer,
    "FONTSTYLE" smallint,
    "FONTNAME" character varying(255),
    "EVENTO" character varying(1024),
    "PAGE" character varying(8000)
);


ALTER TABLE public."Fotografie" OWNER TO postgres;

--
-- TOC entry 1196 (class 1259 OID 210620)
-- Dependencies: 4
-- Name: Fotografie_ID_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE "Fotografie_ID_seq"
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public."Fotografie_ID_seq" OWNER TO postgres;

--
-- TOC entry 1202 (class 1259 OID 213068)
-- Dependencies: 1529 4
-- Name: Layout; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE "Layout" (
    "ID" integer DEFAULT nextval(('public."Layout_ID_seq"'::text)::regclass) NOT NULL,
    "FG_IMAGE_NAME" character varying(255),
    "BG_IMAGE_NAME" character varying(255),
    "ICON_IMAGE_NAME" character varying(255),
    "ASPECT_RATIO" real,
    "IMAGEX" integer,
    "IMAGEY" integer,
    "CROPLEFT" integer,
    "CROPTOP" integer,
    "CROPRIGHT" integer,
    "CROPBOTTOM" integer,
    "ZOOM" smallint,
    "ROTATION" smallint,
    "RED" smallint,
    "GREEN" smallint,
    "BLUE" smallint,
    "CONTRAST" smallint,
    "BRIGHTNESS" smallint,
    "SATURATION" smallint,
    "ICONX" integer,
    "ICONY" integer,
    "ICONZOOM" smallint,
    "ICONROTATION" smallint,
    "TEXT" character varying(255),
    "TEXTX" integer,
    "TEXTY" integer,
    "TEXTZOOM" smallint,
    "TEXTROTATION" integer,
    "TEXTALIGN" smallint,
    "TEXTCOLOR" integer,
    "FONTSTYLE" smallint,
    "FONTNAME" character varying(255),
    "PAGE" character varying(8000)
);


ALTER TABLE public."Layout" OWNER TO postgres;

--
-- TOC entry 1197 (class 1259 OID 210628)
-- Dependencies: 4
-- Name: Layout_ID_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE "Layout_ID_seq"
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public."Layout_ID_seq" OWNER TO postgres;

--
-- TOC entry 1203 (class 1259 OID 213074)
-- Dependencies: 1530 4
-- Name: Spooler; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE "Spooler" (
    "ID" integer DEFAULT nextval(('public."Spooler_ID_seq"'::text)::regclass) NOT NULL,
    "STATO" integer,
    "CONTATORE" integer,
    "OPERATORE" character varying(50),
    "RULLINO" integer,
    "DATA" timestamp with time zone,
    "PRIORITA" integer,
    "PRINT_LAYOUT" integer,
    "MIRROR" boolean NOT NULL,
    "FORMATO_CARTA" integer,
    "NUMERO_COPIE" integer,
    "NOME_FILE" character varying(255),
    "FG_IMAGE_NAME" character varying(255),
    "BG_IMAGE_NAME" character varying(255),
    "ICON_IMAGE_NAME" character varying(255),
    "ASPECT_RATIO" real,
    "IMAGEX" integer,
    "IMAGEY" integer,
    "CROPLEFT" integer,
    "CROPTOP" integer,
    "CROPRIGHT" integer,
    "CROPBOTTOM" integer,
    "ZOOM" smallint,
    "ROTATION" smallint,
    "RED" smallint,
    "GREEN" smallint,
    "BLUE" smallint,
    "CONTRAST" smallint,
    "BRIGHTNESS" smallint,
    "SATURATION" smallint,
    "ICONX" integer,
    "ICONY" integer,
    "ICONZOOM" smallint,
    "ICONROTATION" smallint,
    "TEXT" character varying(254),
    "TEXTX" integer,
    "TEXTY" integer,
    "TEXTZOOM" smallint,
    "TEXTROTATION" integer,
    "TEXTALIGN" smallint,
    "TEXTCOLOR" integer,
    "FONTSTYLE" smallint,
    "FONTNAME" character varying(255),
    "SPOOLERID" integer,
    "PAGE" character varying(8000),
    "PRODOTTO" character varying(256)
);


ALTER TABLE public."Spooler" OWNER TO postgres;

--
-- TOC entry 1198 (class 1259 OID 210636)
-- Dependencies: 4
-- Name: Spooler_ID_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE "Spooler_ID_seq"
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public."Spooler_ID_seq" OWNER TO postgres;

--
-- TOC entry 1204 (class 1259 OID 213080)
-- Dependencies: 1531 4
-- Name: Story; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE "Story" (
    "ID" integer DEFAULT nextval(('public."Story_ID_seq"'::text)::regclass) NOT NULL,
    "OPERATORE" character varying(50),
    "DATA" timestamp with time zone,
    "IMPORTATE" integer,
    "STAMPATE" integer,
    "FORMATO_CARTA" integer,
    "PRODOTTO" character varying(256)
);


ALTER TABLE public."Story" OWNER TO postgres;

--
-- TOC entry 1199 (class 1259 OID 210641)
-- Dependencies: 4
-- Name: Story_ID_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE "Story_ID_seq"
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public."Story_ID_seq" OWNER TO postgres;

--
-- TOC entry 1532 (class 1259 OID 241819)
-- Dependencies: 1205
-- Name: Barcode_Idx; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE INDEX "Barcode_Idx" ON "Barcode" USING btree ("BARCODE");


--
-- TOC entry 1536 (class 0 OID 0)
-- Dependencies: 4
-- Name: public; Type: ACL; Schema: -; Owner: postgres
--

REVOKE ALL ON SCHEMA public FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM postgres;
GRANT ALL ON SCHEMA public TO postgres;
GRANT ALL ON SCHEMA public TO PUBLIC;


-- Completed on 2007-07-06 19:07:07 ora solare Europa occidentale

--
-- PostgreSQL database dump complete
--