File manager - Edit - /home/custbahd/fitbora.net/admin/sql/fitbora.sql
Back
-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Aug 22, 2024 at 01:49 AM -- Server version: 10.4.28-MariaDB -- PHP Version: 8.2.4 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: `fitbora` -- -- -------------------------------------------------------- -- -- Table structure for table `blogs` -- CREATE TABLE `blogs` ( `id` int(11) NOT NULL, `code` varchar(255) NOT NULL, `title` varchar(255) NOT NULL, `cat` varchar(255) NOT NULL, `topic` varchar(255) NOT NULL, `author` varchar(255) NOT NULL, `paragraph1` longtext NOT NULL, `paragraph2` longtext NOT NULL, `paragraph3` longtext NOT NULL, `paragraph4` longtext NOT NULL, `paragraph5` longtext NOT NULL, `paragraph6` longtext NOT NULL, `web_link` longtext NOT NULL, `image1` varchar(255) NOT NULL, `image2` varchar(255) NOT NULL, `image3` varchar(255) NOT NULL, `summ1` text NOT NULL, `summ2` text NOT NULL, `summ3` text NOT NULL, `deleted` varchar(255) NOT NULL, `last_update` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `comments` -- CREATE TABLE `comments` ( `id` int(11) NOT NULL, `blog_id` varchar(255) NOT NULL, `c_name` varchar(255) NOT NULL, `c_email` varchar(255) NOT NULL, `comment` longtext NOT NULL, `deleted` varchar(255) NOT NULL, `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `events` -- CREATE TABLE `events` ( `id` int(11) NOT NULL, `code` varchar(255) NOT NULL, `title` varchar(255) NOT NULL, `cat` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `phone` varchar(255) NOT NULL, `venue` varchar(255) NOT NULL, `location` varchar(255) NOT NULL, `district` varchar(255) NOT NULL, `country` varchar(255) NOT NULL, `start_date` date NOT NULL, `end_date` date NOT NULL, `start_time` time NOT NULL, `end_time` time NOT NULL, `description` longtext NOT NULL, `g_maps` text NOT NULL, `facebook` varchar(255) NOT NULL, `instagram` varchar(255) NOT NULL, `twitter` varchar(255) NOT NULL, `youtube` varchar(255) NOT NULL, `website` longtext NOT NULL, `image` varchar(255) NOT NULL, `deleted` varchar(255) NOT NULL, `last_update` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `events` -- INSERT INTO `events` (`id`, `code`, `title`, `cat`, `email`, `phone`, `venue`, `location`, `district`, `country`, `start_date`, `end_date`, `start_time`, `end_time`, `description`, `g_maps`, `facebook`, `instagram`, `twitter`, `youtube`, `website`, `image`, `deleted`, `last_update`, `timestamp`) VALUES (1, '21312421082024', 'Queens', 'Other', 'bg@gmail.com', '6534567', 'Levels', 'Mulago', 'Kampala', 'Uganda', '2024-12-25', '0000-00-00', '19:00:00', '00:00:00', 'Queens Of Kidongo', 'queens.com', 'queens', 'queens', 'queens', 'queens', 'queens.com', '21312421082024.jpg', '', '2024-08-21 19:33:38', '2024-08-21 19:33:38'), (2, '21333821082024', 'ASFA', 'Other', 'help@asfa.com', '123456789', 'Serena Hotel', 'Kololo', 'Kampala', 'Uganda', '2024-10-18', '0000-00-00', '19:00:00', '00:00:00', 'Abryans Style & Fashion Awards', 'asfa.com', 'asfa', 'asfa', 'asfa', 'asfa', 'asfa.com', '21333821082024.jpg', '', '2024-08-21 19:36:27', '2024-08-21 19:36:27'), (3, '21372721082024', 'Mindfulness', 'Spa', 'sauce@gmail.comm', '123456', 'Source', 'Makerere', 'Kampala', 'Uganda', '2024-09-24', '0000-00-00', '15:00:00', '00:00:00', 'Mindfulness', '', '', '', '', '', '', '21372721082024.jpg', '', '2024-08-21 19:39:44', '2024-08-21 19:39:44'); -- -------------------------------------------------------- -- -- Table structure for table `inquiries` -- CREATE TABLE `inquiries` ( `id` int(11) NOT NULL, `msg_id` varchar(255) NOT NULL, `name` varchar(255) NOT NULL, `phone` varchar(255) NOT NULL, `sender` varchar(255) NOT NULL, `receiver` varchar(255) NOT NULL, `user` varchar(255) NOT NULL, `subject` varchar(255) NOT NULL, `message` longtext NOT NULL, `seen` varchar(255) NOT NULL, `deleted` varchar(255) NOT NULL, `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `listings` -- CREATE TABLE `listings` ( `id` int(11) NOT NULL, `code` varchar(255) NOT NULL, `title` varchar(255) NOT NULL, `cat` varchar(255) NOT NULL, `sub` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `phone` varchar(255) NOT NULL, `address` varchar(255) NOT NULL, `district` varchar(255) NOT NULL, `country` varchar(255) NOT NULL, `hr_open` time NOT NULL, `hr_close` time NOT NULL, `services` longtext NOT NULL, `g_maps` text NOT NULL, `facebook` varchar(255) NOT NULL, `instagram` varchar(255) NOT NULL, `twitter` varchar(255) NOT NULL, `youtube` varchar(255) NOT NULL, `website` longtext NOT NULL, `image` varchar(255) NOT NULL, `image1` varchar(255) NOT NULL, `image2` varchar(255) NOT NULL, `image3` varchar(255) NOT NULL, `image4` varchar(255) NOT NULL, `image5` varchar(255) NOT NULL, `image6` varchar(255) NOT NULL, `summ1` text NOT NULL, `summ2` text NOT NULL, `summ3` text NOT NULL, `summ4` text NOT NULL, `summ5` text NOT NULL, `summ6` text NOT NULL, `deleted` varchar(255) NOT NULL, `last_update` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `listings` -- INSERT INTO `listings` (`id`, `code`, `title`, `cat`, `sub`, `email`, `phone`, `address`, `district`, `country`, `hr_open`, `hr_close`, `services`, `g_maps`, `facebook`, `instagram`, `twitter`, `youtube`, `website`, `image`, `image1`, `image2`, `image3`, `image4`, `image5`, `image6`, `summ1`, `summ2`, `summ3`, `summ4`, `summ5`, `summ6`, `deleted`, `last_update`, `timestamp`) VALUES (1, '20082821082024', 'Aroma', 'Wellness', 'Health Club', 'info@aroma.com', '123456789', 'Plot 21323, Kololo', 'Kampala', 'Uganda', '08:00:00', '18:00:00', 'Massages, Therapy, Training, Meditation & Yoga', 'aroma.com', 'aroma', 'aroma', 'aroma', 'aroma', 'aroma.com', '20082821082024.jpg', '20082821082024_1.png', '20082821082024_2.png', '20082821082024_3.png', '20082821082024_4.png', '', '', 'Gym', 'Spa', 'Therapy', 'Yoga', '', '', '', '2024-08-21 18:14:06', '2024-08-21 18:14:06'), (2, '20140721082024', 'Divine Spa', 'Steam Bath', 'Spa', 'help@divine.com', '123456789', 'Makindye', 'Kampala', 'Uganda', '09:30:00', '17:30:00', 'Steam Bath, Massage, Swimming etc', 'divine.com', 'divine', 'divine', 'divine', 'divine', 'divine.com', '20140721082024.jpg', '20140721082024_1.jpg', '20140721082024_2.jpg', '20140721082024_3.jpg', '', '', '', 'Ocean View', 'Accomodation', 'Pier', '', '', '', '', '2024-08-21 18:20:07', '2024-08-21 18:20:07'), (3, '21083821082024', 'Toppers Gym', 'Fitness', 'Gym', 'info@toppers.com', '1234567890', 'Kitebi', 'Entebbe', 'Uganda', '10:00:00', '23:00:00', 'Heavy lifting, Work Outs, Training, Consultancy etc', 'toppers.com', 'toppers', 'toppers', 'toppers', 'toppers', 'toppers.com', '21083821082024.jpg', '21083821082024_1.jpg', '', '', '', '', '', 'Interior', '', '', '', '', '', '', '2024-08-21 19:13:20', '2024-08-21 19:13:20'), (4, '21132021082024', 'The Source Rehabilitation', 'Wellness', 'Physiotherapist', 'info@source.com', '12345679', 'Itanda Falls', 'Jinja', 'Uganda', '00:00:00', '00:00:00', 'Rehabilitation, Relaxation, Yoga, Mindful Therapy, Physio Therapy etc', 'source.com', 'source', 'source', 'source', 'source', 'source.com', '21132021082024.jpeg', '21132021082024_1.jpeg', '21132021082024_2.jpeg', '', '', '', '', 'Therapy', 'Relaxation', '', '', '', '', '', '2024-08-21 19:20:21', '2024-08-21 19:20:21'), (5, '21202121082024', 'Hot Lounge', 'Dance', 'Dance Club', 'support@hot.com', '6534567', 'Akor', 'Gulu', 'Uganda', '16:00:00', '05:00:00', 'Cocktails, Bar, Lounge, Live Shows', 'hot.com', 'hot', 'hot', 'hot', 'hot', 'hot.com', '21202121082024.jpeg', '21202121082024_1.jpg', '21202121082024_2.png', '', '', '', '', 'Shows', 'Club', '', '', '', '', '', '2024-08-21 19:25:12', '2024-08-21 19:25:12'); -- -------------------------------------------------------- -- -- Table structure for table `subscribers` -- CREATE TABLE `subscribers` ( `id` int(11) NOT NULL, `email` varchar(255) NOT NULL, `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Indexes for dumped tables -- -- -- Indexes for table `blogs` -- ALTER TABLE `blogs` ADD PRIMARY KEY (`id`); -- -- Indexes for table `comments` -- ALTER TABLE `comments` ADD PRIMARY KEY (`id`); -- -- Indexes for table `events` -- ALTER TABLE `events` ADD PRIMARY KEY (`id`); -- -- Indexes for table `inquiries` -- ALTER TABLE `inquiries` ADD PRIMARY KEY (`id`); -- -- Indexes for table `listings` -- ALTER TABLE `listings` ADD PRIMARY KEY (`id`); -- -- Indexes for table `subscribers` -- ALTER TABLE `subscribers` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `blogs` -- ALTER TABLE `blogs` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `comments` -- ALTER TABLE `comments` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `events` -- ALTER TABLE `events` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `inquiries` -- ALTER TABLE `inquiries` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `listings` -- ALTER TABLE `listings` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `subscribers` -- ALTER TABLE `subscribers` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; 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 */;
| ver. 1.4 |
Github
|
.
| PHP 8.1.33 | Generation time: 1.8 |
proxy
|
phpinfo
|
Settings