taobao.sql

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

insert into shopnuminfo values(104,20)
insert into shopnuminfo values(105,20)
insert into shopnuminfo values(106,20)
insert into shopnuminfo values(107,20)
insert into shopnuminfo values(108,20)
insert into shopnuminfo values(109,20)
insert into shopnuminfo values(110,20)
insert into shopnuminfo values(111,20)
insert into shopnuminfo values(112,20)
insert into shopnuminfo values(113,20)
insert into shopnuminfo values(114,20)
insert into shopnuminfo values(115,20)
insert into shopnuminfo values(116,20)
insert into shopnuminfo values(117,20)
insert into shopnuminfo values(118,20)
insert into shopnuminfo values(119,20)
insert into shopnuminfo values(120,20)
insert into shopnuminfo values(121,20)
insert into shopnuminfo values(122,20)
insert into shopnuminfo values(123,20)
insert into shopnuminfo values(124,20)
insert into shopnuminfo values(125,20)
insert into shopnuminfo values(126,20)
insert into shopnuminfo values(127,20)
insert into shopnuminfo values(128,20)
insert into shopnuminfo values(129,20)
insert into shopnuminfo values(130,20)
insert into shopnuminfo values(131,20)
insert into shopnuminfo values(132,20)
insert into shopnuminfo values(133,20)
insert into shopnuminfo values(134,20)
insert into shopnuminfo values(135,20)
insert into shopnuminfo values(136,20)
insert into shopnuminfo values(137,20)
insert into shopnuminfo values(138,20)
insert into shopnuminfo values(139,20)
insert into shopnuminfo values(140,20)
insert into shopnuminfo values(141,20)
insert into shopnuminfo values(142,20)
insert into shopnuminfo values(143,20)
insert into shopnuminfo values(144,20)
insert into shopnuminfo values(145,20)
insert into shopnuminfo values(146,20)
insert into shopnuminfo values(147,20)
insert into shopnuminfo values(148,20)
insert into shopnuminfo values(149,20)
insert into shopnuminfo values(150,20)
insert into shopnuminfo values(151,20)
insert into shopnuminfo values(152,20)
insert into shopnuminfo values(153,20)
insert into shopnuminfo values(154,20)
insert into shopnuminfo values(155,20)
insert into shopnuminfo values(156,20)
insert into shopnuminfo values(157,20)
insert into shopnuminfo values(158,20)
insert into shopnuminfo values(159,20)
insert into shopnuminfo values(160,20)
insert into shopnuminfo values(161,20)
insert into shopnuminfo values(162,20)
insert into shopnuminfo values(163,20)
insert into shopnuminfo values(164,20)
insert into shopnuminfo values(165,20)
insert into shopnuminfo values(166,20)
insert into shopnuminfo values(167,20)
insert into shopnuminfo values(168,20)
insert into shopnuminfo values(169,20)
insert into shopnuminfo values(170,20)
insert into shopnuminfo values(171,20)
insert into shopnuminfo values(172,20)
insert into shopnuminfo values(173,20)
insert into shopnuminfo values(174,20)
insert into shopnuminfo values(175,20)
insert into shopnuminfo values(176,20)
insert into shopnuminfo values(177,20)
insert into shopnuminfo values(178,20)
insert into shopnuminfo values(179,20)
insert into shopnuminfo values(180,20)
insert into shopnuminfo values(181,20)
insert into shopnuminfo values(182,20)
insert into shopnuminfo values(183,20)
insert into shopnuminfo values(184,20)
insert into shopnuminfo values(185,20)
insert into shopnuminfo values(186,20)
insert into shopnuminfo values(187,20)
insert into shopnuminfo values(188,20)
insert into shopnuminfo values(189,20)
insert into shopnuminfo values(190,20)
insert into shopnuminfo values(191,20)



select * from shopnuminfo
go

/*==============================================================*/
/* Table: shoporder                                             */
/*==============================================================*/
create table shoporder (
   sid                  int                  null,
   oid                  int                  null,
   shopnumber           int                  null
)
go
select * from shoporder
go

