use eshop;
insert into supplier  values(10001,'xxxx電子出版社','1','北京xxx路xxx號','','北京','北京','100082','1234567');

insert into category values('001','計算機圖書','最新的計算機圖書');
insert into category values('002','English圖書','英語考試類、普及讀物等');
insert into category values('003','VCD','流行電影,VCD光盤');

INSERT INTO product VALUES ('4512331123','001','使用WSAD開發Web應用','WSAD開發案例，詳細介紹了在WSAD下開發J2EE Web應用的教程');
INSERT INTO product VALUES ('4512331124','001','Webshpere管理參考','管理Webshpere應用服務器的必備書籍');
INSERT INTO product VALUES ('4512331125','001','DB2 參考手冊','管理DB2服務器的必備書籍');
INSERT INTO product VALUES ('1931182140','001','Building Applications with IBM WebSphere Studio and JavaBeans: A Guided Tour','Building Applications with IBM WebSphere Studio and JavaBeans: A Guided Tour');
INSERT INTO product VALUES ('032118579X','001','Enterprise Java Programming with IBM WebSphere, Second Edition','Enterprise Java Programming with IBM WebSphere, Second Edition');
INSERT INTO product VALUES ('0471133051','001','IBM Data Warehousing: With IBM Business Intelligence Tools','IBM Data Warehousing: With IBM Business Intelligence Tools');
INSERT INTO product VALUES ('0201616173','001','Enterprise Java Programming with IBM WebSphere','詳細介紹在WebSphere下開發EJB');
INSERT INTO product VALUES ('0764543660','001','Professional IBM WebSphere 5.0 Application Server','WebSphere 5.0 Application Server專業書籍');
INSERT INTO product VALUES ('0123456789','001','IBM Best Practices for Developing WebSphere based Applications 2002','IBMBest Practices for Developing WebSphere based Applications 2002');
INSERT INTO product VALUES ('1885068921','001','Exploring IBM e-Business Software: Become an Instant Insider on IBM s Internet','Exploring IBM e-Business Software: Become an Instant Insider on IBM s Internet');

INSERT INTO product VALUES ('7505391496','002','大學英語四級考試大全','書中收集了1995年1月至2003年6月，共計18套試題，旨在給讀者提供更多的實踐機會...');
INSERT INTO product VALUES ('750122076X','002','GRE寫作','充分認識GRE作文考試對你提出的嚴峻挑戰，不迷信任何號稱一步登天的捷徑，而是腳踏實地地努力提高自己的綜合素質...');

INSERT INTO product VALUES ('321s12312','003','傲慢與偏見:BBC十六項大獎（6VCD)','奧斯汀傳世經典，英國BBC公司1995年巨制，重現英國十九世紀初社會風貌，優雅的文化，幽默的對白，沁人心脾的愛情……');

insert into item values('04061003a','1931182140',49.2,59.5,10001,'1','精裝圖書','內容介紹：','相關產品：','封面：<img src="http://images.amazon.com/images/P/1931182140.01.MZZZZZZZ.jpg">','評論：');
insert into item values('04061003b','1931182140',45.5,56.5,10001,'1','普通裝圖書','內容介紹：','相關產品：','封面：<img src="http://images.amazon.com/images/P/1931182140.01.MZZZZZZZ.jpg">','評論：');
insert into item values('04061003c','1931182140',30.0,37.5,10001,'1','電子版','內容介紹：','相關產品：','封面：<img src="http://images.amazon.com/images/P/1931182140.01.MZZZZZZZ.jpg">','評論：');

insert into item values('04061004a','032118579X',55.2,66.5,10001,'1','精裝圖書','內容介紹：','相關產品：','封面：<img src="http://images.amazon.com/images/P/032118579X.01.MZZZZZZZ.jpg">','評論：');
insert into item values('04061004b','032118579X',45.2,56.5,10001,'1','普通裝圖書','內容介紹：','相關產品：','封面：<img src="http://images.amazon.com/images/P/032118579X.01.MZZZZZZZ.jpg">','評論：');
insert into item values('04061004c','032118579X',35.2,46.5,10001,'1','電子版','內容介紹：','相關產品：','封面：<img src="http://images.amazon.com/images/P/032118579X.01.MZZZZZZZ.jpg">','評論：');

insert into item values('04061005a','0123456789',39.2,55.5,10001,'1','精裝圖書','內容介紹：','相關產品：','封面：<img src="http://images.amazon.com/images/P/1931182140.01.MZZZZZZZ.jpg">','評論：');
insert into item values('04061005b','0123456789',33.5,45.5,10001,'1','普通裝圖書','內容介紹：','相關產品：','封面：<img src="http://images.amazon.com/images/P/1931182140.01.MZZZZZZZ.jpg">','評論：');
insert into item values('04061005c','0123456789',15.0,27.5,10001,'1','電子版','內容介紹：','相關產品：','封面：<img src="http://images.amazon.com/images/P/1931182140.01.MZZZZZZZ.jpg">','評論：');

insert into item values('04061006a','0201616173',56.2,69.5,10001,'1','精裝圖書','內容介紹：','相關產品：','封面：<img src="http://images.amazon.com/images/P/1931182140.01.MZZZZZZZ.jpg">','評論：');
insert into item values('04061006b','0201616173',47.5,56.5,10001,'1','普通裝圖書','內容介紹：','相關產品：','封面：<img src="http://images.amazon.com/images/P/1931182140.01.MZZZZZZZ.jpg">','評論：');
insert into item values('04061006c','0201616173',32.0,35.5,10001,'1','電子版','內容介紹：','相關產品：','封面：<img src="http://images.amazon.com/images/P/1931182140.01.MZZZZZZZ.jpg">','評論：');

