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

CREATE TABLE IF NOT EXISTS `subscription` (
  `subscriptionid` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `cost` mediumtext,
  `forums` mediumtext NOT NULL,
  `nusergroupid` smallint(6) NOT NULL DEFAULT '0',
  `membergroupids` varchar(255) NOT NULL DEFAULT '',
  `active` smallint(5) unsigned NOT NULL DEFAULT '0',
  `displayorder` smallint(5) unsigned NOT NULL DEFAULT '1',
  `options` int(10) unsigned NOT NULL DEFAULT '0',
  `vbp_vbbuxsub` decimal(30,5) NOT NULL DEFAULT '0.00000',
  `adminoptions` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`subscriptionid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `subscription`
--

INSERT INTO `subscription` (`subscriptionid`, `cost`, `forums`, `nusergroupid`, `membergroupids`, `active`, `displayorder`, `options`, `vbp_vbbuxsub`, `adminoptions`) VALUES
(1, 'a:1:{i:0;a:6:{s:4:"cost";a:5:{s:3:"usd";s:5:"10.00";s:3:"gbp";s:4:"0.00";s:3:"eur";s:4:"0.00";s:3:"aud";s:4:"0.00";s:3:"cad";s:4:"0.00";}s:6:"length";i:1;s:5:"units";s:1:"Y";s:9:"recurring";i:1;s:11:"ccbillsubid";s:0:"";s:18:"twocheckout_prodid";s:0:"";}}', '279,280,96,175', -1, '9', 1, 1, 2, 1000.00000, 0),
(2, 'a:1:{i:0;a:6:{s:4:"cost";a:5:{s:3:"usd";s:5:"25.00";s:3:"gbp";s:4:"0.00";s:3:"eur";s:4:"0.00";s:3:"aud";s:4:"0.00";s:3:"cad";s:4:"0.00";}s:6:"length";i:1;s:5:"units";s:1:"Y";s:9:"recurring";i:1;s:11:"ccbillsubid";s:0:"";s:18:"twocheckout_prodid";s:0:"";}}', '279,280,96,175', -1, '10', 1, 2, 4, 2500.00000, 0),
(3, 'a:1:{i:0;a:6:{s:4:"cost";a:5:{s:3:"usd";s:5:"50.00";s:3:"gbp";s:4:"0.00";s:3:"eur";s:4:"0.00";s:3:"aud";s:4:"0.00";s:3:"cad";s:4:"0.00";}s:6:"length";i:1;s:5:"units";s:1:"Y";s:9:"recurring";i:1;s:11:"ccbillsubid";s:0:"";s:18:"twocheckout_prodid";s:0:"";}}', '', -1, '27', 1, 3, 4, 5000.00000, 0),
(4, 'a:3:{i:0;a:6:{s:4:"cost";a:5:{s:3:"usd";s:6:"225.00";s:3:"gbp";s:4:"0.00";s:3:"eur";s:4:"0.00";s:3:"aud";s:4:"0.00";s:3:"cad";s:4:"0.00";}s:6:"length";i:3;s:5:"units";s:1:"M";s:9:"recurring";i:1;s:11:"ccbillsubid";s:0:"";s:18:"twocheckout_prodid";s:0:"";}i:1;a:6:{s:4:"cost";a:5:{s:3:"usd";s:6:"420.00";s:3:"gbp";s:4:"0.00";s:3:"eur";s:4:"0.00";s:3:"aud";s:4:"0.00";s:3:"cad";s:4:"0.00";}s:6:"length";i:6;s:5:"units";s:1:"M";s:11:"ccbillsubid";s:0:"";s:18:"twocheckout_prodid";s:0:"";s:9:"recurring";i:0;}i:2;a:6:{s:4:"cost";a:5:{s:3:"usd";s:6:"720.00";s:3:"gbp";s:4:"0.00";s:3:"eur";s:4:"0.00";s:3:"aud";s:4:"0.00";s:3:"cad";s:4:"0.00";}s:6:"length";i:12;s:5:"units";s:1:"M";s:11:"ccbillsubid";s:0:"";s:18:"twocheckout_prodid";s:0:"";s:9:"recurring";i:0;}}', '', 48, '', 1, 4, 0, 0.00000, 0);