insert_shopdata.sql

Sun公司Dream项目

INSERT INTO OPERA_SHOP_INFO VALUES('operaShop0','a','Opera Shop 0','http://www.sun.com');
INSERT INTO OPERA_CONTENT_METADATA VALUES('M001','Java Mobile 1','Highlighst the Mobile Features of Java Series Part 1 ','','','','','','','','images/java1a-small.gif','images/java1a-large.gif','download/M001.mp4','MPEG-4 Video','','','','','SUN','Download','M003',NULL);
INSERT INTO OPERA_CONTENT_METADATA VALUES('M002','Java Mobile 2','Highlighst the Mobile Features of Java Series Part 2','','','','','','','','images/java1c-small.gif','images/java1c-large.gif','download/M002.mp4','','','','video/mpeg','','SUN','Download','',NULL);
INSERT INTO OPERA_CONTENT_METADATA VALUES('M003','Java Mobile 3','Highlighst the Mobile Features of Java Series Part 3','','','','','','','','images/mew1a-small.gif','images/mew1a-large.gif','download/M003.mp4','','','','','','SUN','Download','M001',NULL);
INSERT INTO OPERA_CONTENT_METADATA VALUES('M004','Java Mobile 4','Highlighst the Mobile Features of Java Series Part 4','','','','','','','','images/mew1c-small.gif','images/mew1c-large.gif','download/M004.mp4','','','','','','SUN','Download','',NULL);
INSERT INTO OPERA_CONTENT_METADATA VALUES('Music1','Sample Music -1 ','Description of Sample Music 1','','','','','','','','','','','','','','','','','','',NULL);
INSERT INTO OPERA_COUNT VALUES(6,1);
INSERT INTO OPERA_USER_INFO VALUES('admin','admin','0000000000','000000000000000',NULL,NULL);
INSERT INTO OPERA_USER_INFO VALUES('operaUser1','a','[phone]','351102503385766','aa','');
INSERT INTO OPERA_USER_INFO VALUES('operaUser2','a','6508610517','310260001009540','','');
INSERT INTO OPERA_USER_INFO VALUES('operaUser4','no','343413413414','34234324324234','V','adf');
INSERT INTO OPERA_USER_INFO VALUES('operaUser5','a','703-205-9033','1094155489953','null','null');
INSERT INTO OPERA_LICENSE_INFO VALUES('O5M003', 0,'operaUser5','operaShop0','M003',1,0,NULL,NULL);
INSERT INTO OPERA_LICENSE_INFO VALUES('O5M004', 0,'operaUser5','operaShop0','M004',1,0,NULL,NULL);
INSERT INTO OPERA_LICENSE_INFO VALUES('O1M003', 0,'operaUser1','operaShop0','M003',1,1,NULL,NULL);
INSERT INTO OPERA_LICENSE_INFO VALUES('O1M001', 0,'operaUser1','operaShop0','M001',1,0,NULL,NULL);
INSERT INTO OPERA_LICENSE_INFO VALUES('O2M001', 0,'operaUser2','operaShop0','M001',201,197,NULL,NULL);
INSERT INTO OPERA_LICENSE_INFO VALUES('O2M003', 0,'operaUser2','operaShop0','M003',235,223,NULL,NULL);
INSERT INTO OPERA_COUPON_INFO VALUES('Coupon1','M001','operaShop0',2.0E0,'',NULL,NULL,NULL);
INSERT INTO OPERA_COUPON_INFO VALUES('Coupon2','total','operaShop0',5.0E0,'',NULL,NULL,NULL);
INSERT INTO SHOP_PRODUCT VALUES('M001','movie',9.989999771118164E0,9.989999771118164E0,'download/M001.mp4');
INSERT INTO SHOP_PRODUCT VALUES('M002','movie',9.989999771118164E0,9.989999771118164E0,'download/M002.mp4');
INSERT INTO SHOP_PRODUCT VALUES('M003','movie',19.989999771118164E0,17.989999771118164E0,'download/M003.mp4');
INSERT INTO SHOP_PRODUCT VALUES('M004','movie',29.989999771118164E0,25.989999771118164E0,'download/M004.mp4');
INSERT INTO SHOP_PRODUCT VALUES('Music1','music',NULL,NULL,'');
INSERT INTO SHOP_TRANSACTION VALUES('2004-07-24','operaUser1',9.989999771118164E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2004-07-24','operaUser1',19.979999542236328E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2004-07-24','operaUser1',9.989999771118164E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2004-07-25','operaUser2',1998.0E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2004-07-25','operaUser2',19.979999542236328E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2004-07-25','operaUser2',109.8899917602539E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2004-07-25','operaUser2',19.979999542236328E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2004-07-25','operaUser2',999.0E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2004-07-26','operaUser2',9.989999771118164E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2004-07-27','operaUser2',9.989999771118164E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2004-07-27','operaUser2',199.79998779296875E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2004-07-27','operaUser2',675.739990234375E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2004-07-28','operaUser2',35.97999954223633E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2004-07-28','operaUser2',19.979999542236328E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2004-07-28','operaUser2',17.989999771118164E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2004-07-28','operaUser2',17.989999771118164E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2004-07-28','operaUser2',19.979999542236328E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2004-07-28','operaUser2',17.989999771118164E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2004-07-28','operaUser2',35.97999954223633E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2004-07-28','operaUser2',17.989999771118164E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2004-07-28','operaUser2',25.989999771118164E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2004-07-28','operaUser2',17.989999771118164E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2004-07-28','operaUser2',17.989999771118164E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2004-07-28','operaUser2',17.989999771118164E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2004-07-28','operaUser2',17.989999771118164E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2004-07-28','operaUser2',17.989999771118164E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2004-07-28','operaUser2',17.989999771118164E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2004-07-28','operaUser2',17.989999771118164E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2004-07-29','operaUser2',17.989999771118164E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2004-07-29','operaUser2',17.989999771118164E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2004-07-29','operaUser2',17.989999771118164E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2004-07-29','operaUser2',9.989999771118164E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2004-08-03','operaUser4',53.970001220703125E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2004-08-05','operaUser4',2515.489990234375E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2004-08-22','operaUser2',1399.0E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2004-09-02','operaUser2',53.970001220703125E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2004-09-02','operaUser2',17.989999771118164E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2004-09-06','operaUser5',17.989999771118164E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2004-09-07','operaUser5',25.989999771118164E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2004-11-22','operaUser2',2798.0E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2004-12-09','operaUser2',27.979999542236328E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2004-12-09','operaUser2',2798.0E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2005-03-04','operaUser1',27.979999542236328E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2005-04-19','operaUser2',17.989999771118164E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2005-04-19','operaUser2',17.989999771118164E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2005-04-19','operaUser2',17.989999771118164E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2005-04-19','operaUser2',17.989999771118164E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2005-04-20','operaUser2',17.989999771118164E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2005-04-20','operaUser2',17.989999771118164E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2005-04-20','operaUser2',17.989999771118164E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2005-04-20','operaUser2',17.989999771118164E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2005-04-20','operaUser2',17.989999771118164E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2005-04-20','operaUser2',17.989999771118164E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2005-04-20','operaUser2',17.989999771118164E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2005-04-20','operaUser2',17.989999771118164E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2005-04-20','operaUser2',17.989999771118164E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2005-04-20','operaUser2',17.989999771118164E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2005-04-20','operaUser2',17.989999771118164E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2005-04-20','operaUser2',17.989999771118164E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2005-04-20','operaUser2',17.989999771118164E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2005-04-20','operaUser2',17.989999771118164E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2005-04-21','operaUser2',17.989999771118164E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2005-04-21','operaUser2',17.989999771118164E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2005-04-21','operaUser2',17.989999771118164E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2005-04-21','operaUser2',17.989999771118164E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2005-04-21','operaUser2',17.989999771118164E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2005-04-21','operaUser2',17.989999771118164E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2005-04-21','operaUser2',17.989999771118164E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2005-04-21','operaUser2',17.989999771118164E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2005-04-21','operaUser2',17.989999771118164E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2005-04-21','operaUser2',17.989999771118164E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2005-04-21','operaUser2',17.989999771118164E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2005-04-21','operaUser2',17.989999771118164E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2005-04-21','operaUser2',17.989999771118164E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2005-04-21','operaUser2',17.989999771118164E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2005-04-21','operaUser2',17.989999771118164E0,NULL);
INSERT INTO SHOP_TRANSACTION VALUES('2005-04-21','operaUser2',17.989999771118164E0,NULL);
INSERT INTO PLACE VALUES(4900,'Langenthal');
INSERT INTO PLACE VALUES(8000,'Zurich');
INSERT INTO PLACE VALUES(3000,'Berne');
INSERT INTO PLACE VALUES(1200,'Geneva');
INSERT INTO PLACE VALUES(6900,'Lugano');
INSERT INTO CUSTOMER VALUES(1,'Meier',3000);
INSERT INTO CUSTOMER VALUES(2,'Mueller',8000);
INSERT INTO CUSTOMER VALUES(3,'Devaux',1200);
INSERT INTO CUSTOMER VALUES(4,'Rossi',6900);
INSERT INTO CUSTOMER VALUES(5,'Rickli',3000);
INSERT INTO CUSTOMER VALUES(6,'Graf',3000);
INSERT INTO CUSTOMER VALUES(7,'Mueller',4900);
INSERT INTO CUSTOMER VALUES(8,'May',1200);
INSERT INTO CUSTOMER VALUES(9,'Berger',8000);
INSERT INTO CUSTOMER VALUES(10,'D''Ascoli',6900);
INSERT INTO CUSTOMER VALUES(11,'Padruz',1200);
INSERT INTO CUSTOMER VALUES(12,'Hug',4900);