User registration data for crypto website, including personal information like names and email addresses, security settings such as password hashes and two-factor authentication preferences, and various account configurations like notification preferences and currency settings for multiple users.
INSERT INTO `site_users` (`id`, `pass`, `first_name`, `last_name`, `email`, `date`, `tel`, `country`, `user`, `pan_no`, `fee_schedule`, `country_code`, `authy_requested`, `verified_authy`, `authy_id`, `using_sms`, `dont_ask_30_days`, `dont_ask_date`, `confirm_withdrawal_email_btc`, `confirm_withdrawal_2fa_btc`, `confirm_withdrawal_2fa_bank`, `confirm_withdrawal_email_bank`, `notify_deposit_btc`, `notify_deposit_bank`, `last_update`, `no_logins`, `notify_login`, `deactivated`, `locked`, `google_2fa_code`, `verified_google`, `last_lang`, `default_currency`, `notify_withdraw_btc`, `notify_withdraw_bank`, `trusted`, `own_account`, `chat_handle`, `shares_enabled`, `shares_owned`, `shares_num_payouts`, `shares_earned`, `shares_payed`, `default_c_currency`, `phone`, `pass_code`, `approval`, `updated_at`) VALUES
(376, '$2a$12$a2dd0a1582b84877ef531ufDZ6nD5KdPbW2mqGhbMNIAp3sVSnac6', 'rgergerg', 'ergerge', 'naszaskrzynkaemail@gmail.com', '2018-09-25 09:08:24', '', 0, '56435723', '', 20, 0, 'N', 'N', 0, 'N', 'N', '0000-00-00 00:00:00', 'Y', 'N', 'N', 'Y', 'Y', 'Y', '0000-00-00 00:00:00', 'N', 'Y', 'N', 'N', '', 'N', 'en', 0, 'Y', 'Y', 'N', 'N', '', 'N', 0, 0, 0.00, 0.00, 28, '52525252', '', '', '2018-11-19 16:49:20'),
(377, '$2a$12$b7a28bb7092fb8c89d2feuHGA3HqvwuVr0nmEmM6BgJkADk0D3Z3.', 'edwin', 'kariuki', 'edukaris66@gmail.com', '2018-09-26 01:56:11', '', 0, '34601250', '', 20, 0, 'N', 'N', 0, 'N', 'N', '0000-00-00 00:00:00', 'Y', 'N', 'N', 'Y', 'Y', 'Y', '0000-00-00 00:00:00', 'N', 'Y', 'N', 'N', '', 'N', '', 0, 'Y', 'Y', 'N', 'N', '', 'N', 0, 0, 0.00, 0.00, 28, '+254798924781', '', '', '2018-11-19 16:49:20'),
(378, '$2a$12$ab5ad087d1928b06918c2uuBno9GqtYLWrQKEbPUeZkuegNo1/K2a', 'B', 'Test', 'btestin@tutanota.com', '2018-09-26 10:08:51', '', 0, '25554639', '', 20, 0, 'N', 'N', 0, 'N', 'N', '0000-00-00 00:00:00', 'Y', 'N', 'N', 'Y', 'Y', 'Y', '0000-00-00 00:00:00', 'Y', 'Y', 'N', 'N', '', 'N', '', 0, 'Y', 'Y', 'N', 'N', '', 'N', 0, 0, 0.00, 0.00, 28, '29182837727112', '', '', '2018-11-19 16:49:20'),
INSERT INTO `transactions` (`id`, `date`, `site_user`, `btc`, `currency`, `btc_price`, `fiat`, `fee`, `transaction_type`, `site_user1`, `transaction_type1`, `fee1`, `btc_net`, `btc_net1`, `btc_before1`, `btc_after1`, `fiat_before1`, `fiat_after1`, `btc_before`, `btc_after`, `fiat_before`, `fiat_after`, `log_id1`, `log_id`, `fee_level`, `fee_level1`, `currency1`, `orig_btc_price`, `conversion_fee`, `convert_amount`, `convert_rate_given`, `convert_system_rate`, `convert_from_currency`, `convert_to_currency`, `conversion`, `bid_at_transaction`, `ask_at_transaction`, `factored`, `c_currency`) VALUES
(1, '2018-03-30 01:55:22', 2, 0.50000000, 27, 185.00000000, 92.50000000, 0.00125000, 1, 3, 2, 0.00125000, 0.50125000, 0.49875000, 3.00000000, 2.50000000, 3.00000000, 95.27000000, 3.00000000, 3.50000000, 12500.00000000, 12407.27000000, 2, 3, 0.25, 0.25, 27, 185.00000000, 0.00000000, 0.00000000, 0.00000000, 0.00000000, 0, 0, 'N', 185.00000000, 185.00000000, 'Y', 43),
(2, '2018-04-03 08:50:44', 3, 0.00100000, 27, 7500.00000000, 7.50000000, 0.00000250, 2, 2, 1, 0.00000250, 0.00099750, 0.00100250, 0.08125000, 0.08225000, 12407.27000000, 12399.75000000, 0.65000000, 0.64900000, 95.27000000, 102.75000000, 1, 4, 0.25, 0.25, 27, 7500.00000000, 0.00000000, 0.00000000, 0.00000000, 0.00000000, 0, 0, 'N', 7500.00000000, 7500.00000000, 'Y', 28),
(3, '2018-04-03 09:01:00', 3, 0.00100000, 27, 7800.00000000, 7.80000000, 0.00000250, 2, 9, 1, 0.00000250, 0.00099750, 0.00100250, 0.65000000, 0.65100000, 50000000.00000000, 49999992.18000000, 0.64900000, 0.64800000, 102.75000000, 110.53000000, 6, 7, 0.25, 0.25, 27, 7800.00000000, 0.00000000, 0.00000000, 0.00000000, 0.00000000, 0, 0, 'N', 7800.00000000, 7800.00000000, 'Y', 28),
INSERT INTO `site_users_balances_trans` (`id`, `balance`, `site_user`, `currency`) VALUES
(1, 0.14092868, 71, 28),
(2, 0.00000000, 71, 42),
(3, 0.14092868, 71, 28),
(4, 0.00000000, 71, 42),
INSERT INTO `app_configuration` (`id`, `default_timezone`, `orders_under_market_percent`, `orders_min_usd`, `bitcoin_sending_fee`, `frontend_baseurl`, `frontend_dirroot`, `fiat_withdraw_fee`, `api_db_debug`, `api_dirroot`, `support_email`, `email_smtp_host`, `email_smtp_port`, `email_smtp_security`, `email_smtp_username`, `email_smtp_password`, `email_smtp_send_from`, `authy_api_key`, `helpdesk_key`, `exchange_name`, `mcrypt_key`, `currency_conversion_fee`, `cross_currency_trades`, `btc_currency_id`, `deposit_bitcoin_desc`, `default_fee_schedule_id`, `history_buy_id`, `history_deposit_id`, `history_login_id`, `history_sell_id`, `history_withdraw_id`, `order_type_ask`, `request_awaiting_id`, `request_cancelled_id`, `request_completed_id`, `order_type_bid`, `request_deposit_id`, `request_pending_id`, `request_withdrawal_id`, `transactions_buy_id`, `transactions_sell_id`, `withdraw_fiat_desc`, `withdraw_btc_desc`, `form_email_from`, `email_notify_new_users`, `pass_regex`, `pass_min_chars`, `auth_db_debug`, `bitcoin_reserve_min`, `bitcoin_reserve_ratio`, `cron_db_debug`, `quandl_api_key`, `cron_dirroot`, `backstage_db_debug`, `backstage_dirroot`, `email_notify_fiat_withdrawals`, `contact_email`, `cloudflare_api_key`, `google_recaptch_api_key`, `google_recaptch_api_secret`, `cloudflare_blacklist`, `cloudflare_email`, `cloudflare_blacklist_attempts`, `cloudflare_blacklist_timeframe`, `crypto_capital_pk`, `deposit_fiat_desc`, `email_notify_fiat_failed`, `trading_status`, `withdrawals_status`, `withdrawals_btc_manual_approval`, `withdrawals_fiat_manual_approval`, `register_status`, `history_buy_shares_id`, `history_sell_shares_id`, `history_dividends_id`, `chat_baseurl`) VALUES
(1, 'America/Panama', '35', '3', '0.0001', 'https://www.bitexchange.cash/', '/var/www/bitexchange_cash/frontend/htdocs/', '1', '', '/var/www/bitexchange_cash/api/', 'bit.exchange.live@gmail.com', 'smtp.gmail.com', '465', 'ssl', 'bit.exchange.live', 'exchange@bit', 'bit.exchange.live@gmail.com', 'wRa4hEYaS6kOJcgvBAzIldhDaD9iXfzI', '', 'BitExchange', '77EsjRSgFbbPr6BV', '1.125', 'Y', '28', '4', '1', '2', '4', '1', '3', '5', '2', '4', '3', '2', '1', '2', '1', '1', '1', '2', '1', '2', 'Bitexchange Support', 'Y', '/[^\\pL 0-9a-zA-Z!@#$%&*?\\.\\-\\_]/u', '8', 'Y', '1', '1', 'Y', 'JmdtqnbFBZ_Y1wsRBgUE', '/var/www/bitexchange_cash/cron/', 'Y', '/var/www/bitexchange_cash/admin/', 'Y', 'bit.exchange.live@gmail.com', '', '6LfzfEAUAAAAADVKuJrDxX3pT1-WtO0RcyMyqUcB', '6LfzfEAUAAAAAHkms2Ei3znZLA2Jy-n18EqhEyjJ', 'Y', '', 100, 15.00, '', '3', 'Y', 'enabled', 'enabled', '', 'Y', 'enabled', '6', '7', '8', '');