cco.gov.co

:::::::::::::::::::::::::::::::::::::: LulzSec Guatemala ::::::::::::::::::::::::::::::::::

Twitter -----> https://www.twiter.com/LulzSec_GT ( @LulzSec_GT )
Fabook ------> https://www.facebook.com/pages/LulzSec-Guatemala/333756649974544
Google + ----> https://plus.google.com/u/0/102917008474719760899

:::::::::::::::::::::::::::::::::::::: #LulzSec_GT :::::::::::::::::::::::::::::::::::::::::::::

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

SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = FALSE;

--
-- Name: borrar; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--

CREATE TABLE borrar (
    fac_id CHARACTER VARYING(3) NOT NULL,
    pro12 INTEGER,
    fac_des1 CHARACTER VARYING(23),
    ind1 INTEGER,
    responsable CHARACTER(1),
    responsable1 CHARACTER(150),
    responsable2 CHARACTER(150)
);


ALTER TABLE public.borrar OWNER TO postgres;

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

CREATE TABLE factores (
    fac_id CHARACTER VARYING(3) NOT NULL,
    fac_des CHARACTER VARYING(255) NOT NULL,
    fact1 INTEGER,
    fact2 INTEGER,
    fact3 INTEGER,
    fact4 INTEGER,
    fact5 INTEGER,
    fact6 INTEGER,
    fact7 INTEGER,
    fact8 INTEGER,
    fact9 INTEGER,
    fact10 INTEGER,
    fact11 INTEGER,
    fact12 INTEGER,
    control INTEGER,
    responsable CHARACTER(150)
);


ALTER TABLE public.factores OWNER TO postgres;

--
-- Name: indicadores; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--

CREATE TABLE indicadores (
    ind_id CHARACTER VARYING(4) NOT NULL,
    ind_des CHARACTER VARYING(255) NOT NULL,
    ind1 INTEGER,
    ind2 INTEGER,
    ind3 INTEGER,
    ind4 INTEGER,
    ind5 INTEGER,
    ind6 INTEGER,
    ind7 INTEGER,
    ind8 INTEGER,
    ind9 INTEGER,
    ind10 INTEGER,
    ind11 INTEGER,
    ind12 INTEGER,
    unidades CHARACTER(200)
);


ALTER TABLE public.indicadores OWNER TO postgres;

--
-- Name: lineas; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--

CREATE TABLE lineas (
    lin_id CHARACTER VARYING(3) NOT NULL,
    lin_des CHARACTER VARYING(255) NOT NULL
);


ALTER TABLE public.lineas OWNER TO postgres;

--
-- Name: programas; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--

CREATE TABLE programas (
    pro_id CHARACTER VARYING(2) NOT NULL,
    pro_des CHARACTER VARYING(255) NOT NULL,
    pro1 INTEGER,
    pro2 INTEGER,
    pro3 INTEGER,
    pro4 INTEGER,
    pro5 INTEGER,
    pro6 INTEGER,
    pro7 INTEGER,
    pro8 INTEGER,
    pro9 INTEGER,
    pro10 INTEGER,
    pro11 INTEGER,
    pro12 INTEGER,
    unidades CHARACTER(200)
);


ALTER TABLE public.programas OWNER TO postgres;

--
-- Name: usuario; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--

CREATE TABLE usuario (
    user_id INTEGER NOT NULL,
    login CHARACTER VARYING(10),
    passwd CHARACTER VARYING(35),
    name CHARACTER VARYING(100)
);


ALTER TABLE public.usuario OWNER TO postgres;

--
-- Name: variables; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--

CREATE TABLE VARIABLES (
    var_id CHARACTER VARYING(3) NOT NULL,
    var_des CHARACTER VARYING(255) NOT NULL,
    var1 INTEGER,
    var2 INTEGER,
    var3 INTEGER,
    var4 INTEGER,
    var5 INTEGER,
    var6 INTEGER,
    var7 INTEGER,
    var8 INTEGER,
    var9 INTEGER,
    var10 INTEGER,
    var11 INTEGER,
    var12 INTEGER,
    unidades CHARACTER(200)
);


ALTER TABLE public.VARIABLES OWNER TO postgres;

