c354r1t0

--
-- PostgreSQL database dump
--

SET client_encoding = 'UTF8';
SET standard_conforming_strings = off;
SET check_function_bodies = FALSE;
SET client_min_messages = warning;
SET escape_string_warning = off;

--
-- Name: plpgsql; Type: PROCEDURAL LANGUAGE; Schema: -; Owner: postgres
--

CREATE PROCEDURAL LANGUAGE plpgsql;


ALTER PROCEDURAL LANGUAGE plpgsql OWNER TO postgres;

SET search_path = public, pg_catalog;

--
-- Name: ficha_id_seq; Type: SEQUENCE; Schema: public; Owner: javier
--

CREATE SEQUENCE ficha_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.ficha_id_seq OWNER TO javier;

--
-- Name: ficha_id_seq; Type: SEQUENCE SET; Schema: public; Owner: javier
--

SELECT pg_catalog.SETVAL('ficha_id_seq', 1, FALSE);


SET default_tablespace = '';

SET default_with_oids = FALSE;

--
-- Name: ficha; Type: TABLE; Schema: public; Owner: javier; Tablespace:
--

CREATE TABLE ficha (
    id INTEGER DEFAULT NEXTVAL('ficha_id_seq'::regclass) NOT NULL,
    cedula CHARACTER VARYING(11),
    nombres CHARACTER VARYING(45),
    fnacimiento DATE,
    codnom CHARACTER VARYING(6),
    codrec CHARACTER VARYING(10),
    codtipp CHARACTER VARYING(2),
    codcar CHARACTER VARYING(11),
    grado CHARACTER VARYING(2),
    codcat CHARACTER VARYING(4),
    nivel CHARACTER VARYING(1),
    fingreso DATE,
    observacion CHARACTER VARYING(300),
    codest CHARACTER VARYING(2),
    codubi INTEGER,
    codpro INTEGER
);


ALTER TABLE public.ficha OWNER TO javier;

--
-- Name: resultados_id_seq; Type: SEQUENCE; Schema: public; Owner: javier
--

CREATE SEQUENCE resultados_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.resultados_id_seq OWNER TO javier;

--
-- Name: resultados_id_seq; Type: SEQUENCE SET; Schema: public; Owner: javier
--

SELECT pg_catalog.SETVAL('resultados_id_seq', 1, FALSE);


--
-- Name: resultados; Type: TABLE; Schema: public; Owner: javier; Tablespace:
--

CREATE TABLE resultados (
    id INTEGER DEFAULT NEXTVAL('resultados_id_seq'::regclass) NOT NULL,
    id_evaluado INTEGER,
    id_evaluador INTEGER,
    id_supervisor INTEGER,
    anno CHARACTER VARYING(4),
    semestre CHARACTER VARYING(2),
    codtipp CHARACTER VARYING(2),
    t_objetivos INTEGER,
    t_competencias INTEGER,
    t_general INTEGER,
    actuacion CHARACTER VARYING(45),
    comenta_sup text,
    f_evalua DATE,
    deacuerdo CHARACTER VARYING(2),
    f_notificacion DATE,
    comenta_eva text
);


ALTER TABLE public.resultados OWNER TO javier;

--
-- Name: ubicacion_id_seq; Type: SEQUENCE; Schema: public; Owner: javier
--

CREATE SEQUENCE ubicacion_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.ubicacion_id_seq OWNER TO javier;

--
-- Name: ubicacion_id_seq; Type: SEQUENCE SET; Schema: public; Owner: javier
--

SELECT pg_catalog.SETVAL('ubicacion_id_seq', 1, FALSE);


--
-- Name: ubicacion; Type: TABLE; Schema: public; Owner: javier; Tablespace:
--

CREATE TABLE ubicacion (
    id INTEGER DEFAULT NEXTVAL('ubicacion_id_seq'::regclass) NOT NULL,
    codubi CHARACTER VARYING(20) NOT NULL,
    nomubi CHARACTER VARYING(50)
);


ALTER TABLE public.ubicacion OWNER TO javier;

--
-- Name: COLUMN ubicacion.codubi; Type: COMMENT; Schema: public; Owner: javier
--

COMMENT ON COLUMN ubicacion.codubi IS 'Codigo Ubicacion';


--
-- Name: COLUMN ubicacion.nomubi; Type: COMMENT; Schema: public; Owner: javier
--

COMMENT ON COLUMN ubicacion.nomubi IS 'Nombre de la Ubicacion';


--
-- Name: Dependencia; Type: VIEW; Schema: public; Owner: javier
--

CREATE VIEW "Dependencia" AS
    SELECT ubicacion.nomubi, COUNT(ubicacion.nomubi) AS COUNT, resultados.actuacion FROM ((ficha JOIN ubicacion ON ((ficha.codubi = ubicacion.id))) JOIN resultados ON ((resultados.id_evaluado = ficha.id))) WHERE ((resultados.anno)::text = '2010'::text) GROUP BY ubicacion.nomubi, resultados.actuacion ORDER BY ubicacion.nomubi;


ALTER TABLE public."Dependencia" OWNER TO javier;

--
-- Name: actuacion; Type: VIEW; Schema: public; Owner: javier
--

CREATE VIEW actuacion AS
    SELECT resultados.actuacion, COUNT(resultados.actuacion) AS COUNT FROM resultados WHERE ((resultados.anno)::text = '2010'::text) GROUP BY resultados.actuacion;


ALTER TABLE public.actuacion OWNER TO javier;

--
-- Name: areaocu; Type: TABLE; Schema: public; Owner: javier; Tablespace:
--

CREATE TABLE areaocu (
    id INTEGER NOT NULL,
    nomarea CHARACTER VARYING(50)
);


