Server : LiteSpeed System : Linux in-mum-web1949.main-hosting.eu 5.14.0-503.40.1.el9_5.x86_64 #1 SMP PREEMPT_DYNAMIC Mon May 5 06:06:04 EDT 2025 x86_64 User : u595547767 ( 595547767) PHP Version : 7.4.33 Disable Function : NONE Directory : /home/u595547767/domains/junglebookholidays.in/public_html/ |
-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Apr 15, 2025 at 12:47 PM -- Server version: 10.6.20-MariaDB-cll-lve -- PHP Version: 8.3.14 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; 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: `degreeke_jungle` -- -- -------------------------------------------------------- -- -- Table structure for table `tbl_banners` -- CREATE TABLE `tbl_banners` ( `banner_id` int(11) NOT NULL, `banner_image` longtext NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `tbl_banners` -- INSERT INTO `tbl_banners` (`banner_id`, `banner_image`) VALUES (16, 'uploads/banners/a2.jpeg'), (19, 'uploads/banners/about.jpeg'); -- -------------------------------------------------------- -- -- Table structure for table `tbl_book` -- CREATE TABLE `tbl_book` ( `book_id` int(11) NOT NULL, `book_name` varchar(300) NOT NULL, `book_email` varchar(300) NOT NULL, `book_phone` varchar(100) NOT NULL, `book_date` date NOT NULL, `book_destination` varchar(300) NOT NULL, `book_message` mediumtext NOT NULL, `book_status` varchar(300) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `tbl_book` -- INSERT INTO `tbl_book` (`book_id`, `book_name`, `book_email`, `book_phone`, `book_date`, `book_destination`, `book_message`, `book_status`) VALUES (34, 'Akhil Vg', 'akhilvg007@gmail.com', '2147483647', '2024-12-19', 'Kulu', 'Book kulu manali', 'booked'), (35, 'ELDHOSE P JOSEPH', 'volga3power@gmail.com', '09895452453', '2025-03-12', 'Munnar', 'Na', 'booked'); -- -------------------------------------------------------- -- -- Table structure for table `tbl_gallery` -- CREATE TABLE `tbl_gallery` ( `gallery_id` int(11) NOT NULL, `gallery_image` mediumtext NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `tbl_gallery` -- INSERT INTO `tbl_gallery` (`gallery_id`, `gallery_image`) VALUES (75, 'uploads/gallery/a4.jpeg'), (76, 'uploads/gallery/a6.jpeg'), (77, 'uploads/gallery/a10.jpeg'); -- -------------------------------------------------------- -- -- Table structure for table `tbl_testimonial` -- CREATE TABLE `tbl_testimonial` ( `testimonial_id` int(11) NOT NULL, `testimonial_name` varchar(300) NOT NULL, `testimonial_place` varchar(300) NOT NULL, `testimonial_content` mediumtext NOT NULL, `testimonial_image` mediumtext NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `tbl_testimonial` -- INSERT INTO `tbl_testimonial` (`testimonial_id`, `testimonial_name`, `testimonial_place`, `testimonial_content`, `testimonial_image`) VALUES (2, 'Hanna S', 'Alappuzha', 'Truly very satisfied. The drivers were very humble and they took good care to make our journey smooth. Nice journey and great service.', 'uploads/testimonials/avatar.png'), (3, 'Hari K N', 'Idukki', 'It was nice to travel with Jungle Book Holidays.....', 'uploads/testimonials/avatar.png'), (4, 'Mini George', 'Ernakulam', 'Nice Service.. really appreciable!', 'uploads/testimonials/avatar.png'); -- -------------------------------------------------------- -- -- Table structure for table `tbl_user` -- CREATE TABLE `tbl_user` ( `user_id` int(11) NOT NULL, `username` varchar(300) NOT NULL, `password` varchar(300) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `tbl_user` -- INSERT INTO `tbl_user` (`user_id`, `username`, `password`) VALUES (1, 'admin', 'jungle@123'); -- -- Indexes for dumped tables -- -- -- Indexes for table `tbl_banners` -- ALTER TABLE `tbl_banners` ADD PRIMARY KEY (`banner_id`); -- -- Indexes for table `tbl_book` -- ALTER TABLE `tbl_book` ADD PRIMARY KEY (`book_id`); -- -- Indexes for table `tbl_gallery` -- ALTER TABLE `tbl_gallery` ADD PRIMARY KEY (`gallery_id`); -- -- Indexes for table `tbl_testimonial` -- ALTER TABLE `tbl_testimonial` ADD PRIMARY KEY (`testimonial_id`); -- -- Indexes for table `tbl_user` -- ALTER TABLE `tbl_user` ADD PRIMARY KEY (`user_id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `tbl_banners` -- ALTER TABLE `tbl_banners` MODIFY `banner_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20; -- -- AUTO_INCREMENT for table `tbl_book` -- ALTER TABLE `tbl_book` MODIFY `book_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=36; -- -- AUTO_INCREMENT for table `tbl_gallery` -- ALTER TABLE `tbl_gallery` MODIFY `gallery_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=78; -- -- AUTO_INCREMENT for table `tbl_testimonial` -- ALTER TABLE `tbl_testimonial` MODIFY `testimonial_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `tbl_user` -- ALTER TABLE `tbl_user` MODIFY `user_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; 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 */;