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




--
-- Database: `zanjqldh_yadhe_api`
--

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

--
-- Table structure for table `dummy_img`
--

CREATE TABLE IF NOT EXISTS `dummy_img` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `img` text NOT NULL,
  `img2` text NOT NULL,
  `img3` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=22 ;

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

--
-- Table structure for table `tbl_bubble_counter`
--

CREATE TABLE IF NOT EXISTS `tbl_bubble_counter` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mobNo` varchar(255) NOT NULL,
  `bubbleCounter` int(11) NOT NULL,
  `dayNo` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;

--
-- Dumping data for table `tbl_bubble_counter`
--

INSERT INTO `tbl_bubble_counter` (`id`, `mobNo`, `bubbleCounter`, `dayNo`) VALUES
(8, '9912345675', 2, 6),
(7, '7878787878', 3, 6),
(6, '9999999999', 3, 6),
(5, '0000000000', 3, 6),
(9, '7566663274', 3, 6),
(10, '6137005794', 2, 7),
(11, '9912345671', 2, 7),
(12, '6044018787', 2, 2147483647),
(13, '16565156615', 2, 5),
(14, '77777777', 2, 5);

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

--
-- Table structure for table `tbl_chatroom`
--

CREATE TABLE IF NOT EXISTS `tbl_chatroom` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `room_nm` varchar(225) NOT NULL,
  `participants` text NOT NULL,
  `participants_no` int(11) NOT NULL,
  `recent_message` varchar(255) NOT NULL,
  `recent_time` datetime NOT NULL,
  `recent_counter` varchar(255) NOT NULL,
  `room_photo` varchar(255) NOT NULL,
  `latitude` varchar(255) NOT NULL,
  `longitude` varchar(255) NOT NULL,
  `owner_id` varchar(255) NOT NULL,
  `expiry_date` date NOT NULL,
  `expiry_time` time NOT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=459 ;

--
-- Dumping data for table `tbl_chatroom`
--

INSERT INTO `tbl_chatroom` (`id`, `room_nm`, `participants`, `participants_no`, `recent_message`, `recent_time`, `recent_counter`, `room_photo`, `latitude`, `longitude`, `owner_id`, `expiry_date`, `expiry_time`, `status`) VALUES
(428, 'Khusheel%20Verma', '9912345675', 0, '', '0000-00-00 00:00:00', '', '', '19.00498237778891', '72.86257334053516', '9898989898', '0000-00-00', '10:36:12', 0),
(423, 'satish', '7878787878_9479400008', 0, 'haha', '2017-09-11 02:53:21', '', '', '22.682442590944095', '75.93355782330036', '2147483647', '0000-00-00', '20:24:33', 0),
(424, 'dark', '6044125858_6137009632_Optional("6044125858")', 0, 'dupicates', '2017-09-09 17:12:42', '', '', '45.3679391063078', '-75.90580735355616', '2147483647', '0000-00-00', '11:01:08', 0),
(427, 'khushil', '9912345675_7566663274_Optional("7566663274")_9912345671_Optional("9912345671")_9479400008_9926078350_9926078356', 0, 'Kya challenge that h', '2017-09-11 03:06:50', '', '', '18.97300538691781', '72.86297366023064', '2147483647', '0000-00-00', '10:15:14', 0),
(429, 'Ravi%20Teja', '7566663274', 0, '', '0000-00-00 00:00:00', '', '', '19.01152862242544', '72.8481537848711', '2147483647', '0000-00-00', '10:39:00', 0),
(430, 'Bala%20Guru', '7566663274', 0, '', '0000-00-00 00:00:00', '', '', '19.02378165267244', '72.86806650459766', '2147483647', '0000-00-00', '10:40:01', 0),
(432, 'ZanjoIt', '7566663274_Optional("7566663274")', 0, '', '0000-00-00 00:00:00', '', '', '19.01012214144886', '72.8642899543047', '2147483647', '0000-00-00', '11:49:03', 0),
(433, 'Gabbar', '7566663274_Optional("7566663274")', 0, '', '0000-00-00 00:00:00', '', '', '19.00308892414582', '72.85765249282122', '2147483647', '0000-00-00', '11:51:42', 0),
(455, 'name', '9479400008', 0, '', '0000-00-00 00:00:00', '', '', '22.645460714369214', '75.92021048069', '2147483647', '0000-00-00', '12:01:05', 0),
(435, 'Hello%20World', '7566663274', 0, '', '0000-00-00 00:00:00', '', '', '19.01564022081259', '72.87825152277946', '2147483647', '0000-00-00', '12:11:42', 0),
(436, 'Kamal', '7566663274_Optional("7566663274")', 0, '', '0000-00-00 00:00:00', '', '', '18.99941005297478', '72.84643717110157', '2147483647', '0000-00-00', '12:14:12', 0),
(437, 'RamRahim', '7566663274_Optional("7566663274")', 0, '', '0000-00-00 00:00:00', '', '', '18.99908321438519', '72.87102833390236', '2147483647', '0000-00-00', '12:27:57', 0),
(438, 'jayesh', '7566663274', 0, '', '0000-00-00 00:00:00', '', '', '19.03630413003352', '72.86869581788778', '2147483647', '0000-00-00', '12:44:01', 0),
(439, 'salman', '7566663274_Optional("7566663274")', 0, '', '0000-00-00 00:00:00', '', '', '19.01412536650263', '72.83625181764364', '2147483647', '0000-00-00', '12:46:52', 0),
(440, 'Amir', '7566663274', 0, '', '0000-00-00 00:00:00', '', '', '19.03887354742485', '72.84477755427361', '2147483647', '0000-00-00', '12:47:42', 0),
(441, 'march', '6137005794', 0, 'testing', '2017-09-10 08:54:39', '', '', '45.33884654594801', '-75.95782779157162', '2147483647', '0000-00-00', '17:08:38', 0),
(442, 'roomtest', '6044018787_Optional("6044018787")', 0, 'shows up here', '2017-09-09 17:12:06', '', '', '45.326495864983464', '-75.90171933174133', '2147483647', '0000-00-00', '17:11:45', 0),
(443, 'river', '6137005794_6044018787', 0, 'watsap', '2017-09-10 17:48:17', '', '', '45.375118410638684', '-75.85741359740496', '2147483647', '0000-00-00', '08:54:03', 0),
(444, 'beavertale', '6137005794_Optional("6137005794")', 0, '', '0000-00-00 00:00:00', '', '', '45.26026596669144', '-76.0235308483243', '2147483647', '0000-00-00', '08:55:50', 0),
(445, 'RealTime', '7566663274_Optional("7566663274")', 0, '', '0000-00-00 00:00:00', '', '', '19.02867709682219', '72.8338485583663', '2147483647', '0000-00-00', '09:26:33', 0),
(446, 'DayNo', '7566663274', 0, '', '0000-00-00 00:00:00', '', '', '19.02862321444085', '72.87790820002556', '2147483647', '0000-00-00', '09:37:10', 0),
(447, 'Don', '7566663274', 0, '', '0000-00-00 00:00:00', '', '', '19.04225426584096', '72.85753782838583', '2147483647', '0000-00-00', '09:40:36', 0),
(448, 'Iphone', '7566663274', 0, '', '0000-00-00 00:00:00', '', '', '18.99253869922206', '72.85387560725212', '2147483647', '0000-00-00', '09:49:46', 0),
(449, 'samsung', '7566663274_9912345671_Optional("9912345671")', 0, '', '0000-00-00 00:00:00', '', '', '18.99537921018659', '72.864232622087', '2147483647', '0000-00-00', '09:54:44', 0),
(450, 'Petrol', '9912345671_9926078356_9926078350', 0, '', '0000-00-00 00:00:00', '', '', '19.00463082407066', '72.83808276057243', '2147483647', '0000-00-00', '11:54:48', 0),
(451, 'Helo%20World', '9912345671', 0, '', '0000-00-00 00:00:00', '', '', '19.02640514689461', '72.85931177437305', '2147483647', '0000-00-00', '11:57:51', 0),
(454, 'Youtube', '7566663274', 0, '', '0000-00-00 00:00:00', '', '', '19.0094187380039', '72.87664957344532', '9999999999', '0000-00-00', '11:59:56', 0),
(452, 'nepean', '6044018787_Optional("6044018787")', 0, 'Dragonballz', '2017-09-11 00:17:30', '', '', '45.33378366053551', '-75.72020519524813', '2147483647', '0000-00-00', '05:42:07', 0),
(453, '911', '6044018787_Optional("6044018787")_6044125858_Optional("6044125858")_Optional("6137005794")', 0, 'Hidden messages', '2017-09-11 00:38:36', '', '', '45.16505767088652', '-75.93469072133303', '2147483647', '0000-00-00', '12:14:56', 0),
(456, 'hahaha', '9479400008', 0, '', '0000-00-00 00:00:00', '', '', '22.720583186550716', '75.89483946561812', '9479400008', '0000-00-00', '12:43:50', 0),
(457, 'yoyoyo', '9479400008', 0, '', '0000-00-00 00:00:00', '', '', '22.66890283600666', '75.8550874516368', '9479400008', '0000-00-00', '12:54:45', 0),
(458, 'newBubble', '7566663274', 0, '', '0000-00-00 00:00:00', '', '', '19.00165510923431', '72.85381861031055', '7566663274', '0000-00-00', '01:01:43', 0);

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

--
-- Table structure for table `tbl_chat_room_blocked`
--

CREATE TABLE IF NOT EXISTS `tbl_chat_room_blocked` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `room_id` int(11) NOT NULL,
  `room_nm` varchar(255) NOT NULL,
  `participant_id` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

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

--
-- Table structure for table `tbl_exp`
--

CREATE TABLE IF NOT EXISTS `tbl_exp` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `exp_userid` varchar(255) NOT NULL,
  `exp_points` int(11) NOT NULL,
  `exp_time` time NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=88 ;

--
-- Dumping data for table `tbl_exp`
--

INSERT INTO `tbl_exp` (`id`, `exp_userid`, `exp_points`, `exp_time`) VALUES
(74, '9424800080', 5, '00:00:00'),
(75, '0000000000', 2017, '00:00:00'),
(76, '9999999999', 2017, '00:00:00'),
(77, '7878787878', 2017, '00:00:00'),
(78, '6044125858', 2017, '00:00:00'),
(79, '7566663274', 2017, '00:00:00'),
(80, '6137009632', 2017, '00:00:00'),
(81, '6044018787', 2017, '00:00:00'),
(82, '6137005794', 2017, '00:00:00'),
(83, '2', 2017, '00:00:00'),
(84, '9912345671', 2017, '00:00:00'),
(85, '9926078350', 2017, '00:00:00'),
(86, '9926078356', 2017, '00:00:00'),
(87, '9479400008', 2017, '00:00:00');

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

--
-- Table structure for table `tbl_friend`
--

CREATE TABLE IF NOT EXISTS `tbl_friend` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_mob` varchar(255) NOT NULL,
  `friend_mob` varchar(255) NOT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=188 ;