ALTER TABLE public.areaocu OWNER TO javier;

--
-- Name: areaocu_id_seq; Type: SEQUENCE; Schema: public; Owner: javier
--

CREATE SEQUENCE areaocu_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.areaocu_id_seq OWNER TO javier;

--
-- Name: areaocu_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: javier
--

ALTER SEQUENCE areaocu_id_seq OWNED BY areaocu.id;


--
-- Name: areaocu_id_seq; Type: SEQUENCE SET; Schema: public; Owner: javier
--

SELECT pg_catalog.SETVAL('areaocu_id_seq', 1, FALSE);


--
-- Name: ascensos_id_seq; Type: SEQUENCE; Schema: public; Owner: javier
--

CREATE SEQUENCE ascensos_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.ascensos_id_seq OWNER TO javier;

--
-- Name: ascensos_id_seq; Type: SEQUENCE SET; Schema: public; Owner: javier
--

SELECT pg_catalog.SETVAL('ascensos_id_seq', 1, FALSE);


--
-- Name: ascensos; Type: TABLE; Schema: public; Owner: javier; Tablespace:
--

CREATE TABLE ascensos (
    id INTEGER DEFAULT NEXTVAL('ascensos_id_seq'::regclass) NOT NULL,
    codtraba INTEGER NOT NULL,
    codcar INTEGER,
    fecha DATE,
    grado CHARACTER VARYING(2),
    paso CHARACTER VARYING(2),
    codubi INTEGER,
    observacion CHARACTER VARYING(200)
);


ALTER TABLE public.ascensos OWNER TO javier;

--
-- Name: auditor; Type: TABLE; Schema: public; Owner: javier; Tablespace:
--

CREATE TABLE auditor (
    id INTEGER,
    op text,
    fecha TIMESTAMP WITH TIME zone DEFAULT now(),
    tbl CHARACTER VARYING,
    ip inet,
    usr CHARACTER VARYING(30),
    llave INTEGER NOT NULL
);


ALTER TABLE public.auditor OWNER TO javier;

--
-- Name: auditor_llave_seq; Type: SEQUENCE; Schema: public; Owner: javier
--

CREATE SEQUENCE auditor_llave_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.auditor_llave_seq OWNER TO javier;

--
-- Name: auditor_llave_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: javier
--

ALTER SEQUENCE auditor_llave_seq OWNED BY auditor.llave;


--
-- Name: auditor_llave_seq; Type: SEQUENCE SET; Schema: public; Owner: javier
--

SELECT pg_catalog.SETVAL('auditor_llave_seq', 1, FALSE);


--
-- Name: cargos_id_seq; Type: SEQUENCE; Schema: public; Owner: javier
--

CREATE SEQUENCE cargos_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.cargos_id_seq OWNER TO javier;

--
-- Name: cargos_id_seq; Type: SEQUENCE SET; Schema: public; Owner: javier
--

SELECT pg_catalog.SETVAL('cargos_id_seq', 1, FALSE);


--
-- Name: cargos; Type: TABLE; Schema: public; Owner: javier; Tablespace:
--

CREATE TABLE cargos (
    id INTEGER DEFAULT NEXTVAL('cargos_id_seq'::regclass) NOT NULL,
    codcar CHARACTER VARYING(8) NOT NULL,
    nomcar CHARACTER(50)
);


ALTER TABLE public.cargos OWNER TO javier;

--
-- Name: COLUMN cargos.codcar; Type: COMMENT; Schema: public; Owner: javier
--

COMMENT ON COLUMN cargos.codcar IS 'Codigo del Cargo';


--
-- Name: COLUMN cargos.nomcar; Type: COMMENT; Schema: public; Owner: javier
--

COMMENT ON COLUMN cargos.nomcar IS 'Nombre del Cargo';


--
-- Name: categorias_id_seq; Type: SEQUENCE; Schema: public; Owner: javier
--

CREATE SEQUENCE categorias_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.categorias_id_seq OWNER TO javier;

--
-- Name: categorias_id_seq; Type: SEQUENCE SET; Schema: public; Owner: javier
--

SELECT pg_catalog.SETVAL('categorias_id_seq', 1, FALSE);


--
-- Name: categorias; Type: TABLE; Schema: public; Owner: javier; Tablespace:
--

CREATE TABLE categorias (
    id INTEGER DEFAULT NEXTVAL('categorias_id_seq'::regclass) NOT NULL,
    codcat CHARACTER VARYING(4) NOT NULL,
    nomcat CHARACTER VARYING(25)
);


ALTER TABLE public.categorias OWNER TO javier;

--
-- Name: catxfac; Type: TABLE; Schema: public; Owner: javier; Tablespace:
--

CREATE TABLE catxfac (
    id INTEGER NOT NULL,
    idfac INTEGER,
    nomcat CHARACTER VARYING(150),
    valor INTEGER
);


ALTER TABLE public.catxfac OWNER TO javier;

--
-- Name: catxfac_id_seq; Type: SEQUENCE; Schema: public; Owner: javier
--

CREATE SEQUENCE catxfac_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.catxfac_id_seq OWNER TO javier;

--
-- Name: catxfac_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: javier
--

ALTER SEQUENCE catxfac_id_seq OWNED BY catxfac.id;


--
-- Name: catxfac_id_seq; Type: SEQUENCE SET; Schema: public; Owner: javier
--

SELECT pg_catalog.SETVAL('catxfac_id_seq', 1, FALSE);


--
-- Name: cdteca; Type: TABLE; Schema: public; Owner: javier; Tablespace:
--

CREATE TABLE cdteca (
    id INTEGER NOT NULL
);


ALTER TABLE public.cdteca OWNER TO javier;

