-- phpMyAdmin SQL Dump
-- version 4.9.2
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1:3306
-- Generation Time: Feb 11, 2020 at 01:10 PM
-- Server version: 10.4.10-MariaDB
-- PHP Version: 7.3.12

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
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: `gaynor`
--

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

--
-- Table structure for table `people`
--

DROP TABLE IF EXISTS `people`;
CREATE TABLE IF NOT EXISTS `people` (
  `id` int(3) NOT NULL AUTO_INCREMENT,
  `firstname` varchar(25) NOT NULL,
  `surname` varchar(40) NOT NULL,
  `postcode` varchar(12) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `people`
--

INSERT INTO `people` (`id`, `firstname`, `surname`, `postcode`) VALUES
(1, 'Gaynor', 'Thomas', 'SA1 6ED'),
(2, 'Alex', 'Mardare', 'SA5 2ER'),
(3, 'Mark', 'Huntly', 'SA1 8PH'),
(4, 'Christine', 'Woods', 'SA4 3EF'),
(5, 'Gareth', 'Jones', 'SA62 3ER'),
(6, 'Bev', 'Holland', 'SA2 4ER'),
(7, 'Gary', 'Jones', 'SA45 2GH'),
(8, 'Connor', 'Ellement', 'SA6 3FR'),
(9, 'Bob', 'Jones', 'CF44 3ER'),
(10, 'Jane', 'Jones', 'CF12 3TR');
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 */;
