petstore.sql

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

INSERT INTO item VALUES('306', 'fish02', 'Rich Dad, Poor Dad (Rich Dad)', 'This spunky little book is packed with great characters, fast-paced action, and a good deal of humor', 'images/octopus-red-thumb.jpg','images/octopus-red-thumb.jpg', 20,'74','74', 15, 5, 0);
INSERT INTO item VALUES('307', 'fish01', '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('308', 'fish01', '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('309', 'fish01', '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('310', 'fish01', '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('311', 'fish01', '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('312', 'fish02', '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('313', 'fish02', ' 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('314', 'fish01', '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('315', 'fish02', '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('316', 'fish02', '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('317', 'fish02', ' 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('318', 'fish01', '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('319', 'fish01', '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('401', 'reptile01', 'The Artists Way', 'A thorough, informative, and up-to-date reference on green, sustainable and energy-efficient home construction that clarifies definitions of green and sustainable ', 'images/hawaiian-lizard-thumb.jpg','images/hawaiian-lizard-thumb.jpg', 10,'84','84', 15, 5, 0);
INSERT INTO item VALUES('402', 'reptile01', 'Things I have learned in my life so far', 'Scott Kelby is Editor-in-Chief of Photoshop User magazine, President of the National Association of Photoshop Professionals', 'images/african-spurred-tortoise-thumb.jpg','images/african-spurred-tortoise-thumb.jpg', 30,'85','85', 15, 3, 0);
INSERT INTO item VALUES('403', 'reptile01', 'Wall and Piece ', 'Robert Frank discussed with his publisher, Gerhard Steidl, the idea of producing a new edition using modern scanning and the finest tritone printing.', 'images/box-turtle-thumb.jpg','images/box-turtle-thumb.jpg', 50,'86','86', 15, 4, 0);
INSERT INTO item VALUES('404', 'reptile02', 'New Drawing on the Right Side of the Brain Workbook: Guided Practice in the Five Basic Skills of Drawing', 'Have you unpacked your new Nikon D300 digital SLR camera and want to get started right away taking professional quality pictures?', 'images/mexican-redkneed-tarantula-thumb.jpg','images/mexican-redkneed-tarantula-thumb.jpg', 50,'87','87', 15, 5, 0);
INSERT INTO item VALUES('405', 'reptile02', 'Bob Dylan: The Drawn Blank Series ', 'If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store', 'images/box-turtle2-thumb.jpg','images/box-turtle2-thumb.jpg', 50,'88','88', 15, 4, 0);
INSERT INTO item VALUES('406', 'reptile02', 'The Principles of Uncertainty', 'Bryan Peterson, a professional photographer, is the author of Understanding Exposure, Beyond Portraiture, Learning to See Creatively, and Understanding Digital Photography.', 'images/california-desert-tortoise-thumb.jpg','images/california-desert-tortoise-thumb.jpg', 59,'89','89', 15, 3, 0);
INSERT INTO item VALUES('407', 'reptile01', '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('408', 'reptile01', '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('409', 'reptile01', '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('410', 'reptile01', '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('411', 'reptile01', '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('412', 'reptile01', '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('413', 'reptile02', ' 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('414', 'reptile02', '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('415', 'reptile01', '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('416', 'reptile02', '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('417', 'reptile02', ' 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('418', 'reptile02', '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('419', 'reptile02', '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 tag VALUES(1,'awesome',5);
INSERT INTO tag VALUES(2,'interesting',2);
INSERT INTO tag VALUES(3,'cool',10);
INSERT INTO tag VALUES(4,'excellent',20);
INSERT INTO tag VALUES(5,'fun',20);
INSERT INTO tag VALUES(6,'worthless',4);
INSERT INTO tag VALUES(7,'superior',10);
INSERT INTO tag VALUES(8,'inferior',4);

INSERT INTO tag_item VALUES(1, '1');
INSERT INTO tag_item VALUES(1, '2');
INSERT INTO tag_item VALUES(1, '3');
INSERT INTO tag_item VALUES(1, '4');
INSERT INTO tag_item VALUES(1, '5');
INSERT INTO tag_item VALUES(2, '1');
INSERT INTO tag_item VALUES(2, '2');
INSERT INTO tag_item VALUES(3, '1');
INSERT INTO tag_item VALUES(3, '2');
INSERT INTO tag_item VALUES(3, '3');
INSERT INTO tag_item VALUES(3, '4');
INSERT INTO tag_item VALUES(3, '5');
INSERT INTO tag_item VALUES(3, '6');
INSERT INTO tag_item VALUES(3, '7');
INSERT INTO tag_item VALUES(3, '8');
INSERT INTO tag_item VALUES(3, '9');
INSERT INTO tag_item VALUES(3, '10');
INSERT INTO tag_item VALUES(4, '8');
INSERT INTO tag_item VALUES(4, '9');
INSERT INTO tag_item VALUES(4, '10');
INSERT INTO tag_item VALUES(4, '11');
INSERT INTO tag_item VALUES(4, '12');
INSERT INTO tag_item VALUES(4, '13');
INSERT INTO tag_item VALUES(4, '14');
INSERT INTO tag_item VALUES(4, '15');
INSERT INTO tag_item VALUES(4, '16');
INSERT INTO tag_item VALUES(4, '17');
INSERT INTO tag_item VALUES(4, '18');
INSERT INTO tag_item VALUES(4, '19');
INSERT INTO tag_item VALUES(4, '20');
INSERT INTO tag_item VALUES(4, '21');
INSERT INTO tag_item VALUES(4, '22');
INSERT INTO tag_item VALUES(4, '23');
INSERT INTO tag_item VALUES(4, '24');
INSERT INTO tag_item VALUES(4, '25');
INSERT INTO tag_item VALUES(4, '26');
INSERT INTO tag_item VALUES(4, '27');
INSERT INTO tag_item VALUES(5, '28');
INSERT INTO tag_item VALUES(5, '29');
INSERT INTO tag_item VALUES(5, '100');
INSERT INTO tag_item VALUES(5, '101');
INSERT INTO tag_item VALUES(5, '102');
INSERT INTO tag_item VALUES(5, '103');
INSERT INTO tag_item VALUES(5, '104');
INSERT INTO tag_item VALUES(5, '105');
INSERT INTO tag_item VALUES(5, '106');
INSERT INTO tag_item VALUES(5, '107');
INSERT INTO tag_item VALUES(5, '108');
INSERT INTO tag_item VALUES(5, '109');
INSERT INTO tag_item VALUES(5, '110');
INSERT INTO tag_item VALUES(5, '111');
INSERT INTO tag_item VALUES(5, '112');
INSERT INTO tag_item VALUES(5, '113');
INSERT INTO tag_item VALUES(5, '114');
INSERT INTO tag_item VALUES(5, '115');
INSERT INTO tag_item VALUES(5, '116');
INSERT INTO tag_item VALUES(5, '117');
INSERT INTO tag_item VALUES(6, '401');
INSERT INTO tag_item VALUES(6, '402');
INSERT INTO tag_item VALUES(6, '403');
INSERT INTO tag_item VALUES(6, '404');
INSERT INTO tag_item VALUES(7, '405');
INSERT INTO tag_item VALUES(7, '406');
INSERT INTO tag_item VALUES(7, '407');
INSERT INTO tag_item VALUES(7, '408');
INSERT INTO tag_item VALUES(7, '409');
INSERT INTO tag_item VALUES(7, '410');
INSERT INTO tag_item VALUES(7, '411');
INSERT INTO tag_item VALUES(7, '412');
INSERT INTO tag_item VALUES(7, '413');
INSERT INTO tag_item VALUES(7, '414');
INSERT INTO tag_item VALUES(8, '415');
INSERT INTO tag_item VALUES(8, '416');
INSERT INTO tag_item VALUES(8, '417');
INSERT INTO tag_item VALUES(8, '418');

INSERT INTO id_gen VALUES('ITEM_ID',419);
INSERT INTO id_gen VALUES('ADDRESS_ID',102);
INSERT INTO id_gen VALUES('CONTACT_INFO_ID',102);
INSERT INTO id_gen VALUES('TAG_ID',8);