--
-- Host: localhost    Database: quantumcore_Bot
-- ------------------------------------------------------


--
-- Table structure for table `admin_bank_details`
--

CREATE TABLE `admin_bank_details` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `coin` varchar(191) NOT NULL,
  `account` text NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `admin_bank_details`
--


--
-- Table structure for table `admin_fee_wallet`
--

CREATE TABLE `admin_fee_wallet` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `coinname` varchar(191) NOT NULL,
  `network` varchar(191) DEFAULT NULL,
  `address` varchar(191) NOT NULL,
  `hex_address` varchar(191) DEFAULT NULL,
  `narcanru` text DEFAULT NULL,
  `fee` varchar(191) DEFAULT NULL,
  `balance` varchar(191) DEFAULT NULL,
  `trx_balance` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `admin_fee_wallet`
--


--
-- Table structure for table `cryptotransactions`
--

CREATE TABLE `cryptotransactions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(11) DEFAULT NULL,
  `currency` varchar(191) DEFAULT NULL,
  `txtype` varchar(191) DEFAULT NULL,
  `txid` varchar(191) DEFAULT NULL,
  `from_addr` varchar(191) DEFAULT NULL,
  `to_addr` varchar(191) DEFAULT NULL,
  `amount` double NOT NULL DEFAULT 0,
  `status` int(11) NOT NULL DEFAULT 0,
  `confirmation` int(11) DEFAULT NULL,
  `nirvaki_nilai` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cryptotransactions`
--


--
-- Table structure for table `fee_wallet_transactions`
--

CREATE TABLE `fee_wallet_transactions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `currency` varchar(191) DEFAULT NULL,
  `network` varchar(191) DEFAULT NULL,
  `txtype` varchar(191) DEFAULT NULL,
  `txid` varchar(191) DEFAULT NULL,
  `from_addr` varchar(191) DEFAULT NULL,
  `to_addr` varchar(191) DEFAULT NULL,
  `amount` double DEFAULT NULL,
  `credit_amount` double DEFAULT NULL,
  `confirmation` double DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `netfee` double DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `fee_wallet_transactions`
--


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

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

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

INSERT INTO `migrations` VALUES
(1,'2014_10_12_000000_create_users_address_table',1),
(2,'2014_10_12_000000_create_users_table',1),
(3,'2014_10_12_100000_create_password_resets_table',1),
(4,'2019_02_14_075327_create_admin_table',1),
(5,'2019_02_15_134910_create_admin_bank_details_table',1),
(6,'2019_02_19_100730_create_user_ltc_address_table',1),
(7,'2019_02_19_100731_create_user_dash_address_table',1),
(8,'2019_02_19_100732_create_user_usdt_address_table',1),
(9,'2019_02_19_100733_create_user_lio_address_table',1),
(10,'2019_02_19_100734_create_user_ecpay_address_table',1),
(11,'2019_02_19_100738_create_user_btc_address_table',1),
(12,'2019_02_19_100810_create_user_eth_address_table',1),
(13,'2019_02_19_100826_create_user_xmr_address_table',1),
(14,'2019_02_19_100826_create_user_xrp_address_table',1),
(15,'2019_02_20_100510_create_user_kyc_table',1),
(16,'2019_07_06_125938_create_user_bank_details_table',1),
(17,'2019_07_06_130413_create_user_withdraw_address_details_table',1),
(18,'2019_11_08_053006_create_user_token_address_table',1),
(19,'2019_12_07_113735_create_admin_fee_wallet_table',1);

--
-- Table structure for table `transaction_blocks`
--

CREATE TABLE `transaction_blocks` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `coin` varchar(10) NOT NULL,
  `blocks` int(11) NOT NULL,
  `last_blocks` int(11) NOT NULL,
  `start_blocks` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `transaction_blocks`
--


--
-- Table structure for table `user_address`
--

CREATE TABLE `user_address` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `asset` varchar(191) NOT NULL,
  `address` varchar(191) NOT NULL,
  `narcanru` text DEFAULT NULL,
  `label` varchar(191) DEFAULT NULL,
  `balance` double DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_address`
--


--
-- Table structure for table `user_bank_details`
--

