-- http://www.phpmyadmin.net
--




--
-- Database: `global_business`
--

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

--
-- Table structure for table `holiday`
--

CREATE TABLE IF NOT EXISTS `holiday` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `Name` varchar(155) NOT NULL,
  `H_Date` date NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=569 ;

--
-- Dumping data for table `holiday`
--

INSERT INTO `holiday` (`id`, `Name`, `H_Date`) VALUES
(2, 'Sat', '2020-06-13'),
(3, 'Sun', '2020-06-14'),
(4, 'Sat', '2020-06-20'),
(5, 'Sun', '2020-06-21'),
(6, 'Sat', '2020-06-27'),
(7, 'Sun', '2020-06-28'),
(8, 'Sat', '2020-07-04'),
(9, 'Sun', '2020-07-05'),
(10, 'Sat', '2020-07-11'),
(11, 'Sun', '2020-07-12'),
(12, 'Sat', '2020-07-18'),
(13, 'Sun', '2020-07-19'),
(14, 'Sat', '2020-07-25'),
(15, 'Sun', '2020-07-26'),
(16, 'Sat', '2020-08-01'),
(17, 'Sun', '2020-08-02'),
(18, 'Sat', '2020-08-08'),
(19, 'Sun', '2020-08-09'),
(20, 'Sat', '2020-08-15'),
(21, 'Sun', '2020-08-16'),
(22, 'Sat', '2020-08-22'),
(23, 'Sun', '2020-08-23'),
(24, 'Sat', '2020-08-29'),
(25, 'Sun', '2020-08-30'),
(26, 'Sat', '2020-09-05'),
(27, 'Sun', '2020-09-06'),
(28, 'Sat', '2020-09-12'),
(29, 'Sun', '2020-09-13'),
(30, 'Sat', '2020-09-19'),
(31, 'Sun', '2020-09-20'),
(32, 'Sat', '2020-09-26'),
(33, 'Sun', '2020-09-27'),
(34, 'Sat', '2020-10-03'),
(35, 'Sun', '2020-10-04'),
(36, 'Sat', '2020-10-10'),
(37, 'Sun', '2020-10-11'),
(38, 'Sat', '2020-10-17'),
(39, 'Sun', '2020-10-18'),
(40, 'Sat', '2020-10-24'),
(41, 'Sun', '2020-10-25'),
(42, 'Sat', '2020-10-31'),
(43, 'Sun', '2020-11-01'),
(44, 'Sat', '2020-11-07'),
(45, 'Sun', '2020-11-08'),
(46, 'Sat', '2020-11-14'),
(47, 'Sun', '2020-11-15'),
(48, 'Sat', '2020-11-21'),
(49, 'Sun', '2020-11-22'),
(50, 'Sat', '2020-11-28'),
(51, 'Sun', '2020-11-29'),
(52, 'Sat', '2020-12-05'),
(53, 'Sun', '2020-12-06'),
(54, 'Sat', '2020-12-12'),
(55, 'Sun', '2020-12-13'),
(56, 'Sat', '2020-12-19'),
(57, 'Sun', '2020-12-20'),
(58, 'Sat', '2020-12-26'),
(59, 'Sun', '2020-12-27'),
(60, 'Sat', '2021-01-02'),
(61, 'Sun', '2021-01-03'),
(62, 'Sat', '2021-01-09'),
(63, 'Sun', '2021-01-10'),
(64, 'Sat', '2021-01-16'),
(65, 'Sun', '2021-01-17'),
(66, 'Sat', '2021-01-23'),
(67, 'Sun', '2021-01-24'),
(68, 'Sat', '2021-01-30'),
(69, 'Sun', '2021-01-31'),
(70, 'Sat', '2021-02-06'),
(71, 'Sun', '2021-02-07'),
(72, 'Sat', '2021-02-13'),
(73, 'Sun', '2021-02-14'),
(74, 'Sat', '2021-02-20'),
(75, 'Sun', '2021-02-21'),
(76, 'Sat', '2021-02-27'),
(77, 'Sun', '2021-02-28'),
(78, 'Sat', '2021-03-06'),
(79, 'Sun', '2021-03-07'),
(80, 'Sat', '2021-03-13'),
(81, 'Sun', '2021-03-14'),
(82, 'Sat', '2021-03-20'),
(83, 'Sun', '2021-03-21'),
(84, 'Sat', '2021-03-27'),
(85, 'Sun', '2021-03-28'),
(86, 'Sat', '2021-04-03'),
(87, 'Sun', '2021-04-04'),
(88, 'Sat', '2021-04-10'),
(89, 'Sun', '2021-04-11'),
(90, 'Sat', '2021-04-17'),
(91, 'Sun', '2021-04-18'),
(92, 'Sat', '2021-04-24'),
(93, 'Sun', '2021-04-25'),
(94, 'Sat', '2021-05-01'),
(95, 'Sun', '2021-05-02'),
(96, 'Sat', '2021-05-08'),
(97, 'Sun', '2021-05-09'),
(98, 'Sat', '2021-05-15'),
(99, 'Sun', '2021-05-16'),
(100, 'Sat', '2021-05-22'),
(101, 'Sun', '2021-05-23'),
(102, 'Sat', '2021-05-29'),
(103, 'Sun', '2021-05-30'),
(104, 'Sat', '2021-06-05'),
(105, 'Sun', '2021-06-06'),
(106, 'Sat', '2021-06-12'),
(107, 'Sun', '2021-06-13'),
(108, 'Sat', '2021-06-19'),
(109, 'Sun', '2021-06-20'),
(110, 'Sat', '2021-06-26'),
(111, 'Sun', '2021-06-27'),
(112, 'Sat', '2021-07-03'),
(113, 'Sun', '2021-07-04'),
(114, 'Sat', '2021-07-10'),
(115, 'Sun', '2021-07-11'),
(116, 'Sat', '2021-07-17'),
(117, 'Sun', '2021-07-18'),
(118, 'Sat', '2021-07-24'),
(119, 'Sun', '2021-07-25'),
(120, 'Sat', '2021-07-31'),
(121, 'Sun', '2021-08-01'),
(122, 'Sat', '2021-08-07'),
(123, 'Sun', '2021-08-08'),
(124, 'Sat', '2021-08-14'),
(125, 'Sun', '2021-08-15'),
(126, 'Sat', '2021-08-21'),
(127, 'Sun', '2021-08-22'),
(128, 'Sat', '2021-08-28'),
(129, 'Sun', '2021-08-29'),
(130, 'Sat', '2021-09-04'),
(131, 'Sun', '2021-09-05'),
(132, 'Sat', '2021-09-11'),
(133, 'Sun', '2021-09-12'),
(134, 'Sat', '2021-09-18'),
(135, 'Sun', '2021-09-19'),
(136, 'Sat', '2021-09-25'),
(137, 'Sun', '2021-09-26'),
(138, 'Sat', '2021-10-02'),
(139, 'Sun', '2021-10-03'),
(140, 'Sat', '2021-10-09'),
(141, 'Sun', '2021-10-10'),
(142, 'Sat', '2021-10-16'),
(143, 'Sun', '2021-10-17'),
(144, 'Sat', '2021-10-23'),
(145, 'Sun', '2021-10-24'),
(146, 'Sat', '2021-10-30'),
(147, 'Sun', '2021-10-31'),
(148, 'Sat', '2021-11-06'),
(149, 'Sun', '2021-11-07'),
(150, 'Sat', '2021-11-13'),
(151, 'Sun', '2021-11-14'),
(152, 'Sat', '2021-11-20'),
(153, 'Sun', '2021-11-21'),
(154, 'Sat', '2021-11-27'),
(155, 'Sun', '2021-11-28'),
(156, 'Sat', '2021-12-04'),
(157, 'Sun', '2021-12-05'),
(158, 'Sat', '2021-12-11'),
(159, 'Sun', '2021-12-12'),
(160, 'Sat', '2021-12-18'),
(161, 'Sun', '2021-12-19'),
(162, 'Sat', '2021-12-25'),
(163, 'Sun', '2021-12-26'),
(164, 'Sat', '2022-01-01'),
(165, 'Sun', '2022-01-02'),
(166, 'Sat', '2022-01-08'),
(167, 'Sun', '2022-01-09'),
(168, 'Sat', '2022-01-15'),
(169, 'Sun', '2022-01-16'),
(170, 'Sat', '2022-01-22'),
(171, 'Sun', '2022-01-23'),
(172, 'Sat', '2022-01-29'),
(173, 'Sun', '2022-01-30'),
(174, 'Sat', '2022-02-05'),
(175, 'Sun', '2022-02-06'),
(176, 'Sat', '2022-02-12'),
(177, 'Sun', '2022-02-13'),
(178, 'Sat', '2022-02-19'),
(179, 'Sun', '2022-02-20'),
(180, 'Sat', '2022-02-26'),
(181, 'Sun', '2022-02-27'),
(182, 'Sat', '2022-03-05'),
(183, 'Sun', '2022-03-06'),
(184, 'Sat', '2022-03-12'),
(185, 'Sun', '2022-03-13'),
(186, 'Sat', '2022-03-19'),
(187, 'Sun', '2022-03-20'),
(188, 'Sat', '2022-03-26'),
(189, 'Sun', '2022-03-27'),
(190, 'Sat', '2022-04-02'),
(191, 'Sun', '2022-04-03'),
(192, 'Sat', '2022-04-09'),
(193, 'Sun', '2022-04-10'),
(194, 'Sat', '2022-04-16'),
(195, 'Sun', '2022-04-17'),
(196, 'Sat', '2022-04-23'),
(197, 'Sun', '2022-04-24'),
(198, 'Sat', '2022-04-30'),
(199, 'Sun', '2022-05-01'),
(200, 'Sat', '2022-05-07'),
(201, 'Sun', '2022-05-08'),
(202, 'Sat', '2022-05-14'),
(203, 'Sun', '2022-05-15'),
(204, 'Sat', '2022-05-21'),
(205, 'Sun', '2022-05-22'),
(206, 'Sat', '2022-05-28'),
(207, 'Sun', '2022-05-29'),
(208, 'Sat', '2022-06-04'),
(209, 'Sun', '2022-06-05'),
(210, 'Sat', '2022-06-11'),
(211, 'Sun', '2022-06-12'),
(212, 'Sat', '2022-06-18'),
(213, 'Sun', '2022-06-19'),
(214, 'Sat', '2022-06-25'),
(215, 'Sun', '2022-06-26'),
(216, 'Sat', '2022-07-02'),
(217, 'Sun', '2022-07-03'),
(218, 'Sat', '2022-07-09'),
(219, 'Sun', '2022-07-10'),
(220, 'Sat', '2022-07-16'),
(221, 'Sun', '2022-07-17'),
(222, 'Sat', '2022-07-23'),
(223, 'Sun', '2022-07-24'),
(224, 'Sat', '2022-07-30'),
(225, 'Sun', '2022-07-31'),
(226, 'Sat', '2022-08-06'),
(227, 'Sun', '2022-08-07'),
(228, 'Sat', '2022-08-13'),
(229, 'Sun', '2022-08-14'),
(230, 'Sat', '2022-08-20'),
(231, 'Sun', '2022-08-21'),
(232, 'Sat', '2022-08-27'),
(233, 'Sun', '2022-08-28'),
(234, 'Sat', '2022-09-03'),
(235, 'Sun', '2022-09-04'),
(236, 'Sat', '2022-09-10'),
(237, 'Sun', '2022-09-11'),
(238, 'Sat', '2022-09-17'),
(239, 'Sun', '2022-09-18'),
(240, 'Sat', '2022-09-24'),
(241, 'Sun', '2022-09-25'),
(242, 'Sat', '2022-10-01'),
(243, 'Sun', '2022-10-02'),
(244, 'Sat', '2022-10-08'),
(245, 'Sun', '2022-10-09'),
(246, 'Sat', '2022-10-15'),
(247, 'Sun', '2022-10-16'),
(248, 'Sat', '2022-10-22'),
(249, 'Sun', '2022-10-23'),
(250, 'Sat', '2022-10-29'),
(251, 'Sun', '2022-10-30'),
(252, 'Sat', '2022-11-05'),
(253, 'Sun', '2022-11-06'),
(254, 'Sat', '2022-11-12'),
(255, 'Sun', '2022-11-13'),
(256, 'Sat', '2022-11-19'),
(257, 'Sun', '2022-11-20'),
(258, 'Sat', '2022-11-26'),
(259, 'Sun', '2022-11-27'),
(260, 'Sat', '2022-12-03'),
(261, 'Sun', '2022-12-04'),
(262, 'Sat', '2022-12-10'),
(263, 'Sun', '2022-12-11'),
(264, 'Sat', '2022-12-17'),
(265, 'Sun', '2022-12-18'),
(266, 'Sat', '2022-12-24'),
(267, 'Sun', '2022-12-25'),
(268, 'Sat', '2022-12-31'),
(269, 'Sun', '2023-01-01'),
(270, 'Sat', '2023-01-07'),
(271, 'Sun', '2023-01-08'),
(272, 'Sat', '2023-01-14'),
(273, 'Sun', '2023-01-15'),
(274, 'Sat', '2023-01-21'),
(275, 'Sun', '2023-01-22'),
(276, 'Sat', '2023-01-28'),
(277, 'Sun', '2023-01-29'),
(278, 'Sat', '2023-02-04'),
(279, 'Sun', '2023-02-05'),
(280, 'Sat', '2023-02-11'),
(281, 'Sun', '2023-02-12'),
(282, 'Sat', '2023-02-18'),
(283, 'Sun', '2023-02-19'),
(284, 'Sat', '2023-02-25'),
(285, 'Sun', '2023-02-26'),
(286, 'Sat', '2023-03-04'),
(287, 'Sun', '2023-03-05'),
(288, 'Sat', '2023-03-11'),
(289, 'Sun', '2023-03-12'),
(290, 'Sat', '2023-03-18'),
(291, 'Sun', '2023-03-19'),
(292, 'Sat', '2023-03-25'),
(293, 'Sun', '2023-03-26'),
(294, 'Sat', '2023-04-01'),
(295, 'Sun', '2023-04-02'),
(296, 'Sat', '2023-04-08'),
(297, 'Sun', '2023-04-09'),
(298, 'Sat', '2023-04-15'),
(299, 'Sun', '2023-04-16'),
(300, 'Sat', '2023-04-22'),
(301, 'Sun', '2023-04-23'),
(302, 'Sat', '2023-04-29'),
(303, 'Sun', '2023-04-30'),
(304, 'Sat', '2023-05-06'),
(305, 'Sun', '2023-05-07'),
(306, 'Sat', '2023-05-13'),
(307, 'Sun', '2023-05-14'),
(308, 'Sat', '2023-05-20'),
(309, 'Sun', '2023-05-21'),
(310, 'Sat', '2023-05-27'),
(311, 'Sun', '2023-05-28'),
(312, 'Sat', '2023-06-03'),
(313, 'Sun', '2023-06-04'),
(314, 'Sat', '2023-06-10'),
(315, 'Sun', '2023-06-11'),
(316, 'Sat', '2023-06-17'),
(317, 'Sun', '2023-06-18'),
(318, 'Sat', '2023-06-24'),
(319, 'Sun', '2023-06-25'),
(320, 'Sat', '2023-07-01'),
(321, 'Sun', '2023-07-02'),
(322, 'Sat', '2023-07-08'),
(323, 'Sun', '2023-07-09'),
(324, 'Sat', '2023-07-15'),
(325, 'Sun', '2023-07-16'),
(326, 'Sat', '2023-07-22'),
(327, 'Sun', '2023-07-23'),
(328, 'Sat', '2023-07-29'),
(329, 'Sun', '2023-07-30'),
(330, 'Sat', '2023-08-05'),
(331, 'Sun', '2023-08-06'),
(332, 'Sat', '2023-08-12'),
(333, 'Sun', '2023-08-13'),
(334, 'Sat', '2023-08-19'),
(335, 'Sun', '2023-08-20'),
(336, 'Sat', '2023-08-26'),
(337, 'Sun', '2023-08-27'),
(338, 'Sat', '2023-09-02'),
(339, 'Sun', '2023-09-03'),
(340, 'Sat', '2023-09-09'),
(341, 'Sun', '2023-09-10'),
(342, 'Sat', '2023-09-16'),
(343, 'Sun', '2023-09-17'),
(344, 'Sat', '2023-09-23'),
(345, 'Sun', '2023-09-24'),
(346, 'Sat', '2023-09-30'),
(347, 'Sun', '2023-10-01'),
(348, 'Sat', '2023-10-07'),
(349, 'Sun', '2023-10-08'),
(350, 'Sat', '2023-10-14'),
(351, 'Sun', '2023-10-15'),
(352, 'Sat', '2023-10-21'),
(353, 'Sun', '2023-10-22'),
(354, 'Sat', '2023-10-28'),
(355, 'Sun', '2023-10-29'),
(356, 'Sat', '2023-11-04'),
(357, 'Sun', '2023-11-05'),
(358, 'Sat', '2023-11-11'),
(359, 'Sun', '2023-11-12'),
(360, 'Sat', '2023-11-18'),
(361, 'Sun', '2023-11-19'),
(362, 'Sat', '2023-11-25'),
(363, 'Sun', '2023-11-26'),
(364, 'Sat', '2023-12-02'),
(365, 'Sun', '2023-12-03'),
(366, 'Sat', '2023-12-09'),
(367, 'Sun', '2023-12-10'),
(368, 'Sat', '2023-12-16'),
(369, 'Sun', '2023-12-17'),
(370, 'Sat', '2023-12-23'),
(371, 'Sun', '2023-12-24'),
(372, 'Sat', '2023-12-30'),
(373, 'Sun', '2023-12-31'),
(374, 'Sat', '2024-01-06'),
(375, 'Sun', '2024-01-07'),
(376, 'Sat', '2024-01-13'),
(377, 'Sun', '2024-01-14'),
(378, 'Sat', '2024-01-20'),
(379, 'Sun', '2024-01-21'),
(380, 'Sat', '2024-01-27'),
(381, 'Sun', '2024-01-28'),
(382, 'Sat', '2024-02-03'),
(383, 'Sun', '2024-02-04'),
(384, 'Sat', '2024-02-10'),
(385, 'Sun', '2024-02-11'),
(386, 'Sat', '2024-02-17'),
(387, 'Sun', '2024-02-18'),
(388, 'Sat', '2024-02-24'),
(389, 'Sun', '2024-02-25'),
(390, 'Sat', '2024-03-02'),
(391, 'Sun', '2024-03-03'),
(392, 'Sat', '2024-03-09'),
(393, 'Sun', '2024-03-10'),
(394, 'Sat', '2024-03-16'),
(395, 'Sun', '2024-03-17'),
(396, 'Sat', '2024-03-23'),
(397, 'Sun', '2024-03-24'),
(398, 'Sat', '2024-03-30'),
(399, 'Sun', '2024-03-31'),
(400, 'Sat', '2024-04-06'),
(401, 'Sun', '2024-04-07'),
(402, 'Sat', '2024-04-13'),
(403, 'Sun', '2024-04-14'),
(404, 'Sat', '2024-04-20'),
(405, 'Sun', '2024-04-21'),
(406, 'Sat', '2024-04-27'),
(407, 'Sun', '2024-04-28'),
(408, 'Sat', '2024-05-04'),
(409, 'Sun', '2024-05-05'),
(410, 'Sat', '2024-05-11'),
(411, 'Sun', '2024-05-12'),
(412, 'Sat', '2024-05-18'),
(413, 'Sun', '2024-05-19'),
(414, 'Sat', '2024-05-25'),
(415, 'Sun', '2024-05-26'),
(416, 'Sat', '2024-06-01'),
(417, 'Sun', '2024-06-02'),
(418, 'Sat', '2024-06-08'),
(419, 'Sun', '2024-06-09'),
(420, 'Sat', '2024-06-15'),
(421, 'Sun', '2024-06-16'),
(422, 'Sat', '2024-06-22'),
(423, 'Sun', '2024-06-23'),
(424, 'Sat', '2024-06-29'),
(425, 'Sun', '2024-06-30'),
(426, 'Sat', '2024-07-06'),
(427, 'Sun', '2024-07-07'),
(428, 'Sat', '2024-07-13'),
(429, 'Sun', '2024-07-14'),
(430, 'Sat', '2024-07-20'),
(431, 'Sun', '2024-07-21'),
(432, 'Sat', '2024-07-27'),
(433, 'Sun', '2024-07-28'),
(434, 'Sat', '2024-08-03'),
(435, 'Sun', '2024-08-04'),
(436, 'Sat', '2024-08-10'),
(437, 'Sun', '2024-08-11'),
(438, 'Sat', '2024-08-17'),
(439, 'Sun', '2024-08-18'),
(440, 'Sat', '2024-08-24'),
(441, 'Sun', '2024-08-25'),
(442, 'Sat', '2024-08-31'),
(443, 'Sun', '2024-09-01'),
(444, 'Sat', '2024-09-07'),
(445, 'Sun', '2024-09-08'),
(446, 'Sat', '2024-09-14'),
(447, 'Sun', '2024-09-15'),
(448, 'Sat', '2024-09-21'),
(449, 'Sun', '2024-09-22'),
(450, 'Sat', '2024-09-28'),
(451, 'Sun', '2024-09-29'),
(452, 'Sat', '2024-10-05'),
(453, 'Sun', '2024-10-06'),
(454, 'Sat', '2024-10-12'),
(455, 'Sun', '2024-10-13'),
(456, 'Sat', '2024-10-19'),
(457, 'Sun', '2024-10-20'),
(458, 'Sat', '2024-10-26'),
(459, 'Sun', '2024-10-27'),
(460, 'Sat', '2024-11-02'),
(461, 'Sun', '2024-11-03'),
(462, 'Sat', '2024-11-09'),
(463, 'Sun', '2024-11-10'),
(464, 'Sat', '2024-11-16'),
(465, 'Sun', '2024-11-17'),
(466, 'Sat', '2024-11-23'),
(467, 'Sun', '2024-11-24'),
(468, 'Sat', '2024-11-30'),
(469, 'Sun', '2024-12-01'),
(470, 'Sat', '2024-12-07'),
(471, 'Sun', '2024-12-08'),
(472, 'Sat', '2024-12-14'),
(473, 'Sun', '2024-12-15'),
(474, 'Sat', '2024-12-21'),
(475, 'Sun', '2024-12-22'),
(476, 'Sat', '2024-12-28'),
(477, 'Sun', '2024-12-29'),
(478, 'Sat', '2025-01-04'),
(479, 'Sun', '2025-01-05'),
(480, 'Sat', '2025-01-11'),
(481, 'Sun', '2025-01-12'),
(482, 'Sat', '2025-01-18'),
(483, 'Sun', '2025-01-19'),
(484, 'Sat', '2025-01-25'),
(485, 'Sun', '2025-01-26'),
(486, 'Sat', '2025-02-01'),
(487, 'Sun', '2025-02-02'),
(488, 'Sat', '2025-02-08'),
(489, 'Sun', '2025-02-09'),
(490, 'Sat', '2025-02-15'),
(491, 'Sun', '2025-02-16'),
(492, 'Sat', '2025-02-22'),
(493, 'Sun', '2025-02-23'),
(494, 'Sat', '2025-03-01'),
(495, 'Sun', '2025-03-02'),
(496, 'Sat', '2025-03-08'),
(497, 'Sun', '2025-03-09'),
(498, 'Sat', '2025-03-15'),
(499, 'Sun', '2025-03-16'),
(500, 'Sat', '2025-03-22'),
(501, 'Sun', '2025-03-23'),
(502, 'Sat', '2025-03-29'),
(503, 'Sun', '2025-03-30'),
(504, 'Sat', '2025-04-05'),
(505, 'Sun', '2025-04-06'),
(506, 'Sat', '2025-04-12'),
(507, 'Sun', '2025-04-13'),
(508, 'Sat', '2025-04-19'),
(509, 'Sun', '2025-04-20'),
(510, 'Sat', '2025-04-26'),
(511, 'Sun', '2025-04-27'),
(512, 'Sat', '2025-05-03'),
(513, 'Sun', '2025-05-04'),
(514, 'Sat', '2025-05-10'),
(515, 'Sun', '2025-05-11'),
(516, 'Sat', '2025-05-17'),
(517, 'Sun', '2025-05-18'),
(518, 'Sat', '2025-05-24'),
(519, 'Sun', '2025-05-25'),
(520, 'Sat', '2025-05-31'),
(521, 'Sun', '2025-06-01'),
(522, 'Sat', '2025-06-07'),
(523, 'Sun', '2025-06-08'),
(524, 'Sat', '2025-06-14'),
(525, 'Sun', '2025-06-15'),
(526, 'Sat', '2025-06-21'),
(527, 'Sun', '2025-06-22'),
(528, 'Sat', '2025-06-28'),
(529, 'Sun', '2025-06-29'),
(530, 'Sat', '2025-07-05'),
(531, 'Sun', '2025-07-06'),
(532, 'Sat', '2025-07-12'),
(533, 'Sun', '2025-07-13'),
(534, 'Sat', '2025-07-19'),
(535, 'Sun', '2025-07-20'),
(536, 'Sat', '2025-07-26'),
(537, 'Sun', '2025-07-27'),
(538, 'Sat', '2025-08-02'),
(539, 'Sun', '2025-08-03'),
(540, 'Sat', '2025-08-09'),
(541, 'Sun', '2025-08-10'),
(542, 'Sat', '2025-08-16'),
(543, 'Sun', '2025-08-17'),
(544, 'Sat', '2025-08-23'),
(545, 'Sun', '2025-08-24'),
(546, 'Sat', '2025-08-30'),
(547, 'Sun', '2025-08-31'),
(548, 'Sat', '2025-09-06'),
(549, 'Sun', '2025-09-07'),
(550, 'Sat', '2025-09-13'),
(551, 'Sun', '2025-09-14'),
(552, 'Sat', '2025-09-20'),
(553, 'Sun', '2025-09-21'),
(554, 'Sat', '2025-09-27'),
(555, 'Sun', '2025-09-28'),
(556, 'Sat', '2025-10-04'),
(557, 'Sun', '2025-10-05'),
(558, 'Sat', '2025-10-11'),
(559, 'Sun', '2025-10-12'),
(560, 'Sat', '2025-10-18'),
(561, 'Sun', '2025-10-19'),
(562, 'Sat', '2025-10-25'),
(563, 'Sun', '2025-10-26'),
(564, 'Sat', '2025-11-01'),
(565, 'Sun', '2025-11-02'),
(566, 'Sat', '2025-11-08'),
(567, 'Sun', '2025-11-09'),
(568, 'krishna jayanthi', '2020-08-11');

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

