people.sql

-- phpMyAdmin SQL Dump
-- version 4.8.5
-- https://www.phpmyadmin.net/
--
-- Host: localhost:8889
-- Generation Time: May 20, 2019 at 04:58 PM
-- Server version: 5.7.25
-- PHP Version: 7.3.1

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

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

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

DROP TABLE IF EXISTS `people`;
CREATE TABLE `people` (
  `email` varchar(100) NOT NULL,
  `first_name` varchar(30) NOT NULL,
  `last_name` varchar(30) NOT NULL,
  `common_name` varchar(40) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

INSERT INTO `people` (`email`, `first_name`, `last_name`, `common_name`) VALUES
('arya@stark.org', 'Arya', 'Stark', ''),
('brandon@stark.org', 'Brandon', 'Stark', ''),
('bronn@blackwater.info', 'Bronn', 'Blackwater', ''),
('cersei@kingslanding.com', 'Cersei', 'Lannister', ''),
('daenerys@dragonstone.org', 'Daenerys', 'Targaryen', ''),
('gregor@clegane.org', 'Gregor', 'Clegane', ''),
('jaime@lannister.org', 'Jaime', 'Lannister', ''),
('jon@thebastard.org', 'Jon', 'Snow', ''),
('samwell@nights-watch.org', 'Samwell', 'Tarley', ''),
('sandor@clegane.org', 'Sandor', 'Clegane', ''),
('sansa@stark.org', 'Sansa', 'Stark-Bolton', '');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `people`
--
ALTER TABLE `people`
  ADD PRIMARY KEY (`email`);

/*!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 */;