-- phpMyAdmin SQL Dump
-- version 3.2.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Feb 20, 2010 at 01:59 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 `paymentinfo`
--

CREATE TABLE IF NOT EXISTS `paymentinfo` (
  `paymentinfoid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `hash` varchar(32) NOT NULL DEFAULT '',
  `subscriptionid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `subscriptionsubid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `userid` int(10) unsigned NOT NULL DEFAULT '0',
  `completed` smallint(6) NOT NULL DEFAULT '0',
  PRIMARY KEY (`paymentinfoid`),
  KEY `hash` (`hash`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=81 ;

--
-- Dumping data for table `paymentinfo`
--

INSERT INTO `paymentinfo` (`paymentinfoid`, `hash`, `subscriptionid`, `subscriptionsubid`, `userid`, `completed`) VALUES
(1, 'fd53a6aef41108a5f153de3e77c2c6a7', 1, 0, 1, 0),
(2, '7495a569a56a4297ea2f17e18942292d', 2, 0, 6400, 0),
(3, '15266d87bda516095d4f855b82e5fb68', 3, 0, 8103, 0),
(4, '23e4d7e9cf9a00b6487607f420f5eb18', 2, 0, 6209, 0),
(5, 'd3f70694237785b0433c6f03bb1f8209', 3, 0, 8012, 0),
(6, '3b0f90f4a9c5ff0eddbc5618e5dc6bb9', 2, 0, 6468, 0),
(7, 'c7189841a5c8e85ea91d5737e48650e8', 3, 0, 3370, 0),
(8, 'f038bcc44e0af5ff120bd0064262bc98', 2, 0, 8564, 0),
(9, 'ba6603bfdb171a6b61d240457df88ff0', 1, 0, 3369, 0),
(10, '31228eea219914b894da3b7d0ffa9cbe', 1, 0, 9300, 0),
(11, '395d15ac98e7cb8539a81e4b6c860ecb', 3, 0, 3719, 0),
(12, 'd08a5028bebdef7bc7504668bbe0b5a6', 2, 0, 9368, 0),
(13, '236477a65f7070638dd12c6e340d2cb3', 2, 0, 892, 0),
(14, '4b564b3fa515a12843ddc81f10585b36', 3, 0, 9523, 0),
(15, '0d6553e92836680a2398ff425077310e', 2, 0, 4600, 0),
(16, 'fc8279f0d1ea08bdaae332c07b3ac880', 2, 0, 9834, 0),
(17, '9a3b906d66d586f46b986d30e9bab9f6', 1, 0, 7390, 0),
(18, '344c68c8453e3995a29429a012887524', 3, 0, 5998, 0),
(19, 'dad74af388e73d8b5f05fa5478e8a156', 3, 0, 9808, 0),
(20, '1681d11ce181181b50c713568fc36247', 3, 0, 9808, 0),
(21, '5cd74192612aaf531b7a51235828394a', 3, 0, 9808, 0),
(22, '0474880d908c3e30331f481e77cfd98e', 1, 0, 7121, 0),
(23, '88e0b412e627fb9051f2781114c1d956', 2, 0, 9627, 0),
(24, '947802189bf9c3448a766863b0564559', 3, 0, 9808, 0),
(25, '70b483f14aa6cfaaf13422955c03c4ed', 1, 0, 10103, 0),
(26, '63996d8985c36df48891c02f5b3821a8', 3, 0, 1968, 0),
(27, '8c1ec445c65e9cd52be07fc6f4d3ac04', 3, 0, 10322, 0),
(28, 'bec6b848cd726cc71108e6fdcfd7bb12', 3, 0, 10354, 0),
(29, 'a840f94e1f2bb89334f97a6928930454', 3, 0, 2996, 0),
(30, '00b36aacbd2799fb566cebf50785f4bc', 1, 0, 1071, 0),
(31, '178e7cf51f66856951bc82817c77e5a1', 3, 0, 1195, 0),
(32, '90456444175b197a106cb681c50a1e39', 3, 0, 10564, 0),
(33, 'cc5090338abe961f92acbdcbfffd568a', 1, 0, 4349, 0),
(34, '19773974624905b9667406753e7b1aaf', 3, 0, 10031, 0),
(35, 'fc53b75759e187a26dac445cb62ffaf6', 3, 0, 10813, 0),
(36, 'fc766c9667d67cf1766ad078c1229873', 3, 0, 10891, 0),
(37, 'b375ce7c48d802a4d9615853dc1c3cd9', 1, 0, 8278, 0),
(38, '915dc8a459f458eab8f47e81f596f953', 3, 0, 7225, 0),
(39, 'b2747d0ecf66ef60724a331f15db0a10', 1, 0, 11389, 0),
(40, '3164f83086b55f6c50ba57025ccb73b1', 1, 0, 11845, 0),
(41, '720720bee2327bba2296a744db1a1e8d', 3, 0, 3719, 0),
(42, '5be3af0f35f57c3fb1fbf7eb5df54ae6', 2, 0, 9396, 0),
(43, 'bdb7d101dda9eea1862bdef8d28437ea', 3, 0, 9808, 0),
(44, 'a40e93be0e8c9c9342c0a57ffe106296', 3, 0, 2559, 0),
(45, 'e420afef7ccc493c9790b7ec647b3f7e', 3, 0, 2559, 0),
(46, '28f8a08fd92316fd7d2d3b01d997f030', 3, 0, 10354, 0),
(47, 'bfb9967840d89001a2f5ae6e7f3af5df', 2, 0, 11635, 0),
(48, '55b7be3c75bb8e7b2158d98c105410bc', 3, 0, 1195, 0),
(49, '1ab28f3caed581cb3924af3dbf78d861', 1, 0, 8278, 0),
(50, '21dbadfeb43d923d1f0509e59d6f8f0d', 1, 0, 13386, 0),
(51, 'c8e235e214e09ebcb9479e1167a457fe', 2, 0, 11845, 0),
(52, '476a0603206604ad9d41724312c4e7e7', 3, 0, 13386, 0),
(53, 'fdda5a8d6fd9864bbec09259ec175868', 3, 0, 4541, 0),
(54, 'a61bb202a5c5ec6f223b6cd9cdc1fbfd', 3, 0, 4541, 0),
(55, '726f4dc935ae5131193ba1457e44c9a1', 3, 0, 4541, 0),
(56, '2b2c9ad88083c42776027d2dd127a5bf', 1, 0, 8600, 0),
(57, 'ca959d5946234a7f16183d98fecfb8ed', 2, 0, 8868, 0),
(58, '9209ceac9752b00ec2aaa795fbedbb1f', 3, 0, 13386, 0),
(59, 'b288e1f584db0741726e79ec9798b56d', 3, 0, 13848, 0),
(60, 'd73ae5765e38faaf3e806e59c29a5f1b', 2, 0, 4600, 0),
(61, '75d3d20d19063621e15fb308be02db3c', 2, 0, 12309, 0),
(62, 'daf590cc384eb5e8f5559263a21102df', 1, 0, 13727, 0),
(63, 'f3d99a2dac2bc5744511791cb26dcab7', 1, 0, 13727, 0),
(64, 'c8ee157cc46af0caf42e3f3aa92ff978', 1, 0, 13727, 0),
(65, '462724363745e8273cc74a012d6597ab', 3, 0, 3975, 0),
(66, '742193ad083958a2956e08a03618365d', 3, 0, 12309, 0),
(67, '826e4bf703737b01b4230b10189d1cee', 3, 0, 12309, 0),
(68, 'c648ea9ba63ce98d4dc82b594030d5c3', 1, 0, 11719, 0),
(69, 'e298242db97f574beb47c6a2ab26ae66', 2, 0, 12829, 0),
(70, '9ef69c481cd652a8070db1425ca3eb59', 1, 0, 13913, 0),
(71, '4bd3f47428f78437fe53951583ae582c', 2, 0, 12293, 0),
(72, 'aa4227d46bf045226ba910cfd40872a6', 2, 0, 11442, 0),
(73, 'c18aa6e7f74dbbd797f47b5e11b26130', 2, 0, 13941, 0),
(74, '04117f19129388ba35b9f2d38d0a21d1', 3, 0, 6024, 0),
(75, '106e48039ee3b93c7ec69958c6bf580c', 3, 0, 6024, 0),
(76, '465744ebed866c51c8114134a66ff01f', 2, 0, 4947, 0),
(77, '5dadb8689ae55e4d0839ebcb8d52dc17', 3, 0, 12309, 0),
(78, 'd84572b4a7422d2fe3eee89ae9f34563', 3, 0, 9808, 0),
(79, '59ba600485a686dffb85bf590bd735b6', 3, 0, 5887, 0),
(80, '3adfa0b202d906553a6c1f8d08fbecce', 3, 0, 5887, 0);