pXC0EaRZ

· 9 years ago · Jul 04, 2017, 06:38 PM
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:36:22
7-- VersiÃ³n del servidor: 10.1.21-MariaDB
8-- VersiÃ³n de PHP: 5.6.30
9
10SET FOREIGN_KEY_CHECKS=0;
11SET 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--
22CREATE DATABASE IF NOT EXISTS "intl_trading" DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
23USE intl_trading;
24
25-- --------------------------------------------------------
26
27--
28-- Estructura de tabla para la tabla "backend_permisos"
29--
30
31CREATE TABLE "backend_permisos" ;
32
33--
34-- Volcado de datos para la tabla "backend_permisos"
35--
36
37SET IDENTITY_INSERT "backend_permisos" ON ;
38INSERT INTO "backend_permisos" ("id", "backend_permisos_nombre", "created_at", "updated_at", "deleted_at") VALUES
39(1, 'Gerencia', NULL, NULL, NULL),
40(2, 'TesorerÃa', NULL, NULL, NULL),
41(3, 'Cuentas Bancarias', NULL, NULL, NULL),
42(4, 'GestiÃ³n Fondos', NULL, NULL, NULL),
43(5, 'GestiÃ³n de Internos', NULL, NULL, NULL);
44
45SET IDENTITY_INSERT "backend_permisos" OFF;
46
47-- --------------------------------------------------------
48
49--
50-- Estructura de tabla para la tabla "backend_permiso_usuario"
51--
52
53CREATE TABLE "backend_permiso_usuario" ;
54
55--
56-- Volcado de datos para la tabla "backend_permiso_usuario"
57--
58
59SET IDENTITY_INSERT "backend_permiso_usuario" ON ;
60INSERT INTO "backend_permiso_usuario" ("id", "permiso_id", "usuario_id", "created_at", "updated_at") VALUES
61(1, 1, 1, NULL, NULL),
62(3, 2, 1, NULL, NULL),
63(4, 2, 2, NULL, NULL),
64(5, 3, 2, NULL, NULL),
65(6, 1, 3, NULL, NULL),
66(7, 3, 3, NULL, NULL),
67(15, 4, 6, NULL, NULL),
68(16, 2, 7, NULL, NULL),
69(17, 3, 1, NULL, NULL),
70(18, 2, 3, NULL, NULL),
71(19, 2, 8, NULL, NULL),
72(20, 3, 8, NULL, NULL),
73(21, 2, 9, NULL, NULL),
74(22, 2, 6, NULL, NULL);
75
76SET IDENTITY_INSERT "backend_permiso_usuario" OFF;
77
78-- --------------------------------------------------------
79
80--
81-- Estructura de tabla para la tabla "backend_users"
82--
83
84CREATE TABLE "backend_users" ;
85
86--
87-- Volcado de datos para la tabla "backend_users"
88--
89
90SET IDENTITY_INSERT "backend_users" ON ;
91INSERT 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
92(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'),
93(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'),
94(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'),
95(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'),
96(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'),
97(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'),
98(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');
99
100SET IDENTITY_INSERT "backend_users" OFF;
101
102-- --------------------------------------------------------
103
104--
105-- Estructura de tabla para la tabla "bancos"
106--
107
108CREATE TABLE "bancos" ;
109
110--
111-- Volcado de datos para la tabla "bancos"
112--
113
114SET IDENTITY_INSERT "bancos" ON ;
115INSERT INTO "bancos" ("id", "nombre", "habilitado", "created_at", "updated_at", "deleted_at") VALUES
116(1, 'AMERICAN EXPRESS BANK LTD. SOCIEDAD ANON', 1, NULL, NULL, NULL),
117(2, 'BACS BANCO DE CREDITO Y SECURITIZACION S', 1, NULL, NULL, NULL),
118(3, 'BANCO BICA S.A.', 1, NULL, NULL, NULL),
119(4, 'BANCO BRADESCO ARGENTINA S.A.', 1, NULL, NULL, NULL),
120(5, 'BANCO CETELEM ARGENTINA S.A.', 1, NULL, NULL, NULL),
121(6, 'BANCO CMF S.A.', 1, NULL, NULL, NULL),
122(7, 'BANCO COLUMBIA S.A.', 1, NULL, NULL, NULL),
123(8, 'BANCO COMAFI SOCIEDAD ANONIMA', 1, NULL, NULL, NULL),
124(9, 'BANCO CREDICOOP COOPERATIVO LIMITADO', 1, NULL, NULL, NULL),
125(10, 'BANCO DE CORRIENTES S.A.', 1, NULL, NULL, NULL),
126(11, 'BANCO DE GALICIA Y BUENOS AIRES S.A.', 1, NULL, NULL, NULL),
127(12, 'BANCO DE INVERSION Y COMERCIO EXTERIOR S.A.', 1, NULL, NULL, NULL),
128(13, 'BANCO DE LA CIUDAD DE BUENOS AIRES', 1, NULL, NULL, NULL),
129(14, 'BANCO DE LA NACION ARGENTINA', 1, NULL, NULL, NULL),
130(15, 'BANCO DE LA PAMPA SOCIEDAD DE ECONOMÃA MIXTA', 1, NULL, NULL, NULL),
131(16, 'BANCO DE LA PROVINCIA DE BUENOS AIRES', 1, NULL, NULL, NULL),
132(17, 'BANCO DE LA PROVINCIA DE CORDOBA S.A.', 1, NULL, NULL, NULL),
133(18, 'BANCO DE LA REPUBLICA ORIENTAL DEL URUGUAY', 1, NULL, NULL, NULL),
134(19, 'BANCO DE SAN JUAN S.A.', 1, NULL, NULL, NULL),
135(20, 'BANCO DE SANTA CRUZ S.A.', 1, NULL, NULL, NULL),
136(21, 'BANCO DE SANTIAGO DEL ESTERO S.A.', 1, NULL, NULL, NULL),
137(22, 'BANCO DE SERVICIOS FINANCIEROS S.A.', 1, NULL, NULL, NULL),
138(23, 'BANCO DE SERVICIOS Y TRANSACCIONES S.A.', 1, NULL, NULL, NULL),
139(24, 'BANCO DE VALORES S.A.', 1, NULL, NULL, NULL),
140(25, 'BANCO DEL CHUBUT S.A.', 1, NULL, NULL, NULL),
141(26, 'BANCO DEL SOL S.A.', 1, NULL, NULL, NULL),
142(27, 'BANCO DEL TUCUMAN S.A.', 1, NULL, NULL, NULL),
143(28, 'BANCO DO BRASIL S.A.', 1, NULL, NULL, NULL),
144(29, 'BANCO FINANSUR S.A.', 1, NULL, NULL, NULL),
145(30, 'BANCO HIPOTECARIO S.A.', 1, NULL, NULL, NULL),
146(31, 'BANCO INDUSTRIAL S.A.', 1, NULL, NULL, NULL),
147(32, 'BANCO INTERFINANZAS S.A.', 1, NULL, NULL, NULL),
148(33, 'BANCO ITAU ARGENTINA S.A.', 1, NULL, NULL, NULL),
149(34, 'BANCO JULIO SOCIEDAD ANONIMA', 1, NULL, NULL, NULL),
150(35, 'BANCO MACRO S.A.', 1, NULL, NULL, NULL),
151(36, 'BANCO MARIVA S.A.', 1, NULL, NULL, NULL),
152(37, 'BANCO MASVENTAS S.A.', 1, NULL, NULL, NULL),
153(38, 'BANCO MERIDIAN S.A.', 1, NULL, NULL, NULL),
154(39, 'BANCO MUNICIPAL DE ROSARIO', 1, NULL, NULL, NULL),
155(40, 'BANCO PATAGONIA S.A.', 1, NULL, NULL, NULL),
156(41, 'BANCO PIANO S.A.', 1, NULL, NULL, NULL),
157(42, 'BANCO PRIVADO DE INVERSIONES SOCIEDAD ANONIMA', 1, NULL, NULL, NULL),
158(43, 'BANCO PROVINCIA DE TIERRA DEL FUEGO', 1, NULL, NULL, NULL),
159(44, 'BANCO PROVINCIA DEL NEUQUÃ‰N SOCIEDAD ANÃ“NIMA', 1, NULL, NULL, NULL),
160(45, 'BANCO ROELA S.A.', 1, NULL, NULL, NULL),
161(46, 'BANCO SAENZ S.A.', 1, NULL, NULL, NULL),
162(47, 'BANCO SANTANDER RIO S.A.', 1, NULL, NULL, NULL),
163(48, 'BANCO SUPERVIELLE S.A.', 1, NULL, NULL, NULL),
164(49, 'BANK OF AMERICA, NATIONAL ASSOCIATION', 1, NULL, NULL, NULL),
165(50, 'BBVA BANCO FRANCES S.A.', 1, NULL, NULL, NULL),
166(51, 'BNP PARIBAS', 1, NULL, NULL, NULL),
167(52, 'CAJA DE CREDITO COOPERATIVA LA CAPITAL DEL PLATA LIMITADA', 1, NULL, NULL, NULL),
168(53, 'CAJA DE CREDITO CUENCA COOPERATIVA LIMITADA', 1, NULL, NULL, NULL),
169(54, 'CITIBANK N.A.', 1, NULL, NULL, NULL),
170(55, 'COMPAÃ‘ÃA FINANCIERA ARGENTINA S.A.', 1, NULL, NULL, NULL),
171(56, 'CORDIAL COMPAÃ‘ÃA FINANCIERA S.A.', 1, NULL, NULL, NULL),
172(57, 'DEUTSCHE BANK S.A.', 1, NULL, NULL, NULL),
173(58, 'FIAT CREDITO COMPAÃ‘ÃA FINANCIERA S.A.', 1, NULL, NULL, NULL),
174(59, 'FINANDINO COMPAÃ‘ÃA FINANCIERA S.A.', 1, NULL, NULL, NULL),
175(60, 'FORD CREDIT COMPAÃ‘ÃA FINANCIERA S.A.', 1, NULL, NULL, NULL),
176(61, 'GPAT COMPAÃ‘ÃA FINANCIERA S.A.', 1, NULL, NULL, NULL),
177(62, 'HSBC BANK ARGENTINA S.A.', 1, NULL, NULL, NULL),
178(63, 'INDUSTRIAL AND COMMERCIAL BANK OF CHINA (ARGENTINA); S.A.', 1, NULL, NULL, NULL),
179(64, 'JOHN DEERE CREDIT COMPAÃ‘ÃA FINANCIERA S.A.', 1, NULL, NULL, NULL),
180(65, 'JPMORGAN CHASE BANK, NATIONAL ASSOCIATION (SUC. BS. AS.)', 1, NULL, NULL, NULL),
181(66, 'MBA LAZARD BANCO DE INVERSIONES S. A.', 1, NULL, NULL, NULL),
182(67, 'MERCEDES-BENZ COMPAÃ‘ÃA FINANCIERA ARGENT', 1, NULL, NULL, NULL),
183(68, 'METROPOLIS COMPAÃ‘ÃA FINANCIERA S.A.', 1, NULL, NULL, NULL),
184(69, 'MONTEMAR COMPAÃ‘ÃA FINANCIERA S.A.', 1, NULL, NULL, NULL),
185(70, 'MULTIFINANZAS COMPAÃ‘ÃA FINANCIERA S.A.', 1, NULL, NULL, NULL),
186(71, 'NUEVO BANCO DE ENTRE RÃOS S.A.', 1, NULL, NULL, NULL),
187(72, 'NUEVO BANCO DE LA RIOJA SOCIEDAD ANONIMA', 1, NULL, NULL, NULL),
188(73, 'NUEVO BANCO DE SANTA FE SOCIEDAD ANONIMA', 1, NULL, NULL, NULL),
189(74, 'NUEVO BANCO DEL CHACO S.A.', 1, NULL, NULL, NULL),
190(75, 'PSA FINANCE ARGENTINA COMPAÃ‘ÃA FINANCIERA', 1, NULL, NULL, NULL),
191(76, 'RCI BANQUE S.A.', 1, NULL, NULL, NULL),
192(77, 'ROMBO COMPAÃ‘ÃA FINANCIERA S.A.', 1, NULL, NULL, NULL),
193(78, 'THE BANK OF TOKYO-MITSUBISHI UFJ, LTD.', 1, NULL, NULL, NULL),
194(79, 'THE ROYAL BANK OF SCOTLAND N.V.', 1, NULL, NULL, NULL),
195(80, 'TOYOTA COMPAÃ‘ÃA FINANCIERA DE ARGENTINA', 1, NULL, NULL, NULL),
196(81, 'VOLKSWAGEN CREDIT COMPAÃ‘ÃA FINANCIERA S.', 1, NULL, NULL, NULL);
197
198SET IDENTITY_INSERT "bancos" OFF;
199
200-- --------------------------------------------------------
201
202--
203-- Estructura de tabla para la tabla "banco_moneda"
204--
205
206CREATE TABLE "banco_moneda" ;
207
208--
209-- Volcado de datos para la tabla "banco_moneda"
210--
211
212SET IDENTITY_INSERT "banco_moneda" ON ;
213INSERT INTO "banco_moneda" ("id", "banco_id", "moneda_id") VALUES
214(1, 1, 1),
215(2, 1, 2),
216(3, 2, 1),
217(4, 2, 2),
218(5, 3, 1),
219(6, 3, 2),
220(7, 4, 1),
221(8, 4, 2),
222(9, 5, 1),
223(10, 5, 2),
224(11, 6, 1),
225(12, 6, 2),
226(13, 7, 1),
227(14, 7, 2),
228(15, 8, 1),
229(16, 8, 2),
230(17, 9, 1),
231(18, 9, 2),
232(20, 10, 2),
233(21, 11, 1),
234(22, 11, 2),
235(23, 12, 1),
236(24, 12, 2),
237(26, 13, 2),
238(27, 14, 1),
239(28, 14, 2),
240(29, 15, 1),
241(30, 15, 2),
242(31, 16, 1),
243(32, 16, 2),
244(33, 17, 1),
245(34, 17, 2),
246(35, 18, 1),
247(36, 18, 2),
248(37, 19, 1),
249(38, 19, 2),
250(39, 20, 1),
251(40, 20, 2),
252(41, 21, 1),
253(42, 21, 2),
254(43, 22, 1),
255(44, 22, 2),
256(45, 23, 1),
257(46, 23, 2),
258(47, 24, 1),
259(48, 24, 2),
260(49, 25, 1),
261(50, 25, 2),
262(51, 26, 1),
263(52, 26, 2),
264(53, 27, 1),
265(54, 27, 2),
266(55, 28, 1),
267(56, 28, 2),
268(57, 29, 1),
269(58, 29, 2),
270(59, 30, 1),
271(60, 30, 2),
272(61, 31, 1),
273(62, 31, 2),
274(63, 32, 1),
275(64, 32, 2),
276(65, 33, 1),
277(66, 33, 2),
278(67, 34, 1),
279(68, 34, 2),
280(69, 35, 1),
281(70, 35, 2),
282(71, 36, 1),
283(72, 36, 2),
284(73, 37, 1),
285(74, 37, 2),
286(75, 38, 1),
287(76, 38, 2),
288(77, 39, 1),
289(78, 39, 2),
290(79, 40, 1),
291(80, 40, 2),
292(81, 41, 1),
293(82, 41, 2),
294(83, 42, 1),
295(84, 42, 2),
296(85, 43, 1),
297(86, 43, 2),
298(87, 44, 1),
299(88, 44, 2),
300(89, 45, 1),
301(90, 45, 2),
302(91, 46, 1),
303(92, 46, 2),
304(93, 47, 1),
305(94, 47, 2),
306(95, 48, 1),
307(96, 48, 2),
308(97, 49, 1),
309(98, 49, 2),
310(99, 49, 3),
311(100, 50, 1),
312(101, 50, 2),
313(102, 51, 1),
314(103, 51, 2),
315(104, 52, 1),
316(105, 52, 2),
317(106, 53, 1),
318(107, 53, 2),
319(108, 54, 1),
320(109, 54, 2),
321(110, 55, 1),
322(111, 55, 2),
323(112, 56, 1),
324(113, 56, 2),
325(114, 57, 1),
326(115, 57, 2),
327(116, 58, 1),
328(117, 58, 2),
329(118, 59, 1),
330(119, 59, 2),
331(120, 60, 1),
332(121, 60, 2),
333(122, 61, 1),
334(123, 61, 2),
335(124, 62, 1),
336(125, 62, 2),
337(126, 63, 1),
338(127, 63, 2),
339(128, 64, 1),
340(129, 64, 2),
341(130, 65, 1),
342(131, 65, 2),
343(132, 66, 1),
344(133, 66, 2),
345(134, 67, 1),
346(135, 67, 2),
347(136, 68, 1),
348(137, 68, 2),
349(138, 69, 1),
350(139, 69, 2),
351(140, 70, 1),
352(141, 70, 2),
353(142, 71, 1),
354(143, 71, 2),
355(144, 72, 1),
356(145, 72, 2),
357(146, 73, 1),
358(147, 73, 2),
359(148, 74, 1),
360(149, 74, 2),
361(150, 75, 1),
362(151, 75, 2),
363(152, 76, 1),
364(153, 76, 2),
365(154, 77, 1),
366(155, 77, 2),
367(156, 78, 1),
368(157, 78, 2),
369(158, 79, 1),
370(159, 79, 2),
371(160, 80, 1),
372(161, 80, 2),
373(162, 81, 1),
374(163, 81, 2);
375
376SET IDENTITY_INSERT "banco_moneda" OFF;
377
378-- --------------------------------------------------------
379
380--
381-- Estructura de tabla para la tabla "comitente_usuario"
382--
383
384CREATE TABLE "comitente_usuario" ;
385
386--
387-- Volcado de datos para la tabla "comitente_usuario"
388--
389
390SET IDENTITY_INSERT "comitente_usuario" ON ;
391INSERT INTO "comitente_usuario" ("id", "nro_comitente", "usuario_id", "tipo_usuario_id") VALUES
392(27, 10014, 15, 2),
393(31, 10016, 15, 2),
394(32, 10016, 16, 2),
395(33, 10016, 16, 1),
396(34, 10014, 16, 1),
397(38, 10014, 17, 2),
398(39, 10016, 17, 2),
399(40, 10016, 17, 1),
400(41, 61035, 17, 1),
401(47, 100057, 18, 1),
402(53, 100484, 19, 1),
403(54, 10014, 13, 2),
404(55, 31, 20, 2),
405(56, 31, 20, 1),
406(58, 111471, 1, 1),
407(61, 100484, 1, 1),
408(62, 1, 13, 2),
409(63, 1103063, 21, 2),
410(64, 1103063, 21, 1),
411(65, 48, 22, 2),
412(66, 48, 22, 1),
413(67, 10475, 1, 2);
414
415SET IDENTITY_INSERT "comitente_usuario" OFF;
416
417-- --------------------------------------------------------
418
419--
420-- Estructura de tabla para la tabla "cuentas_bancarias"
421--
422
423CREATE TABLE "cuentas_bancarias" ;
424
425--
426-- Volcado de datos para la tabla "cuentas_bancarias"
427--
428
429SET IDENTITY_INSERT "cuentas_bancarias" ON ;
430INSERT 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
431(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'),
432(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');
433
434SET IDENTITY_INSERT "cuentas_bancarias" OFF;
435
436-- --------------------------------------------------------
437
438--
439-- Estructura de tabla para la tabla "cuentas_bancarias_dolar_divisa"
440--
441
442CREATE TABLE "cuentas_bancarias_dolar_divisa" ;
443
444--
445-- Volcado de datos para la tabla "cuentas_bancarias_dolar_divisa"
446--
447
448SET IDENTITY_INSERT "cuentas_bancarias_dolar_divisa" ON ;
449INSERT 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
450(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),
451(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),
452(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);
453
454SET IDENTITY_INSERT "cuentas_bancarias_dolar_divisa" OFF;
455
456-- --------------------------------------------------------
457
458--
459-- Estructura de tabla para la tabla "cuentas_bancarias_intl"
460--
461
462CREATE TABLE "cuentas_bancarias_intl" ;
463
464--
465-- Volcado de datos para la tabla "cuentas_bancarias_intl"
466--
467
468SET IDENTITY_INSERT "cuentas_bancarias_intl" ON ;
469INSERT INTO "cuentas_bancarias_intl" ("id", "nombre", "cbu", "nro_cuenta", "habilitada", "moneda_id", "created_at", "updated_at", "deleted_at", "cod_cuenta_bancaria_esco", "defecto") VALUES
470(15, 'Banco de Valores', '', '240/2', 1, 1, NULL, NULL, NULL, 2, 1),
471(16, 'Banco Galicia', '', '48966/9 999/4', 1, 1, NULL, NULL, NULL, 3, 0),
472(17, 'Banco de la Ciudad de Buenos Aires', '', '999-25226-5', 0, 1, NULL, NULL, NULL, 4, 0),
473(18, 'Santander Rio', '', '000-21665-2', 1, 1, NULL, NULL, NULL, 5, 0),
474(19, 'Banco Frances', '', '099-677166/5', 0, 1, NULL, NULL, NULL, 6, 0),
475(20, 'HSBC Bank', '', '0013214663', 0, 1, NULL, NULL, NULL, 7, 0),
476(21, 'Banco Citibank', '', '0192417112', 0, 1, NULL, NULL, NULL, 8, 0),
477(22, 'Banco de la Nacion Argentina', '', '50205/44', 0, 1, NULL, NULL, NULL, 9, 0),
478(23, 'Banco de la Provincia de Buenos Aires', '', '1000-5052/6', 0, 1, NULL, NULL, NULL, 10, 0),
479(24, 'Banco Macro .', '', '35400-011083356/3', 1, 1, NULL, NULL, NULL, 11, 0),
480(25, 'Banco Patagonia', '', '100011428', 1, 1, NULL, NULL, NULL, 14, 0),
481(26, 'Banco Macro', '', '8-005823-8', 0, 1, NULL, NULL, NULL, 16, 0),
482(27, 'Banco Comafi', '', '0080-18431/5', 0, 1, NULL, NULL, NULL, 17, 0),
483(28, 'STANDARD CHARTERED', '', '3544-053057-070', 0, 2, NULL, NULL, NULL, 20, 0),
484(29, 'Banco Macro (pago a proveedores)', '', '35400-940000304-6', 0, 1, NULL, NULL, NULL, 21, 0),
485(30, 'Banco Macro .', '', '1002', 0, 1, NULL, NULL, NULL, 22, 0),
486(31, 'Banco Macro (cta recaudadora)', '', '454009400410655', 0, 1, NULL, NULL, NULL, 23, 0),
487(32, 'Deutsche Bank', '', '660012910', 0, 1, NULL, NULL, NULL, 24, 0),
488(33, 'Deutsche Bank S.A. (Cta. Cte.)', '', '104023540024', 0, 1, NULL, NULL, NULL, 25, 0),
489(34, 'Transferencias Internas', '', '111111111', 0, 1, NULL, NULL, NULL, 26, 0),
490(35, 'Banco Macro (cta recaudadora)', '', '123456', 0, 2, NULL, NULL, NULL, 27, 0),
491(36, 'BANCO FINANSUR', '', '40190/7', 0, 1, NULL, NULL, NULL, 28, 0),
492(37, 'Banco Macro CV 10000 ME', '', '254009405050582', 1, 2, NULL, NULL, NULL, 29, 0),
493(38, 'Banco Macro.', '', '1004', 0, 2, NULL, NULL, NULL, 30, 0),
494(39, 'HSBC Bank', '', '164208', 0, 2, NULL, NULL, NULL, 31, 0),
495(40, 'HSBC Bank', '', '300346568', 0, 1, NULL, NULL, NULL, 32, 0),
496(41, 'HSBC Bank', '', '3008447969', 0, 2, NULL, NULL, NULL, 33, 0),
497(42, 'Bank Of AmÃ©rica', '', '446015624527', 0, 2, NULL, NULL, NULL, 36, 0),
498(43, 'BANCO COLUMBIA', '', '02-0052057166/6', 0, 1, NULL, NULL, NULL, 37, 0),
499(44, 'Banco emisor licitaciones primarias', '', '0', 0, 1, NULL, NULL, NULL, 38, 0),
500(45, 'BANCO COLUMBIA', '', '04-005205654/2', 0, 2, NULL, NULL, NULL, 39, 0),
501(46, 'Banco de Valores', '', '104269/9', 1, 2, NULL, NULL, NULL, 40, 1),
502(47, 'Banco de Valores', '', '10', 0, 1, NULL, NULL, NULL, 41, 0),
503(48, 'Banco de Valores', '', '104269-9', 0, 2, NULL, NULL, NULL, 42, 0),
504(49, 'Banco Macro CV 10000 ME', '', '254-00940505582', 0, 2, NULL, NULL, NULL, 43, 0),
505(50, 'Banco Emisor de Licitaciones Primarias MAE', '', '0', 0, 1, NULL, NULL, NULL, 45, 0),
506(51, 'Banco emisor licitaciones primarias DÃ³lar Cable', '', '0', 0, 2, NULL, NULL, NULL, 46, 0),
507(52, 'Banco emisor licitaciones primarias DÃ³lar MEP', '', '0', 0, 2, NULL, NULL, NULL, 47, 0),
508(53, 'Banco emisor licitaciones primarias DÃ³lar MEP', '', '00', 0, 2, NULL, NULL, NULL, 48, 0),
509(54, 'Bank of America', '', '4460 1562 4527', 1, 3, NULL, NULL, NULL, 36, 1);
510
511SET IDENTITY_INSERT "cuentas_bancarias_intl" OFF;
512
513-- --------------------------------------------------------
514
515--
516-- Estructura de tabla para la tabla "depositos"
517--
518
519CREATE TABLE "depositos" ;
520
521--
522-- Volcado de datos para la tabla "depositos"
523--
524
525SET IDENTITY_INSERT "depositos" ON ;
526INSERT 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
527(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),
528(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),
529(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),
530(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),
531(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),
532(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),
533(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),
534(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),
535(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),
536(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),
537(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),
538(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),
539(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),
540(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),
541(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),
542(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),
543(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),
544(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),
545(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),
546(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);
547
548SET IDENTITY_INSERT "depositos" OFF;
549
550-- --------------------------------------------------------
551
552--
553-- Estructura de tabla para la tabla "estado_cuenta_bancaria"
554--
555
556CREATE TABLE "estado_cuenta_bancaria" ;
557
558--
559-- Volcado de datos para la tabla "estado_cuenta_bancaria"
560--
561
562SET IDENTITY_INSERT "estado_cuenta_bancaria" ON ;
563INSERT INTO "estado_cuenta_bancaria" ("id", "nombre", "created_at", "updated_at", "deleted_at") VALUES
564(1, 'Pendiente', NULL, NULL, NULL),
565(2, 'Aceptado', NULL, NULL, NULL),
566(3, 'Rechazado', NULL, NULL, NULL);
567
568SET IDENTITY_INSERT "estado_cuenta_bancaria" OFF;
569
570-- --------------------------------------------------------
571
572--
573-- Estructura de tabla para la tabla "estado_deposito"
574--
575
576CREATE TABLE "estado_deposito" ;
577
578--
579-- Volcado de datos para la tabla "estado_deposito"
580--
581
582SET IDENTITY_INSERT "estado_deposito" ON ;
583INSERT INTO "estado_deposito" ("id", "nombre", "deleted_at") VALUES
584(1, 'Pendiente', NULL),
585(2, 'Aceptado', NULL),
586(3, 'Rechazado', NULL);
587
588SET IDENTITY_INSERT "estado_deposito" OFF;
589
590-- --------------------------------------------------------
591
592--
593-- Estructura de tabla para la tabla "estado_transferencia"
594--
595
596CREATE TABLE "estado_transferencia" ;
597
598--
599-- Volcado de datos para la tabla "estado_transferencia"
600--
601
602SET IDENTITY_INSERT "estado_transferencia" ON ;
603INSERT INTO "estado_transferencia" ("id", "nombre", "created_at", "updated_at", "deleted_at") VALUES
604(1, 'Pendiente', NULL, NULL, NULL),
605(2, 'Aceptado', NULL, NULL, NULL),
606(3, 'Rechazado', NULL, NULL, NULL);
607
608SET IDENTITY_INSERT "estado_transferencia" OFF;
609
610-- --------------------------------------------------------
611
612--
613-- Estructura de tabla para la tabla "migrations"
614--
615
616CREATE TABLE "migrations" ;
617
618--
619-- Volcado de datos para la tabla "migrations"
620--
621
622SET IDENTITY_INSERT "migrations" ON ;
623INSERT INTO "migrations" ("id", "migration", "batch") VALUES
624(1, '2014_10_12_000000_create_backend_users_table', 1),
625(2, '2014_10_12_100000_create_password_resets_table', 1),
626(3, '2017_05_10_151140_agregar_email_a_backend_users', 1),
627(4, '2017_05_10_154804_cambiar_nombre_id_backend_users', 1),
628(5, '2017_05_10_160436_create_users_table', 1),
629(6, '2017_05_10_162644_agregar_apellido_a_users', 1),
630(7, '2017_05_11_111126_cambiar_nombre_a_password', 1),
631(8, '2017_05_11_122601_create_permisos_table', 1),
632(9, '2017_05_11_123400_create_permiso_usuario_table', 1),
633(10, '2017_05_12_090630_agregar_apellido_a_backend_users', 1),
634(11, '2017_05_12_120622_agregar_last_login_a_backend_users', 1),
635(12, '2017_05_12_133339_create_estado_deposito_table', 1),
636(13, '2017_05_12_133953_create_moneda_table', 1),
637(14, '2017_05_12_142917_create_bancos_table', 1),
638(15, '2017_05_12_143300_create_banco_moneda_table', 1),
639(16, '2017_05_15_104452_create_cuentas_bancarias_intl_table', 1),
640(40, '2017_05_15_172052_create_depositos_table', 2),
641(41, '2017_05_16_112900_cambiar_campo_password_users_table', 2),
642(42, '2017_05_16_113120_agregar_last_login_users', 2),
643(43, '2017_05_16_124647_agregar_comprobante_a_depositos_table', 2),
644(44, '2017_05_16_132818_agregar_tiempos_a_depositos_table', 2),
645(45, '2017_05_18_100825_agregar_fecha_esco_depositos', 2),
646(65, '2017_05_19_133025_create_tipo_cuenta_bancaria_table', 3),
647(66, '2017_05_19_133202_create_cuentas_bancarias_table', 3),
648(67, '2017_05_19_145202_create_estado_cuenta_bancaria_table', 3),
649(68, '2017_05_19_150105_agregar_estado_id_a_cuentas_bancarias_table', 3),
650(70, '2017_05_19_150818_agregar_usuario_id_a_cuentas_bancarias_table', 4),
651(72, '2017_05_22_114213_quitar_unique_a_cbu_cuentas_bancarias', 5),
652(82, '2017_05_22_132601_create_transferencias_table', 6),
653(83, '2017_05_23_110239_create_estado_transferencia_table', 6),
654(84, '2017_05_23_110335_agregar_estado_id_a_transferencias_table', 6),
655(88, '2017_05_23_141307_agregar_banco_a_transferencias_table', 7),
656(90, '2017_05_24_141343_agregar_num_persona_a_users_table', 8),
657(92, '2017_05_24_144918_eliminar_comitente_de_users', 9),
658(94, '2017_05_24_145135_create_comitente_usuario_table', 10),
659(97, '2017_05_30_094919_cambiar_nombre_a_comitente_id_comitente_usuario_table', 11),
660(100, '2017_05_30_104043_agregar_nulls_a_users', 12),
661(105, '2017_05_30_135323_crear_tipo_comitente_usuario_table', 13),
662(106, '2017_05_30_135625_agregar_tipo_comitente_usuario_id', 13),
663(108, '2017_06_05_143449_agregar_aprobador_id_depositos_table', 14),
664(112, '2017_06_07_102559_cambiar_nombre_origen_transferencias_table', 15),
665(113, '2017_06_07_133531_agregar_datos_comitente_deposito', 16),
666(115, '2017_06_07_134503_agregar_datos_comitente_cuentas_bancarias_table', 17),
667(121, '2017_06_08_153116_agregar_fecha_transaccion_transferencias_table', 18),
668(123, '2017_06_09_113003_agregar_cbu_nro_cuenta_bancos_intl', 19),
669(126, '2017_06_09_120209_agregar_banco_origen_intl_transferencias_table', 20),
670(129, '2017_06_09_134546_agregar_moneda_id_cuenta_intl', 21),
671(131, '2017_06_12_122136_agregar_defecto_cuentas_bancarias_intl', 22),
672(137, '2017_06_19_084512_create_cuentas_bancarias_dolar_divisa_table', 23),
673(138, '2017_06_22_112419_agregar_nulls_a_cuentas_bancarias_table', 24),
674(140, '2017_06_23_115654_agregar_id_y_cod_interfaz_a_monedas_table', 25),
675(141, '2017_06_23_132851_agregar_nulo_tipo_cuenta_transferencias', 26),
676(145, '2017_06_26_123700_agregar_inst_permanente_cuentas_bancarias', 27),
677(149, '2017_06_28_095100_cambiar_tipo_importe_deposito_y_transferencia', 28);
678
679SET IDENTITY_INSERT "migrations" OFF;
680
681-- --------------------------------------------------------
682
683--
684-- Estructura de tabla para la tabla "monedas"
685--
686
687CREATE TABLE "monedas" ;
688
689--
690-- Volcado de datos para la tabla "monedas"
691--
692
693SET IDENTITY_INSERT "monedas" ON ;
694INSERT INTO "monedas" ("id", "nombre", "created_at", "updated_at", "deleted_at", "id_esco", "cod_interfaz_esco") VALUES
695(1, 'Pesos', NULL, NULL, NULL, 1, 0),
696(2, 'Dolares', NULL, NULL, NULL, 2, 1),
697(3, 'Dolar Divisa', NULL, NULL, NULL, 2, 1);
698
699SET IDENTITY_INSERT "monedas" OFF;
700
701-- --------------------------------------------------------
702
703--
704-- Estructura de tabla para la tabla "password_resets"
705--
706
707CREATE TABLE "password_resets" ;
708
709-- --------------------------------------------------------
710
711--
712-- Estructura de tabla para la tabla "tipo_comitente_usuario"
713--
714
715CREATE TABLE "tipo_comitente_usuario" ;
716
717--
718-- Volcado de datos para la tabla "tipo_comitente_usuario"
719--
720
721SET IDENTITY_INSERT "tipo_comitente_usuario" ON ;
722INSERT INTO "tipo_comitente_usuario" ("id", "nombre") VALUES
723(1, 'Operador'),
724(2, 'Vista');
725
726SET IDENTITY_INSERT "tipo_comitente_usuario" OFF;
727
728-- --------------------------------------------------------
729
730--
731-- Estructura de tabla para la tabla "tipo_cuenta_bancaria"
732--
733
734CREATE TABLE "tipo_cuenta_bancaria" ;
735
736--
737-- Volcado de datos para la tabla "tipo_cuenta_bancaria"
738--
739
740SET IDENTITY_INSERT "tipo_cuenta_bancaria" ON ;
741INSERT INTO "tipo_cuenta_bancaria" ("id", "nombre", "created_at", "updated_at", "deleted_at") VALUES
742(1, 'Caja de Ahorro', NULL, NULL, NULL),
743(2, 'Cuenta Corriente', NULL, NULL, NULL);
744
745SET IDENTITY_INSERT "tipo_cuenta_bancaria" OFF;
746
747-- --------------------------------------------------------
748
749--
750-- Estructura de tabla para la tabla "transferencias"
751--
752
753CREATE TABLE "transferencias" ;
754
755--
756-- Volcado de datos para la tabla "transferencias"
757--
758
759SET IDENTITY_INSERT "transferencias" ON ;
760INSERT 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
761(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),
762(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),
763(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),
764(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),
765(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),
766(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),
767(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),
768(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),
769(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),
770(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),
771(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),
772(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),
773(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),
774(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),
775(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),
776(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),
777(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),
778(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),
779(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);
780
781SET IDENTITY_INSERT "transferencias" OFF;
782
783-- --------------------------------------------------------
784
785--
786-- Estructura de tabla para la tabla "users"
787--
788
789CREATE TABLE "users" ;
790
791--
792-- Volcado de datos para la tabla "users"
793--
794
795SET IDENTITY_INSERT "users" ON ;
796INSERT 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
797(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'),
798(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),
799(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),
800(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),
801(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),
802(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),
803(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),
804(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),
805(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),
806(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);
807
808SET IDENTITY_INSERT "users" OFF;
809SET FOREIGN_KEY_CHECKS=1;
810
811/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
812/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
813/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;