--
-- Table structure for table `invest_amount`
--

CREATE TABLE IF NOT EXISTS `invest_amount` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mem_id` varchar(155) NOT NULL,
  `Amount` int(11) NOT NULL,
  `ROI` decimal(11,2) NOT NULL DEFAULT '0.00',
  `ROI_Day` int(11) DEFAULT '0',
  `I_Type` varchar(155) NOT NULL,
  `G_Days` int(11) NOT NULL DEFAULT '0',
  `G_Income` int(11) NOT NULL DEFAULT '0',
  `G_Total` int(11) NOT NULL DEFAULT '0',
  `jdate` date NOT NULL,
  `g_date` date NOT NULL,
  `status` int(11) NOT NULL,
  `D_Status` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=30 ;

--
-- Dumping data for table `invest_amount`
--

INSERT INTO `invest_amount` (`id`, `mem_id`, `Amount`, `ROI`, `ROI_Day`, `I_Type`, `G_Days`, `G_Income`, `G_Total`, `jdate`, `g_date`, `status`, `D_Status`) VALUES
(1, 'GBC210101', 3000, '0.00', 0, '', 0, 0, 0, '2021-04-08', '0000-00-00', 0, 0),
(2, 'GBC210102', 3000, '0.00', 0, '', 0, 0, 0, '2021-04-08', '2021-04-08', 0, 0),
(3, 'GBC210103', 3000, '0.00', 0, '', 0, 0, 0, '2021-04-08', '2021-04-08', 0, 0),
(4, 'GBC210104', 3000, '0.00', 0, '', 0, 0, 0, '2021-04-08', '2021-04-08', 0, 0),
(5, 'GBC210105', 3000, '0.00', 0, '', 0, 0, 0, '2021-04-08', '2021-04-08', 0, 0),
(6, 'GBC210106', 3000, '0.00', 0, '', 0, 0, 0, '2021-04-08', '2021-04-08', 0, 0),
(7, 'GBC210107', 3000, '0.00', 0, '', 0, 0, 0, '2021-04-08', '2021-04-08', 0, 0),
(8, 'GBC542055', 3000, '0.00', 0, '', 0, 0, 0, '2021-04-09', '2021-04-09', 0, 0),
(9, 'GBC657093', 3000, '0.00', 0, '', 0, 0, 0, '2021-04-09', '2021-04-09', 0, 0),
(10, 'GBC698810', 3000, '0.00', 0, '', 0, 0, 0, '2021-04-10', '2021-04-10', 0, 0),
(11, 'GBC411550', 3000, '0.00', 0, '', 0, 0, 0, '2021-04-10', '2021-04-10', 0, 0),
(12, 'GBC529374', 3000, '0.00', 0, '', 0, 0, 0, '2021-04-10', '2021-04-10', 0, 0),
(13, 'GBC775662', 3000, '0.00', 0, '', 0, 0, 0, '2021-04-10', '2021-04-10', 0, 0),
(14, 'GBC642362', 3000, '0.00', 0, '', 0, 0, 0, '2021-04-10', '2021-04-10', 0, 0),
(15, 'GBC364758', 3000, '0.00', 0, '', 0, 0, 0, '2021-04-10', '2021-04-10', 0, 0),
(16, 'GBC687093', 3000, '0.00', 0, '', 0, 0, 0, '2021-04-10', '2021-04-10', 0, 0),
(17, 'GBC260175', 3000, '0.00', 0, '', 0, 0, 0, '2021-04-10', '2021-04-10', 0, 0),
(18, 'GBC287633', 3000, '0.00', 0, '', 0, 0, 0, '2021-04-10', '2021-04-10', 0, 0),
(19, 'GBC258564', 3000, '0.00', 0, '', 0, 0, 0, '2021-04-10', '2021-04-10', 0, 0),
(20, 'GBC743888', 3000, '0.00', 0, '', 0, 0, 0, '2021-04-10', '2021-04-10', 0, 0),
(21, 'GBC219500', 3000, '0.00', 0, '', 0, 0, 0, '2021-04-10', '2021-04-10', 0, 0),
(22, 'GBC866709', 3000, '0.00', 0, '', 0, 0, 0, '2021-04-10', '2021-04-10', 0, 0),
(23, 'GBC715420', 3000, '0.00', 0, '', 0, 0, 0, '2021-04-10', '2021-04-10', 0, 0),
(24, 'GBC797607', 3000, '0.00', 0, '', 0, 0, 0, '2021-04-10', '2021-04-10', 0, 0),
(25, 'GBC119615', 3000, '0.00', 0, '', 0, 0, 0, '2021-04-10', '2021-04-10', 0, 0),
(26, 'GBC561947', 3000, '0.00', 0, '', 0, 0, 0, '2021-04-10', '2021-04-10', 0, 0),
(27, 'GBC724685', 3000, '0.00', 0, '', 0, 0, 0, '2021-04-10', '2021-04-10', 0, 0),
(28, 'GBC178972', 3000, '0.00', 0, '', 0, 0, 0, '2021-04-10', '2021-04-10', 0, 0),
(29, 'GBC791949', 3000, '0.00', 0, '', 0, 0, 0, '2021-04-19', '2021-04-19', 0, 0);

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

--
-- Table structure for table `mail`
--

CREATE TABLE IF NOT EXISTS `mail` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `M_Type` varchar(155) NOT NULL,
  `Subject` varchar(155) NOT NULL,
  `F_ID` varchar(155) NOT NULL,
  `T_ID` varchar(155) NOT NULL,
  `Message` text NOT NULL,
  `jdate` date NOT NULL,
  `Status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `news`
