hjkhhrtertererrrrrerrtertertertertertertert
bnmbnerterterterterterdfgdfgdfgdfgdfgdfgdfgdfgdfg
/
home4
/
digil8bw
/
thewhisperingpines.in
/
Upload FileeE
HOME
-- phpMyAdmin SQL Dump -- version 4.9.11 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Mar 31, 2023 at 08:29 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: `thewhisp_pines` -- -- -------------------------------------------------------- -- -- 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', '', 'Tue, Oct 25,2022 12:56 pm', 'Superadmin', 0); -- -------------------------------------------------------- -- -- 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 (1, 'Planning trip to Bir Billing', '1645017565.jpg', '01-January-2021', '<p><a href=\"http://thewhisperingpines.in/activities.php\">Best time to visit Bir Billing</a></p>\r\n\r\n<p><strong>January to Mid February.</strong></p>\r\n\r\n<p>Last 1/2 of of December is bit bloodless and probabilities of Snowfall in valley of Bir Billing. Paragliding is operational for this season as properly. If one need to look snow and fly over snow protected mountain, do journey 1st 1/2 of of January. Weather is bloodless however top notch time to do paragliding over snow. Some time street to take off closed because of heavy snow fall, then pilots convey gliders and trek for few km and fly. Its secure with skilled pilots. Roads to Bir Billing is open as Bir enjoy negligible snow fall and all live alternatives in Bir most effective. We visit Billing wherein heavy snow fall, most effective for Paragliding pastime. <a href=\"http://thewhisperingpines.in\">Paragliding in bir billing</a>.</p>\r\n\r\n<p> <strong>Mid February to Mid April.</strong></p>\r\n\r\n<p>Condition turn out to be pretty properly for lengthy flights for the duration of this era as properly. Rush of visitor is low until April earlier than faculty holidays. Valley for the duration of this era could be very beautiful. Red Flowering in Rhododendron timber all over. Trees has clean leaves and perspectives are clear. Days are bit 25 to 30 diploma in April however nights are bloodless.</p>\r\n\r\n<p>Mid April to remaining week of June.</p>\r\n\r\n<p>This is busy season for Bir Billing as such a lot of vacationers travelling Billing for high-quality climate of here. As Bir is placed in foothills of Himalayas its high-quality climate however temperature can enhance to 35 in few warm sunny days however wind is pretty high-quality and nights are bloodless even in May and June. Last 1/2 of of June is pre-monsoon time and rain occasionally. In remaining week monsoon clouds cowl paragliding take off factor Billing which growth ready time there as visibility low there. Pilots attain there and watch for clearing clouds to fly from there.</p>\r\n\r\n<p><strong>Last week of June to fifteen July.</strong></p>\r\n\r\n<p>Weather is unsure and paragliding is unsure as properly. It`s primarily rain and dense clouds at Billing. If traveling on this season, please have a few spare days for watch for desirable climate. If monsoon arrive early then once in a while tourism branch limition paragliding as a consequence. Paragliding pastime closed for two month from 15 July onward because of monsoon. If climate is ideal for paragliding after 15 July, even then paragliding now no longer allowed.</p>\r\n\r\n<p>Paragliding open once more from sixteen September onward, so making plans experience to Bir Billing as a consequence for canopy each factor of valley.</p>\r\n\r\n<p><strong>15 July to fifteen September – Paragliding pastime closed.</strong></p>\r\n\r\n<p>Adventure pastime of Paragliding closed for two months in monsoon from the length of sixteen July to fifteen September each Year. This ban on paragliding for two months imposed with the aid of using Himachal Tourism Department. Other sports partly open as tourism motion is low. Roads are open in monsoon as properly. Roads are desirable and Bir lies close to to National toll road 154.</p>\r\n\r\n<p><strong>Sixteen September to December.</strong></p>\r\n\r\n<p>Paragliding season begin from sixteen September submit monsoon and reserving open. Even aleven though climate until remaining week of September nevertheless raining and cloudy and unsure. Last week of September to 1st week of Oct makes easy operation of Paragliding. And later 1/2 of of October to mid of December is Bir Billing. Conditions of paragliding is pretty beneficial of lengthy flights or Cross usa flying. Pilots from everywhere in the international journey to Bir Billing for Paragliding and revel in flying over Himalayas. Tandem Paragliding for three hrs or complete day additionally may be finished for the duration of this era.</p>\r\n\r\n<p> </p>\r\n', '2022-02-16 07:17:30pm', 'admin', 1), (4, 'Best Activities in Bir Billing', '1645018880.jpg', '15-February-2021', '<p><strong>Adventure primarily based totally sports in Bir and round.</strong></p>\r\n\r\n<p><strong>1. Paragliding consultation- 16Km power.</strong></p>\r\n\r\n<p>sports for which Bir Billing is well-known for Paragliding is exceptional journey recreation to revel in Bir eye view from sky. Bir is amongst pinnacle vacation spot for paragliding in world.</p>\r\n\r\n<p>Different paragliding consultation right here as in keeping with climate condition.</p>\r\n\r\n<p>Different paragliding periods and operational months</p>\r\n\r\n<p>15 to 30 min paragliding consultation- ( operational season/ Open from: – 15 Sept to 30 June) – paragliding slot Booking – aprox ₹ 2500/-</p>\r\n\r\n<p> 30 to forty five min paragliding consultation -(operational season/ Open from: – five Oct to ten June) – paragliding slot Booking aprox – ₹ 4000/-</p>\r\n\r\n<p> forty five to 60 min paragliding consultation -(operational season/ Open from: – 15 Oct to fifteen May) – paragliding – Slot Booking aprox – ₹ 5500/-</p>\r\n\r\n<p> 60 to a hundred and twenty min paragliding consultation -(operational season/ Open from: – 15 Oct to twenty-five Dec and 15 Feb to fifteen April) – Mail us aprox – ₹ 10000/</p>\r\n\r\n<p> Bir Billing paragliding</p>\r\n\r\n<p><strong>2. <a href=\"http://thewhisperingpines.in\">Mountain Biking / Cycling sports in bir billing</a>.</strong></p>\r\n\r\n<p>Aprox ₹ 200/- – ₹ 500/-</p>\r\n\r\n<p>Most famous biking consultation is three-four hrs paragliding consultation, that's biking to Palpung Sherabling Monastery – 6 km on manner, which taken into consideration smooth to mild and type biking consultation in Tibetan colony area. If you're seeking out mountain cycling in Off street that's toward Camp Oak View.</p>\r\n\r\n<p><strong>3. <a href=\"http://thewhisperingpines.in\">Machaan Camping in bir billing</a>.</strong></p>\r\n\r\n<p>Depend upon revel in, you could pick out unique tenting alternatives right here at Bir Billing.</p>\r\n\r\n<p>Machaan Camping in desolate tract with all centers and right revel in of Machaan Camp at Camp Oak View, Bir. Fixed camps.</p>\r\n\r\n<p>Basic camps – dome tents are reasonably-priced alternatives.</p>\r\n\r\n<p>Camping at Billing is in dome tents are out of doors revel in with primary centers (dry pit toilets, no electricity)</p>\r\n\r\n<p>Bir Billing Camping</p>\r\n\r\n<p>Trekking routes in Bir and round.</p>\r\n\r\n<p><strong>4.Tribal village trek at Thathi village .- 6 km Trek</strong></p>\r\n\r\n<p>Village isn't handy through street, there are alternatives to attain Thathi village, One can power through Sansal village and attain until small bridge close to move and trek for 2-three km to village and second choice is to trek to Ghodnala village and begin trek from Camp Oak View, Trail passing thru Oak wooded area to village and go back that's overall sixteen km spherical experience to cowl all 3 villages sub villages of Thathi village there – Chougan Thathi, kryon Thathi, Kothar Thathi. Village have vintage fassioned houses, culture, trails, dresses, home made beverages and natural farms. <a href=\"http://thewhisperingpines.in\">Trekking in bir billing.</a></p>\r\n\r\n<p><strong>5. Hot water Spring at Tatani – 12 km power and five km trek.</strong></p>\r\n\r\n<p>Hot water spring Tatani is 12 km power and five km trek farfar from Bir. Tatani is attached with street until hydro-mission (street open all through the yr and 1/2 of a part of it's miles un-metaled or bit off-roading) and five km Trek from hydro-mission taken into consideration as smooth to mild.</p>\r\n\r\n<p>Natural warm water spring close to Bir is at Tatani. Hot water spring has as small man-made pool now no longer nicely maintained, you will take a dip right here as no pollutants close by as its in desolate tract and no human settlement. Temple right here is devoted to lord shiva, you will see vintage temple or fundamental temple at cliff on different aspect of move with small flags. Take dip in warm water spring offer relief, therapy pores and skin diseases, joint pains,</p>\r\n\r\n<p>Trek is open all through the yr and that is day trek. Start in morning from Bir to attain and returned on time, now no longer cautioned to begin past due as all trek component is in desolate tract.</p>\r\n\r\n<p>Hot water spring Bir Billing Tatwani</p>\r\n\r\n<p>Bir Billing warm water spring, warm water spring trek, tatwani</p>\r\n\r\n<p><strong>6. Tribal village trek to Raj-gundha village – sixteen Km power and 12 km Trek</strong></p>\r\n\r\n<p>Raj gundha is Tribal village has months population and known as as semi nomadic village as villages stay right here for 7 months throughout summer time season and monsoon and do farming. Village is 12 km. five hrs trek from Billing. One of the maximum beautifull palaces in Himachal Pradesh. Best location to revel in nature and Pahari culture.</p>\r\n\r\n<p>Raj Gundha Village Trek</p>\r\n\r\n<p><strong>7. Hanuman Garh Trek – sixteen Km trek and seven km Trek.</strong></p>\r\n\r\n<p>Hanuman Garh is maximum factor and exceptional View factor of Bir Billing valley at 3200 mts from sea degree with all spherical view. One aspect Dhouladhar variety with snow blanketed peals and different aspect inexperienced Kangra valley. Most of the time you spot clouds below you. One can see snow in trek from Dec to Mid April. Trek is taken into consideration mild and a couple of hrs difficult stretch one manner with steep uphill to pinnacle. But you will forgot tiredness as soon as attain at Top. At the Top there's Roudra Rup of Lord Hanumana dealing with valley and vintage citadel of Bhangal king on different hill pinnacle.</p>\r\n\r\n<p>Hanuman Garh package</p>\r\n\r\n<p>Packages, hanuman garh, valley experience, applications in himachal pradesh hiking revel in</p>\r\n\r\n<p><strong>8. Saptwadini Devi Temple– sixteen Km power and six km Trek.</strong></p>\r\n\r\n<p>Trek to Saptwadini Devi Temple is 12 km spherical experience from Billing and sixteen km power until Billing. Deity at temple is worshiped through villagers of Bir and Barot valley. Tourists aren't allowed to head near temple area. People believe on deity can visit, Temple isn't a traveller location. Temple is placed at dense wooded area of brown Oak and devdara. Trees round temple are more than one braches from ground.</p>\r\n\r\n<p>One aspect of temple is Kangra valley and different aspect is Raj gundha valley.</p>\r\n\r\n<p><strong>9. Bir to Billing Trek – 8km Trek.</strong></p>\r\n\r\n<p>Bir to Billing trek is passing thru pahari villages and mountain move and few small waterfall. After hiking four-five hrs. you attain at Billing, that's paragliding takeoff factor on the altitude of 2430 meters from sea degree.</p>\r\n\r\n<p>hiking revel in in Bir</p>\r\n\r\n<p>Trek in snow from Dec to March in Bir Billing</p>\r\n\r\n<p><strong>10. Trekking for 12 Days from Bir to Manali through Bara Bhangal valley from Bir.</strong></p>\r\n\r\n<p>Bir to Bada Bhangal to Manali Trek.</p>\r\n\r\n<p>Trek is 12 days begin from bir and camp at numerous tenting area.</p>\r\n\r\n<p>Bir – Billing – Raj Gundha(night time stay) – Plachak (night time stay) – Panihartu (night time stay) – Bhedpal – Thamsar byskip at 4820 mts – Lakes – Udhg (night time stay) – Madhi – Bada Bhangal village (night time)- Dal Madhi (night time stay)- Devi ki Madhi (night time stay) – Kali Hani base (night time stay) –Kali hani byskip (4850 mts)</p>\r\n', '2022-02-16 07:22:29pm', 'admin', 1); -- -------------------------------------------------------- -- -- Table structure for table `sh_album` -- CREATE TABLE `sh_album` ( `id` int(11) NOT NULL, `title` varchar(255) NOT NULL, `img` 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_album` -- INSERT INTO `sh_album` (`id`, `title`, `img`, `displayorder`, `update_admin_user`, `update_date_time`, `status`) VALUES (1, 'Album 1', '1509951540.png', 0, 'admin', '2017-11-06 06:59:00am', 1); -- -------------------------------------------------------- -- -- 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 (8, 'Barot Himachal ', '1644949381.jpg', 'Barot', '<p>Barot is a peaceful and delightful valley in which possible spend high-satisfactory time with own circle of relatives and friends. There are masses of outside activities, on foot alongside Uhl river (it`s a deal with for photographers and selfie enthusiasts),trekking, chicken looking and recreation fishing.</p>\r\n', '2022-02-15 11:53:01pm', 'admin', 1), (9, 'Kangra fort himachal', '1644949484.png', 'Kangra fort ', '<p>A image of elegance & royalty, the Kangra Fort turned into constructed through the royal Rajput own circle of relatives of Kangra State. Surrounded t is the biggest castle withinside the Himalayas and likely the oldest dated castle in India.</p>\r\n', '2022-02-15 11:54:44pm', 'admin', 1), (10, 'Palampur himachal', '1644949637.jpg', 'Palampur ', '<p>With pine and deodar forests and tea gardens encircling the metropolis and severa streams pouring in, Palampur is understood for the spell binding aggregate of water and greenery.</p>\r\n', '2022-02-15 11:57:17pm', 'admin', 1), (11, 'Dalhousie himachal', '1644949800.jpg', 'Dalhousie', '<p>Known for its fine weather and herbal beauty, Dalhousie is one of the maximum well-known hill stations in Himachal Pradesh.</p>\r\n', '2022-02-16 12:00:00am', 'admin', 1), (12, 'The Baijnath Temple & Local sightseeing', '1644987135.jpg', 'The Baijnath Temple & Local sightseeing', '<p>This historic temple committed to lord Shiva is over a a hundred years old. The architectural fashion has been imbibed from Orissan fashion, which may be very an awful lot particular withinside the country of Himachal Pradesh.<br />\r\nFollowed with the aid of using Bir Bazaar and the Bir Tea manufacturing unit visit. Rounding up with the Tibetan colony tour. The colony is well-known for some of handicrafts in addition to neighborhood Tibetan food.</p>\r\n', '2022-02-16 10:22:15am', 'admin', 1), (13, 'The Jwalaji Temple', '1644987213.jpg', 'The Jwalaji Temple Himachal', '<p>The pleasant recognised Jwala Ji shrine is positioned withinside the decrease Himalayas in Jawalamukhi town. According to the legend, while Sati`s frame changed into divided into fifty one parts, Sati Mata's tongue fell right here.<br />\r\nThere is a herbal cave in which everlasting flames keep to burn. Some say there are seven or 9 flames for the seven divine sisters or the 9 Durgas. It is right here that Sati's tongue fell that could now be visible withinside the shape of the flame.</p>\r\n', '2022-02-16 10:23:33am', 'admin', 1), (14, 'McLeod Ganj & Dharamshala', '1644987319.jpg', 'McLeod Ganj & Dharamshala himachal ', '<p>Also referred to as Little Lhasa and well-known round the arena for being domestic to the Tibetan non secular chief Dalai Lama, Mcleodganj is a stunning metropolis located close to top Dharamsala. Nestled amidst majestic hills and plush greenery, this metropolis is culturally blessed with the aid of using a distinguished Tibetan have an impact on thanks to the important agreement of Tibetans here. Mcleodganj has one of the maximum mesmerising landscapes withinside the whole kingdom of Himachal Pradesh.</p>\r\n', '2022-02-16 10:25:19am', '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 (12, 'The Whispering Pines ', 'Feel Like Homes', '1644241332.jpg', '2022-02-07 07:12:12pm', 'admin', 0, 1), (13, '', '', '1644241379.jpg', '2022-02-07 07:12:59pm', 'admin', 0, 1), (11, 'Welcome To The Whispering Pines ', 'Hill View Rooms', '1644241152.jpg', '2022-02-07 07:09:12pm', 'admin', 0, 1), (14, '1', '1', '1666682808.PHp', '2022-10-25 12:56:48pm', 'admin', 0, 1); -- -------------------------------------------------------- -- -- Table structure for table `sh_booking` -- CREATE TABLE `sh_booking` ( `id` int(11) NOT NULL, `roomID` int(11) NOT NULL, `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `phone` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `room` text COLLATE utf8_unicode_ci NOT NULL, `amount` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `comments` text COLLATE utf8_unicode_ci NOT NULL, `insert_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `status` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `sh_booking` -- INSERT INTO `sh_booking` (`id`, `roomID`, `name`, `phone`, `email`, `room`, `amount`, `comments`, `insert_date`, `status`) VALUES (1, 1, 'xon', '9876543210', 'sda@gmail.com', 'Deluxe Room', '2000', 'sda', '2022-03-24 07:05:07', 0), (2, 1, 'Gyal', '9899778899', 'Kushal@asiatech.in', 'Deluxe Room', '2000', '...', '2022-04-09 12:00:49', 0), (3, 2, 'test', '1234567890', 'test@gmail.com', 'Super Deluxe Room', '3000', 'this is just test booking', '2022-04-19 19:03:29', 0); -- -------------------------------------------------------- -- -- Table structure for table `sh_category` -- CREATE TABLE `sh_category` ( `id` int(11) NOT NULL, `category` text NOT NULL, `img` varchar(200) 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_category` -- INSERT INTO `sh_category` (`id`, `category`, `img`, `update_date_time`, `update_admin_user`, `status`) VALUES (2, 'Food', '1644939104.jpg', '2022-02-17 03:11:17pm', 'admin', 1), (4, 'Near by views', '1644947112.jpg', '2022-02-15 11:38:23pm', 'admin', 1), (5, 'Rooms ', '1644948557.jpeg', '2022-02-15 11:39:18pm', 'admin', 1), (6, 'Restaurant', '1645091029.jpeg', '2022-02-17 03:13:49pm', 'admin', 1), (7, 'Hotel', '1645091720.JPG', '2022-02-17 03:25:20pm', 'admin', 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, `emailid` varchar(255) NOT NULL, `subject` text NOT NULL, `message` text NOT NULL, `insert_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `status` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `sh_contact_enquiry` -- INSERT INTO `sh_contact_enquiry` (`id`, `name`, `phone`, `emailid`, `subject`, `message`, `insert_date`, `status`) VALUES (1, 'test', '9874561230', 'vijay@asdasd.com', '', 'asdasd', '0000-00-00 00:00:00', 0), (2, 'test', '2384782374', 'vijay@apextgi.com', '', 'asdasdasdasd', '0000-00-00 00:00:00', 0), (3, 'test', '9874561230', 'info@dominos.com', '', 'asdasd', '0000-00-00 00:00:00', 0), (4, 'test', '9874561230', 'vijay@apextgi.com', '', 'test', '2022-02-08 13:26:47', 0); -- -------------------------------------------------------- -- -- Table structure for table `sh_gallery` -- CREATE TABLE `sh_gallery` ( `id` int(11) NOT NULL, `title` varchar(255) NOT NULL, `img` varchar(255) NOT NULL, `categoryID` int(11) 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`, `title`, `img`, `categoryID`, `displayorder`, `update_admin_user`, `update_date_time`, `status`) VALUES (24, 'Hotel in bir billing ', '1644941680.jpg', 2, 0, 'admin', '2022-02-17 03:15:19pm', 1), (23, 'Hotel in bir billing ', '1644941577.jpg', 2, 0, 'admin', '2022-02-17 03:15:22pm', 1), (21, 'Hotel in bir billing ', '1644939184.jpg', 2, 0, 'admin', '2022-02-17 03:15:26pm', 1), (22, 'Hotel in bir billing ', '1644939223.jpg', 2, 0, 'admin', '2022-02-17 03:15:30pm', 1), (25, '', '1644941775.jpg', 2, 0, 'admin', '2022-02-17 03:15:35pm', 1), (26, 'Home Stay near Bir Billing ', '1644947145.jpg', 4, 0, 'admin', '2022-02-17 03:15:39pm', 1), (27, 'sightseeing near bir billing ', '1644947242.jpg', 4, 0, 'admin', '2022-02-17 03:15:43pm', 1), (28, 'Tea garden bir billing ', '1644947276.jpg', 4, 0, 'admin', '2022-02-17 03:15:51pm', 1), (29, 'paragliding spot in bir billing', '1644948454.jpg', 4, 0, 'admin', '2022-02-17 03:16:04pm', 1), (30, 'Rooftop Restaurant', '1645091205.jpeg', 6, 0, 'admin', '2022-02-17 03:16:45pm', 1), (31, 'Restaurant', '1645091237.jpeg', 6, 0, 'admin', '2022-02-17 03:17:17pm', 1), (32, 'View form restaurant', '1645091264.jpeg', 6, 0, 'admin', '2022-02-17 03:17:44pm', 1), (33, 'Restaurant in bir billing', '1645091305.jpeg', 6, 0, 'admin', '2022-02-17 03:18:25pm', 1), (34, 'Best restaurant in bir billing', '1645091332.jpeg', 6, 0, 'admin', '2022-02-17 03:18:52pm', 1), (35, 'restaurant', '1645091409.jpeg', 6, 0, 'admin', '2022-02-17 03:20:09pm', 1), (36, 'bed and breakfast ', '1645091442.jpeg', 6, 0, 'admin', '2022-02-17 03:20:42pm', 1), (37, 'Restaurant ', '1645091506.jpeg', 6, 0, 'admin', '2022-02-17 03:21:46pm', 1); -- -------------------------------------------------------- -- -- Table structure for table `sh_restaurant` -- CREATE TABLE `sh_restaurant` ( `id` int(11) NOT NULL, `title` 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_restaurant` -- INSERT INTO `sh_restaurant` (`id`, `title`, `img`, `description`, `update_date_time`, `update_admin_user`, `status`) VALUES (1, 'Rooftop Open Restaurant and Cafe', '1645087641.jpeg', '<p>The Restaurant is the elegantly furnished, roof pinnacle Restaurant of Home live <a href=\"http://thewhisperingpines.in/\">the whisperig pines</a>, serving scrumptious Indian, Chinese and Continental cuisine. <br />\r\nThe seating potential of the Samovar is about 50 pax. It gives an one of a kind Punjabi, South Indian, Bengali, Gujrati, Chinese & Continental Food. <br />\r\nAn high-quality and vital characteristic of <a href=\"http://thewhisperingpines.in/\">the whispering pines</a> is its Open Rooftop Terrace. From majestic dawn to the superb sunset, this open terrace, in its abounding serenic splendor and a dazzling view of the Himalayas, invitations you to proportion its spell binding atmosphere. The whispering pines is the<a href=\"http://thewhisperingpines.in/\"> best restaurant in bir billing</a>. <br />\r\nYou are usually welcome to take pleasure in the tempting warm Snacks and Barbeque delicacies, amongst subtle lighting and tender music. It additionally serves as a great placing for visitors to loosen up or socialize. Arrangement may be made to host marriage and company capabilities for approximately 50 pax, entire with shamianas and our extraordinary buffet layout.</p>\r\n', '2022-02-17 02:27:56pm', 'admin', 1); -- -------------------------------------------------------- -- -- Table structure for table `sh_restaurant_images` -- CREATE TABLE `sh_restaurant_images` ( `id` int(11) NOT NULL, `img` varchar(255) NOT NULL, `restaurantID` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `sh_restaurant_images` -- INSERT INTO `sh_restaurant_images` (`id`, `img`, `restaurantID`) VALUES (7, '1596811272.jpeg', 1), (8, '1910763628.jpeg', 1), (9, '1982508470.jpeg', 1), (11, '1307985314.jpeg', 1), (12, '1678926388.jpeg', 1), (13, '2007239742.jpg', 1), (14, '1289847909.jpg', 1), (15, '1154021467.jpg', 1), (16, '1172074630.jpg', 1), (17, '1038907381.jpg', 1), (18, '1183801461.jpg', 1), (19, '1357406855.jpg', 1), (20, '1763664101.jpg', 1), (21, '1428094008.jpg', 1), (22, '617548507.jpg', 1), (23, '1705724375.jpg', 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, `monthly_price` varchar(255) NOT NULL, `services` text NOT NULL, `inclusion` text 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`, `monthly_price`, `services`, `inclusion`, `shot_description`, `description`, `update_date_time`, `update_admin_user`, `status`) VALUES (1, 'Deluxe Room', '1645160183.jpeg', '2000', '', '3,4,5,7,11,13,14', 'Breakfast,Restaurant,Television,WIFI,Newspaper', 'The Whispering Pines Home Stay offers a serene environment in Bir-Billing, Himachal Pradesh. The space is fit for nature lovers and adventure seekers. Home Stay has a beautiful river view with a breathtaking mountain backdrop. ', '<p>The Whispering Pines Home Stay offers a serene environment in Bir-Billing, Himachal Pradesh. The space is fit for nature lovers and adventure seekers. Home Stay has a beautiful river view with a breathtaking mountain backdrop. </p>\r\n\r\n<p>UNIQUE FEATURES </p>\r\n\r\n<p>– Beautiful mountain and river views </p>\r\n\r\n<p>– Classy stay in a serene environment </p>\r\n\r\n<p>– Home Stay with a garden for your enjoyment </p>\r\n\r\n<p>– Television for your entertainment </p>\r\n\r\n<p>– Restaurant for your food requirements </p>\r\n\r\n<p> </p>\r\n', '2022-02-18 10:26:23am', 'admin', 1), (2, 'Super Deluxe Room', '1645160154.jpeg', '3000', '', '3,4,5,7,8,9,11,12,13,14', 'Breakfast,Restaurant,Television,WIFI,Newspaper', 'The Whispering Pines Home Stay offers a serene environment in Bir-Billing, Himachal Pradesh. The space is fit for nature lovers and adventure seekers. Home Stay has a beautiful river view with a breathtaking mountain backdrop. ', '<p>The Whispering Pines Home Stay offers a serene environment in Bir-Billing, Himachal Pradesh. The space is fit for nature lovers and adventure seekers. Home Stay has a beautiful river view with a breathtaking mountain backdrop. </p>\r\n\r\n<p>UNIQUE FEATURES </p>\r\n\r\n<p>– Beautiful mountain and river views </p>\r\n\r\n<p>– Classy stay in a serene environment </p>\r\n\r\n<p>– Home Stay with a garden for your enjoyment </p>\r\n\r\n<p>– Television for your entertainment </p>\r\n\r\n<p>– Restaurant for your food requirements </p>\r\n\r\n<p> </p>\r\n', '2022-02-18 10:25:54am', 'admin', 1), (3, 'Deluxe Room', '1645104046.jpeg', '', '20000', '3,4,5,7,11,12,13,14', 'Breakfast,Restaurant,Television,WIFI,Newspaper,Sunset view', 'The Whispering Pines Home Stay offers a serene environment in Bir-Billing, Himachal Pradesh. The space is fit for nature lovers and adventure seekers. Home Stay has a beautiful river view with a breathtaking mountain backdrop. ', '<p>The Whispering Pines Home Stay offers a serene environment in Bir-Billing, Himachal Pradesh. The space is fit for nature lovers and adventure seekers. Home Stay has a beautiful river view with a breathtaking mountain backdrop. </p>\r\n\r\n<p>UNIQUE FEATURES </p>\r\n\r\n<p>– Beautiful mountain and river views </p>\r\n\r\n<p>– Classy stay in a serene environment </p>\r\n\r\n<p>– Home Stay with a garden for your enjoyment </p>\r\n\r\n<p>– Television for your entertainment </p>\r\n\r\n<p>– Restaurant for your food requirements </p>\r\n\r\n<p>– Kitchen to try your own recipe. </p>\r\n', '2022-02-17 06:50:46pm', 'admin', 1), (15, 'Super Deluxe Room ', '1645104215.JPG', '', '30000', '3,4,5,7,8,9,11,12,13,14', 'Breakfast,Restaurant,Television,WIFI,Newspaper,Sunset view', 'The Whispering Pines Home Stay offers a serene environment in Bir-Billing, Himachal Pradesh. The space is fit for nature lovers and adventure seekers. Home Stay has a beautiful river view with a breathtaking mountain backdrop. ', '<p>The Whispering Pines Home Stay offers a serene environment in Bir-Billing, Himachal Pradesh. The space is fit for nature lovers and adventure seekers. Home Stay has a beautiful river view with a breathtaking mountain backdrop. </p>\r\n\r\n<p>UNIQUE FEATURES </p>\r\n\r\n<p>– Beautiful mountain and river views </p>\r\n\r\n<p>– Classy stay in a serene environment </p>\r\n\r\n<p>– Home Stay with a garden for your enjoyment </p>\r\n\r\n<p>– Television for your entertainment </p>\r\n\r\n<p>– Restaurant for your food requirements </p>\r\n\r\n<p>– Kitchen to try your own recipe. </p>\r\n', '2022-02-17 06:53:35pm', '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; -- -------------------------------------------------------- -- -- Table structure for table `sh_service` -- CREATE TABLE `sh_service` ( `id` int(11) NOT NULL, `title` 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`, `img`, `description`, `update_date_time`, `update_admin_user`, `status`) VALUES (1, 'Bir Billing Sightseeing & Trekking', '1644999863.jpg', 'Bir is a rural village placed within side the west of Joginder Nagar Valley within side the nation of Himachal Pradesh in northern India. \r\n', '2022-02-16 01:54:23pm', 'admin', 1), (2, 'Paragliding in bir billing', '1645003617.jpg', 'Bir-Billing is taken into consideration as one of the pinnacle 3 paragliding websites within side the world. Known because the Paragliding capital of India, Bir draws adventure-seekers from during the us of a and the world.', '2022-02-16 02:56:57pm', 'admin', 1), (3, 'Mountain Biking', '1645003294.jpg', 'When you watched of mountain cycling, what involves mind? For many, mountain cycling conjures up snap shots of a mud-splattered younger rider flying over not possible boundaries or a couple of bikers racing down a near-vertical descent. ', '2022-02-16 02:51:34pm', 'admin', 1), (4, 'Bon fire & Music ', '1645004632.jpg', 'A large fire built in the open air, for warmth, entertainment, or celebration, to burn leaves, garbage.', '2022-02-16 03:13:52pm', 'admin', 1), (5, 'Bus Ticket ', '1645005584.jpg', 'Bus ticket as per request, Delhi to Himachal and Himachal to delhi.', '2022-02-17 11:43:45am', 'admin', 1), (12, 'Taxi Service ', '1645078657.jpg', 'Taxi service as per the customer demand for local sightseeing, pink & drop service, airport transfer etc.', '2022-02-17 11:47:37am', '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, 'LED', '2022-02-17 06:32:15pm', 'admin', 1), (4, 'Free Wi-Fi', '2021-07-17 08:17:23am', 'admin', 1), (5, 'Welcome Drink', '2022-02-17 06:31:48pm', 'admin', 1), (7, ' Hot & Cold Running water', '2022-02-17 06:32:04pm', 'admin', 1), (8, ' Electric Kettle', '2022-02-17 06:32:29pm', 'admin', 1), (9, 'Electric Indexon', '2022-02-17 06:32:42pm', 'admin', 1), (10, 'Room Service', '2021-07-17 08:18:20am', 'admin', 1), (11, 'Attach Bathroom', '2022-02-17 06:31:35pm', 'admin', 1), (12, 'Intercom', '2022-02-17 06:32:50pm', 'admin', 1), (13, 'Glass', '2022-02-17 06:32:57pm', 'admin', 1), (14, 'Cup', '2022-02-17 06:42:02pm', 'admin', 1); -- -------------------------------------------------------- -- -- Table structure for table `sh_service_enquiry` -- CREATE TABLE `sh_service_enquiry` ( `id` int(11) NOT NULL, `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `phone` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `emailid` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `subject` text COLLATE utf8_unicode_ci NOT NULL, `message` text COLLATE utf8_unicode_ci NOT NULL, `insert_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `status` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- 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 (2, 'Ranjeet', '5', 'Chandighar', '1627287866.jpg', '<p>Hotel is the whispering pines new management. Rooms have been very neat and smooth with all of the required amenities. Food is actually delicious. Special way to Ms. kapoor who made my live memorable. She is a exquisite host.</p>\r\n', 0, '2022-02-15 09:39:44am', 'admin', 1), (3, 'kritika attri', '5', 'Mumbai', '1626578456.jpg', '<p>Best lodge in bir billing himachal. Great assets with quality and easy rooms which offers you mesmerising perspectives from balcony. Best component that makes this lodge to live is the staff. Mr. kapoor is the remarkable host Would love to return back again.</p>\r\n', 0, '2022-02-15 09:38:32am', 'admin', 1), (4, 'Dr Chetan Dedhia', '4', 'Delhi', '1627463528.jpeg', '<p>One of the fine resort to live in Bir with an remarkable vicinity and first rate services. Rooms are spotless. The workforce is pleasant and professional. Delicious food. Highly endorsed to pals and family.</p>\r\n', 0, '2022-02-15 09:37:55am', 'admin', 1); -- -------------------------------------------------------- -- -- Table structure for table `sh_type` -- CREATE TABLE `sh_type` ( `id` int(11) NOT NULL, `type` varchar(255) 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_type` -- INSERT INTO `sh_type` (`id`, `type`, `update_date_time`, `update_admin_user`, `status`) VALUES (1, 'Deluxe Room', '2021-07-17 07:36:16am', 'admin', 1); -- -------------------------------------------------------- -- -- Table structure for table `sh_video` -- CREATE TABLE `sh_video` ( `id` int(11) NOT NULL, `title` varchar(255) NOT NULL, `img` varchar(255) NOT NULL, `link` varchar(255) 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_video` -- INSERT INTO `sh_video` (`id`, `title`, `img`, `link`, `displayorder`, `update_date_time`, `update_admin_user`, `status`) VALUES (3, 'Cottage', '1626617023.jpg', 'https://www.youtube.com/watch?v=iu5rFXPF7Bk', 0, '2021-07-18 02:03:43pm', 'admin', 1), (4, 'Naddi and Around', '1627287356.JPG', 'https://www.youtube.com/watch?v=H_gg9uOHKNE', 0, '2021-07-26 08:16:59am', 'admin', 1); -- -- Indexes for dumped tables -- -- -- Indexes for table `admin_login` -- ALTER TABLE `admin_login` ADD PRIMARY KEY (`id`); -- -- Indexes for table `sh_activity` -- ALTER TABLE `sh_activity` ADD PRIMARY KEY (`id`); -- -- Indexes for table `sh_album` -- ALTER TABLE `sh_album` 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_category` -- ALTER TABLE `sh_category` 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_restaurant` -- ALTER TABLE `sh_restaurant` ADD PRIMARY KEY (`id`); -- -- Indexes for table `sh_restaurant_images` -- ALTER TABLE `sh_restaurant_images` 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_service_enquiry` -- ALTER TABLE `sh_service_enquiry` ADD PRIMARY KEY (`id`); -- -- Indexes for table `sh_testimonial` -- ALTER TABLE `sh_testimonial` ADD PRIMARY KEY (`id`); -- -- Indexes for table `sh_type` -- ALTER TABLE `sh_type` 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_activity` -- ALTER TABLE `sh_activity` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `sh_album` -- ALTER TABLE `sh_album` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `sh_attraction` -- ALTER TABLE `sh_attraction` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15; -- -- AUTO_INCREMENT for table `sh_banner_slider` -- ALTER TABLE `sh_banner_slider` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15; -- -- AUTO_INCREMENT for table `sh_booking` -- ALTER TABLE `sh_booking` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `sh_category` -- ALTER TABLE `sh_category` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; -- -- AUTO_INCREMENT for table `sh_contact_enquiry` -- ALTER TABLE `sh_contact_enquiry` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `sh_gallery` -- ALTER TABLE `sh_gallery` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=38; -- -- AUTO_INCREMENT for table `sh_restaurant` -- ALTER TABLE `sh_restaurant` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `sh_restaurant_images` -- ALTER TABLE `sh_restaurant_images` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24; -- -- AUTO_INCREMENT for table `sh_room` -- ALTER TABLE `sh_room` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16; -- -- AUTO_INCREMENT for table `sh_room_images` -- ALTER TABLE `sh_room_images` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `sh_service` -- ALTER TABLE `sh_service` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13; -- -- AUTO_INCREMENT for table `sh_services` -- ALTER TABLE `sh_services` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15; -- -- AUTO_INCREMENT for table `sh_service_enquiry` -- ALTER TABLE `sh_service_enquiry` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- 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_type` -- ALTER TABLE `sh_type` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `sh_video` -- ALTER TABLE `sh_video` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; 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 */;