-- 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 */;
