-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `tourism`
--

-- --------------------------------------------------------

--
-- Table structure for table `access`
--

CREATE TABLE `access` (
  `id` int(11) NOT NULL,
  `code` varchar(255) NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `access`
--

INSERT INTO `access` (`id`, `code`, `timestamp`) VALUES
(1, 'Tourism@256', '2024-08-23 18:45:03');

-- --------------------------------------------------------

--
-- Table structure for table `bloggers`
--

CREATE TABLE `bloggers` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `description` longtext NOT NULL,
  `facebook` varchar(255) NOT NULL,
  `instagram` varchar(255) NOT NULL,
  `twitter` varchar(255) NOT NULL,
  `linkedin` varchar(255) 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 `bloggers`
--

INSERT INTO `bloggers` (`id`, `name`, `title`, `email`, `phone`, `description`, `facebook`, `instagram`, `twitter`, `linkedin`, `image`, `deleted`, `last_update`, `timestamp`) VALUES
(1, 'Saucerer Mo', 'Senior Blogger', 'sauce@gmail.comm', '123456', 'Test', 'f', 'i', 't', 'l', '.jpg', '', '2024-08-23 22:29:51', '2024-08-23 21:19:00'),
(2, 'Ian M', 'Blogger', 'ianmuhumuza@gmail.com', '0785196012', 'Test', '', '', '', '', 'Ian M.jpg', '', '2024-08-23 22:30:16', '2024-08-23 21:27:07');

-- --------------------------------------------------------

--
-- 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,
  `blog_type` 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,
  `vid1` 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;

--
-- Dumping data for table `blogs`
--

INSERT INTO `blogs` (`id`, `code`, `title`, `cat`, `topic`, `author`, `blog_type`, `paragraph1`, `paragraph2`, `paragraph3`, `paragraph4`, `paragraph5`, `paragraph6`, `web_link`, `image1`, `image2`, `image3`, `vid1`, `summ1`, `summ2`, `summ3`, `deleted`, `last_update`, `timestamp`) VALUES
(1, '00035517092024', 'Test', 'Fitness', 'Test', 'Test', 'Video', 'Test 1', 'Test 2', 'Test 3', 'Test 4', '', '', '', '', '', '', '00035517092024_1.mp4', '', '', '', '', '2024-09-16 21:43:01', '2024-09-16 21:04:42');

-- --------------------------------------------------------

--
-- 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,
  `paragraph1` text NOT NULL,
  `phone1` varchar(255) NOT NULL,
  `phone2` varchar(255) 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,
  `url` 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`, `paragraph1`, `phone1`, `phone2`, `g_maps`, `facebook`, `instagram`, `twitter`, `youtube`, `website`, `image`, `image1`, `image2`, `image3`, `image4`, `image5`, `image6`, `summ1`, `summ2`, `summ3`, `summ4`, `summ5`, `summ6`, `url`, `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', '', '', 'aroma', '', '2024-09-26 20:41:16', '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', '', '', '', 'divine-spa', '', '2024-09-26 20:44:45', '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-09-26 20:40:44', '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-09-26 20:40:44', '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', '', '', '', '', 'hot-lounge', '', '2024-09-26 20:41:03', '2024-08-21 19:25:12'),
(6, '19313616092024', 'Relaxation', 'Wellness', 'Spa', 'bg@gmail.com', '6534567', 'Munyonyo', 'Kampala', 'Uganda', '16:32:00', '16:32:00', 'All', 'Testing', '6534567', '6534567', '', '', '', '', '', '', '19313616092024.jpg', '19313616092024_1.jpg', '', '', '', '', '', '', '', '', '', '', '', 'relaxation', '', '2024-09-26 20:40:57', '2024-09-16 16:33:28'),
(7, '01355326092024', 'Quantum Swimming Pool', 'Fitness', 'Swimming Pool', 's@s.s', '12345679', 'Njeru', 'Fort Portal', 'Uganda', '00:00:00', '00:00:00', 'Swimming Pool', '', '12345679', '12345679', '', '', '', '', '', '', '01355326092024.jpeg', '01355326092024_1.jpeg', '', '', '', '', '', '', '', '', '', '', '', 'quantum-swimming-pool', '', '2024-09-26 20:40:50', '2024-09-25 22:44:55');

-- --------------------------------------------------------

--
-- Table structure for table `reviews`
--

CREATE TABLE `reviews` (
  `id` int(11) NOT NULL,
  `listing_id` varchar(255) NOT NULL,
  `listing` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `review` longtext NOT NULL,
  `rate` 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;

--
-- Dumping data for table `reviews`
--

INSERT INTO `reviews` (`id`, `listing_id`, `listing`, `name`, `email`, `review`, `rate`, `deleted`, `timestamp`) VALUES
(1, '20082821082024', '0', 'ian', 's@s.s', '', '', '', '2024-08-23 19:21:24'),
(2, '20082821082024', '0', 'ian', 's@s.s', 'Test', '1', '', '2024-08-23 19:24:01'),
(3, '20082821082024', '0', 'ian', 's@s.s', 'Test', '2', '', '2024-08-23 19:25:01'),
(4, '20082821082024', '0', 'Ian', 's@s.s', 'Test', '4', '', '2024-08-23 20:03:15'),
(5, '20082821082024', '0', 'Ian', 's@s.s', 'Test', '4', '', '2024-08-23 20:03:51'),
(6, '20082821082024', '0', 'Boy George', 'bg@gmail.com', 'Amazing', '5', '', '2024-08-23 20:07:10'),
(7, '20082821082024', '0', 'Ian M', 'ianmuhumuza@gmail.com', 'Test', '2', '', '2024-08-23 20:08:22'),
(8, '20082821082024', '0', 'Ian M', 'ianmuhumuza@gmail.com', 'Test', '5', '', '2024-08-23 20:09:03'),
(9, '20082821082024', 'Aroma', 'Saucerer M', 'sauce@gmail.comm', 'Trial', '3', '', '2024-08-23 20:13:01'),
(10, '20082821082024', 'Aroma', 'Saucerer M', 'sauce@gmail.comm', 'Teat', '2', '', '2024-08-23 20:13:18');

-- --------------------------------------------------------

--
-- Table structure for table `secure`
--

CREATE TABLE `secure` (
  `id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `token` varchar(255) DEFAULT NULL,
  `access` varchar(255) DEFAULT NULL,
  `action` varchar(255) NOT NULL,
  `attempt` varchar(255) DEFAULT NULL,
  `s_code` varchar(255) NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `secure`
--

INSERT INTO `secure` (`id`, `name`, `token`, `access`, `action`, `attempt`, `s_code`, `timestamp`) VALUES
(1, 'Ian', '6-184522-22082024', 'BE@256', 'Login', 'Failed', '', '2024-08-22 15:45:31'),
(2, 'Ian', '35-184530-22082024', 'tourism@256', 'Login', 'Succesful', '', '2024-08-22 15:45:50'),
(3, 'Ian', '81-185226-22082024', 'tourism@256', 'Login', 'Succesful', '', '2024-08-22 15:55:23'),
(4, 'Ian', '56-210333-23082024', 'tourism@256', 'Login', 'Succesful', '', '2024-08-23 18:03:45'),
(5, 'Ian', '6-004511-01092024', 'tourism@256', 'Login', 'Succesful', '', '2024-08-31 21:45:23'),
(6, 'Ian', '30-180555-08092024', 'tourism@256', 'Login', 'Succesful', '', '2024-09-08 15:06:09'),
(7, 'Ian', '12-185956-16092024', 'tourism@256', 'Login', 'Succesful', '', '2024-09-16 16:00:31'),
(8, 'Ian', '9-165806-17092024', 'BE@256', 'Login', 'Failed', '', '2024-09-17 13:58:25'),
(9, 'Ian', '24-165825-17092024', 'tourism@256', 'Login', 'Succesful', '', '2024-09-17 13:58:35'),
(10, 'Ian', '8-013508-26092024', 'tourism@256', 'Login', 'Succesful', '', '2024-09-25 22:35:42'),
(11, 'Ian', '24-201756-26092024', 'tourism@256', 'Login', 'Succesful', '', '2024-09-26 17:18:11'),
(12, 'Ian', '5-203212-20112024', 'tourism@256', 'Login', 'Succesful', '', '2024-11-20 17:32:34'),
(13, 'Ian', '56-195540-24112024', 'tourism@256', 'Login', 'Succesful', '', '2024-11-24 16:55:54');

-- --------------------------------------------------------

--
-- 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 `access`
--
ALTER TABLE `access`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `bloggers`
--
ALTER TABLE `bloggers`
  ADD PRIMARY KEY (`id`);

--
-- 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 `reviews`
--
ALTER TABLE `reviews`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `secure`
--
ALTER TABLE `secure`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `subscribers`
--
ALTER TABLE `subscribers`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `access`
--
ALTER TABLE `access`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `bloggers`
--
ALTER TABLE `bloggers`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `blogs`
--
ALTER TABLE `blogs`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- 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=8;

--
-- AUTO_INCREMENT for table `reviews`
--
ALTER TABLE `reviews`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `secure`
--
ALTER TABLE `secure`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `subscribers`
--
ALTER TABLE `subscribers`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;

