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

-- phpMyAdmin SQL Dump
-- version 4.0.10.7
--
http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jun 28,
2015 at 06:49 AM
-- 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 */;

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

--
--
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 ;




ALTER TABLE  `website_settings` ADD  `gateway_fee`
FLOAT NOT NULL DEFAULT  '0' AFTER  `website_logo_url` ;

ALTER TABLE 
`crypto_orders` ADD  `gateway_fee` FLOAT NOT NULL DEFAULT  '0' AFTER  `fee`
;

ALTER TABLE  `paypal_orders` ADD  `gateway_fee` FLOAT NOT NULL DEFAULT 
'0' AFTER  `paypal_email` ;

ALTER TABLE  `stripe_orders` ADD 
`gateway_fee` FLOAT NOT NULL DEFAULT  '0' AFTER  `amount` ;

ALTER TABLE 
`website_settings` ADD  `payment_options` VARCHAR( 100 ) NOT NULL AFTER 
`gateway_fee` ;

/*
delimiter ;;
create procedure foo ()
begin
    declare
continue handler for 1060 begin end;
    
	ALTER TABLE  `products` ADD 
`product_directurl` VARCHAR( 300 ) NOT NULL AFTER  `product_serials`
;

	ALTER TABLE  `payment_settings` ADD  `stripe_published_key` VARCHAR(
300 ) NOT NULL AFTER  `DOGE` ;

	ALTER TABLE  `payment_settings` ADD 
`stripe_secret_key` VARCHAR( 300 ) NOT NULL AFTER  `stripe_published_key`
;
	
	ALTER TABLE  `website_settings` ADD  `website_logo_url` VARCHAR( 200 )
NOT NULL AFTER  `website_title` ;
	
end;;

call foo();
*/

/*!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 */;