taobao.sql

一个仿造淘宝的jsp网站。功能比较完善

select * from follownote
insert into follownote values(1,1,'你好','恭喜你',convert(varchar(19),getdate(),126))
insert into follownote values(1,1,'可怜','你真可怜,可以去工商局啊?傻瓜!',convert(varchar(19),getdate(),126))
insert into follownote values(2,2,'加油','刘翔加油',convert(varchar(19),getdate(),126))
insert into follownote values(2,2,'nerver give up','刘翔，不要放弃',convert(varchar(19),getdate(),126))
insert into follownote values(2,2,'加油','刘翔加油',convert(varchar(19),getdate(),126))
insert into follownote values(2,2,'nerver give up','刘翔，不要放弃',convert(varchar(19),getdate(),126))

insert into follownote values(3,25,'helloworld','编个helloworld给我看',convert(varchar(19),getdate(),126))
insert into follownote values(3,26,'强人啊，我的娘聂','微软是个大强人啊，太了不起了！',convert(varchar(19),getdate(),126))

go
 
/*==============================================================*/
/* Table: masternote                                            */
/*==============================================================*/
create table masternote (
   mid                  int   identity(1,1)                not null,
   userid               int                  null,
   modeid               int                  null,
   mastertitle          varchar(100)         null,
   mastermessage        varchar(1000)        null,
   mastertime           varchar(100)         null,
   constraint PK_MASTERNOTE primary key (mid)
)

go
insert into masternote values(1,1,'天冷了？','天气说冷就冷！' ,convert(varchar(19),getdate(),126))
insert into masternote values(1,1,'奶粉中毒事件？','我每天冒着生命危险和牛奶，真伟大阿！' ,convert(varchar(19),getdate()))
insert into masternote values(1,1,'今天真倒霉？','今天买了两条假中华的，去退货，店主不承认！' ,convert(varchar(19),getdate(),126))
insert into masternote values(1,1,'今天看到一个美女好漂亮？','在中央门车站看到的那个我怀疑她不是地球人，地球人哪有那么漂亮的！' ,convert(varchar(19),getdate()))
insert into masternote values(1,1,'人民币为什么是长方形的？','为什么每个国家制的纸币都是长方形的！' ,convert(varchar(19),getdate()))
insert into masternote values(2,1,'中国金牌最新突破','中国已经拿到了45块金牌。' ,convert(varchar(19),getdate()))

insert into masternote values(2,2,'刘翔输了？','刘翔因为受伤而退赛了！' ,convert(varchar(19),getdate(),126))
insert into masternote values(2,2,'刘翔加油','世界哪个优秀运动员不受伤，刘翔，哪里跌倒，哪里爬起来！' ,convert(varchar(19),getdate()))
insert into masternote values(2,2,'中国奥运百金','北京奥运会,中国健儿共获取的金牌总数为100枚！' ,convert(varchar(19),getdate()))
insert into masternote values(2,2,'奥运结束了','昨晚奥运结束的序幕在鸟巢拉开！' ,convert(varchar(19),getdate()))
insert into masternote values(2,2,'金牌总数51枚','北京奥运会中国金牌总数为51枚,世界第一！' ,convert(varchar(19),getdate()))
insert into masternote values(2,2,'英国垃圾','奥运会闭幕式英国表演的太垃圾了,好呕心' ,convert(varchar(19),getdate()))
insert into masternote values(2,2,'英超联赛','英超联赛是当今世界最豪华的联赛' ,convert(varchar(19),getdate()))
insert into masternote values(2,2,'中国足球','13亿人中找不出11个踢球的,丢死人了' ,convert(varchar(19),getdate()))
insert into masternote values(2,2,'美国篮球夺冠','梦八战胜了西班牙队,夺得了世界冠军' ,convert(varchar(19),getdate()))
insert into masternote values(2,2,'女篮加油','中国女篮晋级了四强,比男篮强' ,convert(varchar(19),getdate()))
insert into masternote values(2,2,'梦八-科比','科比用一场胜利来庆祝自己的生日' ,convert(varchar(19),getdate()))
insert into masternote values(2,2,'姚明','姚明在闭幕式上强遭外国美女热拥' ,convert(varchar(19),getdate()))
insert into masternote values(2,2,'奥运主题曲','刘欢和萨拉*布莱曼演唱的<我和你>蛮好听的' ,convert(varchar(19),getdate()))
insert into masternote values(2,2,'C罗','皇马队曼联的c罗早已垂涎很久,C罗应不应该离开曼联去皇马呢' ,convert(varchar(19),getdate()))
insert into masternote values(2,2,'NBA亏大了','最次奥运会好多来自NBA的国际球星都受伤了,然后NBA买单,像马刺,公牛' ,convert(varchar(19),getdate()))
insert into masternote values(2,2,'西班牙','像不到西班牙篮球也那么强,打得美国差点招架不过来,辛好有闪电侠' ,convert(varchar(19),getdate()))
insert into masternote values(2,2,'阿迪申诉','阿迪花巨资才获得北京奥运会的赞助权,不过却被李宁强尽了风头,点火时,就做广告了' ,convert(varchar(19),getdate()))