--
-- Data for Name: borrar; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY borrar (fac_id, pro12, fac_des1, ind1, responsable, responsable1, responsable2) FROM stdin;
Bc  \N  0   \N  \N  \N  \N
Bd  \N  0   \N  \N  \N  \N
Bg  123 0   \N  \N  \N  \N
Ba  \N  0   \N  \N  COMISION COLOMBIANA DEL OCEANO                                                                                                                          \N
G   4   0   0       \N  \N
\.


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

COPY factores (fac_id, fac_des, fact1, fact2, fact3, fact4, fact5, fact6, fact7, fact8, fact9, fact10, fact11, fact12, control, responsable) FROM stdin;
\.


--
-- Data for Name: indicadores; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY indicadores (ind_id, ind_des, ind1, ind2, ind3, ind4, ind5, ind6, ind7, ind8, ind9, ind10, ind11, ind12, unidades) FROM stdin;
\.


--
-- Data for Name: lineas; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY lineas (lin_id, lin_des) FROM stdin;
DE  Desarrollo Economico
PMA Proteccion del Medio Ambiente Marino
FTH Formacion del Talento Humano y Fortalecimiento del Capital Social
DT  Desarrollo Territorial
DIM Desarrollo Institucional Maritimo
\.


--
-- Data for Name: programas; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY programas (pro_id, pro_des, pro1, pro2, pro3, pro4, pro5, pro6, pro7, pro8, pro9, pro10, pro11, pro12, unidades) FROM stdin;
MM  Marina Mercante 0   0   0   0   0   0   0   0   0   0   0   0   % de competitividad de la Marina Mercante Nacional
AM  Autoridad Maritima  0   0   0   0   0   0   0   0   0   0   0   0   % De gestion y fortalecimiento de la autoridad maritima
OT  Ordenamiento Territorial    0   0   0   0   0   0   0   0   0   0   0   0   % de avance en el ordenamiento territorial de zonas costeras
PD  Prevencion y Atencion de Desastres  0   0   0   0   0   0   0   0   0   0   0   0   % de avance en la prevencion y atencion de desastres en la zona costera
AP  Agua potable y Saneamiento Basico   0   0   0   0   0   0   0   0   0   0   0   0   % Avance en conservacion
PU  Puertos e infraestructura   0   0   0   0   0   0   0   0   0   0   0   0   % de competitividad del sector Portuario Nacional
IM  Industria Maritima  0   0   0   0   0   0   0   0   0   0   0   0   % de competitividad de la industria Maritima en el Pais
PA  Pesca y Acuicultura 0   0   0   0   0   0   0   0   0   0   0   0   % desarrollo pesca y acuicultura Nacional
TM  Transporte Maritimo 0   0   0   0   0   0   0   0   0   0   0   0   % desarrollo del transporte maritimo en el pais
IT  Industria Turistica 0   0   0   0   0   0   0   0   0   0   0   0   % Avance de la Industria turistica en Colombia
ME  Minerales, hidrocarburos y fuentes alternativas de energia  0   0   0   0   0   0   0   0   0   0   0   0   % Aprovechamiento de los Minerales, hidrocarburos y fuentes alternativas de energia
AS  Areas Protegidas    0   0   0   0   0   0   0   0   0   0   0   0    % avance en conservacion
AD  Areas Degradadas    0   0   0   0   0   0   0   0   0   0   0   0   % avance en la correccion de areas degradadas (escala 1-100)
BD  Biodiversidad y Especies Amenazadas 0   0   0   0   0   0   0   0   0   0   0   0   % de avance en la conservacion y recuperacion
CN  Reduccion de Contaminacion Marina   0   0   0   0   0   0   0   0   0   0   0   0   % de avance en la reduccion de la contaminacion
CS  Capital Social  0   0   0   0   0   0   0   0   0   0   0   0   % Avance en el fortalecimiento del capital social
CM  Conciencia maritima 0   0   0   0   0   0   0   0   0   0   0   0   % De fomento en la conciencia maritima
CH  Capital Humano  0   0   0   0   0   0   0   0   0   0   0   0   % Fortalecimiento del Capital Humano
PN  Poder Naval 0   0   0   0   0   0   0   0   0   0   0   0   % De Poder Naval
\.


