Al-HUWAITI Shell
Apache/2.4.52 (Ubuntu) Linux srv913213 5.15.0-179-generic #189-Ubuntu SMP Tue May 5 18:20:56 UTC 2026 x86_64 www-data ( 33 )7.4.33 pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare, / var /www / Upload File :
Current File : //var/www/bells_matrimony.sql -- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Jul 04, 2025 at 01:02 PM
-- Server version: 8.0.42-0ubuntu0.22.04.1
-- PHP Version: 7.4.33
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
--
-- Database: `bells_matrimony`
--
-- --------------------------------------------------------
--
-- Table structure for table `admin_credential`
--
CREATE TABLE `admin_credential` (
`id` int NOT NULL,
`username` varchar(20) NOT NULL,
`password` varchar(20) NOT NULL,
`email` varchar(100) NOT NULL,
`usertype` tinyint NOT NULL DEFAULT '1' COMMENT '1 - super_admin, 2 - branch admin'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `admin_credential`
--
INSERT INTO `admin_credential` (`id`, `username`, `password`, `email`, `usertype`) VALUES
(1, 'admin', 'admin', 'devtechnogenesis@gmail.com', 1);
-- --------------------------------------------------------
--
-- Table structure for table `ads`
--
CREATE TABLE `ads` (
`id` int NOT NULL,
`position` varchar(50) NOT NULL,
`content` longtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `affluence_level`
--
CREATE TABLE `affluence_level` (
`id` int NOT NULL,
`affluence_level` varchar(50) DEFAULT NULL,
`affluence_tamil` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `affluence_level`
--
INSERT INTO `affluence_level` (`id`, `affluence_level`, `affluence_tamil`) VALUES
(1, 'Affluent', 'செல்வம் மிக்க வகுப்பு'),
(2, 'Upper Middle Class', 'மேல் மத்திய வகுப்பு'),
(3, 'Middle Class', 'நடுத்தரம்'),
(4, 'Lower Class', 'கீழ் வகுப்பு');
-- --------------------------------------------------------
--
-- Table structure for table `annual_income`
--
CREATE TABLE `annual_income` (
`id` int NOT NULL,
`income` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `annual_income`
--
INSERT INTO `annual_income` (`id`, `income`) VALUES
(1, 'Upto 1 Lakh'),
(2, 'INR 1 Lakh to 2 Lakh'),
(3, 'INR 2 Lakh to 4 Lakh'),
(4, 'INR 4 Lakh to 7 Lakh'),
(5, 'INR 7 Lakh to 10 Lakh'),
(6, 'INR 10 Lakh to 15 Lakh'),
(7, 'INR 15 Lakh to 20 Lakh'),
(8, 'INR 20 Lakh to 30 Lakh'),
(9, 'INR 30 Lakh to 50 Lakh');
-- --------------------------------------------------------
--
-- Table structure for table `bank_details`
--
CREATE TABLE `bank_details` (
`id` int NOT NULL,
`bank` varchar(50) NOT NULL,
`ac_holder` varchar(50) NOT NULL,
`ac_number` varchar(30) NOT NULL,
`branch` varchar(50) NOT NULL,
`ifsc` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `bank_details`
--
INSERT INTO `bank_details` (`id`, `bank`, `ac_holder`, `ac_number`, `branch`, `ifsc`) VALUES
(4, 'STATE BANK OF INDIA', 'BOOBALAN G', '20183594244', 'VEDASANDUR', 'SBIN0011941'),
(5, 'CANARA BANK', 'BOOBALAN G', '1006101056433', 'DINDIGUL MAIN ', 'CNRB0001006');
-- --------------------------------------------------------
--
-- Table structure for table `branch`
--
CREATE TABLE `branch` (
`id` int NOT NULL,
`branch` varchar(50) NOT NULL,
`username` varchar(25) NOT NULL,
`password` varchar(25) NOT NULL,
`door_no` varchar(20) NOT NULL,
`street` varchar(50) NOT NULL,
`place` varchar(50) NOT NULL,
`city` varchar(60) NOT NULL,
`state` varchar(10) NOT NULL,
`district` varchar(10) NOT NULL,
`pincode` varchar(10) NOT NULL,
`email` varchar(150) NOT NULL,
`mobile` varchar(12) NOT NULL,
`usertype` tinyint NOT NULL DEFAULT '2' COMMENT '1 - super_admin, 2 - branch admin'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `branch`
--
INSERT INTO `branch` (`id`, `branch`, `username`, `password`, `door_no`, `street`, `place`, `city`, `state`, `district`, `pincode`, `email`, `mobile`, `usertype`) VALUES
(6, 'BELL MATRIMONY -102', 'bmvdsr', 'bmvdsr', '', 'PIRAKARAI', 'UNDARPATTY POST', 'THADIKOMBU VIA', '79', '25', '624709', 'bm2@bellsmatrimony.com', '9677733744', 2);
-- --------------------------------------------------------
--
-- Table structure for table `caste`
--
CREATE TABLE `caste` (
`caste_id` int NOT NULL,
`religion_id` int DEFAULT NULL,
`caste` varchar(500) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `caste`
--
INSERT INTO `caste` (`caste_id`, `religion_id`, `caste`) VALUES
(1, 61, 'AdiDravida'),
(2, 61, 'Arunthathiyar'),
(3, 61, 'Badaga'),
(4, 61, 'Boyer'),
(5, 61, 'Brahmin'),
(6, 61, 'Brahmin - Gurukkal'),
(7, 61, 'Brahmin - Iyengar'),
(8, 61, 'Brahmin - Iyer'),
(9, 61, 'Chattada Sri Vaishnava'),
(10, 61, 'Chettiar'),
(11, 61, 'Devar/Thevar/Mukkulathor'),
(12, 61, 'Devendra Kula Vellalar'),
(13, 61, 'Gounder'),
(14, 61, 'Gramani'),
(15, 61, 'Intercaste'),
(16, 61, 'Karuneegar'),
(17, 61, 'Kongu Vellala Gounder'),
(18, 61, 'Krishnavaka'),
(19, 61, 'Kulalar'),
(20, 61, 'Kuravan'),
(21, 61, 'Kurumbar'),
(22, 61, 'Maruthuvar'),
(23, 61, 'Meenavar'),
(24, 61, 'Mudaliar'),
(25, 61, 'Mudaliar - Senguntha'),
(26, 61, 'Muthuraja'),
(27, 61, 'Nadar'),
(28, 61, 'Naicker'),
(29, 61, 'Naidu'),
(30, 61, 'Pandaram'),
(31, 61, 'Parkava Kulam'),
(32, 61, 'Pillai'),
(33, 61, 'Reddy'),
(34, 61, 'Scheduled Caste (SC)'),
(35, 61, 'Scheduled Tribe (ST)'),
(36, 61, 'Senai Thalaivar'),
(37, 61, 'Sourashtra'),
(38, 61, 'Sozhiya Vellalar'),
(39, 61, 'Urali Gounder'),
(40, 61, 'Valluvan'),
(41, 61, 'Vannar'),
(42, 61, 'Vanniyakullak Kshatriya'),
(43, 61, 'Veera Saivam'),
(44, 61, 'Vellalar'),
(45, 61, 'Vettuva Gounder'),
(46, 61, 'Vishwakarma'),
(47, 61, 'Vokkaliga'),
(48, 61, 'Yadav'),
(49, 61, '96K Kokanastha'),
(50, 61, 'Adi Andhra'),
(51, 61, 'Adi Karnataka'),
(52, 61, 'Agarwal'),
(53, 61, 'Agnikula Kshatriya'),
(54, 61, 'Agri'),
(55, 61, 'Ahom'),
(56, 61, 'Ambalavasi'),
(57, 61, 'Arekatica'),
(58, 61, 'Arora'),
(59, 61, 'Arya Vysya'),
(60, 61, 'Aryasamaj'),
(61, 61, 'Ayyaraka'),
(62, 61, 'Baghel/Pal/Gaderiya'),
(63, 61, 'Bahi'),
(64, 61, 'Baidya'),
(65, 61, 'Baishnab'),
(66, 61, 'Baishya'),
(67, 61, 'Bajantri'),
(68, 61, 'Balija'),
(69, 61, 'Balija - Naidu'),
(70, 61, 'Banik'),
(71, 61, 'Baniya'),
(72, 61, 'Bari'),
(73, 61, 'Barnwal'),
(74, 61, 'Barujibi'),
(75, 61, 'Bengali'),
(76, 61, 'Besta'),
(77, 61, 'Bhandari'),
(78, 61, 'Bhatia'),
(79, 61, 'Bhatraju'),
(80, 61, 'Bhavsar'),
(81, 61, 'Bhovi'),
(82, 61, 'Billava'),
(83, 61, 'Boya/Nayak/Naik'),
(84, 61, 'Brahmin - Anavil'),
(85, 61, 'Brahmin - Audichya'),
(86, 61, 'Brahmin - Barendra'),
(87, 61, 'Brahmin - Bengali'),
(88, 61, 'Brahmin - Bhatt'),
(89, 61, 'Brahmin - Bhumihar'),
(90, 61, 'Brahmin - Brahmbhatt'),
(91, 61, 'Brahmin - Dadhich/Dadheech'),
(92, 61, 'Brahmin - Daivadnya'),
(93, 61, 'Brahmin - Danua'),
(94, 61, 'Brahmin - Deshastha'),
(95, 61, 'Brahmin - Dhiman'),
(96, 61, 'Brahmin - Dravida'),
(97, 61, 'Brahmin - Embrandiri'),
(98, 61, 'Brahmin - Garhwali'),
(99, 61, 'Brahmin - Goswami'),
(100, 61, 'Brahmin - Gour'),
(101, 61, 'Brahmin - Gowd Saraswat'),
(102, 61, 'Brahmin - Halua'),
(103, 61, 'Brahmin - Havyaka'),
(104, 61, 'Brahmin - Himachali'),
(105, 61, 'Brahmin - Hoysala'),
(106, 61, 'Brahmin - Jangid'),
(107, 61, 'Brahmin - Jhadua'),
(108, 61, 'Brahmin - Jhijhotiya'),
(109, 61, 'Brahmin - Kannada Madhva'),
(110, 61, 'Brahmin - Kanyakubja'),
(111, 61, 'Brahmin - Karhade'),
(112, 61, 'Brahmin - Kashmiri Pandit'),
(113, 61, 'Brahmin - Kokanastha'),
(114, 61, 'Brahmin - Kota'),
(115, 61, 'Brahmin - Kulin'),
(116, 61, 'Brahmin - Kumaoni'),
(117, 61, 'Brahmin - Madhwa'),
(118, 61, 'Brahmin - Maharashtrian'),
(119, 61, 'Brahmin - Maithili'),
(120, 61, 'Brahmin - Modh'),
(121, 61, 'Brahmin - Mohyal'),
(122, 61, 'Brahmin - Nagar'),
(123, 61, 'Brahmin - Namboodiri'),
(124, 61, 'Brahmin - Niyogi'),
(125, 61, 'Brahmin - Niyogi Nandavariki'),
(126, 61, 'Brahmin - Paliwal'),
(127, 61, 'Brahmin - Panda'),
(128, 61, 'Brahmin - Pareek'),
(129, 61, 'Brahmin - Punjabi'),
(130, 61, 'Brahmin - Pushkarna'),
(131, 61, 'Brahmin - Rarhi'),
(132, 61, 'Brahmin - Rudraj'),
(133, 61, 'Brahmin - Sakaldwipi'),
(134, 61, 'Brahmin - Sanadya'),
(135, 61, 'Brahmin - Sanketi'),
(136, 61, 'Brahmin - Saraswat'),
(137, 61, 'Brahmin - Saryuparin'),
(138, 61, 'Brahmin - Shivhalli'),
(139, 61, 'Brahmin - Shrimali'),
(140, 61, 'Brahmin - Smartha'),
(141, 61, 'Brahmin - Sri Vaishnava'),
(142, 61, 'Brahmin - Stanika'),
(143, 61, 'Brahmin - Tyagi'),
(144, 61, 'Brahmin - Vaidiki'),
(145, 61, 'Brahmin - Vaikhanasa'),
(146, 61, 'Brahmin - Velanadu'),
(147, 61, 'Brahmin - Vyas'),
(148, 61, 'Brahmo'),
(149, 61, 'Buddar'),
(150, 61, 'Bunt (Shetty)'),
(151, 61, 'CKP'),
(152, 61, 'Chalawadi Holeya'),
(153, 61, 'Chambhar'),
(154, 61, 'Chandravanshi Kahar'),
(155, 61, 'Chasa'),
(156, 61, 'Chaurasia'),
(157, 61, 'Chekkala - Nair'),
(158, 61, 'Chennadasar'),
(159, 61, 'Cheramar'),
(160, 61, 'Chhetri'),
(161, 61, 'Chippolu/Mera'),
(162, 61, 'Coorgi'),
(163, 61, 'Devadiga'),
(164, 61, 'Devanga'),
(165, 61, 'Dhangar'),
(166, 61, 'Dheevara'),
(167, 61, 'Dhiman'),
(168, 61, 'Dhoba'),
(169, 61, 'Digambar'),
(170, 61, 'Dommala'),
(171, 61, 'Ediga'),
(172, 61, 'Ezhava'),
(173, 61, 'Ezhuthachan'),
(174, 61, 'Gabit'),
(175, 61, 'Ganakar'),
(176, 61, 'Gandla'),
(177, 61, 'Ganiga'),
(178, 61, 'Garhwali'),
(179, 61, 'Gatti'),
(180, 61, 'Gavali'),
(181, 61, 'Gavara'),
(182, 61, 'Ghumar'),
(183, 61, 'Goala'),
(184, 61, 'Goan'),
(185, 61, 'Goswami'),
(186, 61, 'Goud'),
(187, 61, 'Goud Saraswat Brahmin (GSB)'),
(188, 61, 'Gowda'),
(189, 61, 'Gudia'),
(190, 61, 'Gujarati'),
(191, 61, 'Gujjar'),
(192, 61, 'Gupta'),
(193, 61, 'Guptan'),
(194, 61, 'Gurjar'),
(195, 61, 'Hegde'),
(196, 61, 'Helava'),
(197, 61, 'Hugar (Jeer)'),
(198, 61, 'Jaalari'),
(199, 61, 'Jaiswal'),
(200, 61, 'Jandra'),
(201, 61, 'Jangam'),
(202, 61, 'Jat'),
(203, 61, 'Jatav'),
(204, 61, 'Jetty Malla'),
(205, 61, 'Kachara'),
(206, 61, 'Kaibarta'),
(207, 61, 'Kakkalan'),
(208, 61, 'Kalar'),
(209, 61, 'Kalinga'),
(210, 61, 'Kalinga Vysya'),
(211, 61, 'Kalita'),
(212, 61, 'Kalwar'),
(213, 61, 'Kamboj'),
(214, 61, 'Kamma'),
(215, 61, 'Kammala'),
(216, 61, 'Kaniyan'),
(217, 61, 'Kannada Mogaveera'),
(218, 61, 'Kansari'),
(219, 61, 'Kapu'),
(220, 61, 'Kapu Naidu'),
(221, 61, 'Karana'),
(222, 61, 'Karmakar'),
(223, 61, 'Kartha'),
(224, 61, 'Kasar'),
(225, 61, 'Kashyap'),
(226, 61, 'Kavuthiyya/Ezhavathy'),
(227, 61, 'Kayastha'),
(228, 61, 'Khandayat'),
(229, 61, 'Khandelwal'),
(230, 61, 'Kharwar'),
(231, 61, 'Khatik'),
(232, 61, 'Khatri'),
(233, 61, 'Koli'),
(234, 61, 'Konkani'),
(235, 61, 'Korama'),
(236, 61, 'Kori'),
(237, 61, 'Koshti'),
(238, 61, 'Kshatriya - Bhavasar'),
(239, 61, 'Kshatriya/Raju/Varma'),
(240, 61, 'Kudumbi'),
(241, 61, 'Kulal'),
(242, 61, 'Kulita'),
(243, 61, 'Kumawat'),
(244, 61, 'Kumbara'),
(245, 61, 'Kumbhakar/Kumbhar'),
(246, 61, 'Kumhar'),
(247, 61, 'Kummari'),
(248, 61, 'Kunbi'),
(249, 61, 'Kurava'),
(250, 61, 'Kurmi'),
(251, 61, 'Kuruba'),
(252, 61, 'Kuruhina Shetty'),
(253, 61, 'Kurup'),
(254, 61, 'Kushwaha'),
(255, 61, 'Kutchi'),
(256, 61, 'Lambadi/Banjara'),
(257, 61, 'Leva Patil'),
(258, 61, 'Lingayath'),
(259, 61, 'Lohana'),
(260, 61, 'Lohar'),
(261, 61, 'Loniya/Lonia/Lunia'),
(262, 61, 'Lubana'),
(263, 61, 'Madiga'),
(264, 61, 'Mahajan'),
(265, 61, 'Mahar'),
(266, 61, 'Maharashtrian'),
(267, 61, 'Mahendra'),
(268, 61, 'Maheshwari'),
(269, 61, 'Mahindra'),
(270, 61, 'Mahishya'),
(271, 61, 'Majabi'),
(272, 61, 'Mala'),
(273, 61, 'Malayalee Variar'),
(274, 61, 'Mali'),
(275, 61, 'Mangalorean'),
(276, 61, 'Maniyani'),
(277, 61, 'Mannadiar'),
(278, 61, 'Mannan'),
(279, 61, 'Mapila'),
(280, 61, 'Marar'),
(281, 61, 'Maratha'),
(282, 61, 'Maratha - Gomantak'),
(283, 61, 'Marvar'),
(284, 61, 'Marwari'),
(285, 61, 'Matang'),
(286, 61, 'Maurya'),
(287, 61, 'Meda'),
(288, 61, 'Medara'),
(289, 61, 'Meena'),
(290, 61, 'Mehra'),
(291, 61, 'Menon'),
(292, 61, 'Meru Darji'),
(293, 61, 'Modak'),
(294, 61, 'Mogaveera'),
(295, 61, 'Monchi'),
(296, 61, 'Mudaliar - Arcot'),
(297, 61, 'Mudaliar - Saiva'),
(298, 61, 'Mudiraj'),
(299, 61, 'Munnuru Kapu'),
(300, 61, 'Naagavamsam'),
(301, 61, 'Nagaralu'),
(302, 61, 'Nai'),
(303, 61, 'Naicken'),
(304, 61, 'Nair'),
(305, 61, 'Nair - Chekkala'),
(306, 61, 'Nair - Vaniya'),
(307, 61, 'Nair - Velethadathu'),
(308, 61, 'Nair - Veluthedathu'),
(309, 61, 'Nair - Vilakkithala'),
(310, 61, 'Namasudra'),
(311, 61, 'Nambiar'),
(312, 61, 'Nambisan'),
(313, 61, 'Namboodiri - Brahmin'),
(314, 61, 'Namosudra'),
(315, 61, 'Napit'),
(316, 61, 'Nayaka'),
(317, 61, 'Neeli'),
(318, 61, 'Nepali'),
(319, 61, 'Nhavi'),
(320, 61, 'OBC - Barber/Naayee'),
(321, 61, 'Oswal'),
(322, 61, 'Otari'),
(323, 61, 'Padmasali'),
(324, 61, 'Panchal'),
(325, 61, 'Panicker'),
(326, 61, 'Paravan'),
(327, 61, 'Parit'),
(328, 61, 'Partraj'),
(329, 61, 'Patel'),
(330, 61, 'Patel - Desai'),
(331, 61, 'Patel - Dodia'),
(332, 61, 'Patel - Kadva'),
(333, 61, 'Patel - Leva'),
(334, 61, 'Patnaick'),
(335, 61, 'Patra'),
(336, 61, 'Perika'),
(337, 61, 'Pisharody'),
(338, 61, 'Poduval'),
(339, 61, 'Poosala'),
(340, 61, 'Prajapati'),
(341, 61, 'Pulaya'),
(342, 61, 'Punjabi'),
(343, 61, 'Rajaka/Chakali/Dhobi'),
(344, 61, 'Rajbhar'),
(345, 61, 'Rajput'),
(346, 61, 'Rajput - Garhwali'),
(347, 61, 'Rajput - Kumaoni'),
(348, 61, 'Rajput - Lodhi'),
(349, 61, 'Ramdasia'),
(350, 61, 'Ramgharia'),
(351, 61, 'Ravidasia'),
(352, 61, 'Rawat'),
(353, 61, 'Reddiar'),
(354, 61, 'Relli'),
(355, 61, 'SSK'),
(356, 61, 'Sadgop'),
(357, 61, 'Sagara - Uppara'),
(358, 61, 'Saha'),
(359, 61, 'Sahu'),
(360, 61, 'Saini'),
(361, 61, 'Saiva Vellala'),
(362, 61, 'Saliya'),
(363, 61, 'Sambava'),
(364, 61, 'Saraswat - Brahmin'),
(365, 61, 'Savji'),
(366, 61, 'Sepahia'),
(367, 61, 'Setti Balija'),
(368, 61, 'Shah'),
(369, 61, 'Shimpi'),
(370, 61, 'Sindhi'),
(371, 61, 'Sindhi - Bhanusali'),
(372, 61, 'Sindhi - Bhatia'),
(373, 61, 'Sindhi - Chhapru'),
(374, 61, 'Sindhi - Dadu'),
(375, 61, 'Sindhi - Hyderabadi'),
(376, 61, 'Sindhi - Larai'),
(377, 61, 'Sindhi - Lohana'),
(378, 61, 'Sindhi - Rohiri'),
(379, 61, 'Sindhi - Sehwani'),
(380, 61, 'Sindhi - Thatai'),
(381, 61, 'Sindhi-Amil'),
(382, 61, 'Sindhi-Baibhand'),
(383, 61, 'Sindhi-Larkana'),
(384, 61, 'Sindhi-Sahiti'),
(385, 61, 'Sindhi-Sakkhar'),
(386, 61, 'Sindhi-Shikarpuri'),
(387, 61, 'Somvanshi'),
(388, 61, 'Sonar'),
(389, 61, 'Soni'),
(390, 61, 'Sowrashtra'),
(391, 61, 'Sri Vaishnava'),
(392, 61, 'Srisayana'),
(393, 61, 'Subarna Banik'),
(394, 61, 'Sugali (Naika)'),
(395, 61, 'Sundhi'),
(396, 61, 'Surya Balija'),
(397, 61, 'Sutar'),
(398, 61, 'Swarnakar'),
(399, 61, 'Tamboli'),
(400, 61, 'Tamil Yadava'),
(401, 61, 'Tanti'),
(402, 61, 'Tantuway'),
(403, 61, 'Telaga'),
(404, 61, 'Teli'),
(405, 61, 'Thachar'),
(406, 61, 'Thakkar'),
(407, 61, 'Thakur'),
(408, 61, 'Thandan'),
(409, 61, 'Thigala'),
(410, 61, 'Thiyya'),
(411, 61, 'Togata'),
(412, 61, 'Turupu Kapu'),
(413, 61, 'Udayar'),
(414, 61, 'Urs'),
(415, 61, 'Vada Balija'),
(416, 61, 'Vadagalai'),
(417, 61, 'Vaddera'),
(418, 61, 'Vaduka'),
(419, 61, 'Vaish'),
(420, 61, 'Vaish - Dhaneshawat'),
(421, 61, 'Vaishnav'),
(422, 61, 'Vaishnav - Bhatia'),
(423, 61, 'Vaishnav - Vania'),
(424, 61, 'Vallala'),
(425, 61, 'Valmiki'),
(426, 61, 'Vanika Vyshya'),
(427, 61, 'Vaniya - Nair'),
(428, 61, 'Vanjara'),
(429, 61, 'Vankar'),
(430, 61, 'Vannan'),
(431, 61, 'Vanniyar'),
(432, 61, 'Variar'),
(433, 61, 'Varshney'),
(434, 61, 'Veerashaiva'),
(435, 61, 'Velaan'),
(436, 61, 'Velama'),
(437, 61, 'Velar'),
(438, 61, 'Veluthedathu - Nair'),
(439, 61, 'Vilakithala - Nair'),
(440, 61, 'Viswabrahmin'),
(441, 61, 'Vokaliga'),
(442, 61, 'Waada Balija'),
(443, 61, 'Warrier'),
(444, 61, 'Yellapu'),
(445, 61, 'Other'),
(446, 51, 'Bengali'),
(447, 51, 'Dawoodi Bohra'),
(448, 51, 'Khoja'),
(449, 51, 'Mapila'),
(450, 51, 'Memon'),
(451, 51, 'Rajput'),
(452, 51, 'Rowther'),
(453, 51, 'Shafi'),
(454, 51, 'Shia'),
(455, 51, 'Shia Bohra'),
(456, 51, 'Shia Imami Ismaili'),
(457, 51, 'Shia Ithna ashariyyah'),
(458, 51, 'Shia Zaidi'),
(459, 51, 'Sunni'),
(460, 51, 'Sunni Ehle-Hadith'),
(461, 51, 'Sunni Hanafi'),
(462, 51, 'Sunni Hunbali'),
(463, 51, 'Sunni Maliki'),
(464, 51, 'Sunni Shafi'),
(465, 3, 'Anglo Indian'),
(466, 3, 'Basel Mission'),
(467, 3, 'Born Again'),
(468, 3, 'Bretheren'),
(469, 3, 'CMS'),
(470, 3, 'Cannonite'),
(471, 3, 'Catholic'),
(472, 3, 'Catholic Knanya'),
(473, 3, 'CCatholic Malankara'),
(474, 3, 'Chaldean Syrian'),
(475, 3, 'Cheramar'),
(476, 3, 'Christian Nadar'),
(477, 3, 'Church of North India (CNI)'),
(478, 3, 'Church of South India (CSI)'),
(479, 3, 'Convert'),
(480, 3, 'Evangelical'),
(481, 3, 'IPC'),
(482, 3, 'Indian Orthodox'),
(483, 3, 'Intercaste'),
(484, 3, 'Jacobite'),
(485, 3, 'Jacobite Knanya'),
(486, 3, 'Knanaya'),
(487, 3, 'Knanaya Catholic'),
(488, 3, 'Knanaya Jacobite'),
(489, 3, 'Knanaya Pentecostal'),
(490, 3, 'Knanya'),
(491, 3, 'Latin Catholic'),
(492, 3, 'Malankara'),
(493, 3, 'Malankara Catholic'),
(494, 3, 'Manglorean'),
(495, 3, 'Marthoma'),
(496, 3, 'Methodist'),
(497, 3, 'Mormon'),
(498, 3, 'Nadar'),
(499, 3, 'Orthodox'),
(500, 3, 'Pentecost'),
(501, 3, 'Presbyterian'),
(502, 3, 'Protestant'),
(503, 3, 'RCSC'),
(504, 3, 'Roman Catholic'),
(505, 3, 'Salvation Army'),
(506, 3, 'Scheduled Caste (SC)'),
(507, 3, 'Scheduled Tribe (ST)'),
(508, 3, 'Seventh day Adventist'),
(509, 3, 'Syrian'),
(510, 3, 'Syrian Catholic'),
(511, 3, 'Syrian Orthodox'),
(512, 3, 'Syro Malabar'),
(513, 61, 'Aasariyar');
-- --------------------------------------------------------
--
-- Table structure for table `cms_banner`
--
CREATE TABLE `cms_banner` (
`id` int NOT NULL,
`image` text
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `cms_banner`
--
INSERT INTO `cms_banner` (`id`, `image`) VALUES
(1, 'bell_gl1524317266.jpg');
-- --------------------------------------------------------
--
-- Table structure for table `cms_content`
--
CREATE TABLE `cms_content` (
`id` int NOT NULL,
`placement` varchar(60) NOT NULL,
`title` varchar(60) NOT NULL,
`contents` varchar(5000) NOT NULL,
`updated_by` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
--
-- Dumping data for table `cms_content`
--
INSERT INTO `cms_content` (`id`, `placement`, `title`, `contents`, `updated_by`) VALUES
(3, 'column2', 'Trusted Wedding Matrimony Website', 'Wedding Matrimonial Site For Tamil Brides And Grooms In Dindigul, Tamilnadu. We Have All Community Marriage Profiles For All Religions Of Brides And Grooms. The Most Trusted Matrimonial Website For Search Your Life Partner From Lakhs Of Matching Profiles.', '2018-01-02'),
(4, 'column1', 'No.1 Tamil Matchmaking Service', 'Find Brides And Grooms In Leading Matrimony In Dindigul. Bells Matrimony Is A Popular Dindigul Matrimonial Website In Dindigul For All Community Marriage. Wedding Matrimonial Site For Tamil Marriages. Find The Perfect Partner With Free Register With Bells Matrimony.', '2018-01-02');
-- --------------------------------------------------------
--
-- Table structure for table `country`
--
CREATE TABLE `country` (
`country_id` int NOT NULL,
`country` varchar(200) DEFAULT NULL,
`iso_code` varchar(15) DEFAULT NULL,
`isd_code` int DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
--
-- Dumping data for table `country`
--
INSERT INTO `country` (`country_id`, `country`, `iso_code`, `isd_code`) VALUES
(120, 'Liberia', 'LR', 231),
(119, 'Lesotho', 'LS', 266),
(118, 'Lebanon', 'LB', 961),
(117, 'Latvia', 'LV', 371),
(116, 'Lao People\'s Democratic Republic', 'LA', 856),
(115, 'Kyrgyzstan', 'KG', 996),
(114, 'Kuwait', 'KW', 965),
(113, 'South Korea', 'KR', 82),
(112, 'Korea, Democratic People\'s Republic of', 'KP', 850),
(111, 'Kiribati', 'KI', 686),
(110, 'Kenya', 'KE', 254),
(109, 'Kazakhstan', 'KZ', 7),
(108, 'Jordan', 'JO', 962),
(107, 'Japan', 'JP', 81),
(106, 'Jamaica', 'JM', 1),
(105, 'Italy', 'IT', 39),
(104, 'Israel', 'IL', 972),
(103, 'Ireland', 'IE', 353),
(102, 'Iraq', 'IQ', 964),
(101, 'Iran (Islamic Republic of)', 'IR', 98),
(100, 'Indonesia', 'ID', 62),
(99, 'India', 'IN', 91),
(98, 'Iceland', 'IS', 354),
(97, 'Hungary', 'HU', 36),
(96, 'Hong Kong', 'HK', 852),
(95, 'Honduras', 'HN', 504),
(94, 'Heard Island and McDonald Islands', 'HM', 11),
(93, 'Haiti', 'HT', 509),
(92, 'Guyana', 'GY', 592),
(91, 'Guinea-bissau', 'GW', 245),
(90, 'Guinea', 'GN', 224),
(89, 'Guatemala', 'GT', 502),
(88, 'Guam', 'GU', 1),
(87, 'Guadeloupe', 'GP', 590),
(86, 'Grenada', 'GD', 1),
(85, 'Greenland', 'GL', 299),
(84, 'Greece', 'GR', 30),
(83, 'Gibraltar', 'GI', 350),
(82, 'Ghana', 'GH', 233),
(81, 'Germany', 'DE', 49),
(80, 'Georgia', 'GE', 995),
(79, 'Gambia', 'GM', 220),
(78, 'Gabon', 'GA', 241),
(77, 'French Southern Territories', 'TF', NULL),
(76, 'French Polynesia', 'PF', 689),
(75, 'French Guiana', 'GF', 594),
(73, 'France', 'FR', 33),
(72, 'Finland', 'FI', 358),
(71, 'Fiji', 'FJ', 679),
(70, 'Faroe Islands', 'FO', 298),
(69, 'Falkland Islands (Malvinas)', 'FK', 500),
(68, 'Ethiopia', 'ET', 251),
(67, 'Estonia', 'EE', 372),
(66, 'Eritrea', 'ER', 291),
(65, 'Equatorial Guinea', 'GQ', 240),
(64, 'El Salvador', 'SV', 503),
(63, 'Egypt', 'EG', 20),
(62, 'Ecuador', 'EC', 593),
(61, 'Timor-Leste', 'TL', 670),
(60, 'Dominican Republic', 'DO', 1),
(59, 'Dominica', 'DM', 1),
(58, 'Djibouti', 'DJ', 253),
(57, 'Denmark', 'DK', 45),
(56, 'Czech Republic', 'CZ', 420),
(55, 'Cyprus', 'CY', 357),
(54, 'Cuba', 'CU', 53),
(53, 'Croatia', 'HR', 385),
(52, 'Cote D\'Ivoire', 'CI', 225),
(51, 'Costa Rica', 'CR', 506),
(50, 'Cook Islands', 'CK', 682),
(49, 'Congo Democratic Republic of', 'CG', 242),
(48, 'Comoros', 'KM', 269),
(47, 'Colombia', 'CO', 57),
(46, 'Cocos (Keeling) Islands', 'CC', 61),
(45, 'Christmas Island', 'CX', 61),
(44, 'China', 'CN', 86),
(43, 'Chile', 'CL', 56),
(42, 'Chad', 'TD', 235),
(41, 'Central African Republic', 'CF', 236),
(40, 'Cayman Islands', 'KY', 1),
(39, 'Cape Verde', 'CV', 238),
(38, 'Canada', 'CA', 1),
(37, 'Cameroon', 'CM', 237),
(36, 'Cambodia', 'KH', 855),
(35, 'Burundi', 'BI', 257),
(34, 'Burkina Faso', 'BF', 226),
(33, 'Bulgaria', 'BG', 359),
(32, 'Brunei Darussalam', 'BN', 673),
(31, 'British Indian Ocean Territory', 'IO', 246),
(30, 'Brazil', 'BR', 55),
(29, 'Bouvet Island', 'BV', 47),
(28, 'Botswana', 'BW', 267),
(27, 'Bosnia and Herzegowina', 'BA', 387),
(26, 'Bolivia', 'BO', 591),
(25, 'Bhutan', 'BT', 975),
(24, 'Bermuda', 'BM', 1),
(23, 'Benin', 'BJ', 229),
(22, 'Belize', 'BZ', 501),
(21, 'Belgium', 'BE', 32),
(20, 'Belarus', 'BY', 375),
(19, 'Barbados', 'BB', 1),
(18, 'Bangladesh', 'BD', 880),
(17, 'Bahrain', 'BH', 973),
(16, 'Bahamas', 'BS', 1),
(15, 'Azerbaijan', 'AZ', 994),
(14, 'Austria', 'AT', 43),
(13, 'Australia', 'AU', 61),
(12, 'Aruba', 'AW', 297),
(11, 'Armenia', 'AM', 374),
(10, 'Argentina', 'AR', 54),
(9, 'Antigua and Barbuda', 'AG', 1),
(8, 'Antarctica', 'AQ', 672),
(7, 'Anguilla', 'AI', 1),
(6, 'Angola', 'AO', 244),
(5, 'Andorra', 'AD', 376),
(4, 'American Samoa', 'AS', 1),
(3, 'Algeria', 'DZ', 213),
(2, 'Albania', 'AL', 355),
(1, 'Afghanistan', 'AF', 93),
(121, 'Libya', 'LY', 218),
(122, 'Liechtenstein', 'LI', 423),
(123, 'Lithuania', 'LT', 370),
(124, 'Luxembourg', 'LU', 352),
(125, 'Macao', 'MO', 853),
(126, 'Macedonia, The Former Yugoslav Republic of', 'MK', 389),
(127, 'Madagascar', 'MG', 261),
(128, 'Malawi', 'MW', 265),
(129, 'Malaysia', 'MY', 60),
(130, 'Maldives', 'MV', 960),
(131, 'Mali', 'ML', 223),
(132, 'Malta', 'MT', 356),
(133, 'Marshall Islands', 'MH', 692),
(134, 'Martinique', 'MQ', 596),
(135, 'Mauritania', 'MR', 222),
(136, 'Mauritius', 'MU', 230),
(137, 'Mayotte', 'YT', 262),
(138, 'Mexico', 'MX', 52),
(139, 'Micronesia, Federated States of', 'FM', 691),
(140, 'Moldova', 'MD', 373),
(141, 'Monaco', 'MC', 377),
(142, 'Mongolia', 'MN', 976),
(143, 'Montserrat', 'MS', 1),
(144, 'Morocco', 'MA', 212),
(145, 'Mozambique', 'MZ', 258),
(146, 'Myanmar', 'MM', 95),
(147, 'Namibia', 'NA', 264),
(148, 'Nauru', 'NR', 674),
(149, 'Nepal', 'NP', 977),
(150, 'Netherlands', 'NL', 31),
(151, 'Netherlands Antilles', 'AN', 599),
(152, 'New Caledonia', 'NC', 687),
(153, 'New Zealand', 'NZ', 64),
(154, 'Nicaragua', 'NI', 505),
(155, 'Niger', 'NE', 227),
(156, 'Nigeria', 'NG', 234),
(157, 'Niue', 'NU', 683),
(158, 'Norfolk Island', 'NF', 672),
(159, 'Northern Mariana Islands', 'MP', 1),
(160, 'Norway', 'NO', 47),
(161, 'Oman', 'OM', 968),
(162, 'Pakistan', 'PK', 92),
(163, 'Palau', 'PW', 680),
(164, 'Panama', 'PA', 507),
(165, 'Papua New Guinea', 'PG', 675),
(166, 'Paraguay', 'PY', 595),
(167, 'Peru', 'PE', 51),
(168, 'Philippines', 'PH', 63),
(169, 'Pitcairn', 'PN', 64),
(170, 'Poland', 'PL', 48),
(171, 'Portugal', 'PT', 351),
(172, 'Puerto Rico', 'PR', 1),
(173, 'Qatar', 'QA', 974),
(174, 'Reunion', 'RE', 262),
(175, 'Romania', 'RO', 40),
(176, 'Russian Federation', 'RU', 7),
(177, 'Rwanda', 'RW', 250),
(178, 'Saint Kitts and Nevis', 'KN', 1),
(179, 'Saint Lucia', 'LC', 1),
(180, 'Saint Vincent and the Grenadines', 'VC', 1),
(181, 'Samoa', 'WS', 685),
(182, 'San Marino', 'SM', 378),
(183, 'Sao Tome and Principe', 'ST', 239),
(184, 'Saudi Arabia', 'SA', 966),
(185, 'Senegal', 'SN', 221),
(186, 'Seychelles', 'SC', 248),
(187, 'Sierra Leone', 'SL', 232),
(188, 'Singapore', 'SG', 65),
(189, 'Slovakia (Slovak Republic)', 'SK', 421),
(190, 'Slovenia', 'SI', 386),
(191, 'Solomon Islands', 'SB', 677),
(192, 'Somalia', 'SO', 252),
(193, 'South Africa', 'ZA', 27),
(194, 'South Georgia and the South Sandwich Islands', 'GS', 500),
(195, 'Spain', 'ES', 34),
(196, 'Sri Lanka', 'LK', 94),
(197, 'Saint Helena, Ascension and Tristan da Cunha', 'SH', 290),
(198, 'St. Pierre and Miquelon', 'PM', 508),
(199, 'Sudan', 'SD', 249),
(200, 'Suriname', 'SR', 597),
(201, 'Svalbard and Jan Mayen Islands', 'SJ', 47),
(202, 'Swaziland', 'SZ', 268),
(203, 'Sweden', 'SE', 46),
(204, 'Switzerland', 'CH', 41),
(205, 'Syrian Arab Republic', 'SY', 963),
(206, 'Taiwan', 'TW', 886),
(207, 'Tajikistan', 'TJ', 992),
(208, 'Tanzania, United Republic of', 'TZ', 255),
(209, 'Thailand', 'TH', 66),
(210, 'Togo', 'TG', 228),
(211, 'Tokelau', 'TK', 690),
(212, 'Tonga', 'TO', 676),
(213, 'Trinidad and Tobago', 'TT', 1),
(214, 'Tunisia', 'TN', 216),
(215, 'Turkey', 'TR', 90),
(216, 'Turkmenistan', 'TM', 993),
(217, 'Turks and Caicos Islands', 'TC', 1),
(218, 'Tuvalu', 'TV', 688),
(219, 'Uganda', 'UG', 256),
(220, 'Ukraine', 'UA', 380),
(221, 'United Arab Emirates', 'AE', 971),
(222, 'United Kingdom', 'GB', 44),
(223, 'United States', 'US', 1),
(224, 'United States Minor Outlying Islands', 'UM', 246),
(225, 'Uruguay', 'UY', 598),
(226, 'Uzbekistan', 'UZ', 998),
(227, 'Vanuatu', 'VU', 678),
(228, 'Vatican City State (Holy See)', 'VA', 379),
(229, 'Venezuela', 'VE', 58),
(230, 'Vietnam', 'VN', 84),
(231, 'Virgin Islands (British)', 'VG', 1),
(232, 'Virgin Islands (U.S.)', 'VI', 1),
(233, 'Wallis and Futuna Islands', 'WF', 681),
(234, 'Western Sahara', 'EH', 212),
(235, 'Yemen', 'YE', 967),
(236, 'Serbia', 'RS', 381),
(238, 'Zambia', 'ZM', 260),
(239, 'Zimbabwe', 'ZW', 263),
(240, 'Aaland Islands', 'AX', 358),
(241, 'Palestine', 'PS', 970),
(242, 'Montenegro', 'ME', 382),
(243, 'Guernsey', 'GG', 44),
(244, 'Isle of Man', 'IM', 44),
(245, 'Jersey', 'JE', 44),
(247, 'Curaçao', 'CW', 599),
(248, 'Ivory Coast', 'CI', 225),
(249, 'Kosovo', 'XK', 383);
-- --------------------------------------------------------
--
-- Table structure for table `diet`
--
CREATE TABLE `diet` (
`id` int NOT NULL,
`diet` varchar(30) DEFAULT NULL,
`diet_tamil` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `diet`
--
INSERT INTO `diet` (`id`, `diet`, `diet_tamil`) VALUES
(1, 'Veg', 'சைவம்'),
(2, 'Non-Veg', 'அசைவம்'),
(3, 'Occasionally Non-Veg', 'எப்போதாவது அசைவம்'),
(4, 'Eggaleration', 'முட்டை மட்டும்'),
(5, 'Jain', 'சமணம்'),
(6, 'Vegan', 'சைவ சமயம்');
-- --------------------------------------------------------
--
-- Table structure for table `district`
--
CREATE TABLE `district` (
`district_id` int NOT NULL,
`state_id` int NOT NULL,
`district` varchar(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `district`
--
INSERT INTO `district` (`district_id`, `state_id`, `district`) VALUES
(20, 79, 'Ariyalur'),
(21, 79, 'Chennai'),
(22, 79, 'Coimbatore'),
(23, 79, 'Cuddalore'),
(24, 79, 'Dharmapuri'),
(25, 79, 'Dindigul'),
(26, 79, 'Erode'),
(27, 79, 'Kancheepuram'),
(28, 79, 'Karur'),
(29, 79, 'Krishnagiri'),
(30, 79, 'Madurai'),
(31, 79, 'Nagapattinam'),
(32, 79, 'Kanyakumari'),
(33, 79, 'Namakkal'),
(34, 79, 'Perambalur'),
(35, 79, 'Pudukottai'),
(36, 79, 'Ramanathapuram'),
(37, 79, 'Salem'),
(38, 79, 'Sivagangai'),
(39, 79, 'Thanjavur'),
(40, 79, 'Theni'),
(41, 79, 'Thiruvallur'),
(42, 79, 'Thiruvarur'),
(43, 79, 'Tuticorin'),
(44, 79, 'Trichirappalli'),
(45, 79, 'Thirunelveli'),
(46, 79, 'Tiruppur'),
(47, 79, 'Thiruvannamalai'),
(48, 79, 'The Nilgiris'),
(49, 79, 'Vellore'),
(50, 79, 'Villupuram'),
(51, 79, 'Virudhunagar'),
(52, 58, 'Anantapur'),
(53, 58, 'Chittoor'),
(54, 58, 'East Godavari'),
(55, 58, 'Guntur'),
(56, 58, 'Cuddapah'),
(57, 58, 'Krishna'),
(58, 58, 'Kurnool'),
(59, 58, 'Prakasam'),
(60, 58, 'Nellore'),
(61, 58, 'Srikakulam'),
(62, 58, 'Vishakhapatnam'),
(63, 58, 'Vizianagaram'),
(64, 58, 'West Godavari'),
(65, 59, 'Anjaw'),
(66, 59, 'Changlang'),
(67, 59, 'Dibang Valley'),
(68, 59, 'East Kameng'),
(69, 59, 'East Siang'),
(70, 59, 'Kra Daadi'),
(71, 59, 'Kurung Kumey'),
(72, 59, 'Lohit'),
(73, 59, 'Longding'),
(74, 59, 'Lower Dibang Valley'),
(75, 59, 'Lower Subansiri'),
(76, 59, 'Namsai'),
(77, 59, 'Papum Pare'),
(78, 59, 'Siang'),
(79, 59, 'Tawang'),
(80, 59, 'Tirap'),
(81, 59, 'Upper Siang'),
(82, 59, 'Upper Subansiri'),
(83, 59, 'West Kameng'),
(84, 59, 'West Siang'),
(85, 60, 'Barpeta'),
(86, 60, 'Baksa'),
(87, 60, 'Bongaigaon'),
(88, 60, 'Cachar'),
(89, 60, 'Chirang'),
(90, 60, 'Darrang'),
(91, 60, 'Dhemaji'),
(92, 60, 'Dhubri'),
(93, 60, 'Dibrugarh'),
(94, 60, 'Dima Hasao'),
(95, 60, 'Goalpara'),
(96, 60, 'Golaghat'),
(97, 60, 'Hailakandi'),
(98, 60, 'Jorhat'),
(99, 60, 'Kamrup (Metro)'),
(100, 60, 'Kamrup'),
(101, 60, 'Karbi Anglong'),
(102, 60, 'Karimganj'),
(103, 60, 'Kokrajhar'),
(104, 60, 'Lakhimpur'),
(105, 60, 'Morigaon'),
(106, 60, 'Nagaon'),
(107, 60, 'Nalbari'),
(108, 60, 'Sivasagar'),
(109, 60, 'Sonitpur'),
(110, 60, 'Tinsukia'),
(111, 60, 'Udalguri'),
(112, 61, 'Araria'),
(113, 61, 'Arwal'),
(114, 61, 'Aurangabad'),
(115, 61, 'Banka'),
(116, 61, 'Begusarai'),
(117, 61, 'Bhagalpur'),
(118, 61, 'Bhojpur'),
(119, 61, 'Buxar'),
(120, 61, 'Darbhanga'),
(121, 61, 'East Champaran'),
(122, 61, 'Gaya'),
(123, 61, 'Gopalganj'),
(124, 61, 'Jamui'),
(125, 61, 'Jehanabad'),
(126, 61, 'Kaimur'),
(127, 61, 'Katihar'),
(128, 61, 'Khagaria'),
(129, 61, 'Kishanganj'),
(130, 61, 'Lakhisarai'),
(131, 61, 'Madhepura'),
(132, 61, 'Madhubani'),
(133, 61, 'Monghyr'),
(134, 61, 'Muzaffarpur'),
(135, 61, 'Nalanda'),
(136, 61, 'Nawada'),
(137, 61, 'Patna'),
(138, 61, 'Purnea'),
(139, 61, 'Rohtas'),
(140, 61, 'Saharsa'),
(141, 61, 'Samastipur'),
(142, 61, 'Saran'),
(143, 61, 'Shiekhpura'),
(144, 61, 'Sheohar'),
(145, 61, 'Sitamarhi'),
(146, 61, 'Siwan'),
(147, 61, 'Supaul'),
(148, 61, 'Vaishali'),
(149, 61, 'West Champaran'),
(150, 62, 'North Goa'),
(151, 62, 'South Goa'),
(152, 63, 'Ahmedabad'),
(153, 63, 'Ahmedabad East'),
(154, 63, 'Amreli'),
(155, 63, 'Anand'),
(156, 63, 'Banaskantha'),
(157, 63, 'Bharuch'),
(158, 63, 'Bhavnagar'),
(159, 63, 'Dahod'),
(160, 63, 'Dang'),
(161, 63, 'Gandhinagar'),
(162, 63, 'Jamnagar'),
(163, 63, 'Junagadh'),
(164, 63, 'Kutch'),
(165, 63, 'Kheda'),
(166, 63, 'Mehsana'),
(167, 63, 'Narmada'),
(168, 63, 'Navsari'),
(169, 63, 'Patan'),
(170, 63, 'Panchmahal'),
(171, 63, 'Porbander'),
(172, 63, 'Rajkot'),
(173, 63, 'Sabarkantha'),
(174, 63, 'Surendranagar'),
(175, 63, 'Surat'),
(176, 63, 'Vadodara'),
(177, 63, 'Valsad'),
(178, 63, 'Vyara'),
(179, 63, 'Aahwa'),
(180, 64, 'Ambala'),
(181, 64, 'Bhiwani'),
(182, 64, 'Charkhi Dadri'),
(183, 64, 'Faridabad'),
(184, 64, 'Fatehabad'),
(185, 64, 'Gurugram'),
(186, 64, 'Hisar'),
(187, 64, 'Jhajjar'),
(188, 64, 'Jind'),
(189, 64, 'Kaithal'),
(190, 64, 'Karnal'),
(191, 64, 'Kurukshetra'),
(192, 64, 'Mahendragarh'),
(193, 64, 'Mewat'),
(194, 64, 'Palwal'),
(195, 64, 'Panchkula'),
(196, 64, 'Panipat'),
(197, 64, 'Rewari'),
(198, 64, 'Rohtak'),
(199, 64, 'Sirsa'),
(200, 64, 'Sonipat'),
(201, 64, 'Yamunanagar'),
(202, 65, 'Bilaspur'),
(203, 65, 'Chamba'),
(204, 65, 'Hamirpur'),
(205, 65, 'Kangra'),
(206, 65, 'Kinnaur'),
(207, 65, 'Kullu'),
(208, 65, 'Lahaul & Spiti'),
(209, 65, 'Mandi'),
(210, 65, 'Shimla'),
(211, 65, 'Sirmaur'),
(212, 65, 'Solan'),
(213, 65, 'Una'),
(214, 66, 'Doda'),
(215, 66, 'Jammu'),
(216, 66, 'Kathua'),
(217, 66, 'Kishtwar'),
(218, 66, 'Poonch'),
(219, 66, 'Rajouri'),
(220, 66, 'Ramban'),
(221, 66, 'Reasi'),
(222, 66, 'Samba'),
(223, 66, 'Udhampur'),
(224, 66, 'Anantnag'),
(225, 66, 'Bandipora'),
(226, 66, 'Baramulla'),
(227, 66, 'Budgam'),
(228, 66, 'Ganderbal'),
(229, 66, 'Kulgam'),
(230, 66, 'Kupwara'),
(231, 66, 'Pulwama'),
(232, 66, 'Shopian'),
(233, 66, 'Srinagar'),
(234, 66, 'Kargil'),
(235, 66, 'Leh'),
(236, 67, 'Bagalkot'),
(237, 67, 'Bangalore'),
(238, 67, 'Belgaum'),
(239, 67, 'Bellary'),
(240, 67, 'Bidar'),
(241, 67, 'Bijapur'),
(242, 67, 'Chamarajanagar'),
(243, 67, 'Chikkaballapura'),
(244, 67, 'Chikmagalur'),
(245, 67, 'Chitradurga'),
(246, 67, 'Mangalore'),
(247, 67, 'Davangere'),
(248, 67, 'Dharwad'),
(249, 67, 'Gadag'),
(250, 67, 'Gulbarga'),
(251, 67, 'Hassan'),
(252, 67, 'Haveri'),
(253, 67, 'Kodagu'),
(254, 67, 'Kolar'),
(255, 67, 'Koppal'),
(256, 67, 'Mandya'),
(257, 67, 'Mysore'),
(258, 67, 'Raichur'),
(259, 67, 'Ramanagara'),
(260, 67, 'Shimoga'),
(261, 67, 'Tumkur'),
(262, 67, 'Udupi'),
(263, 67, 'Uttara Kannada'),
(264, 67, 'Yadgir'),
(265, 68, 'Thiruvananthapuram'),
(266, 68, 'Kollam'),
(267, 68, 'Alappuzha'),
(268, 68, 'Pathanamthitta'),
(269, 68, 'Kottayam'),
(270, 68, 'Idukki'),
(271, 68, 'Ernakulam'),
(272, 68, 'Thrissur'),
(273, 68, 'Palakkad'),
(274, 68, 'Malappuram'),
(275, 68, 'Kozhikode'),
(276, 68, 'Wayanad'),
(277, 68, 'Kannur'),
(278, 68, 'Kasaragod'),
(279, 69, 'Agarmalwa'),
(280, 69, 'Alirajpur'),
(281, 69, 'Anuppur'),
(282, 69, 'Ashoknagar'),
(283, 69, 'Balaghat'),
(284, 69, 'Barwani'),
(285, 69, 'Betul'),
(286, 69, 'Bhind'),
(287, 69, 'Bhopal'),
(288, 69, 'Burhanpur'),
(289, 69, 'Chhatarpur'),
(290, 69, 'Chhindwara'),
(291, 69, 'Damoh'),
(292, 69, 'Datia'),
(293, 69, 'Dewas'),
(294, 69, 'Dhar'),
(295, 69, 'Dindori'),
(296, 69, 'Guna'),
(297, 69, 'Gwalior'),
(298, 69, 'Harda'),
(299, 69, 'Hoshangabad'),
(300, 69, 'Indore'),
(301, 69, 'Jabalpur'),
(302, 69, 'Jhabua'),
(303, 69, 'Katni'),
(304, 69, 'Khandwa'),
(305, 69, 'Khargone'),
(306, 69, 'Mandla'),
(307, 69, 'Mandsaur'),
(308, 69, 'Morena'),
(309, 69, 'Narsinghpur'),
(310, 69, 'Neemuch'),
(311, 69, 'Panna'),
(312, 69, 'Raisen'),
(313, 69, 'Rajgarh'),
(314, 69, 'Ratlam'),
(315, 69, 'Rewa'),
(316, 69, 'Sagar'),
(317, 69, 'Satna'),
(318, 69, 'Sehore'),
(319, 69, 'Seoni'),
(320, 69, 'Singrauli'),
(321, 69, 'Shahdol'),
(322, 69, 'Shajapur'),
(323, 69, 'Sheopur'),
(324, 69, 'Shivpuri'),
(325, 69, 'Sidhi'),
(326, 69, 'Tikamgarh'),
(327, 69, 'Ujjain'),
(328, 69, 'Umaria'),
(329, 69, 'Vidisha'),
(330, 70, 'Ahmednagar'),
(331, 70, 'Jalgaon'),
(332, 70, 'Pune'),
(333, 70, 'Akola'),
(334, 70, 'Jalna'),
(335, 70, 'Raigad'),
(336, 70, 'Amravati'),
(337, 70, 'Kolhapur'),
(338, 70, 'Ratnagiri'),
(339, 70, 'Aurangabad'),
(340, 70, 'Latur'),
(341, 70, 'Sangli Beed'),
(342, 70, 'Mumbai City'),
(343, 70, 'Satara'),
(344, 70, 'Bhandara'),
(345, 70, 'Mumbai Sub-urban'),
(346, 70, 'Sindhudurg'),
(347, 70, 'Buldhana'),
(348, 70, 'Nagpur'),
(349, 70, 'Solapur'),
(350, 70, 'Chandrapur'),
(351, 70, 'Nanded'),
(352, 70, 'Thane'),
(353, 70, 'Dhule'),
(354, 70, 'Nandurbar'),
(355, 70, 'Wardha'),
(356, 70, 'Gadchiroli'),
(357, 70, 'Nashik'),
(358, 70, 'Washim'),
(359, 70, 'Gondia'),
(360, 70, 'Osmanabad'),
(361, 70, 'Yavatmal'),
(362, 70, 'Hingoli'),
(363, 70, 'Parbhani'),
(364, 71, 'Bishnupur'),
(365, 71, 'Chandel'),
(366, 71, 'Churachandpur'),
(367, 71, 'Imphal-East'),
(368, 71, 'Imphal-West'),
(369, 71, 'Senapati'),
(370, 71, 'Tamenglong'),
(371, 71, 'Thoubal'),
(372, 71, 'Ukhrul'),
(373, 71, 'Kangpokpi'),
(374, 71, 'Tengnoupal'),
(375, 71, 'Pherzawl'),
(376, 71, 'Noney'),
(377, 71, 'Kamjong'),
(378, 71, 'Jiribam'),
(379, 71, 'Kakching'),
(380, 72, 'East Garo Hills'),
(381, 72, 'East Jaintia Hills'),
(382, 72, 'East Khasi Hills'),
(383, 72, 'North Garo Hills'),
(384, 72, 'Ri Bhoi'),
(385, 72, 'South Garo Hills'),
(386, 72, 'South West Garo Hills'),
(387, 72, 'South West Khasi Hills'),
(388, 72, 'West Garo Hills'),
(389, 72, 'West Jaintia Hills'),
(390, 72, 'West Khasi Hills'),
(391, 73, 'Aizawl'),
(392, 73, 'Champhai'),
(393, 73, 'Kolasib'),
(394, 73, 'Lawngtlai'),
(395, 73, 'Lunglei'),
(396, 73, 'Mamit'),
(397, 73, 'Saiha'),
(398, 73, 'Serchhip'),
(399, 74, 'Dimapur'),
(400, 74, 'Kiphire'),
(401, 74, 'Kohima'),
(402, 74, 'Longleng'),
(403, 74, 'Mokokchung'),
(404, 74, 'Mon'),
(405, 74, 'Peren'),
(406, 74, 'Phek'),
(407, 74, 'Tuensang'),
(408, 74, 'Wokha'),
(409, 74, 'Zunheboto'),
(410, 75, 'Angul'),
(411, 75, 'Balangir'),
(412, 75, 'Balasore'),
(413, 75, 'Bargarh'),
(414, 75, 'Boudh'),
(415, 75, 'Bhadrak'),
(416, 75, 'Cuttack'),
(417, 75, 'Debagarh'),
(418, 75, 'Dhenkanal'),
(419, 75, 'Gajapati'),
(420, 75, 'Ganjam'),
(421, 75, 'Jagatsinghpur'),
(422, 75, 'Jajpur'),
(423, 75, 'Jharsuguda'),
(424, 75, 'Kalahandi'),
(425, 75, 'Kandhamal'),
(426, 75, 'Kendrapara'),
(427, 75, 'Kendujhar'),
(428, 75, 'Khordha'),
(429, 75, 'Koraput'),
(430, 75, 'Malkangiri'),
(431, 75, 'Mayurbhanj'),
(432, 75, 'Nabarangpur'),
(433, 75, 'Nayagarh'),
(434, 75, 'Nuapada'),
(435, 75, 'Puri'),
(436, 75, 'Rayagada'),
(437, 75, 'Sambalpur'),
(438, 75, 'Subarnapur'),
(439, 75, 'Sundergarh'),
(440, 76, 'Amritsar'),
(441, 76, 'Barnala'),
(442, 76, 'Bathinda'),
(443, 76, 'Fazilka'),
(444, 76, 'Faridkot'),
(445, 76, 'Fatehgarh'),
(446, 76, 'Firozpur'),
(447, 76, 'Gurdaspur'),
(448, 76, 'Hoshiarpur'),
(449, 76, 'Jalandhar'),
(450, 76, 'Kapurthala'),
(451, 76, 'Ludhiana'),
(452, 76, 'Mansa'),
(453, 76, 'Moga'),
(454, 76, 'Mohali'),
(455, 76, 'Muktsar'),
(456, 76, 'Pathankot'),
(457, 76, 'Patiala'),
(458, 76, 'Rupnagar'),
(459, 76, 'Sangrur'),
(460, 76, 'Shahid'),
(461, 76, 'Tarn Taran'),
(462, 77, 'Ajmer'),
(463, 77, 'Alwar'),
(464, 77, 'Banswara'),
(465, 77, 'Baran'),
(466, 77, 'Barmer'),
(467, 77, 'Bharatpur'),
(468, 77, 'Bhilwara'),
(469, 77, 'Bikaner'),
(470, 77, 'Bundi'),
(471, 77, 'Chittorgarh'),
(472, 77, 'Churu'),
(473, 77, 'Dausa'),
(474, 77, 'Dholpur'),
(475, 77, 'Dungarpur'),
(476, 77, 'Hanumangarh'),
(477, 77, 'Jaipur'),
(478, 77, 'Jaisalmer'),
(479, 77, 'Jalore'),
(480, 77, 'Jhalawar'),
(481, 77, 'Jhunjhunu'),
(482, 77, 'Jodhpur'),
(483, 77, 'Karauli'),
(484, 77, 'Kota'),
(485, 77, 'Nagaur'),
(486, 77, 'Pali'),
(487, 77, 'Pratapgarh'),
(488, 77, 'Rajsamand'),
(489, 77, 'Sawai Madhopur'),
(490, 77, 'Sikar'),
(491, 77, 'Sirohi'),
(492, 77, 'Sri Ganganagar'),
(493, 77, 'Tonk'),
(494, 77, 'Udaipur'),
(495, 78, 'East Sikkim'),
(496, 78, 'North Sikkim'),
(497, 78, 'South Sikkim'),
(498, 78, 'West Sikkim'),
(499, 80, 'Dhalai'),
(500, 80, 'Gomati'),
(501, 80, 'Khowai'),
(502, 80, 'North Tripura'),
(503, 80, 'Sepahijala'),
(504, 80, 'South Tripura'),
(505, 80, 'Unakoti'),
(506, 80, 'West Tripura'),
(507, 81, 'Agra'),
(508, 81, 'Aligarh'),
(509, 81, 'Allahabad'),
(510, 81, 'Ambedkar'),
(511, 81, 'Amethi'),
(512, 81, 'Amroha'),
(513, 81, 'Auraiya'),
(514, 81, 'Azamgarh'),
(515, 81, 'Baghpat'),
(516, 81, 'Bahraich'),
(517, 81, 'Ballia'),
(518, 81, 'Balrampur'),
(519, 81, 'Banda'),
(520, 81, 'Barabanki'),
(521, 81, 'Bareilly'),
(522, 81, 'Basti'),
(523, 81, 'Bijnor'),
(524, 81, 'Budaun'),
(525, 81, 'Bulandshahr'),
(526, 81, 'Chandauli'),
(527, 81, 'Chitrakoot'),
(528, 81, 'Deoria'),
(529, 81, 'Etah'),
(530, 81, 'Etawah'),
(531, 81, 'Faizabad'),
(532, 81, 'Farrukhabad'),
(533, 81, 'Fatehpur'),
(534, 81, 'Firozabad'),
(535, 81, 'Gautam Buddha'),
(536, 81, 'Ghaziabad'),
(537, 81, 'Ghazipur'),
(538, 81, 'Gonda'),
(539, 81, 'Gorakhpur'),
(540, 81, 'Hamirpur'),
(541, 81, 'Hardoi'),
(542, 81, 'Hathras'),
(543, 81, 'Jalaun'),
(544, 81, 'Jaunpur'),
(545, 81, 'Jhansi'),
(546, 81, 'Jyotiba'),
(547, 81, 'Kannauj'),
(548, 81, 'Kanpur Dehat'),
(549, 81, 'Kanpur Nagar'),
(550, 81, 'Kanshiram Nagar'),
(551, 81, 'Kaushambi'),
(552, 81, 'Kheri'),
(553, 81, 'Kushinagar'),
(554, 81, 'Lalitpur'),
(555, 81, 'Lucknow'),
(556, 81, 'Maharajganj'),
(557, 81, 'Mahoba'),
(558, 81, 'Mainpuri'),
(559, 81, 'Mathura'),
(560, 81, 'Mau Maunath'),
(561, 81, 'Meerut'),
(562, 81, 'Mirzapur'),
(563, 81, 'Moradabad'),
(564, 81, 'Muzaffarnagar'),
(565, 81, 'Panchsheel Nagar'),
(566, 81, 'Pilibhit'),
(567, 81, 'Pratapgarh'),
(568, 81, 'Raebareli'),
(569, 81, 'Rampur'),
(570, 81, 'Saharanpur'),
(571, 81, 'Sant Kabir Nagar'),
(572, 81, 'Sant Ravidas Nagar'),
(573, 81, 'Shahjahanpur'),
(574, 81, 'Shamli'),
(575, 81, 'Shravasti'),
(576, 81, 'Siddharthnagar'),
(577, 81, 'Sitapur'),
(578, 81, 'Sonbhadra'),
(579, 81, 'Sultanpur'),
(580, 81, 'Unnao'),
(581, 81, 'Varanasi'),
(582, 84, 'Almora'),
(583, 84, 'Bageshwar'),
(584, 84, 'Chamoli'),
(585, 84, 'Champawat'),
(586, 84, 'Dehradun'),
(587, 84, 'Haridwar'),
(588, 84, 'Nainital'),
(589, 84, 'Pauri Garhwal'),
(590, 84, 'Pithoragarh'),
(591, 84, 'Rudraprayag'),
(592, 84, 'Tehri Garhwal'),
(593, 84, 'Udham Singh Nagar'),
(594, 84, 'Uttarkashi'),
(595, 85, 'Bokaro'),
(596, 85, 'Chatra'),
(597, 85, 'Deoghar'),
(598, 85, 'Dhanbad'),
(599, 85, 'Dumka'),
(600, 85, 'East Singhbhum'),
(601, 85, 'Garhwa'),
(602, 85, 'Giridih'),
(603, 85, 'Godda'),
(604, 85, 'Gumla'),
(605, 85, 'Hazaribag'),
(606, 85, 'Jamtara'),
(607, 85, 'Khunti'),
(608, 85, 'Koderma'),
(609, 85, 'Latehar'),
(610, 85, 'Lohardaga'),
(611, 85, 'Pakur'),
(612, 85, 'Palamu'),
(613, 85, 'Ramgarh'),
(614, 85, 'Ranchi'),
(615, 85, 'Sahibganj'),
(616, 85, 'Seraikela-Kharsawan'),
(617, 85, 'Simdega'),
(618, 85, 'West Singhbhum'),
(619, 86, 'Adilabad'),
(620, 86, 'Bhadradri Kothagudem'),
(621, 86, 'Hyderabad'),
(622, 86, 'Jagtial'),
(623, 86, 'Jangaon'),
(624, 86, 'Jayashankar Bhoopalpally'),
(625, 86, 'Jogulamba Gadwal'),
(626, 86, 'Kamareddy'),
(627, 86, 'Karimnagar'),
(628, 86, 'Khammam'),
(629, 86, 'Komaram Bheem Asifabad'),
(630, 86, 'Mahabubabad'),
(631, 86, 'Mahabubnagar'),
(632, 86, 'Mancherial'),
(633, 86, 'Medak'),
(634, 86, 'Medchal'),
(635, 86, 'Nagarkurnool'),
(636, 86, 'Nalgonda'),
(637, 86, 'Nirmal'),
(638, 86, 'Nizamabad'),
(639, 86, 'Peddapalli'),
(640, 86, 'Rajanna Sircilla'),
(641, 86, 'Rangareddy'),
(642, 86, 'Sangareddy'),
(643, 86, 'Siddipet'),
(644, 86, 'Suryapet'),
(645, 86, 'Vikarabad'),
(646, 86, 'Wanaparthy'),
(647, 86, 'Warangal (Rural)'),
(648, 86, 'Warangal (Urban)'),
(649, 86, 'Yadadri Bhuvanagiri'),
(650, 82, 'Alipurduar'),
(651, 82, 'Bankura'),
(652, 82, 'Birbhum'),
(653, 82, 'Burdwan'),
(654, 82, 'Cooch Behar'),
(655, 82, 'Dakshin Dinajpur (South Dinajpur)'),
(656, 82, 'Darjeeling'),
(657, 82, 'Hooghly'),
(658, 82, 'Howrah'),
(659, 82, 'Jalpaiguri'),
(660, 82, 'Kalimpong'),
(661, 82, 'Kolkata'),
(662, 82, 'Malda'),
(663, 82, 'Murshidabad'),
(664, 82, 'Nadia'),
(665, 82, 'North 24 Parganas'),
(666, 82, 'Paschim Medinipur (West Medinipur)'),
(667, 82, 'Purba Medinipur (East Medinipur)'),
(668, 82, 'Purulia'),
(669, 82, 'South 24 Parganas'),
(670, 82, 'Uttar Dinajpur (North Dinajpur)'),
(671, 83, 'Balod'),
(672, 83, 'Baloda Bazar'),
(673, 83, 'Balrampur'),
(674, 83, 'Bastar'),
(675, 83, 'Bemetara'),
(676, 83, 'Bijapur'),
(677, 83, 'Bilaspur'),
(678, 83, 'Dantewada (South Bastar)'),
(679, 83, 'Dhamtari'),
(680, 83, 'Durg'),
(681, 83, 'Gariyaband'),
(682, 83, 'Janjgir-Champa'),
(683, 83, 'Jashpur'),
(684, 83, 'Kabirdham (Kawardha)'),
(685, 83, 'Kanker (North Bastar)'),
(686, 83, 'Kondagaon'),
(687, 83, 'Korba'),
(688, 83, 'Korea (Koriya)'),
(689, 83, 'Mahasamund'),
(690, 83, 'Mungeli'),
(691, 83, 'Narayanpur'),
(692, 83, 'Raigarh'),
(693, 83, 'Raipur'),
(694, 83, 'Rajnandgaon'),
(695, 83, 'Sukma'),
(696, 83, 'Surajpur'),
(697, 83, 'Surguja'),
(698, 87, 'Central Delhi'),
(699, 87, 'East Delhi'),
(700, 87, 'New Delhi'),
(701, 87, 'North Delhi'),
(702, 87, 'North East Delhi'),
(703, 87, 'North West Delhi'),
(704, 87, 'Shahdara'),
(705, 87, 'South Delhi'),
(706, 87, 'South East Delhi'),
(707, 87, 'South West Delhi'),
(708, 87, 'West Delhi'),
(709, 88, 'Nicobar'),
(710, 88, 'North and Middle Andaman'),
(711, 88, 'South Andaman'),
(712, 89, 'Chandigarh'),
(713, 90, 'Dadra & Nagar Haveli'),
(714, 91, 'Daman'),
(715, 91, 'Diu'),
(716, 92, 'Lakshadweep'),
(717, 93, 'Karaikal'),
(718, 93, 'Mahe'),
(719, 93, 'Pondicherry'),
(720, 93, 'Yanam');
-- --------------------------------------------------------
--
-- Table structure for table `education`
--
CREATE TABLE `education` (
`education_id` int NOT NULL,
`education` varchar(250) NOT NULL,
`level_id` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `education`
--
INSERT INTO `education` (`education_id`, `education`, `level_id`) VALUES
(1, 'Bachelor of Architecture', '1'),
(2, 'Bachelor of Biomedical Science', '1'),
(3, 'Bachelor of Business Administration', '1'),
(4, 'Bachelor of Clinical Science', '1'),
(5, 'Bachelor of Commerce', '1'),
(6, 'Bachelor of Computer Applications', '1'),
(7, 'Bachelor of Computer Information Systems', '1'),
(8, 'Bachelor of Science in Construction Technology', '1'),
(9, 'Bachelor of Criminal Justice', '1'),
(10, 'Bachelor of Divinity', '1'),
(11, 'Bachelor of Economics', '1'),
(12, 'Bachelor of Education', '1'),
(13, 'Bachelor of Engineering', '1'),
(14, 'Bachelor of Fine Arts', '1'),
(15, 'Bachelor of Letters', '1'),
(16, 'Bachelor of Information Systems', '1'),
(17, 'Bachelor of Management', '1'),
(18, 'Bachelor of Music', '1'),
(19, 'Bachelor of Pharmacy', '1'),
(20, 'Bachelor of Philosophy', '1'),
(21, 'Bachelor of Social Work', '1'),
(22, 'Bachelor of Technology', '1'),
(23, 'Bachelor of Accountancy', '1'),
(24, 'Bachelor of Arts in American Studies', '1'),
(25, 'Bachelor of Arts in American Indian Studies', '1'),
(26, 'Bachelor of Arts in Applied Psychology', '1'),
(27, 'Bachelor of Arts in Biology', '1'),
(28, 'Bachelor of Arts in Anthropology', '1'),
(29, 'Bachelor of Arts in Child Advocacy', '1'),
(30, 'Bachelor of Arts in Clinical Psychology', '1'),
(31, 'Bachelor of Arts in Forensic Psychology', '1'),
(32, 'Bachelor of Arts in Organizational Psychology', '1'),
(33, 'Bachelor of Science in Aerospace Engineering', '1'),
(34, 'Bachelor of Science in Actuarial', '1'),
(35, 'Bachelor of Science in Agriculture', '1'),
(36, 'Bachelor of Science in Architecture', '1'),
(37, 'Bachelor of Science in Architectural Engineering', '1'),
(38, 'Bachelor of Science in Athletic Training', '1'),
(39, 'Bachelor of Science in Biology', '1'),
(40, 'Bachelor of Science in Biomedical Engineering', '1'),
(41, 'Bachelor of Science in Bible', '1'),
(42, 'Bachelor of Science in Business Administration', '1'),
(43, 'Bachelor of Science in Business and Technology', '1'),
(44, 'Bachelor of Science in Chemical Engineering', '1'),
(45, 'Bachelor of Science in Chemistry', '1'),
(46, 'Bachelor of Science in Civil Engineering', '1'),
(47, 'Bachelor of Science in Clinical Laboratory Science', '1'),
(48, 'Bachelor of Science in Cognitive Science', '1'),
(49, 'Bachelor of Science in Computer Engineering', '1'),
(50, 'Bachelor of Science in Computer Science', '1'),
(51, 'Bachelor of Science in Construction Engineering', '1'),
(52, 'Bachelor of Science in Construction Management', '1'),
(53, 'Bachelor of Science in Criminal Justice', '1'),
(54, 'Bachelor of Science in Criminology', '1'),
(55, 'Bachelor of Science in Diagnostic Radiography', '1'),
(56, 'Bachelor of Science in Education', '1'),
(57, 'Bachelor of Science in Electrical Engineering', '1'),
(58, 'Bachelor of Science in Engineering Physics', '1'),
(59, 'Bachelor of Science in Engineering Science', '1'),
(60, 'Bachelor of Science in Engineering Technology', '1'),
(61, 'Bachelor of Science in English Literature', '1'),
(62, 'Bachelor of Science in Environmental Engineering', '1'),
(63, 'Bachelor of Science in Environmental Science', '1'),
(64, 'Bachelor of Science in Environmental Studies', '1'),
(65, 'Bachelor of Science in Food Science', '1'),
(66, 'Bachelor of Science in Foreign Service', '1'),
(67, 'Bachelor of Science in Forensic Science', '1'),
(68, 'Bachelor of Science in Forestry', '1'),
(69, 'Bachelor of Science in History', '1'),
(70, 'Bachelor of Science in Hospitality Management', '1'),
(71, 'Bachelor of Science in Human Resources Management', '1'),
(72, 'Bachelor of Science in Industrial Engineering', '1'),
(73, 'Bachelor of Science in Information Technology', '1'),
(74, 'Bachelor of Science in Information Systems', '1'),
(75, 'Bachelor of Science in Integrated Science', '1'),
(76, 'Bachelor of Science in International Relations', '1'),
(77, 'Bachelor of Science in Journalism', '1'),
(78, 'Bachelor of Science in Legal Management', '1'),
(79, 'Bachelor of Science in Management', '1'),
(80, 'Bachelor of Science in Manufacturing Engineering', '1'),
(81, 'Bachelor of Science in Marketing', '1'),
(82, 'Bachelor of Science in Mathematics', '1'),
(83, 'Bachelor of Science in Mechanical Engineering', '1'),
(84, 'Bachelor of Science in Medical Technology', '1'),
(85, 'Bachelor of Science in Metallurgical Engineering', '1'),
(86, 'Bachelor of Science in Meteorology', '1'),
(87, 'Bachelor of Science in Microbiology', '1'),
(88, 'Bachelor of Science in Mining Engineering', '1'),
(89, 'Bachelor of Science in Molecular Biology', '1'),
(90, 'Bachelor of Science in Neuroscience', '1'),
(91, 'Bachelor of Science in Nursing', '1'),
(92, 'Bachelor of Science in Nutrition science', '1'),
(93, 'Bachelor of Science in Software Engineering', '1'),
(94, 'Bachelor of Science in Petroleum Engineering', '1'),
(95, 'Bachelor of Science in Podiatry', '1'),
(96, 'Bachelor of Science in Pharmacology', '1'),
(97, 'Bachelor of Science in Pharmacy', '1'),
(98, 'Bachelor of Science in Physical Therapy', '1'),
(99, 'Bachelor of Science in Physics', '1'),
(100, 'Bachelor of Science in Plant Science', '1'),
(101, 'Bachelor of Science in Politics', '1'),
(102, 'Bachelor of Science in Psychology', '1'),
(103, 'Bachelor of Science in Public Safety', '1'),
(104, 'Bachelor of Science in Quantity Surveying Engineering', '1'),
(105, 'Bachelor of Science in Radiologic Technology', '1'),
(106, 'Bachelor of Science in Real-Time Interactive Simulation', '1'),
(107, 'Bachelor of Science in Religion', '1'),
(108, 'Bachelor of Science in Respiratory Therapy', '1'),
(109, 'Bachelor of Science in Risk Management and Insurance', '1'),
(110, 'Bachelor of Science in Science Education', '1'),
(111, 'Bachelor of Science in Sports Management', '1'),
(112, 'Bachelor of Science in Systems Engineering', '1'),
(113, 'Bachelor of Music in Jazz Studies', '1'),
(114, 'Bachelor of Music in Composition', '1'),
(115, 'Bachelor of Music in Performance', '1'),
(116, 'Bachelor of Music in Theory', '1'),
(117, 'Bachelor of Music in Music Education', '1'),
(118, 'Bachelor of Science in Veterinary Technology', '1'),
(119, 'Master of Accountancy', '2'),
(120, 'Master of Accounting and Information Systems', '2'),
(121, 'Master of Advanced Study', '2'),
(122, 'Master of Applied Finance', '2'),
(123, 'Master of Applied Mathematical Sciences', '2'),
(124, 'Master of Applied Psychology', '2'),
(125, 'Master of Applied Science', '2'),
(126, 'Master of Architecture', '2'),
(127, 'Master of Arts', '2'),
(128, 'Master of Arts in Archives and Records Management', '2'),
(129, 'Master of Arts in Liberal Studies', '2'),
(130, 'Master of Arts in Museum Studies', '2'),
(131, 'Master of Arts in Strategic Communication Management', '2'),
(132, 'Master of Arts in Teaching', '2'),
(133, 'Master of Athletic Training', '2'),
(134, 'Master of Bioinformatics', '2'),
(135, 'Master of Biotechnology', '2'),
(136, 'Master of Business Administration', '2'),
(137, 'Master of Business Administration Management of Technology', '2'),
(138, 'Master of Business', '2'),
(139, 'Master of Business Economics', '2'),
(140, 'Master of Business Engineering', '2'),
(141, 'Master of Business Informatics', '2'),
(142, 'Master of Chemistry', '2'),
(143, 'Master of City Planning', '2'),
(144, 'Master of Commerce', '2'),
(145, 'Master of Computational Finance', '2'),
(146, 'Master of Computer Applications', '2'),
(147, 'Master of Computer Science', '2'),
(148, 'Master of Communication', '2'),
(149, 'Master of Counseling', '2'),
(150, 'Master of Criminal Justice', '2'),
(151, 'Master in Creative Technologies', '2'),
(152, 'Master of Design', '2'),
(153, 'Master of Divinity', '2'),
(154, 'Master of Economics', '2'),
(155, 'Master of Education', '2'),
(156, 'Master of Educational Technology', '2'),
(157, 'Master of Engineering', '2'),
(158, 'Master of Engineering Management', '2'),
(159, 'Master of Enterprise', '2'),
(160, 'Master of European Law', '2'),
(161, 'Master of Finance', '2'),
(162, 'Master of Financial Economics', '2'),
(163, 'Master of Financial Engineering', '2'),
(164, 'Master of Financial Mathematics', '2'),
(165, 'Master of Fine Arts', '2'),
(166, 'Master of Health Administration', '2'),
(167, 'Master of Health Science', '2'),
(168, 'Master of Humanities', '2'),
(169, 'Master of Industrial and Labor Relations', '2'),
(170, 'Master of International Affairs', '2'),
(171, 'Master of International Business', '2'),
(172, 'Master of International Economics', '2'),
(173, 'Master of International Public Policy', '2'),
(174, 'Master of International Studies', '2'),
(175, 'Master of Information', '2'),
(176, 'Master of Information Management', '2'),
(177, 'Master of Information Systems', '2'),
(178, 'Master of Information System Management', '2'),
(179, 'Master of Islamic Studies', '2'),
(180, 'Master of IT', '2'),
(181, 'Master of Jurisprudence', '2'),
(182, 'Master of Laws', '2'),
(183, 'Master of Studies in Law', '2'),
(184, 'Master of Landscape Architecture', '2'),
(185, 'Master of Letters', '2'),
(186, 'Master of Liberal Arts', '2'),
(187, 'Master of Library and Information Science', '2'),
(188, 'Master of Management', '2'),
(189, 'Master of Mass Communication and Journalism', '2'),
(190, 'Master of Mathematical Finance', '2'),
(191, 'Master of Mathematics', '2'),
(192, 'Master of Mathematics and Computer Science', '2'),
(193, 'Master of Mathematics and Philosophy', '2'),
(194, 'Master of Medical Science', '2'),
(195, 'Master of Medicine', '2'),
(196, 'Master of Military Art and Science', '2'),
(197, 'Master of Music', '2'),
(198, 'Master of Network and Communications Management', '2'),
(199, 'Master of Occupational Therapy', '2'),
(200, 'Master of Pharmacy', '2'),
(201, 'Master of Philosophy', '2'),
(202, 'Master of Physician Assistant Studies', '2'),
(203, 'Master of Physics', '2'),
(204, 'Master of Political Science', '2'),
(205, 'Master of Professional Studies', '2'),
(206, 'Master of Psychology', '2'),
(207, 'Master of Public Administration', '2'),
(208, 'Master of Public Affairs', '2'),
(209, 'Master of Public Diplomacy', '2'),
(210, 'Master of Public Health', '2'),
(211, 'Master of Public Management', '2'),
(212, 'Master of Public Policy', '2'),
(213, 'Master of Public Relations', '2'),
(214, 'Master of Public Service', '2'),
(215, 'Master of Quantitative Finance', '2'),
(216, 'Master of Rabbinic Studies', '2'),
(217, 'Master of Real Estate Development', '2'),
(218, 'Master of Religious Education', '2'),
(219, 'Master of Research', '2'),
(220, 'Master of Sacred Music', '2'),
(221, 'Master of Sacred Theology', '2'),
(222, 'Master of Science', '2'),
(223, 'Master of Science in Applied Cognition and Neuroscience', '2'),
(224, 'Master of Science in Athletic Training', '2'),
(225, 'Master of Science in Bioinformatics', '2'),
(226, 'Master of Science in Clinical Epidemiology', '2'),
(227, 'Master of Science in Computing Research', '2'),
(228, 'Master of Science in Cyber Security', '2'),
(229, 'Master of Science in Education', '2'),
(230, 'Master of Science in Engineering', '2'),
(231, 'Master of Science in Development Administration', '2'),
(232, 'Master of Science in Finance', '2'),
(233, 'Master of Science in Governance & Organizational Sciences', '2'),
(234, 'Master of Science in Government Contracts', '2'),
(235, 'Master of Science in Health Informatics', '2'),
(236, 'Master of Science in Human Resource Development', '2'),
(237, 'Master of Science in Information Assurance', '2'),
(238, 'Master of Science in Information Systems', '2'),
(239, 'Master of Science in Information Technology', '2'),
(240, 'Master of Science in Leadership', '2'),
(241, 'Master of Science in Management', '2'),
(242, 'Master of Science in Nursing', '2'),
(243, 'Master of Science in Project Management', '2'),
(244, 'Master of Science in Quality Assurance', '2'),
(245, 'Master of Science in Risk Management', '2'),
(246, 'Master of Science in Supply Chain Management', '2'),
(247, 'Master of Science in Teaching', '2'),
(248, 'Master of Science in Taxation', '2'),
(249, 'Master of Social Science', '2'),
(250, 'Master of Social Work', '2'),
(251, 'Master of Statistics', '2'),
(252, 'Master of Strategic Studies', '2'),
(253, 'Master of Studies', '2'),
(254, 'Master of Surgery', '2'),
(255, 'Master of Theological Studies', '2'),
(256, 'Master of Technology', '2'),
(257, 'Master of Theology', '2'),
(258, 'Master of Urban Planning', '2'),
(259, 'Master of Veterinary Science', '2'),
(260, 'Doctor of Business Administration', '3'),
(261, 'Doctor of Canon Law', '3'),
(262, 'Doctor of Chiropractic', '3'),
(263, 'Doctor of Commerce', '3'),
(264, 'Doctor of Dental Surgery', '3'),
(265, 'Doctor of Divinity', '3'),
(266, 'Doctor of Education', '3'),
(267, 'Doctor of Engineering', '3'),
(268, 'Doctor of Health Administration', '3'),
(269, 'Doctor of Health Science', '3'),
(270, 'Doctor of Juridical Science; Juris Doctor', '3'),
(271, 'Doctor of Law; Legum Doctor', '3'),
(272, 'Doctor of Liberal Studies', '3'),
(273, 'Doctor of Management', '3'),
(274, 'Doctor of Medicine', '3'),
(275, 'Doctor of Ministry', '3'),
(276, 'Doctor of Modern Languages', '3'),
(277, 'Doctor of Musical Arts', '3'),
(278, 'Doctor of Naturopathic Medicine', '3'),
(279, 'Doctor of Optometry', '3'),
(280, 'Doctor of Osteopathic Medicine', '3'),
(281, 'Doctor of Pharmacy', '3'),
(282, 'Doctor of Philosophy', '3'),
(283, 'Doctor of Public Administration', '3'),
(284, 'Doctor of Science', '3'),
(285, 'Doctor of Theology', '3'),
(286, 'Doctor of Veterinary Medicine', '3'),
(287, 'Doctor of Radio oncology', '3'),
(288, 'Associate Degree in Administration of Justice', '5'),
(289, 'Associate Degree in Advertising', '5'),
(290, 'Associate Degree in Agribusiness', '5'),
(291, 'Associate Degree in Animal Management', '5'),
(292, 'Associate Degree in Architectural Building Engineering Technology', '5'),
(293, 'Associate Degree in Architecture and Career Options', '5'),
(294, 'Associate Degree in Art', '5'),
(295, 'Associate Degree in Automotive Maintenance Technology', '5'),
(296, 'Associate Degree in Aviation Mechanics', '5'),
(297, 'Associate Degree in Behavioral Science', '5'),
(298, 'Associate Degree in Boat Mechanics', '5'),
(299, 'Associate Degree in Boat Repair and Maintenance', '5'),
(300, 'Associate Degree in Cabinet Design Technology', '5'),
(301, 'Associate Degree in Child Development: Program Summary', '5'),
(302, 'Associate Degree in Christian Ministry', '5'),
(303, 'Associate Degree in Cosmetology Business', '5'),
(304, 'Associate Degree in Digital Media', '5'),
(305, 'Associate Degree in Early Childhood Special Education', '5'),
(306, 'Associate Degree in Elementary Education', '5'),
(307, 'Associate Degree in English', '5'),
(308, 'Associate Degree in Environmental Science', '5'),
(309, 'Associate Degree in Environmental Studies', '5'),
(310, 'Associate Degree in General Psychology', '5'),
(311, 'Associate Degree in History and Information', '5'),
(312, 'Associate Degree in Interdisciplinary Studies', '5'),
(313, 'Associate Degree in International Relations', '5'),
(314, 'Associate Degree in Landscape Architecture', '5'),
(315, 'Associate Degree in Landscaping Design', '5'),
(316, 'Associate Degree in Library Science', '5'),
(317, 'Associate Degree in Music', '5'),
(318, 'Associate Degree in Wildlife Management', '5'),
(319, 'Associate Degree in Education', '5'),
(320, 'Associate of Applied Science (AAS) in Accelerated Culinary Arts', '5'),
(321, 'Associate of Applied Science (AAS) in Accounting Specialist', '5'),
(322, 'Associate of Applied Science (AAS) in Administrative Support', '5'),
(323, 'Associate of Applied Science (AAS) in Baking and Pastry', '5'),
(324, 'Associate of Applied Science (AAS) in Business Administration', '5'),
(325, 'Associate of Applied Science (AAS) in Business Administration - Finance', '5'),
(326, 'Associate of Applied Science (AAS) in Business Information Systems', '5'),
(327, 'Associate of Applied Science (AAS) in Civil Justice - Law Enforcement', '5'),
(328, 'Associate of Applied Science (AAS) in Clinical Medical Assisting', '5'),
(329, 'Associate of Applied Science (AAS) in Computer Applications', '5'),
(330, 'Associate of Applied Science (AAS) in Computer Electronics', '5'),
(331, 'Associate of Applied Science (AAS) in Computer Game Design', '5'),
(332, 'Associate of Applied Science (AAS) in Computer Information Systems', '5'),
(333, 'Associate of Applied Science (AAS) in Culinary Arts', '5'),
(334, 'Associate of Applied Science (AAS) in Digital Media Communications', '5'),
(335, 'Associate of Applied Science (AAS) in Digital Photography', '5'),
(336, 'Associate of Applied Science (AAS) in Electronic Engineering', '5'),
(337, 'Associate of Applied Science (AAS) in Emergency Medical Services', '5'),
(338, 'Associate of Applied Science (AAS) in Health Care Management', '5'),
(339, 'Associate of Applied Science (AAS) in Health Information Management', '5'),
(340, 'Associate of Applied Science (AAS) in Healthcare Administration', '5'),
(341, 'Associate of Applied Science (AAS) in Legal Office E-ministration', '5'),
(342, 'Associate of Applied Science (AAS) in Telecommunications Technology', '5'),
(343, 'Associate of Applied Science (AAS) in Television Production', '5'),
(344, 'Associate of Applied Science (AAS) in Visual Communications', '5'),
(345, 'Associate of Arts (AA) in Computer Information Systems', '5'),
(346, 'Associate of Arts (AA) in Internetworking Technology', '5'),
(347, 'Associate of Arts (AA) in Psychology', '5'),
(348, 'Associate of Arts (AA) in Interior Architecture and Design', '5'),
(349, 'Associate of Biotechnology', '5'),
(350, 'Associate of Business Science (ABS) in Individualized Studies', '5'),
(351, 'Associate of Early Childhood Education (AECE)', '5'),
(352, 'Associate of Occupational Studies (AOS) in Legal Office Administration', '5'),
(353, 'Associate of Science (AS) in Computer Information Science', '5'),
(354, 'Associate of Science (AS) in Computer Science', '5'),
(355, 'Associate of Science (AS) in Corrections, Probation, & Parole', '5'),
(356, 'Associate of Science (AS) in Electronics Engineering Technology', '5'),
(357, 'Associate of Science (AS) in Interactive & Graphic Art', '5'),
(358, 'Diplamo in Mechanical Engineering', '10');
-- --------------------------------------------------------
--
-- Table structure for table `education_level`
--
CREATE TABLE `education_level` (
`id` int NOT NULL,
`education_level` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `education_level`
--
INSERT INTO `education_level` (`id`, `education_level`) VALUES
(1, 'Bachelors '),
(2, 'Masters '),
(3, 'Doctorate '),
(4, 'Undergraduate '),
(5, 'Associates degree'),
(6, 'Honours degree'),
(7, 'Trade School'),
(8, 'High School'),
(9, 'Less than high school'),
(10, 'Diploma');
-- --------------------------------------------------------
--
-- Table structure for table `family_type`
--
CREATE TABLE `family_type` (
`id` int NOT NULL,
`family_type` varchar(50) DEFAULT NULL,
`family_type_tamil` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `family_type`
--
INSERT INTO `family_type` (`id`, `family_type`, `family_type_tamil`) VALUES
(1, 'Nuclear family', 'தனிக்குடும்பம்'),
(2, 'Joint family', 'கூட்டு குடும்பம்'),
(3, 'Extended family ', 'விரிவாக்கப்பட்ட குடும்பம்');
-- --------------------------------------------------------
--
-- Table structure for table `family_value`
--
CREATE TABLE `family_value` (
`id` int NOT NULL,
`family_value` varchar(50) DEFAULT NULL,
`family_value_tamil` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `family_value`
--
INSERT INTO `family_value` (`id`, `family_value`, `family_value_tamil`) VALUES
(1, 'Traditional', 'பாரம்பரிய குடும்பம்'),
(2, 'Moderate', 'இயல்பான குடும்பம்'),
(3, 'Liberal', 'தாராளவாத குடும்பம்');
-- --------------------------------------------------------
--
-- Table structure for table `feedback`
--
CREATE TABLE `feedback` (
`id` int NOT NULL,
`name` varchar(200) DEFAULT NULL,
`phone_no` varchar(15) DEFAULT NULL,
`priority` varchar(200) DEFAULT NULL,
`email` varchar(200) DEFAULT NULL,
`category` varchar(200) DEFAULT NULL,
`suggestion` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `feedback`
--
INSERT INTO `feedback` (`id`, `name`, `phone_no`, `priority`, `email`, `category`, `suggestion`) VALUES
(3, 'testttest', '2147483647', 'High', 'test@test.com', 'Compliments and Suggestions', 'goodddd'),
(4, 'test', '9789595562', 'Low', 'indra@gmail.com', 'Problems related to the Website', 'good');
-- --------------------------------------------------------
--
-- Table structure for table `gallery`
--
CREATE TABLE `gallery` (
`id` int NOT NULL,
`user_id` varchar(20) NOT NULL,
`image` text NOT NULL,
`uploaded_on` datetime DEFAULT NULL,
`status` tinyint NOT NULL DEFAULT '0' COMMENT '1-approved , 2-rejected',
`reason` varchar(2000) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `gallery`
--
INSERT INTO `gallery` (`id`, `user_id`, `image`, `uploaded_on`, `status`, `reason`) VALUES
(1, 'BELL001', 'bell_glBELL0011516954982.jpg', '2018-01-26 13:53:02', 0, NULL),
(2, 'BELL10005', 'bell_glBELL100051516955232.jpg', '2018-01-26 13:57:12', 0, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `gotra`
--
CREATE TABLE `gotra` (
`id` int NOT NULL,
`gotra` varchar(300) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `gotra`
--
INSERT INTO `gotra` (`id`, `gotra`) VALUES
(1, 'Aatharvas'),
(2, 'Agasthi'),
(3, 'Ahabhunasa'),
(4, 'Airan'),
(5, 'Alampayana'),
(6, 'Angiras'),
(7, 'Arrishinimi'),
(8, 'Athreyasya / Athreyasa'),
(9, 'Atri'),
(10, 'Attarishi'),
(11, 'Aukshanas'),
(12, 'Aushanas'),
(13, 'Babrahvya'),
(14, 'Badarayana'),
(15, 'Baijvayas'),
(16, 'Bansal'),
(17, 'Bashan'),
(18, 'Bhandal'),
(19, 'Bharadwaj'),
(20, 'Bhargava/Bhargav'),
(21, 'Bhasyan'),
(22, 'Bhrigu'),
(23, 'Bindal'),
(24, 'Birthare'),
(25, 'Bodhaaynas'),
(26, 'Chandratri'),
(27, 'Chikithasa'),
(28, 'Chyavanasa'),
(29, 'Daksa'),
(30, 'Dalabhya'),
(31, 'Darbhas'),
(32, 'Devrata'),
(33, 'Dhananjaya'),
(34, 'Dhanvantri'),
(35, 'Dhara Gautam'),
(36, 'Dharan'),
(37, 'Dharanas'),
(38, 'Dixit'),
(39, 'Duttatreyas'),
(40, 'Galiva'),
(41, 'Ganganas'),
(42, 'Gangyanas'),
(43, 'Gardhmukh Sandilya'),
(44, 'Garg'),
(45, 'Garga / Gargya'),
(46, 'Gargya Sainasa'),
(47, 'Gautam / Gouthama'),
(48, 'Ghrit Kaushika'),
(49, 'Gowri Veetham'),
(50, 'Goyal'),
(51, 'Goyan'),
(52, 'Haritasya / Harithasa / Haritha'),
(53, 'Jaiminiyas'),
(54, 'Jamadagni'),
(55, 'Jatukarna'),
(56, 'Jindal'),
(57, 'Kaakavas'),
(58, 'Kabi'),
(59, 'Kalabouddasa'),
(60, 'Kalpangeerasa'),
(61, 'Kamakayana Vishwamitra'),
(62, 'Kamsa'),
(63, 'Kanav'),
(64, 'Kansal'),
(65, 'Kanva'),
(66, 'Kapi'),
(67, 'Kapila Baradwaj'),
(68, 'Kapinjal'),
(69, 'Kapishthalas'),
(70, 'Kaplish'),
(71, 'Kashish'),
(72, 'Kashyapa / Kaashyapa'),
(73, 'Katyayan / Katyan'),
(74, 'Kaundinya / Koundanya / Kaundilya'),
(75, 'Kaunsa'),
(76, 'Kaushal'),
(77, 'Kaushika / Kaushik / Kausikasa'),
(78, 'Keshoryas'),
(79, 'Koushika Visvamitrasa'),
(80, 'Krishnatrey'),
(81, 'Kucchal'),
(82, 'Kusa'),
(83, 'Kutsa / Kutsas / Kutsasa'),
(84, 'Laakshmanas'),
(85, 'Laugakshi'),
(86, 'Lavania'),
(87, 'Lodwan'),
(88, 'Lohit'),
(89, 'Lokaakhyas'),
(90, 'Lomasha'),
(91, 'Madelia'),
(92, 'Madhukul'),
(93, 'Maitraya'),
(94, 'Manava'),
(95, 'Mandavya'),
(96, 'Mangal'),
(97, 'Marica'),
(98, 'Markendeya'),
(99, 'Maudlas'),
(100, 'Maunas'),
(101, 'Mihir'),
(102, 'Mittal'),
(103, 'Moudgalya'),
(104, 'Mouna Bhargava'),
(105, 'Munish'),
(106, 'Mythravaruna'),
(107, 'Naagal'),
(108, 'Nagasya'),
(109, 'Naidrupa Kashyapa'),
(110, 'Narayanas'),
(111, 'Nithyandala'),
(112, 'Paaniyas'),
(113, 'Pachori'),
(114, 'Paing'),
(115, 'Parashar / Parashara'),
(116, 'Parthivasa'),
(117, 'Paulastya'),
(118, 'Poothamanasa'),
(119, 'Pourugutsa'),
(120, 'Prachinas'),
(121, 'Raghuvanshi'),
(122, 'Rajoria'),
(123, 'Rathitar'),
(124, 'Rohinya'),
(125, 'Rohita'),
(126, 'Sakalya'),
(127, 'Sakhyanasa'),
(128, 'Salankayanasa'),
(129, 'Sankash'),
(130, 'Sankha-Pingala-Kausta'),
(131, 'Sankrut'),
(132, 'Sankyanasa'),
(133, 'Savanaka'),
(134, 'Savarana / Sabarna / Savarna / Sraborno'),
(135, 'Shaalaksha'),
(136, 'Shadamarshana / Shatamarshanam'),
(137, 'Shakhanas'),
(138, 'Shalavatsa'),
(139, 'Shandilya / Sandilyasa'),
(140, 'Sharkaras'),
(141, 'Sharkvas'),
(142, 'Shaunak'),
(143, 'Shravanesya'),
(144, 'Shrimukh Shandilya'),
(145, 'Shukla Atreyas'),
(146, 'Sigidha'),
(147, 'Singhal'),
(148, 'Sri Vatsa / Vatsa / Vats / Vacchas'),
(149, 'Srungi Bharadwajasa'),
(150, 'Suparnasa'),
(151, 'Swathantra Kapisa'),
(152, 'Tayal'),
(153, 'Tharakayanam'),
(154, 'Thingal'),
(155, 'Titwal'),
(156, 'Tushar'),
(157, 'Udbahu'),
(158, 'Udhalaka'),
(159, 'Uditha Gautham'),
(160, 'Udithya'),
(161, 'Upamanyu Vasishtasa'),
(162, 'Upamanyu'),
(163, 'Upathya'),
(164, 'Vadoola / Vadulasa'),
(165, 'Vainya'),
(166, 'Vardheyasa'),
(167, 'Vashishtha'),
(168, 'Veethahavya'),
(169, 'Vishnordhageerasa'),
(170, 'Vishnu Vridhha'),
(171, 'Vishwamitra'),
(172, 'Yaska'),
(173, 'Others'),
(174, 'Don\'t know');
-- --------------------------------------------------------
--
-- Table structure for table `guest_user`
--
CREATE TABLE `guest_user` (
`id` int NOT NULL,
`user_id` varchar(25) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
`name` varchar(160) NOT NULL,
`mobile` varchar(13) NOT NULL,
`email` varchar(50) DEFAULT NULL,
`address` varchar(300) DEFAULT NULL,
`created_on` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
--
-- Dumping data for table `guest_user`
--
INSERT INTO `guest_user` (`id`, `user_id`, `name`, `mobile`, `email`, `address`, `created_on`) VALUES
(4, '001', '', '', NULL, '', '2017-12-19 12:56:13'),
(5, '005', '', '', NULL, '', '2017-12-19 12:58:42'),
(6, '006', '', '', NULL, '', '2017-12-19 13:03:24'),
(7, '007', '', '', NULL, '', '2017-12-19 13:05:51'),
(8, '008', '', '', NULL, '', '2017-12-19 13:14:41'),
(9, '009', '', '', NULL, '', '2017-12-19 13:21:33'),
(10, '010', '', '', NULL, '', '2017-12-19 13:27:47'),
(11, '011', 'Kannan', '9626194241', NULL, 'Madurai', '2017-12-19 13:36:22');
-- --------------------------------------------------------
--
-- Table structure for table `head_office`
--
CREATE TABLE `head_office` (
`id` int NOT NULL,
`branch` varchar(50) NOT NULL,
`door_no` varchar(20) NOT NULL,
`street` varchar(50) NOT NULL,
`place` varchar(50) NOT NULL,
`city` varchar(60) NOT NULL,
`state` varchar(10) NOT NULL,
`district` varchar(10) NOT NULL,
`pincode` varchar(10) NOT NULL,
`email` varchar(150) NOT NULL,
`mobile` varchar(12) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
--
-- Dumping data for table `head_office`
--
INSERT INTO `head_office` (`id`, `branch`, `door_no`, `street`, `place`, `city`, `state`, `district`, `pincode`, `email`, `mobile`) VALUES
(1, 'PIRAKARAI', '45/3', 'PIRAKARAI', 'UNDARPATTY POST', 'THADIKOMBU VIA', 'Taminadu', 'DINDIGUL', '624709', 'bellsmatrimonyinfo@gmail.com', '9367926693');
-- --------------------------------------------------------
--
-- Table structure for table `height`
--
CREATE TABLE `height` (
`id` int NOT NULL,
`height` varchar(50) DEFAULT NULL,
`height_cm` int NOT NULL COMMENT 'height in centimeters'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `height`
--
INSERT INTO `height` (`id`, `height`, `height_cm`) VALUES
(1, '4\' 5\'\' - 134cm', 134),
(2, '4\' 6\'\' - 137cm', 137),
(3, '4\' 7\'\' - 139cm', 139),
(4, '4\' 8\'\' - 142cm', 142),
(5, '4\' 9\'\' - 144cm', 144),
(6, '4\' 10\'\' - 147cm', 147),
(7, '4\' 11\'\' - 149cm', 149),
(8, '5\' 60\'\' - 152cm', 152),
(9, '5\' 61\'\' - 154cm', 154),
(10, '5\' 62\'\' - 157cm', 157),
(11, '5\' 63\'\' - 160cm', 160),
(12, '5\' 64\'\' - 162cm', 162),
(13, '5\' 65\'\' - 165cm', 165),
(14, '5\' 67\'\' - 167cm', 167),
(15, '5\' 68\'\' - 172cm', 172),
(16, '5\' 69\'\' - 175cm', 175),
(17, '5\' 70\'\' - 177cm', 177),
(18, '5\' 71\'\' - 180cm', 180),
(19, '6\' 72\'\' - 182cm', 182),
(20, '6\' 73\'\' - 185cm', 185),
(21, '6\' 74\'\' - 187cm', 187);
-- --------------------------------------------------------
--
-- Table structure for table `horoscope_details`
--
CREATE TABLE `horoscope_details` (
`id` int NOT NULL,
`user_id` varchar(25) NOT NULL,
`star` varchar(255) DEFAULT NULL,
`raasi` varchar(255) DEFAULT NULL,
`laknam` varchar(255) DEFAULT NULL,
`disha` varchar(255) DEFAULT NULL,
`horo_year` varchar(255) DEFAULT NULL,
`horo_month` varchar(255) DEFAULT NULL,
`horo_day` varchar(255) DEFAULT NULL,
`rasi_grid` text,
`amsam_grid` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
--
-- Dumping data for table `horoscope_details`
--
INSERT INTO `horoscope_details` (`id`, `user_id`, `star`, `raasi`, `laknam`, `disha`, `horo_year`, `horo_month`, `horo_day`, `rasi_grid`, `amsam_grid`) VALUES
(1, 'BELL10002', '16', '12', 'மகரம்', 'வியாழ மகா திசை', '', '', '', '[[\"moon\"],[\"ketu\"],[\"sev\"],[\"lac\"],null,[\"sat\"],[\"rahu\"],[\"viji\"],null,[\"sun\"],[\"chk\"],[\"pu\"]]', '[[\"moon\"],[\"rahu\"],[\"sun\"],[\"sev\"],null,[\"ketu\"],null,[\"viji\"],[\"sat\"],[\"pu\"],[\"lac\"],[\"chk\"]]'),
(2, 'BELL10003', '16', '12', 'மகரம்', 'வியாழ மகா திசை', '', '', '', '[[\"moon\"],[\"ketu\"],[\"sev\"],[\"lac\"],null,[\"sat\"],[\"rahu\"],[\"viji\"],null,[\"sun\"],[\"chk\"],[\"pu\"]]', '[[\"moon\"],[\"rahu\"],[\"sun\"],[\"sev\"],null,[\"ketu\"],null,[\"viji\"],[\"sat\"],[\"pu\"],[\"lac\"],[\"chk\"]]'),
(3, 'BELL10004', '23', '11', 'கும்பம்', 'செவ்வாய் மகா திசை', '', '', '', '[[\"pu\"],[\"moon\"],[\"sun\"],[\"sev\"],null,[\"sat\"],[\"lac\"],[\"ketu\"],null,[\"chk\"],[\"viji\"],[\"rahu\"]]', '[[\"sun\"],[\"moon\"],[\"rahu\"],null,[\"sev\"],[\"sat\"],[\"viji\"],[\"ketu\"],[\"lac\"],[\"pu\"],[\"chk\"],null]'),
(4, 'BELL10005', '14', '7', 'தனுசு', 'செவ்வாய் மகா திசை', '', '', '', '[[\"chk\"],[\"sev\"],[\"ketu\"],[\"sun\"],[\"moon\"],[\"viji\"],[\"rahu\"],[\"lac\"],null,null,[\"sat\"],[\"pu\"]]', '[[\"ketu\"],[\"viji\"],[\"pu\"],[\"sat\"],null,[\"sev\"],[\"chk\"],[\"rahu\"],null,[\"moon\"],[\"lac\"],[\"sun\"]]'),
(5, 'BELL10007', '24', '11', 'கடகம்', 'ராகு மகா திசை', '00', '07', '29', '[[\"rahu\"],null,null,null,[\"moon\"],[\"sev\",\"chk\",\"lac\"],[\"viji\"],[\"pu\",\"sun\"],null,null,[\"sat\",\"ketu\"],null]', '[[\"moon\",\"ketu\",\"sev\"],[\"pu\"],[\"sat\",\"viji\"],null,null,null,null,[\"sun\"],null,[\"lac\"],null,[\"rahu\",\"chk\"]]'),
(6, 'BELL10008', '2', '1', '', '', '', '', '', '[null,null,null,null,null,null,null,null,null,null,null,null]', '[null,null,null,null,null,null,null,null,null,null,null,null]'),
(7, 'BELL10009', '24', '11', 'தனுசு', 'ராகு மகா திசை', '05', '02', '16', '[null,[\"rahu\"],null,[\"pu\"],[\"moon\",\"viji\"],[\"sun\"],[\"sev\"],[\"chk\"],[\"lac\"],[\"sat\"],[\"ketu\"],null]', '[null,[\"pu\",\"rahu\"],null,[\"viji\"],[\"moon\"],null,[\"sev\"],[\"sat\"],null,[\"lac\"],null,[\"sun\",\"ketu\",\"chk\"]]'),
(8, 'BELL10010', '24', '11', 'மிதுனம்', 'ராகு மகா திசை', '12', '11', '26', '[null,[\"sun\",\"viji\"],[\"pu\"],[\"chk\",\"lac\"],[\"moon\",\"rahu\"],null,[\"sev\"],[\"ketu\"],[\"sat\"],null,null,null]', '[null,null,[\"pu\"],[\"rahu\"],null,[\"sat\"],[\"pu\",\"moon\",\"lac\"],null,[\"ketu\"],[\"sun\",\"chk\"],[\"viji\"],[\"sev\"]]'),
(9, 'BELL10011', '6', '3', 'தனுசு', 'ராகு மகா திசை', '04', '05', '07', '[[\"sun\",\"rahu\",\"viji\"],null,[\"sev\"],[\"moon\"],[\"pu\",\"chk\"],null,null,null,[\"lac\"],[\"sat\"],null,[\"ketu\"]]', '[[\"sat\"],null,[\"pu\"],[\"ketu\"],[\"moon\",\"sev\",\"chk\"],null,[\"sun\"],null,[\"rahu\"],[\"viji\"],null,null]'),
(10, 'BELL10012', '2', '1', 'மீனம்', 'சுக்கிர மகா திசை', '08', '11', '03', '[[\"rahu\",\"lac\"],[\"moon\"],null,null,null,[\"pu\",\"sat\"],null,[\"sev\"],null,null,null,[\"ketu\"]]', '[[\"sun\"],[\"ketu\",\"sev\"],[\"moon\"],null,[\"pu\",\"chk\",\"lac\"],null,null,null,null,null,[\"sat\",\"rahu\"],null]'),
(15, 'BELL10013', '24', '11', 'விருச்சிகம்', 'ராகு மகா திசை', '3', '09', '13', '[null,[\"sun\",\"viji\"],[\"pu\"],[\"chk\"],[\"moon\",\"rahu\"],null,[\"sev\"],[\"ketu\"],[\"sat\"],[\"lac\"],null,null]', '[[\"moon\"],[\"sat\"],[\"pu\",\"rahu\"],null,null,null,null,null,[\"chk\"],[\"sun\",\"ketu\",\"lac\"],[\"viji\"],[\"sev\"]]'),
(16, 'BELL10018', '17', '8', 'கடகம்', 'சனி மகா திசை', '07', '08', '09', '[null,null,null,[\"ketu\"],[\"pu\",\"sat\"],null,[\"sun\",\"sev\",\"chk\"],[\"lac\"],[\"moon\",\"rahu\"],[\"viji\"],null,null]', '[[\"viji\"],null,null,null,[\"pu\",\"ketu\"],[\"lac\"],null,[\"sat\",\"rahu\"],null,[\"sun\"],[\"moon\",\"sev\",\"chk\"],null]'),
(17, 'BELL10019', '22', '10', 'மீனம்', 'சந்திர மகா திசை', '00', '07', '21', '[[\"chk\",\"lac\"],null,[\"ketu\"],[\"sev\"],[\"pu\",\"sun\"],null,[\"sat\",\"moon\"],null,null,[\"rahu\"],null,[\"viji\"]]', '[[\"pu\"],null,null,null,[\"sev\"],[\"sat\",\"moon\",\"ketu\",\"viji\"],[\"rahu\",\"chk\",\"lac\"],null,[\"sun\"],null,null,null]'),
(18, 'BELL10020', '15', '7', 'கும்பம்', 'ராகு மகா திசை', '02', '05', '23', '[null,null,null,[\"ketu\"],[\"lac\"],null,[\"sat\"],[\"viji\"],[\"rahu\"],[\"pu\",\"sev\"],[\"sun\",\"moon\"],[\"chk\"]]', '[[\"moon\",\"ketu\",\"sev\"],[\"lac\"],null,null,[\"sun\"],null,[\"sat\"],null,[\"chk\"],null,[\"pu\"],[\"rahu\"]]'),
(19, 'BELL10021', '24', '11', 'விருச்சிகம்', 'ராகு மகா திசை', '12', '11', '2', '[null,null,null,[\"viji\"],[\"moon\"],[\"ketu\"],[\"rahu\"],[\"pu\",\"sun\"],[\"sat\"],[\"lac\"],[\"chk\"],[\"sev\"]]', '[[\"ketu\"],null,null,[\"sat\"],[\"viji\"],null,[\"moon\",\"sev\"],null,[\"pu\",\"sun\",\"chk\"],null,null,[\"rahu\",\"lac\"]]'),
(20, 'BELL10022', '22', '10', 'தனுசு', 'சந்திர மகா திசை', '௦௭', '04', '10', '[null,[\"ketu\"],[\"pu\",\"chk\"],[\"sun\"],[\"sat\"],null,[\"moon\"],[\"sev\"],[\"lac\"],[\"viji\"],[\"rahu\"],null]', '[null,[\"pu\",\"sat\",\"moon\"],[\"chk\",\"lac\"],[\"ketu\"],null,null,null,[\"sev\"],[\"rahu\",\"viji\"],null,[\"sun\"],null]'),
(21, 'BELL10023', '24', '11', 'தனுசு', 'ராகு மகா திசை', '16', '06', '16', '[null,null,null,null,[\"moon\"],[\"ketu\"],[\"rahu\",\"chk\"],null,[\"pu\",\"sat\",\"lac\"],[\"sun\"],[\"sev\"],null]', '[null,null,null,[\"sev\"],[\"ketu\",\"viji\"],null,[\"chk\"],[\"rahu\"],[\"sun\",\"moon\"],null,[\"lac\"],[\"sat\"]]'),
(22, 'BELL10024', '23', '11', 'ரிஷபம்', 'செவ்வாய் மகா திசை', '௦௨', '05', '01', '[null,null,[\"pu\",\"sun\",\"lac\"],[\"ketu\"],[\"moon\"],[\"sev\",\"chk\"],[\"sat\"],null,[\"rahu\"],null,null,null]', '[null,null,[\"ketu\"],[\"pu\",\"sun\",\"lac\"],[\"sat\"],null,null,[\"chk\"],null,[\"rahu\"],[\"moon\",\"sev\"],null]'),
(23, 'BELL10025', '20', '9', 'சிம்மம்', 'சுக்கிர மகா திசை', '06', '00', '07', '[null,null,[\"rahu\"],null,null,[\"sev\"],null,[\"pu\",\"sun\",\"chk\",\"lac\"],[\"moon\"],[\"ketu\",\"viji\"],[\"sat\"],null]', '[[\"ketu\"],[\"sun\"],null,null,null,null,null,[\"lac\"],null,null,[\"pu\",\"sat\",\"moon\",\"viji\"],[\"rahu\",\"sev\",\"chk\"]]'),
(24, 'BELL10026', '4', '2', 'மிதுனம்', 'சந்திர மகா திசை', '௦௦', '00', '09', '[null,[\"rahu\"],[\"moon\",\"chk\"],[\"sun\",\"sev\",\"lac\"],null,[\"pu\"],null,null,null,null,[\"sat\",\"ketu\"],null]', '[null,[\"ketu\"],[\"sat\",\"sun\",\"sev\",\"chk\"],[\"lac\"],null,[\"moon\"],[\"pu\"],null,null,null,[\"rahu\"],null]'),
(25, 'BELL10027', '1', '1', 'ரிஷபம்', 'கேது மகா திசை', '02', '09', '07', '[null,[\"moon\"],[\"ketu\",\"chk\",\"lac\"],[\"pu\",\"sun\"],null,null,[\"sat\"],[\"sev\"],null,[\"rahu\"],null,[\"viji\"]]', '[null,null,[\"sun\",\"ketu\",\"viji\",\"chk\"],[\"moon\"],null,null,[\"pu\"],[\"sat\"],null,[\"rahu\"],null,[\"sev\",\"lac\"]]'),
(26, 'BELL10028', '1', '1', 'கடகம்', 'கேது மகா திசை', '02', '00', '13', '[null,[\"moon\"],null,[\"ketu\"],null,[\"lac\"],null,[\"viji\",\"chk\"],[\"sat\",\"rahu\"],null,[\"pu\",\"sun\",\"sev\"],null]', '[[\"ketu\"],null,[\"pu\"],[\"moon\"],null,null,[\"sev\"],[\"viji\"],[\"sat\"],[\"sun\",\"lac\"],[\"chk\"],[\"rahu\"]]'),
(27, 'BELL10029', '4', '2', 'மேஷம்', 'சந்திர மகா திசை', '௦௦', '08', '04', '[null,[\"rahu\",\"lac\"],[\"moon\"],[\"sun\"],[\"viji\"],[\"pu\",\"chk\"],null,null,[\"sev\"],[\"sat\"],[\"ketu\"],null]', '[[\"sun\",\"chk\"],[\"rahu\",\"lac\"],null,[\"viji\"],null,[\"moon\"],null,null,null,[\"sev\"],[\"pu\",\"sat\",\"ketu\"],null]'),
(28, 'BELL10030', '13', '6', 'தனுசு', 'சந்திர மகா திசை', '௦௪', '11', '12', '[null,[\"rahu\"],[\"chk\"],null,null,[\"pu\",\"sun\",\"sev\"],null,null,[\"lac\"],null,[\"ketu\"],[\"moon\"]]', '[[\"ketu\"],[\"sat\"],null,[\"moon\"],null,null,null,[\"sev\",\"chk\"],[\"lac\"],null,[\"pu\"],[\"sun\",\"rahu\"]]'),
(29, 'BELL10031', '16', '7', 'தனுசு', 'வியாழ மகா திசை', '14', '01', '21', '[[\"pu\",\"rahu\",\"viji\"],[\"sun\"],[\"sev\"],null,[\"chk\"],null,null,null,[\"lac\"],[\"sat\"],[\"moon\"],[\"ketu\"]]', '[null,[\"sun\",\"moon\",\"lac\"],[\"ketu\",\"sev\"],[\"chk\"],null,null,[\"sat\"],null,[\"viji\"],[\"rahu\"],null,null]'),
(30, 'BELL10032', '3', '2', 'விருச்சிகம்', 'சூரிய மகா திசை', '04', '04', '14', '[null,null,[\"moon\"],null,null,null,null,null,null,[\"sat\"],[\"pu\",\"chk\"],[\"sun\",\"ketu\",\"sev\"]]', '[[\"pu\",\"ketu\",\"sev\"],null,null,null,[\"sat\"],[\"sun\"],[\"moon\"],[\"lac\"],null,[\"chk\"],null,[\"rahu\"]]'),
(31, 'BELL10033', '16', '7', 'கடகம்', 'வியாழ மகா திசை', '02', '04', '24', '[null,[\"rahu\"],[\"pu\",\"sun\"],[\"chk\"],[\"viji\"],[\"lac\"],null,null,[\"sev\"],null,[\"sat\",\"ketu\"],null]', '[[\"pu\",\"sun\"],null,[\"rahu\",\"viji\"],[\"moon\"],null,null,null,null,[\"sev\",\"chk\"],[\"ketu\",\"lac\"],[\"sat\"],null]'),
(32, 'BELL10034', '1', '1', 'தனுசு', 'கேது மகா திசை', '௦௫', '01', '22', '[null,[\"ketu\"],[\"sat\",\"moon\"],null,[\"pu\"],null,null,[\"viji\",\"chk\"],[\"sev\"],null,[\"rahu\"],[\"sun\"]]', '[null,[\"moon\",\"rahu\",\"chk\"],[\"sun\"],[\"pu\",\"sev\"],null,null,[\"viji\"],null,[\"lac\"],null,[\"sat\",\"ketu\"],null]'),
(33, 'BELL10035', '15', '7', '', 'ராகு மகா திசை', '09', '09', '00', '[[\"lac\"],[\"rahu\"],null,[\"chk\"],null,[\"pu\",\"sev\"],[\"viji\"],[\"sun\"],null,null,[\"sat\",\"moon\",\"ketu\"],null]', '[[\"ketu\"],null,[\"sat\",\"sun\"],[\"viji\",\"chk\"],[\"lac\"],null,[\"moon\",\"sev\"],null,[\"pu\"],null,null,[\"rahu\"]]'),
(34, 'BELL10036', '5', '2', 'மிதுனம்', 'செவ்வாய் மகா திசை', '௦௫', '00', '24', '[[\"sun\"],[\"viji\",\"chk\"],[\"moon\"],[\"lac\"],[\"pu\",\"rahu\"],null,null,[\"ketu\"],[\"sat\",\"sev\"],null,null,null]', '[null,[\"sat\"],null,[\"pu\",\"rahu\",\"viji\"],[\"sun\"],null,null,null,[\"ketu\"],[\"sev\",\"chk\"],[\"lac\"],[\"moon\"]]'),
(35, 'BELL10037', '16', '7', 'மேஷம்', 'வியாழ மகா திசை', '08 ', '05', '09', '[null,[\"viji\",\"lac\"],[\"pu\",\"sun\"],[\"chk\"],[\"rahu\",\"sev\"],null,null,[\"ketu\"],null,[\"sat\"],[\"moon\"],null]', '[null,null,[\"sun\",\"moon\",\"rahu\"],[\"pu\"],[\"sat\",\"chk\"],null,[\"sev\"],[\"lac\"],null,[\"ketu\",\"viji\"],null,null]'),
(36, 'BELL10038', '7', '3', 'கும்பம்', 'வியாழ மகா திசை', '13', '01', '13', '[[\"rahu\",\"viji\"],[\"sev\"],null,[\"moon\"],[\"sun\",\"lac\"],null,[\"pu\"],null,null,[\"sat\"],null,[\"ketu\"]]', '[null,[\"moon\"],[\"sun\",\"chk\"],[\"ketu\",\"lac\"],null,null,[\"sat\",\"viji\"],[\"sev\"],[\"rahu\"],null,null,[\"pu\"]]'),
(37, 'BELL10039', '18', '8', 'மிதுனம்', 'புதன் மகா திசை', '௦௦', '08', '05', '[null,null,[\"rahu\"],[\"sun\",\"lac\"],null,[\"pu\",\"chk\"],null,null,[\"viji\"],[\"moon\",\"ketu\"],[\"sat\",\"sev\"],null]', '[[\"moon\",\"rahu\"],[\"sev\"],[\"sun\"],null,[\"lac\"],[\"chk\"],[\"sat\"],[\"viji\"],[\"pu\"],null,null,[\"ketu\"]]'),
(38, 'BELL10040', '16', '7', 'மீனம்', 'வியாழ மகா திசை', '00', '08', '28', '[[\"sev\",\"lac\"],null,[\"viji\"],null,[\"rahu\"],null,null,[\"ketu\",\"chk\"],null,[\"sat\"],[\"moon\"],[\"pu\",\"sun\"]]', '[[\"sat\",\"sun\",\"rahu\"],[\"pu\",\"viji\"],[\"moon\"],null,null,null,null,[\"sun\",\"chk\"],[\"lac\"],null,[\"sev\"],[\"ketu\"]]'),
(39, 'BELL10041', '22', '10', 'மிதுனம்', 'சந்திர மகா திசை', '06 ', '05', '26', '[[\"chk\"],[\"viji\"],[\"lac\"],null,[\"sun\",\"rahu\"],null,[\"pu\",\"moon\"],[\"ketu\"],[\"sat\",\"sev\"],null,null,null]', '[null,[\"pu\",\"sat\",\"viji\",\"sev\"],[\"moon\"],[\"rahu\"],[\"lac\"],null,null,null,[\"ketu\"],null,[\"sun\",\"chk\"],null]'),
(40, 'BELL10042', '13', '6', 'சிம்மம்', 'சந்திர மகா திசை', '08', '00', '00', '[[\"rahu\"],null,null,null,[\"sev\"],null,null,[\"lac\"],[\"sun\"],[\"pu\",\"sat\"],[\"chk\"],[\"moon\",\"ketu\"]]', '[[\"pu\"],[\"moon\",\"viji\"],[\"sev\",\"chk\"],[\"sun\",\"lac\"],null,[\"ketu\"],[\"sat\",\"rahu\"],null,null,null,null,null]'),
(41, 'BELL10043', '23', '11', 'மிதுனம்', 'செவ்வாய் மகா திசை', '௦௩', '02', '24', '[[\"rahu\"],null,null,[\"lac\"],[\"moon\",\"viji\",\"sev\"],null,null,null,null,[\"sat\"],[\"pu\",\"sun\",\"chk\"],[\"ketu\"]]', '[[\"lac\"],[\"sun\",\"viji\",\"chk\"],null,null,[\"rahu\"],null,null,[\"ketu\"],[\"pu\"],null,[\"sat\",\"moon\",\"sev\"],null]'),
(42, 'BELL10044', '26', '12', 'சிம்மம்', 'சனி மகா திசை', '09 ', '04', '04', '[[\"moon\",\"chk\"],[\"pu\",\"rahu\"],[\"sun\",\"sev\"],null,null,null,[\"viji\"],null,null,null,[\"sat\"],null]', '[null,null,[\"sat\"],[\"sev\"],null,[\"viji\"],[\"sun\",\"chk\"],null,[\"lac\"],[\"rahu\"],[\"moon\"],[\"pu\"]]'),
(43, 'BELL10045', '21', '10', 'மீனம்', 'சூரிய மகா திசை', '௦௨', '03', '00', '[[\"rahu\",\"lac\"],null,null,null,null,null,[\"moon\"],[\"sun\",\"sev\",\"chk\"],null,[\"sat\"],null,[\"pu\",\"ketu\"]]', '[[\"pu\",\"ketu\"],null,null,null,[\"moon\"],null,null,[\"sev\"],null,[\"sat\",\"lac\"],null,[\"sun\",\"rahu\",\"chk\"]]'),
(44, 'BELL10046', '3', '2', 'சிம்மம்', 'சூரிய மகா திசை', '03', '11', '22', '[null,null,[\"pu\",\"sat\",\"sun\",\"chk\"],null,[\"rahu\",\"sev\"],null,null,[\"ketu\",\"lac\"],null,null,null,null]', '[[\"sev\"],[\"lac\"],[\"sat\",\"rahu\"],null,null,null,[\"moon\"],null,null,[\"ketu\"],null,[\"pu\",\"sun\",\"chk\"]]'),
(45, 'BELL10047', '13', '6', 'மீனம்', 'சந்திர மகா திசை', '௦௦', '09', '17', '[[\"lac\"],null,[\"rahu\"],null,null,null,null,null,[\"viji\",\"sev\"],[\"ketu\",\"chk\"],[\"pu\",\"sat\",\"sun\"],[\"moon\"]]', '[[\"sat\"],[\"pu\"],null,null,[\"rahu\"],null,null,[\"ketu\",\"viji\"],[\"lac\"],[\"sun\"],null,[\"chk\"]]');
-- --------------------------------------------------------
--
-- Table structure for table `interests`
--
CREATE TABLE `interests` (
`id` int NOT NULL,
`sender_id` varchar(25) NOT NULL,
`interested_member` varchar(25) NOT NULL,
`send_on` datetime NOT NULL,
`accepted_on` datetime DEFAULT NULL,
`interest_status` tinyint NOT NULL COMMENT '0-sent, 1-accepted, 2-declined',
`interest_record_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1-deleted'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `interests`
--
INSERT INTO `interests` (`id`, `sender_id`, `interested_member`, `send_on`, `accepted_on`, `interest_status`, `interest_record_status`) VALUES
(1, 'BELL001', 'BELL10006', '2018-01-03 18:16:07', NULL, 0, 0);
-- --------------------------------------------------------
--
-- Table structure for table `marital_status`
--
CREATE TABLE `marital_status` (
`id` int NOT NULL,
`marital_status` varchar(30) DEFAULT NULL,
`marital_status_tamil` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `marital_status`
--
INSERT INTO `marital_status` (`id`, `marital_status`, `marital_status_tamil`) VALUES
(1, 'Un Married', 'திருமணமாகாதவர்'),
(2, 'Divorced', 'விவாகரத்தானவர்'),
(3, 'Widowed', 'துணையை இழந்தவர்'),
(4, 'Awaiting Divorced', 'விவாகரத்துக்காக காத்திருப்பவர்');
-- --------------------------------------------------------
--
-- Table structure for table `mother_tongue`
--
CREATE TABLE `mother_tongue` (
`id` int NOT NULL,
`mother_tongue_id` int NOT NULL,
`mother_tongue` varchar(250) NOT NULL,
`mother_tongue_tamil` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `mother_tongue`
--
INSERT INTO `mother_tongue` (`id`, `mother_tongue_id`, `mother_tongue`, `mother_tongue_tamil`) VALUES
(1, 1, 'Malayalam', 'மலையாளம்'),
(2, 2, 'Hindhi', 'இந்தி'),
(3, 3, 'Tamil', 'தமிழ்'),
(4, 4, 'Bengali', 'பெங்காலி'),
(5, 5, 'Telugu', 'தெலுங்கு'),
(6, 6, 'Marathi', 'மராத்தி'),
(7, 7, 'Urdu', 'உருது'),
(8, 8, 'Gujarati', 'குஜராத்தி'),
(9, 9, 'Kannada', 'கன்னடம்'),
(10, 10, 'Odia', 'ஒடியா'),
(11, 11, ' Punjabi', 'பஞ்சாபி'),
(12, 12, 'Assamese', 'அஸ்ஸாமி'),
(13, 13, 'Maithili', 'மைதிலி'),
(14, 14, 'Bhili/Bhilodi', 'பில்லி/பிலோடி'),
(15, 15, 'Santali', 'சந்தாலி'),
(16, 16, 'Kashmiri', 'காஷ்மிரி'),
(17, 17, 'Nepali', 'நேபாளி'),
(18, 18, 'Gondi', 'கோண்டி'),
(19, 19, 'Sindhi', 'சிந்தி'),
(20, 20, 'Konkani', 'கொங்கனி'),
(21, 21, 'Dogri', 'டோக்ரி'),
(22, 22, 'Khandeshi', 'காண்டெஷி'),
(23, 23, 'Kurukh', 'குருக்ஹ்'),
(24, 24, 'Tulu', 'துளு'),
(25, 25, 'Meitei/Manipuri', 'மீட்டி/மணிப்புரி'),
(26, 26, 'Bodo', 'போடோ'),
(27, 27, 'Khasi', 'காசி'),
(28, 28, 'Mundari', 'முந்தரி'),
(29, 28, 'English', 'ஆங்கிலம்');
-- --------------------------------------------------------
--
-- Table structure for table `nakshathra`
--
CREATE TABLE `nakshathra` (
`id` int NOT NULL,
`nakshathra` varchar(30) DEFAULT NULL,
`nakshathra_tamil` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `nakshathra`
--
INSERT INTO `nakshathra` (`id`, `nakshathra`, `nakshathra_tamil`) VALUES
(1, 'Aswini ', 'அசுவினி'),
(2, 'Bharani ', 'பரணி'),
(3, 'Krittika ', 'கார்த்திகை'),
(4, 'Rohini ', 'ரோகிணி'),
(5, 'Mrigcira ', 'மிருகசீரிடம்'),
(6, 'Ardra ', 'திருவாதிரை'),
(7, 'Punarvasu ', 'புனர்பூசம்'),
(8, 'Pushya ', 'பூசம்'),
(9, 'Ashlesha ', 'ஆயில்யம்'),
(10, 'Magha ', 'மகம்'),
(11, 'Poorva Pulguni', 'பூரம்'),
(12, 'Uttar Pulguni', 'உத்திரம்'),
(13, 'Hasta ', 'அஸ்தம்'),
(14, 'Chitra ', 'சித்திரை'),
(15, 'Swati ', 'சுவாதி'),
(16, 'Vishaka ', 'விசாகம்'),
(17, 'Anuradha ', 'அனுஷம்'),
(18, 'Jyeshta ', 'கேட்டை'),
(19, 'Moola ', 'மூலம்'),
(20, 'Poorvashadha ', 'பூராடம்'),
(21, 'Uttarashadha ', 'உத்திராடம்'),
(22, 'Sharavan ', 'திருவோணம்'),
(23, 'Dhanishta ', 'அவிட்டம்'),
(24, 'Satbhij ', 'சதயம்'),
(25, 'Poorva Bhadrpada', 'பூரட்டாதி'),
(26, 'Uttara Bhadrapada', 'உத்திரட்டாதி'),
(27, 'Revati ', 'ரேவதி');
-- --------------------------------------------------------
--
-- Table structure for table `occupation`
--
CREATE TABLE `occupation` (
`occupation_id` int NOT NULL,
`education_id` int DEFAULT NULL,
`occupation` varchar(250) NOT NULL,
`profession_id` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `occupation`
--
INSERT INTO `occupation` (`occupation_id`, `education_id`, `occupation`, `profession_id`) VALUES
(1, 0, 'Banking Professional', '1'),
(2, 0, 'Chartered Accountant', '1'),
(3, 0, 'Company Secretary', '1'),
(4, 0, 'Finance Professional', '1'),
(5, 0, 'Investment Professional', '1'),
(6, 0, 'Accounting Professional (Others)', '1'),
(7, 0, 'Admin Professional', '2'),
(8, 0, 'Human Resources Professional', '2'),
(9, 0, 'Actor', '3'),
(10, 0, 'Advertising Professional', '3'),
(11, 0, 'Entertainment Professional', '3'),
(12, 0, 'Event Manager', '3'),
(13, 0, 'Journalist', '3'),
(14, 0, 'Media Professional', '3'),
(15, 0, 'Public Relations Professional', '3'),
(16, 0, 'Farming', '4'),
(17, 0, 'Horticulturist', '4'),
(18, 0, 'Agricultural Professional (Others)', '4'),
(19, 0, 'Air Hostess / Flight Attendant', '5'),
(20, 0, 'Pilot / Co-Pilot', '5'),
(21, 0, 'Other Airline Professional', '5'),
(22, 0, 'Architect', '6'),
(23, 0, 'Interior Designer', '6'),
(24, 0, 'Landscape Architect', '6'),
(25, 0, 'Animator', '7'),
(26, 0, 'Commercial Artist', '7'),
(27, 0, 'Web / UX Designers', '7'),
(28, 0, 'Artist (Others)', '7'),
(29, 0, 'Beautician', '8'),
(30, 0, 'Fashion Designer', '8'),
(31, 0, 'Hairstylist', '8'),
(32, 0, 'Jewellery Designer', '8'),
(33, 0, 'Designer (Others)', '8'),
(34, 0, 'Customer Support / BPO / KPO Professional', '9'),
(35, 0, 'IAS / IRS / IES / IFS', '10'),
(36, 0, 'Indian Police Services (IPS)', '10'),
(37, 0, 'Law Enforcement Employee (Others)', '10'),
(38, 0, 'Airforce', '11'),
(39, 0, 'Army', '11'),
(40, 0, 'Navy', '11'),
(41, 0, 'Defense Services (Others)', '11'),
(42, 0, 'Lecturer', '12'),
(43, 0, 'Professor', '12'),
(44, 0, 'Research Assistant', '12'),
(45, 0, 'Research Scholar', '12'),
(46, 0, 'Teacher', '12'),
(47, 0, 'Training Professional (Others)', '12'),
(48, 0, 'Civil Engineer', '13'),
(49, 0, 'Electronics / Telecom Engineer', '13'),
(50, 0, 'Mechanical / Production Engineer', '13'),
(51, 0, 'Non IT Engineer (Others)', '13'),
(52, 0, 'Chef / Sommelier / Food Critic', '14'),
(53, 0, 'Catering Professional', '14'),
(54, 0, 'Hotel & Hospitality Professional (Others)', '14'),
(55, 0, 'Software Developer / Programmer', '15'),
(56, 0, 'Software Consultant', '15'),
(57, 0, 'Hardware & Networking professional', '15'),
(58, 0, 'Software Professional (Others)', '15'),
(59, 0, 'Lawyer', '16'),
(60, 0, 'Legal Assistant', '16'),
(61, 0, 'Legal Professional (Others)', '16'),
(62, 0, 'Dentist', '17'),
(63, 0, 'Doctor', '17'),
(64, 0, 'Medical Transcriptionist', '17'),
(65, 0, 'Nurse', '17'),
(66, 0, 'Pharmacist', '17'),
(67, 0, 'Physician Assistant', '17'),
(68, 0, 'Physiotherapist / Occupational Therapist', '17'),
(69, 0, 'Psychologist', '17'),
(70, 0, 'Surgeon', '17'),
(71, 0, 'Veterinary Doctor', '17'),
(72, 0, 'Therapist (Others)', '17'),
(73, 0, 'Medical / Healthcare Professional (Others)', '17'),
(74, 0, 'Merchant Naval Officer', '18'),
(75, 0, 'Mariner', '18'),
(76, 0, 'Marketing Professional', '19'),
(77, 0, 'Sales Professional', '19'),
(78, 0, 'Biologist / Botanist', '20'),
(79, 0, 'Physicist', '20'),
(80, 0, 'Science Professional (Others)', '20'),
(81, 0, 'CEO / Chairman / Director / President', '21'),
(82, 0, 'VP / AVP / GM / DGM', '21'),
(83, 0, 'Sr. Manager / Manager', '21'),
(84, 0, 'Consultant / Supervisor / Team Leads', '21'),
(85, 0, 'Team Member / Staff', '21'),
(86, 0, 'Agent / Broker / Trader / Contractor', '22'),
(87, 0, 'Business Owner / Entrepreneur', '22'),
(88, 0, 'Politician', '22'),
(89, 0, 'Social Worker / Volunteer / NGO', '22'),
(90, 0, 'Sportsman', '22'),
(91, 0, 'Travel & Transport Professional', '22'),
(92, 0, 'Writer', '22'),
(93, 0, 'Student', '23'),
(94, 0, 'Retired', '23'),
(95, 0, 'Not working', '23');
-- --------------------------------------------------------
--
-- Table structure for table `packages`
--
CREATE TABLE `packages` (
`id` int NOT NULL,
`package_name` varchar(500) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `packages`
--
INSERT INTO `packages` (`id`, `package_name`) VALUES
(6, 'Silver'),
(7, 'Gold'),
(8, 'Diamond'),
(9, 'Platinum');
-- --------------------------------------------------------
--
-- Table structure for table `package_details`
--
CREATE TABLE `package_details` (
`id` int NOT NULL,
`package_id` varchar(250) NOT NULL,
`period` varchar(250) NOT NULL,
`rate` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `package_details`
--
INSERT INTO `package_details` (`id`, `package_id`, `period`, `rate`) VALUES
(37, '6', '3', 1000),
(38, '6', '6', 1750),
(39, '7', '3', 2000),
(40, '7', '6', 3500),
(41, '8', '3', 3500),
(42, '8', '6', 6000),
(43, '9', '3', 5000),
(44, '9', '6', 8000);
-- --------------------------------------------------------
--
-- Table structure for table `partner_preference`
--
CREATE TABLE `partner_preference` (
`id` int NOT NULL,
`user_id` varchar(20) NOT NULL,
`age_from` int DEFAULT NULL,
`age_to` int DEFAULT NULL,
`height_from` int DEFAULT NULL,
`height_to` int DEFAULT NULL,
`marital_status` int DEFAULT NULL,
`religion` varchar(250) DEFAULT NULL,
`mother_tongue` varchar(250) DEFAULT NULL,
`community` varchar(250) DEFAULT NULL,
`sub_community` varchar(100) DEFAULT NULL,
`dosham` varchar(250) DEFAULT NULL,
`profile_created_by` varchar(150) DEFAULT NULL,
`country` varchar(250) DEFAULT NULL,
`state` varchar(500) DEFAULT NULL,
`residency` varchar(500) DEFAULT NULL,
`country_grew_up` int DEFAULT NULL,
`education` varchar(500) DEFAULT NULL,
`working_with` varchar(500) DEFAULT NULL,
`profession_area` varchar(500) DEFAULT NULL,
`annual_income` varchar(500) DEFAULT NULL,
`income_range` varchar(100) DEFAULT NULL,
`diet` varchar(500) DEFAULT NULL,
`smoke` tinyint DEFAULT NULL COMMENT '0-doesn''t matter,1-don''t include',
`drink` varchar(30) DEFAULT NULL,
`body_type` varchar(150) DEFAULT NULL,
`skin_tone` varchar(150) DEFAULT NULL,
`disability` tinyint(1) DEFAULT NULL COMMENT '0-doesn''t matter,1-don''t include',
`hiv` tinyint(1) DEFAULT NULL COMMENT '1-include,0-don''t include',
`updated_by` varchar(20) DEFAULT NULL,
`updated_on` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `partner_preference`
--
INSERT INTO `partner_preference` (`id`, `user_id`, `age_from`, `age_to`, `height_from`, `height_to`, `marital_status`, `religion`, `mother_tongue`, `community`, `sub_community`, `dosham`, `profile_created_by`, `country`, `state`, `residency`, `country_grew_up`, `education`, `working_with`, `profession_area`, `annual_income`, `income_range`, `diet`, `smoke`, `drink`, `body_type`, `skin_tone`, `disability`, `hiv`, `updated_by`, `updated_on`) VALUES
(1, 'BELL001', 17, 34, 7, 13, 1, '61', '3', '44', '257', 'doesnot matter', 'doesnot matter', '99', '79', '25', NULL, '', '', '', NULL, '', 'doesnot matter', 0, 'doesnot matter', 'doesnot matter', 'doesnot matter', 0, 0, 'BELL001', '2017-11-22 01:11:26'),
(2, 'BELL10004', 22, 25, 11, 13, 1, '61', '3', '11', '74', 'doesnot matter', 'doesnot matter', '99', '79', '30', NULL, '73', '1', ' 55 ', NULL, '2', 'doesnot matter', 1, 'never drinks', 'average/athletic', 'wheatish', 1, 0, 'admin', '2017-12-09 16:59:02'),
(3, 'BELL10005', 21, 24, 8, 11, 1, '3', '3', '478', NULL, 'doesnot matter', 'doesnot matter', '99', '79', '30', NULL, '7', '1', '', NULL, '3', 'doesnot matter', 1, 'never drinks', 'average/athletic', 'doesnot matter', 0, 0, 'admin', '2017-12-18 13:12:04'),
(4, 'BELL10006', 21, 29, 12, 15, 1, '61', '3', '11', '74', 'doesnot matter', 'doesnot matter', '99', '79', '30', NULL, '73', '3', ' 58 ', NULL, '3', 'doesnot matter', 1, 'never drinks', 'average/athletic', 'wheatish', 1, 0, 'BELL10006', '2017-12-19 03:12:44'),
(5, 'BELL10049', 28, 33, 4, 5, 1, '61', '3', '12', '', 'without chevvai dosham', 'self', '99', '79', '51', NULL, '', '', '', NULL, '', 'doesnot matter', 0, 'doesnot matter', 'doesnot matter', 'doesnot matter', 0, 0, 'BELL10049', '2019-05-15 22:24:18'),
(6, 'BELL10069', 25, 30, 1, 8, 1, '61', '9', '67', NULL, 'doesnot matter', 'doesnot matter', '99', '67', '257', NULL, '5', '1', ' 1 ', NULL, '3', 'doesnot matter', 0, 'doesnot matter', 'doesnot matter', 'doesnot matter', 1, 0, 'BELL10069', '2024-03-02 07:03:53');
-- --------------------------------------------------------
--
-- Table structure for table `payment`
--
CREATE TABLE `payment` (
`id` int NOT NULL,
`user_id` varchar(25) NOT NULL,
`plan_id` int NOT NULL,
`payment` decimal(20,2) NOT NULL,
`paid_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`paid_by` varchar(50) NOT NULL DEFAULT 'self' COMMENT 'self - from website, value - branch id, admin- super-admin',
`transaction_id` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `payment`
--
INSERT INTO `payment` (`id`, `user_id`, `plan_id`, `payment`, `paid_on`, `paid_by`, `transaction_id`) VALUES
(1, 'BELL001', 8, 1750.00, '2023-03-02 07:26:49', 'admin', 'TRANS001'),
(2, 'BELL001', 7, 1000.00, '2023-03-02 07:26:49', 'admin', 'TRANS002'),
(3, 'BELL10003', 9, 2000.00, '2023-03-02 07:26:49', '6', 'TRANS003');
-- --------------------------------------------------------
--
-- Table structure for table `plan_details`
--
CREATE TABLE `plan_details` (
`id` int NOT NULL,
`period_id` int NOT NULL,
`package_details` longtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `plan_details`
--
INSERT INTO `plan_details` (`id`, `period_id`, `package_details`) VALUES
(7, 37, '{\"send_interest\":\"0\",\"personalized_message\":\"50\",\"verified_mobile\":\"25\",\"send_sms\":\"50\",\"tagged_as_paid\":\"50\"}'),
(8, 38, '{\"send_interest\":\"150\",\"personalized_message\":\"150\",\"verified_mobile\":\"75\",\"send_sms\":\"150\",\"tagged_as_paid\":\"150\"}'),
(9, 39, '{\"send_interest\":\"100\",\"personalized_message\":\"100\",\"verified_mobile\":\"50\",\"send_sms\":\"100\",\"tagged_as_paid\":\"100\"}');
-- --------------------------------------------------------
--
-- Table structure for table `profession`
--
CREATE TABLE `profession` (
`id` int NOT NULL,
`department` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `profession`
--
INSERT INTO `profession` (`id`, `department`) VALUES
(1, 'Accounting, Banking & Finance'),
(2, 'Administration & HR'),
(3, 'Advertising Media and Entertainment'),
(4, 'Agriculture'),
(5, 'Airline & Aviation'),
(6, 'Architecture & Design'),
(7, 'Artists, Animators & Web designers'),
(8, 'Beauty Fashion & Jewellery Designers'),
(9, 'BPO, KPO & Customer Support'),
(10, 'Civil Services / Law Enforcement'),
(11, 'Defense'),
(12, 'Education & Training'),
(13, 'Engineering'),
(14, 'Hotel and Hospitality'),
(15, 'IT & Software Engineering'),
(16, 'Legal'),
(17, 'Medical & HelathCare'),
(18, 'Merchant Navy'),
(19, 'Sales & Marketing'),
(20, 'Science'),
(21, 'Corporate Professionals'),
(22, 'Others'),
(23, 'Non Working');
-- --------------------------------------------------------
--
-- Table structure for table `profile`
--
CREATE TABLE `profile` (
`id` int NOT NULL,
`user_id` varchar(20) NOT NULL,
`dob` date NOT NULL,
`age` int NOT NULL,
`country` int NOT NULL,
`state` int NOT NULL,
`city` int NOT NULL,
`religion` int NOT NULL,
`community` int NOT NULL,
`sub_community` int DEFAULT NULL,
`mother_tongue` int NOT NULL,
`marital_status` int NOT NULL,
`nakshathra` int NOT NULL,
`rasi` int NOT NULL,
`dosham` tinyint NOT NULL COMMENT '1-yes,0-no,2-don''t know',
`profile_created_by` varchar(60) NOT NULL,
`myself` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
`disability` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1 - disability',
`updated_by` varchar(20) NOT NULL,
`update_on` datetime NOT NULL,
`body_weight` int DEFAULT NULL,
`health_problem` varchar(50) DEFAULT NULL,
`other_health_problem` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`blood_group` varchar(10) DEFAULT NULL,
`photo` text,
`gothra` varchar(200) DEFAULT NULL,
`photo_approval` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1-approved, 2-rejected',
`photo_reason` text
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `profile`
--
INSERT INTO `profile` (`id`, `user_id`, `dob`, `age`, `country`, `state`, `city`, `religion`, `community`, `sub_community`, `mother_tongue`, `marital_status`, `nakshathra`, `rasi`, `dosham`, `profile_created_by`, `myself`, `disability`, `updated_by`, `update_on`, `body_weight`, `health_problem`, `other_health_problem`, `blood_group`, `photo`, `gothra`, `photo_approval`, `photo_reason`) VALUES
(1, 'BELL001', '1980-08-15', 37, 99, 79, 25, 61, 44, 257, 3, 1, 13, 6, 0, 'self', '', 0, 'BELL001', '2022-11-02 16:55:18', NULL, NULL, NULL, NULL, 'bell_mat_pr_BELL0011667388318.jpg', '', 1, NULL),
(3, 'BELL10003', '1996-04-06', 21, 99, 79, 30, 61, 10, 51, 3, 1, 20, 12, 0, 'doesnot matter', '', 0, 'admin', '2017-12-09 15:50:58', 60, 'No Health Problems', '', 'A+', 'bell_glBELL100031512814858.jpg', '160', 1, NULL),
(4, 'BELL10004', '1990-03-24', 27, 99, 79, 30, 61, 11, 74, 3, 1, 23, 11, 0, 'self', 'நான் மிகவும் எளிமையானவன் ', 0, 'admin', '2017-12-09 16:44:29', 72, 'No Health Problems', '', 'AB+', 'bell_glBELL100041512818069.jpg', '', 1, NULL),
(5, 'BELL10005', '1990-03-15', 27, 99, 79, 30, 61, 8, 33, 3, 1, 15, 6, 0, 'self', '', 0, 'admin', '2017-12-16 13:07:34', 63, 'No Health Problems', '', 'AB+', 'bell_glBELL100051513409854.jpg', '14', 1, NULL),
(6, 'BELL10006', '1993-10-08', 24, 99, 79, 30, 61, 11, 74, 3, 1, 14, 7, 2, 'self', '', 0, 'BELL10006', '2018-01-26 13:58:36', 63, 'No Health Problems', '', 'A+', 'bell_glBELL100061513677265.jpg', NULL, 1, NULL),
(7, 'BELL10007', '1985-08-31', 32, 99, 79, 45, 61, 513, 0, 3, 1, 24, 11, 0, 'parent/guardian', '', 0, 'admin', '2018-03-05 12:25:31', 0, 'No Health Problems', '', 'Don\'t Know', 'bell_glBELL100071520230419.png', '', 0, NULL),
(8, 'BELL10008', '1988-01-26', 30, 99, 79, 45, 61, 513, 0, 3, 1, 0, 1, 0, 'parent/guardian', '', 0, 'admin', '2018-03-05 12:09:21', 0, '', '', 'Don\'t Know', 'bell_glBELL100081520231226.png', '', 0, NULL),
(9, 'BELL10009', '1986-07-24', 31, 99, 79, 38, 61, 513, 0, 3, 1, 24, 11, 0, 'parent/guardian', '', 0, 'admin', '2018-03-05 12:26:03', 0, '', '', 'Don\'t Know', 'bell_glBELL100091520231755.png', '', 0, NULL),
(10, 'BELL10010', '1988-05-10', 29, 99, 79, 44, 61, 513, 0, 3, 1, 24, 11, 0, 'parent/guardian', '', 0, 'admin', '2018-03-05 12:26:30', 0, '', '', '', 'bell_glBELL100101520232433.png', '', 0, NULL),
(11, 'BELL10011', '1987-04-05', 30, 99, 79, 40, 61, 513, NULL, 3, 1, 6, 3, 0, 'parent/guardian', '', 0, 'admin', '2018-03-05 12:24:36', 0, '', '', '', 'bell_glBELL100111520232876.png', '', 0, NULL),
(12, 'BELL10012', '1987-08-15', 30, 99, 79, 39, 61, 513, NULL, 3, 1, 2, 1, 0, 'parent/guardian', '', 0, 'admin', '2018-03-05 12:34:53', 0, 'No Health Problems', '', '', 'bell_glBELL100121520233493.png', '', 0, NULL),
(13, 'BELL10013', '1988-05-10', 29, 99, 79, 21, 61, 29, 163, 3, 1, 24, 11, 0, 'parent/guardian', '', 0, 'admin', '2018-03-05 12:52:36', 0, 'No Health Problems', '', '', 'bell_glBELL100131520234556.png', '', 0, NULL),
(14, 'BELL10018', '1994-01-08', 24, 99, 79, 30, 61, 29, 155, 3, 1, 17, 8, 0, 'parent/guardian', '', 0, 'admin', '2018-03-05 13:02:15', 0, 'No Health Problems', '', '', 'bell_glBELL100181520235135.png', '', 0, NULL),
(15, 'BELL10019', '1993-02-20', 25, 99, 79, 30, 61, 29, 155, 3, 1, 22, 10, 0, 'parent/guardian', '', 0, 'admin', '2018-03-05 13:08:46', 0, '', '', '', 'bell_glBELL100191520235526.png', '', 0, NULL),
(16, 'BELL10020', '1991-11-06', 26, 99, 79, 30, 61, 29, 155, 3, 1, 15, 7, 0, 'parent/guardian', '', 0, 'admin', '2018-03-05 13:16:56', 0, '', '', '', 'bell_glBELL100201520236016.png', '', 0, NULL),
(17, 'BELL10021', '1989-09-14', 28, 99, 79, 30, 61, 29, 155, 3, 1, 24, 11, 0, 'parent/guardian', '', 0, 'admin', '2018-03-05 13:22:40', 0, '', '', '', 'bell_glBELL100211520236360.png', '', 0, NULL),
(18, 'BELL10022', '1995-06-16', 22, 99, 79, 30, 61, 29, 155, 3, 1, 22, 10, 0, 'parent/guardian', '', 0, 'admin', '2018-03-05 14:05:16', 0, 'No Health Problems', '', '', 'bell_glBELL100221520238916.png', '', 0, NULL),
(19, 'BELL10023', '1989-12-05', 28, 99, 79, 22, 61, 29, 0, 3, 1, 24, 11, 0, 'parent/guardian', '', 0, 'admin', '2018-03-05 14:13:46', 0, '', '', '', 'bell_glBELL100231520239426.png', '', 0, NULL),
(20, 'BELL10024', '1991-06-04', 26, 99, 79, 30, 61, 29, 155, 3, 1, 23, 11, 0, 'parent/guardian', '', 0, 'admin', '2018-03-05 14:21:48', 0, '', '', '', 'bell_glBELL100241520239908.png', '', 0, NULL),
(21, 'BELL10025', '1983-08-20', 34, 99, 79, 45, 61, 513, NULL, 3, 1, 20, 9, 0, 'parent/guardian', '', 0, 'admin', '2018-03-05 14:34:10', 0, '', '', '', 'bell_glBELL100251520240650.png', '', 0, NULL),
(22, 'BELL10026', '1985-07-15', 32, 99, 79, 30, 61, 513, NULL, 3, 1, 4, 2, 0, 'parent/guardian', '', 0, 'admin', '2018-03-05 14:41:25', 0, '', '', '', 'bell_glBELL100261520241085.png', '', 0, NULL),
(23, 'BELL10027', '1993-07-13', 24, 99, 79, 30, 61, 29, 155, 3, 1, 1, 1, 0, 'parent/guardian', '', 0, 'admin', '2018-03-05 14:49:35', 0, 'No Health Problems', '', '', 'bell_glBELL100271520241576.png', '', 0, NULL),
(24, 'BELL10028', '1991-10-24', 26, 99, 79, 51, 61, 29, 155, 3, 1, 1, 1, 0, 'parent/guardian', '', 0, 'admin', '2018-03-05 14:55:13', 0, '', '', '', 'bell_glBELL100281520241913.png', '', 0, NULL),
(25, 'BELL10029', '1986-07-05', 31, 99, 79, 39, 61, 513, NULL, 3, 1, 4, 2, 0, 'parent/guardian', '', 0, 'admin', '2018-03-05 15:01:32', 0, '', '', '', 'bell_glBELL100291520242292.png', '', 0, NULL),
(26, 'BELL10030', '1985-07-23', 32, 99, 67, 237, 61, 513, NULL, 3, 1, 13, 6, 0, 'parent/guardian', '', 0, 'admin', '2018-03-05 15:06:59', 0, '', '', '', 'bell_glBELL100301520242619.png', '', 0, NULL),
(27, 'BELL10031', '1987-04-15', 30, 99, 67, 237, 61, 513, 0, 3, 1, 16, 7, 0, 'parent/guardian', '', 0, 'admin', '2018-03-05 15:13:17', 0, '', '', '', 'bell_glBELL100311520242946.png', '', 0, NULL),
(28, 'BELL10032', '1987-10-10', 30, 99, 79, 21, 61, 513, NULL, 3, 1, 3, 2, 0, 'parent/guardian', '', 0, 'admin', '2018-03-05 15:20:24', 0, '', '', '', 'bell_glBELL100321520243424.png', '', 0, NULL),
(29, 'BELL10033', '1986-06-23', 31, 99, 67, 237, 61, 513, NULL, 3, 1, 16, 7, 0, 'parent/guardian', '', 0, 'admin', '2018-03-05 15:27:30', 0, '', '', '', 'bell_glBELL100331520243850.png', '', 0, NULL),
(30, 'BELL10034', '1985-06-13', 32, 99, 79, 30, 61, 27, 0, 3, 1, 1, 1, 0, 'parent/guardian', '', 0, 'admin', '2018-03-05 15:44:25', 0, '', '', '', 'bell_glBELL100341520244735.png', '', 0, NULL),
(31, 'BELL10035', '1985-08-21', 32, 99, 79, 21, 61, 27, 0, 3, 1, 15, 7, 0, 'parent/guardian', '', 1, 'admin', '2018-03-05 15:52:50', 0, '', '', '', 'bell_glBELL100351520245370.png', '', 0, NULL),
(32, 'BELL10036', '1988-03-24', 29, 99, 79, 30, 61, 27, 0, 3, 1, 5, 2, 0, 'parent/guardian', '', 0, 'admin', '2018-03-05 15:58:25', 0, '', '', '', 'bell_glBELL100361520245705.png', '', 0, NULL),
(33, 'BELL10037', '1988-05-30', 29, 99, 79, 44, 61, 27, 0, 3, 1, 16, 7, 0, 'parent/guardian', '', 0, 'admin', '2018-03-05 16:04:51', 0, '', '', '', 'bell_glBELL100371520246091.png', '', 0, NULL),
(34, 'BELL10038', '1987-03-10', 30, 99, 79, 21, 61, 27, 0, 3, 1, 7, 3, 0, 'parent/guardian', '', 0, 'admin', '2018-03-05 16:12:12', 0, '', '', '', 'bell_glBELL100381520246532.png', '', 0, NULL),
(35, 'BELL10039', '1984-07-11', 33, 99, 79, 21, 61, 27, 0, 3, 1, 18, 8, 0, 'parent/guardian', '', 0, 'admin', '2018-03-05 16:17:36', 0, '', '', '', 'bell_glBELL100391520246856.png', '', 0, NULL),
(36, 'BELL10040', '1988-10-13', 29, 99, 79, 21, 61, 27, 0, 3, 1, 16, 7, 0, 'parent/guardian', '', 0, 'admin', '2018-03-05 17:07:41', 0, '', '', '', 'bell_glBELL100401520249416.png', '', 0, NULL),
(37, 'BELL10041', '1988-02-16', 30, 99, 79, 21, 61, 513, NULL, 3, 1, 22, 10, 0, 'parent/guardian', '', 0, 'admin', '2018-03-05 17:07:01', 0, '', '', '', 'bell_glBELL100411520249821.png', '', 0, NULL),
(38, 'BELL10042', '1986-12-24', 31, 99, 79, 21, 61, 513, NULL, 3, 1, 13, 6, 0, 'parent/guardian', '', 0, 'admin', '2018-03-05 17:13:10', 0, '', '', '', 'bell_glBELL100421520250190.png', '', 0, NULL),
(39, 'BELL10043', '1986-11-09', 31, 99, 79, 21, 61, 513, NULL, 3, 1, 23, 11, 0, 'parent/guardian', '', 0, 'admin', '2018-03-05 17:18:27', 0, '', '', '', 'bell_glBELL100431520250507.png', '', 0, NULL),
(40, 'BELL10044', '1985-05-15', 32, 99, 79, 21, 61, 513, NULL, 3, 1, 26, 12, 0, 'parent/guardian', '', 0, 'admin', '2018-03-05 17:24:22', 0, '', '', '', 'bell_glBELL100441520250862.png', '', 0, NULL),
(41, 'BELL10045', '1987-09-04', 30, 99, 67, 237, 61, 513, NULL, 3, 1, 21, 10, 0, 'parent/guardian', '', 0, 'admin', '2018-03-05 17:32:10', 0, '', '', '', 'bell_glBELL100451520251330.png', '', 0, NULL),
(42, 'BELL10046', '1988-06-12', 29, 99, 79, 21, 61, 513, NULL, 3, 1, 3, 2, 0, 'parent/guardian', '', 0, 'admin', '2018-03-05 17:38:47', 0, '', '', '', 'bell_glBELL100461520251727.png', '', 0, NULL),
(43, 'BELL10047', '1984-10-23', 33, 99, 79, 43, 61, 513, NULL, 3, 1, 13, 6, 0, 'parent/guardian', '', 0, 'admin', '2018-03-05 17:47:35', 0, '', '', '', 'bell_glBELL100471520252255.png', '', 0, NULL),
(44, 'BELL10049', '1980-01-20', 39, 99, 79, 51, 61, 12, NULL, 3, 1, 0, 9, 0, 'self', 'Good ', 0, 'BELL10049', '2019-05-15 22:10:51', NULL, NULL, NULL, NULL, 'bell_glBELL100491557938451.jpeg', NULL, 0, NULL),
(45, 'BELL10050', '1996-04-01', 24, 99, 79, 21, 61, 11, 70, 3, 1, 0, 5, 1, 'doesnot matter', '', 0, 'admin', '2020-11-16 10:14:31', 85, 'Other', 'Nothing', 'B+', NULL, '113', 0, NULL),
(46, 'BELL10051', '1996-04-01', 24, 99, 79, 21, 61, 11, 70, 3, 1, 0, 5, 1, 'doesnot matter', '', 0, 'admin', '2020-11-16 10:14:32', 85, 'Other', 'Nothing', 'B+', NULL, '113', 0, NULL),
(47, 'BELL10052', '1996-04-01', 24, 99, 79, 21, 61, 11, 70, 3, 1, 0, 5, 1, 'doesnot matter', '', 0, 'admin', '2020-11-16 10:14:43', 85, 'Other', 'Nothing', 'B+', NULL, '113', 0, NULL),
(48, 'BELL10053', '1996-04-01', 24, 99, 79, 21, 61, 11, 70, 3, 1, 0, 5, 1, 'doesnot matter', '', 0, 'admin', '2020-11-16 10:14:44', 85, 'Other', 'Nothing', 'B+', NULL, '113', 0, NULL),
(49, 'BELL10054', '1996-04-01', 24, 99, 79, 21, 61, 11, 70, 3, 1, 0, 5, 1, 'doesnot matter', '', 0, 'admin', '2020-11-16 10:14:44', 85, 'Other', 'Nothing', 'B+', NULL, '113', 0, NULL),
(50, 'BELL10055', '1996-04-01', 24, 99, 79, 21, 61, 11, 70, 3, 1, 0, 5, 1, 'doesnot matter', '', 0, 'admin', '2020-11-16 10:14:44', 85, 'Other', 'Nothing', 'B+', NULL, '113', 0, NULL),
(51, 'BELL10056', '1996-04-01', 24, 99, 79, 21, 61, 11, 70, 3, 1, 0, 5, 1, 'doesnot matter', '', 0, 'admin', '2020-11-16 10:14:54', 85, 'Other', 'Nothing', 'B+', NULL, '113', 0, NULL),
(52, 'BELL10057', '1996-04-01', 24, 99, 79, 21, 61, 11, 70, 3, 1, 0, 5, 1, 'doesnot matter', '', 0, 'admin', '2020-11-16 10:19:34', 85, 'Other', 'Nothing', 'B+', NULL, '113', 0, NULL),
(53, 'BELL10058', '1996-04-01', 24, 99, 79, 21, 61, 11, 70, 3, 1, 0, 5, 1, 'doesnot matter', '', 0, 'admin', '2020-11-16 10:19:34', 85, 'Other', 'Nothing', 'B+', NULL, '113', 0, NULL),
(54, 'BELL10059', '1996-04-01', 24, 99, 79, 21, 61, 11, 70, 3, 1, 0, 5, 1, 'doesnot matter', '', 0, 'admin', '2020-11-16 10:19:34', 85, 'Other', 'Nothing', 'B+', NULL, '113', 0, NULL),
(55, 'BELL10060', '1996-04-01', 24, 99, 79, 21, 61, 11, 70, 3, 1, 0, 5, 1, 'doesnot matter', '', 0, 'admin', '2020-11-16 10:19:35', 85, 'Other', 'Nothing', 'B+', NULL, '113', 0, NULL),
(56, 'BELL10061', '1996-04-01', 24, 99, 79, 21, 61, 11, 70, 3, 1, 0, 5, 1, 'doesnot matter', '', 0, 'admin', '2020-11-16 10:19:44', 85, 'Other', 'Nothing', 'B+', NULL, '113', 0, NULL),
(57, 'BELL10062', '1996-04-01', 24, 99, 79, 21, 61, 11, 70, 3, 1, 0, 5, 1, 'doesnot matter', '', 0, 'admin', '2020-11-16 10:24:26', 85, 'Other', 'Nothing', 'B+', NULL, '113', 0, NULL),
(58, 'BELL10063', '1996-04-01', 24, 99, 79, 21, 61, 11, 70, 3, 1, 0, 5, 1, 'doesnot matter', '', 0, 'admin', '2020-11-16 10:24:26', 85, 'Other', 'Nothing', 'B+', NULL, '113', 0, NULL),
(59, 'BELL10064', '1996-04-01', 24, 99, 79, 21, 61, 11, 70, 3, 1, 0, 5, 1, 'doesnot matter', '', 0, 'admin', '2020-11-16 10:24:27', 85, 'Other', 'Nothing', 'B+', NULL, '113', 0, NULL),
(60, 'BELL10065', '1996-04-01', 24, 99, 79, 21, 61, 11, 70, 3, 1, 0, 5, 1, 'doesnot matter', '', 0, 'admin', '2020-11-16 10:24:27', 85, 'Other', 'Nothing', 'B+', NULL, '113', 0, NULL),
(61, 'BELL10066', '1996-04-01', 24, 99, 79, 21, 61, 11, 70, 3, 1, 0, 5, 1, 'doesnot matter', 'hi', 0, 'admin', '2020-11-16 10:32:58', 85, 'Other', 'Nothing', 'B+', NULL, '113', 0, NULL),
(62, 'BELL10067', '1996-04-01', 24, 99, 79, 21, 61, 11, 70, 3, 1, 0, 5, 1, 'doesnot matter', 'hi', 0, 'admin', '2020-11-16 10:32:58', 85, 'Other', 'Nothing', 'B+', NULL, '113', 0, NULL),
(63, 'BELL10069', '1989-10-10', 34, 99, 67, 239, 61, 67, NULL, 9, 1, 23, 10, 0, 'self', 'Searching for traditional family girl ', 0, 'BELL10069', '2024-03-02 19:13:55', NULL, NULL, NULL, NULL, 'bell_glBELL100691709387035.jpg', NULL, 0, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `profile_charge`
--
CREATE TABLE `profile_charge` (
`id` int NOT NULL,
`charge` decimal(20,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
--
-- Dumping data for table `profile_charge`
--
INSERT INTO `profile_charge` (`id`, `charge`) VALUES
(1, 25.00);
-- --------------------------------------------------------
--
-- Table structure for table `profile_education`
--
CREATE TABLE `profile_education` (
`id` int NOT NULL,
`user_id` varchar(20) NOT NULL,
`edu_level` int NOT NULL,
`edu_field` int NOT NULL,
`annual_income` varchar(50) DEFAULT NULL,
`work_with` int DEFAULT NULL,
`work_as` int DEFAULT NULL,
`updated_by` varchar(20) NOT NULL,
`updated_on` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `profile_education`
--
INSERT INTO `profile_education` (`id`, `user_id`, `edu_level`, `edu_field`, `annual_income`, `work_with`, `work_as`, `updated_by`, `updated_on`) VALUES
(1, 'BELL001', 3, 266, '4', 1, 43, 'BELL001', '2017-11-22 11:11:59'),
(2, 'BELL10002', 2, 147, '2', 1, 58, 'admin', '2017-12-09 15:44:27'),
(3, 'BELL10003', 2, 147, '2', 1, 58, 'admin', '2017-12-09 15:50:58'),
(4, 'BELL10004', 1, 73, '3', 3, 58, 'admin', '2017-12-09 16:44:29'),
(5, 'BELL10005', 1, 7, '3', 1, 58, 'admin', '2017-12-16 13:07:34'),
(6, 'BELL10006', 1, 73, '3', 1, 55, 'BELL10006', '2017-12-19 03:12:53'),
(7, 'BELL10007', 2, 136, '', 5, 0, 'admin', '2018-03-05 12:25:31'),
(8, 'BELL10008', 2, 136, '', 0, 0, 'admin', '2018-03-05 12:09:21'),
(9, 'BELL10009', 2, 144, '', 0, 0, 'admin', '2018-03-05 12:26:03'),
(10, 'BELL10010', 1, 13, '', 0, 0, 'admin', '2018-03-05 12:26:30'),
(11, 'BELL10011', 1, 5, '', 0, 0, 'admin', '2018-03-05 12:24:36'),
(12, 'BELL10012', 2, 222, '', 0, 0, 'admin', '2018-03-05 12:34:53'),
(17, 'BELL10013', 1, 13, '2', 1, 55, 'admin', '2018-03-05 12:52:36'),
(18, 'BELL10018', 1, 6, '', 0, 0, 'admin', '2018-03-05 13:02:15'),
(19, 'BELL10019', 2, 144, '', 0, 0, 'admin', '2018-03-05 13:08:46'),
(20, 'BELL10020', 2, 222, '', 0, 0, 'admin', '2018-03-05 13:16:56'),
(21, 'BELL10021', 2, 127, '', 0, 0, 'admin', '2018-03-05 13:22:40'),
(22, 'BELL10022', 1, 13, '', 0, 0, 'admin', '2018-03-05 14:05:16'),
(23, 'BELL10023', 2, 222, '3', 1, 55, 'admin', '2018-03-05 14:13:46'),
(24, 'BELL10024', 1, 13, '', 0, 0, 'admin', '2018-03-05 14:21:48'),
(25, 'BELL10025', 2, 157, '4', 1, 51, 'admin', '2018-03-05 14:34:10'),
(26, 'BELL10026', 1, 13, '3', 0, 0, 'admin', '2018-03-05 14:41:25'),
(27, 'BELL10027', 2, 144, '', 0, 0, 'admin', '2018-03-05 14:49:35'),
(28, 'BELL10028', 1, 13, '3', 0, 55, 'admin', '2018-03-05 14:55:13'),
(29, 'BELL10029', 2, 146, '4', 0, 55, 'admin', '2018-03-05 15:01:32'),
(30, 'BELL10030', 1, 13, '4', 1, 55, 'admin', '2018-03-05 15:06:59'),
(31, 'BELL10031', 1, 13, '3', 1, 55, 'admin', '2018-03-05 15:13:17'),
(32, 'BELL10032', 1, 13, '4', 0, 55, 'admin', '2018-03-05 15:20:24'),
(33, 'BELL10033', 2, 136, '3', 1, 8, 'admin', '2018-03-05 15:27:30'),
(34, 'BELL10034', 10, 358, '', 0, 77, 'admin', '2018-03-05 15:44:25'),
(35, 'BELL10035', 2, 146, '3', 1, 55, 'admin', '2018-03-05 15:52:50'),
(36, 'BELL10036', 1, 5, '2', 1, 6, 'admin', '2018-03-05 15:58:25'),
(37, 'BELL10037', 1, 5, '2', 1, 76, 'admin', '2018-03-05 16:04:51'),
(38, 'BELL10038', 1, 13, '2', 1, 51, 'admin', '2018-03-05 16:12:12'),
(39, 'BELL10039', 1, 13, '4', 1, 55, 'admin', '2018-03-05 16:17:36'),
(40, 'BELL10040', 2, 136, '3', 0, 1, 'admin', '2018-03-05 17:07:41'),
(41, 'BELL10041', 2, 136, '4', 1, 55, 'admin', '2018-03-05 17:07:01'),
(42, 'BELL10042', 2, 136, '3', 1, 8, 'admin', '2018-03-05 17:13:10'),
(43, 'BELL10043', 2, 136, '3', 1, 7, 'admin', '2018-03-05 17:18:27'),
(44, 'BELL10044', 2, 136, '4', 1, 55, 'admin', '2018-03-05 17:24:22'),
(45, 'BELL10045', 1, 13, '4', 1, 58, 'admin', '2018-03-05 17:32:10'),
(46, 'BELL10046', 2, 239, '4', 1, 58, 'admin', '2018-03-05 17:38:47'),
(47, 'BELL10047', 1, 13, '5', 1, 0, 'admin', '2018-03-05 17:47:35'),
(48, 'BELL10049', 2, 127, '3', 3, 4, 'BELL10049', '2019-05-15 10:05:36'),
(49, 'BELL10050', 1, 13, '', 0, 55, 'admin', '2020-11-16 10:14:31'),
(50, 'BELL10051', 1, 13, '', 0, 55, 'admin', '2020-11-16 10:14:32'),
(51, 'BELL10052', 1, 13, '', 0, 55, 'admin', '2020-11-16 10:14:43'),
(52, 'BELL10053', 1, 13, '', 0, 55, 'admin', '2020-11-16 10:14:44'),
(53, 'BELL10054', 1, 13, '', 0, 55, 'admin', '2020-11-16 10:14:44'),
(54, 'BELL10055', 1, 13, '', 0, 55, 'admin', '2020-11-16 10:14:44'),
(55, 'BELL10056', 1, 13, '', 0, 55, 'admin', '2020-11-16 10:14:54'),
(56, 'BELL10057', 1, 13, '', 0, 55, 'admin', '2020-11-16 10:19:34'),
(57, 'BELL10058', 1, 13, '', 0, 55, 'admin', '2020-11-16 10:19:34'),
(58, 'BELL10059', 1, 13, '', 0, 55, 'admin', '2020-11-16 10:19:34'),
(59, 'BELL10060', 1, 13, '', 0, 55, 'admin', '2020-11-16 10:19:35'),
(60, 'BELL10061', 1, 13, '', 0, 55, 'admin', '2020-11-16 10:19:44'),
(61, 'BELL10062', 1, 13, '', 0, 55, 'admin', '2020-11-16 10:24:26'),
(62, 'BELL10063', 1, 13, '', 0, 55, 'admin', '2020-11-16 10:24:26'),
(63, 'BELL10064', 1, 13, '', 0, 55, 'admin', '2020-11-16 10:24:27'),
(64, 'BELL10065', 1, 13, '', 0, 55, 'admin', '2020-11-16 10:24:27'),
(65, 'BELL10066', 1, 13, '', 0, 55, 'admin', '2020-11-16 10:32:58'),
(66, 'BELL10067', 1, 13, '', 0, 55, 'admin', '2020-11-16 10:32:58'),
(67, 'BELL10069', 1, 5, '3', 2, 7, 'BELL10069', '2024-03-02 07:03:27');
-- --------------------------------------------------------
--
-- Table structure for table `profile_family`
--
CREATE TABLE `profile_family` (
`id` int NOT NULL,
`user_id` varchar(20) NOT NULL,
`father_name` varchar(150) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
`father_occupation` varchar(150) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
`mother_name` varchar(150) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
`mother_occupation` varchar(150) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
`brothers` int DEFAULT NULL,
`brothers_married` int DEFAULT NULL,
`brothers_unmarried` int DEFAULT NULL,
`sisters` int DEFAULT NULL,
`sisters_married` int DEFAULT NULL,
`sisters_unmarried` int DEFAULT NULL,
`family_type` int DEFAULT NULL,
`family_value` int DEFAULT NULL,
`affluence_level` int DEFAULT NULL,
`updated_by` varchar(20) NOT NULL,
`updated_on` datetime NOT NULL,
`father_status` varchar(50) DEFAULT NULL,
`work_with` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`mother_work_with` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`mother_status` varchar(50) DEFAULT NULL,
`location` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`native_place` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `profile_family`
--
INSERT INTO `profile_family` (`id`, `user_id`, `father_name`, `father_occupation`, `mother_name`, `mother_occupation`, `brothers`, `brothers_married`, `brothers_unmarried`, `sisters`, `sisters_married`, `sisters_unmarried`, `family_type`, `family_value`, `affluence_level`, `updated_by`, `updated_on`, `father_status`, `work_with`, `mother_work_with`, `mother_status`, `location`, `native_place`) VALUES
(1, 'BELL001', 'Gopal', 'Rtd. Teacher', 'Gnanasoundary', 'Rtd Teacher', NULL, 0, 0, NULL, 1, 0, 0, 0, 0, 'BELL001', '2017-11-22 01:11:50', NULL, NULL, NULL, NULL, NULL, NULL),
(2, 'BELL10002', 'முத்து குமார்', 'பல் மருத்துவர்', 'ரோகினி', 'இல்லத்தரசி', NULL, 0, 1, NULL, 0, 1, 2, 1, 3, 'admin', '2017-12-09 15:44:27', 'Employed', 'மகிழ்ச்சி கிளினிக்', '', 'Not Employed', 'மதுரை ', 'மதுரை '),
(3, 'BELL10003', 'முத்து குமார்', 'பல் மருத்துவர்', 'ரோகினி', 'இல்லத்தரசி', NULL, 0, 1, NULL, 0, 1, 2, 1, 3, 'admin', '2017-12-09 15:50:58', 'Employed', 'மகிழ்ச்சி கிளினிக்', '', 'Not Employed', 'மதுரை ', 'மதுரை '),
(4, 'BELL10004', 'ராமர்', 'மேற்பார்வையாளர்', 'நல்லம்மாள்', 'இல்லத்தரசி', NULL, 0, 1, NULL, 1, 0, 2, 1, 3, 'admin', '2017-12-09 16:44:29', 'Employed', 'தனியார் நிறுவனம்', '', 'Not Employed', 'பூதிப்புரம்', 'பூதிப்புரம் '),
(5, 'BELL10005', 'நாகேந்திரன்', '', 'காளியம்மாள்', '', NULL, 0, 0, NULL, 1, 1, 1, 1, 3, 'admin', '2017-12-16 13:07:34', 'Employed', 'அரசு ', '', 'Employed', 'ஜோதிமாணிக்கம்', 'ஜோதிமாணிக்கம்'),
(6, 'BELL10006', 'Otchu', 'Business', 'Kalai Selvi', 'House Wide', NULL, 1, 0, NULL, 0, 1, 1, 1, 3, 'BELL10006', '2017-12-19 03:12:07', NULL, NULL, NULL, NULL, NULL, NULL),
(7, 'BELL10007', 'சாந்தகுமார்', '', 'கோமதி', '', NULL, 0, 3, NULL, 0, 0, 1, 2, 3, 'admin', '2018-03-05 12:25:31', 'Passed Away', '', '', 'Not Employed', '', ''),
(8, 'BELL10008', 'மதிவாணன்', '', 'முத்து', '', NULL, 0, 1, NULL, 0, 0, 0, 2, 3, 'admin', '2018-03-05 12:09:21', '', '', '', '', 'திருநெல்வேலி ', 'திருநெல்வேலி '),
(9, 'BELL10009', 'பிச்சை', '', 'தனிக்கொடி', '', NULL, 0, 0, NULL, 0, 0, 1, 0, 0, 'admin', '2018-03-05 12:26:03', '', '', '', '', 'சிவகங்கை ', ''),
(10, 'BELL10010', 'ராஜேந்திரன்', '', 'ரேணுகாதேவி', '', NULL, 0, 0, NULL, 0, 0, 0, 0, 0, 'admin', '2018-03-05 12:26:30', '', '', '', '', 'திருச்சி ', ''),
(11, 'BELL10011', 'மாரியப்பன்', '', 'லீலாவதி', '', NULL, 0, 1, NULL, 1, 0, 1, 2, 3, 'admin', '2018-03-05 12:24:36', '', '', '', '', 'தேனி', 'தேனி '),
(12, 'BELL10012', 'ராஜன்', '', 'ஜமுனா', '', NULL, 0, 1, NULL, 0, 0, 1, 2, 0, 'admin', '2018-03-05 12:34:53', 'Passed Away', '', '', '', 'தஞ்சை', 'கும்பகோணம் '),
(17, 'BELL10013', 'ராதாகிருஷ்ணன்', '', 'விஜயா', '', NULL, 1, 1, NULL, 0, 0, 0, 0, 0, 'admin', '2018-03-05 12:52:36', '', '', '', '', 'சென்னை ', 'நெய்வேலி '),
(18, 'BELL10018', 'நாகராஜன்', '', 'ராஜலக்ஷ்மி', '', NULL, 0, 1, NULL, 0, 0, 1, 2, 0, 'admin', '2018-03-05 13:02:15', '', '', '', '', 'மதுரை ', 'காரியாபட்டி '),
(19, 'BELL10019', 'கண்ணன்', '', 'மல்லிகா', '', NULL, 0, 1, NULL, 0, 1, 1, 2, 2, 'admin', '2018-03-05 13:08:46', '', '', '', '', 'மதுரை ', 'மதுரை '),
(20, 'BELL10020', 'ஆனந்த்', '', 'உமாராணி', '', NULL, 1, 0, NULL, 0, 0, 1, 1, 2, 'admin', '2018-03-05 13:16:56', '', '', '', '', 'மதுரை', 'மதுரை '),
(21, 'BELL10021', 'குருசாமி', '', 'கமலாராணி', '', NULL, 0, 0, NULL, 0, 0, 1, 1, 3, 'admin', '2018-03-05 13:22:40', '', '', '', '', 'மதுரை ', 'மதுரை '),
(22, 'BELL10022', 'ரவி', '', 'சாந்தி', '', NULL, 0, 1, NULL, 0, 0, 1, 0, 0, 'admin', '2018-03-05 14:05:16', '', '', '', '', 'மதுரை', 'மதுரை '),
(23, 'BELL10023', 'சந்திரபாபு', '', 'உமாதேவி', '', NULL, 0, 1, NULL, 0, 0, 1, 2, 0, 'admin', '2018-03-05 14:13:46', '', '', '', '', 'கோவை ', 'கோவை '),
(24, 'BELL10024', 'ரமேஷ்', '', 'Kala', '', NULL, 0, 0, NULL, 1, 0, 1, 1, 0, 'admin', '2018-03-05 14:21:48', '', '', '', '', 'மதுரை ', 'திருநெல்வேலி '),
(25, 'BELL10025', 'ஜீவானந்தம்', '', 'வேலம்மாள்', '', NULL, 0, 0, NULL, 2, 0, 1, 2, 0, 'admin', '2018-03-05 14:34:10', '', '', '', '', 'பாளையங்கோட்டை ', 'பாளையங்கோட்டை '),
(26, 'BELL10026', 'ஞானவேல்', '', 'ரேணுகாதேவி', '', NULL, 1, 0, NULL, 1, 0, 1, 1, 0, 'admin', '2018-03-05 14:41:25', '', '', '', '', 'மதுரை', 'மதுரை '),
(27, 'BELL10027', 'ராமன்', '', 'கீதா', '', NULL, 0, 0, NULL, 1, 1, 1, 1, 3, 'admin', '2018-03-05 14:49:35', '', '', '', '', 'மதுரை ', 'மதுரை '),
(28, 'BELL10028', 'கோபாலகிருஷ்ணன்', '', 'கோமதி', '', NULL, 0, 1, NULL, 0, 0, 0, 0, 0, 'admin', '2018-03-05 14:55:13', '', '', '', '', 'காரியாபட்டி ', 'காரியாபட்டி '),
(29, 'BELL10029', 'கோவிந்தராஜன்', '', 'கனகவல்லி', '', NULL, 0, 1, NULL, 0, 0, 0, 0, 0, 'admin', '2018-03-05 15:01:32', '', '', '', '', 'தஞ்சாவூர் ', 'தஞ்சாவூர் '),
(30, 'BELL10030', 'பாஸ்கரன்', '', 'தனலட்சுமி', '', NULL, 1, 0, NULL, 1, 0, 1, 2, 3, 'admin', '2018-03-05 15:06:59', '', '', '', '', 'மதுரை', 'மதுரை '),
(31, 'BELL10031', 'செல்வராஜ்', '', 'ஜெகதா', '', NULL, 0, 0, NULL, 1, 0, 1, 1, 3, 'admin', '2018-03-05 15:13:17', '', '', '', '', 'மதுரை ', 'மதுரை '),
(32, 'BELL10032', 'பாலசுப்ரமணியன்', '', 'மனோரஞ்சிதம்', '', NULL, 1, 0, NULL, 0, 0, 1, 1, 3, 'admin', '2018-03-05 15:20:24', '', '', '', '', 'திருச்சி ', 'திருச்சி '),
(33, 'BELL10033', 'ராமசாமி', '', 'அமுதா', '', NULL, 0, 0, NULL, 1, 0, 1, 2, 3, 'admin', '2018-03-05 15:27:30', '', '', '', '', 'மதுரை ', 'மதுரை '),
(34, 'BELL10034', 'மாணிக்கவேல்', '', 'குணசுந்தரி', '', NULL, 0, 1, NULL, 1, 0, 1, 2, 3, 'admin', '2018-03-05 15:44:25', 'Passed Away', '', '', '', 'மதுரை ', 'பாளையம்பட்டி '),
(35, 'BELL10035', 'ராமசாமி', '', 'சாரதாமணி', '', NULL, 1, 0, NULL, 0, 0, 0, 2, 3, 'admin', '2018-03-05 15:52:50', '', '', '', '', 'மதுரை ', 'கோவில்பட்டி '),
(36, 'BELL10036', 'முருகேசன்', '', 'சித்ராதேவி', '', NULL, 0, 0, NULL, 0, 0, 1, 2, 3, 'admin', '2018-03-05 15:58:25', 'Passed Away', '', '', '', 'மதுரை ', 'கூடக்கோவில் '),
(37, 'BELL10037', 'ராஜேந்திரன்', '', 'ராணி', '', NULL, 0, 0, NULL, 1, 0, 1, 2, 3, 'admin', '2018-03-05 16:04:51', '', '', '', '', 'மதுரை ', 'ராம்நாட்'),
(38, 'BELL10038', 'பால்ராஜ்', '', 'தனலட்சுமி', '', NULL, 0, 1, NULL, 1, 0, 1, 2, 3, 'admin', '2018-03-05 16:12:12', '', '', '', '', 'மதுரை ', 'ராஜபாளையம் '),
(39, 'BELL10039', 'காளிமுத்து', '', 'தமிழ்செல்வி', '', NULL, 0, 0, NULL, 1, 0, 1, 2, 3, 'admin', '2018-03-05 16:17:36', '', '', '', '', 'கேளையாபிள்ளையூர் ', 'திருநெல்வேலி '),
(40, 'BELL10040', 'மெய்யப்பன்', '', 'தனலட்சுமி', '', NULL, 0, 0, NULL, 1, 0, 1, 2, 0, 'admin', '2018-03-05 17:07:41', '', '', '', '', 'காரைக்குடி ', 'காரைக்குடி '),
(41, 'BELL10041', 'சுடலையாண்டி', '', 'நாகம்மாள்', '', NULL, 0, 0, NULL, 0, 0, 1, 2, 3, 'admin', '2018-03-05 17:07:01', '', '', '', '', 'சென்னை ', 'திருநெல்வேலி '),
(42, 'BELL10042', 'பார்த்தசாரதி', '', 'பவானி', '', NULL, 0, 0, NULL, 2, 0, 0, 2, 3, 'admin', '2018-03-05 17:13:10', '', '', '', '', 'மதுரை', 'மதுரை '),
(43, 'BELL10043', 'பாண்டியன்', '', 'சரஸ்வதி', '', NULL, 0, 1, NULL, 2, 0, 1, 0, 0, 'admin', '2018-03-05 17:18:27', '', '', '', '', 'மதுரை', 'மதுரை'),
(44, 'BELL10044', 'தியாகராஜன்', '', 'ராஜேஸ்வரி', '', NULL, 0, 1, NULL, 1, 0, 0, 0, 0, 'admin', '2018-03-05 17:24:22', '', '', '', '', 'மதுரை', 'மேலூர் '),
(45, 'BELL10045', 'கணேசன்', '', 'கிரகலட்சுமி', '', NULL, 0, 1, NULL, 0, 0, 1, 2, 3, 'admin', '2018-03-05 17:32:10', '', '', '', '', 'விழுப்புரம் ', 'சிவகாசி '),
(46, 'BELL10046', 'உதயகுமார்', '', 'தமிழ்செல்வி', '', NULL, 1, 0, NULL, 0, 0, 0, 0, 0, 'admin', '2018-03-05 17:38:47', '', '', '', '', 'சென்னை ', 'சென்னை '),
(47, 'BELL10047', 'பட்டவராயன்', '', 'ராஜலெட்சுமி', '', NULL, 0, 0, NULL, 1, 0, 1, 0, 2, 'admin', '2018-03-05 17:47:35', '', '', '', '', 'திருச்செந்தூர் ', 'திருச்செந்தூர் '),
(48, 'BELL10049', 'Ramu', 'Retired doctor', 'Ananthammal', 'House Wife', NULL, 0, 1, NULL, 1, 0, 2, 1, 2, 'BELL10049', '2019-05-15 10:05:21', NULL, NULL, NULL, NULL, NULL, NULL),
(49, 'BELL10050', 'Palpandi', 'SI', 'Devakani', 'Home maker', NULL, 0, 0, NULL, 0, 0, 0, 0, 0, 'admin', '2020-11-16 10:14:31', '', '', '', '', 'Madurai', ''),
(50, 'BELL10051', 'Palpandi', 'SI', 'Devakani', 'Home maker', NULL, 0, 0, NULL, 0, 0, 0, 0, 0, 'admin', '2020-11-16 10:14:32', '', '', '', '', 'Madurai', ''),
(51, 'BELL10052', 'Palpandi', 'SI', 'Devakani', 'Home maker', NULL, 0, 0, NULL, 0, 0, 0, 0, 0, 'admin', '2020-11-16 10:14:43', '', '', '', '', 'Madurai', ''),
(52, 'BELL10053', 'Palpandi', 'SI', 'Devakani', 'Home maker', NULL, 0, 0, NULL, 0, 0, 0, 0, 0, 'admin', '2020-11-16 10:14:44', '', '', '', '', 'Madurai', ''),
(53, 'BELL10054', 'Palpandi', 'SI', 'Devakani', 'Home maker', NULL, 0, 0, NULL, 0, 0, 0, 0, 0, 'admin', '2020-11-16 10:14:44', '', '', '', '', 'Madurai', ''),
(54, 'BELL10055', 'Palpandi', 'SI', 'Devakani', 'Home maker', NULL, 0, 0, NULL, 0, 0, 0, 0, 0, 'admin', '2020-11-16 10:14:44', '', '', '', '', 'Madurai', ''),
(55, 'BELL10056', 'Palpandi', 'SI', 'Devakani', 'Home maker', NULL, 0, 0, NULL, 0, 0, 0, 0, 0, 'admin', '2020-11-16 10:14:54', '', '', '', '', 'Madurai', ''),
(56, 'BELL10057', 'Palpandi', 'SI', 'Devakani', 'Home maker', NULL, 0, 0, NULL, 0, 0, 0, 0, 0, 'admin', '2020-11-16 10:19:34', '', '', '', '', 'Madurai', ''),
(57, 'BELL10058', 'Palpandi', 'SI', 'Devakani', 'Home maker', NULL, 0, 0, NULL, 0, 0, 0, 0, 0, 'admin', '2020-11-16 10:19:34', '', '', '', '', 'Madurai', ''),
(58, 'BELL10059', 'Palpandi', 'SI', 'Devakani', 'Home maker', NULL, 0, 0, NULL, 0, 0, 0, 0, 0, 'admin', '2020-11-16 10:19:34', '', '', '', '', 'Madurai', ''),
(59, 'BELL10060', 'Palpandi', 'SI', 'Devakani', 'Home maker', NULL, 0, 0, NULL, 0, 0, 0, 0, 0, 'admin', '2020-11-16 10:19:35', '', '', '', '', 'Madurai', ''),
(60, 'BELL10061', 'Palpandi', 'SI', 'Devakani', 'Home maker', NULL, 0, 0, NULL, 0, 0, 0, 0, 0, 'admin', '2020-11-16 10:19:44', '', '', '', '', 'Madurai', ''),
(61, 'BELL10062', 'Palpandi', 'SI', 'Devakani', 'Home maker', NULL, 0, 0, NULL, 0, 0, 0, 0, 0, 'admin', '2020-11-16 10:24:26', '', '', '', '', 'Madurai', ''),
(62, 'BELL10063', 'Palpandi', 'SI', 'Devakani', 'Home maker', NULL, 0, 0, NULL, 0, 0, 0, 0, 0, 'admin', '2020-11-16 10:24:26', '', '', '', '', 'Madurai', ''),
(63, 'BELL10064', 'Palpandi', 'SI', 'Devakani', 'Home maker', NULL, 0, 0, NULL, 0, 0, 0, 0, 0, 'admin', '2020-11-16 10:24:27', '', '', '', '', 'Madurai', ''),
(64, 'BELL10065', 'Palpandi', 'SI', 'Devakani', 'Home maker', NULL, 0, 0, NULL, 0, 0, 0, 0, 0, 'admin', '2020-11-16 10:24:27', '', '', '', '', 'Madurai', ''),
(65, 'BELL10066', 'Palpandi', 'SI', 'Devakani', 'Home maker', NULL, 0, 0, NULL, 0, 0, 0, 0, 0, 'admin', '2020-11-16 10:32:58', '', '', '', '', 'Madurai', ''),
(66, 'BELL10067', 'Palpandi', 'SI', 'Devakani', 'Home maker', NULL, 0, 0, NULL, 0, 0, 0, 0, 0, 'admin', '2020-11-16 10:32:58', '', '', '', '', 'Madurai', ''),
(67, 'BELL10069', 'Sundar Raj', 'Retired', 'Kalavathi', 'Passed away', NULL, 0, 0, NULL, 1, 1, 1, 1, 3, 'BELL10069', '2024-03-02 07:03:56', NULL, NULL, NULL, NULL, NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `profile_lifestyle`
--
CREATE TABLE `profile_lifestyle` (
`id` int NOT NULL,
`user_id` varchar(20) NOT NULL,
`diet` varchar(20) DEFAULT NULL,
`smoke` varchar(20) NOT NULL,
`drink` varchar(20) NOT NULL,
`height` int NOT NULL,
`body_type` varchar(20) DEFAULT NULL,
`skin_tone` varchar(20) DEFAULT NULL,
`updated_by` varchar(20) NOT NULL,
`updated_on` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `profile_lifestyle`
--
INSERT INTO `profile_lifestyle` (`id`, `user_id`, `diet`, `smoke`, `drink`, `height`, `body_type`, `skin_tone`, `updated_by`, `updated_on`) VALUES
(1, 'BELL001', '2', 'No', 'No', 175, 'Slim', 'Very Fair', 'BELL001', '2017-11-22 11:11:34'),
(2, 'BELL10002', '3', 'No', 'No', 160, 'Slim', 'Very Fair', 'admin', '2017-12-09 15:44:27'),
(3, 'BELL10003', '3', 'No', 'No', 160, 'Slim', 'Very Fair', 'admin', '2017-12-09 15:50:58'),
(4, 'BELL10004', '3', 'No', 'No', 172, 'Average', 'Fair', 'admin', '2017-12-09 16:44:29'),
(5, 'BELL10005', '3', 'No', 'No', 165, 'Average', 'Fair', 'admin', '2017-12-16 13:07:34'),
(6, 'BELL10006', '3', 'No', 'No', 160, 'Average', 'Wheatish', 'BELL10006', '2018-01-26 13:58:36'),
(7, 'BELL10007', '', 'No', 'No', 160, 'Average', 'Fair', 'admin', '2018-03-05 12:25:31'),
(8, 'BELL10008', '', 'No', 'No', 160, 'Average', 'Very Fair', 'admin', '2018-03-05 12:09:21'),
(9, 'BELL10009', '', 'No', 'No', 152, 'Average', 'Wheatish', 'admin', '2018-03-05 12:26:03'),
(10, 'BELL10010', '', 'No', 'No', 152, 'Average', 'Fair', 'admin', '2018-03-05 12:26:30'),
(11, 'BELL10011', '', 'No', 'No', 152, 'Average', 'Wheatish', 'admin', '2018-03-05 12:24:36'),
(12, 'BELL10012', '', 'No', 'No', 157, 'Average', 'Fair', 'admin', '2018-03-05 12:34:53'),
(17, 'BELL10013', '', 'No', 'No', 162, 'Average', 'Very Fair', 'admin', '2018-03-05 12:52:36'),
(18, 'BELL10018', '', 'No', 'No', 152, 'Average', 'Very Fair', 'admin', '2018-03-05 13:02:15'),
(19, 'BELL10019', '', 'No', 'No', 152, 'Average', 'Very Fair', 'admin', '2018-03-05 13:08:46'),
(20, 'BELL10020', '', 'No', 'No', 152, 'Average', 'Fair', 'admin', '2018-03-05 13:16:56'),
(21, 'BELL10021', '', 'No', 'No', 152, 'Average', 'Fair', 'admin', '2018-03-05 13:22:40'),
(22, 'BELL10022', '2', 'No', 'No', 152, 'Average', 'Very Fair', 'admin', '2018-03-05 14:05:16'),
(23, 'BELL10023', '', 'No', 'No', 165, 'Average', 'Very Fair', 'admin', '2018-03-05 14:13:46'),
(24, 'BELL10024', '', 'No', 'No', 167, 'Average', 'Fair', 'admin', '2018-03-05 14:21:48'),
(25, 'BELL10025', '', 'No', 'No', 177, 'Average', 'Very Fair', 'admin', '2018-03-05 14:34:10'),
(26, 'BELL10026', '', 'No', 'No', 177, 'Average', 'Very Fair', 'admin', '2018-03-05 14:41:25'),
(27, 'BELL10027', '', 'No', 'No', 152, 'Average', 'Fair', 'admin', '2018-03-05 14:49:35'),
(28, 'BELL10028', '', 'No', 'No', 165, NULL, 'Very Fair', 'admin', '2018-03-05 14:55:13'),
(29, 'BELL10029', '', 'No', 'No', 172, 'Average', 'Very Fair', 'admin', '2018-03-05 15:01:32'),
(30, 'BELL10030', '', 'No', 'No', 177, 'Average', 'Very Fair', 'admin', '2018-03-05 15:06:59'),
(31, 'BELL10031', '', 'No', 'No', 182, 'Average', 'Very Fair', 'admin', '2018-03-05 15:13:17'),
(32, 'BELL10032', '', 'No', 'No', 165, 'Average', 'Very Fair', 'admin', '2018-03-05 15:20:24'),
(33, 'BELL10033', '', 'No', 'No', 152, 'Average', 'Very Fair', 'admin', '2018-03-05 15:27:30'),
(34, 'BELL10034', '', 'No', 'No', 180, 'Average', 'Wheatish', 'admin', '2018-03-05 15:44:25'),
(35, 'BELL10035', '', 'No', 'No', 152, 'Average', 'Very Fair', 'admin', '2018-03-05 15:52:50'),
(36, 'BELL10036', '', 'No', 'No', 180, 'Average', 'Fair', 'admin', '2018-03-05 15:58:25'),
(37, 'BELL10037', '', 'No', 'No', 177, 'Average', 'Very Fair', 'admin', '2018-03-05 16:04:51'),
(38, 'BELL10038', '', 'No', 'No', 165, 'Average', 'Wheatish', 'admin', '2018-03-05 16:12:12'),
(39, 'BELL10039', '', 'No', 'No', 152, 'Average', 'Fair', 'admin', '2018-03-05 16:17:36'),
(40, 'BELL10040', '', 'No', 'No', 152, 'Average', 'Very Fair', 'admin', '2018-03-05 17:07:41'),
(41, 'BELL10041', '', 'No', 'No', 177, 'Average', 'Fair', 'admin', '2018-03-05 17:07:01'),
(42, 'BELL10042', '2', 'No', 'No', 182, 'Average', 'Very Fair', 'admin', '2018-03-05 17:13:10'),
(43, 'BELL10043', '', 'No', 'No', 180, 'Average', 'Fair', 'admin', '2018-03-05 17:18:27'),
(44, 'BELL10044', '', 'No', 'No', 177, 'Average', 'Fair', 'admin', '2018-03-05 17:24:22'),
(45, 'BELL10045', '', 'No', 'No', 177, 'Average', 'Wheatish', 'admin', '2018-03-05 17:32:10'),
(46, 'BELL10046', '2', 'No', 'No', 182, 'Average', 'Very Fair', 'admin', '2018-03-05 17:38:47'),
(47, 'BELL10047', '', 'No', 'No', 172, 'Average', 'Fair', 'admin', '2018-03-05 17:47:35'),
(48, 'BELL10049', '2', 'No', 'No', 142, 'Average', 'Fair', 'BELL10049', '2019-05-15 10:05:02'),
(49, 'BELL10050', '', 'Occasionaly', 'Yes', 160, 'Heavy', 'Dark', 'admin', '2020-11-16 10:14:31'),
(50, 'BELL10051', '', 'Occasionaly', 'Yes', 160, 'Heavy', 'Dark', 'admin', '2020-11-16 10:14:32'),
(51, 'BELL10052', '', 'Occasionaly', 'Yes', 160, 'Heavy', 'Dark', 'admin', '2020-11-16 10:14:43'),
(52, 'BELL10053', '', 'Occasionaly', 'Yes', 160, 'Heavy', 'Dark', 'admin', '2020-11-16 10:14:44'),
(53, 'BELL10054', '', 'Occasionaly', 'Yes', 160, 'Heavy', 'Dark', 'admin', '2020-11-16 10:14:44'),
(54, 'BELL10055', '', 'Occasionaly', 'Yes', 160, 'Heavy', 'Dark', 'admin', '2020-11-16 10:14:44'),
(55, 'BELL10056', '', 'Occasionaly', 'Yes', 160, 'Heavy', 'Dark', 'admin', '2020-11-16 10:14:54'),
(56, 'BELL10057', '', 'Occasionaly', 'Yes', 160, 'Heavy', 'Dark', 'admin', '2020-11-16 10:19:34'),
(57, 'BELL10058', '', 'Occasionaly', 'Yes', 160, 'Heavy', 'Dark', 'admin', '2020-11-16 10:19:34'),
(58, 'BELL10059', '', 'Occasionaly', 'Yes', 160, 'Heavy', 'Dark', 'admin', '2020-11-16 10:19:34'),
(59, 'BELL10060', '', 'Occasionaly', 'Yes', 160, 'Heavy', 'Dark', 'admin', '2020-11-16 10:19:35'),
(60, 'BELL10061', '', 'Occasionaly', 'Yes', 160, 'Heavy', 'Dark', 'admin', '2020-11-16 10:19:44'),
(61, 'BELL10062', '', 'Occasionaly', 'Yes', 160, 'Heavy', 'Dark', 'admin', '2020-11-16 10:24:26'),
(62, 'BELL10063', '', 'Occasionaly', 'Yes', 160, 'Heavy', 'Dark', 'admin', '2020-11-16 10:24:26'),
(63, 'BELL10064', '', 'Occasionaly', 'Yes', 160, 'Heavy', 'Dark', 'admin', '2020-11-16 10:24:27'),
(64, 'BELL10065', '', 'Occasionaly', 'Yes', 160, 'Heavy', 'Dark', 'admin', '2020-11-16 10:24:27'),
(65, 'BELL10066', '', 'Occasionaly', 'Yes', 160, 'Heavy', 'Dark', 'admin', '2020-11-16 10:32:58'),
(66, 'BELL10067', '', 'Occasionaly', 'Yes', 160, 'Heavy', 'Dark', 'admin', '2020-11-16 10:32:58'),
(67, 'BELL10069', '4', 'No', 'No', 175, 'Slim', 'Fair', 'BELL10069', '2024-03-02 07:03:52');
-- --------------------------------------------------------
--
-- Table structure for table `profile_printing`
--
CREATE TABLE `profile_printing` (
`id` int NOT NULL,
`user_id` varchar(25) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
`profile_print_id` varchar(25) NOT NULL,
`created_on` datetime NOT NULL,
`user_type` tinyint(1) NOT NULL COMMENT '1-normal user 2-guest user',
`total_amount` decimal(20,2) NOT NULL,
`paid_amount` decimal(20,2) NOT NULL,
`paid_by` varchar(15) NOT NULL COMMENT 'admin-super_admin, value- branch_id'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
--
-- Dumping data for table `profile_printing`
--
INSERT INTO `profile_printing` (`id`, `user_id`, `profile_print_id`, `created_on`, `user_type`, `total_amount`, `paid_amount`, `paid_by`) VALUES
(10, 'BELL10003', 'BELL10004', '2017-12-09 17:06:24', 1, 2000.00, 2000.00, 'admin'),
(11, 'BELL10005', 'BELL10004', '2017-12-16 13:12:47', 1, 2000.00, 2000.00, '7'),
(12, 'BELL10005', 'BELL10005', '2017-12-18 13:15:50', 1, 2000.00, 2000.00, '7'),
(13, '001', 'BELL001', '2017-12-19 12:56:13', 2, 2000.00, 2000.00, '6'),
(14, '005', 'BELL10004', '2017-12-19 12:58:42', 2, 2000.00, 2000.00, '6'),
(15, '006', 'BELL001', '2017-12-19 13:03:24', 2, 2000.00, 2000.00, '6'),
(16, '007', 'BELL001', '2017-12-19 13:05:51', 2, 2000.00, 2000.00, '6'),
(17, '008', 'BELL10004', '2017-12-19 13:14:41', 2, 100.00, 100.00, 'admin'),
(18, '009', 'BELL10004', '2017-12-19 13:21:33', 2, 100.00, 100.00, '6'),
(19, '010', 'BELL10004', '2017-12-19 13:27:47', 2, 100.00, 100.00, '6'),
(20, 'BELL10004', 'BELL10004', '2017-12-19 13:28:18', 1, 100.00, 100.00, 'admin'),
(21, 'BELL10004', 'BELL10005', '2017-12-19 13:31:29', 1, 100.00, 100.00, '6'),
(22, 'BELL10004', 'BELL10003', '2017-12-19 13:33:03', 1, 100.00, 100.00, '6'),
(23, '011', 'BELL10003', '2017-12-19 13:36:22', 2, 100.00, 100.00, '6'),
(24, 'BELL001', 'BELL10006', '2017-12-21 18:05:28', 1, 100.00, 100.00, '6'),
(25, 'BELL001', 'BELL001', '2017-12-23 20:16:55', 1, 100.00, 100.00, '6'),
(26, 'BELL001', 'BELL10004', '2017-12-23 20:18:59', 1, 100.00, 100.00, '6');
-- --------------------------------------------------------
--
-- Table structure for table `rasi`
--
CREATE TABLE `rasi` (
`id` int NOT NULL,
`rasi` varchar(30) DEFAULT NULL,
`rasi_tamil` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `rasi`
--
INSERT INTO `rasi` (`id`, `rasi`, `rasi_tamil`) VALUES
(1, 'Aries', 'மேஷம்'),
(2, 'Taurus', 'ரிஷபம்'),
(3, 'Gemini', 'மிதுனம்'),
(4, 'Cancer', 'கடகம்'),
(5, 'Leo', 'சிம்மம்'),
(6, 'Virgo', 'கன்னி'),
(7, 'Libra', 'துலாம்'),
(8, 'Scorpio', 'விருச்சிகம்'),
(9, 'Sagittarius', 'தனுசு'),
(10, 'Capricorn', 'மகரம்'),
(11, 'Aquaries', 'கும்பம்'),
(12, 'Pisces', 'மீனம்');
-- --------------------------------------------------------
--
-- Table structure for table `rassi_moonsign`
--
CREATE TABLE `rassi_moonsign` (
`rassimoonsign_id` int NOT NULL,
`star_id` int NOT NULL,
`rassi_moonsign` varchar(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `rassi_moonsign`
--
INSERT INTO `rassi_moonsign` (`rassimoonsign_id`, `star_id`, `rassi_moonsign`) VALUES
(1, 1, 'Medam(Aries)'),
(6, 2, 'Edavam(Taurus)'),
(8, 3, 'Mithunam(Gemini)'),
(10, 4, 'mithunam(gemini)'),
(12, 5, 'karkitakam(cancer)'),
(14, 11, 'Chingam(Leo)'),
(15, 12, 'Kanni(Virgo)'),
(16, 12, 'Chingam(Leo)'),
(18, 14, 'Kanni(Virgo)'),
(19, 14, 'Thulam(Libra)'),
(23, 17, 'Vrischigam(Scorpio)'),
(27, 21, 'Dhanu(Sagittarius)'),
(31, 23, 'Makaram(Capricorn)'),
(33, 25, 'Kumbam(Aquarius)'),
(38, 28, 'Medam(Aries)');
-- --------------------------------------------------------
--
-- Table structure for table `religion`
--
CREATE TABLE `religion` (
`religion_id` bigint NOT NULL,
`religion` varchar(250) DEFAULT NULL,
`religion_tamil` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `religion`
--
INSERT INTO `religion` (`religion_id`, `religion`, `religion_tamil`) VALUES
(61, 'Hindu', 'இந்து'),
(3, 'Christian', 'கிறிஸ்தவம்'),
(51, 'Muslim', 'முஸ்லீம்'),
(57, 'sikism', 'சீக்கியம்');
-- --------------------------------------------------------
--
-- Table structure for table `settings`
--
CREATE TABLE `settings` (
`id` int NOT NULL,
`title` varchar(250) NOT NULL,
`religion` int NOT NULL,
`place` int NOT NULL,
`education` int NOT NULL,
`occupation` int NOT NULL,
`age` int NOT NULL,
`search_without_login` varchar(500) NOT NULL,
`smtp_username` varchar(250) NOT NULL,
`smtp_host` varchar(250) NOT NULL,
`smtp_password` varchar(250) NOT NULL,
`currency` varchar(500) NOT NULL,
`fav_icon` varchar(500) NOT NULL,
`image` varchar(500) NOT NULL,
`payment_gateway_username` varchar(500) NOT NULL,
`payment_gateway_password` varchar(500) NOT NULL,
`payment_gateway_signature` varchar(500) NOT NULL,
`payment_gateway_testmode` varchar(500) NOT NULL,
`user_id` varchar(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `settings`
--
INSERT INTO `settings` (`id`, `title`, `religion`, `place`, `education`, `occupation`, `age`, `search_without_login`, `smtp_username`, `smtp_host`, `smtp_password`, `currency`, `fav_icon`, `image`, `payment_gateway_username`, `payment_gateway_password`, `payment_gateway_signature`, `payment_gateway_testmode`, `user_id`) VALUES
(1, 'Bells Matrimony', 1, 1, 1, 1, 1, 'on', '', '', '', 'R$', 'assets/settingsimages/favicon.ico', 'assets/settingsimages/logo.png', 'shajeermhmmd-facilitator_api1.gmail.com', 'WLNW9ZAZ67R39Z7Y', 'AiPC9BjkCyDFQXbSkoZcgqH3hpacAeGlrg4u9bfsrQbjCcxnzFSrEZ0x', 'true', 'BELL');
-- --------------------------------------------------------
--
-- Table structure for table `star`
--
CREATE TABLE `star` (
`star_id` int NOT NULL,
`star` varchar(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `star`
--
INSERT INTO `star` (`star_id`, `star`) VALUES
(1, 'Aswathi'),
(2, 'Bharani'),
(3, 'Krithiga'),
(4, 'Rohini'),
(5, 'Makayiram'),
(6, 'Thiruvathira'),
(7, 'Punartham'),
(8, 'Pooyam'),
(9, 'Ayilyam'),
(10, 'Magam'),
(11, 'Pooram'),
(12, 'Uthram'),
(13, 'Atham'),
(14, 'Chithira'),
(15, 'Chothi'),
(16, 'Visakham'),
(17, 'Ketta'),
(18, 'Moolam'),
(19, 'Pooradam'),
(20, 'Uthiradam'),
(21, 'Thiruvonam'),
(22, 'Avittam'),
(23, 'Chadayam'),
(24, 'Pooruttathi'),
(25, 'Uthirattathi'),
(26, 'Revathi'),
(28, 'Bharani');
-- --------------------------------------------------------
--
-- Table structure for table `state`
--
CREATE TABLE `state` (
`state_id` int NOT NULL,
`country_id` int NOT NULL,
`state` varchar(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `state`
--
INSERT INTO `state` (`state_id`, `country_id`, `state`) VALUES
(58, 99, 'Andhra Pradesh'),
(59, 99, 'Arunachal Pradesh'),
(60, 99, 'Assam'),
(61, 99, 'Bihar'),
(62, 99, 'Goa'),
(63, 99, 'Gujarat'),
(64, 99, 'Haryana'),
(65, 99, 'Himachal Pradesh'),
(66, 99, 'Jammu & Kashmir'),
(67, 99, 'Karnataka'),
(68, 99, 'Kerala'),
(69, 99, 'Madhya Pradesh'),
(70, 99, 'Maharashtra'),
(71, 99, 'Manipur'),
(72, 99, 'Meghalaya'),
(73, 99, 'Mizoram'),
(74, 99, 'Nagaland'),
(75, 99, 'Orissa'),
(76, 99, 'Punjab'),
(77, 99, 'Rajasthan'),
(78, 99, 'Sikkim'),
(79, 99, 'Tamil Nadu'),
(80, 99, 'Tripura'),
(81, 99, 'Uttar Pradesh'),
(82, 99, 'West Bengal'),
(83, 99, 'Chhattisgarh'),
(84, 99, 'Uttarakhand'),
(85, 99, 'Jharkhand'),
(86, 99, 'Telangana'),
(87, 99, 'Delhi'),
(88, 99, 'Andaman & Nicobar Islands'),
(89, 99, 'Chandigarh'),
(90, 99, 'Dadra & Nagar Haveli'),
(91, 99, 'Daman & Diu'),
(92, 99, 'Lakshadweep'),
(93, 99, 'Puducherry');
-- --------------------------------------------------------
--
-- Table structure for table `sub_caste`
--
CREATE TABLE `sub_caste` (
`id` int NOT NULL,
`caste_id` int NOT NULL,
`sub_caste` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `sub_caste`
--
INSERT INTO `sub_caste` (`id`, `caste_id`, `sub_caste`) VALUES
(1, 5, 'Anavil'),
(2, 5, 'Audichya'),
(3, 5, 'Baidhiki/Vaidhiki'),
(4, 5, 'Baj'),
(5, 5, 'Bardai'),
(6, 5, 'Barendra'),
(7, 5, 'Bhargav'),
(8, 5, 'Bhitra'),
(9, 5, 'Danua'),
(10, 5, 'Desai'),
(11, 5, 'Gaur'),
(12, 5, 'Halua'),
(13, 5, 'Jhadua'),
(14, 5, 'Khadawal'),
(15, 5, 'Khadayata'),
(16, 5, 'Khedaval'),
(17, 5, 'Mevada'),
(18, 5, 'Modh'),
(19, 5, 'Nagar'),
(20, 5, 'Panda'),
(21, 5, 'Rajgor'),
(22, 5, 'Rarhi/Radhi'),
(23, 5, 'Saraswat'),
(24, 5, 'Sarua'),
(25, 5, 'Shri Gaud'),
(26, 5, 'Shri Mali'),
(27, 5, 'Tapodhan'),
(28, 5, 'Valam'),
(29, 5, 'Zalora'),
(30, 7, 'Thenkalai'),
(31, 7, 'Venkalai'),
(32, 7, 'Others'),
(33, 8, 'Ashtasahasram'),
(34, 8, 'Brahacharnam'),
(35, 8, 'Vadama'),
(36, 8, 'Vathima'),
(37, 8, 'Others'),
(38, 10, '24 Manai Telugu Chettiar'),
(39, 10, '24 Manai Telugu Chettiar 16 Veedu'),
(40, 10, '24 Manai Telugu Chettiar 8 Veedu'),
(41, 10, 'Achirapakkam Chettiar'),
(42, 10, 'Agaram Vellan Chettiar'),
(43, 10, 'Arya Vysya'),
(44, 10, 'Beri Chettiar'),
(45, 10, 'Devanga Chettiar'),
(46, 10, 'Elur'),
(47, 10, 'Gandla/Ganiga'),
(48, 10, 'Kasukara'),
(49, 10, 'Kongu Chettiar'),
(50, 10, 'Kuruhini Chetty'),
(51, 10, 'Manjapudur Chettiar'),
(52, 10, 'Nattukottai Chettiar'),
(53, 10, 'Padma Saliar'),
(54, 10, 'Pannirandam Chettiar'),
(55, 10, 'Parvatha Rajakulam'),
(56, 10, 'Pattinavar'),
(57, 10, 'Pattusali'),
(58, 10, 'Sadhu'),
(59, 10, 'Senai Thalaivar'),
(60, 10, 'Sozhia Chetty'),
(61, 10, 'Telugupatti'),
(62, 10, 'Vadambar'),
(63, 10, 'Vaniya Chettiar'),
(64, 10, 'Vellan Chettiars'),
(65, 10, 'Others'),
(66, 11, 'Agamudayar'),
(67, 11, 'Ambalakarar'),
(68, 11, 'Appanad'),
(69, 11, 'Easanattu'),
(70, 11, 'Kallar'),
(71, 11, 'Kondayamkottai'),
(72, 11, 'Maniyakarar'),
(73, 11, 'Maravar'),
(74, 11, 'Piramalai Kallar'),
(75, 11, 'Rajakula'),
(76, 11, 'Sembanad'),
(77, 11, 'Servai'),
(78, 11, 'Thanjavur'),
(79, 11, 'Vallambar'),
(80, 11, 'Others'),
(81, 17, 'Aadai'),
(82, 17, 'Aadhi'),
(83, 17, 'Aanthai'),
(84, 17, 'Aavan'),
(85, 17, 'Alagan'),
(86, 17, 'Andai'),
(87, 17, 'Andhuvan'),
(88, 17, 'Cheran'),
(89, 17, 'Devendran'),
(90, 17, 'Eenjan'),
(91, 17, 'Ennai'),
(92, 17, 'Gounder'),
(93, 17, 'Kaadai'),
(94, 17, 'Kaari'),
(95, 17, 'Kanakkan'),
(96, 17, 'Kannan'),
(97, 17, 'Kannandhai'),
(98, 17, 'Keeran'),
(99, 17, 'Koorai'),
(100, 17, 'Koventhar'),
(101, 17, 'Kuzhlaayan'),
(102, 17, 'Maadai'),
(103, 17, 'Maniyan'),
(104, 17, 'Medhi'),
(105, 17, 'Muthan'),
(106, 17, 'Muzhlukkadhan'),
(107, 17, 'Nattu'),
(108, 17, 'Odhaalar'),
(109, 17, 'Paandian'),
(110, 17, 'Padaithalaiyan'),
(111, 17, 'Panaiyan'),
(112, 17, 'Panangadai'),
(113, 17, 'Pannai'),
(114, 17, 'Pannan'),
(115, 17, 'Pavalan'),
(116, 17, 'Payiran'),
(117, 17, 'Periyan'),
(118, 17, 'Perizhanthan'),
(119, 17, 'Perunkudi'),
(120, 17, 'Pillan'),
(121, 17, 'Podiyan'),
(122, 17, 'Ponnan'),
(123, 17, 'Poochadhai'),
(124, 17, 'Poodhiyan'),
(125, 17, 'Poosan'),
(126, 17, 'Sathandhai'),
(127, 17, 'Sedan'),
(128, 17, 'Sellan'),
(129, 17, 'Sempoothan'),
(130, 17, 'Sengannan'),
(131, 17, 'Sengunni'),
(132, 17, 'Seralan'),
(133, 17, 'Sevadi'),
(134, 17, 'Thodai'),
(135, 17, 'Thooran'),
(136, 17, 'Vannakkan'),
(137, 17, 'Veliyan'),
(138, 17, 'Vellamban'),
(139, 17, 'Venduvan'),
(140, 17, 'Viliyan'),
(141, 17, 'Villi'),
(142, 17, 'Others'),
(143, 24, 'Agamudayar/Arcot/Thuluva Vellala'),
(144, 24, 'Isai Vellalar'),
(145, 24, 'Kerala Mudali'),
(146, 24, 'Kongu Vellala'),
(147, 24, 'Saiva Pillai Tirunelveli'),
(148, 24, 'Sengunthar/Kaikolar'),
(149, 24, 'Sozhiya Vellalar'),
(150, 24, 'Thondai Mandala'),
(151, 24, 'Veerakodi Vellala'),
(152, 24, 'Others'),
(153, 27, 'Gramani/Sanar kongu'),
(154, 29, 'Ediga/Goud'),
(155, 29, 'Gavara'),
(156, 29, 'Kamma'),
(157, 29, 'Kappu'),
(158, 29, 'Muthuraja'),
(159, 29, 'Raju'),
(160, 29, 'Vadugan'),
(161, 29, 'Velama'),
(162, 29, 'Yadava'),
(163, 29, 'Others'),
(164, 32, 'Aaru Nattu Vellala'),
(165, 32, 'Agamudayar/Arcot/Thuluva Vellala'),
(166, 32, 'Cherakula Vellalar'),
(167, 32, 'Desikar'),
(168, 32, 'Desikar Thanjavur'),
(169, 32, 'Illaththu Pillai'),
(170, 32, 'Isai Vellalar'),
(171, 32, 'Karkathar'),
(172, 32, 'Kodikal Pillai'),
(173, 32, 'Nanjil Mudali'),
(174, 32, 'Nanjil Pillai'),
(175, 32, 'Nankudi Vellalar'),
(176, 32, 'Othuvaar'),
(177, 32, 'Pandiya Vellalar'),
(178, 32, 'Saiva Pillai Thanjavur'),
(179, 32, 'Saiva Pillai Tirunelveli'),
(180, 32, 'Sengunthar/Kaikolar'),
(181, 32, 'Sozhiya Vellalar'),
(182, 32, 'Thondai Mandala Vellala'),
(183, 32, 'Veerakodi Vellala'),
(184, 32, 'Others'),
(185, 33, 'Ayodhi'),
(186, 33, 'Bhoomanchi'),
(187, 33, 'Chowdary'),
(188, 33, 'Desuru'),
(189, 33, 'Gandla'),
(190, 33, 'Ganjam'),
(191, 33, 'Gone Kapu'),
(192, 33, 'Gudati'),
(193, 33, 'Kapu'),
(194, 33, 'Motati'),
(195, 33, 'Palle'),
(196, 33, 'Palnati'),
(197, 33, 'Panta'),
(198, 33, 'Pedakanti'),
(199, 33, 'Poknati'),
(200, 33, 'Reddiyar'),
(201, 33, 'Reddy'),
(202, 33, 'Sajjana'),
(203, 33, 'Vanni'),
(204, 33, 'Velanati'),
(205, 33, 'Others'),
(206, 34, 'Adi Dravida'),
(207, 34, 'Ahirwar'),
(208, 34, 'Arunthathiyar'),
(209, 34, 'Bairwa'),
(210, 34, 'Balai'),
(211, 34, 'Dhanak'),
(212, 34, 'Dhobi'),
(213, 34, 'Jatav'),
(214, 34, 'Julaha'),
(215, 34, 'Kanakkan Padanna'),
(216, 34, 'Kandara'),
(217, 34, 'Khatik'),
(218, 34, 'Kori/Koli'),
(219, 34, 'Kuruva'),
(220, 34, 'Madiga'),
(221, 34, 'Mahar'),
(222, 34, 'Mala'),
(223, 34, 'Mannan/Velan/Vannan'),
(224, 34, 'Meghwal'),
(225, 34, 'Mehra'),
(226, 34, 'Pallan/DevandraKulaVellalan'),
(227, 34, 'Panan'),
(228, 34, 'Paravan/Bharatar'),
(229, 34, 'Pasi'),
(230, 34, 'Paswan/Dusadh'),
(231, 34, 'Poundra'),
(232, 34, 'Pulaya/Cheruman'),
(233, 34, 'Raigar'),
(234, 34, 'Ramdasia'),
(235, 34, 'Ravidasia'),
(236, 34, 'Rohit/Chamar'),
(237, 34, 'Samagar'),
(238, 34, 'Sambava'),
(239, 34, 'Satnami'),
(240, 34, 'Shilpkar'),
(241, 34, 'Sonkar'),
(242, 34, 'Thandan'),
(243, 34, 'Valluvan'),
(244, 34, 'Valmiki'),
(245, 34, 'Vettuvan'),
(246, 34, 'Others'),
(247, 42, 'Arasu'),
(248, 42, 'Gounder'),
(249, 42, 'Naicker'),
(250, 42, 'Padayachi'),
(251, 42, 'Palli'),
(252, 42, 'Pandal'),
(253, 42, 'Vannia Reddiar'),
(254, 42, 'Vanniyar'),
(255, 42, 'Others'),
(256, 44, 'Aaru Nattu Vellala'),
(257, 44, 'Agamudayar/Arcot/Thuluva Vellala'),
(258, 44, 'Cherakula Vellalar'),
(259, 44, 'Desikar'),
(260, 44, 'Illaththu Pillai'),
(261, 44, 'Isai Vellalar'),
(262, 44, 'Karkathar'),
(263, 44, 'Kodikal Pillai'),
(264, 44, 'Kongu Vellala'),
(265, 44, 'Nanjil Mudali'),
(266, 44, 'Nanjil Nattu Vellalar'),
(267, 44, 'Nanjil Vellalar'),
(268, 44, 'Nankudi Vellalar'),
(269, 44, 'Othuvaar'),
(270, 44, 'Pandiya Vellalar'),
(271, 44, 'Saiva Pillai Thanjavur'),
(272, 44, 'Saiva Pillai Tirunelveli'),
(273, 44, 'Sengunthar/Kaikolar'),
(274, 44, 'Sozhiya Vellalar'),
(275, 44, 'TrThondai Mandala Vellala'),
(276, 44, 'Veerakodi Vellala'),
(277, 44, 'Others'),
(278, 46, 'Blacksmith'),
(279, 46, 'Carpentry (Vadrangi/Vadla)'),
(280, 46, 'Goldsmiths'),
(281, 46, 'Sculptor (Shilpi)'),
(282, 46, 'Others'),
(283, 48, 'Aheer/Ahir'),
(284, 48, 'Dadhor'),
(285, 48, 'Das'),
(286, 48, 'Doddi'),
(287, 48, 'Erragolla'),
(288, 48, 'Gadri/Gadariya'),
(289, 48, 'Gawli'),
(290, 48, 'Goala/Gola/Golla'),
(291, 48, 'Gop/Gopal/Gopala'),
(292, 48, 'Goriya'),
(293, 48, 'Gouda'),
(294, 48, 'Gwala'),
(295, 48, 'Gwalvanshi'),
(296, 48, 'Jadav'),
(297, 48, 'Karna'),
(298, 48, 'Konar'),
(299, 48, 'Krishnauth'),
(300, 48, 'Kurubas/Gollas'),
(301, 48, 'Kuruma'),
(302, 48, 'Mandal'),
(303, 48, 'Manjrauth'),
(304, 48, 'Nandavanshi'),
(305, 48, 'Pakanati'),
(306, 48, 'Puja'),
(307, 48, 'Raut'),
(308, 48, 'Suryavanshi'),
(309, 48, 'Thethwar'),
(310, 48, 'Yadav'),
(311, 48, 'Yadava Golla'),
(312, 48, 'Yaduvanshi'),
(313, 48, 'Others');
-- --------------------------------------------------------
--
-- Table structure for table `sub_community`
--
CREATE TABLE `sub_community` (
`id` int NOT NULL,
`community_id` int NOT NULL,
`sub_community` varchar(150) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `transaction_prefix`
--
CREATE TABLE `transaction_prefix` (
`id` int NOT NULL,
`prefix` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `transaction_prefix`
--
INSERT INTO `transaction_prefix` (`id`, `prefix`) VALUES
(1, 'trans');
-- --------------------------------------------------------
--
-- Table structure for table `user_reg`
--
CREATE TABLE `user_reg` (
`id` int NOT NULL,
`first_name` varchar(60) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`last_name` varchar(60) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
`user_id` varchar(20) DEFAULT NULL,
`username` varchar(50) NOT NULL,
`password` varchar(50) NOT NULL,
`confirm_password` varchar(60) DEFAULT NULL,
`email` varchar(50) NOT NULL,
`gender` varchar(50) NOT NULL,
`country` int DEFAULT NULL,
`created_on` datetime DEFAULT NULL,
`contact_num` varchar(13) DEFAULT NULL,
`conf_code` varchar(50) DEFAULT NULL,
`notification` varchar(150) DEFAULT NULL,
`email_key` longtext,
`remember_token` varchar(100) DEFAULT NULL,
`approval_status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1-approved, 2-rejected, 5-deactivated',
`approved_date` datetime DEFAULT NULL,
`rejected_by` varchar(20) NOT NULL COMMENT 'rejected by -admin, user ',
`rejection_date` datetime DEFAULT NULL,
`rejected_reason` varchar(100) DEFAULT NULL,
`deactivate_status` int DEFAULT NULL,
`deactivate_days` int DEFAULT NULL,
`deactivation_date` datetime DEFAULT NULL,
`deactivated_by` varchar(25) DEFAULT NULL,
`deactivated_reason` varchar(100) DEFAULT NULL,
`welcome` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1-sent',
`mobile_verified` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1-verified',
`email_verified` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1-verified',
`plan_id` int NOT NULL DEFAULT '0',
`lang` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0-english 1-tamil',
`first_name_tamil` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
`last_name_tamil` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `user_reg`
--
INSERT INTO `user_reg` (`id`, `first_name`, `last_name`, `user_id`, `username`, `password`, `confirm_password`, `email`, `gender`, `country`, `created_on`, `contact_num`, `conf_code`, `notification`, `email_key`, `remember_token`, `approval_status`, `approved_date`, `rejected_by`, `rejection_date`, `rejected_reason`, `deactivate_status`, `deactivate_days`, `deactivation_date`, `deactivated_by`, `deactivated_reason`, `welcome`, `mobile_verified`, `email_verified`, `plan_id`, `lang`, `first_name_tamil`, `last_name_tamil`) VALUES
(1, 'Raja', 'G', 'BELL001', 'raja', 'raja', 'raja', 'boobalang@gmail.com', 'Male', 99, '2017-11-22 11:43:39', '9944118433', NULL, NULL, NULL, NULL, 1, '2017-11-22 01:11:36', 'admin', '2018-03-06 11:03:08', 'sample file', NULL, NULL, NULL, NULL, NULL, 1, 1, 1, 7, 0, '', ''),
(2, 'சுஷாந்த் ', 'ராஜ்', 'BELL10002', 'susanth', 'password', 'password', 'susanth@gmail.com', 'Male', 99, '2017-12-09 15:44:27', '9487180061', NULL, NULL, NULL, NULL, 2, NULL, 'admin', '2017-12-09 03:12:17', 'some technical prob', NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, 1, '', ''),
(3, 'சுஷாந்த் ', 'ராஜ்', 'BELL10003', 'susanth', 'password', 'password', 'susanth@gmail.com', 'Male', 99, '2017-12-09 15:50:58', '9487180061', NULL, NULL, NULL, NULL, 2, NULL, 'admin', '2018-03-06 11:03:21', 'sample data', NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 9, 1, '', ''),
(4, 'சிவா', 'ராமர்', 'BELL10004', 'siva53', '123456', '123456', 'sivait34@gmail.com', 'Male', 99, '2017-12-09 16:44:29', '9790261892', NULL, NULL, NULL, NULL, 2, NULL, 'admin', '2018-03-06 11:03:37', 'sample data', NULL, NULL, NULL, NULL, NULL, 1, 1, 0, 0, 1, '', ''),
(5, 'Rajapandi', 'N', 'BELL10005', 'rajapandi', '123456', '123456', 'rajapandi.nr@gmail.com', 'Male', 99, '2017-12-16 13:07:34', '7639311390', NULL, NULL, NULL, NULL, 1, NULL, 'admin', '2018-03-06 11:03:51', 'sample data', NULL, NULL, NULL, NULL, NULL, 1, 1, 0, 0, 1, 'ராஜபாண்டி', 'N '),
(6, 'Soundarya', 'O', 'BELL10006', 'sound', '123456', '123456', 'otchusound93@gmail.com', 'Female', 99, '2017-12-19 15:22:42', '9894169153', NULL, NULL, NULL, NULL, 2, NULL, 'admin', '2018-03-06 11:03:10', 'sample data', NULL, NULL, NULL, NULL, NULL, 1, 1, 0, 0, 0, '', ''),
(7, 'ஜெயதுர்காதேவி', '', 'BELL10007', 'jeyadurga', '12345', '12345', 'jeya123@gmail.com', 'Female', 99, '2018-03-05 12:25:31', '1234567890', NULL, NULL, NULL, NULL, 1, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 0, 0, 1, 'ஜெயதுர்காதேவி', ''),
(8, 'Rajmeena', '', 'BELL10008', 'rajmeena', '12345', '12345', 'rajmeena@gmail.com', 'Female', 99, '2018-03-05 12:09:21', '4561230787', NULL, NULL, NULL, NULL, 1, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, 1, 'ராஜமீனா', ''),
(9, 'Vanitha', '', 'BELL10009', 'vanitha', '12345', '12345', 'vanitha@gmail.com', 'Female', 99, '2018-03-05 12:26:03', '7894561078', NULL, NULL, NULL, NULL, 1, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, 1, 'வனிதா', ''),
(10, 'Sakthipriya ', '', 'BELL10010', 'priya', '12345', '12345', 'priya@gmail.com', 'Female', 99, '2018-03-05 12:26:30', '4561239878', NULL, NULL, NULL, NULL, 1, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, 1, 'சக்திப்ரியா', ''),
(11, 'Saranya', '', 'BELL10011', 'saranya', '12345', '12345', 'saran@gmail.com', 'Female', 99, '2018-03-05 12:24:36', '2583697411', NULL, NULL, NULL, NULL, 1, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, 1, 'சரண்யா', ''),
(12, 'Siyamaladevi ', '', 'BELL10012', 'siyamala', '12345', '12345', 'siya@gmail.com', 'Female', 99, '2018-03-05 12:34:53', '7125896307', NULL, NULL, NULL, NULL, 1, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, 1, 'சியாமளாதேவி', ''),
(17, 'Srilakshmi ', '', 'BELL10013', 'lakshmi', '12345', '12345', 'lakshmi@gmail.com', 'Female', 99, '2018-03-05 12:52:36', '9790179161', NULL, NULL, NULL, NULL, 1, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, 1, 'ஸ்ரீலக்ஷ்மி', ''),
(18, 'NivithaSri ', '', 'BELL10018', 'nivitha', '12345', '12345', 'nivitha@gmail.com', 'Female', 99, '2018-03-05 13:02:15', '9578312782', NULL, NULL, NULL, NULL, 1, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, 1, 'நிவிதாஸ்ரீ', ''),
(19, 'Sadheeshwari ', '', 'BELL10019', 'sadhees', '12345', '12345', 'sadhees@gmail.com', 'Female', 99, '2018-03-05 13:08:46', '9655520434', NULL, NULL, NULL, NULL, 1, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, 1, 'சத்தீஸ்வரி', ''),
(20, 'Gowri (a) Revathi ', '', 'BELL10020', 'gowri', '12345', '12345', 'gowri@gmail.com', 'Female', 99, '2018-03-05 13:16:56', '8056805552', NULL, NULL, NULL, NULL, 1, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, 1, 'கௌரி (a) ரேவதி', ''),
(21, 'Sangeetha ', '', 'BELL10021', 'sangeetha', '12345', '12345', 'sangeetha@gmail.com', 'Female', 99, '2018-03-05 13:22:40', '9943223742', NULL, NULL, NULL, NULL, 1, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, 1, 'சங்கீதா', ''),
(22, 'Karthika', '', 'BELL10022', 'karthika', '12345', '12345', 'karthika@gmail.com', 'Female', 99, '2018-03-05 14:05:16', '9366633360', NULL, NULL, NULL, NULL, 1, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, 1, 'கார்த்திகா', ''),
(23, 'Sindhuja ', '', 'BELL10023', 'sindhu', '12345', '12345', 'sindhu@gmail.com', 'Female', 99, '2018-03-05 14:13:46', '9994443778', NULL, NULL, NULL, NULL, 1, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, 1, 'சிந்துஜா', ''),
(24, 'Priyanka', '', 'BELL10024', 'priyanka', '12345', '12345', 'priyanja@gmail.com', 'Female', 99, '2018-03-05 14:21:48', '9965556946', NULL, NULL, NULL, NULL, 1, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, 1, 'பிரியங்கா', ''),
(25, 'Venkatesan ', '', 'BELL10025', 'venkatesan', '12345', '12345', 'venkatesan@gmail.com', 'Male', 99, '2018-03-05 14:34:10', '9786770300', NULL, NULL, NULL, NULL, 1, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, 1, 'வெங்கடேசன்', ''),
(26, 'Kanagarai (a) Kannan', '', 'BELL10026', 'kannan', '12345', '12345', 'kannan@gmail.com', 'Male', 99, '2018-03-05 14:41:25', '9843586880', NULL, NULL, NULL, NULL, 1, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, 1, 'கனகராஜ் (a) கண்ணன்', ''),
(27, 'Surya (a) Surya Selvi', '', 'BELL10027', 'surya', '12345', '12345', 'surya@gmail.com', 'Female', 99, '2018-03-05 14:49:35', '9843609699', NULL, NULL, NULL, NULL, 1, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, 1, 'சூர்யா (a) சூரியசெல்வி', ''),
(28, 'Suganya', '', 'BELL10028', 'suganya', '12345', '12345', 'suganya@gmail.com', 'Female', 99, '2018-03-05 14:55:13', '9994367011', NULL, NULL, NULL, NULL, 1, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, 1, 'சுகன்யா', ''),
(29, 'Rajmohan', '', 'BELL10029', 'rajmohan', '12345', '12345', 'rajmohan@gmail.com', 'Male', 99, '2018-03-05 15:01:32', '8056480984', NULL, NULL, NULL, NULL, 1, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, 1, 'ராஜ்மோகன்', ''),
(30, 'Karthikraja ', '', 'BELL10030', 'karthikraja', '12345', '12345', 'karthikraja@gmail.com', 'Male', 99, '2018-03-05 15:06:59', '9952299166', NULL, NULL, NULL, NULL, 1, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, 1, 'கார்த்திக்ராஜா', ''),
(31, 'Dineshkumar', '', 'BELL10031', 'dinesh', '12345', '12345', 'dineshkumar@gmail.com', 'Male', 99, '2018-03-05 15:13:17', '9786947986', NULL, NULL, NULL, NULL, 1, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, 1, 'தினேஷ்குமார்', ''),
(32, 'Aanandhamurugaa', '', 'BELL10032', 'anandh', '12345', '12345', 'anandh@gmail.com', 'Male', 99, '2018-03-05 15:20:24', '8122235382', NULL, NULL, NULL, NULL, 1, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, 1, 'ஆனந்தமுருகா', ''),
(33, 'Vikas', '', 'BELL10033', 'vikas', '12345', '12345', 'vikas@gmail.com', 'Male', 99, '2018-03-05 15:27:30', '9443078349', NULL, NULL, NULL, NULL, 1, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, 1, 'விகாஸ்', ''),
(34, 'SaravanaKrishnan ', '', 'BELL10034', 'saravana', '12345', '12345', 'saravana@gmail.com', 'Male', 99, '2018-03-05 15:44:25', '9994990581', NULL, NULL, NULL, NULL, 1, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, 1, 'சரவணகிருஷ்ணன்', ''),
(35, 'Ravi Sankar', '', 'BELL10035', 'ravi', '12345', '12345', 'ravi@gmail.com', 'Male', 99, '2018-03-05 15:52:50', '9095043700', NULL, NULL, NULL, NULL, 1, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, 1, 'ரவி சங்கர்', ''),
(36, 'Jayakumar ', '', 'BELL10036', 'jayakumar', '12345', '12345', 'jayakumar@gmail.com', 'Male', 99, '2018-03-05 15:58:25', '9787244582', NULL, NULL, NULL, NULL, 1, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, 1, 'ஜெயக்குமார்', ''),
(37, 'Karthikeyan ', '', 'BELL10037', 'karthikeyan', '12345', '12345', 'karthikeyan@gmail.com', 'Male', 99, '2018-03-05 16:04:51', '8012062561', NULL, NULL, NULL, NULL, 1, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, 1, 'கார்த்திகேயன்', ''),
(38, 'Jeyaprakash ', '', 'BELL10038', 'jeyaprakash', '12345', '12345', 'jeyapraksh@gmail.com', 'Male', 99, '2018-03-05 16:12:12', '9944428321', NULL, NULL, NULL, NULL, 1, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, 1, 'ஜெயப்பிரகாஷ்', ''),
(39, 'Prabu ', '', 'BELL10039', 'prabu', '12345', '12345', 'prabu@gmail.com', 'Male', 99, '2018-03-05 16:17:36', '9486340752', NULL, NULL, NULL, NULL, 1, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, 1, 'பிரபு', ''),
(40, 'Rathnaselvam', '', 'BELL10040', 'rathnaselvam', '12345', '12345', 'rathana@gmail.com', 'Male', 99, '2018-03-05 17:07:41', '9042731517', NULL, NULL, NULL, NULL, 1, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, 1, 'ரத்னசெல்வம்', ''),
(41, 'lakshman', '', 'BELL10041', 'lakshman', '12345', '12345', 'lakshman@gmail.com', 'Male', 99, '2018-03-05 17:07:01', '9094566842', NULL, NULL, NULL, NULL, 1, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, 1, 'லெட்சுமன்', ''),
(42, 'Karthik sarathi', '', 'BELL10042', 'karthik', '12345', '12345', 'karthik@gmail.com', 'Male', 99, '2018-03-05 17:13:10', '9443367571', NULL, NULL, NULL, NULL, 1, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, 1, 'கார்த்திக் சாரதி', ''),
(43, 'Manikandan ', '', 'BELL10043', 'mani', '12345', '12345', 'mani@gmail.com', 'Male', 99, '2018-03-05 17:18:27', '9843151504', NULL, NULL, NULL, NULL, 1, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, 1, 'மணிகண்டன்', ''),
(44, 'Seenivasan', '', 'BELL10044', 'seenivasan', '12345', '12345', 'seenivasan@gmail.com', 'Male', 99, '2018-03-05 17:24:22', '9843755358', NULL, NULL, NULL, NULL, 1, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, 1, 'சீனிவாசன்', ''),
(45, 'Gurumoorthi', '', 'BELL10045', 'gurumoorthi', '12345', '12345', 'guru@gmail.com', 'Male', 99, '2018-03-05 17:32:10', '8056690495', NULL, NULL, NULL, NULL, 1, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, 1, 'குருமூர்த்தி', ''),
(46, 'Ranjith ', '', 'BELL10046', 'ranjith', '12345', '12345', 'ranjith@gmail.com', 'Male', 99, '2018-03-05 17:38:47', '9884490760', NULL, NULL, NULL, NULL, 1, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, 1, 'ரஞ்சித்', ''),
(47, 'Siva Arun Sandhar', '', 'BELL10047', 'arun', '12345', '12345', 'arun@gmail.com', 'Male', 99, '2018-03-05 17:47:35', '9629692023', NULL, NULL, NULL, NULL, 1, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, 1, 'சிவ அருண்சந்தர்', ''),
(48, 'sound', 'sound', 'BELL10048', 'soundarya', 'soundarya', 'soundarya', 'soundarya123@gmail.com', 'Female', 99, '2019-03-21 13:46:45', '8940531861', NULL, NULL, NULL, NULL, 1, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 0, 0, 0, '', ''),
(49, 'Muruganandam', 'R', 'BELL10049', 'Muruganandam', 'dhmctmtm01', 'dhmctmtm01', 'rmvnr01@gmail.com', 'Male', 99, '2019-05-15 22:07:17', '9629726297', NULL, NULL, NULL, NULL, 1, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 1, 0, 0, '', ''),
(50, 'Ranjith', 'Kumar', 'BELL10050', 'Randy@31', 'Randy@31', 'Randy@31', 'ranjithkumar.palpandi@gmail.com', 'Male', 99, '2020-11-16 10:14:31', '8148563080', NULL, NULL, NULL, NULL, 1, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, 0, '', ''),
(51, 'Ranjith', 'Kumar', 'BELL10051', 'Randy@31', 'Randy@31', 'Randy@31', 'ranjithkumar.palpandi@gmail.com', 'Male', 99, '2020-11-16 10:14:32', '8148563080', NULL, NULL, NULL, NULL, 1, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, 0, '', ''),
(52, 'Ranjith', 'Kumar', 'BELL10052', 'Randy@31', 'Randy@31', 'Randy@31', 'ranjithkumar.palpandi@gmail.com', 'Male', 99, '2020-11-16 10:14:43', '8148563080', NULL, NULL, NULL, NULL, 1, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, 0, '', ''),
(53, 'Ranjith', 'Kumar', 'BELL10053', 'Randy@31', 'Randy@31', 'Randy@31', 'ranjithkumar.palpandi@gmail.com', 'Male', 99, '2020-11-16 10:14:44', '8148563080', NULL, NULL, NULL, NULL, 1, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, 0, '', ''),
(54, 'Ranjith', 'Kumar', 'BELL10054', 'Randy@31', 'Randy@31', 'Randy@31', 'ranjithkumar.palpandi@gmail.com', 'Male', 99, '2020-11-16 10:14:44', '8148563080', NULL, NULL, NULL, NULL, 1, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, 0, '', ''),
(55, 'Ranjith', 'Kumar', 'BELL10055', 'Randy@31', 'Randy@31', 'Randy@31', 'ranjithkumar.palpandi@gmail.com', 'Male', 99, '2020-11-16 10:14:44', '8148563080', NULL, NULL, NULL, NULL, 1, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, 0, '', ''),
(56, 'Ranjith', 'Kumar', 'BELL10056', 'Randy@31', 'Randy@31', 'Randy@31', 'ranjithkumar.palpandi@gmail.com', 'Male', 99, '2020-11-16 10:14:54', '8148563080', NULL, NULL, NULL, NULL, 1, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, 0, '', ''),
(57, 'Ranjith', 'Kumar', 'BELL10057', 'Randy@31', 'Randy@31', 'Randy@31', 'ranjithkumar.palpandi@gmail.com', 'Male', 99, '2020-11-16 10:19:34', '8148563080', NULL, NULL, NULL, NULL, 1, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, 0, '', ''),
(58, 'Ranjith', 'Kumar', 'BELL10058', 'Randy@31', 'Randy@31', 'Randy@31', 'ranjithkumar.palpandi@gmail.com', 'Male', 99, '2020-11-16 10:19:34', '8148563080', NULL, NULL, NULL, NULL, 1, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, 0, '', ''),
(59, 'Ranjith', 'Kumar', 'BELL10059', 'Randy@31', 'Randy@31', 'Randy@31', 'ranjithkumar.palpandi@gmail.com', 'Male', 99, '2020-11-16 10:19:34', '8148563080', NULL, NULL, NULL, NULL, 1, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, 0, '', ''),
(60, 'Ranjith', 'Kumar', 'BELL10060', 'Randy@31', 'Randy@31', 'Randy@31', 'ranjithkumar.palpandi@gmail.com', 'Male', 99, '2020-11-16 10:19:35', '8148563080', NULL, NULL, NULL, NULL, 1, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, 0, '', ''),
(61, 'Ranjith', 'Kumar', 'BELL10061', 'Randy@31', 'Randy@31', 'Randy@31', 'ranjithkumar.palpandi@gmail.com', 'Male', 99, '2020-11-16 10:19:44', '8148563080', NULL, NULL, NULL, NULL, 1, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, 0, '', ''),
(62, 'Ranjith', 'Kumar', 'BELL10062', 'Randy@31', 'Randy@31', 'Randy@31', 'ranjithkumar.palpandi@gmail.com', 'Male', 99, '2020-11-16 10:24:26', '8148563080', NULL, NULL, NULL, NULL, 1, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, 0, '', ''),
(63, 'Ranjith', 'Kumar', 'BELL10063', 'Randy@31', 'Randy@31', 'Randy@31', 'ranjithkumar.palpandi@gmail.com', 'Male', 99, '2020-11-16 10:24:26', '8148563080', NULL, NULL, NULL, NULL, 1, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, 0, '', ''),
(64, 'Ranjith', 'Kumar', 'BELL10064', 'Randy@31', 'Randy@31', 'Randy@31', 'ranjithkumar.palpandi@gmail.com', 'Male', 99, '2020-11-16 10:24:27', '8148563080', NULL, NULL, NULL, NULL, 1, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, 0, '', ''),
(65, 'Ranjith', 'Kumar', 'BELL10065', 'Randy@31', 'Randy@31', 'Randy@31', 'ranjithkumar.palpandi@gmail.com', 'Male', 99, '2020-11-16 10:24:27', '8148563080', NULL, NULL, NULL, NULL, 1, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, 0, '', ''),
(66, 'Ranjith', 'Kumar', 'BELL10066', 'Randy@31', 'Randy@31', 'Randy@31', 'ranjithkumar.palpandi@gmail.com', 'Male', 99, '2020-11-16 10:32:58', '8148563080', NULL, NULL, NULL, NULL, 1, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, 0, '', ''),
(67, 'Ranjith', 'Kumar', 'BELL10067', 'Randy@31', 'Randy@31', 'Randy@31', 'ranjithkumar.palpandi@gmail.com', 'Male', 99, '2020-11-16 10:32:58', '8148563080', NULL, NULL, NULL, NULL, 1, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, 0, '', ''),
(68, 'elliot', 'elliot', 'BELL10068', 'elliot', 'elliot', 'elliot', 'lmkafnpaimn@sharklasers.com', 'Male', 195, '2023-08-05 17:09:59', '3691628970', NULL, NULL, NULL, NULL, 1, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 0, 0, 0, '', ''),
(69, 'Vijaya', 'Kumar S', 'BELL10069', 'Vijay', 'blakkcatz', 'blakkcatz', 'svijaykumar1010@gmail.com', 'Male', 99, '2024-03-02 19:10:00', '7353460406', NULL, NULL, NULL, NULL, 1, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 0, 0, 0, '', '');
-- --------------------------------------------------------
--
-- Table structure for table `work_with`
--
CREATE TABLE `work_with` (
`id` int NOT NULL,
`work_with` varchar(50) DEFAULT NULL,
`work_with_tamil` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `work_with`
--
INSERT INTO `work_with` (`id`, `work_with`, `work_with_tamil`) VALUES
(1, 'Private Company', 'தனியார் நிறுவனம்'),
(2, 'Government / Public Sector', 'அரசு / பொதுத்துறை'),
(3, 'Business / Self Employee', 'வணிகம் / சுய வேலை'),
(4, 'Defence / Civil Services', 'பாதுகாப்பு / சிவில் சேவை'),
(5, 'Not Working', 'வேலை செய்யவில்லை');
-- --------------------------------------------------------
--
-- Table structure for table `zodiac_starsign`
--
CREATE TABLE `zodiac_starsign` (
`zodiac_starsign_id` int NOT NULL,
`rassi_id` int NOT NULL,
`zodiac_starsign` varchar(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `zodiac_starsign`
--
INSERT INTO `zodiac_starsign` (`zodiac_starsign_id`, `rassi_id`, `zodiac_starsign`) VALUES
(1, 1, 'Aries'),
(2, 6, 'Taurus'),
(3, 0, 'Gemini'),
(4, 0, 'Cancer'),
(5, 0, 'Leo'),
(6, 0, 'Virgo'),
(7, 0, 'Libra'),
(8, 0, 'Scorpio'),
(9, 0, 'Sagittarius'),
(10, 0, 'Capricorn'),
(11, 0, 'Aquarius'),
(12, 0, 'Pisces');
--
-- Indexes for dumped tables
--
--
-- Indexes for table `admin_credential`
--
ALTER TABLE `admin_credential`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `ads`
--
ALTER TABLE `ads`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `affluence_level`
--
ALTER TABLE `affluence_level`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `annual_income`
--
ALTER TABLE `annual_income`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `bank_details`
--
ALTER TABLE `bank_details`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `branch`
--
ALTER TABLE `branch`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `caste`
--
ALTER TABLE `caste`
ADD PRIMARY KEY (`caste_id`);
--
-- Indexes for table `cms_banner`
--
ALTER TABLE `cms_banner`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `cms_content`
--
ALTER TABLE `cms_content`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `country`
--
ALTER TABLE `country`
ADD PRIMARY KEY (`country_id`),
ADD KEY `country_id` (`country_id`);
--
-- Indexes for table `diet`
--
ALTER TABLE `diet`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `district`
--
ALTER TABLE `district`
ADD PRIMARY KEY (`district_id`);
--
-- Indexes for table `education`
--
ALTER TABLE `education`
ADD PRIMARY KEY (`education_id`);
--
-- Indexes for table `education_level`
--
ALTER TABLE `education_level`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `family_type`
--
ALTER TABLE `family_type`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `family_value`
--
ALTER TABLE `family_value`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `feedback`
--
ALTER TABLE `feedback`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `gallery`
--
ALTER TABLE `gallery`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `gotra`
--
ALTER TABLE `gotra`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `guest_user`
--
ALTER TABLE `guest_user`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `head_office`
--
ALTER TABLE `head_office`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `height`
--
ALTER TABLE `height`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `horoscope_details`
--
ALTER TABLE `horoscope_details`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `interests`
--
ALTER TABLE `interests`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `marital_status`
--
ALTER TABLE `marital_status`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `mother_tongue`
--
ALTER TABLE `mother_tongue`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `nakshathra`
--
ALTER TABLE `nakshathra`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `occupation`
--
ALTER TABLE `occupation`
ADD PRIMARY KEY (`occupation_id`);
--
-- Indexes for table `packages`
--
ALTER TABLE `packages`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `package_details`
--
ALTER TABLE `package_details`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `partner_preference`
--
ALTER TABLE `partner_preference`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `payment`
--
ALTER TABLE `payment`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `plan_details`
--
ALTER TABLE `plan_details`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `profession`
--
ALTER TABLE `profession`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `profile`
--
ALTER TABLE `profile`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `profile_charge`
--
ALTER TABLE `profile_charge`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `profile_education`
--
ALTER TABLE `profile_education`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `profile_family`
--
ALTER TABLE `profile_family`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `profile_lifestyle`
--
ALTER TABLE `profile_lifestyle`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `profile_printing`
--
ALTER TABLE `profile_printing`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `rasi`
--
ALTER TABLE `rasi`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `rassi_moonsign`
--
ALTER TABLE `rassi_moonsign`
ADD PRIMARY KEY (`rassimoonsign_id`);
--
-- Indexes for table `religion`
--
ALTER TABLE `religion`
ADD PRIMARY KEY (`religion_id`);
--
-- Indexes for table `settings`
--
ALTER TABLE `settings`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `star`
--
ALTER TABLE `star`
ADD PRIMARY KEY (`star_id`);
--
-- Indexes for table `state`
--
ALTER TABLE `state`
ADD PRIMARY KEY (`state_id`),
ADD KEY `state_id` (`state_id`);
--
-- Indexes for table `sub_caste`
--
ALTER TABLE `sub_caste`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `sub_community`
--
ALTER TABLE `sub_community`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `transaction_prefix`
--
ALTER TABLE `transaction_prefix`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `user_reg`
--
ALTER TABLE `user_reg`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `work_with`
--
ALTER TABLE `work_with`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `zodiac_starsign`
--
ALTER TABLE `zodiac_starsign`
ADD PRIMARY KEY (`zodiac_starsign_id`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `admin_credential`
--
ALTER TABLE `admin_credential`
MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `ads`
--
ALTER TABLE `ads`
MODIFY `id` int NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `affluence_level`
--
ALTER TABLE `affluence_level`
MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `annual_income`
--
ALTER TABLE `annual_income`
MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
--
-- AUTO_INCREMENT for table `bank_details`
--
ALTER TABLE `bank_details`
MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `branch`
--
ALTER TABLE `branch`
MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT for table `caste`
--
ALTER TABLE `caste`
MODIFY `caste_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=514;
--
-- AUTO_INCREMENT for table `cms_banner`
--
ALTER TABLE `cms_banner`
MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `cms_content`
--
ALTER TABLE `cms_content`
MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `country`
--
ALTER TABLE `country`
MODIFY `country_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=278;
--
-- AUTO_INCREMENT for table `diet`
--
ALTER TABLE `diet`
MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `district`
--
ALTER TABLE `district`
MODIFY `district_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=721;
--
-- AUTO_INCREMENT for table `education`
--
ALTER TABLE `education`
MODIFY `education_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=359;
--
-- AUTO_INCREMENT for table `education_level`
--
ALTER TABLE `education_level`
MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
--
-- AUTO_INCREMENT for table `family_type`
--
ALTER TABLE `family_type`
MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `family_value`
--
ALTER TABLE `family_value`
MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `feedback`
--
ALTER TABLE `feedback`
MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `gallery`
--
ALTER TABLE `gallery`
MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `gotra`
--
ALTER TABLE `gotra`
MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=175;
--
-- AUTO_INCREMENT for table `guest_user`
--
ALTER TABLE `guest_user`
MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
--
-- AUTO_INCREMENT for table `head_office`
--
ALTER TABLE `head_office`
MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `height`
--
ALTER TABLE `height`
MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;
--
-- AUTO_INCREMENT for table `horoscope_details`
--
ALTER TABLE `horoscope_details`
MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=46;
--
-- AUTO_INCREMENT for table `interests`
--
ALTER TABLE `interests`
MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `marital_status`
--
ALTER TABLE `marital_status`
MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `mother_tongue`
--
ALTER TABLE `mother_tongue`
MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30;
--
-- AUTO_INCREMENT for table `nakshathra`
--
ALTER TABLE `nakshathra`
MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;
--
-- AUTO_INCREMENT for table `occupation`
--
ALTER TABLE `occupation`
MODIFY `occupation_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=96;
--
-- AUTO_INCREMENT for table `packages`
--
ALTER TABLE `packages`
MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
--
-- AUTO_INCREMENT for table `package_details`
--
ALTER TABLE `package_details`
MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=45;
--
-- AUTO_INCREMENT for table `partner_preference`
--
ALTER TABLE `partner_preference`
MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `payment`
--
ALTER TABLE `payment`
MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `plan_details`
--
ALTER TABLE `plan_details`
MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
--
-- AUTO_INCREMENT for table `profession`
--
ALTER TABLE `profession`
MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;
--
-- AUTO_INCREMENT for table `profile`
--
ALTER TABLE `profile`
MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=64;
--
-- AUTO_INCREMENT for table `profile_charge`
--
ALTER TABLE `profile_charge`
MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `profile_education`
--
ALTER TABLE `profile_education`
MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=68;
--
-- AUTO_INCREMENT for table `profile_family`
--
ALTER TABLE `profile_family`
MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=68;
--
-- AUTO_INCREMENT for table `profile_lifestyle`
--
ALTER TABLE `profile_lifestyle`
MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=68;
--
-- AUTO_INCREMENT for table `profile_printing`
--
ALTER TABLE `profile_printing`
MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;
--
-- AUTO_INCREMENT for table `rasi`
--
ALTER TABLE `rasi`
MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
--
-- AUTO_INCREMENT for table `rassi_moonsign`
--
ALTER TABLE `rassi_moonsign`
MODIFY `rassimoonsign_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=39;
--
-- AUTO_INCREMENT for table `religion`
--
ALTER TABLE `religion`
MODIFY `religion_id` bigint NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=63;
--
-- AUTO_INCREMENT for table `settings`
--
ALTER TABLE `settings`
MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `star`
--
ALTER TABLE `star`
MODIFY `star_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29;
--
-- AUTO_INCREMENT for table `state`
--
ALTER TABLE `state`
MODIFY `state_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=94;
--
-- AUTO_INCREMENT for table `sub_caste`
--
ALTER TABLE `sub_caste`
MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=314;
--
-- AUTO_INCREMENT for table `sub_community`
--
ALTER TABLE `sub_community`
MODIFY `id` int NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `transaction_prefix`
--
ALTER TABLE `transaction_prefix`
MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `user_reg`
--
ALTER TABLE `user_reg`
MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=70;
--
-- AUTO_INCREMENT for table `work_with`
--
ALTER TABLE `work_with`
MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `zodiac_starsign`
--
ALTER TABLE `zodiac_starsign`
MODIFY `zodiac_starsign_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
COMMIT;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