insert into masternote values(1,3,'java随机数问题？','java随机数谁有，发给我，请他吃饭！' ,convert(varchar(19),getdate(),126))
insert into masternote values(1,3,'SQL2008出来了','微软的SQL2008出来了，不知咋样' ,convert(varchar(19),getdate()))
insert into masternote values(1,3,'我的机器天天中毒','我的计算机天天中毒，防火墙时时开着' ,convert(varchar(19),getdate(),126))
insert into masternote values(1,3,'求一个jsp验证码','jsp验证码太难弄，你们谁有阿！我qq是314529656' ,convert(varchar(19),getdate()))
insert into masternote values(1,3,'求c#写的验证码','谁有asp.net写的算术验证码啊' ,convert(varchar(19),getdate()))

insert into masternote values(1,4,'java随机数问题？','java随机数谁有，发给我，请他吃饭！' ,convert(varchar(19),getdate(),126))
insert into masternote values(1,4,'SQL2008出来了','微软的SQL2008出来了，不知咋样' ,convert(varchar(19),getdate()))
insert into masternote values(1,4,'我的机器天天中毒','我的计算机天天中毒，防火墙时时开着' ,convert(varchar(19),getdate(),126))
insert into masternote values(1,4,'求一个jsp验证码','jsp验证码太难弄，你们谁有阿！我qq是314529656' ,convert(varchar(19),getdate()))
insert into masternote values(1,4,'求c#写的验证码','谁有asp.net写的算术验证码啊' ,convert(varchar(19),getdate()))

insert into masternote values(1,5,'java随机数问题？','java随机数谁有，发给我，请他吃饭！' ,convert(varchar(19),getdate(),126))
insert into masternote values(1,5,'SQL2008出来了','微软的SQL2008出来了，不知咋样' ,convert(varchar(19),getdate()))
insert into masternote values(1,5,'我的机器天天中毒','我的计算机天天中毒，防火墙时时开着' ,convert(varchar(19),getdate(),126))
insert into masternote values(1,5,'求一个jsp验证码','jsp验证码太难弄，你们谁有阿！我qq是314529656' ,convert(varchar(19),getdate()))
insert into masternote values(1,5,'求c#写的验证码','谁有asp.net写的算术验证码啊' ,convert(varchar(19),getdate()))

insert into masternote values(1,6,'java随机数问题？','java随机数谁有，发给我，请他吃饭！' ,convert(varchar(19),getdate(),126))
insert into masternote values(1,6,'SQL2008出来了','微软的SQL2008出来了，不知咋样' ,convert(varchar(19),getdate()))
insert into masternote values(1,6,'我的机器天天中毒','我的计算机天天中毒，防火墙时时开着' ,convert(varchar(19),getdate(),126))
insert into masternote values(1,6,'求一个jsp验证码','jsp验证码太难弄，你们谁有阿！我qq是314529656' ,convert(varchar(19),getdate()))
insert into masternote values(1,6,'求c#写的验证码','谁有asp.net写的算术验证码啊' ,convert(varchar(19),getdate()))

insert into masternote values(1,7,'java随机数问题？','java随机数谁有，发给我，请他吃饭！' ,convert(varchar(19),getdate(),126))
insert into masternote values(1,7,'SQL2008出来了','微软的SQL2008出来了，不知咋样' ,convert(varchar(19),getdate()))
insert into masternote values(1,7,'我的机器天天中毒','我的计算机天天中毒，防火墙时时开着' ,convert(varchar(19),getdate(),126))
insert into masternote values(1,7,'求一个jsp验证码','jsp验证码太难弄，你们谁有阿！我qq是314529656' ,convert(varchar(19),getdate()))
insert into masternote values(1,7,'求c#写的验证码','谁有asp.net写的算术验证码啊' ,convert(varchar(19),getdate()))

