· 9 years ago · Jul 04, 2017, 06:40 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:39:36
7-- Versión del servidor: 10.1.21-MariaDB
8-- Versión de PHP: 5.6.30
9
10SET FOREIGN_KEY_CHECKS=0;
11SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
12SET time_zone = "+00:00";
13
14
15/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
16/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
17/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
18/*!40101 SET NAMES utf8mb4 */;
19
20--
21-- Base de datos: `intl_trading`
22--
23CREATE DATABASE IF NOT EXISTS `intl_trading` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
24USE `intl_trading`;
25
26-- --------------------------------------------------------
27
28--
29-- Estructura de tabla para la tabla `backend_permisos`
30--
31
32CREATE TABLE `backend_permisos` (
33 `id` int(10) UNSIGNED NOT NULL,
34 `backend_permisos_nombre` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
35 `created_at` timestamp NULL DEFAULT NULL,
36 `updated_at` timestamp NULL DEFAULT NULL,
37 `deleted_at` timestamp NULL DEFAULT NULL
38) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
39
40--
41-- Volcado de datos para la tabla `backend_permisos`
42--
43
44INSERT INTO `backend_permisos` (`id`, `backend_permisos_nombre`, `created_at`, `updated_at`, `deleted_at`) VALUES
45(1, 'Gerencia', NULL, NULL, NULL),
46(2, 'TesorerÃa', NULL, NULL, NULL),
47(3, 'Cuentas Bancarias', NULL, NULL, NULL),
48(4, 'Gestión Fondos', NULL, NULL, NULL),
49(5, 'Gestión de Internos', NULL, NULL, NULL);
50
51-- --------------------------------------------------------
52
53--
54-- Estructura de tabla para la tabla `backend_permiso_usuario`
55--
56
57CREATE TABLE `backend_permiso_usuario` (
58 `id` int(10) UNSIGNED NOT NULL,
59 `permiso_id` int(10) UNSIGNED NOT NULL,
60 `usuario_id` int(10) UNSIGNED NOT NULL,
61 `created_at` timestamp NULL DEFAULT NULL,
62 `updated_at` timestamp NULL DEFAULT NULL
63) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
64
65--
66-- Volcado de datos para la tabla `backend_permiso_usuario`
67--
68
69INSERT INTO `backend_permiso_usuario` (`id`, `permiso_id`, `usuario_id`, `created_at`, `updated_at`) VALUES
70(1, 1, 1, NULL, NULL),
71(3, 2, 1, NULL, NULL),
72(4, 2, 2, NULL, NULL),
73(5, 3, 2, NULL, NULL),
74(6, 1, 3, NULL, NULL),
75(7, 3, 3, NULL, NULL),
76(15, 4, 6, NULL, NULL),
77(16, 2, 7, NULL, NULL),
78(17, 3, 1, NULL, NULL),
79(18, 2, 3, NULL, NULL),
80(19, 2, 8, NULL, NULL),
81(20, 3, 8, NULL, NULL),
82(21, 2, 9, NULL, NULL),
83(22, 2, 6, NULL, NULL);
84
85-- --------------------------------------------------------
86
87--
88-- Estructura de tabla para la tabla `backend_users`
89--
90
91CREATE TABLE `backend_users` (
92 `id` int(10) UNSIGNED NOT NULL,
93 `backend_users_nombre` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
94 `backend_users_email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
95 `backend_users_username` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
96 `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
97 `backend_users_bloqueado` tinyint(1) NOT NULL DEFAULT '0',
98 `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
99 `last_login` datetime DEFAULT NULL,
100 `created_at` timestamp NULL DEFAULT NULL,
101 `updated_at` timestamp NULL DEFAULT NULL,
102 `deleted_at` timestamp NULL DEFAULT NULL,
103 `backend_users_apellido` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL
104) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
105
106--
107-- Volcado de datos para la tabla `backend_users`
108--
109
110INSERT 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
111(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'),
112(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'),
113(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'),
114(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'),
115(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'),
116(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'),
117(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');
118
119-- --------------------------------------------------------
120
121--
122-- Estructura de tabla para la tabla `bancos`
123--
124
125CREATE TABLE `bancos` (
126 `id` int(10) UNSIGNED NOT NULL,
127 `nombre` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
128 `habilitado` tinyint(1) NOT NULL,
129 `created_at` timestamp NULL DEFAULT NULL,
130 `updated_at` timestamp NULL DEFAULT NULL,
131 `deleted_at` timestamp NULL DEFAULT NULL
132) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
133
134--
135-- Volcado de datos para la tabla `bancos`
136--
137
138INSERT INTO `bancos` (`id`, `nombre`, `habilitado`, `created_at`, `updated_at`, `deleted_at`) VALUES
139(1, 'AMERICAN EXPRESS BANK LTD. SOCIEDAD ANON', 1, NULL, NULL, NULL),
140(2, 'BACS BANCO DE CREDITO Y SECURITIZACION S', 1, NULL, NULL, NULL),
141(3, 'BANCO BICA S.A.', 1, NULL, NULL, NULL),
142(4, 'BANCO BRADESCO ARGENTINA S.A.', 1, NULL, NULL, NULL),
143(5, 'BANCO CETELEM ARGENTINA S.A.', 1, NULL, NULL, NULL),
144(6, 'BANCO CMF S.A.', 1, NULL, NULL, NULL),
145(7, 'BANCO COLUMBIA S.A.', 1, NULL, NULL, NULL),
146(8, 'BANCO COMAFI SOCIEDAD ANONIMA', 1, NULL, NULL, NULL),
147(9, 'BANCO CREDICOOP COOPERATIVO LIMITADO', 1, NULL, NULL, NULL),
148(10, 'BANCO DE CORRIENTES S.A.', 1, NULL, NULL, NULL),
149(11, 'BANCO DE GALICIA Y BUENOS AIRES S.A.', 1, NULL, NULL, NULL),
150(12, 'BANCO DE INVERSION Y COMERCIO EXTERIOR S.A.', 1, NULL, NULL, NULL),
151(13, 'BANCO DE LA CIUDAD DE BUENOS AIRES', 1, NULL, NULL, NULL),
152(14, 'BANCO DE LA NACION ARGENTINA', 1, NULL, NULL, NULL),
153(15, 'BANCO DE LA PAMPA SOCIEDAD DE ECONOMÃA MIXTA', 1, NULL, NULL, NULL),
154(16, 'BANCO DE LA PROVINCIA DE BUENOS AIRES', 1, NULL, NULL, NULL),
155(17, 'BANCO DE LA PROVINCIA DE CORDOBA S.A.', 1, NULL, NULL, NULL),
156(18, 'BANCO DE LA REPUBLICA ORIENTAL DEL URUGUAY', 1, NULL, NULL, NULL),
157(19, 'BANCO DE SAN JUAN S.A.', 1, NULL, NULL, NULL),
158(20, 'BANCO DE SANTA CRUZ S.A.', 1, NULL, NULL, NULL),
159(21, 'BANCO DE SANTIAGO DEL ESTERO S.A.', 1, NULL, NULL, NULL),
160(22, 'BANCO DE SERVICIOS FINANCIEROS S.A.', 1, NULL, NULL, NULL),
161(23, 'BANCO DE SERVICIOS Y TRANSACCIONES S.A.', 1, NULL, NULL, NULL),
162(24, 'BANCO DE VALORES S.A.', 1, NULL, NULL, NULL),
163(25, 'BANCO DEL CHUBUT S.A.', 1, NULL, NULL, NULL),
164(26, 'BANCO DEL SOL S.A.', 1, NULL, NULL, NULL),
165(27, 'BANCO DEL TUCUMAN S.A.', 1, NULL, NULL, NULL),
166(28, 'BANCO DO BRASIL S.A.', 1, NULL, NULL, NULL),
167(29, 'BANCO FINANSUR S.A.', 1, NULL, NULL, NULL),
168(30, 'BANCO HIPOTECARIO S.A.', 1, NULL, NULL, NULL),
169(31, 'BANCO INDUSTRIAL S.A.', 1, NULL, NULL, NULL),
170(32, 'BANCO INTERFINANZAS S.A.', 1, NULL, NULL, NULL),
171(33, 'BANCO ITAU ARGENTINA S.A.', 1, NULL, NULL, NULL),
172(34, 'BANCO JULIO SOCIEDAD ANONIMA', 1, NULL, NULL, NULL),
173(35, 'BANCO MACRO S.A.', 1, NULL, NULL, NULL),
174(36, 'BANCO MARIVA S.A.', 1, NULL, NULL, NULL),
175(37, 'BANCO MASVENTAS S.A.', 1, NULL, NULL, NULL),
176(38, 'BANCO MERIDIAN S.A.', 1, NULL, NULL, NULL),
177(39, 'BANCO MUNICIPAL DE ROSARIO', 1, NULL, NULL, NULL),
178(40, 'BANCO PATAGONIA S.A.', 1, NULL, NULL, NULL),
179(41, 'BANCO PIANO S.A.', 1, NULL, NULL, NULL),
180(42, 'BANCO PRIVADO DE INVERSIONES SOCIEDAD ANONIMA', 1, NULL, NULL, NULL),
181(43, 'BANCO PROVINCIA DE TIERRA DEL FUEGO', 1, NULL, NULL, NULL),
182(44, 'BANCO PROVINCIA DEL NEUQUÉN SOCIEDAD ANÓNIMA', 1, NULL, NULL, NULL),
183(45, 'BANCO ROELA S.A.', 1, NULL, NULL, NULL),
184(46, 'BANCO SAENZ S.A.', 1, NULL, NULL, NULL),
185(47, 'BANCO SANTANDER RIO S.A.', 1, NULL, NULL, NULL),
186(48, 'BANCO SUPERVIELLE S.A.', 1, NULL, NULL, NULL),
187(49, 'BANK OF AMERICA, NATIONAL ASSOCIATION', 1, NULL, NULL, NULL),
188(50, 'BBVA BANCO FRANCES S.A.', 1, NULL, NULL, NULL),
189(51, 'BNP PARIBAS', 1, NULL, NULL, NULL),
190(52, 'CAJA DE CREDITO COOPERATIVA LA CAPITAL DEL PLATA LIMITADA', 1, NULL, NULL, NULL),
191(53, 'CAJA DE CREDITO CUENCA COOPERATIVA LIMITADA', 1, NULL, NULL, NULL),
192(54, 'CITIBANK N.A.', 1, NULL, NULL, NULL),
193(55, 'COMPAÑÃA FINANCIERA ARGENTINA S.A.', 1, NULL, NULL, NULL),
194(56, 'CORDIAL COMPAÑÃA FINANCIERA S.A.', 1, NULL, NULL, NULL),
195(57, 'DEUTSCHE BANK S.A.', 1, NULL, NULL, NULL),
196(58, 'FIAT CREDITO COMPAÑÃA FINANCIERA S.A.', 1, NULL, NULL, NULL),
197(59, 'FINANDINO COMPAÑÃA FINANCIERA S.A.', 1, NULL, NULL, NULL),
198(60, 'FORD CREDIT COMPAÑÃA FINANCIERA S.A.', 1, NULL, NULL, NULL),
199(61, 'GPAT COMPAÑÃA FINANCIERA S.A.', 1, NULL, NULL, NULL),
200(62, 'HSBC BANK ARGENTINA S.A.', 1, NULL, NULL, NULL),
201(63, 'INDUSTRIAL AND COMMERCIAL BANK OF CHINA (ARGENTINA); S.A.', 1, NULL, NULL, NULL),
202(64, 'JOHN DEERE CREDIT COMPAÑÃA FINANCIERA S.A.', 1, NULL, NULL, NULL),
203(65, 'JPMORGAN CHASE BANK, NATIONAL ASSOCIATION (SUC. BS. AS.)', 1, NULL, NULL, NULL),
204(66, 'MBA LAZARD BANCO DE INVERSIONES S. A.', 1, NULL, NULL, NULL),
205(67, 'MERCEDES-BENZ COMPAÑÃA FINANCIERA ARGENT', 1, NULL, NULL, NULL),
206(68, 'METROPOLIS COMPAÑÃA FINANCIERA S.A.', 1, NULL, NULL, NULL),
207(69, 'MONTEMAR COMPAÑÃA FINANCIERA S.A.', 1, NULL, NULL, NULL),
208(70, 'MULTIFINANZAS COMPAÑÃA FINANCIERA S.A.', 1, NULL, NULL, NULL),
209(71, 'NUEVO BANCO DE ENTRE RÃOS S.A.', 1, NULL, NULL, NULL),
210(72, 'NUEVO BANCO DE LA RIOJA SOCIEDAD ANONIMA', 1, NULL, NULL, NULL),
211(73, 'NUEVO BANCO DE SANTA FE SOCIEDAD ANONIMA', 1, NULL, NULL, NULL),
212(74, 'NUEVO BANCO DEL CHACO S.A.', 1, NULL, NULL, NULL),
213(75, 'PSA FINANCE ARGENTINA COMPAÑÃA FINANCIERA', 1, NULL, NULL, NULL),
214(76, 'RCI BANQUE S.A.', 1, NULL, NULL, NULL),
215(77, 'ROMBO COMPAÑÃA FINANCIERA S.A.', 1, NULL, NULL, NULL),
216(78, 'THE BANK OF TOKYO-MITSUBISHI UFJ, LTD.', 1, NULL, NULL, NULL),
217(79, 'THE ROYAL BANK OF SCOTLAND N.V.', 1, NULL, NULL, NULL),
218(80, 'TOYOTA COMPAÑÃA FINANCIERA DE ARGENTINA', 1, NULL, NULL, NULL),
219(81, 'VOLKSWAGEN CREDIT COMPAÑÃA FINANCIERA S.', 1, NULL, NULL, NULL);
220
221-- --------------------------------------------------------
222
223--
224-- Estructura de tabla para la tabla `banco_moneda`
225--
226
227CREATE TABLE `banco_moneda` (
228 `id` int(10) UNSIGNED NOT NULL,
229 `banco_id` int(10) UNSIGNED NOT NULL,
230 `moneda_id` int(10) UNSIGNED NOT NULL
231) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
232
233--
234-- Volcado de datos para la tabla `banco_moneda`
235--
236
237INSERT INTO `banco_moneda` (`id`, `banco_id`, `moneda_id`) VALUES
238(1, 1, 1),
239(2, 1, 2),
240(3, 2, 1),
241(4, 2, 2),
242(5, 3, 1),
243(6, 3, 2),
244(7, 4, 1),
245(8, 4, 2),
246(9, 5, 1),
247(10, 5, 2),
248(11, 6, 1),
249(12, 6, 2),
250(13, 7, 1),
251(14, 7, 2),
252(15, 8, 1),
253(16, 8, 2),
254(17, 9, 1),
255(18, 9, 2),
256(20, 10, 2),
257(21, 11, 1),
258(22, 11, 2),
259(23, 12, 1),
260(24, 12, 2),
261(26, 13, 2),
262(27, 14, 1),
263(28, 14, 2),
264(29, 15, 1),
265(30, 15, 2),
266(31, 16, 1),
267(32, 16, 2),
268(33, 17, 1),
269(34, 17, 2),
270(35, 18, 1),
271(36, 18, 2),
272(37, 19, 1),
273(38, 19, 2),
274(39, 20, 1),
275(40, 20, 2),
276(41, 21, 1),
277(42, 21, 2),
278(43, 22, 1),
279(44, 22, 2),
280(45, 23, 1),
281(46, 23, 2),
282(47, 24, 1),
283(48, 24, 2),
284(49, 25, 1),
285(50, 25, 2),
286(51, 26, 1),
287(52, 26, 2),
288(53, 27, 1),
289(54, 27, 2),
290(55, 28, 1),
291(56, 28, 2),
292(57, 29, 1),
293(58, 29, 2),
294(59, 30, 1),
295(60, 30, 2),
296(61, 31, 1),
297(62, 31, 2),
298(63, 32, 1),
299(64, 32, 2),
300(65, 33, 1),
301(66, 33, 2),
302(67, 34, 1),
303(68, 34, 2),
304(69, 35, 1),
305(70, 35, 2),
306(71, 36, 1),
307(72, 36, 2),
308(73, 37, 1),
309(74, 37, 2),
310(75, 38, 1),
311(76, 38, 2),
312(77, 39, 1),
313(78, 39, 2),
314(79, 40, 1),
315(80, 40, 2),
316(81, 41, 1),
317(82, 41, 2),
318(83, 42, 1),
319(84, 42, 2),
320(85, 43, 1),
321(86, 43, 2),
322(87, 44, 1),
323(88, 44, 2),
324(89, 45, 1),
325(90, 45, 2),
326(91, 46, 1),
327(92, 46, 2),
328(93, 47, 1),
329(94, 47, 2),
330(95, 48, 1),
331(96, 48, 2),
332(97, 49, 1),
333(98, 49, 2),
334(99, 49, 3),
335(100, 50, 1),
336(101, 50, 2),
337(102, 51, 1),
338(103, 51, 2),
339(104, 52, 1),
340(105, 52, 2),
341(106, 53, 1),
342(107, 53, 2),
343(108, 54, 1),
344(109, 54, 2),
345(110, 55, 1),
346(111, 55, 2),
347(112, 56, 1),
348(113, 56, 2),
349(114, 57, 1),
350(115, 57, 2),
351(116, 58, 1),
352(117, 58, 2),
353(118, 59, 1),
354(119, 59, 2),
355(120, 60, 1),
356(121, 60, 2),
357(122, 61, 1),
358(123, 61, 2),
359(124, 62, 1),
360(125, 62, 2),
361(126, 63, 1),
362(127, 63, 2),
363(128, 64, 1),
364(129, 64, 2),
365(130, 65, 1),
366(131, 65, 2),
367(132, 66, 1),
368(133, 66, 2),
369(134, 67, 1),
370(135, 67, 2),
371(136, 68, 1),
372(137, 68, 2),
373(138, 69, 1),
374(139, 69, 2),
375(140, 70, 1),
376(141, 70, 2),
377(142, 71, 1),
378(143, 71, 2),
379(144, 72, 1),
380(145, 72, 2),
381(146, 73, 1),
382(147, 73, 2),
383(148, 74, 1),
384(149, 74, 2),
385(150, 75, 1),
386(151, 75, 2),
387(152, 76, 1),
388(153, 76, 2),
389(154, 77, 1),
390(155, 77, 2),
391(156, 78, 1),
392(157, 78, 2),
393(158, 79, 1),
394(159, 79, 2),
395(160, 80, 1),
396(161, 80, 2),
397(162, 81, 1),
398(163, 81, 2);
399
400-- --------------------------------------------------------
401
402--
403-- Estructura de tabla para la tabla `comitente_usuario`
404--
405
406CREATE TABLE `comitente_usuario` (
407 `id` int(10) UNSIGNED NOT NULL,
408 `nro_comitente` int(11) NOT NULL,
409 `usuario_id` int(10) UNSIGNED NOT NULL,
410 `tipo_usuario_id` int(10) UNSIGNED NOT NULL
411) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
412
413--
414-- Volcado de datos para la tabla `comitente_usuario`
415--
416
417INSERT INTO `comitente_usuario` (`id`, `nro_comitente`, `usuario_id`, `tipo_usuario_id`) VALUES
418(27, 10014, 15, 2),
419(31, 10016, 15, 2),
420(32, 10016, 16, 2),
421(33, 10016, 16, 1),
422(34, 10014, 16, 1),
423(38, 10014, 17, 2),
424(39, 10016, 17, 2),
425(40, 10016, 17, 1),
426(41, 61035, 17, 1),
427(47, 100057, 18, 1),
428(53, 100484, 19, 1),
429(54, 10014, 13, 2),
430(55, 31, 20, 2),
431(56, 31, 20, 1),
432(58, 111471, 1, 1),
433(61, 100484, 1, 1),
434(62, 1, 13, 2),
435(63, 1103063, 21, 2),
436(64, 1103063, 21, 1),
437(65, 48, 22, 2),
438(66, 48, 22, 1),
439(67, 10475, 1, 2);
440
441-- --------------------------------------------------------
442
443--
444-- Estructura de tabla para la tabla `cuentas_bancarias`
445--
446
447CREATE TABLE `cuentas_bancarias` (
448 `id` int(10) UNSIGNED NOT NULL,
449 `tipo_cuenta_bancaria_id` int(10) UNSIGNED DEFAULT NULL,
450 `moneda_id` int(10) UNSIGNED NOT NULL,
451 `banco_id` int(10) UNSIGNED NOT NULL,
452 `numero` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
453 `cuit` int(11) NOT NULL,
454 `extracto` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
455 `cbu` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
456 `created_at` timestamp NULL DEFAULT NULL,
457 `updated_at` timestamp NULL DEFAULT NULL,
458 `deleted_at` timestamp NULL DEFAULT NULL,
459 `estado_id` int(10) UNSIGNED NOT NULL,
460 `usuario_id` int(10) UNSIGNED NOT NULL,
461 `nro_comitente` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
462 `nombre_comitente` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL
463) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
464
465--
466-- Volcado de datos para la tabla `cuentas_bancarias`
467--
468
469INSERT 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
470(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'),
471(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');
472
473-- --------------------------------------------------------
474
475--
476-- Estructura de tabla para la tabla `cuentas_bancarias_dolar_divisa`
477--
478
479CREATE TABLE `cuentas_bancarias_dolar_divisa` (
480 `id` int(10) UNSIGNED NOT NULL,
481 `iban` varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL,
482 `swift` varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL,
483 `aba` varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL,
484 `nro_comitente` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
485 `nombre_comitente` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
486 `pais` varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL,
487 `ciudad` varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL,
488 `codigo_postal` varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL,
489 `moneda_id` int(10) UNSIGNED NOT NULL,
490 `banco_id` int(10) UNSIGNED NOT NULL,
491 `estado_id` int(10) UNSIGNED NOT NULL,
492 `usuario_id` int(10) UNSIGNED NOT NULL,
493 `numero` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
494 `extracto` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
495 `inst_permanente` varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL,
496 `created_at` timestamp NULL DEFAULT NULL,
497 `updated_at` timestamp NULL DEFAULT NULL,
498 `deleted_at` timestamp NULL DEFAULT NULL
499) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
500
501--
502-- Volcado de datos para la tabla `cuentas_bancarias_dolar_divisa`
503--
504
505INSERT 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
506(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),
507(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),
508(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);
509
510-- --------------------------------------------------------
511
512--
513-- Estructura de tabla para la tabla `cuentas_bancarias_intl`
514--
515
516CREATE TABLE `cuentas_bancarias_intl` (
517 `id` int(10) UNSIGNED NOT NULL,
518 `nombre` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
519 `cbu` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
520 `nro_cuenta` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
521 `habilitada` tinyint(1) NOT NULL,
522 `moneda_id` int(10) UNSIGNED DEFAULT NULL,
523 `created_at` timestamp NULL DEFAULT NULL,
524 `updated_at` timestamp NULL DEFAULT NULL,
525 `deleted_at` timestamp NULL DEFAULT NULL,
526 `cod_cuenta_bancaria_esco` int(11) NOT NULL,
527 `defecto` tinyint(1) NOT NULL
528) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
529
530--
531-- Volcado de datos para la tabla `cuentas_bancarias_intl`
532--
533
534INSERT INTO `cuentas_bancarias_intl` (`id`, `nombre`, `cbu`, `nro_cuenta`, `habilitada`, `moneda_id`, `created_at`, `updated_at`, `deleted_at`, `cod_cuenta_bancaria_esco`, `defecto`) VALUES
535(15, 'Banco de Valores', '', '240/2', 1, 1, NULL, NULL, NULL, 2, 1),
536(16, 'Banco Galicia', '', '48966/9 999/4', 1, 1, NULL, NULL, NULL, 3, 0),
537(17, 'Banco de la Ciudad de Buenos Aires', '', '999-25226-5', 0, 1, NULL, NULL, NULL, 4, 0),
538(18, 'Santander Rio', '', '000-21665-2', 1, 1, NULL, NULL, NULL, 5, 0),
539(19, 'Banco Frances', '', '099-677166/5', 0, 1, NULL, NULL, NULL, 6, 0),
540(20, 'HSBC Bank', '', '0013214663', 0, 1, NULL, NULL, NULL, 7, 0),
541(21, 'Banco Citibank', '', '0192417112', 0, 1, NULL, NULL, NULL, 8, 0),
542(22, 'Banco de la Nacion Argentina', '', '50205/44', 0, 1, NULL, NULL, NULL, 9, 0),
543(23, 'Banco de la Provincia de Buenos Aires', '', '1000-5052/6', 0, 1, NULL, NULL, NULL, 10, 0),
544(24, 'Banco Macro .', '', '35400-011083356/3', 1, 1, NULL, NULL, NULL, 11, 0),
545(25, 'Banco Patagonia', '', '100011428', 1, 1, NULL, NULL, NULL, 14, 0),
546(26, 'Banco Macro', '', '8-005823-8', 0, 1, NULL, NULL, NULL, 16, 0),
547(27, 'Banco Comafi', '', '0080-18431/5', 0, 1, NULL, NULL, NULL, 17, 0),
548(28, 'STANDARD CHARTERED', '', '3544-053057-070', 0, 2, NULL, NULL, NULL, 20, 0),
549(29, 'Banco Macro (pago a proveedores)', '', '35400-940000304-6', 0, 1, NULL, NULL, NULL, 21, 0),
550(30, 'Banco Macro .', '', '1002', 0, 1, NULL, NULL, NULL, 22, 0),
551(31, 'Banco Macro (cta recaudadora)', '', '454009400410655', 0, 1, NULL, NULL, NULL, 23, 0),
552(32, 'Deutsche Bank', '', '660012910', 0, 1, NULL, NULL, NULL, 24, 0),
553(33, 'Deutsche Bank S.A. (Cta. Cte.)', '', '104023540024', 0, 1, NULL, NULL, NULL, 25, 0),
554(34, 'Transferencias Internas', '', '111111111', 0, 1, NULL, NULL, NULL, 26, 0),
555(35, 'Banco Macro (cta recaudadora)', '', '123456', 0, 2, NULL, NULL, NULL, 27, 0),
556(36, 'BANCO FINANSUR', '', '40190/7', 0, 1, NULL, NULL, NULL, 28, 0),
557(37, 'Banco Macro CV 10000 ME', '', '254009405050582', 1, 2, NULL, NULL, NULL, 29, 0),
558(38, 'Banco Macro.', '', '1004', 0, 2, NULL, NULL, NULL, 30, 0),
559(39, 'HSBC Bank', '', '164208', 0, 2, NULL, NULL, NULL, 31, 0),
560(40, 'HSBC Bank', '', '300346568', 0, 1, NULL, NULL, NULL, 32, 0),
561(41, 'HSBC Bank', '', '3008447969', 0, 2, NULL, NULL, NULL, 33, 0),
562(42, 'Bank Of América', '', '446015624527', 0, 2, NULL, NULL, NULL, 36, 0),
563(43, 'BANCO COLUMBIA', '', '02-0052057166/6', 0, 1, NULL, NULL, NULL, 37, 0),
564(44, 'Banco emisor licitaciones primarias', '', '0', 0, 1, NULL, NULL, NULL, 38, 0),
565(45, 'BANCO COLUMBIA', '', '04-005205654/2', 0, 2, NULL, NULL, NULL, 39, 0),
566(46, 'Banco de Valores', '', '104269/9', 1, 2, NULL, NULL, NULL, 40, 1),
567(47, 'Banco de Valores', '', '10', 0, 1, NULL, NULL, NULL, 41, 0),
568(48, 'Banco de Valores', '', '104269-9', 0, 2, NULL, NULL, NULL, 42, 0),
569(49, 'Banco Macro CV 10000 ME', '', '254-00940505582', 0, 2, NULL, NULL, NULL, 43, 0),
570(50, 'Banco Emisor de Licitaciones Primarias MAE', '', '0', 0, 1, NULL, NULL, NULL, 45, 0),
571(51, 'Banco emisor licitaciones primarias Dólar Cable', '', '0', 0, 2, NULL, NULL, NULL, 46, 0),
572(52, 'Banco emisor licitaciones primarias Dólar MEP', '', '0', 0, 2, NULL, NULL, NULL, 47, 0),
573(53, 'Banco emisor licitaciones primarias Dólar MEP', '', '00', 0, 2, NULL, NULL, NULL, 48, 0),
574(54, 'Bank of America', '', '4460 1562 4527', 1, 3, NULL, NULL, NULL, 36, 1);
575
576-- --------------------------------------------------------
577
578--
579-- Estructura de tabla para la tabla `depositos`
580--
581
582CREATE TABLE `depositos` (
583 `id` int(10) UNSIGNED NOT NULL,
584 `fecha` datetime NOT NULL,
585 `comprobante` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
586 `moneda_id` int(10) UNSIGNED NOT NULL,
587 `origen_id` int(10) UNSIGNED NOT NULL,
588 `destino_id` int(10) UNSIGNED NOT NULL,
589 `estado_id` int(10) UNSIGNED NOT NULL,
590 `usuario_id` int(10) UNSIGNED DEFAULT NULL COMMENT 'El usuario que informó el deposito',
591 `fecha_esco` datetime DEFAULT NULL,
592 `created_at` timestamp NULL DEFAULT NULL,
593 `updated_at` timestamp NULL DEFAULT NULL,
594 `deleted_at` timestamp NULL DEFAULT NULL,
595 `backend_user_id` int(10) UNSIGNED DEFAULT NULL COMMENT 'El usuario del backend que aprueba/rechaza el deposito',
596 `nro_comitente` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
597 `nombre_comitente` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
598 `importe` double(15,2) NOT NULL
599) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
600
601--
602-- Volcado de datos para la tabla `depositos`
603--
604
605INSERT 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
606(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),
607(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),
608(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),
609(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),
610(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),
611(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),
612(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),
613(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),
614(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),
615(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),
616(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),
617(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),
618(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),
619(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),
620(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),
621(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),
622(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),
623(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),
624(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),
625(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);
626
627-- --------------------------------------------------------
628
629--
630-- Estructura de tabla para la tabla `estado_cuenta_bancaria`
631--
632
633CREATE TABLE `estado_cuenta_bancaria` (
634 `id` int(10) UNSIGNED NOT NULL,
635 `nombre` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
636 `created_at` timestamp NULL DEFAULT NULL,
637 `updated_at` timestamp NULL DEFAULT NULL,
638 `deleted_at` timestamp NULL DEFAULT NULL
639) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
640
641--
642-- Volcado de datos para la tabla `estado_cuenta_bancaria`
643--
644
645INSERT INTO `estado_cuenta_bancaria` (`id`, `nombre`, `created_at`, `updated_at`, `deleted_at`) VALUES
646(1, 'Pendiente', NULL, NULL, NULL),
647(2, 'Aceptado', NULL, NULL, NULL),
648(3, 'Rechazado', NULL, NULL, NULL);
649
650-- --------------------------------------------------------
651
652--
653-- Estructura de tabla para la tabla `estado_deposito`
654--
655
656CREATE TABLE `estado_deposito` (
657 `id` int(10) UNSIGNED NOT NULL,
658 `nombre` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
659 `deleted_at` timestamp NULL DEFAULT NULL
660) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
661
662--
663-- Volcado de datos para la tabla `estado_deposito`
664--
665
666INSERT INTO `estado_deposito` (`id`, `nombre`, `deleted_at`) VALUES
667(1, 'Pendiente', NULL),
668(2, 'Aceptado', NULL),
669(3, 'Rechazado', NULL);
670
671-- --------------------------------------------------------
672
673--
674-- Estructura de tabla para la tabla `estado_transferencia`
675--
676
677CREATE TABLE `estado_transferencia` (
678 `id` int(10) UNSIGNED NOT NULL,
679 `nombre` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
680 `created_at` timestamp NULL DEFAULT NULL,
681 `updated_at` timestamp NULL DEFAULT NULL,
682 `deleted_at` timestamp NULL DEFAULT NULL
683) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
684
685--
686-- Volcado de datos para la tabla `estado_transferencia`
687--
688
689INSERT INTO `estado_transferencia` (`id`, `nombre`, `created_at`, `updated_at`, `deleted_at`) VALUES
690(1, 'Pendiente', NULL, NULL, NULL),
691(2, 'Aceptado', NULL, NULL, NULL),
692(3, 'Rechazado', NULL, NULL, NULL);
693
694-- --------------------------------------------------------
695
696--
697-- Estructura de tabla para la tabla `migrations`
698--
699
700CREATE TABLE `migrations` (
701 `id` int(10) UNSIGNED NOT NULL,
702 `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
703 `batch` int(11) NOT NULL
704) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
705
706--
707-- Volcado de datos para la tabla `migrations`
708--
709
710INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
711(1, '2014_10_12_000000_create_backend_users_table', 1),
712(2, '2014_10_12_100000_create_password_resets_table', 1),
713(3, '2017_05_10_151140_agregar_email_a_backend_users', 1),
714(4, '2017_05_10_154804_cambiar_nombre_id_backend_users', 1),
715(5, '2017_05_10_160436_create_users_table', 1),
716(6, '2017_05_10_162644_agregar_apellido_a_users', 1),
717(7, '2017_05_11_111126_cambiar_nombre_a_password', 1),
718(8, '2017_05_11_122601_create_permisos_table', 1),
719(9, '2017_05_11_123400_create_permiso_usuario_table', 1),
720(10, '2017_05_12_090630_agregar_apellido_a_backend_users', 1),
721(11, '2017_05_12_120622_agregar_last_login_a_backend_users', 1),
722(12, '2017_05_12_133339_create_estado_deposito_table', 1),
723(13, '2017_05_12_133953_create_moneda_table', 1),
724(14, '2017_05_12_142917_create_bancos_table', 1),
725(15, '2017_05_12_143300_create_banco_moneda_table', 1),
726(16, '2017_05_15_104452_create_cuentas_bancarias_intl_table', 1),
727(40, '2017_05_15_172052_create_depositos_table', 2),
728(41, '2017_05_16_112900_cambiar_campo_password_users_table', 2),
729(42, '2017_05_16_113120_agregar_last_login_users', 2),
730(43, '2017_05_16_124647_agregar_comprobante_a_depositos_table', 2),
731(44, '2017_05_16_132818_agregar_tiempos_a_depositos_table', 2),
732(45, '2017_05_18_100825_agregar_fecha_esco_depositos', 2),
733(65, '2017_05_19_133025_create_tipo_cuenta_bancaria_table', 3),
734(66, '2017_05_19_133202_create_cuentas_bancarias_table', 3),
735(67, '2017_05_19_145202_create_estado_cuenta_bancaria_table', 3),
736(68, '2017_05_19_150105_agregar_estado_id_a_cuentas_bancarias_table', 3),
737(70, '2017_05_19_150818_agregar_usuario_id_a_cuentas_bancarias_table', 4),
738(72, '2017_05_22_114213_quitar_unique_a_cbu_cuentas_bancarias', 5),
739(82, '2017_05_22_132601_create_transferencias_table', 6),
740(83, '2017_05_23_110239_create_estado_transferencia_table', 6),
741(84, '2017_05_23_110335_agregar_estado_id_a_transferencias_table', 6),
742(88, '2017_05_23_141307_agregar_banco_a_transferencias_table', 7),
743(90, '2017_05_24_141343_agregar_num_persona_a_users_table', 8),
744(92, '2017_05_24_144918_eliminar_comitente_de_users', 9),
745(94, '2017_05_24_145135_create_comitente_usuario_table', 10),
746(97, '2017_05_30_094919_cambiar_nombre_a_comitente_id_comitente_usuario_table', 11),
747(100, '2017_05_30_104043_agregar_nulls_a_users', 12),
748(105, '2017_05_30_135323_crear_tipo_comitente_usuario_table', 13),
749(106, '2017_05_30_135625_agregar_tipo_comitente_usuario_id', 13),
750(108, '2017_06_05_143449_agregar_aprobador_id_depositos_table', 14),
751(112, '2017_06_07_102559_cambiar_nombre_origen_transferencias_table', 15),
752(113, '2017_06_07_133531_agregar_datos_comitente_deposito', 16),
753(115, '2017_06_07_134503_agregar_datos_comitente_cuentas_bancarias_table', 17),
754(121, '2017_06_08_153116_agregar_fecha_transaccion_transferencias_table', 18),
755(123, '2017_06_09_113003_agregar_cbu_nro_cuenta_bancos_intl', 19),
756(126, '2017_06_09_120209_agregar_banco_origen_intl_transferencias_table', 20),
757(129, '2017_06_09_134546_agregar_moneda_id_cuenta_intl', 21),
758(131, '2017_06_12_122136_agregar_defecto_cuentas_bancarias_intl', 22),
759(137, '2017_06_19_084512_create_cuentas_bancarias_dolar_divisa_table', 23),
760(138, '2017_06_22_112419_agregar_nulls_a_cuentas_bancarias_table', 24),
761(140, '2017_06_23_115654_agregar_id_y_cod_interfaz_a_monedas_table', 25),
762(141, '2017_06_23_132851_agregar_nulo_tipo_cuenta_transferencias', 26),
763(145, '2017_06_26_123700_agregar_inst_permanente_cuentas_bancarias', 27),
764(149, '2017_06_28_095100_cambiar_tipo_importe_deposito_y_transferencia', 28);
765
766-- --------------------------------------------------------
767
768--
769-- Estructura de tabla para la tabla `monedas`
770--
771
772CREATE TABLE `monedas` (
773 `id` int(10) UNSIGNED NOT NULL,
774 `nombre` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
775 `created_at` timestamp NULL DEFAULT NULL,
776 `updated_at` timestamp NULL DEFAULT NULL,
777 `deleted_at` timestamp NULL DEFAULT NULL,
778 `id_esco` int(11) DEFAULT NULL,
779 `cod_interfaz_esco` int(11) DEFAULT NULL
780) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
781
782--
783-- Volcado de datos para la tabla `monedas`
784--
785
786INSERT INTO `monedas` (`id`, `nombre`, `created_at`, `updated_at`, `deleted_at`, `id_esco`, `cod_interfaz_esco`) VALUES
787(1, 'Pesos', NULL, NULL, NULL, 1, 0),
788(2, 'Dolares', NULL, NULL, NULL, 2, 1),
789(3, 'Dolar Divisa', NULL, NULL, NULL, 2, 1);
790
791-- --------------------------------------------------------
792
793--
794-- Estructura de tabla para la tabla `password_resets`
795--
796
797CREATE TABLE `password_resets` (
798 `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
799 `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
800 `created_at` timestamp NULL DEFAULT NULL
801) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
802
803-- --------------------------------------------------------
804
805--
806-- Estructura de tabla para la tabla `tipo_comitente_usuario`
807--
808
809CREATE TABLE `tipo_comitente_usuario` (
810 `id` int(10) UNSIGNED NOT NULL,
811 `nombre` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL
812) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
813
814--
815-- Volcado de datos para la tabla `tipo_comitente_usuario`
816--
817
818INSERT INTO `tipo_comitente_usuario` (`id`, `nombre`) VALUES
819(1, 'Operador'),
820(2, 'Vista');
821
822-- --------------------------------------------------------
823
824--
825-- Estructura de tabla para la tabla `tipo_cuenta_bancaria`
826--
827
828CREATE TABLE `tipo_cuenta_bancaria` (
829 `id` int(10) UNSIGNED NOT NULL,
830 `nombre` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
831 `created_at` timestamp NULL DEFAULT NULL,
832 `updated_at` timestamp NULL DEFAULT NULL,
833 `deleted_at` timestamp NULL DEFAULT NULL
834) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
835
836--
837-- Volcado de datos para la tabla `tipo_cuenta_bancaria`
838--
839
840INSERT INTO `tipo_cuenta_bancaria` (`id`, `nombre`, `created_at`, `updated_at`, `deleted_at`) VALUES
841(1, 'Caja de Ahorro', NULL, NULL, NULL),
842(2, 'Cuenta Corriente', NULL, NULL, NULL);
843
844-- --------------------------------------------------------
845
846--
847-- Estructura de tabla para la tabla `transferencias`
848--
849
850CREATE TABLE `transferencias` (
851 `id` int(10) UNSIGNED NOT NULL,
852 `nro_comitente` int(11) NOT NULL,
853 `nro_cuenta` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
854 `tipo_cuenta` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
855 `banco` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
856 `banco_origen_id` int(10) UNSIGNED NOT NULL COMMENT 'El banco de INTL',
857 `moneda_id` int(10) UNSIGNED NOT NULL,
858 `usuario_id` int(10) UNSIGNED NOT NULL,
859 `estado_id` int(10) UNSIGNED NOT NULL,
860 `cbu` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
861 `cuit` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
862 `fecha_transaccion` datetime DEFAULT NULL,
863 `created_at` timestamp NULL DEFAULT NULL,
864 `updated_at` timestamp NULL DEFAULT NULL,
865 `deleted_at` timestamp NULL DEFAULT NULL,
866 `nombre_comitente` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
867 `backend_user_id` int(10) UNSIGNED DEFAULT NULL,
868 `importe` double(15,2) NOT NULL
869) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
870
871--
872-- Volcado de datos para la tabla `transferencias`
873--
874
875INSERT 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
876(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),
877(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),
878(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),
879(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),
880(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),
881(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),
882(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),
883(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),
884(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),
885(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),
886(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),
887(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),
888(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),
889(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),
890(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),
891(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),
892(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),
893(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),
894(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);
895
896-- --------------------------------------------------------
897
898--
899-- Estructura de tabla para la tabla `users`
900--
901
902CREATE TABLE `users` (
903 `id` int(10) UNSIGNED NOT NULL,
904 `us_nombre` varchar(191) CHARACTER SET utf8 NOT NULL,
905 `us_email` varchar(191) CHARACTER SET utf8 DEFAULT NULL,
906 `us_username` varchar(191) CHARACTER SET utf8 NOT NULL,
907 `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
908 `num_persona` int(11) NOT NULL,
909 `last_login` datetime DEFAULT NULL,
910 `created_at` timestamp NULL DEFAULT NULL,
911 `updated_at` timestamp NULL DEFAULT NULL,
912 `deleted_at` timestamp NULL DEFAULT NULL,
913 `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
914 `us_apellido` varchar(191) CHARACTER SET utf8 DEFAULT NULL
915) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
916
917--
918-- Volcado de datos para la tabla `users`
919--
920
921INSERT 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
922(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'),
923(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),
924(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),
925(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),
926(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),
927(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),
928(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),
929(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),
930(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),
931(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);
932
933--
934-- Ãndices para tablas volcadas
935--
936
937--
938-- Indices de la tabla `backend_permisos`
939--
940ALTER TABLE `backend_permisos`
941 ADD PRIMARY KEY (`id`);
942
943--
944-- Indices de la tabla `backend_permiso_usuario`
945--
946ALTER TABLE `backend_permiso_usuario`
947 ADD PRIMARY KEY (`id`),
948 ADD KEY `backend_permiso_usuario_permiso_id_foreign` (`permiso_id`),
949 ADD KEY `backend_permiso_usuario_usuario_id_foreign` (`usuario_id`);
950
951--
952-- Indices de la tabla `backend_users`
953--
954ALTER TABLE `backend_users`
955 ADD PRIMARY KEY (`id`),
956 ADD UNIQUE KEY `backend_users_backend_users_username_unique` (`backend_users_username`);
957
958--
959-- Indices de la tabla `bancos`
960--
961ALTER TABLE `bancos`
962 ADD PRIMARY KEY (`id`);
963
964--
965-- Indices de la tabla `banco_moneda`
966--
967ALTER TABLE `banco_moneda`
968 ADD PRIMARY KEY (`id`),
969 ADD KEY `banco_moneda_banco_id_foreign` (`banco_id`),
970 ADD KEY `banco_moneda_moneda_id_foreign` (`moneda_id`);
971
972--
973-- Indices de la tabla `comitente_usuario`
974--
975ALTER TABLE `comitente_usuario`
976 ADD PRIMARY KEY (`id`),
977 ADD KEY `comitente_usuario_usuario_id_foreign` (`usuario_id`),
978 ADD KEY `comitente_usuario_tipo_usuario_id_foreign` (`tipo_usuario_id`);
979
980--
981-- Indices de la tabla `cuentas_bancarias`
982--
983ALTER TABLE `cuentas_bancarias`
984 ADD PRIMARY KEY (`id`),
985 ADD KEY `cuentas_bancarias_tipo_cuenta_bancaria_id_foreign` (`tipo_cuenta_bancaria_id`),
986 ADD KEY `cuentas_bancarias_moneda_id_foreign` (`moneda_id`),
987 ADD KEY `cuentas_bancarias_banco_id_foreign` (`banco_id`),
988 ADD KEY `cuentas_bancarias_estado_id_foreign` (`estado_id`),
989 ADD KEY `cuentas_bancarias_usuario_id_foreign` (`usuario_id`);
990
991--
992-- Indices de la tabla `cuentas_bancarias_dolar_divisa`
993--
994ALTER TABLE `cuentas_bancarias_dolar_divisa`
995 ADD PRIMARY KEY (`id`),
996 ADD KEY `cuentas_bancarias_dolar_divisa_estado_id_foreign` (`estado_id`),
997 ADD KEY `cuentas_bancarias_dolar_divisa_moneda_id_foreign` (`moneda_id`),
998 ADD KEY `cuentas_bancarias_dolar_divisa_banco_id_foreign` (`banco_id`),
999 ADD KEY `cuentas_bancarias_dolar_divisa_usuario_id_foreign` (`usuario_id`);
1000
1001--
1002-- Indices de la tabla `cuentas_bancarias_intl`
1003--
1004ALTER TABLE `cuentas_bancarias_intl`
1005 ADD PRIMARY KEY (`id`),
1006 ADD KEY `cuentas_bancarias_intl_moneda_id_foreign` (`moneda_id`);
1007
1008--
1009-- Indices de la tabla `depositos`
1010--
1011ALTER TABLE `depositos`
1012 ADD PRIMARY KEY (`id`),
1013 ADD KEY `depositos_moneda_id_foreign` (`moneda_id`),
1014 ADD KEY `depositos_origen_id_foreign` (`origen_id`),
1015 ADD KEY `depositos_destino_id_foreign` (`destino_id`),
1016 ADD KEY `depositos_estado_id_foreign` (`estado_id`),
1017 ADD KEY `depositos_usuario_id_foreign` (`usuario_id`),
1018 ADD KEY `depositos_backend_user_id_foreign` (`backend_user_id`);
1019
1020--
1021-- Indices de la tabla `estado_cuenta_bancaria`
1022--
1023ALTER TABLE `estado_cuenta_bancaria`
1024 ADD PRIMARY KEY (`id`);
1025
1026--
1027-- Indices de la tabla `estado_deposito`
1028--
1029ALTER TABLE `estado_deposito`
1030 ADD PRIMARY KEY (`id`);
1031
1032--
1033-- Indices de la tabla `estado_transferencia`
1034--
1035ALTER TABLE `estado_transferencia`
1036 ADD PRIMARY KEY (`id`);
1037
1038--
1039-- Indices de la tabla `migrations`
1040--
1041ALTER TABLE `migrations`
1042 ADD PRIMARY KEY (`id`);
1043
1044--
1045-- Indices de la tabla `monedas`
1046--
1047ALTER TABLE `monedas`
1048 ADD PRIMARY KEY (`id`);
1049
1050--
1051-- Indices de la tabla `password_resets`
1052--
1053ALTER TABLE `password_resets`
1054 ADD KEY `password_resets_email_index` (`email`);
1055
1056--
1057-- Indices de la tabla `tipo_comitente_usuario`
1058--
1059ALTER TABLE `tipo_comitente_usuario`
1060 ADD PRIMARY KEY (`id`);
1061
1062--
1063-- Indices de la tabla `tipo_cuenta_bancaria`
1064--
1065ALTER TABLE `tipo_cuenta_bancaria`
1066 ADD PRIMARY KEY (`id`);
1067
1068--
1069-- Indices de la tabla `transferencias`
1070--
1071ALTER TABLE `transferencias`
1072 ADD PRIMARY KEY (`id`),
1073 ADD KEY `transferencias_moneda_id_foreign` (`moneda_id`),
1074 ADD KEY `transferencias_usuario_id_foreign` (`usuario_id`),
1075 ADD KEY `transferencias_estado_id_foreign` (`estado_id`),
1076 ADD KEY `transferencias_backend_user_id_foreign` (`backend_user_id`),
1077 ADD KEY `transferencias_banco_origen_id_foreign` (`banco_origen_id`);
1078
1079--
1080-- Indices de la tabla `users`
1081--
1082ALTER TABLE `users`
1083 ADD PRIMARY KEY (`id`),
1084 ADD UNIQUE KEY `users_us_username_unique` (`us_username`);
1085
1086--
1087-- AUTO_INCREMENT de las tablas volcadas
1088--
1089
1090--
1091-- AUTO_INCREMENT de la tabla `backend_permisos`
1092--
1093ALTER TABLE `backend_permisos`
1094 MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
1095--
1096-- AUTO_INCREMENT de la tabla `backend_permiso_usuario`
1097--
1098ALTER TABLE `backend_permiso_usuario`
1099 MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;
1100--
1101-- AUTO_INCREMENT de la tabla `backend_users`
1102--
1103ALTER TABLE `backend_users`
1104 MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
1105--
1106-- AUTO_INCREMENT de la tabla `bancos`
1107--
1108ALTER TABLE `bancos`
1109 MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=82;
1110--
1111-- AUTO_INCREMENT de la tabla `banco_moneda`
1112--
1113ALTER TABLE `banco_moneda`
1114 MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=164;
1115--
1116-- AUTO_INCREMENT de la tabla `comitente_usuario`
1117--
1118ALTER TABLE `comitente_usuario`
1119 MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=68;
1120--
1121-- AUTO_INCREMENT de la tabla `cuentas_bancarias`
1122--
1123ALTER TABLE `cuentas_bancarias`
1124 MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
1125--
1126-- AUTO_INCREMENT de la tabla `cuentas_bancarias_dolar_divisa`
1127--
1128ALTER TABLE `cuentas_bancarias_dolar_divisa`
1129 MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
1130--
1131-- AUTO_INCREMENT de la tabla `cuentas_bancarias_intl`
1132--
1133ALTER TABLE `cuentas_bancarias_intl`
1134 MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=55;
1135--
1136-- AUTO_INCREMENT de la tabla `depositos`
1137--
1138ALTER TABLE `depositos`
1139 MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;
1140--
1141-- AUTO_INCREMENT de la tabla `estado_cuenta_bancaria`
1142--
1143ALTER TABLE `estado_cuenta_bancaria`
1144 MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
1145--
1146-- AUTO_INCREMENT de la tabla `estado_deposito`
1147--
1148ALTER TABLE `estado_deposito`
1149 MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
1150--
1151-- AUTO_INCREMENT de la tabla `estado_transferencia`
1152--
1153ALTER TABLE `estado_transferencia`
1154 MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
1155--
1156-- AUTO_INCREMENT de la tabla `migrations`
1157--
1158ALTER TABLE `migrations`
1159 MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=150;
1160--
1161-- AUTO_INCREMENT de la tabla `monedas`
1162--
1163ALTER TABLE `monedas`
1164 MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
1165--
1166-- AUTO_INCREMENT de la tabla `tipo_comitente_usuario`
1167--
1168ALTER TABLE `tipo_comitente_usuario`
1169 MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
1170--
1171-- AUTO_INCREMENT de la tabla `tipo_cuenta_bancaria`
1172--
1173ALTER TABLE `tipo_cuenta_bancaria`
1174 MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
1175--
1176-- AUTO_INCREMENT de la tabla `transferencias`
1177--
1178ALTER TABLE `transferencias`
1179 MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;
1180--
1181-- AUTO_INCREMENT de la tabla `users`
1182--
1183ALTER TABLE `users`
1184 MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;
1185--
1186-- Restricciones para tablas volcadas
1187--
1188
1189--
1190-- Filtros para la tabla `backend_permiso_usuario`
1191--
1192ALTER TABLE `backend_permiso_usuario`
1193 ADD CONSTRAINT `backend_permiso_usuario_permiso_id_foreign` FOREIGN KEY (`permiso_id`) REFERENCES `backend_permisos` (`id`),
1194 ADD CONSTRAINT `backend_permiso_usuario_usuario_id_foreign` FOREIGN KEY (`usuario_id`) REFERENCES `backend_users` (`id`);
1195
1196--
1197-- Filtros para la tabla `banco_moneda`
1198--
1199ALTER TABLE `banco_moneda`
1200 ADD CONSTRAINT `banco_moneda_banco_id_foreign` FOREIGN KEY (`banco_id`) REFERENCES `bancos` (`id`),
1201 ADD CONSTRAINT `banco_moneda_moneda_id_foreign` FOREIGN KEY (`moneda_id`) REFERENCES `monedas` (`id`);
1202
1203--
1204-- Filtros para la tabla `comitente_usuario`
1205--
1206ALTER TABLE `comitente_usuario`
1207 ADD CONSTRAINT `comitente_usuario_tipo_usuario_id_foreign` FOREIGN KEY (`tipo_usuario_id`) REFERENCES `tipo_comitente_usuario` (`id`),
1208 ADD CONSTRAINT `comitente_usuario_usuario_id_foreign` FOREIGN KEY (`usuario_id`) REFERENCES `users` (`id`);
1209
1210--
1211-- Filtros para la tabla `cuentas_bancarias`
1212--
1213ALTER TABLE `cuentas_bancarias`
1214 ADD CONSTRAINT `cuentas_bancarias_banco_id_foreign` FOREIGN KEY (`banco_id`) REFERENCES `bancos` (`id`),
1215 ADD CONSTRAINT `cuentas_bancarias_estado_id_foreign` FOREIGN KEY (`estado_id`) REFERENCES `estado_cuenta_bancaria` (`id`),
1216 ADD CONSTRAINT `cuentas_bancarias_moneda_id_foreign` FOREIGN KEY (`moneda_id`) REFERENCES `monedas` (`id`),
1217 ADD CONSTRAINT `cuentas_bancarias_tipo_cuenta_bancaria_id_foreign` FOREIGN KEY (`tipo_cuenta_bancaria_id`) REFERENCES `tipo_cuenta_bancaria` (`id`),
1218 ADD CONSTRAINT `cuentas_bancarias_usuario_id_foreign` FOREIGN KEY (`usuario_id`) REFERENCES `users` (`id`);
1219
1220--
1221-- Filtros para la tabla `cuentas_bancarias_dolar_divisa`
1222--
1223ALTER TABLE `cuentas_bancarias_dolar_divisa`
1224 ADD CONSTRAINT `cuentas_bancarias_dolar_divisa_banco_id_foreign` FOREIGN KEY (`banco_id`) REFERENCES `bancos` (`id`),
1225 ADD CONSTRAINT `cuentas_bancarias_dolar_divisa_estado_id_foreign` FOREIGN KEY (`estado_id`) REFERENCES `estado_cuenta_bancaria` (`id`),
1226 ADD CONSTRAINT `cuentas_bancarias_dolar_divisa_moneda_id_foreign` FOREIGN KEY (`moneda_id`) REFERENCES `monedas` (`id`),
1227 ADD CONSTRAINT `cuentas_bancarias_dolar_divisa_usuario_id_foreign` FOREIGN KEY (`usuario_id`) REFERENCES `users` (`id`);
1228
1229--
1230-- Filtros para la tabla `cuentas_bancarias_intl`
1231--
1232ALTER TABLE `cuentas_bancarias_intl`
1233 ADD CONSTRAINT `cuentas_bancarias_intl_moneda_id_foreign` FOREIGN KEY (`moneda_id`) REFERENCES `monedas` (`id`);
1234
1235--
1236-- Filtros para la tabla `depositos`
1237--
1238ALTER TABLE `depositos`
1239 ADD CONSTRAINT `depositos_backend_user_id_foreign` FOREIGN KEY (`backend_user_id`) REFERENCES `backend_users` (`id`),
1240 ADD CONSTRAINT `depositos_destino_id_foreign` FOREIGN KEY (`destino_id`) REFERENCES `cuentas_bancarias_intl` (`id`),
1241 ADD CONSTRAINT `depositos_estado_id_foreign` FOREIGN KEY (`estado_id`) REFERENCES `estado_deposito` (`id`),
1242 ADD CONSTRAINT `depositos_moneda_id_foreign` FOREIGN KEY (`moneda_id`) REFERENCES `monedas` (`id`),
1243 ADD CONSTRAINT `depositos_origen_id_foreign` FOREIGN KEY (`origen_id`) REFERENCES `bancos` (`id`),
1244 ADD CONSTRAINT `depositos_usuario_id_foreign` FOREIGN KEY (`usuario_id`) REFERENCES `users` (`id`);
1245
1246--
1247-- Filtros para la tabla `transferencias`
1248--
1249ALTER TABLE `transferencias`
1250 ADD CONSTRAINT `transferencias_backend_user_id_foreign` FOREIGN KEY (`backend_user_id`) REFERENCES `backend_users` (`id`),
1251 ADD CONSTRAINT `transferencias_banco_origen_id_foreign` FOREIGN KEY (`banco_origen_id`) REFERENCES `cuentas_bancarias_intl` (`id`),
1252 ADD CONSTRAINT `transferencias_estado_id_foreign` FOREIGN KEY (`estado_id`) REFERENCES `estado_transferencia` (`id`),
1253 ADD CONSTRAINT `transferencias_moneda_id_foreign` FOREIGN KEY (`moneda_id`) REFERENCES `monedas` (`id`),
1254 ADD CONSTRAINT `transferencias_usuario_id_foreign` FOREIGN KEY (`usuario_id`) REFERENCES `users` (`id`);
1255SET FOREIGN_KEY_CHECKS=1;
1256
1257/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1258/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1259/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;