ITKeyword,专注技术干货聚合推荐

注册 | 登录

b2c电子商务网站数据库

mjh11310 分享于 2007-07-16

推荐:大型电子商务网站架构之--分布式可扩展数据库架构

http://liriguang.iteye.com/blog/714728 大型电子商务网站架构之--分布式可扩展数据库架构 博客分类:  Database 电子商务 数据结构 Oracle MySQL memcached  

2020腾讯云共同战“疫”,助力复工(优惠前所未有!4核8G,5M带宽 1684元/3年),
地址https://cloud.tencent.com/act/cps/redirect?redirect=1054

2020阿里云最低价产品入口,含代金券(新老用户有优惠),
地址https://www.aliyun.com/minisite/goods

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','long11310@163.com','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','gongsi@163.com') 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 

推荐:大型电子商务网站架构

大型电子商务网站架构 (转自:http://www.cnblogs.com/skydau/archive/2009/08/30/1556701.html) 7.同一个网站的多语言该如何处理是好,使用配置文件然后cookie或

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 varch

相关阅读排行


相关内容推荐

最新文章

×

×

请激活账号

为了能正常使用评论、编辑功能及以后陆续为用户提供的其他产品,请激活账号。

您的注册邮箱: 修改

重新发送激活邮件 进入我的邮箱

如果您没有收到激活邮件,请注意检查垃圾箱。