--

CREATE TABLE IF NOT EXISTS `news` (
  `SId` bigint(20) NOT NULL AUTO_INCREMENT,
  `Title` varchar(250) NOT NULL,
  `ShortDescription` text NOT NULL,
  `Status` varchar(155) NOT NULL DEFAULT '1',
  `Deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`SId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `package`
--

CREATE TABLE IF NOT EXISTS `package` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `Name` varchar(50) NOT NULL,
  `Amount` int(11) NOT NULL DEFAULT '0',
  `BV` int(11) NOT NULL,
  `CV` int(11) NOT NULL DEFAULT '0',
  `ROI` decimal(11,2) NOT NULL DEFAULT '0.00',
  `ROI_Day` int(11) NOT NULL DEFAULT '0',
  `Status` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;

--
-- Dumping data for table `package`
--

INSERT INTO `package` (`id`, `Name`, `Amount`, `BV`, `CV`, `ROI`, `ROI_Day`, `Status`) VALUES
(1, 'Package 3000', 3000, 1, 0, '0.00', 0, 0);

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

--
-- Table structure for table `payout`
--

CREATE TABLE IF NOT EXISTS `payout` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `mem_id` varchar(250) DEFAULT NULL,
  `NowLeft` int(11) NOT NULL,
  `NowRight` int(11) NOT NULL,
  `Pair` int(11) NOT NULL,
  `pamt` decimal(11,2) NOT NULL DEFAULT '0.00',
  `ceiling` int(11) NOT NULL,
  `Amount` int(11) NOT NULL,
  `tds` decimal(11,2) NOT NULL,
  `sc` decimal(11,2) NOT NULL,
  `jdate` date DEFAULT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `payout_report`
--

CREATE TABLE IF NOT EXISTS `payout_report` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mem_id` varchar(155) NOT NULL,
  `B_Amount` int(11) NOT NULL DEFAULT '0',
  `DR_Amount` int(11) NOT NULL DEFAULT '0',
  `ROI_Amount` int(11) NOT NULL DEFAULT '0',
  `Amount` int(11) NOT NULL DEFAULT '0',
  `tds` decimal(11,2) NOT NULL DEFAULT '0.00',
  `sc` decimal(11,2) NOT NULL DEFAULT '0.00',
  `jdate` date NOT NULL,
  `A_Status` int(11) NOT NULL DEFAULT '0',
  `status` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `pinnumber`
--

CREATE TABLE IF NOT EXISTS `pinnumber` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `pin_refference` varchar(155) NOT NULL,
  `pinnumber` varchar(250) DEFAULT NULL,
  `product_id` int(11) NOT NULL,
  `mem_id` varchar(150) NOT NULL,
  `pin_user_id` varchar(150) NOT NULL,
  `pin_gen_jdate` date NOT NULL,
  `pin_used_jdate` date NOT NULL,
  `P_Type` varchar(155) NOT NULL,
  `Payment_Type` varchar(155) NOT NULL,
  `status` int(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=208 ;

--
-- Dumping data for table `pinnumber`
--

INSERT INTO `pinnumber` (`id`, `pin_refference`, `pinnumber`, `product_id`, `mem_id`, `pin_user_id`, `pin_gen_jdate`, `pin_used_jdate`, `P_Type`, `Payment_Type`, `status`) VALUES
(1, '', '10521199822021-04-08', 1, 'GBC210101', 'GBC347039', '2021-04-08', '2021-04-08', '', '', 1),
(2, '', '10328028182021-04-08', 1, 'GBC210101', 'GBC124445', '2021-04-08', '2021-04-08', '', '', 1),
(3, '', '4334656612021-04-08', 1, 'GBC210101', 'GBC803951', '2021-04-08', '2021-04-08', '', '', 1),
(4, '', '20271777342021-04-08', 1, 'GBC210101', 'GBC933487', '2021-04-08', '2021-04-08', '', '', 1),
(5, '', '11856385852021-04-08', 1, 'GBC210101', 'GBC782880', '2021-04-08', '2021-04-08', '', '', 1),
(6, '', '21186525962021-04-08', 1, 'GBC210101', 'GBC354695', '2021-04-08', '2021-04-08', '', '', 1),
(7, '', '7889787512021-04-08', 1, 'GBC210101', '', '2021-04-08', '0000-00-00', '', '', 0),
(8, '', '21180919382021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(9, '', '18314798192021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(10, '', '11680391372021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(11, '', '20070908742021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(12, '', '14080575322021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(13, '', '8928746662021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(14, '', '7606519372021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(15, '', '4004823132021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(16, '', '6524206412021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(17, '', '2819789492021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(18, '', '19129805182021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(19, '', '15136394832021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(20, '', '12698692332021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(21, '', '14129374832021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(22, '', '20627522522021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(23, '', '8457520432021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(24, '', '398809082021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(25, '', '13998651382021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(26, '', '5950938482021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(27, '', '6468257422021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(28, '', '3115694952021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(29, '', '4937230632021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(30, '', '21056431652021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(31, '', '21426979192021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(32, '', '20173307672021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(33, '', '16960247412021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(34, '', '4532633802021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(35, '', '8252998072021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(36, '', '15145067432021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(37, '', '17551139842021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(38, '', '21312437302021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(39, '', '15677681602021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(40, '', '18413324262021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(41, '', '12355764282021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(42, '', '8326882132021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(43, '', '14937720722021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(44, '', '2983521622021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(45, '', '20391666632021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(46, '', '5645178392021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(47, '', '4386568632021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(48, '', '21110593832021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(49, '', '11614985512021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(50, '', '3955889762021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(51, '', '15360938442021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(52, '', '16540877272021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(53, '', '2880389322021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(54, '', '9033068522021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(55, '', '9753867882021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(56, '', '15105914482021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(57, '', '20558114322021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(58, '', '3023892322021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(59, '', '3892469402021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(60, '', '1932486832021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(61, '', '17970873292021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(62, '', '5856828102021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(63, '', '19618695122021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(64, '', '3084980802021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(65, '', '14400404112021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(66, '', '15832654222021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(67, '', '13864532232021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(68, '', '21237023772021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(69, '', '1109116182021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(70, '', '14792123252021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(71, '', '7929197882021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(72, '', '13816227432021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(73, '', '7387816802021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(74, '', '9274586412021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(75, '', '4971615432021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(76, '', '6472673592021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(77, '', '14466161472021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(78, '', '19211300532021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(79, '', '13126860132021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(80, '', '20481216432021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(81, '', '10261544982021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(82, '', '7011733442021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(83, '', '9173655322021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(84, '', '18844230622021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(85, '', '13288111692021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(86, '', '18638810112021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(87, '', '12114197072021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(88, '', '20272081382021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(89, '', '6592714322021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(90, '', '20298743122021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(91, '', '268481462021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(92, '', '1160179112021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(93, '', '3107536742021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(94, '', '1853457762021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(95, '', '5436941302021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(96, '', '8944969172021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(97, '', '17733878312021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(98, '', '483667262021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(99, '', '17984751072021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(100, '', '2909820842021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(101, '', '5716833332021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(102, '', '12607944302021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(103, '', '10761810802021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(104, '', '9086086122021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(105, '', '17277556032021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(106, '', '5852120592021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(107, '', '8796139462021-04-09', 1, 'GBC210101', '', '2021-04-09', '0000-00-00', '', '', 0),
(108, '', '16122539842021-04-09', 1, 'GBC210104', 'GBC542055', '2021-04-09', '2021-04-09', '', '', 1),
(109, '', '14004562942021-04-09', 1, 'GBC210104', 'GBC657093', '2021-04-09', '2021-04-09', '', '', 1),
(110, '', '682556962021-04-09', 1, 'GBC210104', 'GBC698810', '2021-04-09', '2021-04-10', '', '', 1),
(111, '', '17655070582021-04-09', 1, 'GBC210104', 'GBC411550', '2021-04-09', '2021-04-10', '', '', 1),
(112, '', '9345122272021-04-09', 1, 'GBC210104', 'GBC529374', '2021-04-09', '2021-04-10', '', '', 1),
(113, '', '2158650632021-04-09', 1, 'GBC210104', 'GBC775662', '2021-04-09', '2021-04-10', '', '', 1),
(114, '', '5437048522021-04-09', 1, 'GBC210104', 'GBC642362', '2021-04-09', '2021-04-10', '', '', 1),
(115, '', '4357350492021-04-09', 1, 'GBC210104', 'GBC364758', '2021-04-09', '2021-04-10', '', '', 1),
(116, '', '4844086892021-04-09', 1, 'GBC210104', 'GBC687093', '2021-04-09', '2021-04-10', '', '', 1),
(117, '', '3103758852021-04-09', 1, 'GBC210104', 'GBC260175', '2021-04-09', '2021-04-10', '', '', 1),
(118, '', '5639291242021-04-09', 1, 'GBC210104', 'GBC287633', '2021-04-09', '2021-04-10', '', '', 1),
(119, '', '16100586902021-04-09', 1, 'GBC210104', 'GBC258564', '2021-04-09', '2021-04-10', '', '', 1),
(120, '', '3312565922021-04-09', 1, 'GBC210104', 'GBC743888', '2021-04-09', '2021-04-10', '', '', 1),
(121, '', '14528633272021-04-09', 1, 'GBC210104', 'GBC219500', '2021-04-09', '2021-04-10', '', '', 1),
(122, '', '7420581342021-04-09', 1, 'GBC210104', 'GBC866709', '2021-04-09', '2021-04-10', '', '', 1),
(123, '', '14592510442021-04-09', 1, 'GBC210104', 'GBC715420', '2021-04-09', '2021-04-10', '', '', 1),
(124, '', '5717070762021-04-09', 1, 'GBC210104', 'GBC797607', '2021-04-09', '2021-04-10', '', '', 1),
(125, '', '1546959442021-04-09', 1, 'GBC210104', 'GBC119615', '2021-04-09', '2021-04-10', '', '', 1),
(126, '', '21384817332021-04-09', 1, 'GBC210104', 'GBC561947', '2021-04-09', '2021-04-10', '', '', 1),
(127, '', '16936226632021-04-09', 1, 'GBC210104', 'GBC724685', '2021-04-09', '2021-04-10', '', '', 1),
(128, '', '500706222021-04-09', 1, 'GBC210104', 'GBC178972', '2021-04-09', '2021-04-10', '', '', 1),
(129, '', '16350582332021-04-09', 1, 'GBC210104', 'GBC791949', '2021-04-09', '2021-04-19', '', '', 1),
(130, '', '7516671302021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(131, '', '18028105902021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(132, '', '21029785062021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(133, '', '6778967852021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(134, '', '18986197332021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(135, '', '13189239442021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(136, '', '13458935112021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(137, '', '5281899322021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(138, '', '16101752021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(139, '', '20579899382021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(140, '', '3815253052021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(141, '', '7941781442021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(142, '', '5313635742021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(143, '', '10546470802021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(144, '', '18602793382021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(145, '', '17891221382021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(146, '', '5022173792021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(147, '', '3248420682021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(148, '', '20759885722021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(149, '', '17046750192021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(150, '', '11629671382021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(151, '', '14341012382021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(152, '', '17829267922021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(153, '', '8981324522021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(154, '', '16857412462021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(155, '', '18245217172021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(156, '', '7033999392021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(157, '', '4500554682021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(158, '', '4293688442021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(159, '', '13548445672021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(160, '', '12115934322021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(161, '', '18377831402021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(162, '', '21108266422021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(163, '', '17457827182021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(164, '', '7993094022021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(165, '', '18936194692021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(166, '', '20683530012021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(167, '', '15115062552021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(168, '', '6472645302021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(169, '', '6588143242021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(170, '', '6283601402021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(171, '', '17822125832021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(172, '', '21361527732021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(173, '', '17589028642021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(174, '', '19669340982021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(175, '', '16271502292021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(176, '', '11028429962021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(177, '', '14349804412021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(178, '', '15265068552021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(179, '', '16085705682021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(180, '', '19289003152021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(181, '', '5095766922021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(182, '', '18499074232021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(183, '', '14015655402021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(184, '', '19737004692021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(185, '', '12808260572021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(186, '', '5712453972021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(187, '', '18009225812021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(188, '', '16265175482021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(189, '', '15840598942021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(190, '', '12147680492021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(191, '', '12638962572021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(192, '', '11789718782021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(193, '', '16321293862021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(194, '', '6099114672021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(195, '', '8060418702021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(196, '', '15986847782021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(197, '', '2859651232021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(198, '', '20511221152021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(199, '', '563582122021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(200, '', '612874262021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(201, '', '9510487182021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(202, '', '16388285222021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(203, '', '15080494302021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(204, '', '8286252762021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(205, '', '18826692132021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(206, '', '9254047352021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0),
(207, '', '15550161202021-04-09', 1, 'GBC210104', '', '2021-04-09', '0000-00-00', '', '', 0);

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

--
-- Table structure for table `pin_details`
--

CREATE TABLE IF NOT EXISTS `pin_details` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mem_id` varchar(155) NOT NULL,
  `PID` int(11) NOT NULL,
  `send_id` varchar(155) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '0',
  `jdate` date NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=208 ;

--
-- Dumping data for table `pin_details`
--

INSERT INTO `pin_details` (`id`, `mem_id`, `PID`, `send_id`, `status`, `jdate`) VALUES
(1, 'GBC210101', 0, '', 0, '2021-04-08'),
(2, 'GBC210101', 0, '', 0, '2021-04-08'),
(3, 'GBC210101', 0, '', 0, '2021-04-08'),
(4, 'GBC210101', 0, '', 0, '2021-04-08'),
(5, 'GBC210101', 0, '', 0, '2021-04-08'),
(6, 'GBC210101', 0, '', 0, '2021-04-08'),
(7, 'GBC210101', 0, '', 0, '2021-04-08'),
(8, 'GBC210101', 0, '', 0, '2021-04-09'),
(9, 'GBC210101', 0, '', 0, '2021-04-09'),
(10, 'GBC210101', 0, '', 0, '2021-04-09'),
(11, 'GBC210101', 0, '', 0, '2021-04-09'),
(12, 'GBC210101', 0, '', 0, '2021-04-09'),
(13, 'GBC210101', 0, '', 0, '2021-04-09'),
(14, 'GBC210101', 0, '', 0, '2021-04-09'),
(15, 'GBC210101', 0, '', 0, '2021-04-09'),
(16, 'GBC210101', 0, '', 0, '2021-04-09'),
(17, 'GBC210101', 0, '', 0, '2021-04-09'),
(18, 'GBC210101', 0, '', 0, '2021-04-09'),
(19, 'GBC210101', 0, '', 0, '2021-04-09'),
(20, 'GBC210101', 0, '', 0, '2021-04-09'),
(21, 'GBC210101', 0, '', 0, '2021-04-09'),
(22, 'GBC210101', 0, '', 0, '2021-04-09'),
(23, 'GBC210101', 0, '', 0, '2021-04-09'),
(24, 'GBC210101', 0, '', 0, '2021-04-09'),
(25, 'GBC210101', 0, '', 0, '2021-04-09'),
(26, 'GBC210101', 0, '', 0, '2021-04-09'),
(27, 'GBC210101', 0, '', 0, '2021-04-09'),
(28, 'GBC210101', 0, '', 0, '2021-04-09'),
(29, 'GBC210101', 0, '', 0, '2021-04-09'),
(30, 'GBC210101', 0, '', 0, '2021-04-09'),
(31, 'GBC210101', 0, '', 0, '2021-04-09'),
(32, 'GBC210101', 0, '', 0, '2021-04-09'),
(33, 'GBC210101', 0, '', 0, '2021-04-09'),
(34, 'GBC210101', 0, '', 0, '2021-04-09'),
(35, 'GBC210101', 0, '', 0, '2021-04-09'),
(36, 'GBC210101', 0, '', 0, '2021-04-09'),
(37, 'GBC210101', 0, '', 0, '2021-04-09'),
(38, 'GBC210101', 0, '', 0, '2021-04-09'),
(39, 'GBC210101', 0, '', 0, '2021-04-09'),
(40, 'GBC210101', 0, '', 0, '2021-04-09'),
(41, 'GBC210101', 0, '', 0, '2021-04-09'),
(42, 'GBC210101', 0, '', 0, '2021-04-09'),
(43, 'GBC210101', 0, '', 0, '2021-04-09'),
(44, 'GBC210101', 0, '', 0, '2021-04-09'),
(45, 'GBC210101', 0, '', 0, '2021-04-09'),
(46, 'GBC210101', 0, '', 0, '2021-04-09'),
(47, 'GBC210101', 0, '', 0, '2021-04-09'),
(48, 'GBC210101', 0, '', 0, '2021-04-09'),
(49, 'GBC210101', 0, '', 0, '2021-04-09'),
(50, 'GBC210101', 0, '', 0, '2021-04-09'),
(51, 'GBC210101', 0, '', 0, '2021-04-09'),
(52, 'GBC210101', 0, '', 0, '2021-04-09'),
(53, 'GBC210101', 0, '', 0, '2021-04-09'),
(54, 'GBC210101', 0, '', 0, '2021-04-09'),
(55, 'GBC210101', 0, '', 0, '2021-04-09'),
(56, 'GBC210101', 0, '', 0, '2021-04-09'),
(57, 'GBC210101', 0, '', 0, '2021-04-09'),
(58, 'GBC210101', 0, '', 0, '2021-04-09'),
(59, 'GBC210101', 0, '', 0, '2021-04-09'),
(60, 'GBC210101', 0, '', 0, '2021-04-09'),
(61, 'GBC210101', 0, '', 0, '2021-04-09'),
(62, 'GBC210101', 0, '', 0, '2021-04-09'),
(63, 'GBC210101', 0, '', 0, '2021-04-09'),
(64, 'GBC210101', 0, '', 0, '2021-04-09'),
(65, 'GBC210101', 0, '', 0, '2021-04-09'),
(66, 'GBC210101', 0, '', 0, '2021-04-09'),
(67, 'GBC210101', 0, '', 0, '2021-04-09'),
(68, 'GBC210101', 0, '', 0, '2021-04-09'),
(69, 'GBC210101', 0, '', 0, '2021-04-09'),
(70, 'GBC210101', 0, '', 0, '2021-04-09'),
(71, 'GBC210101', 0, '', 0, '2021-04-09'),
(72, 'GBC210101', 0, '', 0, '2021-04-09'),
(73, 'GBC210101', 0, '', 0, '2021-04-09'),
(74, 'GBC210101', 0, '', 0, '2021-04-09'),
(75, 'GBC210101', 0, '', 0, '2021-04-09'),
(76, 'GBC210101', 0, '', 0, '2021-04-09'),
(77, 'GBC210101', 0, '', 0, '2021-04-09'),
(78, 'GBC210101', 0, '', 0, '2021-04-09'),
(79, 'GBC210101', 0, '', 0, '2021-04-09'),
(80, 'GBC210101', 0, '', 0, '2021-04-09'),
(81, 'GBC210101', 0, '', 0, '2021-04-09'),
(82, 'GBC210101', 0, '', 0, '2021-04-09'),
(83, 'GBC210101', 0, '', 0, '2021-04-09'),
(84, 'GBC210101', 0, '', 0, '2021-04-09'),
(85, 'GBC210101', 0, '', 0, '2021-04-09'),
(86, 'GBC210101', 0, '', 0, '2021-04-09'),
(87, 'GBC210101', 0, '', 0, '2021-04-09'),
(88, 'GBC210101', 0, '', 0, '2021-04-09'),
(89, 'GBC210101', 0, '', 0, '2021-04-09'),
(90, 'GBC210101', 0, '', 0, '2021-04-09'),
(91, 'GBC210101', 0, '', 0, '2021-04-09'),
(92, 'GBC210101', 0, '', 0, '2021-04-09'),
(93, 'GBC210101', 0, '', 0, '2021-04-09'),
(94, 'GBC210101', 0, '', 0, '2021-04-09'),
(95, 'GBC210101', 0, '', 0, '2021-04-09'),
(96, 'GBC210101', 0, '', 0, '2021-04-09'),
(97, 'GBC210101', 0, '', 0, '2021-04-09'),
(98, 'GBC210101', 0, '', 0, '2021-04-09'),
(99, 'GBC210101', 0, '', 0, '2021-04-09'),
(100, 'GBC210101', 0, '', 0, '2021-04-09'),
(101, 'GBC210101', 0, '', 0, '2021-04-09'),
(102, 'GBC210101', 0, '', 0, '2021-04-09'),
(103, 'GBC210101', 0, '', 0, '2021-04-09'),
(104, 'GBC210101', 0, '', 0, '2021-04-09'),
(105, 'GBC210101', 0, '', 0, '2021-04-09'),
(106, 'GBC210101', 0, '', 0, '2021-04-09'),
(107, 'GBC210101', 0, '', 0, '2021-04-09'),
(108, 'GBC210104', 0, '', 0, '2021-04-09'),
(109, 'GBC210104', 0, '', 0, '2021-04-09'),
(110, 'GBC210104', 0, '', 0, '2021-04-09'),
(111, 'GBC210104', 0, '', 0, '2021-04-09'),
(112, 'GBC210104', 0, '', 0, '2021-04-09'),
(113, 'GBC210104', 0, '', 0, '2021-04-09'),
(114, 'GBC210104', 0, '', 0, '2021-04-09'),
(115, 'GBC210104', 0, '', 0, '2021-04-09'),
(116, 'GBC210104', 0, '', 0, '2021-04-09'),
(117, 'GBC210104', 0, '', 0, '2021-04-09'),
(118, 'GBC210104', 0, '', 0, '2021-04-09'),
(119, 'GBC210104', 0, '', 0, '2021-04-09'),
(120, 'GBC210104', 0, '', 0, '2021-04-09'),
(121, 'GBC210104', 0, '', 0, '2021-04-09'),
(122, 'GBC210104', 0, '', 0, '2021-04-09'),
(123, 'GBC210104', 0, '', 0, '2021-04-09'),
(124, 'GBC210104', 0, '', 0, '2021-04-09'),
(125, 'GBC210104', 0, '', 0, '2021-04-09'),
(126, 'GBC210104', 0, '', 0, '2021-04-09'),
(127, 'GBC210104', 0, '', 0, '2021-04-09'),
(128, 'GBC210104', 0, '', 0, '2021-04-09'),
(129, 'GBC210104', 0, '', 0, '2021-04-09'),
(130, 'GBC210104', 0, '', 0, '2021-04-09'),
(131, 'GBC210104', 0, '', 0, '2021-04-09'),
(132, 'GBC210104', 0, '', 0, '2021-04-09'),
(133, 'GBC210104', 0, '', 0, '2021-04-09'),
(134, 'GBC210104', 0, '', 0, '2021-04-09'),
(135, 'GBC210104', 0, '', 0, '2021-04-09'),
(136, 'GBC210104', 0, '', 0, '2021-04-09'),
(137, 'GBC210104', 0, '', 0, '2021-04-09'),
(138, 'GBC210104', 0, '', 0, '2021-04-09'),
(139, 'GBC210104', 0, '', 0, '2021-04-09'),
(140, 'GBC210104', 0, '', 0, '2021-04-09'),
(141, 'GBC210104', 0, '', 0, '2021-04-09'),
(142, 'GBC210104', 0, '', 0, '2021-04-09'),
(143, 'GBC210104', 0, '', 0, '2021-04-09'),
(144, 'GBC210104', 0, '', 0, '2021-04-09'),
(145, 'GBC210104', 0, '', 0, '2021-04-09'),
(146, 'GBC210104', 0, '', 0, '2021-04-09'),
(147, 'GBC210104', 0, '', 0, '2021-04-09'),
(148, 'GBC210104', 0, '', 0, '2021-04-09'),
(149, 'GBC210104', 0, '', 0, '2021-04-09'),
(150, 'GBC210104', 0, '', 0, '2021-04-09'),
(151, 'GBC210104', 0, '', 0, '2021-04-09'),
(152, 'GBC210104', 0, '', 0, '2021-04-09'),
(153, 'GBC210104', 0, '', 0, '2021-04-09'),
(154, 'GBC210104', 0, '', 0, '2021-04-09'),
(155, 'GBC210104', 0, '', 0, '2021-04-09'),
(156, 'GBC210104', 0, '', 0, '2021-04-09'),
(157, 'GBC210104', 0, '', 0, '2021-04-09'),
(158, 'GBC210104', 0, '', 0, '2021-04-09'),
(159, 'GBC210104', 0, '', 0, '2021-04-09'),
(160, 'GBC210104', 0, '', 0, '2021-04-09'),
(161, 'GBC210104', 0, '', 0, '2021-04-09'),
(162, 'GBC210104', 0, '', 0, '2021-04-09'),
(163, 'GBC210104', 0, '', 0, '2021-04-09'),
(164, 'GBC210104', 0, '', 0, '2021-04-09'),
(165, 'GBC210104', 0, '', 0, '2021-04-09'),
(166, 'GBC210104', 0, '', 0, '2021-04-09'),
(167, 'GBC210104', 0, '', 0, '2021-04-09'),
(168, 'GBC210104', 0, '', 0, '2021-04-09'),
(169, 'GBC210104', 0, '', 0, '2021-04-09'),
(170, 'GBC210104', 0, '', 0, '2021-04-09'),
(171, 'GBC210104', 0, '', 0, '2021-04-09'),
(172, 'GBC210104', 0, '', 0, '2021-04-09'),
(173, 'GBC210104', 0, '', 0, '2021-04-09'),
(174, 'GBC210104', 0, '', 0, '2021-04-09'),
(175, 'GBC210104', 0, '', 0, '2021-04-09'),
(176, 'GBC210104', 0, '', 0, '2021-04-09'),
(177, 'GBC210104', 0, '', 0, '2021-04-09'),
(178, 'GBC210104', 0, '', 0, '2021-04-09'),
(179, 'GBC210104', 0, '', 0, '2021-04-09'),
(180, 'GBC210104', 0, '', 0, '2021-04-09'),
(181, 'GBC210104', 0, '', 0, '2021-04-09'),
(182, 'GBC210104', 0, '', 0, '2021-04-09'),
(183, 'GBC210104', 0, '', 0, '2021-04-09'),
(184, 'GBC210104', 0, '', 0, '2021-04-09'),
(185, 'GBC210104', 0, '', 0, '2021-04-09'),
(186, 'GBC210104', 0, '', 0, '2021-04-09'),
(187, 'GBC210104', 0, '', 0, '2021-04-09'),
(188, 'GBC210104', 0, '', 0, '2021-04-09'),
(189, 'GBC210104', 0, '', 0, '2021-04-09'),
(190, 'GBC210104', 0, '', 0, '2021-04-09'),
(191, 'GBC210104', 0, '', 0, '2021-04-09'),
(192, 'GBC210104', 0, '', 0, '2021-04-09'),
(193, 'GBC210104', 0, '', 0, '2021-04-09'),
(194, 'GBC210104', 0, '', 0, '2021-04-09'),
(195, 'GBC210104', 0, '', 0, '2021-04-09'),
(196, 'GBC210104', 0, '', 0, '2021-04-09'),
(197, 'GBC210104', 0, '', 0, '2021-04-09'),
(198, 'GBC210104', 0, '', 0, '2021-04-09'),
(199, 'GBC210104', 0, '', 0, '2021-04-09'),
(200, 'GBC210104', 0, '', 0, '2021-04-09'),
(201, 'GBC210104', 0, '', 0, '2021-04-09'),
(202, 'GBC210104', 0, '', 0, '2021-04-09'),
(203, 'GBC210104', 0, '', 0, '2021-04-09'),
(204, 'GBC210104', 0, '', 0, '2021-04-09'),
(205, 'GBC210104', 0, '', 0, '2021-04-09'),
(206, 'GBC210104', 0, '', 0, '2021-04-09'),
(207, 'GBC210104', 0, '', 0, '2021-04-09');

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

--
-- Table structure for table `pin_request`
--

CREATE TABLE IF NOT EXISTS `pin_request` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mem_id` varchar(155) NOT NULL,
  `noepin` int(11) NOT NULL,
  `P_Amount` int(11) NOT NULL,
  `Payment_Option` varchar(155) NOT NULL,
  `Payment_Type` varchar(155) NOT NULL,
  `Transaction_ID` varchar(155) NOT NULL,
  `Transaction_Detail` text NOT NULL,
  `Payment_Proof` varchar(155) NOT NULL,
  `Payment_Date` varchar(155) NOT NULL,
  `Approve_Date` varchar(155) NOT NULL,
  `Payment_Remarks` text NOT NULL,
  `Status` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `pin_request_item`
--

CREATE TABLE IF NOT EXISTS `pin_request_item` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `rID` int(11) NOT NULL DEFAULT '0',
  `package` int(11) NOT NULL DEFAULT '0',
  `noepin` int(11) NOT NULL DEFAULT '0',
  `total_amount` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `rp_payout`
--

CREATE TABLE IF NOT EXISTS `rp_payout` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mem_id` varchar(155) NOT NULL,
  `reffer` int(11) NOT NULL DEFAULT '0',
  `Amount` int(11) NOT NULL DEFAULT '0',
  `jdate` date NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS `settings` (
  `SId` bigint(20) NOT NULL AUTO_INCREMENT,
  `Company` varchar(250) NOT NULL,
  `Email` varchar(250) NOT NULL,
  `TDS` double(11,2) NOT NULL,
  `SC` double(11,2) NOT NULL,
  `pair_comm` decimal(11,2) NOT NULL,
  `Reffer` decimal(11,2) NOT NULL,
  `ROI` decimal(11,2) NOT NULL DEFAULT '0.00',
  `Status` int(11) NOT NULL,
  PRIMARY KEY (`SId`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

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

INSERT INTO `settings` (`SId`, `Company`, `Email`, `TDS`, `SC`, `pair_comm`, `Reffer`, `ROI`, `Status`) VALUES
(3, 'LFX', 'Info@learningfx.biz', 5.00, 10.00, '500.00', '0.50', '2.00', 0);

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

--
-- Table structure for table `sponsor`
--

CREATE TABLE IF NOT EXISTS `sponsor` (
  `mem_id` varchar(155) NOT NULL,
  `leftid` int(11) NOT NULL,
  `rightid` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `id` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `sponsor`
--

INSERT INTO `sponsor` (`mem_id`, `leftid`, `rightid`, `status`, `id`) VALUES
('CD100000', 1, 1, 1, 1);

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

--
-- Table structure for table `weekly_payout`
--

CREATE TABLE IF NOT EXISTS `weekly_payout` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mem_id` varchar(155) NOT NULL,
  `B_Amount` int(11) NOT NULL DEFAULT '0',
  `tds` decimal(11,2) NOT NULL DEFAULT '0.00',
  `sc` decimal(11,2) NOT NULL DEFAULT '0.00',
  `total` int(11) NOT NULL,
  `jdate` date NOT NULL,
  `A_Status` int(11) NOT NULL DEFAULT '0',
  `status` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