insert into item values('04061007a','4512331123',56.2,69.5,10001,'1','精裝圖書','內容介紹：','相關產品：','封面：<img src="http://images.amazon.com/images/P/1931182140.01.MZZZZZZZ.jpg">','評論：');
insert into item values('04061007b','4512331123',47.5,56.5,10001,'1','普通裝圖書','內容介紹：','相關產品：','封面：<img src="http://images.amazon.com/images/P/1931182140.01.MZZZZZZZ.jpg">','評論：');
insert into item values('04061007c','4512331123',32.0,35.5,10001,'1','電子版','內容介紹：','相關產品：','封面：<img src="http://images.amazon.com/images/P/1931182140.01.MZZZZZZZ.jpg">','評論：');

insert into item values('04061008a','4512331124',56.2,69.5,10001,'1','精裝圖書','內容介紹：','相關產品：','封面：<img src="http://images.amazon.com/images/P/1931182140.01.MZZZZZZZ.jpg">','評論：');
insert into item values('04061008b','4512331124',47.5,56.5,10001,'1','普通裝圖書','內容介紹：','相關產品：','封面：<img src="http://images.amazon.com/images/P/1931182140.01.MZZZZZZZ.jpg">','評論：');
insert into item values('04061008c','4512331124',32.0,35.5,10001,'1','電子版','內容介紹：','相關產品：','封面：<img src="http://images.amazon.com/images/P/1931182140.01.MZZZZZZZ.jpg">','評論：');

insert into item values('04061009a','4512331125',56.2,69.5,10001,'1','精裝圖書','內容介紹：','相關產品：','封面：<img src="http://images.amazon.com/images/P/1931182140.01.MZZZZZZZ.jpg">','評論：');
insert into item values('04061009b','4512331125',47.5,56.5,10001,'1','普通裝圖書','內容介紹：','相關產品：','封面：<img src="http://images.amazon.com/images/P/1931182140.01.MZZZZZZZ.jpg">','評論：');
insert into item values('04061009c','4512331125',32.0,35.5,10001,'1','電子版','內容介紹：','相關產品：','封面：<img src="http://images.amazon.com/images/P/1931182140.01.MZZZZZZZ.jpg">','評論：');

insert into item values('04061010a','0471133051',56.2,69.5,10001,'1','精裝圖書','內容介紹：','相關產品：','封面：<img src="http://images.amazon.com/images/P/1931182140.01.MZZZZZZZ.jpg">','評論：');
insert into item values('04061010b','0471133051',47.5,56.5,10001,'1','普通裝圖書','內容介紹：','相關產品：','封面：<img src="http://images.amazon.com/images/P/1931182140.01.MZZZZZZZ.jpg">','評論：');
insert into item values('04061010c','0471133051',32.0,35.5,10001,'1','電子版','內容介紹：','相關產品：','封面：<img src="http://images.amazon.com/images/P/1931182140.01.MZZZZZZZ.jpg">','評論：');

insert into item values('04061011a','1885068921',56.2,69.5,10001,'1','精裝圖書','內容介紹：','相關產品：','封面：<img src="http://images.amazon.com/images/P/1931182140.01.MZZZZZZZ.jpg">','評論：');
insert into item values('04061011b','1885068921',47.5,56.5,10001,'1','普通裝圖書','內容介紹：','相關產品：','封面：<img src="http://images.amazon.com/images/P/1931182140.01.MZZZZZZZ.jpg">','評論：');
insert into item values('04061011c','1885068921',32.0,35.5,10001,'1','電子版','內容介紹：','相關產品：','封面：<img src="http://images.amazon.com/images/P/1931182140.01.MZZZZZZZ.jpg">','評論：');

insert into item values('04061012a','750122076X',56.2,69.5,10001,'1','精裝圖書','內容介紹：','相關產品：','封面：<img src="http://images.amazon.com/images/P/1931182140.01.MZZZZZZZ.jpg">','評論：');
insert into item values('04061012b','750122076X',47.5,56.5,10001,'1','普通裝圖書','內容介紹：','相關產品：','封面：<img src="http://images.amazon.com/images/P/1931182140.01.MZZZZZZZ.jpg">','評論：');
insert into item values('04061012c','750122076X',32.0,35.5,10001,'1','電子版','內容介紹：','相關產品：','封面：<img src="http://images.amazon.com/images/P/1931182140.01.MZZZZZZZ.jpg">','評論：');

insert into item values('04061013a','7505391496',56.2,69.5,10001,'1','精裝圖書','內容介紹：','相關產品：','封面：<img src="http://images.amazon.com/images/P/1931182140.01.MZZZZZZZ.jpg">','評論：');
insert into item values('04061013b','7505391496',47.5,56.5,10001,'1','普通裝圖書','內容介紹：','相關產品：','封面：<img src="http://images.amazon.com/images/P/1931182140.01.MZZZZZZZ.jpg">','評論：');
insert into item values('04061013c','7505391496',32.0,35.5,10001,'1','電子版','內容介紹：','相關產品：','封面：<img src="http://images.amazon.com/images/P/1931182140.01.MZZZZZZZ.jpg">','評論：');

INSERT INTO sequence VALUES('orders', 1000);
INSERT INTO sequence VALUES('ordernum', 1000);
INSERT INTO sequence VALUES('creditcardinfo', 1000);