/*==============================================================*/
/* Table: stateinfo                                             */
/*==============================================================*/
create table stateinfo (
   stateid              int     identity(1,1)              not null,
   statename            varchar(50)          null,
   constraint PK_STATEINFO primary key (stateid)
)
go
insert into stateinfo values('已上架')
insert into stateinfo values('未上架')
go
select * from stateinfo
go
/*==============================================================*/
/* Table: typeinfo                                              */
/*==============================================================*/
create table typeinfo (
   tid                  int      identity(1,1)             not null,
   typename             varchar(50)          null,
   typedesc             varchar(200)         null,
   constraint PK_TYPEINFO primary key (tid)
)
go
insert into typeinfo values('汽车','各种名牌,各种样式,世界最新款式')
insert into typeinfo values('手机','各种名牌,各种样式,世界最新款式')
insert into typeinfo values('服装' ,'夏季服装风暴,世界最新款式,让您show一下')
insert into typeinfo values('皮包','各种真皮,时尚,气派,有气质')
insert into typeinfo values('图书','各种图书,计算机类,美食类都有')
insert into typeinfo values('首饰','各种图书,计算机类,美食类都有')
insert into typeinfo values('美食','各种名牌,各种样式,世界最新款式')
insert into typeinfo values('家具','各种名牌,各种样式,世界最新款式')
insert into typeinfo values('电器' ,'夏季服装风暴,世界最新款式,让您show一下')
insert into typeinfo values('女人','各种真皮,时尚,气派,有气质')
insert into typeinfo values('居家','各种图书,计算机类,美食类都有')
insert into typeinfo values('数码','各种图书,计算机类,美食类都有')
insert into typeinfo values('时尚','各种真皮,时尚,气派,有气质')
insert into typeinfo values('健康','各种图书,计算机类,美食类都有')
insert into typeinfo values('美容','各种图书,计算机类,美食类都有')
select * from typeinfo
go

/*==============================================================*/
/* Table: userinfo                                              */
/*==============================================================*/
create table userinfo (
   userid               int       identity(1,1)            not null,
   photoid              int                  null,
   usercardid           varchar(20)          null,
   userpwd              varchar(20)          null,
   username             varchar(20)          null,
   question             varchar(200)         null,
   answer               varchar(200)         null,
   userunid             varchar(18)          null,
   useremail            varchar(20)          null,
   useraddress          varchar(100)         null,
   usertel              varchar(17)          null,
   userscore            int                  null,
   userule              int                  null,
   constraint PK_USERINFO primary key (userid)
)
go
insert into userinfo values(1,'240823199001104010','123456','gaojian','What is your name?','My name is gaojian','健仔',
'[e-mail]','南京','15850712636',0,0)
insert into userinfo values(2,'320181198802156515','123456','kaka','What is your name?','My name is gaojian','卡卡',
'[e-mail]','巴西','12345678954',0,0)
insert into userinfo values(2,'320181198802156515','123456','mimi','What is your name?','My name is gaojian','mimi',
'[e-mail]','巴西','12345678954',0,0) 
insert into userinfo values(2,'320511199205165985','123456','cook','What is your name?','My name is gaojian','KOF97',
'[e-mail]','阔可','12345678954',0,1) 
select * from userinfo

go
/*==============================================================*/
/* Table: shopopinion                                              */
/*==============================================================*/
create table shopopinion
(
  opinionid int identity(1,1) not null,
  sid int not null,
  userid int not null,
  title varchar(200) null,
  note varchar(500)  null,
  rate varchar(100)  null,
  optime varchar(50)  null,
  constraint PK_SHOPOPINION primary key (opinionid)
)
select top 5 * from shopopinion where sid=1 order by optime desc
select * from shopopinion
go
alter table shopopinion
   add constraint FK_SHOPPOPI_REFERENCE_USERINFO foreign key (userid)
      references user