--
-- Dumping data for table `tbl_friend`
--

INSERT INTO `tbl_friend` (`id`, `user_mob`, `friend_mob`, `status`) VALUES
(177, '0000000000', '0000000000', 1),
(178, '0000000000', '9999999999', 3),
(179, '9912312345', '9912345675', 0),
(180, '7777777777', '7566663274', 0),
(181, '9713821060', '7566663274', 0),
(182, '9926078356', '9912345671', 3),
(183, '9926078350', '9912345671', 0),
(184, '9912345671', '9926078350', 1),
(185, '9926078356', '9926078350', 0),
(186, '9494505101', '9424800080', 0),
(187, '9926078350', '9479400008', 0);

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

--
-- Table structure for table `tbl_group_chat`
--

CREATE TABLE IF NOT EXISTS `tbl_group_chat` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sender_id` varchar(16) NOT NULL,
  `message` text NOT NULL,
  `room_id` varchar(16) NOT NULL,
  `datetime` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=869 ;

--
-- Dumping data for table `tbl_group_chat`
--

INSERT INTO `tbl_group_chat` (`id`, `sender_id`, `message`, `room_id`, `datetime`) VALUES
(827, '0000000000', 'hi', '420', '2017-09-09 10:03:31'),
(828, '9999999999', 'zanjo2', '420', '2017-09-09 10:06:03'),
(829, '0000000000', 'hi', '420', '2017-09-09 10:08:06'),
(830, '6044125858', 'hello', '424', '2017-09-09 11:01:24'),
(831, '7566663274', 'Dfsdfsd', '427', '2017-09-09 13:20:59'),
(832, '6137009632', 'good news', '424', '2017-09-09 16:57:57'),
(833, '6137009632', 'duplicate', '424', '2017-09-09 16:58:21'),
(834, '6137005794', 'ready', '441', '2017-09-09 17:09:20'),
(835, '6044018787', 'shows up here', '442', '2017-09-09 17:12:06'),
(836, '6044018787', 'again', '424', '2017-09-09 17:12:28'),
(837, '6044018787', 'dupicates', '424', '2017-09-09 17:12:42'),
(838, '6137005794', 'testing', '441', '2017-09-10 08:54:39'),
(839, '9926078350', 'Hi yoyo', '434', '2017-09-10 15:16:48'),
(840, '7566663274', 'Hi guys...how r u', '434', '2017-09-10 15:29:15'),
(841, '6044018787', 'Yuesbee1 hello nepean', '452', '2017-09-10 17:42:41'),
(842, '6044018787', 'Cool', '452', '2017-09-10 17:44:58'),
(843, '6044018787', 'Hello', '443', '2017-09-10 17:47:23'),
(844, '6137005794', 'hello', '443', '2017-09-10 17:47:41'),
(845, '6044018787', 'Tu', '443', '2017-09-10 17:47:46'),
(846, '6044018787', 'Drax', '443', '2017-09-10 17:48:04'),
(847, '6137005794', 'watsap', '443', '2017-09-10 17:48:17'),
(848, '6044018787', 'Hello. Just wanted to test it', '453', '2017-09-11 00:15:53'),
(849, '6044018787', 'Dragonballz', '452', '2017-09-11 00:17:30'),
(850, '6044018787', 'Still teating', '453', '2017-09-11 00:19:05'),
(851, '6044018787', 'Both rooms linked', '453', '2017-09-11 00:19:31'),
(852, '6137005794', 'Just teating the room for now', '453', '2017-09-11 00:24:37'),
(853, '6044125858', 'Fady1 here', '453', '2017-09-11 00:25:49'),
(854, '6137005794', 'Hidden messages', '453', '2017-09-11 00:38:36'),
(855, '9926078350', 'Hi nyagh', '434', '2017-09-11 02:19:44'),
(856, '7566663274', 'Hi dugukdl', '427', '2017-09-11 02:36:27'),
(857, '7566663274', 'Sdifksdb', '427', '2017-09-11 02:36:45'),
(858, '7566663274', 'Hi sduguksfgui,a;dgj', '427', '2017-09-11 02:45:12'),
(859, '9912345671', 'Hi nysha', '427', '2017-09-11 02:46:18'),
(860, '9479400008', 'haha', '423', '2017-09-11 02:53:21'),
(861, '9479400008', 'hi rravi', '427', '2017-09-11 02:54:16'),
(862, '7566663274', 'Ddhdjdjj', '427', '2017-09-11 02:54:52'),
(863, '9479400008', 'how r u', '427', '2017-09-11 02:55:59'),
(864, '7566663274', 'Fine', '427', '2017-09-11 02:56:20'),
(865, '9912345671', 'Grioherg', '427', '2017-09-11 02:57:58'),
(866, '7566663274', 'Helo world', '427', '2017-09-11 03:02:50'),
(867, '7566663274', 'Gus moernig', '427', '2017-09-11 03:04:35'),
(868, '7566663274', 'Kya challenge that h', '427', '2017-09-11 03:06:50');

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

--
-- Table structure for table `tbl_notifyAddRoom`
--

CREATE TABLE IF NOT EXISTS `tbl_notifyAddRoom` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `participent_id` text NOT NULL,
  `room_id` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=26 ;

--
-- Dumping data for table `tbl_notifyAddRoom`
--

INSERT INTO `tbl_notifyAddRoom` (`id`, `participent_id`, `room_id`, `status`) VALUES
(22, '9926078350', 427, 1),
(23, '9926078356', 427, 1),
(24, '9926078356', 450, 1),
(25, '9926078350', 450, 1);

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

--
-- Table structure for table `tbl_noty_group_chat`
--

CREATE TABLE IF NOT EXISTS `tbl_noty_group_chat` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `group_chat_id` int(11) NOT NULL,
  `participent_id` varchar(16) NOT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2375 ;

--
-- Dumping data for table `tbl_noty_group_chat`
--

INSERT INTO `tbl_noty_group_chat` (`id`, `group_chat_id`, `participent_id`, `status`) VALUES
(2244, 827, '9999999999', 1),
(2245, 827, '', 0),
(2246, 828, '0000000000', 1),
(2247, 828, '', 0),
(2248, 829, '9999999999', 1),
(2249, 829, '', 0),
(2250, 830, '', 0),
(2251, 831, '9912345675', 1),
(2252, 831, '', 0),
(2253, 832, '6044125858', 1),
(2254, 832, '', 0),
(2255, 833, '6044125858', 1),
(2256, 833, '', 0),
(2257, 834, '', 0),
(2258, 835, '', 0),
(2259, 836, '6044125858', 1),
(2260, 836, '6137009632', 0),
(2261, 836, '', 0),
(2262, 837, '6044125858', 1),
(2263, 837, '6137009632', 0),
(2264, 837, '', 0),
(2265, 838, '', 0),
(2266, 839, '7566663274', 1),
(2267, 839, '', 0),
(2268, 840, '9926078350', 1),
(2269, 840, '9926078356', 1),
(2270, 840, '9912345671', 1),
(2271, 840, '', 0),
(2272, 841, '', 0),
(2273, 842, 'Optional("604401', 0),
(2274, 842, '', 0),
(2275, 843, '6137005794', 1),
(2276, 843, '', 0),
(2277, 844, '6044018787', 1),
(2278, 844, '', 0),
(2279, 845, '6137005794', 1),
(2280, 845, '', 0),
(2281, 846, '6137005794', 1),
(2282, 846, '', 0),
(2283, 847, '6044018787', 1),
(2284, 847, '', 0),
(2285, 848, '', 0),
(2286, 849, 'Optional("604401', 0),
(2287, 849, '', 0),
(2288, 850, 'Optional("604401', 0),
(2289, 850, '', 0),
(2290, 851, 'Optional("604401', 0),
(2291, 851, '', 0),
(2292, 852, '6044018787', 0),
(2293, 852, 'Optional("604401', 0),
(2294, 852, '', 0),
(2295, 853, '6044018787', 0),
(2296, 853, 'Optional("604401', 0),
(2297, 853, '6137005794', 1),
(2298, 853, '', 0),
(2299, 854, '6044018787', 0),
(2300, 854, 'Optional("604401', 0),
(2301, 854, '6044125858', 0),
(2302, 854, 'Optional("604412', 0),
(2303, 854, 'Optional("613700', 0),
(2304, 854, '', 0),
(2305, 855, '7566663274', 1),
(2306, 855, '9926078356', 0),
(2307, 855, '9912345671', 1),
(2308, 855, 'Optional("991234', 0),
(2309, 855, 'Optional("992607', 0),
(2310, 855, 'Optional("992607', 0),
(2311, 855, '', 0),
(2312, 856, '9912345675', 0),
(2313, 856, 'Optional("756666', 0),
(2314, 856, '', 0),
(2315, 857, '9912345675', 0),
(2316, 857, 'Optional("756666', 0),
(2317, 857, '', 0),
(2318, 858, '9912345675', 0),
(2319, 858, 'Optional("756666', 0),
(2320, 858, '', 0),
(2321, 859, '9912345675', 0),
(2322, 859, '7566663274', 1),
(2323, 859, 'Optional("756666', 0),
(2324, 859, '', 0),
(2325, 860, '7878787878', 0),
(2326, 860, '', 0),
(2327, 861, '9912345675', 0),
(2328, 861, '7566663274', 1),
(2329, 861, 'Optional("756666', 0),
(2330, 861, '9912345671', 1),
(2331, 861, 'Optional("991234', 0),
(2332, 861, '', 0),
(2333, 862, '9912345675', 0),
(2334, 862, 'Optional("756666', 0),
(2335, 862, '9912345671', 1),
(2336, 862, 'Optional("991234', 0),
(2337, 862, '9479400008', 0),
(2338, 862, '', 0),
(2339, 863, '9912345675', 0),
(2340, 863, '7566663274', 1),
(2341, 863, 'Optional("756666', 0),
(2342, 863, '9912345671', 1),
(2343, 863, 'Optional("991234', 0),
(2344, 863, '', 0),
(2345, 864, '9912345675', 0),
(2346, 864, 'Optional("756666', 0),
(2347, 864, '9912345671', 1),
(2348, 864, 'Optional("991234', 0),
(2349, 864, '9479400008', 0),
(2350, 864, '', 0),
(2351, 865, '9912345675', 0),
(2352, 865, '7566663274', 1),
(2353, 865, 'Optional("756666', 0),
(2354, 865, 'Optional("991234', 0),
(2355, 865, '9479400008', 0),
(2356, 865, '', 0),
(2357, 866, '9912345675', 0),
(2358, 866, 'Optional("756666', 0),
(2359, 866, '9912345671', 1),
(2360, 866, 'Optional("991234', 0),
(2361, 866, '9479400008', 0),
(2362, 866, '', 0),
(2363, 867, '9912345675', 0),
(2364, 867, 'Optional("756666', 0),
(2365, 867, '9912345671', 1),
(2366, 867, 'Optional("991234', 0),
(2367, 867, '9479400008', 0),
(2368, 867, '', 0),
(2369, 868, '9912345675', 0),
(2370, 868, 'Optional("756666', 0),
(2371, 868, '9912345671', 1),
(2372, 868, 'Optional("991234', 0),
(2373, 868, '9479400008', 0),
(2374, 868, '', 0);

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

--
-- Table structure for table `tbl_request_kick`
--

CREATE TABLE IF NOT EXISTS `tbl_request_kick` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `blockNo` varchar(255) NOT NULL,
  `fromNo` varchar(255) NOT NULL,
  `roomId` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=28 ;

--
-- Dumping data for table `tbl_request_kick`
--

INSERT INTO `tbl_request_kick` (`id`, `blockNo`, `fromNo`, `roomId`, `status`) VALUES
(25, '9926078350', '9926078356', 434, 0),
(26, '1', '1', 1, 0),
(27, '1', '1', 1, 0);

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

--
-- Table structure for table `tb_guardian`
--

CREATE TABLE IF NOT EXISTS `tb_guardian` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(20) NOT NULL,
  `guardian_id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `phone` varchar(20) NOT NULL,
  `type` varchar(20) NOT NULL,
  `day` int(11) NOT NULL,
  `hours` int(11) NOT NULL,
  `time_now` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=110 ;

--
-- Dumping data for table `tb_guardian`
--

INSERT INTO `tb_guardian` (`id`, `user_id`, `guardian_id`, `name`, `phone`, `type`, `day`, `hours`, `time_now`) VALUES
(108, '9926078350', 2147483647, 'pratik', '9912345671', 'dffbvdf', 11, 7, '4:05:29 AM'),
(109, '9926078350', 2147483647, 'guru', '9926078356', '', 14, 7, '4:05:45 AM');

