-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: May 18, 2025 at 11:46 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 `courses`
--

CREATE TABLE `courses` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `size` varchar(255) NOT NULL,
  `location` varchar(255) NOT NULL,
  `country` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `website` varchar(255) NOT NULL,
  `author` varchar(255) NOT NULL,
  `code` varchar(255) NOT NULL,
  `url` varchar(255) NOT NULL,
  `description1` text NOT NULL,
  `description2` text NOT NULL,
  `image1` varchar(255) NOT NULL,
  `summ1` longtext NOT NULL,
  `image2` varchar(255) NOT NULL,
  `summ2` longtext NOT NULL,
  `image3` varchar(255) NOT NULL,
  `summ3` longtext NOT NULL,
  `image4` varchar(255) NOT NULL,
  `summ4` longtext NOT NULL,
  `image5` varchar(255) NOT NULL,
  `summ5` longtext NOT NULL,
  `image6` varchar(255) NOT NULL,
  `summ6` longtext NOT NULL,
  `image7` varchar(255) NOT NULL,
  `summ7` longtext NOT NULL,
  `image8` varchar(255) NOT NULL,
  `summ8` longtext 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 `courses`
--

INSERT INTO `courses` (`id`, `title`, `size`, `location`, `country`, `phone`, `email`, `website`, `author`, `code`, `url`, `description1`, `description2`, `image1`, `summ1`, `image2`, `summ2`, `image3`, `summ3`, `image4`, `summ4`, `image5`, `summ5`, `image6`, `summ6`, `image7`, `summ7`, `image8`, `summ8`, `deleted`, `last_update`, `timestamp`) VALUES
(1, 'Durban Country Club', '', 'KwaZulu-Natal 4001', 'South Africa', '+27 (0)31 313 1777', 'info@durbancountryclub.co.za', 'https://www.durbancountryclub.co.za/', 'Ian Muhumuza', '19354518052025', 'durban-country-club', 'The Country Club course at Durban Country Club is widely regarded as one of the finest of its kind in South Africa and has earned a spot on the list of the top 100 Golf Courses. This unforgettable venue has hosted the South African Open 17 times, more than any other course globally.', 'The Country Club course at Durban Country Club has proudly hosted sixteen South African Opens, making it the venue with the most tournaments of its kind in the country.', '193545180520251.jpeg', '', '193545180520252.jpeg', '', '193545180520253.jpeg', '', '193545180520254.jpeg', '', '193545180520255.jpeg', '', '193545180520256.jpeg', '', '193545180520257.jpeg', '', '193545180520258.jpeg', '', '', '2025-05-18 17:35:45', '2025-05-18 17:35:45'),
(2, 'Fancourt (The Links)', '', 'Western Cape 6529', 'South Africa', '+27 (0)44 804 0030', '', 'https://www.fancourt.co.za/', 'Ian Muhumuza', '19503518052025', 'fancourt-(the-links)', 'The Links course at Fancourt opened for play in November 2000 and it represents a unique and very tough South African golfing experience. The course was designed by Gary Player but only after the Black Knight’s team had studied in great detail the characteristics of classic Scottish links courses. The Links at Fancourt does indeed resemble a traditional seaside links course but so far they have failed to recreate the changeable British weather.', 'It’s hard to believe that the host venue for the 2003 Presidents Cup, which resulted in an historic tie between Tiger Woods and Ernie Els, was once an airfield. The earth certainly moved at Fancourt and the result is a jaunty ramble through gigantic dunes with the majestic Outeniqua Mountains providing a stunning backdrop. Surely this is South Africa’s most unusual and remarkable golf course?', '195035180520251.jpeg', '', '195035180520252.jpeg', '', '195035180520253.jpeg', '', '195035180520254.jpeg', '', '195035180520255.jpeg', '', '195035180520256.jpeg', '', '195035180520257.jpeg', '', '195035180520258.jpeg', '', '', '2025-05-18 17:50:35', '2025-05-18 17:50:35'),
(3, 'Royal Golf Dar Es Salam (Red)', '', 'Rabat-Salé-Kénitra', 'Morocco', '+212 537 755 864', '', 'https://www.royalgolfdaressalam.com/', 'Ian Muhumuza', '19561118052025', 'royal-golf-dar-es-salam-(red)', 'Morocco’s King Hassan II – a real golf enthusiast – commissioned American-based architect Robert Trent Jones to design Royal Golf Dar Es Salam in the late 1960s on a massive 1,000-acre site located a mere fifteen minutes to the south of Rabat, Morocco’s Atlantic coast capital. The result was that three layouts were carved out of the Zaers forest, creating one of the top golf venues in all of Africa. The 18-hole Red is the toughest of the three tracks at Dar Es Salam, measuring a whopping 7,372-yards with a par of 73. The 18-hole Blue course is less demanding but testing nonetheless whilst the 9-hole Green circuit has been designed for a more relaxing game of golf.', '“The design for Royal Rabat perfectly aligned with his style,” noted Pat Ward-Thomas in the New World Atlas of Golf. “It was intended to be a course worthy of a king – Hassan II of Morocco, who is the most passionate golfer among today’s royals.”', '195611180520251.jpeg', '', '195611180520252.jpeg', '', '195611180520253.jpeg', '', '195611180520254.jpeg', '', '195611180520255.jpeg', '', '195611180520256.jpeg', '', '', '', '', '', '', '2025-05-18 17:56:11', '2025-05-18 17:56:11'),
(4, 'Humewood Golf Club', '', 'Eastern Cape 6001', 'South Africa', '+27 (0) 41 583 2137', 'info@humewoodgolf.co.za', 'https://www.humewoodgolf.co.za/', 'Ian Muhumuza', '20032618052025', 'humewood-golf-club', 'Humewood Golf Club was rated by the late, great Bobby Locke as one of the best links courses he’d ever played and for a man with four Open Championships to his name between 1949 and 1957, he was certainly well qualified to voice such an opinion.', 'Greens at Humewood are firm and fast, requiring a sure putting touch – which was needed when the South African Open returned to this top class links in 2006.', '200326180520251.jpeg', '', '200326180520252.jpeg', '', '200326180520253.jpeg', '', '200326180520254.jpeg', '', '200326180520255.jpeg', '', '200326180520256.jpeg', '', '', '', '', '', '', '2025-05-18 18:03:26', '2025-05-18 18:03:26'),
(5, 'Al Houara Golf Club', '', 'Tangier 90000', 'Morocco', '+212 (0) 539 409 400', '', 'https://www.hilton.com/en/hotels/tngahhi-hilton-tangier-al-houara-resort-and-spa/golf/', 'Ian Muhumuza', '20150318052025', 'al-houara-golf-club', 'Situated right on the Atlantic coast, the golf complex at the Hilton Al Houara Resort & Spa is a rather unique offering from the unlikely design partnership of Graham Marsh and Vijay Singh. Playing surfaces are carpeted throughout with salt water-tolerant paspalum grass.', 'Developed by the Qatari Diar investment company, Al Houra features an 18-hole layout, a 9-hole floodlit compact course, driving range and short game area. The facility was officially opened on 1st September 2022.', '201503180520251.jpeg', '', '201503180520252.jpeg', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '2025-05-18 18:15:03', '2025-05-18 18:15:03'),
(6, 'St Francis Links', '', 'Eastern Cape 6312', 'South Africa', '+27 (0) 42 200 4500', '', 'https://www.stfrancislinks.com/', 'Ian Muhumuza', '20202718052025', 'st-francis-links', '“True Links,” a remarkable book by George Peper and Malcolm Campbell, originally published in 2010, highlights just 246 links golf courses around the globe. Among these, it includes only one course from South Africa: Humewood, a distinguished layout founded by Colonel Stafford Vere Hotchkin in 1931.', 'The course at St Francis Bay is situated slightly inland from the coast and showcases numerous links characteristics, with fairways designed across rugged, undulating sandy landscapes.', '202027180520251.jpeg', '', '202027180520252.jpeg', '', '202027180520253.jpeg', '', '202027180520254.jpeg', '', '', '', '', '', '', '', '', '', '', '2025-05-18 18:20:27', '2025-05-18 18:20:27'),
(7, 'Leopard Creek Country Club', '', 'Mpumalanga 1320', 'South Africa', '+27 (0)13 791 2000', 'info@leopardcreek.co.za', 'https://www.leopardcreek.co.za/', 'Ian Muhumuza', '20310418052025', 'leopard-creek-country-club', 'Leopard Creek Country Club is a prestigious venue that opened its doors in 1996. Owned by businessman Johan Rupert, the club serves as a sponsor for the Alfred Dunhill Links Championship held at St Andrews in Scotland. The entrance to the club is located at the bridge that spans the Crocodile River, leading to the Malelane Gate of Kruger National Park. This entry point is as highly secured as that of Augusta National, with Leopard Creek designated exclusively for members and their guests. However, visitors can still enjoy the property, utilize the clubhouse, and play the course by staying at nearby game lodges and paying a premium green fee. The nearest lodge to the course is Buhala Lodge, situated just a few kilometers away along the banks of the Crocodile River, which also borders the golf course.', 'Leopard Creek Country Club – the wild gem – offers a golf experience that harmonizes with nature. Nestled on the outskirts of Kruger National Park, it presents a delightful blend of golf and safari adventures.', '203104180520251.jpeg', '', '203104180520252.jpeg', '', '203104180520253.jpeg', '', '203104180520254.jpeg', '', '203104180520255.jpeg', '', '203104180520256.jpeg', '', '203104180520257.jpeg', '', '203104180520258.jpeg', '', '', '2025-05-18 18:31:04', '2025-05-18 18:31:04'),
(8, 'Michlifen', '', 'Fez-Meknès', 'Morocco', '+212 5 35 86 42 42', '', 'https://www.michlifen.com/', 'Ian Muhumuza', '20351818052025', 'michlifen', 'Nestled near the charming mountain town of Ifrane, Michlifen Golf & Country Club is perched at an elevation of 5,500 feet above sea level. It is located in the breathtaking Middle Atlas Mountain Region of Morocco, conveniently positioned between Fez and Meknes.', 'Nicklaus Design opened the 18-hole Michlifen Golf and Country Club, a Jack Nicklaus Signature Course, in late summer 2018. Construction began four years earlier, culminating in a high-profile launch with the “Coupe du Trone / King’s Trophy” tournament by the Moroccan Golf Federation.', '203518180520251.jpeg', '', '203518180520252.jpeg', '', '203518180520253.jpeg', '', '203518180520254.jpeg', '', '203518180520255.jpeg', '', '203518180520256.jpeg', '', '203518180520257.jpeg', '', '203518180520258.jpeg', '', '', '2025-05-18 18:35:18', '2025-05-18 18:35:18'),
(9, 'Royal Johannesburg & Kensington (East)', '', 'Gauteng 2192', 'South Africa', '+27 (0) 11 640 3021', '', 'https://www.royaljk.za.com/', 'Ian Muhumuza', '20380218052025', 'royal-johannesburg--kensington-east', 'It was quite a surprise when the Royal Johannesburg and Kensington golf clubs merged in 1998 to create a single entity, especially considering that both clubs had been founded over a century earlier.', 'The East course at Royal Johannesburg and Kensington is renowned for its daunting beginning to the inward half, featuring consecutive par fours that stretch over 500 yards at the 10th and 11th holes.', '203802180520251.jpeg', '', '203802180520252.jpeg', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '2025-05-18 19:47:10', '2025-05-18 18:38:02'),
(10, 'Ile aux Cerfs Golf Club', '', 'Flacq District', 'Mauritius', '+230 402 7720', '', 'https://www.ileauxcerfsgolfclub.com/', 'Ian Muhumuza', '20413218052025', 'ile-aux-cerfs-golf-club', 'The course at Île aux Cerfs Golf Club, previously known as Le Touessrok, is located on a private tropical island in the Indian Ocean. This esteemed IMG layout showcases the architectural signature of Bernhard Langer, adding to its prestige.', 'The Ile aux Cerfs golf course, designed by Bernhard Langer and constructed for approximately $11.5 million, opened in 2003. Situated on a small island off Trou d’Eau Douce in Mauritius’s largest lagoon, it features 18 holes laid out on a former sugar plantation.', '204132180520251.jpeg', '', '204132180520252.jpeg', '', '204132180520253.jpeg', '', '204132180520254.jpeg', '', '204132180520255.jpeg', '', '204132180520256.jpeg', '', '204132180520257.jpeg', '', '204132180520258.jpeg', '', '', '2025-05-18 18:41:32', '2025-05-18 18:41:32');

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

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