CREATE TABLE IF NOT EXISTS `bit_settings` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(255) NULL, `description` varchar(255) NULL, `keywords` varchar(255) NULL, `name` varchar(255) NULL, `infoemail` varchar(255) NULL, `supportemail` varchar(255) NULL, `whatsapp` varchar(255) NULL, `skype` varchar(255) NULL, `url` varchar(255) NULL, `referral_comission` varchar(255) NULL, `wallet_comission` varchar(255) NULL, `login_to_exchange` int(11) NULL, `document_verification` int(11) NULL, `email_verification` int(11) NULL, `phone_verification` int(11) NULL, `recaptcha_verification` int(11) NULL, `recaptcha_publickey` varchar(255) NULL, `recaptcha_privatekey` varchar(255) NULL, `nexmo_api_key` varchar(255) NULL, `nexmo_api_secret` varchar(255) NULL, `worktime_from` varchar(255) NULL, `worktime_to` varchar(255) NULL, `worktime_gmt` varchar(255) NULL, `default_language` varchar(255) NULL, `default_template` varchar(255) NULL, `operator_status` int(11) NULL, `footer_information` text NULL, `license_key` text NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;CREATE TABLE IF NOT EXISTS `bit_users_deposits` ( `id` int(11) NOT NULL AUTO_INCREMENT, `uid` int(11) NULL, `amount` varchar(255) NULL, `currency` varchar(255) NULL, `gateway_id` varchar(255) NULL, `payment_hash` varchar(255) NULL, `txid` varchar(255) NULL, `status` int(11) NULL, `time` int(11) NULL, `reason` int(11) NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;CREATE TABLE IF NOT EXISTS `bit_users_transactions` ( `id` int(11) NOT NULL AUTO_INCREMENT, `sender` int(11) NULL, `recipient` int(11) NULL, `amount` varchar(255) NULL, `currency` varchar(255) NULL, `description` varchar(255) NULL, `status` int(11) NULL, `time` int(11) NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;CREATE TABLE IF NOT EXISTS `bit_users` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(255) NULL, `password` varchar(255) NULL, `password_recovery` text NULL, `email_verified` int(11) NULL, `email_hash` text NULL, `email` varchar(255) NULL, `status` int(11) NULL, `ip` varchar(255) NULL, `last_login` int(11) NULL, `signup_time` int(11) NULL, `document_verified` int(11) NULL, `document_1` text NULL, `document_2` text NULL, `mobile_verified` int(11) NULL, `mobile_number` text NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;CREATE TABLE IF NOT EXISTS `bit_users_earnings` ( `id` int(11) NOT NULL AUTO_INCREMENT, `uid` int(11) NULL, `amount` varchar(255) NULL, `currency` varchar(255) NULL, `created` int(11) NULL, `updated` int(11) NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;CREATE TABLE IF NOT EXISTS `bit_users_withdrawals` ( `id` int(11) NOT NULL AUTO_INCREMENT, `uid` int(11) NULL, `eid` int(11) NULL, `amount` varchar(255) NULL, `currency` varchar(255) NULL, `company` varchar(255) NULL, `requested_on` int(11) NULL, `processed_on` int(11) NULL, `status` int(11) NULL, `u_field_1` varchar(255) NULL, `u_field_2` varchar(255) NULL, `u_field_3` varchar(255) NULL, `u_field_4` varchar(255) NULL, `u_field_5` varchar(255) NULL, `u_field_6` varchar(255) NULL, `u_field_7` varchar(255) NULL, `u_field_8` varchar(255) NULL, `u_field_9` varchar(255) NULL, `u_field_10` varchar(255) NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;CREATE TABLE IF NOT EXISTS `bit_sms_codes` ( `id` int(11) NOT NULL AUTO_INCREMENT, `uid` int(11) NULL, `sms_code` varchar(255) NULL, `verified` int(11) NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;CREATE TABLE IF NOT EXISTS `bit_gateways` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) NULL, `currency` varchar(255) NULL, `reserve` varchar(255) NULL, `min_amount` varchar(255) NULL, `max_amount` varchar(255) NULL, `exchange_type` int(11) NULL, `include_fee` int(11) NULL, `extra_fee` varchar(255) NULL, `fee` varchar(255) NULL, `allow_send` int(11) NULL, `allow_receive` int(11) NULL, `default_send` int(11) NULL, `default_receive` int(11) NULL, `allow_payouts` int(11) NULL, `a_field_1` varchar(255) NULL, `a_field_2` varchar(255) NULL, `a_field_3` varchar(255) NULL,  `a_field_4` varchar(255) NULL, `a_field_5` varchar(255) NULL, `a_field_6` varchar(255) NULL, `a_field_7` varchar(255) NULL, `a_field_8` varchar(255) NULL, `a_field_9` varchar(255) NULL, `a_field_10` varchar(255) NULL, `status` int(11) NULL, `external_gateway` int(11) NOT NULL DEFAULT '0', `external_icon` text NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;CREATE TABLE IF NOT EXISTS `bit_gateways_fields` ( `id` int(11) NOT NULL AUTO_INCREMENT, `gateway_id` int(11) NULL, `field_name` varchar(255) NULL, `field_number` int(11) NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;CREATE TABLE IF NOT EXISTS `bit_rates` ( `id` int(11) NOT NULL AUTO_INCREMENT, `gateway_from` int(11) NULL, `gateway_to` int(11) NULL, `rate_from` varchar(255) NULL, `rate_to` varchar(255) NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;CREATE TABLE IF NOT EXISTS `bit_rates` ( `id` int(11) NOT NULL AUTO_INCREMENT, `gateway_from` int(11) NULL, `gateway_to` int(11) NULL, `rate_from` varchar(255) NULL, `rate_to` varchar(255) NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;CREATE TABLE IF NOT EXISTS `bit_exchanges` ( `id` int(11) NOT NULL AUTO_INCREMENT, `uid` int(11) NULL, `wid` int(11) NULL, `gateway_send` int(11) NULL, `gateway_receive` int(11) NULL, `amount_send` varchar(255) NULL, `amount_receive` varchar(255) NULL, `rate_from` varchar(255) NULL, `rate_to` varchar(255) NULL, `status` int(11) NOT NULL DEFAULT '0', `created` int(11) NOT NULL DEFAULT '0', `updated` int(11) NOT NULL DEFAULT '0', `expired` int(11) NOT NULL DEFAULT '0', `u_field_1` varchar(255) NULL, `u_field_2` varchar(255) NULL, `u_field_3` varchar(255) NULL, `u_field_4` varchar(255) NULL, `u_field_5` varchar(255) NULL, `u_field_6` varchar(255) NULL, `u_field_7` varchar(255) NULL, `u_field_8` varchar(255) NULL, `u_field_9` varchar(255) NULL, `u_field_10` varchar(255) NULL, `ip` varchar(255) NULL, `transaction_id` text NULL, `exchange_id` varchar(255) NULL, `referral_id` varchar(255) NOT NULL DEFAULT '0', `referral_amount` varchar(255) NULL, `referral_currency` varchar(255) NULL, `referral_status` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;CREATE TABLE IF NOT EXISTS `bit_transactions` ( `id` int(11) NOT NULL AUTO_INCREMENT, `uid` int(11) NULL, `transaction_id` text NULL, `status` int(11) NULL, `gateway` varchar(255) NULL, `amount` varchar(255) NULL, `currency` varchar(255) NULL, `time` int(11) NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;CREATE TABLE IF NOT EXISTS `bit_testimonials` ( `id` int(11) NOT NULL AUTO_INCREMENT, `uid` int(11) NULL, `type` int(11) NULL, `exchange_id` int(11) NULL, `status` int(11) NULL, `time` int(11) NULL, `content` text NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;CREATE TABLE IF NOT EXISTS `bit_pages` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(255) NULL, `prefix` varchar(255) NULL, `content` text NULL, `created` int(11) NULL, `updated` int(11) NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;INSERT INTO `bit_pages` (`id`, `title`, `prefix`, `content`) VALUES(1, 'Terms of service', 'terms-of-services', 'Edit from WebAdmin.'),(2, 'Privacy Policy', 'privacy-policy', 'Edit from WebAdmin.'),(3, 'About', 'about', 'Edit from WebAdmin.');CREATE TABLE IF NOT EXISTS `bit_faq` ( `id` int(11) NOT NULL AUTO_INCREMENT, `question` varchar(255) NULL, `answer` text NULL, `created` int(11) NULL, `updated` int(11) NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;
