Go homepage(回首页) Upload pictures (上传图片) Write articles (发文字帖)
The author:(作者)归海一刀published in(发表于) 2014/1/30 0:52:50 ASP.NET,MVC+LINQ开发一个图书销售站点(3)-建立数据库_[Asp.Net教程]
根据上一节的对象,我们创建数据库如下:SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOIF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Admin]') AND type in (N'U'))BEGINCREATE TABLE [dbo].[Admin]( [AdminId] [int] IDENTITY(1,1) NOT NULL, [AdminEmail] [nvarchar](100) NOT NULL, [AdminName] [nvarchar](50) NOT NULL, [AdminIsBlocked] [bit] NULL, [AdminIsDeleted] [bit] NULL, CONSTRAINT [PK_Admin] PRIMARY KEY CLUSTERED ( [AdminId] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]ENDGOSET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOIF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Author]') AND type in (N'U'))BEGINCREATE TABLE [dbo].[Author]( [AuthorId] [int] IDENTITY(1,1) NOT NULL, [AuthorName] [nvarchar](100) NOT NULL, [AuthorDescription] [nvarchar](200) NULL, CONSTRAINT [PK_Author] PRIMARY KEY CLUSTERED ( [AuthorId] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]ENDGOSET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOIF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Category]') AND type in (N'U'))BEGINCREATE TABLE [dbo].[Category]( [CategoryId] [int] IDENTITY(1,1) NOT NULL, [CategoryName] [nvarchar](200) NOT NULL, CONSTRAINT [PK_Category] PRIMARY KEY CLUSTERED ( [CategoryId] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]ENDGOSET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOIF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[User]') AND type in (N'U'))BEGINCREATE TABLE [dbo].[User]( [UserId] [bigint] IDENTITY(1,1) NOT NULL, [UserName] [nvarchar](100) NOT NULL, [UserEmail] [nvarchar](100) NOT NULL, [UserIsBlocked] [bit] NULL, [UserIsDeleted] [bit] NULL, [UserIntroduction] [nvarchar](200) NULL, [UserJoinDate] [datetime] NOT NULL, [UserPassword] [nvarchar](50) NOT NULL, CONSTRAINT [PK_User] PRIMARY KEY CLUSTERED ( [UserId] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]ENDGOSET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOIF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Book]') AND type in (N'U'))BEGINCREATE TABLE [dbo].[Book]( [BookId] [bigint] IDENTITY(1,1) NOT NULL, [BookName] [nvarchar](200) NOT NULL, [BookAuthor] [int] NOT NULL, [BookISBN] [nvarchar](100) NOT NULL, [BookPictureAddress] [nvarchar](100) NULL, [BookDescription] [nvarchar](200) NULL, [BookPublishDate] [datetime] NULL, [BookCategoryId] [int] NOT NULL, CONSTRAINT [PK_Book] PRIMARY KEY CLUSTERED ( [BookId] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]ENDGO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Book]') AND name = N'IX_Book')CREATE NONCLUSTERED INDEX [IX_Book] ON [dbo].[Book] ( [BookId] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]GOSET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOIF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Comment]') AND type in (N'U'))BEGINCREATE TABLE [dbo].[Comment]( [CommentId] [int] IDENTITY(1,1) NOT NULL, [CommentContent] [nvarchar](200) NOT NULL, [CommentDate] [datetime] NOT NULL, [CommentIsDeleted] [bit] NULL, [CommentUserId] [bigint] NOT NULL, [CommentBookId] [bigint] NOT NULL, CONSTRAINT [PK_Comment] PRIMARY KEY CLUSTERED ( [CommentId] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]ENDGOSET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOIF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[OrderDetail]') AND type in (N'U'))BEGINCREATE TABLE [dbo].[OrderDetail]( [OrderDetailId] [bigint] IDENTITY(1,1) NOT NULL, [OrderId] [bigint] NOT NULL, [OrderUserId] [bigint] NOT NULL, [OrderBookId] [bigint] NOT NULL, CONSTRAINT [PK_OrderDetail] PRIMARY KEY CLUSTERED ( [OrderDetailId] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]ENDGOSET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOIF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Order]') AND type in (N'U'))BEGINCREATE TABLE [dbo].[Order]( [OrderId] [bigint] IDENTITY(1,1) NOT NULL, [OrderDate] [datetime] NOT NULL, [OrderStatus] [nvarchar](50) NOT NULL, [OrderUserId] [bigint] NOT NULL, [OrderIsDeleted] [bit] NULL, CONSTRAINT [PK_Order] PRIMARY KEY CLUSTERED ( [OrderId] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]ENDGOIF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Author_Author]') AND parent_object_id = OBJECT_ID(N'[dbo].[Author]'))ALTER TABLE [dbo].[Author] WITH CHECK ADD CONSTRAINT [FK_Author_Author] FOREIGN KEY([AuthorId])REFERENCES [dbo].[Author] ([AuthorId])GOALTER TABLE [dbo].[Author] CHECK CONSTRAINT [FK_Author_Author]GOIF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Book_Author]') AND parent_object_id = OBJECT_ID(N'[dbo].[Book]'))ALTER TABLE [dbo].[Book] WITH CHECK ADD CONSTRAINT [FK_Book_Author] FOREIGN KEY([BookAuthor])REFERENCES [dbo].[Author] ([AuthorId])GOALTER TABLE [dbo].[Book] CHECK CONSTRAINT [FK_Book_Author]GOIF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Book_Category]') AND parent_object_id = OBJECT_ID(N'[dbo].[Book]'))ALTER TABLE [dbo].[Book] WITH CHECK ADD CONSTRAINT [FK_Book_Category] FOREIGN KEY([BookCategoryId])REFERENCES [dbo].[Category] ([CategoryId])GOALTER TABLE [dbo].[Book] CHECK CONSTRAINT [FK_Book_Category]GOIF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Comment_Book]') AND parent_object_id = OBJECT_ID(N'[dbo].[Comment]'))ALTER TABLE [dbo].[Comment] WITH CHECK ADD CONSTRAINT [FK_Comment_Book] FOREIGN KEY([CommentBookId])REFERENCES [dbo].[Book] ([BookId])GOALTER TABLE [dbo].[Comment] CHECK CONSTRAINT [FK_Comment_Book]GOIF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Comment_User]') AND parent_object_id = OBJECT_ID(N'[dbo].[Comment]'))ALTER TABLE [dbo].[Comment] WITH CHECK ADD CONSTRAINT [FK_Comment_User] FOREIGN KEY([CommentUserId])REFERENCES [dbo].[User] ([UserId])GOALTER TABLE [dbo].[Comment] CHECK CONSTRAINT [FK_Comment_User]GOIF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_OrderDetail_Book]') AND parent_object_id = OBJECT_ID(N'[dbo].[OrderDetail]'))ALTER TABLE [dbo].[OrderDetail] WITH CHECK ADD CONSTRAINT [FK_OrderDetail_Book] FOREIGN KEY([OrderBookId])REFERENCES [dbo].[Book] ([BookId])GOALTER TABLE [dbo].[OrderDetail] CHECK CONSTRAINT [FK_OrderDetail_Book]GOIF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_OrderDetail_Orde]') AND parent_object_id = OBJECT_ID(N'[dbo].[OrderDetail]'))ALTER TABLE [dbo].[OrderDetail] WITH CHECK ADD CONSTRAINT [FK_OrderDetail_Orde] FOREIGN KEY([OrderId])REFERENCES [dbo].[Order] ([OrderId])GOALTER TABLE [dbo].[OrderDetail] CHECK CONSTRAINT [FK_OrderDetail_Orde]GOIF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_OrderDetail_User]') AND parent_object_id = OBJECT_ID(N'[dbo].[OrderDetail]'))ALTER TABLE [dbo].[OrderDetail] WITH CHECK ADD CONSTRAINT [FK_OrderDetail_User] FOREIGN KEY([OrderUserId])REFERENCES [dbo].[User] ([UserId])GOALTER TABLE [dbo].[OrderDetail] CHECK CONSTRAINT [FK_OrderDetail_User]GOIF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Order_User]') AND parent_object_id = OBJECT_ID(N'[dbo].[Order]'))ALTER TABLE [dbo].[Order] WITH CHECK ADD CONSTRAINT [FK_Order_User] FOREIGN KEY([OrderUserId])REFERENCES [dbo].[User] ([UserId])GOALTER TABLE [dbo].[Order] CHECK CONSTRAINT [FK_Order_User]或者在此下载数据库的备份http://www.cnblogs.com/Files/cnblogsfans/BookShop.rar
赞