-- phpMyAdmin SQL Dump
-- version 3.2.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Feb 20, 2010 at 01:54 PM
-- Server version: 5.1.40
-- PHP Version: 5.2.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `bmcforu_transfer`
--

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

--
-- Table structure for table `paymentapi`
--

CREATE TABLE IF NOT EXISTS `paymentapi` (
  `paymentapiid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(250) NOT NULL DEFAULT '',
  `currency` varchar(250) NOT NULL DEFAULT '',
  `recurring` smallint(6) NOT NULL DEFAULT '0',
  `classname` varchar(250) NOT NULL DEFAULT '',
  `active` smallint(6) NOT NULL DEFAULT '0',
  `settings` mediumtext,
  PRIMARY KEY (`paymentapiid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

--
-- Dumping data for table `paymentapi`
--

INSERT INTO `paymentapi` (`paymentapiid`, `title`, `currency`, `recurring`, `classname`, `active`, `settings`) VALUES
(1, 'Paypal', 'usd,gbp,eur,aud,cad', 1, 'paypal', 1, 'a:2:{s:7:"ppemail";a:3:{s:4:"type";s:4:"text";s:5:"value";s:26:"blackmustangclub@gmail.com";s:8:"validate";s:6:"string";}s:12:"primaryemail";a:3:{s:4:"type";s:4:"text";s:5:"value";s:26:"blackmustangclub@gmail.com";s:8:"validate";s:6:"string";}}'),
(2, 'NOCHEX', 'gbp', 0, 'nochex', 0, 'a:1:{s:8:"ncxemail";a:3:{s:4:"type";s:4:"text";s:5:"value";s:0:"";s:8:"validate";s:6:"string";}}'),
(3, 'Worldpay', 'usd,gbp,eur', 1, 'worldpay', 0, 'a:2:{s:15:"worldpay_instid";a:3:{s:4:"type";s:4:"text";s:5:"value";s:0:"";s:8:"validate";s:6:"string";}s:17:"worldpay_password";a:3:{s:4:"type";s:4:"text";s:5:"value";s:0:"";s:8:"validate";s:6:"string";}}'),
(4, 'Authorize.Net', 'usd,gbp,eur', 0, 'authorizenet', 0, 'a:3:{s:17:"authorize_loginid";a:3:{s:4:"type";s:4:"text";s:5:"value";s:0:"";s:8:"validate";s:6:"string";}s:6:"txnkey";a:3:{s:4:"type";s:4:"text";s:5:"value";s:0:"";s:8:"validate";s:6:"string";}s:19:"authorize_md5secret";a:3:{s:4:"type";s:4:"text";s:5:"value";s:0:"";s:8:"validate";s:6:"string";}}'),
(5, '2Checkout', 'usd', 0, '2checkout', 0, 'a:2:{s:14:"twocheckout_id";a:3:{s:4:"type";s:4:"text";s:5:"value";s:0:"";s:8:"validate";s:6:"number";}s:11:"secret_word";a:3:{s:4:"type";s:4:"text";s:5:"value";s:0:"";s:8:"validate";s:6:"string";}}'),
(6, 'Moneybookers', 'usd,gbp,eur,aud,cad', 0, 'moneybookers', 0, 'a:2:{s:7:"mbemail";a:3:{s:4:"type";s:4:"text";s:5:"value";s:0:"";s:8:"validate";s:6:"string";}s:8:"mbsecret";a:3:{s:4:"type";s:4:"text";s:5:"value";s:0:"";s:8:"validate";s:6:"string";}}'),
(7, 'CCBill', 'usd', 0, 'ccbill', 0, 'a:6:{s:12:"clientAccnum";a:3:{s:4:"type";s:4:"text";s:5:"value";s:0:"";s:8:"validate";s:6:"string";}s:12:"clientSubacc";a:3:{s:4:"type";s:4:"text";s:5:"value";s:0:"";s:8:"validate";s:6:"string";}s:8:"formName";a:3:{s:4:"type";s:4:"text";s:5:"value";s:0:"";s:8:"validate";s:6:"string";}s:10:"secretword";a:3:{s:4:"type";s:4:"text";s:5:"value";s:0:"";s:8:"validate";s:6:"string";}s:8:"username";a:3:{s:4:"type";s:4:"text";s:5:"value";s:0:"";s:8:"validate";s:6:"string";}s:8:"password";a:3:{s:4:"type";s:4:"text";s:5:"value";s:0:"";s:8:"validate";s:6:"string";}}');