-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- Server version 4.1.11-nt

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

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

--
-- Create schema henry
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ henry;
USE henry;

--
-- Table structure for table `henry`.`author`
--

DROP TABLE IF EXISTS `author`;
CREATE TABLE `author` ( `AUTHOR_NUM` decimal(2,0) NOT NULL default '0', `AUTHOR_LAST` char(12) default NULL, `AUTHOR_FIRST` char(10) default NULL, PRIMARY KEY (`AUTHOR_NUM`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `henry`.`author`
--

/*!40000 ALTER TABLE `author` DISABLE KEYS */;
INSERT INTO `author` (`AUTHOR_NUM`,`AUTHOR_LAST`,`AUTHOR_FIRST`) VALUES ('1','Morrison','Toni'), ('2','Solotaroff','Paul'), ('3','Vintage','Vernor'), ('4','Francis','Dick'), ('5','Straub','Peter'), ('6','King','Stephen'), ('7','Pratt','Philip'), ('8','Chase','Truddi'), ('9','Collins','Bradley'), ('10','Heller','Joseph'), ('11','Wills','Gary'), ('12','Hofstadter','Douglas R.'), ('13','Lee','Harper'), ('14','Ambrose','Stephen E.'), ('15','Rowling','J.K.'), ('16','Salinger','J.D.'), ('17','Heaney','Seamus'), ('18','Camus','Albert'), ('19','Collins, Jr.','Bradley'), ('20','Steinbeck','John'), ('21','Castelman','Riva'), ('22','Owen','Barbara'), ('23','O\'Rourke','Randy'), ('24','Kidder','Tracy'), ('25','Schleining','Lon');