--
-- Dumping data for table `tbl_settings`
--

INSERT INTO `tbl_settings` (`type`, `value`, `updatedDtm`) VALUES
('envato_purchase_code', '', '2020-04-01 13:10:00'),
('disable_frontend', '', '2020-04-01 13:12:21'),
('disable_index', '', '2020-04-01 13:11:47'),
('kyc_allow_deposits', '0', '2020-04-01 13:10:00'),
('kyc_allow_withdrawals', '0', '2020-06-01 15:17:46'), 
('kyc_status', '0', '2020-06-01 15:17:46'),
('kyc_verify_address', '0', '2020-04-01 13:10:00'),
('kyc_verify_id', '0', '2020-04-01 13:12:48'),
('refactive', '0', '2020-04-01 13:10:00'),
('reffrequency', '0', '2020-04-01 13:10:00');

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

--
-- Table structure for table `tbl_coinbase`
--

CREATE TABLE `tbl_coinbase` (
  `id` int NOT NULL,
  `userId` int NOT NULL,
  `invoice` varchar(255) NOT NULL,
  `planId` int NOT NULL,
  `txn_id` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `amount` decimal(10,2) DEFAULT NULL,
  `currency` varchar(255) DEFAULT NULL,
  `status` int NOT NULL DEFAULT '0',
  `modifiedDtm` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `createdDtm` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Dumping data for table `tbl_email_templates`
--

INSERT INTO `tbl_email_templates` (`id`, `type`, `title`, `mail_subject`, `mail_body`, `modifiedBy`, `modifiedDtm`, `createdDtm`, `sms_body`) VALUES
(14, 'Deposit Notification', '', 'You have a new deposit to approve.', 0x[BLOB], 1, '2020-11-07 07:03:50', '2020-07-01 16:20:48', 'You have a new deposit to approve');

-- --------------------------------------------------------
--
-- ADD COLUMNS for table `tbl_payment_methods`
--

ALTER TABLE tbl_payment_methods
ADD depo_variable_comm varchar(255) NULL,
ADD depo_fixed_comm varchar(255) NULL,
ADD withdr_variable_comm varchar(255) NULL,
ADD withdr_fixed_comm varchar(255) NULL;

--
-- Dumping data for table `tbl_payment_methods`
--

INSERT INTO `tbl_payment_methods` (`id`, `name`, `logo`, `type`, `ref`, `API`, `bank_name`, `account_name`, `account_number`, `swift_code`, `variableComm`, `fixedComm`, `transFee`, `depo_variable_comm`, `depo_fixed_comm`, `withdr_variable_comm`, `withdr_fixed_comm`, `iswithdrawable`, `note`, `status`) VALUES
(38, 'Coinbase', 'coinbase.png', 'auto', '', 54, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0),
(39, 'Perfect Money', 'Perfect_Money.png', 'auto', '', 55, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0);

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

--
-- Table structure for table `tbl_verification`
--

CREATE TABLE `tbl_verification` (
  `id` int NOT NULL,
  `userId` int NOT NULL,
  `id_type` varchar(255) DEFAULT NULL,
  `identification_document` varchar(255) DEFAULT NULL,
  `rejected_identification_document` varchar(255) DEFAULT NULL,
  `rejection_reason_id` varchar(255) DEFAULT NULL,
  `status1` int NOT NULL DEFAULT '0',
  `address_type` varchar(255) NOT NULL,
  `address_document` varchar(255) DEFAULT NULL,
  `rejected_address_document` varchar(255) DEFAULT NULL,
  `rejection_reason_address` varchar(255) DEFAULT NULL,
  `status2` int NOT NULL DEFAULT '0',
  `overall_status` int NOT NULL DEFAULT '0',
  `assignedTo` int DEFAULT NULL,
  `createdDtm` datetime NOT NULL,
  `updatedDtm` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- ADD COLUMNS for table `tbl_withdrawals`
--

ALTER TABLE tbl_withdrawals
ADD transaction_fee decimal(13,2) NOT NULL DEFAULT '0.00',
ADD amount_less_transaction_fee decimal(13,2) NOT NULL;

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

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

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

--
-- AUTO_INCREMENT for table `tbl_coinbase`
--
ALTER TABLE `tbl_coinbase`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_verification`
--
ALTER TABLE `tbl_verification`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;