insert into masternote values(1,8,'java随机数问题？','java随机数谁有，发给我，请他吃饭！' ,convert(varchar(19),getdate(),126))
insert into masternote values(1,8,'SQL2008出来了','微软的SQL2008出来了，不知咋样' ,convert(varchar(19),getdate()))
insert into masternote values(1,8,'我的机器天天中毒','我的计算机天天中毒，防火墙时时开着' ,convert(varchar(19),getdate(),126))
insert into masternote values(1,8,'求一个jsp验证码','jsp验证码太难弄，你们谁有阿！我qq是314529656' ,convert(varchar(19),getdate()))
insert into masternote values(1,8,'求c#写的验证码','谁有asp.net写的算术验证码啊' ,convert(varchar(19),getdate()))
go
select * from masternote
select * from masternote where mastertitle like'%C#%'
/*==============================================================*/
/* Table: modeinfo                                              */
/*==============================================================*/
create table modeinfo (
   modeid               int    identity(1,1)               not null,
   modelname            varchar(50)          null,
   constraint PK_MODEINFO primary key (modeid)
)
go
insert into modeinfo values('生活')
insert into modeinfo values('体育')
insert into modeinfo values('编程')
insert into modeinfo values('环境')
insert into modeinfo values('新闻')
insert into modeinfo values('游戏')
insert into modeinfo values('工作')
insert into modeinfo values('爱好')
go
select * from modeinfo
go
/*==============================================================*/
/* Table: orderinfo                                             */
/*==============================================================*/
create table orderinfo (
   oid                  int     identity(1,1)              not null,
   userid               int                  null,
   osid                 int                  null,
   ordertime            datetime             null,
   getshopman           varchar(20)          null,
   telephone            varchar(17)          null,
   address              varchar(100)         null,
   glideid              varchar(50)          null,
   constraint PK_ORDERINFO primary key (oid)
)
go
insert into orderinfo values(1,1,'2008-05-26 02:03:21','liujinbin','123456','china of nanjin','200805260203211')
select * from orderinfo
go
/*==============================================================*/
/* Table: orderstate                                            */
/*==============================================================*/
create table orderstate (
   osid                 int   identity(1,1)                not null,
   ostatename           varchar(50)          null, 
   constraint PK_ORDERSTATE primary key (osid)
)
go
insert into orderstate values('已发货')
insert into orderstate values('未发货')
select * from orderstate
go

/*==============================================================*/
/* Table: photoinfo                                             */
/*==============================================================*/
create table photoinfo (
   photoid              int   identity(1,1)                not null,
   photopath            varchar(50)          null,
   constraint PK_PHOTOINFO primary key (photoid)
)
go
insert into photoinfo values('image/people/laoda.jpg')
insert into photoinfo values('image/people/xiaozhu.JPG')
insert into photoinfo values('image/goods/3.jpg')
insert into photoinfo values('image/goods/4.jpg')
insert into photoinfo values('image/goods/5.jpg')
insert into photoinfo values('image/goods/6.jpg')
insert into photoinfo values('image/goods/7.jpg')
insert into photoinfo values('image/goods/8.jpg')
insert into photoinfo values('image/goods/10.jpg')
insert into photoinfo values('image/goods/11.jpg')
insert into photoinfo values('image/goods/12.jpg')
insert into photoinfo values('image/goods/13.jpg')
insert into photoinfo values('image/goods/14.jpg')
insert into photoinfo values('image/goods/15.jpg')
insert into photoinfo values('image/goods/16.jpg')
insert into photoinfo values('image/goods/17.jpg')
insert into photoinfo values('image/goods/18.jpg')
insert into photoinfo values('image/goods/19.jpg')
insert into photoinfo values('image/goods/20.jpg')
insert into photoinfo values('image/goods/21.jpg')

--表情图片
insert into photoinfo values('image/taobaoluntan/emo/em00.gif')
insert into photoinfo values('image/taobaoluntan/emo/em01.gif')
insert into photoinfo values('image/taobaoluntan/emo/em02.gif')
insert into photoinfo values('image/taobaoluntan/emo/em03.gif')
insert into photoinfo values('image/taobaoluntan/emo/em04.gif')
insert into photoinfo values('image/taobaoluntan/emo/em05.gif')
insert into photoinfo values('image/taobaoluntan/emo/em06.gif')
insert into photoinfo values('image/taobaoluntan/emo/em07.gif')
insert into photoinfo values('image/taobaoluntan/emo/em08.gif')
insert into photoinfo values('image/taobaoluntan/emo/em09.gif')
insert into photoinfo values('image/taobaoluntan/emo/em10.gif')
insert into photoinfo values('image/taobaoluntan/emo/em11.gif')
insert into photoinfo values('image/taobaoluntan/emo/em12.gif')
insert into photoinfo values('image/taobaoluntan/emo/em13.gif')
insert into photoinfo values('image/taobaoluntan/emo/em14.gif')
insert into photoinfo values('image/taobaoluntan/emo/em15.gif')
insert into photoinfo values('image/taobaoluntan/emo/em16.gif')
insert into photoinfo values('image/taobaoluntan/emo/em17.gif')
insert into photoinfo values('image/taobaoluntan/emo/em18.gif')
insert into photoinfo values('image/taobaoluntan/emo/em19.gif')
insert into photoinfo values('image/taobaoluntan/emo/em20.gif')
insert into photoinfo values('image/taobaoluntan/emo/em21.gif')
insert into photoinfo values('image/taobaoluntan/emo/em22.gif')
insert into photoinfo values('image/taobaoluntan/emo/em23.gif')
insert into photoinfo values('image/taobaoluntan/emo/em24.gif')
insert into photoinfo values('image/taobaoluntan/emo/em25.gif')
insert into photoinfo values('image/taobaoluntan/emo/em26.gif')
insert into photoinfo values('image/taobaoluntan/emo/em27.gif')
insert into photoinfo values('image/taobaoluntan/emo/em28.gif')