--
-- Name: cdteca_id_seq; Type: SEQUENCE; Schema: public; Owner: javier
--

CREATE SEQUENCE cdteca_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.cdteca_id_seq OWNER TO javier;

--
-- Name: cdteca_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: javier
--

ALTER SEQUENCE cdteca_id_seq OWNED BY cdteca.id;


--
-- Name: cdteca_id_seq; Type: SEQUENCE SET; Schema: public; Owner: javier
--

SELECT pg_catalog.SETVAL('cdteca_id_seq', 1, FALSE);


--
-- Name: competencias_id_seq; Type: SEQUENCE; Schema: public; Owner: javier
--

CREATE SEQUENCE competencias_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.competencias_id_seq OWNER TO javier;

--
-- Name: competencias_id_seq; Type: SEQUENCE SET; Schema: public; Owner: javier
--

SELECT pg_catalog.SETVAL('competencias_id_seq', 1, FALSE);


--
-- Name: competencias; Type: TABLE; Schema: public; Owner: javier; Tablespace:
--

CREATE TABLE competencias (
    id INTEGER DEFAULT NEXTVAL('competencias_id_seq'::regclass) NOT NULL,
    codcom CHARACTER VARYING(2),
    nomcom CHARACTER VARYING(60),
    peso INTEGER
);


ALTER TABLE public.competencias OWNER TO javier;

--
-- Name: condiactual_id_seq; Type: SEQUENCE; Schema: public; Owner: javier
--

CREATE SEQUENCE condiactual_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.condiactual_id_seq OWNER TO javier;

--
-- Name: condiactual_id_seq; Type: SEQUENCE SET; Schema: public; Owner: javier
--

SELECT pg_catalog.SETVAL('condiactual_id_seq', 1, FALSE);


--
-- Name: condiactual; Type: TABLE; Schema: public; Owner: javier; Tablespace:
--

CREATE TABLE condiactual (
    id INTEGER DEFAULT NEXTVAL('condiactual_id_seq'::regclass) NOT NULL,
    condiactual INTEGER
);


ALTER TABLE public.condiactual OWNER TO javier;

--
-- Name: condicion_id_seq; Type: SEQUENCE; Schema: public; Owner: javier
--

CREATE SEQUENCE condicion_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.condicion_id_seq OWNER TO javier;

--
-- Name: condicion_id_seq; Type: SEQUENCE SET; Schema: public; Owner: javier
--

SELECT pg_catalog.SETVAL('condicion_id_seq', 1, FALSE);


--
-- Name: condicion; Type: TABLE; Schema: public; Owner: javier; Tablespace:
--

CREATE TABLE condicion (
    id INTEGER DEFAULT NEXTVAL('condicion_id_seq'::regclass) NOT NULL,
    condicion CHARACTER VARYING(35) NOT NULL
);


ALTER TABLE public.condicion OWNER TO javier;

--
-- Name: deacuerdo; Type: VIEW; Schema: public; Owner: javier
--

CREATE VIEW deacuerdo AS
    SELECT resultados.deacuerdo, COUNT(resultados.deacuerdo) AS COUNT FROM resultados WHERE ((resultados.anno)::text = '2010'::text) GROUP BY resultados.deacuerdo;


ALTER TABLE public.deacuerdo OWNER TO javier;

--
-- Name: ecompetencias_id_seq; Type: SEQUENCE; Schema: public; Owner: javier
--

CREATE SEQUENCE ecompetencias_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.ecompetencias_id_seq OWNER TO javier;

--
-- Name: ecompetencias_id_seq; Type: SEQUENCE SET; Schema: public; Owner: javier
--

SELECT pg_catalog.SETVAL('ecompetencias_id_seq', 1, FALSE);


--
-- Name: ecompetencias; Type: TABLE; Schema: public; Owner: javier; Tablespace:
--

CREATE TABLE ecompetencias (
    id INTEGER DEFAULT NEXTVAL('ecompetencias_id_seq'::regclass) NOT NULL,
    id_comp INTEGER,
    id_evaluador INTEGER,
    id_supervisor INTEGER,
    anno CHARACTER VARYING(4),
    semestre CHARACTER VARYING(2),
    peso INTEGER,
    rango INTEGER,
    id_cevaluado INTEGER,
    codtipp CHARACTER VARYING(2),
    calcom INTEGER
);


ALTER TABLE public.ecompetencias OWNER TO javier;

--
-- Name: edocivil_id_seq; Type: SEQUENCE; Schema: public; Owner: javier
--

CREATE SEQUENCE edocivil_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.edocivil_id_seq OWNER TO javier;

--
-- Name: edocivil_id_seq; Type: SEQUENCE SET; Schema: public; Owner: javier
--

SELECT pg_catalog.SETVAL('edocivil_id_seq', 1, FALSE);


--
-- Name: edocivil; Type: TABLE; Schema: public; Owner: javier; Tablespace:
--

CREATE TABLE edocivil (
    id INTEGER DEFAULT NEXTVAL('edocivil_id_seq'::regclass) NOT NULL,
    estadoc CHARACTER VARYING(25) NOT NULL
);


ALTER TABLE public.edocivil OWNER TO javier;

--
-- Name: eobreros; Type: TABLE; Schema: public; Owner: javier; Tablespace:
--

CREATE TABLE eobreros (
    id INTEGER NOT NULL,
    id_evaluado INTEGER,
    id_evaluador INTEGER,
    id_supervisor INTEGER,
    anno CHARACTER VARYING(4),
    semestre CHARACTER VARYING(2),
    peso INTEGER,
    calculo NUMERIC(5,2),
    codtipp CHARACTER VARYING,
    id_factor INTEGER,
    id_catxfac INTEGER
);


