Просмотр архива PayPro - Your Own Digital Download Payment Gateway

-- phpMyAdmin SQL Dump
-- version 4.0.10.7
--
http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jul 12,
2015 at 01:24 PM
-- Server version: 5.5.42-cll
-- PHP Version: 5.4.23

SET
SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone =
"+00:00";


/*!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: `tomtem6_paypro`
--

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

--
-- Table
structure for table `billing`
--

CREATE TABLE IF NOT EXISTS `billing` (
 
`id` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(150) NOT NULL,
 
`current_balance` float NOT NULL,
  `last_paid` varchar(100) NOT NULL,
 
`deliquent` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE
KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1
;



--
-- Table structure for table `billing_records`
--

CREATE TABLE IF
NOT EXISTS `billing_records` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
 
`email` varchar(150) NOT NULL,
  `amount` float NOT NULL,
  `time`
varchar(100) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
)
ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;



--
-- Table
structure for table `coupons`
--

CREATE TABLE IF NOT EXISTS `coupons` (
 
`id` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(100) NOT NULL,
 
`product_id` int(11) NOT NULL,
  `coupon_name` varchar(100) CHARACTER SET
utf8 COLLATE utf8_unicode_ci NOT NULL,
  `percentage_off` float NOT NULL,
 
`expiry_usage` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE
KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1
;



--
-- Table structure for table `crypto_orders`
--

CREATE TABLE IF
NOT EXISTS `crypto_orders` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
 
`product_id` int(11) NOT NULL,
  `payment_status` text NOT NULL,
 
`currency` varchar(20) NOT NULL,
  `amount_usd` text NOT NULL,
 
`amount_crypto` text NOT NULL,
  `fee` text NOT NULL,
  `gateway_fee` float
NOT NULL DEFAULT '0',
  `net` text NOT NULL,
  `amount_needed` text NOT
NULL,
  `received_amount` text NOT NULL,
  `txn_id` text NOT NULL,
  `time`
varchar(100) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
)
ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


--
-- Table
structure for table `crypto_withdraw`
--

CREATE TABLE IF NOT EXISTS
`crypto_withdraw` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `order`
int(11) NOT NULL,
  `amount` varchar(200) NOT NULL,
  `sent` int(11) NOT
NULL,
  `txn_id` varchar(200) NOT NULL,
  `time` varchar(200) NOT NULL,
 
PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT
CHARSET=latin1 AUTO_INCREMENT=1 ;



--
-- Table structure for table
`download_links`
--

CREATE TABLE IF NOT EXISTS `download_links` (
  `id`
int(11) NOT NULL AUTO_INCREMENT,
  `product_id` int(11) NOT NULL,
 
`temp_url` varchar(300) NOT NULL,
  `init_time` varchar(200) NOT NULL,
 
`end_time` varchar(200) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id`
(`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;



--
--
Table structure for table `payment_settings`
--

CREATE TABLE IF NOT EXISTS
`payment_settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email`
varchar(200) NOT NULL,
  `PayPal` varchar(200) NOT NULL DEFAULT '0',
 
`BTC` varchar(35) NOT NULL DEFAULT '0',
  `LTC` varchar(200) NOT NULL
DEFAULT '0',
  `DOGE` varchar(200) NOT NULL DEFAULT '0',
 
`stripe_published_key` varchar(200) NOT NULL,
  `stripe_secret_key`
varchar(200) NOT NULL,
  `LTCT` varchar(200) NOT NULL,
  PRIMARY KEY
(`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1
AUTO_INCREMENT=1 ;


--
-- Table structure for table
`paypal_orders`
--

CREATE TABLE IF NOT EXISTS `paypal_orders` (
  `id`
int(11) NOT NULL AUTO_INCREMENT,
  `product_id` int(11) NOT NULL,
 
`payment_status` varchar(50) NOT NULL,
  `payment_amount` double NOT NULL,

 `payment_currency` varchar(200) NOT NULL,
  `paypal_email` varchar(200)
NOT NULL,
  `gateway_fee` float NOT NULL DEFAULT '0',
  `txn_id`
varchar(200) NOT NULL,
  `timestamp` varchar(200) NOT NULL,
  PRIMARY KEY
(`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1
AUTO_INCREMENT=1 ;



--
-- Table structure for table `products`
--

CREATE
TABLE IF NOT EXISTS `products` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
 
`username` varchar(50) NOT NULL,
  `email` varchar(200) NOT NULL,
 
`product_title` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT
NULL,
  `product_price` double NOT NULL,
  `product_description` text
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `product_type`
varchar(200) NOT NULL,
  `product_upload` varchar(500) NOT NULL,
 
`product_upload_name` varchar(200) CHARACTER SET utf8 COLLATE
utf8_unicode_ci NOT NULL,
  `product_serials` varchar(500) CHARACTER SET
utf8 COLLATE utf8_unicode_ci NOT NULL,
  `product_directurl` varchar(300)
NOT NULL,
  `product_currency` varchar(200) NOT NULL,
  `time` varchar(200)
NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM 
DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;



--
-- Table structure for
table `public_page`
--

CREATE TABLE IF NOT EXISTS `public_page` (
  `id`
int(11) NOT NULL AUTO_INCREMENT,
  `product_id` int(11) NOT NULL,
  PRIMARY
KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT
CHARSET=latin1 AUTO_INCREMENT=1 ;



--
-- Table structure for table
`stripe_orders`
--

CREATE TABLE IF NOT EXISTS `stripe_orders` (
  `id`
int(11) NOT NULL AUTO_INCREMENT,
  `product_id` int(11) NOT NULL,
  `email`
varchar(100) NOT NULL,
  `amount` double NOT NULL,
  `gateway_fee` float
NOT NULL DEFAULT '0',
  `time` text NOT NULL,
  PRIMARY KEY (`id`),
 
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1
AUTO_INCREMENT=1 ;



--
-- Table structure for table `users`
--

CREATE
TABLE IF NOT EXISTS `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
 
`username` varchar(50) NOT NULL,
  `email` varchar(150) NOT NULL,
 
`password` varchar(200) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id`
(`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;



--
--
Table structure for table `website_settings`
--

CREATE TABLE IF NOT EXISTS
`website_settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
 
`website_title` varchar(100) NOT NULL,
  `website_logo_url` varchar(200)
NOT NULL,
  `gateway_fee` float NOT NULL DEFAULT '0',
  `payment_options`
varchar(100) NOT NULL,
  `max_upload_size` int(11) NOT NULL,
 
`email_smtp_host` varchar(150) NOT NULL,
  `email_address` varchar(150) NOT
NULL,
  `email_password` varchar(150) NOT NULL,
  `email_smtp_port` int(11)
NOT NULL,
  `cp_private_key` varchar(200) NOT NULL,
  `cp_public_key`
varchar(200) NOT NULL,
  `cp_merchant_id` varchar(200) NOT NULL,
 
`cp_ipn_secret` varchar(200) NOT NULL,
  `stripe_secret_key` varchar(100)
NOT NULL,
  `stripe_published_key` varchar(100) NOT NULL,
  PRIMARY KEY
(`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1
AUTO_INCREMENT=1 ;

--
-- Dumping data for table
`website_settings`
--

INSERT INTO `website_settings` (`id`,
`website_title`, `website_logo_url`, `gateway_fee`, `payment_options`,
`max_upload_size`, `email_smtp_host`, `email_address`, `email_password`,
`email_smtp_port`, `cp_private_key`, `cp_public_key`, `cp_merchant_id`,
`cp_ipn_secret`, `stripe_secret_key`, `stripe_published_key`) VALUES
(1,
'PayPro', 'https://paypro.io/assets/images/logo_big.png', 0,
'PayPal,BTC,LTC,DOGE,STRIPE', 50, '', 'product@paypro.io', '', 465, '', '',
'', '', '', '');

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