hjkhhrtertererrrrrerrtertertertertertertert

-- phpMyAdmin SQL Dump -- version 4.9.11 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Mar 31, 2023 at 08:39 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: `crestsn0_snow` -- -- -------------------------------------------------------- -- -- Table structure for table `accommodation` -- CREATE TABLE `accommodation` ( `id` int(255) NOT NULL, `name` varchar(255) NOT NULL, `short_description` text NOT NULL, `description` text NOT NULL, `img` varchar(255) NOT NULL, `room` int(255) NOT NULL, `breakfast` int(255) NOT NULL, `dinner` int(255) NOT NULL, `withoutbreakfast` int(255) NOT NULL, `includingdinner` int(255) NOT NULL, `bed` int(255) NOT NULL, `insert_date_time` varchar(255) NOT NULL, `status` int(255) NOT NULL, `cpbreakfast` int(255) NOT NULL, `includingdinners` int(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `accommodation` -- INSERT INTO `accommodation` (`id`, `name`, `short_description`, `description`, `img`, `room`, `breakfast`, `dinner`, `withoutbreakfast`, `includingdinner`, `bed`, `insert_date_time`, `status`, `cpbreakfast`, `includingdinners`) VALUES (1, 'Super Deluxe Room with Mountain View', '<p>The Super Deluxe Room is very spacious and exudes an ambience of tranquility.furnished.The Super Deluxe Room is very spacious and exudes an ambience of tranquility. What&#39;s more, the exquisite range of in-room comforts will make for a truly memorable stay. We don&#39;t just call it &#39;superior&#39; for the sake of it. The new Super Deluxe room is set up with a luxurious decor inspired by the combination of Balinese traditional architecture and modern conveniences. Step into the room and feel the graceful environment, secure and yet comfortably furnished.</p>\r\n\r\n<p>We have fiber wife with 100 Mbps speed.</p>\r\n', '', '1652416668.IMG_20220416_180614 - Copy.jpg', 0, 0, 3500, 0, 0, 0, '2022-05-13 10:09:33am', 1, 0, 0), (6, 'Super Deluxe Room with Mountain View', '<p>The Super Deluxe Room is very spacious and exudes an ambience of tranquility.furnished .the super deluxe room is very spacious and exudes an ambience of tranquility. what is more.the exquisite range of in-room comforts will make for truly memorable stay.we don&#39;t juest call it superior for the sake of it.The new Super Deluxe Room is set up with a luxurious decor inspired by the combination of Balinese traditional architecture and modern conveniences. step into the room and feel the graceful environment, secure and yet comfortably furnished.</p>\r\n\r\n<p>We have fiber wife with 100Mbps speed</p>\r\n', '', '1642252293.Cheap hotels in naddi.jpg', 0, 0, 0, 0, 300, 0, '2022-05-13 09:59:44am', 1, 0, 0), (7, 'Deluxe Room Road Side View', '<p>Deluxe room on the second floor with a road side balcony these rooms are recommended for maximum of 3 guests canbe accommodated in the room with on extra bed these room are equippid with hot and cold and electric kettle</p>\r\n\r\n<p>we have fiber wife with 100 Mbps speed<br />\r\n&nbsp;</p>\r\n', '', '1637395389.deluxe room 12.jpg', 0, 0, 0, 0, 0, 0, '2022-05-13 09:59:20am', 1, 0, 0), (8, 'Deluxe Room Road Side View', '<p>Deluxe room on the second floor with a road side balcony these rooms are recommended for maximum of 3 guests can be accommodated in the room with on extra bed these room are equipped with hot and cold and electric kettle</p>\r\n\r\n<p>we have fiber wife with 100 Mbps speed</p>\r\n', '', '1652416557.20220501_172903.jpg', 0, 0, 0, 0, 0, 0, '2022-05-13 10:09:14am', 1, 0, 0); -- -------------------------------------------------------- -- -- 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, 'Snowcrest1', 'Manju@12345', '', 'Mon, Mar 06,2023 3:19 pm', 'Superadmin', 0); -- -------------------------------------------------------- -- -- Table structure for table `banner_slider` -- CREATE TABLE `banner_slider` ( `id` int(255) NOT NULL, `img` varchar(255) NOT NULL, `update_date_time` varchar(255) NOT NULL, `status` int(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `banner_slider` -- INSERT INTO `banner_slider` (`id`, `img`, `update_date_time`, `status`) VALUES (1, '1642248043.jpg', '2022-01-15 12:00:43pm', 1), (37, '1665499957.jpg', '2022-10-11 02:52:37pm', 1), (47, '1653106129.jpg', '2022-05-21 04:08:49am', 1), (48, '1665500065.jpg', '2022-10-11 02:54:25pm', 1), (49, '1653106286.jpg', '2022-05-21 04:11:26am', 1), (51, '1658295549.jpg', '2022-07-20 05:39:09am', 1), (52, '1665500106.jpg', '2022-10-11 02:55:06pm', 1), (53, '1665499998.jpg', '2022-10-11 02:53:18pm', 1); -- -------------------------------------------------------- -- -- Table structure for table `gallery` -- CREATE TABLE `gallery` ( `id` int(255) NOT NULL, `img` varchar(255) COLLATE utf8_unicode_ci 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 `gallery` -- INSERT INTO `gallery` (`id`, `img`, `update_date_time`, `status`) VALUES (17, '1636863518.jpg', '2021-11-14 04:18:38am', 1), (18, '1636863463.jpg', '2021-11-14 04:17:43am', 1), (19, '1636863362.jpg', '2021-11-14 04:16:02am', 1), (21, '1636863246.jpg', '2021-11-14 04:14:06am', 1), (22, '1636863702.jpg', '2021-11-14 04:21:42am', 1), (23, '1608097922.jpg', '2020-12-16 05:52:02am', 1), (24, '1636863203.jpg', '2021-11-14 04:13:23am', 1), (25, '1608098865.jpg', '2020-12-16 06:07:45am', 1), (26, '1636863800.jpg', '2021-11-14 04:23:20am', 1), (27, '1608098977.jpeg', '2020-12-16 06:09:37am', 1), (28, '1636863845.jpg', '2021-11-14 04:24:05am', 1), (29, '1608099088.jpg', '2020-12-16 06:11:28am', 1), (30, '1608099150.jpg', '2020-12-16 06:12:30am', 1), (32, '1608099413.jpg', '2020-12-16 06:16:53am', 1), (38, '1625914238.jpeg', '2021-07-10 10:50:38am', 1), (40, '1636864036.jpg', '2021-11-14 04:27:16am', 1), (41, '1632334422.jpg', '2021-09-22 06:13:42pm', 1), (42, '1636864109.jpeg', '2021-11-14 04:28:29am', 1), (43, '1671341630.php', '2022-12-18 05:33:50am', 1), (44, '1669616110.jpeg', '2022-11-28 06:15:10am', 1), (45, '1669616121.jpeg', '2022-11-28 06:15:21am', 1), (46, '1671341599.php', '2022-12-18 05:33:19am', 1), (47, '1671370720.php', '2022-12-18 01:38:40pm', 1), (48, '1671775391.jpg', '2022-12-23 06:03:11am', 1), (50, '1678088174.html', '2023-03-06 07:36:14am', 1), (51, '1678088792.php', '2023-03-06 07:46:32am', 1); -- -------------------------------------------------------- -- -- Table structure for table `homegallery` -- CREATE TABLE `homegallery` ( `id` int(255) NOT NULL, `title` text COLLATE utf8_unicode_ci NOT NULL, `img` varchar(255) COLLATE utf8_unicode_ci 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 `homegallery` -- INSERT INTO `homegallery` (`id`, `title`, `img`, `update_date_time`, `status`) VALUES (1, 'Restaurant', '1608298220.jpg', '2020-12-19 01:13:28pm', 1), (5, 'Restaurant', '1608277488.jpg', '2020-12-18 01:58:09pm', 1), (7, 'Restaurant', '1608298396.jpg', '2020-12-18 01:33:16pm', 1), (8, 'Restaurant', '1608300594.webp', '2020-12-19 01:13:44pm', 1); -- -------------------------------------------------------- -- -- Table structure for table `offers` -- CREATE TABLE `offers` ( `id` int(255) NOT NULL, `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `description` text COLLATE utf8_unicode_ci NOT NULL, `img` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `offer_price` int(10) NOT NULL, `actual_price` int(10) NOT NULL, `update_date_time` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `status` int(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `service` -- CREATE TABLE `service` ( `id` int(11) NOT NULL, `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `short_description` text COLLATE utf8_unicode_ci 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 `service` -- INSERT INTO `service` (`id`, `name`, `short_description`, `update_date_time`, `status`) VALUES (1, 'Food & Drink', '<p>Hotel Snow Crest Inn Pvt Ltd is known for its wide range of quality food. You can entertain your taste buds in the Snow Crest Inn Pvt Ltd in which mouth-watering delicacies for Breakfast. Lunch. Dinner.</p>\r\n', '2020-11-19 05:29:15pm', 1), (2, 'Internet With Hi Speed', '<p>We know that even enjoying in holidays one feels to share his/her precious experiences and moments with friends and family too, hence, we provide internet services with Wi-Fi enabled in all the rooms with 100Mbps speed which is free of charge.</p>\r\n', '2021-07-11 12:35:03pm', 1), (3, 'Sunrise and Sunset View', '<p>During the stay in our Hotel, you get to enjoy the mesmerizing view of sunrise and sunset from the roof top restaurant. Accommodation in Snow Crest Inn Pvt Ltd, you will get more luxurious and more satisfying stay.</p>\r\n', '2020-11-20 05:50:24pm', 1); -- -- Indexes for dumped tables -- -- -- Indexes for table `accommodation` -- ALTER TABLE `accommodation` ADD PRIMARY KEY (`id`); -- -- Indexes for table `admin_login` -- ALTER TABLE `admin_login` ADD PRIMARY KEY (`id`); -- -- Indexes for table `banner_slider` -- ALTER TABLE `banner_slider` ADD PRIMARY KEY (`id`); -- -- Indexes for table `gallery` -- ALTER TABLE `gallery` ADD PRIMARY KEY (`id`); -- -- Indexes for table `homegallery` -- ALTER TABLE `homegallery` ADD PRIMARY KEY (`id`); -- -- Indexes for table `offers` -- ALTER TABLE `offers` ADD PRIMARY KEY (`id`); -- -- Indexes for table `service` -- ALTER TABLE `service` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `accommodation` -- ALTER TABLE `accommodation` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9; -- -- AUTO_INCREMENT for table `banner_slider` -- ALTER TABLE `banner_slider` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=54; -- -- AUTO_INCREMENT for table `gallery` -- ALTER TABLE `gallery` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=52; -- -- AUTO_INCREMENT for table `homegallery` -- ALTER TABLE `homegallery` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9; -- -- AUTO_INCREMENT for table `offers` -- ALTER TABLE `offers` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `service` -- ALTER TABLE `service` 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 */;