Gecko [ tradesense.co.ke ]

Name	Size	Permission
PNG	[ DIR ]	drwxr-xr-x
assets	[ DIR ]	drwxr-xr-x
idback	[ DIR ]	drwxr-xr-x
idfront	[ DIR ]	drwxr-xr-x
profile	[ DIR ]	drwxr-xr-x
reports	[ DIR ]	drwxr-xr-x
sss	[ DIR ]	drwxr-xr-x
.DS_Store	14 KB	-rw-r--r--
.htaccess	1.63 KB	-rw-r--r--
10215.png	118.93 KB	-rw-r--r--
14.54.58.jpeg	326.88 KB	-rw-r--r--
1521018822076.jpeg	15.38 KB	-rw-r--r--
190054.png	126.5 KB	-rw-r--r--
1_2zm-i1LzLyNfh62Vi1RZTg.png	8.96 KB	-rw-r--r--
324077386_1857199847994256_868...	142.08 KB	-rw-r--r--
324565333_486815220312486_6953...	99.56 KB	-rw-r--r--
4.jpg	191.04 KB	-rw-r--r--
90031f33-7f30-42e0-a235-f2ffc2...	50.12 KB	-rw-r--r--
AMANA CAPITAL.png	158.43 KB	-rw-r--r--
Capture.PNG	154.3 KB	-rw-r--r--
ICON _DEPOSIT-fotor-bg-remover...	31.92 KB	-rw-r--r--
ICON _WEALTH MANAGEMENT FUND-f...	52.5 KB	-rw-r--r--
ICON_WEALTHMANAGEMENT-removebg...	38.88 KB	-rw-r--r--
ICON_WEALTHMANAGEMENT-removebg...	38.88 KB	-rw-r--r--
Icon-01.jpg	293.89 KB	-rw-r--r--
Master Calendar (8).png	11.83 KB	-rw-r--r--
Mpesastkresponse.json	0 B	-rw-r--r--
Pesa-Link.jpg	16.56 KB	-rw-r--r--
PesaLink-Logo.png	16.28 KB	-rw-r--r--
REINVEST-fotor-bg-remover-2023...	56.72 KB	-rw-r--r--
WRTI-Sci-Conference-poster-min...	401.63 KB	-rw-r--r--
WhatsApp Image 2023-04-28 at 1...	62.4 KB	-rw-r--r--
_WITHDRAW-fotor-bg-remover-202...	36.21 KB	-rw-r--r--
__manifest.json	1.59 KB	-rw-r--r--
__service-worker.js	1.42 KB	-rw-r--r--
_public_reports_monthly_report...	3.7 KB	-rw-r--r--
_public_reports_monthly_report...	4.25 KB	-rw-r--r--
_public_reports_monthly_report...	7.45 KB	-rw-r--r--
_public_reports_monthly_report...	7.29 KB	-rw-r--r--
_public_reports_monthly_report...	7.45 KB	-rw-r--r--
_public_reports_monthly_report...	7.46 KB	-rw-r--r--
_public_reports_monthly_report...	7.5 KB	-rw-r--r--
_public_reports_monthly_report...	8.16 KB	-rw-r--r--
_public_reports_monthly_report...	8.16 KB	-rw-r--r--
_public_reports_monthly_report...	7.33 KB	-rw-r--r--
_public_reports_monthly_report...	7.28 KB	-rw-r--r--
_public_reports_monthly_report...	7.29 KB	-rw-r--r--
_public_reports_monthly_report...	7.43 KB	-rw-r--r--
a5c25a36-2b41-42d8-81a8-74c124...	343.17 KB	-rw-r--r--
abstract-dark-blurred-backgrou...	79.22 KB	-rw-r--r--
abstract-luxury-gradient-blue-...	137.62 KB	-rw-r--r--
abstract-luxury-gradient-blue-...	186.79 KB	-rw-r--r--
airtel.png	3.73 KB	-rw-r--r--
background.jpg	239.9 KB	-rw-r--r--
backgroundtwo.jpg	49.02 KB	-rw-r--r--
bc.jpg	218.54 KB	-rw-r--r--
blurred-abstract-background.jp...	2.61 MB	-rw-r--r--
char.png	158.43 KB	-rw-r--r--
charlo.png	62.06 KB	-rw-r--r--
depositwhite.png	154.25 KB	-rw-r--r--
dissatisfied-woman-holds-achin...	130.5 KB	-rw-r--r--
divider.PNG	195 B	-rw-r--r--
download.png	3.76 KB	-rw-r--r--
extreme-close-up-bent-paper-cu...	26.83 KB	-rw-r--r--
ezgif-1-fd635c4810.jpg	21.77 KB	-rw-r--r--
ezgif-2-e3eae81fca.jpg	49.36 KB	-rw-r--r--
ezgif-5-845c98b732.jpg	5.44 KB	-rw-r--r--
ezgif-5-c26837a87e.webp	7.28 KB	-rw-r--r--
fav.png	109.77 KB	-rw-r--r--
favicon.ico	5.3 KB	-rw-r--r--
fund1.jpeg	326.88 KB	-rw-r--r--
fund2.jpeg	157.35 KB	-rw-r--r--
fund3.jpeg	347.45 KB	-rw-r--r--
gh1nr1v9hrb2qrbfqobi.jpg	3.54 KB	-rw-r--r--
gradient_1.webp	7.28 KB	-rw-r--r--
icons8-bell-64.png	1.09 KB	-rw-r--r--
icons8-chart-24.png	349 B	-rw-r--r--
icons8-funds-66.png	1.68 KB	-rw-r--r--
icons8-graph-16.png	356 B	-rw-r--r--
icons8-home-50.png	464 B	-rw-r--r--
icons8-logout-100.png	1.55 KB	-rw-r--r--
icons8-logout-64.png	606 B	-rw-r--r--
icons8-secure-transacti.png	1.27 KB	-rw-r--r--
icons8-secure-transactions-64....	1.31 KB	-rw-r--r--
icons8-smartphone-64.png	613 B	-rw-r--r--
icons8-transaction-64.png	1.51 KB	-rw-r--r--
icons8-user-64.png	1001 B	-rw-r--r--
ihfnlpbze7o01.webp	9.61 KB	-rw-r--r--
index.php	2.15 KB	-rw-r--r--
inter.png	2.3 KB	-rw-r--r--
ipay_transactions.sql	1.74 KB	-rw-r--r--
loading-icon.png	7.98 KB	-rw-r--r--
logo.png	158.43 KB	-rw-r--r--
moneymarket-fotor-bg-remover-2...	42.12 KB	-rw-r--r--
moneymarket-removebg-preview.p...	31.05 KB	-rw-r--r--
mpesa.png	2.93 KB	-rw-r--r--
pension-fotor-bg-remover-20230...	49.4 KB	-rw-r--r--
pension-removebg-preview.png	40.06 KB	-rw-r--r--
purple-calendar-clock-icon-3d-...	6.08 MB	-rw-r--r--
reinvestwhite.png	226.14 KB	-rw-r--r--
robots.txt	25 B	-rw-r--r--
rtgs.png	2.11 KB	-rw-r--r--
rtgs2023-10-055.xlsx	6.25 KB	-rw-r--r--
side-view-depressed-woman-indo...	112.32 KB	-rw-r--r--
sss.zip	375.41 KB	-rw-r--r--
tradeapp.sql	104.07 KB	-rw-r--r--
vecteezy_abstract-green-and-bl...	102.33 KB	-rw-r--r--
vecteezy_abstract-green-and-bl...	102.33 KB	-rw-r--r--
white.png	200.39 KB	-rw-r--r--
withdrawwhite.png	105.14 KB	-rw-r--r--

Code Editor : tradeapp.sql

-- phpMyAdmin SQL Dump
-- version 5.2.0
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: May 27, 2023 at 02:18 AM
-- Server version: 10.4.27-MariaDB
-- PHP Version: 8.0.25

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `tradeapp`
--

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

--
-- Table structure for table `dailyinterest`
--

