-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Nov 24, 2024 at 07:07 PM
-- 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: `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;
/*!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 */;