PHP Classes

File: binbase.sql

Recommend this page to a friend!
  Classes of Yorch Ponce   PHP IIN and BIN   binbase.sql   Download  
File: binbase.sql
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: PHP IIN and BIN
Identify card issuer and bank from numbers
Author: By
Last change:
Date: 7 years ago
Size: 777 bytes
 

Contents

Class file image Download
CREATE DATABASE `bin`; CREATE TABLE `binbase` ( `BIN` varchar(6) DEFAULT NULL, `BRAND` varchar(45) DEFAULT NULL, `BANK` varchar(45) DEFAULT NULL, `CARD_TYPE` varchar(45) DEFAULT NULL, `CARD_CATEGORY` varchar(45) DEFAULT NULL, `COUNTRY` varchar(45) DEFAULT NULL, `CC_ISO3166_1` varchar(45) DEFAULT NULL, `CC_ISO_A3` varchar(45) DEFAULT NULL, `COUNTRY_NUM` varchar(45) DEFAULT NULL, `WEBSITE` varchar(45) DEFAULT NULL, `PHONE` varchar(45) DEFAULT NULL, KEY `bin_idx` (`BIN`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; USE bin; LOAD DATA LOCAL INFILE 'binbase_sample.csv' INTO TABLE binbase FIELDS TERMINATED BY ';' ENCLOSED BY '"' LINES TERMINATED BY '\n' (BIN,BRAND,BANK,CARD_TYPE,CARD_CATEGORY,COUNTRY,CC_ISO3166_1,CC_ISO_A3,COUNTRY_NUM,WEBSITE,PHONE);