-- phpMyAdmin SQL Dump
-- version 2.11.11.3
-- http://www.phpmyadmin.net
--
-- : localhost
--  :  24 2016 ., 15:32
--  : 5.1.73
--  PHP: 5.3.3

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
--  : `cloud`
--

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

--
--   `addmoney`
--

CREATE TABLE IF NOT EXISTS `addmoney` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user` varchar(60) NOT NULL,
  `sum` float(9,2) NOT NULL DEFAULT '0.00',
  `order` varchar(60) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 ;


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

--
--   `invoices`
--

CREATE TABLE IF NOT EXISTS `invoices` (
  `invoice_id` int(11) NOT NULL DEFAULT '0',
  `price_in_usd` double DEFAULT NULL,
  `price_in_btc` double DEFAULT NULL,
  `product_url` text,
  PRIMARY KEY (`invoice_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
--    `invoices`
--

INSERT INTO `invoices` (`invoice_id`, `price_in_usd`, `price_in_btc`, `product_url`) VALUES
(9001, 0.01, 4.176e-05, 'nutbolt.jpg'),
(900, 0.01, 4.192e-05, 'nutbolt.jpg');

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

--
--   `invoice_payments`
--

CREATE TABLE IF NOT EXISTS `invoice_payments` (
  `transaction_hash` char(64) NOT NULL DEFAULT '',
  `value` double DEFAULT NULL,
  `invoice_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`transaction_hash`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
--    `invoice_payments`
--


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

--
--   `merchant`
--

CREATE TABLE IF NOT EXISTS `merchant` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `url_sayt` varchar(255) NOT NULL,
  `url_success` varchar(255) NOT NULL,
  `url_result` varchar(255) NOT NULL,
  `url_fail` varchar(255) NOT NULL,
  `merchant_id` varchar(255) NOT NULL,
  `secret_key` varchar(255) NOT NULL,
  `act` int(1) NOT NULL DEFAULT '0',
  `user` int(11) NOT NULL,
  `balance` float(9,2) NOT NULL DEFAULT '0.00',
  `banned` varchar(1) DEFAULT '0',
  `percent` varchar(3) NOT NULL DEFAULT '3',
  `percent_ym` varchar(3) NOT NULL DEFAULT '3',
  `percent_lp` varchar(3) NOT NULL DEFAULT '3',
  `percent_pri` varchar(3) NOT NULL DEFAULT '3',
  `percent_ego` varchar(3) NOT NULL DEFAULT '3',
  `percent_okpay` varchar(3) NOT NULL DEFAULT '3',
  `percent_perf` varchar(3) NOT NULL DEFAULT '3',
  `percent_wallet` varchar(3) NOT NULL DEFAULT '3',
  `percent_easypay` varchar(3) NOT NULL DEFAULT '3',
  `percent_payeer` varchar(3) NOT NULL DEFAULT '3',
  `per_s` int(1) NOT NULL DEFAULT '0' COMMENT ' ',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 ;



--
--   `pending_invoice_payments`
--

CREATE TABLE IF NOT EXISTS `pending_invoice_payments` (
  `transaction_hash` char(64) NOT NULL DEFAULT '',
  `value` double DEFAULT NULL,
  `invoice_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`transaction_hash`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
--    `pending_invoice_payments`
--


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

--
--   `ptatezh`
--

CREATE TABLE IF NOT EXISTS `ptatezh` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `amount` float(9,2) NOT NULL,
  `pay_amount` float(9,2) NOT NULL DEFAULT '0.00',
  `desc` varchar(255) NOT NULL,
  `merchant_id` varchar(255) NOT NULL,
  `secret_key` varchar(255) NOT NULL,
  `ip` varchar(30) NOT NULL,
  `data` varchar(20) NOT NULL,
  `payment_id` varchar(255) NOT NULL,
  `ok` int(1) NOT NULL DEFAULT '0',
  `sistema_pl` varchar(50) NOT NULL,
  `order_pay` int(11) NOT NULL,
  `success` varchar(255) NOT NULL,
  `fail` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 ;


--
--   `seting`
--

CREATE TABLE IF NOT EXISTS `seting` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `percent` int(1) DEFAULT '3',
  `percent_ym` varchar(3) DEFAULT '0.5',
  `percent_lp` varchar(3) DEFAULT '0.5',
  `percent_pri` varchar(3) NOT NULL DEFAULT '0.5',
  `percent_ego` varchar(3) NOT NULL DEFAULT '0.5',
  `percent_okpay` varchar(3) NOT NULL DEFAULT '0.5',
  `percent_perf` varchar(3) NOT NULL DEFAULT '0.5',
  `percent_wallet` varchar(3) NOT NULL DEFAULT '0.5',
  `percent_easypay` varchar(3) NOT NULL DEFAULT '0.5',
  `percent_payeer` varchar(3) NOT NULL DEFAULT '0.5',
  `curs_usd` varchar(10) NOT NULL,
  `curs_uah` varchar(10) NOT NULL,
  `yandex` int(1) NOT NULL DEFAULT '0',
  `liqpay` int(1) NOT NULL DEFAULT '0',
  `privat` int(1) NOT NULL DEFAULT '0',
  `egopay` int(1) NOT NULL DEFAULT '0',
  `okpay` int(1) NOT NULL DEFAULT '0',
  `perfect` int(1) DEFAULT '0',
  `wallet_rur` int(1) DEFAULT '0',
  `accaunt_mon` int(1) DEFAULT '0',
  `visa` int(1) NOT NULL DEFAULT '0',
  `mastercard` int(1) NOT NULL DEFAULT '0',
  `easypay` int(1) NOT NULL DEFAULT '0',
  `payeer` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=2 ;

--
--    `seting`
--

INSERT INTO `seting` (`id`, `percent`, `percent_ym`, `percent_lp`, `percent_pri`, `percent_ego`, `percent_okpay`, `percent_perf`, `percent_wallet`, `percent_easypay`, `percent_payeer`, `curs_usd`, `curs_uah`, `yandex`, `liqpay`, `privat`, `egopay`, `okpay`, `perfect`, `wallet_rur`, `accaunt_mon`, `visa`, `mastercard`, `easypay`, `payeer`) VALUES
(1, 3, '5', '2', '2', '2', '5', '2', '2', '2', '10', '67.6409', '0.39', 1, 0, 0, 0, 0, 1, 0, 1, 1, 1, 0, 1);

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

--
--   `seting_pay`
--

CREATE TABLE IF NOT EXISTS `seting_pay` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `wallet_yan` varchar(20) DEFAULT '0',
  `liqpay_id` varchar(20) DEFAULT '0',
  `liqpay_sig` varchar(100) DEFAULT '0',
  `wallet_liq` varchar(20) NOT NULL DEFAULT '0',
  `id_privat24` varchar(20) NOT NULL DEFAULT '0',
  `wallet_ego` varchar(20) NOT NULL DEFAULT '0',
  `pas_ego` varchar(50) NOT NULL DEFAULT '0',
  `wallet_okpay` varchar(50) NOT NULL DEFAULT '0',
  `wallet_perf` varchar(10) NOT NULL DEFAULT '0',
  `perf_name` varchar(50) NOT NULL DEFAULT '0',
  `wallet_w1` varchar(40) NOT NULL DEFAULT '0',
  `key_w1` varchar(200) NOT NULL DEFAULT '0',
  `easy_id` varchar(100) NOT NULL DEFAULT '0',
  `payeer_shop` varchar(20) NOT NULL DEFAULT '0',
  `payer_key` varchar(100) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=2 ;

--
--    `seting_pay`
--

INSERT INTO `seting_pay` (`id`, `wallet_yan`, `liqpay_id`, `liqpay_sig`, `wallet_liq`, `id_privat24`, `wallet_ego`, `pas_ego`, `wallet_okpay`, `wallet_perf`, `perf_name`, `wallet_w1`, `key_w1`, `easy_id`, `payeer_shop`, `payer_key`) VALUES
(1, '410019112', 'i4261397', 'Z01NW9EySCkJ', '79054', '1099', 'P2KX7X92Q', 'u0pLPH3tHI4', 'aleksa.ru', 'U111', 'OrderID', '14202', '566c376476716f65487c7348', 'f33a7b5f01020c5501', '5683', 'Y5tqTXfS');

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

--
--   `user`
--

CREATE TABLE IF NOT EXISTS `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `login` varchar(20) NOT NULL,
  `email` varchar(50) NOT NULL,
  `reserve_email` varchar(50) NOT NULL COMMENT ' ',
  `pass` varchar(20) NOT NULL,
  `data` varchar(20) NOT NULL,
  `ip` varchar(30) NOT NULL,
  `ip_log` varchar(30) NOT NULL,
  `money` float(9,2) NOT NULL DEFAULT '0.00',
  `money_out` float(9,2) NOT NULL DEFAULT '0.00',
  `part` int(11) NOT NULL,
  `phone` varchar(19) NOT NULL DEFAULT '0',
  `pay_cod` varchar(6) NOT NULL DEFAULT '0',
  `family` varchar(50) NOT NULL,
  `fam_name` varchar(50) NOT NULL,
  `otchestvo` varchar(50) NOT NULL,
  `sex` int(1) NOT NULL DEFAULT '0',
  `country` varchar(60) NOT NULL,
  `indexstat` varchar(15) NOT NULL,
  `gorod` varchar(20) NOT NULL,
  `adres` varchar(50) NOT NULL,
  `passport` varchar(50) NOT NULL,
  `passport_d` varchar(12) NOT NULL,
  `passport_m` varchar(20) NOT NULL,
  `passport_k` varchar(150) NOT NULL,
  `inn` varchar(50) NOT NULL,
  `privel` varchar(3) NOT NULL DEFAULT 'not',
  `wallet` varchar(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 ;