ALTER TABLE public.eobreros OWNER TO javier;

--
-- Name: eobreros_id_seq; Type: SEQUENCE; Schema: public; Owner: javier
--

CREATE SEQUENCE eobreros_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.eobreros_id_seq OWNER TO javier;

--
-- Name: eobreros_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: javier
--

ALTER SEQUENCE eobreros_id_seq OWNED BY eobreros.id;


--
-- Name: eobreros_id_seq; Type: SEQUENCE SET; Schema: public; Owner: javier
--

SELECT pg_catalog.SETVAL('eobreros_id_seq', 1, FALSE);


--
-- Name: estado_id_seq; Type: SEQUENCE; Schema: public; Owner: javier
--

CREATE SEQUENCE estado_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.estado_id_seq OWNER TO javier;

--
-- Name: estado_id_seq; Type: SEQUENCE SET; Schema: public; Owner: javier
--

SELECT pg_catalog.SETVAL('estado_id_seq', 1, FALSE);


--
-- Name: estado; Type: TABLE; Schema: public; Owner: javier; Tablespace:
--

CREATE TABLE estado (
    id INTEGER DEFAULT NEXTVAL('estado_id_seq'::regclass) NOT NULL,
    codest CHARACTER VARYING(2) NOT NULL,
    nomest CHARACTER VARYING(25)
);


ALTER TABLE public.estado OWNER TO javier;

--
-- Name: evaluados_id_seq; Type: SEQUENCE; Schema: public; Owner: javier
--

CREATE SEQUENCE evaluados_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.evaluados_id_seq OWNER TO javier;

--
-- Name: evaluados_id_seq; Type: SEQUENCE SET; Schema: public; Owner: javier
--

SELECT pg_catalog.SETVAL('evaluados_id_seq', 1, FALSE);


--
-- Name: evaluados; Type: TABLE; Schema: public; Owner: javier; Tablespace:
--

CREATE TABLE evaluados (
    id INTEGER DEFAULT NEXTVAL('evaluados_id_seq'::regclass) NOT NULL,
    id_evaluado INTEGER,
    id_evaluador INTEGER,
    id_supervisor INTEGER,
    observacion CHARACTER VARYING(60),
    codtipp CHARACTER VARYING(2)
);


ALTER TABLE public.evaluados OWNER TO javier;

--
-- Name: COLUMN evaluados.id; Type: COMMENT; Schema: public; Owner: javier
--

COMMENT ON COLUMN evaluados.id IS 'Id';


--
-- Name: COLUMN evaluados.id_evaluado; Type: COMMENT; Schema: public; Owner: javier
--

COMMENT ON COLUMN evaluados.id_evaluado IS 'Evaluado';


--
-- Name: COLUMN evaluados.id_evaluador; Type: COMMENT; Schema: public; Owner: javier
--

COMMENT ON COLUMN evaluados.id_evaluador IS 'Evaluador';


--
-- Name: COLUMN evaluados.id_supervisor; Type: COMMENT; Schema: public; Owner: javier
--

COMMENT ON COLUMN evaluados.id_supervisor IS 'Supervisor del Evaluador';


--
-- Name: COLUMN evaluados.observacion; Type: COMMENT; Schema: public; Owner: javier
--

COMMENT ON COLUMN evaluados.observacion IS 'Observacion';


--
-- Name: factores; Type: TABLE; Schema: public; Owner: javier; Tablespace:
--

CREATE TABLE factores (
    id INTEGER NOT NULL,
    nomfac CHARACTER VARYING(50),
    detfac CHARACTER VARYING(300),
    tipoper CHARACTER VARYING(2)
);


ALTER TABLE public.factores OWNER TO javier;

--
-- Name: factores_id_seq; Type: SEQUENCE; Schema: public; Owner: javier
--

CREATE SEQUENCE factores_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.factores_id_seq OWNER TO javier;

--
-- Name: factores_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: javier
--

ALTER SEQUENCE factores_id_seq OWNED BY factores.id;


--
-- Name: factores_id_seq; Type: SEQUENCE SET; Schema: public; Owner: javier
--

SELECT pg_catalog.SETVAL('factores_id_seq', 1, FALSE);


--
-- Name: familiares_id_seq; Type: SEQUENCE; Schema: public; Owner: javier
--

CREATE SEQUENCE familiares_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.familiares_id_seq OWNER TO javier;

--
-- Name: familiares_id_seq; Type: SEQUENCE SET; Schema: public; Owner: javier
--

SELECT pg_catalog.SETVAL('familiares_id_seq', 1, FALSE);


--
-- Name: familiares; Type: TABLE; Schema: public; Owner: javier; Tablespace:
--

CREATE TABLE familiares (
    id INTEGER DEFAULT NEXTVAL('familiares_id_seq'::regclass) NOT NULL,
    codtraba INTEGER,
    cedfam CHARACTER VARYING(12),
    nomfam CHARACTER VARYING(45),
    sexfam INTEGER,
    parentesco INTEGER,
    fnacfam DATE
);


ALTER TABLE public.familiares OWNER TO javier;

--
-- Name: grado_id_seq; Type: SEQUENCE; Schema: public; Owner: javier
--

CREATE SEQUENCE grado_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.grado_id_seq OWNER TO javier;

--
-- Name: grado_id_seq; Type: SEQUENCE SET; Schema: public; Owner: javier
--

SELECT pg_catalog.SETVAL('grado_id_seq', 1, FALSE);


--
-- Name: grado; Type: TABLE; Schema: public; Owner: javier; Tablespace:
--

