-- http://www.phpmyadmin.net
--




--
-- Database: `previewt_mining`
--

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

--
-- Table structure for table `admins`
--

CREATE TABLE IF NOT EXISTS `admins` (
  `id` int(10) unsigned NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `username` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `admins`
--

INSERT INTO `admins` (`id`, `name`, `username`, `image`, `email`, `password`, `remember_token`, `created_at`, `updated_at`) VALUES
(1, 'thesoftking', 'admin', '1498665028.png', 'admin@admin.com', '$2y$10$QDM9CsR53UODmQYWpCGK7eR528uMeFIDSGVBFjEZx/rGlc06R95qq', '6joW0ciD6IiI4YY1F68qsGoD4wC7XUVyF3PRFmCKvAl5nJbnHQABNEQmXiTM', NULL, '2017-08-17 12:58:09');

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

--
-- Table structure for table `apis`
--

CREATE TABLE IF NOT EXISTS `apis` (
  `id` int(10) unsigned NOT NULL,
  `provider` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `client_id` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `client_secret` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `apis`
--

INSERT INTO `apis` (`id`, `provider`, `client_id`, `client_secret`, `created_at`, `updated_at`) VALUES
(1, 'facebook', '318336281993417', '109be4ebf192c5e8e4d9c0c0ed493d54', '2018-01-14 22:00:00', '2018-01-25 01:49:18'),
(2, 'google', '954646933627-j2t7olcrfgcbtr4d3r8hsthm5bcetfd0.apps.googleusercontent.com', 'iI2g2oRBFrxyi6I_XalyByaW', '2018-01-14 18:00:15', '2018-01-25 01:49:18');

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

--
-- Table structure for table `basic_settings`
--

CREATE TABLE IF NOT EXISTS `basic_settings` (
  `id` int(10) unsigned NOT NULL,
  `title` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `color` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `google_map` blob NOT NULL,
  `start_date` datetime NOT NULL,
  `currency` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `symbol` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `deci` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_reg` int(2) NOT NULL DEFAULT '1',
  `email_verify` tinyint(1) NOT NULL,
  `phone_verify` tinyint(1) NOT NULL,
  `withdraw_status` tinyint(1) NOT NULL,
  `repeat_status` tinyint(1) NOT NULL,
  `email_notify` tinyint(1) NOT NULL,
  `phone_notify` tinyint(1) NOT NULL,
  `google_recap` tinyint(1) NOT NULL,
  `google_site_key` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `google_secret_key` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `reference` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `reference_bonus` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `reference_percent` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `withdraw_charge` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'charge per coin withdraw. in percent',
  `from_email` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_body` longblob NOT NULL,
  `smsapi` blob NOT NULL,
  `breadcrumb` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `about` blob NOT NULL,
  `tou` longblob,
  `pp` longblob,
  `footer_text` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `footer_image` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `copy_text` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `fb_login` tinyint(4) NOT NULL DEFAULT '1',
  `g_login` tinyint(4) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `basic_settings`
--

INSERT INTO `basic_settings` (`id`, `title`, `color`, `phone`, `email`, `address`, `google_map`, `start_date`, `currency`, `symbol`, `deci`, `user_reg`, `email_verify`, `phone_verify`, `withdraw_status`, `repeat_status`, `email_notify`, `phone_notify`, `google_recap`, `google_site_key`, `google_secret_key`, `reference`, `reference_bonus`, `reference_percent`, `withdraw_charge`, `from_email`, `email_body`, `smsapi`, `breadcrumb`, `about`, `tou`, `pp`, `footer_text`, `footer_image`, `copy_text`, `fb_login`, `g_login`, `created_at`, `updated_at`) VALUES
(1, 'Cloud Mining', '2ecc71', '+880123456789', 'software@thesoftking.com', 'Shyamoli, Dhaka 1207, Bangladesh', 0x3c696672616d65207372633d2268747470733a2f2f7777772e676f6f676c652e636f6d2f6d6170732f656d6265643f70623d21316d313821316d313221316d3321316432393138362e39323031333336383032333621326439302e333630373335343135383334383121336432332e38373636373138343739333032353821326d3321316630213266302133663021336d322131693130323421326937363821346631332e3121336d3321316d322131733078333735356335643035653730373464642533413078643163353838303330343966303063372132735574746172612532432b4468616b612135653021336d32213173656e21327362642134763135303531343438393233373822202020616c6c6f7766756c6c73637265656e3e3c2f696672616d653e, '2017-07-30 05:00:22', 'USD', '$', '8', 1, 0, 0, 1, 0, 1, 0, 0, '6LfJ0DEUAAAAANcRYNIasJigJ-tPzNlCH7JOymB-', '6LfJ0DEUAAAAAIGCgkQKHILOyfg6LGcbO4YLM15a', 'admin', '10', '5', '3.5', 'demo@thesoftking.com', 0x[encoded data, 5312 characters], 0x68747470733a2f2f6170692e696e666f6269702e636f6d2f6170692f76332f73656e64736d732f706c61696e3f757365723d2a2a2a2a2670617373776f72643d2a2a2a2a2a2673656e6465723d452d57616c6c657426534d53546578743d7b7b6d6573736167657d7d2647534d3d7b7b6e756d6265727d7d26747970653d6c6f6e67534d53, 'bg.png', 0x[encoded data, 9920 characters], 0x4c4f52454d20495053554d20444f4c4f522053495420414d45542c20434f4e5345435445545552204144495049534943494e4720454c49542c2053454420444f20454955534d4f442054454d504f52494e4349444944554e5420324a4c41424f524520455420444f4c4f5245204d41474e4120414c495155412e20555420415554204f444954204155542046554749542c20534544205155494120434f4e53455155554e545552204d41474e4920444f4c4f52455320454f532051554920524154494f4e4520564f4c5550544154454d205345515549204e45534349554e542e204e4551554520504f52524f20515549535155414d204553542c2051554920444f4c4f524154454d2e3c62723e3c6469763e3c62723e3c2f6469763e3c6469763e4c4f52454d20495053554d20444f4c4f522053495420414d45542c20434f4e5345435445545552204144495049534943494e4720454c49542c2053454420444f20454955534d4f442054454d504f52494e4349444944554e5420324a4c41424f524520455420444f4c4f5245204d41474e4120414c495155412e20555420415554204f444954204155542046554749542c20534544205155494120434f4e53455155554e545552204d41474e4920444f4c4f52455320454f532051554920524154494f4e4520564f4c5550544154454d205345515549204e45534349554e542e204e4551554520504f52524f20515549535155414d204553542c2051554920444f4c4f524154454d2e3c62723e3c2f6469763e3c6469763e3c62723e3c2f6469763e3c6469763e4c4f52454d20495053554d20444f4c4f522053495420414d45542c20434f4e5345435445545552204144495049534943494e4720454c49542c2053454420444f20454955534d4f442054454d504f52494e4349444944554e5420324a4c41424f524520455420444f4c4f5245204d41474e4120414c495155412e20555420415554204f444954204155542046554749542c20534544205155494120434f4e53455155554e545552204d41474e4920444f4c4f52455320454f532051554920524154494f4e4520564f4c5550544154454d205345515549204e45534349554e542e204e4551554520504f52524f20515549535155414d204553542c2051554920444f4c4f524154454d2e3c62723e3c2f6469763e3c6469763e3c62723e3c2f6469763e3c6469763e4c4f52454d20495053554d20444f4c4f522053495420414d45542c20434f4e5345435445545552204144495049534943494e4720454c49542c2053454420444f20454955534d4f442054454d504f52494e4349444944554e5420324a4c41424f524520455420444f4c4f5245204d41474e4120414c495155412e20555420415554204f444954204155542046554749542c20534544205155494120434f4e53455155554e545552204d41474e4920444f4c4f52455320454f532051554920524154494f4e4520564f4c5550544154454d205345515549204e45534349554e542e204e4551554520504f52524f20515549535155414d204553542c2051554920444f4c4f524154454d2e3c62723e3c6469763e3c62723e3c2f6469763e3c6469763e4c4f52454d20495053554d20444f4c4f522053495420414d45542c20434f4e5345435445545552204144495049534943494e4720454c49542c2053454420444f20454955534d4f442054454d504f52494e4349444944554e5420324a4c41424f524520455420444f4c4f5245204d41474e4120414c495155412e20555420415554204f444954204155542046554749542c20534544205155494120434f4e53455155554e545552204d41474e4920444f4c4f52455320454f532051554920524154494f4e4520564f4c5550544154454d205345515549204e45534349554e542e204e4551554520504f52524f20515549535155414d204553542c2051554920444f4c4f524154454d2e3c62723e3c2f6469763e3c6469763e3c62723e3c2f6469763e3c6469763e4c4f52454d20495053554d20444f4c4f522053495420414d45542c20434f4e5345435445545552204144495049534943494e4720454c49542c2053454420444f20454955534d4f442054454d504f52494e4349444944554e5420324a4c41424f524520455420444f4c4f5245204d41474e4120414c495155412e20555420415554204f444954204155542046554749542c20534544205155494120434f4e53455155554e545552204d41474e4920444f4c4f52455320454f532051554920524154494f4e4520564f4c5550544154454d205345515549204e45534349554e542e204e4551554520504f52524f20515549535155414d204553542c2051554920444f4c4f524154454d2e3c2f6469763e3c2f6469763e3c6469763e3c62723e3c2f6469763e3c6469763e3c62723e3c2f6469763e, 0x4c4f52454d20495053554d20444f4c4f522053495420414d45542c20434f4e5345435445545552204144495049534943494e4720454c49542c2053454420444f20454955534d4f442054454d504f52494e4349444944554e5420324a4c41424f524520455420444f4c4f5245204d41474e4120414c495155412e20555420415554204f444954204155542046554749542c20534544205155494120434f4e53455155554e545552204d41474e4920444f4c4f52455320454f532051554920524154494f4e4520564f4c5550544154454d205345515549204e45534349554e542e204e4551554520504f52524f20515549535155414d204553542c2051554920444f4c4f524154454d2e3c62723e3c6469763e3c62723e3c2f6469763e3c6469763e4c4f52454d20495053554d20444f4c4f522053495420414d45542c20434f4e5345435445545552204144495049534943494e4720454c49542c2053454420444f20454955534d4f442054454d504f52494e4349444944554e5420324a4c41424f524520455420444f4c4f5245204d41474e4120414c495155412e20555420415554204f444954204155542046554749542c20534544205155494120434f4e53455155554e545552204d41474e4920444f4c4f52455320454f532051554920524154494f4e4520564f4c5550544154454d205345515549204e45534349554e542e204e4551554520504f52524f20515549535155414d204553542c2051554920444f4c4f524154454d2e3c62723e3c2f6469763e3c6469763e3c62723e3c2f6469763e3c6469763e4c4f52454d20495053554d20444f4c4f522053495420414d45542c20434f4e5345435445545552204144495049534943494e4720454c49542c2053454420444f20454955534d4f442054454d504f52494e4349444944554e5420324a4c41424f524520455420444f4c4f5245204d41474e4120414c495155412e20555420415554204f444954204155542046554749542c20534544205155494120434f4e53455155554e545552204d41474e4920444f4c4f52455320454f532051554920524154494f4e4520564f4c5550544154454d205345515549204e45534349554e542e204e4551554520504f52524f20515549535155414d204553542c2051554920444f4c4f524154454d2e3c62723e3c2f6469763e3c6469763e3c62723e3c2f6469763e3c6469763e4c4f52454d20495053554d20444f4c4f522053495420414d45542c20434f4e5345435445545552204144495049534943494e4720454c49542c2053454420444f20454955534d4f442054454d504f52494e4349444944554e5420324a4c41424f524520455420444f4c4f5245204d41474e4120414c495155412e20555420415554204f444954204155542046554749542c20534544205155494120434f4e53455155554e545552204d41474e4920444f4c4f52455320454f532051554920524154494f4e4520564f4c5550544154454d205345515549204e45534349554e542e204e4551554520504f52524f20515549535155414d204553542c2051554920444f4c4f524154454d2e3c62723e3c6469763e3c62723e3c2f6469763e3c6469763e4c4f52454d20495053554d20444f4c4f522053495420414d45542c20434f4e5345435445545552204144495049534943494e4720454c49542c2053454420444f20454955534d4f442054454d504f52494e4349444944554e5420324a4c41424f524520455420444f4c4f5245204d41474e4120414c495155412e20555420415554204f444954204155542046554749542c20534544205155494120434f4e53455155554e545552204d41474e4920444f4c4f52455320454f532051554920524154494f4e4520564f4c5550544154454d205345515549204e45534349554e542e204e4551554520504f52524f20515549535155414d204553542c2051554920444f4c4f524154454d2e3c62723e3c2f6469763e3c6469763e3c62723e3c2f6469763e3c6469763e4c4f52454d20495053554d20444f4c4f522053495420414d45542c20434f4e5345435445545552204144495049534943494e4720454c49542c2053454420444f20454955534d4f442054454d504f52494e4349444944554e5420324a4c41424f524520455420444f4c4f5245204d41474e4120414c495155412e20555420415554204f444954204155542046554749542c20534544205155494120434f4e53455155554e545552204d41474e4920444f4c4f52455320454f532051554920524154494f4e4520564f4c5550544154454d205345515549204e45534349554e542e204e4551554520504f52524f20515549535155414d204553542c2051554920444f4c4f524154454d2e3c2f6469763e3c2f6469763e3c6469763e3c62723e3c2f6469763e, 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry''s standard dummy.', '1503148676.jpg', 'QyBPIEQgRSBMIEkgUyBUIC4gQyBD', 1, 1, NULL, '2018-01-24 20:32:15');

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

--
-- Table structure for table `categories`
--

CREATE TABLE IF NOT EXISTS `categories` (
  `id` int(10) unsigned NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` (`id`, `name`, `code`, `created_at`, `updated_at`) VALUES
(2, 'BitCoin', 'BTC', '2017-12-12 06:44:13', '2017-12-26 11:13:27'),
(3, 'Etherium', 'ETH', '2017-12-12 09:46:38', '2017-12-20 08:01:05'),
(4, 'Eddy', 'Eddy', '2017-12-17 12:03:00', '2017-12-28 07:46:02'),
(5, 'Black Coin', 'BLK', '2017-12-17 12:03:09', '2017-12-17 12:03:09'),
(6, 'Ripple', 'XRP', '2017-12-17 12:03:21', '2017-12-17 12:03:21');

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

--
-- Table structure for table `deposits`
--

CREATE TABLE IF NOT EXISTS `deposits` (
  `id` int(10) unsigned NOT NULL,
  `user_id` int(11) NOT NULL,
  `transaction_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `amount` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `rate` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `charge` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `net_amount` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `payment_type` tinyint(4) NOT NULL,
  `message` blob,
  `status` tinyint(1) DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `deposit_images`
--

CREATE TABLE IF NOT EXISTS `deposit_images` (
  `id` int(10) unsigned NOT NULL,
  `deposit_id` int(11) NOT NULL,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `faqs`
--

CREATE TABLE IF NOT EXISTS `faqs` (
  `id` int(10) unsigned NOT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` blob NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `faqs`
--

INSERT INTO `faqs` (`id`, `title`, `description`, `created_at`, `updated_at`) VALUES
(1, 'Anim pariatur cliche reprehenderit', 0x416e696d20706172696174757220636c6963686520726570726568656e64657269742c20656e696d20656975736d6f642068696768206c696665206163637573616d75732074657272792072696368617264736f6e2061642073717569642e203320776f6c66206d6f6f6e206f66666963696120617574652c206e6f6e2063757069646174617420736b617465626f61726420646f6c6f72206272756e63682e20466f6f6420747275636b207175696e6f61206e65736369756e74206c61626f72756d20656975736d6f642e204272756e6368203320776f6c66206d6f6f6e2074656d706f722c2073756e7420616c697175612070757420612062697264206f6e2069742073717569642073696e676c652d6f726967696e20636f66666565206e756c6c6120617373756d656e64612073686f726564697463682065742e204e6968696c20616e696d206b656666697965682068656c7665746963612c2063726166742062656572206c61626f72652077657320616e646572736f6e2063726564206e65736369756e742073617069656e74652065612070726f6964656e742e20416420766567616e2065786365707465757220627574636865722076696365206c6f6d6f2e204c656767696e6773206f636361656361742063726166742062656572206661726d2d746f2d7461626c652c207261772064656e696d206165737468657469632073796e7468206e65736369756e7420796f752070726f6261626c7920686176656e2774206865617264206f66207468656d206163637573616d7573206c61626f7265207375737461696e61626c65205648532e, '2017-09-22 11:53:37', '2017-09-22 11:53:37'),
(3, 'Lorem Ipsum is simply dummy text of the printing', 0x57686174206973204c6f72656d20497073756d3f0d0a4c6f72656d20497073756d2069732073696d706c792064756d6d792074657874206f6620746865207072696e74696e6720616e64207479706573657474696e6720696e6475737472792e204c6f72656d20497073756d20686173206265656e2074686520696e6475737472792773207374616e646172642064756d6d79207465787420657665722073696e6365207468652031353030732c207768656e20616e20756e6b6e6f776e207072696e74657220746f6f6b20612067616c6c6579206f66207479706520616e6420736372616d626c656420697420746f206d616b65206120747970652073706563696d656e20626f6f6b2e20497420686173207375727669766564206e6f74206f6e6c7920666976652063656e7475726965732c2062757420616c736f20746865206c65617020696e746f20656c656374726f6e6963207479706573657474696e672c2072656d61696e696e6720657373656e7469616c6c7920756e6368616e6765642e2049742077617320706f70756c61726973656420696e207468652031393630732077697468207468652072656c65617365206f66204c657472617365742073686565747320636f6e7461696e696e67204c6f72656d20497073756d2070617373616765732c20616e64206d6f726520726563656e746c792077697468206465736b746f70207075626c697368696e6720736f667477617265206c696b6520416c64757320506167654d616b657220696e636c7564696e672076657273696f6e73206f66204c6f72656d20497073756d2e, '2017-09-23 02:38:51', '2017-09-23 02:38:51'),
(4, 'Anim pariatur cliche reprehenderit', 0x3c6832207374796c653d226d617267696e2d746f703a203070783b206d617267696e2d72696768743a203070783b206d617267696e2d6c6566743a203070783b2070616464696e673a203070783b206c696e652d6865696768743a20323470783b20666f6e742d66616d696c793a204461757068696e506c61696e3b20666f6e742d73697a653a20323470783b20636f6c6f723a2072676228302c20302c2030293b223e57686174206973204c6f72656d20497073756d3f3c2f68323e3c70207374796c653d226d617267696e2d626f74746f6d3a20313570783b2070616464696e673a203070783b20746578742d616c69676e3a206a7573746966793b20636f6c6f723a2072676228302c20302c2030293b20666f6e742d66616d696c793a202671756f743b4f70656e2053616e732671756f743b2c20417269616c2c2073616e732d73657269663b223e3c7374726f6e67207374796c653d226d617267696e3a203070783b2070616464696e673a203070783b223e4c6f72656d20497073756d3c2f7374726f6e673e266e6273703b69732073696d706c792064756d6d792074657874206f6620746865207072696e74696e6720616e64207479706573657474696e6720696e6475737472792e204c6f72656d20497073756d20686173206265656e2074686520696e6475737472792773207374616e646172642064756d6d79207465787420657665722073696e6365207468652031353030732c207768656e20616e20756e6b6e6f776e207072696e74657220746f6f6b20612067616c6c6579206f66207479706520616e6420736372616d626c656420697420746f206d616b65206120747970652073706563696d656e20626f6f6b2e20497420686173207375727669766564206e6f74206f6e6c7920666976652063656e7475726965732c2062757420616c736f20746865206c65617020696e746f20656c656374726f6e6963207479706573657474696e672c2072656d61696e696e6720657373656e7469616c6c7920756e6368616e6765642e2049742077617320706f70756c61726973656420696e207468652031393630732077697468207468652072656c65617365206f66204c657472617365742073686565747320636f6e7461696e696e67204c6f72656d20497073756d2070617373616765732c20616e64206d6f726520726563656e746c792077697468206465736b746f70207075626c697368696e6720736f667477617265206c696b6520416c64757320506167654d616b657220696e636c7564696e672076657273696f6e73206f66204c6f72656d20497073756d2e3c2f703e, '2017-09-23 02:38:57', '2017-09-23 02:38:57'),
(5, 'Anim pariatur cliche reprehenderit', 0x3c6832207374796c653d226d617267696e2d746f703a203070783b206d617267696e2d72696768743a203070783b206d617267696e2d6c6566743a203070783b2070616464696e673a203070783b206c696e652d6865696768743a20323470783b20666f6e742d66616d696c793a204461757068696e506c61696e3b20666f6e742d73697a653a20323470783b20636f6c6f723a2072676228302c20302c2030293b223e57686174206973204c6f72656d20497073756d3f3c2f68323e3c70207374796c653d226d617267696e2d626f74746f6d3a20313570783b2070616464696e673a203070783b20746578742d616c69676e3a206a7573746966793b20636f6c6f723a2072676228302c20302c2030293b20666f6e742d66616d696c793a202671756f743b4f70656e2053616e732671756f743b2c20417269616c2c2073616e732d73657269663b223e3c7374726f6e67207374796c653d226d617267696e3a203070783b2070616464696e673a203070783b223e4c6f72656d20497073756d3c2f7374726f6e673e266e6273703b69732073696d706c792064756d6d792074657874206f6620746865207072696e74696e6720616e64207479706573657474696e6720696e6475737472792e204c6f72656d20497073756d20686173206265656e2074686520696e6475737472792773207374616e646172642064756d6d79207465787420657665722073696e6365207468652031353030732c207768656e20616e20756e6b6e6f776e207072696e74657220746f6f6b20612067616c6c6579206f66207479706520616e6420736372616d626c656420697420746f206d616b65206120747970652073706563696d656e20626f6f6b2e20497420686173207375727669766564206e6f74206f6e6c7920666976652063656e7475726965732c2062757420616c736f20746865206c65617020696e746f20656c656374726f6e6963207479706573657474696e672c2072656d61696e696e6720657373656e7469616c6c7920756e6368616e6765642e2049742077617320706f70756c61726973656420696e207468652031393630732077697468207468652072656c65617365206f66204c657472617365742073686565747320636f6e7461696e696e67204c6f72656d20497073756d2070617373616765732c20616e64206d6f726520726563656e746c792077697468206465736b746f70207075626c697368696e6720736f667477617265206c696b6520416c64757320506167654d616b657220696e636c7564696e672076657273696f6e73206f66204c6f72656d20497073756d2e3c2f703e, '2017-09-23 02:39:03', '2017-09-23 02:39:03');

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

--
-- Table structure for table `features`
--

CREATE TABLE IF NOT EXISTS `features` (
  `id` int(10) unsigned NOT NULL,
  `photo` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'photo.png',
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Client Company',
  `description` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `features`
--

INSERT INTO `features` (`id`, `photo`, `title`, `description`, `created_at`, `updated_at`) VALUES
(1, '5a4269280f2a4.png', 'CRYPTO MINING', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit.', '2017-11-29 15:25:39', '2017-12-27 03:24:44'),
(2, '5a426931dcbdc.png', 'EASY MINING', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit.', '2017-11-29 15:51:50', '2017-12-27 03:24:57'),
(7, '5a42693d53255.png', 'PRIVATE', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit.', '2017-12-04 11:50:08', '2017-12-27 03:25:11'),
(8, '5a42694667e53.png', 'SECURE', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit.', '2017-12-04 11:58:02', '2017-12-27 03:25:20');

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

--
-- Table structure for table `investments`
--

CREATE TABLE IF NOT EXISTS `investments` (
  `id` int(10) unsigned NOT NULL,
  `trx_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` int(11) NOT NULL,
  `plan_id` int(11) NOT NULL,
  `amount` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `investments`
--

INSERT INTO `investments` (`id`, `trx_id`, `user_id`, `plan_id`, `amount`, `status`, `created_at`, `updated_at`) VALUES
(1, 'TLWRPGZ5XPHQEG9VBEZL', 4, 1, '1200', 1, '2017-10-22 00:31:07', '2017-12-11 15:12:43'),
(2, '5STYCDDMMPDYRQONVRQU', 4, 1, '500', 1, '2017-10-22 00:33:01', '2017-10-22 05:17:07'),
(3, 'KVPXSHNKYCQUKP6PWISU', 4, 1, '500', 1, '2017-10-22 00:35:13', '2017-12-11 15:12:43'),
(4, '9ST9G3WPHXL8HQDIZR9T', 4, 1, '500', 1, '2017-10-04 00:48:15', '2017-12-11 15:12:43'),
(5, '74WYLM4H1DTL0YF3ETCR', 4, 1, '500', 1, '2017-10-22 00:54:14', '2017-12-11 15:12:44'),
(6, 'SABUXJ1WH8XMDCDGQ14U', 4, 1, '1000', 1, '2017-10-22 02:49:17', '2017-12-11 15:12:44'),
(7, 'JPMU5JLUNJ6XKF6RA4KY', 4, 1, '1025', 1, '2017-10-22 03:14:07', '2017-12-11 15:12:44'),
(8, 'ENBXLBB78Z7IYZRDJ9DM', 5, 1, '1000', 1, '2017-10-22 05:05:39', '2017-12-11 15:12:44'),
(9, '9UOX5XDDTRKSM8ZR0MZC', 4, 5, '500', 0, '2017-10-22 05:18:40', '2017-10-22 05:18:40'),
(10, '0QS5Q8H4BY7CZNHFEAHL', 4, 1, '1500', 1, '2017-10-22 23:15:58', '2017-12-11 15:12:45'),
(11, 'FZODUGLJ8SCN0HWVSV9Z', 4, 1, '500', 1, '2017-10-23 22:04:36', '2017-10-24 04:18:47'),
(12, 'MF3JFDSGKNGXF7ALQUCX', 4, 1, '1200', 1, '2017-10-26 05:34:20', '2017-12-11 15:12:45'),
(13, 'M2RYAGPRLGL5VYPINIST', 4, 1, '50000', 1, '2017-11-05 01:00:34', '2017-12-11 15:12:46'),
(14, 'FR3VKR3VPTESTE3QFAMQ', 4, 1, '10000', 1, '2017-11-05 01:01:24', '2017-12-11 15:12:47'),
(15, 'DV4T8CIRJC1A1LSOIWMT', 2, 1, '5', 0, '2017-12-06 06:38:36', '2017-12-06 06:38:36'),
(16, 'HWGCTN3OPF6CKQHMJGV6', 2, 1, '5', 0, '2017-12-07 05:24:23', '2017-12-07 05:24:23'),
(17, 'HKQZSECFHRASDFVGUZGH', 2, 1, '500', 0, '2017-12-07 06:37:17', '2017-12-07 06:37:17'),
(18, 'DKZO4YDP1YPTCSA3PODR', 2, 1, '500', 0, '2017-12-07 06:37:17', '2017-12-07 06:37:17'),
(19, 'WOCOGWV94LDF1NX5LUHF', 2, 1, '500', 0, '2017-12-07 06:37:42', '2017-12-07 06:37:42'),
(20, 'I8KOKBWN1MKH95V9F7SS', 2, 1, '500', 0, '2017-12-07 09:38:02', '2017-12-07 09:38:02'),
(21, 'CEPLUKFRK6TMOH0MQZX8', 2, 1, '10000', 0, '2017-12-10 13:39:19', '2017-12-10 13:39:19');

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

--
-- Table structure for table `menus`
--

CREATE TABLE IF NOT EXISTS `menus` (
  `id` int(10) unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` blob NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `menus`
--

INSERT INTO `menus` (`id`, `name`, `description`, `created_at`, `updated_at`) VALUES
(1, 'Menu1', 0x[encoded data, 4752 characters], '2017-01-11 02:28:02', '2017-04-23 05:26:01');

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

--
-- Table structure for table `migrations`
--

CREATE TABLE IF NOT EXISTS `migrations` (
  `id` int(10) unsigned NOT NULL,
  `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2017_12_12_121328_create_categories_table', 1),
(2, '2017_12_14_184924_create_plan_logs_table', 2),
(3, '2017_12_18_165901_create_partners_table', 3),
(4, '2017_12_19_113236_create_procedures_table', 4),
(5, '2017_12_20_102559_create_user_datas_table', 5),
(6, '2017_12_21_143103_create_trxes_table', 6),
(7, '2017_12_25_141522_create_returns_table', 7),
(8, '2018_01_15_182836_create_apis_table', 8);

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

--
-- Table structure for table `pages`
--

CREATE TABLE IF NOT EXISTS `pages` (
  `id` int(10) unsigned NOT NULL,
  `about_subtitle` text COLLATE utf8mb4_unicode_ci,
  `about_leftText` text COLLATE utf8mb4_unicode_ci,
  `about_rightText` blob,
  `service_subtitle` text COLLATE utf8mb4_unicode_ci,
  `plan_subtitle` text COLLATE utf8mb4_unicode_ci,
  `investor_subtitle` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pages`
--

INSERT INTO `pages` (`id`, `about_subtitle`, `about_leftText`, `about_rightText`, `service_subtitle`, `plan_subtitle`, `investor_subtitle`, `created_at`, `updated_at`) VALUES
(1, 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.', '<iframe width="560" height="315" src="https://www.youtube.com/embed/GmOzih6I1zs" frameborder="0" allow="autoplay; encrypted-media" allowfullscreen></iframe>', 0x4c6f72656d20697073756d20646f6c6f722073697420616d65742c20636f6e7365637465747572206164697069736963696e6720656c69742c2073656420646f20656975736d6f642074656d706f72696e6369646964756e7420326a6c61626f726520657420646f6c6f7265206d61676e6120616c697175612e20557420617574206f646974206175742066756769742c20736564207175696120636f6e73657175756e747572206d61676e6920646f6c6f72657320656f732071756920726174696f6e6520766f6c7570746174656d207365717569206e65736369756e742e204e6571756520706f72726f20717569737175616d206573742c2071756920646f6c6f726174656d2e204c6f72656d20697073756d20646f6c6f722073697420616d65742c20636f6e7365637465747572206164697069736963696e6720656c69742c2073656420646f20656975736d6f642074656d706f72696e6369646964756e7420326a6c61626f726520657420646f6c6f7265206d61676e6120616c697175612e20557420617574206f646974206175742066756769742c20736564207175696120636f6e73657175756e747572206d61676e6920646f6c6f72657320656f732071756920726174696f6e6520766f6c7570746174656d207365717569206e65736369756e742e204e6571756520706f72726f20717569737175616d206573742c2071756920646f6c6f726174656d2e, 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.', NULL, '2018-01-24 20:29:54');

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

--
-- Table structure for table `partners`
--

CREATE TABLE IF NOT EXISTS `partners` (
  `id` int(10) unsigned NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `logo` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `partners`
--

INSERT INTO `partners` (`id`, `name`, `logo`, `created_at`, `updated_at`) VALUES
(2, 'BlockChain', '1513658924.jpg', '2017-12-19 04:48:44', '2017-12-19 04:48:44'),
(3, 'CoinPayments', '1513658942.jpg', '2017-12-19 04:49:02', '2017-12-19 04:49:02'),
(4, 'CoinBase', '1513658958.jpg', '2017-12-19 04:49:18', '2017-12-19 04:49:18'),
(5, 'Google', '1513658988.jpg', '2017-12-19 04:49:48', '2017-12-19 04:49:48'),
(6, 'Facebook', '1513659003.jpg', '2017-12-19 04:50:03', '2017-12-19 04:50:03');

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

--
-- Table structure for table `password_resets`
--

CREATE TABLE IF NOT EXISTS `password_resets` (
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `password_resets`
--

INSERT INTO `password_resets` (`email`, `token`, `created_at`) VALUES
('thesoftking@gmail.comx', '$2y$10$ulwTblbNsrCNlKMlewxjO.HODYIqLDLWArPd3lrNxTtgRUzSkD8Na', NULL),
('thesoftking@gmail.com', '$2y$10$2UzvWGZPYFXKJBmfYfPsXOkmw9N7lMyvo1oek8Q1oqVCQRLUyLGk2', NULL),
('yhossainshanto@gmail.com', '$2y$10$XylV2ww2FkySNp2.oakjiuy87.ZyCfPx/.O.CDGGxfwELv/c4eTri', NULL),
('admin@gmail.com', '$2y$10$LEl8QznPU8yMJtXF6bKuoe6Yor7sp1GgWNY2heFv3XkmPB0YTEPoK', NULL),
('yousuf.hossain.shanto@gmail.com', '$2y$10$zLRqQ9j1Xbxe0ErWi8U9yeboysFgPYVjKV7hiZ/79yjQrT71.S1cO', NULL);

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

--
-- Table structure for table `payment_logs`
--

CREATE TABLE IF NOT EXISTS `payment_logs` (
  `id` int(10) unsigned NOT NULL,
  `member_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `custom` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `payment_type` int(11) NOT NULL,
  `amount` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `charge` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `net_amount` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `usd` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `btc_amo` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `btc_acc` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `payment_methods`
--

CREATE TABLE IF NOT EXISTS `payment_methods` (
  `id` int(10) unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `image` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `rate` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fix` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `percent` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `val1` text COLLATE utf8_unicode_ci NOT NULL,
  `val2` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `currency` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Method Currency',
  `status` tinyint(4) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `payment_methods`
--

INSERT INTO `payment_methods` (`id`, `name`, `image`, `rate`, `fix`, `percent`, `val1`, `val2`, `currency`, `status`, `created_at`, `updated_at`) VALUES
(1, 'PayPal', '59f809c931cb0.png', '1', '2', '1.5', 'admin@rexbd.com', NULL, 'Method Currency', 1, NULL, '2017-12-27 01:45:00'),
(2, 'Perfect Money', '1508826560h4.png', '80', '3', '2.75', 'U5220203', 'reg4e54h1grt1j', 'Method Currency', 1, NULL, '2017-12-25 13:20:05'),
(3, 'Bitcoin Blockchain', '1508826576h5.png', '1', '0', '0.5', '8df2e5a0-3798-4b74-871d-973615b57e7b', 'xpub6CXLqfWXj1xgbYB8Pmg12ET6CGKPKfAJSXaizSWRLzUz9xf9wFJuXR2M4XQ1ThdcgyFN4Ej8zj6BjDoXEf2AikNGiYkSCG8vkCx4ZeFrZah', 'Method Currency', 1, NULL, '2017-10-30 23:57:55'),
(4, 'Credit CARD', '1508740770h6.png', '1', '3', '2.20', 'sk_test_aat3tzBCCXXBkS4sxY3M8A1B', 'pk_test_AU3G7doZ1sbdpJLj0NaozPBu', 'Method Currency', 1, NULL, '2017-12-27 01:54:09'),
(5, 'Bitcoin CoinPayment', '150882822860h8.png', '1', '2', '1', 'db1d9f12444e65c921604e289a281c56', 'ABIR', 'Method Currency', 1, NULL, NULL),
(6, 'Skrill', 'skrill.png', '1', '2', '1.75', 'support@globeskill.com', 'jabali2006', 'Method Currency', 1, '2017-12-12 18:00:00', '2017-12-20 14:46:01');

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

--
-- Table structure for table `plans`
--

CREATE TABLE IF NOT EXISTS `plans` (
  `id` int(10) unsigned NOT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `features` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `price` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `period` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ptyp` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `speed` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `return` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `category_id` int(11) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `plans`
--

INSERT INTO `plans` (`id`, `title`, `description`, `features`, `price`, `period`, `ptyp`, `speed`, `return`, `category_id`, `status`, `created_at`, `updated_at`) VALUES
(1, 'SCRYPT CLOUD MINING', 'SCRYPT ALGORITHM MINER', 'a:4:{i:0;s:24:"Minimum Hashrate: 1 MH/s";i:1;s:39:"Maintenance fee: 0.005 $ / 1 MH/s / 24h";i:2;s:26:"Hardware: HashCoins SCRYPT";i:3;s:23:"Automatic payout in XMR";}', '70.50', '2', 'year', 'per 1 MH/s', '2000', 6, 1, '2017-12-06 00:40:53', '2018-01-24 20:37:37'),
(2, 'SCRYPT CLOUD MINING 2', 'SCRYPT ALGORITHM MINER', 'a:4:{i:0;s:24:"Minimum Hashrate: 1 MH/s";i:1;s:39:"Maintenance fee: 0.005 $ / 1 MH/s / 24h";i:2;s:26:"Hardware: HashCoins SCRYPT";i:3;s:23:"Automatic payout in BTC";}', '10', '10', 'month', '1 mg', '3000', 2, 1, '2017-12-14 08:10:00', '2018-01-24 20:38:20'),
(3, 'SCRYPT CLOUD MINING 3', 'SCRYPT ALGORITHM MINER', 'a:4:{i:0;s:24:"Minimum Hashrate: 1 MH/s";i:1;s:39:"Maintenance fee: 0.005 $ / 1 MH/s / 24h";i:2;s:26:"Hardware: HashCoins SCRYPT";i:3;s:23:"Automatic payout in ETH";}', '10', '55', 'day', '3 GB', '4000', 3, 1, '2017-12-14 08:10:36', '2018-01-24 20:37:39'),
(4, 'SCRYPT CLOUD MINING 4', 'SCRYPT ALGORITHM MINER', 'a:4:{i:0;s:24:"Minimum Hashrate: 1 MH/s";i:1;s:39:"Maintenance fee: 0.005 $ / 1 MH/s / 24h";i:2;s:26:"Hardware: HashCoins SCRYPT";i:3;s:23:"Automatic payout in BTC";}', '50', '5', 'month', '9 GB', '10', 5, 1, '2017-12-14 08:11:07', '2018-01-24 20:41:28');

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

--
-- Table structure for table `plan_logs`
--

CREATE TABLE IF NOT EXISTS `plan_logs` (
  `id` int(10) unsigned NOT NULL,
  `user_id` int(11) NOT NULL,
  `plan_id` int(11) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `plan_logs`
--

INSERT INTO `plan_logs` (`id`, `user_id`, `plan_id`, `status`, `created_at`, `updated_at`) VALUES
(1, 2, 2, 1, '2018-01-23 22:45:07', '2018-01-24 20:33:34'),
(2, 2, 3, 0, '2018-01-24 20:52:50', '2018-01-24 20:52:50'),
(3, 2, 4, 0, '2018-01-24 21:38:34', '2018-01-24 21:38:34'),
(4, 2, 4, 0, '2018-01-24 21:38:41', '2018-01-24 21:38:41'),
(5, 2, 4, 0, '2018-01-24 21:39:13', '2018-01-24 21:39:13'),
(6, 2, 4, 0, '2018-01-25 00:15:59', '2018-01-25 00:15:59');

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

--
-- Table structure for table `procedures`
--

CREATE TABLE IF NOT EXISTS `procedures` (
  `id` int(10) unsigned NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `procedures`
--

INSERT INTO `procedures` (`id`, `name`, `image`, `description`, `created_at`, `updated_at`) VALUES
(2, 'Hardware', '1513667378.jpg', 'Miner is a highly efficient piece of mining equipment specially designed for cryptocurrency mining. Our datacenters house hundreds of miners.', '2017-12-19 07:09:38', '2017-12-19 07:09:38'),
(3, 'Pools', '1513667446.jpg', 'Miners are connected to pools. There are many pools so HashFlare allows you to connect to ones you choose. This allows you to find the most profitable combinantion.', '2017-12-19 07:10:46', '2017-12-19 07:10:46'),
(4, 'Payout', '1513667480.jpg', 'Next, all mined cryptocurrency is distributed among all customers of HashFlare depending on their share of hashrate in the whole system.', '2017-12-19 07:11:20', '2017-12-19 07:11:20');

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

--
-- Table structure for table `repeats`
--

CREATE TABLE IF NOT EXISTS `repeats` (
  `id` int(10) unsigned NOT NULL,
  `user_id` int(11) NOT NULL,
  `investment_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `repeat_time` datetime NOT NULL,
  `made_time` datetime DEFAULT NULL,
  `total_repeat` int(11) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `repeat_logs`
--

CREATE TABLE IF NOT EXISTS `repeat_logs` (
  `id` int(10) unsigned NOT NULL,
  `user_id` int(11) NOT NULL,
  `trx_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `investment_id` int(11) NOT NULL,
  `amount` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `made_time` datetime NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `returns`
--

CREATE TABLE IF NOT EXISTS `returns` (
  `id` int(10) unsigned NOT NULL,
  `user_id` int(11) NOT NULL,
  `plan_log` int(11) NOT NULL,
  `last` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `services`
--

CREATE TABLE IF NOT EXISTS `services` (
  `id` int(10) unsigned NOT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `services`
--

INSERT INTO `services` (`id`, `title`, `code`, `created_at`, `updated_at`) VALUES
(1, 'upper Fast Repeat', '<i class="fa fa-rocket" aria-hidden="true"></i>', '2017-09-27 17:35:45', '2017-12-04 12:18:29'),
(2, 'EASY SETUP', '<i class="fa fa-wrench" aria-hidden="true"></i>', '2017-09-27 17:35:59', '2017-11-05 00:44:10'),
(3, 'INVESTMENT', '<i class="fa fa-money" aria-hidden="true"></i>', '2017-09-27 17:36:08', '2017-11-05 00:44:27'),
(4, 'WITHDRAW', '<i class="fa fa-money" aria-hidden="true"></i>', '2017-09-27 17:36:15', '2017-11-05 00:44:55'),
(5, 'FULLY DYNAMIC', '<i class="fa fa-th" aria-hidden="true"></i>', '2017-09-27 17:36:23', '2017-11-05 00:45:49'),
(6, 'ADMIN DASHBOARD', '<i class="fa fa-th" aria-hidden="true"></i>', '2017-09-27 17:36:30', '2017-11-05 00:46:52'),
(7, 'PLANS', '<i class="fa fa-th" aria-hidden="true"></i>', '2017-09-27 17:36:39', '2017-11-05 00:47:06'),
(8, 'EASY SETUP', '<i class="fa fa-wrench" aria-hidden="true"></i>', '2017-11-05 00:47:51', '2017-11-05 00:47:51');

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

--
-- Table structure for table `sliders`
--

CREATE TABLE IF NOT EXISTS `sliders` (
  `id` int(10) unsigned NOT NULL,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` blob NOT NULL,
  `subtitle` blob NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sliders`
--

INSERT INTO `sliders` (`id`, `image`, `title`, `subtitle`, `created_at`, `updated_at`) VALUES
(5, '5a4c03611bf5c.jpg', 0x3c683120636c6173733d2266726f6e74686561642220616c69676e3d2263656e746572223e3c62723e3c2f68313e3c683120636c6173733d2266726f6e74686561642220616c69676e3d2263656e746572223e3c62723e3c2f68313e3c683120636c6173733d2266726f6e74686561642220616c69676e3d2263656e746572223e3c666f6e7420636f6c6f723d2223363646463333223e3c666f6e7420636f6c6f723d2223464646464646223e3c623e4d494e494e4720495320454153494552205448414e20455645523c2f623e3c2f666f6e743e3c2f666f6e743e3c2f68313e, 0x3c64697620616c69676e3d2263656e746572223e3c68343e20202020202020202020202020202020202020202020202020202020202020202020202020203c666f6e7420636f6c6f723d2223464646464646223e4a757374205369676e757020616e64206f72646572206f7572206d696e65722c20616e6420676574206d696e696e6720616d6f756e74206461696c79206f6e20796f7572204163636f756e743c2f666f6e743e3c2f68343e3c2f6469763e, '2017-10-17 00:04:53', '2018-01-03 10:10:41');

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

--
-- Table structure for table `socials`
--

CREATE TABLE IF NOT EXISTS `socials` (
  `id` int(10) unsigned NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `link` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `socials`
--

INSERT INTO `socials` (`id`, `name`, `code`, `link`, `created_at`, `updated_at`) VALUES
(3, 'Facebook', '<i class="fa fa-facebook" aria-hidden="true"></i>', 'https://www.facebook.com', '2017-08-19 06:25:30', '2018-01-24 20:26:12'),
(5, 'twitter', '<i class="fa fa-twitter" aria-hidden="true"></i>', 'https://twitter.com', '2017-08-19 06:29:52', '2018-01-24 20:26:20'),
(6, 'linkedin', '<i class="fa fa-linkedin" aria-hidden="true"></i>', 'http://linkedin.com', '2017-08-19 06:30:23', '2018-01-24 20:26:33'),
(7, 'google plus', '<i class="fa fa-google-plus" aria-hidden="true"></i>', 'http://google.com', '2017-08-19 06:32:35', '2018-01-24 20:26:46'),
(8, 'instragram', '<i class="fa fa-instagram" aria-hidden="true"></i>', '#', '2017-08-19 07:28:44', '2017-08-19 07:28:44');

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

--
-- Table structure for table `supports`
--

CREATE TABLE IF NOT EXISTS `supports` (
  `id` int(10) unsigned NOT NULL,
  `user_id` int(11) NOT NULL,
  `subject` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ticket_number` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(4) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `support_messages`
--

CREATE TABLE IF NOT EXISTS `support_messages` (
  `id` int(10) unsigned NOT NULL,
  `support_id` int(11) NOT NULL,
  `ticket_number` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` int(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `testimonials`
--

CREATE TABLE IF NOT EXISTS `testimonials` (
  `id` int(10) unsigned NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `position` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` blob NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `testimonials`
--

INSERT INTO `testimonials` (`id`, `name`, `image`, `position`, `message`, `created_at`, `updated_at`) VALUES
(5, 'Ketthy Ben', '1513513770.jpg', 'Executive', 0x3c64697620616c69676e3d226a757374696679223e3c623e4c6f72656d20497073756d3c2f623e2069732073696d706c792064756d6d792074657874206f6620746865207072696e74696e6720616e64207479706573657474696e6720696e6475737472792e204c6f72656d20497073756d20686173206265656e2074686520696e6475737472792773207374616e646172642064756d6d79207465787420657665722073696e6365207468652031353030732c207768656e20616e20756e6b6e6f776e207072696e74657220746f6f6b20612067616c6c6579206f66207479706520616e6420736372616d626c656420697420746f206d616b65206120747970652073706563696d656e20626f6f6b2e20497420686173207375727669766564206e6f74206f6e6c7920666976652063656e7475726965732c2062757420616c736f20746865206c65617020696e746f20656c656374726f6e6963207479706573657474696e672c2072656d61696e696e6720657373656e7469616c6c7920756e6368616e6765642e2049742077617320706f70756c61726973656420696e207468652031393630732077697468207468652072656c65617365206f66204c657472617365742073686565747320636f6e7461696e696e67204c6f72656d20497073756d2070617373616765732c20616e64206d6f726520726563656e746c792077697468206465736b746f70207075626c697368696e6720736f667477617265206c696b6520416c64757320506167654d616b657220696e636c7564696e672076657273696f6e73206f66204c6f72656d20497073756d3c62723e3c2f6469763e, '2017-12-17 12:29:30', '2017-12-17 12:29:30'),
(6, 'Pial Chowdhury', '1513513877.jpg', 'Senior Executive', 0x3c64697620616c69676e3d226a757374696679223e3c623e4c6f72656d20497073756d3c2f623e2069732073696d706c792064756d6d792074657874206f6620746865207072696e74696e6720616e64207479706573657474696e6720696e6475737472792e204c6f72656d20497073756d20686173206265656e2074686520696e6475737472792773207374616e646172642064756d6d79207465787420657665722073696e6365207468652031353030732c207768656e20616e20756e6b6e6f776e207072696e74657220746f6f6b20612067616c6c6579206f66207479706520616e6420736372616d626c656420697420746f206d616b65206120747970652073706563696d656e20626f6f6b2e20497420686173207375727669766564206e6f74206f6e6c7920666976652063656e7475726965732c2062757420616c736f20746865206c65617020696e746f20656c656374726f6e6963207479706573657474696e672c2072656d61696e696e6720657373656e7469616c6c7920756e6368616e6765642e2049742077617320706f70756c61726973656420696e207468652031393630732077697468207468652072656c65617365206f66204c657472617365742073686565747320636f6e7461696e696e67204c6f72656d20497073756d2070617373616765732c20616e64206d6f726520726563656e746c792077697468206465736b746f70207075626c697368696e6720736f667477617265206c696b6520416c64757320506167654d616b657220696e636c7564696e672076657273696f6e73206f66204c6f72656d20497073756d3c62723e3c2f6469763e, '2017-12-17 12:31:17', '2017-12-17 12:31:17'),
(7, 'Usman Khaja', '1513513946.jpg', 'Sr. Accountant', 0x3c64697620616c69676e3d2263656e746572223e4c6f72656d20497073756d2069732073696d706c792064756d6d792074657874206f6620746865207072696e74696e6720616e64207479706573657474696e6720696e6475737472792e204c6f72656d20497073756d20686173206265656e2074686520696e6475737472792773207374616e646172642064756d6d79207465787420657665722073696e6365207468652031353030732c207768656e20616e20756e6b6e6f776e207072696e74657220746f6f6b2e3c62723e3c2f6469763e, '2017-12-17 12:32:26', '2017-12-17 12:32:26'),
(8, 'Pranto Biswas', '1513514001.jpg', 'Executive', 0x3c64697620616c69676e3d2263656e746572223e266e6273703b4c6f72656d20497073756d2069732073696d706c792064756d6d792074657874206f6620746865207072696e74696e6720616e64207479706573657474696e6720696e6475737472792e204c6f72656d20497073756d20686173206265656e2074686520696e6475737472792773207374616e646172642064756d6d79207465787420657665722073696e6365207468652031353030732c207768656e20616e20756e6b6e6f776e207072696e74657220746f6f6b2e3c62723e3c2f6469763e, '2017-12-17 12:33:21', '2017-12-17 12:33:21'),
(9, 'Angenila Jolly', '1513514065.jpg', 'CEO', 0x3c64697620616c69676e3d2263656e746572223e4c6f72656d20497073756d2069732073696d706c792064756d6d792074657874206f6620746865207072696e74696e6720616e64207479706573657474696e6720696e6475737472792e204c6f72656d20497073756d20686173206265656e2074686520696e6475737472792773207374616e646172642064756d6d79207465787420657665722073696e6365207468652031353030732c207768656e20616e20756e6b6e6f776e207072696e74657220746f6f6b2e3c62723e3c2f6469763e, '2017-12-17 12:34:25', '2017-12-17 12:34:25');

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

--
-- Table structure for table `trxes`
--

CREATE TABLE IF NOT EXISTS `trxes` (
  `id` int(10) unsigned NOT NULL,
  `track` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `sender` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `receiver` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `gross_amount` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `charge` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `net_amount` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `trxid` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `custom` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `trxes`
--

INSERT INTO `trxes` (`id`, `track`, `sender`, `receiver`, `gross_amount`, `charge`, `net_amount`, `type`, `description`, `trxid`, `custom`, `status`, `created_at`, `updated_at`) VALUES
(1, '1', '2', 'Cloud Mining', '10', '0', '10', 'PlanLog', 'Purchased SCRYPT CLOUD MINING 2', 'ac6bf15a3fb680c467932bc48466537a', '', 'approved', '2018-01-23 22:45:07', '2018-01-24 20:33:34'),
(2, '2', '2', 'Cloud Mining', '10', '0', '10', 'PlanLog', 'Purchased SCRYPT CLOUD MINING 3', '325470ae6b5a8847dc94ea56258fc2fb', '', 'requested', '2018-01-24 20:52:50', '2018-01-24 20:52:50'),
(3, '3', '2', 'Cloud Mining', '50', '0', '50', 'PlanLog', 'Purchased SCRYPT CLOUD MINING 4', '615c3d71453dc178c93bafbd4f8b94a2', '', 'requested', '2018-01-24 21:38:34', '2018-01-24 21:38:34'),
(4, '4', '2', 'Cloud Mining', '50', '0', '50', 'PlanLog', 'Purchased SCRYPT CLOUD MINING 4', '451b8f9df416678e5db7afb21e3872d4', '', 'requested', '2018-01-24 21:38:41', '2018-01-24 21:38:41'),
(5, '5', '2', 'Cloud Mining', '50', '0', '50', 'PlanLog', 'Purchased SCRYPT CLOUD MINING 4', '67aa168ef6f72e8fa3bb6485459700ea', '', 'requested', '2018-01-24 21:39:13', '2018-01-24 21:39:13'),
(6, '6', '2', 'Cloud Mining', '50', '0', '50', 'PlanLog', 'Purchased SCRYPT CLOUD MINING 4', '1af703f1d0947a45d8bd2f6e12a7248a', '', 'requested', '2018-01-25 00:15:59', '2018-01-25 00:15:59');

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

--
-- Table structure for table `users`
--

CREATE TABLE IF NOT EXISTS `users` (
  `id` int(10) unsigned NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `username` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'user-default.png',
  `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `reference` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `under_reference` int(11) NOT NULL,
  `email_verify` tinyint(1) NOT NULL,
  `email_code` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_time` datetime NOT NULL,
  `phone_verify` tinyint(1) NOT NULL,
  `phone_code` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone_time` datetime NOT NULL,
  `balance` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `tauth` int(11) NOT NULL DEFAULT '0',
  `tfver` int(11) NOT NULL DEFAULT '1',
  `secretcode` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `login_time` datetime DEFAULT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `name`, `username`, `email`, `phone`, `image`, `password`, `reference`, `under_reference`, `email_verify`, `email_code`, `email_time`, `phone_verify`, `phone_code`, `phone_time`, `balance`, `status`, `tauth`, `tfver`, `secretcode`, `login_time`, `remember_token`, `created_at`, `updated_at`) VALUES
(1, 'Rifayet Rifat', 'thesoftking', 'thesoftking@gmail.comx', '0171617171717', 'user-default.png', '$2y$10$isr001zz3XleM6QMGeszQuFtdG4DexWfcKRVG8ILqV6fF4PUmVxDG', 'thesoftking', 0, 1, 'WKPE7C', '2017-10-06 22:31:43', 1, 'HBWHUB', '2017-10-06 22:31:43', '0', 0, 0, 0, '0', NULL, 'hrw3pl9CKTNFAWsdjlAelskkxW0WUsw3OtuKe61HtYGwX4J6d1duVWKWANcx', '2017-10-06 21:26:43', '2017-10-23 23:47:23'),
(2, 'Shanto', 'admin', 'admin@gmail.com', '8801917995609', 'user-default.png', '$2y$10$QDM9CsR53UODmQYWpCGK7eR528uMeFIDSGVBFjEZx/rGlc06R95qq', 'admin', 0, 1, 'HRJFKO', '2017-12-26 12:35:58', 1, '8OVN5J', '2017-12-26 12:39:57', '98807.04999999999', 0, 0, 1, '0', '2018-01-24 19:47:59', 'Dtb0UScYbXnRtI7rroKlSABOZPaPHRY4WCuRc4duxe3SiyaJ9r8F86rB1mbj', '2017-10-07 23:05:52', '2018-01-25 01:48:38'),
(3, 'HostRecline', 'HostRecline', 'sales@hostrecline.com', '0171617171717', 'user-default.png', '$2y$10$pC3KSJl1JfzWjf7Kz.J3ieoknztPfkD3FuGeXU0ZjBV418xiABQR.', 'HostRecline', 2, 1, 'ENKIM2', '2017-10-08 00:13:05', 1, 'MTURZZ', '2017-10-08 00:13:05', '0', 0, 0, 0, '0', NULL, NULL, '2017-10-07 23:08:05', '2017-10-07 23:08:05'),
(4, 'riyad uddin', 'riyad', 'riyad@gmail.com', '1582006532633', 'user-default.png', '$2y$10$qsnIL8ZLFk8FchX4C.XEju/PgyvL0WsdrRDQEw3xx1ONGVBQTam76', 'riyad', 0, 1, 'HVEMHZ', '2017-10-16 10:47:22', 1, 'DIB4LU', '2017-10-16 10:47:22', '206790.86000000002', 0, 0, 0, '0', '2017-11-05 13:00:17', 'PCf6OmpbCGvoTAHp1Gf0nuFd4nlhoY0S5nUeg7rPaO9zuFy6fxzVPlSOGgAF', '2017-10-15 22:42:22', '2017-12-11 15:12:47'),
(5, 'pial', 'pialhh', 'pial@gmail.com', '52525522552', 'user-default.png', '$2y$10$09.uJBc/P5/Z17WIX4CreuF8hQRZCCd8ImTwktWdo17LdVYI7XswK', 'pialhh', 4, 1, 'EWFWWW', '2017-10-22 17:07:42', 1, 'UCMOOS', '2017-10-22 17:07:42', '50500', 0, 0, 0, '0', NULL, NULL, '2017-10-22 05:02:43', '2017-12-11 15:12:45'),
(6, 'Pranto Roy  thesoftking', 'prantoroy', 'pranto@live.com', '018123655282', 'prantoroy.jpg', '$2y$10$xEntnFm9lJ1ORJ.uvb6i8um5sRIrrHpPb7Fnuuqi4zxog2TvxMEQm', 'prantoroy', 4, 1, 'UVDVMG', '2017-10-24 14:59:10', 1, 'ZQEYFM', '2017-10-24 14:59:10', '3160', 0, 0, 0, '0', NULL, NULL, '2017-10-24 02:54:10', '2017-12-26 12:01:32'),
(7, 'Rifayet Rifat', 'support', 'thesoftking@gmail.com', '123456786543', 'user-default.png', '$2y$10$Ff9eqWytHvMlMSY7hdcRpeCJApmPJsfJzWZz2epDLSgmcL/ojyb9O', 'support', 0, 1, '7QKR88', '2017-11-05 13:50:42', 1, 'PDENCO', '2017-11-05 13:50:42', '0', 0, 0, 0, '0', NULL, NULL, '2017-11-05 13:45:42', '2017-11-05 13:45:42'),
(8, 'YH Shanto', 'shanto', 'yhossain.shanto@gmail.com', '01917995609', 'shanto.jpg', '$2y$10$jLYU.jQzKtxtta7CKMiZ5OYuNyOltNlQVYcWky8pspVc6N.ave.te', 'shanto', 0, 1, 'HGJMNJ', '2017-12-24 15:45:18', 1, 'HU59WP', '2017-12-24 15:56:59', '500', 0, 0, 1, '0', NULL, 'R6nKGnDoeaEcki7o5DDmr7JbpzLu7c8bSpjp1A0Apzxd16FfR8XWEI86MYpa', '2017-12-24 09:40:18', '2018-01-15 07:44:36'),
(9, 'abirkhan75', 'abirkhan75', 'abirkhan75@aa.cc', 'abirkhan75', 'user-default.png', '$2y$10$8h0eQK2QBVH61OlGzU67juH5C84D/59wl4RahDbYd2Nw9yVsXtz3K', 'abirkhan75', 0, 1, 'NECRSQ', '2017-12-24 16:56:17', 1, 'HORXVQ', '2017-12-24 16:56:17', '100', 0, 0, 0, '0', NULL, 'OXl84IFwxlGXdu6UpO4Cvlk2cf4sOzV6cLwMytUuPQYxYgcu0dCxonG61NkX', '2017-12-24 10:51:17', '2017-12-24 10:56:54'),
(10, 'YH', 'yhshanto', 'yh@gmail.com', '01917995601', 'user-default.png', '$2y$10$XufvgooOAcrQwazd73vDXOrH4OZUV2TLFMWj4MNVjf4oxowF04aEW', 'yhshanto', 0, 1, 'Q8LWHU', '2017-12-24 17:23:48', 1, 'KDZ4DU', '2017-12-24 17:23:48', '600', 0, 0, 0, '0', '2017-12-25 17:29:34', 'QasYyWunIEEb5nNVGeOqDjkvRiThxe1E8NHutyQw0OPQ6cnE9jqXblLpOo5z', '2017-12-24 11:18:49', '2017-12-25 11:29:34'),
(11, 'abirkhan750', 'abirkhan750', 'abirkhan750@gmail.com', '018484864684854864', 'user-default.png', '$2y$10$5tJYfEYAHx1X4ZTzQndcTePbCQ1iklFeu5o1fk1AdV1yxpGfyGffu', 'abirkhan750', 0, 1, 'QKDIEJ', '2017-12-25 19:15:14', 1, 'IXUHVU', '2017-12-25 19:15:14', '49869.5', 0, 0, 0, '0', NULL, 'YgVAZNBFp312TMojZDnXPCVsucKnK1dmrhXvDEA2GR17kHsbX8QLgxeB0QK9', '2017-12-25 13:10:14', '2017-12-25 13:29:08'),
(12, 'Shanto', 'ubaidah', 'yousuf.hossain.shanto@gmail.com', '8801917995606', 'user-default.png', '$2y$10$NsR1pOpsmbJgaO1fek1XY.wcXtW1OyIXikVVHN8HaaLpxDrGA7fQy', 'ubaidah', 0, 1, 'MUV3W0', '2017-12-26 19:35:35', 1, 'MC1YG2', '2017-12-26 19:13:14', '29.5', 0, 0, 1, '0', NULL, 'iIbDpjSFRwzeCxjqKtgGWY8MvMq3faAml2w813Y3oQfLHAsAEbtU2acgqZJ1', '2017-12-27 01:08:10', '2018-01-15 12:25:39'),
(13, 'Test', 'testuser', 'test@testtest.com', '1234567890', 'user-default.png', '$2y$10$pNcjSzDi5oPGLq2XT07BwuPKKxQGK4hkZfVI8SbDGmio94AZcrtdS', 'testuser', 0, 1, 'QLNOTE', '2017-12-29 19:30:11', 1, 'JRRTO1', '2017-12-29 19:30:11', '0', 0, 0, 0, '0', NULL, NULL, '2017-12-30 01:25:11', '2017-12-30 01:25:11'),
(14, 'nassif', 'nassifgho', 'nassifghossoub@gmail.com', '+96176366744', 'user-default.png', '$2y$10$tvjgkh0dKU6Di9ofgVQh7OfS2/UYvykfvAg8MT0U3NhxNCaATqpiC', 'nassifgho', 0, 1, 'JFNJTP', '2018-01-03 04:41:00', 1, 'V6EMMT', '2018-01-03 04:41:00', '0', 0, 0, 1, '0', NULL, 'awR5ht2MmPEyHUhlkbzqzxbYcfK73MGHE1ChZj7gzydBpzRMvnduRrzrXiaT', '2018-01-03 10:36:00', '2018-01-03 10:36:00'),
(23, 'YH Shanto', 'ubbai', 'yhossainshanto@gmail.com', '01917995605', 'user-default.png', '$2y$10$oR0Xp2p/L2P30dTTR1xGOOwmufhsZ/3mNEIZOBweYC9NNA1YVwSce', 'ubbai', 0, 1, 'V7NTWL', '2018-01-15 20:29:02', 1, 'X9WRU7', '2018-01-15 20:29:02', '0', 0, 0, 1, '0', NULL, 'Vb7tj7L7HsPfiIrDjPlWUK61Z1kJJ0AEbSqtOfqEJJwuxd2xhPJBIY3y8L7X', '2018-01-16 02:24:02', '2018-01-16 02:37:54'),
(24, 'Franky', 'Franky', 'dagol.wr1@gmail.com', '2707272956', 'user-default.png', '$2y$10$Q5L/5HUaehjkl645bBMG2uZI5fUNEN5ZI2AfbhwXLoJnnC8RFCUfS', 'Franky', 0, 1, 'J2BRFX', '2018-01-16 19:55:35', 1, '6ZSNKO', '2018-01-16 19:55:35', '0', 0, 0, 1, '0', NULL, NULL, '2018-01-17 01:50:35', '2018-01-17 01:50:35'),
(25, 'Fiko', 'Firdos007', 'actrade1144@yahoo.com', '+994507731334', 'user-default.png', '$2y$10$8eJurYdAEeBWCPL7SbCV2ODPiORlHAhmCU.vCRhyNwbmYzCEBhyWq', 'Firdos007', 0, 1, 'NUMJC3', '2018-01-23 01:03:06', 1, 'FKQBTS', '2018-01-23 01:03:06', '0', 0, 0, 1, '0', NULL, NULL, '2018-01-23 06:58:06', '2018-01-23 06:58:06'),
(26, 'Riadul Islam', 'supportx', 'editorvapress@gmail.comX', '1736102007', 'user-default.png', '$2y$10$vDlKXV/xOJUSL4yryT7Nru381sujZEuGGkKcnKFYKL16ayhDRO1/S', 'supportx', 0, 1, 'KS90JD', '2018-01-24 14:57:25', 1, 'JQZOHM', '2018-01-24 14:57:25', '0', 0, 0, 1, '0', '2018-01-24 15:37:59', 'txQa6exnZj6CvH98sVvkEmKYwam7mhhq1NRuh13i74aFlD3AQDpoT6KThzLH', '2018-01-24 20:52:25', '2018-01-24 21:38:06');

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

--
-- Table structure for table `user_datas`
--

CREATE TABLE IF NOT EXISTS `user_datas` (
  `id` int(10) unsigned NOT NULL,
  `user_id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `wallet` longtext COLLATE utf8mb4_unicode_ci,
  `balance` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_datas`
--

INSERT INTO `user_datas` (`id`, `user_id`, `category_id`, `wallet`, `balance`, `created_at`, `updated_at`) VALUES
(1, 2, 2, '', '0', '2018-01-23 22:44:58', '2018-01-23 22:44:58'),
(2, 2, 3, '', '0', '2018-01-23 22:44:58', '2018-01-23 22:44:58'),
(3, 2, 4, '', '0', '2018-01-23 22:44:58', '2018-01-23 22:44:58'),
(4, 2, 5, '', '0', '2018-01-23 22:44:58', '2018-01-23 22:44:58'),
(5, 2, 6, '', '0', '2018-01-23 22:44:58', '2018-01-23 22:44:58'),
(6, 2, 8, '', '0', '2018-01-23 22:44:58', '2018-01-23 22:44:58'),
(7, 2, 10, '', '0', '2018-01-23 22:44:58', '2018-01-23 22:44:58'),
(8, 26, 2, '', '0', '2018-01-24 20:52:27', '2018-01-24 20:52:27'),
(9, 26, 3, '', '0', '2018-01-24 20:52:27', '2018-01-24 20:52:27'),
(10, 26, 4, '', '0', '2018-01-24 20:52:27', '2018-01-24 20:52:27'),
(11, 26, 5, '', '0', '2018-01-24 20:52:27', '2018-01-24 20:52:27'),
(12, 26, 6, '', '0', '2018-01-24 20:52:27', '2018-01-24 20:52:27');

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

--
-- Table structure for table `user_logins`
--

CREATE TABLE IF NOT EXISTS `user_logins` (
  `id` int(10) unsigned NOT NULL,
  `user_id` int(11) NOT NULL,
  `user_ip` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `location` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `details` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_logins`
--

INSERT INTO `user_logins` (`id`, `user_id`, `user_ip`, `location`, `details`, `created_at`, `updated_at`) VALUES
(1, 2, '59.153.30.40', 'Rangpur - 0 - Bangladesh - BD ', 'Firefox on Windows 10', '2018-01-23 22:44:57', '2018-01-23 22:44:57'),
(2, 2, '59.153.30.40', 'Rangpur - 0 - Bangladesh - BD ', 'Chrome on Windows 7', '2018-01-24 20:52:49', '2018-01-24 20:52:49'),
(3, 2, '59.153.30.40', 'Rangpur - 0 - Bangladesh - BD ', 'Chrome on Windows 7', '2018-01-24 21:33:09', '2018-01-24 21:33:09'),
(4, 26, '59.153.30.40', 'Rangpur - 0 - Bangladesh - BD ', 'Chrome on Windows 7', '2018-01-24 21:37:59', '2018-01-24 21:37:59'),
(5, 2, '59.153.30.40', 'Rangpur - 0 - Bangladesh - BD ', 'Chrome on Windows 7', '2018-01-24 21:38:14', '2018-01-24 21:38:14'),
(6, 2, '59.153.30.40', 'Rangpur - 0 - Bangladesh - BD ', 'Chrome on Windows 7', '2018-01-25 00:15:21', '2018-01-25 00:15:21'),
(7, 2, '59.153.30.40', 'Rangpur - 0 - Bangladesh - BD ', 'Firefox on Windows 10', '2018-01-25 00:18:18', '2018-01-25 00:18:18'),
(8, 2, '59.153.30.40', 'Rangpur - 0 - Bangladesh - BD ', 'Chrome on Windows 7', '2018-01-25 01:47:59', '2018-01-25 01:47:59');

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

--
-- Table structure for table `user_logs`
--

CREATE TABLE IF NOT EXISTS `user_logs` (
  `id` int(10) unsigned NOT NULL,
  `user_id` int(11) NOT NULL,
  `transaction_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount_type` tinyint(4) NOT NULL,
  `charge` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `post_bal` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `withdraw_logs`
--

CREATE TABLE IF NOT EXISTS `withdraw_logs` (
  `id` int(10) unsigned NOT NULL,
  `user_id` int(11) NOT NULL,
  `method_id` int(11) NOT NULL,
  `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `transaction_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `charge` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `net_amount` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `send_details` text COLLATE utf8mb4_unicode_ci,
  `message` text COLLATE utf8mb4_unicode_ci,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `withdraw_methods`
--

CREATE TABLE IF NOT EXISTS `withdraw_methods` (
  `id` int(10) unsigned NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `withdraw_min` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `withdraw_max` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `fix` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `percent` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `duration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `withdraw_methods`
--

INSERT INTO `withdraw_methods` (`id`, `name`, `image`, `withdraw_min`, `withdraw_max`, `fix`, `percent`, `duration`, `status`, `created_at`, `updated_at`) VALUES
(1, 'bKash', '1506108954h8.png', '500', '25000', '25', '2.25', '2', 1, '2017-07-28 09:09:41', '2017-09-22 07:36:13'),
(2, 'Sure Cash', '1508828617h8.png', '100', '2000', '25', '2.30', '3', 1, '2017-07-28 09:10:00', '2017-10-24 01:03:37'),
(3, 'Dutch Bangla Bank', '1506112905h8.png', '50', '20000', '0', '0', '1', 1, '2017-08-09 15:06:21', '2017-10-24 01:01:54'),
(5, 'SADFADSF', '1508846467h8.png', '10000', '10000', '10', '1', '15', 1, '2017-10-24 06:01:07', '2017-10-24 06:01:07');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `admins`
--
ALTER TABLE `admins`
  ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `admins_email_unique` (`email`);

--
-- Indexes for table `apis`
--
ALTER TABLE `apis`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `basic_settings`
--
ALTER TABLE `basic_settings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `deposits`
--
ALTER TABLE `deposits`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `deposit_images`
--
ALTER TABLE `deposit_images`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `faqs`
--
ALTER TABLE `faqs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `features`
--
ALTER TABLE `features`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `investments`
--
ALTER TABLE `investments`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `menus`
--
ALTER TABLE `menus`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `pages`
--
ALTER TABLE `pages`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `partners`
--
ALTER TABLE `partners`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `password_resets`
--
ALTER TABLE `password_resets`
  ADD KEY `password_resets_email_index` (`email`);

--
-- Indexes for table `payment_logs`
--
ALTER TABLE `payment_logs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `payment_methods`
--
ALTER TABLE `payment_methods`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `plans`
--
ALTER TABLE `plans`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `plan_logs`
--
ALTER TABLE `plan_logs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `procedures`
--
ALTER TABLE `procedures`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `repeats`
--
ALTER TABLE `repeats`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `repeat_logs`
--
ALTER TABLE `repeat_logs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `returns`
--
ALTER TABLE `returns`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `services`
--
ALTER TABLE `services`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sliders`
--
ALTER TABLE `sliders`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `socials`
--
ALTER TABLE `socials`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `supports`
--
ALTER TABLE `supports`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `support_messages`
--
ALTER TABLE `support_messages`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `testimonials`
--
ALTER TABLE `testimonials`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `trxes`
--
ALTER TABLE `trxes`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `users_email_unique` (`email`);

--
-- Indexes for table `user_datas`
--
ALTER TABLE `user_datas`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `user_logins`
--
ALTER TABLE `user_logins`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `user_logs`
--
ALTER TABLE `user_logs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `withdraw_logs`
--
ALTER TABLE `withdraw_logs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `withdraw_methods`
--
ALTER TABLE `withdraw_methods`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `admins`
--
ALTER TABLE `admins`
  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `apis`
--
ALTER TABLE `apis`
  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `basic_settings`
--
ALTER TABLE `basic_settings`
  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=12;
--
-- AUTO_INCREMENT for table `deposits`
--
ALTER TABLE `deposits`
  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `deposit_images`
--
ALTER TABLE `deposit_images`
  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `faqs`
--
ALTER TABLE `faqs`
  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `features`
--
ALTER TABLE `features`
  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=9;
--
-- AUTO_INCREMENT for table `investments`
--
ALTER TABLE `investments`
  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=22;
--
-- AUTO_INCREMENT for table `menus`
--
ALTER TABLE `menus`
  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=9;
--
-- AUTO_INCREMENT for table `pages`
--
ALTER TABLE `pages`
  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `partners`
--
ALTER TABLE `partners`
  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `payment_logs`
--
ALTER TABLE `payment_logs`
  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `payment_methods`
--
ALTER TABLE `payment_methods`
  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `plans`
--
ALTER TABLE `plans`
  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `plan_logs`
--
ALTER TABLE `plan_logs`
  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `procedures`
--
ALTER TABLE `procedures`
  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `repeats`
--
ALTER TABLE `repeats`
  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `repeat_logs`
--
ALTER TABLE `repeat_logs`
  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `returns`
--
ALTER TABLE `returns`
  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `services`
--
ALTER TABLE `services`
  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=9;
--
-- AUTO_INCREMENT for table `sliders`
--
ALTER TABLE `sliders`
  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `socials`
--
ALTER TABLE `socials`
  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=9;
--
-- AUTO_INCREMENT for table `supports`
--
ALTER TABLE `supports`
  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `support_messages`
--
ALTER TABLE `support_messages`
  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `testimonials`
--
ALTER TABLE `testimonials`
  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=10;
--
-- AUTO_INCREMENT for table `trxes`
--
ALTER TABLE `trxes`
  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=27;
--
-- AUTO_INCREMENT for table `user_datas`
--
ALTER TABLE `user_datas`
  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=13;
--
-- AUTO_INCREMENT for table `user_logins`
--
ALTER TABLE `user_logins`
  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=9;
--
-- AUTO_INCREMENT for table `user_logs`
--
ALTER TABLE `user_logs`
  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `withdraw_logs`
--
ALTER TABLE `withdraw_logs`
  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `withdraw_methods`
--
ALTER TABLE `withdraw_methods`
  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
