Guest User

HONDURAS FRAUD

a guest
Nov 24th, 2013
4,837
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. **** HONDURAN ELECTION RESULT DATABASE LEAKS ****
  2. **** DATABASE COULD BE ACCESSED AND MODIFIED FROM ANYWHERE WITH NO PASSWORD ***
  3. **** #StopFraudeHn
  4.  
  5.  
  6.  
  7. sigelec_escrutinio_2013_1=# \d+ votos_detalle
  8. Table "public.votos_detalle"
  9. Column | Type | Modifiers | Storage | Stats target | Description
  10. -----------------+---------+-----------+---------+--------------+-------------
  11. votosdetalle_id | integer | not null | plain | |
  12. candidato_id | integer | | plain | |
  13. acta_llave | integer | | plain | |
  14. etapa_llave | integer | | plain | |
  15. votos | integer | not null | plain | |
  16. flag_cambios | integer | not null | plain | |
  17. Indexes:
  18. "votos_detalle_pkey" PRIMARY KEY, btree (votosdetalle_id)
  19. "bg_etapa_acta_llave" btree (acta_llave, etapa_llave)
  20. "etapa_votos_index" btree (acta_llave, etapa_llave)
  21. "etapa_votos_index_c" btree (acta_llave, candidato_id, etapa_llave)
  22. "idx_79c9d51a60d8e007" btree (acta_llave)
  23. "idx_79c9d51aa26d6f37" btree (etapa_llave)
  24. "idx_79c9d51afe0067e5" btree (candidato_id)
  25. Foreign-key constraints:
  26. "fk_79c9d51a60d8e007" FOREIGN KEY (acta_llave) REFERENCES acta(acta_llave)
  27. "fk_79c9d51aa26d6f37" FOREIGN KEY (etapa_llave) REFERENCES etapa(etapa_llave)
  28. "fk_79c9d51afe0067e5" FOREIGN KEY (candidato_id) REFERENCES candidato(candidato_id)
  29. Has OIDs: no
  30.  
  31. sigelec_escrutinio_2013_1=# \d+ candidato20131029
  32. Table "public.candidato20131029"
  33. Column | Type | Modifiers | Storage | Stats target | Description
  34. --------------------+------------------------+-----------+----------+--------------+-------------
  35. candidato_id | integer | | plain | |
  36. cargoelectoral_id | integer | | plain | |
  37. censo_id | integer | | plain | |
  38. evento_id | integer | | plain | |
  39. lugargeo_id | integer | | plain | |
  40. movimiento_id | integer | | plain | |
  41. numero | character varying(20) | | extended | |
  42. candidatopadre_id | integer | | plain | |
  43. descripcion | character varying(100) | | extended | |
  44. presento_constacia | boolean | | plain | |
  45. foto | character varying(100) | | extended | |
  46. primer_nombre | character varying(100) | | extended | |
  47. segundo_nombre | character varying(100) | | extended | |
  48. primer_apellido | character varying(100) | | extended | |
  49. segundo_apellido | character varying(100) | | extended | |
  50. numero_identidad | character varying(20) | | extended | |
  51. codigo_sexo | character varying(1) | | extended | |
  52. tse_posicion | integer | | plain | |
  53. tse_sorteo | integer | | plain | |
  54. Has OIDs: no
  55.  
  56. sigelec_escrutinio_2013_1=# \d+ votos
  57. Table "public.votos"
  58. Column | Type | Modifiers | Storage | Stats target | Description
  59. ------------------+---------+----------------------------------------------------------+---------+--------------+-------------
  60. votos_id | integer | not null default nextval('votos_votos_id_seq'::regclass) | plain | |
  61. candidato_id | integer | | plain | |
  62. acta_llave | integer | | plain | |
  63. votos | integer | not null | plain | |
  64. votos_captura | integer | not null default 0 | plain | |
  65. votos_verif1 | integer | not null default 0 | plain | |
  66. votos_verif2 | integer | not null default 0 | plain | |
  67. flag_cambios | integer | not null default 0 | plain | |
  68. votos_icr | integer | not null default 0 | plain | |
  69. votos_omr | integer | not null default 0 | plain | |
  70. votos_correccion | integer | not null default 0 | plain | |
  71. votos_auditoria | integer | not null | plain | |
  72. Indexes:
  73. "votos_pkey" PRIMARY KEY, btree (votos_id)
  74. "idx_ab64924560d8e007" btree (acta_llave)
  75. "idx_ab649245fe0067e5" btree (candidato_id)
  76. Foreign-key constraints:
  77. "fk_ab64924560d8e007" FOREIGN KEY (acta_llave) REFERENCES acta(acta_llave)
  78. "fk_ab649245fe0067e5" FOREIGN KEY (candidato_id) REFERENCES candidato(candidato_id)
  79. Has OIDs: no
  80.  
  81.  
  82.  
  83. List of relations
  84. Schema | Name | Type | Owner
  85. --------+-------------------------------+-------+----------
  86. public | acl_classes | table | postgres
  87. public | acl_entries | table | postgres
  88. public | acl_object_identities | table | postgres
  89. public | acl_object_identity_ancestors | table | postgres
  90. public | acl_security_identities | table | postgres
  91. public | acta | table | postgres
  92. public | acta_estado_proceso | table | postgres
  93. public | acta_etapa_flujo | table | postgres
  94. public | acta_etapa_imagen | table | postgres
  95. public | actor_flujo | table | postgres
  96. public | agregacion_data_etapa | table | postgres
  97. public | agregacion_data_etapa_etapa | table | postgres
  98. public | agregacion_im_etapa_etapa | table | postgres
  99. public | agregacion_mesa_usuario | table | postgres
  100. public | agregacion_vali_etapa_etapa | table | postgres
  101. public | aldeas | table | postgres
  102. public | archivo_trep | table | postgres
  103. public | area | table | postgres
  104. public | balance_general | table | postgres
  105. public | bitacora_flujo | table | postgres
  106. public | bundle_actual | table | postgres
  107. public | cache_formacaptura | table | postgres
  108. public | cache_formacaptura20131029 | table | postgres
  109. public | candidato | table | postgres
  110. public | candidato20131029 | table | postgres
  111. public | candidato_new | table | postgres
  112. public | cargaelectoral | table | postgres
  113. public | cargoelectoral | table | postgres
  114. public | caserios | table | postgres
  115. public | censo | table | postgres
  116. public | centrosvotacion | table | postgres
  117. public | conteorapido | table | postgres
  118. public | custodio | table | postgres
  119. public | db | table | postgres
  120. public | departamento | table | postgres
  121. public | estado_flujo | table | postgres
  122. public | estatus_habilitado | table | postgres
  123. public | estatus_identidad | table | postgres
  124. public | etapa | table | postgres
  125. public | etapa_tareas_flujo | table | postgres
  126. public | evento | table | postgres
  127. public | evento_global | table | postgres
  128. public | fos_user | table | postgres
  129. public | fos_user_group | table | postgres
  130. public | fos_user_user_group | table | postgres
  131. public | fuente_informacion | table | postgres
  132. public | hisotrico_reproceso | table | postgres
  133. public | historico_acta | table | postgres
  134. public | historico_votos_detalle | table | postgres
  135. public | historicoacta_etapa_flujo | table | postgres
  136. public | historicoacta_imagen_flujo | table | postgres
  137. public | historicobalance_general | table | postgres
  138. public | integracion_candidato | table | postgres
  139. public | integracion_candidato_empate | table | postgres
  140. public | lugares_poblados | table | postgres
  141. public | lugargeo | table | postgres
  142. public | maleta_electoral | table | postgres
  143. public | maleta_estado_proceso | table | postgres
  144. public | maleta_etapa_flujo | table | postgres
  145. public | medir_acta | table | postgres
  146. public | medir_acta_captura | table | postgres
  147. public | mesa_electoral | table | postgres
  148. public | movimiento | table | postgres
  149. public | municipio | table | postgres
  150. public | nivelelectoral | table | postgres
  151. public | papeleta | table | postgres
  152. public | partido | table | postgres
  153. public | posicionmovimiento | table | postgres
  154. public | proceso | table | postgres
  155. public | proceso_auditoria | table | postgres
  156. public | proceso_correccion | table | postgres
  157. public | proceso_icr | table | postgres
  158. public | proceso_manual | table | postgres
  159. public | proceso_monitoreo | table | postgres
  160. public | proceso_transcripcion | table | postgres
  161. public | proceso_validacion_flujo | table | postgres
  162. public | requirimiento_departamental | table | postgres
  163. public | requirimiento_municipal | table | postgres
  164. public | resumenvotos | table | postgres
  165. public | reubicacionlugarespoblados | table | postgres
  166. public | sectores | table | postgres
  167. public | sexo | table | postgres
  168. public | sincronizacion | table | postgres
  169. public | sincronizacion_actas | table | postgres
  170. public | spatial_ref_sys | table | postgres
  171. public | subproceso | table | postgres
  172. public | tarea_flujo | table | postgres
  173. public | tblrescvxpp | table | postgres
  174. public | tblrescvxpp_alcalde | table | postgres
  175. public | tblrescvxpp_diputado | table | postgres
  176. public | tblresdepxpp | table | postgres
  177. public | tblresdepxpp_alcalde | table | postgres
  178. public | tblresdepxpp_diputado | table | postgres
  179. public | tblresmunxpp | table | postgres
  180. public | tblresmunxpp_alcalde | table | postgres
  181. public | tblresmunxpp_diputado | table | postgres
  182. public | tblresnacionalxpp | table | postgres
  183. public | tblresnacionalxpp_alcalde | table | postgres
  184. public | tblresnacionalxpp_diputado | table | postgres
  185. public | telefonos_electorales | table | postgres
  186. public | tipo_objeto | table | postgres
  187. public | transmision_mesa | table | postgres
  188. public | tsecandidatos20131028 | table | postgres
  189. public | usuario_bitacora_flujo | table | postgres
  190. public | usuario_mesa | table | postgres
  191. public | usuariomesa_etapa_flujo | table | postgres
  192. public | validacion_data_etapa | table | postgres
  193. public | validacion_data_etapa_etapa | table | postgres
  194. public | validacion_etapa_flujo | table | postgres
  195. public | validacion_flujo_etapa_many | table | postgres
  196. public | validaciones | table | postgres
  197. public | validaciones_flujo | table | postgres
  198. public | votos | table | postgres
  199. public | votos_detalle | table | postgres
  200. public | workflow_maleta_electoral | table | postgres
  201. public | z7actasenproceso | table | postgres
  202. public | z7declaratoriabloque | table | postgres
  203. public | z7declaratoriabloqueempate | table | postgres
  204. (118 rows)
  205.  
  206. sigelec_escrutinio_2013_1=# select candidato_id, primer_apellido from candidato where primer_nombre like 'MAURICIO%';
  207. candidato_id | primer_apellido
  208. --------------+-----------------
  209. 82129 | TURCIOS
  210. 85017 | MARTINEZ
  211. 97135 | MIDENCE
  212. 110986 | TEJADA
  213. 83002 | SILVA
  214. 111260 | CASTELLANOS
  215. 144764 | SANCHEZ
  216. 79401 | BONILLA
  217. 78505 | SUAREZ
  218. 82690 | RIVERA
  219. 109096 | BETANCOURTH
  220. 97795 | MEDINA
  221. 87267 | AMADOR
  222. 89008 | GARCIA
  223. 109184 | RODRIGUEZ
  224. 77941 | OLIVA
  225. 80770 | HUETE
  226. 83035 | AREVALO
  227. 109273 | SORIANO
  228. 78479 | MONTOYA
  229. 77036 | VILLEDA
  230. 85146 | RAMIREZ
  231. 110489 | LARA
  232. 98413 | RIVERA
  233. 87379 | MURCIA
  234. 77934 | SUAZO
  235. 82433 | MEDINA
  236. 84306 | ARAQUE
  237. (28 rows)
RAW Paste Data