CREATE TABLE grado (
    id INTEGER DEFAULT NEXTVAL('grado_id_seq'::regclass) NOT NULL,
    codgra CHARACTER VARYING(2) NOT NULL,
    nomgra CHARACTER VARYING(25)
);


ALTER TABLE public.grado OWNER TO javier;

--
-- Name: menu_id_seq; Type: SEQUENCE; Schema: public; Owner: javier
--

CREATE SEQUENCE menu_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.menu_id_seq OWNER TO javier;

--
-- Name: menu_id_seq; Type: SEQUENCE SET; Schema: public; Owner: javier
--

SELECT pg_catalog.SETVAL('menu_id_seq', 1, FALSE);


--
-- Name: menu; Type: TABLE; Schema: public; Owner: javier; Tablespace:
--

CREATE TABLE menu (
    id INTEGER DEFAULT NEXTVAL('menu_id_seq'::regclass) NOT NULL,
    nombre CHARACTER VARYING(20) NOT NULL,
    id_padre INTEGER,
    etiqueta CHARACTER VARYING(40),
    posicion SMALLINT,
    visible BOOLEAN,
    nivel_acceso SMALLINT,
    accion CHARACTER VARYING(100),
    param1 text,
    nombre_padre CHARACTER VARYING(20),
    posicion_padre SMALLINT,
    menu CHARACTER VARYING
);


ALTER TABLE public.menu OWNER TO javier;

--
-- Name: objetivos_id_seq; Type: SEQUENCE; Schema: public; Owner: javier
--

CREATE SEQUENCE objetivos_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.objetivos_id_seq OWNER TO javier;

--
-- Name: objetivos_id_seq; Type: SEQUENCE SET; Schema: public; Owner: javier
--

SELECT pg_catalog.SETVAL('objetivos_id_seq', 1, FALSE);


--
-- Name: objetivos; Type: TABLE; Schema: public; Owner: javier; Tablespace:
--

CREATE TABLE objetivos (
    id INTEGER DEFAULT NEXTVAL('objetivos_id_seq'::regclass) NOT NULL,
    id_oevaluado INTEGER,
    id_evaluador INTEGER,
    id_supervisor INTEGER,
    anno CHARACTER VARYING(4),
    semestre CHARACTER VARYING(2),
    fasigna DATE,
    prirev text,
    fprirev DATE,
    segrev text,
    fsegrev DATE,
    terrev text,
    fterrev DATE,
    objetivo text,
    peso INTEGER,
    rango INTEGER,
    deacuerdo CHARACTER VARYING(2),
    observacion text,
    codtipp CHARACTER VARYING(2),
    calobj INTEGER
);


ALTER TABLE public.objetivos OWNER TO javier;

--
-- Name: COLUMN objetivos.id; Type: COMMENT; Schema: public; Owner: javier
--

COMMENT ON COLUMN objetivos.id IS 'Id Objetivos';


--
-- Name: parentesco_id_seq; Type: SEQUENCE; Schema: public; Owner: javier
--

CREATE SEQUENCE parentesco_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.parentesco_id_seq OWNER TO javier;

--
-- Name: parentesco_id_seq; Type: SEQUENCE SET; Schema: public; Owner: javier
--

SELECT pg_catalog.SETVAL('parentesco_id_seq', 1, FALSE);


--
-- Name: parentesco; Type: TABLE; Schema: public; Owner: javier; Tablespace:
--

CREATE TABLE parentesco (
    id INTEGER DEFAULT NEXTVAL('parentesco_id_seq'::regclass) NOT NULL,
    parentesco CHARACTER VARYING(30)
);


ALTER TABLE public.parentesco OWNER TO javier;

--
-- Name: por estado; Type: VIEW; Schema: public; Owner: javier
--

CREATE VIEW "por estado" AS
    SELECT estado.nomest, COUNT(estado.nomest) AS COUNT FROM ((ficha JOIN estado ON (((ficha.codest)::text = (estado.codest)::text))) JOIN resultados ON ((resultados.id_evaluado = ficha.id))) WHERE ((resultados.anno)::text = '2010'::text) GROUP BY estado.nomest;


ALTER TABLE public."por estado" OWNER TO javier;

--
-- Name: profesion_id_seq; Type: SEQUENCE; Schema: public; Owner: javier
--

CREATE SEQUENCE profesion_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.profesion_id_seq OWNER TO javier;

--
-- Name: profesion_id_seq; Type: SEQUENCE SET; Schema: public; Owner: javier
--

SELECT pg_catalog.SETVAL('profesion_id_seq', 1, FALSE);


--
-- Name: profesion; Type: TABLE; Schema: public; Owner: javier; Tablespace:
--

CREATE TABLE profesion (
    id INTEGER DEFAULT NEXTVAL('profesion_id_seq'::regclass) NOT NULL,
    codpro CHARACTER VARYING(9),
    nompro CHARACTER VARYING(50)
);


ALTER TABLE public.profesion OWNER TO javier;

--
-- Name: COLUMN profesion.codpro; Type: COMMENT; Schema: public; Owner: javier
--

COMMENT ON COLUMN profesion.codpro IS 'Codigo de Profesion';


--
-- Name: COLUMN profesion.nompro; Type: COMMENT; Schema: public; Owner: javier
--

COMMENT ON COLUMN profesion.nompro IS 'Nombre de la Profesion';


--
-- Name: resultados_comenta_evaluado_seq; Type: SEQUENCE; Schema: public; Owner: javier
--

CREATE SEQUENCE resultados_comenta_evaluado_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.resultados_comenta_evaluado_seq OWNER TO javier;

--
-- Name: resultados_comenta_evaluado_seq; Type: SEQUENCE SET; Schema: public; Owner: javier
--

