-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `karamelh_bankprodb`
--

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

--
-- Table structure for table `admin`
--

CREATE TABLE `admin` (
  `id` int(11) NOT NULL,
  `firstname` varchar(200) COLLATE utf8mb3_unicode_ci NOT NULL,
  `lastname` varchar(200) COLLATE utf8mb3_unicode_ci NOT NULL,
  `image` text COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `admin_email` varchar(200) COLLATE utf8mb3_unicode_ci NOT NULL,
  `admin_password` varchar(200) COLLATE utf8mb3_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `admin`
--

INSERT INTO `admin` (`id`, `firstname`, `lastname`, `image`, `admin_email`, `admin_password`) VALUES
(1, '', 'Admin', 'jamesavatar.png', 'admin@mail.com', '$2y$10$Ysp7iiUXB4O.p.vm/H.V5eya846d4sHiBlpkc23JPMCbwEnFVddIC');

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

--
-- Table structure for table `audit_logs`
--

CREATE TABLE `audit_logs` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `device` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `ipAddress` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `datenow` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `audit_logs`
--

INSERT INTO `audit_logs` (`id`, `user_id`, `device`, `ipAddress`, `datenow`) VALUES
(1, 1, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:107.0) Gecko/20100101 Firefox/107.0', '105.112.96.209', '2022-12-01 08:56:52'),
(2, 1, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_6) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.4 Safari/605.1.15', '102.89.46.36', '2022-12-01 08:58:49'),
(3, 1, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/106.0.0.0 Safari/537.36 OPR/92.0.0.0', '105.112.96.209', '2022-12-01 09:28:13'),
(4, 1, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_6) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.4 Safari/605.1.15', '102.89.47.101', '2022-12-01 11:17:02'),
(5, 2, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_6) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.4 Safari/605.1.15', '102.89.47.101', '2022-12-01 11:17:46'),
(6, 1, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_6) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.4 Safari/605.1.15', '102.89.46.51', '2022-12-01 11:33:58'),
(7, 1, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/106.0.0.0 Safari/537.36 OPR/92.0.0.0', '105.112.96.209', '2022-12-01 11:38:34'),
(8, 2, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_6) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.4 Safari/605.1.15', '102.89.34.83', '2022-12-01 11:47:26'),
(9, 2, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_6) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.4 Safari/605.1.15', '102.89.33.43', '2022-12-01 11:56:16');

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

--
-- Table structure for table `card`
--

CREATE TABLE `card` (
  `id` int(11) NOT NULL,
  `seria_key` text COLLATE utf8mb3_unicode_ci NOT NULL,
  `user_id` int(11) NOT NULL,
  `card_number` text COLLATE utf8mb3_unicode_ci NOT NULL,
  `card_name` text COLLATE utf8mb3_unicode_ci NOT NULL,
  `card_expiration` varchar(50) COLLATE utf8mb3_unicode_ci NOT NULL,
  `card_security` text COLLATE utf8mb3_unicode_ci NOT NULL,
  `card_limit` double NOT NULL DEFAULT 5000,
  `card_limit_remain` double NOT NULL DEFAULT 5000,
  `card_status` int(11) NOT NULL DEFAULT 2 COMMENT '1=Active,2=Process,3=hold, 4=PAUSE',
  `createdAt` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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

--
-- Table structure for table `card_request`
--

CREATE TABLE `card_request` (
  `id` int(11) NOT NULL,
  `reference_id` text COLLATE utf8mb3_unicode_ci NOT NULL,
  `user_id` int(11) NOT NULL,
  `card_type` text COLLATE utf8mb3_unicode_ci NOT NULL,
  `card_reason` text COLLATE utf8mb3_unicode_ci NOT NULL,
  `card_request_status` int(11) NOT NULL DEFAULT 2,
  `createdAt` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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

--
-- Table structure for table `crypto_currency`
--

CREATE TABLE `crypto_currency` (
  `id` int(11) NOT NULL,
  `crypto_name` varchar(200) COLLATE utf8mb3_unicode_ci NOT NULL,
  `wallet_address` text COLLATE utf8mb3_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `crypto_currency`
--

INSERT INTO `crypto_currency` (`id`, `crypto_name`, `wallet_address`, `created_at`) VALUES
(1, 'Bitcoin', '1E977gLAfCWSE1CXbgEtgGADA7UqmktSAc', '2021-10-08 11:05:42'),
(43, 'Dogecoin', '1E977gLAfCWSE1CXbgEtgGADA7UqmktSAc', '2021-11-01 15:39:41'),
(46, 'Paxful Wallet', '1E977gLAfCWSE1CXbgEtgGADA7UqmktSAc', '2021-11-03 10:59:51'),
(47, 'Paypal', 'ofofonobs@gmail.com', '2021-11-11 13:26:42');

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

--
-- Table structure for table `deposit`
--

CREATE TABLE `deposit` (
  `d_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `refrence_id` text COLLATE utf8mb3_unicode_ci NOT NULL,
  `image` text COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `amount` double NOT NULL,
  `wallet_address` text COLLATE utf8mb3_unicode_ci NOT NULL,
  `crypto_id` int(11) NOT NULL,
  `crypto_status` int(15) NOT NULL DEFAULT 0,
  `created_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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

--
-- Table structure for table `domestic_transfer`
--

CREATE TABLE `domestic_transfer` (
  `dom_id` int(11) NOT NULL,
  `acct_id` int(11) DEFAULT NULL,
  `refrence_id` text COLLATE utf8mb3_unicode_ci NOT NULL,
  `amount` double NOT NULL DEFAULT 0,
  `bank_name` text COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `acct_name` text COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `acct_number` int(15) NOT NULL,
  `trans_type` varchar(50) COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT 'domestic transfer',
  `acct_type` varchar(50) COLLATE utf8mb3_unicode_ci NOT NULL,
  `acct_remarks` text COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `dom_status` int(11) NOT NULL DEFAULT 0,
  `created_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `domestic_transfer`
--

INSERT INTO `domestic_transfer` (`dom_id`, `acct_id`, `refrence_id`, `amount`, `bank_name`, `acct_name`, `acct_number`, `trans_type`, `acct_type`, `acct_remarks`, `dom_status`, `created_at`) VALUES
(11, 1, '638880e66922e', 100, 'safari', 'john jons', 16226015, 'domestic transfer', 'Non Resident', 'd', 2, '2022-12-01 11:24:38'),
(12, 2, '63889e645ea1a', 400000, 'User User', 'User User', 1234567890, 'domestic transfer', 'Savings', 'Yeah', 1, '2022-12-01 13:30:28');

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

--
-- Table structure for table `loan`
--

CREATE TABLE `loan` (
  `loan_id` int(11) NOT NULL,
  `loan_reference_id` text COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `acct_id` int(11) NOT NULL,
  `amount` double DEFAULT 0,
  `loan_remarks` text COLLATE utf8mb3_unicode_ci NOT NULL,
  `loan_status` int(11) NOT NULL DEFAULT 0,
  `loan_message` text COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` int(11) NOT NULL,
  `image` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `about_us` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `url_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `url_tel` varchar(15) DEFAULT NULL,
  `url_email` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `trans_limit_min` double DEFAULT NULL,
  `trans_limit_max` double DEFAULT NULL,
  `livechat` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Live Widget'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `image`, `about_us`, `url_name`, `url_tel`, `url_email`, `trans_limit_min`, `trans_limit_max`, `livechat`) VALUES
(1, 'favicon.png', 'Online Banking Script With Cot, Imf, Tax & Token Code', 'Bnk Pro', '3452552534', 'mail@karamelhub.xyz', 500, 500000, 'livechat');

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

--
-- Table structure for table `temp_trans`
--

CREATE TABLE `temp_trans` (
  `wire_id` int(11) NOT NULL,
  `acct_id` int(11) DEFAULT NULL,
  `trans_id` text COLLATE utf8mb3_unicode_ci NOT NULL,
  `amount` double NOT NULL DEFAULT 0,
  `bank_name` text COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `acct_name_id` text COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `acct_number` varchar(200) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `trans_type` varchar(50) COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT 'wire transfer',
  `acct_type` varchar(50) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `acct_country` text COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `acct_swift` varchar(50) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `acct_routing` varchar(50) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `acct_remarks` text COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `wire_status` int(11) NOT NULL DEFAULT 0,
  `trans_otp` int(11) DEFAULT NULL,
  `createdAt` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `temp_trans`
--

INSERT INTO `temp_trans` (`wire_id`, `acct_id`, `trans_id`, `amount`, `bank_name`, `acct_name_id`, `acct_number`, `trans_type`, `acct_type`, `acct_country`, `acct_swift`, `acct_routing`, `acct_remarks`, `wire_status`, `trans_otp`, `createdAt`) VALUES
(1, 1, '638880508b213', 100, 'safari', 'john jons', '0016226015', 'domestic transfer', 'Non Resident', NULL, NULL, NULL, 'd', 0, 184135, '2022-12-01 11:22:08'),
(2, 1, '638880cf15d9f', 100, 'safari', 'john jons', '0016226015', 'domestic transfer', 'Non Resident', NULL, NULL, NULL, 'd', 0, 319016, '2022-12-01 11:24:15'),
(3, 2, '63889de919379', 400000, 'User User', 'User User', '1234567890', 'domestic transfer', 'Savings', NULL, NULL, NULL, 'Yeah', 0, 158544, '2022-12-01 13:28:25'),
(4, 2, '6388a4c61cb45', 100000, 'Chase bank', 'Jar', '0989966689', 'domestic transfer', 'Savings', NULL, NULL, NULL, 'Ahhh ', 0, 841119, '2022-12-01 13:57:42');

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

--
-- Table structure for table `transactions`
--

CREATE TABLE `transactions` (
  `trans_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `refrence_id` text COLLATE utf8mb3_unicode_ci NOT NULL,
  `amount` double NOT NULL,
  `trans_type` int(15) NOT NULL,
  `sender_name` text COLLATE utf8mb3_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb3_unicode_ci NOT NULL,
  `trans_status` int(11) NOT NULL DEFAULT 0,
  `created_at` text COLLATE utf8mb3_unicode_ci NOT NULL,
  `time_created` text COLLATE utf8mb3_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `transactions`
--

INSERT INTO `transactions` (`trans_id`, `user_id`, `refrence_id`, `amount`, `trans_type`, `sender_name`, `description`, `trans_status`, `created_at`, `time_created`) VALUES
(1, 1, '63887da43463a', 200, 1, 'admin', 'fees', 0, '2022-12-20', '23:04');

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

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

CREATE TABLE `users` (
  `id` int(11) NOT NULL,
  `acct_username` varchar(200) COLLATE utf8mb3_unicode_ci NOT NULL,
  `firstname` varchar(200) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `lastname` varchar(200) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `image` text COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `acct_no` varchar(50) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `billing_code` int(11) NOT NULL DEFAULT 0 COMMENT '0=deactive,1=active',
  `acct_balance` double DEFAULT 0,
  `loan_balance` double DEFAULT 0,
  `acct_limit` double DEFAULT NULL,
  `limit_remain` double DEFAULT NULL,
  `acct_type` varchar(200) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `acct_gender` text COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `marital_status` text COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `acct_currency` varchar(50) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `acct_status` varchar(50) COLLATE utf8mb3_unicode_ci DEFAULT 'active' COMMENT 'active, hold',
  `acct_email` varchar(200) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `acct_phone` varchar(20) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `acct_occupation` text COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `acct_dob` text COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `ssn` varchar(200) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `frontID` text COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `backID` text COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `country` text COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `state` text COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `acct_password` text COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `acct_pin` varchar(4) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `acct_otp` int(11) DEFAULT NULL,
  `acct_cot` varchar(15) COLLATE utf8mb3_unicode_ci NOT NULL,
  `acct_imf` varchar(15) COLLATE utf8mb3_unicode_ci NOT NULL,
  `acct_tax` varchar(15) COLLATE utf8mb3_unicode_ci NOT NULL,
  `mgr_name` text COLLATE utf8mb3_unicode_ci NOT NULL,
  `mgr_no` text COLLATE utf8mb3_unicode_ci NOT NULL,
  `mgr_email` text COLLATE utf8mb3_unicode_ci NOT NULL,
  `mgr_id` text COLLATE utf8mb3_unicode_ci NOT NULL,
  `mgr_image` text COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `acct_address` text COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `createdAt` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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

INSERT INTO `users` (`id`, `acct_username`, `firstname`, `lastname`, `image`, `acct_no`, `billing_code`, `acct_balance`, `loan_balance`, `acct_limit`, `limit_remain`, `acct_type`, `acct_gender`, `marital_status`, `acct_currency`, `acct_status`, `acct_email`, `acct_phone`, `acct_occupation`, `acct_dob`, `ssn`, `frontID`, `backID`, `country`, `state`, `acct_password`, `acct_pin`, `acct_otp`, `acct_cot`, `acct_imf`, `acct_tax`, `mgr_name`, `mgr_no`, `mgr_email`, `mgr_id`, `mgr_image`, `acct_address`, `createdAt`) VALUES
(1, 'user', 'User', 'User', '1669888519images.jpg', '1234567890', 0, 7000100, 0, NULL, -100, 'Savings', 'male', NULL, 'USD', 'active', 'brytedree@gmail.com', '12345678', 'miner', '2022-12-05', '1234567890', '1669888519images.jpg', '1669888519images.jpg', 'American Samoa', 'new york', '$2y$10$SQIwd14x9fIaaRYqbeyfcebVkXbrleGcG8bgTAGQO1lUSqKyyOkPW', '1234', 464747, '', '', '', '', '', '', '', NULL, 'wishville 34 Manchester new york 53425', '2022-12-01 10:55:19'),
(2, '', 'rita', 'dita', NULL, '9909309656', 0, 600000, 0, 500000, 100000, 'Select Account Type', 'female', 'single', 'USD', 'active', 'crypt4561@gmail.com', '19074886419', 'contractor', '1986-09-03', '5678901234', NULL, NULL, 'United States of America', 'AK', '$2y$10$Y7CFm3T41m.53Qk3XGS2JurvAN82aJ5bY9dYvIo/B3bv.zCU6xvNu', '987', 431408, '677', '67890', '0011', 'hita', '234567890', 'lat@gmail.com', '678', 'account1.png', '71 ST. NICHOLAS DRIVE', '2022-12-01 13:10:42');

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

--
-- Table structure for table `virtual`
--

CREATE TABLE `virtual` (
  `id` int(11) NOT NULL,
  `bank_name` text COLLATE utf8mb3_unicode_ci NOT NULL,
  `routine_no` text COLLATE utf8mb3_unicode_ci NOT NULL,
  `acct_no` text COLLATE utf8mb3_unicode_ci NOT NULL,
  `swift_code` text COLLATE utf8mb3_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `virtual`
--

INSERT INTO `virtual` (`id`, `bank_name`, `routine_no`, `acct_no`, `swift_code`, `created_at`) VALUES
(1, 'Usa Bank', '637363636', '764229211', 'SFDHHS86X', '2021-10-08 11:05:42');

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

--
-- Table structure for table `wire_transfer`
--

CREATE TABLE `wire_transfer` (
  `wire_id` int(11) NOT NULL,
  `acct_id` int(11) NOT NULL,
  `refrence_id` text COLLATE utf8mb3_unicode_ci NOT NULL,
  `amount` double NOT NULL DEFAULT 0,
  `bank_name` text COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `acct_name` text COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `acct_number` varchar(200) COLLATE utf8mb3_unicode_ci NOT NULL,
  `trans_type` varchar(50) COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT 'wire transfer',
  `acct_type` varchar(50) COLLATE utf8mb3_unicode_ci NOT NULL,
  `acct_country` text COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `acct_swift` varchar(50) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `acct_routing` varchar(50) COLLATE utf8mb3_unicode_ci NOT NULL,
  `acct_remarks` text COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `wire_status` int(11) NOT NULL DEFAULT 0,
  `created_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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

--
-- Table structure for table `withdrawal`
--

CREATE TABLE `withdrawal` (
  `id` int(11) NOT NULL,
  `reference_id` varchar(200) NOT NULL,
  `user_id` int(11) NOT NULL,
  `amount` float NOT NULL,
  `withdraw_method` varchar(200) NOT NULL,
  `wallet_address` text NOT NULL,
  `status` int(11) NOT NULL DEFAULT 0,
  `createdAt` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Indexes for dumped tables
--

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

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

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

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

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

--
-- Indexes for table `deposit`
--
ALTER TABLE `deposit`
  ADD PRIMARY KEY (`d_id`);

--
-- Indexes for table `domestic_transfer`
--
ALTER TABLE `domestic_transfer`
  ADD PRIMARY KEY (`dom_id`);

--
-- Indexes for table `loan`
--
ALTER TABLE `loan`
  ADD PRIMARY KEY (`loan_id`);

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

--
-- Indexes for table `temp_trans`
--
ALTER TABLE `temp_trans`
  ADD PRIMARY KEY (`wire_id`);

--
-- Indexes for table `transactions`
--
ALTER TABLE `transactions`
  ADD PRIMARY KEY (`trans_id`);

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

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

--
-- Indexes for table `wire_transfer`
--
ALTER TABLE `wire_transfer`
  ADD PRIMARY KEY (`wire_id`);

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `admin`
--
ALTER TABLE `admin`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `audit_logs`
--
ALTER TABLE `audit_logs`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `card`
--
ALTER TABLE `card`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `card_request`
--
ALTER TABLE `card_request`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `crypto_currency`
--
ALTER TABLE `crypto_currency`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=48;

--
-- AUTO_INCREMENT for table `deposit`
--
ALTER TABLE `deposit`
  MODIFY `d_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `domestic_transfer`
--
ALTER TABLE `domestic_transfer`
  MODIFY `dom_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `loan`
--
ALTER TABLE `loan`
  MODIFY `loan_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `settings`
--
ALTER TABLE `settings`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `temp_trans`
--
ALTER TABLE `temp_trans`
  MODIFY `wire_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `transactions`
--
ALTER TABLE `transactions`
  MODIFY `trans_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `virtual`
--
ALTER TABLE `virtual`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=48;

--
-- AUTO_INCREMENT for table `wire_transfer`
--
ALTER TABLE `wire_transfer`
  MODIFY `wire_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
COMMIT;

