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




--
-- Database: `jacobitematrimony.com`
--

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

--
-- Table structure for table `admin`
--

CREATE TABLE IF NOT EXISTS `admin` (
  `admin_id` int(4) NOT NULL AUTO_INCREMENT,
  `username` varchar(25) DEFAULT NULL,
  `password` varchar(32) NOT NULL,
  `first_name` varchar(25) DEFAULT NULL,
  `last_name` varchar(25) DEFAULT NULL,
  `admin_type` enum('SA','GA') NOT NULL DEFAULT 'GA' COMMENT 'SA = Super Admin, GA = General Admin',
  `theme` varchar(50) NOT NULL,
  `status` enum('Y','N') NOT NULL DEFAULT 'Y',
  PRIMARY KEY (`admin_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;

--
-- Dumping data for table `admin`
--

INSERT INTO `admin` (`admin_id`, `username`, `password`, `first_name`, `last_name`, `admin_type`, `theme`, `status`) VALUES
(1, 'super admin', '5f4dcc3b5aa765d61d8327deb882cf99', 'System', 'Admin', 'SA', 'default', 'Y'),
(2, 'admin', '5f4dcc3b5aa765d61d8327deb882cf99', 'Super', 'Admin', 'SA', 'blue', 'Y'),
(3, 'master admin', '5f4dcc3b5aa765d61d8327deb882cf99', 'System', 'Admin', 'SA', 'default', 'Y'),
(4, 'astro admin', '5f4dcc3b5aa765d61d8327deb882cf99', 'System', 'Admin', 'SA', 'default', 'Y'),
(5, 'astro panel1', '5f4dcc3b5aa765d61d8327deb882cf99', 'System', 'Admin', 'SA', 'default', 'Y'),
(6, 'astro panel2', '5f4dcc3b5aa765d61d8327deb882cf99', 'System', 'Admin', 'SA', 'default', 'Y'),
(7, 'astro panel3', '5f4dcc3b5aa765d61d8327deb882cf99', 'System', 'Admin', 'SA', 'default', 'Y'),
(8, 'astro panel4', '5f4dcc3b5aa765d61d8327deb882cf99', 'System', 'Admin', 'SA', 'default', 'Y'),
(9, 'astro panel5', '5f4dcc3b5aa765d61d8327deb882cf99', 'System', 'Admin', 'SA', 'default', 'Y'),
(10, 'umesh', '1c275e304e0a1c9551a6797da1c73a46', 'Umesh', 'C U', 'SA', 'default', 'Y');

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

--
-- Table structure for table `advanced_search_save`
--

CREATE TABLE IF NOT EXISTS `advanced_search_save` (
  `advanced_search_id` int(11) NOT NULL AUTO_INCREMENT,
  `profile_id` int(11) NOT NULL,
  `search_url` text NOT NULL,
  `added_date` datetime NOT NULL,
  PRIMARY KEY (`advanced_search_id`),
  KEY `profile_id` (`profile_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `advanced_search_save`
--

INSERT INTO `advanced_search_save` (`advanced_search_id`, `profile_id`, `search_url`, `added_date`) VALUES
(1, 23, 'advanced_search.php?gender=Female&religion_id=9&caste_id=null&country_id=null&height_from=&height_to=&age_from=18&age_to=21&complexion=&body_type=&physical_status=1&mother_tongue=null&star_id=null&education_id=null&occupation_id=null&diet=&smoking=&drinking=&location_name=&residential_status=null&family_type=&family_value=&family_status=&marital_status=null', '2014-06-04 14:33:28'),
(2, 27, 'advanced_search.php?gender=Female&religion_id=2&caste_id=null&country_id=356&height_from=&height_to=&age_from=21&age_to=36&complexion=&body_type=&physical_status=1&mother_tongue=null&star_id=null&education_id=null&occupation_id=9&diet=&smoking=&drinking=&location_name=&residential_status=null&family_type=&family_value=&family_status=&marital_status=null', '2014-05-15 16:10:36');

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

--
-- Table structure for table `astro_member`
--

CREATE TABLE IF NOT EXISTS `astro_member` (
  `astro_member_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `first_name` varchar(100) NOT NULL,
  `username` varchar(100) NOT NULL,
  `password` varchar(100) NOT NULL,
  `mobile` varchar(255) NOT NULL,
  `mobile2` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `skype_id` varchar(100) NOT NULL,
  `country_id` varchar(255) NOT NULL,
  `status` enum('Y','N') NOT NULL DEFAULT 'Y',
  `registration_date` datetime NOT NULL,
  `order_id` int(11) NOT NULL,
  PRIMARY KEY (`astro_member_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `astro_member`
--


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

--
-- Table structure for table `banner`
--

CREATE TABLE IF NOT EXISTS `banner` (
  `banner_id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL,
  `description` text NOT NULL,
  `image_name` varchar(100) NOT NULL,
  `banner_date` date NOT NULL,
  `status` enum('Y','N') NOT NULL DEFAULT 'N',
  PRIMARY KEY (`banner_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `banner`
--

INSERT INTO `banner` (`banner_id`, `title`, `description`, `image_name`, `banner_date`, `status`) VALUES
(1, 'banner', 'test banner', '140671497354572300140671497394937jacobite_matrimonial_banner.jpg', '2014-07-30', 'Y');

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

--
-- Table structure for table `booking`
--

CREATE TABLE IF NOT EXISTS `booking` (
  `booking_id` int(11) NOT NULL AUTO_INCREMENT,
  `member_id` bigint(20) NOT NULL,
  `session_date` date NOT NULL,
  `session_time` time NOT NULL,
  `reset_status` enum('Y','N') NOT NULL DEFAULT 'N',
  `booking_date` date NOT NULL,
  PRIMARY KEY (`booking_id`),
  KEY `member_id` (`member_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `booking`
--

INSERT INTO `booking` (`booking_id`, `member_id`, `session_date`, `session_time`, `reset_status`, `booking_date`) VALUES
(1, 1, '2014-02-28', '04:30:00', 'Y', '2014-02-19'),
(2, 1, '2014-02-28', '04:30:00', 'Y', '2014-02-19'),
(3, 1, '2014-02-19', '09:30:00', 'Y', '2014-02-19'),
(4, 1, '2014-02-21', '09:30:00', 'Y', '2014-02-19'),
(5, 1, '2014-04-15', '04:30:00', 'Y', '2014-04-13');

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

--
-- Table structure for table `caste`
--

CREATE TABLE IF NOT EXISTS `caste` (
  `caste_id` int(11) NOT NULL AUTO_INCREMENT,
  `religion_id` int(11) NOT NULL,
  `caste_name` varchar(255) NOT NULL,
  `status` enum('Y','N') NOT NULL DEFAULT 'Y',
  PRIMARY KEY (`caste_id`),
  KEY `religion_id` (`religion_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ;

--
-- Dumping data for table `caste`
--

INSERT INTO `caste` (`caste_id`, `religion_id`, `caste_name`, `status`) VALUES
(15, 1, 'Jacobite', 'Y'),
(18, 1, 'Knanaya Jacobite', 'Y');

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

--
-- Table structure for table `cometchat`
--

CREATE TABLE IF NOT EXISTS `cometchat` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `from` int(10) unsigned NOT NULL,
  `to` int(10) unsigned NOT NULL,
  `message` text NOT NULL,
  `sent` int(10) unsigned NOT NULL DEFAULT '0',
  `read` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `direction` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `to` (`to`),
  KEY `from` (`from`),
  KEY `direction` (`direction`),
  KEY `read` (`read`),
  KEY `sent` (`sent`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `cometchat`
--


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

--
-- Table structure for table `cometchat_announcements`
--

CREATE TABLE IF NOT EXISTS `cometchat_announcements` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `announcement` text NOT NULL,
  `time` int(10) unsigned NOT NULL,
  `to` int(10) NOT NULL,
  `recd` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `to` (`to`),
  KEY `time` (`time`),
  KEY `to_id` (`to`,`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `cometchat_announcements`
--


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

--
-- Table structure for table `cometchat_block`
--

CREATE TABLE IF NOT EXISTS `cometchat_block` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `fromid` int(10) unsigned NOT NULL,
  `toid` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fromid` (`fromid`),
  KEY `toid` (`toid`),
  KEY `fromid_toid` (`fromid`,`toid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `cometchat_block`
--


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

--
-- Table structure for table `cometchat_chatroommessages`
--

CREATE TABLE IF NOT EXISTS `cometchat_chatroommessages` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `userid` int(10) unsigned NOT NULL,
  `chatroomid` int(10) unsigned NOT NULL,
  `message` text NOT NULL,
  `sent` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `userid` (`userid`),
  KEY `chatroomid` (`chatroomid`),
  KEY `sent` (`sent`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `cometchat_chatroommessages`
--


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

--
-- Table structure for table `cometchat_chatrooms`
--

CREATE TABLE IF NOT EXISTS `cometchat_chatrooms` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `lastactivity` int(10) unsigned NOT NULL,
  `createdby` int(10) unsigned NOT NULL,
  `password` varchar(255) NOT NULL,
  `type` tinyint(1) unsigned NOT NULL,
  `vidsession` varchar(512) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `lastactivity` (`lastactivity`),
  KEY `createdby` (`createdby`),
  KEY `type` (`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `cometchat_chatrooms`
--


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

--
-- Table structure for table `cometchat_chatrooms_users`
--

CREATE TABLE IF NOT EXISTS `cometchat_chatrooms_users` (
  `userid` int(10) unsigned NOT NULL,
  `chatroomid` int(10) unsigned NOT NULL,
  `lastactivity` int(10) unsigned NOT NULL,
  `isbanned` int(1) DEFAULT '0',
  PRIMARY KEY (`userid`,`chatroomid`) USING BTREE,
  KEY `chatroomid` (`chatroomid`),
  KEY `lastactivity` (`lastactivity`),
  KEY `userid` (`userid`),
  KEY `userid_chatroomid` (`chatroomid`,`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cometchat_chatrooms_users`
--


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

--
-- Table structure for table `cometchat_comethistory`
--

CREATE TABLE IF NOT EXISTS `cometchat_comethistory` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `channel` varchar(255) NOT NULL,
  `message` text NOT NULL,
  `sent` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `channel` (`channel`),
  KEY `sent` (`sent`),
  KEY `channel_sent` (`channel`,`sent`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `cometchat_comethistory`
--


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

--
-- Table structure for table `cometchat_games`
--

CREATE TABLE IF NOT EXISTS `cometchat_games` (
  `userid` int(10) unsigned NOT NULL,
  `score` int(10) unsigned DEFAULT NULL,
  `games` int(10) unsigned DEFAULT NULL,
  `recentlist` text,
  `highscorelist` text,
  PRIMARY KEY (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cometchat_games`
--


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

--
-- Table structure for table `cometchat_guests`
--

CREATE TABLE IF NOT EXISTS `cometchat_guests` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `lastactivity` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `lastactivity` (`lastactivity`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `cometchat_guests`
--


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

--
-- Table structure for table `cometchat_messages_old`
--

CREATE TABLE IF NOT EXISTS `cometchat_messages_old` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `from` int(10) unsigned NOT NULL,
  `to` int(10) unsigned NOT NULL,
  `message` text NOT NULL,
  `sent` int(10) unsigned NOT NULL DEFAULT '0',
  `read` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `direction` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `to` (`to`),
  KEY `from` (`from`),
  KEY `direction` (`direction`),
  KEY `read` (`read`),
  KEY `sent` (`sent`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `cometchat_messages_old`
--


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

--
-- Table structure for table `cometchat_status`
--

CREATE TABLE IF NOT EXISTS `cometchat_status` (
  `userid` int(10) unsigned NOT NULL,
  `message` text,
  `status` enum('available','away','busy','invisible','offline') DEFAULT NULL,
  `typingto` int(10) unsigned DEFAULT NULL,
  `typingtime` int(10) unsigned DEFAULT NULL,
  `isdevice` int(1) unsigned NOT NULL DEFAULT '0',
  `lastactivity` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`userid`),
  KEY `typingto` (`typingto`),
  KEY `typingtime` (`typingtime`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cometchat_status`
--


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

--
-- Table structure for table `content`
--

CREATE TABLE IF NOT EXISTS `content` (
  `content_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `seo_url` varchar(255) DEFAULT NULL,
  `seo_url_edit` enum('Y','N') NOT NULL DEFAULT 'Y',
  `title` varchar(255) DEFAULT NULL,
  `meta_description` text,
  `meta_keywords` text,
  `content` longtext,
  `author` varchar(255) NOT NULL,
  `added_date` datetime NOT NULL,
  `modified_date` datetime NOT NULL,
  `status` enum('Y','N') NOT NULL DEFAULT 'Y',
  `status_edit` enum('Y','N') NOT NULL DEFAULT 'Y',
  `show_menu` enum('Y','N') NOT NULL DEFAULT 'Y',
  `show_menu_edit` enum('Y','N') NOT NULL DEFAULT 'Y',
  `can_delete` enum('Y','N') NOT NULL DEFAULT 'Y',
  `order_id` int(11) NOT NULL,
  PRIMARY KEY (`content_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=17  ;

--
-- Dumping data for table `content`
--

INSERT INTO `content` (`content_id`, `name`, `seo_url`, `seo_url_edit`, `title`, `meta_description`, `meta_keywords`, `content`, `author`, `added_date`, `modified_date`, `status`, `status_edit`, `show_menu`, `show_menu_edit`, `can_delete`, `order_id`) VALUES
(1, 'Page Not Found', 'page-not-found.html', 'N', 'Page Not Found', 'Page Not Found', 'Page Not Found', '<div style="text-align: center;"><img src="http://localhost/gingermarry.com/userfiles/image/Jellyfish.jpg" width="0" height="0" alt="" /><img src="http://localhost/gingermarry.com/userfiles/image/warning.jpg" width="400" height="300" alt="" /></div>', '', '2013-10-10 17:12:12', '2014-08-26 09:32:50', 'Y', 'Y', 'N', 'Y', 'N', 19),
(2, 'Under Construction', 'under-construction.html', 'Y', 'Under Construction', 'Under Construction', 'Under Construction', '<div style="text-align: center;"><img src="http://localhost/gingermarry.com/userfiles/image/page-under-construction.jpg" width="400" height="300" alt="" /></div>', '', '2013-10-10 17:22:32', '2013-10-28 10:19:26', 'Y', 'Y', 'N', 'Y', 'Y', 21),
(5, 'FAQ', 'faq.html', 'Y', 'FAQ', 'Faq', 'Faq', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry''s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.   Lorem Ipsum is simply dummy text of the printing and typesetting industry.<br />\r\n<br />\r\nLorem Ipsum has been the industry''s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum. <br />\r\n<br />\r\nLorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry''s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.', '', '2013-10-25 12:51:46', '2014-08-20 06:20:33', 'Y', 'Y', 'N', 'Y', 'Y', 12),
(6, 'Contact Us', 'contact-us.html', 'Y', 'Contact Us', 'Contact Us', 'Contact Us', '<div style="text-align: left;"><span style="font-size: 16px;"><strong>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Office Address:</strong></span><span style="font-size: 12px;"><strong><br />\r\n<br />\r\n</strong></span><strong> <br />\r\n</strong></div>\r\n<div style="text-align: left;"><span style="font-size: 16px;"><strong>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Kerala:</strong></span><span style="font-size: 14px;"><strong><br />\r\n<br />\r\n</strong><em>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Jacobite Matrimonial Services,<br />\r\n<br />\r\n&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Menothunalil Buildings, Asamannoor PO, <br />\r\n<br />\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Odakkaly, Perumbavoor,,<br />\r\n<br />\r\n&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Ernakulam Dist, <br />\r\n<br />\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Kerala , PIn 683549<br />\r\n&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<br />\r\n&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;Tel: <span class="skype_c2c_print_container notranslate">+91 484 2801180</span><span data-ismobile="false" data-isrtl="false" data-isfreecall="false" data-numbertocall="+914842801180" onclick="SkypeClick2Call.MenuInjectionHandler.makeCall(this, event)" onmouseout="SkypeClick2Call.MenuInjectionHandler.hideMenu(this, event)" onmouseover="SkypeClick2Call.MenuInjectionHandler.showMenu(this, event)" tabindex="-1" dir="ltr" class="skype_c2c_container notranslate" id="skype_c2c_container"><span skypeaction="skype_dropdown" dir="ltr" class="skype_c2c_highlighting_inactive_common"><span id="non_free_num_ui" class="skype_c2c_textarea_span"><img width="0" height="0" src="resource://skype_ff_extension-at-jetpack/skype_ff_extension/data/call_skype_logo.png" class="skype_c2c_logo_img" alt="" /><span class="skype_c2c_text_span">0484 3201000, +91 93 888 999 60</span></span></span></span><br />\r\n</em><strong><br />\r\n&nbsp;</strong></span><strong><br />\r\n<br />\r\n</strong></div>\r\n<div style="text-align: center;"><strong><br />\r\n<br />\r\n<br />\r\n</strong></div>\r\n<div class="skype_c2c_menu_container notranslate" id="skype_c2c_menu_container" style="left: 167.85px; top: 217px; display: none;" onmouseover="SkypeClick2Call.MenuInjectionHandler.showMenu(this, event)" onmouseout="SkypeClick2Call.MenuInjectionHandler.hideMenu(this, event)" data-fp="{7A45F1B7-7407-4812-BF3D-20CFF05C6CD6}" data-murl="https://pipe.skype.com/Client/2.0/" data-uiid="0">\r\n<div class="skype_c2c_menu_click2call"><a class="skype_c2c_menu_click2call_action" id="skype_c2c_menu_click2call_action" target="_self" href="skype:+914842801180?call&amp;origin=%7B''agent''%3A''FFTB%2F7.3.16540.9015''%2C''browser''%3A''mozilla%2F31.0''%2C''fingerprint''%3A''%7B7A45F1B7-7407-4812-BF3D-20CFF05C6CD6%7D''%2C''uiid''%3A''0''%2C''number_type''%3A''SPNR''%2C''url''%3A''http%3A%2F%2Fwww.jacobitesmatrimonial.com%2Fbeta%2Flibrary%2Ffckeditor%2Feditor%2Ffckeditor.html''%7D">Call</a></div>\r\n<div class="skype_c2c_menu_click2sms"><a class="skype_c2c_menu_click2sms_action" id="skype_c2c_menu_click2sms_action" target="_self" href="skype:+914842801180?sms&amp;origin=%7B''agent''%3A''FFTB%2F7.3.16540.9015''%2C''browser''%3A''mozilla%2F31.0''%2C''fingerprint''%3A''%7B7A45F1B7-7407-4812-BF3D-20CFF05C6CD6%7D''%2C''uiid''%3A''0''%2C''number_type''%3A''SPNR''%2C''url''%3A''http%3A%2F%2Fwww.jacobitesmatrimonial.com%2Fbeta%2Flibrary%2Ffckeditor%2Feditor%2Ffckeditor.html''%7D">Send SMS</a></div>\r\n<div class="skype_c2c_menu_add2skype"><a class="skype_c2c_menu_add2skype_text" id="skype_c2c_menu_add2skype_text" target="_self" href="skype:+914842801180?add&amp;origin=%7B''agent''%3A''FFTB%2F7.3.16540.9015''%2C''browser''%3A''mozilla%2F31.0''%2C''fingerprint''%3A''%7B7A45F1B7-7407-4812-BF3D-20CFF05C6CD6%7D''%2C''uiid''%3A''0''%2C''number_type''%3A''SPNR''%2C''url''%3A''http%3A%2F%2Fwww.jacobitesmatrimonial.com%2Fbeta%2Flibrary%2Ffckeditor%2Feditor%2Ffckeditor.html''%7D">Add to Skype</a></div>\r\n<div class="skype_c2c_menu_toll_info"><span class="skype_c2c_menu_toll_callcredit">You''ll need Skype Credit</span><span class="skype_c2c_menu_toll_free">Free via Skype</span></div>\r\n</div>\r\n\r\n<script src=''https://livesupporti.com/Scripts/client.js?acc=def059f4-bbdf-4b2d-9483-1d439c94a976''></script>', '', '2013-10-25 12:52:00', '2014-08-28 11:29:34', 'Y', 'Y', 'N', 'Y', 'Y', 8),
(7, 'Subscribe', 'subscribe.html', 'Y', 'Subscribe', 'Subscribe', 'Subscribe', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry''s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum. Lorem Ipsum is simply dummy text of the printing and typesetting industry.<br />\r\n<br />\r\nLorem Ipsum has been the industry''s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum. <br />\r\n<br />\r\nLorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry''s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.', '', '2013-10-25 14:36:21', '2014-08-27 05:24:22', 'Y', 'Y', 'Y', 'Y', 'Y', 3),
(9, 'Help', 'help.html', 'Y', 'Help', 'Success Stories', 'Success Stories', '<div style="text-align: left;"><span style="font-size: 16px;"><strong>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Feel free to Call Us for any help:<br />\r\n</strong></span><br />\r\nJacobite Matrimonial Services,<br />\r\n<br />\r\nMenothunalil Buildings, Asamannoor PO,<br />\r\n<br />\r\nOdakkaly, Perumbavoor,,<br />\r\n<br />\r\nErnakulam Dist,<br />\r\n<br />\r\nKerala , PIn 683549<br />\r\n<br />\r\nTel: <span class="skype_c2c_print_container notranslate">0484 3201000</span><span data-ismobile="false" data-isrtl="false" data-isfreecall="false" data-numbertocall="+914843201000" onclick="SkypeClick2Call.MenuInjectionHandler.makeCall(this, event)" onmouseout="SkypeClick2Call.MenuInjectionHandler.hideMenu(this, event)" onmouseover="SkypeClick2Call.MenuInjectionHandler.showMenu(this, event)" tabindex="-1" dir="ltr" class="skype_c2c_container notranslate" id="skype_c2c_container"><span skypeaction="skype_dropdown" dir="ltr" class="skype_c2c_highlighting_inactive_common"><span id="non_free_num_ui" class="skype_c2c_textarea_span"><img width="0" height="0" src="resource://skype_ff_extension-at-jetpack/skype_ff_extension/data/call_skype_logo.png" class="skype_c2c_logo_img" alt="" /><span class="skype_c2c_text_span">0484 3201000</span></span></span></span>, <span class="skype_c2c_print_container notranslate">+91 93 888 999 60</span><span data-ismobile="false" data-isrtl="false" data-isfreecall="false" data-numbertocall="+919388899960" onclick="SkypeClick2Call.MenuInjectionHandler.makeCall(this, event)" onmouseout="SkypeClick2Call.MenuInjectionHandler.hideMenu(this, event)" onmouseover="SkypeClick2Call.MenuInjectionHandler.showMenu(this, event)" tabindex="-1" dir="ltr" class="skype_c2c_container notranslate" id="skype_c2c_container"><span skypeaction="skype_dropdown" dir="ltr" class="skype_c2c_highlighting_inactive_common"><span id="non_free_num_ui" class="skype_c2c_textarea_span"><img width="0" height="0" src="resource://skype_ff_extension-at-jetpack/skype_ff_extension/data/call_skype_logo.png" class="skype_c2c_logo_img" alt="" /><span class="skype_c2c_text_span">+91 93 888 999 60</span></span></span></span></div>\r\n<div style="text-align: left;"><span style="font-size: 16px;"><strong><br />\r\n<br />\r\n&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; </strong></span><strong><em><span style="font-size: 12px;"><br />\r\n</span></em><br />\r\n<br />\r\n</strong></div>\r\n<div style="text-align: center;"><strong><br />\r\n<br />\r\n</strong></div>\r\n<div class="skype_c2c_menu_container notranslate" id="skype_c2c_menu_container" style="display: none;" onmouseover="SkypeClick2Call.MenuInjectionHandler.showMenu(this, event)" onmouseout="SkypeClick2Call.MenuInjectionHandler.hideMenu(this, event)" data-fp="{7A45F1B7-7407-4812-BF3D-20CFF05C6CD6}" data-murl="https://pipe.skype.com/Client/2.0/" data-uiid="0">\r\n<div class="skype_c2c_menu_click2call"><a class="skype_c2c_menu_click2call_action" id="skype_c2c_menu_click2call_action" target="_self">Call</a></div>\r\n<div class="skype_c2c_menu_click2sms"><a class="skype_c2c_menu_click2sms_action" id="skype_c2c_menu_click2sms_action" target="_self">Send SMS</a></div>\r\n<div class="skype_c2c_menu_add2skype"><a class="skype_c2c_menu_add2skype_text" id="skype_c2c_menu_add2skype_text" target="_self">Add to Skype</a></div>\r\n<div class="skype_c2c_menu_toll_info"><span class="skype_c2c_menu_toll_callcredit">You''ll need Skype Credit</span><span class="skype_c2c_menu_toll_free">Free via Skype</span></div>\r\n</div>', '', '2013-10-28 14:26:06', '2014-08-23 07:04:00', 'Y', 'Y', 'N', 'Y', 'Y', 10),
(11, 'About Us', 'about-us.html', 'Y', 'About Us', 'About us', 'About us', '<div class="mentor_in">\r\n<p class="about_site"><img class="our_menter_imgage float_l our_menter_imgage_padding" src="http://www.jacobitesmatrimonial.com/jacobitematrimony.com/userfiles/image/our_mentor.jpg" width="248" height="339" alt="" /> <span style="font-weight:bold; font-family:''kartikabold'' !important;">ദൈവതàµതിനàµ സàµതàµതി </span><br />\r\nപàµരിയപàµപെടàµട  സഹോദരി സഹോദരങàµങളെ ..<br />\r\nമനàµഷàµയൻ à´കാനയിരികàµകàµനàµനതàµ നലàµലതലàµലെനàµനàµ കണàµടàµ അവനàµ തകàµക തàµണയെ ദൈവം സൃഷàµടിചàµചàµ. (ഉലàµപതàµതി 2:18)<br />\r\nപരിശàµദàµധ യാകàµകോബായ സàµറിയാനി സഭയിലെ ദൈവമാകàµകൾകàµകàµ അനàµയോജàµയരായ  ദൈവമകàµകളെ കണàµടെതàµതàµക എനàµനാ ആതàµയനàµതിക ലകàµഷàµയതàµതോടàµ കൂടിയാണàµ <b>Jacobites Matrimonial </b>എനàµന വെബàµസൈറàµറàµ പàµരവരàµതàµതനം ആരംഭിചàµചിടàµടàµളàµളതàµ . <br />\r\nതകàµക തàµണയെ കണàµടെതàµതàµവാൻ ഇനàµനàµ വിവിധ മാർഗങàµങൾ ഉണàµടെങàµകിലàµം അവ പലതàµം യഥാർതàµഥ ലകàµഷàµയതàµതിൽ എതàµതികàµകàµനàµനിലàµല എനàµനതാണàµ യാഥാരàµതàµയം.                 ഈ ചിനàµതയàµടെ  വെളിചàµചതàµതിലാണàµ  യാകàµകോബായ സàµറിയാനി സഭയിലെ ദൈവ മകàµകളെ ലകàµഷàµയം വചàµചàµകൊണàµടàµ ഈ ഒരàµ ഉദàµയമതàµതിനàµ ഞങൾ ഇറങàµങി തിരിചàµചതàµ.<br />\r\nശàµരേഷàµഠ കാതോലികàµക  അബൂൻ മോർ ബസേലിയോസàµ  തോമോസàµ പàµരഥമൻ ബാവയàµടെ അനàµവാദവàµം ആശീർവാദവàµം സഭയàµടെ പരിപൂർണàµണ പിനàµതàµണയàµം ഉണàµടàµ ഈ വെബàµസിറàµറൈനàµ. <br />\r\nഇതിനàµ പിനàµനിൽ പàµരവതàµതികàµകàµനàµന ദൈവമകàµകളെ നനàµദിയോടെ ഓരàµകàµകàµകയàµം പàµരാരàµതികàµകàµകയàµം  ചെയàµയàµനàµനàµ.<br />\r\nകോതമംഗലം കേനàµദàµരികരിചàµചàµ ഒരàµ ഓഫീസàµ  പàµരവതിചàµചàµ വരàµനàµനàµ. ഇ-മെയിൽ / ടെലിഫോണàµ&zwj;  വഴി രജിസàµറàµറർ ചെയàµയാവàµനàµനതാണàµ.<br />\r\nഇതിനàµറെ പàµരവർതàµതനങàµങൾകàµകàµ  നിങàµങളàµടെ വിലയേറിയ മാരàµഗàµഗ നിരàµദേശങàµങളàµം സഹായങàµങളàµം ഞങàµങൾ പàµരതീകàµഷികàµകàµനàµനàµ.<br />\r\nഈ പàµരസàµഥാനം വളരàµവാനàµം സഭകàµകàµ അഭിമാനമായി തീരàµവാൻ നിങàµങൾ പàµരാർതàµഥികàµകàµകയàµം  പേരàµകള രജിസàµറàµറർ ചെയàµതàµ സഹായികàµകàµകയàµം ചെയàµയണമെനàµനàµ അഭàµയരàµതàµതികàµകàµനàµനàµ.<br />\r\nആദàµയം രജിസàµറàµറർ ചെയàµയàµനàµന 500 ദൈവ മകàµകൾകàµകàµ&zwnj;  രെജിസടàµരറേൻ ചാർജàµ  സൌജനàµയമായിരികàµകàµം.</p>\r\n<div class="cb">&nbsp;</div>\r\n<p class="inner_head">For Jacobites Matrimonial Services<br />\r\nFr.Sibi Edapulavan</p>\r\n</div>', '', '2013-11-20 16:53:08', '2014-08-26 11:42:16', 'Y', 'Y', 'Y', 'Y', 'Y', 7),
(13, 'Feedback', 'feedback.html', 'Y', 'Feedback', 'Feedback', 'Feedback', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry''s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.  <br />\r\n<br />\r\nLorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry''s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.  <br />\r\n<br />\r\nLorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry''s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.', '', '2014-08-22 04:28:25', '2014-08-22 04:28:25', 'Y', 'Y', 'N', 'Y', 'Y', 15),
(14, 'Our Mentor', 'our-mentor.html', 'Y', 'Our Mentor', 'our-mentor', 'our-mentor', '<div class="mentor_in">\r\n<p class="about_site"><img class="our_menter_imgage float_l our_menter_imgage_padding" src="http://www.jacobitesmatrimonial.com/jacobitematrimony.com/userfiles/image/our_mentor.jpg" width="248" height="339" alt="" /> <span style="font-weight:bold; font-family:''kartikabold'' !important;">ദൈവതàµതിനàµ സàµതàµതി </span><br />\r\nപàµരിയപàµപെടàµട  സഹോദരി സഹോദരങàµങളെ ..<br />\r\nമനàµഷàµയൻ à´കാനയിരികàµകàµനàµനതàµ നലàµലതലàµലെനàµനàµ കണàµടàµ അവനàµ തകàµക തàµണയെ ദൈവം സൃഷàµടിചàµചàµ. (ഉലàµപതàµതി 2:18)<br />\r\nപരിശàµദàµധ യാകàµകോബായ സàµറിയാനി സഭയിലെ ദൈവമാകàµകൾകàµകàµ അനàµയോജàµയരായ  ദൈവമകàµകളെ കണàµടെതàµതàµക എനàµനാ ആതàµയനàµതിക ലകàµഷàµയതàµതോടàµ കൂടിയാണàµ <b>Jacobites Matrimonial </b>എനàµന വെബàµസൈറàµറàµ പàµരവരàµതàµതനം ആരംഭിചàµചിടàµടàµളàµളതàµ . <br />\r\nതകàµക തàµണയെ കണàµടെതàµതàµവാൻ ഇനàµനàµ വിവിധ മാർഗങàµങൾ ഉണàµടെങàµകിലàµം അവ പലതàµം യഥാർതàµഥ ലകàµഷàµയതàµതിൽ എതàµതികàµകàµനàµനിലàµല എനàµനതാണàµ യാഥാരàµതàµയം.                 ഈ ചിനàµതയàµടെ  വെളിചàµചതàµതിലാണàµ  യാകàµകോബായ സàµറിയാനി സഭയിലെ ദൈവ മകàµകളെ ലകàµഷàµയം വചàµചàµകൊണàµടàµ ഈ ഒരàµ ഉദàµയമതàµതിനàµ ഞങൾ ഇറങàµങി തിരിചàµചതàµ.<br />\r\nശàµരേഷàµഠ കാതോലികàµക  അബൂൻ മോർ ബസേലിയോസàµ  തോമോസàµ പàµരഥമൻ ബാവയàµടെ അനàµവാദവàµം ആശീർവാദവàµം സഭയàµടെ പരിപൂർണàµണ പിനàµതàµണയàµം ഉണàµടàµ ഈ വെബàµസിറàµറൈനàµ. <br />\r\nഇതിനàµ പിനàµനിൽ പàµരവതàµതികàµകàµനàµന ദൈവമകàµകളെ നനàµദിയോടെ ഓരàµകàµകàµകയàµം പàµരാരàµതികàµകàµകയàµം  ചെയàµയàµനàµനàµ.<br />\r\nകോതമംഗലം കേനàµദàµരികരിചàµചàµ ഒരàµ ഓഫീസàµ  പàµരവതിചàµചàµ വരàµനàµനàµ. ഇ-മെയിൽ / ടെലിഫോണàµ&zwj;  വഴി രജിസàµറàµറർ ചെയàµയാവàµനàµനതാണàµ.<br />\r\nഇതിനàµറെ പàµരവർതàµതനങàµങൾകàµകàµ  നിങàµങളàµടെ വിലയേറിയ മാരàµഗàµഗ നിരàµദേശങàµങളàµം സഹായങàµങളàµം ഞങàµങൾ പàµരതീകàµഷികàµകàµനàµനàµ.<br />\r\nഈ പàµരസàµഥാനം വളരàµവാനàµം സഭകàµകàµ അഭിമാനമായി തീരàµവാൻ നിങàµങൾ പàµരാർതàµഥികàµകàµകയàµം  പേരàµകള രജിസàµറàµറർ ചെയàµതàµ സഹായികàµകàµകയàµം ചെയàµയണമെനàµനàµ അഭàµയരàµതàµതികàµകàµനàµനàµ.<br />\r\nആദàµയം രജിസàµറàµറർ ചെയàµയàµനàµന 500 ദൈവ മകàµകൾകàµകàµ&zwnj;  രെജിസടàµരറേൻ ചാർജàµ  സൌജനàµയമായിരികàµകàµം.</p>\r\n<div class="cb">&nbsp;</div>\r\n<p class="inner_head">For Jacobites Matrimonial Services<br />\r\nFr.Sibi Edapulavan</p>\r\n</div>', '', '2014-08-27 05:19:59', '2014-08-27 05:19:59', 'Y', 'Y', 'N', 'Y', 'Y', 17),
(15, 'Find a Soulmate', 'find-a-soulmate-.html', 'Y', 'Find a Soulmate', 'Find a soulmate', 'Find a soulmate', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry''s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum. Lorem Ipsum is simply dummy text of the printing and typesetting industry.<br />\r\n<br />\r\nLorem Ipsum has been the industry''s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum. <br />\r\n<br />\r\nLorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry''s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.&nbsp;', '', '2014-08-27 05:25:33', '2014-08-27 05:25:33', 'Y', 'Y', 'Y', 'Y', 'Y', 1),
(16, 'Success Stories', 'success-stories.html', 'Y', 'Success Stories', 'Success Stories', 'Success Stories', '&nbsp;Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry''s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum. Lorem Ipsum is simply dummy text of the printing and typesetting industry.<br />\r\n<br />\r\nLorem Ipsum has been the industry''s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum. <br />\r\n<br />\r\nLorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry''s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.', '', '2014-08-27 05:26:06', '2014-08-27 05:26:06', 'Y', 'Y', 'Y', 'Y', 'Y', 5);

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

--
-- Table structure for table `country`
--

CREATE TABLE IF NOT EXISTS `country` (
  `country_id` varchar(3) NOT NULL,
  `country_name` varchar(150) NOT NULL,
  `country_code` int(11) NOT NULL,
  `alpha_2` char(2) NOT NULL,
  `alpha_3` char(3) NOT NULL,
  `iso3166_2` varchar(15) NOT NULL,
  `state_naming` varchar(100) NOT NULL,
  `post_code_naming` varchar(100) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='ISO 3166-1';

--
-- Dumping data for table `country`
--

INSERT INTO `country` (`country_id`, `country_name`, `country_code`, `alpha_2`, `alpha_3`, `iso3166_2`, `state_naming`, `post_code_naming`) VALUES
('004', 'Afghanistan', 93, 'AF', 'AFG', 'ISO 3166-2:AF', 'State / Province / Region', 'Postal code'),
('008', 'Albania', 355, 'AL', 'ALB', 'ISO 3166-2:AL', 'State / Province / Region', 'Postal code'),
('012', 'Algeria', 213, 'DZ', 'DZA', 'ISO 3166-2:DZ', 'State / Province / Region', 'Postal code'),
('016', 'American Samoa', 684, 'AS', 'ASM', 'ISO 3166-2:AS', 'State / Province / Region', 'Postal code'),
('020', 'Andorra', 376, 'AD', 'AND', 'ISO 3166-2:AD', 'State / Province / Region', 'Postal code'),
('024', 'Angola', 244, 'AO', 'AGO', 'ISO 3166-2:AO', 'State / Province / Region', 'Postal code'),
('660', 'Anguilla', 264, 'AI', 'AIA', 'ISO 3166-2:AI', 'State / Province / Region', 'Postal code'),
('010', 'Antarctica', 672, 'AQ', 'ATA', 'ISO 3166-2:AQ', '', ''),
('028', 'Antigua and Barbuda', 268, 'AG', 'ATG', 'ISO 3166-2:AG', 'State / Province / Region', 'Postal code'),
('032', 'Argentina', 54, 'AR', 'ARG', 'ISO 3166-2:AR', 'State / Province / Region', 'Postal code'),
('051', 'Armenia', 374, 'AM', 'ARM', 'ISO 3166-2:AM', 'State / Province / Region', 'Pin Code'),
('533', 'Aruba', 297, 'AW', 'ABW', 'ISO 3166-2:AW', 'State / Province / Region\r\n', 'Pin Code'),
('036', 'Australia', 61, 'AU', 'AUS', 'ISO 3166-2:AU', 'State / Territory', 'Postcode'),
('040', 'Austria', 43, 'AT', 'AUT', 'ISO 3166-2:AT', '', ''),
('031', 'Azerbaijan', 994, 'AZ', 'AZE', 'ISO 3166-2:AZ', 'State / Province / Region', 'Pin Code'),
('044', 'Bahamas', 242, 'BS', 'BHS', 'ISO 3166-2:BS', '', ''),
('048', 'Bahrain', 973, 'BH', 'BHR', 'ISO 3166-2:BH', 'State / Province / Region', 'Postal code'),
('050', 'Bangladesh', 880, 'BD', 'BGD', 'ISO 3166-2:BD', 'State / Province / Region', 'Postal code'),
('052', 'Barbados', 246, 'BB', 'BRB', 'ISO 3166-2:BB', 'State / Province / Region', 'Pin Code'),
('112', 'Belarus', 375, 'BY', 'BLR', 'ISO 3166-2:BY', 'State / Province / Region', 'Pin Code'),
('056', 'Belgium', 32, 'BE', 'BEL', 'ISO 3166-2:BE', '', ''),
('084', 'Belize', 501, 'BZ', 'BLZ', 'ISO 3166-2:BZ', 'State / Province / Region', 'Pin Code'),
('204', 'Benin', 229, 'BJ', 'BEN', 'ISO 3166-2:BJ', '', ''),
('060', 'Bermuda', 441, 'BM', 'BMU', 'ISO 3166-2:BM', '', ''),
('064', 'Bhutan', 975, 'BT', 'BTN', 'ISO 3166-2:BT', '', ''),
('068', 'Bolivia, Plurinational State of', 591, 'BO', 'BOL', 'ISO 3166-2:BO', '', ''),
('070', 'Bosnia and Herzegovina', 387, 'BA', 'BIH', 'ISO 3166-2:BA', 'State / Province / Region', 'Postal code'),
('072', 'Botswana', 267, 'BW', 'BWA', 'ISO 3166-2:BW', 'State / Province / Region', 'Postal code'),
('076', 'Brazil', 55, 'BR', 'BRA', 'ISO 3166-2:BR', 'State / Province / Region', 'Pin Code'),
('086', 'British Indian Ocean Territory', 284, 'IO', 'IOT', 'ISO 3166-2:IO', 'State / Province / Region', 'Pin Code'),
('096', 'Brunei Darussalam', 673, 'BN', 'BRN', 'ISO 3166-2:BN', 'State / Province / Region', 'Pin Code'),
('100', 'Bulgaria', 359, 'BG', 'BGR', 'ISO 3166-2:BG', 'State / Province / Region', 'Pin Code'),
('854', 'Burkina Faso', 226, 'BF', 'BFA', 'ISO 3166-2:BF', 'State / Province / Region', 'Pin Code'),
('108', 'Burundi', 257, 'BI', 'BDI', 'ISO 3166-2:BI', 'State / Province / Region', 'Pin Code'),
('116', 'Cambodia', 855, 'KH', 'KHM', 'ISO 3166-2:KH', 'State / Province / Region', 'Pin Code'),
('120', 'Cameroon', 237, 'CM', 'CMR', 'ISO 3166-2:CM', 'State / Province / Region', 'Pin Code'),
('124', 'Canada', 1, 'CA', 'CAN', 'ISO 3166-2:CA', 'State / Province / Region', 'Postal Code'),
('132', 'Cape Verde', 238, 'CV', 'CPV', 'ISO 3166-2:CV', 'State / Province / Region', 'Pin Code'),
('136', 'Cayman Islands', 345, 'KY', 'CYM', 'ISO 3166-2:KY', 'State / Province / Region', 'Pin Code'),
('140', 'Central African Republic', 236, 'CF', 'CAF', 'ISO 3166-2:CF', 'State / Province / Region', 'Pin Code'),
('148', 'Chad', 235, 'TD', 'TCD', 'ISO 3166-2:TD', 'State / Province / Region', 'Pin Code'),
('152', 'Chile', 56, 'CL', 'CHL', 'ISO 3166-2:CL', 'State / Province / Region', 'Pin Code'),
('156', 'China', 86, 'CN', 'CHN', 'ISO 3166-2:CN', '', ''),
('162', 'Christmas Island', 61, 'CX', 'CXR', 'ISO 3166-2:CX', '', ''),
('166', 'Cocos (Keeling) Islands', 61, 'CC', 'CCK', 'ISO 3166-2:CC', '', ''),
('170', 'Colombia', 57, 'CO', 'COL', 'ISO 3166-2:CO', 'State / Province / Region', 'Pin Code'),
('174', 'Comoros', 269, 'KM', 'COM', 'ISO 3166-2:KM', 'State / Province / Region', 'Pin Code'),
('178', 'Congo', 242, 'CG', 'COG', 'ISO 3166-2:CG', 'State / Province / Region', 'Pin Code'),
('180', 'Congo, the Democratic Republic of the', 243, 'CD', 'COD', 'ISO 3166-2:CD', 'State / Province / Region', 'Pin Code'),
('184', 'Cook Islands', 682, 'CK', 'COK', 'ISO 3166-2:CK', 'State / Province / Region', 'Pin Code'),
('188', 'Costa Rica', 506, 'CR', 'CRI', 'ISO 3166-2:CR', 'State / Province / Region', 'Pin Code'),
('384', 'Cote d\\''Ivoire ! Cote d\\''Ivoire', 225, 'CI', 'CIV', 'ISO 3166-2:CI', '', ''),
('191', 'Croatia', 385, 'HR', 'HRV', 'ISO 3166-2:HR', '', ''),
('192', 'Cuba', 53, 'CU', 'CUB', 'ISO 3166-2:CU', '', ''),
('196', 'Cyprus', 357, 'CY', 'CYP', 'ISO 3166-2:CY', '', ''),
('203', 'Czech Republic', 420, 'CZ', 'CZE', 'ISO 3166-2:CZ', '', ''),
('208', 'Denmark', 45, 'DK', 'DNK', 'ISO 3166-2:DK', '', ''),
('262', 'Djibouti', 253, 'DJ', 'DJI', 'ISO 3166-2:DJ', '', ''),
('212', 'Dominica', 767, 'DM', 'DMA', 'ISO 3166-2:DM', '', ''),
('214', 'Dominican Republic', 809, 'DO', 'DOM', 'ISO 3166-2:DO', '', ''),
('218', 'Ecuador', 593, 'EC', 'ECU', 'ISO 3166-2:EC', '', ''),
('818', 'Egypt', 20, 'EG', 'EGY', 'ISO 3166-2:EG', '', ''),
('222', 'El Salvador', 503, 'SV', 'SLV', 'ISO 3166-2:SV', '', ''),
('226', 'Equatorial Guinea', 240, 'GQ', 'GNQ', 'ISO 3166-2:GQ', '', ''),
('232', 'Eritrea', 291, 'ER', 'ERI', 'ISO 3166-2:ER', '', ''),
('233', 'Estonia', 372, 'EE', 'EST', 'ISO 3166-2:EE', '', ''),
('231', 'Ethiopia', 251, 'ET', 'ETH', 'ISO 3166-2:ET', '', ''),
('238', 'Falkland Islands (Malvinas)', 500, 'FK', 'FLK', 'ISO 3166-2:FK', '', ''),
('234', 'Faroe Islands', 298, 'FO', 'FRO', 'ISO 3166-2:FO', '', ''),
('242', 'Fiji', 679, 'FJ', 'FJI', 'ISO 3166-2:FJ', '', ''),
('246', 'Finland', 358, 'FI', 'FIN', 'ISO 3166-2:FI', '', ''),
('250', 'France', 33, 'FR', 'FRA', 'ISO 3166-2:FR', '', ''),
('258', 'French Polynesia', 689, 'PF', 'PYF', 'ISO 3166-2:PF', '', ''),
('266', 'Gabon', 241, 'GA', 'GAB', 'ISO 3166-2:GA', '', ''),
('270', 'Gambia', 220, 'GM', 'GMB', 'ISO 3166-2:GM', '', ''),
('268', 'Georgia', 995, 'GE', 'GEO', 'ISO 3166-2:GE', '', ''),
('276', 'Germany', 49, 'DE', 'DEU', 'ISO 3166-2:DE', '', ''),
('288', 'Ghana', 233, 'GH', 'GHA', 'ISO 3166-2:GH', '', ''),
('292', 'Gibraltar', 350, 'GI', 'GIB', 'ISO 3166-2:GI', '', ''),
('300', 'Greece', 30, 'GR', 'GRC', 'ISO 3166-2:GR', '', ''),
('304', 'Greenland', 299, 'GL', 'GRL', 'ISO 3166-2:GL', '', ''),
('308', 'Grenada', 473, 'GD', 'GRD', 'ISO 3166-2:GD', '', ''),
('316', 'Guam', 671, 'GU', 'GUM', 'ISO 3166-2:GU', '', ''),
('320', 'Guatemala', 502, 'GT', 'GTM', 'ISO 3166-2:GT', '', ''),
('324', 'Guinea', 224, 'GN', 'GIN', 'ISO 3166-2:GN', '', ''),
('624', 'Guinea-Bissau', 245, 'GW', 'GNB', 'ISO 3166-2:GW', '', ''),
('328', 'Guyana', 592, 'GY', 'GUY', 'ISO 3166-2:GY', '', ''),
('332', 'Haiti', 509, 'HT', 'HTI', 'ISO 3166-2:HT', '', ''),
('336', 'Holy See (Vatican City State)', 39, 'VA', 'VAT', 'ISO 3166-2:VA', '', ''),
('340', 'Honduras', 504, 'HN', 'HND', 'ISO 3166-2:HN', '', ''),
('344', 'Hong Kong', 852, 'HK', 'HKG', 'ISO 3166-2:HK', '', ''),
('348', 'Hungary', 36, 'HU', 'HUN', 'ISO 3166-2:HU', '', ''),
('352', 'Iceland', 354, 'IS', 'ISL', 'ISO 3166-2:IS', '', ''),
('356', 'India', 91, 'IN', 'IND', 'ISO 3166-2:IN', 'State', 'Pin Code'),
('360', 'Indonesia', 62, 'ID', 'IDN', 'ISO 3166-2:ID', '', ''),
('364', 'Iran, Islamic Republic of', 98, 'IR', 'IRN', 'ISO 3166-2:IR', '', ''),
('368', 'Iraq', 964, 'IQ', 'IRQ', 'ISO 3166-2:IQ', '', ''),
('372', 'Ireland', 353, 'IE', 'IRL', 'ISO 3166-2:IE', 'County', 'Post code'),
('833', 'Isle of Man', 44, 'IM', 'IMN', 'ISO 3166-2:IM', '', ''),
('376', 'Israel', 972, 'IL', 'ISR', 'ISO 3166-2:IL', '', ''),
('380', 'Italy', 39, 'IT', 'ITA', 'ISO 3166-2:IT', '', ''),
('388', 'Jamaica', 876, 'JM', 'JAM', 'ISO 3166-2:JM', '', ''),
('392', 'Japan', 81, 'JP', 'JPN', 'ISO 3166-2:JP', '', ''),
('400', 'Jordan', 962, 'JO', 'JOR', 'ISO 3166-2:JO', '', ''),
('398', 'Kazakhstan', 7, 'KZ', 'KAZ', 'ISO 3166-2:KZ', '', ''),
('404', 'Kenya', 254, 'KE', 'KEN', 'ISO 3166-2:KE', '', ''),
('296', 'Kiribati', 686, 'KI', 'KIR', 'ISO 3166-2:KI', '', ''),
('408', 'Korea, Democratic People\\''s Republic of', 850, 'KP', 'PRK', 'ISO 3166-2:KP', '', ''),
('410', 'Korea, Republic of', 82, 'KR', 'KOR', 'ISO 3166-2:KR', '', ''),

('566', 'Nigeria', 234, 'NG', 'NGA', 'ISO 3166-2:NG', '', ''),
('570', 'Niue', 683, 'NU', 'NIU', 'ISO 3166-2:NU', '', ''),
('574', 'Norfolk Island', 672, 'NF', 'NFK', 'ISO 3166-2:NF', '', ''),
('580', 'Northern Mariana Islands', 670, 'MP', 'MNP', 'ISO 3166-2:MP', '', ''),
('578', 'Norway', 47, 'NO', 'NOR', 'ISO 3166-2:NO', '', ''),
('512', 'Oman', 968, 'OM', 'OMN', 'ISO 3166-2:OM', '', ''),
('586', 'Pakistan', 92, 'PK', 'PAK', 'ISO 3166-2:PK', '', ''),
('585', 'Palau', 680, 'PW', 'PLW', 'ISO 3166-2:PW', '', ''),
('275', 'Palestinian Territory, Occupied', 275, 'PS', 'PSE', 'ISO 3166-2:PS', '', ''),
('591', 'Panama', 507, 'PA', 'PAN', 'ISO 3166-2:PA', '', ''),
('598', 'Papua New Guinea', 675, 'PG', 'PNG', 'ISO 3166-2:PG', '', ''),
('600', 'Paraguay', 595, 'PY', 'PRY', 'ISO 3166-2:PY', '', ''),
('604', 'Peru', 51, 'PE', 'PER', 'ISO 3166-2:PE', '', ''),
('608', 'Philippines', 63, 'PH', 'PHL', 'ISO 3166-2:PH', '', ''),
('612', 'Pitcairn', 870, 'PN', 'PCN', 'ISO 3166-2:PN', '', ''),
('616', 'Poland', 48, 'PL', 'POL', 'ISO 3166-2:PL', '', ''),
('620', 'Portugal', 351, 'PT', 'PRT', 'ISO 3166-2:PT', '', ''),
('630', 'Puerto Rico', 1, 'PR', 'PRI', 'ISO 3166-2:PR', '', ''),
('634', 'Qatar', 974, 'QA', 'QAT', 'ISO 3166-2:QA', '', ''),
('638', 'Reunion', 638, 'RE', 'REU', 'ISO 3166-2:RE', '', ''),
('642', 'Romania', 40, 'RO', 'ROU', 'ISO 3166-2:RO', '', ''),
('643', 'Russian Federation', 7, 'RU', 'RUS', 'ISO 3166-2:RU', '', ''),
('646', 'Rwanda', 250, 'RW', 'RWA', 'ISO 3166-2:RW', '', ''),
('652', 'Saint Barthelemy', 590, 'BL', 'BLM', 'ISO 3166-2:BL', '', ''),
('654', 'Saint Helena, Ascension and Tristan da Cunha', 654, 'SH', 'SHN', 'ISO 3166-2:SH', '', ''),
('659', 'Saint Kitts and Nevis', 869, 'KN', 'KNA', 'ISO 3166-2:KN', '', ''),
('662', 'Saint Lucia', 758, 'LC', 'LCA', 'ISO 3166-2:LC', '', ''),
('663', 'Saint Martin (French part)', 599, 'MF', 'MAF', 'ISO 3166-2:MF', '', ''),
('666', 'Saint Pierre and Miquelon', 508, 'PM', 'SPM', 'ISO 3166-2:PM', '', ''),
('670', 'Saint Vincent and the Grenadines', 784, 'VC', 'VCT', 'ISO 3166-2:VC', '', ''),
('882', 'Samoa', 685, 'WS', 'WSM', 'ISO 3166-2:WS', '', ''),
('674', 'San Marino', 378, 'SM', 'SMR', 'ISO 3166-2:SM', '', ''),
('678', 'Sao Tome and Principe', 239, 'ST', 'STP', 'ISO 3166-2:ST', '', ''),
('682', 'Saudi Arabia', 966, 'SA', 'SAU', 'ISO 3166-2:SA', '', ''),
('686', 'Senegal', 221, 'SN', 'SEN', 'ISO 3166-2:SN', '', ''),
('688', 'Serbia', 381, 'RS', 'SRB', 'ISO 3166-2:RS', '', ''),
('690', 'Seychelles', 248, 'SC', 'SYC', 'ISO 3166-2:SC', '', ''),
('694', 'Sierra Leone', 232, 'SL', 'SLE', 'ISO 3166-2:SL', '', ''),
('702', 'Singapore', 65, 'SG', 'SGP', 'ISO 3166-2:SG', '', ''),
('703', 'Slovakia', 421, 'SK', 'SVK', 'ISO 3166-2:SK', '', ''),
('705', 'Slovenia', 386, 'SI', 'SVN', 'ISO 3166-2:SI', '', ''),
('090', 'Solomon Islands', 677, 'SB', 'SLB', 'ISO 3166-2:SB', '', ''),
('706', 'Somalia', 252, 'SO', 'SOM', 'ISO 3166-2:SO', '', ''),
('710', 'South Africa', 27, 'ZA', 'ZAF', 'ISO 3166-2:ZA', '', ''),
('239', 'South Georgia and the South Sandwich Islands', 239, 'GS', 'SGS', 'ISO 3166-2:GS', '', ''),
('724', 'Spain', 34, 'ES', 'ESP', 'ISO 3166-2:ES', '', ''),
('144', 'Sri Lanka', 94, 'LK', 'LKA', 'ISO 3166-2:LK', '', ''),
('736', 'Sudan', 249, 'SD', 'SDN', 'ISO 3166-2:SD', '', ''),
('740', 'Suriname', 597, 'SR', 'SUR', 'ISO 3166-2:SR', '', ''),
('744', 'Svalbard and Jan Mayen', 744, 'SJ', 'SJM', 'ISO 3166-2:SJ', '', ''),
('748', 'Swaziland', 268, 'SZ', 'SWZ', 'ISO 3166-2:SZ', '', ''),
('752', 'Sweden', 46, 'SE', 'SWE', 'ISO 3166-2:SE', '', ''),
('756', 'Switzerland', 41, 'CH', 'CHE', 'ISO 3166-2:CH', '', ''),
('760', 'Syrian Arab Republic', 963, 'SY', 'SYR', 'ISO 3166-2:SY', '', ''),
('158', 'Taiwan, Province of China', 886, 'TW', 'TWN', 'ISO 3166-2:TW', '', ''),
('762', 'Tajikistan', 992, 'TJ', 'TJK', 'ISO 3166-2:TJ', '', ''),
('834', 'Tanzania, United Republic of', 255, 'TZ', 'TZA', 'ISO 3166-2:TZ', '', ''),
('764', 'Thailand', 66, 'TH', 'THA', 'ISO 3166-2:TH', '', ''),
('626', 'Timor-Leste', 670, 'TL', 'TLS', 'ISO 3166-2:TL', '', ''),
('768', 'Togo', 228, 'TG', 'TGO', 'ISO 3166-2:TG', '', ''),
('772', 'Tokelau', 690, 'TK', 'TKL', 'ISO 3166-2:TK', '', ''),
('776', 'Tonga', 676, 'TO', 'TON', 'ISO 3166-2:TO', '', ''),
('780', 'Trinidad and Tobago', 868, 'TT', 'TTO', 'ISO 3166-2:TT', '', ''),
('788', 'Tunisia', 216, 'TN', 'TUN', 'ISO 3166-2:TN', '', ''),
('792', 'Turkey', 90, 'TR', 'TUR', 'ISO 3166-2:TR', '', ''),
('795', 'Turkmenistan', 993, 'TM', 'TKM', 'ISO 3166-2:TM', '', ''),
('796', 'Turks and Caicos Islands', 649, 'TC', 'TCA', 'ISO 3166-2:TC', '', ''),
('798', 'Tuvalu', 688, 'TV', 'TUV', 'ISO 3166-2:TV', '', ''),
('800', 'Uganda', 256, 'UG', 'UGA', 'ISO 3166-2:UG', '', ''),
('804', 'Ukraine', 380, 'UA', 'UKR', 'ISO 3166-2:UA', '', ''),
('784', 'United Arab Emirates', 971, 'AE', 'ARE', 'ISO 3166-2:AE', '', ''),
('826', 'United Kingdom', 44, 'GB', 'GBR', 'ISO 3166-2:GB', 'County', 'Post code'),
('840', 'United States', 1, 'US', 'USA', 'ISO 3166-2:US', 'State / Province', 'ZIP / Postal code'),
('581', 'United States Minor Outlying Islands', 581, 'UM', 'UMI', 'ISO 3166-2:UM', '', ''),
('858', 'Uruguay', 598, 'UY', 'URY', 'ISO 3166-2:UY', '', ''),
('860', 'Uzbekistan', 998, 'UZ', 'UZB', 'ISO 3166-2:UZ', '', ''),
('548', 'Vanuatu', 678, 'VU', 'VUT', 'ISO 3166-2:VU', '', ''),
('862', 'Venezuela, Bolivarian Republic of', 58, 'VE', 'VEN', 'ISO 3166-2:VE', '', ''),
('704', 'Viet Nam', 84, 'VN', 'VNM', 'ISO 3166-2:VN', '', ''),
('092', 'Virgin Islands, British', 284, 'VG', 'VGB', 'ISO 3166-2:VG', '', ''),
('850', 'Virgin Islands, U.S.', 340, 'VI', 'VIR', 'ISO 3166-2:VI', '', ''),
('876', 'Wallis and Futuna', 681, 'WF', 'WLF', 'ISO 3166-2:WF', '', ''),
('732', 'Western Sahara', 732, 'EH', 'ESH', 'ISO 3166-2:EH', '', ''),
('887', 'Yemen', 967, 'YE', 'YEM', 'ISO 3166-2:YE', '', ''),
('894', 'Zambia', 260, 'ZM', 'ZMB', 'ISO 3166-2:ZM', '', ''),
('716', 'Zimbabwe', 263, 'ZW', 'ZWE', 'ISO 3166-2:ZW', '', ''),
('717', 'Any', 0, '', '', '', '', '');

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

--
-- Table structure for table `education`
--

CREATE TABLE IF NOT EXISTS `education` (
  `education_id` int(11) NOT NULL AUTO_INCREMENT,
  `education_name` varchar(255) NOT NULL,
  PRIMARY KEY (`education_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=54 ;

--
-- Dumping data for table `education`
--

INSERT INTO `education` (`education_id`, `education_name`) VALUES
(1, 'Aviation'),
(2, 'BAMS'),
(3, 'BDS'),
(4, 'BEd'),
(5, 'BHMS'),
(6, 'BPharm'),
(7, 'BVSC'),
(8, 'Bachelors - Arts/science/commerce/others'),
(9, 'Bachelors - Engineering'),
(10, 'Bachelors - Fashion Technology'),
(11, 'Bachelors - Law'),
(12, 'Bachelors - Management'),
(13, 'Bachelors - Media'),
(14, 'Bachelors - Nursing'),
(15, 'Bachelors - Paramedical'),
(16, 'Biotechnology'),
(17, 'CA'),
(18, 'Civil Service'),
(19, 'Company Secretary'),
(20, 'Diploma'),
(21, 'Doctor'),
(22, 'GNM'),
(23, 'ICWA'),
(24, 'JRF'),
(25, 'Less than Matriculation'),
(26, 'MBBS'),
(27, 'MD'),
(28, 'MDS'),
(29, 'MEd'),
(30, 'MPharm'),
(31, 'MS'),
(32, 'MSW'),
(33, 'MVSC'),
(34, 'Masters - Arts/science/commerce/others'),
(35, 'Masters - Engineering/Computers'),
(36, 'Masters - Fashion Technology'),
(37, 'Masters - Law'),
(38, 'Masters - Management'),
(39, 'Masters - Media'),
(40, 'Masters - Nursing'),
(41, 'Masters - Paramedical'),
(42, 'Medical/health science'),
(43, 'MicroBiology'),
(44, 'Mphil'),
(45, 'NET'),
(46, 'Others'),
(47, 'PDC'),
(48, 'Phd'),
(49, 'SET'),
(50, 'SSLC'),
(51, 'TTC'),
(52, 'UGC'),
(53, 'Any');

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

--
-- Table structure for table `email_template`
--

CREATE TABLE IF NOT EXISTS `email_template` (
  `email_template_id` int(11) NOT NULL AUTO_INCREMENT,
  `template_name` varchar(50) NOT NULL,
  `file_name` varchar(100) NOT NULL,
  `subject` varchar(100) NOT NULL,
  PRIMARY KEY (`email_template_id`),
  UNIQUE KEY `file_name` (`file_name`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=48 ;

--
-- Dumping data for table `email_template`
--

INSERT INTO `email_template` (`email_template_id`, `template_name`, `file_name`, `subject`) VALUES
(1, 'member.member-registration', 'member.member-registration.html', 'Registration Details'),
(2, 'admin.member-registration', 'admin.member-registration.html', 'Registration Details'),
(3, 'member.forgot-password', 'member.forgot-password.html', 'Password Recovery'),
(4, 'member.status-approved', 'member.status-approved.html', 'Member Login Approved'),
(5, 'member.status-disabled', 'member.status-disabled.html', 'Member Login Approval Pending'),
(6, 'member.reset-password', 'member.reset-password.html', 'Registration Details - Password Updated'),
(7, 'member.member-signup', 'member.member-signup.html', 'Registration Details'),
(8, 'admin.member-signup', 'admin.member-signup.html', 'Registration Details'),
(9, 'admin.upload-notification', 'admin.upload-notification.html', 'File Upload Details'),
(10, 'member.invoice-notification', 'member.invoice-notification.html', 'Invoice Details'),
(11, 'contactus.message', 'contactus.message.html', 'Contact Us'),
(12, 'member.member-re_registration', 'member.member-re_registration.html', 'Registration Details'),
(13, 'admin.member-re_registration', 'admin.member-re_registration.html', 'Registration Details'),
(14, 'sms.parent_notification', 'sms.parent_notification.html', 'Text Messaging to Parents(SMS)'),
(15, 'profile.status-approved', 'profile.status-approved.html', 'Profile Login Approved'),
(16, 'profile.status-disabled', 'profile.status-disabled.html', 'Profile Login Approval Pending'),
(17, 'member.profile-assigned', 'member.profile-assigned.html', 'New Profile Assigned'),
(18, 'profile.reset-password', 'profile.reset-password.html', 'Registration Details - Password Updated'),
(19, 'astro_member.reset-password', 'astro_member.reset-password.html', 'Registration Details - Password Updated'),
(20, 'admin.astro-mail', 'admin.astro-mail.html', 'Astro Member Notification Mail'),
(21, 'astro_member.status-approved', 'astro_member.status-approved.html', 'Astro Member Status Approved'),
(22, 'astro_member.status-disabled', 'astro_member.status-disabled.html', 'Astro Member ApprovalPending'),
(23, 'member.forward_profile', 'member.forward_profile.html', 'Forward Profile'),
(24, 'admin.agent-signup', 'admin.agent-signup.html', 'Agent Registration Details'),
(25, 'profile.forgot-password', 'profile.forgot-password.html', 'Password Recovery'),
(26, 'member.message-received', 'member.message-received.html', 'Messages Received'),
(27, 'member.interest-received', 'member.interest-received.html', 'Interest Received'),
(28, 'member.interest-rejected', 'member.interest-rejected.html', 'Interest Rejected'),
(29, 'member.interest-reminder', 'member.interest-reminder.html', 'Interest Reminder'),
(30, 'member.interest-accepted', 'member.interest-accepted.html', 'Interest Accepted'),
(31, 'member.interest-declined', 'member.interest-declined.html', 'Interest Declined'),
(32, 'member.horoscope-request', 'member.horoscope-request.html', 'Horoscope Request'),
(33, 'member.horoscope-password-request', 'member.horoscope-password-request.html', 'Horoscope Password Request'),
(34, 'member.horoscope-reject', 'member.horoscope-reject.html', 'Horoscope Request Reject'),
(35, 'member.horoscope-accept', 'member.horoscope-accept.html', 'Horoscope Request Accept'),
(36, 'member.horoscope-declined', 'member.horoscope-declined.html', 'Horoscope Request Declined'),
(37, 'member.photo-request', 'member.photo-request.html', 'Photo Request'),
(38, 'member.photo-password-request', 'member.photo-password-request.html', 'Photo Password Request'),
(39, 'member.photo-reject', 'member.photo-reject.html', 'Photo Request Reject'),
(40, 'member.photo-accept', 'member.photo-accept.html', 'Photo Request Accept'),
(41, 'member.photo-declined', 'member.photo-declined.html', 'Photo Request Declined'),
(42, 'member.horoscope-password-request-accept ', 'member.horoscope-password-request-accept.html ', 'Horoscope Password'),
(43, 'member.photo-password-request-accept ', 'member.photo-password-request-accept.html ', 'Photo Password'),
(44, 'member.contact-request', 'member.contact-request.html', 'Contact Details Request'),
(45, 'member.forward_favorite', 'member.forward_favorite.html', 'Forward Favorite Profile'),
(46, 'admin.member-update', 'admin.member-update.html', 'Profile Updation Details'),
(47, 'admin.member-photo', 'admin.member-photo.html', 'Photo Upload Details');

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

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

CREATE TABLE IF NOT EXISTS `holiday` (
  `holiday_id` int(11) NOT NULL AUTO_INCREMENT,
  `holiday_date` date NOT NULL,
  PRIMARY KEY (`holiday_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=32 ;

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

INSERT INTO `holiday` (`holiday_id`, `holiday_date`) VALUES
(1, '2013-03-03'),
(2, '2013-03-10'),
(3, '2013-03-17'),
(4, '2013-03-24'),
(5, '2013-03-31'),
(6, '2013-03-02'),
(7, '2013-03-09'),
(8, '2013-03-16'),
(9, '2013-03-23'),
(10, '2013-03-30'),
(11, '2013-03-05'),
(12, '2013-03-12'),
(13, '2013-03-19'),
(14, '2013-03-26'),
(15, '2013-04-06'),
(16, '2013-04-13'),
(17, '2013-04-20'),
(18, '2013-04-27'),
(19, '2013-04-14'),
(20, '2013-04-07'),
(21, '2013-04-21'),
(22, '2013-04-28'),
(23, '2013-04-02'),
(24, '2013-04-09'),
(25, '2013-04-16'),
(26, '2013-04-23'),
(27, '2013-04-30'),
(28, '2014-01-26'),
(29, '2014-01-02'),
(30, '2014-01-09'),
(31, '2014-01-14');

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

--
-- Table structure for table `horoscope`
--

CREATE TABLE IF NOT EXISTS `horoscope` (
  `horoscope_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `astro_member_id` bigint(20) NOT NULL,
  `first_name` varchar(255) NOT NULL,
  `gender` varchar(100) NOT NULL,
  `dob` date NOT NULL,
  `birth_time` varchar(255) NOT NULL,
  `ampm` varchar(50) NOT NULL,
  `country` int(11) NOT NULL,
  `father_name` varchar(225) NOT NULL,
  `mother_name` varchar(225) NOT NULL,
  `house_name` varchar(225) NOT NULL,
  `uploadfile` varchar(225) NOT NULL,
  `pincode` int(11) NOT NULL,
  `email_id` varchar(225) NOT NULL,
  `phoneno` int(11) NOT NULL,
  `birth_place` varchar(255) NOT NULL,
  `star_id` int(11) NOT NULL,
  `guardian_name` varchar(255) NOT NULL,
  `address` text NOT NULL,
  `postal_address` text NOT NULL,
  `status` enum('Y','N') NOT NULL DEFAULT 'Y',
  `registration_date` datetime NOT NULL,
  PRIMARY KEY (`horoscope_id`),
  KEY `astro_member_id` (`astro_member_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `horoscope`
--

INSERT INTO `horoscope` (`horoscope_id`, `astro_member_id`, `first_name`, `gender`, `dob`, `birth_time`, `ampm`, `country`, `father_name`, `mother_name`, `house_name`, `uploadfile`, `pincode`, `email_id`, `phoneno`, `birth_place`, `star_id`, `guardian_name`, `address`, `postal_address`, `status`, `registration_date`) VALUES
(1, 1, 'utyu', '', '1926-02-02', '2:0AM', '', 0, '', '', '', '', 0, '', 0, 'eter', 1, 'erter', 'tetert', 'etrerte', 'Y', '2014-05-13 17:59:20');

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

--
-- Table structure for table `location`
--

CREATE TABLE IF NOT EXISTS `location` (
  `location_id` int(11) NOT NULL AUTO_INCREMENT,
  `country_id` int(11) NOT NULL,
  `location_name` varchar(255) NOT NULL,
  PRIMARY KEY (`location_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=49 ;

--
-- Dumping data for table `location`
--

INSERT INTO `location` (`location_id`, `country_id`, `location_name`) VALUES
(1, 356, 'Kerala-Thiruvananthapuram'),
(2, 356, 'Kerala-Kollam'),
(3, 356, 'Kerala-Alapuzha'),
(4, 356, 'Kerala-Pathanamthitta'),
(5, 356, 'Kerala-Kottayam'),
(6, 356, 'Kerala-Idukki'),
(7, 356, 'Kerala-Ernakulam'),
(8, 356, 'Kerala-Thrissur'),
(9, 356, 'Kerala-Palakad'),
(10, 356, 'Kerala-Malappuram'),
(11, 356, 'Kerala-Kozhikode'),
(12, 356, 'Kerala-Wayanad'),
(13, 356, 'Kerala-Kannur'),
(14, 356, 'Kerala-Kasargod'),
(15, 356, 'Bihar'),
(16, 356, 'Andaman &amp; Nicobar'),
(17, 356, 'Andhra Pradesh'),
(18, 356, 'Arunachal Pradesh'),
(19, 356, 'Assam'),
(20, 356, 'Chandigarh'),
(21, 356, 'Chhattisgarh'),
(22, 356, 'Dadra &amp; Nagar Haveli'),
(23, 356, 'Daman &amp; Diu'),
(24, 356, 'Delhi'),
(25, 356, 'Goa'),
(26, 356, 'Gujarat'),
(27, 356, 'Haryana'),
(28, 356, 'Himachal Pradesh'),
(29, 356, 'Jammu &amp; Kashmir'),
(30, 356, 'Jharkand'),
(31, 356, 'Karnataka'),
(32, 356, 'Lakshadeep'),
(33, 356, 'MadhyaPradesh'),
(34, 356, 'Maharashtra'),
(35, 356, 'Manipur'),
(36, 356, 'Meghalaya'),
(37, 356, 'Mizoram'),
(38, 356, 'Nagaland'),
(39, 356, 'Orissa'),
(40, 356, 'Pondicherry'),
(41, 356, 'Punjab'),
(42, 356, 'Rajasthan'),
(43, 356, 'Sikkim'),
(44, 356, 'Tamil Nadu'),
(45, 356, 'Tripura'),
(46, 356, 'Uttar Pradesh'),
(47, 356, 'Uttaranchal'),
(48, 356, 'West Bengal');

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

--
-- Table structure for table `manage_time`
--

CREATE TABLE IF NOT EXISTS `manage_time` (
  `time_id` int(11) NOT NULL AUTO_INCREMENT,
  `value` time NOT NULL,
  `time_tag` enum('AM','PM') NOT NULL DEFAULT 'AM',
  `day_tag` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`time_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

--
-- Dumping data for table `manage_time`
--

INSERT INTO `manage_time` (`time_id`, `value`, `time_tag`, `day_tag`) VALUES
(2, '09:30:00', 'AM', '0'),
(9, '04:30:00', 'PM', '0');

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

--
-- Table structure for table `member`
--

CREATE TABLE IF NOT EXISTS `member` (
  `member_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `member_type_id` int(11) NOT NULL,
  `salutation` varchar(20) NOT NULL,
  `first_name` varchar(100) DEFAULT NULL,
  `surname` varchar(100) NOT NULL,
  `area` varchar(255) NOT NULL,
  `address` text NOT NULL,
  `username` varchar(100) NOT NULL,
  `password` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `mobile` varchar(255) NOT NULL,
  `status` enum('Y','N') NOT NULL DEFAULT 'N',
  `image_name` varchar(255) NOT NULL,
  `unique_code` varchar(50) NOT NULL,
  `registration_date` datetime NOT NULL,
  PRIMARY KEY (`member_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='Member master' AUTO_INCREMENT=10003 ;

--
-- Dumping data for table `member`
--

INSERT INTO `member` (`member_id`, `member_type_id`, `salutation`, `first_name`, `surname`, `area`, `address`, `username`, `password`, `email`, `mobile`, `status`, `image_name`, `unique_code`, `registration_date`) VALUES
(10002, 1, 'ffg', 'vijay', 't p', 'malappuram', 'fgsd sdgsd', 'vijay', 'a152e841783914146e4bcd4f39100686', 'tpvijay@gmail.com', '578968', 'Y', '14102463602539470014102463606079koala.jpg', '', '2014-09-09 12:36:01');

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

--
-- Table structure for table `message`
--

CREATE TABLE IF NOT EXISTS `message` (
  `message_id` int(11) NOT NULL AUTO_INCREMENT,
  `astro_member_id` bigint(20) NOT NULL,
  `description` text NOT NULL,
  `added_date` datetime NOT NULL,
  `status` enum('Y','N') NOT NULL DEFAULT 'Y',
  PRIMARY KEY (`message_id`),
  KEY `astro_member_id` (`astro_member_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `message`
--

INSERT INTO `message` (`message_id`, `astro_member_id`, `description`, `added_date`, `status`) VALUES
(1, 1, 'fdghdfh', '2014-05-13 17:58:53', 'Y');

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

--
-- Table structure for table `module_settings`
--

CREATE TABLE IF NOT EXISTS `module_settings` (
  `module_settings_id` int(11) NOT NULL AUTO_INCREMENT,
  `keys` varchar(50) NOT NULL,
  `values` varchar(50) NOT NULL,
  PRIMARY KEY (`module_settings_id`),
  UNIQUE KEY `keys` (`keys`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=49 ;

--
-- Dumping data for table `module_settings`
--

INSERT INTO `module_settings` (`module_settings_id`, `keys`, `values`) VALUES
(1, 'CONTENT_EXTENSION', 'html'),
(2, 'DIR_VIDEO_GALLERY', 'DIR_ROOT . userfiles/video_gallery/'),
(3, 'URI_VIDEO_GALLERY', 'URI_ROOT . userfiles/video_gallery/'),
(4, 'DIR_MEMBER', 'DIR_ROOT . userfiles/member_gallery/'),
(5, 'URI_MEMBER', 'URI_ROOT . userfiles/member_gallery/'),
(6, 'MEMBER_THUMB_WIDTH', '115'),
(7, 'MEMBER_THUMB_HEIGHT', '132'),
(8, 'MEMBER_MIN_WIDTH', '500'),
(9, 'MEMBER_MIN_HEIGHT', '375'),
(10, 'MEMBER_MAX_WIDTH', '800'),
(11, 'MEMBER_MAX_HEIGHT', '600'),
(12, 'DIR_PROFILE', 'DIR_ROOT . userfiles/profile_gallery/'),
(13, 'URI_PROFILE', 'URI_ROOT . userfiles/profile_gallery/'),
(14, 'PROFILE_THUMB_WIDTH', '132'),
(15, 'PROFILE_THUMB_HEIGHT', '144'),
(16, 'PROFILE_MIN_WIDTH', '500'),
(17, 'PROFILE_MIN_HEIGHT', '375'),
(18, 'PROFILE_MAX_WIDTH', '800'),
(19, 'PROFILE_MAX_HEIGHT', '600'),
(20, 'DIR_PROFILE_IMAGE_GALLERY', 'DIR_ROOT . userfiles/profile_image_gallery/'),
(21, 'URI_PROFILE_IMAGE_GALLERY', 'URI_ROOT . userfiles/profile_image_gallery/'),
(22, 'BANNER_THUMB_WIDTH', '1086'),
(23, 'BANNER_THUMB_HEIGHT', '407'),
(24, 'BANNER_MIN_WIDTH', '1086'),
(25, 'BANNER_MIN_HEIGHT', '407'),
(26, 'BANNER_MAX_WIDTH', '1086'),
(27, 'BANNER_MAX_HEIGHT', '407'),
(28, 'DIR_BANNER', 'DIR_ROOT . userfiles/banner_gallery/'),
(29, 'URI_BANNER', 'URI_ROOT . userfiles/banner_gallery/'),
(30, 'DIR_DOWNLOADS', 'DIR_ROOT . userfiles/profile_astro_match/'),
(31, 'URI_DOWNLOADS', 'URI_ROOT . userfiles/profile_astro_match/'),
(32, 'SUCCESS_STORY_THUMB_WIDTH', '180'),
(33, 'SUCCESS_STORY_THUMB_HEIGHT', '113'),
(34, 'SUCCESS_STORY_MIN_WIDTH', '636'),
(35, 'SUCCESS_STORY_MIN_HEIGHT', '366'),
(36, 'SUCCESS_STORY_MAX_WIDTH', '800'),
(37, 'SUCCESS_STORY_MAX_HEIGHT', '600'),
(38, 'DIR_SUCCESS_STORY', 'DIR_ROOT . userfiles/success_story_gallery/'),
(39, 'URI_SUCCESS_STORY', 'URI_ROOT . userfiles/success_story_gallery/'),
(40, 'DIR_MEDIA', 'DIR_ROOT . userfiles/media/'),
(41, 'URI_MEDIA', 'URI_ROOT . userfiles/media/'),
(42, 'ASTRO_THUMB_WIDTH', '244'),
(43, 'ASTRO_THUMB_HEIGHT', '210'),
(44, 'ASTRO_MIN_WIDTH', '500'),
(45, 'ASTRO_MIN_HEIGHT', '375'),
(46, 'ASTRO_MAX_WIDTH', '800'),
(47, 'ASTRO_MAX_HEIGHT', '600'),
(48, 'DIR_TEMP', 'DIR_ROOT . userfiles/tmp/');

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

--
-- Table structure for table `occupation`
--

CREATE TABLE IF NOT EXISTS `occupation` (
  `occupation_id` int(11) NOT NULL AUTO_INCREMENT,
  `occupation_name` varchar(255) NOT NULL,
  PRIMARY KEY (`occupation_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=82 ;

--
-- Dumping data for table `occupation`
--

INSERT INTO `occupation` (`occupation_id`, `occupation_name`) VALUES
(1, 'Accountant'),
(2, 'Actor'),
(3, 'Air Hostess'),
(4, 'Airline Professional'),
(5, 'Animator'),
(6, 'Architect'),
(7, 'Artist'),
(8, 'Astrologer'),
(9, 'Bank Officer'),
(10, 'Bank staff'),
(11, 'Beautician'),
(12, 'Business'),
(13, 'Captain'),
(14, 'Chartered Accountant'),
(15, 'Computer Professional'),
(16, 'Computer Programmer'),
(17, 'Consultant'),
(18, 'Contractor'),
(19, 'Counsellor'),
(20, 'Customer Care Assistant'),
(21, 'Deacon'),
(22, 'Defence'),
(23, 'Dentist'),
(24, 'Dietitian'),
(25, 'Doctor'),
(26, 'Driver'),
(27, 'Electrician'),
(28, 'Engineer'),
(29, 'Entrepreneur'),
(30, 'Executive'),
(31, 'Farmer'),
(32, 'Fashion Designer'),
(33, 'Finance Professional'),
(34, 'Government Staff'),
(35, 'Gulf based'),
(36, 'Hospitality'),
(37, 'Hotel Professional'),
(38, 'Insurance Agent'),
(39, 'Interior Designer'),
(40, 'Journalist'),
(41, 'Lab Technician'),
(42, 'Lawyer'),
(43, 'Lecturer'),
(44, 'Management Professional'),
(45, 'Marketing Professional'),
(46, 'Media Professional'),
(47, 'Medical Representative'),
(48, 'Merchant navy'),
(49, 'Microbiologist'),
(50, 'NRI'),
(51, 'Not employed'),
(52, 'Nurse'),
(53, 'Office Staff'),
(54, 'Other'),
(55, 'Paramedical Staff'),
(56, 'Pharmacist'),
(57, 'Physiotherapist'),
(58, 'Pilot'),
(59, 'Police'),
(60, 'Politician'),
(61, 'Priest'),
(62, 'Professor'),
(63, 'Psychologist'),
(64, 'Sales Executive'),
(65, 'Salesman'),
(66, 'Scientist'),
(67, 'Self Employed'),
(68, 'Social Worker'),
(69, 'Sportsman'),
(70, 'Student'),
(71, 'Supervisor'),
(72, 'Teacher'),
(73, 'Technical staff'),
(74, 'Trader'),
(75, 'Trainer'),
(76, 'Tutor'),
(77, 'Videographer/Photographer'),
(78, 'Web Designer'),
(79, 'Web Developer'),
(80, 'Wholesale Businessman'),
(81, 'Any');

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

--
-- Table structure for table `page_content`
--

CREATE TABLE IF NOT EXISTS `page_content` (
  `page_content_id` int(10) NOT NULL AUTO_INCREMENT,
  `page_name` varchar(255) DEFAULT NULL,
  `title` varchar(250) NOT NULL,
  `content` longtext,
  `added_date` datetime NOT NULL,
  `modified_date` datetime NOT NULL,
  `status` enum('Y','N') NOT NULL DEFAULT 'Y',
  `order_id` int(11) NOT NULL,
  PRIMARY KEY (`page_content_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;

--
-- Dumping data for table `page_content`
--

INSERT INTO `page_content` (`page_content_id`, `page_name`, `title`, `content`, `added_date`, `modified_date`, `status`, `order_id`) VALUES
(1, 'index.html', 'Success Stories', 'Join the biggest exclusive matrimonial portal for malayalees offering you lakhs of profilesThe unique matching tools on gingermarry.com enables you to find your perfect partner.find your perfect partner.', '2013-10-10 16:15:36', '2013-10-25 13:05:48', 'Y', 0),
(2, 'index.html', 'Astrology', 'Join the biggest exclusive matrimonial portal for malayalees offering you lakhs of profiles', '2013-10-25 13:18:14', '2013-10-31 11:19:24', 'Y', 0),
(3, 'index.htnl', 'why gingermarry.com', '<ul>\r\n    <li><span style="font-size: 12px;"><strong>Join the First Choice Site for Malayalies:</strong></span></li>\r\n    <li>Join the biggest exclusive matrimonial portal for malayalies offering you lakhs of profiles.</li>\r\n    <li><span style="font-size: 12px;"><strong>Way to Perfect Matches:</strong></span></li>\r\n    <li>The unique matching tools on gingermarry.com enables you to find your perfect partner. Safe and Secure</li>\r\n    <li>gingermarry.com offers you enhanced security features that creates a safe and secure platform for partner search.</li>\r\n    <li><span style="font-size: 12px;"><strong>Customer Care Offices:</strong></span></li>\r\n    <li>Easily accessible customer care centres and a committed and professional service team ensure that help is just a call or click away.</li>\r\n    <li><span style="font-size: 12px;"><strong>Easy to use navigation:</strong></span></li>\r\n    <li>An easy and convenient set of features allow you to manage your search results and communication effectively.</li>\r\n</ul>', '2013-11-07 12:00:40', '2013-11-07 12:25:47', 'Y', 0),
(4, 'index.html', 'Live Astrology', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry''s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.  It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using ''Content here, content here'', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for ''lorem ipsum'' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like).    Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of &quot;de Finibus Bonorum et Malorum&quot; (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, &quot;Lorem ipsum dolor sit amet..&quot;, comes from a line in section 1.10.32.  The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from &quot;de Finibus Bonorum et Malorum&quot; by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.', '2013-12-04 16:54:58', '2013-12-04 16:54:58', 'Y', 0),
(5, 'index.html', 'Wedding Photography', 'Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of &quot;de Finibus Bonorum et Malorum&quot; (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, &quot;Lorem ipsum dolor sit amet..&quot;, comes from a line in section 1.10.32. <br />\r\n<br />\r\n<br />\r\nThe standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from &quot;de Finibus Bonorum et Malorum&quot; by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.', '2013-12-04 17:43:59', '2013-12-04 17:43:59', 'Y', 0),
(6, 'index.html', 'Catering Service', 'Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of &quot;de Finibus Bonorum et Malorum&quot; (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, &quot;Lorem ipsum dolor sit amet..&quot;, comes from a line in section 1.10.32. <br />\r\n<br />\r\nThe standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from &quot;de Finibus Bonorum et Malorum&quot; by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.', '2013-12-04 17:44:38', '2013-12-04 17:44:38', 'Y', 0),
(7, 'index.html', 'Stage Decoration', '&nbsp;Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of &quot;de Finibus Bonorum et Malorum&quot; (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, &quot;Lorem ipsum dolor sit amet..&quot;, comes from a line in section 1.10.32. <br />\r\n<br />\r\nThe standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from &quot;de Finibus Bonorum et Malorum&quot; by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.', '2013-12-04 17:45:09', '2013-12-04 17:45:09', 'Y', 0),
(8, 'index.html', 'Associate With Us', 'Terms &amp; Conditions<br />\r\n1. Use of the Website<br />\r\nWelcome to m4marry.com owned by Malayala Manorama Ltd (hereinafter referred to as &quot;the Company&quot;, which term shall mean and include its subsidiaries, affiliates, partners, shareholders, directors, executives, officers, employees, agents, successors-in-interest and permitted assigns).<br />\r\nYour use of this Website or access of any of the services provided on the Website is subject to your acceptance of these terms and conditions (&quot;Terms&quot; or &quot;Terms and Conditions&quot;). Therefore, please read these Terms carefully. If you require any clarification about these Terms, please contact support@m4marry.com and obtain such clarification before using this Website.<br />\r\nYOUR USE OF THE WEBSITE SIGNIFIES YOUR AGREEMENT TO ALL TERMS AND CONDITIONS, POLICIES AND NOTICES CONTAINED HEREIN. IF YOU DO NOT ACCEPT ANY OF THE PROVISIONS OF THE TERMS AND CONDITIONS, POLICIES OR NOTICES CONTAINED ON THE WEBSITE, DO NOT USE OR ACCESS THE WEBSITE.<br />\r\nFor the purposes of this Website, &quot;User&quot; shall mean any person who uses the Website, and/or any of the services provided on the Website including but not limited to any person who posts any content including but not limited to text, data, images, video, information, and other materials or services on the Website or who views such content or materials. The Website shall be deemed to be used by you when it is loaded and/or continues to be loaded in temporary or permanent memory of your mobile phone, computer or any other device or in the internet browser thereof. The Company''s own records of the use of the Website maintained through computer systems or otherwise shall be deemed accepted as conclusive and binding proof of such use.<br />\r\nThe Company reserves the absolute discretion to amend, delete or supplement any of these Terms at any time, which amendment, deletion or supplement as the case may be shall automatically become binding on the User when the amendment, deletion or supplement is made on the Website.<br />\r\nThe use of this Website by you may be discontinued, terminated or limited at any time by the Company without any notice to you if you violate any part of the Terms or for any reason whatsoever.<br />\r\n2. Eligibility<br />\r\nThis Website is intended to facilitate lawful marriages between persons by providing a medium for contact between such persons. It is therefore essential that Users are capable of entering into a legal and binding contract of marriage as per the law applicable to them. By using this Website, therefore you confirm that you are/ you are registering for a person who is:<br />\r\nA. 18 years or above (if you are a woman) or 21 years or above (if you are a man);<br />\r\nB. Legally competent to enter into a valid contract of marriage as per the law applicable to you; and<br />\r\nC. Not prohibited or prevented by any applicable law for the time being in force from entering into a valid contract of marriage<br />\r\nThe Company reserves the right to forthwith terminate your use and / or registration with the Website without refund of any of subscription fee paid, if at any time the Company is, in its sole discretion, of the opinion or has any reason to believe that, you are not eligible to use this Website or that you have made any misrepresentation about your eligibility.<br />\r\n3. Registration with the Website<br />\r\nTo avail some of the services on the Website such as express interest in a member or of premium services offered by the company Users will be required to register with the Website. The first step in the registration process is for you to fill up the registration form available at m4marry.com/register. During the process of registration or otherwise, you may be required to furnish information, (personal or otherwise). You shall ensure that you furnish accurate, complete and up-to-date information.<br />\r\nUpon successful registration, you will be given a user name and password. By applying for registration you confirm and agree that you will be the sole and exclusive owner and that you accept sole responsibility for the use, confidentiality and protection of the user name and the password as well as for all actions initiated using your user name and password. Your registration with the Website is for your personal use. You may not authorize others to use your user name and password and you may not assign or transfer your user name and / or password to any other person or entity. All statements made and acts or omissions that occur while your user name and password are being used shall be deemed to have originated conclusively from your end and you shall be responsible for the same and/or any misuse thereof.<br />\r\nMultiple registrations of the same person are not allowed on the Website. The Company reserves the right to deactivate all multiple registrations by the same User without any refund of subscription fees.<br />\r\nYou are required to immediately notify the Company in writing on becoming aware of any loss, theft or unauthorized use of your user name and / or password or any inaccurate information in relation to your use of the Website or our services. While the Company disclaims any liability for such loss, theft or unauthorised use and consequences thereof, on receipt of such notification from you, the Company will take such steps as reasonably possible to block your user name and on a request duly made, generate a new user name and password for you.<br />\r\nIf any information provided by you for registration or otherwise is found to be untrue, inaccurate, not current or incomplete, or the Company has grounds to suspect that such information is untrue, inaccurate, not current or incomplete, the Company has the right to suspend or terminate your registration with the Website and refuse you any and all current or future use of the Website (or any portion thereof).<br />\r\nThe Company reserves the right (in its sole discretion) to refuse you registration on the Website, terminate your registration and remove or edit any Content posted on the Website using your user name and password.<br />\r\n4. Content<br />\r\nYou are responsible for the content and information including your profile, photograph and other content including communication with other Users (&quot;Content&quot;) you post or transmit through the Website.<br />\r\nYou hereby represent and warrant that you own all rights, title and interest in your Content or have the necessary licenses, rights, consents, and permissions to post and / or use the said Content.<br />\r\nYou will retain all your ownership rights in Content you post on the Website. However, by submitting the Content to the Website, you hereby grant the Company a worldwide, non-exclusive, royalty-free, sub-licensable and transferable license to use, reproduce, distribute, prepare derivative works of, display, publish, communicate to the public and perform the Content on the Website, in connection with the Website and the Company''s business and services, including without limitation for promoting, communicating to the public and redistributing part or all of the Content (and derivative works thereof) in any media formats and through any media channels. You hereby also grant the Company and its authorised third parties and each User of the Website a non-exclusive license to access your Content and to use, reproduce, distribute, prepare derivative works of, display, communicate to the public and perform such Content. While the Company does not accept any obligation to monitor the Content, the Company reserves the right to review and / or verify the authenticity, accuracy and quality of Content posted by you on the Website and to determine whether the said Content is in compliance with these Terms. If the Company is not able to verify the Content or any part thereof to its satisfaction or if the Content is found not to be in compliance with these Terms, the Company may delete the Content and / or terminate your registration with the Website without a refund of any subscription paid by you. Notwithstanding the Company''s right to verify the Content, all Content is the sole responsibility of the User from whom such Content originates and shall be at the said User''s sole risk and consequences. The Company does not does not guarantee the accuracy, integrity or quality of such Content. Users wishing to use the Content posted by third parties on the Website are advised to independently verify the Content. You shall be solely responsible for your Content and for all consequences arising due to or out of use of the Website and the posting of your Content on the Website including but not limited to all consequences that may arise due to third parties viewing/accessing/downloading your Content and/or arising due to the Website hosting/publishing/communicating your Content to the public. Under no circumstances will the Company be liable in any way for any Content, including, but not limited to, any errors or omissions in any Content, or any loss or damage of any kind incurred as a result of the use of any Content made available through the Website or as a result thereof.<br />\r\nThe company reserves the right to delete the content from the Website after a period of two years unless the user specifically in writing requests for a further period.<br />\r\nYou understand and agree that when using the Website, you will be exposed to Content from different sources, and that the Company shall not be responsible for the accuracy, usefulness, safety, or intellectual property rights of or relating to such Content. You further understand and acknowledge that you may be exposed to Content that is inaccurate, offensive, indecent, or objectionable, and you hereby waive, any legal or equitable rights or remedies you have or may have against the Company with respect thereto, and agree to indemnify and hold the Company harmless to the fullest extent allowed by law regarding all matters related to your use of the Website.<br />\r\nIn the interest of the security and privacy of our Users, the Company reserves the right to restrict the number of communications which any User may send to another User in any 24-hour period to a number which the Company deems appropriate in its sole discretion.<br />\r\nIf any content on the Website does not adhere to these terms and conditions please send an email to support@m4marry.com indicating the non-adherence so as to enable the Company to take appropriate action as deemed necessary by the Company.<br />\r\nThe user has to inform the Company that the User has married another User of the Website and he wishes to update the Website with a success story. The Company reserves the right to request for such documents as proof of a marriage as it may deem fit from the User or both the Users. The Company also reserves the right to publish the success story at its discretion.<br />\r\n5. Restrictions on Use<br />\r\nYou agree that :<br />\r\nA. Your Content shall not contain any material that is copyrighted, protected by trade secret or otherwise subject to third party intellectual property rights or proprietary rights, including privacy and publicity rights, unless you are the owner of such rights or have written permission from their rightful owner to post the material and to grant the Company all of the license rights granted herein.<br />\r\nB. You shall not upload, post, email, transmit or otherwise make available any Content that you do not have a right to make available under any law or under contractual or fiduciary relationships (such as inside information, proprietary and confidential information learned or disclosed as part of employment relationships or under nondisclosure agreements, without limitation).<br />\r\nC. Your Content shall not contain falsehoods or misrepresentations that could damage the Company or any third party.<br />\r\nD. Your Content shall not contain material that is abusive, unlawful, obscene, vulgar, defamatory, libelous, threatening, pornographic, profane, threatening, abusive, harassing, hateful, indecent, racially, religiously or ethnically offensive or otherwise objectionable or offensive in any manner, or encourages conduct that would be considered a criminal offence, give rise to civil, tortious or criminal liability or is otherwise inappropriate.<br />\r\nE. You shall not utilise the Website or its services in any manner whatsoever so as to contact or communicate with minors (i.e those below the age of eighteen).<br />\r\nF. You shall not forge headers or otherwise manipulate identifiers in order to disguise the origin of any content transmitted through the service.<br />\r\nG. Your Content shall not contain advertisements or solicitations of business.<br />\r\nH. Your Content shall not contain any chain letters or pyramid schemes.<br />\r\nI. You shall not impersonate another person or entity.<br />\r\nJ. You shall not intentionally or unintentionally violate any applicable local, state, national or international law while using or accessing the Website.<br />\r\nK. Your Content shall not contain any virus or other harmful component.<br />\r\nL. You will use the Website strictly for the your personal and non-commercial use.<br />\r\nM. You will not take any action that imposes an unreasonable or disproportionately large load on the Website servers or systems, or any servers or systems used by the Company.<br />\r\nN. You will not to use the Website for any illegal purpose or in any manner inconsistent with these Terms.<br />\r\nFurther, you shall not, except as permitted by these Terms :<br />\r\nA. Reverse engineer, decompile, disassemble, copy, reproduce, distribute, modify, transmit, perform, publish or create derivative works from or in any way exploit any part of the Website in violation of these Terms or the laws of any country.<br />\r\nB. Create a database in electronic or structured manual form by systematically downloading and storing the entire Website or part thereof except such information as relates or concerns you directly.<br />\r\nC. Cache or permit caching by any person.<br />\r\nD. Send unsolicited email or other correspondence to any other User.<br />\r\nE. Do any act that violates the Company''s (or any third party''s) intellectual property rights in the Website.<br />\r\nF. Engage in any fraudulent, abusive or illegal activity, including but not limited to any communication or solicitation designed or intended to fraudulently obtain the password or any private information of any other User.<br />\r\nG. Use the Website to violate the security of any computer or computer network, crack passwords or security encryption codes, transfer or store illegal material including threatening or obscene material or engage in any kind of illegal activity.<br />\r\nH. Run any mail list or any form of auto-responder, or spam on the Website or any processes that are run or are activated while the User is not logged on or engage in any virus attack or denial of service or attach or engage in any activity designed and/or intended to interfere with the working of Website for any duration of time.<br />\r\nI. Use any information obtained from the Website in order to harass, abuse, or harm another person, or in order to contact, advertise to, solicit, or sell to any User without their prior explicit consent.<br />\r\nJ. Collect or harvest any personally identifiable information, including account names, from the Website, nor to use the communication systems provided by the Website for any commercial solicitation purposes. User agrees not to solicit, for commercial purposes, any users of the Website with respect to their Content.<br />\r\nK. Use or launch any automated system, including without limitation, &quot;robots,&quot; &quot;spiders,&quot; &quot;offline readers,&quot; etc., that accesses the Website in a manner that sends more request messages to Website servers in a given period of time than a human can reasonably produce in the same period by using a convention on-line web browser.<br />\r\n6. Privacy and Security Policy<br />\r\nThe Company is committed to protecting the User''s privacy and shall take all efforts to protect any personal data provided to the Website by reasonable security safeguards against such risks as loss or unauthorised use, destruction, use, modification or disclosure of data. Although we will strive to safeguard the confidentiality of your personally identifiable information, transmissions made by means of the Internet cannot be made absolutely secure. By using this site, you understand and agree that we will have no liability for disclosure of your information due to errors in transmission or unauthorized acts of third parties.<br />\r\nThe Website uses cookies to track usage of the path of a User, to collect site statistical information and improve your customer experience. Since most web browsers automatically accept cookies, you can edit your browser options to block them if you does not want the Website to use cookies to track usage of the your path.<br />\r\nOur servers may also automatically collect information about your computer when you visit the Website, including but not limited to the type of browser software and version you use, the operating system and platform you are running, the website that referred you to us, your IP or internet protocol address used to connect your computer to the Internet, average time spent on our site, pages viewed, information searched for, access times, &quot;clickstream data&quot; and other relevant information about your online experience.<br />\r\nThe Company undertakes not to disclose, except as otherwise provided, the personal information provided by the User to any person, unless such action is necessary to :-<br />\r\nA. Conform to legal requirements or comply with legal process;<br />\r\nB. Protect and defend The Company or its affiliates'' rights, interests or property;<br />\r\nC. Enforce the terms and conditions of these Terms;<br />\r\nD. Enable the Company or its affiliated/authorized third parties to provide access to the Website (including technical maintenance thereof) and/or services to Users;<br />\r\nE. Share the personal information with third parties for the purpose of the Website;<br />\r\nF. Allow the User to use specific account information;<br />\r\nG. To contact the User when required including to provide the User with information (including information for promotion of the Company''s services).<br />\r\nBy Using the Website, you agree to receive certain specific email from the Company relating to your membership or any alerts of any activity on the site or those of content promotion on the site. Should you not want to receive such e-mail, you may at any time cancel your subscription to such e-mails by sending a mail with the request for the same to support@m4marry.com.<br />\r\nYou hereby confirm that as on the date of your registration with the Website, you have not registered yourselves on the Do Not Disturb (DND) subscriber list with any telecom operator / authority. In the event, you register yourselves as a Do Not Disturb (DND) subscriber, you hereby confirm that you do not have any objection to receiving messages (promotional or otherwise) from the Company or any of its affiliate companies.<br />\r\n7. Collection and Use of Personal Information<br />\r\nTo register on the Website you will be required to provide certain personal information. This information includes (but is not limited to) data that specifically identifies an individual, such as a user name, name, address, telephone number, e-mail address, religion, caste, sex, astrological information, photos, employment details, income details, family background, physical and health data etc. Please refer to FAQ section to identify the information that will be available to all Users of the Website and that which will be available only to those registered with our Website.<br />\r\nWe offer you choices when we ask for personal information, whenever reasonably possible. You may decline to provide personal information to us and/or refuse cookies in your browser, although please be aware that some of our features or services may not function properly as a result. You will have access to your personal information posted on our Website and you may edit, delete or modify the same from time to time.<br />\r\nUser understand that the Company does not guarantee any confidentiality with respect to your Content (including any personal information) other than as specified in the Privacy and Security Policy.<br />\r\n8. Intellectual Property Rights<br />\r\nAll parts of the Website except Content posted by User''s of the Website are owned by the Company and / or its suppliers/affiliates/business partners and is protected by intellectual property rights law including copyright laws, international treaty provisions, and these Terms. User acknowledges that the Website is highly proprietary in nature and that unauthorized copying, transfer or use shall cause the Company irreparable injury that cannot be adequately compensated for by means of monetary damages. Any reproduction, reverse engineering, decompiling, disassembling, modification, copying, distribution, transmission, display, publishing, sublicensing, creation of derivative works from, transferring or redistribution of the Website other than as may be specifically permitted as per these terms is expressly prohibited by law, and shall result in severe civil and criminal penalties. The Company shall be entitled to obtain equitable relief (including all damage, direct, indirect, consequential and exemplary), over and above all other remedies available to the Company to protect its interests therein. Neither the availability of, nor anything contained within the Website shall be construed as conferring any license to any of the Company or any third party''s intellectual property rights, other or further than as expressly provided in these Terms, whether by implication, estoppel or otherwise.<br />\r\n9. Disclaimer<br />\r\nTHE WEBSITE AND ALL SERVICES PROVIDED THEREIN ARE PROVIDED ON AN &quot;AS IS&quot; AND &quot;AS AVAILABLE&quot; BASIS. THE COMPANY EXPRESSLY DISCLAIMS ALL WARRANTIES OF ANY KIND, WHETHER EXPRESS OR IMPLIED OR STATUTORY, INCLUDING, BUT NOT LIMITED TO THE IMPLIED WARRANTIES OF FITNESS FOR A PARTICULAR PURPOSE, DATA ACCURACY AND COMPLETENESS, AND ALL WARRANTIES RELATING TO VIRUSES AND NON-INFRINGEMENT IN THE WEBSITE OR ANY SERVICES PROVIDED BY THE WEBSITE. THE COMPANY MAKES NO REPRESENTATIONS OR WARRANTIES, EITHER EXPRESS OR IMPLIED THAT THE USE OF THE WEBSITE WILL NOT INFRINGE ANY PATENT, COPYRIGHT OR OTHER RIGHT OF ANY THIRD PARTY. NO ADVICE OR INFORMATION, WHETHER ORAL OR WRITTEN, OBTAINED BY USER THROUGH, OR FROM, THE WEBSITE OR IN ANY OTHER MANNER SHALL CREATE ANY WARRANTY NOT EXPRESSLY STATED HEREIN.<br />\r\nTHE COMPANY MAKES NO WARRANTY THAT THE WEBSITE WILL MEET USER''S REQUIREMENTS, OR THAT THE WEBSITE WILL BE UNINTERRUPTED, TIMELY, SECURE, OR ERROR FREE; NOR DOES THE COMPANY MAKE ANY WARRANTY AS TO THE RESULTS THAT MAY BE OBTAINED FROM THE USE OF THE WEBSITE OR AS TO THE ACCURACY OR RELIABILITY OF THE INFORMATION/MATERIAL ON THE WEBSITE.<br />\r\nTHE COMPANY DOES NOT ENDORSE, SUPPORT, VERIFY, REPRESENT OR GUARANTEE THE TRUTHFULNESS, ACCURACY, OR RELIABILITY OF ANY INFORMATION OR COMMUNICATIONS POSTED ON THE WEBSITE OR ENDORSE ANY OPINIONS EXPRESSED BY USERS. USER HEREBY ACKNOWLEDGES THAT ANY RELIANCE ON MATERIAL POSTED BY THE COMPANY OR OTHER USERS WILL BE AT USER''S OWN RISK.<br />\r\nTHE EXCHANGE OF USER PROFILES OR COMMUNICATION THROUGH OR USING THE WEBSITE IS NOT A MATRIMONIAL OFFER AND/OR RECOMMENDATION FROM/BY THE COMPANY. THE COMPANY SHALL NOT BE RESPONSIBLE FOR ANY LOSS OR DAMAGE TO ANY INDIVIDUAL ARISING OUT OF, OR SUBSEQUENT TO, ANY RELATIONS (INCLUDING BUT NOT LIMITED TO MATRIMONIAL RELATIONS) ESTABLISHED BETWEEN USERS PURSUANT TO THE USE OF THE WEBSITE.<br />\r\n10. Limitation of Liability<br />\r\nUSER AGREES THAT IN NO EVENT SHALL THE COMPANY BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, PUNITIVE, CONSEQUENTIAL OR EXEMPLARY DAMAGES, (INCLUDING, BUT NOT LIMITED TO, DAMAGES CAUSED BY PERSONAL INJURY, LOSS OF REPUTATION, LOSS OF PROFITS, USE, DATA OR OTHER INTANGIBLE PROPERTY, BUSINESS INTERRUPTION, LOSS OF PRIVACY, LOSS OF USER CONTENT, OR ANY OTHER PECUNIARY OR PERSONAL LOSS) TO USER OR ANY THIRD PARTY WHATSOEVER RESULTING FROM ANY (I) ERRORS, MISTAKES, OR INACCURACIES ON THE WEBSITE, (II) PERSONAL INJURY OR PROPERTY DAMAGE, OF ANY NATURE WHATSOEVER, RESULTING FROM USER''S ACCESS TO AND USE OF THE WEBSITE, (III) ANY UNAUTHORIZED ACCESS TO OR USE OF THE SECURE SERVERS OF THE WEBSITE AND/OR ANY AND ALL PERSONAL INFORMATION AND/OR FINANCIAL INFORMATION STORED THEREIN, (IV) ANY BUGS, VIRUSES, TROJAN HORSES, OR THE LIKE, WHICH MAY BE TRANSMITTED TO OR THROUGH THE WEBSITE BY ANY THIRD PARTY, (V) ANY ERRORS OR OMISSIONS IN ANY CONTENT OR FOR ANY LOSS OR DAMAGE OF ANY KIND INCURRED AS A RESULT OF USER''S USE OF ANY CONTENT POSTED, EMAILED, TRANSMITTED, OR OTHERWISE MADE AVAILABLE VIA THE WEBSITE, (VI) ANY UNAVAILABILITY OF THE WEBSITE OR PARTS THEREOF OR DELAY IN ANY REAL TIME SERVICE OR INFORMATION PROVIDED BY THE WEBSITE, (VII) ANY RELATIONS BETWEEN USERS ARISING OUT OF OR PURSUANT TO USE OF THE WEBSITE OR ANY CONTENT POSTED ON THE WEBSITE OR COMMUNICATION EXCHANGED WITH ANY OTHER USER USING THE FACILITY PROVIDED BY THE OR USING INFORMATION OBTAINED FROM THE WEBSITE, OR (VIII) ERROR, INTERRUPTION, SUSPENSION OR TERMINATION OF, OR IN, THE WEBSITE WHETHER SUCH ERROR, INTERRUPTION, SUSPENSION OR TERMINATION WAS JUSTIFIED OR NOT, NEGLIGENT OR INTENTIONAL, INADVERTENT OR ADVERTENT OR ANY SERVICES PROVIDED BY OR THROUGH THE WEBSITE OR ANY PRODUCT PURCHASED THROUGH THE WEBSITE, WHETHER BASED ON WARRANTY, CONTRACT, TORT, OR ANY OTHER LEGAL THEORY, AND WHETHER OR NOT THE COMPANY IS ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. THE FOREGOING LIMITATION OF LIABILITY SHALL APPLY TO THE FULLEST EXTENT PERMITTED BY LAW.<br />\r\nUSER SPECIFICALLY ACKNOWLEDGES THAT THE COMPANY SHALL NOT BE LIABLE FOR USER POSTS OR THE DEFAMATORY, OFFENSIVE, OR ILLEGAL CONDUCT OF ANY THIRD PARTY (INCLUDING OTHER USERS) AND THAT THE RISK OF HARM OR DAMAGE FROM THE FOREGOING RESTS ENTIRELY WITH THE USER.<br />\r\n11. Indemnity<br />\r\nBy using this Website you agree to defend, indemnify, and hold harmless the Company, its officers, directors, employees and agents, from and against any and all claims, losses, obligations, liabilities, damages, costs, debt and expenses, including, without limitation, reasonable legal, expert and accounting fees, incurred in connection with any claims, actions or demands alleging or resulting from your :<br />\r\nA. Use of the Website using your user name and password or any material (including software and Contents) on the Website; or<br />\r\nB. User''s breach of the Terms, or<br />\r\nC. User''s violation of any third party right, including without limitation any copyright, property, or privacy right; or<br />\r\nD. Any claim that one of your Contents caused loss or damage to a third party or User; or<br />\r\nE. User''s violation of any law.<br />\r\nThis defence and indemnification obligation will survive these Terms and User''s use of the Website.<br />\r\n12. Third Party Sites<br />\r\nThird party websites to which links are given on this Website are not governed by these Terms and are governed by their own terms and conditions for use and privacy policy. The Company does not in any manner whatsoever authenticate, endorse, verify or certify these third party websites or any contents therein. Please note that a User shall click on links to third party websites at his / her sole risk and responsibility. On leaving our Website, (you can tell where you are by checking the URL in the location bar on your browser), you are advised to verify the terms and conditions governing the usage of such third party websites and their respective privacy policies and continue to use the said third party websites if their respective terms and conditions for use and privacy policies are acceptable to you. The Company expressly disclaims any warranties, liabilities or guarantees, express or implied, which may be attributable, in any manner whatsoever, to the use of any third party website by a User through a link provided on our Website.<br />\r\n13. Subscription Fees<br />\r\nAny subscription fee paid for registration with the Website or for availing any services therefrom shall NOT be reimbursed under any circumstances whatsoever.<br />\r\n14. General<br />\r\nThe operation of the Website may be interfered with by numerous factors outside of the Company''s control. The Company shall not be liable for any default in the Website operation, caused by circumstances beyond its control including but not restricted to acts of God, acts of the public, enemy, decrees or restraints by governmental authorities, internet, telecommunication, computer or utilities failure (including failures caused by (A) acts which impose unreasonably or disproportionately large loads on infrastructure or facilities such as &quot;flooding&quot;, &quot;mail bombing&quot; or &quot;crashing&quot; of the Website; or (B) any virus, time bombs or other computer programming routines that may damage, detrimentally interfere with, intercept or expropriate any system, data or personal information), strikes, war, riots, insurrections, civil commotion and other causes of such nature. In any such event, The Company shall for the duration of such event be relieved of any such obligation under this Agreement as is affected by the said event.<br />\r\nThe Company may schedule downtime in the Website for maintenance purposes and suspend any service by posting a notice of such downtime on the Website or such other manner as it deems fit. If there is any unscheduled down time in the Website during which no User can access any service, the Company shall use all reasonable endeavors to promptly restore the Website to its proper operating condition and notify the Users as soon as reasonably practicable after the Website is available for use again. The foregoing states the Company''s entire liability for any loss caused by downtime in the Website.<br />\r\nAny waiver by a party of a breach of any condition/s in the Terms by the other party shall not be construed as a waiver of any subsequent breach of any condition/s in the Terms.<br />\r\nIf any term, condition, clause or provision of the Terms becomes invalid or be so judged, the remaining terms, conditions, clauses and provisions shall be deemed severable and shall remain in full force.<br />\r\nThese Terms, and any rights and licenses granted hereunder, may not be transferred or assigned by User, but may be assigned by the Company without restriction.<br />\r\nThe Website and the User''s use of the Website and the provision of services by the Website are governed solely by Indian law, without regard to its conflict of law principles. This Website is deemed to be based in Kottayam, Kerala, India and any posting of Contents is deemed to have occurred in Kottayam, Kerala, India. The User hereby consents to submit to the exclusive jurisdiction and venue of courts in Kottayam, Kerala, India, to the exclusion of all other courts that may otherwise have had such jurisdiction in all matters, liability and disputes arising out of or relating to the use of this Website, any Contents and the provision of service by the Website. Use of this Website is unauthorized and prohibited in any jurisdiction that does not give effect to all provisions of the Terms including without limitation, this paragraph.<br />\r\nThe Company makes no claim that the Website and materials (including Contents) on the Website are appropriate for any particular purpose or audience, or that they may be downloaded outside of India. Access to the Website may not be legal by certain persons or in certain countries. If User accesses the Website from outside India, User is responsible for compliance with the laws of User''s jurisdiction. The Company accepts no liability whatsoever, direct or indirect for non-compliance by the Company or the Website with the laws of any country other than that of India.', '2013-12-04 17:46:03', '2014-01-23 16:30:07', 'Y', 0),
(9, 'index.html', 'Our Franchisees', '&nbsp;Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of &quot;de Finibus Bonorum et Malorum&quot; (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, &quot;Lorem ipsum dolor sit amet..&quot;, comes from a line in section 1.10.32. <br />\r\n<br />\r\nThe standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from &quot;de Finibus Bonorum et Malorum&quot; by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.', '2013-12-04 17:46:29', '2013-12-04 17:46:29', 'Y', 0),
(10, 'index.html', 'Sales Enquiry', '<div class="address1">\r\n<div class="add_head">Kochi (Head office)</div>\r\n<ul>\r\n    <li class="home_add">Gingermarry.com<br />\r\n    Lorem ipsum Co. Ltd<br />\r\n    L.K. Road, ernakulam</li>\r\n    <li class="home_phone">0484 4023569</li>\r\n    <li class="home_email">gingermarry@gmail.com</li>\r\n</ul>\r\n</div>\r\n<div class="address1">\r\n<div class="add_head">Kollam</div>\r\n<ul>\r\n    <li class="home_add">Gingermarry.com<br />\r\n    Lorem ipsum Co. Ltd<br />\r\n    L.K. Road, ernakulam</li>\r\n    <li class="home_phone">0484 4023569</li>\r\n    <li class="home_email">gingermarry@gmail.com</li>\r\n</ul>\r\n</div>\r\n<div class="address1">\r\n<div class="add_head">Kottayam</div>\r\n<ul>\r\n    <li class="home_add">Gingermarry.com<br />\r\n    Lorem ipsum Co. Ltd<br />\r\n    L.K. Road, ernakulam</li>\r\n    <li class="home_phone">0484 4023569</li>\r\n    <li class="home_email">gingermarry@gmail.com</li>\r\n</ul>\r\n</div>', '2013-12-04 17:47:00', '2013-12-04 17:51:06', 'Y', 0);

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

--
-- Table structure for table `parent`
--

CREATE TABLE IF NOT EXISTS `parent` (
  `parent_id` int(11) NOT NULL AUTO_INCREMENT,
  `member_id` int(11) NOT NULL,
  `profile_id` int(11) NOT NULL,
  `added_date` datetime NOT NULL,
  PRIMARY KEY (`parent_id`),
  KEY `member_id` (`member_id`),
  KEY `profile_id` (`profile_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `parent`
--


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

--
-- Table structure for table `profile`
--

CREATE TABLE IF NOT EXISTS `profile` (
  `profile_id` int(11) NOT NULL AUTO_INCREMENT,
  `salutation` varchar(250) NOT NULL,
  `first_name` varchar(255) NOT NULL,
  `surname` varchar(255) NOT NULL,
  `username` varchar(100) NOT NULL,
  `password` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `country_code` varchar(255) NOT NULL,
  `mobile` varchar(255) NOT NULL,
  `gender` enum('Male','Female') NOT NULL DEFAULT 'Male',
  `religion_id` int(11) NOT NULL,
  `caste_id` int(11) NOT NULL,
  `country_id` varchar(3) NOT NULL,
  `location_name` varchar(255) NOT NULL,
  `image_name` varchar(200) NOT NULL,
  `dob` date NOT NULL,
  `status` enum('Y','N') NOT NULL DEFAULT 'N',
  `registration_date` date NOT NULL,
  `order_id` int(11) NOT NULL,
  `photo_protect` enum('Y','N') NOT NULL DEFAULT 'N',
  `login_count` int(11) NOT NULL,
  `unique_code` varchar(255) NOT NULL,
  `login_date` datetime NOT NULL,
  `logout_date` datetime NOT NULL,
  `modified_date` datetime NOT NULL,
  `admin_status` enum('Y','N') NOT NULL DEFAULT 'N',
  `super_admin_status` enum('Y','N') NOT NULL DEFAULT 'N',
  `master_admin_status` enum('Y','N') NOT NULL DEFAULT 'N',
  `payment_status` enum('Y','N') NOT NULL DEFAULT 'N',
  `profile_visitedby` text NOT NULL,
  `guest_view` int(11) NOT NULL,
  `photo_password` varchar(255) NOT NULL,
  `delete_status` enum('Y','N') NOT NULL DEFAULT 'N',
  `view_status` enum('Y','N') NOT NULL DEFAULT 'N',
  `registration_type` enum('Normal','Quick') NOT NULL DEFAULT 'Normal',
  `login_timer` datetime NOT NULL,
  `direct_astro` int(11) NOT NULL DEFAULT '5',
  `software_astro` int(11) NOT NULL DEFAULT '5',
  `view_contact` int(11) NOT NULL DEFAULT '100',
  PRIMARY KEY (`profile_id`),
  KEY `religion_id` (`religion_id`),
  KEY `caste_id` (`caste_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10037 ;

--
-- Dumping data for table `profile`
--

INSERT INTO `profile` (`profile_id`, `salutation`, `first_name`, `surname`, `username`, `password`, `email`, `country_code`, `mobile`, `gender`, `religion_id`, `caste_id`, `country_id`, `location_name`, `image_name`, `dob`, `status`, `registration_date`, `order_id`, `photo_protect`, `login_count`, `unique_code`, `login_date`, `logout_date`, `modified_date`, `admin_status`, `super_admin_status`, `master_admin_status`, `payment_status`, `profile_visitedby`, `guest_view`, `photo_password`, `delete_status`, `view_status`, `registration_type`, `login_timer`, `direct_astro`, `software_astro`, `view_contact`) VALUES
(10001, '', 'umesh', '', 'umesh', 'a152e841783914146e4bcd4f39100686', 'cuumesh1@gmail.com', '', '9947253768', 'Male', 1, 15, '356', '0', '', '1985-02-01', 'Y', '2014-08-19', 47, 'N', 41, '', '2014-11-21 10:57:12', '2014-11-21 14:22:29', '2014-09-29 10:47:33', 'Y', 'N', 'Y', 'Y', '', 34, '', 'N', 'Y', 'Normal', '2014-11-21 08:52:27', 5, 5, 98),
(10002, '', 'Sreeja Raju', '', 'sreeja', 'be0c34657f42badf84872e0a5d4c575d', 'sreeja.raju.php@gmail.com', '', '1111111111', 'Female', 1, 15, '356', 'dfgdfdf dfgdf', '', '1987-11-21', 'Y', '2014-08-19', 49, 'N', 15, '', '2014-08-29 09:23:57', '0000-00-00 00:00:00', '2014-08-26 06:35:41', 'Y', 'N', 'Y', 'N', '', 72, '', 'N', 'Y', 'Normal', '2014-08-29 10:28:36', 5, 5, 100),
(10003, '', 'aaaaaaa', '', 'aaaaaaaa', '5d793fc5b00a2348c3fb9ab59e5ca98a', 'fgdfgdf@hfhfgh.com', '', '1111111111', 'Female', 1, 15, '356', 'Kerala-Thiruvananthapuram', '', '1976-02-01', 'Y', '2014-08-20', 43, 'N', 0, '', '2014-08-20 00:48:14', '2014-08-20 00:48:14', '0000-00-00 00:00:00', 'N', 'N', 'N', 'Y', '', 1, '', 'N', 'Y', 'Normal', '0000-00-00 00:00:00', 5, 5, 100),
(10004, '', 'aaaaaaaaa', '', 'aaaaaaaaaa', '3dbe00a167653a1aaee01d93e77e730e', 'testing@ff.com', '', '1111111111', 'Male', 1, 15, '784', 'dfg', '', '1987-11-18', 'Y', '2014-08-20', 45, 'N', 0, '', '2014-08-20 01:06:28', '2014-08-20 01:06:28', '0000-00-00 00:00:00', 'N', 'N', 'N', 'Y', '', 0, '', 'N', 'Y', 'Normal', '0000-00-00 00:00:00', 5, 5, 100),
(10005, '', 'aaaaaaaa', '', 'aaaaaaaaaaww', '4bbde07660e5eff90873642cfae9a8dd', 'ggdgdfgahaha@ggydhdh.com', '', '2222222222', 'Female', 1, 15, '036', 'hhfghfg', '', '1987-11-14', 'Y', '2014-08-20', 39, 'N', 0, '', '2014-08-20 01:49:51', '2014-08-20 01:49:51', '0000-00-00 00:00:00', 'Y', 'N', 'Y', 'Y', '', 4, '', 'N', 'Y', 'Normal', '0000-00-00 00:00:00', 5, 5, 100),
(10006, '', 'Test', '', 'webshore', '098f6bcd4621d373cade4e832627b4f6', 'info@webshore.com.au', '', '3224522363', 'Male', 1, 15, '356', 'Kerala-Ernakulam', '', '1981-12-12', 'Y', '2014-08-20', 41, 'N', 9, '', '2014-08-28 12:02:25', '0000-00-00 00:00:00', '2014-08-20 19:55:42', 'Y', 'Y', 'Y', 'N', '', 15, '', 'N', 'Y', 'Quick', '2014-08-28 12:30:32', 5, 5, 100),
(10007, '', 'sreeja', '', 'sreeja', 'd41d8cd98f00b204e9800998ecf8427e', 'sreeja.raju.php@gmail.com', '', '1111111111', 'Female', 1, 15, '356', 'dfgdfdf dfgdf', '', '1987-11-21', 'Y', '2014-08-22', 27, 'N', 0, '', '2014-08-22 07:18:14', '2014-08-22 07:18:14', '0000-00-00 00:00:00', 'N', 'N', 'N', 'N', '', 3, '', 'N', 'N', 'Normal', '0000-00-00 00:00:00', 5, 5, 100),
(10008, '', 'sreeja', '', 'sreeja', 'd41d8cd98f00b204e9800998ecf8427e', 'sreeja.raju.php@gmail.com', '', '1111111111', 'Female', 1, 15, '356', 'dfgdfdf dfgdf', '', '1987-11-21', 'Y', '2014-08-22', 29, 'N', 0, '', '2014-08-22 07:19:29', '2014-08-22 07:19:29', '0000-00-00 00:00:00', 'N', 'N', 'N', 'N', '', 0, '', 'N', 'N', 'Normal', '0000-00-00 00:00:00', 5, 5, 100),
(10009, '', 'giby', '', 'gibyisac', '2138cb5b0302e84382dd9b3677576b24', 'gibyisac@yahoo.com', '', '', 'Female', 1, 15, '356', 'Kerala-Ernakulam', '', '1977-04-15', 'Y', '2014-08-22', 25, 'N', 0, '', '2014-08-22 11:18:16', '2014-08-22 11:18:16', '0000-00-00 00:00:00', 'N', 'N', 'N', 'N', '', 0, '', 'N', 'N', 'Quick', '2014-08-22 11:18:32', 5, 5, 100),
(10010, '', 'zxcv', '', 'zxc', 'a152e841783914146e4bcd4f39100686', 'cuumesh123@gmail.com', '', '768978078', 'Male', 1, 15, '356', 'Andaman & Nicobar', '', '1964-07-02', 'Y', '2014-08-23', 21, 'N', 0, '', '2014-08-23 10:37:48', '2014-08-23 11:01:38', '2014-08-23 10:38:42', 'N', 'N', 'N', 'N', '', 0, '', 'N', 'N', 'Quick', '2014-08-23 10:39:58', 5, 5, 100),
(10011, '', 'cctv', '', 'cctv', 'a152e841783914146e4bcd4f39100686', 'kfdsjdjs@dsbsd.cd', '', '567878979', 'Female', 1, 15, '356', '0', '', '1990-11-12', 'Y', '2014-08-23', 23, 'N', 0, '', '2014-08-23 11:03:04', '2014-08-23 11:03:04', '0000-00-00 00:00:00', 'N', 'N', 'N', 'N', '', 0, '', 'N', 'Y', 'Normal', '2014-08-23 11:03:11', 5, 5, 100),
(10012, '', 'gfdfghfg', '', 'dfghdf', '980ac217c6b51e7dc41040bec1edfec8', 'suraj@fghfhd.dfg', '', '54568678', 'Male', 1, 15, '834', 'Kerala-Thiruvananthapuram', '', '1937-09-15', 'Y', '2014-08-23', 19, 'N', 0, '', '2014-08-23 11:12:31', '2014-08-23 11:23:36', '0000-00-00 00:00:00', 'N', 'N', 'N', 'Y', '', 0, '', 'Y', 'Y', 'Normal', '2014-08-23 11:23:34', 5, 5, 100),
(10013, '', 'qqqq', '', 'qwwww', '0b4e7a0e5fe84ad35fb5f95b9ceeac79', 'dfgf@fg.gh', '', '456456456', 'Male', 1, 15, '028', 'Kerala-Thrissur', '', '1940-08-12', 'Y', '2014-08-23', 17, 'N', 0, '', '2014-08-23 11:33:25', '2014-08-23 11:33:25', '0000-00-00 00:00:00', 'N', 'Y', 'N', 'Y', '', 0, '', 'Y', 'Y', 'Normal', '2014-08-23 12:36:47', 5, 5, 100),
(10014, '', 'nisar', '', 'nisar', '0b4e7a0e5fe84ad35fb5f95b9ceeac79', 'nis@fgsdg.dsfg', '', '56456456', 'Male', 1, 15, '356', 'Kerala-Kollam', '', '1990-10-16', 'Y', '2014-08-23', 39, 'N', 0, '', '2014-08-23 11:45:19', '2014-08-23 11:45:19', '0000-00-00 00:00:00', 'N', 'Y', 'N', 'Y', '', 0, '', 'N', 'Y', 'Normal', '0000-00-00 00:00:00', 5, 5, 100),
(10015, '', 'raju', '', 'raju', '0b4e7a0e5fe84ad35fb5f95b9ceeac79', 'raj@fgsdfk.df', '', '5467457', 'Male', 1, 15, '036', 'sdfdsfds', '', '1991-05-17', 'Y', '2014-08-23', 35, 'N', 0, '', '2014-08-23 11:50:51', '2014-08-23 11:50:51', '2014-08-23 11:51:40', 'Y', 'Y', 'Y', 'Y', '', 2, '', 'N', 'Y', 'Quick', '2014-08-23 11:53:53', 5, 5, 100),
(10016, '', 'Nitha John', '', 'Nitha John', 'ed64e4901e1974d44ba91107654796bb', 'info@ariuswebstudio.com', '', '', 'Male', 1, 15, '356', 'Kerala-Thiruvananthapuram', '', '1991-01-02', 'Y', '2014-08-25', 13, 'N', 0, '', '2014-08-25 06:53:49', '2014-08-25 06:53:49', '0000-00-00 00:00:00', 'N', 'N', 'N', 'Y', '', 0, '', 'Y', 'Y', 'Quick', '2014-08-25 09:16:35', 5, 5, 100),
(10017, '', 'Eldhose', '', 'test1', '098f6bcd4621d373cade4e832627b4f6', 'eldhosekjacob@gmail.com', '', '0421715497', 'Male', 1, 15, '356', 'Adelaide', '', '1981-12-13', 'Y', '2014-08-25', 15, 'N', 0, '', '2014-08-25 07:00:06', '2014-08-25 07:00:06', '2014-08-25 07:14:37', 'N', 'Y', 'N', 'Y', '', 0, '', 'Y', 'Y', 'Quick', '2014-08-25 08:18:25', 5, 5, 100),
(10018, '', 'Sneha Mathew', '', 'Sneha', 'ed64e4901e1974d44ba91107654796bb', 'admin@ariuswebstudio.com', '', '9845698526', 'Male', 1, 15, '356', 'Kerala-Kottayam', '', '1992-07-01', 'Y', '2014-08-25', 11, 'N', 0, '', '2014-08-25 12:18:57', '2014-08-25 12:26:03', '2014-08-25 12:21:02', 'N', 'Y', 'Y', 'Y', '', 0, '', 'Y', 'Y', 'Quick', '2014-08-25 12:25:56', 5, 5, 100),
(10019, '', 'testing', '', 'testing', '96e79218965eb72c92a549dd5a330112', 'testing@hh.com', '', '3333333333', 'Male', 1, 15, '356', 'bgdfgdf dfdfh', '', '1993-11-18', 'Y', '2014-08-26', 27, 'N', 0, '', '2014-08-26 05:20:40', '2014-08-26 05:20:40', '0000-00-00 00:00:00', 'Y', 'N', 'Y', 'Y', '', 0, '', 'N', 'Y', 'Normal', '0000-00-00 00:00:00', 5, 5, 100),
(10020, '', 'aaaaaaa', '', 'sssssss', '5d793fc5b00a2348c3fb9ab59e5ca98a', 'asasaas@hh.com', '', '3444444444', 'Male', 1, 15, '040', 'bdfgdfg', '', '1966-03-19', 'Y', '2014-08-26', 25, 'N', 0, '', '2014-08-26 05:23:47', '2014-08-26 06:00:05', '2014-08-26 05:25:51', 'Y', 'N', 'Y', 'Y', '', 0, '', 'N', 'Y', 'Quick', '2014-08-26 06:00:01', 5, 5, 100),
(10021, '', 'Nisha Varghese', '', 'Nisha', 'ed64e4901e1974d44ba91107654796bb', 'jintubasilt@gmail.com', '', '9846709109', 'Female', 1, 15, '356', 'Kerala-Kottayam', '', '1996-03-18', 'Y', '2014-08-26', 19, 'Y', 3, '', '2014-08-26 09:58:48', '0000-00-00 00:00:00', '2014-08-26 08:17:41', 'Y', 'Y', 'Y', 'N', '', 13, 'abc', 'N', 'Y', 'Quick', '2014-08-26 12:46:10', 5, 5, 100),
(10022, '', 'hdfhdhdhd', '', 'fsdfsdfsdfsdf', '3dbe00a167653a1aaee01d93e77e730e', 'adadasd@gdgdg.com', '', '1111111111', 'Male', 1, 15, '356', 'Kerala-Thiruvananthapuram', '', '1994-10-18', 'Y', '2014-08-26', 21, 'N', 0, '', '2014-08-26 08:26:09', '2014-08-26 08:26:09', '2014-08-26 08:28:40', 'N', 'N', 'N', 'N', '', 0, '', 'N', 'N', 'Normal', '0000-00-00 00:00:00', 5, 5, 100),
(10023, '', 'ajitha raju', '', 'ajitha', 'c75d0c23fd54f113a1bb5f07ee5b0320', 'ajitha1992@gmail.com', '', '3453426365', 'Female', 1, 15, '784', 'gdfgdffg', '', '1992-05-18', 'Y', '2014-08-26', 23, 'N', 0, '', '2014-08-26 08:37:40', '2014-08-26 08:37:40', '0000-00-00 00:00:00', 'N', 'N', 'Y', 'N', '', 2, '', 'N', 'Y', 'Normal', '0000-00-00 00:00:00', 5, 5, 100),
(10024, '', 'Nisar', '', 'nisar', '55850402c028beeb45f0fe57b46ed4ac', 'nisarmvpz@gmail.com', '', '', 'Female', 1, 15, '356', 'Kerala-Kasargod', '', '1959-02-01', 'Y', '2014-08-28', 9, 'N', 7, '', '2014-08-29 09:22:39', '2014-08-29 09:23:47', '0000-00-00 00:00:00', 'N', 'N', 'N', 'N', '', 0, '', 'N', 'Y', 'Quick', '2014-08-29 09:23:44', 5, 5, 100),
(10025, '', 'Niissar', '', 'nissar', '55850402c028beeb45f0fe57b46ed4ac', 'niasda@gmail.com', '', '9456896652', 'Male', 1, 15, '356', 'Kerala-Thiruvananthapuram', '', '1953-06-15', 'Y', '2014-08-28', 17, 'N', 4, '', '2014-08-28 11:27:45', '2014-08-28 12:22:03', '0000-00-00 00:00:00', 'N', 'N', 'N', 'N', '', 0, '', 'N', 'N', 'Normal', '2014-08-28 13:10:32', 5, 5, 100),
(10026, '', 'asaa', '', 'asaa', '08052ba96f06b696e81fab577fe8dd64', 'niska@sdfsdf.coasd', '', '', 'Male', 1, 15, '356', 'adasddsfasd', '', '1966-02-02', 'Y', '2014-08-29', 5, 'N', 3, '', '2014-08-29 07:04:28', '2014-08-29 07:05:30', '0000-00-00 00:00:00', 'N', 'N', 'N', 'N', '', 0, '', 'N', 'N', 'Quick', '2014-08-29 08:00:01', 5, 5, 100),
(10027, '', 'asdfgh', '', 'asdfgh', '513106c051f94528f1d386926aa65e1a', 'asdfgh@asa.com', '', '', 'Male', 1, 15, '356', 'Arunachal Pradesh', '', '1949-01-01', 'Y', '2014-08-29', 7, 'N', 0, '', '2014-08-29 07:06:28', '2014-08-29 07:10:34', '0000-00-00 00:00:00', 'N', 'N', 'N', 'N', '', 0, '', 'N', 'N', 'Quick', '2014-08-29 07:10:32', 5, 5, 100),
(10028, 'mrs', 'manjusha', 'krishnan', 'manjuisanu', 'a152e841783914146e4bcd4f39100686', 'manjuisanu@gmail.com', '', '', 'Female', 0, 0, '', 'Kerala-Malappuram', '', '1986-09-12', 'Y', '2014-09-03', 1, 'N', 0, '', '2014-09-03 14:42:46', '2014-09-03 14:48:34', '2014-09-17 15:08:51', 'N', 'N', 'N', 'N', '', 0, '', 'N', 'Y', 'Quick', '2014-09-03 09:18:30', 5, 5, 100),
(10029, '', 'binu', '', 'binu', 'a152e841783914146e4bcd4f39100686', 'binu@gmail.com', '', '574567687', 'Female', 1, 15, '356', 'Kerala-Alapuzha', '', '1987-08-01', 'Y', '2014-09-03', 3, 'N', 0, '', '2014-09-03 14:53:07', '2014-09-03 14:54:13', '2014-09-03 14:54:00', 'N', 'N', 'N', 'N', '', 0, '', 'N', 'N', 'Quick', '2014-09-03 09:24:10', 5, 5, 100),
(10030, '', 'biju', '', 'biju', 'a152e841783914146e4bcd4f39100686', 'biju@gmail.com', '44', '46456', 'Female', 1, 15, '826', 'gdgdfg', '', '1964-05-06', 'Y', '2014-09-03', 3, 'N', 0, '', '2014-09-03 14:54:51', '2014-09-03 14:59:47', '0000-00-00 00:00:00', 'N', 'N', 'N', 'N', '', 0, '', 'N', 'N', 'Quick', '2014-09-03 09:29:43', 5, 5, 100),
(10031, '', 'unni', '', 'unni', 'a152e841783914146e4bcd4f39100686', 'unni@gmail.com', '', '6746568776', 'Male', 1, 15, '036', 'dfghfhf', '', '1967-11-09', 'Y', '2014-09-03', 7, 'N', 0, '', '2014-09-03 15:00:40', '2014-09-03 15:00:40', '2014-09-03 15:02:11', 'N', 'N', 'N', 'N', '', 0, '', 'N', 'Y', 'Quick', '2014-09-03 11:05:17', 5, 5, 100),
(10032, '', 'dfgsdgdfg', '', 'dghdfh', '0b4e7a0e5fe84ad35fb5f95b9ceeac79', 'dfgd@gsdf.hg', '', '4564564', 'Male', 1, 18, '356', 'Kerala-Kottayam', '', '1931-06-03', 'Y', '2014-09-03', 9, 'N', 0, '', '2014-09-03 16:31:01', '2014-09-03 16:31:01', '0000-00-00 00:00:00', 'N', 'N', 'N', 'N', '', 0, '', 'N', 'N', 'Normal', '0000-00-00 00:00:00', 5, 5, 100),
(10033, '', 'thanku', '', 'agnika', 'a152e841783914146e4bcd4f39100686', 'agnika@gmail.com', '91', '6345645634', 'Female', 1, 15, '356', 'Kerala-Palakad', '', '1990-04-17', 'Y', '2014-11-18', 1, 'N', 0, '', '2014-11-18 12:12:53', '2014-11-18 12:33:40', '0000-00-00 00:00:00', 'N', 'N', 'N', 'N', '', 0, '', 'N', 'N', 'Quick', '2014-11-18 07:03:35', 5, 5, 100),
(10034, '', 'sdfsf', '', 'umesh4234', '0b4e7a0e5fe84ad35fb5f95b9ceeac79', 'cuumesh1ewqe@gmail.com', '', '5675675', 'Male', 1, 15, '660', '0', '', '1990-02-01', 'Y', '2014-11-18', 0, 'N', 0, '', '2014-11-18 13:47:43', '2014-11-18 13:47:43', '0000-00-00 00:00:00', 'N', 'N', 'N', 'N', '', 0, '', 'N', 'N', 'Normal', '0000-00-00 00:00:00', 5, 5, 100),
(10035, '', 'suraj', '', 'suraj', 'a152e841783914146e4bcd4f39100686', 'suraj@gmail.com', '', '4563563', 'Male', 1, 15, '840', '0', '', '1929-03-01', 'Y', '2014-11-18', 0, 'N', 0, '', '2014-11-18 15:55:14', '2014-11-18 15:55:14', '0000-00-00 00:00:00', 'N', 'N', 'N', 'N', '', 0, '', 'N', 'N', 'Normal', '0000-00-00 00:00:00', 5, 5, 100),
(10036, '', '', '', '', '', '', '', '', 'Male', 0, 0, '', '', '', '0000-00-00', 'N', '0000-00-00', 0, 'N', 0, '', '0000-00-00 00:00:00', '2014-11-19 16:38:59', '0000-00-00 00:00:00', 'N', 'N', 'N', 'Y', '', 0, '', 'N', 'N', 'Normal', '0000-00-00 00:00:00', 5, 5, 100);

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

--
-- Table structure for table `profile_astro_match`
--

CREATE TABLE IF NOT EXISTS `profile_astro_match` (
  `profile_astro_match_id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `astro_file` varchar(255) NOT NULL,
  `added_date` datetime NOT NULL,
  `modified_date` datetime NOT NULL,
  `status` enum('Y','N') NOT NULL DEFAULT 'Y',
  `profile_id` int(11) NOT NULL,
  `password_protect` enum('Y','N') NOT NULL DEFAULT 'N',
  `password` varchar(255) NOT NULL,
  PRIMARY KEY (`profile_astro_match_id`),
  KEY `profile_id` (`profile_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `profile_astro_match`
--


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

--
-- Table structure for table `profile_basic`
--

CREATE TABLE IF NOT EXISTS `profile_basic` (
  `profile_basic_id` int(11) NOT NULL AUTO_INCREMENT,
  `marital_status` int(11) NOT NULL,
  `have_children` enum('Yes','No') NOT NULL DEFAULT 'No',
  `no_of_children` varchar(255) NOT NULL,
  `children_living_with` varchar(255) NOT NULL,
  `height` int(11) NOT NULL,
  `weight` int(11) NOT NULL,
  `mother_tongue` varchar(255) NOT NULL,
  `sub_caste` varchar(255) NOT NULL,
  `physical_status` int(11) NOT NULL,
  `education_id` varchar(255) NOT NULL,
  `education_detail` text NOT NULL,
  `about_me` text NOT NULL,
  `spoken_language` varchar(255) NOT NULL,
  `contact_landline` varchar(255) NOT NULL,
  `contact_mobile` varchar(255) NOT NULL,
  `contact_mobile2` varchar(255) NOT NULL,
  `contact_preferred_type` enum('Mobile','Landline') NOT NULL DEFAULT 'Mobile',
  `contact_person` varchar(255) NOT NULL,
  `contact_convenient_time` varchar(255) NOT NULL,
  `profile_createdby` int(11) NOT NULL,
  `address` text NOT NULL,
  `pincode` varchar(255) NOT NULL,
  `added_date` datetime NOT NULL,
  `modified_date` datetime NOT NULL,
  `status` enum('Y','N') NOT NULL DEFAULT 'Y',
  `profile_id` int(11) NOT NULL,
  `city` varchar(255) NOT NULL,
  PRIMARY KEY (`profile_basic_id`),
  KEY `profile_id` (`profile_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=21 ;

--
-- Dumping data for table `profile_basic`
--

INSERT INTO `profile_basic` (`profile_basic_id`, `marital_status`, `have_children`, `no_of_children`, `children_living_with`, `height`, `weight`, `mother_tongue`, `sub_caste`, `physical_status`, `education_id`, `education_detail`, `about_me`, `spoken_language`, `contact_landline`, `contact_mobile`, `contact_mobile2`, `contact_preferred_type`, `contact_person`, `contact_convenient_time`, `profile_createdby`, `address`, `pincode`, `added_date`, `modified_date`, `status`, `profile_id`, `city`) VALUES
(1, 2, '', '', '', 154, 52, '1', '', 1, '9', '', 'gfhfhfgh', '', '', '', '', 'Mobile', 'dgdfg dfgd', '12:00 PM', 5, 'dfg dfgd', '', '2014-08-19 23:40:28', '2014-09-29 10:47:33', 'N', 10001, 'dfghdfgh'),
(2, 2, '', '', '', 152, 49, '1', '', 1, '1', 'adasdasd fdsf', 'gdfgdfgdfg dfgsdfg', '1', '1111111111', '', '', 'Mobile', 'fgdzfgdf dfgdfh', '1', 2, 'hfghfgh fghfg', '222222', '2014-08-19 23:56:27', '2014-08-22 07:19:29', 'N', 10002, 'hfghfghgh ghfg'),
(3, 2, '', '', '', 121, 37, '1', '', 1, '1', 'testing', 'dfgdfgdf', '', '1111111111', '', '', 'Mobile', 'ggdfgdfgdf', '1', 1, 'dfgdfgdf', '111111', '2014-08-20 00:48:14', '2014-08-20 00:48:14', 'N', 10003, 'fdgbdsfg'),
(4, 2, '', '', '', 124, 43, '1', '', 1, '1', '', 'fsdf dfsd gfg', '1', '5345345345', '', '', 'Mobile', 'ertert get rtrt', '1', 1, 'dhdfhds', '111111', '2014-08-20 01:06:28', '2014-08-20 01:06:28', 'N', 10004, 'dfgdfgdfg'),
(5, 2, '', '', '', 152, 51, '1', '', 1, '1', '', 'bnvbnvb vbnvn fhgh', '', '', '', '', '', 'hfhfhfhfdghdfghfdgh', '', 1, 'hfghfghfg', '', '2014-08-20 01:49:51', '2014-08-20 01:49:51', 'N', 10005, 'dfgdfhdg'),
(6, 2, '', '', '', 124, 36, '1', '', 1, '1', '', 'test', '', '', '', '', '', 'Test', '', 4, 'Test', '', '2014-08-20 19:55:42', '2014-08-20 19:55:42', 'N', 10006, 'Kerala'),
(7, 2, '', '', '', 157, 49, '1', '', 1, '8', '', 'gfhfghfghf', '', '', '', '', '', 'fghfghf gfh', '', 4, 'ghfhf', '', '2014-08-23 11:45:19', '2014-08-23 11:45:19', 'N', 10014, 'fghfhf'),
(8, 2, '', '', '', 154, 49, '1', '', 1, '', '', 'dfgd fdg dfghf', '', '', '', '', '', 'ghfjhg', '', 1, 'fgjhfghj', '', '2014-08-23 11:51:40', '2014-08-23 11:51:40', 'N', 10015, 'fghjfg'),
(9, 2, '', '', '', 124, 41, '1', '', 1, '8', 'dfdfsdfg', 'xdfdfdf', '1', '3333333333', '', '', 'Mobile', 'fghfgh fghfg', '2', 2, 'dfdfgdfgdf', '222222', '2014-08-26 05:20:40', '2014-08-26 05:20:40', 'N', 10019, 'vdxfgdfg'),
(10, 2, '', '', '', 134, 42, '1', '', 1, '1', 'bvcdbdc ghdfgh', 'fghbxdfh', '2', '4444444444', '', '', 'Mobile', 'jcgjgh', '1', 2, 'fgjfj hjjh', '444444', '2014-08-26 05:25:51', '2014-08-26 05:25:51', 'N', 10020, 'dhbfcghfg fg fj'),
(11, 2, '', '', '', 154, 71, '1', '', 1, '1', 'SSLC', 'hello hello hello hellohello hellohello hellohello hellohello hellohello hellohello hellohello hellohello hellohello hello', '1,2', '5455445', '', '', 'Mobile', 'sdds', '6 - 8', 2, 'Jacobite Matrimonial Service', '568956', '2014-08-26 08:17:41', '2014-08-26 08:17:41', 'N', 10021, 'Kochi'),
(12, 2, '', '', '', 121, 39, '1', '', 1, '1', 'dfgdfgdsfg', 'dfgdfg gsdfg', '1', '2222222222', '', '', 'Mobile', 'gfdgdfgdf', '2', 2, 'sdfsdf  xgdfg', '322142', '2014-08-26 08:26:09', '2014-08-26 08:28:40', 'N', 10022, 'xzvxvxcv dfdsf'),
(13, 2, '', '', '', 165, 50, '1', '', 1, '9', 'dsfsdfsd', 'fsdf fsdfs', '1', '3235234523', '', '', 'Landline', 'gdgdfgdfg', '2', 1, 'dgdfgdfg', '234234', '2014-08-26 08:37:40', '2014-08-26 08:37:40', 'N', 10023, 'gdfgdfg'),
(14, 2, '', '', '', 124, 84, '1', '', 1, '1,8', '', 'agsf dg dgd g dh df dhdd', '1,2,3,4', '', '', '', 'Mobile', 'asgfgf', '', 1, 'gagfsdf g d dfg gd dg', '', '2014-08-28 08:22:34', '2014-08-28 08:22:34', 'N', 10025, 'sdgfdsgdsf'),
(15, 2, '', '', '', 160, 60, '1', 'cheruma', 1, '9', '', 'ha ha ha', '1,4', '', '', '', 'Mobile', 'dgdfg dfgd', '', 5, 'dfg dfgd', '987654', '2014-09-03 14:44:06', '2014-09-17 15:08:51', 'N', 10028, 'dfghdfgh'),
(16, 2, '', '', '', 129, 45, '1', '', 1, '9', '', 'fghfg hfg', '', '', '', '', '', 'hgfhgfhf', '', 4, 'fhfghfghfg', '', '2014-09-03 14:54:00', '2014-09-03 14:54:00', 'N', 10029, 'fghfghfgh'),
(17, 2, 'Yes', '3', '', 139, 50, '2', '', 1, '9', '', 'gdfg dfgg', '', '', '', '', '', 'dfgdfgdg dfg', '', 3, 'fdgdfgdfgdfgdf', '', '2014-09-03 15:02:11', '2014-09-03 15:02:11', 'N', 10031, 'dfgdfg dfgd'),
(18, 2, '', '', '', 127, 37, '2', '', 1, '9', '', 'dfgfdgsdfg', '', '', '', '', '', 'ncvncbnbv', '', 4, 'nnbvm', '', '2014-09-03 16:31:01', '2014-09-03 16:31:01', 'N', 10032, 'vnbcv'),
(19, 2, '', '', '', 127, 38, '1', '', 1, '1,8,9', '', 'fgh', '', '', '', '', '', 'hd fgfh', '', 1, 'ghfghfgj', '', '2014-11-18 13:47:46', '2014-11-18 13:47:46', 'N', 10034, 'fghfh'),
(20, 2, '', '', '', 124, 36, '1', '', 1, '1', '', 'dgss sdfsd', '', '', '', '', '', 'dfgghfgh', '', 4, 'dghdfg', '', '2014-11-18 15:55:16', '2014-11-18 15:55:16', 'N', 10035, 'dghd');

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

--
-- Table structure for table `profile_contact_request`
--

CREATE TABLE IF NOT EXISTS `profile_contact_request` (
  `profile_contact_request_id` int(11) NOT NULL AUTO_INCREMENT,
  `profile_id` int(11) NOT NULL,
  `profile_id_request` int(11) NOT NULL,
  `added_date` datetime NOT NULL,
  `modified_date` datetime NOT NULL,
  PRIMARY KEY (`profile_contact_request_id`),
  KEY `profile_id` (`profile_id`),
  KEY `profile_id_request` (`profile_id_request`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `profile_contact_request`
--

INSERT INTO `profile_contact_request` (`profile_contact_request_id`, `profile_id`, `profile_id_request`, `added_date`, `modified_date`) VALUES
(1, 10001, 10021, '2014-11-21 13:02:18', '2014-11-21 13:02:18'),
(2, 10001, 10002, '2014-11-21 14:13:03', '2014-11-21 14:13:03');

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

--
-- Table structure for table `profile_express_interest`
--

CREATE TABLE IF NOT EXISTS `profile_express_interest` (
  `express_interest_id` int(11) NOT NULL AUTO_INCREMENT,
  `profile_id` int(11) NOT NULL,
  `profile_id_interest` int(11) NOT NULL,
  `message` text,
  `added_date` datetime NOT NULL,
  `modified_date` datetime NOT NULL,
  `status` enum('Accepted','Declined','Rejected','Pending') NOT NULL DEFAULT 'Pending',
  `read_status` enum('Y','N') DEFAULT 'N',
  `reminder` enum('N','Y') DEFAULT 'N',
  PRIMARY KEY (`express_interest_id`),
  KEY `profile_id` (`profile_id`),
  KEY `profile_id_interest` (`profile_id_interest`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

--
-- Dumping data for table `profile_express_interest`
--

INSERT INTO `profile_express_interest` (`express_interest_id`, `profile_id`, `profile_id_interest`, `message`, `added_date`, `modified_date`, `status`, `read_status`, `reminder`) VALUES
(3, 10021, 10006, 'Your profile is interested to me. So, Please Accept it', '2014-08-26 09:44:53', '2014-08-26 09:44:53', 'Pending', '', ''),
(4, 10001, 10021, 'Your profile is interested to me. So, Please Accept it', '2014-08-26 10:00:40', '2014-08-26 10:00:40', 'Pending', '', 'Y'),
(5, 10001, 10005, 'We like to move forward with your profile for my son. So please reply fast', '2014-08-28 09:00:45', '2014-08-28 09:00:45', 'Pending', '', ''),
(6, 10002, 10019, 'Your profile is interested to me. So, Please Accept it', '2014-08-29 06:10:22', '2014-08-29 06:10:22', 'Pending', '', ''),
(7, 10001, 10002, 'We like to move forward with your profile for my son. So please reply fast', '2014-11-21 05:28:14', '2014-11-21 05:28:14', 'Pending', '', 'Y');

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

--
-- Table structure for table `profile_favorite`
--

CREATE TABLE IF NOT EXISTS `profile_favorite` (
  `profile_favorite_id` int(11) NOT NULL AUTO_INCREMENT,
  `profile_id` int(11) NOT NULL,
  `profile_id_favorite` int(11) NOT NULL,
  `profile_comment` varchar(225) NOT NULL,
  `added_date` datetime NOT NULL,
  `modified_date` datetime NOT NULL,
  `status` enum('Y','N') NOT NULL DEFAULT 'Y',
  PRIMARY KEY (`profile_favorite_id`),
  KEY `profile_id` (`profile_id`),
  KEY `profile_id_favorite` (`profile_id_favorite`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

--
-- Dumping data for table `profile_favorite`
--

INSERT INTO `profile_favorite` (`profile_favorite_id`, `profile_id`, `profile_id_favorite`, `profile_comment`, `added_date`, `modified_date`, `status`) VALUES
(1, 10001, 10002, 'abcd', '2014-08-20 04:32:23', '2014-08-20 04:32:23', 'N'),
(2, 10002, 10001, 'asasaasa', '2014-08-22 04:49:10', '2014-08-22 04:49:10', 'N'),
(3, 10006, 10015, 'Test', '2014-08-25 06:24:40', '2014-08-25 06:24:40', 'N'),
(4, 10021, 10006, 'abc', '2014-08-26 09:46:13', '2014-08-26 09:46:13', 'N'),
(5, 10021, 10015, 'abc', '2014-08-26 09:46:47', '2014-08-26 09:46:47', 'N'),
(6, 10001, 10021, 'abcd', '2014-08-26 10:00:50', '2014-08-26 10:00:50', 'N'),
(7, 10025, 10002, 'sdfsdf', '2014-08-28 12:00:42', '2014-08-28 12:00:42', 'N'),
(8, 10025, 10021, 'dfsdfdsf', '2014-08-28 12:00:57', '2014-08-28 12:00:57', 'N');

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

--
-- Table structure for table `profile_gallery`
--

CREATE TABLE IF NOT EXISTS `profile_gallery` (
  `profile_gallery_id` int(11) NOT NULL AUTO_INCREMENT,
  `profile_id` int(11) NOT NULL,
  `image_name` varchar(255) NOT NULL,
  `status` enum('Y','N') NOT NULL DEFAULT 'Y',
  `profile_image` enum('Y','N') NOT NULL DEFAULT 'N',
  `added_date` datetime NOT NULL,
  `modified_date` datetime NOT NULL,
  PRIMARY KEY (`profile_gallery_id`),
  KEY `profile_id` (`profile_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

--
-- Dumping data for table `profile_gallery`
--

INSERT INTO `profile_gallery` (`profile_gallery_id`, `profile_id`, `image_name`, `status`, `profile_image`, `added_date`, `modified_date`) VALUES
(1, 10001, 'b5fce02d6bd42749116653d5881056bf.jpg', 'Y', 'Y', '0000-00-00 00:00:00', '2014-10-07 17:45:04'),
(2, 10028, '653f5751ea3071b462e3cd68227f9442.jpg', 'N', 'Y', '2014-09-17 16:17:01', '2014-09-17 16:17:01'),
(3, 10029, '00332dc2e631cffa85ebc1925a3f2f8d.jpg', 'N', 'Y', '2014-09-20 18:04:38', '2014-09-20 18:04:38'),
(4, 10031, '77584b1c14954ae7cc476443577fc10e.jpg', 'N', 'Y', '2014-09-20 18:11:53', '2014-09-20 18:11:53'),
(5, 10021, '931607b041eb5af887f71d8ee0b073d8.jpg', 'N', 'Y', '2014-09-20 18:16:03', '2014-09-20 18:16:03'),
(6, 10001, '42161358c7cd0822409fffdca67a6896.jpg', 'N', 'N', '0000-00-00 00:00:00', '2014-10-07 17:45:04'),
(7, 10001, '270f055e6624d13910288f0ff0557636.jpg', 'N', 'N', '0000-00-00 00:00:00', '2014-10-07 17:45:04');

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

--
-- Table structure for table `profile_match_horoscope`
--

CREATE TABLE IF NOT EXISTS `profile_match_horoscope` (
  `match_horoscope_id` int(11) NOT NULL AUTO_INCREMENT,
  `profile_id` int(11) NOT NULL,
  `profile_id_match` int(11) NOT NULL,
  `message` text,
  `added_date` datetime NOT NULL,
  `modified_date` datetime NOT NULL,
  PRIMARY KEY (`match_horoscope_id`),
  KEY `profile_id` (`profile_id`),
  KEY `profile_id_match` (`profile_id_match`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `profile_match_horoscope`
--


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

--
-- Table structure for table `profile_my_request`
--

CREATE TABLE IF NOT EXISTS `profile_my_request` (
  `my_request_id` int(11) NOT NULL AUTO_INCREMENT,
  `profile_id` int(11) NOT NULL,
  `profile_id_request` int(11) NOT NULL,
  `request_type` enum('Horoscope','Photo_pswd','Horoscope_pswd','Photo') DEFAULT NULL,
  `added_date` datetime NOT NULL,
  `modified_date` datetime NOT NULL,
  `status` enum('Accepted','Pending') NOT NULL DEFAULT 'Pending',
  PRIMARY KEY (`my_request_id`),
  KEY `profile_id` (`profile_id`),
  KEY `profile_id_request` (`profile_id_request`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `profile_my_request`
--

INSERT INTO `profile_my_request` (`my_request_id`, `profile_id`, `profile_id_request`, `request_type`, `added_date`, `modified_date`, `status`) VALUES
(1, 10001, 10021, 'Photo_pswd', '2014-11-21 05:55:55', '2014-11-21 05:55:55', 'Accepted');

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

--
-- Table structure for table `profile_personal`
--

CREATE TABLE IF NOT EXISTS `profile_personal` (
  `profile_personal_id` int(11) NOT NULL AUTO_INCREMENT,
  `complexion` int(11) NOT NULL,
  `occupation_id` int(11) NOT NULL,
  `star_id` int(11) NOT NULL,
  `body_type` int(11) NOT NULL,
  `employed_in` int(11) NOT NULL,
  `chovva_dosham` int(11) NOT NULL,
  `blood_group` varchar(255) NOT NULL,
  `annual_income` varchar(255) NOT NULL,
  `shuddha_jatakam` int(11) NOT NULL,
  `family_type` int(11) NOT NULL,
  `family_status` int(11) NOT NULL,
  `family_value` int(11) NOT NULL,
  `father_occupation` varchar(255) NOT NULL,
  `father_ancestral_place` varchar(255) NOT NULL,
  `mother_occupation` varchar(255) NOT NULL,
  `mother_ancestral_place` varchar(255) NOT NULL,
  `no_of_brother` int(11) NOT NULL,
  `brother_married` int(11) NOT NULL,
  `no_of_sisters` int(11) NOT NULL,
  `sister_married` int(11) NOT NULL,
  `about_family` text NOT NULL,
  `permanent_location` varchar(3) NOT NULL,
  `residential_status` int(11) NOT NULL,
  `added_date` datetime NOT NULL,
  `modified_date` datetime NOT NULL,
  `status` enum('Y','N') NOT NULL DEFAULT 'Y',
  `profile_id` int(11) NOT NULL,
  PRIMARY KEY (`profile_personal_id`),
  KEY `profile_id` (`profile_id`),
  KEY `occupation_id` (`occupation_id`),
  KEY `star_id` (`star_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=21 ;

--
-- Dumping data for table `profile_personal`
--

INSERT INTO `profile_personal` (`profile_personal_id`, `complexion`, `occupation_id`, `star_id`, `body_type`, `employed_in`, `chovva_dosham`, `blood_group`, `annual_income`, `shuddha_jatakam`, `family_type`, `family_status`, `family_value`, `father_occupation`, `father_ancestral_place`, `mother_occupation`, `mother_ancestral_place`, `no_of_brother`, `brother_married`, `no_of_sisters`, `sister_married`, `about_family`, `permanent_location`, `residential_status`, `added_date`, `modified_date`, `status`, `profile_id`) VALUES
(1, 0, 28, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', '', '', '', -1, -1, -1, -1, '', '', 0, '2014-08-19 23:40:28', '2014-08-19 23:40:28', 'N', 10001),
(2, 2, 16, 0, 2, 6, 0, '', '149999', 0, 1, 2, 1, 'dfsd fddsfg', 'dfgdfgfd dfgdf', 'dfgdfgdf', 'dfgdfg dfgdf', 1, 1, 1, 1, 'dfgdf dfgdfg', '036', 1, '2014-08-19 23:56:27', '2014-08-19 23:56:27', 'N', 10002),
(3, 2, 15, 0, 1, 1, 0, '', '99999', 0, 1, 1, 1, 'dfxgdfg dgdfg', 'dfgdfg dfgdfgd', 'dfgdfgfd dfgdf', 'dfg dfgdfg dfgdfg', 1, 1, 1, 1, 'dfgdf dfgdfg dfgdfg', '356', 1, '2014-08-20 00:48:14', '2014-08-20 00:48:14', 'N', 10003),
(4, 0, 1, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', '', '', '', -1, -1, -1, -1, '', '036', 1, '2014-08-20 01:06:28', '2014-08-20 01:06:28', 'N', 10004),
(5, 0, 19, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', '', '', '', -1, -1, -1, -1, '', '036', 1, '2014-08-20 01:49:51', '2014-08-20 01:49:51', 'N', 10005),
(6, 0, 1, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', '', '', '', -1, -1, -1, -1, '', '682', 1, '2014-08-20 19:55:42', '2014-08-20 19:55:42', 'N', 10006),
(7, 0, 15, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', '', '', '', -1, -1, -1, -1, '', '356', 2, '2014-08-23 11:45:19', '2014-08-23 11:45:19', 'N', 10014),
(8, 0, 15, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', '', '', '', -1, -1, -1, -1, '', '840', 1, '2014-08-23 11:51:40', '2014-08-23 11:51:40', 'N', 10015),
(9, 2, 1, 0, 2, 1, 0, '', '699999', 0, 1, 1, 1, 'xcvbvb fdgfg', 'dgdfg dfdfg', 'ddfg dfgdfg', 'dfgdfg dfgdfg', 1, 1, 1, 1, 'dfgdfg dfgdfg', '784', 1, '2014-08-26 05:20:40', '2014-08-26 05:20:40', 'N', 10019),
(10, 2, 14, 0, 2, 2, 0, '', '699999', 0, 1, 1, 2, 'cvbcvbc', 'bcfghdgh', 'cvbcv', 'fhgfhfgh', 1, 1, 2, 2, 'fhfhfg', '040', 1, '2014-08-26 05:25:51', '2014-08-26 05:25:51', 'N', 10020),
(11, 1, 1, 0, 1, 1, 0, '', '49999', 0, 1, 1, 1, 'Business', 'Kottayam', 'House Wife', 'Thrissur', 4, 1, 4, 1, 'hello hellohello hellohello hello', '356', 1, '2014-08-26 08:17:41', '2014-08-26 08:17:41', 'N', 10021),
(12, 2, 16, 0, 1, 1, 0, '', '899999', 0, 1, 1, 1, 'xsdfvsdfsdf', 'dfgdfgdfg dgdfgdf', 'ggfgggggggggg', 'dgdfg dfgdfg dgdfg dfgdfg', 2, 2, 2, 2, 'dgdfgf dgdfgf', '533', 1, '2014-08-26 08:26:09', '2014-08-26 08:26:09', 'N', 10022),
(13, 2, 16, 0, 1, 1, 0, '', '1199999', 0, 2, 1, 1, 'sfsdfdsfg gsdfgfsg', 'dfgdfg fdgdfg fgdfg', 'fgdfg dgdfg gdfg', 'gdfgdfg gdfgdfg dgdf', 1, 0, 1, 0, 'dfgdfg dfgdfgdf', '051', 6, '2014-08-26 08:37:40', '2014-08-26 08:37:40', 'N', 10023),
(14, 1, 1, 0, 1, 1, 0, '', '99999', 0, 1, 0, 0, '', '', '', '', -1, -1, -1, -1, '', '356', 1, '2014-08-28 08:22:34', '2014-08-28 08:22:34', 'N', 10025),
(15, 0, 16, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', '', '', '', -1, -1, -1, -1, '', '356', 3, '2014-09-03 14:44:06', '2014-09-03 14:44:06', 'N', 10028),
(16, 0, 11, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', '', '', '', -1, -1, -1, -1, '', '356', 4, '2014-09-03 14:54:00', '2014-09-03 14:54:00', 'N', 10029),
(17, 0, 16, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', '', '', '', -1, -1, -1, -1, '', '533', 2, '2014-09-03 15:02:11', '2014-09-03 15:02:11', 'N', 10031),
(18, 0, 12, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', '', '', '', -1, -1, -1, -1, '', '356', 2, '2014-09-03 16:31:02', '2014-09-03 16:31:02', 'N', 10032),
(19, 0, 12, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', '', '', '', -1, -1, -1, -1, '', '', 0, '2014-11-18 13:47:46', '2014-11-18 13:47:46', 'N', 10034),
(20, 0, 5, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', '', '', '', -1, -1, -1, -1, '', '', 0, '2014-11-18 15:55:16', '2014-11-18 15:55:16', 'N', 10035);

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

--
-- Table structure for table `profile_personality`
--

CREATE TABLE IF NOT EXISTS `profile_personality` (
  `profile_personality_id` int(11) NOT NULL AUTO_INCREMENT,
  `diet` int(11) NOT NULL,
  `smoking` int(11) NOT NULL,
  `drinking` int(11) NOT NULL,
  `hobbies` varchar(255) NOT NULL,
  `music` varchar(255) NOT NULL,
  `reading` varchar(255) NOT NULL,
  `movies` varchar(255) NOT NULL,
  `sports` varchar(255) NOT NULL,
  `food` varchar(255) NOT NULL,
  `dress` varchar(255) NOT NULL,
  `added_date` datetime NOT NULL,
  `modified_date` datetime NOT NULL,
  `status` enum('Y','N') NOT NULL DEFAULT 'Y',
  `profile_id` int(11) NOT NULL,
  `birth_time` time NOT NULL,
  `time_tag` varchar(255) NOT NULL,
  `time_correction` varchar(255) NOT NULL,
  `birth_place` varchar(255) NOT NULL,
  `longitude` varchar(255) NOT NULL,
  `latitude` varchar(255) NOT NULL,
  `timezone` varchar(255) NOT NULL,
  `agent_code` varchar(255) NOT NULL,
  PRIMARY KEY (`profile_personality_id`),
  KEY `profile_id` (`profile_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=21 ;

--
-- Dumping data for table `profile_personality`
--

INSERT INTO `profile_personality` (`profile_personality_id`, `diet`, `smoking`, `drinking`, `hobbies`, `music`, `reading`, `movies`, `sports`, `food`, `dress`, `added_date`, `modified_date`, `status`, `profile_id`, `birth_time`, `time_tag`, `time_correction`, `birth_place`, `longitude`, `latitude`, `timezone`, `agent_code`) VALUES
(1, 0, 0, 0, '', '', '', '', '', '', '', '2014-08-19 23:40:28', '2014-08-19 23:40:28', 'N', 10001, '00:00:00', '', '', '', '', '', '', ''),
(2, 0, 0, 0, '', '', '', '', '', '', '', '2014-08-19 23:56:27', '2014-08-19 23:56:27', 'N', 10002, '00:00:00', '', '', '', '', '', '', ''),
(3, 0, 0, 0, '', '', '', '', '', '', '', '2014-08-20 00:48:14', '2014-08-20 00:48:14', 'N', 10003, '00:00:00', '', '', '', '', '', '', ''),
(4, 0, 0, 0, '', '', '', '', '', '', '', '2014-08-20 01:06:28', '2014-08-20 01:06:28', 'N', 10004, '00:00:00', '', '', '', '', '', '', ''),
(5, 0, 0, 0, '', '', '', '', '', '', '', '2014-08-20 01:49:51', '2014-08-20 01:49:51', 'N', 10005, '00:00:00', '', '', '', '', '', '', ''),
(6, 0, 0, 0, '', '', '', '', '', '', '', '2014-08-20 19:55:42', '2014-08-20 19:55:42', 'N', 10006, '00:00:00', '', '', '', '', '', '', ''),
(7, 0, 0, 0, '', '', '', '', '', '', '', '2014-08-23 11:45:19', '2014-08-23 11:45:19', 'N', 10014, '00:00:00', '', '', '', '', '', '', ''),
(8, 0, 0, 0, '', '', '', '', '', '', '', '2014-08-23 11:51:40', '2014-08-23 11:51:40', 'N', 10015, '00:00:00', '', '', '', '', '', '', ''),
(9, 0, 0, 0, '', '', '', '', '', '', '', '2014-08-26 05:20:40', '2014-08-26 05:20:40', 'N', 10019, '00:00:00', '', '', '', '', '', '', ''),
(10, 0, 0, 0, '', '', '', '', '', '', '', '2014-08-26 05:25:51', '2014-08-26 05:25:51', 'N', 10020, '00:00:00', '', '', '', '', '', '', ''),
(11, 0, 0, 0, '', '', '', '', '', '', '', '2014-08-26 08:17:41', '2014-08-26 08:17:41', 'N', 10021, '00:00:00', '', '', '', '', '', '', ''),
(12, 0, 0, 0, '', '', '', '', '', '', '', '2014-08-26 08:26:09', '2014-08-26 08:26:09', 'N', 10022, '00:00:00', '', '', '', '', '', '', ''),
(13, 0, 0, 0, '', '', '', '', '', '', '', '2014-08-26 08:37:40', '2014-08-26 08:37:40', 'N', 10023, '00:00:00', '', '', '', '', '', '', ''),
(14, 0, 0, 0, '', '', '', '', '', '', '', '2014-08-28 08:22:34', '2014-08-28 08:22:34', 'N', 10025, '00:00:00', '', '', '', '', '', '', ''),
(15, 3, 3, 1, '1,6,8,11', '1,2', '1,8,9', '1,2,3,4,6', '1,2,5', '1', '1', '2014-09-03 14:44:07', '2014-09-17 15:29:03', 'N', 10028, '00:00:00', '', '', '', '', '', '', ''),
(16, 0, 0, 0, '', '', '', '', '', '', '', '2014-09-03 14:54:01', '2014-09-03 14:54:01', 'N', 10029, '00:00:00', '', '', '', '', '', '', ''),
(17, 0, 0, 0, '', '', '', '', '', '', '', '2014-09-03 15:02:12', '2014-09-03 15:02:12', 'N', 10031, '00:00:00', '', '', '', '', '', '', ''),
(18, 0, 0, 0, '', '', '', '', '', '', '', '2014-09-03 16:31:03', '2014-09-03 16:31:03', 'N', 10032, '00:00:00', '', '', '', '', '', '', ''),
(19, 0, 0, 0, '', '', '', '', '', '', '', '2014-11-18 13:47:46', '2014-11-18 13:47:46', 'N', 10034, '00:00:00', '', '', '', '', '', '', ''),
(20, 0, 0, 0, '', '', '', '', '', '', '', '2014-11-18 15:55:16', '2014-11-18 15:55:16', 'N', 10035, '00:00:00', '', '', '', '', '', '', '');

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

--
-- Table structure for table `profile_preferred_match`
--

CREATE TABLE IF NOT EXISTS `profile_preferred_match` (
  `profile_preferred_match_id` int(11) NOT NULL AUTO_INCREMENT,
  `partner_age_from` int(11) NOT NULL,
  `partner_age_to` int(11) NOT NULL,
  `partner_height_from` int(11) NOT NULL,
  `partner_height_to` int(11) NOT NULL,
  `partner_mother_tongue` int(11) NOT NULL,
  `partner_religion` int(11) NOT NULL,
  `partner_caste` varchar(255) NOT NULL,
  `partner_willing_marry` varchar(255) NOT NULL,
  `partner_diet` varchar(255) NOT NULL,
  `partner_education` varchar(255) NOT NULL,
  `partner_occupation` varchar(255) NOT NULL,
  `partner_location` varchar(255) NOT NULL,
  `partner_marital_status` varchar(255) NOT NULL,
  `about_partner` text NOT NULL,
  `added_date` datetime NOT NULL,
  `modified_date` datetime NOT NULL,
  `status` enum('Y','N') NOT NULL DEFAULT 'Y',
  `profile_id` int(11) NOT NULL,
  PRIMARY KEY (`profile_preferred_match_id`),
  KEY `profile_id` (`profile_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=21 ;

--
-- Dumping data for table `profile_preferred_match`
--

INSERT INTO `profile_preferred_match` (`profile_preferred_match_id`, `partner_age_from`, `partner_age_to`, `partner_height_from`, `partner_height_to`, `partner_mother_tongue`, `partner_religion`, `partner_caste`, `partner_willing_marry`, `partner_diet`, `partner_education`, `partner_occupation`, `partner_location`, `partner_marital_status`, `about_partner`, `added_date`, `modified_date`, `status`, `profile_id`) VALUES
(1, 0, 0, 0, 0, 0, 0, '', '', '', '', '', '', '', '', '2014-08-19 23:40:28', '2014-08-19 23:40:28', 'N', 10001),
(2, 34, 36, 152, 157, 1, 0, '15', '', '1', '53', '81', '717', '1', 'ffg dfghdg fghfg', '2014-08-19 23:56:27', '2014-08-19 23:56:27', 'N', 10002),
(3, 25, 37, 152, 165, 1, 0, '18,26', '', '1', '53', '81', '717', '2', 'fghfg dfgdf fghfgh', '2014-08-20 00:48:14', '2014-08-20 00:48:14', 'N', 10003),
(4, 0, 0, 0, 0, 0, 0, '', '', '', '', '', '', '', '', '2014-08-20 01:06:28', '2014-08-20 01:06:28', 'N', 10004),
(5, 0, 0, 0, 0, 0, 0, '', '', '', '', '', '', '', '', '2014-08-20 01:49:51', '2014-08-20 01:49:51', 'N', 10005),
(6, 0, 0, 0, 0, 0, 0, '15', '', '', '', '', '', '', '', '2014-08-20 19:55:42', '2014-08-20 19:55:42', 'N', 10006),
(7, 0, 0, 0, 0, 0, 0, '', '', '', '', '', '', '', '', '2014-08-23 11:45:19', '2014-08-23 11:45:19', 'N', 10014),
(8, 0, 0, 0, 0, 0, 0, '15', '', '', '', '', '', '', '', '2014-08-23 11:51:40', '2014-08-23 11:51:40', 'N', 10015),
(9, 23, 31, 142, 157, 5, 0, '15', '', '1', '1', '1', '356', '2', 'fdgbdfg dfgdf hh', '2014-08-26 05:20:40', '2014-08-26 05:20:40', 'N', 10019),
(10, 35, 37, 160, 167, 3, 0, '15', '', '1', '1', '1,2', '356', '2', 'gffg  ffgh fjfj', '2014-08-26 05:25:51', '2014-08-26 05:25:51', 'N', 10020),
(11, 26, 33, 134, 162, 2, 0, '18', '', '2', '1', '1', '356', '2', 'hello hellohello hellohello hellohello hello', '2014-08-26 08:17:41', '2014-08-26 08:17:41', 'N', 10021),
(12, 36, 54, 162, 198, 2, 0, '15', '', '2', '1', '1', '356', '2', 'sdgdfg dfgfds dfgdfg dfgdfg dgdfg', '2014-08-26 08:26:09', '2014-08-26 08:26:09', 'N', 10022),
(13, 35, 45, 149, 165, 3, 0, '15', '', '2', '8', '3', '356', '2', 'dsfgdfsg dfgdfg', '2014-08-26 08:37:40', '2014-08-26 08:37:40', 'N', 10023),
(14, 0, 0, 0, 0, 0, 0, '', '', '', '', '', '', '', '', '2014-08-28 08:22:34', '2014-08-28 08:22:34', 'N', 10025),
(15, 0, 0, 0, 0, 0, 0, '', '', '', '', '', '', '', '', '2014-09-03 14:44:08', '2014-09-03 14:44:08', 'N', 10028),
(16, 0, 0, 0, 0, 0, 0, '', '', '', '', '', '', '', '', '2014-09-03 14:54:01', '2014-09-03 14:54:01', 'N', 10029),
(17, 0, 0, 0, 0, 0, 0, '', '', '', '', '', '', '', '', '2014-09-03 15:02:12', '2014-09-03 15:02:12', 'N', 10031),
(18, 0, 0, 0, 0, 0, 0, '', '', '', '', '', '', '', '', '2014-09-03 16:31:03', '2014-09-03 16:31:03', 'N', 10032),
(19, 0, 0, 0, 0, 0, 0, '', '', '', '', '', '', '', '', '2014-11-18 13:47:46', '2014-11-18 13:47:46', 'N', 10034),
(20, 0, 0, 0, 0, 0, 0, '', '', '', '', '', '', '', '', '2014-11-18 15:55:16', '2014-11-18 15:55:16', 'N', 10035);

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

--
-- Table structure for table `profile_send_mail`
--

CREATE TABLE IF NOT EXISTS `profile_send_mail` (
  `send_mail_id` int(11) NOT NULL AUTO_INCREMENT,
  `profile_id` int(11) NOT NULL,
  `profile_id_message` int(11) NOT NULL,
  `message` text NOT NULL,
  `added_date` datetime NOT NULL,
  `modified_date` datetime NOT NULL,
  `status` enum('Y','N') NOT NULL DEFAULT 'Y',
  PRIMARY KEY (`send_mail_id`),
  KEY `profile_id` (`profile_id`),
  KEY `profile_id_message` (`profile_id_message`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `profile_send_mail`
--

INSERT INTO `profile_send_mail` (`send_mail_id`, `profile_id`, `profile_id_message`, `message`, `added_date`, `modified_date`, `status`) VALUES
(1, 10001, 10002, 'Hi dearrrrrrrrrr ....Hw r U???', '2014-11-21 11:14:24', '2014-11-21 11:14:24', 'Y'),
(2, 10001, 10002, 'kooooooooooooooi!\r\n', '2014-11-21 11:15:04', '2014-11-21 11:15:04', 'Y');

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

--
-- Stand-in structure for view `profile_view`
--
CREATE TABLE IF NOT EXISTS `profile_view` (
`profile_id` int(11)
,`first_name` varchar(255)
,`surname` varchar(255)
,`email` varchar(100)
,`country_code` varchar(255)
,`mobile` varchar(255)
,`gender` enum('Male','Female')
,`religion_id` int(11)
,`caste_id` int(11)
,`country_id` varchar(3)
,`dob` date
,`location_name` varchar(255)
,`image_name` varchar(200)
,`status` enum('Y','N')
,`order_id` int(11)
,`registration_date` date
,`photo_protect` enum('Y','N')
,`login_count` int(11)
,`unique_code` varchar(255)
,`login_date` datetime
,`logout_date` datetime
,`modified_date` datetime
,`payment_status` enum('Y','N')
,`profile_visitedby` text
,`guest_view` int(11)
,`photo_password` varchar(255)
,`admin_status` enum('Y','N')
,`super_admin_status` enum('Y','N')
,`master_admin_status` enum('Y','N')
,`delete_status` enum('Y','N')
,`view_status` enum('Y','N')
,`registration_type` enum('Normal','Quick')
,`login_timer` datetime
,`direct_astro` int(11)
,`software_astro` int(11)
,`view_contact` int(11)
,`profile_basic_id` int(11)
,`marital_status` int(11)
,`have_children` enum('Yes','No')
,`no_of_children` varchar(255)
,`children_living_with` varchar(255)
,`height` int(11)
,`weight` int(11)
,`mother_tongue` varchar(255)
,`sub_caste` varchar(255)
,`physical_status` int(11)
,`education_detail` text
,`spoken_language` varchar(255)
,`education_id` varchar(255)
,`about_me` text
,`contact_person` varchar(255)
,`contact_convenient_time` varchar(255)
,`contact_preferred_type` enum('Mobile','Landline')
,`profile_createdby` int(11)
,`address` text
,`pincode` varchar(255)
,`city` varchar(255)
,`profile_personal_id` int(11)
,`complexion` int(11)
,`occupation_id` int(11)
,`star_id` int(11)
,`body_type` int(11)
,`employed_in` int(11)
,`chovva_dosham` int(11)
,`blood_group` varchar(255)
,`annual_income` varchar(255)
,`shuddha_jatakam` int(11)
,`family_type` int(11)
,`family_status` int(11)
,`family_value` int(11)
,`father_occupation` varchar(255)
,`father_ancestral_place` varchar(255)
,`mother_occupation` varchar(255)
,`mother_ancestral_place` varchar(255)
,`no_of_brother` int(11)
,`brother_married` int(11)
,`no_of_sisters` int(11)
,`sister_married` int(11)
,`about_family` text
,`permanent_location` varchar(3)
,`residential_status` int(11)
,`profile_preferred_match_id` int(11)
,`partner_age_from` int(11)
,`partner_age_to` int(11)
,`partner_height_from` int(11)
,`partner_height_to` int(11)
,`partner_mother_tongue` int(11)
,`partner_religion` int(11)
,`partner_caste` varchar(255)
,`partner_willing_marry` varchar(255)
,`partner_diet` varchar(255)
,`partner_education` varchar(255)
,`partner_occupation` varchar(255)
,`partner_location` varchar(255)
,`partner_marital_status` varchar(255)
,`about_partner` text
,`profile_personality_id` int(11)
,`diet` int(11)
,`smoking` int(11)
,`drinking` int(11)
,`hobbies` varchar(255)
,`music` varchar(255)
,`reading` varchar(255)
,`movies` varchar(255)
,`sports` varchar(255)
,`food` varchar(255)
,`dress` varchar(255)
,`birth_time` time
,`longitude` varchar(255)
,`latitude` varchar(255)
,`timezone` varchar(255)
,`agent_code` varchar(255)
);
-- --------------------------------------------------------

--
-- Table structure for table `profile_visit`
--

CREATE TABLE IF NOT EXISTS `profile_visit` (
  `profile_visit_id` int(11) NOT NULL AUTO_INCREMENT,
  `profile_id_login` int(11) NOT NULL,
  `profile_id_contacted` int(11) NOT NULL,
  `added_date` datetime NOT NULL,
  `modified_date` datetime NOT NULL,
  PRIMARY KEY (`profile_visit_id`),
  KEY `profile_id_login` (`profile_id_login`),
  KEY `profile_id_contacted` (`profile_id_contacted`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=23 ;

--
-- Dumping data for table `profile_visit`
--

INSERT INTO `profile_visit` (`profile_visit_id`, `profile_id_login`, `profile_id_contacted`, `added_date`, `modified_date`) VALUES
(1, 10001, 10002, '2014-08-20 04:32:58', '2014-11-21 13:10:05'),
(2, 10006, 10002, '2014-08-22 04:09:19', '2014-11-21 13:10:05'),
(3, 10006, 0, '2014-08-22 04:18:00', '2014-11-21 13:10:05'),
(4, 10002, 0, '2014-08-22 04:42:52', '2014-11-21 13:10:05'),
(5, 10002, 0, '2014-08-22 04:44:47', '2014-11-21 13:10:05'),
(6, 10002, 0, '2014-08-22 04:49:30', '2014-11-21 13:10:05'),
(7, 10006, 0, '2014-08-22 09:16:43', '2014-11-21 13:10:05'),
(8, 10006, 10015, '2014-08-25 06:24:15', '2014-11-21 13:10:05'),
(9, 10006, 10001, '2014-08-25 06:27:47', '2014-11-21 13:10:05'),
(10, 10021, 10002, '2014-08-26 07:59:37', '2014-11-21 13:10:05'),
(11, 10021, 10005, '2014-08-26 09:53:44', '2014-11-21 13:10:05'),
(12, 10001, 10021, '2014-08-26 10:03:29', '2014-11-21 13:10:05'),
(13, 10001, 10023, '2014-08-26 10:46:50', '2014-11-21 13:10:05'),
(14, 10002, 0, '2014-08-27 11:54:06', '2014-11-21 13:10:05'),
(15, 10025, 10021, '2014-08-28 09:33:47', '2014-11-21 13:10:05'),
(16, 10025, 10002, '2014-08-28 11:47:52', '2014-11-21 13:10:05'),
(17, 10002, 10001, '2014-08-29 06:04:43', '2014-11-21 13:10:05'),
(18, 10002, 0, '2014-08-29 06:05:08', '2014-11-21 13:10:05'),
(19, 10002, 0, '2014-08-29 06:20:20', '2014-11-21 13:10:05'),
(20, 10002, 0, '2014-08-29 06:20:53', '2014-11-21 13:10:05'),
(21, 10024, 10002, '2014-08-29 06:46:33', '2014-11-21 13:10:05'),
(22, 10001, 10006, '2014-09-29 16:09:03', '2014-11-21 13:10:05');

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

--
-- Table structure for table `religion`
--

CREATE TABLE IF NOT EXISTS `religion` (
  `religion_id` int(11) NOT NULL AUTO_INCREMENT,
  `religion_name` varchar(255) NOT NULL,
  PRIMARY KEY (`religion_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `religion`
--

INSERT INTO `religion` (`religion_id`, `religion_name`) VALUES
(1, 'Christian');

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

--
-- Table structure for table `remark`
--

CREATE TABLE IF NOT EXISTS `remark` (
  `remark_id` int(11) NOT NULL AUTO_INCREMENT,
  `profile_id` int(11) NOT NULL,
  `admin_id` int(11) NOT NULL,
  `description` text NOT NULL,
  `added_date` datetime NOT NULL,
  PRIMARY KEY (`remark_id`),
  KEY `admin_id` (`admin_id`),
  KEY `profile_id` (`profile_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=15 ;

--
-- Dumping data for table `remark`
--

INSERT INTO `remark` (`remark_id`, `profile_id`, `admin_id`, `description`, `added_date`) VALUES
(1, 10002, 2, 'remark1', '2014-01-10 15:36:45'),
(2, 10002, 2, 'remark2223', '2014-01-10 15:36:54'),
(3, 23, 2, 'hai umesh', '2014-01-10 15:37:19'),
(4, 10005, 2, 'hai mrudula rem1', '2014-01-10 15:37:33'),
(5, 23, 1, 'test remark su', '2014-01-10 15:38:27'),
(6, 10005, 1, 'hai mrudu su rem', '2014-01-10 15:42:46'),
(7, 23, 3, 'remark by master authority', '2014-01-10 15:45:46'),
(8, 10005, 3, 'remark by master auth', '2014-01-10 15:46:04'),
(9, 23, 2, 'test remark', '2014-01-18 15:26:29'),
(10, 23, 1, '134575687568', '2014-01-18 15:30:52'),
(11, 10005, 2, 'WARNING ! Access and use of this section by anyone without permission of the owner of Ginger Marry is strictly prohibited.\r\nAn unauthorized user, including employees are subject to criminal and civil penalties, as well as Company initiated disciplinary action. \r\nBest viewed with screen resolution 1280 * 960 or higher.', '2014-05-08 10:30:29'),
(12, 10005, 3, 'koioii', '2014-05-08 10:43:38'),
(13, 10002, 1, 'staff remark', '2014-05-08 15:58:35'),
(14, 10137, 3, 'hah hahahahha', '2014-05-09 11:59:20');

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

--
-- Table structure for table `search_save`
--

CREATE TABLE IF NOT EXISTS `search_save` (
  `search_id` int(11) NOT NULL AUTO_INCREMENT,
  `profile_id` int(11) NOT NULL,
  `search_url` text NOT NULL,
  `search_name` varchar(255) NOT NULL,
  `added_date` datetime NOT NULL,
  PRIMARY KEY (`search_id`),
  KEY `profile_id` (`profile_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=41 ;

--
-- Dumping data for table `search_save`
--

INSERT INTO `search_save` (`search_id`, `profile_id`, `search_url`, `search_name`, `added_date`) VALUES
(4, 27, 'http://localhost/gingermarry.com/search_result.php?gender=Female&religion_id=9&caste_id=0&country_id=0&height_from=&height_to=&age_from=18&age_to=28&profile_image=undefined', 'sandhya', '2013-12-11 16:43:30'),
(5, 27, 'http://localhost/gingermarry.com/search_result.php?gender=Female&religion_id=9&caste_id=0&country_id=0&height_from=&height_to=&age_from=18&age_to=28&profile_image=undefined&page=2', 'asdfghj', '2013-12-11 16:43:47'),
(6, 27, 'http://localhost/gingermarry.com/search_result.php?gender=Female&age_from=18&age_to=28&religion_id=4&caste_id=0&country_id=0', 'jain', '2013-12-11 16:44:59'),
(20, 10018, 'http://localhost/gingermarry.com/search_result.php?gender=Male&age_from=18&age_to=32&religion_id=9&caste_id=0&country_id=0', 'groom', '2013-12-12 16:48:07'),
(21, 10018, 'http://localhost/gingermarry.com/search_result.php?gender=Female&age_from=18&age_to=25&religion_id=1&caste_id=0&country_id=0', 'christian', '2013-12-12 16:48:31'),
(22, 10018, 'http://localhost/gingermarry.com/search_result.php?gender=Female&age_from=18&age_to=25&religion_id=2&caste_id=0&country_id=0', 'hindu', '2013-12-12 16:48:45'),
(39, 23, 'http://localhost/gingermarry.com/search_result.php?age_from=18&age_to=29&gender=Female&religion_id=9&caste_id=115&height_from=&height_to=&education_id=53&country_id=0&star_id=&marital_status=1&occupation_id=9&complexion=&mother_tongue=&save=Go', 'bank', '2014-03-24 15:06:22'),
(40, 23, 'http://localhost/gingermarry.com/search_result.php?age_from=18&age_to=29&gender=Female&religion_id=2&caste_id=117&height_from=&height_to=&education_id=53&country_id=356&star_id=&marital_status=1&occupation_id=9&complexion=&mother_tongue=&save=Go', 'hindu', '2014-03-24 15:06:44');

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

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

CREATE TABLE IF NOT EXISTS `settings` (
  `settings_id` int(4) NOT NULL AUTO_INCREMENT,
  `caption` varchar(50) NOT NULL,
  `keys` varchar(50) NOT NULL,
  `values` text NOT NULL,
  `display` enum('Y','N') NOT NULL,
  PRIMARY KEY (`settings_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT AUTO_INCREMENT=36 ;

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

INSERT INTO `settings` (`settings_id`, `caption`, `keys`, `values`, `display`) VALUES
(1, 'Website Name', 'SITE_NAME', 'Jacobite Matrimony', 'Y'),
(2, 'Website URL', 'SITE_URL', ' http://jacobitesmatrimonial.com', 'Y'),
(3, 'Client Page Title', 'FRONT_TITLE', 'Jacobite Matrimony ', 'Y'),
(4, 'Admin Page Title', 'ADMIN_TITLE', 'Jacobite Matrimony - Administration Control Panel', 'Y'),
(5, 'Meta Description', 'META_DESCRIPTION', 'Jacobite Matrimony ,Malayalee Matrimonial, search for Kerala brides and grooms.  Partners from all communities.  Complete wedding portal', 'Y'),
(6, 'Meta Keywords', 'META_KEYWORDS', 'Jacobite Matrimony  ,Malayalee Matrimonial, Kerala brides and grooms, Kerala Marriage, Malayalee matrimonial site, Kerala NRI matrimonial, Malayalee matrimonials, Keralite Matrimonials, Matrimony in Kerala, Kerala Chirstian Matrimonials, Kerala Hindu Matrimonials, Kerala Muslim Matrimonials, Malayalee brides and grooms, Malayalee brides, Malayalee Grooms, Malayalee marriage, Kerala Marriage, Kerala wedding, Malayalee wedding, Kerala marry, Malayalee Marry, Ginger marry Matrimonials, Malayalee muslim marriage, Malayalee Christian marriage, Malayalee Christian marriage,Matrimonials, Matrimonial Sites, Marriage, Brides', 'Y'),
(7, 'Client Max. No. of Rows/Page', 'FRONT_PAGE_LIMIT', '12', 'Y'),
(8, 'Admin Max. No. of Rows/Page', 'PAGE_LIMIT', '25', 'Y'),
(9, 'Admin Email Display Name', 'ADMIN_EMAIL_NAME', 'Jacobite Matrimony ', 'Y'),
(10, 'Admin Email', 'ADMIN_EMAIL_ID', 'cuumesh1@gmail.com', 'Y'),
(11, 'Admin Reply Email', 'ADMIN_REPLY_EMAIL_ID', 'web@kissmypixels.co.uk', 'N'),
(12, 'Contact Us Email', 'CONTACT_EMAIL_ID', 'info@ariuswebstudio.com', 'Y'),
(13, 'Bounce  Email', 'BOUNCE_EMAIL_ID', 'web@kissmypixels.co.uk', 'N'),
(14, 'Address', 'ADDRESS', 'Amwell View School and Specialist Sports College<br />Stanstead Abbotts, Nr, Ware, Statio', 'N'),
(15, 'Contact Phone', 'PHONE', '+91 93 888 999 60', 'Y'),
(16, 'Fax', 'FAX', '91 93 888 999 60', 'Y'),
(17, 'Facebook URL', 'FACEBOOK_URL', 'https://www.facebook.com/jacobitematrimonial', 'Y'),
(18, 'Twitter URL', 'TWITTER_URL', 'https://twitter.com/jacobitesmarry', 'Y'),
(19, 'Minimum Image Width', 'MIN_IMAGE_WIDTH', '280', 'N'),
(20, 'Minimum Image Height', 'MIN_IMAGE_HEIGHT', '207', 'N'),
(21, 'Maximum Image Width', 'MAX_IMAGE_WIDTH', '745', 'N'),
(22, 'Maximum Image Height', 'MAX_IMAGE_HEIGHT', '695', 'N'),
(23, 'Maximum Width Of Thumb Image', 'MAX_THUMB_IMAGE_WIDTH', '150', 'N'),
(24, 'Maximum Height Of Thumb Image', 'MAX_THUMB_IMAGE_HEIGHT', '209', 'N'),
(25, 'Number of emails sent by cron', 'CRON_EMAIL_COUNT', '20', 'N'),
(26, 'Admin Page Theme', 'ADMIN_THEME', 'gray', 'N'),
(27, 'Default county', 'DEFAULT_COUNTRY', '356', 'N'),
(28, 'Customer Care', 'CUSTOMER_CARE', '+91 484 3201000', 'Y'),
(29, 'Google Plus URL', 'GOOGLE_PLUS_URL', 'https://www.pinterest.com/jacobitesmarry', 'Y'),
(30, 'Youtube', 'YOUTUBE_URL', 'https://www.youtube.com/', 'Y'),
(31, 'Copyright Title', 'COPYRIGHT', 'Jacobite Matrimony ', 'Y'),
(32, 'Postal Address', 'POSTAL_ADDRESS', 'Jacobite Matrimonial Services\r\nMenothunalil Buildings, Asamannoor PO, Odakkaly, Perumbavoor, \r\nErnakulam Dist, Kerala PIn 683549\r\n\r\nTel : 0484 3201000, +91 93 888 999 60', 'Y'),
(33, 'SMS Username', 'SMS_USERNAME', 'SCK35954', 'N'),
(34, 'SMS Password', 'SMS_PASSWORD', 'amwell123', 'N'),
(35, 'SMS From Test', 'SMS_FROM', 'Amwell View School', 'N');

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

--
-- Table structure for table `sms`
--

CREATE TABLE IF NOT EXISTS `sms` (
  `sms_id` int(10) NOT NULL AUTO_INCREMENT,
  `description` text NOT NULL,
  `added_date` datetime NOT NULL,
  `status` enum('Y','N') NOT NULL DEFAULT 'Y',
  `draft_status` enum('Y','N') NOT NULL DEFAULT 'N',
  PRIMARY KEY (`sms_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=51 ;

--
-- Dumping data for table `sms`
--

INSERT INTO `sms` (`sms_id`, `description`, `added_date`, `status`, `draft_status`) VALUES
(18, 'WARNING ! Access and use of this section by anyone without permission of the owner of Amwell View School & Specialist Sports College is stri', '2013-04-18 12:46:45', 'Y', 'N'),
(19, 'ARNING ! Access and use of this section by anyone without permission of the owner xxxxxxxxxxxxxxxxxxxx', '2013-04-18 12:47:02', 'Y', 'Y'),
(21, 'kkkkkkkkkkkkkk2', '2013-04-18 12:55:12', 'Y', 'Y'),
(22, 'Maximum characters: 140 You hav', '2013-04-18 12:58:04', 'Y', 'N'),
(23, 'new smssss1134zzzzzzzzz', '2013-04-18 12:59:24', 'Y', 'Y'),
(39, 'Maximum characters', '2013-04-18 14:30:19', 'Y', 'N'),
(40, 'fcgdfsg', '2013-04-18 14:37:21', 'Y', 'N'),
(41, 'test', '2013-04-18 14:41:23', 'Y', 'N'),
(42, 'koooooooooooooooi', '2013-04-18 14:45:56', 'Y', 'N'),
(43, 'fghgh', '2013-04-18 15:03:49', 'Y', 'N'),
(44, 'fghfgjgh', '2013-04-18 15:03:59', 'Y', 'N'),
(45, 'uuuuuuuuuuuuuuuuuuu', '2013-04-18 16:21:49', 'Y', 'N'),
(48, 'qqqqqqqqqqqq', '2013-04-18 16:23:09', 'Y', 'N'),
(49, 'xcvbxcvbcv', '2013-04-18 16:47:41', 'Y', 'N'),
(50, 'fghf', '2013-04-18 18:55:49', 'Y', 'Y');

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

--
-- Table structure for table `star`
--

CREATE TABLE IF NOT EXISTS `star` (
  `star_id` int(11) NOT NULL AUTO_INCREMENT,
  `star_name` varchar(255) NOT NULL,
  PRIMARY KEY (`star_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=28 ;

--
-- Dumping data for table `star`
--

INSERT INTO `star` (`star_id`, `star_name`) VALUES
(1, 'Aswathi'),
(2, 'Bharani'),
(3, 'Karthika'),
(4, 'Rohini'),
(5, 'Makayiram'),
(6, 'Thiruvathira'),
(7, 'Punartham'),
(8, 'Pooyam'),
(9, 'Ayilyam'),
(10, 'Makam'),
(11, 'Pooram'),
(12, 'Uthram'),
(13, 'Atham'),
(14, 'Chithira'),
(15, 'Chothi'),
(16, 'Vishakom'),
(17, 'Anizham'),
(18, 'Triketta'),
(19, 'Moolam'),
(20, 'Pooradam'),
(21, 'Uthradam'),
(22, 'Thiruvonam'),
(23, 'Avittam'),
(24, 'Chathayam'),
(25, 'Poororutathy'),
(26, 'Uthratathy'),
(27, 'Revathi');

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

--
-- Table structure for table `success_story`
--

CREATE TABLE IF NOT EXISTS `success_story` (
  `success_story_id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `profile_id` int(11) NOT NULL,
  `partner_name` varchar(255) NOT NULL,
  `partner_profile_id` int(11) NOT NULL,
  `marriage_date` date NOT NULL,
  `description` text NOT NULL,
  `image_name` varchar(255) NOT NULL,
  `success_story_date` date NOT NULL,
  `status` enum('Y','N') NOT NULL DEFAULT 'N',
  PRIMARY KEY (`success_story_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;

--
-- Dumping data for table `success_story`
--

INSERT INTO `success_story` (`success_story_id`, `title`, `name`, `profile_id`, `partner_name`, `partner_profile_id`, `marriage_date`, `description`, `image_name`, `success_story_date`, `status`) VALUES
(1, 'test1', 'test', 675665, 'demo', 5654, '2013-10-07', 'ghfghfgh', '141328364362639500141328364378085tulips.jpg', '2014-10-14', 'Y'),
(2, 'test2', 'test', 675665, 'demo', 5654, '2013-10-10', 'ghfghfgh', '141328361813935500141328361829986penguins.jpg', '2014-10-14', 'Y'),
(3, 'test3', 'test', 675665, 'demo', 5654, '2013-10-02', 'ghfghfgh', '141328359922815700141328359950918lighthouse.jpg', '2014-10-14', 'Y'),
(4, 'test4', 'test', 675665, 'demo', 5654, '2014-10-07', 'ghfghfgh', '141328353590066300141328353534582koala.jpg', '2014-10-14', 'Y'),
(5, 'test5', 'test', 675665, 'demo', 5654, '2014-10-07', 'ghfghfgh', '14132835136351160014132835137296jellyfish.jpg', '2014-10-14', 'Y'),
(6, 'test6', 'test', 675665, 'demo', 5654, '2014-10-07', 'ghfghfgh', '141328348367977700141328348339715hydrangeas.jpg', '2014-10-14', 'Y'),
(7, 'new', 'test', 675665, 'demo', 5654, '2014-10-06', 'ghfghfgh', '141328345550135000141328345530422desert.jpg', '2014-10-14', 'Y'),
(8, 'demo', 'test', 675665, 'demo', 5654, '2014-10-07', 'ghfghfgh', '141328342567803000141328342548901chrysanthemum.jpg', '2014-10-14', 'Y');

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

--
-- Table structure for table `template`
--

CREATE TABLE IF NOT EXISTS `template` (
  `template_id` int(11) NOT NULL AUTO_INCREMENT,
  `template_name` varchar(255) NOT NULL,
  `description` text NOT NULL,
  PRIMARY KEY (`template_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;

--
-- Dumping data for table `template`
--

INSERT INTO `template` (`template_id`, `template_name`, `description`) VALUES
(1, 'About Me', 'I am a simple and loving, god fearing person to my family.'),
(2, 'About Me', 'I am from a middle class family and I give more values and respect to my parents.'),
(3, 'About Me', 'I am from an Upper class traditional family and respect my family very much.'),
(4, 'About Me', 'I am now in abroad and looking for a good partner who loves and takes care about me and my family.'),
(5, 'About Family', 'I and my parents are professionals and I am looking for a partner from the same class.'),
(6, 'About Family', 'My middle class family consisting with my parents and brother and sisters. We all are very close to our family.'),
(7, 'About Family', 'My family is a middle class with brothers and sister to me.'),
(8, 'About my Partner', 'My partner should have good and strong vision about family and future plans.'),
(9, 'About my Partner', 'I respect a suitable partner who can take love and care to me and my family members.'),
(10, 'About my Partner', 'My partner should be a caring, loving and non-smoker.'),
(11, 'About my Partner', 'My partner should be a god fearing, understanding and an educated person.'),
(12, 'About Family', 'My family is a nuclear family and respects traditional values.'),
(13, 'About Family', 'We are from a traditional family and give more importance to it.'),
(14, 'About Family', 'My all family members consist with funloving and god fearing people.');

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

--
-- Table structure for table `video_gallery`
--

CREATE TABLE IF NOT EXISTS `video_gallery` (
  `video_gallery_id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL,
  `video_name` varchar(200) NOT NULL,
  `description` text NOT NULL,
  `added_date` datetime NOT NULL,
  `order_id` int(11) NOT NULL,
  `status` enum('Y','N') NOT NULL DEFAULT 'Y',
  PRIMARY KEY (`video_gallery_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `video_gallery`
--


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

--
-- Structure for view `profile_view`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `profile_view` AS select `a`.`profile_id` AS `profile_id`,`a`.`first_name` AS `first_name`,`a`.`surname` AS `surname`,`a`.`email` AS `email`,`a`.`country_code` AS `country_code`,`a`.`mobile` AS `mobile`,`a`.`gender` AS `gender`,`a`.`religion_id` AS `religion_id`,`a`.`caste_id` AS `caste_id`,`a`.`country_id` AS `country_id`,`a`.`dob` AS `dob`,`a`.`location_name` AS `location_name`,`a`.`image_name` AS `image_name`,`a`.`status` AS `status`,`a`.`order_id` AS `order_id`,`a`.`registration_date` AS `registration_date`,`a`.`photo_protect` AS `photo_protect`,`a`.`login_count` AS `login_count`,`a`.`unique_code` AS `unique_code`,`a`.`login_date` AS `login_date`,`a`.`logout_date` AS `logout_date`,`a`.`modified_date` AS `modified_date`,`a`.`payment_status` AS `payment_status`,`a`.`profile_visitedby` AS `profile_visitedby`,`a`.`guest_view` AS `guest_view`,`a`.`photo_password` AS `photo_password`,`a`.`admin_status` AS `admin_status`,`a`.`super_admin_status` AS `super_admin_status`,`a`.`master_admin_status` AS `master_admin_status`,`a`.`delete_status` AS `delete_status`,`a`.`view_status` AS `view_status`,`a`.`registration_type` AS `registration_type`,`a`.`login_timer` AS `login_timer`,`a`.`direct_astro` AS `direct_astro`,`a`.`software_astro` AS `software_astro`,`a`.`view_contact` AS `view_contact`,`b`.`profile_basic_id` AS `profile_basic_id`,`b`.`marital_status` AS `marital_status`,`b`.`have_children` AS `have_children`,`b`.`no_of_children` AS `no_of_children`,`b`.`children_living_with` AS `children_living_with`,`b`.`height` AS `height`,`b`.`weight` AS `weight`,`b`.`mother_tongue` AS `mother_tongue`,`b`.`sub_caste` AS `sub_caste`,`b`.`physical_status` AS `physical_status`,`b`.`education_detail` AS `education_detail`,`b`.`spoken_language` AS `spoken_language`,`b`.`education_id` AS `education_id`,`b`.`about_me` AS `about_me`,`b`.`contact_person` AS `contact_person`,`b`.`contact_convenient_time` AS `contact_convenient_time`,`b`.`contact_preferred_type` AS `contact_preferred_type`,`b`.`profile_createdby` AS `profile_createdby`,`b`.`address` AS `address`,`b`.`pincode` AS `pincode`,`b`.`city` AS `city`,`c`.`profile_personal_id` AS `profile_personal_id`,`c`.`complexion` AS `complexion`,`c`.`occupation_id` AS `occupation_id`,`c`.`star_id` AS `star_id`,`c`.`body_type` AS `body_type`,`c`.`employed_in` AS `employed_in`,`c`.`chovva_dosham` AS `chovva_dosham`,`c`.`blood_group` AS `blood_group`,`c`.`annual_income` AS `annual_income`,`c`.`shuddha_jatakam` AS `shuddha_jatakam`,`c`.`family_type` AS `family_type`,`c`.`family_status` AS `family_status`,`c`.`family_value` AS `family_value`,`c`.`father_occupation` AS `father_occupation`,`c`.`father_ancestral_place` AS `father_ancestral_place`,`c`.`mother_occupation` AS `mother_occupation`,`c`.`mother_ancestral_place` AS `mother_ancestral_place`,`c`.`no_of_brother` AS `no_of_brother`,`c`.`brother_married` AS `brother_married`,`c`.`no_of_sisters` AS `no_of_sisters`,`c`.`sister_married` AS `sister_married`,`c`.`about_family` AS `about_family`,`c`.`permanent_location` AS `permanent_location`,`c`.`residential_status` AS `residential_status`,`d`.`profile_preferred_match_id` AS `profile_preferred_match_id`,`d`.`partner_age_from` AS `partner_age_from`,`d`.`partner_age_to` AS `partner_age_to`,`d`.`partner_height_from` AS `partner_height_from`,`d`.`partner_height_to` AS `partner_height_to`,`d`.`partner_mother_tongue` AS `partner_mother_tongue`,`d`.`partner_religion` AS `partner_religion`,`d`.`partner_caste` AS `partner_caste`,`d`.`partner_willing_marry` AS `partner_willing_marry`,`d`.`partner_diet` AS `partner_diet`,`d`.`partner_education` AS `partner_education`,`d`.`partner_occupation` AS `partner_occupation`,`d`.`partner_location` AS `partner_location`,`d`.`partner_marital_status` AS `partner_marital_status`,`d`.`about_partner` AS `about_partner`,`e`.`profile_personality_id` AS `profile_personality_id`,`e`.`diet` AS `diet`,`e`.`smoking` AS `smoking`,`e`.`drinking` AS `drinking`,`e`.`hobbies` AS `hobbies`,`e`.`music` AS `music`,`e`.`reading` AS `reading`,`e`.`movies` AS `movies`,`e`.`sports` AS `sports`,`e`.`food` AS `food`,`e`.`dress` AS `dress`,`e`.`birth_time` AS `birth_time`,`e`.`longitude` AS `longitude`,`e`.`latitude` AS `latitude`,`e`.`timezone` AS `timezone`,`e`.`agent_code` AS `agent_code` from ((((`profile` `a` join `profile_basic` `b` on((`a`.`profile_id` = `b`.`profile_id`))) join `profile_personal` `c` on((`b`.`profile_id` = `c`.`profile_id`))) join `profile_preferred_match` `d` on((`c`.`profile_id` = `d`.`profile_id`))) join `profile_personality` `e` on((`d`.`profile_id` = `e`.`profile_id`)));
