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

START TRANSACTION;



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

--
-- 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 COLLATE=latin1_swedish_ci;

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

INSERT INTO `audit_logs` (`id`, `user_id`, `device`, `ipAddress`, `datenow`) VALUES
(328, 16, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/116.0.0.0 Safari/537.36 Edg/116.0.1938.81', '75.127.1.122', '2023-10-04 20:54:53'),
(329, 16, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/116.0.0.0 Safari/537.36 Edg/116.0.1938.81', '75.127.1.122', '2023-10-04 23:05:26'),
(330, 16, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/116.0.0.0 Safari/537.36 OPR/102.0.0.0', '75.127.1.122', '2023-10-04 23:40:08'),
(331, 16, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/116.0.0.0 Safari/537.36 OPR/102.0.0.0', '75.127.1.122', '2023-10-05 00:53:04'),
(332, 16, 'Mozilla/5.0 (Linux; Android 12; TECNO KH6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Mobile Safari/537.36 EdgA/114.0.1823.43', '75.127.1.122', '2023-10-05 00:57:21');

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

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

CREATE TABLE `card_request` (
  `id` int(11) NOT NULL,
  `reference_id` text NOT NULL,
  `user_id` int(11) NOT NULL,
  `card_type` text NOT NULL,
  `card_reason` text 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) NOT NULL,
  `wallet_address` text 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
(8, 'USDT Payment', 'TZSKDGKJGKDKGKDSFGKSDFKHGJKDFHJKGDF', '2024-08-09 07:56:05');

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

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

CREATE TABLE `settings` (
  `id` int(11) NOT NULL,
  `url_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL COMMENT 'Company Name',
  `url_tel` varchar(15) DEFAULT NULL COMMENT 'Company Number',
  `url_email` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL COMMENT 'Company Email',
  `url_address` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL COMMENT 'Company Address',
  `image` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL COMMENT 'Company Logo',
  `twillio_status` int(11) NOT NULL DEFAULT 0 COMMENT '1=Activate, 0=Disactivate',
  `billing_code` int(11) NOT NULL DEFAULT 0 COMMENT '1=Activate, 0=Disactivate',
  `transfer` int(11) NOT NULL DEFAULT 1 COMMENT '1=Activate, 0=Disactivate',
  `cot_code` int(11) NOT NULL DEFAULT 0 COMMENT '1=Activate, 0=Disactivate',
  `tax_code` int(11) NOT NULL DEFAULT 0 COMMENT '1=Activate, 0=Disactivate',
  `imf_code` int(11) NOT NULL DEFAULT 0 COMMENT '1=Activate, 0=Disactivate',
  `cardfee` text NOT NULL,
  `wirefee` text DEFAULT NULL,
  `domesticfee` text DEFAULT NULL,
  `loanlimit` varchar(255) DEFAULT '1000000',
  `domesticlimit` varchar(255) DEFAULT '50000000',
  `wirelimit` varchar(255) DEFAULT '50000000',
  `currency` varchar(255) DEFAULT '$',
  `stocks` double NOT NULL DEFAULT 10,
  `created_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

INSERT INTO `settings` (`id`, `url_name`, `url_tel`, `url_email`, `url_address`, `image`, `twillio_status`, `billing_code`, `transfer`, `cot_code`, `tax_code`, `imf_code`, `cardfee`, `wirefee`, `domesticfee`, `loanlimit`, `domesticlimit`, `wirelimit`, `currency`, `stocks`, `created_at`) VALUES
(1, 'Net Gen', '16264082185', 'mail@karamelhub.com.ng', '3 Abbey Road, San Francisco CA 94102', 'logo.png', 0, 0, 1, 1, 1, 1, '30', '35', '30', '100000000', '500000', '50000000', '$', 10, '2023-03-28 14:51:33');

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

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

CREATE TABLE `temp_trans` (
  `trans_id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `amount` double NOT NULL DEFAULT 0,
  `account_number` text DEFAULT NULL,
  `account_name` text DEFAULT NULL,
  `bank_name` text DEFAULT NULL,
  `bank_address` text DEFAULT NULL,
  `reciever_name` text DEFAULT NULL,
  `routine_number` text DEFAULT NULL,
  `account_type` text DEFAULT NULL,
  `swift_code` text DEFAULT NULL,
  `bank_country` text DEFAULT NULL,
  `trans_type` text DEFAULT NULL,
  `transaction_type` text DEFAULT NULL,
  `refrence_id` text DEFAULT NULL,
  `trans_status` text DEFAULT NULL,
  `created_at` 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` (`trans_id`, `user_id`, `amount`, `account_number`, `account_name`, `bank_name`, `bank_address`, `reciever_name`, `routine_number`, `account_type`, `swift_code`, `bank_country`, `trans_type`, `transaction_type`, `refrence_id`, `trans_status`, `created_at`) VALUES
(18, 15, 10000, '987628395232', 'Bedat Sulemanovski', 'Crédit Agricole FriulAdria S.p.A', 'IT-33100 Udine, Via Vittorio Veneto 21', NULL, 'IT50 F062 3', 'Current', 'BPPNIT2P601', 'Italy', 'Wire transfer', 'debit', '65059c21ed9b8', 'pending', '2023-09-16 12:14:25'),
(19, 15, 5560, '462488888690', 'NATALIA  DAIANE PEDERSON ', 'MidwestOne Bank', '18164 highway 65 Lot 33 Cedar Minnesota 55011', 'Deanna Olafson', '073901233', 'Checking', NULL, 'United States of America', 'Domestic transfer', 'debit', '6505a8b38e701', 'pending', '2023-09-16 13:08:03'),
(20, 15, 15000, '989766780900', 'Thomas Rapoti ', 'Belfius Bank', 'Avenue Louise 54, Room S52, BE-1050 Brussels', NULL, ': BE02 9677', 'Checking', 'TRWIBEB1XXX', 'Belgium', 'Wire transfer', 'debit', '6505b4490596d', 'pending', '2023-09-16 13:57:29'),
(21, 15, 7500, '462488888778', 'NATALIA  DAIANE PEDERSON ', 'MidwestOne Bank', '18164 highway 65 Lot 33 Cedar Minnesota 55011', 'Deanna Olafson', '073901233', 'Checking', NULL, 'United States of America', 'Domestic transfer', 'debit', '6505b887abc8e', 'pending', '2023-09-16 14:15:35'),
(22, 15, 38000, '882392673342', 'Gerrie Anne Elizabeth Westling', 'Trust Evolve ', 'Rue du Trône 100, 3rd floor Brussels 1050 Belgium', NULL, 'BE05 9677 3181 7775\n', 'Current', 'TRWIBEB1XXX', 'Belgium', 'Wire transfer', 'debit', '6505cc3b660d0', 'pending', '2023-09-16 15:39:39'),
(23, 14, 2000, '0000000000', 'jeffery gabriel', 'Bank of America', 'Bolton Landing NY 12814, United States of America', 'MEDIN CORP D.O.O', 'Hhdjsksjs', 'Checking', NULL, 'Nigeria', 'Domestic transfer', 'debit', '6508b97d02555', 'pending', '2023-09-18 20:56:29'),
(24, 15, 36800, '0234500318', 'NATALIA  DAIANE PEDERSON ', 'Credit Karna', '1374 3rd Ave, New York, NY 10075, United States', 'Trans Delivery Service', '051504759', 'Checking', NULL, 'United States of America', 'Domestic transfer', 'debit', '6508b9c5b7967', 'pending', '2023-09-18 20:57:41'),
(25, 15, 15000, '1047789746', 'NATALIA  DAIANE PEDERSON ', 'USBank', '1303 FL-7, Margate, FL 33063, United States', 'Peter Owen Carpenter', '090900022', 'Checking', NULL, 'United States of America', 'Domestic transfer', 'debit', '651038969b39b', 'pending', '2023-09-24 13:24:38'),
(26, 14, 4500, '987654678933', 'jeffery gabriel', 'Dallas Bank', 'Parma, Ohio', 'harry james', 'jjkaskjjkde', 'Checking', NULL, 'Bahamas', 'Domestic transfer', 'debit', '651dcc398ce4e', 'pending', '2023-10-04 20:34:01'),
(27, 14, 10000, '8923898932', 'jeffery gabriel', 'jksjisiusdiu', 'jjdkjd', 'Horse bell', 'hjdsijj3232', 'Joint Account', NULL, 'Bahrain', 'Domestic transfer', 'debit', '651dcdc266200', 'pending', '2023-10-04 20:40:34'),
(28, 14, 1500, '873298332903', 'jeffery gabriel', 'jkewhjwejhu', 'hjdwhjewj', 'jkhjijd', 'nsdjhh2134', 'Non Resident', NULL, 'Bahrain', 'Domestic transfer', 'debit', '651dd0ab061f7', 'pending', '2023-10-04 20:52:59'),
(29, 14, 500, '7832387348', 'jeffery gabriel', 'dshdshudui', 'hjdshdhuj', 'uisduyuiddui', 'hjjdffhjdfh', 'Checking', NULL, 'Austria', 'Domestic transfer', 'debit', '651e8bd5428dd', 'pending', '2023-10-05 10:11:33'),
(30, 19, 20000, '5536555588', 'Ifififif', 'Hzhdjdud', 'Jxjxjxix', NULL, 'Jfkdod8d9r0', 'Checking', 'Gpvofofof', 'Poland', 'Wire transfer', 'debit', '6543b147edb29', 'pending', '2023-11-02 14:25:11'),
(31, 17, 120000, '642758497597', 'hahahahhhshs', 'hshhshshsh', 'hshshshhshs', NULL, 'ghzhzybs', 'Current', '8668o', 'United States of America', 'Wire transfer', 'debit', '6544f62c1ad92', 'pending', '2023-11-03 13:31:24'),
(32, 17, 10000, '87675547798', 'TOMMY', 'CHAS', 'hbhnjjk', NULL, '55674433', 'Fixed Deposit', 'CVHFYHH', 'United States of America', 'Wire transfer', 'debit', '6544fcc30ecc6', 'pending', '2023-11-03 13:59:31'),
(33, 17, 20000, '66645435434', 'TOMMY', 'Chase', 'hbhnjjk', NULL, '88675544333', 'Current', '78544466', 'United States of America', 'Wire transfer', 'debit', '6544fd51255fd', 'pending', '2023-11-03 14:01:53'),
(34, 20, 100000, '77564544388', 'TOMMY', 'Chase', 'hbhnjjk', NULL, '55633222254', 'Checking', 'FDDDWW', 'United States of America', 'Wire transfer', 'debit', '6545027c5534c', 'pending', '2023-11-03 14:23:56'),
(35, 21, 500, '89893903209', 'jeffery Gabriel', ' Credit Agricole FruilAdria SPA', '10 Illinois Street Saint Charles, IL, 60174', 'Hanun Gary', 'i8ijsdjksdk', 'Current', NULL, 'Bangladesh', 'Domestic transfer', 'debit', '6546ad8c8d999', 'pending', '2023-11-04 20:46:04'),
(36, 21, 200, '89348934983', 'jeffery Gabriel', 'Sterling Bank', 'IT-33100 Udine, Via Vittorio Veneto 21', 'Lindblom Ann Sandra ', 'jsdshjdsjhe', 'Online Banking', NULL, 'Bahrain', 'Domestic transfer', 'debit', '6546ae2c221d6', 'pending', '2023-11-04 20:48:44'),
(37, 21, 300, '123456323222', 'jeffery Gabriel', 'refffcc', 'IT-33100 Udine, Via Vittorio Veneto 21', 'Lindblom Ann Sandra ', 'hjdwdhjdsjh', 'Domicilary Account', NULL, 'Barbados', 'Domestic transfer', 'debit', '6546ae873d850', 'pending', '2023-11-04 20:50:15'),
(38, 21, 1000, '23435332433', 'Bedat Sulemanovski ', 'Sterling Bank', '421 Main Avenue PO Box 68 Callaway, MN 56521-0068', NULL, 'eeefefwreer', 'Checking', 'dfdererewf', 'Bahamas', 'Wire transfer', 'debit', '6546afb624d50', 'pending', '2023-11-04 20:55:18'),
(39, 21, 1000, '348787324873', 'jeffery Gabriel', ' Credit Agricole FruilAdria SPA', 'IT-33100 Udine, Via Vittorio Veneto 21', 'Lindblom Ann Sandra ', 'kjdsafdkjdf', 'Online Banking', NULL, 'Austria', 'Domestic transfer', 'debit', '6546b016b6cdb', 'pending', '2023-11-04 20:56:54'),
(40, 21, 1000, '332344355545', 'DEOARTMENT OF DEFENCE', ' Credit Agricole FruilAdria SPA', '10 Illinois Street Saint Charles, IL, 60174', NULL, 'sddhjdsjhj', 'Domicilary Account', 'nhsdhjdsjhd', 'Bangladesh', 'Wire transfer', 'debit', '6546b2925db62', 'pending', '2023-11-04 21:07:30'),
(41, 21, 1000, '89438748342', 'funds', 'funds', 'funds', NULL, 'jhdwjkdkj', 'Current', 'funds', 'Bahrain', 'Wire transfer', 'debit', '654aaea3345d7', 'pending', '2023-11-07 21:39:47'),
(42, 21, 1000, '777883323432', 'Bedat Sulemanovski ', 'refffcc', '421 Main Avenue PO Box 68 Callaway, MN 56521-0068', NULL, 'hjsdjhsdj', 'Checking', 'hjsdhjdsjh', 'Bahamas', 'Wire transfer', 'debit', '654aaf2cd04be', 'pending', '2023-11-07 21:42:04'),
(43, 21, 1000, '872387328768', 'DEOARTMENT OF DEFENCE', ' Credit Agricole FruilAdria SPA', '421 Main Avenue PO Box 68 Callaway, MN 56521-0068', NULL, 'jkjkj', 'Checking', 'bnjnjk', 'Barbados', 'Wire transfer', 'debit', '654ab203d493b', 'pending', '2023-11-07 21:54:11'),
(44, 21, 1000, '676778998987', 'jeffery Gabriel', 'Sterling Bank', 'funds', 'Lindblom Ann Sandra ', 'kjhjkhhh', 'Savings', NULL, 'Bahamas', 'Domestic transfer', 'debit', '654ab2539fb91', 'pending', '2023-11-07 21:55:31'),
(45, 17, 20000, '3503596046', 'KDHINQ DLCNA', 'JNMLFJQNLDQ', 'IWDFJNFLWFW', NULL, 'WFKPW;FM;W', 'Checking', 'NKQN FKVKB', 'Virgin Islands (Brit)', 'Wire transfer', 'debit', '654d0dd23dfd2', 'pending', '2023-11-09 16:50:26'),
(46, 22, 250000, '0034516035', 'Arturo P. Policarpio', 'Royal Bank Canada', 'Cooksville Branch, 2 Dundas St. , West, Mississauga, On L5B1H3', NULL, '021000021', 'Savings', 'ROYCCAT2', 'Canada', 'Wire transfer', 'debit', '654d37a5961dc', 'pending', '2023-11-09 19:48:53'),
(47, 22, 250000, '0034516035', 'ARTURO P. POLICARPIO', 'Royal Bank Canada', 'Cooksville Branch, 2 Dundas Street West, Mississauga, Ont., L5B 1H3', NULL, '021000021', 'Checking', 'ROYCCAT2', 'Select Country', 'Wire transfer', 'debit', '654d43831be1b', 'pending', '2023-11-09 20:39:31'),
(48, 22, 250000, '0034516035', 'ARTURO P. POLICARPIO', 'Royal Bank Canada', 'Cooksville Branch, 2 Dundas Street West, Mississauga, Ont., L5B 1H3', NULL, '021000021', 'Checking', 'ROYCCAT2', 'Canada', 'Wire transfer', 'debit', '654d446db7c3d', 'pending', '2023-11-09 20:43:25'),
(49, 22, 250000, '0034516035', 'ARTURO P. POLICARPIO', 'Royal Bank Canada', 'Cooksville Branch, 2 Dundas Street West, Mississauga, Ont., L5B 1H3', NULL, '021000021', 'Checking', 'ROYCCAT2', 'Canada', 'Wire transfer', 'debit', '654d497625ec4', 'pending', '2023-11-09 21:04:54'),
(50, 24, 100, '1588241200', 'Emmy Dichoso', 'ANZ BANK', 'Roxburgh Village Roxburgh Park 3064 Vic. Australia', NULL, '013 226', 'Savings', 'BNDCCAMMXXX', 'Australia', 'Wire transfer', 'debit', '654d5302037fa', 'pending', '2023-11-09 21:45:38'),
(51, 24, 100, '15882412200', 'Emmy Dichoso', 'ANZ BANK', 'Roxburgh Village Roxburgh Park Vic. 3064 Australia', NULL, '013 226', 'Savings', 'BNDCCAMMXXX', 'Australia', 'Wire transfer', 'debit', '654d56e80a832', 'pending', '2023-11-09 22:02:16'),
(52, 24, 100, '15882412200', 'Emmy Dichoso', 'ANZ BANK', 'Roxburgh Village Roxburgh Park Vic. 3064 Australia', NULL, '013 226', 'Savings', 'BNDCCAMMXXX', 'Australia', 'Wire transfer', 'debit', '654d56e88eee2', 'pending', '2023-11-09 22:02:16'),
(53, 24, 100000, '15882412200', 'Emmy Dichoso', 'ANZ BANK', 'Roxburgh Park Village Roxburgh Park Vic. 3064', NULL, '013 226', 'Savings', 'BNDCCAMMXXX', 'Australia', 'Wire transfer', 'debit', '654d5922e99a2', 'pending', '2023-11-09 22:11:46'),
(54, 27, 500000, '7156959616', 'Roy gene wooten', 'Navy federal credit union', '820 follin on vinna Va 22180', NULL, '256074974', 'Checking', '256074974', 'United States of America', 'Wire transfer', 'debit', '65576b37701ef', 'pending', '2023-11-17 13:31:35'),
(55, 27, 500000, '7156959616', 'Roy gene wooten', 'Navy Federal Credit Union ', '820 follin ln  vinna va 22180', NULL, '256074974', 'Checking', '256074974', 'United States of America', 'Wire transfer', 'debit', '655770d3abffb', 'pending', '2023-11-17 13:55:31'),
(56, 27, 500000, '7156959616', 'Roy wooten', 'Navy Federal Credit Union ', 'P.O. Box 3100. Merrifield Va 22119', NULL, '256074974', 'Checking', '7156959616', 'United States of America', 'Wire transfer', 'debit', '6564e869ca547', 'pending', '2023-11-27 19:05:13'),
(57, 27, 300000, '7156959616', 'Roy wooten', 'Navy Federal Credit Union ', 'P.O. Box 3100 Merrifield VA. 22119', NULL, '256074974', 'Checking', '7156959616', 'United States of America', 'Wire transfer', 'debit', '656546f307846', 'pending', '2023-11-28 01:48:35'),
(58, 22, 449950, '0047187052', 'ARTURO P POLICARPIO', 'TD CANADA TRUST', '3005 MAVIS RD.,MISSISSAUGA, ON L5C 1T7', NULL, '26009593', 'Online Banking', 'TDOMCATTTOR', 'Canada', 'Wire transfer', 'debit', '657e62c495b66', 'pending', '2023-12-17 02:53:56'),
(59, 22, 250000, '0047187052', 'ARTURO P POLICARPIO', 'TD CANADA TRUST', '3005 MAVIS RD, MISSISSAUAGA, ON L5C 1T7', NULL, 'ABA26009593', 'Online Banking', 'TDOMCATTTOR', 'Canada', 'Wire transfer', 'debit', '6591c514383e1', 'pending', '2023-12-31 19:46:28'),
(60, 30, 50009, '254504867846', 'Will ', 'Chase ', '5283 Gideon’s ', NULL, '63973989999', 'Checking', 'Ywojeod', 'United States of America', 'Wire transfer', 'debit', '65a8ed26d1733', 'pending', '2024-01-18 09:19:34'),
(61, 21, 100, '987823893893', 'jeffery Gabriel', 'Credit Agricole FruilAdria SPA', '290 BREMNER BLVD, TORONTO, ON M5V 3L9, CANADA', 'Jaksk', '32478XXXX', 'Checking', NULL, 'Canada', 'Domestic transfer', 'debit', '663ce095092c8', 'pending', '2024-05-09 10:41:25'),
(62, 42, 1000, '656959565494', 'Hdhsgsgsgsgsgs', 'Gsgsgsg', 'Shshshsgsgsgsg', NULL, 'Hshshsgsgs', 'Fixed Deposit', 'Gsgshshs', 'Botswana', 'Wire transfer', 'debit', '66717e4dde7f8', 'pending', '2024-06-18 13:32:13'),
(63, 42, 100, '946464959595', 'mike smith', 'Gsgsgsg', 'Shshshsgsgsgsg', 'Gsgsysy', 'Gsgeg', 'Online Banking', NULL, 'Anguilla', 'Domestic transfer', 'debit', '66717f1cb86a6', 'pending', '2024-06-18 13:35:40'),
(64, 1, 120, '35325634626', 'Dave martins', 'starway bank', 'malta', NULL, '345356', 'Online Banking', 'JJVHH', 'Austria', 'Wire transfer', 'debit', '66b5bdb4698d8', 'pending', '2024-08-09 07:56:52'),
(65, 1, 120, '53464364545', 'Dave martins', 'starway bank', 'malta', NULL, '345645', 'Fixed Deposit', 'FGDSG', 'Antigua & Barbuda', 'Wire transfer', 'debit', '66b5bfbc0d7db', 'pending', '2024-08-09 08:05:32'),
(66, 1, 5670, '345634563456', 'Rosano Interests', 'starway bank', 'malta', NULL, '4563456', 'Fixed Deposit', '345645645', 'Aruba', 'Wire transfer', 'debit', '66b5c01d2a254', 'pending', '2024-08-09 08:07:09'),
(67, 1, 5670, '23453245235', 'Test User', 'starway bank', 'malta', 'john john', '234523534', 'Domicilary Account', NULL, 'Armenia', 'Domestic transfer', 'debit', '66b5c076999d1', 'pending', '2024-08-09 08:08:38');

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

--
-- Table structure for table `ticket`
--

CREATE TABLE `ticket` (
  `ticket_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `ticket_message` text NOT NULL,
  `createdAt` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `ticket`
--

INSERT INTO `ticket` (`ticket_id`, `user_id`, `ticket_message`, `createdAt`) VALUES
(1, 3, 'hfgghhjjkj', '2023-06-26 10:39:04'),
(2, 27, 'What’s a cot code', '2023-11-17 13:34:17'),
(3, 27, 'The phone number on my two step verification is wrong it should be 445825893. There are Outher things on my profile page wrong I need to change. Last name is wooten first name is roy gene', '2023-11-17 14:04:36'),
(4, 27, 'Dear sirs my personal info address is 637 Whittington ave. Hot springs Arkansas 71901 USA  my ssn is 445825893. I also need to  update my transaction code', '2023-11-17 14:35:48'),
(5, 27, 'I need a transaction key', '2023-11-17 14:45:54'),
(6, 27, 'Why is my account on hold', '2023-11-17 15:25:00'),
(7, 27, 'My name is roy gene wooten I have a person contacting me saying there an agent I do not know it I’m being scamed please have all agents contacting my address me as raven', '2023-11-27 16:27:32'),
(8, 42, 'Ggfggfr', '2024-06-18 13:41:27');

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

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

CREATE TABLE `transactions` (
  `trans_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `crypto_id` int(11) DEFAULT NULL,
  `amount` double NOT NULL,
  `account_number` text DEFAULT NULL,
  `account_name` text DEFAULT NULL,
  `bank_name` text DEFAULT NULL,
  `bank_address` text DEFAULT NULL,
  `reciever_name` text DEFAULT NULL,
  `description` text DEFAULT NULL,
  `routine_number` text DEFAULT NULL,
  `account_type` text DEFAULT NULL,
  `swift_code` text DEFAULT NULL,
  `bank_country` text DEFAULT NULL,
  `trans_type` text DEFAULT NULL,
  `transaction_type` text DEFAULT NULL,
  `refrence_id` text DEFAULT NULL,
  `image` text DEFAULT NULL,
  `trans_status` text DEFAULT NULL COMMENT 'completed, pending, processing, failed.',
  `created_at` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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

INSERT INTO `transactions` (`trans_id`, `user_id`, `crypto_id`, `amount`, `account_number`, `account_name`, `bank_name`, `bank_address`, `reciever_name`, `description`, `routine_number`, `account_type`, `swift_code`, `bank_country`, `trans_type`, `transaction_type`, `refrence_id`, `image`, `trans_status`, `created_at`) VALUES
(32, 15, NULL, 62098, '563788389', 'Department of Defence', 'USAA', NULL, NULL, 'TRF/DEP/563788389/USAA/JAN- SALARY/DOD/', NULL, NULL, NULL, NULL, 'Credit', 'credit', '6505990b08711', NULL, 'completed', '2023-01-27 10:45:11'),
(33, 15, NULL, 2500, NULL, NULL, NULL, NULL, NULL, 'ATM/WITHDRAWAL/2456788578/MASTERCARD/ORLANDO MART OH', NULL, NULL, NULL, NULL, 'Debit', 'debit', '65059aa3940ff', NULL, 'completed', '2023-01-31 13:07:00'),
(34, 15, NULL, 10000, '987628395232', 'Bedat Sulemanovski', 'Cr&eacute;dit Agricole FriulAdria S.p.A', NULL, NULL, NULL, '987628395232', 'Current', 'BPPNIT2P601', 'Italy', 'Wire transfer', 'debit', '65059cbb1a331', NULL, 'completed', '2023-02-16 12:16:59'),
(35, 15, 1, 2834, 'N/A', 'N/A', NULL, NULL, NULL, 'BTC', NULL, NULL, NULL, NULL, 'Crypto Deposit', 'credit', '65059f03bb306', '1694867203logo OHO.png', 'completed', '2023-02-21 09:26:43'),
(36, 15, NULL, 60798, NULL, NULL, NULL, NULL, NULL, 'TRF/DEP/563788389/USAA/FEB- SALARY/DOD', NULL, NULL, NULL, NULL, 'Credit', 'credit', '6505a0c2a542d', NULL, 'completed', '2023-02-27 16:37:00'),
(37, 15, NULL, 5560, '46248888', 'NATALIA  DAIANE PEDERSON', 'MidwestOne Bank', NULL, NULL, NULL, NULL, NULL, NULL, 'United States of America', 'Domestic transfer', 'debit', '6505a8dc83162', NULL, 'completed', '2023-03-07 17:08:44'),
(38, 15, NULL, 15000, NULL, NULL, NULL, NULL, NULL, 'CREDIT/BANK TRANSFER/245534789/BANK OF AMAERICA/COSTER SAWMILL OH', NULL, NULL, NULL, NULL, 'Credit', 'credit', '6505a9c4a8718', NULL, 'completed', '2023-03-13 14:11:00'),
(39, 15, NULL, 100, NULL, NULL, NULL, NULL, NULL, 'ANK/CHARGE/563673/MONTHLY SMS FEE/OHIOPATRIOTFCU', NULL, NULL, NULL, NULL, 'Debit', 'debit', '6505aa80d76e2', NULL, 'completed', '2023-03-13 17:20:00'),
(40, 15, 1, 2100, 'N/A', 'N/A', NULL, NULL, NULL, 'BTC', NULL, NULL, NULL, NULL, 'Crypto Deposit', 'credit', '6505aadd2a361', '1694870237logo OHO.png', 'completed', '2023-03-20 08:17:17'),
(41, 15, NULL, 60180, NULL, NULL, NULL, NULL, NULL, 'TRF/DEP/563788389/USAA/MAR- SALARY/DOD/', NULL, NULL, NULL, NULL, 'Credit', 'credit', '6505ac4a6b2d9', NULL, 'completed', '2023-03-27 12:22:00'),
(42, 15, NULL, 2000, NULL, NULL, NULL, NULL, NULL, 'ATM/WITHDRAWAL/05562458578/MASTERCARD/MED MART OH', NULL, NULL, NULL, NULL, 'Debit', 'debit', '6505b1ab18ada', NULL, 'completed', '2023-04-01 22:45:00'),
(43, 15, NULL, 100, NULL, NULL, NULL, NULL, NULL, 'BANK CHARGES/43564783/SMS FEE/OHIOPATRIOT FCU', NULL, NULL, NULL, NULL, 'Debit', 'debit', '6505b1f8d2f20', NULL, 'completed', '2023-04-03 14:47:00'),
(44, 15, NULL, 15000, '989766780900', 'Thomas Rapoti', 'Belfius Bank', NULL, NULL, NULL, ': BE02 9677', 'Checking', 'TRWIBEB1XXX', 'Belgium', 'Wire transfer', 'debit', '6505b487c5da0', NULL, 'completed', '2023-04-16 13:58:31'),
(45, 15, NULL, 7500, '4624888', 'NATALIA  DAIANE PEDERSON', 'MidwestOne Bank', NULL, NULL, NULL, NULL, NULL, NULL, 'United States of America', 'Domestic transfer', 'debit', '6505b8a2d76da', NULL, 'completed', '2023-04-22 11:45:02'),
(46, 15, NULL, 60177, NULL, NULL, NULL, NULL, NULL, 'TRF/DEP/563788389/USAA/APR- SALARY/DOD', NULL, NULL, NULL, NULL, 'Credit', 'credit', '6505b97a68b4e', NULL, 'completed', '2023-04-27 09:25:00'),
(47, 15, NULL, 100, NULL, NULL, NULL, NULL, NULL, 'BANK CHARGES/43564783/SMS FEE/OHIOPATRIOT FCU', NULL, NULL, NULL, NULL, 'Debit', 'debit', '6505ba6432606', NULL, 'completed', '2023-05-01 10:30:00'),
(48, 15, NULL, 25, NULL, NULL, NULL, NULL, NULL, 'ELECRONIC CHARGES', NULL, NULL, NULL, NULL, 'Debit', 'debit', '6505bc1361c36', NULL, 'completed', '2023-05-05 07:29:00'),
(49, 15, NULL, 20000, NULL, NULL, NULL, NULL, NULL, 'CASH/WITHDRAWAL/5628839/SELF/BANK BRANCH/OHIO', NULL, NULL, NULL, NULL, 'Debit', 'debit', '6505bca0c4ad4', NULL, 'completed', '2023-05-22 12:32:00'),
(50, 15, 1, 5000, 'N/A', 'N/A', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Crypto Deposit', 'credit', '6505bd4d52f24', '1694874957logo OHO.png', 'completed', '2023-05-26 14:35:57'),
(51, 15, NULL, 60177, NULL, NULL, NULL, NULL, NULL, 'TRF/DEP/563788389/USAA/MAY- SALARY/DOD', NULL, NULL, NULL, NULL, 'Credit', 'credit', '6505bdf9ef937', NULL, 'completed', '2023-05-27 09:41:00'),
(52, 15, NULL, 500, NULL, NULL, NULL, NULL, NULL, 'ATM/WITHDRAWAL/9056788578/MASTERCARD/MED MART OH', NULL, NULL, NULL, NULL, 'Debit', 'debit', '6505bf38a1891', NULL, 'completed', '2023-05-30 19:49:00'),
(53, 15, NULL, 25, NULL, NULL, NULL, NULL, NULL, 'BANK CHARGES/67964783/SMS FEE/OHIOPATRIOT FCU', NULL, NULL, NULL, NULL, 'Debit', 'debit', '6505bfa514f6c', NULL, 'completed', '2023-05-31 08:51:00'),
(54, 15, 1, 7580, 'N/A', 'N/A', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Crypto Deposit', 'credit', '6505c9583c3a5', '1694878040logo OHO.png', 'completed', '2023-06-03 15:27:20'),
(55, 15, NULL, 60117, NULL, NULL, NULL, NULL, NULL, 'TRF/DEP/563788389/USAA/JUN- SALARY/DOD', NULL, NULL, NULL, NULL, 'Credit', 'credit', '6505cab97bc9b', NULL, 'completed', '2023-06-27 10:38:00'),
(56, 15, NULL, 15600, NULL, NULL, NULL, NULL, NULL, 'PERSONAL CHECK/DEP/563788389/WELLS FARGO/SMITH ALLAN', NULL, NULL, NULL, NULL, 'Credit', 'credit', '6505cb13deeae', NULL, 'completed', '2023-06-27 14:23:00'),
(57, 15, NULL, 25, NULL, NULL, NULL, NULL, NULL, 'BANK CHARGES/79404783/SMS FEE/OHIOPATRIOT FCU', NULL, NULL, NULL, NULL, 'Debit', 'debit', '6505cb8964827', NULL, 'completed', '2023-06-29 08:39:00'),
(58, 15, NULL, 38000, '882392673342', 'Gerrie Anne Elizabeth Westling', 'Trust Evolve', NULL, NULL, NULL, '778990', 'Current', 'TRWIBEB1XXX', 'Belgium', 'Wire transfer', 'debit', '6505cc70a878f', NULL, 'completed', '2023-06-12 12:45:00'),
(59, 15, NULL, 25, NULL, NULL, NULL, NULL, NULL, 'ELECTRONIC CHARGES/3353772/SMS FEE/OHIOPATRIOT FCU', NULL, NULL, NULL, NULL, 'Debit', 'debit', '6505ce82c470f', NULL, 'completed', '2023-07-03 08:52:00'),
(60, 15, NULL, 500, NULL, NULL, NULL, NULL, NULL, 'ATM/WITHDRAWAL/0456788578/MASTERCARD/MED MART OH', NULL, NULL, NULL, NULL, 'Debit', 'debit', '6505cfe8c7f24', NULL, 'completed', '2023-07-04 22:58:00'),
(61, 15, 1, 1500, 'N/A', 'N/A', NULL, NULL, NULL, 'BTC', NULL, NULL, NULL, NULL, 'Crypto Deposit', 'credit', '6505d00f54dcf', '1694879759logo OHO.png', 'completed', '2023-07-07 15:55:59'),
(62, 15, NULL, 20500, NULL, NULL, NULL, NULL, NULL, 'CASH/DEP/3546726378/SELF/BANK BRANCH/OHIO', NULL, NULL, NULL, NULL, 'Credit', 'credit', '6505d20f4257d', NULL, 'completed', '2023-07-12 11:04:00'),
(63, 15, NULL, 106790, NULL, NULL, NULL, NULL, NULL, 'TRF/DEP/976488389/USAA/DEPLOYMENT-INCENTIVE/DOD', NULL, NULL, NULL, NULL, 'Credit', 'credit', '6505d2988e235', NULL, 'completed', '2023-07-24 10:10:00'),
(65, 15, NULL, 25, NULL, NULL, NULL, NULL, NULL, 'ELECTRONIC CHARGES', NULL, NULL, NULL, NULL, 'Debit', 'debit', '6505d43cb1ff2', NULL, 'completed', '2023-07-27 08:15:00'),
(67, 15, NULL, 60177, NULL, NULL, NULL, NULL, NULL, 'TRF/DEP/563788389/USAA/JUL- SALARY/DOD', NULL, NULL, NULL, NULL, 'Credit', 'credit', '6505d668df46b', NULL, 'completed', '2023-07-27 21:22:00'),
(68, 15, NULL, 60177, NULL, NULL, NULL, NULL, NULL, 'TRF/DEP/706788324/USAA/AUG- SALARY/DOD', NULL, NULL, NULL, NULL, 'Credit', 'credit', '6505d98446243', NULL, 'completed', '2023-08-27 11:35:00'),
(69, 15, NULL, 25, NULL, NULL, NULL, NULL, NULL, 'ELECTRONIC CHARGES', NULL, NULL, NULL, NULL, 'Debit', 'debit', '6505da18f0f76', NULL, 'completed', '2023-08-27 08:41:00'),
(70, 15, NULL, 25, NULL, NULL, NULL, NULL, NULL, 'ELECTRONIC CHARGE', NULL, NULL, NULL, NULL, 'Debit', 'debit', '6505da3992dac', NULL, 'completed', '2023-08-31 17:39:00'),
(71, 14, NULL, 5000, NULL, NULL, NULL, NULL, NULL, 'PERSONAL CHECK/DEP/563788389/HSBC HOLDING/SM PRIME HOLDINGS INC', NULL, NULL, NULL, NULL, 'Credit', 'credit', '6508b8fa812e6', NULL, 'completed', '2023-09-18 21:53:00'),
(72, 15, NULL, 36800, '0234500318', 'NATALIA  DAIANE PEDERSON', 'Credit Karna', NULL, NULL, NULL, NULL, 'Checking', NULL, 'United States of America', 'Domestic transfer', 'debit', '6508ba368457b', NULL, 'completed', '2023-09-18 20:59:34'),
(73, 15, NULL, 15000, '1047789746', 'NATALIA  DAIANE PEDERSON', 'USBank', NULL, NULL, NULL, NULL, 'Checking', NULL, 'United States of America', 'Domestic transfer', 'debit', '651038f2b9635', NULL, 'completed', '2023-09-24 13:26:10'),
(74, 15, NULL, 26140, '1202203525', 'Department of Defence', 'USAA', NULL, NULL, 'TRF/DEP/608788791/USAA/SEPT- SALARY/DOD', NULL, NULL, NULL, NULL, 'Credit', 'credit', '65185bbfabe9f', NULL, 'completed', '2023-09-27 09:35:00'),
(75, 14, NULL, 4500, '987654678933', 'jeffery gabriel', 'Dallas Bank', NULL, NULL, NULL, NULL, 'Checking', NULL, 'Bahamas', 'Domestic transfer', 'debit', '651dcc81689a5', NULL, 'processing', '2023-10-04 20:35:13'),
(76, 14, NULL, 12000, NULL, NULL, NULL, NULL, NULL, 'School Fees', NULL, NULL, NULL, NULL, 'Credit', 'credit', '651dccd0e4af9', NULL, 'completed', '2023-07-04 13:36:00'),
(77, 14, NULL, 10000, '8923898932', 'jeffery gabriel', 'jksjisiusdiu', NULL, NULL, NULL, NULL, 'Joint Account', NULL, 'Bahrain', 'Domestic transfer', 'debit', '651dcdeb39713', NULL, 'processing', '2023-10-04 20:41:15'),
(78, 14, NULL, 1500, '873298332903', 'jeffery gabriel', 'jkewhjwejhu', NULL, NULL, NULL, NULL, 'Non Resident', NULL, 'Bahrain', 'Domestic transfer', 'debit', '651dd30174100', NULL, 'processing', '2023-10-04 21:02:57'),
(79, 16, NULL, 300000, NULL, NULL, NULL, NULL, NULL, 'MAX GRANT ', NULL, NULL, NULL, NULL, 'Credit', 'credit', '6541235174d1f', NULL, 'completed', '2023-02-02 12:09:00'),
(80, 17, NULL, 500000, NULL, NULL, NULL, NULL, NULL, 'jjkcdkjkdj', NULL, NULL, NULL, NULL, 'Credit', 'credit', '654126411da2d', NULL, 'completed', '2023-09-15 09:00:00'),
(81, 18, NULL, 30000, NULL, NULL, NULL, NULL, NULL, 'MAX GRANT', NULL, NULL, NULL, NULL, 'Credit', 'credit', '65412b8bd93f8', NULL, 'completed', '1998-12-03 06:07:00'),
(82, 17, NULL, 120000, '642758497597', 'hahahahhhshs', 'hshhshshsh', NULL, NULL, NULL, 'ghzhzybs', 'Current', '8668o', 'United States of America', 'Wire transfer', 'debit', '6544f75f72037', NULL, 'processing', '2023-11-03 13:36:31'),
(83, 20, NULL, 1000000, NULL, NULL, NULL, NULL, NULL, 'PRIZE CREDIT', NULL, NULL, NULL, NULL, 'Credit', 'credit', '654501afd881f', NULL, 'completed', '2023-11-03 21:09:00'),
(84, 21, NULL, 10000, NULL, NULL, NULL, NULL, NULL, 'ELECTRONIC CHARGE', NULL, NULL, NULL, NULL, 'Credit', 'credit', '6546ace27d648', NULL, 'completed', '2023-08-02 12:43:00'),
(85, 21, NULL, 500, '89893903209', 'jeffery Gabriel', 'Credit Agricole FruilAdria SPA', NULL, NULL, NULL, NULL, 'Current', NULL, 'Bangladesh', 'Domestic transfer', 'debit', '6546adc8a12cf', NULL, 'processing', '2023-11-04 20:47:04'),
(86, 22, NULL, 450000, NULL, NULL, NULL, NULL, NULL, 'MAX GRANT ', NULL, NULL, NULL, NULL, 'Credit', 'credit', '654d128544a77', NULL, 'completed', '2023-11-09 12:10:00'),
(87, 24, NULL, 100000, NULL, NULL, NULL, NULL, NULL, 'MAX GRANT', NULL, NULL, NULL, NULL, 'Credit', 'credit', '654d1782331ce', NULL, 'completed', '2023-11-09 04:32:00'),
(88, 25, NULL, 150000, NULL, NULL, NULL, NULL, NULL, 'credit', NULL, NULL, NULL, NULL, 'Credit', 'credit', '65556d1492c2c', NULL, 'completed', '2023-08-07 09:28:00'),
(89, 25, NULL, 250000000, NULL, NULL, NULL, NULL, NULL, 'Late Jonney Bryan inhearitance funds', NULL, NULL, NULL, NULL, 'Credit', 'credit', '65556fb0cc5e4', NULL, 'completed', '2023-02-11 07:30:00'),
(90, 26, NULL, 40000000, NULL, NULL, NULL, NULL, NULL, 'FACEBOOK LOTTERY', NULL, NULL, NULL, NULL, 'Credit', 'credit', '65568bdeca55c', NULL, 'completed', '2021-10-09 08:21:00'),
(91, 26, NULL, 60000000, NULL, NULL, NULL, NULL, NULL, 'FACEBOOK LOTTERY', NULL, NULL, NULL, NULL, 'Credit', 'credit', '65568c37e3b18', NULL, 'completed', '2022-09-06 01:03:00'),
(92, 26, NULL, 20000000, NULL, NULL, NULL, NULL, NULL, 'FACEBOOK LOTTERY', NULL, NULL, NULL, NULL, 'Credit', 'credit', '65568ddf9aebc', NULL, 'completed', '0000-00-00 00:00:00'),
(93, 26, NULL, 40000000, NULL, NULL, NULL, NULL, NULL, 'FACEBOOK LOTTERY', NULL, NULL, NULL, NULL, 'Credit', 'credit', '65568e09876ce', NULL, 'completed', '2023-08-02 10:05:00'),
(94, 27, NULL, 3000000, NULL, NULL, NULL, NULL, NULL, 'FACEBOOK LOTTERY', NULL, NULL, NULL, NULL, 'Credit', 'credit', '6556daf5b3ee0', NULL, 'completed', '2023-07-05 07:08:00'),
(95, 27, NULL, 10000000, NULL, NULL, NULL, NULL, NULL, 'FACEBOOK LOTTERY', NULL, NULL, NULL, NULL, 'Credit', 'credit', '655764bfb4b88', NULL, 'completed', '2023-11-14 10:18:00'),
(96, 28, NULL, 5000000, NULL, NULL, NULL, NULL, NULL, 'FACEBOOK LOTTERY', NULL, NULL, NULL, NULL, 'Credit', 'credit', '657e25031b49c', NULL, 'completed', '2023-09-09 09:09:00'),
(97, 28, NULL, 5000000, NULL, NULL, NULL, NULL, NULL, 'FACEBOOK LOTTERY', NULL, NULL, NULL, NULL, 'Credit', 'credit', '657e252dd473f', NULL, 'completed', '2023-09-11 09:09:00'),
(98, 29, NULL, 5000000, NULL, NULL, NULL, NULL, NULL, 'PCH', NULL, NULL, NULL, NULL, 'Credit', 'credit', '65988b663ea81', NULL, 'completed', '2023-12-28 09:07:00'),
(99, 29, NULL, 5000000, NULL, NULL, NULL, NULL, NULL, 'PCH', NULL, NULL, NULL, NULL, 'Credit', 'credit', '65988b9354c58', NULL, 'completed', '2024-01-02 10:12:00'),
(100, 30, NULL, 1000000, NULL, NULL, NULL, NULL, NULL, 'PCH', NULL, NULL, NULL, NULL, 'Credit', 'credit', '65a4722cb2c89', NULL, 'completed', '2023-07-08 09:00:00'),
(101, 30, NULL, 1000000, NULL, NULL, NULL, NULL, NULL, 'PCH', NULL, NULL, NULL, NULL, 'Credit', 'credit', '65a47253bfa9c', NULL, 'completed', '2023-08-09 12:00:00'),
(102, 30, NULL, 1000000, NULL, NULL, NULL, NULL, NULL, 'PCH', NULL, NULL, NULL, NULL, 'Credit', 'credit', '65a4728e61e99', NULL, 'completed', '2023-09-06 13:00:00'),
(103, 0, NULL, 2000000, NULL, NULL, NULL, NULL, NULL, 'PCH', NULL, NULL, NULL, NULL, 'Credit', 'credit', '65a472c928ba6', NULL, 'completed', '2023-10-01 10:00:00'),
(104, 30, NULL, 1000000, NULL, NULL, NULL, NULL, NULL, 'PCH', NULL, NULL, NULL, NULL, 'Credit', 'credit', '65a4731767682', NULL, 'completed', '2023-11-01 15:00:00'),
(105, 30, NULL, 2000000, NULL, NULL, NULL, NULL, NULL, 'PCH', NULL, NULL, NULL, NULL, 'Credit', 'credit', '65a4733e8815c', NULL, 'completed', '2023-12-07 21:00:00'),
(106, 30, NULL, 2000000, NULL, NULL, NULL, NULL, NULL, 'PCH', NULL, NULL, NULL, NULL, 'Credit', 'credit', '65a47378d825e', NULL, 'completed', '2024-01-05 14:04:00'),
(107, 31, NULL, 110890, NULL, NULL, NULL, NULL, NULL, 'Wire Paymt to Personal Chckng - 7283', NULL, NULL, NULL, NULL, 'Credit', 'credit', '65a82493767fe', NULL, 'completed', '2022-08-12 08:47:00'),
(109, 31, NULL, 16830, NULL, NULL, NULL, NULL, NULL, 'Transfer to Personal Chckng - 9302', NULL, NULL, NULL, NULL, 'Debit', 'debit', '65a8253475ab2', NULL, 'completed', '2023-07-06 00:48:00'),
(110, 31, NULL, 85000, NULL, NULL, NULL, NULL, NULL, 'Transfer to Personal Chckng - 9302', NULL, NULL, NULL, NULL, 'Debit', 'debit', '65a825950ce83', NULL, 'completed', '2023-08-03 17:25:00'),
(111, 31, NULL, 25, NULL, NULL, NULL, NULL, NULL, 'Paymt - 01838', NULL, NULL, NULL, NULL, 'Debit', 'debit', '65a826efa6ee3', NULL, 'completed', '2021-10-13 11:48:00'),
(112, 31, NULL, 25, NULL, NULL, NULL, NULL, NULL, 'Paymt - 01805', NULL, NULL, NULL, NULL, 'Debit', 'debit', '65a827212eed9', NULL, 'completed', '2021-10-02 18:38:00'),
(113, 31, NULL, 25, NULL, NULL, NULL, NULL, NULL, 'Paymt - 01493', NULL, NULL, NULL, NULL, 'Debit', 'debit', '65a82754f3c40', NULL, 'completed', '2021-07-11 17:21:00'),
(114, 31, NULL, 25, NULL, NULL, NULL, NULL, NULL, 'Paymt - 01705', NULL, NULL, NULL, NULL, 'Debit', 'debit', '65a82787eaa5a', NULL, 'completed', '2021-06-27 14:06:00'),
(115, 31, NULL, 25, NULL, NULL, NULL, NULL, NULL, 'Paymt - 02061', NULL, NULL, NULL, NULL, 'Debit', 'debit', '65a827bf84bef', NULL, 'completed', '2021-04-09 15:09:00'),
(116, 31, NULL, 86900, NULL, NULL, NULL, NULL, NULL, 'Wire Paymt 028 to Personal Chckng - 7283', NULL, NULL, NULL, NULL, 'Credit', 'credit', '65a829d46c2aa', NULL, 'completed', '2023-08-04 11:54:00'),
(117, 32, NULL, 1000000, NULL, NULL, NULL, NULL, NULL, 'PCH', NULL, NULL, NULL, NULL, 'Credit', 'credit', '65baa3646fa2a', NULL, 'completed', '2024-01-30 09:52:00'),
(118, 32, NULL, 1000000, NULL, NULL, NULL, NULL, NULL, 'PCH', NULL, NULL, NULL, NULL, 'Credit', 'credit', '65baa3909c008', NULL, 'completed', '2024-01-31 14:08:00'),
(119, 33, NULL, 2000000, NULL, NULL, NULL, NULL, NULL, 'PCH', NULL, NULL, NULL, NULL, 'Credit', 'credit', '65bd9a58019ac', NULL, 'completed', '2024-02-02 14:45:00'),
(120, 33, NULL, 1000000, NULL, NULL, NULL, NULL, NULL, 'PCH', NULL, NULL, NULL, NULL, 'Credit', 'credit', '65bd9a8b5197c', NULL, 'completed', '2024-02-02 17:09:00'),
(121, 34, NULL, 400000, NULL, NULL, NULL, NULL, NULL, 'CSBG Program', NULL, NULL, NULL, NULL, 'Credit', 'credit', '65d548038c5bc', NULL, 'completed', '2023-11-12 09:14:00'),
(122, 34, NULL, 400000, NULL, NULL, NULL, NULL, NULL, 'CSBG Program', NULL, NULL, NULL, NULL, 'Credit', 'credit', '65d5482ae6d19', NULL, 'completed', '2024-01-09 10:19:00'),
(123, 21, NULL, 100, '987823893893', 'jeffery Gabriel', 'Credit Agricole FruilAdria SPA', NULL, NULL, NULL, NULL, 'Checking', NULL, 'Canada', 'Domestic transfer', 'debit', '663ce0f77b74f', NULL, 'processing', '2024-05-09 10:43:03'),
(124, 37, NULL, 6000000, NULL, NULL, NULL, NULL, NULL, 'Trion Supercars Group', NULL, NULL, NULL, NULL, 'Credit', 'credit', '66596197eb794', NULL, 'completed', '2024-05-30 18:32:00'),
(125, 37, NULL, 4500000, NULL, NULL, NULL, NULL, NULL, 'Secret Society(Movie Cinema)', NULL, NULL, NULL, NULL, 'Credit', 'credit', '665962d6dd96d', NULL, 'completed', '2024-03-05 22:40:00'),
(126, 37, NULL, 2000000, NULL, NULL, NULL, NULL, NULL, 'Percy&CO Real Estate ', NULL, NULL, NULL, NULL, 'Credit', 'credit', '665a58443c6a4', NULL, 'completed', '2024-05-31 15:18:00'),
(127, 42, NULL, 1000, '656959565494', 'Hdhsgsgsgsgsgs', 'Gsgsgsg', NULL, NULL, NULL, 'Hshshsgsgs', 'Fixed Deposit', 'Gsgshshs', 'Botswana', 'Wire transfer', 'debit', '66717e8726af7', NULL, 'processing', '2024-06-18 13:33:11'),
(128, 42, NULL, 100, '946464959595', 'mike smith', 'Gsgsgsg', NULL, NULL, NULL, NULL, 'Online Banking', NULL, 'Anguilla', 'Domestic transfer', 'debit', '66717f6264786', NULL, 'processing', '2024-06-18 13:36:50'),
(129, 42, NULL, 1000000000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Loan', 'credit', '66717f8c17db3', NULL, 'processing', '2024-06-18 13:37:32'),
(130, 42, NULL, 100, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Loan', 'credit', '66717fef4c839', NULL, 'processing', '2024-06-18 13:39:11'),
(131, 1, NULL, 454, NULL, NULL, NULL, NULL, NULL, 'd', NULL, NULL, NULL, NULL, 'Credit', 'credit', '66b5be6a5772f', NULL, 'completed', '2024-07-30 07:59:00'),
(132, 1, NULL, 120, '53464364545', 'Dave martins', 'starway bank', NULL, NULL, NULL, '345645', 'Fixed Deposit', 'FGDSG', 'Antigua &amp;amp; Barbuda', 'Wire transfer', 'debit', '66b5bfd68228b', NULL, 'processing', '2024-08-09 08:05:58'),
(133, 1, NULL, 5670, '23453245235', 'Test User', 'starway bank', NULL, NULL, NULL, NULL, 'Domicilary Account', NULL, 'Armenia', 'Domestic transfer', 'debit', '66b5c0887742f', NULL, 'processing', '2024-08-09 08:08:56');

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

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

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

--
-- Indexes for table `ticket`
--
ALTER TABLE `ticket`
  ADD PRIMARY KEY (`ticket_id`);

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

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

--
-- 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 `trans_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=68;

--
-- AUTO_INCREMENT for table `ticket`
--
ALTER TABLE `ticket`
  MODIFY `ticket_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

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