--
-- Data for Name: usuario; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY usuario (user_id, login, passwd, name) FROM stdin;
1   raul    32f81ece0e865834ba1579dabb548aff    COMISION COLOMBIANA DEL OCEANO
2   minjus  3af62635c64ee6fb6f26d67dff1b2b4b    MINISTERIO DEL INTERIOR Y JUSTICIA
3   minrel  83be1d4654f08ec10be5d658b8a29e43    MINISTERIO DE RELACIONES EXTERIORES
4   mindef  cbb501a17b35a6c66005499a568275b4    MINISTERIO DE DEFENSA NACIONAL
5   minagr  242e3b425305fda2f6cdb7e583c02942    MINISTERIO DE AGRICULTURA Y DESARROLLO RURAL
6   mincom  59d913dcd7335fc278faeb70f243cfe3    MINISTERIO DE COMERCIO, INDUSTRIA Y TURISMO
7   minamb  38a741a34142761e6be457adfb03e901    MINISTERIO DE AMBIENTE, VIVIENDA Y DESARROLLO TERRITORIAL
9   minmin  eda59e20bc12d56769cae49abcdeb1b6    MINISTERIO DE MINAS Y ENERGIA
10  minedu  164009f4f6ca81fe95e7e06195238306    MINISTERIO DE EDUCACION
11  mintra  f45dbd968a9c169527ff250eb1eca4ea    MINISTERIO DE TRANSPORTE
12  armnac  073eb9c6dce01d8af415419a950e6273    ARMADA NACIONAL
13  depnac  eff40901ea1ce73b56abb0604eabf3f1    DEPARTAMENTO NACIONAL DE PLANEACION
14  dirgen  5b42a54fac4cdd8c8fd10d99bb9643b1    DIRECCION GENERAL MARITIMA
15  colcie  5dd4dd2883b23cf597aa309666f46e32    COLCIENCIAS
16  asocol  9b30904bd681a20a1efa6c339bdb090e    ASOCIACION COLOMBIANA DE UNIVERSIDADES
17  dirpar  434c2f1353b026969d850b2d3545383e    DIRECCION PARA LA PREVENCION Y ATENCION DE DESASTRES
18  supdep  18cfa14f1c96aa8d9aee1ffcb7f40fe2    SUPERINTENDENCIA DE PUERTOS
\.


--
-- Data for Name: variables; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY VARIABLES (var_id, var_des, var1, var2, var3, var4, var5, var6, var7, var8, var9, var10, var11, var12, unidades) FROM stdin;
\.


--
-- Name: borrar_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
--

ALTER TABLE ONLY borrar
    ADD CONSTRAINT borrar_pkey PRIMARY KEY (fac_id);


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

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


--
-- Name: indicadores_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
--

ALTER TABLE ONLY indicadores
    ADD CONSTRAINT indicadores_pkey PRIMARY KEY (ind_id);


--
-- Name: lineas_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
--

ALTER TABLE ONLY lineas
    ADD CONSTRAINT lineas_pkey PRIMARY KEY (lin_id);


--
-- Name: pk; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
--

ALTER TABLE ONLY usuario
    ADD CONSTRAINT pk PRIMARY KEY (user_id);


--
-- Name: programas_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
--

ALTER TABLE ONLY programas
    ADD CONSTRAINT programas_pkey PRIMARY KEY (pro_id);


--
-- Name: variables_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
--

ALTER TABLE ONLY VARIABLES
    ADD CONSTRAINT variables_pkey PRIMARY KEY (var_id);


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

::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

. /$$                 /$$            /$$$$$$
.| $$                | $$           /$$__  $$
.| $$       /$$   /$$| $$ /$$$$$$$$| $$  \__/  /$$$$$$   /$$$$$$$  #AntiSec
.| $$      | $$  | $$| $$|____ /$$/|  $$$$$$  /$$__  $$ /$$_____/
.| $$      | $$  | $$| $$   /$$$$/  \____  $$| $$$$$$$$| $$
.| $$      | $$  | $$| $$  /$$__/   /$$  \ $$| $$_____/| $$
.| $$$$$$$$|  $$$$$$/| $$ /$$$$$$$$|  $$$$$$/|  $$$$$$$|  $$$$$$.$
.|________/ \______/ |__/|________/ \______/  \_______/ \_______/   #LulzSec_GT
                          //Riéndome de tu seguridad!