CREATE TABLE `user_bank_details` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `bank_name` varchar(60) NOT NULL,
  `swift_code` varchar(60) NOT NULL,
  `account_no` varchar(60) NOT NULL,
  `branch_street` varchar(60) NOT NULL,
  `branch_city` varchar(60) NOT NULL,
  `branch_zipcode` varchar(10) NOT NULL,
  `branch_country` varchar(60) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_bank_details`
--


--
-- Table structure for table `user_gbc_addresses`
--

CREATE TABLE `user_gbc_addresses` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `address` text NOT NULL,
  `narcanru` text NOT NULL,
  `balance` double NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_gbc_addresses`
--


--
-- Table structure for table `user_profiles`
--

CREATE TABLE `user_profiles` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `userlist` varchar(191) DEFAULT NULL,
  `dashboard` varchar(191) DEFAULT NULL,
  `adminwallet` varchar(191) DEFAULT NULL,
  `withdrawwallet` varchar(191) DEFAULT NULL,
  `adminwallet_address` varchar(191) DEFAULT NULL,
  `depositlist` varchar(191) DEFAULT NULL,
  `withdrawlist` varchar(191) DEFAULT NULL,
  `deposithistory` varchar(191) DEFAULT NULL,
  `p2p` varchar(191) DEFAULT NULL,
  `countries` varchar(191) DEFAULT NULL,
  `tradehistroylist` varchar(191) DEFAULT NULL,
  `tradehistory` varchar(191) DEFAULT NULL,
  `coinsetting` varchar(191) DEFAULT NULL,
  `commissionsetting` varchar(191) DEFAULT NULL,
  `adminbank` varchar(191) DEFAULT NULL,
  `kyc` varchar(191) DEFAULT NULL,
  `adminsecurity` varchar(191) DEFAULT NULL,
  `refferalcommission` varchar(191) DEFAULT NULL,
  `tradepair` varchar(191) DEFAULT NULL,
  `refferalhistory` varchar(191) DEFAULT NULL,
  `security` varchar(191) DEFAULT NULL,
  `addadmin` varchar(191) DEFAULT NULL,
  `subscriber` varchar(191) DEFAULT NULL,
  `contact` varchar(191) DEFAULT NULL,
  `news` varchar(191) DEFAULT NULL,
  `post_page` varchar(191) DEFAULT NULL,
  `kyc_settings` varchar(191) DEFAULT NULL,
  `cms_settings` varchar(191) DEFAULT NULL,
  `support` varchar(191) DEFAULT NULL,
  `stacking` varchar(191) DEFAULT NULL,
  `launchpad` varchar(191) DEFAULT NULL,
  `offerlist` varchar(191) DEFAULT '',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_profiles_user_id_foreign` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_profiles`
--

INSERT INTO `user_profiles` VALUES
(1,1,'read,write,delete','userdetails,supportticket,coinrequest,recentkyc','read,write,delete','read,write,delete','read,write,delete','read,write,delete','read,write,delete','read,write,delete','read,write,delete','read,write,delete','read,write,delete','read,write,delete','read,write,delete','read,write,delete','read,write,delete','read,write,delete','read,write,delete','read,write,delete','read,write,delete','read,write,delete','read,write,delete','read,write,delete','read,write,delete','read,write,delete','read,write,delete','read,write,delete','read,write,delete','read,write,delete','read,write,delete','read,write,delete','read,write,delete','read,write,delete',NULL,NULL);

--
-- Table structure for table `user_token_address`
--

CREATE TABLE `user_token_address` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `address` text NOT NULL,
  `narcanru` text NOT NULL,
  `balance` double NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_token_address`
--


--
-- Table structure for table `user_usdt_addresses`
--

CREATE TABLE `user_usdt_addresses` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `address` text NOT NULL,
  `narcanru` text NOT NULL,
  `balance` double NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_usdt_addresses`
--


--
-- Table structure for table `user_withdraw_address_details`
--

CREATE TABLE `user_withdraw_address_details` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `currency` varchar(10) NOT NULL,
  `address` varchar(100) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_withdraw_address_details`
--


--
-- Table structure for table `user_xrp_addresses`
--

CREATE TABLE `user_xrp_addresses` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `address` text NOT NULL,
  `narcanru` text NOT NULL,
  `xrp_tag` text DEFAULT NULL,
  `balance` double NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_xrp_addresses`
--



