b2c电子商务网站数据库

create database b2cshopdb

use b2cshopdb

create table users
(
userid int identity(1,1) primary key,
username varchar(32),
password varchar(32),
address varchar(200),
telephone varchar(12),
email varchar(30),
state int
)
go
select * from users

insert into users(username,password,address,telephone,email,state) values ('admin','admin','地址','13691116725','[e-mail]','1')

create table companys
(
companyid int identity(1,1) primary key,
name varchar(32),
decscription varchar(1000),
address varchar(200),
telephone varchar(20),
email varchar(50),
)
go

insert into companys(name,decscription,address,telephone,email) values('公司名称','公司介绍','公司地址','8812360','[e-mail]')

select * from companys
go

create table categorys
(
categoryid int identity(1,1) primary key,
description varchar(100),
)
go

insert into categorys(description) values ('种类详细描述')
insert into categorys(description) values ('种类详细描述2')
go

select * from categorys

create table products
(
productid int identity(1,1)primary key,
description varchar(2000),
pictureid int,
companyid int,
categoryid int,
quantity int,
price money,
pubdate datetime default(getdate()),
details1 text,
details2 text,
details3 text,
details4 text,
details5 text,
)
go

insert into products(description,pictureid,companyid,categoryid,quantity,price,details1,details2,details3,details4,details5) values ('商品描述名称','1','1','1','200',300,'商品详细属性说明一','商品详细属性说明2','商品详细属性说明3','商品详细属性说明4','商品详细属性说明5')
insert into products(description,pictureid,companyid,categoryid,quantity,price,details1,details2,details3,details4,details5) values ('商品描述名称2','2','1','1','400',600,'商品详细属性说明1-2','商品详细属性说明2-2','商品详细属性说明3-2','商品详细属性说明4-2','商品详细属性说明5-2')
go

select * from products
go

create table shopcarts
(
shopcartid int identity(1,1) primary key,
userid int ,
pubdate datetime default(getdate()),
totalnum int,
totalprice int,
)
go

insert into shopcarts(userid,totalnum,totalprice) values('1','20','300')
go

select * from shopcarts
go

create table productcarts
(
productid int,
shopcartid int,
quantity int,
)
go

insert into productcarts(productid,shopcartid,quantity) values('1','1','20')
go

select * from productcarts
go

 

create table pictures
(
pictureid int identity(1,1) primary key,
title varchar(50),
pictureurl varchar(100),
)
go

insert into pictures(title,pictureurl) values('图片说明','pic/1.jpg')
insert into pictures(title,pictureurl) values('图片说明2','pic/2.jpg')
go
go

select * from pictures
go

create table admin

(
adminid int identity(1,1) primary key,
username varchar(32),
password varchar(32),
state int,
)

insert into admin(username,password,state) values('admin','admin','2')

select * from admin