-- phpMyAdmin SQL Dump
-- version 2.11.11.3
-- http://www.phpmyadmin.net
--
-- Host: mysql10.namesco.net
-- Generation Time: Aug 12, 2016 at 07:24 PM
-- Server version: 5.5.48
-- PHP Version: 5.2.17

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


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

--
--

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

--
-- Table structure for table `mytable2`
--

CREATE TABLE IF NOT EXISTS `mytable2` (
  `ind` int(11) NOT NULL AUTO_INCREMENT,
  `playTitle` varchar(50) DEFAULT NULL,
  `playAuthor` varchar(50) DEFAULT NULL,
  `playStart` char(50) DEFAULT NULL,
  `playEnd` char(50) DEFAULT NULL,
  PRIMARY KEY (`ind`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=23 ;

--
-- Dumping data for table `mytable2`
--

INSERT INTO `mytable2` (`ind`, `playTitle`, `playAuthor`, `playStart`, `playEnd`) VALUES
(1, 'Hamlet', 'William Shakespeare', '200112', '200123'),
(2, 'Waiting for Godot', 'Samuel Becket', '200209', '200220'),
(3, 'Six Characters in Search of an Author', 'Luigi Pirandello', '200309', '200320'),
(4, 'Death of a Salesman', 'Arthur Miller', '200601', '200612'),
(5, 'The Caretaker', 'Harold Pinter', '200629', '200710'),
(6, 'A Streetcar Named Desire', 'Tennessee Williams', '200727', '200807'),
(7, 'The Threepenny Opera', 'Bertolt Brecht', '200824', '200904'),
(8, 'Rosencrantz and Guildenstern are Dead', 'Tom Stoppard', '2021', '201002'),
(9, 'Plenty', 'David Hare', '201019', '201030'),
(10, 'Journey''s End', 'R. C. Sherriff', '201116', '201127');