BookManager

USE [BookManagerSystem]GO/****** Object:  Table [dbo].[Reader]    Script Date: 05/17/2014 16:46:37 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE 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]GOSET IDENTITY_INSERT [dbo].[Reader] ONINSERT [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 ONGOSET QUOTED_IDENTIFIER ONGOCREATE 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]GOSET IDENTITY_INSERT [dbo].[Publisher] ONINSERT [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 ONGOSET QUOTED_IDENTIFIER ONGOCREATE 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]GOSET IDENTITY_INSERT [dbo].[BookType] ONINSERT [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 ONGOSET QUOTED_IDENTIFIER ONGOCREATE 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]GOSET IDENTITY_INSERT [dbo].[Book] ONINSERT [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