-- 
-- Database: 'library'
-- 

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

-- 
-- Table structure for table 'author'
-- 

DROP TABLE IF EXISTS author;
CREATE TABLE author (
  AuthorID int(11) NOT NULL AUTO_INCREMENT,
  AuthorName varchar(255) NOT NULL,
  PRIMARY KEY (AuthorID),
  KEY AuthorName (AuthorName)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table 'author'
-- 

INSERT INTO author (AuthorID, AuthorName) VALUES (101, 'Ed McBain');
INSERT INTO author (AuthorID, AuthorName) VALUES (102, 'Tina Rathbone');
INSERT INTO author (AuthorID, AuthorName) VALUES (103, 'John Welcome');
INSERT INTO author (AuthorID, AuthorName) VALUES (104, 'Andy Rathbone');
INSERT INTO author (AuthorID, AuthorName) VALUES (105, 'Tim Healey');
INSERT INTO author (AuthorID, AuthorName) VALUES (106, 'James Anderson');
INSERT INTO author (AuthorID, AuthorName) VALUES (107, 'David Deutsch');
INSERT INTO author (AuthorID, AuthorName) VALUES (108, 'Will Self');
INSERT INTO author (AuthorID, AuthorName) VALUES (109, 'Ian Don');
INSERT INTO author (AuthorID, AuthorName) VALUES (110, 'Frederick Forsyth');
INSERT INTO author (AuthorID, AuthorName) VALUES (111, 'James Clavell');
INSERT INTO author (AuthorID, AuthorName) VALUES (112, 'Seth McEvoy');
INSERT INTO author (AuthorID, AuthorName) VALUES (113, 'Stephen Fry');
INSERT INTO author (AuthorID, AuthorName) VALUES (114, 'Henri Charriere');
INSERT INTO author (AuthorID, AuthorName) VALUES (115, 'Mark Hebden');
INSERT INTO author (AuthorID, AuthorName) VALUES (116, 'Stephen Mogridge');
INSERT INTO author (AuthorID, AuthorName) VALUES (117, 'Scott Turow');
INSERT INTO author (AuthorID, AuthorName) VALUES (118, 'Len Smith');
INSERT INTO author (AuthorID, AuthorName) VALUES (119, 'Bud Sagendorf');
INSERT INTO author (AuthorID, AuthorName) VALUES (120, 'Tom Sharpe');
INSERT INTO author (AuthorID, AuthorName) VALUES (121, 'William Diehl');
INSERT INTO author (AuthorID, AuthorName) VALUES (122, 'J. J. Fortune');
INSERT INTO author (AuthorID, AuthorName) VALUES (123, 'William Johnston');
INSERT INTO author (AuthorID, AuthorName) VALUES (124, 'Philip Friedman');
INSERT INTO author (AuthorID, AuthorName) VALUES (125, 'Peter Whalley');
INSERT INTO author (AuthorID, AuthorName) VALUES (126, 'Busybee');
INSERT INTO author (AuthorID, AuthorName) VALUES (127, 'Laura Lee Hope');
INSERT INTO author (AuthorID, AuthorName) VALUES (128, 'Trevanian');
INSERT INTO author (AuthorID, AuthorName) VALUES (129, 'Neil Ardley');
INSERT INTO author (AuthorID, AuthorName) VALUES (130, 'E. Phillips Oppenheim');
INSERT INTO author (AuthorID, AuthorName) VALUES (131, 'David Peters');
INSERT INTO author (AuthorID, AuthorName) VALUES (132, 'Todd Johnson');
INSERT INTO author (AuthorID, AuthorName) VALUES (133, 'Jovial Bob Stine');
INSERT INTO author (AuthorID, AuthorName) VALUES (134, 'Agnes Miall');
INSERT INTO author (AuthorID, AuthorName) VALUES (135, 'George Lucas');
INSERT INTO author (AuthorID, AuthorName) VALUES (136, 'Donald F. Glut');
INSERT INTO author (AuthorID, AuthorName) VALUES (137, 'James Kahn');
INSERT INTO author (AuthorID, AuthorName) VALUES (138, 'Jack Roberts');
INSERT INTO author (AuthorID, AuthorName) VALUES (139, 'Charles Gale');
INSERT INTO author (AuthorID, AuthorName) VALUES (140, 'Robert Mayer');
INSERT INTO author (AuthorID, AuthorName) VALUES (141, 'Victor Ulojiofor');
INSERT INTO author (AuthorID, AuthorName) VALUES (142, 'Charles Heath');
INSERT INTO author (AuthorID, AuthorName) VALUES (143, 'Max Hart');
INSERT INTO author (AuthorID, AuthorName) VALUES (144, 'William Rotsler');
INSERT INTO author (AuthorID, AuthorName) VALUES (145, 'Mark Twain');
INSERT INTO author (AuthorID, AuthorName) VALUES (146, 'Malcolm Saville');
INSERT INTO author (AuthorID, AuthorName) VALUES (147, 'Michael Connelly');
INSERT INTO author (AuthorID, AuthorName) VALUES (148, 'David Morrell');
INSERT INTO author (AuthorID, AuthorName) VALUES (149, 'Lois McCoy');
INSERT INTO author (AuthorID, AuthorName) VALUES (150, 'Floyd McCoy');
INSERT INTO author (AuthorID, AuthorName) VALUES (151, 'M. Masters');
INSERT INTO author (AuthorID, AuthorName) VALUES (152, 'E. W. Hildick');
INSERT INTO author (AuthorID, AuthorName) VALUES (153, 'Erle Stanley Gardner');
INSERT INTO author (AuthorID, AuthorName) VALUES (154, 'Michael Bywater');
INSERT INTO author (AuthorID, AuthorName) VALUES (155, 'Robert Farr');
INSERT INTO author (AuthorID, AuthorName) VALUES (156, 'Larry Collins');
INSERT INTO author (AuthorID, AuthorName) VALUES (157, 'Dominique Lapierre');
INSERT INTO author (AuthorID, AuthorName) VALUES (158, 'Stanley Pottinger');
INSERT INTO author (AuthorID, AuthorName) VALUES (159, 'Robin Moore');
INSERT INTO author (AuthorID, AuthorName) VALUES (160, 'Mario Puzo');
INSERT INTO author (AuthorID, AuthorName) VALUES (161, 'Bruce Sterling');
INSERT INTO author (AuthorID, AuthorName) VALUES (162, 'Franklin W. Dixon');
INSERT INTO author (AuthorID, AuthorName) VALUES (163, 'Hilda Boden');
INSERT INTO author (AuthorID, AuthorName) VALUES (164, 'Oscar Wilde');
INSERT INTO author (AuthorID, AuthorName) VALUES (165, 'George Dawes Green');
INSERT INTO author (AuthorID, AuthorName) VALUES (166, 'C. S. Lewis');
INSERT INTO author (AuthorID, AuthorName) VALUES (167, 'Frances Hodgson Burnett');
INSERT INTO author (AuthorID, AuthorName) VALUES (168, 'Michael Avallone');
INSERT INTO author (AuthorID, AuthorName) VALUES (169, 'Carolyn Keene');
INSERT INTO author (AuthorID, AuthorName) VALUES (170, 'Edgar Wallace');
INSERT INTO author (AuthorID, AuthorName) VALUES (171, 'A. J. Quinnell');
INSERT INTO author (AuthorID, AuthorName) VALUES (172, 'Anthony Hope');
INSERT INTO author (AuthorID, AuthorName) VALUES (173, 'Natalie Barkas');
INSERT INTO author (AuthorID, AuthorName) VALUES (174, 'Craig Holden');
INSERT INTO author (AuthorID, AuthorName) VALUES (175, 'T. C. Bridges');
INSERT INTO author (AuthorID, AuthorName) VALUES (176, 'Louis Masterson');
INSERT INTO author (AuthorID, AuthorName) VALUES (177, 'G. P. Jordan');
INSERT INTO author (AuthorID, AuthorName) VALUES (178, 'M. Wiss');
INSERT INTO author (AuthorID, AuthorName) VALUES (179, 'Peter Straub');
INSERT INTO author (AuthorID, AuthorName) VALUES (180, 'Shaun Hutson');
INSERT INTO author (AuthorID, AuthorName) VALUES (181, 'M. V. Carey');
INSERT INTO author (AuthorID, AuthorName) VALUES (182, 'Robert Arthur');
INSERT INTO author (AuthorID, AuthorName) VALUES (183, 'Nick West');
INSERT INTO author (AuthorID, AuthorName) VALUES (184, 'Michael Poole');
INSERT INTO author (AuthorID, AuthorName) VALUES (185, 'Alistair MacLean');
INSERT INTO author (AuthorID, AuthorName) VALUES (186, 'Phyllis Naylor');
INSERT INTO author (AuthorID, AuthorName) VALUES (187, 'Thomas Hughes');
INSERT INTO author (AuthorID, AuthorName) VALUES (188, 'Victor Appleton');
INSERT INTO author (AuthorID, AuthorName) VALUES (189, 'Ellen Feldman');
INSERT INTO author (AuthorID, AuthorName) VALUES (190, 'Irvine Welsh');
INSERT INTO author (AuthorID, AuthorName) VALUES (191, 'Robert L. Stevenson');
INSERT INTO author (AuthorID, AuthorName) VALUES (192, 'Tibor Fischer');
INSERT INTO author (AuthorID, AuthorName) VALUES (193, 'Tim Sullivan');
INSERT INTO author (AuthorID, AuthorName) VALUES (194, 'Ellery Queen');
INSERT INTO author (AuthorID, AuthorName) VALUES (195, 'Wilbur Smith');
INSERT INTO author (AuthorID, AuthorName) VALUES (196, 'Brian Livingston');
INSERT INTO author (AuthorID, AuthorName) VALUES (197, 'Davis Straub');
INSERT INTO author (AuthorID, AuthorName) VALUES (198, 'Charles M. Schulz');
INSERT INTO author (AuthorID, AuthorName) VALUES (199, 'Alan Arnold');
INSERT INTO author (AuthorID, AuthorName) VALUES (200, 'Gerald Frow');