Просмотр архива Money Exchange Script v2.1

CREATE TABLE IF NOT EXISTS `settings` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `description`
varchar(255) NOT NULL,
  `keywords` varchar(255) NOT NULL,
  `sitename`
varchar(255) NOT NULL,
  `siteemail` varchar(255) NOT NULL,
  `url`
varchar(255) NOT NULL,
  `referral_comission` varchar(255) NOT NULL,
 
`wallet_comission` varchar(255) NOT NULL,
  `exchminamount` varchar(255)
NOT NULL,
  `exchtimewithoper` varchar(255) NOT NULL,
 
`exchtimewithoutoper` varchar(255) NOT NULL,
  `earnings` varchar(255) NOT
NULL,
  `p_about` text NOT NULL,
  `p_terms` text NOT NULL,
  `p_poilcy`
text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8
AUTO_INCREMENT=1;


CREATE TABLE IF NOT EXISTS `faq` (
  `id` int(11) NOT
NULL AUTO_INCREMENT,
  `question` text NOT NULL,
  `answer` text NOT NULL,

 PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8
AUTO_INCREMENT=1;



CREATE TABLE IF NOT EXISTS `companies` (
  `id`
int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
 
`a_field_1` varchar(255) NOT NULL,
  `a_field_2` varchar(255) NOT NULL,
 
`a_field_3` varchar(255) NOT NULL,
  `a_field_4` varchar(255) NOT NULL,
 
`a_field_5` varchar(255) NOT NULL,
  `a_field_6` varchar(255) NOT NULL,
 
`a_field_7` varchar(255) NOT NULL,
  `a_field_8` varchar(255) NOT NULL,
 
`a_field_9` varchar(255) NOT NULL,
  `a_field_10` varchar(255) NOT NULL,
 
`allow_send` int(11) NOT NULL,
  `receive_list` text NOT NULL,
  PRIMARY
KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

INSERT
INTO `companies` (`id`, `name`, `a_field_1`, `a_field_2`, `a_field_3`,
`a_field_4`, `a_field_5`, `a_field_6`, `a_field_7`, `a_field_8`,
`a_field_9`, `a_field_10`, `allow_send`, `receive_list`) VALUES
(1,
'PayPal', '', '', '', '', '', '', '', '', '', '', 1, 'PayPal,Payeer,Perfect
Money,AdvCash,OKPay,Entromoney,Payza,Bitcoin,Bank Transfer,Western
union,Moneygram'),
(2, 'Payeer', '', '', '', '', '', '', '', '', '', '', 1,
'PayPal,Payeer,Perfect Money,AdvCash,OKPay,Entromoney,Payza,Bitcoin,Bank
Transfer,Western union,Moneygram'),
(3, 'Perfect Money', '', '', '', '',
'', '', '', '', '', '', 1, 'PayPal,Payeer,Perfect
Money,AdvCash,OKPay,Entromoney,Payza,Bitcoin,Bank Transfer,Western
union,Moneygram'),
(4, 'AdvCash', '', '', '', '', '', '', '', '', '', '',
1, 'PayPal,Payeer,Perfect Money,AdvCash,OKPay,Entromoney,Payza,Bitcoin,Bank
Transfer,Western union,Moneygram'),
(5, 'OKPay', '', '', '', '', '', '',
'', '', '', '', 1, 'PayPal,Payeer,Perfect
Money,AdvCash,OKPay,Entromoney,Payza,Bitcoin,Bank Transfer,Western
union,Moneygram'),
(6, 'Entromoney', '', '', '', '', '', '', '', '', '',
'', 1, 'PayPal,Payeer,Perfect
Money,AdvCash,OKPay,Entromoney,Payza,Bitcoin,Bank Transfer,Western
union,Moneygram'),
(7, 'Payza', '', '', '', '', '', '', '', '', '', '', 1,
'PayPal,Payeer,Perfect Money,AdvCash,OKPay,Entromoney,Payza,Bitcoin,Bank
Transfer,Western union,Moneygram'),
(8, 'Bitcoin', '', '', '', '', '', '',
'', '', '', '', 1, 'PayPal,Payeer,Perfect
Money,AdvCash,OKPay,Entromoney,Payza,Bitcoin,Bank Transfer,Western
union,Moneygram'),
(9, 'Bank Transfer', '', '', '', '', '', '', '', '', '',
'', 1, 'PayPal,Payeer,Perfect
Money,AdvCash,OKPay,Entromoney,Payza,Bitcoin,Bank Transfer,Western
union,Moneygram'),
(10, 'Western union', '', '', '', '', '', '', '', '',
'', '', 1, 'PayPal,Payeer,Perfect
Money,AdvCash,OKPay,Entromoney,Payza,Bitcoin,Bank Transfer,Western
union,Moneygram'),
(11, 'Moneygram', '', '', '', '', '', '', '', '', '',
'', 1, 'PayPal,Payeer,Perfect
Money,AdvCash,OKPay,Entromoney,Payza,Bitcoin,Bank Transfer,Western
union,Moneygram');

CREATE TABLE IF NOT EXISTS `currencies` (
  `id`
int(11) NOT NULL AUTO_INCREMENT,
  `cid` int(11) NOT NULL,
  `company_from`
varchar(255) NOT NULL,
  `company_to` varchar(255) NOT NULL,
 
`currency_from` varchar(255) NOT NULL,
  `currency_to` varchar(255) NOT
NULL,
  `rate` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM 
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

CREATE TABLE IF NOT EXISTS
`exchanges` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT
NULL,
  `wallet_id` int(11) NOT NULL,
  `cfrom` varchar(255) NOT NULL,
 
`cto` varchar(255) NOT NULL,
  `amount_from` varchar(255) NOT NULL,
 
`currency_from` varchar(255) NOT NULL,
  `amount_to` varchar(255) NOT
NULL,
  `currency_to` varchar(255) NOT NULL,
  `rate` varchar(255) NOT
NULL,
  `status` int(11) NOT NULL,
  `created` int(11) NOT NULL,
 
`updated` int(11) NOT NULL,
  `expired` int(11) NOT NULL,
  `u_field_1`
varchar(255) NOT NULL,
  `u_field_2` varchar(255) NOT NULL,
  `u_field_3`
varchar(255) NOT NULL,
  `u_field_4` varchar(255) NOT NULL,
  `u_field_5`
varchar(255) NOT NULL,
  `u_field_6` varchar(255) NOT NULL,
  `u_field_7`
varchar(255) NOT NULL,
  `u_field_8` varchar(255) NOT NULL,
  `u_field_9`
varchar(255) NOT NULL,
  `u_field_10` varchar(255) NOT NULL,
  `ip`
varchar(255) NOT NULL,
  `transaction_id` varchar(255) NOT NULL,
 
`exchange_id` varchar(255) NOT NULL,
  `referral_id` varchar(255) NOT
NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8
AUTO_INCREMENT=1;

CREATE TABLE IF NOT EXISTS `transactions` (
  `id`
int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL,
  `ip`
varchar(255) NOT NULL,
  `txn_id` varchar(255) NOT NULL,
  `payee`
varchar(255) NOT NULL,
  `company` varchar(255) NOT NULL,
  `amount`
varchar(255) NOT NULL,
  `currency` varchar(255) NOT NULL,
  `time`
varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1;

CREATE TABLE IF NOT EXISTS `users` (
  `id`
int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
 
`username` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
 
`password_recovery` varchar(255) NOT NULL,
  `email` varchar(255) NOT
NULL,
  `earnings` varchar(255) NOT NULL,
  `ip` varchar(255) NOT NULL,
 
`status` int(11) NOT NULL,
  `signuptime` int(11) NOT NULL,
 
`lastsignintime` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM 
DEFAULT CHARSET=utf8 AUTO_INCREMENT=10000;

CREATE TABLE IF NOT EXISTS
`wallets` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT
NULL,
  `amount` varchar(255) NOT NULL,
  `currency` varchar(255) NOT
NULL,
  `created` varchar(255) NOT NULL,
  `updated` varchar(255) NOT
NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8
AUTO_INCREMENT=1;

CREATE TABLE IF NOT EXISTS `earnings` (
  `id` int(11)
NOT NULL AUTO_INCREMENT,
  `amount` varchar(255) NOT NULL,
  `currency`
varchar(255) NOT NULL,
  `company` varchar(255) NOT NULL,
  `date`
varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1;

CREATE TABLE IF NOT EXISTS `testimonials`
(
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL,
 
`content` text NOT NULL,
  `status` int(11) NOT NULL,
  `time` int(11) NOT
NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8
AUTO_INCREMENT=1;

CREATE TABLE IF NOT EXISTS `withdrawals` (
  `id`
int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL,
  `wallet_id`
int(11) NOT NULL,
  `amount` varchar(255) NOT NULL,
  `currency`
varchar(255) NOT NULL,
  `company` varchar(255) NOT NULL,
  `account`
varchar(255) NOT NULL,
  `status` int(11) NOT NULL,
  `requested_on`
int(11) NOT NULL,
  `processed_on` int(11) NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;