create database bookManager
on
(
name='bookManager_data',
filename='f:\bookManager.mdf'
)
log on
(
name='bookManager_log',
filename='f:\bookManager.ldf'
)
go
use bookManager
go
create table roles
(
roleID int primary key identity(1,1),
roleName Varchar (50) null
)
go
create table users
(
userID int primary key identity(1,1),
userName Varchar(50) not null,
realName Varchar(50) not null,
pwd Varchar(50) not null,
addr Varchar(200) not null,
phone Varchar(20) null,
createDate datetime not null,
roleID int not null foreign key references roles(roleID),
re Varchar(2000) null
)
gocreate table book
(
bookID int primary key identity(1,1),
bookName Varchar(200) not null,
caregoryID int not null foreign key references category(categoryID) ,
data Varchar(50) null,
info Varchar(2000) null,
sell Varchar(200) null,
buyInDate DateTime not null,
quantity int null,
inPrice money null,
discount float null,
re Varchar(2000) null)
gocreate table category
(
categoryID int primary key identity(1,1),
categoryName Varchar(50) null,
parentID int,
re Varchar(2000) null)
gocreate table comment
(
commentID int primary key identity(1,1),
title Varchar(200) not null,
body Varchar(2000) null,
createDate datetime not null,
userID int not null foreign key references users(userID),
bookID int not null foreign key references book(bookID)
)
go
create table orderForm
(
orderFormID int primary key identity(1,1),
userID int not null foreign key references users(userID),
totalNum int null,
totoalMoney money null,
orderDate datetime not null,
state Varchar(2000) null
)
go
create table orderItem
(
orderItemID int primary key identity(1,1),
bookID int not null foreign key references book(bookID),
orderFormID int not null foreign key references orderForm(orderFormID),
num int not null,
price money not null
)
go这个是干什么的?怎么用呢?
on
(
name='bookManager_data',
filename='f:\bookManager.mdf'
)
log on
(
name='bookManager_log',
filename='f:\bookManager.ldf'
)
go
use bookManager
go
create table roles
(
roleID int primary key identity(1,1),
roleName Varchar (50) null
)
go
create table users
(
userID int primary key identity(1,1),
userName Varchar(50) not null,
realName Varchar(50) not null,
pwd Varchar(50) not null,
addr Varchar(200) not null,
phone Varchar(20) null,
createDate datetime not null,
roleID int not null foreign key references roles(roleID),
re Varchar(2000) null
)
gocreate table book
(
bookID int primary key identity(1,1),
bookName Varchar(200) not null,
caregoryID int not null foreign key references category(categoryID) ,
data Varchar(50) null,
info Varchar(2000) null,
sell Varchar(200) null,
buyInDate DateTime not null,
quantity int null,
inPrice money null,
discount float null,
re Varchar(2000) null)
gocreate table category
(
categoryID int primary key identity(1,1),
categoryName Varchar(50) null,
parentID int,
re Varchar(2000) null)
gocreate table comment
(
commentID int primary key identity(1,1),
title Varchar(200) not null,
body Varchar(2000) null,
createDate datetime not null,
userID int not null foreign key references users(userID),
bookID int not null foreign key references book(bookID)
)
go
create table orderForm
(
orderFormID int primary key identity(1,1),
userID int not null foreign key references users(userID),
totalNum int null,
totoalMoney money null,
orderDate datetime not null,
state Varchar(2000) null
)
go
create table orderItem
(
orderItemID int primary key identity(1,1),
bookID int not null foreign key references book(bookID),
orderFormID int not null foreign key references orderForm(orderFormID),
num int not null,
price money not null
)
go这个是干什么的?怎么用呢?
物理文件在F盘
bookManager下建立表 roles、 users、 book、 category、 comment、 orderForm、 orderItem