petstore.sql

仿照著名的petstore写的网上书店

INSERT INTO SellerContactInfo VALUES('49', 'McClanahan', 'Craig', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('50', 'Murray', 'Greg', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('51', 'Brydon', 'Sean', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('52', 'Singh', 'Inderjeet', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('53', 'Basler', 'Mark', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('54', 'Yoshida', 'Yutaka', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('55', 'Kangath', 'Smitha', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('56', 'Freeman', 'Larry', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('57', 'Kaul', 'Jeet', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('58', 'Burns', 'Ed', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('59', 'McClanahan', 'Craig', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('60', 'Murray', 'Greg', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('61', 'Brydon', 'Sean', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('62', 'Singh', 'Inderjeet', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('63', 'Basler', 'Mark', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('64', 'Yoshida', 'Yutaka', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('65', 'Kangath', 'Smitha', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('66', 'Freeman', 'Larry', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('67', 'Kaul', 'Jeet', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('68', 'Burns', 'Ed', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('69', 'McClanahan', 'Craig', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('70', 'Murray', 'Greg', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('71', 'Brydon', 'Sean', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('72', 'Singh', 'Inderjeet', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('73', 'Basler', 'Mark', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('74', 'Yoshida', 'Yutaka', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('75', 'Kangath', 'Smitha', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('76', 'Freeman', 'Larry', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('77', 'Kaul', 'Jeet', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('78', 'Burns', 'Ed', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('79', 'McClanahan', 'Craig', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('80', 'Murray', 'Greg', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('81', 'Brydon', 'Sean', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('82', 'Singh', 'Inderjeet', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('83', 'Basler', 'Mark', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('84', 'Yoshida', 'Yutaka', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('85', 'Kangath', 'Smitha', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('86', 'Freeman', 'Larry', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('87', 'Kaul', 'Jeet', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('88', 'Burns', 'Ed', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('89', 'McClanahan', 'Craig', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('90', 'Murray', 'Greg', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('91', 'Brydon', 'Sean', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('92', 'Singh', 'Inderjeet', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('93', 'Basler', 'Mark', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('94', 'Yoshida', 'Yutaka', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('95', 'Kangath', 'Smitha', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('96', 'Freeman', 'Larry', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('97', 'Kaul', 'Jeet', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('98', 'Burns', 'Ed', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('99', 'McClanahan', 'Craig', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('100', 'Murray', 'Greg', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('101', 'Brydon', 'Sean', '[e-mail]');
INSERT INTO SellerContactInfo VALUES('102', 'Singh', 'Inderjeet', '[e-mail]');

INSERT INTO item VALUES('1', 'feline01', 'You Can Heal Your Life (Gift Edition) ', 'by Louise Hay and Joan Perrin Falquet (Turtleback - Sep 1999)','images/anthony-s.jpg','images/anthony-s.jpg', 30.10,'1','1', 15, 3, 0);
INSERT INTO item VALUES('2', 'feline01', 'Publication Manual of the American Psychological Association ', 'by American Psychological Association (Paperback - Jul 2001).', 'images/bailey-s.jpg','images/bailey-s.jpg', 37,'2','2', 15, 5, 0);
INSERT INTO item VALUES('3', 'feline02', 'The Vaccine Book: Making the Right Decision for Your Child (Sears Parenting Library ) ', 'by Robert Sears ', 'images/bob-s.jpg','images/bob-s.jpg', 37.20,'3','3', 15, 7, 0);
INSERT INTO item VALUES('4', 'feline02', 'The Brain That Changes Itself: Stories of Personal Triumph from the Frontiers of Brain Science (James H. Silberman Books) ', 'by Norman Doidge (Hardcover - Mar 15, 2007)', 'images/chantelle-s.jpg','images/chantelle-s.jpg', 37.30,'4','4', 15, 5, 0);
INSERT INTO item VALUES('5', 'feline01', 'The China Study: The Most Comprehensive Study of Nutrition Ever Conducted and the Startling Implications for Diet, Weight Loss and Long-Term Health ', 'by T. Colin Campbell and Thomas M. Campbell (Hardcover - Jan 1, 2005)', 'images/charlie-s.jpg','images/charlie-s.jpg', 37,'5','5', 15, 5, 0);
INSERT INTO item VALUES('6', 'feline02', 'The Sanford Guide to Antimicrobial Therapy, 2008 ', 'by David N. Gilbert, Robert C. Moellering Jr., George M. Eliopoulos, and Merle A. Sande (Paperback - April 30, 2008)', 'images/elkie-s.jpg','images/elkie-s.jpg', 37.40,'6','6', 15, 5, 0);
INSERT INTO item VALUES('7', 'feline01', 'Bonk: The Curious Coupling of Science and Sex ', 'by Mary Roach (Hardcover - April 7, 2008)', 'images/faith-s.jpg','images/faith-s.jpg', 307,'7','7', 15, 5, 0);
INSERT INTO item VALUES('8', 'feline01', 'Diagnostic and Statistical Manual of Mental Disorders DSM-IV-TR Fourth Edition (Text Revision)  ', 'by American Psychiatric Association (Paperback - Jun 2000)', 'images/gaetano-s.jpg','images/gaetano-s.jpg', 37.50,'8','8', 15, 15, 0);
INSERT INTO item VALUES('9', 'feline02', 'The Singularity Is Near: When Humans Transcend Biology  ', 'by Ray Kurzweil (Hardcover - Sep 22, 2005)', 'images/harmony-s.jpg','images/harmony-s.jpg', 37,'9','9', 15, 3, 0);
INSERT INTO item VALUES('10', 'feline02', 'Codependent No More  ', 'by Melody Beattie (Audio CD - Jan 2006)', 'images/katzen-s.jpg','images/katzen-s.jpg', 37.60,'10','10', 15, 5, 0);
INSERT INTO item VALUES('11', 'feline02', 'Musicophilia: Tales of Music and the Brain   ', 'by Oliver Sacks (Paperback - Sep 28, 2008)', 'images/mario-s.jpg','images/mario-s.jpg', 37,'11','11', 15, 10, 0);
INSERT INTO item VALUES('12', 'feline01', 'How Doctors Think   ', 'by Jerome Groopman (Paperback - Mar 12, 2008)', 'images/mimi-s.jpg','images/mimi-s.jpg', 37.70,'12','12', 15, 4, 0);
INSERT INTO item VALUES('13', 'feline01', 'Biology  ', 'by Neil A. Campbell and Jane B. Reece (Hardcover - Dec 23, 2004)', 'images/monique-s.jpg','images/monique-s.jpg', 37.80,'13','13', 15, 8, 0);
INSERT INTO item VALUES('14', 'feline01', ' Mayo Clinic Guide to a Healthy Pregnancy  ', 'by Mayo Clinic (Paperback - April 13, 2004)', 'images/olie-s.jpg','images/olie-s.jpg', 37.90,'14','14', 15, 3, 0);
INSERT INTO item VALUES('15', 'feline01', ' Taking Charge of Your Fertility, 10th Anniversary Edition: The Definitive Guide to Natural Birth Control, Pregnancy Achievement, and Reproductive Health  ', 'by Toni Weschler (Paperback - Oct 31, 2006)', 'images/paris-s.jpg','images/paris-s.jpg', 37,'15','15', 15, 4, 0);
INSERT INTO item VALUES('16', 'feline01', 'Tarascon Pocket Pharmacopoeia 2008 Classic Shirt-pocket Edition (Tarascon Pocket Pharmacopoeia) (Tarascon Pocket Pharmacopoeia)', 'by Steven M. Green (Paperback - Nov 1, 2007)', 'images/princess-s.jpg','images/princess-s.jpg', 37,'16','16', 15, 5, 0);
INSERT INTO item VALUES('17', 'feline02', 'Panic in Level 4: Cannibals, Killer Viruses, and Other Journeys to the Edge of Science', 'by Richard Preston (Hardcover - May 27, 2008)', 'images/simba-s.jpg','images/simba-s.jpg', 37,'17','17', 15, 3, 0);
INSERT INTO item VALUES('18', 'feline02', 'The Trigger Point Therapy Workbook: Your Self-Treatment Guide for Pain Relief, Second Edition ', 'by Clair Davies, Amber Davies, and David G. Simons (Paperback - Jul 2004)', 'images/thaicat-s.jpg','images/thaicat-s.jpg', 37,'18','18', 15, 5, 0);
INSERT INTO item VALUES('19', 'feline01', 'Taber Cyclopedic Medical Dictionary  ', 'by Donald Venes (Hardcover - Feb 14, 2005)', 'images/cat1.gif','images/cat1.gif', 37,'19','19', 15, 6, 0);
INSERT INTO item VALUES('20', 'feline01', 'Prevent and Reverse Heart Disease', 'by Caldwell B. Esselstyn (Hardcover - Feb 1, 2007)', 'images/cat2.gif','images/cat2.gif', 20,'20','20', 15, 3, 0);
INSERT INTO item VALUES('21', 'feline01', ' Spark: The Revolutionary New Science of Exercise and the Brain ', 'by John J. Ratey and Eric Hagerman (Hardcover - Jan 10, 2008)', 'images/cat3.gif','images/cat3.gif', 30,'21','21', 15, 3, 0);
INSERT INTO item VALUES('22', 'feline01', ' Pocket Medicine (Pocket Notebook)  ', 'by Marc S. Sabatine (Ring-bound - Feb 15, 2000)', 'images/cat4.gif','images/cat4.gif', 17,'22','22', 15, 9, 0);
INSERT INTO item VALUES('23', 'feline01', 'Strength Training Anatomy  ', 'by Frederic Delavier (Paperback - Nov 4, 2005)', 'images/cat5.gif','images/cat5.gif', 37, '23','23', 15, 5, 0);
INSERT INTO item VALUES('24', 'feline02', 'Our Daily Meds: How the Pharmaceutical Companies Transformed Themselves into Slick Marketing Machines and Hooked the Nation on Prescription Drugs ', 'by Melody Petersen (Hardcover - Mar 18, 2008)', 'images/cat7.gif','images/cat7.gif', 19, '24','24', 15, 3, 0);
INSERT INTO item VALUES('25', 'feline02', 'Eat to Live: The Revolutionary Formula for Fast and Sustained Weight Loss ', 'by Joel Fuhrman and Mehmet C. Oz (Hardcover - Jan 2, 2003)', 'images/cat8.gif', 'images/cat8.gif', 19,'25','25', 15, 8, 0); 
INSERT INTO item VALUES('26', 'feline02', 'Pain Free: A Revolutionary Method for Stopping Chronic Pain ', 'by Pete Egoscue and Roger Gittines (Paperback - Feb 29, 2000)', 'images/cat9.gif','images/cat9.gif', 303,'26','26', 15, 14, 0);
INSERT INTO item VALUES('27', 'feline02', 'From Belly Fat to Belly Flat', 'by C.W. Randolph M.D. and Genie James (Paperback - Nov 27, 2007)', 'images/cat10.gif', 'images/cat10.gif', 27,'27','27', 15, 14, 0);
INSERT INTO item VALUES('28', 'feline02', ' MLA Handbook for Writers of Research Papers Sixth Edition  ', 'by Joseph Gibaldi (Paperback - May 2003)', 'images/cat11.gif', 'images/cat11.gif', 23,'28','28', 15, 5, 0);
INSERT INTO item VALUES('29', 'feline02', 'Saunders Comprehensive Review for the NCLEX-RN? Examination (Saunders Comprehensive Review for Nclex-Rn) ', 'by Linda Anne Silvestri (Paperback - Oct 23, 2007)', 'images/cat12.gif', 'images/cat12.gif', 33,'29','29', 15, 5, 0);

INSERT INTO item VALUES('100', 'canine02', 'The Post-American World ', 'Veteran newsman and Meet the Press moderator Tim Russert is known for his direct and unpretentious style and in this charming memoir he explains why', 'images/biscuit-s.jpg','images/biscuit-s.jpg', 10,'30','30', 15, 3, 0);
INSERT INTO item VALUES('101', 'canine01', 'The World Is Flat 3.0: A Brief History of the Twenty-first Century ', 'This work is a companion to Russerts memoir of his father, BIG RUSS AND ME', 'images/harrison-s.jpg','images/harrison-s.jpg', 25,'31','31', 15, 5, 0);
INSERT INTO item VALUES('102', 'canine01', ' The Elements of Style With Index  ', 'Stephenie Meyer graduated from Brigham Young University with a degree in English Literature, and she lives with her husband and three young sons in Arizona', 'images/honey-s.jpg','images/honey-s.jpg', 25,'32','32', 20, 5, 0);
INSERT INTO item VALUES('103', 'canine01', 'Kitchen Confidential ', 'My dog is full on energy and intensity. He needs a constant challenge to keep him happy. Great for a farm or house in the country. Bring him to work with you.', 'images/hunter-s.jpg','images/hunter-s.jpg', 50,'33','33', 15, 5, 0);
INSERT INTO item VALUES('104', 'canine02', 'The Singularity Is Near: When Humans Transcend Biology ', 'This old geezer just wants to sleep at your feet. Slip him some food under the table and watch him wag his tail. Great dog for someone who retired before the dot-com bubble burst. A partner to loaf with.', 'images/jack-s.jpg','images/jack-s.jpg', 25,'34','34', 15, 7, 0);
INSERT INTO item VALUES('105', 'canine01', 'Spycraft: The Secret History of the CIAs Spytechs, from Communism to al-Qaeda ', 'This spunky little book is packed with great characters, fast-paced action, and a good deal of humor', 'images/lady-s.jpg','images/lady-s.jpg', 20,'35','35', 15, 5, 0);
INSERT INTO item VALUES('106', 'canine01', ' The Selfish Gene   ', 'This debut essay collection is full of sardonic wit and charm, and Crosley effortlessly transforms what could have been stereotypical tales of mid-20s life ', 'images/maggie-s.jpg','images/maggie-s.jpg', 40,'36','36', 15, 3, 0);
INSERT INTO item VALUES('107', 'canine01', 'The Art Of War ', 'Readers will thrill to Ilyana Kadushins elegant narration of NEW MOON, sequel to TWILIGHT.', 'images/marianna-s.jpg','images/marianna-s.jpg', 50,'37','37', 15, 7, 0);
INSERT INTO item VALUES('108', 'canine02', 'The Pixar Touch: The Making of a Company ', 'Adult/High School–Senator McCain approaches the investigation of courage from a position of unease at how diluted a commodity it has become in our society', 'images/puppup-s.jpg','images/puppup-s.jpg', 9,'38','38', 15, 6, 0);
INSERT INTO item VALUES('109', 'canine01', 'The Dumbest Generation: How the Digital Age Stupefies Young Americans and Jeopardizes Our Future  ', 'An equally compelling journey is Jim Nantz’s Always By My Side: A Father’s Grace and a Sports Journey Unlike Any Other. ', 'images/rita-s.jpg','images/rita-s.jpg', 25,'39','39', 15, 9, 0);
INSERT INTO item VALUES('110', 'canine02', 'The Great Bridge: The Epic Story of the Building of the Brooklyn Bridge ', 'McCain, with help from his administrative assistant Salter, picks up where the bestselling Faith of My Fathers left off, after his release from a North Vietnamese POW prison', 'images/sabrina-s.jpg','images/sabrina-s.jpg', 79,'40','40', 15, 5, 0);
INSERT INTO item VALUES('111', 'canine01', 'Reinventing Collapse: The Soviet Example and American Prospects ', 'When Senator Robert F. Kennedy entered the presidential race during the chaotic year of 1968, anarchy appeared to be gathering on the horizon.', 'images/thaidog-s.jpg','images/thaidog-s.jpg', 10,'41','41', 15, 3, 0);
INSERT INTO item VALUES('112', 'canine01', 'The Second World: Empires and Influence in the New Global Order ', 'She has never fit into the human world and has always felt she is destined for something else. ', 'images/dog1.gif','images/dog1.gif', 20,'42','42', 15, 9, 0);
INSERT INTO item VALUES('113', 'canine01', 'The House of the Scorpion ', 'When bodacious bounty hunter Stephanie Plum goes to her ex-husbands apartment, she finds blood stains on the carpet and suspects hes either dead or kidnapped.', 'images/dog2.gif','images/dog2.gif', 70,'43','43', 15, 11, 0);
INSERT INTO item VALUES('114', 'canine01', 'The Path Between the Seas: The Creation of the Panama Canal, 1870-1914 ', 'A great young pet in need of training.', 'images/dog3.gif','images/dog3.gif', 31,'44','44', 15, 5, 0);
INSERT INTO item VALUES('115', 'canine02', 'The Renewable Energy Handbook: A Guide to Rural Energy Independence, Off-Grid and Sustainable Living ', 'This scrapy woofer needs some clean up and some lessons. Help him out and take him home.', 'images/dog4.gif','images/dog4.gif', 41,'45','45', 15, 5, 0);
INSERT INTO item VALUES('116', 'canine02', 'Solar Power Your Home For Dummies- ', 'This spunky little book is packed with great characters, fast-paced action, and a good deal of humor', 'images/dog5.gif', 'images/dog5.gif', 20,'46','46', 15, 3, 0);
INSERT INTO item VALUES('117', 'canine02', '  Earth: The Sequel: The Race to Reinvent Energy and Stop Global Warming   ', 'ssay collection is full of sardonic wit and charm, and Crosley effortlessly transforms what could have been stereotypical tales of mid-20s life', 'images/dog6.gif', 'images/dog6.gif', 20,'47','47', 15, 5, 0);

INSERT INTO item VALUES('201', 'avian01', 'Three Cups of Tea: One Mans Mission to Promote Peace . . . One School at a Time ', 'When it comes to lying, tone of voice is the best way we can tell. It was the exact right choice to have President Bushs former White House press secretary read his own book.', 'images/parrot-popcorn-s.jpg', 'images/parrot-popcorn-s.jpg', 25,'48','48', 15, 5, 0);
INSERT INTO item VALUES('202', 'avian01', 'Skinny Bitch: A No-Nonsense, Tough-Love Guide for Savvy Girls Who Want to Stop Eating Crap and Start Looking Fabulous ', 'Starred Review. United in their obsession with a grisly Italian serial murder case almost three decades old', 'images/eclectus-female-thumb.jpg', 'images/eclectus-female-thumb.jpg', 25,'49','49', 15, 5, 0);
INSERT INTO item VALUES('203', 'avian01', 'Lone Survivor: The Eyewitness Account of Operation Redwing and the Lost Heroes of SEAL Team 10 ', 'After the Iraq war, Fareed Zakaria argued in his Newsweek column that the worlds new organizing principle was pro- or anti-Americanism. ', 'images/galah-parrot-thumb.jpg', 'images/galah-parrot-thumb.jpg', 90,'50','50', 15, 3, 0);
INSERT INTO item VALUES('204', 'avian02', 'The Man Who Loved China: The Fantastic Story of the Eccentric Scientist Who Unlocked the Mysteries of the Middle Kingdom ', 'In The Prosecution of George W. Bush for Murder, Bugliosi presents a tight, meticulously researched legal case that puts George W. Bush on trial in an American courtroom for the murder of nearly 4,000 American soldiers fighting the war in Iraq.', 'images/kookaburra-thumb.jpg', 'images/kookaburra-thumb.jpg', 10,'51','51', 15, 5, 0);
INSERT INTO item VALUES('205', 'avian02', 'Faith of My Fathers ', 'If you are looking for a true story that showcases both American heroism and Afghani humanity, Marcus Luttrells Lone Survivor', 'images/lovebird-thumb.jpg', 'images/lovebird-thumb.jpg', 75,'52','52', 15, 7, 0);
INSERT INTO item VALUES('206', 'avian02', 'Retribution: The Battle for Japan, 1944-45 ', 'The titular bottle, from a cache of allegedly fine, allegedly French wine, allegedly owned by Thomas Jefferson in the 1780s, set a record price when auctioned in 1985.', 'images/peacock-blue-thumb.jpg', 'images/peacock-blue-thumb.jpg', 55,'53','53', 15, 10, 0);
INSERT INTO item VALUES('207', 'avian01', 'Escape from the Deep: A Legendary Submarine and Her Courageous Crew ', 'Were World Wars I and II—which can now be seen as a thirty-year paroxysm of slaughter and destruction—inevitable? ', 'images/peacock-thumb.jpg', 'images/peacock-thumb.jpg', 65,'54','54', 15, 5, 0);
INSERT INTO item VALUES('208', 'avian01', 'The Coldest Winter: America and the Korean War ', 'Were World Wars I and II—which can now be seen as a thirty-year paroxysm of slaughter and destruction—inevitable? ', 'images/peakcock-white-thumb.jpg', 'images/peacock-white-thumb.jpg', 15,'55','55', 15, 3, 0);
INSERT INTO item VALUES('209', 'avian02', 'Anne Frank: The Diary of a Young Girl - The Definitive Edition', 'When it comes to lying, tone of voice is the best way we can tell. ', 'images/rainbow-lorikeet-thumb.jpg', 'images/rainbow-lorikeet-thumb.jpg', 29,'56','56', 15, 5, 0);
INSERT INTO item VALUES('210', 'avian02', 'Peony in Love: A Novel ', 'If you are looking for a true story that showcases both American heroism and Afghani humanity', 'images/eagle-stone-thumb.jpg', 'images/eagle-stone-thumb.jpg', 80,'57','57', 15, 10, 0);
INSERT INTO item VALUES('211', 'avian01', 'The Post-American World ', 'Veteran newsman and Meet the Press moderator Tim Russert is known for his direct and unpretentious style and in this charming memoir he explains why', 'images/biscuit-s.jpg','images/biscuit-s.jpg', 10,'30','30', 15, 3, 0);
INSERT INTO item VALUES('212', 'avian01', 'The World Is Flat 3.0: A Brief History of the Twenty-first Century ', 'This work is a companion to Russerts memoir of his father, BIG RUSS AND ME', 'images/harrison-s.jpg','images/harrison-s.jpg', 25,'31','31', 15, 5, 0);
INSERT INTO item VALUES('213', 'avian01', ' The Elements of Style With Index  ', 'Stephenie Meyer graduated from Brigham Young University with a degree in English Literature, and she lives with her husband and three young sons in Arizona', 'images/honey.jpg','images/honey-s.jpg', 25,'32','32', 20, 5, 0);
INSERT INTO item VALUES('214', 'avian01', 'The Path Between the Seas: The Creation of the Panama Canal, 1870-1914 ', 'This spunky little book is packed with great characters, fast-paced action, and a good deal of humor', 'images/dog3.gif','images/dog3.gif', 31,'44','44', 15, 5, 0);
INSERT INTO item VALUES('215', 'avian02', 'The Renewable Energy Handbook: A Guide to Rural Energy Independence, Off-Grid and Sustainable Living ', 'This spunky little book is packed with great characters, fast-paced action, and a good deal of humor', 'images/dog4.gif','images/dog4.gif', 41,'45','45', 15, 5, 0);
INSERT INTO item VALUES('216', 'avian02', 'Spycraft: The Secret History of the CIAs Spytechs, from Communism to al-Qaeda ', 'This spunky little book is packed with great characters, fast-paced action, and a good deal of humor', 'images/lady-s.jpg','images/lady-s.jpg', 20,'35','35', 15, 5, 0);
INSERT INTO item VALUES('217', 'avian02', ' The Selfish Gene   ', 'This debut essay collection is full of sardonic wit and charm, and Crosley effortlessly transforms what could have been stereotypical tales of mid-20s life ', 'images/maggie-s.jpg','images/maggie-s.jpg', 40,'36','36', 15, 3, 0);
INSERT INTO item VALUES('218', 'avian02', 'The Art Of War ', 'Readers will thrill to Ilyana Kadushins elegant narration of NEW MOON, sequel to TWILIGHT.', 'images/marianna-s.jpg','images/marianna-s.jpg', 50,'37','37', 15, 7, 0);
INSERT INTO item VALUES('219', 'avian02', 'The Pixar Touch: The Making of a Company ', 'Adult/High School–Senator McCain approaches the investigation of courage from a position of unease at how diluted a commodity it has become in our society', 'images/puppup-s.jpg','images/puppup-s.jpg', 9,'38','38', 15, 6, 0);

INSERT INTO item VALUES('301', 'fish02', 'The 4-Hour Workweek: Escape 9-5, Live Anywhere, and Join the New Rich ', 'The Eyewitness Account of Operation Redwing and the Lost Heroes of SEAL Team 10 ', 'images/spotted-jellyfish-thumb.jpg','images/spotted-jellyfish-thumb.jpg', 55,'69','69', 15, 5, 0);
INSERT INTO item VALUES('302', 'fish01', 'Brain Rules: 12 Principles for Surviving and Thriving at Work, Home, and School ', 'When bodacious bounty hunter Stephanie Plum goes to her ex-husbands apartment', 'images/sea-nettle-jellyfish-thumb.jpg','images/sea-nettle-jellyfish-thumb.jpg', 75,'70','70', 15, 5, 0);
INSERT INTO item VALUES('303', 'fish02', 'Getting Things Done: The Art of Stress-Free Productivity ', 'The Creation of the Panama Canal, 1870-1914', 'images/rockfish-med.jpg','images/rockfish-thumb.jpg', 125,'71','71', 15, 5, 0);
INSERT INTO item VALUES('304', 'fish01', 'StrengthsFinder 2.0: A New and Upgraded Edition of the Online Test from Gallups Now, Discover Your Strengths ', 'She has never fit into the human world and has always felt she is destined for something else', 'images/purple-jellyfish-thumb.jpg','images/purple-jellyfish-thumb.jpg', 25,'72','72', 15, 5, 0);
INSERT INTO item VALUES('305', 'fish01', 'The 7 Habits of Highly Effective People ', 'This spunky little book is packed with great characters, fast-paced action, and a good deal of humor', 'images/octopus-white-thumb.jpg','images/octopus-white-thumb.jpg', 20,'73','73', 15, 5, 0);