-- phpMyAdmin SQL Dump
-- version 3.4.9
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Sep 26, 2012 at 04:31 AM
-- Server version: 5.1.65
-- PHP Version: 5.2.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `gopiligr_piligrim`
--

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

--
-- Table structure for table `tbl_admin`
--

CREATE TABLE IF NOT EXISTS `tbl_admin` (
  `admin_id` int(11) NOT NULL AUTO_INCREMENT,
  `admin_fname` varchar(100) NOT NULL,
  `admin_mname` varchar(100) DEFAULT NULL,
  `admin_lname` varchar(100) NOT NULL,
  `admin_email_address` varchar(255) NOT NULL,
  `admin_password` varchar(255) NOT NULL,
  `admin_access` text NOT NULL,
  `access_event` text,
  `admin_created_date` datetime NOT NULL,
  `admin_last_login_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `admin_last_login_ip` varchar(50) DEFAULT NULL,
  `admin_status` enum('0','1') NOT NULL DEFAULT '0',
  PRIMARY KEY (`admin_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=35 ;

--
-- Dumping data for table `tbl_admin`
--

INSERT INTO `tbl_admin` (`admin_id`, `admin_fname`, `admin_mname`, `admin_lname`, `admin_email_address`, `admin_password`, `admin_access`, `access_event`, `admin_created_date`, `admin_last_login_date`, `admin_last_login_ip`, `admin_status`) VALUES
(1, 'Super', '', 'Admin', 'munir@creativecartels.com', '55ebe52d22222e6a6a1802daf99d1605', 'Full', 'Full', '2011-10-05 12:40:52', '2012-09-26 05:49:52', '122.169.29.45', '1'),
(34, 'Paras', '', 'Mathukiya', 'paras@creativecartels.com', '8c5daa8c6473cc9c4964f74a4fb3344c', '1,2,3,5,8,4,10,6,7', 'a:9:{i:1;a:3:{i:0;s:3:"add";i:1;s:4:"edit";i:2;s:6:"delete";}i:2;a:3:{i:0;s:3:"add";i:1;s:4:"edit";i:2;s:6:"delete";}i:3;a:3:{i:0;s:3:"add";i:1;s:4:"edit";i:2;s:6:"delete";}i:5;a:3:{i:0;s:3:"add";i:1;s:4:"edit";i:2;s:6:"delete";}i:8;a:3:{i:0;s:3:"add";i:1;s:4:"edit";i:2;s:6:"delete";}i:4;a:3:{i:0;s:3:"add";i:1;s:4:"edit";i:2;s:6:"delete";}i:10;a:3:{i:0;s:3:"add";i:1;s:4:"edit";i:2;s:6:"delete";}i:6;a:3:{i:0;s:3:"add";i:1;s:4:"edit";i:2;s:6:"delete";}i:7;a:3:{i:0;s:3:"add";i:1;s:4:"edit";i:2;s:6:"delete";}}', '2012-09-25 07:22:56', '2012-09-25 12:23:26', '122.179.143.113', '1');

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

--
-- Table structure for table `tbl_country`
--

CREATE TABLE IF NOT EXISTS `tbl_country` (
  `country_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(225) COLLATE latin1_german2_ci NOT NULL,
  `status` enum('Active','Inactive') COLLATE latin1_german2_ci NOT NULL DEFAULT 'Active',
  PRIMARY KEY (`country_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci AUTO_INCREMENT=476 ;

--
-- Dumping data for table `tbl_country`
--

INSERT INTO `tbl_country` (`country_id`, `name`, `status`) VALUES
(1, 'United States', 'Active'),
(3, 'Afghanistan', 'Active'),
(5, 'Albania', 'Active'),
(7, 'Algeria', 'Active'),
(9, 'American Samoa', 'Active'),
(11, 'Andorra', 'Active'),
(13, 'Angola', 'Active'),
(15, 'Anguilla', 'Active'),
(17, 'Antarctica', 'Active'),
(19, 'Antigua and Barbuda', 'Active'),
(21, 'Argentina', 'Active'),
(23, 'Armenia', 'Active'),
(25, 'Aruba', 'Active'),
(27, 'Australia', 'Active'),
(29, 'Austria', 'Active'),
(31, 'Azerbaijan', 'Active'),
(33, 'Bahamas', 'Active'),
(35, 'Bahrain', 'Active'),
(37, 'Bangladesh', 'Active'),
(39, 'Barbados', 'Active'),
(41, 'Belarus', 'Active'),
(43, 'Belgium', 'Active'),
(45, 'Belize', 'Active'),
(47, 'Benin', 'Active'),
(49, 'Bermuda', 'Active'),
(51, 'Bhutan', 'Active'),
(53, 'Bolivia', 'Active'),
(55, 'Bosnia and Herzegowina', 'Active'),
(57, 'Botswana', 'Active'),
(59, 'Bouvet Island', 'Active'),
(61, 'Brazil', 'Active'),
(63, 'British Indian Ocean Territory', 'Active'),
(65, 'Brunei Darussalam', 'Active'),
(67, 'Bulgaria', 'Active'),
(69, 'Burkina Faso', 'Active'),
(71, 'Burundi', 'Active'),
(75, 'Cambodia', 'Active'),
(77, 'Cameroon', 'Active'),
(79, 'Canada', 'Active'),
(81, 'Cape Verde', 'Active'),
(83, 'Cayman Islands', 'Active'),
(85, 'Central African Republic', 'Active'),
(87, 'Chad', 'Active'),
(89, 'Chile', 'Active'),
(91, 'China', 'Active'),
(93, 'Christmas Island', 'Active'),
(95, 'Cocos (Keeling) Islands', 'Active'),
(97, 'Colombia', 'Active'),
(99, 'Comoros', 'Active'),
(100, 'Comoros Irsih', 'Active'),
(101, 'Congo', 'Active'),
(103, 'Congo, the Democratic Republic of the', 'Active'),
(105, 'Cook Islands', 'Active'),
(107, 'Costa Rica', 'Active'),
(109, 'Cote d''Ivoire', 'Active'),
(111, 'Croatia (Hrvatska)', 'Active'),
(113, 'Cuba', 'Active'),
(115, 'Cyprus', 'Active'),
(117, 'Czech Republic', 'Active'),
(119, 'Denmark', 'Active'),
(121, 'Djibouti', 'Active'),
(123, 'Dominica ', 'Active'),
(125, 'Dominican Republic ', 'Active'),
(127, 'East Timor ', 'Active'),
(129, 'Ecuador', 'Active'),
(131, 'Egypt ', 'Active'),
(133, 'El Salvador', 'Active'),
(135, 'Equatorial Guinea ', 'Active'),
(137, 'Eritrea', 'Active'),
(139, 'Estonia', 'Active'),
(141, 'Ethiopia  ', 'Active'),
(143, 'Falkland Islands (Malvinas)', 'Active'),
(145, 'Faroe Islands ', 'Active'),
(147, 'Fiji  ', 'Active'),
(149, 'Finland ', 'Active'),
(151, 'France', 'Active'),
(153, 'French Guiana ', 'Active'),
(155, 'French Polynesia', 'Active'),
(157, 'Gabon', 'Active'),
(159, 'Gambia', 'Active'),
(161, 'Georgia ', 'Active'),
(163, 'Germany  ', 'Active'),
(165, 'Ghana  ', 'Active'),
(167, 'Gibraltar', 'Active'),
(169, 'Greece  ', 'Active'),
(171, 'Greenland ', 'Active'),
(173, 'Grenada', 'Active'),
(175, 'Guadeloupe', 'Active'),
(177, 'Guam ', 'Active'),
(179, 'Guatemala', 'Active'),
(181, 'Guinea-Bissau ', 'Active'),
(183, 'Guyana', 'Active'),
(185, 'Haiti ', 'Active'),
(187, 'Heard and Mc Donald Islands', 'Active'),
(189, 'Honduras', 'Active'),
(191, 'Hong Kong', 'Active'),
(193, 'Hungary', 'Active'),
(195, 'Iceland ', 'Active'),
(197, 'India', 'Active'),
(199, 'Indonesia ', 'Active'),
(201, 'Iran(Islamic Republic of)Iran(Islamic Republic of)', 'Active'),
(203, 'Iraq ', 'Active'),
(205, 'Ireland', 'Active'),
(207, 'Israel ', 'Active'),
(211, 'Italy ', 'Active'),
(213, 'Jamaica ', 'Active'),
(215, 'Japan ', 'Active'),
(217, 'Jordan ', 'Active'),
(219, 'Kazakhstan', 'Active'),
(221, 'Kenya ', 'Active'),
(223, 'Kiribati', 'Active'),
(225, 'Korea, Democratic Peoples Republic of', 'Active'),
(227, 'Korea, Republic of ', 'Active'),
(229, 'Kuwait ', 'Active'),
(231, 'Kyrgyzstan ', 'Active'),
(233, 'Lao Peoples Democratic Republic ', 'Active'),
(235, 'Latvia ', 'Active'),
(237, 'Lebanon', 'Active'),
(239, 'Lesotho ', 'Active'),
(241, 'Liberia', 'Active'),
(242, 'Liberia', 'Active'),
(243, 'Libyan Arab Jamahiriya', 'Active'),
(245, 'Liechtenstein', 'Active'),
(247, 'Lithuania', 'Active'),
(249, 'Luxembourg', 'Active'),
(251, 'Macau ', 'Active'),
(253, 'Macedonia, The Former Yugoslav Republic of ', 'Active'),
(255, 'Madagascar', 'Active'),
(257, 'Malawi  ', 'Active'),
(259, 'Malaysia ', 'Active'),
(261, 'Maldives', 'Active'),
(263, 'Mali', 'Active'),
(265, 'Malta ', 'Active'),
(267, 'Marshall Islands', 'Active'),
(269, 'Martinique ', 'Active'),
(272, 'Mauritania ', 'Active'),
(273, 'Mauritius ', 'Active'),
(275, 'Mayotte ', 'Active'),
(277, 'Mexico', 'Active'),
(279, 'Micronesia, Federated States of', 'Active'),
(281, 'Moldova, Republic of', 'Active'),
(283, 'Monaco ', 'Active'),
(285, 'Mongolia ', 'Active'),
(287, 'Montserrat', 'Active'),
(289, 'Morocco ', 'Active'),
(291, 'Mozambique', 'Active'),
(293, 'Myanmar ', 'Active'),
(295, 'Namibia', 'Active'),
(297, 'Nauru', 'Active'),
(299, 'Nepal', 'Active'),
(301, 'Netherlands', 'Active'),
(303, 'Netherlands Antilles', 'Active'),
(305, 'New Caledonia ', 'Active'),
(307, 'New Zealand', 'Active'),
(309, 'Nicaragua ', 'Active'),
(311, 'Niger ', 'Active'),
(313, 'Nigeria ', 'Active'),
(315, 'Norfolk Island', 'Active'),
(317, 'Northern Mariana Islands', 'Active'),
(319, 'Norway ', 'Active'),
(321, 'Oman ', 'Active'),
(323, 'Pakistan ', 'Active'),
(325, 'Palau ', 'Active'),
(327, 'Panama ', 'Active'),
(329, 'Papua New Guinea ', 'Active'),
(331, 'Paraguay', 'Active'),
(333, 'Peru ', 'Active'),
(335, 'Philippines', 'Active'),
(337, 'Pitcairn ', 'Active'),
(339, 'Poland ', 'Active'),
(341, 'Portugal', 'Active'),
(343, 'Puerto Rico ', 'Active'),
(345, 'Qatar ', 'Active'),
(347, 'Reunion ', 'Active'),
(349, 'Romania ', 'Active'),
(351, 'Russian Federation', 'Active'),
(353, 'Rwanda', 'Active'),
(355, 'Saint Kitts and Nevis', 'Active'),
(357, 'Saint LUCIA', 'Active'),
(359, 'Saint Vincent and the Grenadines ', 'Active'),
(361, 'Samoa ', 'Active'),
(363, 'San Marino  ', 'Active'),
(365, 'Sao Tome and Principe', 'Active'),
(367, 'Saudi Arabia  ', 'Active'),
(369, 'Senegal ', 'Active'),
(371, 'Seychelles', 'Active'),
(373, 'Sierra Leone ', 'Active'),
(375, 'Singapore ', 'Active'),
(377, 'Slovakia (Slovak Republic) ', 'Active'),
(379, 'Slovenia ', 'Active'),
(381, 'Solomon Islands       ', 'Active'),
(383, 'Somalia ', 'Active'),
(385, 'South Africa ', 'Active'),
(387, 'South Georgia and the South Sandwich Islands', 'Active'),
(389, 'Spain       ', 'Active'),
(391, 'Sri Lanka ', 'Active'),
(393, 'St. Helena', 'Active'),
(395, 'St. Martin', 'Active'),
(397, 'St. Pierre and Miquelon', 'Active'),
(399, 'Sudan ', 'Active'),
(401, 'Suriname ', 'Active'),
(403, 'Svalbard and Jan Mayen Islands', 'Active'),
(405, 'Swaziland       ', 'Active'),
(407, 'Sweden', 'Active'),
(409, 'Switzerland ', 'Active'),
(411, 'Syrian Arab Republic ', 'Active'),
(413, 'Taiwan, Province of China ', 'Active'),
(415, 'Tajikistan', 'Active'),
(417, 'Tanzania, United Republic of ', 'Active'),
(419, 'Thailand ', 'Active'),
(421, 'Togo ', 'Active'),
(423, 'Tokelau ', 'Active'),
(425, 'Tonga', 'Active'),
(427, 'Trinidad and Tobago', 'Active'),
(429, 'Tunisia ', 'Active'),
(431, 'Turkey ', 'Active'),
(433, 'Turkmenistan ', 'Active'),
(435, 'Turks and Caicos Islands', 'Active'),
(437, 'Tuvalu ', 'Active'),
(439, 'Uganda', 'Active'),
(441, 'Ukraine ', 'Active'),
(443, 'United Arab Emirates', 'Active'),
(445, 'United Kingdom', 'Active'),
(449, 'United States Minor Outlying Islands', 'Active'),
(451, 'Uruguay   ', 'Active'),
(453, 'Uzbekistan', 'Active'),
(455, 'Vanuatu ', 'Active'),
(457, 'Venezuela ', 'Active'),
(459, 'Viet Nam  ', 'Active'),
(461, 'Virgin Islands (British)  ', 'Active'),
(463, 'Virgin Islands (U.S.)  ', 'Active'),
(465, 'Wallis and Futuna Islands ', 'Active'),
(467, 'Western Sahara ', 'Active'),
(469, 'Yemen', 'Active'),
(471, 'Yugoslavia ', 'Active'),
(473, 'Zambia  ', 'Active'),
(475, 'Zimbabwe  ', 'Active');

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

--
-- Table structure for table `tbl_gallery`
--

CREATE TABLE IF NOT EXISTS `tbl_gallery` (
  `gallery_id` int(11) NOT NULL AUTO_INCREMENT,
  `gallery_title` varchar(255) NOT NULL,
  `gallery_order` int(11) NOT NULL DEFAULT '0',
  `gallery_banner` varchar(255) DEFAULT NULL,
  `on_sponcer` enum('0','1') NOT NULL DEFAULT '0',
  `gallery_status` enum('0','1') NOT NULL DEFAULT '0',
  PRIMARY KEY (`gallery_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;

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

--
-- Table structure for table `tbl_modules`
--

CREATE TABLE IF NOT EXISTS `tbl_modules` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;

--
-- Dumping data for table `tbl_modules`
--

INSERT INTO `tbl_modules` (`id`, `name`) VALUES
(1, 'Administrators'),
(3, 'Packages'),
(5, 'Pages'),
(8, 'Settings'),
(4, 'Advertize Management'),
(10, 'Image Gallery'),
(6, 'News'),
(7, 'Testimonials');

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

--
-- Table structure for table `tbl_module_pages`
--

CREATE TABLE IF NOT EXISTS `tbl_module_pages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `module_id` int(11) NOT NULL,
  `page` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=27 ;

--
-- Dumping data for table `tbl_module_pages`
--

INSERT INTO `tbl_module_pages` (`id`, `module_id`, `page`) VALUES
(1, 1, 'adminlist.php'),
(2, 1, 'addadmin.php'),
(3, 2, 'userrlist.php'),
(4, 2, 'adduser.php'),
(22, 3, 'packagelist.php'),
(21, 3, 'addpackage.php'),
(9, 5, 'addpage.php'),
(10, 5, 'pagelist.php'),
(18, 4, 'addadvertize.php'),
(12, 7, 'newslist.php'),
(13, 7, 'addnews.php'),
(14, 8, 'setting.php'),
(17, 4, 'advertizelist.php'),
(19, 10, 'gallerylist.php'),
(20, 10, 'addgallery.php'),
(23, 6, 'addnews.php'),
(24, 6, 'newslist,php'),
(25, 7, 'addtestimonial.php'),
(26, 7, 'testimoniallist.php');

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

--
-- Table structure for table `tbl_news`
--

CREATE TABLE IF NOT EXISTS `tbl_news` (
  `news_id` int(11) NOT NULL AUTO_INCREMENT,
  `news_title` varchar(255) NOT NULL,
  `news_slug` varchar(255) NOT NULL,
  `news_desc` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `news_date` date NOT NULL,
  `news_meta_title` text,
  `news_meta_keywords` text,
  `news_meta_desc` text,
  `news_status` enum('0','1') NOT NULL DEFAULT '0',
  PRIMARY KEY (`news_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `tbl_news`
--

INSERT INTO `tbl_news` (`news_id`, `news_title`, `news_slug`, `news_desc`, `news_date`, `news_meta_title`, `news_meta_keywords`, `news_meta_desc`, `news_status`) VALUES
(1, 'Tour for Skandadhasthi', 'diwali-tour-for-lord-subrahmanya-swami', '<p>\r\n	<strong>AARU&nbsp; PADAI&nbsp; VEEDU</strong></p>\r\n<p>\r\n	Avail&nbsp; Visit&nbsp; to&nbsp; all&nbsp; the&nbsp; Six&nbsp; Important&nbsp; Pilgrim&nbsp; Centres&nbsp; of&nbsp;&nbsp; the&nbsp; Lord in&nbsp; one&nbsp; Enchanting&nbsp; All&nbsp; Inclusive&nbsp; Package&nbsp; with Confirmed&nbsp; Rail&nbsp; Reservation, Hotel&nbsp; Accommodation, Meals, Transportation&nbsp; by&nbsp; Deluxe&nbsp; Coaches, Sight&nbsp; seeing , Tour&nbsp; Guide&nbsp; services, etc.</p>\r\n<p>\r\n	&nbsp;</p>\r\n<p>\r\n	<strong>Visit&nbsp; organised&nbsp; in&nbsp; November 2012&nbsp; after Diwali</strong> <strong>for Skandadhasthi</strong></p>\r\n<p>\r\n	&nbsp;</p>\r\n<p>\r\n	<span style=\\"\\\\&quot;\\\\\\\\&quot;\\\\\\\\\\\\\\\\&quot;color:#008000;\\\\\\\\\\\\\\\\&quot;\\\\\\\\&quot;\\\\&quot;\\"><span><strong>For details &amp; Booking</strong></span></span></p>\r\n<p>\r\n	<strong>Contact : </strong>9985021121/9978990243<br />\r\n	<strong>E-mail : </strong><a href=\\"mailto:info@gopiligrim.com\\">info@gopiligrim.com</a></p>\r\n<p>\r\n	&nbsp;</p>\r\n<p>\r\n	<strong>Trip Details:</strong></p>\r\n<ol>\r\n	<li>\r\n		<strong>Start from Coimbatore</strong>\r\n		<ol style=\\"\\\\&quot;\\\\\\\\&quot;\\\\\\\\\\\\\\\\&quot;\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\&quot;\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\&quot;list-style-type:lower-alpha;\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\&quot;\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\&quot;\\\\\\\\\\\\\\\\&quot;\\\\\\\\&quot;\\\\&quot;\\">\r\n			<li>\r\n				Palani Murugan Temple (100 km south east of Coimbatore)</li>\r\n			<li>\r\n				Thiruparamkunram (10 km south of Madurai).</li>\r\n			<li>\r\n				Pazhamudircholai (10 km north of Madurai)</li>\r\n			<li>\r\n				Thiruchendur (40 km south of Thoothukudi or Tuticorin)</li>\r\n			<li>\r\n				Swamimalai (Near Kumbakonam)</li>\r\n			<li>\r\n				Thiruthani (84 km from Chennai) OR,<br />\r\n				&nbsp;</li>\r\n		</ol>\r\n	</li>\r\n	<li>\r\n		<strong>Start from Madurai</strong>\r\n		<ol style=\\"\\\\&quot;\\\\\\\\&quot;\\\\\\\\\\\\\\\\&quot;\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\&quot;\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\&quot;list-style-type:lower-alpha;\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\&quot;\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\&quot;\\\\\\\\\\\\\\\\&quot;\\\\\\\\&quot;\\\\&quot;\\">\r\n			<li>\r\n				Thiruparamkunram (10 km south of Madurai)</li>\r\n			<li>\r\n				Pazhamudircholai (10 km north of Madurai)</li>\r\n			<li>\r\n				Thiruchendur (40 km south of Thoothukudi or Tuticorin)</li>\r\n			<li>\r\n				Palani Murugan Temple (100 km south east of Coimbatore)</li>\r\n			<li>\r\n				Swamimalai (Near Kumbakonam)</li>\r\n			<li>\r\n				Thiruthani (84 km from Chennai)</li>\r\n		</ol>\r\n	</li>\r\n</ol>\r\n<p>\r\n	<br />\r\n	&nbsp;</p>\r\n', '2012-11-20', 'Good News for All Devotees of Lord Subrahmanya Swami', 'Good News for All Devotees of Lord Subrahmanya Swami', 'Good News for All Devotees of Lord Subrahmanya Swami', '1');

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

--
-- Table structure for table `tbl_packages`
--

CREATE TABLE IF NOT EXISTS `tbl_packages` (
  `package_id` int(11) NOT NULL AUTO_INCREMENT,
  `package_title` varchar(255) NOT NULL,
  `package_slug` varchar(255) NOT NULL,
  `package_short_desc` varchar(255) NOT NULL,
  `package_desc` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `package_image` varchar(255) NOT NULL,
  `package_meta_title` text,
  `package_meta_keywords` text,
  `package_meta_desc` text,
  `package_status` enum('0','1') NOT NULL DEFAULT '0',
  PRIMARY KEY (`package_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `tbl_packages`
--

INSERT INTO `tbl_packages` (`package_id`, `package_title`, `package_slug`, `package_short_desc`, `package_desc`, `package_image`, `package_meta_title`, `package_meta_keywords`, `package_meta_desc`, `package_status`) VALUES
(3, 'AARU  PADAI  VEEDU', 'aaru-padai-veedu', 'Good News for All Devotees  of  Lord  Subrahmanya Swami. In November 2012 after Diwali', '<p>\r\n	<strong>AARU&nbsp; PADAI&nbsp; VEEDU</strong></p>\r\n<p>\r\n	Avail&nbsp; Visit&nbsp; to&nbsp; all&nbsp; the&nbsp; Six&nbsp; Important&nbsp; Pilgrim&nbsp; Centres&nbsp; of&nbsp;&nbsp; the&nbsp; Lord in&nbsp; one&nbsp; Enchanting&nbsp; All&nbsp; Inclusive&nbsp; Package&nbsp; with Confirmed&nbsp; Rail&nbsp; Reservation, Hotel&nbsp; Accommodation, Meals, Transportation&nbsp; by&nbsp; Deluxe&nbsp; Coaches, Sight&nbsp; seeing , Tour&nbsp; Guide&nbsp; services, etc.</p>\r\n<p>\r\n	&nbsp;</p>\r\n<p>\r\n	<strong>Visit&nbsp; organised&nbsp; in&nbsp; November 2012&nbsp; after Diwali</strong> <strong>for Skandadhasthi</strong></p>\r\n<p>\r\n	&nbsp;</p>\r\n<p>\r\n	<span style=\\"\\\\&quot;\\\\\\\\&quot;color:#008000;\\\\\\\\&quot;\\\\&quot;\\"><span><strong>For details &amp; Booking</strong></span></span></p>\r\n<p>\r\n	<strong>Contact : </strong>9985021121/9978990243<br />\r\n	<strong>E-mail : </strong><a href=\\"mailto:info@gopiligrim.com\\">info@gopiligrim.com</a></p>\r\n<p>\r\n	&nbsp;</p>\r\n<p>\r\n	<strong>Trip Details:</strong></p>\r\n<ol>\r\n	<li>\r\n		<strong>Start from Coimbatore</strong>\r\n		<ol style=\\"\\\\&quot;\\\\\\\\&quot;\\\\\\\\\\\\\\\\&quot;\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\&quot;list-style-type:lower-alpha;\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\&quot;\\\\\\\\\\\\\\\\&quot;\\\\\\\\&quot;\\\\&quot;\\">\r\n			<li>\r\n				Palani Murugan Temple (100 km south east of Coimbatore)</li>\r\n			<li>\r\n				Thiruparamkunram (10 km south of Madurai).</li>\r\n			<li>\r\n				Pazhamudircholai (10 km north of Madurai)</li>\r\n			<li>\r\n				Thiruchendur (40 km south of Thoothukudi or Tuticorin)</li>\r\n			<li>\r\n				Swamimalai (Near Kumbakonam)</li>\r\n			<li>\r\n				Thiruthani (84 km from Chennai) OR,<br />\r\n				&nbsp;</li>\r\n		</ol>\r\n	</li>\r\n	<li>\r\n		<strong>Start from Madurai</strong>\r\n		<ol style=\\"\\\\&quot;\\\\\\\\&quot;\\\\\\\\\\\\\\\\&quot;\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\&quot;list-style-type:lower-alpha;\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\&quot;\\\\\\\\\\\\\\\\&quot;\\\\\\\\&quot;\\\\&quot;\\">\r\n			<li>\r\n				Thiruparamkunram (10 km south of Madurai)</li>\r\n			<li>\r\n				Pazhamudircholai (10 km north of Madurai)</li>\r\n			<li>\r\n				Thiruchendur (40 km south of Thoothukudi or Tuticorin)</li>\r\n			<li>\r\n				Palani Murugan Temple (100 km south east of Coimbatore)</li>\r\n			<li>\r\n				Swamimalai (Near Kumbakonam)</li>\r\n			<li>\r\n				Thiruthani (84 km from Chennai)</li>\r\n		</ol>\r\n	</li>\r\n</ol>\r\n<p>\r\n	<br />\r\n	&nbsp;</p>\r\n', '1348578338_six-mur.jpg', 'AARU PADAI VEEDU Tour in  November 2012  after Diwali for Skandadhasthi', 'AARU PADAI VEEDU Tour in  November 2012  after Diwali for Skandadhasthi', 'AARU PADAI VEEDU Tour in  November 2012  after Diwali for Skandadhasthi', '1');

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

--
-- Table structure for table `tbl_pages`
--

CREATE TABLE IF NOT EXISTS `tbl_pages` (
  `page_id` int(11) NOT NULL AUTO_INCREMENT,
  `page_title` varchar(255) NOT NULL,
  `page_slug` varchar(255) NOT NULL,
  `page_desc` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `on_home` enum('0','1') NOT NULL DEFAULT '0',
  `on_header` enum('0','1') NOT NULL DEFAULT '1',
  `on_footer` enum('0','1') NOT NULL DEFAULT '1',
  `page_meta_title` text,
  `page_meta_keywords` text,
  `page_meta_desc` text,
  `page_order` int(11) NOT NULL DEFAULT '0',
  `page_banner` varchar(255) DEFAULT NULL,
  `page_status` enum('0','1') NOT NULL DEFAULT '0',
  PRIMARY KEY (`page_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=27 ;

--
-- Dumping data for table `tbl_pages`
--

INSERT INTO `tbl_pages` (`page_id`, `page_title`, `page_slug`, `page_desc`, `on_home`, `on_header`, `on_footer`, `page_meta_title`, `page_meta_keywords`, `page_meta_desc`, `page_order`, `page_banner`, `page_status`) VALUES
(1, 'Home', 'home', '', '0', '1', '1', 'Welcome to Venture Wing', 'Venture Wing', 'Venture Wing', 1, '', '1'),
(2, 'About Us', 'about-us', '<p>\r\n	<q>Seeded with the idea to empower and bring visibility into the various destinations of sanctity and pilgrim hubs &ndash; <strong>GOPILIGRIM</strong> came into existence in 2012. GoPiligrim.com will be the world&rsquo;s &nbsp;first online portal to offer piligrim tours and travel services to the various religious and pious places around the globe.</q></p>\r\n<p>\r\n	&nbsp;</p>\r\n<p>\r\n	<q>GoPiligrim was founded in the year 2012 by Navin Gnaneshwar and Poonam Navin. Created to consolidate all the places of piligrim in one place and spreading the visibility of these spots to empower the Indian believer of god to learn and travel to their choicest piligrim destinations and appease their spiritual desires!</q></p>\r\n<p>\r\n	&nbsp;</p>\r\n<p>\r\n	<q><strong>Our Mission:</strong></q></p>\r\n<ol>\r\n	<li>\r\n		<q>One stop shop for piligrim travellers to check out the various destinations available to be explored</q></li>\r\n	<li>\r\n		<q>Higher visibility to the various places of sanctum!</q></li>\r\n	<li>\r\n		<q>Online reservations and bookings</q></li>\r\n</ol>\r\n', '1', '1', '1', 'About Us', 'About Us', 'About Us', 2, '', '1'),
(6, 'Contact Us', 'contact-us', '<p>\r\n	<strong>Head Office</strong></p>\r\n<p>\r\n	Navam Enterprises<strong> </strong></p>\r\n<p>\r\n	405, Abode Admire, Defence Colony</p>\r\n<p>\r\n	Sainikpuri, AP &ndash; 500 094</p>\r\n<p>\r\n	&nbsp;</p>\r\n<p>\r\n	<strong>Branch office:</strong></p>\r\n<p>\r\n	D303, Shompole</p>\r\n<p>\r\n	Thaltej, Ahmedabad &ndash; 380 059</p>\r\n<p>\r\n	Email: info@gopiligrim.com</p>\r\n', '0', '1', '1', 'Contact Us', 'Contact Us', 'Contact Us', 18, '', '1'),
(20, 'Why Us', 'why-us', '<p>\r\n	Go Piligrim is the tours &amp; travel site that gives you what you need without any annoying fluff.&nbsp;</p>\r\n<p>\r\n	We made a list of some of the things we want to be:</p>\r\n<ul>\r\n	<li>\r\n		<strong>Simple:</strong> Simplicity is a religion at Go Piligrim. Together we can make a difference<br />\r\n		&nbsp;</li>\r\n	<li>\r\n		<strong>Comprehensive:</strong> Part of making travel simple is presenting you with all the options for your trip. We&rsquo;re working closely with suppliers to add more airlines and hotels to our search.<br />\r\n		&nbsp;</li>\r\n	<li>\r\n		<strong>Reliable:</strong> Making travel simple implies making a travel site that just works and works. Reliably, is very important to us.<br />\r\n		&nbsp;</li>\r\n	<li>\r\n		<strong>Responsible:</strong> We take responsibility for what we give you. You won&rsquo;t hear us making excuses for your tours.<br />\r\n		&nbsp;</li>\r\n	<li>\r\n		<strong>Makes it Easy: </strong>What is it about traveling with us that keeps people coming back?<br />\r\n		<ol style="margin-left:20px;">\r\n			<li>\r\n				<strong>Help with luggage:</strong><br />\r\n				Our drivers assist customers in loading their luggage.<br />\r\n				&nbsp;</li>\r\n			<li>\r\n				<strong>A to Z guaranteed:</strong><br />\r\n				No matter what it takes, we guarantee we&#39;ll get you from the start to the end point of your journey.<br />\r\n				&nbsp;</li>\r\n			<li>\r\n				<strong>Friendly and pro-active drivers and staff:</strong><br />\r\n				We have dedicated customer experience and driver development teams to ensure excellent customer service.</li>\r\n		</ol>\r\n	</li>\r\n</ul>\r\n', '1', '0', '0', 'Why Us', 'Why Us', 'Why Us', 12, '', '1'),
(21, 'Contact', 'contact', '<p>\r\n	<strong>Phone: 079 40037 12 15<br />\r\n	Email: info@gopilgrim.com</strong></p>\r\n', '1', '0', '0', 'Contact', 'Contact', 'Contact', 13, '', '1'),
(22, 'Services', 'services', '<p>\r\n	Coming Soon</p>\r\n', '0', '1', '1', 'Services', 'Services', 'Services', 14, '', '1'),
(23, 'Packages', 'packages', '', '0', '1', '1', 'Packages', 'Packages', 'Packages', 15, '', '1'),
(24, 'Tour Gallery', 'tour-gallery', '', '0', '1', '1', 'Tour Gallery', 'Tour Gallery', 'Tour Gallery', 16, '', '1'),
(25, 'Inquiry', 'inquiry', '<p>\r\n	<strong>For Enquiries Contact us at:</strong></p>\r\n<p>\r\n	info@gopiligrim.com or call +91 997 899 0243</p>\r\n', '0', '1', '1', 'Inquiry', 'Inquiry', 'Inquiry', 17, '', '1'),
(26, 'Privacy Policy', 'privacy-policy', '<p>\r\n	Thank you for visiting the website of Go Piligrim (Website).<br />\r\n	<br />\r\n	The Privacy Policy is applicable to the websites of Go Piligrim. This privacy statement also does not apply to the websites of our business partners, corporate affiliates or to any other third parties, even if their websites are linked to Go Piligrim Website. We recommend you review the privacy statements of the other parties with whom you interact.<br />\r\n	<br />\r\n	For the purposes of this privacy policy, &quot;corporate affiliates&quot; means any entity or joint venture that is wholly or partially owned or controlled by Go Piligrim.<br />\r\n	<br />\r\n	The following terms governs the collection, use and protection of your Personal Information by the Website. This Privacy Policy shall be applicable to users or customers who purchases any product or services from the Website or visits the Website. By visiting and/ or using the Website you have agreed to the following Privacy Policy.<br />\r\n	<br />\r\n	<strong>Introduction:</strong><br />\r\n	<br />\r\n	As a registered member of the Website and/or as a visitor (if applicable and as the case may be), you will be entitled to savings and benefits on airfares, hotel reservations, holiday packages and car rentals, among other travel services. In addition, look forward to receiving monthly newsletters and exclusive promotions offering special deals.<br />\r\n	<br />\r\n	That&#39;s why we&#39;ve provided this Privacy Policy, which sets forth our policies regarding the collection, use and protection of the Personal Information of those using or visiting the Website.</p>\r\n<p>\r\n	&nbsp;</p>\r\n<p class="inner_sub_heading append_bottomHalf">\r\n	<strong>Personal Information</strong></p>\r\n<p>\r\n	<br />\r\n	Personal Informationter updates, we will abide by the privacy practices described to you in this Privacy Policy at the time you provided us with your Personal Information.</p>\r\n<p>\r\n	&nbsp;</p>\r\n<p>\r\n	linked to a specific individual or to identify any individual, such as name, address, mailing address, telephone number, e - mail address, credit card number, cardholder name, expiration date, information about the travel, bookings, co-passengers, and any and all details that may be requested while any customers visits or uses the website</p>\r\n<p>\r\n	&nbsp;</p>\r\n<p>\r\n	Personal Information means and includes all information that can be linked to a specific individual or to identify any individual, such as name, address, mailing address, telephone number, e - mail address, credit card number, cardholder name, expiration date, information about the travel, bookings, co-passengers, and any and all details that may be requested while any customers visits or uses the website</p>\r\n<p>\r\n	&nbsp;</p>\r\n<p>\r\n	When you browse the Website, Go Piligrim may collect information regarding the domain and host from which you access the Internet, the Internet Protocol address of the computer or Internet Service Provider you are using, and anonymous site statistical data. The Website uses cookie and tracking technology depending on the features offered. Personal Information will not be collected via cookies and other tracking technology; however, if you previously provided personally identifiable information, cookies may be tied to such information. Aggregate cookie and tracking information may be shared with third parties.</p>\r\n<p>\r\n	<br />\r\n	We encourage you to review our Privacy Policy, and become familiar with it, but you should know that we do not sell or rent our customers&#39; Personal Information to third parties.</p>\r\n<p>\r\n	<br />\r\n	Please note that we review our Privacy Policy from time to time, and we may make periodic changes to the policy in connection with that review. Therefore, you may wish to bookmark this page and/or periodically review this page to make sure you have the latest version. Regardless of later updates, we will abide by the privacy practices described to you in this Privacy Policy at the time you provided us with your Personal Information.</p>\r\n', '0', '0', '1', 'Privacy Policy', 'Privacy Policy', 'Privacy Policy', 19, '', '1');

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

--
-- Table structure for table `tbl_setting`
--

CREATE TABLE IF NOT EXISTS `tbl_setting` (
  `setting_id` int(11) NOT NULL AUTO_INCREMENT,
  `setting_label` varchar(255) NOT NULL,
  `setting_name` varchar(255) NOT NULL,
  `setting_value` text NOT NULL,
  `setting_type` varchar(255) NOT NULL,
  PRIMARY KEY (`setting_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

--
-- Dumping data for table `tbl_setting`
--

INSERT INTO `tbl_setting` (`setting_id`, `setting_label`, `setting_name`, `setting_value`, `setting_type`) VALUES
(1, 'Meta Title', 'DEFAULT_META_TITLE', 'Welcome to Venture Wing', 'textarea'),
(2, 'Meta Keyword', 'DEFAULT_META_KEYWORD', 'Venture Wing', 'textarea'),
(3, 'Meta Description', 'DEFAULT_META_DESCRIPTION', 'Venture Wing', 'textarea'),
(7, 'Admin email address', 'ADMIN_EMAIL', 'info@gopiligrim.com', 'input');

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

--
-- Table structure for table `tbl_testimonial`
--

CREATE TABLE IF NOT EXISTS `tbl_testimonial` (
  `testimonial_id` int(11) NOT NULL AUTO_INCREMENT,
  `testimonial_title` varchar(255) NOT NULL,
  `testimonial_company` varchar(255) NOT NULL,
  `testimonial_slug` varchar(255) NOT NULL,
  `testimonial_desc` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `testimonial_meta_title` text,
  `testimonial_meta_keywords` text,
  `testimonial_meta_desc` text,
  `testimonial_status` enum('0','1') NOT NULL DEFAULT '0',
  PRIMARY KEY (`testimonial_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `tbl_testimonial`
--

INSERT INTO `tbl_testimonial` (`testimonial_id`, `testimonial_title`, `testimonial_company`, `testimonial_slug`, `testimonial_desc`, `testimonial_meta_title`, `testimonial_meta_keywords`, `testimonial_meta_desc`, `testimonial_status`) VALUES
(2, 'Paras Mathukiya', 'Om Net Solution', 'new-test', 'Really good experience with Venture Wing tours', 'Really good experience with Venture Wing tours', 'Really good experience with Venture Wing tours', 'Really good experience with Venture Wing tours', '1');

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

--
-- Table structure for table `tbl_user`
--

CREATE TABLE IF NOT EXISTS `tbl_user` (
  `user_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_uniq_id` varchar(255) NOT NULL,
  `payment_status` enum('Free','Paid') NOT NULL DEFAULT 'Free',
  `user_name` varchar(255) DEFAULT NULL,
  `about_me` text NOT NULL,
  `email_address` varchar(100) NOT NULL,
  `user_native_place` varchar(255) NOT NULL,
  `user_profile_created_by` enum('Self','Parent','Family','Friend') NOT NULL DEFAULT 'Self',
  `user_username` varchar(100) NOT NULL,
  `user_cast` varchar(100) NOT NULL,
  `user_sub_cast` varchar(100) NOT NULL,
  `user_gotra` varchar(25) NOT NULL,
  `outercast_interest` enum('Yes','No') NOT NULL DEFAULT 'No',
  `interested_cast` varchar(100) NOT NULL,
  `user_profile_image` varchar(255) NOT NULL,
  `father_name` varchar(255) NOT NULL,
  `father_occupation` varchar(255) NOT NULL,
  `user_password` varchar(100) NOT NULL,
  `mother_name` varchar(255) NOT NULL,
  `mother_occupation` varchar(255) NOT NULL,
  `screen_name` varchar(255) NOT NULL,
  `marriage_time` enum('Soon','Within 12 Months','No Fixed Time') NOT NULL DEFAULT 'Soon',
  `gender` enum('Male','Female') NOT NULL DEFAULT 'Male',
  `date_of_birth` date NOT NULL,
  `age_in_year` int(11) NOT NULL,
  `marital_status` enum('Single','Divorced','Widowed','Separated') NOT NULL,
  `have_children` enum('Yes','No') NOT NULL DEFAULT 'No',
  `chiledren_live_with` varchar(100) NOT NULL,
  `num_of_son` varchar(50) NOT NULL,
  `num_of_doughter` varchar(50) NOT NULL,
  `religion` varchar(100) NOT NULL,
  `community` varchar(255) NOT NULL,
  `mother_toungue` varchar(100) NOT NULL,
  `lifestyle` enum('Liberal','Modern','Traditional') NOT NULL DEFAULT 'Liberal',
  `last_degree` varchar(255) NOT NULL,
  `degree_detail` varchar(255) NOT NULL,
  `proffession` varchar(255) NOT NULL,
  `annual_incom` varchar(255) NOT NULL,
  `family_status` enum('Rich / Affluent','Upper Middle Class','Middle Class') NOT NULL DEFAULT 'Rich / Affluent',
  `country` varchar(255) NOT NULL,
  `state` varchar(255) NOT NULL,
  `city` varchar(255) NOT NULL,
  `post_code` varchar(15) NOT NULL,
  `address` varchar(255) NOT NULL,
  `nationality` varchar(255) NOT NULL,
  `mobile_no` varchar(15) NOT NULL,
  `phone_no` varchar(20) NOT NULL,
  `suitable_time` varchar(20) NOT NULL,
  `person_contact` varchar(255) NOT NULL,
  `height` varchar(20) NOT NULL,
  `weight` varchar(20) NOT NULL,
  `spects` enum('Yes','No') NOT NULL DEFAULT 'No',
  `star` varchar(100) NOT NULL,
  `mangal` varchar(100) NOT NULL,
  `horpscope_belive` enum('Yes','No') NOT NULL DEFAULT 'No',
  `blood_group` varchar(25) NOT NULL,
  `complexion` varchar(15) NOT NULL,
  `eye_color` varchar(25) NOT NULL,
  `hair_color` varchar(25) NOT NULL,
  `eating_habit` varchar(25) NOT NULL,
  `drinking_habit` varchar(50) NOT NULL,
  `smoking_habit` varchar(50) NOT NULL,
  `special_case` varchar(255) NOT NULL,
  `father_alive` enum('Yes','No') NOT NULL DEFAULT 'Yes',
  `mother_alive` enum('Yes','No') NOT NULL DEFAULT 'No',
  `total_brothers` varchar(50) NOT NULL,
  `total_sisters` varchar(50) NOT NULL,
  `married_brother` varchar(50) NOT NULL,
  `married_sister` varchar(50) NOT NULL,
  `on_home_page` enum('0','1') NOT NULL DEFAULT '0',
  `user_ip_address` varchar(255) NOT NULL,
  `user_created_date` datetime NOT NULL,
  `user_last_login_date` datetime DEFAULT NULL,
  `user_status` enum('0','1') NOT NULL DEFAULT '0',
  PRIMARY KEY (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
