API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jul 4th, 2017
3,851
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 34.08 KB | None | 0 0
raw download clone embed print report
  1. -- phpMyAdmin SQL Dump
  2. -- version 4.6.5.2
  3. -- https://www.phpmyadmin.net/
  4. --
  5. -- Servidor: 127.0.0.1
  6. -- Tiempo de generación: 04-07-2017 a las 20:41:18
  7. -- Versión del servidor: 10.1.21-MariaDB
  8. -- Versión de PHP: 5.6.30
  9.  
  10. SET FOREIGN_KEY_CHECKS=0;
  11. SET time_zone = "+00:00";
  12.  
  13.  
  14. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  15. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  16. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  17. /*!40101 SET NAMES utf8mb4 */;
  18.  
  19. --
  20. -- Base de datos: "intl_trading"
  21. --
  22.  
  23. --
  24. -- Volcado de datos para la tabla "backend_permisos"
  25. --
  26.  
  27. SET IDENTITY_INSERT "backend_permisos" ON ;
  28. INSERT INTO "backend_permisos" ("id", "backend_permisos_nombre", "created_at", "updated_at", "deleted_at") VALUES
  29. (1, 'Gerencia', NULL, NULL, NULL),
  30. (2, 'Tesorería', NULL, NULL, NULL),
  31. (3, 'Cuentas Bancarias', NULL, NULL, NULL),
  32. (4, 'Gestión Fondos', NULL, NULL, NULL),
  33. (5, 'Gestión de Internos', NULL, NULL, NULL);
  34.  
  35. SET IDENTITY_INSERT "backend_permisos" OFF;
  36.  
  37. --
  38. -- Volcado de datos para la tabla "backend_permiso_usuario"
  39. --
  40.  
  41. SET IDENTITY_INSERT "backend_permiso_usuario" ON ;
  42. INSERT INTO "backend_permiso_usuario" ("id", "permiso_id", "usuario_id", "created_at", "updated_at") VALUES
  43. (1, 1, 1, NULL, NULL),
  44. (3, 2, 1, NULL, NULL),
  45. (4, 2, 2, NULL, NULL),
  46. (5, 3, 2, NULL, NULL),
  47. (6, 1, 3, NULL, NULL),
  48. (7, 3, 3, NULL, NULL),
  49. (15, 4, 6, NULL, NULL),
  50. (16, 2, 7, NULL, NULL),
  51. (17, 3, 1, NULL, NULL),
  52. (18, 2, 3, NULL, NULL),
  53. (19, 2, 8, NULL, NULL),
  54. (20, 3, 8, NULL, NULL),
  55. (21, 2, 9, NULL, NULL),
  56. (22, 2, 6, NULL, NULL);
  57.  
  58. SET IDENTITY_INSERT "backend_permiso_usuario" OFF;
  59.  
  60. --
  61. -- Volcado de datos para la tabla "backend_users"
  62. --
  63.  
  64. SET IDENTITY_INSERT "backend_users" ON ;
  65. INSERT INTO "backend_users" ("id", "backend_users_nombre", "backend_users_email", "backend_users_username", "password", "backend_users_bloqueado", "remember_token", "last_login", "created_at", "updated_at", "deleted_at", "backend_users_apellido") VALUES
  66. (1, 'Super', 'super@intl.com', 'superadmin', '$2y$10$b/vBuVxA.vrRdX6PKEZZ1uiAZTkbzk6UYDAANU/hCm.znT7TE5o0.', 0, '0v3VB3R2s4B6S9VSui8toXJJCKRp9uTv0NW3XmvezthiNkjD97yu18FXH324', '2017-07-04 14:10:20', '2017-05-10 18:47:16', '2017-07-04 17:10:20', NULL, 'Admin'),
  67. (2, 'Alejandro', 'aleponzo1@gmail.com', 'alelnro1', '$2y$10$R7oQnhaSoSdZR1BMOMJ8kukAglS1kDB3my.r9WQm11W/Lgv/.bJqm', 0, NULL, NULL, '2017-05-12 13:03:35', '2017-05-16 12:27:31', NULL, 'Ponzo'),
  68. (3, 'Leonel', '@\'leonelavila@doublepoint.com.ar', '@\'leoavila', '$2y$10$s7yVAy4KaxqDbOnyRIXclev7pYABh/g2o.8PfkbF4Top0n66v22Nu', 0, NULL, NULL, '2017-05-12 13:46:20', '2017-05-16 17:46:34', '2017-05-16 17:46:34', 'Avilaa'),
  69. (6, 'Nicolas', 'nicolasboido@intl.com', 'nicoboidi', '$2y$10$W0KLiPHZLuYy4HpjkykVBOurqGIUkv1nKiz4QLuEDF5Aon6V646Nq', 0, NULL, NULL, '2017-05-12 15:21:25', '2017-06-01 15:28:08', NULL, 'Boidi'),
  70. (7, 'asd', '@\'asd@asd.com', '@\'asd', '$2y$10$yhG0Z2HiXPosM.WdtlFP2ew1YhjPDHrL0M7gHB4B7qlYOCuVhuls.', 0, NULL, NULL, '2017-05-12 15:23:37', '2017-05-12 15:23:43', '2017-05-12 15:23:43', 'asd'),
  71. (8, 'asdd', '@\'1495458885_aleponzo1@gmail.com', '@\'1495458885_asd', '$2y$10$Ygk7xAFFTGjLwNf5m.RLSe1akbQZA5oLM/70/SWp2Hf8.FeJZ6R0y', 0, NULL, NULL, '2017-05-22 13:13:10', '2017-05-22 13:14:45', '2017-05-22 13:14:45', 'asd'),
  72. (9, 'mauro', '@\'1495458911_mauro@gmail.com', '@\'1495458911_asd', '$2y$10$2FL7OFZpmkFpb5EZ9mKb7um24HAIXJzVVD/IrrsjAbiaNfdP4ZFYG', 0, NULL, NULL, '2017-05-22 13:15:07', '2017-05-22 13:15:11', '2017-05-22 13:15:11', 'Mazzara');
  73.  
  74. SET IDENTITY_INSERT "backend_users" OFF;
  75.  
  76. --
  77. -- Volcado de datos para la tabla "bancos"
  78. --
  79.  
  80. SET IDENTITY_INSERT "bancos" ON ;
  81. INSERT INTO "bancos" ("id", "nombre", "habilitado", "created_at", "updated_at", "deleted_at") VALUES
  82. (1, 'AMERICAN EXPRESS BANK LTD. SOCIEDAD ANON', 1, NULL, NULL, NULL),
  83. (2, 'BACS BANCO DE CREDITO Y SECURITIZACION S', 1, NULL, NULL, NULL),
  84. (3, 'BANCO BICA S.A.', 1, NULL, NULL, NULL),
  85. (4, 'BANCO BRADESCO ARGENTINA S.A.', 1, NULL, NULL, NULL),
  86. (5, 'BANCO CETELEM ARGENTINA S.A.', 1, NULL, NULL, NULL),
  87. (6, 'BANCO CMF S.A.', 1, NULL, NULL, NULL),
  88. (7, 'BANCO COLUMBIA S.A.', 1, NULL, NULL, NULL),
  89. (8, 'BANCO COMAFI SOCIEDAD ANONIMA', 1, NULL, NULL, NULL),
  90. (9, 'BANCO CREDICOOP COOPERATIVO LIMITADO', 1, NULL, NULL, NULL),
  91. (10, 'BANCO DE CORRIENTES S.A.', 1, NULL, NULL, NULL),
  92. (11, 'BANCO DE GALICIA Y BUENOS AIRES S.A.', 1, NULL, NULL, NULL),
  93. (12, 'BANCO DE INVERSION Y COMERCIO EXTERIOR S.A.', 1, NULL, NULL, NULL),
  94. (13, 'BANCO DE LA CIUDAD DE BUENOS AIRES', 1, NULL, NULL, NULL),
  95. (14, 'BANCO DE LA NACION ARGENTINA', 1, NULL, NULL, NULL),
  96. (15, 'BANCO DE LA PAMPA SOCIEDAD DE ECONOMÍA MIXTA', 1, NULL, NULL, NULL),
  97. (16, 'BANCO DE LA PROVINCIA DE BUENOS AIRES', 1, NULL, NULL, NULL),
  98. (17, 'BANCO DE LA PROVINCIA DE CORDOBA S.A.', 1, NULL, NULL, NULL),
  99. (18, 'BANCO DE LA REPUBLICA ORIENTAL DEL URUGUAY', 1, NULL, NULL, NULL),
  100. (19, 'BANCO DE SAN JUAN S.A.', 1, NULL, NULL, NULL),
  101. (20, 'BANCO DE SANTA CRUZ S.A.', 1, NULL, NULL, NULL),
  102. (21, 'BANCO DE SANTIAGO DEL ESTERO S.A.', 1, NULL, NULL, NULL),
  103. (22, 'BANCO DE SERVICIOS FINANCIEROS S.A.', 1, NULL, NULL, NULL),
  104. (23, 'BANCO DE SERVICIOS Y TRANSACCIONES S.A.', 1, NULL, NULL, NULL),
  105. (24, 'BANCO DE VALORES S.A.', 1, NULL, NULL, NULL),
  106. (25, 'BANCO DEL CHUBUT S.A.', 1, NULL, NULL, NULL),
  107. (26, 'BANCO DEL SOL S.A.', 1, NULL, NULL, NULL),
  108. (27, 'BANCO DEL TUCUMAN S.A.', 1, NULL, NULL, NULL),
  109. (28, 'BANCO DO BRASIL S.A.', 1, NULL, NULL, NULL),
  110. (29, 'BANCO FINANSUR S.A.', 1, NULL, NULL, NULL),
  111. (30, 'BANCO HIPOTECARIO S.A.', 1, NULL, NULL, NULL),
  112. (31, 'BANCO INDUSTRIAL S.A.', 1, NULL, NULL, NULL),
  113. (32, 'BANCO INTERFINANZAS S.A.', 1, NULL, NULL, NULL),
  114. (33, 'BANCO ITAU ARGENTINA S.A.', 1, NULL, NULL, NULL),
  115. (34, 'BANCO JULIO SOCIEDAD ANONIMA', 1, NULL, NULL, NULL),
  116. (35, 'BANCO MACRO S.A.', 1, NULL, NULL, NULL),
  117. (36, 'BANCO MARIVA S.A.', 1, NULL, NULL, NULL),
  118. (37, 'BANCO MASVENTAS S.A.', 1, NULL, NULL, NULL),
  119. (38, 'BANCO MERIDIAN S.A.', 1, NULL, NULL, NULL),
  120. (39, 'BANCO MUNICIPAL DE ROSARIO', 1, NULL, NULL, NULL),
  121. (40, 'BANCO PATAGONIA S.A.', 1, NULL, NULL, NULL),
  122. (41, 'BANCO PIANO S.A.', 1, NULL, NULL, NULL),
  123. (42, 'BANCO PRIVADO DE INVERSIONES SOCIEDAD ANONIMA', 1, NULL, NULL, NULL),
  124. (43, 'BANCO PROVINCIA DE TIERRA DEL FUEGO', 1, NULL, NULL, NULL),
  125. (44, 'BANCO PROVINCIA DEL NEUQUÉN SOCIEDAD ANÓNIMA', 1, NULL, NULL, NULL),
  126. (45, 'BANCO ROELA S.A.', 1, NULL, NULL, NULL),
  127. (46, 'BANCO SAENZ S.A.', 1, NULL, NULL, NULL),
  128. (47, 'BANCO SANTANDER RIO S.A.', 1, NULL, NULL, NULL),
  129. (48, 'BANCO SUPERVIELLE S.A.', 1, NULL, NULL, NULL),
  130. (49, 'BANK OF AMERICA, NATIONAL ASSOCIATION', 1, NULL, NULL, NULL),
  131. (50, 'BBVA BANCO FRANCES S.A.', 1, NULL, NULL, NULL),
  132. (51, 'BNP PARIBAS', 1, NULL, NULL, NULL),
  133. (52, 'CAJA DE CREDITO COOPERATIVA LA CAPITAL DEL PLATA LIMITADA', 1, NULL, NULL, NULL),
  134. (53, 'CAJA DE CREDITO CUENCA COOPERATIVA LIMITADA', 1, NULL, NULL, NULL),
  135. (54, 'CITIBANK N.A.', 1, NULL, NULL, NULL),
  136. (55, 'COMPAÑÍA FINANCIERA ARGENTINA S.A.', 1, NULL, NULL, NULL),
  137. (56, 'CORDIAL COMPAÑÍA FINANCIERA S.A.', 1, NULL, NULL, NULL),
  138. (57, 'DEUTSCHE BANK S.A.', 1, NULL, NULL, NULL),
  139. (58, 'FIAT CREDITO COMPAÑÍA FINANCIERA S.A.', 1, NULL, NULL, NULL),
  140. (59, 'FINANDINO COMPAÑÍA FINANCIERA S.A.', 1, NULL, NULL, NULL),
  141. (60, 'FORD CREDIT COMPAÑÍA FINANCIERA S.A.', 1, NULL, NULL, NULL),
  142. (61, 'GPAT COMPAÑÍA FINANCIERA S.A.', 1, NULL, NULL, NULL),
  143. (62, 'HSBC BANK ARGENTINA S.A.', 1, NULL, NULL, NULL),
  144. (63, 'INDUSTRIAL AND COMMERCIAL BANK OF CHINA (ARGENTINA); S.A.', 1, NULL, NULL, NULL),
  145. (64, 'JOHN DEERE CREDIT COMPAÑÍA FINANCIERA S.A.', 1, NULL, NULL, NULL),
  146. (65, 'JPMORGAN CHASE BANK, NATIONAL ASSOCIATION (SUC. BS. AS.)', 1, NULL, NULL, NULL),
  147. (66, 'MBA LAZARD BANCO DE INVERSIONES S. A.', 1, NULL, NULL, NULL),
  148. (67, 'MERCEDES-BENZ COMPAÑÍA FINANCIERA ARGENT', 1, NULL, NULL, NULL),
  149. (68, 'METROPOLIS COMPAÑÍA FINANCIERA S.A.', 1, NULL, NULL, NULL),
  150. (69, 'MONTEMAR COMPAÑÍA FINANCIERA S.A.', 1, NULL, NULL, NULL),
  151. (70, 'MULTIFINANZAS COMPAÑÍA FINANCIERA S.A.', 1, NULL, NULL, NULL),
  152. (71, 'NUEVO BANCO DE ENTRE RÍOS S.A.', 1, NULL, NULL, NULL),
  153. (72, 'NUEVO BANCO DE LA RIOJA SOCIEDAD ANONIMA', 1, NULL, NULL, NULL),
  154. (73, 'NUEVO BANCO DE SANTA FE SOCIEDAD ANONIMA', 1, NULL, NULL, NULL),
  155. (74, 'NUEVO BANCO DEL CHACO S.A.', 1, NULL, NULL, NULL),
  156. (75, 'PSA FINANCE ARGENTINA COMPAÑÍA FINANCIERA', 1, NULL, NULL, NULL),
  157. (76, 'RCI BANQUE S.A.', 1, NULL, NULL, NULL),
  158. (77, 'ROMBO COMPAÑÍA FINANCIERA S.A.', 1, NULL, NULL, NULL),
  159. (78, 'THE BANK OF TOKYO-MITSUBISHI UFJ, LTD.', 1, NULL, NULL, NULL),
  160. (79, 'THE ROYAL BANK OF SCOTLAND N.V.', 1, NULL, NULL, NULL),
  161. (80, 'TOYOTA COMPAÑÍA FINANCIERA DE ARGENTINA', 1, NULL, NULL, NULL),
  162. (81, 'VOLKSWAGEN CREDIT COMPAÑÍA FINANCIERA S.', 1, NULL, NULL, NULL);
  163.  
  164. SET IDENTITY_INSERT "bancos" OFF;
  165.  
  166. --
  167. -- Volcado de datos para la tabla "banco_moneda"
  168. --
  169.  
  170. SET IDENTITY_INSERT "banco_moneda" ON ;
  171. INSERT INTO "banco_moneda" ("id", "banco_id", "moneda_id") VALUES
  172. (1, 1, 1),
  173. (2, 1, 2),
  174. (3, 2, 1),
  175. (4, 2, 2),
  176. (5, 3, 1),
  177. (6, 3, 2),
  178. (7, 4, 1),
  179. (8, 4, 2),
  180. (9, 5, 1),
  181. (10, 5, 2),
  182. (11, 6, 1),
  183. (12, 6, 2),
  184. (13, 7, 1),
  185. (14, 7, 2),
  186. (15, 8, 1),
  187. (16, 8, 2),
  188. (17, 9, 1),
  189. (18, 9, 2),
  190. (20, 10, 2),
  191. (21, 11, 1),
  192. (22, 11, 2),
  193. (23, 12, 1),
  194. (24, 12, 2),
  195. (26, 13, 2),
  196. (27, 14, 1),
  197. (28, 14, 2),
  198. (29, 15, 1),
  199. (30, 15, 2),
  200. (31, 16, 1),
  201. (32, 16, 2),
  202. (33, 17, 1),
  203. (34, 17, 2),
  204. (35, 18, 1),
  205. (36, 18, 2),
  206. (37, 19, 1),
  207. (38, 19, 2),
  208. (39, 20, 1),
  209. (40, 20, 2),
  210. (41, 21, 1),
  211. (42, 21, 2),
  212. (43, 22, 1),
  213. (44, 22, 2),
  214. (45, 23, 1),
  215. (46, 23, 2),
  216. (47, 24, 1),
  217. (48, 24, 2),
  218. (49, 25, 1),
  219. (50, 25, 2),
  220. (51, 26, 1),
  221. (52, 26, 2),
  222. (53, 27, 1),
  223. (54, 27, 2),
  224. (55, 28, 1),
  225. (56, 28, 2),
  226. (57, 29, 1),
  227. (58, 29, 2),
  228. (59, 30, 1),
  229. (60, 30, 2),
  230. (61, 31, 1),
  231. (62, 31, 2),
  232. (63, 32, 1),
  233. (64, 32, 2),
  234. (65, 33, 1),
  235. (66, 33, 2),
  236. (67, 34, 1),
  237. (68, 34, 2),
  238. (69, 35, 1),
  239. (70, 35, 2),
  240. (71, 36, 1),
  241. (72, 36, 2),
  242. (73, 37, 1),
  243. (74, 37, 2),
  244. (75, 38, 1),
  245. (76, 38, 2),
  246. (77, 39, 1),
  247. (78, 39, 2),
  248. (79, 40, 1),
  249. (80, 40, 2),
  250. (81, 41, 1),
  251. (82, 41, 2),
  252. (83, 42, 1),
  253. (84, 42, 2),
  254. (85, 43, 1),
  255. (86, 43, 2),
  256. (87, 44, 1),
  257. (88, 44, 2),
  258. (89, 45, 1),
  259. (90, 45, 2),
  260. (91, 46, 1),
  261. (92, 46, 2),
  262. (93, 47, 1),
  263. (94, 47, 2),
  264. (95, 48, 1),
  265. (96, 48, 2),
  266. (97, 49, 1),
  267. (98, 49, 2),
  268. (99, 49, 3),
  269. (100, 50, 1),
  270. (101, 50, 2),
  271. (102, 51, 1),
  272. (103, 51, 2),
  273. (104, 52, 1),
  274. (105, 52, 2),
  275. (106, 53, 1),
  276. (107, 53, 2),
  277. (108, 54, 1),
  278. (109, 54, 2),
  279. (110, 55, 1),
  280. (111, 55, 2),
  281. (112, 56, 1),
  282. (113, 56, 2),
  283. (114, 57, 1),
  284. (115, 57, 2),
  285. (116, 58, 1),
  286. (117, 58, 2),
  287. (118, 59, 1),
  288. (119, 59, 2),
  289. (120, 60, 1),
  290. (121, 60, 2),
  291. (122, 61, 1),
  292. (123, 61, 2),
  293. (124, 62, 1),
  294. (125, 62, 2),
  295. (126, 63, 1),
  296. (127, 63, 2),
  297. (128, 64, 1),
  298. (129, 64, 2),
  299. (130, 65, 1),
  300. (131, 65, 2),
  301. (132, 66, 1),
  302. (133, 66, 2),
  303. (134, 67, 1),
  304. (135, 67, 2),
  305. (136, 68, 1),
  306. (137, 68, 2),
  307. (138, 69, 1),
  308. (139, 69, 2),
  309. (140, 70, 1),
  310. (141, 70, 2),
  311. (142, 71, 1),
  312. (143, 71, 2),
  313. (144, 72, 1),
  314. (145, 72, 2),
  315. (146, 73, 1),
  316. (147, 73, 2),
  317. (148, 74, 1),
  318. (149, 74, 2),
  319. (150, 75, 1),
  320. (151, 75, 2),
  321. (152, 76, 1),
  322. (153, 76, 2),
  323. (154, 77, 1),
  324. (155, 77, 2),
  325. (156, 78, 1),
  326. (157, 78, 2),
  327. (158, 79, 1),
  328. (159, 79, 2),
  329. (160, 80, 1),
  330. (161, 80, 2),
  331. (162, 81, 1),
  332. (163, 81, 2);
  333.  
  334. SET IDENTITY_INSERT "banco_moneda" OFF;
  335.  
  336. --
  337. -- Volcado de datos para la tabla "comitente_usuario"
  338. --
  339.  
  340. SET IDENTITY_INSERT "comitente_usuario" ON ;
  341. INSERT INTO "comitente_usuario" ("id", "nro_comitente", "usuario_id", "tipo_usuario_id") VALUES
  342. (27, 10014, 15, 2),
  343. (31, 10016, 15, 2),
  344. (32, 10016, 16, 2),
  345. (33, 10016, 16, 1),
  346. (34, 10014, 16, 1),
  347. (38, 10014, 17, 2),
  348. (39, 10016, 17, 2),
  349. (40, 10016, 17, 1),
  350. (41, 61035, 17, 1),
  351. (47, 100057, 18, 1),
  352. (53, 100484, 19, 1),
  353. (54, 10014, 13, 2),
  354. (55, 31, 20, 2),
  355. (56, 31, 20, 1),
  356. (58, 111471, 1, 1),
  357. (61, 100484, 1, 1),
  358. (62, 1, 13, 2),
  359. (63, 1103063, 21, 2),
  360. (64, 1103063, 21, 1),
  361. (65, 48, 22, 2),
  362. (66, 48, 22, 1),
  363. (67, 10475, 1, 2);
  364.  
  365. SET IDENTITY_INSERT "comitente_usuario" OFF;
  366.  
  367. --
  368. -- Volcado de datos para la tabla "cuentas_bancarias"
  369. --
  370.  
  371. SET IDENTITY_INSERT "cuentas_bancarias" ON ;
  372. INSERT INTO "cuentas_bancarias" ("id", "tipo_cuenta_bancaria_id", "moneda_id", "banco_id", "numero", "cuit", "extracto", "cbu", "created_at", "updated_at", "deleted_at", "estado_id", "usuario_id", "nro_comitente", "nombre_comitente") VALUES
  373. (1, 1, 1, 1, '123123', 23622, '2Y80IWBSHPfiM4VjKNmiwcUUnJMiqlLtnbxvkWrp.docx', '11111', '2017-06-26 18:16:49', '2017-06-28 13:37:38', NULL, 3, 1, '111471', 'BOIDI NICOLAS IGNACIO'),
  374. (2, 1, 1, 1, '111111111', 23622, 'OPxREKKuLntzAQOg9g8s99qXX9szujfb80bW5apW.png', '23123', '2017-06-28 13:54:45', '2017-06-28 13:54:45', NULL, 1, 1, '111471', 'BOIDI NICOLAS IGNACIO');
  375.  
  376. SET IDENTITY_INSERT "cuentas_bancarias" OFF;
  377.  
  378. --
  379. -- Volcado de datos para la tabla "cuentas_bancarias_dolar_divisa"
  380. --
  381.  
  382. SET IDENTITY_INSERT "cuentas_bancarias_dolar_divisa" ON ;
  383. INSERT INTO "cuentas_bancarias_dolar_divisa" ("id", "iban", "swift", "aba", "nro_comitente", "nombre_comitente", "pais", "ciudad", "codigo_postal", "moneda_id", "banco_id", "estado_id", "usuario_id", "numero", "extracto", "inst_permanente", "created_at", "updated_at", "deleted_at") VALUES
  384. (5, NULL, '3333', '2222', '10475', 'AMX ARGENTINA S.A.', 'Argentina', NULL, NULL, 3, 49, 1, 1, '11111', 'CEZpKhZmzZCNA5wt5uGie7dUogPPQPcVqNPUHjKO.docx', 'instruccion_permanente.pdf', '2017-06-26 17:28:19', '2017-06-26 17:28:19', NULL),
  385. (6, NULL, NULL, NULL, '111471', 'BOIDI NICOLAS IGNACIO', 'Argentina', 'Buenos Aires', '1686', 3, 49, 1, 1, '123123123', 'Jjm1D5MxzIbMT8VdJjFLmpxr0QooE71DoBPZB7DD.pdf', 'instruccion_permanente.pdf', '2017-07-03 18:20:41', '2017-07-03 18:20:41', NULL),
  386. (7, NULL, NULL, NULL, '111471', 'BOIDI NICOLAS IGNACIO', 'Argentina', NULL, NULL, 3, 49, 1, 1, '12312311111', '0ykOo5GGfpN36BxkoPm72OjWgMjgfl5cC65S1N4q.pdf', 'instruccion_permanente.pdf', '2017-07-03 18:29:03', '2017-07-03 18:29:03', NULL);
  387.  
  388. SET IDENTITY_INSERT "cuentas_bancarias_dolar_divisa" OFF;
  389.  
  390. --
  391. -- Volcado de datos para la tabla "cuentas_bancarias_intl"
  392. --
  393.  
  394. SET IDENTITY_INSERT "cuentas_bancarias_intl" ON ;
  395. INSERT INTO "cuentas_bancarias_intl" ("id", "nombre", "cbu", "nro_cuenta", "habilitada", "moneda_id", "created_at", "updated_at", "deleted_at", "cod_cuenta_bancaria_esco", "defecto") VALUES
  396. (15, 'Banco de Valores', '', '240/2', 1, 1, NULL, NULL, NULL, 2, 1),
  397. (16, 'Banco Galicia', '', '48966/9 999/4', 1, 1, NULL, NULL, NULL, 3, 0),
  398. (17, 'Banco de la Ciudad de Buenos Aires', '', '999-25226-5', 0, 1, NULL, NULL, NULL, 4, 0),
  399. (18, 'Santander Rio', '', '000-21665-2', 1, 1, NULL, NULL, NULL, 5, 0),
  400. (19, 'Banco Frances', '', '099-677166/5', 0, 1, NULL, NULL, NULL, 6, 0),
  401. (20, 'HSBC Bank', '', '0013214663', 0, 1, NULL, NULL, NULL, 7, 0),
  402. (21, 'Banco Citibank', '', '0192417112', 0, 1, NULL, NULL, NULL, 8, 0),
  403. (22, 'Banco de la Nacion Argentina', '', '50205/44', 0, 1, NULL, NULL, NULL, 9, 0),
  404. (23, 'Banco de la Provincia de Buenos Aires', '', '1000-5052/6', 0, 1, NULL, NULL, NULL, 10, 0),
  405. (24, 'Banco Macro .', '', '35400-011083356/3', 1, 1, NULL, NULL, NULL, 11, 0),
  406. (25, 'Banco Patagonia', '', '100011428', 1, 1, NULL, NULL, NULL, 14, 0),
  407. (26, 'Banco Macro', '', '8-005823-8', 0, 1, NULL, NULL, NULL, 16, 0),
  408. (27, 'Banco Comafi', '', '0080-18431/5', 0, 1, NULL, NULL, NULL, 17, 0),
  409. (28, 'STANDARD CHARTERED', '', '3544-053057-070', 0, 2, NULL, NULL, NULL, 20, 0),
  410. (29, 'Banco Macro (pago a proveedores)', '', '35400-940000304-6', 0, 1, NULL, NULL, NULL, 21, 0),
  411. (30, 'Banco Macro .', '', '1002', 0, 1, NULL, NULL, NULL, 22, 0),
  412. (31, 'Banco Macro (cta recaudadora)', '', '454009400410655', 0, 1, NULL, NULL, NULL, 23, 0),
  413. (32, 'Deutsche Bank', '', '660012910', 0, 1, NULL, NULL, NULL, 24, 0),
  414. (33, 'Deutsche Bank S.A. (Cta. Cte.)', '', '104023540024', 0, 1, NULL, NULL, NULL, 25, 0),
  415. (34, 'Transferencias Internas', '', '111111111', 0, 1, NULL, NULL, NULL, 26, 0),
  416. (35, 'Banco Macro (cta recaudadora)', '', '123456', 0, 2, NULL, NULL, NULL, 27, 0),
  417. (36, 'BANCO FINANSUR', '', '40190/7', 0, 1, NULL, NULL, NULL, 28, 0),
  418. (37, 'Banco Macro CV 10000 ME', '', '254009405050582', 1, 2, NULL, NULL, NULL, 29, 0),
  419. (38, 'Banco Macro.', '', '1004', 0, 2, NULL, NULL, NULL, 30, 0),
  420. (39, 'HSBC Bank', '', '164208', 0, 2, NULL, NULL, NULL, 31, 0),
  421. (40, 'HSBC Bank', '', '300346568', 0, 1, NULL, NULL, NULL, 32, 0),
  422. (41, 'HSBC Bank', '', '3008447969', 0, 2, NULL, NULL, NULL, 33, 0),
  423. (42, 'Bank Of América', '', '446015624527', 0, 2, NULL, NULL, NULL, 36, 0),
  424. (43, 'BANCO COLUMBIA', '', '02-0052057166/6', 0, 1, NULL, NULL, NULL, 37, 0),
  425. (44, 'Banco emisor licitaciones primarias', '', '0', 0, 1, NULL, NULL, NULL, 38, 0),
  426. (45, 'BANCO COLUMBIA', '', '04-005205654/2', 0, 2, NULL, NULL, NULL, 39, 0),
  427. (46, 'Banco de Valores', '', '104269/9', 1, 2, NULL, NULL, NULL, 40, 1),
  428. (47, 'Banco de Valores', '', '10', 0, 1, NULL, NULL, NULL, 41, 0),
  429. (48, 'Banco de Valores', '', '104269-9', 0, 2, NULL, NULL, NULL, 42, 0),
  430. (49, 'Banco Macro CV 10000 ME', '', '254-00940505582', 0, 2, NULL, NULL, NULL, 43, 0),
  431. (50, 'Banco Emisor de Licitaciones Primarias MAE', '', '0', 0, 1, NULL, NULL, NULL, 45, 0),
  432. (51, 'Banco emisor licitaciones primarias Dólar Cable', '', '0', 0, 2, NULL, NULL, NULL, 46, 0),
  433. (52, 'Banco emisor licitaciones primarias Dólar MEP', '', '0', 0, 2, NULL, NULL, NULL, 47, 0),
  434. (53, 'Banco emisor licitaciones primarias Dólar MEP', '', '00', 0, 2, NULL, NULL, NULL, 48, 0),
  435. (54, 'Bank of America', '', '4460 1562 4527', 1, 3, NULL, NULL, NULL, 36, 1);
  436.  
  437. SET IDENTITY_INSERT "cuentas_bancarias_intl" OFF;
  438.  
  439. --
  440. -- Volcado de datos para la tabla "depositos"
  441. --
  442.  
  443. SET IDENTITY_INSERT "depositos" ON ;
  444. INSERT INTO "depositos" ("id", "fecha", "comprobante", "moneda_id", "origen_id", "destino_id", "estado_id", "usuario_id", "fecha_esco", "created_at", "updated_at", "deleted_at", "backend_user_id", "nro_comitente", "nombre_comitente", "importe") VALUES
  445. (1, '2017-06-26 11:22:52', 'kDea7nANqUdTmSNBSwftZUUX60YNRt7TlnUCGylq.pdf', 2, 1, 37, 2, 1, '2017-06-25 11:24:13', '2017-06-26 14:22:52', '2017-06-26 14:24:13', NULL, 1, '10475', 'AMX ARGENTINA S.A.', 0.00),
  446. (2, '2017-06-27 09:33:15', 'COukCUhX70kUtAPhSxXD9eamdqimDveQmx4pMUGS.docx', 1, 1, 15, 1, 1, NULL, '2017-06-27 12:33:15', '2017-06-27 12:33:15', NULL, NULL, '111471', 'BOIDI NICOLAS IGNACIO', 0.00),
  447. (3, '2017-06-28 10:32:44', 'GY9FC9WuCWWqLR01Ybs3sk3bAEC51rW1RBWCCXcR.docx', 1, 1, 15, 1, 1, NULL, '2017-06-28 13:32:44', '2017-06-28 13:32:44', NULL, NULL, '111471', 'BOIDI NICOLAS IGNACIO', 175000000.00),
  448. (4, '2017-06-28 10:39:42', '7eDiSVDcf3ltmQLTgUvsWDLOG8DUUZp3kMoEe6Db.png', 1, 1, 15, 1, 1, NULL, '2017-06-28 13:39:42', '2017-06-28 13:39:42', NULL, NULL, '111471', 'BOIDI NICOLAS IGNACIO', 123.00),
  449. (5, '2017-06-30 13:28:11', 'mHoTwWsDMdnVUtIks9gDbVYPl2vnTw0nR1l8CkBI.pdf', 1, 1, 15, 1, 1, NULL, '2017-06-30 16:28:11', '2017-06-30 16:28:11', NULL, NULL, '111475', 'DE MAYOLAS GUADALUPE', 1234.00),
  450. (6, '2017-06-30 13:29:34', 'o8vJR0mQ6wlPi6ZB4oRCIa0XCkJWLvvljo9jSGhA.pdf', 1, 1, 15, 1, 1, NULL, '2017-06-30 16:29:34', '2017-06-30 16:29:34', NULL, NULL, '111475', 'DE MAYOLAS GUADALUPE', 123.00),
  451. (8, '2017-06-30 13:58:23', 'mfGYcd4kOjBBX1Ikvcrrw78UUldnF70yL9DEJ4tW.pdf', 1, 1, 15, 2, 1, NULL, '2017-06-30 16:58:23', '2017-06-30 16:58:23', NULL, NULL, '111471', 'BOIDI NICOLAS IGNACIO', 1515.00),
  452. (9, '2017-06-30 14:18:16', 'IufuJISBp6E0Vz9dSQvfGV6eTItpwbwQ8JgdfG0Q.pdf', 3, 49, 54, 2, 1, NULL, '2017-06-30 17:18:16', '2017-06-30 17:18:16', NULL, NULL, '111471', 'BOIDI NICOLAS IGNACIO', 1441.00),
  453. (10, '2017-06-30 14:21:22', '8QNWe66AX22BKcnhTWN1kw1xUJ91HEuxHU5Uzppm.pdf', 1, 1, 15, 2, 1, NULL, '2017-06-30 17:21:22', '2017-06-30 17:21:22', NULL, NULL, '111471', 'BOIDI NICOLAS IGNACIO', 8888.00),
  454. (11, '2017-06-30 14:23:24', 'dhFuHCCIbtK5JHWhv8Ca4IF1y3PMfg4MdV5KpHmS.pdf', 3, 49, 54, 2, 1, NULL, '2017-06-30 17:23:24', '2017-06-30 17:23:24', NULL, NULL, '111471', 'BOIDI NICOLAS IGNACIO', 9999.00),
  455. (12, '2017-06-30 14:29:02', 'us6D4WBZzwEs5n4UBLUfKf9dTWXzD5tCA6sDsMVE.pdf', 3, 49, 54, 1, 1, NULL, '2017-06-30 17:29:02', '2017-06-30 17:29:02', NULL, NULL, '111471', 'BOIDI NICOLAS IGNACIO', 500.00),
  456. (13, '2017-06-30 14:29:43', 'WsKXJN83PPAPPtXMfzTNsPz3FNuXOKjF88znv39T.pdf', 1, 1, 15, 1, 1, NULL, '2017-06-30 17:29:43', '2017-06-30 17:29:43', NULL, NULL, '111471', 'BOIDI NICOLAS IGNACIO', 500.00),
  457. (14, '2017-06-30 14:30:13', '40AIj6dEIrkp5rbugBOLLy4W1BCf901IfYN9T2TN.pdf', 1, 1, 46, 2, 1, '2017-06-29 14:30:42', '2017-06-30 17:30:13', '2017-06-30 17:30:42', NULL, 1, '111471', 'BOIDI NICOLAS IGNACIO', 500.00),
  458. (15, '2017-06-30 14:30:20', 'uQhAenO2St6PvqgJIHuD0BKMotJLoDakbM2yiQjQ.png', 1, 1, 15, 2, 1, NULL, '2017-06-30 17:30:20', '2017-06-30 17:30:20', NULL, NULL, '111471', 'BOIDI NICOLAS IGNACIO', 111.00),
  459. (16, '2017-06-30 14:32:49', 'EtHKYbwbpIvYdTX8cqKHM4Ys1bQXUYyWxKgoVEqK.pdf', 3, 49, 54, 1, 1, NULL, '2017-06-30 17:32:49', '2017-06-30 17:32:49', NULL, NULL, '111471', 'BOIDI NICOLAS IGNACIO', 6544.00),
  460. (17, '2017-06-30 14:32:54', 'uUQRZqqKdTkgq6wjFTJeDWUUBdmqbV7yVFLCRqeF.pdf', 3, 49, 54, 2, 1, NULL, '2017-06-30 17:32:54', '2017-06-30 17:32:54', NULL, NULL, '111471', 'BOIDI NICOLAS IGNACIO', 4321.00),
  461. (18, '2017-07-04 10:06:20', 'fViWA3Jnx58QBktVUwTCQvxWzQa7yr1OzUavAQzJ.pdf', 2, 2, 37, 2, 1, NULL, '2017-07-04 13:06:20', '2017-07-04 13:06:20', NULL, NULL, '111471', 'BOIDI NICOLAS IGNACIO', 123.00),
  462. (19, '2017-07-04 10:06:55', 'F85BdCYHJ0qjDNmxAyLvpVqrgxyGqUR9gJGBdvln.pdf', 3, 49, 54, 2, 1, NULL, '2017-07-04 13:06:55', '2017-07-04 13:06:55', NULL, NULL, '111471', 'BOIDI NICOLAS IGNACIO', 222.00),
  463. (20, '2017-07-04 10:35:41', 'bxxbsC9bV1c8GjBgus090gTHYPOGRMIi4qDlXDgB.pdf', 1, 1, 15, 1, 1, NULL, '2017-07-04 13:35:41', '2017-07-04 13:35:41', NULL, NULL, '10475', 'AMX ARGENTINA S.A.', 123.00),
  464. (21, '2017-07-04 10:35:57', 'WFal6OTsUpM8QdPgb9BZUofpdAavVjcqY1GfphIC.pdf', 1, 1, 15, 1, 1, NULL, '2017-07-04 13:35:57', '2017-07-04 13:35:57', NULL, NULL, '10475', 'AMX ARGENTINA S.A.', 500.00);
  465.  
  466. SET IDENTITY_INSERT "depositos" OFF;
  467.  
  468. --
  469. -- Volcado de datos para la tabla "estado_cuenta_bancaria"
  470. --
  471.  
  472. SET IDENTITY_INSERT "estado_cuenta_bancaria" ON ;
  473. INSERT INTO "estado_cuenta_bancaria" ("id", "nombre", "created_at", "updated_at", "deleted_at") VALUES
  474. (1, 'Pendiente', NULL, NULL, NULL),
  475. (2, 'Aceptado', NULL, NULL, NULL),
  476. (3, 'Rechazado', NULL, NULL, NULL);
  477.  
  478. SET IDENTITY_INSERT "estado_cuenta_bancaria" OFF;
  479.  
  480. --
  481. -- Volcado de datos para la tabla "estado_deposito"
  482. --
  483.  
  484. SET IDENTITY_INSERT "estado_deposito" ON ;
  485. INSERT INTO "estado_deposito" ("id", "nombre", "deleted_at") VALUES
  486. (1, 'Pendiente', NULL),
  487. (2, 'Aceptado', NULL),
  488. (3, 'Rechazado', NULL);
  489.  
  490. SET IDENTITY_INSERT "estado_deposito" OFF;
  491.  
  492. --
  493. -- Volcado de datos para la tabla "estado_transferencia"
  494. --
  495.  
  496. SET IDENTITY_INSERT "estado_transferencia" ON ;
  497. INSERT INTO "estado_transferencia" ("id", "nombre", "created_at", "updated_at", "deleted_at") VALUES
  498. (1, 'Pendiente', NULL, NULL, NULL),
  499. (2, 'Aceptado', NULL, NULL, NULL),
  500. (3, 'Rechazado', NULL, NULL, NULL);
  501.  
  502. SET IDENTITY_INSERT "estado_transferencia" OFF;
  503.  
  504. --
  505. -- Volcado de datos para la tabla "migrations"
  506. --
  507.  
  508. SET IDENTITY_INSERT "migrations" ON ;
  509. INSERT INTO "migrations" ("id", "migration", "batch") VALUES
  510. (1, '2014_10_12_000000_create_backend_users_table', 1),
  511. (2, '2014_10_12_100000_create_password_resets_table', 1),
  512. (3, '2017_05_10_151140_agregar_email_a_backend_users', 1),
  513. (4, '2017_05_10_154804_cambiar_nombre_id_backend_users', 1),
  514. (5, '2017_05_10_160436_create_users_table', 1),
  515. (6, '2017_05_10_162644_agregar_apellido_a_users', 1),
  516. (7, '2017_05_11_111126_cambiar_nombre_a_password', 1),
  517. (8, '2017_05_11_122601_create_permisos_table', 1),
  518. (9, '2017_05_11_123400_create_permiso_usuario_table', 1),
  519. (10, '2017_05_12_090630_agregar_apellido_a_backend_users', 1),
  520. (11, '2017_05_12_120622_agregar_last_login_a_backend_users', 1),
  521. (12, '2017_05_12_133339_create_estado_deposito_table', 1),
  522. (13, '2017_05_12_133953_create_moneda_table', 1),
  523. (14, '2017_05_12_142917_create_bancos_table', 1),
  524. (15, '2017_05_12_143300_create_banco_moneda_table', 1),
  525. (16, '2017_05_15_104452_create_cuentas_bancarias_intl_table', 1),
  526. (40, '2017_05_15_172052_create_depositos_table', 2),
  527. (41, '2017_05_16_112900_cambiar_campo_password_users_table', 2),
  528. (42, '2017_05_16_113120_agregar_last_login_users', 2),
  529. (43, '2017_05_16_124647_agregar_comprobante_a_depositos_table', 2),
  530. (44, '2017_05_16_132818_agregar_tiempos_a_depositos_table', 2),
  531. (45, '2017_05_18_100825_agregar_fecha_esco_depositos', 2),
  532. (65, '2017_05_19_133025_create_tipo_cuenta_bancaria_table', 3),
  533. (66, '2017_05_19_133202_create_cuentas_bancarias_table', 3),
  534. (67, '2017_05_19_145202_create_estado_cuenta_bancaria_table', 3),
  535. (68, '2017_05_19_150105_agregar_estado_id_a_cuentas_bancarias_table', 3),
  536. (70, '2017_05_19_150818_agregar_usuario_id_a_cuentas_bancarias_table', 4),
  537. (72, '2017_05_22_114213_quitar_unique_a_cbu_cuentas_bancarias', 5),
  538. (82, '2017_05_22_132601_create_transferencias_table', 6),
  539. (83, '2017_05_23_110239_create_estado_transferencia_table', 6),
  540. (84, '2017_05_23_110335_agregar_estado_id_a_transferencias_table', 6),
  541. (88, '2017_05_23_141307_agregar_banco_a_transferencias_table', 7),
  542. (90, '2017_05_24_141343_agregar_num_persona_a_users_table', 8),
  543. (92, '2017_05_24_144918_eliminar_comitente_de_users', 9),
  544. (94, '2017_05_24_145135_create_comitente_usuario_table', 10),
  545. (97, '2017_05_30_094919_cambiar_nombre_a_comitente_id_comitente_usuario_table', 11),
  546. (100, '2017_05_30_104043_agregar_nulls_a_users', 12),
  547. (105, '2017_05_30_135323_crear_tipo_comitente_usuario_table', 13),
  548. (106, '2017_05_30_135625_agregar_tipo_comitente_usuario_id', 13),
  549. (108, '2017_06_05_143449_agregar_aprobador_id_depositos_table', 14),
  550. (112, '2017_06_07_102559_cambiar_nombre_origen_transferencias_table', 15),
  551. (113, '2017_06_07_133531_agregar_datos_comitente_deposito', 16),
  552. (115, '2017_06_07_134503_agregar_datos_comitente_cuentas_bancarias_table', 17),
  553. (121, '2017_06_08_153116_agregar_fecha_transaccion_transferencias_table', 18),
  554. (123, '2017_06_09_113003_agregar_cbu_nro_cuenta_bancos_intl', 19),
  555. (126, '2017_06_09_120209_agregar_banco_origen_intl_transferencias_table', 20),
  556. (129, '2017_06_09_134546_agregar_moneda_id_cuenta_intl', 21),
  557. (131, '2017_06_12_122136_agregar_defecto_cuentas_bancarias_intl', 22),
  558. (137, '2017_06_19_084512_create_cuentas_bancarias_dolar_divisa_table', 23),
  559. (138, '2017_06_22_112419_agregar_nulls_a_cuentas_bancarias_table', 24),
  560. (140, '2017_06_23_115654_agregar_id_y_cod_interfaz_a_monedas_table', 25),
  561. (141, '2017_06_23_132851_agregar_nulo_tipo_cuenta_transferencias', 26),
  562. (145, '2017_06_26_123700_agregar_inst_permanente_cuentas_bancarias', 27),
  563. (149, '2017_06_28_095100_cambiar_tipo_importe_deposito_y_transferencia', 28);
  564.  
  565. SET IDENTITY_INSERT "migrations" OFF;
  566.  
  567. --
  568. -- Volcado de datos para la tabla "monedas"
  569. --
  570.  
  571. SET IDENTITY_INSERT "monedas" ON ;
  572. INSERT INTO "monedas" ("id", "nombre", "created_at", "updated_at", "deleted_at", "id_esco", "cod_interfaz_esco") VALUES
  573. (1, 'Pesos', NULL, NULL, NULL, 1, 0),
  574. (2, 'Dolares', NULL, NULL, NULL, 2, 1),
  575. (3, 'Dolar Divisa', NULL, NULL, NULL, 2, 1);
  576.  
  577. SET IDENTITY_INSERT "monedas" OFF;
  578.  
  579. --
  580. -- Volcado de datos para la tabla "tipo_comitente_usuario"
  581. --
  582.  
  583. SET IDENTITY_INSERT "tipo_comitente_usuario" ON ;
  584. INSERT INTO "tipo_comitente_usuario" ("id", "nombre") VALUES
  585. (1, 'Operador'),
  586. (2, 'Vista');
  587.  
  588. SET IDENTITY_INSERT "tipo_comitente_usuario" OFF;
  589.  
  590. --
  591. -- Volcado de datos para la tabla "tipo_cuenta_bancaria"
  592. --
  593.  
  594. SET IDENTITY_INSERT "tipo_cuenta_bancaria" ON ;
  595. INSERT INTO "tipo_cuenta_bancaria" ("id", "nombre", "created_at", "updated_at", "deleted_at") VALUES
  596. (1, 'Caja de Ahorro', NULL, NULL, NULL),
  597. (2, 'Cuenta Corriente', NULL, NULL, NULL);
  598.  
  599. SET IDENTITY_INSERT "tipo_cuenta_bancaria" OFF;
  600.  
  601. --
  602. -- Volcado de datos para la tabla "transferencias"
  603. --
  604.  
  605. SET IDENTITY_INSERT "transferencias" ON ;
  606. INSERT INTO "transferencias" ("id", "nro_comitente", "nro_cuenta", "tipo_cuenta", "banco", "banco_origen_id", "moneda_id", "usuario_id", "estado_id", "cbu", "cuit", "fecha_transaccion", "created_at", "updated_at", "deleted_at", "nombre_comitente", "backend_user_id", "importe") VALUES
  607. (4, 111471, '000-371749/7', 'Caja de Ahorro', 'Santander Rio', 19, 1, 1, 2, '0720000788000037174972', '20225920215', '2017-06-12 14:17:16', '2017-06-12 15:31:12', '2017-06-12 17:17:16', NULL, 'BOIDI NICOLAS IGNACIO', NULL, 0.00),
  608. (5, 111471, '000-371749/7', 'Caja de Ahorro', 'Santander Rio', 46, 2, 1, 2, '0720000788000037174972', '20225920215', '2017-06-12 14:01:00', '2017-06-12 15:31:19', '2017-06-12 17:01:00', NULL, 'BOIDI NICOLAS IGNACIO', NULL, 0.00),
  609. (6, 111471, '000-371749/7', 'Caja de Ahorro', 'Santander Rio', 15, 1, 1, 2, '0720000788000037174972', '20225920215', '2017-06-15 09:53:28', '2017-06-15 12:02:17', '2017-06-15 12:53:28', NULL, 'BOIDI NICOLAS IGNACIO', 1, 0.00),
  610. (7, 111471, '000-371749/7', 'Caja de Ahorro', 'Santander Rio', 15, 1, 1, 3, '0720000788000037174972', '20225920215', NULL, '2017-06-15 17:56:59', '2017-06-21 19:47:58', NULL, 'BOIDI NICOLAS IGNACIO', NULL, 0.00),
  611. (8, 111471, '000-371749/7', 'Caja de Ahorro', 'Santander Rio', 15, 1, 1, 3, '0720000788000037174972', '20225920215', NULL, '2017-06-15 18:04:31', '2017-06-21 19:49:31', NULL, 'BOIDI NICOLAS IGNACIO', NULL, 0.00),
  612. (9, 111471, '000-371749/7', 'Caja de Ahorro', 'Santander Rio', 15, 1, 1, 3, '0720000788000037174972', '20225920215', NULL, '2017-06-15 18:04:55', '2017-06-21 20:15:42', NULL, 'BOIDI NICOLAS IGNACIO', NULL, 0.00),
  613. (10, 111471, '000-371749/7', 'Caja de Ahorro', 'Santander Rio', 15, 1, 1, 3, '0720000788000037174972', '20225920215', NULL, '2017-06-15 18:07:01', '2017-06-21 20:17:14', NULL, 'BOIDI NICOLAS IGNACIO', NULL, 0.00),
  614. (11, 111471, '000-371749/7', 'Caja de Ahorro', 'Santander Rio', 15, 1, 1, 3, '0720000788000037174972', '20225920215', NULL, '2017-06-15 18:13:37', '2017-06-21 20:32:46', NULL, 'BOIDI NICOLAS IGNACIO', NULL, 0.00),
  615. (14, 100484, '366714/3', 'Caja de Ahorro', 'Santander Rio', 15, 1, 1, 1, '0720201088000036771436', '20254009475', NULL, '2017-06-16 14:41:03', '2017-06-16 14:41:03', NULL, 'BERNAL MARTIN Y/O CASAL DOLORES', NULL, 0.00),
  616. (15, 100484, '366714/3', 'Caja de Ahorro', 'Santander Rio', 15, 1, 1, 3, '0720201088000036771436', '20254009475', NULL, '2017-06-16 14:44:45', '2017-06-21 20:33:13', NULL, 'BERNAL MARTIN Y/O CASAL DOLORES', NULL, 0.00),
  617. (16, 100484, '366714/3', 'Caja de Ahorro', 'Santander Rio', 15, 1, 1, 3, '0720201088000036771436', '20254009475', NULL, '2017-06-16 17:40:18', '2017-06-16 17:45:20', NULL, 'BERNAL MARTIN Y/O CASAL DOLORES', NULL, 0.00),
  618. (17, 10475, '3617-8353', NULL, 'CITIBANK N.A. NY', 54, 3, 1, 2, '021000089||', '20140089525', '2017-06-26 10:28:25', '2017-06-23 16:30:47', '2017-06-26 13:28:25', NULL, 'AMX ARGENTINA S.A.', 1, 0.00),
  619. (18, 10475, '3617-8353', NULL, 'CITIBANK N.A. NY', 54, 3, 1, 1, '021000089||', '20140089525', NULL, '2017-06-23 16:31:23', '2017-06-23 16:31:23', NULL, 'AMX ARGENTINA S.A.', NULL, 0.00),
  620. (19, 10475, '0/806418/013', 'Cuenta Corriente', 'Banco Citibank', 15, 1, 1, 1, '0168888100008064180135', '20140089525', NULL, '2017-06-23 16:34:27', '2017-06-23 16:34:27', NULL, 'AMX ARGENTINA S.A.', NULL, 0.00),
  621. (20, 10475, '3617-8353', NULL, 'CITIBANK N.A. NY', 54, 3, 1, 2, '021000089||', '20140089525', '2017-06-26 10:36:31', '2017-06-26 13:28:45', '2017-06-26 13:36:31', NULL, 'AMX ARGENTINA S.A.', 1, 0.00),
  622. (21, 10475, '3617-8353', NULL, 'CITIBANK N.A. NY', 54, 3, 1, 2, '021000089||', '20140089525', NULL, '2017-07-04 17:31:17', '2017-07-04 17:31:17', NULL, 'AMX ARGENTINA S.A.', NULL, 50.00),
  623. (22, 10475, '3617-8353', NULL, 'CITIBANK N.A. NY', 54, 3, 1, 2, '021000089||', '20140089525', NULL, '2017-07-04 17:33:17', '2017-07-04 17:33:17', NULL, 'AMX ARGENTINA S.A.', NULL, 10.00),
  624. (23, 10475, '3617-8353', NULL, 'CITIBANK N.A. NY', 54, 3, 1, 2, '021000089||', '20140089525', NULL, '2017-07-04 17:35:06', '2017-07-04 17:35:06', NULL, 'AMX ARGENTINA S.A.', NULL, 10.00),
  625. (24, 10475, '3617-8353', NULL, 'CITIBANK N.A. NY', 54, 3, 1, 2, '021000089||', '20140089525', NULL, '2017-07-04 17:37:34', '2017-07-04 17:37:34', NULL, 'AMX ARGENTINA S.A.', NULL, 5.00);
  626.  
  627. SET IDENTITY_INSERT "transferencias" OFF;
  628.  
  629. --
  630. -- Volcado de datos para la tabla "users"
  631. --
  632.  
  633. SET IDENTITY_INSERT "users" ON ;
  634. INSERT INTO "users" ("id", "us_nombre", "us_email", "us_username", "password", "num_persona", "last_login", "created_at", "updated_at", "deleted_at", "remember_token", "us_apellido") VALUES
  635. (1, 'Alejandro', 'aleponzo1@gmail.com', 'ale', '$2y$10$b/vBuVxA.vrRdX6PKEZZ1uiAZTkbzk6UYDAANU/hCm.znT7TE5o0.', 0, '2017-07-04 14:10:08', NULL, '2017-07-04 17:10:08', NULL, 'LvHTY2fIQ6Cw0UmMvAE0lFPJrT0BaqIEO7tFHXflQLfxD5A2ovkBD3UfQvb6', 'Ponzo'),
  636. (13, 'Parisi Orlando Francisco', NULL, 'parisi', '$2y$10$MjQGNpoMbU5uWddnRm4WbecDhoLPSm5eStF8QFZIhic.4qhvMM2ae', 1, NULL, '2017-05-30 17:28:25', '2017-05-30 17:28:25', NULL, NULL, NULL),
  637. (15, 'Lopez Leon Hernan', 'HERNANLOPEZLEON@HOTMAIL.COM', 'lopez', '$2y$10$INKhUqHChmBwQB56vR60.uPF7P5KOoS8aIuvhNXFJOLqoQ/fLm88S', 2, NULL, '2017-05-31 15:15:27', '2017-05-31 15:15:27', NULL, NULL, NULL),
  638. (16, 'Marasca Diego', NULL, 'diego_marasca', '$2y$10$w/6LPgVnVvOHRYF3.rbgzOVJ6MnDqdKjLkMCpyqdAYt.R2FLUi0r6', 7, NULL, '2017-05-31 15:27:57', '2017-05-31 15:27:57', NULL, NULL, NULL),
  639. (17, 'Loredo Roberto', 'roberto@laderasur.com.ar', 'loredo_roberto', '$2y$10$efUIlVvW.w.rOziYNviYEuCKdTPtIEuiV8grHMXdZBbA.FS6ZInRW', 5, NULL, '2017-05-31 15:29:26', '2017-05-31 15:29:26', NULL, NULL, NULL),
  640. (18, 'Chimeno Bibiana', NULL, 'chimeno', '$2y$10$ycjlNjDwzlTxiSCtCGhioOa40kv3iFUeD6bw7DSDtTQfYH7zr0.yW', 81, NULL, '2017-06-01 14:08:00', '2017-06-01 14:08:00', NULL, NULL, NULL),
  641. (19, 'Bernal Martin', 'MARTIN_BERNAL@YAHOO.COM', 'mbernal', '$2y$10$HhZXtIALJl5hmAFGivZEL.eE.orgvz/yY7AFyT5L8LqJfZInq.Sr2', 5634, NULL, '2017-06-01 15:29:37', '2017-06-01 15:29:37', NULL, NULL, NULL),
  642. (20, 'Acuña Marcelo', NULL, 'macuna', '$2y$10$BrGCD8iSPeg3VPBEsDffCuyCnPX86UP.Jh25wyg8mLULXA/tv8jGS', 573, NULL, '2017-06-06 17:11:06', '2017-06-06 17:11:06', NULL, NULL, NULL),
  643. (21, 'Sanchez Juan Carlos Gaston', 'gsanchez2004@gmail.com', 'juanca', '$2y$10$ZihzKH/vfg8JO4ntDl2xsOMdnfwSz0/peilpfUfLo9UGzZnpsokQ2', 10713, NULL, '2017-06-21 14:36:06', '2017-06-21 14:36:06', NULL, NULL, NULL),
  644. (22, 'Anchorena Santiago', NULL, 'achorena_santiago', '$2y$10$q7jYFf0Dn4oflIyKK5xVxesX7SmivUtmauoUjarJ5o6Z8ads75U/.', 202, NULL, '2017-06-21 18:20:44', '2017-06-21 18:20:44', NULL, NULL, NULL);
  645.  
  646. SET IDENTITY_INSERT "users" OFF;
  647. SET FOREIGN_KEY_CHECKS=1;
  648.  
  649. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  650. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  651. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
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!