-- phpMyAdmin SQL Dump
-- version 2.6.1
-- http://www.phpmyadmin.net
-- 
-- Serveur: localhost
-- Généré le : Dimanche 26 Octobre 2008 à 17:29
-- Version du serveur: 4.1.9
-- Version de PHP: 4.3.10
-- 
-- Base de données: `freepay`
-- 

-- --------------------------------------------------------

-- 
-- Structure de la table `freepay_banque`
-- 

CREATE TABLE `freepay_banque` (
  `bic` varchar(11) NOT NULL default '',
  `nominstitutionbic` varchar(120) NOT NULL default '',
  `villebic` varchar(40) NOT NULL default '',
  `codepaysbic` char(2) NOT NULL default '',
  `paysbic` varchar(40) NOT NULL default '',
  `urlbic` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`bic`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Contenu de la table `freepay_banque`
-- 

INSERT INTO `freepay_banque` VALUES ('XAEXNL21XXX', 'AEX-AGRICULTURAL FUTURES EXCHANGE', 'AMSTERDAM', 'NL', 'NETHERLANDS', '');
INSERT INTO `freepay_banque` VALUES ('XALBCA61XXX', 'ALBERTA STOCK EXCHANGE, THE', 'CALGARY', 'CA', 'CANADA', '');
INSERT INTO `freepay_banque` VALUES ('XASEUS31XXX', 'AMERICAN STOCK EXCHANGE', 'NEW YORK,NY', 'US', 'UNITED STATES', 'http://www.amex.com/');
INSERT INTO `freepay_banque` VALUES ('XAMMJOA1XXX', 'AMMAN STOCK EXCHANGE', 'AMMAN', 'JO', 'JORDAN', 'http://www.ase.com.jo/');
INSERT INTO `freepay_banque` VALUES ('XACENL21XXX', 'AMSTERDAM COMMODITY EXCHANGE', 'AMSTERDAM', 'NL', 'NETHERLANDS', '');
INSERT INTO `freepay_banque` VALUES ('XAMSNL21XXX', 'AMSTERDAMSE EFFECTENBEURS', 'AMSTERDAM', 'NL', 'NETHERLANDS', 'http://www.aex.nl/');
INSERT INTO `freepay_banque` VALUES ('XASXAU2SXXX', 'ASX OPERATIONS PTY LIMITED', 'SYDNEY', 'AU', 'AUSTRALIA', 'http://www.asx.com.au/');
INSERT INTO `freepay_banque` VALUES ('XADEGRA1XXX', 'ATHENS DERIVATIVES EXCHANGE S.A. (ADEX), THE', 'ATHENS', 'GR', 'GREECE', 'http://www.adex.ase.gr/');
INSERT INTO `freepay_banque` VALUES ('XATHGRA1XXX', 'ATHENS STOCK EXCHANGE', 'ATHENS', 'GR', 'GREECE', 'http://www.ase.gr/');
INSERT INTO `freepay_banque` VALUES ('XSTUDES1XXX', 'BADEN-WUERTTEMBERGISCHE WERTPAPIERBOERSE ZU STUTTGART', 'STUTTGART', 'DE', 'GERMANY', 'http://www.boerse-stuttgart.de/');
INSERT INTO `freepay_banque` VALUES ('XBAHBHB1XXX', 'BAHRAIN STOCK EXCHANGE', 'MANAMA', 'BH', 'BAHRAIN', 'http://www.bisxbahamas.com/');
INSERT INTO `freepay_banque` VALUES ('XBANIN51XXX', 'BANGALORE STOCK EXCHANGE LTD', 'BANGALORE', 'IN', 'INDIA', 'http://www.bgse.co.in/');
INSERT INTO `freepay_banque` VALUES ('XBARESB1XXX', 'BARCELONA STOCK EXCHANGE', 'BARCELONA', 'ES', 'SPAIN', 'http://www.borsabcn.es/');
INSERT INTO `freepay_banque` VALUES ('XMUNDEM1XXX', 'BAYERISCHE BOERSE', 'MUENCHEN', 'DE', 'GERMANY', 'http://www.boerse-muenchen.de/');
INSERT INTO `freepay_banque` VALUES ('XBERDEB1XXX', 'BERLINER WERTPAPIERBOERSE', 'BERLIN', 'DE', 'GERMANY', '');
INSERT INTO `freepay_banque` VALUES ('XBDABMH1XXX', 'BERMUDA STOCK EXCHANGE LTD, THE', 'HAMILTON', 'BM', 'BERMUDA', 'http://www.bsx.com/');
INSERT INTO `freepay_banque` VALUES ('XBRNCH21XXX', 'BERNE STOCK EXCHANGE', 'BERNE', 'CH', 'SWITZERLAND', 'http://www.berne-x.com/');
INSERT INTO `freepay_banque` VALUES ('XANTBE21XXX', 'BEURS VAN ANTWERPEN (ANTWERP STOCK EXCHANGE)', 'ANTWERPEN', 'BE', 'BELGIUM', '');
INSERT INTO `freepay_banque` VALUES ('XBMFBRBRXXX', 'BMF - CAMARA DE DERIVATIVOS', 'SAO PAULO', 'BR', 'BRAZIL', 'http://www.bmf.com.br/');
INSERT INTO `freepay_banque` VALUES ('XQTXDED1XXX', 'BOERSE DUESSELDORF', 'DUESSELDORF', 'DE', 'GERMANY', 'http://www.boerse-duesseldorf.de/');
INSERT INTO `freepay_banque` VALUES ('XBOLBOL1XXX', 'BOLSA BOLIVIANA DE VALORES S.A.', 'LA PAZ', 'BO', 'BOLIVIA', 'http://www.bolsa-valores-bolivia.com/');
INSERT INTO `freepay_banque` VALUES ('XROSARB1XXX', 'BOLSA DE COMERCIO ROSARIO', 'ROSARIO', 'AR', 'ARGENTINA', 'http://www.bcr.com.ar/');
INSERT INTO `freepay_banque` VALUES ('XBDPPTP1XXX', 'BOLSA DE DERIVADOS DO PORTO', 'PORTO', 'PT', 'PORTUGAL', '');
INSERT INTO `freepay_banque` VALUES ('XVALESV1XXX', 'BOLSA DE VALENCIA', 'VALENCIA', 'ES', 'SPAIN', 'http://www.bolsavalencia.es/');
INSERT INTO `freepay_banque` VALUES ('XBILES21XXX', 'BOLSA DE VALORES DE BILBAO', 'BILBAO', 'ES', 'SPAIN', 'http://www.bolsabilbao.es/');
INSERT INTO `freepay_banque` VALUES ('XBOGCOB1XXX', 'BOLSA DE VALORES DE COLUMBIA S.A.', 'BOGOTA', 'CO', 'COLOMBIA', 'http://www.bvc.com.co/');
INSERT INTO `freepay_banque` VALUES ('XMNTUYM1XXX', 'BOLSA DE VALORES DE MONTEVIDEO', 'MONTEVIDEO', 'UY', 'URUGUAY', 'http://www.bvm.com.uy/');
INSERT INTO `freepay_banque` VALUES ('XPTYPAP1XXX', 'BOLSA DE VALORES DE PANAMA, S.A.', 'PANAMA', 'PA', 'PANAMA', 'http://www.panabolsa.com/');
INSERT INTO `freepay_banque` VALUES ('XBSPBRS1XXX', 'BOLSA DE VALORES DE SAO PAULO', 'SAO PAULO', 'BR', 'BRAZIL', 'http://www.bovespa.com.br/');
INSERT INTO `freepay_banque` VALUES ('XRIOBRR1XXX', 'BOLSA DE VALORES DO RIO DE JANEIRO', 'RIO DE JANEIRO', 'BR', 'BRAZIL', 'http://www.bvrj.com.br/');
INSERT INTO `freepay_banque` VALUES ('XGTGGTG1XXX', 'BOLSA DE VALORES NACIONAL SA', 'GUATEMALA', 'GT', 'GUATEMALA', 'http://www.bvnsa.com.gt/');
INSERT INTO `freepay_banque` VALUES ('XVPAPYP1XXX', 'BOLSA DE VALORES Y PRODUCTOS DE ASUNCION SA (BVPASA)', 'ASUNCION', 'PY', 'PARAGUAY', 'http://www.bvpasa.com.py/');
INSERT INTO `freepay_banque` VALUES ('XMEXMXM1XXX', 'BOLSA MEXICANA DE VALORES (MEXICAN STOCK EXCHANGE)', 'MEXICO', 'MX', 'MEXICO', 'http://www.bmv.com.mx/');
INSERT INTO `freepay_banque` VALUES ('XMILITM1XXX', 'BORSA ITALIANA S.P.A.', 'MILANO', 'IT', 'ITALY', 'http://www.borsaitaliana.it/');
INSERT INTO `freepay_banque` VALUES ('XBOSUS31XXX', 'BOSTON STOCK EXCHANGE', 'BOSTON,MA', 'US', 'UNITED STATES', 'http://www.bostonstock.com/');
INSERT INTO `freepay_banque` VALUES ('XBOTBWG1XXX', 'BOTSWANA SHARE MARKET', 'GABORONE', 'BW', 'BOTSWANA', 'http://www.bse.co.bw/');
INSERT INTO `freepay_banque` VALUES ('XBEYLBB1XXX', 'BOURSE DE BEYROUTH', 'BEIRUT', 'LB', 'LEBANON', 'http://www.bse.com.lb/');
INSERT INTO `freepay_banque` VALUES ('XLUXLUL1XXX', 'BOURSE DE LUXEMBOURG/LUXEMBOURG STOCK EXCHANGE', 'LUXEMBOURG', 'LU', 'LUXEMBOURG', 'http://www.bourse.lu/');
INSERT INTO `freepay_banque` VALUES ('XABJCIA1XXX', 'BOURSE DES VALEURS ABIDJAN', 'ABIDJAN', 'CI', 'COTE D''IVOIRE', '');
INSERT INTO `freepay_banque` VALUES ('XTUNTNT1XXX', 'BOURSE DES VALEURS MOBILIERES', 'TUNIS', 'TN', 'TUNISIA', 'http://www.bvmt.com.tn/');
INSERT INTO `freepay_banque` VALUES ('XBRASKB1XXX', 'BRATISLAVA STOCK EXCHANGE, THE', 'BRATISLAVA', 'SK', 'SLOVAKIA', 'http://www.bsse.sk/');
INSERT INTO `freepay_banque` VALUES ('XBFOBEB1XXX', 'BRUSSELS EXCHANGES CLEARING HOUSE NV', 'BRUSSELS', 'BE', 'BELGIUM', '');
INSERT INTO `freepay_banque` VALUES ('XBSEROB1XXX', 'BUCHAREST STOCK EXCHANGE', 'BUCHAREST', 'RO', 'ROMANIA', 'http://www.bvb.ro/');
INSERT INTO `freepay_banque` VALUES ('XBCEHUH1XXX', 'BUDAPEST COMMODITY EXCHANGE', 'BUDAPEST', 'HU', 'HUNGARY', 'http://www.bse.hu/');
INSERT INTO `freepay_banque` VALUES ('XBUDHUH1XXX', 'BUDAPEST STOCK EXCHANGE', 'BUDAPEST', 'HU', 'HUNGARY', 'http://www.bse.hu/');
INSERT INTO `freepay_banque` VALUES ('XBUEARB1XXX', 'BUENOS AIRES STOCK EXCHANGE', 'BUENOS AIRES', 'AR', 'ARGENTINA', 'http://www.bcba.sba.com.ar/');
INSERT INTO `freepay_banque` VALUES ('XBULBGS1XXX', 'BULGARIAN STOCK EXCHANGE', 'SOFIA', 'BG', 'BULGARIA', 'http://www.bse-sofia.bg/');
INSERT INTO `freepay_banque` VALUES ('XBBJIDJ1XXX', 'BURSA BERJANGKA JAKARTA (JAKARTA FUTURES EXCHANGE)', 'JAKARTA', 'ID', 'INDONESIA', 'http://bbj-jfx.com/');
INSERT INTO `freepay_banque` VALUES ('XCAIEGC1XXX', 'CAIRO AND ALEXANDRA STOCK EXCHANGE', 'CAIRO', 'EG', 'EGYPT', 'http://www.egyptse.com/');
INSERT INTO `freepay_banque` VALUES ('XCALINC1XXX', 'CALCUTTA STOCK EXCHANGE', 'KOLKATA (CALCUTTA)', 'IN', 'INDIA', 'http://www.cse-india.com/');
INSERT INTO `freepay_banque` VALUES ('XCFFUS31XXX', 'CANTOR FINANCIAL FURTURES EXCHANGE', 'NEW YORK,NY', 'US', 'UNITED STATES', 'http://www.cantor.com/');
INSERT INTO `freepay_banque` VALUES ('XCARVEC1XXX', 'CARACAS STOCK EXCHANGE', 'CARACAS', 'VE', 'VENEZUELA', 'http://www.bolsadecaracas.com/');
INSERT INTO `freepay_banque` VALUES ('XCASMAM1XXX', 'CASABLANCA STOCK EXCHANGE', 'CASABLANCA', 'MA', 'MOROCCO', 'http://www.casablanca-bourse.com/');
INSERT INTO `freepay_banque` VALUES ('XKAZKZK1XXX', 'CENTRAL ASIAN STOCK EXCHANGE', 'ALMATY', 'KZ', 'KAZAKHSTAN', 'http://www.kase.kz/');
INSERT INTO `freepay_banque` VALUES ('XCBTUS41XXX', 'CHICAGO BOARD OF TRADE', 'CHICAGO,IL', 'US', 'UNITED STATES', 'http://www.cbot.com/');
INSERT INTO `freepay_banque` VALUES ('XCBOUS41XXX', 'CHICAGO BOARD OPTIONS EXCHANGE', 'CHICAGO,IL', 'US', 'UNITED STATES', 'http://www.cboe.com/');
INSERT INTO `freepay_banque` VALUES ('XCMEUS4CXXX', 'CHICAGO MERCANTILE EXCHANGE', 'CHICAGO,IL', 'US', 'UNITED STATES', 'http://www.cme.com/');
INSERT INTO `freepay_banque` VALUES ('XCMEUS4FXXX', 'CHICAGO MERCANTILE EXCHANGE', 'CHICAGO,IL', 'US', 'UNITED STATES', 'http://www.cme.com/');
INSERT INTO `freepay_banque` VALUES ('XCRCUS41XXX', 'CHICAGO RICE AND COTTON EXCHANGE', 'CHICAGO,IL', 'US', 'UNITED STATES', '');
INSERT INTO `freepay_banque` VALUES ('XCHIUS41XXX', 'CHICAGO STOCK EXCHANGE, INC.', 'CHICAGO,IL', 'US', 'UNITED STATES', 'http://www.chx.com/');
INSERT INTO `freepay_banque` VALUES ('XCFECNS1XXX', 'CHINA FOREIGN EXCHANGE TRADE SYSTEM', 'SHANGHAI', 'CN', 'CHINA', '');
INSERT INTO `freepay_banque` VALUES ('XCCEJPJ1XXX', 'CHUBU COMMODITY EXCHANGE', 'NAGOYA', 'JP', 'JAPAN', '');
INSERT INTO `freepay_banque` VALUES ('XCISUS41XXX', 'CINCINNATI STOCK EXCHANGE', 'CHICAGO,IL', 'US', 'UNITED STATES OF AMERICA', 'http://www.nsx.com/');
INSERT INTO `freepay_banque` VALUES ('XCOLLKL1XXX', 'COLOMBO STOCK EXCHANGE', 'COLOMBO', 'LK', 'SRI LANKA', 'http://www.cse.lk/');
INSERT INTO `freepay_banque` VALUES ('XCECUS31XXX', 'COMMODITIES EXCHANGE CENTER', 'NEW YORK,NY', 'US', 'UNITED STATES', '');
INSERT INTO `freepay_banque` VALUES ('XCORGB21XXX', 'COREDEAL', 'LONDON', 'GB', 'UNITED KINGDOM', '');
INSERT INTO `freepay_banque` VALUES ('XCYSCY2NXXX', 'CYPRUS STOCK EXCHANGE', 'NICOSIA (LEFKOSIA)', 'CY', 'CYPRUS', 'http://www.cse.com.cy/');
INSERT INTO `freepay_banque` VALUES ('XDESIND1XXX', 'DELHI STOCK EXCHANGE', 'NEW DELHI', 'IN', 'INDIA', 'http://www.dseindia.com/');
INSERT INTO `freepay_banque` VALUES ('XDWZDEF1XXX', 'DEUTSCHE BOERSE AG, FRANKFURT AM MAIN', 'FRANKFURT AM MAIN', 'DE', 'GERMANY', 'http://deutsche-boerse.com/');
INSERT INTO `freepay_banque` VALUES ('XETRDEF1XXX', 'DEUTSCHER KASSENVEREIN AG GRUPPE DEUTSCHE BOERSE', 'FRANKFURT AM MAIN', 'DE', 'GERMANY', '');
INSERT INTO `freepay_banque` VALUES ('XDHABDD1XXX', 'DHAKA STOCK EXCHANGE LTD', 'DHAKA', 'BD', 'BANGLADESH', 'http://www.dsebd.org/');
INSERT INTO `freepay_banque` VALUES ('DSMDQAQ1XXX', 'DOHA SECURITIES MARKET', 'DOHA', 'QA', 'QATAR', 'http://www.dsm.com.qa/');
INSERT INTO `freepay_banque` VALUES ('DGCXAEAAXXX', 'DUBAI GOLD AND COMMODITIES EXCHANGE DMCC', 'DUBAI', 'AE', 'UNITED ARAB EMIRATES', 'http://www.dgcx.ae/');
INSERT INTO `freepay_banque` VALUES ('DIFXAEAAXXX', 'DUBAI INTERNATIONAL FINANCIAL EXCHANGE LTD', 'DUBAI', 'AE', 'UNITED ARAB EMIRATES', 'http://www.difx.ae/');
INSERT INTO `freepay_banque` VALUES ('XEASBEB1XXX', 'EASDAQ S.A.', 'BRUSSELS', 'BE', 'BELGIUM', '');
INSERT INTO `freepay_banque` VALUES ('XEUBDEF1XXX', 'EUREX BONDS', 'FRANKFURT AM MAIN', 'DE', 'GERMANY', 'http://www.eurex-bonds.com/');
INSERT INTO `freepay_banque` VALUES ('XEURDEF1XXX', 'EUREX DEUTSCHLAND', 'FRANKFURT AM MAIN', 'DE', 'GERMANY', 'http://www.eurexchange.com/');
INSERT INTO `freepay_banque` VALUES ('XEURCHZ1XXX', 'EUREX ZURICH AG', 'ZURICH', 'CH', 'SWITZERLAND', 'http://www.eurexchange.com/');
INSERT INTO `freepay_banque` VALUES ('EMTSGB2LXXX', 'EURO MTS', 'LONDON', 'GB', 'UNITED KINGDOM', '');
INSERT INTO `freepay_banque` VALUES ('XEUNBEBBXXX', 'EURONEXT BRUSSELS S.A./N.V.', 'BRUSSELS', 'BE', 'BELGIUM', 'http://www.euronext.com/');
INSERT INTO `freepay_banque` VALUES ('XEUCNL21XXX', 'EURONEXT COM, COMMODITIES FUTURES AND OPTIONS', 'AMSTERDAM', 'NL', 'NETHERLANDS', 'http://www.euronext.com/');
INSERT INTO `freepay_banque` VALUES ('XEUENL21XXX', 'EURONEXT EQF, EQUITIES AND INDICES DERIVATIVES', 'AMSTERDAM', 'NL', 'NETHERLANDS', 'http://www.euronext.com/');
INSERT INTO `freepay_banque` VALUES ('XEUINL21XXX', 'EURONEXT IRF, INTEREST RATE FUTURE AND OPTIONS', 'AMSTERDAM', 'NL', 'NETHERLANDS', 'http://www.euronext.com/');
INSERT INTO `freepay_banque` VALUES ('XLISPTP1XXX', 'EURONEXT LISBOA', 'LISBON', 'PT', 'PORTUGAL', 'http://www.euronext.com/');
INSERT INTO `freepay_banque` VALUES ('XMONFRP1XXX', 'EURONEXT PARIS MONEP (MARCHE DES OPTIONS NEGOCIALBLES DE PARIS (MONEP))', 'PARIS', 'FR', 'FRANCE', 'http://www.monep.fr/');
INSERT INTO `freepay_banque` VALUES ('XPARFRPPTRS', 'EURONEXT PARIS S.A.', 'PARIS', 'FR', 'FRANCE', 'http://www.euronext.com/');
INSERT INTO `freepay_banque` VALUES ('XPARFRPPLIS', 'EURONEXT PARIS S.A.', 'PARIS', 'FR', 'FRANCE', 'http://www.euronext.com/');
INSERT INTO `freepay_banque` VALUES ('XPARFRPPINT', 'EURONEXT PARIS S.A.', 'PARIS', 'FR', 'FRANCE', 'http://www.euronext.com/');
INSERT INTO `freepay_banque` VALUES ('XPARFRPP022', 'EURONEXT PARIS S.A.', 'PARIS', 'FR', 'FRANCE', 'http://www.euronext.com/');
INSERT INTO `freepay_banque` VALUES ('XPARFRPPXXX', 'EURONEXT PARIS S.A.', 'PARIS', 'FR', 'FRANCE', 'http://www.euronext.com/');
INSERT INTO `freepay_banque` VALUES ('XFTANL21XXX', 'FINANCIELE TERMIJNMARKET AMSTERDAM', 'AMSTERDAM', 'NL', 'NETHERLANDS', '');
INSERT INTO `freepay_banque` VALUES ('XFNXIE21XXX', 'FINEX', 'DUBLIN', 'IE', 'IRELAND', '');
INSERT INTO `freepay_banque` VALUES ('XFNXUS31XXX', 'FINEX', 'NEW YORK,NY', 'US', 'UNITED STATES', '');
INSERT INTO `freepay_banque` VALUES ('XFOMFIH1XXX', 'FINNISH OPTIONS MARKET', 'HELSINKI', 'FI', 'FINLAND', '');
INSERT INTO `freepay_banque` VALUES ('XFRADEF1XXX', 'FRANKFURTER WERTPAPIERBOERSE', 'FRANKFURT AM MAIN', 'DE', 'GERMANY', 'http://deutsche-boerse.com/');
INSERT INTO `freepay_banque` VALUES ('XFKAJPJ1XXX', 'FUKUOKA STOCK EXCHANGE', 'FUKUOKA', 'JP', 'JAPAN', 'http://www.fse.or.jp/');
INSERT INTO `freepay_banque` VALUES ('XGHAGHA1XXX', 'GHANA STOCK EXCHANGE', 'ACCRA', 'GH', 'GHANA', 'http://www.gse.com.gh/');
INSERT INTO `freepay_banque` VALUES ('XGUAECE1XXX', 'GUAYAQUIL STOCK EXCHANGE', 'GUAYAQUIL', 'EC', 'ECUADOR', 'http://www.mundobvg.com/');
INSERT INTO `freepay_banque` VALUES ('XHAMDEH1XXX', 'HANSEATISCHE WERTPAPIERBOERSE HAMBURG', 'HAMBURG', 'DE', 'GERMANY', 'http://www.hamburger-boerse.de/');
INSERT INTO `freepay_banque` VALUES ('XHIRJPJ1XXX', 'HIROSHIMA STOCK EXCHANGE', 'HIROSHIMA', 'JP', 'JAPAN', 'http://www.tse.or.jp/');
INSERT INTO `freepay_banque` VALUES ('XHKFHKHHTRE', 'HKFE CLEARING CORPORATION LIMITED', 'HONG KONG', 'HK', 'HONG KONG', 'http://www.hkex.com.hk/');
INSERT INTO `freepay_banque` VALUES ('XHKFHKHHXXX', 'HKFE CLEARING CORPORATION LIMITED', 'HONG KONG', 'HK', 'HONG KONG', 'http://www.hkex.com.hk/');
INSERT INTO `freepay_banque` VALUES ('XHKCHKH1XXX', 'HONG KONG SECURITIES CLEARING COMPANY LIMITED', 'HONG KONG', 'HK', 'HONG KONG', 'http://www.hkex.com.hk/');
INSERT INTO `freepay_banque` VALUES ('XISTTRI1XXX', 'I.M.K.B. (ISTANBUL STOCK EXCHANGE)', 'ISTANBUL', 'TR', 'TURKEY', 'http://www.ise.org/');
INSERT INTO `freepay_banque` VALUES ('XICEISR1UTC', 'ICELAND STOCK EXCHANGE', 'REYKJAVIK', 'IS', 'ICELAND', 'http://www.omxnordicexchange.com/');
INSERT INTO `freepay_banque` VALUES ('XICEISR1XXX', 'ICELAND STOCK EXCHANGE', 'REYKJAVIK', 'IS', 'ICELAND', 'http://www.omxnordicexchange.com/');
INSERT INTO `freepay_banque` VALUES ('XICEISR1SHR', 'ICELAND STOCK EXCHANGE', 'REYKJAVIK', 'IS', 'ICELAND', 'http://www.omxnordicexchange.com/');
INSERT INTO `freepay_banque` VALUES ('XICEISR1PRB', 'ICELAND STOCK EXCHANGE', 'REYKJAVIK', 'IS', 'ICELAND', 'http://www.omxnordicexchange.com/');
INSERT INTO `freepay_banque` VALUES ('XICEISR1BND', 'ICELAND STOCK EXCHANGE', 'REYKJAVIK', 'IS', 'ICELAND', 'http://www.omxnordicexchange.com/');
INSERT INTO `freepay_banque` VALUES ('XICEISR1CFI', 'ICELAND STOCK EXCHANGE', 'REYKJAVIK', 'IS', 'ICELAND', 'http://www.omxnordicexchange.com/');
INSERT INTO `freepay_banque` VALUES ('XICEISR1ETF', 'ICELAND STOCK EXCHANGE', 'REYKJAVIK', 'IS', 'ICELAND', 'http://www.omxnordicexchange.com/');
INSERT INTO `freepay_banque` VALUES ('XICEISR1OAM', 'ICELAND STOCK EXCHANGE', 'REYKJAVIK', 'IS', 'ICELAND', 'http://www.omxnordicexchange.com/');
INSERT INTO `freepay_banque` VALUES ('XICEISR1OEQ', 'ICELAND STOCK EXCHANGE', 'REYKJAVIK', 'IS', 'ICELAND', 'http://www.omxnordicexchange.com/');
INSERT INTO `freepay_banque` VALUES ('XICEISR1OFU', 'ICELAND STOCK EXCHANGE', 'REYKJAVIK', 'IS', 'ICELAND', 'http://www.omxnordicexchange.com/');
INSERT INTO `freepay_banque` VALUES ('XICEISR1AMA', 'ICELAND STOCK EXCHANGE', 'REYKJAVIK', 'IS', 'ICELAND', 'http://www.omxnordicexchange.com/');
INSERT INTO `freepay_banque` VALUES ('XICEISR1OFN', 'ICELAND STOCK EXCHANGE', 'REYKJAVIK', 'IS', 'ICELAND', 'http://www.omxnordicexchange.com/');
INSERT INTO `freepay_banque` VALUES ('XIOMUS41XXX', 'INDEX AND OPTIONS MARKET', 'CHICAGO,IL', 'US', 'UNITED STATES OF AMERICA', 'http://www.cboe.com/');
INSERT INTO `freepay_banque` VALUES ('XCVMPTP1XXX', 'INTERBOLSA, SOC. GESTORA DE SISTEMAS DE LIQUIDACAO E DE SISTEMAS CENTRALIZADOS DE VALORES MOBILIARIOS, SA', 'PORTO', 'PT', 'PORTUGAL', '');
INSERT INTO `freepay_banque` VALUES ('IEPAGB21XXX', 'INTERCONTINENTAL EXCHANGE LTD.', 'LONDON', 'GB', 'UNITED KINGDOM', 'http://www.theice.com/');
INSERT INTO `freepay_banque` VALUES ('IEPAUS31XXX', 'INTERCONTINENTAL EXCHANGE PARTNERS', 'NEW YORK,NY', 'US', 'UNITED STATES', 'http://www.theice.com/');
INSERT INTO `freepay_banque` VALUES ('XIMMUS41XXX', 'INTERNATIONAL MONETARY MARKET', 'CHICAGO,IL', 'US', 'UNITED STATES OF AMERICA', '');
INSERT INTO `freepay_banque` VALUES ('XIPEGB21XXX', 'INTERNATIONAL PETROLEUM EXCHANGE', 'LONDON', 'GB', 'UNITED KINGDOM', 'https://www.theice.com/');
INSERT INTO `freepay_banque` VALUES ('XISXUS31XXX', 'INTERNATIONAL SECURITIES EXCHANGE, LLC.', 'NEW YORK,NY', 'US', 'UNITED STATES', 'http://www.ise.com/');
INSERT INTO `freepay_banque` VALUES ('XDUBIE21XXX', 'IRISH STOCK EXCHANGE', 'DUBLIN', 'IE', 'IRELAND', 'http://www.ise.ie/');
INSERT INTO `freepay_banque` VALUES ('XDMIITM1XXX', 'ITALIAN DERIVATIVES MARKET (IDEM)', 'MILANO', 'IT', 'ITALY', 'http://www.borsaitaliana.it/');
INSERT INTO `freepay_banque` VALUES ('ITGIUS31XXX', 'ITG INC.', 'NEW YORK,NY', 'US', 'UNITED STATES', 'http://www.itginc.com/');
INSERT INTO `freepay_banque` VALUES ('XJNBIDJ1XXX', 'JAKARTA NEGOTIATED BOARD', 'JAKARTA', 'ID', 'INDONESIA', '');
INSERT INTO `freepay_banque` VALUES ('XJKTIDJ1XXX', 'JAKARTA STOCK EXCHANGE', 'JAKARTA', 'ID', 'INDONESIA', 'http://www.jsx.co.id/');
INSERT INTO `freepay_banque` VALUES ('XJAMJMK1XXX', 'JAMAICA STOCK EXCHANGE, THE', 'KINGSTON', 'JM', 'JAMAICA', 'http://www.jamstockex.com/');
INSERT INTO `freepay_banque` VALUES ('XJWYGB21XXX', 'JIWAY EXCHANGE LTD', 'LONDON', 'GB', 'UNITED KINGDOM', '');
INSERT INTO `freepay_banque` VALUES ('XJSEZAJJSAT', 'JSE LIMITED', 'SANDTON', 'ZA', 'SOUTH AFRICA', 'http://www.jse.co.za/');
INSERT INTO `freepay_banque` VALUES ('XJSEZAJJXXX', 'JSE LIMITED', 'SANDTON', 'ZA', 'SOUTH AFRICA', 'http://www.jse.co.za/');
INSERT INTO `freepay_banque` VALUES ('XJSEZAJJMRG', 'JSE LIMITED', 'SANDTON', 'ZA', 'SOUTH AFRICA', 'http://www.jse.co.za/');
INSERT INTO `freepay_banque` VALUES ('XJSEZAJJISN', 'JSE LIMITED', 'SANDTON', 'ZA', 'SOUTH AFRICA', 'http://www.jse.co.za/');
INSERT INTO `freepay_banque` VALUES ('XJSEZAJJSLB', 'JSE LIMITED', 'SANDTON', 'ZA', 'SOUTH AFRICA', 'http://www.jse.co.za/');
INSERT INTO `freepay_banque` VALUES ('XJSEZAJJSFX', 'JSE LIMITED', 'SANDTON', 'ZA', 'SOUTH AFRICA', 'http://www.jse.co.za/');
INSERT INTO `freepay_banque` VALUES ('XKSTJPJ1XXX', 'KANMON SHOHIN TORIHIKIJO (COMMODITY EXCHANGE)', 'SHIMONOSEKI', 'JP', 'JAPAN', '');
INSERT INTO `freepay_banque` VALUES ('XKACJPJ1XXX', 'KANSAI AGRICULTURAL COMMODITIES EXCHANGE', 'OSAKA', 'JP', 'JAPAN', 'http://www.kanex.or.jp/');
INSERT INTO `freepay_banque` VALUES ('XKBTUS41XXX', 'KANSAS CITY BOARD OF TRADE', 'KANSAS CITY,MO', 'US', 'UNITED STATES', 'http://www.kcbt.com/');
INSERT INTO `freepay_banque` VALUES ('XKARPKK1XXX', 'KARACHI STOCK EXCHANGE (GUARANTEE) LIMITED, THE', 'KARACHI', 'PK', 'PAKISTAN', 'http://www.kse.com.pk/');
INSERT INTO `freepay_banque` VALUES ('XKHRUA21XXX', 'KHARKOV COMMODITY EXCHANGE', 'KHARKIV', 'UA', 'UKRAINE', '');
INSERT INTO `freepay_banque` VALUES ('XKCEUZ31XXX', 'KHOREZM INTERREGION COMMODITY EXCHANGE', 'TASHKENT', 'UZ', 'UZBEKISTAN', '');
INSERT INTO `freepay_banque` VALUES ('XKIEUAU1XXX', 'KIEV UNIVERSAL EXCHANGE', 'KIEV', 'UA', 'UKRAINE', 'http://www.kue.kiev.ua/');
INSERT INTO `freepay_banque` VALUES ('XKGTJPJ1XXX', 'KOBE GOMU TORIHIKIJO (RUBBER EXCHANGE)', 'OSAKA', 'JP', 'JAPAN', '');
INSERT INTO `freepay_banque` VALUES ('XKKTJPJ1XXX', 'KOBE KIITO TORIHIKIJO (RAW SILK EXCHANGE)', 'KOBE', 'JP', 'JAPAN', '');
INSERT INTO `freepay_banque` VALUES ('XKFEKR21XXX', 'KOREA FUTURES EXCHANGE', 'PUSAN', 'KR', 'KOREA, REPUBLIC OF', 'http://www.krx.co.kr/');
INSERT INTO `freepay_banque` VALUES ('XKORKRS1XXX', 'KOREA STOCK EXCHANGE', 'SEOUL', 'KR', 'KOREA, REPUBLIC OF', 'http://www.krx.co.kr/');
INSERT INTO `freepay_banque` VALUES ('XKLSMYK1XXX', 'KUALA LUMPUR STOCK EXCHANGE, THE', 'KUALA LUMPUR', 'MY', 'MALAYSIA', 'http://www.bursamalaysia.com/');
INSERT INTO `freepay_banque` VALUES ('XKUWKWK1XXX', 'KUWAIT STOCK EXCHANGE', 'SAFAT', 'KW', 'KUWAIT', 'http://www.kuwaitse.com/');
INSERT INTO `freepay_banque` VALUES ('XKYOJPJ1XXX', 'KYOTO STOCK EXCHANGE', 'KYOTO', 'JP', 'JAPAN', 'http://www.ose.or.jp/');
INSERT INTO `freepay_banque` VALUES ('XLJUSI21XXX', 'LJUBLJANA STOCK EXCHANGE, INC.', 'LJUBLJANA', 'SI', 'SLOVENIA', 'http://www.ljse.si/');
INSERT INTO `freepay_banque` VALUES ('XLIFGB21XXX', 'LONDON INTERNATIONAL FINANCIAL FUTURES AND OPTIONS EXCHANGE', 'LONDON', 'GB', 'UNITED KINGDOM', 'http://www.euronext.com/');
INSERT INTO `freepay_banque` VALUES ('XLMEGB21XXX', 'LONDON METAL EXCHANGE', 'LONDON', 'GB', 'UNITED KINGDOM', 'http://www.lme.co.uk/');
INSERT INTO `freepay_banque` VALUES ('XLONGB2LXXX', 'LONDON STOCK EXCHANGE', 'LONDON', 'GB', 'UNITED KINGDOM', 'http://www.londonstockexchange.com/');
INSERT INTO `freepay_banque` VALUES ('XLUSZML1XXX', 'LUSAKA STOCK EXCHANGE', 'LUSAKA', 'ZM', 'ZAMBIA', '');
INSERT INTO `freepay_banque` VALUES ('XMAEMK21XXX', 'MACEDONIAN STOCK EXCHANGE', 'SKOPJE', 'MK', 'MACEDONIA', 'http://www.mse.org.mk/');
INSERT INTO `freepay_banque` VALUES ('XMDSIN51XXX', 'MADRAS STOCK EXCHANGE', 'CHENNAI (MADRAS)', 'IN', 'INDIA', '');
INSERT INTO `freepay_banque` VALUES ('XMSWMWM1XXX', 'MALAWI STOCK EXCHANGE', 'BLANTYRE', 'MW', 'MALAWI', 'http://www.mse.co.mw/');
INSERT INTO `freepay_banque` VALUES ('XLOFMYK1XXX', 'MALAYSIA DERIVATIVES EXCHANGE BHD', 'KUALA LUMPUR', 'MY', 'MALAYSIA', 'http://www.mdex.com.my/');
INSERT INTO `freepay_banque` VALUES ('XMALMTMTXXX', 'MALTA STOCK EXCHANGE', 'VALLETTA', 'MT', 'MALTA', 'http://www.borzamalta.com.mt/');
INSERT INTO `freepay_banque` VALUES ('XMDGMGM1XXX', 'MARCHE INTERBANCAIRE DES DEVISES M.I.D.', 'ANTANANARIVO', 'MG', 'MADAGASCAR', '');
INSERT INTO `freepay_banque` VALUES ('XMEVARB1XXX', 'MERCADO DE VALORES DE BUENOS AIRES S.A. - MERVAL', 'BUENOS AIRES', 'AR', 'ARGENTINA', 'http://www.merval.sba.com.ar/');
INSERT INTO `freepay_banque` VALUES ('XEMDMXM1XXX', 'MERCADO MEXICANO DE DERIVADOS', 'MEXICO', 'MX', 'MEXICO', 'http://www.mexder.com/');
INSERT INTO `freepay_banque` VALUES ('XMCEESB1XXX', 'MERCATO CONTINUO ESPANOL', 'BARCELONA', 'ES', 'SPAIN', '');
INSERT INTO `freepay_banque` VALUES ('XMIFITM1XXX', 'MERCATO ITALIANO FUTURES EXCHANGE', 'MILANO', 'IT', 'ITALY', '');
INSERT INTO `freepay_banque` VALUES ('XBAVESB1XXX', 'MERCHBOLSA AGENCIA DE VALORES, S.A.', 'BARCELONA', 'ES', 'SPAIN', '');
INSERT INTO `freepay_banque` VALUES ('XSRMES21XXX', 'MFAO, S.A.', 'JAEN', 'ES', 'SPAIN', 'http://www.mfao.es/');
INSERT INTO `freepay_banque` VALUES ('XAPIRU81XXX', 'MICEX FAR EAST', 'VLADIVOSTOK', 'RU', 'RUSSIAN FEDERATION', 'http://www.micex.com/');
INSERT INTO `freepay_banque` VALUES ('XMACUS41XXX', 'MID AMERICA COMMODITY EXCHANGE', 'CHICAGO,IL', 'US', 'UNITED STATES OF AMERICA', '');
INSERT INTO `freepay_banque` VALUES ('XMIDUS41XXX', 'MIDWEST STOCK EXCHANGE', 'CHICAGO,IL', 'US', 'UNITED STATES', '');
INSERT INTO `freepay_banque` VALUES ('XMGEUS41XXX', 'MINNEAPOLIS GRAIN EXCHANGE', 'MINNEAPOLIS,MN', 'US', 'UNITED STATES OF AMERICA', 'http://www.mgex.com/');
INSERT INTO `freepay_banque` VALUES ('XMRVESM1XXX', 'MOFEX : MEFF RENTA VARIABLE', 'MADRID', 'ES', 'SPAIN', 'http://www.meffrv.es/');
INSERT INTO `freepay_banque` VALUES ('XMOOCAM1XXX', 'MONTREAL EXCHANGE THE / BOURSE DE MONTREAL', 'MONTREAL', 'CA', 'CANADA', 'http://www.m-x.ca/');
INSERT INTO `freepay_banque` VALUES ('XMOOCAM1ODP', 'MONTREAL EXCHANGE THE / BOURSE DE MONTREAL (OPTIONS AND OTHER DERIVATIVE PRODUCTS)', 'MONTREAL', 'CA', 'CANADA', 'http://www.m-x.ca/');
INSERT INTO `freepay_banque` VALUES ('XMOSRUM1XXX', 'MOSCOW CENTRAL STOCK EXCHANGE', 'MOSCOW', 'RU', 'RUSSIA', 'http://www.mcse.ru/');
INSERT INTO `freepay_banque` VALUES ('XMICRUMMXXX', 'MOSCOW INTERBANK CURRENCY EXCHANGE (MICEX)', 'MOSCOW', 'RU', 'RUSSIA', 'http://www.micex.com/');
INSERT INTO `freepay_banque` VALUES ('AMTSNL2AXXX', 'MTS AMSTERDAM N.V.', 'AMSTERDAM', 'NL', 'THE NETHERLANDS', 'http://www.mtsamsterdam.com/');
INSERT INTO `freepay_banque` VALUES ('BMTSBEBBXXX', 'MTS ASSOCIATED MARKETS', 'BRUSSELS', 'BE', 'BELGIUM', 'http://www.mtsbelgium.com/');
INSERT INTO `freepay_banque` VALUES ('GMTSDEFFXXX', 'MTS DEUTSCHLAND AG', 'FRANKFURT AM MAIN', 'DE', 'GERMANY', 'http://www.mtsgermany.com/');
INSERT INTO `freepay_banque` VALUES ('FMTSFRPPXXX', 'MTS FRANCE SAS', 'PARIS', 'FR', 'FRANCE', 'http://www.mtsfrance.com/');
INSERT INTO `freepay_banque` VALUES ('PMTSPTPLXXX', 'MTS PORTUGAL SGMR, SA', 'LISBOA', 'PT', 'PORTUGAL', 'http://www.mtsportugal.com/');
INSERT INTO `freepay_banque` VALUES ('SMTSESMMXXX', 'MTS SPAIN, S.A.', 'MADRID', 'ES', 'SPAIN', 'http://www.mtsspain.com/');
INSERT INTO `freepay_banque` VALUES ('XBOMINB1XXX', 'MUMBAI STOCK EXCHANGE', 'MUMBAI', 'IN', 'INDIA', 'http://www.bseindia.com/');
INSERT INTO `freepay_banque` VALUES ('XMUSOMM1XXX', 'MUSCAT SECURITIES MARKET', 'MUSCAT', 'OM', 'OMAN', 'http://www.msm.gov.om/');
INSERT INTO `freepay_banque` VALUES ('XNKSJPJ1XXX', 'NAGOYA KOKUMOTSU SATOU TORIHIKIJO (GRAIN AND SUGAR EXCHANGE)', 'NAGOYA', 'JP', 'JAPAN', 'http://www.c-com.or.jp/');
INSERT INTO `freepay_banque` VALUES ('XNSTJPJ1XXX', 'NAGOYA SENI TORIHIKIJO (TEXTILE EXCHANGE)', 'NAGOYA', 'JP', 'JAPAN', '');
INSERT INTO `freepay_banque` VALUES ('XNGOJPJ1XXX', 'NAGOYA STOCK EXCHANGE', 'NAGOYA', 'JP', 'JAPAN', 'http://www.nse.or.jp/');
INSERT INTO `freepay_banque` VALUES ('XNAIKEN1XXX', 'NAIROBI STOCK EXCHANGE', 'NAIROBI', 'KE', 'KENYA', 'http://nse.co.ke/');
INSERT INTO `freepay_banque` VALUES ('XNAMNAN1XXX', 'NAMIBIAN STOCK EXCHANGE', 'WINDHOEK', 'NA', 'NAMIBIA', 'http://www.nsx.com.na/');
INSERT INTO `freepay_banque` VALUES ('XNASUS31XXX', 'NASDAQ', 'WASHINGTON,DC', 'US', 'UNITED STATES OF AMERICA', 'http://www.nasdaq.com/');
INSERT INTO `freepay_banque` VALUES ('XBREDE21XXX', 'NASDAQ DEUTSCHLAND AG', 'BREMEN', 'DE', 'GERMANY', 'http://www.berlinerboerse.de/');
INSERT INTO `freepay_banque` VALUES ('XNQLUS31XXX', 'NASDAQ LIFE MARKETS', 'NEW YORK', 'US', 'UNITED STATES OF AMERICA', 'http://www.nasdaq.com/');
INSERT INTO `freepay_banque` VALUES ('XNMSUS31XXX', 'NASDAQ/NMS (NATIONAL MARKET SYSTEM)', 'WASHINGTON,DC', 'US', 'UNITED STATES OF AMERICA', '');
INSERT INTO `freepay_banque` VALUES ('XNSEINB1XXX', 'NATIONAL STOCK EXCHANGE OF INDIA', 'MUMBAI', 'IN', 'INDIA', 'http://www.nseindia.com/');
INSERT INTO `freepay_banque` VALUES ('XLITLT21XXX', 'NATIONAL STOCK EXCHANGE OF LITHUANIA', 'VILNIUS', 'LT', 'LITHUANIA', 'http://www.lt.omxgroup.com/');
INSERT INTO `freepay_banque` VALUES ('XNYFUS31XXX', 'NEW YORK BOARD OF TRADE', 'NEW YORK,NY', 'US', 'UNITED STATES OF AMERICA', 'http://www.nybot.com/');
INSERT INTO `freepay_banque` VALUES ('XCSCUS31XXX', 'NEW YORK COCOA, COFFEE AND SUGAR EXCHANGE', 'NEW YORK,NY', 'US', 'UNITED STATES', '');
INSERT INTO `freepay_banque` VALUES ('XNYCUS31XXX', 'NEW YORK COTTON EXCHANGE', 'NEW YORK,NY', 'US', 'UNITED STATES', '');
INSERT INTO `freepay_banque` VALUES ('XNYMUS31XXX', 'NEW YORK MERCANTILE EXCHANGE', 'NEW YORK,NY', 'US', 'UNITED STATES OF AMERICA', 'http://www.nymex.com/');
INSERT INTO `freepay_banque` VALUES ('XNYSUS31XXX', 'NEW YORK STOCK EXCHANGE, INC.', 'NEW YORK,NY', 'US', 'UNITED STATES OF AMERICA', 'http://www.nyse.com/');
INSERT INTO `freepay_banque` VALUES ('XNEENZ21XXX', 'NEW ZEALAND FUTURES AND OPTIONS EXCHANGE', 'AUCKLAND', 'NZ', 'NEW ZEALAND', 'http://www.asx.com.au/');
INSERT INTO `freepay_banque` VALUES ('XNZENZ21XXX', 'NEW ZEALAND STOCK EXCHANGE', 'WELLINGTON', 'NZ', 'NEW ZEALAND', 'http://www.nzx.com/');
INSERT INTO `freepay_banque` VALUES ('XAUKNZ21XXX', 'NEW ZEALAND STOCK EXCHANGE - AUCKLAND', 'AUCKLAND', 'NZ', 'NEW ZEALAND', 'http://www.nzx.com/');
INSERT INTO `freepay_banque` VALUES ('XNEWATW1XXX', 'NEWEX', 'VIENNA', 'DE', 'GERMANY', 'http://www.newex.com/');
INSERT INTO `freepay_banque` VALUES ('XHANDE21XXX', 'NIEDERSAECHSISCHE BOERSE ZU HANNOVER', 'HANNOVER', 'DE', 'GERMANY', 'http://www.boersenag.de/');
INSERT INTO `freepay_banque` VALUES ('XNSANGL1XXX', 'NIGERIAN STOCK EXCHANGE,THE', 'LAGOS', 'NG', 'NIGERIA', 'http://www.nigerianstockexchange.com/');
INSERT INTO `freepay_banque` VALUES ('XNIIJPJ1XXX', 'NIIGATA STOCK EXCHANGE', 'NIIGATA', 'JP', 'JAPAN', '');
INSERT INTO `freepay_banque` VALUES ('NNCSRU21XXX', 'NIZHNY NOVGOROD CURRENCY AND STOCK EXCHANGE CLOSE JOINT STOCK COMPANY', 'NIZHNIY NOVGOROD', 'RU', 'RUSSIA', 'http://www.nnx.ru/');
INSERT INTO `freepay_banque` VALUES ('XODEUA21XXX', 'ODESSA COMMODITY EXCHANGE', 'ODESSA', 'UA', 'UKRAINE', '');
INSERT INTO `freepay_banque` VALUES ('XOTBATW1XXX', 'OESTERREICHISCHE TERMIN- UND OPTIONENBOERSE, CLEARING BANK AG', 'VIENNA', 'AT', 'AUSTRIA', '');
INSERT INTO `freepay_banque` VALUES ('XMLXGB21XXX', 'OMLX, THE LONDON SECURITIES AND DERIVATIVES EXCHANGE LIMITED', 'LONDON', 'GB', 'UNITED KINGDOM', '');
INSERT INTO `freepay_banque` VALUES ('XOCHUS41XXX', 'ONECHICAGO, LLC.', 'CHICAGO', 'US', 'UNITED STATES OF AMERICA', 'http://www.onechicago.com/');
INSERT INTO `freepay_banque` VALUES ('XAOMAU21XXX', 'OPTIONS CLEARING HOUSE PTY LIMITED', 'SYDNEY', 'AU', 'AUSTRALIA', '');
INSERT INTO `freepay_banque` VALUES ('XOSMJPJ1XXX', 'OSAKA MERCANTILE EXCHANGE', 'OSAKA', 'JP', 'JAPAN', '');
INSERT INTO `freepay_banque` VALUES ('XOSEJPJ1XXX', 'OSAKA SECURITIES EXCHANGE', 'OSAKA', 'JP', 'JAPAN', 'http://www.ose.or.jp/');
INSERT INTO `freepay_banque` VALUES ('XOSTJPJ1XXX', 'OSAKA SENI TORIHIKIJO (TEXTILE EXCHANGE)', 'OSAKA', 'JP', 'JAPAN', '');
INSERT INTO `freepay_banque` VALUES ('XOSLNOK1XXX', 'OSLO BORS', 'OLSO', 'NO', 'NORWAY', 'http://www.oslobors.no/');
INSERT INTO `freepay_banque` VALUES ('XOTCUS31XXX', 'OTC BULLETIN BOARD', 'WASHINGTON,DC', 'US', 'UNITED STATES OF AMERICA', 'http://www.otcbb.com/');
INSERT INTO `freepay_banque` VALUES ('XPSEUS61XXX', 'PACIFIC STOCK EXCHANGE INC.', 'SAN FRANCISCO,CA', 'US', 'UNITED STATES', '');
INSERT INTO `freepay_banque` VALUES ('XPAEPS21XXX', 'PALESTINE SECURITIES EXCHANGE', 'NABLUS', 'PS', 'PALESTINIAN TERRITORY, OCCUPIED', 'http://www.p-s-e.com/');
INSERT INTO `freepay_banque` VALUES ('XPBTUS31XXX', 'PHILADELPHIA BOARD OF TRADE', 'PHILADELPHIA,PA', 'US', 'UNITED STATES OF AMERICA', 'http://www.phlx.com/');
INSERT INTO `freepay_banque` VALUES ('XPHOUS31XXX', 'PHILADELPHIA OPTIONS EXCHANGE', 'PHILADELPHIA,PA', 'US', 'UNITED STATES OF AMERICA', 'http://www.phlx.com/');
INSERT INTO `freepay_banque` VALUES ('XPHLUS31XXX', 'PHILADELPHIA STOCK EXCHANGE', 'PHILADELPHIA,PA', 'US', 'UNITED STATES OF AMERICA', 'http://www.phlx.com/');
INSERT INTO `freepay_banque` VALUES ('XPHSPHM1XXX', 'PHILIPPINE STOCK EXCHANGE, INC.', 'PASIG-CITY', 'PH', 'PHILIPPINE', 'http://www.pse.org.ph/');
INSERT INTO `freepay_banque` VALUES ('XPORUS31XXX', 'PORTAL', 'WASHINGTON,DC', 'US', 'UNITED STATES OF AMERICA', 'http://www.nasdaqportalmarket.com/');
INSERT INTO `freepay_banque` VALUES ('XPRIUA21XXX', 'PRIDNEPROVSK COMMODITY EXCHANGE', 'DNIPROPETROVSK', 'UA', 'UKRAINE', '');
INSERT INTO `freepay_banque` VALUES ('XQUIECE1XXX', 'QUITO STOCK EXCHANGE', 'QUITO', 'EC', 'ECUADOR', 'http://www.ccbvq.com/');
INSERT INTO `freepay_banque` VALUES ('XRASROB1XXX', 'RASDAQ', 'BUCHAREST', 'RO', 'ROMANIA', 'http://www.bvb.ro/');
INSERT INTO `freepay_banque` VALUES ('XDUSDED1XXX', 'RHEINISCHE-WESTFALISCHE BOERSE ZU DÜSSELDORF', 'DUESSELDORF', 'DE', 'GERMANY', 'http://www.boerse-duesseldorf.de/');
INSERT INTO `freepay_banque` VALUES ('XRISLV21XXX', 'RIGA STOCK EXCHANGE,THE', 'RIGA', 'LV', 'LATVIA', 'http://www.lv.omxgroup.com/');
INSERT INTO `freepay_banque` VALUES ('XROVRU21XXX', 'ROSTOV CURRENCY AND STOCK EXCHANGE', 'ROSTOV', 'RU', 'RUSSIA', '');
INSERT INTO `freepay_banque` VALUES ('XRTRDEF1XXX', 'RTR (REUTERS-REALTIME-DATEN)', 'FRANKFURT AM MAIN', 'DE', 'GERMANY', '');
INSERT INTO `freepay_banque` VALUES ('XRUSRUM1XXX', 'RUSSIAN EXCHANGE, THE', 'MOSCOW', 'RU', 'RUSSIA', 'http://www.rts.ru/');
INSERT INTO `freepay_banque` VALUES ('XPICRU2PXXX', 'SAINT PETERSBURG CURRENCY EXCHANGE', 'SAINT-PETERSBURG', 'RU', 'RUSSIA', 'http://www.spcex.ru/');
INSERT INTO `freepay_banque` VALUES ('XSAMRU31XXX', 'SAMARA CURRENCY INTERBANK EXCHANGE', 'SAMARA', 'RU', 'RUSSIA', 'http://www.micex.com/');
INSERT INTO `freepay_banque` VALUES ('XSGOCLR1XXX', 'SANTIAGO STOCK EXCHANGE', 'SANTIAGO', 'CL', 'CHILE', 'http://www.bolsadesantiago.com/');
INSERT INTO `freepay_banque` VALUES ('XSAPJPJ1XXX', 'SAPPORO SECURITIES EXCHANGE', 'SAPPORO', 'JP', 'JAPAN', '');
INSERT INTO `freepay_banque` VALUES ('XSGECNC1XXX', 'SHANGHAI FUTURES EXCHANGE', 'SHANGHAI', 'CN', 'CHINA', 'http://www.shfe.com.cn/');
INSERT INTO `freepay_banque` VALUES ('XSHGCNS1XXX', 'SHANGHAI STOCK EXCHANGE', 'SHANGHAI', 'CN', 'CHINA', 'http://www.sse.com.cn/');
INSERT INTO `freepay_banque` VALUES ('XSMECNB1XXX', 'SHENZHEN MERCANTILE EXCHANGE', 'SHENZHEN', 'CN', 'CHINA', '');
INSERT INTO `freepay_banque` VALUES ('XSHECNB1XXX', 'SHENZHEN STOCK EXCHANGE', 'SHENZHEN', 'CN', 'CHINA', 'http://www.szse.cn/');
INSERT INTO `freepay_banque` VALUES ('XSICRU55XXX', 'SIBERIAN INTERBANK CURRENCY EXCHANGE', 'NOVOSIBIRSK', 'RU', 'RUSSIA', 'http://www.sice.ru/');
INSERT INTO `freepay_banque` VALUES ('XSIBRU51XXX', 'SIBERIAN STOCK EXCHANGE', 'NOVOSIBIRSK', 'RU', 'RUSSIA', '');
INSERT INTO `freepay_banque` VALUES ('XSCESGS1XXX', 'SINGAPORE COMMODITY EXCHANGE', 'SINGAPORE', 'SG', 'SINGAPORE', 'http://www.sicom.com.sg/');
INSERT INTO `freepay_banque` VALUES ('XSESSGS1XXX', 'SINGAPORE EXCHANGE', 'SINGAPORE', 'SG', 'SINGAPORE', 'http://www.ses.com.sg/');
INSERT INTO `freepay_banque` VALUES ('XSIMSGSGXXX', 'SINGAPORE EXCHANGE DERIVATIVES CLEARING LIMITED', 'SINGAPORE', 'SG', 'SINGAPORE', '');
INSERT INTO `freepay_banque` VALUES ('XBCNESBBXXX', 'SOCIEDAD RECTORA DE LA BOLSA DE VALORES DE BARCELONA S.A.', 'BARCELONA', 'ES', 'SPAIN', '');
INSERT INTO `freepay_banque` VALUES ('XBCNESBBSCL', 'SOCIEDAD RECTORA DE LA BOLSA DE VALORES DE BARCELONA S.A.', 'BARCELONA', 'ES', 'SPAIN', '');
INSERT INTO `freepay_banque` VALUES ('XBCNESBBGAR', 'SOCIEDAD RECTORA DE LA BOLSA DE VALORES DE BARCELONA S.A.', 'BARCELONA', 'ES', 'SPAIN', '');
INSERT INTO `freepay_banque` VALUES ('MTSCITRRPOL', 'SOCIETA PER IL MERCATO DEI TITOLI DI STATO SPA-MTS SPA', 'ROMA', 'IT', 'ITALY', 'http://www.mtsspa.it/');
INSERT INTO `freepay_banque` VALUES ('MTSCITRREUR', 'SOCIETA PER IL MERCATO DEI TITOLI DI STATO SPA-MTS SPA', 'ROMA', 'IT', 'ITALY', 'http://www.mtsspa.it/');
INSERT INTO `freepay_banque` VALUES ('MTSCITRRXXX', 'SOCIETA PER IL MERCATO DEI TITOLI DI STATO SPA-MTS SPA', 'ROMA', 'IT', 'ITALY', 'http://www.mtsspa.it/');
INSERT INTO `freepay_banque` VALUES ('XFMNFRP1XXX', 'SOCIETE DU NOUVEAU MARCHE', 'PARIS', 'FR', 'FRANCE', '');
INSERT INTO `freepay_banque` VALUES ('XSAFZAJ1XXX', 'SOUTH AFRICAN FUTURES EXCHANGE', 'JOHANNESBURG', 'ZA', 'SOUTH AFRICA', 'http://www.safex.co.za/');
INSERT INTO `freepay_banque` VALUES ('XSFAZAJ1XXX', 'SOUTH AFRICAN FUTURES EXCHANGE - AGRICULTURAL MARKET DIVISION', 'JOHANNESBURG', 'ZA', 'SOUTH AFRICA', 'http://www.safex.co.za/');
INSERT INTO `freepay_banque` VALUES ('XPETRU21XXX', 'ST PETERSBURG STOCK EXCHANGE', 'SAINT-PETERSBURG', 'RU', 'RUSSIA', 'http://www.spbex.ru/');
INSERT INTO `freepay_banque` VALUES ('XHKGHKHHXXX', 'STOCK EXCHANGE OF HONG KONG LTD, THE', 'HONG KONG', 'HK', 'HONG KONG', 'http://www.hkex.com.hk/');
INSERT INTO `freepay_banque` VALUES ('XHKGHKHHTRE', 'STOCK EXCHANGE OF HONG KONG LTD, THE', 'HONG KONG', 'HK', 'HONG KONG', 'http://www.hkex.com.hk/');
INSERT INTO `freepay_banque` VALUES ('XMAUMUM1XXX', 'STOCK EXCHANGE OF MAURITIUS LTD, THE', 'PORT LOUIS', 'MU', 'MAURITIUS', 'http://www.stockexchangeofmauritius.com/');
INSERT INTO `freepay_banque` VALUES ('XBKKTHB1XXX', 'STOCK EXCHANGE OF THAILAND', 'BANGKOK', 'TH', 'THAILAND', 'http://www.set.or.th/');
INSERT INTO `freepay_banque` VALUES ('XPRACZP1XXX', 'STOCK EXCHANGE PRAGUE CO. LTD, THE', 'PRAGUE', 'CZ', 'CZECH REPUBLIC', '');
INSERT INTO `freepay_banque` VALUES ('XSURIDJ1XXX', 'SURABAYA STOCK EXCHANGE', 'SURABAYA', 'ID', 'INDONESIA', 'http://www.bes.co.id/');
INSERT INTO `freepay_banque` VALUES ('XSWXCHZ1XXX', 'SWISS EXCHANGE', 'ZURICH', 'CH', 'SWITZERLAND', 'http://www.swx.com/');
INSERT INTO `freepay_banque` VALUES ('XSFEAU21XXX', 'SYDNEY FUTURES EXCHANGE LIMITED', 'SYDNEY', 'AU', 'AUSTRALIA', 'http://www.sfe.com.au/');
INSERT INTO `freepay_banque` VALUES ('XIMETWT1XXX', 'TAIWAN INTERNATIONAL MERCANTILE EXCHANGE', 'TAIPEI', 'TW', 'TAIWAN', '');
INSERT INTO `freepay_banque` VALUES ('XTAITWT1XXX', 'TAIWAN STOCK EXCHANGE', 'TAIPEI', 'TW', 'TAIWAN', 'http://www.tse.com.tw/');
INSERT INTO `freepay_banque` VALUES ('XTALEE21XXX', 'TALLINN STOCK EXCHANGE', 'TALLINN', 'EE', 'ESTONIA', 'http://www.ee.omxgroup.com/');
INSERT INTO `freepay_banque` VALUES ('XTEHIRT1XXX', 'TEHERAN STOCK EXCHANGE', 'TEHERAN', 'IR', 'IRAN', 'http://www.tse.ir/');
INSERT INTO `freepay_banque` VALUES ('XTAEILITXXX', 'TEL-AVIV STOCK EXCHANGE CLEARING HOUSE', 'TEL AVIV', 'IL', 'ISRAEL', 'http://www.tase.co.il/');
INSERT INTO `freepay_banque` VALUES ('XCUEUZ21XXX', 'THE UZBEKISTAN REPUBLICAN CURRENCY EXCHANGE', 'TASHKENT', 'UZ', 'UZBEKISTAN', '');
INSERT INTO `freepay_banque` VALUES ('XTFFJPJ1XXX', 'TOKYO INTERNATIONAL FINANCIAL FUTURES EXCHANGE, THE', 'TOKYO', 'JP', 'JAPAN', 'http://www.tfx.co.jp/');
INSERT INTO `freepay_banque` VALUES ('XTKTJPJ1XXX', 'TOKYO KOGYOIN TORIHIKIJO (COMMODITY EXCHANGE)', 'TOKYO', 'JP', 'JAPAN', '');
INSERT INTO `freepay_banque` VALUES ('XTKOJPJ1XXX', 'TOKYO KOKUMOTSU SHOHIN TORIHIKIJO (GRAIN EXCHANGE)', 'TOKYO', 'JP', 'JAPAN', '');
INSERT INTO `freepay_banque` VALUES ('XTKSJPJ1XXX', 'TOKYO STOCK EXCHANGE, INC', 'TOKYO', 'JP', 'JAPAN', 'http://www.tse.or.jp/');
INSERT INTO `freepay_banque` VALUES ('XTFECAT1XXX', 'TORONTO FUTURES EXCHANGE', 'TORONTO', 'CA', 'CANADA', '');
INSERT INTO `freepay_banque` VALUES ('XTOECAT1XXX', 'TORONTO OPTIONS EXCHANGE', 'TORONTO', 'CA', 'CANADA', '');
INSERT INTO `freepay_banque` VALUES ('XTSECAT1XXX', 'TORONTO STOCK EXCHANGE', 'TORONTO', 'CA', 'CANADA', 'http://www.tsx.com/');
INSERT INTO `freepay_banque` VALUES ('XTKAJPJ1XXX', 'TOYOHASHI KANKEN TORIHIKIJO (DRIED COCOON EXCHANGE)', 'AICHI', 'JP', 'JAPAN', '');
INSERT INTO `freepay_banque` VALUES ('XTFNGB21XXX', 'TRADEPOINT FINANCIAL NETWORKS PLC', 'LONDON', 'GB', 'UNITED KINGDOM', '');
INSERT INTO `freepay_banque` VALUES ('TREUGB21XXX', 'TRADEWEB EUROPE LIMITED', 'LONDON', 'GB', 'UNITED KINGDOM', '');
INSERT INTO `freepay_banque` VALUES ('XTRNTTP1XXX', 'TRINIDAD AND TOBAGO STOCK EXCHANGE', 'PORT OF SPAIN', 'TT', 'TRINIDAD AND TOBAGO', 'http://stockex.co.tt/');
INSERT INTO `freepay_banque` VALUES ('XUGAUGK1XXX', 'UGANDA SECURITIES EXCHANGE', 'KAMPALA', 'UG', 'UGANDA', 'http://www.use.or.ug/');
INSERT INTO `freepay_banque` VALUES ('XUKCUAU1XXX', 'UKRAINIAN COMMODITY EXCHANGE', 'KIEV', 'UA', 'UKRAINE', '');
INSERT INTO `freepay_banque` VALUES ('XUKRUAU1XXX', 'UKRAINIAN UNIVERSAL COMMODITY EXCHANGE', 'KIEV', 'UA', 'UKRAINE', 'http://www.minagro.gov.ua/');
INSERT INTO `freepay_banque` VALUES ('XUNIUZ21XXX', 'UNIVERSAL BROKER''S EXCHANGE', 'TASHKENT', 'UZ', 'UZBEKISTAN', '');
INSERT INTO `freepay_banque` VALUES ('XCETUZ21XXX', 'UNIVERSAL COMMODITY EXCHANGE', 'TASHKENT', 'UZ', 'UZBEKISTAN', '');
INSERT INTO `freepay_banque` VALUES ('URCERU41XXX', 'URALS REGIONAL CURRENCY EXCHANGE', 'EKATERINBURG', 'RU', 'RUSSIA', 'http://www.urvb.ru/');
INSERT INTO `freepay_banque` VALUES ('XEUSUS41XXX', 'US FUTURES EXCHANGE', 'CHICAGO,IL', 'US', 'UNITED STATES OF AMERICA', 'http://www.usfe.com/');
INSERT INTO `freepay_banque` VALUES ('XSTEUZ21XXX', 'UZBEKISTAN STOCK EXCHANGE', 'TASHKENT', 'UZ', 'UZBEKISTAN', '');
INSERT INTO `freepay_banque` VALUES ('XVSECA81XXX', 'VANCOUVER STOCK EXCHANGE', 'VANCOUVER', 'CA', 'CANADA', '');
INSERT INTO `freepay_banque` VALUES ('XVTXGB21XXX', 'VIRT-X', 'LONDON', 'GB', 'UNITED KINGDOM', 'http://www.virt-x.com/');
INSERT INTO `freepay_banque` VALUES ('XVLARU81XXX', 'VLADIVOSTOK (RUSSIA) STOCK EXCHANGE', 'VLADIVOSTOK', 'RU', 'RUSSIA', '');
INSERT INTO `freepay_banque` VALUES ('XHCEDE21XXX', 'WARENTERMINBOERSE HANNOVER', 'HANNOVER', 'DE', 'GERMANY', 'http://www.wtb-hannover.de/');
INSERT INTO `freepay_banque` VALUES ('XWARPLP1XXX', 'WARSAW STOCK EXCHANGE', 'WARSAW', 'PL', 'POLAND', 'http://www.gpw.com.pl/');
INSERT INTO `freepay_banque` VALUES ('XWBOATW1XXX', 'WIENER BOERSE AG', 'VIENNA', 'AT', 'AUSTRIA', 'http://www.wienerborse.at/');
INSERT INTO `freepay_banque` VALUES ('XWCECA41XXX', 'WINNIPEG COMMODITY EXCHANGE, THE', 'WINNIPEG', 'CA', 'CANADA', 'http://www.wce.ca/');
INSERT INTO `freepay_banque` VALUES ('XYKTJPJ1XXX', 'YOKOHAMA COMMODITY EXCHANGE', 'YOKOHAMA', 'JP', 'JAPAN', '');
INSERT INTO `freepay_banque` VALUES ('XZAGHR21XXX', 'ZAGREB STOCK EXCHANGE, THE', 'ZAGREB', 'HR', 'CROATIA', 'http://www.zse.hr/');
INSERT INTO `freepay_banque` VALUES ('XZIMZWH1XXX', 'ZIMBABWE STOCK EXCHANGE', 'HARARE', 'ZW', 'ZIMBABWE', 'http://www.zse.co.zw/');
INSERT INTO `freepay_banque` VALUES ('XXXXFRPAXXX', 'BANQUE LIBRE FREEPAY', 'PARIS', 'FR', 'FRANCE', 'http://freepay.fr/');
INSERT INTO `freepay_banque` VALUES ('XXXXFRPA001', 'BANQUE LIBRE TUXFAMILY', 'PARIS', 'FR', 'FRANCE', 'http://freepay.tuxfamily.org/');
INSERT INTO `freepay_banque` VALUES ('XXXXGBLO002', 'FREE BANKING SOURCEFORGE', 'LONDON', 'GB', 'UNITED KINGDOM', 'http://freepay.sourceforge.net/');

-- --------------------------------------------------------

-- 
-- Structure de la table `freepay_carte_bancaire`
-- 

CREATE TABLE `freepay_carte_bancaire` (
  `numcb` bigint(19) NOT NULL default '0',
  `typecb` char(30) default NULL,
  `moisexpcb` int(2) default NULL,
  `anneeexpcb` int(4) default NULL,
  `cryvis` int(4) default NULL,
  `iban` char(34) NOT NULL default '',
  `mailcli` char(40) NOT NULL default '',
  PRIMARY KEY  (`numcb`),
  KEY `fk_cbiban` (`iban`),
  KEY `fk_mciban` (`mailcli`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Contenu de la table `freepay_carte_bancaire`
-- 

INSERT INTO `freepay_carte_bancaire` VALUES (5678256256767656, 'GNU Free Card', 1, 2007, 0, 'FR37987635687564673Y5667936', 'test2@freepay.fr');
INSERT INTO `freepay_carte_bancaire` VALUES (5678939372800150, 'GNU Free Card', 1, 2007, 0, 'FR26387654564522285449Y5663', 'test@freepay.fr');

-- --------------------------------------------------------

-- 
-- Structure de la table `freepay_cc_type`
-- 

CREATE TABLE `freepay_cc_type` (
  `ccprefix` int(6) NOT NULL default '0',
  `cctype` char(50) NOT NULL default '',
  `ccurl` char(100) default NULL,
  `cclong` int(2) NOT NULL default '0',
  PRIMARY KEY  (`ccprefix`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Contenu de la table `freepay_cc_type`
-- 

INSERT INTO `freepay_cc_type` VALUES (34, 'American Express', 'http://www.americanexpress.com/', 15);
INSERT INTO `freepay_cc_type` VALUES (37, 'American Express', 'http://www.americanexpress.com/', 15);
INSERT INTO `freepay_cc_type` VALUES (560221, 'Bankcard', '', 16);
INSERT INTO `freepay_cc_type` VALUES (560222, 'Bankcard', '', 16);
INSERT INTO `freepay_cc_type` VALUES (560223, 'Bankcard', '', 16);
INSERT INTO `freepay_cc_type` VALUES (560224, 'Bankcard', '', 16);
INSERT INTO `freepay_cc_type` VALUES (560225, 'Bankcard', '', 16);
INSERT INTO `freepay_cc_type` VALUES (5610, 'Bankcard', '', 16);
INSERT INTO `freepay_cc_type` VALUES (6221, 'China Union Pay', 'http://www.chinaunionpay.com/', 16);
INSERT INTO `freepay_cc_type` VALUES (6222, 'China Union Pay', 'http://www.chinaunionpay.com/', 16);
INSERT INTO `freepay_cc_type` VALUES (6223, 'China Union Pay', 'http://www.chinaunionpay.com/', 16);
INSERT INTO `freepay_cc_type` VALUES (6224, 'China Union Pay', 'http://www.chinaunionpay.com/', 16);
INSERT INTO `freepay_cc_type` VALUES (6225, 'China Union Pay', 'http://www.chinaunionpay.com/', 16);
INSERT INTO `freepay_cc_type` VALUES (6226, 'China Union Pay', 'http://www.chinaunionpay.com/', 16);
INSERT INTO `freepay_cc_type` VALUES (6227, 'China Union Pay', 'http://www.chinaunionpay.com/', 16);
INSERT INTO `freepay_cc_type` VALUES (6228, 'China Union Pay', 'http://www.chinaunionpay.com/', 16);
INSERT INTO `freepay_cc_type` VALUES (6229, 'China Union Pay', 'http://www.chinaunionpay.com/', 16);
INSERT INTO `freepay_cc_type` VALUES (300, 'Diners Club Carte Blanche', 'http://www.dinersclub.com/', 14);
INSERT INTO `freepay_cc_type` VALUES (301, 'Diners Club Carte Blanche', 'http://www.dinersclub.com/', 14);
INSERT INTO `freepay_cc_type` VALUES (302, 'Diners Club Carte Blanche', 'http://www.dinersclub.com/', 14);
INSERT INTO `freepay_cc_type` VALUES (303, 'Diners Club Carte Blanche', 'http://www.dinersclub.com/', 14);
INSERT INTO `freepay_cc_type` VALUES (304, 'Diners Club Carte Blanche', 'http://www.dinersclub.com/', 14);
INSERT INTO `freepay_cc_type` VALUES (305, 'Diners Club Carte Blanche', 'http://www.dinersclub.com/', 14);
INSERT INTO `freepay_cc_type` VALUES (2014, 'Diners Club enRoute', 'http://www.dinersclub.com/', 15);
INSERT INTO `freepay_cc_type` VALUES (2149, 'Diners Club enRoute', 'http://www.dinersclub.com/', 15);
INSERT INTO `freepay_cc_type` VALUES (36, 'Diners Club International', 'http://www.dinersclub.com/', 14);
INSERT INTO `freepay_cc_type` VALUES (38, 'Diners Club International', 'http://www.dinersclub.com/', 14);
INSERT INTO `freepay_cc_type` VALUES (6011, 'Discover Card', 'http://www.discovercard.com/', 16);
INSERT INTO `freepay_cc_type` VALUES (65, 'Discover Card', 'http://www.discovercard.com/', 16);
INSERT INTO `freepay_cc_type` VALUES (5678, 'GNU Free Card', 'http://freepay.fr/', 16);
INSERT INTO `freepay_cc_type` VALUES (1800, 'Japan Credit Bureau (JCB)', 'http://www.jcbinternational.com/', 15);
INSERT INTO `freepay_cc_type` VALUES (2100, 'Japan Credit Bureau (JCB)', 'http://www.jcbinternational.com/', 15);
INSERT INTO `freepay_cc_type` VALUES (2131, 'Japan Credit Bureau (JCB)', 'http://www.jcbinternational.com/', 15);
INSERT INTO `freepay_cc_type` VALUES (3088, 'Japan Credit Bureau (JCB)', 'http://www.jcbinternational.com/', 16);
INSERT INTO `freepay_cc_type` VALUES (3096, 'Japan Credit Bureau (JCB)', 'http://www.jcbinternational.com/', 16);
INSERT INTO `freepay_cc_type` VALUES (3112, 'Japan Credit Bureau (JCB)', 'http://www.jcbinternational.com/', 16);
INSERT INTO `freepay_cc_type` VALUES (3158, 'Japan Credit Bureau (JCB)', 'http://www.jcbinternational.com/', 16);
INSERT INTO `freepay_cc_type` VALUES (3337, 'Japan Credit Bureau (JCB)', 'http://www.jcbinternational.com/', 16);
INSERT INTO `freepay_cc_type` VALUES (35, 'Japan Credit Bureau (JCB)', 'http://www.jcbinternational.com/', 16);
INSERT INTO `freepay_cc_type` VALUES (5020, 'Maestro (debit card)', 'http://www.maestrocard.com/', 16);
INSERT INTO `freepay_cc_type` VALUES (5038, 'Maestro (debit card)', 'http://www.maestrocard.com/', 16);
INSERT INTO `freepay_cc_type` VALUES (6304, 'Maestro (debit card)', 'http://www.maestrocard.com/', 16);
INSERT INTO `freepay_cc_type` VALUES (51, 'MasterCard', 'http://www.mastercard.com/', 16);
INSERT INTO `freepay_cc_type` VALUES (52, 'MasterCard', 'http://www.mastercard.com/', 16);
INSERT INTO `freepay_cc_type` VALUES (53, 'MasterCard', 'http://www.mastercard.com/', 16);
INSERT INTO `freepay_cc_type` VALUES (54, 'MasterCard', 'http://www.mastercard.com/', 16);
INSERT INTO `freepay_cc_type` VALUES (55, 'MasterCard', 'http://www.mastercard.com/', 16);
INSERT INTO `freepay_cc_type` VALUES (6334, 'Solo (debit card)', 'http://www.solocard.co.uk/', 16);
INSERT INTO `freepay_cc_type` VALUES (6767, 'Solo (debit card)', 'http://www.solocard.co.uk/', 16);
INSERT INTO `freepay_cc_type` VALUES (4903, 'Switch (debit card)', 'http://www.switch.co.uk/', 16);
INSERT INTO `freepay_cc_type` VALUES (4905, 'Switch (debit card)', 'http://www.switch.co.uk/', 16);
INSERT INTO `freepay_cc_type` VALUES (4911, 'Switch (debit card)', 'http://www.switch.co.uk/', 16);
INSERT INTO `freepay_cc_type` VALUES (4936, 'Switch (debit card)', 'http://www.switch.co.uk/', 16);
INSERT INTO `freepay_cc_type` VALUES (564182, 'Switch (debit card)', 'http://www.switch.co.uk/', 16);
INSERT INTO `freepay_cc_type` VALUES (633110, 'Switch (debit card)', 'http://www.switch.co.uk/', 16);
INSERT INTO `freepay_cc_type` VALUES (6333, 'Switch (debit card)', 'http://www.switch.co.uk/', 16);
INSERT INTO `freepay_cc_type` VALUES (402299, 'Visa', 'http://www.visa.com/', 13);
INSERT INTO `freepay_cc_type` VALUES (4, 'Visa', 'http://www.visa.com/', 16);
INSERT INTO `freepay_cc_type` VALUES (402400, 'Visa', 'http://www.visa.com/', 16);
INSERT INTO `freepay_cc_type` VALUES (406807, 'Visa', 'http://www.visa.com/', 16);
INSERT INTO `freepay_cc_type` VALUES (42, 'Visa', 'http://www.visa.com/', 16);
INSERT INTO `freepay_cc_type` VALUES (43, 'Visa', 'http://www.visa.com/', 16);
INSERT INTO `freepay_cc_type` VALUES (448541, 'Visa', 'http://www.visa.com/', 16);
INSERT INTO `freepay_cc_type` VALUES (448544, 'Visa', 'http://www.visa.com/', 16);
INSERT INTO `freepay_cc_type` VALUES (4532, 'Visa', 'http://www.visa.com/', 16);
INSERT INTO `freepay_cc_type` VALUES (4539, 'Visa', 'http://www.visa.com/', 16);
INSERT INTO `freepay_cc_type` VALUES (4556, 'Visa', 'http://www.visa.com/', 16);
INSERT INTO `freepay_cc_type` VALUES (46, 'Visa', 'http://www.visa.com/', 16);
INSERT INTO `freepay_cc_type` VALUES (4716, 'Visa', 'http://www.visa.com/', 16);
INSERT INTO `freepay_cc_type` VALUES (48, 'Visa', 'http://www.visa.com/', 16);
INSERT INTO `freepay_cc_type` VALUES (4916, 'Visa', 'http://www.visa.com/', 16);
INSERT INTO `freepay_cc_type` VALUES (4929, 'Visa', 'http://www.visa.com/', 16);
INSERT INTO `freepay_cc_type` VALUES (4913, 'Visa Electron', 'http://www.visa.com/', 16);
INSERT INTO `freepay_cc_type` VALUES (4917, 'Visa Electron', 'http://www.visa.com/', 16);
INSERT INTO `freepay_cc_type` VALUES (417500, 'Visa Electron', 'http://www.visa.com/', 16);
INSERT INTO `freepay_cc_type` VALUES (8699, 'Voyager', '', 15);

-- --------------------------------------------------------

-- 
-- Structure de la table `freepay_client`
-- 

CREATE TABLE `freepay_client` (
  `mailcli` char(40) NOT NULL default '',
  `mdpcli` char(40) NOT NULL default '',
  `nomcli` char(20) default NULL,
  `prenomcli` char(20) default NULL,
  `adresscli` char(20) default NULL,
  `cpcli` char(5) default NULL,
  `villecli` char(20) default NULL,
  `payscli` char(2) default NULL,
  `telcli` char(10) default NULL,
  `montantcompte` decimal(30,2) default NULL,
  `datecreationcompte` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`mailcli`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Contenu de la table `freepay_client`
-- 

INSERT INTO `freepay_client` VALUES ('freebanking@freepay.fr', '0cc175b9c0f1b6a831c399e269772661', 'admin', '', '', '', '', 'FR', '', 100.00, '2006-09-06 12:12:12');
INSERT INTO `freepay_client` VALUES ('test@freepay.fr', '0cc175b9c0f1b6a831c399e269772661', 'test', 'test', 'test', '75000', 'Paris', 'FR', '', 1000.00, '2006-09-14 12:12:12');
INSERT INTO `freepay_client` VALUES ('test2@freepay.fr', '0cc175b9c0f1b6a831c399e269772661', 'test', 'test', 'test', '75000', 'Paris', 'FR', '', 1000.00, '2006-09-14 12:12:12');
INSERT INTO `freepay_client` VALUES ('anonyme@freepay.fr', '0cc175b9c0f1b6a831c399e269772661', '', '', '', '', '', 'FR', '', 0.00, '2007-02-05 12:12:12');
INSERT INTO `freepay_client` VALUES ('shop@freepay.fr', '0cc175b9c0f1b6a831c399e269772661', '', '', '', '', '', 'FR', '', 0.00, '2007-03-05 12:12:12');

-- --------------------------------------------------------

-- 
-- Structure de la table `freepay_client_transferer`
-- 

CREATE TABLE `freepay_client_transferer` (
  `datet` datetime NOT NULL default '0000-00-00 00:00:00',
  `mailcli` char(40) NOT NULL default '',
  `mailcli2` char(40) NOT NULL default '',
  `valeurtrclient` decimal(30,2) default NULL,
  PRIMARY KEY  (`datet`,`mailcli`,`mailcli2`),
  KEY `fk_tcomc` (`mailcli`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Contenu de la table `freepay_client_transferer`
-- 

INSERT INTO `freepay_client_transferer` VALUES ('2006-09-07 12:24:23', 'test@freepay.fr', 'test2@freepay.fr', 0.01);
INSERT INTO `freepay_client_transferer` VALUES ('2006-09-08 13:25:24', 'test@freepay.fr', 'test2@freepay.fr', 12.24);
INSERT INTO `freepay_client_transferer` VALUES ('2006-09-09 14:26:25', 'test@freepay.fr', 'test2@freepay.fr', 23.45);
INSERT INTO `freepay_client_transferer` VALUES ('2006-09-10 15:27:26', 'test@freepay.fr', 'test2@freepay.fr', 56.78);
INSERT INTO `freepay_client_transferer` VALUES ('2006-09-11 16:28:27', 'test@freepay.fr', 'test2@freepay.fr', 123.45);
INSERT INTO `freepay_client_transferer` VALUES ('2006-09-12 17:29:28', 'test@freepay.fr', 'test2@freepay.fr', 589.01);
INSERT INTO `freepay_client_transferer` VALUES ('2006-09-07 14:24:23', 'test2@freepay.fr', 'test@freepay.fr', 0.01);
INSERT INTO `freepay_client_transferer` VALUES ('2006-09-08 15:25:24', 'test2@freepay.fr', 'test@freepay.fr', 12.24);
INSERT INTO `freepay_client_transferer` VALUES ('2006-09-09 16:26:25', 'test2@freepay.fr', 'test@freepay.fr', 23.45);
INSERT INTO `freepay_client_transferer` VALUES ('2006-09-10 17:27:26', 'test2@freepay.fr', 'test@freepay.fr', 56.78);
INSERT INTO `freepay_client_transferer` VALUES ('2006-09-11 18:28:27', 'test2@freepay.fr', 'test@freepay.fr', 123.45);
INSERT INTO `freepay_client_transferer` VALUES ('2006-09-12 19:29:28', 'test2@freepay.fr', 'test@freepay.fr', 589.01);

-- --------------------------------------------------------

-- 
-- Structure de la table `freepay_devises`
-- 

CREATE TABLE `freepay_devises` (
  `codenumdev` char(3) NOT NULL default '',
  `codenomdev` char(3) NOT NULL default '',
  `nomdev` char(50) NOT NULL default '',
  `urldev` char(100) NOT NULL default '',
  PRIMARY KEY  (`codenumdev`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Contenu de la table `freepay_devises`
-- 

INSERT INTO `freepay_devises` VALUES ('008', 'ALL', 'Lek', 'http://fr.wikipedia.org/wiki/Lek_albanais');
INSERT INTO `freepay_devises` VALUES ('012', 'DZD', 'Dinar algérien', 'http://fr.wikipedia.org/wiki/Dinar_alg%C3%A9rien');
INSERT INTO `freepay_devises` VALUES ('032', 'ARS', 'Peso argentin', 'http://fr.wikipedia.org/wiki/Peso_argentin');
INSERT INTO `freepay_devises` VALUES ('036', 'AUD', 'Dollar australien', 'http://fr.wikipedia.org/wiki/Dollar_australien');
INSERT INTO `freepay_devises` VALUES ('044', 'BSD', 'Dollar des Bahamas', '');
INSERT INTO `freepay_devises` VALUES ('048', 'BHD', 'Dinar de Bahreïn', '');
INSERT INTO `freepay_devises` VALUES ('050', 'BDT', 'Taka', 'http://fr.wikipedia.org/wiki/Taka');
INSERT INTO `freepay_devises` VALUES ('051', 'AMD', 'Dram arménien', 'http://fr.wikipedia.org/wiki/Dram_%28monnaie%29');
INSERT INTO `freepay_devises` VALUES ('052', 'BBD', 'Dollar de Barbade', '');
INSERT INTO `freepay_devises` VALUES ('060', 'BMD', 'Dollar des Bermudes', '');
INSERT INTO `freepay_devises` VALUES ('064', 'BTN', 'Ngultrum', 'http://fr.wikipedia.org/wiki/Ngultrum');
INSERT INTO `freepay_devises` VALUES ('068', 'BOB', 'Boliviano', 'http://fr.wikipedia.org/wiki/Boliviano');
INSERT INTO `freepay_devises` VALUES ('072', 'BWP', 'Pula', 'http://fr.wikipedia.org/wiki/Pula_%28monnaie%29');
INSERT INTO `freepay_devises` VALUES ('084', 'BZD', 'Dollar de Belize', '');
INSERT INTO `freepay_devises` VALUES ('090', 'SBD', 'Dollar de Salomon', 'http://fr.wikipedia.org/wiki/Dollar_des_%C3%AEles_Salomon');
INSERT INTO `freepay_devises` VALUES ('096', 'BND', 'Dollar de Brunei', '');
INSERT INTO `freepay_devises` VALUES ('104', 'MMK', 'Kyat', 'http://fr.wikipedia.org/wiki/Kyat');
INSERT INTO `freepay_devises` VALUES ('108', 'BIF', 'Franc du Burundi', 'http://fr.wikipedia.org/wiki/Franc_burundais');
INSERT INTO `freepay_devises` VALUES ('116', 'KHR', 'Riel', 'http://fr.wikipedia.org/wiki/Riel');
INSERT INTO `freepay_devises` VALUES ('124', 'CAD', 'Dollar canadien', 'http://fr.wikipedia.org/wiki/Dollar_canadien');
INSERT INTO `freepay_devises` VALUES ('132', 'CVE', 'Escudo du Cap-Vert', 'http://fr.wikipedia.org/wiki/Escudo_cap-verdien');
INSERT INTO `freepay_devises` VALUES ('136', 'KYD', 'Dollar des Iles Caïmanes', '');
INSERT INTO `freepay_devises` VALUES ('144', 'LKR', 'Roupie srilankaise', 'http://fr.wikipedia.org/wiki/Roupie_srilankaise');
INSERT INTO `freepay_devises` VALUES ('152', 'CLP', 'Peso chilien', 'http://fr.wikipedia.org/wiki/Peso_chilien');
INSERT INTO `freepay_devises` VALUES ('156', 'CNY', 'Yuan', 'http://fr.wikipedia.org/wiki/Yuan');
INSERT INTO `freepay_devises` VALUES ('170', 'COP', 'Peso colombien', 'http://fr.wikipedia.org/wiki/Peso_colombien');
INSERT INTO `freepay_devises` VALUES ('174', 'KMF', 'Franc des Comores', 'http://fr.wikipedia.org/wiki/Franc_comorien');
INSERT INTO `freepay_devises` VALUES ('188', 'CRC', 'Colon de Costa Rica', 'http://fr.wikipedia.org/wiki/Colon_costaricain');
INSERT INTO `freepay_devises` VALUES ('191', 'HRK', 'Kuna', 'http://fr.wikipedia.org/wiki/Kuna_%28monnaie%29');
INSERT INTO `freepay_devises` VALUES ('192', 'CUP', 'Peso cubain', 'http://fr.wikipedia.org/wiki/Peso_cubain');
INSERT INTO `freepay_devises` VALUES ('196', 'CYP', 'Livre cypriote', 'http://fr.wikipedia.org/wiki/Livre_chypriote');
INSERT INTO `freepay_devises` VALUES ('203', 'CZK', 'Couronne tchèque', 'http://fr.wikipedia.org/wiki/Couronne_tch%C3%A8que');
INSERT INTO `freepay_devises` VALUES ('208', 'DKK', 'Couronne danoise', 'http://fr.wikipedia.org/wiki/Couronne_danoise');
INSERT INTO `freepay_devises` VALUES ('214', 'DOP', 'Peso dominicain', 'http://fr.wikipedia.org/wiki/Peso_dominicain');
INSERT INTO `freepay_devises` VALUES ('222', 'SVC', 'Colon du El Salvador', '');
INSERT INTO `freepay_devises` VALUES ('230', 'ETB', 'Birr éthiopien', 'http://fr.wikipedia.org/wiki/Birr');
INSERT INTO `freepay_devises` VALUES ('232', 'ERN', 'Nakfa', 'http://fr.wikipedia.org/wiki/Nakfa');
INSERT INTO `freepay_devises` VALUES ('233', 'EEK', 'Couronne estonienne', 'http://fr.wikipedia.org/wiki/Couronne_estonienne');
INSERT INTO `freepay_devises` VALUES ('238', 'FKP', 'Livre de Falkland', '');
INSERT INTO `freepay_devises` VALUES ('242', 'FJD', 'Dollar de Fidji', 'http://fr.wikipedia.org/wiki/Dollar_fidjien');
INSERT INTO `freepay_devises` VALUES ('262', 'DJF', 'Franc de Djibouti', 'http://fr.wikipedia.org/wiki/Franc_Djibouti');
INSERT INTO `freepay_devises` VALUES ('270', 'GMD', 'Dalasi', 'http://fr.wikipedia.org/wiki/Dalasi');
INSERT INTO `freepay_devises` VALUES ('288', 'GHS', 'Cedi', 'http://fr.wikipedia.org/wiki/Cedi');
INSERT INTO `freepay_devises` VALUES ('292', 'GIP', 'Livre de Gibraltar', 'http://fr.wikipedia.org/wiki/Livre_de_Gibraltar');
INSERT INTO `freepay_devises` VALUES ('320', 'GTQ', 'Quetzal', 'http://fr.wikipedia.org/wiki/Quetzal_guat%C3%A9malt%C3%A8que');
INSERT INTO `freepay_devises` VALUES ('324', 'GNF', 'Franc guinéen', 'http://fr.wikipedia.org/wiki/Franc_guin%C3%A9en');
INSERT INTO `freepay_devises` VALUES ('328', 'GYD', 'Dollar de Guyane', '');
INSERT INTO `freepay_devises` VALUES ('332', 'HTG', 'Gourde', 'http://fr.wikipedia.org/wiki/Gourde_ha%C3%AFtienne');
INSERT INTO `freepay_devises` VALUES ('340', 'HNL', 'Lempira', 'http://fr.wikipedia.org/wiki/Lempira_hondurien');
INSERT INTO `freepay_devises` VALUES ('344', 'HKD', 'Dollar de Hong-Kong', 'http://fr.wikipedia.org/wiki/Dollar_de_Hong_Kong');
INSERT INTO `freepay_devises` VALUES ('348', 'HUF', 'Forint', 'http://fr.wikipedia.org/wiki/Forint_hongrois');
INSERT INTO `freepay_devises` VALUES ('352', 'ISK', 'Couronne islandaise', 'http://fr.wikipedia.org/wiki/Couronne_islandaise');
INSERT INTO `freepay_devises` VALUES ('356', 'INR', 'Roupie indienne', 'http://fr.wikipedia.org/wiki/Roupie_indienne');
INSERT INTO `freepay_devises` VALUES ('360', 'IDR', 'Rupiah', 'http://fr.wikipedia.org/wiki/Roupie_indon%C3%A9sienne');
INSERT INTO `freepay_devises` VALUES ('364', 'IRR', 'Rial iranien', 'http://fr.wikipedia.org/wiki/Rial_iranien');
INSERT INTO `freepay_devises` VALUES ('368', 'IQD', 'Dinar iraquien', 'http://fr.wikipedia.org/wiki/Dinar_irakien');
INSERT INTO `freepay_devises` VALUES ('376', 'ILS', 'Nouveau israëli sheqel', 'http://fr.wikipedia.org/wiki/Shekel');
INSERT INTO `freepay_devises` VALUES ('388', 'JMD', 'Dollar jamaïcain', 'http://fr.wikipedia.org/wiki/Dollar_jama%C3%AFcain');
INSERT INTO `freepay_devises` VALUES ('392', 'JPY', 'Yen', 'http://fr.wikipedia.org/wiki/Yen');
INSERT INTO `freepay_devises` VALUES ('398', 'KZT', 'Tenge', 'http://fr.wikipedia.org/wiki/Tenge');
INSERT INTO `freepay_devises` VALUES ('400', 'JOD', 'Dinar jordanien', 'http://fr.wikipedia.org/wiki/Dinar_jordanien');
INSERT INTO `freepay_devises` VALUES ('404', 'KES', 'Shilling kényan', 'http://fr.wikipedia.org/wiki/Shilling_k%C3%A9nyan');
INSERT INTO `freepay_devises` VALUES ('408', 'KPW', 'Won de la Corée du Nord', 'http://fr.wikipedia.org/wiki/Won');
INSERT INTO `freepay_devises` VALUES ('410', 'KRW', 'Won de la Corée du Sud', 'http://fr.wikipedia.org/wiki/Won');
INSERT INTO `freepay_devises` VALUES ('414', 'KWD', 'Dinar koweïtien', 'http://fr.wikipedia.org/wiki/Dinar_kowe%C3%AFtien');
INSERT INTO `freepay_devises` VALUES ('417', 'KGS', 'Som', 'http://fr.wikipedia.org/wiki/Som');
INSERT INTO `freepay_devises` VALUES ('418', 'LAK', 'Kip', 'http://fr.wikipedia.org/wiki/Kip');
INSERT INTO `freepay_devises` VALUES ('422', 'LBP', 'Livre libanaise', 'http://fr.wikipedia.org/wiki/Livre_libanaise');
INSERT INTO `freepay_devises` VALUES ('426', 'LSL', 'Loti', 'http://fr.wikipedia.org/wiki/Loti');
INSERT INTO `freepay_devises` VALUES ('428', 'LVL', 'Lats letton', 'http://fr.wikipedia.org/wiki/Lats_letton');
INSERT INTO `freepay_devises` VALUES ('430', 'LRD', 'Dollar libérien', 'http://fr.wikipedia.org/wiki/Dollar_lib%C3%A9rien');
INSERT INTO `freepay_devises` VALUES ('434', 'LYD', 'Dinar libyen', 'http://fr.wikipedia.org/wiki/Dinar_libyen');
INSERT INTO `freepay_devises` VALUES ('440', 'LTL', 'Litas lituanien', 'http://fr.wikipedia.org/wiki/Litas');
INSERT INTO `freepay_devises` VALUES ('446', 'MOP', 'Pataca', 'http://fr.wikipedia.org/wiki/Pataca');
INSERT INTO `freepay_devises` VALUES ('454', 'MWK', 'Kwacha malawite', 'http://fr.wikipedia.org/wiki/Kwacha_malawite');
INSERT INTO `freepay_devises` VALUES ('458', 'MYR', 'Ringgit de Malaisie', 'http://fr.wikipedia.org/wiki/Ringgit');
INSERT INTO `freepay_devises` VALUES ('462', 'MVR', 'Rufiyaa', 'http://fr.wikipedia.org/wiki/Rufiyaa');
INSERT INTO `freepay_devises` VALUES ('470', 'MTL', 'Livre maltaise', 'http://fr.wikipedia.org/wiki/Lire_maltaise');
INSERT INTO `freepay_devises` VALUES ('478', 'MRO', 'Ouguija', 'http://fr.wikipedia.org/wiki/Ouguiya');
INSERT INTO `freepay_devises` VALUES ('480', 'MUR', 'Roupie mauricienne', 'http://fr.wikipedia.org/wiki/Roupie_mauricienne');
INSERT INTO `freepay_devises` VALUES ('484', 'MXN', 'Peso mexicain', 'http://fr.wikipedia.org/wiki/Peso_mexicain');
INSERT INTO `freepay_devises` VALUES ('496', 'MNT', 'Tugrik', 'http://fr.wikipedia.org/wiki/Tugrik');
INSERT INTO `freepay_devises` VALUES ('498', 'MDL', 'Leu de Moldovie', 'http://fr.wikipedia.org/wiki/Leu_moldave');
INSERT INTO `freepay_devises` VALUES ('504', 'MAD', 'Dirham marocain', 'http://fr.wikipedia.org/wiki/Dirham_marocain');
INSERT INTO `freepay_devises` VALUES ('512', 'OMR', 'Rial Omani', '');
INSERT INTO `freepay_devises` VALUES ('516', 'NAD', 'Dollar namibien', 'http://fr.wikipedia.org/wiki/Dollar_namibien');
INSERT INTO `freepay_devises` VALUES ('524', 'NPR', 'Roupie népalaise', 'http://fr.wikipedia.org/wiki/Roupie_n%C3%A9palaise');
INSERT INTO `freepay_devises` VALUES ('532', 'ANG', 'Florin des Antilles', 'http://fr.wikipedia.org/wiki/Florin_des_Antilles_n%C3%A9erlandaises');
INSERT INTO `freepay_devises` VALUES ('533', 'AWG', 'Florin d''Aruba', 'http://fr.wikipedia.org/wiki/Florin_d%27Aruba');
INSERT INTO `freepay_devises` VALUES ('548', 'VUV', 'Vatu', 'http://fr.wikipedia.org/wiki/Vatu');
INSERT INTO `freepay_devises` VALUES ('554', 'NZD', 'Dollar néo-zélandais', 'http://fr.wikipedia.org/wiki/Dollar_n%C3%A9o-z%C3%A9landais');
INSERT INTO `freepay_devises` VALUES ('558', 'NIO', 'Cordoba Oro', 'http://fr.wikipedia.org/wiki/C%C3%B3rdoba_nicaraguayen');
INSERT INTO `freepay_devises` VALUES ('566', 'NGN', 'Naira', 'http://fr.wikipedia.org/wiki/Naira');
INSERT INTO `freepay_devises` VALUES ('578', 'NOK', 'Couronne norvégienne', 'http://fr.wikipedia.org/wiki/Couronne_norv%C3%A9gienne');
INSERT INTO `freepay_devises` VALUES ('586', 'PKR', 'Roupie pakistanaise', 'http://fr.wikipedia.org/wiki/Roupie_pakistanaise');
INSERT INTO `freepay_devises` VALUES ('590', 'PAB', 'Balboa', 'http://fr.wikipedia.org/wiki/Balboa_panam%C3%A9en');
INSERT INTO `freepay_devises` VALUES ('598', 'PGK', 'Kina', 'http://fr.wikipedia.org/wiki/Kina');
INSERT INTO `freepay_devises` VALUES ('600', 'PYG', 'Guarani', 'http://fr.wikipedia.org/wiki/Guarani_%28monnaie%29');
INSERT INTO `freepay_devises` VALUES ('604', 'PEN', 'Nouveau Sol', 'http://fr.wikipedia.org/wiki/Nuevo_sol');
INSERT INTO `freepay_devises` VALUES ('608', 'PHP', 'Peso philippin', 'http://fr.wikipedia.org/wiki/Peso_philippin');
INSERT INTO `freepay_devises` VALUES ('634', 'QAR', 'Rial qatari', 'http://fr.wikipedia.org/wiki/Rial_qatari');
INSERT INTO `freepay_devises` VALUES ('643', 'RUB', 'Rouble russe', 'http://fr.wikipedia.org/wiki/Rouble_russe');
INSERT INTO `freepay_devises` VALUES ('646', 'RWF', 'Franc du Rwanda', 'http://fr.wikipedia.org/wiki/Franc_rwandais');
INSERT INTO `freepay_devises` VALUES ('654', 'SHP', 'Livre de Sainte-Hélène', 'http://fr.wikipedia.org/wiki/Livre_de_Sainte-H%C3%A9l%C3%A8ne');
INSERT INTO `freepay_devises` VALUES ('678', 'STD', 'Dobra', 'http://fr.wikipedia.org/wiki/Dobra');
INSERT INTO `freepay_devises` VALUES ('682', 'SAR', 'Riyal saoudien', 'http://fr.wikipedia.org/wiki/Ryal_saoudien');
INSERT INTO `freepay_devises` VALUES ('690', 'SCR', 'Roupie seychelloise', 'http://fr.wikipedia.org/wiki/Roupie_seychelloise');
INSERT INTO `freepay_devises` VALUES ('694', 'SLL', 'Leone', 'http://fr.wikipedia.org/wiki/Leone');
INSERT INTO `freepay_devises` VALUES ('702', 'SGD', 'Dollar de Singapour', 'http://fr.wikipedia.org/wiki/Dollar_de_Singapour');
INSERT INTO `freepay_devises` VALUES ('703', 'SKK', 'Couronne slovaque', 'http://fr.wikipedia.org/wiki/Couronne_slovaque');
INSERT INTO `freepay_devises` VALUES ('704', 'VND', 'Dong', 'http://fr.wikipedia.org/wiki/Dong_%28monnaie%29');
INSERT INTO `freepay_devises` VALUES ('706', 'SOS', 'Shilling de Somalie', 'http://fr.wikipedia.org/wiki/Shilling_somali');
INSERT INTO `freepay_devises` VALUES ('710', 'ZAR', 'Rand', 'http://fr.wikipedia.org/wiki/Rand');
INSERT INTO `freepay_devises` VALUES ('716', 'ZWD', 'Dollar du Zimbabwe', 'http://fr.wikipedia.org/wiki/Dollar_zimbabw%C3%A9en');
INSERT INTO `freepay_devises` VALUES ('748', 'SZL', 'Lilangeni', 'http://fr.wikipedia.org/wiki/Lilangeni');
INSERT INTO `freepay_devises` VALUES ('752', 'SEK', 'Couronne suédoise', 'http://fr.wikipedia.org/wiki/Couronne_su%C3%A9doise');
INSERT INTO `freepay_devises` VALUES ('756', 'CHF', 'Franc suisse', 'http://fr.wikipedia.org/wiki/Franc_suisse');
INSERT INTO `freepay_devises` VALUES ('760', 'SYP', 'Livre syrienne', 'http://fr.wikipedia.org/wiki/Livre_syrienne');
INSERT INTO `freepay_devises` VALUES ('764', 'THB', 'Baht', 'http://fr.wikipedia.org/wiki/Baht');
INSERT INTO `freepay_devises` VALUES ('776', 'TOP', 'Pa''anga', 'http://fr.wikipedia.org/wiki/Pa%27anga');
INSERT INTO `freepay_devises` VALUES ('780', 'TTD', 'Dollar de la Trinité et de Tobago', '');
INSERT INTO `freepay_devises` VALUES ('784', 'AED', 'Dirham des émirats arabes unis', 'http://fr.wikipedia.org/wiki/Dirham_des_%C3%89mirats_arabes_unis');
INSERT INTO `freepay_devises` VALUES ('788', 'TND', 'Dinar tunisien', 'http://fr.wikipedia.org/wiki/Dinar_tunisien');
INSERT INTO `freepay_devises` VALUES ('795', 'TMM', 'Manat turkmène', 'http://fr.wikipedia.org/wiki/Manat_turkm%C3%A8ne');
INSERT INTO `freepay_devises` VALUES ('800', 'UGX', 'Shilling ougandais', 'http://fr.wikipedia.org/wiki/Shilling_ougandais');
INSERT INTO `freepay_devises` VALUES ('807', 'MKD', 'Denar', 'http://fr.wikipedia.org/wiki/Dinar');
INSERT INTO `freepay_devises` VALUES ('818', 'EGP', 'Livre égyptienne', 'http://fr.wikipedia.org/wiki/Livre_%C3%A9gyptienne');
INSERT INTO `freepay_devises` VALUES ('826', 'GBP', 'Livre sterling', 'http://fr.wikipedia.org/wiki/Livre_sterling');
INSERT INTO `freepay_devises` VALUES ('834', 'TZS', 'Shilling tanzanien', 'http://fr.wikipedia.org/wiki/Shilling_tanzanien');
INSERT INTO `freepay_devises` VALUES ('840', 'USD', 'Dollar des États-Unis', 'http://fr.wikipedia.org/wiki/Dollar_am%C3%A9ricain');
INSERT INTO `freepay_devises` VALUES ('858', 'UYU', 'Peso uruguayen', 'http://fr.wikipedia.org/wiki/Peso_uruguayen');
INSERT INTO `freepay_devises` VALUES ('860', 'UZS', 'Soum d''Ouzbékistan', 'http://fr.wikipedia.org/wiki/Sum_%28monnaie%29');
INSERT INTO `freepay_devises` VALUES ('862', 'VEB', 'Bolívar', 'http://fr.wikipedia.org/wiki/Bol%C3%ADvar_%28monnaie%29');
INSERT INTO `freepay_devises` VALUES ('882', 'WST', 'Tala', 'http://fr.wikipedia.org/wiki/Tala');
INSERT INTO `freepay_devises` VALUES ('886', 'YER', 'Rial yéménite', 'http://fr.wikipedia.org/wiki/Rial_y%C3%A9m%C3%A9nite');
INSERT INTO `freepay_devises` VALUES ('894', 'ZMK', 'Kwacha zambien', 'http://fr.wikipedia.org/wiki/Kwacha_zambien');
INSERT INTO `freepay_devises` VALUES ('901', 'TWD', 'Nouveau dollar de Taïwan', 'http://fr.wikipedia.org/wiki/Dollar_ta%C3%AFwanais');
INSERT INTO `freepay_devises` VALUES ('938', 'SDG', 'Livre soudanaise', '');
INSERT INTO `freepay_devises` VALUES ('941', 'RSD', 'Dinar serbe', 'http://fr.wikipedia.org/wiki/Dinar_serbe');
INSERT INTO `freepay_devises` VALUES ('943', 'MZN', 'Metical', 'http://fr.wikipedia.org/wiki/Metical');
INSERT INTO `freepay_devises` VALUES ('944', 'AZN', 'Manat azéri', 'http://fr.wikipedia.org/wiki/Manat_az%C3%A9ri');
INSERT INTO `freepay_devises` VALUES ('946', 'RON', 'Leu roumain', 'http://fr.wikipedia.org/wiki/Leu_roumain');
INSERT INTO `freepay_devises` VALUES ('947', 'CHE', 'WIR Euro', '');
INSERT INTO `freepay_devises` VALUES ('948', 'CHW', 'WIR Franc', '');
INSERT INTO `freepay_devises` VALUES ('950', 'XAF', 'Franc CFA - BEAC', 'http://fr.wikipedia.org/wiki/Franc_CFA');
INSERT INTO `freepay_devises` VALUES ('951', 'XCD', 'Dollar des Caraïbes orientales', 'http://fr.wikipedia.org/wiki/Dollar_de_la_Cara%C3%AFbe_orientale');
INSERT INTO `freepay_devises` VALUES ('952', 'XOF', 'Franc CFA - BCEAO', 'http://fr.wikipedia.org/wiki/Franc_CFA');
INSERT INTO `freepay_devises` VALUES ('953', 'XPF', 'Franc CFP', 'http://fr.wikipedia.org/wiki/Franc_pacifique');
INSERT INTO `freepay_devises` VALUES ('959', 'XAU', 'Or', 'http://fr.wikipedia.org/wiki/%C3%89talon-or');
INSERT INTO `freepay_devises` VALUES ('960', 'XDR', 'Droit de tirage spécial (D.T.S.)', 'http://fr.wikipedia.org/wiki/Droits_de_tirage_sp%C3%A9ciaux');
INSERT INTO `freepay_devises` VALUES ('961', 'XAG', 'Argent', 'http://fr.wikipedia.org/wiki/Argent');
INSERT INTO `freepay_devises` VALUES ('962', 'XPT', 'Platine', 'http://fr.wikipedia.org/wiki/Platine');
INSERT INTO `freepay_devises` VALUES ('968', 'SRD', 'Dollar de Surinam', 'http://fr.wikipedia.org/wiki/Dollar_surinamien');
INSERT INTO `freepay_devises` VALUES ('969', 'MGA', 'Malagasy Ariary', 'http://fr.wikipedia.org/wiki/Ariary_malgache');
INSERT INTO `freepay_devises` VALUES ('970', 'COU', 'Unidad de Valor Real', '');
INSERT INTO `freepay_devises` VALUES ('971', 'AFN', 'Afghani', 'http://fr.wikipedia.org/wiki/Afghani');
INSERT INTO `freepay_devises` VALUES ('972', 'TJS', 'Somoni', 'http://fr.wikipedia.org/wiki/Somoni');
INSERT INTO `freepay_devises` VALUES ('973', 'AOA', 'Kwanza', 'http://fr.wikipedia.org/wiki/Kwanza');
INSERT INTO `freepay_devises` VALUES ('974', 'BYR', 'Rouble biélorusse', 'http://fr.wikipedia.org/wiki/Rouble_bi%C3%A9lorusse');
INSERT INTO `freepay_devises` VALUES ('975', 'BGN', 'Bulgarian Lev', 'http://fr.wikipedia.org/wiki/Lev_bulgare');
INSERT INTO `freepay_devises` VALUES ('976', 'CDF', 'Franc Congolais', 'http://fr.wikipedia.org/wiki/Franc_congolais');
INSERT INTO `freepay_devises` VALUES ('977', 'BAM', 'Mark convertible', 'http://fr.wikipedia.org/wiki/Marka_%28monnaie%29');
INSERT INTO `freepay_devises` VALUES ('978', 'EUR', 'Euro', 'http://fr.wikipedia.org/wiki/Euro');
INSERT INTO `freepay_devises` VALUES ('979', 'MXV', 'Mexican Unidad de Inversion', '');
INSERT INTO `freepay_devises` VALUES ('980', 'UAH', 'Hryvnia', 'http://fr.wikipedia.org/wiki/Hryvnia');
INSERT INTO `freepay_devises` VALUES ('981', 'GEL', 'Lari', 'http://fr.wikipedia.org/wiki/Lari_%28monnaie%29');
INSERT INTO `freepay_devises` VALUES ('984', 'BOV', 'Mvdol', '');
INSERT INTO `freepay_devises` VALUES ('985', 'PLN', 'Zloty', 'http://fr.wikipedia.org/wiki/Z%C5%82oty_polonais');
INSERT INTO `freepay_devises` VALUES ('986', 'BRL', 'Real', 'http://fr.wikipedia.org/wiki/R%C3%A9al_br%C3%A9silien');
INSERT INTO `freepay_devises` VALUES ('990', 'CLF', 'Unité d''investissement', '');

-- --------------------------------------------------------

-- 
-- Structure de la table `freepay_fonds_exporter`
-- 

CREATE TABLE `freepay_fonds_exporter` (
  `datet` datetime NOT NULL default '0000-00-00 00:00:00',
  `iban` char(34) NOT NULL default '',
  `mailcli` char(40) NOT NULL default '',
  `valeurexport` decimal(30,2) default NULL,
  PRIMARY KEY  (`datet`,`iban`,`mailcli`),
  KEY `fk_tinc` (`iban`),
  KEY `fk_timc` (`mailcli`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Contenu de la table `freepay_fonds_exporter`
-- 


-- --------------------------------------------------------

-- 
-- Structure de la table `freepay_fonds_importer`
-- 

CREATE TABLE `freepay_fonds_importer` (
  `datet` datetime NOT NULL default '0000-00-00 00:00:00',
  `iban` char(34) NOT NULL default '',
  `mailcli` char(40) NOT NULL default '',
  `valeurimport` decimal(30,2) default NULL,
  PRIMARY KEY  (`datet`,`iban`,`mailcli`),
  KEY `fk_tinc` (`iban`),
  KEY `fk_timc` (`mailcli`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Contenu de la table `freepay_fonds_importer`
-- 


-- --------------------------------------------------------

-- 
-- Structure de la table `freepay_iban`
-- 

CREATE TABLE `freepay_iban` (
  `iban` char(34) NOT NULL default '',
  `paysiban` char(2) NOT NULL default '',
  `cleiban` int(2) NOT NULL default '0',
  `codebanqueiban` char(5) NOT NULL default '',
  `codeguichet` int(5) NOT NULL default '0',
  `numerocompteiban` char(13) NOT NULL default '',
  `clerib` int(2) NOT NULL default '0',
  `montantiban` decimal(30,2) default NULL,
  `mailcli` char(40) NOT NULL default '',
  PRIMARY KEY  (`iban`),
  KEY `fk_im` (`mailcli`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Contenu de la table `freepay_iban`
-- 



-- --------------------------------------------------------

-- 
-- Structure de la table `freepay_iban_transferer`
-- 

CREATE TABLE `freepay_iban_transferer` (
  `datet` datetime NOT NULL default '0000-00-00 00:00:00',
  `iban` char(40) NOT NULL default '',
  `iban2` char(40) NOT NULL default '',
  `valeurtriban` decimal(30,2) default NULL,
  PRIMARY KEY  (`datet`,`iban`,`iban2`),
  KEY `fk_tcomc` (`iban`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Contenu de la table `freepay_iban_transferer`
-- 


-- --------------------------------------------------------

-- 
-- Structure de la table `freepay_mic`
-- 

CREATE TABLE `freepay_mic` (
  `mic` varchar(4) NOT NULL default '',
  `institutionmic` varchar(100) NOT NULL default '',
  `villemic` varchar(40) NOT NULL default '',
  `codepaysmic` char(2) NOT NULL default '',
  `nompaysmic` varchar(40) NOT NULL default '',
  `urlmic` varchar(100) NOT NULL default '',
  `accrmic` varchar(4) default NULL,
  PRIMARY KEY  (`mic`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Contenu de la table `freepay_mic`
-- 

INSERT INTO `freepay_mic` VALUES ('XA1X', 'A1', 'BUENOS AIRES', 'AR', 'ARGENTINA', '', '');
INSERT INTO `freepay_mic` VALUES ('XADS', 'ABU DHABI SECURITIES MARKET', 'ABU DHABI', 'AE', 'UNITED ARAB EMIRATES', 'http://www.adsm.ae/', 'ADSM');
INSERT INTO `freepay_mic` VALUES ('XDRF', 'AIAF - MERCADO DE RENTA FIJA', 'MADRID', 'ES', 'SPAIN', 'http://www.aiaf.es/', '');
INSERT INTO `freepay_mic` VALUES ('XALG', 'ALGIERS STOCK EXCHANGE', 'ALGIERS', 'DZ', 'ALGERIA', '', '');
INSERT INTO `freepay_mic` VALUES ('AIMX', 'ALTERNATE INVESTMENT MARKET', 'LONDON', 'GB', 'UNITED KINGDOM', 'http://www.londonstockexchange.com/en-gb/products/companyservices/ourmarkets/aim/', 'AIM');
INSERT INTO `freepay_mic` VALUES ('ALTX', 'ALTERNATIVE EXCHANGE', ' JOHANNESBURG', 'ZA', 'SOUTH AFRICA', '', 'ALTX');
INSERT INTO `freepay_mic` VALUES ('XASE', 'AMERICAN STOCK EXCHANGE', 'NEW YORK', 'US', 'UNITED STATES OF AMERICA', 'http://www.amex.com/', 'AMEX');
INSERT INTO `freepay_mic` VALUES ('XAMM', 'AMMAN STOCK EXCHANGE', 'AMMAN', 'JO', 'JORDAN', 'http://www.ase.com.jo/', '');
INSERT INTO `freepay_mic` VALUES ('NLPX', 'APX POWER NL', 'AMSTERDAM', 'NL', 'THE NETHERLANDS', '', '');
INSERT INTO `freepay_mic` VALUES ('UKPX', 'APX POWER UK', 'LONDON', 'GB', 'UNITED KINGDOM', '', '');
INSERT INTO `freepay_mic` VALUES ('XAZX', 'ARIZONA STOCK EXCHANGE', 'PHOENIX', 'US', 'UNITED STATES OF AMERICA', '', 'AZX');
INSERT INTO `freepay_mic` VALUES ('XARM', 'ARMENIAN STOCK EXCHANGE', 'YEREVAN', 'AM', 'ARMENIA', 'http://www.armex.am/', 'ARME');
INSERT INTO `freepay_mic` VALUES ('XAPI', 'ASIA-PACIFIC INTERBANK CURRENCY EXCHANGE, THE', 'VLADIVOSTOK', 'RU', 'RUSSIA', '', 'APIC');
INSERT INTO `freepay_mic` VALUES ('XASX', 'ASX OPERATIONS PTY LIMITED', 'SYDNEY', 'AU', 'AUSTRALIA', '', 'ASX');
INSERT INTO `freepay_mic` VALUES ('XADE', 'ATHENS DERIVATIVES EXCHANGE S.A., THE', 'ATHENS', 'GR', 'GREECE', 'http://www.adex.ase.gr/', 'ADEX');
INSERT INTO `freepay_mic` VALUES ('XATH', 'ATHENS STOCK EXCHANGE', 'ATHENS', 'GR', 'GREECE', 'http://www.ase.gr/', '');
INSERT INTO `freepay_mic` VALUES ('AWBX', 'AUSTRALIAN WHEAT BOARD', 'MELBOURNE', 'AU', 'AUSTRALIA', 'http://www.awb.com.au/', 'AWB');
INSERT INTO `freepay_mic` VALUES ('AWEX', 'AUSTRALIAN WOOL EXCHANGE', 'LANE COVE', 'AU', 'AUSTRALIA', 'http://www.awex.com.au/', 'AWEX');
INSERT INTO `freepay_mic` VALUES ('XSTU', 'BADEN-WUERTTEMBERGISCHE WERTPAPIERBOERSE ZU STUTTGART', 'STUTTGART', 'DE', 'GERMANY', 'http://www.boerse-stuttgart.de/', '');
INSERT INTO `freepay_mic` VALUES ('XBAA', 'BAHAMAS INTERNATIONAL SECURITIES EXCHANGE', 'NASAU', 'BS', 'BAHAMAS', 'http://www.bisxbahamas.com/', 'BISX');
INSERT INTO `freepay_mic` VALUES ('XBAH', 'BAHRAIN STOCK EXCHANGE', 'MANAMA', 'BH', 'BAHRAIN', 'http://www.bahrainstock.com/', 'BSE');
INSERT INTO `freepay_mic` VALUES ('XIBE', 'BAKU INTERBANK CURRENCY EXCHANGE', 'BAKU', 'AZ', 'AZERBAIJAN', 'http://www.bbvb.org/', '');
INSERT INTO `freepay_mic` VALUES ('XBAN', 'BANGALORE STOCK EXCHANGE LTD', 'BANGALORE', 'IN', 'INDIA', 'http://www.bgse.co.in/', '');
INSERT INTO `freepay_mic` VALUES ('XBLB', 'BANJA LUKA STOCK EXCHANGE', 'BANJA LUKA', 'BA', 'BOSNIA AND HERZEGOVINA', 'http://www.blberza.com/', '');
INSERT INTO `freepay_mic` VALUES ('XBAB', 'BARBADOS STOCK EXCHANGE', 'BRIDGETOWN', 'BB', 'BARBADOS', 'http://www.bse.com.bb/', 'BSE');
INSERT INTO `freepay_mic` VALUES ('XBAR', 'BARCELONA STOCK EXCHANGE', 'BARCELONA', 'ES', 'SPAIN', 'http://www.borsabcn.es/', '');
INSERT INTO `freepay_mic` VALUES ('BATS', 'BATS TRADING', 'KANSAS CITY', 'US', 'UNITED STATES OF AMERICA', 'http://www.batstrading.com/', 'BATS');
INSERT INTO `freepay_mic` VALUES ('XMUN', 'BAYERISCHE BOERSE', 'MUENCHEN', 'DE', 'GERMANY', 'http://www.boerse-muenchen.de/', '');
INSERT INTO `freepay_mic` VALUES ('BCSE', 'BELARUS CURRENCY AND STOCK EXCHANGE', 'MINSK', 'BY', 'BELARUS', 'http://www.bcse.by/', 'BCSE');
INSERT INTO `freepay_mic` VALUES ('BLPX', 'BELGIUM POWER EXCHANGE', 'BRUSSELS', 'BE', 'BELGIUM', 'http://www.belpex.be/', 'BLPX');
INSERT INTO `freepay_mic` VALUES ('XBEL', 'BELGRADE STOCK EXCHANGE', 'BELGRADE', 'RS', 'SERBIA (REPUBLIC OF)', 'http://www.belex.co.yu/', '');
INSERT INTO `freepay_mic` VALUES ('XBER', 'BERLINER WERTPAPIERBOERSE', 'BERLIN', 'DE', 'GERMANY', 'http://www.berlinerboerse.de/', '');
INSERT INTO `freepay_mic` VALUES ('XBDA', 'BERMUDA STOCK EXCHANGE LTD, THE', 'HAMILTON', 'BM', 'BERMUDA', 'http://www.bsx.com/', 'BSX');
INSERT INTO `freepay_mic` VALUES ('XBRN', 'BERNE STOCK EXCHANGE', 'BERNE', 'CH', 'SWITZERLAND', 'http://www.berne-x.com/', '');
INSERT INTO `freepay_mic` VALUES ('BIDS', 'BIDS TRADING L.P.', 'NEW YORK', 'US', 'UNITED STATES OF AMERICA', 'http://www.bidstrading.com/', 'BIDS');
INSERT INTO `freepay_mic` VALUES ('XBOL', 'BOLSA BOLIVIANA DE VALORES S.A.', 'LA PAZ', 'BO', 'BOLIVIA', 'http://www.bolsa-valores-bolivia.com', '');
INSERT INTO `freepay_mic` VALUES ('XBBF', 'BOLSA BRASILIERA DE FUTUROS', 'RIO DE JANEIRO', 'BR', 'BRAZIL', 'http://www.bmf.com.br/', 'BBF');
INSERT INTO `freepay_mic` VALUES ('XBCV', 'BOLSA CENTROAMERICANA DE VALORES S.A.', 'TEGUCIGALPA', 'HN', 'HONDURAS', 'http://www.bcv.hn/', 'BCV');
INSERT INTO `freepay_mic` VALUES ('XBCC', 'BOLSA DE COMERCIO DE CORBODA', 'CORDOBA', 'AR', 'ARGENTINA', '', '');
INSERT INTO `freepay_mic` VALUES ('XROS', 'BOLSA DE COMERCIO ROSARIO', 'ROSARIO', 'AR', 'ARGENTINA', 'http://www.bcr.com.ar/', 'ROFE');
INSERT INTO `freepay_mic` VALUES ('XBCM', 'BOLSA DE COMMERCIO DE MENDOZA S.A.', 'MENDOZA', 'AR', 'ARGENTINA', 'http://www.bolsamza.com.ar/', '');
INSERT INTO `freepay_mic` VALUES ('XMAD', 'BOLSA DE MADRID', 'MADRID', 'ES', 'SPAIN', 'http://www.bolsamadrid.es/', '');
INSERT INTO `freepay_mic` VALUES ('XBMF', 'BOLSA DE MERCADORIAS E FUTUROS', 'SAO PAULO', 'BR', 'BRAZIL', 'http://www.bmf.com.br/', 'BM A');
INSERT INTO `freepay_mic` VALUES ('XVAL', 'BOLSA DE VALENCIA', 'VALENCIA', 'ES', 'SPAIN', 'http://www.bolsavalencia.es/', '');
INSERT INTO `freepay_mic` VALUES ('XBIL', 'BOLSA DE VALORES DE BILBAO', 'BILBAO', 'ES', 'SPAIN', 'http://www.bolsabilbao.es/', '');
INSERT INTO `freepay_mic` VALUES ('XCAR', 'BOLSA DE VALORES DE CARACAS', 'CARACAS', 'VE', 'VENEZUELA', 'http://www.bolsadecaracas.com/', '');
INSERT INTO `freepay_mic` VALUES ('XBOG', 'BOLSA DE VALORES DE COLOMBIA', 'BOGOTA', 'CO', 'COLOMBIA', 'http://www.bvc.com.co/', 'BVC');
INSERT INTO `freepay_mic` VALUES ('XBVR', 'BOLSA DE VALORES DE LA REPUBLICA DOMINICANA SA.', 'ST DOMINGO', 'DO', 'DOMINICAN REPUBLIC', 'http://www.bolsard.com/', 'BVRD');
INSERT INTO `freepay_mic` VALUES ('XLIM', 'BOLSA DE VALORES DE LIMA', 'LIMA', 'PE', 'PERU', 'http://www.bvl.com.pe/', 'BVL');
INSERT INTO `freepay_mic` VALUES ('XMNT', 'BOLSA DE VALORES DE MONTEVIDEO', 'MONTEVIDEO', 'UY', 'URUGUAY', 'http://www.bvm.com.uy/', 'BVMT');
INSERT INTO `freepay_mic` VALUES ('XMAN', 'BOLSA DE VALORES DE NICARAGUA', 'MANAGUA', 'NI', 'NICARAGUA', 'http://www.bolsanic.com/', '');
INSERT INTO `freepay_mic` VALUES ('XPTY', 'BOLSA DE VALORES DE PANAMA, S.A.', 'PANAMA', 'PA', 'PANAMA', 'http://www.panabolsa.com/', 'BVP');
INSERT INTO `freepay_mic` VALUES ('XBSP', 'BOLSA DE VALORES DE SAO PAULO', 'SAO PAULO', 'BR', 'BRAZIL', 'http://www.bovespa.com.br/', 'BOVE');
INSERT INTO `freepay_mic` VALUES ('XRIO', 'BOLSA DE VALORES DO RIO DE JANEIRO', 'RIO DE JANEIRO', 'BR', 'BRAZIL', 'http://www.bvrj.com.br/', 'BVRJ');
INSERT INTO `freepay_mic` VALUES ('XGTG', 'BOLSA DE VALORES NACIONAL SA', 'GUATEMALA', 'GT', 'GUATEMALA', 'http://www.bvnsa.com.gt/', '');
INSERT INTO `freepay_mic` VALUES ('XVPA', 'BOLSA DE VALORES Y PRODUCTOS DE ASUNCION SA', 'ASUNCION', 'PY', 'PARAGUAY', 'http://www.bvpasa.com.py/', 'BVPA');
INSERT INTO `freepay_mic` VALUES ('XMEX', 'BOLSA MEXICANA DE VALORES (MEXICAN STOCK EXCHANGE)', 'MEXICO', 'MX', 'MEXICO', 'http://www.bmv.com.mx/', '');
INSERT INTO `freepay_mic` VALUES ('XBNV', 'BOLSA NACIONAL DE VALORES, S.A.', 'SAN JOSE', 'CR', 'COSTA RICA', '', 'BNV');
INSERT INTO `freepay_mic` VALUES ('XBES', 'BOND EXCHANGE OF SOUTH AFRICA', 'JOHANNESBURG', 'ZA', 'SOUTH AFRICA', 'http://www.bondexchange.co.za/', 'BESA');
INSERT INTO `freepay_mic` VALUES ('XBMK', 'BONDMART', 'NEW YORK', 'US', 'UNITED STATES OF AMERICA', 'http://www.bondmart.com/', '');
INSERT INTO `freepay_mic` VALUES ('BOND', 'BONDVISION', 'ROMA', 'IT', 'ITALY', 'http://www.bondvision.net/', '');
INSERT INTO `freepay_mic` VALUES ('XMIL', 'BORSA ITALIANA S.P.A.', 'MILANO', 'IT', 'ITALY', 'http://www.borsaitaliana.it/', '');
INSERT INTO `freepay_mic` VALUES ('XBOX', 'BOSTON OPTIONS EXCHANGE', 'BOSTON', 'US', 'UNITED STATES OF AMERICA', 'http://www.bostonoptions.com/', 'BOX');
INSERT INTO `freepay_mic` VALUES ('XBOS', 'BOSTON STOCK EXCHANGE', 'BOSTON', 'US', 'UNITED STATES OF AMERICA', 'http://www.bostonstock.com/', 'BSE');
INSERT INTO `freepay_mic` VALUES ('XBOT', 'BOTSWANA STOCK EXCHANGE', 'GABORONO', 'BW', 'BOTSWANA', 'http://www.bse.co.bw/', '');
INSERT INTO `freepay_mic` VALUES ('XBEY', 'BOURSE DE BEYROUTH', 'BEYROUTH', 'LB', 'LEBANON', 'http://www.bse.com.lb/', '');
INSERT INTO `freepay_mic` VALUES ('XTUN', 'BOURSE DES VALEURS MOBILIERES', 'TUNIS', 'TN', 'TUNISIA', 'http://www.bvmt.com.tn/', 'BVMT');
INSERT INTO `freepay_mic` VALUES ('XBRV', 'BOURSE REGIONALE DES VALEURS MOBILIERES', 'ABIDJAN', 'CI', 'IVORY COAST', '', 'BRVM');
INSERT INTO `freepay_mic` VALUES ('XBRA', 'BRATISLAVA STOCK EXCHANGE, THE', 'BRATISLAVA', 'SK', 'SLOVAKIA', 'http://www.bsse.sk/', 'BSSE');
INSERT INTO `freepay_mic` VALUES ('XBRE', 'BREMER WERTPAPIERBOERSE', 'BREMEN', 'DE', 'GERMANY', 'http://www.berlinerboerse.de/', '');
INSERT INTO `freepay_mic` VALUES ('BTEE', 'BROKERTEC EUROPE LTD.', 'LONDON', 'GB', 'UNITED KINGDOM', '', 'BTEC');
INSERT INTO `freepay_mic` VALUES ('XBSE', 'BUCHAREST STOCK EXCHANGE', 'BUCHAREST', 'RO', 'ROMANIA', 'http://www.bvb.ro/', 'BVP');
INSERT INTO `freepay_mic` VALUES ('XBUD', 'BUDAPEST STOCK EXCHANGE', 'BUDAPEST', 'HU', 'HUNGARY', 'http://www.bse.hu/', '');
INSERT INTO `freepay_mic` VALUES ('XBUE', 'BUENOS AIRES STOCK EXCHANGE', 'BUENOS AIRES', 'AR', 'ARGENTINA', 'http://www.bcba.sba.com.ar/', '');
INSERT INTO `freepay_mic` VALUES ('XBUL', 'BULGARIAN STOCK EXCHANGE', 'SOFIA', 'BG', 'BULGARIA', 'http://www.bse-sofia.bg/', 'BSE');
INSERT INTO `freepay_mic` VALUES ('XKLS', 'BURSA MALAYSIA', 'KUALA LUMPUR', 'MY', 'MALAYSIA', 'http://www.bursamalaysia.com/', '');
INSERT INTO `freepay_mic` VALUES ('XDPA', 'CADE - MERCADO DE DEUDA PUBLICA ANOTADA', 'MADRID', 'ES', 'SPAIN', '', '');
INSERT INTO `freepay_mic` VALUES ('XCAI', 'CAIRO AND ALEXANDRIA STOCK EXCHANGE', 'CAIRO', 'EG', 'EGYPT', 'http://www.egyptse.com/', 'CASE');
INSERT INTO `freepay_mic` VALUES ('XCAL', 'CALCUTTA STOCK EXCHANGE', 'CALCUTTA', 'IN', 'INDIA', 'http://www.cse-india.com/', '');
INSERT INTO `freepay_mic` VALUES ('CANX', 'CANNEX FINANCIAL EXCHANGE LTS.', 'TORONTO', 'CA', 'CANADA', 'http://www.cannex.com/', 'CANN');
INSERT INTO `freepay_mic` VALUES ('XCFF', 'CANTOR FINANCIAL FUTURES EXCHANGE', 'NEW YORK', 'US', 'UNITED STATES OF AMERICA', 'http://www.cantor.com/', 'CANT');
INSERT INTO `freepay_mic` VALUES ('XBVC', 'CAPE VERDE STOCK EXCHANGE, THE', 'PRAIA', 'CV', 'CAPE VERDE', 'http://www.bvc.cv/', 'BVC');
INSERT INTO `freepay_mic` VALUES ('XCAS', 'CASABLANCA STOCK EXCHANGE', 'CASABLANCA', 'MA', 'MOROCCO', 'http://www.casablanca-bourse.com/', '');
INSERT INTO `freepay_mic` VALUES ('XCAY', 'CAYMAN ISLANDS STOCK EXCHANGE', 'GEORGETOWN', 'KY', 'CAYMAN ISLANDS', 'http://www.csx.com.ky/', '');
INSERT INTO `freepay_mic` VALUES ('XCBF', 'CBOE FUTURES EXCHANGE', 'CHICAGO', 'US', 'UNITED STATES OF AMERICA', 'http://cfe.cboe.com/', 'CFE');
INSERT INTO `freepay_mic` VALUES ('XNKS', 'CENTRAL JAPAN COMMODITIES EXCHANGE', 'NAGOYA', 'JP', 'JAPAN', 'http://www.c-com.or.jp/', 'C-CO');
INSERT INTO `freepay_mic` VALUES ('CCLX', 'CENTRALE DE COMMUNICATIONS LUXEMBOURG S.A.', 'LUXEMBOURG', 'LU', 'LUXEMBOURG', 'http://www.cclux.lu/', 'CCLu');
INSERT INTO `freepay_mic` VALUES ('XCBT', 'CHICAGO BOARD OF TRADE', 'CHICAGO', 'US', 'UNITED STATES OF AMERICA', 'http://www.cbot.com/', 'CBOT');
INSERT INTO `freepay_mic` VALUES ('FCBT', 'CHICAGO BOARD OF TRADE (FLOOR)', 'CHICAGO', 'US', 'UNITED STATES OF AMERICA', '', 'CBOT');
INSERT INTO `freepay_mic` VALUES ('XCBO', 'CHICAGO BOARD OPTIONS EXCHANGE', 'CHICAGO', 'US', 'UNITED STATES OF AMERICA', 'http://www.cboe.com/', 'CBOE');
INSERT INTO `freepay_mic` VALUES ('XCCX', 'CHICAGO CLIMATE EXCHANGE, INC', 'CHICAGO', 'US', 'UNITED STATES OF AMERICA', 'http://www.chicagoclimatex.com/', 'CCX');
INSERT INTO `freepay_mic` VALUES ('XCME', 'CHICAGO MERCANTILE EXCHANGE', 'CHICAGO', 'US', 'UNITED STATES OF AMERICA', 'http://www.cme.com/', 'CME');
INSERT INTO `freepay_mic` VALUES ('FCME', 'CHICAGO MERCANTILE EXCHANGE (FLOOR)', 'CHICAGO', 'US', 'UNITED STATES OF AMERICA', '', 'CME');
INSERT INTO `freepay_mic` VALUES ('XCRC', 'CHICAGO RICE AND COTTON EXCHANGE', 'CHICAGO', 'US', 'UNITED STATES OF AMERICA', '', '');
INSERT INTO `freepay_mic` VALUES ('XCHI', 'CHICAGO STOCK EXCHANGE, INC.', 'CHICAGO', 'US', 'UNITED STATES OF AMERICA', 'http://www.chx.com/', 'CHX');
INSERT INTO `freepay_mic` VALUES ('XCFE', 'CHINA FOREIGN EXCHANGE TRADE SYSTEM', 'SHANGHAI', 'CN', 'CHINA', '', 'CFET');
INSERT INTO `freepay_mic` VALUES ('XCHG', 'CHITTAGONG STOCK EXCHANGE LTD.', 'CHITTAGONG', 'BD', 'BANGLADESH', 'http://www.csebd.com/', 'CSE');
INSERT INTO `freepay_mic` VALUES ('XCOL', 'COLOMBO STOCK EXCHANGE', 'COLOMBO', 'LK', 'SRI LANKA', 'http://www.cse.lk/', '');
INSERT INTO `freepay_mic` VALUES ('XCEC', 'COMMODITIES EXCHANGE CENTER', 'NEW YORK', 'US', 'UNITED STATES OF AMERICA', '', 'COME');
INSERT INTO `freepay_mic` VALUES ('XCSE', 'COPENHAGEN STOCK EXCHANGE', 'COPENHAGEN', 'DK', 'DENMARK', 'http://omxgroup.com/', '');
INSERT INTO `freepay_mic` VALUES ('CRDL', 'COREDEAL MTS', 'LONDON', 'GB', 'UNITED KINGDOM', '', '');
INSERT INTO `freepay_mic` VALUES ('XCYS', 'CYPRUS STOCK EXCHANGE', 'NICOSIA (LEFKOSIA)', 'CY', 'CYPRUS', 'http://www.cse.com.cy/', 'CSE');
INSERT INTO `freepay_mic` VALUES ('XDCE', 'DALIAN COMMODITY EXCHANGE', 'DALIAN', 'CN', 'CHINA', 'http://www.dce.com.cn/', 'DCE');
INSERT INTO `freepay_mic` VALUES ('DAMP', 'DANISH AUTHORISED MARKET PLACE LTD.', 'COPENHAGEN', 'DK', 'DENMARK', '', 'DANS');
INSERT INTO `freepay_mic` VALUES ('XDAR', 'DAR ES SALAAM STOCK EXCHANGE', 'DAR ES SALAAM', 'TZ', 'TANZANIA', 'http://www.darstockexchange.com/', '');
INSERT INTO `freepay_mic` VALUES ('XDES', 'DELHI STOCK EXCHANGE', 'DELHI', 'IN', 'INDIA', 'http://www.dseindia.com/', '');
INSERT INTO `freepay_mic` VALUES ('XFRA', 'DEUTSCHE BOERSE AG', 'FRANKFURT AM MAIN', 'DE', 'GERMANY', 'http://deutsche-boerse.com/', '');
INSERT INTO `freepay_mic` VALUES ('XETR', 'DEUTSCHER KASSENVEREIN AG GRUPPE DEUTSCHE BOERSE', 'FRANKFURT AM MAIN', 'DE', 'GERMANY', '', 'XETR');
INSERT INTO `freepay_mic` VALUES ('XDHA', 'DHAKA STOCK EXCHANGE LTD', 'DHAKA', 'BD', 'BANGLADESH', 'http://www.dsebd.org/', 'DSE');
INSERT INTO `freepay_mic` VALUES ('EDGA', 'DIRECT EDGE ECN (EDGA)', 'JERSEY CITY', 'US', 'UNITED STATES OF AMERICA', 'http://www.directedge.com/', '');
INSERT INTO `freepay_mic` VALUES ('EDGX', 'DIRECT EDGE ECN (EDGX)', 'JERSEY CITY', 'US', 'UNITED STATES OF AMERICA', 'http://www.directedge.com/', '');
INSERT INTO `freepay_mic` VALUES ('DSMD', 'DOHA SECURITIES MARKET', 'DOHA', 'QA', 'QATAR', 'http://www.dsm.com.qa/', 'DSM');
INSERT INTO `freepay_mic` VALUES ('XDFB', 'DONETSK STOCK EXCHANGE', 'DONETSK', 'UA', 'UKRAINE', 'http://www.dfb.donbass.com/', 'DFB');
INSERT INTO `freepay_mic` VALUES ('XDFM', 'DUBAI FINANCIAL MARKET', 'DUBAI', 'AE', 'UNITED ARAB EMIRATES', 'http://www.dfm.ae/', 'DFM');
INSERT INTO `freepay_mic` VALUES ('DGCX', 'DUBAI GOLD AND COMMODITIES EXCHANGE DMCC', 'DUBAI', 'AE', 'UNITED ARAB EMIRATES', 'http://www.dgcx.ae/', 'DGCX');
INSERT INTO `freepay_mic` VALUES ('DIFX', 'DUBAI INTERNATIONAL FINANCIAL EXCHANGE LTD.', 'DUBAI', 'AE', 'UNITED ARAB EMIRATES', 'http://www.difx.ae/', 'DIFX');
INSERT INTO `freepay_mic` VALUES ('XEAS', 'EASDAQ', 'LEUVEN', 'BE', 'BELGIUM', '', '');
INSERT INTO `freepay_mic` VALUES ('XECS', 'EASTERN CARIBBEAN SECURITIES EXCHANGE', 'BASSETERRE', 'KN', 'SAINT KITTS AND NEVIS', 'http://www.ecseonline.com/', 'ECSE');
INSERT INTO `freepay_mic` VALUES ('XEDX', 'EDX LONDON LIMITED', 'LONDON', 'GB', 'UNITED KINGDOM', 'http://www.londonstockexchange.com/', '');
INSERT INTO `freepay_mic` VALUES ('XSVA', 'EL SALVADOR STOCK EXCHANGE', 'EL SALVADOR', 'SV', 'EL SALVADOR', 'https://www.bves.com.sv/', '');
INSERT INTO `freepay_mic` VALUES ('HDAT', 'ELECTRONIC SECONDARY SECURITIES MARKET (HDAT)', 'ATHENS', 'GR', 'GREECE', '', 'HDAT');
INSERT INTO `freepay_mic` VALUES ('XEUB', 'EUREX BONDS', 'FRANKFURT AM MAIN', 'DE', 'GERMANY', 'http://www.eurex-bonds.com/', '');
INSERT INTO `freepay_mic` VALUES ('ECAG', 'EUREX CLEARING AG', 'FRANKFURT AM MAIN', 'DE', 'GERMANY', 'http://www.eurexchange.com/', '');
INSERT INTO `freepay_mic` VALUES ('XEUR', 'EUREX DEUTSCHLAND', 'FRANKFURT AM MAIN', 'DE', 'GERMANY', '', '');
INSERT INTO `freepay_mic` VALUES ('XEUP', 'EUREX REPO GMBH', 'FRANKFURT AM MAIN', 'DE', 'GERMANY', '', '');
INSERT INTO `freepay_mic` VALUES ('TMTS', 'EUROBENCHMARK TRES. BILLS', 'LONDON', 'GB', 'UNITED KINGDOM', '', '');
INSERT INTO `freepay_mic` VALUES ('CMTS', 'EUROCREDIT', 'LONDON', 'GB', 'UNITED KINGDOM', '', '');
INSERT INTO `freepay_mic` VALUES ('LMTS', 'EUROGLOBAL MTS', 'LONDON', 'GB', 'UNITED KINGDOM', 'http://www.euroglobalmts.com/', '');
INSERT INTO `freepay_mic` VALUES ('EMTS', 'EUROMTS', 'LONDON', 'GB', 'UNITED KINGDOM', '', 'EMTS');
INSERT INTO `freepay_mic` VALUES ('KMTS', 'EUROMTS LINKERS MARKET', 'LONDON', 'GB', 'UNITED KINGDOM', '', '');
INSERT INTO `freepay_mic` VALUES ('XAMS', 'EURONEXT AMSTERDAM', 'AMSTERDAM', 'NL', 'THE NETHERLANDS', 'http://www.euronext.com/', 'EURO');
INSERT INTO `freepay_mic` VALUES ('XBRU', 'EURONEXT BRUSSELS', 'BRUSSELS', 'BE', 'BELGIUM', 'http://www.euronext.com/', 'EURO');
INSERT INTO `freepay_mic` VALUES ('XEUC', 'EURONEXT COM, COMMODITIES FUTURES AND OPTIONS', 'AMSTERDAM', 'NL', 'THE NETHERLANDS', 'http://www.euronext.com/', 'EURO');
INSERT INTO `freepay_mic` VALUES ('XEUE', 'EURONEXT EQF, EQUITIES AND INDICES DERIVATIVES', 'AMSTERDAM', 'NL', 'THE NETHERLANDS', 'http://www.euronext.com/', 'EURO');
INSERT INTO `freepay_mic` VALUES ('XEUI', 'EURONEXT IRF, INTEREST RATE FUTURE AND OPTIONS', 'AMSTERDAM', 'NL', 'THE NETHERLANDS', 'http://www.euronext.com/', 'EURO');
INSERT INTO `freepay_mic` VALUES ('XLIS', 'EURONEXT LISBOA', 'LISBOA', 'PT', 'PORTUGAL', 'http://www.euronext.com/', 'EURO');
INSERT INTO `freepay_mic` VALUES ('XMAT', 'EURONEXT PARIS - MATIF', 'PARIS', 'FR', 'FRANCE', 'http://www.matif.fr/', 'EURO');
INSERT INTO `freepay_mic` VALUES ('XMON', 'EURONEXT PARIS - MONEP', 'PARIS', 'FR', 'FRANCE', 'http://www.monep.fr/', 'EURO');
INSERT INTO `freepay_mic` VALUES ('XPAR', 'EURONEXT PARIS S.A.', 'PARIS', 'FR', 'FRANCE', 'http://www.euronext.com/', 'EURO');
INSERT INTO `freepay_mic` VALUES ('XMLI', 'EURONEXT PARIS S.A. - MARCHE LIBRE', 'PARIS', 'FR', 'FRANCE', 'http://www.euronext.com/editorial/wide/editorial-4697-EN.html', 'EURO');
INSERT INTO `freepay_mic` VALUES ('XLIF', 'EURONEXT.LIFFE', 'LONDON', 'GB', 'UNITED KINGDOM', 'http://www.euronext.com/home_derivatives-2153-EN.html', '');
INSERT INTO `freepay_mic` VALUES ('XEEE', 'EUROPEAN ENERGY EXCHANGE AG', 'FRANKFURT AM MAIN', 'DE', 'GERMANY', 'http://www.eex.com/', '');
INSERT INTO `freepay_mic` VALUES ('EUWX', 'EUWAX', 'STUTTGART', 'DE', 'GERMANY', 'http://www.euwax.de/', 'EUWA');
INSERT INTO `freepay_mic` VALUES ('XFNX', 'FINEX (NEW YORK AND DUBLIN)', 'DUBLIN', 'IE', 'IRELAND', '', 'FINE');
INSERT INTO `freepay_mic` VALUES ('XFOM', 'FINNISH OPTIONS MARKET', 'HELSINKI', 'FI', 'FINLAND', '', 'FOM');
INSERT INTO `freepay_mic` VALUES ('PFTS', 'FIRST SECURITIES TRADING SYSTEM - UKRAINIAN OTC', 'KIEV', 'UA', 'UKRAINE', 'http://www.pfts.com/', 'PFTS');
INSERT INTO `freepay_mic` VALUES ('FRRF', 'FONDS DES RENTES / RENTENFONDS', 'BRUSSELS', 'BE', 'BELGIUM', 'http://www.rentenfonds.be/', '');
INSERT INTO `freepay_mic` VALUES ('XFFE', 'FUKUOKA FUTURES EXCHANGE', 'FUKUOKA', 'JP', 'JAPAN', '', '');
INSERT INTO `freepay_mic` VALUES ('XFKA', 'FUKUOKA STOCK EXCHANGE', 'FUKUOKA', 'JP', 'JAPAN', 'http://www.fse.or.jp/', '');
INSERT INTO `freepay_mic` VALUES ('XGSE', 'GEORGIA STOCK EXCHANGE', 'TBILISI', 'GE', 'GEORGIA', 'http://www.gse.ge/', 'GSE');
INSERT INTO `freepay_mic` VALUES ('XGHA', 'GHANA STOCK EXCHANGE', 'ACCRA', 'GH', 'GHANA', 'http://www.gse.com.gh/', '');
INSERT INTO `freepay_mic` VALUES ('ROCO', 'GRETAI SECURITIES MARKET', 'TAIPEI', 'TW', 'TAIWAN', 'http://www.otc.org.tw/', '');
INSERT INTO `freepay_mic` VALUES ('XGUA', 'GUAYAQUIL STOCK EXCHANGE', 'GUAYAQUIL', 'EC', 'ECUADOR', 'http://www.mundobvg.com/', '');
INSERT INTO `freepay_mic` VALUES ('GXMA', 'GX MARKETCENTER', 'VILA', 'WS', 'VANUATU', '', '');
INSERT INTO `freepay_mic` VALUES ('HSTC', 'HANOI SECURITIES TRADING CENTER', 'HANOI', 'VN', 'VIET NAM', 'http://www.hastc.org.vn/', 'HANO');
INSERT INTO `freepay_mic` VALUES ('XHAM', 'HANSEATISCHE WERTPAPIERBOERSE HAMBURG', 'HAMBURG', 'DE', 'GERMANY', 'http://www.hamburger-boerse.de/', '');
INSERT INTO `freepay_mic` VALUES ('HEGX', 'HEDGESTREET EXCHANGE', 'SAN MATEO', 'US', 'UNITED STATES OF AMERICA', 'http://www.hedgestreet.com/', '');
INSERT INTO `freepay_mic` VALUES ('XHON', 'HONDURIAN STOCK EXCHANGE, THE', 'SAN PEDRO SULA', 'HN', 'HONDURAS', 'http://www.bcv.hn/', 'BVH');
INSERT INTO `freepay_mic` VALUES ('XHKF', 'HONG KONG FUTURES EXCHANGE LTD.', 'HONG KONG', 'HK', 'HONG KONG', 'http://www.hkex.com.hk/', 'HKFE');
INSERT INTO `freepay_mic` VALUES ('XGEM', 'HONG KONG GROWTH ENTERPRISES MARKET', 'HONG KONG', 'HK', 'HONG KONG', 'http://www.hkgem.com/', 'HK G');
INSERT INTO `freepay_mic` VALUES ('BTEC', 'ICAP-BROKERTEC', 'JERSEY CITY', 'US', 'UNITED STATES OF AMERICA', 'http://www.icap.com/', '');
INSERT INTO `freepay_mic` VALUES ('XICE', 'ICELAND STOCK EXCHANGE', 'REYKJAVIK', 'IS', 'ICELAND', 'http://www.omxnordicexchange.com/', 'ICEX');
INSERT INTO `freepay_mic` VALUES ('XCOR', 'ICMA', 'LONDON', 'GB', 'UNITED KINGDOM', 'http://icma.org/', '');
INSERT INTO `freepay_mic` VALUES ('XIOM', 'INDEX AND OPTIONS MARKET', 'CHICAGO', 'US', 'UNITED STATES OF AMERICA', 'http://www.cboe.com/', 'IOM');
INSERT INTO `freepay_mic` VALUES ('CHIX', 'INSTINET CHI-X LTD.', 'LONDON', 'GB', 'UNITED KINGDOM', '', 'CHI-');
INSERT INTO `freepay_mic` VALUES ('IEPA', 'INTERCONTINENTAL EXCHANGE LTD.', 'LONDON', 'GB', 'UNITED KINGDOM', '', 'ICE');
INSERT INTO `freepay_mic` VALUES ('XIMA', 'INTERNATIONAL MARTIME EXCHANGE', 'OLSO', 'NO', 'NORWAY', 'http://www.imarex.com/', 'IMAR');
INSERT INTO `freepay_mic` VALUES ('XIMM', 'INTERNATIONAL MONETARY MARKET', 'CHICAGO', 'US', 'UNITED STATES OF AMERICA', '', '');
INSERT INTO `freepay_mic` VALUES ('XISX', 'INTERNATIONAL SECURITIES EXCHANGE, LLC.', 'NEW YORK', 'US', 'UNITED STATES OF AMERICA', 'http://www.ise.com/', 'ISE');
INSERT INTO `freepay_mic` VALUES ('XDUB', 'IRISH STOCK EXCHANGE', 'DUBLIN', 'IE', 'IRELAND', 'http://www.ise.ie/', 'ISE');
INSERT INTO `freepay_mic` VALUES ('ISEC', 'ISEC (ICEX SECOND MARKET)', 'REYKJAVIK', 'IS', 'ICELAND', '', 'ISEC');
INSERT INTO `freepay_mic` VALUES ('XISL', 'ISLAMABAD STOCK EXCHANGE', 'ISLAMABAD', 'PK', 'PAKISTAN', 'http://www.ise.com.pk/', 'ISE');
INSERT INTO `freepay_mic` VALUES ('XIAB', 'ISTANBUL GOLD EXCHANGE', 'ISTAMBUL', 'TR', 'TURKEY', 'http://www.iab.gov.tr/', 'IAB');
INSERT INTO `freepay_mic` VALUES ('XIST', 'ISTANBUL STOCK EXCHANGE', 'ISTAMBUL', 'TR', 'TURKEY', 'http://www.ise.org/', 'ISE');
INSERT INTO `freepay_mic` VALUES ('XDMI', 'ITALIAN DERIVATIVES MARKET', 'MILANO', 'IT', 'ITALY', 'http://www.borsaitaliana.it/', 'IDEM');
INSERT INTO `freepay_mic` VALUES ('ITGI', 'ITG - POSIT EXCHANGE', 'NEW YORK', 'US', 'UNITED STATES OF AMERICA', 'http://www.itginc.com/', '');
INSERT INTO `freepay_mic` VALUES ('XBBJ', 'JAKARTA FUTURES EXCHANGE (BURSA BERJANGKA JAKARTA)', 'JAKARTA', 'ID', 'INDONESIA', 'http://bbj-jfx.com/', '');
INSERT INTO `freepay_mic` VALUES ('XJNB', 'JAKARTA NEGOTIATED BOARD', 'JAKARTA', 'ID', 'INDONESIA', '', '');
INSERT INTO `freepay_mic` VALUES ('XJKT', 'JAKARTA STOCK EXCHANGE', 'JAKARTA', 'ID', 'INDONESIA', 'http://www.jsx.co.id/', '');
INSERT INTO `freepay_mic` VALUES ('XJAM', 'JAMAICA STOCK EXCHANGE, THE', 'KINGSTON', 'JM', 'JAMAICA', 'http://www.jamstockex.com/', '');
INSERT INTO `freepay_mic` VALUES ('JASR', 'JAPAN CROSS (PTS)', 'TOKYO', 'JP', 'JAPAN', '', '');
INSERT INTO `freepay_mic` VALUES ('XJAS', 'JASDAQ SECURITIES EXCHANGE', 'TOKYO', 'JP', 'JAPAN', 'http://www.jasdaq.co.jp/', 'JASD');
INSERT INTO `freepay_mic` VALUES ('XJSE', 'JSE SECURITIES EXCHANGE', 'JOHANNESBURG', 'ZA', 'SOUTH AFRICA', 'http://www.jse.co.za/', 'JSE');
INSERT INTO `freepay_mic` VALUES ('XKAC', 'KANSAI COMMODITIES EXCHANGE', 'OSAKA', 'JP', 'JAPAN', 'http://www.kanex.or.jp/', 'KANE');
INSERT INTO `freepay_mic` VALUES ('XKBT', 'KANSAS CITY BOARD OF TRADE', 'KANSAS CITY', 'US', 'UNITED STATES OF AMERICA', 'http://www.kcbt.com/', 'KCBT');
INSERT INTO `freepay_mic` VALUES ('XKAR', 'KARACHI STOCK EXCHANGE (GUARANTEE) LIMITED, THE', 'KARACHI', 'PK', 'PAKISTAN', 'http://www.kse.com.pk/', 'KSE');
INSERT INTO `freepay_mic` VALUES ('XKAZ', 'KAZAKHSTAN STOCK EXCHANGE', 'ALMA-ATA', 'KZ', 'KAZAKHSTAN', 'http://www.kase.kz/', 'KAZE');
INSERT INTO `freepay_mic` VALUES ('XKHR', 'KHARKOV COMMODITY EXCHANGE', 'KHARKOV', 'UA', 'UKRAINE', '', '');
INSERT INTO `freepay_mic` VALUES ('XKHA', 'KHARTOUM STOCK EXCHANGE', 'KHARTOUM', 'SD', 'SUDAN', 'http://www.khartoumstock.com/', 'KSE');
INSERT INTO `freepay_mic` VALUES ('XKCE', 'KHOREZM INTERREGION COMMODITY EXCHANGE', 'TASHKENT', 'UZ', 'UZBEKISTAN', '', '');
INSERT INTO `freepay_mic` VALUES ('XKIS', 'KIEV INTERNATIONAL STOCK EXCHANGE', 'KIEV', 'UA', 'UKRAINE', 'http://www.kise-ua.com/', 'KISE');
INSERT INTO `freepay_mic` VALUES ('XKIE', 'KIEV UNIVERSAL EXCHANGE', 'KIEV', 'UA', 'UKRAINE', 'http://www.kue.kiev.ua/', '');
INSERT INTO `freepay_mic` VALUES ('KOCN', 'KOREA ECN SECURITIES CO. LTD (ATS)', 'SEOUL', 'KR', 'KOREA, REPUBLIC OF', '', '');
INSERT INTO `freepay_mic` VALUES ('XKFE', 'KOREA EXCHANGE (FUTURES MARKET)', 'SEOUL', 'KR', 'KOREA, REPUBLIC OF', 'http://www.krx.co.kr/', 'KRX');
INSERT INTO `freepay_mic` VALUES ('XKOS', 'KOREA EXCHANGE (KOSDAQ)', 'SEOUL', 'KR', 'KOREA, REPUBLIC OF', '', 'KOSD');
INSERT INTO `freepay_mic` VALUES ('XKRX', 'KOREA EXCHANGE (STOCK MARKET)', 'SEOUL', 'KR', 'KOREA, REPUBLIC OF', '', 'KRX');
INSERT INTO `freepay_mic` VALUES ('XKUW', 'KUWAIT STOCK EXCHANGE', 'KUWAIT', 'KW', 'KUWAIT', 'http://www.kuwaitse.com/', '');
INSERT INTO `freepay_mic` VALUES ('XKSE', 'KYRGYZ STOCK EXCHANGE', 'BISHKEK', 'KG', 'KYRGYZSTAN', 'http://www.kse.kg/', 'KSE');
INSERT INTO `freepay_mic` VALUES ('XBCL', 'LA BOLSA ELECTRONICA DE CHILE', 'SANTIAGO', 'CL', 'CHILE', 'http://www.bolchile.cl/', 'BOLC');
INSERT INTO `freepay_mic` VALUES ('XLFX', 'LABUAN INTERNATIONAL FINANCIAL EXCHANGE', 'LABUAN', 'MY', 'MALAYSIA', 'http://lfxsys.lfx.com.my/', 'LFX');
INSERT INTO `freepay_mic` VALUES ('XLAH', 'LAHORE STOCK EXCHANGE', 'LAHORE', 'PK', 'PAKISTAN', 'http://www.lahorestock.com/', 'LSE');
INSERT INTO `freepay_mic` VALUES ('XLAT', 'LATIBEX', 'MADRID', 'ES', 'SPAIN', '', '');
INSERT INTO `freepay_mic` VALUES ('LEVL', 'LEVEL ATS', 'BOSTON', 'US', 'UNITED STATES OF AMERICA', 'http://www.levelats.com/', 'LEVE');
INSERT INTO `freepay_mic` VALUES ('XLJU', 'LJUBLJANA STOCK EXCHANGE, INC.', 'LJUBLJANA', 'SI', 'SLOVENIA', 'http://www.ljse.si/', '');
INSERT INTO `freepay_mic` VALUES ('XLBM', 'LONDON BULLION MARKET, THE', 'LONDON', 'GB', 'UNITED KINGDOM', 'http://www.lbma.org.uk/', '');
INSERT INTO `freepay_mic` VALUES ('XLME', 'LONDON METAL EXCHANGE', 'LONDON', 'GB', 'UNITED KINGDOM', 'http://www.lme.co.uk/', 'LME');
INSERT INTO `freepay_mic` VALUES ('LPPM', 'LONDON PLATINUM AND PALLADIUM MARKET', 'LONDON', 'GB', 'UNITED KINGDOM', 'http://www.lppm.org.uk/', 'LPPM');
INSERT INTO `freepay_mic` VALUES ('XLON', 'LONDON STOCK EXCHANGE, THE', 'LONDON', 'GB', 'UNITED KINGDOM', 'http://www.londonstockexchange.com/', 'LSE');
INSERT INTO `freepay_mic` VALUES ('XLTO', 'LONDON TRADED OPTIONS MARKET', 'LONDON', 'GB', 'UNITED KINGDOM', '', 'LTOM');
INSERT INTO `freepay_mic` VALUES ('XLUS', 'LUSAKA STOCK EXCHANGE', 'LUSAKA', 'ZM', 'ZAMBIA', '', '');
INSERT INTO `freepay_mic` VALUES ('XLUX', 'LUXEMBOURG STOCK EXCHANGE', 'LUXEMBOURG', 'LU', 'LUXEMBOURG', 'http://www.bourse.lu/', '');
INSERT INTO `freepay_mic` VALUES ('XMAE', 'MACEDONIAN STOCK EXCHANGE', 'SKOPJE', 'MK', 'MACEDONIA', 'http://www.mse.org.mk/', '');
INSERT INTO `freepay_mic` VALUES ('XMDS', 'MADRAS STOCK EXCHANGE', 'MADRAS', 'IN', 'INDIA', '', '');
INSERT INTO `freepay_mic` VALUES ('XMSW', 'MALAWI STOCK EXCHANGE', 'BLANTYRE', 'MW', 'MALAWI', 'http://www.mse.co.mw/', '');
INSERT INTO `freepay_mic` VALUES ('XLOF', 'MALAYSIA DERIVATIVES EXCHANGE BHD', 'KUALA LUMPUR', 'MY', 'MALAYSIA', 'http://www.mdex.com.my/', 'MDEX');
INSERT INTO `freepay_mic` VALUES ('XMAL', 'MALTA STOCK EXCHANGE', 'VALLETTA', 'MT', 'MALTA', 'http://www.borzamalta.com.mt/', '');
INSERT INTO `freepay_mic` VALUES ('XMAP', 'MAPUTO STOCK EXCHANGE', 'MAPUTO', 'MZ', 'MOZAMBIQUE', '', '');
INSERT INTO `freepay_mic` VALUES ('XMDG', 'MARCHE INTERBANCAIRE DES DEVISES M.I.D.', 'ANTANANARIVO', 'MG', 'MADAGASCAR', '', '');
INSERT INTO `freepay_mic` VALUES ('MDIP', 'MEDIP', 'LISBOA', 'PT', 'PORTUGAL', '', 'MEDI');
INSERT INTO `freepay_mic` VALUES ('XMEF', 'MEFF RENTA FIJA', 'BARCELONA', 'ES', 'SPAIN', 'http://www.meff.es/', 'MEFF');
INSERT INTO `freepay_mic` VALUES ('XMRV', 'MEFF RENTA VARIABLE', 'BARCELONA', 'ES', 'SPAIN', 'http://www.meffrv.es/', 'MEFF');
INSERT INTO `freepay_mic` VALUES ('XMTB', 'MERCADO A TERMINO DE BUENOS AIRES S.A.', 'BUENOS AIRES', 'AR', 'ARGENTINA', '', 'MAT');
INSERT INTO `freepay_mic` VALUES ('XMAB', 'MERCADO ABIERTO ELECTRONICO S.A.', 'BUENOS AIRES', 'AR', 'ARGENTINA', 'http://www.mae.com.ar/', 'MAE');
INSERT INTO `freepay_mic` VALUES ('XSRM', 'MERCADO DE FUTUROS DE ACEITE DE OLIVA, S.A.', 'JAEN', 'ES', 'SPAIN', 'http://www.mfao.es/', 'MFAO');
INSERT INTO `freepay_mic` VALUES ('XFCM', 'MERCADO DE FUTUROS Y OPCIONES SOBRE CITRICOS', 'VALENCIA', 'ES', 'SPAIN', '', 'FC A');
INSERT INTO `freepay_mic` VALUES ('XMEV', 'MERCADO DE VALORES DE BUENOS AIRES S.A.', 'BUENOS AIRES', 'AR', 'ARGENTINA', 'http://www.merval.sba.com.ar/', 'MERV');
INSERT INTO `freepay_mic` VALUES ('XEMD', 'MERCADO MEXICANO DE DERIVADOS', 'MEXICO', 'MX', 'MEXICO', 'http://www.mexder.com/', 'MEXD');
INSERT INTO `freepay_mic` VALUES ('XMCE', 'MERCATO CONTINUO ESPANOL', 'BARCELONA', 'ES', 'SPAIN', '', '');
INSERT INTO `freepay_mic` VALUES ('XMIF', 'MERCATO ITALIANO FUTURES EXCHANGE', 'MILANO', 'IT', 'ITALY', '', 'MIF');
INSERT INTO `freepay_mic` VALUES ('XBAV', 'MERCHBOLSA AGENCIA DE VALORES, S.A.', 'BARCELONA', 'ES', 'SPAIN', '', '');
INSERT INTO `freepay_mic` VALUES ('XMAC', 'MID AMERICA COMMODITY EXCHANGE', 'CHICAGO', 'US', 'UNITED STATES OF AMERICA', '', 'MIDA');
INSERT INTO `freepay_mic` VALUES ('XMGE', 'MINNEAPOLIS GRAIN EXCHANGE', 'MINNEAPOLIS', 'US', 'UNITED STATES OF AMERICA', 'http://www.mgex.com/', 'MGE');
INSERT INTO `freepay_mic` VALUES ('XMOL', 'MOLDOVA STOCK EXCHANGE', 'CHISINAU', 'MD', 'MOLDOVA, REPUBLIC OF', 'http://www.moldse.md/', '');
INSERT INTO `freepay_mic` VALUES ('XULA', 'MONGOLIAN STOCK EXCHANGE', 'ULAAN BAATAR', 'MN', 'MONGOLIA', 'http://www.mse.mn/', '');
INSERT INTO `freepay_mic` VALUES ('XMNX', 'MONTENEGRO STOCK EXCHANGE', 'MONTENEGRO', 'ME', 'MONTENEGRO, REPUBLIC OF', 'http://www.montenegroberza.com/', '');
INSERT INTO `freepay_mic` VALUES ('XMOD', 'MONTREAL EXCHANGE THE / BOURSE DE MONTREAL (OTIONS AND OTHER DERIVATIVES)', 'MONTREAL', 'CA', 'CANADA', 'http://www.m-x.ca/', 'CDE');
INSERT INTO `freepay_mic` VALUES ('XMOS', 'MOSCOW CENTRAL STOCK EXCHANGE', 'MOSCOW', 'RU', 'RUSSIA', 'http://www.mcse.ru/', 'MCSE');
INSERT INTO `freepay_mic` VALUES ('XMIC', 'MOSCOW INTERBANK CURRENCY EXCHANGE', 'MOSCOW', 'RU', 'RUSSIA', 'http://www.micex.com/', 'MICE');
INSERT INTO `freepay_mic` VALUES ('AMTS', 'MTS AMSTERDAM N.V.', 'AMSTERDAM', 'NL', 'THE NETHERLANDS', 'http://www.mtsamsterdam.com/', '');
INSERT INTO `freepay_mic` VALUES ('MTSA', 'MTS AUSTRIAN MARKET', 'LONDON', 'GB', 'UNITED KINGDOM', 'http://www.mtsaustria.com/', '');
INSERT INTO `freepay_mic` VALUES ('BMTS', 'MTS BELGIUM', 'BRUSSELS', 'BE', 'BELGIUM', 'http://www.mtsbelgium.com/', '');
INSERT INTO `freepay_mic` VALUES ('UMTS', 'MTS CEDULAS', 'LONDON', 'GB', 'UNITED KINGDOM', '', '');
INSERT INTO `freepay_mic` VALUES ('MTSD', 'MTS DENMARK', 'BRUSSELS', 'BE', 'BELGIUM', 'http://www.mtsdenmark.com/', '');
INSERT INTO `freepay_mic` VALUES ('GMTS', 'MTS DEUTSCHLAND AG', 'FRANKFURT AM MAIN', 'DE', 'GERMANY', 'http://www.mtsgermany.com/', '');
INSERT INTO `freepay_mic` VALUES ('MTSF', 'MTS FINLAND', 'BRUSSELS', 'BE', 'BELGIUM', 'http://www.mtsfinland.com/', '');
INSERT INTO `freepay_mic` VALUES ('FMTS', 'MTS FRANCE SAS', 'PARIS', 'FR', 'FRANCE', 'http://www.mtsfrance.com/', '');
INSERT INTO `freepay_mic` VALUES ('MTSG', 'MTS GREEK MARKET', 'LONDON', 'GB', 'UNITED KINGDOM', 'http://www.mtsgreece.com/', '');
INSERT INTO `freepay_mic` VALUES ('IMTS', 'MTS IRELAND', 'LONDON', 'GB', 'UNITED KINGDOM', 'http://www.mtsireland.com/', '');
INSERT INTO `freepay_mic` VALUES ('MTSP', 'MTS POLAND', 'WARSAW', 'PL', 'POLAND', 'http://www.mtspoland.com/', '');
INSERT INTO `freepay_mic` VALUES ('PMTS', 'MTS PORTUGAL SGMR, SA', 'LISBOA', 'PT', 'PORTUGAL', 'http://www.mtsportugal.com/', '');
INSERT INTO `freepay_mic` VALUES ('QMTS', 'MTS QUASI GOVERNMENT', 'LONDON', 'GB', 'UNITED KINGDOM', '', '');
INSERT INTO `freepay_mic` VALUES ('MTSC', 'MTS S.P.A.', 'ROMA', 'IT', 'ITALY', 'http://www.mtsspa.it/', 'MTS');
INSERT INTO `freepay_mic` VALUES ('SMTS', 'MTS SPAIN, S.A.', 'MADRID', 'ES', 'SPAIN', 'http://www.mtsspain.com/', '');
INSERT INTO `freepay_mic` VALUES ('CETO', 'MTS-CeTO S.A.', 'WARSAW', 'PL', 'POLAND', 'http://www.mts-ceto.pl/', '');
INSERT INTO `freepay_mic` VALUES ('XIMC', 'MULTI COMMODITY EXCHANGE OF INDIA LTD.', 'MUMBAI', 'IN', 'INDIA', 'http://www.mcxindia.com/', 'MCX');
INSERT INTO `freepay_mic` VALUES ('XBOM', 'MUMBAI STOCK EXCHANGE', 'MUMBAI', 'IN', 'INDIA', 'http://www.bseindia.com/', 'MSE');
INSERT INTO `freepay_mic` VALUES ('XMUS', 'MUSCAT SECURITIES MARKET', 'MUSCAT', 'OM', 'OMAN', 'http://www.msm.gov.om/', 'MSM');
INSERT INTO `freepay_mic` VALUES ('XNGO', 'NAGOYA STOCK EXCHANGE', 'NAGOYA', 'JP', 'JAPAN', 'http://www.nse.or.jp/', 'NSE');
INSERT INTO `freepay_mic` VALUES ('XNAI', 'NAIROBI STOCK EXCHANGE', 'NAIROBI', 'KE', 'KENYA', 'http://nse.co.ke/', '');
INSERT INTO `freepay_mic` VALUES ('XNAM', 'NAMIBIAN STOCK EXCHANGE', 'WINDHOEK', 'NA', 'NAMIBIA', 'http://www.nsx.com.na/', '');
INSERT INTO `freepay_mic` VALUES ('XNAS', 'NASDAQ', 'NEW YORK', 'US', 'UNITED STATES OF AMERICA', 'http://www.nasdaq.com/', 'NASD');
INSERT INTO `freepay_mic` VALUES ('XNGS', 'NASDAQ/NGS (GLOBAL SELECT MARKET)', 'NEW YORK', 'US', 'UNITED STATES OF AMERICA', '', 'NGS');
INSERT INTO `freepay_mic` VALUES ('XNMS', 'NASDAQ/NMS (GLOBAL MARKET)', 'NEW YORK', 'US', 'UNITED STATES OF AMERICA', '', '');
INSERT INTO `freepay_mic` VALUES ('XNCD', 'NATIONAL COMMODITY AND DERIVATIVES EXCHANGE LTD.', 'MUMBAI', 'IN', 'INDIA', 'http://www.ncdex.com/', 'NCDE');
INSERT INTO `freepay_mic` VALUES ('XCIS', 'NATIONAL STOCK EXCHANGE', 'CHICAGO', 'US', 'UNITED STATES OF AMERICA', 'http://www.nsx.com/', '');
INSERT INTO `freepay_mic` VALUES ('XNSE', 'NATIONAL STOCK EXCHANGE OF INDIA', 'MUMBAI', 'IN', 'INDIA', 'http://www.nseindia.com/', 'NSE');
INSERT INTO `freepay_mic` VALUES ('XLIT', 'NATIONAL STOCK EXCHANGE OF LITHUANIA', 'VILNIUS', 'LT', 'LITHUANIA', 'http://www.lt.omxgroup.com/', '');
INSERT INTO `freepay_mic` VALUES ('XNEP', 'NEPAL STOCK EXCHANGE', 'KATHMANDU', 'NP', 'NEPAL', 'http://www.nepalstock.com/', '');
INSERT INTO `freepay_mic` VALUES ('NMTS', 'NEW EUROMTS', ' LONDON', 'GB', 'UNITED KINGDOM', 'http://www.neweuromts-ltd.com/', '');
INSERT INTO `freepay_mic` VALUES ('XNYF', 'NEW YORK BOARD OF TRADE', 'NEW YORK', 'US', 'UNITED STATES OF AMERICA', 'http://www.nybot.com/', 'NYBO');
INSERT INTO `freepay_mic` VALUES ('XNYM', 'NEW YORK MERCANTILE EXCHANGE', 'NEW YORK', 'US', 'UNITED STATES OF AMERICA', 'http://www.nymex.com/', 'NYME');
INSERT INTO `freepay_mic` VALUES ('XNYS', 'NEW YORK STOCK EXCHANGE, INC.', 'NEW YORK', 'US', 'UNITED STATES OF AMERICA', 'http://www.nyse.com/', 'NYSE');
INSERT INTO `freepay_mic` VALUES ('XNEE', 'NEW ZEALAND FUTURES AND OPTIONS EXCHANGE', 'AUCKLAND', 'NZ', 'NEW ZEALAND', 'http://www.asx.com.au/', 'NZFO');
INSERT INTO `freepay_mic` VALUES ('XNZE', 'NEW ZEALAND STOCK EXCHANGE', 'WELLINGTON', 'NZ', 'NEW ZEALAND', 'http://www.nzx.com/', 'NZSE');
INSERT INTO `freepay_mic` VALUES ('XNEW', 'NEWEX', 'FRANKFURT AM MAIN', 'DE', 'GERMANY', 'http://www.newex.com/', 'NEWE');
INSERT INTO `freepay_mic` VALUES ('XHAN', 'NIEDERSAECHSISCHE BOERSE ZU HANNOVER', 'HANNOVER', 'DE', 'GERMANY', 'http://www.boersenag.de/', '');
INSERT INTO `freepay_mic` VALUES ('XNSA', 'NIGERIAN STOCK EXCHANGE,THE', 'LAGOS', 'NG', 'NIGERIA', 'http://www.nigerianstockexchange.com/', '');
INSERT INTO `freepay_mic` VALUES ('XHER', 'NIPPON NEW MARKET - HERCULES', 'OSAKA', 'JP', 'JAPAN', 'http://hercules.ose.or.jp/', 'HERC');
INSERT INTO `freepay_mic` VALUES ('NNCS', 'NIZHNY NOVGOROD CURRENCY AND STOCK EXCHANGE CLOSE JOINT STOCK COMPANY', 'NIZHNIY NOVGOROD', 'RU', 'RUSSIA', 'http://www.nnx.ru/', 'NCSE');
INSERT INTO `freepay_mic` VALUES ('XXXX', 'NO MARKET (EG, UNLISTED)', '', '', '', '', '');
INSERT INTO `freepay_mic` VALUES ('NORX', 'NORD POOL', 'OLSO', 'NO', 'NORWAY', 'http://www.nordpool.com/', '');
INSERT INTO `freepay_mic` VALUES ('XNGM', 'NORDIC GROWTH MARKET', 'STOCKHOLM', 'SE', 'SWEDEN', 'http://www.ngm.se/', 'NGM');
INSERT INTO `freepay_mic` VALUES ('XNQL', 'NQLX', 'NEW YORK', 'US', 'UNITED STATES OF AMERICA', 'http://www.nasdaq.com/', 'NQLX');
INSERT INTO `freepay_mic` VALUES ('NYMX', 'NYMEX EUROPE LTD.', 'LONDON', 'GB', 'UNITED KINGDOM', 'http://www.nymexeurope.co.uk/', '');
INSERT INTO `freepay_mic` VALUES ('ARCX', 'NYSE ARCA', 'NEW YORK', 'US', 'UNITED STATES OF AMERICA', 'http://www.nyse.com/', '');
INSERT INTO `freepay_mic` VALUES ('XODE', 'ODESSA COMMODITY EXCHANGE', 'ODESSA', 'UA', 'UKRAINE', '', '');
INSERT INTO `freepay_mic` VALUES ('XOTB', 'OESTERREICHISCHE TERMIN- UND OPTIONENBOERSE, CLEARING BANK AG', 'VIENNA', 'AT', 'AUSTRIA', '', 'OTOB');
INSERT INTO `freepay_mic` VALUES ('XOMF', 'OM FIXED INTEREST EXCHANGE', 'STOCKHOLM', 'SE', 'SWEDEN', '', 'OM');
INSERT INTO `freepay_mic` VALUES ('XOME', 'OM STOCKHOLM EXCHANGE', 'STOCKHOLM', 'SE', 'SWEDEN', 'http://www.omxgroup.com/', 'OM');
INSERT INTO `freepay_mic` VALUES ('XOCH', 'ONECHICAGO, LLC.', 'CHICAGO', 'US', 'UNITED STATES OF AMERICA', 'http://www.onechicago.com/', '');
INSERT INTO `freepay_mic` VALUES ('XOSM', 'OSAKA MERCANTILE EXCHANGE', 'OSAKA', 'JP', 'JAPAN', '', 'OME');
INSERT INTO `freepay_mic` VALUES ('XOSE', 'OSAKA SECURITIES EXCHANGE', 'OSAKA', 'JP', 'JAPAN', 'http://www.ose.or.jp/', 'OSE');
INSERT INTO `freepay_mic` VALUES ('XOSJ', 'OSAKA SECURITIES EXCHANGE J-NET', 'OSAKA', 'JP', 'JAPAN', '', 'J-NE');
INSERT INTO `freepay_mic` VALUES ('XOAS', 'OSLO AXESS', 'OLSO', 'NO', 'NORWAY', 'http://www.osloaxess.no/', '');
INSERT INTO `freepay_mic` VALUES ('XOSL', 'OSLO BORS', 'OLSO', 'NO', 'NORWAY', 'http://www.oslobors.no/', '');
INSERT INTO `freepay_mic` VALUES ('XOTC', 'OTC BULLETIN BOARD', 'WASHINGTON', 'US', 'UNITED STATES OF AMERICA', 'http://www.otcbb.com/', 'OTCB');
INSERT INTO `freepay_mic` VALUES ('OTCX', 'OTC EXCHANGE OF INDIA', 'MUMBAI', 'IN', 'INDIA', 'http://www.otcei.net/', 'OTCE');
INSERT INTO `freepay_mic` VALUES ('XPAE', 'PALESTINE SECURITIES EXCHANGE', 'NABLUS', 'PS', 'PALESTINIAN TERRITORY, OCCUPIED', 'http://www.p-s-e.com/', 'PSE');
INSERT INTO `freepay_mic` VALUES ('OPEX', 'PEX-PRIVATE EXCHANGE', 'LISBOA', 'PT', 'PORTUGAL', 'http://www.opex.pt/', 'OPEX');
INSERT INTO `freepay_mic` VALUES ('XPBT', 'PHILADELPHIA BOARD OF TRADE', 'PHILADELPHIA', 'US', 'UNITED STATES OF AMERICA', 'http://www.phlx.com/', 'PBOT');
INSERT INTO `freepay_mic` VALUES ('XPHO', 'PHILADELPHIA OPTIONS EXCHANGE', 'PHILADELPHIA', 'US', 'UNITED STATES OF AMERICA', 'http://www.phlx.com/', '');
INSERT INTO `freepay_mic` VALUES ('XPHL', 'PHILADELPHIA STOCK EXCHANGE', 'PHILADELPHIA', 'US', 'UNITED STATES OF AMERICA', 'http://www.phlx.com/', 'PHLX');
INSERT INTO `freepay_mic` VALUES ('XPHS', 'PHILIPPINE STOCK EXCHANGE, INC.', 'PASIG-CITY', 'PH', 'PHILIPPINE', 'http://www.pse.org.ph/', 'PSE');
INSERT INTO `freepay_mic` VALUES ('PINX', 'PINK SHEETS LLC (NQB)', 'NEW YORK', 'US', 'UNITED STATES OF AMERICA', 'http://www.pinksheets.com/', '');
INSERT INTO `freepay_mic` VALUES ('PIPE', 'PIPELINE', 'NEW YORK', 'US', 'UNITED STATES OF AMERICA', 'http://www.pipelinetrading.com/', '');
INSERT INTO `freepay_mic` VALUES ('XPLU', 'PLUS MARKETS GROUP', 'LONDON', 'GB', 'UNITED KINGDOM', 'http://www.plusmarketsgroup.com/', 'PLUS');
INSERT INTO `freepay_mic` VALUES ('XPOM', 'PORT MORESBY STOCK EXCHANGE', 'PORT MORESBY', 'PG', 'PAPUA NEW GUINEA', 'http://www.pomsox.com.pg/', '');
INSERT INTO `freepay_mic` VALUES ('XPOR', 'PORTAL', 'WASHINGTON', 'US', 'UNITED STATES OF AMERICA', 'http://www.nasdaqportalmarket.com/', '');
INSERT INTO `freepay_mic` VALUES ('XPOW', 'POWERNEXT', 'PARIS', 'FR', 'FRANCE', 'http://www.powernext.fr/', '');
INSERT INTO `freepay_mic` VALUES ('XPRI', 'PRIDNEPROVSK COMMODITY EXCHANGE', 'PRIDNEPROVSK', 'UA', 'UKRAINE', '', '');
INSERT INTO `freepay_mic` VALUES ('PURE', 'PURE TRADING', 'TORONTO', 'CA', 'CANADA', 'http://www.puretrading.ca/', '');
INSERT INTO `freepay_mic` VALUES ('XQUI', 'QUITO STOCK EXCHANGE', 'QUITO', 'EC', 'ECUADOR', 'http://www.ccbvq.com/', '');
INSERT INTO `freepay_mic` VALUES ('XRAS', 'RASDAQ', 'BUCHAREST', 'RO', 'ROMANIA', 'http://www.bvb.ro/', 'RASD');
INSERT INTO `freepay_mic` VALUES ('XDUS', 'RHEINISCHE-WESTFALISCHE BOERSE ZU DÜSSELDORF', 'DUESSELDORF', 'DE', 'GERMANY', 'http://www.boerse-duesseldorf.de/', '');
INSERT INTO `freepay_mic` VALUES ('XRIS', 'RIGA STOCK EXCHANGE,THE', 'RIGA', 'LV', 'LATVIA', 'http://www.lv.omxgroup.com/', '');
INSERT INTO `freepay_mic` VALUES ('XRBM', 'RINGGIT BOND MARKET', 'KUALA LUMPUR', 'MY', 'MALAYSIA', 'http://rmbond.bnm.gov.my/', 'RBM');
INSERT INTO `freepay_mic` VALUES ('XRMZ', 'RM-SYSTEM A.S.', 'PRAGUE', 'CZ', 'CZECH REPUBLIC', 'http://www.rmsystem.cz/', 'RMS');
INSERT INTO `freepay_mic` VALUES ('XBRM', 'ROMANIAN COMMODITIES EXCHANGE', 'BUCHAREST', 'RO', 'ROMANIA', 'http://www.brm.ro/', 'BRM');
INSERT INTO `freepay_mic` VALUES ('XROV', 'ROSTOV CURRENCY AND STOCK EXCHANGE', 'ROSTOV', 'RU', 'RUSSIA', '', 'RCSE');
INSERT INTO `freepay_mic` VALUES ('XRTR', 'RTR (REUTERS-REALTIME-DATEN)', 'FRANKFURT AM MAIN', 'DE', 'GERMANY', '', 'RTR');
INSERT INTO `freepay_mic` VALUES ('RTSX', 'RTS STOCK EXCHANGE', 'MOSCOW', 'RU', 'RUSSIA', 'http://www.rts.ru/', 'RTS');
INSERT INTO `freepay_mic` VALUES ('XRUS', 'RUSSIAN EXCHANGE, THE', 'MOSCOW', 'RU', 'RUSSIA', 'http://www.rts.ru/', 'NDX');
INSERT INTO `freepay_mic` VALUES ('XPIC', 'SAINT PETERSBURG CURRENCY EXCHANGE', 'SAINT-PETERSBURG', 'RU', 'RUSSIA', 'http://www.spcex.ru/', 'SPSE');
INSERT INTO `freepay_mic` VALUES ('XSAM', 'SAMARA CURRENCY INTERBANK EXCHANGE', 'SAMARA', 'RU', 'RUSSIA', 'http://www.micex.com/', 'SCIE');
INSERT INTO `freepay_mic` VALUES ('XSGO', 'SANTIAGO STOCK EXCHANGE', 'SANTIAGO', 'CL', 'CHILE', 'http://www.bolsadesantiago.com/', '');
INSERT INTO `freepay_mic` VALUES ('XSAP', 'SAPPORO SECURITIES EXCHANGE', 'SAPPORO', 'JP', 'JAPAN', '', '');
INSERT INTO `freepay_mic` VALUES ('XSAU', 'SAUDI ARABIA STOCK EXCHANGE', 'RIJAD', 'SA', 'SAUDI ARABIA', 'http://www.tadawul.com.sa/', '');
INSERT INTO `freepay_mic` VALUES ('BMFM', 'SC BURSA MONETAR-FINANCIERA SI DE MARFURI SIBIU', 'SIBIU', 'RO', 'ROMANIA', '', 'BMFM');
INSERT INTO `freepay_mic` VALUES ('XSGE', 'SHANGHAI FUTURES EXCHANGE', 'SHANGHAI', 'CN', 'CHINA', 'http://www.shfe.com.cn/', 'SHFE');
INSERT INTO `freepay_mic` VALUES ('SGEX', 'SHANGHAI GOLD EXCHANGE', 'SHANGHAI', 'CN', 'CHINA', 'http://www.sge.sh/', 'SGE');
INSERT INTO `freepay_mic` VALUES ('XSHG', 'SHANGHAI STOCK EXCHANGE', 'SHANGHAI', 'CN', 'CHINA', 'http://www.sse.com.cn/', '');
INSERT INTO `freepay_mic` VALUES ('XSME', 'SHENZHEN MERCANTILE EXCHANGE', 'SHENZHEN', 'CN', 'CHINA', '', '');
INSERT INTO `freepay_mic` VALUES ('XSHE', 'SHENZHEN STOCK EXCHANGE', 'SHENZHEN', 'CN', 'CHINA', 'http://www.szse.cn/', '');
INSERT INTO `freepay_mic` VALUES ('XSIC', 'SIBERIAN INTERBANK CURRENCY EXCHANGE', 'NOVOSIBIRSK', 'RU', 'RUSSIA', 'http://www.sice.ru/', 'SICE');
INSERT INTO `freepay_mic` VALUES ('XSIB', 'SIBERIAN STOCK EXCHANGE', 'NOVOSIBIRSK', 'RU', 'RUSSIA', '', 'SIME');
INSERT INTO `freepay_mic` VALUES ('XSCE', 'SINGAPORE COMMODITY EXCHANGE', 'SINGAPORE', 'SG', 'SINGAPORE', 'http://www.sicom.com.sg/', 'SICO');
INSERT INTO `freepay_mic` VALUES ('XSES', 'SINGAPORE EXCHANGE', 'SINGAPORE', 'SG', 'SINGAPORE', 'http://www.ses.com.sg/', 'SGX');
INSERT INTO `freepay_mic` VALUES ('XSIM', 'SINGAPORE EXCHANGE DERIVATIVES CLEARING LIMITED', 'SINGAPORE', 'SG', 'SINGAPORE', '', 'SGX-');
INSERT INTO `freepay_mic` VALUES ('XRMS', 'SK RM-S (SLOVAK STOCK EXCHANGE)', 'BRATISLAVA', 'SK', 'SLOVAKIA', '', 'SK R');
INSERT INTO `freepay_mic` VALUES ('XSOM', 'SOCIEDADE OPERADORA DO MERCADO DE ATIVOS S.A.', 'RIO DE JANEIRO', 'BR', 'BRAZIL', '', 'SOMA');
INSERT INTO `freepay_mic` VALUES ('XFMN', 'SOCIETE DU NOUVEAU MARCHE', 'PARIS', 'FR', 'FRANCE', '', '');
INSERT INTO `freepay_mic` VALUES ('XSAF', 'SOUTH AFRICAN FUTURES EXCHANGE', 'JOHANNESBURG', 'ZA', 'SOUTH AFRICA', 'http://www.safex.co.za/', 'SAFE');
INSERT INTO `freepay_mic` VALUES ('XSFA', 'SOUTH AFRICAN FUTURES EXCHANGE - AGRICULTURAL MARKET DIVISION', 'JOHANNESBURG', 'ZA', 'SOUTH AFRICA', 'http://www.safex.co.za/', '');
INSERT INTO `freepay_mic` VALUES ('XSPS', 'SOUTH PACIFIC STOCK EXCHANGE', 'SUVA', 'FJ', 'FIJI', 'http://www.spse.com.fj/', 'SPSE');
INSERT INTO `freepay_mic` VALUES ('XPET', 'ST PETERSBURG STOCK EXCHANGE', 'SAINT-PETERSBURG', 'RU', 'RUSSIA', 'http://www.spbex.ru/', 'SPBE');
INSERT INTO `freepay_mic` VALUES ('XHKG', 'STOCK EXCHANGE OF HONG KONG LTD, THE', 'HONG KONG', 'HK', 'HONG KONG', 'http://www.hkex.com.hk/', 'SEHK');
INSERT INTO `freepay_mic` VALUES ('XMAU', 'STOCK EXCHANGE OF MAURITIUS LTD, THE', 'PORT LOUIS', 'MU', 'MAURITIUS', 'http://www.stockexchangeofmauritius.com/', '');
INSERT INTO `freepay_mic` VALUES ('XNEC', 'STOCK EXCHANGE OF NEWCASTLE LTD', 'NEWCASTLE', 'AU', 'AUSTRALIA', 'http://www.nsxa.com.au/', 'NSX');
INSERT INTO `freepay_mic` VALUES ('XBKK', 'STOCK EXCHANGE OF THAILAND', 'BANGKOK', 'TH', 'THAILAND', 'http://www.set.or.th/', 'SET');
INSERT INTO `freepay_mic` VALUES ('XBKF', 'STOCK EXCHANGE OF THAILAND - FOREIGN BOARD', 'BANGKOK', 'TH', 'THAILAND', 'http://www.set.or.th/', 'SET');
INSERT INTO `freepay_mic` VALUES ('XPRA', 'STOCK EXCHANGE PRAGUE CO. LTD, THE', 'PRAGUE', 'CZ', 'CZECH REPUBLIC', '', 'PSE');
INSERT INTO `freepay_mic` VALUES ('XSUR', 'SURABAYA STOCK EXCHANGE', 'SURABAYA', 'ID', 'INDONESIA', 'http://www.bes.co.id/', '');
INSERT INTO `freepay_mic` VALUES ('XSWA', 'SWAZILAND STOCK EXCHANGE', 'MBABANE', 'SZ', 'SWAZILAND', 'http://www.ssx.org.sz/', 'SSX');
INSERT INTO `freepay_mic` VALUES ('XSWX', 'SWISS EXCHANGE', 'ZURICH', 'CH', 'SWITZERLAND', 'http://www.swx.com/', 'SWX');
INSERT INTO `freepay_mic` VALUES ('XQMH', 'SWX QUOTEMATCH AG', 'ZURICH', 'CH', 'SWITZERLAND', 'http://www.swx.com/', '');
INSERT INTO `freepay_mic` VALUES ('XSFE', 'SYDNEY FUTURES EXCHANGE LIMITED', 'SYDNEY', 'AU', 'AUSTRALIA', 'http://www.sfe.com.au/', 'SFE');
INSERT INTO `freepay_mic` VALUES ('XTAF', 'TAIWAN FUTURES EXCHANGE', 'TAIPEI', 'TW', 'TAIWAN', 'http://www.taifex.com.tw/', 'TAIF');
INSERT INTO `freepay_mic` VALUES ('XIME', 'TAIWAN INTERNATIONAL MERCANTILE EXCHANGE', 'TAIPEI', 'TW', 'TAIWAN', '', 'TAIM');
INSERT INTO `freepay_mic` VALUES ('XTAI', 'TAIWAN STOCK EXCHANGE', 'TAIPEI', 'TW', 'TAIWAN', 'http://www.tse.com.tw/', 'TSEC');
INSERT INTO `freepay_mic` VALUES ('XTAL', 'TALLINN STOCK EXCHANGE', 'TALLINN', 'EE', 'ESTONIA', 'http://www.ee.omxgroup.com/', '');
INSERT INTO `freepay_mic` VALUES ('XTEH', 'TEHERAN STOCK EXCHANGE', 'TEHERAN', 'IR', 'IRAN', 'http://www.tse.ir/', '');
INSERT INTO `freepay_mic` VALUES ('XTAE', 'TEL AVIV STOCK EXCHANGE', 'TEL AVIV', 'IL', 'ISRAEL', 'http://www.tase.co.il/', 'TASE');
INSERT INTO `freepay_mic` VALUES ('TFEX', 'THAILAND FUTURES EXCHANGE', 'BANGKOK', 'TH', 'THAILAND', 'http://www.tfex.co.th/', 'TFEX');
INSERT INTO `freepay_mic` VALUES ('XBRT', 'THE BRUT ECN', 'NEW YORK', 'US', 'UNITED STATES OF AMERICA', '', 'BRUT');
INSERT INTO `freepay_mic` VALUES ('XCIE', 'THE CHANNEL ISLANDS STOCK EXCHANGE', 'ST. PETER PORT', 'GG', 'GUERNSEY, C.I.', 'http://www.cisx.com/', 'CISX');
INSERT INTO `freepay_mic` VALUES ('XCGS', 'THE CHINESE GOLD AND SILVER EXCHANGE SOCIETY', 'HONG KONG', 'HK', 'HONG KONG', 'http://www.cgse.com.hk/', '');
INSERT INTO `freepay_mic` VALUES ('XHEL', 'THE HELSINKI STOCK EXCHANGE', 'HELSINKI', 'FI', 'FINLAND', 'http://www.omxgroup.com/', '');
INSERT INTO `freepay_mic` VALUES ('XIQS', 'THE IRAK STOCK EXCHANGE', 'BAGHDAD', 'IQ', 'IRAQ', 'http://www.isx-iq.net/', 'ISX');
INSERT INTO `freepay_mic` VALUES ('ICEL', 'THE ISLAND ECN LTD.', 'NEW YORK', 'US', 'UNITED STATES OF AMERICA', '', '');
INSERT INTO `freepay_mic` VALUES ('XLCE', 'THE LONDON COMMODITY EXCHANGE', 'LONDON', 'GB', 'UNITED KINGDOM', 'http://www.euronext.com/', 'LCE');
INSERT INTO `freepay_mic` VALUES ('NOTC', 'THE NORWEGIAN OVER THE COUNTER MARKET', 'OLSO', 'NO', 'NORWAY', 'http://www.nfmf.no/', 'NOTC');
INSERT INTO `freepay_mic` VALUES ('THRD', 'THE THIRD MARKET CORPORATION', 'CHICAGO', 'US', 'UNITED STATES OF AMERICA', 'http://www.onthespotsolutions.com/websites/ThirdMarket/eTHRD.com/', 'ETHR');
INSERT INTO `freepay_mic` VALUES ('XCUE', 'THE UZBEKISTAN REPUBLICAN CURRENCY EXCHANGE', 'TASHKENT', 'UZ', 'UZBEKISTAN', '', '');
INSERT INTO `freepay_mic` VALUES ('XTRZ', 'THE ZAGREB MONEY AND SHORT TERM SECURITIES MARKET INC.', 'ZAGREB', 'HR', 'CROATIA', 'http://trzistenovca.hr/', '');
INSERT INTO `freepay_mic` VALUES ('XTIR', 'TIRANA STOCK EXCHANGE', 'TIRANA', 'AL', 'ALBANIA', 'http://www.tse.com.al/', '');
INSERT INTO `freepay_mic` VALUES ('XTFF', 'TOKYO INTERNATIONAL FINANCIAL FUTURES EXCHANGE, THE', 'TOKYO', 'JP', 'JAPAN', 'http://www.tfx.co.jp/', 'TIFF');
INSERT INTO `freepay_mic` VALUES ('XTKT', 'TOKYO KOGYOIN TORIHIKIJO (COMMODITY EXCHANGE)', 'TOKYO', 'JP', 'JAPAN', '', 'TOCO');
INSERT INTO `freepay_mic` VALUES ('XTKO', 'TOKYO KOKUMOTSU SHOHIN TORIHIKIJO (GRAIN EXCHANGE)', 'TOKYO', 'JP', 'JAPAN', '', 'TGE');
INSERT INTO `freepay_mic` VALUES ('XTKS', 'TOKYO STOCK EXCHANGE', 'TOKYO', 'JP', 'JAPAN', 'http://www.tse.or.jp/', 'TSE');
INSERT INTO `freepay_mic` VALUES ('XTK1', 'TOKYO STOCK EXCHANGE - TOSTNET-1', 'TOKYO', 'JP', 'JAPAN', '', '');
INSERT INTO `freepay_mic` VALUES ('XTK2', 'TOKYO STOCK EXCHANGE - TOSTNET-2', 'TOKYO', 'JP', 'JAPAN', '', '');
INSERT INTO `freepay_mic` VALUES ('XTSE', 'TORONTO STOCK EXCHANGE', 'TORONTO', 'CA', 'CANADA', 'http://www.tsx.com/', 'TSE');
INSERT INTO `freepay_mic` VALUES ('XGAT', 'TRADEGATE AG', 'BERLIN', 'DE', 'GERMANY', 'http://www.tradegate.de/', '');
INSERT INTO `freepay_mic` VALUES ('TREU', 'TRADEWEB EUROPE LIMITED', 'LONDON', 'GB', 'UNITED KINGDOM', '', '');
INSERT INTO `freepay_mic` VALUES ('TRWB', 'TRADEWEB LLC', 'JERSEY CITY', 'US', 'UNITED STATES OF AMERICA', 'http://www.tradeweb.com/', '');
INSERT INTO `freepay_mic` VALUES ('TLAB', 'TRADINGLAB TLX', 'MILANO', 'IT', 'ITALY', 'http://www.tradinglab.co.uk/', 'TLX');
INSERT INTO `freepay_mic` VALUES ('XTRN', 'TRINIDAD AND TOBAGO STOCK EXCHANGE', 'PORT OF SPAIN', 'TT', 'TRINIDAD AND TOBAGO', 'http://stockex.co.tt/', 'TTSE');
INSERT INTO `freepay_mic` VALUES ('XTSX', 'TSX VENTURE EXCHANGE', 'TORONTO', 'CA', 'CANADA', 'http://www.tsx.com/', 'TSX');
INSERT INTO `freepay_mic` VALUES ('XTNX', 'TSX VENTURE EXCHANGE - NEX', 'VANCOUVER', 'CA', 'CANADA', 'http://www.tsx.com/en/nex/', 'NEX');
INSERT INTO `freepay_mic` VALUES ('XTUR', 'TURKISH DERIVATIVES EXCHANGE', 'IZMIR', 'TR', 'TURKEY', 'http://www.turkdex.org.tr/', 'TURK');
INSERT INTO `freepay_mic` VALUES ('XUGA', 'UGANDA SECURITIES EXCHANGE', 'KAMPALA', 'UG', 'UGANDA', 'http://www.use.or.ug/', 'USE');
INSERT INTO `freepay_mic` VALUES ('XUAX', 'UKRAINIAN STOCK EXCHANGE', 'KIEV', 'UA', 'UKRAINE', 'http://www.ukrse.kiev.ua/', 'UKRS');
INSERT INTO `freepay_mic` VALUES ('XUKR', 'UKRAINIAN UNIVERSAL COMMODITY EXCHANGE', 'KIEV', 'UA', 'UKRAINE', 'http://www.minagro.gov.ua/', '');
INSERT INTO `freepay_mic` VALUES ('URCE', 'URALS REGIONAL CURRENCY EXCHANGE', 'EKATERINBURG', 'RU', 'RUSSIA', 'http://www.urvb.ru/', 'URCE');
INSERT INTO `freepay_mic` VALUES ('XEUS', 'US FUTURES EXCHANGE', 'CHICAGO', 'US', 'UNITED STATES OF AMERICA', 'http://www.usfe.com/', '');
INSERT INTO `freepay_mic` VALUES ('XSTE', 'UZBEKISTAN STOCK EXCHANGE', 'TASHKENT', 'UZ', 'UZBEKISTAN', '', 'UZSE');
INSERT INTO `freepay_mic` VALUES ('XVAR', 'VARAZDIN STOCK EXCHANGE, THE', 'VARAZDIN', 'HR', 'CROATIA', 'http://www.vse.hr/', 'VSE');
INSERT INTO `freepay_mic` VALUES ('XVES', 'VESTIMA+', 'LUXEMBOURG', 'LU', 'LUXEMBOURG', 'http://www.clearstream.com/ci/dispatch/en/kir/ci_nav/5_technology/040_asp/030_vestima', '');
INSERT INTO `freepay_mic` VALUES ('XSTC', 'VIETNAM STOCK EXCHANGE', 'HO CHI MINH CITY', 'VN', 'VIET NAM', 'http://www.vietstock.com.vn/', '');
INSERT INTO `freepay_mic` VALUES ('XVTX', 'VIRT-X', 'LONDON', 'GB', 'UNITED KINGDOM', 'http://www.virt-x.com/', 'VIRT');
INSERT INTO `freepay_mic` VALUES ('XVLA', 'VLADIVOSTOK (RUSSIA) STOCK EXCHANGE', 'VLADIVOSTOK', 'RU', 'RUSSIA', '', 'VSX');
INSERT INTO `freepay_mic` VALUES ('XHCE', 'WARENTERMINBOERSE HANNOVER', 'HANNOVER', 'DE', 'GERMANY', 'http://www.wtb-hannover.de/', '');
INSERT INTO `freepay_mic` VALUES ('XWAR', 'WARSAW STOCK EXCHANGE', 'WARSAW', 'PL', 'POLAND', 'http://www.gpw.com.pl/', 'WSE');
INSERT INTO `freepay_mic` VALUES ('XWBO', 'WIENER BOERSE AG', 'VIENNA', 'AT', 'AUSTRIA', 'http://www.wienerborse.at/', 'WBAG');
INSERT INTO `freepay_mic` VALUES ('XWCE', 'WINNIPEG COMMODITY EXCHANGE, THE', 'WINNIPEG', 'CA', 'CANADA', 'http://www.wce.ca/', 'WCE');
INSERT INTO `freepay_mic` VALUES ('XTRA', 'XTRAMARKED', 'COPENHAGEN', 'DK', 'DENMARK', 'http://www.xtramarked.dk/', '');
INSERT INTO `freepay_mic` VALUES ('YLDX', 'YIELD-X', 'JOHANNESBURG', 'ZA', 'SOUTH AFRICA', 'http://www.yieldx.co.za/', '');
INSERT INTO `freepay_mic` VALUES ('XYIE', 'YIELDBROKER PTY LTD', 'SYDNEY', 'AU', 'AUSTRALIA', 'http://www.yieldbroker.com/', '');
INSERT INTO `freepay_mic` VALUES ('XZAG', 'ZAGREB STOCK EXCHANGE, THE', 'ZAGREB', 'HR', 'CROATIA', 'http://www.zse.hr/', '');
INSERT INTO `freepay_mic` VALUES ('XZCE', 'ZHENGZHOU COMMODITY EXCHANGE', 'ZHENGZHOU', 'CN', 'CHINA', 'http://english.czce.com.cn/', 'ZCE');
INSERT INTO `freepay_mic` VALUES ('XZIM', 'ZIMBABWE STOCK EXCHANGE', 'HARARE', 'ZW', 'ZIMBABWE', 'http://www.zse.co.zw/', '');
INSERT INTO `freepay_mic` VALUES ('ZOBX', 'ZOBEX', 'BERLIN', 'DE', 'GERMANY', '', 'ZOBE');

-- --------------------------------------------------------

-- 
-- Structure de la table `freepay_nna`
-- 

CREATE TABLE `freepay_nna` (
  `CodePays` char(2) NOT NULL default '',
  `NomAgence` varchar(100) NOT NULL default '',
  `NomVille` varchar(40) NOT NULL default '',
  `NomPays` varchar(40) NOT NULL default '',
  `URLAgence` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`CodePays`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Contenu de la table `freepay_nna`
-- 

INSERT INTO `freepay_nna` VALUES ('AA', 'ANNA Secretariat', 'Brussels', 'Belgium', 'http://www.anna-web.com/');
INSERT INTO `freepay_nna` VALUES ('AR', 'Caja de Valores S.A.', 'Buenos Aires', 'Argentina', 'http://www.cajval.sba.com.ar/');
INSERT INTO `freepay_nna` VALUES ('AT', 'Oesterreichische Kontrollbank AG', 'Wien', 'Austria', 'http://www.oekb.at/');
INSERT INTO `freepay_nna` VALUES ('AU', 'Australian Stock Exchange Limited', 'Sydney', 'Australia', 'http://www.asx.com.au');
INSERT INTO `freepay_nna` VALUES ('AZ', 'National Depository Center', 'Baku', 'Azerbaijan', 'http://www.mdm.az');
INSERT INTO `freepay_nna` VALUES ('BD', 'Central Depository Bangladesh Ltd.', 'Dhaha', 'Bangladesh', '');
INSERT INTO `freepay_nna` VALUES ('BE', 'NextInfo S.A.', 'Bruxelles', 'Belgium', 'http://www.fininfo.fr');
INSERT INTO `freepay_nna` VALUES ('BG', 'Central Depository of Bulgaria', 'Sofia', 'Bulgaria', 'http://www.cdad.bg');
INSERT INTO `freepay_nna` VALUES ('BO', 'Entitad de Deposito de Valores de Bolivia S.A.', 'La Paz', 'Bolivia', 'http://www.edvbolivia.com');
INSERT INTO `freepay_nna` VALUES ('BR', 'Bolsa de Valores de Sao Paulo S.A. - BVSP', 'Sao Paulo', 'Brazil', 'http://www.bovespa.com.br/');
INSERT INTO `freepay_nna` VALUES ('BW', 'Botswana Stock Exchange', 'Gaborone', 'Botswana', 'http://www.bse.co.bw');
INSERT INTO `freepay_nna` VALUES ('CA', 'The Canadian Depository for Securities Ltd', 'Toronto', 'Canada', 'http://www.cds.ca/');
INSERT INTO `freepay_nna` VALUES ('CH', 'SIX Telekurs Ltd', 'Zurich', 'Switzerland', 'http://www.telekurs.com');
INSERT INTO `freepay_nna` VALUES ('CL', 'Deposito Central de Valores', 'Santiago', 'Chile', 'http://www.dcv.cl');
INSERT INTO `freepay_nna` VALUES ('CN', 'China Securities Regulatory Commission', 'Beijing', 'China', 'http://www.chinaclear.cn/');
INSERT INTO `freepay_nna` VALUES ('CO', 'Deposito Centralizado de Valores de Colombia - DECEVAL S.A.', 'Bogota', 'Colombia', 'http://www.deceval.com.co');
INSERT INTO `freepay_nna` VALUES ('CR', 'Central de Valores - CEVAL', 'San Jose', 'Costa Rica', 'http://www.bnv.co.cr');
INSERT INTO `freepay_nna` VALUES ('CV', 'Bolsa de Valores de Cabo Verde', 'Praia', 'Cape Verde', '');
INSERT INTO `freepay_nna` VALUES ('CY', 'Cyprus Stock Exchange', 'Nicosia', 'Cyprus', 'http://www.cse.com.cy');
INSERT INTO `freepay_nna` VALUES ('CZ', 'Czech National Bank', 'Praha', 'Czech Republic', 'http://www.cnb.cz');
INSERT INTO `freepay_nna` VALUES ('DE', 'Wertpapier-Mitteilungen', 'Frankfurt am Main', 'Germany', 'http://www.wmdaten.com');
INSERT INTO `freepay_nna` VALUES ('DK', 'VP Securities Services', 'Taastrup', 'Denmark', 'http://www.vp.dk');
INSERT INTO `freepay_nna` VALUES ('DZ', 'Algerie Clearing', 'Algiers', 'Algeria', 'http://www.algerieclearing.dz/');
INSERT INTO `freepay_nna` VALUES ('EE', 'Estonian Central Depository for Securities', 'Tallinn', 'Estonia', 'http://www.omxgroup.com/tallinn');
INSERT INTO `freepay_nna` VALUES ('EG', 'Misr for Central Clearing, Depository and Registry (MCDR)', 'Attaba', 'Egypt', 'http://www.mcsd.com.eg');
INSERT INTO `freepay_nna` VALUES ('ES', 'Comision Nacional del Mercado de Valores (CNMV)', 'Madrid', 'Spain', 'http://www.cnmv.es');
INSERT INTO `freepay_nna` VALUES ('FI', 'NCSD Finland', 'Helsinki', 'Finland', 'http://www.ncsd.eu/2192_ENG_ST.htm');
INSERT INTO `freepay_nna` VALUES ('FR', 'Euroclear France', 'Paris', 'France', 'http://www.euroclear.com');
INSERT INTO `freepay_nna` VALUES ('GA', 'Bourse des Valeurs Mobilieres de l´Afrique Centrale (BVMAC)', 'Libreville', 'Gabon and CEMAC countries', 'http://www.bvm-ac.com');
INSERT INTO `freepay_nna` VALUES ('GB', 'London Stock Exchange', 'England', 'United Kingdom', 'http://www.londonstockexchange.com');
INSERT INTO `freepay_nna` VALUES ('GR', 'Central Securities Depository S.A.', 'Athens', 'Greece', 'http://www.hcsd.gr');
INSERT INTO `freepay_nna` VALUES ('HK', 'Hong Kong Exchanges and Clearing Ltd', 'Hong Kong', 'China', 'http://www.hkex.com.hk');
INSERT INTO `freepay_nna` VALUES ('HN', 'Comision Nacional de Bancos y Seguros', 'Tegucigalpa', 'Honduras', 'http://www.cnbs.gov.hn');
INSERT INTO `freepay_nna` VALUES ('HR', 'SDA - Central Depository Agency of Croatia', 'Zagreb', 'Croatia', 'http://www.sda.hr');
INSERT INTO `freepay_nna` VALUES ('HU', 'KELER', 'Budapest', 'Hungary', 'http://www.keler.hu');
INSERT INTO `freepay_nna` VALUES ('ID', 'PT Kustodian Sentral Efek Indonesia (Indonesian Central Securities Depository - ICSD)', 'Jakarta', 'Indonesia', 'http://www.ksei.co.id');
INSERT INTO `freepay_nna` VALUES ('IE', 'The Irish Stock Exchange', 'Dublin', 'Ireland', 'http://www.ise.ie');
INSERT INTO `freepay_nna` VALUES ('IL', 'The Tel Aviv Stock Exchange', 'Tel Aviv', 'Israel', '');
INSERT INTO `freepay_nna` VALUES ('IN', 'Securities and Exchange Board of India', 'Mumbai', 'India', 'http://www.sebi.gov.in');
INSERT INTO `freepay_nna` VALUES ('IR', 'Tehran Securities Exchange Technology Management Company', 'Tehran', 'Iran', 'http://www.tsetmc.com');
INSERT INTO `freepay_nna` VALUES ('IS', 'Icelandic Securities Depository', 'Reykjavik', 'Iceland', 'http://www.verdbrefaskraning.is');
INSERT INTO `freepay_nna` VALUES ('IT', 'Banca d´Italia', 'Roma', 'Italy', 'http://www.bancaditalia.it');
INSERT INTO `freepay_nna` VALUES ('JO', 'Securities Depository Center of Jordan', 'Amman', 'Jordan', 'http://www.sdc.com.jo');
INSERT INTO `freepay_nna` VALUES ('JP', 'Tokyo Stock Exchange', 'Tokyo', 'Japan', 'http://www.tse.or.jp/english/index.html');
INSERT INTO `freepay_nna` VALUES ('KE', 'Nairobi Stock Exchange', 'Nairobi', 'Kenya', 'http://www.nse.co.ke');
INSERT INTO `freepay_nna` VALUES ('KR', 'Korea Exchange - KRX', 'Seoul', 'Korea', 'http://www.krx.co.kr');
INSERT INTO `freepay_nna` VALUES ('KW', 'Kuwait Clearing Company', 'Safat', 'Kuwait', 'http://www.kuwaitclearing.com');
INSERT INTO `freepay_nna` VALUES ('LB', 'Midclear S.A.L.', 'Beirut', 'Lebanon', 'http://www.midclear.com.lb');
INSERT INTO `freepay_nna` VALUES ('LK', 'Colombo Stock Exchange', 'Colombo', 'Sri Lanka', 'http://www.cse.lk');
INSERT INTO `freepay_nna` VALUES ('LT', 'Central Securities Depository of Lithuania', 'Vilnius', 'Lithuania', 'http://www.csdl.lt');
INSERT INTO `freepay_nna` VALUES ('LU', 'Clearstream Banking', 'Luxembourg', 'Luxembourg', 'http://www.clearstream.com');
INSERT INTO `freepay_nna` VALUES ('LV', 'OMX - Latvian Central Depository', 'Riga', 'Latvia', 'http://www.omxgroup.com');
INSERT INTO `freepay_nna` VALUES ('LY', 'Libyan Stock Market', 'Benghazi', 'Libya', 'http://www.lsm.gov.ly');
INSERT INTO `freepay_nna` VALUES ('MA', 'MAROCLEAR S.A.', 'Casablanca', 'Morocco', 'http://www.maroclear.com/');
INSERT INTO `freepay_nna` VALUES ('ME', 'Central Depository Agency of Montenegro', 'Podgorica', 'Montenegro', 'http://www.cda.cg.yu/');
INSERT INTO `freepay_nna` VALUES ('MK', 'Central Securities Depository AD Skopje', 'Skopje', 'Macedonia', 'http://www.cdhv.org.mk');
INSERT INTO `freepay_nna` VALUES ('MT', 'Malta Stock Exchange', 'Valletta', 'Malta', 'http://www.borzamalta.com.mt');
INSERT INTO `freepay_nna` VALUES ('MU', 'Central Depository & Settlement Co. Ltd', 'Port Louis', 'Mauritius', '');
INSERT INTO `freepay_nna` VALUES ('MX', 'S.D. Indeval SA de CV', 'Mexico', 'Mexico', 'http://www.indeval.com.mx');
INSERT INTO `freepay_nna` VALUES ('MY', 'Bursa Malaysia', 'Kuala Lumpur', 'Malaysia', 'http://www.bursamalaysia.com');
INSERT INTO `freepay_nna` VALUES ('NI', 'Central Nicaragüense de Valores, Cenival', 'Managua', 'Nicaragua', 'http://www.bolsanic.com/cenival/index.html');
INSERT INTO `freepay_nna` VALUES ('NL', 'Euroclear Netherlands NIEC', 'Amsterdam', 'Netherlands', 'http://www.euroclearnederland.nl');
INSERT INTO `freepay_nna` VALUES ('NO', 'Verdipapirsentralen (VPS) ASA', 'Oslo', 'Norway', 'http://www.vps.no');
INSERT INTO `freepay_nna` VALUES ('OM', 'Muscat Depository & Securities Registration Co.', 'Muscat', 'Oman', 'http://www.msm.gov.om');
INSERT INTO `freepay_nna` VALUES ('PA', 'Bolsa de Valores de Panama S.A.', 'Panama', 'Panama', 'http://www.panabolsa.com');
INSERT INTO `freepay_nna` VALUES ('PE', 'Bolsa de Valores de Lima', 'Lima', 'Peru', 'http://www.bvl.com.pe');
INSERT INTO `freepay_nna` VALUES ('PH', 'Philippine Stock Exchange, Inc.', 'Manila', 'Philippines', 'http://www.pse.com.ph');
INSERT INTO `freepay_nna` VALUES ('PK', 'Central Depository Company of Pakistan Ltd', 'Karachi', 'Pakistan', 'http://www.cdcpakistan.com/');
INSERT INTO `freepay_nna` VALUES ('PL', 'National Depository for Securities', 'Warsaw', 'Poland', 'http://www.kdpw.pl');
INSERT INTO `freepay_nna` VALUES ('PT', 'Interbolsa - Sociedade Gestora de Sistemas de Liquidação e Sistemas Centralizados de Valores', 'Porto', 'Portugal', 'http://www.interbolsa.pt');
INSERT INTO `freepay_nna` VALUES ('RO', 'Depozitarul Central S.A. (Romanian Central Depository)', 'Bucharest', 'Romania', 'http://www.roclear.eu/');
INSERT INTO `freepay_nna` VALUES ('RS', 'Central Securities Depository A.D. Beograd', 'Belgrade', 'Serbia', 'http://www.crhov.co.yu/');
INSERT INTO `freepay_nna` VALUES ('RU', 'The National Depository Center (NDC)', 'Moscow', 'Russia', 'http://www.ndc.ru/en/');
INSERT INTO `freepay_nna` VALUES ('SA', 'Saudi Financial Market (Tadawul)', 'Riyadh', 'Saudi Arabia', 'http://www.tadawul.com.sa');
INSERT INTO `freepay_nna` VALUES ('SE', 'VPC AB', 'Stockholm', 'Sweden', 'http://www.vpc.se');
INSERT INTO `freepay_nna` VALUES ('SG', 'Singapore Exchange Limited', 'Singapore', 'Singapore', 'http://www.sgx.com');
INSERT INTO `freepay_nna` VALUES ('SI', 'KDD Central Securities Clearing Corporation', 'Ljubljana', 'Slovenia', 'http://www.kdd.si');
INSERT INTO `freepay_nna` VALUES ('SK', 'Central Securities Depository SR, Inc.', 'Bratislava', 'Slovakia', 'http://www.cdcp.sk');
INSERT INTO `freepay_nna` VALUES ('SV', 'Central Deposito de Valores S.A. de C.V.', 'La Libertad', 'El Salvador', 'http://www.cedeval.com');
INSERT INTO `freepay_nna` VALUES ('SZ', 'Central Bank Swaziland', '', 'Swaziland', '');
INSERT INTO `freepay_nna` VALUES ('TH', 'Thailand Securities Depository Co., Ltd', 'Bangkok', 'Thailand', 'http://www.tsd.co.th');
INSERT INTO `freepay_nna` VALUES ('TN', 'Sticodevam', 'Tunis', 'Tunisia', 'http://www.sticodevam.com.tn');
INSERT INTO `freepay_nna` VALUES ('TR', 'Takasbank', 'Istanbul', 'Turkey', 'http://www.takasbank.com.tr');
INSERT INTO `freepay_nna` VALUES ('TW', 'Taiwan Stock Exchange Corporation', 'Taipei', 'Taiwan, Province of China', 'http://www.twse.com.tw');
INSERT INTO `freepay_nna` VALUES ('TZ', 'Dar es Salaam Stock Exchange', 'Dar es Salaam', 'Tanzania', 'http://www.darstockexchange.com');
INSERT INTO `freepay_nna` VALUES ('UA', 'National Depository of Ukraine', 'Kiev', 'Ukraine', 'http://www.ndu.gov.ua');
INSERT INTO `freepay_nna` VALUES ('UG', 'Uganda Securities Exchange', '', 'Uganda', '');
INSERT INTO `freepay_nna` VALUES ('US', 'Standard & Poor´s - CUSIP Global Services', 'New York', 'USA', 'http://www.cusip.com');
INSERT INTO `freepay_nna` VALUES ('VE', 'Bolsa de Valores de Caracas, C.A.', 'Caracas', 'Venezuela', 'http://www.bolsadecaracas.com/');
INSERT INTO `freepay_nna` VALUES ('XS', 'Euroclear Bank S.A./N.V', 'Brussels', 'Euroclear', 'http://www.euroclear.com');
INSERT INTO `freepay_nna` VALUES ('ZA', 'JSE Ltd', 'Sandton', 'South Africa', 'http://www.jse.co.za');
INSERT INTO `freepay_nna` VALUES ('ZM', 'Lusaka Stock Exchange', '', 'Zambia', 'http://www.luse.co.zm/');
INSERT INTO `freepay_nna` VALUES ('ZW', 'Zimbawe Stock Exchange', '', 'Zimbabwe', '');
INSERT INTO `freepay_nna` VALUES ('ZZ', 'FreePay Securities Depository', '', '', 'http://www.freepay.fr/');

-- --------------------------------------------------------

-- 
-- Structure de la table `freepay_sec`
-- 

CREATE TABLE `freepay_sec` (
  `CodePays` varchar(5) NOT NULL default '',
  `NomSEC` varchar(100) NOT NULL default '',
  `NomVille` varchar(40) NOT NULL default '',
  `NomPays` varchar(40) NOT NULL default '',
  `URLSEC` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`CodePays`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Contenu de la table `freepay_sec`
-- 

INSERT INTO `freepay_sec` VALUES ('AE', 'Securities and Commodities Authority', 'Abu Dhabi', 'UNITED ARAB EMIRATES', 'http://www.sca.ae/');
INSERT INTO `freepay_sec` VALUES ('AL', 'Albanian Financial Supervisory Authority', 'Tirana', 'ALBANIA', 'http://www.amf.gov.al/');
INSERT INTO `freepay_sec` VALUES ('AM', 'Central Bank of Armenia', 'Yerevan', 'ARMENIA', 'http://www.cba.am/');
INSERT INTO `freepay_sec` VALUES ('AR', 'Comisión Nacional de Valores', 'Buenos Aires', 'ARGENTINA', 'http://www.cnv.gov.ar/');
INSERT INTO `freepay_sec` VALUES ('AT', 'Financial Market Authority', 'Vienna', 'AUSTRIA', 'http://www.fma.gv.at/');
INSERT INTO `freepay_sec` VALUES ('AU', 'Australian Securities and Investments Commission', 'Sydney', 'AUSTRALIA', 'http://www.asic.gov.au/');
INSERT INTO `freepay_sec` VALUES ('BA-BH', 'Securities Commission of the Federation of Bosnia and Herzegovina', 'Sarajevo', 'BOSNIA AND HERZEGOVINA, FEDERATION OF', 'http://www.komvp.gov.ba/');
INSERT INTO `freepay_sec` VALUES ('BA-RS', 'Securities Commission', 'Banja Luka', 'SRPSKA, REPUBLIC OF', 'http://www.sec.rs.ba/');
INSERT INTO `freepay_sec` VALUES ('BB', 'Securities Commission of Barbados', 'Barbados', 'BARBADOS', '');
INSERT INTO `freepay_sec` VALUES ('BD', 'Securities and Exchange Commission', 'Dhaka', 'BANGLADESH', 'http://www.secbd.org/');
INSERT INTO `freepay_sec` VALUES ('BE', 'Banking, Finance And Insurance Commission', 'Brussels', 'BELGIUM', 'http://www.cbfa.be/');
INSERT INTO `freepay_sec` VALUES ('BG', 'Financial Supervision Commission', 'Sofia', 'BULGARIA', 'http://www.fsc.bg/');
INSERT INTO `freepay_sec` VALUES ('BH', 'Central Bank of Bahrain', 'Manama', 'BAHRAIN, KINGDOM OF', 'http://www.cbb.gov.bh/');
INSERT INTO `freepay_sec` VALUES ('BM', 'Bermuda Monetary Authority', 'Hamilton', 'BERMUDA', 'http://www.bma.bm/');
INSERT INTO `freepay_sec` VALUES ('BN', 'Brunei International Financial Center of the Ministry of Finance', 'Bandar Seri Begawan', 'BRUNEI', '');
INSERT INTO `freepay_sec` VALUES ('BO', 'Superintendencia de Pensiones, Valores y Seguros', 'La Paz', 'BOLIVIA', 'http://www.spvs.gov.bo/');
INSERT INTO `freepay_sec` VALUES ('BR', 'Comissão de Valores Mobiliários', 'Rio de Janeiro, RJ', 'BRAZIL', 'http://www.cvm.gov.br/');
INSERT INTO `freepay_sec` VALUES ('BS', 'Securities Commission of the Bahamas', 'Nassau', 'BAHAMAS, THE', 'http://www.scb.gov.bs/');
INSERT INTO `freepay_sec` VALUES ('CA-AB', 'Alberta Securities Commission', 'Calgary', 'CANADA', 'http://www.albertasecurities.com/');
INSERT INTO `freepay_sec` VALUES ('CA-BC', 'British Columbia Securities Commission', 'Vancouver', 'CANADA', 'http://www.bcsc.bc.ca/');
INSERT INTO `freepay_sec` VALUES ('CA-MB', 'Manitoba Securities Commission', 'Winnipeg', 'CANADA', 'http://www.msc.gov.mb.ca/');
INSERT INTO `freepay_sec` VALUES ('CA-NB', 'New Brunswick Securities Commission', 'Saint John', 'CANADA', 'http://www.nbsc-cvmnb.ca/');
INSERT INTO `freepay_sec` VALUES ('CA-NL', 'Newfoundland and Labrador Financial Services Regulation', 'St. John', 'CANADA', 'http://www.gs.gov.nl.ca/cca/fsr/');
INSERT INTO `freepay_sec` VALUES ('CA-NS', 'Nova Scotia Securities Commission', 'Halifax', 'CANADA', 'http://www.gov.ns.ca/nssc/');
INSERT INTO `freepay_sec` VALUES ('CA-NT', 'Northwest Territories Securities Registry', 'Yellowknife', 'CANADA', 'http://www.justice.gov.nt.ca/SecuritiesRegistry/');
INSERT INTO `freepay_sec` VALUES ('CA-NU', 'Nunavut Registrar of Securities', 'Iqaluit', 'CANADA', '');
INSERT INTO `freepay_sec` VALUES ('CA-ON', 'Ontario Securities Commission', 'Toronto', 'CANADA', 'http://www.osc.gov.on.ca/');
INSERT INTO `freepay_sec` VALUES ('CA-PE', 'Prince Edward Island Securities Office', 'Charlottetown', 'CANADA', 'http://www.gov.pe.ca/securities/');
INSERT INTO `freepay_sec` VALUES ('CA-QC', 'Autorité des marchés financiers du Québec', 'Montréal', 'CANADA', 'http://www.lautorite.qc.ca/');
INSERT INTO `freepay_sec` VALUES ('CA-SK', 'Saskatchewan Financial Services Commission', 'Regina', 'CANADA', 'http://www.sfsc.gov.sk.ca/');
INSERT INTO `freepay_sec` VALUES ('CA-YT', 'Yukon Securities Office', 'Whitehorse', 'CANADA', 'http://www.community.gov.yk.ca/corp/secureinvest.html');
INSERT INTO `freepay_sec` VALUES ('CH', 'Commission fédérale des banques', 'Berne', 'SWITZERLAND', 'http://www.sfbc.admin.ch/');
INSERT INTO `freepay_sec` VALUES ('CI', 'Conseil régional de l''épargne publique et des marchés financiers', 'Lusaka', 'Côte d''Ivoire', 'http://www.crepmf.org/');
INSERT INTO `freepay_sec` VALUES ('CL', 'Superintendencia de Valores y Seguros', 'Santiago', 'CHILE', 'http://www.svs.cl/');
INSERT INTO `freepay_sec` VALUES ('CN', 'China Securities Regulatory Commission', 'Beijing', 'CHINA, PEOPLE''S REPUBLIC OF', 'http://www.csrc.gov.cn/');
INSERT INTO `freepay_sec` VALUES ('CO', 'Superintendencia Financiera de Colombia', 'Bogotá', 'COLOMBIA', 'http://www.superfinanciera.gov.co');
INSERT INTO `freepay_sec` VALUES ('CR', 'Superintendencia General de Valores', 'San José', 'COSTA RICA', 'http://www.sugeval.fi.cr/');
INSERT INTO `freepay_sec` VALUES ('CY', 'Cyprus Securities and Exchange Commission', 'Nicosia', 'CYPRUS, REPUBLIC OF', 'http://www.cysec.gov.cy/');
INSERT INTO `freepay_sec` VALUES ('CZ', 'Czech National Bank', 'Praha', 'CZECH REPUBLIC', 'http://www.cnb.cz/');
INSERT INTO `freepay_sec` VALUES ('DE', 'Bundesanstalt für Finanzdienstleistungsaufsicht (BaFin)', 'Frankfurt am Main', 'GERMANY', 'http://www.bafin.de/');
INSERT INTO `freepay_sec` VALUES ('DK', 'Finanstilsynet', 'Frederiksberg', 'DENMARK', 'http://www.ftnet.dk/');
INSERT INTO `freepay_sec` VALUES ('DO', 'Superintendencia de Valores de la República Dominicana', 'Santo Domingo', 'DOMINICAN REPUBLIC', 'http://www.siv.gov.do/');
INSERT INTO `freepay_sec` VALUES ('DZ', 'Commission d''organisation et de surveillance des opérations de bourse', 'Alger', 'ALGERIA', 'http://www.cosob.com.dz/');
INSERT INTO `freepay_sec` VALUES ('EC', 'Superintendencia de Compañías', 'Quito', 'ECUADOR', 'http://www.supercias.gov.ec/');
INSERT INTO `freepay_sec` VALUES ('EE', 'Financial Supervision Authority (Finantsinspektioon)', 'Tallinn', 'ESTONIA', 'http://www.fi.ee/');
INSERT INTO `freepay_sec` VALUES ('EG', 'Capital Market Authority', 'Cairo', 'EGYPT', 'http://www.cma.gov.eg');
INSERT INTO `freepay_sec` VALUES ('ES', 'Comisión Nacional del Mercado de Valores', 'Madrid', 'SPAIN', '');
INSERT INTO `freepay_sec` VALUES ('FI', 'Financial Supervision Authority', 'Helsinki', 'FINLAND', 'http://www.rahoitustarkastus.fi');
INSERT INTO `freepay_sec` VALUES ('FR', 'Autorité des marchés financiers', 'Paris', 'FRANCE', 'http://www.amf-france.org/');
INSERT INTO `freepay_sec` VALUES ('GB', 'Financial Services Authority', 'London', 'UNITED KINGDOM', 'http://www.fsa.gov.uk/');
INSERT INTO `freepay_sec` VALUES ('GG', 'Guernsey Financial Services Commission', 'St. Peter Port', 'GUERNSEY', 'http://www.gfsc.gg/');
INSERT INTO `freepay_sec` VALUES ('GH', 'Securities and Exchange Commission', 'Accra', 'GHANA', 'http://www.secghana.org/');
INSERT INTO `freepay_sec` VALUES ('GI', 'Financial Services Commission', 'Gibraltar', 'GIBRALTAR', 'http://www.fsc.gi/');
INSERT INTO `freepay_sec` VALUES ('GR', 'Hellenic Republic Capital Market Commission', 'Athens', 'GREECE', 'http://www.hcmc.gr/');
INSERT INTO `freepay_sec` VALUES ('HK', 'Securities and Futures Commission', 'Hong Kong', 'HONG KONG', 'http://www.sfc.hk/');
INSERT INTO `freepay_sec` VALUES ('HN', 'Comisión Nacional de Bancos y Seguros (National Banks and Securities Commission)', 'Tegucigalpa', 'HONDURAS', 'http://www.cnbs.gov.hn/');
INSERT INTO `freepay_sec` VALUES ('HR', 'Croatian Financial Services Supervisory Agency', 'Zagreb', 'CROATIA, REPUBLIC OF', 'http://www.hanfa.hr/');
INSERT INTO `freepay_sec` VALUES ('HU', 'Hungarian Financial Supervisory Authority', 'Budapest', 'HUNGARY', 'http://www.pszaf.hu/');
INSERT INTO `freepay_sec` VALUES ('ID', 'Indonesian Capital Market and Financial Institutions Supervisory Agency', 'Jakarta', 'INDONESIA', 'http://www.bapepam.go.id/');
INSERT INTO `freepay_sec` VALUES ('IE', 'Central Bank and Financial Services Authority', 'Dublin', 'IRELAND', 'http://www.financialregulator.ie/');
INSERT INTO `freepay_sec` VALUES ('IL', 'Israel Securities Authority', 'Jerusalem', 'ISRAEL', 'http://www.isa.gov.il/');
INSERT INTO `freepay_sec` VALUES ('IM', 'Financial Supervision Commission', 'Douglas', 'ISLE OF MAN', 'http://www.fsc.gov.im/');
INSERT INTO `freepay_sec` VALUES ('IN', 'Securities and Exchange Board of India (SEBI)', 'Mumbai', 'INDIA', 'http://www.sebi.gov.in/');
INSERT INTO `freepay_sec` VALUES ('IT', 'Commissione Nazionale per le Società e la Borsa', 'Roma', 'ITALY', 'http://www.consob.it/');
INSERT INTO `freepay_sec` VALUES ('JE', 'Jersey Financial Services Commission', 'St. Helier', 'JERSEY', 'http://www.jerseyfsc.org/');
INSERT INTO `freepay_sec` VALUES ('JM', 'Financial Services Commission', 'Kingston', 'JAMAICA', 'http://www.fscjamaica.org/');
INSERT INTO `freepay_sec` VALUES ('JO', 'Jordan Securities Commission', 'Amman', 'JORDAN', 'http://www.jsc.gov.jo/');
INSERT INTO `freepay_sec` VALUES ('JP', 'Financial Services Agency', 'Tokyo', 'JAPAN', 'http://www.fsa.go.jp/');
INSERT INTO `freepay_sec` VALUES ('KE', 'Capital Markets Authority', 'Nairobi', 'KENYA', 'http://www.cma.or.ke/');
INSERT INTO `freepay_sec` VALUES ('KG', 'State Agency for Financial Surveillance and Accounting', 'Bishkek', 'KYRGYZ REPUBLIC', '');
INSERT INTO `freepay_sec` VALUES ('KR', 'Financial Services Commission/Financial Supervisory Service (FSC/FSS)', 'Seoul', 'KOREA', 'http://www.fsc.go.kr/eng');
INSERT INTO `freepay_sec` VALUES ('KZ', 'Financial Supervision Agency', 'Almaty', 'KAZAKHSTAN, REPUBLIC OF', 'http://www.afn.kz/');
INSERT INTO `freepay_sec` VALUES ('LK', 'Securities and Exchange Commission', 'Colombo', 'SRI LANKA', 'http://www.sec.gov.lk/');
INSERT INTO `freepay_sec` VALUES ('LT', 'Lithuanian Securities Commission', 'Vilnius', 'LITHUANIA', 'http://www.lsc.lt/');
INSERT INTO `freepay_sec` VALUES ('LU', 'Commission de surveillance du secteur financier', 'Luxembourg', 'LUXEMBOURG, GRAND DUCHY OF', 'http://www.cssf.lu/');
INSERT INTO `freepay_sec` VALUES ('MA', 'Conseil déontologique des valeurs mobilières', 'Rabat', 'MOROCCO', 'http://www.cdvm.gov.ma/');
INSERT INTO `freepay_sec` VALUES ('ME', 'Securities Commission of the Republic of Montenegro', 'Podgorica', 'MONTENEGRO', 'http://www.scmn.co.me/');
INSERT INTO `freepay_sec` VALUES ('MK', 'Securities and Exchange Commission', 'Skopje', 'FORMER YUGOSLAV REPUBLIC OF MACEDONIA', 'http://www.sec.gov.mk/');
INSERT INTO `freepay_sec` VALUES ('MN', 'Financial Regulatory Commission', 'Ulaanbaatar', 'MONGOLIA', 'http://www.frc.mn/');
INSERT INTO `freepay_sec` VALUES ('MT', 'Malta Financial Services Authority', 'Attard', 'MALTA', 'http://www.mfsa.com.mt/');
INSERT INTO `freepay_sec` VALUES ('MU', 'Financial Services Commission', 'Port-Louis', 'MAURITIUS, REPUBLIC OF', 'http://www.fscmauritius.org');
INSERT INTO `freepay_sec` VALUES ('MW', 'Reserve Bank of Malawi', 'Blantyre', 'MALAWI', 'http://www.rbm.mw/');
INSERT INTO `freepay_sec` VALUES ('MX', 'Comisión Nacional Bancaria y de Valores', 'México', 'MEXICO', 'http://www.cnbv.gob.mx/');
INSERT INTO `freepay_sec` VALUES ('MY', 'Securities Commission', 'Kuala Lumpur', 'MALAYSIA', 'http://www.sc.com.my/');
INSERT INTO `freepay_sec` VALUES ('NG', 'Securities and Exchange Commission', 'Lagos', 'NIGERIA', 'http://www.sec.gov.ng/');
INSERT INTO `freepay_sec` VALUES ('NL', 'The Netherlands Authority for the Financial Markets', 'Amsterdam', 'NETHERLANDS, THE', 'http://www.afm.nl/');
INSERT INTO `freepay_sec` VALUES ('NO', 'Kredittilsynet', 'Oslo', 'NORWAY', 'http://www.kredittilsynet.no/');
INSERT INTO `freepay_sec` VALUES ('NZ', 'Securities Commission', 'Wellington', 'NEW ZEALAND', 'http://www.seccom.govt.nz/');
INSERT INTO `freepay_sec` VALUES ('OM', 'Capital Market Authority', 'Muscat', 'OMAN, SULTANATE OF', '');
INSERT INTO `freepay_sec` VALUES ('PA', 'Comisión Nacional de Valores', 'Panama', 'PANAMA, REPUBLIC OF', 'http://www.conaval.gob.pa/');
INSERT INTO `freepay_sec` VALUES ('PE', 'Comisión Nacional Supervisora de Empresas y Valores', 'Lima', 'PERU', 'http://www.conasev.gob.pe/');
INSERT INTO `freepay_sec` VALUES ('PG', 'Securities Commission', 'Port Moresby', 'PAPUA NEW GUINEA', 'http://www.ipa.gov.pg/');
INSERT INTO `freepay_sec` VALUES ('PH', 'Securities and Exchange Commission', 'Manila', 'PHILIPPINES', '');
INSERT INTO `freepay_sec` VALUES ('PK', 'Securities and Exchange Commission', 'Islamabad', 'PAKISTAN', 'http://www.secp.gov.pk/');
INSERT INTO `freepay_sec` VALUES ('PL', 'Financial Supervision Authority', 'Warsaw', 'POLAND', 'http://www.kpwig.gov.pl/');
INSERT INTO `freepay_sec` VALUES ('PT', 'Comissão do Mercado de Valores Mobiliários', 'Lisboa', 'PORTUGAL', 'http://www.cmvm.pt');
INSERT INTO `freepay_sec` VALUES ('RO', 'Romanian National Securities Commission', 'Bucharest', 'ROMANIA', 'http://www.cnvmr.ro/');
INSERT INTO `freepay_sec` VALUES ('RS', 'Securities Commission', 'Novi Beograd', 'SERBIA, REPUBLIC OF', 'http://www.sec.sr.gov.yu/');
INSERT INTO `freepay_sec` VALUES ('RU', 'Federal Financial Markets Service of Russia', 'Moscow', 'RUSSIA', 'http://www.ffms.ru');
INSERT INTO `freepay_sec` VALUES ('SE', 'Finansinspektionen', 'Stockholm', 'SWEDEN', 'http://www.fi.se/');
INSERT INTO `freepay_sec` VALUES ('SG', 'Monetary Authority of Singapore', 'Singapore', 'SINGAPORE', 'http://www.mas.gov.sg/');
INSERT INTO `freepay_sec` VALUES ('SI', 'Securities Market Agency', 'Ljubljana', 'SLOVENIA', 'http://www.a-tvp.si/');
INSERT INTO `freepay_sec` VALUES ('SK', 'The National Bank of Slovakia', 'Bratislava', 'SLOVAK REPUBLIC', 'http://www.nbs.sk/');
INSERT INTO `freepay_sec` VALUES ('SV', 'Superintendencia de Valores', 'San Salvador', 'EL SALVADOR', 'http://www.superval.gob.sv/');
INSERT INTO `freepay_sec` VALUES ('TH', 'Securities and Exchange Commission', 'Bangkok', 'THAILAND', 'http://www.sec.or.th/');
INSERT INTO `freepay_sec` VALUES ('TN', 'Conseil du marché financier', 'Tunis', 'TUNISIA', 'http://www.cmf.org.tn/');
INSERT INTO `freepay_sec` VALUES ('TR', 'Capital Markets Board', 'Ankara', 'TURKEY', 'http://www.cmb.gov.tr/');
INSERT INTO `freepay_sec` VALUES ('TT', 'Trinidad and Tobago Securities and Exchange Commission', 'Port of Spain', 'TRINIDAD AND TOBAGO', 'http://www.ttsec.org.tt/');
INSERT INTO `freepay_sec` VALUES ('TW', 'Financial Supervisory Commission', 'Taiwan', 'CHINESE TAIPEI', 'http://www.fsc.gov.tw/');
INSERT INTO `freepay_sec` VALUES ('TZ', 'Capital Markets and Securities Authority', 'Dar Es Salaam', 'TANZANIA', 'http://cmsa-tz.org/');
INSERT INTO `freepay_sec` VALUES ('UA', 'Securities and Stock Market State Commission', 'Kyiv', 'UKRAINE', 'http://ssmsc.gov.ua/');
INSERT INTO `freepay_sec` VALUES ('UG', 'Capital Markets Authority', 'Kampala', 'UGANDA', 'http://www.cmauganda.co.ug');
INSERT INTO `freepay_sec` VALUES ('US', 'U.S. Securities and Exchange Commission', 'Washington, D.C.', 'UNITED STATES OF AMERICA', 'http://www.sec.gov/');
INSERT INTO `freepay_sec` VALUES ('US-AK', 'Alaska Division of Banking, Securities & Corporations', 'Juneau', 'UNITED STATES OF AMERICA', 'http://www.dced.state.ak.us/bsc/secur.htm');
INSERT INTO `freepay_sec` VALUES ('US-AL', 'Alabama Securities Commission', 'Montgomery', 'UNITED STATES OF AMERICA', 'http://www.asc.state.al.us');
INSERT INTO `freepay_sec` VALUES ('US-AR', 'Arkansas Securities Department', 'Little Rock', 'UNITED STATES OF AMERICA', 'http://www.securities.arkansas.gov/');
INSERT INTO `freepay_sec` VALUES ('US-AZ', 'Arizona Corporation Commission, Securities Division', 'Phoenix', 'UNITED STATES OF AMERICA', 'http://www.azinvestor.gov/');
INSERT INTO `freepay_sec` VALUES ('US-CA', 'California Securities Regulation Division', 'Sacramento', 'UNITED STATES OF AMERICA', 'http://www.corp.ca.gov/SRD/');
INSERT INTO `freepay_sec` VALUES ('US-CO', 'Colorado Department of Regulatory Agencies (Division of Securities)', 'Denver', 'UNITED STATES OF AMERICA', 'http://www.dora.state.co.us/Securities/');
INSERT INTO `freepay_sec` VALUES ('US-CT', 'State of Connecticut, Department of Banking, Division of Securities', 'Hartford County', 'UNITED STATES OF AMERICA', 'http://www.ct.gov/dob/site/');
INSERT INTO `freepay_sec` VALUES ('US-DC', 'Department of Insurance, Securities and Banking (DISB)', 'Washington, D.C.', 'UNITED STATES OF AMERICA', 'http://disr.washingtondc.gov/');
INSERT INTO `freepay_sec` VALUES ('US-DE', 'Delaware, Department of Justice, Division of Securities', 'Wilmington', 'UNITED STATES OF AMERICA', 'http://www.state.de.us/securities/');
INSERT INTO `freepay_sec` VALUES ('US-FL', 'Florida, Office of Financial Regulation, Division of Securities', 'Tallahassee', 'UNITED STATES OF AMERICA', 'http://www.flofr.com/Securities/');
INSERT INTO `freepay_sec` VALUES ('US-GA', 'Georgia Secretary of State, Securities Division', 'Atlanta', 'UNITED STATES OF AMERICA', 'http://sos.georgia.gov/Securities/');
INSERT INTO `freepay_sec` VALUES ('US-HI', 'Hawaii, Department of Commerce & Consumer Affairs, Securities Branch', 'Honolulu', 'UNITED STATES OF AMERICA', 'http://hawaii.gov/dcca/areas/sec/');
INSERT INTO `freepay_sec` VALUES ('US-IA', 'Iowa Insurance Division: Securities & Regulated Industries Bureau', 'Des Moines', 'UNITED STATES OF AMERICA', 'http://www.iid.state.ia.us/ia_securities_bureau/');
INSERT INTO `freepay_sec` VALUES ('US-ID', 'Idaho, Department of Finance, Securities Section', 'Boise', 'UNITED STATES OF AMERICA', 'http://finance.idaho.gov/Securities/Securities.aspx');
INSERT INTO `freepay_sec` VALUES ('US-IL', 'Illinois Secretary of State, Securities Department', 'Springfield', 'UNITED STATES OF AMERICA', 'http://www.cyberdriveillinois.com/departments/securities/home.html');
INSERT INTO `freepay_sec` VALUES ('US-IN', 'Indiana Secretary of State, Securities Division', 'Indianapolis', 'UNITED STATES OF AMERICA', 'http://www.in.gov/sos/securities/index.html');
INSERT INTO `freepay_sec` VALUES ('US-KS', 'Kansas, Office of the Securities Commissioner', 'Topeka', 'UNITED STATES OF AMERICA', 'http://www.securities.state.ks.us');
INSERT INTO `freepay_sec` VALUES ('US-KY', 'Kentucky: Department of Financial Institutions (DFI)', 'Frankfort', 'UNITED STATES OF AMERICA', 'http://www.dfi.ky.gov');
INSERT INTO `freepay_sec` VALUES ('US-LA', 'State of Louisiana, Office of Financial Institutions, Securities Division', 'Metairie', 'UNITED STATES OF AMERICA', 'http://www.ofi.state.la.us/securit.htm');
INSERT INTO `freepay_sec` VALUES ('US-MA', 'Massachusetts Securities Division, Secretary of the Commonwealth', 'Boston', 'UNITED STATES OF AMERICA', 'http://www.state.ma.us/sec/sct/sctidx.htm');
INSERT INTO `freepay_sec` VALUES ('US-MD', 'Maryland Attorney General - Securities Division', 'Baltimore', 'UNITED STATES OF AMERICA', 'http://www.oag.state.md.us/Securities/index.htm');
INSERT INTO `freepay_sec` VALUES ('US-ME', 'Department of Financial Regulation, Office of Securities, State of Maine', 'Augusta', 'UNITED STATES OF AMERICA', 'http://www.state.me.us/pfr/sec/sec_index.htm');
INSERT INTO `freepay_sec` VALUES ('US-MI', 'Office of Financial and Insurance Services, Division of Securities', 'Lansing', 'UNITED STATES OF AMERICA', 'http://www.michigan.gov/ofis');
INSERT INTO `freepay_sec` VALUES ('US-MN', 'Minnesota Department of Commerce, Division of Securities', 'Saint Paul', 'UNITED STATES OF AMERICA', 'http://www.state.mn.us/portal/mn/jsp/content.do?subchannel=-536881759&id=-536881351&agency=Commerce');
INSERT INTO `freepay_sec` VALUES ('US-MO', 'Missouri, Secretary of State, Securities Division', 'Jefferson City', 'UNITED STATES OF AMERICA', 'http://www.sos.mo.gov/securities/');
INSERT INTO `freepay_sec` VALUES ('US-MS', 'Mississippi Secretary of State, Business Regulation & Enforcement Division', 'Jackson', 'UNITED STATES OF AMERICA', 'http://www.sos.state.ms.us/regenf/Securities/securities.asp');
INSERT INTO `freepay_sec` VALUES ('US-MT', 'Montana State Auditor''s Office, Securities Department', 'Helena', 'UNITED STATES OF AMERICA', 'http://sao.mt.gov/securities/index.asp');
INSERT INTO `freepay_sec` VALUES ('US-NC', 'North Carolina Securities Division', 'Raleigh', 'UNITED STATES OF AMERICA', 'http://www.secretary.state.nc.us/sec');
INSERT INTO `freepay_sec` VALUES ('US-ND', 'North Dakota Securities Department', 'Bismarck', 'UNITED STATES OF AMERICA', 'http://www.ndsecurities.com/');
INSERT INTO `freepay_sec` VALUES ('US-NE', 'State of Nebraska: Department of Banking and Finance (NDBF), Bureau of Securities', 'Lincoln', 'UNITED STATES OF AMERICA', 'http://www.ndbf.org/securities/');
INSERT INTO `freepay_sec` VALUES ('US-NH', 'New Hampshire, Bureau of Securities Regulation, Department of State', 'Concord', 'UNITED STATES OF AMERICA', 'http://www.sos.nh.gov/securities/');
INSERT INTO `freepay_sec` VALUES ('US-NJ', 'New Jersey, Department of Law and Public Safety, Bureau of Securities', 'Newark', 'UNITED STATES OF AMERICA', 'http://www.njsecurities.gov/');
INSERT INTO `freepay_sec` VALUES ('US-NM', 'New Mexico, Regulation & Licensing Dept, Securities Division', 'Santa Fe', 'UNITED STATES OF AMERICA', 'http://www.rld.state.nm.us/securities/');
INSERT INTO `freepay_sec` VALUES ('US-NV', 'Nevada Securities Center', 'Las Vegas', 'UNITED STATES OF AMERICA', 'http://sos.state.nv.us/securities');
INSERT INTO `freepay_sec` VALUES ('US-NY', 'State of New York, Investor Protection and Securities Bureau', 'New York', 'UNITED STATES OF AMERICA', 'http://www.oag.state.ny.us/bureaus/investor_protection/investors/investors.html');
INSERT INTO `freepay_sec` VALUES ('US-OH', 'Ohio, Department of Commerce, Division of Securities', 'Columbus', 'UNITED STATES OF AMERICA', 'http://www.com.ohio.gov/secu/');
INSERT INTO `freepay_sec` VALUES ('US-OK', 'Oklahoma Securities Commission, Department of Securities', 'Oklahoma City', 'UNITED STATES OF AMERICA', 'http://www.securities.ok.gov/');
INSERT INTO `freepay_sec` VALUES ('US-OR', 'Oregon, Division of Finance and Corporate Securities (DFCS)', 'Salem', 'UNITED STATES OF AMERICA', 'http://www.cbs.state.or.us/external/dfcs/');
INSERT INTO `freepay_sec` VALUES ('US-PA', 'Pennsylvania Securities Commission, Eastgate Office Building', 'Harrisburg', 'UNITED STATES OF AMERICA', 'http://www.psc.state.pa.us/');
INSERT INTO `freepay_sec` VALUES ('US-RI', 'State of Rhode Island, Department of Business Regulation', 'Providence', 'UNITED STATES OF AMERICA', 'http://www.dbr.state.ri.us/');
INSERT INTO `freepay_sec` VALUES ('US-SC', 'South Carolina Attorney General, Securities Division', 'Columbia', 'UNITED STATES OF AMERICA', 'http://www.scsecurities.com');
INSERT INTO `freepay_sec` VALUES ('US-SD', 'South Dakota, Division of Securities', 'Pierre', 'UNITED STATES OF AMERICA', 'http://www.state.sd.us/drr2/reg/securities/index.htm');
INSERT INTO `freepay_sec` VALUES ('US-TN', 'Tennessee, Department of Commerce & Insurance, Securities Division', 'Nashville', 'UNITED STATES OF AMERICA', 'http://tennessee.gov/commerce/securities/');
INSERT INTO `freepay_sec` VALUES ('US-TX', 'Texas State Securities Board', 'Austin', 'UNITED STATES OF AMERICA', 'http://www.ssb.state.tx.us/');
INSERT INTO `freepay_sec` VALUES ('US-UT', 'State of Utah Division of Securities', 'Salt Lake City', 'UNITED STATES OF AMERICA', 'http://www.securities.state.ut.us');
INSERT INTO `freepay_sec` VALUES ('US-VA', 'Virginia Division of Securities and Retail Franchising', 'Richmond', 'UNITED STATES OF AMERICA', 'http://www.scc.virginia.gov/srf/index.aspx');
INSERT INTO `freepay_sec` VALUES ('US-VT', 'Department of Banking, Insurance, Securities & Health Care Administration (BISHCA)', 'Montpelier', 'UNITED STATES OF AMERICA', 'http://www.bishca.state.vt.us');
INSERT INTO `freepay_sec` VALUES ('US-WA', 'Washington State Department of Financial Institutions (DFI), Securities Division', 'Olympia', 'UNITED STATES OF AMERICA', 'http://www.dfi.wa.gov/sd');
INSERT INTO `freepay_sec` VALUES ('US-WI', 'State of Wisconsin Department of Financial Institutions (WDFI)', 'Madison', 'UNITED STATES OF AMERICA', 'http://www.wdfi.org/fi/securities');
INSERT INTO `freepay_sec` VALUES ('US-WV', 'West Virginia, Department of Financial Institutions, Division of Securities', 'Charleston', 'UNITED STATES OF AMERICA', 'http://www.wvsao.gov/securities/securities.asp');
INSERT INTO `freepay_sec` VALUES ('US-WY', 'Wyoming, Secretary of State, Securities Division', 'Cheyenne', 'UNITED STATES OF AMERICA', 'http://soswy.state.wy.us/Compliance/SecRegistration.aspx');
INSERT INTO `freepay_sec` VALUES ('UY', 'Banco Central del Uruguay', 'Montevideo', 'URUGUAY', 'http://www.bcu.gub.uy/');
INSERT INTO `freepay_sec` VALUES ('UZ', 'Center for Coordination and Control over Functioning of Securities Market', 'Tashkent', 'UZBEKISTAN, REPUBLIC OF', 'http://www.csm.gov.uz');
INSERT INTO `freepay_sec` VALUES ('VE', 'Comisión Nacional de Valores', 'Caracas', 'VENEZUELA', 'http://www.cnv.gov.ve/');
INSERT INTO `freepay_sec` VALUES ('VG', 'British Virgin Islands Financial Services Commission', 'Tortola', 'BRITISH VIRGIN ISLANDS', 'http://www.bvifsc.vg/');
INSERT INTO `freepay_sec` VALUES ('VN', 'State Securities Commission', 'Hanoi', 'VIETNAM', 'http://www.ssc.gov.vn/');
INSERT INTO `freepay_sec` VALUES ('ZA', 'Financial Services Board', 'Pretoria', 'SOUTH AFRICA', 'http://www.fsb.co.za/');
INSERT INTO `freepay_sec` VALUES ('ZM', 'Securities and Exchange Commission', 'Lusaka', 'ZAMBIA', 'http://www.sec.gov.zm/');
INSERT INTO `freepay_sec` VALUES ('ZZ', 'FreePay Securities and Exchange Commission', '', '', 'http://freepay.fr/');
-- --------------------------------------------------------

-- 
-- Structure de la table `freepay_titre`
-- 

CREATE TABLE `freepay_titre` (
  `numtitre` char(12) NOT NULL default '',
  `datetitre` datetime NOT NULL default '0000-00-00 00:00:00',
  `valeurtitre` decimal(30,2) NOT NULL default '0.00',
  `mailcli` char(40) NOT NULL default '',
  PRIMARY KEY  (`numtitre`),
  KEY `fk_tm` (`mailcli`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Contenu de la table `freepay_titre`
-- 

INSERT INTO `freepay_titre` VALUES ('FR2936889685', '2008-12-26 14:14:16', 1.00, 'freebanking@freepay.fr');

-- --------------------------------------------------------

-- 
-- Structure de la table `freepay_titre_transferer`
-- 

CREATE TABLE `freepay_titre_transferer` (
  `datet` datetime NOT NULL default '0000-00-00 00:00:00',
  `numtitre` char(12) NOT NULL default '',
  `mailcli` char(40) NOT NULL default '',
  `achattitre` decimal(30,2) NOT NULL default '0.00',
  `tauxprofit` decimal(5,2) NOT NULL default '0.00',
  PRIMARY KEY  (`datet`,`numtitre`,`mailcli`),
  KEY `fk_tcmc` (`numtitre`),
  KEY `fk_tcomc` (`mailcli`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Contenu de la table `freepay_titre_transferer`
-- 

INSERT INTO `freepay_titre_transferer` VALUES ('2008-12-26 13:55:14', 'FR2936889685', 'freebanking@freepay.fr', 0.50, 100.00);
        
