-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `ssc`
--

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

--
-- Table structure for table `about`
--

CREATE TABLE `about` (
  `id` int(11) NOT NULL,
  `about` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `about`
--

INSERT INTO `about` (`id`, `about`) VALUES
(7, '<h4>MY STORY</h4>\r\n\r\n<p>Nnorthographic lifekkk One day however small line of blind text by the name of eorem Ipsum decided to leave for the far World ofGrammar.</p>\r\n\r\n<p>Coast of Semantics, large language ocean. A small river named Duden flows place and ');

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

--
-- Table structure for table `aboutimg`
--

CREATE TABLE `aboutimg` (
  `id` int(11) NOT NULL,
  `aid` varchar(255) NOT NULL,
  `images` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `aboutimg`
--

INSERT INTO `aboutimg` (`id`, `aid`, `images`) VALUES
(4, '7', 'my-story-1.jpg'),
(5, '7', 'my-story-2.jpg'),
(6, '7', 'my-story-3.jpg');

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

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

CREATE TABLE `banner` (
  `tes_id` int(11) NOT NULL,
  `author` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `image` varchar(255) NOT NULL,
  `category` varchar(255) NOT NULL,
  `datetime` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `banner` (`tes_id`, `author`, `description`, `image`, `category`, `datetime`) VALUES
(35, 'Photographers 1', '<p><span style=\"color:rgb(34, 34, 34); font-family:consolas,lucida console,courier new,monospace; font-size:12px\">Lorem ipsum dolor sit amet, consectetur adipisicing elit,sed eiusmod tempor incididunt ut labore et dolore magna aliqua. </span></p>', 'Photographers1_slide-3.jpg', 'Category 1', '2018-09-22 10:36:24'),
(36, 'Photographers 2', '<p><span style=\"color:rgb(34, 34, 34); font-family:consolas,lucida console,courier new,monospace; font-size:12px\">Lorem ipsum dolor sit amet, consectetur adipisicing elit,sed eiusmod tempor incididunt ut labore et dolore magna aliqua. </span></p>', 'Photographers1_slide-1.jpg', 'Category 1', '2018-09-22 10:41:02'),
(37, 'Photographers 2', '<p><span style=\"color:rgb(34, 34, 34); font-family:consolas,lucida console,courier new,monospace; font-size:12px\">Lorem ipsum dolor sit amet, consectetur adipisicing elit,sed eiusmod tempor incididunt ut labore et dolore magna aliqua. </span></p>', 'Photographers1_slide-2.jpg', 'Category 1', '2018-09-22 10:41:16');

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

--
-- Table structure for table `category`
--

CREATE TABLE `category` (
  `categoryId` int(11) NOT NULL,
  `category` varchar(255) NOT NULL,
  `type` enum('Gallery','Videos') NOT NULL,
  `updationDate` datetime NOT NULL,
  `creationDate` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `category`
--

INSERT INTO `category` (`categoryId`, `category`, `type`, `updationDate`, `creationDate`) VALUES
(7, 'Fashion', 'Gallery', '2015-12-10 12:18:06', '2015-12-04 10:26:54'),
(18, 'Product', 'Gallery', '2015-12-10 12:20:11', '2015-12-10 12:20:11'),
(19, 'Wedding', 'Gallery', '2015-12-10 12:20:23', '2015-12-10 12:20:23'),
(20, 'Jewellery', 'Gallery', '2015-12-10 12:20:49', '2015-12-10 12:20:49'),
(21, 'Street', 'Gallery', '2015-12-10 12:21:01', '2015-12-10 12:21:01'),
(23, 'Event', 'Gallery', '2015-12-27 16:09:50', '2015-12-27 16:09:50'),
(24, 'Kids Shoots', 'Gallery', '2016-03-06 17:12:59', '2016-03-06 17:12:59'),
(25, 'Producats', 'Videos', '2016-08-09 14:08:48', '2016-08-09 14:08:48');

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

--
-- Table structure for table `clients`
--

CREATE TABLE `clients` (
  `cli_id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `datetime` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `clients`
--

INSERT INTO `clients` (`cli_id`, `title`, `image`, `datetime`) VALUES
(11, 'colour palace', 'colour palace1_68105_346315348845562_153200696_n.png', '2016-01-01 09:56:38');

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

--
-- Table structure for table `cms`
--

CREATE TABLE `cms` (
  `category` varchar(255) NOT NULL,
  `content` text NOT NULL,
  `datetime` datetime NOT NULL,
  `files` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `cms`
--

INSERT INTO `cms` (`category`, `content`, `datetime`, `files`) VALUES
('about', '<p style=\"text-align:justify\">MY STORY</p>\r\n\r\n<p>Nnorthographic life One day however small line of blind text by the name of eorem Ipsum decided to leave for the far World ofGrammar.Coast of Semantics, large language ocean. A small river named Duden flows place and supplies it with the necessary regelialia. It is a paradisematic unor thographic life One day however small line of blind</p>', '2018-09-25 09:45:50', 'Tv0YcmGQzT91fjrQMJAONg==1.png'),
('corevalue', '<p><span style=\"color:rgb(98, 97, 97); font-family:dosis,sans-serif; font-size:16px\">Lorem Ipsum is simply dummy text of the printing and typesetting indust orem Ipsum has been the industry&#39;s standard dummy text ever since 1500s when. It has survived not only.</span></p>', '2018-09-25 07:13:13', 'UVG3B7GR8iIMcIembT+KJhWOa6kaXRqgiV49XCtxzOU=1.jpg'),
('facility', '<p style=\"text-align:justify\"><strong>Characteristics of chakras</strong>:</p>\r\n\r\n<p style=\"text-align:justify\">&nbsp;</p>\r\n\r\n<p style=\"text-align:justify\">They are related to the five elements from which the entire universe is formed, namely Earth, Water, Fire , Air and Space. By virtue of their relationship with these elements, they bear typical characteristics of these elements.</p>\r\n\r\n<p style=\"text-align:justify\">Each has a number of petals which have a specific significance.</p>\r\n\r\n<p style=\"text-align:justify\"><br />\r\n&nbsp;</p>\r\n\r\n<p style=\"text-align:justify\">Each chakra controls the functioning of an endocrine gland (which produce hormones) and specific parts of our body.</p>\r\n\r\n<p style=\"text-align:justify\">Each chakra has a specific colour (the colours of the Rainbow&nbsp;<strong>VIBGYOR</strong>) and stores emotional memories, which is why we &ldquo;feel&rdquo; certain past memories in different parts of the body.</p>\r\n\r\n<p style=\"text-align:justify\">Each chakra can be activated by a mantra specific for it. The mantra brings it into balance as a result of its vibration.</p>\r\n\r\n<p style=\"text-align:justify\">Chakras also have a relationship with the&nbsp;<strong>Gunas of Prakriti</strong>, namely&nbsp;<strong>Sattva, Rajas and Tamas</strong>. The Vishudhi and Agya Chakras are related to a Sattvic pravriti, concerned with purity and virtue, and the consciousness is centered at the Third Eye Centre. The Anahat Chakra is responsible for Rajas, which is characterized by passion, and wordly activities etc. The lower chakras, namely Manipur, Svadisthan and Muladhar are related to Tamas, characterized by inertia, arrogance and pride. &nbsp;</p>\r\n\r\n<p style=\"text-align:justify\"><strong>Muladhar Chakra:</strong>&nbsp;&ldquo;Mula&rdquo; means root and &ldquo;dhara&rdquo; means vital part. Hence it is the foundation of all the other chakras. &nbsp;&nbsp;</p>\r\n\r\n<p style=\"text-align:justify\">It is&nbsp; known as the first chakra, Root or the coccygeal chakra since it lies at the base of the spine. It is also called the Saturn Chakra.</p>\r\n\r\n<p style=\"text-align:justify\">It is related to the&nbsp;<strong>Earth element</strong>, hence responsible for our&nbsp;<strong>foundation&nbsp;</strong>(just like Mother Earth is responsible for the foundation of the entire planet), grounding, stability, balance, and structure as it is responsible for our skeleton, blood production, hair skin, etc.&nbsp;&nbsp;</p>\r\n\r\n<p style=\"text-align:justify\">It is related to our sense of&nbsp;<strong>smell&nbsp;</strong>and to<strong>&nbsp;Apana Prana,&nbsp;</strong>therefore, responsible for elimination of wastes from our body.</p>\r\n\r\n<p style=\"text-align:justify\">Predominance of this chakra makes us hard working, determined, and also lead to attachment with our surroundings, people etc.</p>\r\n\r\n<p style=\"text-align:justify\">This chakra has&nbsp;<strong>four petals</strong>&nbsp;which denote the four psychic functions, namely Mind (Manas), Intellect (Budhi), Consciousness (Chitta), and Ego (Ahankar) which originate here.</p>\r\n\r\n<p style=\"text-align:justify\">It is related to the colour&nbsp;<strong>Red&nbsp;</strong>which signifies<strong>&nbsp;Shakti,&nbsp;</strong>symbolizing awakening of sleeping consciousness to alert consciousness.</p>\r\n\r\n<p style=\"text-align:justify\">The Mantra for this chakra is&nbsp;<strong>&ldquo;LAM&rdquo;&hellip;..Laaaaammm</strong></p>\r\n\r\n<p style=\"text-align:justify\">i Kriyananda, Deepak Chopra/ David Simon lecture series and the Internet.&nbsp;</p>', '2018-04-06 15:18:38', 'B3XAFW1aSWIDxaey0SFtbA==5.jpg'),
('features', '<ul>\r\n	<li>FIT &reg; Gym &amp; Fitness</li>\r\n	<li>Wired Business Center</li>\r\n	<li>All Inclusive &reg; Service</li>\r\n	<li>Bliss &amp; Spa</li>\r\n	<li>SPG Keyless</li>\r\n	<li>Resturant &amp; lounge bar</li>\r\n	<li>Private rooms</li>\r\n</ul>', '2018-04-05 14:16:51', 'm(19319)bz97ngYfrll6PON1cz1g==1.jpg'),
('information', '<ul>\r\n	<li>Check-in Time: 3 PM</li>\r\n	<li>Check-out Time: 12 PM</li>\r\n	<li>Complimentary WiFi for All Members</li>\r\n	<li>Valet Parking $65-$75/day</li>\r\n	<li>Pets Welcome (fee)</li>\r\n	<li>Early Check-In Available</li>\r\n	<li>Best Prices Guaranteed</li>\r\n	<li>Free parking for All Inclusive package</li>\r\n</ul>', '2018-04-05 14:16:32', 'NYvv2Bceo04IvYGlrJMRPQ==1.jpg'),
('mission', '<ul>\r\n	<li>Address:12 civil line Dewas</li>\r\n	<li>Contact no:(0727272) 0000</li>\r\n	<li>Email:info@itgeeksin.com</li>\r\n	<li>Website:www.itgeeksin.com</li>\r\n</ul>', '2018-09-25 08:58:19', ''),
('process', '<p>We make every customer and employee part of our family, by taking utmost care to meet the needs and expectation, whether it is in terms of bringing the finest quality product or making the work culture conducive.</p>', '2018-06-11 11:22:20', ''),
('vision', '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed eget lorem magna Fusce eu urna a sapien fringilla viverra.&nbsp; Morbi ut est ac diam sagittis auctor. Suspendisse ut&nbsp; eros et est elementum sollicitudin. lacus vel viverra molestie sapien fringilla viverra.&nbsp; Morbi ut est ac diam sagittis auctor. Suspendisse ut&nbsp; eros et est elementum&nbsp;</p>', '2018-09-24 09:52:37', 'i5rwMtCKbkzCsQ7xYc7b6A==1.jpg');

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

--
-- Table structure for table `gallery`
--

CREATE TABLE `gallery` (
  `gal_id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `category` int(11) NOT NULL,
  `image` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `datetime` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `gallery`
--

INSERT INTO `gallery` (`gal_id`, `title`, `category`, `image`, `type`, `datetime`) VALUES
(169, 'MODEL', 23, '231_3.jpg', 'landscape', '2018-09-23 12:06:52'),
(170, 'MODEL', 23, '231_4.jpg', 'landscape', '2018-09-23 12:07:03'),
(171, 'MODEL', 23, '231_5.jpg', 'landscape', '2018-09-23 12:09:58'),
(172, 'MODEL', 7, '71_work-3.jpg', 'landscape', '2018-09-23 12:10:12'),
(174, 'MODEL', 19, '191_work-9.jpg', 'potrait', '2018-09-23 12:14:24'),
(175, 'MODEL', 20, '201_3.jpg', 'landscape', '2018-09-23 13:39:56'),
(176, 'MODEL', 7, '71_1.jpg', 'landscape', '2018-09-23 13:40:10'),
(177, 'MODEL', 7, '72_work-3.jpg', 'landscape', '2018-09-23 13:40:24'),
(178, 'MODEL', 7, '71_work-2.jpg', 'landscape', '2018-09-23 13:40:39'),
(179, 'MODEL', 20, '201_work-5.jpg', 'potrait', '2018-09-23 13:40:55'),
(180, 'MODEL', 7, '71_work-10.jpg', 'potrait', '2018-09-23 13:41:11'),
(181, 'MODEL', 7, '71_foot-1.jpg', 'squre', '2018-09-24 12:35:41'),
(182, 'MODEL', 7, '71_foot-2.jpg', 'squre', '2018-09-24 12:35:59'),
(183, 'MODEL', 7, '71_foot-3.jpg', 'squre', '2018-09-24 12:36:16'),
(184, 'MODEL', 20, '201_foot-4.jpg', 'squre', '2018-09-24 12:36:33'),
(185, 'MODEL', 23, '231_foot-5.jpg', 'squre', '2018-09-24 12:37:06'),
(186, 'MODEL', 18, '181_foot-6.jpg', 'squre', '2018-09-24 12:37:39'),
(187, 'MODEL', 20, '201_foot-7.jpg', 'squre', '2018-09-24 12:37:51'),
(188, 'MODEL', 7, '71_foot-8.jpg', 'squre', '2018-09-24 12:38:06'),
(189, 'MODEL', 7, '71_foot-9.jpg', 'squre', '2018-09-24 12:38:18');

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

--
-- Table structure for table `newsevents`
--

CREATE TABLE `newsevents` (
  `ne_id` int(11) NOT NULL,
  `newsevents` varchar(500) NOT NULL,
  `progress_list` int(200) NOT NULL,
  `datetime` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `newsevents`
--

INSERT INTO `newsevents` (`ne_id`, `newsevents`, `progress_list`, `datetime`) VALUES
(3, 'Final Cut', 85, '2015-12-15 16:56:57'),
(5, 'Motion Video', 80, '2015-12-15 16:57:18'),
(6, 'Photoshop', 90, '2015-12-15 16:56:34'),
(7, 'Photography', 95, '2015-12-24 08:53:49');

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

--
-- Table structure for table `prices`
--

CREATE TABLE `prices` (
  `tes_id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `price` varchar(255) NOT NULL,
  `title1` varchar(255) NOT NULL,
  `title2` varchar(255) NOT NULL,
  `title3` varchar(255) NOT NULL,
  `title4` varchar(255) NOT NULL,
  `title5` varchar(255) NOT NULL,
  `title6` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `image` varchar(255) NOT NULL,
  `category` varchar(255) NOT NULL,
  `datetime` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `prices`
--

INSERT INTO `prices` (`tes_id`, `title`, `price`, `title1`, `title2`, `title3`, `title4`, `title5`, `title6`, `description`, `image`, `category`, `datetime`) VALUES
(4, 'Platinum', '60,000-1,00,000', 'black', 'One Day Event,upto 8-10 hours shooting ,3 photographers Processed and colour corrected photographs', '12', '6-8 minute wedding short cinematographed song+Full wedding movie', 'one tabletop calender with best 14 pictures', '', '<h2><span style=\"color:#FFD700\">More than 3 days event ? &ndash; Platinum Options..Visit our office..!!</span></h2>\r\n\r\n<div class=\"note-box\" style=\"margin: 20px 0px; padding: 12px 15px; border: 1px solid rgb(237, 216, 121); outline: 0px; font-size: 15px; vertical-align: baseline; border-radius: 4px; color: rgb(255, 255, 255); text-shadow: rgba(0, 0, 0, 0.4) 1px 1px 1px; font-family: \'Roboto Condensed\', sans-serif; line-height: 25.5px; background: linear-gradient(rgba(0, 0, 0, 0) 0%, rgba(0, 0, 0, 0) 1%, rgba(0, 0, 0, 0.0470588) 99%, rgba(0, 0, 0, 0.0470588) 100%) rgb(221, 199, 96);\"><strong>Please email me the exact requirements and number of days you need us for, so that we can customize a package for you.</strong></div>\r\n\r\n<p><span style=\"color:#FFFFFF\">We usually shoot around 1500-2500 images per wedding. The final high-resolution images are color corrected and ready to print. You also get low res images for convenient online sharing.</span></p>\r\n\r\n<p><span style=\"color:#FFFFFF\">Bookings have to be made in advance. A fifty percent advance has to be made upfront to block the dates and the rest on the day of the shoot. The mode of payment can be either via online transfer/cheque/cash.</span></p>\r\n\r\n<p><span style=\"color:#FFFFFF\">A contract with full details shall be signed on booking.</span></p>\r\n\r\n<p><span style=\"color:#FFFFFF\">I do not take up more than four or five weddings per season, to maintain the quality of my work. Therefore, I will need the following details before I can give you an exact quotation.</span></p>\r\n\r\n<p><span style=\"color:#FFFFFF\">1. Exact date of the wedding and all functions (big and small events both)<br />\r\n2. Number of functions to be covered with timing (mention indoor/outdoor)<br />\r\n3. Venue of the wedding, with location &amp; city<br />\r\n4. Style of wedding (Maharastrian/Punjabi/Christian/Islamic/etc) (To get clarity on the rituals)<br />\r\n5. Expected number of guests<br />\r\n6. Small note about the bride and groom<br />\r\n7. Their story<br />\r\n8. Any special requests like pre wedding shoot, photo book, photo booth etc<br />\r\n9. Preferred package</span></p>\r\n\r\n<h2>&nbsp;</h2>', 'default.jpg', 'Platinum', '2015-12-15 16:15:19'),
(5, 'Diamond', '1,25,000-2,25,000', 'black', 'First day-2 photographers,upto 6-8 hours shooting.Second day-2 Photographers upto 8-10 hours shooting', 'Processed and colour corrected photographs', '12', 'one tabletop calender with best 14 pictures', '', '<h2><span style=\"color:#FFFFFF\">3 Days Event &ndash; Diamond Options (Rs 2,50,000 &ndash; Rs 3,50,000)</span></h2>\r\n\r\n<div class=\"tip-box\" style=\"margin: 20px 0px; padding: 12px 15px; border: 1px solid rgb(162, 186, 106); outline: 0px; font-size: 15px; vertical-align: baseline; border-radius: 4px; color: rgb(255, 255, 255); text-shadow: rgba(0, 0, 0, 0.4) 1px 1px 1px; font-family: \'Roboto Condensed\', sans-serif; line-height: 25.5px; background: linear-gradient(rgba(0, 0, 0, 0) 0%, rgba(0, 0, 0, 0) 1%, rgba(0, 0, 0, 0.0470588) 99%, rgba(0, 0, 0, 0.0470588) 100%) rgb(148, 171, 93);\">\r\n<h3>Photography Only Package</h3>\r\n\r\n<p>Three day photo coverage<br />\r\nExclusive couple shoot on any one of the days&ndash; Upto 4 hours shooting<br />\r\nFirst day &ndash; Upto 4-6 hours shooting &ndash; 2 photographers<br />\r\nSecond day &ndash; Upto 4-6 hours shooting &ndash; 2 photographers<br />\r\nWedding day &ndash; Upto 8-10 hours shooting &ndash; 2 photographers<br />\r\nAll photographs processed, color corrected and ready to print on hard drive<br />\r\nOne table top calendar with best 14 pictures<br />\r\n12&times;18 Huge Photo Album (Photobook) with best 350 pictures nicely arranged with premium paper</p>\r\n\r\n<h3>Videography/Cinematography Only Package</h3>\r\n\r\n<p>Three day video coverage<br />\r\nExclusive couple shoot on any one of the days&ndash; Upto 4 hours shooting<br />\r\nFirst day &ndash; Upto 4-6 hours shooting &ndash; 2 cinematographers + 1 assistant<br />\r\nSecond day &ndash; Upto 4-6 hours shooting &ndash; 2 cinematographers + 1 assistant<br />\r\nWedding day &ndash; Upto 8-10 hours shooting &ndash; 2 cinematographers + 1 assistant<br />\r\nAudio Video interviews of bride, groom, close family members<br />\r\n6-8 minute edited and compiled HD wedding film<br />\r\nAll candid videos as short clips on hard drive<br />\r\nFinal Long Wedding FullHD Movie</p>\r\n\r\n<h3>Photography, Videography, Cinematography Package</h3>\r\n\r\n<p>Three day photo and video coverage<br />\r\nExclusive couple shoot on any one of the days&ndash; Upto 4 hours shooting<br />\r\nFirst day &ndash; Upto 4-6 hours shooting &ndash; 2 photographers + 2 cinematographers + 1 assistant<br />\r\nSecond day &ndash; Upto 4-6 hours shooting &ndash; 2 photographers + 2 cinematographers+ 1 assistant<br />\r\nWedding day &ndash; Upto 8-10 hours shooting &ndash; 2 photographers + 2 cinematographers+ 1 assistant<br />\r\nAudio Video interviews of bride, groom, close family members<br />\r\n6-8 minute edited and compiled HD wedding film<br />\r\nAll candid videos as short clips<br />\r\nAll photographs processed, color corrected and ready to print on hard drive<br />\r\nOne table top calendar with best 14 pictures<br />\r\n12&times;18 Huge Photo Album (Photobook) with best 350 pictures nicely arranged with premium paper<br />\r\nFinal Long Wedding FullHD Movie</p>\r\n</div>', 'default.jpg', 'Gold', '2015-12-15 16:19:45'),
(6, 'Gold', '2,50,000-4,00,000', 'black', 'First day-2 photographers+2 videographers+assistants,upto 6-8 hours shooting.Second day-2 Photographers+2videographers+assistants upto 8-10 hours shooting,Third day-2 Photographers+2videographers+assistants', 'full processed fantastically edited photographs', '3-4 cinematographed wedding event films + Full wedding movie.', '12', 'one tabletop calender+one wall calender with best 14 pictures+one surprise by our side', '<h2><span style=\"color:rgb(255, 255, 255)\">2 Days Event &ndash; Gold Options (Rs 1,50,000 &ndash; Rs 2,50,000)</span></h2>\r\n\r\n<div class=\"error-box\" style=\"margin: 20px 0px; padding: 12px 15px; border: 1px solid rgb(174, 70, 65); outline: 0px; font-size: 15px; vertical-align: baseline; border-radius: 4px; color: rgb(255, 255, 255); text-shadow: rgba(0, 0, 0, 0.4) 1px 1px 1px; font-family: \'Roboto Condensed\', sans-serif; line-height: 25.5px; background: linear-gradient(rgba(0, 0, 0, 0) 0%, rgba(0, 0, 0, 0) 1%, rgba(0, 0, 0, 0.0470588) 99%, rgba(0, 0, 0, 0.0470588) 100%) rgb(151, 57, 52);\">\r\n<h3><span style=\"color:rgb(255, 255, 0)\"><span style=\"font-size:16px\">Photography Only Package</span></span></h3>\r\n\r\n<p><span style=\"font-size:16px\">Two day photo coverage<br />\r\nExclusive couple shoot on any one of the days&ndash; Upto 4 hours shooting<br />\r\nFirst day &ndash; Upto 6-8 hours shooting &ndash; 2 photographers<br />\r\nWedding day &ndash; Upto 8-10 hours shooting &ndash; 2 photographers<br />\r\nAll photographs processed, color corrected and ready to print on hard drive<br />\r\nOne table top calendar with best 14 pictures<br />\r\n12&times;18 Huge Photo Album (Photobook) with best 350 pictures nicely arranged with premium paper</span></p>\r\n\r\n<h3><span style=\"color:rgb(255, 215, 0)\"><span style=\"font-size:16px\">Videography/Cinematography Only Package</span></span></h3>\r\n\r\n<p><span style=\"font-size:16px\">Two day video coverage<br />\r\nExclusive couple shoot on any one of the days&ndash; Upto 4 hours shooting<br />\r\nFinal Long Wedding FullHD Movie</span></p>\r\n\r\n<h3><span style=\"color:rgb(255, 215, 0)\"><span style=\"font-size:16px\">Photography, Videography, Cinematography Package</span></span></h3>\r\n\r\n<p><span style=\"font-size:16px\">Two day photo and video coverage<br />\r\nExclusive couple shoot on any one of the days&ndash; Upto 4 hours shooting<br />\r\nFirst day &ndash; Upto 6-8 hours shooting &ndash; 2 photographers + 2 cinematographers + 1 assistant<br />\r\nWedding day &ndash; Upto 8-10 hours shooting &ndash; 2 photographers + 2 cinematographers + 1 assistant<br />\r\nAudio Video interviews of bride, groom, close family members<br />\r\n6-8 minute edited and compiled HD wedding film<br />\r\nAll candid videos as short clips<br />\r\nAll photographs processed, color corrected and ready to print on hard drive<br />\r\nOne table top calendar with best 14 pictures<br />\r\n12&times;18 Huge Photo Album (Photobook) with best 350 pictures nicely arranged with premium paper<br />\r\nFinal Long Wedding FullHD Movie</span></p>\r\n</div>', 'default.jpg', 'Silver', '2015-12-15 16:14:06'),
(7, 'Silver', '4500', 'black', 'Unlimited API Access', 'Unlimited Storage', 'Custom Cloud Services', 'Weekly Reports', '7/24 Support', '<h2><span style=\"color:rgb(255, 255, 255)\">1 Day Event &ndash; Silver Options (Rs 60,000 &ndash; Rs 1,00,000)</span></h2>\r\n\r\n<div class=\"info-box\" style=\"margin: 20px 0px; padding: 12px 15px; border: 1px solid rgb(109, 135, 161); outline: 0px; font-size: 15px; vertical-align: baseline; border-radius: 4px; color: rgb(255, 255, 255); text-shadow: rgba(0, 0, 0, 0.4) 1px 1px 1px; font-family: \'Roboto Condensed\', sans-serif; line-height: 25.5px; background: linear-gradient(rgba(0, 0, 0, 0) 0%, rgba(0, 0, 0, 0) 1%, rgba(0, 0, 0, 0.0470588) 99%, rgba(0, 0, 0, 0.0470588) 100%) rgb(95, 119, 143);\">\r\n<h3><span style=\"color:rgb(255, 215, 0)\">Photography Only Package</span></h3>\r\n\r\n<p>One day photo coverage<br />\r\nWedding day &ndash; Upto 8-10 hours shooting &ndash; 3 photographers<br />\r\nAll photographs processed, color corrected and ready to print on DVDs<br />\r\n12&times;18 Huge Photo Album (Photobook) with best 350 pictures nicely arranged with premium paper</p>\r\n\r\n<h3><span style=\"color:rgb(255, 215, 0)\">Videography/Cinematography Only Package</span></h3>\r\n\r\n<p>Upto 6-8 hours shooting &ndash; 2 cinematographers + 1 assistant<br />\r\nWedding day &ndash; Upto 8-10 hours shooting &ndash; 2 cinematographers + 2 videographers + assistant<br />\r\nAudio Video interviews of bride, groom, close family members<br />\r\n6-8 minute edited and compiled FullHD wedding film<br />\r\nAll candid videos as short clips on hard drive<br />\r\nFinal Long Wedding FullHD Movie</p>\r\n\r\n<h3><span style=\"color:rgb(255, 215, 0)\">Photography, Videography, Cinematography Package</span></h3>\r\n\r\n<p>One day photo and video coverage<br />\r\nWedding day &ndash; Upto 8-10 hours shooting &ndash; 2 photographers + 1 cinematographers + 1 assistant<br />\r\nAudio Video interviews of bride, groom, close family members<br />\r\n4-6 minute edited and compiled HD wedding film<br />\r\nAll candid videos as short clips<br />\r\nAll photographs processed, color corrected and ready to print on hard drive<br />\r\nOne table top calendar with best 14 pictures<br />\r\n12&times;18 Huge Photo Album (Photobook) with best 350 pictures nicely arranged with premium paper<br />\r\nFinal Long Wedding FullHD Movie</p>\r\n</div>', 'default.jpg', 'Bronze', '2016-05-09 11:51:55'),
(9, 'Fashion Shoots', '', 'black', '', '', '', '', '', '<p><span style=\"font-family:arial,helvetica,sans-serif\"><span style=\"color:#FFA07A\"><strong><em>Fashion shoot packages starting from &nbsp;20,000/-INR </em></strong>..packages are as follows.</span></span></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<h2 style=\"font-style:italic;\"><span style=\"font-size:12px\"><strong><span style=\"color:#008000\">1) MINI PACKAGE -(5000/-INR)</span></strong></span></h2>\r\n\r\n<p><span style=\"color:#FFD700\">it includes 5 to 10 pictures with&nbsp;single makeup No Printing would be included in this package.photoshoot would be in local.if outdoors our conveyance and fooding should be by yourself ....!!</span></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><span style=\"font-family:arial,helvetica,sans-serif\"><span style=\"color:#FF8C00\"><strong><em><u>1)BASIC PACKAGE-(20,000/-INR---25,000/-INR)</u></em></strong></span></span></p>\r\n\r\n<p><span style=\"color:#FFD700\"><span style=\"font-family:arial,helvetica,sans-serif\">It includes a standard photobook printed with best 20&nbsp;to 25&nbsp;pictures,6 changes,single makeup,individual shoot.+behind the shoot high quality video+slide show video of selected pictures+one gift from our side.</span></span></p>\r\n\r\n<p><span style=\"font-family:arial,helvetica,sans-serif\"><span style=\"color:#FF8C00\"><u><em><strong>2)ADVANCED PACKAGE-(30,000/-INR---40,000/-INR)</strong></em></u></span></span></p>\r\n\r\n<p><span style=\"font-family:arial,helvetica,sans-serif\"><span style=\"color:#FFD700\">It includes a luxury photobook printed with best 30&nbsp;to 35&nbsp;pictures,8 to 10 changes,3 makeups,individual/couple shoot with a male or female model on hire+behind the shoot video+slide show video of selected pictures+one finely cinematographed video+one gift from our side.</span></span></p>\r\n\r\n<p><span style=\"font-family:arial,helvetica,sans-serif\"><span style=\"color:#FF8C00\"><u><em><strong>3)PROFESSIONAL PACKAGE-(50,000/-INR---70,000/-INR)</strong></em></u></span></span></p>\r\n\r\n<p><span style=\"font-family:arial,helvetica,sans-serif\"><span style=\"color:#FFD700\">It includes a luxury photobook printed with best 40&nbsp;to 45&nbsp;or more pictures ,12 to 15 changes,5 makeups,individual/couple shoot with model on hire +behind the scene video+slide show video of selected pictures+one finely cinemaographed video+one gift from our side</span></span></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><span style=\"font-family:arial,helvetica,sans-serif\"><span style=\"color:#F0FFFF\"><strong><em><u>*The Advanced and Professional packages includes outdoor shoot on a hill station<a class=\"FQM6L0ms wr4qFbU0\" href=\"#72311682\" title=\"Click to Continue &gt; by Deal Top\"> villa<img src=\"http://cdncache-a.akamaihd.net/items/it/img/arrow-10x10.png\" /></a>,etc according to the location of the shoot whereas the basic package is local .The variation in prices depends on the location..</u></em></strong></span></span></p>\r\n\r\n<p><span style=\"font-family:arial,helvetica,sans-serif\"><span style=\"color:#A9A9A9\">For any customization in these packages ,visit our office......</span></span></p>\r\n\r\n<p>&nbsp;</p>', 'default.jpg', 'Bronze', '2016-04-26 09:56:20');

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

--
-- Table structure for table `service`
--

CREATE TABLE `service` (
  `id` int(10) NOT NULL,
  `service` varchar(255) NOT NULL,
  `des` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `cat` varchar(255) NOT NULL,
  `datetime` date NOT NULL,
  `im` int(10) NOT NULL,
  `video` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `service`
--

INSERT INTO `service` (`id`, `service`, `des`, `image`, `cat`, `datetime`, `im`, `video`) VALUES
(25, ' Modern photo graphy', '<p>Coast of Semantics, large language ocean. A small place andsupplies it with the necessary thographic language ocean. small place and supplies it with the necessary life regelialia thographic life One day supplies it with the necessary regelialia thogra', 'This is Modern photo graphy2_article-1.jpg', 'Category 1', '2018-09-24', 0, 'https://www.youtube.com/embed/i87mdydtYX4'),
(26, 'Wedding Service', '<p>lies it with the necessary life regelialia thographic life One day supplies it with the necessary regelialia thogra</p>', 'This is Modern photo graphy with video graphy1_work-1-2.jpg', 'Category 1', '2018-09-24', 0, 'https://www.youtube.com/embed/i87mdydtYX4');

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

--
-- Table structure for table `simg`
--

CREATE TABLE `simg` (
  `id` int(10) NOT NULL,
  `sid` int(10) NOT NULL,
  `images` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `simg`
--

INSERT INTO `simg` (`id`, `sid`, `images`) VALUES
(17, 25, '2.jpg'),
(18, 25, 'work-1-2.jpg'),
(19, 25, 'work-1-3.jpg'),
(20, 25, 'work-1-4.jpg'),
(21, 25, 'work-1-7.jpg'),
(22, 26, 'work-1-9.jpg'),
(23, 26, 'work-1-10.jpg'),
(24, 26, 'work-1-11.jpg'),
(25, 26, 'work-1-12.jpg');

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

--
-- Table structure for table `student`
--

CREATE TABLE `student` (
  `idd` int(10) NOT NULL,
  `fname` varchar(255) NOT NULL,
  `mname` varchar(255) NOT NULL,
  `lname` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `p` varchar(255) NOT NULL,
  `cp` varchar(255) NOT NULL,
  `referid` varchar(255) NOT NULL,
  `pstatus` int(10) NOT NULL DEFAULT '0',
  `form` varchar(255) NOT NULL,
  `datetime` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `student`
--

INSERT INTO `student` (`idd`, `fname`, `mname`, `lname`, `email`, `phone`, `p`, `cp`, `referid`, `pstatus`, `form`, `datetime`) VALUES
(1, 'jatin', 'j', 'jatin', 'jatin@phitsolution.com', '8791391630', 'm', 'n', '', 0, '', '2018-10-03'),
(2, 'jatin', '', 'jatin', 'jatin@phitsolution.com', '8791391630', 'm', 'm', '', 0, '', '2018-10-03'),
(3, 'jatin', '', 'jatin', 'jatin@phitsolution.com', '8791391630', 'm', 'm', '', 0, '', '2018-10-03'),
(4, 'jatin', 's', 'a', 'jatin@phitsolution.com', '8791391630', 'a', 'aa', '', 0, '', '2018-10-03'),
(5, 'jatinaaaaaa', 'aaaa', 'aaa', 'aa@gmail.com', 'aaa', 'aa', 'aaaaa', '', 0, '', '2018-10-03'),
(6, 'jatin', 'j', 'jatin', 'jatin@phitsolution.comx', '8791391630', 's', 's', '', 0, '', '2018-10-03'),
(7, 'jatin', 'j', 'jatin', 'jatin@phitsolsution.com', '8791393630', 'a', 'a', '', 0, '', '2018-10-03'),
(8, 'name', '', 'garg', 'naman@gmail.com', '8791398989', 'aa', 'aa', '', 0, '', '2018-10-03');

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

--
-- Table structure for table `team`
--

CREATE TABLE `team` (
  `tes_id` int(11) NOT NULL,
  `category` varchar(255) NOT NULL,
  `author` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `image` varchar(255) NOT NULL,
  `datetime` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `team`
--

INSERT INTO `team` (`tes_id`, `category`, `author`, `description`, `image`, `datetime`) VALUES
(40, 'NA', 'NISHCHAY KUMAR NIMBEKAR/8791498522', 'DIRECTOR | PHOTOGRAPHER | CINEMATOGRAPHER', 'NISHCHAY KUMAR NIMBEKAR/87914985221__MG_1876 copy.jpg', '2016-08-05 18:01:34');

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

--
-- Table structure for table `testimonial`
--

CREATE TABLE `testimonial` (
  `tes_id` int(11) NOT NULL,
  `author` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `image` varchar(255) NOT NULL,
  `category` varchar(255) NOT NULL,
  `datetime` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `testimonial`
--

INSERT INTO `testimonial` (`tes_id`, `author`, `description`, `image`, `category`, `datetime`) VALUES
(1, 'Photographerss', '', 'Photographers2_partner-5.png', 'Category 1', '2018-09-25 08:09:42'),
(2, 'a', '', 'a1_partner-4.png', '', '2018-09-25 08:14:11'),
(3, 's', '', 's1_partner-3.png', '', '2018-09-25 08:14:19'),
(4, '3', '', '31_partner-2.png', '', '2018-09-25 08:14:26');

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

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

CREATE TABLE `video_gallery` (
  `vid_id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `category` int(11) NOT NULL,
  `url` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `datetime` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `video_gallery` (`vid_id`, `title`, `category`, `url`, `description`, `datetime`) VALUES
(1, 'MANSHI', 25, 'https://www.youtube.com/embed/B3Y-X0z-jWc', 'NA', '2016-08-09 14:09:15'),
(2, 'MANSHI', 25, 'https://www.youtube.com/embed/VHVFf8e5qyE', 'NA', '2016-08-09 14:10:04'),
(3, 'MANSHI', 25, 'https://www.youtube.com/embed/ryTWk3HTRrg', 'NA', '2016-08-09 14:10:26');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `about`
--
ALTER TABLE `about`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `aboutimg`
--
ALTER TABLE `aboutimg`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `banner`
--
ALTER TABLE `banner`
  ADD PRIMARY KEY (`tes_id`);

--
-- Indexes for table `category`
--
ALTER TABLE `category`
  ADD PRIMARY KEY (`categoryId`);

--
-- Indexes for table `clients`
--
ALTER TABLE `clients`
  ADD PRIMARY KEY (`cli_id`);

--
-- Indexes for table `cms`
--
ALTER TABLE `cms`
  ADD PRIMARY KEY (`category`);

--
-- Indexes for table `gallery`
--
ALTER TABLE `gallery`
  ADD PRIMARY KEY (`gal_id`);

--
-- Indexes for table `newsevents`
--
ALTER TABLE `newsevents`
  ADD PRIMARY KEY (`ne_id`);

--
-- Indexes for table `prices`
--
ALTER TABLE `prices`
  ADD PRIMARY KEY (`tes_id`);

--
-- Indexes for table `service`
--
ALTER TABLE `service`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `simg`
--
ALTER TABLE `simg`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `student`
--
ALTER TABLE `student`
  ADD PRIMARY KEY (`idd`);

--
-- Indexes for table `team`
--
ALTER TABLE `team`
  ADD PRIMARY KEY (`tes_id`);

--
-- Indexes for table `testimonial`
--
ALTER TABLE `testimonial`
  ADD PRIMARY KEY (`tes_id`);

--
-- Indexes for table `video_gallery`
--
ALTER TABLE `video_gallery`
  ADD PRIMARY KEY (`vid_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `about`
--
ALTER TABLE `about`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `aboutimg`
--
ALTER TABLE `aboutimg`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `banner`
--
ALTER TABLE `banner`
  MODIFY `tes_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=38;

--
-- AUTO_INCREMENT for table `category`
--
ALTER TABLE `category`
  MODIFY `categoryId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;

--
-- AUTO_INCREMENT for table `clients`
--
ALTER TABLE `clients`
  MODIFY `cli_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `gallery`
--
ALTER TABLE `gallery`
  MODIFY `gal_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=190;

--
-- AUTO_INCREMENT for table `newsevents`
--
ALTER TABLE `newsevents`
  MODIFY `ne_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `prices`
--
ALTER TABLE `prices`
  MODIFY `tes_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `service`
--
ALTER TABLE `service`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;

--
-- AUTO_INCREMENT for table `simg`
--
ALTER TABLE `simg`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;

--
-- AUTO_INCREMENT for table `student`
--
ALTER TABLE `student`
  MODIFY `idd` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `team`
--
ALTER TABLE `team`
  MODIFY `tes_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=41;

--
-- AUTO_INCREMENT for table `testimonial`
--
ALTER TABLE `testimonial`
  MODIFY `tes_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `video_gallery`
--
ALTER TABLE `video_gallery`
  MODIFY `vid_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
COMMIT;

