truncate(); DB::statement('SET FOREIGN_KEY_CHECKS=1;'); DB::table('banks')->insert([ ['id' => 1, 'code' => 1, 'name' => 'BANCO DE MEXICO'], ['id' => 2, 'code' => 2, 'name' => 'BANCO NACIONAL DE MEXICO'], ['id' => 3, 'code' => 3, 'name' => 'BANCA SERFIN'], ['id' => 4, 'code' => 4, 'name' => 'BANCO DEL ATLANTICO'], ['id' => 5, 'code' => 6, 'name' => 'BANCO NACIONAL DE COMERCIO EXTERIOR'], ['id' => 6, 'code' => 7, 'name' => 'CITIBANK'], ['id' => 7, 'code' => 8, 'name' => 'BANCO UNION'], ['id' => 8, 'code' => 9, 'name' => 'BANCO NACIONAL DE OBRAS PUBLICAS'], ['id' => 9, 'code' => 11, 'name' => 'BANCA CONFIA'], ['id' => 10, 'code' => 12, 'name' => 'BBVA BANCOMER'], ['id' => 11, 'code' => 13, 'name' => 'BANCO INDUSTRIAL'], ['id' => 12, 'code' => 14, 'name' => 'SANTANDER'], ['id' => 13, 'code' => 16, 'name' => 'BANCO INTERESTATAL'], ['id' => 14, 'code' => 17, 'name' => 'BANCO BILBAO VIZCAYA MEXICO'], ['id' => 15, 'code' => 19, 'name' => 'BANJERCITO'], ['id' => 16, 'code' => 21, 'name' => 'HSBC'], ['id' => 17, 'code' => 22, 'name' => 'GE CAPITAL BANK'], ['id' => 18, 'code' => 25, 'name' => 'SURESTE'], ['id' => 19, 'code' => 26, 'name' => 'BANCO NACIONAL DE COMERCIO INTERIOR'], ['id' => 20, 'code' => 28, 'name' => 'CAPITAL'], ['id' => 21, 'code' => 30, 'name' => 'BANCO DEL BAJIO'], ['id' => 22, 'code' => 32, 'name' => 'IXE BANCO'], ['id' => 23, 'code' => 36, 'name' => 'BANCO INBURSA'], ['id' => 24, 'code' => 37, 'name' => 'BANCO INTERACCIONES'], ['id' => 25, 'code' => 42, 'name' => 'BANCA MIFEL'], ['id' => 26, 'code' => 44, 'name' => 'SCOTIABANK INVERLAT'], ['id' => 27, 'code' => 47, 'name' => 'BANCO PROMOTOR DEL NORTE'], ['id' => 28, 'code' => 56, 'name' => 'BANCA QUADRUMT'], ['id' => 29, 'code' => 58, 'name' => 'BANCO REGIONAL DE MONTERREY'], ['id' => 30, 'code' => 59, 'name' => 'BANCO INVEX'], ['id' => 31, 'code' => 60, 'name' => 'BANSI'], ['id' => 32, 'code' => 61, 'name' => 'BANCO DEL ATOYAC'], ['id' => 33, 'code' => 62, 'name' => 'BANCO AFIRME'], ['id' => 34, 'code' => 63, 'name' => 'BANCO SOFIMEX'], ['id' => 35, 'code' => 65, 'name' => 'BANCO ANAHUAC'], ['id' => 36, 'code' => 68, 'name' => 'BANCA PROMEX'], ['id' => 37, 'code' => 71, 'name' => 'BANPAIS'], ['id' => 38, 'code' => 72, 'name' => 'BANORTE'], ['id' => 39, 'code' => 83, 'name' => 'BANCO DE ORIENTE'], ['id' => 40, 'code' => 86, 'name' => 'BANCO DEL CENTRO'], ['id' => 41, 'code' => 90, 'name' => 'BANORO'], ['id' => 42, 'code' => 99, 'name' => 'DSAF'], ['id' => 43, 'code' => 101, 'name' => 'BANCA CREMI'], ['id' => 44, 'code' => 102, 'name' => 'THE ROYAL BANK OF SCOTLAND MEXICO'], ['id' => 45, 'code' => 103, 'name' => 'AMERICAN EXPRESS BANK LTD'], ['id' => 46, 'code' => 106, 'name' => 'BANK OF AMERICA MEXICO'], ['id' => 47, 'code' => 107, 'name' => 'BANK OF BOSTON'], ['id' => 48, 'code' => 108, 'name' => 'BANK OF TOKYO MEXICO'], ['id' => 49, 'code' => 110, 'name' => 'JPMORGAN CHASE BANK NA'], ['id' => 50, 'code' => 112, 'name' => 'BANCO MONEX, S.A.'], ['id' => 51, 'code' => 113, 'name' => 'BANCO VE POR MAS S.A. DE C.V.'], ['id' => 52, 'code' => 114, 'name' => 'FIRST NAT. BANK OF CHICAGO'], ['id' => 53, 'code' => 115, 'name' => 'FUJI BANK'], ['id' => 54, 'code' => 116, 'name' => 'ING BANK'], ['id' => 55, 'code' => 117, 'name' => 'J P MORGAN'], ['id' => 56, 'code' => 118, 'name' => 'NATIONS BANK N.A.'], ['id' => 57, 'code' => 123, 'name' => 'SOCIETE GENERALE'], ['id' => 58, 'code' => 124, 'name' => 'DEUTSCHE BANK AG NEW YORK'], ['id' => 59, 'code' => 128, 'name' => 'BANCO AUTOFIN MEXICO'], ['id' => 60, 'code' => 130, 'name' => 'COMPARTAMOS'], ['id' => 61, 'code' => 132, 'name' => 'BANCO MULTIVA SOCIEDAD ANONIMA'], ['id' => 62, 'code' => 135, 'name' => 'NACIONAL FINANCIERA'], ['id' => 63, 'code' => 139, 'name' => 'UBS BANK MEXICO S.A.'], ['id' => 64, 'code' => 149, 'name' => 'BANCO NACIONAL DE CREDITO RURAL'], ['id' => 65, 'code' => 161, 'name' => 'BANCRECER'], ['id' => 66, 'code' => 163, 'name' => 'BANCO OBRERO'], ['id' => 67, 'code' => 167, 'name' => 'TESORERIA DE LA FEDERACION'], ['id' => 68, 'code' => 168, 'name' => 'SOCIEDAD HIPOTECARIA FEDERAL'], ['id' => 69, 'code' => 402, 'name' => 'SCOTIABANK/NOSCATT'], ['id' => 70, 'code' => 404, 'name' => 'CREDIT SUISSE'], ['id' => 71, 'code' => 405, 'name' => 'LASALLE BANK'], ['id' => 72, 'code' => 406, 'name' => 'BANCO BNS (TORONTO)'], ['id' => 73, 'code' => 407, 'name' => 'BANKING DEUTSCHE BANK LONDON'], ['id' => 74, 'code' => 408, 'name' => 'JP MORGAN CHASE BANK LONDON SWIFT'], ['id' => 75, 'code' => 412, 'name' => 'UNIONE DI BANCHE ITALIANE SCPA'], ['id' => 76, 'code' => 413, 'name' => 'BANCA POPOLARE DI SONDRIO'], ['id' => 77, 'code' => 414, 'name' => 'BANCO FIDES'], ['id' => 78, 'code' => 415, 'name' => 'REGIONS BANK'], ['id' => 79, 'code' => 416, 'name' => 'BANCO ABN-AMRO BANK NV'], ['id' => 80, 'code' => 417, 'name' => 'RAIFFEISEN ZENTRALBANK OSTERREICH AG RZB'], ['id' => 81, 'code' => 418, 'name' => 'US BANK NATIONAL ASSOCIATTION'], ['id' => 82, 'code' => 501, 'name' => 'BANK OF NEW YORK'], ['id' => 83, 'code' => 502, 'name' => 'BANK OF AMERICA.'], ['id' => 84, 'code' => 503, 'name' => 'BANK ONE HOUSTON'], ['id' => 85, 'code' => 504, 'name' => 'JPMORGAN CHASE BANK NEW YORK'], ['id' => 86, 'code' => 506, 'name' => 'JPMORGAN CHASE BANK TEXAS'], ['id' => 87, 'code' => 507, 'name' => 'DEL RIO NATIONAL BANK.'], ['id' => 88, 'code' => 508, 'name' => 'COMERICA BANK'], ['id' => 89, 'code' => 509, 'name' => 'U.S BANK'], ['id' => 90, 'code' => 510, 'name' => 'THE LAREDO NATIONAL BANK.'], ['id' => 91, 'code' => 511, 'name' => 'NORWEST BANK INTERNATIONAL'], ['id' => 92, 'code' => 512, 'name' => 'WELLS FARGO BANK NA'], ['id' => 93, 'code' => 513, 'name' => 'NORDEA BANK DENMARK A/S'], ['id' => 94, 'code' => 515, 'name' => 'BANK OF SCOTLAND TREASURY'], ['id' => 95, 'code' => 516, 'name' => 'BANK ONE ARIZONA'], ['id' => 96, 'code' => 517, 'name' => 'BERLINER HANDLES'], ['id' => 97, 'code' => 518, 'name' => 'NORWEST BANK MINESOTA'], ['id' => 98, 'code' => 519, 'name' => 'SYDBSNK A S'], ['id' => 99, 'code' => 520, 'name' => 'FROST NATIONAL BANK.'], ['id' => 100, 'code' => 521, 'name' => 'TREASURY BANK'], ['id' => 101, 'code' => 524, 'name' => 'SWISS BANK SWITZERLAND'], ['id' => 102, 'code' => 525, 'name' => 'BANK OF NOVA SCOTIA GRAND CAIMAN'], ['id' => 103, 'code' => 526, 'name' => 'BANK OF NOVA SCOTIA LONDRES'], ['id' => 104, 'code' => 527, 'name' => 'BANK OF NOVA SCOTIA NEW YORK'], ['id' => 105, 'code' => 528, 'name' => 'BANCO DE CREDITO CENTRAMERICANO'], ['id' => 106, 'code' => 531, 'name' => 'UBS AG'], ['id' => 107, 'code' => 540, 'name' => 'IBC BANK'], ['id' => 108, 'code' => 548, 'name' => 'BANCO SANTANDER CENTRAL HISPANO S.A.'], ['id' => 109, 'code' => 551, 'name' => 'COMMERZBANK A.G.'], ['id' => 110, 'code' => 552, 'name' => 'DEUTSCHE BANK A.G.'], ['id' => 111, 'code' => 555, 'name' => 'BANCO BILBAO VIZCAYA ARGENTARIA S.A.'], ['id' => 112, 'code' => 559, 'name' => 'BANQUE NATIONALE DE PARIS.'], ['id' => 113, 'code' => 563, 'name' => 'BANK OF NOVA SCOTIA'], ['id' => 114, 'code' => 565, 'name' => 'UBS AG NEW YORK'], ['id' => 115, 'code' => 567, 'name' => 'BANCA COMERCIALE ITALIANA.'], ['id' => 116, 'code' => 568, 'name' => 'SKANDINAVISKA ESKILDEN BANKEN'], ['id' => 117, 'code' => 569, 'name' => 'DNB NOR BANK ASA'], ['id' => 118, 'code' => 570, 'name' => 'BANQUE DE BRUXELLES.'], ['id' => 119, 'code' => 572, 'name' => 'BARCLAYS BANK LTD.'], ['id' => 120, 'code' => 574, 'name' => 'SOUTH TEXAS NATIONAL BANK'], ['id' => 121, 'code' => 575, 'name' => 'CREDITANSTALT BANKVEREIN.'], ['id' => 122, 'code' => 582, 'name' => 'AMEGY BANK NATIONAL ASSOCIATION'], ['id' => 123, 'code' => 583, 'name' => 'BARCLAYS BANK PLC MIAMI'], ['id' => 124, 'code' => 584, 'name' => 'THE BANK OF NOVA SCOTIA/SCOTIA MOCATTA'], ['id' => 125, 'code' => 585, 'name' => 'BANK OF NOVA SCOTIA TOKYO'], ['id' => 126, 'code' => 589, 'name' => 'NORWEST BANK MINESOTA N.A.'], ['id' => 127, 'code' => 590, 'name' => 'CASA DE CAMBIO'], ['id' => 128, 'code' => 591, 'name' => 'FLEET BANK'], ['id' => 129, 'code' => 592, 'name' => 'NATIONAL WESTMINISTER BANK'], ['id' => 130, 'code' => 593, 'name' => 'BANCA MULTIPLE'], ['id' => 131, 'code' => 594, 'name' => 'BANCA DE DESARROLLO'], ['id' => 132, 'code' => 595, 'name' => 'CAROLINA FIRST BANK'], ['id' => 133, 'code' => 596, 'name' => 'CLEARSTREAM BANKING'], ['id' => 134, 'code' => 597, 'name' => 'BANCO POPOLARE DI VERONA E NOVARA'], ['id' => 135, 'code' => 598, 'name' => 'BANK ONE'], ['id' => 136, 'code' => 599, 'name' => 'DRESDNER BANK AG.'], ['id' => 137, 'code' => 600, 'name' => 'CASA DE BOLSA MONEX'], ['id' => 138, 'code' => 601, 'name' => 'CASA DE BOLSA GBM'], ['id' => 139, 'code' => 602, 'name' => 'MASARI CASA DE CAMBIO'], ['id' => 140, 'code' => 605, 'name' => 'VALUE CASA DE BOLSA'], ['id' => 141, 'code' => 607, 'name' => 'CASA DE CAMBIO TIBER'], ['id' => 142, 'code' => 608, 'name' => 'CASA DE BOLSA VECTOR'], ['id' => 143, 'code' => 610, 'name' => 'B Y B CASA DE CAMBIO'], ['id' => 144, 'code' => 611, 'name' => 'INTERCAM CASA DE CAMBIO'], ['id' => 145, 'code' => 612, 'name' => 'MAJAPARA CASA DE CAMBIO'], ['id' => 146, 'code' => 613, 'name' => 'MULTIVALORES CASA DE BOLSA'], ['id' => 147, 'code' => 614, 'name' => 'ACCIVAL CASA DE BOLSA'], ['id' => 148, 'code' => 615, 'name' => 'MERRIL LYNCH CASA DE BOLSA'], ['id' => 149, 'code' => 616, 'name' => 'CASA DE BOLSA FINAMEX'], ['id' => 150, 'code' => 617, 'name' => 'VALORES MEXICANO'], ['id' => 151, 'code' => 619, 'name' => 'MAPFRE TEPEYAC'], ['id' => 152, 'code' => 620, 'name' => 'PROFUTURO GNP AFORE'], ['id' => 153, 'code' => 621, 'name' => 'BANCO ACTINVER'], ['id' => 154, 'code' => 622, 'name' => 'ACTINVER SOCIEDAD OPERADORA'], ['id' => 155, 'code' => 624, 'name' => 'UNICREDITO ITALIANO SPA'], ['id' => 156, 'code' => 629, 'name' => 'HIPOTECARIA SU CASITA S.A. DE C.V.'], ['id' => 157, 'code' => 631, 'name' => 'VANGUARDIA CASA DE BOLSA'], ['id' => 158, 'code' => 633, 'name' => 'STERLING CASA DE CAMBIO S.A. DE C.V.'], ['id' => 159, 'code' => 647, 'name' => 'TELECOMM'], ['id' => 160, 'code' => 700, 'name' => 'SILICON VALLEY BANK'], ['id' => 161, 'code' => 852, 'name' => 'STANDARD CHARTERED BANK NEW YORK'], ['id' => 162, 'code' => 854, 'name' => 'BANK OF AMERICA NA'], ['id' => 163, 'code' => 855, 'name' => 'SANTANDER CENTRAL HISPANO NUEVA YORK'], ['id' => 164, 'code' => 856, 'name' => 'SYNOVUS BANK'], ['id' => 165, 'code' => 857, 'name' => 'BANCO POPOLARE SOC. COOP.'], ['id' => 166, 'code' => 858, 'name' => 'ALETTI & C. BANCA DI INVESTIMENTO MOBILI'], ['id' => 167, 'code' => 861, 'name' => 'FIFTH THIRD BANK'], ['id' => 168, 'code' => 862, 'name' => 'ITAU UNIBANCO SA GRAND CAYMAN BRANCH'], ['id' => 169, 'code' => 863, 'name' => 'CLS BANK INTERNATIONAL'], ['id' => 170, 'code' => 865, 'name' => 'COMMERCE BANK'], ['id' => 171, 'code' => 866, 'name' => 'ING BELGIUM NV'], ['id' => 172, 'code' => 867, 'name' => 'STANDARD CHARTERED BANK LONDRES'], ['id' => 173, 'code' => 869, 'name' => 'THE ROYAL BANK OF SCOTLAND LONDRES'], ['id' => 174, 'code' => 870, 'name' => 'BANKIA S.A'], ['id' => 175, 'code' => 871, 'name' => 'MB FINANCIAL BANK N.A'], ['id' => 176, 'code' => 872, 'name' => 'ITAU BANK LIMITED'], ['id' => 177, 'code' => 873, 'name' => 'POLSKI BANK PRZEDSICBIORCZOCI SPOLKA AKCYJNA'], ['id' => 178, 'code' => 874, 'name' => 'FIRSTMERIT BANK NA'], ['id' => 179, 'code' => 875, 'name' => 'SCOTIABANK CARIBBEAN TREASURY LIMITED'], ['id' => 180, 'code' => 876, 'name' => 'THE BANK OF NOVA SCOTIA LONDON'], ['id' => 181, 'code' => 878, 'name' => 'PACIFIC WESTERN BANK'], ['id' => 182, 'code' => 879, 'name' => 'BANCO ITAU (SUISSE) SA'], ['id' => 183, 'code' => 880, 'name' => 'ALLGEMEINE SPARKASSE OBEROESTERREICH BANK AG'], ['id' => 184, 'code' => 881, 'name' => 'SCOTIABANK CHILE'], ['id' => 185, 'code' => 882, 'name' => 'THE BANK OF NOVA SCOTIA ASIA LIMITED'], ['id' => 186, 'code' => 883, 'name' => 'HSBC BANK PLC'], ['id' => 187, 'code' => 902, 'name' => 'INDEVAL'], ['id' => 188, 'code' => 127, 'name' => 'BANCO AZTECA, S.A.'], ['id' => 189, 'code' => 131, 'name' => 'BANCO AHORRO FAMSA, S.A.'], ['id' => 190, 'code' => 133, 'name' => 'BANCO ACTIVER, S.A.'], ['id' => 191, 'code' => 134, 'name' => 'BANCO WALL-MART DE MEXICO ADELANTE, S.A.'], ['id' => 192, 'code' => 136, 'name' => 'INTER BANCO, S.A. DE C.V. INSTITUCION DE BANCA MULTIPLE'], ['id' => 193, 'code' => 137, 'name' => 'BANCOPPEL, S.A.'], ['id' => 194, 'code' => 138, 'name' => 'ABC CAPITAL, S.A. INSTITUCION DE BANCA MULITPLE'], ['id' => 195, 'code' => 140, 'name' => 'CONSUBANCO, S.A INSTITUCION DE BANCA MULTIPLE'], ['id' => 196, 'code' => 141, 'name' => 'VOLKSWAGEN BANK, S.A.'], ['id' => 197, 'code' => 143, 'name' => 'CI BANCO, S.A.'], ['id' => 198, 'code' => 145, 'name' => 'BANCO BASE, S.A., INSTITUCION DE BANCA MULTIPLE'], ['id' => 199, 'code' => 146, 'name' => 'BANCO BICENTENARIO, S.A., INSTITUCION DE BANCA MULTIPLE'], ['id' => 200, 'code' => 166, 'name' => 'BANCO DEL AHORRO NACIONAL Y SERVICIOS FINANCIEROS, S.A. DE C.V.'], ['id' => 201, 'code' => 401, 'name' => 'SOUTHWEST BANK OF TEXAS, NAV'], ['id' => 202, 'code' => 403, 'name' => 'CITIBANK, N.A.'], ['id' => 203, 'code' => 409, 'name' => 'DEUTSCHE BANK, FRANKFURT ALEMANIA'], ['id' => 204, 'code' => 410, 'name' => 'MAPLE BANK GBMH FRANKFURT, GERMANY'], ['id' => 205, 'code' => 411, 'name' => 'HSBC (BUFFALO, ESTADOS UNIDOS)'], ['id' => 206, 'code' => 577, 'name' => 'BANK OF TOKYO-MITSUBISHI UFJ, LTD'], ['id' => 207, 'code' => 606, 'name' => 'ESTRUCTURADORES DEL MERCADO DE VALORES CASA DE BOLSA, S.A. DE C.'], ['id' => 208, 'code' => 618, 'name' => 'UNICA CASA DE CAMBIO, S.A. DE C.V.'], ['id' => 209, 'code' => 623, 'name' => 'SKANDIA VIDA, S.A DE C.V'], ['id' => 210, 'code' => 625, 'name' => 'CASA DE CAMBIO TAMIBE, S.A. DE C.V.'], ['id' => 211, 'code' => 626, 'name' => 'DEUTSCHE SECURITIES, S.A. DE C.V'], ['id' => 212, 'code' => 627, 'name' => 'ZURICH COMPANIA DE SEGUROS, S.A.'], ['id' => 213, 'code' => 628, 'name' => 'ZURICH VIDA, COMPANIA DE SEGUROS, S.A.'], ['id' => 214, 'code' => 632, 'name' => 'BULLTICK CASA DE BOLSA, S.A. DE C.V.'], ['id' => 215, 'code' => 634, 'name' => 'FINCOMUN, SERVICIOS FINANCIEROS COMUNITARIOS, S.A. DE C.V.'], ['id' => 216, 'code' => 636, 'name' => 'GENWORTH SEGUROS MEXICO, S.A. DE C.V.'], ['id' => 217, 'code' => 637, 'name' => 'ORDER EXPRESS CASA DE CAMBIO, S.A. DE C.V'], ['id' => 218, 'code' => 639, 'name' => 'EUROFIMEX, CASA DE CAMBIO, S.A. DE C.V.'], ['id' => 219, 'code' => 640, 'name' => 'J.P. MORGAN CASA DE BOLSA, S.A. DE C.V'], ['id' => 220, 'code' => 642, 'name' => 'OPERADORA DE RECURSOS REFORMA, S.A. DE C'], ['id' => 221, 'code' => 643, 'name' => 'TIBER CAPITAL Y SOLUCIONES, S.A. DE C.V. SOFOM, E.N.R.'], ['id' => 222, 'code' => 646, 'name' => 'SISTEMA DE TRANSFERENCIAS Y PAGOS STP, S'], ['id' => 223, 'code' => 648, 'name' => 'EVERCORE CASA DE BOLSA, S.A. DE C.V.'], ['id' => 224, 'code' => 652, 'name' => 'SOLUCION ASEA, SA DE CV SFP'], ['id' => 225, 'code' => 653, 'name' => 'KUSPIT CASA DE BOLSA, S.A. DE C.V.'], ['id' => 226, 'code' => 655, 'name' => 'J.P. SOFIEXPRESS, S.A. DE C.V., S.F.P.'], ['id' => 227, 'code' => 656, 'name' => 'UNAGRA, S.A. DE C.V., S.F.P.'], ['id' => 228, 'code' => 659, 'name' => 'OPCIONES EMPRESARIALES DEL NORESTE, S.A. DE C.V., S.F.P.'], ['id' => 229, 'code' => 670, 'name' => 'LIBERTAD SERVICIOS FINANCIEROS, S.A. DE C.V., S.F.P.'], ['id' => 230, 'code' => 853, 'name' => 'BANCO ESPANOL DE CREDITOS, S.A.'], ['id' => 231, 'code' => 859, 'name' => 'BANCO ITAU BBA, S.A -NASSAU.BRANCH'], ['id' => 232, 'code' => 860, 'name' => 'BOKF, N.A.'], ['id' => 233, 'code' => 864, 'name' => 'BANCO POPULAR ESPANOL, S.A.'], ['id' => 234, 'code' => 877, 'name' => 'JPMORGAN CHASE BANK, LONDRES'], ['id' => 235, 'code' => 630, 'name' => 'INTERCAM CASA DE BOLSA, S.A. DE C.V.'], ['id' => 236, 'code' => 638, 'name' => 'AKALA, SA DE CV SOCIEDAD FINANCIERA POPULAR'], ['id' => 237, 'code' => 505, 'name' => 'BANK ONE, NA CHICAGO'], ['id' => 238, 'code' => 522, 'name' => 'HSBC BANK USA, NA'], ['id' => 239, 'code' => 523, 'name' => 'WACHOVIA BANK, NA'], ]); } }