hjkhhrtertererrrrrerrtertertertertertertert
bnmbnerterterterterterdfgdfgdfgdfgdfgdfgdfgdfgdfg
/
home4
/
digil8bw
/
snowcrestresidency.com
/
Upload FileeE
HOME
-- phpMyAdmin SQL Dump -- version 4.9.11 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Mar 31, 2023 at 08:38 PM -- Server version: 5.7.23-23 -- PHP Version: 7.4.33 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `snowcres_db` -- -- -------------------------------------------------------- -- -- Table structure for table `admin_login` -- CREATE TABLE `admin_login` ( `id` int(11) NOT NULL, `username` varchar(255) NOT NULL, `password` varchar(255) NOT NULL, `regi_date` varchar(255) NOT NULL, `admin_last_login` varchar(255) NOT NULL, `type` varchar(255) NOT NULL, `status` int(11) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `admin_login` -- INSERT INTO `admin_login` (`id`, `username`, `password`, `regi_date`, `admin_last_login`, `type`, `status`) VALUES (1, 'admin', 'Admin@12345', '', 'Fri, Mar 31,2023 5:29 am', 'Superadmin', 0); -- -------------------------------------------------------- -- -- Table structure for table `sh_about` -- CREATE TABLE `sh_about` ( `id` int(11) NOT NULL, `hometitle` varchar(200) NOT NULL, `description` text NOT NULL, `img1` varchar(200) NOT NULL, `img2` varchar(200) NOT NULL, `img3` varchar(200) NOT NULL, `mainimg` varchar(200) NOT NULL, `abouttitle` varchar(200) NOT NULL, `paragraph` text NOT NULL, `paragraph2` text NOT NULL, `update_date_time` varchar(255) NOT NULL, `update_admin_user` varchar(255) NOT NULL, `status` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `sh_about` -- INSERT INTO `sh_about` (`id`, `hometitle`, `description`, `img1`, `img2`, `img3`, `mainimg`, `abouttitle`, `paragraph`, `paragraph2`, `update_date_time`, `update_admin_user`, `status`) VALUES (1, 'Welcome To Snow Crest Residency Hotel Luxury', 'Hotel Snow Crest Residency is surrounded by beautiful apple valley deodor trees at backyard and snow capped mountains all around it. rooms have private balcony with breathtaking view of apply valley and beautiful spectacular view of mountains. peaceful and serene ambiance makes this place perfect for nature lovers.\r\nHave private parking space and small lawn for sun basking and bone fire. Hospitality is our passion and we know what you expect and need when you are away from home. most appropriate place for long stay, staycation , Honey moon couple, family vacation , college and school tours. when season is favorable you can go around plucking apples , plums and pears.', '11673961748.jpg', '21679642849.jpeg', '31673961748.jpg', '41674890662.jpg', '20 Years Of Experience', 'The Snow Crest Residency organisation and its personnel are committed to providing efficient services and welcoming hospitality to the needs of tourists from all communities and nationalities. Important factors like neatness, professionalism, and the availability of attractive installations within our demesne are essential to the success of our services and operations.', 'Understanding our valued clients\' expectations is extremely important to us at Snow Crest Residency. Mr. Rao, director, takes personal interest in all operations and efficiency for improved client care and expert services. He can be reached directly at (+91) 98160 25631 , Email : vprao80199@gmail.com', '2023-03-24 07:27:29am', 'admin', 1); -- -------------------------------------------------------- -- -- Table structure for table `sh_activity` -- CREATE TABLE `sh_activity` ( `id` int(11) NOT NULL, `title` varchar(255) NOT NULL, `img` varchar(255) NOT NULL, `doj` varchar(255) NOT NULL, `description` text NOT NULL, `update_date_time` varchar(255) NOT NULL, `update_admin_user` varchar(255) NOT NULL, `status` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `sh_activity` -- INSERT INTO `sh_activity` (`id`, `title`, `img`, `doj`, `description`, `update_date_time`, `update_admin_user`, `status`) VALUES (6, 'Skiing – Play Around The Snow', '1671801750.jpg', '20-December-2022', '<p>Enjoy your snowy rendezvous with skiing, at the famous Solang Valley near Manali. One of the most sought-after adventure sports in Manali, Skiing is offered along with prior assistance and sessions. One can also go Skiing in Rohtang, Marhi, Gulaba and Dhundi, but there is a good chance that the experience of skiing in Manali will reign supreme.</p>\r\n', '2022-12-23 01:22:30pm', 'admin', 1), (7, 'Paragliding – Bird’s Eye View', '1671801708.jpg', '12-December-2022', '<p>Surf along majestic mountains and get intimate with deep blue skies while paragliding in Manali. One must possess nerves of steel to make the initial jump, after all it is considerably one of the most challenging adventure sports in Manali.</p>\r\n\r\n<p>Note: Amateur (accompanied by pilots), can glide for a span of 60-90 seconds, while experienced gliders, for 30 minutes.</p>\r\n', '2022-12-23 01:21:48pm', 'admin', 1), (8, 'River Rafting – Fight The Gushing Waters', '1671801644.jpg', '11-December-2022', '<p>For those who wish to conquer the hard currents of water, river rafting in Manali is a must. The challenge of surviving through the wicked twists and turns of the rapids will quench your thirst for adventure in Manali. Before starting, the rafters are given a brief introduction and made wary of the lurking dangers. This is amongst the most loved adventure activities in Manali.</p>\r\n', '2022-12-23 01:20:44pm', 'admin', 1); -- -------------------------------------------------------- -- -- Table structure for table `sh_amenities` -- CREATE TABLE `sh_amenities` ( `id` int(11) NOT NULL, `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `img` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `description` text COLLATE utf8_unicode_ci NOT NULL, `displayorder` int(11) NOT NULL, `update_date_time` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `update_admin_user` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `status` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `sh_attraction` -- CREATE TABLE `sh_attraction` ( `id` int(11) NOT NULL, `title` varchar(255) NOT NULL, `img` varchar(255) NOT NULL, `subtitle` varchar(255) NOT NULL, `description` text NOT NULL, `update_date_time` varchar(255) NOT NULL, `update_admin_user` varchar(255) NOT NULL, `status` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `sh_attraction` -- INSERT INTO `sh_attraction` (`id`, `title`, `img`, `subtitle`, `description`, `update_date_time`, `update_admin_user`, `status`) VALUES (3, 'Hidimba Temple', '1671801271.jpg', 'Manali', '<p> Hidimba temple is Located near Mall road , Hidimba Temple is beauty of Manali . the Hadimba Temple is a unique shrine dedicated to Hidimba Devi, who was the wife of Bhima and mother of Ghatothkach. Surrounded by gorgeous cedar forests, this beautiful shrine is built on a rock which is believed to be in the image of goddess Hidimba herself. </p>\r\n\r\n<p>Locally known as Dhungari Temple, the construction style of the Hidimba Devi temple is entirely different from that of any of the other temples, with its wooden doorways, walls, and cone-shaped roof. the door of hidimba tample is different from another tampleThis temple is a fitting dedication to its presiding deity Hadimba. Hotel Snow Crest Residency is 18 kms from Hotel Snow Crest Residency. </p>\r\n', '2023-03-24 09:19:43am', 'admin', 1), (6, 'Solang Valley', '1677847273.jpg', 'Manali', '<p>When heading to Manali for a vacation, two absolutely essential destinations in the itinerary are Rohtang and Solang Valley. 14 kilometres to the north west of the main town of Manali, Solang Valley is one of the most popular tourist destinations in Himachal Pradesh. Situated on the way to Rohtang from Manali, every year the valley welcomes tourists in huge numbers. A favourite for adventure enthusiasts, parachuting to paragliding, horse riding to driving mini-open jeeps specially available for tourists of all age groups, Solang Valley has it all.</p>\r\n\r\n<p>During winters, Solang valley is covered with snow, making skiing is a popular sport here, with training institutes and trainers located in the valley to supervise skiers and train beginners. As the snow melts, skiing is taken over by zorbing. Another popular attraction of Solang valley, taking advantage of the slopes of the valley, you are likely to spot a huge transparent ball with mostly two people inside it rolling down the slope during summers. Yes, Zorbing is as much fun as it looks like. One of the most vibrant and enjoyable places in Manali, there is no way one can possibly miss this amazing valley, while here.</p>\r\n', '2023-03-03 12:41:13pm', 'admin', 1), (7, 'Rohtang Pass', '1671801347.jpg', 'Manali', '<p>Located at a distance of just 55 kilometres from hotel Snow Crest Residency, Rohtang Pass can be reached only by road. The pass is located at a massive height of 3978 metres on Manali- Keylong road. When planning a trip to Manali, a day off to the vista point of Rohtang Pass is the ultimate and almost essential attraction of the itinerary. Owing to its splendid natural beauty, Rohtang Pass is a favourite among the community of film directors. Many blockbusters ranging from 'Jab We Met' to 'Yeh Jawani Hai Deewani' have been shot here. A peculiar fact behind the name of the place is that it was named so because a number of people working in CBRE died whilst trying to cross this treacherous stretch.</p>\r\n\r\n<p>An experience of the snow can never be complete without a sledge ride, which involves sliding through the snow in a wooden toboggan. Another thrilling activity that can be pursued at Rohtang Pass would be mountain biking where you ride your mountain bikes off the regular course and into the lesser taken routes. It can get a bit rough, so you must take care in case you are planning on pursuing this activity. You can try your hand at skiing and tyre drop at the Rohtang Pass as well, where again you slide down a slope of snow whilst using the appropriate equipment. Gear for all of these activities is available for reasonable rent, so do not miss out on this opportunity.</p>\r\n', '2023-03-03 12:18:14pm', 'admin', 1), (12, 'Naggar Castle', '1677842236.jpg', '', '<p><strong>The Naggar Castle is a magnificent historical structure. It is one of the best Place to visit in Manali. The castle was built by Raja Sidhi Singh in 1460 AD in an impressive combination of European and Himalayan architecture. The castle has traditional architecture called Kathkooni, which uses a combination of stones and wooden beams. The Naggar Castle is a famous castle located in Naggar. The Castle overlooks the Kullu Valley. From the castle one could see the far off snow-covered peaks, the delightful Beas valley below and the lush green hill sides dotted with apple orchards. Movies & Episodes Shot in Naggar Castle <ins><span class=\"marker\">THE HERO MOVIE, ROZA MOVIE, JAB WE MET MOVIE, TERE NAAL LOVE HO GAYA MOVIE, BANG BANG MOVIE, TUBE LIGHT MOVIE, YAAR ANMULLE RETURN MOVIE, MAARCHIS MOVIE, DESAMUDURU MOVIE (TELGU), LITTLE CHAMPS EPISODE, JASOOS VIJAY EPISODE, NOORIE EPISODE, PATIALA BEBE EPISODE</span></ins>. <ins>This is another popular attraction not to miss in a Manali tour</ins>. Hotel Snow Crest Residency is 4.4 km from Naggar Castle Manali. Hotel Snow Crest Residency is surrounded by beautiful apple valley deodor trees at backyard and snow capped mountains all around it. rooms have private balcony with breathtaking view of apply valley and beautiful spectacular view of mountains. peaceful and serene ambiance makes this place perfect for nature lovers. Hotel Snow Crest Residency is Best Hotel near Naggar Castle Manali.<ins><a href=\"https://www.trawell.in/tour-packages/manali\" target=\"_blank\"> </a></ins></strong></p>\r\n', '2023-03-27 08:49:44am', 'admin', 1), (13, 'Nicholas Roerich Art Gallery And Museum', '1677843593.jpg', '', '<p>The Nicholas Roerich art gallery is amazingPlace at Manali (Naggar). Nicholas Roerich is a Russian artist arrived in the Himalayas after the revolution of 1917, where he died in the year 1947. He married to Helena Roerich and famous Indian actor Devika Rani is his daughter in law.<br />\r\n<br />\r\nThe Nicholas Roerich art gallery was founded in 1962 by Svyetoslav Roerich, son of Nicholas Roerich. The building that now houses the gallery once served as the residence of Nicholas Roerich. Himachal Pradesh Government and Russian Government have formed a trust to run this art gallery as the Roerich Heritage Museum.<br />\r\nPaintings of Kullu, Spiti and Lahaul made by the painter have been housed in the ground floor of the gallery. A great number of his works are preserved in museums all over the world. Most of the paintings show the beauty of ice covered valleys and peaks during early hours of evening.<a href=\"http://www.snowcrestresidency.com\"> Hotel Snow Crest Residency is 4.4 kms From The Nicholas Roerich art gallery</a>. Hotel snow Crest Residency is best Hotel near The Nicholas Roerich art gallery.<a href=\"http://www.snowcrestresidency.com\">Hotel Snow Crest Residency</a> is surrounded by beautiful apple valley deodor trees at backyard and snow capped mountains all around it. rooms have private balcony with breathtaking view of apply valley and beautiful spectacular view of mountains. peaceful and serene ambiance makes this place perfect for nature lovers</p>\r\n', '2023-03-04 11:28:58am', 'admin', 1); -- -------------------------------------------------------- -- -- Table structure for table `sh_banner_slider` -- CREATE TABLE `sh_banner_slider` ( `id` int(11) NOT NULL, `title` varchar(255) NOT NULL, `subtitle` varchar(255) NOT NULL, `img` varchar(255) NOT NULL, `update_date_time` varchar(255) NOT NULL, `update_admin_user` varchar(255) NOT NULL, `displayorder` int(11) NOT NULL, `status` int(11) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `sh_banner_slider` -- INSERT INTO `sh_banner_slider` (`id`, `title`, `subtitle`, `img`, `update_date_time`, `update_admin_user`, `displayorder`, `status`) VALUES (3, 'Welcome To Snow crest Residency Manali', 'Hotel & Resort', '1677843701.jpg', '2023-03-03 11:41:41am', 'admin', 0, 1), (12, '', '', '1677925868.jpg', '2023-03-04 10:31:08am', 'admin', 0, 1), (13, 'Nature with Snow', 'Summer', '1674196153.jpg', '2023-03-04 10:31:26am', 'admin', 0, 1), (16, 'Balcony View', '', '1677495623.jpg', '2023-02-27 11:00:23am', 'admin', 0, 1), (14, 'Apple Valley View', '', '1674196279.jpg', '2023-03-03 10:53:57am', 'admin', 0, 1), (15, 'The years last \"loveliest smile\". (AUTUMN)', '', '1674196300.jpg', '2023-03-03 10:28:30am', 'admin', 0, 1); -- -------------------------------------------------------- -- -- Table structure for table `sh_booking` -- CREATE TABLE `sh_booking` ( `id` int(11) NOT NULL, `name` varchar(255) NOT NULL, `phone` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `checkin` varchar(255) NOT NULL, `checkout` varchar(255) NOT NULL, `adults` int(11) NOT NULL, `children` int(11) NOT NULL, `roomtype` text NOT NULL, `comments` text NOT NULL, `insert_date` varchar(255) NOT NULL, `status` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `sh_booking` -- INSERT INTO `sh_booking` (`id`, `name`, `phone`, `email`, `checkin`, `checkout`, `adults`, `children`, `roomtype`, `comments`, `insert_date`, `status`) VALUES (1, 'asadasd', '3423423423', 'asdasd@gmail.com', '21/12/22', '21/12/22', 0, 0, '', '', '2022-12-23 11:12:27am', 1), (2, 'Nitin Soni ', '9988439886', 'sonineil810@gmail.com', '14/04/23', '14/04/23,17/04/23', 2, 1, '', '', '2023-03-25 04:08:17pm', 1); -- -------------------------------------------------------- -- -- Table structure for table `sh_contact_enquiry` -- CREATE TABLE `sh_contact_enquiry` ( `id` int(11) NOT NULL, `name` varchar(255) NOT NULL, `phone` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `subject` text NOT NULL, `message` text NOT NULL, `insert_date` datetime NOT NULL, `status` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `sh_gallery` -- CREATE TABLE `sh_gallery` ( `id` int(11) NOT NULL, `albumID` int(11) NOT NULL, `title` varchar(255) NOT NULL, `img` varchar(255) NOT NULL, `imgalt` varchar(255) NOT NULL, `displayorder` int(11) NOT NULL, `update_admin_user` varchar(255) NOT NULL, `update_date_time` varchar(255) NOT NULL, `status` int(11) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `sh_gallery` -- INSERT INTO `sh_gallery` (`id`, `albumID`, `title`, `img`, `imgalt`, `displayorder`, `update_admin_user`, `update_date_time`, `status`) VALUES (1, 0, 'hotel Snow Crest Residency Manali', '1673789670.jpeg', 'Gallery', 0, 'admin', '2023-03-14 06:22:37am', 1), (2, 0, 'out side view', '1673723847.jpeg', 'Out Side View', 0, 'admin', '2023-02-23 07:21:00am', 1), (4, 0, 'snow view', '1673724054.jpeg', 'Gallery 3', 0, 'admin', '2023-03-14 06:24:19am', 1), (5, 0, 'Balcony', '1678775132.jpg', 'Gallery', 0, 'admin', '2023-03-14 06:25:32am', 1), (7, 0, 'Snow Man', '1673724151.jpeg', '', 0, 'admin', '2023-03-14 06:27:12am', 1); -- -------------------------------------------------------- -- -- Table structure for table `sh_room` -- CREATE TABLE `sh_room` ( `id` int(11) NOT NULL, `title` varchar(255) NOT NULL, `img` varchar(255) NOT NULL, `price` varchar(255) NOT NULL, `size` varchar(255) NOT NULL, `capacity` varchar(255) NOT NULL, `bed` varchar(200) NOT NULL, `shot_description` text NOT NULL, `description` text NOT NULL, `update_date_time` varchar(255) NOT NULL, `update_admin_user` varchar(255) NOT NULL, `status` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `sh_room` -- INSERT INTO `sh_room` (`id`, `title`, `img`, `price`, `size`, `capacity`, `bed`, `shot_description`, `description`, `update_date_time`, `update_admin_user`, `status`) VALUES (9, 'Deluxe Room', '1680241054.jpeg', '2000 ', '30 ft', '3', 'King Size', '', '<p>The Deluxe bedrooms are spacious with ample space for an extra adult or children, as well as luggage. Its amenities are an attached bath with running hot and cold water, ample cupboard space, and room service.</p>\r\n\r\n<p> Note: We allow only two people per room and the extra person will charged.</p>\r\n', '2023-03-31 05:37:34am', 'admin', 1), (10, 'Semi Deluxe Room', '1680241017.jpeg', '1800', '30 Ft', '3', 'KIng Size', '', '<p>Semi Deluxe are spacious and fully ventilated and ideal for peaceful living. Ventilated wash room is equipped with modern good quality fittings and have 24 hours hot and cold water with the mountain view. Room comprises of good satellite connection, 6 feet bed with 5 good quality mattress, full size body pillow having white linen on pillows, bed sheets and duvet of reputed Brand, Laminated back facing, 6x2 Bed runner carpet, side table, telephone, two good quality Chair and one Center Table for dinning, One big cup board which includes separate partition for luggage and capacity to accommodate day to day clothes.<br />\r\n<br />\r\nNote: We allow only two person per room and the extra person will charged. </p>\r\n', '2023-03-31 05:50:07am', 'admin', 1); -- -------------------------------------------------------- -- -- Table structure for table `sh_room_images` -- CREATE TABLE `sh_room_images` ( `id` int(11) NOT NULL, `img` varchar(255) NOT NULL, `roomID` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `sh_room_images` -- INSERT INTO `sh_room_images` (`id`, `img`, `roomID`) VALUES (29, '482537985.jpeg', 9), (30, '915312303.jpeg', 10), (31, '771260662.jpeg', 10), (32, '1824720265.jpeg', 9); -- -------------------------------------------------------- -- -- Table structure for table `sh_service` -- CREATE TABLE `sh_service` ( `id` int(11) NOT NULL, `title` varchar(255) NOT NULL, `ico` varchar(255) NOT NULL, `img` varchar(255) NOT NULL, `description` text NOT NULL, `update_date_time` varchar(255) NOT NULL, `update_admin_user` varchar(255) NOT NULL, `status` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `sh_service` -- INSERT INTO `sh_service` (`id`, `title`, `ico`, `img`, `description`, `update_date_time`, `update_admin_user`, `status`) VALUES (1, 'Restaurant', '1626605047.png', '1628608653.jpg', '<p>Fresh food is prepared for our guests. A little patience is appreciated.</p>\r\n', '2021-08-10 08:47:33pm', 'admin', 1), (2, 'Free Parking & Taxi on Call', '1626605054.png', '1627737487.jpg', '<p>We have free parking space for our guests and also provide taxi on call service.</p>\r\n', '2021-07-31 06:48:07pm', 'admin', 1), (3, 'Free WIFI', '1626605031.png', '1627362119.jpg', '<p>BSNL fiber line installed with the 50 Mbps speed that is absolutely free for the guest.</p>\r\n', '2021-07-30 04:21:05pm', 'admin', 1), (4, 'Trekking & Sight-seeing', '1626605084.png', '1627722302.jpeg', '<p>Trekking and sightseeing facility can be organized as per the guest request.</p>\r\n', '2021-07-31 02:35:02pm', 'admin', 1); -- -------------------------------------------------------- -- -- Table structure for table `sh_services` -- CREATE TABLE `sh_services` ( `id` int(11) NOT NULL, `services` text NOT NULL, `update_date_time` varchar(255) NOT NULL, `update_admin_user` varchar(255) NOT NULL, `status` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `sh_services` -- INSERT INTO `sh_services` (`id`, `services`, `update_date_time`, `update_admin_user`, `status`) VALUES (3, 'Double Bed', '2021-07-17 08:17:13am', 'admin', 1), (4, 'Free Wi-Fi', '2021-07-17 08:17:23am', 'admin', 1), (5, 'Flat Screen Tv', '2021-07-17 08:17:31am', 'admin', 1), (6, '80 Sq mt', '2021-07-17 08:17:41am', 'admin', 1), (7, 'Breakfast Include', '2021-07-17 08:17:50am', 'admin', 1), (8, 'Full Ac', '2021-07-17 08:17:58am', 'admin', 1), (9, 'Private Balcony', '2021-07-17 08:18:11am', 'admin', 1), (10, 'Room Service', '2021-07-17 08:18:20am', 'admin', 1), (11, 'Pet friendly', '2021-08-02 04:48:55pm', 'admin', 1); -- -------------------------------------------------------- -- -- Table structure for table `sh_testimonial` -- CREATE TABLE `sh_testimonial` ( `id` int(11) NOT NULL, `name` varchar(255) NOT NULL, `rating` varchar(255) NOT NULL, `location` varchar(255) NOT NULL, `img` varchar(255) NOT NULL, `description` text NOT NULL, `displayorder` int(11) NOT NULL, `update_date_time` varchar(255) NOT NULL, `update_admin_user` varchar(255) NOT NULL, `status` int(11) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `sh_testimonial` -- INSERT INTO `sh_testimonial` (`id`, `name`, `rating`, `location`, `img`, `description`, `displayorder`, `update_date_time`, `update_admin_user`, `status`) VALUES (3, 'NISHA YADAV', '5', 'HARYANA', '1675860768.jpeg', 'If you are the person who loves natural beauty , peace , silence and fresh air then this is the right place to visit . I am just in love with this place. Everything was perfect according to me. Wonderful place to spend time with your loved ones \r\n', 0, '2023-02-08 12:52:48pm', 'admin', 1), (4, 'Associate Professor. Nand Lal', '5', 'HIMACHAL PRADESH', '1675860208.jpeg', 'View is awesome one of the best places I have visited and in manali best view is from this hotel.\r\n.', 0, '2023-02-14 07:44:46am', 'admin', 1); -- -------------------------------------------------------- -- -- Table structure for table `sh_video` -- CREATE TABLE `sh_video` ( `id` int(11) NOT NULL, `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `link` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `img` text COLLATE utf8_unicode_ci NOT NULL, `displayorder` int(11) NOT NULL, `update_date_time` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `status` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `sh_video` -- INSERT INTO `sh_video` (`id`, `title`, `link`, `img`, `displayorder`, `update_date_time`, `status`) VALUES (2, 'Snow crest residency ', '', 'VID-20230123-WA0008.mp4', 0, '2023-02-08 12:20:11pm', 1), (3, 'Balcony view - Hotel Snow Crest residency Manali', 'https://youtu.be/C6NQshe1nTU', '', 0, '2023-03-14 09:00:57am', 1); -- -- Indexes for dumped tables -- -- -- Indexes for table `admin_login` -- ALTER TABLE `admin_login` ADD PRIMARY KEY (`id`); -- -- Indexes for table `sh_about` -- ALTER TABLE `sh_about` ADD PRIMARY KEY (`id`); -- -- Indexes for table `sh_activity` -- ALTER TABLE `sh_activity` ADD PRIMARY KEY (`id`); -- -- Indexes for table `sh_amenities` -- ALTER TABLE `sh_amenities` ADD PRIMARY KEY (`id`); -- -- Indexes for table `sh_attraction` -- ALTER TABLE `sh_attraction` ADD PRIMARY KEY (`id`); -- -- Indexes for table `sh_banner_slider` -- ALTER TABLE `sh_banner_slider` ADD PRIMARY KEY (`id`); -- -- Indexes for table `sh_booking` -- ALTER TABLE `sh_booking` ADD PRIMARY KEY (`id`); -- -- Indexes for table `sh_contact_enquiry` -- ALTER TABLE `sh_contact_enquiry` ADD PRIMARY KEY (`id`); -- -- Indexes for table `sh_gallery` -- ALTER TABLE `sh_gallery` ADD PRIMARY KEY (`id`); -- -- Indexes for table `sh_room` -- ALTER TABLE `sh_room` ADD PRIMARY KEY (`id`); -- -- Indexes for table `sh_room_images` -- ALTER TABLE `sh_room_images` ADD PRIMARY KEY (`id`); -- -- Indexes for table `sh_service` -- ALTER TABLE `sh_service` ADD PRIMARY KEY (`id`); -- -- Indexes for table `sh_services` -- ALTER TABLE `sh_services` ADD PRIMARY KEY (`id`); -- -- Indexes for table `sh_testimonial` -- ALTER TABLE `sh_testimonial` ADD PRIMARY KEY (`id`); -- -- Indexes for table `sh_video` -- ALTER TABLE `sh_video` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `admin_login` -- ALTER TABLE `admin_login` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `sh_about` -- ALTER TABLE `sh_about` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `sh_activity` -- ALTER TABLE `sh_activity` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9; -- -- AUTO_INCREMENT for table `sh_amenities` -- ALTER TABLE `sh_amenities` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `sh_attraction` -- ALTER TABLE `sh_attraction` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14; -- -- AUTO_INCREMENT for table `sh_banner_slider` -- ALTER TABLE `sh_banner_slider` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17; -- -- AUTO_INCREMENT for table `sh_booking` -- ALTER TABLE `sh_booking` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `sh_contact_enquiry` -- ALTER TABLE `sh_contact_enquiry` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `sh_gallery` -- ALTER TABLE `sh_gallery` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; -- -- AUTO_INCREMENT for table `sh_room` -- ALTER TABLE `sh_room` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT for table `sh_room_images` -- ALTER TABLE `sh_room_images` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33; -- -- AUTO_INCREMENT for table `sh_service` -- ALTER TABLE `sh_service` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `sh_services` -- ALTER TABLE `sh_services` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12; -- -- AUTO_INCREMENT for table `sh_testimonial` -- ALTER TABLE `sh_testimonial` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `sh_video` -- ALTER TABLE `sh_video` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;