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

START TRANSACTION;



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

--
-- Table structure for table `temp_selections`
--

CREATE TABLE `temp_selections` (
  `id` int NOT NULL,
  `chat_id` varchar(20) DEFAULT NULL,
  `account_number` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `amount` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `temp_selections`
--

INSERT INTO `temp_selections` (`id`, `chat_id`, `account_number`, `amount`, `phone`) VALUES
(1, '673532878', 'Vas.C037', '1', '0798939583'),
(2, '673532878', 'Vas.C037', '1', '0798939583'),
(3, '673532878', 'Vas.C037', '1', '0798939583'),
(4, '673532878', 'Vas.C037', '1', '0798938583');

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

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

CREATE TABLE `transactions` (
  `id` int NOT NULL,
  `transaction_id` varchar(255) NOT NULL,
  `amount` varchar(255) NOT NULL,
  `mpesa_code` varchar(50) DEFAULT NULL,
  `phone` varchar(14) NOT NULL,
  `transaction_status` int NOT NULL,
  `shortcode` int NOT NULL,
  `client_name` varchar(50) NOT NULL,
  `transaction_remarks` varchar(500) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_on` varchar(50) DEFAULT NULL,
  `account_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `used` int DEFAULT '0',
  `chat_id` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

INSERT INTO `transactions` (`id`, `transaction_id`, `amount`, `mpesa_code`, `phone`, `transaction_status`, `shortcode`, `client_name`, `transaction_remarks`, `created_at`, `updated_on`, `account_number`, `used`, `chat_id`) VALUES
(1, '23206-123822766-1', '1', 'RIS3YGN5X7', '254798939583', 0, 4109543, 'CROWDCOMM', 'The service request is processed successfully.', '2023-09-28 11:01:45', '2023-09-28 14:02:08', 'Vas.C037', 1, NULL),
(2, '56551-25893638-1', '10000', NULL, '254798939583', 1, 4109543, 'CROWDCOMM', 'The balance is insufficient for the transaction.', '2023-09-28 11:06:06', '2023-09-28 14:06:23', 'Vas.C037', 2, NULL),
(3, '7619-238045567-1', '1', 'RIS0YJRL4K', '254798939583', 0, 4109543, 'CROWDCOMM', 'The service request is processed successfully.', '2023-09-28 11:30:46', '2023-09-28 14:30:58', 'Vas.C037', 1, '673532878'),
(4, '25311-94421715-1', '1', 'RIS6YK26RC', '254798939583', 0, 4109543, 'CROWDCOMM', 'The service request is processed successfully.', '2023-09-28 11:33:35', '2023-09-28 14:33:48', 'Vas.C037', 1, '673532878'),
(5, '7569-45494829-1', '3', 'RIS1ZQMZ67', '254720823611', 0, 4109543, 'CROWDCOMM', 'The service request is processed successfully.', '2023-09-28 16:44:27', '2023-09-28 19:45:12', 'Vas.A224', 1, NULL),
(6, '51802-141439104-1', '2', 'RIS0ZZXGW4', '254720823611', 0, 4109543, 'CROWDCOMM', 'The service request is processed successfully.', '2023-09-28 17:45:30', '2023-09-28 20:46:04', 'Vas.A224', 1, NULL),
(7, '26299-149467221-1', '500', 'RIU158U08Z', '254722638468', 0, 4109543, 'CROWDCOMM', 'The service request is processed successfully.', '2023-09-30 06:30:58', '2023-09-30 09:31:18', 'Vas.B337', 1, NULL),
(8, '92642-109620362-1', '500', 'RIU658U616', '254790019666', 0, 4109543, 'CROWDCOMM', 'The service request is processed successfully.', '2023-09-30 06:31:16', '2023-09-30 09:31:27', 'Vas.B337', 1, NULL),
(9, '1018-12887896-1', '1', NULL, '254798938583', 1037, 4109543, 'CROWDCOMM', 'DS timeout user cannot be reached', '2023-09-30 06:47:41', '2023-09-30 09:47:43', 'Vas.C037', 0, '673532878'),
(10, '79065-145415981-1', '3000', 'RIU2627C2I', '254790019666', 0, 4109543, 'CROWDCOMM', 'The service request is processed successfully.', '2023-09-30 10:50:56', '2023-09-30 13:51:06', 'Vas.B337', 1, NULL),
(11, '29614-324849243-1', '200', 'RJ18AAKPFS', '254790019666', 0, 4109543, 'CROWDCOMM', 'The service request is processed successfully.', '2023-10-01 15:32:05', '2023-10-01 18:32:14', 'Vas.B337', 1, NULL),
(12, '55485-32269607-1', '50', 'RJ24BODCUO', '254729865071', 0, 4109543, 'CROWDCOMM', 'The service request is processed successfully.', '2023-10-02 05:55:20', '2023-10-02 08:55:27', 'Vas.B916', 1, NULL),
(13, '24722-178228123-1', '10', NULL, '254700281075', 1037, 4109543, 'CROWDCOMM', 'DS timeout user cannot be reached', '2023-10-02 09:48:26', '2023-10-02 12:48:56', 'Vas.A597', 2, NULL),
(14, '55491-32683715-1', '10', NULL, '254700281075', 1037, 4109543, 'CROWDCOMM', 'DS timeout user cannot be reached', '2023-10-02 09:49:50', '2023-10-02 12:49:52', 'Vas.A597', 2, NULL),
(15, '65410-145961711-1', '10', NULL, '254700281075', 1037, 4109543, 'CROWDCOMM', 'DS timeout user cannot be reached', '2023-10-02 09:52:29', '2023-10-02 12:52:32', 'Vas.A597', 2, NULL),
(16, '79044-150249460-1', '10', NULL, '254700281075', 1037, 4109543, 'CROWDCOMM', 'DS timeout user cannot be reached', '2023-10-02 09:55:12', '2023-10-02 12:55:45', 'Vas.A597', 2, NULL),
(17, '26319-154940091-1', '10', NULL, '254700281075', 1037, 4109543, 'CROWDCOMM', 'DS timeout user cannot be reached', '2023-10-02 09:59:26', '2023-10-02 12:59:28', 'Vas.A597', 2, NULL),
(18, '1014-18419373-1', '10', 'RJ25CFD807', '254700281075', 0, 4109543, 'CROWDCOMM', 'The service request is processed successfully.', '2023-10-02 10:10:44', '2023-10-02 13:10:57', 'Vas.A597', 1, NULL),
(19, '51805-149929497-1', '5', 'RJ26CFG1RK', '254700281075', 0, 4109543, 'CROWDCOMM', 'The service request is processed successfully.', '2023-10-02 10:11:28', '2023-10-02 13:11:38', 'Vas.A597', 1, NULL),
(20, '23204-136562389-1', '500', NULL, '254790019666', 1037, 4109543, 'CROWDCOMM', 'DS timeout user cannot be reached', '2023-10-03 13:41:00', '2023-10-03 16:41:33', 'Vas.B337', 2, NULL),
(21, '36059-250452347-1', '600', NULL, '254790019666', 1, 4109543, 'CROWDCOMM', 'The balance is insufficient for the transaction.', '2023-10-03 13:51:52', '2023-10-03 16:51:59', 'Vas.B337', 2, NULL),
(22, '36068-250454510-1', '500', NULL, '254708375000', 2001, 4109543, 'CROWDCOMM', 'The initiator information is invalid.', '2023-10-03 13:52:57', '2023-10-03 16:53:28', 'Vas.B337', 2, NULL),
(23, '24709-181821032-1', '500', NULL, '254790019666', 1032, 4109543, 'CROWDCOMM', 'Request cancelled by user', '2023-10-03 13:56:36', '2023-10-03 16:56:38', 'Vas.B337', 2, NULL),
(24, '27273-150378136-1', '500', 'RJ35GG5ZH1', '254790019666', 0, 4109543, 'CROWDCOMM', 'The service request is processed successfully.', '2023-10-03 13:58:50', '2023-10-03 16:59:01', 'Vas.B337', 1, NULL),
(25, '26641-120626270-1', '5000', 'RJ77T29ZFH', '254723868630', 0, 4109543, 'CROWDCOMM', 'The service request is processed successfully.', '2023-10-07 08:46:17', '2023-10-07 11:46:33', 'Vas.C171', 1, NULL),
(26, '7624-262167387-1', '5', 'RJ84WZK3W2', '254798939583', 0, 4109543, 'CROWDCOMM', 'The service request is processed successfully.', '2023-10-08 11:56:39', '2023-10-08 14:57:03', 'Vas.B337', 1, NULL),
(27, '7565-71779313-1', '1500', 'RJ91ZLN3X1', '254790019666', 0, 4109543, 'CROWDCOMM', 'The service request is processed successfully.', '2023-10-09 08:49:25', '2023-10-09 11:49:35', 'Vas.B337', 1, NULL),
(28, '36059-267987255-1', '2000', 'RJA35SN7MX', '254790019666', 0, 4109543, 'CROWDCOMM', 'The service request is processed successfully.', '2023-10-10 18:01:36', '2023-10-10 21:01:49', 'Vas.B337', 1, NULL),
(29, '23222-155604868-1', '500', NULL, '254700281075', 1037, 4109543, 'CROWDCOMM', 'DS timeout user cannot be reached', '2023-10-11 03:52:14', '2023-10-11 06:52:47', 'Vas.A597', 2, NULL),
(30, '29615-349716813-1', '500', 'RJB36E31BX', '254700281075', 0, 4109543, 'CROWDCOMM', 'The service request is processed successfully.', '2023-10-11 04:58:42', '2023-10-11 07:58:52', 'Vas.A597', 1, NULL),
(31, '29611-353153339-1', '500', 'RJC5ANVX2L', '254700281075', 0, 4109543, 'CROWDCOMM', 'The service request is processed successfully.', '2023-10-12 11:12:06', '2023-10-12 14:12:14', 'Vas.A597', 1, NULL),
(32, '56535-65148676-1', '5000', NULL, '254722301981', 1, 4109543, 'CROWDCOMM', NULL, '2023-10-14 05:13:41', NULL, 'Vas.C178', 0, NULL),
(33, '54924-30036805-1', '1000', 'RJK5ZHR1WD', '254729865071', 0, 4109543, 'CROWDCOMM', 'The service request is processed successfully.', '2023-10-20 07:13:13', '2023-10-20 10:13:22', 'Vas.B916', 1, NULL),
(34, '20489-40866945-1', '10', 'RJO3D7P0NP', '254725752873', 0, 4109543, 'CROWDCOMM', 'The service request is processed successfully.', '2023-10-24 08:46:56', '2023-10-24 11:47:07', 'Vas.A224', 1, NULL),
(35, '29591-388392351-1', '10', NULL, '254703157632', 1032, 4109543, 'CROWDCOMM', 'Request cancelled by user', '2023-10-25 07:38:08', '2023-10-25 10:38:26', 'Vas.A224', 2, NULL),
(36, '22586-60334086-1', '800', 'RJP4I2GB8Y', '254729865071', 0, 4109543, 'CROWDCOMM', 'The service request is processed successfully.', '2023-10-25 16:38:15', '2023-10-25 19:38:24', 'Vas.B916', 1, NULL),
(37, '106702-2315185-1', '1000', 'RK217FILIR', '254729865071', 0, 4109543, 'CROWDCOMM', 'The service request is processed successfully.', '2023-11-02 08:20:14', '2023-11-02 11:20:21', 'Vas.B916', 1, NULL),
(38, '43601-11328821-1', '5000', 'RK38BIJA3M', '254722638468', 0, 4109543, 'CROWDCOMM', 'The service request is processed successfully.', '2023-11-03 12:29:55', '2023-11-03 15:30:04', 'Vas.B337', 1, NULL),
(39, '78752-72630830-1', '6000', 'RK32C90SJ4', '254717447946', 0, 4109543, 'CROWDCOMM', 'The service request is processed successfully.', '2023-11-03 15:39:16', '2023-11-03 18:39:38', 'Vas.A725', 1, NULL),
(40, '103325-73497838-1', '100', 'RK30D2SBXI', '254717447946', 0, 4109543, 'CROWDCOMM', 'The service request is processed successfully.', '2023-11-03 19:22:22', '2023-11-03 22:22:38', 'Vas.A725', 1, NULL),
(41, '113834-80625918-1', '10', 'RK62LE3RDE', '254798939583', 0, 4109543, 'CROWDCOMM', 'The service request is processed successfully.', '2023-11-06 13:12:44', '2023-11-06 16:12:58', 'Vas.A725', 1, NULL),
(42, '75057-12162448-1', '100', 'RK66LGFI92', '254717447946', 0, 4109543, 'CROWDCOMM', 'The service request is processed successfully.', '2023-11-06 13:32:10', '2023-11-06 16:32:33', 'Vas.A725', 1, NULL),
(43, '19449-3914918-1', '800', NULL, '254724022841', 1037, 4109543, 'CROWDCOMM', 'DS timeout user cannot be reached', '2023-11-06 13:46:17', '2023-11-06 16:46:48', 'Vas.A151', 2, NULL),
(44, '17186-6773461-1', '800', NULL, '254724022841', 1, 4109543, 'CROWDCOMM', 'The balance is insufficient for the transaction.', '2023-11-06 13:54:35', '2023-11-06 16:54:57', 'Vas.A151', 2, NULL),
(45, '4807-11855962-1', '700', 'RK60LK0I38', '254724022841', 0, 4109543, 'CROWDCOMM', 'The service request is processed successfully.', '2023-11-06 14:00:54', '2023-11-06 17:01:12', 'Vas.A151', 1, NULL),
(46, '94503-340445024-1', '5000', 'RK70NUY7RE', '254722638468', 0, 4109543, 'CROWDCOMM', 'The service request is processed successfully.', '2023-11-07 09:03:12', '2023-11-07 12:03:20', 'Vas.B337', 1, NULL),
(47, '84307-13945222-1', '10', NULL, '254798939583', 1037, 4109543, 'CROWDCOMM', 'DS timeout user cannot be reached', '2023-11-09 09:24:54', '2023-11-09 12:25:25', 'Vas.A725', 2, NULL),
(48, '93951-22258904-1', '5000', 'RKA7XHO5IZ', '254722638468', 0, 4109543, 'CROWDCOMM', 'The service request is processed successfully.', '2023-11-10 08:39:17', '2023-11-10 11:39:25', 'Vas.B337', 1, NULL),
(49, '31765-4050789-1', '5000', 'RKE6C0FLV2', '254722638468', 0, 4109543, 'CROWDCOMM', 'The service request is processed successfully.', '2023-11-14 13:27:12', '2023-11-14 16:27:23', 'Vas.B337', 1, NULL),
(50, '8674-3351998-1', '1000', 'RKG5ITBW5F', '254729865071', 0, 4109543, 'CROWDCOMM', 'The service request is processed successfully.', '2023-11-16 15:12:58', '2023-11-16 18:13:09', 'Vas.B916', 1, NULL),
(51, '38707-112069061-1', '5000', 'RKH9KJCY4P', '254722638468', 0, 4109543, 'CROWDCOMM', 'The service request is processed successfully.', '2023-11-17 07:18:02', '2023-11-17 10:18:11', 'Vas.B337', 1, NULL),
(52, '12616-16403360-1', '10000', 'RKL5ZIH07N', '254717447946', 0, 4109543, 'CROWDCOMM', 'The service request is processed successfully.', '2023-11-21 18:40:11', '2023-11-21 21:40:21', 'Vas.A725', 1, NULL),
(53, '89456-2401245-1', '67000', 'RKL4ZJONNK', '254717447946', 0, 4109543, 'CROWDCOMM', 'The service request is processed successfully.', '2023-11-21 18:53:24', '2023-11-21 21:53:34', 'Vas.A725', 1, NULL),
(54, '98188-119107811-1', '500', 'RKM211TE1G', '254717447946', 0, 4109543, 'CROWDCOMM', 'The service request is processed successfully.', '2023-11-22 05:30:32', '2023-11-22 08:30:40', 'Vas.A725', 1, NULL),
(55, '8673-40534182-1', '5000', 'RKS8KDO844', '254722638468', 0, 4109543, 'CROWDCOMM', 'The service request is processed successfully.', '2023-11-28 06:24:36', '2023-11-28 09:24:45', 'Vas.B337', 1, NULL),
(56, '79815-67694923-1', '1000', NULL, '254729865071', 1037, 4109543, 'CROWDCOMM', 'DS timeout user cannot be reached', '2023-11-28 17:47:48', '2023-11-28 20:48:05', 'Vas.B916', 2, NULL),
(57, '18141-144422820-1', '1000', NULL, '254729865071', 1037, 4109543, 'CROWDCOMM', 'DS timeout user cannot be reached', '2023-11-28 17:48:16', '2023-11-28 20:48:48', 'Vas.B916', 2, NULL),
(58, '18137-144425785-1', '1000', NULL, '254729865071', 1037, 4109543, 'CROWDCOMM', 'DS timeout user cannot be reached', '2023-11-28 17:48:56', '2023-11-28 20:48:59', 'Vas.B916', 2, NULL),
(59, '93950-77958413-1', '1000', NULL, '254729865071', 2001, 4109543, 'CROWDCOMM', 'The initiator information is invalid.', '2023-11-28 17:50:16', '2023-11-28 20:50:28', 'Vas.B916', 2, NULL),
(60, '7865-5573544-1', '200', 'RKT4PZ1JAY', '254700281075', 0, 4109543, 'CROWDCOMM', 'The service request is processed successfully.', '2023-11-29 17:05:24', '2023-11-29 20:05:42', 'Vas.A597', 1, NULL),
(61, '42463-86554857-1', '200', NULL, '254700281075', 1032, 4109543, 'CROWDCOMM', 'Request cancelled by user', '2023-11-30 12:42:06', '2023-11-30 15:42:24', 'Vas.A597', 2, NULL),
(62, '42450-86557082-1', '200', 'RKU7S9BJUF', '254700281075', 0, 4109543, 'CROWDCOMM', 'The service request is processed successfully.', '2023-11-30 12:42:46', '2023-11-30 15:42:55', 'Vas.A597', 1, NULL);

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

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

--
-- AUTO_INCREMENT for table `temp_selections`
--
ALTER TABLE `temp_selections`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `transactions`
--
ALTER TABLE `transactions`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=63;
COMMIT;