SELECT pg_catalog.SETVAL('resultados_comenta_evaluado_seq', 1, FALSE);


--
-- Name: sexo_id_seq; Type: SEQUENCE; Schema: public; Owner: javier
--

CREATE SEQUENCE sexo_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.sexo_id_seq OWNER TO javier;

--
-- Name: sexo_id_seq; Type: SEQUENCE SET; Schema: public; Owner: javier
--

SELECT pg_catalog.SETVAL('sexo_id_seq', 1, FALSE);


--
-- Name: sexo; Type: TABLE; Schema: public; Owner: javier; Tablespace:
--

CREATE TABLE sexo (
    id INTEGER DEFAULT NEXTVAL('sexo_id_seq'::regclass) NOT NULL,
    sexo CHARACTER VARYING(9) NOT NULL
);


ALTER TABLE public.sexo OWNER TO javier;

--
-- Name: tipo; Type: VIEW; Schema: public; Owner: javier
--

CREATE VIEW tipo AS
    SELECT resultados.actuacion, resultados.codtipp, COUNT(resultados.codtipp) AS COUNT FROM ((ficha JOIN ubicacion ON ((ficha.codubi = ubicacion.id))) JOIN resultados ON ((resultados.id_evaluado = ficha.id))) WHERE ((resultados.anno)::text = '2010'::text) GROUP BY resultados.codtipp, resultados.actuacion ORDER BY resultados.codtipp;


ALTER TABLE public.tipo OWNER TO javier;

--
-- Name: tipocar_id_seq; Type: SEQUENCE; Schema: public; Owner: javier
--

CREATE SEQUENCE tipocar_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.tipocar_id_seq OWNER TO javier;

--
-- Name: tipocar_id_seq; Type: SEQUENCE SET; Schema: public; Owner: javier
--

SELECT pg_catalog.SETVAL('tipocar_id_seq', 1, FALSE);


--
-- Name: tipocar; Type: TABLE; Schema: public; Owner: javier; Tablespace:
--

CREATE TABLE tipocar (
    id INTEGER DEFAULT NEXTVAL('tipocar_id_seq'::regclass) NOT NULL,
    codtipc CHARACTER VARYING(2) NOT NULL,
    nomtipc CHARACTER VARYING(25)
);


ALTER TABLE public.tipocar OWNER TO javier;

--
-- Name: tipoper_id_seq; Type: SEQUENCE; Schema: public; Owner: javier
--

CREATE SEQUENCE tipoper_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.tipoper_id_seq OWNER TO javier;

--
-- Name: tipoper_id_seq; Type: SEQUENCE SET; Schema: public; Owner: javier
--

SELECT pg_catalog.SETVAL('tipoper_id_seq', 1, FALSE);


--
-- Name: tipoper; Type: TABLE; Schema: public; Owner: javier; Tablespace:
--

CREATE TABLE tipoper (
    id INTEGER DEFAULT NEXTVAL('tipoper_id_seq'::regclass) NOT NULL,
    codtipp CHARACTER VARYING(2),
    nomtipp CHARACTER VARYING(45)
);


ALTER TABLE public.tipoper OWNER TO javier;

--
-- Name: users_id_seq; Type: SEQUENCE; Schema: public; Owner: javier
--

CREATE SEQUENCE users_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.users_id_seq OWNER TO javier;

--
-- Name: users_id_seq; Type: SEQUENCE SET; Schema: public; Owner: javier
--

SELECT pg_catalog.SETVAL('users_id_seq', 1, FALSE);


--
-- Name: users; Type: TABLE; Schema: public; Owner: javier; Tablespace:
--

CREATE TABLE users (
    id INTEGER DEFAULT NEXTVAL('users_id_seq'::regclass) NOT NULL,
    usuario CHARACTER VARYING(20) NOT NULL,
    clave CHARACTER VARYING NOT NULL,
    nivel_acceso CHARACTER VARYING(11),
    default_mask CHARACTER VARYING(30),
    nombre CHARACTER VARYING(100),
    codsup INTEGER
);


ALTER TABLE public.users OWNER TO javier;

--
-- Name: COLUMN users.nivel_acceso; Type: COMMENT; Schema: public; Owner: javier
--

COMMENT ON COLUMN users.nivel_acceso IS 'compuesto por el código político';


--
-- Name: COLUMN users.default_mask; Type: COMMENT; Schema: public; Owner: javier
--

COMMENT ON COLUMN users.default_mask IS 'mascara del sistema que abrira por defecto el usuario';


--
-- Name: usuario_menu; Type: TABLE; Schema: public; Owner: javier; Tablespace:
--

CREATE TABLE usuario_menu (
    id_usuario INTEGER NOT NULL,
    id_menu INTEGER NOT NULL,
    visible BOOLEAN DEFAULT TRUE NOT NULL,
    id INTEGER NOT NULL
);


ALTER TABLE public.usuario_menu OWNER TO javier;

--
-- Name: usuario_menu_id_seq; Type: SEQUENCE; Schema: public; Owner: javier
--

CREATE SEQUENCE usuario_menu_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.usuario_menu_id_seq OWNER TO javier;

--
-- Name: usuario_menu_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: javier
--

ALTER SEQUENCE usuario_menu_id_seq OWNED BY usuario_menu.id;


--
-- Name: usuario_menu_id_seq; Type: SEQUENCE SET; Schema: public; Owner: javier
--

SELECT pg_catalog.SETVAL('usuario_menu_id_seq', 1, FALSE);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: javier
--

ALTER TABLE areaocu ALTER COLUMN id SET DEFAULT NEXTVAL('areaocu_id_seq'::regclass);


--
-- Name: llave; Type: DEFAULT; Schema: public; Owner: javier
--

