Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- **** HONDURAN ELECTION RESULT DATABASE LEAKS ****
- **** DATABASE COULD BE ACCESSED AND MODIFIED FROM ANYWHERE WITH NO PASSWORD ***
- **** #StopFraudeHn
- sigelec_escrutinio_2013_1=# \d+ votos_detalle
- Table "public.votos_detalle"
- Column | Type | Modifiers | Storage | Stats target | Description
- -----------------+---------+-----------+---------+--------------+-------------
- votosdetalle_id | integer | not null | plain | |
- candidato_id | integer | | plain | |
- acta_llave | integer | | plain | |
- etapa_llave | integer | | plain | |
- votos | integer | not null | plain | |
- flag_cambios | integer | not null | plain | |
- Indexes:
- "votos_detalle_pkey" PRIMARY KEY, btree (votosdetalle_id)
- "bg_etapa_acta_llave" btree (acta_llave, etapa_llave)
- "etapa_votos_index" btree (acta_llave, etapa_llave)
- "etapa_votos_index_c" btree (acta_llave, candidato_id, etapa_llave)
- "idx_79c9d51a60d8e007" btree (acta_llave)
- "idx_79c9d51aa26d6f37" btree (etapa_llave)
- "idx_79c9d51afe0067e5" btree (candidato_id)
- Foreign-key constraints:
- "fk_79c9d51a60d8e007" FOREIGN KEY (acta_llave) REFERENCES acta(acta_llave)
- "fk_79c9d51aa26d6f37" FOREIGN KEY (etapa_llave) REFERENCES etapa(etapa_llave)
- "fk_79c9d51afe0067e5" FOREIGN KEY (candidato_id) REFERENCES candidato(candidato_id)
- Has OIDs: no
- sigelec_escrutinio_2013_1=# \d+ candidato20131029
- Table "public.candidato20131029"
- Column | Type | Modifiers | Storage | Stats target | Description
- --------------------+------------------------+-----------+----------+--------------+-------------
- candidato_id | integer | | plain | |
- cargoelectoral_id | integer | | plain | |
- censo_id | integer | | plain | |
- evento_id | integer | | plain | |
- lugargeo_id | integer | | plain | |
- movimiento_id | integer | | plain | |
- numero | character varying(20) | | extended | |
- candidatopadre_id | integer | | plain | |
- descripcion | character varying(100) | | extended | |
- presento_constacia | boolean | | plain | |
- foto | character varying(100) | | extended | |
- primer_nombre | character varying(100) | | extended | |
- segundo_nombre | character varying(100) | | extended | |
- primer_apellido | character varying(100) | | extended | |
- segundo_apellido | character varying(100) | | extended | |
- numero_identidad | character varying(20) | | extended | |
- codigo_sexo | character varying(1) | | extended | |
- tse_posicion | integer | | plain | |
- tse_sorteo | integer | | plain | |
- Has OIDs: no
- sigelec_escrutinio_2013_1=# \d+ votos
- Table "public.votos"
- Column | Type | Modifiers | Storage | Stats target | Description
- ------------------+---------+----------------------------------------------------------+---------+--------------+-------------
- votos_id | integer | not null default nextval('votos_votos_id_seq'::regclass) | plain | |
- candidato_id | integer | | plain | |
- acta_llave | integer | | plain | |
- votos | integer | not null | plain | |
- votos_captura | integer | not null default 0 | plain | |
- votos_verif1 | integer | not null default 0 | plain | |
- votos_verif2 | integer | not null default 0 | plain | |
- flag_cambios | integer | not null default 0 | plain | |
- votos_icr | integer | not null default 0 | plain | |
- votos_omr | integer | not null default 0 | plain | |
- votos_correccion | integer | not null default 0 | plain | |
- votos_auditoria | integer | not null | plain | |
- Indexes:
- "votos_pkey" PRIMARY KEY, btree (votos_id)
- "idx_ab64924560d8e007" btree (acta_llave)
- "idx_ab649245fe0067e5" btree (candidato_id)
- Foreign-key constraints:
- "fk_ab64924560d8e007" FOREIGN KEY (acta_llave) REFERENCES acta(acta_llave)
- "fk_ab649245fe0067e5" FOREIGN KEY (candidato_id) REFERENCES candidato(candidato_id)
- Has OIDs: no
- List of relations
- Schema | Name | Type | Owner
- --------+-------------------------------+-------+----------
- public | acl_classes | table | postgres
- public | acl_entries | table | postgres
- public | acl_object_identities | table | postgres
- public | acl_object_identity_ancestors | table | postgres
- public | acl_security_identities | table | postgres
- public | acta | table | postgres
- public | acta_estado_proceso | table | postgres
- public | acta_etapa_flujo | table | postgres
- public | acta_etapa_imagen | table | postgres
- public | actor_flujo | table | postgres
- public | agregacion_data_etapa | table | postgres
- public | agregacion_data_etapa_etapa | table | postgres
- public | agregacion_im_etapa_etapa | table | postgres
- public | agregacion_mesa_usuario | table | postgres
- public | agregacion_vali_etapa_etapa | table | postgres
- public | aldeas | table | postgres
- public | archivo_trep | table | postgres
- public | area | table | postgres
- public | balance_general | table | postgres
- public | bitacora_flujo | table | postgres
- public | bundle_actual | table | postgres
- public | cache_formacaptura | table | postgres
- public | cache_formacaptura20131029 | table | postgres
- public | candidato | table | postgres
- public | candidato20131029 | table | postgres
- public | candidato_new | table | postgres
- public | cargaelectoral | table | postgres
- public | cargoelectoral | table | postgres
- public | caserios | table | postgres
- public | censo | table | postgres
- public | centrosvotacion | table | postgres
- public | conteorapido | table | postgres
- public | custodio | table | postgres
- public | db | table | postgres
- public | departamento | table | postgres
- public | estado_flujo | table | postgres
- public | estatus_habilitado | table | postgres
- public | estatus_identidad | table | postgres
- public | etapa | table | postgres
- public | etapa_tareas_flujo | table | postgres
- public | evento | table | postgres
- public | evento_global | table | postgres
- public | fos_user | table | postgres
- public | fos_user_group | table | postgres
- public | fos_user_user_group | table | postgres
- public | fuente_informacion | table | postgres
- public | hisotrico_reproceso | table | postgres
- public | historico_acta | table | postgres
- public | historico_votos_detalle | table | postgres
- public | historicoacta_etapa_flujo | table | postgres
- public | historicoacta_imagen_flujo | table | postgres
- public | historicobalance_general | table | postgres
- public | integracion_candidato | table | postgres
- public | integracion_candidato_empate | table | postgres
- public | lugares_poblados | table | postgres
- public | lugargeo | table | postgres
- public | maleta_electoral | table | postgres
- public | maleta_estado_proceso | table | postgres
- public | maleta_etapa_flujo | table | postgres
- public | medir_acta | table | postgres
- public | medir_acta_captura | table | postgres
- public | mesa_electoral | table | postgres
- public | movimiento | table | postgres
- public | municipio | table | postgres
- public | nivelelectoral | table | postgres
- public | papeleta | table | postgres
- public | partido | table | postgres
- public | posicionmovimiento | table | postgres
- public | proceso | table | postgres
- public | proceso_auditoria | table | postgres
- public | proceso_correccion | table | postgres
- public | proceso_icr | table | postgres
- public | proceso_manual | table | postgres
- public | proceso_monitoreo | table | postgres
- public | proceso_transcripcion | table | postgres
- public | proceso_validacion_flujo | table | postgres
- public | requirimiento_departamental | table | postgres
- public | requirimiento_municipal | table | postgres
- public | resumenvotos | table | postgres
- public | reubicacionlugarespoblados | table | postgres
- public | sectores | table | postgres
- public | sexo | table | postgres
- public | sincronizacion | table | postgres
- public | sincronizacion_actas | table | postgres
- public | spatial_ref_sys | table | postgres
- public | subproceso | table | postgres
- public | tarea_flujo | table | postgres
- public | tblrescvxpp | table | postgres
- public | tblrescvxpp_alcalde | table | postgres
- public | tblrescvxpp_diputado | table | postgres
- public | tblresdepxpp | table | postgres
- public | tblresdepxpp_alcalde | table | postgres
- public | tblresdepxpp_diputado | table | postgres
- public | tblresmunxpp | table | postgres
- public | tblresmunxpp_alcalde | table | postgres
- public | tblresmunxpp_diputado | table | postgres
- public | tblresnacionalxpp | table | postgres
- public | tblresnacionalxpp_alcalde | table | postgres
- public | tblresnacionalxpp_diputado | table | postgres
- public | telefonos_electorales | table | postgres
- public | tipo_objeto | table | postgres
- public | transmision_mesa | table | postgres
- public | tsecandidatos20131028 | table | postgres
- public | usuario_bitacora_flujo | table | postgres
- public | usuario_mesa | table | postgres
- public | usuariomesa_etapa_flujo | table | postgres
- public | validacion_data_etapa | table | postgres
- public | validacion_data_etapa_etapa | table | postgres
- public | validacion_etapa_flujo | table | postgres
- public | validacion_flujo_etapa_many | table | postgres
- public | validaciones | table | postgres
- public | validaciones_flujo | table | postgres
- public | votos | table | postgres
- public | votos_detalle | table | postgres
- public | workflow_maleta_electoral | table | postgres
- public | z7actasenproceso | table | postgres
- public | z7declaratoriabloque | table | postgres
- public | z7declaratoriabloqueempate | table | postgres
- (118 rows)
- sigelec_escrutinio_2013_1=# select candidato_id, primer_apellido from candidato where primer_nombre like 'MAURICIO%';
- candidato_id | primer_apellido
- --------------+-----------------
- 82129 | TURCIOS
- 85017 | MARTINEZ
- 97135 | MIDENCE
- 110986 | TEJADA
- 83002 | SILVA
- 111260 | CASTELLANOS
- 144764 | SANCHEZ
- 79401 | BONILLA
- 78505 | SUAREZ
- 82690 | RIVERA
- 109096 | BETANCOURTH
- 97795 | MEDINA
- 87267 | AMADOR
- 89008 | GARCIA
- 109184 | RODRIGUEZ
- 77941 | OLIVA
- 80770 | HUETE
- 83035 | AREVALO
- 109273 | SORIANO
- 78479 | MONTOYA
- 77036 | VILLEDA
- 85146 | RAMIREZ
- 110489 | LARA
- 98413 | RIVERA
- 87379 | MURCIA
- 77934 | SUAZO
- 82433 | MEDINA
- 84306 | ARAQUE
- (28 rows)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement