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




--
-- Database: `mismatch`
--

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

--
-- Table structure for table `mismatch_block`
--

CREATE TABLE IF NOT EXISTS `mismatch_block` (
`block_id` int(11) NOT NULL,
  `USER_ID` int(11) NOT NULL,
  `TO_USER_ID` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `mismatch_chat`
--

CREATE TABLE IF NOT EXISTS `mismatch_chat` (
`chat_id` int(11) NOT NULL,
  `USER_ID` int(11) NOT NULL,
  `TO_USER_ID` int(11) NOT NULL,
  `message` mediumtext NOT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `seen` tinyint(4) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=1333 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `mismatch_chat`
--

INSERT INTO `mismatch_chat` (`chat_id`, `USER_ID`, `TO_USER_ID`, `message`, `time`, `seen`) VALUES
(1292, 12, 11, ' hiii ', '2017-07-12 08:40:40', 0),
(1293, 33, 13, ' hello ', '2017-07-12 12:47:47', 0),
(1294, 33, 13, ' 12345678990-= ', '2017-07-12 12:47:51', 0),
(1295, 33, 13, ' !@#$%^&amp;*() ', '2017-07-12 12:47:58', 0),
(1296, 33, 13, ' \\n ', '2017-07-12 12:48:01', 0),
(1297, 33, 13, ' ("\\n") ', '2017-07-12 12:48:10', 0),
(1298, 33, 13, ' <img style="display:inline" src=".\\selected emoji\\8.png" <="" img=""> <img style="display:inline" src=".\\selected emoji\\11.png" <="" img="">\\t("\\n") ', '2017-07-12 12:48:31', 0),
(1299, 12, 11, ' hel ', '2017-07-12 13:55:44', 0),
(1300, 12, 11, ' hgeljvewf<img style="display:inline" src=".\\selected emoji\\4.png" <="" img="">bkewads ', '2017-07-12 13:56:03', 0),
(1301, 12, 11, ' hfkads fdnsa<img style="display:inline" src=".\\selected emoji\\3.png" <="" img=""> <img style="display:inline" src=".\\selected emoji\\3.png" <="" img="">bjksfd  fasd<img style="display:inline" src=".\\selected emoji\\6.png" <="" img=""> ', '2017-07-12 13:56:12', 0),
(1302, 12, 11, ' <img style="display:inline" src=".\\selected emoji\\9.png" <="" img=""> <img style="display:inline" src=".\\selected emoji\\7.png" <="" img=""> ', '2017-07-12 13:56:49', 0),
(1303, 12, 11, ' &lt;div&gt;gekl&lt;\\div&gt; ', '2017-07-12 13:58:24', 0),
(1304, 12, 11, ' &lt;code&gt;hello&lt;\\code&gt; ', '2017-07-12 13:58:34', 0),
(1305, 12, 11, ' &lt;code&gt;afsdfds&lt;\\code&gt; ', '2017-07-12 13:58:53', 0),
(1306, 12, 14, ' hiiii ', '2017-07-13 11:01:27', 0),
(1307, 12, 14, ' hello ', '2017-07-13 11:01:30', 0),
(1308, 12, 14, ' hello ', '2017-07-22 20:27:41', 0),
(1309, 62, 12, ' hello abc ', '2017-07-24 11:14:12', 0),
(1310, 62, 12, ' sorry you are bc too ', '2017-07-24 11:14:24', 0),
(1311, 62, 12, ' <img style="display:inline" src=".\\selected emoji\\4.png" <="" img=""> <img style="display:inline" src=".\\selected emoji\\4.png" <="" img=""> <img style="display:inline" src=".\\selected emoji\\4.png" <="" img=""> ', '2017-07-24 11:14:29', 0),
(1312, 62, 12, ' fds ', '2017-07-24 11:14:47', 0),
(1313, 12, 62, ' chup be ', '2017-07-24 11:26:45', 0),
(1314, 12, 62, ' get lost you asshole ', '2017-07-24 11:26:52', 0),
(1315, 12, 62, ' hello ', '2017-07-27 07:15:45', 0),
(1316, 12, 62, ' <img style="display:inline" src=".\\selected emoji\\2.png" <="" img=""> <img style="display:inline" src=".\\selected emoji\\2.png" <="" img=""> ', '2017-07-27 07:15:52', 0),
(1317, 12, 11, ' jle ', '2017-07-27 07:16:50', 0),
(1318, 12, 11, ' ble ', '2017-07-27 07:16:54', 0),
(1319, 12, 11, ' hiii ', '2017-07-27 19:47:32', 0),
(1320, 12, 11, ' helo ', '2017-07-27 19:47:35', 0),
(1321, 12, 62, ' hiii ', '2017-07-28 14:23:31', 0),
(1322, 12, 62, ' hy ', '2017-07-28 14:23:52', 0),
(1323, 12, 11, ' yo ', '2017-07-30 19:08:06', 0),
(1324, 12, 22, ' hiiiii ', '2017-08-04 13:40:50', 0),
(1325, 12, 14, ' goa  ', '2017-08-04 13:43:02', 0),
(1326, 12, 14, ' gower ', '2017-08-04 13:43:10', 0),
(1327, 12, 22, ' <img style="display:inline" src=".\\selected emoji\\3.png" <="" img=""> <img style="display:inline" src=".\\selected emoji\\3.png" <="" img=""> <img style="display:inline" src=".\\selected emoji\\3.png" <="" img=""> ', '2017-08-04 13:44:11', 0),
(1328, 12, 127, ' heart ', '2017-08-04 13:45:04', 0),
(1329, 12, 127, ' &lt;3 ', '2017-08-04 13:45:08', 0),
(1330, 12, 127, ' &lt;:3 ', '2017-08-04 13:45:12', 0),
(1331, 12, 127, ' :) ', '2017-08-04 13:45:16', 0),
(1332, 12, 14, ' hello ', '2017-08-13 12:24:34', 0);

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

--
-- Table structure for table `mismatch_response`
--

CREATE TABLE IF NOT EXISTS `mismatch_response` (
`RESPONSE_ID` int(11) NOT NULL,
  `USER_ID` int(11) NOT NULL,
  `TOPIC_ID` int(11) NOT NULL,
  `response` tinyint(4) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=576 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `mismatch_response`
--

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

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

--
-- Table structure for table `mismatch_topic`
--

CREATE TABLE IF NOT EXISTS `mismatch_topic` (
`TOPIC_ID` int(11) NOT NULL,
  `name` varchar(40) NOT NULL,
  `category` varchar(40) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `mismatch_topic`
--

INSERT INTO `mismatch_topic` (`TOPIC_ID`, `name`, `category`) VALUES
(1, 'Tattoos', 'Appearance'),
(2, 'Gold Chains', 'Appearance'),
(3, 'Body piercings', 'Appearance'),
(4, 'Cowboy boots', 'Appearance'),
(5, 'Long hair', 'Appearance'),
(6, 'Reality TV', 'Entertainment'),
(7, 'Professional wrestling', 'Entertainment'),
(8, 'Horror movies', 'Entertainment'),
(9, 'Easy listening music', 'Entertainment'),
(10, 'The opera', 'Entertainment'),
(11, 'pizza', 'Food'),
(12, 'Homemade dishes', 'Food'),
(13, 'spicy food', 'Food'),
(14, 'Fruits', 'Food'),
(15, 'non vegitarian', 'Food'),
(16, 'Bill Gates', 'people'),
(17, 'Narendra Modi', 'people'),
(18, 'Stephen Hawkings', 'people'),
(19, 'APJ Abdul Kalam', 'people'),
(20, 'Sachin Tendulkar', 'people'),
(21, 'Indoor Gaming', 'Activities'),
(22, 'Outdoor Gaming', 'Activities'),
(23, 'Hiking', 'Activities'),
(24, 'Weightlifting', 'Activities'),
(25, 'Reading', 'Activities');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `mismatch_block`
--
ALTER TABLE `mismatch_block`
 ADD PRIMARY KEY (`block_id`), ADD KEY `USER_ID` (`USER_ID`), ADD KEY `TO_USER_ID` (`TO_USER_ID`);

--
-- Indexes for table `mismatch_chat`
--
ALTER TABLE `mismatch_chat`
 ADD PRIMARY KEY (`chat_id`), ADD KEY `USER_ID` (`USER_ID`), ADD KEY `TO_USER_ID` (`TO_USER_ID`);

--
-- Indexes for table `mismatch_response`
--
ALTER TABLE `mismatch_response`
 ADD PRIMARY KEY (`RESPONSE_ID`), ADD KEY `USER_ID` (`USER_ID`), ADD KEY `TOPIC_ID` (`TOPIC_ID`);

--
-- Indexes for table `mismatch_topic`
--
ALTER TABLE `mismatch_topic`
 ADD PRIMARY KEY (`TOPIC_ID`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `mismatch_block`
--
ALTER TABLE `mismatch_block`
MODIFY `block_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `mismatch_chat`
--
ALTER TABLE `mismatch_chat`
MODIFY `chat_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=1333;
--
-- AUTO_INCREMENT for table `mismatch_response`
--
ALTER TABLE `mismatch_response`
MODIFY `RESPONSE_ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=576;
--
-- AUTO_INCREMENT for table `mismatch_topic`
--
ALTER TABLE `mismatch_topic`
MODIFY `TOPIC_ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=26;
--
-- Constraints for dumped tables
--

--
-- Constraints for table `mismatch_block`
--
ALTER TABLE `mismatch_block`
ADD CONSTRAINT `mismatch_block_ibfk_1` FOREIGN KEY (`USER_ID`) REFERENCES `mismatch_user` (`USER_ID`),
ADD CONSTRAINT `mismatch_block_ibfk_2` FOREIGN KEY (`TO_USER_ID`) REFERENCES `mismatch_user` (`USER_ID`);

--
-- Constraints for table `mismatch_chat`
--
ALTER TABLE `mismatch_chat`
ADD CONSTRAINT `mismatch_chat_ibfk_1` FOREIGN KEY (`USER_ID`) REFERENCES `mismatch_user` (`USER_ID`),
ADD CONSTRAINT `mismatch_chat_ibfk_2` FOREIGN KEY (`TO_USER_ID`) REFERENCES `mismatch_user` (`USER_ID`);

--
-- Constraints for table `mismatch_response`
--
ALTER TABLE `mismatch_response`
ADD CONSTRAINT `mismatch_response_ibfk_1` FOREIGN KEY (`USER_ID`) REFERENCES `mismatch_user` (`USER_ID`),
ADD CONSTRAINT `mismatch_response_ibfk_2` FOREIGN KEY (`TOPIC_ID`) REFERENCES `mismatch_topic` (`TOPIC_ID`);