ALTER TABLE auditor ALTER COLUMN llave SET DEFAULT NEXTVAL('auditor_llave_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: javier
--

ALTER TABLE catxfac ALTER COLUMN id SET DEFAULT NEXTVAL('catxfac_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: javier
--

ALTER TABLE cdteca ALTER COLUMN id SET DEFAULT NEXTVAL('cdteca_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: javier
--

ALTER TABLE eobreros ALTER COLUMN id SET DEFAULT NEXTVAL('eobreros_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: javier
--

ALTER TABLE factores ALTER COLUMN id SET DEFAULT NEXTVAL('factores_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: javier
--

ALTER TABLE usuario_menu ALTER COLUMN id SET DEFAULT NEXTVAL('usuario_menu_id_seq'::regclass);


--
-- Data for Name: areaocu; Type: TABLE DATA; Schema: public; Owner: javier
--



--
-- Data for Name: ascensos; Type: TABLE DATA; Schema: public; Owner: javier
--



--
-- Data for Name: auditor; Type: TABLE DATA; Schema: public; Owner: javier
--



--
-- Data for Name: cargos; Type: TABLE DATA; Schema: public; Owner: javier
--



--
-- Data for Name: categorias; Type: TABLE DATA; Schema: public; Owner: javier
--



--
-- Data for Name: catxfac; Type: TABLE DATA; Schema: public; Owner: javier
--



--
-- Data for Name: cdteca; Type: TABLE DATA; Schema: public; Owner: javier
--



--
-- Data for Name: competencias; Type: TABLE DATA; Schema: public; Owner: javier
--



--
-- Data for Name: condiactual; Type: TABLE DATA; Schema: public; Owner: javier
--



--
-- Data for Name: condicion; Type: TABLE DATA; Schema: public; Owner: javier
--



--
-- Data for Name: ecompetencias; Type: TABLE DATA; Schema: public; Owner: javier
--



--
-- Data for Name: edocivil; Type: TABLE DATA; Schema: public; Owner: javier
--



--
-- Data for Name: eobreros; Type: TABLE DATA; Schema: public; Owner: javier
--



--
-- Data for Name: estado; Type: TABLE DATA; Schema: public; Owner: javier
--



--
-- Data for Name: evaluados; Type: TABLE DATA; Schema: public; Owner: javier
--



--
-- Data for Name: factores; Type: TABLE DATA; Schema: public; Owner: javier
--



--
-- Data for Name: familiares; Type: TABLE DATA; Schema: public; Owner: javier
--



--
-- Data for Name: ficha; Type: TABLE DATA; Schema: public; Owner: javier
--



--
-- Data for Name: grado; Type: TABLE DATA; Schema: public; Owner: javier
--



--
-- Data for Name: menu; Type: TABLE DATA; Schema: public; Owner: javier
--



--
-- Data for Name: objetivos; Type: TABLE DATA; Schema: public; Owner: javier
--



--
-- Data for Name: parentesco; Type: TABLE DATA; Schema: public; Owner: javier
--



--
-- Data for Name: profesion; Type: TABLE DATA; Schema: public; Owner: javier
--



--
-- Data for Name: resultados; Type: TABLE DATA; Schema: public; Owner: javier
--



--
-- Data for Name: sexo; Type: TABLE DATA; Schema: public; Owner: javier
--



--
-- Data for Name: tipocar; Type: TABLE DATA; Schema: public; Owner: javier
--



--
-- Data for Name: tipoper; Type: TABLE DATA; Schema: public; Owner: javier
--



--
-- Data for Name: ubicacion; Type: TABLE DATA; Schema: public; Owner: javier
--



--
-- Data for Name: users; Type: TABLE DATA; Schema: public; Owner: javier
--



--
-- Data for Name: usuario_menu; Type: TABLE DATA; Schema: public; Owner: javier
--



--
-- Name: areaocu_pkey; Type: CONSTRAINT; Schema: public; Owner: javier; Tablespace:
--

ALTER TABLE ONLY areaocu
    ADD CONSTRAINT areaocu_pkey PRIMARY KEY (id);


--
-- Name: ascensos_pkey; Type: CONSTRAINT; Schema: public; Owner: javier; Tablespace:
--

ALTER TABLE ONLY ascensos
    ADD CONSTRAINT ascensos_pkey PRIMARY KEY (id);


--
-- Name: auditor_pkey; Type: CONSTRAINT; Schema: public; Owner: javier; Tablespace:
--

ALTER TABLE ONLY auditor
    ADD CONSTRAINT auditor_pkey PRIMARY KEY (llave);


--
-- Name: cargos_pkey; Type: CONSTRAINT; Schema: public; Owner: javier; Tablespace:
--

ALTER TABLE ONLY cargos
    ADD CONSTRAINT cargos_pkey PRIMARY KEY (id);


--
-- Name: categorias_pkey; Type: CONSTRAINT; Schema: public; Owner: javier; Tablespace:
--

ALTER TABLE ONLY categorias
    ADD CONSTRAINT categorias_pkey PRIMARY KEY (id);


--
-- Name: catxfac_pkey; Type: CONSTRAINT; Schema: public; Owner: javier; Tablespace:
--

ALTER TABLE ONLY catxfac
    ADD CONSTRAINT catxfac_pkey PRIMARY KEY (id);


--
-- Name: cdteca_pkey; Type: CONSTRAINT; Schema: public; Owner: javier; Tablespace:
--

ALTER TABLE ONLY cdteca
    ADD CONSTRAINT cdteca_pkey PRIMARY KEY (id);


--
-- Name: competencias_pkey; Type: CONSTRAINT; Schema: public; Owner: javier; Tablespace:
--

ALTER TABLE ONLY competencias
    ADD CONSTRAINT competencias_pkey PRIMARY KEY (id);


--
-- Name: condiactual_pkey; Type: CONSTRAINT; Schema: public; Owner: javier; Tablespace:
--

ALTER TABLE ONLY condiactual
    ADD CONSTRAINT condiactual_pkey PRIMARY KEY (id);


--
-- Name: condicion_pkey; Type: CONSTRAINT; Schema: public; Owner: javier; Tablespace:
--

ALTER TABLE ONLY condicion
    ADD CONSTRAINT condicion_pkey PRIMARY KEY (id);


--
-- Name: ecompetencias_pkey; Type: CONSTRAINT; Schema: public; Owner: javier; Tablespace:
--

ALTER TABLE ONLY ecompetencias
    ADD CONSTRAINT ecompetencias_pkey PRIMARY KEY (id);


--
-- Name: edocivil_pkey; Type: CONSTRAINT; Schema: public; Owner: javier; Tablespace:
--

ALTER TABLE ONLY edocivil
    ADD CONSTRAINT edocivil_pkey PRIMARY KEY (id);


--
-- Name: eobreros_pkey; Type: CONSTRAINT; Schema: public; Owner: javier; Tablespace:
--

ALTER TABLE ONLY eobreros
    ADD CONSTRAINT eobreros_pkey PRIMARY KEY (id);


--
-- Name: estado_pkey; Type: CONSTRAINT; Schema: public; Owner: javier; Tablespace:
--

ALTER TABLE ONLY estado
    ADD CONSTRAINT estado_pkey PRIMARY KEY (id);


--
-- Name: evaluados_pkey; Type: CONSTRAINT; Schema: public; Owner: javier; Tablespace:
--

ALTER TABLE ONLY evaluados
    ADD CONSTRAINT evaluados_pkey PRIMARY KEY (id);


--
-- Name: factores_pkey; Type: CONSTRAINT; Schema: public; Owner: javier; Tablespace:
--

ALTER TABLE ONLY factores
    ADD CONSTRAINT factores_pkey PRIMARY KEY (id);


--
-- Name: familiares_pkey; Type: CONSTRAINT; Schema: public; Owner: javier; Tablespace:
--

ALTER TABLE ONLY familiares
    ADD CONSTRAINT familiares_pkey PRIMARY KEY (id);


--
-- Name: ficha_pkey; Type: CONSTRAINT; Schema: public; Owner: javier; Tablespace:
--

ALTER TABLE ONLY ficha
    ADD CONSTRAINT ficha_pkey PRIMARY KEY (id);


--
-- Name: grado_pkey; Type: CONSTRAINT; Schema: public; Owner: javier; Tablespace:
--

ALTER TABLE ONLY grado
    ADD CONSTRAINT grado_pkey PRIMARY KEY (id);


--
-- Name: menu_pkey; Type: CONSTRAINT; Schema: public; Owner: javier; Tablespace:
--

ALTER TABLE ONLY menu
    ADD CONSTRAINT menu_pkey PRIMARY KEY (id);


--
-- Name: objetivos_pkey; Type: CONSTRAINT; Schema: public; Owner: javier; Tablespace:
--

ALTER TABLE ONLY objetivos
    ADD CONSTRAINT objetivos_pkey PRIMARY KEY (id);


--
-- Name: parentesco_pkey; Type: CONSTRAINT; Schema: public; Owner: javier; Tablespace:
--

ALTER TABLE ONLY parentesco
    ADD CONSTRAINT parentesco_pkey PRIMARY KEY (id);


--
-- Name: profesion_pkey; Type: CONSTRAINT; Schema: public; Owner: javier; Tablespace:
--

ALTER TABLE ONLY profesion
    ADD CONSTRAINT profesion_pkey PRIMARY KEY (id);


--
-- Name: resultados_pkey; Type: CONSTRAINT; Schema: public; Owner: javier; Tablespace:
--

ALTER TABLE ONLY resultados
    ADD CONSTRAINT resultados_pkey PRIMARY KEY (id);


--
-- Name: sexo_pkey; Type: CONSTRAINT; Schema: public; Owner: javier; Tablespace:
--

ALTER TABLE ONLY sexo
    ADD CONSTRAINT sexo_pkey PRIMARY KEY (id);


--
-- Name: tipocar_pkey; Type: CONSTRAINT; Schema: public; Owner: javier; Tablespace:
--

ALTER TABLE ONLY tipocar
    ADD CONSTRAINT tipocar_pkey PRIMARY KEY (id);


--
-- Name: tipoper_pkey; Type: CONSTRAINT; Schema: public; Owner: javier; Tablespace:
--

ALTER TABLE ONLY tipoper
    ADD CONSTRAINT tipoper_pkey PRIMARY KEY (id);


--
-- Name: ubicacion_pkey; Type: CONSTRAINT; Schema: public; Owner: javier; Tablespace:
--

ALTER TABLE ONLY ubicacion
    ADD CONSTRAINT ubicacion_pkey PRIMARY KEY (id);


--
-- Name: usuario_menu_pkey; Type: CONSTRAINT; Schema: public; Owner: javier; Tablespace:
--

ALTER TABLE ONLY usuario_menu
    ADD CONSTRAINT usuario_menu_pkey PRIMARY KEY (id);


--
-- Name: usuario_pkey; Type: CONSTRAINT; Schema: public; Owner: javier; Tablespace:
--

ALTER TABLE ONLY users
    ADD CONSTRAINT usuario_pkey PRIMARY KEY (id);

ALTER TABLE users CLUSTER ON usuario_pkey;


--
-- 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;


--
-- PostgreSQL database dump complete
--