USE [BookManagerSystem]
GO
/****** Object: Table [dbo].[Reader] Script Date: 05/17/2014 16:46:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Reader](
[Reader_Id] [int] IDENTITY(1,1) NOT NULL,
[Reader_Name] [nvarchar](50) NULL,
[Reader_Age] [nvarchar](50) NULL,
[Reader_Sex] [nvarchar](50) NULL,
[Reader_Phone] [nvarchar](50) NULL,
[Reader_Address] [nvarchar](50) NULL,
CONSTRAINT [PK_Reader] PRIMARY KEY CLUSTERED
(
[Reader_Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[Reader] ON
INSERT [dbo].[Reader] ([Reader_Id], [Reader_Name], [Reader_Age], [Reader_Sex], [Reader_Phone], [Reader_Address]) VALUES (1, N'姚立', N'24', N'男', N'12345678901', N'南京')
INSERT [dbo].[Reader] ([Reader_Id], [Reader_Name], [Reader_Age], [Reader_Sex], [Reader_Phone], [Reader_Address]) VALUES (2, N'李晓明', N'23', N'男', N'23456789012', N'北京')
INSERT [dbo].[Reader] ([Reader_Id], [Reader_Name], [Reader_Age], [Reader_Sex], [Reader_Phone], [Reader_Address]) VALUES (3, N'王小红', N'22', N'女', N'34565789012', N'上海')
SET IDENTITY_INSERT [dbo].[Reader] OFF
/****** Object: Table [dbo].[Publisher] Script Date: 05/17/2014 16:46:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Publisher](
[Pub_Id] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
[Pub_Name] [nvarchar](50) NULL,
[Pub_Address] [nvarchar](50) NULL,
[Pub_Contacter] [nvarchar](50) NULL,
[Pub_Phone] [nvarchar](50) NULL,
[Pub_NetAddress] [nvarchar](50) NULL,
CONSTRAINT [PK_Publisher_1] PRIMARY KEY CLUSTERED
(
[Pub_Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[Publisher] ON
INSERT [dbo].[Publisher] ([Pub_Id], [Pub_Name], [Pub_Address], [Pub_Contacter], [Pub_Phone], [Pub_NetAddress]) VALUES (1, N'中国邮电出版社', N'北京', N'小王', N'12345678901', N'www.baidu.com')
INSERT [dbo].[Publisher] ([Pub_Id], [Pub_Name], [Pub_Address], [Pub_Contacter], [Pub_Phone], [Pub_NetAddress]) VALUES (2, N'人民邮电出版社', N'上海', N'小李', N'23456789012', N'www.youdian.com')
INSERT [dbo].[Publisher] ([Pub_Id], [Pub_Name], [Pub_Address], [Pub_Contacter], [Pub_Phone], [Pub_NetAddress]) VALUES (3, N'华章出版社', N'深圳', N'小吴', N'34567890123', N'www.huazhang.com')
SET IDENTITY_INSERT [dbo].[Publisher] OFF
/****** Object: Table [dbo].[BookType] Script Date: 05/17/2014 16:46:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[BookType](
[BType_Id] [int] IDENTITY(1,1) NOT NULL,
[BType_Name] [nvarchar](50) NULL,
[BType_Des] [nvarchar](50) NULL,
CONSTRAINT [PK_BookType] PRIMARY KEY CLUSTERED
(
[BType_Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[BookType] ON
INSERT [dbo].[BookType] ([BType_Id], [BType_Name], [BType_Des]) VALUES (1, N'科技', N'科技类别')
INSERT [dbo].[BookType] ([BType_Id], [BType_Name], [BType_Des]) VALUES (2, N'人文', N'人文类别')
INSERT [dbo].[BookType] ([BType_Id], [BType_Name], [BType_Des]) VALUES (3, N'艺术', N'艺术类别')
INSERT [dbo].[BookType] ([BType_Id], [BType_Name], [BType_Des]) VALUES (4, N'数理化', N'数理化类别')
SET IDENTITY_INSERT [dbo].[BookType] OFF
/****** Object: Table [dbo].[Book] Script Date: 05/17/2014 16:46:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Book](
[Book_Id] [int] IDENTITY(1,1) NOT NULL,
[Book_Name] [nvarchar](50) NULL,
[Book_Author] [nvarchar](50) NULL,
[Book_Price] [nvarchar](50) NULL,
[Book_Type_id] [nvarchar](50) NULL,
[Book_Publisher_id] [nvarchar](50) NULL,
[Book_Date] [date] NULL,
[Book_Isbn] [nvarchar](50) NULL,
[Book_Num] [int] NULL,
CONSTRAINT [PK_Book] PRIMARY KEY CLUSTERED
(
[Book_Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[Book] ON
INSERT [dbo].[Book] ([Book_Id], [Book_Name], [Book_Author], [Book_Price], [Book_Type_id], [Book_Publisher_id], [Book_Date], [Book_Isbn], [Book_Num]) VALUES (1, N'Java编程思想', N'Bruce', N'79.00', N'4', N'3', CAST(0x4C320B00 AS Date), N'12345678', 3)
INSERT [dbo].[Book] ([Book_Id], [Book_Name], [Book_Author], [Book_Price], [Book_Type_id], [Book_Publisher_id], [Book_Date], [Book_Isbn], [Book_Num]) VALUES (2, N'电商迷局', N'王小明', N'49.00', N'2', N'1', CAST(0x26350B00 AS Date), N'23456789', 4)
INSERT [dbo].[Book] ([Book_Id], [Book_Name], [Book_Author], [Book_Price], [Book_Type_id], [Book_Publisher_id], [Book_Date], [Book_Isbn], [Book_Num]) VALUES (3, N'哲学家', N'李晓波', N'60.00', N'3', N'1', CAST(0x94360B00 AS Date), N'45678901', 2)
INSERT [dbo].[Book] ([Book_Id], [Book_Name], [Book_Author], [Book_Price], [Book_Type_id], [Book_Publisher_id], [Book_Date], [Book_Isbn], [Book_Num]) VALUES (4, N'科技的发展', N'Brian', N'50.00', N'1', N'2', CAST(0x01380B00 AS Date), N'34567890', 5)
SET IDENTITY_INSERT [dbo].[Book] OFF
08-11
08-11