-- --------------------------------------------------
-- Generated by Enterprise Architect Version 6.1.789
-- Created On : 星期日, 07 五月, 2006
-- DBMS : SQL Server 2000
-- --------------------------------------------------
-- Drop Foreign Key Constraints
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id('FK_Comment_MemberInfo') AND OBJECTPROPERTY(id, 'IsForeignKey') = 1)
ALTER TABLE Comment DROP CONSTRAINT FK_Comment_MemberInfo
;
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id('FK_Comment_Storage') AND OBJECTPROPERTY(id, 'IsForeignKey') = 1)
ALTER TABLE Comment DROP CONSTRAINT FK_Comment_Storage
;
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id('FK_Discount_Storage') AND OBJECTPROPERTY(id, 'IsForeignKey') = 1)
ALTER TABLE Discount DROP CONSTRAINT FK_Discount_Storage
;
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id('FK_OrderAddress_MemberInfo') AND OBJECTPROPERTY(id, 'IsForeignKey') = 1)
ALTER TABLE OrderAddress DROP CONSTRAINT FK_OrderAddress_MemberInfo
;
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id('FK_OrderMember_MemberInfo') AND OBJECTPROPERTY(id, 'IsForeignKey') = 1)
ALTER TABLE OrderMember DROP CONSTRAINT FK_OrderMember_MemberInfo
;
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id('FK_SentInfo_Storage') AND OBJECTPROPERTY(id, 'IsForeignKey') = 1)
ALTER TABLE SentInfo DROP CONSTRAINT FK_SentInfo_Storage
;
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id('FK_SentInfo_UserInfo') AND OBJECTPROPERTY(id, 'IsForeignKey') = 1)
ALTER TABLE SentInfo DROP CONSTRAINT FK_SentInfo_UserInfo
;
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id('FK_ShopCart_MemberInfo') AND OBJECTPROPERTY(id, 'IsForeignKey') = 1)
ALTER TABLE ShopCart DROP CONSTRAINT FK_ShopCart_MemberInfo
;
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id('FK_Storage_CatogoryTable') AND OBJECTPROPERTY(id, 'IsForeignKey') = 1)
ALTER TABLE Storage DROP CONSTRAINT FK_Storage_CatogoryTable
;
-- Drop Tables
IF EXISTS (SELECT * FROM dbo.SYSOBJECTS WHERE id = object_id('CatogoryTable') AND OBJECTPROPERTY(id, 'IsUserTable') = 1)
DROP TABLE CatogoryTable
;
IF EXISTS (SELECT * FROM dbo.SYSOBJECTS WHERE id = object_id('Comment') AND OBJECTPROPERTY(id, 'IsUserTable') = 1)
DROP TABLE Comment
;
IF EXISTS (SELECT * FROM dbo.SYSOBJECTS WHERE id = object_id('Discount') AND OBJECTPROPERTY(id, 'IsUserTable') = 1)
DROP TABLE Discount
;
IF EXISTS (SELECT * FROM dbo.SYSOBJECTS WHERE id = object_id('MemberInfo') AND OBJECTPROPERTY(id, 'IsUserTable') = 1)
DROP TABLE MemberInfo
;
IF EXISTS (SELECT * FROM dbo.SYSOBJECTS WHERE id = object_id('OrderAddress') AND OBJECTPROPERTY(id, 'IsUserTable') = 1)
DROP TABLE OrderAddress
;
IF EXISTS (SELECT * FROM dbo.SYSOBJECTS WHERE id = object_id('OrderMember') AND OBJECTPROPERTY(id, 'IsUserTable') = 1)
DROP TABLE OrderMember
;
IF EXISTS (SELECT * FROM dbo.SYSOBJECTS WHERE id = object_id('SentInfo') AND OBJECTPROPERTY(id, 'IsUserTable') = 1)
DROP TABLE SentInfo
;
IF EXISTS (SELECT * FROM dbo.SYSOBJECTS WHERE id = object_id('ShopCart') AND OBJECTPROPERTY(id, 'IsUserTable') = 1)
DROP TABLE ShopCart
;
IF EXISTS (SELECT * FROM dbo.SYSOBJECTS WHERE id = object_id('Storage') AND OBJECTPROPERTY(id, 'IsUserTable') = 1)
DROP TABLE Storage
;
IF EXISTS (SELECT * FROM dbo.SYSOBJECTS WHERE id = object_id('SystemSettings') AND OBJECTPROPERTY(id, 'IsUserTable') = 1)
DROP TABLE SystemSettings
;
IF EXISTS (SELECT * FROM dbo.SYSOBJECTS WHERE id = object_id('UserInfo') AND OBJECTPROPERTY(id, 'IsUserTable') = 1)
DROP TABLE UserInfo
;
-- Create Tables
CREATE TABLE CatogoryTable (
CtID int identity(1,1) NOT NULL, -- 类别ID
CtName nvarchar(200) NOT NULL, -- 类别名称
CtParentID int DEFAULT 0 -- 父类别ID
)
;
CREATE TABLE Comment (
CmID int identity(1,1) NOT NULL, -- 评论ID
CmCommenderID int NOT NULL, -- 评论人员ID
CmBookID int NOT NULL, -- 所评论的书籍的ID
CmTitle nvarchar(200) NOT NULL, -- 评论标题
CmContent ntext, -- 评论内容
CmDate datetime NOT NULL -- 评论日期
)
;
CREATE TABLE Discount (
DID int identity(1,1) NOT NULL, -- ID
SID int NOT NULL, -- 对应的货物ID
SMemberLevel int NOT NULL, -- 会员级别
SDiscount float NOT NULL -- 会员折扣价
)
;
CREATE TABLE MemberInfo (
MbID int identity(1,1) NOT NULL, -- 会员ID
MbName nvarchar(30) NOT NULL, -- 会员名称
MbPassword nvarchar(32) NOT NULL, -- 密码
MbTrueName nvarchar(50) NOT NULL, -- 真实姓名
MbEmail nvarchar(200), -- Email地址
MbBouns int DEFAULT 0 NOT NULL, -- 会员消费积分
MbDeleted bit DEFAULT 0, -- 删除标记位
MbRegisterDate datetime NOT NULL -- 会员注册时间
)
;
CREATE TABLE OrderAddress (
OaID int identity(1,1) NOT NULL, -- ID
OaMemberID int NOT NULL, -- 会员ID
OaContactInfo ntext -- 序列化的收货人信息
)
;
CREATE TABLE OrderMember (
OmID int identity(1,1) NOT NULL, -- 订单ID
OmMemberID int NOT NULL,
OmOrder ntext NOT NULL, -- 序列化的订单实体
OmDate datetime NOT NULL -- 下订单时间
)
;
CREATE TABLE SentInfo (
SiID int identity(1,1) NOT NULL, -- 发货信息ID
SStorageID int NOT NULL, -- 货物ID
SiCount int NOT NULL,
SiSentUserID int NOT NULL, -- 确认为发货状态的用户ID
SiDate datetime -- 发货时间
)
;
CREATE TABLE ShopCart (
ScID int identity(1,1) NOT NULL, -- 购物车ID
ScMemberID int NOT NULL, -- 会员ID
ScShopCart ntext -- 序列化的购物车对象
)
;
CREATE TABLE Storage (
SID int identity(1,1) NOT NULL, -- 货物ID
SName nchar(500) NOT NULL, -- 货物名称
STypeID int NOT NULL, -- 所属类别ID
SImage nvarchar(500), -- 所略图的URL
SWriter nvarchar(500) NOT NULL, -- 作者
SPublisher ntext NOT NULL, -- 出版社
SPublishDate datetime NOT NULL, -- 出版日期
SPublishTimes int DEFAULT 1 NOT NULL, -- 版次
SISBN nvarchar(50) NOT NULL, -- ISBN
SPageCount int NOT NULL, -- 页数
SPageSize nvarchar(50) NOT NULL, -- 书的开数
SWordCount int NOT NULL, -- 字数
SPrice float NOT NULL, -- 价格
SIntro ntext, -- 内容简介
SContents bigint, -- 目录
SStorageCount int DEFAULT 0 NOT NULL -- 货物库存
)
;
CREATE TABLE SystemSettings (
SsId int identity(1,1) NOT NULL, -- 设置ID
SsKey nvarchar(50) NOT NULL, -- 设置键名
SsValue ntext NOT NULL -- 设置值
)
;
CREATE TABLE UserInfo (
UID int identity(1,1) NOT NULL, -- 用户ID
UName nvarchar(50) NOT NULL, -- 用户名
UPassword nvarchar(32) NOT NULL, -- 密码
URoleID int NOT NULL, -- 用户所属角色
UiDeleted bit DEFAULT 0 NOT NULL -- 删除标记位
)
;
-- Create Primary Key Constraints
ALTER TABLE CatogoryTable ADD CONSTRAINT PK_CatogoryTable
PRIMARY KEY (CtID)
;
ALTER TABLE Comment ADD CONSTRAINT PK_Comment
PRIMARY KEY (CmID)
;
ALTER TABLE Discount ADD CONSTRAINT PK_Discount
PRIMARY KEY (DID)
;
ALTER TABLE MemberInfo ADD CONSTRAINT PK_MemberInfo
PRIMARY KEY (MbID)
;
ALTER TABLE OrderAddress ADD CONSTRAINT PK_OrderAddress
PRIMARY KEY (OaID)
;
ALTER TABLE OrderMember ADD CONSTRAINT PK_OrderMember
PRIMARY KEY (OmID)
;
ALTER TABLE SentInfo ADD CONSTRAINT PK_SentInfo
PRIMARY KEY (SiID)
;
ALTER TABLE ShopCart ADD CONSTRAINT PK_ShopCart
PRIMARY KEY (ScID)
;
ALTER TABLE Storage ADD CONSTRAINT PK_Storage
PRIMARY KEY (SID)
;
ALTER TABLE SystemSettings ADD CONSTRAINT PK_SystemSettings
PRIMARY KEY (SsId)
;
ALTER TABLE UserInfo ADD CONSTRAINT PK_UserInfo
PRIMARY KEY (UID)
;
-- Create Indexes
ALTER TABLE CatogoryTable
ADD CONSTRAINT UQ_CatogoryTable_CtID UNIQUE (CtID)
;
ALTER TABLE Discount
ADD CONSTRAINT UQ_Discount_DID UNIQUE (DID)
;
ALTER TABLE OrderA
没有合适的资源?快使用搜索试试~ 我知道了~
网上书店源码
共167个文件
cs:90个
aspx:33个
ascx:20个
需积分: 0 83 下载量 177 浏览量
2008-01-09
19:00:31
上传
评论
收藏 797KB RAR 举报
温馨提示
网上书店源码~~还是有点大~~
资源详情
资源评论
资源推荐
收起资源包目录
网上书店源码 (167个子文件)
Global.asax 3KB
GoodsBriefControl.ascx 4KB
UCAdminLoginControl.ascx 2KB
MemberLoginControl.ascx 2KB
MemberAddressControl.ascx 2KB
CartItemControl.ascx 1KB
CartRowControl.ascx 1KB
ShopcartControl.ascx 988B
PayCartControl.ascx 905B
NewestBookControl.ascx 772B
HotBookControl.ascx 765B
CategoryControl.ascx 704B
PayCartRowControl.ascx 645B
UCTopBanner.ascx 532B
CategoryOfGoodsControl.ascx 401B
GoodsIntroControl.ascx 316B
GoodsContentsControl.ascx 305B
UCBottomBanner.ascx 243B
GoodsCommentControl.ascx 234B
ImageLinkControl.ascx 195B
ValidateCodeControl.ascx 132B
AddGoods.aspx 9KB
Register.aspx 5KB
ShowCategory.aspx 3KB
Category.aspx 3KB
ViewGoods.aspx 3KB
Bonus.aspx 2KB
AddUser.aspx 2KB
ShowGoods.aspx 2KB
ModifyPassword.aspx 2KB
SystemSettings.aspx 2KB
User.aspx 1KB
Login.aspx 1KB
ShowMember.aspx 1KB
EditUser.aspx 1KB
Member.aspx 1KB
Pay.aspx 1KB
Default.aspx 1KB
OrderList.aspx 1KB
AddCategory.aspx 829B
EditCategory.aspx 815B
Cart.aspx 795B
Login.aspx 652B
Validator.aspx 588B
UserInfo.aspx 557B
FindPassword.aspx 453B
ErrorPage.aspx 447B
OrderSuccess.aspx 341B
Default.aspx 298B
ViewGoodsCount.aspx 285B
Help.aspx 264B
MyComments.aspx 203B
MyOrders.aspx 199B
AdminBase.aspx 111B
Web.Config 2KB
GoodsAccess.cs 10KB
AddGoods.aspx.cs 7KB
MemberAccess.cs 6KB
Common.cs 6KB
GoodsBussiness.cs 5KB
UserAccess.cs 5KB
DbTools.cs 5KB
GoodsEntity.cs 4KB
CatagoryAccess.cs 4KB
MemberBussiness.cs 4KB
OrderAccess.cs 4KB
CatogoryBussiness.cs 3KB
ValidateCodeControl.ascx.cs 3KB
ShopcartBussiness.cs 3KB
Category.aspx.cs 3KB
MemberLoginControl.ascx.cs 3KB
SystemAccess.cs 3KB
AddressAccess.cs 2KB
SystemSettings.aspx.cs 2KB
Pay.aspx.cs 2KB
MemberEntity.cs 2KB
CommentAccess.cs 2KB
UserBussiness.cs 2KB
PayCartControl.ascx.cs 2KB
CartRowControl.ascx.cs 2KB
MemberAddressEntity.cs 2KB
OrderBussiness.cs 2KB
OrderEntity.cs 2KB
GoodsBriefControl.ascx.cs 2KB
CommentEntity.cs 2KB
ModifyPassword.aspx.cs 2KB
PayCartRowControl.ascx.cs 2KB
AddressBussiness.cs 2KB
ShowMember.aspx.cs 2KB
User.aspx.cs 2KB
UserEntity.cs 2KB
AddCategory.aspx.cs 2KB
ShopCartAccess.cs 2KB
CommentBussiness.cs 2KB
EditCategory.aspx.cs 2KB
SendEntity.cs 2KB
UCAdminLoginControl.ascx.cs 2KB
SystemBussiness.cs 2KB
Bonus.aspx.cs 2KB
EditUser.aspx.cs 2KB
共 167 条
- 1
- 2
路伊阑珊
- 粉丝: 34
- 资源: 62
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
评论0