CREATE TABLE `dailyinterest` (
  `id` int(11) NOT NULL,
  `userid` varchar(512) DEFAULT NULL,
  `dailyinterest` varchar(255) DEFAULT NULL,
  `cuurrentdate` varchar(512) DEFAULT NULL,
  `currentinvestment` varchar(512) DEFAULT NULL,
  `transactionId` varchar(512) DEFAULT NULL,
  `expectedmaturity` varchar(512) DEFAULT NULL,
  `enrolmentday` varchar(512) DEFAULT NULL,
  `fundid` varchar(512) DEFAULT NULL,
  `datecreated` timestamp NULL DEFAULT NULL,
  `update_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `dailyinterest`
--

INSERT INTO `dailyinterest` (`id`, `userid`, `dailyinterest`, `cuurrentdate`, `currentinvestment`, `transactionId`, `expectedmaturity`, `enrolmentday`, `fundid`, `datecreated`, `update_at`) VALUES
(119, '13', '0.067367', '2023-05-10', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:17:58', '2023-05-23 11:17:58'),
(120, '13', '0.067367', '2023-05-11', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:17:58', '2023-05-23 11:17:58'),
(121, '13', '0.067367', '2023-05-12', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:17:58', '2023-05-23 11:17:58'),
(122, '13', '0.067367', '2023-05-13', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:17:58', '2023-05-23 11:17:58'),
(123, '13', '0.067367', '2023-05-14', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:17:58', '2023-05-23 11:17:58'),
(124, '13', '0.067367', '2023-05-15', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:17:58', '2023-05-23 11:17:58'),
(125, '13', '0.067367', '2023-05-16', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:17:58', '2023-05-23 11:17:58'),
(126, '13', '0.067367', '2023-05-17', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:17:58', '2023-05-23 11:17:58'),
(127, '13', '0.067367', '2023-05-18', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:17:58', '2023-05-23 11:17:58'),
(128, '13', '0.067367', '2023-05-19', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:17:58', '2023-05-23 11:17:58'),
(129, '13', '0.067367', '2023-05-20', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:17:58', '2023-05-23 11:17:58'),
(130, '13', '0.067367', '2023-05-21', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:17:58', '2023-05-23 11:17:58'),
(131, '13', '0.067367', '2023-05-22', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:17:58', '2023-05-23 11:17:58'),
(132, '13', '0.067367', '2023-05-10', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:18:30', '2023-05-23 11:18:30'),
(133, '13', '0.067367', '2023-05-11', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:18:30', '2023-05-23 11:18:30'),
(134, '13', '0.067367', '2023-05-12', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:18:30', '2023-05-23 11:18:30'),
(135, '13', '0.067367', '2023-05-13', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:18:30', '2023-05-23 11:18:30'),
(136, '13', '0.067367', '2023-05-14', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:18:30', '2023-05-23 11:18:30'),
(137, '13', '0.067367', '2023-05-15', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:18:30', '2023-05-23 11:18:30'),
(138, '13', '0.067367', '2023-05-16', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:18:30', '2023-05-23 11:18:30'),
(139, '13', '0.067367', '2023-05-17', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:18:30', '2023-05-23 11:18:30'),
(140, '13', '0.067367', '2023-05-18', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:18:30', '2023-05-23 11:18:30'),
(141, '13', '0.067367', '2023-05-19', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:18:30', '2023-05-23 11:18:30'),
(142, '13', '0.067367', '2023-05-20', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:18:30', '2023-05-23 11:18:30'),
(143, '13', '0.067367', '2023-05-21', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:18:30', '2023-05-23 11:18:30'),
(144, '13', '0.067367', '2023-05-22', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:18:30', '2023-05-23 11:18:30'),
(145, '13', '0.067367', '2023-05-10', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:18:41', '2023-05-23 11:18:41'),
(146, '13', '0.067367', '2023-05-11', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:18:41', '2023-05-23 11:18:41'),
(147, '13', '0.067367', '2023-05-12', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:18:41', '2023-05-23 11:18:41'),
(148, '13', '0.067367', '2023-05-13', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:18:41', '2023-05-23 11:18:41'),
(149, '13', '0.067367', '2023-05-14', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:18:41', '2023-05-23 11:18:41'),
(150, '13', '0.067367', '2023-05-15', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:18:41', '2023-05-23 11:18:41'),
(151, '13', '0.067367', '2023-05-16', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:18:41', '2023-05-23 11:18:41'),
(152, '13', '0.067367', '2023-05-17', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:18:41', '2023-05-23 11:18:41'),
(153, '13', '0.067367', '2023-05-18', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:18:41', '2023-05-23 11:18:41'),
(154, '13', '0.067367', '2023-05-19', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:18:41', '2023-05-23 11:18:41'),
(155, '13', '0.067367', '2023-05-20', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:18:41', '2023-05-23 11:18:41'),
(156, '13', '0.067367', '2023-05-21', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:18:41', '2023-05-23 11:18:41'),
(157, '13', '0.067367', '2023-05-22', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:18:41', '2023-05-23 11:18:41'),
(158, '13', '0.067367', '2023-05-10', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:21:38', '2023-05-23 11:21:38'),
(159, '13', '0.067367', '2023-05-11', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:21:38', '2023-05-23 11:21:38'),
(160, '13', '0.067367', '2023-05-12', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:21:38', '2023-05-23 11:21:38'),
(161, '13', '0.067367', '2023-05-13', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:21:38', '2023-05-23 11:21:38'),
(162, '13', '0.067367', '2023-05-14', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:21:38', '2023-05-23 11:21:38'),
(163, '13', '0.067367', '2023-05-15', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:21:38', '2023-05-23 11:21:38'),
(164, '13', '0.067367', '2023-05-16', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:21:38', '2023-05-23 11:21:38'),
(165, '13', '0.067367', '2023-05-17', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:21:38', '2023-05-23 11:21:38'),
(166, '13', '0.067367', '2023-05-18', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:21:38', '2023-05-23 11:21:38'),
(167, '13', '0.067367', '2023-05-19', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:21:38', '2023-05-23 11:21:38'),
(168, '13', '0.067367', '2023-05-20', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:21:38', '2023-05-23 11:21:38'),
(169, '13', '0.067367', '2023-05-21', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:21:38', '2023-05-23 11:21:38'),
(170, '13', '0.067367', '2023-05-22', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:21:38', '2023-05-23 11:21:38'),
(171, '13', '0.067367', '2023-05-10', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:38:03', '2023-05-23 11:38:03'),
(172, '13', '0.067367', '2023-05-11', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:38:03', '2023-05-23 11:38:03'),
(173, '13', '0.067367', '2023-05-12', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:38:03', '2023-05-23 11:38:03'),
(174, '13', '0.067367', '2023-05-13', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:38:03', '2023-05-23 11:38:03'),
(175, '13', '0.067367', '2023-05-14', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:38:03', '2023-05-23 11:38:03'),
(176, '13', '0.067367', '2023-05-15', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:38:03', '2023-05-23 11:38:03'),
(177, '13', '0.067367', '2023-05-16', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:38:03', '2023-05-23 11:38:03'),
(178, '13', '0.067367', '2023-05-17', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:38:03', '2023-05-23 11:38:03'),
(179, '13', '0.067367', '2023-05-18', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:38:03', '2023-05-23 11:38:03'),
(180, '13', '0.067367', '2023-05-19', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:38:03', '2023-05-23 11:38:03'),
(181, '13', '0.067367', '2023-05-20', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:38:03', '2023-05-23 11:38:03'),
(182, '13', '0.067367', '2023-05-21', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:38:03', '2023-05-23 11:38:03'),
(183, '13', '0.067367', '2023-05-22', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:38:03', '2023-05-23 11:38:03'),
(184, '13', '0.067367', '2023-05-10', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:38:53', '2023-05-23 11:38:53'),
(185, '13', '0.067367', '2023-05-11', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:38:53', '2023-05-23 11:38:53'),
(186, '13', '0.067367', '2023-05-12', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:38:53', '2023-05-23 11:38:53'),
(187, '13', '0.067367', '2023-05-13', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:38:53', '2023-05-23 11:38:53'),
(188, '13', '0.067367', '2023-05-14', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:38:53', '2023-05-23 11:38:53'),
(189, '13', '0.067367', '2023-05-15', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:38:53', '2023-05-23 11:38:53'),
(190, '13', '0.067367', '2023-05-16', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:38:53', '2023-05-23 11:38:53'),
(191, '13', '0.067367', '2023-05-17', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:38:53', '2023-05-23 11:38:53'),
(192, '13', '0.067367', '2023-05-18', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:38:53', '2023-05-23 11:38:53'),
(193, '13', '0.067367', '2023-05-19', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:38:53', '2023-05-23 11:38:53'),
(194, '13', '0.067367', '2023-05-20', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:38:53', '2023-05-23 11:38:53'),
(195, '13', '0.067367', '2023-05-21', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:38:53', '2023-05-23 11:38:53'),
(196, '13', '0.067367', '2023-05-22', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:38:53', '2023-05-23 11:38:53'),
(197, '13', '0.067367', '2023-05-10', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:38:57', '2023-05-23 11:38:57'),
(198, '13', '0.067367', '2023-05-11', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:38:57', '2023-05-23 11:38:57'),
(199, '13', '0.067367', '2023-05-12', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:38:57', '2023-05-23 11:38:57'),
(200, '13', '0.067367', '2023-05-13', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:38:57', '2023-05-23 11:38:57'),
(201, '13', '0.067367', '2023-05-14', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:38:57', '2023-05-23 11:38:57'),
(202, '13', '0.067367', '2023-05-15', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:38:57', '2023-05-23 11:38:57'),
(203, '13', '0.067367', '2023-05-16', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:38:57', '2023-05-23 11:38:57'),
(204, '13', '0.067367', '2023-05-17', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:38:57', '2023-05-23 11:38:57'),
(205, '13', '0.067367', '2023-05-18', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:38:57', '2023-05-23 11:38:57'),
(206, '13', '0.067367', '2023-05-19', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:38:57', '2023-05-23 11:38:57'),
(207, '13', '0.067367', '2023-05-20', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:38:57', '2023-05-23 11:38:57'),
(208, '13', '0.067367', '2023-05-21', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:38:57', '2023-05-23 11:38:57'),
(209, '13', '0.067367', '2023-05-22', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:38:57', '2023-05-23 11:38:57'),
(210, '13', '0.067367', '2023-05-10', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:41:28', '2023-05-23 11:41:28'),
(211, '13', '0.067367', '2023-05-11', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:41:28', '2023-05-23 11:41:28'),
(212, '13', '0.067367', '2023-05-12', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:41:28', '2023-05-23 11:41:28'),
(213, '13', '0.067367', '2023-05-13', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:41:28', '2023-05-23 11:41:28'),
(214, '13', '0.067367', '2023-05-14', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:41:28', '2023-05-23 11:41:28'),
(215, '13', '0.067367', '2023-05-15', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:41:28', '2023-05-23 11:41:28'),
(216, '13', '0.067367', '2023-05-16', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:41:28', '2023-05-23 11:41:28'),
(217, '13', '0.067367', '2023-05-17', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:41:28', '2023-05-23 11:41:28'),
(218, '13', '0.067367', '2023-05-18', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:41:28', '2023-05-23 11:41:28'),
(219, '13', '0.067367', '2023-05-19', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:41:28', '2023-05-23 11:41:28'),
(220, '13', '0.067367', '2023-05-20', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:41:28', '2023-05-23 11:41:28'),
(221, '13', '0.067367', '2023-05-21', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:41:28', '2023-05-23 11:41:28'),
(222, '13', '0.067367', '2023-05-22', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:41:28', '2023-05-23 11:41:28'),
(223, '13', '0.067367', '2023-05-10', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:42:28', '2023-05-23 11:42:28'),
(224, '13', '0.067367', '2023-05-11', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:42:28', '2023-05-23 11:42:28'),
(225, '13', '0.067367', '2023-05-12', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:42:28', '2023-05-23 11:42:28'),
(226, '13', '0.067367', '2023-05-13', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:42:28', '2023-05-23 11:42:28'),
(227, '13', '0.067367', '2023-05-14', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:42:28', '2023-05-23 11:42:28'),
(228, '13', '0.067367', '2023-05-15', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:42:28', '2023-05-23 11:42:28'),
(229, '13', '0.067367', '2023-05-16', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:42:28', '2023-05-23 11:42:28'),
(230, '13', '0.067367', '2023-05-17', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:42:28', '2023-05-23 11:42:28'),
(231, '13', '0.067367', '2023-05-18', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:42:28', '2023-05-23 11:42:28'),
(232, '13', '0.067367', '2023-05-19', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:42:28', '2023-05-23 11:42:28'),
(233, '13', '0.067367', '2023-05-20', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:42:28', '2023-05-23 11:42:28'),
(234, '13', '0.067367', '2023-05-21', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:42:28', '2023-05-23 11:42:28'),
(235, '13', '0.067367', '2023-05-22', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 11:42:28', '2023-05-23 11:42:28'),
(236, '13', '0.067367', '2023-05-10', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 20:08:06', '2023-05-23 20:08:06'),
(237, '13', '0.067367', '2023-05-11', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 20:08:06', '2023-05-23 20:08:06'),
(238, '13', '0.067367', '2023-05-12', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 20:08:06', '2023-05-23 20:08:06'),
(239, '13', '0.067367', '2023-05-13', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 20:08:06', '2023-05-23 20:08:06'),
(240, '13', '0.067367', '2023-05-14', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 20:08:06', '2023-05-23 20:08:06'),
(241, '13', '0.067367', '2023-05-15', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 20:08:06', '2023-05-23 20:08:06'),
(242, '13', '0.067367', '2023-05-16', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 20:08:06', '2023-05-23 20:08:06'),
(243, '13', '0.067367', '2023-05-17', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 20:08:06', '2023-05-23 20:08:06'),
(244, '13', '0.067367', '2023-05-18', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 20:08:06', '2023-05-23 20:08:06'),
(245, '13', '0.067367', '2023-05-19', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 20:08:06', '2023-05-23 20:08:06'),
(246, '13', '0.067367', '2023-05-20', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 20:08:06', '2023-05-23 20:08:06'),
(247, '13', '0.067367', '2023-05-21', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 20:08:06', '2023-05-23 20:08:06'),
(248, '13', '0.067367', '2023-05-22', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-23 20:08:06', '2023-05-23 20:08:06'),
(249, '13', '0.067367', '2023-05-10', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 01:44:45', '2023-05-26 01:44:45'),
(250, '13', '0.067367', '2023-05-11', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 01:44:45', '2023-05-26 01:44:45'),
(251, '13', '0.067367', '2023-05-12', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 01:44:45', '2023-05-26 01:44:45'),
(252, '13', '0.067367', '2023-05-13', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 01:44:45', '2023-05-26 01:44:45'),
(253, '13', '0.067367', '2023-05-14', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 01:44:45', '2023-05-26 01:44:45'),
(254, '13', '0.067367', '2023-05-15', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 01:44:45', '2023-05-26 01:44:45'),
(255, '13', '0.067367', '2023-05-16', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 01:44:45', '2023-05-26 01:44:45'),
(256, '13', '0.067367', '2023-05-17', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 01:44:45', '2023-05-26 01:44:45'),
(257, '13', '0.067367', '2023-05-18', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 01:44:45', '2023-05-26 01:44:45'),
(258, '13', '0.067367', '2023-05-19', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 01:44:45', '2023-05-26 01:44:45'),
(259, '13', '0.067367', '2023-05-20', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 01:44:45', '2023-05-26 01:44:45'),
(260, '13', '0.067367', '2023-05-21', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 01:44:45', '2023-05-26 01:44:45'),
(261, '13', '0.067367', '2023-05-22', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 01:44:45', '2023-05-26 01:44:45'),
(262, '13', '0.067367', '2023-05-23', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 01:44:45', '2023-05-26 01:44:45'),
(263, '13', '0.067367', '2023-05-24', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 01:44:45', '2023-05-26 01:44:45'),
(264, '13', '0.067367', '2023-05-25', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 01:44:45', '2023-05-26 01:44:45'),
(265, '13', '0.067367', '2023-05-10', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 11:49:07', '2023-05-26 11:49:07'),
(266, '13', '0.067367', '2023-05-11', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 11:49:07', '2023-05-26 11:49:07'),
(267, '13', '0.067367', '2023-05-12', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 11:49:07', '2023-05-26 11:49:07'),
(268, '13', '0.067367', '2023-05-13', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 11:49:07', '2023-05-26 11:49:07'),
(269, '13', '0.067367', '2023-05-14', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 11:49:07', '2023-05-26 11:49:07'),
(270, '13', '0.067367', '2023-05-15', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 11:49:07', '2023-05-26 11:49:07'),
(271, '13', '0.067367', '2023-05-16', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 11:49:07', '2023-05-26 11:49:07'),
(272, '13', '0.067367', '2023-05-17', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 11:49:07', '2023-05-26 11:49:07'),
(273, '13', '0.067367', '2023-05-18', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 11:49:07', '2023-05-26 11:49:07'),
(274, '13', '0.067367', '2023-05-19', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 11:49:07', '2023-05-26 11:49:07'),
(275, '13', '0.067367', '2023-05-20', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 11:49:07', '2023-05-26 11:49:07'),
(276, '13', '0.067367', '2023-05-21', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 11:49:07', '2023-05-26 11:49:07'),
(277, '13', '0.067367', '2023-05-22', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 11:49:07', '2023-05-26 11:49:07'),
(278, '13', '0.067367', '2023-05-23', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 11:49:07', '2023-05-26 11:49:07'),
(279, '13', '0.067367', '2023-05-24', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 11:49:07', '2023-05-26 11:49:07'),
(280, '13', '0.067367', '2023-05-25', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 11:49:07', '2023-05-26 11:49:07'),
(281, '13', '0.067367', '2023-05-10', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:12:20', '2023-05-26 12:12:20'),
(282, '13', '0.067367', '2023-05-11', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:12:20', '2023-05-26 12:12:20'),
(283, '13', '0.067367', '2023-05-12', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:12:20', '2023-05-26 12:12:20'),
(284, '13', '0.067367', '2023-05-13', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:12:20', '2023-05-26 12:12:20'),
(285, '13', '0.067367', '2023-05-14', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:12:20', '2023-05-26 12:12:20'),
(286, '13', '0.067367', '2023-05-15', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:12:20', '2023-05-26 12:12:20'),
(287, '13', '0.067367', '2023-05-16', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:12:20', '2023-05-26 12:12:20'),
(288, '13', '0.067367', '2023-05-17', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:12:20', '2023-05-26 12:12:20'),
(289, '13', '0.067367', '2023-05-18', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:12:20', '2023-05-26 12:12:20'),
(290, '13', '0.067367', '2023-05-19', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:12:20', '2023-05-26 12:12:20'),
(291, '13', '0.067367', '2023-05-20', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:12:20', '2023-05-26 12:12:20'),
(292, '13', '0.067367', '2023-05-21', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:12:20', '2023-05-26 12:12:20'),
(293, '13', '0.067367', '2023-05-22', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:12:20', '2023-05-26 12:12:20'),
(294, '13', '0.067367', '2023-05-23', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:12:20', '2023-05-26 12:12:20'),
(295, '13', '0.067367', '2023-05-24', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:12:20', '2023-05-26 12:12:20'),
(296, '13', '0.067367', '2023-05-25', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:12:20', '2023-05-26 12:12:20'),
(297, '13', '0.067367', '2023-05-10', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:17:39', '2023-05-26 12:17:39'),
(298, '13', '0.067367', '2023-05-11', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:17:39', '2023-05-26 12:17:39'),
(299, '13', '0.067367', '2023-05-12', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:17:39', '2023-05-26 12:17:39'),
(300, '13', '0.067367', '2023-05-13', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:17:39', '2023-05-26 12:17:39'),
(301, '13', '0.067367', '2023-05-14', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:17:39', '2023-05-26 12:17:39'),
(302, '13', '0.067367', '2023-05-15', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:17:39', '2023-05-26 12:17:39'),
(303, '13', '0.067367', '2023-05-16', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:17:39', '2023-05-26 12:17:39'),
(304, '13', '0.067367', '2023-05-17', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:17:39', '2023-05-26 12:17:39'),
(305, '13', '0.067367', '2023-05-18', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:17:39', '2023-05-26 12:17:39'),
(306, '13', '0.067367', '2023-05-19', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:17:39', '2023-05-26 12:17:39'),
(307, '13', '0.067367', '2023-05-20', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:17:39', '2023-05-26 12:17:39'),
(308, '13', '0.067367', '2023-05-21', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:17:39', '2023-05-26 12:17:39'),
(309, '13', '0.067367', '2023-05-22', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:17:39', '2023-05-26 12:17:39'),
(310, '13', '0.067367', '2023-05-23', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:17:39', '2023-05-26 12:17:39'),
(311, '13', '0.067367', '2023-05-24', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:17:39', '2023-05-26 12:17:39'),
(312, '13', '0.067367', '2023-05-25', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:17:39', '2023-05-26 12:17:39'),
(313, '13', '0.067367', '2023-05-10', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:23:52', '2023-05-26 12:23:52'),
(314, '13', '0.067367', '2023-05-11', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:23:52', '2023-05-26 12:23:52'),
(315, '13', '0.067367', '2023-05-12', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:23:52', '2023-05-26 12:23:52'),
(316, '13', '0.067367', '2023-05-13', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:23:52', '2023-05-26 12:23:52'),
(317, '13', '0.067367', '2023-05-14', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:23:52', '2023-05-26 12:23:52'),
(318, '13', '0.067367', '2023-05-15', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:23:52', '2023-05-26 12:23:52'),
(319, '13', '0.067367', '2023-05-16', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:23:52', '2023-05-26 12:23:52'),
(320, '13', '0.067367', '2023-05-17', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:23:52', '2023-05-26 12:23:52'),
(321, '13', '0.067367', '2023-05-18', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:23:52', '2023-05-26 12:23:52'),
(322, '13', '0.067367', '2023-05-19', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:23:52', '2023-05-26 12:23:52'),
(323, '13', '0.067367', '2023-05-20', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:23:52', '2023-05-26 12:23:52'),
(324, '13', '0.067367', '2023-05-21', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:23:52', '2023-05-26 12:23:52'),
(325, '13', '0.067367', '2023-05-22', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:23:52', '2023-05-26 12:23:52'),
(326, '13', '0.067367', '2023-05-23', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:23:52', '2023-05-26 12:23:52'),
(327, '13', '0.067367', '2023-05-24', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:23:52', '2023-05-26 12:23:52'),
(328, '13', '0.067367', '2023-05-25', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:23:52', '2023-05-26 12:23:52'),
(329, '13', '0.067367', '2023-05-10', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:27:01', '2023-05-26 12:27:01'),
(330, '13', '0.067367', '2023-05-11', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:27:01', '2023-05-26 12:27:01'),
(331, '13', '0.067367', '2023-05-12', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:27:01', '2023-05-26 12:27:01'),
(332, '13', '0.067367', '2023-05-13', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:27:01', '2023-05-26 12:27:01'),
(333, '13', '0.067367', '2023-05-14', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:27:01', '2023-05-26 12:27:01'),
(334, '13', '0.067367', '2023-05-15', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:27:01', '2023-05-26 12:27:01'),
(335, '13', '0.067367', '2023-05-16', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:27:01', '2023-05-26 12:27:01'),
(336, '13', '0.067367', '2023-05-17', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:27:01', '2023-05-26 12:27:01'),
(337, '13', '0.067367', '2023-05-18', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:27:01', '2023-05-26 12:27:01'),
(338, '13', '0.067367', '2023-05-19', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:27:01', '2023-05-26 12:27:01'),
(339, '13', '0.067367', '2023-05-20', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:27:01', '2023-05-26 12:27:01'),
(340, '13', '0.067367', '2023-05-21', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:27:01', '2023-05-26 12:27:01'),
(341, '13', '0.067367', '2023-05-22', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:27:01', '2023-05-26 12:27:01'),
(342, '13', '0.067367', '2023-05-23', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:27:01', '2023-05-26 12:27:01'),
(343, '13', '0.067367', '2023-05-24', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:27:01', '2023-05-26 12:27:01'),
(344, '13', '0.067367', '2023-05-25', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:27:01', '2023-05-26 12:27:01'),
(345, '13', '0.067367', '2023-05-10', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:27:34', '2023-05-26 12:27:34'),
(346, '13', '0.067367', '2023-05-11', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:27:34', '2023-05-26 12:27:34'),
(347, '13', '0.067367', '2023-05-12', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:27:34', '2023-05-26 12:27:34'),
(348, '13', '0.067367', '2023-05-13', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:27:34', '2023-05-26 12:27:34'),
(349, '13', '0.067367', '2023-05-14', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:27:34', '2023-05-26 12:27:34'),
(350, '13', '0.067367', '2023-05-15', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:27:34', '2023-05-26 12:27:34'),
(351, '13', '0.067367', '2023-05-16', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:27:34', '2023-05-26 12:27:34'),
(352, '13', '0.067367', '2023-05-17', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:27:34', '2023-05-26 12:27:34'),
(353, '13', '0.067367', '2023-05-18', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:27:34', '2023-05-26 12:27:34'),
(354, '13', '0.067367', '2023-05-19', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:27:34', '2023-05-26 12:27:34'),
(355, '13', '0.067367', '2023-05-20', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:27:34', '2023-05-26 12:27:34'),
(356, '13', '0.067367', '2023-05-21', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:27:35', '2023-05-26 12:27:35'),
(357, '13', '0.067367', '2023-05-22', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:27:35', '2023-05-26 12:27:35'),
(358, '13', '0.067367', '2023-05-23', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:27:35', '2023-05-26 12:27:35'),
(359, '13', '0.067367', '2023-05-24', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:27:35', '2023-05-26 12:27:35'),
(360, '13', '0.067367', '2023-05-25', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:27:35', '2023-05-26 12:27:35'),
(361, '13', '0.067367', '2023-05-10', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:57:38', '2023-05-26 12:57:38'),
(362, '13', '0.067367', '2023-05-11', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:57:38', '2023-05-26 12:57:38'),
(363, '13', '0.067367', '2023-05-12', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:57:38', '2023-05-26 12:57:38'),
(364, '13', '0.067367', '2023-05-13', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:57:38', '2023-05-26 12:57:38'),
(365, '13', '0.067367', '2023-05-14', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:57:38', '2023-05-26 12:57:38'),
(366, '13', '0.067367', '2023-05-15', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:57:38', '2023-05-26 12:57:38'),
(367, '13', '0.067367', '2023-05-16', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:57:38', '2023-05-26 12:57:38'),
(368, '13', '0.067367', '2023-05-17', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:57:38', '2023-05-26 12:57:38'),
(369, '13', '0.067367', '2023-05-18', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:57:38', '2023-05-26 12:57:38'),
(370, '13', '0.067367', '2023-05-19', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:57:38', '2023-05-26 12:57:38'),
(371, '13', '0.067367', '2023-05-20', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:57:38', '2023-05-26 12:57:38'),
(372, '13', '0.067367', '2023-05-21', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:57:38', '2023-05-26 12:57:38'),
(373, '13', '0.067367', '2023-05-22', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:57:38', '2023-05-26 12:57:38'),
(374, '13', '0.067367', '2023-05-23', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:57:38', '2023-05-26 12:57:38'),
(375, '13', '0.067367', '2023-05-24', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:57:38', '2023-05-26 12:57:38'),
(376, '13', '0.067367', '2023-05-25', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:57:38', '2023-05-26 12:57:38'),
(377, '13', '0.067367', '2023-05-10', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:57:45', '2023-05-26 12:57:45'),
(378, '13', '0.067367', '2023-05-11', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:57:45', '2023-05-26 12:57:45'),
(379, '13', '0.067367', '2023-05-12', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:57:45', '2023-05-26 12:57:45'),
(380, '13', '0.067367', '2023-05-13', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:57:45', '2023-05-26 12:57:45'),
(381, '13', '0.067367', '2023-05-14', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:57:45', '2023-05-26 12:57:45'),
(382, '13', '0.067367', '2023-05-15', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:57:45', '2023-05-26 12:57:45'),
(383, '13', '0.067367', '2023-05-16', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:57:45', '2023-05-26 12:57:45'),
(384, '13', '0.067367', '2023-05-17', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:57:45', '2023-05-26 12:57:45'),
(385, '13', '0.067367', '2023-05-18', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:57:45', '2023-05-26 12:57:45'),
(386, '13', '0.067367', '2023-05-19', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:57:45', '2023-05-26 12:57:45'),
(387, '13', '0.067367', '2023-05-20', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:57:45', '2023-05-26 12:57:45'),
(388, '13', '0.067367', '2023-05-21', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:57:45', '2023-05-26 12:57:45'),
(389, '13', '0.067367', '2023-05-22', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:57:45', '2023-05-26 12:57:45'),
(390, '13', '0.067367', '2023-05-23', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:57:45', '2023-05-26 12:57:45'),
(391, '13', '0.067367', '2023-05-24', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:57:45', '2023-05-26 12:57:45'),
(392, '13', '0.067367', '2023-05-25', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:57:45', '2023-05-26 12:57:45'),
(393, '13', '0.067367', '2023-05-10', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:58:01', '2023-05-26 12:58:01'),
(394, '13', '0.067367', '2023-05-11', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:58:01', '2023-05-26 12:58:01'),
(395, '13', '0.067367', '2023-05-12', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:58:01', '2023-05-26 12:58:01'),
(396, '13', '0.067367', '2023-05-13', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:58:01', '2023-05-26 12:58:01'),
(397, '13', '0.067367', '2023-05-14', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:58:01', '2023-05-26 12:58:01'),
(398, '13', '0.067367', '2023-05-15', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:58:01', '2023-05-26 12:58:01'),
(399, '13', '0.067367', '2023-05-16', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:58:01', '2023-05-26 12:58:01'),
(400, '13', '0.067367', '2023-05-17', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:58:01', '2023-05-26 12:58:01'),
(401, '13', '0.067367', '2023-05-18', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:58:01', '2023-05-26 12:58:01'),
(402, '13', '0.067367', '2023-05-19', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:58:01', '2023-05-26 12:58:01'),
(403, '13', '0.067367', '2023-05-20', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:58:01', '2023-05-26 12:58:01'),
(404, '13', '0.067367', '2023-05-21', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:58:01', '2023-05-26 12:58:01'),
(405, '13', '0.067367', '2023-05-22', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:58:01', '2023-05-26 12:58:01'),
(406, '13', '0.067367', '2023-05-23', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:58:01', '2023-05-26 12:58:01'),
(407, '13', '0.067367', '2023-05-24', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:58:01', '2023-05-26 12:58:01'),
(408, '13', '0.067367', '2023-05-25', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 12:58:01', '2023-05-26 12:58:01'),
(409, '13', '0.067367', '2023-05-10', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 13:14:09', '2023-05-26 13:14:09'),
(410, '13', '0.067367', '2023-05-11', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 13:14:09', '2023-05-26 13:14:09'),
(411, '13', '0.067367', '2023-05-12', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 13:14:09', '2023-05-26 13:14:09'),
(412, '13', '0.067367', '2023-05-13', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 13:14:09', '2023-05-26 13:14:09'),
(413, '13', '0.067367', '2023-05-14', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 13:14:09', '2023-05-26 13:14:09'),
(414, '13', '0.067367', '2023-05-15', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 13:14:09', '2023-05-26 13:14:09'),
(415, '13', '0.067367', '2023-05-16', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 13:14:09', '2023-05-26 13:14:09'),
(416, '13', '0.067367', '2023-05-17', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 13:14:09', '2023-05-26 13:14:09'),
(417, '13', '0.067367', '2023-05-18', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 13:14:09', '2023-05-26 13:14:09'),
(418, '13', '0.067367', '2023-05-19', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 13:14:09', '2023-05-26 13:14:09'),
(419, '13', '0.067367', '2023-05-20', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 13:14:09', '2023-05-26 13:14:09'),
(420, '13', '0.067367', '2023-05-21', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 13:14:09', '2023-05-26 13:14:09'),
(421, '13', '0.067367', '2023-05-22', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 13:14:09', '2023-05-26 13:14:09'),
(422, '13', '0.067367', '2023-05-23', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 13:14:09', '2023-05-26 13:14:09'),
(423, '13', '0.067367', '2023-05-24', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 13:14:09', '2023-05-26 13:14:09'),
(424, '13', '0.067367', '2023-05-25', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 13:14:09', '2023-05-26 13:14:09'),
(425, '13', '0.067367', '2023-05-10', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 13:16:30', '2023-05-26 13:16:30'),
(426, '13', '0.067367', '2023-05-11', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 13:16:30', '2023-05-26 13:16:30'),
(427, '13', '0.067367', '2023-05-12', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 13:16:30', '2023-05-26 13:16:30'),
(428, '13', '0.067367', '2023-05-13', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 13:16:30', '2023-05-26 13:16:30'),
(429, '13', '0.067367', '2023-05-14', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 13:16:30', '2023-05-26 13:16:30'),
(430, '13', '0.067367', '2023-05-15', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 13:16:30', '2023-05-26 13:16:30'),
(431, '13', '0.067367', '2023-05-16', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 13:16:30', '2023-05-26 13:16:30'),
(432, '13', '0.067367', '2023-05-17', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 13:16:30', '2023-05-26 13:16:30'),
(433, '13', '0.067367', '2023-05-18', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 13:16:30', '2023-05-26 13:16:30'),
(434, '13', '0.067367', '2023-05-19', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 13:16:30', '2023-05-26 13:16:30'),
(435, '13', '0.067367', '2023-05-20', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 13:16:30', '2023-05-26 13:16:30'),
(436, '13', '0.067367', '2023-05-21', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 13:16:30', '2023-05-26 13:16:30'),
(437, '13', '0.067367', '2023-05-22', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 13:16:30', '2023-05-26 13:16:30'),
(438, '13', '0.067367', '2023-05-23', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 13:16:30', '2023-05-26 13:16:30'),
(439, '13', '0.067367', '2023-05-24', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 13:16:30', '2023-05-26 13:16:30'),
(440, '13', '0.067367', '2023-05-25', '101', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 13:16:30', '2023-05-26 13:16:30'),
(441, '13', '0.068034', '2023-05-10', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 13:34:31', '2023-05-26 13:34:31'),
(442, '13', '0.068034', '2023-05-11', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 13:34:31', '2023-05-26 13:34:31'),
(443, '13', '0.068034', '2023-05-12', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 13:34:31', '2023-05-26 13:34:31'),
(444, '13', '0.068034', '2023-05-13', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 13:34:31', '2023-05-26 13:34:31'),
(445, '13', '0.068034', '2023-05-14', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 13:34:31', '2023-05-26 13:34:31'),
(446, '13', '0.068034', '2023-05-15', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 13:34:31', '2023-05-26 13:34:31'),
(447, '13', '0.068034', '2023-05-16', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 13:34:31', '2023-05-26 13:34:31'),
(448, '13', '0.068034', '2023-05-17', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 13:34:31', '2023-05-26 13:34:31'),
(449, '13', '0.068034', '2023-05-18', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 13:34:31', '2023-05-26 13:34:31'),
(450, '13', '0.068034', '2023-05-19', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 13:34:31', '2023-05-26 13:34:31'),
(451, '13', '0.068034', '2023-05-20', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 13:34:31', '2023-05-26 13:34:31'),
(452, '13', '0.068034', '2023-05-21', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 13:34:31', '2023-05-26 13:34:31'),
(453, '13', '0.068034', '2023-05-22', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 13:34:31', '2023-05-26 13:34:31'),
(454, '13', '0.068034', '2023-05-23', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 13:34:31', '2023-05-26 13:34:31'),
(455, '13', '0.068034', '2023-05-24', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 13:34:31', '2023-05-26 13:34:31'),
(456, '13', '0.068034', '2023-05-25', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 13:34:31', '2023-05-26 13:34:31'),
(457, '13', '0.068034', '2023-05-10', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:05:08', '2023-05-26 14:05:08'),
(458, '13', '0.068034', '2023-05-11', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:05:08', '2023-05-26 14:05:08'),
(459, '13', '0.068034', '2023-05-12', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:05:08', '2023-05-26 14:05:08'),
(460, '13', '0.068034', '2023-05-13', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:05:08', '2023-05-26 14:05:08'),
(461, '13', '0.068034', '2023-05-14', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:05:08', '2023-05-26 14:05:08'),
(462, '13', '0.068034', '2023-05-15', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:05:08', '2023-05-26 14:05:08'),
(463, '13', '0.068034', '2023-05-16', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:05:08', '2023-05-26 14:05:08'),
(464, '13', '0.068034', '2023-05-17', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:05:08', '2023-05-26 14:05:08'),
(465, '13', '0.068034', '2023-05-18', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:05:08', '2023-05-26 14:05:08'),
(466, '13', '0.068034', '2023-05-19', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:05:08', '2023-05-26 14:05:08'),
(467, '13', '0.068034', '2023-05-20', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:05:08', '2023-05-26 14:05:08'),
(468, '13', '0.068034', '2023-05-21', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:05:08', '2023-05-26 14:05:08'),
(469, '13', '0.068034', '2023-05-22', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:05:08', '2023-05-26 14:05:08'),
(470, '13', '0.068034', '2023-05-23', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:05:08', '2023-05-26 14:05:08'),
(471, '13', '0.068034', '2023-05-24', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:05:08', '2023-05-26 14:05:08'),
(472, '13', '0.068034', '2023-05-25', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:05:08', '2023-05-26 14:05:08'),
(473, '13', '0.068034', '2023-05-10', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:05:36', '2023-05-26 14:05:36'),
(474, '13', '0.068034', '2023-05-11', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:05:36', '2023-05-26 14:05:36'),
(475, '13', '0.068034', '2023-05-12', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:05:36', '2023-05-26 14:05:36'),
(476, '13', '0.068034', '2023-05-13', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:05:36', '2023-05-26 14:05:36'),
(477, '13', '0.068034', '2023-05-14', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:05:36', '2023-05-26 14:05:36'),
(478, '13', '0.068034', '2023-05-15', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:05:36', '2023-05-26 14:05:36'),
(479, '13', '0.068034', '2023-05-16', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:05:36', '2023-05-26 14:05:36'),
(480, '13', '0.068034', '2023-05-17', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:05:36', '2023-05-26 14:05:36'),
(481, '13', '0.068034', '2023-05-18', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:05:36', '2023-05-26 14:05:36'),
(482, '13', '0.068034', '2023-05-19', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:05:36', '2023-05-26 14:05:36'),
(483, '13', '0.068034', '2023-05-20', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:05:36', '2023-05-26 14:05:36'),
(484, '13', '0.068034', '2023-05-21', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:05:36', '2023-05-26 14:05:36'),
(485, '13', '0.068034', '2023-05-22', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:05:36', '2023-05-26 14:05:36'),
(486, '13', '0.068034', '2023-05-23', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:05:36', '2023-05-26 14:05:36'),
(487, '13', '0.068034', '2023-05-24', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:05:36', '2023-05-26 14:05:36'),
(488, '13', '0.068034', '2023-05-25', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:05:36', '2023-05-26 14:05:36'),
(489, '13', '0.068034', '2023-05-10', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:06:25', '2023-05-26 14:06:25'),
(490, '13', '0.068034', '2023-05-11', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:06:25', '2023-05-26 14:06:25'),
(491, '13', '0.068034', '2023-05-12', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:06:25', '2023-05-26 14:06:25'),
(492, '13', '0.068034', '2023-05-13', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:06:25', '2023-05-26 14:06:25'),
(493, '13', '0.068034', '2023-05-14', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:06:25', '2023-05-26 14:06:25'),
(494, '13', '0.068034', '2023-05-15', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:06:25', '2023-05-26 14:06:25'),
(495, '13', '0.068034', '2023-05-16', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:06:25', '2023-05-26 14:06:25'),
(496, '13', '0.068034', '2023-05-17', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:06:25', '2023-05-26 14:06:25'),
(497, '13', '0.068034', '2023-05-18', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:06:25', '2023-05-26 14:06:25'),
(498, '13', '0.068034', '2023-05-19', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:06:25', '2023-05-26 14:06:25'),
(499, '13', '0.068034', '2023-05-20', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:06:25', '2023-05-26 14:06:25'),
(500, '13', '0.068034', '2023-05-21', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:06:25', '2023-05-26 14:06:25'),
(501, '13', '0.068034', '2023-05-22', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:06:25', '2023-05-26 14:06:25'),
(502, '13', '0.068034', '2023-05-23', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:06:25', '2023-05-26 14:06:25'),
(503, '13', '0.068034', '2023-05-24', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:06:25', '2023-05-26 14:06:25'),
(504, '13', '0.068034', '2023-05-25', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:06:25', '2023-05-26 14:06:25');
INSERT INTO `dailyinterest` (`id`, `userid`, `dailyinterest`, `cuurrentdate`, `currentinvestment`, `transactionId`, `expectedmaturity`, `enrolmentday`, `fundid`, `datecreated`, `update_at`) VALUES
(505, '13', '0.068034', '2023-05-10', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:07:11', '2023-05-26 14:07:11'),
(506, '13', '0.068034', '2023-05-11', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:07:11', '2023-05-26 14:07:11'),
(507, '13', '0.068034', '2023-05-12', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:07:11', '2023-05-26 14:07:11'),
(508, '13', '0.068034', '2023-05-13', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:07:11', '2023-05-26 14:07:11'),
(509, '13', '0.068034', '2023-05-14', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:07:11', '2023-05-26 14:07:11'),
(510, '13', '0.068034', '2023-05-15', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:07:11', '2023-05-26 14:07:11'),
(511, '13', '0.068034', '2023-05-16', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:07:11', '2023-05-26 14:07:11'),
(512, '13', '0.068034', '2023-05-17', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:07:11', '2023-05-26 14:07:11'),
(513, '13', '0.068034', '2023-05-18', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:07:11', '2023-05-26 14:07:11'),
(514, '13', '0.068034', '2023-05-19', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:07:11', '2023-05-26 14:07:11'),
(515, '13', '0.068034', '2023-05-20', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:07:11', '2023-05-26 14:07:11'),
(516, '13', '0.068034', '2023-05-21', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:07:11', '2023-05-26 14:07:11'),
(517, '13', '0.068034', '2023-05-22', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:07:11', '2023-05-26 14:07:11'),
(518, '13', '0.068034', '2023-05-23', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:07:11', '2023-05-26 14:07:11'),
(519, '13', '0.068034', '2023-05-24', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:07:11', '2023-05-26 14:07:11'),
(520, '13', '0.068034', '2023-05-25', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:07:11', '2023-05-26 14:07:11'),
(521, '13', '0.068034', '2023-05-10', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:07:54', '2023-05-26 14:07:54'),
(522, '13', '0.068034', '2023-05-11', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:07:54', '2023-05-26 14:07:54'),
(523, '13', '0.068034', '2023-05-12', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:07:54', '2023-05-26 14:07:54'),
(524, '13', '0.068034', '2023-05-13', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:07:54', '2023-05-26 14:07:54'),
(525, '13', '0.068034', '2023-05-14', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:07:54', '2023-05-26 14:07:54'),
(526, '13', '0.068034', '2023-05-15', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:07:54', '2023-05-26 14:07:54'),
(527, '13', '0.068034', '2023-05-16', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:07:54', '2023-05-26 14:07:54'),
(528, '13', '0.068034', '2023-05-17', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:07:54', '2023-05-26 14:07:54'),
(529, '13', '0.068034', '2023-05-18', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:07:54', '2023-05-26 14:07:54'),
(530, '13', '0.068034', '2023-05-19', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:07:54', '2023-05-26 14:07:54'),
(531, '13', '0.068034', '2023-05-20', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:07:54', '2023-05-26 14:07:54'),
(532, '13', '0.068034', '2023-05-21', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:07:54', '2023-05-26 14:07:54'),
(533, '13', '0.068034', '2023-05-22', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:07:54', '2023-05-26 14:07:54'),
(534, '13', '0.068034', '2023-05-23', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:07:54', '2023-05-26 14:07:54'),
(535, '13', '0.068034', '2023-05-24', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:07:54', '2023-05-26 14:07:54'),
(536, '13', '0.068034', '2023-05-25', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:07:54', '2023-05-26 14:07:54'),
(537, '13', '0.068034', '2023-05-10', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:07:59', '2023-05-26 14:07:59'),
(538, '13', '0.068034', '2023-05-11', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:07:59', '2023-05-26 14:07:59'),
(539, '13', '0.068034', '2023-05-12', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:07:59', '2023-05-26 14:07:59'),
(540, '13', '0.068034', '2023-05-13', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:07:59', '2023-05-26 14:07:59'),
(541, '13', '0.068034', '2023-05-14', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:07:59', '2023-05-26 14:07:59'),
(542, '13', '0.068034', '2023-05-15', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:07:59', '2023-05-26 14:07:59'),
(543, '13', '0.068034', '2023-05-16', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:07:59', '2023-05-26 14:07:59'),
(544, '13', '0.068034', '2023-05-17', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:07:59', '2023-05-26 14:07:59'),
(545, '13', '0.068034', '2023-05-18', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:07:59', '2023-05-26 14:07:59'),
(546, '13', '0.068034', '2023-05-19', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:07:59', '2023-05-26 14:07:59'),
(547, '13', '0.068034', '2023-05-20', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:07:59', '2023-05-26 14:07:59'),
(548, '13', '0.068034', '2023-05-21', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:07:59', '2023-05-26 14:07:59'),
(549, '13', '0.068034', '2023-05-22', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:07:59', '2023-05-26 14:07:59'),
(550, '13', '0.068034', '2023-05-23', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:07:59', '2023-05-26 14:07:59'),
(551, '13', '0.068034', '2023-05-24', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:07:59', '2023-05-26 14:07:59'),
(552, '13', '0.068034', '2023-05-25', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:07:59', '2023-05-26 14:07:59'),
(553, '13', '0.068034', '2023-05-10', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:08:49', '2023-05-26 14:08:49'),
(554, '13', '0.068034', '2023-05-11', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:08:49', '2023-05-26 14:08:49'),
(555, '13', '0.068034', '2023-05-12', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:08:49', '2023-05-26 14:08:49'),
(556, '13', '0.068034', '2023-05-13', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:08:49', '2023-05-26 14:08:49'),
(557, '13', '0.068034', '2023-05-14', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:08:49', '2023-05-26 14:08:49'),
(558, '13', '0.068034', '2023-05-15', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:08:49', '2023-05-26 14:08:49'),
(559, '13', '0.068034', '2023-05-16', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:08:49', '2023-05-26 14:08:49'),
(560, '13', '0.068034', '2023-05-17', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:08:49', '2023-05-26 14:08:49'),
(561, '13', '0.068034', '2023-05-18', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:08:49', '2023-05-26 14:08:49'),
(562, '13', '0.068034', '2023-05-19', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:08:49', '2023-05-26 14:08:49'),
(563, '13', '0.068034', '2023-05-20', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:08:49', '2023-05-26 14:08:49'),
(564, '13', '0.068034', '2023-05-21', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:08:49', '2023-05-26 14:08:49'),
(565, '13', '0.068034', '2023-05-22', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:08:49', '2023-05-26 14:08:49'),
(566, '13', '0.068034', '2023-05-23', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:08:49', '2023-05-26 14:08:49'),
(567, '13', '0.068034', '2023-05-24', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:08:49', '2023-05-26 14:08:49'),
(568, '13', '0.068034', '2023-05-25', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:08:49', '2023-05-26 14:08:49'),
(569, '13', '0.068034', '2023-05-10', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:46:30', '2023-05-26 14:46:30'),
(570, '13', '0.068034', '2023-05-11', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:46:30', '2023-05-26 14:46:30'),
(571, '13', '0.068034', '2023-05-12', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:46:30', '2023-05-26 14:46:30'),
(572, '13', '0.068034', '2023-05-13', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:46:30', '2023-05-26 14:46:30'),
(573, '13', '0.068034', '2023-05-14', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:46:30', '2023-05-26 14:46:30'),
(574, '13', '0.068034', '2023-05-15', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:46:30', '2023-05-26 14:46:30'),
(575, '13', '0.068034', '2023-05-16', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:46:30', '2023-05-26 14:46:30'),
(576, '13', '0.068034', '2023-05-17', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:46:30', '2023-05-26 14:46:30'),
(577, '13', '0.068034', '2023-05-18', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:46:30', '2023-05-26 14:46:30'),
(578, '13', '0.068034', '2023-05-19', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:46:30', '2023-05-26 14:46:30'),
(579, '13', '0.068034', '2023-05-20', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:46:30', '2023-05-26 14:46:30'),
(580, '13', '0.068034', '2023-05-21', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:46:30', '2023-05-26 14:46:30'),
(581, '13', '0.068034', '2023-05-22', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:46:30', '2023-05-26 14:46:30'),
(582, '13', '0.068034', '2023-05-23', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:46:30', '2023-05-26 14:46:30'),
(583, '13', '0.068034', '2023-05-24', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:46:30', '2023-05-26 14:46:30'),
(584, '13', '0.068034', '2023-05-25', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 14:46:30', '2023-05-26 14:46:30'),
(585, '13', '0.068034', '2023-05-10', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 16:09:28', '2023-05-26 16:09:28'),
(586, '13', '0.068034', '2023-05-11', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 16:09:28', '2023-05-26 16:09:28'),
(587, '13', '0.068034', '2023-05-12', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 16:09:28', '2023-05-26 16:09:28'),
(588, '13', '0.068034', '2023-05-13', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 16:09:28', '2023-05-26 16:09:28'),
(589, '13', '0.068034', '2023-05-14', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 16:09:28', '2023-05-26 16:09:28'),
(590, '13', '0.068034', '2023-05-15', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 16:09:28', '2023-05-26 16:09:28'),
(591, '13', '0.068034', '2023-05-16', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 16:09:28', '2023-05-26 16:09:28'),
(592, '13', '0.068034', '2023-05-17', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 16:09:28', '2023-05-26 16:09:28'),
(593, '13', '0.068034', '2023-05-18', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 16:09:28', '2023-05-26 16:09:28'),
(594, '13', '0.068034', '2023-05-19', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 16:09:28', '2023-05-26 16:09:28'),
(595, '13', '0.068034', '2023-05-20', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 16:09:28', '2023-05-26 16:09:28'),
(596, '13', '0.068034', '2023-05-21', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 16:09:28', '2023-05-26 16:09:28'),
(597, '13', '0.068034', '2023-05-22', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 16:09:28', '2023-05-26 16:09:28'),
(598, '13', '0.068034', '2023-05-23', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 16:09:28', '2023-05-26 16:09:28'),
(599, '13', '0.068034', '2023-05-24', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 16:09:28', '2023-05-26 16:09:28'),
(600, '13', '0.068034', '2023-05-25', '102', NULL, '2023-06-02', '2023-05-10', '1', '2023-05-26 16:09:28', '2023-05-26 16:09:28');

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

--
-- Table structure for table `funds`
--

CREATE TABLE `funds` (
  `id` int(11) NOT NULL,
  `userid` int(11) DEFAULT NULL,
  `fundid` int(11) DEFAULT NULL,
  `amount` int(11) DEFAULT NULL,
  `enrolmentday` varchar(512) DEFAULT NULL,
  `timeupdated` timestamp NULL DEFAULT NULL,
  `maturitydate` varchar(512) DEFAULT NULL,
  `previoustime` datetime DEFAULT NULL,
  `interestearned` varchar(512) DEFAULT NULL,
  `maturedinterest` varchar(512) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `funds`
--

INSERT INTO `funds` (`id`, `userid`, `fundid`, `amount`, `enrolmentday`, `timeupdated`, `maturitydate`, `previoustime`, `interestearned`, `maturedinterest`) VALUES
(13, 13, 1, 102, '2023-05-10', '2023-05-23 09:14:59', '2023-06-02', '2023-05-26 16:23:58', '1.088544', '0');

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

--
-- Table structure for table `mpesatransaction`
--

CREATE TABLE `mpesatransaction` (
  `id` int(11) NOT NULL,
  `userid` int(11) DEFAULT NULL,
  `fundid` int(11) DEFAULT NULL,
  `MerchantRequestID` varchar(512) DEFAULT NULL,
  `CheckoutRequestID` varchar(512) DEFAULT NULL,
  `ResultCode` varchar(512) DEFAULT NULL,
  `ResultDesc` varchar(512) DEFAULT NULL,
  `Amount` varchar(512) DEFAULT NULL,
  `TransactionId` varchar(512) DEFAULT NULL,
  `TransactionDate` varchar(512) DEFAULT NULL,
  `UserPhoneNumber` varchar(512) DEFAULT NULL,
  `status` varchar(512) DEFAULT NULL,
  `datecreated` timestamp NULL DEFAULT NULL,
  `updateday` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mpesatransaction`
--

INSERT INTO `mpesatransaction` (`id`, `userid`, `fundid`, `MerchantRequestID`, `CheckoutRequestID`, `ResultCode`, `ResultDesc`, `Amount`, `TransactionId`, `TransactionDate`, `UserPhoneNumber`, `status`, `datecreated`, `updateday`) VALUES
(1, 12, 1, '5790-44784932-1', 'ws_CO_04032023043013199743208927', '0', 'The service request is processed successfully.', '1', NULL, NULL, NULL, 'Complete', '2023-03-04 01:32:10', '2023-03-04 01:32:10'),
(2, 12, 1, '122147-71296945-1', 'ws_CO_11032023031221526743208927', '0', 'The service request is processed successfully.', '1', NULL, NULL, NULL, 'Complete', '2023-03-11 00:17:04', '2023-03-11 00:17:04'),
(3, 12, 1, '5805-86328782-1', 'ws_CO_14032023142109419743208927', '0', 'The service request is processed successfully.', '1', NULL, NULL, NULL, 'Complete', '2023-03-14 11:22:49', '2023-03-14 11:22:49'),
(4, 13, 1, '21926-54997903-1', 'ws_CO_14032023163311039743208927', '0', 'The service request is processed successfully.', '1', NULL, NULL, NULL, 'Complete', '2023-03-14 20:33:39', '2023-03-14 20:33:39'),
(5, 13, 1, '21926-54997903-1', 'ws_CO_14032023163311039743208927', '0', 'The service request is processed successfully.', '1', NULL, NULL, NULL, 'Complete', '2023-03-14 20:33:42', '2023-03-14 20:33:42'),
(6, 13, 1, '101032-84550688-1', 'ws_CO_14032023163455150743208927', '0', 'The service request is processed successfully.', '1', NULL, NULL, NULL, 'Complete', '2023-03-14 20:35:28', '2023-03-14 20:35:28'),
(7, 13, 2, '17578-40504498-1', 'ws_CO_14032023163901452743208927', '0', 'The service request is processed successfully.', '1', NULL, NULL, NULL, 'Complete', '2023-03-14 20:39:37', '2023-03-14 20:39:37'),
(8, 13, 2, '17578-40504498-1', 'ws_CO_14032023163901452743208927', '0', 'The service request is processed successfully.', '1', NULL, NULL, NULL, 'Complete', '2023-03-14 20:39:43', '2023-03-14 20:39:43'),
(9, 13, 5, '5791-86831644-1', 'ws_CO_14032023164440327743208927', '0', 'The service request is processed successfully.', '1', NULL, NULL, NULL, 'Complete', '2023-03-14 20:46:01', '2023-03-14 20:46:01'),
(10, 14, 1, '17922-5472594-1', 'ws_CO_14032023183815919743208927', '0', 'The service request is processed successfully.', '1', NULL, NULL, NULL, 'Complete', '2023-03-14 22:39:15', '2023-03-14 22:39:15'),
(11, 14, 2, '5820-87297809-1', 'ws_CO_14032023184345507743208927', '0', 'The service request is processed successfully.', '1', NULL, NULL, NULL, 'Complete', '2023-03-14 22:44:45', '2023-03-14 22:44:45'),
(12, 13, 1, '1454-7694792-1', 'ws_CO_14052023000450222743208927', NULL, NULL, NULL, NULL, NULL, NULL, 'STK', '2023-05-13 13:04:33', '2023-05-13 13:04:33'),
(13, 13, 1, '129085-7963821-1', 'ws_CO_14052023010244362743208927', '0', NULL, NULL, NULL, NULL, NULL, 'STK', '2023-05-13 14:02:00', '2023-05-13 14:02:00'),
(14, 13, 1, '12134-7760603-1', 'ws_CO_14052023011115814743208927', '0', NULL, NULL, NULL, NULL, NULL, 'STK', '2023-05-13 14:10:32', '2023-05-13 14:10:32'),
(15, 13, 1, '83444-8103589-1', 'ws_CO_14052023012857047743208927', '0', NULL, NULL, NULL, NULL, NULL, 'Complete', '2023-05-13 14:28:40', '2023-05-13 14:28:40'),
(16, 13, 1, '3326-8085126-1', 'ws_CO_14052023013327403743208927', '0', NULL, NULL, NULL, NULL, NULL, 'STK', '2023-05-13 14:32:44', '2023-05-13 14:32:44'),
(17, 13, 1, '129084-8005778-1', 'ws_CO_14052023014218881743208927', '0', NULL, NULL, NULL, NULL, NULL, 'Complete', '2023-05-13 14:41:35', '2023-05-13 14:41:35'),
(18, 13, 1, '4081-14823714-1', 'ws_CO_16052023001719232743208927', '0', NULL, NULL, NULL, NULL, NULL, 'STK', '2023-05-15 13:17:01', '2023-05-15 13:17:01'),
(19, 13, 1, '83446-25386561-1', 'ws_CO_18052023144621746743208927', '0', NULL, NULL, NULL, NULL, NULL, 'STK', '2023-05-18 03:46:03', '2023-05-18 03:46:03'),
(20, 13, 1, '1455-44827153-1', 'ws_CO_23052023184254619743208927', '0', NULL, NULL, NULL, NULL, NULL, 'STK', '2023-05-23 07:42:34', '2023-05-23 07:42:34'),
(21, 13, 1, '83452-45436915-1', 'ws_CO_23052023184401021743208927', '0', NULL, NULL, NULL, NULL, NULL, 'STK', '2023-05-23 07:43:40', '2023-05-23 07:43:40'),
(22, 13, 1, '20602-44069413-1', 'ws_CO_23052023184650431743208927', '0', NULL, NULL, NULL, NULL, NULL, 'STK', '2023-05-23 07:45:58', '2023-05-23 07:45:58'),
(23, 13, 1, '16901-44298549-1', 'ws_CO_23052023184904494743208927', '0', NULL, NULL, NULL, NULL, NULL, 'STK', '2023-05-23 07:48:12', '2023-05-23 07:48:12'),
(24, 13, 1, '129091-44677583-3', 'ws_CO_23052023184933370743208927', '0', NULL, NULL, NULL, NULL, NULL, 'STK', '2023-05-23 07:49:12', '2023-05-23 07:49:12'),
(25, 13, 1, '12124-44753890-1', 'ws_CO_23052023185037258743208927', '0', NULL, NULL, NULL, NULL, NULL, 'STK', '2023-05-23 07:49:44', '2023-05-23 07:49:44'),
(26, 13, 1, '16893-44308908-1', 'ws_CO_23052023185131406743208927', '0', NULL, NULL, NULL, NULL, NULL, 'STK', '2023-05-23 07:50:39', '2023-05-23 07:50:39'),
(27, 13, 1, '22251-25701484-1', 'ws_CO_23052023185222577743208927', '0', NULL, NULL, NULL, NULL, NULL, 'STK', '2023-05-23 07:52:02', '2023-05-23 07:52:02'),
(28, 13, 1, '120316-45202473-1', 'ws_CO_23052023185248674743208927', '0', NULL, NULL, NULL, NULL, NULL, 'STK', '2023-05-23 07:52:28', '2023-05-23 07:52:28'),
(29, 13, 1, '10483-44711757-4', 'ws_CO_23052023185307689743208927', '0', NULL, NULL, NULL, NULL, NULL, 'STK', '2023-05-23 07:52:47', '2023-05-23 07:52:47'),
(30, 13, 1, '20611-44129388-1', 'ws_CO_23052023190048035743208927', '0', NULL, NULL, NULL, NULL, NULL, 'STK', '2023-05-23 07:59:55', '2023-05-23 07:59:55'),
(31, 13, 1, '12136-44812695-1', 'ws_CO_23052023190327307743208927', '0', NULL, NULL, NULL, NULL, NULL, 'STK', '2023-05-23 08:03:06', '2023-05-23 08:03:06'),
(32, 13, 1, '12136-44886656-1', 'ws_CO_23052023191856358743208927', '0', NULL, NULL, NULL, NULL, NULL, 'Complete', '2023-05-23 08:18:35', '2023-05-23 08:18:35'),
(33, 13, 1, '120311-45426705-1', 'ws_CO_23052023194154925743208927', '0', NULL, NULL, NULL, NULL, NULL, 'STK', '2023-05-23 08:41:02', '2023-05-23 08:41:02'),
(34, 13, 1, '1461-45094766-3', 'ws_CO_23052023194223043743208927', '0', NULL, NULL, NULL, NULL, NULL, 'Complete', '2023-05-23 08:41:30', '2023-05-23 08:41:30'),
(35, 13, 1, '84259-74085153-1', 'ws_CO_23052023194324897743208927', '0', NULL, NULL, NULL, NULL, NULL, 'Complete', '2023-05-23 08:42:32', '2023-05-23 08:42:32'),
(36, 13, 1, '22264-26525111-1', 'ws_CO_23052023220316328743208927', '0', NULL, NULL, NULL, NULL, NULL, 'Complete', '2023-05-23 11:03:00', '2023-05-23 11:03:00'),
(37, 13, 1, '22268-38191504-4', 'ws_CO_27052023001246293743208927', '0', NULL, NULL, NULL, NULL, NULL, 'STK', '2023-05-26 13:11:51', '2023-05-26 13:11:51'),
(38, 13, 1, '6551-38976920-1', 'ws_CO_27052023002430365743208927', '0', NULL, NULL, NULL, NULL, NULL, 'Complete', '2023-05-26 13:23:35', '2023-05-26 13:23:35');

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

--
-- Table structure for table `ndovufund`
--

CREATE TABLE `ndovufund` (
  `id` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  `amount` int(11) NOT NULL,
  `datecreated` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `notification`
--

CREATE TABLE `notification` (
  `id` int(11) NOT NULL,
  `subject` varchar(512) DEFAULT NULL,
  `userid` int(11) DEFAULT NULL,
  `message` varchar(512) DEFAULT NULL,
  `status` varchar(512) DEFAULT 'Not',
  `notitype` varchar(512) DEFAULT NULL,
  `datecreated` date DEFAULT NULL,
  `updated` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `notification`
--

INSERT INTO `notification` (`id`, `subject`, `userid`, `message`, `status`, `notitype`, `datecreated`, `updated`) VALUES
(1, 'TEWEREWR', 13, 'FDSDFGFDSSDDFDFSFSDFDSFDSFDFDS', 'Not', '1', '2023-05-24', '2023-05-24'),
(2, 'TEWEREWR', 13, 'FDSDFGFDSSDDFDFSFSDFDSFDSFDFDS', 'seen', '1', '2023-05-24', '2023-05-24'),
(3, 'Mpesa Top Up Received', 13, 'You have deposited1 to your fund', 'Not', 'Payment', '2023-05-26', '2023-05-26'),
(4, 'Personal Profile Updated', 13, 'You have Updated Your Personal Profile', 'Not', 'Profile', '2023-05-26', '2023-05-26'),
(5, 'Phone Number Updated', 13, 'You have Updated Your Phone Number', 'Not', 'Profile', '2023-05-26', '2023-05-26'),
(6, 'Phone Number Updated', 13, 'You have Updated Your Phone Number', 'Not', 'Profile', '2023-05-26', '2023-05-26');

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

--
-- Table structure for table `stkerror`
--

CREATE TABLE `stkerror` (
  `id` int(11) NOT NULL,
  `userid` int(11) DEFAULT NULL,
  `fundid` int(11) DEFAULT NULL,
  `errorCode` varchar(512) DEFAULT NULL,
  `errorMessage` varchar(512) DEFAULT NULL,
  `datecreated` timestamp NULL DEFAULT NULL,
  `updated` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `stkerror`
--

INSERT INTO `stkerror` (`id`, `userid`, `fundid`, `errorCode`, `errorMessage`, `datecreated`, `updated`) VALUES
(1, 13, 1, '400.002.02', 'Bad Request - Invalid PhoneNumber', '2023-05-13 12:25:05', '2023-05-13 12:25:05'),
(2, 13, 1, '400.002.02', 'Bad Request - Invalid PhoneNumber', '2023-05-13 12:27:30', '2023-05-13 12:27:30'),
(3, 13, 1, '500.001.1001', 'Unable to lock subscriber, a transaction is already in process for the current subscriber', '2023-05-18 03:46:18', '2023-05-18 03:46:18');

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

--
-- Table structure for table `stkinitiation`
--

CREATE TABLE `stkinitiation` (
  `id` int(11) NOT NULL,
  `userid` int(11) DEFAULT NULL,
  `MerchantRequestID` varchar(512) DEFAULT NULL,
  `CheckoutRequestID` varchar(512) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `ResponseCode` varchar(512) DEFAULT NULL,
  `ResponseDescription` varchar(512) DEFAULT NULL,
  `CustomerMessage` varchar(512) DEFAULT NULL,
  `fundid` varchar(512) DEFAULT NULL,
  `amount` int(11) DEFAULT NULL,
  `phonenumber` varchar(255) DEFAULT NULL,
  `datecreated` timestamp NULL DEFAULT NULL,
  `dayupdate` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `stkinitiation`
--

INSERT INTO `stkinitiation` (`id`, `userid`, `MerchantRequestID`, `CheckoutRequestID`, `status`, `ResponseCode`, `ResponseDescription`, `CustomerMessage`, `fundid`, `amount`, `phonenumber`, `datecreated`, `dayupdate`) VALUES
(6, 12, '5790-44784932-1', 'ws_CO_04032023043013199743208927', NULL, '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '1', 1, NULL, '2023-03-03 16:31:01', '2023-03-03 16:31:01'),
(7, 12, '122147-71296945-1', 'ws_CO_11032023031221526743208927', NULL, '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '1', 1, NULL, '2023-03-10 15:13:12', '2023-03-10 15:13:12'),
(8, 12, '21930-54317934-1', 'ws_CO_14032023131942819743208927', NULL, '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '1', 1, NULL, '2023-03-14 02:20:49', '2023-03-14 02:20:49'),
(9, 12, '17582-40024171-1', 'ws_CO_14032023141725166743208927', NULL, '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '1', 1, NULL, '2023-03-14 03:18:22', '2023-03-14 03:18:22'),
(10, 12, '5805-86328782-1', 'ws_CO_14032023142109419743208927', NULL, '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '1', 1, NULL, '2023-03-14 03:22:06', '2023-03-14 03:22:06'),
(11, 12, '101029-84353615-1', 'ws_CO_14032023153747236743208927', NULL, '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '3', 1, NULL, '2023-03-14 04:38:44', '2023-03-14 04:38:44'),
(12, 12, '42513-21846949-2', 'ws_CO_14032023154008103743208927', NULL, '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '3', 1, NULL, '2023-03-14 04:41:10', '2023-03-14 04:41:10'),
(13, 13, '37392-80782194-1', 'ws_CO_14032023163115225743208927', NULL, '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '1', 10, NULL, '2023-03-14 12:31:20', '2023-03-14 12:31:20'),
(14, 13, '17908-4997311-1', 'ws_CO_14032023163146245743208927', NULL, '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '1', 1, NULL, '2023-03-14 12:31:51', '2023-03-14 12:31:51'),
(15, 13, '37390-80785349-1', 'ws_CO_14032023163208710743208927', NULL, '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '1', 1, NULL, '2023-03-14 12:32:13', '2023-03-14 12:32:13'),
(16, 13, '21926-54997903-1', 'ws_CO_14032023163311039743208927', NULL, '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '1', 1, NULL, '2023-03-14 12:33:16', '2023-03-14 12:33:16'),
(17, 13, '101032-84550688-1', 'ws_CO_14032023163455150743208927', NULL, '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '1', 1, NULL, '2023-03-14 12:35:00', '2023-03-14 12:35:00'),
(18, 13, '17578-40504498-1', 'ws_CO_14032023163901452743208927', NULL, '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '2', 1, NULL, '2023-03-14 12:39:06', '2023-03-14 12:39:06'),
(19, 13, '5791-86831644-1', 'ws_CO_14032023164440327743208927', NULL, '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '5', 1, NULL, '2023-03-14 12:44:46', '2023-03-14 12:44:46'),
(20, 13, '122145-84849722-1', 'ws_CO_14032023174906892743208927', NULL, '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '1', 10, NULL, '2023-03-14 13:49:12', '2023-03-14 13:49:12'),
(21, 14, '17922-5472594-1', 'ws_CO_14032023183815919743208927', NULL, '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '1', 1, NULL, '2023-03-14 14:38:21', '2023-03-14 14:38:21'),
(22, 14, '5820-87297809-1', 'ws_CO_14032023184345507743208927', NULL, '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '2', 1, NULL, '2023-03-14 14:44:01', '2023-03-14 14:44:01'),
(23, 13, '39321-173550072-1', 'ws_CO_07052023012622666743208927', NULL, '0', NULL, NULL, '1', 1, '254743208927', '2023-05-06 14:25:44', '2023-05-06 14:25:44'),
(24, 13, '2587-47254303-1', 'ws_CO_07052023013133489743208927', NULL, '0', NULL, NULL, '1', 1, '254743208927', '2023-05-06 14:31:18', '2023-05-06 14:31:18'),
(25, 13, '7243-68244585-1', 'ws_CO_07052023020153588743208927', NULL, '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '1', 1, '254743208927', '2023-05-06 15:01:15', '2023-05-06 15:01:15'),
(26, 13, '22521-49171985-1', 'ws_CO_07052023020316719743208927', NULL, '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '1', 1, '254743208927', '2023-05-06 15:03:01', '2023-05-06 15:03:01'),
(27, 13, '7445-173367928-1', 'ws_CO_07052023020522674743208927', NULL, '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '1', 1, '254743208927', '2023-05-06 15:04:44', '2023-05-06 15:04:44'),
(28, 13, '19189-46855877-1', 'ws_CO_07052023020649356743208927', NULL, '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '1', 1, '254743208927', '2023-05-06 15:06:34', '2023-05-06 15:06:34'),
(29, 13, '7432-173377534-1', 'ws_CO_07052023021514876743208927', NULL, '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '1', 1, '254743208927', '2023-05-06 15:14:59', '2023-05-06 15:14:59'),
(30, 13, '22500-49192653-2', 'ws_CO_07052023022250632743208927', NULL, '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '1', 1, '254743208927', '2023-05-06 15:22:35', '2023-05-06 15:22:35'),
(31, 13, '24340-46403177-1', 'ws_CO_07052023023000666743208927', NULL, '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '1', 1, '254743208927', '2023-05-06 15:29:45', '2023-05-06 15:29:45'),
(32, 13, '7451-173395186-2', 'ws_CO_07052023023520790743208927', NULL, '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '1', 1, '254743208927', '2023-05-06 15:35:05', '2023-05-06 15:35:05'),
(33, 13, '25495-49307221-1', 'ws_CO_07052023024835727743208927', NULL, '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '1', 1, '254743208927', '2023-05-06 15:47:57', '2023-05-06 15:47:57'),
(34, 13, '10688-61072890-1', 'ws_CO_07052023025319573743208927', NULL, '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '1', 1, '254743208927', '2023-05-06 15:52:41', '2023-05-06 15:52:41'),
(35, 13, '7457-173421062-1', 'ws_CO_07052023030654835743208927', NULL, '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '1', 1, '254743208927', '2023-05-06 16:06:16', '2023-05-06 16:06:16'),
(36, 13, '2575-47345924-1', 'ws_CO_07052023031419668743208927', NULL, '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '1', 1, '254743208927', '2023-05-06 16:13:41', '2023-05-06 16:13:41'),
(37, 13, '7249-68315151-1', 'ws_CO_07052023031745605743208927', NULL, '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '1', 1, '254743208927', '2023-05-06 16:17:07', '2023-05-06 16:17:07'),
(38, 13, '10695-61100503-1', 'ws_CO_07052023032817308743208927', NULL, '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '1', 1, '254743208927', '2023-05-06 16:27:38', '2023-05-06 16:27:38'),
(39, 13, '7430-173447300-1', 'ws_CO_07052023034047857743208927', NULL, '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '1', 1, '254743208927', '2023-05-06 16:40:32', '2023-05-06 16:40:32'),
(40, 13, '2594-47368356-1', 'ws_CO_07052023034403498743208927', NULL, '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '1', 1, '254743208927', '2023-05-06 16:43:25', '2023-05-06 16:43:25'),
(41, 13, '22501-49270391-1', 'ws_CO_07052023034648388743208927', NULL, '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '1', 1, '254743208927', '2023-05-06 16:46:09', '2023-05-06 16:46:09'),
(42, 13, '39307-173677149-1', 'ws_CO_07052023034716717743208927', NULL, '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '1', 1, '254743208927', '2023-05-06 16:47:01', '2023-05-06 16:47:01'),
(43, 13, '2597-47385209-1', 'ws_CO_07052023040651755743208927', NULL, '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '1', 1, '254743208927', '2023-05-06 17:06:13', '2023-05-06 17:06:13'),
(44, 13, '7236-68358315-1', 'ws_CO_07052023041017680743208927', NULL, '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '1', 1, '254743208927', '2023-05-06 17:09:39', '2023-05-06 17:09:39'),
(45, 13, '84257-9304209-1', 'ws_CO_07052023041317841743208927', NULL, '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '1', 1, '254743208927', '2023-05-06 17:13:02', '2023-05-06 17:13:02'),
(46, 13, '25502-49383216-1', 'ws_CO_07052023041604973743208927', NULL, '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '1', 1, '254743208927', '2023-05-06 17:15:26', '2023-05-06 17:15:26'),
(47, 13, '70245-63675991-1', 'ws_CO_07052023041648566743208927', NULL, '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '1', 1, '254743208927', '2023-05-06 17:16:32', '2023-05-06 17:16:32'),
(48, 13, '39305-173718527-3', 'ws_CO_07052023044052031743208927', NULL, '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '1', 1, '254743208927', '2023-05-06 17:40:36', '2023-05-06 17:40:36'),
(49, 13, '2580-47412673-1', 'ws_CO_07052023044323570743208927', NULL, '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '1', 1, '254743208927', '2023-05-06 17:43:07', '2023-05-06 17:43:07'),
(50, 13, '7445-173507078-1', 'ws_CO_07052023050145349743208927', NULL, '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '1', 1, '254743208927', '2023-05-06 18:01:06', '2023-05-06 18:01:06'),
(51, 13, '2575-47426889-1', 'ws_CO_07052023050301197743208927', NULL, '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '1', 1, '254743208927', '2023-05-06 18:02:22', '2023-05-06 18:02:22'),
(52, 13, '70245-63711917-1', 'ws_CO_07052023050405016743208927', NULL, '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '1', 1, '254743208927', '2023-05-06 18:03:26', '2023-05-06 18:03:26'),
(53, 13, '70238-70136571-1', 'ws_CO_08052023192512255743208927', NULL, '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '1', 1, '254743208927', '2023-05-08 08:24:33', '2023-05-08 08:24:33'),
(54, 13, '16895-7554904-1', 'ws_CO_13052023223327350743208927', NULL, '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '1', 10, '254743208927', '2023-05-13 11:33:10', '2023-05-13 11:33:10'),
(55, 13, '25715-7538992-1', 'ws_CO_13052023225219819743208927', NULL, '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '1', 10, '254743208927', '2023-05-13 11:52:02', '2023-05-13 11:52:02'),
(56, 13, '10474-7754873-1', 'ws_CO_13052023225345522743208927', NULL, '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '1', 10000, '254743208927', '2023-05-13 11:53:01', '2023-05-13 11:53:01'),
(57, 13, '1454-7694792-1', 'ws_CO_14052023000450222743208927', NULL, '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '1', 1, '254743208927', '2023-05-13 13:04:33', '2023-05-13 13:04:33'),
(58, 13, '129085-7963821-1', 'ws_CO_14052023010244362743208927', NULL, '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '1', 1, '254743208927', '2023-05-13 14:02:00', '2023-05-13 14:02:00'),
(59, 13, '12134-7760603-1', 'ws_CO_14052023011115814743208927', NULL, '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '1', 1, '254743208927', '2023-05-13 14:10:32', '2023-05-13 14:10:32'),
(60, 13, '83444-8103589-1', 'ws_CO_14052023012857047743208927', 'Complete', '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '1', 2, '254743208927', '2023-05-13 14:28:40', '2023-05-13 14:28:40'),
(61, 13, '3326-8085126-1', 'ws_CO_14052023013327403743208927', 'STK Initiated', '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '1', 1, '254743208927', '2023-05-13 14:32:44', '2023-05-13 14:32:44'),
(62, 13, '129084-8005778-1', 'ws_CO_14052023014218881743208927', 'Complete', '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '1', 1, '254743208927', '2023-05-13 14:41:35', '2023-05-13 14:41:35'),
(63, 13, '4081-14823714-1', 'ws_CO_16052023001719232743208927', 'STK Initiated', '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '1', 1, '254743208927', '2023-05-15 13:17:01', '2023-05-15 13:17:01'),
(64, 13, '83446-25386561-1', 'ws_CO_18052023144621746743208927', 'STK Initiated', '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '1', 1, '254743208927', '2023-05-18 03:46:03', '2023-05-18 03:46:03'),
(65, 13, '1455-44827153-1', 'ws_CO_23052023184254619743208927', 'STK Initiated', '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '1', 1, '254743208927', '2023-05-23 07:42:34', '2023-05-23 07:42:34'),
(66, 13, '83452-45436915-1', 'ws_CO_23052023184401021743208927', 'STK Initiated', '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '1', 1, '254743208927', '2023-05-23 07:43:40', '2023-05-23 07:43:40'),
(67, 13, '20602-44069413-1', 'ws_CO_23052023184650431743208927', 'STK Initiated', '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '1', 1, '254743208927', '2023-05-23 07:45:58', '2023-05-23 07:45:58'),
(68, 13, '16901-44298549-1', 'ws_CO_23052023184904494743208927', 'STK Initiated', '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '1', 1, '254743208927', '2023-05-23 07:48:12', '2023-05-23 07:48:12'),
(69, 13, '129091-44677583-3', 'ws_CO_23052023184933370743208927', 'STK Initiated', '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '1', 1, '254743208927', '2023-05-23 07:49:12', '2023-05-23 07:49:12'),
(70, 13, '12124-44753890-1', 'ws_CO_23052023185037258743208927', 'STK Initiated', '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '1', 1, '254743208927', '2023-05-23 07:49:44', '2023-05-23 07:49:44'),
(71, 13, '16893-44308908-1', 'ws_CO_23052023185131406743208927', 'STK Initiated', '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '1', 1, '254743208927', '2023-05-23 07:50:39', '2023-05-23 07:50:39'),
(72, 13, '22251-25701484-1', 'ws_CO_23052023185222577743208927', 'STK Initiated', '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '1', 1, '254743208927', '2023-05-23 07:52:01', '2023-05-23 07:52:01'),
(73, 13, '120316-45202473-1', 'ws_CO_23052023185248674743208927', 'STK Initiated', '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '1', 1, '254743208927', '2023-05-23 07:52:28', '2023-05-23 07:52:28'),
(74, 13, '10483-44711757-4', 'ws_CO_23052023185307689743208927', 'STK Initiated', '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '1', 1, '254743208927', '2023-05-23 07:52:47', '2023-05-23 07:52:47'),
(75, 13, '20611-44129388-1', 'ws_CO_23052023190048035743208927', 'STK Initiated', '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '1', 1, '254743208927', '2023-05-23 07:59:55', '2023-05-23 07:59:55'),
(76, 13, '12136-44812695-1', 'ws_CO_23052023190327307743208927', 'STK Initiated', '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '1', 1, '254743208927', '2023-05-23 08:03:06', '2023-05-23 08:03:06'),
(77, 13, '12136-44886656-1', 'ws_CO_23052023191856358743208927', 'Complete', '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '1', 1, '254743208927', '2023-05-23 08:18:35', '2023-05-23 08:18:35'),
(78, 13, '120311-45426705-1', 'ws_CO_23052023194154925743208927', 'STK Initiated', '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '1', 1, '254743208927', '2023-05-23 08:41:02', '2023-05-23 08:41:02'),
(79, 13, '1461-45094766-3', 'ws_CO_23052023194223043743208927', 'Complete', '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '1', 1, '254743208927', '2023-05-23 08:41:30', '2023-05-23 08:41:30'),
(80, 13, '84259-74085153-1', 'ws_CO_23052023194324897743208927', 'Complete', '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '1', 1, '254743208927', '2023-05-23 08:42:32', '2023-05-23 08:42:32'),
(81, 13, '22264-26525111-1', 'ws_CO_23052023220316328743208927', 'Complete', '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '1', 1, '254743208927', '2023-05-23 11:03:00', '2023-05-23 11:03:00'),
(82, 13, '22268-38191504-4', 'ws_CO_27052023001246293743208927', 'STK Initiated', '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '1', 1, '254743208927', '2023-05-26 13:11:51', '2023-05-26 13:11:51'),
(83, 13, '6551-38976920-1', 'ws_CO_27052023002430365743208927', 'Complete', '0', 'Success. Request accepted for processing', 'Success. Request accepted for processing', '1', 1, '254743208927', '2023-05-26 13:23:35', '2023-05-26 13:23:35');

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

--
-- Table structure for table `transactioninfo`
--

CREATE TABLE `transactioninfo` (
  `id` int(11) NOT NULL,
  `transactionmode` varchar(255) DEFAULT NULL,
  `amount` int(11) DEFAULT NULL,
  `transactioncode` varchar(512) DEFAULT NULL,
  `datecreated` timestamp NULL DEFAULT NULL,
  `updated` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

CREATE TABLE `transactions` (
  `id` int(11) NOT NULL,
  `TransactionId` varchar(255) DEFAULT NULL,
  `fundid` int(11) DEFAULT NULL,
  `userid` int(11) DEFAULT NULL,
  `amount` int(11) DEFAULT NULL,
  `datecreated` timestamp NULL DEFAULT NULL,
  `transactionmode` varchar(255) DEFAULT NULL,
  `phonenumber` varchar(255) DEFAULT NULL,
  `transtype` varchar(255) DEFAULT 'Deposit',
  `previoustime` timestamp NULL DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `transactions` (`id`, `TransactionId`, `fundid`, `userid`, `amount`, `datecreated`, `transactionmode`, `phonenumber`, `transtype`, `previoustime`, `status`) VALUES
(2, 'ENROLMENT-FUNDNO-1-USER-12', 1, 12, 0, '2023-02-22 12:03:31', 'ENROL-FUNDNO-1-USER-12', NULL, NULL, '2023-02-22 12:03:31', NULL),
(3, '5790-44784932-1', 1, 12, 1, '2023-03-04 01:32:10', NULL, NULL, 'Deposit', '2023-03-04 01:32:10', NULL),
(4, '122147-71296945-1', 1, 12, 1, '2023-03-11 00:17:04', NULL, NULL, 'Deposit', '2023-03-11 00:17:04', NULL),
(6, '5805-86328782-1', 1, 12, 1, '2023-03-14 11:22:49', NULL, NULL, 'Deposit', '2023-03-14 11:22:49', NULL),
(7, 'ENROLMENT-FUNDNO-3-USER-12', 3, 12, 0, '2023-03-14 03:26:22', 'ENROL-FUNDNO-3-USER-12', NULL, NULL, '2023-03-14 03:26:22', NULL),
(8, 'ENROLMENT-FUNDNO-1-USER-13', 1, 13, 0, '2023-03-14 12:27:14', 'ENROL-FUNDNO-1-USER-13', NULL, 'Deposit', '2023-03-14 12:27:14', NULL),
(9, '21926-54997903-1', 1, 13, 1, '2023-03-14 20:33:39', NULL, NULL, 'Deposit', '2023-03-14 20:33:39', NULL),
(10, '21926-54997903-1', 1, 13, 1, '2023-03-14 20:33:42', NULL, NULL, 'Deposit', '2023-03-14 20:33:42', NULL),
(11, '101032-84550688-1', 1, 13, 1, '2023-03-14 20:35:28', NULL, NULL, 'Deposit', '2023-03-14 20:35:28', NULL),
(12, 'ENROLMENT-FUNDNO-2-USER-13', 2, 13, 0, '2023-03-14 12:38:33', 'ENROL-FUNDNO-2-USER-13', NULL, 'Deposit', '2023-03-14 12:38:33', NULL),
(13, '17578-40504498-1', 2, 13, 1, '2023-03-14 20:39:37', NULL, NULL, 'Deposit', '2023-03-14 20:39:37', NULL),
(14, '17578-40504498-1', 2, 13, 1, '2023-03-14 20:39:43', NULL, NULL, 'Deposit', '2023-03-14 20:39:43', NULL),
(15, 'ENROLMENT-FUNDNO-5-USER-13', 5, 13, 0, '2023-03-14 12:44:32', 'ENROL-FUNDNO-5-USER-13', NULL, 'Deposit', '2023-03-14 12:44:32', NULL),
(16, '5791-86831644-1', 5, 13, 1, '2023-03-14 20:46:01', NULL, NULL, 'Deposit', '2023-03-14 20:46:01', NULL),
(17, 'ENROLMENT-FUNDNO-1-USER-14', 1, 14, 0, '2023-03-14 14:37:30', 'ENROL-FUNDNO-1-USER-14', NULL, 'Deposit', '2023-03-14 14:37:30', NULL),
(18, '17922-5472594-1', 1, 14, 1, '2023-03-14 22:39:15', NULL, NULL, 'Deposit', '2023-03-14 22:39:15', NULL),
(19, 'ENROLMENT-FUNDNO-2-USER-14', 2, 14, 0, '2023-03-14 14:43:32', 'ENROL-FUNDNO-2-USER-14', NULL, 'Deposit', '2023-03-14 14:43:32', NULL),
(20, '5820-87297809-1', 2, 14, 1, '2023-03-14 22:44:45', NULL, NULL, 'Deposit', '2023-03-14 22:44:45', NULL),
(21, 'ws_CO_14052023011115814743208927', 1, 13, 1, '2023-05-13 14:15:12', 'Mpesa', '254743208927', 'Top Up', '2023-05-13 14:15:12', 'Sucess'),
(22, 'ws_CO_14052023012857047743208927', 1, 13, 2, '2023-05-13 14:29:53', 'Mpesa', '254743208927', 'Top Up', '2023-05-13 14:29:53', 'Sucess'),
(23, 'ws_CO_14052023014218881743208927', 1, 13, 1, '2023-05-13 14:41:51', 'Mpesa', '254743208927', 'Top Up', '2023-05-13 14:41:51', 'Sucess'),
(24, 'ws_CO_23052023191856358743208927', 1, 13, 1, '2023-05-23 08:19:04', 'Mpesa', '254743208927', 'Top Up', '2023-05-23 08:19:04', 'Sucess'),
(25, 'ws_CO_23052023194223043743208927', 1, 13, 1, '2023-05-23 08:41:50', 'Mpesa', '254743208927', 'Top Up', '2023-05-23 08:41:50', 'Sucess'),
(26, 'ws_CO_23052023194324897743208927', 1, 13, 1, '2023-05-23 08:42:52', 'Mpesa', '254743208927', 'Top Up', '2023-05-23 08:42:52', 'Sucess'),
(27, 'ENROLMENT-FUNDNO-1-USER-13', 1, 13, 0, '2023-05-23 09:13:19', 'ENROL-FUNDNO-1-USER-13', NULL, 'Deposit', '2023-05-23 09:13:19', 'Enrolment'),
(28, 'ENROLMENT-FUNDNO-1-USER-13', 1, 13, 0, '2023-05-23 09:14:59', 'ENROL-FUNDNO-1-USER-13', NULL, 'Deposit', '2023-05-23 09:14:59', 'Enrolment'),
(29, 'ws_CO_23052023220316328743208927', 1, 13, 1, '2023-05-23 11:03:24', 'Mpesa', '254743208927', 'Top Up', '2023-05-23 11:03:24', 'Sucess'),
(30, 'ws_CO_27052023002430365743208927', 1, 13, 1, '2023-05-26 13:23:58', 'Mpesa', '254743208927', 'Top Up', '2023-05-26 13:23:58', 'Sucess');

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

--
-- Table structure for table `user`
--

CREATE TABLE `user` (
  `userid` int(11) NOT NULL,
  `fullname` varchar(512) DEFAULT NULL,
  `mobilenumber` varchar(512) DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `emailadress` varchar(512) DEFAULT NULL,
  `otp` varchar(512) DEFAULT NULL,
  `status` varchar(512) DEFAULT NULL,
  `datecreated` timestamp NULL DEFAULT NULL,
  `latestlogin` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `user`
--

INSERT INTO `user` (`userid`, `fullname`, `mobilenumber`, `password`, `emailadress`, `otp`, `status`, `datecreated`, `latestlogin`) VALUES
(10, 'bernard munyu', '0722813569', '$2y$10$vXrt2ukqSDtMQeid2wN44uiRNvzcJNAy7bcH3u1bES49LSXwhEydu', 'bernardkarabamunyu@gmail.com', '8192', '2', '2023-01-20 00:38:28', '2023-01-20 00:38:28'),
(13, 'Mike Saoke', '+254743208927', '$2y$10$OhIIzCHyWAqzDz2daz3xDua0s6lareID/s4.5XLOZGnxMc567m3Ja', 'mikesaoke03@gmail.com', '8110', '3', '2023-03-14 12:20:01', '2023-05-26 11:47:50'),
(14, 'Michael Gitonga', '+254721121071', '$2y$10$6TpAyQOPlrzaCJ1jCxvCGurrhZ8H1xtzEbmH8JMYL6xLyK64EIo.q', 'fxgitosh@gmail.com', '3381', '3', '2023-03-14 14:24:49', '2023-03-14 14:24:49'),
(16, '0743208927`', NULL, '$2y$10$8LBKDmFj5ZED7zKmob4rtuTtV5NoM8K2J76onBv43ujbLtO6I0X7a', 'marcusokoth@gmail.com', '9534', '3', '2023-03-24 08:42:46', '2023-03-24 08:42:46');

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

--
-- Table structure for table `userinfo`
--

CREATE TABLE `userinfo` (
  `id` int(11) NOT NULL,
  `userid` int(11) DEFAULT NULL,
  `krapin` varchar(512) DEFAULT NULL,
  `idfront` varchar(512) DEFAULT NULL,
  `idback` varchar(512) DEFAULT NULL,
  `profilepic` varchar(512) DEFAULT NULL,
  `gender` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `dateofbirth` varchar(512) DEFAULT NULL,
  `datecreated` timestamp NULL DEFAULT NULL,
  `idnumber` varchar(512) DEFAULT NULL,
  `lastupdate` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `userinfo`
--

INSERT INTO `userinfo` (`id`, `userid`, `krapin`, `idfront`, `idback`, `profilepic`, `gender`, `city`, `dateofbirth`, `datecreated`, `idnumber`, `lastupdate`) VALUES
(1, 9, 'trtrrerwe', 'Law and advocacy south sudan_1.jpg', 'Law and advocacy south sudan_1.jpg', 'Brenda Ongalo_1.jpg', 'Male', 'ttrrerttew', '2023-01-03', '2023-01-18 19:06:46', '34902193', '2023-01-18 19:06:46'),
(2, 10, 'a6677889j', 'IMG_20230119_224914.jpg', 'IMG_20230119_224914.jpg', 'Screenshot_20230109-111241.jpg', 'Male', 'tesdfhj', '2022-09-08', '2023-01-20 00:41:13', '346767898', '2023-01-20 00:41:13'),
(3, 12, '432243242', 'hammer-g16f1e85b0_1920.jpg', 'hammer-g16f1e85b0_1920.jpg', 'corporate-law.jpg', 'Male', 'Niarobi', '2023-02-15', '2023-02-22 08:57:52', '342342432324', '2023-02-22 08:57:52'),
(4, 13, '564728264', 'IMG-20230312-WA0002.jpg', 'IMG-20230312-WA0002.jpg', 'Capture_5.PNG', 'Female', 'Nairobi', '1994-07-03', '2023-03-14 12:23:51', '66252524545', '2023-03-14 12:23:51'),
(5, 14, '43644576', 'Focus Magic Test Image.jpg', 'Focus Magic Test Image.jpg', 'Focus Magic Test Image.jpg', 'Male', 'nairobi', '2023-03-07', '2023-03-14 14:35:10', '6546547657', '2023-03-14 14:35:10'),
(6, 12, 'fdsdfdsfsd', 'Screenshot (2).png', 'Screenshot (2).png', 'ISK Logo_banner_transparent.png', 'Male', 'sfdfdfdsfds', '2023-03-23', '2023-03-22 13:08:35', '34902193', '2023-03-22 13:08:35');

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `user`
--
ALTER TABLE `user`
  ADD PRIMARY KEY (`userid`);

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `user`
--
ALTER TABLE `user`
  MODIFY `userid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `userinfo`
--
ALTER TABLE `userinfo`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

${this.title}

Code Editor : tradeapp.sql