API tools faq
paste
Advertisement
franciscojack

DATA BASE ISPEAK.GOV.CO

franciscojack
Jan 25th, 2013
96
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 15.46 KB | None | 0 0
raw download clone embed print report
  1. -----------------------------DATA DUMP BY FRANCISCOHACK--------------------
  2.  
  3. URL: www.ispeak.gov.co
  4.  
  5.  
  6. --------------------DATA SPEAK--------------
  7.  
  8. F--R--A--N--C---I--S--C--O
  9. | categories_ctg |
  10. | ciudad |
  11. | ciudad_examen |
  12. | cms_banner |
  13. | cms_block |
  14. | cms_block_location H
  15. | cms_category |
  16. | cms_config |
  17. | cms_contact_type |
  18. | cms_content |
  19. | cms_content_type A
  20. | cms_language |
  21. | cms_log |
  22. | cms_plantilla |
  23. | cms_role |
  24. | cms_role_category |
  25. | cms_skin |
  26. | cms_user C
  27. | convocatoria |
  28. | departamento |
  29. | empresa |
  30. | encuesta |
  31. | estado_civil |
  32. | estado_laboral K
  33. | faq |
  34. | faq_category |
  35. | gallery |
  36. | gallery_images |
  37. | institucion |
  38. | link |
  39. | link_category |
  40. | link_category_has_link |
  41. | localidad |
  42. | manufacturers_man |
  43. | news |
  44. | news_type |
  45. | ninos |
  46. | option_opt |
  47. | optionvalue_ova |
  48. | pais |
  49. | paises |
  50. | poll |
  51. | poll_answer |
  52. | poll_ip |
  53. | productoption_pop |
  54. | products_prd |
  55. | programa_estudio |
  56. | reserva |
  57. | sector |
  58. | sector_ptp |
  59. | sedes |
  60. | tags |
  61. | testimonios |
  62. | usberlitz |
  63. | users_usr |
  64. | usoxford |
  65. | usr_experience |
  66. | usr_study |
  67. | usuario |
  68. --------------------------
  69. F--R--A--N--C--I--S--C--O------H---A--C---K----
  70. | Column | Type |
  71. +------------------------------+--------------+
  72. | `presenta_direcci\xd3n` | longtext |
  73. | apellidos | longtext |
  74. | area_desempeno | longtext |
  75. | areaconocimiento | longtext |
  76. | aspiracion | int(5) |
  77. | bachillerato_ano | int(11) |
  78. | bachillerato_ciudad | int(11) |
  79. | bachillerato_colegio | longtext |
  80. | bachillerato_departamento | int(11) |
  81. | bachillerato_pais | int(11) |
  82. | calificacion | longtext |
  83. | calificacion_discapacidad | varchar(3) |
  84. | cargo | varchar(40) |
  85. | celular | longtext |
  86. | certificado | longtext |
  87. | certificado_2012 | tinyint(1) |
  88. | citacion_ano | longtext |
  89. | citacion_diam | longtext |
  90. | citacion_dias | longtext |
  91. | citacion_horaf | longtext |
  92. | citacion_horai | longtext |
  93. | citacion_lugar | longtext |
  94. | citacion_mes | longtext |
  95. | ciudad | int(11) |
  96. | ciudad_certificacion | longtext |
  97. | confirmacion_certificacion | tinyint(1) |
  98. | confirmacion_fecha | datetime |
  99. | convocatoria | int(11) |
  100. | convocatoria_2012 | int(1) |
  101. | correo | varchar(255) |
  102. | correo2 | longtext |
  103. | cuso_grado | int(5) |
  104. | departamento | int(11) |
  105. | direccion_contacto | longtext |
  106. | direccion_contacto2 | longtext |
  107. | discapacidad | longtext |
  108. | disponibilidad_viajar | tinyint(1) |
  109. | documento | bigint(20) |
  110. | emisora | longtext |
  111. | entidad_educativa | varchar(40) |
  112. | estado_civil | int(11) |
  113. | estado_vulnerabilidad | varchar(20) |
  114. | estrato | longtext |
  115. | estudia_actualmente | varchar(3) |
  116. | estudia_bogota | varchar(2) |
  117. | examen_nota | longtext |
  118. | fecha_cert_2012 | date |
  119. | fecha_nacimiento | datetime |
  120. | fecha_preinscripcion | datetime |
  121. | fecha_preinscripcion_2012 | datetime |
  122. | fecha_registro | datetime |
  123. | grupo_etnico | varchar(40) |
  124. | hv_more | longtext |
  125. | ingresos | longtext |
  126. | interesado_sectores | varchar(3) |
  127. | internet | varchar(3) |
  128. | last_apellido | varchar(255) |
  129. | last_nombre | varchar(255) |
  130. | limitacion_restriccion | varchar(3) |
  131. | localidad | int(11) |
  132. | marca | tinyint(1) |
  133. | n_hijos | int(5) |
  134. | n_sisben | varchar(2) |
  135. | niveleducativo | longtext |
  136. | niveleducativo2 | longtext |
  137. | nombre | longtext |
  138. | nombre_acudiente | varchar(40) |
  139. | nombre_empresa | varchar(40) |
  140. | ocupacion | int(11) |
  141. | ocupacion_laboral | varchar(60) |
  142. | orientacion_sexual | varchar(20) |
  143. | p_presencial | varchar(2) |
  144. | posgrado_ano | int(11) |
  145. | posgrado_carrera | longtext |
  146. | posgrado_institucion | longtext |
  147. | posgrado_otras | longtext |
  148. | posgrado_pais | int(11) |
  149. | posgrado_semestres | int(11) |
  150. | posgrado_titulo | tinyint(1) |
  151. | pregunta | longtext |
  152. | pregunta_ib | longtext |
  153. | preinscripcion_2012_completo | int(1) |
  154. | presenta_aula | longtext |
  155. | presenta_certificacion | tinyint(1) |
  156. | presenta_ciudad_examen | longtext |
  157. | presenta_lugar | longtext |
  158. | presentahora | longtext |
  159. | profesional_ano | int(11) |
  160. | profesional_carrera | longtext |
  161. | profesional_ciudad | int(11) |
  162. | profesional_departamento | int(11) |
  163. | profesional_institucion | longtext |
  164. | profesional_nidentificacion | varchar(30) |
  165. | profesional_otras | longtext |
  166. | profesional_pais | int(11) |
  167. | profesional_semestres | int(11) |
  168. | profesional_titulo | tinyint(1) |
  169. | quien_certifica | tinyint(1) |
  170. | recibir_info | tinyint(1) |
  171. | respuesta | longtext |
  172. | se_entero | longtext |
  173. | sector | int(11) |
  174. | sexo | varchar(15) |
  175. | sisben | varchar(3) |
  176. | situacion_laboral | int(11) |
  177. | situacion_vulnerabilidad | varchar(40) |
  178. | tecnologia_ano | int(11) |
  179. | tecnologia_carrera | longtext |
  180. | tecnologia_ciudad | int(11) |
  181. | tecnologia_departamento | int(11) |
  182. | tecnologia_institucion | longtext |
  183. | tecnologia_otras | longtext |
  184. | tecnologia_pais | int(11) |
  185. | tecnologia_semestres | int(11) |
  186. | tecnologia_titulo | tinyint(1) |
  187. | telefono | longtext |
  188. | telefono2 | longtext |
  189. | tiempo_empresa | int(5) |
  190. | tipo_contrato | varchar(40) |
  191. | tipo_documento | varchar(40) |
  192. | trabaja_bogota | varchar(2) |
  193. | trabajaactualmente | longtext |
  194. | uso_licecia | varchar(2) |
  195. | usr_id | int(11) |
  196. | vive_bogota | varchar(2) |
  197. | vivienda | varchar(40) |
  198. +------------------------------+--------------+
  199.  
  200. -----------------50 REGISTROS DE 155828------------
  201.  
  202. +---------------+----------------------------------+
  203. | login_usr | password_usr |
  204. +---------------+----------------------------------+
  205. | <blank> | <blank> |
  206. | 63366966 | b88f2de43596e64eae7e2c666164fcd9 |
  207. | -1012370521 | d51e71eb9682fa5390a92cd3f4671864 |
  208. | -1024526788 | 291d90a34ee831590cef361b478b2ff8 |
  209. | -1032414397 | 2ed13f846729c9ab94398924bc3fa4e9 |
  210. | -1032464547 | b1777b459f3168500508b5029ac7754c |
  211. | -1069742735 | 1feb85d0164b151bb407e33bfe63f811 |
  212. | -1075247985 | 86289805ecd94d0baf7aa466ef855b46 |
  213. | -1094928564 | 39ef9ad71ec06d0d17baf463f5e68176 |
  214. | -1098641994 | 6801e7bb1c9330e26654f02bec2c313c |
  215. | -1114487476 | 6fabc9bbb1c1cd11149daaf07a5061cd |
  216. | -1121327593 | cd90768486de4e493ca64dba8317ec4f |
  217. | -1126965643 | 07494aa4b88f5bea752f2787f689ee45 |
  218. | -1143350806 | 05fe03b494c0f1a7d6cb49f0bf3fd70d |
  219. | -1165202 | a976cafb5d9b6426eaaf48568e9b3095 |
  220. | -21 | 2dafa90991846718182bd6f3b8912033 |
  221. | -33703883 | 48de1fe873f853f40681d100bf5e6532 |
  222. | -34609659 | e8e824cea868713d0b3f9060c40c9ce9 |
  223. | -52204431 | 247a5914d1a2af40437a14654a3f933c |
  224. | -52877492 | e549f9bb9d7e8f56c9cf285494d143be |
  225. | -53030875 | 563fbce453a22a632bcfb3808b7a41a4 |
  226. | -79631768 | 7f974f9197ddaf18b39dad70f9b10b93 |
  227. | -79677130 | 45cf323633984f4e0eb49e7d5b92b328 |
  228. | -80243493 | e6042afc4e2776851200b285fbbeb00c |
  229. | -80766620 | 7f233be19349bfacd597018b45991d28 |
  230. | -95060905232 | 27a6f40c926a7e2c0e3624a3cca8fd3d |
  231. | 0 | 269938d73e27e4385f4a3b5676a036aa |
  232. | 000469656 | 82ae7eb7569c5ffb22d59f5bdeb4367b |
  233. | 002037625 | 8b1c860e4ef726446fddd7b1fc76b84b |
  234. | 00720480 | fb081673d6781dd8f4d9b70fa0e8be5e |
  235. | 01079856029 | f240a4a08ef4d49a9b643168779d8491 |
  236. | 0118426943 | 27d2656eb1f0eea728d81d8eb72ea188 |
  237. | 017563445 | 4c86a51f20f781c6d102296eaeb208fa |
  238. | 0204719546 | 373ae5146e0eb3fd217c722d25e6ca3c |
  239. | 033063252 | 36e5fb3be19a9b36e7186e58859e5440 |
  240. | 035597236 | 2ce1a5b3daf20aff0e429dd28ad43a7d |
  241. | 044480587 | 87e216890583f0ba06c2586cc28adae6 |
  242. | 047295262 | ff88f87232d7abb4933e25b5db11621a |
  243. | 054244830 | 35227eb95aa33accab94bd9f7741028a |
  244. | 06 | 99fb32a8635349772dcfc5e7cead5c41 |
  245. | 0604099190629 | e9d86072d4e6287995fbb2e756762f41 |
  246. | 06080024012 | 68182c2adcfc33c4161bbbbb8831afe6 |
  247. | 06248056 | f696b2acb7856436d20ed58f169d915b |
  248. | 067891502 | fac86fb4161435e9057a7cba4a34efce |
  249. | 07052318800 | 88cdb953ff5ede7323f465c06eeed5a8 |
  250. | 07129862567 | 74632494e72df01a6bd6b215c68ffb17 |
  251. | 1 | 6d071901727aec1ba6d8e2497ef5b709 |
  252. | 10.095 | b4e8a3664355a411ca09c6116872a3af |
  253. | 1000000000 | 20be525ade2efa431bf676a87b30426d |
  254. | 1000000001 | 54b8ede4bc203893e34f74cf0dbe2168 |
  255. +---------------+----------------------------------+
  256.  
  257. --------------------------MYSQL DATA BASE -------------------------------
  258.  
  259. +---------------------------+
  260. | columns_priv |
  261. | db |
  262. | event |
  263. | func |
  264. | general_log |
  265. | help_category |
  266. | help_keyword |
  267. | help_relation |
  268. | help_topic |
  269. | host |
  270. | ndb_binlog_index |
  271. | plugin |
  272. | proc |
  273. | procs_priv |
  274. | proxies_priv |
  275. | servers |
  276. | slow_log |
  277. | tables_priv |
  278. | time_zone |
  279. | time_zone_leap_second |
  280. | time_zone_name |
  281. | time_zone_transition |
  282. | time_zone_transition_type |
  283. | user |
  284. +---------------------------+
  285.  
  286. +------------------------+-----------------------------------+
  287. | Column | Type |
  288. +------------------------+-----------------------------------+
  289. | Alter_priv | enum('N','Y') |
  290. | Alter_routine_priv | enum('N','Y') |
  291. | authentication_string | text |
  292. | Create_priv | enum('N','Y') |
  293. | Create_routine_priv | enum('N','Y') |
  294. | Create_tablespace_priv | enum('N','Y') |
  295. | Create_tmp_table_priv | enum('N','Y') |
  296. | Create_user_priv | enum('N','Y') |
  297. | Create_view_priv | enum('N','Y') |
  298. | Delete_priv | enum('N','Y') |
  299. | Drop_priv | enum('N','Y') |
  300. | Event_priv | enum('N','Y') |
  301. | Execute_priv | enum('N','Y') |
  302. | File_priv | enum('N','Y') |
  303. | Grant_priv | enum('N','Y') |
  304. | Host | char(60) |
  305. | Index_priv | enum('N','Y') |
  306. | Insert_priv | enum('N','Y') |
  307. | Lock_tables_priv | enum('N','Y') |
  308. | max_connections | int(11) unsigned |
  309. | max_questions | int(11) unsigned |
  310. | max_updates | int(11) unsigned |
  311. | max_user_connections | int(11) unsigned |
  312. | Password | char(41) |
  313. | plugin | char(64) |
  314. | Process_priv | enum('N','Y') |
  315. | References_priv | enum('N','Y') |
  316. | Reload_priv | enum('N','Y') |
  317. | Repl_client_priv | enum('N','Y') |
  318. | Repl_slave_priv | enum('N','Y') |
  319. | Select_priv | enum('N','Y') |
  320. | Show_db_priv | enum('N','Y') |
  321. | Show_view_priv | enum('N','Y') |
  322. | Shutdown_priv | enum('N','Y') |
  323. | ssl_cipher | blob |
  324. | ssl_type | enum('','ANY','X509','SPECIFIED') |
  325. | Super_priv | enum('N','Y') |
  326. | Trigger_priv | enum('N','Y') |
  327. | Update_priv | enum('N','Y') |
  328. | User | char(16) |
  329. | x509_issuer | blob |
  330. | x509_subject | blob |
  331. +------------------------+-----------------------------------+
  332.  
  333. +------------------+-------------------------------------------+
  334. | User | Password |
  335. +------------------+-------------------------------------------+
  336. | bdpagweb | *DA498D0BBC9E9FFA2B7428AC240D8E88AA76E04C |
  337. | bdpagweb | *DA498D0BBC9E9FFA2B7428AC240D8E88AA76E04C |
  338. | bdpagweb | *DA498D0BBC9E9FFA2B7428AC240D8E88AA76E04C |
  339. | debian-sys-maint | *9E55BCE39A7134EBFC7B958D27BBF266F37A8D8A |
  340. | root | *8E7F78D22130CB1121C88EEE47971B3C0C21E606 |
  341. | root | *8E7F78D22130CB1121C88EEE47971B3C0C21E606 |
  342. | root | *8E7F78D22130CB1121C88EEE47971B3C0C21E606 |
  343. | root | *1E4EE31D61A2E54B26DADE5158FC9F629276EAE4 |
  344. +------------------+-------------------------------------------+
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!