-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: May 20, 2025 at 08:58 PM
-- Server version: 10.4.32-MariaDB
-- PHP Version: 8.2.12

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: `golfer`
--

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

--
-- Table structure for table `events`
--

CREATE TABLE `events` (
  `id` int(11) NOT NULL,
  `code` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `region` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `website` 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,
  `url` text 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`, `region`, `email`, `phone`, `website`, `venue`, `location`, `district`, `country`, `start_date`, `end_date`, `start_time`, `end_time`, `description`, `url`, `image`, `deleted`, `last_update`, `timestamp`) VALUES
(1, '18292020052025', 'All-Africa Challenge Trophy Southern Region Championship', 'Africa', 'brenda@iway.na', '+26461400849', '', 'Omeya Golf Estate', 'Windhoek East', 'Khomas', 'Namibia', '2025-03-31', '2025-04-04', '00:00:00', '00:00:00', 'The Namibia Golf Federation and Namibia Ladies Golf will be hosting the All-Africa Challenge Trophy Southern Region championships from 31 March to 4 April, at the Windhoek Country Club. For more information, please contact Brenda Lens and brenda@iway.na', 'allafrica-challenge-trophy-southern-region-championship', '18292020052025.webp', '', '2025-05-20 16:51:26', '2025-05-20 16:29:20'),
(2, '18434120052025', 'All Africa Junior Golf Teams Championship', 'Africa', 'federationdegolftun@gmail.com', '', '', 'The Residence Golf Course', 'Gammath', 'Tunis', 'Tunisia', '2026-05-23', '2026-05-26', '00:00:00', '00:00:00', 'The Tunisia Golf Federation will be hosting the 2026 All Africa Junior Golf Teams Championship from the 22nd – 27th April at The Residence Golf Course, Gammath. (Closing date for team submissions is Saturday the 15th March 2025, for more information contact federationdegolftun@gmail.com)', 'all-africa-junior-golf-teams-championship', '18434120052025.jpg', '', '2025-05-20 16:51:11', '2025-05-20 16:43:41'),
(3, '19103720052025', 'The AGC Region 5 Championship', 'Africa', '', '', '', 'Gaborone Golf Course', 'Chuma Drive', 'Gaborone', 'Ethiopia', '0000-00-00', '0000-00-00', '00:00:00', '00:00:00', 'The Botswana Golf Union will be hosting the Region 5 Championship. The AGC Region 5 Golf Tournament 2025 is a premier golfing event that unites top talent from across the region for an unforgettable competition. Hosted at the prestigious Gaborone Golf Course, this tournament showcases skill, precision, and sportsmanship on a world-class course.', 'the-agc-region-5-championship', '19103720052025.jpg', '', '2025-05-20 17:10:37', '2025-05-20 17:10:37'),
(4, '19472620052025', 'Biennial Africa Amateur Team Championship', 'Africa', '', '', 'https://www.randa.org/', 'Kruger National Park', 'Limpopo', 'Mpumalanga Province', 'South Africa', '0000-00-00', '0000-00-00', '00:00:00', '00:00:00', 'The championship is played in February and consists of 72 holes of stroke-play with 72 players from the Africa region, and a cut for the leading 40 players and ties after 36 holes. The inaugural winner received invitations into The Open Championship, The Amateur Championship, Alfred Dunhill Championship and Waterfall City Tournament of Champions.', 'biennial-africa-amateur-team-championship', '19472620052025.jpg', '', '2025-05-20 17:47:45', '2025-05-20 17:47:26');

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `events`
--
ALTER TABLE `events`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
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 */;
