insertvalues.sql

一个网上购物商城系统

insert into productattention (sessionid,pid, attentiontime) values ('SID3286850272686654064',37,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID91893834616039464',23,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID-592291114295015564',48,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID3617495008288211745',58,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID41806020377527834',98,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID5509588892787235282',65,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID-8480339069118170401',38,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID1152726424727769059',99,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID7098236113037243831',38,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID-1409105512163527555',12,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID-5927344108057009197',61,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID-8999928409127223208',54,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID-2777163588076331408',13,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID-8962975612460772755',25,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID-7477478767859384827',41,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID-1182658182465929733',5,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID144826180585502508',48,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID7997472878281631638',98,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID-3383799490188403947',93,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID-6737795901776052097',4,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID-6746451031876204684',18,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID1560983945717184120',45,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID4040744711053636117',26,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID-4569617377552286775',6,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID2803491354486774438',79,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID-4588629627936788934',48,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID-2525083697896662696',95,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID940830684280302888',89,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID7591581791634918238',20,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID-6443448666730353148',58,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID6154302920167396989',84,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID-541432210090040361',40,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID215384554287526690',17,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID-3873517648900822622',31,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID7888360651908968635',38,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID3076708866564710581',81,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID-1128845704602809779',97,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID-4524622497644074154',4,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID9211147284450292079',43,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID501258844323014980',69,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID3815041870517142589',39,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID3486196223131315966',60,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID-1118776540536242461',82,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID2945244395831683552',74,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID7764195721302799297',47,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID-2695506472696638873',61,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID8322613624273501537',9,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID-4742513092619893951',20,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID-5319949057383513155',98,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID6366320623621428977',79,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID7201742494789395065',97,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID-1283881468698108109',49,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID8556900564143968288',84,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID-3547738203538165660',64,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID3949942840935835279',61,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID4570522054807562387',31,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID6680420963077876488',23,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID-632514937190703855',2,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID7773758081360609448',56,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID8617504479571329678',80,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID-2174025921419847117',22,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID1489518771925091117',22,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID8912677439646537846',51,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID-6038835380265182442',77,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID-2542730212369917782',25,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID-3386607613480022166',60,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID9218759929104276129',38,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID-3035748366679493466',33,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID-3752434119865931607',14,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID-7270215419087531817',12,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID7203704171466234712',45,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID-1242385127743503561',76,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID2027245388950438353',38,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID-2941027603612594694',77,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID-7061970222959987943',56,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID-9218198647139403646',82,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID-5094100014955042927',79,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID-3687554996943745236',28,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID-1011214442146168387',20,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID1657703708308888439',5,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID-8461943418619710510',70,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID-6077851864419050955',23,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID-3153026368261258297',91,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID-4168651308073662722',60,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID1641858728147821026',22,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID-7045272659763471576',43,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID5698234980256458222',36,date '2008-11-10');

commit;

insert into levels (levelname,photo,description) values('土豆','images/xx.gif','注册会员');

insert into question (question) values('无');
insert into question (question) values('母亲的名字');
insert into question (question) values('爷爷的名字');
insert into question (question) values('父亲出生的城市');
insert into question (question) values('您其中一位老师的名字');
insert into question (question) values('您个人计算机的型号');
insert into question (question) values('您最喜欢的餐馆名称');
insert into question (question) values('驾驶执照的最后四位数字');

insert into announce (username,atype,title,titlecolor,sendtime,content) values('小猪','[豆告]','恭喜，新豆网初步建成','red','2008-11-11 00:11:11','经过一小段时间的努力，新豆网终于完成了~');
insert into announce (username,atype,title,titlecolor,sendtime,content) values('小猪','[豆告]','测试公告1','','2008-11-11 00:11:11','经过一小段时间的努力，新豆网终于完成了~');
insert into announce (username,atype,title,titlecolor,sendtime,content) values('小猪','[豆告]','测试公告2','','2008-11-11 00:11:11','经过一小段时间的努力，新豆网终于完成了~');
insert into announce (username,atype,title,titlecolor,sendtime,content) values('小猪','[豆告]','测试公告3','','2008-11-11 00:11:11','经过一小段时间的努力，新豆网终于完成了~');
insert into announce (username,atype,title,titlecolor,sendtime,content) values('小猪','[豆告]','测试公告4','blue','2008-11-11 00:11:11','经过一小段时间的努力，新豆网终于完成了~');
insert into announce (username,atype,title,titlecolor,sendtime,content) values('小猪','[豆告]','测试公告5','yellow','2008-11-11 00:11:11','经过一小段时间的努力，新豆网终于完成了~');




insert into section(sectionname,parentid,description,sectiontype) values ('包包',0,'包包',1);
insert into section(sectionname,parentid,description,sectiontype) values ('电脑产品',0,'电脑产品',1);
insert into section(sectionname,parentid,description,sectiontype) values ('数码娱乐',0,'数码娱乐',1);
insert into section(sectionname,parentid,description,sectiontype) values ('办公家居',0,'办公家居',1);
insert into section(sectionname,parentid,description,sectiontype) values ('苹果专区',0,'苹果专区',1);
insert into section(sectionname,parentid,description,sectiontype) values ('礼品团购区',0,'礼品团购区',1);

insert into section(sectionname,parentid,description,sectiontype) values ('手提包',1,'手提包',2);
insert into section(sectionname,parentid,description,sectiontype) values ('背包',1,'背包',2);
insert into section(sectionname,parentid,description,sectiontype) values ('旅行箱包',1,'旅行箱包',2);
insert into section(sectionname,parentid,description,sectiontype) values ('笔记本内袋',1,'笔记本内袋',2);
insert into section(sectionname,parentid,description,sectiontype) values ('数码包',1,'数码包',2);
insert into section(sectionname,parentid,description,sectiontype) values ('休闲包',1,'休闲包',2);
insert into section(sectionname,parentid,description,sectiontype) values ('多功能包',1,'多功能包',2);

insert into section(sectionname,parentid,description,sectiontype) values ('存储设备',2,'存储设备',2);
insert into section(sectionname,parentid,description,sectiontype) values ('笔记本及周边',2,'笔记本及周边',2);
insert into section(sectionname,parentid,description,sectiontype) values ('输入输出设备',2,'输入输出设备',2);
insert into section(sectionname,parentid,description,sectiontype) values ('接口设备',2,'接口设备',2);
insert into section(sectionname,parentid,description,sectiontype) values ('线材类',2,'线材类',2);
insert into section(sectionname,parentid,description,sectiontype) values ('音频/视频设备',2,'音频/视频设备',2);
insert into section(sectionname,parentid,description,sectiontype) values ('电源设备',2,'电源设备',2);
insert into section(sectionname,parentid,description,sectiontype) values ('网络设备',2,'网络设备',2);